Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.id = 0x0195A4AA95AA74DC9A2D5459629A9DC6;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.username = 'kfan64' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.d7_nid AS d7_nid_4,
  t0.loaded_from AS loaded_from_5
FROM
  department t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.d7_nid AS d7_nid_4, t0.loaded_from AS loaded_from_5 FROM department t0 WHERE t0.id = '27' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.username = 'xc4' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.serial_num AS serial_num_1,
          e0_.req_admin AS req_admin_2,
          e0_.institution_other AS institution_other_3,
          e0_.institution_country AS institution_country_4,
          e0_.course_subj_code AS course_subj_code_5,
          e0_.course_crse_num AS course_crse_num_6,
          e0_.course_title AS course_title_7,
          e0_.course_term AS course_term_8,
          e0_.course_credit_hrs AS course_credit_hrs_9,
          e0_.course_credit_basis AS course_credit_basis_10,
          e0_.lab_subj_code AS lab_subj_code_11,
          e0_.lab_crse_num AS lab_crse_num_12,
          e0_.lab_title AS lab_title_13,
          e0_.lab_term AS lab_term_14,
          e0_.lab_credit_hrs AS lab_credit_hrs_15,
          e0_.lab_credit_basis AS lab_credit_basis_16,
          e0_.phase AS phase_17,
          e0_.status AS status_18,
          e0_.created AS created_19,
          e0_.updated AS updated_20,
          e0_.draft_equiv1_course AS draft_equiv1_course_21,
          e0_.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_22,
          e0_.draft_equiv1_operator AS draft_equiv1_operator_23,
          e0_.draft_equiv2_course AS draft_equiv2_course_24,
          e0_.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_25,
          e0_.draft_equiv2_operator AS draft_equiv2_operator_26,
          e0_.draft_equiv3_course AS draft_equiv3_course_27,
          e0_.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_28,
          e0_.draft_equiv3_operator AS draft_equiv3_operator_29,
          e0_.draft_equiv4_course AS draft_equiv4_course_30,
          e0_.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_31,
          e0_.draft_policy AS draft_policy_32,
          e0_.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_33,
          e0_.final_equiv1_operator AS final_equiv1_operator_34,
          e0_.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_35,
          e0_.final_equiv2_operator AS final_equiv2_operator_36,
          e0_.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_37,
          e0_.final_equiv3_operator AS final_equiv3_operator_38,
          e0_.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_39,
          e0_.final_policy AS final_policy_40,
          e0_.requester_type AS requester_type_41,
          e0_.course_in_sis AS course_in_sis_42,
          e0_.transcript_on_hand AS transcript_on_hand_43,
          e0_.hold_for_requester_admit AS hold_for_requester_admit_44,
          e0_.hold_for_course_input AS hold_for_course_input_45,
          e0_.hold_for_transcript AS hold_for_transcript_46,
          e0_.tag_spot_articulated AS tag_spot_articulated_47,
          e0_.tag_r1_to_student AS tag_r1_to_student_48,
          e0_.tag_dept_to_student AS tag_dept_to_student_49,
          e0_.tag_dept_to_r1 AS tag_dept_to_r1_50,
          e0_.tag_r2_to_student AS tag_r2_to_student_51,
          e0_.tag_r2_to_dept AS tag_r2_to_dept_52,
          e0_.tag_reassigned AS tag_reassigned_53,
          e0_.d7_nid AS d7_nid_54,
          e0_.d7_uuid AS d7_uuid_55,
          e0_.loaded_from AS loaded_from_56
        FROM
          evaluation e0_
          LEFT JOIN user u1_ ON e0_.assignee_id = u1_.id
        WHERE
          e0_.status = ?
          AND u1_.username = ?
        ORDER BY
          e0_.updated DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.serial_num AS serial_num_1, e0_.req_admin AS req_admin_2, e0_.institution_other AS institution_other_3, e0_.institution_country AS institution_country_4, e0_.course_subj_code AS course_subj_code_5, e0_.course_crse_num AS course_crse_num_6, e0_.course_title AS course_title_7, e0_.course_term AS course_term_8, e0_.course_credit_hrs AS course_credit_hrs_9, e0_.course_credit_basis AS course_credit_basis_10, e0_.lab_subj_code AS lab_subj_code_11, e0_.lab_crse_num AS lab_crse_num_12, e0_.lab_title AS lab_title_13, e0_.lab_term AS lab_term_14, e0_.lab_credit_hrs AS lab_credit_hrs_15, e0_.lab_credit_basis AS lab_credit_basis_16, e0_.phase AS phase_17, e0_.status AS status_18, e0_.created AS created_19, e0_.updated AS updated_20, e0_.draft_equiv1_course AS draft_equiv1_course_21, e0_.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_22, e0_.draft_equiv1_operator AS draft_equiv1_operator_23, e0_.draft_equiv2_course AS draft_equiv2_course_24, e0_.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_25, e0_.draft_equiv2_operator AS draft_equiv2_operator_26, e0_.draft_equiv3_course AS draft_equiv3_course_27, e0_.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_28, e0_.draft_equiv3_operator AS draft_equiv3_operator_29, e0_.draft_equiv4_course AS draft_equiv4_course_30, e0_.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_31, e0_.draft_policy AS draft_policy_32, e0_.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_33, e0_.final_equiv1_operator AS final_equiv1_operator_34, e0_.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_35, e0_.final_equiv2_operator AS final_equiv2_operator_36, e0_.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_37, e0_.final_equiv3_operator AS final_equiv3_operator_38, e0_.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_39, e0_.final_policy AS final_policy_40, e0_.requester_type AS requester_type_41, e0_.course_in_sis AS course_in_sis_42, e0_.transcript_on_hand AS transcript_on_hand_43, e0_.hold_for_requester_admit AS hold_for_requester_admit_44, e0_.hold_for_course_input AS hold_for_course_input_45, e0_.hold_for_transcript AS hold_for_transcript_46, e0_.tag_spot_articulated AS tag_spot_articulated_47, e0_.tag_r1_to_student AS tag_r1_to_student_48, e0_.tag_dept_to_student AS tag_dept_to_student_49, e0_.tag_dept_to_r1 AS tag_dept_to_r1_50, e0_.tag_r2_to_student AS tag_r2_to_student_51, e0_.tag_r2_to_dept AS tag_r2_to_dept_52, e0_.tag_reassigned AS tag_reassigned_53, e0_.d7_nid AS d7_nid_54, e0_.d7_uuid AS d7_uuid_55, e0_.loaded_from AS loaded_from_56 FROM evaluation e0_ LEFT JOIN user u1_ ON e0_.assignee_id = u1_.id WHERE e0_.status = 1 AND u1_.username = 'xc4' ORDER BY e0_.updated DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      updated_20
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.serial_num AS serial_num_1,
          e0_.req_admin AS req_admin_2,
          e0_.institution_other AS institution_other_3,
          e0_.institution_country AS institution_country_4,
          e0_.course_subj_code AS course_subj_code_5,
          e0_.course_crse_num AS course_crse_num_6,
          e0_.course_title AS course_title_7,
          e0_.course_term AS course_term_8,
          e0_.course_credit_hrs AS course_credit_hrs_9,
          e0_.course_credit_basis AS course_credit_basis_10,
          e0_.lab_subj_code AS lab_subj_code_11,
          e0_.lab_crse_num AS lab_crse_num_12,
          e0_.lab_title AS lab_title_13,
          e0_.lab_term AS lab_term_14,
          e0_.lab_credit_hrs AS lab_credit_hrs_15,
          e0_.lab_credit_basis AS lab_credit_basis_16,
          e0_.phase AS phase_17,
          e0_.status AS status_18,
          e0_.created AS created_19,
          e0_.updated AS updated_20,
          e0_.draft_equiv1_course AS draft_equiv1_course_21,
          e0_.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_22,
          e0_.draft_equiv1_operator AS draft_equiv1_operator_23,
          e0_.draft_equiv2_course AS draft_equiv2_course_24,
          e0_.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_25,
          e0_.draft_equiv2_operator AS draft_equiv2_operator_26,
          e0_.draft_equiv3_course AS draft_equiv3_course_27,
          e0_.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_28,
          e0_.draft_equiv3_operator AS draft_equiv3_operator_29,
          e0_.draft_equiv4_course AS draft_equiv4_course_30,
          e0_.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_31,
          e0_.draft_policy AS draft_policy_32,
          e0_.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_33,
          e0_.final_equiv1_operator AS final_equiv1_operator_34,
          e0_.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_35,
          e0_.final_equiv2_operator AS final_equiv2_operator_36,
          e0_.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_37,
          e0_.final_equiv3_operator AS final_equiv3_operator_38,
          e0_.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_39,
          e0_.final_policy AS final_policy_40,
          e0_.requester_type AS requester_type_41,
          e0_.course_in_sis AS course_in_sis_42,
          e0_.transcript_on_hand AS transcript_on_hand_43,
          e0_.hold_for_requester_admit AS hold_for_requester_admit_44,
          e0_.hold_for_course_input AS hold_for_course_input_45,
          e0_.hold_for_transcript AS hold_for_transcript_46,
          e0_.tag_spot_articulated AS tag_spot_articulated_47,
          e0_.tag_r1_to_student AS tag_r1_to_student_48,
          e0_.tag_dept_to_student AS tag_dept_to_student_49,
          e0_.tag_dept_to_r1 AS tag_dept_to_r1_50,
          e0_.tag_r2_to_student AS tag_r2_to_student_51,
          e0_.tag_r2_to_dept AS tag_r2_to_dept_52,
          e0_.tag_reassigned AS tag_reassigned_53,
          e0_.d7_nid AS d7_nid_54,
          e0_.d7_uuid AS d7_uuid_55,
          e0_.loaded_from AS loaded_from_56,
          u1_.id AS id_57,
          u1_.username AS username_58,
          u1_.org_id AS org_id_59,
          u1_.display_name AS display_name_60,
          u1_.email AS email_61,
          u1_.category AS category_62,
          u1_.status AS status_63,
          u1_.frozen AS frozen_64,
          u1_.loaded_from AS loaded_from_65,
          u1_.created AS created_66,
          u1_.updated AS updated_67,
          u1_.roles AS roles_68,
          u1_.d7_uid AS d7_uid_69
        FROM
          evaluation e0_
          LEFT JOIN user u1_ ON e0_.assignee_id = u1_.id
        WHERE
          e0_.status = ?
          AND u1_.username = ?
      ) dctrn_result_inner
    ORDER BY
      updated_20 DESC
  ) dctrn_result
LIMIT
  30 OFFSET 1200

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_20 FROM (SELECT e0_.id AS id_0, e0_.serial_num AS serial_num_1, e0_.req_admin AS req_admin_2, e0_.institution_other AS institution_other_3, e0_.institution_country AS institution_country_4, e0_.course_subj_code AS course_subj_code_5, e0_.course_crse_num AS course_crse_num_6, e0_.course_title AS course_title_7, e0_.course_term AS course_term_8, e0_.course_credit_hrs AS course_credit_hrs_9, e0_.course_credit_basis AS course_credit_basis_10, e0_.lab_subj_code AS lab_subj_code_11, e0_.lab_crse_num AS lab_crse_num_12, e0_.lab_title AS lab_title_13, e0_.lab_term AS lab_term_14, e0_.lab_credit_hrs AS lab_credit_hrs_15, e0_.lab_credit_basis AS lab_credit_basis_16, e0_.phase AS phase_17, e0_.status AS status_18, e0_.created AS created_19, e0_.updated AS updated_20, e0_.draft_equiv1_course AS draft_equiv1_course_21, e0_.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_22, e0_.draft_equiv1_operator AS draft_equiv1_operator_23, e0_.draft_equiv2_course AS draft_equiv2_course_24, e0_.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_25, e0_.draft_equiv2_operator AS draft_equiv2_operator_26, e0_.draft_equiv3_course AS draft_equiv3_course_27, e0_.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_28, e0_.draft_equiv3_operator AS draft_equiv3_operator_29, e0_.draft_equiv4_course AS draft_equiv4_course_30, e0_.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_31, e0_.draft_policy AS draft_policy_32, e0_.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_33, e0_.final_equiv1_operator AS final_equiv1_operator_34, e0_.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_35, e0_.final_equiv2_operator AS final_equiv2_operator_36, e0_.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_37, e0_.final_equiv3_operator AS final_equiv3_operator_38, e0_.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_39, e0_.final_policy AS final_policy_40, e0_.requester_type AS requester_type_41, e0_.course_in_sis AS course_in_sis_42, e0_.transcript_on_hand AS transcript_on_hand_43, e0_.hold_for_requester_admit AS hold_for_requester_admit_44, e0_.hold_for_course_input AS hold_for_course_input_45, e0_.hold_for_transcript AS hold_for_transcript_46, e0_.tag_spot_articulated AS tag_spot_articulated_47, e0_.tag_r1_to_student AS tag_r1_to_student_48, e0_.tag_dept_to_student AS tag_dept_to_student_49, e0_.tag_dept_to_r1 AS tag_dept_to_r1_50, e0_.tag_r2_to_student AS tag_r2_to_student_51, e0_.tag_r2_to_dept AS tag_r2_to_dept_52, e0_.tag_reassigned AS tag_reassigned_53, e0_.d7_nid AS d7_nid_54, e0_.d7_uuid AS d7_uuid_55, e0_.loaded_from AS loaded_from_56, u1_.id AS id_57, u1_.username AS username_58, u1_.org_id AS org_id_59, u1_.display_name AS display_name_60, u1_.email AS email_61, u1_.category AS category_62, u1_.status AS status_63, u1_.frozen AS frozen_64, u1_.loaded_from AS loaded_from_65, u1_.created AS created_66, u1_.updated AS updated_67, u1_.roles AS roles_68, u1_.d7_uid AS d7_uid_69 FROM evaluation e0_ LEFT JOIN user u1_ ON e0_.assignee_id = u1_.id WHERE e0_.status = 1 AND u1_.username = 'xc4') dctrn_result_inner ORDER BY updated_20 DESC) dctrn_result LIMIT 30 OFFSET 1200;

SELECT
  e0_.id AS id_0,
  e0_.serial_num AS serial_num_1,
  e0_.req_admin AS req_admin_2,
  e0_.institution_other AS institution_other_3,
  e0_.institution_country AS institution_country_4,
  e0_.course_subj_code AS course_subj_code_5,
  e0_.course_crse_num AS course_crse_num_6,
  e0_.course_title AS course_title_7,
  e0_.course_term AS course_term_8,
  e0_.course_credit_hrs AS course_credit_hrs_9,
  e0_.course_credit_basis AS course_credit_basis_10,
  e0_.lab_subj_code AS lab_subj_code_11,
  e0_.lab_crse_num AS lab_crse_num_12,
  e0_.lab_title AS lab_title_13,
  e0_.lab_term AS lab_term_14,
  e0_.lab_credit_hrs AS lab_credit_hrs_15,
  e0_.lab_credit_basis AS lab_credit_basis_16,
  e0_.phase AS phase_17,
  e0_.status AS status_18,
  e0_.created AS created_19,
  e0_.updated AS updated_20,
  e0_.draft_equiv1_course AS draft_equiv1_course_21,
  e0_.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_22,
  e0_.draft_equiv1_operator AS draft_equiv1_operator_23,
  e0_.draft_equiv2_course AS draft_equiv2_course_24,
  e0_.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_25,
  e0_.draft_equiv2_operator AS draft_equiv2_operator_26,
  e0_.draft_equiv3_course AS draft_equiv3_course_27,
  e0_.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_28,
  e0_.draft_equiv3_operator AS draft_equiv3_operator_29,
  e0_.draft_equiv4_course AS draft_equiv4_course_30,
  e0_.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_31,
  e0_.draft_policy AS draft_policy_32,
  e0_.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_33,
  e0_.final_equiv1_operator AS final_equiv1_operator_34,
  e0_.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_35,
  e0_.final_equiv2_operator AS final_equiv2_operator_36,
  e0_.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_37,
  e0_.final_equiv3_operator AS final_equiv3_operator_38,
  e0_.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_39,
  e0_.final_policy AS final_policy_40,
  e0_.requester_type AS requester_type_41,
  e0_.course_in_sis AS course_in_sis_42,
  e0_.transcript_on_hand AS transcript_on_hand_43,
  e0_.hold_for_requester_admit AS hold_for_requester_admit_44,
  e0_.hold_for_course_input AS hold_for_course_input_45,
  e0_.hold_for_transcript AS hold_for_transcript_46,
  e0_.tag_spot_articulated AS tag_spot_articulated_47,
  e0_.tag_r1_to_student AS tag_r1_to_student_48,
  e0_.tag_dept_to_student AS tag_dept_to_student_49,
  e0_.tag_dept_to_r1 AS tag_dept_to_r1_50,
  e0_.tag_r2_to_student AS tag_r2_to_student_51,
  e0_.tag_r2_to_dept AS tag_r2_to_dept_52,
  e0_.tag_reassigned AS tag_reassigned_53,
  e0_.d7_nid AS d7_nid_54,
  e0_.d7_uuid AS d7_uuid_55,
  e0_.loaded_from AS loaded_from_56,
  e0_.requester_id AS requester_id_57,
  e0_.institution_id AS institution_id_58,
  e0_.assignee_id AS assignee_id_59,
  e0_.final_equiv1_course_id AS final_equiv1_course_id_60,
  e0_.final_equiv2_course_id AS final_equiv2_course_id_61,
  e0_.final_equiv3_course_id AS final_equiv3_course_id_62,
  e0_.final_equiv4_course_id AS final_equiv4_course_id_63
FROM
  evaluation e0_
  LEFT JOIN user u1_ ON e0_.assignee_id = u1_.id
WHERE
  e0_.status = ?
  AND u1_.username = ?
  AND e0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  e0_.updated DESC

SELECT e0_.id AS id_0, e0_.serial_num AS serial_num_1, e0_.req_admin AS req_admin_2, e0_.institution_other AS institution_other_3, e0_.institution_country AS institution_country_4, e0_.course_subj_code AS course_subj_code_5, e0_.course_crse_num AS course_crse_num_6, e0_.course_title AS course_title_7, e0_.course_term AS course_term_8, e0_.course_credit_hrs AS course_credit_hrs_9, e0_.course_credit_basis AS course_credit_basis_10, e0_.lab_subj_code AS lab_subj_code_11, e0_.lab_crse_num AS lab_crse_num_12, e0_.lab_title AS lab_title_13, e0_.lab_term AS lab_term_14, e0_.lab_credit_hrs AS lab_credit_hrs_15, e0_.lab_credit_basis AS lab_credit_basis_16, e0_.phase AS phase_17, e0_.status AS status_18, e0_.created AS created_19, e0_.updated AS updated_20, e0_.draft_equiv1_course AS draft_equiv1_course_21, e0_.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_22, e0_.draft_equiv1_operator AS draft_equiv1_operator_23, e0_.draft_equiv2_course AS draft_equiv2_course_24, e0_.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_25, e0_.draft_equiv2_operator AS draft_equiv2_operator_26, e0_.draft_equiv3_course AS draft_equiv3_course_27, e0_.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_28, e0_.draft_equiv3_operator AS draft_equiv3_operator_29, e0_.draft_equiv4_course AS draft_equiv4_course_30, e0_.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_31, e0_.draft_policy AS draft_policy_32, e0_.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_33, e0_.final_equiv1_operator AS final_equiv1_operator_34, e0_.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_35, e0_.final_equiv2_operator AS final_equiv2_operator_36, e0_.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_37, e0_.final_equiv3_operator AS final_equiv3_operator_38, e0_.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_39, e0_.final_policy AS final_policy_40, e0_.requester_type AS requester_type_41, e0_.course_in_sis AS course_in_sis_42, e0_.transcript_on_hand AS transcript_on_hand_43, e0_.hold_for_requester_admit AS hold_for_requester_admit_44, e0_.hold_for_course_input AS hold_for_course_input_45, e0_.hold_for_transcript AS hold_for_transcript_46, e0_.tag_spot_articulated AS tag_spot_articulated_47, e0_.tag_r1_to_student AS tag_r1_to_student_48, e0_.tag_dept_to_student AS tag_dept_to_student_49, e0_.tag_dept_to_r1 AS tag_dept_to_r1_50, e0_.tag_r2_to_student AS tag_r2_to_student_51, e0_.tag_r2_to_dept AS tag_r2_to_dept_52, e0_.tag_reassigned AS tag_reassigned_53, e0_.d7_nid AS d7_nid_54, e0_.d7_uuid AS d7_uuid_55, e0_.loaded_from AS loaded_from_56, e0_.requester_id AS requester_id_57, e0_.institution_id AS institution_id_58, e0_.assignee_id AS assignee_id_59, e0_.final_equiv1_course_id AS final_equiv1_course_id_60, e0_.final_equiv2_course_id AS final_equiv2_course_id_61, e0_.final_equiv3_course_id AS final_equiv3_course_id_62, e0_.final_equiv4_course_id AS final_equiv4_course_id_63 FROM evaluation e0_ LEFT JOIN user u1_ ON e0_.assignee_id = u1_.id WHERE e0_.status = 1 AND u1_.username = 'xc4' AND e0_.id IN (59566, 55569, 59701, 59367, 59729, 59658, 59531, 59688, 59623, 59653, 59668, 59636, 59165, 59433, 59518, 59431, 59428, 59430, 59393, 59327, 59275, 59317, 59271, 59258, 59247, 59412, 59223, 59208, 59198, 59173) ORDER BY e0_.updated DESC;

SELECT
  t0.id AS id_1,
  t0.dapip_id AS dapip_id_2,
  t0.usg_id AS usg_id_3,
  t0.name AS name_4,
  t0.state AS state_5,
  t0.address AS address_6,
  t0.status AS status_7,
  t0.d7_nid AS d7_nid_8,
  t0.loaded_from AS loaded_from_9
FROM
  institution t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.dapip_id AS dapip_id_2, t0.usg_id AS usg_id_3, t0.name AS name_4, t0.state AS state_5, t0.address AS address_6, t0.status AS status_7, t0.d7_nid AS d7_nid_8, t0.loaded_from AS loaded_from_9 FROM institution t0 WHERE t0.id = 1484;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.id = 0x018D32885D127D17A7079C5AC0821A20;

SELECT
  t0.id AS id_1,
  t0.dapip_id AS dapip_id_2,
  t0.usg_id AS usg_id_3,
  t0.name AS name_4,
  t0.state AS state_5,
  t0.address AS address_6,
  t0.status AS status_7,
  t0.d7_nid AS d7_nid_8,
  t0.loaded_from AS loaded_from_9
FROM
  institution t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.dapip_id AS dapip_id_2, t0.usg_id AS usg_id_3, t0.name AS name_4, t0.state AS state_5, t0.address AS address_6, t0.status AS status_7, t0.d7_nid AS d7_nid_8, t0.loaded_from AS loaded_from_9 FROM institution t0 WHERE t0.id = 3183;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.id = 0x018D3287C8D57603B7C4624172204DB8;