Query Metrics
8
Database Queries
8
Different statements
3.36 ms
Query time
0
Invalid entities
Grouped 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▼ | Count | Info |
---|---|---|
0.90 ms (0.00%) |
1 |
INSERT INTO pixel_dates (FunctionName,StartEnde,`Page`,UpdateDatetime) VALUES(?,?,?,?)
Parameters:
[ "remove/products_zulauf" "Start" "12" "2024-09-21 09:45:08" ] |
0.79 ms (0.00%) |
1 |
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 12 ;
Parameters:
[] |
database_akn_dump_live_ionos connection
Time▼ | Count | Info |
---|---|---|
0.34 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522041101' ;
Parameters:
[] |
0.29 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522033004' ;
Parameters:
[] |
0.29 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522060103' ;
Parameters:
[] |
0.27 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522092201' ;
Parameters:
[] |
0.24 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522042900' ;
Parameters:
[] |
0.23 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522020406' ;
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.