Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.description AS description_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.ibcode AS ibcode_8,
  t0.requested_exclusion_participant AS requested_exclusion_participant_9,
  t0.uid AS uid_10,
  t0.research_locations AS research_locations_11,
  t0.keywords AS keywords_12,
  t0.fda_no AS fda_no_13,
  t0.fda_name AS fda_name_14,
  t0.fda_sponsor AS fda_sponsor_15,
  t0.holder AS holder_16,
  t0.ind AS ind_17,
  t0.study_site AS study_site_18,
  t0.submitted_by_id AS submitted_by_id_19,
  t0.report_expectation_period_id AS report_expectation_period_id_20,
  t0.study_population_id AS study_population_id_21,
  t0.ionizing_radiation_use_id AS ionizing_radiation_use_id_22,
  t0.proceedure_use_id AS proceedure_use_id_23,
  t0.multi_site_collaboration_id AS multi_site_collaboration_id_24,
  t0.financial_disclosure_id AS financial_disclosure_id_25,
  t0.review_mode_id AS review_mode_id_26,
  t0.status_id AS status_id_27,
  t0.rexecpart_id AS rexecpart_id_28,
  t0.age_range_id AS age_range_id_29,
  t0.pediatric_cp_id AS pediatric_cp_id_30,
  t0.impaired_cp_id AS impaired_cp_id_31,
  t0.app_type_id AS app_type_id_32,
  t0.study_location_id AS study_location_id_33,
  t0.region_id AS region_id_34
FROM
  application t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.ibcode AS ibcode_8, t0.requested_exclusion_participant AS requested_exclusion_participant_9, t0.uid AS uid_10, t0.research_locations AS research_locations_11, t0.keywords AS keywords_12, t0.fda_no AS fda_no_13, t0.fda_name AS fda_name_14, t0.fda_sponsor AS fda_sponsor_15, t0.holder AS holder_16, t0.ind AS ind_17, t0.study_site AS study_site_18, t0.submitted_by_id AS submitted_by_id_19, t0.report_expectation_period_id AS report_expectation_period_id_20, t0.study_population_id AS study_population_id_21, t0.ionizing_radiation_use_id AS ionizing_radiation_use_id_22, t0.proceedure_use_id AS proceedure_use_id_23, t0.multi_site_collaboration_id AS multi_site_collaboration_id_24, t0.financial_disclosure_id AS financial_disclosure_id_25, t0.review_mode_id AS review_mode_id_26, t0.status_id AS status_id_27, t0.rexecpart_id AS rexecpart_id_28, t0.age_range_id AS age_range_id_29, t0.pediatric_cp_id AS pediatric_cp_id_30, t0.impaired_cp_id AS impaired_cp_id_31, t0.app_type_id AS app_type_id_32, t0.study_location_id AS study_location_id_33, t0.region_id AS region_id_34 FROM application t0;

SELECT
  t0.id AS id_1,
  t0.approved_at AS approved_at_2,
  t0.certificate_code AS certificate_code_3,
  t0.valid_until AS valid_until_4,
  t0.valid_from AS valid_from_5,
  t0.chair_approval AS chair_approval_6,
  t0.vice_approval AS vice_approval_7,
  t0.uid AS uid_8,
  t0.irb_application_id AS irb_application_id_9,
  t0.approved_by_id AS approved_by_id_10,
  t0.th_agenda_id AS th_agenda_id_11,
  t0.meeting_minute_id AS meeting_minute_id_12
FROM
  irb_certificate t0

SELECT t0.id AS id_1, t0.approved_at AS approved_at_2, t0.certificate_code AS certificate_code_3, t0.valid_until AS valid_until_4, t0.valid_from AS valid_from_5, t0.chair_approval AS chair_approval_6, t0.vice_approval AS vice_approval_7, t0.uid AS uid_8, t0.irb_application_id AS irb_application_id_9, t0.approved_by_id AS approved_by_id_10, t0.th_agenda_id AS th_agenda_id_11, t0.meeting_minute_id AS meeting_minute_id_12 FROM irb_certificate t0;

SELECT
  t0.id AS id_1,
  t0.assigned_at AS assigned_at_2,
  t0.status AS status_3,
  t0.role AS role_4,
  t0.bio AS bio_5,
  t0.uid AS uid_6,
  t0.user_id AS user_id_7,
  t0.assigned_by_id AS assigned_by_id_8
FROM
  board_member t0
WHERE
  t0.role = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.assigned_at AS assigned_at_2, t0.status AS status_3, t0.role AS role_4, t0.bio AS bio_5, t0.uid AS uid_6, t0.user_id AS user_id_7, t0.assigned_by_id AS assigned_by_id_8 FROM board_member t0 WHERE t0.role = 'Chair' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.assigned_at AS assigned_at_2,
  t0.status AS status_3,
  t0.role AS role_4,
  t0.bio AS bio_5,
  t0.uid AS uid_6,
  t0.user_id AS user_id_7,
  t0.assigned_by_id AS assigned_by_id_8
FROM
  board_member t0
WHERE
  t0.role = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.assigned_at AS assigned_at_2, t0.status AS status_3, t0.role AS role_4, t0.bio AS bio_5, t0.uid AS uid_6, t0.user_id AS user_id_7, t0.assigned_by_id AS assigned_by_id_8 FROM board_member t0 WHERE t0.role = 'Director' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.assigned_at AS assigned_at_2,
  t0.status AS status_3,
  t0.role AS role_4,
  t0.bio AS bio_5,
  t0.uid AS uid_6,
  t0.user_id AS user_id_7,
  t0.assigned_by_id AS assigned_by_id_8
FROM
  board_member t0
WHERE
  t0.role = ?

SELECT t0.id AS id_1, t0.assigned_at AS assigned_at_2, t0.status AS status_3, t0.role AS role_4, t0.bio AS bio_5, t0.uid AS uid_6, t0.user_id AS user_id_7, t0.assigned_by_id AS assigned_by_id_8 FROM board_member t0 WHERE t0.role = 'Secretary';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  task_type t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM task_type t0 WHERE t0.code = 'REPORT' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.description AS description_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.ibcode AS ibcode_8,
  t0.requested_exclusion_participant AS requested_exclusion_participant_9,
  t0.uid AS uid_10,
  t0.research_locations AS research_locations_11,
  t0.keywords AS keywords_12,
  t0.fda_no AS fda_no_13,
  t0.fda_name AS fda_name_14,
  t0.fda_sponsor AS fda_sponsor_15,
  t0.holder AS holder_16,
  t0.ind AS ind_17,
  t0.study_site AS study_site_18,
  t0.submitted_by_id AS submitted_by_id_19,
  t0.report_expectation_period_id AS report_expectation_period_id_20,
  t0.study_population_id AS study_population_id_21,
  t0.ionizing_radiation_use_id AS ionizing_radiation_use_id_22,
  t0.proceedure_use_id AS proceedure_use_id_23,
  t0.multi_site_collaboration_id AS multi_site_collaboration_id_24,
  t0.financial_disclosure_id AS financial_disclosure_id_25,
  t0.review_mode_id AS review_mode_id_26,
  t0.status_id AS status_id_27,
  t0.rexecpart_id AS rexecpart_id_28,
  t0.age_range_id AS age_range_id_29,
  t0.pediatric_cp_id AS pediatric_cp_id_30,
  t0.impaired_cp_id AS impaired_cp_id_31,
  t0.app_type_id AS app_type_id_32,
  t0.study_location_id AS study_location_id_33,
  t0.region_id AS region_id_34
FROM
  application t0
WHERE
  t0.submitted_by_id IS NULL

SELECT t0.id AS id_1, t0.title AS title_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.ibcode AS ibcode_8, t0.requested_exclusion_participant AS requested_exclusion_participant_9, t0.uid AS uid_10, t0.research_locations AS research_locations_11, t0.keywords AS keywords_12, t0.fda_no AS fda_no_13, t0.fda_name AS fda_name_14, t0.fda_sponsor AS fda_sponsor_15, t0.holder AS holder_16, t0.ind AS ind_17, t0.study_site AS study_site_18, t0.submitted_by_id AS submitted_by_id_19, t0.report_expectation_period_id AS report_expectation_period_id_20, t0.study_population_id AS study_population_id_21, t0.ionizing_radiation_use_id AS ionizing_radiation_use_id_22, t0.proceedure_use_id AS proceedure_use_id_23, t0.multi_site_collaboration_id AS multi_site_collaboration_id_24, t0.financial_disclosure_id AS financial_disclosure_id_25, t0.review_mode_id AS review_mode_id_26, t0.status_id AS status_id_27, t0.rexecpart_id AS rexecpart_id_28, t0.age_range_id AS age_range_id_29, t0.pediatric_cp_id AS pediatric_cp_id_30, t0.impaired_cp_id AS impaired_cp_id_31, t0.app_type_id AS app_type_id_32, t0.study_location_id AS study_location_id_33, t0.region_id AS region_id_34 FROM application t0 WHERE t0.submitted_by_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.tederasian AS tederasian_2,
  t0.tederasian_code AS tederasian_code_3,
  t0.instruction AS instruction_4,
  t0.created_at AS created_at_5,
  t0.active AS active_6
FROM
  instruction t0
WHERE
  t0.tederasian_code = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tederasian AS tederasian_2, t0.tederasian_code AS tederasian_code_3, t0.instruction AS instruction_4, t0.created_at AS created_at_5, t0.active AS active_6 FROM instruction t0 WHERE t0.tederasian_code = 'SUBMISSION' AND t0.active = 1 LIMIT 1;