Symfony Profiler

Query Metrics

38 Database Queries

3 Different statements

3.97 ms Query time

0 Invalid entities

850 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.68 ms
(92.55%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.link AS link_7, t0.image AS image_8, t0.old_slug AS old_slug_9, t0.dossier AS dossier_10, t0.fichier_image AS fichier_image_11, t0.publie AS publie_12, t0.date_modif_at AS date_modif_at_13, t0.en_avant AS en_avant_14, t0.editeur AS editeur_15, t0.credit AS credit_16, t0.meta_description AS meta_description_17, t0.note AS note_18, t0.source AS source_19, t0.guid AS guid_20, t0.instagram_published_at AS instagram_published_at_21, t0.image_format AS image_format_22, t0.author_id AS author_id_23, t0.categorie_id AS categorie_id_24, t0.site_id AS site_id_25, t0.flux_rss_id AS flux_rss_id_26 FROM article t0 WHERE t0.categorie_id = ? ORDER BY t0.published_at DESC

Parameters:

[
  282
]

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.summary AS summary_4,
  t0.content AS content_5,
  t0.published_at AS published_at_6,
  t0.link AS link_7,
  t0.image AS image_8,
  t0.old_slug AS old_slug_9,
  t0.dossier AS dossier_10,
  t0.fichier_image AS fichier_image_11,
  t0.publie AS publie_12,
  t0.date_modif_at AS date_modif_at_13,
  t0.en_avant AS en_avant_14,
  t0.editeur AS editeur_15,
  t0.credit AS credit_16,
  t0.meta_description AS meta_description_17,
  t0.note AS note_18,
  t0.source AS source_19,
  t0.guid AS guid_20,
  t0.instagram_published_at AS instagram_published_at_21,
  t0.image_format AS image_format_22,
  t0.author_id AS author_id_23,
  t0.categorie_id AS categorie_id_24,
  t0.site_id AS site_id_25,
  t0.flux_rss_id AS flux_rss_id_26
FROM
  article t0
WHERE
  t0.categorie_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.link AS link_7, t0.image AS image_8, t0.old_slug AS old_slug_9, t0.dossier AS dossier_10, t0.fichier_image AS fichier_image_11, t0.publie AS publie_12, t0.date_modif_at AS date_modif_at_13, t0.en_avant AS en_avant_14, t0.editeur AS editeur_15, t0.credit AS credit_16, t0.meta_description AS meta_description_17, t0.note AS note_18, t0.source AS source_19, t0.guid AS guid_20, t0.instagram_published_at AS instagram_published_at_21, t0.image_format AS image_format_22, t0.author_id AS author_id_23, t0.categorie_id AS categorie_id_24, t0.site_id AS site_id_25, t0.flux_rss_id AS flux_rss_id_26 FROM article t0 WHERE t0.categorie_id = 282 ORDER BY t0.published_at DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_f65e514ec1891b4e643119f822f5f1d6::doDisplay (line 57)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\CategorieController->categoriesRacine (line 48)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 9)

0.18 ms
(4.48%)

SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url_site AS url_site_3, t0.meta_description AS meta_description_4, t0.meta_mots_cles AS meta_mots_cles_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.a_propos AS a_propos_8, t0.titre_apropos AS titre_apropos_9, t0.slug_apropos AS slug_apropos_10, t0.resume_apropos AS resume_apropos_11, t0.instagram_user_id AS instagram_user_id_12, t0.instagram_access_token AS instagram_access_token_13, t0.image_format_default AS image_format_default_14, t0.auteur_principal_id AS auteur_principal_id_15 FROM site t0 WHERE t0.url_site = ? LIMIT 1

Parameters:

[
  "la-buse.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_site AS nom_site_2,
  t0.url_site AS url_site_3,
  t0.meta_description AS meta_description_4,
  t0.meta_mots_cles AS meta_mots_cles_5,
  t0.description AS description_6,
  t0.meta_title AS meta_title_7,
  t0.a_propos AS a_propos_8,
  t0.titre_apropos AS titre_apropos_9,
  t0.slug_apropos AS slug_apropos_10,
  t0.resume_apropos AS resume_apropos_11,
  t0.instagram_user_id AS instagram_user_id_12,
  t0.instagram_access_token AS instagram_access_token_13,
  t0.image_format_default AS image_format_default_14,
  t0.auteur_principal_id AS auteur_principal_id_15
FROM
  site t0
WHERE
  t0.url_site = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url_site AS url_site_3, t0.meta_description AS meta_description_4, t0.meta_mots_cles AS meta_mots_cles_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.a_propos AS a_propos_8, t0.titre_apropos AS titre_apropos_9, t0.slug_apropos AS slug_apropos_10, t0.resume_apropos AS resume_apropos_11, t0.instagram_user_id AS instagram_user_id_12, t0.instagram_access_token AS instagram_access_token_13, t0.image_format_default AS image_format_default_14, t0.auteur_principal_id AS auteur_principal_id_15 FROM site t0 WHERE t0.url_site = 'la-buse.fr' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\ORM\EntityRepository->resolveMagicCall (line 235)
4	Doctrine\ORM\EntityRepository->__call (line 158)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 95)
6	App\Controller\CategorieController->categoriesRacine (line 46)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 9)

0.12 ms
(2.97%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.texte_description AS texte_description_6, t0.site_id AS site_id_7, t0.categorie_parent_id AS categorie_parent_id_8 FROM categorie t0 WHERE t0.site_id = ? AND t0.categorie_parent_id IS NULL ORDER BY t0.nom DESC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.meta_description AS meta_description_4,
  t0.resume AS resume_5,
  t0.texte_description AS texte_description_6,
  t0.site_id AS site_id_7,
  t0.categorie_parent_id AS categorie_parent_id_8
FROM
  categorie t0
WHERE
  t0.site_id = ?
  AND t0.categorie_parent_id IS NULL
ORDER BY
  t0.nom DESC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.texte_description AS texte_description_6, t0.site_id AS site_id_7, t0.categorie_parent_id AS categorie_parent_id_8 FROM categorie t0 WHERE t0.site_id = 2 AND t0.categorie_parent_id IS NULL ORDER BY t0.nom DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\CategorieController->categoriesRacine (line 49)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 9)

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\Article	812
App\Entity\Categorie	35
App\Entity\User	2
App\Entity\Site	1

Entities Mapping

Class	Mapping errors
App\Entity\Site	No errors.
App\Entity\User	No errors.
App\Entity\Categorie	No errors.
App\Entity\Gallerie	No errors.
App\Entity\Article	No errors.
App\Entity\Tag	No errors.
App\Entity\FluxRss	No errors.
App\Entity\ItemRss	No errors.
App\Entity\Comment	No errors.

Symfony Profiler

GET https://la-buse.fr/en/categories_categorie_racine

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping