Symfony Profiler

Query Metrics

47 Database Queries

8 Different statements

42.52 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.90 ms
(37.39%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.filename AS filename_4, t0.completed_at AS completed_at_5, t0.is_classified AS is_classified_6, t0.numero AS numero_7, t0.arret_at AS arret_at_8, t0.year_at AS year_at_9, t0.content AS content_10, t0.updated_at AS updated_at_11, t0.created_by_id AS created_by_id_12, t0.decision_id AS decision_id_13, t0.completed_by_id AS completed_by_id_14, t0.nature_id AS nature_id_15 FROM draft t0 WHERE t0.decision_id = ?

Parameters:

[
  430
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.created_at AS created_at_3,
  t0.filename AS filename_4,
  t0.completed_at AS completed_at_5,
  t0.is_classified AS is_classified_6,
  t0.numero AS numero_7,
  t0.arret_at AS arret_at_8,
  t0.year_at AS year_at_9,
  t0.content AS content_10,
  t0.updated_at AS updated_at_11,
  t0.created_by_id AS created_by_id_12,
  t0.decision_id AS decision_id_13,
  t0.completed_by_id AS completed_by_id_14,
  t0.nature_id AS nature_id_15
FROM
  draft t0
WHERE
  t0.decision_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.filename AS filename_4, t0.completed_at AS completed_at_5, t0.is_classified AS is_classified_6, t0.numero AS numero_7, t0.arret_at AS arret_at_8, t0.year_at AS year_at_9, t0.content AS content_10, t0.updated_at AS updated_at_11, t0.created_by_id AS created_by_id_12, t0.decision_id AS decision_id_13, t0.completed_by_id AS completed_by_id_14, t0.nature_id AS nature_id_15 FROM draft t0 WHERE t0.decision_id = 430;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 833)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2440)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 145)
12	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
13	iterator_to_array (line 45)
14	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
19	Knp\Component\Pager\Paginator->paginate (line 25)
20	ContainerCDDsvfo\PaginatorProxyBa079e5->paginate (line 68)
21	App\Controller\Api\DecisionController->list (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

15.40 ms
(36.22%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM matiere t0 INNER JOIN decision_matiere ON t0.id = decision_matiere.matiere_id WHERE decision_matiere.decision_id = ?

Parameters:

[
  430
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3
FROM
  matiere t0
  INNER JOIN decision_matiere ON t0.id = decision_matiere.matiere_id
WHERE
  decision_matiere.decision_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM matiere t0 INNER JOIN decision_matiere ON t0.id = decision_matiere.matiere_id WHERE decision_matiere.decision_id = 430;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1076)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1005)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 796)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 694)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 49)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
13	Symfony\Component\Serializer\Serializer->normalize (line 168)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 85)
17	App\Controller\Api\DecisionController->list (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

5.60 ms
(13.16%)

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.numero AS numero_2, d0_.arret_at AS arret_at_3, d0_.numero_dossier AS numero_dossier_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.validated_at AS validated_at_7, d0_.is_published AS is_published_8, d0_.is_validated AS is_validated_9, d0_.demandeur AS demandeur_10, d0_.defendeur AS defendeur_11, d0_.filename AS filename_12, d0_.object AS object_13, d0_.object_other AS object_other_14, d0_.content AS content_15, d0_.president AS president_16, d0_.conseiller_rapporteur AS conseiller_rapporteur_17, d0_.conseiller AS conseiller_18, d0_.greffier AS greffier_19, d0_.avocat_general AS avocat_general_20, d0_.autre_personnes AS autre_personnes_21, d0_.validation_note AS validation_note_22, d0_.sommaire AS sommaire_23, d0_.keywords AS keywords_24, d0_.content_brut AS content_brut_25, d0_.validate_by_id AS validate_by_id_26, d0_.nature_id AS nature_id_27, d0_.solution_id AS solution_id_28, d0_.cassation_id AS cassation_id_29, d0_.statut_id AS statut_id_30, d0_.created_by_id AS created_by_id_31 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = ? AND (n3_.id = ? OR n3_.code = ?) AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.arret_at DESC

Parameters:

[
  1
  "COMMERCIALE"
  "COMMERCIALE"
  430
  311
  307
  308
  302
  285
  251
  228
  231
  218
  219
  211
  208
  204
  191
  187
  175
  169
  160
  124
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.code AS code_1,
  d0_.numero AS numero_2,
  d0_.arret_at AS arret_at_3,
  d0_.numero_dossier AS numero_dossier_4,
  d0_.created_at AS created_at_5,
  d0_.updated_at AS updated_at_6,
  d0_.validated_at AS validated_at_7,
  d0_.is_published AS is_published_8,
  d0_.is_validated AS is_validated_9,
  d0_.demandeur AS demandeur_10,
  d0_.defendeur AS defendeur_11,
  d0_.filename AS filename_12,
  d0_.object AS object_13,
  d0_.object_other AS object_other_14,
  d0_.content AS content_15,
  d0_.president AS president_16,
  d0_.conseiller_rapporteur AS conseiller_rapporteur_17,
  d0_.conseiller AS conseiller_18,
  d0_.greffier AS greffier_19,
  d0_.avocat_general AS avocat_general_20,
  d0_.autre_personnes AS autre_personnes_21,
  d0_.validation_note AS validation_note_22,
  d0_.sommaire AS sommaire_23,
  d0_.keywords AS keywords_24,
  d0_.content_brut AS content_brut_25,
  d0_.validate_by_id AS validate_by_id_26,
  d0_.nature_id AS nature_id_27,
  d0_.solution_id AS solution_id_28,
  d0_.cassation_id AS cassation_id_29,
  d0_.statut_id AS statut_id_30,
  d0_.created_by_id AS created_by_id_31
FROM
  decision d0_
  LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id
  LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id
  LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id
  LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id
  LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id
  LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id
WHERE
  d0_.is_published = ?
  AND (
    n3_.id = ?
    OR n3_.code = ?
  )
  AND d0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  d0_.arret_at DESC

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.numero AS numero_2, d0_.arret_at AS arret_at_3, d0_.numero_dossier AS numero_dossier_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.validated_at AS validated_at_7, d0_.is_published AS is_published_8, d0_.is_validated AS is_validated_9, d0_.demandeur AS demandeur_10, d0_.defendeur AS defendeur_11, d0_.filename AS filename_12, d0_.object AS object_13, d0_.object_other AS object_other_14, d0_.content AS content_15, d0_.president AS president_16, d0_.conseiller_rapporteur AS conseiller_rapporteur_17, d0_.conseiller AS conseiller_18, d0_.greffier AS greffier_19, d0_.avocat_general AS avocat_general_20, d0_.autre_personnes AS autre_personnes_21, d0_.validation_note AS validation_note_22, d0_.sommaire AS sommaire_23, d0_.keywords AS keywords_24, d0_.content_brut AS content_brut_25, d0_.validate_by_id AS validate_by_id_26, d0_.nature_id AS nature_id_27, d0_.solution_id AS solution_id_28, d0_.cassation_id AS cassation_id_29, d0_.statut_id AS statut_id_30, d0_.created_by_id AS created_by_id_31 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = 1 AND (n3_.id = 'COMMERCIALE' OR n3_.code = 'COMMERCIALE') AND d0_.id IN (430, 311, 307, 308, 302, 285, 251, 228, 231, 218, 219, 211, 208, 204, 191, 187, 175, 169, 160, 124) ORDER BY d0_.arret_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerCDDsvfo\PaginatorProxyBa079e5->paginate (line 68)
16	App\Controller\Api\DecisionController->list (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.52 ms
(3.56%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.color AS color_4 FROM solution t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.color AS color_4
FROM
  solution t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.color AS color_4 FROM solution t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Solution::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Solution->__get (line 75)
8	App\Entity\Solution->getCode (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 783)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 49)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
15	Symfony\Component\Serializer\Serializer->normalize (line 828)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 728)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
21	Symfony\Component\Serializer\Serializer->normalize (line 168)
22	Symfony\Component\Serializer\Serializer->normalize (line 129)
23	Symfony\Component\Serializer\Serializer->serialize (line 43)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 85)
25	App\Controller\Api\DecisionController->list (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.47 ms
(3.45%)

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = ? AND (n3_.id = ? OR n3_.code = ?)

Parameters:

[
  1
  "COMMERCIALE"
  "COMMERCIALE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  decision d0_
  LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id
  LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id
  LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id
  LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id
  LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id
  LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id
WHERE
  d0_.is_published = ?
  AND (
    n3_.id = ?
    OR n3_.code = ?
  )

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = 1 AND (n3_.id = 'COMMERCIALE' OR n3_.code = 'COMMERCIALE');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerCDDsvfo\PaginatorProxyBa079e5->paginate (line 68)
16	App\Controller\Api\DecisionController->list (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.09 ms
(2.56%)

SELECT DISTINCT d0_.id AS id_0, d0_.arret_at AS arret_at_1 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = ? AND (n3_.id = ? OR n3_.code = ?) ORDER BY d0_.arret_at DESC LIMIT 20 OFFSET 20

Parameters:

[
  1
  "COMMERCIALE"
  "COMMERCIALE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.arret_at AS arret_at_1
FROM
  decision d0_
  LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id
  LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id
  LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id
  LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id
  LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id
  LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id
WHERE
  d0_.is_published = ?
  AND (
    n3_.id = ?
    OR n3_.code = ?
  )
ORDER BY
  d0_.arret_at DESC
LIMIT
  20
OFFSET
  20

SELECT DISTINCT d0_.id AS id_0, d0_.arret_at AS arret_at_1 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE d0_.is_published = 1 AND (n3_.id = 'COMMERCIALE' OR n3_.code = 'COMMERCIALE') ORDER BY d0_.arret_at DESC LIMIT 20 OFFSET 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerCDDsvfo\PaginatorProxyBa079e5->paginate (line 68)
16	App\Controller\Api\DecisionController->list (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.82 ms
(1.94%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM nature t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3
FROM
  nature t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM nature t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Nature::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Nature->__get (line 78)
8	App\Entity\Nature->getCode (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 783)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 49)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
15	Symfony\Component\Serializer\Serializer->normalize (line 828)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 728)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
21	Symfony\Component\Serializer\Serializer->normalize (line 168)
22	Symfony\Component\Serializer\Serializer->normalize (line 129)
23	Symfony\Component\Serializer\Serializer->serialize (line 43)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 85)
25	App\Controller\Api\DecisionController->list (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.73 ms
(1.71%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM cassation t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3
FROM
  cassation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM cassation t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Cassation::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Cassation->__get (line 76)
8	App\Entity\Cassation->getCode (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 783)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 49)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
15	Symfony\Component\Serializer\Serializer->normalize (line 828)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 728)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 155)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 49)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
21	Symfony\Component\Serializer\Serializer->normalize (line 168)
22	Symfony\Component\Serializer\Serializer->normalize (line 129)
23	Symfony\Component\Serializer\Serializer->serialize (line 43)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 85)
25	App\Controller\Api\DecisionController->list (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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.

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\Decision	The mappings App\Entity\Decision#validateBy and App\Entity\Utilisateur#validatedDecisions are inconsistent with each other.
App\Entity\Cassation	No errors.
App\Entity\Solution	No errors.
App\Entity\Nature	No errors.
App\Entity\Statut	No errors.
App\Entity\Matiere	No errors.
App\Entity\Utilisateur	The association App\Entity\Utilisateur#validatedDecisions refers to the owning side field App\Entity\Decision#ValidateBy which does not exist.
App\Entity\Draft	No errors.
App\Entity\History	No errors.

Symfony Profiler

GET https://medem.snovibox.com/api/decision/list?nature=COMMERCIALE&page=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping