Symfony Profiler

Query Metrics

83 Database Queries

32 Different statements

54.94 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

12.37 ms
(22.51%)

SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‰±5ÆYp\x07€£êò\fõÃá"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `app`.`id` as `app.id`,
  `app`.`name` as `app.name`,
  `app`.`path` as `app.path`,
  `app`.`author` as `app.author`,
  `app`.`copyright` as `app.copyright`,
  `app`.`license` as `app.license`,
  `app`.`active` as `app.active`,
  `app`.`configurable` as `app.configurable`,
  `app`.`privacy` as `app.privacy`,
  `app`.`version` as `app.version`,
  `app`.`icon` as `app.iconRaw`,
  `app`.`app_secret` as `app.appSecret`,
  `app`.`modules` as `app.modules`,
  `app`.`main_module` as `app.mainModule`,
  `app`.`cookies` as `app.cookies`,
  `app`.`allow_disable` as `app.allowDisable`,
  `app`.`base_app_url` as `app.baseAppUrl`,
  `app`.`allowed_hosts` as `app.allowedHosts`,
  `app`.`template_load_priority` as `app.templateLoadPriority`,
  `app`.`integration_id` as `app.integrationId`,
  `app.integration`.`id` as `app.integration.id`,
  `app.integration`.`label` as `app.integration.label`,
  `app.integration`.`access_key` as `app.integration.accessKey`,
  `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
  `app.integration`.`admin` as `app.integration.admin`,
  `app.integration`.`custom_fields` as `app.integration.customFields`,
  `app.integration`.`deleted_at` as `app.integration.deletedAt`,
  `app.integration`.`write_access` as `app.integration.writeAccess`,
  `app.integration`.`created_at` as `app.integration.createdAt`,
  `app.integration`.`updated_at` as `app.integration.updatedAt`,
  `app`.`acl_role_id` as `app.aclRoleId`,
  `app.aclRole`.`id` as `app.aclRole.id`,
  `app.aclRole`.`name` as `app.aclRole.name`,
  `app.aclRole`.`description` as `app.aclRole.description`,
  `app.aclRole`.`privileges` as `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` as `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
  `app`.`created_at` as `app.createdAt`,
  `app`.`updated_at` as `app.updatedAt`,
  `app.translation.label`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  LEFT JOIN (
    SELECT
      `app.translation`.app_id,
      `app.translation`.label as `app.translation.label`,
      `app.translation`.description as `app.translation.description`,
      `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
      `app.translation`.custom_fields as `app.translation.customFields`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
  `app`.`id` IN (?)

SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (0x0189B135C659700780A3EAF20CF5C3E1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 132)
9	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->getAppWithExistingScripts (line 30)
10	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->updateScripts (line 110)
11	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->refresh (line 72)
12	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
13	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 56)
14	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
15	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 34)
17	Shopware\Core\Checkout\Cart\Processor->process (line 105)
18	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 83)
20	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
21	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
22	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 59)
24	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
25	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
26	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
30	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
31	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
32	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
36	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
37	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
38	Shopware\Core\Kernel->handle (line 86)
39	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
42	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
44	Shopware\Core\HttpKernel->doHandle (line 67)
45	Shopware\Core\HttpKernel->handle (line 63)
46	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 12)

9.64 ms
(17.55%)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)

Parameters:

[
  "/note"
  "/navigation/93a4337318f0054690d354de28c5dddc"
  "/navigation/fd676cf919c6fa8bd32dc34773cdd1a2"
  "/navigation/b043ac3b6b3140955905850879e26592"
  "/navigation/eff45ba8ecb85b0ade6abc9b2e928e82"
  "/navigation/fa16ab0a538a8501a95e8578041b2f59"
  "/navigation/131942a1db80fb0ac3ce5522c90415f3"
  "/navigation/24aca821ba4db7ab66c76a5fd7ae0cc5"
  "/navigation/34b3309fc64351ac445a4c172cb4d44c"
  "/landingPage/132b3e541f3a46778137ebdc495c60fd"
  "/navigation/bb3af78c78896a1e31b7ef400d3a28fc"
  "/navigation/1c518506f752949ec293737722e4499b"
  "/navigation/778e0ed7ab5c1a7d786e8e8b3a676d14"
  "/navigation/5ecbefc853199c4a26f05d46ceb6c86a"
  "/navigation/6dda38aeb1d0f1ae1544b23c8f08c1bf"
  "/navigation/e0fafb740f309b9617c6851e26daac7b"
  "/navigation/165bf1461c54c861b54db9502494e8bb"
  "/navigation/d06491a73f7481f8d0f6c8420a2ba270"
  "/navigation/f3fbbedf45da7098e77af90ab3fed694"
  "/navigation/9dbceb82cd1ad9852be2d66c03f42805"
  "/navigation/f9153356d34d571babf82f7a32523837"
  "/detail/5c25705ab668cf993926245948f86d00"
  "/navigation/89abb3174e2d7e7304e9f3a525fc5b86"
  "/navigation/e710d14628a15b62da0ad737eafca643"
  "/navigation/b69ddce29e21df7be3020bed56282668"
  "/navigation/2f291725e83f578c57b926f542e7e22f"
  "/navigation/2a6ed2c9e3caee7fcfe61c55fbc08757"
  "/navigation/6fb849e2ef6ce9da07eeaf2f70016495"
  "/navigation/3f62648c673058f2d1499975a6b445a2"
  "/navigation/b67d8baa46c67425f0f0948cd6d58411"
  "/navigation/ec05f0a7bc40c9e7e3a118a0ad5f3802"
  "/navigation/71f3f644a2728c9f4ede6fe5d0b0fbd9"
  "/navigation/580d21fec58a183e72b8608115df7a9f"
  "/navigation/0d40a9663c11a2342f02e447f269023c"
  "/navigation/2488454d5762b2f97c085f3160753fd0"
  "/navigation/eeafdd77e2abc9dc08b3bbf011ff97bf"
  "/navigation/94e0ed4a8dc29ec245c846b8dd35db95"
  "/navigation/e24dd7d82ce4461d63fceb2576dd2819"
  "/navigation/6805a9e4583dd6c416186289bcc86d12"
  "/navigation/35b1adb37395d91de43b0b4634b78663"
  "/navigation/3547ce3e294d5d08530d29045149f0e2"
  "/navigation/4f2d452ecaffc1a1cff6417787162675"
  "/navigation/484a5288a950ad9a143cb8c4c6f6aa39"
  "/navigation/80c2cdca20d8cacfcff206d2caa93ebf"
  "/navigation/00f7b8117945483ea1ad5204fbb7a2b9"
  "/navigation/22bf636f562462eb849b23a878c6eca8"
  "/navigation/981758de3d52c50a878b1f25eecd8742"
  "/navigation/38fa32fdc995af57b8c0fdde4ceea074"
  "/navigation/043a706bfe30516c97d46a838b8902c5"
  "/navigation/bef204edf93555e1d960ccdbe66c08b8"
  "/navigation/90dc8d5ca64af4113933927420c2f66c"
  "/navigation/df7051ed7bb92ac154f23fd0e4034f23"
  "/navigation/bf9f6f2f198741008dccbb762c7d50b2"
  "/navigation/7658f31a192ad7978f92a03c9878ceab"
  "/navigation/0bf4f16f690c467e31d903a04185d95b"
  "/navigation/7cc2aa0bfe1a099b0d4c3a3e4648569d"
  "/navigation/4e6a91d907322489a2fd17d46071ec97"
  "/navigation/77848cf4f279d463177d2695ec7811dc"
  "/navigation/7a6cf7b63e9849798fde605516a7e2ce"
  "/navigation/7ba75687d380c1652767a9f7cea72c46"
  "/navigation/d406cad7131ab368a9af4b2af7be669b"
  "/navigation/2276908e77e901a5f9700b10a2e42f1d"
  "/navigation/4d4cc90a5eff22ccc630475c8985b11c"
  "/navigation/24d6be0ee3f75d3cf14ad646e15b5706"
  "/navigation/95d19b7d2a43bca874ed937173ab818d"
  "/navigation/f67a99c5bf8c0bd4fb150997bf0de350"
  "/navigation/e9a88b01e32a9d86660c8c8b3334b500"
  "/navigation/0cc4d1e6097fb38dfc49b3e035911870"
  "/navigation/225a611208d5a56f780026586f84acd0"
  "/navigation/5536c572dcdd2656aad11feb2e8d6309"
  "/navigation/64ed80ef87b9b9b754be36772425e947"
  "/navigation/40ed8a18f47da7d87f6c8719bb28385a"
  "/navigation/499456f34de05a8962ada7af19c70b70"
  "/navigation/38af3ad37d571a413da701644b1511b9"
  "/navigation/1c1708cf9234149e42c462815ab6db09"
  "/navigation/ea18b796828ab701c109d6c82cd644f4"
  "/navigation/6bcdc53ba589d9ca5e0a806b247beabd"
  "/landingPage/01900bcdf62a789ba0e74be57b210083"
  "/landingPage/0190973de41a757d89600621522778a1"
  "/landingPage/38bdd0c3e4ef4cdd94eb98e6acec006b"
  "/landingPage/018ee7156a227c90a5cae86d76127ead"
  "/landingPage/0190307e217c7fc892e45b7ec067d6b5"
  "/landingPage/01901652ffbf78e6be8e6d19d0af461b"
  "/landingPage/05e1ea75fb5248d48ecd6f533ceb0643"
  "/landingPage/018ebcad754a70abb7d72fcffdd4fb8e"
  "/landingPage/018eeae802b676f98f5b75096f158d8f"
  "/landingPage/80b15d8cbdd64db29782cecb9e837b4b"
  "/landingPage/3215141b9d834c4a85e405f40cfd0151"
  "/landingPage/c4b54c9423c94cb882f32376fbcdc2cc"
  "/landingPage/6cfbd3fb873e4379955f38697d0cee51"
  "/landingPage/0190790d6fe477109ef87826b43657e4"
  "/landingPage/018fbf3fff2c78e1adc27bfd4efa60a6"
  "/landingPage/7fb1ee1593f14ffe8d1a3de9f29f3fa0"
  "/landingPage/535996cae7b54c7fa2321e5d03c734dc"
  "/landingPage/018fb926e4177c90a5b229230ba9229b"
  "/landingPage/018fe30405f873eb8a445e81d223f44e"
  "/landingPage/018fde7030da73dc9e85c4e23d665202"
  "/landingPage/4d4c983734434b1bac6951f026cb2569"
  "/detail/9143f90c70fd1f52361bd3c615721959"
  "/detail/b08fd96795e796ac4d91a7a2035ccf02"
  "/detail/daa199e2f336681dcc31308cc709247d"
  "/detail/f3679325440882ea8f62712feae6a772"
  "/detail/43784693d2dc41a316598d5f2a306926"
  "/detail/d3af5837735a2e75e6a431182266c5ad"
  "/detail/d0b6ddc7433d9bf32db472c4480b0f6a"
  "/detail/8856aba73f18bd96881bc028b433e596"
  "/detail/48833c0e5cde4d2d2633a9c1b22ef2ae"
  "/detail/720fa6e903b37d44c64157ed95be9c3d"
  "/detail/9df298b85774d7cdaff132c239bc6cd5"
  "/detail/212f90883b1aa53562ea4b347a01bf56"
  "/detail/23741939230db6c052faf832b7f25bc9"
  "/detail/f7b88f3c60cd1b18e987a191870a7934"
  "/detail/86e44a32348128f123defbe60a82a4ef"
  "/detail/cab27287e9b6164ceef0978370284019"
  "/detail/2827cc83503c2621ce0d96ef8ce18227"
  "/detail/a4c6e0e932674fe30807184054ce4313"
  "/detail/b93f25e8e9c6b378b085638b42957948"
  "/detail/0908d3c53a640cf4214f1651aa531068"
  "/detail/9178a7ae42460a14ba96dd6d41f9d26b"
  "/detail/fa1465c04160b84f1be3fd4655763e8c"
  "/detail/42af2073d6160e8d350deb292b7ad5ed"
  "/detail/37962bf0b7bfca1d956cae838b22d5d4"
  "/detail/12de9dca9fa33b9e8b10a487d9e05d39"
  "/detail/b8b3e66896f8f464aac6caa96f218401"
  "/detail/e1ba7dc84694d13b48379725efbb881d"
  "/detail/5fb37e0dcc984d90d7e2520cbcba28dc"
  "/detail/acabe8d36d8275bfd44b3e23a9d7a161"
  "/detail/1b575036ef8fb334d9a240bbc2bb9444"
  "/detail/25499b797f72ad2d942c471e3cd9b39a"
  "/detail/a57757e94661ed2ef268bf4eb443deda"
  "/detail/296c3adf830d0ae45f7b464ffe804fdb"
  "/detail/0524451a2ed47b62d88ac26d5d9e2caa"
  "/detail/f6588ae45013f35ef8c7fce512e00c14"
  "/detail/f5a2f05d01ed91ef8b20b81e6882cad8"
  "/detail/62e8169b0f0e6b6a16bc4c803a5e4700"
  "/detail/0e5bd9874ff5566cea583cfb730cf24e"
  "/detail/7840157769d67623a2c04cc31e955c79"
  "/detail/ee517c5aa045cc37f492ebe5277d3b1e"
  "/detail/ea14683fd491ba407733b673be32779e"
  "/detail/e8c5b72307275017042ce65a381807bc"
  "/detail/e7a5630eae69fe3e97983624eb86e2ba"
  "/detail/d62c48aafa9070f60f5234137424caec"
  "/detail/ce66631759227e5d45a104f6219c24f8"
  "/detail/c2c839cecba4856b93335693685143d2"
  "/detail/bfaf528d954a8c85d3fcf722ec4db4d5"
  "/detail/b53e591e82899b8ed6d4c0fa16710c2f"
  "/detail/ad42a4edfd80f4ab2c4b15838003756c"
  "/detail/a533cd414421cd0d1372e24af2e21b61"
  "/detail/9d3fc726c5d7dc3eb655a2d4c3e57533"
  "/detail/8ef205594760f57f8808101b70dfe1c3"
  "/detail/8c03466f02c7191336b636509b64e5c4"
  "/detail/542cfa03a8dc54e54f04b02143a65843"
  "/detail/517e50d1a95cb4bc7b1673c101894acb"
  "/detail/3909cee7b96e8606d218f6e8efd89a3b"
  "/detail/3608762f3926843223c94b5e22cccb4d"
  "/detail/080fcdea8a6c9858aab2b136594fe7e5"
  "/detail/6d8e40ae1fabdce0596e09335a83f076"
  "/detail/79a55b61579557f07dc29b3a460bdfec"
  "/detail/181a6375ecc4ecf192e55130de7d4d1f"
  "/detail/d2ce5d2e15ba44999e4436ebe67c0c2f"
  "/detail/ef3edfaff0782479db19a43df43e077b"
  "/detail/4057b1b2b23d8f4398301834f4a5af83"
  "/detail/5ddf35694b79c579450e73e11916b2c7"
  "/detail/97a0299f3945142915cf00e279cded1c"
  "/detail/9abc61672972a58a97be308457599b6a"
  "/detail/ad44d7762191bd44db5d1b063ac80eb2"
  "/detail/da9c3ca249343f73f0863f52369d0356"
  "/detail/8df58f07c69fcb138ec236cb18b9ac4d"
  "/detail/5840634bff3b95f0822d00f64b4b2ef5"
  "/detail/cd3a282d3855ce1875b26bc37d0f1678"
  "/detail/c93f242bdb4955f4bdf76af56198d635"
  "/detail/d45ac4af708396ab094761b545e3ca5e"
  "/detail/e7082f40194441e46e11157e48227779"
  "/detail/ccd2e8fc86d1303a8646f2ecefd9315b"
  "/detail/0fd42e8e1ca359a1646ac8623736a348"
  "/detail/df5c7c18d4d9987b83b34b1869fd40f7"
  "/detail/3b626ebc464ed54d4e927da65366c177"
  "/detail/8548757bab7a366e0ca0886cc492980e"
  "/detail/4fdfce66958498823a7bf413b1f57046"
  "/detail/6a7469b0b439de808e81ca79c19c42df"
  "/detail/d3ed6c5d82cc13f916417971cac28d74"
  "/detail/6d0e601ce4f857a9a73b736be8823195"
  "/detail/390c1c2af0b8aa495528ace2f531dac7"
  "/detail/7bd35a1bb824cea7876fa21b8f7bcfeb"
  "/detail/cbf782607dc1aeb7f423ad4aa86dafc7"
  "/detail/e9230bdc77cc2c563b13677dda6eb3eb"
  "/detail/e0711aff8c9fd8e108c7042c6239439c"
  "/detail/7485b999fd5dfe9d553f10cf94e6c005"
  "/detail/fd069bfac5432cc43d222be6c2f86102"
  "/detail/054e62e5f71bac69e2df8e70dc01b1ce"
  "/detail/09aba0589346a18c907431a1ad43c17e"
  "/detail/5eafb36eb2940456509ae327d32eff4c"
  "/detail/74f814f75ae4f178e1b8df5ac4f19b62"
  "/detail/bc3b13579e4c44959127dec490851233"
  "/detail/ff60000b6f71580dbc179565611311dd"
  "/detail/f6b6d49ca32ef9aeafd20053b7c296ff"
  "/detail/f747da51ff66e71c47331d307c5bb5fa"
  "/detail/9101ba25811c6083ebccdf4f3d0e3ddb"
  "/detail/afc58c38010d513652f68f8162df8e30"
  "/detail/e2c8eb557006dcc4c44a87da08ae5fc1"
  "/detail/7af8527c1cb7f4c66c6f0dc76ebfa7ba"
  "/detail/001c90aab3c9d27de565f3462b183be4"
  "/detail/36424ed13058cdf95f9d4f7f0ff1d8b8"
  "/detail/4f2abae677b4cca8076c3c91e54b02fd"
  "/detail/4b80f67f691ab98a12d9760fb3c73a03"
  "/detail/9b5dd2dba421435321f6cbf48fa95ac0"
  "/detail/062cb91b54ab2825e56d668fa7d51a81"
  "/detail/2fb5542c8cc21fe8bebf62f25b015f18"
  "/detail/b44a2f17f49620b27151e16de38bdb1a"
  "/detail/b03eb34bd4537d10fe5d881c04788c9b"
  "/detail/d972016df4655458c2f10e506b148fe7"
  "/detail/64fa1c87699862c5e209fb83ac8479bd"
  "/detail/2566b483c24d4c68b8ab2f0ab24d873b"
  "/detail/0f82f7a4a7635975b1f495bca076b109"
  "/detail/2616120cd791346317b06ecfa8bd4089"
  "/detail/c5d54284a5498392e760fadf94d2b208"
  "/detail/1cbd3b68d0c9ed6193976ed14b2e2167"
  "/detail/474e02839557eb8f9fcff237bb24a5a3"
  "/detail/4ad19ec9bdeadd653870341b236f1c31"
  "/detail/f8f5e857f998432ddf2faaad170a869d"
  "/detail/055e65b175ec6ed269f136ac0c16cec6"
  "/detail/794aafd668b141deacbe664f1737e96f"
  "/detail/89db541f3e60d7ab5429c618c7839364"
  "/detail/1df6c21bbe889b27ab89b8fa82fb7b37"
  "/detail/e0fd3be08117e50c9e5220c76470efdf"
  "/detail/d2345a7d0a90be9ff1a6f57d2c7e9b5a"
  "/detail/c9e35234387ea3b500dfec5be7c8ceec"
  "/detail/91f064ea1d64ee4aa7df31737a2b4fe1"
  "/detail/2224a893643ec5c49a0588b8cfeb763b"
  "/detail/0333c24416c1c41afa830d0c42e2a237"
  "/detail/ff98e96794afe66e4862bb3f604efaca"
  "/detail/e96df0c2587bc597cf75d56700d6a64f"
  "/detail/b47334e588fb8a480be13c9c3cee320e"
  "/detail/322086c611c4bcbd56519f61d07a1bc7"
  "/detail/9d5891f7b9cdf0463752b857241718b5"
  "/detail/9e666ce36f706938b4d7b2689494783d"
  "/detail/d3a74bcb3f41cd82be29a31bfdc4f968"
  "/detail/5b7437507cff2524b0cdf1a308c1f848"
  "/detail/c294de1d7a600c6205b82efa9e4f437f"
  "/detail/238c27d31ed6b0e58be1238ffb4f603a"
  "/detail/cf99e5f13efae2cf97033ea716b5d2c7"
  "/detail/0d64874200f8f06ce8fffb2a066cf4ed"
  "/detail/1f26a893d8b2292becbf8a62489dd1a5"
  "/detail/5fc8e682aa2807d3b412d622622c2e84"
  "/detail/b916881c328db28b52c9d396a0fc237b"
  "/detail/904513de2e59ed674f628bf36b405756"
  "/detail/5d706a2bee647981bb99ef186286b1ff"
  "/detail/ac29ff465769f3865f35ffd4835b3d1c"
  "/detail/9e8bd25dc4f9ebb5395133f4cb8e02d3"
  "/detail/ddf099f652d870138ee21bcaade8d529"
  "/detail/a0bc03a60ed859ed21d9dc1c20c00cc1"
  "/detail/d4e52caa008ad90d593687d037d7152b"
  "/detail/74985cc59696dd5bef06c15e384e4dcc"
  "/detail/c10a0e2cfdcab7766579372e0089994d"
  "/detail/0385a47dcefec4b599269d789d813f4e"
  "/detail/a0514c63c8a2bd526fbe23bbe9a39b9b"
  "/detail/427678efb880df984ad533ef8f8a6b79"
  "/detail/e4cffcbbea8f22b8786afa71414a0884"
  "/detail/81223408aee5dea6d224ccf0ee64867f"
  "/detail/6ea99403daefbcdfd6b8ad78a4f515ed"
  "/detail/06f0960e4fc1d5de7b5d593800e6eeb4"
  "/detail/8de2f03d8fe2a67e3bb4c694eab3cfe1"
  "/detail/79ebdec973b9ed3d393941910eb65b7c"
  "/detail/36baf65d7fc56efec409a2be70ee41c2"
  "/detail/24785cee4f49440117b6ad9a16f7c64c"
  "/detail/0bd56478f76c26b2caf928577ba37e69"
  "/detail/f31e460cfe2f6963ccda9f2cf0d60ed2"
  "/detail/6866e61d3bfcc5cf89a72377502c8b2a"
  "/detail/f35dc60708966beb14c33a8c959ec4dc"
  "/detail/b53d654b65fa2752cc68365230f118fa"
  "/detail/54ae77fa7705d75c0a642e8ba5c56508"
  "/detail/8565f54a56a465fc946e9a0d85d4f43d"
  "/detail/33c3390a111762dcc71b25445ae83c44"
  "/detail/198ae84776e899924cc2e5324ea64e74"
  "/detail/00d337f41a9e6529dbf30efe849e716e"
  "/detail/0f2741953e6a8dd1dbb8f2074529bc0a"
  "/detail/187dcb70ceb18f8138949b04d1d816ea"
  "/detail/1c2a2db1069d97765cb68554119c4c1a"
  "/detail/1d6d4b02128ba4ca5c877213aa26ce0b"
  "/detail/1f010f49eb738fb7723551cd0c476b8a"
  "/detail/1f61dd6247f350f2bad7524fe1173e9d"
  "/detail/2bd77d2ac5b0ee4f5a1830079ea5fa80"
  "/detail/2d2b1776a285814167788680e7273966"
  "/detail/302be1abbeac88f2c2224e5bf0ba5ee8"
  "/detail/378875d39de2e9bc5b4859ac20d9ffa8"
  "/detail/37c5c06f227611109d5851a1fc52d795"
  "/detail/394e39b00edceb6912c04c93f8afd5f6"
  "/detail/41ac4ab6c86cecd6dda29cac5e18d9bd"
  "/detail/42b30eac84dc8f66250e2c7bf4c9d9bb"
  "/detail/43880550903878816fc1cd991e3cde1f"
  "/detail/482cf4bf2792fa28f36c498d886040e0"
  "/detail/4c0c39a518dc3175f27fb753b8826ceb"
  "/detail/4f93ab3dbf8a76514b7fcb611c1a2a04"
  "/detail/5845bfc3bc1c73556c8c39cccea782d1"
  "/detail/5d0d2585ddc3f4d298bfaa8927434085"
  "/detail/5de411716477e551ca2b07b04e20a5ae"
  "/detail/69dd938204ccdc393ef1a63633e4b530"
  "/detail/729d73a5bf7c8684da3c3b58f5759352"
  "/detail/79b6d3ecf514d09e462cbc4ab3ff36af"
  "/detail/7a33a78563cf8ea28c40d51e7153a67a"
  "/detail/7c3ed9e9b0075ebf9a31d0c9a5887b95"
  "/detail/8470b577594c6d8f2dc23a84edd086f7"
  "/detail/9072e627487c133003d1cd1ddcea2d04"
  "/detail/92030b7a32611e19e10212837517bd96"
  "/detail/983fbe58f6c97fc19297771aa779e773"
  "/detail/a57ba0243571cb9c7bd9095317fe68bf"
  "/detail/ac03cfc6f8ed81965825c4c472061849"
  "/detail/ad072a35ad814169c68d540fd1e76919"
  "/detail/af5181d37ead3db958459bdbfcfed418"
  "/detail/b50a030c2f0ce4a3ade54851549e7928"
  "/detail/b6f9df13f0df04c9e0c4a9ffcba8b2dc"
  "/detail/b9126eb0afe1141b7436ca75024ba9a9"
  "/detail/d89ba5f8d49bfbcfdf2e7ced26a8eadd"
  "/detail/db4b6108df5776ccd763da2fa979bac1"
  "/detail/e0f3d0df06c78af7448ac837342f6c2b"
  "/detail/e35e0291c11e76e7aa32e1089f0b5d86"
  "/detail/e4e0c0b1e201d2a1c6464510b7e4d4f4"
  "/detail/e7842a02828a5599bd6d8b24008991ca"
  "/detail/ea69ec09fbe00c5f9ff0a51d7253eb78"
  "/detail/f21232a41dd2f3676b600bfbc3d16080"
  "/detail/f5670478134ace2b3dd770c7a566cf9c"
  "/detail/f775f138a3aa95e86a8756eb4269bf3b"
  "/detail/f93f38b76dd97ca29f2db976a4df0f25"
  "/detail/fe73b6530fcee9ddcdfe3eaf306cde2c"
  "/detail/fe89bb431069027cf2cf6789f61f9a2a"
  "/detail/ff89f7b912ce648065bd1707ca40dd29"
  "/detail/d96aef2e7f7d39bfa30e3ea809b7eda6"
  "/navigation/47c823ffa54c4a838419e63637237423"
  "/navigation/003fead0b2c54c02b2b6a000fd0dc3c6"
  "/landingPage/019146c494347206b1979287d007975e"
  "/navigation/7d5664d1b3e6418f85f1bc53429bc3ca"
  "/navigation/513109c128ad4a7ab30fa1d8979d40e0"
  "/navigation/a5b2c8e80d144124a5321366d0d6bdc6"
  "/landingPage/018ee098c74f763e91f7d621dbfa7074"
  "/landingPage/4e6f17971ae5455ab840ad4974ac14a1"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x02a\f\x08ÑQN├ü\vb¦©!\x19Ã"
]

View formatted query View runnable query Explain query View query backtrace

# seo_url::replacement
SELECT
  seo_path_info,
  path_info,
  sales_channel_id
FROM
  seo_url
WHERE
  (seo_url.is_canonical = 1)
  AND (
    seo_url.path_info IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND (seo_url.language_id = ?)
  AND (
    seo_url.sales_channel_id = ?
    OR seo_url.sales_channel_id IS NULL
  )
  AND (seo_url.is_deleted = 0)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/note', '/navigation/93a4337318f0054690d354de28c5dddc', '/navigation/fd676cf919c6fa8bd32dc34773cdd1a2', '/navigation/b043ac3b6b3140955905850879e26592', '/navigation/eff45ba8ecb85b0ade6abc9b2e928e82', '/navigation/fa16ab0a538a8501a95e8578041b2f59', '/navigation/131942a1db80fb0ac3ce5522c90415f3', '/navigation/24aca821ba4db7ab66c76a5fd7ae0cc5', '/navigation/34b3309fc64351ac445a4c172cb4d44c', '/landingPage/132b3e541f3a46778137ebdc495c60fd', '/navigation/bb3af78c78896a1e31b7ef400d3a28fc', '/navigation/1c518506f752949ec293737722e4499b', '/navigation/778e0ed7ab5c1a7d786e8e8b3a676d14', '/navigation/5ecbefc853199c4a26f05d46ceb6c86a', '/navigation/6dda38aeb1d0f1ae1544b23c8f08c1bf', '/navigation/e0fafb740f309b9617c6851e26daac7b', '/navigation/165bf1461c54c861b54db9502494e8bb', '/navigation/d06491a73f7481f8d0f6c8420a2ba270', '/navigation/f3fbbedf45da7098e77af90ab3fed694', '/navigation/9dbceb82cd1ad9852be2d66c03f42805', '/navigation/f9153356d34d571babf82f7a32523837', '/detail/5c25705ab668cf993926245948f86d00', '/navigation/89abb3174e2d7e7304e9f3a525fc5b86', '/navigation/e710d14628a15b62da0ad737eafca643', '/navigation/b69ddce29e21df7be3020bed56282668', '/navigation/2f291725e83f578c57b926f542e7e22f', '/navigation/2a6ed2c9e3caee7fcfe61c55fbc08757', '/navigation/6fb849e2ef6ce9da07eeaf2f70016495', '/navigation/3f62648c673058f2d1499975a6b445a2', '/navigation/b67d8baa46c67425f0f0948cd6d58411', '/navigation/ec05f0a7bc40c9e7e3a118a0ad5f3802', '/navigation/71f3f644a2728c9f4ede6fe5d0b0fbd9', '/navigation/580d21fec58a183e72b8608115df7a9f', '/navigation/0d40a9663c11a2342f02e447f269023c', '/navigation/2488454d5762b2f97c085f3160753fd0', '/navigation/eeafdd77e2abc9dc08b3bbf011ff97bf', '/navigation/94e0ed4a8dc29ec245c846b8dd35db95', '/navigation/e24dd7d82ce4461d63fceb2576dd2819', '/navigation/6805a9e4583dd6c416186289bcc86d12', '/navigation/35b1adb37395d91de43b0b4634b78663', '/navigation/3547ce3e294d5d08530d29045149f0e2', '/navigation/4f2d452ecaffc1a1cff6417787162675', '/navigation/484a5288a950ad9a143cb8c4c6f6aa39', '/navigation/80c2cdca20d8cacfcff206d2caa93ebf', '/navigation/00f7b8117945483ea1ad5204fbb7a2b9', '/navigation/22bf636f562462eb849b23a878c6eca8', '/navigation/981758de3d52c50a878b1f25eecd8742', '/navigation/38fa32fdc995af57b8c0fdde4ceea074', '/navigation/043a706bfe30516c97d46a838b8902c5', '/navigation/bef204edf93555e1d960ccdbe66c08b8', '/navigation/90dc8d5ca64af4113933927420c2f66c', '/navigation/df7051ed7bb92ac154f23fd0e4034f23', '/navigation/bf9f6f2f198741008dccbb762c7d50b2', '/navigation/7658f31a192ad7978f92a03c9878ceab', '/navigation/0bf4f16f690c467e31d903a04185d95b', '/navigation/7cc2aa0bfe1a099b0d4c3a3e4648569d', '/navigation/4e6a91d907322489a2fd17d46071ec97', '/navigation/77848cf4f279d463177d2695ec7811dc', '/navigation/7a6cf7b63e9849798fde605516a7e2ce', '/navigation/7ba75687d380c1652767a9f7cea72c46', '/navigation/d406cad7131ab368a9af4b2af7be669b', '/navigation/2276908e77e901a5f9700b10a2e42f1d', '/navigation/4d4cc90a5eff22ccc630475c8985b11c', '/navigation/24d6be0ee3f75d3cf14ad646e15b5706', '/navigation/95d19b7d2a43bca874ed937173ab818d', '/navigation/f67a99c5bf8c0bd4fb150997bf0de350', '/navigation/e9a88b01e32a9d86660c8c8b3334b500', '/navigation/0cc4d1e6097fb38dfc49b3e035911870', '/navigation/225a611208d5a56f780026586f84acd0', '/navigation/5536c572dcdd2656aad11feb2e8d6309', '/navigation/64ed80ef87b9b9b754be36772425e947', '/navigation/40ed8a18f47da7d87f6c8719bb28385a', '/navigation/499456f34de05a8962ada7af19c70b70', '/navigation/38af3ad37d571a413da701644b1511b9', '/navigation/1c1708cf9234149e42c462815ab6db09', '/navigation/ea18b796828ab701c109d6c82cd644f4', '/navigation/6bcdc53ba589d9ca5e0a806b247beabd', '/landingPage/01900bcdf62a789ba0e74be57b210083', '/landingPage/0190973de41a757d89600621522778a1', '/landingPage/38bdd0c3e4ef4cdd94eb98e6acec006b', '/landingPage/018ee7156a227c90a5cae86d76127ead', '/landingPage/0190307e217c7fc892e45b7ec067d6b5', '/landingPage/01901652ffbf78e6be8e6d19d0af461b', '/landingPage/05e1ea75fb5248d48ecd6f533ceb0643', '/landingPage/018ebcad754a70abb7d72fcffdd4fb8e', '/landingPage/018eeae802b676f98f5b75096f158d8f', '/landingPage/80b15d8cbdd64db29782cecb9e837b4b', '/landingPage/3215141b9d834c4a85e405f40cfd0151', '/landingPage/c4b54c9423c94cb882f32376fbcdc2cc', '/landingPage/6cfbd3fb873e4379955f38697d0cee51', '/landingPage/0190790d6fe477109ef87826b43657e4', '/landingPage/018fbf3fff2c78e1adc27bfd4efa60a6', '/landingPage/7fb1ee1593f14ffe8d1a3de9f29f3fa0', '/landingPage/535996cae7b54c7fa2321e5d03c734dc', '/landingPage/018fb926e4177c90a5b229230ba9229b', '/landingPage/018fe30405f873eb8a445e81d223f44e', '/landingPage/018fde7030da73dc9e85c4e23d665202', '/landingPage/4d4c983734434b1bac6951f026cb2569', '/detail/9143f90c70fd1f52361bd3c615721959', '/detail/b08fd96795e796ac4d91a7a2035ccf02', '/detail/daa199e2f336681dcc31308cc709247d', '/detail/f3679325440882ea8f62712feae6a772', '/detail/43784693d2dc41a316598d5f2a306926', '/detail/d3af5837735a2e75e6a431182266c5ad', '/detail/d0b6ddc7433d9bf32db472c4480b0f6a', '/detail/8856aba73f18bd96881bc028b433e596', '/detail/48833c0e5cde4d2d2633a9c1b22ef2ae', '/detail/720fa6e903b37d44c64157ed95be9c3d', '/detail/9df298b85774d7cdaff132c239bc6cd5', '/detail/212f90883b1aa53562ea4b347a01bf56', '/detail/23741939230db6c052faf832b7f25bc9', '/detail/f7b88f3c60cd1b18e987a191870a7934', '/detail/86e44a32348128f123defbe60a82a4ef', '/detail/cab27287e9b6164ceef0978370284019', '/detail/2827cc83503c2621ce0d96ef8ce18227', '/detail/a4c6e0e932674fe30807184054ce4313', '/detail/b93f25e8e9c6b378b085638b42957948', '/detail/0908d3c53a640cf4214f1651aa531068', '/detail/9178a7ae42460a14ba96dd6d41f9d26b', '/detail/fa1465c04160b84f1be3fd4655763e8c', '/detail/42af2073d6160e8d350deb292b7ad5ed', '/detail/37962bf0b7bfca1d956cae838b22d5d4', '/detail/12de9dca9fa33b9e8b10a487d9e05d39', '/detail/b8b3e66896f8f464aac6caa96f218401', '/detail/e1ba7dc84694d13b48379725efbb881d', '/detail/5fb37e0dcc984d90d7e2520cbcba28dc', '/detail/acabe8d36d8275bfd44b3e23a9d7a161', '/detail/1b575036ef8fb334d9a240bbc2bb9444', '/detail/25499b797f72ad2d942c471e3cd9b39a', '/detail/a57757e94661ed2ef268bf4eb443deda', '/detail/296c3adf830d0ae45f7b464ffe804fdb', '/detail/0524451a2ed47b62d88ac26d5d9e2caa', '/detail/f6588ae45013f35ef8c7fce512e00c14', '/detail/f5a2f05d01ed91ef8b20b81e6882cad8', '/detail/62e8169b0f0e6b6a16bc4c803a5e4700', '/detail/0e5bd9874ff5566cea583cfb730cf24e', '/detail/7840157769d67623a2c04cc31e955c79', '/detail/ee517c5aa045cc37f492ebe5277d3b1e', '/detail/ea14683fd491ba407733b673be32779e', '/detail/e8c5b72307275017042ce65a381807bc', '/detail/e7a5630eae69fe3e97983624eb86e2ba', '/detail/d62c48aafa9070f60f5234137424caec', '/detail/ce66631759227e5d45a104f6219c24f8', '/detail/c2c839cecba4856b93335693685143d2', '/detail/bfaf528d954a8c85d3fcf722ec4db4d5', '/detail/b53e591e82899b8ed6d4c0fa16710c2f', '/detail/ad42a4edfd80f4ab2c4b15838003756c', '/detail/a533cd414421cd0d1372e24af2e21b61', '/detail/9d3fc726c5d7dc3eb655a2d4c3e57533', '/detail/8ef205594760f57f8808101b70dfe1c3', '/detail/8c03466f02c7191336b636509b64e5c4', '/detail/542cfa03a8dc54e54f04b02143a65843', '/detail/517e50d1a95cb4bc7b1673c101894acb', '/detail/3909cee7b96e8606d218f6e8efd89a3b', '/detail/3608762f3926843223c94b5e22cccb4d', '/detail/080fcdea8a6c9858aab2b136594fe7e5', '/detail/6d8e40ae1fabdce0596e09335a83f076', '/detail/79a55b61579557f07dc29b3a460bdfec', '/detail/181a6375ecc4ecf192e55130de7d4d1f', '/detail/d2ce5d2e15ba44999e4436ebe67c0c2f', '/detail/ef3edfaff0782479db19a43df43e077b', '/detail/4057b1b2b23d8f4398301834f4a5af83', '/detail/5ddf35694b79c579450e73e11916b2c7', '/detail/97a0299f3945142915cf00e279cded1c', '/detail/9abc61672972a58a97be308457599b6a', '/detail/ad44d7762191bd44db5d1b063ac80eb2', '/detail/da9c3ca249343f73f0863f52369d0356', '/detail/8df58f07c69fcb138ec236cb18b9ac4d', '/detail/5840634bff3b95f0822d00f64b4b2ef5', '/detail/cd3a282d3855ce1875b26bc37d0f1678', '/detail/c93f242bdb4955f4bdf76af56198d635', '/detail/d45ac4af708396ab094761b545e3ca5e', '/detail/e7082f40194441e46e11157e48227779', '/detail/ccd2e8fc86d1303a8646f2ecefd9315b', '/detail/0fd42e8e1ca359a1646ac8623736a348', '/detail/df5c7c18d4d9987b83b34b1869fd40f7', '/detail/3b626ebc464ed54d4e927da65366c177', '/detail/8548757bab7a366e0ca0886cc492980e', '/detail/4fdfce66958498823a7bf413b1f57046', '/detail/6a7469b0b439de808e81ca79c19c42df', '/detail/d3ed6c5d82cc13f916417971cac28d74', '/detail/6d0e601ce4f857a9a73b736be8823195', '/detail/390c1c2af0b8aa495528ace2f531dac7', '/detail/7bd35a1bb824cea7876fa21b8f7bcfeb', '/detail/cbf782607dc1aeb7f423ad4aa86dafc7', '/detail/e9230bdc77cc2c563b13677dda6eb3eb', '/detail/e0711aff8c9fd8e108c7042c6239439c', '/detail/7485b999fd5dfe9d553f10cf94e6c005', '/detail/fd069bfac5432cc43d222be6c2f86102', '/detail/054e62e5f71bac69e2df8e70dc01b1ce', '/detail/09aba0589346a18c907431a1ad43c17e', '/detail/5eafb36eb2940456509ae327d32eff4c', '/detail/74f814f75ae4f178e1b8df5ac4f19b62', '/detail/bc3b13579e4c44959127dec490851233', '/detail/ff60000b6f71580dbc179565611311dd', '/detail/f6b6d49ca32ef9aeafd20053b7c296ff', '/detail/f747da51ff66e71c47331d307c5bb5fa', '/detail/9101ba25811c6083ebccdf4f3d0e3ddb', '/detail/afc58c38010d513652f68f8162df8e30', '/detail/e2c8eb557006dcc4c44a87da08ae5fc1', '/detail/7af8527c1cb7f4c66c6f0dc76ebfa7ba', '/detail/001c90aab3c9d27de565f3462b183be4', '/detail/36424ed13058cdf95f9d4f7f0ff1d8b8', '/detail/4f2abae677b4cca8076c3c91e54b02fd', '/detail/4b80f67f691ab98a12d9760fb3c73a03', '/detail/9b5dd2dba421435321f6cbf48fa95ac0', '/detail/062cb91b54ab2825e56d668fa7d51a81', '/detail/2fb5542c8cc21fe8bebf62f25b015f18', '/detail/b44a2f17f49620b27151e16de38bdb1a', '/detail/b03eb34bd4537d10fe5d881c04788c9b', '/detail/d972016df4655458c2f10e506b148fe7', '/detail/64fa1c87699862c5e209fb83ac8479bd', '/detail/2566b483c24d4c68b8ab2f0ab24d873b', '/detail/0f82f7a4a7635975b1f495bca076b109', '/detail/2616120cd791346317b06ecfa8bd4089', '/detail/c5d54284a5498392e760fadf94d2b208', '/detail/1cbd3b68d0c9ed6193976ed14b2e2167', '/detail/474e02839557eb8f9fcff237bb24a5a3', '/detail/4ad19ec9bdeadd653870341b236f1c31', '/detail/f8f5e857f998432ddf2faaad170a869d', '/detail/055e65b175ec6ed269f136ac0c16cec6', '/detail/794aafd668b141deacbe664f1737e96f', '/detail/89db541f3e60d7ab5429c618c7839364', '/detail/1df6c21bbe889b27ab89b8fa82fb7b37', '/detail/e0fd3be08117e50c9e5220c76470efdf', '/detail/d2345a7d0a90be9ff1a6f57d2c7e9b5a', '/detail/c9e35234387ea3b500dfec5be7c8ceec', '/detail/91f064ea1d64ee4aa7df31737a2b4fe1', '/detail/2224a893643ec5c49a0588b8cfeb763b', '/detail/0333c24416c1c41afa830d0c42e2a237', '/detail/ff98e96794afe66e4862bb3f604efaca', '/detail/e96df0c2587bc597cf75d56700d6a64f', '/detail/b47334e588fb8a480be13c9c3cee320e', '/detail/322086c611c4bcbd56519f61d07a1bc7', '/detail/9d5891f7b9cdf0463752b857241718b5', '/detail/9e666ce36f706938b4d7b2689494783d', '/detail/d3a74bcb3f41cd82be29a31bfdc4f968', '/detail/5b7437507cff2524b0cdf1a308c1f848', '/detail/c294de1d7a600c6205b82efa9e4f437f', '/detail/238c27d31ed6b0e58be1238ffb4f603a', '/detail/cf99e5f13efae2cf97033ea716b5d2c7', '/detail/0d64874200f8f06ce8fffb2a066cf4ed', '/detail/1f26a893d8b2292becbf8a62489dd1a5', '/detail/5fc8e682aa2807d3b412d622622c2e84', '/detail/b916881c328db28b52c9d396a0fc237b', '/detail/904513de2e59ed674f628bf36b405756', '/detail/5d706a2bee647981bb99ef186286b1ff', '/detail/ac29ff465769f3865f35ffd4835b3d1c', '/detail/9e8bd25dc4f9ebb5395133f4cb8e02d3', '/detail/ddf099f652d870138ee21bcaade8d529', '/detail/a0bc03a60ed859ed21d9dc1c20c00cc1', '/detail/d4e52caa008ad90d593687d037d7152b', '/detail/74985cc59696dd5bef06c15e384e4dcc', '/detail/c10a0e2cfdcab7766579372e0089994d', '/detail/0385a47dcefec4b599269d789d813f4e', '/detail/a0514c63c8a2bd526fbe23bbe9a39b9b', '/detail/427678efb880df984ad533ef8f8a6b79', '/detail/e4cffcbbea8f22b8786afa71414a0884', '/detail/81223408aee5dea6d224ccf0ee64867f', '/detail/6ea99403daefbcdfd6b8ad78a4f515ed', '/detail/06f0960e4fc1d5de7b5d593800e6eeb4', '/detail/8de2f03d8fe2a67e3bb4c694eab3cfe1', '/detail/79ebdec973b9ed3d393941910eb65b7c', '/detail/36baf65d7fc56efec409a2be70ee41c2', '/detail/24785cee4f49440117b6ad9a16f7c64c', '/detail/0bd56478f76c26b2caf928577ba37e69', '/detail/f31e460cfe2f6963ccda9f2cf0d60ed2', '/detail/6866e61d3bfcc5cf89a72377502c8b2a', '/detail/f35dc60708966beb14c33a8c959ec4dc', '/detail/b53d654b65fa2752cc68365230f118fa', '/detail/54ae77fa7705d75c0a642e8ba5c56508', '/detail/8565f54a56a465fc946e9a0d85d4f43d', '/detail/33c3390a111762dcc71b25445ae83c44', '/detail/198ae84776e899924cc2e5324ea64e74', '/detail/00d337f41a9e6529dbf30efe849e716e', '/detail/0f2741953e6a8dd1dbb8f2074529bc0a', '/detail/187dcb70ceb18f8138949b04d1d816ea', '/detail/1c2a2db1069d97765cb68554119c4c1a', '/detail/1d6d4b02128ba4ca5c877213aa26ce0b', '/detail/1f010f49eb738fb7723551cd0c476b8a', '/detail/1f61dd6247f350f2bad7524fe1173e9d', '/detail/2bd77d2ac5b0ee4f5a1830079ea5fa80', '/detail/2d2b1776a285814167788680e7273966', '/detail/302be1abbeac88f2c2224e5bf0ba5ee8', '/detail/378875d39de2e9bc5b4859ac20d9ffa8', '/detail/37c5c06f227611109d5851a1fc52d795', '/detail/394e39b00edceb6912c04c93f8afd5f6', '/detail/41ac4ab6c86cecd6dda29cac5e18d9bd', '/detail/42b30eac84dc8f66250e2c7bf4c9d9bb', '/detail/43880550903878816fc1cd991e3cde1f', '/detail/482cf4bf2792fa28f36c498d886040e0', '/detail/4c0c39a518dc3175f27fb753b8826ceb', '/detail/4f93ab3dbf8a76514b7fcb611c1a2a04', '/detail/5845bfc3bc1c73556c8c39cccea782d1', '/detail/5d0d2585ddc3f4d298bfaa8927434085', '/detail/5de411716477e551ca2b07b04e20a5ae', '/detail/69dd938204ccdc393ef1a63633e4b530', '/detail/729d73a5bf7c8684da3c3b58f5759352', '/detail/79b6d3ecf514d09e462cbc4ab3ff36af', '/detail/7a33a78563cf8ea28c40d51e7153a67a', '/detail/7c3ed9e9b0075ebf9a31d0c9a5887b95', '/detail/8470b577594c6d8f2dc23a84edd086f7', '/detail/9072e627487c133003d1cd1ddcea2d04', '/detail/92030b7a32611e19e10212837517bd96', '/detail/983fbe58f6c97fc19297771aa779e773', '/detail/a57ba0243571cb9c7bd9095317fe68bf', '/detail/ac03cfc6f8ed81965825c4c472061849', '/detail/ad072a35ad814169c68d540fd1e76919', '/detail/af5181d37ead3db958459bdbfcfed418', '/detail/b50a030c2f0ce4a3ade54851549e7928', '/detail/b6f9df13f0df04c9e0c4a9ffcba8b2dc', '/detail/b9126eb0afe1141b7436ca75024ba9a9', '/detail/d89ba5f8d49bfbcfdf2e7ced26a8eadd', '/detail/db4b6108df5776ccd763da2fa979bac1', '/detail/e0f3d0df06c78af7448ac837342f6c2b', '/detail/e35e0291c11e76e7aa32e1089f0b5d86', '/detail/e4e0c0b1e201d2a1c6464510b7e4d4f4', '/detail/e7842a02828a5599bd6d8b24008991ca', '/detail/ea69ec09fbe00c5f9ff0a51d7253eb78', '/detail/f21232a41dd2f3676b600bfbc3d16080', '/detail/f5670478134ace2b3dd770c7a566cf9c', '/detail/f775f138a3aa95e86a8756eb4269bf3b', '/detail/f93f38b76dd97ca29f2db976a4df0f25', '/detail/fe73b6530fcee9ddcdfe3eaf306cde2c', '/detail/fe89bb431069027cf2cf6789f61f9a2a', '/detail/ff89f7b912ce648065bd1707ca40dd29', '/detail/d96aef2e7f7d39bfa30e3ea809b7eda6', '/navigation/47c823ffa54c4a838419e63637237423', '/navigation/003fead0b2c54c02b2b6a000fd0dc3c6', '/landingPage/019146c494347206b1979287d007975e', '/navigation/7d5664d1b3e6418f85f1bc53429bc3ca', '/navigation/513109c128ad4a7ab30fa1d8979d40e0', '/navigation/a5b2c8e80d144124a5321366d0d6bdc6', '/landingPage/018ee098c74f763e91f7d621dbfa7074', '/landingPage/4e6f17971ae5455ab840ad4974ac14a1')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x02610C08A5514EC3810B62DDB82119C7 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 107)
3	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->createSeoMapping (line 52)
4	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->Shopware\Core\Content\Seo\{closure} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 47)
6	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->replace (line 109)
7	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 35)
8	Shopware\Storefront\Controller\LandingPageController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
11	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
12	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
13	Shopware\Core\Kernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
19	Shopware\Core\HttpKernel->doHandle (line 67)
20	Shopware\Core\HttpKernel->handle (line 63)
21	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 12)

5.21 ms
(9.49%)

SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock` FROM `product` WHERE (`product`.`version_id` = ?) AND ((((`product`.`stock` >= ?) AND (`product`.`available_stock` < ?) AND `product`.`version_id` = ?)))

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  0
  0
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `product`.`id` as `product.id`,
  `product`.`version_id` as `product.versionId`,
  `product`.`product_number` as `product.productNumber`,
  `product`.`stock` as `product.stock`
FROM
  `product`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (`product`.`stock` >= ?)
        AND (`product`.`available_stock` < ?)
        AND `product`.`version_id` = ?
      )
    )
  )

SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock` FROM `product` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product`.`stock` >= 0) AND (`product`.`available_stock` < 0) AND `product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425)));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 60)
9	Bisg\ProductInventory\Core\Content\Product\Stock\ProductStockTouchService->touch (line 168)
10	Bisg\ProductInventory\Core\Content\Product\Subscriber\ProductSubscriber->onRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
22	Shopware\Core\Kernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
28	Shopware\Core\HttpKernel->doHandle (line 67)
29	Shopware\Core\HttpKernel->handle (line 63)
30	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 12)

4.44 ms
(8.08%)

SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))

Parameters:

[
  b"\x01‰±5ÆYp\x07€£êò\fõÃá"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `script`.`id` as `script.id`,
  `script`.`script` as `script.script`,
  `script`.`hook` as `script.hook`,
  `script`.`name` as `script.name`,
  `script`.`active` as `script.active`,
  `script`.`app_id` as `script.appId`,
  `script`.`created_at` as `script.createdAt`,
  `script`.`updated_at` as `script.updatedAt`
FROM
  `script`
WHERE
  (
    `script`.`app_id` IN (?)
  )

SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (0x0189B135C659700780A3EAF20CF5C3E1));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 490)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 433)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1208)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 132)
13	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->getAppWithExistingScripts (line 30)
14	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->updateScripts (line 110)
15	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->refresh (line 72)
16	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
17	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 56)
18	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
19	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
20	Shopware\Core\Profiling\Profiler::trace (line 34)
21	Shopware\Core\Checkout\Cart\Processor->process (line 105)
22	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 83)
24	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
25	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
26	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
27	Shopware\Core\Profiling\Profiler::trace (line 59)
28	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
29	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
30	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
34	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
35	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
36	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
37	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
40	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
41	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
42	Shopware\Core\Kernel->handle (line 86)
43	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
44	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
46	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
47	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
48	Shopware\Core\HttpKernel->doHandle (line 67)
49	Shopware\Core\HttpKernel->handle (line 63)
50	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	require_once (line 12)

3.95 ms
(7.20%)

# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]

View formatted query View runnable query Explain query View query backtrace

# app-scripts::refresh::read
SELECT
  `app`.`id` as `app.id`,
  `app`.`name` as `app.name`,
  `app`.`path` as `app.path`,
  `app`.`author` as `app.author`,
  `app`.`copyright` as `app.copyright`,
  `app`.`license` as `app.license`,
  `app`.`active` as `app.active`,
  `app`.`configurable` as `app.configurable`,
  `app`.`privacy` as `app.privacy`,
  `app`.`version` as `app.version`,
  `app`.`icon` as `app.iconRaw`,
  `app`.`app_secret` as `app.appSecret`,
  `app`.`modules` as `app.modules`,
  `app`.`main_module` as `app.mainModule`,
  `app`.`cookies` as `app.cookies`,
  `app`.`allow_disable` as `app.allowDisable`,
  `app`.`base_app_url` as `app.baseAppUrl`,
  `app`.`allowed_hosts` as `app.allowedHosts`,
  `app`.`template_load_priority` as `app.templateLoadPriority`,
  `app`.`integration_id` as `app.integrationId`,
  `app.integration`.`id` as `app.integration.id`,
  `app.integration`.`label` as `app.integration.label`,
  `app.integration`.`access_key` as `app.integration.accessKey`,
  `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
  `app.integration`.`admin` as `app.integration.admin`,
  `app.integration`.`custom_fields` as `app.integration.customFields`,
  `app.integration`.`deleted_at` as `app.integration.deletedAt`,
  `app.integration`.`write_access` as `app.integration.writeAccess`,
  `app.integration`.`created_at` as `app.integration.createdAt`,
  `app.integration`.`updated_at` as `app.integration.updatedAt`,
  `app`.`acl_role_id` as `app.aclRoleId`,
  `app.aclRole`.`id` as `app.aclRole.id`,
  `app.aclRole`.`name` as `app.aclRole.name`,
  `app.aclRole`.`description` as `app.aclRole.description`,
  `app.aclRole`.`privileges` as `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` as `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
  `app`.`created_at` as `app.createdAt`,
  `app`.`updated_at` as `app.updatedAt`,
  `app.translation.label`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  LEFT JOIN (
    SELECT
      `app.translation`.app_id,
      `app.translation`.label as `app.translation.label`,
      `app.translation`.description as `app.translation.description`,
      `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
      `app.translation`.custom_fields as `app.translation.customFields`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
  (`app`.`active` = ?)

# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 65)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 106)
11	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->refresh (line 72)
12	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
13	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 56)
14	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
15	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 34)
17	Shopware\Core\Checkout\Cart\Processor->process (line 105)
18	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 83)
20	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
21	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
22	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 59)
24	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
25	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
26	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
30	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
31	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
32	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
36	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
37	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
38	Shopware\Core\Kernel->handle (line 86)
39	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
42	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
44	Shopware\Core\HttpKernel->doHandle (line 67)
45	Shopware\Core\HttpKernel->handle (line 63)
46	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 12)

3.75 ms
(6.82%)

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS scriptName,
  `script`.`script` AS script,
  `script`.`hook` AS hook,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  `app`.`version` AS appVersion,
  `script`.`active` AS active
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` != 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 76)
3	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
4	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 56)
5	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
6	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
7	Shopware\Core\Profiling\Profiler::trace (line 34)
8	Shopware\Core\Checkout\Cart\Processor->process (line 105)
9	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 83)
11	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
13	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 59)
15	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
16	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
17	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
21	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
22	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
23	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
27	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
29	Shopware\Core\Kernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
35	Shopware\Core\HttpKernel->doHandle (line 67)
36	Shopware\Core\HttpKernel->handle (line 63)
37	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 12)

2.95 ms
(5.37%)

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS name,
  `script`.`script` AS script,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` = 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 92)
3	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
4	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 56)
5	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
6	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
7	Shopware\Core\Profiling\Profiler::trace (line 34)
8	Shopware\Core\Checkout\Cart\Processor->process (line 105)
9	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 83)
11	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
13	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 59)
15	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
16	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
17	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
21	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
22	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
23	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
27	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
29	Shopware\Core\Kernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
35	Shopware\Core\HttpKernel->doHandle (line 67)
36	Shopware\Core\HttpKernel->handle (line 63)
37	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 12)

1.67 ms
(3.04%)

SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, (SELECT GROUP_CONCAT(HEX(`sales_channel.paymentMethods.mapping`.`payment_method_id`) SEPARATOR '||')
                  FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping`
                  WHERE `sales_channel.paymentMethods.mapping`.`sales_channel_id` = `sales_channel`.`id` ) as `sales_channel.paymentMethods.id_mapping`, `sales_channel.country`.`id` as `sales_channel.country.id`, `sales_channel.country`.`iso` as `sales_channel.country.iso`, `sales_channel.country`.`position` as `sales_channel.country.position`, `sales_channel.country`.`active` as `sales_channel.country.active`, `sales_channel.country`.`shipping_available` as `sales_channel.country.shippingAvailable`, `sales_channel.country`.`iso3` as `sales_channel.country.iso3`, `sales_channel.country`.`display_state_in_registration` as `sales_channel.country.displayStateInRegistration`, `sales_channel.country`.`force_state_in_registration` as `sales_channel.country.forceStateInRegistration`, `sales_channel.country`.`check_vat_id_pattern` as `sales_channel.country.checkVatIdPattern`, `sales_channel.country`.`vat_id_required` as `sales_channel.country.vatIdRequired`, `sales_channel.country`.`vat_id_pattern` as `sales_channel.country.vatIdPattern`, `sales_channel.country`.`customer_tax` as `sales_channel.country.customerTax`, `sales_channel.country`.`company_tax` as `sales_channel.country.companyTax`, `sales_channel.country`.`postal_code_required` as `sales_channel.country.postalCodeRequired`, `sales_channel.country`.`check_postal_code_pattern` as `sales_channel.country.checkPostalCodePattern`, `sales_channel.country`.`check_advanced_postal_code_pattern` as `sales_channel.country.checkAdvancedPostalCodePattern`, `sales_channel.country`.`advanced_postal_code_pattern` as `sales_channel.country.advancedPostalCodePattern`, `sales_channel.country`.`default_postal_code_pattern` as `sales_channel.country.defaultPostalCodePattern`, `sales_channel.country`.`created_at` as `sales_channel.country.createdAt`, `sales_channel.country`.`updated_at` as `sales_channel.country.updatedAt`, `sales_channel.country.translation.name`, COALESCE(`sales_channel.country.translation.name`,`sales_channel.country.translation.name`) as `sales_channel.country.name`, `sales_channel.country.translation.addressFormat`, COALESCE(`sales_channel.country.translation.addressFormat`,`sales_channel.country.translation.addressFormat`) as `sales_channel.country.addressFormat`, `sales_channel.country.translation.customFields`, COALESCE(`sales_channel.country.translation.customFields`,`sales_channel.country.translation.customFields`) as `sales_channel.country.customFields`, `sales_channel.country.translation.createdAt`, `sales_channel.country.translation.updatedAt`, `sales_channel.country.translation.countryId`, `sales_channel.country.translation.languageId`, `sales_channel.language`.`id` as `sales_channel.language.id`, `sales_channel.language`.`parent_id` as `sales_channel.language.parentId`, `sales_channel.language`.`locale_id` as `sales_channel.language.localeId`, `sales_channel.language`.`translation_code_id` as `sales_channel.language.translationCodeId`, `sales_channel.language`.`name` as `sales_channel.language.name`, `sales_channel.language`.`custom_fields` as `sales_channel.language.customFields`, `sales_channel.language`.`created_at` as `sales_channel.language.createdAt`, `sales_channel.language`.`updated_at` as `sales_channel.language.updatedAt`, `sales_channel.language.locale`.`id` as `sales_channel.language.locale.id`, `sales_channel.language.locale`.`code` as `sales_channel.language.locale.code`, `sales_channel.language.locale`.`created_at` as `sales_channel.language.locale.createdAt`, `sales_channel.language.locale`.`updated_at` as `sales_channel.language.locale.updatedAt`, `sales_channel.language.locale.translation.name`, COALESCE(`sales_channel.language.locale.translation.name`,`sales_channel.language.locale.translation.name`) as `sales_channel.language.locale.name`, `sales_channel.language.locale.translation.territory`, COALESCE(`sales_channel.language.locale.translation.territory`,`sales_channel.language.locale.translation.territory`) as `sales_channel.language.locale.territory`, `sales_channel.language.locale.translation.customFields`, COALESCE(`sales_channel.language.locale.translation.customFields`,`sales_channel.language.locale.translation.customFields`) as `sales_channel.language.locale.customFields`, `sales_channel.language.locale.translation.createdAt`, `sales_channel.language.locale.translation.updatedAt`, `sales_channel.language.locale.translation.localeId`, `sales_channel.language.locale.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `country` `sales_channel.country` ON `sales_channel`.`country_id` = `sales_channel.country`.`id` LEFT JOIN `language` `sales_channel.language` ON `sales_channel`.`language_id` = `sales_channel.language`.`id` LEFT JOIN (SELECT `sales_channel.country.translation`.country_id, `sales_channel.country.translation`.name as `sales_channel.country.translation.name`, `sales_channel.country.translation`.address_format as `sales_channel.country.translation.addressFormat`, `sales_channel.country.translation`.custom_fields as `sales_channel.country.translation.customFields`, `sales_channel.country.translation`.created_at as `sales_channel.country.translation.createdAt`, `sales_channel.country.translation`.updated_at as `sales_channel.country.translation.updatedAt`, `sales_channel.country.translation`.country_id as `sales_channel.country.translation.countryId`, `sales_channel.country.translation`.language_id as `sales_channel.country.translation.languageId` FROM `country_translation` `sales_channel.country.translation` WHERE `sales_channel.country.translation`.language_id = ?) `sales_channel.country.country_translation` ON `sales_channel.country.country_translation`.`country_id` = `sales_channel.country`.`id` LEFT JOIN `locale` `sales_channel.language.locale` ON `sales_channel.language`.`locale_id` = `sales_channel.language.locale`.`id` LEFT JOIN (SELECT `sales_channel.language.locale.translation`.locale_id, `sales_channel.language.locale.translation`.name as `sales_channel.language.locale.translation.name`, `sales_channel.language.locale.translation`.territory as `sales_channel.language.locale.translation.territory`, `sales_channel.language.locale.translation`.custom_fields as `sales_channel.language.locale.translation.customFields`, `sales_channel.language.locale.translation`.created_at as `sales_channel.language.locale.translation.createdAt`, `sales_channel.language.locale.translation`.updated_at as `sales_channel.language.locale.translation.updatedAt`, `sales_channel.language.locale.translation`.locale_id as `sales_channel.language.locale.translation.localeId`, `sales_channel.language.locale.translation`.language_id as `sales_channel.language.locale.translation.languageId` FROM `locale_translation` `sales_channel.language.locale.translation` WHERE `sales_channel.language.locale.translation`.language_id = ?) `sales_channel.language.locale.locale_translation` ON `sales_channel.language.locale.locale_translation`.`locale_id` = `sales_channel.language.locale`.`id` WHERE `sales_channel`.`id` IN (?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x02a\f\x08ÑQN├ü\vb¦©!\x19Ã"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `sales_channel`.`id` as `sales_channel.id`,
  `sales_channel`.`type_id` as `sales_channel.typeId`,
  `sales_channel`.`language_id` as `sales_channel.languageId`,
  `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`,
  `sales_channel`.`currency_id` as `sales_channel.currencyId`,
  `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`,
  `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`,
  `sales_channel`.`country_id` as `sales_channel.countryId`,
  `sales_channel`.`analytics_id` as `sales_channel.analyticsId`,
  `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`,
  `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`,
  `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`,
  `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`,
  `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`,
  `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`,
  `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`,
  `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`,
  `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`,
  `sales_channel`.`short_name` as `sales_channel.shortName`,
  `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`,
  `sales_channel`.`access_key` as `sales_channel.accessKey`,
  `sales_channel`.`configuration` as `sales_channel.configuration`,
  `sales_channel`.`active` as `sales_channel.active`,
  `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`,
  `sales_channel`.`maintenance` as `sales_channel.maintenance`,
  `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`,
  `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`,
  `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`,
  `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`,
  `sales_channel.analytics`.`id` as `sales_channel.analytics.id`,
  `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`,
  `sales_channel.analytics`.`active` as `sales_channel.analytics.active`,
  `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`,
  `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`,
  `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`,
  `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`,
  `sales_channel`.`created_at` as `sales_channel.createdAt`,
  `sales_channel`.`updated_at` as `sales_channel.updatedAt`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `sales_channel.paymentMethods.mapping`.`payment_method_id`
        ) SEPARATOR '||'
      )
    FROM
      `sales_channel_payment_method` `sales_channel.paymentMethods.mapping`
    WHERE
      `sales_channel.paymentMethods.mapping`.`sales_channel_id` = `sales_channel`.`id`
  ) as `sales_channel.paymentMethods.id_mapping`,
  `sales_channel.country`.`id` as `sales_channel.country.id`,
  `sales_channel.country`.`iso` as `sales_channel.country.iso`,
  `sales_channel.country`.`position` as `sales_channel.country.position`,
  `sales_channel.country`.`active` as `sales_channel.country.active`,
  `sales_channel.country`.`shipping_available` as `sales_channel.country.shippingAvailable`,
  `sales_channel.country`.`iso3` as `sales_channel.country.iso3`,
  `sales_channel.country`.`display_state_in_registration` as `sales_channel.country.displayStateInRegistration`,
  `sales_channel.country`.`force_state_in_registration` as `sales_channel.country.forceStateInRegistration`,
  `sales_channel.country`.`check_vat_id_pattern` as `sales_channel.country.checkVatIdPattern`,
  `sales_channel.country`.`vat_id_required` as `sales_channel.country.vatIdRequired`,
  `sales_channel.country`.`vat_id_pattern` as `sales_channel.country.vatIdPattern`,
  `sales_channel.country`.`customer_tax` as `sales_channel.country.customerTax`,
  `sales_channel.country`.`company_tax` as `sales_channel.country.companyTax`,
  `sales_channel.country`.`postal_code_required` as `sales_channel.country.postalCodeRequired`,
  `sales_channel.country`.`check_postal_code_pattern` as `sales_channel.country.checkPostalCodePattern`,
  `sales_channel.country`.`check_advanced_postal_code_pattern` as `sales_channel.country.checkAdvancedPostalCodePattern`,
  `sales_channel.country`.`advanced_postal_code_pattern` as `sales_channel.country.advancedPostalCodePattern`,
  `sales_channel.country`.`default_postal_code_pattern` as `sales_channel.country.defaultPostalCodePattern`,
  `sales_channel.country`.`created_at` as `sales_channel.country.createdAt`,
  `sales_channel.country`.`updated_at` as `sales_channel.country.updatedAt`,
  `sales_channel.country.translation.name`,
  COALESCE(
    `sales_channel.country.translation.name`,
    `sales_channel.country.translation.name`
  ) as `sales_channel.country.name`,
  `sales_channel.country.translation.addressFormat`,
  COALESCE(
    `sales_channel.country.translation.addressFormat`,
    `sales_channel.country.translation.addressFormat`
  ) as `sales_channel.country.addressFormat`,
  `sales_channel.country.translation.customFields`,
  COALESCE(
    `sales_channel.country.translation.customFields`,
    `sales_channel.country.translation.customFields`
  ) as `sales_channel.country.customFields`,
  `sales_channel.country.translation.createdAt`,
  `sales_channel.country.translation.updatedAt`,
  `sales_channel.country.translation.countryId`,
  `sales_channel.country.translation.languageId`,
  `sales_channel.language`.`id` as `sales_channel.language.id`,
  `sales_channel.language`.`parent_id` as `sales_channel.language.parentId`,
  `sales_channel.language`.`locale_id` as `sales_channel.language.localeId`,
  `sales_channel.language`.`translation_code_id` as `sales_channel.language.translationCodeId`,
  `sales_channel.language`.`name` as `sales_channel.language.name`,
  `sales_channel.language`.`custom_fields` as `sales_channel.language.customFields`,
  `sales_channel.language`.`created_at` as `sales_channel.language.createdAt`,
  `sales_channel.language`.`updated_at` as `sales_channel.language.updatedAt`,
  `sales_channel.language.locale`.`id` as `sales_channel.language.locale.id`,
  `sales_channel.language.locale`.`code` as `sales_channel.language.locale.code`,
  `sales_channel.language.locale`.`created_at` as `sales_channel.language.locale.createdAt`,
  `sales_channel.language.locale`.`updated_at` as `sales_channel.language.locale.updatedAt`,
  `sales_channel.language.locale.translation.name`,
  COALESCE(
    `sales_channel.language.locale.translation.name`,
    `sales_channel.language.locale.translation.name`
  ) as `sales_channel.language.locale.name`,
  `sales_channel.language.locale.translation.territory`,
  COALESCE(
    `sales_channel.language.locale.translation.territory`,
    `sales_channel.language.locale.translation.territory`
  ) as `sales_channel.language.locale.territory`,
  `sales_channel.language.locale.translation.customFields`,
  COALESCE(
    `sales_channel.language.locale.translation.customFields`,
    `sales_channel.language.locale.translation.customFields`
  ) as `sales_channel.language.locale.customFields`,
  `sales_channel.language.locale.translation.createdAt`,
  `sales_channel.language.locale.translation.updatedAt`,
  `sales_channel.language.locale.translation.localeId`,
  `sales_channel.language.locale.translation.languageId`,
  `sales_channel.translation.name`,
  COALESCE(
    `sales_channel.translation.name`,
    `sales_channel.translation.name`
  ) as `sales_channel.name`,
  `sales_channel.translation.homeSlotConfig`,
  COALESCE(
    `sales_channel.translation.homeSlotConfig`,
    `sales_channel.translation.homeSlotConfig`
  ) as `sales_channel.homeSlotConfig`,
  `sales_channel.translation.homeEnabled`,
  COALESCE(
    `sales_channel.translation.homeEnabled`,
    `sales_channel.translation.homeEnabled`
  ) as `sales_channel.homeEnabled`,
  `sales_channel.translation.homeName`,
  COALESCE(
    `sales_channel.translation.homeName`,
    `sales_channel.translation.homeName`
  ) as `sales_channel.homeName`,
  `sales_channel.translation.homeMetaTitle`,
  COALESCE(
    `sales_channel.translation.homeMetaTitle`,
    `sales_channel.translation.homeMetaTitle`
  ) as `sales_channel.homeMetaTitle`,
  `sales_channel.translation.homeMetaDescription`,
  COALESCE(
    `sales_channel.translation.homeMetaDescription`,
    `sales_channel.translation.homeMetaDescription`
  ) as `sales_channel.homeMetaDescription`,
  `sales_channel.translation.homeKeywords`,
  COALESCE(
    `sales_channel.translation.homeKeywords`,
    `sales_channel.translation.homeKeywords`
  ) as `sales_channel.homeKeywords`,
  `sales_channel.translation.customFields`,
  COALESCE(
    `sales_channel.translation.customFields`,
    `sales_channel.translation.customFields`
  ) as `sales_channel.customFields`,
  `sales_channel.translation.createdAt`,
  `sales_channel.translation.updatedAt`,
  `sales_channel.translation.salesChannelId`,
  `sales_channel.translation.languageId`
FROM
  `sales_channel`
  LEFT JOIN (
    SELECT
      `sales_channel.translation`.sales_channel_id,
      `sales_channel.translation`.name as `sales_channel.translation.name`,
      `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`,
      `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`,
      `sales_channel.translation`.home_name as `sales_channel.translation.homeName`,
      `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`,
      `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`,
      `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`,
      `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`,
      `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`,
      `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`,
      `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`,
      `sales_channel.translation`.language_id as `sales_channel.translation.languageId`
    FROM
      `sales_channel_translation` `sales_channel.translation`
    WHERE
      `sales_channel.translation`.language_id = ?
  ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id`
  LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id`
  LEFT JOIN `country` `sales_channel.country` ON `sales_channel`.`country_id` = `sales_channel.country`.`id`
  LEFT JOIN `language` `sales_channel.language` ON `sales_channel`.`language_id` = `sales_channel.language`.`id`
  LEFT JOIN (
    SELECT
      `sales_channel.country.translation`.country_id,
      `sales_channel.country.translation`.name as `sales_channel.country.translation.name`,
      `sales_channel.country.translation`.address_format as `sales_channel.country.translation.addressFormat`,
      `sales_channel.country.translation`.custom_fields as `sales_channel.country.translation.customFields`,
      `sales_channel.country.translation`.created_at as `sales_channel.country.translation.createdAt`,
      `sales_channel.country.translation`.updated_at as `sales_channel.country.translation.updatedAt`,
      `sales_channel.country.translation`.country_id as `sales_channel.country.translation.countryId`,
      `sales_channel.country.translation`.language_id as `sales_channel.country.translation.languageId`
    FROM
      `country_translation` `sales_channel.country.translation`
    WHERE
      `sales_channel.country.translation`.language_id = ?
  ) `sales_channel.country.country_translation` ON `sales_channel.country.country_translation`.`country_id` = `sales_channel.country`.`id`
  LEFT JOIN `locale` `sales_channel.language.locale` ON `sales_channel.language`.`locale_id` = `sales_channel.language.locale`.`id`
  LEFT JOIN (
    SELECT
      `sales_channel.language.locale.translation`.locale_id,
      `sales_channel.language.locale.translation`.name as `sales_channel.language.locale.translation.name`,
      `sales_channel.language.locale.translation`.territory as `sales_channel.language.locale.translation.territory`,
      `sales_channel.language.locale.translation`.custom_fields as `sales_channel.language.locale.translation.customFields`,
      `sales_channel.language.locale.translation`.created_at as `sales_channel.language.locale.translation.createdAt`,
      `sales_channel.language.locale.translation`.updated_at as `sales_channel.language.locale.translation.updatedAt`,
      `sales_channel.language.locale.translation`.locale_id as `sales_channel.language.locale.translation.localeId`,
      `sales_channel.language.locale.translation`.language_id as `sales_channel.language.locale.translation.languageId`
    FROM
      `locale_translation` `sales_channel.language.locale.translation`
    WHERE
      `sales_channel.language.locale.translation`.language_id = ?
  ) `sales_channel.language.locale.locale_translation` ON `sales_channel.language.locale.locale_translation`.`locale_id` = `sales_channel.language.locale`.`id`
WHERE
  `sales_channel`.`id` IN (?)

SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, (SELECT GROUP_CONCAT(HEX(`sales_channel.paymentMethods.mapping`.`payment_method_id`) SEPARATOR '||')
                  FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping`
                  WHERE `sales_channel.paymentMethods.mapping`.`sales_channel_id` = `sales_channel`.`id` ) as `sales_channel.paymentMethods.id_mapping`, `sales_channel.country`.`id` as `sales_channel.country.id`, `sales_channel.country`.`iso` as `sales_channel.country.iso`, `sales_channel.country`.`position` as `sales_channel.country.position`, `sales_channel.country`.`active` as `sales_channel.country.active`, `sales_channel.country`.`shipping_available` as `sales_channel.country.shippingAvailable`, `sales_channel.country`.`iso3` as `sales_channel.country.iso3`, `sales_channel.country`.`display_state_in_registration` as `sales_channel.country.displayStateInRegistration`, `sales_channel.country`.`force_state_in_registration` as `sales_channel.country.forceStateInRegistration`, `sales_channel.country`.`check_vat_id_pattern` as `sales_channel.country.checkVatIdPattern`, `sales_channel.country`.`vat_id_required` as `sales_channel.country.vatIdRequired`, `sales_channel.country`.`vat_id_pattern` as `sales_channel.country.vatIdPattern`, `sales_channel.country`.`customer_tax` as `sales_channel.country.customerTax`, `sales_channel.country`.`company_tax` as `sales_channel.country.companyTax`, `sales_channel.country`.`postal_code_required` as `sales_channel.country.postalCodeRequired`, `sales_channel.country`.`check_postal_code_pattern` as `sales_channel.country.checkPostalCodePattern`, `sales_channel.country`.`check_advanced_postal_code_pattern` as `sales_channel.country.checkAdvancedPostalCodePattern`, `sales_channel.country`.`advanced_postal_code_pattern` as `sales_channel.country.advancedPostalCodePattern`, `sales_channel.country`.`default_postal_code_pattern` as `sales_channel.country.defaultPostalCodePattern`, `sales_channel.country`.`created_at` as `sales_channel.country.createdAt`, `sales_channel.country`.`updated_at` as `sales_channel.country.updatedAt`, `sales_channel.country.translation.name`, COALESCE(`sales_channel.country.translation.name`,`sales_channel.country.translation.name`) as `sales_channel.country.name`, `sales_channel.country.translation.addressFormat`, COALESCE(`sales_channel.country.translation.addressFormat`,`sales_channel.country.translation.addressFormat`) as `sales_channel.country.addressFormat`, `sales_channel.country.translation.customFields`, COALESCE(`sales_channel.country.translation.customFields`,`sales_channel.country.translation.customFields`) as `sales_channel.country.customFields`, `sales_channel.country.translation.createdAt`, `sales_channel.country.translation.updatedAt`, `sales_channel.country.translation.countryId`, `sales_channel.country.translation.languageId`, `sales_channel.language`.`id` as `sales_channel.language.id`, `sales_channel.language`.`parent_id` as `sales_channel.language.parentId`, `sales_channel.language`.`locale_id` as `sales_channel.language.localeId`, `sales_channel.language`.`translation_code_id` as `sales_channel.language.translationCodeId`, `sales_channel.language`.`name` as `sales_channel.language.name`, `sales_channel.language`.`custom_fields` as `sales_channel.language.customFields`, `sales_channel.language`.`created_at` as `sales_channel.language.createdAt`, `sales_channel.language`.`updated_at` as `sales_channel.language.updatedAt`, `sales_channel.language.locale`.`id` as `sales_channel.language.locale.id`, `sales_channel.language.locale`.`code` as `sales_channel.language.locale.code`, `sales_channel.language.locale`.`created_at` as `sales_channel.language.locale.createdAt`, `sales_channel.language.locale`.`updated_at` as `sales_channel.language.locale.updatedAt`, `sales_channel.language.locale.translation.name`, COALESCE(`sales_channel.language.locale.translation.name`,`sales_channel.language.locale.translation.name`) as `sales_channel.language.locale.name`, `sales_channel.language.locale.translation.territory`, COALESCE(`sales_channel.language.locale.translation.territory`,`sales_channel.language.locale.translation.territory`) as `sales_channel.language.locale.territory`, `sales_channel.language.locale.translation.customFields`, COALESCE(`sales_channel.language.locale.translation.customFields`,`sales_channel.language.locale.translation.customFields`) as `sales_channel.language.locale.customFields`, `sales_channel.language.locale.translation.createdAt`, `sales_channel.language.locale.translation.updatedAt`, `sales_channel.language.locale.translation.localeId`, `sales_channel.language.locale.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `country` `sales_channel.country` ON `sales_channel`.`country_id` = `sales_channel.country`.`id` LEFT JOIN `language` `sales_channel.language` ON `sales_channel`.`language_id` = `sales_channel.language`.`id` LEFT JOIN (SELECT `sales_channel.country.translation`.country_id, `sales_channel.country.translation`.name as `sales_channel.country.translation.name`, `sales_channel.country.translation`.address_format as `sales_channel.country.translation.addressFormat`, `sales_channel.country.translation`.custom_fields as `sales_channel.country.translation.customFields`, `sales_channel.country.translation`.created_at as `sales_channel.country.translation.createdAt`, `sales_channel.country.translation`.updated_at as `sales_channel.country.translation.updatedAt`, `sales_channel.country.translation`.country_id as `sales_channel.country.translation.countryId`, `sales_channel.country.translation`.language_id as `sales_channel.country.translation.languageId` FROM `country_translation` `sales_channel.country.translation` WHERE `sales_channel.country.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel.country.country_translation` ON `sales_channel.country.country_translation`.`country_id` = `sales_channel.country`.`id` LEFT JOIN `locale` `sales_channel.language.locale` ON `sales_channel.language`.`locale_id` = `sales_channel.language.locale`.`id` LEFT JOIN (SELECT `sales_channel.language.locale.translation`.locale_id, `sales_channel.language.locale.translation`.name as `sales_channel.language.locale.translation.name`, `sales_channel.language.locale.translation`.territory as `sales_channel.language.locale.translation.territory`, `sales_channel.language.locale.translation`.custom_fields as `sales_channel.language.locale.translation.customFields`, `sales_channel.language.locale.translation`.created_at as `sales_channel.language.locale.translation.createdAt`, `sales_channel.language.locale.translation`.updated_at as `sales_channel.language.locale.translation.updatedAt`, `sales_channel.language.locale.translation`.locale_id as `sales_channel.language.locale.translation.localeId`, `sales_channel.language.locale.translation`.language_id as `sales_channel.language.locale.translation.languageId` FROM `locale_translation` `sales_channel.language.locale.translation` WHERE `sales_channel.language.locale.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel.language.locale.locale_translation` ON `sales_channel.language.locale.locale_translation`.`locale_id` = `sales_channel.language.locale`.`id` WHERE `sales_channel`.`id` IN (0x02610C08A5514EC3810B62DDB82119C7);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 139)
9	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->getSalesChannel (line 109)
10	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->testPaymentMethodExistence (line 52)
11	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->isKlarnaCheckoutEnabled (line 67)
12	KlarnaPayment\Components\EventListener\FooterBadgeEventListener->displayKlarnaCheckoutBadge (line 41)
13	KlarnaPayment\Components\EventListener\FooterBadgeEventListener->addFooterBadge (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
17	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
18	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
19	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 39)
21	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 60)
22	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 38)
24	Shopware\Storefront\Page\GenericPageLoader->load (line 47)
25	Shopware\Storefront\Page\LandingPage\LandingPageLoader->load (line 31)
26	Shopware\Storefront\Controller\LandingPageController->index (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
31	Shopware\Core\Kernel->handle (line 86)
32	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
37	Shopware\Core\HttpKernel->doHandle (line 67)
38	Shopware\Core\HttpKernel->handle (line 63)
39	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 12)

0.82 ms
(1.49%)

SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01è<\x1C░═q<òTÔfÅ\x08 _"
  b"\x01Ä╠®Â[qèü╦\x13$8k┴\x04"
  b"ZvóEê\x1DC°˜ýP†€È›ö"
  b"u4Í\x03·`ID©¹û¼LDæÈ"
  b"…"Vv2—CÑšN‚j¢ÝÜ"
  b"ŸJÇ¾ó9D‡°«’˜Ñ.±½"
  b" ;S¦ãÓH6±PÌnêöÙ}"
  b"¤¨ì¿ÌÃG’²H~nØ\x1A\U"
  b"ª÷\x1F_ÁnH\x06ž^\x19‘[\x06•s"
  b"L¦B\x04k@$„Dë£‹¸õè"
  b"▒7Í6ÚÆO'ì┘\x07$▓╗A"
  b"¼wë1y>N5¯¡lwz\x18/h"
  b"½¯\x05†p¡Kx¹[\x0F\x13 ·š\x0E"
  b"╬G}‗┴ÅE2ê=ÉnQ┌Cg"
  b"ÒEÃž‡\x07è_\x05>€j¿ü»6"
  b"ÓQýÔ;dHy€!z\x02®Îé˜"
  b"Þêe'&ÞEù¶ç\x19–ø\x1C!J"
  b"áb0\x13{\x15D˜³\x14'eŽh$ˆ"
  b"íà[q›!AC¤Ë\x1C\x02\x16¸RÞ"
  b"ñï6SŒYMÅ€µž( j\x12—"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `payment_method`.`id` as `payment_method.id`,
  `payment_method`.`plugin_id` as `payment_method.pluginId`,
  `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`,
  `payment_method`.`position` as `payment_method.position`,
  `payment_method`.`active` as `payment_method.active`,
  `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`,
  `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`,
  `payment_method`.`media_id` as `payment_method.mediaId`,
  `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`,
  `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`,
  `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`,
  `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`,
  `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`,
  `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`,
  `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`,
  `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`,
  `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`,
  `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`,
  `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`,
  `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`,
  `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`,
  `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`,
  `payment_method`.`technical_name` as `payment_method.technicalName`,
  `payment_method`.`created_at` as `payment_method.createdAt`,
  `payment_method`.`updated_at` as `payment_method.updatedAt`,
  `payment_method.translation.name`,
  COALESCE(
    `payment_method.translation.name`,
    `payment_method.translation.name`
  ) as `payment_method.name`,
  `payment_method.translation.distinguishableName`,
  COALESCE(
    `payment_method.translation.distinguishableName`,
    `payment_method.translation.distinguishableName`
  ) as `payment_method.distinguishableName`,
  `payment_method.translation.description`,
  COALESCE(
    `payment_method.translation.description`,
    `payment_method.translation.description`
  ) as `payment_method.description`,
  `payment_method.translation.customFields`,
  COALESCE(
    `payment_method.translation.customFields`,
    `payment_method.translation.customFields`
  ) as `payment_method.customFields`,
  `payment_method.translation.createdAt`,
  `payment_method.translation.updatedAt`,
  `payment_method.translation.paymentMethodId`,
  `payment_method.translation.languageId`
FROM
  `payment_method`
  LEFT JOIN (
    SELECT
      `payment_method.translation`.payment_method_id,
      `payment_method.translation`.name as `payment_method.translation.name`,
      `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`,
      `payment_method.translation`.description as `payment_method.translation.description`,
      `payment_method.translation`.custom_fields as `payment_method.translation.customFields`,
      `payment_method.translation`.created_at as `payment_method.translation.createdAt`,
      `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`,
      `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`,
      `payment_method.translation`.language_id as `payment_method.translation.languageId`
    FROM
      `payment_method_translation` `payment_method.translation`
    WHERE
      `payment_method.translation`.language_id = ?
  ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id`
  LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id`
WHERE
  `payment_method`.`id` IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE `payment_method`.`id` IN (0x018A3C1CB0CD713C9554E2668F08205F, 0x018ECCA9B65B718A81CB1324386BC104, 0x5A76F345EA1D43B098FD508680C89BF6, 0x7534CD03B7604944A9B9FBBC4C44E6C8, 0x85225676329743D19A4EAD826AA2DDDC, 0x9F4AC7BEF3394487B0AB9298D12EB1BD, 0xA03B53A6E3D34836B150CC6EEAF6D97D, 0xA4A8ECBFCCC34792B2487E6ED81A5C55, 0xAAF71F5FC16E48069E5E19915B069573, 0xAD4CA642046B40248444EBA38BB8F5E8, 0xB137D636E9924F278DD90724B2F0BB41, 0xBC77EB31793E4E35AFA16C777A182F68, 0xBDAF058670A14B78B95B0F1320B79A0E, 0xCE477DF2C18F4532883D906E51DA4367, 0xD245C39E8707E85F053E806ABFFCBB36, 0xD351FDD43B64487980217A02AECEE998, 0xDEEA652726DE45F9B6E71996F81C214A, 0xE16230137B154498B31427658E682488, 0xEDE05B719B214143A4CB1C0216B852DE, 0xF1EF36538C594DC580B59E28206A1297);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 670)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyOverExtension (line 339)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1214)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 139)
13	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->getSalesChannel (line 109)
14	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->testPaymentMethodExistence (line 52)
15	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->isKlarnaCheckoutEnabled (line 67)
16	KlarnaPayment\Components\EventListener\FooterBadgeEventListener->displayKlarnaCheckoutBadge (line 41)
17	KlarnaPayment\Components\EventListener\FooterBadgeEventListener->addFooterBadge (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
21	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
22	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
23	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 39)
25	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 60)
26	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
27	Shopware\Core\Profiling\Profiler::trace (line 38)
28	Shopware\Storefront\Page\GenericPageLoader->load (line 47)
29	Shopware\Storefront\Page\LandingPage\LandingPageLoader->load (line 31)
30	Shopware\Storefront\Controller\LandingPageController->index (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
33	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
34	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
35	Shopware\Core\Kernel->handle (line 86)
36	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
38	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
39	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
41	Shopware\Core\HttpKernel->doHandle (line 67)
42	Shopware\Core\HttpKernel->handle (line 63)
43	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
45	require_once (line 12)

0.77 ms
(1.39%)

SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"Õ¦´Â╣/L╔Ø8´l´\x03o="
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `media`.`id` as `media.id`,
  `media`.`user_id` as `media.userId`,
  `media`.`media_folder_id` as `media.mediaFolderId`,
  `media`.`mime_type` as `media.mimeType`,
  `media`.`file_extension` as `media.fileExtension`,
  `media`.`uploaded_at` as `media.uploadedAt`,
  `media`.`file_name` as `media.fileName`,
  `media`.`file_size` as `media.fileSize`,
  `media`.`media_type` as `media.mediaTypeRaw`,
  `media`.`meta_data` as `media.metaData`,
  `media`.`config` as `media.config`,
  `media`.`path` as `media.path`,
  `media`.`private` as `media.private`,
  `media`.`thumbnails_ro` as `media.thumbnailsRo`,
  `media`.`created_at` as `media.createdAt`,
  `media`.`updated_at` as `media.updatedAt`,
  `media.translation.title`,
  COALESCE(
    `media.translation.title`, `media.translation.title`
  ) as `media.title`,
  `media.translation.alt`,
  COALESCE(
    `media.translation.alt`, `media.translation.alt`
  ) as `media.alt`,
  `media.translation.customFields`,
  COALESCE(
    `media.translation.customFields`,
    `media.translation.customFields`
  ) as `media.customFields`,
  `media.translation.createdAt`,
  `media.translation.updatedAt`,
  `media.translation.mediaId`,
  `media.translation.languageId`
FROM
  `media`
  LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id`
  LEFT JOIN (
    SELECT
      `media.translation`.media_id,
      `media.translation`.title as `media.translation.title`,
      `media.translation`.alt as `media.translation.alt`,
      `media.translation`.custom_fields as `media.translation.customFields`,
      `media.translation`.created_at as `media.translation.createdAt`,
      `media.translation`.updated_at as `media.translation.updatedAt`,
      `media.translation`.media_id as `media.translation.mediaId`,
      `media.translation`.language_id as `media.translation.languageId`
    FROM
      `media_translation` `media.translation`
    WHERE
      `media.translation`.language_id = ?
  ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id`
  LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id`
WHERE
  (
    (
      (
        `media`.`private` = ?
        OR (
          `media`.`private` = ?
          AND `media.mediaFolder.defaultFolder`.`entity` = ?
        )
      )
    )
  )
  AND (
    `media`.`id` IN (?)
  )

SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = 0 OR (`media`.`private` = 1 AND `media.mediaFolder.defaultFolder`.`entity` = 'product_download')))) AND (`media`.`id` IN (0xE5DDEFB6B92F4CC99D38EF6CEF036F3D));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 40)
9	Shopware\Core\Framework\Adapter\Twig\Extension\MediaExtension->searchMedia (line 125)
10	__TwigTemplate_5de4a6ec467832c96b6246d38da97498->block_category_headline_box_block (line 171)
11	Twig\Template->displayBlock (line 46)
12	__TwigTemplate_5de4a6ec467832c96b6246d38da97498->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 109)
15	__TwigTemplate_5a37e74080931c591f3ebb74c5e30f87->block_block_category_box_first_inner (line 171)
16	Twig\Template->displayBlock (line 72)
17	__TwigTemplate_5a37e74080931c591f3ebb74c5e30f87->block_bisg_category_headlines_block (line 171)
18	Twig\Template->displayBlock (line 47)
19	__TwigTemplate_5a37e74080931c591f3ebb74c5e30f87->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 326)
22	__TwigTemplate_11f991fd96c7fc35362fa9b372fa42cf->block_section_content_block_row (line 171)
23	Twig\Template->displayBlock (line 134)
24	Twig\Template->displayParentBlock (line 564)
25	__TwigTemplate_0a291b05c6a2cc92c1134fca64fb805e->block_section_content_block_row (line 171)
26	Twig\Template->displayBlock (line 461)
27	__TwigTemplate_0a291b05c6a2cc92c1134fca64fb805e->block_section_content_block_container (line 171)
28	Twig\Template->displayBlock (line 213)
29	__TwigTemplate_11f991fd96c7fc35362fa9b372fa42cf->block_section_content_block (line 171)
30	Twig\Template->displayBlock (line 49)
31	__TwigTemplate_11f991fd96c7fc35362fa9b372fa42cf->doDisplay (line 394)
32	Twig\Template->displayWithErrorHandling (line 367)
33	Twig\Template->display (line 51)
34	__TwigTemplate_0a291b05c6a2cc92c1134fca64fb805e->doDisplay (line 394)
35	Twig\Template->displayWithErrorHandling (line 367)
36	Twig\Template->display (line 132)
37	__TwigTemplate_54fb665836d049b90a61ff28bc41e761->block_section_default_content_block (line 171)
38	Twig\Template->displayBlock (line 134)
39	Twig\Template->displayParentBlock (line 214)
40	__TwigTemplate_3321a96c3ee7bca26d7c53b600334d27->block_section_default_content_block (line 171)
41	Twig\Template->displayBlock (line 148)
42	__TwigTemplate_3321a96c3ee7bca26d7c53b600334d27->block_page_content_section_default (line 171)
43	Twig\Template->displayBlock (line 47)
44	__TwigTemplate_54fb665836d049b90a61ff28bc41e761->doDisplay (line 394)
45	Twig\Template->displayWithErrorHandling (line 367)
46	Twig\Template->display (line 51)
47	__TwigTemplate_3321a96c3ee7bca26d7c53b600334d27->doDisplay (line 394)
48	Twig\Template->displayWithErrorHandling (line 367)
49	Twig\Template->display (line 235)
50	__TwigTemplate_cd56db33a2af8aa53d0f8a8bb0424d29->block_page_content_section (line 171)
51	Twig\Template->displayBlock (line 134)
52	Twig\Template->displayParentBlock (line 76)
53	__TwigTemplate_40bd2342ba416523003688c0778bb932->block_page_content_section (line 171)
54	Twig\Template->displayBlock (line 134)
55	Twig\Template->displayParentBlock (line 436)
56	__TwigTemplate_1c0a80464fbe658d65459ed928d7d02e->block_page_content_section (line 171)
57	Twig\Template->displayBlock (line 171)
58	__TwigTemplate_cd56db33a2af8aa53d0f8a8bb0424d29->block_page_content_sections_inner (line 171)
59	Twig\Template->displayBlock (line 47)
60	__TwigTemplate_cd56db33a2af8aa53d0f8a8bb0424d29->doDisplay (line 394)
61	Twig\Template->displayWithErrorHandling (line 367)
62	Twig\Template->display (line 55)
63	__TwigTemplate_40bd2342ba416523003688c0778bb932->doDisplay (line 394)
64	Twig\Template->displayWithErrorHandling (line 367)
65	Twig\Template->display (line 50)
66	__TwigTemplate_1c0a80464fbe658d65459ed928d7d02e->doDisplay (line 394)
67	Twig\Template->displayWithErrorHandling (line 367)
68	Twig\Template->display (line 108)
69	__TwigTemplate_0fb3e41d1f17ff6050cc2e6fd727899d->block_page_content_blocks (line 171)
70	Twig\Template->displayBlock (line 84)
71	__TwigTemplate_0fb3e41d1f17ff6050cc2e6fd727899d->block_cms_content (line 171)
72	Twig\Template->displayBlock (line 106)
73	__TwigTemplate_cb60e4a1692deef59ac437b6b2a66828->block_page_content (line 171)
74	Twig\Template->displayBlock (line 77)
75	__TwigTemplate_cb60e4a1692deef59ac437b6b2a66828->block_base_main_inner (line 171)
76	Twig\Template->displayBlock (line 497)
77	__TwigTemplate_87dc8b08dbef6f2716adb08ac8375a87->block_base_main (line 171)
78	Twig\Template->displayBlock (line 276)
79	__TwigTemplate_87dc8b08dbef6f2716adb08ac8375a87->block_base_body_inner (line 171)
80	Twig\Template->displayBlock (line 186)
81	__TwigTemplate_87dc8b08dbef6f2716adb08ac8375a87->block_base_body (line 171)
82	Twig\Template->displayBlock (line 134)
83	Twig\Template->displayParentBlock (line 96)
84	__TwigTemplate_c2a1661035df2cd2ff60f85e227be5a3->block_base_body (line 171)
85	Twig\Template->displayBlock (line 191)
86	Twig\Template->displayBlock (line 191)
87	Twig\Template->displayBlock (line 191)
88	Twig\Template->displayBlock (line 191)
89	Twig\Template->displayBlock (line 134)
90	Twig\Template->displayParentBlock (line 85)
91	__TwigTemplate_e5be71e36bae3c92a043dc82f6042c52->block_base_body (line 171)
92	Twig\Template->displayBlock (line 90)
93	__TwigTemplate_87dc8b08dbef6f2716adb08ac8375a87->doDisplay (line 394)
94	Twig\Template->displayWithErrorHandling (line 367)
95	Twig\Template->display (line 52)
96	__TwigTemplate_c2a1661035df2cd2ff60f85e227be5a3->doDisplay (line 394)
97	Twig\Template->displayWithErrorHandling (line 367)
98	Twig\Template->display (line 50)
99	__TwigTemplate_94a26c8f0c3d009ab0b2d93ee138813c->doDisplay (line 394)
100	Twig\Template->displayWithErrorHandling (line 367)
101	Twig\Template->display (line 50)
102	__TwigTemplate_da06b07379863cc10b1cd0acbea80604->doDisplay (line 394)
103	Twig\Template->displayWithErrorHandling (line 367)
104	Twig\Template->display (line 52)
105	__TwigTemplate_c08d5426c1cfb2c32d49f85597f40044->doDisplay (line 394)
106	Twig\Template->displayWithErrorHandling (line 367)
107	Twig\Template->display (line 51)
108	__TwigTemplate_f7e049c45980821fa2a271b025f6d343->doDisplay (line 394)
109	Twig\Template->displayWithErrorHandling (line 367)
110	Twig\Template->display (line 51)
111	__TwigTemplate_e5be71e36bae3c92a043dc82f6042c52->doDisplay (line 394)
112	Twig\Template->displayWithErrorHandling (line 367)
113	Twig\Template->display (line 67)
114	__TwigTemplate_10d8f7377ed4e0cdcabff74e92333f8e->doDisplay (line 394)
115	Twig\Template->displayWithErrorHandling (line 367)
116	Twig\Template->display (line 52)
117	__TwigTemplate_2dcb4906798384177aae65f9ab5e91f0->doDisplay (line 394)
118	Twig\Template->displayWithErrorHandling (line 367)
119	Twig\Template->display (line 51)
120	__TwigTemplate_8dde08c341d9df3629a6979a98a82efb->doDisplay (line 394)
121	Twig\Template->displayWithErrorHandling (line 367)
122	Twig\Template->display (line 54)
123	__TwigTemplate_45048f99956c92f17dc2ceb22959fae0->doDisplay (line 394)
124	Twig\Template->displayWithErrorHandling (line 367)
125	Twig\Template->display (line 51)
126	__TwigTemplate_0575f77b9042f545560a25e9f3a72781->doDisplay (line 394)
127	Twig\Template->displayWithErrorHandling (line 367)
128	Twig\Template->display (line 51)
129	__TwigTemplate_9487d9e3977e9ecc6a0faa2c6904f709->doDisplay (line 394)
130	Twig\Template->displayWithErrorHandling (line 367)
131	Twig\Template->display (line 54)
132	__TwigTemplate_cb60e4a1692deef59ac437b6b2a66828->doDisplay (line 394)
133	Twig\Template->displayWithErrorHandling (line 367)
134	Twig\Template->display (line 55)
135	__TwigTemplate_cc06ea27274c97a8ef0a25a2f2fe6723->doDisplay (line 394)
136	Twig\Template->displayWithErrorHandling (line 367)
137	Twig\Template->display (line 51)
138	__TwigTemplate_0fb3e41d1f17ff6050cc2e6fd727899d->doDisplay (line 394)
139	Twig\Template->displayWithErrorHandling (line 367)
140	Twig\Template->display (line 379)
141	Twig\Template->render (line 38)
142	Twig\TemplateWrapper->render (line 280)
143	Twig\Environment->render (line 281)
144	Shopware\Storefront\Controller\StorefrontController->renderView (line 295)
145	Shopware\Storefront\Controller\StorefrontController->render (line 92)
146	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
147	Shopware\Core\Profiling\Profiler::trace (line 92)
148	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 35)
149	Shopware\Storefront\Controller\LandingPageController->index (line 181)
150	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
151	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
152	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
153	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
154	Shopware\Core\Kernel->handle (line 86)
155	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
156	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
157	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
158	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
159	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
160	Shopware\Core\HttpKernel->doHandle (line 67)
161	Shopware\Core\HttpKernel->handle (line 63)
162	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
163	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
164	require_once (line 12)

0.71 ms
(1.29%)

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

# dbal-plugin-loader
SELECT
  `name`,
  `base_class` AS baseClass,
  IF(
    `active` = 1
    AND `installed_at` IS NOT NULL,
    1,
    0
  ) AS active,
  `path`,
  `version`,
  `autoload`,
  `managed_by_composer` AS managedByComposer,
  composer_name as composerName
FROM
  `plugin`
ORDER BY
  `installed_at`;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 37)
2	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line 109)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 181)
4	Shopware\Core\Kernel->boot (line 119)
5	Shopware\Core\HttpKernel->doHandle (line 67)
6	Shopware\Core\HttpKernel->handle (line 63)
7	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 12)

0.70 ms
(1.28%)

SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC

Parameters:

[
  b"\x02a\f\x08ÑQN├ü\vb¦©!\x19Ã"
  "KlarnaPayment.settings.%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  configuration_key,
  configuration_value
FROM
  system_config
WHERE
  (
    sales_channel_id IS NULL
    OR sales_channel_id = ?
  )
  AND (configuration_key LIKE ?)
ORDER BY
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = 0x02610C08A5514EC3810B62DDB82119C7) AND (configuration_key LIKE 'KlarnaPayment.settings.%') ORDER BY sales_channel_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 184)
3	Shopware\Core\System\SystemConfig\SystemConfigService->getDomain (line 31)
4	KlarnaPayment\Components\ConfigReader\ConfigReader->read (line 39)
5	KlarnaPayment\Components\EventListener\FooterBadgeEventListener->addFooterBadge (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 39)
13	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 60)
14	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
15	Shopware\Core\Profiling\Profiler::trace (line 38)
16	Shopware\Storefront\Page\GenericPageLoader->load (line 47)
17	Shopware\Storefront\Page\LandingPage\LandingPageLoader->load (line 31)
18	Shopware\Storefront\Controller\LandingPageController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
23	Shopware\Core\Kernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
29	Shopware\Core\HttpKernel->doHandle (line 67)
30	Shopware\Core\HttpKernel->handle (line 63)
31	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 12)

0.64 ms
(1.16%)

SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.locale_id, `language.locale.translation`.name as `language.locale.translation.name`, `language.locale.translation`.territory as `language.locale.translation.territory`, `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.language_id = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `language`.`id` as `language.id`,
  `language`.`parent_id` as `language.parentId`,
  `language`.`locale_id` as `language.localeId`,
  `language`.`translation_code_id` as `language.translationCodeId`,
  `language`.`name` as `language.name`,
  `language`.`custom_fields` as `language.customFields`,
  `language`.`created_at` as `language.createdAt`,
  `language`.`updated_at` as `language.updatedAt`,
  `language.locale`.`id` as `language.locale.id`,
  `language.locale`.`code` as `language.locale.code`,
  `language.locale`.`created_at` as `language.locale.createdAt`,
  `language.locale`.`updated_at` as `language.locale.updatedAt`,
  `language.locale.translation.name`,
  COALESCE(
    `language.locale.translation.name`,
    `language.locale.translation.name`
  ) as `language.locale.name`,
  `language.locale.translation.territory`,
  COALESCE(
    `language.locale.translation.territory`,
    `language.locale.translation.territory`
  ) as `language.locale.territory`,
  `language.locale.translation.customFields`,
  COALESCE(
    `language.locale.translation.customFields`,
    `language.locale.translation.customFields`
  ) as `language.locale.customFields`,
  `language.locale.translation.createdAt`,
  `language.locale.translation.updatedAt`,
  `language.locale.translation.localeId`,
  `language.locale.translation.languageId`
FROM
  `language`
  LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id`
  LEFT JOIN (
    SELECT
      `language.locale.translation`.locale_id,
      `language.locale.translation`.name as `language.locale.translation.name`,
      `language.locale.translation`.territory as `language.locale.translation.territory`,
      `language.locale.translation`.custom_fields as `language.locale.translation.customFields`,
      `language.locale.translation`.created_at as `language.locale.translation.createdAt`,
      `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`,
      `language.locale.translation`.locale_id as `language.locale.translation.localeId`,
      `language.locale.translation`.language_id as `language.locale.translation.languageId`
    FROM
      `locale_translation` `language.locale.translation`
    WHERE
      `language.locale.translation`.language_id = ?
  ) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id`
WHERE
  `language`.`id` IN (?)

SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.locale_id, `language.locale.translation`.name as `language.locale.translation.name`, `language.locale.translation`.territory as `language.locale.translation.territory`, `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 256)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 58)
9	Swag\PayPal\Util\LocaleCodeProvider->getLocaleCodeFromContext (line 54)
10	Swag\PayPal\Storefront\Data\Service\AbstractScriptDataService->getButtonLanguage (line 40)
11	Swag\PayPal\Storefront\Data\Service\AbstractScriptDataService->getBaseData (line 39)
12	Swag\PayPal\Storefront\Data\Service\FundingEligibilityDataService->buildData (line 52)
13	Swag\PayPal\Storefront\Data\FundingSubscriber->addFundingAvailabilityData (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
17	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
18	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
19	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 39)
21	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 60)
22	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 38)
24	Shopware\Storefront\Page\GenericPageLoader->load (line 47)
25	Shopware\Storefront\Page\LandingPage\LandingPageLoader->load (line 31)
26	Shopware\Storefront\Controller\LandingPageController->index (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
31	Shopware\Core\Kernel->handle (line 86)
32	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
37	Shopware\Core\HttpKernel->doHandle (line 67)
38	Shopware\Core\HttpKernel->handle (line 63)
39	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 12)

0.58 ms
(1.06%)

SELECT 
 LOWER(HEX(product.id)) as __product_productId, LOWER(HEX(product.version_id)) as __product_versionId, product.id as __product_id, product.product_number as __product_productNumber, LOWER(HEX(product.active)) as __product_active, LOWER(HEX(parentProduct.id)) as __parentProduct_productId, LOWER(HEX(parentProduct.version_id)) as __parentProduct_versionId, parentProduct.id as __parentProduct_id, parentProduct.product_number as __parentProduct_productNumber, LOWER(HEX(parentProduct.active)) as __parentProduct_active
  FROM product 
  LEFT JOIN product parentProduct ON parentProduct.id = product.parent_id AND parentProduct.version_id = product.version_id 
  WHERE product.product_number = ?
  AND product.version_id = ?

Parameters:

[
  "TM-CO2-comp"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(product.id)
  ) as __product_productId,
  LOWER(
    HEX(product.version_id)
  ) as __product_versionId,
  product.id as __product_id,
  product.product_number as __product_productNumber,
  LOWER(
    HEX(product.active)
  ) as __product_active,
  LOWER(
    HEX(parentProduct.id)
  ) as __parentProduct_productId,
  LOWER(
    HEX(parentProduct.version_id)
  ) as __parentProduct_versionId,
  parentProduct.id as __parentProduct_id,
  parentProduct.product_number as __parentProduct_productNumber,
  LOWER(
    HEX(parentProduct.active)
  ) as __parentProduct_active
FROM
  product
  LEFT JOIN product parentProduct ON parentProduct.id = product.parent_id
  AND parentProduct.version_id = product.version_id
WHERE
  product.product_number = ?
  AND product.version_id = ?

SELECT 
 LOWER(HEX(product.id)) as __product_productId, LOWER(HEX(product.version_id)) as __product_versionId, product.id as __product_id, product.product_number as __product_productNumber, LOWER(HEX(product.active)) as __product_active, LOWER(HEX(parentProduct.id)) as __parentProduct_productId, LOWER(HEX(parentProduct.version_id)) as __parentProduct_versionId, parentProduct.id as __parentProduct_id, parentProduct.product_number as __parentProduct_productNumber, LOWER(HEX(parentProduct.active)) as __parentProduct_active
  FROM product 
  LEFT JOIN product parentProduct ON parentProduct.id = product.parent_id AND parentProduct.version_id = product.version_id 
  WHERE product.product_number = 'TM-CO2-comp'
  AND product.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 588)
2	Doctrine\DBAL\Connection->fetchAssociative (line 113)
3	Bisg\Overrides\Core\Checkout\Cart\Co2\Co2CompensationService->loadProductInfo (line 33)
4	Bisg\Overrides\Core\Checkout\Cart\Co2\Co2CompensationService->setProductActiveState (line 196)
5	Bisg\Overrides\Core\Checkout\Cart\Co2\Co2CompensationService->setArticleActive (line 76)
6	Bisg\Overrides\Core\Checkout\Cart\Co2\Subscriber\FeatureProductRestrictionSubscriber->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
18	Shopware\Core\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
24	Shopware\Core\HttpKernel->doHandle (line 67)
25	Shopware\Core\HttpKernel->handle (line 63)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

0.56 ms
(1.03%)

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?

Parameters:

[
  "payload"
]

View formatted query View runnable query Explain query View query backtrace

SHOW COLUMNS
FROM
  `cart`
WHERE
  `Field` LIKE ?

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 51)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityDefinitionQueryHelper::columnExists (line 161)
4	Shopware\Core\Checkout\Cart\CartPersister->payloadExists (line 43)
5	Shopware\Core\Checkout\Cart\CartPersister->load (line 55)
6	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
7	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 59)
9	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
10	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
11	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
15	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
16	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
17	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
23	Shopware\Core\Kernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
29	Shopware\Core\HttpKernel->doHandle (line 67)
30	Shopware\Core\HttpKernel->handle (line 63)
31	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 12)

0.55 ms
(1.01%)

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x02a\f\x08ÑQN├ü\vb¦©!\x19Ã"
  "kaffee-kaffeezubehoer-kaffeezubereitung"
]

View formatted query View runnable query Explain query View query backtrace

# seo-url::resolve
SELECT
  id,
  path_info pathInfo,
  is_canonical isCanonical,
  sales_channel_id salesChannelId
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
  AND (seo_path_info = ?)

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x02610C08A5514EC3810B62DDB82119C7 OR sales_channel_id IS NULL)) AND (seo_path_info = 'kaffee-kaffeezubehoer-kaffeezubereitung');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 48)
3	Shopware\Core\Content\Seo\SeoResolver->resolve (line 35)
4	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 325)
5	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 122)
6	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 126)
7	Shopware\Core\HttpKernel->doHandle (line 67)
8	Shopware\Core\HttpKernel->handle (line 63)
9	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 12)

0.54 ms
(0.98%)

SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `handler_identifier`,
  LOWER(
    HEX(`id`)
  )
FROM
  `payment_method`

SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 919)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 136)
3	Swag\PayPal\Util\PaymentMethodUtil->getPaymentMethodIdByHandler (line 55)
4	Swag\PayPal\Util\PaymentMethodUtil->getPayPalPaymentMethodId (line 63)
5	Swag\PayPal\Util\PaymentMethodUtil->isPaypalPaymentMethodInSalesChannel (line 130)
6	Swag\PayPal\Installment\Banner\InstallmentBannerSubscriber->addInstallmentBannerPagelet (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 39)
14	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 60)
15	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 38)
17	Shopware\Storefront\Page\GenericPageLoader->load (line 47)
18	Shopware\Storefront\Page\LandingPage\LandingPageLoader->load (line 31)
19	Shopware\Storefront\Controller\LandingPageController->index (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
24	Shopware\Core\Kernel->handle (line 86)
25	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
30	Shopware\Core\HttpKernel->doHandle (line 67)
31	Shopware\Core\HttpKernel->handle (line 63)
32	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 12)

0.52 ms
(0.96%)

SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `app`.`name`,
  `app`.`version`,
  `app`.`template_load_priority`
FROM
  `app`
  INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
WHERE
  `app`.`active` = 1
  AND `app_template`.`active` = 1

SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 937)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 66)
3	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->getAppTemplateNamespaces (line 43)
4	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->buildNamespaceHierarchy (line 31)
5	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 136)
6	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->getNamespaceHierarchy (line 57)
7	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->find (line 277)
8	Shopware\Storefront\Controller\StorefrontController->renderView (line 295)
9	Shopware\Storefront\Controller\StorefrontController->render (line 92)
10	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 92)
12	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 35)
13	Shopware\Storefront\Controller\LandingPageController->index (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
18	Shopware\Core\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
24	Shopware\Core\HttpKernel->doHandle (line 67)
25	Shopware\Core\HttpKernel->handle (line 63)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

0.51 ms
(0.93%)

SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`

Parameters:

[
  b"\x02a\f\x08ÑQN├ü\vb¦©!\x19Ã"
  b"É╣îW\x7F÷K╬®¤Y┤Çpîà"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `country`.`id`
FROM
  `country`
  LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`
  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`
WHERE
  (
    (`country.salesChannels`.`id` = ?)
  )
  AND (
    `country`.`id` IN (?)
  )
GROUP BY
  `country`.`id`

SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = 0x02610C08A5514EC3810B62DDB82119C7)) AND (`country`.`id` IN (0x90B98C577FF64BCEA9CF59B480708C85)) GROUP BY `country`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 45)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 93)
6	Shopware\Core\Checkout\Cart\Address\AddressValidator->isSalesChannelCountry (line 53)
7	Shopware\Core\Checkout\Cart\Address\AddressValidator->validate (line 25)
8	Shopware\Core\Checkout\Cart\Validator->validate (line 62)
9	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 34)
11	Shopware\Core\Checkout\Cart\Processor->process (line 105)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
13	Shopware\Core\Profiling\Profiler::trace (line 83)
14	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
15	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
16	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
17	Shopware\Core\Profiling\Profiler::trace (line 59)
18	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
19	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
20	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
24	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
25	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
26	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
30	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
32	Shopware\Core\Kernel->handle (line 86)
33	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
38	Shopware\Core\HttpKernel->doHandle (line 67)
39	Shopware\Core\HttpKernel->handle (line 63)
40	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 12)

0.51 ms
(0.92%)

SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = ? AND
                    pm.`active` = 1

Parameters:

[
  b"▒7Í6ÚÆO'ì┘\x07$▓╗A"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(assoc.`sales_channel_id`)
  )
FROM
  `sales_channel_payment_method` AS assoc
  LEFT JOIN `payment_method` AS pm ON pm.`id` = assoc.`payment_method_id`
WHERE
  assoc.`payment_method_id` = ?
  AND pm.`active` = 1

SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = 0xB137D636E9924F278DD90724B2F0BB41 AND
                    pm.`active` = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 953)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 79)
3	Swag\PayPal\Util\PaymentMethodUtil->isPaypalPaymentMethodInSalesChannel (line 130)
4	Swag\PayPal\Installment\Banner\InstallmentBannerSubscriber->addInstallmentBannerPagelet (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 39)
12	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 60)
13	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 38)
15	Shopware\Storefront\Page\GenericPageLoader->load (line 47)
16	Shopware\Storefront\Page\LandingPage\LandingPageLoader->load (line 31)
17	Shopware\Storefront\Controller\LandingPageController->index (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
22	Shopware\Core\Kernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
28	Shopware\Core\HttpKernel->doHandle (line 67)
29	Shopware\Core\HttpKernel->handle (line 63)
30	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 12)

0.51 ms
(0.92%)

SELECT `bisg_product_feature_type`.`id` as `bisg_product_feature_type.id`, `bisg_product_feature_type`.`name` as `bisg_product_feature_type.name`, `bisg_product_feature_type`.`custom_field_config` as `bisg_product_feature_type.customFieldConfig`, `bisg_product_feature_type`.`created_at` as `bisg_product_feature_type.createdAt`, `bisg_product_feature_type`.`updated_at` as `bisg_product_feature_type.updatedAt`, `bisg_product_feature_type.translation.label`, COALESCE(`bisg_product_feature_type.translation.label`,`bisg_product_feature_type.translation.label`) as `bisg_product_feature_type.label`, `bisg_product_feature_type.translation.description`, COALESCE(`bisg_product_feature_type.translation.description`,`bisg_product_feature_type.translation.description`) as `bisg_product_feature_type.description`, `bisg_product_feature_type.translation.createdAt`, `bisg_product_feature_type.translation.updatedAt`, `bisg_product_feature_type.translation.bisgProductFeatureTypeId`, `bisg_product_feature_type.translation.languageId` FROM `bisg_product_feature_type` LEFT JOIN (SELECT `bisg_product_feature_type.translation`.bisg_product_feature_type_id, `bisg_product_feature_type.translation`.label as `bisg_product_feature_type.translation.label`, `bisg_product_feature_type.translation`.description as `bisg_product_feature_type.translation.description`, `bisg_product_feature_type.translation`.created_at as `bisg_product_feature_type.translation.createdAt`, `bisg_product_feature_type.translation`.updated_at as `bisg_product_feature_type.translation.updatedAt`, `bisg_product_feature_type.translation`.bisg_product_feature_type_id as `bisg_product_feature_type.translation.bisgProductFeatureTypeId`, `bisg_product_feature_type.translation`.language_id as `bisg_product_feature_type.translation.languageId` FROM `bisg_product_feature_type_translation` `bisg_product_feature_type.translation` WHERE `bisg_product_feature_type.translation`.language_id = ?) `bisg_product_feature_type.bisg_product_feature_type_translation` ON `bisg_product_feature_type.bisg_product_feature_type_translation`.`bisg_product_feature_type_id` = `bisg_product_feature_type`.`id`

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `bisg_product_feature_type`.`id` as `bisg_product_feature_type.id`,
  `bisg_product_feature_type`.`name` as `bisg_product_feature_type.name`,
  `bisg_product_feature_type`.`custom_field_config` as `bisg_product_feature_type.customFieldConfig`,
  `bisg_product_feature_type`.`created_at` as `bisg_product_feature_type.createdAt`,
  `bisg_product_feature_type`.`updated_at` as `bisg_product_feature_type.updatedAt`,
  `bisg_product_feature_type.translation.label`,
  COALESCE(
    `bisg_product_feature_type.translation.label`,
    `bisg_product_feature_type.translation.label`
  ) as `bisg_product_feature_type.label`,
  `bisg_product_feature_type.translation.description`,
  COALESCE(
    `bisg_product_feature_type.translation.description`,
    `bisg_product_feature_type.translation.description`
  ) as `bisg_product_feature_type.description`,
  `bisg_product_feature_type.translation.createdAt`,
  `bisg_product_feature_type.translation.updatedAt`,
  `bisg_product_feature_type.translation.bisgProductFeatureTypeId`,
  `bisg_product_feature_type.translation.languageId`
FROM
  `bisg_product_feature_type`
  LEFT JOIN (
    SELECT
      `bisg_product_feature_type.translation`.bisg_product_feature_type_id,
      `bisg_product_feature_type.translation`.label as `bisg_product_feature_type.translation.label`,
      `bisg_product_feature_type.translation`.description as `bisg_product_feature_type.translation.description`,
      `bisg_product_feature_type.translation`.created_at as `bisg_product_feature_type.translation.createdAt`,
      `bisg_product_feature_type.translation`.updated_at as `bisg_product_feature_type.translation.updatedAt`,
      `bisg_product_feature_type.translation`.bisg_product_feature_type_id as `bisg_product_feature_type.translation.bisgProductFeatureTypeId`,
      `bisg_product_feature_type.translation`.language_id as `bisg_product_feature_type.translation.languageId`
    FROM
      `bisg_product_feature_type_translation` `bisg_product_feature_type.translation`
    WHERE
      `bisg_product_feature_type.translation`.language_id = ?
  ) `bisg_product_feature_type.bisg_product_feature_type_translation` ON `bisg_product_feature_type.bisg_product_feature_type_translation`.`bisg_product_feature_type_id` = `bisg_product_feature_type`.`id`

SELECT `bisg_product_feature_type`.`id` as `bisg_product_feature_type.id`, `bisg_product_feature_type`.`name` as `bisg_product_feature_type.name`, `bisg_product_feature_type`.`custom_field_config` as `bisg_product_feature_type.customFieldConfig`, `bisg_product_feature_type`.`created_at` as `bisg_product_feature_type.createdAt`, `bisg_product_feature_type`.`updated_at` as `bisg_product_feature_type.updatedAt`, `bisg_product_feature_type.translation.label`, COALESCE(`bisg_product_feature_type.translation.label`,`bisg_product_feature_type.translation.label`) as `bisg_product_feature_type.label`, `bisg_product_feature_type.translation.description`, COALESCE(`bisg_product_feature_type.translation.description`,`bisg_product_feature_type.translation.description`) as `bisg_product_feature_type.description`, `bisg_product_feature_type.translation.createdAt`, `bisg_product_feature_type.translation.updatedAt`, `bisg_product_feature_type.translation.bisgProductFeatureTypeId`, `bisg_product_feature_type.translation.languageId` FROM `bisg_product_feature_type` LEFT JOIN (SELECT `bisg_product_feature_type.translation`.bisg_product_feature_type_id, `bisg_product_feature_type.translation`.label as `bisg_product_feature_type.translation.label`, `bisg_product_feature_type.translation`.description as `bisg_product_feature_type.translation.description`, `bisg_product_feature_type.translation`.created_at as `bisg_product_feature_type.translation.createdAt`, `bisg_product_feature_type.translation`.updated_at as `bisg_product_feature_type.translation.updatedAt`, `bisg_product_feature_type.translation`.bisg_product_feature_type_id as `bisg_product_feature_type.translation.bisgProductFeatureTypeId`, `bisg_product_feature_type.translation`.language_id as `bisg_product_feature_type.translation.languageId` FROM `bisg_product_feature_type_translation` `bisg_product_feature_type.translation` WHERE `bisg_product_feature_type.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `bisg_product_feature_type.bisg_product_feature_type_translation` ON `bisg_product_feature_type.bisg_product_feature_type_translation`.`bisg_product_feature_type_id` = `bisg_product_feature_type`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 68)
9	Bisg\ProductFeatures\Core\Service\ProductFeatureTypeService->getFeatureTypes (line 79)
10	Bisg\ProductFeatures\Core\Request\RequestSubscriber->onRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
22	Shopware\Core\Kernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
28	Shopware\Core\HttpKernel->doHandle (line 67)
29	Shopware\Core\HttpKernel->handle (line 63)
30	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 12)

0.43 ms
(0.79%)

SELECT `bisg_warehouse`.`id` as `bisg_warehouse.id`, `bisg_warehouse`.`group_id` as `bisg_warehouse.groupId`, `bisg_warehouse`.`number` as `bisg_warehouse.number` FROM `bisg_warehouse` WHERE (`bisg_warehouse`.`group_id` <=> ? AND NOT (`bisg_warehouse`.`number` IN (?)))

Parameters:

[
  null
  "BKRPC5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `bisg_warehouse`.`id` as `bisg_warehouse.id`,
  `bisg_warehouse`.`group_id` as `bisg_warehouse.groupId`,
  `bisg_warehouse`.`number` as `bisg_warehouse.number`
FROM
  `bisg_warehouse`
WHERE
  (
    `bisg_warehouse`.`group_id` <=> ?
    AND NOT (
      `bisg_warehouse`.`number` IN (?)
    )
  )

SELECT `bisg_warehouse`.`id` as `bisg_warehouse.id`, `bisg_warehouse`.`group_id` as `bisg_warehouse.groupId`, `bisg_warehouse`.`number` as `bisg_warehouse.number` FROM `bisg_warehouse` WHERE (`bisg_warehouse`.`group_id` <=> NULL AND NOT (`bisg_warehouse`.`number` IN ('BKRPC5')));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 129)
9	Bisg\ProductInventory\Core\Content\Warehouse\Mapping\WarehouseGroupMappingService->processMissingMappings (line 121)
10	Bisg\ProductInventory\Core\Content\Warehouse\Mapping\WarehouseGroupMappingService->updateWarehouseGroupIds (line 59)
11	Bisg\ProductInventory\Core\Content\Warehouse\Mapping\WarehouseGroupMappingUpdater->onKernelRequest (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
15	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
16	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
17	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
23	Shopware\Core\Kernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
29	Shopware\Core\HttpKernel->doHandle (line 67)
30	Shopware\Core\HttpKernel->handle (line 63)
31	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 12)

0.43 ms
(0.78%)

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  custom_entity.name,
  custom_entity.fields,
  custom_entity.flags
FROM
  custom_entity
  LEFT JOIN app ON app.id = custom_entity.app_id
WHERE
  (
    custom_entity.app_id IS NULL
    OR app.active = 1
  )
  AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 35)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 63)
4	Shopware\Core\System\System->boot (line 211)
5	Shopware\Core\Kernel->boot (line 119)
6	Shopware\Core\HttpKernel->doHandle (line 67)
7	Shopware\Core\HttpKernel->handle (line 63)
8	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 12)

0.38 ms
(0.68%)

SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  b"\x01Å\x14tÜÃvLò\x02\v\vÝ╚Å¤"
  b"\x01É£¼of|y┐¦\x11½§oRï"
  b"""
    'g\n
    \x10ØÙFü¾„ZÃŽòâc
    """
  b"3G}j™'Bæ§__|D\x02¦÷"
  b"üÀùòÇÃAÒñé\x07=µ¢Ð┼"
  b"■Ð@¤¤´N│É\x03╩ıº\x02D\"
  b"""
    \x01ô\eÜUìv¥ê£\x04©\n
    °j¦
    """
  b"\x06Ó&¦A_OÊª3\x12ì|▄\e┴"
  b"F-ø‘S\x10DÅ‘8Ò'Ïý~Ù"
  b"Ÿ£ê\x1C¨\x03\x11"4+L,ƒ\x02½\x10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `rule`.`id` as `rule.id`,
  `rule`.`name` as `rule.name`,
  `rule`.`priority` as `rule.priority`,
  `rule`.`description` as `rule.description`,
  `rule`.`payload` as `rule.payload`,
  `rule`.`invalid` as `rule.invalid`,
  `rule`.`areas` as `rule.areas`,
  `rule`.`custom_fields` as `rule.customFields`,
  `rule`.`module_types` as `rule.moduleTypes`,
  `rule`.`created_at` as `rule.createdAt`,
  `rule`.`updated_at` as `rule.updatedAt`
FROM
  `rule`
WHERE
  `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (0x018F14749AC7764C95020B0BEDC88FCF, 0x01909CAC6F667C79BFDD11ABF56F528B, 0x27670A10D8D946FCBE845AC38EF2E263, 0x33477D6A992742E6A75F5F7C4402A6F7, 0x81B7979580C741E3A482073DE6BDD1C5, 0xFED140CFCFEF4EB39003CAD5A702445C, 0x01931B9A558D76BE889C04B80AF86ADD, 0x06E026DD415F4FD2A633128D7CDC1BC1, 0x462DF891531044C59138D227CFFD7ED9, 0x9FA3EA1CA8031122342B4C2C8302BD10);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 90)
9	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->getMatchingRules (line 66)
10	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->collect (line 169)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 108)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
20	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
25	Shopware\Core\Kernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
31	Shopware\Core\HttpKernel->doHandle (line 67)
32	Shopware\Core\HttpKernel->handle (line 63)
33	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 12)

0.35 ms
(0.64%)

SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `name`,
  `path`,
  `author`
FROM
  `app`
WHERE
  `active` = 1

SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 61)
3	Shopware\Core\Framework\App\ActiveAppsLoader->loadApps (line 43)
4	Shopware\Core\Framework\App\ActiveAppsLoader->getActiveApps (line 280)
5	Shopware\Storefront\Framework\Routing\StorefrontSubscriber->addShopIdParameter (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 84)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 35)
14	Shopware\Storefront\Controller\LandingPageController->index (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
19	Shopware\Core\Kernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
25	Shopware\Core\HttpKernel->doHandle (line 67)
26	Shopware\Core\HttpKernel->handle (line 63)
27	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 12)

0.28 ms
(0.52%)

SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?

Parameters:

[
  b"\x01è ì×3s╚ô¼ïx\x13Lp§"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `acl_role`.`privileges` AS `privileges`
FROM
  `acl_role`
  INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE
  `app`.`id` = ?

SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = 0x018AFF8D9E3373C893AC8B78134C70F5
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 65)
3	Shopware\Core\Framework\DataAbstractionLayer\Facade\AppContextCreator->fetchPrivileges (line 55)
4	Shopware\Core\Framework\DataAbstractionLayer\Facade\AppContextCreator->getAppContextSource (line 37)
5	Shopware\Core\Framework\DataAbstractionLayer\Facade\AppContextCreator->getAppContext (line 36)
6	Shopware\Core\Framework\DataAbstractionLayer\Facade\RepositoryFacadeHookFactory->factory (line 174)
7	Shopware\Core\Framework\Script\Execution\ScriptExecutor->initServices (line 92)
8	Shopware\Core\Framework\Script\Execution\ScriptExecutor->render (line 72)
9	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 311)
10	Shopware\Storefront\Controller\StorefrontController->hook (line 33)
11	Shopware\Storefront\Controller\LandingPageController->index (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
14	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
15	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
16	Shopware\Core\Kernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
22	Shopware\Core\HttpKernel->doHandle (line 67)
23	Shopware\Core\HttpKernel->handle (line 63)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 12)

0.26 ms
(0.48%)

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1

Parameters:

[
  b"\x02a\f\x08ÑQN├ü\vb¦©!\x19Ã"
  "xdABohClrfVN0XVedfGzKqLB8GbbB56h"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  sales_channel_api_context
WHERE
  (sales_channel_id = ?)
  AND (token = ?)
LIMIT
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x02610C08A5514EC3810B62DDB82119C7) AND (token = 'xdABohClrfVN0XVedfGzKqLB8GbbB56h') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 130)
3	Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister->load (line 62)
4	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 59)
6	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
19	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
20	Shopware\Core\Kernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
26	Shopware\Core\HttpKernel->doHandle (line 67)
27	Shopware\Core\HttpKernel->handle (line 63)
28	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 12)

0.21 ms
(0.37%)

#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?

Parameters:

[
  "xdABohClrfVN0XVedfGzKqLB8GbbB56h"
]

View formatted query View runnable query Explain query View query backtrace

#cart-persister::load
SELECT
  `cart`.`payload`,
  `cart`.`rule_ids`,
  `cart`.`compressed`
FROM
  cart
WHERE
  `token` = ?

#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = 'xdABohClrfVN0XVedfGzKqLB8GbbB56h';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 588)
2	Doctrine\DBAL\Connection->fetchAssociative (line 44)
3	Shopware\Core\Checkout\Cart\CartPersister->load (line 55)
4	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
5	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
6	Shopware\Core\Profiling\Profiler::trace (line 59)
7	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
8	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
21	Shopware\Core\Kernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
27	Shopware\Core\HttpKernel->doHandle (line 67)
28	Shopware\Core\HttpKernel->handle (line 63)
29	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 12)

0.20 ms
(0.37%)

SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `language`.`id`
FROM
  `language`
WHERE
  `language`.`id` IN (?)
LIMIT
  1

SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 45)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 245)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 58)
8	Swag\PayPal\Util\LocaleCodeProvider->getLocaleCodeFromContext (line 54)
9	Swag\PayPal\Storefront\Data\Service\AbstractScriptDataService->getButtonLanguage (line 40)
10	Swag\PayPal\Storefront\Data\Service\AbstractScriptDataService->getBaseData (line 39)
11	Swag\PayPal\Storefront\Data\Service\FundingEligibilityDataService->buildData (line 52)
12	Swag\PayPal\Storefront\Data\FundingSubscriber->addFundingAvailabilityData (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 39)
20	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 60)
21	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
22	Shopware\Core\Profiling\Profiler::trace (line 38)
23	Shopware\Storefront\Page\GenericPageLoader->load (line 47)
24	Shopware\Storefront\Page\LandingPage\LandingPageLoader->load (line 31)
25	Shopware\Storefront\Controller\LandingPageController->index (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
28	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
30	Shopware\Core\Kernel->handle (line 86)
31	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
36	Shopware\Core\HttpKernel->doHandle (line 67)
37	Shopware\Core\HttpKernel->handle (line 63)
38	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 12)

0.19 ms
(0.35%)

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?

Parameters:

[
  "de-DE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(id)
  )
FROM
  snippet_set
WHERE
  iso = ?

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = 'de-DE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 953)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 265)
3	Shopware\Core\Framework\Adapter\Translation\Translator->getSnippetSetId (line 312)
4	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalog (line 134)
5	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 156)
6	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 45)
7	Symfony\Component\Translation\DataCollectorTranslator->trans (line 125)
8	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 306)
9	__TwigTemplate_87dc8b08dbef6f2716adb08ac8375a87->block_base_noscript (line 171)
10	Twig\Template->displayBlock (line 191)
11	Twig\Template->displayBlock (line 191)
12	Twig\Template->displayBlock (line 191)
13	Twig\Template->displayBlock (line 191)
14	Twig\Template->displayBlock (line 191)
15	Twig\Template->displayBlock (line 191)
16	Twig\Template->displayBlock (line 191)
17	Twig\Template->displayBlock (line 191)
18	Twig\Template->displayBlock (line 191)
19	Twig\Template->displayBlock (line 134)
20	Twig\Template->displayParentBlock (line 80)
21	__TwigTemplate_45048f99956c92f17dc2ceb22959fae0->block_base_noscript (line 171)
22	Twig\Template->displayBlock (line 256)
23	__TwigTemplate_87dc8b08dbef6f2716adb08ac8375a87->block_base_body_inner (line 171)
24	Twig\Template->displayBlock (line 186)
25	__TwigTemplate_87dc8b08dbef6f2716adb08ac8375a87->block_base_body (line 171)
26	Twig\Template->displayBlock (line 134)
27	Twig\Template->displayParentBlock (line 96)
28	__TwigTemplate_c2a1661035df2cd2ff60f85e227be5a3->block_base_body (line 171)
29	Twig\Template->displayBlock (line 191)
30	Twig\Template->displayBlock (line 191)
31	Twig\Template->displayBlock (line 191)
32	Twig\Template->displayBlock (line 191)
33	Twig\Template->displayBlock (line 134)
34	Twig\Template->displayParentBlock (line 85)
35	__TwigTemplate_e5be71e36bae3c92a043dc82f6042c52->block_base_body (line 171)
36	Twig\Template->displayBlock (line 90)
37	__TwigTemplate_87dc8b08dbef6f2716adb08ac8375a87->doDisplay (line 394)
38	Twig\Template->displayWithErrorHandling (line 367)
39	Twig\Template->display (line 52)
40	__TwigTemplate_c2a1661035df2cd2ff60f85e227be5a3->doDisplay (line 394)
41	Twig\Template->displayWithErrorHandling (line 367)
42	Twig\Template->display (line 50)
43	__TwigTemplate_94a26c8f0c3d009ab0b2d93ee138813c->doDisplay (line 394)
44	Twig\Template->displayWithErrorHandling (line 367)
45	Twig\Template->display (line 50)
46	__TwigTemplate_da06b07379863cc10b1cd0acbea80604->doDisplay (line 394)
47	Twig\Template->displayWithErrorHandling (line 367)
48	Twig\Template->display (line 52)
49	__TwigTemplate_c08d5426c1cfb2c32d49f85597f40044->doDisplay (line 394)
50	Twig\Template->displayWithErrorHandling (line 367)
51	Twig\Template->display (line 51)
52	__TwigTemplate_f7e049c45980821fa2a271b025f6d343->doDisplay (line 394)
53	Twig\Template->displayWithErrorHandling (line 367)
54	Twig\Template->display (line 51)
55	__TwigTemplate_e5be71e36bae3c92a043dc82f6042c52->doDisplay (line 394)
56	Twig\Template->displayWithErrorHandling (line 367)
57	Twig\Template->display (line 67)
58	__TwigTemplate_10d8f7377ed4e0cdcabff74e92333f8e->doDisplay (line 394)
59	Twig\Template->displayWithErrorHandling (line 367)
60	Twig\Template->display (line 52)
61	__TwigTemplate_2dcb4906798384177aae65f9ab5e91f0->doDisplay (line 394)
62	Twig\Template->displayWithErrorHandling (line 367)
63	Twig\Template->display (line 51)
64	__TwigTemplate_8dde08c341d9df3629a6979a98a82efb->doDisplay (line 394)
65	Twig\Template->displayWithErrorHandling (line 367)
66	Twig\Template->display (line 54)
67	__TwigTemplate_45048f99956c92f17dc2ceb22959fae0->doDisplay (line 394)
68	Twig\Template->displayWithErrorHandling (line 367)
69	Twig\Template->display (line 51)
70	__TwigTemplate_0575f77b9042f545560a25e9f3a72781->doDisplay (line 394)
71	Twig\Template->displayWithErrorHandling (line 367)
72	Twig\Template->display (line 51)
73	__TwigTemplate_9487d9e3977e9ecc6a0faa2c6904f709->doDisplay (line 394)
74	Twig\Template->displayWithErrorHandling (line 367)
75	Twig\Template->display (line 54)
76	__TwigTemplate_cb60e4a1692deef59ac437b6b2a66828->doDisplay (line 394)
77	Twig\Template->displayWithErrorHandling (line 367)
78	Twig\Template->display (line 55)
79	__TwigTemplate_cc06ea27274c97a8ef0a25a2f2fe6723->doDisplay (line 394)
80	Twig\Template->displayWithErrorHandling (line 367)
81	Twig\Template->display (line 51)
82	__TwigTemplate_0fb3e41d1f17ff6050cc2e6fd727899d->doDisplay (line 394)
83	Twig\Template->displayWithErrorHandling (line 367)
84	Twig\Template->display (line 379)
85	Twig\Template->render (line 38)
86	Twig\TemplateWrapper->render (line 280)
87	Twig\Environment->render (line 281)
88	Shopware\Storefront\Controller\StorefrontController->renderView (line 295)
89	Shopware\Storefront\Controller\StorefrontController->render (line 92)
90	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
91	Shopware\Core\Profiling\Profiler::trace (line 92)
92	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 35)
93	Shopware\Storefront\Controller\LandingPageController->index (line 181)
94	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
95	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
96	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
97	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
98	Shopware\Core\Kernel->handle (line 86)
99	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
100	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
101	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
102	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
103	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
104	Shopware\Core\HttpKernel->doHandle (line 67)
105	Shopware\Core\HttpKernel->handle (line 63)
106	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
107	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
108	require_once (line 12)

0.19 ms
(0.35%)

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `name`,
  `type`
FROM
  `custom_field`
WHERE
  `active` = 1

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 919)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 82)
3	Shopware\Core\System\CustomField\CustomFieldService->getCustomFields (line 40)
4	Shopware\Core\System\CustomField\CustomFieldService->getCustomField (line 101)
5	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->getFields (line 86)
6	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->decode (line 389)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->customFields (line 243)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateFields (line 169)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->assign (line 562)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateEntity (line 88)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrate (line 133)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 670)
13	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyOverExtension (line 339)
14	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1214)
15	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
16	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
17	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 212)
18	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
19	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
20	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 139)
21	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->getSalesChannel (line 109)
22	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->testPaymentMethodExistence (line 52)
23	KlarnaPayment\Components\Helper\PaymentHelper\PaymentHelper->isKlarnaCheckoutEnabled (line 67)
24	KlarnaPayment\Components\EventListener\FooterBadgeEventListener->displayKlarnaCheckoutBadge (line 41)
25	KlarnaPayment\Components\EventListener\FooterBadgeEventListener->addFooterBadge (line 116)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
29	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
30	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
31	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 39)
33	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 60)
34	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
35	Shopware\Core\Profiling\Profiler::trace (line 38)
36	Shopware\Storefront\Page\GenericPageLoader->load (line 47)
37	Shopware\Storefront\Page\LandingPage\LandingPageLoader->load (line 31)
38	Shopware\Storefront\Controller\LandingPageController->index (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
41	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
42	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 157)
43	Shopware\Core\Kernel->handle (line 86)
44	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 473)
45	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 448)
46	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 346)
47	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 221)
48	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 146)
49	Shopware\Core\HttpKernel->doHandle (line 67)
50	Shopware\Core\HttpKernel->handle (line 63)
51	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
52	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
53	require_once (line 12)

0.10 ms
(0.19%)

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  @@group_concat_max_len = CAST(
    IF(
      @@group_concat_max_len > 320000, @@group_concat_max_len,
      320000
    ) AS UNSIGNED
  );
SET
  sql_mode =(
    SELECT
      REPLACE(
        @@sql_mode, 'ONLY_FULL_GROUP_BY',
        ''
      )
  )

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 392)
2	Shopware\Core\Kernel->initializeDatabaseConnectionVariables (line 214)
3	Shopware\Core\Kernel->boot (line 119)
4	Shopware\Core\HttpKernel->doHandle (line 67)
5	Shopware\Core\HttpKernel->handle (line 63)
6	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/vhosts/staging.berliner-kaffeeroesterei.de/httpdocs/public/index.php:53$13a->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 12)

Database Connections

Name	Service
0	default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

GET https://staging.berliner-kaffeeroesterei.de/landingPage/0190307e217c7fc892e45b7ec067d6b5

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache