https://apinutriciona.dkreativo.es/api/projects/production-recipes/58

Query Metrics

1 Database Queries
1 Different statements
0.61 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.