Error 500 Internal Server Error

GET https://staging-b2b.gefu.com/StoreLocator

Query Metrics

71 Database Queries
32 Different statements
41.51 ms Query time

Queries

Group similar statements

# Time Info
1 0.44 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.26 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
3 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:
[]
4 0.18 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:
[]
5 0.22 ms
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:
[
  "/store-finder"
  true
]
6 0.29 ms
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ò
    """
]
7 0.17 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[
  b"""
    ÎmŒ\e‰LE9Ÿtå\x05\n
    \x08ò
    """
  "w77fWOS4xGqfzFeTAJKkxtoYAxloe1Qk"
]
8 0.14 ms
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
  true
]
9 0.87 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`.`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ÇÊ"
]
10 0.15 ms
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ÇÊ"
]
11 0.59 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`.`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öä:à×p ò┐2¸Åeíc"
]
12 0.13 ms
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öä:à×p ò┐2¸Åeíc"
]
13 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`.`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–#ön%pñ€Û©à\x0F°T\x16"
]
14 0.13 ms
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–#ön%pñ€Û©à\x0F°T\x16"
]
15 0.35 ms
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:
[]
16 0.18 ms
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:
[]
17 0.13 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"""
    ÎmŒ\e‰LE9Ÿtå\x05\n
    \x08ò
    """
  b"\x12*œD†\x1EIѼ|\x7F\x02 ·ÿ"
]
18 0.11 ms
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
  true
]
19 0.49 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`.`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ÇÊ"
]
20 0.12 ms
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ÇÊ"
]
21 0.32 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`.`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öä:à×p ò┐2¸Åeíc"
]
22 0.13 ms
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öä:à×p ò┐2¸Åeíc"
]
23 0.34 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`.`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–#ön%pñ€Û©à\x0F°T\x16"
]
24 0.17 ms
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–#ön%pñ€Û©à\x0F°T\x16"
]
25 0.28 ms
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:
[]
26 0.16 ms
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:
[]
27 1.06 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`, 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"
]
28 0.73 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`, 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"
]
29 0.14 ms
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[]
30 0.11 ms
SELECT `acris_cookie_group`.`id` FROM `acris_cookie_group` ORDER BY `acris_cookie_group`.`is_default` DESC, `acris_cookie_group`.`is_default` DESC
Parameters:
[]
31 0.27 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`, 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`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    õ^;íÉ]MÁž\n
    7\x1A¼¢\\
    """
  b"\x00î:\x11\x03eM■ùüãìº5\f£"
  b"\f1É} \x12F£áÖºÕÞÔ\fu"
  b"""
    ,\x1D1i -B㤄TÉ5\n
    ì\x16
    """
  b"1>˃¤×L‚Ž»ý*RÂ8½"
  b"HÇÅo'1E\x18╣Ïh▓+£æä"
  b"UÒ†KU:OT‹pò°”ml¨"
  b"\x10ß¾iF8ŸóÄØçÜKl"
  b"kÊ7å¶ßAW˜‚\x06åfØ¢ƒ"
  b"zñ~N¦+Huºýÿ1”ÙÕT"
  b"£jZŸØ"BÀ€{®…š,Q²"
  b"§2»i©‘Ev‹—Œ*‡;=="
  b"ç\v%íŽ/Fû«ÊÝÉ¥\x00"
]
32 0.85 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`, 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` WHERE (`acris_cookie`.`cookie_group_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x00î:\x11\x03eM■ùüãìº5\f£"
  b"\f1É} \x12F£áÖºÕÞÔ\fu"
  b"""
    ,\x1D1i -B㤄TÉ5\n
    ì\x16
    """
  b"1>˃¤×L‚Ž»ý*RÂ8½"
  b"HÇÅo'1E\x18╣Ïh▓+£æä"
  b"UÒ†KU:OT‹pò°”ml¨"
  b"\x10ß¾iF8ŸóÄØçÜKl"
  b"kÊ7å¶ßAW˜‚\x06åfØ¢ƒ"
  b"zñ~N¦+Huºýÿ1”ÙÕT"
  b"£jZŸØ"BÀ€{®…š,Q²"
  b"§2»i©‘Ev‹—Œ*‡;=="
  b"ç\v%íŽ/Fû«ÊÝÉ¥\x00"
  b"""
    õ^;íÉ]MÁž\n
    7\x1A¼¢\\
    """
]
33 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`, 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"""
    Î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"""
    Î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"""
    Î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".\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"""
    Î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"""
    ÎmŒ\e‰LE9Ÿtå\x05\n
    \x08ò
    """
  b".\x05ÅHù€Cú ñM\t\x1C½ß\e"
]
34 0.62 ms
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
  true
]
35 0.42 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`.`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ÇÊ"
]
36 0.16 ms
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ÇÊ"
]
37 0.36 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`.`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öä:à×p ò┐2¸Åeíc"
]
38 0.12 ms
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öä:à×p ò┐2¸Åeíc"
]
39 0.38 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`.`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–#ön%pñ€Û©à\x0F°T\x16"
]
40 0.13 ms
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–#ön%pñ€Û©à\x0F°T\x16"
]
41 0.29 ms
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:
[]
42 0.16 ms
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:
[]
43 0.11 ms
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
  true
]
44 0.33 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`.`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ÇÊ"
]
45 0.12 ms
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ÇÊ"
]
46 0.31 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`.`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öä:à×p ò┐2¸Åeíc"
]
47 0.12 ms
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öä:à×p ò┐2¸Åeíc"
]
48 0.37 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`.`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–#ön%pñ€Û©à\x0F°T\x16"
]
49 0.12 ms
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–#ön%pñ€Û©à\x0F°T\x16"
]
50 0.26 ms
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:
[]
51 0.16 ms
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:
[]
52 0.27 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`, 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"?Ö›î…OGº¸/k>%Ü_\x05"
]
53 2.37 ms
SELECT `media`.`id` AS `media.id`, `media`.`user_id` AS `media.userId`, `media`.`media_folder_id` AS `media.mediaFolderId`, `media`.`mime_type` AS `media.mimeType`, `media`.`file_extension` AS `media.fileExtension`, `media`.`uploaded_at` AS `media.uploadedAt`, `media`.`file_name` AS `media.fileName`, `media`.`file_size` AS `media.fileSize`, `media`.`media_type` AS `media.mediaTypeRaw`, `media`.`meta_data` AS `media.metaData`, `media`.`config` AS `media.config`, `media`.`path` AS `media.path`, `media`.`private` AS `media.private`, `media`.`thumbnails_ro` AS `media.thumbnailsRo`, `media`.`created_at` AS `media.createdAt`, `media`.`updated_at` AS `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) AS `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) AS `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) AS `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title AS `media.translation.title`, `media.translation`.alt AS `media.translation.alt`, `media.translation`.custom_fields AS `media.translation.customFields`, `media.translation`.created_at AS `media.translation.createdAt`, `media.translation`.updated_at AS `media.translation.updatedAt`, `media.translation`.media_id AS `media.translation.mediaId`, `media.translation`.language_id AS `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (`media`.`id` = ? AND (`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¼\x17ŽhºeI\x15±@\x1DïîªV4"
  false
  true
  "product_download"
]
54 2.38 ms
SELECT `plugin`.`id` AS `plugin.id`, `plugin`.`base_class` AS `plugin.baseClass`, `plugin`.`name` AS `plugin.name`, `plugin`.`composer_name` AS `plugin.composerName`, `plugin`.`autoload` AS `plugin.autoload`, `plugin`.`active` AS `plugin.active`, `plugin`.`managed_by_composer` AS `plugin.managedByComposer`, `plugin`.`path` AS `plugin.path`, `plugin`.`author` AS `plugin.author`, `plugin`.`copyright` AS `plugin.copyright`, `plugin`.`license` AS `plugin.license`, `plugin`.`version` AS `plugin.version`, `plugin`.`upgrade_version` AS `plugin.upgradeVersion`, `plugin`.`installed_at` AS `plugin.installedAt`, `plugin`.`upgraded_at` AS `plugin.upgradedAt`, `plugin`.`icon` AS `plugin.iconRaw`, `plugin`.`created_at` AS `plugin.createdAt`, `plugin`.`updated_at` AS `plugin.updatedAt`, `plugin.translation.label`, COALESCE(`plugin.translation.label`,`plugin.translation.label`) AS `plugin.label`, `plugin.translation.description`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) AS `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) AS `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) AS `plugin.supportLink`, `plugin.translation.customFields`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) AS `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label AS `plugin.translation.label`, `plugin.translation`.description AS `plugin.translation.description`, `plugin.translation`.manufacturer_link AS `plugin.translation.manufacturerLink`, `plugin.translation`.support_link AS `plugin.translation.supportLink`, `plugin.translation`.custom_fields AS `plugin.translation.customFields`, `plugin.translation`.created_at AS `plugin.translation.createdAt`, `plugin.translation`.updated_at AS `plugin.translation.updatedAt`, `plugin.translation`.plugin_id AS `plugin.translation.pluginId`, `plugin.translation`.language_id AS `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = ?) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`name` = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "NetiNextStorePickup"
]
55 0.13 ms
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
  "de-DE"
]
56 11.85 ms
SELECT `neti_store_locator`.`id` FROM `neti_store_locator` LEFT JOIN `neti_store_sales_channel` `neti_store_locator.salesChannels.mapping` ON `neti_store_locator`.`id` = `neti_store_locator.salesChannels.mapping`.`store_id`  LEFT JOIN `sales_channel` `neti_store_locator.salesChannels` ON `neti_store_locator.salesChannels.mapping`.`sales_channel_id` = `neti_store_locator.salesChannels`.`id`  WHERE (`neti_store_locator.salesChannels`.`id` = ?) GROUP BY `neti_store_locator`.`country_id`
Parameters:
[
  b"""
    ÎmŒ\e‰LE9Ÿtå\x05\n
    \x08ò
    """
]
57 1.11 ms
SELECT `neti_store_locator`.`id` AS `neti_store_locator.id`, `neti_store_locator`.`label` AS `neti_store_locator.label`, `neti_store_locator`.`street` AS `neti_store_locator.street`, `neti_store_locator`.`street_number` AS `neti_store_locator.streetNumber`, `neti_store_locator`.`zip_code` AS `neti_store_locator.zipCode`, `neti_store_locator`.`city` AS `neti_store_locator.city`, `neti_store_locator`.`address_hash` AS `neti_store_locator.addressHash`, `neti_store_locator`.`longitude` AS `neti_store_locator.longitude`, `neti_store_locator`.`latitude` AS `neti_store_locator.latitude`, `neti_store_locator`.`timezone` AS `neti_store_locator.timezone`, `neti_store_locator`.`phone` AS `neti_store_locator.phone`, `neti_store_locator`.`fax` AS `neti_store_locator.fax`, `neti_store_locator`.`url` AS `neti_store_locator.url`, `neti_store_locator`.`url_label` AS `neti_store_locator.urlLabel`, `neti_store_locator`.`email` AS `neti_store_locator.email`, `neti_store_locator`.`country_id` AS `neti_store_locator.countryId`, `neti_store_locator`.`country_state_id` AS `neti_store_locator.countryStateId`, `neti_store_locator`.`active` AS `neti_store_locator.active`, `neti_store_locator`.`contact_form_enabled` AS `neti_store_locator.contactFormEnabled`, `neti_store_locator`.`contact_form_detail` AS `neti_store_locator.contactFormDetail`, `neti_store_locator`.`hidden` AS `neti_store_locator.hidden`, `neti_store_locator`.`notification_email` AS `neti_store_locator.notificationMailAddress`, `neti_store_locator`.`show_always` AS `neti_store_locator.showAlways`, `neti_store_locator`.`zoom` AS `neti_store_locator.zoom`, `neti_store_locator`.`exclude_from_sync` AS `neti_store_locator.excludeFromSync`, `neti_store_locator`.`google_place_id` AS `neti_store_locator.googlePlaceID`, `neti_store_locator`.`featured` AS `neti_store_locator.featured`, `neti_store_locator`.`radius` AS `neti_store_locator.radius`, `neti_store_locator`.`detail_page_enabled` AS `neti_store_locator.detailPageEnabled`, `neti_store_locator`.`detail_content_type` AS `neti_store_locator.detailContentType`, `neti_store_locator`.`detail_in_sitemap` AS `neti_store_locator.detailInSitemap`, `neti_store_locator`.`picture_media_id` AS `neti_store_locator.pictureMediaId`, `neti_store_locator`.`details_picture_media_id` AS `neti_store_locator.detailsPictureMediaId`, `neti_store_locator`.`icon_media_id` AS `neti_store_locator.iconMediaId`, `neti_store_locator`.`external_id` AS `neti_store_locator.externalId`, `neti_store_locator`.`created_at` AS `neti_store_locator.createdAt`, `neti_store_locator`.`updated_at` AS `neti_store_locator.updatedAt`, `neti_store_locator.country`.`id` AS `neti_store_locator.country.id`, `neti_store_locator.country`.`iso` AS `neti_store_locator.country.iso`, `neti_store_locator.country`.`position` AS `neti_store_locator.country.position`, `neti_store_locator.country`.`active` AS `neti_store_locator.country.active`, `neti_store_locator.country`.`shipping_available` AS `neti_store_locator.country.shippingAvailable`, `neti_store_locator.country`.`iso3` AS `neti_store_locator.country.iso3`, `neti_store_locator.country`.`display_state_in_registration` AS `neti_store_locator.country.displayStateInRegistration`, `neti_store_locator.country`.`force_state_in_registration` AS `neti_store_locator.country.forceStateInRegistration`, `neti_store_locator.country`.`check_vat_id_pattern` AS `neti_store_locator.country.checkVatIdPattern`, `neti_store_locator.country`.`vat_id_required` AS `neti_store_locator.country.vatIdRequired`, `neti_store_locator.country`.`vat_id_pattern` AS `neti_store_locator.country.vatIdPattern`, `neti_store_locator.country`.`customer_tax` AS `neti_store_locator.country.customerTax`, `neti_store_locator.country`.`company_tax` AS `neti_store_locator.country.companyTax`, `neti_store_locator.country`.`postal_code_required` AS `neti_store_locator.country.postalCodeRequired`, `neti_store_locator.country`.`check_postal_code_pattern` AS `neti_store_locator.country.checkPostalCodePattern`, `neti_store_locator.country`.`check_advanced_postal_code_pattern` AS `neti_store_locator.country.checkAdvancedPostalCodePattern`, `neti_store_locator.country`.`advanced_postal_code_pattern` AS `neti_store_locator.country.advancedPostalCodePattern`, `neti_store_locator.country`.`default_postal_code_pattern` AS `neti_store_locator.country.defaultPostalCodePattern`, `neti_store_locator.country`.`created_at` AS `neti_store_locator.country.createdAt`, `neti_store_locator.country`.`updated_at` AS `neti_store_locator.country.updatedAt`, `neti_store_locator.country.translation.name`, COALESCE(`neti_store_locator.country.translation.name`,`neti_store_locator.country.translation.name`) AS `neti_store_locator.country.name`, `neti_store_locator.country.translation.addressFormat`, COALESCE(`neti_store_locator.country.translation.addressFormat`,`neti_store_locator.country.translation.addressFormat`) AS `neti_store_locator.country.addressFormat`, `neti_store_locator.country.translation.customFields`, COALESCE(`neti_store_locator.country.translation.customFields`,`neti_store_locator.country.translation.customFields`) AS `neti_store_locator.country.customFields`, `neti_store_locator.country.translation.createdAt`, `neti_store_locator.country.translation.updatedAt`, `neti_store_locator.country.translation.countryId`, `neti_store_locator.country.translation.languageId`, `neti_store_locator.translation.description`, COALESCE(`neti_store_locator.translation.description`,`neti_store_locator.translation.description`) AS `neti_store_locator.description`, `neti_store_locator.translation.additionalInformation`, COALESCE(`neti_store_locator.translation.additionalInformation`,`neti_store_locator.translation.additionalInformation`) AS `neti_store_locator.additionalInformation`, `neti_store_locator.translation.seoTitle`, COALESCE(`neti_store_locator.translation.seoTitle`,`neti_store_locator.translation.seoTitle`) AS `neti_store_locator.seoTitle`, `neti_store_locator.translation.seoUrl`, COALESCE(`neti_store_locator.translation.seoUrl`,`neti_store_locator.translation.seoUrl`) AS `neti_store_locator.seoUrl`, `neti_store_locator.translation.seoDescription`, COALESCE(`neti_store_locator.translation.seoDescription`,`neti_store_locator.translation.seoDescription`) AS `neti_store_locator.seoDescription`, `neti_store_locator.translation.detailTitle`, COALESCE(`neti_store_locator.translation.detailTitle`,`neti_store_locator.translation.detailTitle`) AS `neti_store_locator.detailTitle`, `neti_store_locator.translation.detailDescription`, COALESCE(`neti_store_locator.translation.detailDescription`,`neti_store_locator.translation.detailDescription`) AS `neti_store_locator.detailDescription`, `neti_store_locator.translation.openingTimes`, COALESCE(`neti_store_locator.translation.openingTimes`,`neti_store_locator.translation.openingTimes`) AS `neti_store_locator.openingTimes`, `neti_store_locator.translation.customFields`, COALESCE(`neti_store_locator.translation.customFields`,`neti_store_locator.translation.customFields`) AS `neti_store_locator.customFields`, `neti_store_locator.translation.createdAt`, `neti_store_locator.translation.updatedAt`, `neti_store_locator.translation.netiStoreLocatorId`, `neti_store_locator.translation.languageId` FROM `neti_store_locator` LEFT JOIN (SELECT `neti_store_locator.translation`.neti_store_locator_id, `neti_store_locator.translation`.description AS `neti_store_locator.translation.description`, `neti_store_locator.translation`.additional_information AS `neti_store_locator.translation.additionalInformation`, `neti_store_locator.translation`.seo_title AS `neti_store_locator.translation.seoTitle`, `neti_store_locator.translation`.seo_url AS `neti_store_locator.translation.seoUrl`, `neti_store_locator.translation`.seo_description AS `neti_store_locator.translation.seoDescription`, `neti_store_locator.translation`.detail_title AS `neti_store_locator.translation.detailTitle`, `neti_store_locator.translation`.detail_description AS `neti_store_locator.translation.detailDescription`, `neti_store_locator.translation`.opening_times AS `neti_store_locator.translation.openingTimes`, `neti_store_locator.translation`.custom_fields AS `neti_store_locator.translation.customFields`, `neti_store_locator.translation`.created_at AS `neti_store_locator.translation.createdAt`, `neti_store_locator.translation`.updated_at AS `neti_store_locator.translation.updatedAt`, `neti_store_locator.translation`.neti_store_locator_id AS `neti_store_locator.translation.netiStoreLocatorId`, `neti_store_locator.translation`.language_id AS `neti_store_locator.translation.languageId` FROM `neti_store_locator_translation` `neti_store_locator.translation` WHERE `neti_store_locator.translation`.language_id = ?) `neti_store_locator.neti_store_locator_translation` ON `neti_store_locator.neti_store_locator_translation`.`neti_store_locator_id` = `neti_store_locator`.`id` LEFT JOIN `country` `neti_store_locator.country` ON `neti_store_locator`.`country_id` = `neti_store_locator.country`.`id` LEFT JOIN (SELECT `neti_store_locator.country.translation`.country_id, `neti_store_locator.country.translation`.name AS `neti_store_locator.country.translation.name`, `neti_store_locator.country.translation`.address_format AS `neti_store_locator.country.translation.addressFormat`, `neti_store_locator.country.translation`.custom_fields AS `neti_store_locator.country.translation.customFields`, `neti_store_locator.country.translation`.created_at AS `neti_store_locator.country.translation.createdAt`, `neti_store_locator.country.translation`.updated_at AS `neti_store_locator.country.translation.updatedAt`, `neti_store_locator.country.translation`.country_id AS `neti_store_locator.country.translation.countryId`, `neti_store_locator.country.translation`.language_id AS `neti_store_locator.country.translation.languageId` FROM `country_translation` `neti_store_locator.country.translation` WHERE `neti_store_locator.country.translation`.language_id = ?) `neti_store_locator.country.country_translation` ON `neti_store_locator.country.country_translation`.`country_id` = `neti_store_locator.country`.`id` WHERE `neti_store_locator`.`id` IN (?, ?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x00\r‰\8\BN†™°¯\x03h\x0F\e"
  b"\x00.º70YNº©¬Ô;ø░9Ø"
  b"""
    \x08Úgñ²"Jw´š\n
    _\x14©a?
    """
]
58 2.01 ms
SELECT `old_seo_urls`.`id` FROM `old_seo_urls` WHERE (`old_seo_urls`.`old_seo_url` LIKE ?) LIMIT 1
Parameters:
[
  "%storelocator%"
]
59 0.40 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‘;*ÖQN£²µŠ‚¯¤\x01æ"
  b"[Ü~DJ/F8–Þü\x03\w­2"
  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öÆœ˜"
]
60 1.38 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`, 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"
]
61 0.74 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`, 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"
]
62 0.65 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`.`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
]
63 0.58 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`.`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
]
64 0.16 ms
SELECT `acris_cookie_group`.`id` FROM `acris_cookie_group` WHERE (`acris_cookie_group`.`identification` = ?) LIMIT 1
Parameters:
[
  "functional"
]
65 0.32 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`, 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"
]
66 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`, 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.groupMarketing"
]
67 0.45 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`, 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.groupComfortFeatures"
]
68 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`, 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"
  "neti-next-store-locator.cookie.google-consent.name"
]
69 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`, 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.groupAffiliate"
]
70 0.28 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‘;*ÖQN£²µŠ‚¯¤\x01æ"
  b"[Ü~DJ/F8–Þü\x03\w­2"
  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öÆœ˜"
]
71 0.25 ms
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:
[]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.