Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

9.56 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.54 ms
(57.98%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.top_image AS top_image_3, t0.site_link AS site_link_4, t0.text AS text_5, t0.coordinates AS coordinates_6, t0.slug AS slug_7, t0.top_image_alt AS top_image_alt_8, t0.bottom_image AS bottom_image_9, t0.bottom_image_alt AS bottom_image_alt_10, t0.annee_label AS annee_label_11, t0.departement_id AS departement_id_12, t0.label_id AS label_id_13 FROM ville_active t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.top_image AS top_image_3,
  t0.site_link AS site_link_4,
  t0.text AS text_5,
  t0.coordinates AS coordinates_6,
  t0.slug AS slug_7,
  t0.top_image_alt AS top_image_alt_8,
  t0.bottom_image AS bottom_image_9,
  t0.bottom_image_alt AS bottom_image_alt_10,
  t0.annee_label AS annee_label_11,
  t0.departement_id AS departement_id_12,
  t0.label_id AS label_id_13
FROM
  ville_active t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.top_image AS top_image_3, t0.site_link AS site_link_4, t0.text AS text_5, t0.coordinates AS coordinates_6, t0.slug AS slug_7, t0.top_image_alt AS top_image_alt_8, t0.bottom_image AS bottom_image_9, t0.bottom_image_alt AS bottom_image_alt_10, t0.annee_label AS annee_label_11, t0.departement_id AS departement_id_12, t0.label_id AS label_id_13 FROM ville_active t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 38)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.18 ms
(12.37%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.image AS image_4 FROM label t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.image AS image_4
FROM
  label t0

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.image AS image_4 FROM label t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 33)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.80 ms
(8.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.region_id AS region_id_4 FROM departement t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.region_id AS region_id_4
FROM
  departement t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.region_id AS region_id_4 FROM departement t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 36)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.71 ms
(7.44%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.image AS image_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.image_alt AS image_alt_7, a0_.seo_title AS seo_title_8, a0_.seo_description AS seo_description_9, a0_.seo_keywords AS seo_keywords_10, a0_.slug AS slug_11 FROM article a0_ ORDER BY a0_.updated_at DESC LIMIT 6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.image AS image_3,
  a0_.content AS content_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.image_alt AS image_alt_7,
  a0_.seo_title AS seo_title_8,
  a0_.seo_description AS seo_description_9,
  a0_.seo_keywords AS seo_keywords_10,
  a0_.slug AS slug_11
FROM
  article a0_
ORDER BY
  a0_.updated_at DESC
LIMIT
  6

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.image AS image_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.image_alt AS image_alt_7, a0_.seo_title AS seo_title_8, a0_.seo_description AS seo_description_9, a0_.seo_keywords AS seo_keywords_10, a0_.slug AS slug_11 FROM article a0_ ORDER BY a0_.updated_at DESC LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 55)
7	App\Repository\ArticleRepository->findLimitedValue (line 42)
8	App\Controller\HomeController->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.71 ms
(7.42%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM region t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  region t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM region t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 34)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.61 ms
(6.41%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.presentation AS presentation_3, t0.image AS image_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.image_alt AS image_alt_7, t0.seo_keywords AS seo_keywords_8 FROM home_page t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.presentation AS presentation_3,
  t0.image AS image_4,
  t0.seo_title AS seo_title_5,
  t0.seo_description AS seo_description_6,
  t0.image_alt AS image_alt_7,
  t0.seo_keywords AS seo_keywords_8
FROM
  home_page t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.presentation AS presentation_3, t0.image AS image_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.image_alt AS image_alt_7, t0.seo_keywords AS seo_keywords_8 FROM home_page t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 40)
4	App\Controller\HomeController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\Label	No errors.
App\Entity\VilleActive	No errors.
App\Entity\Region	No errors.
App\Entity\Departement	No errors.
App\Entity\Candidat	No errors.
App\Entity\HomePage	No errors.
App\Entity\Article	No errors.

Symfony Profiler

GET https://preprod.ville-active.com-clients.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping