POST https://dentalkiosk.commerce-crew.com/api/cleverreach/async/1531483_686df13c8649e7.55836938

Query Metrics

39 Database Queries
27 Different statements
24.71 ms Query time

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
2 0.46 ms
# dbal-plugin-loader
        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`;
Parameters:
[]
3 0.22 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',''))
Parameters:
[]
4 0.63 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
5 0.41 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;
Parameters:
[]
6 0.73 ms
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
7 0.30 ms
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
8 0.50 ms
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
9 0.42 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '1531483_686df13c8649e7.55836938') LIMIT 1
Parameters:
[]
10 0.29 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=15812051) LIMIT 1
Parameters:
[]
11 0.32 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
Parameters:
[]
12 0.28 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
Parameters:
[]
13 0.26 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
Parameters:
[]
14 0.28 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
Parameters:
[]
15 0.25 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
Parameters:
[]
16 0.24 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
Parameters:
[]
17 0.45 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
Parameters:
[]
18 0.33 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
Parameters:
[]
19 0.28 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
Parameters:
[]
20 0.37 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=15812051 AND p.index_1 = 'queued' AND p.index_7 IS NULL) LIMIT 1
Parameters:
[]
21 0.40 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` = ?)
Parameters:
[
  "15812051"
]
22 0.48 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
Parameters:
[]
23 1.04 ms
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (?)
Parameters:
[
  b"\x01—ívEPq{¼\x7F³üöIí‚"
]
24 0.18 ms
"START TRANSACTION"
Parameters:
[]
25 2.54 ms
UPDATE `cleverreach_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `index_3` = ?, `index_4` = ?, `index_5` = ?, `index_6` = ?, `index_7` = ?, `index_8` = ?, `index_9` = ?, `data` = ? WHERE shopware_id = ?
Parameters:
[
  "QueueItem"
  "in_progress"
  "ScheduleCheckTask"
  "Schedule"
  null
  "1752035640"
  "00000000000"
  "01752035644"
  "00000000100"
  "5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487"
  "{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\TaskExecution\\QueueItem","id":"15812051","status":"in_progress","context":"","serializedTask":"{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\BusinessLogic\\\\Scheduler\\\\ScheduleCheckTask\"}","queueName":"Schedule","lastExecutionProgressBasePoints":0,"progressBasePoints":0,"retries":0,"failureDescription":"","createTime":"2025-07-09T04:34:00+00:00","startTime":"2025-07-09T04:34:04+00:00","finishTime":null,"failTime":null,"earliestStartTime":null,"queueTime":"2025-07-09T04:34:00+00:00","lastUpdateTime":"2025-07-09T04:34:04+00:00","priority":100,"equalityHash":"5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487"}"
  b"\x01—ívEPq{¼\x7F³üöIí‚"
]
26 1.91 ms
"COMMIT"
Parameters:
[]
27 0.36 ms
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters:
[
  true
  false
]
28 0.50 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`
Parameters:
[]
29 0.38 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`
Parameters:
[]
30 0.34 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Schedule') AND (p.index_1 <= '1752035644' AND p.index_5 = '1') ORDER BY p.index_1 ASC LIMIT 1000
Parameters:
[]
31 0.30 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=15812051 AND p.index_1 = 'in_progress' AND p.index_6 = '00000000000' AND p.index_7 = '01752035644') LIMIT 1
Parameters:
[]
32 0.32 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` = ?)
Parameters:
[
  15812051
]
33 1.28 ms
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (?)
Parameters:
[
  b"\x01—ívEPq{¼\x7F³üöIí‚"
]
34 0.15 ms
"START TRANSACTION"
Parameters:
[]
35 3.61 ms
UPDATE `cleverreach_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `index_3` = ?, `index_4` = ?, `index_5` = ?, `index_6` = ?, `index_7` = ?, `index_8` = ?, `index_9` = ?, `data` = ? WHERE shopware_id = ?
Parameters:
[
  "QueueItem"
  "in_progress"
  "ScheduleCheckTask"
  "Schedule"
  null
  "1752035640"
  "00000000000"
  "01752035644"
  "00000000100"
  "5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487"
  "{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\TaskExecution\\QueueItem","id":15812051,"status":"in_progress","context":"","serializedTask":"{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\BusinessLogic\\\\Scheduler\\\\ScheduleCheckTask\"}","queueName":"Schedule","lastExecutionProgressBasePoints":0,"progressBasePoints":10000,"retries":0,"failureDescription":"","createTime":"2025-07-09T04:34:00+00:00","startTime":"2025-07-09T04:34:04+00:00","finishTime":null,"failTime":null,"earliestStartTime":null,"queueTime":"2025-07-09T04:34:00+00:00","lastUpdateTime":"2025-07-09T04:34:04+00:00","priority":100,"equalityHash":"5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487"}"
  b"\x01—ívEPq{¼\x7F³üöIí‚"
]
36 1.15 ms
"COMMIT"
Parameters:
[]
37 0.31 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=15812051) LIMIT 1
Parameters:
[]
38 1.04 ms
DELETE FROM cleverreach_entity WHERE id=?
Parameters:
[
  15812051
]
39 0.98 ms
DELETE FROM cleverreach_entity WHERE id=?
Parameters:
[
  "15812055"
]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.