https://curchod.zwei.gmbh/api/oauth/token

Method
POST
HTTP Status
200
IP
78.46.7.75
Profiled on
Token
1d02ae

Query Metrics

11 Database Queries
Different statements
16.87 ms Query time
Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.29 ms 
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = :key
View formatted query    View runnable query    View query stack
2 0.15 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`;
View formatted query    View runnable query    View query stack
3 0.53 ms 
SELECT custom_entity.name, custom_entity.fields 
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
View formatted query    View runnable query    View query stack
4 0.27 ms 
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
View formatted query    View runnable query    View query stack
5 0.28 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',''));SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1582718994_IS_ACTIVE = TRUE;SET @MIGRATION_1586345021_IS_ACTIVE = TRUE;SET @MIGRATION_1586345049_IS_ACTIVE = TRUE;SET @MIGRATION_1586345063_IS_ACTIVE = TRUE;SET @MIGRATION_1587126585_IS_ACTIVE = TRUE;SET @MIGRATION_1625566312_IS_ACTIVE = TRUE
View formatted query    View runnable query    View query stack
6 0.25 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
View formatted query    View runnable query    View query stack
7 0.34 ms 
SELECT item_rounding FROM currency WHERE id = :id
View formatted query    View runnable query    View query stack
8 11.83 ms 
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = :accessKey
View formatted query    View runnable query    View query stack
9 2.11 ms 
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = :accessKey
View formatted query    View runnable query    View query stack
10 0.44 ms 
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = :accessKey
View formatted query    View runnable query    View query stack
11 0.39 ms 
SELECT admin FROM user WHERE id = UNHEX(:accessKey) LIMIT 1
View formatted query    View runnable query    View query stack

Database Connections

There are no configured database connections.

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping