GET http://lk.more.stage.mind4.me/hotel/32?edit=true

Query Metrics

9 Database Queries
9 Different statements
5.30 ms Query time
0 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.id AS id_5, t0.passport_id AS passport_id_6, t0.company_id AS company_id_7 FROM users_user t0 WHERE t0.id = ?
Parameters:
[
  6
]
2 0.52 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.id AS id_5, t0.passport_id AS passport_id_6, t0.company_id AS company_id_7 FROM users_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "info@hotel-rate.ru"
]
3 0.69 ms
SELECT t0.terminal_id AS terminal_id_1, t0.name AS name_2, t0.login AS login_3, t0.password AS password_4, t0.secret_seed AS secret_seed_5, t0.ulid AS ulid_6, t0.bank_id AS bank_id_7 FROM payments_terminal t0
Parameters:
[]
4 0.41 ms
SELECT t0.name AS name_1, t0.address AS address_2, t0.type AS type_3, t0.url AS url_4, t0.ulid AS ulid_5 FROM payments_bank t0 WHERE t0.ulid = ?
Parameters:
[
  "01JV22VWVTG1804CRZX3C2KM92"
]
5 0.59 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.id = ?
Parameters:
[
  32
]
6 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.site AS site_4, t0.city AS city_5, t0.adress AS adress_6, t0.postcode AS postcode_7, t0.code AS code_8 FROM company t0
Parameters:
[]
7 0.87 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 = ? ORDER BY t0.sort ASC
Parameters:
[
  32
]
8 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 = ? ORDER BY t0.sort ASC
Parameters:
[
  32
]
9 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.hotel_id = ? ORDER BY t0.sort ASC
Parameters:
[
  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\HotelRoomType 7
App\Booking\Domain\Entity\EquipmentCategory 4
App\Booking\Domain\Entity\PaymentMethod 3
App\Booking\Domain\Entity\RulesPayBack 3
App\Booking\Domain\Entity\Company 2
App\Users\Domain\Entity\User 1
App\Users\Domain\Entity\Passport 1
App\Payment\Domain\Entity\Terminal 1
App\Payment\Domain\Entity\Bank 1
App\Booking\Domain\Entity\Hotel 1