Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 28
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

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.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.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

[
  "Chair"
]

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

[
  "Director"
]

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 = ?

[
  "Secretary"
]

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

[
  "REPORT"
]

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;