POST https://mealplan.heatherevens.me.uk/shopping/2026-11-08/55/tin?shop=lidl

Query Metrics

77 Database Queries
12 Different statements
30.20 ms Query time
0 Invalid entities
118 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.65 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 5.37 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.92 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.55 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.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-11"
]
6 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-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.26 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.42 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.38 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.41 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.34 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.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:
[
  51
]
14 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:
[
  52
]
15 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:
[
  53
]
16 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:
[
  54
]
17 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:
[
  55
]
18 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:
[
  56
]
19 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:
[
  28
]
20 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:
[
  83
]
21 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:
[
  20
]
22 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:
[
  20
]
23 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:
[
  24
]
24 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:
[
  25
]
25 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:
[
  26
]
26 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:
[
  27
]
27 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:
[
  29
]
28 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:
[
  84
]
29 0.28 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.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:
[
  21
]
31 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:
[
  30
]
32 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:
[
  31
]
33 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:
[
  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.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:
[
  35
]
37 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:
[
  36
]
38 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:
[
  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.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:
[
  19
]
41 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:
[
  19
]
42 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:
[
  18
]
43 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:
[
  19
]
44 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:
[
  20
]
45 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:
[
  21
]
46 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:
[
  22
]
47 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:
[
  23
]
48 0.35 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.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:
[
  22
]
50 0.34 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.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:
[
  38
]
52 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:
[
  39
]
53 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:
[
  40
]
54 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:
[
  41
]
55 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:
[
  42
]
56 0.35 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.28 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.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:
[
  54
]
59 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:
[
  102
]
60 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:
[
  103
]
61 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:
[
  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.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:
[
  106
]
64 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:
[
  868
]
65 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:
[
  24
]
66 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:
[
  24
]
67 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:
[
  45
]
68 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:
[
  46
]
69 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:
[
  47
]
70 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:
[
  48
]
71 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:
[
  49
]
72 0.33 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.38 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"
]
74 0.52 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.ingredient_id = ? AND t0.unit = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
  "2026-11-08"
  55
  "tin"
]
75 0.25 ms
"START TRANSACTION"
Parameters:
[]
76 0.44 ms
INSERT INTO shopping_list_check (week, unit, checked, pantry_checked, deleted_at, ingredient_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-11-08"
  "tin"
  1
  0
  null
  55
]
77 0.61 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\RecipeIngredient 52
App\Entity\Ingredient 42
App\Entity\MealPlanDay 7
App\Entity\MealPlanItem 7
App\Entity\Recipe 7
App\Entity\User 1
App\Entity\PantryReview 1
App\Entity\ShoppingListCheck 1

Entities Mapping