Symfony Profiler

Query Metrics

83 Database Queries

18 Different statements

37.29 ms Query time

4 Invalid entities

3832 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.10 ms
(43.18%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.echelle AS echelle_4, t0.date_sortie AS date_sortie_5, t0.date_reedition AS date_reedition_6, t0.dimension AS dimension_7, t0.status AS status_8, t0.price AS price_9, t0.price_yen AS price_yen_10, t0.tags AS tags_11, t0.photo_cover AS photo_cover_12, t0.photo_thumbnail AS photo_thumbnail_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.slug AS slug_16, t0.old_id AS old_id_17, t0.other_price AS other_price_18, t0.photo_alt AS photo_alt_19, t0.miniature_alt AS miniature_alt_20, t0.view AS view_21, t0.figurine_gammes_id AS figurine_gammes_id_22, t0.figurine_fabriquant_id AS figurine_fabriquant_id_23, t0.serie_id AS serie_id_24, t0.personnage_id AS personnage_id_25 FROM figurine t0 WHERE t0.status = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.echelle AS echelle_4,
  t0.date_sortie AS date_sortie_5,
  t0.date_reedition AS date_reedition_6,
  t0.dimension AS dimension_7,
  t0.status AS status_8,
  t0.price AS price_9,
  t0.price_yen AS price_yen_10,
  t0.tags AS tags_11,
  t0.photo_cover AS photo_cover_12,
  t0.photo_thumbnail AS photo_thumbnail_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.slug AS slug_16,
  t0.old_id AS old_id_17,
  t0.other_price AS other_price_18,
  t0.photo_alt AS photo_alt_19,
  t0.miniature_alt AS miniature_alt_20,
  t0.view AS view_21,
  t0.figurine_gammes_id AS figurine_gammes_id_22,
  t0.figurine_fabriquant_id AS figurine_fabriquant_id_23,
  t0.serie_id AS serie_id_24,
  t0.personnage_id AS personnage_id_25
FROM
  figurine t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.echelle AS echelle_4, t0.date_sortie AS date_sortie_5, t0.date_reedition AS date_reedition_6, t0.dimension AS dimension_7, t0.status AS status_8, t0.price AS price_9, t0.price_yen AS price_yen_10, t0.tags AS tags_11, t0.photo_cover AS photo_cover_12, t0.photo_thumbnail AS photo_thumbnail_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.slug AS slug_16, t0.old_id AS old_id_17, t0.other_price AS other_price_18, t0.photo_alt AS photo_alt_19, t0.miniature_alt AS miniature_alt_20, t0.view AS view_21, t0.figurine_gammes_id AS figurine_gammes_id_22, t0.figurine_fabriquant_id AS figurine_fabriquant_id_23, t0.serie_id AS serie_id_24, t0.personnage_id AS personnage_id_25 FROM figurine 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\Figurine->getFigurineBddCount (line 181)
5	App\Twig\Figurine->figurineCount (line 154)
6	__TwigTemplate_6d307244a98eac444b7b8d7b21b35567->doDisplay (line 70)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 86)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
21	App\Controller\FrontPage\HomeController->index (line 97)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

3.22 ms
(8.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM figurine_materiaux t0 INNER JOIN figurine_materiaux_figurine ON t0.id = figurine_materiaux_figurine.figurine_materiaux_id WHERE figurine_materiaux_figurine.figurine_id = ?

Parameters:

[
  2336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  figurine_materiaux t0
  INNER JOIN figurine_materiaux_figurine ON t0.id = figurine_materiaux_figurine.figurine_materiaux_id
WHERE
  figurine_materiaux_figurine.figurine_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM figurine_materiaux t0 INNER JOIN figurine_materiaux_figurine ON t0.id = figurine_materiaux_figurine.figurine_materiaux_id WHERE figurine_materiaux_figurine.figurine_id = 2336;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Twig\Figurine->getMateriaux (line 124)
8	__TwigTemplate_2faae208fb489bc8379b2963d1d7f79b->doDisplay (line 162)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 89)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\FrontPage\HomeController->index (line 97)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

3.20 ms
(8.58%)

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_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
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\HomeController->index (line 97)
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)

2.77 ms
(7.42%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM figurine_sculpteur t0 INNER JOIN figurine_figurine_sculpteur ON t0.id = figurine_figurine_sculpteur.figurine_sculpteur_id WHERE figurine_figurine_sculpteur.figurine_id = ?

Parameters:

[
  2336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.firstname AS firstname_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  figurine_sculpteur t0
  INNER JOIN figurine_figurine_sculpteur ON t0.id = figurine_figurine_sculpteur.figurine_sculpteur_id
WHERE
  figurine_figurine_sculpteur.figurine_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM figurine_sculpteur t0 INNER JOIN figurine_figurine_sculpteur ON t0.id = figurine_figurine_sculpteur.figurine_sculpteur_id WHERE figurine_figurine_sculpteur.figurine_id = 2336;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Twig\Figurine->getSculpteur (line 86)
8	__TwigTemplate_2faae208fb489bc8379b2963d1d7f79b->doDisplay (line 182)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 89)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\FrontPage\HomeController->index (line 97)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

2.73 ms
(7.32%)

SELECT t0.id AS id_1, t0.alt AS alt_2, t0.photo AS photo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.old_data AS old_data_7, t0.figurine_id AS figurine_id_8 FROM figurine_photos t0 WHERE t0.figurine_id = ?

Parameters:

[
  2336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.alt AS alt_2,
  t0.photo AS photo_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.position AS position_6,
  t0.old_data AS old_data_7,
  t0.figurine_id AS figurine_id_8
FROM
  figurine_photos t0
WHERE
  t0.figurine_id = ?

SELECT t0.id AS id_1, t0.alt AS alt_2, t0.photo AS photo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.old_data AS old_data_7, t0.figurine_id AS figurine_id_8 FROM figurine_photos t0 WHERE t0.figurine_id = 2336;

#	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	sizeof (line 94)
9	App\Service\FigurineService::getHomeSlidePhoto (line 94)
10	App\Twig\Figurine->getHomeSlidePhoto (line 62)
11	__TwigTemplate_2faae208fb489bc8379b2963d1d7f79b->doDisplay (line 90)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 89)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	App\Controller\FrontPage\HomeController->index (line 97)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

2.09 ms
(5.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM figurine_peintre t0 INNER JOIN figurine_figurine_peintre ON t0.id = figurine_figurine_peintre.figurine_peintre_id WHERE figurine_figurine_peintre.figurine_id = ?

Parameters:

[
  2336
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.firstname AS firstname_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  figurine_peintre t0
  INNER JOIN figurine_figurine_peintre ON t0.id = figurine_figurine_peintre.figurine_peintre_id
WHERE
  figurine_figurine_peintre.figurine_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM figurine_peintre t0 INNER JOIN figurine_figurine_peintre ON t0.id = figurine_figurine_peintre.figurine_peintre_id WHERE figurine_figurine_peintre.figurine_id = 2336;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Twig\Figurine->getPeintre (line 70)
8	__TwigTemplate_2faae208fb489bc8379b2963d1d7f79b->doDisplay (line 190)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 89)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\FrontPage\HomeController->index (line 97)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.08 ms
(2.89%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_japonais AS nom_japonais_3, t0.description AS description_4, t0.twitter AS twitter_5, t0.site AS site_6, t0.libellestreaming AS libellestreaming_7, t0.liensstreaming AS liensstreaming_8, t0.photo AS photo_9, t0.slug AS slug_10, t0.old_id AS old_id_11, t0.photo_alt AS photo_alt_12, t0.studio_editeur AS studio_editeur_13, t0.editeur AS editeur_14, t0.editeur_jp AS editeur_jp_15, t0.date_debut AS date_debut_16, t0.date_fin AS date_fin_17, t0.nombre_de_saison AS nombre_de_saison_18, t0.about AS about_19, t0.autre_appellation AS autre_appellation_20, t0.membre_id AS membre_id_21 FROM figurine_serie t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_japonais AS nom_japonais_3,
  t0.description AS description_4,
  t0.twitter AS twitter_5,
  t0.site AS site_6,
  t0.libellestreaming AS libellestreaming_7,
  t0.liensstreaming AS liensstreaming_8,
  t0.photo AS photo_9,
  t0.slug AS slug_10,
  t0.old_id AS old_id_11,
  t0.photo_alt AS photo_alt_12,
  t0.studio_editeur AS studio_editeur_13,
  t0.editeur AS editeur_14,
  t0.editeur_jp AS editeur_jp_15,
  t0.date_debut AS date_debut_16,
  t0.date_fin AS date_fin_17,
  t0.nombre_de_saison AS nombre_de_saison_18,
  t0.about AS about_19,
  t0.autre_appellation AS autre_appellation_20,
  t0.membre_id AS membre_id_21
FROM
  figurine_serie t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_japonais AS nom_japonais_3, t0.description AS description_4, t0.twitter AS twitter_5, t0.site AS site_6, t0.libellestreaming AS libellestreaming_7, t0.liensstreaming AS liensstreaming_8, t0.photo AS photo_9, t0.slug AS slug_10, t0.old_id AS old_id_11, t0.photo_alt AS photo_alt_12, t0.studio_editeur AS studio_editeur_13, t0.editeur AS editeur_14, t0.editeur_jp AS editeur_jp_15, t0.date_debut AS date_debut_16, t0.date_fin AS date_fin_17, t0.nombre_de_saison AS nombre_de_saison_18, t0.about AS about_19, t0.autre_appellation AS autre_appellation_20, t0.membre_id AS membre_id_21 FROM figurine_serie t0;

#	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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\Figurine->getFigurineBddLicenseCount (line 197)
6	App\Twig\Figurine->figurineCount (line 168)
7	__TwigTemplate_6d307244a98eac444b7b8d7b21b35567->doDisplay (line 155)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 86)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\FrontPage\HomeController->index (line 97)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.83 ms
(2.23%)

SELECT t0.id AS id_1, t0.page AS page_2, t0.alt AS alt_3, t0.photo AS photo_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM slider_hero t0 WHERE t0.page = ?

Parameters:

[
  "front.app.home.index"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.page AS page_2,
  t0.alt AS alt_3,
  t0.photo AS photo_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  slider_hero t0
WHERE
  t0.page = ?

SELECT t0.id AS id_1, t0.page AS page_2, t0.alt AS alt_3, t0.photo AS photo_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM slider_hero t0 WHERE t0.page = 'front.app.home.index';

#	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\Service\SliderHeroService->get_hero_page (line 23)
5	App\Controller\FrontPage\HomeController->index (line 66)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.75 ms
(2.01%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.localisation AS localisation_3, t0.url AS url_4, t0.photo AS photo_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.old_id AS old_id_9, t0.pays AS pays_10, t0.photo_alt AS photo_alt_11, t0.description AS description_12 FROM figurine_boutique t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.localisation AS localisation_3,
  t0.url AS url_4,
  t0.photo AS photo_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.old_id AS old_id_9,
  t0.pays AS pays_10,
  t0.photo_alt AS photo_alt_11,
  t0.description AS description_12
FROM
  figurine_boutique t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.localisation AS localisation_3, t0.url AS url_4, t0.photo AS photo_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.old_id AS old_id_9, t0.pays AS pays_10, t0.photo_alt AS photo_alt_11, t0.description AS description_12 FROM figurine_boutique t0;

#	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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\Figurine->getFigurineBddBoutiqueCount (line 201)
6	App\Twig\Figurine->figurineCount (line 166)
7	__TwigTemplate_6d307244a98eac444b7b8d7b21b35567->doDisplay (line 104)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 86)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\FrontPage\HomeController->index (line 97)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.72 ms
(1.93%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.content AS content_3, p0_.slug AS slug_4, p0_.created_at AS created_at_5, p0_.status AS status_6, p0_.tags AS tags_7, p0_.photo AS photo_8, p0_.type AS type_9, p0_.updated_at AS updated_at_10, p0_.published_date AS published_date_11, p0_.view AS view_12, p0_.old_id AS old_id_13, p0_.photo_alt AS photo_alt_14, p0_.faq_id AS faq_id_15 FROM posts p0_ WHERE p0_.status = ? ORDER BY p0_.published_date DESC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.content AS content_3,
  p0_.slug AS slug_4,
  p0_.created_at AS created_at_5,
  p0_.status AS status_6,
  p0_.tags AS tags_7,
  p0_.photo AS photo_8,
  p0_.type AS type_9,
  p0_.updated_at AS updated_at_10,
  p0_.published_date AS published_date_11,
  p0_.view AS view_12,
  p0_.old_id AS old_id_13,
  p0_.photo_alt AS photo_alt_14,
  p0_.faq_id AS faq_id_15
FROM
  posts p0_
WHERE
  p0_.status = ?
ORDER BY
  p0_.published_date DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.content AS content_3, p0_.slug AS slug_4, p0_.created_at AS created_at_5, p0_.status AS status_6, p0_.tags AS tags_7, p0_.photo AS photo_8, p0_.type AS type_9, p0_.updated_at AS updated_at_10, p0_.published_date AS published_date_11, p0_.view AS view_12, p0_.old_id AS old_id_13, p0_.photo_alt AS photo_alt_14, p0_.faq_id AS faq_id_15 FROM posts p0_ WHERE p0_.status = 1 ORDER BY p0_.published_date DESC LIMIT 3;

#	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\Controller\FrontPage\HomeController->index (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.65 ms
(1.75%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.autre_appelation AS autre_appelation_3, t0.dob AS dob_4, t0.taille AS taille_5, t0.doubleur AS doubleur_6, t0.trait_physique AS trait_physique_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.nom_japonais AS nom_japonais_10, t0.annivaersaire AS annivaersaire_11, t0.slug AS slug_12, t0.photo AS photo_13, t0.old_id AS old_id_14, t0.description AS description_15, t0.photo_alt AS photo_alt_16, t0.genre AS genre_17, t0.tags AS tags_18, t0.date_naissance AS date_naissance_19, t0.license_personnage_id AS license_personnage_id_20, t0.genre_personnage_id AS genre_personnage_id_21, t0.serie_id AS serie_id_22 FROM personnage t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.autre_appelation AS autre_appelation_3,
  t0.dob AS dob_4,
  t0.taille AS taille_5,
  t0.doubleur AS doubleur_6,
  t0.trait_physique AS trait_physique_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.nom_japonais AS nom_japonais_10,
  t0.annivaersaire AS annivaersaire_11,
  t0.slug AS slug_12,
  t0.photo AS photo_13,
  t0.old_id AS old_id_14,
  t0.description AS description_15,
  t0.photo_alt AS photo_alt_16,
  t0.genre AS genre_17,
  t0.tags AS tags_18,
  t0.date_naissance AS date_naissance_19,
  t0.license_personnage_id AS license_personnage_id_20,
  t0.genre_personnage_id AS genre_personnage_id_21,
  t0.serie_id AS serie_id_22
FROM
  personnage t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.autre_appelation AS autre_appelation_3, t0.dob AS dob_4, t0.taille AS taille_5, t0.doubleur AS doubleur_6, t0.trait_physique AS trait_physique_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.nom_japonais AS nom_japonais_10, t0.annivaersaire AS annivaersaire_11, t0.slug AS slug_12, t0.photo AS photo_13, t0.old_id AS old_id_14, t0.description AS description_15, t0.photo_alt AS photo_alt_16, t0.genre AS genre_17, t0.tags AS tags_18, t0.date_naissance AS date_naissance_19, t0.license_personnage_id AS license_personnage_id_20, t0.genre_personnage_id AS genre_personnage_id_21, t0.serie_id AS serie_id_22 FROM personnage t0;

#	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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\Figurine->getFigurineBddPersonnageCount (line 193)
6	App\Twig\Figurine->figurineCount (line 163)
7	__TwigTemplate_6d307244a98eac444b7b8d7b21b35567->doDisplay (line 138)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 86)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\FrontPage\HomeController->index (line 97)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.58 ms
(1.56%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adress AS adress_3, t0.photo AS photo_4, t0.description AS description_5, t0.status AS status_6, t0.type AS type_7, t0.date_creation AS date_creation_8, t0.nom_japonais AS nom_japonais_9, t0.twitter AS twitter_10, t0.site AS site_11, t0.pays AS pays_12, t0.old_id AS old_id_13, t0.photo_alt AS photo_alt_14, t0.slug AS slug_15, t0.autre_appellation AS autre_appellation_16, t0.localisation_id AS localisation_id_17, t0.membre_id AS membre_id_18 FROM figurine_fabriquant t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adress AS adress_3,
  t0.photo AS photo_4,
  t0.description AS description_5,
  t0.status AS status_6,
  t0.type AS type_7,
  t0.date_creation AS date_creation_8,
  t0.nom_japonais AS nom_japonais_9,
  t0.twitter AS twitter_10,
  t0.site AS site_11,
  t0.pays AS pays_12,
  t0.old_id AS old_id_13,
  t0.photo_alt AS photo_alt_14,
  t0.slug AS slug_15,
  t0.autre_appellation AS autre_appellation_16,
  t0.localisation_id AS localisation_id_17,
  t0.membre_id AS membre_id_18
FROM
  figurine_fabriquant t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adress AS adress_3, t0.photo AS photo_4, t0.description AS description_5, t0.status AS status_6, t0.type AS type_7, t0.date_creation AS date_creation_8, t0.nom_japonais AS nom_japonais_9, t0.twitter AS twitter_10, t0.site AS site_11, t0.pays AS pays_12, t0.old_id AS old_id_13, t0.photo_alt AS photo_alt_14, t0.slug AS slug_15, t0.autre_appellation AS autre_appellation_16, t0.localisation_id AS localisation_id_17, t0.membre_id AS membre_id_18 FROM figurine_fabriquant t0;

#	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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\Figurine->getFigurineBddFabriquantCount (line 189)
6	App\Twig\Figurine->figurineCount (line 157)
7	__TwigTemplate_6d307244a98eac444b7b8d7b21b35567->doDisplay (line 121)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 86)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\FrontPage\HomeController->index (line 97)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.56 ms
(1.49%)

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.route_name = ? LIMIT 1

Parameters:

[
  "front.app.home.index"
]

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.route_name = ?
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.route_name = 'front.app.home.index' 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 101)
5	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 70)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
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\HomeController->index (line 97)
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)

0.51 ms
(1.36%)

SELECT t0.id AS id_1, t0.photo AS photo_2, t0.nom AS nom_3, t0.taille_moyenne AS taille_moyenne_4, t0.gamme_prix AS gamme_prix_5, t0.site AS site_6, t0.pays AS pays_7, t0.slug AS slug_8, t0.nom_japonais AS nom_japonais_9, t0.old_id AS old_id_10, t0.description AS description_11, t0.photo_alt AS photo_alt_12, t0.date_add AS date_add_13, t0.autre_appellation AS autre_appellation_14, t0.website AS website_15, t0.style_id AS style_id_16, t0.membre_id AS membre_id_17 FROM figurine_gammes t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.photo AS photo_2,
  t0.nom AS nom_3,
  t0.taille_moyenne AS taille_moyenne_4,
  t0.gamme_prix AS gamme_prix_5,
  t0.site AS site_6,
  t0.pays AS pays_7,
  t0.slug AS slug_8,
  t0.nom_japonais AS nom_japonais_9,
  t0.old_id AS old_id_10,
  t0.description AS description_11,
  t0.photo_alt AS photo_alt_12,
  t0.date_add AS date_add_13,
  t0.autre_appellation AS autre_appellation_14,
  t0.website AS website_15,
  t0.style_id AS style_id_16,
  t0.membre_id AS membre_id_17
FROM
  figurine_gammes t0

SELECT t0.id AS id_1, t0.photo AS photo_2, t0.nom AS nom_3, t0.taille_moyenne AS taille_moyenne_4, t0.gamme_prix AS gamme_prix_5, t0.site AS site_6, t0.pays AS pays_7, t0.slug AS slug_8, t0.nom_japonais AS nom_japonais_9, t0.old_id AS old_id_10, t0.description AS description_11, t0.photo_alt AS photo_alt_12, t0.date_add AS date_add_13, t0.autre_appellation AS autre_appellation_14, t0.website AS website_15, t0.style_id AS style_id_16, t0.membre_id AS membre_id_17 FROM figurine_gammes t0;

#	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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\Figurine->getFigurineBddGammesCount (line 185)
6	App\Twig\Figurine->figurineCount (line 160)
7	__TwigTemplate_6d307244a98eac444b7b8d7b21b35567->doDisplay (line 87)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->block_content (line 86)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_9726f04b13ecfd907582128d55139e34->doDisplay (line 107)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\FrontPage\HomeController->index (line 97)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.46 ms
(1.23%)

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_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
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\HomeController->index (line 97)
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.44 ms
(1.19%)

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_ WHERE f0_.status = ? ORDER BY f0_.date_sortie DESC LIMIT 12

Parameters:

[
  1
]

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_
WHERE
  f0_.status = ?
ORDER BY
  f0_.date_sortie DESC
LIMIT
  12

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_ WHERE f0_.status = 1 ORDER BY f0_.date_sortie DESC LIMIT 12;

#	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\Controller\FrontPage\HomeController->index (line 93)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.34 ms
(0.91%)

SELECT DISTINCT YEAR(f0_.date_sortie) AS sclr_0 FROM figurine f0_ ORDER BY sclr_0 DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT YEAR(f0_.date_sortie) AS sclr_0
FROM
  figurine f0_
ORDER BY
  sclr_0 DESC

SELECT DISTINCT YEAR(f0_.date_sortie) AS sclr_0 FROM figurine f0_ ORDER BY sclr_0 DESC;

#	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->getScalarResult (line 725)
6	App\Service\FigurineService->available_date_sortie (line 328)
7	App\Controller\FrontPage\HomeController->index (line 95)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

0.26 ms
(0.69%)

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_db49b173deed1690bf72e1c211ad1164->doDisplay (line 54)
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\HomeController->index (line 97)
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\Figurine	2273
App\Entity\Personnage	970
App\Entity\FigurineSerie	286
App\Entity\FigurinePhotos	131
App\Entity\FigurineFabriquant	63
App\Entity\FigurineBoutique	29
App\Entity\FigurineGammes	28
App\Entity\SiteConfiguration	12
App\Entity\FigurineSculpteur	11
App\Entity\FigurinePeintre	11
App\Entity\Posts	3
App\Entity\TypeGamme	3
App\Entity\Page	2
App\Entity\Membre	2
App\Entity\LocalisationFabricant	2
App\Entity\FigurineMateriaux	2
App\Entity\SliderHero	1
App\Entity\Faq	1
App\Entity\SEO	1
App\Entity\Annonces	1

Entities Mapping

Class	Mapping errors
App\Entity\SliderHero	No 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\FigurinePhotos	No errors.
App\Entity\FigurineMateriaux	No errors.
App\Entity\FigurineSerieLicence	No errors.
App\Entity\FigurineBoutiqueFigurine	No errors.
App\Entity\FigurinePeintre	The association App\Entity\FigurinePeintre#figurine refers to the owning side field App\Entity\Figurine#figurinePeintre which does not exist.
App\Entity\FigurineSculpteur	The association App\Entity\FigurineSculpteur#figurine refers to the owning side field App\Entity\Figurine#figurineSculpteur which does not exist.
App\Entity\FigurineIllustrator	No errors.
App\Entity\FigurineCategories	No errors.
App\Entity\MembreCollection	No errors.
App\Entity\MembreWishlist	No errors.
App\Entity\SEO	No errors.
App\Entity\SiteConfiguration	No errors.
App\Entity\Page	No errors.
App\Entity\Annonces	No errors.
App\Entity\TypeGamme	No errors.
App\Entity\Membre	The mappings App\Entity\Membre#historique and App\Entity\MembreHistorique#membre are inconsistent with each other.
App\Entity\Appelation	No errors.
App\Entity\Note	No errors.
App\Entity\FigurineBoutique	No errors.
App\Entity\FigurineBoutiqueCodePromo	No errors.
App\Entity\TypeBoutique	No errors.
App\Entity\LocalisationFabricant	No errors.
App\Entity\SpecialitenFabricant	No errors.
App\Entity\TypeFigurineFabricant	No errors.
App\Entity\LicensePersonnage	No errors.
App\Entity\GenrePersonnage	No errors.
App\Entity\OriginePersonnage	No errors.
App\Entity\PersonnagePhotos	No errors.
App\Entity\TypeSerie	No errors.
App\Entity\SerieLicencePhotos	No errors.

Symfony Profiler

GET https://figurine-actus.ethiko.io/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping