Symfony Profiler

Query Metrics

12 Database Queries

5 Different statements

11.94 ms Query time

0 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.21 ms
(35.25%)

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_da36d5938b5913f26bca3c4672e115b5::block_body (line 163)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_94481a46e625ceefd62abd1cdd42af97->doDisplay (line 277)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_da36d5938b5913f26bca3c4672e115b5->doDisplay (line 54)
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\MenuController->index (line 35)
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)

3.99 ms
(33.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->rand (line 49)
12	App\Controller\MenuController->index (line 26)
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)

1.67 ms
(13.97%)

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_ WHERE a0_.etat = ? ORDER BY RAND() ASC LIMIT 6

Parameters:

[
  "EN_LIGNE"
]

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_
WHERE
  a0_.etat = ?
ORDER BY
  RAND() ASC
LIMIT
  6

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_ WHERE a0_.etat = 'EN_LIGNE' ORDER BY RAND() ASC LIMIT 6;

#	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->rand (line 49)
7	App\Controller\MenuController->index (line 26)
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)

1.05 ms
(8.80%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.objectif AS objectif_3, t0.description AS description_4, t0.datelimite AS datelimite_5, t0.status AS status_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.datedebut AS datedebut_10, t0.montant_collecte AS montant_collecte_11, t0.custom_id AS custom_id_12 FROM campagne t0 WHERE t0.status = ?

Parameters:

[
  "EN_COURS"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.objectif AS objectif_3,
  t0.description AS description_4,
  t0.datelimite AS datelimite_5,
  t0.status AS status_6,
  t0.image_name AS image_name_7,
  t0.image_size AS image_size_8,
  t0.updated_at AS updated_at_9,
  t0.datedebut AS datedebut_10,
  t0.montant_collecte AS montant_collecte_11,
  t0.custom_id AS custom_id_12
FROM
  campagne t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.objectif AS objectif_3, t0.description AS description_4, t0.datelimite AS datelimite_5, t0.status AS status_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.datedebut AS datedebut_10, t0.montant_collecte AS montant_collecte_11, t0.custom_id AS custom_id_12 FROM campagne t0 WHERE t0.status = 'EN_COURS';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\MenuController->index (line 27)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

1.02 ms
(8.55%)

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_da36d5938b5913f26bca3c4672e115b5::block_body (line 163)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_94481a46e625ceefd62abd1cdd42af97->doDisplay (line 277)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_da36d5938b5913f26bca3c4672e115b5->doDisplay (line 54)
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\MenuController->index (line 35)
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	5
App\Entity\Ville	5
App\Entity\Race	4
App\Entity\User	3
App\Entity\Paiement	1
App\Entity\Espece	1

Entities Mapping

Class	Mapping errors
App\Entity\Annonce	No errors.
App\Entity\Race	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\Campagne	No errors.
App\Entity\Espece	No errors.
App\Entity\Article	No errors.
App\Entity\RaceCaractere	No errors.

Symfony Profiler

GET https://www.tycotr.lapatteprecieuse.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping