https://api.dev.pocket.doctorvida.com/admin/assays

302 Redirect from
POST @app_backoffice_security_index (c12e6a)
Method
GET
HTTP Status
200
IP
213.141.7.214
Profiled on
Token
500718

Query Metrics

4 Database Queries
4 Different statements
15.48 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 7.48 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 1.46 ms 
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
  ]
]
View formatted query    View runnable query    Explain query
3 0.51 ms 
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
  ]
]
View formatted query    View runnable query    Explain query
4 6.04 ms 
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
Parameters: 
[]
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\Assay\Assay No errors.
App\Entity\Assay\Protocol No errors.
App\Entity\Assay\AssayResult No errors.
App\Entity\User\User No errors.
App\Entity\Assay\SampleType No errors.
App\Entity\Assay\AnalysisMethod No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Assay\Test No errors.
App\Entity\Customer\Customer No errors.
App\Entity\Assay\AssayData No errors.
App\Entity\Assay\ProtocolSampleType No errors.
App\Entity\Assay\TestTranslation No errors.