Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.39 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.09 ms
(45.43%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.numero AS numero_3, t0.arret_at AS arret_at_4, t0.numero_dossier AS numero_dossier_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.validated_at AS validated_at_8, t0.is_published AS is_published_9, t0.is_validated AS is_validated_10, t0.demandeur AS demandeur_11, t0.defendeur AS defendeur_12, t0.filename AS filename_13, t0.object AS object_14, t0.object_other AS object_other_15, t0.content AS content_16, t0.president AS president_17, t0.conseiller_rapporteur AS conseiller_rapporteur_18, t0.conseiller AS conseiller_19, t0.greffier AS greffier_20, t0.avocat_general AS avocat_general_21, t0.autre_personnes AS autre_personnes_22, t0.validation_note AS validation_note_23, t0.sommaire AS sommaire_24, t0.keywords AS keywords_25, t0.content_brut AS content_brut_26, t0.validate_by_id AS validate_by_id_27, t0.nature_id AS nature_id_28, t0.solution_id AS solution_id_29, t0.cassation_id AS cassation_id_30, t0.statut_id AS statut_id_31, t32.id AS id_33, t32.code AS code_34, t32.created_at AS created_at_35, t32.filename AS filename_36, t32.completed_at AS completed_at_37, t32.is_classified AS is_classified_38, t32.numero AS numero_39, t32.arret_at AS arret_at_40, t32.year_at AS year_at_41, t32.content AS content_42, t32.updated_at AS updated_at_43, t32.created_by_id AS created_by_id_44, t32.decision_id AS decision_id_45, t32.completed_by_id AS completed_by_id_46, t32.nature_id AS nature_id_47, t0.created_by_id AS created_by_id_48 FROM decision t0 LEFT JOIN draft t32 ON t32.decision_id = t0.id WHERE t0.code = ? LIMIT 1

Parameters:

[
  "DCS68389AFFEF01A"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.numero AS numero_3,
  t0.arret_at AS arret_at_4,
  t0.numero_dossier AS numero_dossier_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.validated_at AS validated_at_8,
  t0.is_published AS is_published_9,
  t0.is_validated AS is_validated_10,
  t0.demandeur AS demandeur_11,
  t0.defendeur AS defendeur_12,
  t0.filename AS filename_13,
  t0.object AS object_14,
  t0.object_other AS object_other_15,
  t0.content AS content_16,
  t0.president AS president_17,
  t0.conseiller_rapporteur AS conseiller_rapporteur_18,
  t0.conseiller AS conseiller_19,
  t0.greffier AS greffier_20,
  t0.avocat_general AS avocat_general_21,
  t0.autre_personnes AS autre_personnes_22,
  t0.validation_note AS validation_note_23,
  t0.sommaire AS sommaire_24,
  t0.keywords AS keywords_25,
  t0.content_brut AS content_brut_26,
  t0.validate_by_id AS validate_by_id_27,
  t0.nature_id AS nature_id_28,
  t0.solution_id AS solution_id_29,
  t0.cassation_id AS cassation_id_30,
  t0.statut_id AS statut_id_31,
  t32.id AS id_33,
  t32.code AS code_34,
  t32.created_at AS created_at_35,
  t32.filename AS filename_36,
  t32.completed_at AS completed_at_37,
  t32.is_classified AS is_classified_38,
  t32.numero AS numero_39,
  t32.arret_at AS arret_at_40,
  t32.year_at AS year_at_41,
  t32.content AS content_42,
  t32.updated_at AS updated_at_43,
  t32.created_by_id AS created_by_id_44,
  t32.decision_id AS decision_id_45,
  t32.completed_by_id AS completed_by_id_46,
  t32.nature_id AS nature_id_47,
  t0.created_by_id AS created_by_id_48
FROM
  decision t0
  LEFT JOIN draft t32 ON t32.decision_id = t0.id
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.numero AS numero_3, t0.arret_at AS arret_at_4, t0.numero_dossier AS numero_dossier_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.validated_at AS validated_at_8, t0.is_published AS is_published_9, t0.is_validated AS is_validated_10, t0.demandeur AS demandeur_11, t0.defendeur AS defendeur_12, t0.filename AS filename_13, t0.object AS object_14, t0.object_other AS object_other_15, t0.content AS content_16, t0.president AS president_17, t0.conseiller_rapporteur AS conseiller_rapporteur_18, t0.conseiller AS conseiller_19, t0.greffier AS greffier_20, t0.avocat_general AS avocat_general_21, t0.autre_personnes AS autre_personnes_22, t0.validation_note AS validation_note_23, t0.sommaire AS sommaire_24, t0.keywords AS keywords_25, t0.content_brut AS content_brut_26, t0.validate_by_id AS validate_by_id_27, t0.nature_id AS nature_id_28, t0.solution_id AS solution_id_29, t0.cassation_id AS cassation_id_30, t0.statut_id AS statut_id_31, t32.id AS id_33, t32.code AS code_34, t32.created_at AS created_at_35, t32.filename AS filename_36, t32.completed_at AS completed_at_37, t32.is_classified AS is_classified_38, t32.numero AS numero_39, t32.arret_at AS arret_at_40, t32.year_at AS year_at_41, t32.content AS content_42, t32.updated_at AS updated_at_43, t32.created_by_id AS created_by_id_44, t32.decision_id AS decision_id_45, t32.completed_by_id AS completed_by_id_46, t32.nature_id AS nature_id_47, t0.created_by_id AS created_by_id_48 FROM decision t0 LEFT JOIN draft t32 ON t32.decision_id = t0.id WHERE t0.code = 'DCS68389AFFEF01A' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 44)
5	App\Controller\Api\DecisionController->details (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.38 ms
(15.96%)

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:

[
  1049
]

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

#	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 257)
7	Doctrine\Common\Collections\AbstractLazyCollection->map (line 471)
8	App\Service\Decision\DecisionServices->getDecisionDetails (line 50)
9	App\Controller\Api\DecisionController->details (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.35 ms
(14.54%)

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

Parameters:

[
  4
]

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

#	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 90)
8	App\Entity\Nature->getDesignation (line 463)
9	App\Service\Decision\DecisionServices->getDecisionDetails (line 50)
10	App\Controller\Api\DecisionController->details (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.31 ms
(12.91%)

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 87)
8	App\Entity\Solution->getDesignation (line 464)
9	App\Service\Decision\DecisionServices->getDecisionDetails (line 50)
10	App\Controller\Api\DecisionController->details (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.27 ms
(11.16%)

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 88)
8	App\Entity\Cassation->getDesignation (line 465)
9	App\Service\Decision\DecisionServices->getDecisionDetails (line 50)
10	App\Controller\Api\DecisionController->details (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\Utilisateur	The association App\Entity\Utilisateur#validatedDecisions refers to the owning side field App\Entity\Decision#ValidateBy which does not exist.
App\Entity\Nature	No errors.
App\Entity\Solution	No errors.
App\Entity\Cassation	No errors.
App\Entity\Statut	No errors.
App\Entity\Draft	No errors.
App\Entity\Matiere	No errors.
App\Entity\History	No errors.

Symfony Profiler

GET https://medem.snovibox.com/api/decision/details/DCS68389AFFEF01A

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping