1
0.23 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . nom AS nom_3 , t0 . prenoms AS prenoms_4 , t0 . telephone AS telephone_5 , t0 . roles AS roles_6 , t0 . password AS password_7 , t0 . is_active AS is_active_8 , t0 . is_email_auth_enabled AS is_email_auth_enabled_9 , t0 . is_sms_auth_enabled AS is_sms_auth_enabled_10 , t0 . auth_code AS auth_code_11 , t0 . created_at AS created_at_12 , t0 . updated_at AS updated_at_13 , t0 . avatar AS avatar_14 , t0 . push_token AS push_token_15 , t0 . push_subscription AS push_subscription_16 , t0 . must_change_password AS must_change_password_17 , t0 . agence_id AS agence_id_18 , t0 . service_transfert_id AS service_transfert_id_19 , t20 . id AS id_21 , t20 . nom AS nom_22 , t20 . prenoms AS prenoms_23 , t20 . contact AS contact_24 , t20 . email AS email_25 , t20 . registre_commerce AS registre_commerce_26 , t20 . profession AS profession_27 , t20 . created_at AS created_at_28 , t20 . ifu AS ifu_29 , t20 . code_client AS code_client_30 , t20 . created_by_id AS created_by_id_31 , t20 . agence_id AS agence_id_32 , t20 . user_id AS user_id_33 FROM user t0 LEFT JOIN client t20 ON t20 . user_id = t0 . id WHERE t0 . email = ? LIMIT 1
Parameters :
[
"zantoinette@retouralasourcefx.com "
]
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . nom AS nom_3 , t0 . prenoms AS prenoms_4 , t0 . telephone AS telephone_5 , t0 . roles AS roles_6 , t0 . password AS password_7 , t0 . is_active AS is_active_8 , t0 . is_email_auth_enabled AS is_email_auth_enabled_9 , t0 . is_sms_auth_enabled AS is_sms_auth_enabled_10 , t0 . auth_code AS auth_code_11 , t0 . created_at AS created_at_12 , t0 . updated_at AS updated_at_13 , t0 . avatar AS avatar_14 , t0 . push_token AS push_token_15 , t0 . push_subscription AS push_subscription_16 , t0 . must_change_password AS must_change_password_17 , t0 . agence_id AS agence_id_18 , t0 . service_transfert_id AS service_transfert_id_19 , t20 . id AS id_21 , t20 . nom AS nom_22 , t20 . prenoms AS prenoms_23 , t20 . contact AS contact_24 , t20 . email AS email_25 , t20 . registre_commerce AS registre_commerce_26 , t20 . profession AS profession_27 , t20 . created_at AS created_at_28 , t20 . ifu AS ifu_29 , t20 . code_client AS code_client_30 , t20 . created_by_id AS created_by_id_31 , t20 . agence_id AS agence_id_32 , t20 . user_id AS user_id_33 FROM user t0 LEFT JOIN client t20 ON t20 . user_id = t0 . id WHERE t0 . email = 'zantoinette@retouralasourcefx.com' LIMIT 1 ;
Copy
2
0.14 ms
SELECT a0_ . id AS id_0 , a0_ . date_debut AS date_debut_1 , a0_ . is_active AS is_active_2 , a0_ . is_appro_initial_valide AS is_appro_initial_valide_3 , a0_ . date_fin AS date_fin_4 , a0_ . caissier_id AS caissier_id_5 , a0_ . caisse_id AS caisse_id_6 FROM affectation_caisse a0_ WHERE a0_ . caissier_id = ? AND a0_ . is_active = ? AND a0_ . date_debut < = ? AND (a0_ . date_fin IS NULL OR a0_ . date_fin > = ? ) ORDER BY a0_ . date_debut DESC LIMIT 1
Parameters :
[
20
1
"2026-07-31 13:02:34 "
"2026-07-31 13:02:34 "
]
SELECT a0_ . id AS id_0 , a0_ . date_debut AS date_debut_1 , a0_ . is_active AS is_active_2 , a0_ . is_appro_initial_valide AS is_appro_initial_valide_3 , a0_ . date_fin AS date_fin_4 , a0_ . caissier_id AS caissier_id_5 , a0_ . caisse_id AS caisse_id_6 FROM affectation_caisse a0_ WHERE a0_ . caissier_id = 20 AND a0_ . is_active = 1 AND a0_ . date_debut < = '2026-07-31 13:02:34' AND (a0_ . date_fin IS NULL OR a0_ . date_fin > = '2026-07-31 13:02:34' ) ORDER BY a0_ . date_debut DESC LIMIT 1 ;
Copy
3
0.27 ms
DELETE FROM user_sessions WHERE last_activity < ?
Parameters :
[
"2026-07-31 12:47:34 "
]
DELETE FROM user_sessions WHERE last_activity < '2026-07-31 12:47:34' ;
Copy
4
0.11 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . prenoms AS prenoms_3 , t0 . contact AS contact_4 , t0 . email AS email_5 , t0 . registre_commerce AS registre_commerce_6 , t0 . profession AS profession_7 , t0 . created_at AS created_at_8 , t0 . ifu AS ifu_9 , t0 . code_client AS code_client_10 , t0 . created_by_id AS created_by_id_11 , t0 . agence_id AS agence_id_12 , t0 . user_id AS user_id_13 FROM client t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . prenoms AS prenoms_3 , t0 . contact AS contact_4 , t0 . email AS email_5 , t0 . registre_commerce AS registre_commerce_6 , t0 . profession AS profession_7 , t0 . created_at AS created_at_8 , t0 . ifu AS ifu_9 , t0 . code_client AS code_client_10 , t0 . created_by_id AS created_by_id_11 , t0 . agence_id AS agence_id_12 , t0 . user_id AS user_id_13 FROM client t0 WHERE t0 . id = '66' ;
Copy
5
0.10 ms
SELECT t0 . id AS id_1 , t0 . numero_profil_compte AS numero_profil_compte_2 , t0 . is_actif AS is_actif_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . client_id AS client_id_6 , t0 . type_client_id AS type_client_id_7 FROM profil_client t0 WHERE t0 . client_id = ?
SELECT t0 . id AS id_1 , t0 . numero_profil_compte AS numero_profil_compte_2 , t0 . is_actif AS is_actif_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . client_id AS client_id_6 , t0 . type_client_id AS type_client_id_7 FROM profil_client t0 WHERE t0 . client_id = 66 ;
Copy
6
0.09 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 FROM type_client t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 FROM type_client t0 WHERE t0 . id = 1 ;
Copy
7
0.31 ms
SELECT t0 . id AS id_1 , t0 . solde_initial AS solde_initial_2 , t0 . solde_actuel AS solde_actuel_3 , t0 . created_at AS created_at_4 , t0 . devise_id AS devise_id_5 , t0 . profil_client_id AS profil_client_id_6 FROM compte_client t0 WHERE t0 . profil_client_id = ?
SELECT t0 . id AS id_1 , t0 . solde_initial AS solde_initial_2 , t0 . solde_actuel AS solde_actuel_3 , t0 . created_at AS created_at_4 , t0 . devise_id AS devise_id_5 , t0 . profil_client_id AS profil_client_id_6 FROM compte_client t0 WHERE t0 . profil_client_id = 66 ;
Copy
8
0.10 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = 1 ;
Copy
9
0.09 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = 2 ;
Copy
10
0.08 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = 3 ;
Copy
11
0.08 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = 4 ;
Copy
12
0.07 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = 5 ;
Copy
13
0.08 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = 6 ;
Copy
14
0.08 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code_iso AS code_iso_3 , t0 . symbole AS symbole_4 , t0 . is_active AS is_active_5 , t0 . created_at AS created_at_6 FROM devise t0 WHERE t0 . id = 7 ;
Copy
15
0.10 ms
SELECT t0 . id AS id_1 , t0 . montant_principal AS montant_principal_2 , t0 . montant_restant AS montant_restant_3 , t0 . taux_interet_annuel AS taux_interet_annuel_4 , t0 . duree_mois AS duree_mois_5 , t0 . date_echeance AS date_echeance_6 , t0 . contrat_signe AS contrat_signe_7 , t0 . montant_total_rembourse AS montant_total_rembourse_8 , t0 . statut AS statut_9 , t0 . commentaire AS commentaire_10 , t0 . created_at AS created_at_11 , t0 . profil_client_id AS profil_client_id_12 , t0 . devise_id AS devise_id_13 , t0 . agent_octroi_id AS agent_octroi_id_14 , t0 . agence_id AS agence_id_15 , t0 . caisse_id AS caisse_id_16 FROM pret t0 WHERE t0 . profil_client_id = ?
SELECT t0 . id AS id_1 , t0 . montant_principal AS montant_principal_2 , t0 . montant_restant AS montant_restant_3 , t0 . taux_interet_annuel AS taux_interet_annuel_4 , t0 . duree_mois AS duree_mois_5 , t0 . date_echeance AS date_echeance_6 , t0 . contrat_signe AS contrat_signe_7 , t0 . montant_total_rembourse AS montant_total_rembourse_8 , t0 . statut AS statut_9 , t0 . commentaire AS commentaire_10 , t0 . created_at AS created_at_11 , t0 . profil_client_id AS profil_client_id_12 , t0 . devise_id AS devise_id_13 , t0 . agent_octroi_id AS agent_octroi_id_14 , t0 . agence_id AS agence_id_15 , t0 . caisse_id AS caisse_id_16 FROM pret t0 WHERE t0 . profil_client_id = 66 ;
Copy