Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.20 ms Query time

0 Invalid entities

22 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.43 ms
(35.45%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content_json AS content_json_5, t0.page_heading AS page_heading_6, t0.short_description AS short_description_7, t0.hero_feature_lines AS hero_feature_lines_8, t0.hero_image AS hero_image_9, t0.what_shows_title AS what_shows_title_10, t0.what_shows_cards AS what_shows_cards_11, t0.process_title AS process_title_12, t0.process_description AS process_description_13, t0.process_steps AS process_steps_14, t0.process_slides AS process_slides_15, t0.contact_form_image AS contact_form_image_16, t0.catalog_image AS catalog_image_17, t0.checkup_preview_image AS checkup_preview_image_18, t0.catalog_price AS catalog_price_19, t0.catalog_features AS catalog_features_20, t0.is_published AS is_published_21, t0.sort_order AS sort_order_22, t0.category_id AS category_id_23 FROM service_page t0 WHERE t0.slug = ? AND t0.is_published = ? LIMIT 1

Parameters:

[
  "uzi-organov-bryushnoj-polosti-i-pochek"
  1
]

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.meta_description AS meta_description_4,
  t0.content_json AS content_json_5,
  t0.page_heading AS page_heading_6,
  t0.short_description AS short_description_7,
  t0.hero_feature_lines AS hero_feature_lines_8,
  t0.hero_image AS hero_image_9,
  t0.what_shows_title AS what_shows_title_10,
  t0.what_shows_cards AS what_shows_cards_11,
  t0.process_title AS process_title_12,
  t0.process_description AS process_description_13,
  t0.process_steps AS process_steps_14,
  t0.process_slides AS process_slides_15,
  t0.contact_form_image AS contact_form_image_16,
  t0.catalog_image AS catalog_image_17,
  t0.checkup_preview_image AS checkup_preview_image_18,
  t0.catalog_price AS catalog_price_19,
  t0.catalog_features AS catalog_features_20,
  t0.is_published AS is_published_21,
  t0.sort_order AS sort_order_22,
  t0.category_id AS category_id_23
FROM
  service_page t0
WHERE
  t0.slug = ?
  AND t0.is_published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.content_json AS content_json_5, t0.page_heading AS page_heading_6, t0.short_description AS short_description_7, t0.hero_feature_lines AS hero_feature_lines_8, t0.hero_image AS hero_image_9, t0.what_shows_title AS what_shows_title_10, t0.what_shows_cards AS what_shows_cards_11, t0.process_title AS process_title_12, t0.process_description AS process_description_13, t0.process_steps AS process_steps_14, t0.process_slides AS process_slides_15, t0.contact_form_image AS contact_form_image_16, t0.catalog_image AS catalog_image_17, t0.checkup_preview_image AS checkup_preview_image_18, t0.catalog_price AS catalog_price_19, t0.catalog_features AS catalog_features_20, t0.is_published AS is_published_21, t0.sort_order AS sort_order_22, t0.category_id AS category_id_23 FROM service_page t0 WHERE t0.slug = 'uzi-organov-bryushnoj-polosti-i-pochek' AND t0.is_published = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\AnaliziController->show (line 596)
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.29 ms
(24.25%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9, t0.years_experience AS years_experience_10 FROM doctor t0 ORDER BY t0.full_name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.slug AS slug_3,
  t0.photo AS photo_4,
  t0.list_photo AS list_photo_5,
  t0.list_description AS list_description_6,
  t0.short_description AS short_description_7,
  t0.left_description AS left_description_8,
  t0.right_description AS right_description_9,
  t0.years_experience AS years_experience_10
FROM
  doctor t0
ORDER BY
  t0.full_name ASC

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9, t0.years_experience AS years_experience_10 FROM doctor t0 ORDER BY t0.full_name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Twig\DoctorGlobalsExtension->getGlobals (line 19)
5	Twig\ExtensionSet->getGlobals (line 359)
6	Twig\Environment->getGlobals (line 900)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
15	App\Controller\AnaliziController->show (line 618)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.28 ms
(23.44%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9, t0.years_experience AS years_experience_10 FROM doctor t0 INNER JOIN service_page_doctor ON t0.id = service_page_doctor.doctor_id WHERE service_page_doctor.service_page_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.slug AS slug_3,
  t0.photo AS photo_4,
  t0.list_photo AS list_photo_5,
  t0.list_description AS list_description_6,
  t0.short_description AS short_description_7,
  t0.left_description AS left_description_8,
  t0.right_description AS right_description_9,
  t0.years_experience AS years_experience_10
FROM
  doctor t0
  INNER JOIN service_page_doctor ON t0.id = service_page_doctor.doctor_id
WHERE
  service_page_doctor.service_page_id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.slug AS slug_3, t0.photo AS photo_4, t0.list_photo AS list_photo_5, t0.list_description AS list_description_6, t0.short_description AS short_description_7, t0.left_description AS left_description_8, t0.right_description AS right_description_9, t0.years_experience AS years_experience_10 FROM doctor t0 INNER JOIN service_page_doctor ON t0.id = service_page_doctor.doctor_id WHERE service_page_doctor.service_page_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	App\Entity\ServicePage->buildAnaliziPageData (line 737)
10	App\Controller\AnaliziController->show (line 619)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.20 ms
(16.86%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.icon_color AS icon_color_5, t0.icon_image AS icon_image_6, t0.template_type AS template_type_7, t0.sort_order AS sort_order_8, t0.is_active AS is_active_9 FROM service_category t0 WHERE t0.id = ?

Parameters:

[
  4
]

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.icon AS icon_4,
  t0.icon_color AS icon_color_5,
  t0.icon_image AS icon_image_6,
  t0.template_type AS template_type_7,
  t0.sort_order AS sort_order_8,
  t0.is_active AS is_active_9
FROM
  service_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.icon_color AS icon_color_5, t0.icon_image AS icon_image_6, t0.template_type AS template_type_7, t0.sort_order AS sort_order_8, t0.is_active AS is_active_9 FROM service_category t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 289)
4	Proxies\__CG__\App\Entity\ServiceCategory::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\ServiceCategory->__get (line 153)
7	App\Entity\ServiceCategory->getSlug (line 81)
8	App\Controller\AnaliziController->show (line 602)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

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\Doctor	20
App\Entity\ServicePage	1
App\Entity\ServiceCategory	1

Entities Mapping

Class	Mapping errors
App\Entity\ServicePage	No errors.
App\Entity\ServiceCategory	No errors.
App\Entity\Doctor	No errors.
App\Entity\DoctorDiploma	No errors.

Symfony Profiler

GET https://hormonelife.ru/uslugi/diagnostics/uzi-organov-bryushnoj-polosti-i-pochek

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping