| 1 |
1.28 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters: [
"sophie@dapres.fr"
]
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.password AS password_3,
t0.first_name AS first_name_4,
t0.last_name AS last_name_5,
t0.birth_date AS birth_date_6,
t0.gender AS gender_7,
t0.address AS address_8,
t0.telephone AS telephone_9,
t0.nir AS nir_10,
t0.pro_situation AS pro_situation_11,
t0.personal_situation AS personal_situation_12,
t0.status AS status_13,
t0.mobility_area AS mobility_area_14,
t0.transport_means AS transport_means_15,
t0.education_level AS education_level_16,
t0.french_level AS french_level_17,
t0.english_level AS english_level_18,
t0.created_at AS created_at_19,
t0.updated_at AS updated_at_20,
t0.structure_id AS structure_id_21,
t22.id AS id_23,
t22.avatar AS avatar_24,
t22.avatar_updated_at AS avatar_updated_at_25,
t22.cv AS cv_26,
t22.cv_updated_at AS cv_updated_at_27,
t22.rib AS rib_28,
t22.rib_updated_at AS rib_updated_at_29,
t22.id_card AS id_card_30,
t22.id_card_updated_at AS id_card_updated_at_31,
t22.taxe_notice AS taxe_notice_32,
t22.taxe_notice_updated_at AS taxe_notice_updated_at_33,
t22.attest_secu AS attest_secu_34,
t22.attest_secu_updated_at AS attest_secu_updated_at_35,
t22.vitale_card AS vitale_card_36,
t22.vitale_card_updated_at AS vitale_card_updated_at_37,
t22.address_proof AS address_proof_38,
t22.address_proof_updated_at AS address_proof_updated_at_39,
t22.created_at AS created_at_40,
t22.updated_at AS updated_at_41,
t22.owner_id AS owner_id_42
FROM
users t0
LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id
WHERE
t0.email = ?
LIMIT
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.email = 'sophie@dapres.fr' LIMIT 1;
|
| 2 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM roles t0 INNER JOIN roles_users ON t0.id = roles_users.role_id WHERE roles_users.user_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM roles t0 INNER JOIN roles_users ON t0.id = roles_users.role_id WHERE roles_users.user_id = 92;
|
| 3 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.location AS location_7, t0.seats AS seats_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.events_model_id AS events_model_id_11, t0.parent_id AS parent_id_12, t0.author_id AS author_id_13 FROM events t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.location AS location_7, t0.seats AS seats_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.events_model_id AS events_model_id_11, t0.parent_id AS parent_id_12, t0.author_id AS author_id_13 FROM events t0 WHERE t0.id = '9';
|
| 4 |
0.40 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.password AS password_3,
t0.first_name AS first_name_4,
t0.last_name AS last_name_5,
t0.birth_date AS birth_date_6,
t0.gender AS gender_7,
t0.address AS address_8,
t0.telephone AS telephone_9,
t0.nir AS nir_10,
t0.pro_situation AS pro_situation_11,
t0.personal_situation AS personal_situation_12,
t0.status AS status_13,
t0.mobility_area AS mobility_area_14,
t0.transport_means AS transport_means_15,
t0.education_level AS education_level_16,
t0.french_level AS french_level_17,
t0.english_level AS english_level_18,
t0.created_at AS created_at_19,
t0.updated_at AS updated_at_20,
t0.structure_id AS structure_id_21,
t22.id AS id_23,
t22.avatar AS avatar_24,
t22.avatar_updated_at AS avatar_updated_at_25,
t22.cv AS cv_26,
t22.cv_updated_at AS cv_updated_at_27,
t22.rib AS rib_28,
t22.rib_updated_at AS rib_updated_at_29,
t22.id_card AS id_card_30,
t22.id_card_updated_at AS id_card_updated_at_31,
t22.taxe_notice AS taxe_notice_32,
t22.taxe_notice_updated_at AS taxe_notice_updated_at_33,
t22.attest_secu AS attest_secu_34,
t22.attest_secu_updated_at AS attest_secu_updated_at_35,
t22.vitale_card AS vitale_card_36,
t22.vitale_card_updated_at AS vitale_card_updated_at_37,
t22.address_proof AS address_proof_38,
t22.address_proof_updated_at AS address_proof_updated_at_39,
t22.created_at AS created_at_40,
t22.updated_at AS updated_at_41,
t22.owner_id AS owner_id_42
FROM
users t0
LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.id = 65;
|
| 5 |
0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.author_id AS author_id_7, t0.parent_id AS parent_id_8 FROM events_models t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.author_id AS author_id_7, t0.parent_id AS parent_id_8 FROM events_models t0 WHERE t0.id = 9;
|
| 6 |
0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7 FROM events_types t0 INNER JOIN events_model_events_type ON t0.id = events_model_events_type.events_type_id WHERE events_model_events_type.events_model_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7 FROM events_types t0 INNER JOIN events_model_events_type ON t0.id = events_model_events_type.events_type_id WHERE events_model_events_type.events_model_id = 9;
|
| 7 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7 FROM events_types t0 INNER JOIN events_eventstypes ON t0.id = events_eventstypes.eventstype_id WHERE events_eventstypes.event_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7 FROM events_types t0 INNER JOIN events_eventstypes ON t0.id = events_eventstypes.eventstype_id WHERE events_eventstypes.event_id = 9;
|
| 8 |
0.27 ms |
SELECT t0.id AS id_1, t0.attendance AS attendance_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.course_id AS course_id_5, t0.event_id AS event_id_6 FROM registrations t0 WHERE t0.event_id = ?
SELECT t0.id AS id_1, t0.attendance AS attendance_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.course_id AS course_id_5, t0.event_id AS event_id_6 FROM registrations t0 WHERE t0.event_id = 9;
|
| 9 |
0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.acivityfield_id AS acivityfield_id_6, t0.owner_id AS owner_id_7 FROM sub_fields t0 INNER JOIN events_subfields ON t0.id = events_subfields.subfield_id WHERE events_subfields.event_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.acivityfield_id AS acivityfield_id_6, t0.owner_id AS owner_id_7 FROM sub_fields t0 INNER JOIN events_subfields ON t0.id = events_subfields.subfield_id WHERE events_subfields.event_id = 9;
|
| 10 |
0.47 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id INNER JOIN events_users ON t0.id = events_users.user_id WHERE events_users.event_id = ?
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.password AS password_3,
t0.first_name AS first_name_4,
t0.last_name AS last_name_5,
t0.birth_date AS birth_date_6,
t0.gender AS gender_7,
t0.address AS address_8,
t0.telephone AS telephone_9,
t0.nir AS nir_10,
t0.pro_situation AS pro_situation_11,
t0.personal_situation AS personal_situation_12,
t0.status AS status_13,
t0.mobility_area AS mobility_area_14,
t0.transport_means AS transport_means_15,
t0.education_level AS education_level_16,
t0.french_level AS french_level_17,
t0.english_level AS english_level_18,
t0.created_at AS created_at_19,
t0.updated_at AS updated_at_20,
t0.structure_id AS structure_id_21,
t22.id AS id_23,
t22.avatar AS avatar_24,
t22.avatar_updated_at AS avatar_updated_at_25,
t22.cv AS cv_26,
t22.cv_updated_at AS cv_updated_at_27,
t22.rib AS rib_28,
t22.rib_updated_at AS rib_updated_at_29,
t22.id_card AS id_card_30,
t22.id_card_updated_at AS id_card_updated_at_31,
t22.taxe_notice AS taxe_notice_32,
t22.taxe_notice_updated_at AS taxe_notice_updated_at_33,
t22.attest_secu AS attest_secu_34,
t22.attest_secu_updated_at AS attest_secu_updated_at_35,
t22.vitale_card AS vitale_card_36,
t22.vitale_card_updated_at AS vitale_card_updated_at_37,
t22.address_proof AS address_proof_38,
t22.address_proof_updated_at AS address_proof_updated_at_39,
t22.created_at AS created_at_40,
t22.updated_at AS updated_at_41,
t22.owner_id AS owner_id_42
FROM
users t0
LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id
INNER JOIN events_users ON t0.id = events_users.user_id
WHERE
events_users.event_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id INNER JOIN events_users ON t0.id = events_users.user_id WHERE events_users.event_id = 9;
|
| 11 |
0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.starts_at AS starts_at_4, t0.ends_at AS ends_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.candidate_id AS candidate_id_8, t0.prescriber_id AS prescriber_id_9, t0.referent_id AS referent_id_10, t0.courses_type_id AS courses_type_id_11 FROM courses t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.starts_at AS starts_at_4, t0.ends_at AS ends_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.candidate_id AS candidate_id_8, t0.prescriber_id AS prescriber_id_9, t0.referent_id AS referent_id_10, t0.courses_type_id AS courses_type_id_11 FROM courses t0 WHERE t0.id = 2;
|
| 12 |
0.44 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.password AS password_3,
t0.first_name AS first_name_4,
t0.last_name AS last_name_5,
t0.birth_date AS birth_date_6,
t0.gender AS gender_7,
t0.address AS address_8,
t0.telephone AS telephone_9,
t0.nir AS nir_10,
t0.pro_situation AS pro_situation_11,
t0.personal_situation AS personal_situation_12,
t0.status AS status_13,
t0.mobility_area AS mobility_area_14,
t0.transport_means AS transport_means_15,
t0.education_level AS education_level_16,
t0.french_level AS french_level_17,
t0.english_level AS english_level_18,
t0.created_at AS created_at_19,
t0.updated_at AS updated_at_20,
t0.structure_id AS structure_id_21,
t22.id AS id_23,
t22.avatar AS avatar_24,
t22.avatar_updated_at AS avatar_updated_at_25,
t22.cv AS cv_26,
t22.cv_updated_at AS cv_updated_at_27,
t22.rib AS rib_28,
t22.rib_updated_at AS rib_updated_at_29,
t22.id_card AS id_card_30,
t22.id_card_updated_at AS id_card_updated_at_31,
t22.taxe_notice AS taxe_notice_32,
t22.taxe_notice_updated_at AS taxe_notice_updated_at_33,
t22.attest_secu AS attest_secu_34,
t22.attest_secu_updated_at AS attest_secu_updated_at_35,
t22.vitale_card AS vitale_card_36,
t22.vitale_card_updated_at AS vitale_card_updated_at_37,
t22.address_proof AS address_proof_38,
t22.address_proof_updated_at AS address_proof_updated_at_39,
t22.created_at AS created_at_40,
t22.updated_at AS updated_at_41,
t22.owner_id AS owner_id_42
FROM
users t0
LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.id = 70;
|
| 13 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.starts_at AS starts_at_4, t0.ends_at AS ends_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.candidate_id AS candidate_id_8, t0.prescriber_id AS prescriber_id_9, t0.referent_id AS referent_id_10, t0.courses_type_id AS courses_type_id_11 FROM courses t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.starts_at AS starts_at_4, t0.ends_at AS ends_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.candidate_id AS candidate_id_8, t0.prescriber_id AS prescriber_id_9, t0.referent_id AS referent_id_10, t0.courses_type_id AS courses_type_id_11 FROM courses t0 WHERE t0.id = 1;
|
| 14 |
0.34 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.password AS password_3,
t0.first_name AS first_name_4,
t0.last_name AS last_name_5,
t0.birth_date AS birth_date_6,
t0.gender AS gender_7,
t0.address AS address_8,
t0.telephone AS telephone_9,
t0.nir AS nir_10,
t0.pro_situation AS pro_situation_11,
t0.personal_situation AS personal_situation_12,
t0.status AS status_13,
t0.mobility_area AS mobility_area_14,
t0.transport_means AS transport_means_15,
t0.education_level AS education_level_16,
t0.french_level AS french_level_17,
t0.english_level AS english_level_18,
t0.created_at AS created_at_19,
t0.updated_at AS updated_at_20,
t0.structure_id AS structure_id_21,
t22.id AS id_23,
t22.avatar AS avatar_24,
t22.avatar_updated_at AS avatar_updated_at_25,
t22.cv AS cv_26,
t22.cv_updated_at AS cv_updated_at_27,
t22.rib AS rib_28,
t22.rib_updated_at AS rib_updated_at_29,
t22.id_card AS id_card_30,
t22.id_card_updated_at AS id_card_updated_at_31,
t22.taxe_notice AS taxe_notice_32,
t22.taxe_notice_updated_at AS taxe_notice_updated_at_33,
t22.attest_secu AS attest_secu_34,
t22.attest_secu_updated_at AS attest_secu_updated_at_35,
t22.vitale_card AS vitale_card_36,
t22.vitale_card_updated_at AS vitale_card_updated_at_37,
t22.address_proof AS address_proof_38,
t22.address_proof_updated_at AS address_proof_updated_at_39,
t22.created_at AS created_at_40,
t22.updated_at AS updated_at_41,
t22.owner_id AS owner_id_42
FROM
users t0
LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.birth_date AS birth_date_6, t0.gender AS gender_7, t0.address AS address_8, t0.telephone AS telephone_9, t0.nir AS nir_10, t0.pro_situation AS pro_situation_11, t0.personal_situation AS personal_situation_12, t0.status AS status_13, t0.mobility_area AS mobility_area_14, t0.transport_means AS transport_means_15, t0.education_level AS education_level_16, t0.french_level AS french_level_17, t0.english_level AS english_level_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.structure_id AS structure_id_21, t22.id AS id_23, t22.avatar AS avatar_24, t22.avatar_updated_at AS avatar_updated_at_25, t22.cv AS cv_26, t22.cv_updated_at AS cv_updated_at_27, t22.rib AS rib_28, t22.rib_updated_at AS rib_updated_at_29, t22.id_card AS id_card_30, t22.id_card_updated_at AS id_card_updated_at_31, t22.taxe_notice AS taxe_notice_32, t22.taxe_notice_updated_at AS taxe_notice_updated_at_33, t22.attest_secu AS attest_secu_34, t22.attest_secu_updated_at AS attest_secu_updated_at_35, t22.vitale_card AS vitale_card_36, t22.vitale_card_updated_at AS vitale_card_updated_at_37, t22.address_proof AS address_proof_38, t22.address_proof_updated_at AS address_proof_updated_at_39, t22.created_at AS created_at_40, t22.updated_at AS updated_at_41, t22.owner_id AS owner_id_42 FROM users t0 LEFT JOIN candidate_files_safe t22 ON t22.owner_id = t0.id WHERE t0.id = 22;
|
| 15 |
0.31 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5, t0.survey_id AS survey_id_6, t0.event_id AS event_id_7, t0.course_id AS course_id_8 FROM responses t0 WHERE t0.event_id = ?
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5, t0.survey_id AS survey_id_6, t0.event_id AS event_id_7, t0.course_id AS course_id_8 FROM responses t0 WHERE t0.event_id = 9;
|
| 16 |
0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.location AS location_7, t0.seats AS seats_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.events_model_id AS events_model_id_11, t0.parent_id AS parent_id_12, t0.author_id AS author_id_13 FROM events t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.starts_at AS starts_at_5, t0.ends_at AS ends_at_6, t0.location AS location_7, t0.seats AS seats_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.events_model_id AS events_model_id_11, t0.parent_id AS parent_id_12, t0.author_id AS author_id_13 FROM events t0 WHERE t0.parent_id = 9;
|
| 17 |
0.34 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.comment AS comment_3, t0.status AS status_4, t0.version AS version_5, t0.open_time AS open_time_6, t0.close_time AS close_time_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.evaluation_mode AS evaluation_mode_10, t0.surveys_type_id AS surveys_type_id_11, t0.author_id AS author_id_12 FROM surveys t0 INNER JOIN survey_events_model ON t0.id = survey_events_model.survey_id WHERE survey_events_model.events_model_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.comment AS comment_3, t0.status AS status_4, t0.version AS version_5, t0.open_time AS open_time_6, t0.close_time AS close_time_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.evaluation_mode AS evaluation_mode_10, t0.surveys_type_id AS surveys_type_id_11, t0.author_id AS author_id_12 FROM surveys t0 INNER JOIN survey_events_model ON t0.id = survey_events_model.survey_id WHERE survey_events_model.events_model_id = 9;
|