Symfony Profiler

Query Metrics

160 Database Queries

10 Different statements

20.82 ms Query time

1 Invalid entities

198 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.23 ms
(49.11%)

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\ProfileController->orderShow (line 717)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 6)

7.69 ms
(36.95%)

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\ProfileController->orderShow (line 717)
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)

0.76 ms
(3.63%)

SELECT t0.id AS id_1, t0.transaction_code AS transaction_code_2, t0.created_at AS created_at_3, t0.total AS total_4, t0.postage AS postage_5, t0.postage_extra AS postage_extra_6, t0.processing_fee AS processing_fee_7, t0.postage_saturday AS postage_saturday_8, t0.is_paid AS is_paid_9, t0.dicount AS dicount_10, t0.tax AS tax_11, t0.is_express AS is_express_12, t0.shipping_address_snapshot AS shipping_address_snapshot_13, t0.invoice_address_snapshot AS invoice_address_snapshot_14, t0.project_code AS project_code_15, t0.mollie_payment_id AS mollie_payment_id_16, t0.mollie_status AS mollie_status_17, t0.paid_at AS paid_at_18, t0.confirmation_sent_at AS confirmation_sent_at_19, t0.status AS status_20, t0.source_cart_id AS source_cart_id_21, t0.payment_metadata_hash AS payment_metadata_hash_22, t0.customer_comment AS customer_comment_23, t0.updated_at AS updated_at_24, t0.owner_id AS owner_id_25, t0.payment_method_id AS payment_method_id_26, t0.shipping_method_id AS shipping_method_id_27, t0.voucher_id AS voucher_id_28, t0.shipping_address_id AS shipping_address_id_29, t0.invoice_address_id AS invoice_address_id_30 FROM shop_order t0 WHERE t0.id = ?

Parameters:

[
  "176"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.transaction_code AS transaction_code_2,
  t0.created_at AS created_at_3,
  t0.total AS total_4,
  t0.postage AS postage_5,
  t0.postage_extra AS postage_extra_6,
  t0.processing_fee AS processing_fee_7,
  t0.postage_saturday AS postage_saturday_8,
  t0.is_paid AS is_paid_9,
  t0.dicount AS dicount_10,
  t0.tax AS tax_11,
  t0.is_express AS is_express_12,
  t0.shipping_address_snapshot AS shipping_address_snapshot_13,
  t0.invoice_address_snapshot AS invoice_address_snapshot_14,
  t0.project_code AS project_code_15,
  t0.mollie_payment_id AS mollie_payment_id_16,
  t0.mollie_status AS mollie_status_17,
  t0.paid_at AS paid_at_18,
  t0.confirmation_sent_at AS confirmation_sent_at_19,
  t0.status AS status_20,
  t0.source_cart_id AS source_cart_id_21,
  t0.payment_metadata_hash AS payment_metadata_hash_22,
  t0.customer_comment AS customer_comment_23,
  t0.updated_at AS updated_at_24,
  t0.owner_id AS owner_id_25,
  t0.payment_method_id AS payment_method_id_26,
  t0.shipping_method_id AS shipping_method_id_27,
  t0.voucher_id AS voucher_id_28,
  t0.shipping_address_id AS shipping_address_id_29,
  t0.invoice_address_id AS invoice_address_id_30
FROM
  shop_order t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.transaction_code AS transaction_code_2, t0.created_at AS created_at_3, t0.total AS total_4, t0.postage AS postage_5, t0.postage_extra AS postage_extra_6, t0.processing_fee AS processing_fee_7, t0.postage_saturday AS postage_saturday_8, t0.is_paid AS is_paid_9, t0.dicount AS dicount_10, t0.tax AS tax_11, t0.is_express AS is_express_12, t0.shipping_address_snapshot AS shipping_address_snapshot_13, t0.invoice_address_snapshot AS invoice_address_snapshot_14, t0.project_code AS project_code_15, t0.mollie_payment_id AS mollie_payment_id_16, t0.mollie_status AS mollie_status_17, t0.paid_at AS paid_at_18, t0.confirmation_sent_at AS confirmation_sent_at_19, t0.status AS status_20, t0.source_cart_id AS source_cart_id_21, t0.payment_metadata_hash AS payment_metadata_hash_22, t0.customer_comment AS customer_comment_23, t0.updated_at AS updated_at_24, t0.owner_id AS owner_id_25, t0.payment_method_id AS payment_method_id_26, t0.shipping_method_id AS shipping_method_id_27, t0.voucher_id AS voucher_id_28, t0.shipping_address_id AS shipping_address_id_29, t0.invoice_address_id AS invoice_address_id_30 FROM shop_order t0 WHERE t0.id = '176';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 6)

0.58 ms
(2.77%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.message AS message_3, t0.payload AS payload_4, t0.created_at AS created_at_5, t0.order_ref_id AS order_ref_id_6, t0.owner_id AS owner_id_7 FROM shop_order_reclamation t0 WHERE t0.order_ref_id = ? AND t0.owner_id = ? ORDER BY t0.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.message AS message_3,
  t0.payload AS payload_4,
  t0.created_at AS created_at_5,
  t0.order_ref_id AS order_ref_id_6,
  t0.owner_id AS owner_id_7
FROM
  shop_order_reclamation t0
WHERE
  t0.order_ref_id = ?
  AND t0.owner_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.status AS status_2, t0.message AS message_3, t0.payload AS payload_4, t0.created_at AS created_at_5, t0.order_ref_id AS order_ref_id_6, t0.owner_id AS owner_id_7 FROM shop_order_reclamation t0 WHERE t0.order_ref_id = 176 AND t0.owner_id = 30451 ORDER BY t0.created_at DESC;

#	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\ProfileController->orderShow (line 709)
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.54 ms
(2.61%)

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_9087d03b9a135ef232b089eb31428f40->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a->doDisplay (line 55)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_d49e09c359f446883ae31288a9214dfa->doDisplay (line 58)
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 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\ProfileController->orderShow (line 714)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 6)

0.26 ms
(1.26%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.token AS token_5, t0.token_requested_at AS token_requested_at_6, t0.email_verification_token AS email_verification_token_7, t0.email_verification_requested_at AS email_verification_requested_at_8, t0.is_verified AS is_verified_9, t0.meta AS meta_10, t0.created_at AS created_at_11, t0.firstname AS firstname_12, t0.lastname AS lastname_13, t0.identifier AS identifier_14, t0.company AS company_15, t0.phone AS phone_16, t0.is_collective_bill_enabled AS is_collective_bill_enabled_17 FROM user t0 WHERE t0.id = ?

Parameters:

[
  30451
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.token AS token_5,
  t0.token_requested_at AS token_requested_at_6,
  t0.email_verification_token AS email_verification_token_7,
  t0.email_verification_requested_at AS email_verification_requested_at_8,
  t0.is_verified AS is_verified_9,
  t0.meta AS meta_10,
  t0.created_at AS created_at_11,
  t0.firstname AS firstname_12,
  t0.lastname AS lastname_13,
  t0.identifier AS identifier_14,
  t0.company AS company_15,
  t0.phone AS phone_16,
  t0.is_collective_bill_enabled AS is_collective_bill_enabled_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.token AS token_5, t0.token_requested_at AS token_requested_at_6, t0.email_verification_token AS email_verification_token_7, t0.email_verification_requested_at AS email_verification_requested_at_8, t0.is_verified AS is_verified_9, t0.meta AS meta_10, t0.created_at AS created_at_11, t0.firstname AS firstname_12, t0.lastname AS lastname_13, t0.identifier AS identifier_14, t0.company AS company_15, t0.phone AS phone_16, t0.is_collective_bill_enabled AS is_collective_bill_enabled_17 FROM user t0 WHERE t0.id = 30451;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 6)

0.24 ms
(1.14%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.reference AS reference_3, t0.is_published AS is_published_4, t0.can_order_guest AS can_order_guest_5, t0.has_collective_bill AS has_collective_bill_6, t0.total_min AS total_min_7, t0.total_max AS total_max_8, t0.total_max_guest AS total_max_guest_9, t0.position AS position_10, t0.description AS description_11, t0.has_customer_number_check AS has_customer_number_check_12, t0.skip_payment_initialization AS skip_payment_initialization_13 FROM shop_payment_method t0 WHERE t0.id = ?

Parameters:

[
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.reference AS reference_3,
  t0.is_published AS is_published_4,
  t0.can_order_guest AS can_order_guest_5,
  t0.has_collective_bill AS has_collective_bill_6,
  t0.total_min AS total_min_7,
  t0.total_max AS total_max_8,
  t0.total_max_guest AS total_max_guest_9,
  t0.position AS position_10,
  t0.description AS description_11,
  t0.has_customer_number_check AS has_customer_number_check_12,
  t0.skip_payment_initialization AS skip_payment_initialization_13
FROM
  shop_payment_method t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.reference AS reference_3, t0.is_published AS is_published_4, t0.can_order_guest AS can_order_guest_5, t0.has_collective_bill AS has_collective_bill_6, t0.total_min AS total_min_7, t0.total_max AS total_max_8, t0.total_max_guest AS total_max_guest_9, t0.position AS position_10, t0.description AS description_11, t0.has_customer_number_check AS has_customer_number_check_12, t0.skip_payment_initialization AS skip_payment_initialization_13 FROM shop_payment_method t0 WHERE t0.id = 36;

#	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\Shop\PaymentMethod::{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\Shop\PaymentMethod->__get (line 153)
7	App\Entity\Shop\PaymentMethod->getTitle (line 83)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_d49e09c359f446883ae31288a9214dfa::block_account_content (line 167)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a->{closure:__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a::block_shop_body():91} (line 92)
12	Twig\Extension\CoreExtension->captureOutput (line 2116)
13	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a::block_shop_body (line 91)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_9087d03b9a135ef232b089eb31428f40->block_body (line 77)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 600)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_9087d03b9a135ef232b089eb31428f40->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a->doDisplay (line 55)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_d49e09c359f446883ae31288a9214dfa->doDisplay (line 58)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
32	App\Controller\ProfileController->orderShow (line 714)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	require_once (line 6)

0.21 ms
(0.98%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.category_id AS category_id_3, t0.qty AS qty_4, t0.type AS type_5, t0.unit_price AS unit_price_6, t0.line_total AS line_total_7, t0.snapshot AS snapshot_8, t0.payload AS payload_9, t0.project_code AS project_code_10, t0.upload_ids AS upload_ids_11, t0.created_at AS created_at_12, t0.order_id AS order_id_13 FROM shop_order_item t0 WHERE t0.order_id = ?

Parameters:

[
  176
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.category_id AS category_id_3,
  t0.qty AS qty_4,
  t0.type AS type_5,
  t0.unit_price AS unit_price_6,
  t0.line_total AS line_total_7,
  t0.snapshot AS snapshot_8,
  t0.payload AS payload_9,
  t0.project_code AS project_code_10,
  t0.upload_ids AS upload_ids_11,
  t0.created_at AS created_at_12,
  t0.order_id AS order_id_13
FROM
  shop_order_item t0
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.category_id AS category_id_3, t0.qty AS qty_4, t0.type AS type_5, t0.unit_price AS unit_price_6, t0.line_total AS line_total_7, t0.snapshot AS snapshot_8, t0.payload AS payload_9, t0.project_code AS project_code_10, t0.upload_ids AS upload_ids_11, t0.created_at AS created_at_12, t0.order_id AS order_id_13 FROM shop_order_item t0 WHERE t0.order_id = 176;

#	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->length (line 1278)
9	__TwigTemplate_d49e09c359f446883ae31288a9214dfa::block_account_content (line 370)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a->{closure:__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a::block_shop_body():91} (line 92)
12	Twig\Extension\CoreExtension->captureOutput (line 2116)
13	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a::block_shop_body (line 91)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_9087d03b9a135ef232b089eb31428f40->block_body (line 77)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 600)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_9087d03b9a135ef232b089eb31428f40->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a->doDisplay (line 55)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_d49e09c359f446883ae31288a9214dfa->doDisplay (line 58)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
32	App\Controller\ProfileController->orderShow (line 714)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	require_once (line 6)

0.20 ms
(0.97%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.fixed_price AS fixed_price_3, t0.description AS description_4, t0.hint AS hint_5, t0.is_published AS is_published_6, t0.position AS position_7 FROM shop_shipping_method t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.fixed_price AS fixed_price_3,
  t0.description AS description_4,
  t0.hint AS hint_5,
  t0.is_published AS is_published_6,
  t0.position AS position_7
FROM
  shop_shipping_method t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.fixed_price AS fixed_price_3, t0.description AS description_4, t0.hint AS hint_5, t0.is_published AS is_published_6, t0.position AS position_7 FROM shop_shipping_method t0 WHERE t0.id = 3;

#	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\Shop\ShippingMethod::{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\Shop\ShippingMethod->__get (line 153)
7	App\Entity\Shop\ShippingMethod->getTitle (line 63)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_d49e09c359f446883ae31288a9214dfa::block_account_content (line 181)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a->{closure:__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a::block_shop_body():91} (line 92)
12	Twig\Extension\CoreExtension->captureOutput (line 2116)
13	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a::block_shop_body (line 91)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_9087d03b9a135ef232b089eb31428f40->block_body (line 77)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_363658751dba418e42a9e762aa792f90->doDisplay (line 600)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_9087d03b9a135ef232b089eb31428f40->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_c6d6a2ed2bc0ff0d37031d91d454af4a->doDisplay (line 55)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_d49e09c359f446883ae31288a9214dfa->doDisplay (line 58)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
32	App\Controller\ProfileController->orderShow (line 714)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	require_once (line 6)

0.12 ms
(0.57%)

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\ProfileController->orderShow (line 717)
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)

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	78
App\Entity\Page\NavigationItem	75
App\Entity\Shop\Product	21
App\Entity\Footer\FooterLink	10
App\Entity\User	6
App\Entity\Footer\FooterColumn	3
App\Entity\Shop\Order	1
App\Entity\Shop\PaymentMethod	1
App\Entity\Shop\ShippingMethod	1
App\Entity\UserAddress	1
App\Entity\Shop\OrderItem	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Shop\Product	No errors.
App\Entity\Shop\Order	No errors.
App\Entity\UserAddress	No errors.
App\Entity\Shop\PaymentMethod	No errors.
App\Entity\Shop\ShippingMethod	No errors.
App\Entity\Shop\Voucher	No errors.
App\Entity\Shop\OrderItem	No errors.
App\Entity\Shop\OrderReclamation	No errors.
App\Entity\Page\NavigationItem	No errors.
App\Entity\Page\Page	No errors.
App\Entity\Page\Section	No errors.
App\Entity\Shop\Postage	No errors.
App\Entity\Shop\VariantGroupText	No errors.
App\Entity\Shop\Variant	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\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/account/orders/176

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping