1
1.37 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . email AS email_3 , t0 . phone_number AS phone_number_4 , t0 . roles AS roles_5 , t0 . password AS password_6 FROM user t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . email AS email_3 , t0 . phone_number AS phone_number_4 , t0 . roles AS roles_5 , t0 . password AS password_6 FROM user t0 WHERE t0 . id = 1 ;
Copy
2
0.42 ms
SELECT t0 . id AS id_1 , t0 . date_ouverture AS date_ouverture_2 , t0 . caissier_nom AS caissier_nom_3 , t0 . orange AS orange_4 , t0 . orange2 AS orange2_5 , t0 . mtn AS mtn_6 , t0 . mtn2 AS mtn2_7 , t0 . wave AS wave_8 , t0 . wave2 AS wave2_9 , t0 . push AS push_10 , t0 . tresor_money AS tresor_money_11 , t0 . moov AS moov_12 , t0 . transfert AS transfert_13 , t0 . billet AS billet_14 , t0 . monnaie AS monnaie_15 , t0 . total_fermeture AS total_fermeture_16 , t0 . caissier_id AS caissier_id_17 , t0 . fermeture_id AS fermeture_id_18 FROM caisse t0 WHERE t0 . caissier_id = ? ORDER BY t0 . date_ouverture DESC
SELECT t0 . id AS id_1 , t0 . date_ouverture AS date_ouverture_2 , t0 . caissier_nom AS caissier_nom_3 , t0 . orange AS orange_4 , t0 . orange2 AS orange2_5 , t0 . mtn AS mtn_6 , t0 . mtn2 AS mtn2_7 , t0 . wave AS wave_8 , t0 . wave2 AS wave2_9 , t0 . push AS push_10 , t0 . tresor_money AS tresor_money_11 , t0 . moov AS moov_12 , t0 . transfert AS transfert_13 , t0 . billet AS billet_14 , t0 . monnaie AS monnaie_15 , t0 . total_fermeture AS total_fermeture_16 , t0 . caissier_id AS caissier_id_17 , t0 . fermeture_id AS fermeture_id_18 FROM caisse t0 WHERE t0 . caissier_id = 1 ORDER BY t0 . date_ouverture DESC ;
Copy
3
0.51 ms
SELECT c0_ . id AS id_0 , c0_ . date_ouverture AS date_ouverture_1 , c0_ . caissier_nom AS caissier_nom_2 , c0_ . orange AS orange_3 , c0_ . orange2 AS orange2_4 , c0_ . mtn AS mtn_5 , c0_ . mtn2 AS mtn2_6 , c0_ . wave AS wave_7 , c0_ . wave2 AS wave2_8 , c0_ . push AS push_9 , c0_ . tresor_money AS tresor_money_10 , c0_ . moov AS moov_11 , c0_ . transfert AS transfert_12 , c0_ . billet AS billet_13 , c0_ . monnaie AS monnaie_14 , c0_ . total_fermeture AS total_fermeture_15 , c1_ . id AS id_16 , c1_ . date_fermeture AS date_fermeture_17 , c1_ . orange AS orange_18 , c1_ . orange2 AS orange2_19 , c1_ . mtn AS mtn_20 , c1_ . mtn2 AS mtn2_21 , c1_ . wave AS wave_22 , c1_ . wave2 AS wave2_23 , c1_ . push AS push_24 , c1_ . tresor_money AS tresor_money_25 , c1_ . moov AS moov_26 , c1_ . transfert AS transfert_27 , c1_ . billet AS billet_28 , c1_ . monnaie AS monnaie_29 , m2_ . id AS id_30 , m2_ . type AS type_31 , m2_ . montant AS montant_32 , m2_ . date AS date_33 , m2_ . libelle AS libelle_34 , m2_ . libelle2 AS libelle2_35 , c0_ . caissier_id AS caissier_id_36 , c0_ . fermeture_id AS fermeture_id_37 , c1_ . caisse_id AS caisse_id_38 , m2_ . caisse_id AS caisse_id_39 FROM caisse c0_ LEFT JOIN caisse_fermeture c1_ ON c0_ . fermeture_id = c1_ . id LEFT JOIN mouvement m2_ ON c0_ . id = m2_ . caisse_id WHERE c0_ . caissier_id = ? AND (c1_ . date_fermeture BETWEEN ? AND ? )
Parameters :
[
1
"2026-06-01 00:00:00 "
"2026-06-30 23:59:59 "
]
SELECT c0_ . id AS id_0 , c0_ . date_ouverture AS date_ouverture_1 , c0_ . caissier_nom AS caissier_nom_2 , c0_ . orange AS orange_3 , c0_ . orange2 AS orange2_4 , c0_ . mtn AS mtn_5 , c0_ . mtn2 AS mtn2_6 , c0_ . wave AS wave_7 , c0_ . wave2 AS wave2_8 , c0_ . push AS push_9 , c0_ . tresor_money AS tresor_money_10 , c0_ . moov AS moov_11 , c0_ . transfert AS transfert_12 , c0_ . billet AS billet_13 , c0_ . monnaie AS monnaie_14 , c0_ . total_fermeture AS total_fermeture_15 , c1_ . id AS id_16 , c1_ . date_fermeture AS date_fermeture_17 , c1_ . orange AS orange_18 , c1_ . orange2 AS orange2_19 , c1_ . mtn AS mtn_20 , c1_ . mtn2 AS mtn2_21 , c1_ . wave AS wave_22 , c1_ . wave2 AS wave2_23 , c1_ . push AS push_24 , c1_ . tresor_money AS tresor_money_25 , c1_ . moov AS moov_26 , c1_ . transfert AS transfert_27 , c1_ . billet AS billet_28 , c1_ . monnaie AS monnaie_29 , m2_ . id AS id_30 , m2_ . type AS type_31 , m2_ . montant AS montant_32 , m2_ . date AS date_33 , m2_ . libelle AS libelle_34 , m2_ . libelle2 AS libelle2_35 , c0_ . caissier_id AS caissier_id_36 , c0_ . fermeture_id AS fermeture_id_37 , c1_ . caisse_id AS caisse_id_38 , m2_ . caisse_id AS caisse_id_39 FROM caisse c0_ LEFT JOIN caisse_fermeture c1_ ON c0_ . fermeture_id = c1_ . id LEFT JOIN mouvement m2_ ON c0_ . id = m2_ . caisse_id WHERE c0_ . caissier_id = 1 AND (c1_ . date_fermeture BETWEEN '2026-06-01 00:00:00' AND '2026-06-30 23:59:59' );
Copy
4
2.11 ms
SELECT c0_ . id AS id_0 , c0_ . date_ouverture AS date_ouverture_1 , c0_ . caissier_nom AS caissier_nom_2 , c0_ . orange AS orange_3 , c0_ . orange2 AS orange2_4 , c0_ . mtn AS mtn_5 , c0_ . mtn2 AS mtn2_6 , c0_ . wave AS wave_7 , c0_ . wave2 AS wave2_8 , c0_ . push AS push_9 , c0_ . tresor_money AS tresor_money_10 , c0_ . moov AS moov_11 , c0_ . transfert AS transfert_12 , c0_ . billet AS billet_13 , c0_ . monnaie AS monnaie_14 , c0_ . total_fermeture AS total_fermeture_15 , c0_ . caissier_id AS caissier_id_16 , c0_ . fermeture_id AS fermeture_id_17 FROM caisse c0_ WHERE c0_ . date_ouverture > = ? AND c0_ . date_ouverture < ? ORDER BY c0_ . date_ouverture DESC
Parameters :
[
"2026-06-15 00:00:00 "
"2026-06-16 00:00:00 "
]
SELECT c0_ . id AS id_0 , c0_ . date_ouverture AS date_ouverture_1 , c0_ . caissier_nom AS caissier_nom_2 , c0_ . orange AS orange_3 , c0_ . orange2 AS orange2_4 , c0_ . mtn AS mtn_5 , c0_ . mtn2 AS mtn2_6 , c0_ . wave AS wave_7 , c0_ . wave2 AS wave2_8 , c0_ . push AS push_9 , c0_ . tresor_money AS tresor_money_10 , c0_ . moov AS moov_11 , c0_ . transfert AS transfert_12 , c0_ . billet AS billet_13 , c0_ . monnaie AS monnaie_14 , c0_ . total_fermeture AS total_fermeture_15 , c0_ . caissier_id AS caissier_id_16 , c0_ . fermeture_id AS fermeture_id_17 FROM caisse c0_ WHERE c0_ . date_ouverture > = '2026-06-15 00:00:00' AND c0_ . date_ouverture < '2026-06-16 00:00:00' ORDER BY c0_ . date_ouverture DESC ;
Copy
5
0.35 ms
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = 1531 ;
Copy
6
0.34 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = 1538 ;
Copy
7
0.33 ms
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = 1532 ;
Copy
8
0.32 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = 1537 ;
Copy
9
0.34 ms
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = 1528 ;
Copy
10
0.33 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = 1536 ;
Copy
11
0.36 ms
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = 1529 ;
Copy
12
0.34 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = 1535 ;
Copy
13
0.32 ms
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . date_fermeture AS date_fermeture_2 , t0 . orange AS orange_3 , t0 . orange2 AS orange2_4 , t0 . mtn AS mtn_5 , t0 . mtn2 AS mtn2_6 , t0 . wave AS wave_7 , t0 . wave2 AS wave2_8 , t0 . push AS push_9 , t0 . tresor_money AS tresor_money_10 , t0 . moov AS moov_11 , t0 . transfert AS transfert_12 , t0 . billet AS billet_13 , t0 . monnaie AS monnaie_14 , t0 . caisse_id AS caisse_id_15 FROM caisse_fermeture t0 WHERE t0 . id = 1530 ;
Copy
14
0.31 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . montant AS montant_3 , t0 . date AS date_4 , t0 . libelle AS libelle_5 , t0 . libelle2 AS libelle2_6 , t0 . caisse_id AS caisse_id_7 FROM mouvement t0 WHERE t0 . caisse_id = 1534 ;
Copy