Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.46 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.72 ms
(29.18%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.departure_label AS departure_label_2, r0_.departure_longitude AS departure_longitude_3, r0_.departure_latitude AS departure_latitude_4, r0_.arrival_label AS arrival_label_5, r0_.arrival_longitude AS arrival_longitude_6, r0_.arrival_latitude AS arrival_latitude_7, r0_.departure_place_id AS departure_place_id_8, r0_.arrival_place_id AS arrival_place_id_9, r0_.admin_confirm AS admin_confirm_10, r0_.date_depart AS date_depart_11, r0_.date_retour AS date_retour_12, r0_.created_at AS created_at_13, r0_.updated_at AS updated_at_14, r0_.place_disponibility AS place_disponibility_15, r0_.bagage AS bagage_16, r0_.femaly_only AS femaly_only_17, r0_.price AS price_18, r0_.remarque AS remarque_19, r0_.user_id AS user_id_20, r0_.profile_driver_id AS profile_driver_id_21, r0_.car_id AS car_id_22 FROM ride_event r0_ WHERE r0_.admin_confirm = 1 ORDER BY r0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.departure_label AS departure_label_2,
  r0_.departure_longitude AS departure_longitude_3,
  r0_.departure_latitude AS departure_latitude_4,
  r0_.arrival_label AS arrival_label_5,
  r0_.arrival_longitude AS arrival_longitude_6,
  r0_.arrival_latitude AS arrival_latitude_7,
  r0_.departure_place_id AS departure_place_id_8,
  r0_.arrival_place_id AS arrival_place_id_9,
  r0_.admin_confirm AS admin_confirm_10,
  r0_.date_depart AS date_depart_11,
  r0_.date_retour AS date_retour_12,
  r0_.created_at AS created_at_13,
  r0_.updated_at AS updated_at_14,
  r0_.place_disponibility AS place_disponibility_15,
  r0_.bagage AS bagage_16,
  r0_.femaly_only AS femaly_only_17,
  r0_.price AS price_18,
  r0_.remarque AS remarque_19,
  r0_.user_id AS user_id_20,
  r0_.profile_driver_id AS profile_driver_id_21,
  r0_.car_id AS car_id_22
FROM
  ride_event r0_
WHERE
  r0_.admin_confirm = 1
ORDER BY
  r0_.id DESC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.departure_label AS departure_label_2, r0_.departure_longitude AS departure_longitude_3, r0_.departure_latitude AS departure_latitude_4, r0_.arrival_label AS arrival_label_5, r0_.arrival_longitude AS arrival_longitude_6, r0_.arrival_latitude AS arrival_latitude_7, r0_.departure_place_id AS departure_place_id_8, r0_.arrival_place_id AS arrival_place_id_9, r0_.admin_confirm AS admin_confirm_10, r0_.date_depart AS date_depart_11, r0_.date_retour AS date_retour_12, r0_.created_at AS created_at_13, r0_.updated_at AS updated_at_14, r0_.place_disponibility AS place_disponibility_15, r0_.bagage AS bagage_16, r0_.femaly_only AS femaly_only_17, r0_.price AS price_18, r0_.remarque AS remarque_19, r0_.user_id AS user_id_20, r0_.profile_driver_id AS profile_driver_id_21, r0_.car_id AS car_id_22 FROM ride_event r0_ WHERE r0_.admin_confirm = 1 ORDER BY r0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 79)
7	App\Repository\RideEventRepository->findBySearch (line 57)
8	App\Controller\Public\RideEventController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.60 ms
(24.40%)

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.title AS title_3, t0.html_text AS html_text_4, t0.created_at AS created_at_5, t0.html_text_en AS html_text_en_6, t0.title_en AS title_en_7, t0.e_accueil AS e_accueil_8, t0.entreprise_id AS entreprise_id_9 FROM page_public t0 WHERE t0.entreprise_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.title AS title_3,
  t0.html_text AS html_text_4,
  t0.created_at AS created_at_5,
  t0.html_text_en AS html_text_en_6,
  t0.title_en AS title_en_7,
  t0.e_accueil AS e_accueil_8,
  t0.entreprise_id AS entreprise_id_9
FROM
  page_public t0
WHERE
  t0.entreprise_id = ?

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.title AS title_3, t0.html_text AS html_text_4, t0.created_at AS created_at_5, t0.html_text_en AS html_text_en_6, t0.title_en AS title_en_7, t0.e_accueil AS e_accueil_8, t0.entreprise_id AS entreprise_id_9 FROM page_public t0 WHERE t0.entreprise_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 33)
4	App\Service\PublicPageTwigService->getAllPublicPage (line 1754)
5	Twig\Extension\CoreExtension::getAttribute (line 96)
6	__TwigTemplate_9ded4b8d057c9cf767746fb22b48a28b->doDisplay (line 393)
7	Twig\Template->yield (line 718)
8	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->block_footer (line 437)
9	Twig\Template->yieldBlock (line 401)
10	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_b3a90a3998d1b419fc3c556972af17d8->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 243)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
20	App\Controller\Public\RideEventController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.48 ms
(19.31%)

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.phone AS phone_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.e_actif AS e_actif_9, t10.id AS id_11, t10.couleur_primaire AS couleur_primaire_12, t10.couleur_secondaire AS couleur_secondaire_13, t10.couleur_sombre AS couleur_sombre_14, t10.couleur_information AS couleur_information_15, t10.afficher_pub AS afficher_pub_16, t10.lien_dans_principal AS lien_dans_principal_17, t10.trajet_dans_principal AS trajet_dans_principal_18, t10.entreprise_id AS entreprise_id_19 FROM entreprise t0 LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.raison_social AS raison_social_2,
  t0.phone AS phone_3,
  t0.adresse AS adresse_4,
  t0.ville AS ville_5,
  t0.pays AS pays_6,
  t0.logo AS logo_7,
  t0.slug AS slug_8,
  t0.e_actif AS e_actif_9,
  t10.id AS id_11,
  t10.couleur_primaire AS couleur_primaire_12,
  t10.couleur_secondaire AS couleur_secondaire_13,
  t10.couleur_sombre AS couleur_sombre_14,
  t10.couleur_information AS couleur_information_15,
  t10.afficher_pub AS afficher_pub_16,
  t10.lien_dans_principal AS lien_dans_principal_17,
  t10.trajet_dans_principal AS trajet_dans_principal_18,
  t10.entreprise_id AS entreprise_id_19
FROM
  entreprise t0
  LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.phone AS phone_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.e_actif AS e_actif_9, t10.id AS id_11, t10.couleur_primaire AS couleur_primaire_12, t10.couleur_secondaire AS couleur_secondaire_13, t10.couleur_sombre AS couleur_sombre_14, t10.couleur_information AS couleur_information_15, t10.afficher_pub AS afficher_pub_16, t10.lien_dans_principal AS lien_dans_principal_17, t10.trajet_dans_principal AS trajet_dans_principal_18, t10.entreprise_id AS entreprise_id_19 FROM entreprise t0 LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 27)
5	App\Service\EntrepriseTwigService->getEntrepriseVisible (line 1754)
6	Twig\Extension\CoreExtension::getAttribute (line 231)
7	__TwigTemplate_7f0ccb1c82fe381ef635df3191c1c14f->doDisplay (line 393)
8	Twig\Template->yield (line 667)
9	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->block_navbar (line 437)
10	Twig\Template->yieldBlock (line 387)
11	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
12	Twig\Template->yield (line 56)
13	__TwigTemplate_b3a90a3998d1b419fc3c556972af17d8->doDisplay (line 393)
14	Twig\Template->yield (line 349)
15	Twig\Template->display (line 364)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
21	App\Controller\Public\RideEventController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.38 ms
(15.26%)

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.phone AS phone_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.e_actif AS e_actif_9, t10.id AS id_11, t10.couleur_primaire AS couleur_primaire_12, t10.couleur_secondaire AS couleur_secondaire_13, t10.couleur_sombre AS couleur_sombre_14, t10.couleur_information AS couleur_information_15, t10.afficher_pub AS afficher_pub_16, t10.lien_dans_principal AS lien_dans_principal_17, t10.trajet_dans_principal AS trajet_dans_principal_18, t10.entreprise_id AS entreprise_id_19 FROM entreprise t0 LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.raison_social AS raison_social_2,
  t0.phone AS phone_3,
  t0.adresse AS adresse_4,
  t0.ville AS ville_5,
  t0.pays AS pays_6,
  t0.logo AS logo_7,
  t0.slug AS slug_8,
  t0.e_actif AS e_actif_9,
  t10.id AS id_11,
  t10.couleur_primaire AS couleur_primaire_12,
  t10.couleur_secondaire AS couleur_secondaire_13,
  t10.couleur_sombre AS couleur_sombre_14,
  t10.couleur_information AS couleur_information_15,
  t10.afficher_pub AS afficher_pub_16,
  t10.lien_dans_principal AS lien_dans_principal_17,
  t10.trajet_dans_principal AS trajet_dans_principal_18,
  t10.entreprise_id AS entreprise_id_19
FROM
  entreprise t0
  LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.phone AS phone_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.e_actif AS e_actif_9, t10.id AS id_11, t10.couleur_primaire AS couleur_primaire_12, t10.couleur_secondaire AS couleur_secondaire_13, t10.couleur_sombre AS couleur_sombre_14, t10.couleur_information AS couleur_information_15, t10.afficher_pub AS afficher_pub_16, t10.lien_dans_principal AS lien_dans_principal_17, t10.trajet_dans_principal AS trajet_dans_principal_18, t10.entreprise_id AS entreprise_id_19 FROM entreprise t0 LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 47)
6	App\Service\EntrepriseTwigService->getConfigEntreprise (line 1754)
7	Twig\Extension\CoreExtension::getAttribute (line 48)
8	__TwigTemplate_cbc2f885dc697f13613ac8ea56374226->doDisplay (line 393)
9	Twig\Template->yield (line 109)
10	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_b3a90a3998d1b419fc3c556972af17d8->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 243)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
20	App\Controller\Public\RideEventController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.29 ms
(11.85%)

SELECT t0.id AS id_1, t0.admin_address AS admin_address_2, t0.relation_reservation AS relation_reservation_3, t0.phone_number AS phone_number_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.twiter AS twiter_7, t0.linked_in AS linked_in_8, t0.mode AS mode_9, t0.api_key AS api_key_10, t0.api_site AS api_site_11, t0.secret_key AS secret_key_12, t0.money_key AS money_key_13, t0.language AS language_14, t0.entreprise_id AS entreprise_id_15 FROM parameter t0 WHERE t0.entreprise_id = ? LIMIT 1

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.admin_address AS admin_address_2,
  t0.relation_reservation AS relation_reservation_3,
  t0.phone_number AS phone_number_4,
  t0.facebook AS facebook_5,
  t0.instagram AS instagram_6,
  t0.twiter AS twiter_7,
  t0.linked_in AS linked_in_8,
  t0.mode AS mode_9,
  t0.api_key AS api_key_10,
  t0.api_site AS api_site_11,
  t0.secret_key AS secret_key_12,
  t0.money_key AS money_key_13,
  t0.language AS language_14,
  t0.entreprise_id AS entreprise_id_15
FROM
  parameter t0
WHERE
  t0.entreprise_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.admin_address AS admin_address_2, t0.relation_reservation AS relation_reservation_3, t0.phone_number AS phone_number_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.twiter AS twiter_7, t0.linked_in AS linked_in_8, t0.mode AS mode_9, t0.api_key AS api_key_10, t0.api_site AS api_site_11, t0.secret_key AS secret_key_12, t0.money_key AS money_key_13, t0.language AS language_14, t0.entreprise_id AS entreprise_id_15 FROM parameter t0 WHERE t0.entreprise_id = 2 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	App\Service\PublicPageTwigService->getParams (line 1754)
5	Twig\Extension\CoreExtension::getAttribute (line 65)
6	__TwigTemplate_9ded4b8d057c9cf767746fb22b48a28b->doDisplay (line 393)
7	Twig\Template->yield (line 718)
8	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->block_footer (line 437)
9	Twig\Template->yieldBlock (line 401)
10	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_b3a90a3998d1b419fc3c556972af17d8->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 243)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
20	App\Controller\Public\RideEventController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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
App\Entity\RideEvent	No errors.
App\Entity\User	No errors.
App\Entity\ProfileDriver	No errors.
App\Entity\Car	No errors.
App\Entity\Reservation	No errors.
App\Entity\Entreprise	No errors.
App\Entity\ConfigEntreprise	No errors.
App\Entity\Abonnement	No errors.
App\Entity\PagePublic	No errors.
App\Entity\Parameter	No errors.

Symfony Profiler

GET https://myecocar.devsoft-pro.com/ride/event/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping