Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.84 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.64 ms
(42.68%)

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 56)
15	__TwigTemplate_25408b4c718318fc635bffe3d7a6427c->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 97)
23	App\Controller\Public\RidePurposeController->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.18 ms
(30.79%)

SELECT r0_.id AS id_0, r0_.date AS date_1, r0_.avaible_place AS avaible_place_2, r0_.direction AS direction_3, r0_.ride_purpose_id AS ride_purpose_id_4 FROM ride_purpose_date_and_place r0_ LEFT JOIN ride_purpose r1_ ON r0_.ride_purpose_id = r1_.id WHERE r1_.admin_confirm = 1 ORDER BY r0_.date ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.date AS date_1,
  r0_.avaible_place AS avaible_place_2,
  r0_.direction AS direction_3,
  r0_.ride_purpose_id AS ride_purpose_id_4
FROM
  ride_purpose_date_and_place r0_
  LEFT JOIN ride_purpose r1_ ON r0_.ride_purpose_id = r1_.id
WHERE
  r1_.admin_confirm = 1
ORDER BY
  r0_.date ASC

SELECT r0_.id AS id_0, r0_.date AS date_1, r0_.avaible_place AS avaible_place_2, r0_.direction AS direction_3, r0_.ride_purpose_id AS ride_purpose_id_4 FROM ride_purpose_date_and_place r0_ LEFT JOIN ride_purpose r1_ ON r0_.ride_purpose_id = r1_.id WHERE r1_.admin_confirm = 1 ORDER BY r0_.date 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 86)
7	App\Repository\RidePurposeDateAndPlaceRepository->findBySearch (line 65)
8	App\Controller\Public\RidePurposeController->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.61 ms
(15.79%)

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_25408b4c718318fc635bffe3d7a6427c->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 97)
21	App\Controller\Public\RidePurposeController->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.41 ms
(10.74%)

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 56)
15	__TwigTemplate_25408b4c718318fc635bffe3d7a6427c->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 97)
23	App\Controller\Public\RidePurposeController->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\RidePurposeDateAndPlace	No errors.
App\Entity\RidePurpose	No errors.
App\Entity\Reservation	No errors.
App\Entity\Entreprise	No errors.
App\Entity\ConfigEntreprise	No errors.
App\Entity\User	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-purpose/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping