| 1 |
1.15 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.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = ?
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.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = 108;
|
| 2 |
1.20 ms
|
SELECT t0.id AS id_1, t0.status AS status_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.desired_training AS desired_training_6, t0.retention_years AS retention_years_7, t0.locale AS locale_8, t0.birth_date AS birth_date_9, t0.birth_place AS birth_place_10, t0.nationality AS nationality_11, t0.phone_number AS phone_number_12, t0.street AS street_13, t0.postal_code AS postal_code_14, t0.city AS city_15, t0.country AS country_16, t0.education_level AS education_level_17, t0.situation AS situation_18, t0.financial_aid AS financial_aid_19, t0.motivation AS motivation_20, t0.token_hash AS token_hash_21, t0.token_expires_at AS token_expires_at_22, t0.seal_reference AS seal_reference_23, t0.sealed_at AS sealed_at_24, t0.seal_digest AS seal_digest_25, t0.document_path AS document_path_26, t0.document_sha256 AS document_sha256_27, t0.created_at AS created_at_28, t0.submitted_at AS submitted_at_29, t0.validated_at AS validated_at_30, t0.decided_at AS decided_at_31, t0.rejection_reason AS rejection_reason_32, t0.retention_until AS retention_until_33, t0.invited_by_id AS invited_by_id_34, t0.validated_by_id AS validated_by_id_35, t0.decided_by_id AS decided_by_id_36, t0.cohort_id AS cohort_id_37, t0.trainee_id AS trainee_id_38 FROM candidate t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.status AS status_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.desired_training AS desired_training_6, t0.retention_years AS retention_years_7, t0.locale AS locale_8, t0.birth_date AS birth_date_9, t0.birth_place AS birth_place_10, t0.nationality AS nationality_11, t0.phone_number AS phone_number_12, t0.street AS street_13, t0.postal_code AS postal_code_14, t0.city AS city_15, t0.country AS country_16, t0.education_level AS education_level_17, t0.situation AS situation_18, t0.financial_aid AS financial_aid_19, t0.motivation AS motivation_20, t0.token_hash AS token_hash_21, t0.token_expires_at AS token_expires_at_22, t0.seal_reference AS seal_reference_23, t0.sealed_at AS sealed_at_24, t0.seal_digest AS seal_digest_25, t0.document_path AS document_path_26, t0.document_sha256 AS document_sha256_27, t0.created_at AS created_at_28, t0.submitted_at AS submitted_at_29, t0.validated_at AS validated_at_30, t0.decided_at AS decided_at_31, t0.rejection_reason AS rejection_reason_32, t0.retention_until AS retention_until_33, t0.invited_by_id AS invited_by_id_34, t0.validated_by_id AS validated_by_id_35, t0.decided_by_id AS decided_by_id_36, t0.cohort_id AS cohort_id_37, t0.trainee_id AS trainee_id_38 FROM candidate t0 WHERE t0.id = '2';
|
| 3 |
1.28 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.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.role AS role_19, t1.entrance_code AS entrance_code_20, t1.entrance_code_date AS entrance_code_date_21, t1.responsible_id AS responsible_id_22, t2.role AS role_23, t2.entrance_code AS entrance_code_24, t2.entrance_code_date AS entrance_code_date_25, t2.sector_id AS sector_id_26, t3.password_save AS password_save_27, t3.documents AS documents_28, t3.diploma AS diploma_29, t3.tutorial_completed AS tutorial_completed_30, t3.financial_aid AS financial_aid_31, t3.cohort_id AS cohort_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN coordinator t1 ON t0.id = t1.id LEFT JOIN responsible t2 ON t0.id = t2.id LEFT JOIN trainee t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = ?
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.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.role AS role_19, t1.entrance_code AS entrance_code_20, t1.entrance_code_date AS entrance_code_date_21, t1.responsible_id AS responsible_id_22, t2.role AS role_23, t2.entrance_code AS entrance_code_24, t2.entrance_code_date AS entrance_code_date_25, t2.sector_id AS sector_id_26, t3.password_save AS password_save_27, t3.documents AS documents_28, t3.diploma AS diploma_29, t3.tutorial_completed AS tutorial_completed_30, t3.financial_aid AS financial_aid_31, t3.cohort_id AS cohort_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN coordinator t1 ON t0.id = t1.id LEFT JOIN responsible t2 ON t0.id = t2.id LEFT JOIN trainee t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = 1;
|
| 4 |
0.87 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.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = ?
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.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = 1;
|
| 5 |
0.98 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.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = ?
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.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = 180;
|
| 6 |
1.23 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.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id = ? ORDER BY t0.date DESC
Parameters: [
"homework_to_do"
108
]
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.user_id AS user_id_7 FROM notification t0 WHERE t0.category = 'homework_to_do' AND t0.user_id = 108 ORDER BY t0.date DESC;
|
| 7 |
1.08 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.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id = ? ORDER BY t0.date DESC
Parameters: [
"new_message"
108
]
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.user_id AS user_id_7 FROM notification t0 WHERE t0.category = 'new_message' AND t0.user_id = 108 ORDER BY t0.date DESC;
|
| 8 |
1.01 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.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id = ? ORDER BY t0.date DESC
Parameters: [
"internship_approval"
"internship_to_seal"
"internship_rejected"
108
]
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.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN ('internship_approval', 'internship_to_seal', 'internship_rejected') AND t0.user_id = 108 ORDER BY t0.date DESC;
|
| 9 |
1.00 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.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id = ? ORDER BY t0.date DESC
Parameters: [
"new_document"
108
]
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.user_id AS user_id_7 FROM notification t0 WHERE t0.category = 'new_document' AND t0.user_id = 108 ORDER BY t0.date DESC;
|
| 10 |
1.00 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.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id = ? ORDER BY t0.date DESC
Parameters: [
"planning_added"
"planning_updated"
"planning_removed"
108
]
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.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN ('planning_added', 'planning_updated', 'planning_removed') AND t0.user_id = 108 ORDER BY t0.date DESC;
|
| 11 |
0.75 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;
|
| 12 |
1.04 ms
|
SELECT t1.id AS id_2, t1.username AS username_3, t1.last_name AS last_name_4, t1.first_name AS first_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.email AS email_8, t1.activated AS activated_9, t1.tmp_code AS tmp_code_10, t1.tmp_code_date AS tmp_code_date_11, t1.signature AS signature_12, t1.uuid AS uuid_13, t1.phone_number AS phone_number_14, t0.role AS role_15, t0.entrance_code AS entrance_code_16, t0.entrance_code_date AS entrance_code_date_17, t1.avatar_id AS avatar_id_18, t0.sector_id AS sector_id_19, t1.dtype FROM responsible t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.username = ? LIMIT 1
Parameters: [
"sophiepoulakos"
]
SELECT t1.id AS id_2, t1.username AS username_3, t1.last_name AS last_name_4, t1.first_name AS first_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.email AS email_8, t1.activated AS activated_9, t1.tmp_code AS tmp_code_10, t1.tmp_code_date AS tmp_code_date_11, t1.signature AS signature_12, t1.uuid AS uuid_13, t1.phone_number AS phone_number_14, t0.role AS role_15, t0.entrance_code AS entrance_code_16, t0.entrance_code_date AS entrance_code_date_17, t1.avatar_id AS avatar_id_18, t0.sector_id AS sector_id_19, t1.dtype FROM responsible t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.username = 'sophiepoulakos' LIMIT 1;
|
| 13 |
1.03 ms
|
SELECT t1.id AS id_2, t1.username AS username_3, t1.last_name AS last_name_4, t1.first_name AS first_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.email AS email_8, t1.activated AS activated_9, t1.tmp_code AS tmp_code_10, t1.tmp_code_date AS tmp_code_date_11, t1.signature AS signature_12, t1.uuid AS uuid_13, t1.phone_number AS phone_number_14, t0.role AS role_15, t0.entrance_code AS entrance_code_16, t0.entrance_code_date AS entrance_code_date_17, t1.avatar_id AS avatar_id_18, t0.coordinator_id AS coordinator_id_19, t1.dtype FROM trainer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.username = ? LIMIT 1
Parameters: [
"sophiepoulakos"
]
SELECT t1.id AS id_2, t1.username AS username_3, t1.last_name AS last_name_4, t1.first_name AS first_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.email AS email_8, t1.activated AS activated_9, t1.tmp_code AS tmp_code_10, t1.tmp_code_date AS tmp_code_date_11, t1.signature AS signature_12, t1.uuid AS uuid_13, t1.phone_number AS phone_number_14, t0.role AS role_15, t0.entrance_code AS entrance_code_16, t0.entrance_code_date AS entrance_code_date_17, t1.avatar_id AS avatar_id_18, t0.coordinator_id AS coordinator_id_19, t1.dtype FROM trainer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.username = 'sophiepoulakos' LIMIT 1;
|