| 1 |
0.77 ms |
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 = ?
Parameters: [
b"\x01òñ¬ò¬t▄Ü-TYbÜØã"
]
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;
|
| 2 |
0.53 ms |
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;
|
| 3 |
0.55 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.subject_code AS subject_code_3, t0.course_number AS course_number_4, t0.status AS status_5, t0.d7_nid AS d7_nid_6, t0.loaded_from AS loaded_from_7 FROM course t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.subject_code AS subject_code_3, t0.course_number AS course_number_4, t0.status AS status_5, t0.d7_nid AS d7_nid_6, t0.loaded_from AS loaded_from_7 FROM course t0 WHERE t0.id = '8033';
|
| 4 |
0.40 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.subject_code AS subject_code_3, t0.course_number AS course_number_4, t0.status AS status_5, t0.d7_nid AS d7_nid_6, t0.loaded_from AS loaded_from_7 FROM course t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.subject_code AS subject_code_3, t0.course_number AS course_number_4, t0.status AS status_5, t0.d7_nid AS d7_nid_6, t0.loaded_from AS loaded_from_7 FROM course t0 WHERE t0.id = '8033' LIMIT 1;
|
| 5 |
1.10 ms |
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_ WHERE (e0_.status = ? AND e0_.final_equiv1_course_id = ?) OR e0_.final_equiv2_course_id = ? OR e0_.final_equiv3_course_id = ? OR e0_.final_equiv4_course_id = ? ORDER BY e0_.updated DESC) dctrn_result) dctrn_table
Parameters: [
1
8033
8033
8033
8033
]
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_
WHERE
(
e0_.status = ?
AND e0_.final_equiv1_course_id = ?
)
OR e0_.final_equiv2_course_id = ?
OR e0_.final_equiv3_course_id = ?
OR e0_.final_equiv4_course_id = ?
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_ WHERE (e0_.status = 1 AND e0_.final_equiv1_course_id = 8033) OR e0_.final_equiv2_course_id = 8033 OR e0_.final_equiv3_course_id = 8033 OR e0_.final_equiv4_course_id = 8033 ORDER BY e0_.updated DESC) dctrn_result) dctrn_table;
|
| 6 |
0.94 ms |
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 FROM evaluation e0_ WHERE (e0_.status = ? AND e0_.final_equiv1_course_id = ?) OR e0_.final_equiv2_course_id = ? OR e0_.final_equiv3_course_id = ? OR e0_.final_equiv4_course_id = ?) dctrn_result_inner ORDER BY updated_20 DESC) dctrn_result LIMIT 30
Parameters: [
1
8033
8033
8033
8033
]
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
FROM
evaluation e0_
WHERE
(
e0_.status = ?
AND e0_.final_equiv1_course_id = ?
)
OR e0_.final_equiv2_course_id = ?
OR e0_.final_equiv3_course_id = ?
OR e0_.final_equiv4_course_id = ?
) dctrn_result_inner
ORDER BY
updated_20 DESC
) dctrn_result
LIMIT
30
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 FROM evaluation e0_ WHERE (e0_.status = 1 AND e0_.final_equiv1_course_id = 8033) OR e0_.final_equiv2_course_id = 8033 OR e0_.final_equiv3_course_id = 8033 OR e0_.final_equiv4_course_id = 8033) dctrn_result_inner ORDER BY updated_20 DESC) dctrn_result LIMIT 30;
|
| 7 |
1.06 ms |
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_ WHERE ((e0_.status = ? AND e0_.final_equiv1_course_id = ?) OR e0_.final_equiv2_course_id = ? OR e0_.final_equiv3_course_id = ? OR e0_.final_equiv4_course_id = ?) AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.updated DESC
Parameters: [
1
8033
8033
8033
8033
63493
69163
67715
62483
65853
65455
63713
63716
63215
63157
63007
62102
62504
60392
60478
59182
58034
58035
57266
]
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_
WHERE
(
(
e0_.status = ?
AND e0_.final_equiv1_course_id = ?
)
OR e0_.final_equiv2_course_id = ?
OR e0_.final_equiv3_course_id = ?
OR e0_.final_equiv4_course_id = ?
)
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_ WHERE ((e0_.status = 1 AND e0_.final_equiv1_course_id = 8033) OR e0_.final_equiv2_course_id = 8033 OR e0_.final_equiv3_course_id = 8033 OR e0_.final_equiv4_course_id = 8033) AND e0_.id IN (63493, 69163, 67715, 62483, 65853, 65455, 63713, 63716, 63215, 63157, 63007, 62102, 62504, 60392, 60478, 59182, 58034, 58035, 57266) ORDER BY e0_.updated DESC;
|
| 8 |
0.60 ms |
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 = ?
Parameters: [
b"\x01ÅêpÙ\vv2ÁÐî4©┬ãı"
]
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 = 0x018F8870EB0B7632B5D18C34B8C2C6D5;
|
| 9 |
0.38 ms |
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 = ?
Parameters: [
b"\x01ì2ç`C{┐»▓══ái ▀"
]
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 = 0x018D328760437BBFAFB2CDCDA069FFDF;
|
| 10 |
0.98 ms |
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 = 896;
|
| 11 |
0.36 ms |
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 = ?
Parameters: [
b"\x01šPHÑÐtÑŸ†Šg´Ýå€"
]
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 = 0x019A5048D1D074D19F868A67B4DDE580;
|
| 12 |
0.23 ms |
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 = 791;
|
| 13 |
0.21 ms |
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 = ?
Parameters: [
b"\x01—oë\x16¶x{š¨ï^ÕBÇU"
]
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 = 0x01976FEB16B6787B9AA8EF5ED542C755;
|
| 14 |
0.21 ms |
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 = ?
Parameters: [
b"\x01æFg0ÊtÃòBÃKØ&\x15#"
]
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 = 0x0191466730D274C79542C74B9D261523;
|
| 15 |
0.28 ms |
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 = 1382;
|
| 16 |
0.22 ms |
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 = ?
Parameters: [
b"\x01ì2à¦×yL¶ÜýPõ\x1C┐"
]
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 = 0x018D3285DD9E794CB6F49AEC50E41CBF;
|
| 17 |
0.20 ms |
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 = ?
Parameters: [
b"\x01ì2âÚ!t\x12╝─_p▒ks¦"
]
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 = 0x018D3283E9217412BCC45F70B16B73DD;
|
| 18 |
0.19 ms |
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 = 884;
|
| 19 |
0.17 ms |
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 = ?
Parameters: [
b"\x01’ú‹Ç¸u0˜ ÈŒh²2\x1C"
]
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 = 0x0192FA8BC7B875309820C88C68B2321C;
|
| 20 |
0.17 ms |
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 = ?
Parameters: [
b"\x01ì2ç═%{cêeõ\x1DoE╚\x1E"
]
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 = 0x018D3287CD257B638865E41D6F45C81E;
|
| 21 |
0.18 ms |
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 = 3088;
|
| 22 |
0.20 ms |
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 = ?
Parameters: [
b"\x01Éëá▀hw\x1Cö└IÚºeúï"
]
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 = 0x019089A0DF68771C94C049E9A765A38B;
|
| 23 |
0.21 ms |
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 = ?
Parameters: [
b"\x01ì2ꤶx¡Æ\x18│à\x14▒\t\v"
]
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 = 0x018D3288CFF478AD9218B38514B1090B;
|
| 24 |
0.19 ms |
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 = 1381;
|
| 25 |
0.21 ms |
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 = 1944;
|
| 26 |
0.22 ms |
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 = ?
Parameters: [
b"\x01Å\x01VÛ║pfƒÙë\x0F╠½Ö""
]
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 = 0x018F0156EABA70669FEB890FCCAB9922;
|
| 27 |
0.21 ms |
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 = ?
Parameters: [
b"\x01ì2çsbxÜ║É│─┌Ì|ñ"
]
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 = 0x018D32877362789ABA90B3C4DADE7CA4;
|
| 28 |
0.19 ms |
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 = 2563;
|
| 29 |
0.19 ms |
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 = ?
Parameters: [
b"\x01ì2ê^▄z0©DYüÄ[\vo"
]
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 = 0x018D32885EDC7A30B84459818E5B0B6F;
|
| 30 |
0.20 ms |
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 = 3353;
|
| 31 |
0.22 ms |
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 = ?
Parameters: [
b"\x01ŽÁŽê3w\v¯Nj\rÑ“Úï"
]
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 = 0x018EC18EEA33770BAF4E6A0DD193DAEF;
|
| 32 |
0.21 ms |
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 = 3223;
|
| 33 |
0.20 ms |
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 = ?
Parameters: [
b"\x01ì2ê├íxùØ~\x05D6\x15\x14╦"
]
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 = 0x018D3288C3A178979D7E0544361514CB;
|
| 34 |
0.20 ms |
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 = 926;
|
| 35 |
0.29 ms |
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 = ?
Parameters: [
b"\x01ì2êSëpÓ¿\x1DKb\x18ÅÖ""
]
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 = 0x018D3288538970E0A81D4B62188F9922;
|
| 36 |
0.24 ms |
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 = 960;
|
| 37 |
0.24 ms |
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 = ?
Parameters: [
b"\x01ì2êë\x1FxUê═\ÎÅ¥AF"
]
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 = 0x018D3288891F785588CD5CD78FBE4146;
|
| 38 |
0.25 ms |
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 = 949;
|
| 39 |
0.18 ms |
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 = ?
Parameters: [
b"\x01ì2êX\x17sÑÀ\x01ªî\x17eò\x1E"
]
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 = 0x018D3288581773A5B701A68C1765951E;
|
| 40 |
0.20 ms |
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 = ?
Parameters: [
b"\x01ì2ê&êpÐÂx+ßtw╔\r"
]
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 = 0x018D3288268870D1B6782BE17477C90D;
|
| 41 |
0.19 ms |
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 = 1368;
|
| 42 |
0.25 ms |
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 = ?
Parameters: [
b"\x01ì2ç·b{Ñíé\x06N\x03í\x01+"
]
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 = 0x018D3287FA627BA5A182064E03A1012B;
|