Symfony Profiler

Query Metrics

12 Database Queries

7 Different statements

35.57 ms Query time

5 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.11 ms
(42.48%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.site AS site_3, t0.uid AS uid_4, t0.address AS address_5, t0.city AS city_6, t0.country AS country_7, t0.phone AS phone_8, t0.email AS email_9, t0.logo AS logo_10, t0.tax_rate AS tax_rate_11, t0.iban AS iban_12, t0.tax_identify_number AS tax_identify_number_13, t0.statistic_card AS statistic_card_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.status AS status_17, t0.open_ai_token AS open_ai_token_18, t0.contact_user_id AS contact_user_id_19, t0.subscription_plan_id AS subscription_plan_id_20 FROM hotel t0 WHERE t0.uid = ? LIMIT 1

Parameters:

[
  "3c236664-075b-4f31-877f-b3bff8f4e570"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.site AS site_3,
  t0.uid AS uid_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.country AS country_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.logo AS logo_10,
  t0.tax_rate AS tax_rate_11,
  t0.iban AS iban_12,
  t0.tax_identify_number AS tax_identify_number_13,
  t0.statistic_card AS statistic_card_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.status AS status_17,
  t0.open_ai_token AS open_ai_token_18,
  t0.contact_user_id AS contact_user_id_19,
  t0.subscription_plan_id AS subscription_plan_id_20
FROM
  hotel t0
WHERE
  t0.uid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.site AS site_3, t0.uid AS uid_4, t0.address AS address_5, t0.city AS city_6, t0.country AS country_7, t0.phone AS phone_8, t0.email AS email_9, t0.logo AS logo_10, t0.tax_rate AS tax_rate_11, t0.iban AS iban_12, t0.tax_identify_number AS tax_identify_number_13, t0.statistic_card AS statistic_card_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.status AS status_17, t0.open_ai_token AS open_ai_token_18, t0.contact_user_id AS contact_user_id_19, t0.subscription_plan_id AS subscription_plan_id_20 FROM hotel t0 WHERE t0.uid = '3c236664-075b-4f31-877f-b3bff8f4e570' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Infrastructure\Persistence\Doctrine\HotelRepository->findByUid (line 58)
5	App\UserInterface\Controller\Public\ReservationController->reservation (line 75)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

6.59 ms
(18.52%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7, t0.is_active AS is_active_8, t0.photo AS photo_9, t0.reset_token AS reset_token_10, t0.reset_token_expires_at AS reset_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.status AS status_14, t0.hotel_id AS hotel_id_15 FROM "user" t0 WHERE t0.hotel_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.phone AS phone_7,
  t0.is_active AS is_active_8,
  t0.photo AS photo_9,
  t0.reset_token AS reset_token_10,
  t0.reset_token_expires_at AS reset_token_expires_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.status AS status_14,
  t0.hotel_id AS hotel_id_15
FROM
  "user" t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7, t0.is_active AS is_active_8, t0.photo AS photo_9, t0.reset_token AS reset_token_10, t0.reset_token_expires_at AS reset_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.status AS status_14, t0.hotel_id AS hotel_id_15 FROM "user" t0 WHERE t0.hotel_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 62)
9	App\Application\Service\WebSiteManager::generateHotelData (line 62)
10	App\UserInterface\Controller\Public\ReservationController->reservation (line 99)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

3.28 ms
(9.22%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.description AS description_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.status AS status_7, t0.category AS category_8, t0.matelas AS matelas_9, t0.features AS features_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.hotel_id AS hotel_id_13 FROM room t0 WHERE t0.hotel_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.quantity AS quantity_6,
  t0.status AS status_7,
  t0.category AS category_8,
  t0.matelas AS matelas_9,
  t0.features AS features_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.hotel_id AS hotel_id_13
FROM
  room t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.description AS description_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.status AS status_7, t0.category AS category_8, t0.matelas AS matelas_9, t0.features AS features_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.hotel_id AS hotel_id_13 FROM room t0 WHERE t0.hotel_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Application\Service\WebSiteManager->generateRoomsData (line 84)
8	App\Application\Service\WebSiteManager->generateHotelData (line 44)
9	App\UserInterface\Controller\Public\ReservationController->reservation (line 99)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

2.95 ms
(8.30%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.image AS image_5, t0.is_available AS is_available_6, t0.is_vegetarian AS is_vegetarian_7, t0.is_vegan AS is_vegan_8, t0.is_gluten_free AS is_gluten_free_9, t0.sort_order AS sort_order_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.allergens AS allergens_14, t0.preparation_time AS preparation_time_15, t0.calories AS calories_16, t0.restaurant_id AS restaurant_id_17, t0.category_id AS category_id_18 FROM restaurant_products t0 WHERE t0.category_id = ?

Parameters:

[
  1
]

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.price AS price_4,
  t0.image AS image_5,
  t0.is_available AS is_available_6,
  t0.is_vegetarian AS is_vegetarian_7,
  t0.is_vegan AS is_vegan_8,
  t0.is_gluten_free AS is_gluten_free_9,
  t0.sort_order AS sort_order_10,
  t0.is_active AS is_active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.allergens AS allergens_14,
  t0.preparation_time AS preparation_time_15,
  t0.calories AS calories_16,
  t0.restaurant_id AS restaurant_id_17,
  t0.category_id AS category_id_18
FROM
  restaurant_products t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.image AS image_5, t0.is_available AS is_available_6, t0.is_vegetarian AS is_vegetarian_7, t0.is_vegan AS is_vegan_8, t0.is_gluten_free AS is_gluten_free_9, t0.sort_order AS sort_order_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.allergens AS allergens_14, t0.preparation_time AS preparation_time_15, t0.calories AS calories_16, t0.restaurant_id AS restaurant_id_17, t0.category_id AS category_id_18 FROM restaurant_products t0 WHERE t0.category_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Application\Service\WebSiteManager->generateCategoryProductsData (line 195)
8	App\Application\Service\WebSiteManager->generateRestaurantCategoriesData (line 167)
9	App\Application\Service\WebSiteManager->generateRestaurantsData (line 136)
10	App\Application\Service\WebSiteManager->generateHotelData (line 45)
11	App\UserInterface\Controller\Public\ReservationController->reservation (line 99)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

2.89 ms
(8.13%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.alt AS alt_3, t0.is_primary AS is_primary_4, t0.created_at AS created_at_5, t0.room_id AS room_id_6 FROM room_image t0 WHERE t0.room_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.alt AS alt_3,
  t0.is_primary AS is_primary_4,
  t0.created_at AS created_at_5,
  t0.room_id AS room_id_6
FROM
  room_image t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.alt AS alt_3, t0.is_primary AS is_primary_4, t0.created_at AS created_at_5, t0.room_id AS room_id_6 FROM room_image t0 WHERE t0.room_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Application\Service\WebSiteManager->generateRoomImagesData (line 113)
8	App\Application\Service\WebSiteManager->generateRoomsData (line 85)
9	App\Application\Service\WebSiteManager->generateHotelData (line 44)
10	App\UserInterface\Controller\Public\ReservationController->reservation (line 99)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

2.54 ms
(7.13%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.color AS color_4, t0.icon AS icon_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.restaurant_id AS restaurant_id_11 FROM restaurant_categories t0 WHERE t0.restaurant_id = ?

Parameters:

[
  1
]

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.color AS color_4,
  t0.icon AS icon_5,
  t0.is_active AS is_active_6,
  t0.sort_order AS sort_order_7,
  t0.image AS image_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.restaurant_id AS restaurant_id_11
FROM
  restaurant_categories t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.color AS color_4, t0.icon AS icon_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.restaurant_id AS restaurant_id_11 FROM restaurant_categories t0 WHERE t0.restaurant_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Application\Service\WebSiteManager->generateRestaurantCategoriesData (line 166)
8	App\Application\Service\WebSiteManager->generateRestaurantsData (line 136)
9	App\Application\Service\WebSiteManager->generateHotelData (line 45)
10	App\UserInterface\Controller\Public\ReservationController->reservation (line 99)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

2.21 ms
(6.21%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.phone AS phone_4, t0.email AS email_5, t0.address AS address_6, t0.image AS image_7, t0.opening_time AS opening_time_8, t0.closing_time AS closing_time_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.hotel_id AS hotel_id_13 FROM restaurants t0 WHERE t0.hotel_id = ?

Parameters:

[
  1
]

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.phone AS phone_4,
  t0.email AS email_5,
  t0.address AS address_6,
  t0.image AS image_7,
  t0.opening_time AS opening_time_8,
  t0.closing_time AS closing_time_9,
  t0.is_active AS is_active_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.hotel_id AS hotel_id_13
FROM
  restaurants t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.phone AS phone_4, t0.email AS email_5, t0.address AS address_6, t0.image AS image_7, t0.opening_time AS opening_time_8, t0.closing_time AS closing_time_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.hotel_id AS hotel_id_13 FROM restaurants t0 WHERE t0.hotel_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Application\Service\WebSiteManager->generateRestaurantsData (line 135)
8	App\Application\Service\WebSiteManager->generateHotelData (line 45)
9	App\UserInterface\Controller\Public\ReservationController->reservation (line 99)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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\Domain\Entity\Restaurant\Product	4
App\Domain\Entity\Room	3
App\Domain\Entity\RoomImage	3
App\Domain\Entity\Restaurant\Category	3
App\Domain\Entity\User	2
App\Domain\Entity\Restaurant\Restaurant	2
App\Domain\Entity\Hotel	1
App\Domain\Entity\SubscriptionPlan	1

Entities Mapping

Class	Mapping errors
App\Domain\Entity\Hotel	No errors.
App\Domain\Entity\User	No errors.
App\Domain\Entity\SubscriptionPlan	No errors.
App\Domain\Entity\HotelCurrency	No errors.
App\Domain\Entity\CurrencyConversion	The field 'App\Domain\Entity\CurrencyConversion#rate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\Entity\Room	The field App\Domain\Entity\Room#reservations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Entity\Reservation#room does not contain the required 'inversedBy: "reservations"' attribute.
App\Domain\Entity\TenantService	No errors.
App\Domain\Entity\Permission	No errors.
App\Domain\Entity\Restaurant\Restaurant	No errors.
App\Domain\Entity\HotelModePaiement	No errors.
App\Domain\Entity\RoomImage	No errors.
App\Domain\Entity\RoomBlock	No errors.
App\Domain\Entity\Reservation	The association App\Domain\Entity\Reservation#hotel refers to the inverse side field App\Domain\Entity\Hotel#reservations which does not exist.
App\Domain\Entity\Restaurant\Menu	The field 'App\Domain\Entity\Restaurant\Menu#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\Entity\Restaurant\Category	No errors.
App\Domain\Entity\Restaurant\Product	The field 'App\Domain\Entity\Restaurant\Product#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Domain\Entity\Restaurant\Table	No errors.

Symfony Profiler

GET https://pms.mypreprod.xyz/reservation/3c236664-075b-4f31-877f-b3bff8f4e570

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping