Symfony Profiler

SELECT
  t0.assay_id AS assay_id_1,
  t0.device_id AS device_id_2,
  t0.sample_id AS sample_id_3,
  t0.sample_type_other AS sample_type_other_4,
  t0.certificate_result_type AS certificate_result_type_5,
  t0.photo_filename AS photo_filename_6,
  t0.sinave_result_type AS sinave_result_type_7,
  t0.device_latitude AS device_latitude_8,
  t0.device_longitude AS device_longitude_9,
  t0.batch AS batch_10,
  t0.status AS status_11,
  t0.expected_entry_count AS expected_entry_count_12,
  t0.received_entry_count AS received_entry_count_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.hardware_version AS hardware_version_16,
  t0.firmware_version AS firmware_version_17,
  t0.software_version AS software_version_18,
  t0.device_model AS device_model_19,
  t0.device_version AS device_version_20,
  t0.internal_control_type AS internal_control_type_21,
  t0.internal_control_ref AS internal_control_ref_22,
  t0.reporter AS reporter_23,
  t0.skip_analysis AS skip_analysis_24,
  t0.protocol_id AS protocol_id_25,
  t0.user_id AS user_id_26,
  t0.sample_type AS sample_type_27,
  t28.assay_result_id AS assay_result_id_29,
  t28.ct_assay_a AS ct_assay_a_30,
  t28.result_a AS result_a_31,
  t28.predicted_result_a AS predicted_result_a_32,
  t28.biomarker_a AS biomarker_a_33,
  t28.ct_assay_b AS ct_assay_b_34,
  t28.result_b AS result_b_35,
  t28.predicted_result_b AS predicted_result_b_36,
  t28.biomarker_b AS biomarker_b_37,
  t28.created_at AS created_at_38,
  t28.updated_at AS updated_at_39,
  t28.details AS details_40,
  t28.predicted_details AS predicted_details_41,
  t28.health_authority_rx AS health_authority_rx_42,
  t28.result_merged AS result_merged_43,
  t28.result_control AS result_control_44,
  t28.intermediate_results AS intermediate_results_45,
  t28.assay_id AS assay_id_46,
  t0.analysis_method_id AS analysis_method_id_47
FROM
  assays t0
  LEFT JOIN assay_results t28 ON t28.assay_id = t0.assay_id
WHERE
  t0.assay_id = ?

SELECT t0.assay_id AS assay_id_1, t0.device_id AS device_id_2, t0.sample_id AS sample_id_3, t0.sample_type_other AS sample_type_other_4, t0.certificate_result_type AS certificate_result_type_5, t0.photo_filename AS photo_filename_6, t0.sinave_result_type AS sinave_result_type_7, t0.device_latitude AS device_latitude_8, t0.device_longitude AS device_longitude_9, t0.batch AS batch_10, t0.status AS status_11, t0.expected_entry_count AS expected_entry_count_12, t0.received_entry_count AS received_entry_count_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.hardware_version AS hardware_version_16, t0.firmware_version AS firmware_version_17, t0.software_version AS software_version_18, t0.device_model AS device_model_19, t0.device_version AS device_version_20, t0.internal_control_type AS internal_control_type_21, t0.internal_control_ref AS internal_control_ref_22, t0.reporter AS reporter_23, t0.skip_analysis AS skip_analysis_24, t0.protocol_id AS protocol_id_25, t0.user_id AS user_id_26, t0.sample_type AS sample_type_27, t28.assay_result_id AS assay_result_id_29, t28.ct_assay_a AS ct_assay_a_30, t28.result_a AS result_a_31, t28.predicted_result_a AS predicted_result_a_32, t28.biomarker_a AS biomarker_a_33, t28.ct_assay_b AS ct_assay_b_34, t28.result_b AS result_b_35, t28.predicted_result_b AS predicted_result_b_36, t28.biomarker_b AS biomarker_b_37, t28.created_at AS created_at_38, t28.updated_at AS updated_at_39, t28.details AS details_40, t28.predicted_details AS predicted_details_41, t28.health_authority_rx AS health_authority_rx_42, t28.result_merged AS result_merged_43, t28.result_control AS result_control_44, t28.intermediate_results AS intermediate_results_45, t28.assay_id AS assay_id_46, t0.analysis_method_id AS analysis_method_id_47 FROM assays t0 LEFT JOIN assay_results t28 ON t28.assay_id = t0.assay_id WHERE t0.assay_id = '4304';

SELECT
  t0.entry_number AS entry_number_1,
  t0.data_time AS data_time_2,
  t0.smoothed_ch1 AS smoothed_ch1_3,
  t0.smoothed_ch2 AS smoothed_ch2_4,
  t0.chA1 AS chA1_5,
  t0.chA2 AS chA2_6,
  t0.chA3 AS chA3_7,
  t0.chA4 AS chA4_8,
  t0.chA5 AS chA5_9,
  t0.chA6 AS chA6_10,
  t0.chB1 AS chB1_11,
  t0.chB2 AS chB2_12,
  t0.chB3 AS chB3_13,
  t0.chB4 AS chB4_14,
  t0.chB5 AS chB5_15,
  t0.chB6 AS chB6_16,
  t0.read_temperature AS read_temperature_17,
  t0.instruction_order AS instruction_order_18,
  t0.instruction_type AS instruction_type_19,
  t0.assay_id AS assay_id_20
FROM
  assay_data t0
WHERE
  t0.assay_id = ?
ORDER BY
  t0.entry_number ASC

SELECT t0.entry_number AS entry_number_1, t0.data_time AS data_time_2, t0.smoothed_ch1 AS smoothed_ch1_3, t0.smoothed_ch2 AS smoothed_ch2_4, t0.chA1 AS chA1_5, t0.chA2 AS chA2_6, t0.chA3 AS chA3_7, t0.chA4 AS chA4_8, t0.chA5 AS chA5_9, t0.chA6 AS chA6_10, t0.chB1 AS chB1_11, t0.chB2 AS chB2_12, t0.chB3 AS chB3_13, t0.chB4 AS chB4_14, t0.chB5 AS chB5_15, t0.chB6 AS chB6_16, t0.read_temperature AS read_temperature_17, t0.instruction_order AS instruction_order_18, t0.instruction_type AS instruction_type_19, t0.assay_id AS assay_id_20 FROM assay_data t0 WHERE t0.assay_id = 4304 ORDER BY t0.entry_number ASC;

SELECT
  t0.protocol_id AS protocol_id_1,
  t0.temperature AS temperature_2,
  t0.assay_duration AS assay_duration_3,
  t0.data_interval AS data_interval_4,
  t0.biomarker_a AS biomarker_a_5,
  t0.analysis_channel_a AS analysis_channel_a_6,
  t0.fluor_cutoff_a AS fluor_cutoff_a_7,
  t0.ct_cutoff_a AS ct_cutoff_a_8,
  t0.led_color_a AS led_color_a_9,
  t0.biomarker_b AS biomarker_b_10,
  t0.analysis_channel_b AS analysis_channel_b_11,
  t0.fluor_cutoff_b AS fluor_cutoff_b_12,
  t0.ct_cutoff_b AS ct_cutoff_b_13,
  t0.led_color_b AS led_color_b_14,
  t0.sensor_gain AS sensor_gain_15,
  t0.sku AS sku_16,
  t0.version AS version_17,
  t0.analysis_init_time AS analysis_init_time_18,
  t0.requires_confirmation AS requires_confirmation_19,
  t0.wait_results AS wait_results_20,
  t0.wait_results_seconds AS wait_results_seconds_21,
  t0.wait_results_retries AS wait_results_retries_22,
  t0.dynamic_analysis AS dynamic_analysis_23,
  t0.instructions AS instructions_24,
  t0.notify_sinave AS notify_sinave_25,
  t0.skip_analysis AS skip_analysis_26,
  t0.step_to_analyze AS step_to_analyze_27,
  t0.heating_led_color AS heating_led_color_28,
  t0.cooling_led_color AS cooling_led_color_29,
  t0.default_analysis_method_id AS default_analysis_method_id_30,
  t0.test_id AS test_id_31,
  t32.test_id AS test_id_33,
  t32.test_type AS test_type_34,
  t32.identifier AS identifier_35,
  t32.certificate_template AS certificate_template_36,
  t32.use_for_customer_protocols AS use_for_customer_protocols_37,
  t32.show_in_app_to AS show_in_app_to_38,
  t32.updated_at AS updated_at_39,
  t32.position AS position_40,
  t32.button_icon_name AS button_icon_name_41,
  t32.button_icon_original_name AS button_icon_original_name_42,
  t32.button_icon_mime_type AS button_icon_mime_type_43,
  t32.button_icon_size AS button_icon_size_44,
  t32.button_icon_dimensions AS button_icon_dimensions_45,
  t32.background_image_name AS background_image_name_46,
  t32.background_image_original_name AS background_image_original_name_47,
  t32.background_image_mime_type AS background_image_mime_type_48,
  t32.background_image_size AS background_image_size_49,
  t32.background_image_dimensions AS background_image_dimensions_50,
  t0.customer_id AS customer_id_51
FROM
  protocols t0
  LEFT JOIN tests t32 ON t0.test_id = t32.test_id
WHERE
  t0.protocol_id = ?

SELECT t0.protocol_id AS protocol_id_1, t0.temperature AS temperature_2, t0.assay_duration AS assay_duration_3, t0.data_interval AS data_interval_4, t0.biomarker_a AS biomarker_a_5, t0.analysis_channel_a AS analysis_channel_a_6, t0.fluor_cutoff_a AS fluor_cutoff_a_7, t0.ct_cutoff_a AS ct_cutoff_a_8, t0.led_color_a AS led_color_a_9, t0.biomarker_b AS biomarker_b_10, t0.analysis_channel_b AS analysis_channel_b_11, t0.fluor_cutoff_b AS fluor_cutoff_b_12, t0.ct_cutoff_b AS ct_cutoff_b_13, t0.led_color_b AS led_color_b_14, t0.sensor_gain AS sensor_gain_15, t0.sku AS sku_16, t0.version AS version_17, t0.analysis_init_time AS analysis_init_time_18, t0.requires_confirmation AS requires_confirmation_19, t0.wait_results AS wait_results_20, t0.wait_results_seconds AS wait_results_seconds_21, t0.wait_results_retries AS wait_results_retries_22, t0.dynamic_analysis AS dynamic_analysis_23, t0.instructions AS instructions_24, t0.notify_sinave AS notify_sinave_25, t0.skip_analysis AS skip_analysis_26, t0.step_to_analyze AS step_to_analyze_27, t0.heating_led_color AS heating_led_color_28, t0.cooling_led_color AS cooling_led_color_29, t0.default_analysis_method_id AS default_analysis_method_id_30, t0.test_id AS test_id_31, t32.test_id AS test_id_33, t32.test_type AS test_type_34, t32.identifier AS identifier_35, t32.certificate_template AS certificate_template_36, t32.use_for_customer_protocols AS use_for_customer_protocols_37, t32.show_in_app_to AS show_in_app_to_38, t32.updated_at AS updated_at_39, t32.position AS position_40, t32.button_icon_name AS button_icon_name_41, t32.button_icon_original_name AS button_icon_original_name_42, t32.button_icon_mime_type AS button_icon_mime_type_43, t32.button_icon_size AS button_icon_size_44, t32.button_icon_dimensions AS button_icon_dimensions_45, t32.background_image_name AS background_image_name_46, t32.background_image_original_name AS background_image_original_name_47, t32.background_image_mime_type AS background_image_mime_type_48, t32.background_image_size AS background_image_size_49, t32.background_image_dimensions AS background_image_dimensions_50, t0.customer_id AS customer_id_51 FROM protocols t0 LEFT JOIN tests t32 ON t0.test_id = t32.test_id WHERE t0.protocol_id = 78;

SELECT
  t0.analysis_method_id AS analysis_method_id_1,
  t0.ref AS ref_2,
  t0.name AS name_3,
  t0.version AS version_4,
  t0.algorithm AS algorithm_5,
  t0.configuration AS configuration_6
FROM
  analysis_methods t0
  INNER JOIN protocol_analysis_methods ON t0.analysis_method_id = protocol_analysis_methods.analysis_method_id
WHERE
  protocol_analysis_methods.protocol_id = ?

SELECT t0.analysis_method_id AS analysis_method_id_1, t0.ref AS ref_2, t0.name AS name_3, t0.version AS version_4, t0.algorithm AS algorithm_5, t0.configuration AS configuration_6 FROM analysis_methods t0 INNER JOIN protocol_analysis_methods ON t0.analysis_method_id = protocol_analysis_methods.analysis_method_id WHERE protocol_analysis_methods.protocol_id = 78;

SELECT
  t0.version_id AS version_id_1,
  t0.version_name AS version_name_2,
  t0.version_code AS version_code_3,
  t0.version_notes AS version_notes_4,
  t0.date AS date_5,
  t0.git_hash AS git_hash_6,
  t0.app_os AS app_os_7
FROM
  app_version t0
WHERE
  t0.version_code = ?
LIMIT
  1

SELECT t0.version_id AS version_id_1, t0.version_name AS version_name_2, t0.version_code AS version_code_3, t0.version_notes AS version_notes_4, t0.date AS date_5, t0.git_hash AS git_hash_6, t0.app_os AS app_os_7 FROM app_version t0 WHERE t0.version_code = '39' LIMIT 1;

SELECT
  t0.assay_report_id AS assay_report_id_1,
  t0.reporter AS reporter_2,
  t0.status AS status_3,
  t0.data AS data_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.assay_id AS assay_id_7,
  t8.assay_id AS assay_id_9,
  t8.device_id AS device_id_10,
  t8.sample_id AS sample_id_11,
  t8.sample_type_other AS sample_type_other_12,
  t8.certificate_result_type AS certificate_result_type_13,
  t8.photo_filename AS photo_filename_14,
  t8.sinave_result_type AS sinave_result_type_15,
  t8.device_latitude AS device_latitude_16,
  t8.device_longitude AS device_longitude_17,
  t8.batch AS batch_18,
  t8.status AS status_19,
  t8.expected_entry_count AS expected_entry_count_20,
  t8.received_entry_count AS received_entry_count_21,
  t8.created_at AS created_at_22,
  t8.updated_at AS updated_at_23,
  t8.hardware_version AS hardware_version_24,
  t8.firmware_version AS firmware_version_25,
  t8.software_version AS software_version_26,
  t8.device_model AS device_model_27,
  t8.device_version AS device_version_28,
  t8.internal_control_type AS internal_control_type_29,
  t8.internal_control_ref AS internal_control_ref_30,
  t8.reporter AS reporter_31,
  t8.skip_analysis AS skip_analysis_32,
  t8.protocol_id AS protocol_id_33,
  t8.user_id AS user_id_34,
  t8.sample_type AS sample_type_35,
  t8.analysis_method_id AS analysis_method_id_36
FROM
  assay_reports t0
  INNER JOIN assays t8 ON t0.assay_id = t8.assay_id
WHERE
  t0.assay_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.assay_report_id AS assay_report_id_1, t0.reporter AS reporter_2, t0.status AS status_3, t0.data AS data_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.assay_id AS assay_id_7, t8.assay_id AS assay_id_9, t8.device_id AS device_id_10, t8.sample_id AS sample_id_11, t8.sample_type_other AS sample_type_other_12, t8.certificate_result_type AS certificate_result_type_13, t8.photo_filename AS photo_filename_14, t8.sinave_result_type AS sinave_result_type_15, t8.device_latitude AS device_latitude_16, t8.device_longitude AS device_longitude_17, t8.batch AS batch_18, t8.status AS status_19, t8.expected_entry_count AS expected_entry_count_20, t8.received_entry_count AS received_entry_count_21, t8.created_at AS created_at_22, t8.updated_at AS updated_at_23, t8.hardware_version AS hardware_version_24, t8.firmware_version AS firmware_version_25, t8.software_version AS software_version_26, t8.device_model AS device_model_27, t8.device_version AS device_version_28, t8.internal_control_type AS internal_control_type_29, t8.internal_control_ref AS internal_control_ref_30, t8.reporter AS reporter_31, t8.skip_analysis AS skip_analysis_32, t8.protocol_id AS protocol_id_33, t8.user_id AS user_id_34, t8.sample_type AS sample_type_35, t8.analysis_method_id AS analysis_method_id_36 FROM assay_reports t0 INNER JOIN assays t8 ON t0.assay_id = t8.assay_id WHERE t0.assay_id = 4304 ORDER BY t0.created_at DESC;