Symfony Profiler

Query Metrics

186 Database Queries

15 Different statements

33.75 ms Query time

1 Invalid entities

232 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.21 ms
(45.06%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE t0.id = ?

Parameters:

[
  158
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.modified_at AS modified_at_4,
  t0.published_at AS published_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.short_description AS short_description_8,
  t0.is_published AS is_published_9,
  t0.slug AS slug_10,
  t0.path AS path_11,
  t0.position AS position_12,
  t0.redirect AS redirect_13,
  t0.is_deleted AS is_deleted_14,
  t0.robots AS robots_15,
  t0.redirect_code AS redirect_code_16,
  t0.is_home AS is_home_17,
  t0.settings AS settings_18,
  t0.image_name AS image_name_19,
  t0.updated_at AS updated_at_20,
  t0.parent_id AS parent_id_21,
  t0.owner_id AS owner_id_22,
  t23.id AS id_24,
  t23.title AS title_25,
  t23.title_short AS title_short_26,
  t23.slug AS slug_27,
  t23.description AS description_28,
  t23.price AS price_29,
  t23.is_calculated AS is_calculated_30,
  t23.min_size_x AS min_size_x_31,
  t23.min_size_y AS min_size_y_32,
  t23.max_size_x AS max_size_x_33,
  t23.max_size_y AS max_size_y_34,
  t23.formula AS formula_35,
  t23.stock AS stock_36,
  t23.sku AS sku_37,
  t23.processing_fee AS processing_fee_38,
  t23.position AS position_39,
  t23.is_published AS is_published_40,
  t23.is_deleted AS is_deleted_41,
  t23.image_name AS image_name_42,
  t23.updated_at AS updated_at_43,
  t23.shipping_info AS shipping_info_44,
  t23.shipping_duration AS shipping_duration_45,
  t23.has_individual_sizes AS has_individual_sizes_46,
  t23.short_description AS short_description_47,
  t23.editor_override_type AS editor_override_type_48,
  t23.editor_override_config AS editor_override_config_49,
  t23.owner_id AS owner_id_50,
  t23.page_id AS page_id_51
FROM
  page t0
  LEFT JOIN shop_product t23 ON t23.page_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE t0.id = 158;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Page\Page::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Page\Page->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\Page\Page->__load (line 20)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromField (line 79)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 147)
10	Vich\UploaderBundle\Storage\AbstractStorage->resolveUri (line 105)
11	Vich\UploaderBundle\Storage\FlysystemStorage->resolveUri (line 85)
12	App\Service\Page\NavigationService->getTree (line 31)
13	App\Service\Page\NavigationService->getTree (line 28)
14	App\Controller\FrontpageController->renderPage (line 319)
15	App\Controller\FrontpageController->pageView (line 120)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 6)

9.89 ms
(29.31%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_link AS custom_link_3, t0.position AS position_4, t0.target AS target_5, t0.is_visible AS is_visible_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM navigation_item t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.custom_link AS custom_link_3,
  t0.position AS position_4,
  t0.target AS target_5,
  t0.is_visible AS is_visible_6,
  t0.link_type AS link_type_7,
  t0.page_id AS page_id_8,
  t0.parent_id AS parent_id_9
FROM
  navigation_item t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_link AS custom_link_3, t0.position AS position_4, t0.target AS target_5, t0.is_visible AS is_visible_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM navigation_item t0 WHERE t0.parent_id = 14 ORDER BY t0.position 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\Service\Page\NavigationService->getTree (line 24)
5	App\Service\Page\NavigationService->getTree (line 28)
6	App\Controller\FrontpageController->renderPage (line 319)
7	App\Controller\FrontpageController->pageView (line 120)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 6)

2.09 ms
(6.19%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.is_draft AS is_draft_5, t0.published_at AS published_at_6, t0.section_id AS section_id_7 FROM block t0 WHERE t0.section_id = ? AND t0.is_draft = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.settings AS settings_3,
  t0.position AS position_4,
  t0.is_draft AS is_draft_5,
  t0.published_at AS published_at_6,
  t0.section_id AS section_id_7
FROM
  block t0
WHERE
  t0.section_id = ?
  AND t0.is_draft = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.is_draft AS is_draft_5, t0.published_at AS published_at_6, t0.section_id AS section_id_7 FROM block t0 WHERE t0.section_id = 922 AND t0.is_draft = 0;

#	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\FrontpageController->renderPage (line 157)
5	App\Controller\FrontpageController->pageView (line 120)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

1.67 ms
(4.96%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.is_draft AS is_draft_5, t0.published_at AS published_at_6, t0.section_id AS section_id_7 FROM block t0 WHERE t0.section_id = ? ORDER BY t0.position ASC

Parameters:

[
  922
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.settings AS settings_3,
  t0.position AS position_4,
  t0.is_draft AS is_draft_5,
  t0.published_at AS published_at_6,
  t0.section_id AS section_id_7
FROM
  block t0
WHERE
  t0.section_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.is_draft AS is_draft_5, t0.published_at AS published_at_6, t0.section_id AS section_id_7 FROM block t0 WHERE t0.section_id = 922 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_95f79092bd7f442d7229c022db3d5106->doDisplay (line 227)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 170)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->doDisplay (line 53)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\FrontpageController->renderPage (line 316)
21	App\Controller\FrontpageController->pageView (line 120)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 6)

1.47 ms
(4.37%)

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.uploaded_at AS uploaded_at_4, t0.block_id AS block_id_5 FROM block_asset t0 WHERE t0.block_id = ?

Parameters:

[
  1870
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.mime_type AS mime_type_3,
  t0.uploaded_at AS uploaded_at_4,
  t0.block_id AS block_id_5
FROM
  block_asset t0
WHERE
  t0.block_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.mime_type AS mime_type_3, t0.uploaded_at AS uploaded_at_4, t0.block_id AS block_id_5 FROM block_asset t0 WHERE t0.block_id = 1870;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	IteratorIterator->__construct (line 1980)
8	Twig\Extension\CoreExtension->filter (line 1980)
9	__TwigTemplate_6d1cce9dfc885e7b60fece55ca320951::doDisplay (line 72)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->block_body (line 217)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 600)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->doDisplay (line 53)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\FrontpageController->renderPage (line 316)
25	App\Controller\FrontpageController->pageView (line 120)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 6)

0.82 ms
(2.43%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE t0.path = ? LIMIT 1

Parameters:

[
  "fotogeschenke/fotoaufsteller"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.modified_at AS modified_at_4,
  t0.published_at AS published_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.short_description AS short_description_8,
  t0.is_published AS is_published_9,
  t0.slug AS slug_10,
  t0.path AS path_11,
  t0.position AS position_12,
  t0.redirect AS redirect_13,
  t0.is_deleted AS is_deleted_14,
  t0.robots AS robots_15,
  t0.redirect_code AS redirect_code_16,
  t0.is_home AS is_home_17,
  t0.settings AS settings_18,
  t0.image_name AS image_name_19,
  t0.updated_at AS updated_at_20,
  t0.parent_id AS parent_id_21,
  t0.owner_id AS owner_id_22,
  t23.id AS id_24,
  t23.title AS title_25,
  t23.title_short AS title_short_26,
  t23.slug AS slug_27,
  t23.description AS description_28,
  t23.price AS price_29,
  t23.is_calculated AS is_calculated_30,
  t23.min_size_x AS min_size_x_31,
  t23.min_size_y AS min_size_y_32,
  t23.max_size_x AS max_size_x_33,
  t23.max_size_y AS max_size_y_34,
  t23.formula AS formula_35,
  t23.stock AS stock_36,
  t23.sku AS sku_37,
  t23.processing_fee AS processing_fee_38,
  t23.position AS position_39,
  t23.is_published AS is_published_40,
  t23.is_deleted AS is_deleted_41,
  t23.image_name AS image_name_42,
  t23.updated_at AS updated_at_43,
  t23.shipping_info AS shipping_info_44,
  t23.shipping_duration AS shipping_duration_45,
  t23.has_individual_sizes AS has_individual_sizes_46,
  t23.short_description AS short_description_47,
  t23.editor_override_type AS editor_override_type_48,
  t23.editor_override_config AS editor_override_config_49,
  t23.owner_id AS owner_id_50,
  t23.page_id AS page_id_51
FROM
  page t0
  LEFT JOIN shop_product t23 ON t23.page_id = t0.id
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE t0.path = 'fotogeschenke/fotoaufsteller' 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\FrontpageController->pageView (line 111)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 6)

0.58 ms
(1.73%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.title AS title_5, t0.is_draft AS is_draft_6, t0.published_at AS published_at_7, t0.page_id AS page_id_8 FROM section t0 WHERE t0.page_id = ? AND t0.is_draft = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.settings AS settings_3,
  t0.position AS position_4,
  t0.title AS title_5,
  t0.is_draft AS is_draft_6,
  t0.published_at AS published_at_7,
  t0.page_id AS page_id_8
FROM
  section t0
WHERE
  t0.page_id = ?
  AND t0.is_draft = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.title AS title_5, t0.is_draft AS is_draft_6, t0.published_at AS published_at_7, t0.page_id AS page_id_8 FROM section t0 WHERE t0.page_id = 48 AND t0.is_draft = 0;

#	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\FrontpageController->renderPage (line 151)
5	App\Controller\FrontpageController->pageView (line 120)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.36 ms
(1.05%)

SELECT f0_.id AS id_0, f0_.headline AS headline_1, f0_.position AS position_2, f0_.is_published AS is_published_3, f1_.id AS id_4, f1_.label AS label_5, f1_.url AS url_6, f1_.position AS position_7, f1_.is_published AS is_published_8, f1_.column_id AS column_id_9, f1_.page_id AS page_id_10 FROM footer_column f0_ LEFT JOIN footer_link f1_ ON f0_.id = f1_.column_id WHERE f0_.is_published = ? AND (f1_.id IS NULL OR f1_.is_published = ?) ORDER BY f0_.position ASC, f0_.id ASC, f1_.position ASC, f1_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.headline AS headline_1,
  f0_.position AS position_2,
  f0_.is_published AS is_published_3,
  f1_.id AS id_4,
  f1_.label AS label_5,
  f1_.url AS url_6,
  f1_.position AS position_7,
  f1_.is_published AS is_published_8,
  f1_.column_id AS column_id_9,
  f1_.page_id AS page_id_10
FROM
  footer_column f0_
  LEFT JOIN footer_link f1_ ON f0_.id = f1_.column_id
WHERE
  f0_.is_published = ?
  AND (
    f1_.id IS NULL
    OR f1_.is_published = ?
  )
ORDER BY
  f0_.position ASC,
  f0_.id ASC,
  f1_.position ASC,
  f1_.id ASC

SELECT f0_.id AS id_0, f0_.headline AS headline_1, f0_.position AS position_2, f0_.is_published AS is_published_3, f1_.id AS id_4, f1_.label AS label_5, f1_.url AS url_6, f1_.position AS position_7, f1_.is_published AS is_published_8, f1_.column_id AS column_id_9, f1_.page_id AS page_id_10 FROM footer_column f0_ LEFT JOIN footer_link f1_ ON f0_.id = f1_.column_id WHERE f0_.is_published = 1 AND (f1_.id IS NULL OR f1_.is_published = 1) ORDER BY f0_.position ASC, f0_.id ASC, f1_.position ASC, f1_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Footer\FooterColumnRepository->findPublishedWithLinks (line 37)
7	App\Service\FooterConfig->loadFooterColumns (line 36)
8	App\Service\FooterConfig->get (line 29)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_95f79092bd7f442d7229c022db3d5106::doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 170)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->doDisplay (line 53)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\FrontpageController->renderPage (line 316)
24	App\Controller\FrontpageController->pageView (line 120)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 6)

0.36 ms
(1.05%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.title AS title_5, t0.is_draft AS is_draft_6, t0.published_at AS published_at_7, t0.page_id AS page_id_8 FROM section t0 WHERE t0.page_id = ? ORDER BY t0.position ASC

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.settings AS settings_3,
  t0.position AS position_4,
  t0.title AS title_5,
  t0.is_draft AS is_draft_6,
  t0.published_at AS published_at_7,
  t0.page_id AS page_id_8
FROM
  section t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.settings AS settings_3, t0.position AS position_4, t0.title AS title_5, t0.is_draft AS is_draft_6, t0.published_at AS published_at_7, t0.page_id AS page_id_8 FROM section t0 WHERE t0.page_id = 48 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_95f79092bd7f442d7229c022db3d5106->doDisplay (line 219)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 170)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->doDisplay (line 53)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\FrontpageController->renderPage (line 316)
21	App\Controller\FrontpageController->pageView (line 120)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 6)

0.33 ms
(0.98%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.position AS position_7, t0.is_deleted AS is_deleted_8, t0.is_configurable AS is_configurable_9, t0.is_published AS is_published_10, t0.custom_link AS custom_link_11, t0.image_name AS image_name_12, t0.updated_at AS updated_at_13, t0.editor_type AS editor_type_14, t0.editor_config AS editor_config_15, t0.show_in_editor AS show_in_editor_16, t0.parent_id AS parent_id_17 FROM shop_category t0 WHERE t0.id IN (?)

Parameters:

[
  28
]

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.created_at AS created_at_5,
  t0.modified_at AS modified_at_6,
  t0.position AS position_7,
  t0.is_deleted AS is_deleted_8,
  t0.is_configurable AS is_configurable_9,
  t0.is_published AS is_published_10,
  t0.custom_link AS custom_link_11,
  t0.image_name AS image_name_12,
  t0.updated_at AS updated_at_13,
  t0.editor_type AS editor_type_14,
  t0.editor_config AS editor_config_15,
  t0.show_in_editor AS show_in_editor_16,
  t0.parent_id AS parent_id_17
FROM
  shop_category t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.position AS position_7, t0.is_deleted AS is_deleted_8, t0.is_configurable AS is_configurable_9, t0.is_published AS is_published_10, t0.custom_link AS custom_link_11, t0.image_name AS image_name_12, t0.updated_at AS updated_at_13, t0.editor_type AS editor_type_14, t0.editor_config AS editor_config_15, t0.show_in_editor AS show_in_editor_16, t0.parent_id AS parent_id_17 FROM shop_category t0 WHERE t0.id IN (28);

#	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\FrontpageController->renderPage (line 198)
5	App\Controller\FrontpageController->pageView (line 120)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.31 ms
(0.93%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.position AS position_7, t0.is_deleted AS is_deleted_8, t0.is_configurable AS is_configurable_9, t0.is_published AS is_published_10, t0.custom_link AS custom_link_11, t0.image_name AS image_name_12, t0.updated_at AS updated_at_13, t0.editor_type AS editor_type_14, t0.editor_config AS editor_config_15, t0.show_in_editor AS show_in_editor_16, t0.parent_id AS parent_id_17 FROM shop_category t0 WHERE t0.parent_id = ?

Parameters:

[
  28
]

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.created_at AS created_at_5,
  t0.modified_at AS modified_at_6,
  t0.position AS position_7,
  t0.is_deleted AS is_deleted_8,
  t0.is_configurable AS is_configurable_9,
  t0.is_published AS is_published_10,
  t0.custom_link AS custom_link_11,
  t0.image_name AS image_name_12,
  t0.updated_at AS updated_at_13,
  t0.editor_type AS editor_type_14,
  t0.editor_config AS editor_config_15,
  t0.show_in_editor AS show_in_editor_16,
  t0.parent_id AS parent_id_17
FROM
  shop_category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.position AS position_7, t0.is_deleted AS is_deleted_8, t0.is_configurable AS is_configurable_9, t0.is_published AS is_published_10, t0.custom_link AS custom_link_11, t0.image_name AS image_name_12, t0.updated_at AS updated_at_13, t0.editor_type AS editor_type_14, t0.editor_config AS editor_config_15, t0.show_in_editor AS show_in_editor_16, t0.parent_id AS parent_id_17 FROM shop_category t0 WHERE t0.parent_id = 28;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1423)
9	__TwigTemplate_6f224dabd611ac857fca8d9d2fd34f9f::doDisplay (line 57)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->block_body (line 217)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 600)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->doDisplay (line 53)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\FrontpageController->renderPage (line 316)
25	App\Controller\FrontpageController->pageView (line 120)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 6)

0.23 ms
(0.68%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_short AS title_short_3, t0.slug AS slug_4, t0.description AS description_5, t0.price AS price_6, t0.is_calculated AS is_calculated_7, t0.min_size_x AS min_size_x_8, t0.min_size_y AS min_size_y_9, t0.max_size_x AS max_size_x_10, t0.max_size_y AS max_size_y_11, t0.formula AS formula_12, t0.stock AS stock_13, t0.sku AS sku_14, t0.processing_fee AS processing_fee_15, t0.position AS position_16, t0.is_published AS is_published_17, t0.is_deleted AS is_deleted_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.shipping_info AS shipping_info_21, t0.shipping_duration AS shipping_duration_22, t0.has_individual_sizes AS has_individual_sizes_23, t0.short_description AS short_description_24, t0.editor_override_type AS editor_override_type_25, t0.editor_override_config AS editor_override_config_26, t0.owner_id AS owner_id_27, t0.page_id AS page_id_28 FROM shop_product t0 INNER JOIN shop_category_product ON t0.id = shop_category_product.product_id WHERE shop_category_product.category_id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_short AS title_short_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.is_calculated AS is_calculated_7,
  t0.min_size_x AS min_size_x_8,
  t0.min_size_y AS min_size_y_9,
  t0.max_size_x AS max_size_x_10,
  t0.max_size_y AS max_size_y_11,
  t0.formula AS formula_12,
  t0.stock AS stock_13,
  t0.sku AS sku_14,
  t0.processing_fee AS processing_fee_15,
  t0.position AS position_16,
  t0.is_published AS is_published_17,
  t0.is_deleted AS is_deleted_18,
  t0.image_name AS image_name_19,
  t0.updated_at AS updated_at_20,
  t0.shipping_info AS shipping_info_21,
  t0.shipping_duration AS shipping_duration_22,
  t0.has_individual_sizes AS has_individual_sizes_23,
  t0.short_description AS short_description_24,
  t0.editor_override_type AS editor_override_type_25,
  t0.editor_override_config AS editor_override_config_26,
  t0.owner_id AS owner_id_27,
  t0.page_id AS page_id_28
FROM
  shop_product t0
  INNER JOIN shop_category_product ON t0.id = shop_category_product.product_id
WHERE
  shop_category_product.category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_short AS title_short_3, t0.slug AS slug_4, t0.description AS description_5, t0.price AS price_6, t0.is_calculated AS is_calculated_7, t0.min_size_x AS min_size_x_8, t0.min_size_y AS min_size_y_9, t0.max_size_x AS max_size_x_10, t0.max_size_y AS max_size_y_11, t0.formula AS formula_12, t0.stock AS stock_13, t0.sku AS sku_14, t0.processing_fee AS processing_fee_15, t0.position AS position_16, t0.is_published AS is_published_17, t0.is_deleted AS is_deleted_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.shipping_info AS shipping_info_21, t0.shipping_duration AS shipping_duration_22, t0.has_individual_sizes AS has_individual_sizes_23, t0.short_description AS short_description_24, t0.editor_override_type AS editor_override_type_25, t0.editor_override_config AS editor_override_config_26, t0.owner_id AS owner_id_27, t0.page_id AS page_id_28 FROM shop_product t0 INNER JOIN shop_category_product ON t0.id = shop_category_product.product_id WHERE shop_category_product.category_id = 28;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1423)
9	__TwigTemplate_6f224dabd611ac857fca8d9d2fd34f9f::doDisplay (line 87)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->block_body (line 217)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 600)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_feb7e156f7ce2449a9c5087bba7d9609->doDisplay (line 53)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\FrontpageController->renderPage (line 316)
25	App\Controller\FrontpageController->pageView (line 120)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 6)

0.16 ms
(0.47%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE 1=0 AND t0.is_published = ? AND t0.is_deleted = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.modified_at AS modified_at_4,
  t0.published_at AS published_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.short_description AS short_description_8,
  t0.is_published AS is_published_9,
  t0.slug AS slug_10,
  t0.path AS path_11,
  t0.position AS position_12,
  t0.redirect AS redirect_13,
  t0.is_deleted AS is_deleted_14,
  t0.robots AS robots_15,
  t0.redirect_code AS redirect_code_16,
  t0.is_home AS is_home_17,
  t0.settings AS settings_18,
  t0.image_name AS image_name_19,
  t0.updated_at AS updated_at_20,
  t0.parent_id AS parent_id_21,
  t0.owner_id AS owner_id_22,
  t23.id AS id_24,
  t23.title AS title_25,
  t23.title_short AS title_short_26,
  t23.slug AS slug_27,
  t23.description AS description_28,
  t23.price AS price_29,
  t23.is_calculated AS is_calculated_30,
  t23.min_size_x AS min_size_x_31,
  t23.min_size_y AS min_size_y_32,
  t23.max_size_x AS max_size_x_33,
  t23.max_size_y AS max_size_y_34,
  t23.formula AS formula_35,
  t23.stock AS stock_36,
  t23.sku AS sku_37,
  t23.processing_fee AS processing_fee_38,
  t23.position AS position_39,
  t23.is_published AS is_published_40,
  t23.is_deleted AS is_deleted_41,
  t23.image_name AS image_name_42,
  t23.updated_at AS updated_at_43,
  t23.shipping_info AS shipping_info_44,
  t23.shipping_duration AS shipping_duration_45,
  t23.has_individual_sizes AS has_individual_sizes_46,
  t23.short_description AS short_description_47,
  t23.editor_override_type AS editor_override_type_48,
  t23.editor_override_config AS editor_override_config_49,
  t23.owner_id AS owner_id_50,
  t23.page_id AS page_id_51
FROM
  page t0
  LEFT JOIN shop_product t23 ON t23.page_id = t0.id
WHERE
  1 = 0
  AND t0.is_published = ?
  AND t0.is_deleted = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.published_at AS published_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.short_description AS short_description_8, t0.is_published AS is_published_9, t0.slug AS slug_10, t0.path AS path_11, t0.position AS position_12, t0.redirect AS redirect_13, t0.is_deleted AS is_deleted_14, t0.robots AS robots_15, t0.redirect_code AS redirect_code_16, t0.is_home AS is_home_17, t0.settings AS settings_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.parent_id AS parent_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.title AS title_25, t23.title_short AS title_short_26, t23.slug AS slug_27, t23.description AS description_28, t23.price AS price_29, t23.is_calculated AS is_calculated_30, t23.min_size_x AS min_size_x_31, t23.min_size_y AS min_size_y_32, t23.max_size_x AS max_size_x_33, t23.max_size_y AS max_size_y_34, t23.formula AS formula_35, t23.stock AS stock_36, t23.sku AS sku_37, t23.processing_fee AS processing_fee_38, t23.position AS position_39, t23.is_published AS is_published_40, t23.is_deleted AS is_deleted_41, t23.image_name AS image_name_42, t23.updated_at AS updated_at_43, t23.shipping_info AS shipping_info_44, t23.shipping_duration AS shipping_duration_45, t23.has_individual_sizes AS has_individual_sizes_46, t23.short_description AS short_description_47, t23.editor_override_type AS editor_override_type_48, t23.editor_override_config AS editor_override_config_49, t23.owner_id AS owner_id_50, t23.page_id AS page_id_51 FROM page t0 LEFT JOIN shop_product t23 ON t23.page_id = t0.id WHERE 1=0 AND t0.is_published = 1 AND t0.is_deleted = 0;

#	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\FrontpageController->renderPage (line 200)
5	App\Controller\FrontpageController->pageView (line 120)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.15 ms
(0.45%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_short AS title_short_3, t0.slug AS slug_4, t0.description AS description_5, t0.price AS price_6, t0.is_calculated AS is_calculated_7, t0.min_size_x AS min_size_x_8, t0.min_size_y AS min_size_y_9, t0.max_size_x AS max_size_x_10, t0.max_size_y AS max_size_y_11, t0.formula AS formula_12, t0.stock AS stock_13, t0.sku AS sku_14, t0.processing_fee AS processing_fee_15, t0.position AS position_16, t0.is_published AS is_published_17, t0.is_deleted AS is_deleted_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.shipping_info AS shipping_info_21, t0.shipping_duration AS shipping_duration_22, t0.has_individual_sizes AS has_individual_sizes_23, t0.short_description AS short_description_24, t0.editor_override_type AS editor_override_type_25, t0.editor_override_config AS editor_override_config_26, t0.owner_id AS owner_id_27, t0.page_id AS page_id_28 FROM shop_product t0 WHERE 1=0 AND t0.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_short AS title_short_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.is_calculated AS is_calculated_7,
  t0.min_size_x AS min_size_x_8,
  t0.min_size_y AS min_size_y_9,
  t0.max_size_x AS max_size_x_10,
  t0.max_size_y AS max_size_y_11,
  t0.formula AS formula_12,
  t0.stock AS stock_13,
  t0.sku AS sku_14,
  t0.processing_fee AS processing_fee_15,
  t0.position AS position_16,
  t0.is_published AS is_published_17,
  t0.is_deleted AS is_deleted_18,
  t0.image_name AS image_name_19,
  t0.updated_at AS updated_at_20,
  t0.shipping_info AS shipping_info_21,
  t0.shipping_duration AS shipping_duration_22,
  t0.has_individual_sizes AS has_individual_sizes_23,
  t0.short_description AS short_description_24,
  t0.editor_override_type AS editor_override_type_25,
  t0.editor_override_config AS editor_override_config_26,
  t0.owner_id AS owner_id_27,
  t0.page_id AS page_id_28
FROM
  shop_product t0
WHERE
  1 = 0
  AND t0.is_published = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_short AS title_short_3, t0.slug AS slug_4, t0.description AS description_5, t0.price AS price_6, t0.is_calculated AS is_calculated_7, t0.min_size_x AS min_size_x_8, t0.min_size_y AS min_size_y_9, t0.max_size_x AS max_size_x_10, t0.max_size_y AS max_size_y_11, t0.formula AS formula_12, t0.stock AS stock_13, t0.sku AS sku_14, t0.processing_fee AS processing_fee_15, t0.position AS position_16, t0.is_published AS is_published_17, t0.is_deleted AS is_deleted_18, t0.image_name AS image_name_19, t0.updated_at AS updated_at_20, t0.shipping_info AS shipping_info_21, t0.shipping_duration AS shipping_duration_22, t0.has_individual_sizes AS has_individual_sizes_23, t0.short_description AS short_description_24, t0.editor_override_type AS editor_override_type_25, t0.editor_override_config AS editor_override_config_26, t0.owner_id AS owner_id_27, t0.page_id AS page_id_28 FROM shop_product t0 WHERE 1=0 AND t0.is_published = 1;

#	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\FrontpageController->renderPage (line 199)
5	App\Controller\FrontpageController->pageView (line 120)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 6)

0.11 ms
(0.33%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_link AS custom_link_3, t0.position AS position_4, t0.target AS target_5, t0.is_visible AS is_visible_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM navigation_item t0 WHERE t0.parent_id IS NULL ORDER BY t0.position 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.custom_link AS custom_link_3,
  t0.position AS position_4,
  t0.target AS target_5,
  t0.is_visible AS is_visible_6,
  t0.link_type AS link_type_7,
  t0.page_id AS page_id_8,
  t0.parent_id AS parent_id_9
FROM
  navigation_item t0
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_link AS custom_link_3, t0.position AS position_4, t0.target AS target_5, t0.is_visible AS is_visible_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8, t0.parent_id AS parent_id_9 FROM navigation_item t0 WHERE t0.parent_id IS NULL ORDER BY t0.position 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\Service\Page\NavigationService->getTree (line 24)
5	App\Controller\FrontpageController->renderPage (line 319)
6	App\Controller\FrontpageController->pageView (line 120)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 6)

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\Page\Page	84
App\Entity\Page\NavigationItem	75
App\Entity\Shop\Product	27
App\Entity\Page\Block	11
App\Entity\Footer\FooterLink	10
App\Entity\Media\BlockAsset	8
App\Entity\Page\Section	7
App\Entity\User	5
App\Entity\Footer\FooterColumn	3
App\Entity\Shop\Category	2

Entities Mapping

Class	Mapping errors
App\Entity\Page\Page	No errors.
App\Entity\User	No errors.
App\Entity\Shop\Product	No errors.
App\Entity\Page\Section	No errors.
App\Entity\Page\Block	No errors.
App\Entity\Media\BlockAsset	No errors.
App\Entity\Shop\Category	The field App\Entity\Shop\Category#children is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Shop\Category#parent does not contain the required 'inversedBy: "children"' attribute.
App\Entity\Shop\Voucher	No errors.
App\Entity\Page\NavigationItem	No errors.
App\Entity\Shop\Postage	No errors.
App\Entity\Shop\VariantGroupText	No errors.
App\Entity\Shop\Variant	No errors.
App\Entity\Shop\VariantGroup	No errors.
App\Entity\Media\MediaObject	No errors.
App\Entity\Footer\FooterColumn	No errors.
App\Entity\Footer\FooterLink	No errors.

Symfony Profiler

GET https://www.pixelfoto-express.de/fotogeschenke/fotoaufsteller?srsltid=AfmBOooML_fsdOIXc2VUcAYaTDrwF7xKseJXbY7q0r-bczJtabm5s3FY

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping