Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.35 ms Query time

0 Invalid entities

45 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.60 ms
(25.48%)

SELECT c0_.id AS id_0, c0_.author_name AS author_name_1, c0_.content AS content_2, c0_.is_valid AS is_valid_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.article_id AS article_id_6 FROM comment c0_ WHERE c0_.article_id = ? AND c0_.is_valid = 1 ORDER BY c0_.created_at DESC

Parameters:

[
  12237
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.author_name AS author_name_1,
  c0_.content AS content_2,
  c0_.is_valid AS is_valid_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.article_id AS article_id_6
FROM
  comment c0_
WHERE
  c0_.article_id = ?
  AND c0_.is_valid = 1
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.author_name AS author_name_1, c0_.content AS content_2, c0_.is_valid AS is_valid_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.article_id AS article_id_6 FROM comment c0_ WHERE c0_.article_id = 12237 AND c0_.is_valid = 1 ORDER BY c0_.created_at 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CommentRepository->findValidByArticle (line 55)
7	App\Controller\ArticleController->show (line 176)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.53 ms
(22.63%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.id_legifrance AS id_legifrance_3, t0.ecli AS ecli_4, t0.resume AS resume_5, t0.texte_integral AS texte_integral_6, t0.infos_complementaires AS infos_complementaires_7, t0.visas AS visas_8, t0.conclusion AS conclusion_9, t0.personal_resume AS personal_resume_10, t0.publication_date AS publication_date_11, t0.url_legifrance AS url_legifrance_12, t0.fond AS fond_13, t0.etat AS etat_14, t0.juridiction AS juridiction_15, t0.formation AS formation_16, t0.chambre AS chambre_17, t0.numero_decision AS numero_decision_18, t0.keywords AS keywords_19, t0.official_keywords AS official_keywords_20, t0.needs_validation AS needs_validation_21, t0.ai_on_topic AS ai_on_topic_22, t0.ai_no_parasite_words AS ai_no_parasite_words_23, t0.ai_title_has_keyword AS ai_title_has_keyword_24, t0.ai_resume AS ai_resume_25, t0.is_read AS is_read_26, t0.is_favorite AS is_favorite_27, t0.in_progress AS in_progress_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.in_progress_by_id AS in_progress_by_id_31 FROM article t0 WHERE t0.id = ?

Parameters:

[
  "12237"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.id_legifrance AS id_legifrance_3,
  t0.ecli AS ecli_4,
  t0.resume AS resume_5,
  t0.texte_integral AS texte_integral_6,
  t0.infos_complementaires AS infos_complementaires_7,
  t0.visas AS visas_8,
  t0.conclusion AS conclusion_9,
  t0.personal_resume AS personal_resume_10,
  t0.publication_date AS publication_date_11,
  t0.url_legifrance AS url_legifrance_12,
  t0.fond AS fond_13,
  t0.etat AS etat_14,
  t0.juridiction AS juridiction_15,
  t0.formation AS formation_16,
  t0.chambre AS chambre_17,
  t0.numero_decision AS numero_decision_18,
  t0.keywords AS keywords_19,
  t0.official_keywords AS official_keywords_20,
  t0.needs_validation AS needs_validation_21,
  t0.ai_on_topic AS ai_on_topic_22,
  t0.ai_no_parasite_words AS ai_no_parasite_words_23,
  t0.ai_title_has_keyword AS ai_title_has_keyword_24,
  t0.ai_resume AS ai_resume_25,
  t0.is_read AS is_read_26,
  t0.is_favorite AS is_favorite_27,
  t0.in_progress AS in_progress_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.in_progress_by_id AS in_progress_by_id_31
FROM
  article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.id_legifrance AS id_legifrance_3, t0.ecli AS ecli_4, t0.resume AS resume_5, t0.texte_integral AS texte_integral_6, t0.infos_complementaires AS infos_complementaires_7, t0.visas AS visas_8, t0.conclusion AS conclusion_9, t0.personal_resume AS personal_resume_10, t0.publication_date AS publication_date_11, t0.url_legifrance AS url_legifrance_12, t0.fond AS fond_13, t0.etat AS etat_14, t0.juridiction AS juridiction_15, t0.formation AS formation_16, t0.chambre AS chambre_17, t0.numero_decision AS numero_decision_18, t0.keywords AS keywords_19, t0.official_keywords AS official_keywords_20, t0.needs_validation AS needs_validation_21, t0.ai_on_topic AS ai_on_topic_22, t0.ai_no_parasite_words AS ai_no_parasite_words_23, t0.ai_title_has_keyword AS ai_title_has_keyword_24, t0.ai_resume AS ai_resume_25, t0.is_read AS is_read_26, t0.is_favorite AS is_favorite_27, t0.in_progress AS in_progress_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.in_progress_by_id AS in_progress_by_id_31 FROM article t0 WHERE t0.id = '12237';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 5)

0.36 ms
(15.27%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.setup_token AS setup_token_6, t0.setup_token_expires_at AS setup_token_expires_at_7 FROM `user` t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.setup_token AS setup_token_6,
  t0.setup_token_expires_at AS setup_token_expires_at_7
FROM
  `user` t0

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.setup_token AS setup_token_6, t0.setup_token_expires_at AS setup_token_expires_at_7 FROM `user` t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\UserExtension->allUsers (line 34)
6	App\Twig\UserExtension->{closure:App\Twig\UserExtension::getFunctions():20} (line 20)
7	__TwigTemplate_b5eb5e2ce0eba68d3708824bbe734d22->doDisplay (line 119)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_e5c4d1719f02f6d90b681f609de4a77c->doDisplay (line 54)
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 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\ArticleController->show (line 173)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.32 ms
(13.82%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM prejudice t0 INNER JOIN article_prejudice ON t0.id = article_prejudice.prejudice_id WHERE article_prejudice.article_id = ?

Parameters:

[
  12237
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  prejudice t0
  INNER JOIN article_prejudice ON t0.id = article_prejudice.prejudice_id
WHERE
  article_prejudice.article_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM prejudice t0 INNER JOIN article_prejudice ON t0.id = article_prejudice.prejudice_id WHERE article_prejudice.article_id = 12237;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
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->testEmpty (line 1423)
9	__TwigTemplate_e5c4d1719f02f6d90b681f609de4a77c::block_body (line 740)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_b5eb5e2ce0eba68d3708824bbe734d22->doDisplay (line 416)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_e5c4d1719f02f6d90b681f609de4a77c->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Controller\ArticleController->show (line 173)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.28 ms
(11.91%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.parasite_words AS parasite_words_6, t0.last_imported_at AS last_imported_at_7 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?

Parameters:

[
  12237
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.focus AS focus_4,
  t0.keywords AS keywords_5,
  t0.parasite_words AS parasite_words_6,
  t0.last_imported_at AS last_imported_at_7
FROM
  category t0
  INNER JOIN article_category ON t0.id = article_category.category_id
WHERE
  article_category.article_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.parasite_words AS parasite_words_6, t0.last_imported_at AS last_imported_at_7 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 12237;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
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->testEmpty (line 1423)
9	__TwigTemplate_e5c4d1719f02f6d90b681f609de4a77c::block_body (line 232)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_b5eb5e2ce0eba68d3708824bbe734d22->doDisplay (line 416)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_e5c4d1719f02f6d90b681f609de4a77c->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Controller\ArticleController->show (line 173)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.26 ms
(10.89%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.parasite_words AS parasite_words_6, t0.last_imported_at AS last_imported_at_7 FROM category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.label AS label_3,
  t0.focus AS focus_4,
  t0.keywords AS keywords_5,
  t0.parasite_words AS parasite_words_6,
  t0.last_imported_at AS last_imported_at_7
FROM
  category t0

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.parasite_words AS parasite_words_6, t0.last_imported_at AS last_imported_at_7 FROM category t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Twig\CategoryExtension->lastSyncDate (line 68)
6	__TwigTemplate_b5eb5e2ce0eba68d3708824bbe734d22->doDisplay (line 163)
7	Twig\Template->yield (line 411)
8	__TwigTemplate_e5c4d1719f02f6d90b681f609de4a77c->doDisplay (line 54)
9	Twig\Template->yield (line 411)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
17	App\Controller\ArticleController->show (line 173)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 191)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	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\Category	38
App\Entity\User	5
App\Entity\Article	1
App\Entity\Prejudice	1

Entities Mapping

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\User	No errors.
App\Entity\Category	No errors.
App\Entity\Note	No errors.
App\Entity\Prejudice	No errors.
App\Entity\Comment	No errors.

Symfony Profiler

GET https://juris.credolab.fr/article/12237

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping