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

Query Metrics

10 Database Queries
9 Different statements
5.60 ms Query time
0 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 0.50 ms
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"
]
2 0.39 ms
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"
]
3 0.34 ms
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
]
4 0.43 ms
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
]
5 0.55 ms
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"
]
6 0.19 ms
"START TRANSACTION"
Parameters:
[]
7 0.54 ms
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
]
8 0.26 ms
INSERT INTO task_execution_stock_action (planned_quantity, task_execution_id, stock_action_id) VALUES (?, ?, ?)
Parameters:
[
  1.0
  266
  8
]
9 0.24 ms
INSERT INTO task_execution_stock_action (planned_quantity, task_execution_id, stock_action_id) VALUES (?, ?, ?)
Parameters:
[
  1.0
  266
  9
]
10 2.17 ms
"COMMIT"
Parameters:
[]

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