1648.35 ms (27.25%)
1182
DELETE FROM messenger_messages WHERE delivered_at = ?
Parameters :
[
"9999-12-31 23:59:59 "
]
DELETE FROM messenger_messages WHERE delivered_at = '9999-12-31 23:59:59' ;
Copy
1333.34 ms (22.04%)
1182
SELECT m . * FROM messenger_messages m WHERE (m . delivered_at is null OR m . delivered_at < ? ) AND (m . available_at < = ? ) AND (m . queue_name = ? ) ORDER BY available_at ASC LIMIT 1 FOR UPDATE
Parameters :
[
"2025-07-10 04:11:27 "
"2025-07-10 05:11:27 "
"default "
]
SELECT m . * FROM messenger_messages m WHERE (m . delivered_at is null OR m . delivered_at < '2025-07-10 04:11:27' ) AND (m . available_at < = '2025-07-10 05:11:27' ) AND (m . queue_name = 'default' ) ORDER BY available_at ASC LIMIT 1 FOR UPDATE ;
Copy
948.17 ms (15.68%)
1239
"COMMIT"
877.03 ms (14.50%)
1239
"START TRANSACTION"
"START TRANSACTION" ;
Copy
335.82 ms (5.55%)
174
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` . `write_access` as `app.integration.writeAccess` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE `app` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x00 ûöïrªH!³‰\x05 ’½¡ò× "
]
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` . `write_access` as `app.integration.writeAccess` ,
`app.integration` . `last_usage_at` as `app.integration.lastUsageAt` ,
`app.integration` . `admin` as `app.integration.admin` ,
`app.integration` . `custom_fields` as `app.integration.customFields` ,
`app.integration` . `deleted_at` as `app.integration.deletedAt` ,
`app.integration` . `created_at` as `app.integration.createdAt` ,
`app.integration` . `updated_at` as `app.integration.updatedAt` ,
`app` . `acl_role_id` as `app.aclRoleId` ,
`app.aclRole` . `id` as `app.aclRole.id` ,
`app.aclRole` . `name` as `app.aclRole.name` ,
`app.aclRole` . `description` as `app.aclRole.description` ,
`app.aclRole` . `privileges` as `app.aclRole.privileges` ,
`app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` ,
`app.aclRole` . `created_at` as `app.aclRole.createdAt` ,
`app.aclRole` . `updated_at` as `app.aclRole.updatedAt` ,
`app` . `created_at` as `app.createdAt` ,
`app` . `updated_at` as `app.updatedAt` ,
`app.translation.label` ,
COALESCE (
`app.translation.label` , `app.translation.label`
) as `app.label` ,
`app.translation.description` ,
COALESCE (
`app.translation.description` , `app.translation.description`
) as `app.description` ,
`app.translation.privacyPolicyExtensions` ,
COALESCE (
`app.translation.privacyPolicyExtensions` ,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions` ,
`app.translation.customFields` ,
COALESCE (
`app.translation.customFields` ,
`app.translation.customFields`
) as `app.customFields` ,
`app.translation.createdAt` ,
`app.translation.updatedAt` ,
`app.translation.appId` ,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation` . app_id ,
`app.translation` . label as `app.translation.label` ,
`app.translation` . description as `app.translation.description` ,
`app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` ,
`app.translation` . custom_fields as `app.translation.customFields` ,
`app.translation` . created_at as `app.translation.createdAt` ,
`app.translation` . updated_at as `app.translation.updatedAt` ,
`app.translation` . app_id as `app.translation.appId` ,
`app.translation` . language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation` . language_id = ?
) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id`
LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id`
LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id`
WHERE
`app` . `id` IN (? )
Copy
SELECT `app` . `id` as `app.id` , `app` . `name` as `app.name` , `app` . `path` as `app.path` , `app` . `author` as `app.author` , `app` . `copyright` as `app.copyright` , `app` . `license` as `app.license` , `app` . `active` as `app.active` , `app` . `configurable` as `app.configurable` , `app` . `privacy` as `app.privacy` , `app` . `version` as `app.version` , `app` . `icon` as `app.iconRaw` , `app` . `app_secret` as `app.appSecret` , `app` . `modules` as `app.modules` , `app` . `main_module` as `app.mainModule` , `app` . `cookies` as `app.cookies` , `app` . `allow_disable` as `app.allowDisable` , `app` . `base_app_url` as `app.baseAppUrl` , `app` . `allowed_hosts` as `app.allowedHosts` , `app` . `template_load_priority` as `app.templateLoadPriority` , `app` . `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` . `write_access` as `app.integration.writeAccess` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE `app` . `id` IN (0x00FBF6EF72AA4821B3890592BDA1F2D7 );
Copy
155.54 ms (2.57%)
174
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"\x00 ûöïrªH!³‰\x05 ’½¡ò× "
]
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 (0x00FBF6EF72AA4821B3890592BDA1F2D7 ));
Copy
125.22 ms (2.07%)
58
UPDATE messenger_messages SET delivered_at = ? WHERE id = ?
Parameters :
[
"2025-07-10 05:11:27 "
"189591 "
]
UPDATE messenger_messages SET delivered_at = '2025-07-10 05:11:27' WHERE id = '189591' ;
Copy
109.91 ms (1.82%)
58
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` . `write_access` as `app.integration.writeAccess` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE (`app` . `active` = ? )
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` . `write_access` as `app.integration.writeAccess` ,
`app.integration` . `last_usage_at` as `app.integration.lastUsageAt` ,
`app.integration` . `admin` as `app.integration.admin` ,
`app.integration` . `custom_fields` as `app.integration.customFields` ,
`app.integration` . `deleted_at` as `app.integration.deletedAt` ,
`app.integration` . `created_at` as `app.integration.createdAt` ,
`app.integration` . `updated_at` as `app.integration.updatedAt` ,
`app` . `acl_role_id` as `app.aclRoleId` ,
`app.aclRole` . `id` as `app.aclRole.id` ,
`app.aclRole` . `name` as `app.aclRole.name` ,
`app.aclRole` . `description` as `app.aclRole.description` ,
`app.aclRole` . `privileges` as `app.aclRole.privileges` ,
`app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` ,
`app.aclRole` . `created_at` as `app.aclRole.createdAt` ,
`app.aclRole` . `updated_at` as `app.aclRole.updatedAt` ,
`app` . `created_at` as `app.createdAt` ,
`app` . `updated_at` as `app.updatedAt` ,
`app.translation.label` ,
COALESCE (
`app.translation.label` , `app.translation.label`
) as `app.label` ,
`app.translation.description` ,
COALESCE (
`app.translation.description` , `app.translation.description`
) as `app.description` ,
`app.translation.privacyPolicyExtensions` ,
COALESCE (
`app.translation.privacyPolicyExtensions` ,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions` ,
`app.translation.customFields` ,
COALESCE (
`app.translation.customFields` ,
`app.translation.customFields`
) as `app.customFields` ,
`app.translation.createdAt` ,
`app.translation.updatedAt` ,
`app.translation.appId` ,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation` . app_id ,
`app.translation` . label as `app.translation.label` ,
`app.translation` . description as `app.translation.description` ,
`app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` ,
`app.translation` . custom_fields as `app.translation.customFields` ,
`app.translation` . created_at as `app.translation.createdAt` ,
`app.translation` . updated_at as `app.translation.updatedAt` ,
`app.translation` . app_id as `app.translation.appId` ,
`app.translation` . language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation` . language_id = ?
) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id`
LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id`
LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id`
WHERE
(`app` . `active` = ? )
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` . `write_access` as `app.integration.writeAccess` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE (`app` . `active` = 1 );
Copy
92.96 ms (1.54%)
58
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
87.17 ms (1.44%)
29
UPDATE `increment`
SET `count` = `count` - 1 , `updated_at` = ?
WHERE `pool` = ? AND `cluster` = ? AND `key` = ? AND `count` > 0 ;
Parameters :
[
"2025-07-10 05:11:27.692 "
"message_queue "
"message_queue_stats "
"Shopware\Core\Framework\Log\ScheduledTask\LogCleanupTask "
]
UPDATE `increment`
SET `count` = `count` - 1 , `updated_at` = '2025-07-10 05:11:27.692'
WHERE `pool` = 'message_queue' AND `cluster` = 'message_queue_stats' AND `key` = 'Shopware\\Core\\Framework\\Log\\ScheduledTask\\LogCleanupTask' AND `count` > 0 ;
;
Copy
79.15 ms (1.31%)
58
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
48.84 ms (0.81%)
28
SELECT `scheduled_task` . `id` as `scheduled_task.id` , `scheduled_task` . `name` as `scheduled_task.name` , `scheduled_task` . `scheduled_task_class` as `scheduled_task.scheduledTaskClass` , `scheduled_task` . `run_interval` as `scheduled_task.runInterval` , `scheduled_task` . `status` as `scheduled_task.status` , `scheduled_task` . `last_execution_time` as `scheduled_task.lastExecutionTime` , `scheduled_task` . `next_execution_time` as `scheduled_task.nextExecutionTime` , `scheduled_task` . `created_at` as `scheduled_task.createdAt` , `scheduled_task` . `updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE `scheduled_task` . `id` IN (? )
Parameters :
[
b"!„…G\x07 ¼Eõ‡ë¼œ\x1F ÚJj "
]
SELECT `scheduled_task` . `id` as `scheduled_task.id` , `scheduled_task` . `name` as `scheduled_task.name` , `scheduled_task` . `scheduled_task_class` as `scheduled_task.scheduledTaskClass` , `scheduled_task` . `run_interval` as `scheduled_task.runInterval` , `scheduled_task` . `status` as `scheduled_task.status` , `scheduled_task` . `last_execution_time` as `scheduled_task.lastExecutionTime` , `scheduled_task` . `next_execution_time` as `scheduled_task.nextExecutionTime` , `scheduled_task` . `created_at` as `scheduled_task.createdAt` , `scheduled_task` . `updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE `scheduled_task` . `id` IN (0x2184854707BC45F587EBBC9C1FDA4A6A );
Copy
43.61 ms (0.72%)
56
SELECT 1 as `exists` , `id` FROM `scheduled_task` WHERE `id` IN (? )
Parameters :
[
b"!„…G\x07 ¼Eõ‡ë¼œ\x1F ÚJj "
]
SELECT 1 as `exists` , `id` FROM `scheduled_task` WHERE `id` IN (0x2184854707BC45F587EBBC9C1FDA4A6A );
Copy
38.33 ms (0.63%)
18
SELECT `product_export` . `id` as `product_export.id` , `product_export` . `product_stream_id` as `product_export.productStreamId` , `product_export` . `storefront_sales_channel_id` as `product_export.storefrontSalesChannelId` , `product_export` . `sales_channel_id` as `product_export.salesChannelId` , `product_export` . `sales_channel_domain_id` as `product_export.salesChannelDomainId` , `product_export` . `currency_id` as `product_export.currencyId` , `product_export` . `file_name` as `product_export.fileName` , `product_export` . `access_key` as `product_export.accessKey` , `product_export` . `encoding` as `product_export.encoding` , `product_export` . `file_format` as `product_export.fileFormat` , `product_export` . `include_variants` as `product_export.includeVariants` , `product_export` . `generate_by_cronjob` as `product_export.generateByCronjob` , `product_export` . `generated_at` as `product_export.generatedAt` , `product_export` . `interval` as `product_export.interval` , `product_export` . `header_template` as `product_export.headerTemplate` , `product_export` . `body_template` as `product_export.bodyTemplate` , `product_export` . `footer_template` as `product_export.footerTemplate` , `product_export` . `paused_schedule` as `product_export.pausedSchedule` , `product_export` . `is_running` as `product_export.isRunning` , `product_export` . `created_at` as `product_export.createdAt` , `product_export` . `updated_at` as `product_export.updatedAt` , `product_export.salesChannel` . `id` as `product_export.salesChannel.id` , `product_export.salesChannel` . `type_id` as `product_export.salesChannel.typeId` , `product_export.salesChannel` . `language_id` as `product_export.salesChannel.languageId` , `product_export.salesChannel` . `customer_group_id` as `product_export.salesChannel.customerGroupId` , `product_export.salesChannel` . `currency_id` as `product_export.salesChannel.currencyId` , `product_export.salesChannel` . `payment_method_id` as `product_export.salesChannel.paymentMethodId` , `product_export.salesChannel` . `shipping_method_id` as `product_export.salesChannel.shippingMethodId` , `product_export.salesChannel` . `country_id` as `product_export.salesChannel.countryId` , `product_export.salesChannel` . `analytics_id` as `product_export.salesChannel.analyticsId` , `product_export.salesChannel` . `navigation_category_id` as `product_export.salesChannel.navigationCategoryId` , `product_export.salesChannel` . `navigation_category_version_id` as `product_export.salesChannel.navigationCategoryVersionId` , `product_export.salesChannel` . `navigation_category_depth` as `product_export.salesChannel.navigationCategoryDepth` , `product_export.salesChannel` . `footer_category_id` as `product_export.salesChannel.footerCategoryId` , `product_export.salesChannel` . `footer_category_version_id` as `product_export.salesChannel.footerCategoryVersionId` , `product_export.salesChannel` . `service_category_id` as `product_export.salesChannel.serviceCategoryId` , `product_export.salesChannel` . `service_category_version_id` as `product_export.salesChannel.serviceCategoryVersionId` , `product_export.salesChannel` . `mail_header_footer_id` as `product_export.salesChannel.mailHeaderFooterId` , `product_export.salesChannel` . `hreflang_default_domain_id` as `product_export.salesChannel.hreflangDefaultDomainId` , `product_export.salesChannel` . `short_name` as `product_export.salesChannel.shortName` , `product_export.salesChannel` . `tax_calculation_type` as `product_export.salesChannel.taxCalculationType` , `product_export.salesChannel` . `access_key` as `product_export.salesChannel.accessKey` , `product_export.salesChannel` . `configuration` as `product_export.salesChannel.configuration` , `product_export.salesChannel` . `active` as `product_export.salesChannel.active` , `product_export.salesChannel` . `hreflang_active` as `product_export.salesChannel.hreflangActive` , `product_export.salesChannel` . `maintenance` as `product_export.salesChannel.maintenance` , `product_export.salesChannel` . `maintenance_ip_whitelist` as `product_export.salesChannel.maintenanceIpWhitelist` , `product_export.salesChannel` . `payment_method_ids` as `product_export.salesChannel.paymentMethodIds` , `product_export.salesChannel` . `home_cms_page_id` as `product_export.salesChannel.homeCmsPageId` , `product_export.salesChannel` . `home_cms_page_version_id` as `product_export.salesChannel.homeCmsPageVersionId` , `product_export.salesChannel.analytics` . `id` as `product_export.salesChannel.analytics.id` , `product_export.salesChannel.analytics` . `tracking_id` as `product_export.salesChannel.analytics.trackingId` , `product_export.salesChannel.analytics` . `active` as `product_export.salesChannel.analytics.active` , `product_export.salesChannel.analytics` . `track_orders` as `product_export.salesChannel.analytics.trackOrders` , `product_export.salesChannel.analytics` . `anonymize_ip` as `product_export.salesChannel.analytics.anonymizeIp` , `product_export.salesChannel.analytics` . `created_at` as `product_export.salesChannel.analytics.createdAt` , `product_export.salesChannel.analytics` . `updated_at` as `product_export.salesChannel.analytics.updatedAt` , `product_export.salesChannel` . `created_at` as `product_export.salesChannel.createdAt` , `product_export.salesChannel` . `updated_at` as `product_export.salesChannel.updatedAt` , `product_export.salesChannel.translation.name` , COALESCE (`product_export.salesChannel.translation.name` , `product_export.salesChannel.translation.name` ) as `product_export.salesChannel.name` , `product_export.salesChannel.translation.homeSlotConfig` , COALESCE (`product_export.salesChannel.translation.homeSlotConfig` , `product_export.salesChannel.translation.homeSlotConfig` ) as `product_export.salesChannel.homeSlotConfig` , `product_export.salesChannel.translation.homeEnabled` , COALESCE (`product_export.salesChannel.translation.homeEnabled` , `product_export.salesChannel.translation.homeEnabled` ) as `product_export.salesChannel.homeEnabled` , `product_export.salesChannel.translation.homeName` , COALESCE (`product_export.salesChannel.translation.homeName` , `product_export.salesChannel.translation.homeName` ) as `product_export.salesChannel.homeName` , `product_export.salesChannel.translation.homeMetaTitle` , COALESCE (`product_export.salesChannel.translation.homeMetaTitle` , `product_export.salesChannel.translation.homeMetaTitle` ) as `product_export.salesChannel.homeMetaTitle` , `product_export.salesChannel.translation.homeMetaDescription` , COALESCE (`product_export.salesChannel.translation.homeMetaDescription` , `product_export.salesChannel.translation.homeMetaDescription` ) as `product_export.salesChannel.homeMetaDescription` , `product_export.salesChannel.translation.homeKeywords` , COALESCE (`product_export.salesChannel.translation.homeKeywords` , `product_export.salesChannel.translation.homeKeywords` ) as `product_export.salesChannel.homeKeywords` , `product_export.salesChannel.translation.customFields` , COALESCE (`product_export.salesChannel.translation.customFields` , `product_export.salesChannel.translation.customFields` ) as `product_export.salesChannel.customFields` , `product_export.salesChannel.translation.createdAt` , `product_export.salesChannel.translation.updatedAt` , `product_export.salesChannel.translation.salesChannelId` , `product_export.salesChannel.translation.languageId` FROM `product_export` LEFT JOIN `sales_channel` `product_export.salesChannel` ON `product_export` . `sales_channel_id` = `product_export.salesChannel` . `id` LEFT JOIN `sales_channel_domain` `product_export.salesChannelDomain` ON `product_export` . `sales_channel_domain_id` = `product_export.salesChannelDomain` . `id` LEFT JOIN (SELECT `product_export.salesChannel.translation` . sales_channel_id , `product_export.salesChannel.translation` . name as `product_export.salesChannel.translation.name` , `product_export.salesChannel.translation` . home_slot_config as `product_export.salesChannel.translation.homeSlotConfig` , `product_export.salesChannel.translation` . home_enabled as `product_export.salesChannel.translation.homeEnabled` , `product_export.salesChannel.translation` . home_name as `product_export.salesChannel.translation.homeName` , `product_export.salesChannel.translation` . home_meta_title as `product_export.salesChannel.translation.homeMetaTitle` , `product_export.salesChannel.translation` . home_meta_description as `product_export.salesChannel.translation.homeMetaDescription` , `product_export.salesChannel.translation` . home_keywords as `product_export.salesChannel.translation.homeKeywords` , `product_export.salesChannel.translation` . custom_fields as `product_export.salesChannel.translation.customFields` , `product_export.salesChannel.translation` . created_at as `product_export.salesChannel.translation.createdAt` , `product_export.salesChannel.translation` . updated_at as `product_export.salesChannel.translation.updatedAt` , `product_export.salesChannel.translation` . sales_channel_id as `product_export.salesChannel.translation.salesChannelId` , `product_export.salesChannel.translation` . language_id as `product_export.salesChannel.translation.languageId` FROM `sales_channel_translation` `product_export.salesChannel.translation` WHERE `product_export.salesChannel.translation` . language_id = ? ) `product_export.salesChannel.sales_channel_translation` ON `product_export.salesChannel.sales_channel_translation` . `sales_channel_id` = `product_export.salesChannel` . `id` LEFT JOIN `sales_channel_analytics` `product_export.salesChannel.analytics` ON `product_export.salesChannel` . `analytics_id` = `product_export.salesChannel.analytics` . `id` LEFT JOIN `sales_channel` `product_export.salesChannelDomain.salesChannel` ON `product_export.salesChannelDomain` . `sales_channel_id` = `product_export.salesChannelDomain.salesChannel` . `id` WHERE ((`product_export` . `generate_by_cronjob` = ? AND `product_export.salesChannel` . `active` = ? ) AND (`product_export` . `storefront_sales_channel_id` = ? OR `product_export.salesChannelDomain.salesChannel` . `id` = ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
true
b"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
b"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
SELECT
`product_export` . `id` as `product_export.id` ,
`product_export` . `product_stream_id` as `product_export.productStreamId` ,
`product_export` . `storefront_sales_channel_id` as `product_export.storefrontSalesChannelId` ,
`product_export` . `sales_channel_id` as `product_export.salesChannelId` ,
`product_export` . `sales_channel_domain_id` as `product_export.salesChannelDomainId` ,
`product_export` . `currency_id` as `product_export.currencyId` ,
`product_export` . `file_name` as `product_export.fileName` ,
`product_export` . `access_key` as `product_export.accessKey` ,
`product_export` . `encoding` as `product_export.encoding` ,
`product_export` . `file_format` as `product_export.fileFormat` ,
`product_export` . `include_variants` as `product_export.includeVariants` ,
`product_export` . `generate_by_cronjob` as `product_export.generateByCronjob` ,
`product_export` . `generated_at` as `product_export.generatedAt` ,
`product_export` . `interval` as `product_export.interval` ,
`product_export` . `header_template` as `product_export.headerTemplate` ,
`product_export` . `body_template` as `product_export.bodyTemplate` ,
`product_export` . `footer_template` as `product_export.footerTemplate` ,
`product_export` . `paused_schedule` as `product_export.pausedSchedule` ,
`product_export` . `is_running` as `product_export.isRunning` ,
`product_export` . `created_at` as `product_export.createdAt` ,
`product_export` . `updated_at` as `product_export.updatedAt` ,
`product_export.salesChannel` . `id` as `product_export.salesChannel.id` ,
`product_export.salesChannel` . `type_id` as `product_export.salesChannel.typeId` ,
`product_export.salesChannel` . `language_id` as `product_export.salesChannel.languageId` ,
`product_export.salesChannel` . `customer_group_id` as `product_export.salesChannel.customerGroupId` ,
`product_export.salesChannel` . `currency_id` as `product_export.salesChannel.currencyId` ,
`product_export.salesChannel` . `payment_method_id` as `product_export.salesChannel.paymentMethodId` ,
`product_export.salesChannel` . `shipping_method_id` as `product_export.salesChannel.shippingMethodId` ,
`product_export.salesChannel` . `country_id` as `product_export.salesChannel.countryId` ,
`product_export.salesChannel` . `analytics_id` as `product_export.salesChannel.analyticsId` ,
`product_export.salesChannel` . `navigation_category_id` as `product_export.salesChannel.navigationCategoryId` ,
`product_export.salesChannel` . `navigation_category_version_id` as `product_export.salesChannel.navigationCategoryVersionId` ,
`product_export.salesChannel` . `navigation_category_depth` as `product_export.salesChannel.navigationCategoryDepth` ,
`product_export.salesChannel` . `footer_category_id` as `product_export.salesChannel.footerCategoryId` ,
`product_export.salesChannel` . `footer_category_version_id` as `product_export.salesChannel.footerCategoryVersionId` ,
`product_export.salesChannel` . `service_category_id` as `product_export.salesChannel.serviceCategoryId` ,
`product_export.salesChannel` . `service_category_version_id` as `product_export.salesChannel.serviceCategoryVersionId` ,
`product_export.salesChannel` . `mail_header_footer_id` as `product_export.salesChannel.mailHeaderFooterId` ,
`product_export.salesChannel` . `hreflang_default_domain_id` as `product_export.salesChannel.hreflangDefaultDomainId` ,
`product_export.salesChannel` . `short_name` as `product_export.salesChannel.shortName` ,
`product_export.salesChannel` . `tax_calculation_type` as `product_export.salesChannel.taxCalculationType` ,
`product_export.salesChannel` . `access_key` as `product_export.salesChannel.accessKey` ,
`product_export.salesChannel` . `configuration` as `product_export.salesChannel.configuration` ,
`product_export.salesChannel` . `active` as `product_export.salesChannel.active` ,
`product_export.salesChannel` . `hreflang_active` as `product_export.salesChannel.hreflangActive` ,
`product_export.salesChannel` . `maintenance` as `product_export.salesChannel.maintenance` ,
`product_export.salesChannel` . `maintenance_ip_whitelist` as `product_export.salesChannel.maintenanceIpWhitelist` ,
`product_export.salesChannel` . `payment_method_ids` as `product_export.salesChannel.paymentMethodIds` ,
`product_export.salesChannel` . `home_cms_page_id` as `product_export.salesChannel.homeCmsPageId` ,
`product_export.salesChannel` . `home_cms_page_version_id` as `product_export.salesChannel.homeCmsPageVersionId` ,
`product_export.salesChannel.analytics` . `id` as `product_export.salesChannel.analytics.id` ,
`product_export.salesChannel.analytics` . `tracking_id` as `product_export.salesChannel.analytics.trackingId` ,
`product_export.salesChannel.analytics` . `active` as `product_export.salesChannel.analytics.active` ,
`product_export.salesChannel.analytics` . `track_orders` as `product_export.salesChannel.analytics.trackOrders` ,
`product_export.salesChannel.analytics` . `anonymize_ip` as `product_export.salesChannel.analytics.anonymizeIp` ,
`product_export.salesChannel.analytics` . `created_at` as `product_export.salesChannel.analytics.createdAt` ,
`product_export.salesChannel.analytics` . `updated_at` as `product_export.salesChannel.analytics.updatedAt` ,
`product_export.salesChannel` . `created_at` as `product_export.salesChannel.createdAt` ,
`product_export.salesChannel` . `updated_at` as `product_export.salesChannel.updatedAt` ,
`product_export.salesChannel.translation.name` ,
COALESCE (
`product_export.salesChannel.translation.name` ,
`product_export.salesChannel.translation.name`
) as `product_export.salesChannel.name` ,
`product_export.salesChannel.translation.homeSlotConfig` ,
COALESCE (
`product_export.salesChannel.translation.homeSlotConfig` ,
`product_export.salesChannel.translation.homeSlotConfig`
) as `product_export.salesChannel.homeSlotConfig` ,
`product_export.salesChannel.translation.homeEnabled` ,
COALESCE (
`product_export.salesChannel.translation.homeEnabled` ,
`product_export.salesChannel.translation.homeEnabled`
) as `product_export.salesChannel.homeEnabled` ,
`product_export.salesChannel.translation.homeName` ,
COALESCE (
`product_export.salesChannel.translation.homeName` ,
`product_export.salesChannel.translation.homeName`
) as `product_export.salesChannel.homeName` ,
`product_export.salesChannel.translation.homeMetaTitle` ,
COALESCE (
`product_export.salesChannel.translation.homeMetaTitle` ,
`product_export.salesChannel.translation.homeMetaTitle`
) as `product_export.salesChannel.homeMetaTitle` ,
`product_export.salesChannel.translation.homeMetaDescription` ,
COALESCE (
`product_export.salesChannel.translation.homeMetaDescription` ,
`product_export.salesChannel.translation.homeMetaDescription`
) as `product_export.salesChannel.homeMetaDescription` ,
`product_export.salesChannel.translation.homeKeywords` ,
COALESCE (
`product_export.salesChannel.translation.homeKeywords` ,
`product_export.salesChannel.translation.homeKeywords`
) as `product_export.salesChannel.homeKeywords` ,
`product_export.salesChannel.translation.customFields` ,
COALESCE (
`product_export.salesChannel.translation.customFields` ,
`product_export.salesChannel.translation.customFields`
) as `product_export.salesChannel.customFields` ,
`product_export.salesChannel.translation.createdAt` ,
`product_export.salesChannel.translation.updatedAt` ,
`product_export.salesChannel.translation.salesChannelId` ,
`product_export.salesChannel.translation.languageId`
FROM
`product_export`
LEFT JOIN `sales_channel` `product_export.salesChannel` ON `product_export` . `sales_channel_id` = `product_export.salesChannel` . `id`
LEFT JOIN `sales_channel_domain` `product_export.salesChannelDomain` ON `product_export` . `sales_channel_domain_id` = `product_export.salesChannelDomain` . `id`
LEFT JOIN (
SELECT
`product_export.salesChannel.translation` . sales_channel_id ,
`product_export.salesChannel.translation` . name as `product_export.salesChannel.translation.name` ,
`product_export.salesChannel.translation` . home_slot_config as `product_export.salesChannel.translation.homeSlotConfig` ,
`product_export.salesChannel.translation` . home_enabled as `product_export.salesChannel.translation.homeEnabled` ,
`product_export.salesChannel.translation` . home_name as `product_export.salesChannel.translation.homeName` ,
`product_export.salesChannel.translation` . home_meta_title as `product_export.salesChannel.translation.homeMetaTitle` ,
`product_export.salesChannel.translation` . home_meta_description as `product_export.salesChannel.translation.homeMetaDescription` ,
`product_export.salesChannel.translation` . home_keywords as `product_export.salesChannel.translation.homeKeywords` ,
`product_export.salesChannel.translation` . custom_fields as `product_export.salesChannel.translation.customFields` ,
`product_export.salesChannel.translation` . created_at as `product_export.salesChannel.translation.createdAt` ,
`product_export.salesChannel.translation` . updated_at as `product_export.salesChannel.translation.updatedAt` ,
`product_export.salesChannel.translation` . sales_channel_id as `product_export.salesChannel.translation.salesChannelId` ,
`product_export.salesChannel.translation` . language_id as `product_export.salesChannel.translation.languageId`
FROM
`sales_channel_translation` `product_export.salesChannel.translation`
WHERE
`product_export.salesChannel.translation` . language_id = ?
) `product_export.salesChannel.sales_channel_translation` ON `product_export.salesChannel.sales_channel_translation` . `sales_channel_id` = `product_export.salesChannel` . `id`
LEFT JOIN `sales_channel_analytics` `product_export.salesChannel.analytics` ON `product_export.salesChannel` . `analytics_id` = `product_export.salesChannel.analytics` . `id`
LEFT JOIN `sales_channel` `product_export.salesChannelDomain.salesChannel` ON `product_export.salesChannelDomain` . `sales_channel_id` = `product_export.salesChannelDomain.salesChannel` . `id`
WHERE
(
(
`product_export` . `generate_by_cronjob` = ?
AND `product_export.salesChannel` . `active` = ?
)
AND (
`product_export` . `storefront_sales_channel_id` = ?
OR `product_export.salesChannelDomain.salesChannel` . `id` = ?
)
)
Copy
SELECT `product_export` . `id` as `product_export.id` , `product_export` . `product_stream_id` as `product_export.productStreamId` , `product_export` . `storefront_sales_channel_id` as `product_export.storefrontSalesChannelId` , `product_export` . `sales_channel_id` as `product_export.salesChannelId` , `product_export` . `sales_channel_domain_id` as `product_export.salesChannelDomainId` , `product_export` . `currency_id` as `product_export.currencyId` , `product_export` . `file_name` as `product_export.fileName` , `product_export` . `access_key` as `product_export.accessKey` , `product_export` . `encoding` as `product_export.encoding` , `product_export` . `file_format` as `product_export.fileFormat` , `product_export` . `include_variants` as `product_export.includeVariants` , `product_export` . `generate_by_cronjob` as `product_export.generateByCronjob` , `product_export` . `generated_at` as `product_export.generatedAt` , `product_export` . `interval` as `product_export.interval` , `product_export` . `header_template` as `product_export.headerTemplate` , `product_export` . `body_template` as `product_export.bodyTemplate` , `product_export` . `footer_template` as `product_export.footerTemplate` , `product_export` . `paused_schedule` as `product_export.pausedSchedule` , `product_export` . `is_running` as `product_export.isRunning` , `product_export` . `created_at` as `product_export.createdAt` , `product_export` . `updated_at` as `product_export.updatedAt` , `product_export.salesChannel` . `id` as `product_export.salesChannel.id` , `product_export.salesChannel` . `type_id` as `product_export.salesChannel.typeId` , `product_export.salesChannel` . `language_id` as `product_export.salesChannel.languageId` , `product_export.salesChannel` . `customer_group_id` as `product_export.salesChannel.customerGroupId` , `product_export.salesChannel` . `currency_id` as `product_export.salesChannel.currencyId` , `product_export.salesChannel` . `payment_method_id` as `product_export.salesChannel.paymentMethodId` , `product_export.salesChannel` . `shipping_method_id` as `product_export.salesChannel.shippingMethodId` , `product_export.salesChannel` . `country_id` as `product_export.salesChannel.countryId` , `product_export.salesChannel` . `analytics_id` as `product_export.salesChannel.analyticsId` , `product_export.salesChannel` . `navigation_category_id` as `product_export.salesChannel.navigationCategoryId` , `product_export.salesChannel` . `navigation_category_version_id` as `product_export.salesChannel.navigationCategoryVersionId` , `product_export.salesChannel` . `navigation_category_depth` as `product_export.salesChannel.navigationCategoryDepth` , `product_export.salesChannel` . `footer_category_id` as `product_export.salesChannel.footerCategoryId` , `product_export.salesChannel` . `footer_category_version_id` as `product_export.salesChannel.footerCategoryVersionId` , `product_export.salesChannel` . `service_category_id` as `product_export.salesChannel.serviceCategoryId` , `product_export.salesChannel` . `service_category_version_id` as `product_export.salesChannel.serviceCategoryVersionId` , `product_export.salesChannel` . `mail_header_footer_id` as `product_export.salesChannel.mailHeaderFooterId` , `product_export.salesChannel` . `hreflang_default_domain_id` as `product_export.salesChannel.hreflangDefaultDomainId` , `product_export.salesChannel` . `short_name` as `product_export.salesChannel.shortName` , `product_export.salesChannel` . `tax_calculation_type` as `product_export.salesChannel.taxCalculationType` , `product_export.salesChannel` . `access_key` as `product_export.salesChannel.accessKey` , `product_export.salesChannel` . `configuration` as `product_export.salesChannel.configuration` , `product_export.salesChannel` . `active` as `product_export.salesChannel.active` , `product_export.salesChannel` . `hreflang_active` as `product_export.salesChannel.hreflangActive` , `product_export.salesChannel` . `maintenance` as `product_export.salesChannel.maintenance` , `product_export.salesChannel` . `maintenance_ip_whitelist` as `product_export.salesChannel.maintenanceIpWhitelist` , `product_export.salesChannel` . `payment_method_ids` as `product_export.salesChannel.paymentMethodIds` , `product_export.salesChannel` . `home_cms_page_id` as `product_export.salesChannel.homeCmsPageId` , `product_export.salesChannel` . `home_cms_page_version_id` as `product_export.salesChannel.homeCmsPageVersionId` , `product_export.salesChannel.analytics` . `id` as `product_export.salesChannel.analytics.id` , `product_export.salesChannel.analytics` . `tracking_id` as `product_export.salesChannel.analytics.trackingId` , `product_export.salesChannel.analytics` . `active` as `product_export.salesChannel.analytics.active` , `product_export.salesChannel.analytics` . `track_orders` as `product_export.salesChannel.analytics.trackOrders` , `product_export.salesChannel.analytics` . `anonymize_ip` as `product_export.salesChannel.analytics.anonymizeIp` , `product_export.salesChannel.analytics` . `created_at` as `product_export.salesChannel.analytics.createdAt` , `product_export.salesChannel.analytics` . `updated_at` as `product_export.salesChannel.analytics.updatedAt` , `product_export.salesChannel` . `created_at` as `product_export.salesChannel.createdAt` , `product_export.salesChannel` . `updated_at` as `product_export.salesChannel.updatedAt` , `product_export.salesChannel.translation.name` , COALESCE (`product_export.salesChannel.translation.name` , `product_export.salesChannel.translation.name` ) as `product_export.salesChannel.name` , `product_export.salesChannel.translation.homeSlotConfig` , COALESCE (`product_export.salesChannel.translation.homeSlotConfig` , `product_export.salesChannel.translation.homeSlotConfig` ) as `product_export.salesChannel.homeSlotConfig` , `product_export.salesChannel.translation.homeEnabled` , COALESCE (`product_export.salesChannel.translation.homeEnabled` , `product_export.salesChannel.translation.homeEnabled` ) as `product_export.salesChannel.homeEnabled` , `product_export.salesChannel.translation.homeName` , COALESCE (`product_export.salesChannel.translation.homeName` , `product_export.salesChannel.translation.homeName` ) as `product_export.salesChannel.homeName` , `product_export.salesChannel.translation.homeMetaTitle` , COALESCE (`product_export.salesChannel.translation.homeMetaTitle` , `product_export.salesChannel.translation.homeMetaTitle` ) as `product_export.salesChannel.homeMetaTitle` , `product_export.salesChannel.translation.homeMetaDescription` , COALESCE (`product_export.salesChannel.translation.homeMetaDescription` , `product_export.salesChannel.translation.homeMetaDescription` ) as `product_export.salesChannel.homeMetaDescription` , `product_export.salesChannel.translation.homeKeywords` , COALESCE (`product_export.salesChannel.translation.homeKeywords` , `product_export.salesChannel.translation.homeKeywords` ) as `product_export.salesChannel.homeKeywords` , `product_export.salesChannel.translation.customFields` , COALESCE (`product_export.salesChannel.translation.customFields` , `product_export.salesChannel.translation.customFields` ) as `product_export.salesChannel.customFields` , `product_export.salesChannel.translation.createdAt` , `product_export.salesChannel.translation.updatedAt` , `product_export.salesChannel.translation.salesChannelId` , `product_export.salesChannel.translation.languageId` FROM `product_export` LEFT JOIN `sales_channel` `product_export.salesChannel` ON `product_export` . `sales_channel_id` = `product_export.salesChannel` . `id` LEFT JOIN `sales_channel_domain` `product_export.salesChannelDomain` ON `product_export` . `sales_channel_domain_id` = `product_export.salesChannelDomain` . `id` LEFT JOIN (SELECT `product_export.salesChannel.translation` . sales_channel_id , `product_export.salesChannel.translation` . name as `product_export.salesChannel.translation.name` , `product_export.salesChannel.translation` . home_slot_config as `product_export.salesChannel.translation.homeSlotConfig` , `product_export.salesChannel.translation` . home_enabled as `product_export.salesChannel.translation.homeEnabled` , `product_export.salesChannel.translation` . home_name as `product_export.salesChannel.translation.homeName` , `product_export.salesChannel.translation` . home_meta_title as `product_export.salesChannel.translation.homeMetaTitle` , `product_export.salesChannel.translation` . home_meta_description as `product_export.salesChannel.translation.homeMetaDescription` , `product_export.salesChannel.translation` . home_keywords as `product_export.salesChannel.translation.homeKeywords` , `product_export.salesChannel.translation` . custom_fields as `product_export.salesChannel.translation.customFields` , `product_export.salesChannel.translation` . created_at as `product_export.salesChannel.translation.createdAt` , `product_export.salesChannel.translation` . updated_at as `product_export.salesChannel.translation.updatedAt` , `product_export.salesChannel.translation` . sales_channel_id as `product_export.salesChannel.translation.salesChannelId` , `product_export.salesChannel.translation` . language_id as `product_export.salesChannel.translation.languageId` FROM `sales_channel_translation` `product_export.salesChannel.translation` WHERE `product_export.salesChannel.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product_export.salesChannel.sales_channel_translation` ON `product_export.salesChannel.sales_channel_translation` . `sales_channel_id` = `product_export.salesChannel` . `id` LEFT JOIN `sales_channel_analytics` `product_export.salesChannel.analytics` ON `product_export.salesChannel` . `analytics_id` = `product_export.salesChannel.analytics` . `id` LEFT JOIN `sales_channel` `product_export.salesChannelDomain.salesChannel` ON `product_export.salesChannelDomain` . `sales_channel_id` = `product_export.salesChannelDomain.salesChannel` . `id` WHERE ((`product_export` . `generate_by_cronjob` = 1 AND `product_export.salesChannel` . `active` = 1 ) AND (`product_export` . `storefront_sales_channel_id` = 0x1D51345C01AF4236ABA1B71FFA95453F OR `product_export.salesChannelDomain.salesChannel` . `id` = 0x1D51345C01AF4236ABA1B71FFA95453F ));
Copy
25.61 ms (0.42%)
28
UPDATE `scheduled_task` SET `status` = ? , `last_execution_time` = ? , `next_execution_time` = ? , `updated_at` = ? WHERE id = ?
Parameters :
[
"scheduled "
"2025-07-10 05:11:27.662 "
"2025-07-10 12:43:26.972 "
"2025-07-10 05:11:27.663 "
b"!„…G\x07 ¼Eõ‡ë¼œ\x1F ÚJj "
]
UPDATE `scheduled_task` SET `status` = 'scheduled' , `last_execution_time` = '2025-07-10 05:11:27.662' , `next_execution_time` = '2025-07-10 12:43:26.972' , `updated_at` = '2025-07-10 05:11:27.663' WHERE id = 0x2184854707BC45F587EBBC9C1FDA4A6A ;
Copy
18.87 ms (0.31%)
28
UPDATE `scheduled_task` SET `status` = ? , `updated_at` = ? WHERE id = ?
Parameters :
[
"running "
"2025-07-10 05:11:27.546 "
b"!„…G\x07 ¼Eõ‡ë¼œ\x1F ÚJj "
]
UPDATE `scheduled_task` SET `status` = 'running' , `updated_at` = '2025-07-10 05:11:27.546' WHERE id = 0x2184854707BC45F587EBBC9C1FDA4A6A ;
Copy
12.05 ms (0.20%)
18
SELECT `sales_channel` . `id` FROM `sales_channel` WHERE (`sales_channel` . `type_id` = ? AND `sales_channel` . `active` = ? )
Parameters :
[
b"Š$0€ù.Lq•F1KW|ø+ "
true
]
SELECT `sales_channel` . `id` FROM `sales_channel` WHERE (`sales_channel` . `type_id` = 0x8A243080F92E4C719546314B577CF82B AND `sales_channel` . `active` = 1 );
Copy
8.52 ms (0.14%)
2
SELECT `product` . auto_increment , LOWER (HEX (`product` . id )) as id , `product` . created_at as created_at , `product` . updated_at as updated_at FROM `product` LEFT JOIN `product` parent ON `product` . parent_id = parent . id INNER JOIN product_visibility visibilities ON product . visibilities = visibilities . product_id WHERE (`product` . auto_increment > ? ) AND (`product` . version_id = ? ) AND ((`product` . available = 1 OR `product` . is_closeout )) AND (IFNULL (`product` . active , parent . active ) = 1 ) AND ((`product` . child_count = 0 OR `product` . parent_id IS NOT NULL )) AND ((`product` . parent_id IS NULL OR parent . canonical_product_id IS NULL OR parent . canonical_product_id = `product` . id )) AND (visibilities . product_version_id = ? ) AND (visibilities . sales_channel_id = ? ) ORDER BY `product` . auto_increment ASC LIMIT 100
Parameters :
[
0
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
SELECT `product` . auto_increment , LOWER (HEX (`product` . id )) as id , `product` . created_at as created_at , `product` . updated_at as updated_at FROM `product` LEFT JOIN `product` parent ON `product` . parent_id = parent . id INNER JOIN product_visibility visibilities ON product . visibilities = visibilities . product_id WHERE (`product` . auto_increment > 0 ) AND (`product` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((`product` . available = 1 OR `product` . is_closeout )) AND (IFNULL (`product` . active , parent . active ) = 1 ) AND ((`product` . child_count = 0 OR `product` . parent_id IS NOT NULL )) AND ((`product` . parent_id IS NULL OR parent . canonical_product_id IS NULL OR parent . canonical_product_id = `product` . id )) AND (visibilities . product_version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (visibilities . sales_channel_id = 0x1D51345C01AF4236ABA1B71FFA95453F ) ORDER BY `product` . auto_increment ASC LIMIT 100 ;
Copy
8.12 ms (0.13%)
2
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` . `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` . `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` . `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.title` , COALESCE (`payment_method.media.translation.title` , `payment_method.media.translation.title` ) as `payment_method.media.title` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.alt` , `payment_method.media.translation.alt` ) as `payment_method.media.alt` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` ) as `payment_method.media.customFields` , `payment_method.media.translation.createdAt` , `payment_method.media.translation.updatedAt` , `payment_method.media.translation.mediaId` , `payment_method.media.translation.languageId` , `payment_method.translation.name` , COALESCE (`payment_method.translation.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.description` , COALESCE (`payment_method.translation.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` , `payment_method.translation.createdAt` , `payment_method.translation.updatedAt` , `payment_method.translation.paymentMethodId` , `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` FROM `payment_method_translation` `payment_method.translation` 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` FROM `media_translation` `payment_method.media.translation` 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"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"³¹µ\x12 4G╗Øz\r #Ë┤\x1D d "
]
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` . `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` . `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` . `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.title` ,
COALESCE (
`payment_method.media.translation.title` ,
`payment_method.media.translation.title`
) as `payment_method.media.title` ,
`payment_method.media.translation.alt` ,
COALESCE (
`payment_method.media.translation.alt` ,
`payment_method.media.translation.alt`
) as `payment_method.media.alt` ,
`payment_method.media.translation.customFields` ,
COALESCE (
`payment_method.media.translation.customFields` ,
`payment_method.media.translation.customFields`
) as `payment_method.media.customFields` ,
`payment_method.media.translation.createdAt` ,
`payment_method.media.translation.updatedAt` ,
`payment_method.media.translation.mediaId` ,
`payment_method.media.translation.languageId` ,
`payment_method.translation.name` ,
COALESCE (
`payment_method.translation.name` ,
`payment_method.translation.name`
) as `payment_method.name` ,
`payment_method.translation.distinguishableName` ,
COALESCE (
`payment_method.translation.distinguishableName` ,
`payment_method.translation.distinguishableName`
) as `payment_method.distinguishableName` ,
`payment_method.translation.description` ,
COALESCE (
`payment_method.translation.description` ,
`payment_method.translation.description`
) as `payment_method.description` ,
`payment_method.translation.customFields` ,
COALESCE (
`payment_method.translation.customFields` ,
`payment_method.translation.customFields`
) as `payment_method.customFields` ,
`payment_method.translation.createdAt` ,
`payment_method.translation.updatedAt` ,
`payment_method.translation.paymentMethodId` ,
`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`
FROM
`payment_method_translation` `payment_method.translation`
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`
FROM
`media_translation` `payment_method.media.translation`
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` . `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` . `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` . `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.title` , COALESCE (`payment_method.media.translation.title` , `payment_method.media.translation.title` ) as `payment_method.media.title` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.alt` , `payment_method.media.translation.alt` ) as `payment_method.media.alt` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` ) as `payment_method.media.customFields` , `payment_method.media.translation.createdAt` , `payment_method.media.translation.updatedAt` , `payment_method.media.translation.mediaId` , `payment_method.media.translation.languageId` , `payment_method.translation.name` , COALESCE (`payment_method.translation.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.description` , COALESCE (`payment_method.translation.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` , `payment_method.translation.createdAt` , `payment_method.translation.updatedAt` , `payment_method.translation.paymentMethodId` , `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` FROM `payment_method_translation` `payment_method.translation` 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` FROM `media_translation` `payment_method.media.translation` 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 (0xFCF0FBE6123447BB9D7A0D23D3B41D64 );
Copy
6.69 ms (0.11%)
2
SELECT `category` . auto_increment , LOWER (HEX (`category` . id )) as id , `category` . created_at , `category` . updated_at FROM `category` WHERE (`category` . auto_increment > ? ) AND ((`category` . path LIKE ? OR `category` . path LIKE ? OR `category` . path LIKE ? )) AND (`category` . version_id = ? ) AND (`category` . active = 1 ) AND (`category` . type ! = ? ) ORDER BY `category` . auto_increment ASC LIMIT 100
Parameters :
[
0
"%|e20324cea29341109605337617a0c677|% "
"%|e20324cea29341109605337617a0c677|% "
"%|e20324cea29341109605337617a0c677|% "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
"link "
]
SELECT `category` . auto_increment , LOWER (HEX (`category` . id )) as id , `category` . created_at , `category` . updated_at FROM `category` WHERE (`category` . auto_increment > 0 ) AND ((`category` . path LIKE '%|e20324cea29341109605337617a0c677|%' OR `category` . path LIKE '%|e20324cea29341109605337617a0c677|%' OR `category` . path LIKE '%|e20324cea29341109605337617a0c677|%' )) AND (`category` . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . active = 1 ) AND (`category` . type ! = 'link' ) ORDER BY `category` . auto_increment ASC LIMIT 100 ;
Copy
4.07 ms (0.07%)
2
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.name` , COALESCE (`shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` ) as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` ) as `shipping_method.deliveryTime.customFields` , `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation.languageId` , `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` . `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.title` , COALESCE (`shipping_method.media.translation.title` , `shipping_method.media.translation.title` ) as `shipping_method.media.title` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` ) as `shipping_method.media.alt` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` ) as `shipping_method.media.customFields` , `shipping_method.media.translation.createdAt` , `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation.mediaId` , `shipping_method.media.translation.languageId` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.name` , `shipping_method.translation.name` ) as `shipping_method.name` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.description` , `shipping_method.translation.description` ) as `shipping_method.description` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` ) as `shipping_method.trackingUrl` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.customFields` , `shipping_method.translation.customFields` ) as `shipping_method.customFields` , `shipping_method.translation.createdAt` , `shipping_method.translation.updatedAt` , `shipping_method.translation.shippingMethodId` , `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` FROM `shipping_method_translation` `shipping_method.translation` 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 `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` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` 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` FROM `media_translation` `shipping_method.media.translation` 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"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b")!\x01 ¡]\x03 H4Æi|CS§¹Å "
]
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.name` ,
COALESCE (
`shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation.name`
) as `shipping_method.deliveryTime.name` ,
`shipping_method.deliveryTime.translation.customFields` ,
COALESCE (
`shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation.customFields`
) as `shipping_method.deliveryTime.customFields` ,
`shipping_method.deliveryTime.translation.createdAt` ,
`shipping_method.deliveryTime.translation.updatedAt` ,
`shipping_method.deliveryTime.translation.deliveryTimeId` ,
`shipping_method.deliveryTime.translation.languageId` ,
`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` . `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.title` ,
COALESCE (
`shipping_method.media.translation.title` ,
`shipping_method.media.translation.title`
) as `shipping_method.media.title` ,
`shipping_method.media.translation.alt` ,
COALESCE (
`shipping_method.media.translation.alt` ,
`shipping_method.media.translation.alt`
) as `shipping_method.media.alt` ,
`shipping_method.media.translation.customFields` ,
COALESCE (
`shipping_method.media.translation.customFields` ,
`shipping_method.media.translation.customFields`
) as `shipping_method.media.customFields` ,
`shipping_method.media.translation.createdAt` ,
`shipping_method.media.translation.updatedAt` ,
`shipping_method.media.translation.mediaId` ,
`shipping_method.media.translation.languageId` ,
`shipping_method.translation.name` ,
COALESCE (
`shipping_method.translation.name` ,
`shipping_method.translation.name`
) as `shipping_method.name` ,
`shipping_method.translation.description` ,
COALESCE (
`shipping_method.translation.description` ,
`shipping_method.translation.description`
) as `shipping_method.description` ,
`shipping_method.translation.trackingUrl` ,
COALESCE (
`shipping_method.translation.trackingUrl` ,
`shipping_method.translation.trackingUrl`
) as `shipping_method.trackingUrl` ,
`shipping_method.translation.customFields` ,
COALESCE (
`shipping_method.translation.customFields` ,
`shipping_method.translation.customFields`
) as `shipping_method.customFields` ,
`shipping_method.translation.createdAt` ,
`shipping_method.translation.updatedAt` ,
`shipping_method.translation.shippingMethodId` ,
`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`
FROM
`shipping_method_translation` `shipping_method.translation`
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 `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`
FROM
`delivery_time_translation` `shipping_method.deliveryTime.translation`
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`
FROM
`media_translation` `shipping_method.media.translation`
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.name` , COALESCE (`shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` ) as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` ) as `shipping_method.deliveryTime.customFields` , `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation.languageId` , `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` . `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.title` , COALESCE (`shipping_method.media.translation.title` , `shipping_method.media.translation.title` ) as `shipping_method.media.title` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` ) as `shipping_method.media.alt` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` ) as `shipping_method.media.customFields` , `shipping_method.media.translation.createdAt` , `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation.mediaId` , `shipping_method.media.translation.languageId` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.name` , `shipping_method.translation.name` ) as `shipping_method.name` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.description` , `shipping_method.translation.description` ) as `shipping_method.description` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` ) as `shipping_method.trackingUrl` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.customFields` , `shipping_method.translation.customFields` ) as `shipping_method.customFields` , `shipping_method.translation.createdAt` , `shipping_method.translation.updatedAt` , `shipping_method.translation.shippingMethodId` , `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` FROM `shipping_method_translation` `shipping_method.translation` 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 `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` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` 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` FROM `media_translation` `shipping_method.media.translation` 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 (0x292101AD5D03483492697C4353F5FB8F );
Copy
3.65 ms (0.06%)
2
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel.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.shortName` , COALESCE (`sales_channel.currency.translation.shortName` , `sales_channel.currency.translation.shortName` ) as `sales_channel.currency.shortName` , `sales_channel.currency.translation.name` , COALESCE (`sales_channel.currency.translation.name` , `sales_channel.currency.translation.name` ) as `sales_channel.currency.name` , `sales_channel.currency.translation.customFields` , COALESCE (`sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.customFields` ) as `sales_channel.currency.customFields` , `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation.languageId` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name as `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name as `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` , `sales_channel.translation` . created_at as `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` 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` FROM `currency_translation` `sales_channel.currency.translation` 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"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
SELECT
`sales_channel` . `id` as `sales_channel.id` ,
`sales_channel` . `type_id` as `sales_channel.typeId` ,
`sales_channel` . `language_id` as `sales_channel.languageId` ,
`sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` ,
`sales_channel` . `currency_id` as `sales_channel.currencyId` ,
`sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` ,
`sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` ,
`sales_channel` . `country_id` as `sales_channel.countryId` ,
`sales_channel` . `analytics_id` as `sales_channel.analyticsId` ,
`sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` ,
`sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` ,
`sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` ,
`sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` ,
`sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` ,
`sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` ,
`sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` ,
`sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` ,
`sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` ,
`sales_channel` . `short_name` as `sales_channel.shortName` ,
`sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` ,
`sales_channel` . `access_key` as `sales_channel.accessKey` ,
`sales_channel` . `configuration` as `sales_channel.configuration` ,
`sales_channel` . `active` as `sales_channel.active` ,
`sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` ,
`sales_channel` . `maintenance` as `sales_channel.maintenance` ,
`sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` ,
`sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` ,
`sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` ,
`sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` ,
`sales_channel.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.shortName` ,
COALESCE (
`sales_channel.currency.translation.shortName` ,
`sales_channel.currency.translation.shortName`
) as `sales_channel.currency.shortName` ,
`sales_channel.currency.translation.name` ,
COALESCE (
`sales_channel.currency.translation.name` ,
`sales_channel.currency.translation.name`
) as `sales_channel.currency.name` ,
`sales_channel.currency.translation.customFields` ,
COALESCE (
`sales_channel.currency.translation.customFields` ,
`sales_channel.currency.translation.customFields`
) as `sales_channel.currency.customFields` ,
`sales_channel.currency.translation.createdAt` ,
`sales_channel.currency.translation.updatedAt` ,
`sales_channel.currency.translation.currencyId` ,
`sales_channel.currency.translation.languageId` ,
`sales_channel.translation.name` ,
COALESCE (
`sales_channel.translation.name` ,
`sales_channel.translation.name`
) as `sales_channel.name` ,
`sales_channel.translation.homeSlotConfig` ,
COALESCE (
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig`
) as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.homeEnabled` ,
COALESCE (
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled`
) as `sales_channel.homeEnabled` ,
`sales_channel.translation.homeName` ,
COALESCE (
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName`
) as `sales_channel.homeName` ,
`sales_channel.translation.homeMetaTitle` ,
COALESCE (
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle`
) as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.homeMetaDescription` ,
COALESCE (
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription`
) as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.homeKeywords` ,
COALESCE (
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords`
) as `sales_channel.homeKeywords` ,
`sales_channel.translation.customFields` ,
COALESCE (
`sales_channel.translation.customFields` ,
`sales_channel.translation.customFields`
) as `sales_channel.customFields` ,
`sales_channel.translation.createdAt` ,
`sales_channel.translation.updatedAt` ,
`sales_channel.translation.salesChannelId` ,
`sales_channel.translation.languageId`
FROM
`sales_channel`
LEFT JOIN (
SELECT
`sales_channel.translation` . sales_channel_id ,
`sales_channel.translation` . name as `sales_channel.translation.name` ,
`sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation` . home_name as `sales_channel.translation.homeName` ,
`sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` ,
`sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` ,
`sales_channel.translation` . created_at as `sales_channel.translation.createdAt` ,
`sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` ,
`sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` ,
`sales_channel.translation` . language_id as `sales_channel.translation.languageId`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation` . language_id = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
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`
FROM
`currency_translation` `sales_channel.currency.translation`
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.shortName` , COALESCE (`sales_channel.currency.translation.shortName` , `sales_channel.currency.translation.shortName` ) as `sales_channel.currency.shortName` , `sales_channel.currency.translation.name` , COALESCE (`sales_channel.currency.translation.name` , `sales_channel.currency.translation.name` ) as `sales_channel.currency.name` , `sales_channel.currency.translation.customFields` , COALESCE (`sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.customFields` ) as `sales_channel.currency.customFields` , `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation.languageId` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name as `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name as `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` , `sales_channel.translation` . created_at as `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` 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` FROM `currency_translation` `sales_channel.currency.translation` 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 (0x1D51345C01AF4236ABA1B71FFA95453F );
Copy
3.02 ms (0.05%)
2
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.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.typeName` , COALESCE (`tax_rule.type.translation.typeName` , `tax_rule.type.translation.typeName` ) as `tax_rule.type.typeName` , `tax_rule.type.translation.createdAt` , `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation.taxRuleTypeId` , `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` FROM `tax_rule_type_translation` `tax_rule.type.translation` 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"/»_ââšMpªXTÎ|ãâ\v "
b"8)$g§ÐO\x1A ╝|Åß\x05\x12 *å "
b"i©ë»\x0F\x03 DV„IWœ\x19 ì\e Ú "
b"°[òŸ\x05 ·KMъɹ>Ö¾ "
]
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.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.typeName` , COALESCE (`tax_rule.type.translation.typeName` , `tax_rule.type.translation.typeName` ) as `tax_rule.type.typeName` , `tax_rule.type.translation.createdAt` , `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation.taxRuleTypeId` , `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` FROM `tax_rule_type_translation` `tax_rule.type.translation` 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 (0x38292467F5D14F1ABC7C8FE105122A86 , 0x69A9EBBB0F0344568449579C19EC1BDA , 0xB05BF29F05B74B4DADD18AC9B93ED6BE ));
Copy
2.43 ms (0.04%)
1
INSERT INTO messenger_messages (body , headers , queue_name , created_at , available_at ) VALUES (? , ? , ? , ? , ? )
Parameters :
[
"{"lastSalesChannelId":"1d51345c01af4236aba1b71ffa95453f","lastLanguageId":"2fbb5fe2e29a4d70aa5854ce7ce3e20b","lastProvider":null,"nextOffset":null,"finished":false} "
"{"type":"Shopware\\Core\\Content\\Sitemap\\ScheduledTask\\SitemapMessage","X-Message-Stamp-Symfony\\Component\\Messenger\\Stamp\\BusNameStamp":"[{\"busName\":\"messenger.bus.default\"}]","Content-Type":"application\/json"} "
"default "
"2025-07-10 05:11:27 "
"2025-07-10 05:11:27 "
]
INSERT INTO messenger_messages (body , headers , queue_name , created_at , available_at ) VALUES ('{\"lastSalesChannelId\":\"1d51345c01af4236aba1b71ffa95453f\",\"lastLanguageId\":\"2fbb5fe2e29a4d70aa5854ce7ce3e20b\",\"lastProvider\":null,\"nextOffset\":null,\"finished\":false}' , '{\"type\":\"Shopware\\\\Core\\\\Content\\\\Sitemap\\\\ScheduledTask\\\\SitemapMessage\",\"X-Message-Stamp-Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\":\"[{\\\"busName\\\":\\\"messenger.bus.default\\\"}]\",\"Content-Type\":\"application\\/json\"}' , 'default' , '2025-07-10 05:11:27' , '2025-07-10 05:11:27' );
Copy
2.42 ms (0.04%)
2
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.name` , COALESCE (`country.translation.name` , `country.translation.name` ) as `country.name` , `country.translation.addressFormat` , COALESCE (`country.translation.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.customFields` , COALESCE (`country.translation.customFields` , `country.translation.customFields` ) as `country.customFields` , `country.translation.createdAt` , `country.translation.updatedAt` , `country.translation.countryId` , `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` FROM `country_translation` `country.translation` WHERE `country.translation` . language_id = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"ôJ\x1C ²\x01 ╗M[ü]\x1C ð±▄ä▓ "
]
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.name` , COALESCE (`country.translation.name` , `country.translation.name` ) as `country.name` , `country.translation.addressFormat` , COALESCE (`country.translation.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.customFields` , COALESCE (`country.translation.customFields` , `country.translation.customFields` ) as `country.customFields` , `country.translation.createdAt` , `country.translation.updatedAt` , `country.translation.countryId` , `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` FROM `country_translation` `country.translation` WHERE `country.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x934A1CFD01BB4D5B815D1CD0F1DC84B2 );
Copy
2.40 ms (0.04%)
1
INSERT INTO `increment` (`pool` , `cluster` , `key` , `count` , `created_at` )
VALUES (? , ? , ? , 1 , ? )
ON DUPLICATE KEY UPDATE `count` = `count` + 1 , `updated_at` = ?
Parameters :
[
"message_queue "
"message_queue_stats "
"Shopware\Core\Content\Sitemap\ScheduledTask\SitemapMessage "
"2025-07-10 05:11:27.838 "
"2025-07-10 05:11:27.838 "
]
INSERT INTO `increment` (`pool` , `cluster` , `key` , `count` , `created_at` )
VALUES ('message_queue' , 'message_queue_stats' , 'Shopware\\Core\\Content\\Sitemap\\ScheduledTask\\SitemapMessage' , 1 , '2025-07-10 05:11:27.838' )
ON DUPLICATE KEY UPDATE `count` = `count` + 1 , `updated_at` = '2025-07-10 05:11:27.838'
;
Copy
2.28 ms (0.04%)
2
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.name` , COALESCE (`customer_group.translation.name` , `customer_group.translation.name` ) as `customer_group.name` , `customer_group.translation.registrationTitle` , COALESCE (`customer_group.translation.registrationTitle` , `customer_group.translation.registrationTitle` ) as `customer_group.registrationTitle` , `customer_group.translation.registrationIntroduction` , COALESCE (`customer_group.translation.registrationIntroduction` , `customer_group.translation.registrationIntroduction` ) as `customer_group.registrationIntroduction` , `customer_group.translation.registrationOnlyCompanyRegistration` , COALESCE (`customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` ) as `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationSeoMetaDescription` , COALESCE (`customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` ) as `customer_group.registrationSeoMetaDescription` , `customer_group.translation.customFields` , COALESCE (`customer_group.translation.customFields` , `customer_group.translation.customFields` ) as `customer_group.customFields` , `customer_group.translation.createdAt` , `customer_group.translation.updatedAt` , `customer_group.translation.customerGroupId` , `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` FROM `customer_group_translation` `customer_group.translation` 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"/»_ââš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.name` , COALESCE (`customer_group.translation.name` , `customer_group.translation.name` ) as `customer_group.name` , `customer_group.translation.registrationTitle` , COALESCE (`customer_group.translation.registrationTitle` , `customer_group.translation.registrationTitle` ) as `customer_group.registrationTitle` , `customer_group.translation.registrationIntroduction` , COALESCE (`customer_group.translation.registrationIntroduction` , `customer_group.translation.registrationIntroduction` ) as `customer_group.registrationIntroduction` , `customer_group.translation.registrationOnlyCompanyRegistration` , COALESCE (`customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` ) as `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationSeoMetaDescription` , COALESCE (`customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` ) as `customer_group.registrationSeoMetaDescription` , `customer_group.translation.customFields` , COALESCE (`customer_group.translation.customFields` , `customer_group.translation.customFields` ) as `customer_group.customFields` , `customer_group.translation.createdAt` , `customer_group.translation.updatedAt` , `customer_group.translation.customerGroupId` , `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` FROM `customer_group_translation` `customer_group.translation` 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
2.25 ms (0.04%)
2
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"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
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 = 0x1D51345C01AF4236ABA1B71FFA95453F
GROUP BY sales_channel . id , sales_channel . language_id , sales_channel . currency_id , currency . factor ;
Copy
1.96 ms (0.03%)
1
SELECT LOWER (HEX (foreign_key )) as foreign_key , seo_path_info
FROM seo_url WHERE foreign_key IN (? , ? , ? , ? , ? , ? , ? , ? )
AND `seo_url` . `route_name` = ?
AND `seo_url` . `is_canonical` = 1
AND `seo_url` . `is_deleted` = 0
AND `seo_url` . `language_id` = ?
AND (`seo_url` . `sales_channel_id` = ? OR seo_url . sales_channel_id IS NULL )
Parameters :
[
b"PèkÅÕÝIÁ© \x04 ÷╗┼\x12 ó "
b"\x19 ╩@WÉ O\x07 ¬╚┼ÖÈ1xh "
b"Hù\x7F C/ÐA8‹&0\x18 A9Ï\x0E "
b"»"°[ÿ‘@ó€‹\x1C ÿ—[uë "
b"¥\x15 ®&\x02 #FoŽ7G\x1D 'žd\x06 "
b"ìÚ┤ä┼OD\x1C ëGtÕ§~H\ "
b"!…\x18 ,»ÔF.¨D«ë*C‹3 "
b"%\x14 H╣\e ÃBÌàd?_╠ÏÉQ "
"frontend.navigation.page "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
SELECT LOWER (HEX (foreign_key )) as foreign_key , seo_path_info
FROM seo_url WHERE foreign_key IN (0x508A6B8FE5ED49B5B8FF04F6BBC512A2 , 0x19CA405790FF4F07AAC8C599D4317868 , 0x48F97F432FD041388B2630184139CF0E , 0xBB22B05BFF9140F3808B1CFF975B75EB , 0xA515AE260223466F8E37471D279E6406 , 0x8DE9B484C54F441C894774E5F57E485C , 0x2185182CBBD4462EA844ABEB2A438B33 , 0x251448B91BC742DE85643F5FCCD89051 )
AND `seo_url` . `route_name` = 'frontend.navigation.page'
AND `seo_url` . `is_canonical` = 1
AND `seo_url` . `is_deleted` = 0
AND `seo_url` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B
AND (`seo_url` . `sales_channel_id` = 0x1D51345C01AF4236ABA1B71FFA95453F OR seo_url . sales_channel_id IS NULL );
Copy
1.79 ms (0.03%)
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.type` . `id` as `sales_channel.type.id` , `sales_channel.type` . `cover_url` as `sales_channel.type.coverUrl` , `sales_channel.type` . `icon_name` as `sales_channel.type.iconName` , `sales_channel.type` . `screenshot_urls` as `sales_channel.type.screenshotUrls` , `sales_channel.type` . `created_at` as `sales_channel.type.createdAt` , `sales_channel.type` . `updated_at` as `sales_channel.type.updatedAt` , `sales_channel.type.translation.name` , COALESCE (`sales_channel.type.translation.name` , `sales_channel.type.translation.name` ) as `sales_channel.type.name` , `sales_channel.type.translation.manufacturer` , COALESCE (`sales_channel.type.translation.manufacturer` , `sales_channel.type.translation.manufacturer` ) as `sales_channel.type.manufacturer` , `sales_channel.type.translation.description` , COALESCE (`sales_channel.type.translation.description` , `sales_channel.type.translation.description` ) as `sales_channel.type.description` , `sales_channel.type.translation.descriptionLong` , COALESCE (`sales_channel.type.translation.descriptionLong` , `sales_channel.type.translation.descriptionLong` ) as `sales_channel.type.descriptionLong` , `sales_channel.type.translation.customFields` , COALESCE (`sales_channel.type.translation.customFields` , `sales_channel.type.translation.customFields` ) as `sales_channel.type.customFields` , `sales_channel.type.translation.createdAt` , `sales_channel.type.translation.updatedAt` , `sales_channel.type.translation.salesChannelTypeId` , `sales_channel.type.translation.languageId` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name as `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name as `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` , `sales_channel.translation` . created_at as `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id` LEFT JOIN `sales_channel_type` `sales_channel.type` ON `sales_channel` . `type_id` = `sales_channel.type` . `id` LEFT JOIN (SELECT `sales_channel.type.translation` . sales_channel_type_id , `sales_channel.type.translation` . name as `sales_channel.type.translation.name` , `sales_channel.type.translation` . manufacturer as `sales_channel.type.translation.manufacturer` , `sales_channel.type.translation` . description as `sales_channel.type.translation.description` , `sales_channel.type.translation` . description_long as `sales_channel.type.translation.descriptionLong` , `sales_channel.type.translation` . custom_fields as `sales_channel.type.translation.customFields` , `sales_channel.type.translation` . created_at as `sales_channel.type.translation.createdAt` , `sales_channel.type.translation` . updated_at as `sales_channel.type.translation.updatedAt` , `sales_channel.type.translation` . sales_channel_type_id as `sales_channel.type.translation.salesChannelTypeId` , `sales_channel.type.translation` . language_id as `sales_channel.type.translation.languageId` FROM `sales_channel_type_translation` `sales_channel.type.translation` WHERE `sales_channel.type.translation` . language_id = ? ) `sales_channel.type.sales_channel_type_translation` ON `sales_channel.type.sales_channel_type_translation` . `sales_channel_type_id` = `sales_channel.type` . `id` WHERE `sales_channel` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
SELECT
`sales_channel` . `id` as `sales_channel.id` ,
`sales_channel` . `type_id` as `sales_channel.typeId` ,
`sales_channel` . `language_id` as `sales_channel.languageId` ,
`sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` ,
`sales_channel` . `currency_id` as `sales_channel.currencyId` ,
`sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` ,
`sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` ,
`sales_channel` . `country_id` as `sales_channel.countryId` ,
`sales_channel` . `analytics_id` as `sales_channel.analyticsId` ,
`sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` ,
`sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` ,
`sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` ,
`sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` ,
`sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` ,
`sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` ,
`sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` ,
`sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` ,
`sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` ,
`sales_channel` . `short_name` as `sales_channel.shortName` ,
`sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` ,
`sales_channel` . `access_key` as `sales_channel.accessKey` ,
`sales_channel` . `configuration` as `sales_channel.configuration` ,
`sales_channel` . `active` as `sales_channel.active` ,
`sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` ,
`sales_channel` . `maintenance` as `sales_channel.maintenance` ,
`sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` ,
`sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` ,
`sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` ,
`sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` ,
`sales_channel.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.type` . `id` as `sales_channel.type.id` ,
`sales_channel.type` . `cover_url` as `sales_channel.type.coverUrl` ,
`sales_channel.type` . `icon_name` as `sales_channel.type.iconName` ,
`sales_channel.type` . `screenshot_urls` as `sales_channel.type.screenshotUrls` ,
`sales_channel.type` . `created_at` as `sales_channel.type.createdAt` ,
`sales_channel.type` . `updated_at` as `sales_channel.type.updatedAt` ,
`sales_channel.type.translation.name` ,
COALESCE (
`sales_channel.type.translation.name` ,
`sales_channel.type.translation.name`
) as `sales_channel.type.name` ,
`sales_channel.type.translation.manufacturer` ,
COALESCE (
`sales_channel.type.translation.manufacturer` ,
`sales_channel.type.translation.manufacturer`
) as `sales_channel.type.manufacturer` ,
`sales_channel.type.translation.description` ,
COALESCE (
`sales_channel.type.translation.description` ,
`sales_channel.type.translation.description`
) as `sales_channel.type.description` ,
`sales_channel.type.translation.descriptionLong` ,
COALESCE (
`sales_channel.type.translation.descriptionLong` ,
`sales_channel.type.translation.descriptionLong`
) as `sales_channel.type.descriptionLong` ,
`sales_channel.type.translation.customFields` ,
COALESCE (
`sales_channel.type.translation.customFields` ,
`sales_channel.type.translation.customFields`
) as `sales_channel.type.customFields` ,
`sales_channel.type.translation.createdAt` ,
`sales_channel.type.translation.updatedAt` ,
`sales_channel.type.translation.salesChannelTypeId` ,
`sales_channel.type.translation.languageId` ,
`sales_channel.translation.name` ,
COALESCE (
`sales_channel.translation.name` ,
`sales_channel.translation.name`
) as `sales_channel.name` ,
`sales_channel.translation.homeSlotConfig` ,
COALESCE (
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig`
) as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.homeEnabled` ,
COALESCE (
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled`
) as `sales_channel.homeEnabled` ,
`sales_channel.translation.homeName` ,
COALESCE (
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName`
) as `sales_channel.homeName` ,
`sales_channel.translation.homeMetaTitle` ,
COALESCE (
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle`
) as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.homeMetaDescription` ,
COALESCE (
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription`
) as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.homeKeywords` ,
COALESCE (
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords`
) as `sales_channel.homeKeywords` ,
`sales_channel.translation.customFields` ,
COALESCE (
`sales_channel.translation.customFields` ,
`sales_channel.translation.customFields`
) as `sales_channel.customFields` ,
`sales_channel.translation.createdAt` ,
`sales_channel.translation.updatedAt` ,
`sales_channel.translation.salesChannelId` ,
`sales_channel.translation.languageId`
FROM
`sales_channel`
LEFT JOIN (
SELECT
`sales_channel.translation` . sales_channel_id ,
`sales_channel.translation` . name as `sales_channel.translation.name` ,
`sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation` . home_name as `sales_channel.translation.homeName` ,
`sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` ,
`sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` ,
`sales_channel.translation` . created_at as `sales_channel.translation.createdAt` ,
`sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` ,
`sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` ,
`sales_channel.translation` . language_id as `sales_channel.translation.languageId`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation` . language_id = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id`
LEFT JOIN `sales_channel_type` `sales_channel.type` ON `sales_channel` . `type_id` = `sales_channel.type` . `id`
LEFT JOIN (
SELECT
`sales_channel.type.translation` . sales_channel_type_id ,
`sales_channel.type.translation` . name as `sales_channel.type.translation.name` ,
`sales_channel.type.translation` . manufacturer as `sales_channel.type.translation.manufacturer` ,
`sales_channel.type.translation` . description as `sales_channel.type.translation.description` ,
`sales_channel.type.translation` . description_long as `sales_channel.type.translation.descriptionLong` ,
`sales_channel.type.translation` . custom_fields as `sales_channel.type.translation.customFields` ,
`sales_channel.type.translation` . created_at as `sales_channel.type.translation.createdAt` ,
`sales_channel.type.translation` . updated_at as `sales_channel.type.translation.updatedAt` ,
`sales_channel.type.translation` . sales_channel_type_id as `sales_channel.type.translation.salesChannelTypeId` ,
`sales_channel.type.translation` . language_id as `sales_channel.type.translation.languageId`
FROM
`sales_channel_type_translation` `sales_channel.type.translation`
WHERE
`sales_channel.type.translation` . language_id = ?
) `sales_channel.type.sales_channel_type_translation` ON `sales_channel.type.sales_channel_type_translation` . `sales_channel_type_id` = `sales_channel.type` . `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.type` . `id` as `sales_channel.type.id` , `sales_channel.type` . `cover_url` as `sales_channel.type.coverUrl` , `sales_channel.type` . `icon_name` as `sales_channel.type.iconName` , `sales_channel.type` . `screenshot_urls` as `sales_channel.type.screenshotUrls` , `sales_channel.type` . `created_at` as `sales_channel.type.createdAt` , `sales_channel.type` . `updated_at` as `sales_channel.type.updatedAt` , `sales_channel.type.translation.name` , COALESCE (`sales_channel.type.translation.name` , `sales_channel.type.translation.name` ) as `sales_channel.type.name` , `sales_channel.type.translation.manufacturer` , COALESCE (`sales_channel.type.translation.manufacturer` , `sales_channel.type.translation.manufacturer` ) as `sales_channel.type.manufacturer` , `sales_channel.type.translation.description` , COALESCE (`sales_channel.type.translation.description` , `sales_channel.type.translation.description` ) as `sales_channel.type.description` , `sales_channel.type.translation.descriptionLong` , COALESCE (`sales_channel.type.translation.descriptionLong` , `sales_channel.type.translation.descriptionLong` ) as `sales_channel.type.descriptionLong` , `sales_channel.type.translation.customFields` , COALESCE (`sales_channel.type.translation.customFields` , `sales_channel.type.translation.customFields` ) as `sales_channel.type.customFields` , `sales_channel.type.translation.createdAt` , `sales_channel.type.translation.updatedAt` , `sales_channel.type.translation.salesChannelTypeId` , `sales_channel.type.translation.languageId` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name as `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name as `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` , `sales_channel.translation` . created_at as `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id` LEFT JOIN `sales_channel_type` `sales_channel.type` ON `sales_channel` . `type_id` = `sales_channel.type` . `id` LEFT JOIN (SELECT `sales_channel.type.translation` . sales_channel_type_id , `sales_channel.type.translation` . name as `sales_channel.type.translation.name` , `sales_channel.type.translation` . manufacturer as `sales_channel.type.translation.manufacturer` , `sales_channel.type.translation` . description as `sales_channel.type.translation.description` , `sales_channel.type.translation` . description_long as `sales_channel.type.translation.descriptionLong` , `sales_channel.type.translation` . custom_fields as `sales_channel.type.translation.customFields` , `sales_channel.type.translation` . created_at as `sales_channel.type.translation.createdAt` , `sales_channel.type.translation` . updated_at as `sales_channel.type.translation.updatedAt` , `sales_channel.type.translation` . sales_channel_type_id as `sales_channel.type.translation.salesChannelTypeId` , `sales_channel.type.translation` . language_id as `sales_channel.type.translation.languageId` FROM `sales_channel_type_translation` `sales_channel.type.translation` WHERE `sales_channel.type.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.type.sales_channel_type_translation` ON `sales_channel.type.sales_channel_type_translation` . `sales_channel_type_id` = `sales_channel.type` . `id` WHERE `sales_channel` . `id` IN (0x1D51345C01AF4236ABA1B71FFA95453F );
Copy
1.51 ms (0.02%)
2
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"·ÒUK\f èGÍ‚ó¬›ÑÀßÊ "
b"ôJ\x1C ²\x01 ╗M[ü]\x1C ð±▄ä▓ "
]
SELECT `currency_country_rounding` . `id` FROM `currency_country_rounding` WHERE (`currency_country_rounding` . `currency_id` = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA AND `currency_country_rounding` . `country_id` = 0x934A1CFD01BB4D5B815D1CD0F1DC84B2 ) LIMIT 1 ;
Copy
1.36 ms (0.02%)
2
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
1.28 ms (0.02%)
2
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"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
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 (0x1D51345C01AF4236ABA1B71FFA95453F ));
Copy
1.07 ms (0.02%)
1
SELECT `value` FROM app_config WHERE `key` = ?
Parameters :
[
"cache-id "
]
SELECT `value` FROM app_config WHERE `key` = 'cache-id' ;
Copy
0.95 ms (0.02%)
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"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id = 0x1D51345C01AF4236ABA1B71FFA95453F OR system_config . sales_channel_id IS NULL ORDER BY sales_channel_id ASC ;
Copy
0.94 ms (0.02%)
1
SELECT `product_stream` . `id` FROM `product_stream` LEFT JOIN `product_stream_filter` `product_stream.filters` ON `product_stream` . `id` = `product_stream.filters` . `product_stream_id` WHERE ((`product_stream.filters` . `type` = ? OR `product_stream.filters` . `type` = ? )) GROUP BY `product_stream` . `id`
Parameters :
[
"until "
"since "
]
SELECT `product_stream` . `id` FROM `product_stream` LEFT JOIN `product_stream_filter` `product_stream.filters` ON `product_stream` . `id` = `product_stream.filters` . `product_stream_id` WHERE ((`product_stream.filters` . `type` = 'until' OR `product_stream.filters` . `type` = 'since' )) GROUP BY `product_stream` . `id` ;
Copy
0.92 ms (0.02%)
1
SELECT LOWER (HEX (foreign_key )) as foreign_key , seo_path_info
FROM seo_url WHERE foreign_key IN (? , ? )
AND `seo_url` . `route_name` = ?
AND `seo_url` . `is_canonical` = 1
AND `seo_url` . `is_deleted` = 0
AND `seo_url` . `language_id` = ?
AND (`seo_url` . `sales_channel_id` = ? OR seo_url . sales_channel_id IS NULL )
Parameters :
[
b"Å╠vɸLE║¥¸\x0F ╗å4&É "
b"\Ì\x06 $\ŽMÁŸˆÖDm\x00 ™~ "
"frontend.detail.page "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
SELECT LOWER (HEX (foreign_key )) as foreign_key , seo_path_info
FROM seo_url WHERE foreign_key IN (0x8FCC7690F74C45BABEF70FBB86342690 , 0x5CCC06245C8E4DC19F88D6446D00997E )
AND `seo_url` . `route_name` = 'frontend.detail.page'
AND `seo_url` . `is_canonical` = 1
AND `seo_url` . `is_deleted` = 0
AND `seo_url` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B
AND (`seo_url` . `sales_channel_id` = 0x1D51345C01AF4236ABA1B71FFA95453F OR seo_url . sales_channel_id IS NULL );
Copy
0.78 ms (0.01%)
1
SELECT `sales_channel` . `id` FROM `sales_channel` LEFT JOIN `sales_channel_domain` `sales_channel.domains` ON `sales_channel` . `id` = `sales_channel.domains` . `sales_channel_id` LEFT JOIN `sales_channel_type` `sales_channel.type` ON `sales_channel` . `type_id` = `sales_channel.type` . `id` WHERE (NOT (`sales_channel.domains` . `id` < = > ? ) AND `sales_channel.type` . `id` = ? ) GROUP BY `sales_channel` . `id`
Parameters :
[
null
b"Š$0€ù.Lq•F1KW|ø+ "
]
SELECT `sales_channel` . `id` FROM `sales_channel` LEFT JOIN `sales_channel_domain` `sales_channel.domains` ON `sales_channel` . `id` = `sales_channel.domains` . `sales_channel_id` LEFT JOIN `sales_channel_type` `sales_channel.type` ON `sales_channel` . `type_id` = `sales_channel.type` . `id` WHERE (NOT (`sales_channel.domains` . `id` < = > NULL ) AND `sales_channel.type` . `id` = 0x8A243080F92E4C719546314B577CF82B ) GROUP BY `sales_channel` . `id` ;
Copy
0.76 ms (0.01%)
1
DELETE ld FROM `log_entry` ld LEFT JOIN (
SELECT id
FROM `log_entry`
ORDER BY `created_at`
DESC LIMIT :maxEntries
) ls ON ld . ID = ls . ID
WHERE ls . ID IS NULL ;
Parameters :
[
"maxEntries " => 10000000
]
DELETE ld FROM `log_entry` ld LEFT JOIN (
SELECT id
FROM `log_entry`
ORDER BY `created_at`
DESC LIMIT 10000000
) ls ON ld . ID = ls . ID
WHERE ls . ID IS NULL ; ;
Copy
0.74 ms (0.01%)
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
0.68 ms (0.01%)
1
SELECT LOWER (HEX (language . id )) AS array_key , LOWER (HEX (language . id )) AS id , locale . code , LOWER (HEX (language . parent_id )) parentId FROM language LEFT JOIN locale locale ON language . translation_code_id = locale . id
SELECT LOWER (HEX (language . id )) AS array_key , LOWER (HEX (language . id )) AS id , locale . code , LOWER (HEX (language . parent_id )) parentId FROM language LEFT JOIN locale locale ON language . translation_code_id = locale . id ;
Copy
0.68 ms (0.01%)
1
DELETE FROM cart
WHERE (updated_at IS NULL AND created_at < = ? )
OR (updated_at IS NOT NULL AND updated_at < = ? ) LIMIT 1000 ;
Parameters :
[
"2025-03-12 05:11:28.631 "
"2025-03-12 05:11:28.631 "
]
DELETE FROM cart
WHERE (updated_at IS NULL AND created_at < = '2025-03-12 05:11:28.631' )
OR (updated_at IS NOT NULL AND updated_at < = '2025-03-12 05:11:28.631' ) LIMIT 1000 ; ;
Copy
0.63 ms (0.01%)
1
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters :
[
b"£–Óã‘ØF_«¥ˆêbî†r "
]
SELECT last_updated_password_at FROM user WHERE id = 0xA396D3E391D8465FABA588EA62EE8672 ;
Copy
0.63 ms (0.01%)
1
SELECT `newsletter_recipient` . `id` FROM `newsletter_recipient` WHERE ((`newsletter_recipient` . `created_at` < = ? ) AND `newsletter_recipient` . `status` = ? ) LIMIT 999
Parameters :
[
"2025-06-10T05:11:28+00:00 "
"notSet "
]
SELECT `newsletter_recipient` . `id` FROM `newsletter_recipient` WHERE ((`newsletter_recipient` . `created_at` < = '2025-06-10T05:11:28+00:00' ) AND `newsletter_recipient` . `status` = 'notSet' ) LIMIT 999 ;
Copy
0.62 ms (0.01%)
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
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
;
Copy
0.62 ms (0.01%)
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"\x1D Q4\\x01 ¯B6«¡·\x1F ú•E? "
]
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 (0x1D51345C01AF4236ABA1B71FFA95453F ));
Copy
0.58 ms (0.01%)
1
SELECT `acl_role` . `id` FROM `acl_role` WHERE ((`acl_role` . `deleted_at` < = ? ))
Parameters :
[
"2025-07-09 05:11:28.764 "
]
SELECT `acl_role` . `id` FROM `acl_role` WHERE ((`acl_role` . `deleted_at` < = '2025-07-09 05:11:28.764' ));
Copy
0.57 ms (0.01%)
1
SELECT
`name` ,
`base_class` AS baseClass ,
IF (`active` = 1 AND `installed_at` IS NOT NULL , 1 , 0 ) AS active ,
`path` ,
`version` ,
`autoload` ,
`managed_by_composer` AS managedByComposer ,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at` ;
SELECT
`name` ,
`base_class` AS baseClass ,
IF (`active` = 1 AND `installed_at` IS NOT NULL , 1 , 0 ) AS active ,
`path` ,
`version` ,
`autoload` ,
`managed_by_composer` AS managedByComposer ,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at` ; ;
Copy
0.49 ms (0.01%)
1
SELECT role . privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping . acl_role_id = role . id WHERE mapping . user_id = ?
Parameters :
[
b"£–Óã‘ØF_«¥ˆêbî†r "
]
SELECT role . privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping . acl_role_id = role . id WHERE mapping . user_id = 0xA396D3E391D8465FABA588EA62EE8672 ;
Copy
0.40 ms (0.01%)
1
SELECT item_rounding FROM currency WHERE id = ?
Parameters :
[
b"·ÒUK\f èGÍ‚ó¬›ÑÀßÊ "
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA ;
Copy
0.40 ms (0.01%)
1
SELECT `integration` . `id` FROM `integration` WHERE ((`integration` . `deleted_at` < = ? ))
Parameters :
[
"2025-07-09 05:11:28.764 "
]
SELECT `integration` . `id` FROM `integration` WHERE ((`integration` . `deleted_at` < = '2025-07-09 05:11:28.764' ));
Copy
0.40 ms (0.01%)
1
SELECT `import_export_file` . `id` FROM `import_export_file` WHERE ((`import_export_file` . `expire_date` < ? ))
Parameters :
[
"2025-07-10T05:11:28+00:00 "
]
SELECT `import_export_file` . `id` FROM `import_export_file` WHERE ((`import_export_file` . `expire_date` < '2025-07-10T05:11:28+00:00' ));
Copy
0.36 ms (0.01%)
1
DELETE FROM `webhook_event_log` WHERE `created_at` < ?
Parameters :
[
"2025-06-26 05:11:27.738 "
]
DELETE FROM `webhook_event_log` WHERE `created_at` < '2025-06-26 05:11:27.738' ;
Copy
0.36 ms (0.01%)
1
DELETE FROM `log_entry` WHERE `created_at` < ?
Parameters :
[
"2025-06-09 05:11:27.660 "
]
DELETE FROM `log_entry` WHERE `created_at` < '2025-06-09 05:11:27.660' ;
Copy
0.36 ms (0.01%)
1
SELECT admin FROM `user` WHERE id = ?
Parameters :
[
b"£–Óã‘ØF_«¥ˆêbî†r "
]
SELECT admin FROM `user` WHERE id = 0xA396D3E391D8465FABA588EA62EE8672 ;
Copy
0.36 ms (0.01%)
1
DELETE FROM version WHERE created_at < = ? LIMIT 1000
Parameters :
[
"2025-06-10 05:11:28.317 "
]
DELETE FROM version WHERE created_at < = '2025-06-10 05:11:28.317' LIMIT 1000 ;
Copy
0.30 ms (0.00%)
1
DELETE FROM version_commit WHERE created_at < = ? LIMIT 1000
Parameters :
[
"2025-06-10 05:11:28.317 "
]
DELETE FROM version_commit WHERE created_at < = '2025-06-10 05:11:28.317' LIMIT 1000 ;
Copy
0.27 ms (0.00%)
1
DELETE FROM sales_channel_api_context WHERE updated_at < = ?
Parameters :
[
"2025-03-12 05:11:27.940 "
]
DELETE FROM sales_channel_api_context WHERE updated_at < = '2025-03-12 05:11:27.940' ;
Copy
0.19 ms (0.00%)
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