POST https://dentalkiosk.commerce-crew.com/api/cleverreach/async/1482870_686d815a6d8a01.32556536

Query Metrics

20 Database Queries
16 Different statements
9.21 ms Query time

Grouped Statements

Show all queries

Time Count Info
1.62 ms
(17.55%)
1
DELETE FROM cleverreach_entity WHERE id=?
Parameters:
[
  "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
Parameters:
[]
0.95 ms
(10.28%)
2
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
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
Parameters:
[]
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
Parameters:
[]
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
Parameters:
[]
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
Parameters:
[]
0.47 ms
(5.14%)
1
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
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`
Parameters:
[]
0.43 ms
(4.66%)
1
# 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:
[]
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;
Parameters:
[]
0.40 ms
(4.29%)
1
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
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`
Parameters:
[]
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
Parameters:
[]
0.34 ms
(3.66%)
1
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters:
[
  true
  false
]
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',''))
Parameters:
[]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.