Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

20 Database Queries

Different statements

120.64 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 path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = :language_id) AND (sales_channel_id = :sales_channel_id) AND (id != :id) AND (path_info = :pathInfo) AND (is_canonical = 1) LIMIT 1
# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` IS NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500
# system-config::load::read
SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (:ids)
# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` IS NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500
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_254abba1210946518ac6a230803748e2)
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
# 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_096538e01177404491daf658d794dbbc)

#▲	Time	Info
1	5.99 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.75 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	7.37 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 = 'Eutopia-2-Non-Linear-Multiple-Hybrid-Solutions/idea31637') 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	8.70 ms	SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = :language_id) AND (sales_channel_id = :sales_channel_id) AND (id != :id) AND (path_info = :pathInfo) AND (is_canonical = 1) LIMIT 1 View formatted query View runnable query View query stack SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = : language_id) AND ( sales_channel_id = : sales_channel_id ) AND (id != : id) AND (path_info = : pathInfo) AND (is_canonical = 1) LIMIT 1 SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x0A197278A7514B78A06EA27EF27E9EF8) AND (id != 0xDA0C02E4C7024EF5A5A1BCD980099389) AND (path_info = '/detail/e0b3baff9183492ea2531a6b54e4b49d') AND (is_canonical = 1) 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 87)" 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)"]
5	5.77 ms	# system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` IS NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 View formatted query View runnable query View query stack # system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE ( `system_config`.`sales_channel_id` IS NULL ) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 # system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` IS NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500; array:15 [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 72)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 340)" 10 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 72)" 11 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)" 12 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 147)" 13 => "Shopware\Core\HttpKernel::doHandle (line 80)" 14 => "Shopware\Core\HttpKernel::handle (line 86)"]
6	8.32 ms	# system-config::load::read SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (:ids) View formatted query View runnable query View query stack # system-config::load::read SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (: ids) # system-config::load::read SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (0x04D8001333C4455B8BEE629C0F4ADE7B, 0x05FFBDFA4B654FB083560AB42D01EE68, 0x0DB6007B422C4E24999B3F604AACFFD6, 0x0F27FEAA8C684EF385AB2162EDED45F3, 0x14B47C04A140439C96EAE5396F307057, 0x1A3AFCE1EDC8484CAEF312A42702E6FB, 0x23C59CB1995C4A35BFE0FDDEABAEDF7F, 0x244532F33BCC428C921E449CA769DF41, 0x2C4856851EE14F0B8160113B0DAE5B51, 0x2CFC783CE6E34420AFA769DFEFA9B88E, 0x2F9A5D93156A40658FF193ED75C65E55, 0x332C15CFA0774504A25A56219386126D, 0x33F12374281347CE96246665A3F3F826, 0x374076F0711A4976A0F58A00A9A990A8, 0x3DC74095579B43BA8C7CAFA2655969C0, 0x3F4C3A0E0E1644D5B166E49310CF8221, 0x3FD2E894B00F4829989DA4C30D0BA22E, 0x40C2D2C452E04B1D985AF1B5402F6B24, 0x42B2EF99EDB441A191C4316B5B1AA822, 0x49CBE9D9DDF64ACFB27DED146F7E2814, 0x4CA13139E3724CFC81EFE6DF9AC8644C, 0x51A991BBE79D4AF39C7AD28735CA9C37, 0x51DFED9BB58E412FA1D817EC8BAFC62C, 0x556FF4779C9D45ACA0A4B0C89DA363C7, 0x5B42F6407B3B47B38328EE17634EBE92, 0x5D68AD455A1D4D6CBCB0B6C5E035ADA2, 0x5F1FD12B547E4DC291538BA9ED3E4504, 0x60B2EC12CC304460AD50094453F9FB15, 0x65F5754E06D444FC8547477A8C867F70, 0x66B1931AF3224F8099C53F193AB55669, 0x6789D051DF5C4FE0A199E11815B4DA07, 0x6C7C5536CE844AE48EA817CDF7912FDB, 0x6F3942137FBC4EDBA9B74D5F8D9FECEB, 0x701251EFAD41441094334087553410BB, 0x70920CA2411441AD9FB3A513B331D855, 0x70BE68ED59BF4E47B91887120AA687C2, 0x71862A6099A24AD49F683BF429D8A3C4, 0x750D80BE2AA04F8F9F18AFA19B9225D4, 0x76EF15244E3A457A8CD2363744753D65, 0x779AB6F2F88348A1BDE4C1AACA4FE871, 0x7DB99F72BB0243FE9D6C543AF053AF65, 0x7EFBF910E74246AD9426EA2493D644B9, 0x80668C03A1084DC780D97A3E48C1005A, 0x8182EA7877D24B0C8AC4968C8BE77A02, 0x84408DD02DF949B8BC97DE488BD47704, 0x86734CCDE3E2482AA0A7E89567A20B34, 0x8846B20DB01945A99F703B7F085C3BAB, 0x8FD4A4929DED4B7FACA08C4AD08EC489, 0x8FEF1CAE9D034E39AAA5CF64752E9EEE, 0x90F2B9EF6D98423E9CE3D34C1DEF8147, 0x911E8C9CEF59418287662CBD70192774, 0x9478AB732AA744CB82D95DFA00185C78, 0x9517C42A6E8E444ABD9BFFCE350069F8, 0x952F9311C9F54CB48DDEB1C7CB8CAAB1, 0x9651DD5D2970496D8112D3C7B22B6E89, 0x982C1158C3704EB9982A3FAFB9085D73, 0x99C16407FCB24A3E9D9861B0568B6E53, 0x9A22178AABDF46CA9EDF717478009D32, 0x9A53B743B5F04D5EABB1DB696335D42B, 0x9A590638094242998B0555D830083074, 0x9D077D03FA5649D3BE25EFDB6C388ECA, 0x9E26A627EDFE499680A2F901E2BEB3E9, 0x9F64ABD8427446A29FBE008E75425361, 0xA20979F28E6B4E9DBF7A55958EF04483, 0xA262086038D14453A46BA82C75B30FDC, 0xA37A7C0469EF49DE850518FEF272783A, 0xA3965A47F26E4B66AA9798913F6149CE, 0xA6755F7F2A7743BFA248060856F1096C, 0xA730A472C9944AE2B63872ADABFF61B8, 0xA89FE0BEB51345F5B2F19E50761E9085, 0xAA07F5944CFF427AA2B40DCA185D465D, 0xAA25C48558A64023828B659BE85A03FC, 0xAF49AEA5C4864EB9B0BC003E55921A90, 0xB1C5FD877B614FB49709E83FB7FADE78, 0xB53FC7F689E24657A2704055F5B40082, 0xB7F6343F5E7441429FA6251C08AE929E, 0xB8DCAA4837294D7DBA1FD8D9302A195B, 0xBD578C0B7E0A42E9B7757D1088379C6E, 0xBFBD2BA10DCB43D6A95AA8BBE97281FA, 0xC973CBB383124FA5AD3C87E0741C577B, 0xCAC9BF9D0EEC41E6B290C867DB9051EB, 0xCBBDA92CCA4F4133A2FCBD738CBE3854, 0xCFE583FD05E14962AFF3A89F12C62DC4, 0xD397C2081A5E45C68C235DE908ED93BC, 0xD5FB1FDDC1424465B9688D8F4E37811E, 0xDB78E3EFC193417C81A225AB806E0605, 0xDBA504D049D843D79880165A0CB07F36, 0xDC4992299B3A4120940A512484F29354, 0xE089C1B50E4F41BDAAEC6C975352B184, 0xE2FD8A168EB04AE4947572F574F70974, 0xE44FFA0B78A24432A99D86305E499609, 0xE46A1998246347E1AF5CD1FFC8BA6479, 0xE7B267ECF28E42DDBF8F6F941C2D7D2C, 0xF30E47EA62FD438CB1F7189207EE1099, 0xF32B624C90F44554901A8C8F68F8882C, 0xF46833EF1D85453090E0DD8465AE307A, 0xF4CF293A09C847858A768CA741DA7B6A, 0xF51A829F5BBE4B029D0054A449A3ED13, 0xF5DEB03699A04645A65A57024974E59D, 0xF7C29A8032B949149F51FFB4DAD24F35, 0xF7F69CB0DD964C6AA5C0ED01D8D2801B, 0xF987C9651286495788F38AECE0B956B4, 0xF9A976EE28004757B7E0B70E60923A0B, 0xFAF04B2F7F30468BB693B2F31A8AB62B, 0xFB0AE06B16724F2DAD89BD34B1627774, 0xFC254A3230294807B2C2FD06CA45E6C0, 0xFD9FFC85771F4E549027F22E65935B21, 0xFE86EC0451C64308AB9F7BF8A9E56CB9); array:17 [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 72)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 340)" 12 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 72)" 13 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)" 14 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 147)" 15 => "Shopware\Core\HttpKernel::doHandle (line 80)" 16 => "Shopware\Core\HttpKernel::handle (line 86)"]
7	5.58 ms	# system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` IS NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500 View formatted query View runnable query View query stack # system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE ( `system_config`.`sales_channel_id` IS NULL ) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500 # system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` IS NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500; array:15 [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 72)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 340)" 10 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 72)" 11 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)" 12 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 147)" 13 => "Shopware\Core\HttpKernel::doHandle (line 80)" 14 => "Shopware\Core\HttpKernel::handle (line 86)"]
8	6.83 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_254abba1210946518ac6a230803748e2) 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_254abba1210946518ac6a230803748e2 ) 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)"]
9	6.24 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)"]
10	5.48 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)"]
11	5.56 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)"]
12	5.49 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` = 'o1HDzz6Jl2HjX5BTQqzDx9qNvbSyO86V'; 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)"]
13	5.54 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)"]
14	5.69 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)"]
15	5.35 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)"]
16	5.52 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)"]
17	5.49 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` = 0xA59628EC24EC4FBB992D74F4E5EB48E0 OR `parent_id` = 0xA59628EC24EC4FBB992D74F4E5EB48E0 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 94)" 8 => "Shopware\Storefront\Page\Product\ProductPageLoader::load (line 92)" 9 => "Shopware\Storefront\Controller\ProductController::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	5.29 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 94)" 9 => "Shopware\Storefront\Page\Product\ProductPageLoader::load (line 92)" 10 => "Shopware\Storefront\Controller\ProductController::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)"]
19	5.43 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: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 94)" 8 => "Shopware\Storefront\Page\Product\ProductPageLoader::load (line 92)" 9 => "Shopware\Storefront\Controller\ProductController::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)"]
20	6.23 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_096538e01177404491daf658d794dbbc) 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_096538e01177404491daf658d794dbbc ) 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 94)" 17 => "Shopware\Storefront\Page\Product\ProductPageLoader::load (line 92)" 18 => "Shopware\Storefront\Controller\ProductController::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)"]

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/detail/e0b3baff9183492ea2531a6b54e4b49d

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://ideabooks.albertvanderveen.nl/detail/e0b3baff9183492ea2531a6b54e4b49d

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping