https://apinutriciona.dkreativo.es/api/recipe_test_phases?recipeTest=53

Method
GET
HTTP Status
200
IP
74.7.227.125
Profiled on
Token
60ffd3

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 0.98 ms 
SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.time AS time_2, r0_.velocity AS velocity_3, r0_.observations AS observations_4, r1_.id AS id_5, r1_.code AS code_6, r1_.state AS state_7, r1_.test_date AS test_date_8, r1_.mold AS mold_9, r1_.packaging AS packaging_10, r1_.type AS type_11, r1_.line AS line_12, r1_.observations AS observations_13, r1_.nutriscore AS nutriscore_14, r1_.cost AS cost_15, r1_.final_test AS final_test_16, r1_.oven AS oven_17, r1_.nutritional_info AS nutritional_info_18, r1_.moisture_baked_product_target AS moisture_baked_product_target_19, r1_.moisture_baked_product_register AS moisture_baked_product_register_20, r1_.raw_dimensions_diameter_objective AS raw_dimensions_diameter_objective_21, r1_.raw_dimensions_diameter_result AS raw_dimensions_diameter_result_22, r1_.raw_dimensions_long_objective AS raw_dimensions_long_objective_23, r1_.raw_dimensions_long_result AS raw_dimensions_long_result_24, r1_.raw_dimensions_width_objective AS raw_dimensions_width_objective_25, r1_.raw_dimensions_width_result AS raw_dimensions_width_result_26, r1_.raw_dimensions_height_objective AS raw_dimensions_height_objective_27, r1_.raw_dimensions_height_result AS raw_dimensions_height_result_28, r1_.baked_dimensions_diameter_objective AS baked_dimensions_diameter_objective_29, r1_.baked_dimensions_diameter_result AS baked_dimensions_diameter_result_30, r1_.baked_dimensions_long_objective AS baked_dimensions_long_objective_31, r1_.baked_dimensions_long_result AS baked_dimensions_long_result_32, r1_.baked_dimensions_width_objective AS baked_dimensions_width_objective_33, r1_.baked_dimensions_width_result AS baked_dimensions_width_result_34, r1_.baked_dimensions_height_objective AS baked_dimensions_height_objective_35, r1_.baked_dimensions_height_result AS baked_dimensions_height_result_36, r1_.galletas_plaston_superficie_objectivo AS galletas_plaston_superficie_objectivo_37, r1_.galletas_plaston_superficie_registrada AS galletas_plaston_superficie_registrada_38, r1_.galletas_plaston_perdida_objectivo AS galletas_plaston_perdida_objectivo_39, r1_.galletas_plaston_perdida_registrada AS galletas_plaston_perdida_registrada_40, r1_.peso_oblea_unidades AS peso_oblea_unidades_41, r1_.peso_oblea_objetivo AS peso_oblea_objetivo_42, r1_.peso_oblea_registrado AS peso_oblea_registrado_43, r1_.peso_plaston_unidades AS peso_plaston_unidades_44, r1_.peso_plaston_objetivo AS peso_plaston_objetivo_45, r1_.peso_plaston_registrado AS peso_plaston_registrado_46, r1_.obleas_por_plaston AS obleas_por_plaston_47, r1_.capas_relleno_plaston AS capas_relleno_plaston_48, r1_.peso_galleta_barquillo_unidad AS peso_galleta_barquillo_unidad_49, r1_.peso_galleta_barquillo_objetivo AS peso_galleta_barquillo_objetivo_50, r1_.peso_galleta_barquillo_registrado AS peso_galleta_barquillo_registrado_51, r1_.dev_dimensions_diameter_objective AS dev_dimensions_diameter_objective_52, r1_.dev_dimensions_diameter_result AS dev_dimensions_diameter_result_53, r1_.dev_dimensions_long_objective AS dev_dimensions_long_objective_54, r1_.dev_dimensions_long_result AS dev_dimensions_long_result_55, r1_.dev_dimensions_width_objective AS dev_dimensions_width_objective_56, r1_.dev_dimensions_width_result AS dev_dimensions_width_result_57, r1_.dev_dimensions_height_objective AS dev_dimensions_height_objective_58, r1_.dev_dimensions_height_result AS dev_dimensions_height_result_59, r1_.weight_before_baked_number AS weight_before_baked_number_60, r1_.weight_before_baked_weight_objective AS weight_before_baked_weight_objective_61, r1_.weight_before_baked_weight_registered AS weight_before_baked_weight_registered_62, r1_.weight_before_baked_unit_objective AS weight_before_baked_unit_objective_63, r1_.weight_before_baked_unit_registered AS weight_before_baked_unit_registered_64, r1_.topping_weight_before_baked_number AS topping_weight_before_baked_number_65, r1_.topping_weight_before_baked_weight_objective AS topping_weight_before_baked_weight_objective_66, r1_.topping_weight_before_baked_weight_registered AS topping_weight_before_baked_weight_registered_67, r1_.topping_weight_before_baked_unit_objective AS topping_weight_before_baked_unit_objective_68, r1_.topping_weight_before_baked_unit_registered AS topping_weight_before_baked_unit_registered_69, r1_.topping_quantity_before_objective AS topping_quantity_before_objective_70, r1_.topping_quantity_before_registered AS topping_quantity_before_registered_71, r1_.stuffed_weight_before_baked_number AS stuffed_weight_before_baked_number_72, r1_.stuffed_weight_before_baked_weight_objective AS stuffed_weight_before_baked_weight_objective_73, r1_.stuffed_weight_before_baked_weight_registered AS stuffed_weight_before_baked_weight_registered_74, r1_.stuffed_weight_before_baked_unit_objective AS stuffed_weight_before_baked_unit_objective_75, r1_.stuffed_weight_before_baked_unit_registered AS stuffed_weight_before_baked_unit_registered_76, r1_.stuffed_quantity_before_objective AS stuffed_quantity_before_objective_77, r1_.stuffed_quantity_before_registered AS stuffed_quantity_before_registered_78, r1_.weight_after_baked_number AS weight_after_baked_number_79, r1_.weight_after_baked_weight_objective AS weight_after_baked_weight_objective_80, r1_.weight_after_baked_weight_registered AS weight_after_baked_weight_registered_81, r1_.weight_after_baked_unit_objective AS weight_after_baked_unit_objective_82, r1_.weight_after_baked_unit_registered AS weight_after_baked_unit_registered_83, r1_.weight_after_baked_weight_objective_leak AS weight_after_baked_weight_objective_leak_84, r1_.weight_after_baked_weight_registered_leak AS weight_after_baked_weight_registered_leak_85, r1_.topping_weight_after_baked_number AS topping_weight_after_baked_number_86, r1_.topping_weight_after_baked_weight_objective AS topping_weight_after_baked_weight_objective_87, r1_.topping_weight_after_baked_weight_registered AS topping_weight_after_baked_weight_registered_88, r1_.topping_weight_after_baked_unit_objective AS topping_weight_after_baked_unit_objective_89, r1_.topping_weight_after_baked_unit_registered AS topping_weight_after_baked_unit_registered_90, r1_.topping_weight_after_baked_weight_objective_leak AS topping_weight_after_baked_weight_objective_leak_91, r1_.topping_weight_after_baked_weight_registered_leak AS topping_weight_after_baked_weight_registered_leak_92, r1_.stuffed_weight_after_baked_number AS stuffed_weight_after_baked_number_93, r1_.stuffed_weight_after_baked_weight_objective AS stuffed_weight_after_baked_weight_objective_94, r1_.stuffed_weight_after_baked_weight_registered AS stuffed_weight_after_baked_weight_registered_95, r1_.stuffed_weight_after_baked_unit_objective AS stuffed_weight_after_baked_unit_objective_96, r1_.stuffed_weight_after_baked_unit_registered AS stuffed_weight_after_baked_unit_registered_97, r1_.stuffed_weight_after_baked_weight_objective_leak AS stuffed_weight_after_baked_weight_objective_leak_98, r1_.stuffed_weight_after_baked_weight_registered_leak AS stuffed_weight_after_baked_weight_registered_leak_99, r1_.oc1_tempsup_s3 AS oc1_tempsup_s3_100, r1_.oc1_tempsup_s2 AS oc1_tempsup_s2_101, r1_.oc1_tempsup_s1 AS oc1_tempsup_s1_102, r1_.oc1_tempinf_s3 AS oc1_tempinf_s3_103, r1_.oc1_tempinf_s2 AS oc1_tempinf_s2_104, r1_.oc1_tempinf_s1 AS oc1_tempinf_s1_105, r1_.oc1_tiros_s3_f AS oc1_tiros_s3_f_106, r1_.oc1_tiros_s3_e AS oc1_tiros_s3_e_107, r1_.oc1_tiros_s2_d AS oc1_tiros_s2_d_108, r1_.oc1_tiros_s2_c AS oc1_tiros_s2_c_109, r1_.oc1_tiros_s1_b AS oc1_tiros_s1_b_110, r1_.oc1_tiros_s1_a AS oc1_tiros_s1_a_111, r1_.oc_rows AS oc_rows_112, r1_.oc_time AS oc_time_113, r1_.oc_observations AS oc_observations_114, r1_.oc2_calorsup_s3 AS oc2_calorsup_s3_115, r1_.oc2_calorsup_s2 AS oc2_calorsup_s2_116, r1_.oc2_calorsup_s1 AS oc2_calorsup_s1_117, r1_.oc2_temp_s3 AS oc2_temp_s3_118, r1_.oc2_temp_s2 AS oc2_temp_s2_119, r1_.oc2_temp_s1 AS oc2_temp_s1_120, r1_.oc2_tiros_s3 AS oc2_tiros_s3_121, r1_.oc2_tiros_s2 AS oc2_tiros_s2_122, r1_.oc2_tiros_s1 AS oc2_tiros_s1_123, r1_.oc2_fan_f AS oc2_fan_f_124, r1_.oc2_fan_d AS oc2_fan_d_125, r1_.oc2_fan_b AS oc2_fan_b_126, r1_.doc3_temp AS doc3_temp_127, r1_.oc3_temp AS oc3_temp_128, k2_.id AS id_129, k2_.name AS name_130, r0_.recipe_test_id AS recipe_test_id_131, r0_.kneading_id AS kneading_id_132, r1_.recipe_id AS recipe_id_133 FROM recipe_test_phase r0_ LEFT JOIN recipe_test r1_ ON r0_.recipe_test_id = r1_.id INNER JOIN kneading_type k2_ ON r0_.kneading_id = k2_.id WHERE r0_.recipe_test_id = ? ORDER BY r0_.id ASC
Parameters: 
[
  "53"
]
View formatted query    View runnable query    Explain query

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\RecipeTestPhase No errors.
App\Entity\RecipeTest No errors.
App\Entity\KneadingType No errors.
App\Entity\Recipe No errors.