https://harmony.assiecloud.com/fr/dashboard/ims-sarl-22/expensives/list Return to referer URL

Query Metrics

53 Database Queries
6 Different statements
17.26 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.56 ms
(43.80%)
28
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.groupe_charge AS groupe_charge_3, t0.boutique_id AS boutique_id_4 FROM categorie_depense t0 WHERE t0.id = ?
Parameters:
[
  28
]
5.79 ms
(33.55%)
20
SELECT t0.id AS id_1, t0.type_client AS type_client_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.email AS email_7, t0.telephone AS telephone_8, t0.assujetti_ala_tva AS assujetti_ala_tva_9, t0.code_tva AS code_tva_10, t0.est_supprime AS est_supprime_11, t0.mois AS mois_12, t0.annee AS annee_13, t0.la_date AS la_date_14, t0.boutique_id AS boutique_id_15, t0.pays_id AS pays_id_16, t0.cree_par_id AS cree_par_id_17, t0.modifie_par_id AS modifie_par_id_18, t0.supprime_par_id AS supprime_par_id_19 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  238
]
2.33 ms
(13.51%)
2
SELECT g0_.id AS id_0, g0_.la_date AS la_date_1, g0_.piece AS piece_2, g0_.detail AS detail_3, g0_.moyen_de_paiement AS moyen_de_paiement_4, g0_.montant AS montant_5, g0_.mois AS mois_6, g0_.annee AS annee_7, g0_.est_supprime AS est_supprime_8, g1_.slug AS slug_9, g1_.id AS id_10, g1_.adresse AS adresse_11, g1_.nom AS nom_12, g1_.heure_debut_travail AS heure_debut_travail_13, g1_.heure_fin_travail AS heure_fin_travail_14, g1_.temps_de_travail AS temps_de_travail_15, g1_.sigle AS sigle_16, g1_.email AS email_17, g1_.phone AS phone_18, g1_.code_postal AS code_postal_19, g1_.ville AS ville_20, g1_.site_web AS site_web_21, g1_.fax AS fax_22, g1_.statut_juridique AS statut_juridique_23, g1_.capital AS capital_24, g1_.matricule AS matricule_25, g1_.siret AS siret_26, g1_.ape AS ape_27, g1_.cc AS cc_28, g1_.facture_tva AS facture_tva_29, g1_.mention_legal AS mention_legal_30, g1_.banque AS banque_31, g1_.rib AS rib_32, g1_.iban AS iban_33, g1_.bic AS bic_34, g1_.url_fnede_base AS url_fnede_base_35, g1_.api_key_fne AS api_key_fne_36, g1_.solde_timbre_fne AS solde_timbre_fne_37, g1_.numero_cnps AS numero_cnps_38, g0_.categorie_depense_id AS categorie_depense_id_39, g0_.boutique_id AS boutique_id_40, g0_.tiers_id AS tiers_id_41, g0_.cree_par_id AS cree_par_id_42, g0_.modifie_par_id AS modifie_par_id_43, g0_.supprime_par_id AS supprime_par_id_44, g1_.logo_id AS logo_id_45, g1_.settings_id AS settings_id_46, g1_.pays_id AS pays_id_47 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 ORDER BY g0_.la_date DESC
Parameters:
[
  22
  "2026-04-27 00:00:00"
  "2026-05-03 23:59:00"
]
0.77 ms
(4.45%)
1
SELECT t0.slug_username AS slug_username_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.id AS id_5, t0.email AS email_6, t0.email_token AS email_token_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.nom_complet AS nom_complet_10, t0.dateNaissance AS dateNaissance_11, t0.contacts AS contacts_12, t0.adresse AS adresse_13, t0.matricule AS matricule_14, t0.salaire AS salaire_15, t0.numero_cnps AS numero_cnps_16, t0.vacataire AS vacataire_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.filename AS filename_20, t0.boutique_id AS boutique_id_21, t0.avatar_id AS avatar_id_22 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  89
]
0.44 ms
(2.56%)
1
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.nom AS nom_4, t0.heure_debut_travail AS heure_debut_travail_5, t0.heure_fin_travail AS heure_fin_travail_6, t0.temps_de_travail AS temps_de_travail_7, t0.sigle AS sigle_8, t0.email AS email_9, t0.phone AS phone_10, t0.code_postal AS code_postal_11, t0.ville AS ville_12, t0.site_web AS site_web_13, t0.fax AS fax_14, t0.statut_juridique AS statut_juridique_15, t0.capital AS capital_16, t0.matricule AS matricule_17, t0.siret AS siret_18, t0.ape AS ape_19, t0.cc AS cc_20, t0.facture_tva AS facture_tva_21, t0.mention_legal AS mention_legal_22, t0.banque AS banque_23, t0.rib AS rib_24, t0.iban AS iban_25, t0.bic AS bic_26, t0.url_fnede_base AS url_fnede_base_27, t0.api_key_fne AS api_key_fne_28, t0.solde_timbre_fne AS solde_timbre_fne_29, t0.numero_cnps AS numero_cnps_30, t0.logo_id AS logo_id_31, t0.settings_id AS settings_id_32, t0.pays_id AS pays_id_33 FROM gestock_boutique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "ims-sarl-22"
]
0.37 ms
(2.13%)
1
SELECT t0.role AS role_1, t0.accepte AS accepte_2, t0.est_parti AS est_parti_3, t0.salaire AS salaire_4, t0.matricule AS matricule_5, t0.la_fonction AS la_fonction_6, t0.categorie_emploi AS categorie_emploi_7, t0.la_qualification AS la_qualification_8, t0.departement_emploi AS departement_emploi_9, t0.date_de_prise_de_fonction AS date_de_prise_de_fonction_10, t0.igr AS igr_11, t0.nombre_d_enfant AS nombre_d_enfant_12, t0.nom_etablissement_fne AS nom_etablissement_fne_13, t0.nom_point_de_vente_fne AS nom_point_de_vente_fne_14, t0.boutique_id AS boutique_id_15, t0.user_id AS user_id_16 FROM gestock_user_boutique t0 WHERE t0.user_id = ? AND t0.boutique_id = ? LIMIT 1
Parameters:
[
  89
  22
]

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\AppUser No errors.
App\Entity\Boutique No errors.
App\Entity\Photo No errors.
App\Entity\Settings No errors.
App\Entity\Pays No errors.
App\Entity\Expensive No errors.
App\Entity\CategorieDepense No errors.
App\Entity\Tiers No errors.
App\Entity\UserBoutique No errors.