POST https://sw65.test.firebearstudio.com/api/search/language?q=%2Fapi%2Fsearch%2Flanguage

Query Metrics

11 Database Queries
11 Different statements
31.31 ms Query time

Queries

Group similar statements

# Time Info
1 2.15 ms
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = ?
Parameters:
[
  "cache-id"
]
2 1.33 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 1.93 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
Parameters:
[]
4 3.79 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:
[]
5 2.14 ms
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
6 4.25 ms
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters:
[
  b"£–Óã‘ØF_«¥ˆêbî†r"
]
7 5.45 ms
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
8 1.48 ms
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = ?
Parameters:
[
  b"£–Óã‘ØF_«¥ˆêbî†r"
]
9 1.54 ms
SELECT admin FROM `user` WHERE id = ?
Parameters:
[
  b"£–Óã‘ØF_«¥ˆêbî†r"
]
10 2.03 ms
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) ORDER BY `language`.`name` ASC
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
11 5.21 ms
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt` FROM `language` WHERE `language`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.