Query Metrics

19 Database Queries
18 Different statements
7.56 ms Query time

Queries

Group similar statements

# Time Info
1 0.63 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
2 0.56 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.20 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.35 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
5 0.42 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.55 ms
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
7 0.38 ms
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
8 0.34 ms
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
9 0.24 ms
SELECT id FROM integration WHERE access_key = ?
Parameters:
[
  "SWIAWKZ5EUZSAZDDBG5ZT1JJYW"
]
10 0.23 ms
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•|\x7FUÈpÓ½…rð\x03\x07Tk"
]
11 0.20 ms
SELECT admin FROM `integration` WHERE id = ?
Parameters:
[
  b"\x01•|\x7FUÈpÓ½…rð\x03\x07Tk"
]
12 0.21 ms
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•|\x7FUÈpÓ½…rð\x03\x07Tk"
]
13 0.34 ms
SELECT `state_machine`.`id` FROM `state_machine` LIMIT 50
Parameters:
[]
14 0.21 ms
SELECT COUNT(*) FROM (SELECT `state_machine`.`id` FROM `state_machine`) total
Parameters:
[]
15 0.55 ms
SELECT `state_machine`.`id` as `state_machine.id`, `state_machine`.`technical_name` as `state_machine.technicalName`, `state_machine`.`initial_state_id` as `state_machine.initialStateId`, `state_machine`.`created_at` as `state_machine.createdAt`, `state_machine`.`updated_at` as `state_machine.updatedAt`, `state_machine.translation.name`, `state_machine.translation.name` as `state_machine.name`, `state_machine.translation.customFields`, `state_machine.translation.customFields` as `state_machine.customFields` FROM `state_machine` LEFT JOIN (SELECT `state_machine.translation`.`state_machine_id`, `state_machine.translation`.`name` as `state_machine.translation.name`, `state_machine.translation`.`custom_fields` as `state_machine.translation.customFields` FROM `state_machine_translation` `state_machine.translation` WHERE `state_machine.translation`.`language_id` = ?) `state_machine.state_machine_translation` ON `state_machine.state_machine_translation`.`state_machine_id` = `state_machine`.`id` WHERE `state_machine`.`id` IN (?, ?, ?, ?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01•|`9är`¶Ë'o.Ò˜w"
  b"\x01ò|`C\x1ApKüU÷3§FÛ&"
  b"\x01ò|`L▒sÑì\x18ÓGÊ7ø┬"
  b"\x01•|jâmr\x19‚òK²ÒãÑå"
  b"""
    \x01•|jè\n
    qQ¬‹»Xµ\x01
    """
]
16 0.46 ms
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`state_machine_id` IN (?, ?, ?, ?, ?))
Parameters:
[
  b"\x01•|`9är`¶Ë'o.Ò˜w"
  b"\x01ò|`C\x1ApKüU÷3§FÛ&"
  b"\x01ò|`L▒sÑì\x18ÓGÊ7ø┬"
  b"\x01•|jâmr\x19‚òK²ÒãÑå"
  b"""
    \x01•|jè\n
    qQ¬‹»Xµ\x01
    """
]
17 0.57 ms
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = ?) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` WHERE (`state_machine_state`.`state_machine_id` IN (?, ?, ?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01•|`9är`¶Ë'o.Ò˜w"
  b"\x01ò|`C\x1ApKüU÷3§FÛ&"
  b"\x01ò|`L▒sÑì\x18ÓGÊ7ø┬"
  b"\x01•|jâmr\x19‚òK²ÒãÑå"
  b"""
    \x01•|jè\n
    qQ¬‹»Xµ\x01
    """
]
18 0.56 ms
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`from_state_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[
  b"\x01•|`9är`¶Ë'o/~³Û"
  b"\x01•|`9är`¶Ë'o0=\x1Da"
  b"\x01•|`9är`¶Ë'o0§JÇ"
  b"\x01•|`9är`¶Ë'o0ðµC"
  b"\x01ò|`C\x1ApKüU÷3§¹Ñé"
  b"\x01ò|`C\x1ApKüU÷3÷"®ÿ"
  b"\x01ò|`C\x1ApKüU÷3÷yÞò"
  b"\x01ò|`C\x1ApKüU÷3¸9s%"
  b"\x01ò|`C\x1ApKüU÷3¸Ô|,"
  b"\x01ò|`C\x1ApKüU÷3° Ê="
  b"\x01ò|`L▒sÑì\x18ÓGË":┐"
  b"\x01ò|`L▒sÑì\x18ÓGËc\x07\r"
  b"\x01ò|`L▒sÑì\x18ÓGËı$Þ"
  b"\x01ò|`L▒sÑì\x18ÓGÈëÖm"
  b"\x01ò|`L▒sÑì\x18ÓGÈ­ö╩"
  b"\x01ò|`L▒sÑì\x18ÓGıîL╦"
  b"\x01ò|`L▒sÑì\x18ÓGı§\x16Ê"
  b"\x01•|c¶´r¯»>Öµg&M²"
  b"\x01•|c¶´r¯»>ÖµgžiÏ"
  b"\x01•|ew\x0Fp\x03¤×Άk]€‘"
  b"\x01•|eyÚs²•\x04à\t¶_­þ"
  b"\x01•|j\x1E2qØ—ÁÐ7M\e‚F"
  b"\x01•|jã@s\x0F¬AµÐRÌš’"
  b"\x01ò|jõÉsÄ¡.▒(╠\x00ü\x15"
  b"\x01•|jåGs\x12¬UŸUÂcÿÅ"
  b"\x01•|jé£q&…7Ƕ\x19ž”„"
  b"\x01ò|jÙ&s▀íÉ¡\x16ıuêb"
  b"\x01•|jìºrP„½õý\eÊM\x13"
  b"\x01•|jîFq³”\x1F¨æÉ\eÕÉ"
  b"\x01•|jïls\x07„·å4\x7F\x00‘W"
]
19 0.56 ms
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`to_state_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[
  b"\x01•|`9är`¶Ë'o/~³Û"
  b"\x01•|`9är`¶Ë'o0=\x1Da"
  b"\x01•|`9är`¶Ë'o0§JÇ"
  b"\x01•|`9är`¶Ë'o0ðµC"
  b"\x01ò|`C\x1ApKüU÷3§¹Ñé"
  b"\x01ò|`C\x1ApKüU÷3÷"®ÿ"
  b"\x01ò|`C\x1ApKüU÷3÷yÞò"
  b"\x01ò|`C\x1ApKüU÷3¸9s%"
  b"\x01ò|`C\x1ApKüU÷3¸Ô|,"
  b"\x01ò|`C\x1ApKüU÷3° Ê="
  b"\x01ò|`L▒sÑì\x18ÓGË":┐"
  b"\x01ò|`L▒sÑì\x18ÓGËc\x07\r"
  b"\x01ò|`L▒sÑì\x18ÓGËı$Þ"
  b"\x01ò|`L▒sÑì\x18ÓGÈëÖm"
  b"\x01ò|`L▒sÑì\x18ÓGÈ­ö╩"
  b"\x01ò|`L▒sÑì\x18ÓGıîL╦"
  b"\x01ò|`L▒sÑì\x18ÓGı§\x16Ê"
  b"\x01•|c¶´r¯»>Öµg&M²"
  b"\x01•|c¶´r¯»>ÖµgžiÏ"
  b"\x01•|ew\x0Fp\x03¤×Άk]€‘"
  b"\x01•|eyÚs²•\x04à\t¶_­þ"
  b"\x01•|j\x1E2qØ—ÁÐ7M\e‚F"
  b"\x01•|jã@s\x0F¬AµÐRÌš’"
  b"\x01ò|jõÉsÄ¡.▒(╠\x00ü\x15"
  b"\x01•|jåGs\x12¬UŸUÂcÿÅ"
  b"\x01•|jé£q&…7Ƕ\x19ž”„"
  b"\x01ò|jÙ&s▀íÉ¡\x16ıuêb"
  b"\x01•|jìºrP„½õý\eÊM\x13"
  b"\x01•|jîFq³”\x1F¨æÉ\eÕÉ"
  b"\x01•|jïls\x07„·å4\x7F\x00‘W"
]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.