Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

15 Database Queries

12 Different statements

22.15 ms Query time

0 Invalid entities

Queries

Group similar statements


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 = ?
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
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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, SUM(g0_.total_ttc) AS sclr_39, SUM(g0_.total_tva) AS sclr_40 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0
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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, SUM(g0_.total_ttc) AS sclr_39, SUM(g0_.total_tva) AS sclr_40 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0
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, SUM(g0_.montant) AS sclr_9 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0
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, SUM(g0_.montant) AS sclr_9 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0
SELECT g0_.id AS id_0, g0_.type_client AS type_client_1, g0_.nom AS nom_2, g0_.adresse AS adresse_3, g0_.code_postal AS code_postal_4, g0_.ville AS ville_5, g0_.email AS email_6, g0_.telephone AS telephone_7, g0_.assujetti_ala_tva AS assujetti_ala_tva_8, g0_.code_tva AS code_tva_9, g0_.est_supprime AS est_supprime_10, g0_.mois AS mois_11, g0_.annee AS annee_12, g0_.la_date AS la_date_13, COUNT(g0_.id) AS sclr_14 FROM gestock_tiers g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.est_supprime = 0
SELECT g0_.slug AS slug_0, g0_.id AS id_1, g0_.reference AS reference_2, g0_.nom AS nom_3, g0_.prix_dachat AS prix_dachat_4, g0_.description AS description_5, g0_.stock_minimum AS stock_minimum_6, g0_.stock_disponible AS stock_disponible_7, g0_.stock_de_securite AS stock_de_securite_8, g0_.stock_dalerte AS stock_dalerte_9, g0_.stock_outil AS stock_outil_10, g0_.stock_maximum AS stock_maximum_11, g0_.cout_de_stockage AS cout_de_stockage_12, g0_.gere_le_stock AS gere_le_stock_13, g0_.unite_de_mesure AS unite_de_mesure_14, g0_.codebarre AS codebarre_15, g0_.est_supprime AS est_supprime_16, COUNT(g0_.id) AS sclr_17 FROM gestock_produit g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ?
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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, g0_.mois AS mois_39, SUM(g0_.total_ttc) AS sclr_40, SUM(g0_.montant_paye) AS sclr_41 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g0_.est_supprime = 0 AND g0_.type_facture = ? AND g1_.id = ? GROUP BY g0_.mois ORDER BY mois_39 ASC
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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, g0_.annee AS annee_39, SUM(g0_.total_ttc) AS sclr_40, SUM(g0_.montant_paye) AS sclr_41 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.est_supprime = 0 AND g0_.type_facture = ? GROUP BY g0_.annee ORDER BY annee_39 ASC
SELECT g0_.etat AS etat_0, g0_.type_facture AS type_facture_1, SUM(g0_.total_ht) AS sclr_2, g0_.id AS id_3, g0_.etat AS etat_4, g0_.etat_chaine AS etat_chaine_5, g0_.lien_pdf AS lien_pdf_6, g0_.la_date AS la_date_7, g0_.valable_jusqu_au AS valable_jusqu_au_8, g0_.total_ht AS total_ht_9, g0_.total_htapres_remise AS total_htapres_remise_10, g0_.type_facture AS type_facture_11, g0_.nature_facture AS nature_facture_12, g0_.total_tva AS total_tva_13, g0_.total_autre_taxe AS total_autre_taxe_14, g0_.autres_taxes AS autres_taxes_15, g0_.frais_de_port AS frais_de_port_16, g0_.total_ttc AS total_ttc_17, g0_.acquitee AS acquitee_18, g0_.numero AS numero_19, g0_.montant_paye AS montant_paye_20, g0_.reste_apayer AS reste_apayer_21, g0_.remise AS remise_22, g0_.remise_pourcentage AS remise_pourcentage_23, g0_.montant_en_lettre AS montant_en_lettre_24, g0_.observation_sur_facture AS observation_sur_facture_25, g0_.titre_document AS titre_document_26, g0_.mois AS mois_27, g0_.annee AS annee_28, g0_.observation AS observation_29, g0_.moyen_de_paiement AS moyen_de_paiement_30, g0_.id_facture_de_base AS id_facture_de_base_31, g0_.id_facture_fne AS id_facture_fne_32, g0_.token_fne AS token_fne_33, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_34, g0_.est_supprime AS est_supprime_35, g0_.matricule_vehicule AS matricule_vehicule_36, g0_.marque_vehicule AS marque_vehicule_37, g0_.kilometrage_vehicule AS kilometrage_vehicule_38, g0_.client_final_nom AS client_final_nom_39, g0_.client_final_numero AS client_final_numero_40, g0_.cout_de_revient AS cout_de_revient_41, g1_.slug AS slug_42, g1_.id AS id_43, g1_.adresse AS adresse_44, g1_.nom AS nom_45, g1_.heure_debut_travail AS heure_debut_travail_46, g1_.heure_fin_travail AS heure_fin_travail_47, g1_.temps_de_travail AS temps_de_travail_48, g1_.sigle AS sigle_49, g1_.email AS email_50, g1_.phone AS phone_51, g1_.code_postal AS code_postal_52, g1_.ville AS ville_53, g1_.site_web AS site_web_54, g1_.fax AS fax_55, g1_.statut_juridique AS statut_juridique_56, g1_.capital AS capital_57, g1_.matricule AS matricule_58, g1_.siret AS siret_59, g1_.ape AS ape_60, g1_.cc AS cc_61, g1_.facture_tva AS facture_tva_62, g1_.mention_legal AS mention_legal_63, g1_.banque AS banque_64, g1_.rib AS rib_65, g1_.iban AS iban_66, g1_.bic AS bic_67, g1_.url_fnede_base AS url_fnede_base_68, g1_.api_key_fne AS api_key_fne_69, g1_.solde_timbre_fne AS solde_timbre_fne_70, g1_.numero_cnps AS numero_cnps_71 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.type_facture = ? AND g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 GROUP BY g0_.type_facture ORDER BY type_facture_1 ASC
SELECT g0_.etat AS etat_0, g0_.type_facture AS type_facture_1, SUM(g0_.total_ht) AS sclr_2, g0_.id AS id_3, g0_.etat AS etat_4, g0_.etat_chaine AS etat_chaine_5, g0_.lien_pdf AS lien_pdf_6, g0_.la_date AS la_date_7, g0_.valable_jusqu_au AS valable_jusqu_au_8, g0_.total_ht AS total_ht_9, g0_.total_htapres_remise AS total_htapres_remise_10, g0_.type_facture AS type_facture_11, g0_.nature_facture AS nature_facture_12, g0_.total_tva AS total_tva_13, g0_.total_autre_taxe AS total_autre_taxe_14, g0_.autres_taxes AS autres_taxes_15, g0_.frais_de_port AS frais_de_port_16, g0_.total_ttc AS total_ttc_17, g0_.acquitee AS acquitee_18, g0_.numero AS numero_19, g0_.montant_paye AS montant_paye_20, g0_.reste_apayer AS reste_apayer_21, g0_.remise AS remise_22, g0_.remise_pourcentage AS remise_pourcentage_23, g0_.montant_en_lettre AS montant_en_lettre_24, g0_.observation_sur_facture AS observation_sur_facture_25, g0_.titre_document AS titre_document_26, g0_.mois AS mois_27, g0_.annee AS annee_28, g0_.observation AS observation_29, g0_.moyen_de_paiement AS moyen_de_paiement_30, g0_.id_facture_de_base AS id_facture_de_base_31, g0_.id_facture_fne AS id_facture_fne_32, g0_.token_fne AS token_fne_33, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_34, g0_.est_supprime AS est_supprime_35, g0_.matricule_vehicule AS matricule_vehicule_36, g0_.marque_vehicule AS marque_vehicule_37, g0_.kilometrage_vehicule AS kilometrage_vehicule_38, g0_.client_final_nom AS client_final_nom_39, g0_.client_final_numero AS client_final_numero_40, g0_.cout_de_revient AS cout_de_revient_41, g1_.slug AS slug_42, g1_.id AS id_43, g1_.adresse AS adresse_44, g1_.nom AS nom_45, g1_.heure_debut_travail AS heure_debut_travail_46, g1_.heure_fin_travail AS heure_fin_travail_47, g1_.temps_de_travail AS temps_de_travail_48, g1_.sigle AS sigle_49, g1_.email AS email_50, g1_.phone AS phone_51, g1_.code_postal AS code_postal_52, g1_.ville AS ville_53, g1_.site_web AS site_web_54, g1_.fax AS fax_55, g1_.statut_juridique AS statut_juridique_56, g1_.capital AS capital_57, g1_.matricule AS matricule_58, g1_.siret AS siret_59, g1_.ape AS ape_60, g1_.cc AS cc_61, g1_.facture_tva AS facture_tva_62, g1_.mention_legal AS mention_legal_63, g1_.banque AS banque_64, g1_.rib AS rib_65, g1_.iban AS iban_66, g1_.bic AS bic_67, g1_.url_fnede_base AS url_fnede_base_68, g1_.api_key_fne AS api_key_fne_69, g1_.solde_timbre_fne AS solde_timbre_fne_70, g1_.numero_cnps AS numero_cnps_71 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.type_facture = ? AND g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 GROUP BY g0_.type_facture ORDER BY type_facture_1 ASC
SELECT SUM(g0_.montant) AS sclr_0, g0_.id AS id_1, g0_.la_date AS la_date_2, g0_.montant AS montant_3, g0_.reference_paiement AS reference_paiement_4, g0_.moyen_de_paiement AS moyen_de_paiement_5, g1_.slug AS slug_6, g1_.id AS id_7, g1_.adresse AS adresse_8, g1_.nom AS nom_9, g1_.heure_debut_travail AS heure_debut_travail_10, g1_.heure_fin_travail AS heure_fin_travail_11, g1_.temps_de_travail AS temps_de_travail_12, g1_.sigle AS sigle_13, g1_.email AS email_14, g1_.phone AS phone_15, g1_.code_postal AS code_postal_16, g1_.ville AS ville_17, g1_.site_web AS site_web_18, g1_.fax AS fax_19, g1_.statut_juridique AS statut_juridique_20, g1_.capital AS capital_21, g1_.matricule AS matricule_22, g1_.siret AS siret_23, g1_.ape AS ape_24, g1_.cc AS cc_25, g1_.facture_tva AS facture_tva_26, g1_.mention_legal AS mention_legal_27, g1_.banque AS banque_28, g1_.rib AS rib_29, g1_.iban AS iban_30, g1_.bic AS bic_31, g1_.url_fnede_base AS url_fnede_base_32, g1_.api_key_fne AS api_key_fne_33, g1_.solde_timbre_fne AS solde_timbre_fne_34, g1_.numero_cnps AS numero_cnps_35 FROM gestock_payment g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ?
SELECT SUM(g0_.montant) AS sclr_0, g0_.id AS id_1, g0_.la_date AS la_date_2, g0_.piece AS piece_3, g0_.detail AS detail_4, g0_.moyen_de_paiement AS moyen_de_paiement_5, g0_.montant AS montant_6, g0_.mois AS mois_7, g0_.annee AS annee_8, g0_.est_supprime AS est_supprime_9, g1_.slug AS slug_10, g1_.id AS id_11, g1_.adresse AS adresse_12, g1_.nom AS nom_13, g1_.heure_debut_travail AS heure_debut_travail_14, g1_.heure_fin_travail AS heure_fin_travail_15, g1_.temps_de_travail AS temps_de_travail_16, g1_.sigle AS sigle_17, g1_.email AS email_18, g1_.phone AS phone_19, g1_.code_postal AS code_postal_20, g1_.ville AS ville_21, g1_.site_web AS site_web_22, g1_.fax AS fax_23, g1_.statut_juridique AS statut_juridique_24, g1_.capital AS capital_25, g1_.matricule AS matricule_26, g1_.siret AS siret_27, g1_.ape AS ape_28, g1_.cc AS cc_29, g1_.facture_tva AS facture_tva_30, g1_.mention_legal AS mention_legal_31, g1_.banque AS banque_32, g1_.rib AS rib_33, g1_.iban AS iban_34, g1_.bic AS bic_35, g1_.url_fnede_base AS url_fnede_base_36, g1_.api_key_fne AS api_key_fne_37, g1_.solde_timbre_fne AS solde_timbre_fne_38, g1_.numero_cnps AS numero_cnps_39 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
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.droits AS droits_16, t0.boutique_id AS boutique_id_17, t0.user_id AS user_id_18 FROM gestock_user_boutique t0 WHERE t0.user_id = ? AND t0.boutique_id = ? LIMIT 1

#▲	Time	Info
1	0.83 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.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: [`3`] View formatted query View runnable query Explain query 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 = ? 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 = 3;
2	0.46 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: [`"berassou-multi-services"`] View formatted query View runnable query Explain query 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 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 = 'berassou-multi-services' LIMIT 1;
3	1.42 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, SUM(g0_.total_ttc) AS sclr_39, SUM(g0_.total_tva) AS sclr_40 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0 Parameters: [`"%082026" 3`] View formatted query View runnable query Explain query 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, SUM(g0_.total_ttc) AS sclr_39, SUM(g0_.total_tva) AS sclr_40 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, SUM(g0_.total_ttc) AS sclr_39, SUM(g0_.total_tva) AS sclr_40 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE '%082026' AND g1_.id = 3 AND g0_.est_supprime = 0;
4	1.17 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, SUM(g0_.total_ttc) AS sclr_39, SUM(g0_.total_tva) AS sclr_40 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0 Parameters: [`"%2026" 3`] View formatted query View runnable query Explain query 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, SUM(g0_.total_ttc) AS sclr_39, SUM(g0_.total_tva) AS sclr_40 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, SUM(g0_.total_ttc) AS sclr_39, SUM(g0_.total_tva) AS sclr_40 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE '%2026' AND g1_.id = 3 AND g0_.est_supprime = 0;
5	0.76 ms	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, SUM(g0_.montant) AS sclr_9 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0 Parameters: [`"%082026" 3`] View formatted query View runnable query Explain query 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, SUM(g0_.montant) AS sclr_9 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0 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, SUM(g0_.montant) AS sclr_9 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE '%082026' AND g1_.id = 3 AND g0_.est_supprime = 0;
6	0.64 ms	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, SUM(g0_.montant) AS sclr_9 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0 Parameters: [`"%2026" 3`] View formatted query View runnable query Explain query 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, SUM(g0_.montant) AS sclr_9 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g1_.id = ? AND g0_.est_supprime = 0 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, SUM(g0_.montant) AS sclr_9 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE '%2026' AND g1_.id = 3 AND g0_.est_supprime = 0;
7	0.74 ms	SELECT g0_.id AS id_0, g0_.type_client AS type_client_1, g0_.nom AS nom_2, g0_.adresse AS adresse_3, g0_.code_postal AS code_postal_4, g0_.ville AS ville_5, g0_.email AS email_6, g0_.telephone AS telephone_7, g0_.assujetti_ala_tva AS assujetti_ala_tva_8, g0_.code_tva AS code_tva_9, g0_.est_supprime AS est_supprime_10, g0_.mois AS mois_11, g0_.annee AS annee_12, g0_.la_date AS la_date_13, COUNT(g0_.id) AS sclr_14 FROM gestock_tiers g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.est_supprime = 0 Parameters: [`3`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.type_client AS type_client_1, g0_.nom AS nom_2, g0_.adresse AS adresse_3, g0_.code_postal AS code_postal_4, g0_.ville AS ville_5, g0_.email AS email_6, g0_.telephone AS telephone_7, g0_.assujetti_ala_tva AS assujetti_ala_tva_8, g0_.code_tva AS code_tva_9, g0_.est_supprime AS est_supprime_10, g0_.mois AS mois_11, g0_.annee AS annee_12, g0_.la_date AS la_date_13, COUNT(g0_.id) AS sclr_14 FROM gestock_tiers g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.est_supprime = 0 SELECT g0_.id AS id_0, g0_.type_client AS type_client_1, g0_.nom AS nom_2, g0_.adresse AS adresse_3, g0_.code_postal AS code_postal_4, g0_.ville AS ville_5, g0_.email AS email_6, g0_.telephone AS telephone_7, g0_.assujetti_ala_tva AS assujetti_ala_tva_8, g0_.code_tva AS code_tva_9, g0_.est_supprime AS est_supprime_10, g0_.mois AS mois_11, g0_.annee AS annee_12, g0_.la_date AS la_date_13, COUNT(g0_.id) AS sclr_14 FROM gestock_tiers g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = 3 AND g0_.est_supprime = 0;
8	1.42 ms	SELECT g0_.slug AS slug_0, g0_.id AS id_1, g0_.reference AS reference_2, g0_.nom AS nom_3, g0_.prix_dachat AS prix_dachat_4, g0_.description AS description_5, g0_.stock_minimum AS stock_minimum_6, g0_.stock_disponible AS stock_disponible_7, g0_.stock_de_securite AS stock_de_securite_8, g0_.stock_dalerte AS stock_dalerte_9, g0_.stock_outil AS stock_outil_10, g0_.stock_maximum AS stock_maximum_11, g0_.cout_de_stockage AS cout_de_stockage_12, g0_.gere_le_stock AS gere_le_stock_13, g0_.unite_de_mesure AS unite_de_mesure_14, g0_.codebarre AS codebarre_15, g0_.est_supprime AS est_supprime_16, COUNT(g0_.id) AS sclr_17 FROM gestock_produit g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT g0_.slug AS slug_0, g0_.id AS id_1, g0_.reference AS reference_2, g0_.nom AS nom_3, g0_.prix_dachat AS prix_dachat_4, g0_.description AS description_5, g0_.stock_minimum AS stock_minimum_6, g0_.stock_disponible AS stock_disponible_7, g0_.stock_de_securite AS stock_de_securite_8, g0_.stock_dalerte AS stock_dalerte_9, g0_.stock_outil AS stock_outil_10, g0_.stock_maximum AS stock_maximum_11, g0_.cout_de_stockage AS cout_de_stockage_12, g0_.gere_le_stock AS gere_le_stock_13, g0_.unite_de_mesure AS unite_de_mesure_14, g0_.codebarre AS codebarre_15, g0_.est_supprime AS est_supprime_16, COUNT(g0_.id) AS sclr_17 FROM gestock_produit g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? SELECT g0_.slug AS slug_0, g0_.id AS id_1, g0_.reference AS reference_2, g0_.nom AS nom_3, g0_.prix_dachat AS prix_dachat_4, g0_.description AS description_5, g0_.stock_minimum AS stock_minimum_6, g0_.stock_disponible AS stock_disponible_7, g0_.stock_de_securite AS stock_de_securite_8, g0_.stock_dalerte AS stock_dalerte_9, g0_.stock_outil AS stock_outil_10, g0_.stock_maximum AS stock_maximum_11, g0_.cout_de_stockage AS cout_de_stockage_12, g0_.gere_le_stock AS gere_le_stock_13, g0_.unite_de_mesure AS unite_de_mesure_14, g0_.codebarre AS codebarre_15, g0_.est_supprime AS est_supprime_16, COUNT(g0_.id) AS sclr_17 FROM gestock_produit g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = 3;
9	3.77 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, g0_.mois AS mois_39, SUM(g0_.total_ttc) AS sclr_40, SUM(g0_.montant_paye) AS sclr_41 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g0_.est_supprime = 0 AND g0_.type_facture = ? AND g1_.id = ? GROUP BY g0_.mois ORDER BY mois_39 ASC Parameters: [`"%2026" "invoice" 3`] View formatted query View runnable query Explain query 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, g0_.mois AS mois_39, SUM(g0_.total_ttc) AS sclr_40, SUM(g0_.montant_paye) AS sclr_41 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE ? AND g0_.est_supprime = 0 AND g0_.type_facture = ? AND g1_.id = ? GROUP BY g0_.mois ORDER BY mois_39 ASC 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, g0_.mois AS mois_39, SUM(g0_.total_ttc) AS sclr_40, SUM(g0_.montant_paye) AS sclr_41 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.mois LIKE '%2026' AND g0_.est_supprime = 0 AND g0_.type_facture = 'invoice' AND g1_.id = 3 GROUP BY g0_.mois ORDER BY mois_39 ASC;
10	3.29 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, g0_.annee AS annee_39, SUM(g0_.total_ttc) AS sclr_40, SUM(g0_.montant_paye) AS sclr_41 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.est_supprime = 0 AND g0_.type_facture = ? GROUP BY g0_.annee ORDER BY annee_39 ASC Parameters: [`3 "invoice"`] View formatted query View runnable query Explain query 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, g0_.annee AS annee_39, SUM(g0_.total_ttc) AS sclr_40, SUM(g0_.montant_paye) AS sclr_41 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.est_supprime = 0 AND g0_.type_facture = ? GROUP BY g0_.annee ORDER BY annee_39 ASC 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, g0_.client_final_nom AS client_final_nom_36, g0_.client_final_numero AS client_final_numero_37, g0_.cout_de_revient AS cout_de_revient_38, g0_.annee AS annee_39, SUM(g0_.total_ttc) AS sclr_40, SUM(g0_.montant_paye) AS sclr_41 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = 3 AND g0_.est_supprime = 0 AND g0_.type_facture = 'invoice' GROUP BY g0_.annee ORDER BY annee_39 ASC;
11	2.88 ms	SELECT g0_.etat AS etat_0, g0_.type_facture AS type_facture_1, SUM(g0_.total_ht) AS sclr_2, g0_.id AS id_3, g0_.etat AS etat_4, g0_.etat_chaine AS etat_chaine_5, g0_.lien_pdf AS lien_pdf_6, g0_.la_date AS la_date_7, g0_.valable_jusqu_au AS valable_jusqu_au_8, g0_.total_ht AS total_ht_9, g0_.total_htapres_remise AS total_htapres_remise_10, g0_.type_facture AS type_facture_11, g0_.nature_facture AS nature_facture_12, g0_.total_tva AS total_tva_13, g0_.total_autre_taxe AS total_autre_taxe_14, g0_.autres_taxes AS autres_taxes_15, g0_.frais_de_port AS frais_de_port_16, g0_.total_ttc AS total_ttc_17, g0_.acquitee AS acquitee_18, g0_.numero AS numero_19, g0_.montant_paye AS montant_paye_20, g0_.reste_apayer AS reste_apayer_21, g0_.remise AS remise_22, g0_.remise_pourcentage AS remise_pourcentage_23, g0_.montant_en_lettre AS montant_en_lettre_24, g0_.observation_sur_facture AS observation_sur_facture_25, g0_.titre_document AS titre_document_26, g0_.mois AS mois_27, g0_.annee AS annee_28, g0_.observation AS observation_29, g0_.moyen_de_paiement AS moyen_de_paiement_30, g0_.id_facture_de_base AS id_facture_de_base_31, g0_.id_facture_fne AS id_facture_fne_32, g0_.token_fne AS token_fne_33, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_34, g0_.est_supprime AS est_supprime_35, g0_.matricule_vehicule AS matricule_vehicule_36, g0_.marque_vehicule AS marque_vehicule_37, g0_.kilometrage_vehicule AS kilometrage_vehicule_38, g0_.client_final_nom AS client_final_nom_39, g0_.client_final_numero AS client_final_numero_40, g0_.cout_de_revient AS cout_de_revient_41, g1_.slug AS slug_42, g1_.id AS id_43, g1_.adresse AS adresse_44, g1_.nom AS nom_45, g1_.heure_debut_travail AS heure_debut_travail_46, g1_.heure_fin_travail AS heure_fin_travail_47, g1_.temps_de_travail AS temps_de_travail_48, g1_.sigle AS sigle_49, g1_.email AS email_50, g1_.phone AS phone_51, g1_.code_postal AS code_postal_52, g1_.ville AS ville_53, g1_.site_web AS site_web_54, g1_.fax AS fax_55, g1_.statut_juridique AS statut_juridique_56, g1_.capital AS capital_57, g1_.matricule AS matricule_58, g1_.siret AS siret_59, g1_.ape AS ape_60, g1_.cc AS cc_61, g1_.facture_tva AS facture_tva_62, g1_.mention_legal AS mention_legal_63, g1_.banque AS banque_64, g1_.rib AS rib_65, g1_.iban AS iban_66, g1_.bic AS bic_67, g1_.url_fnede_base AS url_fnede_base_68, g1_.api_key_fne AS api_key_fne_69, g1_.solde_timbre_fne AS solde_timbre_fne_70, g1_.numero_cnps AS numero_cnps_71 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.type_facture = ? AND g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 GROUP BY g0_.type_facture ORDER BY type_facture_1 ASC Parameters: [`"invoice" 3 "2026-08-01 00:00:00" "2026-08-31 23:59:00"`] View formatted query View runnable query Explain query SELECT g0_.etat AS etat_0, g0_.type_facture AS type_facture_1, SUM(g0_.total_ht) AS sclr_2, g0_.id AS id_3, g0_.etat AS etat_4, g0_.etat_chaine AS etat_chaine_5, g0_.lien_pdf AS lien_pdf_6, g0_.la_date AS la_date_7, g0_.valable_jusqu_au AS valable_jusqu_au_8, g0_.total_ht AS total_ht_9, g0_.total_htapres_remise AS total_htapres_remise_10, g0_.type_facture AS type_facture_11, g0_.nature_facture AS nature_facture_12, g0_.total_tva AS total_tva_13, g0_.total_autre_taxe AS total_autre_taxe_14, g0_.autres_taxes AS autres_taxes_15, g0_.frais_de_port AS frais_de_port_16, g0_.total_ttc AS total_ttc_17, g0_.acquitee AS acquitee_18, g0_.numero AS numero_19, g0_.montant_paye AS montant_paye_20, g0_.reste_apayer AS reste_apayer_21, g0_.remise AS remise_22, g0_.remise_pourcentage AS remise_pourcentage_23, g0_.montant_en_lettre AS montant_en_lettre_24, g0_.observation_sur_facture AS observation_sur_facture_25, g0_.titre_document AS titre_document_26, g0_.mois AS mois_27, g0_.annee AS annee_28, g0_.observation AS observation_29, g0_.moyen_de_paiement AS moyen_de_paiement_30, g0_.id_facture_de_base AS id_facture_de_base_31, g0_.id_facture_fne AS id_facture_fne_32, g0_.token_fne AS token_fne_33, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_34, g0_.est_supprime AS est_supprime_35, g0_.matricule_vehicule AS matricule_vehicule_36, g0_.marque_vehicule AS marque_vehicule_37, g0_.kilometrage_vehicule AS kilometrage_vehicule_38, g0_.client_final_nom AS client_final_nom_39, g0_.client_final_numero AS client_final_numero_40, g0_.cout_de_revient AS cout_de_revient_41, g1_.slug AS slug_42, g1_.id AS id_43, g1_.adresse AS adresse_44, g1_.nom AS nom_45, g1_.heure_debut_travail AS heure_debut_travail_46, g1_.heure_fin_travail AS heure_fin_travail_47, g1_.temps_de_travail AS temps_de_travail_48, g1_.sigle AS sigle_49, g1_.email AS email_50, g1_.phone AS phone_51, g1_.code_postal AS code_postal_52, g1_.ville AS ville_53, g1_.site_web AS site_web_54, g1_.fax AS fax_55, g1_.statut_juridique AS statut_juridique_56, g1_.capital AS capital_57, g1_.matricule AS matricule_58, g1_.siret AS siret_59, g1_.ape AS ape_60, g1_.cc AS cc_61, g1_.facture_tva AS facture_tva_62, g1_.mention_legal AS mention_legal_63, g1_.banque AS banque_64, g1_.rib AS rib_65, g1_.iban AS iban_66, g1_.bic AS bic_67, g1_.url_fnede_base AS url_fnede_base_68, g1_.api_key_fne AS api_key_fne_69, g1_.solde_timbre_fne AS solde_timbre_fne_70, g1_.numero_cnps AS numero_cnps_71 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.type_facture = ? AND g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 GROUP BY g0_.type_facture ORDER BY type_facture_1 ASC SELECT g0_.etat AS etat_0, g0_.type_facture AS type_facture_1, SUM(g0_.total_ht) AS sclr_2, g0_.id AS id_3, g0_.etat AS etat_4, g0_.etat_chaine AS etat_chaine_5, g0_.lien_pdf AS lien_pdf_6, g0_.la_date AS la_date_7, g0_.valable_jusqu_au AS valable_jusqu_au_8, g0_.total_ht AS total_ht_9, g0_.total_htapres_remise AS total_htapres_remise_10, g0_.type_facture AS type_facture_11, g0_.nature_facture AS nature_facture_12, g0_.total_tva AS total_tva_13, g0_.total_autre_taxe AS total_autre_taxe_14, g0_.autres_taxes AS autres_taxes_15, g0_.frais_de_port AS frais_de_port_16, g0_.total_ttc AS total_ttc_17, g0_.acquitee AS acquitee_18, g0_.numero AS numero_19, g0_.montant_paye AS montant_paye_20, g0_.reste_apayer AS reste_apayer_21, g0_.remise AS remise_22, g0_.remise_pourcentage AS remise_pourcentage_23, g0_.montant_en_lettre AS montant_en_lettre_24, g0_.observation_sur_facture AS observation_sur_facture_25, g0_.titre_document AS titre_document_26, g0_.mois AS mois_27, g0_.annee AS annee_28, g0_.observation AS observation_29, g0_.moyen_de_paiement AS moyen_de_paiement_30, g0_.id_facture_de_base AS id_facture_de_base_31, g0_.id_facture_fne AS id_facture_fne_32, g0_.token_fne AS token_fne_33, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_34, g0_.est_supprime AS est_supprime_35, g0_.matricule_vehicule AS matricule_vehicule_36, g0_.marque_vehicule AS marque_vehicule_37, g0_.kilometrage_vehicule AS kilometrage_vehicule_38, g0_.client_final_nom AS client_final_nom_39, g0_.client_final_numero AS client_final_numero_40, g0_.cout_de_revient AS cout_de_revient_41, g1_.slug AS slug_42, g1_.id AS id_43, g1_.adresse AS adresse_44, g1_.nom AS nom_45, g1_.heure_debut_travail AS heure_debut_travail_46, g1_.heure_fin_travail AS heure_fin_travail_47, g1_.temps_de_travail AS temps_de_travail_48, g1_.sigle AS sigle_49, g1_.email AS email_50, g1_.phone AS phone_51, g1_.code_postal AS code_postal_52, g1_.ville AS ville_53, g1_.site_web AS site_web_54, g1_.fax AS fax_55, g1_.statut_juridique AS statut_juridique_56, g1_.capital AS capital_57, g1_.matricule AS matricule_58, g1_.siret AS siret_59, g1_.ape AS ape_60, g1_.cc AS cc_61, g1_.facture_tva AS facture_tva_62, g1_.mention_legal AS mention_legal_63, g1_.banque AS banque_64, g1_.rib AS rib_65, g1_.iban AS iban_66, g1_.bic AS bic_67, g1_.url_fnede_base AS url_fnede_base_68, g1_.api_key_fne AS api_key_fne_69, g1_.solde_timbre_fne AS solde_timbre_fne_70, g1_.numero_cnps AS numero_cnps_71 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.type_facture = 'invoice' AND g1_.id = 3 AND g0_.la_date >= '2026-08-01 00:00:00' AND g0_.la_date <= '2026-08-31 23:59:00' AND g0_.est_supprime = 0 GROUP BY g0_.type_facture ORDER BY type_facture_1 ASC;
12	2.89 ms	SELECT g0_.etat AS etat_0, g0_.type_facture AS type_facture_1, SUM(g0_.total_ht) AS sclr_2, g0_.id AS id_3, g0_.etat AS etat_4, g0_.etat_chaine AS etat_chaine_5, g0_.lien_pdf AS lien_pdf_6, g0_.la_date AS la_date_7, g0_.valable_jusqu_au AS valable_jusqu_au_8, g0_.total_ht AS total_ht_9, g0_.total_htapres_remise AS total_htapres_remise_10, g0_.type_facture AS type_facture_11, g0_.nature_facture AS nature_facture_12, g0_.total_tva AS total_tva_13, g0_.total_autre_taxe AS total_autre_taxe_14, g0_.autres_taxes AS autres_taxes_15, g0_.frais_de_port AS frais_de_port_16, g0_.total_ttc AS total_ttc_17, g0_.acquitee AS acquitee_18, g0_.numero AS numero_19, g0_.montant_paye AS montant_paye_20, g0_.reste_apayer AS reste_apayer_21, g0_.remise AS remise_22, g0_.remise_pourcentage AS remise_pourcentage_23, g0_.montant_en_lettre AS montant_en_lettre_24, g0_.observation_sur_facture AS observation_sur_facture_25, g0_.titre_document AS titre_document_26, g0_.mois AS mois_27, g0_.annee AS annee_28, g0_.observation AS observation_29, g0_.moyen_de_paiement AS moyen_de_paiement_30, g0_.id_facture_de_base AS id_facture_de_base_31, g0_.id_facture_fne AS id_facture_fne_32, g0_.token_fne AS token_fne_33, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_34, g0_.est_supprime AS est_supprime_35, g0_.matricule_vehicule AS matricule_vehicule_36, g0_.marque_vehicule AS marque_vehicule_37, g0_.kilometrage_vehicule AS kilometrage_vehicule_38, g0_.client_final_nom AS client_final_nom_39, g0_.client_final_numero AS client_final_numero_40, g0_.cout_de_revient AS cout_de_revient_41, g1_.slug AS slug_42, g1_.id AS id_43, g1_.adresse AS adresse_44, g1_.nom AS nom_45, g1_.heure_debut_travail AS heure_debut_travail_46, g1_.heure_fin_travail AS heure_fin_travail_47, g1_.temps_de_travail AS temps_de_travail_48, g1_.sigle AS sigle_49, g1_.email AS email_50, g1_.phone AS phone_51, g1_.code_postal AS code_postal_52, g1_.ville AS ville_53, g1_.site_web AS site_web_54, g1_.fax AS fax_55, g1_.statut_juridique AS statut_juridique_56, g1_.capital AS capital_57, g1_.matricule AS matricule_58, g1_.siret AS siret_59, g1_.ape AS ape_60, g1_.cc AS cc_61, g1_.facture_tva AS facture_tva_62, g1_.mention_legal AS mention_legal_63, g1_.banque AS banque_64, g1_.rib AS rib_65, g1_.iban AS iban_66, g1_.bic AS bic_67, g1_.url_fnede_base AS url_fnede_base_68, g1_.api_key_fne AS api_key_fne_69, g1_.solde_timbre_fne AS solde_timbre_fne_70, g1_.numero_cnps AS numero_cnps_71 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.type_facture = ? AND g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 GROUP BY g0_.type_facture ORDER BY type_facture_1 ASC Parameters: [`"proposal" 3 "2026-08-01 00:00:00" "2026-08-31 23:59:00"`] View formatted query View runnable query Explain query SELECT g0_.etat AS etat_0, g0_.type_facture AS type_facture_1, SUM(g0_.total_ht) AS sclr_2, g0_.id AS id_3, g0_.etat AS etat_4, g0_.etat_chaine AS etat_chaine_5, g0_.lien_pdf AS lien_pdf_6, g0_.la_date AS la_date_7, g0_.valable_jusqu_au AS valable_jusqu_au_8, g0_.total_ht AS total_ht_9, g0_.total_htapres_remise AS total_htapres_remise_10, g0_.type_facture AS type_facture_11, g0_.nature_facture AS nature_facture_12, g0_.total_tva AS total_tva_13, g0_.total_autre_taxe AS total_autre_taxe_14, g0_.autres_taxes AS autres_taxes_15, g0_.frais_de_port AS frais_de_port_16, g0_.total_ttc AS total_ttc_17, g0_.acquitee AS acquitee_18, g0_.numero AS numero_19, g0_.montant_paye AS montant_paye_20, g0_.reste_apayer AS reste_apayer_21, g0_.remise AS remise_22, g0_.remise_pourcentage AS remise_pourcentage_23, g0_.montant_en_lettre AS montant_en_lettre_24, g0_.observation_sur_facture AS observation_sur_facture_25, g0_.titre_document AS titre_document_26, g0_.mois AS mois_27, g0_.annee AS annee_28, g0_.observation AS observation_29, g0_.moyen_de_paiement AS moyen_de_paiement_30, g0_.id_facture_de_base AS id_facture_de_base_31, g0_.id_facture_fne AS id_facture_fne_32, g0_.token_fne AS token_fne_33, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_34, g0_.est_supprime AS est_supprime_35, g0_.matricule_vehicule AS matricule_vehicule_36, g0_.marque_vehicule AS marque_vehicule_37, g0_.kilometrage_vehicule AS kilometrage_vehicule_38, g0_.client_final_nom AS client_final_nom_39, g0_.client_final_numero AS client_final_numero_40, g0_.cout_de_revient AS cout_de_revient_41, g1_.slug AS slug_42, g1_.id AS id_43, g1_.adresse AS adresse_44, g1_.nom AS nom_45, g1_.heure_debut_travail AS heure_debut_travail_46, g1_.heure_fin_travail AS heure_fin_travail_47, g1_.temps_de_travail AS temps_de_travail_48, g1_.sigle AS sigle_49, g1_.email AS email_50, g1_.phone AS phone_51, g1_.code_postal AS code_postal_52, g1_.ville AS ville_53, g1_.site_web AS site_web_54, g1_.fax AS fax_55, g1_.statut_juridique AS statut_juridique_56, g1_.capital AS capital_57, g1_.matricule AS matricule_58, g1_.siret AS siret_59, g1_.ape AS ape_60, g1_.cc AS cc_61, g1_.facture_tva AS facture_tva_62, g1_.mention_legal AS mention_legal_63, g1_.banque AS banque_64, g1_.rib AS rib_65, g1_.iban AS iban_66, g1_.bic AS bic_67, g1_.url_fnede_base AS url_fnede_base_68, g1_.api_key_fne AS api_key_fne_69, g1_.solde_timbre_fne AS solde_timbre_fne_70, g1_.numero_cnps AS numero_cnps_71 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.type_facture = ? AND g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? AND g0_.est_supprime = 0 GROUP BY g0_.type_facture ORDER BY type_facture_1 ASC SELECT g0_.etat AS etat_0, g0_.type_facture AS type_facture_1, SUM(g0_.total_ht) AS sclr_2, g0_.id AS id_3, g0_.etat AS etat_4, g0_.etat_chaine AS etat_chaine_5, g0_.lien_pdf AS lien_pdf_6, g0_.la_date AS la_date_7, g0_.valable_jusqu_au AS valable_jusqu_au_8, g0_.total_ht AS total_ht_9, g0_.total_htapres_remise AS total_htapres_remise_10, g0_.type_facture AS type_facture_11, g0_.nature_facture AS nature_facture_12, g0_.total_tva AS total_tva_13, g0_.total_autre_taxe AS total_autre_taxe_14, g0_.autres_taxes AS autres_taxes_15, g0_.frais_de_port AS frais_de_port_16, g0_.total_ttc AS total_ttc_17, g0_.acquitee AS acquitee_18, g0_.numero AS numero_19, g0_.montant_paye AS montant_paye_20, g0_.reste_apayer AS reste_apayer_21, g0_.remise AS remise_22, g0_.remise_pourcentage AS remise_pourcentage_23, g0_.montant_en_lettre AS montant_en_lettre_24, g0_.observation_sur_facture AS observation_sur_facture_25, g0_.titre_document AS titre_document_26, g0_.mois AS mois_27, g0_.annee AS annee_28, g0_.observation AS observation_29, g0_.moyen_de_paiement AS moyen_de_paiement_30, g0_.id_facture_de_base AS id_facture_de_base_31, g0_.id_facture_fne AS id_facture_fne_32, g0_.token_fne AS token_fne_33, g0_.warning_solde_timbre_fne AS warning_solde_timbre_fne_34, g0_.est_supprime AS est_supprime_35, g0_.matricule_vehicule AS matricule_vehicule_36, g0_.marque_vehicule AS marque_vehicule_37, g0_.kilometrage_vehicule AS kilometrage_vehicule_38, g0_.client_final_nom AS client_final_nom_39, g0_.client_final_numero AS client_final_numero_40, g0_.cout_de_revient AS cout_de_revient_41, g1_.slug AS slug_42, g1_.id AS id_43, g1_.adresse AS adresse_44, g1_.nom AS nom_45, g1_.heure_debut_travail AS heure_debut_travail_46, g1_.heure_fin_travail AS heure_fin_travail_47, g1_.temps_de_travail AS temps_de_travail_48, g1_.sigle AS sigle_49, g1_.email AS email_50, g1_.phone AS phone_51, g1_.code_postal AS code_postal_52, g1_.ville AS ville_53, g1_.site_web AS site_web_54, g1_.fax AS fax_55, g1_.statut_juridique AS statut_juridique_56, g1_.capital AS capital_57, g1_.matricule AS matricule_58, g1_.siret AS siret_59, g1_.ape AS ape_60, g1_.cc AS cc_61, g1_.facture_tva AS facture_tva_62, g1_.mention_legal AS mention_legal_63, g1_.banque AS banque_64, g1_.rib AS rib_65, g1_.iban AS iban_66, g1_.bic AS bic_67, g1_.url_fnede_base AS url_fnede_base_68, g1_.api_key_fne AS api_key_fne_69, g1_.solde_timbre_fne AS solde_timbre_fne_70, g1_.numero_cnps AS numero_cnps_71 FROM gestock_commande g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g0_.type_facture = 'proposal' AND g1_.id = 3 AND g0_.la_date >= '2026-08-01 00:00:00' AND g0_.la_date <= '2026-08-31 23:59:00' AND g0_.est_supprime = 0 GROUP BY g0_.type_facture ORDER BY type_facture_1 ASC;
13	0.68 ms	SELECT SUM(g0_.montant) AS sclr_0, g0_.id AS id_1, g0_.la_date AS la_date_2, g0_.montant AS montant_3, g0_.reference_paiement AS reference_paiement_4, g0_.moyen_de_paiement AS moyen_de_paiement_5, g1_.slug AS slug_6, g1_.id AS id_7, g1_.adresse AS adresse_8, g1_.nom AS nom_9, g1_.heure_debut_travail AS heure_debut_travail_10, g1_.heure_fin_travail AS heure_fin_travail_11, g1_.temps_de_travail AS temps_de_travail_12, g1_.sigle AS sigle_13, g1_.email AS email_14, g1_.phone AS phone_15, g1_.code_postal AS code_postal_16, g1_.ville AS ville_17, g1_.site_web AS site_web_18, g1_.fax AS fax_19, g1_.statut_juridique AS statut_juridique_20, g1_.capital AS capital_21, g1_.matricule AS matricule_22, g1_.siret AS siret_23, g1_.ape AS ape_24, g1_.cc AS cc_25, g1_.facture_tva AS facture_tva_26, g1_.mention_legal AS mention_legal_27, g1_.banque AS banque_28, g1_.rib AS rib_29, g1_.iban AS iban_30, g1_.bic AS bic_31, g1_.url_fnede_base AS url_fnede_base_32, g1_.api_key_fne AS api_key_fne_33, g1_.solde_timbre_fne AS solde_timbre_fne_34, g1_.numero_cnps AS numero_cnps_35 FROM gestock_payment g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? Parameters: [`3 "2026-08-01 00:00:00" "2026-08-31 23:59:00"`] View formatted query View runnable query Explain query SELECT SUM(g0_.montant) AS sclr_0, g0_.id AS id_1, g0_.la_date AS la_date_2, g0_.montant AS montant_3, g0_.reference_paiement AS reference_paiement_4, g0_.moyen_de_paiement AS moyen_de_paiement_5, g1_.slug AS slug_6, g1_.id AS id_7, g1_.adresse AS adresse_8, g1_.nom AS nom_9, g1_.heure_debut_travail AS heure_debut_travail_10, g1_.heure_fin_travail AS heure_fin_travail_11, g1_.temps_de_travail AS temps_de_travail_12, g1_.sigle AS sigle_13, g1_.email AS email_14, g1_.phone AS phone_15, g1_.code_postal AS code_postal_16, g1_.ville AS ville_17, g1_.site_web AS site_web_18, g1_.fax AS fax_19, g1_.statut_juridique AS statut_juridique_20, g1_.capital AS capital_21, g1_.matricule AS matricule_22, g1_.siret AS siret_23, g1_.ape AS ape_24, g1_.cc AS cc_25, g1_.facture_tva AS facture_tva_26, g1_.mention_legal AS mention_legal_27, g1_.banque AS banque_28, g1_.rib AS rib_29, g1_.iban AS iban_30, g1_.bic AS bic_31, g1_.url_fnede_base AS url_fnede_base_32, g1_.api_key_fne AS api_key_fne_33, g1_.solde_timbre_fne AS solde_timbre_fne_34, g1_.numero_cnps AS numero_cnps_35 FROM gestock_payment g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = ? AND g0_.la_date >= ? AND g0_.la_date <= ? SELECT SUM(g0_.montant) AS sclr_0, g0_.id AS id_1, g0_.la_date AS la_date_2, g0_.montant AS montant_3, g0_.reference_paiement AS reference_paiement_4, g0_.moyen_de_paiement AS moyen_de_paiement_5, g1_.slug AS slug_6, g1_.id AS id_7, g1_.adresse AS adresse_8, g1_.nom AS nom_9, g1_.heure_debut_travail AS heure_debut_travail_10, g1_.heure_fin_travail AS heure_fin_travail_11, g1_.temps_de_travail AS temps_de_travail_12, g1_.sigle AS sigle_13, g1_.email AS email_14, g1_.phone AS phone_15, g1_.code_postal AS code_postal_16, g1_.ville AS ville_17, g1_.site_web AS site_web_18, g1_.fax AS fax_19, g1_.statut_juridique AS statut_juridique_20, g1_.capital AS capital_21, g1_.matricule AS matricule_22, g1_.siret AS siret_23, g1_.ape AS ape_24, g1_.cc AS cc_25, g1_.facture_tva AS facture_tva_26, g1_.mention_legal AS mention_legal_27, g1_.banque AS banque_28, g1_.rib AS rib_29, g1_.iban AS iban_30, g1_.bic AS bic_31, g1_.url_fnede_base AS url_fnede_base_32, g1_.api_key_fne AS api_key_fne_33, g1_.solde_timbre_fne AS solde_timbre_fne_34, g1_.numero_cnps AS numero_cnps_35 FROM gestock_payment g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = 3 AND g0_.la_date >= '2026-08-01 00:00:00' AND g0_.la_date <= '2026-08-31 23:59:00';
14	0.78 ms	SELECT SUM(g0_.montant) AS sclr_0, g0_.id AS id_1, g0_.la_date AS la_date_2, g0_.piece AS piece_3, g0_.detail AS detail_4, g0_.moyen_de_paiement AS moyen_de_paiement_5, g0_.montant AS montant_6, g0_.mois AS mois_7, g0_.annee AS annee_8, g0_.est_supprime AS est_supprime_9, g1_.slug AS slug_10, g1_.id AS id_11, g1_.adresse AS adresse_12, g1_.nom AS nom_13, g1_.heure_debut_travail AS heure_debut_travail_14, g1_.heure_fin_travail AS heure_fin_travail_15, g1_.temps_de_travail AS temps_de_travail_16, g1_.sigle AS sigle_17, g1_.email AS email_18, g1_.phone AS phone_19, g1_.code_postal AS code_postal_20, g1_.ville AS ville_21, g1_.site_web AS site_web_22, g1_.fax AS fax_23, g1_.statut_juridique AS statut_juridique_24, g1_.capital AS capital_25, g1_.matricule AS matricule_26, g1_.siret AS siret_27, g1_.ape AS ape_28, g1_.cc AS cc_29, g1_.facture_tva AS facture_tva_30, g1_.mention_legal AS mention_legal_31, g1_.banque AS banque_32, g1_.rib AS rib_33, g1_.iban AS iban_34, g1_.bic AS bic_35, g1_.url_fnede_base AS url_fnede_base_36, g1_.api_key_fne AS api_key_fne_37, g1_.solde_timbre_fne AS solde_timbre_fne_38, g1_.numero_cnps AS numero_cnps_39 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 Parameters: [`3 "2026-08-01 00:00:00" "2026-08-31 23:59:00"`] View formatted query View runnable query Explain query SELECT SUM(g0_.montant) AS sclr_0, g0_.id AS id_1, g0_.la_date AS la_date_2, g0_.piece AS piece_3, g0_.detail AS detail_4, g0_.moyen_de_paiement AS moyen_de_paiement_5, g0_.montant AS montant_6, g0_.mois AS mois_7, g0_.annee AS annee_8, g0_.est_supprime AS est_supprime_9, g1_.slug AS slug_10, g1_.id AS id_11, g1_.adresse AS adresse_12, g1_.nom AS nom_13, g1_.heure_debut_travail AS heure_debut_travail_14, g1_.heure_fin_travail AS heure_fin_travail_15, g1_.temps_de_travail AS temps_de_travail_16, g1_.sigle AS sigle_17, g1_.email AS email_18, g1_.phone AS phone_19, g1_.code_postal AS code_postal_20, g1_.ville AS ville_21, g1_.site_web AS site_web_22, g1_.fax AS fax_23, g1_.statut_juridique AS statut_juridique_24, g1_.capital AS capital_25, g1_.matricule AS matricule_26, g1_.siret AS siret_27, g1_.ape AS ape_28, g1_.cc AS cc_29, g1_.facture_tva AS facture_tva_30, g1_.mention_legal AS mention_legal_31, g1_.banque AS banque_32, g1_.rib AS rib_33, g1_.iban AS iban_34, g1_.bic AS bic_35, g1_.url_fnede_base AS url_fnede_base_36, g1_.api_key_fne AS api_key_fne_37, g1_.solde_timbre_fne AS solde_timbre_fne_38, g1_.numero_cnps AS numero_cnps_39 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 SELECT SUM(g0_.montant) AS sclr_0, g0_.id AS id_1, g0_.la_date AS la_date_2, g0_.piece AS piece_3, g0_.detail AS detail_4, g0_.moyen_de_paiement AS moyen_de_paiement_5, g0_.montant AS montant_6, g0_.mois AS mois_7, g0_.annee AS annee_8, g0_.est_supprime AS est_supprime_9, g1_.slug AS slug_10, g1_.id AS id_11, g1_.adresse AS adresse_12, g1_.nom AS nom_13, g1_.heure_debut_travail AS heure_debut_travail_14, g1_.heure_fin_travail AS heure_fin_travail_15, g1_.temps_de_travail AS temps_de_travail_16, g1_.sigle AS sigle_17, g1_.email AS email_18, g1_.phone AS phone_19, g1_.code_postal AS code_postal_20, g1_.ville AS ville_21, g1_.site_web AS site_web_22, g1_.fax AS fax_23, g1_.statut_juridique AS statut_juridique_24, g1_.capital AS capital_25, g1_.matricule AS matricule_26, g1_.siret AS siret_27, g1_.ape AS ape_28, g1_.cc AS cc_29, g1_.facture_tva AS facture_tva_30, g1_.mention_legal AS mention_legal_31, g1_.banque AS banque_32, g1_.rib AS rib_33, g1_.iban AS iban_34, g1_.bic AS bic_35, g1_.url_fnede_base AS url_fnede_base_36, g1_.api_key_fne AS api_key_fne_37, g1_.solde_timbre_fne AS solde_timbre_fne_38, g1_.numero_cnps AS numero_cnps_39 FROM gestock_expensive g0_ LEFT JOIN gestock_boutique g1_ ON g0_.boutique_id = g1_.id WHERE g1_.id = 3 AND g0_.la_date >= '2026-08-01 00:00:00' AND g0_.la_date <= '2026-08-31 23:59:00' AND g0_.est_supprime = 0;
15	0.42 ms	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.droits AS droits_16, t0.boutique_id AS boutique_id_17, t0.user_id AS user_id_18 FROM gestock_user_boutique t0 WHERE t0.user_id = ? AND t0.boutique_id = ? LIMIT 1 Parameters: [`3 3`] View formatted query View runnable query Explain query 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.droits AS droits_16, t0.boutique_id AS boutique_id_17, t0.user_id AS user_id_18 FROM gestock_user_boutique t0 WHERE t0.user_id = ? AND t0.boutique_id = ? LIMIT 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.droits AS droits_16, t0.boutique_id AS boutique_id_17, t0.user_id AS user_id_18 FROM gestock_user_boutique t0 WHERE t0.user_id = 3 AND t0.boutique_id = 3 LIMIT 1;

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

Symfony Profiler

https://harmony.assiecloud.com/fr/dashboard/shop/berassou-multi-services/mini-statistic Return to referer URL

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping