Symfony Profiler

Query Metrics

40 Database Queries

19 Different statements

15.69 ms Query time

0 Invalid entities

81 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.68 ms
(61.70%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.code = ? ORDER BY t0.id ASC LIMIT 1

Parameters:

[
  "FASHION_WEB"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.code = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.code = 'FASHION_WEB' ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Sylius\Bundle\ChannelBundle\Doctrine\ORM\ChannelRepository->findOneByCode (line 42)
4	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\ChannelSelectorComponent->getChannelName (line 70)
5	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
6	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
7	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
8	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
9	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
10	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
11	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
12	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
13	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
14	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
15	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
16	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
17	__TwigTemplate_9a49dd45c98b630460fd7cef1eef24a7->doDisplay (line 54)
18	Twig\Template->yield (line 461)
19	Twig\Template->display (line 416)
20	Twig\Template->render (line 431)
21	Twig\TemplateWrapper->render (line 53)
22	Twig\Environment->render (line 343)
23	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
24	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
25	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
26	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
27	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
28	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
29	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
30	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
31	__TwigTemplate_97c7e36a2d25ae674620e4dd5d49444d->doDisplay (line 59)
32	Twig\Template->yield (line 461)
33	Twig\Template->display (line 416)
34	Twig\Template->render (line 431)
35	Twig\TemplateWrapper->render (line 53)
36	Twig\Environment->render (line 343)
37	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
38	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
39	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
40	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
41	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
42	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
43	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
44	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
45	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
46	Twig\Template->yield (line 461)
47	Twig\Template->display (line 416)
48	Twig\Template->render (line 431)
49	Twig\TemplateWrapper->render (line 53)
50	Twig\Environment->render (line 343)
51	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
52	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
53	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
54	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
55	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
56	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
57	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
58	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
59	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
60	Twig\Template->yieldBlock (line 493)
61	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
62	Twig\Template->yield (line 461)
63	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
64	Twig\Template->yield (line 461)
65	Twig\Template->display (line 416)
66	Twig\Template->render (line 431)
67	Twig\TemplateWrapper->render (line 53)
68	Twig\Environment->render (line 343)
69	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
70	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
71	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
72	Symfony\Component\HttpKernel\Kernel->handle (line 195)
73	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
74	require_once (line 32)
75	require_once (line 5)

1.07 ms
(6.82%)

SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.customer_group_id AS customer_group_id_12, t0.default_address_id AS default_address_id_13, t14.username AS username_15, t14.username_canonical AS username_canonical_16, t14.enabled AS enabled_17, t14.password AS password_18, t14.last_login AS last_login_19, t14.password_reset_token AS password_reset_token_20, t14.password_requested_at AS password_requested_at_21, t14.email_verification_token AS email_verification_token_22, t14.verified_at AS verified_at_23, t14.roles AS roles_24, t14.email AS email_25, t14.email_canonical AS email_canonical_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.id AS id_29, t14.customer_id AS customer_id_30 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t14 ON t14.customer_id = t0.id WHERE t0.id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.email_canonical AS email_canonical_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.birthday AS birthday_5,
  t0.gender AS gender_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.phone_number AS phone_number_9,
  t0.subscribed_to_newsletter AS subscribed_to_newsletter_10,
  t0.id AS id_11,
  t0.customer_group_id AS customer_group_id_12,
  t0.default_address_id AS default_address_id_13,
  t14.username AS username_15,
  t14.username_canonical AS username_canonical_16,
  t14.enabled AS enabled_17,
  t14.password AS password_18,
  t14.last_login AS last_login_19,
  t14.password_reset_token AS password_reset_token_20,
  t14.password_requested_at AS password_requested_at_21,
  t14.email_verification_token AS email_verification_token_22,
  t14.verified_at AS verified_at_23,
  t14.roles AS roles_24,
  t14.email AS email_25,
  t14.email_canonical AS email_canonical_26,
  t14.created_at AS created_at_27,
  t14.updated_at AS updated_at_28,
  t14.id AS id_29,
  t14.customer_id AS customer_id_30
FROM
  sylius_customer t0
  LEFT JOIN sylius_shop_user t14 ON t14.customer_id = t0.id
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.customer_group_id AS customer_group_id_12, t0.default_address_id AS default_address_id_13, t14.username AS username_15, t14.username_canonical AS username_canonical_16, t14.enabled AS enabled_17, t14.password AS password_18, t14.last_login AS last_login_19, t14.password_reset_token AS password_reset_token_20, t14.password_requested_at AS password_requested_at_21, t14.email_verification_token AS email_verification_token_22, t14.verified_at AS verified_at_23, t14.roles AS roles_24, t14.email AS email_25, t14.email_canonical AS email_canonical_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.id AS id_29, t14.customer_id AS customer_id_30 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t14 ON t14.customer_id = t0.id WHERE t0.id = 12;

#	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::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1869)
5	__TwigTemplate_9df535feb36616f83331fd1425ec2ecb::doDisplay (line 99)
6	Twig\Template->yield (line 461)
7	__TwigTemplate_0f5184c35d36acb7f45ab1c8f7017434->doDisplay (line 53)
8	Twig\Template->yield (line 461)
9	Twig\Template->display (line 416)
10	Twig\Template->render (line 431)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 89)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
13	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
14	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
15	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
16	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
17	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
18	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
19	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
20	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
21	__TwigTemplate_88fd6c0a1a07812036bed30853d1b169->doDisplay (line 55)
22	Twig\Template->yield (line 461)
23	Twig\Template->display (line 416)
24	Twig\Template->render (line 431)
25	Twig\TemplateWrapper->render (line 53)
26	Twig\Environment->render (line 343)
27	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
28	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
29	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
30	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
31	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
32	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
33	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
34	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
35	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
36	Twig\Template->yield (line 461)
37	Twig\Template->display (line 416)
38	Twig\Template->render (line 431)
39	Twig\TemplateWrapper->render (line 53)
40	Twig\Environment->render (line 343)
41	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
42	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
43	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
44	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
45	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
46	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
47	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
48	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
49	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
50	Twig\Template->yieldBlock (line 493)
51	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
52	Twig\Template->yield (line 461)
53	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
54	Twig\Template->yield (line 461)
55	Twig\Template->display (line 416)
56	Twig\Template->render (line 431)
57	Twig\TemplateWrapper->render (line 53)
58	Twig\Environment->render (line 343)
59	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
60	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
61	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
62	Symfony\Component\HttpKernel\Kernel->handle (line 195)
63	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
64	require_once (line 32)
65	require_once (line 5)

0.99 ms
(6.29%)

SELECT t0.quantity AS quantity_1, t0.unit_price AS unit_price_2, t0.original_unit_price AS original_unit_price_3, t0.units_total AS units_total_4, t0.adjustments_total AS adjustments_total_5, t0.total AS total_6, t0.is_immutable AS is_immutable_7, t0.id AS id_8, t0.product_name AS product_name_9, t0.variant_name AS variant_name_10, t0.version AS version_11, t0.order_id AS order_id_12, t0.variant_id AS variant_id_13 FROM sylius_order_item t0 WHERE t0.order_id = ? ORDER BY t0.id ASC

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.quantity AS quantity_1,
  t0.unit_price AS unit_price_2,
  t0.original_unit_price AS original_unit_price_3,
  t0.units_total AS units_total_4,
  t0.adjustments_total AS adjustments_total_5,
  t0.total AS total_6,
  t0.is_immutable AS is_immutable_7,
  t0.id AS id_8,
  t0.product_name AS product_name_9,
  t0.variant_name AS variant_name_10,
  t0.version AS version_11,
  t0.order_id AS order_id_12,
  t0.variant_id AS variant_id_13
FROM
  sylius_order_item t0
WHERE
  t0.order_id = ?
ORDER BY
  t0.id ASC

SELECT t0.quantity AS quantity_1, t0.unit_price AS unit_price_2, t0.original_unit_price AS original_unit_price_3, t0.units_total AS units_total_4, t0.adjustments_total AS adjustments_total_5, t0.total AS total_6, t0.is_immutable AS is_immutable_7, t0.id AS id_8, t0.product_name AS product_name_9, t0.variant_name AS variant_name_10, t0.version AS version_11, t0.order_id AS order_id_12, t0.variant_id AS variant_id_13 FROM sylius_order_item t0 WHERE t0.order_id = 20 ORDER BY t0.id 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 2799)
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 1299)
9	__TwigTemplate_9df535feb36616f83331fd1425ec2ecb::doDisplay (line 120)
10	Twig\Template->yield (line 461)
11	__TwigTemplate_0f5184c35d36acb7f45ab1c8f7017434->doDisplay (line 53)
12	Twig\Template->yield (line 461)
13	Twig\Template->display (line 416)
14	Twig\Template->render (line 431)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 89)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
17	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
18	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
19	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
20	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
21	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
22	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
23	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
24	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
25	__TwigTemplate_88fd6c0a1a07812036bed30853d1b169->doDisplay (line 55)
26	Twig\Template->yield (line 461)
27	Twig\Template->display (line 416)
28	Twig\Template->render (line 431)
29	Twig\TemplateWrapper->render (line 53)
30	Twig\Environment->render (line 343)
31	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
32	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
33	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
34	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
35	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
36	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
37	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
38	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
39	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
40	Twig\Template->yield (line 461)
41	Twig\Template->display (line 416)
42	Twig\Template->render (line 431)
43	Twig\TemplateWrapper->render (line 53)
44	Twig\Environment->render (line 343)
45	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
46	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
47	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
48	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
49	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
50	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
51	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
52	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
53	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
54	Twig\Template->yieldBlock (line 493)
55	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
56	Twig\Template->yield (line 461)
57	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
58	Twig\Template->yield (line 461)
59	Twig\Template->display (line 416)
60	Twig\Template->render (line 431)
61	Twig\TemplateWrapper->render (line 53)
62	Twig\Environment->render (line 343)
63	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
64	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
65	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
66	Symfony\Component\HttpKernel\Kernel->handle (line 195)
67	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
68	require_once (line 32)
69	require_once (line 5)

0.47 ms
(3.00%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.enabled = ?

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.enabled = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Sylius\Bundle\ChannelBundle\Doctrine\ORM\ChannelRepository->findEnabled (line 62)
4	Sylius\Bundle\AdminBundle\Twig\Component\Shared\Navbar\ShopPreviewComponent->getChannels (line 36)
5	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
6	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
7	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
8	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
9	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
10	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
11	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
12	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
13	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
14	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
15	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
16	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
17	__TwigTemplate_e0f2e3167a7f07f089e6c53d21c71533->doDisplay (line 54)
18	Twig\Template->yield (line 461)
19	Twig\Template->display (line 416)
20	Twig\Template->render (line 431)
21	Twig\TemplateWrapper->render (line 53)
22	Twig\Environment->render (line 343)
23	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
24	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
25	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
26	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
27	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
28	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
29	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
30	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
31	__TwigTemplate_335e7704891ccc108b8561e1986ec425->doDisplay (line 55)
32	Twig\Template->yield (line 461)
33	Twig\Template->display (line 416)
34	Twig\Template->render (line 431)
35	Twig\TemplateWrapper->render (line 53)
36	Twig\Environment->render (line 343)
37	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
38	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
39	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
40	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
41	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
42	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
43	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
44	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
45	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
46	Twig\Template->yieldBlock (line 493)
47	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
48	Twig\Template->yield (line 461)
49	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
50	Twig\Template->yield (line 461)
51	Twig\Template->display (line 416)
52	Twig\Template->render (line 431)
53	Twig\TemplateWrapper->render (line 53)
54	Twig\Environment->render (line 343)
55	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
56	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
57	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
58	Symfony\Component\HttpKernel\Kernel->handle (line 195)
59	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
60	require_once (line 32)
61	require_once (line 5)

0.34 ms
(2.15%)

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_product_variant s0_ WHERE s0_.tracked = ? AND s0_.on_hand = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sylius_product_variant s0_
WHERE
  s0_.tracked = ?
  AND s0_.on_hand = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_product_variant s0_ WHERE s0_.tracked = 1 AND s0_.on_hand = 0;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Sylius\Bundle\CoreBundle\Doctrine\ORM\ProductVariantRepository->countTrackedOutOfStock (line 92)
8	Sylius\Bundle\AdminBundle\PendingAction\Provider\CountProductVariantsOutOfStockProvider->count (line 27)
9	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\PendingActionCountComponent->getCount (line 44)
10	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
14	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
15	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
16	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
18	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
19	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
21	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
22	__TwigTemplate_da2f193d1a639979e7cbd6276b83816d->doDisplay (line 61)
23	Twig\Template->yield (line 461)
24	Twig\Template->display (line 416)
25	Twig\Template->render (line 431)
26	Twig\TemplateWrapper->render (line 53)
27	Twig\Environment->render (line 343)
28	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
29	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
30	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
32	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
33	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
35	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
36	__TwigTemplate_2a721408ac0ec697f01b378d96f7160b->doDisplay (line 55)
37	Twig\Template->yield (line 461)
38	Twig\Template->display (line 416)
39	Twig\Template->render (line 431)
40	Twig\TemplateWrapper->render (line 53)
41	Twig\Environment->render (line 343)
42	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
43	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
44	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
45	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
46	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
47	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
48	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
49	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
50	__TwigTemplate_88fd6c0a1a07812036bed30853d1b169->doDisplay (line 55)
51	Twig\Template->yield (line 461)
52	Twig\Template->display (line 416)
53	Twig\Template->render (line 431)
54	Twig\TemplateWrapper->render (line 53)
55	Twig\Environment->render (line 343)
56	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
57	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
58	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
59	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
60	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
61	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
62	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
63	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
64	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
65	Twig\Template->yield (line 461)
66	Twig\Template->display (line 416)
67	Twig\Template->render (line 431)
68	Twig\TemplateWrapper->render (line 53)
69	Twig\Environment->render (line 343)
70	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
71	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
72	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
73	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
74	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
75	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
76	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
77	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
78	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
79	Twig\Template->yieldBlock (line 493)
80	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
81	Twig\Template->yield (line 461)
82	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
83	Twig\Template->yield (line 461)
84	Twig\Template->display (line 416)
85	Twig\Template->render (line 431)
86	Twig\TemplateWrapper->render (line 53)
87	Twig\Environment->render (line 343)
88	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
89	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
90	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
91	Symfony\Component\HttpKernel\Kernel->handle (line 195)
92	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
93	require_once (line 32)
94	require_once (line 5)

0.29 ms
(1.86%)

SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.mollie_payment_id AS mollie_payment_id_18, s0_.qr_code AS qr_code_19, s0_.recurring_sequence_index AS recurring_sequence_index_20, s0_.abandoned_email AS abandoned_email_21, s0_.channel_id AS channel_id_22, s0_.promotion_coupon_id AS promotion_coupon_id_23, s0_.customer_id AS customer_id_24, s0_.shipping_address_id AS shipping_address_id_25, s0_.billing_address_id AS billing_address_id_26 FROM sylius_order s0_ WHERE s0_.channel_id = ? AND s0_.state <> ? ORDER BY s0_.checkout_completed_at DESC LIMIT 5

Parameters:

[
  1
  "cart"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.number AS number_0,
  s0_.notes AS notes_1,
  s0_.state AS state_2,
  s0_.checkout_completed_at AS checkout_completed_at_3,
  s0_.items_total AS items_total_4,
  s0_.adjustments_total AS adjustments_total_5,
  s0_.total AS total_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.id AS id_9,
  s0_.currency_code AS currency_code_10,
  s0_.locale_code AS locale_code_11,
  s0_.checkout_state AS checkout_state_12,
  s0_.payment_state AS payment_state_13,
  s0_.shipping_state AS shipping_state_14,
  s0_.created_by_guest AS created_by_guest_15,
  s0_.token_value AS token_value_16,
  s0_.customer_ip AS customer_ip_17,
  s0_.mollie_payment_id AS mollie_payment_id_18,
  s0_.qr_code AS qr_code_19,
  s0_.recurring_sequence_index AS recurring_sequence_index_20,
  s0_.abandoned_email AS abandoned_email_21,
  s0_.channel_id AS channel_id_22,
  s0_.promotion_coupon_id AS promotion_coupon_id_23,
  s0_.customer_id AS customer_id_24,
  s0_.shipping_address_id AS shipping_address_id_25,
  s0_.billing_address_id AS billing_address_id_26
FROM
  sylius_order s0_
WHERE
  s0_.channel_id = ?
  AND s0_.state <> ?
ORDER BY
  s0_.checkout_completed_at DESC
LIMIT
  5

SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.mollie_payment_id AS mollie_payment_id_18, s0_.qr_code AS qr_code_19, s0_.recurring_sequence_index AS recurring_sequence_index_20, s0_.abandoned_email AS abandoned_email_21, s0_.channel_id AS channel_id_22, s0_.promotion_coupon_id AS promotion_coupon_id_23, s0_.customer_id AS customer_id_24, s0_.shipping_address_id AS shipping_address_id_25, s0_.billing_address_id AS billing_address_id_26 FROM sylius_order s0_ WHERE s0_.channel_id = 1 AND s0_.state <> 'cart' ORDER BY s0_.checkout_completed_at DESC LIMIT 5;

#	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	Sylius\Bundle\CoreBundle\Doctrine\ORM\OrderRepository->findLatestInChannel (line 429)
7	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\NewOrdersComponent->getNewOrders (line 57)
8	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
9	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
10	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
12	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
13	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
14	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
15	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
16	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
17	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
18	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
19	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
20	__TwigTemplate_88fd6c0a1a07812036bed30853d1b169->doDisplay (line 55)
21	Twig\Template->yield (line 461)
22	Twig\Template->display (line 416)
23	Twig\Template->render (line 431)
24	Twig\TemplateWrapper->render (line 53)
25	Twig\Environment->render (line 343)
26	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
27	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
28	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
29	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
30	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
31	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
32	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
33	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
34	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
35	Twig\Template->yield (line 461)
36	Twig\Template->display (line 416)
37	Twig\Template->render (line 431)
38	Twig\TemplateWrapper->render (line 53)
39	Twig\Environment->render (line 343)
40	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
41	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
42	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
43	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
44	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
45	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
46	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
47	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
48	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
49	Twig\Template->yieldBlock (line 493)
50	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
51	Twig\Template->yield (line 461)
52	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
53	Twig\Template->yield (line 461)
54	Twig\Template->display (line 416)
55	Twig\Template->render (line 431)
56	Twig\TemplateWrapper->render (line 53)
57	Twig\Environment->render (line 343)
58	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
59	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
60	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
61	Symfony\Component\HttpKernel\Kernel->handle (line 195)
62	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
63	require_once (line 32)
64	require_once (line 5)

0.29 ms
(1.82%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1

Parameters:

[
  "webshop.scherstra.com"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.hostname = ?
  AND t0.enabled = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = 'webshop.scherstra.com' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Sylius\Bundle\ChannelBundle\Doctrine\ORM\ChannelRepository->findOneEnabledByHostname (line 37)
4	Sylius\Component\Channel\Context\RequestBased\HostnameBasedRequestResolver->findChannel (line 32)
5	Sylius\Component\Channel\Context\RequestBased\CompositeRequestResolver->findChannel (line 38)
6	Sylius\Component\Channel\Context\RequestBased\ChannelContext->getChannelForRequest (line 39)
7	Sylius\Component\Channel\Context\RequestBased\ChannelContext->getChannel (line 31)
8	Sylius\Component\Channel\Context\CompositeChannelContext->getChannel (line 38)
9	Sylius\Component\Channel\Context\CachedPerRequestChannelContext->getChannel (line 44)
10	Sylius\Component\Core\Provider\ChannelBasedLocaleProvider->getDefaultLocaleCode (line 50)
11	Sylius\Bundle\LocaleBundle\Listener\RequestLocaleSetter->onKernelRequest (line 35)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 161)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 195)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	require_once (line 5)

0.28 ms
(1.79%)

SELECT SUM(s0_.total) AS sclr_0 FROM sylius_order s0_ WHERE s0_.payment_state = ? AND s0_.channel_id = ? AND s0_.checkout_completed_at >= ? AND s0_.checkout_completed_at <= ?

Parameters:

[
  "paid"
  1
  "2025-11-01 12:48:02"
  "2026-11-01 12:48:02"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(s0_.total) AS sclr_0
FROM
  sylius_order s0_
WHERE
  s0_.payment_state = ?
  AND s0_.channel_id = ?
  AND s0_.checkout_completed_at >= ?
  AND s0_.checkout_completed_at <= ?

SELECT SUM(s0_.total) AS sclr_0 FROM sylius_order s0_ WHERE s0_.payment_state = 'paid' AND s0_.channel_id = 1 AND s0_.checkout_completed_at >= '2025-11-01 12:48:02' AND s0_.checkout_completed_at <= '2026-11-01 12:48:02';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Sylius\Bundle\CoreBundle\Doctrine\ORM\OrderRepository->getTotalPaidSalesForChannelInPeriod (line 325)
8	Sylius\Component\Core\Statistics\Provider\BusinessActivitySummaryProvider->provide (line 40)
9	Sylius\Component\Core\Statistics\Provider\StatisticsProvider->provide (line 30)
10	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\StatisticsComponent->getStatistics (line 83)
11	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
12	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
15	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
16	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
18	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
19	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
21	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
22	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
23	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
24	Twig\Template->yield (line 461)
25	Twig\Template->display (line 416)
26	Twig\Template->render (line 431)
27	Twig\TemplateWrapper->render (line 53)
28	Twig\Environment->render (line 343)
29	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
30	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
32	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
33	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
35	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
36	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
37	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
38	Twig\Template->yieldBlock (line 493)
39	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
40	Twig\Template->yield (line 461)
41	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
42	Twig\Template->yield (line 461)
43	Twig\Template->display (line 416)
44	Twig\Template->render (line 431)
45	Twig\TemplateWrapper->render (line 53)
46	Twig\Environment->render (line 343)
47	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
50	Symfony\Component\HttpKernel\Kernel->handle (line 195)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
52	require_once (line 32)
53	require_once (line 5)

0.28 ms
(1.79%)

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.password_reset_token AS password_reset_token_6, t0.password_requested_at AS password_requested_at_7, t0.email_verification_token AS email_verification_token_8, t0.verified_at AS verified_at_9, t0.roles AS roles_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.id AS id_15, t0.first_name AS first_name_16, t0.last_name AS last_name_17, t0.locale_code AS locale_code_18, t0.mollie_onboarding_completed AS mollie_onboarding_completed_19, t20.type AS type_21, t20.path AS path_22, t20.id AS id_23, t20.owner_id AS owner_id_24 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t20 ON t20.owner_id = t0.id WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.enabled AS enabled_3,
  t0.password AS password_4,
  t0.last_login AS last_login_5,
  t0.password_reset_token AS password_reset_token_6,
  t0.password_requested_at AS password_requested_at_7,
  t0.email_verification_token AS email_verification_token_8,
  t0.verified_at AS verified_at_9,
  t0.roles AS roles_10,
  t0.email AS email_11,
  t0.email_canonical AS email_canonical_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.id AS id_15,
  t0.first_name AS first_name_16,
  t0.last_name AS last_name_17,
  t0.locale_code AS locale_code_18,
  t0.mollie_onboarding_completed AS mollie_onboarding_completed_19,
  t20.type AS type_21,
  t20.path AS path_22,
  t20.id AS id_23,
  t20.owner_id AS owner_id_24
FROM
  sylius_admin_user t0
  LEFT JOIN sylius_avatar_image t20 ON t20.owner_id = t0.id
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.password_reset_token AS password_reset_token_6, t0.password_requested_at AS password_requested_at_7, t0.email_verification_token AS email_verification_token_8, t0.verified_at AS verified_at_9, t0.roles AS roles_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.id AS id_15, t0.first_name AS first_name_16, t0.last_name AS last_name_17, t0.locale_code AS locale_code_18, t0.mollie_onboarding_completed AS mollie_onboarding_completed_19, t20.type AS type_21, t20.path AS path_22, t20.id AS id_23, t20.owner_id AS owner_id_24 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t20 ON t20.owner_id = t0.id 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\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Sylius\Bundle\UserBundle\Provider\AbstractUserProvider->refreshUser (line 69)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 231)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
10	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 161)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 195)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
19	require_once (line 32)
20	require_once (line 5)

0.26 ms
(1.67%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.enabled = ? ORDER BY t0.id ASC LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.enabled = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Sylius\Bundle\AdminBundle\Controller\DashboardController->findChannelByCodeOrFindFirst (line 57)
4	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 37)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 195)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.25 ms
(1.60%)

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_payment s0_ INNER JOIN sylius_order s1_ ON s0_.order_id = s1_.id WHERE s0_.state = ? AND s1_.channel_id = ?

Parameters:

[
  "new"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sylius_payment s0_
  INNER JOIN sylius_order s1_ ON s0_.order_id = s1_.id
WHERE
  s0_.state = ?
  AND s1_.channel_id = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_payment s0_ INNER JOIN sylius_order s1_ ON s0_.order_id = s1_.id WHERE s0_.state = 'new' AND s1_.channel_id = 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Sylius\Bundle\CoreBundle\Doctrine\ORM\PaymentRepository->countNewByChannel (line 103)
8	Sylius\Bundle\AdminBundle\PendingAction\Provider\CountPendingPaymentsProvider->count (line 30)
9	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\PendingActionCountComponent->getCount (line 44)
10	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
14	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
15	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
16	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
18	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
19	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
21	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
22	__TwigTemplate_da2f193d1a639979e7cbd6276b83816d->doDisplay (line 61)
23	Twig\Template->yield (line 461)
24	Twig\Template->display (line 416)
25	Twig\Template->render (line 431)
26	Twig\TemplateWrapper->render (line 53)
27	Twig\Environment->render (line 343)
28	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
29	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
30	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
32	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
33	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
35	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
36	__TwigTemplate_2a721408ac0ec697f01b378d96f7160b->doDisplay (line 55)
37	Twig\Template->yield (line 461)
38	Twig\Template->display (line 416)
39	Twig\Template->render (line 431)
40	Twig\TemplateWrapper->render (line 53)
41	Twig\Environment->render (line 343)
42	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
43	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
44	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
45	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
46	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
47	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
48	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
49	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
50	__TwigTemplate_88fd6c0a1a07812036bed30853d1b169->doDisplay (line 55)
51	Twig\Template->yield (line 461)
52	Twig\Template->display (line 416)
53	Twig\Template->render (line 431)
54	Twig\TemplateWrapper->render (line 53)
55	Twig\Environment->render (line 343)
56	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
57	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
58	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
59	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
60	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
61	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
62	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
63	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
64	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
65	Twig\Template->yield (line 461)
66	Twig\Template->display (line 416)
67	Twig\Template->render (line 431)
68	Twig\TemplateWrapper->render (line 53)
69	Twig\Environment->render (line 343)
70	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
71	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
72	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
73	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
74	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
75	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
76	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
77	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
78	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
79	Twig\Template->yieldBlock (line 493)
80	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
81	Twig\Template->yield (line 461)
82	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
83	Twig\Template->yield (line 461)
84	Twig\Template->display (line 416)
85	Twig\Template->render (line 431)
86	Twig\TemplateWrapper->render (line 53)
87	Twig\Environment->render (line 343)
88	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
89	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
90	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
91	Symfony\Component\HttpKernel\Kernel->handle (line 195)
92	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
93	require_once (line 32)
94	require_once (line 5)

0.25 ms
(1.57%)

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_order s0_ WHERE s0_.channel_id = ? AND s0_.payment_state = ? AND s0_.checkout_completed_at >= ? AND s0_.checkout_completed_at <= ?

Parameters:

[
  1
  "paid"
  "2025-11-01 12:48:02"
  "2026-11-01 12:48:02"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sylius_order s0_
WHERE
  s0_.channel_id = ?
  AND s0_.payment_state = ?
  AND s0_.checkout_completed_at >= ?
  AND s0_.checkout_completed_at <= ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_order s0_ WHERE s0_.channel_id = 1 AND s0_.payment_state = 'paid' AND s0_.checkout_completed_at >= '2025-11-01 12:48:02' AND s0_.checkout_completed_at <= '2026-11-01 12:48:02';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Sylius\Bundle\CoreBundle\Doctrine\ORM\OrderRepository->countPaidForChannelInPeriod (line 415)
8	Sylius\Component\Core\Statistics\Provider\BusinessActivitySummaryProvider->provide (line 43)
9	Sylius\Component\Core\Statistics\Provider\StatisticsProvider->provide (line 30)
10	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\StatisticsComponent->getStatistics (line 83)
11	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
12	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
15	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
16	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
18	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
19	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
21	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
22	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
23	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
24	Twig\Template->yield (line 461)
25	Twig\Template->display (line 416)
26	Twig\Template->render (line 431)
27	Twig\TemplateWrapper->render (line 53)
28	Twig\Environment->render (line 343)
29	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
30	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
32	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
33	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
35	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
36	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
37	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
38	Twig\Template->yieldBlock (line 493)
39	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
40	Twig\Template->yield (line 461)
41	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
42	Twig\Template->yield (line 461)
43	Twig\Template->display (line 416)
44	Twig\Template->render (line 431)
45	Twig\TemplateWrapper->render (line 53)
46	Twig\Environment->render (line 343)
47	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
50	Symfony\Component\HttpKernel\Kernel->handle (line 195)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
52	require_once (line 32)
53	require_once (line 5)

0.24 ms
(1.51%)

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_customer s0_ WHERE s0_.created_at >= ? AND s0_.created_at <= ?

Parameters:

[
  "2025-11-01 12:48:02"
  "2026-11-01 12:48:02"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sylius_customer s0_
WHERE
  s0_.created_at >= ?
  AND s0_.created_at <= ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_customer s0_ WHERE s0_.created_at >= '2025-11-01 12:48:02' AND s0_.created_at <= '2026-11-01 12:48:02';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Sylius\Bundle\CoreBundle\Doctrine\ORM\CustomerRepository->countCustomersInPeriod (line 45)
8	Sylius\Component\Core\Statistics\Provider\BusinessActivitySummaryProvider->provide (line 46)
9	Sylius\Component\Core\Statistics\Provider\StatisticsProvider->provide (line 30)
10	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\StatisticsComponent->getStatistics (line 83)
11	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
12	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
15	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
16	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
18	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
19	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
21	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
22	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
23	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
24	Twig\Template->yield (line 461)
25	Twig\Template->display (line 416)
26	Twig\Template->render (line 431)
27	Twig\TemplateWrapper->render (line 53)
28	Twig\Environment->render (line 343)
29	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
30	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
32	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
33	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
35	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
36	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
37	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
38	Twig\Template->yieldBlock (line 493)
39	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
40	Twig\Template->yield (line 461)
41	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
42	Twig\Template->yield (line 461)
43	Twig\Template->display (line 416)
44	Twig\Template->render (line 431)
45	Twig\TemplateWrapper->render (line 53)
46	Twig\Environment->render (line 343)
47	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
50	Symfony\Component\HttpKernel\Kernel->handle (line 195)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
52	require_once (line 32)
53	require_once (line 5)

0.22 ms
(1.40%)

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_shipment s0_ INNER JOIN sylius_order s1_ ON s0_.order_id = s1_.id WHERE s0_.state = ? AND s1_.channel_id = ?

Parameters:

[
  "ready"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sylius_shipment s0_
  INNER JOIN sylius_order s1_ ON s0_.order_id = s1_.id
WHERE
  s0_.state = ?
  AND s1_.channel_id = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_shipment s0_ INNER JOIN sylius_order s1_ ON s0_.order_id = s1_.id WHERE s0_.state = 'ready' AND s1_.channel_id = 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Sylius\Bundle\CoreBundle\Doctrine\ORM\ShipmentRepository->countReadyByChannel (line 118)
8	Sylius\Bundle\AdminBundle\PendingAction\Provider\CountShipmentsToShipProvider->count (line 30)
9	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\PendingActionCountComponent->getCount (line 44)
10	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
14	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
15	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
16	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
18	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
19	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
21	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
22	__TwigTemplate_da2f193d1a639979e7cbd6276b83816d->doDisplay (line 61)
23	Twig\Template->yield (line 461)
24	Twig\Template->display (line 416)
25	Twig\Template->render (line 431)
26	Twig\TemplateWrapper->render (line 53)
27	Twig\Environment->render (line 343)
28	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
29	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
30	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
32	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
33	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
35	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
36	__TwigTemplate_2a721408ac0ec697f01b378d96f7160b->doDisplay (line 55)
37	Twig\Template->yield (line 461)
38	Twig\Template->display (line 416)
39	Twig\Template->render (line 431)
40	Twig\TemplateWrapper->render (line 53)
41	Twig\Environment->render (line 343)
42	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
43	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
44	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
45	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
46	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
47	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
48	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
49	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
50	__TwigTemplate_88fd6c0a1a07812036bed30853d1b169->doDisplay (line 55)
51	Twig\Template->yield (line 461)
52	Twig\Template->display (line 416)
53	Twig\Template->render (line 431)
54	Twig\TemplateWrapper->render (line 53)
55	Twig\Environment->render (line 343)
56	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
57	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
58	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
59	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
60	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
61	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
62	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
63	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
64	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
65	Twig\Template->yield (line 461)
66	Twig\Template->display (line 416)
67	Twig\Template->render (line 431)
68	Twig\TemplateWrapper->render (line 53)
69	Twig\Environment->render (line 343)
70	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
71	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
72	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
73	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
74	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
75	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
76	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
77	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
78	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
79	Twig\Template->yieldBlock (line 493)
80	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
81	Twig\Template->yield (line 461)
82	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
83	Twig\Template->yield (line 461)
84	Twig\Template->display (line 416)
85	Twig\Template->render (line 431)
86	Twig\TemplateWrapper->render (line 53)
87	Twig\Environment->render (line 343)
88	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
89	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
90	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
91	Symfony\Component\HttpKernel\Kernel->handle (line 195)
92	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
93	require_once (line 32)
94	require_once (line 5)

0.20 ms
(1.24%)

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_order s0_ WHERE s0_.state = ? AND s0_.channel_id = ?

Parameters:

[
  "new"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sylius_order s0_
WHERE
  s0_.state = ?
  AND s0_.channel_id = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_order s0_ WHERE s0_.state = 'new' AND s0_.channel_id = 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Sylius\Bundle\CoreBundle\Doctrine\ORM\OrderRepository->countNewByChannel (line 615)
8	Sylius\Bundle\AdminBundle\PendingAction\Provider\CountOrdersToProcessProvider->count (line 30)
9	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\PendingActionCountComponent->getCount (line 44)
10	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
14	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
15	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
16	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
18	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
19	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
21	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
22	__TwigTemplate_da2f193d1a639979e7cbd6276b83816d->doDisplay (line 61)
23	Twig\Template->yield (line 461)
24	Twig\Template->display (line 416)
25	Twig\Template->render (line 431)
26	Twig\TemplateWrapper->render (line 53)
27	Twig\Environment->render (line 343)
28	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
29	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
30	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
32	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
33	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
35	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
36	__TwigTemplate_2a721408ac0ec697f01b378d96f7160b->doDisplay (line 55)
37	Twig\Template->yield (line 461)
38	Twig\Template->display (line 416)
39	Twig\Template->render (line 431)
40	Twig\TemplateWrapper->render (line 53)
41	Twig\Environment->render (line 343)
42	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
43	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
44	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
45	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
46	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
47	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
48	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
49	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
50	__TwigTemplate_88fd6c0a1a07812036bed30853d1b169->doDisplay (line 55)
51	Twig\Template->yield (line 461)
52	Twig\Template->display (line 416)
53	Twig\Template->render (line 431)
54	Twig\TemplateWrapper->render (line 53)
55	Twig\Environment->render (line 343)
56	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
57	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
58	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
59	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
60	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
61	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
62	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
63	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
64	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
65	Twig\Template->yield (line 461)
66	Twig\Template->display (line 416)
67	Twig\Template->render (line 431)
68	Twig\TemplateWrapper->render (line 53)
69	Twig\Environment->render (line 343)
70	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
71	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
72	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
73	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
74	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
75	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
76	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
77	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
78	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
79	Twig\Template->yieldBlock (line 493)
80	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
81	Twig\Template->yield (line 461)
82	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
83	Twig\Template->yield (line 461)
84	Twig\Template->display (line 416)
85	Twig\Template->render (line 431)
86	Twig\TemplateWrapper->render (line 53)
87	Twig\Environment->render (line 343)
88	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
89	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
90	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
91	Symfony\Component\HttpKernel\Kernel->handle (line 195)
92	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
93	require_once (line 32)
94	require_once (line 5)

0.18 ms
(1.14%)

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_product_review s0_ WHERE s0_.status = ?

Parameters:

[
  "new"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sylius_product_review s0_
WHERE
  s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_product_review s0_ WHERE s0_.status = 'new';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Sylius\Bundle\CoreBundle\Doctrine\ORM\ProductReviewRepository->countNew (line 107)
8	Sylius\Bundle\AdminBundle\PendingAction\Provider\CountProductReviewsToApproveProvider->count (line 27)
9	Sylius\Bundle\AdminBundle\Twig\Component\Dashboard\PendingActionCountComponent->getCount (line 44)
10	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
14	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
15	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
16	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
18	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
19	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
21	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
22	__TwigTemplate_da2f193d1a639979e7cbd6276b83816d->doDisplay (line 61)
23	Twig\Template->yield (line 461)
24	Twig\Template->display (line 416)
25	Twig\Template->render (line 431)
26	Twig\TemplateWrapper->render (line 53)
27	Twig\Environment->render (line 343)
28	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
29	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
30	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
32	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
33	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
35	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
36	__TwigTemplate_2a721408ac0ec697f01b378d96f7160b->doDisplay (line 55)
37	Twig\Template->yield (line 461)
38	Twig\Template->display (line 416)
39	Twig\Template->render (line 431)
40	Twig\TemplateWrapper->render (line 53)
41	Twig\Environment->render (line 343)
42	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
43	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
44	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
45	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
46	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
47	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
48	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
49	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
50	__TwigTemplate_88fd6c0a1a07812036bed30853d1b169->doDisplay (line 55)
51	Twig\Template->yield (line 461)
52	Twig\Template->display (line 416)
53	Twig\Template->render (line 431)
54	Twig\TemplateWrapper->render (line 53)
55	Twig\Environment->render (line 343)
56	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
57	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
58	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
59	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
60	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
61	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
62	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
63	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
64	__TwigTemplate_0ac96e0f8bdc4850380b2f8328ba59e9->doDisplay (line 54)
65	Twig\Template->yield (line 461)
66	Twig\Template->display (line 416)
67	Twig\Template->render (line 431)
68	Twig\TemplateWrapper->render (line 53)
69	Twig\Environment->render (line 343)
70	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
71	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
72	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
73	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
74	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
75	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
76	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
77	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
78	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
79	Twig\Template->yieldBlock (line 493)
80	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
81	Twig\Template->yield (line 461)
82	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
83	Twig\Template->yield (line 461)
84	Twig\Template->display (line 416)
85	Twig\Template->render (line 431)
86	Twig\TemplateWrapper->render (line 53)
87	Twig\Environment->render (line 343)
88	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
89	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
90	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
91	Symfony\Component\HttpKernel\Kernel->handle (line 195)
92	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
93	require_once (line 32)
94	require_once (line 5)

0.15 ms
(0.94%)

SELECT t0.code AS code_1, t0.environment AS environment_2, t0.is_enabled AS is_enabled_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.gateway_config_id AS gateway_config_id_8 FROM sylius_payment_method t0 WHERE t0.is_enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.environment AS environment_2,
  t0.is_enabled AS is_enabled_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7,
  t0.gateway_config_id AS gateway_config_id_8
FROM
  sylius_payment_method t0
WHERE
  t0.is_enabled = ?

SELECT t0.code AS code_1, t0.environment AS environment_2, t0.is_enabled AS is_enabled_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.gateway_config_id AS gateway_config_id_8 FROM sylius_payment_method t0 WHERE t0.is_enabled = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	FluxSE\SyliusStripePlugin\Stripe\SecretKey\LegacyStripePaymentMethodsProvider->provide (line 30)
4	FluxSE\SyliusStripePlugin\Notification\LegacyStripeKeyNotificationProvider->getNotifications (line 21)
5	Sylius\Bundle\AdminBundle\Notification\CompositeNotificationProvider->getNotifications (line 40)
6	Sylius\Bundle\AdminBundle\Twig\Component\Shared\Navbar\NotificationsComponent->getNotifications (line 38)
7	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
8	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
9	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
10	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
11	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
12	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
13	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
14	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
15	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
16	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
17	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
18	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
19	__TwigTemplate_e0f2e3167a7f07f089e6c53d21c71533->doDisplay (line 54)
20	Twig\Template->yield (line 461)
21	Twig\Template->display (line 416)
22	Twig\Template->render (line 431)
23	Twig\TemplateWrapper->render (line 53)
24	Twig\Environment->render (line 343)
25	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
26	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
27	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
28	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
29	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
30	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
31	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
32	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
33	__TwigTemplate_335e7704891ccc108b8561e1986ec425->doDisplay (line 55)
34	Twig\Template->yield (line 461)
35	Twig\Template->display (line 416)
36	Twig\Template->render (line 431)
37	Twig\TemplateWrapper->render (line 53)
38	Twig\Environment->render (line 343)
39	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
40	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
41	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
42	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
43	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
44	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
45	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
46	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
47	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
48	Twig\Template->yieldBlock (line 493)
49	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
50	Twig\Template->yield (line 461)
51	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
52	Twig\Template->yield (line 461)
53	Twig\Template->display (line 416)
54	Twig\Template->render (line 431)
55	Twig\TemplateWrapper->render (line 53)
56	Twig\Environment->render (line 343)
57	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
58	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
59	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
60	Symfony\Component\HttpKernel\Kernel->handle (line 195)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
62	require_once (line 32)
63	require_once (line 5)

0.14 ms
(0.90%)

SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.gateway_name AS gateway_name_1,
  t0.factory_name AS factory_name_2,
  t0.config AS config_3,
  t0.id AS id_4,
  t0.use_payum AS use_payum_5
FROM
  sylius_gateway_config t0
WHERE
  t0.id = ?

SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = 2;

#	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::getProxy():217} (line 223)
4	Sylius\Bundle\PayumBundle\Model\GatewayConfig::getConfig (line 43)
5	Sylius\Bundle\PaymentBundle\Provider\GatewayFactoryNameProvider->provide (line 27)
6	FluxSE\SyliusStripePlugin\Stripe\SecretKey\LegacyStripePaymentMethodsProvider->provide (line 38)
7	FluxSE\SyliusStripePlugin\Notification\LegacyStripeKeyNotificationProvider->getNotifications (line 21)
8	Sylius\Bundle\AdminBundle\Notification\CompositeNotificationProvider->getNotifications (line 40)
9	Sylius\Bundle\AdminBundle\Twig\Component\Shared\Navbar\NotificationsComponent->getNotifications (line 38)
10	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 67)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 128)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 75)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 68)
14	Sylius\TwigHooks\Hookable\Renderer\HookableComponentRenderer->render (line 48)
15	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
16	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
17	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
18	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
19	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
20	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
21	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 116)
22	__TwigTemplate_e0f2e3167a7f07f089e6c53d21c71533->doDisplay (line 54)
23	Twig\Template->yield (line 461)
24	Twig\Template->display (line 416)
25	Twig\Template->render (line 431)
26	Twig\TemplateWrapper->render (line 53)
27	Twig\Environment->render (line 343)
28	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
29	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
30	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
31	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
32	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
33	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
34	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
35	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
36	__TwigTemplate_335e7704891ccc108b8561e1986ec425->doDisplay (line 55)
37	Twig\Template->yield (line 461)
38	Twig\Template->display (line 416)
39	Twig\Template->render (line 431)
40	Twig\TemplateWrapper->render (line 53)
41	Twig\Environment->render (line 343)
42	Sylius\TwigHooks\Hookable\Renderer\HookableTemplateRenderer->render (line 48)
43	Sylius\TwigHooks\Hookable\Renderer\CompositeHookableRenderer->render (line 45)
44	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableProfilerRenderer->render (line 36)
45	Sylius\TwigHooks\Hookable\Renderer\Debug\HookableDebugCommentRenderer->render (line 37)
46	Sylius\TwigHooks\Hook\Renderer\HookRenderer->render (line 65)
47	Sylius\TwigHooks\Hook\Renderer\Debug\HookProfilerRenderer->render (line 34)
48	Sylius\TwigHooks\Hook\Renderer\Debug\HookDebugCommentRenderer->render (line 33)
49	Sylius\TwigHooks\Twig\Runtime\HooksRuntime->renderHook (line 104)
50	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->block_body (line 113)
51	Twig\Template->yieldBlock (line 493)
52	__TwigTemplate_7b3a5747849f88167a96c9aff5525f00->doDisplay (line 97)
53	Twig\Template->yield (line 461)
54	__TwigTemplate_af05d3ce699296855c5a0f3fc445fdd5->doDisplay (line 59)
55	Twig\Template->yield (line 461)
56	Twig\Template->display (line 416)
57	Twig\Template->render (line 431)
58	Twig\TemplateWrapper->render (line 53)
59	Twig\Environment->render (line 343)
60	Sylius\Bundle\AdminBundle\Controller\DashboardController->__invoke (line 43)
61	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
62	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
63	Symfony\Component\HttpKernel\Kernel->handle (line 195)
64	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
65	require_once (line 32)
66	require_once (line 5)

0.12 ms
(0.78%)

SELECT COUNT(*) FROM sylius_channel t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  sylius_channel t0

SELECT COUNT(*) FROM sylius_channel t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Sylius\Bundle\ChannelBundle\Doctrine\ORM\ChannelRepository->countAll (line 69)
4	Sylius\Component\Channel\Context\SingleChannelContext->getChannel (line 27)
5	Sylius\Component\Channel\Context\CompositeChannelContext->getChannel (line 38)
6	Sylius\Component\Channel\Context\CachedPerRequestChannelContext->getChannel (line 44)
7	Sylius\Component\Core\Provider\ChannelBasedLocaleProvider->getDefaultLocaleCode (line 50)
8	Sylius\Bundle\LocaleBundle\Listener\RequestLocaleSetter->onKernelRequest (line 35)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 161)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 195)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	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\Order\OrderItem	20
App\Entity\Product\ProductVariant	20
App\Entity\Addressing\Address	10
App\Entity\Order\Order	5
App\Entity\Customer\Customer	5
App\Entity\User\ShopUser	5
App\Entity\Channel\Channel	2
App\Entity\Channel\ShopBillingData	2
App\Entity\Channel\ChannelPriceHistoryConfig	2
App\Entity\Locale\Locale	2
App\Entity\Customer\CustomerGroup	2
App\Entity\User\AdminUser	1
App\Entity\Addressing\Zone	1
App\Entity\Taxonomy\Taxon	1
App\Entity\Currency\Currency	1
App\Entity\Payment\PaymentMethod	1
App\Entity\Payment\GatewayConfig	1

Entities Mapping

Class	Mapping errors
Sylius\Component\Payment\Model\PaymentMethod	No errors.
Sylius\Component\Core\Model\PaymentMethod	No errors.
App\Entity\Payment\PaymentMethod	No errors.
Sylius\Component\Order\Model\Order	No errors.
Sylius\Component\Core\Model\Order	No errors.
App\Entity\Order\Order	No errors.
Sylius\Component\Shipping\Model\Shipment	No errors.
Sylius\Component\Core\Model\Shipment	No errors.
App\Entity\Shipping\Shipment	No errors.
Sylius\Component\Taxonomy\Model\Taxon	No errors.
Sylius\Component\Core\Model\Taxon	No errors.
App\Entity\Taxonomy\Taxon	No errors.
Sylius\Component\User\Model\User	No errors.
Sylius\Component\Core\Model\AdminUser	No errors.
App\Entity\User\AdminUser	No errors.
Sylius\Component\Core\Model\Image	No errors.
Sylius\Component\Core\Model\AvatarImage	No errors.
App\Entity\User\AvatarImage	No errors.
Sylius\Component\User\Model\UserOAuth	No errors.
App\Entity\User\UserOAuth	No errors.
Sylius\Component\Channel\Model\Channel	No errors.
Sylius\Component\Core\Model\Channel	No errors.
App\Entity\Channel\Channel	No errors.
Sylius\Component\Locale\Model\Locale	No errors.
App\Entity\Locale\Locale	No errors.
Sylius\Component\Currency\Model\Currency	No errors.
App\Entity\Currency\Currency	No errors.
Sylius\Component\Addressing\Model\Zone	No errors.
App\Entity\Addressing\Zone	No errors.
Sylius\Component\Core\Model\ShopBillingData	No errors.
App\Entity\Channel\ShopBillingData	No errors.
Sylius\Component\Core\Model\ChannelPriceHistoryConfig	No errors.
App\Entity\Channel\ChannelPriceHistoryConfig	No errors.
Sylius\Component\Currency\Model\ExchangeRate	No errors.
App\Entity\Currency\ExchangeRate	No errors.
Sylius\MolliePlugin\Entity\MollieGatewayConfig	No errors.
Sylius\MolliePlugin\Entity\MollieLogger	No errors.
Sylius\Component\Payment\Model\GatewayConfig	No errors.
Sylius\Bundle\PayumBundle\Model\GatewayConfig	No errors.
App\Entity\Payment\GatewayConfig	No errors.
Sylius\Component\Shipping\Model\ShippingMethod	No errors.
Sylius\Component\Core\Model\ShippingMethod	No errors.
App\Entity\Shipping\ShippingMethod	No errors.
Sylius\MolliePlugin\Entity\MollieCustomer	No errors.
Sylius\RefundPlugin\Entity\Refund	No errors.
Sylius\RefundPlugin\Entity\RefundPayment	No errors.
Sylius\Component\Order\Model\OrderItemUnit	No errors.
Sylius\Component\Core\Model\OrderItemUnit	No errors.
App\Entity\Order\OrderItemUnit	No errors.
Sylius\AdyenPlugin\Entity\AdyenPaymentDetail	No errors.
Sylius\AdyenPlugin\Entity\PaymentLink	No errors.
Sylius\AdyenPlugin\Entity\AdyenReference	No errors.
Sylius\Component\Addressing\Model\Country	No errors.
App\Entity\Addressing\Country	No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation	No errors.
App\Entity\Payment\PaymentMethodTranslation	No errors.
Sylius\Component\Customer\Model\Customer	No errors.
Sylius\Component\Core\Model\Customer	No errors.
App\Entity\Customer\Customer	No errors.
Sylius\Component\Payment\Model\Payment	No errors.
Sylius\Component\Core\Model\Payment	No errors.
App\Entity\Payment\Payment	No errors.
Sylius\Component\Review\Model\Review	No errors.
Sylius\Component\Core\Model\ProductReview	No errors.
App\Entity\Product\ProductReview	No errors.
Sylius\Component\Product\Model\ProductVariant	No errors.
Sylius\Component\Core\Model\ProductVariant	No errors.
App\Entity\Product\ProductVariant	No errors.
Sylius\Component\Promotion\Model\PromotionCoupon	No errors.
Sylius\Component\Core\Model\PromotionCoupon	No errors.
App\Entity\Promotion\PromotionCoupon	No errors.
Sylius\Component\Addressing\Model\Address	No errors.
Sylius\Component\Core\Model\Address	No errors.
App\Entity\Addressing\Address	No errors.
Sylius\Component\Promotion\Model\Promotion	No errors.
Sylius\Component\Core\Model\Promotion	No errors.
App\Entity\Promotion\Promotion	No errors.
Sylius\Component\Order\Model\OrderItem	No errors.
Sylius\Component\Core\Model\OrderItem	No errors.
App\Entity\Order\OrderItem	No errors.
Sylius\Component\Order\Model\Adjustment	No errors.
Sylius\Component\Core\Model\Adjustment	No errors.
App\Entity\Order\Adjustment	No errors.
Sylius\Component\Customer\Model\CustomerGroup	No errors.
App\Entity\Customer\CustomerGroup	No errors.
Sylius\Component\Core\Model\ShopUser	No errors.
App\Entity\User\ShopUser	No errors.

Symfony Profiler

GET http://webshop.scherstra.com/admin/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping