http://admindev.volcanohostal.com/login

Query Metrics

48 Database Queries
35 Different statements
10.97 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.02 ms
(9.29%)
4
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'PAYMENT_STATUS'
Parameters:
[]
0.83 ms
(7.59%)
1
SELECT m0_.device_id AS device_id_0, m0_.device_follow_id AS device_follow_id_1, m0_.device_no AS device_no_2, m0_.device_number AS device_number_3, m0_.user_id AS user_id_4, m0_.device_name AS device_name_5, m0_.device_reference AS device_reference_6, m0_.device_remarks AS device_remarks_7, m0_.device_enabled AS device_enabled_8, m0_.device_date_add AS device_date_add_9, m0_.device_add_by AS device_add_by_10, m0_.device_date_update AS device_date_update_11, m0_.device_update_by AS device_update_by_12, m0_.device_ip AS device_ip_13, m0_.device_md5 AS device_md5_14, m0_.device_useragent AS device_useragent_15, m0_.device_useragentname AS device_useragentname_16, m0_.device_version AS device_version_17, m0_.device_platform AS device_platform_18, m0_.device_pattern AS device_pattern_19, u1_.id AS id_20, u1_.user_follow_id AS user_follow_id_21, u1_.user_no AS user_no_22, u1_.email AS email_23, u1_.roles AS roles_24, u1_.password AS password_25, u1_.enabled AS enabled_26, u1_.confirmation_token AS confirmation_token_27, u1_.firstname AS firstname_28, u1_.lastname AS lastname_29, u1_.mobile AS mobile_30, u1_.position AS position_31, u1_.location AS location_32, u1_.picture AS picture_33, u1_.personal_information AS personal_information_34, u1_.remarks AS remarks_35, u1_.last_login_at AS last_login_at_36, u1_.created_at AS created_at_37, u1_.updated_at AS updated_at_38, u1_.user_add_by AS user_add_by_39, u1_.user_update_by AS user_update_by_40 FROM modulo_devices m0_ LEFT JOIN user u1_ ON (u1_.id = m0_.user_id) WHERE m0_.device_md5 = ? GROUP BY m0_.device_id
Parameters:
[
  "059980228a62b687bba3feedb368f63c"
]
0.64 ms
(5.88%)
1
SELECT i0_.init_company_id AS init_company_id_0, i0_.init_company_follow_id AS init_company_follow_id_1, i0_.init_company_no AS init_company_no_2, i0_.init_company_name AS init_company_name_3, i0_.init_company_address AS init_company_address_4, i0_.init_company_local AS init_company_local_5, i0_.init_company_city AS init_company_city_6, i0_.init_company_province AS init_company_province_7, i0_.init_company_postalcode AS init_company_postalcode_8, i0_.init_company_region AS init_company_region_9, i0_.init_company_country AS init_company_country_10, i0_.init_company_phone AS init_company_phone_11, i0_.init_company_email AS init_company_email_12, i0_.init_company_email_commercial AS init_company_email_commercial_13, i0_.init_company_email_accounting AS init_company_email_accounting_14, i0_.init_company_logo AS init_company_logo_15, i0_.init_company_qrcode_logo AS init_company_qrcode_logo_16, i0_.init_company_add_by AS init_company_add_by_17, i0_.init_company_update_by AS init_company_update_by_18, i0_.init_company_enabled AS init_company_enabled_19, i0_.init_company_date_add AS init_company_date_add_20, i0_.init_company_date_update AS init_company_date_update_21 FROM init_company i0_ WHERE i0_.init_company_no = ?
Parameters:
[
  "29717632"
]
0.61 ms
(5.56%)
1
SELECT m0_.hotel_channel_number AS hotel_channel_number_0, m0_.hotel_channel_follow_id AS hotel_channel_follow_id_1, m0_.hotel_channel_name AS hotel_channel_name_2 FROM modulo_hotel_channels m0_
Parameters:
[]
0.56 ms
(5.10%)
4
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'LANGUAGES'
Parameters:
[]
0.55 ms
(5.00%)
1
SELECT m0_.hotel_rooms_type_number AS hotel_rooms_type_number_0, m0_.hotel_rooms_type_follow_id AS hotel_rooms_type_follow_id_1, m0_.hotel_rooms_type_name AS hotel_rooms_type_name_2 FROM modulo_hotel_rooms_types m0_
Parameters:
[]
0.52 ms
(4.72%)
4
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'BOOKING_STATUS'
Parameters:
[]
0.52 ms
(4.71%)
4
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'CHILD_AGES'
Parameters:
[]
0.44 ms
(4.05%)
1
SELECT m0_.hotel_room_number AS hotel_room_number_0, m0_.hotel_room_follow_id AS hotel_room_follow_id_1, m0_.hotel_room_name AS hotel_room_name_2 FROM modulo_hotel_rooms m0_
Parameters:
[]
0.30 ms
(2.72%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTEL' AND lcKeyName = 'DAY_PLATEFORMS_START'
Parameters:
[]
0.29 ms
(2.61%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTEL' AND lcKeyName = 'REPORTS_QUANTITY_MONTHS_AFTER_CURRENT_MONTH'
Parameters:
[]
0.24 ms
(2.19%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'MODULOEMAILTEMPLATE' AND lcKeyName = 'LANGUAGES'
Parameters:
[]
0.23 ms
(2.12%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_DATE'
Parameters:
[]
0.23 ms
(2.09%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL'
Parameters:
[]
0.23 ms
(2.08%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'CHANNELS_TYPES'
Parameters:
[]
0.22 ms
(2.00%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_CASH_DATE'
Parameters:
[]
0.21 ms
(1.91%)
2
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'MEDIA_TYPES'
Parameters:
[]
0.21 ms
(1.91%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_EXPEDIA'
Parameters:
[]
0.21 ms
(1.90%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_CASH_DATE'
Parameters:
[]
0.21 ms
(1.89%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CREDIT_CARD'
Parameters:
[]
0.21 ms
(1.88%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CASH'
Parameters:
[]
0.21 ms
(1.88%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'MODULOEMAILTEMPLATE' AND lcKeyName = 'EMAIL_TEMPLATE_TYPES'
Parameters:
[]
0.20 ms
(1.87%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_CASH_AMOUNT'
Parameters:
[]
0.20 ms
(1.84%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_PROMOTION'
Parameters:
[]
0.19 ms
(1.77%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_BOOKING'
Parameters:
[]
0.19 ms
(1.70%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_COLLECT'
Parameters:
[]
0.18 ms
(1.67%)
1
SELECT m0_.hotel_channel_number AS hotel_channel_number_0, m0_.hotel_channel_follow_id AS hotel_channel_follow_id_1, m0_.hotel_channel_name AS hotel_channel_name_2, m0_.hotel_channel_color AS hotel_channel_color_3, m0_.hotel_channel_background_color AS hotel_channel_background_color_4, m0_.hotel_channel_border_color AS hotel_channel_border_color_5 FROM modulo_hotel_channels m0_
Parameters:
[]
0.18 ms
(1.63%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'GUEST_GENDER'
Parameters:
[]
0.17 ms
(1.59%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'ACCOUNTSMOVEMENTS_TYPES'
Parameters:
[]
0.17 ms
(1.58%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'ACCOUNTSMOVEMENTS_ACCOUNTS'
Parameters:
[]
0.17 ms
(1.53%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_AMOUNT'
Parameters:
[]
0.17 ms
(1.52%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'MINIMUM_DAYS_BOOKING_COUNTS_IN_OVERBOOKING'
Parameters:
[]
0.16 ms
(1.50%)
1
SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_CASH_AMOUNT'
Parameters:
[]
0.16 ms
(1.42%)
1
SELECT m0_.hotel_rooms_type_number AS hotel_rooms_type_number_0, m0_.hotel_rooms_type_follow_id AS hotel_rooms_type_follow_id_1, m0_.hotel_rooms_type_name AS hotel_rooms_type_name_2, m0_.hotel_rooms_type_color AS hotel_rooms_type_color_3, m0_.hotel_rooms_type_background_color AS hotel_rooms_type_background_color_4, m0_.hotel_rooms_type_border_color AS hotel_rooms_type_border_color_5, m0_.hotel_rooms_type_alternative_room_if_room_occupied AS hotel_rooms_type_alternative_room_if_room_occupied_6, m0_.hotel_rooms_type_maximum_bookings_to_consider_alert AS hotel_rooms_type_maximum_bookings_to_consider_alert_7, m0_.hotel_rooms_type_maximum_bookings_to_consider_critical AS hotel_rooms_type_maximum_bookings_to_consider_critical_8 FROM modulo_hotel_rooms_types m0_
Parameters:
[]
0.15 ms
(1.33%)
1
SELECT m0_.hotel_room_number AS hotel_room_number_0, m0_.hotel_room_follow_id AS hotel_room_follow_id_1, m0_.hotel_room_name AS hotel_room_name_2, m0_.hotel_room_door_number AS hotel_room_door_number_3, m0_.hotel_room_color AS hotel_room_color_4, m0_.hotel_room_background_color AS hotel_room_background_color_5, m0_.hotel_room_border_color AS hotel_room_border_color_6, m0_.hotel_room_alternative_room_if_room_occupied AS hotel_room_alternative_room_if_room_occupied_7, m0_.hotel_room_maximum_bookings_to_consider_alert AS hotel_room_maximum_bookings_to_consider_alert_8, m0_.hotel_room_maximum_bookings_to_consider_critical AS hotel_room_maximum_bookings_to_consider_critical_9 FROM modulo_hotel_rooms m0_
Parameters:
[]

Database Connections

Name Service
Symfony doctrine.dbal.Symfony_connection

Entity Managers

Name Service
Symfony doctrine.orm.Symfony_entity_manager

Second Level Cache

Second Level Cache is not enabled.