| 1 |
0.46 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
| 2 |
0.47 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.24 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',''));
|
| 4 |
0.46 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
| 5 |
0.52 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;
;
|
| 6 |
0.99 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;
|
| 7 |
0.49 ms |
SELECT `name`, `path`, `author`, `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name`, `path`, `author`, `self_managed`
FROM `app`
WHERE `active` = 1
;
|
| 8 |
0.38 ms |
SELECT item_rounding FROM currency WHERE id = ?
Parameters: [
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
|
| 9 |
0.43 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '1542548_686df1d6041d80.41292096') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '1542548_686df1d6041d80.41292096') LIMIT 1;
|
| 10 |
0.30 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=14823971) LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=14823971) LIMIT 1;
|
| 11 |
0.31 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 12 |
0.28 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 13 |
0.31 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 14 |
0.27 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 15 |
0.32 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1;
|
| 16 |
0.30 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 17 |
0.60 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 18 |
0.32 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 19 |
0.27 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 20 |
0.31 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 21 |
0.24 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 22 |
0.33 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 23 |
0.24 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 24 |
0.24 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1;
|
| 25 |
0.25 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 26 |
0.60 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 27 |
0.29 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 28 |
0.28 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 29 |
0.30 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'authInfo') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'authInfo') LIMIT 1;
|
| 30 |
0.28 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 31 |
0.27 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 32 |
0.27 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 33 |
0.25 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 34 |
0.33 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1;
|
| 35 |
0.24 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
|
| 36 |
0.72 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 37 |
0.39 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 38 |
0.27 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 39 |
0.28 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 40 |
0.30 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 41 |
0.29 ms |
SELECT `cleverreach_data_resources_entity`.`shopware_id` as `cleverreach_data_resources_entity.shopware_id`, `cleverreach_data_resources_entity`.`id` as `cleverreach_data_resources_entity.id`, `cleverreach_data_resources_entity`.`type` as `cleverreach_data_resources_entity.type`, `cleverreach_data_resources_entity`.`index_1` as `cleverreach_data_resources_entity.index_1`, `cleverreach_data_resources_entity`.`index_2` as `cleverreach_data_resources_entity.index_2`, `cleverreach_data_resources_entity`.`index_3` as `cleverreach_data_resources_entity.index_3`, `cleverreach_data_resources_entity`.`index_4` as `cleverreach_data_resources_entity.index_4`, `cleverreach_data_resources_entity`.`data` as `cleverreach_data_resources_entity.data` FROM `cleverreach_data_resources_entity` WHERE (`cleverreach_data_resources_entity`.`id` = ?)
SELECT `cleverreach_data_resources_entity`.`shopware_id` as `cleverreach_data_resources_entity.shopware_id`, `cleverreach_data_resources_entity`.`id` as `cleverreach_data_resources_entity.id`, `cleverreach_data_resources_entity`.`type` as `cleverreach_data_resources_entity.type`, `cleverreach_data_resources_entity`.`index_1` as `cleverreach_data_resources_entity.index_1`, `cleverreach_data_resources_entity`.`index_2` as `cleverreach_data_resources_entity.index_2`, `cleverreach_data_resources_entity`.`index_3` as `cleverreach_data_resources_entity.index_3`, `cleverreach_data_resources_entity`.`index_4` as `cleverreach_data_resources_entity.index_4`, `cleverreach_data_resources_entity`.`data` as `cleverreach_data_resources_entity.data` FROM `cleverreach_data_resources_entity` WHERE (`cleverreach_data_resources_entity`.`id` = '17');
|
| 42 |
0.41 ms |
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id;
|
| 43 |
0.45 ms |
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_data_resources_entity` WHERE `shopware_id` IN (?)
Parameters: [
b"\x01•á™\x14trOº™Â+\x088#Ä"
]
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_data_resources_entity` WHERE `shopware_id` IN (0x0195E1991474724FBA99C22B083823C4);
|
| 44 |
0.22 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 45 |
1.03 ms |
UPDATE `cleverreach_data_resources_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `data` = ? WHERE shopware_id = ?
Parameters: [
"Configuration"
"isOffline"
null
"{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\Configuration\\ConfigEntity","id":"17","name":"isOffline","value":true,"context":""}"
b"\x01•á™\x14trOº™Â+\x088#Ä"
]
UPDATE `cleverreach_data_resources_entity` SET `type` = 'Configuration', `index_1` = 'isOffline', `index_2` = NULL, `data` = '{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\Infrastructure\\\\Configuration\\\\ConfigEntity\",\"id\":\"17\",\"name\":\"isOffline\",\"value\":true,\"context\":\"\"}' WHERE shopware_id = 0x0195E1991474724FBA99C22B083823C4;
|
| 46 |
0.21 ms |
"COMMIT"
|
| 47 |
0.33 ms |
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters: [
true
false
]
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = 1 AND `app`.`self_managed` = 0);
|
| 48 |
0.58 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`
;
|
| 49 |
0.61 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`
;
|
| 50 |
0.38 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1;
|
| 51 |
0.29 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1;
|
| 52 |
0.28 ms |
SELECT `cleverreach_data_resources_entity`.`shopware_id` as `cleverreach_data_resources_entity.shopware_id`, `cleverreach_data_resources_entity`.`id` as `cleverreach_data_resources_entity.id`, `cleverreach_data_resources_entity`.`type` as `cleverreach_data_resources_entity.type`, `cleverreach_data_resources_entity`.`index_1` as `cleverreach_data_resources_entity.index_1`, `cleverreach_data_resources_entity`.`index_2` as `cleverreach_data_resources_entity.index_2`, `cleverreach_data_resources_entity`.`index_3` as `cleverreach_data_resources_entity.index_3`, `cleverreach_data_resources_entity`.`index_4` as `cleverreach_data_resources_entity.index_4`, `cleverreach_data_resources_entity`.`data` as `cleverreach_data_resources_entity.data` FROM `cleverreach_data_resources_entity` WHERE (`cleverreach_data_resources_entity`.`id` = ?)
SELECT `cleverreach_data_resources_entity`.`shopware_id` as `cleverreach_data_resources_entity.shopware_id`, `cleverreach_data_resources_entity`.`id` as `cleverreach_data_resources_entity.id`, `cleverreach_data_resources_entity`.`type` as `cleverreach_data_resources_entity.type`, `cleverreach_data_resources_entity`.`index_1` as `cleverreach_data_resources_entity.index_1`, `cleverreach_data_resources_entity`.`index_2` as `cleverreach_data_resources_entity.index_2`, `cleverreach_data_resources_entity`.`index_3` as `cleverreach_data_resources_entity.index_3`, `cleverreach_data_resources_entity`.`index_4` as `cleverreach_data_resources_entity.index_4`, `cleverreach_data_resources_entity`.`data` as `cleverreach_data_resources_entity.data` FROM `cleverreach_data_resources_entity` WHERE (`cleverreach_data_resources_entity`.`id` = '22');
|
| 53 |
0.41 ms |
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_data_resources_entity` WHERE `shopware_id` IN (?)
Parameters: [
b"\x01•á™\x14zpV¾M›É\x13YÏÚ"
]
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_data_resources_entity` WHERE `shopware_id` IN (0x0195E199147A7056BE4D9BC91359CFDA);
|
| 54 |
0.31 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 55 |
0.82 ms |
UPDATE `cleverreach_data_resources_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `data` = ? WHERE shopware_id = ?
Parameters: [
"Configuration"
"appState"
null
"{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\Configuration\\ConfigEntity","id":"22","name":"appState","value":{"stateCode":"offline","subStateCode":null,"previous":{"stateCode":"dashboard","subStateCode":null,"previous":null}},"context":""}"
b"\x01•á™\x14zpV¾M›É\x13YÏÚ"
]
UPDATE `cleverreach_data_resources_entity` SET `type` = 'Configuration', `index_1` = 'appState', `index_2` = NULL, `data` = '{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\Infrastructure\\\\Configuration\\\\ConfigEntity\",\"id\":\"22\",\"name\":\"appState\",\"value\":{\"stateCode\":\"offline\",\"subStateCode\":null,\"previous\":{\"stateCode\":\"dashboard\",\"subStateCode\":null,\"previous\":null}},\"context\":\"\"}' WHERE shopware_id = 0x0195E199147A7056BE4D9BC91359CFDA;
|
| 56 |
0.23 ms |
"COMMIT"
|
| 57 |
0.36 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 58 |
0.32 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 59 |
0.31 ms |
SELECT `cleverreach_data_resources_entity`.`shopware_id` as `cleverreach_data_resources_entity.shopware_id`, `cleverreach_data_resources_entity`.`id` as `cleverreach_data_resources_entity.id`, `cleverreach_data_resources_entity`.`type` as `cleverreach_data_resources_entity.type`, `cleverreach_data_resources_entity`.`index_1` as `cleverreach_data_resources_entity.index_1`, `cleverreach_data_resources_entity`.`index_2` as `cleverreach_data_resources_entity.index_2`, `cleverreach_data_resources_entity`.`index_3` as `cleverreach_data_resources_entity.index_3`, `cleverreach_data_resources_entity`.`index_4` as `cleverreach_data_resources_entity.index_4`, `cleverreach_data_resources_entity`.`data` as `cleverreach_data_resources_entity.data` FROM `cleverreach_data_resources_entity` WHERE (`cleverreach_data_resources_entity`.`id` = ?)
SELECT `cleverreach_data_resources_entity`.`shopware_id` as `cleverreach_data_resources_entity.shopware_id`, `cleverreach_data_resources_entity`.`id` as `cleverreach_data_resources_entity.id`, `cleverreach_data_resources_entity`.`type` as `cleverreach_data_resources_entity.type`, `cleverreach_data_resources_entity`.`index_1` as `cleverreach_data_resources_entity.index_1`, `cleverreach_data_resources_entity`.`index_2` as `cleverreach_data_resources_entity.index_2`, `cleverreach_data_resources_entity`.`index_3` as `cleverreach_data_resources_entity.index_3`, `cleverreach_data_resources_entity`.`index_4` as `cleverreach_data_resources_entity.index_4`, `cleverreach_data_resources_entity`.`data` as `cleverreach_data_resources_entity.data` FROM `cleverreach_data_resources_entity` WHERE (`cleverreach_data_resources_entity`.`id` = '17');
|
| 60 |
0.47 ms |
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_data_resources_entity` WHERE `shopware_id` IN (?)
Parameters: [
b"\x01•á™\x14trOº™Â+\x088#Ä"
]
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_data_resources_entity` WHERE `shopware_id` IN (0x0195E1991474724FBA99C22B083823C4);
|
| 61 |
0.19 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 62 |
1.00 ms |
UPDATE `cleverreach_data_resources_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `data` = ? WHERE shopware_id = ?
Parameters: [
"Configuration"
"isOffline"
null
"{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\Configuration\\ConfigEntity","id":"17","name":"isOffline","value":true,"context":""}"
b"\x01•á™\x14trOº™Â+\x088#Ä"
]
UPDATE `cleverreach_data_resources_entity` SET `type` = 'Configuration', `index_1` = 'isOffline', `index_2` = NULL, `data` = '{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\Infrastructure\\\\Configuration\\\\ConfigEntity\",\"id\":\"17\",\"name\":\"isOffline\",\"value\":true,\"context\":\"\"}' WHERE shopware_id = 0x0195E1991474724FBA99C22B083823C4;
|
| 63 |
0.22 ms |
"COMMIT"
|
| 64 |
0.34 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1;
|
| 65 |
0.29 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'appState') LIMIT 1;
|
| 66 |
0.28 ms |
SELECT `cleverreach_data_resources_entity`.`shopware_id` as `cleverreach_data_resources_entity.shopware_id`, `cleverreach_data_resources_entity`.`id` as `cleverreach_data_resources_entity.id`, `cleverreach_data_resources_entity`.`type` as `cleverreach_data_resources_entity.type`, `cleverreach_data_resources_entity`.`index_1` as `cleverreach_data_resources_entity.index_1`, `cleverreach_data_resources_entity`.`index_2` as `cleverreach_data_resources_entity.index_2`, `cleverreach_data_resources_entity`.`index_3` as `cleverreach_data_resources_entity.index_3`, `cleverreach_data_resources_entity`.`index_4` as `cleverreach_data_resources_entity.index_4`, `cleverreach_data_resources_entity`.`data` as `cleverreach_data_resources_entity.data` FROM `cleverreach_data_resources_entity` WHERE (`cleverreach_data_resources_entity`.`id` = ?)
SELECT `cleverreach_data_resources_entity`.`shopware_id` as `cleverreach_data_resources_entity.shopware_id`, `cleverreach_data_resources_entity`.`id` as `cleverreach_data_resources_entity.id`, `cleverreach_data_resources_entity`.`type` as `cleverreach_data_resources_entity.type`, `cleverreach_data_resources_entity`.`index_1` as `cleverreach_data_resources_entity.index_1`, `cleverreach_data_resources_entity`.`index_2` as `cleverreach_data_resources_entity.index_2`, `cleverreach_data_resources_entity`.`index_3` as `cleverreach_data_resources_entity.index_3`, `cleverreach_data_resources_entity`.`index_4` as `cleverreach_data_resources_entity.index_4`, `cleverreach_data_resources_entity`.`data` as `cleverreach_data_resources_entity.data` FROM `cleverreach_data_resources_entity` WHERE (`cleverreach_data_resources_entity`.`id` = '22');
|
| 67 |
0.46 ms |
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_data_resources_entity` WHERE `shopware_id` IN (?)
Parameters: [
b"\x01•á™\x14zpV¾M›É\x13YÏÚ"
]
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_data_resources_entity` WHERE `shopware_id` IN (0x0195E199147A7056BE4D9BC91359CFDA);
|
| 68 |
0.20 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 69 |
0.81 ms |
UPDATE `cleverreach_data_resources_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `data` = ? WHERE shopware_id = ?
Parameters: [
"Configuration"
"appState"
null
"{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\Configuration\\ConfigEntity","id":"22","name":"appState","value":{"stateCode":"offline","subStateCode":null,"previous":{"stateCode":"dashboard","subStateCode":null,"previous":null}},"context":""}"
b"\x01•á™\x14zpV¾M›É\x13YÏÚ"
]
UPDATE `cleverreach_data_resources_entity` SET `type` = 'Configuration', `index_1` = 'appState', `index_2` = NULL, `data` = '{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\Infrastructure\\\\Configuration\\\\ConfigEntity\",\"id\":\"22\",\"name\":\"appState\",\"value\":{\"stateCode\":\"offline\",\"subStateCode\":null,\"previous\":{\"stateCode\":\"dashboard\",\"subStateCode\":null,\"previous\":null}},\"context\":\"\"}' WHERE shopware_id = 0x0195E199147A7056BE4D9BC91359CFDA;
|
| 70 |
0.22 ms |
"COMMIT"
|
| 71 |
0.34 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'isOffline') LIMIT 1;
|
| 72 |
0.38 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
|
| 73 |
0.28 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
|
| 74 |
0.27 ms |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
|
| 75 |
1.73 ms |
DELETE FROM cleverreach_entity WHERE id=?
Parameters: [
"15812175"
]
DELETE FROM cleverreach_entity WHERE id='15812175';
|