Query Metrics
4
Database Queries
3
Different statements
2.30 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.91 ms (0.00%) |
2 |
INSERT INTO pixel_dates (FunctionName,StartEnde,UpdateDatetime) VALUES(?,?,?)
Parameters:
[ "update/products" "Start" "2024-09-21 08:35:02" ] |
database_akn_dump_live_ionos connection
Time▼ | Count | Info |
---|---|---|
0.25 ms (0.00%) |
1 |
UPDATE storages SET upload_done = ?, upload_failed = ? -- WHERE stone_number = '' WHERE (upload_done IS NULL AND upload_failed IS NULL) OR (upload_done = 4 AND upload_failed IS NULL) ;
Parameters:
[ 1 3 ] |
0.14 ms (0.00%) |
1 |
SELECT * , articles.material_id as material_id , articles.materialgroup_id as materialgroup_id , storages.id as storage_id , storages.stone_number AS product_number -- , CONCAT(storages.material_id, '_', storages.materialgroup_id) AS product_number_parent , CONCAT(storages.material_id, '_', storages.materialgroup_id, '_') AS product_number_parent -- , COALESCE(NULLIF(storages.picture, ''), NULLIF(materials.picture, ''), 'default.jpg') AS picture--select picture , storages.picture AS storages_picture , materials.picture AS materials_picture , storages.advice AS advice , materials.advice AS description_advice , COALESCE(NULLIF(materials.picture, ''), 'default_art.jpg') AS picture_parent -- select picture , key1.key_text AS color_text , key2.key_text AS einheit_2 FROM articles LEFT JOIN materials ON (articles.material_id = materials.material_id AND articles.materialgroup_id = materials.materialgroup_id ) -- LEFT JOIN articlegroups ON (articlegroups.articlegroup_id = articles.article_id) LEFT JOIN articlegroups ON (articles.articlegroup_id = articlegroups.articlegroup_id) LEFT JOIN materialgroups ON (materialgroups.materialgroup_id = articles.materialgroup_id) LEFT JOIN surfaces ON (surfaces.surface_id = articles.surface_id AND surfaces.materialgroup_id = articles.materialgroup_id) INNER JOIN storages ON (articles.article_id = storages.article_id) LEFT JOIN storagefaults ON (storages.fault_id = storagefaults.fault_id) LEFT JOIN materialcolors ON (articles.material_id = materialcolors.mar_id AND articles.materialgroup_id = materialcolors.mgr_id ) LEFT JOIN `keys` key1 ON (materialcolors.color_id = key1.key_number AND key1.key_kind = 88) LEFT JOIN `keys` key2 ON (storages.quantity_unit_2 = key2.key_number AND key2.key_kind = 1) LEFT JOIN artikeldaten ON (artikeldaten.material_group = articles.materialgroup_id AND artikeldaten.material = articles.material_id) WHERE storages.stone_number IS NOT NULL -- AND storages.stone_number = '219102526' -- AND articles.material_id = 'BEHA' -- AND materials.advice !='' AND storages.stone_number !='' AND storages.storage != 'ZULAUF' -- AND storages.upload_done IS NULL AND storages.upload_done = 4 -- OR storages.upload_done = 4 -- AND articles.upload_done IS NULL AND storages.upload_failed IS NULL AND material_name IS NOT NULL -- AND block_advice IS NOT NULL -- AND block_advice != '' ORDER BY storages.upload_done DESC, articles.id ASC LIMIT 5 ;
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.