Symfony Profiler

[
  "route" => "app_shopping"
  "route_parameters" => [
    "_route" => "app_shopping"
    "_controller" => "App\Controller\ShoppingController::index"
  ]
  "request_uri" => "https://mealplan.heatherevens.me.uk/shopping?shop=lidl&week=2026-11-08"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "psimseu_mealplanhelper"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "psimseu_mealplanhelper"
    "serverVersion" => "10.4.27-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "me@heatherevens.me.uk"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-09"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-11"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-12"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-13"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-14"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 28
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 83
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 29
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 84
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 30
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 31
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 32
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 33
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 34
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 35
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 36
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 37
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 85
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 86
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 38
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 867
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 102
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 103
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 104
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 106
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 868
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 45
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 47
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 48
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => "2026-11-08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => "2026-11-08"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1625
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => "2026-11-08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => "2026-11-08"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1625
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => "2026-11-08"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1625
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 51
    2 => 18
    3 => 28
    4 => 32
    5 => 19
    6 => 55
    7 => 24
    8 => 52
    9 => 38
    10 => 27
    11 => 48
    12 => 37
    13 => 26
    14 => 53
    15 => 47
    16 => 29
    17 => 30
    18 => 105
    19 => 46
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#824
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#824}
    3 => Doctrine\DBAL\ParameterType {#824}
    4 => Doctrine\DBAL\ParameterType {#824}
    5 => Doctrine\DBAL\ParameterType {#824}
    6 => Doctrine\DBAL\ParameterType {#824}
    7 => Doctrine\DBAL\ParameterType {#824}
    8 => Doctrine\DBAL\ParameterType {#824}
    9 => Doctrine\DBAL\ParameterType {#824}
    10 => Doctrine\DBAL\ParameterType {#824}
    11 => Doctrine\DBAL\ParameterType {#824}
    12 => Doctrine\DBAL\ParameterType {#824}
    13 => Doctrine\DBAL\ParameterType {#824}
    14 => Doctrine\DBAL\ParameterType {#824}
    15 => Doctrine\DBAL\ParameterType {#824}
    16 => Doctrine\DBAL\ParameterType {#824}
    17 => Doctrine\DBAL\ParameterType {#824}
    18 => Doctrine\DBAL\ParameterType {#824}
    19 => Doctrine\DBAL\ParameterType {#824}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-11-08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#938
      +name: "STRING"
    }
  ]
]

[
  "key" => "_security_main"
]