1.21 ms
(14.20%)
|
4 |
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`write_access` AS `app.integration.writeAccess`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"\x01ŽPÊÝ\x01q…‚Kvþ¢¢\x1D´"
]
SELECT
`app`.`id` AS `app.id`,
`app`.`name` AS `app.name`,
`app`.`path` AS `app.path`,
`app`.`author` AS `app.author`,
`app`.`copyright` AS `app.copyright`,
`app`.`license` AS `app.license`,
`app`.`active` AS `app.active`,
`app`.`configurable` AS `app.configurable`,
`app`.`privacy` AS `app.privacy`,
`app`.`version` AS `app.version`,
`app`.`icon` AS `app.iconRaw`,
`app`.`app_secret` AS `app.appSecret`,
`app`.`modules` AS `app.modules`,
`app`.`main_module` AS `app.mainModule`,
`app`.`cookies` AS `app.cookies`,
`app`.`allow_disable` AS `app.allowDisable`,
`app`.`base_app_url` AS `app.baseAppUrl`,
`app`.`allowed_hosts` AS `app.allowedHosts`,
`app`.`template_load_priority` AS `app.templateLoadPriority`,
`app`.`integration_id` AS `app.integrationId`,
`app.integration`.`id` AS `app.integration.id`,
`app.integration`.`label` AS `app.integration.label`,
`app.integration`.`access_key` AS `app.integration.accessKey`,
`app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`,
`app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`,
`app.integration`.`admin` AS `app.integration.admin`,
`app.integration`.`custom_fields` AS `app.integration.customFields`,
`app.integration`.`deleted_at` AS `app.integration.deletedAt`,
`app.integration`.`write_access` AS `app.integration.writeAccess`,
`app.integration`.`created_at` AS `app.integration.createdAt`,
`app.integration`.`updated_at` AS `app.integration.updatedAt`,
`app`.`acl_role_id` AS `app.aclRoleId`,
`app.aclRole`.`id` AS `app.aclRole.id`,
`app.aclRole`.`name` AS `app.aclRole.name`,
`app.aclRole`.`description` AS `app.aclRole.description`,
`app.aclRole`.`privileges` AS `app.aclRole.privileges`,
`app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`,
`app.aclRole`.`created_at` AS `app.aclRole.createdAt`,
`app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`,
`app`.`created_at` AS `app.createdAt`,
`app`.`updated_at` AS `app.updatedAt`,
`app.translation.label`,
COALESCE(
`app.translation.label`, `app.translation.label`
) AS `app.label`,
`app.translation.description`,
COALESCE(
`app.translation.description`, `app.translation.description`
) AS `app.description`,
`app.translation.privacyPolicyExtensions`,
COALESCE(
`app.translation.privacyPolicyExtensions`,
`app.translation.privacyPolicyExtensions`
) AS `app.privacyPolicyExtensions`,
`app.translation.customFields`,
COALESCE(
`app.translation.customFields`,
`app.translation.customFields`
) AS `app.customFields`,
`app.translation.createdAt`,
`app.translation.updatedAt`,
`app.translation.appId`,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation`.app_id,
`app.translation`.label AS `app.translation.label`,
`app.translation`.description AS `app.translation.description`,
`app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`,
`app.translation`.custom_fields AS `app.translation.customFields`,
`app.translation`.created_at AS `app.translation.createdAt`,
`app.translation`.updated_at AS `app.translation.updatedAt`,
`app.translation`.app_id AS `app.translation.appId`,
`app.translation`.language_id AS `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation`.language_id = ?
) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
`app`.`id` IN (?)
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`write_access` AS `app.integration.writeAccess`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (0x018E50CADD017185824B76FEA2A21DB4);
|
1.06 ms
(12.48%)
|
3 |
"COMMIT"
|
0.78 ms
(9.13%)
|
2 |
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`write_access` AS `app.integration.writeAccess`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
true
]
SELECT
`app`.`id` AS `app.id`,
`app`.`name` AS `app.name`,
`app`.`path` AS `app.path`,
`app`.`author` AS `app.author`,
`app`.`copyright` AS `app.copyright`,
`app`.`license` AS `app.license`,
`app`.`active` AS `app.active`,
`app`.`configurable` AS `app.configurable`,
`app`.`privacy` AS `app.privacy`,
`app`.`version` AS `app.version`,
`app`.`icon` AS `app.iconRaw`,
`app`.`app_secret` AS `app.appSecret`,
`app`.`modules` AS `app.modules`,
`app`.`main_module` AS `app.mainModule`,
`app`.`cookies` AS `app.cookies`,
`app`.`allow_disable` AS `app.allowDisable`,
`app`.`base_app_url` AS `app.baseAppUrl`,
`app`.`allowed_hosts` AS `app.allowedHosts`,
`app`.`template_load_priority` AS `app.templateLoadPriority`,
`app`.`integration_id` AS `app.integrationId`,
`app.integration`.`id` AS `app.integration.id`,
`app.integration`.`label` AS `app.integration.label`,
`app.integration`.`access_key` AS `app.integration.accessKey`,
`app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`,
`app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`,
`app.integration`.`admin` AS `app.integration.admin`,
`app.integration`.`custom_fields` AS `app.integration.customFields`,
`app.integration`.`deleted_at` AS `app.integration.deletedAt`,
`app.integration`.`write_access` AS `app.integration.writeAccess`,
`app.integration`.`created_at` AS `app.integration.createdAt`,
`app.integration`.`updated_at` AS `app.integration.updatedAt`,
`app`.`acl_role_id` AS `app.aclRoleId`,
`app.aclRole`.`id` AS `app.aclRole.id`,
`app.aclRole`.`name` AS `app.aclRole.name`,
`app.aclRole`.`description` AS `app.aclRole.description`,
`app.aclRole`.`privileges` AS `app.aclRole.privileges`,
`app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`,
`app.aclRole`.`created_at` AS `app.aclRole.createdAt`,
`app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`,
`app`.`created_at` AS `app.createdAt`,
`app`.`updated_at` AS `app.updatedAt`,
`app.translation.label`,
COALESCE(
`app.translation.label`, `app.translation.label`
) AS `app.label`,
`app.translation.description`,
COALESCE(
`app.translation.description`, `app.translation.description`
) AS `app.description`,
`app.translation.privacyPolicyExtensions`,
COALESCE(
`app.translation.privacyPolicyExtensions`,
`app.translation.privacyPolicyExtensions`
) AS `app.privacyPolicyExtensions`,
`app.translation.customFields`,
COALESCE(
`app.translation.customFields`,
`app.translation.customFields`
) AS `app.customFields`,
`app.translation.createdAt`,
`app.translation.updatedAt`,
`app.translation.appId`,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation`.app_id,
`app.translation`.label AS `app.translation.label`,
`app.translation`.description AS `app.translation.description`,
`app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`,
`app.translation`.custom_fields AS `app.translation.customFields`,
`app.translation`.created_at AS `app.translation.createdAt`,
`app.translation`.updated_at AS `app.translation.updatedAt`,
`app.translation`.app_id AS `app.translation.appId`,
`app.translation`.language_id AS `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation`.language_id = ?
) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
(`app`.`active` = ?)
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`write_access` AS `app.integration.writeAccess`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);
|
0.75 ms
(8.80%)
|
2 |
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`
;
|
0.58 ms
(6.78%)
|
2 |
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`
;
|
0.48 ms
(5.63%)
|
1 |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
0.45 ms
(5.23%)
|
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\ProductExport\ScheduledTask\ProductExportGenerateTask"
"2025-06-25 13:40:27.821"
"2025-06-25 13:40:27.821"
]
INSERT INTO `increment` (`pool`, `cluster`, `key`, `count`, `created_at`)
VALUES ('message_queue', 'message_queue_stats', 'Shopware\\Core\\Content\\ProductExport\\ScheduledTask\\ProductExportGenerateTask', 1, '2025-06-25 13:40:27.821')
ON DUPLICATE KEY UPDATE `count` = `count` + 1, `updated_at` = '2025-06-25 13:40:27.821'
;
|
0.42 ms
(4.91%)
|
4 |
SELECT `script`.`id` AS `script.id`, `script`.`script` AS `script.script`, `script`.`hook` AS `script.hook`, `script`.`name` AS `script.name`, `script`.`active` AS `script.active`, `script`.`app_id` AS `script.appId`, `script`.`created_at` AS `script.createdAt`, `script`.`updated_at` AS `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters: [
b"\x01ŽPÊÝ\x01q…‚Kvþ¢¢\x1D´"
]
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 (0x018E50CADD017185824B76FEA2A21DB4));
|
0.41 ms
(4.83%)
|
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;
|
0.37 ms
(4.30%)
|
1 |
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
FROM custom_entity
LEFT JOIN app ON app.id = custom_entity.app_id
WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
FROM custom_entity
LEFT JOIN app ON app.id = custom_entity.app_id
WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
;
|
0.27 ms
(3.20%)
|
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`;;
|
0.25 ms
(2.93%)
|
1 |
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters: [
b"\x01‘¢\x00|ÐrŸ ÖÁ;3£—'"
]
SELECT last_updated_password_at FROM user WHERE id = 0x0191A2007CD0729FA0D6C13B33A39727;
|
0.17 ms
(2.05%)
|
2 |
SELECT 1 AS `exists`, `id` FROM `scheduled_task` WHERE `id` IN (?)
Parameters: [
b"\x11ð4¼\x04»BÅöÏüðèøg\x18"
]
SELECT 1 AS `exists`, `id` FROM `scheduled_task` WHERE `id` IN (0x11D034AC04AF428F94D881D08A9B6718);
|
0.17 ms
(1.95%)
|
1 |
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`.`default_run_interval` AS `scheduled_task.defaultRunInterval`, `scheduled_task`.`created_at` AS `scheduled_task.createdAt`, `scheduled_task`.`updated_at` AS `scheduled_task.updatedAt` FROM `scheduled_task` WHERE ((`scheduled_task`.`next_execution_time` < ?) AND `scheduled_task`.`status` IN (?, ?))
Parameters: [
"2025-06-25 13:40:27.758"
"scheduled"
"skipped"
]
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`.`default_run_interval` AS `scheduled_task.defaultRunInterval`, `scheduled_task`.`created_at` AS `scheduled_task.createdAt`, `scheduled_task`.`updated_at` AS `scheduled_task.updatedAt` FROM `scheduled_task` WHERE ((`scheduled_task`.`next_execution_time` < '2025-06-25 13:40:27.758') AND `scheduled_task`.`status` IN ('scheduled', 'skipped'));
|
0.16 ms
(1.93%)
|
1 |
UPDATE `scheduled_task` SET `status` = ?, `next_execution_time` = ?, `updated_at` = ? WHERE id = ?
Parameters: [
"skipped"
"2025-06-25 13:40:27.765"
"2025-06-25 13:40:27.768"
b"\x11ð4¼\x04»BÅöÏüðèøg\x18"
]
UPDATE `scheduled_task` SET `status` = 'skipped', `next_execution_time` = '2025-06-25 13:40:27.765', `updated_at` = '2025-06-25 13:40:27.768' WHERE id = 0x11D034AC04AF428F94D881D08A9B6718;
|
0.15 ms
(1.77%)
|
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;
|
0.15 ms
(1.73%)
|
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"\x01‘¢\x00|ÐrŸ ÖÁ;3£—'"
]
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0x0191A2007CD0729FA0D6C13B33A39727;
|
0.13 ms
(1.49%)
|
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',''));
|
0.11 ms
(1.33%)
|
1 |
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters: [
"{"taskId":"3d5b260a205a4aac9b541454e5a4697b"}"
"{"type":"Shopware\\Core\\Content\\ProductExport\\ScheduledTask\\ProductExportGenerateTask","X-Message-Stamp-Symfony\\Component\\Messenger\\Stamp\\BusNameStamp":"[{\"busName\":\"messenger.bus.default\"}]","Content-Type":"application\/json"}"
"default"
"2025-06-25 13:40:27"
"2025-06-25 13:40:27"
]
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('{\"taskId\":\"3d5b260a205a4aac9b541454e5a4697b\"}', '{\"type\":\"Shopware\\\\Core\\\\Content\\\\ProductExport\\\\ScheduledTask\\\\ProductExportGenerateTask\",\"X-Message-Stamp-Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\":\"[{\\\"busName\\\":\\\"messenger.bus.default\\\"}]\",\"Content-Type\":\"application\\/json\"}', 'default', '2025-06-25 13:40:27', '2025-06-25 13:40:27');
|
0.11 ms
(1.29%)
|
1 |
UPDATE `scheduled_task` SET `status` = ?, `updated_at` = ? WHERE id = ?
Parameters: [
"queued"
"2025-06-25 13:40:27.812"
b"""
=[&\n
ZJ¬›T\x14Tå¤i{
"""
]
UPDATE `scheduled_task` SET `status` = 'queued', `updated_at` = '2025-06-25 13:40:27.812' WHERE id = 0x3D5B260A205A4AAC9B541454E5A4697B;
|
0.11 ms
(1.25%)
|
3 |
"START TRANSACTION"
"START TRANSACTION";
|
0.09 ms
(1.02%)
|
1 |
SELECT module.module, module.response FROM wbm_data_layer_modules module
SELECT module.module, module.response FROM wbm_data_layer_modules module;
|
0.08 ms
(0.98%)
|
1 |
SELECT item_rounding FROM currency WHERE id = ?
Parameters: [
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
|
0.07 ms
(0.79%)
|
1 |
SELECT admin FROM `user` WHERE id = ?
Parameters: [
b"\x01‘¢\x00|ÐrŸ ÖÁ;3£—'"
]
SELECT admin FROM `user` WHERE id = 0x0191A2007CD0729FA0D6C13B33A39727;
|