Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.mail AS mail_7,
  t0.is_verified AS is_verified_8,
  t0.failed_login_count AS failed_login_count_9,
  t0.last_failed_login_at AS last_failed_login_at_10,
  t0.last_login_at AS last_login_at_11,
  t0.is_validated AS is_validated_12,
  t0.token AS token_13
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.mail AS mail_7, t0.is_verified AS is_verified_8, t0.failed_login_count AS failed_login_count_9, t0.last_failed_login_at AS last_failed_login_at_10, t0.last_login_at AS last_login_at_11, t0.is_validated AS is_validated_12, t0.token AS token_13 FROM `user` t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.datestart AS datestart_3,
  t0.dateend AS dateend_4,
  t0.comment AS comment_5,
  t0.statut_close AS statut_close_6,
  t0.statut_lock AS statut_lock_7,
  t0.locked_at AS locked_at_8,
  t0.closed_at AS closed_at_9
FROM
  accounting_year t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.year AS year_2, t0.datestart AS datestart_3, t0.dateend AS dateend_4, t0.comment AS comment_5, t0.statut_close AS statut_close_6, t0.statut_lock AS statut_lock_7, t0.locked_at AS locked_at_8, t0.closed_at AS closed_at_9 FROM accounting_year t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.slug AS slug_4,
  t0.label AS label_5,
  t0.position AS position_6,
  t0.target AS target_7,
  t0.lockable AS lockable_8,
  t0.menu_item AS menu_item_9,
  t0.roles_acl AS roles_acl_10,
  t0.roles_menu AS roles_menu_11,
  t0.displayable AS displayable_12,
  t0.positionabsolute AS positionabsolute_13,
  t0.actif AS actif_14,
  t0.allow_writing AS allow_writing_15,
  t0.allow_deleting AS allow_deleting_16,
  t0.allow_validating AS allow_validating_17,
  t0.parent_id AS parent_id_18
FROM
  menu t0
WHERE
  t0.path = ?
  AND t0.actif = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.slug AS slug_4, t0.label AS label_5, t0.position AS position_6, t0.target AS target_7, t0.lockable AS lockable_8, t0.menu_item AS menu_item_9, t0.roles_acl AS roles_acl_10, t0.roles_menu AS roles_menu_11, t0.displayable AS displayable_12, t0.positionabsolute AS positionabsolute_13, t0.actif AS actif_14, t0.allow_writing AS allow_writing_15, t0.allow_deleting AS allow_deleting_16, t0.allow_validating AS allow_validating_17, t0.parent_id AS parent_id_18 FROM menu t0 WHERE t0.path = 'app_general_balance_grandlivre' AND t0.actif = 1 LIMIT 1;

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2,
  t0.`group` AS group_3,
  t0.type AS type_4,
  t0.comment AS comment_5
FROM
  `configuration` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = 'isAclDisplaySynced' LIMIT 1;

SELECT
  DISTINCT jel.accountnumber AS value,
  CONCAT(
    jel.accountnumber, ' – ', jel.label
  ) AS label
FROM
  journal_entry_line jel
  JOIN journal_entry je ON je.id = jel.journal_entry_id
WHERE
  je.exercice_id = ?
  AND jel.delete_by_id IS NULL
ORDER BY
  jel.accountnumber

SELECT DISTINCT
                    jel.accountnumber AS value,
                    CONCAT(jel.accountnumber, ' – ', jel.label) AS label
                FROM journal_entry_line jel
                JOIN journal_entry je ON je.id = jel.journal_entry_id
                WHERE je.exercice_id = 3
                AND jel.delete_by_id IS NULL
                ORDER BY jel.accountnumber
            ;

SELECT
  DISTINCT tj.code AS value,
  tj.libelle AS label
FROM
  journal_entry je
  JOIN type_journal tj ON tj.id = je.type_journal_id
WHERE
  je.exercice_id = ?
ORDER BY
  tj.code

SELECT DISTINCT
                    tj.code   AS value,
                    tj.libelle AS label
                FROM journal_entry je
                JOIN type_journal tj
                    ON tj.id = je.type_journal_id
                WHERE je.exercice_id = 3
                ORDER BY tj.code
            ;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1
FROM
  analytic_category a0_
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1 FROM analytic_category a0_ ORDER BY a0_.name ASC;

SELECT
  r0_.id AS id_0,
  r0_.cle AS cle_1,
  r0_.nom AS nom_2,
  r0_.pourcentage AS pourcentage_3,
  r0_.commentaire AS commentaire_4,
  r0_.datecreation AS datecreation_5,
  r0_.linked_to_exercise AS linked_to_exercise_6,
  r0_.exercice_id AS exercice_id_7,
  r0_.user_id AS user_id_8,
  r0_.category_id AS category_id_9
FROM
  repartition_key r0_
WHERE
  (
    r0_.exercice_id = ?
    OR r0_.linked_to_exercise = 0
  )
ORDER BY
  r0_.cle ASC

SELECT r0_.id AS id_0, r0_.cle AS cle_1, r0_.nom AS nom_2, r0_.pourcentage AS pourcentage_3, r0_.commentaire AS commentaire_4, r0_.datecreation AS datecreation_5, r0_.linked_to_exercise AS linked_to_exercise_6, r0_.exercice_id AS exercice_id_7, r0_.user_id AS user_id_8, r0_.category_id AS category_id_9 FROM repartition_key r0_ WHERE (r0_.exercice_id = 3 OR r0_.linked_to_exercise = 0) ORDER BY r0_.cle ASC;

SELECT
  ca.id AS compte_id,
  ca.accountnumber AS compte_numero,
  ca.label AS compte_label,
  je.posted_at AS date_ecriture,
  tj.code AS journal_code,
  je.numero_piece AS numero_piece,
  jel.libelle AS libelle,
  COALESCE(jf.attachment_count, 0) AS attachment_count,
  rks.repartition_cles AS repartition_cles,
  COALESCE(jel.debit, 0) AS debit,
  COALESCE(jel.credit, 0) AS credit
FROM
  journal_entry_line jel
  INNER JOIN journal_entry je ON je.id = jel.journal_entry_id
  INNER JOIN chart_accounts ca ON ca.id = jel.compte_id
  INNER JOIN type_journal tj ON tj.id = je.type_journal_id
  LEFT JOIN (
    SELECT
      jf.entry_id,
      COUNT(jf.id) AS attachment_count
    FROM
      justificatif_file jf
    GROUP BY
      jf.entry_id
  ) jf ON jf.entry_id = je.id
  LEFT JOIN (
    SELECT
      jalaa.line_id,
      GROUP_CONCAT(
        DISTINCT rk.cle
        ORDER BY
          rk.cle SEPARATOR ', '
      ) AS repartition_cles
    FROM
      journal_entry_line_analytic_allocation jalaa
      INNER JOIN repartition_key rk ON rk.id = jalaa.repartition_key_id
    GROUP BY
      jalaa.line_id
  ) rks ON rks.line_id = jel.id
WHERE
  je.exercice_id = ?
  AND jel.delete_by_id IS NULL
  AND je.posted_at >= ?
  AND je.posted_at <= ?
ORDER BY
  ca.accountnumber,
  je.posted_at,
  jel.id

SELECT
                ca.id            AS compte_id,
                ca.accountnumber AS compte_numero,
                ca.label         AS compte_label,

                je.posted_at     AS date_ecriture,
                tj.code          AS journal_code,
                je.numero_piece  AS numero_piece,
                jel.libelle      AS libelle,
                COALESCE(jf.attachment_count, 0) AS attachment_count,
                rks.repartition_cles AS repartition_cles,

                COALESCE(jel.debit, 0)  AS debit,
                COALESCE(jel.credit, 0) AS credit

            FROM journal_entry_line jel
            INNER JOIN journal_entry je ON je.id = jel.journal_entry_id
            INNER JOIN chart_accounts ca ON ca.id = jel.compte_id
            INNER JOIN type_journal tj ON tj.id = je.type_journal_id
            LEFT JOIN (
                SELECT
                    jf.entry_id,
                    COUNT(jf.id) AS attachment_count
                FROM justificatif_file jf
                GROUP BY jf.entry_id
            ) jf ON jf.entry_id = je.id
            LEFT JOIN (
                SELECT
                    jalaa.line_id,
                    GROUP_CONCAT(DISTINCT rk.cle ORDER BY rk.cle SEPARATOR ', ') AS repartition_cles
                FROM journal_entry_line_analytic_allocation jalaa
                INNER JOIN repartition_key rk ON rk.id = jalaa.repartition_key_id
                GROUP BY jalaa.line_id
            ) rks ON rks.line_id = jel.id

            WHERE je.exercice_id = 3 AND jel.delete_by_id IS NULL AND je.posted_at >= '2025-09-01' AND je.posted_at <= '2026-08-31'

            ORDER BY
                ca.accountnumber,
                je.posted_at,
                jel.id
        ;

SELECT
  SUM(
    COALESCE(jel.debit, 0)
  ) AS debit,
  SUM(
    COALESCE(jel.credit, 0)
  ) AS credit
FROM
  journal_entry_line jel
  INNER JOIN journal_entry je ON je.id = jel.journal_entry_id
  INNER JOIN chart_accounts ca ON ca.id = jel.compte_id
  INNER JOIN type_journal tj ON tj.id = je.type_journal_id
WHERE
  je.exercice_id = ?
  AND jel.delete_by_id IS NULL
  AND je.posted_at >= ?
  AND je.posted_at <= ?

SELECT
                SUM(COALESCE(jel.debit,0))  AS debit,
                SUM(COALESCE(jel.credit,0)) AS credit
            FROM journal_entry_line jel
            INNER JOIN journal_entry je ON je.id = jel.journal_entry_id
            INNER JOIN chart_accounts ca ON ca.id = jel.compte_id
            INNER JOIN type_journal tj ON tj.id = je.type_journal_id
            WHERE je.exercice_id = 3 AND jel.delete_by_id IS NULL AND je.posted_at >= '2025-09-01' AND je.posted_at <= '2026-08-31'
        ;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.tel AS tel_4,
  t0.mail AS mail_5,
  t0.logo AS logo_6,
  t0.siren AS siren_7,
  t0.siret AS siret_8,
  t0.ape AS ape_9,
  t0.tva AS tva_10,
  t0.dateendexercice AS dateendexercice_11
FROM
  structure t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.tel AS tel_4, t0.mail AS mail_5, t0.logo AS logo_6, t0.siren AS siren_7, t0.siret AS siret_8, t0.ape AS ape_9, t0.tva AS tva_10, t0.dateendexercice AS dateendexercice_11 FROM structure t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.slug AS slug_4,
  t0.label AS label_5,
  t0.position AS position_6,
  t0.target AS target_7,
  t0.lockable AS lockable_8,
  t0.menu_item AS menu_item_9,
  t0.roles_acl AS roles_acl_10,
  t0.roles_menu AS roles_menu_11,
  t0.displayable AS displayable_12,
  t0.positionabsolute AS positionabsolute_13,
  t0.actif AS actif_14,
  t0.allow_writing AS allow_writing_15,
  t0.allow_deleting AS allow_deleting_16,
  t0.allow_validating AS allow_validating_17,
  t0.parent_id AS parent_id_18
FROM
  menu t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.slug AS slug_4, t0.label AS label_5, t0.position AS position_6, t0.target AS target_7, t0.lockable AS lockable_8, t0.menu_item AS menu_item_9, t0.roles_acl AS roles_acl_10, t0.roles_menu AS roles_menu_11, t0.displayable AS displayable_12, t0.positionabsolute AS positionabsolute_13, t0.actif AS actif_14, t0.allow_writing AS allow_writing_15, t0.allow_deleting AS allow_deleting_16, t0.allow_validating AS allow_validating_17, t0.parent_id AS parent_id_18 FROM menu t0 WHERE t0.path = 'app_general_balance_grandlivre' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.year AS year_1,
  a0_.datestart AS datestart_2,
  a0_.dateend AS dateend_3,
  a0_.comment AS comment_4,
  a0_.statut_close AS statut_close_5,
  a0_.statut_lock AS statut_lock_6,
  a0_.locked_at AS locked_at_7,
  a0_.closed_at AS closed_at_8
FROM
  accounting_year a0_
ORDER BY
  a0_.datestart DESC

SELECT a0_.id AS id_0, a0_.year AS year_1, a0_.datestart AS datestart_2, a0_.dateend AS dateend_3, a0_.comment AS comment_4, a0_.statut_close AS statut_close_5, a0_.statut_lock AS statut_lock_6, a0_.locked_at AS locked_at_7, a0_.closed_at AS closed_at_8 FROM accounting_year a0_ ORDER BY a0_.datestart DESC;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.path AS path_2,
  m0_.slug AS slug_3,
  m0_.label AS label_4,
  m0_.position AS position_5,
  m0_.target AS target_6,
  m0_.lockable AS lockable_7,
  m0_.menu_item AS menu_item_8,
  m0_.roles_acl AS roles_acl_9,
  m0_.roles_menu AS roles_menu_10,
  m0_.displayable AS displayable_11,
  m0_.positionabsolute AS positionabsolute_12,
  m0_.actif AS actif_13,
  m0_.allow_writing AS allow_writing_14,
  m0_.allow_deleting AS allow_deleting_15,
  m0_.allow_validating AS allow_validating_16,
  m0_.parent_id AS parent_id_17
FROM
  menu m0_
WHERE
  m0_.parent_id IS NULL
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.path AS path_2, m0_.slug AS slug_3, m0_.label AS label_4, m0_.position AS position_5, m0_.target AS target_6, m0_.lockable AS lockable_7, m0_.menu_item AS menu_item_8, m0_.roles_acl AS roles_acl_9, m0_.roles_menu AS roles_menu_10, m0_.displayable AS displayable_11, m0_.positionabsolute AS positionabsolute_12, m0_.actif AS actif_13, m0_.allow_writing AS allow_writing_14, m0_.allow_deleting AS allow_deleting_15, m0_.allow_validating AS allow_validating_16, m0_.parent_id AS parent_id_17 FROM menu m0_ WHERE m0_.parent_id IS NULL ORDER BY m0_.position ASC;

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2,
  t0.`group` AS group_3,
  t0.type AS type_4,
  t0.comment AS comment_5
FROM
  `configuration` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = 'isAclDisplaySynced' LIMIT 1;

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2,
  t0.`group` AS group_3,
  t0.type AS type_4,
  t0.comment AS comment_5
FROM
  `configuration` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = 'isAclDisplaySynced' LIMIT 1;

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2,
  t0.`group` AS group_3,
  t0.type AS type_4,
  t0.comment AS comment_5
FROM
  `configuration` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = 'isAclDisplaySynced' LIMIT 1;

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2,
  t0.`group` AS group_3,
  t0.type AS type_4,
  t0.comment AS comment_5
FROM
  `configuration` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = 'isAclDisplaySynced' LIMIT 1;

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2,
  t0.`group` AS group_3,
  t0.type AS type_4,
  t0.comment AS comment_5
FROM
  `configuration` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = 'isAclDisplaySynced' LIMIT 1;

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2,
  t0.`group` AS group_3,
  t0.type AS type_4,
  t0.comment AS comment_5
FROM
  `configuration` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.`group` AS group_3, t0.type AS type_4, t0.comment AS comment_5 FROM `configuration` t0 WHERE t0.`key` = 'isAclDisplaySynced' LIMIT 1;