POST https://dentalkiosk.commerce-crew.com/api/cleverreach/async/1531370_686de05eb297d4.70408563

Query Metrics

39 Database Queries
27 Different statements
23.16 ms Query time

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
2 0.39 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.62 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
5 0.43 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.93 ms
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
7 0.36 ms
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
8 0.40 ms
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
9 0.46 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '1531370_686de05eb297d4.70408563') LIMIT 1
Parameters:
[]
10 0.32 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=15808603) LIMIT 1
Parameters:
[]
11 0.35 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
Parameters:
[]
12 0.30 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
Parameters:
[]
13 0.37 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
Parameters:
[]
14 0.32 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
Parameters:
[]
15 0.29 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
Parameters:
[]
16 0.31 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
Parameters:
[]
17 0.65 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
Parameters:
[]
18 0.30 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
Parameters:
[]
19 0.26 ms
SELECT p.* FROM cleverreach_data_resources_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
Parameters:
[]
20 0.34 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=15808603 AND p.index_1 = 'queued' AND p.index_7 IS NULL) LIMIT 1
Parameters:
[]
21 0.37 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:
[
  "15808603"
]
22 0.40 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.02 ms
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (?)
Parameters:
[
  b"\x01—í4cYp”¸†ÖéVJ:$"
]
24 0.22 ms
"START TRANSACTION"
Parameters:
[]
25 2.47 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
  "1752031322"
  "00000000000"
  "01752031326"
  "00000000100"
  "5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487"
  "{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\TaskExecution\\QueueItem","id":"15808603","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-09T03:22:02+00:00","startTime":"2025-07-09T03:22:06+00:00","finishTime":null,"failTime":null,"earliestStartTime":null,"queueTime":"2025-07-09T03:22:02+00:00","lastUpdateTime":"2025-07-09T03:22:06+00:00","priority":100,"equalityHash":"5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487"}"
  b"\x01—í4cYp”¸†ÖéVJ:$"
]
26 1.44 ms
"COMMIT"
Parameters:
[]
27 0.34 ms
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters:
[
  true
  false
]
28 0.48 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.32 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.40 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Schedule') AND (p.index_1 <= '1752031326' 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=15808603 AND p.index_1 = 'in_progress' AND p.index_6 = '00000000000' AND p.index_7 = '01752031326') LIMIT 1
Parameters:
[]
32 0.34 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:
[
  15808603
]
33 0.83 ms
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (?)
Parameters:
[
  b"\x01—í4cYp”¸†ÖéVJ:$"
]
34 0.20 ms
"START TRANSACTION"
Parameters:
[]
35 2.30 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
  "1752031322"
  "00000000000"
  "01752031326"
  "00000000100"
  "5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487"
  "{"class_name":"Crsw\\CleverReachOfficial\\Core\\Infrastructure\\TaskExecution\\QueueItem","id":15808603,"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-09T03:22:02+00:00","startTime":"2025-07-09T03:22:06+00:00","finishTime":null,"failTime":null,"earliestStartTime":null,"queueTime":"2025-07-09T03:22:02+00:00","lastUpdateTime":"2025-07-09T03:22:06+00:00","priority":100,"equalityHash":"5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487"}"
  b"\x01—í4cYp”¸†ÖéVJ:$"
]
36 1.19 ms
"COMMIT"
Parameters:
[]
37 0.34 ms
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=15808603) LIMIT 1
Parameters:
[]
38 1.13 ms
DELETE FROM cleverreach_entity WHERE id=?
Parameters:
[
  15808603
]
39 1.05 ms
DELETE FROM cleverreach_entity WHERE id=?
Parameters:
[
  "15808607"
]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.