Symfony Profiler

https://dev.artecon.426.agency/api/search/order-address

Method: POST
HTTP Status: 200
IP: 89.22.120.22
Profiled on: Fri, 22 Nov 2024 10:59:09 +0000
Token: 80b5f7

Last 10 Latest Search

Settings

Query Metrics

14 Database Queries

Different statements

11.34 ms Query time

Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.45 ms (0.00%)		# 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)"`]
0.43 ms (0.00%)		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)"`]
0.41 ms (0.00%)		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)"`]
0.75 ms (0.00%)		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 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 @@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; 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)"`]
1.77 ms (0.00%)		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)"]
1.15 ms (0.00%)		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 = 0x07E124F8262A43899F8C964656633A35; 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)"]
0.28 ms (0.00%)		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)"]
0.27 ms (0.00%)		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 = 0x07E124F8262A43899F8C964656633A35; 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)"]
0.21 ms (0.00%)		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 = 0x07E124F8262A43899F8C964656633A35; 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)"]
0.45 ms (0.00%)		SELECT `order_address`.`id` FROM `order_address` WHERE (`order_address`.`version_id` = :version) AND ((`order_address`.`order_id` = :param_73bfc017f5af4bf19bfc835d0294a4e5)) LIMIT 25 View formatted query View runnable query View query stack SELECT `order_address`.`id` FROM `order_address` WHERE ( `order_address`.`version_id` = : version ) AND ( ( `order_address`.`order_id` = : param_73bfc017f5af4bf19bfc835d0294a4e5 ) ) LIMIT 25 SELECT `order_address`.`id` FROM `order_address` WHERE (`order_address`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`order_address`.`order_id` = 0x27DD86023E6A4AA7852FF808788E72E5)) 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 44)" 8 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::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)"]
0.25 ms (0.00%)		SELECT COUNT() FROM (SELECT `order_address`.`id` FROM `order_address` WHERE (`order_address`.`version_id` = :version) AND ((`order_address`.`order_id` = :param_73bfc017f5af4bf19bfc835d0294a4e5))) total View formatted query View runnable query View query stack SELECT COUNT() FROM ( SELECT `order_address`.`id` FROM `order_address` WHERE ( `order_address`.`version_id` = : version ) AND ( ( `order_address`.`order_id` = : param_73bfc017f5af4bf19bfc835d0294a4e5 ) ) ) total SELECT COUNT(*) FROM (SELECT `order_address`.`id` FROM `order_address` WHERE (`order_address`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`order_address`.`order_id` = 0x27DD86023E6A4AA7852FF808788E72E5))) 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 44)" 9 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::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)"]
4.02 ms (0.00%)		SELECT `order_address`.`id` as `order_address.id`, `order_address`.`version_id` as `order_address.versionId`, `order_address`.`country_id` as `order_address.countryId`, `order_address`.`country_state_id` as `order_address.countryStateId`, `order_address`.`order_id` as `order_address.orderId`, `order_address`.`order_version_id` as `order_address.orderVersionId`, `order_address`.`salutation_id` as `order_address.salutationId`, `order_address`.`first_name` as `order_address.firstName`, `order_address`.`last_name` as `order_address.lastName`, `order_address`.`street` as `order_address.street`, `order_address`.`zipcode` as `order_address.zipcode`, `order_address`.`city` as `order_address.city`, `order_address`.`company` as `order_address.company`, `order_address`.`department` as `order_address.department`, `order_address`.`title` as `order_address.title`, `order_address`.`vat_id` as `order_address.vatId`, `order_address`.`phone_number` as `order_address.phoneNumber`, `order_address`.`additional_address_line1` as `order_address.additionalAddressLine1`, `order_address`.`additional_address_line2` as `order_address.additionalAddressLine2`, `order_address`.`custom_fields` as `order_address.customFields`, `order_address`.`created_at` as `order_address.createdAt`, `order_address`.`updated_at` as `order_address.updatedAt`, `order_address.country`.`id` as `order_address.country.id`, `order_address.country`.`iso` as `order_address.country.iso`, `order_address.country`.`position` as `order_address.country.position`, `order_address.country`.`active` as `order_address.country.active`, `order_address.country`.`shipping_available` as `order_address.country.shippingAvailable`, `order_address.country`.`iso3` as `order_address.country.iso3`, `order_address.country`.`display_state_in_registration` as `order_address.country.displayStateInRegistration`, `order_address.country`.`force_state_in_registration` as `order_address.country.forceStateInRegistration`, `order_address.country`.`company_tax_free` as `order_address.country.companyTaxFree`, `order_address.country`.`check_vat_id_pattern` as `order_address.country.checkVatIdPattern`, `order_address.country`.`vat_id_required` as `order_address.country.vatIdRequired`, `order_address.country`.`tax_free` as `order_address.country.taxFree`, `order_address.country`.`vat_id_pattern` as `order_address.country.vatIdPattern`, `order_address.country`.`customer_tax` as `order_address.country.customerTax`, `order_address.country`.`company_tax` as `order_address.country.companyTax`, `order_address.country`.`postal_code_required` as `order_address.country.postalCodeRequired`, `order_address.country`.`check_postal_code_pattern` as `order_address.country.checkPostalCodePattern`, `order_address.country`.`check_advanced_postal_code_pattern` as `order_address.country.checkAdvancedPostalCodePattern`, `order_address.country`.`advanced_postal_code_pattern` as `order_address.country.advancedPostalCodePattern`, `order_address.country`.`default_postal_code_pattern` as `order_address.country.defaultPostalCodePattern`, `order_address.country`.`created_at` as `order_address.country.createdAt`, `order_address.country`.`updated_at` as `order_address.country.updatedAt`, `order_address.country.zipValidation`.`id` as `order_address.country.zipValidation.id`, `order_address.country.zipValidation`.`country_id` as `order_address.country.zipValidation.countryId`, `order_address.country.zipValidation`.`min_length` as `order_address.country.zipValidation.minLength`, `order_address.country.zipValidation`.`max_length` as `order_address.country.zipValidation.maxLength`, `order_address.country.zipValidation`.`letters_allowed` as `order_address.country.zipValidation.lettersAllowed`, `order_address.country.zipValidation`.`pattern` as `order_address.country.zipValidation.pattern`, `order_address.country.zipValidation`.`active` as `order_address.country.zipValidation.active`, `order_address.country.zipValidation`.`created_at` as `order_address.country.zipValidation.createdAt`, `order_address.country.zipValidation`.`updated_at` as `order_address.country.zipValidation.updatedAt`, `order_address.country.translation.name`, COALESCE(`order_address.country.translation.name`,`order_address.country.translation.name`) as `order_address.country.name`, `order_address.country.translation.addressFormat`, COALESCE(`order_address.country.translation.addressFormat`,`order_address.country.translation.addressFormat`) as `order_address.country.addressFormat`, `order_address.country.translation.customFields`, COALESCE(`order_address.country.translation.customFields`,`order_address.country.translation.customFields`) as `order_address.country.customFields`, `order_address.country.translation.createdAt`, `order_address.country.translation.updatedAt`, `order_address.country.translation.countryId`, `order_address.country.translation.languageId`, `order_address.countryState`.`id` as `order_address.countryState.id`, `order_address.countryState`.`country_id` as `order_address.countryState.countryId`, `order_address.countryState`.`short_code` as `order_address.countryState.shortCode`, `order_address.countryState`.`position` as `order_address.countryState.position`, `order_address.countryState`.`active` as `order_address.countryState.active`, `order_address.countryState`.`created_at` as `order_address.countryState.createdAt`, `order_address.countryState`.`updated_at` as `order_address.countryState.updatedAt`, `order_address.countryState.translation.name`, COALESCE(`order_address.countryState.translation.name`,`order_address.countryState.translation.name`) as `order_address.countryState.name`, `order_address.countryState.translation.customFields`, COALESCE(`order_address.countryState.translation.customFields`,`order_address.countryState.translation.customFields`) as `order_address.countryState.customFields`, `order_address.countryState.translation.createdAt`, `order_address.countryState.translation.updatedAt`, `order_address.countryState.translation.countryStateId`, `order_address.countryState.translation.languageId` FROM `order_address` LEFT JOIN `country` `order_address.country` ON `order_address`.`country_id` = `order_address.country`.`id` LEFT JOIN `country_state` `order_address.countryState` ON `order_address`.`country_state_id` = `order_address.countryState`.`id` LEFT JOIN (SELECT `order_address.country.translation`.country_id, `order_address.country.translation`.name as `order_address.country.translation.name`, `order_address.country.translation`.address_format as `order_address.country.translation.addressFormat`, `order_address.country.translation`.custom_fields as `order_address.country.translation.customFields`, `order_address.country.translation`.created_at as `order_address.country.translation.createdAt`, `order_address.country.translation`.updated_at as `order_address.country.translation.updatedAt`, `order_address.country.translation`.country_id as `order_address.country.translation.countryId`, `order_address.country.translation`.language_id as `order_address.country.translation.languageId` FROM `country_translation` `order_address.country.translation` WHERE `order_address.country.translation`.language_id = :languageId) `order_address.country.country_translation` ON `order_address.country.country_translation`.`country_id` = `order_address.country`.`id` LEFT JOIN `coe_country_zip_validation` `order_address.country.zipValidation` ON `order_address.country`.`id` = `order_address.country.zipValidation`.`country_id` LEFT JOIN (SELECT `order_address.countryState.translation`.country_state_id, `order_address.countryState.translation`.name as `order_address.countryState.translation.name`, `order_address.countryState.translation`.custom_fields as `order_address.countryState.translation.customFields`, `order_address.countryState.translation`.created_at as `order_address.countryState.translation.createdAt`, `order_address.countryState.translation`.updated_at as `order_address.countryState.translation.updatedAt`, `order_address.countryState.translation`.country_state_id as `order_address.countryState.translation.countryStateId`, `order_address.countryState.translation`.language_id as `order_address.countryState.translation.languageId` FROM `country_state_translation` `order_address.countryState.translation` WHERE `order_address.countryState.translation`.language_id = :languageId) `order_address.countryState.country_state_translation` ON `order_address.countryState.country_state_translation`.`country_state_id` = `order_address.countryState`.`id` WHERE (`order_address`.`version_id` = :version) AND (`order_address`.`id` IN (:ids)) View formatted query View runnable query View query stack SELECT `order_address`.`id` as `order_address.id`, `order_address`.`version_id` as `order_address.versionId`, `order_address`.`country_id` as `order_address.countryId`, `order_address`.`country_state_id` as `order_address.countryStateId`, `order_address`.`order_id` as `order_address.orderId`, `order_address`.`order_version_id` as `order_address.orderVersionId`, `order_address`.`salutation_id` as `order_address.salutationId`, `order_address`.`first_name` as `order_address.firstName`, `order_address`.`last_name` as `order_address.lastName`, `order_address`.`street` as `order_address.street`, `order_address`.`zipcode` as `order_address.zipcode`, `order_address`.`city` as `order_address.city`, `order_address`.`company` as `order_address.company`, `order_address`.`department` as `order_address.department`, `order_address`.`title` as `order_address.title`, `order_address`.`vat_id` as `order_address.vatId`, `order_address`.`phone_number` as `order_address.phoneNumber`, `order_address`.`additional_address_line1` as `order_address.additionalAddressLine1`, `order_address`.`additional_address_line2` as `order_address.additionalAddressLine2`, `order_address`.`custom_fields` as `order_address.customFields`, `order_address`.`created_at` as `order_address.createdAt`, `order_address`.`updated_at` as `order_address.updatedAt`, `order_address.country`.`id` as `order_address.country.id`, `order_address.country`.`iso` as `order_address.country.iso`, `order_address.country`.`position` as `order_address.country.position`, `order_address.country`.`active` as `order_address.country.active`, `order_address.country`.`shipping_available` as `order_address.country.shippingAvailable`, `order_address.country`.`iso3` as `order_address.country.iso3`, `order_address.country`.`display_state_in_registration` as `order_address.country.displayStateInRegistration`, `order_address.country`.`force_state_in_registration` as `order_address.country.forceStateInRegistration`, `order_address.country`.`company_tax_free` as `order_address.country.companyTaxFree`, `order_address.country`.`check_vat_id_pattern` as `order_address.country.checkVatIdPattern`, `order_address.country`.`vat_id_required` as `order_address.country.vatIdRequired`, `order_address.country`.`tax_free` as `order_address.country.taxFree`, `order_address.country`.`vat_id_pattern` as `order_address.country.vatIdPattern`, `order_address.country`.`customer_tax` as `order_address.country.customerTax`, `order_address.country`.`company_tax` as `order_address.country.companyTax`, `order_address.country`.`postal_code_required` as `order_address.country.postalCodeRequired`, `order_address.country`.`check_postal_code_pattern` as `order_address.country.checkPostalCodePattern`, `order_address.country`.`check_advanced_postal_code_pattern` as `order_address.country.checkAdvancedPostalCodePattern`, `order_address.country`.`advanced_postal_code_pattern` as `order_address.country.advancedPostalCodePattern`, `order_address.country`.`default_postal_code_pattern` as `order_address.country.defaultPostalCodePattern`, `order_address.country`.`created_at` as `order_address.country.createdAt`, `order_address.country`.`updated_at` as `order_address.country.updatedAt`, `order_address.country.zipValidation`.`id` as `order_address.country.zipValidation.id`, `order_address.country.zipValidation`.`country_id` as `order_address.country.zipValidation.countryId`, `order_address.country.zipValidation`.`min_length` as `order_address.country.zipValidation.minLength`, `order_address.country.zipValidation`.`max_length` as `order_address.country.zipValidation.maxLength`, `order_address.country.zipValidation`.`letters_allowed` as `order_address.country.zipValidation.lettersAllowed`, `order_address.country.zipValidation`.`pattern` as `order_address.country.zipValidation.pattern`, `order_address.country.zipValidation`.`active` as `order_address.country.zipValidation.active`, `order_address.country.zipValidation`.`created_at` as `order_address.country.zipValidation.createdAt`, `order_address.country.zipValidation`.`updated_at` as `order_address.country.zipValidation.updatedAt`, `order_address.country.translation.name`, COALESCE( `order_address.country.translation.name`, `order_address.country.translation.name` ) as `order_address.country.name`, `order_address.country.translation.addressFormat`, COALESCE( `order_address.country.translation.addressFormat`, `order_address.country.translation.addressFormat` ) as `order_address.country.addressFormat`, `order_address.country.translation.customFields`, COALESCE( `order_address.country.translation.customFields`, `order_address.country.translation.customFields` ) as `order_address.country.customFields`, `order_address.country.translation.createdAt`, `order_address.country.translation.updatedAt`, `order_address.country.translation.countryId`, `order_address.country.translation.languageId`, `order_address.countryState`.`id` as `order_address.countryState.id`, `order_address.countryState`.`country_id` as `order_address.countryState.countryId`, `order_address.countryState`.`short_code` as `order_address.countryState.shortCode`, `order_address.countryState`.`position` as `order_address.countryState.position`, `order_address.countryState`.`active` as `order_address.countryState.active`, `order_address.countryState`.`created_at` as `order_address.countryState.createdAt`, `order_address.countryState`.`updated_at` as `order_address.countryState.updatedAt`, `order_address.countryState.translation.name`, COALESCE( `order_address.countryState.translation.name`, `order_address.countryState.translation.name` ) as `order_address.countryState.name`, `order_address.countryState.translation.customFields`, COALESCE( `order_address.countryState.translation.customFields`, `order_address.countryState.translation.customFields` ) as `order_address.countryState.customFields`, `order_address.countryState.translation.createdAt`, `order_address.countryState.translation.updatedAt`, `order_address.countryState.translation.countryStateId`, `order_address.countryState.translation.languageId` FROM `order_address` LEFT JOIN `country` `order_address.country` ON `order_address`.`country_id` = `order_address.country`.`id` LEFT JOIN `country_state` `order_address.countryState` ON `order_address`.`country_state_id` = `order_address.countryState`.`id` LEFT JOIN ( SELECT `order_address.country.translation`.country_id, `order_address.country.translation`.name as `order_address.country.translation.name`, `order_address.country.translation`.address_format as `order_address.country.translation.addressFormat`, `order_address.country.translation`.custom_fields as `order_address.country.translation.customFields`, `order_address.country.translation`.created_at as `order_address.country.translation.createdAt`, `order_address.country.translation`.updated_at as `order_address.country.translation.updatedAt`, `order_address.country.translation`.country_id as `order_address.country.translation.countryId`, `order_address.country.translation`.language_id as `order_address.country.translation.languageId` FROM `country_translation` `order_address.country.translation` WHERE `order_address.country.translation`.language_id = : languageId ) `order_address.country.country_translation` ON `order_address.country.country_translation`.`country_id` = `order_address.country`.`id` LEFT JOIN `coe_country_zip_validation` `order_address.country.zipValidation` ON `order_address.country`.`id` = `order_address.country.zipValidation`.`country_id` LEFT JOIN ( SELECT `order_address.countryState.translation`.country_state_id, `order_address.countryState.translation`.name as `order_address.countryState.translation.name`, `order_address.countryState.translation`.custom_fields as `order_address.countryState.translation.customFields`, `order_address.countryState.translation`.created_at as `order_address.countryState.translation.createdAt`, `order_address.countryState.translation`.updated_at as `order_address.countryState.translation.updatedAt`, `order_address.countryState.translation`.country_state_id as `order_address.countryState.translation.countryStateId`, `order_address.countryState.translation`.language_id as `order_address.countryState.translation.languageId` FROM `country_state_translation` `order_address.countryState.translation` WHERE `order_address.countryState.translation`.language_id = : languageId ) `order_address.countryState.country_state_translation` ON `order_address.countryState.country_state_translation`.`country_state_id` = `order_address.countryState`.`id` WHERE ( `order_address`.`version_id` = : version ) AND ( `order_address`.`id` IN (: ids) ) SELECT `order_address`.`id` as `order_address.id`, `order_address`.`version_id` as `order_address.versionId`, `order_address`.`country_id` as `order_address.countryId`, `order_address`.`country_state_id` as `order_address.countryStateId`, `order_address`.`order_id` as `order_address.orderId`, `order_address`.`order_version_id` as `order_address.orderVersionId`, `order_address`.`salutation_id` as `order_address.salutationId`, `order_address`.`first_name` as `order_address.firstName`, `order_address`.`last_name` as `order_address.lastName`, `order_address`.`street` as `order_address.street`, `order_address`.`zipcode` as `order_address.zipcode`, `order_address`.`city` as `order_address.city`, `order_address`.`company` as `order_address.company`, `order_address`.`department` as `order_address.department`, `order_address`.`title` as `order_address.title`, `order_address`.`vat_id` as `order_address.vatId`, `order_address`.`phone_number` as `order_address.phoneNumber`, `order_address`.`additional_address_line1` as `order_address.additionalAddressLine1`, `order_address`.`additional_address_line2` as `order_address.additionalAddressLine2`, `order_address`.`custom_fields` as `order_address.customFields`, `order_address`.`created_at` as `order_address.createdAt`, `order_address`.`updated_at` as `order_address.updatedAt`, `order_address.country`.`id` as `order_address.country.id`, `order_address.country`.`iso` as `order_address.country.iso`, `order_address.country`.`position` as `order_address.country.position`, `order_address.country`.`active` as `order_address.country.active`, `order_address.country`.`shipping_available` as `order_address.country.shippingAvailable`, `order_address.country`.`iso3` as `order_address.country.iso3`, `order_address.country`.`display_state_in_registration` as `order_address.country.displayStateInRegistration`, `order_address.country`.`force_state_in_registration` as `order_address.country.forceStateInRegistration`, `order_address.country`.`company_tax_free` as `order_address.country.companyTaxFree`, `order_address.country`.`check_vat_id_pattern` as `order_address.country.checkVatIdPattern`, `order_address.country`.`vat_id_required` as `order_address.country.vatIdRequired`, `order_address.country`.`tax_free` as `order_address.country.taxFree`, `order_address.country`.`vat_id_pattern` as `order_address.country.vatIdPattern`, `order_address.country`.`customer_tax` as `order_address.country.customerTax`, `order_address.country`.`company_tax` as `order_address.country.companyTax`, `order_address.country`.`postal_code_required` as `order_address.country.postalCodeRequired`, `order_address.country`.`check_postal_code_pattern` as `order_address.country.checkPostalCodePattern`, `order_address.country`.`check_advanced_postal_code_pattern` as `order_address.country.checkAdvancedPostalCodePattern`, `order_address.country`.`advanced_postal_code_pattern` as `order_address.country.advancedPostalCodePattern`, `order_address.country`.`default_postal_code_pattern` as `order_address.country.defaultPostalCodePattern`, `order_address.country`.`created_at` as `order_address.country.createdAt`, `order_address.country`.`updated_at` as `order_address.country.updatedAt`, `order_address.country.zipValidation`.`id` as `order_address.country.zipValidation.id`, `order_address.country.zipValidation`.`country_id` as `order_address.country.zipValidation.countryId`, `order_address.country.zipValidation`.`min_length` as `order_address.country.zipValidation.minLength`, `order_address.country.zipValidation`.`max_length` as `order_address.country.zipValidation.maxLength`, `order_address.country.zipValidation`.`letters_allowed` as `order_address.country.zipValidation.lettersAllowed`, `order_address.country.zipValidation`.`pattern` as `order_address.country.zipValidation.pattern`, `order_address.country.zipValidation`.`active` as `order_address.country.zipValidation.active`, `order_address.country.zipValidation`.`created_at` as `order_address.country.zipValidation.createdAt`, `order_address.country.zipValidation`.`updated_at` as `order_address.country.zipValidation.updatedAt`, `order_address.country.translation.name`, COALESCE(`order_address.country.translation.name`,`order_address.country.translation.name`) as `order_address.country.name`, `order_address.country.translation.addressFormat`, COALESCE(`order_address.country.translation.addressFormat`,`order_address.country.translation.addressFormat`) as `order_address.country.addressFormat`, `order_address.country.translation.customFields`, COALESCE(`order_address.country.translation.customFields`,`order_address.country.translation.customFields`) as `order_address.country.customFields`, `order_address.country.translation.createdAt`, `order_address.country.translation.updatedAt`, `order_address.country.translation.countryId`, `order_address.country.translation.languageId`, `order_address.countryState`.`id` as `order_address.countryState.id`, `order_address.countryState`.`country_id` as `order_address.countryState.countryId`, `order_address.countryState`.`short_code` as `order_address.countryState.shortCode`, `order_address.countryState`.`position` as `order_address.countryState.position`, `order_address.countryState`.`active` as `order_address.countryState.active`, `order_address.countryState`.`created_at` as `order_address.countryState.createdAt`, `order_address.countryState`.`updated_at` as `order_address.countryState.updatedAt`, `order_address.countryState.translation.name`, COALESCE(`order_address.countryState.translation.name`,`order_address.countryState.translation.name`) as `order_address.countryState.name`, `order_address.countryState.translation.customFields`, COALESCE(`order_address.countryState.translation.customFields`,`order_address.countryState.translation.customFields`) as `order_address.countryState.customFields`, `order_address.countryState.translation.createdAt`, `order_address.countryState.translation.updatedAt`, `order_address.countryState.translation.countryStateId`, `order_address.countryState.translation.languageId` FROM `order_address` LEFT JOIN `country` `order_address.country` ON `order_address`.`country_id` = `order_address.country`.`id` LEFT JOIN `country_state` `order_address.countryState` ON `order_address`.`country_state_id` = `order_address.countryState`.`id` LEFT JOIN (SELECT `order_address.country.translation`.country_id, `order_address.country.translation`.name as `order_address.country.translation.name`, `order_address.country.translation`.address_format as `order_address.country.translation.addressFormat`, `order_address.country.translation`.custom_fields as `order_address.country.translation.customFields`, `order_address.country.translation`.created_at as `order_address.country.translation.createdAt`, `order_address.country.translation`.updated_at as `order_address.country.translation.updatedAt`, `order_address.country.translation`.country_id as `order_address.country.translation.countryId`, `order_address.country.translation`.language_id as `order_address.country.translation.languageId` FROM `country_translation` `order_address.country.translation` WHERE `order_address.country.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order_address.country.country_translation` ON `order_address.country.country_translation`.`country_id` = `order_address.country`.`id` LEFT JOIN `coe_country_zip_validation` `order_address.country.zipValidation` ON `order_address.country`.`id` = `order_address.country.zipValidation`.`country_id` LEFT JOIN (SELECT `order_address.countryState.translation`.country_state_id, `order_address.countryState.translation`.name as `order_address.countryState.translation.name`, `order_address.countryState.translation`.custom_fields as `order_address.countryState.translation.customFields`, `order_address.countryState.translation`.created_at as `order_address.countryState.translation.createdAt`, `order_address.countryState.translation`.updated_at as `order_address.countryState.translation.updatedAt`, `order_address.countryState.translation`.country_state_id as `order_address.countryState.translation.countryStateId`, `order_address.countryState.translation`.language_id as `order_address.countryState.translation.languageId` FROM `country_state_translation` `order_address.countryState.translation` WHERE `order_address.countryState.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order_address.countryState.country_state_translation` ON `order_address.countryState.country_state_translation`.`country_state_id` = `order_address.countryState`.`id` WHERE (`order_address`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`order_address`.`id` IN (0x84900EB0ACB94ED8B204C00609546C0B)); 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 44)" 9 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::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)"]
0.25 ms (0.00%)		SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1 View formatted query View runnable query View query stack SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1 SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1; array:31 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1065)" 2 => "Doctrine\DBAL\Connection::fetchAllKeyValue (line 101)" 3 => "Shopware\Core\System\CustomField\CustomFieldService::getCustomFields (line 43)" 4 => "Shopware\Core\System\CustomField\CustomFieldService::getCustomField (line 107)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer::getFields (line 97)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer::decode (line 418)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator::customFields (line 241)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator::hydrateFields (line 167)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator::assign (line 544)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator::hydrateEntity (line 86)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator::hydrate (line 148)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 91)" 13 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 256)" 14 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 301)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)" 16 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 44)" 17 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::search (line 376)" 18 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 221)" 19 => "Shopware\Core\Framework\Context::scope (line 377)" 20 => "Shopware\Core\Framework\Api\Controller\ApiController::search (line 163)" 21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 29 => "Shopware\Core\HttpKernel::doHandle (line 79)" 30 => "Shopware\Core\HttpKernel::handle (line 85)"]
0.66 ms (0.00%)		# default-salutation-loading::read SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.displayName`, COALESCE(`salutation.translation.displayName`,`salutation.translation.displayName`) as `salutation.displayName`, `salutation.translation.letterName`, COALESCE(`salutation.translation.letterName`,`salutation.translation.letterName`) as `salutation.letterName`, `salutation.translation.customFields`, COALESCE(`salutation.translation.customFields`,`salutation.translation.customFields`) as `salutation.customFields`, `salutation.translation.createdAt`, `salutation.translation.updatedAt`, `salutation.translation.salutationId`, `salutation.translation.languageId` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.salutation_id, `salutation.translation`.display_name as `salutation.translation.displayName`, `salutation.translation`.letter_name as `salutation.translation.letterName`, `salutation.translation`.custom_fields as `salutation.translation.customFields`, `salutation.translation`.created_at as `salutation.translation.createdAt`, `salutation.translation`.updated_at as `salutation.translation.updatedAt`, `salutation.translation`.salutation_id as `salutation.translation.salutationId`, `salutation.translation`.language_id as `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.language_id = :languageId) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id` WHERE `salutation`.`id` IN (:ids) View formatted query View runnable query View query stack # default-salutation-loading::read SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.displayName`, COALESCE( `salutation.translation.displayName`, `salutation.translation.displayName` ) as `salutation.displayName`, `salutation.translation.letterName`, COALESCE( `salutation.translation.letterName`, `salutation.translation.letterName` ) as `salutation.letterName`, `salutation.translation.customFields`, COALESCE( `salutation.translation.customFields`, `salutation.translation.customFields` ) as `salutation.customFields`, `salutation.translation.createdAt`, `salutation.translation.updatedAt`, `salutation.translation.salutationId`, `salutation.translation.languageId` FROM `salutation` LEFT JOIN ( SELECT `salutation.translation`.salutation_id, `salutation.translation`.display_name as `salutation.translation.displayName`, `salutation.translation`.letter_name as `salutation.translation.letterName`, `salutation.translation`.custom_fields as `salutation.translation.customFields`, `salutation.translation`.created_at as `salutation.translation.createdAt`, `salutation.translation`.updated_at as `salutation.translation.updatedAt`, `salutation.translation`.salutation_id as `salutation.translation.salutationId`, `salutation.translation`.language_id as `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.language_id = : languageId ) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id` WHERE `salutation`.`id` IN (: ids) # default-salutation-loading::read SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.displayName`, COALESCE(`salutation.translation.displayName`,`salutation.translation.displayName`) as `salutation.displayName`, `salutation.translation.letterName`, COALESCE(`salutation.translation.letterName`,`salutation.translation.letterName`) as `salutation.letterName`, `salutation.translation.customFields`, COALESCE(`salutation.translation.customFields`,`salutation.translation.customFields`) as `salutation.customFields`, `salutation.translation.createdAt`, `salutation.translation.updatedAt`, `salutation.translation.salutationId`, `salutation.translation.languageId` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.salutation_id, `salutation.translation`.display_name as `salutation.translation.displayName`, `salutation.translation`.letter_name as `salutation.translation.letterName`, `salutation.translation`.custom_fields as `salutation.translation.customFields`, `salutation.translation`.created_at as `salutation.translation.createdAt`, `salutation.translation`.updated_at as `salutation.translation.updatedAt`, `salutation.translation`.salutation_id as `salutation.translation.salutationId`, `salutation.translation`.language_id as `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id` WHERE `salutation`.`id` IN (0xED643807C9F84CC8B50132EA3CCB1C3B); array:40 [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 109)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 59)" 9 => "Shopware\Core\Profiling\Profiler::trace (line 110)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 44)" 11 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::search (line 77)" 12 => "Shopware\Core\Checkout\Customer\Subscriber\CustomerDefaultSalutationSubscriber::getDefaultSalutation (line 60)" 13 => "Shopware\Core\Checkout\Customer\Subscriber\CustomerDefaultSalutationSubscriber::loaded (line 270)" 14 => "Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 230)" 15 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 16 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 54)" 17 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 99)" 18 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)" 19 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 38)" 20 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 34)" 21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 268)" 23 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 301)" 24 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)" 25 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 44)" 26 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::search (line 376)" 27 => "Shopware\Core\Framework\Api\Controller\ApiController::Shopware\Core\Framework\Api\Controller\{closure} (line 221)" 28 => "Shopware\Core\Framework\Context::scope (line 377)" 29 => "Shopware\Core\Framework\Api\Controller\ApiController::search (line 163)" 30 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 31 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 32 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)" 33 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 34 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 35 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 38 => "Shopware\Core\HttpKernel::doHandle (line 79)" 39 => "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.

Entities Mapping