Symfony Profiler

Query Metrics

16 Database Queries

5 Different statements

22.30 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.48 ms
(69.41%)

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?

Parameters:

[
  "2024-10-01 00:00:00"
  "2025-09-30 00:00:00"
  "10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(
    CASE WHEN f0_.statut = 1 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_0,
  SUM(
    CASE WHEN f0_.statut = 2 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_1,
  SUM(
    CASE WHEN f0_.statut = 3 THEN
      f1_.ht
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(f1_.ht) AS sclr_3
FROM
  session_client_order s2_
  LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id
  LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id
  LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id
  LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id
WHERE
  (
    s3_.etat BETWEEN 1
    AND 3
  )
  AND s4_.dernier_jour = 1
  AND (
    s4_.date_start BETWEEN ?
    AND ?
  )
  AND SUBSTRING(
    s4_.date_start
    FROM
      6 FOR 2
  ) = ?

SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = '10';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 768)
7	App\Repository\Sessions\SessionClientOrderRepository->getStatsByMonth (line 118)
8	App\Controller\Rapport\RapportPrevisionnelController->rapportPrevisionnelTest (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

5.85 ms
(26.24%)

SELECT s0_.id AS id_0, s0_.signature AS signature_1, s0_.numero_bon_commande AS numero_bon_commande_2, s0_.filename AS filename_3, s0_.date_signature AS date_signature_4, s0_.signature_filename AS signature_filename_5, s0_.dossier AS dossier_6, s0_.statut AS statut_7, s0_.facture AS facture_8, s0_.statut_non_facture AS statut_non_facture_9, s0_.created_at AS created_at_10, s0_.type_quantite AS type_quantite_11, s0_.formation_pu_ht AS formation_pu_ht_12, s0_.remise_ht AS remise_ht_13, s0_.type_quantite_materiel AS type_quantite_materiel_14, s0_.type_quantite_deplacement AS type_quantite_deplacement_15, s0_.type_quantite_document AS type_quantite_document_16, s0_.materiel_pu_ht AS materiel_pu_ht_17, s0_.deplacement_pu_ht AS deplacement_pu_ht_18, s0_.document_pu_ht AS document_pu_ht_19, s0_.dossier_pu_ht AS dossier_pu_ht_20, count(s1_.id) AS sclr_21, f2_.nombre_jour AS nombre_jour_22, s3_.date_start AS date_start_23, s0_.session_id AS session_id_24, s0_.client_id AS client_id_25 FROM session_client_order s0_ LEFT JOIN sessions s4_ ON s0_.session_id = s4_.id LEFT JOIN session_dates s3_ ON s4_.id = s3_.session_id LEFT JOIN formations f2_ ON s4_.formation_id = f2_.id LEFT JOIN session_stagiaire s1_ ON s0_.id = s1_.session_client_order_id LEFT JOIN facture f5_ ON s0_.id = f5_.session_order_client_id WHERE s0_.statut_non_facture IS NULL AND s3_.dernier_jour = 1 AND (s3_.date_start BETWEEN ? AND ?) AND s1_.statut_id <= 3 AND f5_.id IS NULL GROUP BY s0_.id

Parameters:

[
  "2024-10-01 00:00:00"
  "2025-09-30 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.signature AS signature_1,
  s0_.numero_bon_commande AS numero_bon_commande_2,
  s0_.filename AS filename_3,
  s0_.date_signature AS date_signature_4,
  s0_.signature_filename AS signature_filename_5,
  s0_.dossier AS dossier_6,
  s0_.statut AS statut_7,
  s0_.facture AS facture_8,
  s0_.statut_non_facture AS statut_non_facture_9,
  s0_.created_at AS created_at_10,
  s0_.type_quantite AS type_quantite_11,
  s0_.formation_pu_ht AS formation_pu_ht_12,
  s0_.remise_ht AS remise_ht_13,
  s0_.type_quantite_materiel AS type_quantite_materiel_14,
  s0_.type_quantite_deplacement AS type_quantite_deplacement_15,
  s0_.type_quantite_document AS type_quantite_document_16,
  s0_.materiel_pu_ht AS materiel_pu_ht_17,
  s0_.deplacement_pu_ht AS deplacement_pu_ht_18,
  s0_.document_pu_ht AS document_pu_ht_19,
  s0_.dossier_pu_ht AS dossier_pu_ht_20,
  count(s1_.id) AS sclr_21,
  f2_.nombre_jour AS nombre_jour_22,
  s3_.date_start AS date_start_23,
  s0_.session_id AS session_id_24,
  s0_.client_id AS client_id_25
FROM
  session_client_order s0_
  LEFT JOIN sessions s4_ ON s0_.session_id = s4_.id
  LEFT JOIN session_dates s3_ ON s4_.id = s3_.session_id
  LEFT JOIN formations f2_ ON s4_.formation_id = f2_.id
  LEFT JOIN session_stagiaire s1_ ON s0_.id = s1_.session_client_order_id
  LEFT JOIN facture f5_ ON s0_.id = f5_.session_order_client_id
WHERE
  s0_.statut_non_facture IS NULL
  AND s3_.dernier_jour = 1
  AND (
    s3_.date_start BETWEEN ?
    AND ?
  )
  AND s1_.statut_id <= 3
  AND f5_.id IS NULL
GROUP BY
  s0_.id

SELECT s0_.id AS id_0, s0_.signature AS signature_1, s0_.numero_bon_commande AS numero_bon_commande_2, s0_.filename AS filename_3, s0_.date_signature AS date_signature_4, s0_.signature_filename AS signature_filename_5, s0_.dossier AS dossier_6, s0_.statut AS statut_7, s0_.facture AS facture_8, s0_.statut_non_facture AS statut_non_facture_9, s0_.created_at AS created_at_10, s0_.type_quantite AS type_quantite_11, s0_.formation_pu_ht AS formation_pu_ht_12, s0_.remise_ht AS remise_ht_13, s0_.type_quantite_materiel AS type_quantite_materiel_14, s0_.type_quantite_deplacement AS type_quantite_deplacement_15, s0_.type_quantite_document AS type_quantite_document_16, s0_.materiel_pu_ht AS materiel_pu_ht_17, s0_.deplacement_pu_ht AS deplacement_pu_ht_18, s0_.document_pu_ht AS document_pu_ht_19, s0_.dossier_pu_ht AS dossier_pu_ht_20, count(s1_.id) AS sclr_21, f2_.nombre_jour AS nombre_jour_22, s3_.date_start AS date_start_23, s0_.session_id AS session_id_24, s0_.client_id AS client_id_25 FROM session_client_order s0_ LEFT JOIN sessions s4_ ON s0_.session_id = s4_.id LEFT JOIN session_dates s3_ ON s4_.id = s3_.session_id LEFT JOIN formations f2_ ON s4_.formation_id = f2_.id LEFT JOIN session_stagiaire s1_ ON s0_.id = s1_.session_client_order_id LEFT JOIN facture f5_ ON s0_.id = f5_.session_order_client_id WHERE s0_.statut_non_facture IS NULL AND s3_.dernier_jour = 1 AND (s3_.date_start BETWEEN '2024-10-01 00:00:00' AND '2025-09-30 00:00:00') AND s1_.statut_id <= 3 AND f5_.id IS NULL GROUP BY s0_.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 789)
7	App\Repository\Sessions\SessionClientOrderRepository->findIfFactureNonForDashWithoutMonth (line 65)
8	App\Controller\Rapport\RapportPrevisionnelController->rapportPrevisionnelTest (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.47 ms
(2.09%)

SELECT s0_.session_client_order_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM session_stagiaire s0_ WHERE s0_.session_client_order_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.repas_id IS NOT NULL AND s0_.statut_id <> 4 GROUP BY s0_.session_client_order_id

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.session_client_order_id AS sclr_0,
  COUNT(s0_.id) AS sclr_1
FROM
  session_stagiaire s0_
WHERE
  s0_.session_client_order_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
  AND s0_.repas_id IS NOT NULL
  AND s0_.statut_id <> 4
GROUP BY
  s0_.session_client_order_id

SELECT s0_.session_client_order_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM session_stagiaire s0_ WHERE s0_.session_client_order_id IN (2219, 2220, 2233, 2326, 2339, 2344, 2362, 2363, 2364, 2365, 2366, 2367, 2369, 2373, 2374, 2375, 2376, 2382, 2383, 2384, 2385, 2387, 2388, 2389, 2393, 2394, 2395, 2399, 2400, 2401, 2402, 2403, 2404, 2405, 2406, 2407, 2408, 2409, 2410, 2412, 2413, 2414, 2415, 2416, 2417, 2418, 2419) AND s0_.repas_id IS NOT NULL AND s0_.statut_id <> 4 GROUP BY s0_.session_client_order_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 118)
7	App\Repository\Sessions\SessionStagiaireRepository->countRepasGroupedByOrder (line 79)
8	App\Controller\Rapport\RapportPrevisionnelController->rapportPrevisionnelTest (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.28 ms
(1.28%)

SELECT t0.id AS id_1, t0.token AS token_2 FROM bdd_api t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2
FROM
  bdd_api t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.token AS token_2 FROM bdd_api t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 52)
7	App\Controller\Rapport\RapportPrevisionnelController->rapportPrevisionnelTest (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.22 ms
(0.98%)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.prix AS prix_2, b0_.date_debut AS date_debut_3, b0_.date_fin AS date_fin_4 FROM bdd_ticket_repas b0_ WHERE b0_.date_debut <= ? AND b0_.date_fin >= ?

Parameters:

[
  "2025-09-30 00:00:00"
  "2024-10-01 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.prix AS prix_2,
  b0_.date_debut AS date_debut_3,
  b0_.date_fin AS date_fin_4
FROM
  bdd_ticket_repas b0_
WHERE
  b0_.date_debut <= ?
  AND b0_.date_fin >= ?

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.prix AS prix_2, b0_.date_debut AS date_debut_3, b0_.date_fin AS date_fin_4 FROM bdd_ticket_repas b0_ WHERE b0_.date_debut <= '2025-09-30 00:00:00' AND b0_.date_fin >= '2024-10-01 00:00:00';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 28)
7	App\Repository\Bdd\BddTicketRepasRepository->findAllInRange (line 64)
8	App\Controller\Rapport\RapportPrevisionnelController->rapportPrevisionnelTest (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

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\Bdd\Api\BddApi	No errors.
App\Entity\Bdd\BddTicketRepas	No errors.
App\Entity\Sessions\SessionClientOrder	No errors.
App\Entity\Sessions\Sessions	The field App\Entity\Sessions\Sessions#stagiaires is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sessions\SessionStagiaire#session does not contain the required 'inversedBy="stagiaires"' attribute.
App\Entity\Sessions\SessionDates	No errors.
App\Entity\Formations\Formations	No errors.
App\Entity\Sessions\SessionStagiaire	No errors.
App\Entity\Facturations\Facture	No errors.
App\Entity\Clients\Clients	No errors.
App\Entity\Facturations\FacturePrestation	No errors.

Symfony Profiler

GET https://api-pvg.click-app.fr/old-api/WH5kEDfKFeY226YPl0RdWheevVSvT1Xd9Jf2KJkbsKHH5RL9BKClGF06VhI2x7Te/rapport/previsionnel/2025

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping