Query Metrics
259
Database Queries
5
Different statements
1540.07 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 21.66 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.reset_token AS reset_token_6, t0.reset_token_expires_at AS reset_token_expires_at_7, t0.is_pro_access_requested AS is_pro_access_requested_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
53
]
|
2 | 15.73 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.designation AS designation_3, t0.montant_ht AS montant_ht_4, t0.taux_tva AS taux_tva_5, t0.montant_tva AS montant_tva_6, t0.montant_ttc AS montant_ttc_7, t0.date_paiement AS date_paiement_8, t0.categorie_designation AS categorie_designation_9, t0.is_entreprise_charge AS is_entreprise_charge_10, t0.is_mensuel AS is_mensuel_11, t0.categorie_personnalisee AS categorie_personnalisee_12, t0.agent_id AS agent_id_13 FROM charge t0
Parameters:
[] |
3 | 23.44 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.username AS username_4, u0_.reset_token AS reset_token_5, u0_.reset_token_expires_at AS reset_token_expires_at_6, u0_.is_pro_access_requested AS is_pro_access_requested_7 FROM user u0_ WHERE u0_.roles LIKE ? ORDER BY u0_.username ASC
Parameters:
[
"%ROLE_TEAM%"
]
|
4 | 12.49 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.is_mensuel = ?
Parameters:
[
1
]
|
5 | 21.64 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CA Certificat" 27 "2024-10" ] |
6 | 7.47 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CA Certificat" 27 "2024-11" ] |
7 | 7.54 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CA Certificat" 27 "2024-12" ] |
8 | 2.34 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Total Énergie" 27 "2024-10" ] |
9 | 8.77 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Total Énergie" 27 "2024-11" ] |
10 | 23.47 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Total Énergie" 27 "2024-12" ] |
11 | 0.96 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 27 "2024-10" ] |
12 | 0.90 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 27 "2024-11" ] |
13 | 5.49 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 27 "2024-12" ] |
14 | 1.78 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 27 "2025-01" ] |
15 | 9.19 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 27 "2024-10" ] |
16 | 6.24 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 27 "2024-11" ] |
17 | 14.32 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 27 "2024-12" ] |
18 | 56.70 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 27 "2025-01" ] |
19 | 11.52 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 27 "2024-10" ] |
20 | 2.14 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 27 "2024-11" ] |
21 | 10.66 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 27 "2024-12" ] |
22 | 22.77 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 27 "2025-01" ] |
23 | 1.68 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2024-10" ] |
24 | 15.91 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2024-11" ] |
25 | 4.78 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2024-12" ] |
26 | 10.18 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2025-01" ] |
27 | 1.57 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2024-10" ] |
28 | 4.48 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2024-11" ] |
29 | 20.65 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2024-12" ] |
30 | 7.44 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2025-01" ] |
31 | 4.88 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-10" ] |
32 | 4.68 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-11" ] |
33 | 11.68 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
34 | 20.02 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
35 | 2.60 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-10" ] |
36 | 0.54 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-11" ] |
37 | 18.42 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
38 | 0.54 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
39 | 0.53 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-10" ] |
40 | 5.73 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-11" ] |
41 | 0.44 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
42 | 14.28 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
43 | 4.12 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2024-10" ] |
44 | 6.93 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2024-11" ] |
45 | 4.82 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2024-12" ] |
46 | 10.10 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2025-01" ] |
47 | 14.67 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2024-10" ] |
48 | 8.25 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2024-11" ] |
49 | 4.76 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2024-12" ] |
50 | 10.19 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2025-01" ] |
51 | 0.50 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-10" ] |
52 | 6.55 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-11" ] |
53 | 3.62 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
54 | 0.94 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
55 | 21.35 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CPME" 27 "2024-10" ] |
56 | 1.72 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CPME" 27 "2024-11" ] |
57 | 9.42 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CPME" 27 "2024-12" ] |
58 | 1.72 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2024-10" ] |
59 | 5.41 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2024-11" ] |
60 | 9.45 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2024-12" ] |
61 | 5.70 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2025-01" ] |
62 | 8.06 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2024-10" ] |
63 | 6.89 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2024-11" ] |
64 | 4.69 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2024-12" ] |
65 | 10.18 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2025-01" ] |
66 | 1.72 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2024-10" ] |
67 | 9.35 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2024-11" ] |
68 | 1.69 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2024-12" ] |
69 | 5.36 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2025-01" ] |
70 | 4.24 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2024-11" ] |
71 | 0.46 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2024-12" ] |
72 | 22.01 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2025-01" ] |
73 | 1.99 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Belvia Immobilier" 27 "2024-11" ] |
74 | 9.10 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Belvia Immobilier" 27 "2024-12" ] |
75 | 23.48 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Belvia Immobilier" 27 "2025-01" ] |
76 | 0.53 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2024-11" ] |
77 | 0.34 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2024-12" ] |
78 | 0.34 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2025-01" ] |
79 | 13.41 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Securihelp Pro" 27 "2024-11" ] |
80 | 7.50 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Securihelp Pro" 27 "2024-12" ] |
81 | 3.88 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Securihelp Pro" 27 "2025-01" ] |
82 | 3.41 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2024-11" ] |
83 | 0.37 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2024-12" ] |
84 | 10.77 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2025-01" ] |
85 | 7.63 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Assurance CAAE Prêt Professionnel" 27 "2024-11" ] |
86 | 7.49 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Assurance CAAE Prêt Professionnel" 27 "2024-12" ] |
87 | 7.48 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Assurance CAAE Prêt Professionnel" 27 "2025-01" ] |
88 | 0.50 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-11" ] |
89 | 2.78 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
90 | 11.29 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
91 | 0.53 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2024-11" ] |
92 | 0.35 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2024-12" ] |
93 | 0.40 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2025-01" ] |
94 | 21.33 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI Sens Aller" 27 "2024-11" ] |
95 | 7.41 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI Sens Aller" 27 "2024-12" ] |
96 | 3.69 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI Sens Aller" 27 "2025-01" ] |
97 | 0.40 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-11" ] |
98 | 0.35 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
99 | 6.07 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
100 | 7.48 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2024-11" ] |
101 | 0.50 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2024-12" ] |
102 | 1.89 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2025-01" ] |
103 | 2.07 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2024-11" ] |
104 | 0.54 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2024-12" ] |
105 | 9.06 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2025-01" ] |
106 | 0.45 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-11" ] |
107 | 14.71 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
108 | 0.53 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
109 | 0.35 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-11" ] |
110 | 9.99 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
111 | 0.40 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
112 | 0.34 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 27 "2024-11" ] |
113 | 1.79 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 27 "2024-12" ] |
114 | 4.02 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 27 "2025-01" ] |
115 | 0.40 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 27 "2024-11" ] |
116 | 14.61 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 27 "2024-12" ] |
117 | 0.51 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 27 "2025-01" ] |
118 | 4.26 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement APRR" 27 "2024-11" ] |
119 | 10.11 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement APRR" 27 "2024-12" ] |
120 | 1.49 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement APRR" 27 "2025-01" ] |
121 | 0.52 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 27 "2024-11" ] |
122 | 6.79 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 27 "2024-12" ] |
123 | 0.48 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 27 "2025-01" ] |
124 | 6.95 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Nicolas 50€ entretien véhicule" 27 "2024-11" ] |
125 | 15.45 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Nicolas 50€ entretien véhicule" 27 "2024-12" ] |
126 | 7.57 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Nicolas 50€ entretien véhicule" 27 "2025-01" ] |
127 | 3.03 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Yoan 50€ entretien véhicule" 27 "2024-11" ] |
128 | 8.11 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Yoan 50€ entretien véhicule" 27 "2024-12" ] |
129 | 1.57 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Yoan 50€ entretien véhicule" 27 "2025-01" ] |
130 | 9.66 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Thierry 50€ entretien véhicule" 27 "2024-11" ] |
131 | 11.54 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Thierry 50€ entretien véhicule" 27 "2024-12" ] |
132 | 1.60 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Thierry 50€ entretien véhicule" 27 "2025-01" ] |
133 | 0.36 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2024-11" ] |
134 | 12.92 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2024-12" ] |
135 | 3.82 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2025-01" ] |
136 | 1.59 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Bouygues" 27 "2024-11" ] |
137 | 5.47 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Bouygues" 27 "2024-12" ] |
138 | 3.78 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Bouygues" 27 "2025-01" ] |
139 | 0.46 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2024-11" ] |
140 | 6.92 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2024-12" ] |
141 | 0.40 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 27 "2025-01" ] |
142 | 2.76 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement B2B DGFIP" 27 "2024-11" ] |
143 | 10.95 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement B2B DGFIP" 27 "2024-12" ] |
144 | 8.27 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement B2B DGFIP" 27 "2025-01" ] |
145 | 3.73 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Malakoff Humanis Retraite" 27 "2024-11" ] |
146 | 19.31 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Malakoff Humanis Retraite" 27 "2024-12" ] |
147 | 0.63 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CA Certificat" 27 "2024-11" ] |
148 | 2.69 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CA Certificat" 27 "2024-12" ] |
149 | 3.59 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CPME" 27 "2024-11" ] |
150 | 3.48 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CPME" 27 "2024-12" ] |
151 | 15.40 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Cotisation forfait LCE" 27 "2024-11" ] |
152 | 7.51 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Cotisation forfait LCE" 27 "2024-12" ] |
153 | 7.51 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Cotisation forfait LCE" 27 "2025-01" ] |
154 | 4.21 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE IARD" 27 "2024-11" ] |
155 | 7.46 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE IARD" 27 "2024-12" ] |
156 | 14.21 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE IARD" 27 "2025-01" ] |
157 | 4.98 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2024-11" ] |
158 | 6.09 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2024-12" ] |
159 | 7.43 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2025-01" ] |
160 | 0.48 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2024-11" ] |
161 | 2.87 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2024-12" ] |
162 | 11.30 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2025-01" ] |
163 | 7.62 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Engie" 27 "2024-11" ] |
164 | 4.75 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Engie" 27 "2024-12" ] |
165 | 6.28 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Engie" 27 "2025-01" ] |
166 | 15.66 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Adobe" 27 "2024-11" ] |
167 | 15.79 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Adobe" 27 "2024-12" ] |
168 | 1.77 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Adobe" 27 "2025-01" ] |
169 | 1.38 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Wix" 27 "2024-12" ] |
170 | 4.49 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Wix" 27 "2025-01" ] |
171 | 18.26 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Wix" 27 "2024-11" ] |
172 | 3.75 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Wix" 27 "2024-12" ] |
173 | 0.39 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Wix" 27 "2025-01" ] |
174 | 2.51 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Axonaut" 27 "2024-11" ] |
175 | 8.83 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Axonaut" 27 "2024-12" ] |
176 | 6.24 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Axonaut" 27 "2025-01" ] |
177 | 15.56 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement DropBox" 27 "2024-11" ] |
178 | 1.64 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement DropBox" 27 "2024-12" ] |
179 | 9.50 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement DropBox" 27 "2025-01" ] |
180 | 11.56 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement APRR" 27 "2024-10" ] |
181 | 1.68 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement APRR" 27 "2024-12" ] |
182 | 5.42 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement APRR" 27 "2025-01" ] |
183 | 15.61 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Anthropic (Claude)" 27 "2024-11" ] |
184 | 7.54 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Anthropic (Claude)" 27 "2024-12" ] |
185 | 7.60 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Anthropic (Claude)" 27 "2025-01" ] |
186 | 4.79 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Abonnement Canva" 27 "2024-10" ] |
187 | 2.22 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Abonnement Canva" 27 "2024-11" ] |
188 | 19.48 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Abonnement Canva" 27 "2024-12" ] |
189 | 0.49 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Abonnement Canva" 27 "2024-11" ] |
190 | 2.81 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Abonnement Canva" 27 "2024-12" ] |
191 | 0.83 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CA Certificat" 52 "2024-12" ] |
192 | 0.54 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Total Énergie" 27 "2024-12" ] |
193 | 3.23 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement B2B DGFIP" 52 "2024-12" ] |
194 | 18.91 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Malakoff Humanis Retraite" 43 "2024-12" ] |
195 | 1.00 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CPME" 43 "2024-12" ] |
196 | 6.68 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement B2B DGFIP" 43 "2024-12" ] |
197 | 3.50 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Bouygues" 52 "2024-12" ] |
198 | 0.71 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Thierry 50€ entretien véhicule" 52 "2024-12" ] |
199 | 0.64 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Thierry 50€ entretien véhicule" 52 "2025-01" ] |
200 | 13.08 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Yoan 50€ entretien véhicule" 52 "2024-12" ] |
201 | 2.53 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Yoan 50€ entretien véhicule" 52 "2025-01" ] |
202 | 3.32 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Nicolas 50€ entretien véhicule" 52 "2024-12" ] |
203 | 5.29 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Nicolas 50€ entretien véhicule" 52 "2025-01" ] |
204 | 3.93 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 52 "2024-12" ] |
205 | 10.91 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 52 "2025-01" ] |
206 | 0.83 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 43 "2024-12" ] |
207 | 0.61 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement URSSAF" 43 "2025-01" ] |
208 | 0.60 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement DGFIP" 52 "2024-12" ] |
209 | 10.32 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement DGFIP" 52 "2025-01" ] |
210 | 0.79 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 43 "2024-12" ] |
211 | 0.51 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Fiducial" 43 "2025-01" ] |
212 | 24.80 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement APRR" 43 "2024-12" ] |
213 | 2.32 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement APRR" 43 "2025-01" ] |
214 | 4.91 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 43 "2024-12" ] |
215 | 4.36 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement FidExpertise" 43 "2025-01" ] |
216 | 6.60 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 43 "2024-12" ] |
217 | 7.78 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Offre à Composer Pro" 43 "2025-01" ] |
218 | 0.40 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2024-12" ] |
219 | 0.24 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Xavier Dalon" 27 "2025-01" ] |
220 | 1.76 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
221 | 0.34 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
222 | 0.24 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
223 | 0.27 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
224 | 6.51 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2024-12" ] |
225 | 0.33 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2025-01" ] |
226 | 0.35 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2024-12" ] |
227 | 0.32 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Abonnement EDI" 27 "2025-01" ] |
228 | 0.37 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
229 | 0.28 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
230 | 0.39 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2024-12" ] |
231 | 5.98 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement SFR" 27 "2025-01" ] |
232 | 0.35 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2024-12" ] |
233 | 2.96 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Eau" 27 "2025-01" ] |
234 | 1.16 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Rotary Club" 27 "2024-12" ] |
235 | 6.09 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Rotary Club" 27 "2025-01" ] |
236 | 3.60 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2024-12" ] |
237 | 0.36 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement AXA" 27 "2025-01" ] |
238 | 0.27 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Assurance CAAE Prêt Professionnel" 27 "2024-12" ] |
239 | 0.30 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Assurance CAAE Prêt Professionnel" 27 "2025-01" ] |
240 | 0.26 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2024-12" ] |
241 | 0.27 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Crédit Agricole Assurance Pro" 27 "2025-01" ] |
242 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Belvia Immobilier" 27 "2024-12" ] |
243 | 0.46 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement Belvia Immobilier" 27 "2025-01" ] |
244 | 7.88 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2024-12" ] |
245 | 0.35 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Virement ROCHET SEBASTIEN" 27 "2025-01" ] |
246 | 0.33 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Securihelp Pro" 27 "2024-12" ] |
247 | 0.32 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Securihelp Pro" 27 "2025-01" ] |
248 | 0.33 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Cotisation forfait LCE" 27 "2024-12" ] |
249 | 0.24 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Cotisation forfait LCE" 27 "2025-01" ] |
250 | 0.24 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2024-12" ] |
251 | 4.43 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2025-01" ] |
252 | 3.18 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2024-12" ] |
253 | 0.31 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE Vie" 27 "2025-01" ] |
254 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE IARD" 27 "2024-12" ] |
255 | 0.32 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement BPCE IARD" 27 "2025-01" ] |
256 | 0.44 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement CPME" 43 "2024-12" ] |
257 | 1.47 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Abonnement Canva" 27 "2024-12" ] |
258 | 1.20 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Wix" 27 "2024-12" ] |
259 | 6.21 ms |
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.designation AS designation_2, c0_.montant_ht AS montant_ht_3, c0_.taux_tva AS taux_tva_4, c0_.montant_tva AS montant_tva_5, c0_.montant_ttc AS montant_ttc_6, c0_.date_paiement AS date_paiement_7, c0_.categorie_designation AS categorie_designation_8, c0_.is_entreprise_charge AS is_entreprise_charge_9, c0_.is_mensuel AS is_mensuel_10, c0_.categorie_personnalisee AS categorie_personnalisee_11, c0_.agent_id AS agent_id_12 FROM charge c0_ WHERE c0_.designation = ? AND c0_.agent_id = ? AND SUBSTRING(c0_.date FROM 1 FOR 7) = ?
Parameters:
[ "Prélèvement Wix" 27 "2025-01" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Entreprise | No errors. |
App\Entity\PricingGrid | No errors. |
App\Entity\Charge | No errors. |