1 |
6.75 ms |
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 |
5.67 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
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.52 ms |
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 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 = '9789078454496-pre-specifics-access-x-get-access-to-the-x-imposed-by-designed-culture') 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 |
7.38 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_609ef85a7fd941fc88dcf5547f28a969)
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_609ef85a7fd941fc88dcf5547f28a969
)
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 |
6.30 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
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 36781)"
6 => "Container4cmXU7D\srcShopware_Production_KernelDevDebugContainer::getMolliePayments_LoggerService (line 18338)"
7 => "Container4cmXU7D\srcShopware_Production_KernelDevDebugContainer::getWebhookTimezoneSubscriberService (line 11241)"
8 => "Container4cmXU7D\srcShopware_Production_KernelDevDebugContainer::Container4cmXU7D\{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 |
6.20 ms |
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 |
6.48 ms |
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
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 |
6.21 ms |
SELECT `cart`.`cart` FROM cart WHERE `token` = :token
SELECT `cart`.`cart` FROM cart WHERE `token` = '6ugFLbuncrtSEcNOmHRheAyYZJvLL6dl';
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.95 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
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.56 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
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.84 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
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 |
6.78 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
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 |
SELECT LOWER(HEX(`id`)), `path`, `level`
FROM `category`
WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId
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)"
]
|
14 |
6.72 ms |
SELECT LOWER(HEX(`id`)), `path`, `level`
FROM `category`
WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId
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)"
]
|
15 |
6.78 ms |
SELECT LOWER(HEX(`id`)), `path`, `level`
FROM `category`
WHERE `id` = :activeId OR `parent_id` = :activeId OR `id` = :rootId
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)"
]
|
16 |
8.37 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_8c106f16694c4bad807af5665623eeaf)
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_8c106f16694c4bad807af5665623eeaf
)
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)"
]
|