Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

25 Database Queries

Different statements

165.28 ms Query time

Invalid entities

Queries

Group similar statements


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',''));SET @MIGRATION_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1536765935_IS_ACTIVE = TRUE;SET @MIGRATION_1536765936_IS_ACTIVE = TRUE;SET @MIGRATION_1536765937_IS_ACTIVE = TRUE;SET @MIGRATION_1536765938_IS_ACTIVE = TRUE;SET @MIGRATION_1538046469_IS_ACTIVE = TRUE;SET @MIGRATION_1538985581_IS_ACTIVE = TRUE;SET @MIGRATION_1544535797_IS_ACTIVE = TRUE;SET @MIGRATION_1563456847_IS_ACTIVE = TRUE;SET @MIGRATION_1564041870_IS_ACTIVE = TRUE;SET @MIGRATION_1564053392_IS_ACTIVE = TRUE;SET @MIGRATION_1568882302_IS_ACTIVE = TRUE;SET @MIGRATION_1568882317_IS_ACTIVE = TRUE;SET @MIGRATION_1587476616_IS_ACTIVE = TRUE;SET @MIGRATION_1589448383_IS_ACTIVE = TRUE;SET @MIGRATION_1593494859_IS_ACTIVE = TRUE;SET @MIGRATION_1593508853_IS_ACTIVE = TRUE;SET @MIGRATION_1615794849_IS_ACTIVE = TRUE;SET @MIGRATION_1644753635_IS_ACTIVE = TRUE;SET @MIGRATION_1652444730_IS_ACTIVE = TRUE;SET @MIGRATION_1669117848_IS_ACTIVE = TRUE;SET @MIGRATION_1669796049_IS_ACTIVE = TRUE;SET @MIGRATION_1678106061_IS_ACTIVE = TRUE;SET @MIGRATION_1559416986_IS_ACTIVE = TRUE;SET @MIGRATION_1602739765_IS_ACTIVE = TRUE;SET @MIGRATION_1604519670_IS_ACTIVE = TRUE;SET @MIGRATION_1604520733_IS_ACTIVE = TRUE;SET @MIGRATION_1605031477_IS_ACTIVE = TRUE;SET @MIGRATION_1612160298_IS_ACTIVE = TRUE
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = :language_id) AND ((sales_channel_id = :sales_channel_id OR sales_channel_id IS NULL)) AND (seo_path_info = :seoPath) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`.*, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = :languageId) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = :param_1a5a235d3f1e4a7caeeb2cb9776730f4)
SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = :salesChannelId) AND (token = :token) LIMIT 1
# context-factory::base-context

        SELECT
          sales_channel.id as sales_channel_id,
          sales_channel.language_id as sales_channel_default_language_id,
          sales_channel.currency_id as sales_channel_currency_id,
          currency.factor as sales_channel_currency_factor,
          currency.decimal_precision as sales_channel_currency_decimal_precision,
          GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids
        FROM sales_channel
            INNER JOIN currency
                ON sales_channel.currency_id = currency.id
            LEFT JOIN sales_channel_language
                ON sales_channel_language.sales_channel_id = sales_channel.id
        WHERE sales_channel.id = :id
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
#cart-persister::load
            SELECT `cart`.`cart` FROM cart WHERE `token` = :token
SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC
SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC
SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC
SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.category_translation`.*, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = :languageId) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` WHERE (`category`.`version_id` = :version) AND ((`category`.`id` = :param_2dad259fc61c498da011a026c68edd9b))
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.media_translation`.*, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.category_translation`.*, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = :languageId) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = :languageId) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = :version) AND ((`category`.`parent_id` IN (:param_bd854b558f1f41538f5b901335929174))) ORDER BY `category`.`level` ASC
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`.*, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = :languageId) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = :param_4d94bfcbfaa24894b28bf839fc3da76b)
# category::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.cms_page_translation`.*, COALESCE(`cms_page.translation.name`,`cms_page.translation.name`) as `cms_page.name`, COALESCE(`cms_page.translation.customFields`,`cms_page.translation.customFields`) as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.name as `cms_page.translation.name`, `cms_page.translation`.custom_fields as `cms_page.translation.customFields`, `cms_page.translation`.created_at as `cms_page.translation.createdAt`, `cms_page.translation`.updated_at as `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id as `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id as `cms_page.translation.languageId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = :languageId) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` WHERE `cms_page`.`id` IN (:ids)
# category::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.media_translation`.*, COALESCE(`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, COALESCE(`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, COALESCE(`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at as `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at as `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id as `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id as `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = :languageId) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`cms_page_id` IN (:param_099e8091e9134bddafed051f39253593))
# category::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.media_translation`.*, COALESCE(`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, COALESCE(`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, COALESCE(`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at as `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at as `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id as `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id as `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = :languageId) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`cms_section_id` IN (:param_27d6093e79404475a1d58a7aa688d6ab))
# category::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.cms_slot_translation`.*, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = :languageId) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` WHERE (`cms_slot`.`version_id` = :version) AND ((`cms_slot`.`cms_block_id` IN (:param_0a7c48c96ff14234bd4897a7b25d454c)))
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.category_translation`.*, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = :languageId) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` WHERE (`category`.`version_id` = :version) AND (`category`.`id` IN (:ids))
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = :param_cfed938931a14c87b10bfbe7cdfb6329) ORDER BY `product_sorting`.`priority` DESC
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.product_sorting_translation`.*, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = :languageId) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (:ids)

#▲	Time	Info
1	5.31 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 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 334)" 4 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 156)" 5 => "Shopware\Core\Kernel::boot (line 136)" 6 => "Shopware\Core\HttpKernel::doHandle (line 80)" 7 => "Shopware\Core\HttpKernel::handle (line 86)"`]
2	4.57 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',''));SET @MIGRATION_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1536765935_IS_ACTIVE = TRUE;SET @MIGRATION_1536765936_IS_ACTIVE = TRUE;SET @MIGRATION_1536765937_IS_ACTIVE = TRUE;SET @MIGRATION_1536765938_IS_ACTIVE = TRUE;SET @MIGRATION_1538046469_IS_ACTIVE = TRUE;SET @MIGRATION_1538985581_IS_ACTIVE = TRUE;SET @MIGRATION_1544535797_IS_ACTIVE = TRUE;SET @MIGRATION_1563456847_IS_ACTIVE = TRUE;SET @MIGRATION_1564041870_IS_ACTIVE = TRUE;SET @MIGRATION_1564053392_IS_ACTIVE = TRUE;SET @MIGRATION_1568882302_IS_ACTIVE = TRUE;SET @MIGRATION_1568882317_IS_ACTIVE = TRUE;SET @MIGRATION_1587476616_IS_ACTIVE = TRUE;SET @MIGRATION_1589448383_IS_ACTIVE = TRUE;SET @MIGRATION_1593494859_IS_ACTIVE = TRUE;SET @MIGRATION_1593508853_IS_ACTIVE = TRUE;SET @MIGRATION_1615794849_IS_ACTIVE = TRUE;SET @MIGRATION_1644753635_IS_ACTIVE = TRUE;SET @MIGRATION_1652444730_IS_ACTIVE = TRUE;SET @MIGRATION_1669117848_IS_ACTIVE = TRUE;SET @MIGRATION_1669796049_IS_ACTIVE = TRUE;SET @MIGRATION_1678106061_IS_ACTIVE = TRUE;SET @MIGRATION_1559416986_IS_ACTIVE = TRUE;SET @MIGRATION_1602739765_IS_ACTIVE = TRUE;SET @MIGRATION_1604519670_IS_ACTIVE = TRUE;SET @MIGRATION_1604520733_IS_ACTIVE = TRUE;SET @MIGRATION_1605031477_IS_ACTIVE = TRUE;SET @MIGRATION_1612160298_IS_ACTIVE = TRUE 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 @MIGRATION_1590758953_IS_ACTIVE = TRUE; SET @MIGRATION_1591683158_IS_ACTIVE = TRUE; SET @MIGRATION_1592837424_IS_ACTIVE = TRUE; SET @MIGRATION_1593698606_IS_ACTIVE = TRUE; SET @MIGRATION_1595160327_IS_ACTIVE = TRUE; SET @MIGRATION_1595321666_IS_ACTIVE = TRUE; SET @MIGRATION_1595422169_IS_ACTIVE = TRUE; SET @MIGRATION_1595489705_IS_ACTIVE = TRUE; SET @MIGRATION_1595492052_IS_ACTIVE = TRUE; SET @MIGRATION_1595492053_IS_ACTIVE = TRUE; SET @MIGRATION_1595578253_IS_ACTIVE = TRUE; SET @MIGRATION_1595919251_IS_ACTIVE = TRUE; SET @MIGRATION_1596091744_IS_ACTIVE = TRUE; SET @MIGRATION_1596441551_IS_ACTIVE = TRUE; SET @MIGRATION_1597391970_IS_ACTIVE = TRUE; SET @MIGRATION_1597394241_IS_ACTIVE = TRUE; SET @MIGRATION_1597657689_IS_ACTIVE = TRUE; SET @MIGRATION_1597762808_IS_ACTIVE = TRUE; SET @MIGRATION_1597830237_IS_ACTIVE = TRUE; SET @MIGRATION_1597930227_IS_ACTIVE = TRUE; SET @MIGRATION_1598280548_IS_ACTIVE = TRUE; SET @MIGRATION_1598520424_IS_ACTIVE = TRUE; SET @MIGRATION_1598885384_IS_ACTIVE = TRUE; SET @MIGRATION_1599112309_IS_ACTIVE = TRUE; SET @MIGRATION_1599134496_IS_ACTIVE = TRUE; SET @MIGRATION_1599463278_IS_ACTIVE = TRUE; SET @MIGRATION_1599570560_IS_ACTIVE = TRUE; SET @MIGRATION_1599720163_IS_ACTIVE = TRUE; SET @MIGRATION_1599806584_IS_ACTIVE = TRUE; SET @MIGRATION_1599806595_IS_ACTIVE = TRUE; SET @MIGRATION_1599822061_IS_ACTIVE = TRUE; SET @MIGRATION_1600072779_IS_ACTIVE = TRUE; SET @MIGRATION_1600156989_IS_ACTIVE = TRUE; SET @MIGRATION_1600253602_IS_ACTIVE = TRUE; SET @MIGRATION_1600330846_IS_ACTIVE = TRUE; SET @MIGRATION_1600338271_IS_ACTIVE = TRUE; SET @MIGRATION_1600349343_IS_ACTIVE = TRUE; SET @MIGRATION_1600676671_IS_ACTIVE = TRUE; SET @MIGRATION_1600769357_IS_ACTIVE = TRUE; SET @MIGRATION_1600778848_IS_ACTIVE = TRUE; SET @MIGRATION_1601451838_IS_ACTIVE = TRUE; SET @MIGRATION_1601539530_IS_ACTIVE = TRUE; SET @MIGRATION_1601543829_IS_ACTIVE = TRUE; SET @MIGRATION_1601891339_IS_ACTIVE = TRUE; SET @MIGRATION_1602062376_IS_ACTIVE = TRUE; SET @MIGRATION_1602146868_IS_ACTIVE = TRUE; SET @MIGRATION_1602153572_IS_ACTIVE = TRUE; SET @MIGRATION_1602494493_IS_ACTIVE = TRUE; SET @MIGRATION_1602494495_IS_ACTIVE = TRUE; SET @MIGRATION_1602745374_IS_ACTIVE = TRUE; SET @MIGRATION_1602822727_IS_ACTIVE = TRUE; SET @MIGRATION_1603179023_IS_ACTIVE = TRUE; SET @MIGRATION_1603293043_IS_ACTIVE = TRUE; SET @MIGRATION_1603970276_IS_ACTIVE = TRUE; SET @MIGRATION_1604056363_IS_ACTIVE = TRUE; SET @MIGRATION_1604056421_IS_ACTIVE = TRUE; SET @MIGRATION_1604475913_IS_ACTIVE = TRUE; SET @MIGRATION_1604499476_IS_ACTIVE = TRUE; SET @MIGRATION_1604568928_IS_ACTIVE = TRUE; SET @MIGRATION_1604669773_IS_ACTIVE = TRUE; SET @MIGRATION_1605103533_IS_ACTIVE = TRUE; SET @MIGRATION_1605530777_IS_ACTIVE = TRUE; SET @MIGRATION_1605609309_IS_ACTIVE = TRUE; SET @MIGRATION_1605609477_IS_ACTIVE = TRUE; SET @MIGRATION_1605861407_IS_ACTIVE = TRUE; SET @MIGRATION_1606310257_IS_ACTIVE = TRUE; SET @MIGRATION_1607415095_IS_ACTIVE = TRUE; SET @MIGRATION_1607500561_IS_ACTIVE = TRUE; SET @MIGRATION_1607514878_IS_ACTIVE = TRUE; SET @MIGRATION_1607581275_IS_ACTIVE = TRUE; SET @MIGRATION_1607581276_IS_ACTIVE = TRUE; SET @MIGRATION_1608624028_IS_ACTIVE = TRUE; SET @MIGRATION_1609125144_IS_ACTIVE = TRUE; SET @MIGRATION_1609140710_IS_ACTIVE = TRUE; SET @MIGRATION_1609857999_IS_ACTIVE = TRUE; SET @MIGRATION_1610439375_IS_ACTIVE = TRUE; SET @MIGRATION_1610448012_IS_ACTIVE = TRUE; SET @MIGRATION_1610523204_IS_ACTIVE = TRUE; SET @MIGRATION_1610531188_IS_ACTIVE = TRUE; SET @MIGRATION_1610904608_IS_ACTIVE = TRUE; SET @MIGRATION_1611155140_IS_ACTIVE = TRUE; SET @MIGRATION_1595492054_IS_ACTIVE = TRUE; SET @MIGRATION_1604502151_IS_ACTIVE = TRUE; SET @MIGRATION_1595492054_IS_ACTIVE = TRUE; SET @MIGRATION_1604502151_IS_ACTIVE = TRUE; SET @MIGRATION_1536765935_IS_ACTIVE = TRUE; SET @MIGRATION_1536765936_IS_ACTIVE = TRUE; SET @MIGRATION_1536765937_IS_ACTIVE = TRUE; SET @MIGRATION_1536765938_IS_ACTIVE = TRUE; SET @MIGRATION_1538046469_IS_ACTIVE = TRUE; SET @MIGRATION_1538985581_IS_ACTIVE = TRUE; SET @MIGRATION_1544535797_IS_ACTIVE = TRUE; SET @MIGRATION_1563456847_IS_ACTIVE = TRUE; SET @MIGRATION_1564041870_IS_ACTIVE = TRUE; SET @MIGRATION_1564053392_IS_ACTIVE = TRUE; SET @MIGRATION_1568882302_IS_ACTIVE = TRUE; SET @MIGRATION_1568882317_IS_ACTIVE = TRUE; SET @MIGRATION_1587476616_IS_ACTIVE = TRUE; SET @MIGRATION_1589448383_IS_ACTIVE = TRUE; SET @MIGRATION_1593494859_IS_ACTIVE = TRUE; SET @MIGRATION_1593508853_IS_ACTIVE = TRUE; SET @MIGRATION_1615794849_IS_ACTIVE = TRUE; SET @MIGRATION_1644753635_IS_ACTIVE = TRUE; SET @MIGRATION_1652444730_IS_ACTIVE = TRUE; SET @MIGRATION_1669117848_IS_ACTIVE = TRUE; SET @MIGRATION_1669796049_IS_ACTIVE = TRUE; SET @MIGRATION_1678106061_IS_ACTIVE = TRUE; SET @MIGRATION_1559416986_IS_ACTIVE = TRUE; SET @MIGRATION_1602739765_IS_ACTIVE = TRUE; SET @MIGRATION_1604519670_IS_ACTIVE = TRUE; SET @MIGRATION_1604520733_IS_ACTIVE = TRUE; SET @MIGRATION_1605031477_IS_ACTIVE = TRUE; SET @MIGRATION_1612160298_IS_ACTIVE = TRUE 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 @MIGRATION_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1536765935_IS_ACTIVE = TRUE;SET @MIGRATION_1536765936_IS_ACTIVE = TRUE;SET @MIGRATION_1536765937_IS_ACTIVE = TRUE;SET @MIGRATION_1536765938_IS_ACTIVE = TRUE;SET @MIGRATION_1538046469_IS_ACTIVE = TRUE;SET @MIGRATION_1538985581_IS_ACTIVE = TRUE;SET @MIGRATION_1544535797_IS_ACTIVE = TRUE;SET @MIGRATION_1563456847_IS_ACTIVE = TRUE;SET @MIGRATION_1564041870_IS_ACTIVE = TRUE;SET @MIGRATION_1564053392_IS_ACTIVE = TRUE;SET @MIGRATION_1568882302_IS_ACTIVE = TRUE;SET @MIGRATION_1568882317_IS_ACTIVE = TRUE;SET @MIGRATION_1587476616_IS_ACTIVE = TRUE;SET @MIGRATION_1589448383_IS_ACTIVE = TRUE;SET @MIGRATION_1593494859_IS_ACTIVE = TRUE;SET @MIGRATION_1593508853_IS_ACTIVE = TRUE;SET @MIGRATION_1615794849_IS_ACTIVE = TRUE;SET @MIGRATION_1644753635_IS_ACTIVE = TRUE;SET @MIGRATION_1652444730_IS_ACTIVE = TRUE;SET @MIGRATION_1669117848_IS_ACTIVE = TRUE;SET @MIGRATION_1669796049_IS_ACTIVE = TRUE;SET @MIGRATION_1678106061_IS_ACTIVE = TRUE;SET @MIGRATION_1559416986_IS_ACTIVE = TRUE;SET @MIGRATION_1602739765_IS_ACTIVE = TRUE;SET @MIGRATION_1604519670_IS_ACTIVE = TRUE;SET @MIGRATION_1604520733_IS_ACTIVE = TRUE;SET @MIGRATION_1605031477_IS_ACTIVE = TRUE;SET @MIGRATION_1612160298_IS_ACTIVE = TRUE; array:6 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 362)" 4 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 156)" 5 => "Shopware\Core\Kernel::boot (line 136)" 6 => "Shopware\Core\HttpKernel::doHandle (line 80)" 7 => "Shopware\Core\HttpKernel::handle (line 86)"`]
3	6.74 ms	# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = :language_id) AND ((sales_channel_id = :sales_channel_id OR sales_channel_id IS NULL)) AND (seo_path_info = :seoPath) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1 View formatted query View runnable query View query stack # seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = : language_id) AND ( ( sales_channel_id = : sales_channel_id OR sales_channel_id IS NULL ) ) AND (seo_path_info = : seoPath) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1 # seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x0A197278A7514B78A06EA27EF27E9EF8 OR sales_channel_id IS NULL)) AND (seo_path_info = 'Magazines/Oase/') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1; array:8 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 66)" 3 => "Shopware\Core\Content\Seo\SeoResolver::resolveSeoPath (line 345)" 4 => "Shopware\Storefront\Framework\Routing\RequestTransformer::resolveSeoUrl (line 166)" 5 => "Shopware\Storefront\Framework\Routing\RequestTransformer::transform (line 143)" 6 => "Shopware\Core\HttpKernel::doHandle (line 80)" 7 => "Shopware\Core\HttpKernel::handle (line 86)"]
4	6.25 ms	SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`., COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = :languageId) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = :param_1a5a235d3f1e4a7caeeb2cb9776730f4) View formatted query View runnable query View query stack SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`., COALESCE( `plugin.translation.label`, `plugin.translation.label` ) as `plugin.label`, COALESCE( `plugin.translation.description`, `plugin.translation.description` ) as `plugin.description`, COALESCE( `plugin.translation.manufacturerLink`, `plugin.translation.manufacturerLink` ) as `plugin.manufacturerLink`, COALESCE( `plugin.translation.supportLink`, `plugin.translation.supportLink` ) as `plugin.supportLink`, COALESCE( `plugin.translation.changelog`, `plugin.translation.changelog` ) as `plugin.changelog`, COALESCE( `plugin.translation.customFields`, `plugin.translation.customFields` ) as `plugin.customFields` FROM `plugin` LEFT JOIN ( SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = : languageId ) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE ( `plugin`.`active` = : param_1a5a235d3f1e4a7caeeb2cb9776730f4 ) SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`.*, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = 0); array:18 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 48)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 7 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 445)" 10 => "Shopware\Core\System\SystemConfig\SystemConfigService::getNotActivatedPlugins (line 381)" 11 => "Shopware\Core\System\SystemConfig\SystemConfigService::filterNotActivatedPlugins (line 376)" 12 => "Shopware\Core\System\SystemConfig\SystemConfigService::buildSystemConfigArray (line 344)" 13 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 72)" 14 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)" 15 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 147)" 16 => "Shopware\Core\HttpKernel::doHandle (line 80)" 17 => "Shopware\Core\HttpKernel::handle (line 86)"]
5	5.51 ms	SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC View formatted query View runnable query View query stack SELECT LOWER( HEX(id) ) FROM system_config WHERE ( sales_channel_id IS NULL OR sales_channel_id = : salesChannelId ) AND (configuration_key LIKE : prefix) ORDER BY configuration_key ASC, sales_channel_id ASC SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = NULL) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY configuration_key ASC, sales_channel_id ASC; array:21 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 172)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigService::getDomain (line 74)" 4 => "Kiener\MolliePayments\Service\SettingsService::getSettings (line 56)" 5 => "Kiener\MolliePayments\Service\Logger\MollieLoggerFactory::createLogger (line 36773)" 6 => "ContainerKsEkLcM\srcShopware_Production_KernelDevDebugContainer::getMolliePayments_LoggerService (line 18332)" 7 => "ContainerKsEkLcM\srcShopware_Production_KernelDevDebugContainer::getWebhookTimezoneSubscriberService (line 11241)" 8 => "ContainerKsEkLcM\srcShopware_Production_KernelDevDebugContainer::ContainerKsEkLcM\{closure} (line 279)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 90)" 10 => "Symfony\Component\EventDispatcher\EventDispatcher::getListeners (line 133)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::getListeners (line 83)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::getListeners (line 57)" 13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::getListeners (line 334)" 14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::preProcess (line 162)" 15 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 134)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 18 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 19 => "Shopware\Core\HttpKernel::doHandle (line 80)" 20 => "Shopware\Core\HttpKernel::handle (line 86)"]
6	5.41 ms	SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = :salesChannelId) AND (token = :token) LIMIT 1 View formatted query View runnable query View query stack SELECT * FROM sales_channel_api_context WHERE ( sales_channel_id = : salesChannelId ) AND (token = : token) LIMIT 1 SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = :salesChannelId) AND (token = :token) LIMIT 1; array:21 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 160)" 3 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister::load (line 73)" 4 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 34)" 5 => "Shopware\Core\Profiling\Checkout\SalesChannelContextServiceProfiler::get (line 107)" 6 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 33)" 7 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 126)" 8 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 264)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::doDispatch (line 239)" 10 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 11 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 12 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 13 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 14 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 15 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 146)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 18 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 19 => "Shopware\Core\HttpKernel::doHandle (line 80)" 20 => "Shopware\Core\HttpKernel::handle (line 86)"]
7	5.90 ms	# context-factory::base-context SELECT sales_channel.id as sales_channel_id, sales_channel.language_id as sales_channel_default_language_id, sales_channel.currency_id as sales_channel_currency_id, currency.factor as sales_channel_currency_factor, currency.decimal_precision as sales_channel_currency_decimal_precision, GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids FROM sales_channel INNER JOIN currency ON sales_channel.currency_id = currency.id LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id WHERE sales_channel.id = :id GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor View formatted query View runnable query View query stack # context-factory::base-context SELECT sales_channel.id as sales_channel_id, sales_channel.language_id as sales_channel_default_language_id, sales_channel.currency_id as sales_channel_currency_id, currency.factor as sales_channel_currency_factor, currency.decimal_precision as sales_channel_currency_decimal_precision, GROUP_CONCAT( LOWER( HEX( sales_channel_language.language_id ) ) ) as sales_channel_language_ids FROM sales_channel INNER JOIN currency ON sales_channel.currency_id = currency.id LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id WHERE sales_channel.id = : id GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor # context-factory::base-context SELECT sales_channel.id as sales_channel_id, sales_channel.language_id as sales_channel_default_language_id, sales_channel.currency_id as sales_channel_currency_id, currency.factor as sales_channel_currency_factor, currency.decimal_precision as sales_channel_currency_decimal_precision, GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids FROM sales_channel INNER JOIN currency ON sales_channel.currency_id = currency.id LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id WHERE sales_channel.id = 0x0A197278A7514B78A06EA27EF27E9EF8 GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor; array:22 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 553)" 2 => "Doctrine\DBAL\Connection::fetchAssoc (line 1035)" 3 => "IdeaBooks\Decorates\Core\System\SalesChannel\Context\SalesChannelContextFactory::getContext (line 180)" 4 => "IdeaBooks\Decorates\Core\System\SalesChannel\Context\SalesChannelContextFactory::create (line 91)" 5 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 34)" 6 => "Shopware\Core\Profiling\Checkout\SalesChannelContextServiceProfiler::get (line 107)" 7 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 33)" 8 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 126)" 9 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 264)" 10 => "Symfony\Component\EventDispatcher\EventDispatcher::doDispatch (line 239)" 11 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 12 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 13 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 14 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 15 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 16 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 146)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 20 => "Shopware\Core\HttpKernel::doHandle (line 80)" 21 => "Shopware\Core\HttpKernel::handle (line 86)"]
8	5.81 ms	#cart-persister::load SELECT `cart`.`cart` FROM cart WHERE `token` = :token View formatted query View runnable query View query stack #cart-persister::load SELECT `cart`.`cart` FROM cart WHERE `token` = : token #cart-persister::load SELECT `cart`.`cart` FROM cart WHERE `token` = 'YSLtSj1YSlfyP3Jvi7SIf8fzTGrqaCDi'; array:22 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 586)" 2 => "Doctrine\DBAL\Connection::fetchColumn (line 39)" 3 => "Shopware\Core\Checkout\Cart\CartPersister::load (line 64)" 4 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 93)" 5 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 34)" 6 => "Shopware\Core\Profiling\Checkout\SalesChannelContextServiceProfiler::get (line 107)" 7 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 33)" 8 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 126)" 9 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 264)" 10 => "Symfony\Component\EventDispatcher\EventDispatcher::doDispatch (line 239)" 11 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 12 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 13 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 14 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 15 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 16 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 146)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 20 => "Shopware\Core\HttpKernel::doHandle (line 80)" 21 => "Shopware\Core\HttpKernel::handle (line 86)"]
9	6.23 ms	SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC View formatted query View runnable query View query stack SELECT LOWER( HEX(id) ) FROM system_config WHERE ( sales_channel_id IS NULL OR sales_channel_id = : salesChannelId ) AND (configuration_key LIKE : prefix) ORDER BY configuration_key ASC, sales_channel_id ASC SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = 0x0A197278A7514B78A06EA27EF27E9EF8) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY configuration_key ASC, sales_channel_id ASC; array:28 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 172)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigService::getDomain (line 74)" 4 => "Kiener\MolliePayments\Service\SettingsService::getSettings (line 41)" 5 => "Kiener\MolliePayments\Components\Subscription\Cart\Validator\AvailabilityInformationValidator::validate (line 24)" 6 => "Shopware\Core\Checkout\Cart\Validator::validate (line 81)" 7 => "Shopware\Core\Checkout\Cart\Processor::process (line 96)" 8 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 74)" 9 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByCart (line 69)" 10 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 93)" 11 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 34)" 12 => "Shopware\Core\Profiling\Checkout\SalesChannelContextServiceProfiler::get (line 107)" 13 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 33)" 14 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 126)" 15 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 264)" 16 => "Symfony\Component\EventDispatcher\EventDispatcher::doDispatch (line 239)" 17 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 19 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 20 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 146)" 23 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 24 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 25 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 26 => "Shopware\Core\HttpKernel::doHandle (line 80)" 27 => "Shopware\Core\HttpKernel::handle (line 86)"]
10	6.05 ms	SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC View formatted query View runnable query View query stack SELECT LOWER( HEX(id) ) FROM system_config WHERE ( sales_channel_id IS NULL OR sales_channel_id = : salesChannelId ) AND (configuration_key LIKE : prefix) ORDER BY configuration_key ASC, sales_channel_id ASC SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = 0x0A197278A7514B78A06EA27EF27E9EF8) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY configuration_key ASC, sales_channel_id ASC; array:28 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 172)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigService::getDomain (line 74)" 4 => "Kiener\MolliePayments\Service\SettingsService::getSettings (line 47)" 5 => "Kiener\MolliePayments\Components\Subscription\Cart\Validator\SubscriptionCartValidator::validate (line 24)" 6 => "Shopware\Core\Checkout\Cart\Validator::validate (line 81)" 7 => "Shopware\Core\Checkout\Cart\Processor::process (line 96)" 8 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 74)" 9 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByCart (line 69)" 10 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 93)" 11 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 34)" 12 => "Shopware\Core\Profiling\Checkout\SalesChannelContextServiceProfiler::get (line 107)" 13 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 33)" 14 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 126)" 15 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 264)" 16 => "Symfony\Component\EventDispatcher\EventDispatcher::doDispatch (line 239)" 17 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 19 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 20 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 146)" 23 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 24 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 25 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 26 => "Shopware\Core\HttpKernel::doHandle (line 80)" 27 => "Shopware\Core\HttpKernel::handle (line 86)"]
11	6.15 ms	SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC View formatted query View runnable query View query stack SELECT LOWER( HEX(id) ) FROM system_config WHERE ( sales_channel_id IS NULL OR sales_channel_id = : salesChannelId ) AND (configuration_key LIKE : prefix) ORDER BY configuration_key ASC, sales_channel_id ASC SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = 0x0A197278A7514B78A06EA27EF27E9EF8) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY configuration_key ASC, sales_channel_id ASC; array:28 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 172)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigService::getDomain (line 74)" 4 => "Kiener\MolliePayments\Service\SettingsService::getSettings (line 41)" 5 => "Kiener\MolliePayments\Components\Subscription\Cart\Validator\AvailabilityInformationValidator::validate (line 24)" 6 => "Shopware\Core\Checkout\Cart\Validator::validate (line 81)" 7 => "Shopware\Core\Checkout\Cart\Processor::process (line 112)" 8 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 74)" 9 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByCart (line 69)" 10 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 93)" 11 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 34)" 12 => "Shopware\Core\Profiling\Checkout\SalesChannelContextServiceProfiler::get (line 107)" 13 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 33)" 14 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 126)" 15 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 264)" 16 => "Symfony\Component\EventDispatcher\EventDispatcher::doDispatch (line 239)" 17 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 19 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 20 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 146)" 23 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 24 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 25 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 26 => "Shopware\Core\HttpKernel::doHandle (line 80)" 27 => "Shopware\Core\HttpKernel::handle (line 86)"]
12	5.97 ms	SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY configuration_key ASC, sales_channel_id ASC View formatted query View runnable query View query stack SELECT LOWER( HEX(id) ) FROM system_config WHERE ( sales_channel_id IS NULL OR sales_channel_id = : salesChannelId ) AND (configuration_key LIKE : prefix) ORDER BY configuration_key ASC, sales_channel_id ASC SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = 0x0A197278A7514B78A06EA27EF27E9EF8) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY configuration_key ASC, sales_channel_id ASC; array:28 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 172)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigService::getDomain (line 74)" 4 => "Kiener\MolliePayments\Service\SettingsService::getSettings (line 47)" 5 => "Kiener\MolliePayments\Components\Subscription\Cart\Validator\SubscriptionCartValidator::validate (line 24)" 6 => "Shopware\Core\Checkout\Cart\Validator::validate (line 81)" 7 => "Shopware\Core\Checkout\Cart\Processor::process (line 112)" 8 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 74)" 9 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByCart (line 69)" 10 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 93)" 11 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 34)" 12 => "Shopware\Core\Profiling\Checkout\SalesChannelContextServiceProfiler::get (line 107)" 13 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 33)" 14 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 126)" 15 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 264)" 16 => "Symfony\Component\EventDispatcher\EventDispatcher::doDispatch (line 239)" 17 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 19 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 20 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 146)" 23 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 24 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 25 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 26 => "Shopware\Core\HttpKernel::doHandle (line 80)" 27 => "Shopware\Core\HttpKernel::handle (line 86)"]
13	6.83 ms	# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId View formatted query View runnable query View query stack # navigation-route::meta-information SELECT LOWER( HEX(`id`) ), `path`, `level` FROM `category` WHERE `id` = : activeId OR `parent_id` = : activeId OR `id` = : rootId # navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = 0x313EFA5737034013BF5F29E3ABB1161A OR `parent_id` = 0x313EFA5737034013BF5F29E3ABB1161A OR `id` = 0xA59628EC24EC4FBB992D74F4E5EB48E0 ; array:15 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 844)" 2 => "Doctrine\DBAL\Connection::fetchAll (line 218)" 3 => "Shopware\Core\Content\Category\SalesChannel\NavigationRoute::getCategoryMetaInfo (line 113)" 4 => "Shopware\Core\Content\Category\SalesChannel\NavigationRoute::load (line 72)" 5 => "Shopware\Core\Content\Category\Service\NavigationLoader::load (line 79)" 6 => "Shopware\Storefront\Pagelet\Header\HeaderPageletLoader::load (line 90)" 7 => "Shopware\Storefront\Page\GenericPageLoader::load (line 54)" 8 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 9 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 10 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 11 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 12 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 13 => "Shopware\Core\HttpKernel::doHandle (line 80)" 14 => "Shopware\Core\HttpKernel::handle (line 86)"]
14	6.09 ms	# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId View formatted query View runnable query View query stack # navigation-route::meta-information SELECT LOWER( HEX(`id`) ), `path`, `level` FROM `category` WHERE `id` = : activeId OR `parent_id` = : activeId OR `id` = : rootId # navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = 0xC4122D9E221E4EFA8576F3DCFE12D60C OR `parent_id` = 0xC4122D9E221E4EFA8576F3DCFE12D60C OR `id` = 0xC4122D9E221E4EFA8576F3DCFE12D60C ; array:16 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 844)" 2 => "Doctrine\DBAL\Connection::fetchAll (line 218)" 3 => "Shopware\Core\Content\Category\SalesChannel\NavigationRoute::getCategoryMetaInfo (line 113)" 4 => "Shopware\Core\Content\Category\SalesChannel\NavigationRoute::load (line 72)" 5 => "Shopware\Core\Content\Category\Service\NavigationLoader::load (line 111)" 6 => "Shopware\Storefront\Pagelet\Header\HeaderPageletLoader::getServiceMenu (line 95)" 7 => "Shopware\Storefront\Pagelet\Header\HeaderPageletLoader::load (line 90)" 8 => "Shopware\Storefront\Page\GenericPageLoader::load (line 54)" 9 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 10 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 11 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 12 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 13 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 14 => "Shopware\Core\HttpKernel::doHandle (line 80)" 15 => "Shopware\Core\HttpKernel::handle (line 86)"]
15	7.63 ms	SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.category_translation`., COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = :languageId) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` WHERE (`category`.`version_id` = :version) AND ((`category`.`id` = :param_2dad259fc61c498da011a026c68edd9b)) View formatted query View runnable query View query stack SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.category_translation`., COALESCE( `category.translation.name`, `category.translation.name` ) as `category.name`, COALESCE( `category.translation.breadcrumb`, `category.translation.breadcrumb` ) as `category.breadcrumb`, COALESCE( `category.translation.slotConfig`, `category.translation.slotConfig` ) as `category.slotConfig`, COALESCE( `category.translation.externalLink`, `category.translation.externalLink` ) as `category.externalLink`, COALESCE( `category.translation.description`, `category.translation.description` ) as `category.description`, COALESCE( `category.translation.metaTitle`, `category.translation.metaTitle` ) as `category.metaTitle`, COALESCE( `category.translation.metaDescription`, `category.translation.metaDescription` ) as `category.metaDescription`, COALESCE( `category.translation.keywords`, `category.translation.keywords` ) as `category.keywords`, COALESCE( `category.translation.customFields`, `category.translation.customFields` ) as `category.customFields` FROM `category` LEFT JOIN ( SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = : languageId ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` WHERE ( `category`.`version_id` = : version ) AND ( ( `category`.`id` = : param_2dad259fc61c498da011a026c68edd9b ) ) SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.category_translation`.*, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`id` = 0x313EFA5737034013BF5F29E3ABB1161A)); array:28 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 70)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadFilterResult (line 52)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 8 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 76)" 11 => "LoyxxSW6CategoryTreeTeaser\Subscriber\PageLoadedEventSubscriber::onPageLoadedEvent (line 126)" 12 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 251)" 13 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 14 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 15 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 16 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 17 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 18 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 98)" 19 => "Shopware\Storefront\Pagelet\Header\HeaderPageletLoader::load (line 90)" 20 => "Shopware\Storefront\Page\GenericPageLoader::load (line 54)" 21 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 22 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 23 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 24 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 25 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 26 => "Shopware\Core\HttpKernel::doHandle (line 80)" 27 => "Shopware\Core\HttpKernel::handle (line 86)"]
16	8.88 ms	SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.media_translation`., COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.category_translation`., COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = :languageId) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = :languageId) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = :version) AND ((`category`.`parent_id` IN (:param_bd854b558f1f41538f5b901335929174))) ORDER BY `category`.`level` ASC View formatted query View runnable query View query stack SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.media_translation`., COALESCE( `category.media.translation.title`, `category.media.translation.title` ) as `category.media.title`, COALESCE( `category.media.translation.alt`, `category.media.translation.alt` ) as `category.media.alt`, COALESCE( `category.media.translation.customFields`, `category.media.translation.customFields` ) as `category.media.customFields`, `category.category_translation`., COALESCE( `category.translation.name`, `category.translation.name` ) as `category.name`, COALESCE( `category.translation.breadcrumb`, `category.translation.breadcrumb` ) as `category.breadcrumb`, COALESCE( `category.translation.slotConfig`, `category.translation.slotConfig` ) as `category.slotConfig`, COALESCE( `category.translation.externalLink`, `category.translation.externalLink` ) as `category.externalLink`, COALESCE( `category.translation.description`, `category.translation.description` ) as `category.description`, COALESCE( `category.translation.metaTitle`, `category.translation.metaTitle` ) as `category.metaTitle`, COALESCE( `category.translation.metaDescription`, `category.translation.metaDescription` ) as `category.metaDescription`, COALESCE( `category.translation.keywords`, `category.translation.keywords` ) as `category.keywords`, COALESCE( `category.translation.customFields`, `category.translation.customFields` ) as `category.customFields` FROM `category` LEFT JOIN ( SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = : languageId ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN ( SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = : languageId ) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE ( `category`.`version_id` = : version ) AND ( ( `category`.`parent_id` IN ( : param_bd854b558f1f41538f5b901335929174 ) ) ) ORDER BY `category`.`level` ASC SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.media_translation`., COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.category_translation`., COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`parent_id` IN (0x313EFA5737034013BF5F29E3ABB1161A))) ORDER BY `category`.`level` ASC; array:32 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 438)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 385)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1022)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 128)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 70)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadFilterResult (line 52)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 12 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 13 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 14 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 76)" 15 => "LoyxxSW6CategoryTreeTeaser\Subscriber\PageLoadedEventSubscriber::onPageLoadedEvent (line 126)" 16 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 251)" 17 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 19 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 20 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 98)" 23 => "Shopware\Storefront\Pagelet\Header\HeaderPageletLoader::load (line 90)" 24 => "Shopware\Storefront\Page\GenericPageLoader::load (line 54)" 25 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 26 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 27 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 28 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 29 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 30 => "Shopware\Core\HttpKernel::doHandle (line 80)" 31 => "Shopware\Core\HttpKernel::handle (line 86)"]
17	5.11 ms	# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId View formatted query View runnable query View query stack # navigation-route::meta-information SELECT LOWER( HEX(`id`) ), `path`, `level` FROM `category` WHERE `id` = : activeId OR `parent_id` = : activeId OR `id` = : rootId # navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = 0x313EFA5737034013BF5F29E3ABB1161A OR `parent_id` = 0x313EFA5737034013BF5F29E3ABB1161A OR `id` = 0xC4122D9E221E4EFA8576F3DCFE12D60C ; array:15 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 844)" 2 => "Doctrine\DBAL\Connection::fetchAll (line 218)" 3 => "Shopware\Core\Content\Category\SalesChannel\NavigationRoute::getCategoryMetaInfo (line 113)" 4 => "Shopware\Core\Content\Category\SalesChannel\NavigationRoute::load (line 72)" 5 => "Shopware\Core\Content\Category\Service\NavigationLoader::load (line 42)" 6 => "Shopware\Storefront\Pagelet\Footer\FooterPageletLoader::load (line 94)" 7 => "Shopware\Storefront\Page\GenericPageLoader::load (line 54)" 8 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 9 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 10 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 11 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 12 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 13 => "Shopware\Core\HttpKernel::doHandle (line 80)" 14 => "Shopware\Core\HttpKernel::handle (line 86)"]
18	6.52 ms	SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`., COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = :languageId) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = :param_4d94bfcbfaa24894b28bf839fc3da76b) View formatted query View runnable query View query stack SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`., COALESCE( `plugin.translation.label`, `plugin.translation.label` ) as `plugin.label`, COALESCE( `plugin.translation.description`, `plugin.translation.description` ) as `plugin.description`, COALESCE( `plugin.translation.manufacturerLink`, `plugin.translation.manufacturerLink` ) as `plugin.manufacturerLink`, COALESCE( `plugin.translation.supportLink`, `plugin.translation.supportLink` ) as `plugin.supportLink`, COALESCE( `plugin.translation.changelog`, `plugin.translation.changelog` ) as `plugin.changelog`, COALESCE( `plugin.translation.customFields`, `plugin.translation.customFields` ) as `plugin.customFields` FROM `plugin` LEFT JOIN ( SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = : languageId ) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE ( `plugin`.`active` = : param_4d94bfcbfaa24894b28bf839fc3da76b ) SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`.*, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = 0); array:24 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 48)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 7 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 445)" 10 => "Shopware\Core\System\SystemConfig\SystemConfigService::getNotActivatedPlugins (line 381)" 11 => "Shopware\Core\System\SystemConfig\SystemConfigService::filterNotActivatedPlugins (line 376)" 12 => "Shopware\Core\System\SystemConfig\SystemConfigService::buildSystemConfigArray (line 344)" 13 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 72)" 14 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 97)" 15 => "Shopware\Core\System\SystemConfig\SystemConfigService::getString (line 125)" 16 => "Shopware\Storefront\Page\GenericPageLoader::load (line 54)" 17 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 18 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 19 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 20 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 21 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 22 => "Shopware\Core\HttpKernel::doHandle (line 80)" 23 => "Shopware\Core\HttpKernel::handle (line 86)"]
19	6.63 ms	# category::cms-page::read SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.cms_page_translation`., COALESCE(`cms_page.translation.name`,`cms_page.translation.name`) as `cms_page.name`, COALESCE(`cms_page.translation.customFields`,`cms_page.translation.customFields`) as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.name as `cms_page.translation.name`, `cms_page.translation`.custom_fields as `cms_page.translation.customFields`, `cms_page.translation`.created_at as `cms_page.translation.createdAt`, `cms_page.translation`.updated_at as `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id as `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id as `cms_page.translation.languageId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = :languageId) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` WHERE `cms_page`.`id` IN (:ids) View formatted query View runnable query View query stack # category::cms-page::read SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.cms_page_translation`., COALESCE( `cms_page.translation.name`, `cms_page.translation.name` ) as `cms_page.name`, COALESCE( `cms_page.translation.customFields`, `cms_page.translation.customFields` ) as `cms_page.customFields` FROM `cms_page` LEFT JOIN ( SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.name as `cms_page.translation.name`, `cms_page.translation`.custom_fields as `cms_page.translation.customFields`, `cms_page.translation`.created_at as `cms_page.translation.createdAt`, `cms_page.translation`.updated_at as `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id as `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id as `cms_page.translation.languageId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = : languageId ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` WHERE `cms_page`.`id` IN (: ids) # category::cms-page::read SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.cms_page_translation`.*, COALESCE(`cms_page.translation.name`,`cms_page.translation.name`) as `cms_page.name`, COALESCE(`cms_page.translation.customFields`,`cms_page.translation.customFields`) as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.name as `cms_page.translation.name`, `cms_page.translation`.custom_fields as `cms_page.translation.customFields`, `cms_page.translation`.created_at as `cms_page.translation.createdAt`, `cms_page.translation`.updated_at as `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id as `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id as `cms_page.translation.languageId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` WHERE `cms_page`.`id` IN (0x7AF2EA8AA72344499E81DD72B1FCDF60); array:20 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 130)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadResultByIds (line 55)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 8 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 67)" 11 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::load (line 108)" 12 => "Shopware\Core\Content\Category\SalesChannel\CategoryRoute::load (line 60)" 13 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 14 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 18 => "Shopware\Core\HttpKernel::doHandle (line 80)" 19 => "Shopware\Core\HttpKernel::handle (line 86)"]
20	7.87 ms	# category::cms-page::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.media_translation`., COALESCE(`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, COALESCE(`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, COALESCE(`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at as `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at as `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id as `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id as `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = :languageId) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`cms_page_id` IN (:param_099e8091e9134bddafed051f39253593)) View formatted query View runnable query View query stack # category::cms-page::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.media_translation`., COALESCE( `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` ) as `cms_section.backgroundMedia.title`, COALESCE( `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` ) as `cms_section.backgroundMedia.alt`, COALESCE( `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` ) as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN ( SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at as `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at as `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id as `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id as `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = : languageId ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE ( `cms_section`.`cms_page_id` IN ( : param_099e8091e9134bddafed051f39253593 ) ) # category::cms-page::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.media_translation`.*, COALESCE(`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, COALESCE(`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, COALESCE(`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at as `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at as `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id as `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id as `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`cms_page_id` IN (0x7AF2EA8AA72344499E81DD72B1FCDF60)); array:24 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 438)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 385)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1022)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 128)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 130)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadResultByIds (line 55)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 12 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 13 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 14 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 67)" 15 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::load (line 108)" 16 => "Shopware\Core\Content\Category\SalesChannel\CategoryRoute::load (line 60)" 17 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 18 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 19 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 20 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 21 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 22 => "Shopware\Core\HttpKernel::doHandle (line 80)" 23 => "Shopware\Core\HttpKernel::handle (line 86)"]
21	7.95 ms	# category::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.media_translation`., COALESCE(`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, COALESCE(`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, COALESCE(`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at as `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at as `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id as `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id as `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = :languageId) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`cms_section_id` IN (:param_27d6093e79404475a1d58a7aa688d6ab)) View formatted query View runnable query View query stack # category::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.media_translation`., COALESCE( `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` ) as `cms_block.backgroundMedia.title`, COALESCE( `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` ) as `cms_block.backgroundMedia.alt`, COALESCE( `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` ) as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN ( SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at as `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at as `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id as `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id as `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = : languageId ) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE ( `cms_block`.`cms_section_id` IN ( : param_27d6093e79404475a1d58a7aa688d6ab ) ) # category::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.media_translation`.*, COALESCE(`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, COALESCE(`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, COALESCE(`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at as `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at as `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id as `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id as `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`cms_section_id` IN (0x36D204F477144EE7B82495B8440CB46E, 0x5AF5BC6950084368ADF68451D7D72815)); array:28 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 438)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 385)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1022)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 128)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 438)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 385)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1022)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 128)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 13 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 130)" 14 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadResultByIds (line 55)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 16 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 17 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 18 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 67)" 19 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::load (line 108)" 20 => "Shopware\Core\Content\Category\SalesChannel\CategoryRoute::load (line 60)" 21 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 22 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 23 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 24 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 25 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 26 => "Shopware\Core\HttpKernel::doHandle (line 80)" 27 => "Shopware\Core\HttpKernel::handle (line 86)"]
22	7.09 ms	# category::cms-page::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.cms_slot_translation`., COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = :languageId) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` WHERE (`cms_slot`.`version_id` = :version) AND ((`cms_slot`.`cms_block_id` IN (:param_0a7c48c96ff14234bd4897a7b25d454c))) View formatted query View runnable query View query stack # category::cms-page::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.cms_slot_translation`., COALESCE( `cms_slot.translation.config`, `cms_slot.translation.config` ) as `cms_slot.config`, COALESCE( `cms_slot.translation.customFields`, `cms_slot.translation.customFields` ) as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN ( SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = : languageId ) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` WHERE ( `cms_slot`.`version_id` = : version ) AND ( ( `cms_slot`.`cms_block_id` IN ( : param_0a7c48c96ff14234bd4897a7b25d454c ) ) ) # category::cms-page::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.cms_slot_translation`.*, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` WHERE (`cms_slot`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`cms_slot`.`cms_block_id` IN (0x0BCF398C3D34456881BB4CE790C58FAA, 0x55F29805E9EC44F4B82F18471CFD849A, 0x64097083DD8B4A61AC1B80CCFD89E3C3, 0x3633276213764C0FBAEA3CCDB09F8163))); array:32 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 438)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 385)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1022)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 128)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 438)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 385)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1022)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 128)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 438)" 13 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 385)" 14 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1022)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 128)" 16 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 17 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 130)" 18 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadResultByIds (line 55)" 19 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 20 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 21 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 22 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 67)" 23 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::load (line 108)" 24 => "Shopware\Core\Content\Category\SalesChannel\CategoryRoute::load (line 60)" 25 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 26 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 27 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 28 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 29 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 30 => "Shopware\Core\HttpKernel::doHandle (line 80)" 31 => "Shopware\Core\HttpKernel::handle (line 86)"]
23	7.31 ms	SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.category_translation`., COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = :languageId) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` WHERE (`category`.`version_id` = :version) AND (`category`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.category_translation`., COALESCE( `category.translation.name`, `category.translation.name` ) as `category.name`, COALESCE( `category.translation.breadcrumb`, `category.translation.breadcrumb` ) as `category.breadcrumb`, COALESCE( `category.translation.slotConfig`, `category.translation.slotConfig` ) as `category.slotConfig`, COALESCE( `category.translation.externalLink`, `category.translation.externalLink` ) as `category.externalLink`, COALESCE( `category.translation.description`, `category.translation.description` ) as `category.description`, COALESCE( `category.translation.metaTitle`, `category.translation.metaTitle` ) as `category.metaTitle`, COALESCE( `category.translation.metaDescription`, `category.translation.metaDescription` ) as `category.metaDescription`, COALESCE( `category.translation.keywords`, `category.translation.keywords` ) as `category.keywords`, COALESCE( `category.translation.customFields`, `category.translation.customFields` ) as `category.customFields` FROM `category` LEFT JOIN ( SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = : languageId ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` WHERE ( `category`.`version_id` = : version ) AND ( `category`.`id` IN (: ids) ) SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.category_translation`.*, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x313EFA5737034013BF5F29E3ABB1161A)); array:24 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 130)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadResultByIds (line 55)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 8 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 91)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 112)" 11 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute::load (line 59)" 12 => "Shopware\Core\Content\Product\Cms\ProductListingCmsElementResolver::enrich (line 95)" 13 => "Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver::resolve (line 107)" 14 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::loadSlotData (line 97)" 15 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::load (line 108)" 16 => "Shopware\Core\Content\Category\SalesChannel\CategoryRoute::load (line 60)" 17 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 18 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 19 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 20 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 21 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 22 => "Shopware\Core\HttpKernel::doHandle (line 80)" 23 => "Shopware\Core\HttpKernel::handle (line 86)"]
24	8.47 ms	SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = :param_cfed938931a14c87b10bfbe7cdfb6329) ORDER BY `product_sorting`.`priority` DESC View formatted query View runnable query View query stack SELECT `product_sorting`.`id` FROM `product_sorting` WHERE ( `product_sorting`.`active` = : param_cfed938931a14c87b10bfbe7cdfb6329 ) ORDER BY `product_sorting`.`priority` DESC SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = 1) ORDER BY `product_sorting`.`priority` DESC; array:32 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 89)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 74)" 4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 76)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntitySearcher::search (line 36)" 6 => "Shopware\Core\Profiling\Entity\EntitySearcherProfiler::search (line 148)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 96)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 324)" 9 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingFeaturesSubscriber::getAvailableSortings (line 283)" 10 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingFeaturesSubscriber::handleSorting (line 151)" 11 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingFeaturesSubscriber::handleListingRequest (line 126)" 12 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 251)" 13 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 14 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 15 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 16 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 17 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 18 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 127)" 19 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute::load (line 59)" 20 => "Shopware\Core\Content\Product\Cms\ProductListingCmsElementResolver::enrich (line 95)" 21 => "Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver::resolve (line 107)" 22 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::loadSlotData (line 97)" 23 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::load (line 108)" 24 => "Shopware\Core\Content\Category\SalesChannel\CategoryRoute::load (line 60)" 25 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 26 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 27 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 28 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 29 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 30 => "Shopware\Core\HttpKernel::doHandle (line 80)" 31 => "Shopware\Core\HttpKernel::handle (line 86)"]
25	9.00 ms	SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.product_sorting_translation`., COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = :languageId) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (:ids) View formatted query View runnable query View query stack SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.product_sorting_translation`., COALESCE( `product_sorting.translation.label`, `product_sorting.translation.label` ) as `product_sorting.label` FROM `product_sorting` LEFT JOIN ( SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = : languageId ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (: ids) SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.product_sorting_translation`.*, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (0x1809BAD69B0C46799511A2FF86F96299, 0xD3446F397B8C4A76975EFD73561DDBD6, 0xD41994DF7EF94A2F8EA2EF1849B099FB); array:34 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 918)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 206)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 277)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 124)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 94)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 130)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::loadResultByIds (line 55)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Cache\CachedEntityReader::read (line 36)" 8 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 239)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 100)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 324)" 11 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingFeaturesSubscriber::getAvailableSortings (line 283)" 12 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingFeaturesSubscriber::handleSorting (line 151)" 13 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingFeaturesSubscriber::handleListingRequest (line 126)" 14 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 251)" 15 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 73)" 16 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 88)" 17 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 46)" 18 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)" 19 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 168)" 20 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 127)" 21 => "Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute::load (line 59)" 22 => "Shopware\Core\Content\Product\Cms\ProductListingCmsElementResolver::enrich (line 95)" 23 => "Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver::resolve (line 107)" 24 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::loadSlotData (line 97)" 25 => "Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader::load (line 108)" 26 => "Shopware\Core\Content\Category\SalesChannel\CategoryRoute::load (line 60)" 27 => "Shopware\Storefront\Page\Navigation\NavigationPageLoader::load (line 57)" 28 => "Shopware\Storefront\Controller\NavigationController::index (line 158)" 29 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 80)" 30 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 201)" 31 => "Symfony\Component\HttpKernel\Kernel::handle (line 163)" 32 => "Shopware\Core\HttpKernel::doHandle (line 80)" 33 => "Shopware\Core\HttpKernel::handle (line 86)"]

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://ideabooks.albertvanderveen.nl/navigation/313efa5737034013bf5f29e3abb1161a

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://ideabooks.albertvanderveen.nl/navigation/313efa5737034013bf5f29e3abb1161a

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping