Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

44 Database Queries

Different statements

23.15 ms Query time

Invalid entities

Queries

Group similar statements


# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = :key
# 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`;
SELECT custom_entity.name, custom_entity.fields
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT last_updated_password_at FROM user WHERE id = :userId
SELECT item_rounding FROM currency WHERE id = :id
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = :userId
SELECT admin FROM `user` WHERE id = :id
SELECT 1 as `exists`, `media_id`, `language_id` FROM `media_translation` WHERE (`media_id`,`language_id`) IN ((?,?))
SELECT 1 as `exists`, `id` FROM `media` WHERE `id` IN (?)
SELECT LOWER(HEX(`media.productDownloads`.`id`)) as id FROM `media` `media` LEFT JOIN `product_download` `media.productDownloads` ON `media`.`id` = `media.productDownloads`.`media_id` WHERE (`media.productDownloads`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.orderLineItemDownloads`.`id`)) as id FROM `media` `media` LEFT JOIN `order_line_item_download` `media.orderLineItemDownloads` ON `media`.`id` = `media.orderLineItemDownloads`.`media_id` WHERE (`media.orderLineItemDownloads`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.cmsBlocks`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_block` `media.cmsBlocks` ON `media`.`id` = `media.cmsBlocks`.`background_media_id` WHERE (`media.cmsBlocks`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.cmsSections`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_section` `media.cmsSections` ON `media`.`id` = `media.cmsSections`.`background_media_id` WHERE (`media.cmsSections`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.cmsPages`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_page` `media.cmsPages` ON `media`.`id` = `media.cmsPages`.`preview_media_id` WHERE (`media.cmsPages`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.documents`.`id`)) as id FROM `media` `media` LEFT JOIN `document` `media.documents` ON `media`.`id` = `media.documents`.`document_media_file_id` WHERE (`media.documents`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.translations`.`media_id`)) as mediaId, LOWER(HEX(`media.translations`.`language_id`)) as languageId FROM `media` `media` LEFT JOIN `media_translation` `media.translations` ON `media`.`id` = `media.translations`.`media_id` WHERE (`media.translations`.`media_id` IS NOT NULL) AND (`media.translations`.`language_id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.thumbnails`.`id`)) as id FROM `media` `media` LEFT JOIN `media_thumbnail` `media.thumbnails` ON `media`.`id` = `media.thumbnails`.`media_id` WHERE (`media.thumbnails`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.productMedia`.`id`)) as id FROM `media` `media` LEFT JOIN `product_media` `media.productMedia` ON `media`.`id` = `media.productMedia`.`media_id` WHERE (`media.productMedia`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.avatarUser`.`id`)) as id FROM `media` `media` LEFT JOIN `user` `media.avatarUser` ON `media`.`id` = `media.avatarUser`.`avatar_id` WHERE (`media.avatarUser`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.mailTemplateMedia`.`id`)) as id FROM `media` `media` LEFT JOIN `mail_template_media` `media.mailTemplateMedia` ON `media`.`id` = `media.mailTemplateMedia`.`media_id` WHERE (`media.mailTemplateMedia`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.categories`.`id`)) as id FROM `media` `media` LEFT JOIN `category` `media.categories` ON `media`.`id` = `media.categories`.`media_id` WHERE (`media.categories`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.productManufacturers`.`id`)) as id FROM `media` `media` LEFT JOIN `product_manufacturer` `media.productManufacturers` ON `media`.`id` = `media.productManufacturers`.`media_id` WHERE (`media.productManufacturers`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.propertyGroupOptions`.`id`)) as id FROM `media` `media` LEFT JOIN `property_group_option` `media.propertyGroupOptions` ON `media`.`id` = `media.propertyGroupOptions`.`media_id` WHERE (`media.propertyGroupOptions`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.documentBaseConfigs`.`id`)) as id FROM `media` `media` LEFT JOIN `document_base_config` `media.documentBaseConfigs` ON `media`.`id` = `media.documentBaseConfigs`.`logo_id` WHERE (`media.documentBaseConfigs`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.shippingMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `shipping_method` `media.shippingMethods` ON `media`.`id` = `media.shippingMethods`.`media_id` WHERE (`media.shippingMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.paymentMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `payment_method` `media.paymentMethods` ON `media`.`id` = `media.paymentMethods`.`media_id` WHERE (`media.paymentMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.productConfiguratorSettings`.`id`)) as id FROM `media` `media` LEFT JOIN `product_configurator_setting` `media.productConfiguratorSettings` ON `media`.`id` = `media.productConfiguratorSettings`.`media_id` WHERE (`media.productConfiguratorSettings`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.orderLineItems`.`id`)) as id FROM `media` `media` LEFT JOIN `order_line_item` `media.orderLineItems` ON `media`.`id` = `media.orderLineItems`.`cover_id` WHERE (`media.orderLineItems`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(`media.appPaymentMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `app_payment_method` `media.appPaymentMethods` ON `media`.`id` = `media.appPaymentMethods`.`original_media_id` WHERE (`media.appPaymentMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids))
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id
"START TRANSACTION"
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`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = :languageId) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` WHERE `media`.`id` IN (:ids)
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_7c7f1e5e354a46629422e3637da11253)
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
DELETE FROM `media` WHERE id = ?
"COMMIT"
SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`width` as `media_thumbnail.width`, `media_thumbnail`.`height` as `media_thumbnail.height`, `media_thumbnail`.`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 (:param_db77a1be5b704915a1d1aa81a328b8fe))
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_301a09dd0c704077afbf1cb7c656ecd7)
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`

#▲	Time	Info
1	0.21 ms	# cache-id-loader SELECT `value` FROM app_config WHERE `key` = :key View formatted query View runnable query View query stack # cache-id-loader SELECT `value` FROM app_config WHERE `key` = : key # cache-id-loader SELECT `value` FROM app_config WHERE `key` = 'cache-id'; array:7 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 734)" 2 => "Doctrine\DBAL\Connection::fetchOne (line 39)" 3 => "Shopware\Core\Framework\Adapter\Cache\CacheIdLoader::load (line 187)" 4 => "Shopware\Core\HttpKernel::createKernel (line 128)" 5 => "Shopware\Core\HttpKernel::doHandle (line 81)" 6 => "Shopware\Core\HttpKernel::handle (line 85)"`]
2	0.14 ms	# 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`; View formatted query View runnable query View query stack # 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`;; array:7 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 41)" 2 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader::loadPluginInfos (line 100)" 3 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader::initializePlugins (line 179)" 4 => "Shopware\Core\Kernel::boot (line 129)" 5 => "Shopware\Core\HttpKernel::doHandle (line 81)" 6 => "Shopware\Core\HttpKernel::handle (line 85)"`]
3	0.17 ms	SELECT custom_entity.name, custom_entity.fields FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1 View formatted query View runnable query View query stack SELECT custom_entity.name, custom_entity.fields FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1 SELECT custom_entity.name, custom_entity.fields FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1 ; array:8 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)" 2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 38)" 3 => "Shopware\Core\System\CustomEntity\CustomEntityRegistrar::register (line 57)" 4 => "Shopware\Core\System\System::boot (line 194)" 5 => "Shopware\Core\Kernel::boot (line 129)" 6 => "Shopware\Core\HttpKernel::doHandle (line 81)" 7 => "Shopware\Core\HttpKernel::handle (line 85)"`]
4	0.09 ms	SELECT `creation_timestamp` FROM `migration` WHERE `update` IS NOT NULL AND `update_destructive` IS NULL View formatted query View runnable query View query stack SELECT `creation_timestamp` FROM `migration` WHERE `update` IS NOT NULL AND `update_destructive` IS NULL SELECT `creation_timestamp` FROM `migration` WHERE `update` IS NOT NULL AND `update_destructive` IS NULL ; array:6 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 377)" 2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 197)" 3 => "Shopware\Core\Kernel::boot (line 129)" 4 => "Shopware\Core\HttpKernel::doHandle (line 81)" 5 => "Shopware\Core\HttpKernel::handle (line 85)"`]
5	0.21 ms	SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')) View formatted query View runnable query View query stack SET @@group_concat_max_len = CAST( IF( @@group_concat_max_len > 320000, @@group_concat_max_len, 320000 ) AS UNSIGNED ); SET sql_mode =( SELECT REPLACE( @@sql_mode, 'ONLY_FULL_GROUP_BY', '' ) ) SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); array:6 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 398)" 2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 197)" 3 => "Shopware\Core\Kernel::boot (line 129)" 4 => "Shopware\Core\HttpKernel::doHandle (line 81)" 5 => "Shopware\Core\HttpKernel::handle (line 85)"`]
6	0.16 ms	SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC View formatted query View runnable query View query stack SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC; array:13 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 54)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 38)" 4 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::Shopware\Core\System\SystemConfig\{closure} (line 72)" 5 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::doGet (line 35)" 6 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::get (line 43)" 7 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 39)" 8 => "Shopware\Core\System\SystemConfig\MemoizedSystemConfigLoader::load (line 83)" 9 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 38)" 10 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 140)" 11 => "Shopware\Core\HttpKernel::doHandle (line 81)" 12 => "Shopware\Core\HttpKernel::handle (line 85)"]
7	0.76 ms	SELECT last_updated_password_at FROM user WHERE id = :userId View formatted query View runnable query View query stack SELECT last_updated_password_at FROM user WHERE id = : userId SELECT last_updated_password_at FROM user WHERE id = 0x39E754B650534020943E72215DD5ABD7; array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 68)" 3 => "Shopware\Core\Framework\Api\OAuth\BearerTokenValidator::validateAccessTokenIssuedAt (line 52)" 4 => "Shopware\Core\Framework\Api\OAuth\BearerTokenValidator::validateAuthorization (line 84)" 5 => "League\OAuth2\Server\ResourceServer::validateAuthenticatedRequest (line 107)" 6 => "Shopware\Core\Framework\Api\EventListener\Authentication\ApiAuthenticationListener::validateRequest (line 117)" 7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 151)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 23 => "Shopware\Core\HttpKernel::doHandle (line 81)" 24 => "Shopware\Core\HttpKernel::handle (line 85)"]
8	0.15 ms	SELECT item_rounding FROM currency WHERE id = :id View formatted query View runnable query View query stack SELECT item_rounding FROM currency WHERE id = : id SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA; array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 684)" 2 => "Doctrine\DBAL\Connection::fetchAssociative (line 329)" 3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getCashRounding (line 56)" 4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 70)" 5 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 38)" 6 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)" 7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 151)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 23 => "Shopware\Core\HttpKernel::doHandle (line 81)" 24 => "Shopware\Core\HttpKernel::handle (line 85)"]
9	0.16 ms	SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = :userId View formatted query View runnable query View query stack SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = : userId SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0x39E754B650534020943E72215DD5ABD7; array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 313)" 3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::fetchPermissions (line 273)" 4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getAdminApiSource (line 148)" 5 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolveContextSource (line 59)" 6 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 70)" 7 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 38)" 8 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)" 9 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 10 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 11 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 12 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 13 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 14 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 15 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 16 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 151)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
10	0.14 ms	SELECT admin FROM `user` WHERE id = :id View formatted query View runnable query View query stack SELECT admin FROM `user` WHERE id = : id SELECT admin FROM `user` WHERE id = 0x39E754B650534020943E72215DD5ABD7; array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 734)" 2 => "Doctrine\DBAL\Connection::fetchOne (line 293)" 3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::isAdmin (line 274)" 4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getAdminApiSource (line 148)" 5 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolveContextSource (line 59)" 6 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 70)" 7 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 38)" 8 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)" 9 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 10 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 11 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 12 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 13 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 14 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 15 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 16 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 151)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
11	0.56 ms	SELECT 1 as `exists`, `media_id`, `language_id` FROM `media_translation` WHERE (`media_id`,`language_id`) IN ((?,?)) View formatted query View runnable query View query stack 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 ((0x8883761C7CD64E658173E680E082D056,0x2FBB5FE2E29A4D70AA5854CE7CE3E20B)); array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 371)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::prefetch (line 90)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::prefetchExistences (line 439)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 9 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 11 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 12 => "Shopware\Core\Framework\Context::scope (line 881)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 23 => "Shopware\Core\HttpKernel::doHandle (line 81)" 24 => "Shopware\Core\HttpKernel::handle (line 85)"]
12	0.33 ms	SELECT 1 as `exists`, `id` FROM `media` WHERE `id` IN (?) View formatted query View runnable query View query stack SELECT 1 as `exists`, `id` FROM `media` WHERE `id` IN (?) SELECT 1 as `exists`, `id` FROM `media` WHERE `id` IN (0x8883761C7CD64E658173E680E082D056); array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 371)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::prefetch (line 90)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::prefetchExistences (line 439)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 9 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 11 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 12 => "Shopware\Core\Framework\Context::scope (line 881)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 23 => "Shopware\Core\HttpKernel::doHandle (line 81)" 24 => "Shopware\Core\HttpKernel::handle (line 85)"]
13	0.57 ms	SELECT LOWER(HEX(`media.productDownloads`.`id`)) as id FROM `media` `media` LEFT JOIN `product_download` `media.productDownloads` ON `media`.`id` = `media.productDownloads`.`media_id` WHERE (`media.productDownloads`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.productDownloads`.`id`) ) as id FROM `media` `media` LEFT JOIN `product_download` `media.productDownloads` ON `media`.`id` = `media.productDownloads`.`media_id` WHERE ( `media.productDownloads`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.productDownloads`.`id`)) as id FROM `media` `media` LEFT JOIN `product_download` `media.productDownloads` ON `media`.`id` = `media.productDownloads`.`media_id` WHERE (`media.productDownloads`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:26 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 69)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeleteRestrictions (line 444)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 10 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 13 => "Shopware\Core\Framework\Context::scope (line 881)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 18 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 19 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 24 => "Shopware\Core\HttpKernel::doHandle (line 81)" 25 => "Shopware\Core\HttpKernel::handle (line 85)"]
14	0.58 ms	SELECT LOWER(HEX(`media.orderLineItemDownloads`.`id`)) as id FROM `media` `media` LEFT JOIN `order_line_item_download` `media.orderLineItemDownloads` ON `media`.`id` = `media.orderLineItemDownloads`.`media_id` WHERE (`media.orderLineItemDownloads`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX( `media.orderLineItemDownloads`.`id` ) ) as id FROM `media` `media` LEFT JOIN `order_line_item_download` `media.orderLineItemDownloads` ON `media`.`id` = `media.orderLineItemDownloads`.`media_id` WHERE ( `media.orderLineItemDownloads`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.orderLineItemDownloads`.`id`)) as id FROM `media` `media` LEFT JOIN `order_line_item_download` `media.orderLineItemDownloads` ON `media`.`id` = `media.orderLineItemDownloads`.`media_id` WHERE (`media.orderLineItemDownloads`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:26 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 69)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeleteRestrictions (line 444)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 10 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 13 => "Shopware\Core\Framework\Context::scope (line 881)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 18 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 19 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 24 => "Shopware\Core\HttpKernel::doHandle (line 81)" 25 => "Shopware\Core\HttpKernel::handle (line 85)"]
15	0.64 ms	SELECT LOWER(HEX(`media.cmsBlocks`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_block` `media.cmsBlocks` ON `media`.`id` = `media.cmsBlocks`.`background_media_id` WHERE (`media.cmsBlocks`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.cmsBlocks`.`id`) ) as id FROM `media` `media` LEFT JOIN `cms_block` `media.cmsBlocks` ON `media`.`id` = `media.cmsBlocks`.`background_media_id` WHERE ( `media.cmsBlocks`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.cmsBlocks`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_block` `media.cmsBlocks` ON `media`.`id` = `media.cmsBlocks`.`background_media_id` WHERE (`media.cmsBlocks`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:26 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 69)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeleteRestrictions (line 444)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 10 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 13 => "Shopware\Core\Framework\Context::scope (line 881)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 18 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 19 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 24 => "Shopware\Core\HttpKernel::doHandle (line 81)" 25 => "Shopware\Core\HttpKernel::handle (line 85)"]
16	0.52 ms	SELECT LOWER(HEX(`media.cmsSections`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_section` `media.cmsSections` ON `media`.`id` = `media.cmsSections`.`background_media_id` WHERE (`media.cmsSections`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.cmsSections`.`id`) ) as id FROM `media` `media` LEFT JOIN `cms_section` `media.cmsSections` ON `media`.`id` = `media.cmsSections`.`background_media_id` WHERE ( `media.cmsSections`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.cmsSections`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_section` `media.cmsSections` ON `media`.`id` = `media.cmsSections`.`background_media_id` WHERE (`media.cmsSections`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:26 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 69)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeleteRestrictions (line 444)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 10 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 13 => "Shopware\Core\Framework\Context::scope (line 881)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 18 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 19 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 24 => "Shopware\Core\HttpKernel::doHandle (line 81)" 25 => "Shopware\Core\HttpKernel::handle (line 85)"]
17	0.56 ms	SELECT LOWER(HEX(`media.cmsPages`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_page` `media.cmsPages` ON `media`.`id` = `media.cmsPages`.`preview_media_id` WHERE (`media.cmsPages`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.cmsPages`.`id`) ) as id FROM `media` `media` LEFT JOIN `cms_page` `media.cmsPages` ON `media`.`id` = `media.cmsPages`.`preview_media_id` WHERE (`media.cmsPages`.`id` IS NOT NULL) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.cmsPages`.`id`)) as id FROM `media` `media` LEFT JOIN `cms_page` `media.cmsPages` ON `media`.`id` = `media.cmsPages`.`preview_media_id` WHERE (`media.cmsPages`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:26 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 69)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeleteRestrictions (line 444)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 10 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 13 => "Shopware\Core\Framework\Context::scope (line 881)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 18 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 19 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 24 => "Shopware\Core\HttpKernel::doHandle (line 81)" 25 => "Shopware\Core\HttpKernel::handle (line 85)"]
18	0.56 ms	SELECT LOWER(HEX(`media.documents`.`id`)) as id FROM `media` `media` LEFT JOIN `document` `media.documents` ON `media`.`id` = `media.documents`.`document_media_file_id` WHERE (`media.documents`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.documents`.`id`) ) as id FROM `media` `media` LEFT JOIN `document` `media.documents` ON `media`.`id` = `media.documents`.`document_media_file_id` WHERE ( `media.documents`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.documents`.`id`)) as id FROM `media` `media` LEFT JOIN `document` `media.documents` ON `media`.`id` = `media.documents`.`document_media_file_id` WHERE (`media.documents`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:26 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 69)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeleteRestrictions (line 444)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 10 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 13 => "Shopware\Core\Framework\Context::scope (line 881)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 18 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 19 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 24 => "Shopware\Core\HttpKernel::doHandle (line 81)" 25 => "Shopware\Core\HttpKernel::handle (line 85)"]
19	0.73 ms	SELECT LOWER(HEX(`media.translations`.`media_id`)) as mediaId, LOWER(HEX(`media.translations`.`language_id`)) as languageId FROM `media` `media` LEFT JOIN `media_translation` `media.translations` ON `media`.`id` = `media.translations`.`media_id` WHERE (`media.translations`.`media_id` IS NOT NULL) AND (`media.translations`.`language_id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX( `media.translations`.`media_id` ) ) as mediaId, LOWER( HEX( `media.translations`.`language_id` ) ) as languageId FROM `media` `media` LEFT JOIN `media_translation` `media.translations` ON `media`.`id` = `media.translations`.`media_id` WHERE ( `media.translations`.`media_id` IS NOT NULL ) AND ( `media.translations`.`language_id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.translations`.`media_id`)) as mediaId, LOWER(HEX(`media.translations`.`language_id`)) as languageId FROM `media` `media` LEFT JOIN `media_translation` `media.translations` ON `media`.`id` = `media.translations`.`media_id` WHERE (`media.translations`.`media_id` IS NOT NULL) AND (`media.translations`.`language_id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 92)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeletes (line 310)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addDeleteCascadeCommands (line 488)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
20	0.48 ms	SELECT LOWER(HEX(`media.thumbnails`.`id`)) as id FROM `media` `media` LEFT JOIN `media_thumbnail` `media.thumbnails` ON `media`.`id` = `media.thumbnails`.`media_id` WHERE (`media.thumbnails`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.thumbnails`.`id`) ) as id FROM `media` `media` LEFT JOIN `media_thumbnail` `media.thumbnails` ON `media`.`id` = `media.thumbnails`.`media_id` WHERE ( `media.thumbnails`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.thumbnails`.`id`)) as id FROM `media` `media` LEFT JOIN `media_thumbnail` `media.thumbnails` ON `media`.`id` = `media.thumbnails`.`media_id` WHERE (`media.thumbnails`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 92)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeletes (line 310)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addDeleteCascadeCommands (line 488)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
21	0.45 ms	SELECT LOWER(HEX(`media.productMedia`.`id`)) as id FROM `media` `media` LEFT JOIN `product_media` `media.productMedia` ON `media`.`id` = `media.productMedia`.`media_id` WHERE (`media.productMedia`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.productMedia`.`id`) ) as id FROM `media` `media` LEFT JOIN `product_media` `media.productMedia` ON `media`.`id` = `media.productMedia`.`media_id` WHERE ( `media.productMedia`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.productMedia`.`id`)) as id FROM `media` `media` LEFT JOIN `product_media` `media.productMedia` ON `media`.`id` = `media.productMedia`.`media_id` WHERE (`media.productMedia`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 92)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeletes (line 310)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addDeleteCascadeCommands (line 488)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
22	0.43 ms	SELECT LOWER(HEX(`media.avatarUser`.`id`)) as id FROM `media` `media` LEFT JOIN `user` `media.avatarUser` ON `media`.`id` = `media.avatarUser`.`avatar_id` WHERE (`media.avatarUser`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.avatarUser`.`id`) ) as id FROM `media` `media` LEFT JOIN `user` `media.avatarUser` ON `media`.`id` = `media.avatarUser`.`avatar_id` WHERE ( `media.avatarUser`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.avatarUser`.`id`)) as id FROM `media` `media` LEFT JOIN `user` `media.avatarUser` ON `media`.`id` = `media.avatarUser`.`avatar_id` WHERE (`media.avatarUser`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 92)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeletes (line 310)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addDeleteCascadeCommands (line 488)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
23	0.43 ms	SELECT LOWER(HEX(`media.mailTemplateMedia`.`id`)) as id FROM `media` `media` LEFT JOIN `mail_template_media` `media.mailTemplateMedia` ON `media`.`id` = `media.mailTemplateMedia`.`media_id` WHERE (`media.mailTemplateMedia`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.mailTemplateMedia`.`id`) ) as id FROM `media` `media` LEFT JOIN `mail_template_media` `media.mailTemplateMedia` ON `media`.`id` = `media.mailTemplateMedia`.`media_id` WHERE ( `media.mailTemplateMedia`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.mailTemplateMedia`.`id`)) as id FROM `media` `media` LEFT JOIN `mail_template_media` `media.mailTemplateMedia` ON `media`.`id` = `media.mailTemplateMedia`.`media_id` WHERE (`media.mailTemplateMedia`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 92)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedDeletes (line 310)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addDeleteCascadeCommands (line 488)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
24	0.52 ms	SELECT LOWER(HEX(`media.categories`.`id`)) as id FROM `media` `media` LEFT JOIN `category` `media.categories` ON `media`.`id` = `media.categories`.`media_id` WHERE (`media.categories`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.categories`.`id`) ) as id FROM `media` `media` LEFT JOIN `category` `media.categories` ON `media`.`id` = `media.categories`.`media_id` WHERE ( `media.categories`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.categories`.`id`)) as id FROM `media` `media` LEFT JOIN `category` `media.categories` ON `media`.`id` = `media.categories`.`media_id` WHERE (`media.categories`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
25	0.54 ms	SELECT LOWER(HEX(`media.productManufacturers`.`id`)) as id FROM `media` `media` LEFT JOIN `product_manufacturer` `media.productManufacturers` ON `media`.`id` = `media.productManufacturers`.`media_id` WHERE (`media.productManufacturers`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX( `media.productManufacturers`.`id` ) ) as id FROM `media` `media` LEFT JOIN `product_manufacturer` `media.productManufacturers` ON `media`.`id` = `media.productManufacturers`.`media_id` WHERE ( `media.productManufacturers`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.productManufacturers`.`id`)) as id FROM `media` `media` LEFT JOIN `product_manufacturer` `media.productManufacturers` ON `media`.`id` = `media.productManufacturers`.`media_id` WHERE (`media.productManufacturers`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
26	0.48 ms	SELECT LOWER(HEX(`media.propertyGroupOptions`.`id`)) as id FROM `media` `media` LEFT JOIN `property_group_option` `media.propertyGroupOptions` ON `media`.`id` = `media.propertyGroupOptions`.`media_id` WHERE (`media.propertyGroupOptions`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX( `media.propertyGroupOptions`.`id` ) ) as id FROM `media` `media` LEFT JOIN `property_group_option` `media.propertyGroupOptions` ON `media`.`id` = `media.propertyGroupOptions`.`media_id` WHERE ( `media.propertyGroupOptions`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.propertyGroupOptions`.`id`)) as id FROM `media` `media` LEFT JOIN `property_group_option` `media.propertyGroupOptions` ON `media`.`id` = `media.propertyGroupOptions`.`media_id` WHERE (`media.propertyGroupOptions`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
27	0.47 ms	SELECT LOWER(HEX(`media.documentBaseConfigs`.`id`)) as id FROM `media` `media` LEFT JOIN `document_base_config` `media.documentBaseConfigs` ON `media`.`id` = `media.documentBaseConfigs`.`logo_id` WHERE (`media.documentBaseConfigs`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX( `media.documentBaseConfigs`.`id` ) ) as id FROM `media` `media` LEFT JOIN `document_base_config` `media.documentBaseConfigs` ON `media`.`id` = `media.documentBaseConfigs`.`logo_id` WHERE ( `media.documentBaseConfigs`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.documentBaseConfigs`.`id`)) as id FROM `media` `media` LEFT JOIN `document_base_config` `media.documentBaseConfigs` ON `media`.`id` = `media.documentBaseConfigs`.`logo_id` WHERE (`media.documentBaseConfigs`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
28	0.43 ms	SELECT LOWER(HEX(`media.shippingMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `shipping_method` `media.shippingMethods` ON `media`.`id` = `media.shippingMethods`.`media_id` WHERE (`media.shippingMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.shippingMethods`.`id`) ) as id FROM `media` `media` LEFT JOIN `shipping_method` `media.shippingMethods` ON `media`.`id` = `media.shippingMethods`.`media_id` WHERE ( `media.shippingMethods`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.shippingMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `shipping_method` `media.shippingMethods` ON `media`.`id` = `media.shippingMethods`.`media_id` WHERE (`media.shippingMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
29	0.48 ms	SELECT LOWER(HEX(`media.paymentMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `payment_method` `media.paymentMethods` ON `media`.`id` = `media.paymentMethods`.`media_id` WHERE (`media.paymentMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.paymentMethods`.`id`) ) as id FROM `media` `media` LEFT JOIN `payment_method` `media.paymentMethods` ON `media`.`id` = `media.paymentMethods`.`media_id` WHERE ( `media.paymentMethods`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.paymentMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `payment_method` `media.paymentMethods` ON `media`.`id` = `media.paymentMethods`.`media_id` WHERE (`media.paymentMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
30	0.45 ms	SELECT LOWER(HEX(`media.productConfiguratorSettings`.`id`)) as id FROM `media` `media` LEFT JOIN `product_configurator_setting` `media.productConfiguratorSettings` ON `media`.`id` = `media.productConfiguratorSettings`.`media_id` WHERE (`media.productConfiguratorSettings`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX( `media.productConfiguratorSettings`.`id` ) ) as id FROM `media` `media` LEFT JOIN `product_configurator_setting` `media.productConfiguratorSettings` ON `media`.`id` = `media.productConfiguratorSettings`.`media_id` WHERE ( `media.productConfiguratorSettings`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.productConfiguratorSettings`.`id`)) as id FROM `media` `media` LEFT JOIN `product_configurator_setting` `media.productConfiguratorSettings` ON `media`.`id` = `media.productConfiguratorSettings`.`media_id` WHERE (`media.productConfiguratorSettings`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
31	0.53 ms	SELECT LOWER(HEX(`media.orderLineItems`.`id`)) as id FROM `media` `media` LEFT JOIN `order_line_item` `media.orderLineItems` ON `media`.`id` = `media.orderLineItems`.`cover_id` WHERE (`media.orderLineItems`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.orderLineItems`.`id`) ) as id FROM `media` `media` LEFT JOIN `order_line_item` `media.orderLineItems` ON `media`.`id` = `media.orderLineItems`.`cover_id` WHERE ( `media.orderLineItems`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.orderLineItems`.`id`)) as id FROM `media` `media` LEFT JOIN `order_line_item` `media.orderLineItems` ON `media`.`id` = `media.orderLineItems`.`cover_id` WHERE (`media.orderLineItems`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
32	0.50 ms	SELECT LOWER(HEX(`media.appPaymentMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `app_payment_method` `media.appPaymentMethods` ON `media`.`id` = `media.appPaymentMethods`.`original_media_id` WHERE (`media.appPaymentMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT LOWER( HEX(`media.appPaymentMethods`.`id`) ) as id FROM `media` `media` LEFT JOIN `app_payment_method` `media.appPaymentMethods` ON `media`.`id` = `media.appPaymentMethods`.`original_media_id` WHERE ( `media.appPaymentMethods`.`id` IS NOT NULL ) AND ( `media`.`id` IN (: ids) ) SELECT LOWER(HEX(`media.appPaymentMethods`.`id`)) as id FROM `media` `media` LEFT JOIN `app_payment_method` `media.appPaymentMethods` ON `media`.`id` = `media.appPaymentMethods`.`original_media_id` WHERE (`media.appPaymentMethods`.`id` IS NOT NULL) AND (`media`.`id` IN (0x8883761C7CD64E658173E680E082D056)); array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 244)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetchAssociation (line 167)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::fetch (line 109)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityForeignKeyResolver::getAffectedSetNulls (line 340)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::addSetNullOnDeletesCommands (line 490)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::extractDeleteCommands (line 191)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
33	0.12 ms	SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id View formatted query View runnable query View query stack SELECT LOWER( HEX(language.id) ) AS array_key, LOWER( HEX(language.id) ) AS id, locale.code, LOWER( HEX(language.parent_id) ) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id; array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 267)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 34)" 3 => "Shopware\Core\System\Language\LanguageLoader::loadLanguages (line 49)" 4 => "Shopware\Core\System\Language\CachedLanguageLoader::Shopware\Core\System\Language\{closure} (line 72)" 5 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::doGet (line 35)" 6 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::get (line 50)" 7 => "Shopware\Core\System\Language\CachedLanguageLoader::loadLanguages (line 193)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 14 => "Shopware\Core\Framework\Context::scope (line 881)" 15 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 16 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 25 => "Shopware\Core\HttpKernel::doHandle (line 81)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
34	0.12 ms	"START TRANSACTION" View formatted query View runnable query View query stack "START TRANSACTION" "START TRANSACTION"; array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1743)" 1 => "Doctrine\DBAL\Connection::beginTransaction (line 1668)" 2 => "Doctrine\DBAL\Connection::transactional (line 34)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 21)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 127)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 194)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 9 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 11 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 12 => "Shopware\Core\Framework\Context::scope (line 881)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 23 => "Shopware\Core\HttpKernel::doHandle (line 81)" 24 => "Shopware\Core\HttpKernel::handle (line 85)"]
35	1.45 ms	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`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = :languageId) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` WHERE `media`.`id` IN (:ids) View formatted query View runnable query View query stack 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`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE( `media.translation.title`, `media.translation.title` ) as `media.title`, `media.translation.alt`, COALESCE( `media.translation.alt`, `media.translation.alt` ) as `media.alt`, `media.translation.customFields`, COALESCE( `media.translation.customFields`, `media.translation.customFields` ) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN ( SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = : languageId ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` WHERE `media`.`id` IN (: ids) 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`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` WHERE `media`.`id` IN (0x8883761C7CD64E658173E680E082D056); array:48 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 316)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 148)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 93)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 257)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 286)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 106)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 59)" 9 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::search (line 51)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::search (line 136)" 11 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::Shopware\Core\Content\Media\Subscriber\{closure} (line 223)" 12 => "Shopware\Core\Framework\Context::scope (line 137)" 13 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::handleMediaDeletion (line 126)" 14 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::beforeDelete (line 117)" 15 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 16 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 17 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 18 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 19 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 20 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 153)" 23 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands (line 126)" 24 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1670)" 25 => "Doctrine\DBAL\Connection::transactional (line 34)" 26 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 21)" 27 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 127)" 28 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 194)" 29 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 30 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 31 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 32 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 33 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 34 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 35 => "Shopware\Core\Framework\Context::scope (line 881)" 36 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 37 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 38 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 39 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 40 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 41 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 42 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 43 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 44 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 45 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 46 => "Shopware\Core\HttpKernel::doHandle (line 81)" 47 => "Shopware\Core\HttpKernel::handle (line 85)"]
36	2.45 ms	# app-scripts::refresh::read SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_7c7f1e5e354a46629422e3637da11253) View formatted query View runnable query View query stack # app-scripts::refresh::read SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE( `app.translation.label`, `app.translation.label` ) as `app.label`, `app.translation.description`, COALESCE( `app.translation.description`, `app.translation.description` ) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE( `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE( `app.translation.customFields`, `app.translation.customFields` ) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN ( SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = : languageId ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE ( `app`.`active` = : param_7c7f1e5e354a46629422e3637da11253 ) # app-scripts::refresh::read SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1); array:63 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 316)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 148)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 93)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 257)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 286)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 110)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 59)" 9 => "Shopware\Core\Profiling\Profiler::trace (line 111)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 51)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::search (line 119)" 12 => "Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister::refresh (line 73)" 13 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 57)" 14 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 71)" 15 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 33)" 16 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (line 117)" 17 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 19 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 20 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 21 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 22 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 23 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 24 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 200)" 25 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 50)" 26 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaThumbnailRepositoryDecorator::delete (line 71)" 27 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 167)" 28 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::handleMediaDeletion (line 126)" 29 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::beforeDelete (line 117)" 30 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 31 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 32 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 33 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 34 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 35 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 36 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 37 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 153)" 38 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands (line 126)" 39 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1670)" 40 => "Doctrine\DBAL\Connection::transactional (line 34)" 41 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 21)" 42 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 127)" 43 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 194)" 44 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 45 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 46 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 47 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 48 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 49 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 50 => "Shopware\Core\Framework\Context::scope (line 881)" 51 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 52 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 53 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 54 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 55 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 56 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 57 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 58 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 59 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 60 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 61 => "Shopware\Core\HttpKernel::doHandle (line 81)" 62 => "Shopware\Core\HttpKernel::handle (line 85)"]
37	0.13 ms	SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` View formatted query View runnable query View query stack SELECT LOWER( HEX(`script`.`app_id`) ) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL( `script`.`updated_at`, `script`.`created_at` ) AS lastModified, `app`.`name` AS appName, LOWER( HEX(`app`.`integration_id`) ) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` ; array:53 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)" 2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 76)" 3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 57)" 4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 71)" 5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 33)" 6 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (line 117)" 7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 200)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 50)" 16 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaThumbnailRepositoryDecorator::delete (line 71)" 17 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 167)" 18 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::handleMediaDeletion (line 126)" 19 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::beforeDelete (line 117)" 20 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 21 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 22 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 23 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 24 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 25 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 26 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 27 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 153)" 28 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands (line 126)" 29 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1670)" 30 => "Doctrine\DBAL\Connection::transactional (line 34)" 31 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 21)" 32 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 127)" 33 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 194)" 34 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 35 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 36 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 37 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 38 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 39 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 40 => "Shopware\Core\Framework\Context::scope (line 881)" 41 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 42 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 43 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 44 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 45 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 46 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 47 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 48 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 49 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 50 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 51 => "Shopware\Core\HttpKernel::doHandle (line 81)" 52 => "Shopware\Core\HttpKernel::handle (line 85)"]
38	0.14 ms	SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` View formatted query View runnable query View query stack SELECT LOWER( HEX(`script`.`app_id`) ) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER( HEX(`app`.`integration_id`) ) AS integrationId, IFNULL( `script`.`updated_at`, `script`.`created_at` ) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` ; array:53 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)" 2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 92)" 3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 57)" 4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 71)" 5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 33)" 6 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (line 117)" 7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 200)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 50)" 16 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaThumbnailRepositoryDecorator::delete (line 71)" 17 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 167)" 18 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::handleMediaDeletion (line 126)" 19 => "Shopware\Core\Content\Media\Subscriber\MediaDeletionSubscriber::beforeDelete (line 117)" 20 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 21 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 22 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 23 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 24 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 25 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 26 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 27 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 153)" 28 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands (line 126)" 29 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1670)" 30 => "Doctrine\DBAL\Connection::transactional (line 34)" 31 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 21)" 32 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 127)" 33 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 194)" 34 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 35 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 36 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 37 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 38 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 39 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 40 => "Shopware\Core\Framework\Context::scope (line 881)" 41 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 42 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 43 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 44 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 45 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 46 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 47 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 48 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 49 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 50 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 51 => "Shopware\Core\HttpKernel::doHandle (line 81)" 52 => "Shopware\Core\HttpKernel::handle (line 85)"]
39	1.94 ms	DELETE FROM `media` WHERE id = ? View formatted query View runnable query View query stack DELETE FROM `media` WHERE id = ? DELETE FROM `media` WHERE id = 0x8883761C7CD64E658173E680E082D056; array:31 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1546)" 1 => "Doctrine\DBAL\Connection::executeStatement (line 819)" 2 => "Doctrine\DBAL\Connection::delete (line 194)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 122)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 99)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 195)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands (line 126)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1670)" 8 => "Doctrine\DBAL\Connection::transactional (line 34)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 21)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 127)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 194)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 13 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 14 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 15 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 16 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 17 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 18 => "Shopware\Core\Framework\Context::scope (line 881)" 19 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 20 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 29 => "Shopware\Core\HttpKernel::doHandle (line 81)" 30 => "Shopware\Core\HttpKernel::handle (line 85)"]
40	0.38 ms	"COMMIT" View formatted query View runnable query View query stack "COMMIT" "COMMIT"; array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1789)" 1 => "Doctrine\DBAL\Connection::commit (line 1671)" 2 => "Doctrine\DBAL\Connection::transactional (line 34)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 21)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 127)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 194)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::delete (line 158)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::delete (line 189)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 9 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 11 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 12 => "Shopware\Core\Framework\Context::scope (line 881)" 13 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 14 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 23 => "Shopware\Core\HttpKernel::doHandle (line 81)" 24 => "Shopware\Core\HttpKernel::handle (line 85)"]
41	0.26 ms	SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`width` as `media_thumbnail.width`, `media_thumbnail`.`height` as `media_thumbnail.height`, `media_thumbnail`.`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 (:param_db77a1be5b704915a1d1aa81a328b8fe)) View formatted query View runnable query View query stack SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`width` as `media_thumbnail.width`, `media_thumbnail`.`height` as `media_thumbnail.height`, `media_thumbnail`.`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 ( : param_db77a1be5b704915a1d1aa81a328b8fe ) ) SELECT `media_thumbnail`.`id` as `media_thumbnail.id`, `media_thumbnail`.`media_id` as `media_thumbnail.mediaId`, `media_thumbnail`.`width` as `media_thumbnail.width`, `media_thumbnail`.`height` as `media_thumbnail.height`, `media_thumbnail`.`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 (0x8883761C7CD64E658173E680E082D056)); array:41 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 316)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 148)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 93)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 257)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 286)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 106)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 70)" 9 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaThumbnailRepositoryDecorator::search (line 51)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::search (line 113)" 11 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaIndexer::handle (line 166)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry::handle (line 242)" 13 => "Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry::sendOrHandle (line 140)" 14 => "Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry::refresh (line 30)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber::refreshIndex (line 117)" 16 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 17 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 19 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 20 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 21 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 22 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 23 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 200)" 24 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 25 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 26 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 27 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 28 => "Shopware\Core\Framework\Context::scope (line 881)" 29 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 30 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 31 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 32 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 33 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 34 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 35 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 38 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 39 => "Shopware\Core\HttpKernel::doHandle (line 81)" 40 => "Shopware\Core\HttpKernel::handle (line 85)"]
42	2.49 ms	# app-scripts::refresh::read SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_301a09dd0c704077afbf1cb7c656ecd7) View formatted query View runnable query View query stack # app-scripts::refresh::read SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE( `app.translation.label`, `app.translation.label` ) as `app.label`, `app.translation.description`, COALESCE( `app.translation.description`, `app.translation.description` ) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE( `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE( `app.translation.customFields`, `app.translation.customFields` ) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN ( SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = : languageId ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE ( `app`.`active` = : param_301a09dd0c704077afbf1cb7c656ecd7 ) # app-scripts::refresh::read SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1); array:42 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 238)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 316)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 148)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 93)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 257)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 286)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 110)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 59)" 9 => "Shopware\Core\Profiling\Profiler::trace (line 111)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 51)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::search (line 119)" 12 => "Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister::refresh (line 73)" 13 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 57)" 14 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 71)" 15 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 33)" 16 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (line 117)" 17 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 19 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 20 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 21 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 22 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 23 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 24 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 200)" 25 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 26 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 27 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 28 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 29 => "Shopware\Core\Framework\Context::scope (line 881)" 30 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 31 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 32 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 33 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 34 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 35 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 38 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 39 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 40 => "Shopware\Core\HttpKernel::doHandle (line 81)" 41 => "Shopware\Core\HttpKernel::handle (line 85)"]
43	0.13 ms	SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` View formatted query View runnable query View query stack SELECT LOWER( HEX(`script`.`app_id`) ) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL( `script`.`updated_at`, `script`.`created_at` ) AS lastModified, `app`.`name` AS appName, LOWER( HEX(`app`.`integration_id`) ) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` ; array:32 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)" 2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 76)" 3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 57)" 4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 71)" 5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 33)" 6 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (line 117)" 7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 200)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 16 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 17 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 18 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 19 => "Shopware\Core\Framework\Context::scope (line 881)" 20 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 21 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 22 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 23 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 24 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 25 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 30 => "Shopware\Core\HttpKernel::doHandle (line 81)" 31 => "Shopware\Core\HttpKernel::handle (line 85)"]
44	0.11 ms	SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` View formatted query View runnable query View query stack SELECT LOWER( HEX(`script`.`app_id`) ) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER( HEX(`app`.`integration_id`) ) AS integrationId, IFNULL( `script`.`updated_at`, `script`.`created_at` ) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name` ; array:32 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)" 2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 92)" 3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 57)" 4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 71)" 5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 33)" 6 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (line 117)" 7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 200)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::delete (line 37)" 16 => "Shopware\Core\Content\Media\DataAbstractionLayer\MediaRepositoryDecorator::delete (line 71)" 17 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::delete (line 871)" 18 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 223)" 19 => "Shopware\Core\Framework\Context::scope (line 881)" 20 => "Shopware\Core\Framework\Api\Controller\ApiController::executeWriteOperation (line 423)" 21 => "Shopware\Core\Framework\Api\Controller\ApiController::delete (line 163)" 22 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 23 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 24 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 25 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 156)" 30 => "Shopware\Core\HttpKernel::doHandle (line 81)" 31 => "Shopware\Core\HttpKernel::handle (line 85)"]

Database Connections

There are no configured database connections.

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

https://sieber-gaindorf.server13.zwei.gmbh/api/media/8883761c7cd64e658173e680e082d056 Return to referer URL

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://sieber-gaindorf.server13.zwei.gmbh/api/media/8883761c7cd64e658173e680e082d056 Return to referer URL

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping