Redirect 303 redirect from POST @app_shopping_check (7939cf)

GET https://mealplan.heatherevens.me.uk/shopping?shop=lidl&week=2026-11-08

Query Metrics

82 Database Queries
14 Different statements
30.07 ms Query time
0 Invalid entities
154 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.51 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.protected_from_deletion AS protected_from_deletion_3, t0.deleted_at AS deleted_at_4 FROM household_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  49
]
2 0.42 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.deleted_at AS deleted_at_3 FROM meal_plan_day t0 WHERE t0.date = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-08"
]
3 0.31 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.deleted_at AS deleted_at_3 FROM meal_plan_day t0 WHERE t0.date = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-09"
]
4 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.deleted_at AS deleted_at_3 FROM meal_plan_day t0 WHERE t0.date = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-10"
]
5 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.deleted_at AS deleted_at_3 FROM meal_plan_day t0 WHERE t0.date = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-11"
]
6 0.31 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.deleted_at AS deleted_at_3 FROM meal_plan_day t0 WHERE t0.date = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-12"
]
7 0.28 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.deleted_at AS deleted_at_3 FROM meal_plan_day t0 WHERE t0.date = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-13"
]
8 0.27 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.deleted_at AS deleted_at_3 FROM meal_plan_day t0 WHERE t0.date = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-14"
]
9 0.46 ms
SELECT t0.id AS id_1, t0.servings AS servings_2, t0.meal AS meal_3, t0.deleted_at AS deleted_at_4, t0.day_id AS day_id_5, t0.recipe_id AS recipe_id_6 FROM meal_plan_item t0 WHERE t0.day_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  21
]
10 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.servings AS servings_5, t0.deleted_at AS deleted_at_6 FROM recipe t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  25
]
11 0.48 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit AS unit_3, t0.deleted_at AS deleted_at_4, t0.recipe_id AS recipe_id_5, t0.ingredient_id AS ingredient_id_6 FROM recipe_ingredient t0 WHERE t0.recipe_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  25
]
12 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  50
]
13 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  51
]
14 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  52
]
15 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  53
]
16 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  54
]
17 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  55
]
18 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  56
]
19 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  28
]
20 0.34 ms
SELECT t0.id AS id_1, t0.servings AS servings_2, t0.meal AS meal_3, t0.deleted_at AS deleted_at_4, t0.day_id AS day_id_5, t0.recipe_id AS recipe_id_6 FROM meal_plan_item t0 WHERE t0.day_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  83
]
21 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.servings AS servings_5, t0.deleted_at AS deleted_at_6 FROM recipe t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  20
]
22 0.36 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit AS unit_3, t0.deleted_at AS deleted_at_4, t0.recipe_id AS recipe_id_5, t0.ingredient_id AS ingredient_id_6 FROM recipe_ingredient t0 WHERE t0.recipe_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  20
]
23 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  24
]
24 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  25
]
25 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  26
]
26 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  27
]
27 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  29
]
28 0.32 ms
SELECT t0.id AS id_1, t0.servings AS servings_2, t0.meal AS meal_3, t0.deleted_at AS deleted_at_4, t0.day_id AS day_id_5, t0.recipe_id AS recipe_id_6 FROM meal_plan_item t0 WHERE t0.day_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  84
]
29 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.servings AS servings_5, t0.deleted_at AS deleted_at_6 FROM recipe t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  21
]
30 0.32 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit AS unit_3, t0.deleted_at AS deleted_at_4, t0.recipe_id AS recipe_id_5, t0.ingredient_id AS ingredient_id_6 FROM recipe_ingredient t0 WHERE t0.recipe_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  21
]
31 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  30
]
32 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  31
]
33 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  32
]
34 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  33
]
35 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  34
]
36 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  35
]
37 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  36
]
38 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  37
]
39 0.28 ms
SELECT t0.id AS id_1, t0.servings AS servings_2, t0.meal AS meal_3, t0.deleted_at AS deleted_at_4, t0.day_id AS day_id_5, t0.recipe_id AS recipe_id_6 FROM meal_plan_item t0 WHERE t0.day_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  85
]
40 0.60 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.servings AS servings_5, t0.deleted_at AS deleted_at_6 FROM recipe t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  19
]
41 0.32 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit AS unit_3, t0.deleted_at AS deleted_at_4, t0.recipe_id AS recipe_id_5, t0.ingredient_id AS ingredient_id_6 FROM recipe_ingredient t0 WHERE t0.recipe_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  19
]
42 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  18
]
43 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  19
]
44 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  20
]
45 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  21
]
46 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  22
]
47 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  23
]
48 0.30 ms
SELECT t0.id AS id_1, t0.servings AS servings_2, t0.meal AS meal_3, t0.deleted_at AS deleted_at_4, t0.day_id AS day_id_5, t0.recipe_id AS recipe_id_6 FROM meal_plan_item t0 WHERE t0.day_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  86
]
49 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.servings AS servings_5, t0.deleted_at AS deleted_at_6 FROM recipe t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  22
]
50 0.31 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit AS unit_3, t0.deleted_at AS deleted_at_4, t0.recipe_id AS recipe_id_5, t0.ingredient_id AS ingredient_id_6 FROM recipe_ingredient t0 WHERE t0.recipe_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  22
]
51 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  38
]
52 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  39
]
53 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  40
]
54 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  41
]
55 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  42
]
56 0.29 ms
SELECT t0.id AS id_1, t0.servings AS servings_2, t0.meal AS meal_3, t0.deleted_at AS deleted_at_4, t0.day_id AS day_id_5, t0.recipe_id AS recipe_id_6 FROM meal_plan_item t0 WHERE t0.day_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  867
]
57 0.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.servings AS servings_5, t0.deleted_at AS deleted_at_6 FROM recipe t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  54
]
58 0.31 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit AS unit_3, t0.deleted_at AS deleted_at_4, t0.recipe_id AS recipe_id_5, t0.ingredient_id AS ingredient_id_6 FROM recipe_ingredient t0 WHERE t0.recipe_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  54
]
59 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  102
]
60 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  103
]
61 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  104
]
62 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  105
]
63 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  106
]
64 0.31 ms
SELECT t0.id AS id_1, t0.servings AS servings_2, t0.meal AS meal_3, t0.deleted_at AS deleted_at_4, t0.day_id AS day_id_5, t0.recipe_id AS recipe_id_6 FROM meal_plan_item t0 WHERE t0.day_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  868
]
65 0.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.servings AS servings_5, t0.deleted_at AS deleted_at_6 FROM recipe t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  24
]
66 0.33 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit AS unit_3, t0.deleted_at AS deleted_at_4, t0.recipe_id AS recipe_id_5, t0.ingredient_id AS ingredient_id_6 FROM recipe_ingredient t0 WHERE t0.recipe_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  24
]
67 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  45
]
68 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  46
]
69 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  47
]
70 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  48
]
71 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.preferred_shop AS preferred_shop_4, t0.deleted_at AS deleted_at_5 FROM ingredient t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  49
]
72 0.32 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.confirmed_at AS confirmed_at_3, t0.plan_fingerprint AS plan_fingerprint_4, t0.deleted_at AS deleted_at_5 FROM pantry_review t0 WHERE t0.week = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-08"
]
73 0.28 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.confirmed_at AS confirmed_at_3, t0.plan_fingerprint AS plan_fingerprint_4, t0.deleted_at AS deleted_at_5 FROM pantry_review t0 WHERE t0.week = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-08"
]
74 0.27 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.confirmed_at AS confirmed_at_3, t0.plan_fingerprint AS plan_fingerprint_4, t0.deleted_at AS deleted_at_5 FROM pantry_review t0 WHERE t0.week = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-08"
]
75 0.34 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit AS unit_3, t0.location AS location_4, t0.review_week AS review_week_5, t0.measured_amount AS measured_amount_6, t0.measured_unit AS measured_unit_7, t0.deleted_at AS deleted_at_8, t0.ingredient_id AS ingredient_id_9 FROM pantry_item t0 WHERE t0.review_week = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "2026-11-08"
]
76 0.38 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.unit AS unit_3, t0.checked AS checked_4, t0.pantry_checked AS pantry_checked_5, t0.deleted_at AS deleted_at_6, t0.ingredient_id AS ingredient_id_7 FROM shopping_list_check t0 WHERE t0.week = ? AND t0.pantry_checked = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "2026-11-08"
  1
]
77 0.33 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.shop AS shop_3, t0.deleted_at AS deleted_at_4, t0.ingredient_id AS ingredient_id_5 FROM shopping_shop_override t0 WHERE t0.week = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "2026-11-08"
]
78 0.38 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.unit AS unit_3, t0.checked AS checked_4, t0.pantry_checked AS pantry_checked_5, t0.deleted_at AS deleted_at_6, t0.ingredient_id AS ingredient_id_7 FROM shopping_list_check t0 WHERE t0.week = ? AND t0.checked = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "2026-11-08"
  1
]
79 0.38 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.unit AS unit_3, t0.checked AS checked_4, t0.pantry_checked AS pantry_checked_5, t0.deleted_at AS deleted_at_6, t0.ingredient_id AS ingredient_id_7 FROM shopping_list_check t0 WHERE t0.week = ? AND t0.pantry_checked = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "2026-11-08"
  1
]
80 0.37 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.text AS text_3, t0.shop AS shop_4, t0.pantry_checked AS pantry_checked_5, t0.checked AS checked_6, t0.deleted_at AS deleted_at_7 FROM shopping_extra_item t0 WHERE t0.week = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.text ASC, t0.id ASC
Parameters:
[
  "2026-11-08"
]
81 3.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.amount AS amount_3, t0.unit AS unit_4, t0.measured_amount AS measured_amount_5, t0.measured_unit AS measured_unit_6, t0.shop AS shop_7, t0.price AS price_8, t0.deleted_at AS deleted_at_9, t0.ingredient_id AS ingredient_id_10 FROM ingredient_pack t0 WHERE t0.ingredient_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ((t0.deleted_at IS NULL)) ORDER BY t0.name ASC, t0.amount ASC
Parameters:
[
  51
  18
  28
  32
  19
  55
  24
  52
  38
  27
  48
  37
  26
  53
  47
  29
  30
  105
  46
]
82 0.81 ms
SELECT t0.id AS id_1, t0.week AS week_2, t0.unit AS unit_3, t0.count AS count_4, t0.pack_name AS pack_name_5, t0.pack_amount AS pack_amount_6, t0.pack_unit AS pack_unit_7, t0.measured_amount AS measured_amount_8, t0.measured_unit AS measured_unit_9, t0.pack_price AS pack_price_10, t0.pack_shop AS pack_shop_11, t0.deleted_at AS deleted_at_12, t0.ingredient_id AS ingredient_id_13, t0.pack_id AS pack_id_14 FROM shopping_pack_selection t0 WHERE t0.week = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.id ASC
Parameters:
[
  "2026-11-08"
]

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\RecipeIngredient 52
App\Entity\Ingredient 42
App\Entity\ShoppingListCheck 29
App\Entity\MealPlanDay 7
App\Entity\MealPlanItem 7
App\Entity\Recipe 7
App\Entity\IngredientPack 5
App\Entity\ShoppingShopOverride 3
App\Entity\User 1
App\Entity\PantryReview 1