Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

13.35 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.75 ms
(95.48%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.profile_filename AS profile_filename_3, f0_.departement AS departement_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.secteur AS secteur_7, f0_.mail AS mail_8, f0_.phone AS phone_9, f0_.fiche_google AS fiche_google_10, f0_.services AS services_11, f0_.siret AS siret_12, f0_.seo_title AS seo_title_13, f0_.seo_content AS seo_content_14, f0_.is_ads_word AS is_ads_word_15, f0_.title_home_site AS title_home_site_16, f0_.subdomain AS subdomain_17, f0_.presentation AS presentation_18, f0_.title_service AS title_service_19, f0_.description_service AS description_service_20, f0_.title_service_2 AS title_service_2_21, f0_.description_service_2 AS description_service_2_22, f0_.home_filename AS home_filename_23 FROM franchise f0_ LEFT JOIN franchise_cities f2_ ON f0_.id = f2_.franchise_id LEFT JOIN cities c1_ ON c1_.id = f2_.cities_id WHERE f0_.mail <> ? ORDER BY f0_.created_at DESC

Parameters:

[
  "t.belorgeot@beescom.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.description AS description_2,
  f0_.profile_filename AS profile_filename_3,
  f0_.departement AS departement_4,
  f0_.created_at AS created_at_5,
  f0_.updated_at AS updated_at_6,
  f0_.secteur AS secteur_7,
  f0_.mail AS mail_8,
  f0_.phone AS phone_9,
  f0_.fiche_google AS fiche_google_10,
  f0_.services AS services_11,
  f0_.siret AS siret_12,
  f0_.seo_title AS seo_title_13,
  f0_.seo_content AS seo_content_14,
  f0_.is_ads_word AS is_ads_word_15,
  f0_.title_home_site AS title_home_site_16,
  f0_.subdomain AS subdomain_17,
  f0_.presentation AS presentation_18,
  f0_.title_service AS title_service_19,
  f0_.description_service AS description_service_20,
  f0_.title_service_2 AS title_service_2_21,
  f0_.description_service_2 AS description_service_2_22,
  f0_.home_filename AS home_filename_23
FROM
  franchise f0_
  LEFT JOIN franchise_cities f2_ ON f0_.id = f2_.franchise_id
  LEFT JOIN cities c1_ ON c1_.id = f2_.cities_id
WHERE
  f0_.mail <> ?
ORDER BY
  f0_.created_at DESC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.profile_filename AS profile_filename_3, f0_.departement AS departement_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.secteur AS secteur_7, f0_.mail AS mail_8, f0_.phone AS phone_9, f0_.fiche_google AS fiche_google_10, f0_.services AS services_11, f0_.siret AS siret_12, f0_.seo_title AS seo_title_13, f0_.seo_content AS seo_content_14, f0_.is_ads_word AS is_ads_word_15, f0_.title_home_site AS title_home_site_16, f0_.subdomain AS subdomain_17, f0_.presentation AS presentation_18, f0_.title_service AS title_service_19, f0_.description_service AS description_service_20, f0_.title_service_2 AS title_service_2_21, f0_.description_service_2 AS description_service_2_22, f0_.home_filename AS home_filename_23 FROM franchise f0_ LEFT JOIN franchise_cities f2_ ON f0_.id = f2_.franchise_id LEFT JOIN cities c1_ ON c1_.id = f2_.cities_id WHERE f0_.mail <> 't.belorgeot@beescom.fr' ORDER BY f0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 50)
7	App\Repository\FranchiseRepository->findSearch (line 303)
8	App\Controller\BaseController->proProche (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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
(4.52%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.profile_filename AS profile_filename_4, t0.departement AS departement_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.secteur AS secteur_8, t0.mail AS mail_9, t0.phone AS phone_10, t0.fiche_google AS fiche_google_11, t0.services AS services_12, t0.siret AS siret_13, t0.seo_title AS seo_title_14, t0.seo_content AS seo_content_15, t0.is_ads_word AS is_ads_word_16, t0.title_home_site AS title_home_site_17, t0.subdomain AS subdomain_18, t0.presentation AS presentation_19, t0.title_service AS title_service_20, t0.description_service AS description_service_21, t0.title_service_2 AS title_service_2_22, t0.description_service_2 AS description_service_2_23, t0.home_filename AS home_filename_24 FROM franchise t0 WHERE t0.mail = ? LIMIT 1

Parameters:

[
  "francis.moreau@abeille-verte.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.profile_filename AS profile_filename_4,
  t0.departement AS departement_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.secteur AS secteur_8,
  t0.mail AS mail_9,
  t0.phone AS phone_10,
  t0.fiche_google AS fiche_google_11,
  t0.services AS services_12,
  t0.siret AS siret_13,
  t0.seo_title AS seo_title_14,
  t0.seo_content AS seo_content_15,
  t0.is_ads_word AS is_ads_word_16,
  t0.title_home_site AS title_home_site_17,
  t0.subdomain AS subdomain_18,
  t0.presentation AS presentation_19,
  t0.title_service AS title_service_20,
  t0.description_service AS description_service_21,
  t0.title_service_2 AS title_service_2_22,
  t0.description_service_2 AS description_service_2_23,
  t0.home_filename AS home_filename_24
FROM
  franchise t0
WHERE
  t0.mail = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.profile_filename AS profile_filename_4, t0.departement AS departement_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.secteur AS secteur_8, t0.mail AS mail_9, t0.phone AS phone_10, t0.fiche_google AS fiche_google_11, t0.services AS services_12, t0.siret AS siret_13, t0.seo_title AS seo_title_14, t0.seo_content AS seo_content_15, t0.is_ads_word AS is_ads_word_16, t0.title_home_site AS title_home_site_17, t0.subdomain AS subdomain_18, t0.presentation AS presentation_19, t0.title_service AS title_service_20, t0.description_service AS description_service_21, t0.title_service_2 AS title_service_2_22, t0.description_service_2 AS description_service_2_23, t0.home_filename AS home_filename_24 FROM franchise t0 WHERE t0.mail = 'francis.moreau@abeille-verte.fr' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 304)
5	App\Controller\BaseController->proProche (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Cities	No errors.
App\Entity\Franchise	No errors.
App\Entity\Avis	No errors.
App\Entity\Realisation	No errors.
App\Entity\ContactWebsitePro	No errors.
App\Entity\Actuality	No errors.
App\Entity\DevisWebsite	No errors.

Symfony Profiler

GET https://troyes.abeille-verte.fr/pro-proche

Configuration Settings

Theme