Symfony Profiler

Query Metrics

82 Database Queries

14 Different statements

30.07 ms Query time

0 Invalid entities

154 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.35 ms
(44.40%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 50 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Service\ShoppingListCalculator::calculate (line 31)
5	App\Controller\ShoppingController->renderList (line 56)
6	App\Controller\ShoppingController->index (line 51)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 155)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

3.04 ms
(10.12%)

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:

View formatted query View runnable query Explain query View query backtrace

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

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 (51, 18, 28, 32, 19, 55, 24, 52, 38, 27, 48, 37, 26, 53, 47, 29, 30, 105, 46) AND ((t0.deleted_at IS NULL)) ORDER BY t0.name ASC, t0.amount ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	App\Service\IngredientPacks->compatibleOptions (line 25)
4	App\Controller\ShoppingController->renderList (line 85)
5	App\Controller\ShoppingController->index (line 51)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 155)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

2.44 ms
(8.10%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 25 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Service\ShoppingListCalculator::calculate (line 26)
5	App\Controller\ShoppingController->renderList (line 56)
6	App\Controller\ShoppingController->index (line 51)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 155)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

2.42 ms
(8.05%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 25 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
7	App\Service\ShoppingListCalculator->calculate (line 29)
8	App\Controller\ShoppingController->renderList (line 56)
9	App\Controller\ShoppingController->index (line 51)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
12	Symfony\Component\HttpKernel\Kernel->handle (line 155)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

2.30 ms
(7.64%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 21 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
7	App\Service\ShoppingListCalculator->calculate (line 24)
8	App\Controller\ShoppingController->renderList (line 56)
9	App\Controller\ShoppingController->index (line 51)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
12	Symfony\Component\HttpKernel\Kernel->handle (line 155)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

2.15 ms
(7.16%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '2026-11-08' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	App\Service\MealPlanner->day (line 48)
4	App\Service\MealPlanner->week (line 40)
5	App\Controller\ShoppingController->renderList (line 56)
6	App\Controller\ShoppingController->index (line 51)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 155)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.88 ms
(2.91%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '2026-11-08' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	App\Service\PantryPlanning->review (line 23)
4	App\Service\PantryPlanning->confirmed (line 33)
5	App\Controller\ShoppingController->renderList (line 57)
6	App\Controller\ShoppingController->index (line 51)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 155)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.81 ms
(2.69%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '2026-11-08' AND ((t0.deleted_at IS NULL)) ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	App\Service\ShoppingPackPlanner->estimates (line 25)
4	App\Controller\ShoppingController->renderList (line 86)
5	App\Controller\ShoppingController->index (line 51)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 155)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.76 ms
(2.51%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = '2026-11-08' AND t0.pantry_checked = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	App\Service\ShoppingChecklist->pantryItems (line 36)
4	App\Service\PantryPlanning->shoppingItems (line 40)
5	App\Controller\ShoppingController->renderList (line 60)
6	App\Controller\ShoppingController->index (line 51)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 155)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.51 ms
(1.68%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = 49 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 231)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
18	Symfony\Component\HttpKernel\Kernel->handle (line 155)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	require_once (line 5)

0.38 ms
(1.27%)

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
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = '2026-11-08' AND t0.checked = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	App\Service\ShoppingChecklist->checkedItems (line 20)
4	App\Controller\ShoppingController->renderList (line 65)
5	App\Controller\ShoppingController->index (line 51)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 155)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.37 ms
(1.24%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '2026-11-08' AND ((t0.deleted_at IS NULL)) ORDER BY t0.text ASC, t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	App\Service\ShoppingExtras->forWeek (line 18)
4	App\Controller\ShoppingController->renderList (line 67)
5	App\Controller\ShoppingController->index (line 51)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 155)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.34 ms
(1.12%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = '2026-11-08' AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	App\Service\PantryPlanning->stock (line 57)
4	App\Service\PantryPlanning->shoppingItems (line 39)
5	App\Controller\ShoppingController->renderList (line 60)
6	App\Controller\ShoppingController->index (line 51)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 155)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.33 ms
(1.11%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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)
  )

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 = '2026-11-08' AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	App\Service\ShoppingStores->group (line 24)
4	App\Controller\ShoppingController->renderList (line 63)
5	App\Controller\ShoppingController->index (line 51)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 155)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

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

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\MealPlanDay	No errors.
App\Entity\MealPlanItem	No errors.
App\Entity\Recipe	No errors.
App\Entity\RecipeIngredient	No errors.
App\Entity\Ingredient	No errors.
App\Entity\PantryReview	No errors.
App\Entity\PantryItem	No errors.
App\Entity\ShoppingListCheck	No errors.
App\Entity\ShoppingShopOverride	No errors.
App\Entity\ShoppingExtraItem	No errors.
App\Entity\IngredientPack	No errors.
App\Entity\ShoppingPackSelection	No errors.

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping