Query Metrics

7 Database Queries
7 Different statements
17.56 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.32 ms
(58.75%)
1
SELECT t0.id AS id_1, t0.devise AS devise_2, t0.lettre_debut_facture_avoir AS lettre_debut_facture_avoir_3, t0.ente_document AS ente_document_4, t0.bon_de_livraison_avec_prix AS bon_de_livraison_avec_prix_5, t0.pied_document AS pied_document_6, t0.lettre_debut_facture_acompte AS lettre_debut_facture_acompte_7, t0.lettre_debut_facture AS lettre_debut_facture_8, t0.lettre_debut_devis AS lettre_debut_devis_9, t0.inclu_annee AS inclu_annee_10, t0.nombre_de_chiffre AS nombre_de_chiffre_11, t0.a_ete_change AS a_ete_change_12, t0.facture_contient_entete AS facture_contient_entete_13, t0.marge_entete AS marge_entete_14, t0.marge_pied_de_page AS marge_pied_de_page_15, t0.format_papier_impression AS format_papier_impression_16, t0.taille_logo_sur_les_documents AS taille_logo_sur_les_documents_17, t0.texte_mail_simple AS texte_mail_simple_18, t0.sujet_mail_simple AS sujet_mail_simple_19, t0.texte_mail_pre_relance AS texte_mail_pre_relance_20, t0.sujet_mail_pre_relance AS sujet_mail_pre_relance_21, t0.texte_mail_relance1 AS texte_mail_relance1_22, t0.sujet_mail_relance1 AS sujet_mail_relance1_23, t0.texte_mail_relance2 AS texte_mail_relance2_24, t0.sujet_mail_relance2 AS sujet_mail_relance2_25, t0.generer_automatiquement_fne AS generer_automatiquement_fne_26, t0.generer_automatiquement_ecritures_comptabilite AS generer_automatiquement_ecritures_comptabilite_27, t0.paiement_automatique_des_factures AS paiement_automatique_des_factures_28, t0.journal_de_vente_id AS journal_de_vente_id_29, t0.compte_de_vente_id AS compte_de_vente_id_30, t0.journal_dachat_id AS journal_dachat_id_31, t0.compte_dachat_id AS compte_dachat_id_32, t0.journal_de_caisse_id AS journal_de_caisse_id_33, t0.journal_de_banque_id AS journal_de_banque_id_34 FROM gestock_settings t0 WHERE t0.id = ?
Parameters:
[
  72
]
4.77 ms
(27.19%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.nombre AS nombre_4, t0.taux AS taux_5, t0.taux_salarial AS taux_salarial_6, t0.gain_salarial AS gain_salarial_7, t0.retenue_salarial AS retenue_salarial_8, t0.taux_patronal AS taux_patronal_9, t0.gain_patronal AS gain_patronal_10, t0.retenue_patronal AS retenue_patronal_11, t0.taux_employeur AS taux_employeur_12, t0.emplacement_part AS emplacement_part_13, t0.gain_ou_retenu AS gain_ou_retenu_14, t0.la_base AS la_base_15, t0.valeur_salarie AS valeur_salarie_16, t0.valeur_employeur AS valeur_employeur_17, t0.date_paiement_salaire AS date_paiement_salaire_18, t0.annee_paiement_salaire AS annee_paiement_salaire_19, t0.mois_paiement_salaire AS mois_paiement_salaire_20, t0.boutique_id AS boutique_id_21, t0.user_id AS user_id_22 FROM rubrique_salaire_paiement t0 WHERE t0.boutique_id = ? AND t0.user_id = ? AND t0.mois_paiement_salaire = ? AND t0.annee_paiement_salaire = ?
Parameters:
[
  72
  172
  "07"
  "2026"
]
0.84 ms
(4.76%)
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:
[
  "domotech-pro-sarl"
]
0.52 ms
(2.95%)
1
SELECT t0.id AS id_1, t0.salaire_brut AS salaire_brut_2, t0.cumul_salaire_brut AS cumul_salaire_brut_3, t0.charges_salariales AS charges_salariales_4, t0.cumul_charges_salariales AS cumul_charges_salariales_5, t0.charges_patronales AS charges_patronales_6, t0.cumul_charges_patronales AS cumul_charges_patronales_7, t0.heures_travaillees AS heures_travaillees_8, t0.cumul_heures_travaillees AS cumul_heures_travaillees_9, t0.heures_supplementaires AS heures_supplementaires_10, t0.cumul_heures_supplementaires AS cumul_heures_supplementaires_11, t0.salaire_net_apayer AS salaire_net_apayer_12, t0.cumul_salaire_net_apayer AS cumul_salaire_net_apayer_13, t0.date_paiement_salaire AS date_paiement_salaire_14, t0.date_paiement_fin_du_mois AS date_paiement_fin_du_mois_15, t0.mois_salaire AS mois_salaire_16, t0.annee_salaire AS annee_salaire_17, t0.avantage_en_nature AS avantage_en_nature_18, t0.boutique_id AS boutique_id_19, t0.user_id AS user_id_20 FROM paiement_salaire t0 WHERE t0.boutique_id = ? AND t0.user_id = ? AND t0.mois_salaire = ? AND t0.annee_salaire = ? LIMIT 1
Parameters:
[
  72
  172
  "07"
  "2026"
]
0.46 ms
(2.60%)
1
SELECT t0.role AS role_1, t0.accepte AS accepte_2, t0.est_parti AS est_parti_3, t0.est_employe AS est_employe_4, t0.salaire AS salaire_5, t0.matricule AS matricule_6, t0.la_fonction AS la_fonction_7, t0.categorie_emploi AS categorie_emploi_8, t0.la_qualification AS la_qualification_9, t0.departement_emploi AS departement_emploi_10, t0.date_de_prise_de_fonction AS date_de_prise_de_fonction_11, t0.igr AS igr_12, t0.nombre_d_enfant AS nombre_d_enfant_13, t0.nom_etablissement_fne AS nom_etablissement_fne_14, t0.nom_point_de_vente_fne AS nom_point_de_vente_fne_15, t0.vendeur_fne AS vendeur_fne_16, t0.droits AS droits_17, t0.boutique_id AS boutique_id_18, t0.user_id AS user_id_19 FROM gestock_user_boutique t0 WHERE t0.boutique_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[
  72
  "172"
]
0.44 ms
(2.49%)
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.sexe AS sexe_5, t0.id AS id_6, t0.email AS email_7, t0.email_token AS email_token_8, t0.nom AS nom_9, t0.prenom AS prenom_10, t0.nom_complet AS nom_complet_11, t0.dateNaissance AS dateNaissance_12, t0.contacts AS contacts_13, t0.adresse AS adresse_14, t0.matricule AS matricule_15, t0.salaire AS salaire_16, t0.numero_cnps AS numero_cnps_17, t0.vacataire AS vacataire_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.filename AS filename_21, t0.boutique_id AS boutique_id_22, t0.avatar_id AS avatar_id_23 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  172
]
0.22 ms
(1.25%)
1
SELECT t0.role AS role_1, t0.accepte AS accepte_2, t0.est_parti AS est_parti_3, t0.est_employe AS est_employe_4, t0.salaire AS salaire_5, t0.matricule AS matricule_6, t0.la_fonction AS la_fonction_7, t0.categorie_emploi AS categorie_emploi_8, t0.la_qualification AS la_qualification_9, t0.departement_emploi AS departement_emploi_10, t0.date_de_prise_de_fonction AS date_de_prise_de_fonction_11, t0.igr AS igr_12, t0.nombre_d_enfant AS nombre_d_enfant_13, t0.nom_etablissement_fne AS nom_etablissement_fne_14, t0.nom_point_de_vente_fne AS nom_point_de_vente_fne_15, t0.vendeur_fne AS vendeur_fne_16, t0.droits AS droits_17, t0.boutique_id AS boutique_id_18, t0.user_id AS user_id_19 FROM gestock_user_boutique t0 WHERE t0.user_id = ? AND t0.boutique_id = ? LIMIT 1
Parameters:
[
  172
  72
]

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\Boutique No errors.
App\Entity\Photo No errors.
App\Entity\Settings No errors.
App\Entity\Pays No errors.
App\Entity\AppUser No errors.
App\Entity\UserBoutique No errors.
App\Entity\RubriqueSalairePaiement No errors.
App\Entity\PaiementSalaire No errors.
App\Entity\JournalComptabilite No errors.
App\Entity\Compte No errors.