Symfony Profiler

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 = ?

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 = '29717632';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'PAYMENT_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'PAYMENT_STATUS';

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_

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_;

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_

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_;

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_

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_;

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'LANGUAGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'LANGUAGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'CHILD_AGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'CHILD_AGES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'BOOKING_STATUS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'BOOKING_STATUS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTEL'
  AND lcKeyName = 'DAY_PLATEFORMS_START'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTEL' AND lcKeyName = 'DAY_PLATEFORMS_START';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'MINIMUM_DAYS_BOOKING_COUNTS_IN_OVERBOOKING'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'MINIMUM_DAYS_BOOKING_COUNTS_IN_OVERBOOKING';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_EXPEDIA'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_EXPEDIA';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'MEDIA_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'MEDIA_TYPES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTEL'
  AND lcKeyName = 'REPORTS_QUANTITY_MONTHS_AFTER_CURRENT_MONTH'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTEL' AND lcKeyName = 'REPORTS_QUANTITY_MONTHS_AFTER_CURRENT_MONTH';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELBOOKING'
  AND lcKeyName = 'GUEST_GENDER'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELBOOKING' AND lcKeyName = 'GUEST_GENDER';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'MODULOEMAILTEMPLATE'
  AND lcKeyName = 'LANGUAGES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'MODULOEMAILTEMPLATE' AND lcKeyName = 'LANGUAGES';

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_

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_;

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CREDIT_CARD'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CREDIT_CARD';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_BANK_CASH_DATE'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_CASH_DATE';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'CHANNELS_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'CHANNELS_TYPES';

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_

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_;

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'ACCOUNTSMOVEMENTS_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'ACCOUNTSMOVEMENTS_TYPES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CASH'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_CASH';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_BANK_AMOUNT'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_AMOUNT';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_BOOKING'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_BOOKING';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_CASH_DATE'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_CASH_DATE';

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_

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_;

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_PROMOTION'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_PROMOTION';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_BANK_CASH_AMOUNT'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_CASH_AMOUNT';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_BANK_DATE'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_BANK_DATE';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'OPEN_CASH_AMOUNT'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'OPEN_CASH_AMOUNT';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'ACCOUNTS'
  AND lcKeyName = 'ACCOUNTSMOVEMENTS_ACCOUNTS'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'ACCOUNTS' AND lcKeyName = 'ACCOUNTSMOVEMENTS_ACCOUNTS';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'MODULOEMAILTEMPLATE'
  AND lcKeyName = 'EMAIL_TEMPLATE_TYPES'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'MODULOEMAILTEMPLATE' AND lcKeyName = 'EMAIL_TEMPLATE_TYPES';

SELECT
  lcKeyValue
FROM
  `init_configurations`
WHERE
  lcKeyFor = 'CONFIGURATIONS'
  AND lcKeyModulo = 'HOTELCHANNEL'
  AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_COLLECT'

SELECT lcKeyValue FROM `init_configurations` WHERE lcKeyFor = 'CONFIGURATIONS' AND lcKeyModulo = 'HOTELCHANNEL' AND lcKeyName = 'HOTEL_CHANNEL_NUMBER_HOTEL_COLLECT';