GET https://api-ongi.nathandierickx.com/fr/rooms

Query Metrics

28 Database Queries
10 Different statements
28.98 ms Query time
0 Invalid entities
47 Managed entities

Queries

Group similar statements

# Time Info
1 1.34 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.active = ?
Parameters:
[
  1
]
2 1.27 ms
SELECT t0.id AS id_1, t0.active AS active_2 FROM bed t0 WHERE t0.id = ?
Parameters:
[
  b"\x13BÁ"¨\x07L\x03"\eœóËm6"
]
3 1.28 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bed_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"\x13BÁ"¨\x07L\x03"\eœóËm6"
]
4 1.38 ms
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.active AS active_3 FROM equipment t0 INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id WHERE room_equipment.room_id = ?
Parameters:
[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]
5 0.93 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b".\t2|\x07 DC˜iŽ­Z¬¼í"
]
6 0.88 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"NóyÔ\x0E°J¡‰\x7F«"\x02\x18\x1D"
]
7 1.06 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"c\x0F/Iç&HÁ¢ È,gYy§"
]
8 0.84 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"w\x1E\x16»×ÅO\x15´Sæ€\x19Ø.b"
]
9 0.90 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"պѠMcFúŽKÖíi>\eí"
]
10 1.02 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.disabled_at AS disabled_at_6, t0.active AS active_7, t0.room_id AS room_id_8 FROM room_gallery t0 WHERE t0.room_id = ?
Parameters:
[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]
11 1.30 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.type AS type_5, t0.active AS active_6 FROM availability t0 INNER JOIN availability_room ON t0.id = availability_room.availability_id WHERE availability_room.room_id = ?
Parameters:
[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]
12 1.11 ms
SELECT t0.id AS id_1, t0.minimum_nights AS minimum_nights_2, t0.maximum_nights AS maximum_nights_3, t0.active AS active_4 FROM stay_duration t0 INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id WHERE stay_duration_room.room_id = ?
Parameters:
[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]
13 1.01 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.week_day AS week_day_3, t0.active AS active_4 FROM stay_day t0 INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id WHERE stay_day_room.room_id = ?
Parameters:
[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]
14 1.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.view AS view_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM room_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"'f\x7F¿¾‚F;·ëXŠØXW"
]
15 0.77 ms
SELECT t0.id AS id_1, t0.active AS active_2 FROM bed t0 WHERE t0.id = ?
Parameters:
[
  b"ì\f¤zèò@­áõA3q\x1CS"
]
16 0.88 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bed_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"ì\f¤zèò@­áõA3q\x1CS"
]
17 1.16 ms
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.active AS active_3 FROM equipment t0 INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id WHERE room_equipment.room_id = ?
Parameters:
[
  b"m3(N\x1E„M¶µÝÔ玟«\x1D"
]
18 0.86 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.disabled_at AS disabled_at_6, t0.active AS active_7, t0.room_id AS room_id_8 FROM room_gallery t0 WHERE t0.room_id = ?
Parameters:
[
  b"m3(N\x1E„M¶µÝÔ玟«\x1D"
]
19 1.08 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.type AS type_5, t0.active AS active_6 FROM availability t0 INNER JOIN availability_room ON t0.id = availability_room.availability_id WHERE availability_room.room_id = ?
Parameters:
[
  b"m3(N\x1E„M¶µÝÔ玟«\x1D"
]
20 0.90 ms
SELECT t0.id AS id_1, t0.minimum_nights AS minimum_nights_2, t0.maximum_nights AS maximum_nights_3, t0.active AS active_4 FROM stay_duration t0 INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id WHERE stay_duration_room.room_id = ?
Parameters:
[
  b"m3(N\x1E„M¶µÝÔ玟«\x1D"
]
21 0.77 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.week_day AS week_day_3, t0.active AS active_4 FROM stay_day t0 INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id WHERE stay_day_room.room_id = ?
Parameters:
[
  b"m3(N\x1E„M¶µÝÔ玟«\x1D"
]
22 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.view AS view_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM room_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"m3(N\x1E„M¶µÝÔ玟«\x1D"
]
23 0.91 ms
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.active AS active_3 FROM equipment t0 INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id WHERE room_equipment.room_id = ?
Parameters:
[
  b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
]
24 1.10 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.disabled_at AS disabled_at_6, t0.active AS active_7, t0.room_id AS room_id_8 FROM room_gallery t0 WHERE t0.room_id = ?
Parameters:
[
  b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
]
25 1.19 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.type AS type_5, t0.active AS active_6 FROM availability t0 INNER JOIN availability_room ON t0.id = availability_room.availability_id WHERE availability_room.room_id = ?
Parameters:
[
  b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
]
26 0.94 ms
SELECT t0.id AS id_1, t0.minimum_nights AS minimum_nights_2, t0.maximum_nights AS maximum_nights_3, t0.active AS active_4 FROM stay_duration t0 INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id WHERE stay_duration_room.room_id = ?
Parameters:
[
  b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
]
27 0.94 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.week_day AS week_day_3, t0.active AS active_4 FROM stay_day t0 INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id WHERE stay_day_room.room_id = ?
Parameters:
[
  b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
]
28 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.view AS view_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM room_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
]

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\RoomGallery 14
App\Entity\EquipmentTranslation 10
App\Entity\RoomTranslation 6
App\Entity\Equipment 5
App\Entity\BedTranslation 4
App\Entity\Room 3
App\Entity\Bed 2
App\Entity\Availability 2
App\Entity\TaxRule 1

Entities Mapping