1
0.81 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 ;
Copy
2
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 . 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 ;
Copy
3
0.37 ms
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 = '69' LIMIT 1 ;
Copy
4
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 . 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 = 'hjoo41' LIMIT 1 ;
Copy
5
0.82 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_ 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
Parameters :
[
1
"hjoo41 "
]
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
Copy
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 = 'hjoo41' ORDER BY e0_ . updated DESC ) dctrn_result ) dctrn_table ;
Copy
6
0.70 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 , 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
Parameters :
[
1
"hjoo41 "
]
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
Copy
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 = 'hjoo41' ) dctrn_result_inner ORDER BY updated_20 DESC ) dctrn_result LIMIT 30 ;
Copy
7
0.92 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_ 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
Parameters :
[
1
"hjoo41 "
64692
64693
65034
65033
64074
64075
61525
63195
58899
59121
61998
61372
61374
61373
60098
61293
60416
59364
58914
58913
58049
58047
57690
]
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
Copy
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 = 'hjoo41' AND e0_ . id IN (64692 , 64693 , 65034 , 65033 , 64074 , 64075 , 61525 , 63195 , 58899 , 59121 , 61998 , 61372 , 61374 , 61373 , 60098 , 61293 , 60416 , 59364 , 58914 , 58913 , 58049 , 58047 , 57690 ) ORDER BY e0_ . updated DESC ;
Copy
8
0.31 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 = 2734 ;
Copy
9
0.27 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 Å´\x02 ╠x|1¥5┤░┘w;A "
]
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 = 0x018FEF02CC787C31BE35B4B0D9773B41 ;
Copy
10
0.32 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 = 2068 ;
Copy
11
0.27 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 įe└gtÀæ\x1A âQȪì\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 = 0x018EEE65C06774B7911A8351D4A68D0D ;
Copy
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 = 2148 ;
Copy
13
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 É,(Ò┤ywà═&┘¢║\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 = 0x01902C28E3B4797785CD26D9BDBA1CF3 ;
Copy
14
0.26 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 = 1839 ;
Copy
15
0.27 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ê½Mt·ÑtUhÅ\x00 ýp "
]
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 = 0x018D3288AB4D74FAA57455688F00EC70 ;
Copy
16
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 = 3208 ;
Copy
17
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ê]û~*ɧÊRïÿ(\x16 "
]
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 = 0x018D32885D967E2A90F5D2528B982816 ;
Copy
18
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 = 3040 ;
Copy
19
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å2þrE¢¹╩ÙI \x10 Ó "
]
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 = 0x018D328632E77245BDFBCAEB49FF10E0 ;
Copy
20
0.23 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ê\r Ît■û│ì‗tDPA "
]
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 = 0x018D32880DD774FE96B38DF274445041 ;
Copy
21
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 = 2430 ;
Copy
22
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êØÄv$á┴aÖ┘\x13 L3 "
]
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 = 0x018D32889D8E7624A0C16199D9134C33 ;
Copy
23
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 = 2629 ;
Copy
24
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êÅ v¸æ\x18\x17 ÿ\x04 ó±; "
]
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 = 0x018D32888FFF76F79118179804A2F13B ;
Copy
25
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 = 3034 ;
Copy
26
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ê\x7F ‗p╦í╣1÷└p· "
]
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 = 0x018D32887FF270CBA1B931F6C070FAFF ;
Copy
27
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 = 16 ;
Copy
28
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êå©s)ø\v 7╚┼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 = 0x018D328886B873299B0B37C8C55524C4 ;
Copy
29
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 = 957 ;
Copy
30
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êRBwØ║´ö├&¾Ó@ "
]
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 = 0x018D32885242779DBAEF94C326F3E040 ;
Copy
31
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 = 3183 ;
Copy
32
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êI´}`ÜD■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 = 0x018D328849EF7D609A44FE55BBCD3CC3 ;
Copy
33
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 = 2913 ;
Copy
34
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ê.¡uôª┤\x1C\x04\x17 ╦·ì "
]
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 = 0x018D32882EAD7593A6B41C0417CBFA8D ;
Copy
35
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 = 2042 ;
Copy
36
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åj\e wPØÉå\v\x15 │\e\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 = 0x018D32866A1B77509D90860B15B31B01 ;
Copy