Query Metrics

38 Database Queries
15 Different statements
15.79 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

# Time Info
1 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.deleted AS deleted_4, t0.api_url AS api_url_5, t0.second_api_url AS second_api_url_6, t0.email AS email_7, t0.phone AS phone_8, t0.whatsapp AS whatsapp_9, t0.tax_type AS tax_type_10, t0.logo_image AS logo_image_11, t0.icon_image AS icon_image_12, t0.output_type AS output_type_13, t0.slug AS slug_14, t0.emails_notification AS emails_notification_15, t0.max_age_child AS max_age_child_16, t0.accommodation_child_text AS accommodation_child_text_17, t0.site AS site_18, t0.time_from AS time_from_19, t0.time_to AS time_to_20, t0.interactions_id AS interactions_id_21, t0.pms_type AS pms_type_22, t0.resort_fee AS resort_fee_23, t0.request_reservation_id AS request_reservation_id_24, t0.reservation_id AS reservation_id_25, t0.external_terminal_id AS external_terminal_id_26, t0.work_time_start AS work_time_start_27, t0.vk AS vk_28, t0.telegram AS telegram_29, t0.address AS address_30, t0.active AS active_31, t0.for_storage AS for_storage_32, t0.company_id AS company_id_33 FROM hotel t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "more.stage.mind4.me"
  0
  1
]
2 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.hotel_id = ?
Parameters:
[
  32
]
3 0.34 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.min_age AS min_age_4, t0.max_age AS max_age_5, t0.hotel_id AS hotel_id_6 FROM type_age t0 WHERE t0.hotel_id = ?
Parameters:
[
  32
]
4 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.hotel_id = ? ORDER BY t0.sort ASC
Parameters:
[
  32
]
5 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.sort AS sort_4, t0.hotel_id AS hotel_id_5, t0.category_id AS category_id_6 FROM hotel_room_type_equipment t0 INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id WHERE hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = ?
Parameters:
[
  12
]
6 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.column_number AS column_number_4, t0.hotel_id AS hotel_id_5 FROM hotel_room_type_equipment_category t0 WHERE t0.id = ?
Parameters:
[
  8
]
7 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.column_number AS column_number_4, t0.hotel_id AS hotel_id_5 FROM hotel_room_type_equipment_category t0 WHERE t0.id = ?
Parameters:
[
  9
]
8 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.column_number AS column_number_4, t0.hotel_id AS hotel_id_5 FROM hotel_room_type_equipment_category t0 WHERE t0.id = ?
Parameters:
[
  10
]
9 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.sort AS sort_4, t0.hotel_id AS hotel_id_5, t0.category_id AS category_id_6 FROM hotel_room_type_equipment t0 INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id WHERE hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = ?
Parameters:
[
  16
]
10 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.sort AS sort_4, t0.hotel_id AS hotel_id_5, t0.category_id AS category_id_6 FROM hotel_room_type_equipment t0 INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id WHERE hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = ?
Parameters:
[
  17
]
11 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.sort AS sort_4, t0.hotel_id AS hotel_id_5, t0.category_id AS category_id_6 FROM hotel_room_type_equipment t0 INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id WHERE hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = ?
Parameters:
[
  18
]
12 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.sort AS sort_4, t0.hotel_id AS hotel_id_5, t0.category_id AS category_id_6 FROM hotel_room_type_equipment t0 INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id WHERE hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = ?
Parameters:
[
  19
]
13 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.sort AS sort_4, t0.hotel_id AS hotel_id_5, t0.category_id AS category_id_6 FROM hotel_room_type_equipment t0 INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id WHERE hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = ?
Parameters:
[
  11
]
14 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.sort AS sort_4, t0.hotel_id AS hotel_id_5, t0.category_id AS category_id_6 FROM hotel_room_type_equipment t0 INNER JOIN hotel_room_type_equipment_hotel_room_type ON t0.id = hotel_room_type_equipment_hotel_room_type.hotel_room_type_equipment_id WHERE hotel_room_type_equipment_hotel_room_type.hotel_room_type_id = ?
Parameters:
[
  69
]
15 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.hotel_id = ? ORDER BY t0.sort ASC
Parameters:
[
  32
]
16 0.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.deleted AS deleted_4, t0.api_url AS api_url_5, t0.second_api_url AS second_api_url_6, t0.email AS email_7, t0.phone AS phone_8, t0.whatsapp AS whatsapp_9, t0.tax_type AS tax_type_10, t0.logo_image AS logo_image_11, t0.icon_image AS icon_image_12, t0.output_type AS output_type_13, t0.slug AS slug_14, t0.emails_notification AS emails_notification_15, t0.max_age_child AS max_age_child_16, t0.accommodation_child_text AS accommodation_child_text_17, t0.site AS site_18, t0.time_from AS time_from_19, t0.time_to AS time_to_20, t0.interactions_id AS interactions_id_21, t0.pms_type AS pms_type_22, t0.resort_fee AS resort_fee_23, t0.request_reservation_id AS request_reservation_id_24, t0.reservation_id AS reservation_id_25, t0.external_terminal_id AS external_terminal_id_26, t0.work_time_start AS work_time_start_27, t0.vk AS vk_28, t0.telegram AS telegram_29, t0.address AS address_30, t0.active AS active_31, t0.for_storage AS for_storage_32, t0.company_id AS company_id_33 FROM hotel t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "more.stage.mind4.me"
]
17 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.deleted AS deleted_4, t0.api_url AS api_url_5, t0.second_api_url AS second_api_url_6, t0.email AS email_7, t0.phone AS phone_8, t0.whatsapp AS whatsapp_9, t0.tax_type AS tax_type_10, t0.logo_image AS logo_image_11, t0.icon_image AS icon_image_12, t0.output_type AS output_type_13, t0.slug AS slug_14, t0.emails_notification AS emails_notification_15, t0.max_age_child AS max_age_child_16, t0.accommodation_child_text AS accommodation_child_text_17, t0.site AS site_18, t0.time_from AS time_from_19, t0.time_to AS time_to_20, t0.interactions_id AS interactions_id_21, t0.pms_type AS pms_type_22, t0.resort_fee AS resort_fee_23, t0.request_reservation_id AS request_reservation_id_24, t0.reservation_id AS reservation_id_25, t0.external_terminal_id AS external_terminal_id_26, t0.work_time_start AS work_time_start_27, t0.vk AS vk_28, t0.telegram AS telegram_29, t0.address AS address_30, t0.active AS active_31, t0.for_storage AS for_storage_32, t0.company_id AS company_id_33 FROM hotel t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "more.stage.mind4.me"
]
18 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.second_code AS second_code_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.active AS active_7, t0.main AS main_8, t0.period_from AS period_from_9, t0.period_to AS period_to_10, t0.vat_type AS vat_type_11, t0.service_description AS service_description_12, t0.promo_code AS promo_code_13, t0.icon_image AS icon_image_14, t0.sort AS sort_15, t0.time_from AS time_from_16, t0.time_to AS time_to_17, t0.hide_main AS hide_main_18, t0.source_profile AS source_profile_19, t0.source AS source_20, t0.structure_guests AS structure_guests_21, t0.free_kids AS free_kids_22, t0.ulid AS ulid_23, t0.for_storage AS for_storage_24, t0.hotel_id AS hotel_id_25, t0.default_payment_id AS default_payment_id_26, t0.rules_pay_back_id AS rules_pay_back_id_27 FROM hotel_rate t0 WHERE t0.hotel_id = ? AND t0.active = ?
Parameters:
[
  32
  1
]
19 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.second_code AS second_code_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.active AS active_7, t0.main AS main_8, t0.period_from AS period_from_9, t0.period_to AS period_to_10, t0.vat_type AS vat_type_11, t0.service_description AS service_description_12, t0.promo_code AS promo_code_13, t0.icon_image AS icon_image_14, t0.sort AS sort_15, t0.time_from AS time_from_16, t0.time_to AS time_to_17, t0.hide_main AS hide_main_18, t0.source_profile AS source_profile_19, t0.source AS source_20, t0.structure_guests AS structure_guests_21, t0.free_kids AS free_kids_22, t0.ulid AS ulid_23, t0.for_storage AS for_storage_24, t0.hotel_id AS hotel_id_25, t0.default_payment_id AS default_payment_id_26, t0.rules_pay_back_id AS rules_pay_back_id_27 FROM hotel_rate t0 WHERE t0.hotel_id = ? AND t0.active = ?
Parameters:
[
  32
  1
]
20 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.hotel_id = ? ORDER BY t0.sort ASC
Parameters:
[
  32
]
21 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.hotel_id = ? ORDER BY t0.sort ASC
Parameters:
[
  32
]
22 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_room_type_id AS hotel_room_type_id_3 FROM hotel_room_type_image t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  69
]
23 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_room_type_id AS hotel_room_type_id_3 FROM hotel_room_type_image t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  16
]
24 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_room_type_id AS hotel_room_type_id_3 FROM hotel_room_type_image t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  17
]
25 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_room_type_id AS hotel_room_type_id_3 FROM hotel_room_type_image t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  19
]
26 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.period_show_from AS period_show_from_3, t0.period_show_to AS period_show_to_4, t0.hotel_id AS hotel_id_5 FROM discount_item t0 INNER JOIN discount_item_hotel_rate ON t0.id = discount_item_hotel_rate.discount_item_id WHERE discount_item_hotel_rate.hotel_rate_id = ?
Parameters:
[
  19
]
27 0.23 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.type AS type_3, t0.value AS value_4, t0.discount_item_id AS discount_item_id_5 FROM discount_day t0 WHERE t0.discount_item_id = ?
Parameters:
[
  28
]
28 0.18 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.stop_sale AS stop_sale_3, t0.min_los AS min_los_4, t0.max_los AS max_los_5, t0.min_adv_booking AS min_adv_booking_6, t0.max_adv_booking AS max_adv_booking_7, t0.ctd AS ctd_8, t0.cta AS cta_9, t0.restriction_item_id AS restriction_item_id_10, t0.hotel_rate_id AS hotel_rate_id_11 FROM restriction_day t0 WHERE t0.hotel_rate_id = ?
Parameters:
[
  19
]
29 0.22 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.count AS count_3, t0.hotel_room_type_id AS hotel_room_type_id_4 FROM category_restriction_day t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  69
]
30 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 INNER JOIN hotel_room_type_hotel_rate ON t0.id = hotel_room_type_hotel_rate.hotel_room_type_id WHERE hotel_room_type_hotel_rate.hotel_rate_id = ?
Parameters:
[
  19
]
31 0.15 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.count AS count_3, t0.hotel_room_type_id AS hotel_room_type_id_4 FROM category_restriction_day t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  16
]
32 0.22 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.count AS count_3, t0.hotel_room_type_id AS hotel_room_type_id_4 FROM category_restriction_day t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  17
]
33 0.37 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.count AS count_3, t0.hotel_room_type_id AS hotel_room_type_id_4 FROM category_restriction_day t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  19
]
34 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_room_type_id AS hotel_room_type_id_3 FROM hotel_room_type_image t0 WHERE t0.hotel_room_type_id = ?
Parameters:
[
  18
]
35 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.code = ? AND t0.hotel_id = ? LIMIT 1
Parameters:
[
  "STD"
  32
]
36 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.code = ? AND t0.hotel_id = ? LIMIT 1
Parameters:
[
  "STD+"
  32
]
37 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.code = ? AND t0.hotel_id = ? LIMIT 1
Parameters:
[
  "SUP"
  32
]
38 2.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.sort AS sort_6, t0.room_capacity AS room_capacity_7, t0.room_area AS room_area_8, t0.motivator AS motivator_9, t0.choosing_bad AS choosing_bad_10, t0.ulid AS ulid_11, t0.max_main_place AS max_main_place_12, t0.for_storage AS for_storage_13, t0.baby_without_place AS baby_without_place_14, t0.tour AS tour_15, t0.video AS video_16, t0.hotel_id AS hotel_id_17, t0.building_id AS building_id_18 FROM hotel_room_type t0 WHERE t0.code = ? AND t0.hotel_id = ? LIMIT 1
Parameters:
[
  "SUIP"
  32
]

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\Booking\Domain\Entity\HotelRate 13
App\Booking\Domain\Entity\Equipment 12
App\Booking\Domain\Entity\HotelRoomType 7
App\Booking\Domain\Entity\TypeAge 3
App\Booking\Domain\Entity\EquipmentCategory 3
App\Booking\Domain\Entity\PaymentMethod 3
App\Booking\Domain\Entity\RulesPayBack 3
App\Booking\Domain\Entity\HotelRoomTypeImage 3
App\Booking\Domain\Entity\Hotel 1
App\Booking\Domain\Entity\Company 1
App\Booking\Domain\Entity\DiscountItem 1