Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

13 Database Queries

Different statements

7.91 ms Query time

Invalid entities

Queries

Group similar statements


# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
SELECT custom_entity.name, custom_entity.fields
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));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_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_1707984263_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1662757955_IS_ACTIVE = TRUE;SET @MIGRATION_1663039410_IS_ACTIVE = TRUE;SET @MIGRATION_1676830357_IS_ACTIVE = TRUE;SET @MIGRATION_1584635124_IS_ACTIVE = TRUE;SET @MIGRATION_1654529559_IS_ACTIVE = TRUE;SET @MIGRATION_1663348079_IS_ACTIVE = TRUE;SET @MIGRATION_1664148561_IS_ACTIVE = TRUE;SET @MIGRATION_1674735643_IS_ACTIVE = TRUE;SET @MIGRATION_1676971558_IS_ACTIVE = TRUE
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT last_updated_password_at FROM user WHERE id = :userId
SELECT item_rounding FROM currency WHERE id = :id
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = :userId
SELECT admin FROM `user` WHERE id = :id
SELECT `swag_language_pack_language.language.locale`.`code` as `locales.key`, COUNT(`swag_language_pack_language`.`id`) as `locales.count` FROM `swag_language_pack_language` LEFT JOIN `language` `swag_language_pack_language.language` ON `swag_language_pack_language`.`language_id` = `swag_language_pack_language.language`.`id` LEFT JOIN `locale` `swag_language_pack_language.language.locale` ON `swag_language_pack_language.language`.`locale_id` = `swag_language_pack_language.language.locale`.`id` WHERE (`swag_language_pack_language`.`administration_active` = :param_4f5a1438c0584bc6afb6a8d1a9c7c4b6) GROUP BY `swag_language_pack_language.language.locale`.`code`
SELECT `swag_language_pack_language`.`id` FROM `swag_language_pack_language` WHERE (`swag_language_pack_language`.`administration_active` = :param_d98b167f793848118e369854ea21c439) LIMIT 25
SELECT COUNT(*) FROM (SELECT `swag_language_pack_language`.`id` FROM `swag_language_pack_language` WHERE (`swag_language_pack_language`.`administration_active` = :param_d98b167f793848118e369854ea21c439)) total
SELECT `swag_language_pack_language`.`id` as `swag_language_pack_language.id`, `swag_language_pack_language`.`administration_active` as `swag_language_pack_language.administrationActive`, `swag_language_pack_language`.`sales_channel_active` as `swag_language_pack_language.salesChannelActive`, `swag_language_pack_language`.`language_id` as `swag_language_pack_language.languageId`, `swag_language_pack_language.language`.`id` as `swag_language_pack_language.language.id`, `swag_language_pack_language.language`.`parent_id` as `swag_language_pack_language.language.parentId`, `swag_language_pack_language.language`.`locale_id` as `swag_language_pack_language.language.localeId`, `swag_language_pack_language.language`.`translation_code_id` as `swag_language_pack_language.language.translationCodeId`, `swag_language_pack_language.language`.`name` as `swag_language_pack_language.language.name`, `swag_language_pack_language.language`.`custom_fields` as `swag_language_pack_language.language.customFields`, `swag_language_pack_language.language`.`created_at` as `swag_language_pack_language.language.createdAt`, `swag_language_pack_language.language`.`updated_at` as `swag_language_pack_language.language.updatedAt`, `swag_language_pack_language.language.locale`.`id` as `swag_language_pack_language.language.locale.id`, `swag_language_pack_language.language.locale`.`code` as `swag_language_pack_language.language.locale.code`, `swag_language_pack_language.language.locale`.`created_at` as `swag_language_pack_language.language.locale.createdAt`, `swag_language_pack_language.language.locale`.`updated_at` as `swag_language_pack_language.language.locale.updatedAt`, `swag_language_pack_language.language.locale.translation.name`, COALESCE(`swag_language_pack_language.language.locale.translation.name`,`swag_language_pack_language.language.locale.translation.name`) as `swag_language_pack_language.language.locale.name`, `swag_language_pack_language.language.locale.translation.territory`, COALESCE(`swag_language_pack_language.language.locale.translation.territory`,`swag_language_pack_language.language.locale.translation.territory`) as `swag_language_pack_language.language.locale.territory`, `swag_language_pack_language.language.locale.translation.customFields`, COALESCE(`swag_language_pack_language.language.locale.translation.customFields`,`swag_language_pack_language.language.locale.translation.customFields`) as `swag_language_pack_language.language.locale.customFields`, `swag_language_pack_language.language.locale.translation.createdAt`, `swag_language_pack_language.language.locale.translation.updatedAt`, `swag_language_pack_language.language.locale.translation.localeId`, `swag_language_pack_language.language.locale.translation.languageId`, `swag_language_pack_language`.`created_at` as `swag_language_pack_language.createdAt`, `swag_language_pack_language`.`updated_at` as `swag_language_pack_language.updatedAt` FROM `swag_language_pack_language` LEFT JOIN `language` `swag_language_pack_language.language` ON `swag_language_pack_language`.`language_id` = `swag_language_pack_language.language`.`id` LEFT JOIN `locale` `swag_language_pack_language.language.locale` ON `swag_language_pack_language.language`.`locale_id` = `swag_language_pack_language.language.locale`.`id` LEFT JOIN (SELECT `swag_language_pack_language.language.locale.translation`.locale_id, `swag_language_pack_language.language.locale.translation`.name as `swag_language_pack_language.language.locale.translation.name`, `swag_language_pack_language.language.locale.translation`.territory as `swag_language_pack_language.language.locale.translation.territory`, `swag_language_pack_language.language.locale.translation`.custom_fields as `swag_language_pack_language.language.locale.translation.customFields`, `swag_language_pack_language.language.locale.translation`.created_at as `swag_language_pack_language.language.locale.translation.createdAt`, `swag_language_pack_language.language.locale.translation`.updated_at as `swag_language_pack_language.language.locale.translation.updatedAt`, `swag_language_pack_language.language.locale.translation`.locale_id as `swag_language_pack_language.language.locale.translation.localeId`, `swag_language_pack_language.language.locale.translation`.language_id as `swag_language_pack_language.language.locale.translation.languageId` FROM `locale_translation` `swag_language_pack_language.language.locale.translation` WHERE `swag_language_pack_language.language.locale.translation`.language_id = :languageId) `swag_language_pack_language.language.locale.locale_translation` ON `swag_language_pack_language.language.locale.locale_translation`.`locale_id` = `swag_language_pack_language.language.locale`.`id` WHERE `swag_language_pack_language`.`id` IN (:ids)

#▲	Time	Info
1	0.64 ms	# dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`; View formatted query View runnable query View query stack # dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF( `active` = 1 AND `installed_at` IS NOT NULL, 1, 0 ) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`; # dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`;; array:7 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 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 View formatted query View runnable query View query stack SELECT custom_entity.name, custom_entity.fields FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1 SELECT custom_entity.name, custom_entity.fields FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1 ; array:8 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)" 2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 38)" 3 => "Shopware\Core\System\CustomEntity\CustomEntityRegistrar::register (line 57)" 4 => "Shopware\Core\System\System::boot (line 195)" 5 => "Shopware\Core\Kernel::boot (line 127)" 6 => "Shopware\Core\HttpKernel::doHandle (line 79)" 7 => "Shopware\Core\HttpKernel::handle (line 85)"`]
3	0.67 ms	SELECT `creation_timestamp` FROM `migration` WHERE `update` IS NOT NULL AND `update_destructive` IS NULL View formatted query View runnable query View query stack SELECT `creation_timestamp` FROM `migration` WHERE `update` IS NOT NULL AND `update_destructive` IS NULL SELECT `creation_timestamp` FROM `migration` WHERE `update` IS NOT NULL AND `update_destructive` IS NULL ; array:6 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 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.62 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_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_1707984263_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1662757955_IS_ACTIVE = TRUE;SET @MIGRATION_1663039410_IS_ACTIVE = TRUE;SET @MIGRATION_1676830357_IS_ACTIVE = TRUE;SET @MIGRATION_1584635124_IS_ACTIVE = TRUE;SET @MIGRATION_1654529559_IS_ACTIVE = TRUE;SET @MIGRATION_1663348079_IS_ACTIVE = TRUE;SET @MIGRATION_1664148561_IS_ACTIVE = TRUE;SET @MIGRATION_1674735643_IS_ACTIVE = TRUE;SET @MIGRATION_1676971558_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_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_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_1707984263_IS_ACTIVE = TRUE; SET @MIGRATION_1628172267_IS_ACTIVE = TRUE; SET @MIGRATION_1644922949_IS_ACTIVE = TRUE; SET @MIGRATION_1688378836_IS_ACTIVE = TRUE; SET @MIGRATION_1616141231_IS_ACTIVE = TRUE; SET @MIGRATION_1631631689_IS_ACTIVE = TRUE; SET @MIGRATION_1636082647_IS_ACTIVE = TRUE; SET @MIGRATION_1662306139_IS_ACTIVE = TRUE; SET @MIGRATION_1662757955_IS_ACTIVE = TRUE; SET @MIGRATION_1663039410_IS_ACTIVE = TRUE; SET @MIGRATION_1676830357_IS_ACTIVE = TRUE; SET @MIGRATION_1584635124_IS_ACTIVE = TRUE; SET @MIGRATION_1654529559_IS_ACTIVE = TRUE; SET @MIGRATION_1663348079_IS_ACTIVE = TRUE; SET @MIGRATION_1664148561_IS_ACTIVE = TRUE; SET @MIGRATION_1674735643_IS_ACTIVE = TRUE; SET @MIGRATION_1676971558_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_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_1707984263_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1662757955_IS_ACTIVE = TRUE;SET @MIGRATION_1663039410_IS_ACTIVE = TRUE;SET @MIGRATION_1676830357_IS_ACTIVE = TRUE;SET @MIGRATION_1584635124_IS_ACTIVE = TRUE;SET @MIGRATION_1654529559_IS_ACTIVE = TRUE;SET @MIGRATION_1663348079_IS_ACTIVE = TRUE;SET @MIGRATION_1664148561_IS_ACTIVE = TRUE;SET @MIGRATION_1674735643_IS_ACTIVE = TRUE;SET @MIGRATION_1676971558_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	1.17 ms	SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC View formatted query View runnable query View query stack SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC; array:13 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 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.38 ms	SELECT last_updated_password_at FROM user WHERE id = :userId View formatted query View runnable query View query stack SELECT last_updated_password_at FROM user WHERE id = : userId SELECT last_updated_password_at FROM user WHERE id = 0x19B619EE82F4410186EC7178E247A119; array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 252)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 69)" 3 => "Shopware\Core\Framework\Api\OAuth\BearerTokenValidator::validateAccessTokenIssuedAt (line 53)" 4 => "Shopware\Core\Framework\Api\OAuth\BearerTokenValidator::validateAuthorization (line 84)" 5 => "League\OAuth2\Server\ResourceServer::validateAuthenticatedRequest (line 105)" 6 => "Shopware\Core\Framework\Api\EventListener\Authentication\ApiAuthenticationListener::validateRequest (line 117)" 7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 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	0.18 ms	SELECT item_rounding FROM currency WHERE id = :id View formatted query View runnable query View query stack SELECT item_rounding FROM currency WHERE id = : id SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA; array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 684)" 2 => "Doctrine\DBAL\Connection::fetchAssociative (line 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)"]
8	0.24 ms	SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = :userId View formatted query View runnable query View query stack SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = : userId SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0x19B619EE82F4410186EC7178E247A119; array:27 [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\Routing\ApiRequestContextResolver::fetchPermissions (line 274)" 4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getAdminApiSource (line 149)" 5 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolveContextSource (line 60)" 6 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 71)" 7 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 38)" 8 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)" 9 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 10 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 11 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 54)" 12 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 99)" 13 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)" 14 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 38)" 15 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 16 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 151)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 25 => "Shopware\Core\HttpKernel::doHandle (line 79)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
9	0.16 ms	SELECT admin FROM `user` WHERE id = :id View formatted query View runnable query View query stack SELECT admin FROM `user` WHERE id = : id SELECT admin FROM `user` WHERE id = 0x19B619EE82F4410186EC7178E247A119; array:27 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 734)" 2 => "Doctrine\DBAL\Connection::fetchOne (line 294)" 3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::isAdmin (line 275)" 4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getAdminApiSource (line 149)" 5 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolveContextSource (line 60)" 6 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 71)" 7 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 38)" 8 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)" 9 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 10 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 11 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 54)" 12 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 99)" 13 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)" 14 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 38)" 15 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 16 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 151)" 17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 25 => "Shopware\Core\HttpKernel::doHandle (line 79)" 26 => "Shopware\Core\HttpKernel::handle (line 85)"]
10	1.29 ms	SELECT `swag_language_pack_language.language.locale`.`code` as `locales.key`, COUNT(`swag_language_pack_language`.`id`) as `locales.count` FROM `swag_language_pack_language` LEFT JOIN `language` `swag_language_pack_language.language` ON `swag_language_pack_language`.`language_id` = `swag_language_pack_language.language`.`id` LEFT JOIN `locale` `swag_language_pack_language.language.locale` ON `swag_language_pack_language.language`.`locale_id` = `swag_language_pack_language.language.locale`.`id` WHERE (`swag_language_pack_language`.`administration_active` = :param_4f5a1438c0584bc6afb6a8d1a9c7c4b6) GROUP BY `swag_language_pack_language.language.locale`.`code` View formatted query View runnable query View query stack SELECT `swag_language_pack_language.language.locale`.`code` as `locales.key`, COUNT( `swag_language_pack_language`.`id` ) as `locales.count` FROM `swag_language_pack_language` LEFT JOIN `language` `swag_language_pack_language.language` ON `swag_language_pack_language`.`language_id` = `swag_language_pack_language.language`.`id` LEFT JOIN `locale` `swag_language_pack_language.language.locale` ON `swag_language_pack_language.language`.`locale_id` = `swag_language_pack_language.language.locale`.`id` WHERE ( `swag_language_pack_language`.`administration_active` = : param_4f5a1438c0584bc6afb6a8d1a9c7c4b6 ) GROUP BY `swag_language_pack_language.language.locale`.`code` SELECT `swag_language_pack_language.language.locale`.`code` as `locales.key`, COUNT(`swag_language_pack_language`.`id`) as `locales.count` FROM `swag_language_pack_language` LEFT JOIN `language` `swag_language_pack_language.language` ON `swag_language_pack_language`.`language_id` = `swag_language_pack_language.language`.`id` LEFT JOIN `locale` `swag_language_pack_language.language.locale` ON `swag_language_pack_language.language`.`locale_id` = `swag_language_pack_language.language.locale`.`id` WHERE (`swag_language_pack_language`.`administration_active` = 1) GROUP BY `swag_language_pack_language.language.locale`.`code`; array:23 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 252)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 203)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator::fetchAggregation (line 93)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator::aggregate (line 53)" 5 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator::aggregate (line 117)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::aggregate (line 278)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 37)" 9 => "Swag\LanguagePack\Core\Content\PackLanguageRepositoryDecorator::search (line 376)" 10 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 221)" 11 => "Shopware\Core\Framework\Context::scope (line 377)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::search (line 163)" 13 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 14 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 15 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 16 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 21 => "Shopware\Core\HttpKernel::doHandle (line 79)" 22 => "Shopware\Core\HttpKernel::handle (line 85)"]
11	0.21 ms	SELECT `swag_language_pack_language`.`id` FROM `swag_language_pack_language` WHERE (`swag_language_pack_language`.`administration_active` = :param_d98b167f793848118e369854ea21c439) LIMIT 25 View formatted query View runnable query View query stack SELECT `swag_language_pack_language`.`id` FROM `swag_language_pack_language` WHERE ( `swag_language_pack_language`.`administration_active` = : param_d98b167f793848118e369854ea21c439 ) LIMIT 25 SELECT `swag_language_pack_language`.`id` FROM `swag_language_pack_language` WHERE (`swag_language_pack_language`.`administration_active` = 1) LIMIT 25; 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 105)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 63)" 4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 131)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 290)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 37)" 8 => "Swag\LanguagePack\Core\Content\PackLanguageRepositoryDecorator::search (line 376)" 9 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 221)" 10 => "Shopware\Core\Framework\Context::scope (line 377)" 11 => "Shopware\Core\Framework\Api\Controller\ApiController::search (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)"]
12	0.17 ms	SELECT COUNT() FROM (SELECT `swag_language_pack_language`.`id` FROM `swag_language_pack_language` WHERE (`swag_language_pack_language`.`administration_active` = :param_d98b167f793848118e369854ea21c439)) total View formatted query View runnable query View query stack SELECT COUNT() FROM ( SELECT `swag_language_pack_language`.`id` FROM `swag_language_pack_language` WHERE ( `swag_language_pack_language`.`administration_active` = : param_d98b167f793848118e369854ea21c439 ) ) total SELECT COUNT(*) FROM (SELECT `swag_language_pack_language`.`id` FROM `swag_language_pack_language` WHERE (`swag_language_pack_language`.`administration_active` = 1)) total; array:23 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 252)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 193)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::getTotalCount (line 107)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 63)" 5 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 131)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 290)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 37)" 9 => "Swag\LanguagePack\Core\Content\PackLanguageRepositoryDecorator::search (line 376)" 10 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 221)" 11 => "Shopware\Core\Framework\Context::scope (line 377)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::search (line 163)" 13 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 14 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 15 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 16 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 21 => "Shopware\Core\HttpKernel::doHandle (line 79)" 22 => "Shopware\Core\HttpKernel::handle (line 85)"]
13	1.66 ms	SELECT `swag_language_pack_language`.`id` as `swag_language_pack_language.id`, `swag_language_pack_language`.`administration_active` as `swag_language_pack_language.administrationActive`, `swag_language_pack_language`.`sales_channel_active` as `swag_language_pack_language.salesChannelActive`, `swag_language_pack_language`.`language_id` as `swag_language_pack_language.languageId`, `swag_language_pack_language.language`.`id` as `swag_language_pack_language.language.id`, `swag_language_pack_language.language`.`parent_id` as `swag_language_pack_language.language.parentId`, `swag_language_pack_language.language`.`locale_id` as `swag_language_pack_language.language.localeId`, `swag_language_pack_language.language`.`translation_code_id` as `swag_language_pack_language.language.translationCodeId`, `swag_language_pack_language.language`.`name` as `swag_language_pack_language.language.name`, `swag_language_pack_language.language`.`custom_fields` as `swag_language_pack_language.language.customFields`, `swag_language_pack_language.language`.`created_at` as `swag_language_pack_language.language.createdAt`, `swag_language_pack_language.language`.`updated_at` as `swag_language_pack_language.language.updatedAt`, `swag_language_pack_language.language.locale`.`id` as `swag_language_pack_language.language.locale.id`, `swag_language_pack_language.language.locale`.`code` as `swag_language_pack_language.language.locale.code`, `swag_language_pack_language.language.locale`.`created_at` as `swag_language_pack_language.language.locale.createdAt`, `swag_language_pack_language.language.locale`.`updated_at` as `swag_language_pack_language.language.locale.updatedAt`, `swag_language_pack_language.language.locale.translation.name`, COALESCE(`swag_language_pack_language.language.locale.translation.name`,`swag_language_pack_language.language.locale.translation.name`) as `swag_language_pack_language.language.locale.name`, `swag_language_pack_language.language.locale.translation.territory`, COALESCE(`swag_language_pack_language.language.locale.translation.territory`,`swag_language_pack_language.language.locale.translation.territory`) as `swag_language_pack_language.language.locale.territory`, `swag_language_pack_language.language.locale.translation.customFields`, COALESCE(`swag_language_pack_language.language.locale.translation.customFields`,`swag_language_pack_language.language.locale.translation.customFields`) as `swag_language_pack_language.language.locale.customFields`, `swag_language_pack_language.language.locale.translation.createdAt`, `swag_language_pack_language.language.locale.translation.updatedAt`, `swag_language_pack_language.language.locale.translation.localeId`, `swag_language_pack_language.language.locale.translation.languageId`, `swag_language_pack_language`.`created_at` as `swag_language_pack_language.createdAt`, `swag_language_pack_language`.`updated_at` as `swag_language_pack_language.updatedAt` FROM `swag_language_pack_language` LEFT JOIN `language` `swag_language_pack_language.language` ON `swag_language_pack_language`.`language_id` = `swag_language_pack_language.language`.`id` LEFT JOIN `locale` `swag_language_pack_language.language.locale` ON `swag_language_pack_language.language`.`locale_id` = `swag_language_pack_language.language.locale`.`id` LEFT JOIN (SELECT `swag_language_pack_language.language.locale.translation`.locale_id, `swag_language_pack_language.language.locale.translation`.name as `swag_language_pack_language.language.locale.translation.name`, `swag_language_pack_language.language.locale.translation`.territory as `swag_language_pack_language.language.locale.translation.territory`, `swag_language_pack_language.language.locale.translation`.custom_fields as `swag_language_pack_language.language.locale.translation.customFields`, `swag_language_pack_language.language.locale.translation`.created_at as `swag_language_pack_language.language.locale.translation.createdAt`, `swag_language_pack_language.language.locale.translation`.updated_at as `swag_language_pack_language.language.locale.translation.updatedAt`, `swag_language_pack_language.language.locale.translation`.locale_id as `swag_language_pack_language.language.locale.translation.localeId`, `swag_language_pack_language.language.locale.translation`.language_id as `swag_language_pack_language.language.locale.translation.languageId` FROM `locale_translation` `swag_language_pack_language.language.locale.translation` WHERE `swag_language_pack_language.language.locale.translation`.language_id = :languageId) `swag_language_pack_language.language.locale.locale_translation` ON `swag_language_pack_language.language.locale.locale_translation`.`locale_id` = `swag_language_pack_language.language.locale`.`id` WHERE `swag_language_pack_language`.`id` IN (:ids) View formatted query View runnable query View query stack SELECT `swag_language_pack_language`.`id` as `swag_language_pack_language.id`, `swag_language_pack_language`.`administration_active` as `swag_language_pack_language.administrationActive`, `swag_language_pack_language`.`sales_channel_active` as `swag_language_pack_language.salesChannelActive`, `swag_language_pack_language`.`language_id` as `swag_language_pack_language.languageId`, `swag_language_pack_language.language`.`id` as `swag_language_pack_language.language.id`, `swag_language_pack_language.language`.`parent_id` as `swag_language_pack_language.language.parentId`, `swag_language_pack_language.language`.`locale_id` as `swag_language_pack_language.language.localeId`, `swag_language_pack_language.language`.`translation_code_id` as `swag_language_pack_language.language.translationCodeId`, `swag_language_pack_language.language`.`name` as `swag_language_pack_language.language.name`, `swag_language_pack_language.language`.`custom_fields` as `swag_language_pack_language.language.customFields`, `swag_language_pack_language.language`.`created_at` as `swag_language_pack_language.language.createdAt`, `swag_language_pack_language.language`.`updated_at` as `swag_language_pack_language.language.updatedAt`, `swag_language_pack_language.language.locale`.`id` as `swag_language_pack_language.language.locale.id`, `swag_language_pack_language.language.locale`.`code` as `swag_language_pack_language.language.locale.code`, `swag_language_pack_language.language.locale`.`created_at` as `swag_language_pack_language.language.locale.createdAt`, `swag_language_pack_language.language.locale`.`updated_at` as `swag_language_pack_language.language.locale.updatedAt`, `swag_language_pack_language.language.locale.translation.name`, COALESCE( `swag_language_pack_language.language.locale.translation.name`, `swag_language_pack_language.language.locale.translation.name` ) as `swag_language_pack_language.language.locale.name`, `swag_language_pack_language.language.locale.translation.territory`, COALESCE( `swag_language_pack_language.language.locale.translation.territory`, `swag_language_pack_language.language.locale.translation.territory` ) as `swag_language_pack_language.language.locale.territory`, `swag_language_pack_language.language.locale.translation.customFields`, COALESCE( `swag_language_pack_language.language.locale.translation.customFields`, `swag_language_pack_language.language.locale.translation.customFields` ) as `swag_language_pack_language.language.locale.customFields`, `swag_language_pack_language.language.locale.translation.createdAt`, `swag_language_pack_language.language.locale.translation.updatedAt`, `swag_language_pack_language.language.locale.translation.localeId`, `swag_language_pack_language.language.locale.translation.languageId`, `swag_language_pack_language`.`created_at` as `swag_language_pack_language.createdAt`, `swag_language_pack_language`.`updated_at` as `swag_language_pack_language.updatedAt` FROM `swag_language_pack_language` LEFT JOIN `language` `swag_language_pack_language.language` ON `swag_language_pack_language`.`language_id` = `swag_language_pack_language.language`.`id` LEFT JOIN `locale` `swag_language_pack_language.language.locale` ON `swag_language_pack_language.language`.`locale_id` = `swag_language_pack_language.language.locale`.`id` LEFT JOIN ( SELECT `swag_language_pack_language.language.locale.translation`.locale_id, `swag_language_pack_language.language.locale.translation`.name as `swag_language_pack_language.language.locale.translation.name`, `swag_language_pack_language.language.locale.translation`.territory as `swag_language_pack_language.language.locale.translation.territory`, `swag_language_pack_language.language.locale.translation`.custom_fields as `swag_language_pack_language.language.locale.translation.customFields`, `swag_language_pack_language.language.locale.translation`.created_at as `swag_language_pack_language.language.locale.translation.createdAt`, `swag_language_pack_language.language.locale.translation`.updated_at as `swag_language_pack_language.language.locale.translation.updatedAt`, `swag_language_pack_language.language.locale.translation`.locale_id as `swag_language_pack_language.language.locale.translation.localeId`, `swag_language_pack_language.language.locale.translation`.language_id as `swag_language_pack_language.language.locale.translation.languageId` FROM `locale_translation` `swag_language_pack_language.language.locale.translation` WHERE `swag_language_pack_language.language.locale.translation`.language_id = : languageId ) `swag_language_pack_language.language.locale.locale_translation` ON `swag_language_pack_language.language.locale.locale_translation`.`locale_id` = `swag_language_pack_language.language.locale`.`id` WHERE `swag_language_pack_language`.`id` IN (: ids) SELECT `swag_language_pack_language`.`id` as `swag_language_pack_language.id`, `swag_language_pack_language`.`administration_active` as `swag_language_pack_language.administrationActive`, `swag_language_pack_language`.`sales_channel_active` as `swag_language_pack_language.salesChannelActive`, `swag_language_pack_language`.`language_id` as `swag_language_pack_language.languageId`, `swag_language_pack_language.language`.`id` as `swag_language_pack_language.language.id`, `swag_language_pack_language.language`.`parent_id` as `swag_language_pack_language.language.parentId`, `swag_language_pack_language.language`.`locale_id` as `swag_language_pack_language.language.localeId`, `swag_language_pack_language.language`.`translation_code_id` as `swag_language_pack_language.language.translationCodeId`, `swag_language_pack_language.language`.`name` as `swag_language_pack_language.language.name`, `swag_language_pack_language.language`.`custom_fields` as `swag_language_pack_language.language.customFields`, `swag_language_pack_language.language`.`created_at` as `swag_language_pack_language.language.createdAt`, `swag_language_pack_language.language`.`updated_at` as `swag_language_pack_language.language.updatedAt`, `swag_language_pack_language.language.locale`.`id` as `swag_language_pack_language.language.locale.id`, `swag_language_pack_language.language.locale`.`code` as `swag_language_pack_language.language.locale.code`, `swag_language_pack_language.language.locale`.`created_at` as `swag_language_pack_language.language.locale.createdAt`, `swag_language_pack_language.language.locale`.`updated_at` as `swag_language_pack_language.language.locale.updatedAt`, `swag_language_pack_language.language.locale.translation.name`, COALESCE(`swag_language_pack_language.language.locale.translation.name`,`swag_language_pack_language.language.locale.translation.name`) as `swag_language_pack_language.language.locale.name`, `swag_language_pack_language.language.locale.translation.territory`, COALESCE(`swag_language_pack_language.language.locale.translation.territory`,`swag_language_pack_language.language.locale.translation.territory`) as `swag_language_pack_language.language.locale.territory`, `swag_language_pack_language.language.locale.translation.customFields`, COALESCE(`swag_language_pack_language.language.locale.translation.customFields`,`swag_language_pack_language.language.locale.translation.customFields`) as `swag_language_pack_language.language.locale.customFields`, `swag_language_pack_language.language.locale.translation.createdAt`, `swag_language_pack_language.language.locale.translation.updatedAt`, `swag_language_pack_language.language.locale.translation.localeId`, `swag_language_pack_language.language.locale.translation.languageId`, `swag_language_pack_language`.`created_at` as `swag_language_pack_language.createdAt`, `swag_language_pack_language`.`updated_at` as `swag_language_pack_language.updatedAt` FROM `swag_language_pack_language` LEFT JOIN `language` `swag_language_pack_language.language` ON `swag_language_pack_language`.`language_id` = `swag_language_pack_language.language`.`id` LEFT JOIN `locale` `swag_language_pack_language.language.locale` ON `swag_language_pack_language.language`.`locale_id` = `swag_language_pack_language.language.locale`.`id` LEFT JOIN (SELECT `swag_language_pack_language.language.locale.translation`.locale_id, `swag_language_pack_language.language.locale.translation`.name as `swag_language_pack_language.language.locale.translation.name`, `swag_language_pack_language.language.locale.translation`.territory as `swag_language_pack_language.language.locale.translation.territory`, `swag_language_pack_language.language.locale.translation`.custom_fields as `swag_language_pack_language.language.locale.translation.customFields`, `swag_language_pack_language.language.locale.translation`.created_at as `swag_language_pack_language.language.locale.translation.createdAt`, `swag_language_pack_language.language.locale.translation`.updated_at as `swag_language_pack_language.language.locale.translation.updatedAt`, `swag_language_pack_language.language.locale.translation`.locale_id as `swag_language_pack_language.language.locale.translation.localeId`, `swag_language_pack_language.language.locale.translation`.language_id as `swag_language_pack_language.language.locale.translation.languageId` FROM `locale_translation` `swag_language_pack_language.language.locale.translation` WHERE `swag_language_pack_language.language.locale.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `swag_language_pack_language.language.locale.locale_translation` ON `swag_language_pack_language.language.locale.locale_translation`.`locale_id` = `swag_language_pack_language.language.locale`.`id` WHERE `swag_language_pack_language`.`id` IN (0x0D491DFA7D4648119AD6A567157D103B, 0x1794F66F965C40A89EF5D917A7BF0B98, 0x1A536683483C48DAAD5A5C22F5C9AB79, 0x1AAFBAD91E3F4DABA64405041E732AAD, 0x1C42DB4A32454E0F9F2B1D432949C33E, 0x1C8D4218A1FB4F58963BADFCA1336286, 0x267093B7591A47D695C8525415F9AA37, 0x5101B07D231A457491AC65ADA3EE2049, 0x5DD2592C42F245D986A55F130DA20282, 0x63B2F41413BC4B8CBF0C03CC6FBCA173, 0x73A239B9935A4F2EBA153D7B818EF4FA, 0x7F35084F6618438A88E2039E180C047E, 0x7F5EE1CFFC8A42919C3C944AA1BF5956, 0x8942CE42B46146F595DC4DA68C9D141D, 0x9A28AEC510BC49A7BA43E57BC0B2EFD7, 0x9BD482D148A64813909080201580FDEF, 0xC56F63DB416F457ABCF167900D27C4A9, 0xCA5A7E3FD73441009F38EA870F14387D, 0xCFB1A5EBE90C44C584CD4C7879B5AB10, 0xD4C41297D0794EDB95AB7281F3BC4DC6, 0xDD1D6740DDD6474786E9A242FE6C08F7, 0xDD76980CB73A469F9DA261BE29FBF2D9, 0xDF98A749B57246CDA312817385747958, 0xE0312E46E2964EE3A4DEDE6C9B8320EB, 0xE2AE063C57CD41D39F6FFCBD9152D2FF); array:23 [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 301)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 37)" 9 => "Swag\LanguagePack\Core\Content\PackLanguageRepositoryDecorator::search (line 376)" 10 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 221)" 11 => "Shopware\Core\Framework\Context::scope (line 377)" 12 => "Shopware\Core\Framework\Api\Controller\ApiController::search (line 163)" 13 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 14 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 15 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 16 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 21 => "Shopware\Core\HttpKernel::doHandle (line 79)" 22 => "Shopware\Core\HttpKernel::handle (line 85)"]

Database Connections

There are no configured database connections.

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

https://dev.artecon.426.agency/api/search/swag-language-pack-language Return to referer URL

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://dev.artecon.426.agency/api/search/swag-language-pack-language Return to referer URL

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping