Symfony Profiler

Query Metrics

19 Database Queries

19 Different statements

4.78 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

0.64 ms
(13.48%)

# 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 40)
2	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line 115)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 181)
4	Shopware\Core\Kernel->boot (line 153)
5	Shopware\Core\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 15)

0.46 ms
(9.72%)

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC

Parameters:

[]

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
ORDER BY
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 47)
3	Shopware\Core\System\SystemConfig\SystemConfigLoader->load (line 34)
4	Shopware\Core\System\SystemConfig\CachedSystemConfigLoader->Shopware\Core\System\SystemConfig\{closure} (line 64)
5	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 30)
6	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 33)
7	Shopware\Core\System\SystemConfig\CachedSystemConfigLoader->load (line 29)
8	Shopware\Core\System\SystemConfig\ConfiguredSystemConfigLoader->load (line 33)
9	Shopware\Core\System\SystemConfig\MemoizedSystemConfigLoader->load (line 87)
10	Shopware\Core\System\SystemConfig\SystemConfigService->get (line 32)
11	Shopware\Core\Framework\Routing\CanonicalRedirectService->getRedirect (line 62)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
19	Shopware\Core\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 15)

0.40 ms
(8.36%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 61)
3	Shopware\Core\Framework\App\ActiveAppsLoader->loadApps (line 44)
4	Shopware\Core\Framework\App\ActiveAppsLoader->getActiveApps (line 25)
5	Shopware\Core\Framework\App\Source\NoDatabaseSourceResolver->__construct (line 29246)
6	ContainerCnwMAmg\Shopware_Core_KernelDevDebugContainer::getSourceResolverService (line 34567)
7	ContainerCnwMAmg\Shopware_Core_KernelDevDebugContainer::getStorefrontPluginConfigurationFactoryService (line 10342)
8	ContainerCnwMAmg\Shopware_Core_KernelDevDebugContainer::getStorefrontPluginRegistryService (line 34981)
9	ContainerCnwMAmg\Shopware_Core_KernelDevDebugContainer::getThemeNamespaceHierarchyBuilderService (line 12861)
10	ContainerCnwMAmg\Shopware_Core_KernelDevDebugContainer::ContainerCnwMAmg\{closure} (line 221)
11	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
12	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 89)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->getListeners (line 71)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->getListeners (line 64)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->getListeners (line 252)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 15)

0.39 ms
(8.16%)

SELECT 1 as `exists`, `id` FROM `customer_address` WHERE `id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Parameters:

[
  b"²7ô*dŽBU¹`'Ž94.è"
  b"s„\fŒüVAY–}ë\x18\x06P¥)"
  b">ð`…\t²MÝ®÷.µ¥OÑ\n"
  b"ÃI2p\x1CÙC■ôÅç\x1F»\x0F®é"
  b"╩Å.èôxN/öJòG<ßô╔"
  b"mý@:ò%IÌ©ç£–…©ž¼"
  b"õöSŒ1rC\x05°\x05dÓiéAE"
  b"¿ÔÉC.÷I#Â]¤O\x1DÌ£"
  b"‘)\x05rë²B¿ˆ\x08Ÿ÷\x01’Ýx"
  b"¦ƒowøâE\x14’{}º–ÿ}\x06"
  b"_äëÎmF”ˆ&\x1Cažàòá"
  b"â›\x7FÌ\x074KëŸ\x05v¼Ÿ‚Yþ"
  b"\x00õ„æÿ÷C‹ƒä(\x0E™ö=\x11"
  b"K^S*a£@¸—r:cÈÊ”\x16"
  b"#|¥ç¾}L^³˜ÅâL»,§"
  b"Ð-¸ñÅsF6ë®í'Ï\x1D«'"
  b"\x1FTh°¤*OO‡¡Íj¬oÅ^"
  b"º┌¾ÐsÉJ+▓ÞMþ·÷«m"
  b"×\r¥tDùJÜ†T7„U¯m—"
  b"ÜË¸î!‗Hì¿¿¬já\x16‗¯"
  b"3`zí-ÆJ<¼Ê=\x00ACKŠ"
  b"█\x1Cìà\x01UM\x05ØÉ)ã\x187º;"
  b"K\x07™š\x146DØ¼AŸŒ]ïù«"
  b"ð’Œì\x04\vBY³&5³Ë‚\x05à"
  b"^\x18û}\x0F╩H×╗1üYp«â_"
  b"""
    \n
    \x1Esäû\x10J*Ø s²\x08\fð§
    """
  b"éÅGÙËçGÎªz█]ô\x00╣«"
  b"¿W‹(\E¶‰&™ªŠõ•R"
  b"–Ðx/IK¸½\x1C,yDò`µ"
  b"\x15í┴■Í C:öü´,S\e\x1D╬"
  b"a1S %<HÑ‹å\x16°Ò6`ô"
  b"Û\fƒ\x1A¥Õ@¨µ1\x03kD|\t’"
  b"ƒÌ×&YÌNõŸQÌ$Á)8\x03"
  b"u‰+S\x7F°Du‰ežbê@Œê"
  b"""
    \rÆ\fÊ\x13\n
    H®²FÁy4¦{É
    """
  b"«§%>X\x05C·¬■y¸KªNØ"
  b"ÆpÔ¤'bF–“ÔÉé7%õ°"
  b"(û–îë>G£²‰vé3Ý+‰"
  b"þÖ¨žÈjC¼²í|‘\vÆå9"
  b"ÜÉ)á▀rHPèÀÄ|d'\x00¶"
  b"ì┼\x1C\x00ÞaDFèlU1]■Ê‗"
  b"P\rfHrÍEU¹ò^\x00d÷\x1E»"
  b"¤ku\x17&ÆBF„v\x1Fî%ˆÁ\x7F"
  b"""
    D¤ã-»/JUŠ\x0Fx\x1C}\x1F\n
    Ü
    """
  b"UL¶g\ÄI<ŽA_fm\x1Dñ²"
  b"˜–Ä˜íwLú¼ûD‡4øÁœ"
  b"""
    ¨\x01ä£ö\x1FL¡œ‡¤#âÝ\n
    $
    """
  b":(À?\x1AAL▓ä╝É6tûN╗"
  b"ÕæÄ²àzGW¤\fò–¼¸¶!"
  b"\x01¼3\x08Ó*Mj‹‚øb¢7Í+"
  b"í\t°L=ÍL\x11¥\x1A]]‘Þ\x1Fc"
  b"Å½%\x7Fr]IÉ\x1A\vÖ\x07q`┼"
  b"R´}á¸VBþ¿G\x14€\x01¶úL"
  b"êg\x16\x00\x08Í@ï¤ÿ,¨\x10}ò\x05"
  b"ƒt\x13FnˆGû¦>ÆJQ™IP"
  b"\x15│\x1CÅ└\x12Iíé*Û\x19ÀU2\f"
  b"""
    ó´j┘¨~M\x18úäü¢\x17\n
    >þ
    """
  b"ý\x10²\btLb¦\vŠ\x1A¢Câ¡"
  b"®9¤Å&lEm¢ ┴|^\e¨@"
  b" \x13ÿ7÷3BÈ¸èþüx\x12\x0F="
  b"ÆžDÑÊ`JBˆ\x1Dv\x04–æ’§"
  b"""
    ñÖØ\x06“bE ¥/‹ah¸\n
    ¹
    """
  b"¹¼\x1F6tµLí–\x08,ûEHÑ„"
  b"ÂÍk3ùÅ@(ˆ>Ä\x1D31ÀÌ"
  b"ð-eºé\x08O_ŸÞÛ\r\x16\x17r3"
  b"╗Ì╔°&)AÅ┤ù7#üØ$ "
  b"]\x0EÂz\x15³Më—#\x1CÚ×ÿÂ¦"
  b"Æ¾—žŽ\x07B\’¦§\x0Eà\rq\"
  b"ò!y*ÿ½@bìÂx¬ØÊÁë"
  b"ì\v–Îà|HÅ”\eþ¶ÂïF5"
  b"\x0E\x14ÀÍ_mO\x0E”ìj\x1A”\x1E˜‡"
  b"¾Š\r\x16ºœKÿ¬r6YÞ®\x1D\v"
  b"pÑ«°¥$Cf±\x07#ñl‚!ü"
  b"1…sÜ\f)E\f†\x13·îr'{"
  b"\x04\x10K \x1EÖB╠®Ë\vZ>LìF"
  b"{ÞÐDþ'GµÉ¹[█9░\x06Ó"
  b"NôŠ\x1F\rUNa°ÿ\x016ä"šd"
  b"‹BÄ\x03!ŒG«Ÿ\x14Ó±1Æx¾"
  b"\x1A2f$\x0EÉI´íÔ;ù\x12[\x05ò"
  b"H–È2\x13½N¤ªÝc)\x19\x04J©"
  b"¾c\x1DÑ\x0F…G\x14œ¼®\x08»KÊ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 as `exists`,
  `id`
FROM
  `customer_address`
WHERE
  `id` IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT 1 as `exists`, `id` FROM `customer_address` WHERE `id` IN (0xB237F42A648E4255B960278E39342EE8,0x73840C8CFC564159967DEB180650A529,0x3EF0608509B24DDDAEF72EB5A54FD10A,0xC74932701CEB43FE938F871FAF0FA982,0xCA8F2E8A93784E2F944A95473CE193C9,0x6DFD403AF22549CCA9E7A39685A99EBC,0xF5F6538C31724305B00564D369E94145,0xA8E290432EF64923B65DF0CF4F1DDE9C,0x91290572EBB242BF88089FF70192DD78,0xA6836F77F8E24514927B7DBA96FF7D06,0x5FE4EBADCE6D469488261C619EE0F2E1,0xE29B7FCC07344BEB9F0576BC9F8259FE,0x00F584E6FFF7438B83E4280E99F63D11,0x4B5E532A61A340B897723A63C8CA9416,0x237CA5E7BE7D4C5EB398C5E24CBB2CA7,0xD12DF7A48F73463689A9A127D81DAE27,0x1F5468B0A42A4F4F87A1CD6AAC6FC55E,0xA7DAF3D173904A2BB2E84DE7FAF6AE6D,0xD70DA57444F94ADC8654378455AF6D97,0x9AD3F78C21F2488DA8A8AA6AA016F2EE,0x33607AED2DC64A3CBCCA3D0041434B8A,0xDB1C8D8501554D059D9029C61837A73B,0x4B07999A143644D8BC419F8C5DEFF9AB,0xF0928CEC040B4259B32635B3CB8205E0,0x5E18967D0FCA489EBB31815970AE835F,0x0A1E738496104A2A9DFF73FD080CD0F5,0x828F47EBD38747D7A67ADB5D9300B9AE,0xBF578B285CAD45B6892699AA8AF59552,0x96D0AD782F494BB8BD1C2C7944F260B5,0x15A1C1FED620433A9481EF2C531B1DCE,0x613153A0253C48D18BE516B0D23660F4,0xDB0C831AA5D540A8B531036B447C0992,0x83CCD72659CC4EF59F51CC24C1293803,0x75892B537FB0447589659E62EA408CEA,0x0DC60CCA130A48AEB246C17934A67BC9,0xAEF5253E580543FAAAFE79F74BA64E9D,0xC670D4A42762469693D4C9E93725F5B0,0x28FB96EEEB3E47A3B28976E933DD2B89,0xFED6A89EC86A43BCB2ED7C910BC6E539,0x9A9029A0DF7248508AB78E7C642700F4,0x8DC51C00E86144468A6C55315DFED2F2,0x500D664872CD4555B9F25E0064F71EBB,0xA46B751726C6424684761FEE2588C17F,0x44A4E32DBB2F4A558A0F781C7D1F0ADC,0x554CB6675CC4493C8E415F666D1DF1B2,0x9896C498ED774CFABCFB448734F8C19C,0xA801E4A3F61F4CA19C87A423E2DD0A24,0x3A28B73F1A414CB284BC903674964EBB,0xD5E6C4B2E07A4757A40CF296BCB8B621,0x01BC3308D32A4D6A8B82F862A237CD2B,0xED09B04C3DCD4C11A51A5D5D91DE1F63,0x8FAB257F725D49F0901A0B99077160C5,0x52B47DE1B85642FEBF47148001B6FA4C,0xEA67160008CD40EFA4FF2CA8107DF205,0x837413466E8847FBA63EC64A51994950,0x15B31C8FC01249A1822AEA19B755320C,0xA2EF6AD9F97E4D18A38481BD170A3EE7,0xFD10B25C62744C62A60B8A1AA243E2A1,0xA939CF8F266C456DBD20C17C5E1BF940,0xA013FF37F73342C8B8E8FEFC78120F3D,0xC69E44D1CA604A42881D760496E692A7,0xF1D6D806936245A0A52F8B6168B80AB9,0xB9BC1F3674B54CED96082CFB4548D184,0xC2CD6B33F9C54028883EC41D3331C0CC,0xF02D65BAE9084F5F9FDEDB0D16177233,0xBBDEC9F82629418FB4973723819D24FF,0x5D0EC27A15B34DEB97231CDAD7FFC2A6,0xC6BE979E8E07425C92A6A70EE00D715C,0x9521792A98AB40628DB678AA9DD2B589,0xEC0B96CEE07C48C5941BFEB6C2EF4635,0x0E14C0CD5F6D4F0E94EC6A1A941E9887,0xBE8A0D16BA9C4BFFAC723659DEAE1D0B,0x70D1ABB0A5244366B10723F16C8221FC,0x318573DC0C29450CAD8613B7EE72277B,0x04104B201E9942CCA9D30B5A3E4C8D46,0x7BE8D144E72747E690FB5BDB39B006E0,0x4EF48A1F0D554E61B0FF0136E4229A64,0x8B42C403218C47AB9F14D3B131C678BE,0x1A3266240E9049EFA1E23B97125B0595,0x4896C83213BD4EA4AADD632919044AA9,0xBE631DD10F8547149CBCAE08BBAD4BCA);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 339)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetch (line 71)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetchExistences (line 94)
5	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
6	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 71)
7	Shopware\Core\Framework\Api\Controller\SyncController->Shopware\Core\Framework\Api\Controller\{closure} (line 161)
8	Shopware\Core\Framework\Context->scope (line 71)
9	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
19	Shopware\Core\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 15)

0.36 ms
(7.49%)

SELECT item_rounding FROM currency WHERE id = ?

Parameters:

[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 320)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getCashRounding (line 48)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 36)
5	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
6	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 15)

0.34 ms
(7.09%)

SELECT `key`, `value` FROM `app_config`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 924)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 70)
3	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->load (line 36)
4	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->get (line 47)
5	Shopware\Core\Framework\Feature\FeatureFlagRegistry->register (line 148)
6	Shopware\Core\Framework\Framework->boot (line 125)
7	Symfony\Component\HttpKernel\Kernel->boot (line 190)
8	Shopware\Core\Kernel->boot (line 153)
9	Shopware\Core\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 15)

0.29 ms
(6.04%)

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

Parameters:

[
  "en-GB"
]

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 = 'en-GB';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 958)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 267)
3	Shopware\Core\Framework\Adapter\Translation\Translator->getSnippetSetId (line 314)
4	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalog (line 139)
5	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 168)
6	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 38)
7	Symfony\Component\Translation\DataCollectorTranslator->trans (line 120)
8	Symfony\Component\Validator\Violation\ConstraintViolationBuilder->addViolation (line 42)
9	Symfony\Component\Validator\Constraints\NotBlankValidator->validate (line 747)
10	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 592)
11	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateGenericNode (line 101)
12	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 81)
13	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 57)
14	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 53)
15	Shopware\Core\Framework\Validation\HappyPathValidator->validate (line 53)
16	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\AbstractFieldSerializer->validate (line 139)
17	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\AbstractFieldSerializer->validateIfNeeded (line 37)
18	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\EmailFieldSerializer->encode (line 314)
19	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 218)
20	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 101)
21	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
22	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 71)
23	Shopware\Core\Framework\Api\Controller\SyncController->Shopware\Core\Framework\Api\Controller\{closure} (line 161)
24	Shopware\Core\Framework\Context->scope (line 71)
25	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
28	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
29	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
34	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
35	Shopware\Core\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 15)

0.26 ms
(5.39%)

SELECT 1 as `exists`, `id` FROM `customer` WHERE `id` IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Parameters:

[
  b"▓ÃR▀Ø╗I\x0F░Ý2Q>®,d"
  b"dU5ÅºbK├«\x12╩F>ÿ@B"
  b"\x0EÓ°æ}OK\x10ƒˆ˜£¥®N2"
  b"‘‰Â*\x07ÁB³…*\x1C\x11Ð‡Xò"
  b"cq!ù‚$KØ·Ý‘\x01jP†ð"
  b"Žä¹…,˜EÛ„zîƒ¸<îT"
  b"\x7Fa+\t†ÆAD—‹WS|4¼t"
  b"ã(ŠÚv¦LÞœ¯v\x01€Ò\x0EÁ"
  b"ÑšE\x1DÀ\x10J\x14€ÝDeªGqé"
  b"'’¶•”ÓLI‡\x00¿\x7F\x16kA\x05"
  b"~¦"«ËÓGZ‚^“\x04\x05\Š–"
  b"^\x1A\x14"\x02²OA±]„°Àˆ_‹"
  b"Š è,AÂG\x0F¡ô`GqëN\x05"
  b"\x06N\x18kêÛ@Ò¥ôà¶V¨Ò³"
  b"\x1Cqr├+¢C┌ñ\vØ\>╩\x1A/"
  b"'háïÐ\Dþ½Ï■TÅÆ´1"
  b")°RC«ñN<ˆ°à¸ÈŒÍT"
  b"i/\x11r¢dMéŒz6FõbN"
  b"7uaÖàFJõ¡;|\t°$‘C"
  b"\x00~\vˆ@’D\x06…‘ó"\x06LÕ|"
  b"\x116æK°sF6ì\x11H$sè)â"
  b"\x01])Àl´D)ˆ¼pñ€ÙŠ$"
  b"f’SjBlG¾¯›µÛîãßs"
  b"ªÌø_~ÜJÈ‡¶ôç\x0E®\x7F9"
  b"\x1A‡Þ)¿²KA¤÷á’R#ûï"
  b"e¹¶Œ;¹O§—©Ú¼Äš§ƒ"
  b"V}╗BÌÜO╝è¼╝Ødh■p"
  b"åXÑ3╠¶Kü░êqTº¾Îÿ"
  b"""
    Iêä¬\eñ@\x05†º\n
    ò'Òçž
    """
  b"\x12\f°ÒhUJ\x0Fšñ¦{–Ãáº"
  b"XRÝ°À›Aû’uK^UÍˆ…"
  b"+áÂl\x15ÕBY£‘áÔÈ’jÒ"
  b"ÉÔo)VuB ³'\x01U8A‰9"
  b"ª\x15mS;aNH›Xã÷\x10·t2"
  b"è´\ °¥@\x00üÂ█Ä+ìø─"
  b"ì{|ò]ÐB`Ö\x07&rY¥B¢"
  b"\x1A\eÍHÌªNÔ‰\x00`\x1D¡†[½"
  b"Tˆ³MÁJFð´ÎÕr\x7FÆü9"
  b"°¸£Ù×çK\x06¯¯õZ¨s\x01Ù"
  b")No˜\x1E\x18LÅ›\v,äÚJM¶"
  b"Ç¬\x12n÷ýH¢’\x1Do¡ì²j0"
  b"«"ð"}3N'ŸŸîh\x16\x07øó"
  b"""
    ð×iVØ$M\t▓\x08▓þQ\x13\n
    ý
    """
  b"–_õõÒáCf•ÙÙ\e³‡7†"
  b"ù+®ð\x10\x18Câ–øµØâñb¼"
  b"ŒÇO’#¶FÜ„>³\x10\x05™³Ä"
  b"2¡9íÿ\x19Há¿Îõå\x05þ¡~"
  b"™Øþ\v–³Fñ¨ðÆ›¬\eG†"
  b"\x00\tn§^`@t®┘WIØ╗╠·"
  b"–t\x04òUžIJ¨\x1A[²×ìô\x1D"
  b"@É¨ yÄFÙ°–@É¾äw¤"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 as `exists`,
  `id`
FROM
  `customer`
WHERE
  `id` IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT 1 as `exists`, `id` FROM `customer` WHERE `id` IN (0xB2C752DF9DBB490FB0ED32513EA92C64,0x6455358FA7624BC3AE12CA463E984042,0x0ED3B0E67D4F4B10838898A3A5AE4E32,0x9189C22A07C142B3852A1C11D08758F2,0x637121F982244BD8B7DD91016A5086F0,0x8EE4B9852C9845DB847AEE83B83CEE54,0x7F612B0986C64144978B57537C34BC74,0xE3288ADA76A64CDE9CAF760180D20EC1,0xD19A451DC0104A1480DD4465AA4771E9,0x2792B69594D34C498700BF7F166B4105,0x7EA622ABCBD3475A825E9304055C8A96,0x5E1A142202B24F41B15D84B0C0885F8B,0x8A20E82C41C2470FA1F4604771EB4E05,0x064E186BEADB40D2A5F4E0B656A8D2B3,0x1C7172C32BBD43DAA40B9D5C3ECA1A2F,0x2768A08BD15C44E7ABD8FE548F92EF31,0x29B05243ABF14E3C88B0E0B8C88CCD54,0x692F1172A2644DE98C7A3646F5624EAD,0x377561D6E0464AF5A13B7C09B0249143,0x007E0B88409244068591F322064CD57C,0x1136914BF87346368D114824738A2983,0x015D29C06CB4442988BC70F180D98A24,0x6692536A426C47BEAF9BB5DBEEE3DF73,0xAACCF85F7EDC4AC887B6F4E70EAE7F39,0x1A87DE29BFB24B41A4F7E1925223FBEF,0x65B9B68C3BB94FA797A9DABCC49AA783,0x567DBB42DE9A4FBC8AACBC9D6468FE70,0x8658A533CCF44B81B0887154A7F3D798,0x49EAE4AC1BF1400586BA0AF227D2E79E,0x120CB0D268554A0F9AF1A67B96C3E1BA,0x5852DDB0C09B41FB92754B5E55CD8885,0x2BE1C26C15D54259A391E1D4C8926AD2,0xC9D46F29567542A0B327015538418939,0xAA156D533B614E489B58E3F710B77432,0x8AEF5C20F8BE400081B6DB8E2B8D9BC4,0x8D7B7C955DD142609907267259BE42BD,0x1A1BCD48CCAA4ED48900601DA1865BBD,0x5488B34DC14A46F0B4CED5727FC6FC39,0xB0B8A3D9D7E74B06AFAFF55AA87301D9,0x294E6F981E184CC59B0B2CE4DA4A4DB6,0xC7AC126EF7FD48A2921D6FA1ECB26A30,0xAB22F0227D334E279F9FEE681607F8F3,0xD09E69569D244D09B208B2E751130AEC,0x965FF5F5D2E1436695D9D91BB3873786,0xF92BAEF0101843E296F8B5D8E2F162BC,0x8CC74F9223B646DC843EB3100599B3C4,0x32A139EDFF1948E1BFCEF5E505FEA17E,0x99D8FE0B96B346F1A8F0C69BAC1B4786,0x00096EF55E604074A9D957499DBBCCFA,0x967404F2559E494AA81A5BB2D7ECF41D,0x40C9A8A079C446D9B09640C9BEE477A4);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 339)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetch (line 71)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetchExistences (line 94)
5	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
6	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 71)
7	Shopware\Core\Framework\Api\Controller\SyncController->Shopware\Core\Framework\Api\Controller\{closure} (line 161)
8	Shopware\Core\Framework\Context->scope (line 71)
9	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
19	Shopware\Core\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 15)

0.25 ms
(5.16%)

SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?

Parameters:

[
  b"i‹šƒùxK^‹ž'w;8º\x07"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  translation_key,
  value
FROM
  snippet
WHERE
  snippet_set_id = ?

SELECT translation_key, value FROM snippet WHERE snippet_set_id = 0x698B9A83F9784B5E8B9E27773B38BA07;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 924)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 255)
3	Shopware\Core\System\Snippet\SnippetService->fetchSnippetsFromDatabase (line 128)
4	Shopware\Core\System\Snippet\SnippetService->getStorefrontSnippets (line 355)
5	Shopware\Core\Framework\Adapter\Translation\Translator->Shopware\Core\Framework\Adapter\Translation\{closure} (line 64)
6	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 30)
7	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 345)
8	Shopware\Core\Framework\Adapter\Translation\Translator->loadSnippets (line 328)
9	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalog (line 139)
10	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 168)
11	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 38)
12	Symfony\Component\Translation\DataCollectorTranslator->trans (line 120)
13	Symfony\Component\Validator\Violation\ConstraintViolationBuilder->addViolation (line 42)
14	Symfony\Component\Validator\Constraints\NotBlankValidator->validate (line 747)
15	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 592)
16	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateGenericNode (line 101)
17	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 81)
18	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 57)
19	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 53)
20	Shopware\Core\Framework\Validation\HappyPathValidator->validate (line 53)
21	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\AbstractFieldSerializer->validate (line 139)
22	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\AbstractFieldSerializer->validateIfNeeded (line 37)
23	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\EmailFieldSerializer->encode (line 314)
24	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 218)
25	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 101)
26	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
27	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 71)
28	Shopware\Core\Framework\Api\Controller\SyncController->Shopware\Core\Framework\Api\Controller\{closure} (line 161)
29	Shopware\Core\Framework\Context->scope (line 71)
30	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
33	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
34	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
38	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
39	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
40	Shopware\Core\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 15)

0.22 ms
(4.69%)

SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(language.id)
  ) AS array_key,
  LOWER(
    HEX(language.id)
  ) AS id,
  locale.code,
  parentLocale.code AS parentCode,
  LOWER(
    HEX(language.parent_id)
  ) parentId
FROM
  language
  LEFT JOIN locale locale ON language.translation_code_id = locale.id
  LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id
  LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id

SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 33)
3	Shopware\Core\System\Language\LanguageLoader->loadLanguages (line 44)
4	Shopware\Core\System\Language\CachedLanguageLoader->Shopware\Core\System\Language\{closure} (line 64)
5	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 30)
6	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 44)
7	Shopware\Core\System\Language\CachedLanguageLoader->loadLanguages (line 64)
8	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
9	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 71)
10	Shopware\Core\Framework\Api\Controller\SyncController->Shopware\Core\Framework\Api\Controller\{closure} (line 161)
11	Shopware\Core\Framework\Context->scope (line 71)
12	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
15	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
22	Shopware\Core\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 15)

0.20 ms
(4.18%)

SELECT id FROM integration WHERE access_key = ?

Parameters:

[
  "SWIATW11VFPXNM5LEGD2MVZSSG"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  integration
WHERE
  access_key = ?

SELECT id FROM integration WHERE access_key = 'SWIATW11VFPXNM5LEGD2MVZSSG';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 243)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getIntegrationIdByAccessKey (line 160)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 51)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 36)
6	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
7	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
11	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
12	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
13	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 15)

0.19 ms
(4.06%)

SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `base_class` AS `baseClass`,
  `author`
FROM
  `plugin`

SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 924)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 39)
3	Shopware\Core\System\Snippet\Files\SnippetFileLoader->loadPluginSnippets (line 30)
4	Shopware\Core\System\Snippet\Files\SnippetFileLoader->loadSnippetFilesIntoCollection (line 20)
5	Shopware\Core\System\Snippet\Files\SnippetFileCollectionFactory->createSnippetFileCollection (line 9264)
6	ContainerCnwMAmg\Shopware_Core_KernelDevDebugContainer::getSnippetFileCollectionService (line 9261)
7	ContainerCnwMAmg\Shopware_Core_KernelDevDebugContainer::ContainerCnwMAmg\{closure} (line 116)
8	ContainerCnwMAmg\SnippetFileCollectionProxyA628dd5->__get (line 144)
9	Shopware\Core\Framework\Struct\Collection->filter (line 104)
10	Shopware\Core\System\Snippet\SnippetService->getStorefrontSnippets (line 355)
11	Shopware\Core\Framework\Adapter\Translation\Translator->Shopware\Core\Framework\Adapter\Translation\{closure} (line 64)
12	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 30)
13	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 345)
14	Shopware\Core\Framework\Adapter\Translation\Translator->loadSnippets (line 328)
15	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalog (line 139)
16	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 168)
17	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 38)
18	Symfony\Component\Translation\DataCollectorTranslator->trans (line 120)
19	Symfony\Component\Validator\Violation\ConstraintViolationBuilder->addViolation (line 42)
20	Symfony\Component\Validator\Constraints\NotBlankValidator->validate (line 747)
21	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 592)
22	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateGenericNode (line 101)
23	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 81)
24	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 57)
25	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 53)
26	Shopware\Core\Framework\Validation\HappyPathValidator->validate (line 53)
27	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\AbstractFieldSerializer->validate (line 139)
28	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\AbstractFieldSerializer->validateIfNeeded (line 37)
29	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\EmailFieldSerializer->encode (line 314)
30	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 218)
31	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 101)
32	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
33	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 71)
34	Shopware\Core\Framework\Api\Controller\SyncController->Shopware\Core\Framework\Api\Controller\{closure} (line 161)
35	Shopware\Core\Framework\Context->scope (line 71)
36	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
39	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
40	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
42	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
43	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
44	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
45	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
46	Shopware\Core\Kernel->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 15)

0.18 ms
(3.79%)

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 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 32)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 63)
4	Shopware\Core\System\System->boot (line 125)
5	Symfony\Component\HttpKernel\Kernel->boot (line 190)
6	Shopware\Core\Kernel->boot (line 153)
7	Shopware\Core\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 15)

0.18 ms
(3.74%)

SELECT iso FROM snippet_set WHERE id = ?

Parameters:

[
  b"i‹šƒùxK^‹ž'w;8º\x07"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  iso
FROM
  snippet_set
WHERE
  id = ?

SELECT iso FROM snippet_set WHERE id = 0x698B9A83F9784B5E8B9E27773B38BA07;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 358)
3	Shopware\Core\System\Snippet\SnippetService->getLocaleBySnippetSetId (line 96)
4	Shopware\Core\System\Snippet\SnippetService->getStorefrontSnippets (line 355)
5	Shopware\Core\Framework\Adapter\Translation\Translator->Shopware\Core\Framework\Adapter\Translation\{closure} (line 64)
6	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 30)
7	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 345)
8	Shopware\Core\Framework\Adapter\Translation\Translator->loadSnippets (line 328)
9	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalog (line 139)
10	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 168)
11	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 38)
12	Symfony\Component\Translation\DataCollectorTranslator->trans (line 120)
13	Symfony\Component\Validator\Violation\ConstraintViolationBuilder->addViolation (line 42)
14	Symfony\Component\Validator\Constraints\NotBlankValidator->validate (line 747)
15	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 592)
16	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateGenericNode (line 101)
17	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 81)
18	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 57)
19	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 53)
20	Shopware\Core\Framework\Validation\HappyPathValidator->validate (line 53)
21	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\AbstractFieldSerializer->validate (line 139)
22	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\AbstractFieldSerializer->validateIfNeeded (line 37)
23	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\EmailFieldSerializer->encode (line 314)
24	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 218)
25	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 101)
26	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
27	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 71)
28	Shopware\Core\Framework\Api\Controller\SyncController->Shopware\Core\Framework\Api\Controller\{closure} (line 161)
29	Shopware\Core\Framework\Context->scope (line 71)
30	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
33	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
34	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
38	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
39	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
40	Shopware\Core\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 15)

0.13 ms
(2.62%)

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

Parameters:

[
  b"ŒgdÃÍµIˆ„YÐ\e‚h®\x08"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 346)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->fetchPermissionsIntegrationByApp (line 254)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 162)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 51)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 36)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 15)

0.11 ms
(2.26%)

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 386)
2	Shopware\Core\Kernel->initializeDatabaseConnectionVariables (line 188)
3	Shopware\Core\Kernel->boot (line 153)
4	Shopware\Core\Kernel->handle (line 35)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
6	require_once (line 15)

0.07 ms
(1.42%)

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 924)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 130)
3	Shopware\Core\System\CustomField\CustomFieldService->getCustomFields (line 46)
4	Shopware\Core\System\CustomField\CustomFieldService->getCustomField (line 102)
5	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->getFields (line 57)
6	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->encode (line 314)
7	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 218)
8	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 106)
9	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\ManyToOneAssociationFieldSerializer->encode (line 314)
10	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 218)
11	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 101)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
13	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 71)
14	Shopware\Core\Framework\Api\Controller\SyncController->Shopware\Core\Framework\Api\Controller\{closure} (line 161)
15	Shopware\Core\Framework\Context->scope (line 71)
16	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 15)

0.06 ms
(1.34%)

SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = ?

Parameters:

[
  b"ŒgdÃÍµIˆ„YÐ\e‚h®\x08"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  role.privileges
FROM
  integration_role mapping
  INNER JOIN acl_role role ON mapping.acl_role_id = role.id
WHERE
  mapping.integration_id = ?

SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = 0x8C6764C3CDB549888459D01B8268AE08;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 371)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->fetchIntegrationPermissions (line 271)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 162)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 51)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 36)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 15)

0.05 ms
(1.01%)

SELECT admin FROM `integration` WHERE id = ?

Parameters:

[
  b"ŒgdÃÍµIˆ„YÐ\e‚h®\x08"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  admin
FROM
  `integration`
WHERE
  id = ?

SELECT admin FROM `integration` WHERE id = 0x8C6764C3CDB549888459D01B8268AE08;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 289)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->isAdminIntegration (line 270)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 162)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 51)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 36)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 15)

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

POST https://staging.reinhold-sohn-hygiene.de/api/_action/sync

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache