Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.63 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.67 ms
(41.22%)

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:

[
  "47"
]

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 = '47';

#	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.59 ms
(35.90%)

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:

[
  47
]

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 = 47;

#	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->getIterator (line 315)
7	__TwigTemplate_06b6d823125fc38b4d2d81fa0c536612->doDisplay (line 264)
8	Twig\Template->yield (line 411)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 258)
15	App\Controller\ArticleController->pdf (line 190)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 191)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	require_once (line 5)

0.37 ms
(22.88%)

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:

[
  47
]

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 = 47;

#	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_06b6d823125fc38b4d2d81fa0c536612::doDisplay (line 422)
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->renderView (line 258)
17	App\Controller\ArticleController->pdf (line 190)
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\Article	1
App\Entity\Category	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/47/pdf

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping