68.06 ms
1
SELECT `pluszwei_seo_redirect` . `id` FROM `pluszwei_seo_redirect` WHERE (`pluszwei_seo_redirect` . `old_url` = ? ) LIMIT 1
Parameters :
[
"/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
]
SELECT `pluszwei_seo_redirect` . `id` FROM `pluszwei_seo_redirect` WHERE (`pluszwei_seo_redirect` . `old_url` = '/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' ) LIMIT 1 ; Copy
12.78 ms
1
UPDATE `pluszwei_seo_redirect` SET `hits` = ? , `last_request_at` = ? , `updated_at` = ? WHERE id = ?
Parameters :
[
7
"2024-11-23 10:05:46.286 "
"2024-11-23 10:05:46.289 "
b"\x01 ŸtÃlp"ɤ~┤┤Ðì¹ ]
UPDATE `pluszwei_seo_redirect` SET `hits` = 7 , `last_request_at` = '2024-11-23 10:05:46.286' , `updated_at` = '2024-11-23 10:05:46.289' WHERE id = 0x018FF774C76C702290CF7EB4B4D18DFB ; Copy
9.36 ms
1
"COMMIT"
3.79 ms
3
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` . `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` . `write_access` AS `app.integration.writeAccess` , `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` = ? )
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` . `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` . `write_access` AS `app.integration.writeAccess` ,
`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` = ? )
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` . `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` . `write_access` AS `app.integration.writeAccess` , `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 );
Copy
3.50 ms
3
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` . `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` . `write_access` AS `app.integration.writeAccess` , `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 Œ>Ûì"ps‹\f ~\x00 wTW\x07 ]
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` . `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` . `write_access` AS `app.integration.writeAccess` ,
`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` . `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` . `write_access` AS `app.integration.writeAccess` , `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 (0x018C3EDBEC2270738B0C7E0077545707 ); Copy
3.00 ms
3
SELECT LOWER (HEX (`script` . `app_id` )) AS `app_id` ,
`script` . `name` AS scriptName ,
`script` . `script` AS script ,
`script` . `hook` AS hook ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
`app` . `version` AS appVersion ,
`script` . `active` AS active
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` ! = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
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
2.87 ms
1
SELECT
sales_channel . id AS sales_channel_id ,
sales_channel . language_id AS sales_channel_default_language_id ,
sales_channel . currency_id AS sales_channel_currency_id ,
currency . factor AS sales_channel_currency_factor ,
GROUP_CONCAT (LOWER (HEX (sales_channel_language . language_id ))) AS sales_channel_language_ids
FROM sales_channel
INNER JOIN currency
ON sales_channel . currency_id = currency . id
LEFT JOIN sales_channel_language
ON sales_channel_language . sales_channel_id = sales_channel . id
WHERE sales_channel . id = ?
GROUP BY sales_channel . id , sales_channel . language_id , sales_channel . currency_id , currency . factor
Parameters :
[
b"\x01 ïò$Ù\r ~@░àüT¦╝Vu ]
SELECT
sales_channel . id AS sales_channel_id ,
sales_channel . language_id AS sales_channel_default_language_id ,
sales_channel . currency_id AS sales_channel_currency_id ,
currency . factor AS sales_channel_currency_factor ,
GROUP_CONCAT (LOWER (HEX (sales_channel_language . language_id ))) AS sales_channel_language_ids
FROM sales_channel
INNER JOIN currency
ON sales_channel . currency_id = currency . id
LEFT JOIN sales_channel_language
ON sales_channel_language . sales_channel_id = sales_channel . id
WHERE sales_channel . id = 0x018B9524EB0D7E40B0858154DDBC5675
GROUP BY sales_channel . id , sales_channel . language_id , sales_channel . currency_id , currency . factor ;
Copy
2.82 ms
1
SELECT CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) `key` , CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) url , LOWER (HEX (domain . id )) id , LOWER (HEX (sales_channel . id )) salesChannelId , LOWER (HEX (sales_channel . type_id )) typeId , LOWER (HEX (domain . snippet_set_id )) snippetSetId , LOWER (HEX (domain . currency_id )) currencyId , LOWER (HEX (domain . language_id )) languageId , LOWER (HEX (theme . id )) themeId , sales_channel . maintenance maintenance , sales_channel . maintenance_ip_whitelist maintenanceIpWhitelist , snippet_set . iso AS locale , theme . technical_name AS themeName , parentTheme . technical_name AS parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain . sales_channel_id = sales_channel . id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel . id = theme_sales_channel . sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set . id = domain . snippet_set_id LEFT JOIN theme theme ON theme_sales_channel . theme_id = theme . id LEFT JOIN theme parentTheme ON theme . parent_theme_id = parentTheme . id WHERE (sales_channel . type_id = UNHEX (? )) AND (sales_channel . active )
Parameters :
[
"8a243080f92e4c719546314b577cf82b "
]
SELECT CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) `key` , CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) url , LOWER (HEX (domain . id )) id , LOWER (HEX (sales_channel . id )) salesChannelId , LOWER (HEX (sales_channel . type_id )) typeId , LOWER (HEX (domain . snippet_set_id )) snippetSetId , LOWER (HEX (domain . currency_id )) currencyId , LOWER (HEX (domain . language_id )) languageId , LOWER (HEX (theme . id )) themeId , sales_channel . maintenance maintenance , sales_channel . maintenance_ip_whitelist maintenanceIpWhitelist , snippet_set . iso AS locale , theme . technical_name AS themeName , parentTheme . technical_name AS parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain . sales_channel_id = sales_channel . id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel . id = theme_sales_channel . sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set . id = domain . snippet_set_id LEFT JOIN theme theme ON theme_sales_channel . theme_id = theme . id LEFT JOIN theme parentTheme ON theme . parent_theme_id = parentTheme . id WHERE (sales_channel . type_id = UNHEX ('8a243080f92e4c719546314b577cf82b' )) AND (sales_channel . active ); Copy
2.78 ms
1
SELECT `pluszwei_seo_redirect` . `id` AS `pluszwei_seo_redirect.id` , `pluszwei_seo_redirect` . `old_url` AS `pluszwei_seo_redirect.oldUrl` , `pluszwei_seo_redirect` . `sales_channel_id` AS `pluszwei_seo_redirect.salesChannelId` , `pluszwei_seo_redirect` . `hits` AS `pluszwei_seo_redirect.hits` , `pluszwei_seo_redirect` . `new_url` AS `pluszwei_seo_redirect.newUrl` , `pluszwei_seo_redirect` . `referrers` AS `pluszwei_seo_redirect.referrers` , `pluszwei_seo_redirect` . `status_code` AS `pluszwei_seo_redirect.statusCode` , `pluszwei_seo_redirect` . `active` AS `pluszwei_seo_redirect.active` , `pluszwei_seo_redirect` . `format` AS `pluszwei_seo_redirect.format` , `pluszwei_seo_redirect` . `last_request_at` AS `pluszwei_seo_redirect.lastRequestAt` , `pluszwei_seo_redirect` . `created_at` AS `pluszwei_seo_redirect.createdAt` , `pluszwei_seo_redirect` . `updated_at` AS `pluszwei_seo_redirect.updatedAt` FROM `pluszwei_seo_redirect` WHERE `pluszwei_seo_redirect` . `id` IN (? )
Parameters :
[
b"\x01 ŸtÃlp"ɤ~┤┤Ðì¹ ]
SELECT `pluszwei_seo_redirect` . `id` AS `pluszwei_seo_redirect.id` , `pluszwei_seo_redirect` . `old_url` AS `pluszwei_seo_redirect.oldUrl` , `pluszwei_seo_redirect` . `sales_channel_id` AS `pluszwei_seo_redirect.salesChannelId` , `pluszwei_seo_redirect` . `hits` AS `pluszwei_seo_redirect.hits` , `pluszwei_seo_redirect` . `new_url` AS `pluszwei_seo_redirect.newUrl` , `pluszwei_seo_redirect` . `referrers` AS `pluszwei_seo_redirect.referrers` , `pluszwei_seo_redirect` . `status_code` AS `pluszwei_seo_redirect.statusCode` , `pluszwei_seo_redirect` . `active` AS `pluszwei_seo_redirect.active` , `pluszwei_seo_redirect` . `format` AS `pluszwei_seo_redirect.format` , `pluszwei_seo_redirect` . `last_request_at` AS `pluszwei_seo_redirect.lastRequestAt` , `pluszwei_seo_redirect` . `created_at` AS `pluszwei_seo_redirect.createdAt` , `pluszwei_seo_redirect` . `updated_at` AS `pluszwei_seo_redirect.updatedAt` FROM `pluszwei_seo_redirect` WHERE `pluszwei_seo_redirect` . `id` IN (0x018FF774C76C702290CF7EB4B4D18DFB ); Copy
2.62 ms
3
SELECT LOWER (HEX (`script` . `app_id` )) AS `app_id` ,
`script` . `name` AS name ,
`script` . `script` AS script ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
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
2.46 ms
3
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 Œ>Ûì"ps‹\f ~\x00 wTW\x07 ]
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 (0x018C3EDBEC2270738B0C7E0077545707 )); Copy
2.21 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC ; Copy
1.95 ms
1
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND (seo_path_info = ? )
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò\x01 ïò$Ù\r ~@░àüT¦╝Vusoluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x018A69406DFC703C89D2E685B3D159F2 ) AND ((sales_channel_id = 0x018B9524EB0D7E40B0858154DDBC5675 OR sales_channel_id IS NULL )) AND (seo_path_info = 'soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' );
Copy
1.85 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.analytics` . `id` AS `sales_channel.analytics.id` , `sales_channel.analytics` . `tracking_id` AS `sales_channel.analytics.trackingId` , `sales_channel.analytics` . `active` AS `sales_channel.analytics.active` , `sales_channel.analytics` . `track_orders` AS `sales_channel.analytics.trackOrders` , `sales_channel.analytics` . `anonymize_ip` AS `sales_channel.analytics.anonymizeIp` , `sales_channel.analytics` . `created_at` AS `sales_channel.analytics.createdAt` , `sales_channel.analytics` . `updated_at` AS `sales_channel.analytics.updatedAt` , `sales_channel` . `created_at` AS `sales_channel.createdAt` , `sales_channel` . `updated_at` AS `sales_channel.updatedAt` , `sales_channel.currency` . `id` AS `sales_channel.currency.id` , `sales_channel.currency` . `factor` AS `sales_channel.currency.factor` , `sales_channel.currency` . `symbol` AS `sales_channel.currency.symbol` , `sales_channel.currency` . `iso_code` AS `sales_channel.currency.isoCode` , `sales_channel.currency` . `position` AS `sales_channel.currency.position` , `sales_channel.currency` . `tax_free_from` AS `sales_channel.currency.taxFreeFrom` , `sales_channel.currency` . `item_rounding` AS `sales_channel.currency.itemRounding` , `sales_channel.currency` . `total_rounding` AS `sales_channel.currency.totalRounding` , `sales_channel.currency` . `created_at` AS `sales_channel.currency.createdAt` , `sales_channel.currency` . `updated_at` AS `sales_channel.currency.updatedAt` , `sales_channel.currency.translation.fallback_1.shortName` , `sales_channel.currency.translation.shortName` , COALESCE (`sales_channel.currency.translation.fallback_1.shortName` , `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation.shortName` ) AS `sales_channel.currency.shortName` , `sales_channel.currency.translation.fallback_1.name` , `sales_channel.currency.translation.name` , COALESCE (`sales_channel.currency.translation.fallback_1.name` , `sales_channel.currency.translation.name` , `sales_channel.currency.translation.name` ) AS `sales_channel.currency.name` , `sales_channel.currency.translation.fallback_1.customFields` , `sales_channel.currency.translation.customFields` , COALESCE (`sales_channel.currency.translation.fallback_1.customFields` , `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.customFields` ) AS `sales_channel.currency.customFields` , `sales_channel.currency.translation.fallback_1.createdAt` , `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation.fallback_1.updatedAt` , `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation.fallback_1.currencyId` , `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation.fallback_1.languageId` , `sales_channel.currency.translation.languageId` , `sales_channel.translation.fallback_1.name` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.fallback_1.name` , `sales_channel.translation.name` , `sales_channel.translation.name` ) AS `sales_channel.name` , `sales_channel.translation.fallback_1.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.fallback_1.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) AS `sales_channel.homeSlotConfig` , `sales_channel.translation.fallback_1.homeEnabled` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.fallback_1.homeEnabled` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) AS `sales_channel.homeEnabled` , `sales_channel.translation.fallback_1.homeName` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.fallback_1.homeName` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) AS `sales_channel.homeName` , `sales_channel.translation.fallback_1.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.fallback_1.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) AS `sales_channel.homeMetaTitle` , `sales_channel.translation.fallback_1.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.fallback_1.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) AS `sales_channel.homeMetaDescription` , `sales_channel.translation.fallback_1.homeKeywords` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.fallback_1.homeKeywords` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) AS `sales_channel.homeKeywords` , `sales_channel.translation.fallback_1.customFields` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.fallback_1.customFields` , `sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) AS `sales_channel.customFields` , `sales_channel.translation.fallback_1.createdAt` , `sales_channel.translation.createdAt` , `sales_channel.translation.fallback_1.updatedAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.fallback_1.salesChannelId` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.fallback_1.languageId` , `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` , `sales_channel.translation.fallback_1` . name AS `sales_channel.translation.fallback_1.name` , `sales_channel.translation.fallback_1` . home_slot_config AS `sales_channel.translation.fallback_1.homeSlotConfig` , `sales_channel.translation.fallback_1` . home_enabled AS `sales_channel.translation.fallback_1.homeEnabled` , `sales_channel.translation.fallback_1` . home_name AS `sales_channel.translation.fallback_1.homeName` , `sales_channel.translation.fallback_1` . home_meta_title AS `sales_channel.translation.fallback_1.homeMetaTitle` , `sales_channel.translation.fallback_1` . home_meta_description AS `sales_channel.translation.fallback_1.homeMetaDescription` , `sales_channel.translation.fallback_1` . home_keywords AS `sales_channel.translation.fallback_1.homeKeywords` , `sales_channel.translation.fallback_1` . custom_fields AS `sales_channel.translation.fallback_1.customFields` , `sales_channel.translation.fallback_1` . created_at AS `sales_channel.translation.fallback_1.createdAt` , `sales_channel.translation.fallback_1` . updated_at AS `sales_channel.translation.fallback_1.updatedAt` , `sales_channel.translation.fallback_1` . sales_channel_id AS `sales_channel.translation.fallback_1.salesChannelId` , `sales_channel.translation.fallback_1` . language_id AS `sales_channel.translation.fallback_1.languageId` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.fallback_1` ON `sales_channel.translation` . `sales_channel_id` = `sales_channel.translation.fallback_1` . `sales_channel_id` AND `sales_channel.translation.fallback_1` . language_id = ? WHERE `sales_channel.translation` . language_id = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id` LEFT JOIN (SELECT `sales_channel.currency.translation` . currency_id , `sales_channel.currency.translation` . short_name AS `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation` . name AS `sales_channel.currency.translation.name` , `sales_channel.currency.translation` . custom_fields AS `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation` . created_at AS `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation` . updated_at AS `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation` . currency_id AS `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation` . language_id AS `sales_channel.currency.translation.languageId` , `sales_channel.currency.translation.fallback_1` . short_name AS `sales_channel.currency.translation.fallback_1.shortName` , `sales_channel.currency.translation.fallback_1` . name AS `sales_channel.currency.translation.fallback_1.name` , `sales_channel.currency.translation.fallback_1` . custom_fields AS `sales_channel.currency.translation.fallback_1.customFields` , `sales_channel.currency.translation.fallback_1` . created_at AS `sales_channel.currency.translation.fallback_1.createdAt` , `sales_channel.currency.translation.fallback_1` . updated_at AS `sales_channel.currency.translation.fallback_1.updatedAt` , `sales_channel.currency.translation.fallback_1` . currency_id AS `sales_channel.currency.translation.fallback_1.currencyId` , `sales_channel.currency.translation.fallback_1` . language_id AS `sales_channel.currency.translation.fallback_1.languageId` FROM `currency_translation` `sales_channel.currency.translation` LEFT JOIN `currency_translation` `sales_channel.currency.translation.fallback_1` ON `sales_channel.currency.translation` . `currency_id` = `sales_channel.currency.translation.fallback_1` . `currency_id` AND `sales_channel.currency.translation.fallback_1` . language_id = ? WHERE `sales_channel.currency.translation` . language_id = ? ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id` WHERE `sales_channel` . `id` IN (? )
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 ïò$Ù\r ~@░àüT¦╝Vu ]
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.analytics` . `id` AS `sales_channel.analytics.id` ,
`sales_channel.analytics` . `tracking_id` AS `sales_channel.analytics.trackingId` ,
`sales_channel.analytics` . `active` AS `sales_channel.analytics.active` ,
`sales_channel.analytics` . `track_orders` AS `sales_channel.analytics.trackOrders` ,
`sales_channel.analytics` . `anonymize_ip` AS `sales_channel.analytics.anonymizeIp` ,
`sales_channel.analytics` . `created_at` AS `sales_channel.analytics.createdAt` ,
`sales_channel.analytics` . `updated_at` AS `sales_channel.analytics.updatedAt` ,
`sales_channel` . `created_at` AS `sales_channel.createdAt` ,
`sales_channel` . `updated_at` AS `sales_channel.updatedAt` ,
`sales_channel.currency` . `id` AS `sales_channel.currency.id` ,
`sales_channel.currency` . `factor` AS `sales_channel.currency.factor` ,
`sales_channel.currency` . `symbol` AS `sales_channel.currency.symbol` ,
`sales_channel.currency` . `iso_code` AS `sales_channel.currency.isoCode` ,
`sales_channel.currency` . `position` AS `sales_channel.currency.position` ,
`sales_channel.currency` . `tax_free_from` AS `sales_channel.currency.taxFreeFrom` ,
`sales_channel.currency` . `item_rounding` AS `sales_channel.currency.itemRounding` ,
`sales_channel.currency` . `total_rounding` AS `sales_channel.currency.totalRounding` ,
`sales_channel.currency` . `created_at` AS `sales_channel.currency.createdAt` ,
`sales_channel.currency` . `updated_at` AS `sales_channel.currency.updatedAt` ,
`sales_channel.currency.translation.fallback_1.shortName` ,
`sales_channel.currency.translation.shortName` ,
COALESCE (
`sales_channel.currency.translation.fallback_1.shortName` ,
`sales_channel.currency.translation.shortName` ,
`sales_channel.currency.translation.shortName`
) AS `sales_channel.currency.shortName` ,
`sales_channel.currency.translation.fallback_1.name` ,
`sales_channel.currency.translation.name` ,
COALESCE (
`sales_channel.currency.translation.fallback_1.name` ,
`sales_channel.currency.translation.name` ,
`sales_channel.currency.translation.name`
) AS `sales_channel.currency.name` ,
`sales_channel.currency.translation.fallback_1.customFields` ,
`sales_channel.currency.translation.customFields` ,
COALESCE (
`sales_channel.currency.translation.fallback_1.customFields` ,
`sales_channel.currency.translation.customFields` ,
`sales_channel.currency.translation.customFields`
) AS `sales_channel.currency.customFields` ,
`sales_channel.currency.translation.fallback_1.createdAt` ,
`sales_channel.currency.translation.createdAt` ,
`sales_channel.currency.translation.fallback_1.updatedAt` ,
`sales_channel.currency.translation.updatedAt` ,
`sales_channel.currency.translation.fallback_1.currencyId` ,
`sales_channel.currency.translation.currencyId` ,
`sales_channel.currency.translation.fallback_1.languageId` ,
`sales_channel.currency.translation.languageId` ,
`sales_channel.translation.fallback_1.name` ,
`sales_channel.translation.name` ,
COALESCE (
`sales_channel.translation.fallback_1.name` ,
`sales_channel.translation.name` ,
`sales_channel.translation.name`
) AS `sales_channel.name` ,
`sales_channel.translation.fallback_1.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig` ,
COALESCE (
`sales_channel.translation.fallback_1.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig`
) AS `sales_channel.homeSlotConfig` ,
`sales_channel.translation.fallback_1.homeEnabled` ,
`sales_channel.translation.homeEnabled` ,
COALESCE (
`sales_channel.translation.fallback_1.homeEnabled` ,
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled`
) AS `sales_channel.homeEnabled` ,
`sales_channel.translation.fallback_1.homeName` ,
`sales_channel.translation.homeName` ,
COALESCE (
`sales_channel.translation.fallback_1.homeName` ,
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName`
) AS `sales_channel.homeName` ,
`sales_channel.translation.fallback_1.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle` ,
COALESCE (
`sales_channel.translation.fallback_1.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle`
) AS `sales_channel.homeMetaTitle` ,
`sales_channel.translation.fallback_1.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription` ,
COALESCE (
`sales_channel.translation.fallback_1.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription`
) AS `sales_channel.homeMetaDescription` ,
`sales_channel.translation.fallback_1.homeKeywords` ,
`sales_channel.translation.homeKeywords` ,
COALESCE (
`sales_channel.translation.fallback_1.homeKeywords` ,
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords`
) AS `sales_channel.homeKeywords` ,
`sales_channel.translation.fallback_1.customFields` ,
`sales_channel.translation.customFields` ,
COALESCE (
`sales_channel.translation.fallback_1.customFields` ,
`sales_channel.translation.customFields` ,
`sales_channel.translation.customFields`
) AS `sales_channel.customFields` ,
`sales_channel.translation.fallback_1.createdAt` ,
`sales_channel.translation.createdAt` ,
`sales_channel.translation.fallback_1.updatedAt` ,
`sales_channel.translation.updatedAt` ,
`sales_channel.translation.fallback_1.salesChannelId` ,
`sales_channel.translation.salesChannelId` ,
`sales_channel.translation.fallback_1.languageId` ,
`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` ,
`sales_channel.translation.fallback_1` . name AS `sales_channel.translation.fallback_1.name` ,
`sales_channel.translation.fallback_1` . home_slot_config AS `sales_channel.translation.fallback_1.homeSlotConfig` ,
`sales_channel.translation.fallback_1` . home_enabled AS `sales_channel.translation.fallback_1.homeEnabled` ,
`sales_channel.translation.fallback_1` . home_name AS `sales_channel.translation.fallback_1.homeName` ,
`sales_channel.translation.fallback_1` . home_meta_title AS `sales_channel.translation.fallback_1.homeMetaTitle` ,
`sales_channel.translation.fallback_1` . home_meta_description AS `sales_channel.translation.fallback_1.homeMetaDescription` ,
`sales_channel.translation.fallback_1` . home_keywords AS `sales_channel.translation.fallback_1.homeKeywords` ,
`sales_channel.translation.fallback_1` . custom_fields AS `sales_channel.translation.fallback_1.customFields` ,
`sales_channel.translation.fallback_1` . created_at AS `sales_channel.translation.fallback_1.createdAt` ,
`sales_channel.translation.fallback_1` . updated_at AS `sales_channel.translation.fallback_1.updatedAt` ,
`sales_channel.translation.fallback_1` . sales_channel_id AS `sales_channel.translation.fallback_1.salesChannelId` ,
`sales_channel.translation.fallback_1` . language_id AS `sales_channel.translation.fallback_1.languageId`
FROM
`sales_channel_translation` `sales_channel.translation`
LEFT JOIN `sales_channel_translation` `sales_channel.translation.fallback_1` ON `sales_channel.translation` . `sales_channel_id` = `sales_channel.translation.fallback_1` . `sales_channel_id`
AND `sales_channel.translation.fallback_1` . language_id = ?
WHERE
`sales_channel.translation` . language_id = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id`
LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id`
LEFT JOIN (
SELECT
`sales_channel.currency.translation` . currency_id ,
`sales_channel.currency.translation` . short_name AS `sales_channel.currency.translation.shortName` ,
`sales_channel.currency.translation` . name AS `sales_channel.currency.translation.name` ,
`sales_channel.currency.translation` . custom_fields AS `sales_channel.currency.translation.customFields` ,
`sales_channel.currency.translation` . created_at AS `sales_channel.currency.translation.createdAt` ,
`sales_channel.currency.translation` . updated_at AS `sales_channel.currency.translation.updatedAt` ,
`sales_channel.currency.translation` . currency_id AS `sales_channel.currency.translation.currencyId` ,
`sales_channel.currency.translation` . language_id AS `sales_channel.currency.translation.languageId` ,
`sales_channel.currency.translation.fallback_1` . short_name AS `sales_channel.currency.translation.fallback_1.shortName` ,
`sales_channel.currency.translation.fallback_1` . name AS `sales_channel.currency.translation.fallback_1.name` ,
`sales_channel.currency.translation.fallback_1` . custom_fields AS `sales_channel.currency.translation.fallback_1.customFields` ,
`sales_channel.currency.translation.fallback_1` . created_at AS `sales_channel.currency.translation.fallback_1.createdAt` ,
`sales_channel.currency.translation.fallback_1` . updated_at AS `sales_channel.currency.translation.fallback_1.updatedAt` ,
`sales_channel.currency.translation.fallback_1` . currency_id AS `sales_channel.currency.translation.fallback_1.currencyId` ,
`sales_channel.currency.translation.fallback_1` . language_id AS `sales_channel.currency.translation.fallback_1.languageId`
FROM
`currency_translation` `sales_channel.currency.translation`
LEFT JOIN `currency_translation` `sales_channel.currency.translation.fallback_1` ON `sales_channel.currency.translation` . `currency_id` = `sales_channel.currency.translation.fallback_1` . `currency_id`
AND `sales_channel.currency.translation.fallback_1` . language_id = ?
WHERE
`sales_channel.currency.translation` . language_id = ?
) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `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.analytics` . `id` AS `sales_channel.analytics.id` , `sales_channel.analytics` . `tracking_id` AS `sales_channel.analytics.trackingId` , `sales_channel.analytics` . `active` AS `sales_channel.analytics.active` , `sales_channel.analytics` . `track_orders` AS `sales_channel.analytics.trackOrders` , `sales_channel.analytics` . `anonymize_ip` AS `sales_channel.analytics.anonymizeIp` , `sales_channel.analytics` . `created_at` AS `sales_channel.analytics.createdAt` , `sales_channel.analytics` . `updated_at` AS `sales_channel.analytics.updatedAt` , `sales_channel` . `created_at` AS `sales_channel.createdAt` , `sales_channel` . `updated_at` AS `sales_channel.updatedAt` , `sales_channel.currency` . `id` AS `sales_channel.currency.id` , `sales_channel.currency` . `factor` AS `sales_channel.currency.factor` , `sales_channel.currency` . `symbol` AS `sales_channel.currency.symbol` , `sales_channel.currency` . `iso_code` AS `sales_channel.currency.isoCode` , `sales_channel.currency` . `position` AS `sales_channel.currency.position` , `sales_channel.currency` . `tax_free_from` AS `sales_channel.currency.taxFreeFrom` , `sales_channel.currency` . `item_rounding` AS `sales_channel.currency.itemRounding` , `sales_channel.currency` . `total_rounding` AS `sales_channel.currency.totalRounding` , `sales_channel.currency` . `created_at` AS `sales_channel.currency.createdAt` , `sales_channel.currency` . `updated_at` AS `sales_channel.currency.updatedAt` , `sales_channel.currency.translation.fallback_1.shortName` , `sales_channel.currency.translation.shortName` , COALESCE (`sales_channel.currency.translation.fallback_1.shortName` , `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation.shortName` ) AS `sales_channel.currency.shortName` , `sales_channel.currency.translation.fallback_1.name` , `sales_channel.currency.translation.name` , COALESCE (`sales_channel.currency.translation.fallback_1.name` , `sales_channel.currency.translation.name` , `sales_channel.currency.translation.name` ) AS `sales_channel.currency.name` , `sales_channel.currency.translation.fallback_1.customFields` , `sales_channel.currency.translation.customFields` , COALESCE (`sales_channel.currency.translation.fallback_1.customFields` , `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.customFields` ) AS `sales_channel.currency.customFields` , `sales_channel.currency.translation.fallback_1.createdAt` , `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation.fallback_1.updatedAt` , `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation.fallback_1.currencyId` , `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation.fallback_1.languageId` , `sales_channel.currency.translation.languageId` , `sales_channel.translation.fallback_1.name` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.fallback_1.name` , `sales_channel.translation.name` , `sales_channel.translation.name` ) AS `sales_channel.name` , `sales_channel.translation.fallback_1.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.fallback_1.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) AS `sales_channel.homeSlotConfig` , `sales_channel.translation.fallback_1.homeEnabled` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.fallback_1.homeEnabled` , `sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) AS `sales_channel.homeEnabled` , `sales_channel.translation.fallback_1.homeName` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.fallback_1.homeName` , `sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) AS `sales_channel.homeName` , `sales_channel.translation.fallback_1.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.fallback_1.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) AS `sales_channel.homeMetaTitle` , `sales_channel.translation.fallback_1.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.fallback_1.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) AS `sales_channel.homeMetaDescription` , `sales_channel.translation.fallback_1.homeKeywords` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.fallback_1.homeKeywords` , `sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) AS `sales_channel.homeKeywords` , `sales_channel.translation.fallback_1.customFields` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.fallback_1.customFields` , `sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) AS `sales_channel.customFields` , `sales_channel.translation.fallback_1.createdAt` , `sales_channel.translation.createdAt` , `sales_channel.translation.fallback_1.updatedAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.fallback_1.salesChannelId` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.fallback_1.languageId` , `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` , `sales_channel.translation.fallback_1` . name AS `sales_channel.translation.fallback_1.name` , `sales_channel.translation.fallback_1` . home_slot_config AS `sales_channel.translation.fallback_1.homeSlotConfig` , `sales_channel.translation.fallback_1` . home_enabled AS `sales_channel.translation.fallback_1.homeEnabled` , `sales_channel.translation.fallback_1` . home_name AS `sales_channel.translation.fallback_1.homeName` , `sales_channel.translation.fallback_1` . home_meta_title AS `sales_channel.translation.fallback_1.homeMetaTitle` , `sales_channel.translation.fallback_1` . home_meta_description AS `sales_channel.translation.fallback_1.homeMetaDescription` , `sales_channel.translation.fallback_1` . home_keywords AS `sales_channel.translation.fallback_1.homeKeywords` , `sales_channel.translation.fallback_1` . custom_fields AS `sales_channel.translation.fallback_1.customFields` , `sales_channel.translation.fallback_1` . created_at AS `sales_channel.translation.fallback_1.createdAt` , `sales_channel.translation.fallback_1` . updated_at AS `sales_channel.translation.fallback_1.updatedAt` , `sales_channel.translation.fallback_1` . sales_channel_id AS `sales_channel.translation.fallback_1.salesChannelId` , `sales_channel.translation.fallback_1` . language_id AS `sales_channel.translation.fallback_1.languageId` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.fallback_1` ON `sales_channel.translation` . `sales_channel_id` = `sales_channel.translation.fallback_1` . `sales_channel_id` AND `sales_channel.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `sales_channel.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id` LEFT JOIN (SELECT `sales_channel.currency.translation` . currency_id , `sales_channel.currency.translation` . short_name AS `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation` . name AS `sales_channel.currency.translation.name` , `sales_channel.currency.translation` . custom_fields AS `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation` . created_at AS `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation` . updated_at AS `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation` . currency_id AS `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation` . language_id AS `sales_channel.currency.translation.languageId` , `sales_channel.currency.translation.fallback_1` . short_name AS `sales_channel.currency.translation.fallback_1.shortName` , `sales_channel.currency.translation.fallback_1` . name AS `sales_channel.currency.translation.fallback_1.name` , `sales_channel.currency.translation.fallback_1` . custom_fields AS `sales_channel.currency.translation.fallback_1.customFields` , `sales_channel.currency.translation.fallback_1` . created_at AS `sales_channel.currency.translation.fallback_1.createdAt` , `sales_channel.currency.translation.fallback_1` . updated_at AS `sales_channel.currency.translation.fallback_1.updatedAt` , `sales_channel.currency.translation.fallback_1` . currency_id AS `sales_channel.currency.translation.fallback_1.currencyId` , `sales_channel.currency.translation.fallback_1` . language_id AS `sales_channel.currency.translation.fallback_1.languageId` FROM `currency_translation` `sales_channel.currency.translation` LEFT JOIN `currency_translation` `sales_channel.currency.translation.fallback_1` ON `sales_channel.currency.translation` . `currency_id` = `sales_channel.currency.translation.fallback_1` . `currency_id` AND `sales_channel.currency.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `sales_channel.currency.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id` WHERE `sales_channel` . `id` IN (0x018B9524EB0D7E40B0858154DDBC5675 );
Copy
1.84 ms
1
SELECT `shipping_method` . `id` AS `shipping_method.id` , `shipping_method` . `active` AS `shipping_method.active` , `shipping_method` . `position` AS `shipping_method.position` , `shipping_method` . `availability_rule_id` AS `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` AS `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` AS `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` AS `shipping_method.taxType` , `shipping_method` . `tax_id` AS `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` AS `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` AS `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` AS `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` AS `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` AS `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` AS `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.fallback_1.name` , `shipping_method.deliveryTime.translation.name` , COALESCE (`shipping_method.deliveryTime.translation.fallback_1.name` , `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` ) AS `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.fallback_1.customFields` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.fallback_1.customFields` , `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` ) AS `shipping_method.deliveryTime.customFields` , `shipping_method.deliveryTime.translation.fallback_1.createdAt` , `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation.fallback_1.updatedAt` , `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId` , `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation.fallback_1.languageId` , `shipping_method.deliveryTime.translation.languageId` , `shipping_method.appShippingMethod` . `id` AS `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` AS `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` AS `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` AS `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` AS `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` AS `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` AS `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` AS `shipping_method.technicalName` , `shipping_method` . `created_at` AS `shipping_method.createdAt` , `shipping_method` . `updated_at` AS `shipping_method.updatedAt` , `shipping_method.media` . `id` AS `shipping_method.media.id` , `shipping_method.media` . `user_id` AS `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` AS `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` AS `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` AS `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` AS `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` AS `shipping_method.media.fileName` , `shipping_method.media` . `file_size` AS `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` AS `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` AS `shipping_method.media.metaData` , `shipping_method.media` . `config` AS `shipping_method.media.config` , `shipping_method.media` . `path` AS `shipping_method.media.path` , `shipping_method.media` . `private` AS `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` AS `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` AS `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` AS `shipping_method.media.updatedAt` , `shipping_method.media.translation.fallback_1.title` , `shipping_method.media.translation.title` , COALESCE (`shipping_method.media.translation.fallback_1.title` , `shipping_method.media.translation.title` , `shipping_method.media.translation.title` ) AS `shipping_method.media.title` , `shipping_method.media.translation.fallback_1.alt` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.fallback_1.alt` , `shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` ) AS `shipping_method.media.alt` , `shipping_method.media.translation.fallback_1.customFields` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.fallback_1.customFields` , `shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` ) AS `shipping_method.media.customFields` , `shipping_method.media.translation.fallback_1.createdAt` , `shipping_method.media.translation.createdAt` , `shipping_method.media.translation.fallback_1.updatedAt` , `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation.fallback_1.mediaId` , `shipping_method.media.translation.mediaId` , `shipping_method.media.translation.fallback_1.languageId` , `shipping_method.media.translation.languageId` , `shipping_method.translation.fallback_1.name` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.fallback_1.name` , `shipping_method.translation.name` , `shipping_method.translation.name` ) AS `shipping_method.name` , `shipping_method.translation.fallback_1.description` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.fallback_1.description` , `shipping_method.translation.description` , `shipping_method.translation.description` ) AS `shipping_method.description` , `shipping_method.translation.fallback_1.trackingUrl` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.fallback_1.trackingUrl` , `shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` ) AS `shipping_method.trackingUrl` , `shipping_method.translation.fallback_1.customFields` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.fallback_1.customFields` , `shipping_method.translation.customFields` , `shipping_method.translation.customFields` ) AS `shipping_method.customFields` , `shipping_method.translation.fallback_1.createdAt` , `shipping_method.translation.createdAt` , `shipping_method.translation.fallback_1.updatedAt` , `shipping_method.translation.updatedAt` , `shipping_method.translation.fallback_1.shippingMethodId` , `shipping_method.translation.shippingMethodId` , `shipping_method.translation.fallback_1.languageId` , `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation` . shipping_method_id , `shipping_method.translation` . name AS `shipping_method.translation.name` , `shipping_method.translation` . description AS `shipping_method.translation.description` , `shipping_method.translation` . tracking_url AS `shipping_method.translation.trackingUrl` , `shipping_method.translation` . custom_fields AS `shipping_method.translation.customFields` , `shipping_method.translation` . created_at AS `shipping_method.translation.createdAt` , `shipping_method.translation` . updated_at AS `shipping_method.translation.updatedAt` , `shipping_method.translation` . shipping_method_id AS `shipping_method.translation.shippingMethodId` , `shipping_method.translation` . language_id AS `shipping_method.translation.languageId` , `shipping_method.translation.fallback_1` . name AS `shipping_method.translation.fallback_1.name` , `shipping_method.translation.fallback_1` . description AS `shipping_method.translation.fallback_1.description` , `shipping_method.translation.fallback_1` . tracking_url AS `shipping_method.translation.fallback_1.trackingUrl` , `shipping_method.translation.fallback_1` . custom_fields AS `shipping_method.translation.fallback_1.customFields` , `shipping_method.translation.fallback_1` . created_at AS `shipping_method.translation.fallback_1.createdAt` , `shipping_method.translation.fallback_1` . updated_at AS `shipping_method.translation.fallback_1.updatedAt` , `shipping_method.translation.fallback_1` . shipping_method_id AS `shipping_method.translation.fallback_1.shippingMethodId` , `shipping_method.translation.fallback_1` . language_id AS `shipping_method.translation.fallback_1.languageId` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation` . `shipping_method_id` = `shipping_method.translation.fallback_1` . `shipping_method_id` AND `shipping_method.translation.fallback_1` . language_id = ? WHERE `shipping_method.translation` . language_id = ? ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . delivery_time_id , `shipping_method.deliveryTime.translation` . name AS `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation` . custom_fields AS `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation` . created_at AS `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation` . updated_at AS `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation` . delivery_time_id AS `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation` . language_id AS `shipping_method.deliveryTime.translation.languageId` , `shipping_method.deliveryTime.translation.fallback_1` . name AS `shipping_method.deliveryTime.translation.fallback_1.name` , `shipping_method.deliveryTime.translation.fallback_1` . custom_fields AS `shipping_method.deliveryTime.translation.fallback_1.customFields` , `shipping_method.deliveryTime.translation.fallback_1` . created_at AS `shipping_method.deliveryTime.translation.fallback_1.createdAt` , `shipping_method.deliveryTime.translation.fallback_1` . updated_at AS `shipping_method.deliveryTime.translation.fallback_1.updatedAt` , `shipping_method.deliveryTime.translation.fallback_1` . delivery_time_id AS `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId` , `shipping_method.deliveryTime.translation.fallback_1` . language_id AS `shipping_method.deliveryTime.translation.fallback_1.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation` . `delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1` . `delivery_time_id` AND `shipping_method.deliveryTime.translation.fallback_1` . language_id = ? WHERE `shipping_method.deliveryTime.translation` . language_id = ? ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . media_id , `shipping_method.media.translation` . title AS `shipping_method.media.translation.title` , `shipping_method.media.translation` . alt AS `shipping_method.media.translation.alt` , `shipping_method.media.translation` . custom_fields AS `shipping_method.media.translation.customFields` , `shipping_method.media.translation` . created_at AS `shipping_method.media.translation.createdAt` , `shipping_method.media.translation` . updated_at AS `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation` . media_id AS `shipping_method.media.translation.mediaId` , `shipping_method.media.translation` . language_id AS `shipping_method.media.translation.languageId` , `shipping_method.media.translation.fallback_1` . title AS `shipping_method.media.translation.fallback_1.title` , `shipping_method.media.translation.fallback_1` . alt AS `shipping_method.media.translation.fallback_1.alt` , `shipping_method.media.translation.fallback_1` . custom_fields AS `shipping_method.media.translation.fallback_1.customFields` , `shipping_method.media.translation.fallback_1` . created_at AS `shipping_method.media.translation.fallback_1.createdAt` , `shipping_method.media.translation.fallback_1` . updated_at AS `shipping_method.media.translation.fallback_1.updatedAt` , `shipping_method.media.translation.fallback_1` . media_id AS `shipping_method.media.translation.fallback_1.mediaId` , `shipping_method.media.translation.fallback_1` . language_id AS `shipping_method.media.translation.fallback_1.languageId` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.fallback_1` ON `shipping_method.media.translation` . `media_id` = `shipping_method.media.translation.fallback_1` . `media_id` AND `shipping_method.media.translation.fallback_1` . language_id = ? WHERE `shipping_method.media.translation` . language_id = ? ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (? )
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Šf\x13 ‰ésó³\x18 Þ\x1F ‹Ì^¡ ]
SELECT
`shipping_method` . `id` AS `shipping_method.id` ,
`shipping_method` . `active` AS `shipping_method.active` ,
`shipping_method` . `position` AS `shipping_method.position` ,
`shipping_method` . `availability_rule_id` AS `shipping_method.availabilityRuleId` ,
`shipping_method` . `media_id` AS `shipping_method.mediaId` ,
`shipping_method` . `delivery_time_id` AS `shipping_method.deliveryTimeId` ,
`shipping_method` . `tax_type` AS `shipping_method.taxType` ,
`shipping_method` . `tax_id` AS `shipping_method.taxId` ,
`shipping_method.deliveryTime` . `id` AS `shipping_method.deliveryTime.id` ,
`shipping_method.deliveryTime` . `min` AS `shipping_method.deliveryTime.min` ,
`shipping_method.deliveryTime` . `max` AS `shipping_method.deliveryTime.max` ,
`shipping_method.deliveryTime` . `unit` AS `shipping_method.deliveryTime.unit` ,
`shipping_method.deliveryTime` . `created_at` AS `shipping_method.deliveryTime.createdAt` ,
`shipping_method.deliveryTime` . `updated_at` AS `shipping_method.deliveryTime.updatedAt` ,
`shipping_method.deliveryTime.translation.fallback_1.name` ,
`shipping_method.deliveryTime.translation.name` ,
COALESCE (
`shipping_method.deliveryTime.translation.fallback_1.name` ,
`shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation.name`
) AS `shipping_method.deliveryTime.name` ,
`shipping_method.deliveryTime.translation.fallback_1.customFields` ,
`shipping_method.deliveryTime.translation.customFields` ,
COALESCE (
`shipping_method.deliveryTime.translation.fallback_1.customFields` ,
`shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation.customFields`
) AS `shipping_method.deliveryTime.customFields` ,
`shipping_method.deliveryTime.translation.fallback_1.createdAt` ,
`shipping_method.deliveryTime.translation.createdAt` ,
`shipping_method.deliveryTime.translation.fallback_1.updatedAt` ,
`shipping_method.deliveryTime.translation.updatedAt` ,
`shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId` ,
`shipping_method.deliveryTime.translation.deliveryTimeId` ,
`shipping_method.deliveryTime.translation.fallback_1.languageId` ,
`shipping_method.deliveryTime.translation.languageId` ,
`shipping_method.appShippingMethod` . `id` AS `shipping_method.appShippingMethod.id` ,
`shipping_method.appShippingMethod` . `app_name` AS `shipping_method.appShippingMethod.appName` ,
`shipping_method.appShippingMethod` . `identifier` AS `shipping_method.appShippingMethod.identifier` ,
`shipping_method.appShippingMethod` . `app_id` AS `shipping_method.appShippingMethod.appId` ,
`shipping_method.appShippingMethod` . `shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId` ,
`shipping_method.appShippingMethod` . `original_media_id` AS `shipping_method.appShippingMethod.originalMediaId` ,
`shipping_method.appShippingMethod` . `created_at` AS `shipping_method.appShippingMethod.createdAt` ,
`shipping_method.appShippingMethod` . `updated_at` AS `shipping_method.appShippingMethod.updatedAt` ,
`shipping_method` . `technical_name` AS `shipping_method.technicalName` ,
`shipping_method` . `created_at` AS `shipping_method.createdAt` ,
`shipping_method` . `updated_at` AS `shipping_method.updatedAt` ,
`shipping_method.media` . `id` AS `shipping_method.media.id` ,
`shipping_method.media` . `user_id` AS `shipping_method.media.userId` ,
`shipping_method.media` . `media_folder_id` AS `shipping_method.media.mediaFolderId` ,
`shipping_method.media` . `mime_type` AS `shipping_method.media.mimeType` ,
`shipping_method.media` . `file_extension` AS `shipping_method.media.fileExtension` ,
`shipping_method.media` . `uploaded_at` AS `shipping_method.media.uploadedAt` ,
`shipping_method.media` . `file_name` AS `shipping_method.media.fileName` ,
`shipping_method.media` . `file_size` AS `shipping_method.media.fileSize` ,
`shipping_method.media` . `media_type` AS `shipping_method.media.mediaTypeRaw` ,
`shipping_method.media` . `meta_data` AS `shipping_method.media.metaData` ,
`shipping_method.media` . `config` AS `shipping_method.media.config` ,
`shipping_method.media` . `path` AS `shipping_method.media.path` ,
`shipping_method.media` . `private` AS `shipping_method.media.private` ,
`shipping_method.media` . `thumbnails_ro` AS `shipping_method.media.thumbnailsRo` ,
`shipping_method.media` . `created_at` AS `shipping_method.media.createdAt` ,
`shipping_method.media` . `updated_at` AS `shipping_method.media.updatedAt` ,
`shipping_method.media.translation.fallback_1.title` ,
`shipping_method.media.translation.title` ,
COALESCE (
`shipping_method.media.translation.fallback_1.title` ,
`shipping_method.media.translation.title` ,
`shipping_method.media.translation.title`
) AS `shipping_method.media.title` ,
`shipping_method.media.translation.fallback_1.alt` ,
`shipping_method.media.translation.alt` ,
COALESCE (
`shipping_method.media.translation.fallback_1.alt` ,
`shipping_method.media.translation.alt` ,
`shipping_method.media.translation.alt`
) AS `shipping_method.media.alt` ,
`shipping_method.media.translation.fallback_1.customFields` ,
`shipping_method.media.translation.customFields` ,
COALESCE (
`shipping_method.media.translation.fallback_1.customFields` ,
`shipping_method.media.translation.customFields` ,
`shipping_method.media.translation.customFields`
) AS `shipping_method.media.customFields` ,
`shipping_method.media.translation.fallback_1.createdAt` ,
`shipping_method.media.translation.createdAt` ,
`shipping_method.media.translation.fallback_1.updatedAt` ,
`shipping_method.media.translation.updatedAt` ,
`shipping_method.media.translation.fallback_1.mediaId` ,
`shipping_method.media.translation.mediaId` ,
`shipping_method.media.translation.fallback_1.languageId` ,
`shipping_method.media.translation.languageId` ,
`shipping_method.translation.fallback_1.name` ,
`shipping_method.translation.name` ,
COALESCE (
`shipping_method.translation.fallback_1.name` ,
`shipping_method.translation.name` ,
`shipping_method.translation.name`
) AS `shipping_method.name` ,
`shipping_method.translation.fallback_1.description` ,
`shipping_method.translation.description` ,
COALESCE (
`shipping_method.translation.fallback_1.description` ,
`shipping_method.translation.description` ,
`shipping_method.translation.description`
) AS `shipping_method.description` ,
`shipping_method.translation.fallback_1.trackingUrl` ,
`shipping_method.translation.trackingUrl` ,
COALESCE (
`shipping_method.translation.fallback_1.trackingUrl` ,
`shipping_method.translation.trackingUrl` ,
`shipping_method.translation.trackingUrl`
) AS `shipping_method.trackingUrl` ,
`shipping_method.translation.fallback_1.customFields` ,
`shipping_method.translation.customFields` ,
COALESCE (
`shipping_method.translation.fallback_1.customFields` ,
`shipping_method.translation.customFields` ,
`shipping_method.translation.customFields`
) AS `shipping_method.customFields` ,
`shipping_method.translation.fallback_1.createdAt` ,
`shipping_method.translation.createdAt` ,
`shipping_method.translation.fallback_1.updatedAt` ,
`shipping_method.translation.updatedAt` ,
`shipping_method.translation.fallback_1.shippingMethodId` ,
`shipping_method.translation.shippingMethodId` ,
`shipping_method.translation.fallback_1.languageId` ,
`shipping_method.translation.languageId`
FROM
`shipping_method`
LEFT JOIN (
SELECT
`shipping_method.translation` . shipping_method_id ,
`shipping_method.translation` . name AS `shipping_method.translation.name` ,
`shipping_method.translation` . description AS `shipping_method.translation.description` ,
`shipping_method.translation` . tracking_url AS `shipping_method.translation.trackingUrl` ,
`shipping_method.translation` . custom_fields AS `shipping_method.translation.customFields` ,
`shipping_method.translation` . created_at AS `shipping_method.translation.createdAt` ,
`shipping_method.translation` . updated_at AS `shipping_method.translation.updatedAt` ,
`shipping_method.translation` . shipping_method_id AS `shipping_method.translation.shippingMethodId` ,
`shipping_method.translation` . language_id AS `shipping_method.translation.languageId` ,
`shipping_method.translation.fallback_1` . name AS `shipping_method.translation.fallback_1.name` ,
`shipping_method.translation.fallback_1` . description AS `shipping_method.translation.fallback_1.description` ,
`shipping_method.translation.fallback_1` . tracking_url AS `shipping_method.translation.fallback_1.trackingUrl` ,
`shipping_method.translation.fallback_1` . custom_fields AS `shipping_method.translation.fallback_1.customFields` ,
`shipping_method.translation.fallback_1` . created_at AS `shipping_method.translation.fallback_1.createdAt` ,
`shipping_method.translation.fallback_1` . updated_at AS `shipping_method.translation.fallback_1.updatedAt` ,
`shipping_method.translation.fallback_1` . shipping_method_id AS `shipping_method.translation.fallback_1.shippingMethodId` ,
`shipping_method.translation.fallback_1` . language_id AS `shipping_method.translation.fallback_1.languageId`
FROM
`shipping_method_translation` `shipping_method.translation`
LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation` . `shipping_method_id` = `shipping_method.translation.fallback_1` . `shipping_method_id`
AND `shipping_method.translation.fallback_1` . language_id = ?
WHERE
`shipping_method.translation` . language_id = ?
) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id`
LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id`
LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id`
LEFT JOIN (
SELECT
`shipping_method.deliveryTime.translation` . delivery_time_id ,
`shipping_method.deliveryTime.translation` . name AS `shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation` . custom_fields AS `shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation` . created_at AS `shipping_method.deliveryTime.translation.createdAt` ,
`shipping_method.deliveryTime.translation` . updated_at AS `shipping_method.deliveryTime.translation.updatedAt` ,
`shipping_method.deliveryTime.translation` . delivery_time_id AS `shipping_method.deliveryTime.translation.deliveryTimeId` ,
`shipping_method.deliveryTime.translation` . language_id AS `shipping_method.deliveryTime.translation.languageId` ,
`shipping_method.deliveryTime.translation.fallback_1` . name AS `shipping_method.deliveryTime.translation.fallback_1.name` ,
`shipping_method.deliveryTime.translation.fallback_1` . custom_fields AS `shipping_method.deliveryTime.translation.fallback_1.customFields` ,
`shipping_method.deliveryTime.translation.fallback_1` . created_at AS `shipping_method.deliveryTime.translation.fallback_1.createdAt` ,
`shipping_method.deliveryTime.translation.fallback_1` . updated_at AS `shipping_method.deliveryTime.translation.fallback_1.updatedAt` ,
`shipping_method.deliveryTime.translation.fallback_1` . delivery_time_id AS `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId` ,
`shipping_method.deliveryTime.translation.fallback_1` . language_id AS `shipping_method.deliveryTime.translation.fallback_1.languageId`
FROM
`delivery_time_translation` `shipping_method.deliveryTime.translation`
LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation` . `delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1` . `delivery_time_id`
AND `shipping_method.deliveryTime.translation.fallback_1` . language_id = ?
WHERE
`shipping_method.deliveryTime.translation` . language_id = ?
) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN (
SELECT
`shipping_method.media.translation` . media_id ,
`shipping_method.media.translation` . title AS `shipping_method.media.translation.title` ,
`shipping_method.media.translation` . alt AS `shipping_method.media.translation.alt` ,
`shipping_method.media.translation` . custom_fields AS `shipping_method.media.translation.customFields` ,
`shipping_method.media.translation` . created_at AS `shipping_method.media.translation.createdAt` ,
`shipping_method.media.translation` . updated_at AS `shipping_method.media.translation.updatedAt` ,
`shipping_method.media.translation` . media_id AS `shipping_method.media.translation.mediaId` ,
`shipping_method.media.translation` . language_id AS `shipping_method.media.translation.languageId` ,
`shipping_method.media.translation.fallback_1` . title AS `shipping_method.media.translation.fallback_1.title` ,
`shipping_method.media.translation.fallback_1` . alt AS `shipping_method.media.translation.fallback_1.alt` ,
`shipping_method.media.translation.fallback_1` . custom_fields AS `shipping_method.media.translation.fallback_1.customFields` ,
`shipping_method.media.translation.fallback_1` . created_at AS `shipping_method.media.translation.fallback_1.createdAt` ,
`shipping_method.media.translation.fallback_1` . updated_at AS `shipping_method.media.translation.fallback_1.updatedAt` ,
`shipping_method.media.translation.fallback_1` . media_id AS `shipping_method.media.translation.fallback_1.mediaId` ,
`shipping_method.media.translation.fallback_1` . language_id AS `shipping_method.media.translation.fallback_1.languageId`
FROM
`media_translation` `shipping_method.media.translation`
LEFT JOIN `media_translation` `shipping_method.media.translation.fallback_1` ON `shipping_method.media.translation` . `media_id` = `shipping_method.media.translation.fallback_1` . `media_id`
AND `shipping_method.media.translation.fallback_1` . language_id = ?
WHERE
`shipping_method.media.translation` . language_id = ?
) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id`
WHERE
`shipping_method` . `id` IN (? )
Copy
SELECT `shipping_method` . `id` AS `shipping_method.id` , `shipping_method` . `active` AS `shipping_method.active` , `shipping_method` . `position` AS `shipping_method.position` , `shipping_method` . `availability_rule_id` AS `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` AS `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` AS `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` AS `shipping_method.taxType` , `shipping_method` . `tax_id` AS `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` AS `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` AS `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` AS `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` AS `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` AS `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` AS `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.fallback_1.name` , `shipping_method.deliveryTime.translation.name` , COALESCE (`shipping_method.deliveryTime.translation.fallback_1.name` , `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` ) AS `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.fallback_1.customFields` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.fallback_1.customFields` , `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` ) AS `shipping_method.deliveryTime.customFields` , `shipping_method.deliveryTime.translation.fallback_1.createdAt` , `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation.fallback_1.updatedAt` , `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId` , `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation.fallback_1.languageId` , `shipping_method.deliveryTime.translation.languageId` , `shipping_method.appShippingMethod` . `id` AS `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` AS `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` AS `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` AS `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` AS `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` AS `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` AS `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` AS `shipping_method.technicalName` , `shipping_method` . `created_at` AS `shipping_method.createdAt` , `shipping_method` . `updated_at` AS `shipping_method.updatedAt` , `shipping_method.media` . `id` AS `shipping_method.media.id` , `shipping_method.media` . `user_id` AS `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` AS `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` AS `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` AS `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` AS `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` AS `shipping_method.media.fileName` , `shipping_method.media` . `file_size` AS `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` AS `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` AS `shipping_method.media.metaData` , `shipping_method.media` . `config` AS `shipping_method.media.config` , `shipping_method.media` . `path` AS `shipping_method.media.path` , `shipping_method.media` . `private` AS `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` AS `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` AS `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` AS `shipping_method.media.updatedAt` , `shipping_method.media.translation.fallback_1.title` , `shipping_method.media.translation.title` , COALESCE (`shipping_method.media.translation.fallback_1.title` , `shipping_method.media.translation.title` , `shipping_method.media.translation.title` ) AS `shipping_method.media.title` , `shipping_method.media.translation.fallback_1.alt` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.fallback_1.alt` , `shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` ) AS `shipping_method.media.alt` , `shipping_method.media.translation.fallback_1.customFields` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.fallback_1.customFields` , `shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` ) AS `shipping_method.media.customFields` , `shipping_method.media.translation.fallback_1.createdAt` , `shipping_method.media.translation.createdAt` , `shipping_method.media.translation.fallback_1.updatedAt` , `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation.fallback_1.mediaId` , `shipping_method.media.translation.mediaId` , `shipping_method.media.translation.fallback_1.languageId` , `shipping_method.media.translation.languageId` , `shipping_method.translation.fallback_1.name` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.fallback_1.name` , `shipping_method.translation.name` , `shipping_method.translation.name` ) AS `shipping_method.name` , `shipping_method.translation.fallback_1.description` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.fallback_1.description` , `shipping_method.translation.description` , `shipping_method.translation.description` ) AS `shipping_method.description` , `shipping_method.translation.fallback_1.trackingUrl` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.fallback_1.trackingUrl` , `shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` ) AS `shipping_method.trackingUrl` , `shipping_method.translation.fallback_1.customFields` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.fallback_1.customFields` , `shipping_method.translation.customFields` , `shipping_method.translation.customFields` ) AS `shipping_method.customFields` , `shipping_method.translation.fallback_1.createdAt` , `shipping_method.translation.createdAt` , `shipping_method.translation.fallback_1.updatedAt` , `shipping_method.translation.updatedAt` , `shipping_method.translation.fallback_1.shippingMethodId` , `shipping_method.translation.shippingMethodId` , `shipping_method.translation.fallback_1.languageId` , `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation` . shipping_method_id , `shipping_method.translation` . name AS `shipping_method.translation.name` , `shipping_method.translation` . description AS `shipping_method.translation.description` , `shipping_method.translation` . tracking_url AS `shipping_method.translation.trackingUrl` , `shipping_method.translation` . custom_fields AS `shipping_method.translation.customFields` , `shipping_method.translation` . created_at AS `shipping_method.translation.createdAt` , `shipping_method.translation` . updated_at AS `shipping_method.translation.updatedAt` , `shipping_method.translation` . shipping_method_id AS `shipping_method.translation.shippingMethodId` , `shipping_method.translation` . language_id AS `shipping_method.translation.languageId` , `shipping_method.translation.fallback_1` . name AS `shipping_method.translation.fallback_1.name` , `shipping_method.translation.fallback_1` . description AS `shipping_method.translation.fallback_1.description` , `shipping_method.translation.fallback_1` . tracking_url AS `shipping_method.translation.fallback_1.trackingUrl` , `shipping_method.translation.fallback_1` . custom_fields AS `shipping_method.translation.fallback_1.customFields` , `shipping_method.translation.fallback_1` . created_at AS `shipping_method.translation.fallback_1.createdAt` , `shipping_method.translation.fallback_1` . updated_at AS `shipping_method.translation.fallback_1.updatedAt` , `shipping_method.translation.fallback_1` . shipping_method_id AS `shipping_method.translation.fallback_1.shippingMethodId` , `shipping_method.translation.fallback_1` . language_id AS `shipping_method.translation.fallback_1.languageId` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation` . `shipping_method_id` = `shipping_method.translation.fallback_1` . `shipping_method_id` AND `shipping_method.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `shipping_method.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . delivery_time_id , `shipping_method.deliveryTime.translation` . name AS `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation` . custom_fields AS `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation` . created_at AS `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation` . updated_at AS `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation` . delivery_time_id AS `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation` . language_id AS `shipping_method.deliveryTime.translation.languageId` , `shipping_method.deliveryTime.translation.fallback_1` . name AS `shipping_method.deliveryTime.translation.fallback_1.name` , `shipping_method.deliveryTime.translation.fallback_1` . custom_fields AS `shipping_method.deliveryTime.translation.fallback_1.customFields` , `shipping_method.deliveryTime.translation.fallback_1` . created_at AS `shipping_method.deliveryTime.translation.fallback_1.createdAt` , `shipping_method.deliveryTime.translation.fallback_1` . updated_at AS `shipping_method.deliveryTime.translation.fallback_1.updatedAt` , `shipping_method.deliveryTime.translation.fallback_1` . delivery_time_id AS `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId` , `shipping_method.deliveryTime.translation.fallback_1` . language_id AS `shipping_method.deliveryTime.translation.fallback_1.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation` . `delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1` . `delivery_time_id` AND `shipping_method.deliveryTime.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `shipping_method.deliveryTime.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . media_id , `shipping_method.media.translation` . title AS `shipping_method.media.translation.title` , `shipping_method.media.translation` . alt AS `shipping_method.media.translation.alt` , `shipping_method.media.translation` . custom_fields AS `shipping_method.media.translation.customFields` , `shipping_method.media.translation` . created_at AS `shipping_method.media.translation.createdAt` , `shipping_method.media.translation` . updated_at AS `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation` . media_id AS `shipping_method.media.translation.mediaId` , `shipping_method.media.translation` . language_id AS `shipping_method.media.translation.languageId` , `shipping_method.media.translation.fallback_1` . title AS `shipping_method.media.translation.fallback_1.title` , `shipping_method.media.translation.fallback_1` . alt AS `shipping_method.media.translation.fallback_1.alt` , `shipping_method.media.translation.fallback_1` . custom_fields AS `shipping_method.media.translation.fallback_1.customFields` , `shipping_method.media.translation.fallback_1` . created_at AS `shipping_method.media.translation.fallback_1.createdAt` , `shipping_method.media.translation.fallback_1` . updated_at AS `shipping_method.media.translation.fallback_1.updatedAt` , `shipping_method.media.translation.fallback_1` . media_id AS `shipping_method.media.translation.fallback_1.mediaId` , `shipping_method.media.translation.fallback_1` . language_id AS `shipping_method.media.translation.fallback_1.languageId` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.fallback_1` ON `shipping_method.media.translation` . `media_id` = `shipping_method.media.translation.fallback_1` . `media_id` AND `shipping_method.media.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `shipping_method.media.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (0x018A661389E973F3B318DE1F8BCC5EA1 );
Copy
1.83 ms
1
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters :
[
"payload "
]
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload' ; Copy
1.70 ms
1
SELECT `payment_method` . `id` AS `payment_method.id` , `payment_method` . `plugin_id` AS `payment_method.pluginId` , `payment_method` . `handler_identifier` AS `payment_method.handlerIdentifier` , `payment_method` . `position` AS `payment_method.position` , `payment_method` . `active` AS `payment_method.active` , `payment_method` . `after_order_enabled` AS `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` AS `payment_method.availabilityRuleId` , `payment_method` . `media_id` AS `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` AS `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` AS `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` AS `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` AS `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` AS `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` AS `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` AS `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` AS `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` AS `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` AS `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` AS `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` AS `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` AS `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` AS `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` AS `payment_method.technicalName` , `payment_method` . `created_at` AS `payment_method.createdAt` , `payment_method` . `updated_at` AS `payment_method.updatedAt` , `payment_method.media` . `id` AS `payment_method.media.id` , `payment_method.media` . `user_id` AS `payment_method.media.userId` , `payment_method.media` . `media_folder_id` AS `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` AS `payment_method.media.mimeType` , `payment_method.media` . `file_extension` AS `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` AS `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` AS `payment_method.media.fileName` , `payment_method.media` . `file_size` AS `payment_method.media.fileSize` , `payment_method.media` . `media_type` AS `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` AS `payment_method.media.metaData` , `payment_method.media` . `config` AS `payment_method.media.config` , `payment_method.media` . `path` AS `payment_method.media.path` , `payment_method.media` . `private` AS `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` AS `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` AS `payment_method.media.createdAt` , `payment_method.media` . `updated_at` AS `payment_method.media.updatedAt` , `payment_method.media.translation.fallback_1.title` , `payment_method.media.translation.title` , COALESCE (`payment_method.media.translation.fallback_1.title` , `payment_method.media.translation.title` , `payment_method.media.translation.title` ) AS `payment_method.media.title` , `payment_method.media.translation.fallback_1.alt` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.fallback_1.alt` , `payment_method.media.translation.alt` , `payment_method.media.translation.alt` ) AS `payment_method.media.alt` , `payment_method.media.translation.fallback_1.customFields` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.fallback_1.customFields` , `payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` ) AS `payment_method.media.customFields` , `payment_method.media.translation.fallback_1.createdAt` , `payment_method.media.translation.createdAt` , `payment_method.media.translation.fallback_1.updatedAt` , `payment_method.media.translation.updatedAt` , `payment_method.media.translation.fallback_1.mediaId` , `payment_method.media.translation.mediaId` , `payment_method.media.translation.fallback_1.languageId` , `payment_method.media.translation.languageId` , `payment_method.translation.fallback_1.name` , `payment_method.translation.name` , COALESCE (`payment_method.translation.fallback_1.name` , `payment_method.translation.name` , `payment_method.translation.name` ) AS `payment_method.name` , `payment_method.translation.fallback_1.distinguishableName` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.fallback_1.distinguishableName` , `payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) AS `payment_method.distinguishableName` , `payment_method.translation.fallback_1.description` , `payment_method.translation.description` , COALESCE (`payment_method.translation.fallback_1.description` , `payment_method.translation.description` , `payment_method.translation.description` ) AS `payment_method.description` , `payment_method.translation.fallback_1.customFields` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.fallback_1.customFields` , `payment_method.translation.customFields` , `payment_method.translation.customFields` ) AS `payment_method.customFields` , `payment_method.translation.fallback_1.createdAt` , `payment_method.translation.createdAt` , `payment_method.translation.fallback_1.updatedAt` , `payment_method.translation.updatedAt` , `payment_method.translation.fallback_1.paymentMethodId` , `payment_method.translation.paymentMethodId` , `payment_method.translation.fallback_1.languageId` , `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation` . payment_method_id , `payment_method.translation` . name AS `payment_method.translation.name` , `payment_method.translation` . distinguishable_name AS `payment_method.translation.distinguishableName` , `payment_method.translation` . description AS `payment_method.translation.description` , `payment_method.translation` . custom_fields AS `payment_method.translation.customFields` , `payment_method.translation` . created_at AS `payment_method.translation.createdAt` , `payment_method.translation` . updated_at AS `payment_method.translation.updatedAt` , `payment_method.translation` . payment_method_id AS `payment_method.translation.paymentMethodId` , `payment_method.translation` . language_id AS `payment_method.translation.languageId` , `payment_method.translation.fallback_1` . name AS `payment_method.translation.fallback_1.name` , `payment_method.translation.fallback_1` . distinguishable_name AS `payment_method.translation.fallback_1.distinguishableName` , `payment_method.translation.fallback_1` . description AS `payment_method.translation.fallback_1.description` , `payment_method.translation.fallback_1` . custom_fields AS `payment_method.translation.fallback_1.customFields` , `payment_method.translation.fallback_1` . created_at AS `payment_method.translation.fallback_1.createdAt` , `payment_method.translation.fallback_1` . updated_at AS `payment_method.translation.fallback_1.updatedAt` , `payment_method.translation.fallback_1` . payment_method_id AS `payment_method.translation.fallback_1.paymentMethodId` , `payment_method.translation.fallback_1` . language_id AS `payment_method.translation.fallback_1.languageId` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.fallback_1` ON `payment_method.translation` . `payment_method_id` = `payment_method.translation.fallback_1` . `payment_method_id` AND `payment_method.translation.fallback_1` . language_id = ? WHERE `payment_method.translation` . language_id = ? ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.media.translation` . media_id , `payment_method.media.translation` . title AS `payment_method.media.translation.title` , `payment_method.media.translation` . alt AS `payment_method.media.translation.alt` , `payment_method.media.translation` . custom_fields AS `payment_method.media.translation.customFields` , `payment_method.media.translation` . created_at AS `payment_method.media.translation.createdAt` , `payment_method.media.translation` . updated_at AS `payment_method.media.translation.updatedAt` , `payment_method.media.translation` . media_id AS `payment_method.media.translation.mediaId` , `payment_method.media.translation` . language_id AS `payment_method.media.translation.languageId` , `payment_method.media.translation.fallback_1` . title AS `payment_method.media.translation.fallback_1.title` , `payment_method.media.translation.fallback_1` . alt AS `payment_method.media.translation.fallback_1.alt` , `payment_method.media.translation.fallback_1` . custom_fields AS `payment_method.media.translation.fallback_1.customFields` , `payment_method.media.translation.fallback_1` . created_at AS `payment_method.media.translation.fallback_1.createdAt` , `payment_method.media.translation.fallback_1` . updated_at AS `payment_method.media.translation.fallback_1.updatedAt` , `payment_method.media.translation.fallback_1` . media_id AS `payment_method.media.translation.fallback_1.mediaId` , `payment_method.media.translation.fallback_1` . language_id AS `payment_method.media.translation.fallback_1.languageId` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.fallback_1` ON `payment_method.media.translation` . `media_id` = `payment_method.media.translation.fallback_1` . `media_id` AND `payment_method.media.translation.fallback_1` . language_id = ? WHERE `payment_method.media.translation` . language_id = ? ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (? )
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Šf\x13 ‰Àp’´æq0\x1A Bsq ]
SELECT
`payment_method` . `id` AS `payment_method.id` ,
`payment_method` . `plugin_id` AS `payment_method.pluginId` ,
`payment_method` . `handler_identifier` AS `payment_method.handlerIdentifier` ,
`payment_method` . `position` AS `payment_method.position` ,
`payment_method` . `active` AS `payment_method.active` ,
`payment_method` . `after_order_enabled` AS `payment_method.afterOrderEnabled` ,
`payment_method` . `availability_rule_id` AS `payment_method.availabilityRuleId` ,
`payment_method` . `media_id` AS `payment_method.mediaId` ,
`payment_method.appPaymentMethod` . `id` AS `payment_method.appPaymentMethod.id` ,
`payment_method.appPaymentMethod` . `app_name` AS `payment_method.appPaymentMethod.appName` ,
`payment_method.appPaymentMethod` . `identifier` AS `payment_method.appPaymentMethod.identifier` ,
`payment_method.appPaymentMethod` . `pay_url` AS `payment_method.appPaymentMethod.payUrl` ,
`payment_method.appPaymentMethod` . `finalize_url` AS `payment_method.appPaymentMethod.finalizeUrl` ,
`payment_method.appPaymentMethod` . `validate_url` AS `payment_method.appPaymentMethod.validateUrl` ,
`payment_method.appPaymentMethod` . `capture_url` AS `payment_method.appPaymentMethod.captureUrl` ,
`payment_method.appPaymentMethod` . `refund_url` AS `payment_method.appPaymentMethod.refundUrl` ,
`payment_method.appPaymentMethod` . `recurring_url` AS `payment_method.appPaymentMethod.recurringUrl` ,
`payment_method.appPaymentMethod` . `app_id` AS `payment_method.appPaymentMethod.appId` ,
`payment_method.appPaymentMethod` . `original_media_id` AS `payment_method.appPaymentMethod.originalMediaId` ,
`payment_method.appPaymentMethod` . `payment_method_id` AS `payment_method.appPaymentMethod.paymentMethodId` ,
`payment_method.appPaymentMethod` . `created_at` AS `payment_method.appPaymentMethod.createdAt` ,
`payment_method.appPaymentMethod` . `updated_at` AS `payment_method.appPaymentMethod.updatedAt` ,
`payment_method` . `technical_name` AS `payment_method.technicalName` ,
`payment_method` . `created_at` AS `payment_method.createdAt` ,
`payment_method` . `updated_at` AS `payment_method.updatedAt` ,
`payment_method.media` . `id` AS `payment_method.media.id` ,
`payment_method.media` . `user_id` AS `payment_method.media.userId` ,
`payment_method.media` . `media_folder_id` AS `payment_method.media.mediaFolderId` ,
`payment_method.media` . `mime_type` AS `payment_method.media.mimeType` ,
`payment_method.media` . `file_extension` AS `payment_method.media.fileExtension` ,
`payment_method.media` . `uploaded_at` AS `payment_method.media.uploadedAt` ,
`payment_method.media` . `file_name` AS `payment_method.media.fileName` ,
`payment_method.media` . `file_size` AS `payment_method.media.fileSize` ,
`payment_method.media` . `media_type` AS `payment_method.media.mediaTypeRaw` ,
`payment_method.media` . `meta_data` AS `payment_method.media.metaData` ,
`payment_method.media` . `config` AS `payment_method.media.config` ,
`payment_method.media` . `path` AS `payment_method.media.path` ,
`payment_method.media` . `private` AS `payment_method.media.private` ,
`payment_method.media` . `thumbnails_ro` AS `payment_method.media.thumbnailsRo` ,
`payment_method.media` . `created_at` AS `payment_method.media.createdAt` ,
`payment_method.media` . `updated_at` AS `payment_method.media.updatedAt` ,
`payment_method.media.translation.fallback_1.title` ,
`payment_method.media.translation.title` ,
COALESCE (
`payment_method.media.translation.fallback_1.title` ,
`payment_method.media.translation.title` ,
`payment_method.media.translation.title`
) AS `payment_method.media.title` ,
`payment_method.media.translation.fallback_1.alt` ,
`payment_method.media.translation.alt` ,
COALESCE (
`payment_method.media.translation.fallback_1.alt` ,
`payment_method.media.translation.alt` ,
`payment_method.media.translation.alt`
) AS `payment_method.media.alt` ,
`payment_method.media.translation.fallback_1.customFields` ,
`payment_method.media.translation.customFields` ,
COALESCE (
`payment_method.media.translation.fallback_1.customFields` ,
`payment_method.media.translation.customFields` ,
`payment_method.media.translation.customFields`
) AS `payment_method.media.customFields` ,
`payment_method.media.translation.fallback_1.createdAt` ,
`payment_method.media.translation.createdAt` ,
`payment_method.media.translation.fallback_1.updatedAt` ,
`payment_method.media.translation.updatedAt` ,
`payment_method.media.translation.fallback_1.mediaId` ,
`payment_method.media.translation.mediaId` ,
`payment_method.media.translation.fallback_1.languageId` ,
`payment_method.media.translation.languageId` ,
`payment_method.translation.fallback_1.name` ,
`payment_method.translation.name` ,
COALESCE (
`payment_method.translation.fallback_1.name` ,
`payment_method.translation.name` ,
`payment_method.translation.name`
) AS `payment_method.name` ,
`payment_method.translation.fallback_1.distinguishableName` ,
`payment_method.translation.distinguishableName` ,
COALESCE (
`payment_method.translation.fallback_1.distinguishableName` ,
`payment_method.translation.distinguishableName` ,
`payment_method.translation.distinguishableName`
) AS `payment_method.distinguishableName` ,
`payment_method.translation.fallback_1.description` ,
`payment_method.translation.description` ,
COALESCE (
`payment_method.translation.fallback_1.description` ,
`payment_method.translation.description` ,
`payment_method.translation.description`
) AS `payment_method.description` ,
`payment_method.translation.fallback_1.customFields` ,
`payment_method.translation.customFields` ,
COALESCE (
`payment_method.translation.fallback_1.customFields` ,
`payment_method.translation.customFields` ,
`payment_method.translation.customFields`
) AS `payment_method.customFields` ,
`payment_method.translation.fallback_1.createdAt` ,
`payment_method.translation.createdAt` ,
`payment_method.translation.fallback_1.updatedAt` ,
`payment_method.translation.updatedAt` ,
`payment_method.translation.fallback_1.paymentMethodId` ,
`payment_method.translation.paymentMethodId` ,
`payment_method.translation.fallback_1.languageId` ,
`payment_method.translation.languageId`
FROM
`payment_method`
LEFT JOIN (
SELECT
`payment_method.translation` . payment_method_id ,
`payment_method.translation` . name AS `payment_method.translation.name` ,
`payment_method.translation` . distinguishable_name AS `payment_method.translation.distinguishableName` ,
`payment_method.translation` . description AS `payment_method.translation.description` ,
`payment_method.translation` . custom_fields AS `payment_method.translation.customFields` ,
`payment_method.translation` . created_at AS `payment_method.translation.createdAt` ,
`payment_method.translation` . updated_at AS `payment_method.translation.updatedAt` ,
`payment_method.translation` . payment_method_id AS `payment_method.translation.paymentMethodId` ,
`payment_method.translation` . language_id AS `payment_method.translation.languageId` ,
`payment_method.translation.fallback_1` . name AS `payment_method.translation.fallback_1.name` ,
`payment_method.translation.fallback_1` . distinguishable_name AS `payment_method.translation.fallback_1.distinguishableName` ,
`payment_method.translation.fallback_1` . description AS `payment_method.translation.fallback_1.description` ,
`payment_method.translation.fallback_1` . custom_fields AS `payment_method.translation.fallback_1.customFields` ,
`payment_method.translation.fallback_1` . created_at AS `payment_method.translation.fallback_1.createdAt` ,
`payment_method.translation.fallback_1` . updated_at AS `payment_method.translation.fallback_1.updatedAt` ,
`payment_method.translation.fallback_1` . payment_method_id AS `payment_method.translation.fallback_1.paymentMethodId` ,
`payment_method.translation.fallback_1` . language_id AS `payment_method.translation.fallback_1.languageId`
FROM
`payment_method_translation` `payment_method.translation`
LEFT JOIN `payment_method_translation` `payment_method.translation.fallback_1` ON `payment_method.translation` . `payment_method_id` = `payment_method.translation.fallback_1` . `payment_method_id`
AND `payment_method.translation.fallback_1` . language_id = ?
WHERE
`payment_method.translation` . language_id = ?
) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id`
LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id`
LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id`
LEFT JOIN (
SELECT
`payment_method.media.translation` . media_id ,
`payment_method.media.translation` . title AS `payment_method.media.translation.title` ,
`payment_method.media.translation` . alt AS `payment_method.media.translation.alt` ,
`payment_method.media.translation` . custom_fields AS `payment_method.media.translation.customFields` ,
`payment_method.media.translation` . created_at AS `payment_method.media.translation.createdAt` ,
`payment_method.media.translation` . updated_at AS `payment_method.media.translation.updatedAt` ,
`payment_method.media.translation` . media_id AS `payment_method.media.translation.mediaId` ,
`payment_method.media.translation` . language_id AS `payment_method.media.translation.languageId` ,
`payment_method.media.translation.fallback_1` . title AS `payment_method.media.translation.fallback_1.title` ,
`payment_method.media.translation.fallback_1` . alt AS `payment_method.media.translation.fallback_1.alt` ,
`payment_method.media.translation.fallback_1` . custom_fields AS `payment_method.media.translation.fallback_1.customFields` ,
`payment_method.media.translation.fallback_1` . created_at AS `payment_method.media.translation.fallback_1.createdAt` ,
`payment_method.media.translation.fallback_1` . updated_at AS `payment_method.media.translation.fallback_1.updatedAt` ,
`payment_method.media.translation.fallback_1` . media_id AS `payment_method.media.translation.fallback_1.mediaId` ,
`payment_method.media.translation.fallback_1` . language_id AS `payment_method.media.translation.fallback_1.languageId`
FROM
`media_translation` `payment_method.media.translation`
LEFT JOIN `media_translation` `payment_method.media.translation.fallback_1` ON `payment_method.media.translation` . `media_id` = `payment_method.media.translation.fallback_1` . `media_id`
AND `payment_method.media.translation.fallback_1` . language_id = ?
WHERE
`payment_method.media.translation` . language_id = ?
) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id`
WHERE
`payment_method` . `id` IN (? )
Copy
SELECT `payment_method` . `id` AS `payment_method.id` , `payment_method` . `plugin_id` AS `payment_method.pluginId` , `payment_method` . `handler_identifier` AS `payment_method.handlerIdentifier` , `payment_method` . `position` AS `payment_method.position` , `payment_method` . `active` AS `payment_method.active` , `payment_method` . `after_order_enabled` AS `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` AS `payment_method.availabilityRuleId` , `payment_method` . `media_id` AS `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` AS `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` AS `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` AS `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` AS `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` AS `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` AS `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` AS `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` AS `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` AS `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` AS `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` AS `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` AS `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` AS `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` AS `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` AS `payment_method.technicalName` , `payment_method` . `created_at` AS `payment_method.createdAt` , `payment_method` . `updated_at` AS `payment_method.updatedAt` , `payment_method.media` . `id` AS `payment_method.media.id` , `payment_method.media` . `user_id` AS `payment_method.media.userId` , `payment_method.media` . `media_folder_id` AS `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` AS `payment_method.media.mimeType` , `payment_method.media` . `file_extension` AS `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` AS `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` AS `payment_method.media.fileName` , `payment_method.media` . `file_size` AS `payment_method.media.fileSize` , `payment_method.media` . `media_type` AS `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` AS `payment_method.media.metaData` , `payment_method.media` . `config` AS `payment_method.media.config` , `payment_method.media` . `path` AS `payment_method.media.path` , `payment_method.media` . `private` AS `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` AS `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` AS `payment_method.media.createdAt` , `payment_method.media` . `updated_at` AS `payment_method.media.updatedAt` , `payment_method.media.translation.fallback_1.title` , `payment_method.media.translation.title` , COALESCE (`payment_method.media.translation.fallback_1.title` , `payment_method.media.translation.title` , `payment_method.media.translation.title` ) AS `payment_method.media.title` , `payment_method.media.translation.fallback_1.alt` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.fallback_1.alt` , `payment_method.media.translation.alt` , `payment_method.media.translation.alt` ) AS `payment_method.media.alt` , `payment_method.media.translation.fallback_1.customFields` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.fallback_1.customFields` , `payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` ) AS `payment_method.media.customFields` , `payment_method.media.translation.fallback_1.createdAt` , `payment_method.media.translation.createdAt` , `payment_method.media.translation.fallback_1.updatedAt` , `payment_method.media.translation.updatedAt` , `payment_method.media.translation.fallback_1.mediaId` , `payment_method.media.translation.mediaId` , `payment_method.media.translation.fallback_1.languageId` , `payment_method.media.translation.languageId` , `payment_method.translation.fallback_1.name` , `payment_method.translation.name` , COALESCE (`payment_method.translation.fallback_1.name` , `payment_method.translation.name` , `payment_method.translation.name` ) AS `payment_method.name` , `payment_method.translation.fallback_1.distinguishableName` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.fallback_1.distinguishableName` , `payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) AS `payment_method.distinguishableName` , `payment_method.translation.fallback_1.description` , `payment_method.translation.description` , COALESCE (`payment_method.translation.fallback_1.description` , `payment_method.translation.description` , `payment_method.translation.description` ) AS `payment_method.description` , `payment_method.translation.fallback_1.customFields` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.fallback_1.customFields` , `payment_method.translation.customFields` , `payment_method.translation.customFields` ) AS `payment_method.customFields` , `payment_method.translation.fallback_1.createdAt` , `payment_method.translation.createdAt` , `payment_method.translation.fallback_1.updatedAt` , `payment_method.translation.updatedAt` , `payment_method.translation.fallback_1.paymentMethodId` , `payment_method.translation.paymentMethodId` , `payment_method.translation.fallback_1.languageId` , `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation` . payment_method_id , `payment_method.translation` . name AS `payment_method.translation.name` , `payment_method.translation` . distinguishable_name AS `payment_method.translation.distinguishableName` , `payment_method.translation` . description AS `payment_method.translation.description` , `payment_method.translation` . custom_fields AS `payment_method.translation.customFields` , `payment_method.translation` . created_at AS `payment_method.translation.createdAt` , `payment_method.translation` . updated_at AS `payment_method.translation.updatedAt` , `payment_method.translation` . payment_method_id AS `payment_method.translation.paymentMethodId` , `payment_method.translation` . language_id AS `payment_method.translation.languageId` , `payment_method.translation.fallback_1` . name AS `payment_method.translation.fallback_1.name` , `payment_method.translation.fallback_1` . distinguishable_name AS `payment_method.translation.fallback_1.distinguishableName` , `payment_method.translation.fallback_1` . description AS `payment_method.translation.fallback_1.description` , `payment_method.translation.fallback_1` . custom_fields AS `payment_method.translation.fallback_1.customFields` , `payment_method.translation.fallback_1` . created_at AS `payment_method.translation.fallback_1.createdAt` , `payment_method.translation.fallback_1` . updated_at AS `payment_method.translation.fallback_1.updatedAt` , `payment_method.translation.fallback_1` . payment_method_id AS `payment_method.translation.fallback_1.paymentMethodId` , `payment_method.translation.fallback_1` . language_id AS `payment_method.translation.fallback_1.languageId` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.fallback_1` ON `payment_method.translation` . `payment_method_id` = `payment_method.translation.fallback_1` . `payment_method_id` AND `payment_method.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `payment_method.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.media.translation` . media_id , `payment_method.media.translation` . title AS `payment_method.media.translation.title` , `payment_method.media.translation` . alt AS `payment_method.media.translation.alt` , `payment_method.media.translation` . custom_fields AS `payment_method.media.translation.customFields` , `payment_method.media.translation` . created_at AS `payment_method.media.translation.createdAt` , `payment_method.media.translation` . updated_at AS `payment_method.media.translation.updatedAt` , `payment_method.media.translation` . media_id AS `payment_method.media.translation.mediaId` , `payment_method.media.translation` . language_id AS `payment_method.media.translation.languageId` , `payment_method.media.translation.fallback_1` . title AS `payment_method.media.translation.fallback_1.title` , `payment_method.media.translation.fallback_1` . alt AS `payment_method.media.translation.fallback_1.alt` , `payment_method.media.translation.fallback_1` . custom_fields AS `payment_method.media.translation.fallback_1.customFields` , `payment_method.media.translation.fallback_1` . created_at AS `payment_method.media.translation.fallback_1.createdAt` , `payment_method.media.translation.fallback_1` . updated_at AS `payment_method.media.translation.fallback_1.updatedAt` , `payment_method.media.translation.fallback_1` . media_id AS `payment_method.media.translation.fallback_1.mediaId` , `payment_method.media.translation.fallback_1` . language_id AS `payment_method.media.translation.fallback_1.languageId` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.fallback_1` ON `payment_method.media.translation` . `media_id` = `payment_method.media.translation.fallback_1` . `media_id` AND `payment_method.media.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `payment_method.media.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (0x018A661389C07092B4E671301A427371 );
Copy
1.69 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config . sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters :
[
b"\x01 ïò$Ù\r ~@░àüT¦╝Vu ]
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id = 0x018B9524EB0D7E40B0858154DDBC5675 OR system_config . sales_channel_id IS NULL ORDER BY sales_channel_id ASC ; Copy
1.46 ms
1
SELECT `tax_rule` . `id` AS `tax_rule.id` , `tax_rule` . `tax_rule_type_id` AS `tax_rule.taxRuleTypeId` , `tax_rule` . `country_id` AS `tax_rule.countryId` , `tax_rule` . `tax_rate` AS `tax_rule.taxRate` , `tax_rule` . `data` AS `tax_rule.data` , `tax_rule` . `tax_id` AS `tax_rule.taxId` , `tax_rule` . `active_from` AS `tax_rule.activeFrom` , `tax_rule.type` . `id` AS `tax_rule.type.id` , `tax_rule.type` . `technical_name` AS `tax_rule.type.technicalName` , `tax_rule.type` . `position` AS `tax_rule.type.position` , `tax_rule.type` . `created_at` AS `tax_rule.type.createdAt` , `tax_rule.type` . `updated_at` AS `tax_rule.type.updatedAt` , `tax_rule.type.translation.fallback_1.typeName` , `tax_rule.type.translation.typeName` , COALESCE (`tax_rule.type.translation.fallback_1.typeName` , `tax_rule.type.translation.typeName` , `tax_rule.type.translation.typeName` ) AS `tax_rule.type.typeName` , `tax_rule.type.translation.fallback_1.createdAt` , `tax_rule.type.translation.createdAt` , `tax_rule.type.translation.fallback_1.updatedAt` , `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation.fallback_1.taxRuleTypeId` , `tax_rule.type.translation.taxRuleTypeId` , `tax_rule.type.translation.fallback_1.languageId` , `tax_rule.type.translation.languageId` , `tax_rule` . `created_at` AS `tax_rule.createdAt` , `tax_rule` . `updated_at` AS `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule` . `tax_rule_type_id` = `tax_rule.type` . `id` LEFT JOIN (SELECT `tax_rule.type.translation` . tax_rule_type_id , `tax_rule.type.translation` . type_name AS `tax_rule.type.translation.typeName` , `tax_rule.type.translation` . created_at AS `tax_rule.type.translation.createdAt` , `tax_rule.type.translation` . updated_at AS `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation` . tax_rule_type_id AS `tax_rule.type.translation.taxRuleTypeId` , `tax_rule.type.translation` . language_id AS `tax_rule.type.translation.languageId` , `tax_rule.type.translation.fallback_1` . type_name AS `tax_rule.type.translation.fallback_1.typeName` , `tax_rule.type.translation.fallback_1` . created_at AS `tax_rule.type.translation.fallback_1.createdAt` , `tax_rule.type.translation.fallback_1` . updated_at AS `tax_rule.type.translation.fallback_1.updatedAt` , `tax_rule.type.translation.fallback_1` . tax_rule_type_id AS `tax_rule.type.translation.fallback_1.taxRuleTypeId` , `tax_rule.type.translation.fallback_1` . language_id AS `tax_rule.type.translation.fallback_1.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` LEFT JOIN `tax_rule_type_translation` `tax_rule.type.translation.fallback_1` ON `tax_rule.type.translation` . `tax_rule_type_id` = `tax_rule.type.translation.fallback_1` . `tax_rule_type_id` AND `tax_rule.type.translation.fallback_1` . language_id = ? WHERE `tax_rule.type.translation` . language_id = ? ) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation` . `tax_rule_type_id` = `tax_rule.type` . `id` WHERE (`tax_rule` . `tax_id` IN (? , ? , ? ))
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Šf\x13 Š\x01 r¨›\x1C È;ø§ï)\x01 Šf\x13 Š\x01 r¨›\x1C È;øîcZ\x01 Šf\x13 ´íq\x06 ‚\x07 ¶â;¾±Ï ]
SELECT `tax_rule` . `id` AS `tax_rule.id` , `tax_rule` . `tax_rule_type_id` AS `tax_rule.taxRuleTypeId` , `tax_rule` . `country_id` AS `tax_rule.countryId` , `tax_rule` . `tax_rate` AS `tax_rule.taxRate` , `tax_rule` . `data` AS `tax_rule.data` , `tax_rule` . `tax_id` AS `tax_rule.taxId` , `tax_rule` . `active_from` AS `tax_rule.activeFrom` , `tax_rule.type` . `id` AS `tax_rule.type.id` , `tax_rule.type` . `technical_name` AS `tax_rule.type.technicalName` , `tax_rule.type` . `position` AS `tax_rule.type.position` , `tax_rule.type` . `created_at` AS `tax_rule.type.createdAt` , `tax_rule.type` . `updated_at` AS `tax_rule.type.updatedAt` , `tax_rule.type.translation.fallback_1.typeName` , `tax_rule.type.translation.typeName` , COALESCE (`tax_rule.type.translation.fallback_1.typeName` , `tax_rule.type.translation.typeName` , `tax_rule.type.translation.typeName` ) AS `tax_rule.type.typeName` , `tax_rule.type.translation.fallback_1.createdAt` , `tax_rule.type.translation.createdAt` , `tax_rule.type.translation.fallback_1.updatedAt` , `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation.fallback_1.taxRuleTypeId` , `tax_rule.type.translation.taxRuleTypeId` , `tax_rule.type.translation.fallback_1.languageId` , `tax_rule.type.translation.languageId` , `tax_rule` . `created_at` AS `tax_rule.createdAt` , `tax_rule` . `updated_at` AS `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule` . `tax_rule_type_id` = `tax_rule.type` . `id` LEFT JOIN (SELECT `tax_rule.type.translation` . tax_rule_type_id , `tax_rule.type.translation` . type_name AS `tax_rule.type.translation.typeName` , `tax_rule.type.translation` . created_at AS `tax_rule.type.translation.createdAt` , `tax_rule.type.translation` . updated_at AS `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation` . tax_rule_type_id AS `tax_rule.type.translation.taxRuleTypeId` , `tax_rule.type.translation` . language_id AS `tax_rule.type.translation.languageId` , `tax_rule.type.translation.fallback_1` . type_name AS `tax_rule.type.translation.fallback_1.typeName` , `tax_rule.type.translation.fallback_1` . created_at AS `tax_rule.type.translation.fallback_1.createdAt` , `tax_rule.type.translation.fallback_1` . updated_at AS `tax_rule.type.translation.fallback_1.updatedAt` , `tax_rule.type.translation.fallback_1` . tax_rule_type_id AS `tax_rule.type.translation.fallback_1.taxRuleTypeId` , `tax_rule.type.translation.fallback_1` . language_id AS `tax_rule.type.translation.fallback_1.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` LEFT JOIN `tax_rule_type_translation` `tax_rule.type.translation.fallback_1` ON `tax_rule.type.translation` . `tax_rule_type_id` = `tax_rule.type.translation.fallback_1` . `tax_rule_type_id` AND `tax_rule.type.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `tax_rule.type.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation` . `tax_rule_type_id` = `tax_rule.type` . `id` WHERE (`tax_rule` . `tax_id` IN (0x018A66138A0172A89B1CC83BF8A7EF29 , 0x018A66138A0172A89B1CC83BF8EE635A , 0x018A6613B4ED71068207B6E23BBEB1CF ));
Copy
1.25 ms
1
SELECT `customer_group` . `id` AS `customer_group.id` , `customer_group` . `display_gross` AS `customer_group.displayGross` , `customer_group` . `registration_active` AS `customer_group.registrationActive` , `customer_group` . `created_at` AS `customer_group.createdAt` , `customer_group` . `updated_at` AS `customer_group.updatedAt` , `customer_group.translation.fallback_1.name` , `customer_group.translation.name` , COALESCE (`customer_group.translation.fallback_1.name` , `customer_group.translation.name` , `customer_group.translation.name` ) AS `customer_group.name` , `customer_group.translation.fallback_1.registrationTitle` , `customer_group.translation.registrationTitle` , COALESCE (`customer_group.translation.fallback_1.registrationTitle` , `customer_group.translation.registrationTitle` , `customer_group.translation.registrationTitle` ) AS `customer_group.registrationTitle` , `customer_group.translation.fallback_1.registrationIntroduction` , `customer_group.translation.registrationIntroduction` , COALESCE (`customer_group.translation.fallback_1.registrationIntroduction` , `customer_group.translation.registrationIntroduction` , `customer_group.translation.registrationIntroduction` ) AS `customer_group.registrationIntroduction` , `customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` , COALESCE (`customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` ) AS `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.fallback_1.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` , COALESCE (`customer_group.translation.fallback_1.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` ) AS `customer_group.registrationSeoMetaDescription` , `customer_group.translation.fallback_1.customFields` , `customer_group.translation.customFields` , COALESCE (`customer_group.translation.fallback_1.customFields` , `customer_group.translation.customFields` , `customer_group.translation.customFields` ) AS `customer_group.customFields` , `customer_group.translation.fallback_1.createdAt` , `customer_group.translation.createdAt` , `customer_group.translation.fallback_1.updatedAt` , `customer_group.translation.updatedAt` , `customer_group.translation.fallback_1.customerGroupId` , `customer_group.translation.customerGroupId` , `customer_group.translation.fallback_1.languageId` , `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation` . customer_group_id , `customer_group.translation` . name AS `customer_group.translation.name` , `customer_group.translation` . registration_title AS `customer_group.translation.registrationTitle` , `customer_group.translation` . registration_introduction AS `customer_group.translation.registrationIntroduction` , `customer_group.translation` . registration_only_company_registration AS `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation` . registration_seo_meta_description AS `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation` . custom_fields AS `customer_group.translation.customFields` , `customer_group.translation` . created_at AS `customer_group.translation.createdAt` , `customer_group.translation` . updated_at AS `customer_group.translation.updatedAt` , `customer_group.translation` . customer_group_id AS `customer_group.translation.customerGroupId` , `customer_group.translation` . language_id AS `customer_group.translation.languageId` , `customer_group.translation.fallback_1` . name AS `customer_group.translation.fallback_1.name` , `customer_group.translation.fallback_1` . registration_title AS `customer_group.translation.fallback_1.registrationTitle` , `customer_group.translation.fallback_1` . registration_introduction AS `customer_group.translation.fallback_1.registrationIntroduction` , `customer_group.translation.fallback_1` . registration_only_company_registration AS `customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` , `customer_group.translation.fallback_1` . registration_seo_meta_description AS `customer_group.translation.fallback_1.registrationSeoMetaDescription` , `customer_group.translation.fallback_1` . custom_fields AS `customer_group.translation.fallback_1.customFields` , `customer_group.translation.fallback_1` . created_at AS `customer_group.translation.fallback_1.createdAt` , `customer_group.translation.fallback_1` . updated_at AS `customer_group.translation.fallback_1.updatedAt` , `customer_group.translation.fallback_1` . customer_group_id AS `customer_group.translation.fallback_1.customerGroupId` , `customer_group.translation.fallback_1` . language_id AS `customer_group.translation.fallback_1.languageId` FROM `customer_group_translation` `customer_group.translation` LEFT JOIN `customer_group_translation` `customer_group.translation.fallback_1` ON `customer_group.translation` . `customer_group_id` = `customer_group.translation.fallback_1` . `customer_group_id` AND `customer_group.translation.fallback_1` . language_id = ? WHERE `customer_group.translation` . language_id = ? ) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id` WHERE `customer_group` . `id` IN (? )
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"¤¢P\x18 ËìAÏ¡╩\x10 ┘O╚¢Í "
]
SELECT
`customer_group` . `id` AS `customer_group.id` ,
`customer_group` . `display_gross` AS `customer_group.displayGross` ,
`customer_group` . `registration_active` AS `customer_group.registrationActive` ,
`customer_group` . `created_at` AS `customer_group.createdAt` ,
`customer_group` . `updated_at` AS `customer_group.updatedAt` ,
`customer_group.translation.fallback_1.name` ,
`customer_group.translation.name` ,
COALESCE (
`customer_group.translation.fallback_1.name` ,
`customer_group.translation.name` ,
`customer_group.translation.name`
) AS `customer_group.name` ,
`customer_group.translation.fallback_1.registrationTitle` ,
`customer_group.translation.registrationTitle` ,
COALESCE (
`customer_group.translation.fallback_1.registrationTitle` ,
`customer_group.translation.registrationTitle` ,
`customer_group.translation.registrationTitle`
) AS `customer_group.registrationTitle` ,
`customer_group.translation.fallback_1.registrationIntroduction` ,
`customer_group.translation.registrationIntroduction` ,
COALESCE (
`customer_group.translation.fallback_1.registrationIntroduction` ,
`customer_group.translation.registrationIntroduction` ,
`customer_group.translation.registrationIntroduction`
) AS `customer_group.registrationIntroduction` ,
`customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` ,
`customer_group.translation.registrationOnlyCompanyRegistration` ,
COALESCE (
`customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` ,
`customer_group.translation.registrationOnlyCompanyRegistration` ,
`customer_group.translation.registrationOnlyCompanyRegistration`
) AS `customer_group.registrationOnlyCompanyRegistration` ,
`customer_group.translation.fallback_1.registrationSeoMetaDescription` ,
`customer_group.translation.registrationSeoMetaDescription` ,
COALESCE (
`customer_group.translation.fallback_1.registrationSeoMetaDescription` ,
`customer_group.translation.registrationSeoMetaDescription` ,
`customer_group.translation.registrationSeoMetaDescription`
) AS `customer_group.registrationSeoMetaDescription` ,
`customer_group.translation.fallback_1.customFields` ,
`customer_group.translation.customFields` ,
COALESCE (
`customer_group.translation.fallback_1.customFields` ,
`customer_group.translation.customFields` ,
`customer_group.translation.customFields`
) AS `customer_group.customFields` ,
`customer_group.translation.fallback_1.createdAt` ,
`customer_group.translation.createdAt` ,
`customer_group.translation.fallback_1.updatedAt` ,
`customer_group.translation.updatedAt` ,
`customer_group.translation.fallback_1.customerGroupId` ,
`customer_group.translation.customerGroupId` ,
`customer_group.translation.fallback_1.languageId` ,
`customer_group.translation.languageId`
FROM
`customer_group`
LEFT JOIN (
SELECT
`customer_group.translation` . customer_group_id ,
`customer_group.translation` . name AS `customer_group.translation.name` ,
`customer_group.translation` . registration_title AS `customer_group.translation.registrationTitle` ,
`customer_group.translation` . registration_introduction AS `customer_group.translation.registrationIntroduction` ,
`customer_group.translation` . registration_only_company_registration AS `customer_group.translation.registrationOnlyCompanyRegistration` ,
`customer_group.translation` . registration_seo_meta_description AS `customer_group.translation.registrationSeoMetaDescription` ,
`customer_group.translation` . custom_fields AS `customer_group.translation.customFields` ,
`customer_group.translation` . created_at AS `customer_group.translation.createdAt` ,
`customer_group.translation` . updated_at AS `customer_group.translation.updatedAt` ,
`customer_group.translation` . customer_group_id AS `customer_group.translation.customerGroupId` ,
`customer_group.translation` . language_id AS `customer_group.translation.languageId` ,
`customer_group.translation.fallback_1` . name AS `customer_group.translation.fallback_1.name` ,
`customer_group.translation.fallback_1` . registration_title AS `customer_group.translation.fallback_1.registrationTitle` ,
`customer_group.translation.fallback_1` . registration_introduction AS `customer_group.translation.fallback_1.registrationIntroduction` ,
`customer_group.translation.fallback_1` . registration_only_company_registration AS `customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` ,
`customer_group.translation.fallback_1` . registration_seo_meta_description AS `customer_group.translation.fallback_1.registrationSeoMetaDescription` ,
`customer_group.translation.fallback_1` . custom_fields AS `customer_group.translation.fallback_1.customFields` ,
`customer_group.translation.fallback_1` . created_at AS `customer_group.translation.fallback_1.createdAt` ,
`customer_group.translation.fallback_1` . updated_at AS `customer_group.translation.fallback_1.updatedAt` ,
`customer_group.translation.fallback_1` . customer_group_id AS `customer_group.translation.fallback_1.customerGroupId` ,
`customer_group.translation.fallback_1` . language_id AS `customer_group.translation.fallback_1.languageId`
FROM
`customer_group_translation` `customer_group.translation`
LEFT JOIN `customer_group_translation` `customer_group.translation.fallback_1` ON `customer_group.translation` . `customer_group_id` = `customer_group.translation.fallback_1` . `customer_group_id`
AND `customer_group.translation.fallback_1` . language_id = ?
WHERE
`customer_group.translation` . language_id = ?
) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id`
WHERE
`customer_group` . `id` IN (? )
Copy
SELECT `customer_group` . `id` AS `customer_group.id` , `customer_group` . `display_gross` AS `customer_group.displayGross` , `customer_group` . `registration_active` AS `customer_group.registrationActive` , `customer_group` . `created_at` AS `customer_group.createdAt` , `customer_group` . `updated_at` AS `customer_group.updatedAt` , `customer_group.translation.fallback_1.name` , `customer_group.translation.name` , COALESCE (`customer_group.translation.fallback_1.name` , `customer_group.translation.name` , `customer_group.translation.name` ) AS `customer_group.name` , `customer_group.translation.fallback_1.registrationTitle` , `customer_group.translation.registrationTitle` , COALESCE (`customer_group.translation.fallback_1.registrationTitle` , `customer_group.translation.registrationTitle` , `customer_group.translation.registrationTitle` ) AS `customer_group.registrationTitle` , `customer_group.translation.fallback_1.registrationIntroduction` , `customer_group.translation.registrationIntroduction` , COALESCE (`customer_group.translation.fallback_1.registrationIntroduction` , `customer_group.translation.registrationIntroduction` , `customer_group.translation.registrationIntroduction` ) AS `customer_group.registrationIntroduction` , `customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` , COALESCE (`customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` ) AS `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.fallback_1.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` , COALESCE (`customer_group.translation.fallback_1.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` ) AS `customer_group.registrationSeoMetaDescription` , `customer_group.translation.fallback_1.customFields` , `customer_group.translation.customFields` , COALESCE (`customer_group.translation.fallback_1.customFields` , `customer_group.translation.customFields` , `customer_group.translation.customFields` ) AS `customer_group.customFields` , `customer_group.translation.fallback_1.createdAt` , `customer_group.translation.createdAt` , `customer_group.translation.fallback_1.updatedAt` , `customer_group.translation.updatedAt` , `customer_group.translation.fallback_1.customerGroupId` , `customer_group.translation.customerGroupId` , `customer_group.translation.fallback_1.languageId` , `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation` . customer_group_id , `customer_group.translation` . name AS `customer_group.translation.name` , `customer_group.translation` . registration_title AS `customer_group.translation.registrationTitle` , `customer_group.translation` . registration_introduction AS `customer_group.translation.registrationIntroduction` , `customer_group.translation` . registration_only_company_registration AS `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation` . registration_seo_meta_description AS `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation` . custom_fields AS `customer_group.translation.customFields` , `customer_group.translation` . created_at AS `customer_group.translation.createdAt` , `customer_group.translation` . updated_at AS `customer_group.translation.updatedAt` , `customer_group.translation` . customer_group_id AS `customer_group.translation.customerGroupId` , `customer_group.translation` . language_id AS `customer_group.translation.languageId` , `customer_group.translation.fallback_1` . name AS `customer_group.translation.fallback_1.name` , `customer_group.translation.fallback_1` . registration_title AS `customer_group.translation.fallback_1.registrationTitle` , `customer_group.translation.fallback_1` . registration_introduction AS `customer_group.translation.fallback_1.registrationIntroduction` , `customer_group.translation.fallback_1` . registration_only_company_registration AS `customer_group.translation.fallback_1.registrationOnlyCompanyRegistration` , `customer_group.translation.fallback_1` . registration_seo_meta_description AS `customer_group.translation.fallback_1.registrationSeoMetaDescription` , `customer_group.translation.fallback_1` . custom_fields AS `customer_group.translation.fallback_1.customFields` , `customer_group.translation.fallback_1` . created_at AS `customer_group.translation.fallback_1.createdAt` , `customer_group.translation.fallback_1` . updated_at AS `customer_group.translation.fallback_1.updatedAt` , `customer_group.translation.fallback_1` . customer_group_id AS `customer_group.translation.fallback_1.customerGroupId` , `customer_group.translation.fallback_1` . language_id AS `customer_group.translation.fallback_1.languageId` FROM `customer_group_translation` `customer_group.translation` LEFT JOIN `customer_group_translation` `customer_group.translation.fallback_1` ON `customer_group.translation` . `customer_group_id` = `customer_group.translation.fallback_1` . `customer_group_id` AND `customer_group.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `customer_group.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id` WHERE `customer_group` . `id` IN (0xCFBD5018D38D41D8ADCA10D94FC8BDD6 );
Copy
1.22 ms
1
SELECT `country` . `id` AS `country.id` , `country` . `iso` AS `country.iso` , `country` . `position` AS `country.position` , `country` . `active` AS `country.active` , `country` . `shipping_available` AS `country.shippingAvailable` , `country` . `iso3` AS `country.iso3` , `country` . `display_state_in_registration` AS `country.displayStateInRegistration` , `country` . `force_state_in_registration` AS `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` AS `country.checkVatIdPattern` , `country` . `vat_id_required` AS `country.vatIdRequired` , `country` . `vat_id_pattern` AS `country.vatIdPattern` , `country` . `customer_tax` AS `country.customerTax` , `country` . `company_tax` AS `country.companyTax` , `country` . `postal_code_required` AS `country.postalCodeRequired` , `country` . `check_postal_code_pattern` AS `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` AS `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` AS `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` AS `country.defaultPostalCodePattern` , `country` . `created_at` AS `country.createdAt` , `country` . `updated_at` AS `country.updatedAt` , `country.translation.fallback_1.name` , `country.translation.name` , COALESCE (`country.translation.fallback_1.name` , `country.translation.name` , `country.translation.name` ) AS `country.name` , `country.translation.fallback_1.addressFormat` , `country.translation.addressFormat` , COALESCE (`country.translation.fallback_1.addressFormat` , `country.translation.addressFormat` , `country.translation.addressFormat` ) AS `country.addressFormat` , `country.translation.fallback_1.customFields` , `country.translation.customFields` , COALESCE (`country.translation.fallback_1.customFields` , `country.translation.customFields` , `country.translation.customFields` ) AS `country.customFields` , `country.translation.fallback_1.createdAt` , `country.translation.createdAt` , `country.translation.fallback_1.updatedAt` , `country.translation.updatedAt` , `country.translation.fallback_1.countryId` , `country.translation.countryId` , `country.translation.fallback_1.languageId` , `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation` . country_id , `country.translation` . name AS `country.translation.name` , `country.translation` . address_format AS `country.translation.addressFormat` , `country.translation` . custom_fields AS `country.translation.customFields` , `country.translation` . created_at AS `country.translation.createdAt` , `country.translation` . updated_at AS `country.translation.updatedAt` , `country.translation` . country_id AS `country.translation.countryId` , `country.translation` . language_id AS `country.translation.languageId` , `country.translation.fallback_1` . name AS `country.translation.fallback_1.name` , `country.translation.fallback_1` . address_format AS `country.translation.fallback_1.addressFormat` , `country.translation.fallback_1` . custom_fields AS `country.translation.fallback_1.customFields` , `country.translation.fallback_1` . created_at AS `country.translation.fallback_1.createdAt` , `country.translation.fallback_1` . updated_at AS `country.translation.fallback_1.updatedAt` , `country.translation.fallback_1` . country_id AS `country.translation.fallback_1.countryId` , `country.translation.fallback_1` . language_id AS `country.translation.fallback_1.languageId` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.fallback_1` ON `country.translation` . `country_id` = `country.translation.fallback_1` . `country_id` AND `country.translation.fallback_1` . language_id = ? WHERE `country.translation` . language_id = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? )
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Šf\x13 ±Jp\x0F š\x17 HÁa=«X ]
SELECT
`country` . `id` AS `country.id` ,
`country` . `iso` AS `country.iso` ,
`country` . `position` AS `country.position` ,
`country` . `active` AS `country.active` ,
`country` . `shipping_available` AS `country.shippingAvailable` ,
`country` . `iso3` AS `country.iso3` ,
`country` . `display_state_in_registration` AS `country.displayStateInRegistration` ,
`country` . `force_state_in_registration` AS `country.forceStateInRegistration` ,
`country` . `check_vat_id_pattern` AS `country.checkVatIdPattern` ,
`country` . `vat_id_required` AS `country.vatIdRequired` ,
`country` . `vat_id_pattern` AS `country.vatIdPattern` ,
`country` . `customer_tax` AS `country.customerTax` ,
`country` . `company_tax` AS `country.companyTax` ,
`country` . `postal_code_required` AS `country.postalCodeRequired` ,
`country` . `check_postal_code_pattern` AS `country.checkPostalCodePattern` ,
`country` . `check_advanced_postal_code_pattern` AS `country.checkAdvancedPostalCodePattern` ,
`country` . `advanced_postal_code_pattern` AS `country.advancedPostalCodePattern` ,
`country` . `default_postal_code_pattern` AS `country.defaultPostalCodePattern` ,
`country` . `created_at` AS `country.createdAt` ,
`country` . `updated_at` AS `country.updatedAt` ,
`country.translation.fallback_1.name` ,
`country.translation.name` ,
COALESCE (
`country.translation.fallback_1.name` ,
`country.translation.name` , `country.translation.name`
) AS `country.name` ,
`country.translation.fallback_1.addressFormat` ,
`country.translation.addressFormat` ,
COALESCE (
`country.translation.fallback_1.addressFormat` ,
`country.translation.addressFormat` ,
`country.translation.addressFormat`
) AS `country.addressFormat` ,
`country.translation.fallback_1.customFields` ,
`country.translation.customFields` ,
COALESCE (
`country.translation.fallback_1.customFields` ,
`country.translation.customFields` ,
`country.translation.customFields`
) AS `country.customFields` ,
`country.translation.fallback_1.createdAt` ,
`country.translation.createdAt` ,
`country.translation.fallback_1.updatedAt` ,
`country.translation.updatedAt` ,
`country.translation.fallback_1.countryId` ,
`country.translation.countryId` ,
`country.translation.fallback_1.languageId` ,
`country.translation.languageId`
FROM
`country`
LEFT JOIN (
SELECT
`country.translation` . country_id ,
`country.translation` . name AS `country.translation.name` ,
`country.translation` . address_format AS `country.translation.addressFormat` ,
`country.translation` . custom_fields AS `country.translation.customFields` ,
`country.translation` . created_at AS `country.translation.createdAt` ,
`country.translation` . updated_at AS `country.translation.updatedAt` ,
`country.translation` . country_id AS `country.translation.countryId` ,
`country.translation` . language_id AS `country.translation.languageId` ,
`country.translation.fallback_1` . name AS `country.translation.fallback_1.name` ,
`country.translation.fallback_1` . address_format AS `country.translation.fallback_1.addressFormat` ,
`country.translation.fallback_1` . custom_fields AS `country.translation.fallback_1.customFields` ,
`country.translation.fallback_1` . created_at AS `country.translation.fallback_1.createdAt` ,
`country.translation.fallback_1` . updated_at AS `country.translation.fallback_1.updatedAt` ,
`country.translation.fallback_1` . country_id AS `country.translation.fallback_1.countryId` ,
`country.translation.fallback_1` . language_id AS `country.translation.fallback_1.languageId`
FROM
`country_translation` `country.translation`
LEFT JOIN `country_translation` `country.translation.fallback_1` ON `country.translation` . `country_id` = `country.translation.fallback_1` . `country_id`
AND `country.translation.fallback_1` . language_id = ?
WHERE
`country.translation` . language_id = ?
) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id`
WHERE
`country` . `id` IN (? )
Copy
SELECT `country` . `id` AS `country.id` , `country` . `iso` AS `country.iso` , `country` . `position` AS `country.position` , `country` . `active` AS `country.active` , `country` . `shipping_available` AS `country.shippingAvailable` , `country` . `iso3` AS `country.iso3` , `country` . `display_state_in_registration` AS `country.displayStateInRegistration` , `country` . `force_state_in_registration` AS `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` AS `country.checkVatIdPattern` , `country` . `vat_id_required` AS `country.vatIdRequired` , `country` . `vat_id_pattern` AS `country.vatIdPattern` , `country` . `customer_tax` AS `country.customerTax` , `country` . `company_tax` AS `country.companyTax` , `country` . `postal_code_required` AS `country.postalCodeRequired` , `country` . `check_postal_code_pattern` AS `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` AS `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` AS `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` AS `country.defaultPostalCodePattern` , `country` . `created_at` AS `country.createdAt` , `country` . `updated_at` AS `country.updatedAt` , `country.translation.fallback_1.name` , `country.translation.name` , COALESCE (`country.translation.fallback_1.name` , `country.translation.name` , `country.translation.name` ) AS `country.name` , `country.translation.fallback_1.addressFormat` , `country.translation.addressFormat` , COALESCE (`country.translation.fallback_1.addressFormat` , `country.translation.addressFormat` , `country.translation.addressFormat` ) AS `country.addressFormat` , `country.translation.fallback_1.customFields` , `country.translation.customFields` , COALESCE (`country.translation.fallback_1.customFields` , `country.translation.customFields` , `country.translation.customFields` ) AS `country.customFields` , `country.translation.fallback_1.createdAt` , `country.translation.createdAt` , `country.translation.fallback_1.updatedAt` , `country.translation.updatedAt` , `country.translation.fallback_1.countryId` , `country.translation.countryId` , `country.translation.fallback_1.languageId` , `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation` . country_id , `country.translation` . name AS `country.translation.name` , `country.translation` . address_format AS `country.translation.addressFormat` , `country.translation` . custom_fields AS `country.translation.customFields` , `country.translation` . created_at AS `country.translation.createdAt` , `country.translation` . updated_at AS `country.translation.updatedAt` , `country.translation` . country_id AS `country.translation.countryId` , `country.translation` . language_id AS `country.translation.languageId` , `country.translation.fallback_1` . name AS `country.translation.fallback_1.name` , `country.translation.fallback_1` . address_format AS `country.translation.fallback_1.addressFormat` , `country.translation.fallback_1` . custom_fields AS `country.translation.fallback_1.customFields` , `country.translation.fallback_1` . created_at AS `country.translation.fallback_1.createdAt` , `country.translation.fallback_1` . updated_at AS `country.translation.fallback_1.updatedAt` , `country.translation.fallback_1` . country_id AS `country.translation.fallback_1.countryId` , `country.translation.fallback_1` . language_id AS `country.translation.fallback_1.languageId` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.fallback_1` ON `country.translation` . `country_id` = `country.translation.fallback_1` . `country_id` AND `country.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `country.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x018A6613B14A700F9A1748C1613DAB58 );
Copy
1.19 ms
1
SELECT `currency` . `id` AS `currency.id` , `currency` . `factor` AS `currency.factor` , `currency` . `symbol` AS `currency.symbol` , `currency` . `iso_code` AS `currency.isoCode` , `currency` . `position` AS `currency.position` , `currency` . `tax_free_from` AS `currency.taxFreeFrom` , `currency` . `item_rounding` AS `currency.itemRounding` , `currency` . `total_rounding` AS `currency.totalRounding` , `currency` . `created_at` AS `currency.createdAt` , `currency` . `updated_at` AS `currency.updatedAt` , `currency.translation.fallback_1.shortName` , `currency.translation.shortName` , COALESCE (`currency.translation.fallback_1.shortName` , `currency.translation.shortName` , `currency.translation.shortName` ) AS `currency.shortName` , `currency.translation.fallback_1.name` , `currency.translation.name` , COALESCE (`currency.translation.fallback_1.name` , `currency.translation.name` , `currency.translation.name` ) AS `currency.name` , `currency.translation.fallback_1.customFields` , `currency.translation.customFields` , COALESCE (`currency.translation.fallback_1.customFields` , `currency.translation.customFields` , `currency.translation.customFields` ) AS `currency.customFields` , `currency.translation.fallback_1.createdAt` , `currency.translation.createdAt` , `currency.translation.fallback_1.updatedAt` , `currency.translation.updatedAt` , `currency.translation.fallback_1.currencyId` , `currency.translation.currencyId` , `currency.translation.fallback_1.languageId` , `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation` . currency_id , `currency.translation` . short_name AS `currency.translation.shortName` , `currency.translation` . name AS `currency.translation.name` , `currency.translation` . custom_fields AS `currency.translation.customFields` , `currency.translation` . created_at AS `currency.translation.createdAt` , `currency.translation` . updated_at AS `currency.translation.updatedAt` , `currency.translation` . currency_id AS `currency.translation.currencyId` , `currency.translation` . language_id AS `currency.translation.languageId` , `currency.translation.fallback_1` . short_name AS `currency.translation.fallback_1.shortName` , `currency.translation.fallback_1` . name AS `currency.translation.fallback_1.name` , `currency.translation.fallback_1` . custom_fields AS `currency.translation.fallback_1.customFields` , `currency.translation.fallback_1` . created_at AS `currency.translation.fallback_1.createdAt` , `currency.translation.fallback_1` . updated_at AS `currency.translation.fallback_1.updatedAt` , `currency.translation.fallback_1` . currency_id AS `currency.translation.fallback_1.currencyId` , `currency.translation.fallback_1` . language_id AS `currency.translation.fallback_1.languageId` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.fallback_1` ON `currency.translation` . `currency_id` = `currency.translation.fallback_1` . `currency_id` AND `currency.translation.fallback_1` . language_id = ? WHERE `currency.translation` . language_id = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (? )
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò/»_ââšMpªXTÎ|ãâ\v "
b"\x01 Šf\x13 ‰œq[”p²\x14\x17 ¬m\x19 ]
SELECT
`currency` . `id` AS `currency.id` ,
`currency` . `factor` AS `currency.factor` ,
`currency` . `symbol` AS `currency.symbol` ,
`currency` . `iso_code` AS `currency.isoCode` ,
`currency` . `position` AS `currency.position` ,
`currency` . `tax_free_from` AS `currency.taxFreeFrom` ,
`currency` . `item_rounding` AS `currency.itemRounding` ,
`currency` . `total_rounding` AS `currency.totalRounding` ,
`currency` . `created_at` AS `currency.createdAt` ,
`currency` . `updated_at` AS `currency.updatedAt` ,
`currency.translation.fallback_1.shortName` ,
`currency.translation.shortName` ,
COALESCE (
`currency.translation.fallback_1.shortName` ,
`currency.translation.shortName` ,
`currency.translation.shortName`
) AS `currency.shortName` ,
`currency.translation.fallback_1.name` ,
`currency.translation.name` ,
COALESCE (
`currency.translation.fallback_1.name` ,
`currency.translation.name` , `currency.translation.name`
) AS `currency.name` ,
`currency.translation.fallback_1.customFields` ,
`currency.translation.customFields` ,
COALESCE (
`currency.translation.fallback_1.customFields` ,
`currency.translation.customFields` ,
`currency.translation.customFields`
) AS `currency.customFields` ,
`currency.translation.fallback_1.createdAt` ,
`currency.translation.createdAt` ,
`currency.translation.fallback_1.updatedAt` ,
`currency.translation.updatedAt` ,
`currency.translation.fallback_1.currencyId` ,
`currency.translation.currencyId` ,
`currency.translation.fallback_1.languageId` ,
`currency.translation.languageId`
FROM
`currency`
LEFT JOIN (
SELECT
`currency.translation` . currency_id ,
`currency.translation` . short_name AS `currency.translation.shortName` ,
`currency.translation` . name AS `currency.translation.name` ,
`currency.translation` . custom_fields AS `currency.translation.customFields` ,
`currency.translation` . created_at AS `currency.translation.createdAt` ,
`currency.translation` . updated_at AS `currency.translation.updatedAt` ,
`currency.translation` . currency_id AS `currency.translation.currencyId` ,
`currency.translation` . language_id AS `currency.translation.languageId` ,
`currency.translation.fallback_1` . short_name AS `currency.translation.fallback_1.shortName` ,
`currency.translation.fallback_1` . name AS `currency.translation.fallback_1.name` ,
`currency.translation.fallback_1` . custom_fields AS `currency.translation.fallback_1.customFields` ,
`currency.translation.fallback_1` . created_at AS `currency.translation.fallback_1.createdAt` ,
`currency.translation.fallback_1` . updated_at AS `currency.translation.fallback_1.updatedAt` ,
`currency.translation.fallback_1` . currency_id AS `currency.translation.fallback_1.currencyId` ,
`currency.translation.fallback_1` . language_id AS `currency.translation.fallback_1.languageId`
FROM
`currency_translation` `currency.translation`
LEFT JOIN `currency_translation` `currency.translation.fallback_1` ON `currency.translation` . `currency_id` = `currency.translation.fallback_1` . `currency_id`
AND `currency.translation.fallback_1` . language_id = ?
WHERE
`currency.translation` . language_id = ?
) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id`
WHERE
`currency` . `id` IN (? )
Copy
SELECT `currency` . `id` AS `currency.id` , `currency` . `factor` AS `currency.factor` , `currency` . `symbol` AS `currency.symbol` , `currency` . `iso_code` AS `currency.isoCode` , `currency` . `position` AS `currency.position` , `currency` . `tax_free_from` AS `currency.taxFreeFrom` , `currency` . `item_rounding` AS `currency.itemRounding` , `currency` . `total_rounding` AS `currency.totalRounding` , `currency` . `created_at` AS `currency.createdAt` , `currency` . `updated_at` AS `currency.updatedAt` , `currency.translation.fallback_1.shortName` , `currency.translation.shortName` , COALESCE (`currency.translation.fallback_1.shortName` , `currency.translation.shortName` , `currency.translation.shortName` ) AS `currency.shortName` , `currency.translation.fallback_1.name` , `currency.translation.name` , COALESCE (`currency.translation.fallback_1.name` , `currency.translation.name` , `currency.translation.name` ) AS `currency.name` , `currency.translation.fallback_1.customFields` , `currency.translation.customFields` , COALESCE (`currency.translation.fallback_1.customFields` , `currency.translation.customFields` , `currency.translation.customFields` ) AS `currency.customFields` , `currency.translation.fallback_1.createdAt` , `currency.translation.createdAt` , `currency.translation.fallback_1.updatedAt` , `currency.translation.updatedAt` , `currency.translation.fallback_1.currencyId` , `currency.translation.currencyId` , `currency.translation.fallback_1.languageId` , `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation` . currency_id , `currency.translation` . short_name AS `currency.translation.shortName` , `currency.translation` . name AS `currency.translation.name` , `currency.translation` . custom_fields AS `currency.translation.customFields` , `currency.translation` . created_at AS `currency.translation.createdAt` , `currency.translation` . updated_at AS `currency.translation.updatedAt` , `currency.translation` . currency_id AS `currency.translation.currencyId` , `currency.translation` . language_id AS `currency.translation.languageId` , `currency.translation.fallback_1` . short_name AS `currency.translation.fallback_1.shortName` , `currency.translation.fallback_1` . name AS `currency.translation.fallback_1.name` , `currency.translation.fallback_1` . custom_fields AS `currency.translation.fallback_1.customFields` , `currency.translation.fallback_1` . created_at AS `currency.translation.fallback_1.createdAt` , `currency.translation.fallback_1` . updated_at AS `currency.translation.fallback_1.updatedAt` , `currency.translation.fallback_1` . currency_id AS `currency.translation.fallback_1.currencyId` , `currency.translation.fallback_1` . language_id AS `currency.translation.fallback_1.languageId` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.fallback_1` ON `currency.translation` . `currency_id` = `currency.translation.fallback_1` . `currency_id` AND `currency.translation.fallback_1` . language_id = 0x018A69406DFC703C89D2E685B3D159F2 WHERE `currency.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (0x018A6613899C715B9470B21417AC6D19 );
Copy
1.09 ms
1
SELECT LOWER (HEX (language . id )) AS array_key , LOWER (HEX (language . id )) AS id , locale . code , parentLocale . code AS parentCode , LOWER (HEX (language . parent_id )) parentId FROM language LEFT JOIN locale locale ON language . translation_code_id = locale . id LEFT JOIN language parentLanguage ON language . parent_id = parentLanguage . id LEFT JOIN locale parentLocale ON parentLanguage . translation_code_id = parentLocale . id
SELECT LOWER (HEX (language . id )) AS array_key , LOWER (HEX (language . id )) AS id , locale . code , parentLocale . code AS parentCode , LOWER (HEX (language . parent_id )) parentId FROM language LEFT JOIN locale locale ON language . translation_code_id = locale . id LEFT JOIN language parentLanguage ON language . parent_id = parentLanguage . id LEFT JOIN locale parentLocale ON parentLanguage . translation_code_id = parentLocale . id ; Copy
1.08 ms
1
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
1.06 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
1.06 ms
1
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ? ) AND (sales_channel_id = ? ) AND (path_info = ? ) AND (is_canonical = 1 ) LIMIT 1
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò\x01 ïò$Ù\r ~@░àüT¦╝Vu/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x018A69406DFC703C89D2E685B3D159F2 ) AND (sales_channel_id = 0x018B9524EB0D7E40B0858154DDBC5675 ) AND (path_info = '/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
1.06 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.98 ms
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"\x01 ïò$Ù\r ~@░àüT¦╝Vu0193587c112273b1ae4979321a15c5ef "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x018B9524EB0D7E40B0858154DDBC5675 ) AND (token = '0193587c112273b1ae4979321a15c5ef' ) LIMIT 1 ; Copy
0.97 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"\x01 Šf\x13 ‰µp߬”%\x15 QY\x0F ì\x01 èf\x13 ëÚs¾│\x18 Ì\x1F ìQª>\x01 Šf\x13 Š|r\x1D ¬Œ™·Œ\r š—\x01 Šf\x13 ¨Üqý¯Å>fóC\x1A ‹\x01 ì\r P0?r\x1C Á°)på┌æ┐\x01 Šf\x13 ŠtqÒŸþ<€ñœl;\x01 Šf\x13 Šxr\e §:[è_O~"\x01 Šf\x14\x01\x05 q¢˜@µ4iÎ|w ]
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 (0x018A661389B570DFAC94251551590FEC , 0x018A661389E973F3B318DE1F8D51A63E , 0x018A66138A7C721DAC8C99B78C0D9A97 , 0x018A6613A8DC71FDAFC53E66F3431A8B , 0x018D0D50303F721CB5F8297086DA91BF , 0x018A66138A7471D29FFE3C80F19C6C3B , 0x018A66138A78721BA73A5BE85F4F7E22 , 0x018A6614010571A29840B53469CE7C77 );
Copy
0.90 ms
1
SELECT `id` , `old_url` , `new_url` , `old_url_regex` , `search_url_by` , `temporary` , ? REGEXP `old_url_regex` AS regex0 , ? REGEXP `old_url_regex` AS regex1 , ? REGEXP `old_url_regex` AS regex2 , ? REGEXP `old_url_regex` AS regex3 FROM `acris_seo_redirect` WHERE `active` = ? AND ((NOT (`search_url_by` = ? ) AND ((`old_url` = ? OR `old_url` = ? OR `old_url` = ? OR `old_url` = ? ))) OR (`search_url_by` = ? AND ((? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` )))) LIMIT 6 ;
Parameters :
[
"/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"https://shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
1
"regex "
"/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"https://shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"regex "
"/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"https://shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
"shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes "
]
SELECT `id` , `old_url` , `new_url` , `old_url_regex` , `search_url_by` , `temporary` , '/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' REGEXP `old_url_regex` AS regex0 , '/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' REGEXP `old_url_regex` AS regex1 , 'https://shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' REGEXP `old_url_regex` AS regex2 , 'shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' REGEXP `old_url_regex` AS regex3 FROM `acris_seo_redirect` WHERE `active` = 1 AND ((NOT (`search_url_by` = 'regex' ) AND ((`old_url` = '/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' OR `old_url` = '/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' OR `old_url` = 'https://shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' OR `old_url` = 'shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' ))) OR (`search_url_by` = 'regex' AND (('/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' REGEXP `old_url_regex` OR '/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' REGEXP `old_url_regex` OR 'https://shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' REGEXP `old_url_regex` OR 'shopw.tente-network.com/es-cl/soluciones-de-movilidad/medio-ambiente/soluciones-para-entornos-exigentes' REGEXP `old_url_regex` )))) LIMIT 6 ; ; Copy
0.87 ms
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"0193587c112273b1ae4979321a15c5ef "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = '0193587c112273b1ae4979321a15c5ef' ;
Copy
0.87 ms
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
0.87 ms
1
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE ((`country.salesChannels` . `id` = ? )) AND (`country` . `id` IN (? )) GROUP BY `country` . `id`
Parameters :
[
b"\x01 ïò$Ù\r ~@░àüT¦╝Vu\x01 Šf\x13 ±Jp\x0F š\x17 HÁa=«X ]
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE ((`country.salesChannels` . `id` = 0x018B9524EB0D7E40B0858154DDBC5675 )) AND (`country` . `id` IN (0x018A6613B14A700F9A1748C1613DAB58 )) GROUP BY `country` . `id` ; Copy
0.87 ms
1
SELECT `rule` . `id` FROM `rule` ORDER BY `rule` . `priority` DESC , `rule` . `id` ASC LIMIT 500
SELECT `rule` . `id` FROM `rule` ORDER BY `rule` . `priority` DESC , `rule` . `id` ASC LIMIT 500 ;
Copy
0.87 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` FROM `sales_channel_domain` WHERE (`sales_channel_domain` . `sales_channel_id` IN (? ))
Parameters :
[
b"\x01 ïò$Ù\r ~@░àüT¦╝Vu ]
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` FROM `sales_channel_domain` WHERE (`sales_channel_domain` . `sales_channel_id` IN (0x018B9524EB0D7E40B0858154DDBC5675 ));
Copy
0.86 ms
1
SELECT `currency_country_rounding` . `id` FROM `currency_country_rounding` WHERE (`currency_country_rounding` . `currency_id` = ? AND `currency_country_rounding` . `country_id` = ? ) LIMIT 1
Parameters :
[
b"\x01 Šf\x13 ‰œq[”p²\x14\x17 ¬m\x19 \x01 Šf\x13 ±Jp\x0F š\x17 HÁa=«X ]
SELECT `currency_country_rounding` . `id` FROM `currency_country_rounding` WHERE (`currency_country_rounding` . `currency_id` = 0x018A6613899C715B9470B21417AC6D19 AND `currency_country_rounding` . `country_id` = 0x018A6613B14A700F9A1748C1613DAB58 ) LIMIT 1 ;
Copy
0.85 ms
1
SELECT LOWER (HEX (language . parent_id )) FROM language WHERE language . id = ?
Parameters :
[
b"\x01 Ši@müp<‰Òæ…³ÑYò ]
SELECT LOWER (HEX (language . parent_id )) FROM language WHERE language . id = 0x018A69406DFC703C89D2E685B3D159F2 ; Copy
0.85 ms
1
SELECT `tax` . `id` AS `tax.id` , `tax` . `tax_rate` AS `tax.taxRate` , `tax` . `name` AS `tax.name` , `tax` . `position` AS `tax.position` , `tax` . `custom_fields` AS `tax.customFields` , `tax` . `created_at` AS `tax.createdAt` , `tax` . `updated_at` AS `tax.updatedAt` FROM `tax`
SELECT `tax` . `id` AS `tax.id` , `tax` . `tax_rate` AS `tax.taxRate` , `tax` . `name` AS `tax.name` , `tax` . `position` AS `tax.position` , `tax` . `custom_fields` AS `tax.customFields` , `tax` . `created_at` AS `tax.createdAt` , `tax` . `updated_at` AS `tax.updatedAt` FROM `tax` ;
Copy
0.81 ms
1
SELECT 1 AS `exists` , `id` FROM `pluszwei_seo_redirect` WHERE `id` IN (? )
Parameters :
[
b"\x01 ŸtÃlp"ɤ~┤┤Ðì¹ ]
SELECT 1 AS `exists` , `id` FROM `pluszwei_seo_redirect` WHERE `id` IN (0x018FF774C76C702290CF7EB4B4D18DFB ); Copy
0.73 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.68 ms
1
"START TRANSACTION"
"START TRANSACTION" ; Copy