1.62 ms (17.55%)
|
1 |
DELETE FROM cleverreach_entity WHERE id=?
Parameters: [
"15789346"
]
DELETE FROM cleverreach_entity WHERE id='15789346';
|
0.95 ms (10.29%)
|
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.95 ms (10.28%)
|
2 |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
0.60 ms (6.49%)
|
1 |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '1482870_686d815a6d8a01.32556536') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '1482870_686d815a6d8a01.32556536') LIMIT 1;
|
0.57 ms (6.24%)
|
2 |
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;
|
0.57 ms (6.18%)
|
2 |
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;
|
0.50 ms (5.41%)
|
2 |
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;
|
0.47 ms (5.14%)
|
1 |
SELECT item_rounding FROM currency WHERE id = ?
Parameters: [
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
|
0.46 ms (5.03%)
|
1 |
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.43 ms (4.66%)
|
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.43 ms (4.64%)
|
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.40 ms (4.29%)
|
1 |
SELECT `name`, `path`, `author`, `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name`, `path`, `author`, `self_managed`
FROM `app`
WHERE `active` = 1
;
|
0.36 ms (3.93%)
|
1 |
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.34 ms (3.67%)
|
1 |
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'taskRunnerStatus') LIMIT 1
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'taskRunnerStatus') LIMIT 1;
|
0.34 ms (3.66%)
|
1 |
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);
|
0.23 ms (2.54%)
|
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',''));
|