Symfony Profiler

Query Metrics

23 Database Queries

6 Different statements

18.67 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.97 ms
(53.40%)

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = ? AND (h0_.date_at BETWEEN ? AND ?) AND h0_.initiale = ?

Parameters:

[
  1
  "2026-04-17 00:00:00"
  "2026-04-17 23:59:00"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 1 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 63)
7	App\Repository\HistoriqueCiterneRepository->findHistoStock (line 99)
8	App\Service\HistoricalUpdater->setLastDailyHistoricalsToInitalFor (line 41)
9	App\Service\DailyHistoricalTransactionInCiterneInitialzer->initializeLastHistoricalsTransactionFor (line 24)
10	App\Service\DailyHistoricalTransactionInCiterneInitialzer->initializeDailyTransactionHistory (line 40)
11	App\Command\UpdateHistoricalCiterneCommand->execute (line 326)
12	Symfony\Component\Console\Command\Command->run (line 1096)
13	Symfony\Component\Console\Application->doRunCommand (line 126)
14	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 324)
15	Symfony\Component\Console\Application->doRun (line 80)
16	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 175)
17	Symfony\Component\Console\Application->run (line 59)
18	App\Controller\LoginFormController->login (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

6.98 ms
(37.38%)

SELECT h0_.id AS id_0, h0_.volume_produit AS volume_produit_1, h0_.date_at AS date_at_2, h0_.initiale AS initiale_3, h0_.citerne_id AS citerne_id_4 FROM historique_citerne h0_ LEFT JOIN citerne c1_ ON h0_.citerne_id = c1_.id WHERE h0_.id = (SELECT MAX(h2_.id) AS sclr_5 FROM historique_citerne h2_ WHERE h2_.citerne_id = h0_.citerne_id) GROUP BY c1_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.volume_produit AS volume_produit_1,
  h0_.date_at AS date_at_2,
  h0_.initiale AS initiale_3,
  h0_.citerne_id AS citerne_id_4
FROM
  historique_citerne h0_
  LEFT JOIN citerne c1_ ON h0_.citerne_id = c1_.id
WHERE
  h0_.id = (
    SELECT
      MAX(h2_.id) AS sclr_5
    FROM
      historique_citerne h2_
    WHERE
      h2_.citerne_id = h0_.citerne_id
  )
GROUP BY
  c1_.id

SELECT h0_.id AS id_0, h0_.volume_produit AS volume_produit_1, h0_.date_at AS date_at_2, h0_.initiale AS initiale_3, h0_.citerne_id AS citerne_id_4 FROM historique_citerne h0_ LEFT JOIN citerne c1_ ON h0_.citerne_id = c1_.id WHERE h0_.id = (SELECT MAX(h2_.id) AS sclr_5 FROM historique_citerne h2_ WHERE h2_.citerne_id = h0_.citerne_id) GROUP BY c1_.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 90)
7	App\Repository\HistoriqueCiterneRepository->findLastHistoricalsAt (line 92)
8	App\Service\HistoricalUpdater->setLastDailyHistoricalsToInitalFor (line 41)
9	App\Service\DailyHistoricalTransactionInCiterneInitialzer->initializeLastHistoricalsTransactionFor (line 24)
10	App\Service\DailyHistoricalTransactionInCiterneInitialzer->initializeDailyTransactionHistory (line 40)
11	App\Command\UpdateHistoricalCiterneCommand->execute (line 326)
12	Symfony\Component\Console\Command\Command->run (line 1096)
13	Symfony\Component\Console\Application->doRunCommand (line 126)
14	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 324)
15	Symfony\Component\Console\Application->doRun (line 80)
16	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 175)
17	Symfony\Component\Console\Application->run (line 59)
18	App\Controller\LoginFormController->login (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.59 ms
(3.18%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 60)
5	App\Service\DailyHistoricalTransactionInCiterneInitialzer->finalizeTask (line 28)
6	App\Service\DailyHistoricalTransactionInCiterneInitialzer->initializeDailyTransactionHistory (line 40)
7	App\Command\UpdateHistoricalCiterneCommand->execute (line 326)
8	Symfony\Component\Console\Command\Command->run (line 1096)
9	Symfony\Component\Console\Application->doRunCommand (line 126)
10	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 324)
11	Symfony\Component\Console\Application->doRun (line 80)
12	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 175)
13	Symfony\Component\Console\Application->run (line 59)
14	App\Controller\LoginFormController->login (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.48 ms
(2.56%)

INSERT INTO task_execution (task_name, started_at, finished_at, status, output) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "DailyTransactionHistoryInitializer"
  "2026-04-17 09:43:00"
  "2026-04-17 09:43:00"
  1
  "Transactions du 2026-04-17 marquées comme initiales"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO task_execution (
  task_name, started_at, finished_at,
  status, output
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO task_execution (task_name, started_at, finished_at, status, output) VALUES ('DailyTransactionHistoryInitializer', '2026-04-17 09:43:00', '2026-04-17 09:43:00', 1, 'Transactions du 2026-04-17 marquées comme initiales');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 60)
7	App\Service\DailyHistoricalTransactionInCiterneInitialzer->finalizeTask (line 28)
8	App\Service\DailyHistoricalTransactionInCiterneInitialzer->initializeDailyTransactionHistory (line 40)
9	App\Command\UpdateHistoricalCiterneCommand->execute (line 326)
10	Symfony\Component\Console\Command\Command->run (line 1096)
11	Symfony\Component\Console\Application->doRunCommand (line 126)
12	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 324)
13	Symfony\Component\Console\Application->doRun (line 80)
14	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 175)
15	Symfony\Component\Console\Application->run (line 59)
16	App\Controller\LoginFormController->login (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.47 ms
(2.51%)

INSERT INTO historique_citerne (volume_produit, date_at, initiale, citerne_id) VALUES (?, ?, ?, ?)

Parameters:

[
  0.0
  "2026-04-17 09:43:00"
  1
  21
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO historique_citerne (
  volume_produit, date_at, initiale,
  citerne_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO historique_citerne (volume_produit, date_at, initiale, citerne_id) VALUES (0, '2026-04-17 09:43:00', 1, 21);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 60)
7	App\Service\DailyHistoricalTransactionInCiterneInitialzer->finalizeTask (line 28)
8	App\Service\DailyHistoricalTransactionInCiterneInitialzer->initializeDailyTransactionHistory (line 40)
9	App\Command\UpdateHistoricalCiterneCommand->execute (line 326)
10	Symfony\Component\Console\Command\Command->run (line 1096)
11	Symfony\Component\Console\Application->doRunCommand (line 126)
12	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 324)
13	Symfony\Component\Console\Application->doRun (line 80)
14	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 175)
15	Symfony\Component\Console\Application->run (line 59)
16	App\Controller\LoginFormController->login (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.18 ms
(0.97%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 60)
4	App\Service\DailyHistoricalTransactionInCiterneInitialzer->finalizeTask (line 28)
5	App\Service\DailyHistoricalTransactionInCiterneInitialzer->initializeDailyTransactionHistory (line 40)
6	App\Command\UpdateHistoricalCiterneCommand->execute (line 326)
7	Symfony\Component\Console\Command\Command->run (line 1096)
8	Symfony\Component\Console\Application->doRunCommand (line 126)
9	Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand (line 324)
10	Symfony\Component\Console\Application->doRun (line 80)
11	Symfony\Bundle\FrameworkBundle\Console\Application->doRun (line 175)
12	Symfony\Component\Console\Application->run (line 59)
13	App\Controller\LoginFormController->login (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\HistoriqueCiterne	No errors.
App\Entity\Citerne	The association App\Entity\Citerne#transferts refers to the owning side field App\Entity\Transfert#citerneOrigine which does not exist.
App\Entity\TaskExecution	No errors.

Symfony Profiler

GET https://petrole.sch-km.com/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping