Symfony Profiler

Query Metrics

23 Database Queries

8 Different statements

15.59 ms Query time

1 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.64 ms
(36.17%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content AS content_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.status AS status_7, t0.tags AS tags_8, t0.photo AS photo_9, t0.type AS type_10, t0.updated_at AS updated_at_11, t0.published_date AS published_date_12, t0.view AS view_13, t0.old_id AS old_id_14, t0.photo_alt AS photo_alt_15, t0.faq_id AS faq_id_16 FROM posts t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "blabla test"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.content AS content_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.status AS status_7,
  t0.tags AS tags_8,
  t0.photo AS photo_9,
  t0.type AS type_10,
  t0.updated_at AS updated_at_11,
  t0.published_date AS published_date_12,
  t0.view AS view_13,
  t0.old_id AS old_id_14,
  t0.photo_alt AS photo_alt_15,
  t0.faq_id AS faq_id_16
FROM
  posts t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content AS content_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.status AS status_7, t0.tags AS tags_8, t0.photo AS photo_9, t0.type AS type_10, t0.updated_at AS updated_at_11, t0.published_date AS published_date_12, t0.view AS view_13, t0.old_id AS old_id_14, t0.photo_alt AS photo_alt_15, t0.faq_id AS faq_id_16 FROM posts t0 WHERE t0.slug = 'blabla test' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

2.96 ms
(19.00%)

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.status AS status_2, f0_.created_at AS created_at_3, f0_.updated_at AS updated_at_4 FROM faq f0_ INNER JOIN posts p1_ ON f0_.id = p1_.faq_id INNER JOIN faq_items f2_ ON f0_.id = f2_.faq_id WHERE f2_.status = ? AND p1_.status = ? AND p1_.id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.status AS status_2,
  f0_.created_at AS created_at_3,
  f0_.updated_at AS updated_at_4
FROM
  faq f0_
  INNER JOIN posts p1_ ON f0_.id = p1_.faq_id
  INNER JOIN faq_items f2_ ON f0_.id = f2_.faq_id
WHERE
  f2_.status = ?
  AND p1_.status = ?
  AND p1_.id = ?

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.status AS status_2, f0_.created_at AS created_at_3, f0_.updated_at AS updated_at_4 FROM faq f0_ INNER JOIN posts p1_ ON f0_.id = p1_.faq_id INNER JOIN faq_items f2_ ON f0_.id = f2_.faq_id WHERE f2_.status = 1 AND p1_.status = 1 AND p1_.id = 1636;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Service\PostService->faq (line 212)
7	App\Twig\Post->get_post_faq (line 44)
8	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->{closure:__TwigTemplate_25628cd6322ed681c5515ac5db74eafe::macro_render():202} (line 254)
9	Twig\Extension\CoreExtension->captureOutput (line 2106)
10	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe::macro_render (line 202)
11	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->block_content (line 91)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\FrontPage\PostController->single (line 135)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

2.56 ms
(16.40%)

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.object AS object_3, t0.page_title AS page_title_4, t0.page_description AS page_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.object_id AS object_id_10 FROM seo t0 WHERE t0.object = ? AND t0.object_id = ? LIMIT 1

Parameters:

[
  "App\Entity\Posts"
  1636
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.route_name AS route_name_2,
  t0.object AS object_3,
  t0.page_title AS page_title_4,
  t0.page_description AS page_description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.keywords AS keywords_8,
  t0.image AS image_9,
  t0.object_id AS object_id_10
FROM
  seo t0
WHERE
  t0.object = ?
  AND t0.object_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.object AS object_3, t0.page_title AS page_title_4, t0.page_description AS page_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.object_id AS object_id_10 FROM seo t0 WHERE t0.object = 'App\\Entity\\Posts' AND t0.object_id = 1636 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Twig\SiteOptions->getSiteSEO (line 86)
5	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 70)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->doDisplay (line 55)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
16	App\Controller\FrontPage\PostController->single (line 135)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

2.19 ms
(14.05%)

SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1

Parameters:

[
  "id_page_pc"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.config_name AS config_name_2,
  t0.config_value AS config_value_3
FROM
  site_configuration t0
WHERE
  t0.config_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = 'id_page_pc' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Twig\SiteOptions->getSiteOptions (line 59)
5	__TwigTemplate_e9380e153abbc91009a3b5ec0df8dd03->doDisplay (line 54)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 87)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
18	App\Controller\FrontPage\PostController->single (line 135)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

1.24 ms
(7.98%)

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.description AS description_2, f0_.echelle AS echelle_3, f0_.date_sortie AS date_sortie_4, f0_.date_reedition AS date_reedition_5, f0_.dimension AS dimension_6, f0_.status AS status_7, f0_.price AS price_8, f0_.price_yen AS price_yen_9, f0_.tags AS tags_10, f0_.photo_cover AS photo_cover_11, f0_.photo_thumbnail AS photo_thumbnail_12, f0_.created_at AS created_at_13, f0_.updated_at AS updated_at_14, f0_.slug AS slug_15, f0_.old_id AS old_id_16, f0_.other_price AS other_price_17, f0_.photo_alt AS photo_alt_18, f0_.miniature_alt AS miniature_alt_19, f0_.view AS view_20, f0_.figurine_gammes_id AS figurine_gammes_id_21, f0_.figurine_fabriquant_id AS figurine_fabriquant_id_22, f0_.serie_id AS serie_id_23, f0_.personnage_id AS personnage_id_24 FROM figurine f0_ INNER JOIN figurine_posts f2_ ON f0_.id = f2_.figurine_id INNER JOIN posts p1_ ON p1_.id = f2_.posts_id WHERE p1_.id = ? ORDER BY f0_.date_sortie DESC LIMIT 4

Parameters:

[
  1636
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nom AS nom_1,
  f0_.description AS description_2,
  f0_.echelle AS echelle_3,
  f0_.date_sortie AS date_sortie_4,
  f0_.date_reedition AS date_reedition_5,
  f0_.dimension AS dimension_6,
  f0_.status AS status_7,
  f0_.price AS price_8,
  f0_.price_yen AS price_yen_9,
  f0_.tags AS tags_10,
  f0_.photo_cover AS photo_cover_11,
  f0_.photo_thumbnail AS photo_thumbnail_12,
  f0_.created_at AS created_at_13,
  f0_.updated_at AS updated_at_14,
  f0_.slug AS slug_15,
  f0_.old_id AS old_id_16,
  f0_.other_price AS other_price_17,
  f0_.photo_alt AS photo_alt_18,
  f0_.miniature_alt AS miniature_alt_19,
  f0_.view AS view_20,
  f0_.figurine_gammes_id AS figurine_gammes_id_21,
  f0_.figurine_fabriquant_id AS figurine_fabriquant_id_22,
  f0_.serie_id AS serie_id_23,
  f0_.personnage_id AS personnage_id_24
FROM
  figurine f0_
  INNER JOIN figurine_posts f2_ ON f0_.id = f2_.figurine_id
  INNER JOIN posts p1_ ON p1_.id = f2_.posts_id
WHERE
  p1_.id = ?
ORDER BY
  f0_.date_sortie DESC
LIMIT
  4

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.description AS description_2, f0_.echelle AS echelle_3, f0_.date_sortie AS date_sortie_4, f0_.date_reedition AS date_reedition_5, f0_.dimension AS dimension_6, f0_.status AS status_7, f0_.price AS price_8, f0_.price_yen AS price_yen_9, f0_.tags AS tags_10, f0_.photo_cover AS photo_cover_11, f0_.photo_thumbnail AS photo_thumbnail_12, f0_.created_at AS created_at_13, f0_.updated_at AS updated_at_14, f0_.slug AS slug_15, f0_.old_id AS old_id_16, f0_.other_price AS other_price_17, f0_.photo_alt AS photo_alt_18, f0_.miniature_alt AS miniature_alt_19, f0_.view AS view_20, f0_.figurine_gammes_id AS figurine_gammes_id_21, f0_.figurine_fabriquant_id AS figurine_fabriquant_id_22, f0_.serie_id AS serie_id_23, f0_.personnage_id AS personnage_id_24 FROM figurine f0_ INNER JOIN figurine_posts f2_ ON f0_.id = f2_.figurine_id INNER JOIN posts p1_ ON p1_.id = f2_.posts_id WHERE p1_.id = 1636 ORDER BY f0_.date_sortie DESC LIMIT 4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Service\PostService->get_related_figurines (line 181)
7	App\Twig\Post->get_related_figurines (line 37)
8	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->{closure:__TwigTemplate_25628cd6322ed681c5515ac5db74eafe::macro_render():202} (line 332)
9	Twig\Extension\CoreExtension->captureOutput (line 2106)
10	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe::macro_render (line 202)
11	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->block_content (line 91)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\FrontPage\PostController->single (line 135)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.42 ms
(2.70%)

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.createdt_at AS createdt_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.faq_id AS faq_id_7 FROM faq_items t0 WHERE t0.faq_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.answer AS answer_3,
  t0.createdt_at AS createdt_at_4,
  t0.updated_at AS updated_at_5,
  t0.status AS status_6,
  t0.faq_id AS faq_id_7
FROM
  faq_items t0
WHERE
  t0.faq_id = ?

SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.createdt_at AS createdt_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.faq_id AS faq_id_7 FROM faq_items t0 WHERE t0.faq_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_17245e1672fa37a5289f2fc815d86d6f->doDisplay (line 79)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	App\Service\PostService->faq (line 215)
15	App\Twig\Post->get_post_faq (line 44)
16	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->{closure:__TwigTemplate_25628cd6322ed681c5515ac5db74eafe::macro_render():202} (line 254)
17	Twig\Extension\CoreExtension->captureOutput (line 2106)
18	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe::macro_render (line 202)
19	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->block_content (line 91)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->doDisplay (line 55)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
32	App\Controller\FrontPage\PostController->single (line 135)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 182)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

0.36 ms
(2.31%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.status AS status_8 FROM page t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.content AS content_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.status AS status_8
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.status AS status_8 FROM page t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Twig\Common->build_page_url (line 131)
7	__TwigTemplate_e9380e153abbc91009a3b5ec0df8dd03->doDisplay (line 54)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 87)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\FrontPage\PostController->single (line 135)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.22 ms
(1.39%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.link AS link_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM annonces t0 WHERE t0.status = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.link AS link_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  annonces t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.link AS link_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM annonces t0 WHERE t0.status = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\Common->annonce (line 206)
5	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 97)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_25628cd6322ed681c5515ac5db74eafe->doDisplay (line 55)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
16	App\Controller\FrontPage\PostController->single (line 135)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\SiteConfiguration	11
App\Entity\Page	2
App\Entity\FaqItems	2
App\Entity\Posts	1
App\Entity\Faq	1
App\Entity\SEO	1
App\Entity\Annonces	1

Entities Mapping

Class	Mapping errors
App\Entity\Posts	No errors.
App\Entity\Faq	No errors.
App\Entity\Categories	No errors.
App\Entity\PostTag	No errors.
App\Entity\Figurine	The association App\Entity\Figurine#peintre refers to the inverse side field App\Entity\FigurinePeintre#figurines which does not exist. The association App\Entity\Figurine#sculpteur refers to the inverse side field App\Entity\FigurineSculpteur#figurines which does not exist.
App\Entity\FigurineSerie	No errors.
App\Entity\FigurineFabriquant	No errors.
App\Entity\FigurineGammes	No errors.
App\Entity\Personnage	No errors.
App\Entity\SEO	No errors.
App\Entity\SiteConfiguration	No errors.
App\Entity\Page	No errors.
App\Entity\Annonces	No errors.
App\Entity\FaqItems	No errors.

Symfony Profiler

GET https://figurine-actus.ethiko.io/article/blabla%20test

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping