5.57 ms
1
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (seo_url . language_id = ? ) AND (seo_url . sales_channel_id = ? OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 )
Parameters :
[
"/navigation/2ca74aa4b6734696bc27b1c056db8ab8 "
"/navigation/c69d2bb30f4d421fb31621c9a1a1a3e5 "
"/navigation/2446cc998f844b95824b502461852a3e "
"/navigation/b105da45770d42f4b5c70e8154a30056 "
"/navigation/b7ada48edad3455493417e06f3b6404d "
"/navigation/439dc38c3f9e4852ac01bd97a72e4882 "
"/navigation/01971195daa57aaaa9416940ca00b99a "
"/navigation/3edc8ee7796c45239cc2a76762d3034f "
"/navigation/42b54967dc8d42a8b31270e25c5ae1ab "
"/navigation/50b4097e185e42d0b5afbc24f4e2d015 "
"/navigation/926291283b7a453fb7af9dfbdd272d5f "
"/navigation/5c37f70905234f1db2b7ca1279bb8db3 "
"/navigation/a44a38fc51c64459841e51c7102f36ef "
"/navigation/455a81265d0a4c47b2f307e8cad64011 "
"/navigation/fc6c6b2f41fe4dabaf249abd4a96a670 "
"/navigation/a1979c8919ac4eb4bcb315bd0e49d1ca "
"/navigation/51dbf7811d7d4228a0624fd7b13393a8 "
"/navigation/dd9a30d09b0f4c5baff99eb5f0a2b5d3 "
"/navigation/965f1a3bf1f24c298e5268fc1a5fcf55 "
"/navigation/de5aba2eb86c475b9b1a9c3d88c11dd8 "
"/navigation/c9cb6825af6741438a63eea13d8bd1f9 "
"/navigation/7963f31c95e1416a8dfec93c3dcf3910 "
"/navigation/292a5bd4aebe45f892507f77cf477f80 "
"/navigation/69a179917ae44335b8a021b10d8f4d7a "
"/navigation/b7f7a840961548818c4afe4daff94167 "
"/navigation/04734c61638d4db3afc07417558d361d "
"/navigation/2a781b99b9974768859861bc77fbc68e "
"/navigation/dbe9937c19874e2db720ae96bad6db61 "
"/navigation/66e78e0558e340258482d8cf97edb345 "
"/navigation/0194a7a757417c3ea528fa9289514ba1 "
"/navigation/3ed3acf74e3a4eaca05853b448166afb "
"/landingPage/57032895960b4dad99c6a7b251e6be4c "
b"/»_ââšMpªXTÎ|ãâ\v "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
]
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN ('/navigation/2ca74aa4b6734696bc27b1c056db8ab8' , '/navigation/c69d2bb30f4d421fb31621c9a1a1a3e5' , '/navigation/2446cc998f844b95824b502461852a3e' , '/navigation/b105da45770d42f4b5c70e8154a30056' , '/navigation/b7ada48edad3455493417e06f3b6404d' , '/navigation/439dc38c3f9e4852ac01bd97a72e4882' , '/navigation/01971195daa57aaaa9416940ca00b99a' , '/navigation/3edc8ee7796c45239cc2a76762d3034f' , '/navigation/42b54967dc8d42a8b31270e25c5ae1ab' , '/navigation/50b4097e185e42d0b5afbc24f4e2d015' , '/navigation/926291283b7a453fb7af9dfbdd272d5f' , '/navigation/5c37f70905234f1db2b7ca1279bb8db3' , '/navigation/a44a38fc51c64459841e51c7102f36ef' , '/navigation/455a81265d0a4c47b2f307e8cad64011' , '/navigation/fc6c6b2f41fe4dabaf249abd4a96a670' , '/navigation/a1979c8919ac4eb4bcb315bd0e49d1ca' , '/navigation/51dbf7811d7d4228a0624fd7b13393a8' , '/navigation/dd9a30d09b0f4c5baff99eb5f0a2b5d3' , '/navigation/965f1a3bf1f24c298e5268fc1a5fcf55' , '/navigation/de5aba2eb86c475b9b1a9c3d88c11dd8' , '/navigation/c9cb6825af6741438a63eea13d8bd1f9' , '/navigation/7963f31c95e1416a8dfec93c3dcf3910' , '/navigation/292a5bd4aebe45f892507f77cf477f80' , '/navigation/69a179917ae44335b8a021b10d8f4d7a' , '/navigation/b7f7a840961548818c4afe4daff94167' , '/navigation/04734c61638d4db3afc07417558d361d' , '/navigation/2a781b99b9974768859861bc77fbc68e' , '/navigation/dbe9937c19874e2db720ae96bad6db61' , '/navigation/66e78e0558e340258482d8cf97edb345' , '/navigation/0194a7a757417c3ea528fa9289514ba1' , '/navigation/3ed3acf74e3a4eaca05853b448166afb' , '/landingPage/57032895960b4dad99c6a7b251e6be4c' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0xA290DC5C19E14CBEBBA6C40F9C59949F OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
5.27 ms
12
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 –\x1F Â\x08 æpÒˆÊvÜ©ÛÀ² ]
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 (0x01961FC208E670D288CA76DCA9DBC0B2 ); Copy
4.26 ms
2
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
3.83 ms
1
SELECT `neti_store_locator` . `id` FROM `neti_store_locator` LEFT JOIN `neti_store_sales_channel` `neti_store_locator.salesChannels.mapping` ON `neti_store_locator` . `id` = `neti_store_locator.salesChannels.mapping` . `store_id` LEFT JOIN `sales_channel` `neti_store_locator.salesChannels` ON `neti_store_locator.salesChannels.mapping` . `sales_channel_id` = `neti_store_locator.salesChannels` . `id` WHERE (`neti_store_locator.salesChannels` . `id` = ? ) GROUP BY `neti_store_locator` . `country_id`
Parameters :
[
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
]
SELECT `neti_store_locator` . `id` FROM `neti_store_locator` LEFT JOIN `neti_store_sales_channel` `neti_store_locator.salesChannels.mapping` ON `neti_store_locator` . `id` = `neti_store_locator.salesChannels.mapping` . `store_id` LEFT JOIN `sales_channel` `neti_store_locator.salesChannels` ON `neti_store_locator.salesChannels.mapping` . `sales_channel_id` = `neti_store_locator.salesChannels` . `id` WHERE (`neti_store_locator.salesChannels` . `id` = 0xA290DC5C19E14CBEBBA6C40F9C59949F ) GROUP BY `neti_store_locator` . `country_id` ; Copy
2.30 ms
7
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
2.12 ms
2
SELECT `app` . `id` AS `app.id` , `app` . `name` AS `app.name` , `app` . `path` AS `app.path` , `app` . `author` AS `app.author` , `app` . `copyright` AS `app.copyright` , `app` . `license` AS `app.license` , `app` . `active` AS `app.active` , `app` . `configurable` AS `app.configurable` , `app` . `privacy` AS `app.privacy` , `app` . `version` AS `app.version` , `app` . `icon` AS `app.iconRaw` , `app` . `app_secret` AS `app.appSecret` , `app` . `modules` AS `app.modules` , `app` . `main_module` AS `app.mainModule` , `app` . `cookies` AS `app.cookies` , `app` . `allow_disable` AS `app.allowDisable` , `app` . `base_app_url` AS `app.baseAppUrl` , `app` . `allowed_hosts` AS `app.allowedHosts` , `app` . `template_load_priority` AS `app.templateLoadPriority` , `app` . `checkout_gateway_url` AS `app.checkoutGatewayUrl` , `app` . `integration_id` AS `app.integrationId` , `app.integration` . `id` AS `app.integration.id` , `app.integration` . `label` AS `app.integration.label` , `app.integration` . `access_key` AS `app.integration.accessKey` , `app.integration` . `secret_access_key` AS `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` AS `app.integration.lastUsageAt` , `app.integration` . `admin` AS `app.integration.admin` , `app.integration` . `custom_fields` AS `app.integration.customFields` , `app.integration` . `deleted_at` AS `app.integration.deletedAt` , `app.integration` . `created_at` AS `app.integration.createdAt` , `app.integration` . `updated_at` AS `app.integration.updatedAt` , `app` . `acl_role_id` AS `app.aclRoleId` , `app.aclRole` . `id` AS `app.aclRole.id` , `app.aclRole` . `name` AS `app.aclRole.name` , `app.aclRole` . `description` AS `app.aclRole.description` , `app.aclRole` . `privileges` AS `app.aclRole.privileges` , `app.aclRole` . `deleted_at` AS `app.aclRole.deletedAt` , `app.aclRole` . `created_at` AS `app.aclRole.createdAt` , `app.aclRole` . `updated_at` AS `app.aclRole.updatedAt` , `app` . `created_at` AS `app.createdAt` , `app` . `updated_at` AS `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) AS `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) AS `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) AS `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) AS `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label AS `app.translation.label` , `app.translation` . description AS `app.translation.description` , `app.translation` . privacy_policy_extensions AS `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields AS `app.translation.customFields` , `app.translation` . created_at AS `app.translation.createdAt` , `app.translation` . updated_at AS `app.translation.updatedAt` , `app.translation` . app_id AS `app.translation.appId` , `app.translation` . language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE (`app` . `active` = ? AND NOT (`app` . `cookies` IS NULL ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
]
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
1.68 ms
12
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 –\x1F Â\x08 æpÒˆÊvÜ©ÛÀ² ]
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 (0x01961FC208E670D288CA76DCA9DBC0B2 )); Copy
1.55 ms
2
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":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
]
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 (0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F ); Copy
1.25 ms
1
SELECT `acris_cookie` . `id` AS `acris_cookie.id` , `acris_cookie` . `cookie_group_id` AS `acris_cookie.cookieGroupId` , `acris_cookie.cookieGroup` . `id` AS `acris_cookie.cookieGroup.id` , `acris_cookie.cookieGroup` . `is_default` AS `acris_cookie.cookieGroup.isDefault` , `acris_cookie.cookieGroup` . `identification` AS `acris_cookie.cookieGroup.identification` , `acris_cookie.cookieGroup` . `created_at` AS `acris_cookie.cookieGroup.createdAt` , `acris_cookie.cookieGroup` . `updated_at` AS `acris_cookie.cookieGroup.updatedAt` , `acris_cookie.cookieGroup.translation.title` , COALESCE (`acris_cookie.cookieGroup.translation.title` , `acris_cookie.cookieGroup.translation.title` ) AS `acris_cookie.cookieGroup.title` , `acris_cookie.cookieGroup.translation.description` , COALESCE (`acris_cookie.cookieGroup.translation.description` , `acris_cookie.cookieGroup.translation.description` ) AS `acris_cookie.cookieGroup.description` , `acris_cookie.cookieGroup.translation.createdAt` , `acris_cookie.cookieGroup.translation.updatedAt` , `acris_cookie.cookieGroup.translation.acrisCookieGroupId` , `acris_cookie.cookieGroup.translation.languageId` , `acris_cookie` . `cookie_id` AS `acris_cookie.cookieId` , `acris_cookie` . `google_cookie_consent_mode` AS `acris_cookie.googleCookieConsentMode` , `acris_cookie` . `default_value` AS `acris_cookie.defaultValue` , `acris_cookie` . `script_position` AS `acris_cookie.scriptPosition` , `acris_cookie` . `provider` AS `acris_cookie.provider` , `acris_cookie` . `active` AS `acris_cookie.active` , `acris_cookie` . `unknown` AS `acris_cookie.unknown` , `acris_cookie` . `is_default` AS `acris_cookie.isDefault` , `acris_cookie` . `created_at` AS `acris_cookie.createdAt` , `acris_cookie` . `updated_at` AS `acris_cookie.updatedAt` , (SELECT GROUP_CONCAT (HEX (`acris_cookie.salesChannels.mapping` . `sales_channel_id` ) SEPARATOR '||' )
FROM `acris_cookie_sales_channel` `acris_cookie.salesChannels.mapping`
WHERE `acris_cookie.salesChannels.mapping` . `cookie_id` = `acris_cookie` . `id` ) AS `acris_cookie.salesChannels.id_mapping` , `acris_cookie.translation.title` , COALESCE (`acris_cookie.translation.title` , `acris_cookie.translation.title` ) AS `acris_cookie.title` , `acris_cookie.translation.description` , COALESCE (`acris_cookie.translation.description` , `acris_cookie.translation.description` ) AS `acris_cookie.description` , `acris_cookie.translation.script` , COALESCE (`acris_cookie.translation.script` , `acris_cookie.translation.script` ) AS `acris_cookie.script` , `acris_cookie.translation.createdAt` , `acris_cookie.translation.updatedAt` , `acris_cookie.translation.acrisCookieId` , `acris_cookie.translation.languageId` FROM `acris_cookie` LEFT JOIN `acris_cookie_group` `acris_cookie.cookieGroup` ON `acris_cookie` . `cookie_group_id` = `acris_cookie.cookieGroup` . `id` LEFT JOIN (SELECT `acris_cookie.translation` . acris_cookie_id , `acris_cookie.translation` . title AS `acris_cookie.translation.title` , `acris_cookie.translation` . description AS `acris_cookie.translation.description` , `acris_cookie.translation` . script AS `acris_cookie.translation.script` , `acris_cookie.translation` . created_at AS `acris_cookie.translation.createdAt` , `acris_cookie.translation` . updated_at AS `acris_cookie.translation.updatedAt` , `acris_cookie.translation` . acris_cookie_id AS `acris_cookie.translation.acrisCookieId` , `acris_cookie.translation` . language_id AS `acris_cookie.translation.languageId` FROM `acris_cookie_translation` `acris_cookie.translation` WHERE `acris_cookie.translation` . language_id = ? ) `acris_cookie.acris_cookie_translation` ON `acris_cookie.acris_cookie_translation` . `acris_cookie_id` = `acris_cookie` . `id` LEFT JOIN (SELECT `acris_cookie.cookieGroup.translation` . acris_cookie_group_id , `acris_cookie.cookieGroup.translation` . title AS `acris_cookie.cookieGroup.translation.title` , `acris_cookie.cookieGroup.translation` . description AS `acris_cookie.cookieGroup.translation.description` , `acris_cookie.cookieGroup.translation` . created_at AS `acris_cookie.cookieGroup.translation.createdAt` , `acris_cookie.cookieGroup.translation` . updated_at AS `acris_cookie.cookieGroup.translation.updatedAt` , `acris_cookie.cookieGroup.translation` . acris_cookie_group_id AS `acris_cookie.cookieGroup.translation.acrisCookieGroupId` , `acris_cookie.cookieGroup.translation` . language_id AS `acris_cookie.cookieGroup.translation.languageId` FROM `acris_cookie_group_translation` `acris_cookie.cookieGroup.translation` WHERE `acris_cookie.cookieGroup.translation` . language_id = ? ) `acris_cookie.cookieGroup.acris_cookie_group_translation` ON `acris_cookie.cookieGroup.acris_cookie_group_translation` . `acris_cookie_group_id` = `acris_cookie.cookieGroup` . `id` WHERE (`acris_cookie` . `cookie_group_id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ÉÚøìÅsëº\x1C S\\x7F ;0¢\x01 ô?B¢┘q©ØÔa║\x11 o\x11 ╗\x01 •7T«\x1A pšµƒ “´\x11 Ev\x01 •7Wa“pw¡o„&ŠÊ¯\x07 \x02\x01 /7I█H!ñ\e ıu~(ÓÉ.;mS|5O\±Øäž~FÌt "
b"1+çßKvLlÇ~Ùÿìð\x1E 0 "
b"4wXñ┘\x08 L\x14 £SôÉ9ø\x18 ┴ "
b"<zì╦,ªGb║3«Ê#?=V "
b"='\x13\e ¨1B£–?\x19 ‚·Iœk "
b"TÜÔ~Ã┘G'üÀqyo─\x1C á "
b"[ƒ<à~FJÔ¬Pðªžk4\x05 "
b"""
Ø▓└ø\x7F £D.®\x19\x17 \n
x\x19 [─
"""
b"ÀõŽ`›³J¶ \x14 ·„iÕ‘} "
b"Ì_<-·¥ILˆ«§¶“\e oj "
b"┘{áÍ┐®EùØ\x05 Ù½┴\e O "
]
SELECT
`acris_cookie` . `id` AS `acris_cookie.id` ,
`acris_cookie` . `cookie_group_id` AS `acris_cookie.cookieGroupId` ,
`acris_cookie.cookieGroup` . `id` AS `acris_cookie.cookieGroup.id` ,
`acris_cookie.cookieGroup` . `is_default` AS `acris_cookie.cookieGroup.isDefault` ,
`acris_cookie.cookieGroup` . `identification` AS `acris_cookie.cookieGroup.identification` ,
`acris_cookie.cookieGroup` . `created_at` AS `acris_cookie.cookieGroup.createdAt` ,
`acris_cookie.cookieGroup` . `updated_at` AS `acris_cookie.cookieGroup.updatedAt` ,
`acris_cookie.cookieGroup.translation.title` ,
COALESCE (
`acris_cookie.cookieGroup.translation.title` ,
`acris_cookie.cookieGroup.translation.title`
) AS `acris_cookie.cookieGroup.title` ,
`acris_cookie.cookieGroup.translation.description` ,
COALESCE (
`acris_cookie.cookieGroup.translation.description` ,
`acris_cookie.cookieGroup.translation.description`
) AS `acris_cookie.cookieGroup.description` ,
`acris_cookie.cookieGroup.translation.createdAt` ,
`acris_cookie.cookieGroup.translation.updatedAt` ,
`acris_cookie.cookieGroup.translation.acrisCookieGroupId` ,
`acris_cookie.cookieGroup.translation.languageId` ,
`acris_cookie` . `cookie_id` AS `acris_cookie.cookieId` ,
`acris_cookie` . `google_cookie_consent_mode` AS `acris_cookie.googleCookieConsentMode` ,
`acris_cookie` . `default_value` AS `acris_cookie.defaultValue` ,
`acris_cookie` . `script_position` AS `acris_cookie.scriptPosition` ,
`acris_cookie` . `provider` AS `acris_cookie.provider` ,
`acris_cookie` . `active` AS `acris_cookie.active` ,
`acris_cookie` . `unknown` AS `acris_cookie.unknown` ,
`acris_cookie` . `is_default` AS `acris_cookie.isDefault` ,
`acris_cookie` . `created_at` AS `acris_cookie.createdAt` ,
`acris_cookie` . `updated_at` AS `acris_cookie.updatedAt` ,
(
SELECT
GROUP_CONCAT (
HEX (
`acris_cookie.salesChannels.mapping` . `sales_channel_id`
) SEPARATOR '||'
)
FROM
`acris_cookie_sales_channel` `acris_cookie.salesChannels.mapping`
WHERE
`acris_cookie.salesChannels.mapping` . `cookie_id` = `acris_cookie` . `id`
) AS `acris_cookie.salesChannels.id_mapping` ,
`acris_cookie.translation.title` ,
COALESCE (
`acris_cookie.translation.title` ,
`acris_cookie.translation.title`
) AS `acris_cookie.title` ,
`acris_cookie.translation.description` ,
COALESCE (
`acris_cookie.translation.description` ,
`acris_cookie.translation.description`
) AS `acris_cookie.description` ,
`acris_cookie.translation.script` ,
COALESCE (
`acris_cookie.translation.script` ,
`acris_cookie.translation.script`
) AS `acris_cookie.script` ,
`acris_cookie.translation.createdAt` ,
`acris_cookie.translation.updatedAt` ,
`acris_cookie.translation.acrisCookieId` ,
`acris_cookie.translation.languageId`
FROM
`acris_cookie`
LEFT JOIN `acris_cookie_group` `acris_cookie.cookieGroup` ON `acris_cookie` . `cookie_group_id` = `acris_cookie.cookieGroup` . `id`
LEFT JOIN (
SELECT
`acris_cookie.translation` . acris_cookie_id ,
`acris_cookie.translation` . title AS `acris_cookie.translation.title` ,
`acris_cookie.translation` . description AS `acris_cookie.translation.description` ,
`acris_cookie.translation` . script AS `acris_cookie.translation.script` ,
`acris_cookie.translation` . created_at AS `acris_cookie.translation.createdAt` ,
`acris_cookie.translation` . updated_at AS `acris_cookie.translation.updatedAt` ,
`acris_cookie.translation` . acris_cookie_id AS `acris_cookie.translation.acrisCookieId` ,
`acris_cookie.translation` . language_id AS `acris_cookie.translation.languageId`
FROM
`acris_cookie_translation` `acris_cookie.translation`
WHERE
`acris_cookie.translation` . language_id = ?
) `acris_cookie.acris_cookie_translation` ON `acris_cookie.acris_cookie_translation` . `acris_cookie_id` = `acris_cookie` . `id`
LEFT JOIN (
SELECT
`acris_cookie.cookieGroup.translation` . acris_cookie_group_id ,
`acris_cookie.cookieGroup.translation` . title AS `acris_cookie.cookieGroup.translation.title` ,
`acris_cookie.cookieGroup.translation` . description AS `acris_cookie.cookieGroup.translation.description` ,
`acris_cookie.cookieGroup.translation` . created_at AS `acris_cookie.cookieGroup.translation.createdAt` ,
`acris_cookie.cookieGroup.translation` . updated_at AS `acris_cookie.cookieGroup.translation.updatedAt` ,
`acris_cookie.cookieGroup.translation` . acris_cookie_group_id AS `acris_cookie.cookieGroup.translation.acrisCookieGroupId` ,
`acris_cookie.cookieGroup.translation` . language_id AS `acris_cookie.cookieGroup.translation.languageId`
FROM
`acris_cookie_group_translation` `acris_cookie.cookieGroup.translation`
WHERE
`acris_cookie.cookieGroup.translation` . language_id = ?
) `acris_cookie.cookieGroup.acris_cookie_group_translation` ON `acris_cookie.cookieGroup.acris_cookie_group_translation` . `acris_cookie_group_id` = `acris_cookie.cookieGroup` . `id`
WHERE
(
`acris_cookie` . `cookie_group_id` IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
)
)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` WHERE (`acris_cookie` . `cookie_group_id` IN (0x0190E99B8D8F7389A71C535C7F3B30BD , 0x01933F42BDD971B89DE261BA116F11BB , 0x01953754AB1A709AB5832093B4114576 , 0x0195375761937077A16F84268ACAAF07 , 0x02012F3749DB4821A41BD5757E28E090 , 0x2E3B6D537C354F5CB1D8E49E7E46CC74 , 0x312B87E14B764C6C807EEB988DD01E30 , 0x347758A4D9084C149C539390399B18C1 , 0x3C7A8DCB2CA64762BA33AED2233F3D56 , 0x3D27131BA83142A3963F1982B7499C6B , 0x549AE27EC7D9472781B771796FC41CA0 , 0x5B833CE07E464AD4AC50F0AA9E6B3405 , 0x9DB2C09B7F9C442EA919170A78195BC4 , 0xC0F58E609BB34AB6A014B78469D5917D , 0xCC5F3C2DB7A5494C88ABA7B6931B6F6A , 0xD97BA0D6BFA945979D05EBABC11B4F20 )); Copy
0.91 ms
4
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
0.90 ms
1
SELECT `neti_store_locator` . `id` AS `neti_store_locator.id` , `neti_store_locator` . `label` AS `neti_store_locator.label` , `neti_store_locator` . `street` AS `neti_store_locator.street` , `neti_store_locator` . `street_number` AS `neti_store_locator.streetNumber` , `neti_store_locator` . `zip_code` AS `neti_store_locator.zipCode` , `neti_store_locator` . `city` AS `neti_store_locator.city` , `neti_store_locator` . `address_hash` AS `neti_store_locator.addressHash` , `neti_store_locator` . `longitude` AS `neti_store_locator.longitude` , `neti_store_locator` . `latitude` AS `neti_store_locator.latitude` , `neti_store_locator` . `timezone` AS `neti_store_locator.timezone` , `neti_store_locator` . `phone` AS `neti_store_locator.phone` , `neti_store_locator` . `fax` AS `neti_store_locator.fax` , `neti_store_locator` . `url` AS `neti_store_locator.url` , `neti_store_locator` . `url_label` AS `neti_store_locator.urlLabel` , `neti_store_locator` . `email` AS `neti_store_locator.email` , `neti_store_locator` . `country_id` AS `neti_store_locator.countryId` , `neti_store_locator` . `country_state_id` AS `neti_store_locator.countryStateId` , `neti_store_locator` . `active` AS `neti_store_locator.active` , `neti_store_locator` . `contact_form_enabled` AS `neti_store_locator.contactFormEnabled` , `neti_store_locator` . `contact_form_detail` AS `neti_store_locator.contactFormDetail` , `neti_store_locator` . `hidden` AS `neti_store_locator.hidden` , `neti_store_locator` . `notification_email` AS `neti_store_locator.notificationMailAddress` , `neti_store_locator` . `show_always` AS `neti_store_locator.showAlways` , `neti_store_locator` . `zoom` AS `neti_store_locator.zoom` , `neti_store_locator` . `exclude_from_sync` AS `neti_store_locator.excludeFromSync` , `neti_store_locator` . `google_place_id` AS `neti_store_locator.googlePlaceID` , `neti_store_locator` . `featured` AS `neti_store_locator.featured` , `neti_store_locator` . `radius` AS `neti_store_locator.radius` , `neti_store_locator` . `detail_page_enabled` AS `neti_store_locator.detailPageEnabled` , `neti_store_locator` . `detail_content_type` AS `neti_store_locator.detailContentType` , `neti_store_locator` . `detail_in_sitemap` AS `neti_store_locator.detailInSitemap` , `neti_store_locator` . `picture_media_id` AS `neti_store_locator.pictureMediaId` , `neti_store_locator` . `details_picture_media_id` AS `neti_store_locator.detailsPictureMediaId` , `neti_store_locator` . `icon_media_id` AS `neti_store_locator.iconMediaId` , `neti_store_locator` . `external_id` AS `neti_store_locator.externalId` , `neti_store_locator` . `created_at` AS `neti_store_locator.createdAt` , `neti_store_locator` . `updated_at` AS `neti_store_locator.updatedAt` , `neti_store_locator.country` . `id` AS `neti_store_locator.country.id` , `neti_store_locator.country` . `iso` AS `neti_store_locator.country.iso` , `neti_store_locator.country` . `position` AS `neti_store_locator.country.position` , `neti_store_locator.country` . `active` AS `neti_store_locator.country.active` , `neti_store_locator.country` . `shipping_available` AS `neti_store_locator.country.shippingAvailable` , `neti_store_locator.country` . `iso3` AS `neti_store_locator.country.iso3` , `neti_store_locator.country` . `display_state_in_registration` AS `neti_store_locator.country.displayStateInRegistration` , `neti_store_locator.country` . `force_state_in_registration` AS `neti_store_locator.country.forceStateInRegistration` , `neti_store_locator.country` . `check_vat_id_pattern` AS `neti_store_locator.country.checkVatIdPattern` , `neti_store_locator.country` . `vat_id_required` AS `neti_store_locator.country.vatIdRequired` , `neti_store_locator.country` . `vat_id_pattern` AS `neti_store_locator.country.vatIdPattern` , `neti_store_locator.country` . `customer_tax` AS `neti_store_locator.country.customerTax` , `neti_store_locator.country` . `company_tax` AS `neti_store_locator.country.companyTax` , `neti_store_locator.country` . `postal_code_required` AS `neti_store_locator.country.postalCodeRequired` , `neti_store_locator.country` . `check_postal_code_pattern` AS `neti_store_locator.country.checkPostalCodePattern` , `neti_store_locator.country` . `check_advanced_postal_code_pattern` AS `neti_store_locator.country.checkAdvancedPostalCodePattern` , `neti_store_locator.country` . `advanced_postal_code_pattern` AS `neti_store_locator.country.advancedPostalCodePattern` , `neti_store_locator.country` . `default_postal_code_pattern` AS `neti_store_locator.country.defaultPostalCodePattern` , `neti_store_locator.country` . `created_at` AS `neti_store_locator.country.createdAt` , `neti_store_locator.country` . `updated_at` AS `neti_store_locator.country.updatedAt` , `neti_store_locator.country.translation.name` , COALESCE (`neti_store_locator.country.translation.name` , `neti_store_locator.country.translation.name` ) AS `neti_store_locator.country.name` , `neti_store_locator.country.translation.addressFormat` , COALESCE (`neti_store_locator.country.translation.addressFormat` , `neti_store_locator.country.translation.addressFormat` ) AS `neti_store_locator.country.addressFormat` , `neti_store_locator.country.translation.customFields` , COALESCE (`neti_store_locator.country.translation.customFields` , `neti_store_locator.country.translation.customFields` ) AS `neti_store_locator.country.customFields` , `neti_store_locator.country.translation.createdAt` , `neti_store_locator.country.translation.updatedAt` , `neti_store_locator.country.translation.countryId` , `neti_store_locator.country.translation.languageId` , `neti_store_locator.translation.description` , COALESCE (`neti_store_locator.translation.description` , `neti_store_locator.translation.description` ) AS `neti_store_locator.description` , `neti_store_locator.translation.additionalInformation` , COALESCE (`neti_store_locator.translation.additionalInformation` , `neti_store_locator.translation.additionalInformation` ) AS `neti_store_locator.additionalInformation` , `neti_store_locator.translation.seoTitle` , COALESCE (`neti_store_locator.translation.seoTitle` , `neti_store_locator.translation.seoTitle` ) AS `neti_store_locator.seoTitle` , `neti_store_locator.translation.seoUrl` , COALESCE (`neti_store_locator.translation.seoUrl` , `neti_store_locator.translation.seoUrl` ) AS `neti_store_locator.seoUrl` , `neti_store_locator.translation.seoDescription` , COALESCE (`neti_store_locator.translation.seoDescription` , `neti_store_locator.translation.seoDescription` ) AS `neti_store_locator.seoDescription` , `neti_store_locator.translation.detailTitle` , COALESCE (`neti_store_locator.translation.detailTitle` , `neti_store_locator.translation.detailTitle` ) AS `neti_store_locator.detailTitle` , `neti_store_locator.translation.detailDescription` , COALESCE (`neti_store_locator.translation.detailDescription` , `neti_store_locator.translation.detailDescription` ) AS `neti_store_locator.detailDescription` , `neti_store_locator.translation.openingTimes` , COALESCE (`neti_store_locator.translation.openingTimes` , `neti_store_locator.translation.openingTimes` ) AS `neti_store_locator.openingTimes` , `neti_store_locator.translation.customFields` , COALESCE (`neti_store_locator.translation.customFields` , `neti_store_locator.translation.customFields` ) AS `neti_store_locator.customFields` , `neti_store_locator.translation.createdAt` , `neti_store_locator.translation.updatedAt` , `neti_store_locator.translation.netiStoreLocatorId` , `neti_store_locator.translation.languageId` FROM `neti_store_locator` LEFT JOIN (SELECT `neti_store_locator.translation` . neti_store_locator_id , `neti_store_locator.translation` . description AS `neti_store_locator.translation.description` , `neti_store_locator.translation` . additional_information AS `neti_store_locator.translation.additionalInformation` , `neti_store_locator.translation` . seo_title AS `neti_store_locator.translation.seoTitle` , `neti_store_locator.translation` . seo_url AS `neti_store_locator.translation.seoUrl` , `neti_store_locator.translation` . seo_description AS `neti_store_locator.translation.seoDescription` , `neti_store_locator.translation` . detail_title AS `neti_store_locator.translation.detailTitle` , `neti_store_locator.translation` . detail_description AS `neti_store_locator.translation.detailDescription` , `neti_store_locator.translation` . opening_times AS `neti_store_locator.translation.openingTimes` , `neti_store_locator.translation` . custom_fields AS `neti_store_locator.translation.customFields` , `neti_store_locator.translation` . created_at AS `neti_store_locator.translation.createdAt` , `neti_store_locator.translation` . updated_at AS `neti_store_locator.translation.updatedAt` , `neti_store_locator.translation` . neti_store_locator_id AS `neti_store_locator.translation.netiStoreLocatorId` , `neti_store_locator.translation` . language_id AS `neti_store_locator.translation.languageId` FROM `neti_store_locator_translation` `neti_store_locator.translation` WHERE `neti_store_locator.translation` . language_id = ? ) `neti_store_locator.neti_store_locator_translation` ON `neti_store_locator.neti_store_locator_translation` . `neti_store_locator_id` = `neti_store_locator` . `id` LEFT JOIN `country` `neti_store_locator.country` ON `neti_store_locator` . `country_id` = `neti_store_locator.country` . `id` LEFT JOIN (SELECT `neti_store_locator.country.translation` . country_id , `neti_store_locator.country.translation` . name AS `neti_store_locator.country.translation.name` , `neti_store_locator.country.translation` . address_format AS `neti_store_locator.country.translation.addressFormat` , `neti_store_locator.country.translation` . custom_fields AS `neti_store_locator.country.translation.customFields` , `neti_store_locator.country.translation` . created_at AS `neti_store_locator.country.translation.createdAt` , `neti_store_locator.country.translation` . updated_at AS `neti_store_locator.country.translation.updatedAt` , `neti_store_locator.country.translation` . country_id AS `neti_store_locator.country.translation.countryId` , `neti_store_locator.country.translation` . language_id AS `neti_store_locator.country.translation.languageId` FROM `country_translation` `neti_store_locator.country.translation` WHERE `neti_store_locator.country.translation` . language_id = ? ) `neti_store_locator.country.country_translation` ON `neti_store_locator.country.country_translation` . `country_id` = `neti_store_locator.country` . `id` WHERE `neti_store_locator` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x00 \r ‰\8\BN†™°¯\x03 h\x0F\e ]
SELECT
`neti_store_locator` . `id` AS `neti_store_locator.id` ,
`neti_store_locator` . `label` AS `neti_store_locator.label` ,
`neti_store_locator` . `street` AS `neti_store_locator.street` ,
`neti_store_locator` . `street_number` AS `neti_store_locator.streetNumber` ,
`neti_store_locator` . `zip_code` AS `neti_store_locator.zipCode` ,
`neti_store_locator` . `city` AS `neti_store_locator.city` ,
`neti_store_locator` . `address_hash` AS `neti_store_locator.addressHash` ,
`neti_store_locator` . `longitude` AS `neti_store_locator.longitude` ,
`neti_store_locator` . `latitude` AS `neti_store_locator.latitude` ,
`neti_store_locator` . `timezone` AS `neti_store_locator.timezone` ,
`neti_store_locator` . `phone` AS `neti_store_locator.phone` ,
`neti_store_locator` . `fax` AS `neti_store_locator.fax` ,
`neti_store_locator` . `url` AS `neti_store_locator.url` ,
`neti_store_locator` . `url_label` AS `neti_store_locator.urlLabel` ,
`neti_store_locator` . `email` AS `neti_store_locator.email` ,
`neti_store_locator` . `country_id` AS `neti_store_locator.countryId` ,
`neti_store_locator` . `country_state_id` AS `neti_store_locator.countryStateId` ,
`neti_store_locator` . `active` AS `neti_store_locator.active` ,
`neti_store_locator` . `contact_form_enabled` AS `neti_store_locator.contactFormEnabled` ,
`neti_store_locator` . `contact_form_detail` AS `neti_store_locator.contactFormDetail` ,
`neti_store_locator` . `hidden` AS `neti_store_locator.hidden` ,
`neti_store_locator` . `notification_email` AS `neti_store_locator.notificationMailAddress` ,
`neti_store_locator` . `show_always` AS `neti_store_locator.showAlways` ,
`neti_store_locator` . `zoom` AS `neti_store_locator.zoom` ,
`neti_store_locator` . `exclude_from_sync` AS `neti_store_locator.excludeFromSync` ,
`neti_store_locator` . `google_place_id` AS `neti_store_locator.googlePlaceID` ,
`neti_store_locator` . `featured` AS `neti_store_locator.featured` ,
`neti_store_locator` . `radius` AS `neti_store_locator.radius` ,
`neti_store_locator` . `detail_page_enabled` AS `neti_store_locator.detailPageEnabled` ,
`neti_store_locator` . `detail_content_type` AS `neti_store_locator.detailContentType` ,
`neti_store_locator` . `detail_in_sitemap` AS `neti_store_locator.detailInSitemap` ,
`neti_store_locator` . `picture_media_id` AS `neti_store_locator.pictureMediaId` ,
`neti_store_locator` . `details_picture_media_id` AS `neti_store_locator.detailsPictureMediaId` ,
`neti_store_locator` . `icon_media_id` AS `neti_store_locator.iconMediaId` ,
`neti_store_locator` . `external_id` AS `neti_store_locator.externalId` ,
`neti_store_locator` . `created_at` AS `neti_store_locator.createdAt` ,
`neti_store_locator` . `updated_at` AS `neti_store_locator.updatedAt` ,
`neti_store_locator.country` . `id` AS `neti_store_locator.country.id` ,
`neti_store_locator.country` . `iso` AS `neti_store_locator.country.iso` ,
`neti_store_locator.country` . `position` AS `neti_store_locator.country.position` ,
`neti_store_locator.country` . `active` AS `neti_store_locator.country.active` ,
`neti_store_locator.country` . `shipping_available` AS `neti_store_locator.country.shippingAvailable` ,
`neti_store_locator.country` . `iso3` AS `neti_store_locator.country.iso3` ,
`neti_store_locator.country` . `display_state_in_registration` AS `neti_store_locator.country.displayStateInRegistration` ,
`neti_store_locator.country` . `force_state_in_registration` AS `neti_store_locator.country.forceStateInRegistration` ,
`neti_store_locator.country` . `check_vat_id_pattern` AS `neti_store_locator.country.checkVatIdPattern` ,
`neti_store_locator.country` . `vat_id_required` AS `neti_store_locator.country.vatIdRequired` ,
`neti_store_locator.country` . `vat_id_pattern` AS `neti_store_locator.country.vatIdPattern` ,
`neti_store_locator.country` . `customer_tax` AS `neti_store_locator.country.customerTax` ,
`neti_store_locator.country` . `company_tax` AS `neti_store_locator.country.companyTax` ,
`neti_store_locator.country` . `postal_code_required` AS `neti_store_locator.country.postalCodeRequired` ,
`neti_store_locator.country` . `check_postal_code_pattern` AS `neti_store_locator.country.checkPostalCodePattern` ,
`neti_store_locator.country` . `check_advanced_postal_code_pattern` AS `neti_store_locator.country.checkAdvancedPostalCodePattern` ,
`neti_store_locator.country` . `advanced_postal_code_pattern` AS `neti_store_locator.country.advancedPostalCodePattern` ,
`neti_store_locator.country` . `default_postal_code_pattern` AS `neti_store_locator.country.defaultPostalCodePattern` ,
`neti_store_locator.country` . `created_at` AS `neti_store_locator.country.createdAt` ,
`neti_store_locator.country` . `updated_at` AS `neti_store_locator.country.updatedAt` ,
`neti_store_locator.country.translation.name` ,
COALESCE (
`neti_store_locator.country.translation.name` ,
`neti_store_locator.country.translation.name`
) AS `neti_store_locator.country.name` ,
`neti_store_locator.country.translation.addressFormat` ,
COALESCE (
`neti_store_locator.country.translation.addressFormat` ,
`neti_store_locator.country.translation.addressFormat`
) AS `neti_store_locator.country.addressFormat` ,
`neti_store_locator.country.translation.customFields` ,
COALESCE (
`neti_store_locator.country.translation.customFields` ,
`neti_store_locator.country.translation.customFields`
) AS `neti_store_locator.country.customFields` ,
`neti_store_locator.country.translation.createdAt` ,
`neti_store_locator.country.translation.updatedAt` ,
`neti_store_locator.country.translation.countryId` ,
`neti_store_locator.country.translation.languageId` ,
`neti_store_locator.translation.description` ,
COALESCE (
`neti_store_locator.translation.description` ,
`neti_store_locator.translation.description`
) AS `neti_store_locator.description` ,
`neti_store_locator.translation.additionalInformation` ,
COALESCE (
`neti_store_locator.translation.additionalInformation` ,
`neti_store_locator.translation.additionalInformation`
) AS `neti_store_locator.additionalInformation` ,
`neti_store_locator.translation.seoTitle` ,
COALESCE (
`neti_store_locator.translation.seoTitle` ,
`neti_store_locator.translation.seoTitle`
) AS `neti_store_locator.seoTitle` ,
`neti_store_locator.translation.seoUrl` ,
COALESCE (
`neti_store_locator.translation.seoUrl` ,
`neti_store_locator.translation.seoUrl`
) AS `neti_store_locator.seoUrl` ,
`neti_store_locator.translation.seoDescription` ,
COALESCE (
`neti_store_locator.translation.seoDescription` ,
`neti_store_locator.translation.seoDescription`
) AS `neti_store_locator.seoDescription` ,
`neti_store_locator.translation.detailTitle` ,
COALESCE (
`neti_store_locator.translation.detailTitle` ,
`neti_store_locator.translation.detailTitle`
) AS `neti_store_locator.detailTitle` ,
`neti_store_locator.translation.detailDescription` ,
COALESCE (
`neti_store_locator.translation.detailDescription` ,
`neti_store_locator.translation.detailDescription`
) AS `neti_store_locator.detailDescription` ,
`neti_store_locator.translation.openingTimes` ,
COALESCE (
`neti_store_locator.translation.openingTimes` ,
`neti_store_locator.translation.openingTimes`
) AS `neti_store_locator.openingTimes` ,
`neti_store_locator.translation.customFields` ,
COALESCE (
`neti_store_locator.translation.customFields` ,
`neti_store_locator.translation.customFields`
) AS `neti_store_locator.customFields` ,
`neti_store_locator.translation.createdAt` ,
`neti_store_locator.translation.updatedAt` ,
`neti_store_locator.translation.netiStoreLocatorId` ,
`neti_store_locator.translation.languageId`
FROM
`neti_store_locator`
LEFT JOIN (
SELECT
`neti_store_locator.translation` . neti_store_locator_id ,
`neti_store_locator.translation` . description AS `neti_store_locator.translation.description` ,
`neti_store_locator.translation` . additional_information AS `neti_store_locator.translation.additionalInformation` ,
`neti_store_locator.translation` . seo_title AS `neti_store_locator.translation.seoTitle` ,
`neti_store_locator.translation` . seo_url AS `neti_store_locator.translation.seoUrl` ,
`neti_store_locator.translation` . seo_description AS `neti_store_locator.translation.seoDescription` ,
`neti_store_locator.translation` . detail_title AS `neti_store_locator.translation.detailTitle` ,
`neti_store_locator.translation` . detail_description AS `neti_store_locator.translation.detailDescription` ,
`neti_store_locator.translation` . opening_times AS `neti_store_locator.translation.openingTimes` ,
`neti_store_locator.translation` . custom_fields AS `neti_store_locator.translation.customFields` ,
`neti_store_locator.translation` . created_at AS `neti_store_locator.translation.createdAt` ,
`neti_store_locator.translation` . updated_at AS `neti_store_locator.translation.updatedAt` ,
`neti_store_locator.translation` . neti_store_locator_id AS `neti_store_locator.translation.netiStoreLocatorId` ,
`neti_store_locator.translation` . language_id AS `neti_store_locator.translation.languageId`
FROM
`neti_store_locator_translation` `neti_store_locator.translation`
WHERE
`neti_store_locator.translation` . language_id = ?
) `neti_store_locator.neti_store_locator_translation` ON `neti_store_locator.neti_store_locator_translation` . `neti_store_locator_id` = `neti_store_locator` . `id`
LEFT JOIN `country` `neti_store_locator.country` ON `neti_store_locator` . `country_id` = `neti_store_locator.country` . `id`
LEFT JOIN (
SELECT
`neti_store_locator.country.translation` . country_id ,
`neti_store_locator.country.translation` . name AS `neti_store_locator.country.translation.name` ,
`neti_store_locator.country.translation` . address_format AS `neti_store_locator.country.translation.addressFormat` ,
`neti_store_locator.country.translation` . custom_fields AS `neti_store_locator.country.translation.customFields` ,
`neti_store_locator.country.translation` . created_at AS `neti_store_locator.country.translation.createdAt` ,
`neti_store_locator.country.translation` . updated_at AS `neti_store_locator.country.translation.updatedAt` ,
`neti_store_locator.country.translation` . country_id AS `neti_store_locator.country.translation.countryId` ,
`neti_store_locator.country.translation` . language_id AS `neti_store_locator.country.translation.languageId`
FROM
`country_translation` `neti_store_locator.country.translation`
WHERE
`neti_store_locator.country.translation` . language_id = ?
) `neti_store_locator.country.country_translation` ON `neti_store_locator.country.country_translation` . `country_id` = `neti_store_locator.country` . `id`
WHERE
`neti_store_locator` . `id` IN (? )Copy
SELECT `neti_store_locator` . `id` AS `neti_store_locator.id` , `neti_store_locator` . `label` AS `neti_store_locator.label` , `neti_store_locator` . `street` AS `neti_store_locator.street` , `neti_store_locator` . `street_number` AS `neti_store_locator.streetNumber` , `neti_store_locator` . `zip_code` AS `neti_store_locator.zipCode` , `neti_store_locator` . `city` AS `neti_store_locator.city` , `neti_store_locator` . `address_hash` AS `neti_store_locator.addressHash` , `neti_store_locator` . `longitude` AS `neti_store_locator.longitude` , `neti_store_locator` . `latitude` AS `neti_store_locator.latitude` , `neti_store_locator` . `timezone` AS `neti_store_locator.timezone` , `neti_store_locator` . `phone` AS `neti_store_locator.phone` , `neti_store_locator` . `fax` AS `neti_store_locator.fax` , `neti_store_locator` . `url` AS `neti_store_locator.url` , `neti_store_locator` . `url_label` AS `neti_store_locator.urlLabel` , `neti_store_locator` . `email` AS `neti_store_locator.email` , `neti_store_locator` . `country_id` AS `neti_store_locator.countryId` , `neti_store_locator` . `country_state_id` AS `neti_store_locator.countryStateId` , `neti_store_locator` . `active` AS `neti_store_locator.active` , `neti_store_locator` . `contact_form_enabled` AS `neti_store_locator.contactFormEnabled` , `neti_store_locator` . `contact_form_detail` AS `neti_store_locator.contactFormDetail` , `neti_store_locator` . `hidden` AS `neti_store_locator.hidden` , `neti_store_locator` . `notification_email` AS `neti_store_locator.notificationMailAddress` , `neti_store_locator` . `show_always` AS `neti_store_locator.showAlways` , `neti_store_locator` . `zoom` AS `neti_store_locator.zoom` , `neti_store_locator` . `exclude_from_sync` AS `neti_store_locator.excludeFromSync` , `neti_store_locator` . `google_place_id` AS `neti_store_locator.googlePlaceID` , `neti_store_locator` . `featured` AS `neti_store_locator.featured` , `neti_store_locator` . `radius` AS `neti_store_locator.radius` , `neti_store_locator` . `detail_page_enabled` AS `neti_store_locator.detailPageEnabled` , `neti_store_locator` . `detail_content_type` AS `neti_store_locator.detailContentType` , `neti_store_locator` . `detail_in_sitemap` AS `neti_store_locator.detailInSitemap` , `neti_store_locator` . `picture_media_id` AS `neti_store_locator.pictureMediaId` , `neti_store_locator` . `details_picture_media_id` AS `neti_store_locator.detailsPictureMediaId` , `neti_store_locator` . `icon_media_id` AS `neti_store_locator.iconMediaId` , `neti_store_locator` . `external_id` AS `neti_store_locator.externalId` , `neti_store_locator` . `created_at` AS `neti_store_locator.createdAt` , `neti_store_locator` . `updated_at` AS `neti_store_locator.updatedAt` , `neti_store_locator.country` . `id` AS `neti_store_locator.country.id` , `neti_store_locator.country` . `iso` AS `neti_store_locator.country.iso` , `neti_store_locator.country` . `position` AS `neti_store_locator.country.position` , `neti_store_locator.country` . `active` AS `neti_store_locator.country.active` , `neti_store_locator.country` . `shipping_available` AS `neti_store_locator.country.shippingAvailable` , `neti_store_locator.country` . `iso3` AS `neti_store_locator.country.iso3` , `neti_store_locator.country` . `display_state_in_registration` AS `neti_store_locator.country.displayStateInRegistration` , `neti_store_locator.country` . `force_state_in_registration` AS `neti_store_locator.country.forceStateInRegistration` , `neti_store_locator.country` . `check_vat_id_pattern` AS `neti_store_locator.country.checkVatIdPattern` , `neti_store_locator.country` . `vat_id_required` AS `neti_store_locator.country.vatIdRequired` , `neti_store_locator.country` . `vat_id_pattern` AS `neti_store_locator.country.vatIdPattern` , `neti_store_locator.country` . `customer_tax` AS `neti_store_locator.country.customerTax` , `neti_store_locator.country` . `company_tax` AS `neti_store_locator.country.companyTax` , `neti_store_locator.country` . `postal_code_required` AS `neti_store_locator.country.postalCodeRequired` , `neti_store_locator.country` . `check_postal_code_pattern` AS `neti_store_locator.country.checkPostalCodePattern` , `neti_store_locator.country` . `check_advanced_postal_code_pattern` AS `neti_store_locator.country.checkAdvancedPostalCodePattern` , `neti_store_locator.country` . `advanced_postal_code_pattern` AS `neti_store_locator.country.advancedPostalCodePattern` , `neti_store_locator.country` . `default_postal_code_pattern` AS `neti_store_locator.country.defaultPostalCodePattern` , `neti_store_locator.country` . `created_at` AS `neti_store_locator.country.createdAt` , `neti_store_locator.country` . `updated_at` AS `neti_store_locator.country.updatedAt` , `neti_store_locator.country.translation.name` , COALESCE (`neti_store_locator.country.translation.name` , `neti_store_locator.country.translation.name` ) AS `neti_store_locator.country.name` , `neti_store_locator.country.translation.addressFormat` , COALESCE (`neti_store_locator.country.translation.addressFormat` , `neti_store_locator.country.translation.addressFormat` ) AS `neti_store_locator.country.addressFormat` , `neti_store_locator.country.translation.customFields` , COALESCE (`neti_store_locator.country.translation.customFields` , `neti_store_locator.country.translation.customFields` ) AS `neti_store_locator.country.customFields` , `neti_store_locator.country.translation.createdAt` , `neti_store_locator.country.translation.updatedAt` , `neti_store_locator.country.translation.countryId` , `neti_store_locator.country.translation.languageId` , `neti_store_locator.translation.description` , COALESCE (`neti_store_locator.translation.description` , `neti_store_locator.translation.description` ) AS `neti_store_locator.description` , `neti_store_locator.translation.additionalInformation` , COALESCE (`neti_store_locator.translation.additionalInformation` , `neti_store_locator.translation.additionalInformation` ) AS `neti_store_locator.additionalInformation` , `neti_store_locator.translation.seoTitle` , COALESCE (`neti_store_locator.translation.seoTitle` , `neti_store_locator.translation.seoTitle` ) AS `neti_store_locator.seoTitle` , `neti_store_locator.translation.seoUrl` , COALESCE (`neti_store_locator.translation.seoUrl` , `neti_store_locator.translation.seoUrl` ) AS `neti_store_locator.seoUrl` , `neti_store_locator.translation.seoDescription` , COALESCE (`neti_store_locator.translation.seoDescription` , `neti_store_locator.translation.seoDescription` ) AS `neti_store_locator.seoDescription` , `neti_store_locator.translation.detailTitle` , COALESCE (`neti_store_locator.translation.detailTitle` , `neti_store_locator.translation.detailTitle` ) AS `neti_store_locator.detailTitle` , `neti_store_locator.translation.detailDescription` , COALESCE (`neti_store_locator.translation.detailDescription` , `neti_store_locator.translation.detailDescription` ) AS `neti_store_locator.detailDescription` , `neti_store_locator.translation.openingTimes` , COALESCE (`neti_store_locator.translation.openingTimes` , `neti_store_locator.translation.openingTimes` ) AS `neti_store_locator.openingTimes` , `neti_store_locator.translation.customFields` , COALESCE (`neti_store_locator.translation.customFields` , `neti_store_locator.translation.customFields` ) AS `neti_store_locator.customFields` , `neti_store_locator.translation.createdAt` , `neti_store_locator.translation.updatedAt` , `neti_store_locator.translation.netiStoreLocatorId` , `neti_store_locator.translation.languageId` FROM `neti_store_locator` LEFT JOIN (SELECT `neti_store_locator.translation` . neti_store_locator_id , `neti_store_locator.translation` . description AS `neti_store_locator.translation.description` , `neti_store_locator.translation` . additional_information AS `neti_store_locator.translation.additionalInformation` , `neti_store_locator.translation` . seo_title AS `neti_store_locator.translation.seoTitle` , `neti_store_locator.translation` . seo_url AS `neti_store_locator.translation.seoUrl` , `neti_store_locator.translation` . seo_description AS `neti_store_locator.translation.seoDescription` , `neti_store_locator.translation` . detail_title AS `neti_store_locator.translation.detailTitle` , `neti_store_locator.translation` . detail_description AS `neti_store_locator.translation.detailDescription` , `neti_store_locator.translation` . opening_times AS `neti_store_locator.translation.openingTimes` , `neti_store_locator.translation` . custom_fields AS `neti_store_locator.translation.customFields` , `neti_store_locator.translation` . created_at AS `neti_store_locator.translation.createdAt` , `neti_store_locator.translation` . updated_at AS `neti_store_locator.translation.updatedAt` , `neti_store_locator.translation` . neti_store_locator_id AS `neti_store_locator.translation.netiStoreLocatorId` , `neti_store_locator.translation` . language_id AS `neti_store_locator.translation.languageId` FROM `neti_store_locator_translation` `neti_store_locator.translation` WHERE `neti_store_locator.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `neti_store_locator.neti_store_locator_translation` ON `neti_store_locator.neti_store_locator_translation` . `neti_store_locator_id` = `neti_store_locator` . `id` LEFT JOIN `country` `neti_store_locator.country` ON `neti_store_locator` . `country_id` = `neti_store_locator.country` . `id` LEFT JOIN (SELECT `neti_store_locator.country.translation` . country_id , `neti_store_locator.country.translation` . name AS `neti_store_locator.country.translation.name` , `neti_store_locator.country.translation` . address_format AS `neti_store_locator.country.translation.addressFormat` , `neti_store_locator.country.translation` . custom_fields AS `neti_store_locator.country.translation.customFields` , `neti_store_locator.country.translation` . created_at AS `neti_store_locator.country.translation.createdAt` , `neti_store_locator.country.translation` . updated_at AS `neti_store_locator.country.translation.updatedAt` , `neti_store_locator.country.translation` . country_id AS `neti_store_locator.country.translation.countryId` , `neti_store_locator.country.translation` . language_id AS `neti_store_locator.country.translation.languageId` FROM `country_translation` `neti_store_locator.country.translation` WHERE `neti_store_locator.country.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `neti_store_locator.country.country_translation` ON `neti_store_locator.country.country_translation` . `country_id` = `neti_store_locator.country` . `id` WHERE `neti_store_locator` . `id` IN (0x000D895C385C424E8699B0AF03680F1B ); Copy
0.80 ms
4
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = ? )
SELECT `app` . `id` FROM `app` WHERE (`app` . `active` = 1 );
Copy
0.70 ms
4
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
0.62 ms
1
SELECT `plugin` . `id` AS `plugin.id` , `plugin` . `base_class` AS `plugin.baseClass` , `plugin` . `name` AS `plugin.name` , `plugin` . `composer_name` AS `plugin.composerName` , `plugin` . `autoload` AS `plugin.autoload` , `plugin` . `active` AS `plugin.active` , `plugin` . `managed_by_composer` AS `plugin.managedByComposer` , `plugin` . `path` AS `plugin.path` , `plugin` . `author` AS `plugin.author` , `plugin` . `copyright` AS `plugin.copyright` , `plugin` . `license` AS `plugin.license` , `plugin` . `version` AS `plugin.version` , `plugin` . `upgrade_version` AS `plugin.upgradeVersion` , `plugin` . `installed_at` AS `plugin.installedAt` , `plugin` . `upgraded_at` AS `plugin.upgradedAt` , `plugin` . `icon` AS `plugin.iconRaw` , `plugin` . `created_at` AS `plugin.createdAt` , `plugin` . `updated_at` AS `plugin.updatedAt` , `plugin.translation.label` , COALESCE (`plugin.translation.label` , `plugin.translation.label` ) AS `plugin.label` , `plugin.translation.description` , COALESCE (`plugin.translation.description` , `plugin.translation.description` ) AS `plugin.description` , `plugin.translation.manufacturerLink` , COALESCE (`plugin.translation.manufacturerLink` , `plugin.translation.manufacturerLink` ) AS `plugin.manufacturerLink` , `plugin.translation.supportLink` , COALESCE (`plugin.translation.supportLink` , `plugin.translation.supportLink` ) AS `plugin.supportLink` , `plugin.translation.customFields` , COALESCE (`plugin.translation.customFields` , `plugin.translation.customFields` ) AS `plugin.customFields` , `plugin.translation.createdAt` , `plugin.translation.updatedAt` , `plugin.translation.pluginId` , `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation` . plugin_id , `plugin.translation` . label AS `plugin.translation.label` , `plugin.translation` . description AS `plugin.translation.description` , `plugin.translation` . manufacturer_link AS `plugin.translation.manufacturerLink` , `plugin.translation` . support_link AS `plugin.translation.supportLink` , `plugin.translation` . custom_fields AS `plugin.translation.customFields` , `plugin.translation` . created_at AS `plugin.translation.createdAt` , `plugin.translation` . updated_at AS `plugin.translation.updatedAt` , `plugin.translation` . plugin_id AS `plugin.translation.pluginId` , `plugin.translation` . language_id AS `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation` . language_id = ? ) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id` WHERE (`plugin` . `name` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
"NetiNextStorePickup "
]
SELECT
`plugin` . `id` AS `plugin.id` ,
`plugin` . `base_class` AS `plugin.baseClass` ,
`plugin` . `name` AS `plugin.name` ,
`plugin` . `composer_name` AS `plugin.composerName` ,
`plugin` . `autoload` AS `plugin.autoload` ,
`plugin` . `active` AS `plugin.active` ,
`plugin` . `managed_by_composer` AS `plugin.managedByComposer` ,
`plugin` . `path` AS `plugin.path` ,
`plugin` . `author` AS `plugin.author` ,
`plugin` . `copyright` AS `plugin.copyright` ,
`plugin` . `license` AS `plugin.license` ,
`plugin` . `version` AS `plugin.version` ,
`plugin` . `upgrade_version` AS `plugin.upgradeVersion` ,
`plugin` . `installed_at` AS `plugin.installedAt` ,
`plugin` . `upgraded_at` AS `plugin.upgradedAt` ,
`plugin` . `icon` AS `plugin.iconRaw` ,
`plugin` . `created_at` AS `plugin.createdAt` ,
`plugin` . `updated_at` AS `plugin.updatedAt` ,
`plugin.translation.label` ,
COALESCE (
`plugin.translation.label` , `plugin.translation.label`
) AS `plugin.label` ,
`plugin.translation.description` ,
COALESCE (
`plugin.translation.description` ,
`plugin.translation.description`
) AS `plugin.description` ,
`plugin.translation.manufacturerLink` ,
COALESCE (
`plugin.translation.manufacturerLink` ,
`plugin.translation.manufacturerLink`
) AS `plugin.manufacturerLink` ,
`plugin.translation.supportLink` ,
COALESCE (
`plugin.translation.supportLink` ,
`plugin.translation.supportLink`
) AS `plugin.supportLink` ,
`plugin.translation.customFields` ,
COALESCE (
`plugin.translation.customFields` ,
`plugin.translation.customFields`
) AS `plugin.customFields` ,
`plugin.translation.createdAt` ,
`plugin.translation.updatedAt` ,
`plugin.translation.pluginId` ,
`plugin.translation.languageId`
FROM
`plugin`
LEFT JOIN (
SELECT
`plugin.translation` . plugin_id ,
`plugin.translation` . label AS `plugin.translation.label` ,
`plugin.translation` . description AS `plugin.translation.description` ,
`plugin.translation` . manufacturer_link AS `plugin.translation.manufacturerLink` ,
`plugin.translation` . support_link AS `plugin.translation.supportLink` ,
`plugin.translation` . custom_fields AS `plugin.translation.customFields` ,
`plugin.translation` . created_at AS `plugin.translation.createdAt` ,
`plugin.translation` . updated_at AS `plugin.translation.updatedAt` ,
`plugin.translation` . plugin_id AS `plugin.translation.pluginId` ,
`plugin.translation` . language_id AS `plugin.translation.languageId`
FROM
`plugin_translation` `plugin.translation`
WHERE
`plugin.translation` . language_id = ?
) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id`
WHERE
(`plugin` . `name` = ? )Copy
SELECT `plugin` . `id` AS `plugin.id` , `plugin` . `base_class` AS `plugin.baseClass` , `plugin` . `name` AS `plugin.name` , `plugin` . `composer_name` AS `plugin.composerName` , `plugin` . `autoload` AS `plugin.autoload` , `plugin` . `active` AS `plugin.active` , `plugin` . `managed_by_composer` AS `plugin.managedByComposer` , `plugin` . `path` AS `plugin.path` , `plugin` . `author` AS `plugin.author` , `plugin` . `copyright` AS `plugin.copyright` , `plugin` . `license` AS `plugin.license` , `plugin` . `version` AS `plugin.version` , `plugin` . `upgrade_version` AS `plugin.upgradeVersion` , `plugin` . `installed_at` AS `plugin.installedAt` , `plugin` . `upgraded_at` AS `plugin.upgradedAt` , `plugin` . `icon` AS `plugin.iconRaw` , `plugin` . `created_at` AS `plugin.createdAt` , `plugin` . `updated_at` AS `plugin.updatedAt` , `plugin.translation.label` , COALESCE (`plugin.translation.label` , `plugin.translation.label` ) AS `plugin.label` , `plugin.translation.description` , COALESCE (`plugin.translation.description` , `plugin.translation.description` ) AS `plugin.description` , `plugin.translation.manufacturerLink` , COALESCE (`plugin.translation.manufacturerLink` , `plugin.translation.manufacturerLink` ) AS `plugin.manufacturerLink` , `plugin.translation.supportLink` , COALESCE (`plugin.translation.supportLink` , `plugin.translation.supportLink` ) AS `plugin.supportLink` , `plugin.translation.customFields` , COALESCE (`plugin.translation.customFields` , `plugin.translation.customFields` ) AS `plugin.customFields` , `plugin.translation.createdAt` , `plugin.translation.updatedAt` , `plugin.translation.pluginId` , `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation` . plugin_id , `plugin.translation` . label AS `plugin.translation.label` , `plugin.translation` . description AS `plugin.translation.description` , `plugin.translation` . manufacturer_link AS `plugin.translation.manufacturerLink` , `plugin.translation` . support_link AS `plugin.translation.supportLink` , `plugin.translation` . custom_fields AS `plugin.translation.customFields` , `plugin.translation` . created_at AS `plugin.translation.createdAt` , `plugin.translation` . updated_at AS `plugin.translation.updatedAt` , `plugin.translation` . plugin_id AS `plugin.translation.pluginId` , `plugin.translation` . language_id AS `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `plugin.plugin_translation` ON `plugin.plugin_translation` . `plugin_id` = `plugin` . `id` WHERE (`plugin` . `name` = 'NetiNextStorePickup' ); Copy
0.61 ms
1
SELECT `sales_channel_domain` . `id` AS `sales_channel_domain.id` , `sales_channel_domain` . `url` AS `sales_channel_domain.url` , `sales_channel_domain` . `sales_channel_id` AS `sales_channel_domain.salesChannelId` , `sales_channel_domain` . `language_id` AS `sales_channel_domain.languageId` , `sales_channel_domain` . `currency_id` AS `sales_channel_domain.currencyId` , `sales_channel_domain` . `snippet_set_id` AS `sales_channel_domain.snippetSetId` , `sales_channel_domain` . `hreflang_use_only_locale` AS `sales_channel_domain.hreflangUseOnlyLocale` , `sales_channel_domain` . `custom_fields` AS `sales_channel_domain.customFields` , `sales_channel_domain` . `created_at` AS `sales_channel_domain.createdAt` , `sales_channel_domain` . `updated_at` AS `sales_channel_domain.updatedAt` , `sales_channel_domain.language` . `id` AS `sales_channel_domain.language.id` , `sales_channel_domain.language` . `parent_id` AS `sales_channel_domain.language.parentId` , `sales_channel_domain.language` . `locale_id` AS `sales_channel_domain.language.localeId` , `sales_channel_domain.language` . `translation_code_id` AS `sales_channel_domain.language.translationCodeId` , `sales_channel_domain.language` . `name` AS `sales_channel_domain.language.name` , `sales_channel_domain.language` . `custom_fields` AS `sales_channel_domain.language.customFields` , `sales_channel_domain.language` . `created_at` AS `sales_channel_domain.language.createdAt` , `sales_channel_domain.language` . `updated_at` AS `sales_channel_domain.language.updatedAt` , `sales_channel_domain.language.locale` . `id` AS `sales_channel_domain.language.locale.id` , `sales_channel_domain.language.locale` . `code` AS `sales_channel_domain.language.locale.code` , `sales_channel_domain.language.locale` . `created_at` AS `sales_channel_domain.language.locale.createdAt` , `sales_channel_domain.language.locale` . `updated_at` AS `sales_channel_domain.language.locale.updatedAt` , `sales_channel_domain.language.locale.translation.name` , COALESCE (`sales_channel_domain.language.locale.translation.name` , `sales_channel_domain.language.locale.translation.name` ) AS `sales_channel_domain.language.locale.name` , `sales_channel_domain.language.locale.translation.territory` , COALESCE (`sales_channel_domain.language.locale.translation.territory` , `sales_channel_domain.language.locale.translation.territory` ) AS `sales_channel_domain.language.locale.territory` , `sales_channel_domain.language.locale.translation.customFields` , COALESCE (`sales_channel_domain.language.locale.translation.customFields` , `sales_channel_domain.language.locale.translation.customFields` ) AS `sales_channel_domain.language.locale.customFields` , `sales_channel_domain.language.locale.translation.createdAt` , `sales_channel_domain.language.locale.translation.updatedAt` , `sales_channel_domain.language.locale.translation.localeId` , `sales_channel_domain.language.locale.translation.languageId` , `sales_channel_domain.currency` . `id` AS `sales_channel_domain.currency.id` , `sales_channel_domain.currency` . `factor` AS `sales_channel_domain.currency.factor` , `sales_channel_domain.currency` . `symbol` AS `sales_channel_domain.currency.symbol` , `sales_channel_domain.currency` . `iso_code` AS `sales_channel_domain.currency.isoCode` , `sales_channel_domain.currency` . `position` AS `sales_channel_domain.currency.position` , `sales_channel_domain.currency` . `tax_free_from` AS `sales_channel_domain.currency.taxFreeFrom` , `sales_channel_domain.currency` . `item_rounding` AS `sales_channel_domain.currency.itemRounding` , `sales_channel_domain.currency` . `total_rounding` AS `sales_channel_domain.currency.totalRounding` , `sales_channel_domain.currency` . `created_at` AS `sales_channel_domain.currency.createdAt` , `sales_channel_domain.currency` . `updated_at` AS `sales_channel_domain.currency.updatedAt` , `sales_channel_domain.currency.translation.shortName` , COALESCE (`sales_channel_domain.currency.translation.shortName` , `sales_channel_domain.currency.translation.shortName` ) AS `sales_channel_domain.currency.shortName` , `sales_channel_domain.currency.translation.name` , COALESCE (`sales_channel_domain.currency.translation.name` , `sales_channel_domain.currency.translation.name` ) AS `sales_channel_domain.currency.name` , `sales_channel_domain.currency.translation.customFields` , COALESCE (`sales_channel_domain.currency.translation.customFields` , `sales_channel_domain.currency.translation.customFields` ) AS `sales_channel_domain.currency.customFields` , `sales_channel_domain.currency.translation.createdAt` , `sales_channel_domain.currency.translation.updatedAt` , `sales_channel_domain.currency.translation.currencyId` , `sales_channel_domain.currency.translation.languageId` FROM `sales_channel_domain` LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain` . `language_id` = `sales_channel_domain.language` . `id` LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain` . `currency_id` = `sales_channel_domain.currency` . `id` LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language` . `locale_id` = `sales_channel_domain.language.locale` . `id` LEFT JOIN (SELECT `sales_channel_domain.language.locale.translation` . locale_id , `sales_channel_domain.language.locale.translation` . name AS `sales_channel_domain.language.locale.translation.name` , `sales_channel_domain.language.locale.translation` . territory AS `sales_channel_domain.language.locale.translation.territory` , `sales_channel_domain.language.locale.translation` . custom_fields AS `sales_channel_domain.language.locale.translation.customFields` , `sales_channel_domain.language.locale.translation` . created_at AS `sales_channel_domain.language.locale.translation.createdAt` , `sales_channel_domain.language.locale.translation` . updated_at AS `sales_channel_domain.language.locale.translation.updatedAt` , `sales_channel_domain.language.locale.translation` . locale_id AS `sales_channel_domain.language.locale.translation.localeId` , `sales_channel_domain.language.locale.translation` . language_id AS `sales_channel_domain.language.locale.translation.languageId` FROM `locale_translation` `sales_channel_domain.language.locale.translation` WHERE `sales_channel_domain.language.locale.translation` . language_id = ? ) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation` . `locale_id` = `sales_channel_domain.language.locale` . `id` LEFT JOIN (SELECT `sales_channel_domain.currency.translation` . currency_id , `sales_channel_domain.currency.translation` . short_name AS `sales_channel_domain.currency.translation.shortName` , `sales_channel_domain.currency.translation` . name AS `sales_channel_domain.currency.translation.name` , `sales_channel_domain.currency.translation` . custom_fields AS `sales_channel_domain.currency.translation.customFields` , `sales_channel_domain.currency.translation` . created_at AS `sales_channel_domain.currency.translation.createdAt` , `sales_channel_domain.currency.translation` . updated_at AS `sales_channel_domain.currency.translation.updatedAt` , `sales_channel_domain.currency.translation` . currency_id AS `sales_channel_domain.currency.translation.currencyId` , `sales_channel_domain.currency.translation` . language_id AS `sales_channel_domain.currency.translation.languageId` FROM `currency_translation` `sales_channel_domain.currency.translation` WHERE `sales_channel_domain.currency.translation` . language_id = ? ) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation` . `currency_id` = `sales_channel_domain.currency` . `id` WHERE `sales_channel_domain` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"ea¦\e OOLU¨UJB\x05 µ‚& "
]
SELECT
`sales_channel_domain` . `id` AS `sales_channel_domain.id` ,
`sales_channel_domain` . `url` AS `sales_channel_domain.url` ,
`sales_channel_domain` . `sales_channel_id` AS `sales_channel_domain.salesChannelId` ,
`sales_channel_domain` . `language_id` AS `sales_channel_domain.languageId` ,
`sales_channel_domain` . `currency_id` AS `sales_channel_domain.currencyId` ,
`sales_channel_domain` . `snippet_set_id` AS `sales_channel_domain.snippetSetId` ,
`sales_channel_domain` . `hreflang_use_only_locale` AS `sales_channel_domain.hreflangUseOnlyLocale` ,
`sales_channel_domain` . `custom_fields` AS `sales_channel_domain.customFields` ,
`sales_channel_domain` . `created_at` AS `sales_channel_domain.createdAt` ,
`sales_channel_domain` . `updated_at` AS `sales_channel_domain.updatedAt` ,
`sales_channel_domain.language` . `id` AS `sales_channel_domain.language.id` ,
`sales_channel_domain.language` . `parent_id` AS `sales_channel_domain.language.parentId` ,
`sales_channel_domain.language` . `locale_id` AS `sales_channel_domain.language.localeId` ,
`sales_channel_domain.language` . `translation_code_id` AS `sales_channel_domain.language.translationCodeId` ,
`sales_channel_domain.language` . `name` AS `sales_channel_domain.language.name` ,
`sales_channel_domain.language` . `custom_fields` AS `sales_channel_domain.language.customFields` ,
`sales_channel_domain.language` . `created_at` AS `sales_channel_domain.language.createdAt` ,
`sales_channel_domain.language` . `updated_at` AS `sales_channel_domain.language.updatedAt` ,
`sales_channel_domain.language.locale` . `id` AS `sales_channel_domain.language.locale.id` ,
`sales_channel_domain.language.locale` . `code` AS `sales_channel_domain.language.locale.code` ,
`sales_channel_domain.language.locale` . `created_at` AS `sales_channel_domain.language.locale.createdAt` ,
`sales_channel_domain.language.locale` . `updated_at` AS `sales_channel_domain.language.locale.updatedAt` ,
`sales_channel_domain.language.locale.translation.name` ,
COALESCE (
`sales_channel_domain.language.locale.translation.name` ,
`sales_channel_domain.language.locale.translation.name`
) AS `sales_channel_domain.language.locale.name` ,
`sales_channel_domain.language.locale.translation.territory` ,
COALESCE (
`sales_channel_domain.language.locale.translation.territory` ,
`sales_channel_domain.language.locale.translation.territory`
) AS `sales_channel_domain.language.locale.territory` ,
`sales_channel_domain.language.locale.translation.customFields` ,
COALESCE (
`sales_channel_domain.language.locale.translation.customFields` ,
`sales_channel_domain.language.locale.translation.customFields`
) AS `sales_channel_domain.language.locale.customFields` ,
`sales_channel_domain.language.locale.translation.createdAt` ,
`sales_channel_domain.language.locale.translation.updatedAt` ,
`sales_channel_domain.language.locale.translation.localeId` ,
`sales_channel_domain.language.locale.translation.languageId` ,
`sales_channel_domain.currency` . `id` AS `sales_channel_domain.currency.id` ,
`sales_channel_domain.currency` . `factor` AS `sales_channel_domain.currency.factor` ,
`sales_channel_domain.currency` . `symbol` AS `sales_channel_domain.currency.symbol` ,
`sales_channel_domain.currency` . `iso_code` AS `sales_channel_domain.currency.isoCode` ,
`sales_channel_domain.currency` . `position` AS `sales_channel_domain.currency.position` ,
`sales_channel_domain.currency` . `tax_free_from` AS `sales_channel_domain.currency.taxFreeFrom` ,
`sales_channel_domain.currency` . `item_rounding` AS `sales_channel_domain.currency.itemRounding` ,
`sales_channel_domain.currency` . `total_rounding` AS `sales_channel_domain.currency.totalRounding` ,
`sales_channel_domain.currency` . `created_at` AS `sales_channel_domain.currency.createdAt` ,
`sales_channel_domain.currency` . `updated_at` AS `sales_channel_domain.currency.updatedAt` ,
`sales_channel_domain.currency.translation.shortName` ,
COALESCE (
`sales_channel_domain.currency.translation.shortName` ,
`sales_channel_domain.currency.translation.shortName`
) AS `sales_channel_domain.currency.shortName` ,
`sales_channel_domain.currency.translation.name` ,
COALESCE (
`sales_channel_domain.currency.translation.name` ,
`sales_channel_domain.currency.translation.name`
) AS `sales_channel_domain.currency.name` ,
`sales_channel_domain.currency.translation.customFields` ,
COALESCE (
`sales_channel_domain.currency.translation.customFields` ,
`sales_channel_domain.currency.translation.customFields`
) AS `sales_channel_domain.currency.customFields` ,
`sales_channel_domain.currency.translation.createdAt` ,
`sales_channel_domain.currency.translation.updatedAt` ,
`sales_channel_domain.currency.translation.currencyId` ,
`sales_channel_domain.currency.translation.languageId`
FROM
`sales_channel_domain`
LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain` . `language_id` = `sales_channel_domain.language` . `id`
LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain` . `currency_id` = `sales_channel_domain.currency` . `id`
LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language` . `locale_id` = `sales_channel_domain.language.locale` . `id`
LEFT JOIN (
SELECT
`sales_channel_domain.language.locale.translation` . locale_id ,
`sales_channel_domain.language.locale.translation` . name AS `sales_channel_domain.language.locale.translation.name` ,
`sales_channel_domain.language.locale.translation` . territory AS `sales_channel_domain.language.locale.translation.territory` ,
`sales_channel_domain.language.locale.translation` . custom_fields AS `sales_channel_domain.language.locale.translation.customFields` ,
`sales_channel_domain.language.locale.translation` . created_at AS `sales_channel_domain.language.locale.translation.createdAt` ,
`sales_channel_domain.language.locale.translation` . updated_at AS `sales_channel_domain.language.locale.translation.updatedAt` ,
`sales_channel_domain.language.locale.translation` . locale_id AS `sales_channel_domain.language.locale.translation.localeId` ,
`sales_channel_domain.language.locale.translation` . language_id AS `sales_channel_domain.language.locale.translation.languageId`
FROM
`locale_translation` `sales_channel_domain.language.locale.translation`
WHERE
`sales_channel_domain.language.locale.translation` . language_id = ?
) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation` . `locale_id` = `sales_channel_domain.language.locale` . `id`
LEFT JOIN (
SELECT
`sales_channel_domain.currency.translation` . currency_id ,
`sales_channel_domain.currency.translation` . short_name AS `sales_channel_domain.currency.translation.shortName` ,
`sales_channel_domain.currency.translation` . name AS `sales_channel_domain.currency.translation.name` ,
`sales_channel_domain.currency.translation` . custom_fields AS `sales_channel_domain.currency.translation.customFields` ,
`sales_channel_domain.currency.translation` . created_at AS `sales_channel_domain.currency.translation.createdAt` ,
`sales_channel_domain.currency.translation` . updated_at AS `sales_channel_domain.currency.translation.updatedAt` ,
`sales_channel_domain.currency.translation` . currency_id AS `sales_channel_domain.currency.translation.currencyId` ,
`sales_channel_domain.currency.translation` . language_id AS `sales_channel_domain.currency.translation.languageId`
FROM
`currency_translation` `sales_channel_domain.currency.translation`
WHERE
`sales_channel_domain.currency.translation` . language_id = ?
) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation` . `currency_id` = `sales_channel_domain.currency` . `id`
WHERE
`sales_channel_domain` . `id` IN (? )Copy
SELECT `sales_channel_domain` . `id` AS `sales_channel_domain.id` , `sales_channel_domain` . `url` AS `sales_channel_domain.url` , `sales_channel_domain` . `sales_channel_id` AS `sales_channel_domain.salesChannelId` , `sales_channel_domain` . `language_id` AS `sales_channel_domain.languageId` , `sales_channel_domain` . `currency_id` AS `sales_channel_domain.currencyId` , `sales_channel_domain` . `snippet_set_id` AS `sales_channel_domain.snippetSetId` , `sales_channel_domain` . `hreflang_use_only_locale` AS `sales_channel_domain.hreflangUseOnlyLocale` , `sales_channel_domain` . `custom_fields` AS `sales_channel_domain.customFields` , `sales_channel_domain` . `created_at` AS `sales_channel_domain.createdAt` , `sales_channel_domain` . `updated_at` AS `sales_channel_domain.updatedAt` , `sales_channel_domain.language` . `id` AS `sales_channel_domain.language.id` , `sales_channel_domain.language` . `parent_id` AS `sales_channel_domain.language.parentId` , `sales_channel_domain.language` . `locale_id` AS `sales_channel_domain.language.localeId` , `sales_channel_domain.language` . `translation_code_id` AS `sales_channel_domain.language.translationCodeId` , `sales_channel_domain.language` . `name` AS `sales_channel_domain.language.name` , `sales_channel_domain.language` . `custom_fields` AS `sales_channel_domain.language.customFields` , `sales_channel_domain.language` . `created_at` AS `sales_channel_domain.language.createdAt` , `sales_channel_domain.language` . `updated_at` AS `sales_channel_domain.language.updatedAt` , `sales_channel_domain.language.locale` . `id` AS `sales_channel_domain.language.locale.id` , `sales_channel_domain.language.locale` . `code` AS `sales_channel_domain.language.locale.code` , `sales_channel_domain.language.locale` . `created_at` AS `sales_channel_domain.language.locale.createdAt` , `sales_channel_domain.language.locale` . `updated_at` AS `sales_channel_domain.language.locale.updatedAt` , `sales_channel_domain.language.locale.translation.name` , COALESCE (`sales_channel_domain.language.locale.translation.name` , `sales_channel_domain.language.locale.translation.name` ) AS `sales_channel_domain.language.locale.name` , `sales_channel_domain.language.locale.translation.territory` , COALESCE (`sales_channel_domain.language.locale.translation.territory` , `sales_channel_domain.language.locale.translation.territory` ) AS `sales_channel_domain.language.locale.territory` , `sales_channel_domain.language.locale.translation.customFields` , COALESCE (`sales_channel_domain.language.locale.translation.customFields` , `sales_channel_domain.language.locale.translation.customFields` ) AS `sales_channel_domain.language.locale.customFields` , `sales_channel_domain.language.locale.translation.createdAt` , `sales_channel_domain.language.locale.translation.updatedAt` , `sales_channel_domain.language.locale.translation.localeId` , `sales_channel_domain.language.locale.translation.languageId` , `sales_channel_domain.currency` . `id` AS `sales_channel_domain.currency.id` , `sales_channel_domain.currency` . `factor` AS `sales_channel_domain.currency.factor` , `sales_channel_domain.currency` . `symbol` AS `sales_channel_domain.currency.symbol` , `sales_channel_domain.currency` . `iso_code` AS `sales_channel_domain.currency.isoCode` , `sales_channel_domain.currency` . `position` AS `sales_channel_domain.currency.position` , `sales_channel_domain.currency` . `tax_free_from` AS `sales_channel_domain.currency.taxFreeFrom` , `sales_channel_domain.currency` . `item_rounding` AS `sales_channel_domain.currency.itemRounding` , `sales_channel_domain.currency` . `total_rounding` AS `sales_channel_domain.currency.totalRounding` , `sales_channel_domain.currency` . `created_at` AS `sales_channel_domain.currency.createdAt` , `sales_channel_domain.currency` . `updated_at` AS `sales_channel_domain.currency.updatedAt` , `sales_channel_domain.currency.translation.shortName` , COALESCE (`sales_channel_domain.currency.translation.shortName` , `sales_channel_domain.currency.translation.shortName` ) AS `sales_channel_domain.currency.shortName` , `sales_channel_domain.currency.translation.name` , COALESCE (`sales_channel_domain.currency.translation.name` , `sales_channel_domain.currency.translation.name` ) AS `sales_channel_domain.currency.name` , `sales_channel_domain.currency.translation.customFields` , COALESCE (`sales_channel_domain.currency.translation.customFields` , `sales_channel_domain.currency.translation.customFields` ) AS `sales_channel_domain.currency.customFields` , `sales_channel_domain.currency.translation.createdAt` , `sales_channel_domain.currency.translation.updatedAt` , `sales_channel_domain.currency.translation.currencyId` , `sales_channel_domain.currency.translation.languageId` FROM `sales_channel_domain` LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain` . `language_id` = `sales_channel_domain.language` . `id` LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain` . `currency_id` = `sales_channel_domain.currency` . `id` LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language` . `locale_id` = `sales_channel_domain.language.locale` . `id` LEFT JOIN (SELECT `sales_channel_domain.language.locale.translation` . locale_id , `sales_channel_domain.language.locale.translation` . name AS `sales_channel_domain.language.locale.translation.name` , `sales_channel_domain.language.locale.translation` . territory AS `sales_channel_domain.language.locale.translation.territory` , `sales_channel_domain.language.locale.translation` . custom_fields AS `sales_channel_domain.language.locale.translation.customFields` , `sales_channel_domain.language.locale.translation` . created_at AS `sales_channel_domain.language.locale.translation.createdAt` , `sales_channel_domain.language.locale.translation` . updated_at AS `sales_channel_domain.language.locale.translation.updatedAt` , `sales_channel_domain.language.locale.translation` . locale_id AS `sales_channel_domain.language.locale.translation.localeId` , `sales_channel_domain.language.locale.translation` . language_id AS `sales_channel_domain.language.locale.translation.languageId` FROM `locale_translation` `sales_channel_domain.language.locale.translation` WHERE `sales_channel_domain.language.locale.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation` . `locale_id` = `sales_channel_domain.language.locale` . `id` LEFT JOIN (SELECT `sales_channel_domain.currency.translation` . currency_id , `sales_channel_domain.currency.translation` . short_name AS `sales_channel_domain.currency.translation.shortName` , `sales_channel_domain.currency.translation` . name AS `sales_channel_domain.currency.translation.name` , `sales_channel_domain.currency.translation` . custom_fields AS `sales_channel_domain.currency.translation.customFields` , `sales_channel_domain.currency.translation` . created_at AS `sales_channel_domain.currency.translation.createdAt` , `sales_channel_domain.currency.translation` . updated_at AS `sales_channel_domain.currency.translation.updatedAt` , `sales_channel_domain.currency.translation` . currency_id AS `sales_channel_domain.currency.translation.currencyId` , `sales_channel_domain.currency.translation` . language_id AS `sales_channel_domain.currency.translation.languageId` FROM `currency_translation` `sales_channel_domain.currency.translation` WHERE `sales_channel_domain.currency.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation` . `currency_id` = `sales_channel_domain.currency` . `id` WHERE `sales_channel_domain` . `id` IN (0x6561A61B4F4F4C55A8554A4205B58226 ); Copy
0.56 ms
1
SELECT `sales_channel` . `id` AS `sales_channel.id` , `sales_channel` . `type_id` AS `sales_channel.typeId` , `sales_channel` . `language_id` AS `sales_channel.languageId` , `sales_channel` . `customer_group_id` AS `sales_channel.customerGroupId` , `sales_channel` . `currency_id` AS `sales_channel.currencyId` , `sales_channel` . `payment_method_id` AS `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` AS `sales_channel.shippingMethodId` , `sales_channel` . `country_id` AS `sales_channel.countryId` , `sales_channel` . `analytics_id` AS `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` AS `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` AS `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` AS `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` AS `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` AS `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` AS `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` AS `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` AS `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` AS `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` AS `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` AS `sales_channel.taxCalculationType` , `sales_channel` . `access_key` AS `sales_channel.accessKey` , `sales_channel` . `configuration` AS `sales_channel.configuration` , `sales_channel` . `active` AS `sales_channel.active` , `sales_channel` . `hreflang_active` AS `sales_channel.hreflangActive` , `sales_channel` . `maintenance` AS `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` AS `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` AS `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` AS `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` AS `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` AS `sales_channel.createdAt` , `sales_channel` . `updated_at` AS `sales_channel.updatedAt` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) AS `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) AS `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) AS `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) AS `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) AS `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) AS `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) AS `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) AS `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name AS `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config AS `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled AS `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name AS `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title AS `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description AS `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords AS `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields AS `sales_channel.translation.customFields` , `sales_channel.translation` . created_at AS `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at AS `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id AS `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id AS `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` WHERE `sales_channel` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b":s\x01 VìSNAè.±K[\x00\x02 z "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
]
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 (0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F , 0x3A7301568D534E418A2EF14B5B00027A , 0xA290DC5C19E14CBEBBA6C40F9C59949F ); Copy
0.56 ms
1
SELECT `neti_store_locator_contact_form` . `id` AS `neti_store_locator_contact_form.id` , `neti_store_locator_contact_form` . `active` AS `neti_store_locator_contact_form.active` , `neti_store_locator_contact_form` . `type` AS `neti_store_locator_contact_form.type` , `neti_store_locator_contact_form` . `required` AS `neti_store_locator_contact_form.required` , `neti_store_locator_contact_form` . `position` AS `neti_store_locator_contact_form.position` , `neti_store_locator_contact_form` . `created_at` AS `neti_store_locator_contact_form.createdAt` , `neti_store_locator_contact_form` . `updated_at` AS `neti_store_locator_contact_form.updatedAt` , `neti_store_locator_contact_form.translation.label` , COALESCE (`neti_store_locator_contact_form.translation.label` , `neti_store_locator_contact_form.translation.label` ) AS `neti_store_locator_contact_form.label` , `neti_store_locator_contact_form.translation.value` , COALESCE (`neti_store_locator_contact_form.translation.value` , `neti_store_locator_contact_form.translation.value` ) AS `neti_store_locator_contact_form.value` , `neti_store_locator_contact_form.translation.createdAt` , `neti_store_locator_contact_form.translation.updatedAt` , `neti_store_locator_contact_form.translation.netiStoreLocatorContactFormId` , `neti_store_locator_contact_form.translation.languageId` FROM `neti_store_locator_contact_form` LEFT JOIN (SELECT `neti_store_locator_contact_form.translation` . neti_store_locator_contact_form_id , `neti_store_locator_contact_form.translation` . label AS `neti_store_locator_contact_form.translation.label` , `neti_store_locator_contact_form.translation` . value AS `neti_store_locator_contact_form.translation.value` , `neti_store_locator_contact_form.translation` . created_at AS `neti_store_locator_contact_form.translation.createdAt` , `neti_store_locator_contact_form.translation` . updated_at AS `neti_store_locator_contact_form.translation.updatedAt` , `neti_store_locator_contact_form.translation` . neti_store_locator_contact_form_id AS `neti_store_locator_contact_form.translation.netiStoreLocatorContactFormId` , `neti_store_locator_contact_form.translation` . language_id AS `neti_store_locator_contact_form.translation.languageId` FROM `neti_store_locator_contact_form_translation` `neti_store_locator_contact_form.translation` WHERE `neti_store_locator_contact_form.translation` . language_id = ? ) `neti_store_locator_contact_form.neti_store_locator_contact_form_translation` ON `neti_store_locator_contact_form.neti_store_locator_contact_form_translation` . `neti_store_locator_contact_form_id` = `neti_store_locator_contact_form` . `id` WHERE `neti_store_locator_contact_form` . `id` IN (? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"]vÆ¥6>L…ªU=ÙáœTý "
b"——qh\x1A æB›—_¼(tÕ܆ "
b"N´+Ï!ÔD›ºf«:F×Ív "
b"ò^ÎÒ)ËMÏüûÆi│ûyƒ "
b"î\x15 9ä´¹Föœ’oÔ\x04 T1ä "
b"░Mh└═øD_Å!\x02 Øk;âÔ "
]
SELECT `neti_store_locator_contact_form` . `id` AS `neti_store_locator_contact_form.id` , `neti_store_locator_contact_form` . `active` AS `neti_store_locator_contact_form.active` , `neti_store_locator_contact_form` . `type` AS `neti_store_locator_contact_form.type` , `neti_store_locator_contact_form` . `required` AS `neti_store_locator_contact_form.required` , `neti_store_locator_contact_form` . `position` AS `neti_store_locator_contact_form.position` , `neti_store_locator_contact_form` . `created_at` AS `neti_store_locator_contact_form.createdAt` , `neti_store_locator_contact_form` . `updated_at` AS `neti_store_locator_contact_form.updatedAt` , `neti_store_locator_contact_form.translation.label` , COALESCE (`neti_store_locator_contact_form.translation.label` , `neti_store_locator_contact_form.translation.label` ) AS `neti_store_locator_contact_form.label` , `neti_store_locator_contact_form.translation.value` , COALESCE (`neti_store_locator_contact_form.translation.value` , `neti_store_locator_contact_form.translation.value` ) AS `neti_store_locator_contact_form.value` , `neti_store_locator_contact_form.translation.createdAt` , `neti_store_locator_contact_form.translation.updatedAt` , `neti_store_locator_contact_form.translation.netiStoreLocatorContactFormId` , `neti_store_locator_contact_form.translation.languageId` FROM `neti_store_locator_contact_form` LEFT JOIN (SELECT `neti_store_locator_contact_form.translation` . neti_store_locator_contact_form_id , `neti_store_locator_contact_form.translation` . label AS `neti_store_locator_contact_form.translation.label` , `neti_store_locator_contact_form.translation` . value AS `neti_store_locator_contact_form.translation.value` , `neti_store_locator_contact_form.translation` . created_at AS `neti_store_locator_contact_form.translation.createdAt` , `neti_store_locator_contact_form.translation` . updated_at AS `neti_store_locator_contact_form.translation.updatedAt` , `neti_store_locator_contact_form.translation` . neti_store_locator_contact_form_id AS `neti_store_locator_contact_form.translation.netiStoreLocatorContactFormId` , `neti_store_locator_contact_form.translation` . language_id AS `neti_store_locator_contact_form.translation.languageId` FROM `neti_store_locator_contact_form_translation` `neti_store_locator_contact_form.translation` WHERE `neti_store_locator_contact_form.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `neti_store_locator_contact_form.neti_store_locator_contact_form_translation` ON `neti_store_locator_contact_form.neti_store_locator_contact_form_translation` . `neti_store_locator_contact_form_id` = `neti_store_locator_contact_form` . `id` WHERE `neti_store_locator_contact_form` . `id` IN (0x5D76C6A5363E4C85AA553DD9E19C54FD , 0x979771681AE6429B975FBC2874D5DC86 , 0x4EB42BCF21D4449BBA66AB3A46D7CD76 , 0x955ED7E329D34DD881969269B396799F , 0xEE1539E4B4B946F69C926FD4045431E4 , 0xB04D68C0CD9B445F8F21029D6B3B83E2 ); Copy
0.56 ms
1
SELECT `rule` . `id` AS `rule.id` , `rule` . `name` AS `rule.name` , `rule` . `priority` AS `rule.priority` , `rule` . `description` AS `rule.description` , `rule` . `payload` AS `rule.payload` , `rule` . `invalid` AS `rule.invalid` , `rule` . `areas` AS `rule.areas` , `rule` . `custom_fields` AS `rule.customFields` , `rule` . `module_types` AS `rule.moduleTypes` , `rule` . `created_at` AS `rule.createdAt` , `rule` . `updated_at` AS `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"-\r -¡Å┘NnöçÞÊ¿þ\x7F â "
b"""
EÑ\n
Y¯…IG³ú·=ü\x7F\x1D b
"""
b"Xn÷3ç\x00 C\x19 °¶¶à‡U\x16 "
b"ô1@ß&\x12 LnÉN[ñß\x00 <h "
b"—‚Ê\x07 x‰E\x0E ¥g¸›¶ÜÕ "
b"®6´ç\f UO¶½Z\x01\x1A ”¤-} "
b"Ê┼N\x17 ü┬A-Ñ─┴r®%æ\v "
b"ÛMÖ+Ö|F† :½,Ÿ^˜= "
b"""
\n ´Sù†}F¢¢¢rÝ/ºo\f
"""
b"î4PCòhAdØ▒┤['aÍ! "
b"\x06 &\x01 ÝZ\f G1™ãp0\f ŒK>\x18 –@§l-@˜´ä\x12 £\e ž\x01 ”█¯▒±Ê╚N(ì\x04 ═\x08 IÙ~C "
]
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 (0x2D0D2DAD8FD94E6E9487E8D2A8E77F83 , 0x45D10A59AF854947B3FAB73DFC7F1D62 , 0x586EF733E7004319B0B6B6E087551620 , 0x933140E126124C6E904E5BA4E1003C68 , 0x9782CA077889450EA567B89BB6DCD5AD , 0xAE36B4E70C554FB6BD5A011A94A42D7D , 0xD2C54E1781C2412DA5C4C172A925910B , 0xDB4DD62BD67C4686A03ABD2C9F5E983D , 0x0AB453F9867D46A2A2A272DD2FBA6F0C , 0x8C345043956841649DB1B45B2761D621 , 0x062601DD5A0C473199E370300C8C4B3E , 0x189640A76C2D4098B4E412A31B9E0194 , 0xDBEEB1F1D2C84E288D04CD0849EB7E43 ); Copy
0.55 ms
1
SELECT `acris_cookie_group` . `id` AS `acris_cookie_group.id` , `acris_cookie_group` . `is_default` AS `acris_cookie_group.isDefault` , `acris_cookie_group` . `identification` AS `acris_cookie_group.identification` , `acris_cookie_group` . `created_at` AS `acris_cookie_group.createdAt` , `acris_cookie_group` . `updated_at` AS `acris_cookie_group.updatedAt` , `acris_cookie_group.translation.title` , COALESCE (`acris_cookie_group.translation.title` , `acris_cookie_group.translation.title` ) AS `acris_cookie_group.title` , `acris_cookie_group.translation.description` , COALESCE (`acris_cookie_group.translation.description` , `acris_cookie_group.translation.description` ) AS `acris_cookie_group.description` , `acris_cookie_group.translation.createdAt` , `acris_cookie_group.translation.updatedAt` , `acris_cookie_group.translation.acrisCookieGroupId` , `acris_cookie_group.translation.languageId` FROM `acris_cookie_group` LEFT JOIN (SELECT `acris_cookie_group.translation` . acris_cookie_group_id , `acris_cookie_group.translation` . title AS `acris_cookie_group.translation.title` , `acris_cookie_group.translation` . description AS `acris_cookie_group.translation.description` , `acris_cookie_group.translation` . created_at AS `acris_cookie_group.translation.createdAt` , `acris_cookie_group.translation` . updated_at AS `acris_cookie_group.translation.updatedAt` , `acris_cookie_group.translation` . acris_cookie_group_id AS `acris_cookie_group.translation.acrisCookieGroupId` , `acris_cookie_group.translation` . language_id AS `acris_cookie_group.translation.languageId` FROM `acris_cookie_group_translation` `acris_cookie_group.translation` WHERE `acris_cookie_group.translation` . language_id = ? ) `acris_cookie_group.acris_cookie_group_translation` ON `acris_cookie_group.acris_cookie_group_translation` . `acris_cookie_group_id` = `acris_cookie_group` . `id` WHERE `acris_cookie_group` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"1+çßKvLlÇ~Ùÿìð\x1E 0 "
b"\x01 ÉÚøìÅsëº\x1C S\\x7F ;0¢\x01 ô?B¢┘q©ØÔa║\x11 o\x11 ╗\x01 •7T«\x1A pšµƒ “´\x11 Ev\x01 •7Wa“pw¡o„&ŠÊ¯\x07 \x02\x01 /7I█H!ñ\e ıu~(ÓÉ.;mS|5O\±Øäž~FÌt "
b"4wXñ┘\x08 L\x14 £SôÉ9ø\x18 ┴ "
b"<zì╦,ªGb║3«Ê#?=V "
b"='\x13\e ¨1B£–?\x19 ‚·Iœk "
b"TÜÔ~Ã┘G'üÀqyo─\x1C á "
b"[ƒ<à~FJÔ¬Pðªžk4\x05 "
b"""
Ø▓└ø\x7F £D.®\x19\x17 \n
x\x19 [─
"""
b"ÀõŽ`›³J¶ \x14 ·„iÕ‘} "
b"Ì_<-·¥ILˆ«§¶“\e oj "
b"┘{áÍ┐®EùØ\x05 Ù½┴\e O "
]
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` . `id` IN (0x312B87E14B764C6C807EEB988DD01E30 , 0x0190E99B8D8F7389A71C535C7F3B30BD , 0x01933F42BDD971B89DE261BA116F11BB , 0x01953754AB1A709AB5832093B4114576 , 0x0195375761937077A16F84268ACAAF07 , 0x02012F3749DB4821A41BD5757E28E090 , 0x2E3B6D537C354F5CB1D8E49E7E46CC74 , 0x347758A4D9084C149C539390399B18C1 , 0x3C7A8DCB2CA64762BA33AED2233F3D56 , 0x3D27131BA83142A3963F1982B7499C6B , 0x549AE27EC7D9472781B771796FC41CA0 , 0x5B833CE07E464AD4AC50F0AA9E6B3405 , 0x9DB2C09B7F9C442EA919170A78195BC4 , 0xC0F58E609BB34AB6A014B78469D5917D , 0xCC5F3C2DB7A5494C88ABA7B6931B6F6A , 0xD97BA0D6BFA945979D05EBABC11B4F20 ); Copy
0.49 ms
1
SELECT `media` . `id` AS `media.id` , `media` . `user_id` AS `media.userId` , `media` . `media_folder_id` AS `media.mediaFolderId` , `media` . `mime_type` AS `media.mimeType` , `media` . `file_extension` AS `media.fileExtension` , `media` . `uploaded_at` AS `media.uploadedAt` , `media` . `file_name` AS `media.fileName` , `media` . `file_size` AS `media.fileSize` , `media` . `media_type` AS `media.mediaTypeRaw` , `media` . `meta_data` AS `media.metaData` , `media` . `config` AS `media.config` , `media` . `path` AS `media.path` , `media` . `private` AS `media.private` , `media` . `thumbnails_ro` AS `media.thumbnailsRo` , `media` . `created_at` AS `media.createdAt` , `media` . `updated_at` AS `media.updatedAt` , `media.translation.title` , COALESCE (`media.translation.title` , `media.translation.title` ) AS `media.title` , `media.translation.alt` , COALESCE (`media.translation.alt` , `media.translation.alt` ) AS `media.alt` , `media.translation.customFields` , COALESCE (`media.translation.customFields` , `media.translation.customFields` ) AS `media.customFields` , `media.translation.createdAt` , `media.translation.updatedAt` , `media.translation.mediaId` , `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . media_id , `media.translation` . title AS `media.translation.title` , `media.translation` . alt AS `media.translation.alt` , `media.translation` . custom_fields AS `media.translation.customFields` , `media.translation` . created_at AS `media.translation.createdAt` , `media.translation` . updated_at AS `media.translation.updatedAt` , `media.translation` . media_id AS `media.translation.mediaId` , `media.translation` . language_id AS `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation` . language_id = ? ) `media.media_translation` ON `media.media_translation` . `media_id` = `media` . `id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder` . `default_folder_id` = `media.mediaFolder.defaultFolder` . `id` WHERE (`media` . `id` = ? AND (`media` . `private` = ? OR (`media` . `private` = ? AND `media.mediaFolder.defaultFolder` . `entity` = ? )))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"ÂAÝ^w\Aõ°.pß\x07 2Ej "
false
true
"product_download "
]
SELECT `media` . `id` AS `media.id` , `media` . `user_id` AS `media.userId` , `media` . `media_folder_id` AS `media.mediaFolderId` , `media` . `mime_type` AS `media.mimeType` , `media` . `file_extension` AS `media.fileExtension` , `media` . `uploaded_at` AS `media.uploadedAt` , `media` . `file_name` AS `media.fileName` , `media` . `file_size` AS `media.fileSize` , `media` . `media_type` AS `media.mediaTypeRaw` , `media` . `meta_data` AS `media.metaData` , `media` . `config` AS `media.config` , `media` . `path` AS `media.path` , `media` . `private` AS `media.private` , `media` . `thumbnails_ro` AS `media.thumbnailsRo` , `media` . `created_at` AS `media.createdAt` , `media` . `updated_at` AS `media.updatedAt` , `media.translation.title` , COALESCE (`media.translation.title` , `media.translation.title` ) AS `media.title` , `media.translation.alt` , COALESCE (`media.translation.alt` , `media.translation.alt` ) AS `media.alt` , `media.translation.customFields` , COALESCE (`media.translation.customFields` , `media.translation.customFields` ) AS `media.customFields` , `media.translation.createdAt` , `media.translation.updatedAt` , `media.translation.mediaId` , `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . media_id , `media.translation` . title AS `media.translation.title` , `media.translation` . alt AS `media.translation.alt` , `media.translation` . custom_fields AS `media.translation.customFields` , `media.translation` . created_at AS `media.translation.createdAt` , `media.translation` . updated_at AS `media.translation.updatedAt` , `media.translation` . media_id AS `media.translation.mediaId` , `media.translation` . language_id AS `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `media.media_translation` ON `media.media_translation` . `media_id` = `media` . `id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder` . `default_folder_id` = `media.mediaFolder.defaultFolder` . `id` WHERE (`media` . `id` = 0xC241DD5E775C41F5B02E70DF0732456A AND (`media` . `private` = 0 OR (`media` . `private` = 1 AND `media.mediaFolder.defaultFolder` . `entity` = 'product_download' ))); Copy
0.48 ms
1
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
0.44 ms
1
SELECT `sales_channel` . `id` AS `sales_channel.id` , `sales_channel` . `type_id` AS `sales_channel.typeId` , `sales_channel` . `language_id` AS `sales_channel.languageId` , `sales_channel` . `customer_group_id` AS `sales_channel.customerGroupId` , `sales_channel` . `currency_id` AS `sales_channel.currencyId` , `sales_channel` . `payment_method_id` AS `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` AS `sales_channel.shippingMethodId` , `sales_channel` . `country_id` AS `sales_channel.countryId` , `sales_channel` . `analytics_id` AS `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` AS `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` AS `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` AS `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` AS `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` AS `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` AS `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` AS `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` AS `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` AS `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` AS `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` AS `sales_channel.taxCalculationType` , `sales_channel` . `access_key` AS `sales_channel.accessKey` , `sales_channel` . `configuration` AS `sales_channel.configuration` , `sales_channel` . `active` AS `sales_channel.active` , `sales_channel` . `hreflang_active` AS `sales_channel.hreflangActive` , `sales_channel` . `maintenance` AS `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` AS `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` AS `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` AS `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` AS `sales_channel.homeCmsPageVersionId` , `sales_channel` . `created_at` AS `sales_channel.createdAt` , `sales_channel` . `updated_at` AS `sales_channel.updatedAt` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) AS `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) AS `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) AS `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) AS `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) AS `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) AS `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) AS `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) AS `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name AS `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config AS `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled AS `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name AS `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title AS `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description AS `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords AS `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields AS `sales_channel.translation.customFields` , `sales_channel.translation` . created_at AS `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at AS `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id AS `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id AS `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` WHERE (`sales_channel` . `id` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
]
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` = ? )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` = 0xA290DC5C19E14CBEBBA6C40F9C59949F ); Copy
0.41 ms
2
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
"w2p2F9LIAJVoRISO8byJv2FY8R01ubH6 "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xA290DC5C19E14CBEBBA6C40F9C59949F ) AND (token = 'w2p2F9LIAJVoRISO8byJv2FY8R01ubH6' ) LIMIT 1 ; Copy
0.40 ms
1
SELECT `webi_configuration` . `id` AS `webi_configuration.id` , `webi_configuration` . `configuration_key` AS `webi_configuration.configurationKey` , `webi_configuration` . `configuration_value` AS `webi_configuration.configurationValue` , `webi_configuration` . `created_at` AS `webi_configuration.createdAt` , `webi_configuration` . `updated_at` AS `webi_configuration.updatedAt` FROM `webi_configuration`
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
0.39 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ? ) AND (configuration_key LIKE ? ) ORDER BY sales_channel_id ASC
Parameters :
[
null
"IntediaDoofinderSW6.config.% "
]
SELECT configuration_key , configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = NULL ) AND (configuration_key LIKE 'IntediaDoofinderSW6.config.%' ) ORDER BY sales_channel_id ASC ; Copy
0.38 ms
1
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
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
0.32 ms
1
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
0.32 ms
1
SELECT `acris_cookie_group` . `id` FROM `acris_cookie_group` ORDER BY `acris_cookie_group` . `is_default` DESC , `acris_cookie_group` . `is_default` DESC
SELECT `acris_cookie_group` . `id` FROM `acris_cookie_group` ORDER BY `acris_cookie_group` . `is_default` DESC , `acris_cookie_group` . `is_default` DESC ; Copy
0.30 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE (sales_channel_id IS NULL ) AND (configuration_key LIKE ? ) ORDER BY sales_channel_id ASC
Parameters :
[
"IntediaDoofinderSW6.config.% "
]
SELECT configuration_key , configuration_value FROM system_config WHERE (sales_channel_id IS NULL ) AND (configuration_key LIKE 'IntediaDoofinderSW6.config.%' ) ORDER BY sales_channel_id ASC ; Copy
0.29 ms
1
SELECT `payment_method` . `id` FROM `payment_method` WHERE (`payment_method` . `handler_identifier` = ? AND `payment_method` . `active` = ? )
Parameters :
[
"Kiener\MolliePayments\Handler\Method\ApplePayPayment "
true
]
SELECT `payment_method` . `id` FROM `payment_method` WHERE (`payment_method` . `handler_identifier` = 'Kiener\\MolliePayments\\Handler\\Method\\ApplePayPayment' AND `payment_method` . `active` = 1 ); Copy
0.28 ms
1
SELECT configuration_value FROM system_config WHERE (configuration_key = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) ORDER BY sales_channel_id IS NULL ASC LIMIT 1
Parameters :
[
"NetiNextStoreLocator.config.seoUrl "
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
]
SELECT configuration_value FROM system_config WHERE (configuration_key = 'NetiNextStoreLocator.config.seoUrl' ) AND ((sales_channel_id = 0xA290DC5C19E14CBEBBA6C40F9C59949F OR sales_channel_id IS NULL )) ORDER BY sales_channel_id IS NULL ASC LIMIT 1 ; Copy
0.27 ms
1
SELECT `neti_sl_filter` . `id` FROM `neti_sl_filter` WHERE (`neti_sl_filter` . `active` = ? ) ORDER BY `neti_sl_filter` . `position` ASC , `neti_sl_filter` . `position` ASC
SELECT `neti_sl_filter` . `id` FROM `neti_sl_filter` WHERE (`neti_sl_filter` . `active` = 1 ) ORDER BY `neti_sl_filter` . `position` ASC , `neti_sl_filter` . `position` ASC ; Copy
0.26 ms
1
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_fb_element` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-12-14T02:50:03+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2025-12-14T02:50:03+00:00' )) AND `active` = '1' ;
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_fb_element` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-12-14T02:50:03+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2025-12-14T02:50:03+00:00' )) AND `active` = '1' ; ; Copy
0.22 ms
1
SELECT `redirect` . `id` AS `redirect.id` , `redirect` . `oldUrl` AS `redirect.oldUrl` , `redirect` . `newUrl` AS `redirect.newUrl` , `redirect` . `active` AS `redirect.active` , `redirect` . `temporaryRedirect` AS `redirect.temporaryRedirect` , `redirect` . `externalRedirect` AS `redirect.externalRedirect` , `redirect` . `gone` AS `redirect.gone` , `redirect` . `created_at` AS `redirect.createdAt` , `redirect` . `updated_at` AS `redirect.updatedAt` FROM `redirect` WHERE (`redirect` . `oldUrl` = ? AND `redirect` . `active` = ? )
Parameters :
[
"/store-finder "
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` = '/store-finder' AND `redirect` . `active` = 1 ); Copy
0.22 ms
1
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_interrupter` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-12-14T02:50:03+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2025-12-14T02:50:03+00:00' )) AND `active` = '1' ;
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_interrupter` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-12-14T02:50:03+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2025-12-14T02:50:03+00:00' )) AND `active` = '1' ; ; Copy
0.21 ms
1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
; Copy
0.21 ms
1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1 ; Copy
0.20 ms
1
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' ))
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
0.18 ms
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
0.16 ms
1
SELECT `intedia_doofinder_layer` . `id` AS `intedia_doofinder_layer.id` , `intedia_doofinder_layer` . `doofinder_channel_id` AS `intedia_doofinder_layer.doofinderChannelId` , `intedia_doofinder_layer` . `doofinder_hash_id` AS `intedia_doofinder_layer.doofinderHashId` , `intedia_doofinder_layer` . `doofinder_store_id` AS `intedia_doofinder_layer.doofinderStoreId` , `intedia_doofinder_layer` . `domain_id` AS `intedia_doofinder_layer.domainId` , `intedia_doofinder_layer` . `trigger` AS `intedia_doofinder_layer.trigger` , `intedia_doofinder_layer` . `name` AS `intedia_doofinder_layer.name` , `intedia_doofinder_layer` . `status` AS `intedia_doofinder_layer.status` , `intedia_doofinder_layer` . `status_message` AS `intedia_doofinder_layer.statusMessage` , `intedia_doofinder_layer` . `status_date` AS `intedia_doofinder_layer.statusDate` , `intedia_doofinder_layer` . `status_received_date` AS `intedia_doofinder_layer.statusReceivedDate` , `intedia_doofinder_layer` . `created_at` AS `intedia_doofinder_layer.createdAt` , `intedia_doofinder_layer` . `updated_at` AS `intedia_doofinder_layer.updatedAt` FROM `intedia_doofinder_layer` WHERE (`intedia_doofinder_layer` . `domain_id` = ? )
Parameters :
[
b"ea¦\e OOLU¨UJB\x05 µ‚& "
]
SELECT `intedia_doofinder_layer` . `id` AS `intedia_doofinder_layer.id` , `intedia_doofinder_layer` . `doofinder_channel_id` AS `intedia_doofinder_layer.doofinderChannelId` , `intedia_doofinder_layer` . `doofinder_hash_id` AS `intedia_doofinder_layer.doofinderHashId` , `intedia_doofinder_layer` . `doofinder_store_id` AS `intedia_doofinder_layer.doofinderStoreId` , `intedia_doofinder_layer` . `domain_id` AS `intedia_doofinder_layer.domainId` , `intedia_doofinder_layer` . `trigger` AS `intedia_doofinder_layer.trigger` , `intedia_doofinder_layer` . `name` AS `intedia_doofinder_layer.name` , `intedia_doofinder_layer` . `status` AS `intedia_doofinder_layer.status` , `intedia_doofinder_layer` . `status_message` AS `intedia_doofinder_layer.statusMessage` , `intedia_doofinder_layer` . `status_date` AS `intedia_doofinder_layer.statusDate` , `intedia_doofinder_layer` . `status_received_date` AS `intedia_doofinder_layer.statusReceivedDate` , `intedia_doofinder_layer` . `created_at` AS `intedia_doofinder_layer.createdAt` , `intedia_doofinder_layer` . `updated_at` AS `intedia_doofinder_layer.updatedAt` FROM `intedia_doofinder_layer` WHERE (`intedia_doofinder_layer` . `domain_id` = 0x6561A61B4F4F4C55A8554A4205B58226 ); Copy
0.15 ms
1
SELECT `neti_store_locator_contact_form` . `id` FROM `neti_store_locator_contact_form` WHERE (`neti_store_locator_contact_form` . `active` = ? ) ORDER BY `neti_store_locator_contact_form` . `position` ASC , `neti_store_locator_contact_form` . `position` ASC
SELECT `neti_store_locator_contact_form` . `id` FROM `neti_store_locator_contact_form` WHERE (`neti_store_locator_contact_form` . `active` = 1 ) ORDER BY `neti_store_locator_contact_form` . `position` ASC , `neti_store_locator_contact_form` . `position` ASC ; Copy
0.15 ms
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ; Copy
0.14 ms
1
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
0.14 ms
1
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_fb_form` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-12-14T02:50:03+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2025-12-14T02:50:03+00:00' )) AND `active` = '1' ;
SELECT LOWER (HEX (`id` )) AS `id` FROM `moorl_fb_form` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-12-14T02:50:03+00:00' ) OR (`show_until` > `updated_at` AND `show_until` < '2025-12-14T02:50:03+00:00' )) AND `active` = '1' ; ; Copy
0.12 ms
1
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = ? AND `sales_channel_country` . `country_id` = ? )
Parameters :
[
b"óÉ▄\\x19 ßL¥╗ª─\x0F £Yöƒ "
b"""
…\x11 ¿o\x0F ŽM\x19 ©\x05 Þ$\n
\x15 ÚF ]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0xA290DC5C19E14CBEBBA6C40F9C59949F AND `sales_channel_country` . `country_id` = 0x8511BF6F0F8E4D19A905DE240A15DA46 ); Copy