Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.89 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.79 ms

SELECT r0_.id AS id_0, r0_.departure_label AS departure_label_1, r0_.departure_longitude AS departure_longitude_2, r0_.departure_latitude AS departure_latitude_3, r0_.arrival_label AS arrival_label_4, r0_.arrival_longitude AS arrival_longitude_5, r0_.arrival_latitude AS arrival_latitude_6, r0_.departure_place_id AS departure_place_id_7, r0_.arrival_place_id AS arrival_place_id_8, r0_.meeting_place AS meeting_place_9, r0_.date_depart AS date_depart_10, r0_.created_at AS created_at_11, r0_.updated_at AS updated_at_12, r0_.place_request AS place_request_13, r0_.bagage AS bagage_14, r0_.femaly_only AS femaly_only_15, r0_.user_id AS user_id_16, r0_.profile_passenger_id AS profile_passenger_id_17 FROM ride_request r0_ WHERE r0_.date_depart <> 0 ORDER BY r0_.date_depart ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.departure_label AS departure_label_1,
  r0_.departure_longitude AS departure_longitude_2,
  r0_.departure_latitude AS departure_latitude_3,
  r0_.arrival_label AS arrival_label_4,
  r0_.arrival_longitude AS arrival_longitude_5,
  r0_.arrival_latitude AS arrival_latitude_6,
  r0_.departure_place_id AS departure_place_id_7,
  r0_.arrival_place_id AS arrival_place_id_8,
  r0_.meeting_place AS meeting_place_9,
  r0_.date_depart AS date_depart_10,
  r0_.created_at AS created_at_11,
  r0_.updated_at AS updated_at_12,
  r0_.place_request AS place_request_13,
  r0_.bagage AS bagage_14,
  r0_.femaly_only AS femaly_only_15,
  r0_.user_id AS user_id_16,
  r0_.profile_passenger_id AS profile_passenger_id_17
FROM
  ride_request r0_
WHERE
  r0_.date_depart <> 0
ORDER BY
  r0_.date_depart ASC

SELECT r0_.id AS id_0, r0_.departure_label AS departure_label_1, r0_.departure_longitude AS departure_longitude_2, r0_.departure_latitude AS departure_latitude_3, r0_.arrival_label AS arrival_label_4, r0_.arrival_longitude AS arrival_longitude_5, r0_.arrival_latitude AS arrival_latitude_6, r0_.departure_place_id AS departure_place_id_7, r0_.arrival_place_id AS arrival_place_id_8, r0_.meeting_place AS meeting_place_9, r0_.date_depart AS date_depart_10, r0_.created_at AS created_at_11, r0_.updated_at AS updated_at_12, r0_.place_request AS place_request_13, r0_.bagage AS bagage_14, r0_.femaly_only AS femaly_only_15, r0_.user_id AS user_id_16, r0_.profile_passenger_id AS profile_passenger_id_17 FROM ride_request r0_ WHERE r0_.date_depart <> 0 ORDER BY r0_.date_depart ASC;

#	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 77)
7	App\Repository\RideRequestRepository->findBySearch (line 61)
8	App\Controller\Public\RideRequestController->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.40 ms

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 57)
13	__TwigTemplate_d080c1afa036f71c828710cf1df9bd31->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 90)
21	App\Controller\Public\RideRequestController->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.40 ms

SELECT p0_.id AS id_0, p0_.admin_address AS admin_address_1, p0_.relation_reservation AS relation_reservation_2, p0_.phone_number AS phone_number_3, p0_.facebook AS facebook_4, p0_.instagram AS instagram_5, p0_.twiter AS twiter_6, p0_.linked_in AS linked_in_7, p0_.mode AS mode_8, p0_.api_key AS api_key_9, p0_.api_site AS api_site_10, p0_.secret_key AS secret_key_11, p0_.money_key AS money_key_12, p0_.language AS language_13, p0_.entreprise_id AS entreprise_id_14 FROM parameter p0_ WHERE p0_.entreprise_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.admin_address AS admin_address_1,
  p0_.relation_reservation AS relation_reservation_2,
  p0_.phone_number AS phone_number_3,
  p0_.facebook AS facebook_4,
  p0_.instagram AS instagram_5,
  p0_.twiter AS twiter_6,
  p0_.linked_in AS linked_in_7,
  p0_.mode AS mode_8,
  p0_.api_key AS api_key_9,
  p0_.api_site AS api_site_10,
  p0_.secret_key AS secret_key_11,
  p0_.money_key AS money_key_12,
  p0_.language AS language_13,
  p0_.entreprise_id AS entreprise_id_14
FROM
  parameter p0_
WHERE
  p0_.entreprise_id IS NULL

SELECT p0_.id AS id_0, p0_.admin_address AS admin_address_1, p0_.relation_reservation AS relation_reservation_2, p0_.phone_number AS phone_number_3, p0_.facebook AS facebook_4, p0_.instagram AS instagram_5, p0_.twiter AS twiter_6, p0_.linked_in AS linked_in_7, p0_.mode AS mode_8, p0_.api_key AS api_key_9, p0_.api_site AS api_site_10, p0_.secret_key AS secret_key_11, p0_.money_key AS money_key_12, p0_.language AS language_13, p0_.entreprise_id AS entreprise_id_14 FROM parameter p0_ WHERE p0_.entreprise_id IS NULL;

#	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 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 87)
7	App\Service\PublicPageTwigService->getParams (line 1754)
8	Twig\Extension\CoreExtension::getAttribute (line 65)
9	__TwigTemplate_9ded4b8d057c9cf767746fb22b48a28b->doDisplay (line 393)
10	Twig\Template->yield (line 718)
11	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->block_footer (line 437)
12	Twig\Template->yieldBlock (line 401)
13	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_d080c1afa036f71c828710cf1df9bd31->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 90)
23	App\Controller\Public\RideRequestController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.29 ms

SELECT p0_.id AS id_0, p0_.lien AS lien_1, p0_.title AS title_2, p0_.html_text AS html_text_3, p0_.created_at AS created_at_4, p0_.html_text_en AS html_text_en_5, p0_.title_en AS title_en_6, p0_.e_accueil AS e_accueil_7, p0_.entreprise_id AS entreprise_id_8 FROM page_public p0_ WHERE p0_.entreprise_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.lien AS lien_1,
  p0_.title AS title_2,
  p0_.html_text AS html_text_3,
  p0_.created_at AS created_at_4,
  p0_.html_text_en AS html_text_en_5,
  p0_.title_en AS title_en_6,
  p0_.e_accueil AS e_accueil_7,
  p0_.entreprise_id AS entreprise_id_8
FROM
  page_public p0_
WHERE
  p0_.entreprise_id IS NULL

SELECT p0_.id AS id_0, p0_.lien AS lien_1, p0_.title AS title_2, p0_.html_text AS html_text_3, p0_.created_at AS created_at_4, p0_.html_text_en AS html_text_en_5, p0_.title_en AS title_en_6, p0_.e_accueil AS e_accueil_7, p0_.entreprise_id AS entreprise_id_8 FROM page_public p0_ WHERE p0_.entreprise_id IS NULL;

#	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 39)
7	App\Service\PublicPageTwigService->getAllPublicPage (line 1754)
8	Twig\Extension\CoreExtension::getAttribute (line 96)
9	__TwigTemplate_9ded4b8d057c9cf767746fb22b48a28b->doDisplay (line 393)
10	Twig\Template->yield (line 718)
11	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->block_footer (line 437)
12	Twig\Template->yieldBlock (line 401)
13	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_d080c1afa036f71c828710cf1df9bd31->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 90)
23	App\Controller\Public\RideRequestController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\RideRequest	No errors.
App\Entity\User	No errors.
App\Entity\ProfilePassenger	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-request/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping