Query Metrics
25
Database Queries
14
Different statements
302.89 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 23.52 ms |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.description AS description_2, r0_.active AS active_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.featured_image AS featured_image_6, r0_.services AS services_7, r0_.slug AS slug_8, h1_.id AS id_9, h1_.name AS name_10, h1_.description AS description_11, h1_.website AS website_12, h1_.stars AS stars_13, h1_.youtube_video_id AS youtube_video_id_14, h1_.phone AS phone_15, h1_.email AS email_16, h1_.active AS active_17, h1_.gmap_url AS gmap_url_18, h1_.zone AS zone_19, h1_.created_at AS created_at_20, h1_.updated_at AS updated_at_21, h1_.address AS address_22, h1_.check_in_time AS check_in_time_23, h1_.check_out_time AS check_out_time_24, h1_.baby_age_max AS baby_age_max_25, h1_.child_age_max AS child_age_max_26, h1_.teen_age_max AS teen_age_max_27, h1_.featured_image AS featured_image_28, h1_.highlighted AS highlighted_29, h1_.services AS services_30, h1_.hl_start_at AS hl_start_at_31, h1_.hl_end_at AS hl_end_at_32, h1_.slug AS slug_33, g2_.id AS id_34, g2_.title AS title_35, r0_.hotel_id AS hotel_id_36, g2_.hotel_id AS hotel_id_37, g2_.room_id AS room_id_38 FROM rooms r0_ LEFT JOIN hotels h1_ ON r0_.hotel_id = h1_.id LEFT JOIN galleries g2_ ON r0_.id = g2_.room_id LEFT JOIN room_capacities r3_ ON r0_.id = r3_.room_id WHERE r0_.active = 1 AND h1_.active = 1 AND r0_.slug = ? AND h1_.slug = ?
Parameters:
[ "suite-famille" "lux-grand-gaube" ]
|
||||||||||||||||||||||||||||||||||
2 | 11.69 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.hotel_id AS hotel_id_3, t0.room_id AS room_id_4 FROM galleries t0 WHERE t0.hotel_id = ?
Parameters:
[
24
]
|
||||||||||||||||||||||||||||||||||
3 | 11.92 ms |
SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, r1_.id AS id_3, r1_.name AS name_4, r1_.description AS description_5, r1_.active AS active_6, r1_.created_at AS created_at_7, r1_.updated_at AS updated_at_8, r1_.featured_image AS featured_image_9, r1_.services AS services_10, r1_.slug AS slug_11, s0_.room_id AS room_id_12, r1_.hotel_id AS hotel_id_13 FROM stop_sales s0_ LEFT JOIN rooms r1_ ON s0_.room_id = r1_.id WHERE (s0_.start_at <= ? AND s0_.end_at >= ?) ORDER BY s0_.id ASC
Parameters:
[ "2024-12-27 23:59:00" "2024-12-23 00:00:00" ]
|
||||||||||||||||||||||||||||||||||
4 | 13.30 ms |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 24 AND r1_.id IN (152) AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500
Parameters:
[ "2024-12-27 23:59:00" "2024-12-23 00:00:00" ]
|
||||||||||||||||||||||||||||||||||
5 | 11.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.featured_image AS featured_image_7, t0.services AS services_8, t0.slug AS slug_9, t0.hotel_id AS hotel_id_10, t11.id AS id_12, t11.title AS title_13, t11.hotel_id AS hotel_id_14, t11.room_id AS room_id_15 FROM rooms t0 LEFT JOIN galleries t11 ON t11.room_id = t0.id WHERE t0.hotel_id = ?
Parameters:
[
24
]
|
||||||||||||||||||||||||||||||||||
6 | 11.61 ms |
SELECT t0.id AS id_1, t0.adults AS adults_2, t0.teens AS teens_3, t0.children AS children_4, t0.babies AS babies_5, t0.is_default_config AS is_default_config_6, t0.room_id AS room_id_7 FROM room_capacities t0 WHERE t0.room_id = ?
Parameters:
[
147
]
|
||||||||||||||||||||||||||||||||||
7 | 11.56 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.quantity AS quantity_3, t0.stay_started_at AS stay_started_at_4, t0.stay_ended_at AS stay_ended_at_5, t0.sale_started_at AS sale_started_at_6, t0.sale_ended_at AS sale_ended_at_7, t0.min_nights AS min_nights_8, t0.double_occupancy AS double_occupancy_9, t0.single_occupancy AS single_occupancy_10, t0.triple_occupancy AS triple_occupancy_11, t0.active AS active_12, t0.extra_baby AS extra_baby_13, t0.extra_child AS extra_child_14, t0.extra_teen AS extra_teen_15, t0.default_extra_label AS default_extra_label_16, t0.room_id AS room_id_17 FROM room_prices t0 WHERE t0.room_id = ?
Parameters:
[
147
]
|
||||||||||||||||||||||||||||||||||
8 | 11.41 ms |
SELECT t0.id AS id_1, t0.adults AS adults_2, t0.teens AS teens_3, t0.children AS children_4, t0.babies AS babies_5, t0.is_default_config AS is_default_config_6, t0.room_id AS room_id_7 FROM room_capacities t0 WHERE t0.room_id = ?
Parameters:
[
148
]
|
||||||||||||||||||||||||||||||||||
9 | 11.63 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.quantity AS quantity_3, t0.stay_started_at AS stay_started_at_4, t0.stay_ended_at AS stay_ended_at_5, t0.sale_started_at AS sale_started_at_6, t0.sale_ended_at AS sale_ended_at_7, t0.min_nights AS min_nights_8, t0.double_occupancy AS double_occupancy_9, t0.single_occupancy AS single_occupancy_10, t0.triple_occupancy AS triple_occupancy_11, t0.active AS active_12, t0.extra_baby AS extra_baby_13, t0.extra_child AS extra_child_14, t0.extra_teen AS extra_teen_15, t0.default_extra_label AS default_extra_label_16, t0.room_id AS room_id_17 FROM room_prices t0 WHERE t0.room_id = ?
Parameters:
[
148
]
|
||||||||||||||||||||||||||||||||||
10 | 11.34 ms |
SELECT t0.id AS id_1, t0.adults AS adults_2, t0.teens AS teens_3, t0.children AS children_4, t0.babies AS babies_5, t0.is_default_config AS is_default_config_6, t0.room_id AS room_id_7 FROM room_capacities t0 WHERE t0.room_id = ?
Parameters:
[
149
]
|
||||||||||||||||||||||||||||||||||
11 | 11.35 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.quantity AS quantity_3, t0.stay_started_at AS stay_started_at_4, t0.stay_ended_at AS stay_ended_at_5, t0.sale_started_at AS sale_started_at_6, t0.sale_ended_at AS sale_ended_at_7, t0.min_nights AS min_nights_8, t0.double_occupancy AS double_occupancy_9, t0.single_occupancy AS single_occupancy_10, t0.triple_occupancy AS triple_occupancy_11, t0.active AS active_12, t0.extra_baby AS extra_baby_13, t0.extra_child AS extra_child_14, t0.extra_teen AS extra_teen_15, t0.default_extra_label AS default_extra_label_16, t0.room_id AS room_id_17 FROM room_prices t0 WHERE t0.room_id = ?
Parameters:
[
149
]
|
||||||||||||||||||||||||||||||||||
12 | 11.32 ms |
SELECT t0.id AS id_1, t0.adults AS adults_2, t0.teens AS teens_3, t0.children AS children_4, t0.babies AS babies_5, t0.is_default_config AS is_default_config_6, t0.room_id AS room_id_7 FROM room_capacities t0 WHERE t0.room_id = ?
Parameters:
[
150
]
|
||||||||||||||||||||||||||||||||||
13 | 11.44 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.quantity AS quantity_3, t0.stay_started_at AS stay_started_at_4, t0.stay_ended_at AS stay_ended_at_5, t0.sale_started_at AS sale_started_at_6, t0.sale_ended_at AS sale_ended_at_7, t0.min_nights AS min_nights_8, t0.double_occupancy AS double_occupancy_9, t0.single_occupancy AS single_occupancy_10, t0.triple_occupancy AS triple_occupancy_11, t0.active AS active_12, t0.extra_baby AS extra_baby_13, t0.extra_child AS extra_child_14, t0.extra_teen AS extra_teen_15, t0.default_extra_label AS default_extra_label_16, t0.room_id AS room_id_17 FROM room_prices t0 WHERE t0.room_id = ?
Parameters:
[
150
]
|
||||||||||||||||||||||||||||||||||
14 | 11.32 ms |
SELECT t0.id AS id_1, t0.adults AS adults_2, t0.teens AS teens_3, t0.children AS children_4, t0.babies AS babies_5, t0.is_default_config AS is_default_config_6, t0.room_id AS room_id_7 FROM room_capacities t0 WHERE t0.room_id = ?
Parameters:
[
151
]
|
||||||||||||||||||||||||||||||||||
15 | 11.76 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.quantity AS quantity_3, t0.stay_started_at AS stay_started_at_4, t0.stay_ended_at AS stay_ended_at_5, t0.sale_started_at AS sale_started_at_6, t0.sale_ended_at AS sale_ended_at_7, t0.min_nights AS min_nights_8, t0.double_occupancy AS double_occupancy_9, t0.single_occupancy AS single_occupancy_10, t0.triple_occupancy AS triple_occupancy_11, t0.active AS active_12, t0.extra_baby AS extra_baby_13, t0.extra_child AS extra_child_14, t0.extra_teen AS extra_teen_15, t0.default_extra_label AS default_extra_label_16, t0.room_id AS room_id_17 FROM room_prices t0 WHERE t0.room_id = ?
Parameters:
[
151
]
|
||||||||||||||||||||||||||||||||||
16 | 11.53 ms |
SELECT t0.id AS id_1, t0.adults AS adults_2, t0.teens AS teens_3, t0.children AS children_4, t0.babies AS babies_5, t0.is_default_config AS is_default_config_6, t0.room_id AS room_id_7 FROM room_capacities t0 WHERE t0.room_id = ?
Parameters:
[
152
]
|
||||||||||||||||||||||||||||||||||
17 | 11.62 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.quantity AS quantity_3, t0.stay_started_at AS stay_started_at_4, t0.stay_ended_at AS stay_ended_at_5, t0.sale_started_at AS sale_started_at_6, t0.sale_ended_at AS sale_ended_at_7, t0.min_nights AS min_nights_8, t0.double_occupancy AS double_occupancy_9, t0.single_occupancy AS single_occupancy_10, t0.triple_occupancy AS triple_occupancy_11, t0.active AS active_12, t0.extra_baby AS extra_baby_13, t0.extra_child AS extra_child_14, t0.extra_teen AS extra_teen_15, t0.default_extra_label AS default_extra_label_16, t0.room_id AS room_id_17 FROM room_prices t0 WHERE t0.room_id = ?
Parameters:
[
152
]
|
||||||||||||||||||||||||||||||||||
18 | 11.65 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 WHERE t0.hotel_id = ?
Parameters:
[
24
]
|
||||||||||||||||||||||||||||||||||
19 | 11.79 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.description AS description_4, t0.stay_start_at AS stay_start_at_5, t0.stay_end_at AS stay_end_at_6, t0.booking_start_at AS booking_start_at_7, t0.booking_end_at AS booking_end_at_8, t0.reference AS reference_9, t0.min_nights AS min_nights_10, t0.max_nights AS max_nights_11, t0.early_booking_days AS early_booking_days_12, t0.apply_to_all_rooms AS apply_to_all_rooms_13, t0.discount AS discount_14, t0.combinable AS combinable_15, t0.combinable_discount AS combinable_discount_16, t0.active AS active_17, t0.extras_discount AS extras_discount_18, t0.priority AS priority_19, t0.discount_kids1 AS discount_kids1_20, t0.discount_kids2 AS discount_kids2_21, t0.discount_kids3 AS discount_kids3_22, t0.hotel_id AS hotel_id_23 FROM offers t0 WHERE t0.hotel_id = ?
Parameters:
[
24
]
|
||||||||||||||||||||||||||||||||||
20 | 11.60 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 INNER JOIN offers_extra_charges ON t0.id = offers_extra_charges.extra_charges_id WHERE offers_extra_charges.offers_id = ?
Parameters:
[
157
]
|
||||||||||||||||||||||||||||||||||
21 | 11.59 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 INNER JOIN offers_extras_discounted ON t0.id = offers_extras_discounted.extra_charges_id WHERE offers_extras_discounted.offers_id = ?
Parameters:
[
157
]
|
||||||||||||||||||||||||||||||||||
22 | 11.73 ms |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.adult_extra AS adult_extra_3, e0_.baby_extra AS baby_extra_4, e0_.child_extra AS child_extra_5, e0_.teen_extra AS teen_extra_6, e0_.stay_started_at AS stay_started_at_7, e0_.stay_ended_at AS stay_ended_at_8, e0_.is_active AS is_active_9, e0_.is_mandatory AS is_mandatory_10, e0_.min_nights AS min_nights_11, e0_.hotel_id AS hotel_id_12 FROM extra_charges e0_ LEFT JOIN hotels h1_ ON e0_.hotel_id = h1_.id WHERE h1_.id = ? AND e0_.is_active = 1 AND e0_.stay_started_at IS NULL ORDER BY e0_.adult_extra ASC
Parameters:
[
24
]
|
||||||||||||||||||||||||||||||||||
23 | 11.54 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image_name AS image_name_3, t0.size AS size_4, t0.type AS type_5, t0.dimensions AS dimensions_6, t0.updated_at AS updated_at_7, t0.gallery_id AS gallery_id_8 FROM images t0 WHERE t0.gallery_id = ?
Parameters:
[
27
]
|
||||||||||||||||||||||||||||||||||
24 | 11.46 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image_name AS image_name_3, t0.size AS size_4, t0.type AS type_5, t0.dimensions AS dimensions_6, t0.updated_at AS updated_at_7, t0.gallery_id AS gallery_id_8 FROM images t0 WHERE t0.gallery_id = ?
Parameters:
[
32
]
|
||||||||||||||||||||||||||||||||||
25 | 11.34 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.btn_label AS btn_label_3, s0_.btn_link AS btn_link_4, s0_.bg_image AS bg_image_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.active AS active_8, s0_.hook AS hook_9 FROM slides s0_ WHERE s0_.active = 1 AND s0_.hook IS NULL ORDER BY s0_.id ASC LIMIT 10
Parameters:
[] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Rooms | No errors. |
App\Entity\Hotels | No errors. |
App\Entity\Galleries | No errors. |
App\Entity\RoomCapacities | No errors. |
App\Entity\RoomPrices | No errors. |
App\Entity\StopSales | No errors. |
App\Entity\ExtraCharges | No errors. |
App\Entity\Images | No errors. |
App\Entity\Offers | No errors. |
App\Entity\Slides | No errors. |
App\Entity\Insurances | No errors. |
App\Entity\Posts | No errors. |
App\Entity\Orders | No errors. |
App\Entity\Transfers | No errors. |
App\Entity\Categories | No errors. |
App\Entity\Users | No errors. |
App\Entity\Faq | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |