| 1 |
0.69 ms |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.annee AS annee_3, t0.total AS total_4, t0.demande_remboursement_at AS demande_remboursement_at_5, t0.remboursement_at AS remboursement_at_6, t0.created_at AS created_at_7, t0.created_by_id AS created_by_id_8, t0.created_by AS created_by_9, t0.collaborateur_id AS collaborateur_id_10 FROM engagement_frais t0 WHERE t0.created_by_id = ? AND t0.annee = ? ORDER BY t0.created_at DESC
Parameters: [
12
"2026"
]
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.annee AS annee_3, t0.total AS total_4, t0.demande_remboursement_at AS demande_remboursement_at_5, t0.remboursement_at AS remboursement_at_6, t0.created_at AS created_at_7, t0.created_by_id AS created_by_id_8, t0.created_by AS created_by_9, t0.collaborateur_id AS collaborateur_id_10 FROM engagement_frais t0 WHERE t0.created_by_id = 12 AND t0.annee = '2026' ORDER BY t0.created_at DESC;
|
| 2 |
0.53 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 69;
|
| 3 |
0.37 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 66;
|
| 4 |
0.35 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 65;
|
| 5 |
0.36 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 23;
|
| 6 |
0.34 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 64;
|
| 7 |
0.35 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 63;
|
| 8 |
0.41 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 62;
|
| 9 |
0.35 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 61;
|
| 10 |
0.65 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 55;
|
| 11 |
0.56 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 54;
|
| 12 |
0.42 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 51;
|
| 13 |
0.38 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 46;
|
| 14 |
0.40 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 36;
|
| 15 |
0.51 ms |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.annee AS annee_3, t0.total AS total_4, t0.demande_remboursement_at AS demande_remboursement_at_5, t0.remboursement_at AS remboursement_at_6, t0.created_at AS created_at_7, t0.created_by_id AS created_by_id_8, t0.created_by AS created_by_9, t0.collaborateur_id AS collaborateur_id_10 FROM engagement_frais t0 WHERE t0.created_by_id = ? AND t0.annee = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.annee AS annee_3, t0.total AS total_4, t0.demande_remboursement_at AS demande_remboursement_at_5, t0.remboursement_at AS remboursement_at_6, t0.created_at AS created_at_7, t0.created_by_id AS created_by_id_8, t0.created_by AS created_by_9, t0.collaborateur_id AS collaborateur_id_10 FROM engagement_frais t0 WHERE t0.created_by_id = 12 AND t0.annee = 2025 ORDER BY t0.created_at DESC;
|
| 16 |
0.38 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 32;
|
| 17 |
0.38 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 WHERE t0.id = 27;
|
| 18 |
0.54 ms |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.annee AS annee_3, t0.total AS total_4, t0.demande_remboursement_at AS demande_remboursement_at_5, t0.remboursement_at AS remboursement_at_6, t0.created_at AS created_at_7, t0.created_by_id AS created_by_id_8, t0.created_by AS created_by_9, t0.collaborateur_id AS collaborateur_id_10 FROM engagement_frais t0 WHERE t0.created_by_id = ? AND t0.annee = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.annee AS annee_3, t0.total AS total_4, t0.demande_remboursement_at AS demande_remboursement_at_5, t0.remboursement_at AS remboursement_at_6, t0.created_at AS created_at_7, t0.created_by_id AS created_by_id_8, t0.created_by AS created_by_9, t0.collaborateur_id AS collaborateur_id_10 FROM engagement_frais t0 WHERE t0.created_by_id = 12 AND t0.annee = 2024 ORDER BY t0.created_at DESC;
|
| 19 |
1.54 ms |
SELECT t0.id AS id_1, t0.budget_code AS budget_code_2, t0.budget_libelle AS budget_libelle_3, t0.action_code AS action_code_4, t0.action_libelle AS action_libelle_5, t0.intitule_code AS intitule_code_6, t0.intitule_libelle AS intitule_libelle_7, t0.sous_intitule_code AS sous_intitule_code_8, t0.sous_intitule_libelle AS sous_intitule_libelle_9, t0.educ_code AS educ_code_10, t0.code_analytique AS code_analytique_11, t0.description AS description_12, t0.annee AS annee_13 FROM plan_analytique t0
SELECT t0.id AS id_1, t0.budget_code AS budget_code_2, t0.budget_libelle AS budget_libelle_3, t0.action_code AS action_code_4, t0.action_libelle AS action_libelle_5, t0.intitule_code AS intitule_code_6, t0.intitule_libelle AS intitule_libelle_7, t0.sous_intitule_code AS sous_intitule_code_8, t0.sous_intitule_libelle AS sous_intitule_libelle_9, t0.educ_code AS educ_code_10, t0.code_analytique AS code_analytique_11, t0.description AS description_12, t0.annee AS annee_13 FROM plan_analytique t0;
|
| 20 |
2.29 ms |
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 ORDER BY t0.nom ASC, t0.prenom ASC
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.service1 AS service1_5, t0.service2 AS service2_6, t0.fonction AS fonction_7, t0.entree_date AS entree_date_8, t0.sortie_date AS sortie_date_9, t0.type AS type_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.telephone AS telephone_14, t0.email AS email_15 FROM collaborateur t0 ORDER BY t0.nom ASC, t0.prenom ASC;
|