| 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
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;
|
| 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"
]
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;
|
| 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"
]
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 = 4 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 5 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 6 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 18 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 8 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 15 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 16 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 19 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 3 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 12 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 14 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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"
]
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 = 13 AND t0.planned_date = '2026-06-12' LIMIT 1;
|
| 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
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;
|
| 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"
]
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;
|
| 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 = ?
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;
|
| 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 = ?
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;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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;
|
| 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 = ?
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;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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
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;
|
| 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
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;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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;
|
| 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 = ?
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;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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;
|
| 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 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 = ?
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 = 4;
|