Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

5.51 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.02 ms
(18.48%)

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.nom AS nom_2, a0_.date_naissance AS date_naissance_3, a0_.maladie AS maladie_4, a0_.etat AS etat_5, a0_.sexe AS sexe_6, a0_.image_name AS image_name_7, a0_.image_size AS image_size_8, a0_.updated_at AS updated_at_9, a0_.num_iden_valid AS num_iden_valid_10, a0_.num_iden AS num_iden_11, a0_.datepublication AS datepublication_12, a0_.vaccine AS vaccine_13, a0_.dresse AS dresse_14, a0_.sterile AS sterile_15, a0_.couleur AS couleur_16, a0_.poil AS poil_17, a0_.possedeallergie AS possedeallergie_18, a0_.allergie AS allergie_19, a0_.traiter AS traiter_20, a0_.goodwith AS goodwith_21, a0_.raison AS raison_22, a0_.custom_id AS custom_id_23, a0_.etape AS etape_24, a0_.race_id AS race_id_25, a0_.ville_id AS ville_id_26, a0_.donneur_id AS donneur_id_27 FROM annonce a0_ INNER JOIN race r1_ ON a0_.race_id = r1_.id INNER JOIN espece e2_ ON r1_.espece_id = e2_.id WHERE a0_.nom = ? AND e2_.nom = ? AND r1_.race_slug = ? AND a0_.custom_id = ?

Parameters:

[
  "Sylvie de la Devaux"
  "Chien"
  "barbado-de-terceira"
  "A100021"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.description AS description_1,
  a0_.nom AS nom_2,
  a0_.date_naissance AS date_naissance_3,
  a0_.maladie AS maladie_4,
  a0_.etat AS etat_5,
  a0_.sexe AS sexe_6,
  a0_.image_name AS image_name_7,
  a0_.image_size AS image_size_8,
  a0_.updated_at AS updated_at_9,
  a0_.num_iden_valid AS num_iden_valid_10,
  a0_.num_iden AS num_iden_11,
  a0_.datepublication AS datepublication_12,
  a0_.vaccine AS vaccine_13,
  a0_.dresse AS dresse_14,
  a0_.sterile AS sterile_15,
  a0_.couleur AS couleur_16,
  a0_.poil AS poil_17,
  a0_.possedeallergie AS possedeallergie_18,
  a0_.allergie AS allergie_19,
  a0_.traiter AS traiter_20,
  a0_.goodwith AS goodwith_21,
  a0_.raison AS raison_22,
  a0_.custom_id AS custom_id_23,
  a0_.etape AS etape_24,
  a0_.race_id AS race_id_25,
  a0_.ville_id AS ville_id_26,
  a0_.donneur_id AS donneur_id_27
FROM
  annonce a0_
  INNER JOIN race r1_ ON a0_.race_id = r1_.id
  INNER JOIN espece e2_ ON r1_.espece_id = e2_.id
WHERE
  a0_.nom = ?
  AND e2_.nom = ?
  AND r1_.race_slug = ?
  AND a0_.custom_id = ?

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.nom AS nom_2, a0_.date_naissance AS date_naissance_3, a0_.maladie AS maladie_4, a0_.etat AS etat_5, a0_.sexe AS sexe_6, a0_.image_name AS image_name_7, a0_.image_size AS image_size_8, a0_.updated_at AS updated_at_9, a0_.num_iden_valid AS num_iden_valid_10, a0_.num_iden AS num_iden_11, a0_.datepublication AS datepublication_12, a0_.vaccine AS vaccine_13, a0_.dresse AS dresse_14, a0_.sterile AS sterile_15, a0_.couleur AS couleur_16, a0_.poil AS poil_17, a0_.possedeallergie AS possedeallergie_18, a0_.allergie AS allergie_19, a0_.traiter AS traiter_20, a0_.goodwith AS goodwith_21, a0_.raison AS raison_22, a0_.custom_id AS custom_id_23, a0_.etape AS etape_24, a0_.race_id AS race_id_25, a0_.ville_id AS ville_id_26, a0_.donneur_id AS donneur_id_27 FROM annonce a0_ INNER JOIN race r1_ ON a0_.race_id = r1_.id INNER JOIN espece e2_ ON r1_.espece_id = e2_.id WHERE a0_.nom = 'Sylvie de la Devaux' AND e2_.nom = 'Chien' AND r1_.race_slug = 'barbado-de-terceira' AND a0_.custom_id = 'A100021';

#	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\AnnonceRepository->verif_url (line 66)
7	App\Controller\AnnonceController->annonce_profil (line 649)
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 35)
12	require_once (line 32)
13	require_once (line 5)

0.85 ms
(15.36%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_postal AS code_postal_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.departement_id AS departement_id_6 FROM ville t0 WHERE t0.id = ?

Parameters:

[
  20843
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code_postal AS code_postal_3,
  t0.longitude AS longitude_4,
  t0.latitude AS latitude_5,
  t0.departement_id AS departement_id_6
FROM
  ville t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_postal AS code_postal_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.departement_id AS departement_id_6 FROM ville t0 WHERE t0.id = 20843;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Ville::getLatitude (line 87)
5	App\Controller\AnnonceController->annonce_profil (line 661)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.82 ms
(14.83%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.race_slug AS race_slug_3, t0.poids_min AS poids_min_4, t0.poids_max AS poids_max_5, t0.taille_min AS taille_min_6, t0.taille_max AS taille_max_7, t0.vie_min AS vie_min_8, t0.vie_max AS vie_max_9, t0.temps_balade AS temps_balade_10, t0.avantage AS avantage_11, t0.inconvenient AS inconvenient_12, t0.description AS description_13, t0.lof AS lof_14, t0.espece_id AS espece_id_15 FROM race t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.race_slug AS race_slug_3,
  t0.poids_min AS poids_min_4,
  t0.poids_max AS poids_max_5,
  t0.taille_min AS taille_min_6,
  t0.taille_max AS taille_max_7,
  t0.vie_min AS vie_min_8,
  t0.vie_max AS vie_max_9,
  t0.temps_balade AS temps_balade_10,
  t0.avantage AS avantage_11,
  t0.inconvenient AS inconvenient_12,
  t0.description AS description_13,
  t0.lof AS lof_14,
  t0.espece_id AS espece_id_15
FROM
  race t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.race_slug AS race_slug_3, t0.poids_min AS poids_min_4, t0.poids_max AS poids_max_5, t0.taille_min AS taille_min_6, t0.taille_max AS taille_max_7, t0.vie_min AS vie_min_8, t0.vie_max AS vie_max_9, t0.temps_balade AS temps_balade_10, t0.avantage AS avantage_11, t0.inconvenient AS inconvenient_12, t0.description AS description_13, t0.lof AS lof_14, t0.espece_id AS espece_id_15 FROM race t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_06726cc56c9923c11721b2f997007f03::block_body (line 94)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_94481a46e625ceefd62abd1cdd42af97->doDisplay (line 277)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_06726cc56c9923c11721b2f997007f03->doDisplay (line 53)
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\AnnonceController->annonce_profil (line 687)
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 35)
23	require_once (line 32)
24	require_once (line 5)

0.80 ms
(14.44%)

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.type AS type_3, t0.montant AS montant_4, t0.date_paiement AS date_paiement_5, t0.status AS status_6, t0.helloasso_id AS helloasso_id_7, t0.annonce_id AS annonce_id_8, t0.user_id AS user_id_9 FROM paiement t0 WHERE t0.annonce_id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.type AS type_3,
  t0.montant AS montant_4,
  t0.date_paiement AS date_paiement_5,
  t0.status AS status_6,
  t0.helloasso_id AS helloasso_id_7,
  t0.annonce_id AS annonce_id_8,
  t0.user_id AS user_id_9
FROM
  paiement t0
WHERE
  t0.annonce_id = ?

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.type AS type_3, t0.montant AS montant_4, t0.date_paiement AS date_paiement_5, t0.status AS status_6, t0.helloasso_id AS helloasso_id_7, t0.annonce_id AS annonce_id_8, t0.user_id AS user_id_9 FROM paiement t0 WHERE t0.annonce_id = 21;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Repository\AnnonceRepository->verif_url (line 66)
12	App\Controller\AnnonceController->annonce_profil (line 649)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.71 ms
(12.93%)

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM espece t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  espece t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM espece t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_06726cc56c9923c11721b2f997007f03::block_body (line 94)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_94481a46e625ceefd62abd1cdd42af97->doDisplay (line 277)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_06726cc56c9923c11721b2f997007f03->doDisplay (line 53)
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\AnnonceController->annonce_profil (line 687)
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 35)
23	require_once (line 32)
24	require_once (line 5)

0.68 ms
(12.33%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.region_id AS region_id_4 FROM departement t0 WHERE t0.id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.region_id AS region_id_4
FROM
  departement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.region_id AS region_id_4 FROM departement t0 WHERE t0.id = 15;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_06726cc56c9923c11721b2f997007f03::block_body (line 375)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_94481a46e625ceefd62abd1cdd42af97->doDisplay (line 277)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_06726cc56c9923c11721b2f997007f03->doDisplay (line 53)
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\AnnonceController->annonce_profil (line 687)
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 35)
23	require_once (line 32)
24	require_once (line 5)

0.64 ms
(11.63%)

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1794)
5	__TwigTemplate_06726cc56c9923c11721b2f997007f03::block_body (line 379)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_94481a46e625ceefd62abd1cdd42af97->doDisplay (line 277)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_06726cc56c9923c11721b2f997007f03->doDisplay (line 53)
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\AnnonceController->annonce_profil (line 687)
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 35)
23	require_once (line 32)
24	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\Annonce	1
App\Entity\Race	1
App\Entity\Ville	1
App\Entity\User	1
App\Entity\Departement	1
App\Entity\Espece	1
App\Entity\Region	1

Entities Mapping

Class	Mapping errors
App\Entity\Annonce	No errors.
App\Entity\Race	No errors.
App\Entity\Espece	No errors.
App\Entity\Ville	No errors.
App\Entity\User	No errors.
App\Entity\FormAdoption	No errors.
App\Entity\Paiement	No errors.
App\Entity\AnnoncePreuve	No errors.
App\Entity\AnnonceHistorique	No errors.
App\Entity\Conversation	No errors.
App\Entity\Departement	No errors.
App\Entity\Article	No errors.
App\Entity\RaceCaractere	No errors.
App\Entity\Region	No errors.

Symfony Profiler

GET https://www.tycotr.lapatteprecieuse.fr/annonce-adoption/Chien/barbado-de-terceira/Sylvie%20de%20la%20Devaux/A100021

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping