Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

6.07 ms Query time

0 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.38 ms
(39.26%)

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

Parameters:

[
  3
  "2025-09-01"
  "2026-08-31"
  2
  9
]

View formatted query View runnable query Explain query View query backtrace

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
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Domain\Analytic\Service\analyticByPostService->getAnalyticByPost (line 127)
3	App\Domain\Analytic\Controller\AnalyticController->exportPdf (line 119)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 4)

0.86 ms
(14.11%)

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 = ?

Parameters:

[
  3
  "2025-09-01"
  "2026-08-31"
  2
  9
]

View formatted query View runnable query Explain query View query backtrace

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
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	App\Domain\Analytic\Service\analyticByPostService->computeBottomTotalsAgOther (line 180)
3	App\Domain\Analytic\Service\analyticByPostService->getAnalyticByPost (line 131)
4	App\Domain\Analytic\Controller\AnalyticController->exportPdf (line 119)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 4)

0.71 ms
(11.64%)

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 = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 4)

0.58 ms
(9.61%)

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

Parameters:

[
  "app_analytic_gestion_repartition_pdf"
  1
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Domain\Menu\Security\ActionPermissionChecker->canAccess (line 41)
5	App\Domain\User\Security\Voter\ACLRouteVoter->voteOnAttribute (line 33)
6	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
7	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
8	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
9	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
10	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
11	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
12	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
13	Symfony\Bundle\SecurityBundle\Security->isGranted (line 65)
14	App\EventSubscriber\AccessSubscriber->onController (line 74)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 4)

0.35 ms
(5.73%)

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

Parameters:

[
  "isAclDisplaySynced"
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\ConfigurationService->getValueByType (line 33)
5	App\Service\MenuService->getEffectiveRoles (line 38)
6	App\Domain\Menu\Security\ActionPermissionChecker->canAccess (line 47)
7	App\Domain\User\Security\Voter\ACLRouteVoter->voteOnAttribute (line 33)
8	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
9	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
10	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 89)
11	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 36)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
13	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
14	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
15	Symfony\Bundle\SecurityBundle\Security->isGranted (line 65)
16	App\EventSubscriber\AccessSubscriber->onController (line 74)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 4)

0.32 ms
(5.27%)

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 = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Service\CurrentAccountingYear->get (line 17)
7	App\EventSubscriber\CurrentYearGuardSubscriber->onKernelRequest (line 18)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 4)

0.32 ms
(5.24%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Domain\Structure\Repository\StructureRepository->findStructure (line 26)
7	App\Domain\Analytic\Controller\AnalyticController->exportPdf (line 137)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 4)

0.28 ms
(4.68%)

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 = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Domain\GrandLivre\Presenter\LedgerFilterPresenter->present (line 43)
7	App\Domain\Analytic\Controller\AnalyticController->exportPdf (line 150)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 4)

0.27 ms
(4.45%)

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 = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Domain\GrandLivre\Presenter\LedgerFilterPresenter->present (line 29)
7	App\Domain\Analytic\Controller\AnalyticController->exportPdf (line 150)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 4)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Domain\Menu\Entity\Menu	2
App\Domain\User\Entity\User	1
App\Domain\AccountingYear\Entity\AccountingYear	1
App\Domain\SiteConfiguration\Entity\SiteConfiguration	1
App\Domain\Structure\Entity\Structure	1
App\Domain\Analytic\Entity\AnalyticCategory	1
App\Domain\RepartitionKey\Entity\RepartitionKey	1

Entities Mapping

Class	Mapping errors
App\Domain\User\Entity\User	No errors.
App\Domain\User\Entity\LoginLog	No errors.
App\Domain\JournalEntry\Entity\JournalEntry	No errors.
App\Domain\JournalEntryLine\Entity\JournalEntryLine	No errors.
App\Domain\AccountingYear\Entity\AccountingYear	No errors.
App\Domain\RepartitionKey\Entity\RepartitionKey	No errors.
App\Domain\Menu\Entity\Menu	No errors.
App\Domain\SiteConfiguration\Entity\SiteConfiguration	No errors.
App\Domain\Structure\Entity\Structure	No errors.
App\Domain\Analytic\Entity\AnalyticCategory	No errors.
App\Domain\TypeJournal\Entity\TypeJournal	No errors.
App\Domain\JustificatifFile\Entity\JustificatifFile	No errors.
App\Domain\ChartAccounts\Entity\ChartAccounts	No errors.
App\Domain\JournalEntryLine\Entity\AnalyticAllocation	No errors.
App\Domain\Lock\Entity\Lock	No errors.
App\Domain\User\Entity\ResetPasswordRequest	No errors.
App\Domain\AntiSpam\Entity\ImageCaptcha	No errors.
App\Domain\AntiSpam\Entity\PuzzleCaptcha	No errors.
App\Domain\PeriodCaptcha\Entity\PeriodCaptcha	No errors.
App\Domain\ContactMessage\Entity\ContactMessage	No errors.
App\Domain\JsLog\Entity\JsLog	No errors.
App\Domain\JournalEntry\Entity\JournalEntryHistory	No errors.
App\Domain\Reconciliation\Entity\AccountRecoItem	No errors.
App\Domain\Reconciliation\Entity\AccountRecoSession	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://compta.eschenlauer.fr/gestion/repartition/pdf/grandlivre?ledger_filter%5BdateFrom%5D=2025-09-01&ledger_filter%5BdateTo%5D=2026-08-31&ledger_filter%5Bacc…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping