Query Metrics
13
Database Queries
13
Different statements
10.82 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.91 ms (17.65%) |
1 |
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.type`.`id` as `sales_channel.type.id`, `sales_channel.type`.`cover_url` as `sales_channel.type.coverUrl`, `sales_channel.type`.`icon_name` as `sales_channel.type.iconName`, `sales_channel.type`.`screenshot_urls` as `sales_channel.type.screenshotUrls`, `sales_channel.type`.`created_at` as `sales_channel.type.createdAt`, `sales_channel.type`.`updated_at` as `sales_channel.type.updatedAt`, `sales_channel.type.translation.name`, COALESCE(`sales_channel.type.translation.name`,`sales_channel.type.translation.name`) as `sales_channel.type.name`, `sales_channel.type.translation.manufacturer`, COALESCE(`sales_channel.type.translation.manufacturer`,`sales_channel.type.translation.manufacturer`) as `sales_channel.type.manufacturer`, `sales_channel.type.translation.description`, COALESCE(`sales_channel.type.translation.description`,`sales_channel.type.translation.description`) as `sales_channel.type.description`, `sales_channel.type.translation.descriptionLong`, COALESCE(`sales_channel.type.translation.descriptionLong`,`sales_channel.type.translation.descriptionLong`) as `sales_channel.type.descriptionLong`, `sales_channel.type.translation.customFields`, COALESCE(`sales_channel.type.translation.customFields`,`sales_channel.type.translation.customFields`) as `sales_channel.type.customFields`, `sales_channel.type.translation.createdAt`, `sales_channel.type.translation.updatedAt`, `sales_channel.type.translation.salesChannelTypeId`, `sales_channel.type.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `sales_channel_type` `sales_channel.type` ON `sales_channel`.`type_id` = `sales_channel.type`.`id` LEFT JOIN (SELECT `sales_channel.type.translation`.sales_channel_type_id, `sales_channel.type.translation`.name as `sales_channel.type.translation.name`, `sales_channel.type.translation`.manufacturer as `sales_channel.type.translation.manufacturer`, `sales_channel.type.translation`.description as `sales_channel.type.translation.description`, `sales_channel.type.translation`.description_long as `sales_channel.type.translation.descriptionLong`, `sales_channel.type.translation`.custom_fields as `sales_channel.type.translation.customFields`, `sales_channel.type.translation`.created_at as `sales_channel.type.translation.createdAt`, `sales_channel.type.translation`.updated_at as `sales_channel.type.translation.updatedAt`, `sales_channel.type.translation`.sales_channel_type_id as `sales_channel.type.translation.salesChannelTypeId`, `sales_channel.type.translation`.language_id as `sales_channel.type.translation.languageId` FROM `sales_channel_type_translation` `sales_channel.type.translation` WHERE `sales_channel.type.translation`.language_id = ?) `sales_channel.type.sales_channel_type_translation` ON `sales_channel.type.sales_channel_type_translation`.`sales_channel_type_id` = `sales_channel.type`.`id` WHERE `sales_channel`.`id` IN (?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"˜C-ï9üF$³2\x13¥kŒ”M" b"\x1DQ4\\x01¯B6«¡·\x1Fú•E?" ] |
||||||||||||||||||||||
|
1.56 ms (14.47%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||||
|
1.35 ms (12.47%) |
1 |
SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` ORDER BY COALESCE(`sales_channel.translation.name`) ASC LIMIT 7
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||
|
1.09 ms (10.12%) |
1 |
# cache-id-loader SELECT `value` FROM app_config WHERE `key` = ?
Parameters:
[
"cache-id"
]
|
||||||||||||||||||||||
|
0.80 ms (7.42%) |
1 |
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?, ?))
Parameters:
[ b"\x1DQ4\\x01¯B6«¡·\x1Fú•E?" b"˜C-ï9üF$³2\x13¥kŒ”M" ] |
||||||||||||||||||||||
|
0.67 ms (6.21%) |
1 |
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1
Parameters:
[]
|
||||||||||||||||||||||
|
0.64 ms (5.93%) |
1 |
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters:
[
b"£–Óã‘ØF_«¥ˆêbî†r"
]
|
||||||||||||||||||||||
|
0.60 ms (5.54%) |
1 |
# 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`;
Parameters:
[]
|
||||||||||||||||||||||
|
0.58 ms (5.39%) |
1 |
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = ?
Parameters:
[
b"£–Óã‘ØF_«¥ˆêbî†r"
]
|
||||||||||||||||||||||
|
0.56 ms (5.22%) |
1 |
SELECT COUNT(*) FROM (SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id`) total
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||
|
0.42 ms (3.89%) |
1 |
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
|
||||||||||||||||||||||
|
0.34 ms (3.18%) |
1 |
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',''))
Parameters:
[]
|
||||||||||||||||||||||
|
0.27 ms (2.50%) |
1 |
SELECT admin FROM `user` WHERE id = ?
Parameters:
[
b"£–Óã‘ØF_«¥ˆêbî†r"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.