Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.lecture_id AS lecture_id_6,
  t0.EvaluationTemplate_id AS EvaluationTemplate_id_7
FROM
  evaluation t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.lecture_id AS lecture_id_6, t0.EvaluationTemplate_id AS EvaluationTemplate_id_7 FROM evaluation t0 WHERE t0.lecture_id = 7660;

SELECT
  t1.id AS id_2,
  t1.title AS title_3,
  t1.description AS description_4,
  t1.location AS location_5,
  t1.notes AS notes_6,
  t1.start AS start_7,
  t1.duration AS duration_8,
  t1.public AS public_9,
  t1.created AS created_10,
  t1.created_by AS created_by_11,
  t1.updated AS updated_12,
  t1.updated_by AS updated_by_13,
  t0.objectives AS objectives_14,
  t0.grandrounds AS grandrounds_15,
  t0.financial_interest AS financial_interest_16,
  t0.attendance_flag AS attendance_flag_17,
  t0.video_url AS video_url_18,
  t0.video_url_livestream AS video_url_livestream_19,
  t0.audience_faculty AS audience_faculty_20,
  t0.audience_resident AS audience_resident_21,
  t0.audience_student AS audience_student_22,
  t0.attendance_required AS attendance_required_23,
  t0.credit_time AS credit_time_24,
  t0.faculty_extra AS faculty_extra_25,
  t1.event_location_id AS event_location_id_26,
  t0.conference_id AS conference_id_27,
  t0.category_id AS category_id_28,
  t1.dtype
FROM
  lecture t0
  INNER JOIN event t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.title AS title_3, t1.description AS description_4, t1.location AS location_5, t1.notes AS notes_6, t1.start AS start_7, t1.duration AS duration_8, t1.public AS public_9, t1.created AS created_10, t1.created_by AS created_by_11, t1.updated AS updated_12, t1.updated_by AS updated_by_13, t0.objectives AS objectives_14, t0.grandrounds AS grandrounds_15, t0.financial_interest AS financial_interest_16, t0.attendance_flag AS attendance_flag_17, t0.video_url AS video_url_18, t0.video_url_livestream AS video_url_livestream_19, t0.audience_faculty AS audience_faculty_20, t0.audience_resident AS audience_resident_21, t0.audience_student AS audience_student_22, t0.attendance_required AS attendance_required_23, t0.credit_time AS credit_time_24, t0.faculty_extra AS faculty_extra_25, t1.event_location_id AS event_location_id_26, t0.conference_id AS conference_id_27, t0.category_id AS category_id_28, t1.dtype FROM lecture t0 INNER JOIN event t1 ON t0.id = t1.id WHERE t1.id = 7660;

SELECT
  t1.id AS id_2,
  t1.title AS title_3,
  t1.description AS description_4,
  t1.location AS location_5,
  t1.notes AS notes_6,
  t1.start AS start_7,
  t1.duration AS duration_8,
  t1.public AS public_9,
  t1.created AS created_10,
  t1.created_by AS created_by_11,
  t1.updated AS updated_12,
  t1.updated_by AS updated_by_13,
  t0.objectives AS objectives_14,
  t0.grandrounds AS grandrounds_15,
  t0.financial_interest AS financial_interest_16,
  t0.attendance_flag AS attendance_flag_17,
  t0.video_url AS video_url_18,
  t0.video_url_livestream AS video_url_livestream_19,
  t0.audience_faculty AS audience_faculty_20,
  t0.audience_resident AS audience_resident_21,
  t0.audience_student AS audience_student_22,
  t0.attendance_required AS attendance_required_23,
  t0.credit_time AS credit_time_24,
  t0.faculty_extra AS faculty_extra_25,
  t1.event_location_id AS event_location_id_26,
  t0.conference_id AS conference_id_27,
  t0.category_id AS category_id_28,
  t1.dtype
FROM
  lecture t0
  INNER JOIN event t1 ON t0.id = t1.id
WHERE
  t0.conference_id = ?
ORDER BY
  t1.start ASC

SELECT t1.id AS id_2, t1.title AS title_3, t1.description AS description_4, t1.location AS location_5, t1.notes AS notes_6, t1.start AS start_7, t1.duration AS duration_8, t1.public AS public_9, t1.created AS created_10, t1.created_by AS created_by_11, t1.updated AS updated_12, t1.updated_by AS updated_by_13, t0.objectives AS objectives_14, t0.grandrounds AS grandrounds_15, t0.financial_interest AS financial_interest_16, t0.attendance_flag AS attendance_flag_17, t0.video_url AS video_url_18, t0.video_url_livestream AS video_url_livestream_19, t0.audience_faculty AS audience_faculty_20, t0.audience_resident AS audience_resident_21, t0.audience_student AS audience_student_22, t0.attendance_required AS attendance_required_23, t0.credit_time AS credit_time_24, t0.faculty_extra AS faculty_extra_25, t1.event_location_id AS event_location_id_26, t0.conference_id AS conference_id_27, t0.category_id AS category_id_28, t1.dtype FROM lecture t0 INNER JOIN event t1 ON t0.id = t1.id WHERE t0.conference_id = 7657 ORDER BY t1.start ASC;

SELECT
  t0.emp_index AS emp_index_1,
  t0.emp_lastname AS emp_lastname_2,
  t0.emp_firstname AS emp_firstname_3,
  t0.emp_middlename AS emp_middlename_4,
  t0.emp_gender AS emp_gender_5,
  t0.emp_start_date AS emp_start_date_6,
  t0.emp_suffix AS emp_suffix_7,
  t0.emp_timestamp_initial AS emp_timestamp_initial_8,
  t0.emp_timestamp_update AS emp_timestamp_update_9,
  t0.emp_ftpt AS emp_ftpt_10,
  t0.emp_show_profile AS emp_show_profile_11,
  t0.emp_disable AS emp_disable_12,
  t0.emp_grad_residency AS emp_grad_residency_13,
  t0.emp_profile_update_flag AS emp_profile_update_flag_14,
  t0.emp_chief AS emp_chief_15,
  t0.emp_program_director AS emp_program_director_16,
  t0.emp_network_provider AS emp_network_provider_17,
  t0.emp_pending_forms AS emp_pending_forms_18,
  t0.emp_emerg_name AS emp_emerg_name_19,
  t0.emp_emerg_phone AS emp_emerg_phone_20,
  t0.emp_emerg_relationship AS emp_emerg_relationship_21,
  t0.emp_birthdate AS emp_birthdate_22,
  t0.emp_birthplace AS emp_birthplace_23,
  t0.emp_ssn AS emp_ssn_24,
  t0.emp_race AS emp_race_25,
  t0.emp_citizenship_index AS emp_citizenship_index_26,
  t0.emp_ethnicity AS emp_ethnicity_27,
  t0.emp_email_primary_index AS emp_email_primary_index_28,
  t0.emp_spouse_name AS emp_spouse_name_29,
  t0.faculty_auto_exempt AS faculty_auto_exempt_30,
  t0.bamboo_id AS bamboo_id_31,
  t0.npi AS npi_32,
  t0.umms_ad_username AS umms_ad_username_33,
  t34.user_index AS user_index_35,
  t34.emp_index AS emp_index_36,
  t34.username AS username_37,
  t34.ad_guid AS ad_guid_38,
  t34.password_hash AS password_hash_39,
  t34.reset_token AS reset_token_40,
  t34.reset_timestamp AS reset_timestamp_41,
  t34.reset_count AS reset_count_42,
  t34.account_update AS account_update_43,
  t34.activation_token AS activation_token_44,
  t34.activation_timestamp AS activation_timestamp_45,
  t34.activation_count AS activation_count_46,
  t34.invitation_token AS invitation_token_47,
  t34.invitation_timestamp AS invitation_timestamp_48,
  t34.invitation_count AS invitation_count_49,
  t34.timestamp AS timestamp_50,
  t34.roles AS roles_51,
  t34.emp_index AS emp_index_52,
  t0.emp_email_primary_index AS emp_email_primary_index_53,
  t0.emp_citizenship_index AS emp_citizenship_index_54,
  t0.emp_gender AS emp_gender_55
FROM
  employee t0
  LEFT JOIN users t34 ON t34.emp_index = t0.emp_index
WHERE
  t0.emp_index = ?

SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = 107;

SELECT
  t1.id AS id_2,
  t1.title AS title_3,
  t1.description AS description_4,
  t1.location AS location_5,
  t1.notes AS notes_6,
  t1.start AS start_7,
  t1.duration AS duration_8,
  t1.public AS public_9,
  t1.created AS created_10,
  t1.created_by AS created_by_11,
  t1.updated AS updated_12,
  t1.updated_by AS updated_by_13,
  t0.active AS active_14,
  t1.event_location_id AS event_location_id_15,
  t1.dtype
FROM
  conference t0
  INNER JOIN event t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.title AS title_3, t1.description AS description_4, t1.location AS location_5, t1.notes AS notes_6, t1.start AS start_7, t1.duration AS duration_8, t1.public AS public_9, t1.created AS created_10, t1.created_by AS created_by_11, t1.updated AS updated_12, t1.updated_by AS updated_by_13, t0.active AS active_14, t1.event_location_id AS event_location_id_15, t1.dtype FROM conference t0 INNER JOIN event t1 ON t0.id = t1.id WHERE t1.id = 7657;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_by AS created_by_3,
  t0.updated AS updated_4,
  t0.updated_by AS updated_by_5,
  t0.file_name AS file_name_6,
  t0.file_original_name AS file_original_name_7,
  t0.file_mime_type AS file_mime_type_8,
  t0.file_size AS file_size_9,
  t0.file_dimensions AS file_dimensions_10,
  t0.event_id AS event_id_11
FROM
  event_file t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_by AS created_by_3, t0.updated AS updated_4, t0.updated_by AS updated_by_5, t0.file_name AS file_name_6, t0.file_original_name AS file_original_name_7, t0.file_mime_type AS file_mime_type_8, t0.file_size AS file_size_9, t0.file_dimensions AS file_dimensions_10, t0.event_id AS event_id_11 FROM event_file t0 WHERE t0.event_id = 7660;

SELECT
  t0.emp_photo_index AS emp_photo_index_1,
  t0.emp_photo_employee AS emp_photo_employee_2,
  t0.emp_photo_name AS emp_photo_name_3,
  t0.timestamp AS timestamp_4,
  t0.emp_photo_employee AS emp_photo_employee_5
FROM
  emp_photo t0
WHERE
  t0.emp_photo_employee = ?

SELECT t0.emp_photo_index AS emp_photo_index_1, t0.emp_photo_employee AS emp_photo_employee_2, t0.emp_photo_name AS emp_photo_name_3, t0.timestamp AS timestamp_4, t0.emp_photo_employee AS emp_photo_employee_5 FROM emp_photo t0 WHERE t0.emp_photo_employee = 107;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.institution AS institution_3,
  t0.lecture_id AS lecture_id_4,
  t0.employee_id AS employee_id_5
FROM
  lecture_speaker t0
WHERE
  t0.lecture_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.institution AS institution_3, t0.lecture_id AS lecture_id_4, t0.employee_id AS employee_id_5 FROM lecture_speaker t0 WHERE t0.lecture_id = 7660;

SELECT
  t0.emp_title_index AS emp_title_index_1,
  t0.emp_index AS emp_index_2,
  t0.title_type_index AS title_type_index_3,
  t0.title_subtype_index AS title_subtype_index_4,
  t0.emp_title_other AS emp_title_other_5,
  t0.timestamp AS timestamp_6,
  t0.emp_index AS emp_index_7,
  t0.title_type_index AS title_type_index_8,
  t0.title_subtype_index AS title_subtype_index_9
FROM
  emp_title t0
WHERE
  t0.emp_index = ?

SELECT t0.emp_title_index AS emp_title_index_1, t0.emp_index AS emp_index_2, t0.title_type_index AS title_type_index_3, t0.title_subtype_index AS title_subtype_index_4, t0.emp_title_other AS emp_title_other_5, t0.timestamp AS timestamp_6, t0.emp_index AS emp_index_7, t0.title_type_index AS title_type_index_8, t0.title_subtype_index AS title_subtype_index_9 FROM emp_title t0 WHERE t0.emp_index = 107;

SELECT
  t0.title_subtype_index AS title_subtype_index_1,
  t0.title_type_index AS title_type_index_2,
  t0.title_subtype_name AS title_subtype_name_3,
  t0.title_subtype_sortorder AS title_subtype_sortorder_4,
  t0.title_subtype_icon AS title_subtype_icon_5,
  t0.title_subtype_acronym AS title_subtype_acronym_6,
  t0.title_type_index AS title_type_index_7
FROM
  title_subtype t0
WHERE
  t0.title_subtype_index = ?

SELECT t0.title_subtype_index AS title_subtype_index_1, t0.title_type_index AS title_type_index_2, t0.title_subtype_name AS title_subtype_name_3, t0.title_subtype_sortorder AS title_subtype_sortorder_4, t0.title_subtype_icon AS title_subtype_icon_5, t0.title_subtype_acronym AS title_subtype_acronym_6, t0.title_type_index AS title_type_index_7 FROM title_subtype t0 WHERE t0.title_subtype_index = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3
FROM
  lecture_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM lecture_category t0 WHERE t0.id = 64;