Symfony Profiler

Query Metrics

53 Database Queries

35 Different statements

58.01 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

18.83 ms
(32.45%)

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"u&"ß-\rãE6´þ¢gñBƒ"
]

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 = 0x752622DF2D0DE34536B4FEA267F14283;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 133)
2	Doctrine\DBAL\Statement->executeStatement (line 19)
3	Shopware\Core\Framework\DataAbstractionLayer\Util\StatementHelper::executeStatement (line 27)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery->{closure:Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::execute():27} (line 59)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 27)
6	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery->execute (line 112)
7	Shopware\Core\Content\Media\DataAbstractionLayer\MediaIndexer->handle (line 60)
8	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->__invoke (line 243)
9	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->sendOrHandle (line 150)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 149)
19	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
20	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
21	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
22	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
23	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
24	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
27	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
33	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
34	Shopware\Core\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 10)

10.35 ms
(17.85%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 978)
2	Doctrine\DBAL\Connection->transactional (line 45)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
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 502)
9	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
10	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
11	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

6.98 ms
(12.04%)

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

Parameters:

[
  "path" => "media/74/3e/e6/1778741095/4662920_1.jpg"
  "id" => b"u&"ß-\rãE6´þ¢gñBƒ"
]

View formatted query View runnable query Explain query View query backtrace

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

UPDATE media SET path = 'media/74/3e/e6/1778741095/4662920_1.jpg' WHERE id = 0x752622DF2D0DE34536B4FEA267F14283;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 133)
2	Doctrine\DBAL\Statement->executeStatement (line 19)
3	Shopware\Core\Framework\DataAbstractionLayer\Util\StatementHelper::executeStatement (line 34)
4	Shopware\Core\Content\Media\Infrastructure\Path\SqlMediaPathStorage->media (line 58)
5	Shopware\Core\Content\Media\Core\Application\MediaPathUpdater->updateMedia (line 246)
6	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
9	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 302)
13	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
14	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

4.38 ms
(7.55%)

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

Parameters:

[
  null
  "image/jpeg"
  "jpg"
  "2026-05-14 06:44:55.819"
  "4662920_1"
  590411
  "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":1000,"height":1000,"type":2,"hash":"3c5776846603079e7c2b3e50d39c949f"}"
  "2026-05-14 06:44:55.821"
  b"u&"ß-\rãE6´þ¢gñBƒ"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `media`
SET
  `user_id` = ?,
  `mime_type` = ?,
  `file_extension` = ?,
  `uploaded_at` = ?,
  `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', `uploaded_at` = '2026-05-14 06:44:55.819', `file_name` = '4662920_1', `file_size` = 590411, `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\":1000,\"height\":1000,\"type\":2,\"hash\":\"3c5776846603079e7c2b3e50d39c949f\"}', `updated_at` = '2026-05-14 06:44:55.821' WHERE id = 0x752622DF2D0DE34536B4FEA267F14283;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 483)
2	Doctrine\DBAL\Connection->update (line 199)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():198} (line 59)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
8	Doctrine\DBAL\Connection->transactional (line 45)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
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 299)
16	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::updateMediaEntity():298} (line 201)
17	Shopware\Core\Framework\Context->scope (line 298)
18	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
19	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 10)

2.50 ms
(4.31%)

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 300)
2	Doctrine\DBAL\Connection->fetchAssociative (line 335)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getCashRounding (line 49)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
5	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
6	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
7	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
8	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
11	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->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 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

1.35 ms
(2.33%)

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`.`file_hash` as `media.fileHash`, `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` WHERE `media`.`id` IN (?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"u&"ß-\rãE6´þ¢gñBƒ"
]

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`.`file_hash` as `media.fileHash`,
  `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`
WHERE
  `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`.`file_hash` as `media.fileHash`, `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` WHERE `media`.`id` IN (0x752622DF2D0DE34536B4FEA267F14283);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 340)
9	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::findMediaById():338} (line 201)
10	Shopware\Core\Framework\Context->scope (line 338)
11	Shopware\Core\Content\Media\File\FileSaver->findMediaById (line 71)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

1.12 ms
(1.92%)

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"u&"ß-\rãE6´þ¢gñBƒ"
]

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 (0x752622DF2D0DE34536B4FEA267F14283);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 295)
3	Shopware\Core\Framework\Adapter\Cache\CacheInvalidationSubscriber->invalidateMedia (line 246)
4	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
7	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 118)
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 246)
16	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
19	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
20	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
21	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
22	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 149)
23	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
24	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
25	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
26	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
27	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
37	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
38	Shopware\Core\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 10)

1.02 ms
(1.76%)

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 638)
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 150)
6	Shopware\Core\Framework\Framework->boot (line 127)
7	Symfony\Component\HttpKernel\Kernel->boot (line 150)
8	Shopware\Core\Kernel->boot (line 126)
9	Shopware\Core\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 10)

0.90 ms
(1.56%)

SELECT LOWER(HEX(media.id)) as id,
                   media.file_name,
                   media.path,
                   GROUP_CONCAT(DISTINCT media_translation.alt SEPARATOR " ") as alt,
                   GROUP_CONCAT(DISTINCT media_translation.title SEPARATOR " ") as title,
                   media_folder.name,
                   GROUP_CONCAT(tag.name SEPARATOR " ") as tags
            FROM media
                INNER JOIN media_translation
                    ON media.id = media_translation.media_id
                LEFT JOIN media_folder
                    ON media.media_folder_id = media_folder.id
                LEFT JOIN media_tag
                    ON media.id = media_tag.media_id
                LEFT JOIN tag
                    ON media_tag.tag_id = tag.id
            WHERE media.id IN (?)
            GROUP BY media.id

Parameters:

[
  b"u&"ß-\rãE6´þ¢gñBƒ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(media.id)
  ) as id,
  media.file_name,
  media.path,
  GROUP_CONCAT(
    DISTINCT media_translation.alt SEPARATOR " "
  ) as alt,
  GROUP_CONCAT(
    DISTINCT media_translation.title SEPARATOR " "
  ) as title,
  media_folder.name,
  GROUP_CONCAT(tag.name SEPARATOR " ") as tags
FROM
  media
  INNER JOIN media_translation ON media.id = media_translation.media_id
  LEFT JOIN media_folder ON media.media_folder_id = media_folder.id
  LEFT JOIN media_tag ON media.id = media_tag.media_id
  LEFT JOIN tag ON media_tag.tag_id = tag.id
WHERE
  media.id IN (?)
GROUP BY
  media.id

SELECT LOWER(HEX(media.id)) as id,
                   media.file_name,
                   media.path,
                   GROUP_CONCAT(DISTINCT media_translation.alt SEPARATOR " ") as alt,
                   GROUP_CONCAT(DISTINCT media_translation.title SEPARATOR " ") as title,
                   media_folder.name,
                   GROUP_CONCAT(tag.name SEPARATOR " ") as tags
            FROM media
                INNER JOIN media_translation
                    ON media.id = media_translation.media_id
                LEFT JOIN media_folder
                    ON media.media_folder_id = media_folder.id
                LEFT JOIN media_tag
                    ON media.id = media_tag.media_id
                LEFT JOIN tag
                    ON media_tag.tag_id = tag.id
            WHERE media.id IN (0x752622DF2D0DE34536B4FEA267F14283)
            GROUP BY media.id
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 95)
3	Shopware\Elasticsearch\Admin\Indexer\MediaAdminSearchIndexer->fetch (line 239)
4	Shopware\Elasticsearch\Admin\AdminSearchRegistry->push (line 80)
5	Shopware\Elasticsearch\Admin\AdminSearchRegistry->__invoke (line 176)
6	Shopware\Elasticsearch\Admin\AdminSearchRegistry->refresh (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
9	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 98)
13	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 299)
14	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::updateMediaEntity():298} (line 201)
15	Shopware\Core\Framework\Context->scope (line 298)
16	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
17	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 10)

0.85 ms
(1.47%)

DELETE FROM `media_thumbnail` WHERE id = ?

Parameters:

[
  b"\x01ž \x04ŽÂqMŽv\x12B²qñ"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  `media_thumbnail`
WHERE
  id = ?

DELETE FROM `media_thumbnail` WHERE id = 0x019E20048EC2714D8E761242B271F190;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 402)
2	Doctrine\DBAL\Connection->delete (line 176)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():175} (line 59)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 175)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
8	Doctrine\DBAL\Connection->transactional (line 45)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 158)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->delete (line 126)
13	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->delete (line 138)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
15	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
16	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
17	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
18	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 10)

0.81 ms
(1.39%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 78)
3	Shopware\Core\Framework\Webhook\Service\WebhookLoader->getWebhooks (line 347)
4	Shopware\Core\Framework\Webhook\Service\WebhookManager->loadWebhooks (line 336)
5	Shopware\Core\Framework\Webhook\Service\WebhookManager->getWebhooks (line 97)
6	Shopware\Core\Framework\Webhook\Service\WebhookManager->callWebhooks (line 75)
7	Shopware\Core\Framework\Webhook\Service\WebhookManager->dispatch (line 34)
8	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
9	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 98)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 299)
11	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::updateMediaEntity():298} (line 201)
12	Shopware\Core\Framework\Context->scope (line 298)
13	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
14	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

0.80 ms
(1.37%)

SELECT LOWER(HEX(`media_id`)) FROM `media_thumbnail` WHERE `id` = ?

Parameters:

[
  b"\x01ž \x04ŽÂqMŽv\x12B²qñ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`media_id`)
  )
FROM
  `media_thumbnail`
WHERE
  `id` = ?

SELECT LOWER(HEX(`media_id`)) FROM `media_thumbnail` WHERE `id` = 0x019E20048EC2714D8E761242B271F190;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 589)
3	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriteResultFactory->fetchForeignKey (line 544)
4	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriteResultFactory->getPrimaryKeysOfFkField (line 211)
5	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriteResultFactory->resolveParents (line 61)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriteResultFactory->resolveDelete (line 151)
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 502)
10	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
11	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
12	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
13	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.70 ms
(1.21%)

SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`media_thumbnail_size_id` as `media_thumbnail.mediaThumbnailSizeId`, `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`, `media_thumbnail.media`.`id` as `media_thumbnail.media.id`, `media_thumbnail.media`.`user_id` as `media_thumbnail.media.userId`, `media_thumbnail.media`.`media_folder_id` as `media_thumbnail.media.mediaFolderId`, `media_thumbnail.media`.`mime_type` as `media_thumbnail.media.mimeType`, `media_thumbnail.media`.`file_extension` as `media_thumbnail.media.fileExtension`, `media_thumbnail.media`.`uploaded_at` as `media_thumbnail.media.uploadedAt`, `media_thumbnail.media`.`file_name` as `media_thumbnail.media.fileName`, `media_thumbnail.media`.`file_size` as `media_thumbnail.media.fileSize`, `media_thumbnail.media`.`media_type` as `media_thumbnail.media.mediaTypeRaw`, `media_thumbnail.media`.`meta_data` as `media_thumbnail.media.metaData`, `media_thumbnail.media`.`config` as `media_thumbnail.media.config`, `media_thumbnail.media`.`path` as `media_thumbnail.media.path`, `media_thumbnail.media`.`private` as `media_thumbnail.media.private`, `media_thumbnail.media`.`thumbnails_ro` as `media_thumbnail.media.thumbnailsRo`, `media_thumbnail.media`.`file_hash` as `media_thumbnail.media.fileHash`, `media_thumbnail.media`.`created_at` as `media_thumbnail.media.createdAt`, `media_thumbnail.media`.`updated_at` as `media_thumbnail.media.updatedAt`, `media_thumbnail.media.translation.title`, `media_thumbnail.media.translation.title` as `media_thumbnail.media.title`, `media_thumbnail.media.translation.alt`, `media_thumbnail.media.translation.alt` as `media_thumbnail.media.alt`, `media_thumbnail.media.translation.customFields`, `media_thumbnail.media.translation.customFields` as `media_thumbnail.media.customFields` FROM `media_thumbnail` LEFT JOIN `media` `media_thumbnail.media` ON `media_thumbnail`.`media_id` = `media_thumbnail.media`.`id` LEFT JOIN (SELECT `media_thumbnail.media.translation`.`media_id`, `media_thumbnail.media.translation`.`alt` as `media_thumbnail.media.translation.alt`, `media_thumbnail.media.translation`.`title` as `media_thumbnail.media.translation.title`, `media_thumbnail.media.translation`.`custom_fields` as `media_thumbnail.media.translation.customFields` FROM `media_translation` `media_thumbnail.media.translation` WHERE `media_thumbnail.media.translation`.`language_id` = ?) `media_thumbnail.media.media_translation` ON `media_thumbnail.media.media_translation`.`media_id` = `media_thumbnail.media`.`id` WHERE ((`media_thumbnail`.`id` IN (?, ?, ?, ?)))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ž \x04ŽÂqMŽv\x12B²qñ"
  b"\x01ž \x04ŽÂqMŽv\x12B³<s£"
  b"\x01ž \x04ŽÂqMŽv\x12B³ùÔŽ"
  b"\x01ž \x04ŽÂqMŽv\x12B³û*:"
]

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`.`media_thumbnail_size_id` as `media_thumbnail.mediaThumbnailSizeId`,
  `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`,
  `media_thumbnail.media`.`id` as `media_thumbnail.media.id`,
  `media_thumbnail.media`.`user_id` as `media_thumbnail.media.userId`,
  `media_thumbnail.media`.`media_folder_id` as `media_thumbnail.media.mediaFolderId`,
  `media_thumbnail.media`.`mime_type` as `media_thumbnail.media.mimeType`,
  `media_thumbnail.media`.`file_extension` as `media_thumbnail.media.fileExtension`,
  `media_thumbnail.media`.`uploaded_at` as `media_thumbnail.media.uploadedAt`,
  `media_thumbnail.media`.`file_name` as `media_thumbnail.media.fileName`,
  `media_thumbnail.media`.`file_size` as `media_thumbnail.media.fileSize`,
  `media_thumbnail.media`.`media_type` as `media_thumbnail.media.mediaTypeRaw`,
  `media_thumbnail.media`.`meta_data` as `media_thumbnail.media.metaData`,
  `media_thumbnail.media`.`config` as `media_thumbnail.media.config`,
  `media_thumbnail.media`.`path` as `media_thumbnail.media.path`,
  `media_thumbnail.media`.`private` as `media_thumbnail.media.private`,
  `media_thumbnail.media`.`thumbnails_ro` as `media_thumbnail.media.thumbnailsRo`,
  `media_thumbnail.media`.`file_hash` as `media_thumbnail.media.fileHash`,
  `media_thumbnail.media`.`created_at` as `media_thumbnail.media.createdAt`,
  `media_thumbnail.media`.`updated_at` as `media_thumbnail.media.updatedAt`,
  `media_thumbnail.media.translation.title`,
  `media_thumbnail.media.translation.title` as `media_thumbnail.media.title`,
  `media_thumbnail.media.translation.alt`,
  `media_thumbnail.media.translation.alt` as `media_thumbnail.media.alt`,
  `media_thumbnail.media.translation.customFields`,
  `media_thumbnail.media.translation.customFields` as `media_thumbnail.media.customFields`
FROM
  `media_thumbnail`
  LEFT JOIN `media` `media_thumbnail.media` ON `media_thumbnail`.`media_id` = `media_thumbnail.media`.`id`
  LEFT JOIN (
    SELECT
      `media_thumbnail.media.translation`.`media_id`,
      `media_thumbnail.media.translation`.`alt` as `media_thumbnail.media.translation.alt`,
      `media_thumbnail.media.translation`.`title` as `media_thumbnail.media.translation.title`,
      `media_thumbnail.media.translation`.`custom_fields` as `media_thumbnail.media.translation.customFields`
    FROM
      `media_translation` `media_thumbnail.media.translation`
    WHERE
      `media_thumbnail.media.translation`.`language_id` = ?
  ) `media_thumbnail.media.media_translation` ON `media_thumbnail.media.media_translation`.`media_id` = `media_thumbnail.media`.`id`
WHERE
  (
    (
      `media_thumbnail`.`id` IN (?, ?, ?, ?)
    )
  )

SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`media_thumbnail_size_id` as `media_thumbnail.mediaThumbnailSizeId`, `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`, `media_thumbnail.media`.`id` as `media_thumbnail.media.id`, `media_thumbnail.media`.`user_id` as `media_thumbnail.media.userId`, `media_thumbnail.media`.`media_folder_id` as `media_thumbnail.media.mediaFolderId`, `media_thumbnail.media`.`mime_type` as `media_thumbnail.media.mimeType`, `media_thumbnail.media`.`file_extension` as `media_thumbnail.media.fileExtension`, `media_thumbnail.media`.`uploaded_at` as `media_thumbnail.media.uploadedAt`, `media_thumbnail.media`.`file_name` as `media_thumbnail.media.fileName`, `media_thumbnail.media`.`file_size` as `media_thumbnail.media.fileSize`, `media_thumbnail.media`.`media_type` as `media_thumbnail.media.mediaTypeRaw`, `media_thumbnail.media`.`meta_data` as `media_thumbnail.media.metaData`, `media_thumbnail.media`.`config` as `media_thumbnail.media.config`, `media_thumbnail.media`.`path` as `media_thumbnail.media.path`, `media_thumbnail.media`.`private` as `media_thumbnail.media.private`, `media_thumbnail.media`.`thumbnails_ro` as `media_thumbnail.media.thumbnailsRo`, `media_thumbnail.media`.`file_hash` as `media_thumbnail.media.fileHash`, `media_thumbnail.media`.`created_at` as `media_thumbnail.media.createdAt`, `media_thumbnail.media`.`updated_at` as `media_thumbnail.media.updatedAt`, `media_thumbnail.media.translation.title`, `media_thumbnail.media.translation.title` as `media_thumbnail.media.title`, `media_thumbnail.media.translation.alt`, `media_thumbnail.media.translation.alt` as `media_thumbnail.media.alt`, `media_thumbnail.media.translation.customFields`, `media_thumbnail.media.translation.customFields` as `media_thumbnail.media.customFields` FROM `media_thumbnail` LEFT JOIN `media` `media_thumbnail.media` ON `media_thumbnail`.`media_id` = `media_thumbnail.media`.`id` LEFT JOIN (SELECT `media_thumbnail.media.translation`.`media_id`, `media_thumbnail.media.translation`.`alt` as `media_thumbnail.media.translation.alt`, `media_thumbnail.media.translation`.`title` as `media_thumbnail.media.translation.title`, `media_thumbnail.media.translation`.`custom_fields` as `media_thumbnail.media.translation.customFields` FROM `media_translation` `media_thumbnail.media.translation` WHERE `media_thumbnail.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media_thumbnail.media.media_translation` ON `media_thumbnail.media.media_translation`.`media_id` = `media_thumbnail.media`.`id` WHERE ((`media_thumbnail`.`id` IN (0x019E20048EC2714D8E761242B271F190, 0x019E20048EC2714D8E761242B33C73A3, 0x019E20048EC2714D8E761242B3F9D48E, 0x019E20048EC2714D8E761242B3FB2A3A)));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 209)
9	Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber->getThumbnails (line 177)
10	Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber->handleThumbnailDeletion (line 64)
11	Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber->beforeDelete (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 134)
19	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
20	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
21	Doctrine\DBAL\Connection->transactional (line 45)
22	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
23	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
24	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 158)
25	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->delete (line 126)
26	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->delete (line 138)
27	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
28	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
29	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
30	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
31	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
32	Shopware\Core\Content\Media\Api\MediaUploadController->upload (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
35	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
36	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
38	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
39	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
41	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
42	Shopware\Core\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 10)

0.67 ms
(1.15%)

INSERT INTO usage_data_entity_deletion (id, entity_name, entity_ids, deleted_at) VALUES(:id, :entity_name, :entity_ids, :deleted_at)

Parameters:

[
  ":id" => b"\x01ž%;-dsÐŽ\x1CB§‰TY%"
  ":entity_name" => "media_thumbnail"
  ":entity_ids" => "{"id":"019e20048ec2714d8e761242b271f190"}"
  ":deleted_at" => "2026-05-14 06:44:55.772"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO usage_data_entity_deletion (
  id, entity_name, entity_ids, deleted_at
)
VALUES
  (
    :id, :entity_name, :entity_ids, :deleted_at
  )

INSERT INTO usage_data_entity_deletion (id, entity_name, entity_ids, deleted_at) VALUES(:id, :entity_name, :entity_ids, :deleted_at);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 133)
2	Doctrine\DBAL\Statement->executeStatement (line 90)
3	Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber->storeDeletions (line 65)
4	Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber->{closure:Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber::handleEntityDeleteEvent():65} (line 122)
5	Shopware\Core\Framework\DataAbstractionLayer\Event\EntityDeleteEvent->success (line 232)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
8	Doctrine\DBAL\Connection->transactional (line 45)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 158)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->delete (line 126)
13	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->delete (line 138)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
15	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
16	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
17	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
18	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 10)

0.67 ms
(1.15%)

# 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 114)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 142)
4	Shopware\Core\Kernel->boot (line 126)
5	Shopware\Core\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 10)

0.65 ms
(1.13%)

SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`media_thumbnail_size_id` as `media_thumbnail.mediaThumbnailSizeId`, `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"u&"ß-\rãE6´þ¢gñBƒ"
]

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`.`media_thumbnail_size_id` as `media_thumbnail.mediaThumbnailSizeId`,
  `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`.`media_thumbnail_size_id` as `media_thumbnail.mediaThumbnailSizeId`, `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 (0x752622DF2D0DE34536B4FEA267F14283)));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 106)
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 246)
14	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
17	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
18	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
19	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
20	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 149)
21	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
22	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
23	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
24	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
25	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
35	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
36	Shopware\Core\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 10)

0.62 ms
(1.07%)

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`.`file_hash` as `media.fileHash`, `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"
  "4662920_1"
  "jpg"
  b"u&"ß-\rãE6´þ¢gñBƒ"
  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`.`file_hash` as `media.fileHash`,
  `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`.`file_hash` as `media.fileHash`, `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` = '4662920_1' AND `media`.`file_extension` = 'jpg' AND NOT (`media`.`id` <=> 0x752622DF2D0DE34536B4FEA267F14283)) AND (`media`.`private` = 0 OR (`media`.`private` = 1 AND `media.mediaFolder.defaultFolder`.`entity` = 'product_download')));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 427)
9	Shopware\Core\Content\Media\File\FileSaver->searchRelatedMediaByFileName (line 391)
10	Shopware\Core\Content\Media\File\FileSaver->ensureFileNameIsUnique (line 73)
11	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
22	Shopware\Core\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 10)

0.48 ms
(0.82%)

SELECT `id`, `privileges`
    FROM `acl_role`
    WHERE `id` IN (?)

Parameters:

[
  b"\x01œ×¶\x0EDq2N$NïD\x15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `id`,
  `privileges`
FROM
  `acl_role`
WHERE
  `id` IN (?)

SELECT `id`, `privileges`
    FROM `acl_role`
    WHERE `id` IN (0x019CD7B60E44718181324E244EEF4415);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 31)
3	Shopware\Core\Framework\Webhook\Service\WebhookLoader->getPrivilegesForRoles (line 328)
4	Shopware\Core\Framework\Webhook\Service\WebhookManager->loadPrivileges (line 110)
5	Shopware\Core\Framework\Webhook\Service\WebhookManager->callWebhooks (line 75)
6	Shopware\Core\Framework\Webhook\Service\WebhookManager->dispatch (line 34)
7	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
8	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 98)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->update (line 299)
10	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::updateMediaEntity():298} (line 201)
11	Shopware\Core\Framework\Context->scope (line 298)
12	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
13	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.43 ms
(0.75%)

DELETE FROM admin_elasticsearch_index_task WHERE `entity` IN (NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  admin_elasticsearch_index_task
WHERE
  `entity` IN (NULL)

DELETE FROM admin_elasticsearch_index_task WHERE `entity` IN (NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 344)
2	Shopware\Elasticsearch\Admin\AdminSearchRegistry->refreshIndices (line 142)
3	Shopware\Elasticsearch\Admin\AdminSearchRegistry->refresh (line 246)
4	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
7	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 149)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
12	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
13	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
14	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
15	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.36 ms
(0.62%)

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 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 34)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 63)
4	Shopware\Core\System\System->boot (line 127)
5	Symfony\Component\HttpKernel\Kernel->boot (line 150)
6	Shopware\Core\Kernel->boot (line 126)
7	Shopware\Core\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 10)

0.33 ms
(0.58%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 638)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 132)
3	Shopware\Core\System\CustomField\CustomFieldService->getCustomFields (line 54)
4	Shopware\Core\System\CustomField\CustomFieldService->getCustomField (line 101)
5	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->getFields (line 86)
6	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->decode (line 326)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->translate (line 68)
8	Shopware\Core\Content\Media\MediaHydrator->assign (line 590)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateEntity (line 95)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrate (line 135)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
13	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
15	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 340)
16	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::findMediaById():338} (line 201)
17	Shopware\Core\Framework\Context->scope (line 338)
18	Shopware\Core\Content\Media\File\FileSaver->findMediaById (line 71)
19	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 10)

0.32 ms
(0.56%)

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

Parameters:

[
  b"u&"ß-\rãE6´þ¢gñBƒ"
  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 ((0x752622DF2D0DE34536B4FEA267F14283,0x2FBB5FE2E29A4D70AA5854CE7CE3E20B));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 341)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetch (line 74)
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 299)
9	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::updateMediaEntity():298} (line 201)
10	Shopware\Core\Framework\Context->scope (line 298)
11	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

0.32 ms
(0.56%)

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"u&"ß-\rãE6´þ¢gñBƒ"
]

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 (0x752622DF2D0DE34536B4FEA267F14283);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 655)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 45)
3	Shopware\Core\Content\Media\Infrastructure\Path\SqlMediaLocationBuilder->media (line 46)
4	Shopware\Core\Content\Media\Core\Application\MediaPathUpdater->updateMedia (line 246)
5	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
8	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 302)
12	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
13	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.31 ms
(0.54%)

SELECT `alias`, `index` FROM admin_elasticsearch_index_task

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `alias`,
  `index`
FROM
  admin_elasticsearch_index_task

SELECT `alias`, `index` FROM admin_elasticsearch_index_task;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 638)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 151)
3	Shopware\Elasticsearch\Admin\AdminSearchRegistry->refresh (line 246)
4	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
7	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 149)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
12	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
13	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
14	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
15	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.29 ms
(0.50%)

SELECT admin FROM `integration` WHERE id = ?

Parameters:

[
  b"\x01›ÛÛÿh}ÑŽ%š³ÐoWÌ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  admin
FROM
  `integration`
WHERE
  id = ?

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 304)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->isAdminIntegration (line 285)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 169)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
8	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
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 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.27 ms
(0.47%)

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

Parameters:

[
  b"\x01›ÛÛÿh}ÑŽ%š³ÐoWÌ"
]

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` = 0x019BDBDBFF687DD18D259AB3D06F57CC
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 365)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->fetchPermissionsIntegrationByApp (line 261)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 169)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
8	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
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 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.24 ms
(0.42%)

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"\x01›ÛÛÿh}ÑŽ%š³ÐoWÌ"
]

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 = 0x019BDBDBFF687DD18D259AB3D06F57CC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 390)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->fetchIntegrationPermissions (line 286)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 169)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
8	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
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 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.23 ms
(0.40%)

SELECT id FROM integration WHERE access_key = ?

Parameters:

[
  "SWIAAVYYDXPOT09WCLDDBZFNQW"
]

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 = 'SWIAAVYYDXPOT09WCLDDBZFNQW';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 250)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getIntegrationIdByAccessKey (line 161)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
6	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
7	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
9	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
12	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->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 466)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

0.23 ms
(0.40%)

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

Parameters:

[
  b"u&"ß-\rãE6´þ¢gñBƒ"
  b"/»_ââšMpªXTÎ|ãâ\v"
  "2026-05-14 06:44:55.821"
  b"u&"ß-\rãE6´þ¢gñBƒ"
  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` = 0x752622DF2D0DE34536B4FEA267F14283, `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B, `updated_at` = '2026-05-14 06:44:55.821' WHERE media_id = 0x752622DF2D0DE34536B4FEA267F14283 AND language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 483)
2	Doctrine\DBAL\Connection->update (line 199)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():198} (line 59)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
8	Doctrine\DBAL\Connection->transactional (line 45)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
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 299)
16	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::updateMediaEntity():298} (line 201)
17	Shopware\Core\Framework\Context->scope (line 298)
18	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
19	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 10)

0.23 ms
(0.39%)

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

Parameters:

[
  b"\x01ž \x04ŽÂqMŽv\x12B²qñ"
  b"\x01ž \x04ŽÂqMŽv\x12B³<s£"
  b"\x01ž \x04ŽÂqMŽv\x12B³ùÔŽ"
  b"\x01ž \x04ŽÂqMŽv\x12B³û*:"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT 1 as `exists`, `id` FROM `media_thumbnail` WHERE `id` IN (0x019E20048EC2714D8E761242B271F190,0x019E20048EC2714D8E761242B33C73A3,0x019E20048EC2714D8E761242B3F9D48E,0x019E20048EC2714D8E761242B3FB2A3A);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 341)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetch (line 74)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetchExistences (line 404)
5	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->extractDeleteCommands (line 155)
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 502)
9	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
10	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
11	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

0.21 ms
(0.36%)

"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 959)
2	Doctrine\DBAL\Connection->transactional (line 45)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
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 502)
9	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
10	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
11	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

0.21 ms
(0.36%)

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

Parameters:

[
  b"u&"ß-\rãE6´þ¢gñBƒ"
  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` = 0x752622DF2D0DE34536B4FEA267F14283) AND (`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 716)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->fetchFromDatabase (line 660)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->getCurrentState (line 85)
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 299)
14	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::updateMediaEntity():298} (line 201)
15	Shopware\Core\Framework\Context->scope (line 298)
16	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
17	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 10)

0.21 ms
(0.36%)

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

Parameters:

[
  b"u&"ß-\rãE6´þ¢gñBƒ"
]

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 (0x752622DF2D0DE34536B4FEA267F14283);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 341)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetch (line 74)
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 299)
9	Shopware\Core\Content\Media\File\FileSaver->{closure:Shopware\Core\Content\Media\File\FileSaver::updateMediaEntity():298} (line 201)
10	Shopware\Core\Framework\Context->scope (line 298)
11	Shopware\Core\Content\Media\File\FileSaver->updateMediaEntity (line 88)
12	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

0.08 ms
(0.13%)

SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 1173)
2	Doctrine\DBAL\Connection->createSavepoint (line 1063)
3	Doctrine\DBAL\Connection->beginTransaction (line 79)
4	Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber->storeDeletions (line 65)
5	Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber->{closure:Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber::handleEntityDeleteEvent():65} (line 122)
6	Shopware\Core\Framework\DataAbstractionLayer\Event\EntityDeleteEvent->success (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
9	Doctrine\DBAL\Connection->transactional (line 45)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
11	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 158)
13	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->delete (line 126)
14	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->delete (line 138)
15	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
16	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
17	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
18	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
19	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 10)

0.05 ms
(0.09%)

RELEASE SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 1195)
2	Doctrine\DBAL\Connection->releaseSavepoint (line 1088)
3	Doctrine\DBAL\Connection->commit (line 93)
4	Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber->storeDeletions (line 65)
5	Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber->{closure:Shopware\Core\System\UsageData\Subscriber\EntityDeleteSubscriber::handleEntityDeleteEvent():65} (line 122)
6	Shopware\Core\Framework\DataAbstractionLayer\Event\EntityDeleteEvent->success (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
9	Doctrine\DBAL\Connection->transactional (line 45)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
11	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 158)
13	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->delete (line 126)
14	Shopware\Core\Framework\DataAbstractionLayer\VersionManager->delete (line 138)
15	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->delete (line 502)
16	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteAssociatedThumbnails (line 198)
17	Shopware\Core\Content\Media\Thumbnail\ThumbnailService->deleteThumbnails (line 238)
18	Shopware\Core\Content\Media\File\FileSaver->removeOldMediaData (line 82)
19	Shopware\Core\Content\Media\File\FileSaver->persistFileToMedia (line 57)
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 466)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 10)

Database Connections

Name	Service
0	default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

POST https://sw6staging.behr-labor.eu/api/_action/media/752622df2d0de34536b4fea267f14283/upload?extension=jpg&fileName=4662920_1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache