0.77 ms (46.67%)
1
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . last_email_verification_send AS last_email_verification_send_5 , t0 . organization_id AS organization_id_6 , t7 . id AS id_8 , t7 . company_name AS company_name_9 , t7 . website AS website_10 , t7 . address AS address_11 , t7 . phone AS phone_12 , t7 . contact_email AS contact_email_13 , t7 . opening_hours AS opening_hours_14 , t7 . siret AS siret_15 , t7 . ape_naf AS ape_naf_16 , t7 . declaration_number AS declaration_number_17 , t7 . region AS region_18 , t7 . tva AS tva_19 , t7 . manager_lastname AS manager_lastname_20 , t7 . manager_firstname AS manager_firstname_21 , t7 . logo_path AS logo_path_22 , t7 . thumbnail_path AS thumbnail_path_23 , t7 . stamp_path AS stamp_path_24 , t7 . signature_path AS signature_path_25 , t7 . qualiopi_certified AS qualiopi_certified_26 , t7 . certificate_number AS certificate_number_27 , t7 . visibility AS visibility_28 , t7 . completed_after_registration AS completed_after_registration_29 , t7 . enabled AS enabled_30 , t7 . stripe_id AS stripe_id_31 , t7 . verified AS verified_32 , t7 . created_at AS created_at_33 , t7 . trial_days AS trial_days_34 , t7 . subscription_email AS subscription_email_35 , t7 . notif_sent AS notif_sent_36 , t7 . actions_nature AS actions_nature_37 , t7 . activate_qualiopi_mention AS activate_qualiopi_mention_38 , t7 . qualiopi_certificate_path AS qualiopi_certificate_path_39 , t0 . former_id AS former_id_40 , t41 . id AS id_42 , t41 . firstname AS firstname_43 , t41 . lastname AS lastname_44 , t41 . email AS email_45 , t41 . phone AS phone_46 , t41 . main_activity AS main_activity_47 , t41 . title AS title_48 , t41 . quality AS quality_49 , t41 . business_activity AS business_activity_50 , t41 . professionnal_career AS professionnal_career_51 , t41 . formation AS formation_52 , t41 . continuous_formation AS continuous_formation_53 , t41 . cv_path AS cv_path_54 , t41 . signature_path AS signature_path_55 , t41 . diploma_path AS diploma_path_56 , t41 . status AS status_57 , t41 . organization_id AS organization_id_58 FROM user t0 LEFT JOIN organization t7 ON t0 . organization_id = t7 . id LEFT JOIN former t41 ON t0 . former_id = t41 . id WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . email AS email_2 ,
t0 . roles AS roles_3 ,
t0 . password AS password_4 ,
t0 . last_email_verification_send AS last_email_verification_send_5 ,
t0 . organization_id AS organization_id_6 ,
t7 . id AS id_8 ,
t7 . company_name AS company_name_9 ,
t7 . website AS website_10 ,
t7 . address AS address_11 ,
t7 . phone AS phone_12 ,
t7 . contact_email AS contact_email_13 ,
t7 . opening_hours AS opening_hours_14 ,
t7 . siret AS siret_15 ,
t7 . ape_naf AS ape_naf_16 ,
t7 . declaration_number AS declaration_number_17 ,
t7 . region AS region_18 ,
t7 . tva AS tva_19 ,
t7 . manager_lastname AS manager_lastname_20 ,
t7 . manager_firstname AS manager_firstname_21 ,
t7 . logo_path AS logo_path_22 ,
t7 . thumbnail_path AS thumbnail_path_23 ,
t7 . stamp_path AS stamp_path_24 ,
t7 . signature_path AS signature_path_25 ,
t7 . qualiopi_certified AS qualiopi_certified_26 ,
t7 . certificate_number AS certificate_number_27 ,
t7 . visibility AS visibility_28 ,
t7 . completed_after_registration AS completed_after_registration_29 ,
t7 . enabled AS enabled_30 ,
t7 . stripe_id AS stripe_id_31 ,
t7 . verified AS verified_32 ,
t7 . created_at AS created_at_33 ,
t7 . trial_days AS trial_days_34 ,
t7 . subscription_email AS subscription_email_35 ,
t7 . notif_sent AS notif_sent_36 ,
t7 . actions_nature AS actions_nature_37 ,
t7 . activate_qualiopi_mention AS activate_qualiopi_mention_38 ,
t7 . qualiopi_certificate_path AS qualiopi_certificate_path_39 ,
t0 . former_id AS former_id_40 ,
t41 . id AS id_42 ,
t41 . firstname AS firstname_43 ,
t41 . lastname AS lastname_44 ,
t41 . email AS email_45 ,
t41 . phone AS phone_46 ,
t41 . main_activity AS main_activity_47 ,
t41 . title AS title_48 ,
t41 . quality AS quality_49 ,
t41 . business_activity AS business_activity_50 ,
t41 . professionnal_career AS professionnal_career_51 ,
t41 . formation AS formation_52 ,
t41 . continuous_formation AS continuous_formation_53 ,
t41 . cv_path AS cv_path_54 ,
t41 . signature_path AS signature_path_55 ,
t41 . diploma_path AS diploma_path_56 ,
t41 . status AS status_57 ,
t41 . organization_id AS organization_id_58
FROM
user t0
LEFT JOIN organization t7 ON t0 . organization_id = t7 . id
LEFT JOIN former t41 ON t0 . former_id = t41 . id
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . last_email_verification_send AS last_email_verification_send_5 , t0 . organization_id AS organization_id_6 , t7 . id AS id_8 , t7 . company_name AS company_name_9 , t7 . website AS website_10 , t7 . address AS address_11 , t7 . phone AS phone_12 , t7 . contact_email AS contact_email_13 , t7 . opening_hours AS opening_hours_14 , t7 . siret AS siret_15 , t7 . ape_naf AS ape_naf_16 , t7 . declaration_number AS declaration_number_17 , t7 . region AS region_18 , t7 . tva AS tva_19 , t7 . manager_lastname AS manager_lastname_20 , t7 . manager_firstname AS manager_firstname_21 , t7 . logo_path AS logo_path_22 , t7 . thumbnail_path AS thumbnail_path_23 , t7 . stamp_path AS stamp_path_24 , t7 . signature_path AS signature_path_25 , t7 . qualiopi_certified AS qualiopi_certified_26 , t7 . certificate_number AS certificate_number_27 , t7 . visibility AS visibility_28 , t7 . completed_after_registration AS completed_after_registration_29 , t7 . enabled AS enabled_30 , t7 . stripe_id AS stripe_id_31 , t7 . verified AS verified_32 , t7 . created_at AS created_at_33 , t7 . trial_days AS trial_days_34 , t7 . subscription_email AS subscription_email_35 , t7 . notif_sent AS notif_sent_36 , t7 . actions_nature AS actions_nature_37 , t7 . activate_qualiopi_mention AS activate_qualiopi_mention_38 , t7 . qualiopi_certificate_path AS qualiopi_certificate_path_39 , t0 . former_id AS former_id_40 , t41 . id AS id_42 , t41 . firstname AS firstname_43 , t41 . lastname AS lastname_44 , t41 . email AS email_45 , t41 . phone AS phone_46 , t41 . main_activity AS main_activity_47 , t41 . title AS title_48 , t41 . quality AS quality_49 , t41 . business_activity AS business_activity_50 , t41 . professionnal_career AS professionnal_career_51 , t41 . formation AS formation_52 , t41 . continuous_formation AS continuous_formation_53 , t41 . cv_path AS cv_path_54 , t41 . signature_path AS signature_path_55 , t41 . diploma_path AS diploma_path_56 , t41 . status AS status_57 , t41 . organization_id AS organization_id_58 FROM user t0 LEFT JOIN organization t7 ON t0 . organization_id = t7 . id LEFT JOIN former t41 ON t0 . former_id = t41 . id WHERE t0 . id = 1 ;
Copy
0.40 ms (24.00%)
1
SELECT t0 . id AS id_1 , t0 . date_last_update AS date_last_update_2 , t0 . bases AS bases_3 , t0 . infos_given_to_intern AS infos_given_to_intern_4 , t0 . infos_required_from_intern AS infos_required_from_intern_5 , t0 . health AS health_6 , t0 . health_general_principles AS health_general_principles_7 , t0 . health_fire_instructions AS health_fire_instructions_8 , t0 . health_alcohol AS health_alcohol_9 , t0 . health_smoke AS health_smoke_10 , t0 . health_animals AS health_animals_11 , t0 . health_accident AS health_accident_12 , t0 . general_discipline_follow_up AS general_discipline_follow_up_13 , t0 . general_discipline_attendance AS general_discipline_attendance_14 , t0 . general_discipline_offices_access AS general_discipline_offices_access_15 , t0 . general_discipline_dress AS general_discipline_dress_16 , t0 . general_discipline_behaviour AS general_discipline_behaviour_17 , t0 . general_discipline_use_equipment AS general_discipline_use_equipment_18 , t0 . general_discipline_participation AS general_discipline_participation_19 , t0 . general_discipline_copyright AS general_discipline_copyright_20 , t0 . discipline_penalties AS discipline_penalties_21 , t0 . representation_interns AS representation_interns_22 , t0 . publication_internal_rules AS publication_internal_rules_23 , t0 . complaints_procedure AS complaints_procedure_24 , t0 . file_path AS file_path_25 , t0 . organization_id AS organization_id_26 FROM internal_rules t0 WHERE t0 . organization_id = ?
SELECT t0 . id AS id_1 , t0 . date_last_update AS date_last_update_2 , t0 . bases AS bases_3 , t0 . infos_given_to_intern AS infos_given_to_intern_4 , t0 . infos_required_from_intern AS infos_required_from_intern_5 , t0 . health AS health_6 , t0 . health_general_principles AS health_general_principles_7 , t0 . health_fire_instructions AS health_fire_instructions_8 , t0 . health_alcohol AS health_alcohol_9 , t0 . health_smoke AS health_smoke_10 , t0 . health_animals AS health_animals_11 , t0 . health_accident AS health_accident_12 , t0 . general_discipline_follow_up AS general_discipline_follow_up_13 , t0 . general_discipline_attendance AS general_discipline_attendance_14 , t0 . general_discipline_offices_access AS general_discipline_offices_access_15 , t0 . general_discipline_dress AS general_discipline_dress_16 , t0 . general_discipline_behaviour AS general_discipline_behaviour_17 , t0 . general_discipline_use_equipment AS general_discipline_use_equipment_18 , t0 . general_discipline_participation AS general_discipline_participation_19 , t0 . general_discipline_copyright AS general_discipline_copyright_20 , t0 . discipline_penalties AS discipline_penalties_21 , t0 . representation_interns AS representation_interns_22 , t0 . publication_internal_rules AS publication_internal_rules_23 , t0 . complaints_procedure AS complaints_procedure_24 , t0 . file_path AS file_path_25 , t0 . organization_id AS organization_id_26 FROM internal_rules t0 WHERE t0 . organization_id = 1 ;
Copy