Symfony Profiler

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 = 20;

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

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 = 17 AND t0.planned_date = '2026-06-12' LIMIT 1;

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 = ?

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 = 260;

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

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;

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 = 4;

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 = ?

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 = 3;

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 = ?

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 = 1;

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

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 = '2026-06-12 00:00:00' AND t0_.status <> 'cancelled' ORDER BY t0_.sort_order ASC, t0_.id ASC;

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

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;

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

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 = 1 ORDER BY t0.name ASC;

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;