Query Metrics
1
Database Queries
1
Different statements
0.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.61 ms |
SELECT rtrm.id, rtrm.recipe_test_id, r.code as recipe_code, r.type AS recipe_type, rtrm.raw_material_id, rm.name raw_material_name, rtrm.phase_id, rtp.code phase_code, quantity, rtrm.observations from recipe_test_raw_material rtrm LEFT JOIN recipe_test_phase rtp ON rtrm.phase_id=rtp.id LEFT JOIN recipe_test rt ON rt.id=rtrm.recipe_test_id LEFT JOIN raw_material rm ON rtrm.raw_material_id=rm.id LEFT JOIN recipe r ON r.id=rt.recipe_id LEFT JOIN project p ON p.id=r.project_id WHERE p.id=:project_id AND rt.final_test = TRUE ORDER BY rt.recipe_id, rtrm.raw_material_id
Parameters:
[ ":project_id" => 58 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Project | No errors. |