Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.room_id AS room_id_2,
  t0.guest_id AS guest_id_3
FROM
  guest_room t0
WHERE
  t0.guest_id = ?

SELECT t0.id AS id_1, t0.room_id AS room_id_2, t0.guest_id AS guest_id_3 FROM guest_room t0 WHERE t0.guest_id = 1136557;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.expires_at AS expires_at_3,
  t0.created_at AS created_at_4,
  t0.is_active AS is_active_5,
  t0.checkin_id AS checkin_id_6
FROM
  authenticated_tokens t0
WHERE
  t0.checkin_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.created_at AS created_at_4, t0.is_active AS is_active_5, t0.checkin_id AS checkin_id_6 FROM authenticated_tokens t0 WHERE t0.checkin_id = 827462;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.first_url AS first_url_3,
  t0.second_url AS second_url_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.guest_id AS guest_id_8,
  t0.document_validation_id AS document_validation_id_9
FROM
  document t0
WHERE
  t0.guest_id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.first_url AS first_url_3, t0.second_url AS second_url_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.guest_id AS guest_id_8, t0.document_validation_id AS document_validation_id_9 FROM document t0 WHERE t0.guest_id = 1136557;

SELECT
  t0.id AS id_1,
  t0.room_id AS room_id_2,
  t0.sku AS sku_3,
  t0.room_name AS room_name_4,
  t0.max_guests AS max_guests_5,
  t0.is_private AS is_private_6,
  t0.room_type_id AS room_type_id_7,
  t0.building_id AS building_id_8,
  t0.description AS description_9,
  t0.external_id AS external_id_10,
  t0.housekeeping_status AS housekeeping_status_11,
  t0.room_name_gatekeeper AS room_name_gatekeeper_12
FROM
  room t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.room_id AS room_id_2, t0.sku AS sku_3, t0.room_name AS room_name_4, t0.max_guests AS max_guests_5, t0.is_private AS is_private_6, t0.room_type_id AS room_type_id_7, t0.building_id AS building_id_8, t0.description AS description_9, t0.external_id AS external_id_10, t0.housekeeping_status AS housekeeping_status_11, t0.room_name_gatekeeper AS room_name_gatekeeper_12 FROM room t0 WHERE t0.id = 46705;

SELECT
  t0.id AS id_1,
  t0.cpf AS cpf_2,
  t0.guest_id AS guest_id_3,
  t0.name AS name_4,
  t0.email AS email_5,
  t0.country AS country_6,
  t0.state AS state_7,
  t0.city AS city_8,
  t0.phone AS phone_9,
  t0.main_guest AS main_guest_10,
  t0.building_id AS building_id_11,
  t0.is_child AS is_child_12,
  t0.external_entrance_id AS external_entrance_id_13,
  t0.cerberus_id AS cerberus_id_14,
  t0.status_document AS status_document_15,
  t0.birth_date AS birth_date_16,
  t0.is_gate_system_registered AS is_gate_system_registered_17,
  t0.is_block AS is_block_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.checkin_id AS checkin_id_21
FROM
  guest t0
WHERE
  t0.checkin_id = ?

SELECT t0.id AS id_1, t0.cpf AS cpf_2, t0.guest_id AS guest_id_3, t0.name AS name_4, t0.email AS email_5, t0.country AS country_6, t0.state AS state_7, t0.city AS city_8, t0.phone AS phone_9, t0.main_guest AS main_guest_10, t0.building_id AS building_id_11, t0.is_child AS is_child_12, t0.external_entrance_id AS external_entrance_id_13, t0.cerberus_id AS cerberus_id_14, t0.status_document AS status_document_15, t0.birth_date AS birth_date_16, t0.is_gate_system_registered AS is_gate_system_registered_17, t0.is_block AS is_block_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.checkin_id AS checkin_id_21 FROM guest t0 WHERE t0.checkin_id = 827462;

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.checkin_id AS checkin_id_5
FROM
  checkout t0
WHERE
  t0.checkin_id = ?

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.checkin_id AS checkin_id_5 FROM checkout t0 WHERE t0.checkin_id = 827462;

SELECT
  t0.id AS id_1,
  t0.action AS action_2,
  t0.agent AS agent_3,
  t0.date_time AS date_time_4,
  t0.checkin_id AS checkin_id_5
FROM
  history t0
WHERE
  t0.checkin_id = ?

SELECT t0.id AS id_1, t0.action AS action_2, t0.agent AS agent_3, t0.date_time AS date_time_4, t0.checkin_id AS checkin_id_5 FROM history t0 WHERE t0.checkin_id = 827462;

SELECT
  t0.id AS id_1,
  t0.lighthouse_user_id AS lighthouse_user_id_2,
  t0.status AS status_3,
  t0.motive AS motive_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t7.id AS id_8,
  t7.number AS number_9,
  t7.first_url AS first_url_10,
  t7.second_url AS second_url_11,
  t7.type AS type_12,
  t7.created_at AS created_at_13,
  t7.updated_at AS updated_at_14,
  t7.guest_id AS guest_id_15,
  t7.document_validation_id AS document_validation_id_16
FROM
  document_validation t0
  LEFT JOIN document t7 ON t7.document_validation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lighthouse_user_id AS lighthouse_user_id_2, t0.status AS status_3, t0.motive AS motive_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t7.id AS id_8, t7.number AS number_9, t7.first_url AS first_url_10, t7.second_url AS second_url_11, t7.type AS type_12, t7.created_at AS created_at_13, t7.updated_at AS updated_at_14, t7.guest_id AS guest_id_15, t7.document_validation_id AS document_validation_id_16 FROM document_validation t0 LEFT JOIN document t7 ON t7.document_validation_id = t0.id WHERE t0.id = 2771134;

SELECT
  c0_.id AS id_0,
  c0_.adults AS adults_1,
  c0_.children AS children_2,
  c0_.check_in_date AS check_in_date_3,
  c0_.check_out_date AS check_out_date_4,
  c0_.canceled AS canceled_5,
  c0_.reservation_id AS reservation_id_6,
  c0_.sub_reservation_id AS sub_reservation_id_7,
  c0_.status AS status_8,
  c0_.building_id AS building_id_9,
  c0_.source AS source_10,
  c0_.third_party_identifier AS third_party_identifier_11,
  c0_.external_entrance_id AS external_entrance_id_12,
  c0_.observation AS observation_13,
  c0_.status_concierge AS status_concierge_14,
  c0_.is_vip AS is_vip_15,
  c0_.is_block AS is_block_16,
  c0_.checkin_status AS checkin_status_17,
  c0_.disable_auto_messages AS disable_auto_messages_18,
  c0_.is_immediate_authorization AS is_immediate_authorization_19,
  c0_.created_at AS created_at_20,
  c0_.updated_at AS updated_at_21,
  c0_.room_id AS room_id_22
FROM
  checkin c0_
  INNER JOIN guest g1_ ON (g1_.checkin_id = c0_.id)
WHERE
  c0_.building_id = ?
  AND (
    ? BETWEEN c0_.check_in_date
    AND c0_.check_out_date
  )
  AND c0_.status NOT IN (?, ?, ?, ?)
  AND c0_.status_concierge IS NULL
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, c0_.adults AS adults_1, c0_.children AS children_2, c0_.check_in_date AS check_in_date_3, c0_.check_out_date AS check_out_date_4, c0_.canceled AS canceled_5, c0_.reservation_id AS reservation_id_6, c0_.sub_reservation_id AS sub_reservation_id_7, c0_.status AS status_8, c0_.building_id AS building_id_9, c0_.source AS source_10, c0_.third_party_identifier AS third_party_identifier_11, c0_.external_entrance_id AS external_entrance_id_12, c0_.observation AS observation_13, c0_.status_concierge AS status_concierge_14, c0_.is_vip AS is_vip_15, c0_.is_block AS is_block_16, c0_.checkin_status AS checkin_status_17, c0_.disable_auto_messages AS disable_auto_messages_18, c0_.is_immediate_authorization AS is_immediate_authorization_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.room_id AS room_id_22 FROM checkin c0_ INNER JOIN guest g1_ ON (g1_.checkin_id = c0_.id) WHERE c0_.building_id = '213046' AND ('2026-04-03' BETWEEN c0_.check_in_date AND c0_.check_out_date) AND c0_.status NOT IN ('checked_out', 'canceled', 'not_confirmed', 'no_show') AND c0_.status_concierge IS NULL GROUP BY c0_.id;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.ext_building_id AS ext_building_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.ext_building_id AS ext_building_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM user t0 WHERE t0.username = 'checkin_api' LIMIT 1;