1.08 ms (34.34%)
1
SELECT c0_ . id AS id_0 , c0_ . role_code AS role_code_1 , c0_ . date_debut AS date_debut_2 , c0_ . date_fin AS date_fin_3 , p1_ . id AS id_4 , p1_ . code AS code_5 , p1_ . nom AS nom_6 , p1_ . description AS description_7 , p1_ . prix AS prix_8 , p1_ . logo AS logo_9 , p1_ . banniere AS banniere_10 , p1_ . presentation AS presentation_11 , p1_ . site_officiel AS site_officiel_12 , p1_ . lien_plateforme AS lien_plateforme_13 , p1_ . base_prefix AS base_prefix_14 , p1_ . base_suffix AS base_suffix_15 , p1_ . api_service AS api_service_16 , p1_ . api_provisionning AS api_provisionning_17 , p1_ . db_host AS db_host_18 , p1_ . db_name AS db_name_19 , p1_ . db_user AS db_user_20 , p1_ . db_pass AS db_pass_21 , p1_ . base_url AS base_url_22 , p1_ . api_key AS api_key_23 , p1_ . numero_bpay AS numero_bpay_24 , p1_ . portail AS portail_25 , p1_ . ordre_portail AS ordre_portail_26 , p1_ . sous_compte_bpay AS sous_compte_bpay_27 , p1_ . updated_at AS updated_at_28 , e2_ . id AS id_29 , e2_ . nom AS nom_30 , e2_ . libelle AS libelle_31 , e2_ . logo AS logo_32 , e2_ . telephone AS telephone_33 , e2_ . email AS email_34 , e2_ . dgi_token AS dgi_token_35 , e2_ . site_web AS site_web_36 , e2_ . slogan AS slogan_37 , e2_ . gps AS gps_38 , e2_ . address AS address_39 , e2_ . code AS code_40 , e2_ . livrado AS livrado_41 , e2_ . businesspay AS businesspay_42 , e2_ . bpay_account AS bpay_account_43 , e2_ . businesspay_account AS businesspay_account_44 , e2_ . cashline_account AS cashline_account_45 , e2_ . careconcept_account AS careconcept_account_46 , e2_ . instantmark_account AS instantmark_account_47 , e3_ . id AS id_48 , e3_ . libelle AS libelle_49 , e3_ . logo AS logo_50 , e3_ . telephone AS telephone_51 , e3_ . email AS email_52 , e3_ . site_web AS site_web_53 , e3_ . gps AS gps_54 , e3_ . address AS address_55 , e3_ . description AS description_56 , e3_ . ifu AS ifu_57 , e3_ . rccm AS rccm_58 , e3_ . dgi_token AS dgi_token_59 , e3_ . bpay_account AS bpay_account_60 , e3_ . careconcept_account AS careconcept_account_61 , e3_ . businesspay_account AS businesspay_account_62 , e3_ . cashline_account AS cashline_account_63 , e3_ . instantmark_account AS instantmark_account_64 , c0_ . user_id AS user_id_65 , c0_ . entreprise_id AS entreprise_id_66 , c0_ . enseigne_id AS enseigne_id_67 , c0_ . plateforme_id AS plateforme_id_68 , e2_ . pays_id AS pays_id_69 , e2_ . entreprise_id AS entreprise_id_70 , e2_ . secteur_activite_id AS secteur_activite_id_71 , e2_ . pack_id AS pack_id_72 , e2_ . mode_integration_id AS mode_integration_id_73 , e3_ . user_id AS user_id_74 , e3_ . pays_id AS pays_id_75 FROM collaboration c0_ LEFT JOIN plateforme p1_ ON c0_ . plateforme_id = p1_ . id LEFT JOIN enseigne e2_ ON c0_ . enseigne_id = e2_ . id LEFT JOIN entreprise e3_ ON c0_ . entreprise_id = e3_ . id WHERE c0_ . user_id = ? AND (c0_ . date_fin IS NULL OR c0_ . date_fin > ? ) ORDER BY c0_ . date_debut DESC
Parameters :
[
37
"2026-01-24 22:38:44 "
]
SELECT
c0_ . id AS id_0 ,
c0_ . role_code AS role_code_1 ,
c0_ . date_debut AS date_debut_2 ,
c0_ . date_fin AS date_fin_3 ,
p1_ . id AS id_4 ,
p1_ . code AS code_5 ,
p1_ . nom AS nom_6 ,
p1_ . description AS description_7 ,
p1_ . prix AS prix_8 ,
p1_ . logo AS logo_9 ,
p1_ . banniere AS banniere_10 ,
p1_ . presentation AS presentation_11 ,
p1_ . site_officiel AS site_officiel_12 ,
p1_ . lien_plateforme AS lien_plateforme_13 ,
p1_ . base_prefix AS base_prefix_14 ,
p1_ . base_suffix AS base_suffix_15 ,
p1_ . api_service AS api_service_16 ,
p1_ . api_provisionning AS api_provisionning_17 ,
p1_ . db_host AS db_host_18 ,
p1_ . db_name AS db_name_19 ,
p1_ . db_user AS db_user_20 ,
p1_ . db_pass AS db_pass_21 ,
p1_ . base_url AS base_url_22 ,
p1_ . api_key AS api_key_23 ,
p1_ . numero_bpay AS numero_bpay_24 ,
p1_ . portail AS portail_25 ,
p1_ . ordre_portail AS ordre_portail_26 ,
p1_ . sous_compte_bpay AS sous_compte_bpay_27 ,
p1_ . updated_at AS updated_at_28 ,
e2_ . id AS id_29 ,
e2_ . nom AS nom_30 ,
e2_ . libelle AS libelle_31 ,
e2_ . logo AS logo_32 ,
e2_ . telephone AS telephone_33 ,
e2_ . email AS email_34 ,
e2_ . dgi_token AS dgi_token_35 ,
e2_ . site_web AS site_web_36 ,
e2_ . slogan AS slogan_37 ,
e2_ . gps AS gps_38 ,
e2_ . address AS address_39 ,
e2_ . code AS code_40 ,
e2_ . livrado AS livrado_41 ,
e2_ . businesspay AS businesspay_42 ,
e2_ . bpay_account AS bpay_account_43 ,
e2_ . businesspay_account AS businesspay_account_44 ,
e2_ . cashline_account AS cashline_account_45 ,
e2_ . careconcept_account AS careconcept_account_46 ,
e2_ . instantmark_account AS instantmark_account_47 ,
e3_ . id AS id_48 ,
e3_ . libelle AS libelle_49 ,
e3_ . logo AS logo_50 ,
e3_ . telephone AS telephone_51 ,
e3_ . email AS email_52 ,
e3_ . site_web AS site_web_53 ,
e3_ . gps AS gps_54 ,
e3_ . address AS address_55 ,
e3_ . description AS description_56 ,
e3_ . ifu AS ifu_57 ,
e3_ . rccm AS rccm_58 ,
e3_ . dgi_token AS dgi_token_59 ,
e3_ . bpay_account AS bpay_account_60 ,
e3_ . careconcept_account AS careconcept_account_61 ,
e3_ . businesspay_account AS businesspay_account_62 ,
e3_ . cashline_account AS cashline_account_63 ,
e3_ . instantmark_account AS instantmark_account_64 ,
c0_ . user_id AS user_id_65 ,
c0_ . entreprise_id AS entreprise_id_66 ,
c0_ . enseigne_id AS enseigne_id_67 ,
c0_ . plateforme_id AS plateforme_id_68 ,
e2_ . pays_id AS pays_id_69 ,
e2_ . entreprise_id AS entreprise_id_70 ,
e2_ . secteur_activite_id AS secteur_activite_id_71 ,
e2_ . pack_id AS pack_id_72 ,
e2_ . mode_integration_id AS mode_integration_id_73 ,
e3_ . user_id AS user_id_74 ,
e3_ . pays_id AS pays_id_75
FROM
collaboration c0_
LEFT JOIN plateforme p1_ ON c0_ . plateforme_id = p1_ . id
LEFT JOIN enseigne e2_ ON c0_ . enseigne_id = e2_ . id
LEFT JOIN entreprise e3_ ON c0_ . entreprise_id = e3_ . id
WHERE
c0_ . user_id = ?
AND (
c0_ . date_fin IS NULL
OR c0_ . date_fin > ?
)
ORDER BY
c0_ . date_debut DESC
Copy
SELECT c0_ . id AS id_0 , c0_ . role_code AS role_code_1 , c0_ . date_debut AS date_debut_2 , c0_ . date_fin AS date_fin_3 , p1_ . id AS id_4 , p1_ . code AS code_5 , p1_ . nom AS nom_6 , p1_ . description AS description_7 , p1_ . prix AS prix_8 , p1_ . logo AS logo_9 , p1_ . banniere AS banniere_10 , p1_ . presentation AS presentation_11 , p1_ . site_officiel AS site_officiel_12 , p1_ . lien_plateforme AS lien_plateforme_13 , p1_ . base_prefix AS base_prefix_14 , p1_ . base_suffix AS base_suffix_15 , p1_ . api_service AS api_service_16 , p1_ . api_provisionning AS api_provisionning_17 , p1_ . db_host AS db_host_18 , p1_ . db_name AS db_name_19 , p1_ . db_user AS db_user_20 , p1_ . db_pass AS db_pass_21 , p1_ . base_url AS base_url_22 , p1_ . api_key AS api_key_23 , p1_ . numero_bpay AS numero_bpay_24 , p1_ . portail AS portail_25 , p1_ . ordre_portail AS ordre_portail_26 , p1_ . sous_compte_bpay AS sous_compte_bpay_27 , p1_ . updated_at AS updated_at_28 , e2_ . id AS id_29 , e2_ . nom AS nom_30 , e2_ . libelle AS libelle_31 , e2_ . logo AS logo_32 , e2_ . telephone AS telephone_33 , e2_ . email AS email_34 , e2_ . dgi_token AS dgi_token_35 , e2_ . site_web AS site_web_36 , e2_ . slogan AS slogan_37 , e2_ . gps AS gps_38 , e2_ . address AS address_39 , e2_ . code AS code_40 , e2_ . livrado AS livrado_41 , e2_ . businesspay AS businesspay_42 , e2_ . bpay_account AS bpay_account_43 , e2_ . businesspay_account AS businesspay_account_44 , e2_ . cashline_account AS cashline_account_45 , e2_ . careconcept_account AS careconcept_account_46 , e2_ . instantmark_account AS instantmark_account_47 , e3_ . id AS id_48 , e3_ . libelle AS libelle_49 , e3_ . logo AS logo_50 , e3_ . telephone AS telephone_51 , e3_ . email AS email_52 , e3_ . site_web AS site_web_53 , e3_ . gps AS gps_54 , e3_ . address AS address_55 , e3_ . description AS description_56 , e3_ . ifu AS ifu_57 , e3_ . rccm AS rccm_58 , e3_ . dgi_token AS dgi_token_59 , e3_ . bpay_account AS bpay_account_60 , e3_ . careconcept_account AS careconcept_account_61 , e3_ . businesspay_account AS businesspay_account_62 , e3_ . cashline_account AS cashline_account_63 , e3_ . instantmark_account AS instantmark_account_64 , c0_ . user_id AS user_id_65 , c0_ . entreprise_id AS entreprise_id_66 , c0_ . enseigne_id AS enseigne_id_67 , c0_ . plateforme_id AS plateforme_id_68 , e2_ . pays_id AS pays_id_69 , e2_ . entreprise_id AS entreprise_id_70 , e2_ . secteur_activite_id AS secteur_activite_id_71 , e2_ . pack_id AS pack_id_72 , e2_ . mode_integration_id AS mode_integration_id_73 , e3_ . user_id AS user_id_74 , e3_ . pays_id AS pays_id_75 FROM collaboration c0_ LEFT JOIN plateforme p1_ ON c0_ . plateforme_id = p1_ . id LEFT JOIN enseigne e2_ ON c0_ . enseigne_id = e2_ . id LEFT JOIN entreprise e3_ ON c0_ . entreprise_id = e3_ . id WHERE c0_ . user_id = 37 AND (c0_ . date_fin IS NULL OR c0_ . date_fin > '2026-01-24 22:38:44' ) ORDER BY c0_ . date_debut DESC ;
Copy
0.84 ms (26.71%)
1
SELECT t0 . id AS id_1 , t0 . uuid AS uuid_2 , t0 . prenom AS prenom_3 , t0 . nom AS nom_4 , t0 . email AS email_5 , t0 . telephone AS telephone_6 , t0 . ifu AS ifu_7 , t0 . password AS password_8 , t0 . roles AS roles_9 , t0 . photo_profil AS photo_profil_10 , t0 . type_compte AS type_compte_11 , t0 . confirmation_token AS confirmation_token_12 , t0 . reset_password_token AS reset_password_token_13 , t0 . reset_password_requested_at AS reset_password_requested_at_14 , t0 . is_verified AS is_verified_15 , t0 . confirmed_at AS confirmed_at_16 , t0 . last_confirmation_email_sent_at AS last_confirmation_email_sent_at_17 , t0 . bpay_account AS bpay_account_18 , t0 . careconcept_account AS careconcept_account_19 , t0 . businesspay_account AS businesspay_account_20 , t0 . cashline_account AS cashline_account_21 , t0 . instantmark_account AS instantmark_account_22 FROM users t0 WHERE t0 . email = ? LIMIT 1
Parameters :
[
"honorine.beakou@danone.com "
]
SELECT t0 . id AS id_1 , t0 . uuid AS uuid_2 , t0 . prenom AS prenom_3 , t0 . nom AS nom_4 , t0 . email AS email_5 , t0 . telephone AS telephone_6 , t0 . ifu AS ifu_7 , t0 . password AS password_8 , t0 . roles AS roles_9 , t0 . photo_profil AS photo_profil_10 , t0 . type_compte AS type_compte_11 , t0 . confirmation_token AS confirmation_token_12 , t0 . reset_password_token AS reset_password_token_13 , t0 . reset_password_requested_at AS reset_password_requested_at_14 , t0 . is_verified AS is_verified_15 , t0 . confirmed_at AS confirmed_at_16 , t0 . last_confirmation_email_sent_at AS last_confirmation_email_sent_at_17 , t0 . bpay_account AS bpay_account_18 , t0 . careconcept_account AS careconcept_account_19 , t0 . businesspay_account AS businesspay_account_20 , t0 . cashline_account AS cashline_account_21 , t0 . instantmark_account AS instantmark_account_22 FROM users t0 WHERE t0 . email = 'honorine.beakou@danone.com' LIMIT 1 ;
Copy