Symfony Profiler

Query Metrics

32 Database Queries

22 Different statements

50.16 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

11.43 ms
(22.79%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 1301)
3	Doctrine\DBAL\Connection->transactional (line 42)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 27)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 109)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 204)
7	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->write (line 139)
8	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->update (line 114)
9	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->update (line 96)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 126)
11	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
12	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
13	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
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 476)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
23	Shopware\Core\Kernel->handle (line 34)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
25	require_once (line 10)

5.87 ms
(11.71%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 1285)
2	Doctrine\DBAL\Connection->transactional (line 42)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 27)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 109)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->write (line 139)
7	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->update (line 114)
8	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->update (line 96)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 126)
10	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
11	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
12	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (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 476)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
22	Shopware\Core\Kernel->handle (line 34)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
24	require_once (line 10)

4.16 ms
(8.30%)

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 30367)
6	ContainerVu6vxYC\Shopware_Core_KernelDevDebugContainer::getSourceResolverService (line 30177)
7	ContainerVu6vxYC\Shopware_Core_KernelDevDebugContainer::getScriptFileReaderService (line 30118)
8	ContainerVu6vxYC\Shopware_Core_KernelDevDebugContainer::getScriptPersisterService (line 32356)
9	ContainerVu6vxYC\Shopware_Core_KernelDevDebugContainer::getScriptLoaderService (line 7614)
10	ContainerVu6vxYC\Shopware_Core_KernelDevDebugContainer::getScriptExecutorService (line 32140)
11	ContainerVu6vxYC\Shopware_Core_KernelDevDebugContainer::getCoreSubscriberService (line 12178)
12	ContainerVu6vxYC\Shopware_Core_KernelDevDebugContainer::ContainerVu6vxYC\{closure} (line 221)
13	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
14	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 89)
15	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->getListeners (line 71)
16	Shopware\Core\Framework\Webhook\WebhookDispatcher->getListeners (line 64)
17	Shopware\Core\Framework\Event\NestedEventDispatcher->getListeners (line 262)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 123)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
29	Shopware\Core\Kernel->handle (line 34)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
31	require_once (line 10)

4.11 ms
(8.19%)

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 37)
5	Shopware\Core\Framework\Adapter\Cache\CacheIdLoader->load (line 67)
6	Shopware\Core\Framework\Adapter\Kernel\KernelFactory::create (line 42)
7	{closure} (line 25)
8	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 27)
9	require_once (line 10)

3.53 ms
(7.03%)

INSERT INTO `increment` (`pool`, `cluster`, `key`, `count`, `created_at`)
            VALUES (?, ?, ?, 1, ?)
            ON DUPLICATE KEY UPDATE `count` = `count` + 1, `updated_at` = ?

Parameters:

[
  "message_queue"
  "message_queue_stats"
  "Shopware\Core\Content\ProductExport\ScheduledTask\ProductExportGenerateTask"
  "2026-07-14 08:12:08.606"
  "2026-07-14 08:12:08.606"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO `increment` (
  `pool`, `cluster`, `key`, `count`,
  `created_at`
)
VALUES
  (?, ?, ?, 1, ?) ON DUPLICATE KEY
UPDATE
  `count` = `count` + 1,
  `updated_at` = ?

INSERT INTO `increment` (`pool`, `cluster`, `key`, `count`, `created_at`)
            VALUES ('message_queue', 'message_queue_stats', 'Shopware\\Core\\Content\\ProductExport\\ScheduledTask\\ProductExportGenerateTask', 1, '2026-07-14 08:12:08.606')
            ON DUPLICATE KEY UPDATE `count` = `count` + 1, `updated_at` = '2026-07-14 08:12:08.606'
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 32)
2	Shopware\Core\Framework\Increment\MySQLIncrementer->increment (line 62)
3	Shopware\Core\Framework\MessageQueue\Subscriber\MessageQueueStatsSubscriber->handle (line 52)
4	Shopware\Core\Framework\MessageQueue\Subscriber\MessageQueueStatsSubscriber->onMessageSent (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 129)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 56)
12	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 28)
13	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 34)
14	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
15	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
16	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
17	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 33)
18	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 36)
19	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 47)
20	Shopware\Core\Framework\MessageQueue\Middleware\RoutingOverwriteMiddleware->handle (line 69)
21	Symfony\Component\Messenger\MessageBus->dispatch (line 42)
22	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 147)
23	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
24	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
25	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (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 476)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
34	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
35	Shopware\Core\Kernel->handle (line 34)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
37	require_once (line 10)

3.06 ms
(6.10%)

SELECT `scheduled_task`.`id` as `scheduled_task.id`, `scheduled_task`.`name` as `scheduled_task.name`, `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, `scheduled_task`.`default_run_interval` as `scheduled_task.defaultRunInterval`, `scheduled_task`.`status` as `scheduled_task.status`, `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, `scheduled_task`.`created_at` as `scheduled_task.createdAt`, `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE ((`scheduled_task`.`next_execution_time` < ?) AND `scheduled_task`.`status` IN (?, ?))

Parameters:

[
  "2026-07-14 08:12:08.548"
  "scheduled"
  "skipped"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `scheduled_task`.`id` as `scheduled_task.id`,
  `scheduled_task`.`name` as `scheduled_task.name`,
  `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`,
  `scheduled_task`.`run_interval` as `scheduled_task.runInterval`,
  `scheduled_task`.`default_run_interval` as `scheduled_task.defaultRunInterval`,
  `scheduled_task`.`status` as `scheduled_task.status`,
  `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`,
  `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`,
  `scheduled_task`.`created_at` as `scheduled_task.createdAt`,
  `scheduled_task`.`updated_at` as `scheduled_task.updatedAt`
FROM
  `scheduled_task`
WHERE
  (
    (
      `scheduled_task`.`next_execution_time` < ?
    )
    AND `scheduled_task`.`status` IN (?, ?)
  )

SELECT `scheduled_task`.`id` as `scheduled_task.id`, `scheduled_task`.`name` as `scheduled_task.name`, `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, `scheduled_task`.`default_run_interval` as `scheduled_task.defaultRunInterval`, `scheduled_task`.`status` as `scheduled_task.status`, `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, `scheduled_task`.`created_at` as `scheduled_task.createdAt`, `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE ((`scheduled_task`.`next_execution_time` < '2026-07-14 08:12:08.548') AND `scheduled_task`.`status` IN ('scheduled', 'skipped'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 43)
9	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
10	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
13	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
19	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
20	Shopware\Core\Kernel->handle (line 34)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
22	require_once (line 10)

2.69 ms
(5.37%)

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

Parameters:

[
  b"H¬ªá§\tA¢U\x12þX½¡ù"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT 1 as `exists`, `id` FROM `scheduled_task` WHERE `id` IN (0x48ACAAE1A70941A2815512FE58BDA1F9);

#	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 188)
5	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->write (line 139)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->update (line 114)
7	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->update (line 96)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 126)
9	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
10	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
11	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
14	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
21	Shopware\Core\Kernel->handle (line 34)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
23	require_once (line 10)

2.53 ms
(5.05%)

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 476)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
19	Shopware\Core\Kernel->handle (line 34)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
21	require_once (line 10)

2.25 ms
(4.48%)

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 183)
8	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->write (line 139)
9	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->update (line 114)
10	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->update (line 96)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 126)
12	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
13	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
14	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
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 476)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
24	Shopware\Core\Kernel->handle (line 34)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
26	require_once (line 10)

1.88 ms
(3.75%)

UPDATE `scheduled_task` SET `status` = ?, `next_execution_time` = ?, `updated_at` = ? WHERE id = ?

Parameters:

[
  "skipped"
  "2026-07-14 08:12:08.553"
  "2026-07-14 08:12:08.558"
  b"H¬ªá§\tA¢U\x12þX½¡ù"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `scheduled_task`
SET
  `status` = ?,
  `next_execution_time` = ?,
  `updated_at` = ?
WHERE
  id = ?

UPDATE `scheduled_task` SET `status` = 'skipped', `next_execution_time` = '2026-07-14 08:12:08.553', `updated_at` = '2026-07-14 08:12:08.558' WHERE id = 0x48ACAAE1A70941A2815512FE58BDA1F9;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 782)
2	Doctrine\DBAL\Connection->update (line 196)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 60)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 40)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 195)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 110)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1290)
8	Doctrine\DBAL\Connection->transactional (line 42)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 27)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 109)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 204)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->write (line 139)
13	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->update (line 114)
14	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->update (line 96)
15	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 126)
16	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
17	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
18	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
28	Shopware\Core\Kernel->handle (line 34)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
30	require_once (line 10)

1.69 ms
(3.37%)

UPDATE `scheduled_task` SET `status` = ?, `updated_at` = ? WHERE id = ?

Parameters:

[
  "queued"
  "2026-07-14 08:12:08.592"
  b"feá™SÁKó²\x7FgŒ\\x10²°"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `scheduled_task`
SET
  `status` = ?,
  `updated_at` = ?
WHERE
  id = ?

UPDATE `scheduled_task` SET `status` = 'queued', `updated_at` = '2026-07-14 08:12:08.592' WHERE id = 0x6665E19953C14BF3B27F678C5C10B2B0;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 782)
2	Doctrine\DBAL\Connection->update (line 196)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 60)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 40)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 195)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 110)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1290)
8	Doctrine\DBAL\Connection->transactional (line 42)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 27)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 109)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 204)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->write (line 139)
13	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->update (line 114)
14	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->update (line 96)
15	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 137)
16	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
17	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
18	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
28	Shopware\Core\Kernel->handle (line 34)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
30	require_once (line 10)

1.46 ms
(2.92%)

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 371)
2	Shopware\Core\Kernel->initializeDatabaseConnectionVariables (line 175)
3	Shopware\Core\Kernel->boot (line 151)
4	Shopware\Core\Kernel->handle (line 34)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
6	require_once (line 10)

1.02 ms
(2.04%)

-- app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)

Parameters:

[
  true
  false
]

View formatted query View runnable query Explain query View query backtrace

-- app-scripts::refresh::search-ids
SELECT
  `app`.`id`
FROM
  `app`
WHERE
  (
    `app`.`active` = ?
    AND `app`.`self_managed` = ?
  )

-- app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = 1 AND `app`.`self_managed` = 0);

#	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 49)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 37)
5	Shopware\Elasticsearch\Admin\AdminElasticsearchEntitySearcher->search (line 299)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 86)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 86)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 117)
10	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->refresh (line 73)
11	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 54)
12	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 55)
13	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 29)
14	Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber->executeCacheInvalidationHook (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
18	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
19	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
20	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 129)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
22	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 185)
23	Shopware\Core\Framework\Context->scope (line 98)
24	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 126)
25	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
26	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
27	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
30	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
31	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
36	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
37	Shopware\Core\Kernel->handle (line 34)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
39	require_once (line 10)

0.98 ms
(1.95%)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)

Parameters:

[
  "{"taskId":"6665e19953c14bf3b27f678c5c10b2b0"}"
  "{"type":"Shopware\\Core\\Content\\ProductExport\\ScheduledTask\\ProductExportGenerateTask","X-Message-Stamp-Symfony\\Component\\Messenger\\Stamp\\BusNameStamp":"[{\"busName\":\"messenger.bus.default\"}]","Content-Type":"application\/json"}"
  "default"
  "2026-07-14 08:12:08"
  "2026-07-14 08:12:08"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('{\"taskId\":\"6665e19953c14bf3b27f678c5c10b2b0\"}', '{\"type\":\"Shopware\\\\Core\\\\Content\\\\ProductExport\\\\ScheduledTask\\\\ProductExportGenerateTask\",\"X-Message-Stamp-Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\":\"[{\\\"busName\\\":\\\"messenger.bus.default\\\"}]\",\"Content-Type\":\"application\\/json\"}', 'default', '2026-07-14 08:12:08', '2026-07-14 08:12:08');

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 480)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 148)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 76)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 62)
6	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 28)
7	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 33)
12	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 36)
13	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 47)
14	Shopware\Core\Framework\MessageQueue\Middleware\RoutingOverwriteMiddleware->handle (line 69)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 42)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 147)
17	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
18	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
19	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
29	Shopware\Core\Kernel->handle (line 34)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
31	require_once (line 10)

0.92 ms
(1.84%)

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 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 77)
3	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 54)
4	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 55)
5	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 29)
6	Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber->executeCacheInvalidationHook (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 129)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 185)
15	Shopware\Core\Framework\Context->scope (line 98)
16	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 126)
17	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
18	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
19	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
29	Shopware\Core\Kernel->handle (line 34)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
31	require_once (line 10)

0.64 ms
(1.27%)

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 127)
5	Symfony\Component\HttpKernel\Kernel->boot (line 177)
6	Shopware\Core\Kernel->boot (line 151)
7	Shopware\Core\Kernel->handle (line 34)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
9	require_once (line 10)

0.46 ms
(0.92%)

SELECT last_updated_password_at FROM user WHERE id = ?

Parameters:

[
  b"Põc“ÖŽAøªZ«Tºÿ˜¶"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  last_updated_password_at
FROM
  user
WHERE
  id = ?

SELECT last_updated_password_at FROM user WHERE id = 0x50F56393D68E41F8AA5AAB54BAFF98B6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 91)
3	Shopware\Core\Framework\Api\OAuth\SymfonyBearerTokenValidator->validateAccessTokenIssuedAt (line 80)
4	Shopware\Core\Framework\Api\OAuth\SymfonyBearerTokenValidator->validateAuthorization (line 33)
5	Shopware\Core\Framework\Api\OAuth\BearerTokenValidator->validateAuthorization (line 101)
6	Shopware\Core\Framework\Api\EventListener\Authentication\ApiAuthenticationListener->validateRequest (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 129)
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 476)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
23	Shopware\Core\Kernel->handle (line 34)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
25	require_once (line 10)

0.40 ms
(0.80%)

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 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 93)
3	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 54)
4	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 55)
5	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 29)
6	Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber->executeCacheInvalidationHook (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 129)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 185)
15	Shopware\Core\Framework\Context->scope (line 98)
16	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 126)
17	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueTask (line 54)
18	Shopware\Core\Framework\MessageQueue\ScheduledTask\Scheduler\TaskScheduler->queueScheduledTasks (line 25)
19	Shopware\Core\Framework\MessageQueue\Api\ScheduledTaskController->runScheduledTasks (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
29	Shopware\Core\Kernel->handle (line 34)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
31	require_once (line 10)

0.34 ms
(0.68%)

# 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 167)
4	Shopware\Core\Kernel->boot (line 151)
5	Shopware\Core\Kernel->handle (line 34)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
7	require_once (line 10)

0.31 ms
(0.63%)

SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = ?

Parameters:

[
  b"Põc“ÖŽAøªZ«Tºÿ˜¶"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  role.privileges
FROM
  acl_user_role mapping
  INNER JOIN acl_role role ON mapping.acl_role_id = role.id
WHERE
  mapping.user_id = ?

SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0x50F56393D68E41F8AA5AAB54BAFF98B6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 306)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->fetchPermissions (line 263)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 143)
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 129)
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 476)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
25	Shopware\Core\Kernel->handle (line 34)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
27	require_once (line 10)

0.23 ms
(0.46%)

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 129)
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 476)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
23	Shopware\Core\Kernel->handle (line 34)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
25	require_once (line 10)

0.18 ms
(0.36%)

SELECT admin FROM `user` WHERE id = ?

Parameters:

[
  b"Põc“ÖŽAøªZ«Tºÿ˜¶"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  admin
FROM
  `user`
WHERE
  id = ?

SELECT admin FROM `user` WHERE id = 0x50F56393D68E41F8AA5AAB54BAFF98B6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 281)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->isAdmin (line 264)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 143)
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 129)
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 476)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 292)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 206)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 153)
25	Shopware\Core\Kernel->handle (line 34)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
27	require_once (line 10)

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://swstaging.serv.rocks/api/_action/scheduled-task/run

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache