Query Metrics
3
Database Queries
2
Different statements
3.51 ms
Query time
0
Invalid entities
Queries
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 | 1.02 ms |
INSERT INTO pixel_dates (FunctionName,StartEnde,UpdateDatetime) VALUES(?,?,?)
Parameters:
[ "import/products_zulauf" "Start" "2024-09-21 08:30:02" ] |
| 2 | 1.05 ms |
INSERT INTO pixel_dates (FunctionName,StartEnde,UpdateDatetime) VALUES(?,?,?)
Parameters:
[ "import/products_zulauf" "ENDE" "2024-09-21 08:30:11" ] |
database_akn_dump_live_ionos connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.44 ms |
SELECT * , articles.material_id as material_id , articles.materialgroup_id as materialgroup_id , storages.id as storage_id -- , CONCAT(storages.article_id, '_' ,storages.id) AS product_number -- , CONCAT('zulauf', '_', storages.material_id, '_', storages.materialgroup_id, '_', storages.id) AS product_number , storages.stone_number AS product_number , CONCAT('Zulauf_', 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 , COALESCE(NULLIF(materials.picture, ''), 'default.jpg') AS picture_parent -- select picture 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) WHERE storages.stone_number IS NOT NULL AND storages.storage = 'ZULAUF' AND storages.upload_done IS NULL AND material_name IS NOT NULL -- AND articles.material_id = 'BCCD' ORDER BY articles.id ASC LIMIT 10 ;
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.