Symfony Profiler

Query Metrics

10 Database Queries

9 Different statements

5.60 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.17 ms
(38.67%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\PlanningController->assign (line 92)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 8)

0.55 ms
(9.76%)

SELECT MAX(t0_.sort_order) AS sclr_0 FROM task_execution t0_ WHERE t0_.work_post_id = ? AND t0_.planned_date = ?

Parameters:

[
  1
  "2026-06-12 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(t0_.sort_order) AS sclr_0
FROM
  task_execution t0_
WHERE
  t0_.work_post_id = ?
  AND t0_.planned_date = ?

SELECT MAX(t0_.sort_order) AS sclr_0 FROM task_execution t0_ WHERE t0_.work_post_id = 1 AND t0_.planned_date = '2026-06-12 00:00:00';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\TaskExecutionRepository->getNextSortOrder (line 134)
8	App\Controller\PlanningController->assign (line 89)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 8)

0.54 ms
(9.60%)

INSERT INTO task_execution (planned_date, sort_order, status, planned_quantity, quantity_unit, planned_recipe_quantity, planned_recipe_unit, started_at, finished_at, elapsed_seconds, comment, created_at, task_template_id, work_post_id, recurring_plan_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-06-12"
  90
  "todo"
  null
  null
  320.0
  "tenders"
  null
  null
  null
  null
  "2026-06-11 13:58:48"
  5
  1
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO task_execution (
  planned_date, sort_order, status,
  planned_quantity, quantity_unit,
  planned_recipe_quantity, planned_recipe_unit,
  started_at, finished_at, elapsed_seconds,
  comment, created_at, task_template_id,
  work_post_id, recurring_plan_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO task_execution (planned_date, sort_order, status, planned_quantity, quantity_unit, planned_recipe_quantity, planned_recipe_unit, started_at, finished_at, elapsed_seconds, comment, created_at, task_template_id, work_post_id, recurring_plan_id) VALUES ('2026-06-12', 90, 'todo', NULL, NULL, 320, 'tenders', NULL, NULL, NULL, NULL, '2026-06-11 13:58:48', 5, 1, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\PlanningController->assign (line 92)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 8)

0.51 ms
(9.05%)

INSERT INTO task_execution_stock_action (planned_quantity, task_execution_id, stock_action_id) VALUES (?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

INSERT INTO task_execution_stock_action (
  planned_quantity, task_execution_id,
  stock_action_id
)
VALUES
  (?, ?, ?)

INSERT INTO task_execution_stock_action (planned_quantity, task_execution_id, stock_action_id) VALUES (1, 266, 8);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\PlanningController->assign (line 92)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 8)

0.50 ms
(8.90%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.default_duration_minutes AS default_duration_minutes_4, t0.has_quantity AS has_quantity_5, t0.default_quantity AS default_quantity_6, t0.quantity_unit AS quantity_unit_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.recipe_id AS recipe_id_10 FROM task_template t0 WHERE t0.id = ?

Parameters:

[
  "5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.default_duration_minutes AS default_duration_minutes_4,
  t0.has_quantity AS has_quantity_5,
  t0.default_quantity AS default_quantity_6,
  t0.quantity_unit AS quantity_unit_7,
  t0.active AS active_8,
  t0.created_at AS created_at_9,
  t0.recipe_id AS recipe_id_10
FROM
  task_template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.default_duration_minutes AS default_duration_minutes_4, t0.has_quantity AS has_quantity_5, t0.default_quantity AS default_quantity_6, t0.quantity_unit AS quantity_unit_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.recipe_id AS recipe_id_10 FROM task_template t0 WHERE t0.id = '5';

#	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\Controller\PlanningController->assign (line 77)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 8)

0.43 ms
(7.62%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.comment AS comment_3, t0.active AS active_4, t0.task_template_id AS task_template_id_5, t0.item_id AS item_id_6, t0.from_location_id AS from_location_id_7, t0.to_location_id AS to_location_id_8 FROM task_stock_action t0 WHERE t0.task_template_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.comment AS comment_3,
  t0.active AS active_4,
  t0.task_template_id AS task_template_id_5,
  t0.item_id AS item_id_6,
  t0.from_location_id AS from_location_id_7,
  t0.to_location_id AS to_location_id_8
FROM
  task_stock_action t0
WHERE
  t0.task_template_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.comment AS comment_3, t0.active AS active_4, t0.task_template_id AS task_template_id_5, t0.item_id AS item_id_6, t0.from_location_id AS from_location_id_7, t0.to_location_id AS to_location_id_8 FROM task_stock_action t0 WHERE t0.task_template_id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Controller\PlanningController->buildExecutionFromRequest (line 496)
8	App\Controller\PlanningController->assign (line 85)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 8)

0.39 ms
(6.89%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.login AS login_3, t0.password_hash AS password_hash_4, t0.description AS description_5, t0.active AS active_6, t0.created_at AS created_at_7 FROM work_post t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.login AS login_3,
  t0.password_hash AS password_hash_4,
  t0.description AS description_5,
  t0.active AS active_6,
  t0.created_at AS created_at_7
FROM
  work_post t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.login AS login_3, t0.password_hash AS password_hash_4, t0.description AS description_5, t0.active AS active_6, t0.created_at AS created_at_7 FROM work_post t0 WHERE t0.id = '1';

#	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\Controller\PlanningController->assign (line 78)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 8)

0.34 ms
(6.12%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.base_quantity AS base_quantity_3, t0.base_unit AS base_unit_4, t0.protocol AS protocol_5, t0.active AS active_6, t0.created_at AS created_at_7 FROM recipe t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.base_quantity AS base_quantity_3,
  t0.base_unit AS base_unit_4,
  t0.protocol AS protocol_5,
  t0.active AS active_6,
  t0.created_at AS created_at_7
FROM
  recipe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.base_quantity AS base_quantity_3, t0.base_unit AS base_unit_4, t0.protocol AS protocol_5, t0.active AS active_6, t0.created_at AS created_at_7 FROM recipe 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\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Recipe::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Recipe->__get (line 184)
7	App\Entity\Recipe->getBaseUnit (line 80)
8	App\Controller\PlanningController->buildExecutionFromRequest (line 485)
9	App\Controller\PlanningController->assign (line 85)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 8)

0.19 ms
(3.39%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\PlanningController->assign (line 92)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 8)

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\Entity\TaskStockAction	2
App\Entity\StockItem	2
App\Entity\TaskExecutionStockAction	2
App\Entity\TaskTemplate	1
App\Entity\Recipe	1
App\Entity\WorkPost	1
App\Entity\StockLocation	1
App\Entity\TaskExecution	1

Entities Mapping

Class	Mapping errors
App\Entity\TaskTemplate	No errors.
App\Entity\Recipe	No errors.
App\Entity\TaskStockAction	No errors.
App\Entity\TaskExecution	No errors.
App\Entity\WorkPost	No errors.
App\Entity\StockMovement	No errors.
App\Entity\RecipeIngredient	No errors.
App\Entity\StockItem	No errors.
App\Entity\StockLocation	No errors.
App\Entity\TaskExecutionStockAction	No errors.
App\Entity\RecurringTaskPlan	No errors.

Symfony Profiler

POST https://www.gamechange.fr/planning/assigner

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping