| 1 |
0.12 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
| 2 |
0.09 ms |
SELECT
`name`,
`base_class` AS baseClass,
IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
`path`,
`version`,
`autoload`,
`managed_by_composer` AS managedByComposer,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at`;
SELECT
`name`,
`base_class` AS baseClass,
IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
`path`,
`version`,
`autoload`,
`managed_by_composer` AS managedByComposer,
composer_name as composerName
FROM `plugin`
ORDER BY `installed_at`;;
|
| 3 |
0.16 ms |
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
FROM custom_entity
LEFT JOIN app ON app.id = custom_entity.app_id
WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
FROM custom_entity
LEFT JOIN app ON app.id = custom_entity.app_id
WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
;
|
| 4 |
0.14 ms |
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
|
| 5 |
0.19 ms |
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;
|
| 6 |
0.10 ms |
SELECT item_rounding FROM currency WHERE id = ?
Parameters: [
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
|
| 7 |
0.47 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '201914_680c050015e178.59610073') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '201914_680c050015e178.59610073') LIMIT 1;
|
| 8 |
0.26 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=4847266) LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=4847266) LIMIT 1;
|
| 9 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 10 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 11 |
0.05 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 12 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 13 |
0.22 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1;
|
| 14 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 15 |
0.19 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 16 |
0.08 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 17 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 18 |
0.11 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 19 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 20 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 21 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 22 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1;
|
| 23 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 24 |
0.18 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 25 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 26 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 27 |
0.64 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'authInfo') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'authInfo') LIMIT 1;
|
| 28 |
0.09 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 29 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 30 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 31 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 32 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1;
|
| 33 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 34 |
0.19 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 35 |
0.11 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 36 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 37 |
0.50 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 38 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 39 |
0.47 ms |
SELECT `cleverreach_entity`.`shopware_id` as `cleverreach_entity.shopware_id`, `cleverreach_entity`.`id` as `cleverreach_entity.id`, `cleverreach_entity`.`type` as `cleverreach_entity.type`, `cleverreach_entity`.`index_1` as `cleverreach_entity.index_1`, `cleverreach_entity`.`index_2` as `cleverreach_entity.index_2`, `cleverreach_entity`.`index_3` as `cleverreach_entity.index_3`, `cleverreach_entity`.`index_4` as `cleverreach_entity.index_4`, `cleverreach_entity`.`index_5` as `cleverreach_entity.index_5`, `cleverreach_entity`.`index_6` as `cleverreach_entity.index_6`, `cleverreach_entity`.`index_7` as `cleverreach_entity.index_7`, `cleverreach_entity`.`index_8` as `cleverreach_entity.index_8`, `cleverreach_entity`.`index_9` as `cleverreach_entity.index_9`, `cleverreach_entity`.`index_10` as `cleverreach_entity.index_10`, `cleverreach_entity`.`data` as `cleverreach_entity.data` FROM `cleverreach_entity` WHERE (`cleverreach_entity`.`id` = ?)
SELECT `cleverreach_entity`.`shopware_id` as `cleverreach_entity.shopware_id`, `cleverreach_entity`.`id` as `cleverreach_entity.id`, `cleverreach_entity`.`type` as `cleverreach_entity.type`, `cleverreach_entity`.`index_1` as `cleverreach_entity.index_1`, `cleverreach_entity`.`index_2` as `cleverreach_entity.index_2`, `cleverreach_entity`.`index_3` as `cleverreach_entity.index_3`, `cleverreach_entity`.`index_4` as `cleverreach_entity.index_4`, `cleverreach_entity`.`index_5` as `cleverreach_entity.index_5`, `cleverreach_entity`.`index_6` as `cleverreach_entity.index_6`, `cleverreach_entity`.`index_7` as `cleverreach_entity.index_7`, `cleverreach_entity`.`index_8` as `cleverreach_entity.index_8`, `cleverreach_entity`.`index_9` as `cleverreach_entity.index_9`, `cleverreach_entity`.`index_10` as `cleverreach_entity.index_10`, `cleverreach_entity`.`data` as `cleverreach_entity.data` FROM `cleverreach_entity` WHERE (`cleverreach_entity`.`id` = '26');
|
| 40 |
0.10 ms |
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;
|
| 41 |
0.75 ms |
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (?)
Parameters: [
b"ëëj¸\x01hL«øÙ├[¹ºÉq"
]
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (0x89896AF701684CAE9BEBC35BFBA79071);
|
| 42 |
0.09 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 43 |
1.72 ms |
UPDATE `cleverreach_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `data` = ? WHERE shopware_id = ?
Parameters: [
"Configuration"
"isOffline"
null
"{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\Configuration\\ConfigEntity","id":"26","name":"isOffline","value":true,"context":""}"
b"ëëj¸\x01hL«øÙ├[¹ºÉq"
]
UPDATE `cleverreach_entity` SET `type` = 'Configuration', `index_1` = 'isOffline', `index_2` = NULL, `data` = '{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\Infrastructure\\\\Configuration\\\\ConfigEntity\",\"id\":\"26\",\"name\":\"isOffline\",\"value\":true,\"context\":\"\"}' WHERE shopware_id = 0x89896AF701684CAE9BEBC35BFBA79071;
|
| 44 |
0.12 ms |
"COMMIT"
|
| 45 |
0.16 ms |
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`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);
|
| 46 |
0.07 ms |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
|
| 47 |
0.06 ms |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
|
| 48 |
0.47 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1;
|
| 49 |
0.08 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 50 |
0.05 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 51 |
0.08 ms |
SELECT `cleverreach_entity`.`shopware_id` as `cleverreach_entity.shopware_id`, `cleverreach_entity`.`id` as `cleverreach_entity.id`, `cleverreach_entity`.`type` as `cleverreach_entity.type`, `cleverreach_entity`.`index_1` as `cleverreach_entity.index_1`, `cleverreach_entity`.`index_2` as `cleverreach_entity.index_2`, `cleverreach_entity`.`index_3` as `cleverreach_entity.index_3`, `cleverreach_entity`.`index_4` as `cleverreach_entity.index_4`, `cleverreach_entity`.`index_5` as `cleverreach_entity.index_5`, `cleverreach_entity`.`index_6` as `cleverreach_entity.index_6`, `cleverreach_entity`.`index_7` as `cleverreach_entity.index_7`, `cleverreach_entity`.`index_8` as `cleverreach_entity.index_8`, `cleverreach_entity`.`index_9` as `cleverreach_entity.index_9`, `cleverreach_entity`.`index_10` as `cleverreach_entity.index_10`, `cleverreach_entity`.`data` as `cleverreach_entity.data` FROM `cleverreach_entity` WHERE (`cleverreach_entity`.`id` = ?)
SELECT `cleverreach_entity`.`shopware_id` as `cleverreach_entity.shopware_id`, `cleverreach_entity`.`id` as `cleverreach_entity.id`, `cleverreach_entity`.`type` as `cleverreach_entity.type`, `cleverreach_entity`.`index_1` as `cleverreach_entity.index_1`, `cleverreach_entity`.`index_2` as `cleverreach_entity.index_2`, `cleverreach_entity`.`index_3` as `cleverreach_entity.index_3`, `cleverreach_entity`.`index_4` as `cleverreach_entity.index_4`, `cleverreach_entity`.`index_5` as `cleverreach_entity.index_5`, `cleverreach_entity`.`index_6` as `cleverreach_entity.index_6`, `cleverreach_entity`.`index_7` as `cleverreach_entity.index_7`, `cleverreach_entity`.`index_8` as `cleverreach_entity.index_8`, `cleverreach_entity`.`index_9` as `cleverreach_entity.index_9`, `cleverreach_entity`.`index_10` as `cleverreach_entity.index_10`, `cleverreach_entity`.`data` as `cleverreach_entity.data` FROM `cleverreach_entity` WHERE (`cleverreach_entity`.`id` = '26');
|
| 52 |
0.07 ms |
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (?)
Parameters: [
b"ëëj¸\x01hL«øÙ├[¹ºÉq"
]
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (0x89896AF701684CAE9BEBC35BFBA79071);
|
| 53 |
0.06 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 54 |
1.58 ms |
UPDATE `cleverreach_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `data` = ? WHERE shopware_id = ?
Parameters: [
"Configuration"
"isOffline"
null
"{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\Configuration\\ConfigEntity","id":"26","name":"isOffline","value":true,"context":""}"
b"ëëj¸\x01hL«øÙ├[¹ºÉq"
]
UPDATE `cleverreach_entity` SET `type` = 'Configuration', `index_1` = 'isOffline', `index_2` = NULL, `data` = '{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\Infrastructure\\\\Configuration\\\\ConfigEntity\",\"id\":\"26\",\"name\":\"isOffline\",\"value\":true,\"context\":\"\"}' WHERE shopware_id = 0x89896AF701684CAE9BEBC35BFBA79071;
|
| 55 |
0.09 ms |
"COMMIT"
|
| 56 |
0.14 ms |
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`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);
|
| 57 |
0.07 ms |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
|
| 58 |
0.06 ms |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
|
| 59 |
0.11 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1;
|
| 60 |
0.07 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 61 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 62 |
0.06 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 63 |
0.79 ms |
DELETE FROM cleverreach_entity WHERE id=?
Parameters: [
"7203365"
]
DELETE FROM cleverreach_entity WHERE id='7203365';
|
| 64 |
0.21 ms |
SELECT `document_type`.`id` as `document_type.id`, `document_type`.`technical_name` as `document_type.technicalName`, `document_type`.`created_at` as `document_type.createdAt`, `document_type`.`updated_at` as `document_type.updatedAt`, `document_type.translation.name`, COALESCE(`document_type.translation.name`,`document_type.translation.name`) as `document_type.name`, `document_type.translation.customFields`, COALESCE(`document_type.translation.customFields`,`document_type.translation.customFields`) as `document_type.customFields`, `document_type.translation.createdAt`, `document_type.translation.updatedAt`, `document_type.translation.documentTypeId`, `document_type.translation.languageId` FROM `document_type` LEFT JOIN (SELECT `document_type.translation`.document_type_id, `document_type.translation`.name as `document_type.translation.name`, `document_type.translation`.custom_fields as `document_type.translation.customFields`, `document_type.translation`.created_at as `document_type.translation.createdAt`, `document_type.translation`.updated_at as `document_type.translation.updatedAt`, `document_type.translation`.document_type_id as `document_type.translation.documentTypeId`, `document_type.translation`.language_id as `document_type.translation.languageId` FROM `document_type_translation` `document_type.translation` WHERE `document_type.translation`.language_id = ?) `document_type.document_type_translation` ON `document_type.document_type_translation`.`document_type_id` = `document_type`.`id` WHERE (`document_type`.`technical_name` = ?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
"invoice"
]
SELECT `document_type`.`id` as `document_type.id`, `document_type`.`technical_name` as `document_type.technicalName`, `document_type`.`created_at` as `document_type.createdAt`, `document_type`.`updated_at` as `document_type.updatedAt`, `document_type.translation.name`, COALESCE(`document_type.translation.name`,`document_type.translation.name`) as `document_type.name`, `document_type.translation.customFields`, COALESCE(`document_type.translation.customFields`,`document_type.translation.customFields`) as `document_type.customFields`, `document_type.translation.createdAt`, `document_type.translation.updatedAt`, `document_type.translation.documentTypeId`, `document_type.translation.languageId` FROM `document_type` LEFT JOIN (SELECT `document_type.translation`.document_type_id, `document_type.translation`.name as `document_type.translation.name`, `document_type.translation`.custom_fields as `document_type.translation.customFields`, `document_type.translation`.created_at as `document_type.translation.createdAt`, `document_type.translation`.updated_at as `document_type.translation.updatedAt`, `document_type.translation`.document_type_id as `document_type.translation.documentTypeId`, `document_type.translation`.language_id as `document_type.translation.languageId` FROM `document_type_translation` `document_type.translation` WHERE `document_type.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `document_type.document_type_translation` ON `document_type.document_type_translation`.`document_type_id` = `document_type`.`id` WHERE (`document_type`.`technical_name` = 'invoice');
|