Symfony Profiler

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 = 1;

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.adresse AS adresse_3,
  t0.nom AS nom_4,
  t0.heure_debut_travail AS heure_debut_travail_5,
  t0.heure_fin_travail AS heure_fin_travail_6,
  t0.temps_de_travail AS temps_de_travail_7,
  t0.sigle AS sigle_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.code_postal AS code_postal_11,
  t0.ville AS ville_12,
  t0.site_web AS site_web_13,
  t0.fax AS fax_14,
  t0.statut_juridique AS statut_juridique_15,
  t0.capital AS capital_16,
  t0.matricule AS matricule_17,
  t0.siret AS siret_18,
  t0.ape AS ape_19,
  t0.cc AS cc_20,
  t0.facture_tva AS facture_tva_21,
  t0.mention_legal AS mention_legal_22,
  t0.banque AS banque_23,
  t0.rib AS rib_24,
  t0.iban AS iban_25,
  t0.bic AS bic_26,
  t0.url_fnede_base AS url_fnede_base_27,
  t0.api_key_fne AS api_key_fne_28,
  t0.solde_timbre_fne AS solde_timbre_fne_29,
  t0.numero_cnps AS numero_cnps_30,
  t0.logo_id AS logo_id_31,
  t0.settings_id AS settings_id_32,
  t0.pays_id AS pays_id_33
FROM
  gestock_boutique t0
WHERE
  t0.slug = ?
LIMIT
  1

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 = 'assie-technologie-et-ingenierie-1' 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 = ?
  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 = 1 AND t0.boutique_id = 1 LIMIT 1;

SELECT
  e0_.mois AS mois_0,
  e0_.annee AS annee_1,
  e0_.id AS id_2,
  e0_.libelle_ecriture AS libelle_ecriture_3,
  e0_.credit AS credit_4,
  e0_.debit AS debit_5,
  e0_.solde AS solde_6,
  e0_.la_date AS la_date_7,
  e0_.numero_piece AS numero_piece_8,
  g1_.slug AS slug_9,
  g1_.id AS id_10,
  g1_.adresse AS adresse_11,
  g1_.nom AS nom_12,
  g1_.heure_debut_travail AS heure_debut_travail_13,
  g1_.heure_fin_travail AS heure_fin_travail_14,
  g1_.temps_de_travail AS temps_de_travail_15,
  g1_.sigle AS sigle_16,
  g1_.email AS email_17,
  g1_.phone AS phone_18,
  g1_.code_postal AS code_postal_19,
  g1_.ville AS ville_20,
  g1_.site_web AS site_web_21,
  g1_.fax AS fax_22,
  g1_.statut_juridique AS statut_juridique_23,
  g1_.capital AS capital_24,
  g1_.matricule AS matricule_25,
  g1_.siret AS siret_26,
  g1_.ape AS ape_27,
  g1_.cc AS cc_28,
  g1_.facture_tva AS facture_tva_29,
  g1_.mention_legal AS mention_legal_30,
  g1_.banque AS banque_31,
  g1_.rib AS rib_32,
  g1_.iban AS iban_33,
  g1_.bic AS bic_34,
  g1_.url_fnede_base AS url_fnede_base_35,
  g1_.api_key_fne AS api_key_fne_36,
  g1_.solde_timbre_fne AS solde_timbre_fne_37,
  g1_.numero_cnps AS numero_cnps_38,
  c2_.id AS id_39,
  c2_.numero AS numero_40,
  c2_.nom AS nom_41,
  c2_.annee AS annee_42,
  c2_.mois AS mois_43,
  c2_.debit AS debit_44,
  c2_.credit AS credit_45,
  c2_.solde AS solde_46,
  c2_.famille AS famille_47,
  c2_.categorie_pour_bilan AS categorie_pour_bilan_48,
  c2_.rubrique_pour_bilan AS rubrique_pour_bilan_49,
  e0_.boutique_id AS boutique_id_50,
  e0_.le_journal_id AS le_journal_id_51,
  e0_.compte_id AS compte_id_52,
  e0_.groupe_ecriture_comptable_id AS groupe_ecriture_comptable_id_53,
  g1_.logo_id AS logo_id_54,
  g1_.settings_id AS settings_id_55,
  g1_.pays_id AS pays_id_56,
  c2_.boutique_id AS boutique_id_57,
  c2_.la_classe_id AS la_classe_id_58
FROM
  ecriture_comptable e0_
  LEFT JOIN gestock_boutique g1_ ON e0_.boutique_id = g1_.id
  LEFT JOIN compte c2_ ON e0_.compte_id = c2_.id
WHERE
  g1_.id = ?
  AND c2_.id = ?
  AND e0_.la_date >= ?
  AND e0_.la_date <= ?
ORDER BY
  e0_.la_date DESC

SELECT e0_.mois AS mois_0, e0_.annee AS annee_1, e0_.id AS id_2, e0_.libelle_ecriture AS libelle_ecriture_3, e0_.credit AS credit_4, e0_.debit AS debit_5, e0_.solde AS solde_6, e0_.la_date AS la_date_7, e0_.numero_piece AS numero_piece_8, g1_.slug AS slug_9, g1_.id AS id_10, g1_.adresse AS adresse_11, g1_.nom AS nom_12, g1_.heure_debut_travail AS heure_debut_travail_13, g1_.heure_fin_travail AS heure_fin_travail_14, g1_.temps_de_travail AS temps_de_travail_15, g1_.sigle AS sigle_16, g1_.email AS email_17, g1_.phone AS phone_18, g1_.code_postal AS code_postal_19, g1_.ville AS ville_20, g1_.site_web AS site_web_21, g1_.fax AS fax_22, g1_.statut_juridique AS statut_juridique_23, g1_.capital AS capital_24, g1_.matricule AS matricule_25, g1_.siret AS siret_26, g1_.ape AS ape_27, g1_.cc AS cc_28, g1_.facture_tva AS facture_tva_29, g1_.mention_legal AS mention_legal_30, g1_.banque AS banque_31, g1_.rib AS rib_32, g1_.iban AS iban_33, g1_.bic AS bic_34, g1_.url_fnede_base AS url_fnede_base_35, g1_.api_key_fne AS api_key_fne_36, g1_.solde_timbre_fne AS solde_timbre_fne_37, g1_.numero_cnps AS numero_cnps_38, c2_.id AS id_39, c2_.numero AS numero_40, c2_.nom AS nom_41, c2_.annee AS annee_42, c2_.mois AS mois_43, c2_.debit AS debit_44, c2_.credit AS credit_45, c2_.solde AS solde_46, c2_.famille AS famille_47, c2_.categorie_pour_bilan AS categorie_pour_bilan_48, c2_.rubrique_pour_bilan AS rubrique_pour_bilan_49, e0_.boutique_id AS boutique_id_50, e0_.le_journal_id AS le_journal_id_51, e0_.compte_id AS compte_id_52, e0_.groupe_ecriture_comptable_id AS groupe_ecriture_comptable_id_53, g1_.logo_id AS logo_id_54, g1_.settings_id AS settings_id_55, g1_.pays_id AS pays_id_56, c2_.boutique_id AS boutique_id_57, c2_.la_classe_id AS la_classe_id_58 FROM ecriture_comptable e0_ LEFT JOIN gestock_boutique g1_ ON e0_.boutique_id = g1_.id LEFT JOIN compte c2_ ON e0_.compte_id = c2_.id WHERE g1_.id = 1 AND c2_.id = '235' AND e0_.la_date >= '2026-06-01 00:00:00' AND e0_.la_date <= '2026-06-07 00:00:00' ORDER BY e0_.la_date DESC;