| 1 |
0.47 ms |
SELECT
`name`,
`base_class` AS baseClass,
IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
`path`,
`version`,
`autoload`,
`managed_by_composer` AS managedByComposer,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at`;
SELECT
`name`,
`base_class` AS baseClass,
IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
`path`,
`version`,
`autoload`,
`managed_by_composer` AS managedByComposer,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at`;;
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 42)"
2 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader::loadPluginInfos (line 101)"
3 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader::initializePlugins (line 180)"
4 => "Shopware\Core\Kernel::boot (line 127)"
5 => "Shopware\Core\HttpKernel::doHandle (line 79)"
6 => "Shopware\Core\HttpKernel::handle (line 85)"
]
|
| 2 |
0.52 ms |
SELECT custom_entity.name, custom_entity.fields
FROM custom_entity
LEFT JOIN app ON app.id = custom_entity.app_id
WHERE custom_entity.app_id IS NULL OR app.active = 1
SELECT custom_entity.name, custom_entity.fields
FROM custom_entity
LEFT JOIN app ON app.id = custom_entity.app_id
WHERE custom_entity.app_id IS NULL OR app.active = 1
;
array:8 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 38)"
3 => "Shopware\Core\System\CustomEntity\CustomEntityRegistrar::register (line 57)"
4 => "Shopware\Core\System\System::boot (line 195)"
5 => "Shopware\Core\Kernel::boot (line 127)"
6 => "Shopware\Core\HttpKernel::doHandle (line 79)"
7 => "Shopware\Core\HttpKernel::handle (line 85)"
]
|
| 3 |
0.62 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 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 378)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 198)"
3 => "Shopware\Core\Kernel::boot (line 127)"
4 => "Shopware\Core\HttpKernel::doHandle (line 79)"
5 => "Shopware\Core\HttpKernel::handle (line 85)"
]
|
| 4 |
0.14 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_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1720536114_IS_ACTIVE = TRUE;SET @MIGRATION_1724420699_IS_ACTIVE = TRUE;SET @MIGRATION_1732629279_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1675420139_IS_ACTIVE = TRUE;SET @MIGRATION_1604898081_IS_ACTIVE = TRUE;SET @MIGRATION_165657926_IS_ACTIVE = TRUE;SET @MIGRATION_1590657517_IS_ACTIVE = TRUE;SET @MIGRATION_1651494367_IS_ACTIVE = TRUE;SET @MIGRATION_1615371170_IS_ACTIVE = TRUE;SET @MIGRATION_1617881178_IS_ACTIVE = TRUE;SET @MIGRATION_1697795798_IS_ACTIVE = TRUE;SET @MIGRATION_1686812041_IS_ACTIVE = TRUE;SET @MIGRATION_1690469830_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_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_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1720536114_IS_ACTIVE = TRUE;SET @MIGRATION_1724420699_IS_ACTIVE = TRUE;SET @MIGRATION_1732629279_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1675420139_IS_ACTIVE = TRUE;SET @MIGRATION_1604898081_IS_ACTIVE = TRUE;SET @MIGRATION_165657926_IS_ACTIVE = TRUE;SET @MIGRATION_1590657517_IS_ACTIVE = TRUE;SET @MIGRATION_1651494367_IS_ACTIVE = TRUE;SET @MIGRATION_1615371170_IS_ACTIVE = TRUE;SET @MIGRATION_1617881178_IS_ACTIVE = TRUE;SET @MIGRATION_1697795798_IS_ACTIVE = TRUE;SET @MIGRATION_1686812041_IS_ACTIVE = TRUE;SET @MIGRATION_1690469830_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_IS_ACTIVE = TRUE;
array:6 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 399)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 198)"
3 => "Shopware\Core\Kernel::boot (line 127)"
4 => "Shopware\Core\HttpKernel::doHandle (line 79)"
5 => "Shopware\Core\HttpKernel::handle (line 85)"
]
|
| 5 |
0.71 ms |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;
array:13 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 252)"
2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 52)"
3 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 36)"
4 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::Shopware\Core\System\SystemConfig\{closure} (line 72)"
5 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::doGet (line 35)"
6 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::get (line 41)"
7 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 37)"
8 => "Shopware\Core\System\SystemConfig\MemoizedSystemConfigLoader::load (line 81)"
9 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 39)"
10 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 138)"
11 => "Shopware\Core\HttpKernel::doHandle (line 79)"
12 => "Shopware\Core\HttpKernel::handle (line 85)"
]
|
| 6 |
0.66 ms |
SELECT item_rounding FROM currency WHERE id = :id
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
array:25 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 684)"
2 => "Doctrine\DBAL\Connection::fetchAssociative (line 330)"
3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getCashRounding (line 57)"
4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 71)"
5 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 38)"
6 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 54)"
10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 99)"
11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 38)"
13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 151)"
15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)"
23 => "Shopware\Core\HttpKernel::doHandle (line 79)"
24 => "Shopware\Core\HttpKernel::handle (line 85)"
]
|
| 7 |
1.00 ms |
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 (IF(JSON_TYPE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL) = :param_aebc93f3e3fc4ddca22bb09ed1b22564)
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 (IF(JSON_TYPE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL) = '2HsWlFojj6rE5l7eYqAEdAFWC5CaZshV');
array:22 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 252)"
2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 314)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 146)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 91)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 256)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 285)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 44)"
9 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::search (line 178)"
10 => "Swag\PayPal\Webhook\WebhookController::validateShopwareToken (line 101)"
11 => "Swag\PayPal\Webhook\WebhookController::executeWebhook (line 163)"
12 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
13 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
14 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
15 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
16 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)"
20 => "Shopware\Core\HttpKernel::doHandle (line 79)"
21 => "Shopware\Core\HttpKernel::handle (line 85)"
]
|