Query Metrics
8
Database Queries
8
Different statements
5.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 |
---|---|---|
1.22 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 0 ;
Parameters:
[] |
1.06 ms (0.00%) |
1 |
INSERT INTO pixel_dates (FunctionName,StartEnde,`Page`,UpdateDatetime) VALUES(?,?,?,?)
Parameters:
[ "remove/products_zulauf" "Start" 0 "2024-09-21 08:45:02" ] |
database_akn_dump_live_ionos connection
Time▼ | Count | Info |
---|---|---|
0.76 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522050900' ;
Parameters:
[] |
0.70 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522033100' ;
Parameters:
[] |
0.45 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522060201' ;
Parameters:
[] |
0.41 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522060203' ;
Parameters:
[] |
0.41 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522033005' ;
Parameters:
[] |
0.35 ms (0.00%) |
1 |
SELECT * FROM storages WHERE stone_number = '522022202' ;
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.