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

Query Metrics

15 Database Queries
5 Different statements
61.82 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 ms
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:
[
  57
]
2 10.62 ms
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"
]
3 11.14 ms
SELECT g0_.id AS id_0, g0_.etat AS etat_1, g0_.etat_chaine AS etat_chaine_2, g0_.lien_pdf AS lien_pdf_3, g0_.la_date AS la_date_4, g0_.valable_jusqu_au AS valable_jusqu_au_5, g0_.total_ht AS total_ht_6, g0_.total_htapres_remise AS total_htapres_remise_7, g0_.type_facture AS type_facture_8, g0_.nature_facture AS nature_facture_9, g0_.total_tva AS total_tva_10, g0_.total_autre_taxe AS total_autre_taxe_11, g0_.autres_taxes AS autres_taxes_12, g0_.frais_de_port AS frais_de_port_13, g0_.total_ttc AS total_ttc_14, g0_.acquitee AS acquitee_15, g0_.numero AS numero_16, g0_.montant_paye AS montant_paye_17, g0_.reste_apayer AS reste_apayer_18, g0_.remise AS remise_19, g0_.remise_pourcentage AS remise_pourcentage_20, g0_.montant_en_lettre AS montant_en_lettre_21, g0_.observation_sur_facture AS observation_sur_facture_22, g0_.titre_document AS titre_document_23, g0_.mois AS mois_24, g0_.annee AS annee_25, g0_.observation AS observation_26, g0_.moyen_de_paiement AS moyen_de_paiement_27, g0_.id_facture_de_base AS id_facture_de_base_28, g0_.id_facture_fne AS id_facture_fne_29, g0_.token_fne AS token_fne_30, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_31, g0_.est_supprime AS est_supprime_32, g0_.matricule_vehicule AS matricule_vehicule_33, g0_.marque_vehicule AS marque_vehicule_34, g0_.kilometrage_vehicule AS kilometrage_vehicule_35, g1_.slug AS slug_36, g1_.id AS id_37, g1_.adresse AS adresse_38, g1_.nom AS nom_39, g1_.heure_debut_travail AS heure_debut_travail_40, g1_.heure_fin_travail AS heure_fin_travail_41, g1_.temps_de_travail AS temps_de_travail_42, g1_.sigle AS sigle_43, g1_.email AS email_44, g1_.phone AS phone_45, g1_.code_postal AS code_postal_46, g1_.ville AS ville_47, g1_.site_web AS site_web_48, g1_.fax AS fax_49, g1_.statut_juridique AS statut_juridique_50, g1_.capital AS capital_51, g1_.matricule AS matricule_52, g1_.siret AS siret_53, g1_.ape AS ape_54, g1_.cc AS cc_55, g1_.facture_tva AS facture_tva_56, g1_.mention_legal AS mention_legal_57, g1_.banque AS banque_58, g1_.rib AS rib_59, g1_.iban AS iban_60, g1_.bic AS bic_61, g1_.url_fnede_base AS url_fnede_base_62, g1_.api_key_fne AS api_key_fne_63, g1_.solde_timbre_fne AS solde_timbre_fne_64, g1_.numero_cnps AS numero_cnps_65, g0_.boutique_id AS boutique_id_66, g0_.tiers_id AS tiers_id_67, g0_.cree_par_id AS cree_par_id_68, g0_.modifie_par_id AS modifie_par_id_69, g0_.supprime_par_id AS supprime_par_id_70, g1_.logo_id AS logo_id_71, g1_.settings_id AS settings_id_72, g1_.pays_id AS pays_id_73 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.type_facture = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 ORDER BY g0_.la_date DESC, g0_.numero DESC
Parameters:
[
  22
  "proposal"
  "2026-03-09 00:00:00"
  "2026-03-15 23:59:00"
]
4 0.43 ms
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:
[
  57
  22
]
5 10.33 ms
SELECT g0_.id AS id_0, g0_.etat AS etat_1, g0_.etat_chaine AS etat_chaine_2, g0_.lien_pdf AS lien_pdf_3, g0_.la_date AS la_date_4, g0_.valable_jusqu_au AS valable_jusqu_au_5, g0_.total_ht AS total_ht_6, g0_.total_htapres_remise AS total_htapres_remise_7, g0_.type_facture AS type_facture_8, g0_.nature_facture AS nature_facture_9, g0_.total_tva AS total_tva_10, g0_.total_autre_taxe AS total_autre_taxe_11, g0_.autres_taxes AS autres_taxes_12, g0_.frais_de_port AS frais_de_port_13, g0_.total_ttc AS total_ttc_14, g0_.acquitee AS acquitee_15, g0_.numero AS numero_16, g0_.montant_paye AS montant_paye_17, g0_.reste_apayer AS reste_apayer_18, g0_.remise AS remise_19, g0_.remise_pourcentage AS remise_pourcentage_20, g0_.montant_en_lettre AS montant_en_lettre_21, g0_.observation_sur_facture AS observation_sur_facture_22, g0_.titre_document AS titre_document_23, g0_.mois AS mois_24, g0_.annee AS annee_25, g0_.observation AS observation_26, g0_.moyen_de_paiement AS moyen_de_paiement_27, g0_.id_facture_de_base AS id_facture_de_base_28, g0_.id_facture_fne AS id_facture_fne_29, g0_.token_fne AS token_fne_30, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_31, g0_.est_supprime AS est_supprime_32, g0_.matricule_vehicule AS matricule_vehicule_33, g0_.marque_vehicule AS marque_vehicule_34, g0_.kilometrage_vehicule AS kilometrage_vehicule_35, g1_.slug AS slug_36, g1_.id AS id_37, g1_.adresse AS adresse_38, g1_.nom AS nom_39, g1_.heure_debut_travail AS heure_debut_travail_40, g1_.heure_fin_travail AS heure_fin_travail_41, g1_.temps_de_travail AS temps_de_travail_42, g1_.sigle AS sigle_43, g1_.email AS email_44, g1_.phone AS phone_45, g1_.code_postal AS code_postal_46, g1_.ville AS ville_47, g1_.site_web AS site_web_48, g1_.fax AS fax_49, g1_.statut_juridique AS statut_juridique_50, g1_.capital AS capital_51, g1_.matricule AS matricule_52, g1_.siret AS siret_53, g1_.ape AS ape_54, g1_.cc AS cc_55, g1_.facture_tva AS facture_tva_56, g1_.mention_legal AS mention_legal_57, g1_.banque AS banque_58, g1_.rib AS rib_59, g1_.iban AS iban_60, g1_.bic AS bic_61, g1_.url_fnede_base AS url_fnede_base_62, g1_.api_key_fne AS api_key_fne_63, g1_.solde_timbre_fne AS solde_timbre_fne_64, g1_.numero_cnps AS numero_cnps_65, g0_.boutique_id AS boutique_id_66, g0_.tiers_id AS tiers_id_67, g0_.cree_par_id AS cree_par_id_68, g0_.modifie_par_id AS modifie_par_id_69, g0_.supprime_par_id AS supprime_par_id_70, g1_.logo_id AS logo_id_71, g1_.settings_id AS settings_id_72, g1_.pays_id AS pays_id_73 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.type_facture = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 ORDER BY g0_.la_date DESC, g0_.numero DESC
Parameters:
[
  22
  "proposal"
  "2026-02-01 00:00:00"
  "2026-03-13 23:59:00"
]
6 10.84 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  188
]
7 9.01 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  189
]
8 0.35 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  36
]
9 6.59 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  49
]
10 0.36 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  67
]
11 0.19 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  59
]
12 0.35 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  64
]
13 0.21 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  63
]
14 0.24 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  82
]
15 0.19 ms
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.boutique_id AS boutique_id_12, t0.pays_id AS pays_id_13, t0.cree_par_id AS cree_par_id_14, t0.modifie_par_id AS modifie_par_id_15, t0.supprime_par_id AS supprime_par_id_16 FROM gestock_tiers t0 WHERE t0.id = ?
Parameters:
[
  65
]

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\Commande No errors.
App\Entity\Tiers No errors.
App\Entity\UserBoutique No errors.