https://swconnect.akn.pixelproductions.de/remove/products_zulauf/96

Query Metrics

8 Database Queries
8 Different statements
5.21 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

No database queries were performed.

database_akn_dump connection

No database queries were performed.

database_akn connection

No database queries were performed.

database_akn_old connection

No database queries were performed.

database_akn_live connection

No database queries were performed.

database_akn_dump_live connection

No database queries were performed.

database_akn_live_ionos connection

# Time Info
1 0.94 ms
INSERT INTO pixel_dates (FunctionName,StartEnde,`Page`,UpdateDatetime)
                VALUES(?,?,?,?)
Parameters:
[
  "remove/products_zulauf"
  "Start"
  "96"
  "2024-09-21 08:45:42"
]
2 2.17 ms
SELECT LOWER(HEX(product_category.product_id)) AS product_id,
            product_number AS product_number,
            JSON_EXTRACT(product_translation.custom_fields,'$.custom_article_material_id') AS custom_article_material_id,
            JSON_EXTRACT(product_translation.custom_fields,'$.custom_article_materialgroup_id') AS custom_article_materialgroup_id
            FROM product_category
            INNER JOIN product ON (product_category.product_id = product.id)
            INNER JOIN product_translation ON (product.id = product_translation.product_id)
            WHERE LOWER(HEX(product_category.category_id)) = '69eb42414c5c44bfa4d6ef6c29954873'
            AND parent_id IS NOT NULL
            LIMIT 6
            OFFSET 96
        ;
Parameters:
[]

database_akn_dump_live_ionos connection

# Time Info
1 0.57 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522033000'
                ;
Parameters:
[]
2 0.28 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522022208'
                ;
Parameters:
[]
3 0.34 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522042700'
                ;
Parameters:
[]
4 0.25 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522050905'
                ;
Parameters:
[]
5 0.33 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522092204'
                ;
Parameters:
[]
6 0.32 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522020401'
                ;
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
database_akn_dump doctrine.dbal.database_akn_dump_connection
database_akn doctrine.dbal.database_akn_connection
database_akn_old doctrine.dbal.database_akn_old_connection
database_akn_live doctrine.dbal.database_akn_live_connection
database_akn_dump_live doctrine.dbal.database_akn_dump_live_connection
database_akn_live_ionos doctrine.dbal.database_akn_live_ionos_connection
database_akn_dump_live_ionos doctrine.dbal.database_akn_dump_live_ionos_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.