1
1.02 ms
SELECT module FROM organization_module WHERE organization_id = ?
SELECT module FROM organization_module WHERE organization_id = 1 ;
Copy
2
0.60 ms
SELECT id FROM organization WHERE domain = ?
Parameters :
[
"forum.trainizer.fr "
]
SELECT id FROM organization WHERE domain = 'forum.trainizer.fr' ;
Copy
3
0.90 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . organization_id AS organization_id_4 FROM forum_category t0 WHERE ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . organization_id AS organization_id_4 FROM forum_category t0 WHERE ((t0 . organization_id = 1 ));
Copy
4
1.33 ms
SELECT f0_ . id AS id_0 , f0_ . title AS title_1 , f0_ . created_at AS created_at_2 , f0_ . updated_at AS updated_at_3 , f0_ . is_pinned AS is_pinned_4 , f0_ . is_solved AS is_solved_5 , f0_ . tags AS tags_6 , f0_ . organization_id AS organization_id_7 , f1_ . id AS id_8 , f1_ . name AS name_9 , f1_ . slug AS slug_10 , f1_ . organization_id AS organization_id_11 , f2_ . id AS id_12 , f2_ . content AS content_13 , f2_ . created_at AS created_at_14 , f2_ . is_solution AS is_solution_15 , f2_ . organization_id AS organization_id_16 , f0_ . category_id AS category_id_17 , f0_ . author_id AS author_id_18 , f2_ . topic_id AS topic_id_19 , f2_ . author_id AS author_id_20 FROM forum_topic f0_ LEFT JOIN forum_category f1_ ON f0_ . category_id = f1_ . id AND (f1_ . organization_id = 1 ) LEFT JOIN forum_post f2_ ON f0_ . id = f2_ . topic_id AND (f2_ . organization_id = 1 ) WHERE (f0_ . organization_id = 1 ) ORDER BY f0_ . is_pinned DESC , f0_ . updated_at DESC
SELECT f0_ . id AS id_0 , f0_ . title AS title_1 , f0_ . created_at AS created_at_2 , f0_ . updated_at AS updated_at_3 , f0_ . is_pinned AS is_pinned_4 , f0_ . is_solved AS is_solved_5 , f0_ . tags AS tags_6 , f0_ . organization_id AS organization_id_7 , f1_ . id AS id_8 , f1_ . name AS name_9 , f1_ . slug AS slug_10 , f1_ . organization_id AS organization_id_11 , f2_ . id AS id_12 , f2_ . content AS content_13 , f2_ . created_at AS created_at_14 , f2_ . is_solution AS is_solution_15 , f2_ . organization_id AS organization_id_16 , f0_ . category_id AS category_id_17 , f0_ . author_id AS author_id_18 , f2_ . topic_id AS topic_id_19 , f2_ . author_id AS author_id_20 FROM forum_topic f0_ LEFT JOIN forum_category f1_ ON f0_ . category_id = f1_ . id AND (f1_ . organization_id = 1 ) LEFT JOIN forum_post f2_ ON f0_ . id = f2_ . topic_id AND (f2_ . organization_id = 1 ) WHERE (f0_ . organization_id = 1 ) ORDER BY f0_ . is_pinned DESC , f0_ . updated_at DESC ;
Copy
5
1.39 ms
SELECT t0 . id AS id_5 , t0 . username AS username_6 , t0 . last_name AS last_name_7 , t0 . first_name AS first_name_8 , t0 . roles AS roles_9 , t0 . password AS password_10 , t0 . email AS email_11 , t0 . activated AS activated_12 , t0 . calendar_feed_secret AS calendar_feed_secret_13 , t0 . password_changed_at AS password_changed_at_14 , t0 . tmp_code AS tmp_code_15 , t0 . tmp_code_date AS tmp_code_date_16 , t0 . signature AS signature_17 , t0 . uuid AS uuid_18 , t0 . phone_number AS phone_number_19 , t0 . organization_id AS organization_id_20 , t0 . avatar_id AS avatar_id_21 , t0 . dtype , t1 . password_save AS password_save_22 , t1 . documents AS documents_23 , t1 . diploma AS diploma_24 , t1 . tutorial_completed AS tutorial_completed_25 , t1 . financial_aid AS financial_aid_26 , t1 . cohort_id AS cohort_id_27 , t2 . role AS role_28 , t2 . entrance_code AS entrance_code_29 , t2 . entrance_code_date AS entrance_code_date_30 , t2 . responsible_id AS responsible_id_31 , t3 . role AS role_32 , t3 . entrance_code AS entrance_code_33 , t3 . entrance_code_date AS entrance_code_date_34 , t3 . sector_id AS sector_id_35 , t4 . role AS role_36 , t4 . entrance_code AS entrance_code_37 , t4 . entrance_code_date AS entrance_code_date_38 , t4 . coordinator_id AS coordinator_id_39 FROM user t0 LEFT JOIN trainee t1 ON t0 . id = t1 . id LEFT JOIN coordinator t2 ON t0 . id = t2 . id LEFT JOIN responsible t3 ON t0 . id = t3 . id LEFT JOIN trainer t4 ON t0 . id = t4 . id WHERE t0 . id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_5 , t0 . username AS username_6 , t0 . last_name AS last_name_7 , t0 . first_name AS first_name_8 , t0 . roles AS roles_9 , t0 . password AS password_10 , t0 . email AS email_11 , t0 . activated AS activated_12 , t0 . calendar_feed_secret AS calendar_feed_secret_13 , t0 . password_changed_at AS password_changed_at_14 , t0 . tmp_code AS tmp_code_15 , t0 . tmp_code_date AS tmp_code_date_16 , t0 . signature AS signature_17 , t0 . uuid AS uuid_18 , t0 . phone_number AS phone_number_19 , t0 . organization_id AS organization_id_20 , t0 . avatar_id AS avatar_id_21 , t0 . dtype , t1 . password_save AS password_save_22 , t1 . documents AS documents_23 , t1 . diploma AS diploma_24 , t1 . tutorial_completed AS tutorial_completed_25 , t1 . financial_aid AS financial_aid_26 , t1 . cohort_id AS cohort_id_27 , t2 . role AS role_28 , t2 . entrance_code AS entrance_code_29 , t2 . entrance_code_date AS entrance_code_date_30 , t2 . responsible_id AS responsible_id_31 , t3 . role AS role_32 , t3 . entrance_code AS entrance_code_33 , t3 . entrance_code_date AS entrance_code_date_34 , t3 . sector_id AS sector_id_35 , t4 . role AS role_36 , t4 . entrance_code AS entrance_code_37 , t4 . entrance_code_date AS entrance_code_date_38 , t4 . coordinator_id AS coordinator_id_39 FROM user t0 LEFT JOIN trainee t1 ON t0 . id = t1 . id LEFT JOIN coordinator t2 ON t0 . id = t2 . id LEFT JOIN responsible t3 ON t0 . id = t3 . id LEFT JOIN trainer t4 ON t0 . id = t4 . id WHERE t0 . id = 1 AND ((t0 . organization_id = 1 ));
Copy
6
0.91 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . registry_number AS registry_number_3 , t0 . job AS job_4 , t0 . qualification AS qualification_5 , t0 . contract_label AS contract_label_6 , t0 . nationality AS nationality_7 , t0 . birth_date AS birth_date_8 , t0 . sex AS sex_9 , t0 . hired_at AS hired_at_10 , t0 . left_at AS left_at_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . organization_id AS organization_id_14 , t0 . user_id AS user_id_15 FROM collaborator t0 WHERE t0 . user_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . registry_number AS registry_number_3 , t0 . job AS job_4 , t0 . qualification AS qualification_5 , t0 . contract_label AS contract_label_6 , t0 . nationality AS nationality_7 , t0 . birth_date AS birth_date_8 , t0 . sex AS sex_9 , t0 . hired_at AS hired_at_10 , t0 . left_at AS left_at_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . organization_id AS organization_id_14 , t0 . user_id AS user_id_15 FROM collaborator t0 WHERE t0 . user_id = 1 AND ((t0 . organization_id = 1 ));
Copy
7
1.23 ms
SELECT t0 . id AS id_5 , t0 . username AS username_6 , t0 . last_name AS last_name_7 , t0 . first_name AS first_name_8 , t0 . roles AS roles_9 , t0 . password AS password_10 , t0 . email AS email_11 , t0 . activated AS activated_12 , t0 . calendar_feed_secret AS calendar_feed_secret_13 , t0 . password_changed_at AS password_changed_at_14 , t0 . tmp_code AS tmp_code_15 , t0 . tmp_code_date AS tmp_code_date_16 , t0 . signature AS signature_17 , t0 . uuid AS uuid_18 , t0 . phone_number AS phone_number_19 , t0 . organization_id AS organization_id_20 , t0 . avatar_id AS avatar_id_21 , t0 . dtype , t1 . password_save AS password_save_22 , t1 . documents AS documents_23 , t1 . diploma AS diploma_24 , t1 . tutorial_completed AS tutorial_completed_25 , t1 . financial_aid AS financial_aid_26 , t1 . cohort_id AS cohort_id_27 , t2 . role AS role_28 , t2 . entrance_code AS entrance_code_29 , t2 . entrance_code_date AS entrance_code_date_30 , t2 . responsible_id AS responsible_id_31 , t3 . role AS role_32 , t3 . entrance_code AS entrance_code_33 , t3 . entrance_code_date AS entrance_code_date_34 , t3 . sector_id AS sector_id_35 , t4 . role AS role_36 , t4 . entrance_code AS entrance_code_37 , t4 . entrance_code_date AS entrance_code_date_38 , t4 . coordinator_id AS coordinator_id_39 FROM user t0 LEFT JOIN trainee t1 ON t0 . id = t1 . id LEFT JOIN coordinator t2 ON t0 . id = t2 . id LEFT JOIN responsible t3 ON t0 . id = t3 . id LEFT JOIN trainer t4 ON t0 . id = t4 . id WHERE t0 . id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_5 , t0 . username AS username_6 , t0 . last_name AS last_name_7 , t0 . first_name AS first_name_8 , t0 . roles AS roles_9 , t0 . password AS password_10 , t0 . email AS email_11 , t0 . activated AS activated_12 , t0 . calendar_feed_secret AS calendar_feed_secret_13 , t0 . password_changed_at AS password_changed_at_14 , t0 . tmp_code AS tmp_code_15 , t0 . tmp_code_date AS tmp_code_date_16 , t0 . signature AS signature_17 , t0 . uuid AS uuid_18 , t0 . phone_number AS phone_number_19 , t0 . organization_id AS organization_id_20 , t0 . avatar_id AS avatar_id_21 , t0 . dtype , t1 . password_save AS password_save_22 , t1 . documents AS documents_23 , t1 . diploma AS diploma_24 , t1 . tutorial_completed AS tutorial_completed_25 , t1 . financial_aid AS financial_aid_26 , t1 . cohort_id AS cohort_id_27 , t2 . role AS role_28 , t2 . entrance_code AS entrance_code_29 , t2 . entrance_code_date AS entrance_code_date_30 , t2 . responsible_id AS responsible_id_31 , t3 . role AS role_32 , t3 . entrance_code AS entrance_code_33 , t3 . entrance_code_date AS entrance_code_date_34 , t3 . sector_id AS sector_id_35 , t4 . role AS role_36 , t4 . entrance_code AS entrance_code_37 , t4 . entrance_code_date AS entrance_code_date_38 , t4 . coordinator_id AS coordinator_id_39 FROM user t0 LEFT JOIN trainee t1 ON t0 . id = t1 . id LEFT JOIN coordinator t2 ON t0 . id = t2 . id LEFT JOIN responsible t3 ON t0 . id = t3 . id LEFT JOIN trainer t4 ON t0 . id = t4 . id WHERE t0 . id = 106 AND ((t0 . organization_id = 1 ));
Copy
8
0.93 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . registry_number AS registry_number_3 , t0 . job AS job_4 , t0 . qualification AS qualification_5 , t0 . contract_label AS contract_label_6 , t0 . nationality AS nationality_7 , t0 . birth_date AS birth_date_8 , t0 . sex AS sex_9 , t0 . hired_at AS hired_at_10 , t0 . left_at AS left_at_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . organization_id AS organization_id_14 , t0 . user_id AS user_id_15 FROM collaborator t0 WHERE t0 . user_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . registry_number AS registry_number_3 , t0 . job AS job_4 , t0 . qualification AS qualification_5 , t0 . contract_label AS contract_label_6 , t0 . nationality AS nationality_7 , t0 . birth_date AS birth_date_8 , t0 . sex AS sex_9 , t0 . hired_at AS hired_at_10 , t0 . left_at AS left_at_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . organization_id AS organization_id_14 , t0 . user_id AS user_id_15 FROM collaborator t0 WHERE t0 . user_id = 106 AND ((t0 . organization_id = 1 ));
Copy
9
1.27 ms
SELECT t0 . id AS id_5 , t0 . username AS username_6 , t0 . last_name AS last_name_7 , t0 . first_name AS first_name_8 , t0 . roles AS roles_9 , t0 . password AS password_10 , t0 . email AS email_11 , t0 . activated AS activated_12 , t0 . calendar_feed_secret AS calendar_feed_secret_13 , t0 . password_changed_at AS password_changed_at_14 , t0 . tmp_code AS tmp_code_15 , t0 . tmp_code_date AS tmp_code_date_16 , t0 . signature AS signature_17 , t0 . uuid AS uuid_18 , t0 . phone_number AS phone_number_19 , t0 . organization_id AS organization_id_20 , t0 . avatar_id AS avatar_id_21 , t0 . dtype , t1 . password_save AS password_save_22 , t1 . documents AS documents_23 , t1 . diploma AS diploma_24 , t1 . tutorial_completed AS tutorial_completed_25 , t1 . financial_aid AS financial_aid_26 , t1 . cohort_id AS cohort_id_27 , t2 . role AS role_28 , t2 . entrance_code AS entrance_code_29 , t2 . entrance_code_date AS entrance_code_date_30 , t2 . responsible_id AS responsible_id_31 , t3 . role AS role_32 , t3 . entrance_code AS entrance_code_33 , t3 . entrance_code_date AS entrance_code_date_34 , t3 . sector_id AS sector_id_35 , t4 . role AS role_36 , t4 . entrance_code AS entrance_code_37 , t4 . entrance_code_date AS entrance_code_date_38 , t4 . coordinator_id AS coordinator_id_39 FROM user t0 LEFT JOIN trainee t1 ON t0 . id = t1 . id LEFT JOIN coordinator t2 ON t0 . id = t2 . id LEFT JOIN responsible t3 ON t0 . id = t3 . id LEFT JOIN trainer t4 ON t0 . id = t4 . id WHERE t0 . id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_5 , t0 . username AS username_6 , t0 . last_name AS last_name_7 , t0 . first_name AS first_name_8 , t0 . roles AS roles_9 , t0 . password AS password_10 , t0 . email AS email_11 , t0 . activated AS activated_12 , t0 . calendar_feed_secret AS calendar_feed_secret_13 , t0 . password_changed_at AS password_changed_at_14 , t0 . tmp_code AS tmp_code_15 , t0 . tmp_code_date AS tmp_code_date_16 , t0 . signature AS signature_17 , t0 . uuid AS uuid_18 , t0 . phone_number AS phone_number_19 , t0 . organization_id AS organization_id_20 , t0 . avatar_id AS avatar_id_21 , t0 . dtype , t1 . password_save AS password_save_22 , t1 . documents AS documents_23 , t1 . diploma AS diploma_24 , t1 . tutorial_completed AS tutorial_completed_25 , t1 . financial_aid AS financial_aid_26 , t1 . cohort_id AS cohort_id_27 , t2 . role AS role_28 , t2 . entrance_code AS entrance_code_29 , t2 . entrance_code_date AS entrance_code_date_30 , t2 . responsible_id AS responsible_id_31 , t3 . role AS role_32 , t3 . entrance_code AS entrance_code_33 , t3 . entrance_code_date AS entrance_code_date_34 , t3 . sector_id AS sector_id_35 , t4 . role AS role_36 , t4 . entrance_code AS entrance_code_37 , t4 . entrance_code_date AS entrance_code_date_38 , t4 . coordinator_id AS coordinator_id_39 FROM user t0 LEFT JOIN trainee t1 ON t0 . id = t1 . id LEFT JOIN coordinator t2 ON t0 . id = t2 . id LEFT JOIN responsible t3 ON t0 . id = t3 . id LEFT JOIN trainer t4 ON t0 . id = t4 . id WHERE t0 . id = 23 AND ((t0 . organization_id = 1 ));
Copy
10
0.95 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . registry_number AS registry_number_3 , t0 . job AS job_4 , t0 . qualification AS qualification_5 , t0 . contract_label AS contract_label_6 , t0 . nationality AS nationality_7 , t0 . birth_date AS birth_date_8 , t0 . sex AS sex_9 , t0 . hired_at AS hired_at_10 , t0 . left_at AS left_at_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . organization_id AS organization_id_14 , t0 . user_id AS user_id_15 FROM collaborator t0 WHERE t0 . user_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . registry_number AS registry_number_3 , t0 . job AS job_4 , t0 . qualification AS qualification_5 , t0 . contract_label AS contract_label_6 , t0 . nationality AS nationality_7 , t0 . birth_date AS birth_date_8 , t0 . sex AS sex_9 , t0 . hired_at AS hired_at_10 , t0 . left_at AS left_at_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . organization_id AS organization_id_14 , t0 . user_id AS user_id_15 FROM collaborator t0 WHERE t0 . user_id = 23 AND ((t0 . organization_id = 1 ));
Copy
11
1.33 ms
SELECT t0 . id AS id_5 , t0 . username AS username_6 , t0 . last_name AS last_name_7 , t0 . first_name AS first_name_8 , t0 . roles AS roles_9 , t0 . password AS password_10 , t0 . email AS email_11 , t0 . activated AS activated_12 , t0 . calendar_feed_secret AS calendar_feed_secret_13 , t0 . password_changed_at AS password_changed_at_14 , t0 . tmp_code AS tmp_code_15 , t0 . tmp_code_date AS tmp_code_date_16 , t0 . signature AS signature_17 , t0 . uuid AS uuid_18 , t0 . phone_number AS phone_number_19 , t0 . organization_id AS organization_id_20 , t0 . avatar_id AS avatar_id_21 , t0 . dtype , t1 . password_save AS password_save_22 , t1 . documents AS documents_23 , t1 . diploma AS diploma_24 , t1 . tutorial_completed AS tutorial_completed_25 , t1 . financial_aid AS financial_aid_26 , t1 . cohort_id AS cohort_id_27 , t2 . role AS role_28 , t2 . entrance_code AS entrance_code_29 , t2 . entrance_code_date AS entrance_code_date_30 , t2 . responsible_id AS responsible_id_31 , t3 . role AS role_32 , t3 . entrance_code AS entrance_code_33 , t3 . entrance_code_date AS entrance_code_date_34 , t3 . sector_id AS sector_id_35 , t4 . role AS role_36 , t4 . entrance_code AS entrance_code_37 , t4 . entrance_code_date AS entrance_code_date_38 , t4 . coordinator_id AS coordinator_id_39 FROM user t0 LEFT JOIN trainee t1 ON t0 . id = t1 . id LEFT JOIN coordinator t2 ON t0 . id = t2 . id LEFT JOIN responsible t3 ON t0 . id = t3 . id LEFT JOIN trainer t4 ON t0 . id = t4 . id WHERE t0 . id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_5 , t0 . username AS username_6 , t0 . last_name AS last_name_7 , t0 . first_name AS first_name_8 , t0 . roles AS roles_9 , t0 . password AS password_10 , t0 . email AS email_11 , t0 . activated AS activated_12 , t0 . calendar_feed_secret AS calendar_feed_secret_13 , t0 . password_changed_at AS password_changed_at_14 , t0 . tmp_code AS tmp_code_15 , t0 . tmp_code_date AS tmp_code_date_16 , t0 . signature AS signature_17 , t0 . uuid AS uuid_18 , t0 . phone_number AS phone_number_19 , t0 . organization_id AS organization_id_20 , t0 . avatar_id AS avatar_id_21 , t0 . dtype , t1 . password_save AS password_save_22 , t1 . documents AS documents_23 , t1 . diploma AS diploma_24 , t1 . tutorial_completed AS tutorial_completed_25 , t1 . financial_aid AS financial_aid_26 , t1 . cohort_id AS cohort_id_27 , t2 . role AS role_28 , t2 . entrance_code AS entrance_code_29 , t2 . entrance_code_date AS entrance_code_date_30 , t2 . responsible_id AS responsible_id_31 , t3 . role AS role_32 , t3 . entrance_code AS entrance_code_33 , t3 . entrance_code_date AS entrance_code_date_34 , t3 . sector_id AS sector_id_35 , t4 . role AS role_36 , t4 . entrance_code AS entrance_code_37 , t4 . entrance_code_date AS entrance_code_date_38 , t4 . coordinator_id AS coordinator_id_39 FROM user t0 LEFT JOIN trainee t1 ON t0 . id = t1 . id LEFT JOIN coordinator t2 ON t0 . id = t2 . id LEFT JOIN responsible t3 ON t0 . id = t3 . id LEFT JOIN trainer t4 ON t0 . id = t4 . id WHERE t0 . id = 24 AND ((t0 . organization_id = 1 ));
Copy
12
1.05 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . registry_number AS registry_number_3 , t0 . job AS job_4 , t0 . qualification AS qualification_5 , t0 . contract_label AS contract_label_6 , t0 . nationality AS nationality_7 , t0 . birth_date AS birth_date_8 , t0 . sex AS sex_9 , t0 . hired_at AS hired_at_10 , t0 . left_at AS left_at_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . organization_id AS organization_id_14 , t0 . user_id AS user_id_15 FROM collaborator t0 WHERE t0 . user_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . registry_number AS registry_number_3 , t0 . job AS job_4 , t0 . qualification AS qualification_5 , t0 . contract_label AS contract_label_6 , t0 . nationality AS nationality_7 , t0 . birth_date AS birth_date_8 , t0 . sex AS sex_9 , t0 . hired_at AS hired_at_10 , t0 . left_at AS left_at_11 , t0 . notes AS notes_12 , t0 . created_at AS created_at_13 , t0 . organization_id AS organization_id_14 , t0 . user_id AS user_id_15 FROM collaborator t0 WHERE t0 . user_id = 24 AND ((t0 . organization_id = 1 ));
Copy
13
0.86 ms
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category = ? AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC
Parameters :
[
"homework_to_do "
]
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category = 'homework_to_do' AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC ;
Copy
14
0.84 ms
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category = ? AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC
Parameters :
[
"new_message "
]
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category = 'new_message' AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC ;
Copy
15
0.74 ms
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category IN (? , ? , ? ) AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC
Parameters :
[
"internship_approval "
"internship_to_seal "
"internship_rejected "
]
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category IN ('internship_approval' , 'internship_to_seal' , 'internship_rejected' ) AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC ;
Copy
16
0.69 ms
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category = ? AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC
Parameters :
[
"new_document "
]
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category = 'new_document' AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC ;
Copy
17
0.90 ms
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category IN (? , ? , ? ) AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC
Parameters :
[
"planning_added "
"planning_updated "
"planning_removed "
]
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category IN ('planning_added' , 'planning_updated' , 'planning_removed' ) AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC ;
Copy
18
0.89 ms
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category IN (? , ? , ? , ? ) AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC
Parameters :
[
"interview_due "
"interview_overdue "
"interview_done "
"interview_ack "
]
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category IN ('interview_due' , 'interview_overdue' , 'interview_done' , 'interview_ack' ) AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC ;
Copy
19
0.84 ms
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category = ? AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC
Parameters :
[
"rncp_expired "
]
SELECT t0 . id AS id_1 , t0 . origin AS origin_2 , t0 . message AS message_3 , t0 . link AS link_4 , t0 . date AS date_5 , t0 . category AS category_6 , t0 . organization_id AS organization_id_7 , t0 . user_id AS user_id_8 FROM notification t0 WHERE t0 . category = 'rncp_expired' AND t0 . user_id IS NULL AND ((t0 . organization_id = 1 )) ORDER BY t0 . date DESC ;
Copy
20
1.16 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . path AS path_3 FROM theme t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . path AS path_3 FROM theme t0 WHERE t0 . id = 4 ;
Copy
21
1.00 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = 4 AND ((t0 . organization_id = 1 ));
Copy
22
0.95 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = 5 AND ((t0 . organization_id = 1 ));
Copy
23
0.97 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = 2 AND ((t0 . organization_id = 1 ));
Copy
24
0.94 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = 3 AND ((t0 . organization_id = 1 ));
Copy
25
1.03 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = ? AND ((t0 . organization_id = 1 ))
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_pinned AS is_pinned_5 , t0 . is_solved AS is_solved_6 , t0 . tags AS tags_7 , t0 . organization_id AS organization_id_8 , t0 . category_id AS category_id_9 , t0 . author_id AS author_id_10 FROM forum_topic t0 WHERE t0 . category_id = 1 AND ((t0 . organization_id = 1 ));
Copy