Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.27 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.09 ms
(49.28%)

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.url AS url_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM partners t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.url AS url_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  partners t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.url AS url_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM partners t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 125)
4	App\TwigExtensions\AppExtension->widgetPartners (line 174)
5	__TwigTemplate_1ba1eb192bd98f364b1f1001be4f1394->block_body (line 171)
6	Twig\Template->displayBlock (line 89)
7	__TwigTemplate_6691218cc67caf35564ba108619d97b2->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 48)
10	__TwigTemplate_1ba1eb192bd98f364b1f1001be4f1394->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
18	App\Controller\HomeController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.82 ms
(28.93%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.text_1 AS text_1_3, t0.text_2 AS text_2_4, t0.picture_page AS picture_page_5, t0.picture_text AS picture_text_6, t0.picture_pres AS picture_pres_7, t0.picture_pres_hover AS picture_pres_hover_8, t0.pos AS pos_9, t0.tag AS tag_10, t0.updated_at AS updated_at_11 FROM services t0 ORDER BY t0.pos ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.text_1 AS text_1_3,
  t0.text_2 AS text_2_4,
  t0.picture_page AS picture_page_5,
  t0.picture_text AS picture_text_6,
  t0.picture_pres AS picture_pres_7,
  t0.picture_pres_hover AS picture_pres_hover_8,
  t0.pos AS pos_9,
  t0.tag AS tag_10,
  t0.updated_at AS updated_at_11
FROM
  services t0
ORDER BY
  t0.pos ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.text_1 AS text_1_3, t0.text_2 AS text_2_4, t0.picture_page AS picture_page_5, t0.picture_text AS picture_text_6, t0.picture_pres AS picture_pres_7, t0.picture_pres_hover AS picture_pres_hover_8, t0.pos AS pos_9, t0.tag AS tag_10, t0.updated_at AS updated_at_11 FROM services t0 ORDER BY t0.pos ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 44)
4	App\TwigExtensions\AppExtension->widgetServices (line 133)
5	__TwigTemplate_1ba1eb192bd98f364b1f1001be4f1394->block_body (line 171)
6	Twig\Template->displayBlock (line 89)
7	__TwigTemplate_6691218cc67caf35564ba108619d97b2->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 48)
10	__TwigTemplate_1ba1eb192bd98f364b1f1001be4f1394->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
18	App\Controller\HomeController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.70 ms
(11.21%)

SELECT t0.id AS id_1, t0.picture_text AS picture_text_2, t0.picture_pres AS picture_pres_3, t0.picture_pres_hover AS picture_pres_hover_4, t0.title AS title_5, t0.text AS text_6, t0.duration AS duration_7, t0.allowed_to_appointment AS allowed_to_appointment_8, t0.duration_to_book AS duration_to_book_9, t0.updated_at AS updated_at_10 FROM specialities t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.picture_text AS picture_text_2,
  t0.picture_pres AS picture_pres_3,
  t0.picture_pres_hover AS picture_pres_hover_4,
  t0.title AS title_5,
  t0.text AS text_6,
  t0.duration AS duration_7,
  t0.allowed_to_appointment AS allowed_to_appointment_8,
  t0.duration_to_book AS duration_to_book_9,
  t0.updated_at AS updated_at_10
FROM
  specialities t0

SELECT t0.id AS id_1, t0.picture_text AS picture_text_2, t0.picture_pres AS picture_pres_3, t0.picture_pres_hover AS picture_pres_hover_4, t0.title AS title_5, t0.text AS text_6, t0.duration AS duration_7, t0.allowed_to_appointment AS allowed_to_appointment_8, t0.duration_to_book AS duration_to_book_9, t0.updated_at AS updated_at_10 FROM specialities t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 77)
5	App\TwigExtensions\AppExtension->widgetSpecialities (line 137)
6	__TwigTemplate_1ba1eb192bd98f364b1f1001be4f1394->block_body (line 171)
7	Twig\Template->displayBlock (line 89)
8	__TwigTemplate_6691218cc67caf35564ba108619d97b2->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 48)
11	__TwigTemplate_1ba1eb192bd98f364b1f1001be4f1394->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 40)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 243)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
19	App\Controller\HomeController->index (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.66 ms
(10.58%)

SELECT t0.id AS id_1, t0.customer AS customer_2, t0.content AS content_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM notices t0 WHERE t0.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.customer AS customer_2,
  t0.content AS content_3,
  t0.enabled AS enabled_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  notices t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.customer AS customer_2, t0.content AS content_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM notices t0 WHERE t0.enabled = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 117)
4	App\TwigExtensions\AppExtension->widgetNotices (line 170)
5	__TwigTemplate_1ba1eb192bd98f364b1f1001be4f1394->block_body (line 171)
6	Twig\Template->displayBlock (line 89)
7	__TwigTemplate_6691218cc67caf35564ba108619d97b2->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 48)
10	__TwigTemplate_1ba1eb192bd98f364b1f1001be4f1394->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 14)
18	App\Controller\HomeController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Services	No errors.
App\Entity\SubServices	No errors.
App\Entity\Specialities	No errors.
App\Entity\Notices	No errors.
App\Entity\Partners	No errors.

Symfony Profiler

GET https://recette.deborah-cimerman-naturopathe.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping