Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.64 ms Query time

0 Invalid entities

12 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.20 ms

SELECT t0.id AS id_1, t0.address AS address_2, t0.phone AS phone_3, t0.email AS email_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.whatsapp AS whatsapp_7, t0.map_embed_code AS map_embed_code_8 FROM general_data t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.facebook AS facebook_5,
  t0.instagram AS instagram_6,
  t0.whatsapp AS whatsapp_7,
  t0.map_embed_code AS map_embed_code_8
FROM
  general_data t0
LIMIT
  1

SELECT t0.id AS id_1, t0.address AS address_2, t0.phone AS phone_3, t0.email AS email_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.whatsapp AS whatsapp_7, t0.map_embed_code AS map_embed_code_8 FROM general_data t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\EventSubscriber\GlobalVariablesSubscriber->onKernelController (line 33)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

2.90 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.svg_icon AS svg_icon_4, t0.used_to_diagnose AS used_to_diagnose_5, t0.short_description AS short_description_6, t0.full_text AS full_text_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.sort_order AS sort_order_11 FROM specialty t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "prevencao-cardiovascular"
  1
]

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,
  t0.svg_icon AS svg_icon_4,
  t0.used_to_diagnose AS used_to_diagnose_5,
  t0.short_description AS short_description_6,
  t0.full_text AS full_text_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9,
  t0.active AS active_10,
  t0.sort_order AS sort_order_11
FROM
  specialty t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.svg_icon AS svg_icon_4, t0.used_to_diagnose AS used_to_diagnose_5, t0.short_description AS short_description_6, t0.full_text AS full_text_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.sort_order AS sort_order_11 FROM specialty t0 WHERE t0.slug = 'prevencao-cardiovascular' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\SpecialtyController->show (line 24)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.27 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.svg_icon AS svg_icon_4, t0.used_to_diagnose AS used_to_diagnose_5, t0.short_description AS short_description_6, t0.full_text AS full_text_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.sort_order AS sort_order_11 FROM specialty t0 WHERE t0.active = ? ORDER BY t0.sort_order 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.slug AS slug_3,
  t0.svg_icon AS svg_icon_4,
  t0.used_to_diagnose AS used_to_diagnose_5,
  t0.short_description AS short_description_6,
  t0.full_text AS full_text_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9,
  t0.active AS active_10,
  t0.sort_order AS sort_order_11
FROM
  specialty t0
WHERE
  t0.active = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.svg_icon AS svg_icon_4, t0.used_to_diagnose AS used_to_diagnose_5, t0.short_description AS short_description_6, t0.full_text AS full_text_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.sort_order AS sort_order_11 FROM specialty t0 WHERE t0.active = 1 ORDER BY t0.sort_order ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\SpecialtyController->show (line 31)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.28 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.icon AS icon_6, t0.image_name AS image_name_7, t0.updated_at AS updated_at_8 FROM service t0 ORDER BY t0.title ASC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.content AS content_5,
  t0.icon AS icon_6,
  t0.image_name AS image_name_7,
  t0.updated_at AS updated_at_8
FROM
  service t0
ORDER BY
  t0.title ASC
LIMIT
  5

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.icon AS icon_6, t0.image_name AS image_name_7, t0.updated_at AS updated_at_8 FROM service t0 ORDER BY t0.title ASC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\PartialController->footerServices (line 21)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_09608e3184df5ee3b1a16d75301c782f->block_body (line 490)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_e8ca7f547effa072916de9cb8f80eb98->doDisplay (line 88)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_09608e3184df5ee3b1a16d75301c782f->doDisplay (line 54)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_e9bf2bbff9b63abf252467dcde03a29c->doDisplay (line 55)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
27	App\Controller\SpecialtyController->show (line 33)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Specialty	7
App\Entity\Service	4
App\Entity\GeneralData	1

Entities Mapping

Class	Mapping errors
App\Entity\GeneralData	No errors.
App\Entity\Specialty	No errors.
App\Entity\Service	No errors.

Symfony Profiler

GET https://procordis.wab.com.br/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CPartialController%253A%253AfooterServices

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping