Redirect 302 redirect from POST @app_planning_assign (dd4ece)

GET https://www.gamechange.fr/planning/?date=2026-06-12

Query Metrics

101 Database Queries
11 Different statements
34.39 ms Query time
0 Invalid entities
121 Managed entities

Queries

Group similar statements

# Time Info
1 1.54 ms
SELECT r0_.id AS id_0, r0_.frequency AS frequency_1, r0_.weekdays AS weekdays_2, r0_.monthly_weekday AS monthly_weekday_3, r0_.start_date AS start_date_4, r0_.end_date AS end_date_5, r0_.active AS active_6, r0_.planned_quantity AS planned_quantity_7, r0_.quantity_unit AS quantity_unit_8, r0_.planned_recipe_quantity AS planned_recipe_quantity_9, r0_.planned_recipe_unit AS planned_recipe_unit_10, r0_.created_at AS created_at_11, w1_.id AS id_12, w1_.name AS name_13, w1_.login AS login_14, w1_.password_hash AS password_hash_15, w1_.description AS description_16, w1_.active AS active_17, w1_.created_at AS created_at_18, t2_.id AS id_19, t2_.name AS name_20, t2_.description AS description_21, t2_.default_duration_minutes AS default_duration_minutes_22, t2_.has_quantity AS has_quantity_23, t2_.default_quantity AS default_quantity_24, t2_.quantity_unit AS quantity_unit_25, t2_.active AS active_26, t2_.created_at AS created_at_27, r0_.task_template_id AS task_template_id_28, r0_.work_post_id AS work_post_id_29, t2_.recipe_id AS recipe_id_30 FROM recurring_task_plan r0_ LEFT JOIN work_post w1_ ON r0_.work_post_id = w1_.id LEFT JOIN task_template t2_ ON r0_.task_template_id = t2_.id WHERE r0_.active = 1 ORDER BY w1_.name ASC, t2_.name ASC
Parameters:
[]
2 0.78 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  17
  "2026-06-12"
]
3 0.42 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  4
  "2026-06-12"
]
4 0.45 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  5
  "2026-06-12"
]
5 0.43 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  6
  "2026-06-12"
]
6 0.45 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  18
  "2026-06-12"
]
7 0.41 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  8
  "2026-06-12"
]
8 0.40 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  15
  "2026-06-12"
]
9 0.45 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  16
  "2026-06-12"
]
10 0.37 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  19
  "2026-06-12"
]
11 0.36 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  3
  "2026-06-12"
]
12 0.38 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  12
  "2026-06-12"
]
13 0.46 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  14
  "2026-06-12"
]
14 0.37 ms
SELECT t0.id AS id_1, t0.planned_date AS planned_date_2, t0.sort_order AS sort_order_3, t0.status AS status_4, t0.planned_quantity AS planned_quantity_5, t0.quantity_unit AS quantity_unit_6, t0.planned_recipe_quantity AS planned_recipe_quantity_7, t0.planned_recipe_unit AS planned_recipe_unit_8, t0.started_at AS started_at_9, t0.finished_at AS finished_at_10, t0.elapsed_seconds AS elapsed_seconds_11, t0.comment AS comment_12, t0.created_at AS created_at_13, t0.task_template_id AS task_template_id_14, t0.work_post_id AS work_post_id_15, t0.recurring_plan_id AS recurring_plan_id_16 FROM task_execution t0 WHERE t0.recurring_plan_id = ? AND t0.planned_date = ? LIMIT 1
Parameters:
[
  13
  "2026-06-12"
]
15 0.36 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.active = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
16 0.50 ms
SELECT t0_.id AS id_0, t0_.planned_date AS planned_date_1, t0_.sort_order AS sort_order_2, t0_.status AS status_3, t0_.planned_quantity AS planned_quantity_4, t0_.quantity_unit AS quantity_unit_5, t0_.planned_recipe_quantity AS planned_recipe_quantity_6, t0_.planned_recipe_unit AS planned_recipe_unit_7, t0_.started_at AS started_at_8, t0_.finished_at AS finished_at_9, t0_.elapsed_seconds AS elapsed_seconds_10, t0_.comment AS comment_11, t0_.created_at AS created_at_12, t0_.task_template_id AS task_template_id_13, t0_.work_post_id AS work_post_id_14, t0_.recurring_plan_id AS recurring_plan_id_15 FROM task_execution t0_ WHERE t0_.planned_date = ? AND t0_.status <> ? ORDER BY t0_.sort_order ASC, t0_.id ASC
Parameters:
[
  "2026-06-12 00:00:00"
  "cancelled"
]
17 0.38 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  260
]
18 0.34 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:
[
  20
]
19 0.26 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  257
]
20 0.27 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:
[
  34
]
21 0.24 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  253
]
22 0.37 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:
[
  21
]
23 0.29 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  256
]
24 0.28 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:
[
  29
]
25 0.34 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  255
]
26 0.28 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:
[
  28
]
27 0.30 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  254
]
28 0.28 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:
[
  19
]
29 0.31 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  258
]
30 0.25 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:
[
  22
]
31 0.30 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  259
]
32 0.27 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:
[
  4
]
33 0.28 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  261
]
34 0.30 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:
[
  33
]
35 0.34 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  266
]
36 0.28 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
]
37 0.30 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
]
38 0.28 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  263
]
39 0.26 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:
[
  30
]
40 0.29 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  262
]
41 0.31 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:
[
  23
]
42 0.25 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  265
]
43 0.25 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:
[
  2
]
44 0.26 ms
SELECT t0.id AS id_1, t0.planned_quantity AS planned_quantity_2, t0.task_execution_id AS task_execution_id_3, t0.stock_action_id AS stock_action_id_4 FROM task_execution_stock_action t0 WHERE t0.task_execution_id = ?
Parameters:
[
  264
]
45 0.28 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:
[
  31
]
46 0.48 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.default_duration_minutes AS default_duration_minutes_3, t0_.has_quantity AS has_quantity_4, t0_.default_quantity AS default_quantity_5, t0_.quantity_unit AS quantity_unit_6, t0_.active AS active_7, t0_.created_at AS created_at_8, t0_.recipe_id AS recipe_id_9 FROM task_template t0_ WHERE t0_.active = 1 ORDER BY t0_.name ASC
Parameters:
[]
47 0.93 ms
SELECT r0_.id AS id_0, r0_.frequency AS frequency_1, r0_.weekdays AS weekdays_2, r0_.monthly_weekday AS monthly_weekday_3, r0_.start_date AS start_date_4, r0_.end_date AS end_date_5, r0_.active AS active_6, r0_.planned_quantity AS planned_quantity_7, r0_.quantity_unit AS quantity_unit_8, r0_.planned_recipe_quantity AS planned_recipe_quantity_9, r0_.planned_recipe_unit AS planned_recipe_unit_10, r0_.created_at AS created_at_11, w1_.id AS id_12, w1_.name AS name_13, w1_.login AS login_14, w1_.password_hash AS password_hash_15, w1_.description AS description_16, w1_.active AS active_17, w1_.created_at AS created_at_18, t2_.id AS id_19, t2_.name AS name_20, t2_.description AS description_21, t2_.default_duration_minutes AS default_duration_minutes_22, t2_.has_quantity AS has_quantity_23, t2_.default_quantity AS default_quantity_24, t2_.quantity_unit AS quantity_unit_25, t2_.active AS active_26, t2_.created_at AS created_at_27, r0_.task_template_id AS task_template_id_28, r0_.work_post_id AS work_post_id_29, t2_.recipe_id AS recipe_id_30 FROM recurring_task_plan r0_ LEFT JOIN work_post w1_ ON r0_.work_post_id = w1_.id LEFT JOIN task_template t2_ ON r0_.task_template_id = t2_.id WHERE r0_.active = 1 ORDER BY w1_.name ASC, t2_.name ASC
Parameters:
[]
48 0.40 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:
[
  16
]
49 0.33 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:
[
  17
]
50 0.31 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:
[
  18
]
51 0.29 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:
[
  49
]
52 0.30 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:
[
  48
]
53 0.26 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:
[
  35
]
54 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.description AS description_4, t0.active AS active_5, t0.created_at AS created_at_6 FROM stock_item t0 WHERE t0.id = ?
Parameters:
[
  3
]
55 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5 FROM stock_location t0 WHERE t0.id = ?
Parameters:
[
  1
]
56 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5 FROM stock_location t0 WHERE t0.id = ?
Parameters:
[
  2
]
57 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.description AS description_4, t0.active AS active_5, t0.created_at AS created_at_6 FROM stock_item t0 WHERE t0.id = ?
Parameters:
[
  5
]
58 0.33 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:
[
  24
]
59 0.28 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:
[
  26
]
60 0.32 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:
[
  27
]
61 0.37 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:
[
  32
]
62 0.62 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:
[
  53
]
63 0.29 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:
[
  52
]
64 0.30 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:
[
  41
]
65 0.34 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:
[
  42
]
66 0.31 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:
[
  9
]
67 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.description AS description_4, t0.active AS active_5, t0.created_at AS created_at_6 FROM stock_item t0 WHERE t0.id = ?
Parameters:
[
  1
]
68 0.42 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:
[
  38
]
69 0.32 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:
[
  51
]
70 0.30 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:
[
  6
]
71 0.28 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:
[
  4
]
72 0.40 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:
[
  8
]
73 0.28 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:
[
  6
]
74 0.29 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:
[
  7
]
75 0.30 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:
[
  5
]
76 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.description AS description_4, t0.active AS active_5, t0.created_at AS created_at_6 FROM stock_item t0 WHERE t0.id = ?
Parameters:
[
  6
]
77 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5 FROM stock_location t0 WHERE t0.id = ?
Parameters:
[
  3
]
78 0.26 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:
[
  55
]
79 0.49 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:
[
  43
]
80 0.28 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
]
81 0.28 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:
[
  44
]
82 0.26 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:
[
  25
]
83 0.26 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:
[
  40
]
84 0.27 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:
[
  10
]
85 0.24 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:
[
  15
]
86 0.26 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:
[
  14
]
87 0.23 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:
[
  12
]
88 0.35 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:
[
  13
]
89 0.32 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:
[
  11
]
90 0.28 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:
[
  36
]
91 0.24 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:
[
  39
]
92 0.26 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:
[
  37
]
93 0.34 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:
[
  47
]
94 0.27 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:
[
  54
]
95 0.28 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:
[
  7
]
96 0.27 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:
[
  3
]
97 0.25 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:
[
  1
]
98 0.26 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:
[
  45
]
99 0.23 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:
[
  46
]
100 0.36 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:
[
  50
]
101 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.description AS description_4, t0.active AS active_5, t0.created_at AS created_at_6 FROM stock_item t0 WHERE t0.id = ?
Parameters:
[
  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\Entity\TaskTemplate 54
App\Entity\RecurringTaskPlan 14
App\Entity\TaskExecution 14
App\Entity\TaskStockAction 12
App\Entity\TaskExecutionStockAction 9
App\Entity\StockItem 6
App\Entity\Recipe 6
App\Entity\WorkPost 3
App\Entity\StockLocation 3