GET https://aprotech-dev.noneddon.de/maintenance/singlepage/267b320b25a34b52bb63bef9872e68ca

Query Metrics

41 Database Queries
33 Different statements
40.29 ms Query time

Queries

Group similar statements

# Time Info
1 0.52 ms
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters:
[]
2 0.22 ms
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters:
[]
3 0.23 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
4 0.26 ms
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:
[]
5 0.43 ms
# 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"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  "maintenance/singlepage/267b320b25a34b52bb63bef9872e68ca"
  "maintenance/singlepage/267b320b25a34b52bb63bef9872e68ca/"
]
6 0.27 ms
# 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"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  "/maintenance/singlepage/267b320b25a34b52bb63bef9872e68ca"
]
7 0.31 ms
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
8 0.24 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  "p0zcgA6QrWHDZlWmIx36rfi2rW4anRmN"
]
9 0.23 ms
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
  "p0zcgA6QrWHDZlWmIx36rfi2rW4anRmN"
]
10 0.21 ms
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"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    œº«;Ù`G\n
    ´ø\x17áÔÀ³e
    """
]
11 1.01 ms
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`, `acris_cookie.cookieGroup.translation.title` as `acris_cookie.cookieGroup.title`, `acris_cookie.cookieGroup.translation.description`, `acris_cookie.cookieGroup.translation.description` as `acris_cookie.cookieGroup.description`, `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`.`from_extension` as `acris_cookie.fromExtension`, `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`, `acris_cookie.translation.title` as `acris_cookie.title`, `acris_cookie.translation.description`, `acris_cookie.translation.description` as `acris_cookie.description`, `acris_cookie.translation.script`, `acris_cookie.translation.script` as `acris_cookie.script` 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` 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` 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"
]
12 0.45 ms
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`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `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` 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"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
]
13 0.23 ms
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[]
14 0.21 ms
SELECT `acris_cookie_group`.`id` FROM `acris_cookie_group` ORDER BY `acris_cookie_group`.`is_default` DESC
Parameters:
[]
15 0.36 ms
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`, `acris_cookie_group.translation.title` as `acris_cookie_group.title`, `acris_cookie_group.translation.description`, `acris_cookie_group.translation.description` as `acris_cookie_group.description` 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` 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`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ÿØ\x1CëÏpÜø=│)`¶'T"
  b"\x01ÿØ\x1CëÚq~Ø\x08\x10³8ëä┬"
  b"""
    \x01ÿØ\x1CëÝpWû\x7F\f"i\n
    º
    """
  b"\x01ÿØ\x1Cë­pzÉØ\x10:;Þ\x03W"
  b"\x01ÿØ\x1Cë¾s½ñ5¸Í<m4î"
  b"\x01ÿØ\x1Cë÷r>ÑÂÀ=cÒ&}"
  b"\x01ÿØ\x1D\f[sb░a¤▀QÊå "
  b"\x01ÿØ\x1D\rÀp\Æ®®\x14 ┼´\x00"
  b"\x01ÿØ\x1D\x0Eèr«Â¤ÙаÙZU"
  b"\x01ÿØ öKs@üçê/Tûp¶"
  b"\x01ÿØ ò\x1Aq&¢Zoc\x1D²8x"
  b"\x01ÿØ òÍq─ú\fkÔ8f\ea"
]
16 0.69 ms
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`, `acris_cookie.cookieGroup.translation.title` as `acris_cookie.cookieGroup.title`, `acris_cookie.cookieGroup.translation.description`, `acris_cookie.cookieGroup.translation.description` as `acris_cookie.cookieGroup.description`, `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`.`from_extension` as `acris_cookie.fromExtension`, `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`, `acris_cookie.translation.title` as `acris_cookie.title`, `acris_cookie.translation.description`, `acris_cookie.translation.description` as `acris_cookie.description`, `acris_cookie.translation.script`, `acris_cookie.translation.script` as `acris_cookie.script` 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` 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` 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` WHERE (`acris_cookie`.`cookie_group_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ÿØ\x1CëÏpÜø=│)`¶'T"
  b"\x01ÿØ\x1CëÚq~Ø\x08\x10³8ëä┬"
  b"""
    \x01ÿØ\x1CëÝpWû\x7F\f"i\n
    º
    """
  b"\x01ÿØ\x1Cë­pzÉØ\x10:;Þ\x03W"
  b"\x01ÿØ\x1Cë¾s½ñ5¸Í<m4î"
  b"\x01ÿØ\x1Cë÷r>ÑÂÀ=cÒ&}"
  b"\x01ÿØ\x1D\f[sb░a¤▀QÊå "
  b"\x01ÿØ\x1D\rÀp\Æ®®\x14 ┼´\x00"
  b"\x01ÿØ\x1D\x0Eèr«Â¤ÙаÙZU"
  b"\x01ÿØ öKs@üçê/Tûp¶"
  b"\x01ÿØ ò\x1Aq&¢Zoc\x1D²8x"
  b"\x01ÿØ òÍq─ú\fkÔ8f\ea"
]
17 0.41 ms
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`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `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` 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"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
]
18 9.04 ms
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`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` 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` 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"&{2\v%£KR»c¾ù‡.hÊ"
]
19 11.67 ms
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`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `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`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` 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`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` 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"&{2\v%£KR»c¾ù‡.hÊ"
]
20 1.96 ms
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`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `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`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` 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`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` 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"\\x07+i¡|H\x0E‡´÷\x10{ìœö"
]
21 3.35 ms
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`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` 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` 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"íù`"¯‚CŠ£–›£\x19’Pq"
]
22 0.39 ms
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:
[]
23 0.56 ms
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`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `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`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` 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` 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` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "AcrisTagManagerAppCS"
]
24 0.39 ms
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`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `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`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` 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` 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` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "mailcShopware6MailchimpIntegration"
]
25 0.50 ms
SELECT path FROM category WHERE id = ?
Parameters:
[
  b"\x06ýI­B\x14§Ç\x06‘¦I\r\x03"
]
26 0.16 ms
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
27 0.18 ms
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
  "de-DE"
]
28 1.17 ms
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`, `acris_cookie.cookieGroup.translation.title` as `acris_cookie.cookieGroup.title`, `acris_cookie.cookieGroup.translation.description`, `acris_cookie.cookieGroup.translation.description` as `acris_cookie.cookieGroup.description`, `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`.`from_extension` as `acris_cookie.fromExtension`, `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`, `acris_cookie.translation.title` as `acris_cookie.title`, `acris_cookie.translation.description`, `acris_cookie.translation.description` as `acris_cookie.description`, `acris_cookie.translation.script`, `acris_cookie.translation.script` as `acris_cookie.script` 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` 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` 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"
]
29 0.46 ms
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`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `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` 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"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
]
30 0.79 ms
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`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `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`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` 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` 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` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`active` = ? AND NOT (`app`.`cookies` IS NULL))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
31 0.16 ms
SELECT `acris_cookie_group`.`id` FROM `acris_cookie_group` WHERE (`acris_cookie_group`.`identification` = ?) LIMIT 1
Parameters:
[
  "functional"
]
32 0.28 ms
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`, `acris_cookie_group.translation.title` as `acris_cookie_group.title`, `acris_cookie_group.translation.description`, `acris_cookie_group.translation.description` as `acris_cookie_group.description` 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` 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"
]
33 0.25 ms
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`, `acris_cookie_group.translation.title` as `acris_cookie_group.title`, `acris_cookie_group.translation.description`, `acris_cookie_group.translation.description` as `acris_cookie_group.description` 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` 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.groupMarketing"
]
34 0.23 ms
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`, `acris_cookie_group.translation.title` as `acris_cookie_group.title`, `acris_cookie_group.translation.description`, `acris_cookie_group.translation.description` as `acris_cookie_group.description` 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` 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.groupComfortFeatures"
]
35 0.26 ms
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`, `acris_cookie_group.translation.title` as `acris_cookie_group.title`, `acris_cookie_group.translation.description`, `acris_cookie_group.translation.description` as `acris_cookie_group.description` 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` 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"
  "acrisTagManagerApp.acrisTagManagerCookieGroupName"
]
36 0.26 ms
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`, `acris_cookie_group.translation.title` as `acris_cookie_group.title`, `acris_cookie_group.translation.description`, `acris_cookie_group.translation.description` as `acris_cookie_group.description` 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` 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"
  "acrisTagManagerApp.acrisTagManagerGoogleAnalyticsCookieGroupName"
]
37 0.24 ms
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`, `acris_cookie_group.translation.title` as `acris_cookie_group.title`, `acris_cookie_group.translation.description`, `acris_cookie_group.translation.description` as `acris_cookie_group.description` 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` 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"
  "acrisTagManagerApp.acrisTagManagerGoogleAdsCookieGroupName"
]
38 0.25 ms
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"\x1EIÐOB݈~\x01÷â!\x04`"
  b"\x10\x16\x1Cy”EI™¼\x1FÉéŽS\ì"
  b"-\rìëm\x15C¸Ö╚M^ïÚ@g"
  b"ÅÑü\x1EYùDʪÝöªcW╬£"
  b"Ë$°ÂOC@ר+òû┐0î\x1D"
  b"ÙÝ®|¢!Aæ£\x1E(„\fºš™"
  b"]Ñ1»ºVEk­‚ÍDÁ´-\x04"
]
39 0.49 ms
SELECT `acris_cookie`.`id` FROM `acris_cookie` LEFT JOIN `acris_cookie_sales_channel` `acris_cookie.salesChannels.mapping` ON `acris_cookie`.`id` = `acris_cookie.salesChannels.mapping`.`cookie_id`  LEFT JOIN `acris_cookie_group` `acris_cookie.cookieGroup` ON `acris_cookie`.`cookie_group_id` = `acris_cookie.cookieGroup`.`id` LEFT JOIN `sales_channel` `acris_cookie.salesChannels` ON `acris_cookie.salesChannels.mapping`.`sales_channel_id` = `acris_cookie.salesChannels`.`id`  WHERE (`acris_cookie`.`active` = ? AND NOT (`acris_cookie`.`default_value` <=> ?) AND (`acris_cookie.salesChannels`.`id` <=> ? OR `acris_cookie.salesChannels`.`id` = ?) AND `acris_cookie.cookieGroup`.`is_default` = ?) GROUP BY `acris_cookie`.`id`
Parameters:
[
  true
  null
  null
  b"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
  true
]
40 0.53 ms
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`, `acris_cookie.cookieGroup.translation.title` as `acris_cookie.cookieGroup.title`, `acris_cookie.cookieGroup.translation.description`, `acris_cookie.cookieGroup.translation.description` as `acris_cookie.cookieGroup.description`, `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`.`from_extension` as `acris_cookie.fromExtension`, `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`, `acris_cookie.translation.title` as `acris_cookie.title`, `acris_cookie.translation.description`, `acris_cookie.translation.description` as `acris_cookie.description`, `acris_cookie.translation.script`, `acris_cookie.translation.script` as `acris_cookie.script` 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` 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` 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` WHERE `acris_cookie`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    \x01ÿØ\x1D\v­r@ò§\n
    îÒn?u
    """
]
41 0.43 ms
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`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `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` 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"""
    k\tÂÙÛFJ\n
     ¬~.º\x19
    """
]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.