Symfony Profiler

Query Metrics

11 Database Queries

3 Different statements

6.17 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.92 ms
(63.61%)

SELECT t1.id AS id_2, t1.target AS target_3, t1.pages AS pages_4, t1.downloads AS downloads_5, t1.reading AS reading_6, t1.name AS name_7, t1.dir AS dir_8, t1.source AS source_9, t1.size AS size_10, t1.is_enabled AS is_enabled_11, t1.is_deleted AS is_deleted_12, t1.last_update AS last_update_13, t1.created_at AS created_at_14, t1.format_size AS format_size_15, t1.mimetype AS mimetype_16, t1.uuid AS uuid_17, t1.view_strategy AS view_strategy_18, t0.thumbnail_dir AS thumbnail_dir_19, t0.has_thumbnail AS has_thumbnail_20, t1.created_by_id AS created_by_id_21, t1.type FROM picture t0 INNER JOIN FILE t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.target AS target_3,
  t1.pages AS pages_4,
  t1.downloads AS downloads_5,
  t1.reading AS reading_6,
  t1.name AS name_7,
  t1.dir AS dir_8,
  t1.source AS source_9,
  t1.size AS size_10,
  t1.is_enabled AS is_enabled_11,
  t1.is_deleted AS is_deleted_12,
  t1.last_update AS last_update_13,
  t1.created_at AS created_at_14,
  t1.format_size AS format_size_15,
  t1.mimetype AS mimetype_16,
  t1.uuid AS uuid_17,
  t1.view_strategy AS view_strategy_18,
  t0.thumbnail_dir AS thumbnail_dir_19,
  t0.has_thumbnail AS has_thumbnail_20,
  t1.created_by_id AS created_by_id_21,
  t1.type
FROM
  picture t0
  INNER JOIN FILE t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.target AS target_3, t1.pages AS pages_4, t1.downloads AS downloads_5, t1.reading AS reading_6, t1.name AS name_7, t1.dir AS dir_8, t1.source AS source_9, t1.size AS size_10, t1.is_enabled AS is_enabled_11, t1.is_deleted AS is_deleted_12, t1.last_update AS last_update_13, t1.created_at AS created_at_14, t1.format_size AS format_size_15, t1.mimetype AS mimetype_16, t1.uuid AS uuid_17, t1.view_strategy AS view_strategy_18, t0.thumbnail_dir AS thumbnail_dir_19, t0.has_thumbnail AS has_thumbnail_20, t1.created_by_id AS created_by_id_21, t1.type FROM picture t0 INNER JOIN FILE t1 ON t0.id = t1.id WHERE t1.id = 24;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\File\Picture->__get (line 199)
7	App\Entity\File\File->getDir (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 1859)
9	__TwigTemplate_cafd0170a410135da0368521428c1065->{closure} (line 1775)
10	Twig\Extension\CoreExtension::captureOutput (line 1892)
11	__TwigTemplate_cafd0170a410135da0368521428c1065->macro_service (line 1228)
12	Twig\Extension\CoreExtension::callMacro (line 139)
13	__TwigTemplate_e45e0cdbd3304fb3d3b7052814aa65e7->block_content (line 430)
14	Twig\Template->yieldBlock (line 1200)
15	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_body (line 430)
16	Twig\Template->yieldBlock (line 1058)
17	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_container (line 430)
18	Twig\Template->yieldBlock (line 197)
19	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_html (line 430)
20	Twig\Template->yieldBlock (line 96)
21	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->{closure} (line 1775)
22	Twig\Extension\CoreExtension::captureOutput (line 98)
23	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->doDisplay (line 360)
24	Twig\Template->yield (line 56)
25	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->doDisplay (line 360)
26	Twig\Template->yield (line 59)
27	__TwigTemplate_e45e0cdbd3304fb3d3b7052814aa65e7->doDisplay (line 360)
28	Twig\Template->yield (line 335)
29	Twig\Template->render (line 38)
30	Twig\TemplateWrapper->render (line 307)
31	Twig\Environment->render (line 448)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 183)
35	App\Controller\DefaultController->getListServices (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

1.42 ms
(23.04%)

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_enabled AS is_enabled_8, t0.banner_id AS banner_id_9 FROM articles_categories t0 WHERE t0.is_enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.id AS id_4,
  t0.uuid AS uuid_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.is_enabled AS is_enabled_8,
  t0.banner_id AS banner_id_9
FROM
  articles_categories t0
WHERE
  t0.is_enabled = ?

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_enabled AS is_enabled_8, t0.banner_id AS banner_id_9 FROM articles_categories t0 WHERE t0.is_enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 30)
5	App\EventSubscriber\HandleMenu->onKernelRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.82 ms
(13.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.subdescription AS subdescription_4, t0.details AS details_5, t0.details_description_avantage AS details_description_avantage_6, t0.position AS position_7, t0.is_enabled AS is_enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.slug AS slug_11, t0.banner_id AS banner_id_12, t0.icon_banner_id AS icon_banner_id_13 FROM services t0 WHERE t0.is_enabled = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

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.subdescription AS subdescription_4,
  t0.details AS details_5,
  t0.details_description_avantage AS details_description_avantage_6,
  t0.position AS position_7,
  t0.is_enabled AS is_enabled_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.slug AS slug_11,
  t0.banner_id AS banner_id_12,
  t0.icon_banner_id AS icon_banner_id_13
FROM
  services t0
WHERE
  t0.is_enabled = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.subdescription AS subdescription_4, t0.details AS details_5, t0.details_description_avantage AS details_description_avantage_6, t0.position AS position_7, t0.is_enabled AS is_enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.slug AS slug_11, t0.banner_id AS banner_id_12, t0.icon_banner_id AS icon_banner_id_13 FROM services t0 WHERE t0.is_enabled = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 176)
5	App\Controller\DefaultController->getListServices (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)

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\Article\ArticlesCategories	No errors.
App\Entity\File\File	No errors.
App\Entity\File\Picture	No errors.
App\Entity\Services	No errors.
App\Entity\Specialite	No errors.
App\Entity\Users	No errors.

Symfony Profiler

GET https://cliniqueserena.com/services

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping