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:00:57', updated_at = '2025-09-08 18:00:57' 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:00:57', 0.36255788803101, '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\":\"2059326|HoQnuEOPnSmsf05xxkMSAaPmuHuQAwGpukUNPYbx9c3dd6a4\",\"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.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.identifier AS identifier_4,
  t0.name AS name_5,
  t0.number AS number_6,
  t0.adult_count AS adult_count_7,
  t0.child_count AS child_count_8,
  t0.start AS start_9,
  t0.end AS end_10,
  t0.is_paid AS is_paid_11,
  t0.send_guest_to_reception AS send_guest_to_reception_12,
  t0.email AS email_13,
  t0.phone AS phone_14,
  t0.is_business_trip AS is_business_trip_15,
  t0.external_identifier AS external_identifier_16,
  t0.external_id AS external_id_17,
  t0.created_by_id AS created_by_id_18,
  t0.updated_by_id AS updated_by_id_19,
  t0.contract_id AS contract_id_20,
  t0.state_id AS state_id_21,
  t0.company_id AS company_id_22,
  t0.price_id AS price_id_23,
  t0.accommodation_price_id AS accommodation_price_id_24,
  t0.accommodation_price_total_id AS accommodation_price_total_id_25,
  t0.space_id AS space_id_26
FROM
  contract_item 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.identifier AS identifier_4, t0.name AS name_5, t0.number AS number_6, t0.adult_count AS adult_count_7, t0.child_count AS child_count_8, t0.start AS start_9, t0.end AS end_10, t0.is_paid AS is_paid_11, t0.send_guest_to_reception AS send_guest_to_reception_12, t0.email AS email_13, t0.phone AS phone_14, t0.is_business_trip AS is_business_trip_15, t0.external_identifier AS external_identifier_16, t0.external_id AS external_id_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.contract_id AS contract_id_20, t0.state_id AS state_id_21, t0.company_id AS company_id_22, t0.price_id AS price_id_23, t0.accommodation_price_id AS accommodation_price_id_24, t0.accommodation_price_total_id AS accommodation_price_total_id_25, t0.space_id AS space_id_26 FROM contract_item t0 WHERE t0.identifier = '6675c750-6388-4517-a3f2-97c07714bd50' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.external_identifier AS external_identifier_4,
  t0.name AS name_5,
  t0.number AS number_6,
  t0.crs AS crs_7,
  t0.adult_count AS adult_count_8,
  t0.child_count AS child_count_9,
  t0.start AS start_10,
  t0.end AS end_11,
  t0.external_id AS external_id_12,
  t0.is_online_checkin_allowed AS is_online_checkin_allowed_13,
  t0.identifier AS identifier_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.client_id AS client_id_17,
  t0.property_id AS property_id_18,
  t0.state_id AS state_id_19,
  t0.main_guest_id AS main_guest_id_20
FROM
  contract 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.external_identifier AS external_identifier_4, t0.name AS name_5, t0.number AS number_6, t0.crs AS crs_7, t0.adult_count AS adult_count_8, t0.child_count AS child_count_9, t0.start AS start_10, t0.end AS end_11, t0.external_id AS external_id_12, t0.is_online_checkin_allowed AS is_online_checkin_allowed_13, t0.identifier AS identifier_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.client_id AS client_id_17, t0.property_id AS property_id_18, t0.state_id AS state_id_19, t0.main_guest_id AS main_guest_id_20 FROM contract t0 WHERE t0.id = 39888;

"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:00:58', 0.84115290641785, 'https://online.agnis.cz/api/30/rec/reservations/26687', 'GET', '{\"Authorization\":\"Bearer 2059326|HoQnuEOPnSmsf05xxkMSAaPmuHuQAwGpukUNPYbx9c3dd6a4\"}', '[]', '{\"data\":{\"id\":26687,\"mode\":\"R\",\"group\":0,\"name\":\"Miskova Radka\",\"companyName\":\"\",\"address\":{\"street\":\"Smrcna c.ev. 158\",\"postcode\":\"58801\",\"city\":\"Smr\\u010dn\\u00e1\",\"country\":{\"name\":\"\\u010cesk\\u00e1 republika\",\"alpha2\":\"CZ\",\"alpha3\":\"CZE\"}},\"phone1\":\"+420 607 981 298\",\"phone2\":\"\",\"phone3\":\"\",\"fax\":\"\",\"email\":\"rmisko.969274@guest.booking.com\",\"contactPerson\":\"\",\"orderNumber\":\"S9EL5I\",\"count\":{\"room\":1,\"total\":2,\"bed\":2,\"extrabed\":0,\"child1\":0,\"child2\":0,\"child3\":0},\"amount\":{\"accommodation\":\"5843.00\",\"board\":\"0.00\",\"other\":\"0.00\",\"event\":\"0.00\"},\"advance\":{\"date\":\"2025-09-04\",\"amount\":\"5763.00\",\"paid\":\"5763.00\",\"variableSymbol\":\"\",\"calculation\":\"5843.00\",\"percent\":100,\"externalNumber\":0,\"qrPlatba\":\"\"},\"qrLogin\":\"\",\"createdAt\":\"2025-08-30 20:59:17\",\"createdBy\":149,\"updatedAt\":\"2025-08-30 20:59:17\",\"updatedBy\":149,\"exclamationmark\":\"\",\"intakeId\":103,\"segmentId\":0,\"pricelistId\":22,\"version2006\":\"2006\",\"status\":\"!\",\"cumulativeArrival\":\"2025-09-08\",\"cumulativeDeparture\":\"2025-09-10\",\"reserve\":\"6562-Booking.com\",\"memo\":\"<p><span style=\\\"\\\">Booking.com 5232031451<\\/span><\\/p><p><span style=\\\"\\\">Sie haben f\\u00fcr diese Buchung eine virtuelle Kreditkarte erhalten.Sie k\\u00f6nnen sie ab dem 2025-08-31 belasten.<\\/span><\\/p><p><span style=\\\"\\\">Dies ist eine SmartFlex-Buchung.<\\/span><\\/p><p><span style=\\\"\\\">Aktualisierte Richtlinie: Kostenfreie Stornierung bis 8 Tage vor Anreise.<\\/span><\\/p><p><span style=\\\"\\\">Bitte belasten Sie nicht die angezeigte virtuelle Kreditkarte (VCC), da sie noch nicht aktiviert wurde. Bei Stornierungen, f\\u00fcr die wir keinen Ersatz finden k\\u00f6nnen, k\\u00f6nnen Sie die Zahlung nach dem Check-out einziehen.<\\/span><\\/p><p><span style=\\\"\\\">Weitere Informationen dazu finden Sie hier: https:\\/\\/admin.booking.com\\/hotel\\/hoteladmin\\/extranet_ng\\/manage\\/booking.html?hotel_id=185680&amp;res_id=5232031451<\\/span><\\/p><p><span style=\\\"\\\">VCC Activation Date : 2025-08-31<\\/span><\\/p><p><span style=\\\"\\\">VCC Current Balance : 0.00<\\/span><\\/p><p><span style=\\\"\\\">VCC Expire Date : 2026-09-01<\\/span><\\/p><p><span style=\\\"\\\">Doppel- oder Zweibettzimmer - FLEXBBEUR :: (Non smoking)&lt;br&gt;&lt;br&gt;&lt;ul&gt;Fr\\u00fchst\\u00fcck ist im Zimmerpreis enthalten.<\\/span><\\/p><p><span style=\\\"\\\">Mittagessen kostet EUR 9 pro Person pro Nacht<\\/span><\\/p><p><span style=\\\"\\\">Abendessen kostet EUR 15 pro Person pro Nacht Zustell- und Kinderbetten: Kinder jeden Alters sind willkommen. 1 Kind ((bis einschlie\\u00dflich 3 Jahre)) \\u00fcbernachtet f\\u00fcr \\u20ac 12 pro Kind pro Nacht, bei Nutzung von verf\\u00fcgbaren Babybetten. 1 Person ((egal welchen Alters)) \\u00fcbernachtet f\\u00fcr \\u20ac 27 pro Kind pro Nacht, bei Nutzung von verf\\u00fcgbaren Zustellbetten. Maximale Anzahl an Extrabetten: 1 Maximale Anzahl an Babybetten: 1 Maximale Gesamtanzahl der G\\u00e4ste: 2  Anzahlungen: Keine Vorauszahlung erforderlich.  Stornierungen: Bis zu 8 Tage vor der Anreise k\\u00f6nnen G\\u00e4ste kostenlos stornieren. Der Gast zahlt im Falle einer Stornierung in den 8 Tagen vor der Anreise einen Betrag in H\\u00f6he des Gesamtpreises. &lt;\\/ul&gt;&lt;br&gt;genius rate (480443) : no 2025-09-08\\/2025-09-09 &lt;br&gt;<\\/span><\\/p><p><span style=\\\"\\\">Extra info :: Flags : booker_is_genius&lt;br&gt;Payments info : payment_on_Booking.com 0.00 EUR Virtual credit card&lt;br&gt;<\\/span><\\/p><p><span style=\\\"\\\">The guest searched for a room for:: adult: 2 &lt;br&gt; The search data is for information purposes only and might not reflect the actual number of guests booked.<\\/span><\\/p><p><span style=\\\"\\\">Preferred Language: Czech<\\/span><\\/p><p><span style=\\\"\\\">30.8.2025 K.<\\/span><\\/p><br>\",\"memo1\":null,\"confirmEmail\":4,\"confirmPrint\":0,\"confirmOther\":0,\"package\":\"\",\"packagePrice\":\"0.00\",\"fixedPackagePrice\":\"\",\"conversionToEuros\":\"\",\"clientId\":0,\"category\":0,\"event\":{\"name\":\"\",\"startedAt\":\"\",\"endedAt\":\"\",\"persons\":0,\"maxPersons\":0,\"sumPersons\":0,\"recurring\":false,\"private\":false},\"newsletter\":false,\"external\":{\"number\":45899874501458,\"voucherId\":\"S9EL5I\",\"voucher2Id\":\"5232031451\"},\"pricePlanDisabled\":false,\"pincode\":2144,\"advances\":[{\"receiptId\":32912,\"receiptType\":\"Z\",\"name\":\"Miskova Radka\",\"paymentType\":\"Banka\",\"amount\":\"5763.00\",\"createdAt\":\"2025-09-07 12:29:18\",\"issuedAt\":\"2025-09-07\",\"taxableSupplyAt\":\"2025-09-07\",\"canceledAt\":\"\",\"shiftId\":11756,\"order\":\"S9EL5I\"}],\"occupations\":[{\"status\":\"R\",\"sort\":1105,\"accountId\":92897,\"reservationId\":26687,\"rezervationId\":26687,\"roomId\":\"105\",\"room\":{\"status\":\"\"},\"blockId\":\"N\",\"arrivedAt\":\"2025-09-08\",\"departuredAt\":\"2025-09-10\",\"fullName\":\"Miskova Radka\",\"anotherName\":\"Miskova Radka\",\"statusDeposit\":\"P\",\"advanceAt\":\"2025-09-04\",\"confirmEmail\":4,\"confirmOther\":0}]}}');

"COMMIT"

"COMMIT";

"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:00:59', 3.5298128128052, 'https://online.agnis.cz/api/30/rec/occupations/92897/prelook', 'GET', '{\"Authorization\":\"Bearer 2059326|HoQnuEOPnSmsf05xxkMSAaPmuHuQAwGpukUNPYbx9c3dd6a4\"}', '[]', '{\"data\":{\"status\":\"R\",\"sort\":1105,\"accountId\":92897,\"reservationId\":26687,\"rezervationId\":26687,\"roomId\":\"105\",\"familyRoomId\":\"\",\"blockId\":\"N\",\"arrivedAt\":\"2025-09-08\",\"departuredAt\":\"2025-09-10\",\"heating\":{\"from\":\"2025-09-08 14:00:00\",\"to\":\"2025-09-10 10:00:00\",\"temperature\":22,\"minutesBefore\":0},\"guestNumber\":1,\"fullName\":\"Miskova Radka\",\"anotherName\":\"Miskova Radka\",\"amount\":{\"accommodation\":5763,\"board\":0,\"fee\":80,\"other\":0},\"account\":{\"status\":2,\"amount\":80,\"currency\":\"CZK\"},\"count\":{\"adult\":2,\"extrabed\":0,\"child1\":0,\"child2\":0,\"child3\":0},\"price\":{\"adult\":\"0.00\",\"extrabed\":\"0.00\",\"child1\":\"0.00\",\"child2\":\"0.00\",\"child3\":\"0.00\",\"room\":\"5843.00\",\"roomWithoutDiscount\":\"0.00\",\"discount\":\"\"},\"group\":{\"id\":0,\"status\":1,\"accountAmount\":0,\"mainRoom\":false,\"rules\":{\"accommodation\":false,\"feeSpa\":false,\"bed\":false,\"board\":false}},\"accommodationDetails\":\"Uby\",\"pricePlan\":\"Pla\",\"note\":\"\",\"lock\":false,\"statusDeposit\":\"P\",\"advanceAt\":\"2025-09-04\",\"statusPreparation\":10,\"exclamationmark\":\"\",\"createdAt\":\"2025-08-30 20:59:17\",\"createdBy\":149,\"IODeparturedAt\":\" 00:00:00\",\"IODeparturedBy\":0,\"reserve\":\"\",\"memo\":\"\\\"Double - Standard with bath\\\" \\/ 230,52 EUR \\/ 25,000 exchange rate\",\"bail\":\"0.00\",\"connection\":0,\"formLease\":\"\",\"bedGroup\":0,\"inoperative\":\"\",\"externalNumber\":1,\"intakeId\":103,\"segmentId\":0,\"eventTemplate\":false,\"eventStartedAt\":null,\"room\":{\"id\":\"105\",\"status\":\"\",\"sort\":1105,\"category\":\"Dvoul\\u016f\\u017ekov\\u00fd pokoj\",\"typeId\":\"DBL\",\"bedCount\":2,\"extrabedCount\":1,\"floor\":1,\"block\":\"N\",\"door1\":\"\",\"door2\":\"\",\"door3\":\"\",\"door4\":\"\",\"door5\":\"\",\"color\":\"\"},\"guests\":[{\"account\":92897,\"status\":\"R\",\"guestNumber\":1,\"guestName\":\"Miskova Radka\",\"guestBornName\":\"\",\"address\":{\"street\":\"Smrcna c.ev. 158\",\"postcode\":\"58801\",\"place\":\"Smr\\u010dn\\u00e1\",\"country\":{\"name\":\"\\u010cesk\\u00e1 republika\",\"alpha2\":\"CZ\",\"alpha3\":\"CZE\"}},\"birthdate\":\"\",\"birthNumber\":0,\"age\":0,\"personalDocument\":\"\",\"typeDocument\":\"\",\"fee\":{\"spa\":true,\"bed\":false},\"price\":\"0.00\",\"breakfast\":\"N\",\"arrivedAt\":\" \",\"arrivalScheduledAt\":\"\",\"departuredAt\":\" \",\"departureScheduledAt\":\"\",\"createdAt\":\"2025-08-30 20:59:17\",\"createdBy\":149,\"updatedAt\":\" \",\"updatedBy\":0,\"IODeparturedAt\":\" 00:00:00\",\"IODeparturedBy\":0,\"category\":0,\"reserve\":\"\",\"memo\":null,\"idKeyId\":\"\",\"extrabed\":\"N\",\"diet\":0,\"lockedPricePlan\":\"L\",\"activeIdKey\":false,\"accommodatedRelation\":\"\",\"gender\":\"\",\"bail\":\"0.00\",\"discount\":0,\"typeUserId\":\"\",\"groupUserId\":\"\",\"discountCard\":\"\",\"package\":\"\",\"guestPricelistId\":22,\"guestPricelistFix\":\"N\",\"toGroup\":false,\"conversionToEuros\":\"\",\"externalNumber\":0,\"clientId\":39958,\"reportForeignPolice\":\"\",\"event\":{\"advance\":\"0.00\",\"storno\":\"\",\"groupId\":0,\"reservationId\":0},\"extends\":{\"account\":92897,\"guestNumber\":1,\"purposeStay\":\"\",\"licensePlate\":\"\",\"placeBirth\":\"\",\"citizenship\":\"\",\"visa\":\"\",\"visaLengthDays\":0,\"visaIssuedWhere\":\"\",\"crossingRoad\":\"\",\"arrivedAt\":\"2025-09-08\",\"employer\":\"\",\"note\":\"\",\"phone1\":\"+420 607 981 298\",\"phone2\":\"\",\"phone3\":\"\",\"fax\":\"\",\"email\":\"rmisko.969274@guest.booking.com\",\"profession\":\"\",\"countDays\":0,\"fullLastname\":\"\",\"fullFirstname\":\"\",\"newsletter\":false,\"gdprEndAt\":\"2025-09-08\"}},{\"account\":92897,\"status\":\"R\",\"guestNumber\":2,\"guestName\":\"Miskova Radka\",\"guestBornName\":\"\",\"address\":{\"street\":\"\",\"postcode\":\"\",\"place\":\"\",\"country\":{\"name\":\"\\u010cesk\\u00e1 republika\",\"alpha2\":\"CZ\",\"alpha3\":\"CZE\"}},\"birthdate\":\"\",\"birthNumber\":0,\"age\":0,\"personalDocument\":\"\",\"typeDocument\":\"\",\"fee\":{\"spa\":true,\"bed\":false},\"price\":\"0.00\",\"breakfast\":\"N\",\"arrivedAt\":\" \",\"arrivalScheduledAt\":\"\",\"departuredAt\":\" \",\"departureScheduledAt\":\"\",\"createdAt\":\"2025-08-30 20:59:17\",\"createdBy\":149,\"updatedAt\":\" \",\"updatedBy\":0,\"IODeparturedAt\":\" 00:00:00\",\"IODeparturedBy\":0,\"category\":0,\"reserve\":\"\",\"memo\":null,\"idKeyId\":\"\",\"extrabed\":\"N\",\"diet\":0,\"lockedPricePlan\":\"\",\"activeIdKey\":false,\"accommodatedRelation\":\"\",\"gender\":\"\",\"bail\":\"0.00\",\"discount\":0,\"typeUserId\":\"\",\"groupUserId\":\"\",\"discountCard\":\"\",\"package\":\"\",\"guestPricelistId\":22,\"guestPricelistFix\":\"N\",\"toGroup\":false,\"conversionToEuros\":\"\",\"externalNumber\":0,\"clientId\":0,\"reportForeignPolice\":\"\",\"event\":{\"advance\":\"0.00\",\"storno\":\"\",\"groupId\":0,\"reservationId\":0},\"extends\":{\"account\":92897,\"guestNumber\":2,\"purposeStay\":\"\",\"licensePlate\":\"\",\"placeBirth\":\"\",\"citizenship\":\"\",\"visa\":\"\",\"visaLengthDays\":0,\"visaIssuedWhere\":\"\",\"crossingRoad\":\"\",\"arrivedAt\":\"2025-09-08\",\"employer\":\"\",\"note\":\"\",\"phone1\":\"+420 607 981 298\",\"phone2\":\"\",\"phone3\":\"\",\"fax\":\"\",\"email\":\"rmisko.969274@guest.booking.com\",\"profession\":\"\",\"countDays\":0,\"fullLastname\":\"\",\"fullFirstname\":\"\",\"newsletter\":false,\"gdprEndAt\":\"2025-09-08\"}}],\"items\":[{\"id\":100,\"sort\":0,\"name\":\"Ubytov\\u00e1n\\u00ed\",\"unit\":{\"days\":2,\"count\":\"1.00\",\"price\":2881.5},\"amount\":5763,\"vatPercent\":\"12.0\",\"note\":\"\",\"accountId\":92897,\"guestNumber\":1,\"reservationId\":0,\"packageId\":0,\"perGroup\":false,\"receiptId\":0},{\"id\":190,\"sort\":0,\"name\":\"Poplatek obci\",\"unit\":{\"days\":2,\"count\":\"1.00\",\"price\":\"20.00\"},\"amount\":40,\"vatPercent\":\"0.0\",\"note\":\"\",\"accountId\":92897,\"guestNumber\":1,\"reservationId\":0,\"packageId\":0,\"perGroup\":false,\"receiptId\":0},{\"id\":100,\"sort\":0,\"name\":\"Ubytov\\u00e1n\\u00ed\",\"unit\":{\"days\":0,\"count\":\"1.00\",\"price\":0},\"amount\":0,\"vatPercent\":\"12.0\",\"note\":\"penze v cen\\u011b\",\"accountId\":0,\"guestNumber\":1,\"reservationId\":0,\"packageId\":0,\"perGroup\":false,\"receiptId\":0},{\"id\":210,\"sort\":0,\"name\":\"Sn\\u00eddan\\u011b\",\"unit\":{\"days\":4,\"count\":\"1.00\",\"price\":0},\"amount\":0,\"vatPercent\":\"12.0\",\"note\":\"dot\\u00ed\\u017een\\u00ed\",\"accountId\":92897,\"guestNumber\":1,\"reservationId\":0,\"packageId\":0,\"perGroup\":false,\"receiptId\":0},{\"id\":190,\"sort\":0,\"name\":\"Poplatek obci\",\"unit\":{\"days\":2,\"count\":\"1.00\",\"price\":\"20.00\"},\"amount\":40,\"vatPercent\":\"0.0\",\"note\":\"\",\"accountId\":92897,\"guestNumber\":2,\"reservationId\":0,\"packageId\":0,\"perGroup\":false,\"receiptId\":0},{\"id\":902,\"sort\":1032912,\"name\":\"Z\\u00e1loha 12%\",\"unit\":{\"days\":0,\"count\":\"1.00\",\"price\":\"5763.00\"},\"amount\":\"5763.00\",\"vatPercent\":\"12.0\",\"note\":\"Z\\u00e1loha REC0032912\",\"accountId\":92897,\"guestNumber\":1,\"reservationId\":26687,\"packageId\":0,\"perGroup\":false,\"receiptId\":0}],\"receipts\":[],\"dailyServices\":[],\"reservation\":{\"id\":26687,\"mode\":\"R\",\"group\":0,\"name\":\"Miskova Radka\",\"email\":\"rmisko.969274@guest.booking.com\",\"pincode\":2144,\"external\":{\"number\":45899874501458,\"voucherId\":\"S9EL5I\",\"voucher2Id\":\"5232031451\"},\"orderNumber\":\"S9EL5I\",\"amount\":{\"accommodation\":\"5843.00\",\"board\":\"0.00\",\"other\":\"0.00\",\"event\":\"0.00\"},\"advance\":{\"date\":\"2025-09-04\",\"amount\":\"5763.00\",\"paid\":\"5763.00\",\"variableSymbol\":\"\",\"calculation\":\"5843.00\",\"percent\":100,\"externalNumber\":0,\"qrPlatba\":\"\"},\"createdAt\":\"2025-08-30 20:59:17\"}}}');

"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.code AS code_5,
  t0.symbol AS symbol_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  currency t0
WHERE
  t0.code = ?
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.code AS code_5, t0.symbol AS symbol_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM currency t0 WHERE t0.code = 'CZK' 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.code AS code_5,
  t0.symbol AS symbol_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  currency t0
WHERE
  t0.code = ?
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.code AS code_5, t0.symbol AS symbol_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM currency t0 WHERE t0.code = 'CZK' 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.code AS code_5,
  t0.symbol AS symbol_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  currency t0
WHERE
  t0.code = ?
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.code AS code_5, t0.symbol AS symbol_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM currency t0 WHERE t0.code = 'CZK' 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
  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.code AS code_5,
  t0.symbol AS symbol_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  currency t0
WHERE
  t0.code = ?
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.code AS code_5, t0.symbol AS symbol_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM currency t0 WHERE t0.code = 'CZK' 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.code AS code_5,
  t0.symbol AS symbol_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  currency t0
WHERE
  t0.code = ?
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.code AS code_5, t0.symbol AS symbol_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM currency t0 WHERE t0.code = 'CZK' 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.code AS code_5,
  t0.symbol AS symbol_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  currency t0
WHERE
  t0.code = ?
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.code AS code_5, t0.symbol AS symbol_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM currency t0 WHERE t0.code = 'CZK' 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.is_paid AS is_paid_4,
  t0.pay_date AS pay_date_5,
  t0.paid_date AS paid_date_6,
  t0.additional_info AS additional_info_7,
  t0.note AS note_8,
  t0.email AS email_9,
  t0.variable_symbol AS variable_symbol_10,
  t0.number AS number_11,
  t0.is_deposite AS is_deposite_12,
  t0.is_partial_paid AS is_partial_paid_13,
  t0.total_paid AS total_paid_14,
  t0.external_identifier AS external_identifier_15,
  t0.external_id AS external_id_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.contract_item_id AS contract_item_id_20,
  t0.currency_id AS currency_id_21,
  t0.property_id AS property_id_22,
  t0.guest_id AS guest_id_23,
  t0.contract_id AS contract_id_24,
  t0.client_id AS client_id_25,
  t0.company_id AS company_id_26,
  t0.total_price_id AS total_price_id_27
FROM
  payment 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.is_paid AS is_paid_4, t0.pay_date AS pay_date_5, t0.paid_date AS paid_date_6, t0.additional_info AS additional_info_7, t0.note AS note_8, t0.email AS email_9, t0.variable_symbol AS variable_symbol_10, t0.number AS number_11, t0.is_deposite AS is_deposite_12, t0.is_partial_paid AS is_partial_paid_13, t0.total_paid AS total_paid_14, t0.external_identifier AS external_identifier_15, t0.external_id AS external_id_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.contract_item_id AS contract_item_id_20, t0.currency_id AS currency_id_21, t0.property_id AS property_id_22, t0.guest_id AS guest_id_23, t0.contract_id AS contract_id_24, t0.client_id AS client_id_25, t0.company_id AS company_id_26, t0.total_price_id AS total_price_id_27 FROM payment t0 WHERE t0.external_identifier = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_92897' 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.code AS code_5,
  t0.symbol AS symbol_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  currency t0
WHERE
  t0.code = ?
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.code AS code_5, t0.symbol AS symbol_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM currency t0 WHERE t0.code = 'CZK' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.with_vat AS with_vat_2,
  t0.without_vat AS without_vat_3,
  t0.external_identifier AS external_identifier_4,
  t0.external_id AS external_id_5,
  t0.tax_rate_id AS tax_rate_id_6,
  t0.currency_id AS currency_id_7
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.with_vat AS with_vat_2, t0.without_vat AS without_vat_3, t0.external_identifier AS external_identifier_4, t0.external_id AS external_id_5, t0.tax_rate_id AS tax_rate_id_6, t0.currency_id AS currency_id_7 FROM price t0 WHERE t0.id = 100149;

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.external_identifier AS external_identifier_5,
  t0.value AS value_6,
  t0.external_id AS external_id_7,
  t0.identifier AS identifier_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.client_id AS client_id_11,
  t0.property_id AS property_id_12
FROM
  tax_rate 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.external_identifier AS external_identifier_5, t0.value AS value_6, t0.external_id AS external_id_7, t0.identifier AS identifier_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.client_id AS client_id_11, t0.property_id AS property_id_12 FROM tax_rate t0 WHERE t0.id = 219;