Symfony Profiler

Query Metrics

103 Database Queries

9 Different statements

38.40 ms Query time

0 Invalid entities

206 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

29.73 ms
(77.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.default_image AS default_image_4, t0.is_vegetarian AS is_vegetarian_5, t0.is_vegan AS is_vegan_6, t0.has_gluten AS has_gluten_7, t0.has_sugar AS has_sugar_8, t0.has_lactose AS has_lactose_9, t0.is_spicy AS is_spicy_10, t0.allergens AS allergens_11, t0.preparation_time AS preparation_time_12, t0.sku AS sku_13, t0.owner_token AS owner_token_14, t0.group_id AS group_id_15 FROM menu_item t0 WHERE t0.id = ?

Parameters:

[
  101
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.default_image AS default_image_4,
  t0.is_vegetarian AS is_vegetarian_5,
  t0.is_vegan AS is_vegan_6,
  t0.has_gluten AS has_gluten_7,
  t0.has_sugar AS has_sugar_8,
  t0.has_lactose AS has_lactose_9,
  t0.is_spicy AS is_spicy_10,
  t0.allergens AS allergens_11,
  t0.preparation_time AS preparation_time_12,
  t0.sku AS sku_13,
  t0.owner_token AS owner_token_14,
  t0.group_id AS group_id_15
FROM
  menu_item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.default_image AS default_image_4, t0.is_vegetarian AS is_vegetarian_5, t0.is_vegan AS is_vegan_6, t0.has_gluten AS has_gluten_7, t0.has_sugar AS has_sugar_8, t0.has_lactose AS has_lactose_9, t0.is_spicy AS is_spicy_10, t0.allergens AS allergens_11, t0.preparation_time AS preparation_time_12, t0.sku AS sku_13, t0.owner_token AS owner_token_14, t0.group_id AS group_id_15 FROM menu_item t0 WHERE t0.id = 101;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\MenuFoodItem::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\MenuFoodItem->__get (line 89)
8	App\Entity\MenuFoodItem->getName (line 133)
9	App\Controller\WidgetController->init (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 15)

2.16 ms
(5.62%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.address AS address_3, r0_.phone AS phone_4, r0_.token_takeway AS token_takeway_5, r0_.token_reservation AS token_reservation_6, r0_.business_hours AS business_hours_7, r0_.off_days AS off_days_8, r0_.default_photo AS default_photo_9, r0_.default_logo AS default_logo_10, r0_.description AS description_11, r0_.access_token AS access_token_12, r0_.owner_token AS owner_token_13, r0_.stripe_secret_key AS stripe_secret_key_14, r0_.stripe_publishable_key AS stripe_publishable_key_15, r0_.group_id AS group_id_16 FROM restaurant r0_ WHERE r0_.access_token = ? OR r0_.token_reservation = ? OR r0_.token_takeway = ?

Parameters:

[
  "a87f50e62513fc05fcd8bc6d8456ab7d"
  "a87f50e62513fc05fcd8bc6d8456ab7d"
  "a87f50e62513fc05fcd8bc6d8456ab7d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.slug AS slug_2,
  r0_.address AS address_3,
  r0_.phone AS phone_4,
  r0_.token_takeway AS token_takeway_5,
  r0_.token_reservation AS token_reservation_6,
  r0_.business_hours AS business_hours_7,
  r0_.off_days AS off_days_8,
  r0_.default_photo AS default_photo_9,
  r0_.default_logo AS default_logo_10,
  r0_.description AS description_11,
  r0_.access_token AS access_token_12,
  r0_.owner_token AS owner_token_13,
  r0_.stripe_secret_key AS stripe_secret_key_14,
  r0_.stripe_publishable_key AS stripe_publishable_key_15,
  r0_.group_id AS group_id_16
FROM
  restaurant r0_
WHERE
  r0_.access_token = ?
  OR r0_.token_reservation = ?
  OR r0_.token_takeway = ?

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.address AS address_3, r0_.phone AS phone_4, r0_.token_takeway AS token_takeway_5, r0_.token_reservation AS token_reservation_6, r0_.business_hours AS business_hours_7, r0_.off_days AS off_days_8, r0_.default_photo AS default_photo_9, r0_.default_logo AS default_logo_10, r0_.description AS description_11, r0_.access_token AS access_token_12, r0_.owner_token AS owner_token_13, r0_.stripe_secret_key AS stripe_secret_key_14, r0_.stripe_publishable_key AS stripe_publishable_key_15, r0_.group_id AS group_id_16 FROM restaurant r0_ WHERE r0_.access_token = 'a87f50e62513fc05fcd8bc6d8456ab7d' OR r0_.token_reservation = 'a87f50e62513fc05fcd8bc6d8456ab7d' OR r0_.token_takeway = 'a87f50e62513fc05fcd8bc6d8456ab7d';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 23)
7	App\Repository\RestaurantRepository->getRestaurantByAccessToken (line 52)
8	App\Controller\WidgetController->init (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 15)

1.65 ms
(4.30%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 66)
5	App\Controller\WidgetController->init (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 15)

1.19 ms
(3.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.schedule AS schedule_7, t0.is_default AS is_default_8, t0.type AS type_9, t0.cover_image AS cover_image_10, t0.owner_token AS owner_token_11, t0.restaurant_id AS restaurant_id_12 FROM menu t0 WHERE t0.restaurant_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.schedule AS schedule_7,
  t0.is_default AS is_default_8,
  t0.type AS type_9,
  t0.cover_image AS cover_image_10,
  t0.owner_token AS owner_token_11,
  t0.restaurant_id AS restaurant_id_12
FROM
  menu t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.schedule AS schedule_7, t0.is_default AS is_default_8, t0.type AS type_9, t0.cover_image AS cover_image_10, t0.owner_token AS owner_token_11, t0.restaurant_id AS restaurant_id_12 FROM menu t0 WHERE t0.restaurant_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 78)
8	App\Controller\WidgetController->init (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 15)

1.03 ms
(2.69%)

SELECT t0.id AS id_1, t0.price AS price_2, t0.categories AS categories_3, t0.days_override AS days_override_4, t0.position AS position_5, t0.is_featured AS is_featured_6, t0.is_available AS is_available_7, t0.special_description AS special_description_8, t0.owner_token AS owner_token_9, t0.menu_id AS menu_id_10, t0.item_id AS item_id_11 FROM menu_item_in_menu t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.categories AS categories_3,
  t0.days_override AS days_override_4,
  t0.position AS position_5,
  t0.is_featured AS is_featured_6,
  t0.is_available AS is_available_7,
  t0.special_description AS special_description_8,
  t0.owner_token AS owner_token_9,
  t0.menu_id AS menu_id_10,
  t0.item_id AS item_id_11
FROM
  menu_item_in_menu t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.price AS price_2, t0.categories AS categories_3, t0.days_override AS days_override_4, t0.position AS position_5, t0.is_featured AS is_featured_6, t0.is_available AS is_available_7, t0.special_description AS special_description_8, t0.owner_token AS owner_token_9, t0.menu_id AS menu_id_10, t0.item_id AS item_id_11 FROM menu_item_in_menu t0 WHERE t0.menu_id = 3 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 79)
8	App\Controller\WidgetController->init (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 15)

0.91 ms
(2.37%)

INSERT INTO widget_tokens (token, created_at, valid_until, restaurant_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "993811e03addaf1d99aad05c89e92179"
  "2025-12-22 16:50:50"
  "2025-12-22 18:50:50"
  3
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO widget_tokens (
  token, created_at, valid_until, restaurant_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO widget_tokens (token, created_at, valid_until, restaurant_id) VALUES ('993811e03addaf1d99aad05c89e92179', '2025-12-22 16:50:50', '2025-12-22 18:50:50', 3);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 66)
7	App\Controller\WidgetController->init (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 15)

0.72 ms
(1.87%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.owner_token AS owner_token_4, t0.group_id AS group_id_5 FROM menu_category t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.owner_token AS owner_token_4,
  t0.group_id AS group_id_5
FROM
  menu_category t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.owner_token AS owner_token_4, t0.group_id AS group_id_5 FROM menu_category t0 WHERE t0.id IN (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 97)
5	App\Controller\WidgetController->init (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 15)

0.69 ms
(1.80%)

SELECT t0.id AS id_1, t0.width AS width_2, t0.height AS height_3, t0.restaurant_id AS restaurant_id_4 FROM seat_map t0 WHERE t0.restaurant_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.width AS width_2,
  t0.height AS height_3,
  t0.restaurant_id AS restaurant_id_4
FROM
  seat_map t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.width AS width_2, t0.height AS height_3, t0.restaurant_id AS restaurant_id_4 FROM seat_map t0 WHERE t0.restaurant_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 738)
11	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 23)
12	App\Repository\RestaurantRepository->getRestaurantByAccessToken (line 52)
13	App\Controller\WidgetController->init (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 15)

0.32 ms
(0.84%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 66)
4	App\Controller\WidgetController->init (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 15)

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\MenuItemInMenu	95
App\Entity\MenuFoodItem	95
App\Entity\MenuCategory	12
App\Entity\Restaurant	1
App\Entity\RestaurantGroup	1
App\Entity\WidgetToken	1
App\Entity\Menu	1

Entities Mapping

Class	Mapping errors
App\Entity\Restaurant	No errors.
App\Entity\RestaurantGroup	No errors.
App\Entity\CategoryTablePlacement	No errors.
App\Entity\SeatMap	No errors.
App\Entity\BusinessRules	No errors.
App\Entity\Menu	No errors.
App\Entity\User	No errors.
App\Entity\Order	No errors.
App\Entity\WidgetToken	No errors.
App\Entity\MenuItemInMenu	No errors.
App\Entity\MenuFoodItem	No errors.
App\Entity\MenuCategory	No errors.

Symfony Profiler

GET https://app.mealiosystem.com/widget?payload=ewogICJ0b2tlbiI6ICJhODdmNTBlNjI1MTNmYzA1ZmNkOGJjNmQ4NDU2YWI3ZCIsCiAgInRoZW1lIjogewogICAgInByaW1hcnkiOiAiI2RiOTQyMyIs…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping