7.48 ms
(0.00%)
|
1 |
SELECT DISTINCT assay_id_0 FROM (SELECT DISTINCT assay_id_0, created_at_13 FROM (SELECT a0_.assay_id AS assay_id_0, a0_.device_id AS device_id_1, a0_.sample_id AS sample_id_2, a0_.sample_type_other AS sample_type_other_3, a0_.certificate_result_type AS certificate_result_type_4, a0_.photo_filename AS photo_filename_5, a0_.sinave_result_type AS sinave_result_type_6, a0_.device_latitude AS device_latitude_7, a0_.device_longitude AS device_longitude_8, a0_.batch AS batch_9, a0_.status AS status_10, a0_.expected_entry_count AS expected_entry_count_11, a0_.received_entry_count AS received_entry_count_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.hardware_version AS hardware_version_15, a0_.firmware_version AS firmware_version_16, a0_.software_version AS software_version_17, a0_.device_model AS device_model_18, a0_.device_version AS device_version_19, a0_.internal_control_type AS internal_control_type_20, a0_.internal_control_ref AS internal_control_ref_21, a0_.reporter AS reporter_22, a0_.skip_analysis AS skip_analysis_23, p1_.protocol_id AS protocol_id_24, p1_.temperature AS temperature_25, p1_.assay_duration AS assay_duration_26, p1_.data_interval AS data_interval_27, p1_.biomarker_a AS biomarker_a_28, p1_.analysis_channel_a AS analysis_channel_a_29, p1_.fluor_cutoff_a AS fluor_cutoff_a_30, p1_.ct_cutoff_a AS ct_cutoff_a_31, p1_.led_color_a AS led_color_a_32, p1_.biomarker_b AS biomarker_b_33, p1_.analysis_channel_b AS analysis_channel_b_34, p1_.fluor_cutoff_b AS fluor_cutoff_b_35, p1_.ct_cutoff_b AS ct_cutoff_b_36, p1_.led_color_b AS led_color_b_37, p1_.sensor_gain AS sensor_gain_38, p1_.sku AS sku_39, p1_.version AS version_40, p1_.analysis_init_time AS analysis_init_time_41, p1_.requires_confirmation AS requires_confirmation_42, p1_.wait_results AS wait_results_43, p1_.wait_results_seconds AS wait_results_seconds_44, p1_.wait_results_retries AS wait_results_retries_45, p1_.dynamic_analysis AS dynamic_analysis_46, p1_.instructions AS instructions_47, p1_.notify_sinave AS notify_sinave_48, p1_.skip_analysis AS skip_analysis_49, p1_.step_to_analyze AS step_to_analyze_50, p1_.heating_led_color AS heating_led_color_51, p1_.cooling_led_color AS cooling_led_color_52, a2_.assay_result_id AS assay_result_id_53, a2_.ct_assay_a AS ct_assay_a_54, a2_.result_a AS result_a_55, a2_.predicted_result_a AS predicted_result_a_56, a2_.biomarker_a AS biomarker_a_57, a2_.ct_assay_b AS ct_assay_b_58, a2_.result_b AS result_b_59, a2_.predicted_result_b AS predicted_result_b_60, a2_.biomarker_b AS biomarker_b_61, a2_.created_at AS created_at_62, a2_.updated_at AS updated_at_63, a2_.details AS details_64, a2_.predicted_details AS predicted_details_65, a2_.health_authority_rx AS health_authority_rx_66, a2_.result_merged AS result_merged_67, a2_.result_control AS result_control_68, a2_.intermediate_results AS intermediate_results_69, u3_.user_id AS user_id_70, u3_.email AS email_71, u3_.password AS password_72, u3_.reset_password_token AS reset_password_token_73, u3_.reset_password_expires_at AS reset_password_expires_at_74 FROM assays a0_ INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id) dctrn_result_inner ORDER BY created_at_13 DESC) dctrn_result LIMIT 25
SELECT
DISTINCT assay_id_0
FROM
(
SELECT
DISTINCT assay_id_0,
created_at_13
FROM
(
SELECT
a0_.assay_id AS assay_id_0,
a0_.device_id AS device_id_1,
a0_.sample_id AS sample_id_2,
a0_.sample_type_other AS sample_type_other_3,
a0_.certificate_result_type AS certificate_result_type_4,
a0_.photo_filename AS photo_filename_5,
a0_.sinave_result_type AS sinave_result_type_6,
a0_.device_latitude AS device_latitude_7,
a0_.device_longitude AS device_longitude_8,
a0_.batch AS batch_9,
a0_.status AS status_10,
a0_.expected_entry_count AS expected_entry_count_11,
a0_.received_entry_count AS received_entry_count_12,
a0_.created_at AS created_at_13,
a0_.updated_at AS updated_at_14,
a0_.hardware_version AS hardware_version_15,
a0_.firmware_version AS firmware_version_16,
a0_.software_version AS software_version_17,
a0_.device_model AS device_model_18,
a0_.device_version AS device_version_19,
a0_.internal_control_type AS internal_control_type_20,
a0_.internal_control_ref AS internal_control_ref_21,
a0_.reporter AS reporter_22,
a0_.skip_analysis AS skip_analysis_23,
p1_.protocol_id AS protocol_id_24,
p1_.temperature AS temperature_25,
p1_.assay_duration AS assay_duration_26,
p1_.data_interval AS data_interval_27,
p1_.biomarker_a AS biomarker_a_28,
p1_.analysis_channel_a AS analysis_channel_a_29,
p1_.fluor_cutoff_a AS fluor_cutoff_a_30,
p1_.ct_cutoff_a AS ct_cutoff_a_31,
p1_.led_color_a AS led_color_a_32,
p1_.biomarker_b AS biomarker_b_33,
p1_.analysis_channel_b AS analysis_channel_b_34,
p1_.fluor_cutoff_b AS fluor_cutoff_b_35,
p1_.ct_cutoff_b AS ct_cutoff_b_36,
p1_.led_color_b AS led_color_b_37,
p1_.sensor_gain AS sensor_gain_38,
p1_.sku AS sku_39,
p1_.version AS version_40,
p1_.analysis_init_time AS analysis_init_time_41,
p1_.requires_confirmation AS requires_confirmation_42,
p1_.wait_results AS wait_results_43,
p1_.wait_results_seconds AS wait_results_seconds_44,
p1_.wait_results_retries AS wait_results_retries_45,
p1_.dynamic_analysis AS dynamic_analysis_46,
p1_.instructions AS instructions_47,
p1_.notify_sinave AS notify_sinave_48,
p1_.skip_analysis AS skip_analysis_49,
p1_.step_to_analyze AS step_to_analyze_50,
p1_.heating_led_color AS heating_led_color_51,
p1_.cooling_led_color AS cooling_led_color_52,
a2_.assay_result_id AS assay_result_id_53,
a2_.ct_assay_a AS ct_assay_a_54,
a2_.result_a AS result_a_55,
a2_.predicted_result_a AS predicted_result_a_56,
a2_.biomarker_a AS biomarker_a_57,
a2_.ct_assay_b AS ct_assay_b_58,
a2_.result_b AS result_b_59,
a2_.predicted_result_b AS predicted_result_b_60,
a2_.biomarker_b AS biomarker_b_61,
a2_.created_at AS created_at_62,
a2_.updated_at AS updated_at_63,
a2_.details AS details_64,
a2_.predicted_details AS predicted_details_65,
a2_.health_authority_rx AS health_authority_rx_66,
a2_.result_merged AS result_merged_67,
a2_.result_control AS result_control_68,
a2_.intermediate_results AS intermediate_results_69,
u3_.user_id AS user_id_70,
u3_.email AS email_71,
u3_.password AS password_72,
u3_.reset_password_token AS reset_password_token_73,
u3_.reset_password_expires_at AS reset_password_expires_at_74
FROM
assays a0_
INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id
LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id
LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id
) dctrn_result_inner
ORDER BY
created_at_13 DESC
) dctrn_result
LIMIT
25
SELECT DISTINCT assay_id_0 FROM (SELECT DISTINCT assay_id_0, created_at_13 FROM (SELECT a0_.assay_id AS assay_id_0, a0_.device_id AS device_id_1, a0_.sample_id AS sample_id_2, a0_.sample_type_other AS sample_type_other_3, a0_.certificate_result_type AS certificate_result_type_4, a0_.photo_filename AS photo_filename_5, a0_.sinave_result_type AS sinave_result_type_6, a0_.device_latitude AS device_latitude_7, a0_.device_longitude AS device_longitude_8, a0_.batch AS batch_9, a0_.status AS status_10, a0_.expected_entry_count AS expected_entry_count_11, a0_.received_entry_count AS received_entry_count_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.hardware_version AS hardware_version_15, a0_.firmware_version AS firmware_version_16, a0_.software_version AS software_version_17, a0_.device_model AS device_model_18, a0_.device_version AS device_version_19, a0_.internal_control_type AS internal_control_type_20, a0_.internal_control_ref AS internal_control_ref_21, a0_.reporter AS reporter_22, a0_.skip_analysis AS skip_analysis_23, p1_.protocol_id AS protocol_id_24, p1_.temperature AS temperature_25, p1_.assay_duration AS assay_duration_26, p1_.data_interval AS data_interval_27, p1_.biomarker_a AS biomarker_a_28, p1_.analysis_channel_a AS analysis_channel_a_29, p1_.fluor_cutoff_a AS fluor_cutoff_a_30, p1_.ct_cutoff_a AS ct_cutoff_a_31, p1_.led_color_a AS led_color_a_32, p1_.biomarker_b AS biomarker_b_33, p1_.analysis_channel_b AS analysis_channel_b_34, p1_.fluor_cutoff_b AS fluor_cutoff_b_35, p1_.ct_cutoff_b AS ct_cutoff_b_36, p1_.led_color_b AS led_color_b_37, p1_.sensor_gain AS sensor_gain_38, p1_.sku AS sku_39, p1_.version AS version_40, p1_.analysis_init_time AS analysis_init_time_41, p1_.requires_confirmation AS requires_confirmation_42, p1_.wait_results AS wait_results_43, p1_.wait_results_seconds AS wait_results_seconds_44, p1_.wait_results_retries AS wait_results_retries_45, p1_.dynamic_analysis AS dynamic_analysis_46, p1_.instructions AS instructions_47, p1_.notify_sinave AS notify_sinave_48, p1_.skip_analysis AS skip_analysis_49, p1_.step_to_analyze AS step_to_analyze_50, p1_.heating_led_color AS heating_led_color_51, p1_.cooling_led_color AS cooling_led_color_52, a2_.assay_result_id AS assay_result_id_53, a2_.ct_assay_a AS ct_assay_a_54, a2_.result_a AS result_a_55, a2_.predicted_result_a AS predicted_result_a_56, a2_.biomarker_a AS biomarker_a_57, a2_.ct_assay_b AS ct_assay_b_58, a2_.result_b AS result_b_59, a2_.predicted_result_b AS predicted_result_b_60, a2_.biomarker_b AS biomarker_b_61, a2_.created_at AS created_at_62, a2_.updated_at AS updated_at_63, a2_.details AS details_64, a2_.predicted_details AS predicted_details_65, a2_.health_authority_rx AS health_authority_rx_66, a2_.result_merged AS result_merged_67, a2_.result_control AS result_control_68, a2_.intermediate_results AS intermediate_results_69, u3_.user_id AS user_id_70, u3_.email AS email_71, u3_.password AS password_72, u3_.reset_password_token AS reset_password_token_73, u3_.reset_password_expires_at AS reset_password_expires_at_74 FROM assays a0_ INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id) dctrn_result_inner ORDER BY created_at_13 DESC) dctrn_result LIMIT 25;
|
6.04 ms
(0.00%)
|
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT assay_id_0 FROM (SELECT a0_.assay_id AS assay_id_0, a0_.device_id AS device_id_1, a0_.sample_id AS sample_id_2, a0_.sample_type_other AS sample_type_other_3, a0_.certificate_result_type AS certificate_result_type_4, a0_.photo_filename AS photo_filename_5, a0_.sinave_result_type AS sinave_result_type_6, a0_.device_latitude AS device_latitude_7, a0_.device_longitude AS device_longitude_8, a0_.batch AS batch_9, a0_.status AS status_10, a0_.expected_entry_count AS expected_entry_count_11, a0_.received_entry_count AS received_entry_count_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.hardware_version AS hardware_version_15, a0_.firmware_version AS firmware_version_16, a0_.software_version AS software_version_17, a0_.device_model AS device_model_18, a0_.device_version AS device_version_19, a0_.internal_control_type AS internal_control_type_20, a0_.internal_control_ref AS internal_control_ref_21, a0_.reporter AS reporter_22, a0_.skip_analysis AS skip_analysis_23, p1_.protocol_id AS protocol_id_24, p1_.temperature AS temperature_25, p1_.assay_duration AS assay_duration_26, p1_.data_interval AS data_interval_27, p1_.biomarker_a AS biomarker_a_28, p1_.analysis_channel_a AS analysis_channel_a_29, p1_.fluor_cutoff_a AS fluor_cutoff_a_30, p1_.ct_cutoff_a AS ct_cutoff_a_31, p1_.led_color_a AS led_color_a_32, p1_.biomarker_b AS biomarker_b_33, p1_.analysis_channel_b AS analysis_channel_b_34, p1_.fluor_cutoff_b AS fluor_cutoff_b_35, p1_.ct_cutoff_b AS ct_cutoff_b_36, p1_.led_color_b AS led_color_b_37, p1_.sensor_gain AS sensor_gain_38, p1_.sku AS sku_39, p1_.version AS version_40, p1_.analysis_init_time AS analysis_init_time_41, p1_.requires_confirmation AS requires_confirmation_42, p1_.wait_results AS wait_results_43, p1_.wait_results_seconds AS wait_results_seconds_44, p1_.wait_results_retries AS wait_results_retries_45, p1_.dynamic_analysis AS dynamic_analysis_46, p1_.instructions AS instructions_47, p1_.notify_sinave AS notify_sinave_48, p1_.skip_analysis AS skip_analysis_49, p1_.step_to_analyze AS step_to_analyze_50, p1_.heating_led_color AS heating_led_color_51, p1_.cooling_led_color AS cooling_led_color_52, a2_.assay_result_id AS assay_result_id_53, a2_.ct_assay_a AS ct_assay_a_54, a2_.result_a AS result_a_55, a2_.predicted_result_a AS predicted_result_a_56, a2_.biomarker_a AS biomarker_a_57, a2_.ct_assay_b AS ct_assay_b_58, a2_.result_b AS result_b_59, a2_.predicted_result_b AS predicted_result_b_60, a2_.biomarker_b AS biomarker_b_61, a2_.created_at AS created_at_62, a2_.updated_at AS updated_at_63, a2_.details AS details_64, a2_.predicted_details AS predicted_details_65, a2_.health_authority_rx AS health_authority_rx_66, a2_.result_merged AS result_merged_67, a2_.result_control AS result_control_68, a2_.intermediate_results AS intermediate_results_69, u3_.user_id AS user_id_70, u3_.email AS email_71, u3_.password AS password_72, u3_.reset_password_token AS reset_password_token_73, u3_.reset_password_expires_at AS reset_password_expires_at_74 FROM assays a0_ INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table
SELECT
COUNT(*) AS dctrn_count
FROM
(
SELECT
DISTINCT assay_id_0
FROM
(
SELECT
a0_.assay_id AS assay_id_0,
a0_.device_id AS device_id_1,
a0_.sample_id AS sample_id_2,
a0_.sample_type_other AS sample_type_other_3,
a0_.certificate_result_type AS certificate_result_type_4,
a0_.photo_filename AS photo_filename_5,
a0_.sinave_result_type AS sinave_result_type_6,
a0_.device_latitude AS device_latitude_7,
a0_.device_longitude AS device_longitude_8,
a0_.batch AS batch_9,
a0_.status AS status_10,
a0_.expected_entry_count AS expected_entry_count_11,
a0_.received_entry_count AS received_entry_count_12,
a0_.created_at AS created_at_13,
a0_.updated_at AS updated_at_14,
a0_.hardware_version AS hardware_version_15,
a0_.firmware_version AS firmware_version_16,
a0_.software_version AS software_version_17,
a0_.device_model AS device_model_18,
a0_.device_version AS device_version_19,
a0_.internal_control_type AS internal_control_type_20,
a0_.internal_control_ref AS internal_control_ref_21,
a0_.reporter AS reporter_22,
a0_.skip_analysis AS skip_analysis_23,
p1_.protocol_id AS protocol_id_24,
p1_.temperature AS temperature_25,
p1_.assay_duration AS assay_duration_26,
p1_.data_interval AS data_interval_27,
p1_.biomarker_a AS biomarker_a_28,
p1_.analysis_channel_a AS analysis_channel_a_29,
p1_.fluor_cutoff_a AS fluor_cutoff_a_30,
p1_.ct_cutoff_a AS ct_cutoff_a_31,
p1_.led_color_a AS led_color_a_32,
p1_.biomarker_b AS biomarker_b_33,
p1_.analysis_channel_b AS analysis_channel_b_34,
p1_.fluor_cutoff_b AS fluor_cutoff_b_35,
p1_.ct_cutoff_b AS ct_cutoff_b_36,
p1_.led_color_b AS led_color_b_37,
p1_.sensor_gain AS sensor_gain_38,
p1_.sku AS sku_39,
p1_.version AS version_40,
p1_.analysis_init_time AS analysis_init_time_41,
p1_.requires_confirmation AS requires_confirmation_42,
p1_.wait_results AS wait_results_43,
p1_.wait_results_seconds AS wait_results_seconds_44,
p1_.wait_results_retries AS wait_results_retries_45,
p1_.dynamic_analysis AS dynamic_analysis_46,
p1_.instructions AS instructions_47,
p1_.notify_sinave AS notify_sinave_48,
p1_.skip_analysis AS skip_analysis_49,
p1_.step_to_analyze AS step_to_analyze_50,
p1_.heating_led_color AS heating_led_color_51,
p1_.cooling_led_color AS cooling_led_color_52,
a2_.assay_result_id AS assay_result_id_53,
a2_.ct_assay_a AS ct_assay_a_54,
a2_.result_a AS result_a_55,
a2_.predicted_result_a AS predicted_result_a_56,
a2_.biomarker_a AS biomarker_a_57,
a2_.ct_assay_b AS ct_assay_b_58,
a2_.result_b AS result_b_59,
a2_.predicted_result_b AS predicted_result_b_60,
a2_.biomarker_b AS biomarker_b_61,
a2_.created_at AS created_at_62,
a2_.updated_at AS updated_at_63,
a2_.details AS details_64,
a2_.predicted_details AS predicted_details_65,
a2_.health_authority_rx AS health_authority_rx_66,
a2_.result_merged AS result_merged_67,
a2_.result_control AS result_control_68,
a2_.intermediate_results AS intermediate_results_69,
u3_.user_id AS user_id_70,
u3_.email AS email_71,
u3_.password AS password_72,
u3_.reset_password_token AS reset_password_token_73,
u3_.reset_password_expires_at AS reset_password_expires_at_74
FROM
assays a0_
INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id
LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id
LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id
ORDER BY
a0_.created_at DESC
) dctrn_result
) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT assay_id_0 FROM (SELECT a0_.assay_id AS assay_id_0, a0_.device_id AS device_id_1, a0_.sample_id AS sample_id_2, a0_.sample_type_other AS sample_type_other_3, a0_.certificate_result_type AS certificate_result_type_4, a0_.photo_filename AS photo_filename_5, a0_.sinave_result_type AS sinave_result_type_6, a0_.device_latitude AS device_latitude_7, a0_.device_longitude AS device_longitude_8, a0_.batch AS batch_9, a0_.status AS status_10, a0_.expected_entry_count AS expected_entry_count_11, a0_.received_entry_count AS received_entry_count_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.hardware_version AS hardware_version_15, a0_.firmware_version AS firmware_version_16, a0_.software_version AS software_version_17, a0_.device_model AS device_model_18, a0_.device_version AS device_version_19, a0_.internal_control_type AS internal_control_type_20, a0_.internal_control_ref AS internal_control_ref_21, a0_.reporter AS reporter_22, a0_.skip_analysis AS skip_analysis_23, p1_.protocol_id AS protocol_id_24, p1_.temperature AS temperature_25, p1_.assay_duration AS assay_duration_26, p1_.data_interval AS data_interval_27, p1_.biomarker_a AS biomarker_a_28, p1_.analysis_channel_a AS analysis_channel_a_29, p1_.fluor_cutoff_a AS fluor_cutoff_a_30, p1_.ct_cutoff_a AS ct_cutoff_a_31, p1_.led_color_a AS led_color_a_32, p1_.biomarker_b AS biomarker_b_33, p1_.analysis_channel_b AS analysis_channel_b_34, p1_.fluor_cutoff_b AS fluor_cutoff_b_35, p1_.ct_cutoff_b AS ct_cutoff_b_36, p1_.led_color_b AS led_color_b_37, p1_.sensor_gain AS sensor_gain_38, p1_.sku AS sku_39, p1_.version AS version_40, p1_.analysis_init_time AS analysis_init_time_41, p1_.requires_confirmation AS requires_confirmation_42, p1_.wait_results AS wait_results_43, p1_.wait_results_seconds AS wait_results_seconds_44, p1_.wait_results_retries AS wait_results_retries_45, p1_.dynamic_analysis AS dynamic_analysis_46, p1_.instructions AS instructions_47, p1_.notify_sinave AS notify_sinave_48, p1_.skip_analysis AS skip_analysis_49, p1_.step_to_analyze AS step_to_analyze_50, p1_.heating_led_color AS heating_led_color_51, p1_.cooling_led_color AS cooling_led_color_52, a2_.assay_result_id AS assay_result_id_53, a2_.ct_assay_a AS ct_assay_a_54, a2_.result_a AS result_a_55, a2_.predicted_result_a AS predicted_result_a_56, a2_.biomarker_a AS biomarker_a_57, a2_.ct_assay_b AS ct_assay_b_58, a2_.result_b AS result_b_59, a2_.predicted_result_b AS predicted_result_b_60, a2_.biomarker_b AS biomarker_b_61, a2_.created_at AS created_at_62, a2_.updated_at AS updated_at_63, a2_.details AS details_64, a2_.predicted_details AS predicted_details_65, a2_.health_authority_rx AS health_authority_rx_66, a2_.result_merged AS result_merged_67, a2_.result_control AS result_control_68, a2_.intermediate_results AS intermediate_results_69, u3_.user_id AS user_id_70, u3_.email AS email_71, u3_.password AS password_72, u3_.reset_password_token AS reset_password_token_73, u3_.reset_password_expires_at AS reset_password_expires_at_74 FROM assays a0_ INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table;
|
1.46 ms
(0.00%)
|
1 |
SELECT a0_.assay_id AS assay_id_0, a0_.device_id AS device_id_1, a0_.sample_id AS sample_id_2, a0_.sample_type_other AS sample_type_other_3, a0_.certificate_result_type AS certificate_result_type_4, a0_.photo_filename AS photo_filename_5, a0_.sinave_result_type AS sinave_result_type_6, a0_.device_latitude AS device_latitude_7, a0_.device_longitude AS device_longitude_8, a0_.batch AS batch_9, a0_.status AS status_10, a0_.expected_entry_count AS expected_entry_count_11, a0_.received_entry_count AS received_entry_count_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.hardware_version AS hardware_version_15, a0_.firmware_version AS firmware_version_16, a0_.software_version AS software_version_17, a0_.device_model AS device_model_18, a0_.device_version AS device_version_19, a0_.internal_control_type AS internal_control_type_20, a0_.internal_control_ref AS internal_control_ref_21, a0_.reporter AS reporter_22, a0_.skip_analysis AS skip_analysis_23, p1_.protocol_id AS protocol_id_24, p1_.temperature AS temperature_25, p1_.assay_duration AS assay_duration_26, p1_.data_interval AS data_interval_27, p1_.biomarker_a AS biomarker_a_28, p1_.analysis_channel_a AS analysis_channel_a_29, p1_.fluor_cutoff_a AS fluor_cutoff_a_30, p1_.ct_cutoff_a AS ct_cutoff_a_31, p1_.led_color_a AS led_color_a_32, p1_.biomarker_b AS biomarker_b_33, p1_.analysis_channel_b AS analysis_channel_b_34, p1_.fluor_cutoff_b AS fluor_cutoff_b_35, p1_.ct_cutoff_b AS ct_cutoff_b_36, p1_.led_color_b AS led_color_b_37, p1_.sensor_gain AS sensor_gain_38, p1_.sku AS sku_39, p1_.version AS version_40, p1_.analysis_init_time AS analysis_init_time_41, p1_.requires_confirmation AS requires_confirmation_42, p1_.wait_results AS wait_results_43, p1_.wait_results_seconds AS wait_results_seconds_44, p1_.wait_results_retries AS wait_results_retries_45, p1_.dynamic_analysis AS dynamic_analysis_46, p1_.instructions AS instructions_47, p1_.notify_sinave AS notify_sinave_48, p1_.skip_analysis AS skip_analysis_49, p1_.step_to_analyze AS step_to_analyze_50, p1_.heating_led_color AS heating_led_color_51, p1_.cooling_led_color AS cooling_led_color_52, a2_.assay_result_id AS assay_result_id_53, a2_.ct_assay_a AS ct_assay_a_54, a2_.result_a AS result_a_55, a2_.predicted_result_a AS predicted_result_a_56, a2_.biomarker_a AS biomarker_a_57, a2_.ct_assay_b AS ct_assay_b_58, a2_.result_b AS result_b_59, a2_.predicted_result_b AS predicted_result_b_60, a2_.biomarker_b AS biomarker_b_61, a2_.created_at AS created_at_62, a2_.updated_at AS updated_at_63, a2_.details AS details_64, a2_.predicted_details AS predicted_details_65, a2_.health_authority_rx AS health_authority_rx_66, a2_.result_merged AS result_merged_67, a2_.result_control AS result_control_68, a2_.intermediate_results AS intermediate_results_69, u3_.user_id AS user_id_70, u3_.email AS email_71, u3_.password AS password_72, u3_.reset_password_token AS reset_password_token_73, u3_.reset_password_expires_at AS reset_password_expires_at_74, a0_.protocol_id AS protocol_id_75, a0_.user_id AS user_id_76, a0_.sample_type AS sample_type_77, a0_.analysis_method_id AS analysis_method_id_78, p1_.default_analysis_method_id AS default_analysis_method_id_79, p1_.test_id AS test_id_80, p1_.customer_id AS customer_id_81, a2_.assay_id AS assay_id_82 FROM assays a0_ INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id WHERE a0_.assay_id IN (?) ORDER BY a0_.created_at DESC
Parameters: [
[
4305
4304
4303
4302
4301
4300
4299
4298
4297
4296
4295
4294
4293
4292
4291
4290
4289
4288
4287
4286
4285
4284
4283
4282
4281
]
]
SELECT
a0_.assay_id AS assay_id_0,
a0_.device_id AS device_id_1,
a0_.sample_id AS sample_id_2,
a0_.sample_type_other AS sample_type_other_3,
a0_.certificate_result_type AS certificate_result_type_4,
a0_.photo_filename AS photo_filename_5,
a0_.sinave_result_type AS sinave_result_type_6,
a0_.device_latitude AS device_latitude_7,
a0_.device_longitude AS device_longitude_8,
a0_.batch AS batch_9,
a0_.status AS status_10,
a0_.expected_entry_count AS expected_entry_count_11,
a0_.received_entry_count AS received_entry_count_12,
a0_.created_at AS created_at_13,
a0_.updated_at AS updated_at_14,
a0_.hardware_version AS hardware_version_15,
a0_.firmware_version AS firmware_version_16,
a0_.software_version AS software_version_17,
a0_.device_model AS device_model_18,
a0_.device_version AS device_version_19,
a0_.internal_control_type AS internal_control_type_20,
a0_.internal_control_ref AS internal_control_ref_21,
a0_.reporter AS reporter_22,
a0_.skip_analysis AS skip_analysis_23,
p1_.protocol_id AS protocol_id_24,
p1_.temperature AS temperature_25,
p1_.assay_duration AS assay_duration_26,
p1_.data_interval AS data_interval_27,
p1_.biomarker_a AS biomarker_a_28,
p1_.analysis_channel_a AS analysis_channel_a_29,
p1_.fluor_cutoff_a AS fluor_cutoff_a_30,
p1_.ct_cutoff_a AS ct_cutoff_a_31,
p1_.led_color_a AS led_color_a_32,
p1_.biomarker_b AS biomarker_b_33,
p1_.analysis_channel_b AS analysis_channel_b_34,
p1_.fluor_cutoff_b AS fluor_cutoff_b_35,
p1_.ct_cutoff_b AS ct_cutoff_b_36,
p1_.led_color_b AS led_color_b_37,
p1_.sensor_gain AS sensor_gain_38,
p1_.sku AS sku_39,
p1_.version AS version_40,
p1_.analysis_init_time AS analysis_init_time_41,
p1_.requires_confirmation AS requires_confirmation_42,
p1_.wait_results AS wait_results_43,
p1_.wait_results_seconds AS wait_results_seconds_44,
p1_.wait_results_retries AS wait_results_retries_45,
p1_.dynamic_analysis AS dynamic_analysis_46,
p1_.instructions AS instructions_47,
p1_.notify_sinave AS notify_sinave_48,
p1_.skip_analysis AS skip_analysis_49,
p1_.step_to_analyze AS step_to_analyze_50,
p1_.heating_led_color AS heating_led_color_51,
p1_.cooling_led_color AS cooling_led_color_52,
a2_.assay_result_id AS assay_result_id_53,
a2_.ct_assay_a AS ct_assay_a_54,
a2_.result_a AS result_a_55,
a2_.predicted_result_a AS predicted_result_a_56,
a2_.biomarker_a AS biomarker_a_57,
a2_.ct_assay_b AS ct_assay_b_58,
a2_.result_b AS result_b_59,
a2_.predicted_result_b AS predicted_result_b_60,
a2_.biomarker_b AS biomarker_b_61,
a2_.created_at AS created_at_62,
a2_.updated_at AS updated_at_63,
a2_.details AS details_64,
a2_.predicted_details AS predicted_details_65,
a2_.health_authority_rx AS health_authority_rx_66,
a2_.result_merged AS result_merged_67,
a2_.result_control AS result_control_68,
a2_.intermediate_results AS intermediate_results_69,
u3_.user_id AS user_id_70,
u3_.email AS email_71,
u3_.password AS password_72,
u3_.reset_password_token AS reset_password_token_73,
u3_.reset_password_expires_at AS reset_password_expires_at_74,
a0_.protocol_id AS protocol_id_75,
a0_.user_id AS user_id_76,
a0_.sample_type AS sample_type_77,
a0_.analysis_method_id AS analysis_method_id_78,
p1_.default_analysis_method_id AS default_analysis_method_id_79,
p1_.test_id AS test_id_80,
p1_.customer_id AS customer_id_81,
a2_.assay_id AS assay_id_82
FROM
assays a0_
INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id
LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id
LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id
WHERE
a0_.assay_id IN (?)
ORDER BY
a0_.created_at DESC
SELECT a0_.assay_id AS assay_id_0, a0_.device_id AS device_id_1, a0_.sample_id AS sample_id_2, a0_.sample_type_other AS sample_type_other_3, a0_.certificate_result_type AS certificate_result_type_4, a0_.photo_filename AS photo_filename_5, a0_.sinave_result_type AS sinave_result_type_6, a0_.device_latitude AS device_latitude_7, a0_.device_longitude AS device_longitude_8, a0_.batch AS batch_9, a0_.status AS status_10, a0_.expected_entry_count AS expected_entry_count_11, a0_.received_entry_count AS received_entry_count_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.hardware_version AS hardware_version_15, a0_.firmware_version AS firmware_version_16, a0_.software_version AS software_version_17, a0_.device_model AS device_model_18, a0_.device_version AS device_version_19, a0_.internal_control_type AS internal_control_type_20, a0_.internal_control_ref AS internal_control_ref_21, a0_.reporter AS reporter_22, a0_.skip_analysis AS skip_analysis_23, p1_.protocol_id AS protocol_id_24, p1_.temperature AS temperature_25, p1_.assay_duration AS assay_duration_26, p1_.data_interval AS data_interval_27, p1_.biomarker_a AS biomarker_a_28, p1_.analysis_channel_a AS analysis_channel_a_29, p1_.fluor_cutoff_a AS fluor_cutoff_a_30, p1_.ct_cutoff_a AS ct_cutoff_a_31, p1_.led_color_a AS led_color_a_32, p1_.biomarker_b AS biomarker_b_33, p1_.analysis_channel_b AS analysis_channel_b_34, p1_.fluor_cutoff_b AS fluor_cutoff_b_35, p1_.ct_cutoff_b AS ct_cutoff_b_36, p1_.led_color_b AS led_color_b_37, p1_.sensor_gain AS sensor_gain_38, p1_.sku AS sku_39, p1_.version AS version_40, p1_.analysis_init_time AS analysis_init_time_41, p1_.requires_confirmation AS requires_confirmation_42, p1_.wait_results AS wait_results_43, p1_.wait_results_seconds AS wait_results_seconds_44, p1_.wait_results_retries AS wait_results_retries_45, p1_.dynamic_analysis AS dynamic_analysis_46, p1_.instructions AS instructions_47, p1_.notify_sinave AS notify_sinave_48, p1_.skip_analysis AS skip_analysis_49, p1_.step_to_analyze AS step_to_analyze_50, p1_.heating_led_color AS heating_led_color_51, p1_.cooling_led_color AS cooling_led_color_52, a2_.assay_result_id AS assay_result_id_53, a2_.ct_assay_a AS ct_assay_a_54, a2_.result_a AS result_a_55, a2_.predicted_result_a AS predicted_result_a_56, a2_.biomarker_a AS biomarker_a_57, a2_.ct_assay_b AS ct_assay_b_58, a2_.result_b AS result_b_59, a2_.predicted_result_b AS predicted_result_b_60, a2_.biomarker_b AS biomarker_b_61, a2_.created_at AS created_at_62, a2_.updated_at AS updated_at_63, a2_.details AS details_64, a2_.predicted_details AS predicted_details_65, a2_.health_authority_rx AS health_authority_rx_66, a2_.result_merged AS result_merged_67, a2_.result_control AS result_control_68, a2_.intermediate_results AS intermediate_results_69, u3_.user_id AS user_id_70, u3_.email AS email_71, u3_.password AS password_72, u3_.reset_password_token AS reset_password_token_73, u3_.reset_password_expires_at AS reset_password_expires_at_74, a0_.protocol_id AS protocol_id_75, a0_.user_id AS user_id_76, a0_.sample_type AS sample_type_77, a0_.analysis_method_id AS analysis_method_id_78, p1_.default_analysis_method_id AS default_analysis_method_id_79, p1_.test_id AS test_id_80, p1_.customer_id AS customer_id_81, a2_.assay_id AS assay_id_82 FROM assays a0_ INNER JOIN protocols p1_ ON a0_.protocol_id = p1_.protocol_id LEFT JOIN assay_results a2_ ON a0_.assay_id = a2_.assay_id LEFT JOIN users u3_ ON a0_.user_id = u3_.user_id WHERE a0_.assay_id IN (4305, 4304, 4303, 4302, 4301, 4300, 4299, 4298, 4297, 4296, 4295, 4294, 4293, 4292, 4291, 4290, 4289, 4288, 4287, 4286, 4285, 4284, 4283, 4282, 4281) ORDER BY a0_.created_at DESC;
|
0.51 ms
(0.00%)
|
1 |
SELECT t0.test_id AS test_id_1, t0.test_type AS test_type_2, t0.identifier AS identifier_3, t0.certificate_template AS certificate_template_4, t0.use_for_customer_protocols AS use_for_customer_protocols_5, t0.show_in_app_to AS show_in_app_to_6, t0.updated_at AS updated_at_7, t0.position AS position_8, t0.button_icon_name AS button_icon_name_9, t0.button_icon_original_name AS button_icon_original_name_10, t0.button_icon_mime_type AS button_icon_mime_type_11, t0.button_icon_size AS button_icon_size_12, t0.button_icon_dimensions AS button_icon_dimensions_13, t0.background_image_name AS background_image_name_14, t0.background_image_original_name AS background_image_original_name_15, t0.background_image_mime_type AS background_image_mime_type_16, t0.background_image_size AS background_image_size_17, t0.background_image_dimensions AS background_image_dimensions_18 FROM tests t0 WHERE t0.test_id IN (?)
Parameters: [
[
1
5
3
]
]
SELECT t0.test_id AS test_id_1, t0.test_type AS test_type_2, t0.identifier AS identifier_3, t0.certificate_template AS certificate_template_4, t0.use_for_customer_protocols AS use_for_customer_protocols_5, t0.show_in_app_to AS show_in_app_to_6, t0.updated_at AS updated_at_7, t0.position AS position_8, t0.button_icon_name AS button_icon_name_9, t0.button_icon_original_name AS button_icon_original_name_10, t0.button_icon_mime_type AS button_icon_mime_type_11, t0.button_icon_size AS button_icon_size_12, t0.button_icon_dimensions AS button_icon_dimensions_13, t0.background_image_name AS background_image_name_14, t0.background_image_original_name AS background_image_original_name_15, t0.background_image_mime_type AS background_image_mime_type_16, t0.background_image_size AS background_image_size_17, t0.background_image_dimensions AS background_image_dimensions_18 FROM tests t0 WHERE t0.test_id IN (1, 5, 3);
|