Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.date_of_birth AS date_of_birth_14,
  t0.firstname AS firstname_15,
  t0.lastname AS lastname_16,
  t0.website AS website_17,
  t0.biography AS biography_18,
  t0.gender AS gender_19,
  t0.locale AS locale_20,
  t0.timezone AS timezone_21,
  t0.phone AS phone_22,
  t0.facebook_uid AS facebook_uid_23,
  t0.facebook_name AS facebook_name_24,
  t0.facebook_data AS facebook_data_25,
  t0.twitter_uid AS twitter_uid_26,
  t0.twitter_name AS twitter_name_27,
  t0.twitter_data AS twitter_data_28,
  t0.gplus_uid AS gplus_uid_29,
  t0.gplus_name AS gplus_name_30,
  t0.gplus_data AS gplus_data_31,
  t0.token AS token_32,
  t0.two_step_code AS two_step_code_33,
  t0.id AS id_34,
  t0.property_id AS property_id_35,
  t0.contract_id AS contract_id_36
FROM
  jwtuser t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.date_of_birth AS date_of_birth_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.website AS website_17, t0.biography AS biography_18, t0.gender AS gender_19, t0.locale AS locale_20, t0.timezone AS timezone_21, t0.phone AS phone_22, t0.facebook_uid AS facebook_uid_23, t0.facebook_name AS facebook_name_24, t0.facebook_data AS facebook_data_25, t0.twitter_uid AS twitter_uid_26, t0.twitter_name AS twitter_name_27, t0.twitter_data AS twitter_data_28, t0.gplus_uid AS gplus_uid_29, t0.gplus_name AS gplus_name_30, t0.gplus_data AS gplus_data_31, t0.token AS token_32, t0.two_step_code AS two_step_code_33, t0.id AS id_34, t0.property_id AS property_id_35, t0.contract_id AS contract_id_36 FROM jwtuser t0 WHERE t0.username = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_26687' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  jwtuser
SET
  last_login = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE jwtuser SET last_login = '2025-09-08 18:01:03', updated_at = '2025-09-08 18:01:03' WHERE id = 35352;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.monitoring_id AS monitoring_id_5,
  t0.external_identifier AS external_identifier_6,
  t0.external_id AS external_id_7,
  t0.is_default AS is_default_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.identifier AS identifier_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.client_id AS client_id_14,
  t0.pms_settings_id AS pms_settings_id_15,
  t0.sync_data_id AS sync_data_id_16,
  t0.smtp_settings_id AS smtp_settings_id_17,
  t0.payment_gateway_settings_id AS payment_gateway_settings_id_18,
  t0.logo_id AS logo_id_19,
  t20.id AS id_21,
  t20.endpoint AS endpoint_22,
  t20.monitoring_id AS monitoring_id_23,
  t20.is_allowed AS is_allowed_24,
  t20.property_id AS property_id_25,
  t0.contact_address_id AS contact_address_id_26
FROM
  property t0
  LEFT JOIN online_checkin_settings t20 ON t20.property_id = t0.id
WHERE
  t0.monitoring_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.monitoring_id AS monitoring_id_5, t0.external_identifier AS external_identifier_6, t0.external_id AS external_id_7, t0.is_default AS is_default_8, t0.email AS email_9, t0.phone AS phone_10, t0.identifier AS identifier_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.client_id AS client_id_14, t0.pms_settings_id AS pms_settings_id_15, t0.sync_data_id AS sync_data_id_16, t0.smtp_settings_id AS smtp_settings_id_17, t0.payment_gateway_settings_id AS payment_gateway_settings_id_18, t0.logo_id AS logo_id_19, t20.id AS id_21, t20.endpoint AS endpoint_22, t20.monitoring_id AS monitoring_id_23, t20.is_allowed AS is_allowed_24, t20.property_id AS property_id_25, t0.contact_address_id AS contact_address_id_26 FROM property t0 LEFT JOIN online_checkin_settings t20 ON t20.property_id = t0.id WHERE t0.monitoring_id = '250' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.endpoint AS endpoint_5,
  t0.credentials1 AS credentials1_6,
  t0.credentials2 AS credentials2_7,
  t0.credentials3 AS credentials3_8,
  t0.identifier AS identifier_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.client_id AS client_id_12,
  t0.pms_id AS pms_id_13
FROM
  pmsconnector_settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.endpoint AS endpoint_5, t0.credentials1 AS credentials1_6, t0.credentials2 AS credentials2_7, t0.credentials3 AS credentials3_8, t0.identifier AS identifier_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.client_id AS client_id_12, t0.pms_id AS pms_id_13 FROM pmsconnector_settings t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.identifier AS identifier_5,
  t0.created_by_id AS created_by_id_6,
  t0.updated_by_id AS updated_by_id_7
FROM
  pmssystem t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.identifier AS identifier_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM pmssystem t0 WHERE t0.id = 4;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO connector_log_message (
  monitoring_id, date, duration, endpoint,
  method, headers, payload, response
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO connector_log_message (monitoring_id, date, duration, endpoint, method, headers, payload, response) VALUES ('250', '2025-09-08 18:01:03', 0.57829117774963, 'https://online.agnis.cz/api/auth/login', 'POST', '[]', '{\"username\":\"202113756\",\"password\":\"uqrA#CUQEJB4uT\"}', '{\"success\":true,\"data\":{\"uid\":678,\"active\":1,\"fullName\":\"Hotel N API\",\"username\":\"202113756\",\"avatar\":\"\",\"email\":\"api-202113756@agnis.cz\",\"token\":\"2059328|v0q6b5ySdKZYQ6mo9v1TYTTmWPfucpBgxR8YknsGfca7b62f\",\"currentLicense\":30,\"licenses\":[{\"id\":30,\"name\":\"Hotel N\",\"number\":\"202113756\",\"logo\":\"https:\\/\\/online.agnis.cz\\/storage\\/768\\/logo.png\"}],\"address\":[],\"mobile\":\"\",\"locale\":\"cs\",\"departmentId\":2,\"idkeys\":[],\"settings\":[],\"userRole\":\"public-api\",\"roles\":[\"public-api\"],\"permissions\":[\"docs view\",\"categories view\",\"contents view\",\"vouchers view\",\"vouchers create\",\"vouchers edit\",\"kasOrders view\",\"kasOrders create\",\"kasOrders edit\",\"kasOccupations view\",\"kasOccupations create\",\"kasOccupations edit\",\"recOccupations view\",\"recOccupations create\",\"recOccupations edit\",\"recRooms view\",\"recRooms create\",\"recRooms edit\",\"recReservations view\",\"recReservations create\",\"recReservations edit\",\"recPayments view\",\"recPayments create\",\"recPayments edit\",\"paymentgateways view\",\"loyalty create\",\"loyalty edit\",\"loyalty view\"],\"ability\":[{\"action\":\"view\",\"subject\":\"Publics\"},{\"action\":\"read\",\"subject\":\"Auth\"},{\"action\":\"view\",\"subject\":\"Docs\"},{\"action\":\"view\",\"subject\":\"Categories\"},{\"action\":\"view\",\"subject\":\"Contents\"},{\"action\":\"view\",\"subject\":\"KasOrders\"},{\"action\":\"create\",\"subject\":\"KasOrders\"},{\"action\":\"edit\",\"subject\":\"KasOrders\"},{\"action\":\"view\",\"subject\":\"KasOccupations\"},{\"action\":\"create\",\"subject\":\"KasOccupations\"},{\"action\":\"edit\",\"subject\":\"KasOccupations\"},{\"action\":\"view\",\"subject\":\"RecOccupations\"},{\"action\":\"create\",\"subject\":\"RecOccupations\"},{\"action\":\"edit\",\"subject\":\"RecOccupations\"},{\"action\":\"view\",\"subject\":\"RecRooms\"},{\"action\":\"create\",\"subject\":\"RecRooms\"},{\"action\":\"edit\",\"subject\":\"RecRooms\"},{\"action\":\"view\",\"subject\":\"RecReservations\"},{\"action\":\"create\",\"subject\":\"RecReservations\"},{\"action\":\"edit\",\"subject\":\"RecReservations\"},{\"action\":\"view\",\"subject\":\"RecPayments\"},{\"action\":\"create\",\"subject\":\"RecPayments\"},{\"action\":\"edit\",\"subject\":\"RecPayments\"},{\"action\":\"view\",\"subject\":\"Paymentgateways\"},{\"action\":\"create\",\"subject\":\"Loyalty\"},{\"action\":\"edit\",\"subject\":\"Loyalty\"},{\"action\":\"view\",\"subject\":\"Loyalty\"}],\"about\":\"N\\u011bco o m\\u011b\",\"dob\":\"28 January 1998\",\"gender\":\"male\",\"country\":\"Bolivia\",\"status\":\"online\",\"is_verified\":true,\"department\":\"sales\",\"company\":\"WinDon Technologies Pvt Ltd\",\"website\":\"https:\\/\\/example.com\",\"contact_options\":[\"email\",\"message\",\"phone\"],\"social_links\":{\"twitter\":\"https:\\/\\/twitter.com\\/#\",\"facebook\":\"https:\\/\\/www.facebook.com\\/#\",\"instagram\":\"https:\\/\\/www.instagram.com\\/#\\/\",\"github\":\"https:\\/\\/github.com\\/#\",\"codepen\":\"https:\\/\\/codepen.io\\/#\",\"slack\":\"@#\"}},\"error\":false}');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.birth_date AS birth_date_4,
  t0.birth_place AS birth_place_5,
  t0.external_identifier AS external_identifier_6,
  t0.email AS email_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.notes AS notes_10,
  t0.phone AS phone_11,
  t0.loyalty_code AS loyalty_code_12,
  t0.external_id AS external_id_13,
  t0.purpose_of_stay AS purpose_of_stay_14,
  t0.signature AS signature_15,
  t0.license_plate AS license_plate_16,
  t0.identifier AS identifier_17,
  t0.created_by_id AS created_by_id_18,
  t0.updated_by_id AS updated_by_id_19,
  t0.client_id AS client_id_20,
  t0.property_id AS property_id_21,
  t0.address_id AS address_id_22,
  t0.language_id AS language_id_23,
  t0.nationality_id AS nationality_id_24,
  t0.gender_id AS gender_id_25,
  t0.user_id AS user_id_26
FROM
  guest t0
WHERE
  t0.identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.birth_date AS birth_date_4, t0.birth_place AS birth_place_5, t0.external_identifier AS external_identifier_6, t0.email AS email_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.notes AS notes_10, t0.phone AS phone_11, t0.loyalty_code AS loyalty_code_12, t0.external_id AS external_id_13, t0.purpose_of_stay AS purpose_of_stay_14, t0.signature AS signature_15, t0.license_plate AS license_plate_16, t0.identifier AS identifier_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.client_id AS client_id_20, t0.property_id AS property_id_21, t0.address_id AS address_id_22, t0.language_id AS language_id_23, t0.nationality_id AS nationality_id_24, t0.gender_id AS gender_id_25, t0.user_id AS user_id_26 FROM guest t0 WHERE t0.identifier = '1b5df190-def3-4a7e-be29-c0fc93961e5a' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.birth_date AS birth_date_4,
  t0.birth_place AS birth_place_5,
  t0.external_identifier AS external_identifier_6,
  t0.email AS email_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.notes AS notes_10,
  t0.phone AS phone_11,
  t0.loyalty_code AS loyalty_code_12,
  t0.external_id AS external_id_13,
  t0.purpose_of_stay AS purpose_of_stay_14,
  t0.signature AS signature_15,
  t0.license_plate AS license_plate_16,
  t0.identifier AS identifier_17,
  t0.created_by_id AS created_by_id_18,
  t0.updated_by_id AS updated_by_id_19,
  t0.client_id AS client_id_20,
  t0.property_id AS property_id_21,
  t0.address_id AS address_id_22,
  t0.language_id AS language_id_23,
  t0.nationality_id AS nationality_id_24,
  t0.gender_id AS gender_id_25,
  t0.user_id AS user_id_26
FROM
  guest t0
WHERE
  t0.external_identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.birth_date AS birth_date_4, t0.birth_place AS birth_place_5, t0.external_identifier AS external_identifier_6, t0.email AS email_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.notes AS notes_10, t0.phone AS phone_11, t0.loyalty_code AS loyalty_code_12, t0.external_id AS external_id_13, t0.purpose_of_stay AS purpose_of_stay_14, t0.signature AS signature_15, t0.license_plate AS license_plate_16, t0.identifier AS identifier_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.client_id AS client_id_20, t0.property_id AS property_id_21, t0.address_id AS address_id_22, t0.language_id AS language_id_23, t0.nationality_id AS nationality_id_24, t0.gender_id AS gender_id_25, t0.user_id AS user_id_26 FROM guest t0 WHERE t0.external_identifier = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_92897_2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.line1 AS line1_4,
  t0.line2 AS line2_5,
  t0.city AS city_6,
  t0.postal_code AS postal_code_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.external_identifier AS external_identifier_10,
  t0.external_id AS external_id_11,
  t0.identifier AS identifier_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14,
  t0.country_id AS country_id_15
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.line1 AS line1_4, t0.line2 AS line2_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.external_identifier AS external_identifier_10, t0.external_id AS external_id_11, t0.identifier AS identifier_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.country_id AS country_id_15 FROM address t0 WHERE t0.id = 32434;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.code AS code_4,
  t0.name AS name_5,
  t0.identifier AS identifier_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.code AS code_4, t0.name AS name_5, t0.identifier AS identifier_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM country t0 WHERE t0.id = 56;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.code AS code_3,
  c0_.name AS name_4,
  c0_.identifier AS identifier_5,
  c0_.created_by_id AS created_by_id_6,
  c0_.updated_by_id AS updated_by_id_7
FROM
  country c0_
WHERE
  c0_.code = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.code AS code_3, c0_.name AS name_4, c0_.identifier AS identifier_5, c0_.created_by_id AS created_by_id_6, c0_.updated_by_id AS updated_by_id_7 FROM country c0_ WHERE c0_.code = 'CZ' ORDER BY c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.code AS code_3,
  c0_.name AS name_4,
  c0_.identifier AS identifier_5,
  c0_.created_by_id AS created_by_id_6,
  c0_.updated_by_id AS updated_by_id_7
FROM
  country c0_
WHERE
  c0_.code = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.code AS code_3, c0_.name AS name_4, c0_.identifier AS identifier_5, c0_.created_by_id AS created_by_id_6, c0_.updated_by_id AS updated_by_id_7 FROM country c0_ WHERE c0_.code = 'CZ' ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.number AS number_4,
  t0.expiration AS expiration_5,
  t0.issuance AS issuance_6,
  t0.external_identifier AS external_identifier_7,
  t0.external_id AS external_id_8,
  t0.identifier AS identifier_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.guest_id AS guest_id_12,
  t0.type_id AS type_id_13,
  t0.issuing_country_id AS issuing_country_id_14
FROM
  document t0
WHERE
  t0.guest_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.number AS number_4, t0.expiration AS expiration_5, t0.issuance AS issuance_6, t0.external_identifier AS external_identifier_7, t0.external_id AS external_id_8, t0.identifier AS identifier_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.guest_id AS guest_id_12, t0.type_id AS type_id_13, t0.issuing_country_id AS issuing_country_id_14 FROM document t0 WHERE t0.guest_id = 46944;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.birth_date AS birth_date_4,
  t0.birth_place AS birth_place_5,
  t0.external_identifier AS external_identifier_6,
  t0.email AS email_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.notes AS notes_10,
  t0.phone AS phone_11,
  t0.loyalty_code AS loyalty_code_12,
  t0.external_id AS external_id_13,
  t0.purpose_of_stay AS purpose_of_stay_14,
  t0.signature AS signature_15,
  t0.license_plate AS license_plate_16,
  t0.identifier AS identifier_17,
  t0.created_by_id AS created_by_id_18,
  t0.updated_by_id AS updated_by_id_19,
  t0.client_id AS client_id_20,
  t0.property_id AS property_id_21,
  t0.address_id AS address_id_22,
  t0.language_id AS language_id_23,
  t0.nationality_id AS nationality_id_24,
  t0.gender_id AS gender_id_25,
  t0.user_id AS user_id_26
FROM
  guest t0
WHERE
  t0.external_identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.birth_date AS birth_date_4, t0.birth_place AS birth_place_5, t0.external_identifier AS external_identifier_6, t0.email AS email_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.notes AS notes_10, t0.phone AS phone_11, t0.loyalty_code AS loyalty_code_12, t0.external_id AS external_id_13, t0.purpose_of_stay AS purpose_of_stay_14, t0.signature AS signature_15, t0.license_plate AS license_plate_16, t0.identifier AS identifier_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.client_id AS client_id_20, t0.property_id AS property_id_21, t0.address_id AS address_id_22, t0.language_id AS language_id_23, t0.nationality_id AS nationality_id_24, t0.gender_id AS gender_id_25, t0.user_id AS user_id_26 FROM guest t0 WHERE t0.external_identifier = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_92897_2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.line1 AS line1_4,
  t0.line2 AS line2_5,
  t0.city AS city_6,
  t0.postal_code AS postal_code_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.external_identifier AS external_identifier_10,
  t0.external_id AS external_id_11,
  t0.identifier AS identifier_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14,
  t0.country_id AS country_id_15
FROM
  address t0
WHERE
  t0.external_identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.line1 AS line1_4, t0.line2 AS line2_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.external_identifier AS external_identifier_10, t0.external_id AS external_id_11, t0.identifier AS identifier_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.country_id AS country_id_15 FROM address t0 WHERE t0.external_identifier = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_92897_2e441fcf4a7686817fe868bf38a5c2c07' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.code AS code_3,
  c0_.name AS name_4,
  c0_.identifier AS identifier_5,
  c0_.created_by_id AS created_by_id_6,
  c0_.updated_by_id AS updated_by_id_7
FROM
  country c0_
WHERE
  c0_.code = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.code AS code_3, c0_.name AS name_4, c0_.identifier AS identifier_5, c0_.created_by_id AS created_by_id_6, c0_.updated_by_id AS updated_by_id_7 FROM country c0_ WHERE c0_.code = 'CZ' ORDER BY c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.code AS code_3,
  c0_.name AS name_4,
  c0_.identifier AS identifier_5,
  c0_.created_by_id AS created_by_id_6,
  c0_.updated_by_id AS updated_by_id_7
FROM
  country c0_
WHERE
  c0_.code = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.code AS code_3, c0_.name AS name_4, c0_.identifier AS identifier_5, c0_.created_by_id AS created_by_id_6, c0_.updated_by_id AS updated_by_id_7 FROM country c0_ WHERE c0_.code = 'CZ' ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.monitoring_id AS monitoring_id_5,
  t0.external_identifier AS external_identifier_6,
  t0.external_id AS external_id_7,
  t0.is_default AS is_default_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.identifier AS identifier_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.client_id AS client_id_14,
  t0.pms_settings_id AS pms_settings_id_15,
  t0.sync_data_id AS sync_data_id_16,
  t0.smtp_settings_id AS smtp_settings_id_17,
  t0.payment_gateway_settings_id AS payment_gateway_settings_id_18,
  t0.logo_id AS logo_id_19,
  t20.id AS id_21,
  t20.endpoint AS endpoint_22,
  t20.monitoring_id AS monitoring_id_23,
  t20.is_allowed AS is_allowed_24,
  t20.property_id AS property_id_25,
  t0.contact_address_id AS contact_address_id_26
FROM
  property t0
  LEFT JOIN online_checkin_settings t20 ON t20.property_id = t0.id
WHERE
  t0.monitoring_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.monitoring_id AS monitoring_id_5, t0.external_identifier AS external_identifier_6, t0.external_id AS external_id_7, t0.is_default AS is_default_8, t0.email AS email_9, t0.phone AS phone_10, t0.identifier AS identifier_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.client_id AS client_id_14, t0.pms_settings_id AS pms_settings_id_15, t0.sync_data_id AS sync_data_id_16, t0.smtp_settings_id AS smtp_settings_id_17, t0.payment_gateway_settings_id AS payment_gateway_settings_id_18, t0.logo_id AS logo_id_19, t20.id AS id_21, t20.endpoint AS endpoint_22, t20.monitoring_id AS monitoring_id_23, t20.is_allowed AS is_allowed_24, t20.property_id AS property_id_25, t0.contact_address_id AS contact_address_id_26 FROM property t0 LEFT JOIN online_checkin_settings t20 ON t20.property_id = t0.id WHERE t0.monitoring_id = '250' LIMIT 1;