Symfony Profiler

Query Metrics

39 Database Queries

33 Different statements

29.77 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

10.90 ms
(36.60%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "4901249012"
  "JPG"
  b"©!O\tÛƒDËØØ«R{û¡\x10"
  false
  true
  "product_download"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
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 433)
9	Shopware\Core\Content\Media\File\FileSaver->searchRelatedMediaByFileName (line 394)
10	Shopware\Core\Content\Media\File\FileSaver->ensureFileNameIsUnique (line 73)
11	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
12	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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)

8.18 ms
(27.47%)

SELECT
                    LOWER(HEX(pm.product_id)) as product_id,
                    IF(variant.id IS NULL,  NULL, LOWER(HEX(variant.id))) as variant_id
                    FROM product_media AS pm
                    LEFT JOIN product as variant ON (pm.product_id = variant.parent_id)
                    WHERE media_id IN (?)

Parameters:

[
  b"©!O\tÛƒDËØØ«R{û¡\x10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(pm.product_id)
  ) as product_id,
  IF(
    variant.id IS NULL,
    NULL,
    LOWER(
      HEX(variant.id)
    )
  ) as variant_id
FROM
  product_media AS pm
  LEFT JOIN product as variant ON (
    pm.product_id = variant.parent_id
  )
WHERE
  media_id IN (?)

SELECT
                    LOWER(HEX(pm.product_id)) as product_id,
                    IF(variant.id IS NULL,  NULL, LOWER(HEX(variant.id))) as variant_id
                    FROM product_media AS pm
                    LEFT JOIN product as variant ON (pm.product_id = variant.parent_id)
                    WHERE media_id IN (0xB8214F09EA9F44D39D9DAE527B96AD10);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 383)
3	Shopware\Core\Framework\Adapter\Cache\CacheInvalidationSubscriber->invalidateMedia (line 115)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
7	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
8	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
9	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 105)
11	Shopware\Core\Content\Media\DataAbstractionLayer\MediaIndexer->handle (line 60)
12	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->__invoke (line 243)
13	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->sendOrHandle (line 150)
14	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
15	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
19	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
20	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
21	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
23	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 300)
24	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
25	Shopware\Core\Framework\Context->scope (line 299)
26	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
27	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
28	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
31	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
32	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
37	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
38	Shopware\Core\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 15)

1.03 ms
(3.46%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"©!O\tÛƒDËØØ«R{û¡\x10"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
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 344)
9	Shopware\Core\Content\Media\File\FileSaver->findMediaById (line 71)
10	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
11	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 460)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
21	Shopware\Core\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 15)

0.96 ms
(3.23%)

UPDATE `media` SET `user_id` = ?, `mime_type` = ?, `file_extension` = ?, `file_name` = ?, `file_size` = ?, `media_type` = ?, `meta_data` = ?, `updated_at` = ? WHERE id = ?

Parameters:

[
  null
  "image/jpeg"
  "JPG"
  "4901249012"
  74881
  "O:47:"Shopware\Core\Content\Media\MediaType\ImageType":3:{s:13:"\x00*\x00extensions";a:0:{}s:7:"\x00*\x00name";s:5:"IMAGE";s:8:"\x00*\x00flags";a:0:{}}"
  "{"width":1200,"height":1200,"type":2,"hash":"1417d5ad962a5f8e536dfad1f081c91b"}"
  "2025-12-06 05:33:09.100"
  b"©!O\tÛƒDËØØ«R{û¡\x10"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `media`
SET
  `user_id` = ?,
  `mime_type` = ?,
  `file_extension` = ?,
  `file_name` = ?,
  `file_size` = ?,
  `media_type` = ?,
  `meta_data` = ?,
  `updated_at` = ?
WHERE
  id = ?

UPDATE `media` SET `user_id` = NULL, `mime_type` = 'image/jpeg', `file_extension` = 'JPG', `file_name` = '4901249012', `file_size` = 74881, `media_type` = 'O:47:\"Shopware\\Core\\Content\\Media\\MediaType\\ImageType\":3:{s:13:\"\0*\0extensions\";a:0:{}s:7:\"\0*\0name\";s:5:\"IMAGE\";s:8:\"\0*\0flags\";a:0:{}}', `meta_data` = '{\"width\":1200,\"height\":1200,\"type\":2,\"hash\":\"1417d5ad962a5f8e536dfad1f081c91b\"}', `updated_at` = '2025-12-06 05:33:09.100' WHERE id = 0xB8214F09EA9F44D39D9DAE527B96AD10;

#	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 300)
16	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
17	Shopware\Core\Framework\Context->scope (line 299)
18	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
19	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
20	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 15)

0.72 ms
(2.42%)

# 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.67 ms
(2.26%)

"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 158)
7	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->delete (line 126)
8	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->delete (line 138)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 509)
10	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 201)
11	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 236)
12	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
13	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
14	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 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.67 ms
(2.26%)

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 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 149)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 509)
15	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 201)
16	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 236)
17	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
18	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
19	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 460)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 15)

0.63 ms
(2.11%)

UPDATE `media` SET thumbnails_ro = :thumbnails_ro WHERE id = :id

Parameters:

[
  "thumbnails_ro" => "O:77:"Shopware\Core\Content\Media\Aggregate\MediaThumbnail\MediaThumbnailCollection":2:{s:13:"\x00*\x00extensions";a:0:{}s:11:"\x00*\x00elements";a:0:{}}"
  "id" => b"©!O\tÛƒDËØØ«R{û¡\x10"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `media`
SET
  thumbnails_ro = :thumbnails_ro
WHERE
  id = :id

UPDATE `media` SET thumbnails_ro = 'O:77:\"Shopware\\Core\\Content\\Media\\Aggregate\\MediaThumbnail\\MediaThumbnailCollection\":2:{s:13:\"\0*\0extensions\";a:0:{}s:11:\"\0*\0elements\";a:0:{}}' WHERE id = 0xB8214F09EA9F44D39D9DAE527B96AD10;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 28)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery->Shopware\Core\Framework\DataAbstractionLayer\Doctrine\{closure} (line 60)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 28)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery->execute (line 99)
6	Shopware\Core\Content\Media\DataAbstractionLayer\MediaIndexer->handle (line 60)
7	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->__invoke (line 243)
8	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->sendOrHandle (line 150)
9	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
18	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 300)
19	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
20	Shopware\Core\Framework\Context->scope (line 299)
21	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
22	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
23	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
26	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
32	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
33	Shopware\Core\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 15)

0.60 ms
(2.01%)

UPDATE media SET path = :path WHERE id = :id

Parameters:

[
  "path" => "media/0f/8b/36/1730243276/4901249012.JPG"
  "id" => b"©!O\tÛƒDËØØ«R{û¡\x10"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  media
SET
  path = :path
WHERE
  id = :id

UPDATE media SET path = 'media/0f/8b/36/1730243276/4901249012.JPG' WHERE id = 0xB8214F09EA9F44D39D9DAE527B96AD10;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 31)
3	Shopware\Core\Content\Media\Infrastructure\Path\SqlMediaPathStorage->media (line 58)
4	Shopware\Core\Content\Media\Core\Application\MediaPathUpdater->updateMedia (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 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 306)
12	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
13	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
14	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 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.44 ms
(1.49%)

SELECT
        LOWER(HEX(MIN(w.id))) as webhookId,
        MIN(w.name) as webhookName,
        w.event_name as eventName,
        w.url as webhookUrl,
        w.only_live_version as onlyLiveVersion,
        LOWER(HEX(MIN(a.id))) AS appId,
        MIN(a.name) AS appName,
        MIN(a.active) AS appActive,
        MIN(a.version) AS appVersion,
        MIN(a.app_secret) AS appSecret,
        LOWER(HEX(MIN(a.acl_role_id))) as appAclRoleId

    FROM webhook w
    LEFT JOIN app a ON (a.id = w.app_id)
    WHERE w.active = 1
    GROUP BY event_name, url, only_live_version

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(
      MIN(w.id)
    )
  ) as webhookId,
  MIN(w.name) as webhookName,
  w.event_name as eventName,
  w.url as webhookUrl,
  w.only_live_version as onlyLiveVersion,
  LOWER(
    HEX(
      MIN(a.id)
    )
  ) AS appId,
  MIN(a.name) AS appName,
  MIN(a.active) AS appActive,
  MIN(a.version) AS appVersion,
  MIN(a.app_secret) AS appSecret,
  LOWER(
    HEX(
      MIN(a.acl_role_id)
    )
  ) as appAclRoleId
FROM
  webhook w
  LEFT JOIN app a ON (a.id = w.app_id)
WHERE
  w.active = 1
GROUP BY
  event_name,
  url,
  only_live_version

SELECT
        LOWER(HEX(MIN(w.id))) as webhookId,
        MIN(w.name) as webhookName,
        w.event_name as eventName,
        w.url as webhookUrl,
        w.only_live_version as onlyLiveVersion,
        LOWER(HEX(MIN(a.id))) AS appId,
        MIN(a.name) AS appName,
        MIN(a.active) AS appActive,
        MIN(a.version) AS appVersion,
        MIN(a.app_secret) AS appSecret,
        LOWER(HEX(MIN(a.acl_role_id))) as appAclRoleId

    FROM webhook w
    LEFT JOIN app a ON (a.id = w.app_id)
    WHERE w.active = 1
    GROUP BY event_name, url, only_live_version;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 92)
3	Shopware\Core\Framework\Webhook\Service\WebhookLoader->getWebhooks (line 352)
4	Shopware\Core\Framework\Webhook\Service\WebhookManager->loadWebhooks (line 341)
5	Shopware\Core\Framework\Webhook\Service\WebhookManager->getWebhooks (line 94)
6	Shopware\Core\Framework\Webhook\Service\WebhookManager->callWebhooks (line 72)
7	Shopware\Core\Framework\Webhook\Service\WebhookManager->dispatch (line 36)
8	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
9	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 300)
12	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
13	Shopware\Core\Framework\Context->scope (line 299)
14	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
15	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
16	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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.40 ms
(1.33%)

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\Media\Message\GenerateThumbnailsMessage"
  "2025-12-06 05:33:09.128"
  "2025-12-06 05:33:09.128"
]

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\\Media\\Message\\GenerateThumbnailsMessage', 1, '2025-12-06 05:33:09.128')
            ON DUPLICATE KEY UPDATE `count` = `count` + 1, `updated_at` = '2025-12-06 05:33:09.128'
        ;

#	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 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 56)
12	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
13	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
14	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
15	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
16	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
17	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 47)
18	Shopware\Core\Framework\MessageQueue\Middleware\RoutingOverwriteMiddleware->handle (line 69)
19	Symfony\Component\Messenger\MessageBus->dispatch (line 37)
20	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 107)
21	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
22	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 15)

0.37 ms
(1.24%)

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 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 149)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 509)
15	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 201)
16	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 236)
17	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
18	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
19	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 460)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 15)

0.36 ms
(1.20%)

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.30 ms
(1.00%)

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.30 ms
(0.99%)

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 157)
8	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->delete (line 126)
9	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->delete (line 138)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 509)
11	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 201)
12	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 236)
13	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
14	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
15	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
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.26 ms
(0.87%)

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.24 ms
(0.81%)

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.23 ms
(0.77%)

"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 158)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->delete (line 126)
7	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->delete (line 138)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 509)
9	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 201)
10	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 236)
11	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
13	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 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.22 ms
(0.74%)

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.22 ms
(0.73%)

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 27691)
6	ContainerPj5G6xr\Shopware_Core_KernelDevDebugContainer::getSourceResolverService (line 33002)
7	ContainerPj5G6xr\Shopware_Core_KernelDevDebugContainer::getStorefrontPluginConfigurationFactoryService (line 9718)
8	ContainerPj5G6xr\Shopware_Core_KernelDevDebugContainer::getStorefrontPluginRegistryService (line 33416)
9	ContainerPj5G6xr\Shopware_Core_KernelDevDebugContainer::getThemeNamespaceHierarchyBuilderService (line 11997)
10	ContainerPj5G6xr\Shopware_Core_KernelDevDebugContainer::ContainerPj5G6xr\{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.22 ms
(0.73%)

SELECT `event_name`, LOWER(HEX(`id`)) as `id`, `name`, `payload` FROM `flow`
                WHERE `active` = 1 AND `invalid` = 0 AND `payload` IS NOT NULL
                ORDER BY `priority` DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `event_name`,
  LOWER(
    HEX(`id`)
  ) as `id`,
  `name`,
  `payload`
FROM
  `flow`
WHERE
  `active` = 1
  AND `invalid` = 0
  AND `payload` IS NOT NULL
ORDER BY
  `priority` DESC

SELECT `event_name`, LOWER(HEX(`id`)) as `id`, `name`, `payload` FROM `flow`
                WHERE `active` = 1 AND `invalid` = 0 AND `payload` IS NOT NULL
                ORDER BY `priority` DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 29)
3	Shopware\Core\Content\Flow\Dispatching\FlowLoader->load (line 48)
4	Shopware\Core\Content\Flow\Dispatching\CachedFlowLoader->Shopware\Core\Content\Flow\Dispatching\{closure} (line 64)
5	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 30)
6	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 45)
7	Shopware\Core\Content\Flow\Dispatching\CachedFlowLoader->load (line 169)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->getFlows (line 118)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->callFlowExecutor (line 56)
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 62)
14	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 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.20 ms
(0.66%)

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.19 ms
(0.64%)

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
(0.64%)

# 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 297)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 86)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
7	Shopware\Core\Profiling\Profiler::trace (line 86)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 117)
9	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->refresh (line 73)
10	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 54)
11	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 55)
12	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 29)
13	Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber->executeCacheInvalidationHook (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
17	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
18	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
19	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 149)
21	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 509)
22	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 201)
23	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 236)
24	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
25	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
26	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
35	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
36	Shopware\Core\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 15)

0.17 ms
(0.56%)

SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`width` as `media_thumbnail.width`, `media_thumbnail`.`height` as `media_thumbnail.height`, `media_thumbnail`.`path` as `media_thumbnail.path`, `media_thumbnail`.`custom_fields` as `media_thumbnail.customFields`, `media_thumbnail`.`created_at` as `media_thumbnail.createdAt`, `media_thumbnail`.`updated_at` as `media_thumbnail.updatedAt` FROM `media_thumbnail` WHERE (`media_thumbnail`.`media_id` IN (?))

Parameters:

[
  b"©!O\tÛƒDËØØ«R{û¡\x10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `media_thumbnail`.`id` as `media_thumbnail.id`,
  `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`,
  `media_thumbnail`.`width` as `media_thumbnail.width`,
  `media_thumbnail`.`height` as `media_thumbnail.height`,
  `media_thumbnail`.`path` as `media_thumbnail.path`,
  `media_thumbnail`.`custom_fields` as `media_thumbnail.customFields`,
  `media_thumbnail`.`created_at` as `media_thumbnail.createdAt`,
  `media_thumbnail`.`updated_at` as `media_thumbnail.updatedAt`
FROM
  `media_thumbnail`
WHERE
  (
    `media_thumbnail`.`media_id` IN (?)
  )

SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`width` as `media_thumbnail.width`, `media_thumbnail`.`height` as `media_thumbnail.height`, `media_thumbnail`.`path` as `media_thumbnail.path`, `media_thumbnail`.`custom_fields` as `media_thumbnail.customFields`, `media_thumbnail`.`created_at` as `media_thumbnail.createdAt`, `media_thumbnail`.`updated_at` as `media_thumbnail.updatedAt` FROM `media_thumbnail` WHERE (`media_thumbnail`.`media_id` IN (0xB8214F09EA9F44D39D9DAE527B96AD10));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
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 93)
9	Shopware\Core\Content\Media\DataAbstractionLayer\MediaIndexer->handle (line 60)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->__invoke (line 243)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->sendOrHandle (line 150)
12	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
13	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 40)
17	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
18	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
19	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
21	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 300)
22	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
23	Shopware\Core\Framework\Context->scope (line 299)
24	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
25	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
26	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
35	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
36	Shopware\Core\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 15)

0.16 ms
(0.55%)

SELECT 1 as `exists`, `media_id`, `language_id` FROM `media_translation` WHERE (`media_id`,`language_id`) IN ((?,?))

Parameters:

[
  b"©!O\tÛƒDËØØ«R{û¡\x10"
  b"/»_ââšMpªXTÎ|ãâ\v"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 as `exists`,
  `media_id`,
  `language_id`
FROM
  `media_translation`
WHERE
  (`media_id`, `language_id`) IN (
    (?, ?)
  )

SELECT 1 as `exists`, `media_id`, `language_id` FROM `media_translation` WHERE (`media_id`,`language_id`) IN ((0xB8214F09EA9F44D39D9DAE527B96AD10,0x2FBB5FE2E29A4D70AA5854CE7CE3E20B));

#	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 300)
9	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
10	Shopware\Core\Framework\Context->scope (line 299)
11	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
13	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 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.16 ms
(0.55%)

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

Parameters:

[
  "{"mediaIds":["b8214f09ea9f44d39d9dae527b96ad10"],"context":{"extensions":[],"scope":"user","rulesLocked":false,"source":{"type":"admin-api","isAdmin":true,"permissions":[],"userId":null,"integrationId":"8c6764c3cdb549888459d01b8268ae08"},"ruleIds":[],"currencyId":"b7d2554b0ce847cd82f3ac9bd1c0dfca","languageIdChain":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"versionId":"0fa91ce3e96a4bc2be4bd9ce752c3425","currencyFactor":1.0,"considerInheritance":false,"taxState":"gross","rounding":{"extensions":[],"decimals":2,"interval":0.01,"roundForNet":true},"states":[]}}"
  "{"type":"Shopware\\Core\\Content\\Media\\Message\\GenerateThumbnailsMessage","X-Message-Stamp-Symfony\\Component\\Messenger\\Stamp\\BusNameStamp":"[{\"busName\":\"messenger.bus.default\"}]","Content-Type":"application\/json"}"
  "default"
  "2025-12-06 05:33:09"
  "2025-12-06 05:33:09"
]

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('{\"mediaIds\":[\"b8214f09ea9f44d39d9dae527b96ad10\"],\"context\":{\"extensions\":[],\"scope\":\"user\",\"rulesLocked\":false,\"source\":{\"type\":\"admin-api\",\"isAdmin\":true,\"permissions\":[],\"userId\":null,\"integrationId\":\"8c6764c3cdb549888459d01b8268ae08\"},\"ruleIds\":[],\"currencyId\":\"b7d2554b0ce847cd82f3ac9bd1c0dfca\",\"languageIdChain\":[\"2fbb5fe2e29a4d70aa5854ce7ce3e20b\"],\"versionId\":\"0fa91ce3e96a4bc2be4bd9ce752c3425\",\"currencyFactor\":1.0,\"considerInheritance\":false,\"taxState\":\"gross\",\"rounding\":{\"extensions\":[],\"decimals\":2,\"interval\":0.01,\"roundForNet\":true},\"states\":[]}}', '{\"type\":\"Shopware\\\\Core\\\\Content\\\\Media\\\\Message\\\\GenerateThumbnailsMessage\",\"X-Message-Stamp-Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\":\"[{\\\"busName\\\":\\\"messenger.bus.default\\\"}]\",\"Content-Type\":\"application\\/json\"}', 'default', '2025-12-06 05:33:09', '2025-12-06 05:33:09');

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 473)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 144)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 70)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 62)
6	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
8	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
9	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
10	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
11	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 47)
12	Shopware\Core\Framework\MessageQueue\Middleware\RoutingOverwriteMiddleware->handle (line 69)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 37)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 107)
15	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
16	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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.14 ms
(0.48%)

SELECT LOWER(HEX(id)) as array_key,
                    LOWER(HEX(id)) as id,
                    file_extension,
                    file_name,
                    uploaded_at
            FROM media
            WHERE id IN (?)

Parameters:

[
  b"©!O\tÛƒDËØØ«R{û¡\x10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(id)
  ) as array_key,
  LOWER(
    HEX(id)
  ) as id,
  file_extension,
  file_name,
  uploaded_at
FROM
  media
WHERE
  id IN (?)

SELECT LOWER(HEX(id)) as array_key,
                    LOWER(HEX(id)) as id,
                    file_extension,
                    file_name,
                    uploaded_at
            FROM media
            WHERE id IN (0xB8214F09EA9F44D39D9DAE527B96AD10);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 43)
3	Shopware\Core\Content\Media\Infrastructure\Path\SqlMediaLocationBuilder->media (line 46)
4	Shopware\Core\Content\Media\Core\Application\MediaPathUpdater->updateMedia (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 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 306)
12	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
13	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
14	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 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.14 ms
(0.47%)

SELECT 1 as `exists` FROM `media_translation` WHERE (`media_id` = ?) AND (`language_id` = ?)

Parameters:

[
  b"©!O\tÛƒDËØØ«R{û¡\x10"
  b"/»_ââšMpªXTÎ|ãâ\v"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 as `exists`
FROM
  `media_translation`
WHERE
  (`media_id` = ?)
  AND (`language_id` = ?)

SELECT 1 as `exists` FROM `media_translation` WHERE (`media_id` = 0xB8214F09EA9F44D39D9DAE527B96AD10) AND (`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 716)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->fetchFromDatabase (line 658)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->getCurrentState (line 82)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->getExistence (line 210)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 202)
7	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\TranslationsAssociationFieldSerializer->map (line 314)
8	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 224)
9	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 193)
10	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->write (line 139)
11	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->update (line 114)
12	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->update (line 96)
13	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 300)
14	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
15	Shopware\Core\Framework\Context->scope (line 299)
16	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
17	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
18	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 460)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 15)

0.14 ms
(0.47%)

UPDATE `media_translation` SET `media_id` = ?, `language_id` = ?, `updated_at` = ? WHERE media_id = ? AND language_id = ?

Parameters:

[
  b"©!O\tÛƒDËØØ«R{û¡\x10"
  b"/»_ââšMpªXTÎ|ãâ\v"
  "2025-12-06 05:33:09.101"
  b"©!O\tÛƒDËØØ«R{û¡\x10"
  b"/»_ââšMpªXTÎ|ãâ\v"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `media_translation`
SET
  `media_id` = ?,
  `language_id` = ?,
  `updated_at` = ?
WHERE
  media_id = ?
  AND language_id = ?

UPDATE `media_translation` SET `media_id` = 0xB8214F09EA9F44D39D9DAE527B96AD10, `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B, `updated_at` = '2025-12-06 05:33:09.101' WHERE media_id = 0xB8214F09EA9F44D39D9DAE527B96AD10 AND language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B;

#	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 300)
16	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
17	Shopware\Core\Framework\Context->scope (line 299)
18	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
19	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
20	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 262)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 276)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 156)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 15)

0.13 ms
(0.43%)

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.12 ms
(0.41%)

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)

0.12 ms
(0.39%)

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

Parameters:

[
  b"©!O\tÛƒDËØØ«R{û¡\x10"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT 1 as `exists`, `id` FROM `media` WHERE `id` IN (0xB8214F09EA9F44D39D9DAE527B96AD10);

#	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 300)
9	Shopware\Core\Content\Media\File\FileSaver->Shopware\Core\Content\Media\File\{closure} (line 161)
10	Shopware\Core\Framework\Context->scope (line 299)
11	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 55)
13	Shopware\Core\Content\Media\Api\MediaUploadController->upload (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 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)

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/media/b8214f09ea9f44d39d9dae527b96ad10/upload?_response=true&extension=JPG&fileName=4901249012

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache