Query Metrics
59
Database Queries
31
Different statements
24.60 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.05 ms (20.51%) |
9 |
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`checkout_gateway_url` AS `app.checkoutGatewayUrl`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01öä9N\x1DqÅ×ãyÓ¢jÇÊ" ] |
||||||||||||||||||||||
|
1.93 ms (7.86%) |
1 |
SELECT `acris_cookie`.`id` AS `acris_cookie.id`, `acris_cookie`.`cookie_group_id` AS `acris_cookie.cookieGroupId`, `acris_cookie.cookieGroup`.`id` AS `acris_cookie.cookieGroup.id`, `acris_cookie.cookieGroup`.`is_default` AS `acris_cookie.cookieGroup.isDefault`, `acris_cookie.cookieGroup`.`identification` AS `acris_cookie.cookieGroup.identification`, `acris_cookie.cookieGroup`.`created_at` AS `acris_cookie.cookieGroup.createdAt`, `acris_cookie.cookieGroup`.`updated_at` AS `acris_cookie.cookieGroup.updatedAt`, `acris_cookie.cookieGroup.translation.title`, COALESCE(`acris_cookie.cookieGroup.translation.title`,`acris_cookie.cookieGroup.translation.title`) AS `acris_cookie.cookieGroup.title`, `acris_cookie.cookieGroup.translation.description`, COALESCE(`acris_cookie.cookieGroup.translation.description`,`acris_cookie.cookieGroup.translation.description`) AS `acris_cookie.cookieGroup.description`, `acris_cookie.cookieGroup.translation.createdAt`, `acris_cookie.cookieGroup.translation.updatedAt`, `acris_cookie.cookieGroup.translation.acrisCookieGroupId`, `acris_cookie.cookieGroup.translation.languageId`, `acris_cookie`.`cookie_id` AS `acris_cookie.cookieId`, `acris_cookie`.`google_cookie_consent_mode` AS `acris_cookie.googleCookieConsentMode`, `acris_cookie`.`default_value` AS `acris_cookie.defaultValue`, `acris_cookie`.`script_position` AS `acris_cookie.scriptPosition`, `acris_cookie`.`provider` AS `acris_cookie.provider`, `acris_cookie`.`active` AS `acris_cookie.active`, `acris_cookie`.`unknown` AS `acris_cookie.unknown`, `acris_cookie`.`is_default` AS `acris_cookie.isDefault`, `acris_cookie`.`created_at` AS `acris_cookie.createdAt`, `acris_cookie`.`updated_at` AS `acris_cookie.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_cookie.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||') FROM `acris_cookie_sales_channel` `acris_cookie.salesChannels.mapping` WHERE `acris_cookie.salesChannels.mapping`.`cookie_id` = `acris_cookie`.`id` ) AS `acris_cookie.salesChannels.id_mapping`, `acris_cookie.translation.title`, COALESCE(`acris_cookie.translation.title`,`acris_cookie.translation.title`) AS `acris_cookie.title`, `acris_cookie.translation.description`, COALESCE(`acris_cookie.translation.description`,`acris_cookie.translation.description`) AS `acris_cookie.description`, `acris_cookie.translation.script`, COALESCE(`acris_cookie.translation.script`,`acris_cookie.translation.script`) AS `acris_cookie.script`, `acris_cookie.translation.createdAt`, `acris_cookie.translation.updatedAt`, `acris_cookie.translation.acrisCookieId`, `acris_cookie.translation.languageId` FROM `acris_cookie` LEFT JOIN `acris_cookie_group` `acris_cookie.cookieGroup` ON `acris_cookie`.`cookie_group_id` = `acris_cookie.cookieGroup`.`id` LEFT JOIN (SELECT `acris_cookie.translation`.acris_cookie_id, `acris_cookie.translation`.title AS `acris_cookie.translation.title`, `acris_cookie.translation`.description AS `acris_cookie.translation.description`, `acris_cookie.translation`.script AS `acris_cookie.translation.script`, `acris_cookie.translation`.created_at AS `acris_cookie.translation.createdAt`, `acris_cookie.translation`.updated_at AS `acris_cookie.translation.updatedAt`, `acris_cookie.translation`.acris_cookie_id AS `acris_cookie.translation.acrisCookieId`, `acris_cookie.translation`.language_id AS `acris_cookie.translation.languageId` FROM `acris_cookie_translation` `acris_cookie.translation` WHERE `acris_cookie.translation`.language_id = ?) `acris_cookie.acris_cookie_translation` ON `acris_cookie.acris_cookie_translation`.`acris_cookie_id` = `acris_cookie`.`id` LEFT JOIN (SELECT `acris_cookie.cookieGroup.translation`.acris_cookie_group_id, `acris_cookie.cookieGroup.translation`.title AS `acris_cookie.cookieGroup.translation.title`, `acris_cookie.cookieGroup.translation`.description AS `acris_cookie.cookieGroup.translation.description`, `acris_cookie.cookieGroup.translation`.created_at AS `acris_cookie.cookieGroup.translation.createdAt`, `acris_cookie.cookieGroup.translation`.updated_at AS `acris_cookie.cookieGroup.translation.updatedAt`, `acris_cookie.cookieGroup.translation`.acris_cookie_group_id AS `acris_cookie.cookieGroup.translation.acrisCookieGroupId`, `acris_cookie.cookieGroup.translation`.language_id AS `acris_cookie.cookieGroup.translation.languageId` FROM `acris_cookie_group_translation` `acris_cookie.cookieGroup.translation` WHERE `acris_cookie.cookieGroup.translation`.language_id = ?) `acris_cookie.cookieGroup.acris_cookie_group_translation` ON `acris_cookie.cookieGroup.acris_cookie_group_translation`.`acris_cookie_group_id` = `acris_cookie.cookieGroup`.`id`
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||
|
1.74 ms (7.06%) |
2 |
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`checkout_gateway_url` AS `app.checkoutGatewayUrl`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ? AND NOT (`app`.`cookies` IS NULL))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true ] |
||||||||||||||||||||||
|
1.54 ms (6.27%) |
5 |
SELECT `acris_cookie_group`.`id` AS `acris_cookie_group.id`, `acris_cookie_group`.`is_default` AS `acris_cookie_group.isDefault`, `acris_cookie_group`.`identification` AS `acris_cookie_group.identification`, `acris_cookie_group`.`created_at` AS `acris_cookie_group.createdAt`, `acris_cookie_group`.`updated_at` AS `acris_cookie_group.updatedAt`, `acris_cookie_group.translation.title`, COALESCE(`acris_cookie_group.translation.title`,`acris_cookie_group.translation.title`) AS `acris_cookie_group.title`, `acris_cookie_group.translation.description`, COALESCE(`acris_cookie_group.translation.description`,`acris_cookie_group.translation.description`) AS `acris_cookie_group.description`, `acris_cookie_group.translation.createdAt`, `acris_cookie_group.translation.updatedAt`, `acris_cookie_group.translation.acrisCookieGroupId`, `acris_cookie_group.translation.languageId` FROM `acris_cookie_group` LEFT JOIN (SELECT `acris_cookie_group.translation`.acris_cookie_group_id, `acris_cookie_group.translation`.title AS `acris_cookie_group.translation.title`, `acris_cookie_group.translation`.description AS `acris_cookie_group.translation.description`, `acris_cookie_group.translation`.created_at AS `acris_cookie_group.translation.createdAt`, `acris_cookie_group.translation`.updated_at AS `acris_cookie_group.translation.updatedAt`, `acris_cookie_group.translation`.acris_cookie_group_id AS `acris_cookie_group.translation.acrisCookieGroupId`, `acris_cookie_group.translation`.language_id AS `acris_cookie_group.translation.languageId` FROM `acris_cookie_group_translation` `acris_cookie_group.translation` WHERE `acris_cookie_group.translation`.language_id = ?) `acris_cookie_group.acris_cookie_group_translation` ON `acris_cookie_group.acris_cookie_group_translation`.`acris_cookie_group_id` = `acris_cookie_group`.`id` WHERE (`acris_cookie_group`.`identification` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" "cookie.groupStatistical" ] |
||||||||||||||||||||||
|
1.51 ms (6.14%) |
9 |
SELECT `script`.`id` AS `script.id`, `script`.`script` AS `script.script`, `script`.`hook` AS `script.hook`, `script`.`name` AS `script.name`, `script`.`active` AS `script.active`, `script`.`app_id` AS `script.appId`, `script`.`created_at` AS `script.createdAt`, `script`.`updated_at` AS `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters:
[
b"\x01öä9N\x1DqÅ×ãyÓ¢jÇÊ"
]
|
||||||||||||||||||||||
|
1.27 ms (5.17%) |
3 |
SELECT LOWER(HEX(`script`.`app_id`)) AS `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||
|
1.16 ms (4.70%) |
1 |
SELECT `cms_slot`.`id` AS `cms_slot.id`, `cms_slot`.`version_id` AS `cms_slot.versionId`, `cms_slot`.`type` AS `cms_slot.type`, `cms_slot`.`slot` AS `cms_slot.slot`, `cms_slot`.`locked` AS `cms_slot.locked`, `cms_slot`.`cms_block_id` AS `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` AS `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` AS `cms_slot.createdAt`, `cms_slot`.`updated_at` AS `cms_slot.updatedAt`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) AS `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) AS `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config AS `cms_slot.translation.config`, `cms_slot.translation`.custom_fields AS `cms_slot.translation.customFields`, `cms_slot.translation`.created_at AS `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at AS `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id AS `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id AS `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id AS `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"xí4%fMSš\x05\x07åAJ\x01É" ] |
||||||||||||||||||||||
|
0.96 ms (3.90%) |
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`.`created_at` AS `sales_channel.createdAt`, `sales_channel`.`updated_at` AS `sales_channel.updatedAt`, `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` WHERE `sales_channel`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b".\x05ÅHù€Cú ñM\t\x1C½ß\e" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ b".\x05ÅHù€Cú ñM\t\x1C½ß\e" ] |
||||||||||||||||||||||
|
0.84 ms (3.41%) |
1 |
SELECT `cms_section`.`id` AS `cms_section.id`, `cms_section`.`position` AS `cms_section.position`, `cms_section`.`type` AS `cms_section.type`, `cms_section`.`locked` AS `cms_section.locked`, `cms_section`.`name` AS `cms_section.name`, `cms_section`.`sizing_mode` AS `cms_section.sizingMode`, `cms_section`.`mobile_behavior` AS `cms_section.mobileBehavior`, `cms_section`.`background_color` AS `cms_section.backgroundColor`, `cms_section`.`background_media_id` AS `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` AS `cms_section.backgroundMediaMode`, `cms_section`.`css_class` AS `cms_section.cssClass`, `cms_section`.`cms_page_id` AS `cms_section.pageId`, `cms_section`.`visibility` AS `cms_section.visibility`, `cms_section`.`custom_fields` AS `cms_section.customFields`, `cms_section`.`version_id` AS `cms_section.versionId`, `cms_section`.`cms_page_version_id` AS `cms_section.cmsPageVersionId`, `cms_section`.`created_at` AS `cms_section.createdAt`, `cms_section`.`updated_at` AS `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` AS `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` AS `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` AS `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` AS `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` AS `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` AS `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` AS `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` AS `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` AS `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` AS `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` AS `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` AS `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` AS `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` AS `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` AS `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` AS `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) AS `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) AS `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) AS `cms_section.backgroundMedia.customFields`, `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation.languageId` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title AS `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt AS `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields AS `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at AS `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at AS `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id AS `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id AS `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"~ˆ$»×\x18O&¼0ªÄÆ©°"" ] |
||||||||||||||||||||||
|
0.79 ms (3.21%) |
1 |
SELECT `cms_page`.`id` AS `cms_page.id`, `cms_page`.`version_id` AS `cms_page.versionId`, `cms_page`.`type` AS `cms_page.type`, `cms_page`.`entity` AS `cms_page.entity`, `cms_page`.`css_class` AS `cms_page.cssClass`, `cms_page`.`config` AS `cms_page.config`, `cms_page`.`preview_media_id` AS `cms_page.previewMediaId`, `cms_page`.`locked` AS `cms_page.locked`, `cms_page`.`created_at` AS `cms_page.createdAt`, `cms_page`.`updated_at` AS `cms_page.updatedAt`, `cms_page.translation.name`, COALESCE(`cms_page.translation.name`,`cms_page.translation.name`) AS `cms_page.name`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.customFields`,`cms_page.translation.customFields`) AS `cms_page.customFields`, `cms_page.translation.createdAt`, `cms_page.translation.updatedAt`, `cms_page.translation.cmsPageId`, `cms_page.translation.languageId`, `cms_page.translation.cmsPageVersionId` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.cms_page_version_id, `cms_page.translation`.name AS `cms_page.translation.name`, `cms_page.translation`.custom_fields AS `cms_page.translation.customFields`, `cms_page.translation`.created_at AS `cms_page.translation.createdAt`, `cms_page.translation`.updated_at AS `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id AS `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id AS `cms_page.translation.languageId`, `cms_page.translation`.cms_page_version_id AS `cms_page.translation.cmsPageVersionId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.cms_page_version_id = `cms_page`.version_id WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"~ˆ$»×\x18O&¼0ªÄÆ©°"" ] |
||||||||||||||||||||||
|
0.66 ms (2.68%) |
1 |
SELECT `rule`.`id` AS `rule.id`, `rule`.`name` AS `rule.name`, `rule`.`priority` AS `rule.priority`, `rule`.`description` AS `rule.description`, `rule`.`payload` AS `rule.payload`, `rule`.`invalid` AS `rule.invalid`, `rule`.`areas` AS `rule.areas`, `rule`.`custom_fields` AS `rule.customFields`, `rule`.`module_types` AS `rule.moduleTypes`, `rule`.`created_at` AS `rule.createdAt`, `rule`.`updated_at` AS `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\t‘;*ÖQN£²µŠ‚¯¤\x01æ" b"[Ü~DJ/F8–Þü\x03\w2" b"ª\x1C\eŽÀ\x04OR¤óm¢8‹BÌ" b"ù6\t\x01OèLt—#kèel\x00å" b"‚^\x18;snHµŒ$¤‰YãG" b"¦ˆù\x15Ã…EP»‚DBÈgZ×" b"\x01’2åñ`r=°\x0E¿?;8ÚF" b""" \ti:\x11DxH ‡\n B—Ùiö° """ b"4Þ7êtTAB▓─ì2XJ·N" b"e\x10\x1F¾}íOÞª‡U\x1CÚCËÇ" b"Á░v‗0*AÅ╗r║a^\x02û:" b"úŽÿí¥\x1EK\x02’LwJÌá\x18„" b"\x01˜\x08$½÷t÷°/2EöÆœ˜" ] |
||||||||||||||||||||||
|
0.64 ms (2.61%) |
3 |
SELECT LOWER(HEX(`script`.`app_id`)) AS `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||
|
0.59 ms (2.40%) |
3 |
# app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
true
]
|
||||||||||||||||||||||
|
0.58 ms (2.34%) |
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.56 ms (2.28%) |
1 |
SELECT `cms_block`.`id` AS `cms_block.id`, `cms_block`.`position` AS `cms_block.position`, `cms_block`.`type` AS `cms_block.type`, `cms_block`.`locked` AS `cms_block.locked`, `cms_block`.`name` AS `cms_block.name`, `cms_block`.`section_position` AS `cms_block.sectionPosition`, `cms_block`.`margin_top` AS `cms_block.marginTop`, `cms_block`.`margin_bottom` AS `cms_block.marginBottom`, `cms_block`.`margin_left` AS `cms_block.marginLeft`, `cms_block`.`margin_right` AS `cms_block.marginRight`, `cms_block`.`background_color` AS `cms_block.backgroundColor`, `cms_block`.`background_media_id` AS `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` AS `cms_block.backgroundMediaMode`, `cms_block`.`css_class` AS `cms_block.cssClass`, `cms_block`.`visibility` AS `cms_block.visibility`, `cms_block`.`cms_section_id` AS `cms_block.sectionId`, `cms_block`.`custom_fields` AS `cms_block.customFields`, `cms_block`.`version_id` AS `cms_block.versionId`, `cms_block`.`cms_section_version_id` AS `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` AS `cms_block.createdAt`, `cms_block`.`updated_at` AS `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` AS `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` AS `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` AS `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` AS `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` AS `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` AS `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` AS `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` AS `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` AS `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` AS `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` AS `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` AS `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` AS `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` AS `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` AS `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` AS `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) AS `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) AS `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) AS `cms_block.backgroundMedia.customFields`, `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation.languageId` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title AS `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt AS `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields AS `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at AS `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at AS `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id AS `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id AS `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x08û\x06Pp³D]œu¯¨^1ǃ" ] |
||||||||||||||||||||||
|
0.48 ms (1.95%) |
2 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[
b"""
ÎmŒ\e‰LE9Ÿtå\x05\n
‰\x08ò
"""
"RxvdY10a4w5LqEHHh6ooXWGirlyFo1pF"
]
|
||||||||||||||||||||||
|
0.40 ms (1.63%) |
1 |
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority` FROM `app` INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id` WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters:
[] |
||||||||||||||||||||||
|
0.39 ms (1.60%) |
1 |
SELECT `redirect`.`id` AS `redirect.id`, `redirect`.`oldUrl` AS `redirect.oldUrl`, `redirect`.`newUrl` AS `redirect.newUrl`, `redirect`.`active` AS `redirect.active`, `redirect`.`temporaryRedirect` AS `redirect.temporaryRedirect`, `redirect`.`externalRedirect` AS `redirect.externalRedirect`, `redirect`.`gone` AS `redirect.gone`, `redirect`.`created_at` AS `redirect.createdAt`, `redirect`.`updated_at` AS `redirect.updatedAt` FROM `redirect` WHERE (`redirect`.`oldUrl` = ? AND `redirect`.`active` = ?)
Parameters:
[ "/widgets/cms/7e8824bbd7184f26bc30aac4c6a9b022" true ] |
||||||||||||||||||||||
|
0.38 ms (1.53%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||
|
0.38 ms (1.53%) |
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) AND custom_entity.deleted_at IS NULL;
Parameters:
[]
|
||||||||||||||||||||||
|
0.35 ms (1.44%) |
1 |
SELECT configuration_value FROM system_config WHERE (configuration_key = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) ORDER BY sales_channel_id IS NULL ASC LIMIT 1
Parameters:
[ "NetiNextStoreLocator.config.seoUrl" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ ] |
||||||||||||||||||||||
|
0.35 ms (1.41%) |
1 |
# seo-url::resolve-fallback SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ "/widgets/cms/7e8824bbd7184f26bc30aac4c6a9b022" ] |
||||||||||||||||||||||
|
0.31 ms (1.27%) |
1 |
SELECT `webi_configuration`.`id` AS `webi_configuration.id`, `webi_configuration`.`configuration_key` AS `webi_configuration.configurationKey`, `webi_configuration`.`configuration_value` AS `webi_configuration.configurationValue`, `webi_configuration`.`created_at` AS `webi_configuration.createdAt`, `webi_configuration`.`updated_at` AS `webi_configuration.updatedAt` FROM `webi_configuration`
Parameters:
[] |
||||||||||||||||||||||
|
0.31 ms (1.24%) |
1 |
# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b""" ÎmŒ\e‰LE9Ÿtå\x05\n ‰\x08ò """ "widgets/cms/7e8824bbd7184f26bc30aac4c6a9b022" "widgets/cms/7e8824bbd7184f26bc30aac4c6a9b022/" ] |
||||||||||||||||||||||
|
0.30 ms (1.22%) |
1 |
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ? AND `payment_method`.`active` = ?)
Parameters:
[ "Kiener\MolliePayments\Handler\Method\ApplePayPayment" true ] |
||||||||||||||||||||||
|
0.24 ms (1.00%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||
|
0.21 ms (0.86%) |
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.18 ms (0.72%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||
|
0.18 ms (0.72%) |
1 |
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters:
[
b"""
ÎmŒ\e‰LE9Ÿtå\x05\n
‰\x08ò
"""
b"\x12*œD†\x1EIѼ|\x7F\x02 ·ÿ"
]
|
||||||||||||||||||||||
|
0.17 ms (0.68%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||
|
0.16 ms (0.67%) |
1 |
SELECT `acris_cookie_group`.`id` FROM `acris_cookie_group` WHERE (`acris_cookie_group`.`identification` = ?) LIMIT 1
Parameters:
[
"functional"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.