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;

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.arrival_time AS arrival_time_2,
  t0.license_plate AS license_plate_3,
  t0.external_identifier AS external_identifier_4,
  t0.external_id AS external_id_5,
  t0.contract_item_id AS contract_item_id_6,
  t0.guest_id AS guest_id_7
FROM
  contract_item_guest t0
WHERE
  t0.external_identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.arrival_time AS arrival_time_2, t0.license_plate AS license_plate_3, t0.external_identifier AS external_identifier_4, t0.external_id AS external_id_5, t0.contract_item_id AS contract_item_id_6, t0.guest_id AS guest_id_7 FROM contract_item_guest t0 WHERE t0.external_identifier = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_92897_92897_1' 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;

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

UPDATE
  price
SET
  with_vat = ?,
  without_vat = ?
WHERE
  id = ?

UPDATE price SET with_vat = '80', without_vat = '80' WHERE id = 100145;

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.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 = 32433;

UPDATE
  contract_item_guest
SET
  contract_item_id = ?
WHERE
  id = ?

UPDATE contract_item_guest SET contract_item_id = NULL WHERE id = 27661;

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_1' LIMIT 1;

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 = 46943;

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.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.external_identifier = ?
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.external_identifier = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_26687_92897_price' LIMIT 1;

UPDATE
  contract_item
SET
  start = ?,
  end = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE contract_item SET start = '2025-09-08 00:00:00', end = '2025-09-10 00:00:00', updated_at = '2025-09-08 18:01:02' WHERE id = 17107;

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;

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.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.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.external_identifier = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_0' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.arrival_time AS arrival_time_2,
  t0.license_plate AS license_plate_3,
  t0.external_identifier AS external_identifier_4,
  t0.external_id AS external_id_5,
  t0.contract_item_id AS contract_item_id_6,
  t0.guest_id AS guest_id_7
FROM
  contract_item_guest t0
WHERE
  t0.contract_item_id = ?

SELECT t0.id AS id_1, t0.arrival_time AS arrival_time_2, t0.license_plate AS license_plate_3, t0.external_identifier AS external_identifier_4, t0.external_id AS external_id_5, t0.contract_item_id AS contract_item_id_6, t0.guest_id AS guest_id_7 FROM contract_item_guest t0 WHERE t0.contract_item_id = 17107;

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;

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;

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.title AS title_2,
  t0.type AS type_3,
  t0.external_identifier AS external_identifier_4,
  t0.external_id AS external_id_5,
  t0.price_id AS price_id_6,
  t0.contract_item_id AS contract_item_id_7
FROM
  price_item t0
WHERE
  t0.contract_item_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.external_identifier AS external_identifier_4, t0.external_id AS external_id_5, t0.price_id AS price_id_6, t0.contract_item_id AS contract_item_id_7 FROM price_item t0 WHERE t0.contract_item_id = 17107;

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_1ef627089e3813dc2fb28d94404e82b6d' 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.description AS description_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
  space_state 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.name AS name_4, t0.description AS description_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 space_state t0 WHERE t0.identifier = 'clean' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.description AS description_4,
  t0.price_without_vat AS price_without_vat_5,
  t0.price_with_vat AS price_with_vat_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.payment_id AS payment_id_12,
  t0.tax_rate_id AS tax_rate_id_13,
  t0.price_id AS price_id_14
FROM
  payment_item t0
WHERE
  t0.payment_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.description AS description_4, t0.price_without_vat AS price_without_vat_5, t0.price_with_vat AS price_with_vat_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.payment_id AS payment_id_12, t0.tax_rate_id AS tax_rate_id_13, t0.price_id AS price_id_14 FROM payment_item t0 WHERE t0.payment_id = 18018;

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.number AS number_5,
  t0.description AS description_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.floor_id AS floor_id_12,
  t0.property_id AS property_id_13,
  t0.category_id AS category_id_14,
  t0.state_id AS state_id_15
FROM
  space 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.name AS name_4, t0.number AS number_5, t0.description AS description_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.floor_id AS floor_id_12, t0.property_id AS property_id_13, t0.category_id AS category_id_14, t0.state_id AS state_id_15 FROM space t0 WHERE t0.external_identifier = 'f59b1fa4-790e-4ae9-a451-3cb7e4fea806_105' 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;