| 1 |
2.13 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;
|
| 3 |
0.54 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 = '3';
|