POST https://abb-dev.tech/api/search/customer

Query Metrics

12 Database Queries
11 Different statements
5.34 ms Query time

Grouped Statements

Show all queries

Time Count Info
0.99 ms
(18.61%)
2
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
0.60 ms
(11.24%)
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.56 ms
(10.53%)
1
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
0.56 ms
(10.44%)
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.52 ms
(9.80%)
1
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
0.52 ms
(9.76%)
1
SELECT `customer`.`id`, `customer`.`auto_increment`, `customer`.`customer_number` FROM `customer` LIMIT 250 OFFSET 250
Parameters:
[]
0.51 ms
(9.54%)
1
SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = ?
Parameters:
[
  b"\x01’â ´¦w=¨¬àÀJ{‹y"
]
0.39 ms
(7.38%)
1
SELECT id FROM integration WHERE access_key = ?
Parameters:
[
  "SWIAZ2K0WEFZOUHNMNRZSTU4QQ"
]
0.31 ms
(5.81%)
1
SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = ?
Parameters:
[
  b"\x01’â ´¦w=¨¬àÀJ{‹y"
]
0.20 ms
(3.73%)
1
SELECT admin FROM `integration` WHERE id = ?
Parameters:
[
  b"\x01’â ´¦w=¨¬àÀJ{‹y"
]
0.17 ms
(3.17%)
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.