Symfony Profiler

Query Metrics

13 Database Queries

7 Different statements

4.63 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.00 ms
(43.10%)

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 15)
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)

1.26 ms
(27.19%)

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:

[
  "footer_text"
]

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 = 'footer_text' 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 25)
5	__TwigTemplate_d76e031d6ca3645afd06fcf08f73c7c5->doDisplay (line 68)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_95d2f1329494ce03da0e36548c081c2d->doDisplay (line 96)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->doDisplay (line 53)
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 17)
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)

0.40 ms
(8.53%)

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.style AS style_6 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.style AS style_6
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.style AS style_6 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 70)
6	App\Twig\Figurine->figurineCount (line 45)
7	__TwigTemplate_074e0a244ce94c323dc9c67eb4a52dac->doDisplay (line 81)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->block_content (line 84)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_95d2f1329494ce03da0e36548c081c2d->doDisplay (line 91)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->doDisplay (line 53)
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 17)
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.35 ms
(7.54%)

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.figurine_sculpteur_id AS figurine_sculpteur_id_16, t0.figurine_peintre_id AS figurine_peintre_id_17, t0.figurine_gammes_id AS figurine_gammes_id_18, t0.figurine_fabriquant_id AS figurine_fabriquant_id_19 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.figurine_sculpteur_id AS figurine_sculpteur_id_16,
  t0.figurine_peintre_id AS figurine_peintre_id_17,
  t0.figurine_gammes_id AS figurine_gammes_id_18,
  t0.figurine_fabriquant_id AS figurine_fabriquant_id_19
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.figurine_sculpteur_id AS figurine_sculpteur_id_16, t0.figurine_peintre_id AS figurine_peintre_id_17, t0.figurine_gammes_id AS figurine_gammes_id_18, t0.figurine_fabriquant_id AS figurine_fabriquant_id_19 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 66)
5	App\Twig\Figurine->figurineCount (line 39)
6	__TwigTemplate_074e0a244ce94c323dc9c67eb4a52dac->doDisplay (line 67)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->block_content (line 84)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_95d2f1329494ce03da0e36548c081c2d->doDisplay (line 91)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->doDisplay (line 53)
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 17)
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)

0.24 ms
(5.08%)

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 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
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 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 74)
6	App\Twig\Figurine->figurineCount (line 42)
7	__TwigTemplate_074e0a244ce94c323dc9c67eb4a52dac->doDisplay (line 106)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->block_content (line 84)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_95d2f1329494ce03da0e36548c081c2d->doDisplay (line 91)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->doDisplay (line 53)
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 17)
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.21 ms
(4.60%)

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.license_personnage_id AS license_personnage_id_10, t0.genre_personnage_id AS genre_personnage_id_11, t0.origine_personnage_id AS origine_personnage_id_12, t0.figurine_id AS figurine_id_13 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.license_personnage_id AS license_personnage_id_10,
  t0.genre_personnage_id AS genre_personnage_id_11,
  t0.origine_personnage_id AS origine_personnage_id_12,
  t0.figurine_id AS figurine_id_13
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.license_personnage_id AS license_personnage_id_10, t0.genre_personnage_id AS genre_personnage_id_11, t0.origine_personnage_id AS origine_personnage_id_12, t0.figurine_id AS figurine_id_13 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 78)
6	App\Twig\Figurine->figurineCount (line 48)
7	__TwigTemplate_074e0a244ce94c323dc9c67eb4a52dac->doDisplay (line 120)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->block_content (line 84)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_95d2f1329494ce03da0e36548c081c2d->doDisplay (line 91)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->doDisplay (line 53)
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 17)
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.18 ms
(3.95%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.status AS status_3, t0.type AS type_4, t0.studio AS studio_5, t0.editeur_fr AS editeur_fr_6, t0.editeur_jp AS editeur_jp_7, t0.tags AS tags_8, t0.studio_animation AS studio_animation_9, t0.date_debut AS date_debut_10, t0.date_fin AS date_fin_11, t0.nb_saison AS nb_saison_12, t0.photo AS photo_13 FROM figurine_serie_licence t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.status AS status_3,
  t0.type AS type_4,
  t0.studio AS studio_5,
  t0.editeur_fr AS editeur_fr_6,
  t0.editeur_jp AS editeur_jp_7,
  t0.tags AS tags_8,
  t0.studio_animation AS studio_animation_9,
  t0.date_debut AS date_debut_10,
  t0.date_fin AS date_fin_11,
  t0.nb_saison AS nb_saison_12,
  t0.photo AS photo_13
FROM
  figurine_serie_licence t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.status AS status_3, t0.type AS type_4, t0.studio AS studio_5, t0.editeur_fr AS editeur_fr_6, t0.editeur_jp AS editeur_jp_7, t0.tags AS tags_8, t0.studio_animation AS studio_animation_9, t0.date_debut AS date_debut_10, t0.date_fin AS date_fin_11, t0.nb_saison AS nb_saison_12, t0.photo AS photo_13 FROM figurine_serie_licence 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 82)
6	App\Twig\Figurine->figurineCount (line 53)
7	__TwigTemplate_074e0a244ce94c323dc9c67eb4a52dac->doDisplay (line 134)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->block_content (line 84)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_95d2f1329494ce03da0e36548c081c2d->doDisplay (line 91)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c4a0c4c8e133dd499366b130237ace9b->doDisplay (line 53)
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 17)
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)

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	1
App\Entity\FigurineSculpteur	1
App\Entity\FigurineGammes	1
App\Entity\FigurineFabriquant	1
App\Entity\FigurineSerieLicence	1

Entities Mapping

Class	Mapping errors
App\Entity\SliderHero	No errors.
App\Entity\Figurine	No errors.
App\Entity\FigurineSculpteur	No errors.
App\Entity\FigurinePeintre	No errors.
App\Entity\FigurineGammes	No errors.
App\Entity\FigurineFabriquant	No errors.
App\Entity\FigurinePhotos	No errors.
App\Entity\FigurineMateriaux	No errors.
App\Entity\Personnage	No errors.
App\Entity\FigurineSerieLicence	No errors.
App\Entity\FigurineBoutiqueFigurine	No errors.
App\Entity\Appelation	No errors.
App\Entity\Note	No errors.
App\Entity\LicensePersonnage	No errors.
App\Entity\GenrePersonnage	No errors.
App\Entity\OriginePersonnage	No errors.
App\Entity\SiteConfiguration	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