1
3.07 ms
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` ;
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` ; ;
Copy
2
2.54 ms
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ;
Copy
3
2.27 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 ;
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 ;
;
Copy
4
2.69 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' , '' ))
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' , '' ));
Copy
5
2.31 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 :
[
"/account/logout "
true
]
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` = '/account/logout' AND `redirect` . `active` = 1 );
Copy
6
0.40 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 ò
"""
]
SELECT configuration_value FROM system_config WHERE (configuration_key = 'NetiNextStoreLocator.config.seoUrl' ) AND ((sales_channel_id = 0xCE6D8C1B894C45399F74E5050A8908F2 OR sales_channel_id IS NULL )) ORDER BY sales_channel_id IS NULL ASC LIMIT 1 ;
Copy
7
2.94 ms
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND ((seo_path_info = ? OR seo_path_info = ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"""
ÎmŒ\e ‰LE9Ÿtå\x05 \n
‰\x08 ò
"""
"account/logout "
"account/logout/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0xCE6D8C1B894C45399F74E5050A8908F2 OR sales_channel_id IS NULL )) AND ((seo_path_info = 'account/logout' OR seo_path_info = 'account/logout/' ));
Copy
8
0.44 ms
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ? ) AND (sales_channel_id = ? ) AND (path_info = ? ) AND (is_canonical = 1 ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"""
ÎmŒ\e ‰LE9Ÿtå\x05 \n
‰\x08 ò
"""
"/account/logout "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0xCE6D8C1B894C45399F74E5050A8908F2 ) AND (path_info = '/account/logout' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
9
3.04 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"""
ÎmŒ\e ‰LE9Ÿtå\x05 \n
‰\x08 ò
"""
"iCMYh3Lmb1P3ekwgXqOgsdG8hme0zrD3 "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xCE6D8C1B894C45399F74E5050A8908F2 ) AND (token = 'iCMYh3Lmb1P3ekwgXqOgsdG8hme0zrD3' ) LIMIT 1 ;
Copy
10
1.76 ms
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = ? )
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = 1 );
Copy
11
3.47 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\x1D qÅ×ãyÓ¢jÇÊ "
]
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 (? )
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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 (0x019484394E1D718F9EC679E0BD6A80D2 );
Copy
12
0.37 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\x1D qÅ×ãyÓ¢jÇÊ "
]
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 (0x019484394E1D718F9EC679E0BD6A80D2 ));
Copy
13
0.77 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 "
]
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 (? )
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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 (0x0194843A859E70FF95BF32F78F65A163 );
Copy
14
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 öä:à×p ò┐2¸Åeíc "
]
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 (0x0194843A859E70FF95BF32F78F65A163 ));
Copy
15
0.54 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 "
]
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 (? )
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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 (0x019623F66E2570F180DBA9E00FB05416 );
Copy
16
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 –#ön%pñ€Û©à\x0F °T\x16 "
]
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 (0x019623F66E2570F180DBA9E00FB05416 ));
Copy
17
0.41 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`
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`
;
Copy
18
0.20 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`
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`
;
Copy
19
0.27 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†\x1E IѼ|\x7F\x02 ·ÿ "
]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0xCE6D8C1B894C45399F74E5050A8908F2 AND `sales_channel_country` . `country_id` = 0x122A9C44861E49C391BC7C7F0220B7FF );
Copy
20
0.15 ms
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = ? )
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = 1 );
Copy
21
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\x1D qÅ×ãyÓ¢jÇÊ "
]
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 (? )
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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 (0x019484394E1D718F9EC679E0BD6A80D2 );
Copy
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 öä9N\x1D qÅ×ãyÓ¢jÇÊ "
]
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 (0x019484394E1D718F9EC679E0BD6A80D2 ));
Copy
23
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 öä:à×p ò┐2¸Åeíc "
]
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 (? )
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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 (0x0194843A859E70FF95BF32F78F65A163 );
Copy
24
0.29 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 "
]
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 (0x0194843A859E70FF95BF32F78F65A163 ));
Copy
25
0.62 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 "
]
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 (? )
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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 (0x019623F66E2570F180DBA9E00FB05416 );
Copy
26
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 "
]
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 (0x019623F66E2570F180DBA9E00FB05416 ));
Copy
27
0.32 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`
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`
;
Copy
28
0.23 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`
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`
;
Copy
29
1.28 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 "
]
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`
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `acris_cookie.cookieGroup.acris_cookie_group_translation` ON `acris_cookie.cookieGroup.acris_cookie_group_translation` . `acris_cookie_group_id` = `acris_cookie.cookieGroup` . `id` ;
Copy
30
0.66 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 "
]
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 (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
)
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` WHERE `sales_channel` . `id` IN (0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0x2E05C548F98043FAA0F14D091CBDDF1B , 0xCE6D8C1B894C45399F74E5050A8908F2 , 0x2E05C548F98043FAA0F14D091CBDDF1B );
Copy
31
0.15 ms
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ;
Copy
32
0.55 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
]
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 )
)
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 1 AND NOT (`app` . `cookies` IS NULL ));
Copy
33
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` . `active` = ? AND NOT (`app` . `cookies` IS NULL ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
]
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 )
)
Copy
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 1 AND NOT (`app` . `cookies` IS NULL ));
Copy
34
0.15 ms
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ;
Copy
35
0.14 ms
SELECT `acris_cookie_group` . `id` FROM `acris_cookie_group` WHERE (`acris_cookie_group` . `identification` = ? ) LIMIT 1
Parameters :
[
"functional "
]
SELECT `acris_cookie_group` . `id` FROM `acris_cookie_group` WHERE (`acris_cookie_group` . `identification` = 'functional' ) LIMIT 1 ;
Copy
36
0.25 ms
SELECT `acris_cookie_group` . `id` AS `acris_cookie_group.id` , `acris_cookie_group` . `is_default` AS `acris_cookie_group.isDefault` , `acris_cookie_group` . `identification` AS `acris_cookie_group.identification` , `acris_cookie_group` . `created_at` AS `acris_cookie_group.createdAt` , `acris_cookie_group` . `updated_at` AS `acris_cookie_group.updatedAt` , `acris_cookie_group.translation.title` , 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 "
]
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 'cookie.groupStatistical' );
Copy
37
0.22 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 "
]
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 'cookie.groupMarketing' );
Copy
38
0.20 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 "
]
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 'cookie.groupComfortFeatures' );
Copy
39
0.19 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 "
]
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 'neti-next-store-locator.cookie.google-consent.name' );
Copy
40
0.19 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 "
]
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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 'cookie.groupAffiliate' );
Copy
41
0.31 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 \w2 "
b"ª\x1C\e ŽÀ\x04 OR¤óm¢8‹BÌ "
b"ù6\t\x01 OèLt—#kèel\x00 å "
b"‚^\x18 ;snHµŒ$¤‰YãG "
b"¦ˆù\x15 Ã…EP»‚DBÈgZ× "
b"\x01 ’2åñ`r=°\x0E ¿?;8ÚF "
b"""
\t i:\x11 DxH ‡\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"úŽÿí¥\x1E K\x02 ’LwJÌá\x18 „ "
b"\x01 ˜\x08 $½÷t÷°/2EöÆœ˜ "
]
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 (0x09913B2AD6514EA3B2B58A82AFA401E6 , 0x5BDC7E444A2F463896DEFC035C77AD32 , 0xAA1C1B8EC0044F52A4F36DA2388B42CC , 0xF93609014FE84C7497236BE8656C00E5 , 0x825E183B736E48B58C24A489AD59E347 , 0xA688F915C3854550BB824442C8675AD7 , 0x019232E5F160723DB00EBF3F3B38DA46 , 0x09693A1144784820870A4297D969F6B0 , 0x34E8378874544142B2C48D32584AFA4E , 0x65101FBE7DED4FDEAA87551CDA43CBC7 , 0xB5B076F2302A418FBB72BA615E02963A , 0xFA8EFFEDA51E4B02924C774ACCE11884 , 0x01980824BDF774F7B02F3245F6C69C98 );
Copy
42
0.39 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`
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` ;
Copy