Symfony Profiler

Query Metrics

12 Database Queries

8 Different statements

7.51 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.26 ms
(16.77%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.host AS host_2, p0_.logo AS logo_3, p0_.favicon AS favicon_4, p0_.currency AS currency_5, p0_.languages AS languages_6, p0_.is_active AS is_active_7, p0_.telegram AS telegram_8, p0_.whatsapp AS whatsapp_9, p0_.phone AS phone_10, p0_.handlers AS handlers_11, p0_.is_fullname AS is_fullname_12, p0_.is_delivery_outside_city AS is_delivery_outside_city_13, p0_.min_order_price AS min_order_price_14, p0_.telegram_message_footer AS telegram_message_footer_15, p0_.verified_domain AS verified_domain_16, p0_.is_urgent_order AS is_urgent_order_17, p0_.is_comment_order AS is_comment_order_18, p0_.country AS country_19, p0_.site_menu AS site_menu_20, p0_.site_theme AS site_theme_21, p0_.email AS email_22, p0_.instagram AS instagram_23, p0_.address AS address_24, p0_.map AS map_25, p0_.min_carpet_price AS min_carpet_price_26, p0_.header_button_link AS header_button_link_27, p0_.is_header_button_target_blank_attr AS is_header_button_target_blank_attr_28 FROM projects p0_ WHERE p0_.host = ?

Parameters:

[
  "itkovrochist.online"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.host AS host_2,
  p0_.logo AS logo_3,
  p0_.favicon AS favicon_4,
  p0_.currency AS currency_5,
  p0_.languages AS languages_6,
  p0_.is_active AS is_active_7,
  p0_.telegram AS telegram_8,
  p0_.whatsapp AS whatsapp_9,
  p0_.phone AS phone_10,
  p0_.handlers AS handlers_11,
  p0_.is_fullname AS is_fullname_12,
  p0_.is_delivery_outside_city AS is_delivery_outside_city_13,
  p0_.min_order_price AS min_order_price_14,
  p0_.telegram_message_footer AS telegram_message_footer_15,
  p0_.verified_domain AS verified_domain_16,
  p0_.is_urgent_order AS is_urgent_order_17,
  p0_.is_comment_order AS is_comment_order_18,
  p0_.country AS country_19,
  p0_.site_menu AS site_menu_20,
  p0_.site_theme AS site_theme_21,
  p0_.email AS email_22,
  p0_.instagram AS instagram_23,
  p0_.address AS address_24,
  p0_.map AS map_25,
  p0_.min_carpet_price AS min_carpet_price_26,
  p0_.header_button_link AS header_button_link_27,
  p0_.is_header_button_target_blank_attr AS is_header_button_target_blank_attr_28
FROM
  projects p0_
WHERE
  p0_.host = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.host AS host_2, p0_.logo AS logo_3, p0_.favicon AS favicon_4, p0_.currency AS currency_5, p0_.languages AS languages_6, p0_.is_active AS is_active_7, p0_.telegram AS telegram_8, p0_.whatsapp AS whatsapp_9, p0_.phone AS phone_10, p0_.handlers AS handlers_11, p0_.is_fullname AS is_fullname_12, p0_.is_delivery_outside_city AS is_delivery_outside_city_13, p0_.min_order_price AS min_order_price_14, p0_.telegram_message_footer AS telegram_message_footer_15, p0_.verified_domain AS verified_domain_16, p0_.is_urgent_order AS is_urgent_order_17, p0_.is_comment_order AS is_comment_order_18, p0_.country AS country_19, p0_.site_menu AS site_menu_20, p0_.site_theme AS site_theme_21, p0_.email AS email_22, p0_.instagram AS instagram_23, p0_.address AS address_24, p0_.map AS map_25, p0_.min_carpet_price AS min_carpet_price_26, p0_.header_button_link AS header_button_link_27, p0_.is_header_button_target_blank_attr AS is_header_button_target_blank_attr_28 FROM projects p0_ WHERE p0_.host = 'itkovrochist.online';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 33)
7	App\Repository\ProjectsRepository->findByHost (line 45)
8	App\EventListener\NotFoundExceptionListener->onKernelException (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
13	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.19 ms
(15.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.mime AS mime_4, t0.size AS size_5, t0.last_modified AS last_modified_6, t0.metas AS metas_7, t0.folder_id AS folder_id_8, t0.project_id AS project_id_9 FROM easy_media_medias t0 WHERE t0.id = ?

Parameters:

[
  "11"
]

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.mime AS mime_4,
  t0.size AS size_5,
  t0.last_modified AS last_modified_6,
  t0.metas AS metas_7,
  t0.folder_id AS folder_id_8,
  t0.project_id AS project_id_9
FROM
  easy_media_medias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.mime AS mime_4, t0.size AS size_5, t0.last_modified AS last_modified_6, t0.metas AS metas_7, t0.folder_id AS folder_id_8, t0.project_id AS project_id_9 FROM easy_media_medias t0 WHERE t0.id = '11';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 80)
7	Adeliom\EasyMediaBundle\Service\EasyMediaHelper->getMedia (line 94)
8	Adeliom\EasyMediaBundle\Service\EasyMediaManager->getMedia (line 107)
9	Adeliom\EasyMediaBundle\Twig\EasyMediaRuntime->getMedia (line 152)
10	Adeliom\EasyMediaBundle\Twig\EasyMediaRuntime->path (line 109)
11	__TwigTemplate_ca52b96de7d7612aba875a2805a8669c->doDisplay (line 388)
12	Twig\Template->yield (line 59)
13	__TwigTemplate_7a443b55c990106e68a5aae90fd342f2->doDisplay (line 388)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_1df3a5fa6b674e0131486784832faf17->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 63)
21	App\EventListener\NotFoundExceptionListener->onKernelException (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
26	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.02 ms
(13.63%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.app_id AS app_id_6, t0.type AS type_7, t0.page_id AS page_id_8 FROM facebook_meta_tags t0 WHERE t0.page_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.app_id AS app_id_6,
  t0.type AS type_7,
  t0.page_id AS page_id_8
FROM
  facebook_meta_tags t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.app_id AS app_id_6, t0.type AS type_7, t0.page_id AS page_id_8 FROM facebook_meta_tags t0 WHERE t0.page_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2444)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 170)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 43)
12	App\Repository\PageRepository->getPagesByProject (line 63)
13	App\EventListener\NotFoundExceptionListener->onKernelException (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
18	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.88 ms
(11.67%)

SELECT t0.id AS id_1, t0.monday_start AS monday_start_2, t0.monday_stop AS monday_stop_3, t0.tuesday_start AS tuesday_start_4, t0.tuesday_stop AS tuesday_stop_5, t0.wednesday_start AS wednesday_start_6, t0.wednesday_stop AS wednesday_stop_7, t0.thursday_start AS thursday_start_8, t0.thursday_stop AS thursday_stop_9, t0.friday_start AS friday_start_10, t0.friday_stop AS friday_stop_11, t0.saturday_start AS saturday_start_12, t0.saturday_stop AS saturday_stop_13, t0.sunday_start AS sunday_start_14, t0.sunday_stop AS sunday_stop_15, t0.project_id AS project_id_16 FROM workdays t0 WHERE t0.project_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.monday_start AS monday_start_2,
  t0.monday_stop AS monday_stop_3,
  t0.tuesday_start AS tuesday_start_4,
  t0.tuesday_stop AS tuesday_stop_5,
  t0.wednesday_start AS wednesday_start_6,
  t0.wednesday_stop AS wednesday_stop_7,
  t0.thursday_start AS thursday_start_8,
  t0.thursday_stop AS thursday_stop_9,
  t0.friday_start AS friday_start_10,
  t0.friday_stop AS friday_stop_11,
  t0.saturday_start AS saturday_start_12,
  t0.saturday_stop AS saturday_stop_13,
  t0.sunday_start AS sunday_start_14,
  t0.sunday_stop AS sunday_stop_15,
  t0.project_id AS project_id_16
FROM
  workdays t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.monday_start AS monday_start_2, t0.monday_stop AS monday_stop_3, t0.tuesday_start AS tuesday_start_4, t0.tuesday_stop AS tuesday_stop_5, t0.wednesday_start AS wednesday_start_6, t0.wednesday_stop AS wednesday_stop_7, t0.thursday_start AS thursday_start_8, t0.thursday_stop AS thursday_stop_9, t0.friday_start AS friday_start_10, t0.friday_stop AS friday_stop_11, t0.saturday_start AS saturday_start_12, t0.saturday_stop AS saturday_stop_13, t0.sunday_start AS sunday_start_14, t0.sunday_stop AS sunday_stop_15, t0.project_id AS project_id_16 FROM workdays t0 WHERE t0.project_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2444)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 170)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 738)
11	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 33)
12	App\Repository\ProjectsRepository->findByHost (line 45)
13	App\EventListener\NotFoundExceptionListener->onKernelException (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
18	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.87 ms
(11.66%)

SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.seo_keywords AS seo_keywords_3, t0.title AS title_4, t0.menu_title AS menu_title_5, t0.button_text AS button_text_6, t0.id AS id_7, t0.locale AS locale_8, t0.field AS field_9, t0.content AS content_10, t0.object_id AS object_id_11 FROM page_translations t0 WHERE t0.object_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.seo_title AS seo_title_1,
  t0.seo_description AS seo_description_2,
  t0.seo_keywords AS seo_keywords_3,
  t0.title AS title_4,
  t0.menu_title AS menu_title_5,
  t0.button_text AS button_text_6,
  t0.id AS id_7,
  t0.locale AS locale_8,
  t0.field AS field_9,
  t0.content AS content_10,
  t0.object_id AS object_id_11
FROM
  page_translations t0
WHERE
  t0.object_id = ?

SELECT t0.seo_title AS seo_title_1, t0.seo_description AS seo_description_2, t0.seo_keywords AS seo_keywords_3, t0.title AS title_4, t0.menu_title AS menu_title_5, t0.button_text AS button_text_6, t0.id AS id_7, t0.locale AS locale_8, t0.field AS field_9, t0.content AS content_10, t0.object_id AS object_id_11 FROM page_translations t0 WHERE t0.object_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 187)
7	Doctrine\Common\Collections\AbstractLazyCollection->key (line 101)
8	App\Entity\Pages\Page->getTranslations (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 141)
10	__TwigTemplate_7a443b55c990106e68a5aae90fd342f2->block_header (line 432)
11	Twig\Template->yieldBlock (line 135)
12	__TwigTemplate_ca52b96de7d7612aba875a2805a8669c->doDisplay (line 388)
13	Twig\Template->yield (line 59)
14	__TwigTemplate_7a443b55c990106e68a5aae90fd342f2->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_1df3a5fa6b674e0131486784832faf17->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 63)
22	App\EventListener\NotFoundExceptionListener->onKernelException (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
27	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.79 ms
(10.51%)

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.template AS template_4, p0_.is_render_button AS is_render_button_5, p0_.button_url AS button_url_6, p0_.project_id AS project_id_7 FROM page p0_ WHERE p0_.project_id = ? AND p0_.id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.template AS template_4,
  p0_.is_render_button AS is_render_button_5,
  p0_.button_url AS button_url_6,
  p0_.project_id AS project_id_7
FROM
  page p0_
WHERE
  p0_.project_id = ?
  AND p0_.id IN (?, ?)

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.template AS template_4, p0_.is_render_button AS is_render_button_5, p0_.button_url AS button_url_6, p0_.project_id AS project_id_7 FROM page p0_ WHERE p0_.project_id = 1 AND p0_.id IN (4, 5);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 43)
7	App\Repository\PageRepository->getPagesByProject (line 63)
8	App\EventListener\NotFoundExceptionListener->onKernelException (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
13	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.75 ms
(9.98%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.site AS site_5, t0.card AS card_6, t0.page_id AS page_id_7 FROM twitter_meta_tags t0 WHERE t0.page_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.description AS description_3,
  t0.image AS image_4,
  t0.site AS site_5,
  t0.card AS card_6,
  t0.page_id AS page_id_7
FROM
  twitter_meta_tags t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.site AS site_5, t0.card AS card_6, t0.page_id AS page_id_7 FROM twitter_meta_tags t0 WHERE t0.page_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2444)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 170)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 43)
12	App\Repository\PageRepository->getPagesByProject (line 63)
13	App\EventListener\NotFoundExceptionListener->onKernelException (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
18	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.75 ms
(9.95%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM project_translate t0 WHERE t0.object_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  project_translate t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM project_translate t0 WHERE t0.object_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 187)
7	Doctrine\Common\Collections\AbstractLazyCollection->key (line 181)
8	App\Entity\Project->getTranslations (line 483)
9	App\Entity\Project->getProjectSettings (line 61)
10	App\EventListener\NotFoundExceptionListener->onKernelException (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
15	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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\Translates\PageTranslate	4
App\Entity\Translates\ProjectTranslate	2
App\Entity\Pages\Page	2
App\Entity\EasyMedia\Media	2
App\Entity\Project	1
App\Entity\Workdays	1

Entities Mapping

Class	Mapping errors
App\Entity\Project	No errors.
App\Entity\Service	No errors.
App\Entity\Subscription	No errors.
App\Entity\Workdays	No errors.
App\Entity\Translates\ProjectTranslate	No errors.
App\Entity\Pages\Page	No errors.
App\Entity\Translates\PageTranslate	No errors.
App\Entity\Pages\FacebookMetaTags	No errors.
App\Entity\Pages\TwitterMetaTags	No errors.
App\Entity\Pages\Widgets\Widget	No errors.
Adeliom\EasyMediaBundle\Entity\Media	No errors.
App\Entity\EasyMedia\Media	No errors.
Adeliom\EasyMediaBundle\Entity\Folder	No errors.
App\Entity\EasyMedia\Folder	No errors.

Symfony Profiler

GET https://itkovrochist.online/ru/https/u003A/itkovrochist.online/_profiler/'%20+%20newToken%20+%20'

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping