GET https://api-ongi.nathandierickx.com/fr/rooms/cf33fdbf-18ba-4fa5-a677-3cce0482fe10/current-pricing

Query Metrics

3 Database Queries
3 Different statements
3.71 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 1.46 ms
SELECT t0.id AS id_1, t0.size AS size_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.disabled_at AS disabled_at_5, t0.active AS active_6, t0.bed_id AS bed_id_7, t0.tax_rule_id AS tax_rule_id_8 FROM room t0 WHERE t0.id = ?
Parameters:
[
  b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
]
2 1.13 ms
SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.start_at AS start_at_2, s0_.end_at AS end_at_3, s0_.active AS active_4 FROM season s0_ WHERE ? BETWEEN s0_.start_at AND s0_.end_at
Parameters:
[
  "2026-06-25 00:00:00"
]
3 1.13 ms
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.price AS price_2, p0_.special_price AS special_price_3, p0_.active AS active_4, p0_.season_id AS season_id_5 FROM pricing p0_ INNER JOIN pricing_room p2_ ON p0_.id = p2_.pricing_id INNER JOIN room r1_ ON r1_.id = p2_.room_id WHERE r1_.id = ? AND p0_.season_id = ?
Parameters:
[
  b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
  b"¸ÌÇN+1MZ¤ŽÚ³}\x151"
]

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\Room 1
App\Entity\Bed 1
App\Entity\TaxRule 1
App\Entity\Season 1
App\Entity\Pricing 1

Entities Mapping

Class Mapping errors
App\Entity\Room No errors.
App\Entity\Bed No errors.
App\Entity\TaxRule No errors.
App\Entity\Equipment No errors.
App\Entity\RoomGallery No errors.
App\Entity\Availability No errors.
App\Entity\StayDuration No errors.
App\Entity\StayDay No errors.
App\Entity\Booking No errors.
App\Entity\Pricing No errors.
App\Entity\RoomTranslation No errors.
App\Entity\Season No errors.