PATCH https://dev.webshop.fior-gentz.de/api/customer-group/5c15435ef76e4987882c8661a21e2559

Query Metrics

20 Database Queries
15 Different statements
3.79 ms Query time

Queries

Group similar statements

# Time Info
1 0.37 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:
[]
2 0.14 ms
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
3 0.21 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:
[]
4 0.17 ms
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
5 0.17 ms
SELECT id FROM integration WHERE access_key = ?
Parameters:
[
  "SWIAM1RVM2FCNHU5S3CXZVDIZG"
]
6 0.20 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"""
    ñº,ÀcBA½\n
    \x1AQ„¼TQ
    """
]
7 0.13 ms
SELECT admin FROM `integration` WHERE id = ?
Parameters:
[
  b"""
    ñº,ÀcBA½\n
    \x1AQ„¼TQ
    """
]
8 0.22 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"""
    ñº,ÀcBA½\n
    \x1AQ„¼TQ
    """
]
9 0.17 ms
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
10 0.13 ms
SELECT id FROM integration WHERE access_key = ?
Parameters:
[
  "SWIAM1RVM2FCNHU5S3CXZVDIZG"
]
11 0.15 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"""
    ñº,ÀcBA½\n
    \x1AQ„¼TQ
    """
]
12 0.10 ms
SELECT admin FROM `integration` WHERE id = ?
Parameters:
[
  b"""
    ñº,ÀcBA½\n
    \x1AQ„¼TQ
    """
]
13 0.14 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"""
    ñº,ÀcBA½\n
    \x1AQ„¼TQ
    """
]
14 0.15 ms
SELECT 1 as `exists`, `customer_group_id`, `language_id` FROM `customer_group_translation` WHERE (`customer_group_id`,`language_id`) IN ((?,?))
Parameters:
[
  b"\\x15C^÷nI‡ˆ,†a¢\x1E%Y"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
15 0.11 ms
SELECT 1 as `exists`, `id` FROM `customer_group` WHERE `id` IN (?)
Parameters:
[
  b"\\x15C^÷nI‡ˆ,†a¢\x1E%Y"
]
16 0.13 ms
SELECT 1 as `exists` FROM `customer_group_translation` WHERE (`customer_group_id` = ?) AND (`language_id` = ?)
Parameters:
[
  b"\\x15C^÷nI‡ˆ,†a¢\x1E%Y"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
17 0.06 ms
"START TRANSACTION"
Parameters:
[]
18 0.75 ms
UPDATE `customer_group` SET `updated_at` = ? WHERE id = ?
Parameters:
[
  "2026-06-19 16:00:37.761"
  b"\\x15C^÷nI‡ˆ,†a¢\x1E%Y"
]
19 0.16 ms
UPDATE `customer_group_translation` SET `customer_group_id` = ?, `language_id` = ?, `name` = ?, `updated_at` = ? WHERE customer_group_id = ? AND language_id = ?
Parameters:
[
  b"\\x15C^÷nI‡ˆ,†a¢\x1E%Y"
  b"/»_ââšMpªXTÎ|ãâ\v"
  "96-AE-31 (AE, Orthopädie-Schuhtechnik Großhandel)"
  "2026-06-19 16:00:37.762"
  b"\\x15C^÷nI‡ˆ,†a¢\x1E%Y"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
20 0.12 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.