| 1 |
2.79 ms |
SELECT r0_.id AS id_0, r0_.phase_imported AS phase_imported_1, r0_.quantity_imported AS quantity_imported_2, r0_.percentage_imported AS percentage_imported_3, r0_.observations_imported AS observations_imported_4, r0_.quantity AS quantity_5, r0_.observations AS observations_6, r0_.processed_quantity AS processed_quantity_7, r0_.processed_percentage AS processed_percentage_8, r0_.cost AS cost_9, r0_.nutritional_info AS nutritional_info_10, r1_.id AS id_11, r1_.code AS code_12, r1_.state AS state_13, r1_.test_date AS test_date_14, r1_.mold AS mold_15, r1_.packaging AS packaging_16, r1_.type AS type_17, r1_.line AS line_18, r1_.observations AS observations_19, r1_.nutriscore AS nutriscore_20, r1_.cost AS cost_21, r1_.final_test AS final_test_22, r1_.oven AS oven_23, r1_.nutritional_info AS nutritional_info_24, r1_.moisture_baked_product_target AS moisture_baked_product_target_25, r1_.moisture_baked_product_register AS moisture_baked_product_register_26, r1_.raw_dimensions_diameter_objective AS raw_dimensions_diameter_objective_27, r1_.raw_dimensions_diameter_result AS raw_dimensions_diameter_result_28, r1_.raw_dimensions_long_objective AS raw_dimensions_long_objective_29, r1_.raw_dimensions_long_result AS raw_dimensions_long_result_30, r1_.raw_dimensions_width_objective AS raw_dimensions_width_objective_31, r1_.raw_dimensions_width_result AS raw_dimensions_width_result_32, r1_.raw_dimensions_height_objective AS raw_dimensions_height_objective_33, r1_.raw_dimensions_height_result AS raw_dimensions_height_result_34, r1_.baked_dimensions_diameter_objective AS baked_dimensions_diameter_objective_35, r1_.baked_dimensions_diameter_result AS baked_dimensions_diameter_result_36, r1_.baked_dimensions_long_objective AS baked_dimensions_long_objective_37, r1_.baked_dimensions_long_result AS baked_dimensions_long_result_38, r1_.baked_dimensions_width_objective AS baked_dimensions_width_objective_39, r1_.baked_dimensions_width_result AS baked_dimensions_width_result_40, r1_.baked_dimensions_height_objective AS baked_dimensions_height_objective_41, r1_.baked_dimensions_height_result AS baked_dimensions_height_result_42, r1_.galletas_plaston_superficie_objectivo AS galletas_plaston_superficie_objectivo_43, r1_.galletas_plaston_superficie_registrada AS galletas_plaston_superficie_registrada_44, r1_.galletas_plaston_perdida_objectivo AS galletas_plaston_perdida_objectivo_45, r1_.galletas_plaston_perdida_registrada AS galletas_plaston_perdida_registrada_46, r1_.peso_oblea_unidades AS peso_oblea_unidades_47, r1_.peso_oblea_objetivo AS peso_oblea_objetivo_48, r1_.peso_oblea_registrado AS peso_oblea_registrado_49, r1_.peso_plaston_unidades AS peso_plaston_unidades_50, r1_.peso_plaston_objetivo AS peso_plaston_objetivo_51, r1_.peso_plaston_registrado AS peso_plaston_registrado_52, r1_.obleas_por_plaston AS obleas_por_plaston_53, r1_.capas_relleno_plaston AS capas_relleno_plaston_54, r1_.peso_galleta_barquillo_unidad AS peso_galleta_barquillo_unidad_55, r1_.peso_galleta_barquillo_objetivo AS peso_galleta_barquillo_objetivo_56, r1_.peso_galleta_barquillo_registrado AS peso_galleta_barquillo_registrado_57, r1_.dev_dimensions_diameter_objective AS dev_dimensions_diameter_objective_58, r1_.dev_dimensions_diameter_result AS dev_dimensions_diameter_result_59, r1_.dev_dimensions_long_objective AS dev_dimensions_long_objective_60, r1_.dev_dimensions_long_result AS dev_dimensions_long_result_61, r1_.dev_dimensions_width_objective AS dev_dimensions_width_objective_62, r1_.dev_dimensions_width_result AS dev_dimensions_width_result_63, r1_.dev_dimensions_height_objective AS dev_dimensions_height_objective_64, r1_.dev_dimensions_height_result AS dev_dimensions_height_result_65, r1_.weight_before_baked_number AS weight_before_baked_number_66, r1_.weight_before_baked_weight_objective AS weight_before_baked_weight_objective_67, r1_.weight_before_baked_weight_registered AS weight_before_baked_weight_registered_68, r1_.weight_before_baked_unit_objective AS weight_before_baked_unit_objective_69, r1_.weight_before_baked_unit_registered AS weight_before_baked_unit_registered_70, r1_.topping_weight_before_baked_number AS topping_weight_before_baked_number_71, r1_.topping_weight_before_baked_weight_objective AS topping_weight_before_baked_weight_objective_72, r1_.topping_weight_before_baked_weight_registered AS topping_weight_before_baked_weight_registered_73, r1_.topping_weight_before_baked_unit_objective AS topping_weight_before_baked_unit_objective_74, r1_.topping_weight_before_baked_unit_registered AS topping_weight_before_baked_unit_registered_75, r1_.topping_quantity_before_objective AS topping_quantity_before_objective_76, r1_.topping_quantity_before_registered AS topping_quantity_before_registered_77, r1_.stuffed_weight_before_baked_number AS stuffed_weight_before_baked_number_78, r1_.stuffed_weight_before_baked_weight_objective AS stuffed_weight_before_baked_weight_objective_79, r1_.stuffed_weight_before_baked_weight_registered AS stuffed_weight_before_baked_weight_registered_80, r1_.stuffed_weight_before_baked_unit_objective AS stuffed_weight_before_baked_unit_objective_81, r1_.stuffed_weight_before_baked_unit_registered AS stuffed_weight_before_baked_unit_registered_82, r1_.stuffed_quantity_before_objective AS stuffed_quantity_before_objective_83, r1_.stuffed_quantity_before_registered AS stuffed_quantity_before_registered_84, r1_.weight_after_baked_number AS weight_after_baked_number_85, r1_.weight_after_baked_weight_objective AS weight_after_baked_weight_objective_86, r1_.weight_after_baked_weight_registered AS weight_after_baked_weight_registered_87, r1_.weight_after_baked_unit_objective AS weight_after_baked_unit_objective_88, r1_.weight_after_baked_unit_registered AS weight_after_baked_unit_registered_89, r1_.weight_after_baked_weight_objective_leak AS weight_after_baked_weight_objective_leak_90, r1_.weight_after_baked_weight_registered_leak AS weight_after_baked_weight_registered_leak_91, r1_.topping_weight_after_baked_number AS topping_weight_after_baked_number_92, r1_.topping_weight_after_baked_weight_objective AS topping_weight_after_baked_weight_objective_93, r1_.topping_weight_after_baked_weight_registered AS topping_weight_after_baked_weight_registered_94, r1_.topping_weight_after_baked_unit_objective AS topping_weight_after_baked_unit_objective_95, r1_.topping_weight_after_baked_unit_registered AS topping_weight_after_baked_unit_registered_96, r1_.topping_weight_after_baked_weight_objective_leak AS topping_weight_after_baked_weight_objective_leak_97, r1_.topping_weight_after_baked_weight_registered_leak AS topping_weight_after_baked_weight_registered_leak_98, r1_.stuffed_weight_after_baked_number AS stuffed_weight_after_baked_number_99, r1_.stuffed_weight_after_baked_weight_objective AS stuffed_weight_after_baked_weight_objective_100, r1_.stuffed_weight_after_baked_weight_registered AS stuffed_weight_after_baked_weight_registered_101, r1_.stuffed_weight_after_baked_unit_objective AS stuffed_weight_after_baked_unit_objective_102, r1_.stuffed_weight_after_baked_unit_registered AS stuffed_weight_after_baked_unit_registered_103, r1_.stuffed_weight_after_baked_weight_objective_leak AS stuffed_weight_after_baked_weight_objective_leak_104, r1_.stuffed_weight_after_baked_weight_registered_leak AS stuffed_weight_after_baked_weight_registered_leak_105, r1_.oc1_tempsup_s3 AS oc1_tempsup_s3_106, r1_.oc1_tempsup_s2 AS oc1_tempsup_s2_107, r1_.oc1_tempsup_s1 AS oc1_tempsup_s1_108, r1_.oc1_tempinf_s3 AS oc1_tempinf_s3_109, r1_.oc1_tempinf_s2 AS oc1_tempinf_s2_110, r1_.oc1_tempinf_s1 AS oc1_tempinf_s1_111, r1_.oc1_tiros_s3_f AS oc1_tiros_s3_f_112, r1_.oc1_tiros_s3_e AS oc1_tiros_s3_e_113, r1_.oc1_tiros_s2_d AS oc1_tiros_s2_d_114, r1_.oc1_tiros_s2_c AS oc1_tiros_s2_c_115, r1_.oc1_tiros_s1_b AS oc1_tiros_s1_b_116, r1_.oc1_tiros_s1_a AS oc1_tiros_s1_a_117, r1_.oc_rows AS oc_rows_118, r1_.oc_time AS oc_time_119, r1_.oc_observations AS oc_observations_120, r1_.oc2_calorsup_s3 AS oc2_calorsup_s3_121, r1_.oc2_calorsup_s2 AS oc2_calorsup_s2_122, r1_.oc2_calorsup_s1 AS oc2_calorsup_s1_123, r1_.oc2_temp_s3 AS oc2_temp_s3_124, r1_.oc2_temp_s2 AS oc2_temp_s2_125, r1_.oc2_temp_s1 AS oc2_temp_s1_126, r1_.oc2_tiros_s3 AS oc2_tiros_s3_127, r1_.oc2_tiros_s2 AS oc2_tiros_s2_128, r1_.oc2_tiros_s1 AS oc2_tiros_s1_129, r1_.oc2_fan_f AS oc2_fan_f_130, r1_.oc2_fan_d AS oc2_fan_d_131, r1_.oc2_fan_b AS oc2_fan_b_132, r1_.doc3_temp AS doc3_temp_133, r1_.oc3_temp AS oc3_temp_134, r2_.id AS id_135, r2_.code AS code_136, r2_.name AS name_137, r2_.public_name AS public_name_138, r2_.allergens AS allergens_139, r2_.price AS price_140, r2_.humidity AS humidity_141, r2_.grease AS grease_142, r2_.saturated_fatty_acids AS saturated_fatty_acids_143, r2_.monosaturated_fatty_acids AS monosaturated_fatty_acids_144, r2_.polyunsaturated_fats AS polyunsaturated_fats_145, r2_.salatrim AS salatrim_146, r2_.carbohydrates AS carbohydrates_147, r2_.sugars AS sugars_148, r2_.polyalcohols AS polyalcohols_149, r2_.alcohol AS alcohol_150, r2_.organic_acids AS organic_acids_151, r2_.starches AS starches_152, r2_.erythritol AS erythritol_153, r2_.fiber AS fiber_154, r2_.proteins AS proteins_155, r2_.mineral_salts AS mineral_salts_156, r2_.salt AS salt_157, r2_.sodium AS sodium_158, r2_.lost_volatilization AS lost_volatilization_159, r2_.vitamin_a AS vitamin_a_160, r2_.vitamin_b1 AS vitamin_b1_161, r2_.vitamin_b2 AS vitamin_b2_162, r2_.vitamin_b3 AS vitamin_b3_163, r2_.vitamin_b5 AS vitamin_b5_164, r2_.vitamin_b6 AS vitamin_b6_165, r2_.vitamin_b9 AS vitamin_b9_166, r2_.vitamin_b12 AS vitamin_b12_167, r2_.vitamin_c AS vitamin_c_168, r2_.vitamin_d AS vitamin_d_169, r2_.vitamin_e AS vitamin_e_170, r2_.vitamin_h AS vitamin_h_171, r2_.vitamin_k AS vitamin_k_172, r2_.calcium AS calcium_173, r2_.iron AS iron_174, r2_.magnesium AS magnesium_175, r2_.match_element AS match_element_176, r2_.potassium AS potassium_177, r2_.chlorine AS chlorine_178, r2_.zinc AS zinc_179, r2_.copper AS copper_180, r2_.manganese AS manganese_181, r2_.fluorine AS fluorine_182, r2_.selenium AS selenium_183, r2_.chromium AS chromium_184, r2_.molybdenum AS molybdenum_185, r2_.iodine AS iodine_186, r3_.id AS id_187, r3_.code AS code_188, r3_.time AS time_189, r3_.velocity AS velocity_190, r3_.observations AS observations_191, r0_.recipe_test_id AS recipe_test_id_192, r0_.raw_material_id AS raw_material_id_193, r0_.phase_id AS phase_id_194, r1_.recipe_id AS recipe_id_195, r3_.recipe_test_id AS recipe_test_id_196, r3_.kneading_id AS kneading_id_197 FROM recipe_test_raw_material r0_ INNER JOIN recipe_test r1_ ON r0_.recipe_test_id = r1_.id INNER JOIN raw_material r2_ ON r0_.raw_material_id = r2_.id INNER JOIN recipe_test_phase r3_ ON r0_.phase_id = r3_.id WHERE r0_.recipe_test_id = ? ORDER BY r0_.id ASC
SELECT
r0_.id AS id_0,
r0_.phase_imported AS phase_imported_1,
r0_.quantity_imported AS quantity_imported_2,
r0_.percentage_imported AS percentage_imported_3,
r0_.observations_imported AS observations_imported_4,
r0_.quantity AS quantity_5,
r0_.observations AS observations_6,
r0_.processed_quantity AS processed_quantity_7,
r0_.processed_percentage AS processed_percentage_8,
r0_.cost AS cost_9,
r0_.nutritional_info AS nutritional_info_10,
r1_.id AS id_11,
r1_.code AS code_12,
r1_.state AS state_13,
r1_.test_date AS test_date_14,
r1_.mold AS mold_15,
r1_.packaging AS packaging_16,
r1_.type AS type_17,
r1_.line AS line_18,
r1_.observations AS observations_19,
r1_.nutriscore AS nutriscore_20,
r1_.cost AS cost_21,
r1_.final_test AS final_test_22,
r1_.oven AS oven_23,
r1_.nutritional_info AS nutritional_info_24,
r1_.moisture_baked_product_target AS moisture_baked_product_target_25,
r1_.moisture_baked_product_register AS moisture_baked_product_register_26,
r1_.raw_dimensions_diameter_objective AS raw_dimensions_diameter_objective_27,
r1_.raw_dimensions_diameter_result AS raw_dimensions_diameter_result_28,
r1_.raw_dimensions_long_objective AS raw_dimensions_long_objective_29,
r1_.raw_dimensions_long_result AS raw_dimensions_long_result_30,
r1_.raw_dimensions_width_objective AS raw_dimensions_width_objective_31,
r1_.raw_dimensions_width_result AS raw_dimensions_width_result_32,
r1_.raw_dimensions_height_objective AS raw_dimensions_height_objective_33,
r1_.raw_dimensions_height_result AS raw_dimensions_height_result_34,
r1_.baked_dimensions_diameter_objective AS baked_dimensions_diameter_objective_35,
r1_.baked_dimensions_diameter_result AS baked_dimensions_diameter_result_36,
r1_.baked_dimensions_long_objective AS baked_dimensions_long_objective_37,
r1_.baked_dimensions_long_result AS baked_dimensions_long_result_38,
r1_.baked_dimensions_width_objective AS baked_dimensions_width_objective_39,
r1_.baked_dimensions_width_result AS baked_dimensions_width_result_40,
r1_.baked_dimensions_height_objective AS baked_dimensions_height_objective_41,
r1_.baked_dimensions_height_result AS baked_dimensions_height_result_42,
r1_.galletas_plaston_superficie_objectivo AS galletas_plaston_superficie_objectivo_43,
r1_.galletas_plaston_superficie_registrada AS galletas_plaston_superficie_registrada_44,
r1_.galletas_plaston_perdida_objectivo AS galletas_plaston_perdida_objectivo_45,
r1_.galletas_plaston_perdida_registrada AS galletas_plaston_perdida_registrada_46,
r1_.peso_oblea_unidades AS peso_oblea_unidades_47,
r1_.peso_oblea_objetivo AS peso_oblea_objetivo_48,
r1_.peso_oblea_registrado AS peso_oblea_registrado_49,
r1_.peso_plaston_unidades AS peso_plaston_unidades_50,
r1_.peso_plaston_objetivo AS peso_plaston_objetivo_51,
r1_.peso_plaston_registrado AS peso_plaston_registrado_52,
r1_.obleas_por_plaston AS obleas_por_plaston_53,
r1_.capas_relleno_plaston AS capas_relleno_plaston_54,
r1_.peso_galleta_barquillo_unidad AS peso_galleta_barquillo_unidad_55,
r1_.peso_galleta_barquillo_objetivo AS peso_galleta_barquillo_objetivo_56,
r1_.peso_galleta_barquillo_registrado AS peso_galleta_barquillo_registrado_57,
r1_.dev_dimensions_diameter_objective AS dev_dimensions_diameter_objective_58,
r1_.dev_dimensions_diameter_result AS dev_dimensions_diameter_result_59,
r1_.dev_dimensions_long_objective AS dev_dimensions_long_objective_60,
r1_.dev_dimensions_long_result AS dev_dimensions_long_result_61,
r1_.dev_dimensions_width_objective AS dev_dimensions_width_objective_62,
r1_.dev_dimensions_width_result AS dev_dimensions_width_result_63,
r1_.dev_dimensions_height_objective AS dev_dimensions_height_objective_64,
r1_.dev_dimensions_height_result AS dev_dimensions_height_result_65,
r1_.weight_before_baked_number AS weight_before_baked_number_66,
r1_.weight_before_baked_weight_objective AS weight_before_baked_weight_objective_67,
r1_.weight_before_baked_weight_registered AS weight_before_baked_weight_registered_68,
r1_.weight_before_baked_unit_objective AS weight_before_baked_unit_objective_69,
r1_.weight_before_baked_unit_registered AS weight_before_baked_unit_registered_70,
r1_.topping_weight_before_baked_number AS topping_weight_before_baked_number_71,
r1_.topping_weight_before_baked_weight_objective AS topping_weight_before_baked_weight_objective_72,
r1_.topping_weight_before_baked_weight_registered AS topping_weight_before_baked_weight_registered_73,
r1_.topping_weight_before_baked_unit_objective AS topping_weight_before_baked_unit_objective_74,
r1_.topping_weight_before_baked_unit_registered AS topping_weight_before_baked_unit_registered_75,
r1_.topping_quantity_before_objective AS topping_quantity_before_objective_76,
r1_.topping_quantity_before_registered AS topping_quantity_before_registered_77,
r1_.stuffed_weight_before_baked_number AS stuffed_weight_before_baked_number_78,
r1_.stuffed_weight_before_baked_weight_objective AS stuffed_weight_before_baked_weight_objective_79,
r1_.stuffed_weight_before_baked_weight_registered AS stuffed_weight_before_baked_weight_registered_80,
r1_.stuffed_weight_before_baked_unit_objective AS stuffed_weight_before_baked_unit_objective_81,
r1_.stuffed_weight_before_baked_unit_registered AS stuffed_weight_before_baked_unit_registered_82,
r1_.stuffed_quantity_before_objective AS stuffed_quantity_before_objective_83,
r1_.stuffed_quantity_before_registered AS stuffed_quantity_before_registered_84,
r1_.weight_after_baked_number AS weight_after_baked_number_85,
r1_.weight_after_baked_weight_objective AS weight_after_baked_weight_objective_86,
r1_.weight_after_baked_weight_registered AS weight_after_baked_weight_registered_87,
r1_.weight_after_baked_unit_objective AS weight_after_baked_unit_objective_88,
r1_.weight_after_baked_unit_registered AS weight_after_baked_unit_registered_89,
r1_.weight_after_baked_weight_objective_leak AS weight_after_baked_weight_objective_leak_90,
r1_.weight_after_baked_weight_registered_leak AS weight_after_baked_weight_registered_leak_91,
r1_.topping_weight_after_baked_number AS topping_weight_after_baked_number_92,
r1_.topping_weight_after_baked_weight_objective AS topping_weight_after_baked_weight_objective_93,
r1_.topping_weight_after_baked_weight_registered AS topping_weight_after_baked_weight_registered_94,
r1_.topping_weight_after_baked_unit_objective AS topping_weight_after_baked_unit_objective_95,
r1_.topping_weight_after_baked_unit_registered AS topping_weight_after_baked_unit_registered_96,
r1_.topping_weight_after_baked_weight_objective_leak AS topping_weight_after_baked_weight_objective_leak_97,
r1_.topping_weight_after_baked_weight_registered_leak AS topping_weight_after_baked_weight_registered_leak_98,
r1_.stuffed_weight_after_baked_number AS stuffed_weight_after_baked_number_99,
r1_.stuffed_weight_after_baked_weight_objective AS stuffed_weight_after_baked_weight_objective_100,
r1_.stuffed_weight_after_baked_weight_registered AS stuffed_weight_after_baked_weight_registered_101,
r1_.stuffed_weight_after_baked_unit_objective AS stuffed_weight_after_baked_unit_objective_102,
r1_.stuffed_weight_after_baked_unit_registered AS stuffed_weight_after_baked_unit_registered_103,
r1_.stuffed_weight_after_baked_weight_objective_leak AS stuffed_weight_after_baked_weight_objective_leak_104,
r1_.stuffed_weight_after_baked_weight_registered_leak AS stuffed_weight_after_baked_weight_registered_leak_105,
r1_.oc1_tempsup_s3 AS oc1_tempsup_s3_106,
r1_.oc1_tempsup_s2 AS oc1_tempsup_s2_107,
r1_.oc1_tempsup_s1 AS oc1_tempsup_s1_108,
r1_.oc1_tempinf_s3 AS oc1_tempinf_s3_109,
r1_.oc1_tempinf_s2 AS oc1_tempinf_s2_110,
r1_.oc1_tempinf_s1 AS oc1_tempinf_s1_111,
r1_.oc1_tiros_s3_f AS oc1_tiros_s3_f_112,
r1_.oc1_tiros_s3_e AS oc1_tiros_s3_e_113,
r1_.oc1_tiros_s2_d AS oc1_tiros_s2_d_114,
r1_.oc1_tiros_s2_c AS oc1_tiros_s2_c_115,
r1_.oc1_tiros_s1_b AS oc1_tiros_s1_b_116,
r1_.oc1_tiros_s1_a AS oc1_tiros_s1_a_117,
r1_.oc_rows AS oc_rows_118,
r1_.oc_time AS oc_time_119,
r1_.oc_observations AS oc_observations_120,
r1_.oc2_calorsup_s3 AS oc2_calorsup_s3_121,
r1_.oc2_calorsup_s2 AS oc2_calorsup_s2_122,
r1_.oc2_calorsup_s1 AS oc2_calorsup_s1_123,
r1_.oc2_temp_s3 AS oc2_temp_s3_124,
r1_.oc2_temp_s2 AS oc2_temp_s2_125,
r1_.oc2_temp_s1 AS oc2_temp_s1_126,
r1_.oc2_tiros_s3 AS oc2_tiros_s3_127,
r1_.oc2_tiros_s2 AS oc2_tiros_s2_128,
r1_.oc2_tiros_s1 AS oc2_tiros_s1_129,
r1_.oc2_fan_f AS oc2_fan_f_130,
r1_.oc2_fan_d AS oc2_fan_d_131,
r1_.oc2_fan_b AS oc2_fan_b_132,
r1_.doc3_temp AS doc3_temp_133,
r1_.oc3_temp AS oc3_temp_134,
r2_.id AS id_135,
r2_.code AS code_136,
r2_.name AS name_137,
r2_.public_name AS public_name_138,
r2_.allergens AS allergens_139,
r2_.price AS price_140,
r2_.humidity AS humidity_141,
r2_.grease AS grease_142,
r2_.saturated_fatty_acids AS saturated_fatty_acids_143,
r2_.monosaturated_fatty_acids AS monosaturated_fatty_acids_144,
r2_.polyunsaturated_fats AS polyunsaturated_fats_145,
r2_.salatrim AS salatrim_146,
r2_.carbohydrates AS carbohydrates_147,
r2_.sugars AS sugars_148,
r2_.polyalcohols AS polyalcohols_149,
r2_.alcohol AS alcohol_150,
r2_.organic_acids AS organic_acids_151,
r2_.starches AS starches_152,
r2_.erythritol AS erythritol_153,
r2_.fiber AS fiber_154,
r2_.proteins AS proteins_155,
r2_.mineral_salts AS mineral_salts_156,
r2_.salt AS salt_157,
r2_.sodium AS sodium_158,
r2_.lost_volatilization AS lost_volatilization_159,
r2_.vitamin_a AS vitamin_a_160,
r2_.vitamin_b1 AS vitamin_b1_161,
r2_.vitamin_b2 AS vitamin_b2_162,
r2_.vitamin_b3 AS vitamin_b3_163,
r2_.vitamin_b5 AS vitamin_b5_164,
r2_.vitamin_b6 AS vitamin_b6_165,
r2_.vitamin_b9 AS vitamin_b9_166,
r2_.vitamin_b12 AS vitamin_b12_167,
r2_.vitamin_c AS vitamin_c_168,
r2_.vitamin_d AS vitamin_d_169,
r2_.vitamin_e AS vitamin_e_170,
r2_.vitamin_h AS vitamin_h_171,
r2_.vitamin_k AS vitamin_k_172,
r2_.calcium AS calcium_173,
r2_.iron AS iron_174,
r2_.magnesium AS magnesium_175,
r2_.match_element AS match_element_176,
r2_.potassium AS potassium_177,
r2_.chlorine AS chlorine_178,
r2_.zinc AS zinc_179,
r2_.copper AS copper_180,
r2_.manganese AS manganese_181,
r2_.fluorine AS fluorine_182,
r2_.selenium AS selenium_183,
r2_.chromium AS chromium_184,
r2_.molybdenum AS molybdenum_185,
r2_.iodine AS iodine_186,
r3_.id AS id_187,
r3_.code AS code_188,
r3_.time AS time_189,
r3_.velocity AS velocity_190,
r3_.observations AS observations_191,
r0_.recipe_test_id AS recipe_test_id_192,
r0_.raw_material_id AS raw_material_id_193,
r0_.phase_id AS phase_id_194,
r1_.recipe_id AS recipe_id_195,
r3_.recipe_test_id AS recipe_test_id_196,
r3_.kneading_id AS kneading_id_197
FROM
recipe_test_raw_material r0_
INNER JOIN recipe_test r1_ ON r0_.recipe_test_id = r1_.id
INNER JOIN raw_material r2_ ON r0_.raw_material_id = r2_.id
INNER JOIN recipe_test_phase r3_ ON r0_.phase_id = r3_.id
WHERE
r0_.recipe_test_id = ?
ORDER BY
r0_.id ASC
SELECT r0_.id AS id_0, r0_.phase_imported AS phase_imported_1, r0_.quantity_imported AS quantity_imported_2, r0_.percentage_imported AS percentage_imported_3, r0_.observations_imported AS observations_imported_4, r0_.quantity AS quantity_5, r0_.observations AS observations_6, r0_.processed_quantity AS processed_quantity_7, r0_.processed_percentage AS processed_percentage_8, r0_.cost AS cost_9, r0_.nutritional_info AS nutritional_info_10, r1_.id AS id_11, r1_.code AS code_12, r1_.state AS state_13, r1_.test_date AS test_date_14, r1_.mold AS mold_15, r1_.packaging AS packaging_16, r1_.type AS type_17, r1_.line AS line_18, r1_.observations AS observations_19, r1_.nutriscore AS nutriscore_20, r1_.cost AS cost_21, r1_.final_test AS final_test_22, r1_.oven AS oven_23, r1_.nutritional_info AS nutritional_info_24, r1_.moisture_baked_product_target AS moisture_baked_product_target_25, r1_.moisture_baked_product_register AS moisture_baked_product_register_26, r1_.raw_dimensions_diameter_objective AS raw_dimensions_diameter_objective_27, r1_.raw_dimensions_diameter_result AS raw_dimensions_diameter_result_28, r1_.raw_dimensions_long_objective AS raw_dimensions_long_objective_29, r1_.raw_dimensions_long_result AS raw_dimensions_long_result_30, r1_.raw_dimensions_width_objective AS raw_dimensions_width_objective_31, r1_.raw_dimensions_width_result AS raw_dimensions_width_result_32, r1_.raw_dimensions_height_objective AS raw_dimensions_height_objective_33, r1_.raw_dimensions_height_result AS raw_dimensions_height_result_34, r1_.baked_dimensions_diameter_objective AS baked_dimensions_diameter_objective_35, r1_.baked_dimensions_diameter_result AS baked_dimensions_diameter_result_36, r1_.baked_dimensions_long_objective AS baked_dimensions_long_objective_37, r1_.baked_dimensions_long_result AS baked_dimensions_long_result_38, r1_.baked_dimensions_width_objective AS baked_dimensions_width_objective_39, r1_.baked_dimensions_width_result AS baked_dimensions_width_result_40, r1_.baked_dimensions_height_objective AS baked_dimensions_height_objective_41, r1_.baked_dimensions_height_result AS baked_dimensions_height_result_42, r1_.galletas_plaston_superficie_objectivo AS galletas_plaston_superficie_objectivo_43, r1_.galletas_plaston_superficie_registrada AS galletas_plaston_superficie_registrada_44, r1_.galletas_plaston_perdida_objectivo AS galletas_plaston_perdida_objectivo_45, r1_.galletas_plaston_perdida_registrada AS galletas_plaston_perdida_registrada_46, r1_.peso_oblea_unidades AS peso_oblea_unidades_47, r1_.peso_oblea_objetivo AS peso_oblea_objetivo_48, r1_.peso_oblea_registrado AS peso_oblea_registrado_49, r1_.peso_plaston_unidades AS peso_plaston_unidades_50, r1_.peso_plaston_objetivo AS peso_plaston_objetivo_51, r1_.peso_plaston_registrado AS peso_plaston_registrado_52, r1_.obleas_por_plaston AS obleas_por_plaston_53, r1_.capas_relleno_plaston AS capas_relleno_plaston_54, r1_.peso_galleta_barquillo_unidad AS peso_galleta_barquillo_unidad_55, r1_.peso_galleta_barquillo_objetivo AS peso_galleta_barquillo_objetivo_56, r1_.peso_galleta_barquillo_registrado AS peso_galleta_barquillo_registrado_57, r1_.dev_dimensions_diameter_objective AS dev_dimensions_diameter_objective_58, r1_.dev_dimensions_diameter_result AS dev_dimensions_diameter_result_59, r1_.dev_dimensions_long_objective AS dev_dimensions_long_objective_60, r1_.dev_dimensions_long_result AS dev_dimensions_long_result_61, r1_.dev_dimensions_width_objective AS dev_dimensions_width_objective_62, r1_.dev_dimensions_width_result AS dev_dimensions_width_result_63, r1_.dev_dimensions_height_objective AS dev_dimensions_height_objective_64, r1_.dev_dimensions_height_result AS dev_dimensions_height_result_65, r1_.weight_before_baked_number AS weight_before_baked_number_66, r1_.weight_before_baked_weight_objective AS weight_before_baked_weight_objective_67, r1_.weight_before_baked_weight_registered AS weight_before_baked_weight_registered_68, r1_.weight_before_baked_unit_objective AS weight_before_baked_unit_objective_69, r1_.weight_before_baked_unit_registered AS weight_before_baked_unit_registered_70, r1_.topping_weight_before_baked_number AS topping_weight_before_baked_number_71, r1_.topping_weight_before_baked_weight_objective AS topping_weight_before_baked_weight_objective_72, r1_.topping_weight_before_baked_weight_registered AS topping_weight_before_baked_weight_registered_73, r1_.topping_weight_before_baked_unit_objective AS topping_weight_before_baked_unit_objective_74, r1_.topping_weight_before_baked_unit_registered AS topping_weight_before_baked_unit_registered_75, r1_.topping_quantity_before_objective AS topping_quantity_before_objective_76, r1_.topping_quantity_before_registered AS topping_quantity_before_registered_77, r1_.stuffed_weight_before_baked_number AS stuffed_weight_before_baked_number_78, r1_.stuffed_weight_before_baked_weight_objective AS stuffed_weight_before_baked_weight_objective_79, r1_.stuffed_weight_before_baked_weight_registered AS stuffed_weight_before_baked_weight_registered_80, r1_.stuffed_weight_before_baked_unit_objective AS stuffed_weight_before_baked_unit_objective_81, r1_.stuffed_weight_before_baked_unit_registered AS stuffed_weight_before_baked_unit_registered_82, r1_.stuffed_quantity_before_objective AS stuffed_quantity_before_objective_83, r1_.stuffed_quantity_before_registered AS stuffed_quantity_before_registered_84, r1_.weight_after_baked_number AS weight_after_baked_number_85, r1_.weight_after_baked_weight_objective AS weight_after_baked_weight_objective_86, r1_.weight_after_baked_weight_registered AS weight_after_baked_weight_registered_87, r1_.weight_after_baked_unit_objective AS weight_after_baked_unit_objective_88, r1_.weight_after_baked_unit_registered AS weight_after_baked_unit_registered_89, r1_.weight_after_baked_weight_objective_leak AS weight_after_baked_weight_objective_leak_90, r1_.weight_after_baked_weight_registered_leak AS weight_after_baked_weight_registered_leak_91, r1_.topping_weight_after_baked_number AS topping_weight_after_baked_number_92, r1_.topping_weight_after_baked_weight_objective AS topping_weight_after_baked_weight_objective_93, r1_.topping_weight_after_baked_weight_registered AS topping_weight_after_baked_weight_registered_94, r1_.topping_weight_after_baked_unit_objective AS topping_weight_after_baked_unit_objective_95, r1_.topping_weight_after_baked_unit_registered AS topping_weight_after_baked_unit_registered_96, r1_.topping_weight_after_baked_weight_objective_leak AS topping_weight_after_baked_weight_objective_leak_97, r1_.topping_weight_after_baked_weight_registered_leak AS topping_weight_after_baked_weight_registered_leak_98, r1_.stuffed_weight_after_baked_number AS stuffed_weight_after_baked_number_99, r1_.stuffed_weight_after_baked_weight_objective AS stuffed_weight_after_baked_weight_objective_100, r1_.stuffed_weight_after_baked_weight_registered AS stuffed_weight_after_baked_weight_registered_101, r1_.stuffed_weight_after_baked_unit_objective AS stuffed_weight_after_baked_unit_objective_102, r1_.stuffed_weight_after_baked_unit_registered AS stuffed_weight_after_baked_unit_registered_103, r1_.stuffed_weight_after_baked_weight_objective_leak AS stuffed_weight_after_baked_weight_objective_leak_104, r1_.stuffed_weight_after_baked_weight_registered_leak AS stuffed_weight_after_baked_weight_registered_leak_105, r1_.oc1_tempsup_s3 AS oc1_tempsup_s3_106, r1_.oc1_tempsup_s2 AS oc1_tempsup_s2_107, r1_.oc1_tempsup_s1 AS oc1_tempsup_s1_108, r1_.oc1_tempinf_s3 AS oc1_tempinf_s3_109, r1_.oc1_tempinf_s2 AS oc1_tempinf_s2_110, r1_.oc1_tempinf_s1 AS oc1_tempinf_s1_111, r1_.oc1_tiros_s3_f AS oc1_tiros_s3_f_112, r1_.oc1_tiros_s3_e AS oc1_tiros_s3_e_113, r1_.oc1_tiros_s2_d AS oc1_tiros_s2_d_114, r1_.oc1_tiros_s2_c AS oc1_tiros_s2_c_115, r1_.oc1_tiros_s1_b AS oc1_tiros_s1_b_116, r1_.oc1_tiros_s1_a AS oc1_tiros_s1_a_117, r1_.oc_rows AS oc_rows_118, r1_.oc_time AS oc_time_119, r1_.oc_observations AS oc_observations_120, r1_.oc2_calorsup_s3 AS oc2_calorsup_s3_121, r1_.oc2_calorsup_s2 AS oc2_calorsup_s2_122, r1_.oc2_calorsup_s1 AS oc2_calorsup_s1_123, r1_.oc2_temp_s3 AS oc2_temp_s3_124, r1_.oc2_temp_s2 AS oc2_temp_s2_125, r1_.oc2_temp_s1 AS oc2_temp_s1_126, r1_.oc2_tiros_s3 AS oc2_tiros_s3_127, r1_.oc2_tiros_s2 AS oc2_tiros_s2_128, r1_.oc2_tiros_s1 AS oc2_tiros_s1_129, r1_.oc2_fan_f AS oc2_fan_f_130, r1_.oc2_fan_d AS oc2_fan_d_131, r1_.oc2_fan_b AS oc2_fan_b_132, r1_.doc3_temp AS doc3_temp_133, r1_.oc3_temp AS oc3_temp_134, r2_.id AS id_135, r2_.code AS code_136, r2_.name AS name_137, r2_.public_name AS public_name_138, r2_.allergens AS allergens_139, r2_.price AS price_140, r2_.humidity AS humidity_141, r2_.grease AS grease_142, r2_.saturated_fatty_acids AS saturated_fatty_acids_143, r2_.monosaturated_fatty_acids AS monosaturated_fatty_acids_144, r2_.polyunsaturated_fats AS polyunsaturated_fats_145, r2_.salatrim AS salatrim_146, r2_.carbohydrates AS carbohydrates_147, r2_.sugars AS sugars_148, r2_.polyalcohols AS polyalcohols_149, r2_.alcohol AS alcohol_150, r2_.organic_acids AS organic_acids_151, r2_.starches AS starches_152, r2_.erythritol AS erythritol_153, r2_.fiber AS fiber_154, r2_.proteins AS proteins_155, r2_.mineral_salts AS mineral_salts_156, r2_.salt AS salt_157, r2_.sodium AS sodium_158, r2_.lost_volatilization AS lost_volatilization_159, r2_.vitamin_a AS vitamin_a_160, r2_.vitamin_b1 AS vitamin_b1_161, r2_.vitamin_b2 AS vitamin_b2_162, r2_.vitamin_b3 AS vitamin_b3_163, r2_.vitamin_b5 AS vitamin_b5_164, r2_.vitamin_b6 AS vitamin_b6_165, r2_.vitamin_b9 AS vitamin_b9_166, r2_.vitamin_b12 AS vitamin_b12_167, r2_.vitamin_c AS vitamin_c_168, r2_.vitamin_d AS vitamin_d_169, r2_.vitamin_e AS vitamin_e_170, r2_.vitamin_h AS vitamin_h_171, r2_.vitamin_k AS vitamin_k_172, r2_.calcium AS calcium_173, r2_.iron AS iron_174, r2_.magnesium AS magnesium_175, r2_.match_element AS match_element_176, r2_.potassium AS potassium_177, r2_.chlorine AS chlorine_178, r2_.zinc AS zinc_179, r2_.copper AS copper_180, r2_.manganese AS manganese_181, r2_.fluorine AS fluorine_182, r2_.selenium AS selenium_183, r2_.chromium AS chromium_184, r2_.molybdenum AS molybdenum_185, r2_.iodine AS iodine_186, r3_.id AS id_187, r3_.code AS code_188, r3_.time AS time_189, r3_.velocity AS velocity_190, r3_.observations AS observations_191, r0_.recipe_test_id AS recipe_test_id_192, r0_.raw_material_id AS raw_material_id_193, r0_.phase_id AS phase_id_194, r1_.recipe_id AS recipe_id_195, r3_.recipe_test_id AS recipe_test_id_196, r3_.kneading_id AS kneading_id_197 FROM recipe_test_raw_material r0_ INNER JOIN recipe_test r1_ ON r0_.recipe_test_id = r1_.id INNER JOIN raw_material r2_ ON r0_.raw_material_id = r2_.id INNER JOIN recipe_test_phase r3_ ON r0_.phase_id = r3_.id WHERE r0_.recipe_test_id = '364' ORDER BY r0_.id ASC;
|