Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

5.47 ms Query time

0 Invalid entities

26 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.44 ms
(62.89%)

SELECT t0.rendez_vous_id AS rendez_vous_id_1, t0.service_propose_id AS service_propose_id_2, t0.date_realisation AS date_realisation_3, t0.cout_total AS cout_total_4, t0.statut AS statut_5, t0.id AS id_6 FROM prestation t0 WHERE t0.id = ?

Parameters:

[
  "bc21cd4d3984b5888d5fe7b19d84c2ab"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.rendez_vous_id AS rendez_vous_id_1,
  t0.service_propose_id AS service_propose_id_2,
  t0.date_realisation AS date_realisation_3,
  t0.cout_total AS cout_total_4,
  t0.statut AS statut_5,
  t0.id AS id_6
FROM
  prestation t0
WHERE
  t0.id = ?

SELECT t0.rendez_vous_id AS rendez_vous_id_1, t0.service_propose_id AS service_propose_id_2, t0.date_realisation AS date_realisation_3, t0.cout_total AS cout_total_4, t0.statut AS statut_5, t0.id AS id_6 FROM prestation t0 WHERE t0.id = 'bc21cd4d3984b5888d5fe7b19d84c2ab';

#	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	Infrastructure\Persistence\Doctrine\Repository\DoctrinePrestationRepository->findById (line 25)
5	UI\Http\Admin\Controller\PrestationAdminController->show (line 104)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.36 ms
(6.60%)

SELECT t0.valeur AS valeur_1, t0.type_valeur AS type_valeur_2, t0.document_id AS document_id_3, t0.service_champ_id AS service_champ_id_4, t0.prestation_id AS prestation_id_5 FROM prestation_valeur_champ t0 WHERE t0.prestation_id = ?

Parameters:

[
  "bc21cd4d3984b5888d5fe7b19d84c2ab"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.valeur AS valeur_1,
  t0.type_valeur AS type_valeur_2,
  t0.document_id AS document_id_3,
  t0.service_champ_id AS service_champ_id_4,
  t0.prestation_id AS prestation_id_5
FROM
  prestation_valeur_champ t0
WHERE
  t0.prestation_id = ?

SELECT t0.valeur AS valeur_1, t0.type_valeur AS type_valeur_2, t0.document_id AS document_id_3, t0.service_champ_id AS service_champ_id_4, t0.prestation_id AS prestation_id_5 FROM prestation_valeur_champ t0 WHERE t0.prestation_id = 'bc21cd4d3984b5888d5fe7b19d84c2ab';

#	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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_9af02021049097ca2ee953870b70d550->block_body (line 258)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_832daebeaa5c4db5873ffc8b675403dc->doDisplay (line 100)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_9af02021049097ca2ee953870b70d550->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	UI\Http\Admin\Controller\PrestationAdminController->show (line 126)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 6)

0.31 ms
(5.60%)

SELECT t0.nom AS nom_1, t0.code AS code_2, t0.description AS description_3, t0.duree_default_minutes AS duree_default_minutes_4, t0.necessite_acompte_default AS necessite_acompte_default_5, t0.actif AS actif_6, t0.id AS id_7, t0.montant AS montant_8, t0.devise AS devise_9, t0.date_application AS date_application_10, t0.categorie_id AS categorie_id_11 FROM service t0 WHERE t0.id = ?

Parameters:

[
  "a5f85aed3f53df690c9de50789e58dca"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nom AS nom_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.duree_default_minutes AS duree_default_minutes_4,
  t0.necessite_acompte_default AS necessite_acompte_default_5,
  t0.actif AS actif_6,
  t0.id AS id_7,
  t0.montant AS montant_8,
  t0.devise AS devise_9,
  t0.date_application AS date_application_10,
  t0.categorie_id AS categorie_id_11
FROM
  service t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.code AS code_2, t0.description AS description_3, t0.duree_default_minutes AS duree_default_minutes_4, t0.necessite_acompte_default AS necessite_acompte_default_5, t0.actif AS actif_6, t0.id AS id_7, t0.montant AS montant_8, t0.devise AS devise_9, t0.date_application AS date_application_10, t0.categorie_id AS categorie_id_11 FROM service t0 WHERE t0.id = 'a5f85aed3f53df690c9de50789e58dca';

#	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	Infrastructure\Persistence\Doctrine\Repository\DoctrineServiceRepository->findById (line 25)
5	UI\Http\Admin\Controller\PrestationAdminController->show (line 111)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.30 ms
(5.50%)

SELECT t0.client_id AS client_id_1, t0.animal_id AS animal_id_2, t0.prestataire_id AS prestataire_id_3, t0.service_propose_id AS service_propose_id_4, t0.date_rdv AS date_rdv_5, t0.statut AS statut_6, t0.commentaires AS commentaires_7, t0.id AS id_8, t0.heure_debut AS heure_debut_9, t0.heure_fin AS heure_fin_10, t0.duree_minutes AS duree_minutes_11 FROM rendez_vous t0 WHERE t0.id = ?

Parameters:

[
  "49bbdc6a968f8b42e8c3b3b7b0699761"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.client_id AS client_id_1,
  t0.animal_id AS animal_id_2,
  t0.prestataire_id AS prestataire_id_3,
  t0.service_propose_id AS service_propose_id_4,
  t0.date_rdv AS date_rdv_5,
  t0.statut AS statut_6,
  t0.commentaires AS commentaires_7,
  t0.id AS id_8,
  t0.heure_debut AS heure_debut_9,
  t0.heure_fin AS heure_fin_10,
  t0.duree_minutes AS duree_minutes_11
FROM
  rendez_vous t0
WHERE
  t0.id = ?

SELECT t0.client_id AS client_id_1, t0.animal_id AS animal_id_2, t0.prestataire_id AS prestataire_id_3, t0.service_propose_id AS service_propose_id_4, t0.date_rdv AS date_rdv_5, t0.statut AS statut_6, t0.commentaires AS commentaires_7, t0.id AS id_8, t0.heure_debut AS heure_debut_9, t0.heure_fin AS heure_fin_10, t0.duree_minutes AS duree_minutes_11 FROM rendez_vous t0 WHERE t0.id = '49bbdc6a968f8b42e8c3b3b7b0699761';

#	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	Infrastructure\Persistence\Doctrine\Repository\DoctrineRendezVousRepository->findById (line 25)
5	UI\Http\Admin\Controller\PrestationAdminController->show (line 109)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.23 ms
(4.24%)

SELECT t0.right_name AS right_name_1, t0.right_code AS right_code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM rights t0 WHERE t0.right_code = ? LIMIT 1

Parameters:

[
  "admin_prestation_show"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.right_name AS right_name_1,
  t0.right_code AS right_code_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.id AS id_5
FROM
  rights t0
WHERE
  t0.right_code = ?
LIMIT
  1

SELECT t0.right_name AS right_name_1, t0.right_code AS right_code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM rights t0 WHERE t0.right_code = 'admin_prestation_show' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Infrastructure\Persistence\Doctrine\Repository\DoctrineRightRepository->findByCode (line 31)
5	Infrastructure\Shared\Security\AccessControlSubscriber->onKernelController (line 43)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 6)

0.22 ms
(4.06%)

SELECT t0.prestataire_id AS prestataire_id_1, t0.service_id AS service_id_2, t0.actif AS actif_3, t0.description AS description_4, t0.id AS id_5 FROM service_propose t0 WHERE t0.id = ?

Parameters:

[
  "b2659f6b5cd07fd025d7a065f0d7d4cd"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.prestataire_id AS prestataire_id_1,
  t0.service_id AS service_id_2,
  t0.actif AS actif_3,
  t0.description AS description_4,
  t0.id AS id_5
FROM
  service_propose t0
WHERE
  t0.id = ?

SELECT t0.prestataire_id AS prestataire_id_1, t0.service_id AS service_id_2, t0.actif AS actif_3, t0.description AS description_4, t0.id AS id_5 FROM service_propose t0 WHERE t0.id = 'b2659f6b5cd07fd025d7a065f0d7d4cd';

#	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	Infrastructure\Persistence\Doctrine\Repository\DoctrineServiceProposeRepository->findById (line 26)
5	UI\Http\Admin\Controller\PrestationAdminController->show (line 110)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.21 ms
(3.86%)

SELECT t0.nom AS nom_1, t0.prenom AS prenom_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.ville AS ville_5, t0.id AS id_6 FROM client t0 WHERE t0.id = ?

Parameters:

[
  "e328141444215e88cd83203fa9498252"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nom AS nom_1,
  t0.prenom AS prenom_2,
  t0.email AS email_3,
  t0.telephone AS telephone_4,
  t0.ville AS ville_5,
  t0.id AS id_6
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.prenom AS prenom_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.ville AS ville_5, t0.id AS id_6 FROM client t0 WHERE t0.id = 'e328141444215e88cd83203fa9498252';

#	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	Infrastructure\Persistence\Doctrine\Repository\DoctrineClientRepository->findById (line 25)
5	UI\Http\Admin\Controller\PrestationAdminController->show (line 116)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.21 ms
(3.79%)

SELECT t0.nom AS nom_1, t0.espece AS espece_2, t0.race AS race_3, t0.date_naissance AS date_naissance_4, t0.proprietaire_id AS proprietaire_id_5, t0.poids AS poids_6, t0.id AS id_7 FROM animal t0 WHERE t0.id = ?

Parameters:

[
  "b7943130033ef8407c82f43d619ea37d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nom AS nom_1,
  t0.espece AS espece_2,
  t0.race AS race_3,
  t0.date_naissance AS date_naissance_4,
  t0.proprietaire_id AS proprietaire_id_5,
  t0.poids AS poids_6,
  t0.id AS id_7
FROM
  animal t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.espece AS espece_2, t0.race AS race_3, t0.date_naissance AS date_naissance_4, t0.proprietaire_id AS proprietaire_id_5, t0.poids AS poids_6, t0.id AS id_7 FROM animal t0 WHERE t0.id = 'b7943130033ef8407c82f43d619ea37d';

#	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	Infrastructure\Persistence\Doctrine\Repository\DoctrineAnimalRepository->findById (line 26)
5	UI\Http\Admin\Controller\PrestationAdminController->show (line 120)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.19 ms
(3.46%)

SELECT t0.nom AS nom_1, t0.type_champ AS type_champ_2, t0.description AS description_3, t0.obligatoire_global AS obligatoire_global_4, t0.id AS id_5 FROM service_champ t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nom AS nom_1,
  t0.type_champ AS type_champ_2,
  t0.description AS description_3,
  t0.obligatoire_global AS obligatoire_global_4,
  t0.id AS id_5
FROM
  service_champ t0

SELECT t0.nom AS nom_1, t0.type_champ AS type_champ_2, t0.description AS description_3, t0.obligatoire_global AS obligatoire_global_4, t0.id AS id_5 FROM service_champ t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	Infrastructure\Persistence\Doctrine\Repository\DoctrineServiceChampRepository->findAll (line 30)
5	UI\Http\Admin\Controller\PrestationAdminController->show (line 132)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

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
Domain\Service\Entity\ServiceChamp	16
Domain\Prestation\Entity\PrestationValeurChamp	3
Domain\Prestation\Entity\Prestation	1
Domain\RendezVous\Entity\RendezVous	1
Domain\Prestataire\Entity\ServicePropose	1
Domain\Service\Entity\Service	1
Domain\Service\Entity\ServiceCategorie	1
Domain\Client\Entity\Client	1
Domain\Animal\Entity\Animal	1

Entities Mapping

Class	Mapping errors
Domain\User\Entity\Right	No errors.
Domain\Prestation\Entity\Prestation	No errors.
Domain\Prestation\Entity\PrestationValeurChamp	No errors.
Domain\RendezVous\ValueObject\TimeRange	No errors.
Domain\RendezVous\Entity\RendezVous	No errors.
Domain\Prestataire\Entity\ServicePropose	No errors.
Domain\Service\Entity\Tarif	No errors.
Domain\Service\Entity\Service	No errors.
Domain\Service\Entity\ServiceCategorie	No errors.
Domain\Client\Entity\Client	No errors.
Domain\Animal\Entity\Animal	No errors.
Domain\Service\Entity\ServiceChamp	No errors.

Symfony Profiler

GET https://www.recette-app.animal-care-madagascar.com/admin/prestation/bc21cd4d3984b5888d5fe7b19d84c2ab/detail

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping