Query Metrics
8
Database Queries
8
Different statements
3.64 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 |
---|---|---|
1.01 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 24 ;
Parameters:
[] |
0.91 ms (0.00%) |
1 |
INSERT INTO pixel_dates (FunctionName,StartEnde,`Page`,UpdateDatetime) VALUES(?,?,?,?)
Parameters:
[ "remove/products_zulauf" "Start" "24" "2024-09-21 09:45:13" ] |
database_akn_dump_live_ionos connection
Time▼ | Count | Info |
---|---|---|
0.40 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522092205' ;
Parameters:
[] |
0.31 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522083002' ;
Parameters:
[] |
0.31 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522051605' ;
Parameters:
[] |
0.27 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522092206' ;
Parameters:
[] |
0.25 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522092000' ;
Parameters:
[] |
0.18 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522041100' ;
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.