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

Query Metrics

8 Database Queries
7 Different statements
5.51 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.96 ms
INSERT INTO pixel_dates (FunctionName,StartEnde,`Page`,UpdateDatetime)
                VALUES(?,?,?,?)
Parameters:
[
  "remove/products_zulauf"
  "Start"
  "108"
  "2024-09-21 09:45:48"
]
2 2.23 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 108
        ;
Parameters:
[]
3 0.96 ms
INSERT INTO pixel_dates (FunctionName,StartEnde,`Page`,UpdateDatetime)
                VALUES(?,?,?,?)
Parameters:
[
  "remove/products_zulauf"
  "ENDE"
  "108"
  "2024-09-21 09:45:59"
]

database_akn_dump_live_ionos connection

# Time Info
1 0.23 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522033001'
                ;
Parameters:
[]
2 0.26 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522081202'
                ;
Parameters:
[]
3 0.27 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522090602'
                ;
Parameters:
[]
4 0.31 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522020405'
                ;
Parameters:
[]
5 0.29 ms
SELECT *
                    FROM storages
                    WHERE stone_number = '522060100'
                ;
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.