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

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_analytic_gestion_repartition_pdf' 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
  rk.id AS repartition_id,
  rk.cle AS repartition_cle,
  rk.nom AS repartition_nom,
  ac.id AS category_id,
  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,
  rks.repartition_cles AS repartition_cles,
  COALESCE(jel.debit, 0) * COALESCE(jalaa.percentage, 1) AS debit,
  COALESCE(jel.credit, 0) * COALESCE(jalaa.percentage) AS credit,
  COALESCE(jalaa.percentage) AS pourcentage
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 journal_entry_line_analytic_allocation jalaa ON jalaa.line_id = jel.id
  INNER JOIN repartition_key rk ON rk.id = jalaa.repartition_key_id
  INNER JOIN type_journal tj ON tj.id = je.type_journal_id
  LEFT JOIN analytic_category ac ON ac.id = rk.category_id
  LEFT JOIN (
    SELECT
      jalaa2.line_id,
      GROUP_CONCAT(
        DISTINCT rk2.cle
        ORDER BY
          rk2.cle SEPARATOR ', '
      ) AS repartition_cles
    FROM
      journal_entry_line_analytic_allocation jalaa2
      INNER JOIN repartition_key rk2 ON rk2.id = jalaa2.repartition_key_id
    GROUP BY
      jalaa2.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 <= ?
  AND ac.id = ?
  AND rk.id = ?
ORDER BY
  rk.cle,
  ca.accountnumber,
  je.posted_at,
  jel.id

SELECT
                rk.id                     AS repartition_id,
                rk.cle                    AS repartition_cle,
                rk.nom                    AS repartition_nom,

                ac.id                     AS category_id,

                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,
                rks.repartition_cles      AS repartition_cles,

                COALESCE(jel.debit, 0)  * COALESCE(jalaa.percentage, 1) AS debit,
                COALESCE(jel.credit, 0) * COALESCE(jalaa.percentage) AS credit,
                COALESCE(jalaa.percentage)                           AS pourcentage

            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 journal_entry_line_analytic_allocation jalaa ON jalaa.line_id = jel.id
            INNER JOIN repartition_key rk ON rk.id = jalaa.repartition_key_id
            INNER JOIN type_journal tj ON tj.id = je.type_journal_id
            LEFT JOIN analytic_category ac ON ac.id = rk.category_id
            LEFT JOIN (
                SELECT
                    jalaa2.line_id,
                    GROUP_CONCAT(DISTINCT rk2.cle ORDER BY rk2.cle SEPARATOR ', ') AS repartition_cles
                FROM journal_entry_line_analytic_allocation jalaa2
                INNER JOIN repartition_key rk2 ON rk2.id = jalaa2.repartition_key_id
                GROUP BY jalaa2.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' AND ac.id = 2 AND rk.id = 9

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

SELECT
  SUM(
    CASE WHEN ac.code = 'AG' THEN
      COALESCE(jel.debit, 0) * COALESCE(jalaa.percentage, 1)
    ELSE
      0
    END
  ) AS debit_ag,
  SUM(
    CASE WHEN ac.code = 'AG' THEN
      COALESCE(jel.credit, 0) * COALESCE(jalaa.percentage, 1)
    ELSE
      0
    END
  ) AS credit_ag,
  SUM(
    CASE WHEN ac.code <> 'AG'
    OR ac.code IS NULL THEN
      COALESCE(jel.debit, 0) * COALESCE(jalaa.percentage, 1)
    ELSE
      0
    END
  ) AS debit_other,
  SUM(
    CASE WHEN ac.code <> 'AG'
    OR ac.code IS NULL THEN
      COALESCE(jel.credit, 0) * COALESCE(jalaa.percentage, 1)
    ELSE
      0
    END
  ) AS credit_other
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 journal_entry_line_analytic_allocation jalaa ON jalaa.line_id = jel.id
  INNER JOIN repartition_key rk ON rk.id = jalaa.repartition_key_id
  LEFT JOIN analytic_category ac ON ac.id = rk.category_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 <= ?
  AND ac.id = ?
  AND rk.id = ?

SELECT
            SUM(
                CASE WHEN ac.code = 'AG'
                THEN COALESCE(jel.debit,0) * COALESCE(jalaa.percentage,1)
                ELSE 0 END
            ) AS debit_ag,

            SUM(
                CASE WHEN ac.code = 'AG'
                THEN COALESCE(jel.credit,0) * COALESCE(jalaa.percentage,1)
                ELSE 0 END
            ) AS credit_ag,

            SUM(
                CASE WHEN ac.code <> 'AG' OR ac.code IS NULL
                THEN COALESCE(jel.debit,0) * COALESCE(jalaa.percentage,1)
                ELSE 0 END
            ) AS debit_other,

            SUM(
                CASE WHEN ac.code <> 'AG' OR ac.code IS NULL
                THEN COALESCE(jel.credit,0) * COALESCE(jalaa.percentage,1)
                ELSE 0 END
            ) AS credit_other

            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 journal_entry_line_analytic_allocation jalaa ON jalaa.line_id = jel.id
            INNER JOIN repartition_key rk ON rk.id = jalaa.repartition_key_id
            LEFT JOIN analytic_category ac ON ac.id = rk.category_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' AND ac.id = 2 AND rk.id = 9
        ;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.address AS address_2,
  s0_.tel AS tel_3,
  s0_.mail AS mail_4,
  s0_.logo AS logo_5,
  s0_.siren AS siren_6,
  s0_.siret AS siret_7,
  s0_.ape AS ape_8,
  s0_.tva AS tva_9,
  s0_.dateendexercice AS dateendexercice_10
FROM
  structure s0_
ORDER BY
  s0_.id ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.address AS address_2, s0_.tel AS tel_3, s0_.mail AS mail_4, s0_.logo AS logo_5, s0_.siren AS siren_6, s0_.siret AS siret_7, s0_.ape AS ape_8, s0_.tva AS tva_9, s0_.dateendexercice AS dateendexercice_10 FROM structure s0_ ORDER BY s0_.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.enabled AS enabled_4,
  t0.position AS position_5
FROM
  analytic_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.enabled AS enabled_4, t0.position AS position_5 FROM analytic_category t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.cle AS cle_2,
  t0.nom AS nom_3,
  t0.pourcentage AS pourcentage_4,
  t0.commentaire AS commentaire_5,
  t0.datecreation AS datecreation_6,
  t0.linked_to_exercise AS linked_to_exercise_7,
  t0.exercice_id AS exercice_id_8,
  t0.user_id AS user_id_9,
  t0.category_id AS category_id_10
FROM
  repartition_key t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cle AS cle_2, t0.nom AS nom_3, t0.pourcentage AS pourcentage_4, t0.commentaire AS commentaire_5, t0.datecreation AS datecreation_6, t0.linked_to_exercise AS linked_to_exercise_7, t0.exercice_id AS exercice_id_8, t0.user_id AS user_id_9, t0.category_id AS category_id_10 FROM repartition_key t0 WHERE t0.id = 9;