Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 29
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• Serializer
• Configuration

Query Metrics

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

[
  634756
]

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

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_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.room_id AS room_id_20 FROM checkin c0_ WHERE c0_.building_id = ? AND c0_.check_out_date = ?

[
  "197396"
  "2025-08-19"
]

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_.created_at AS created_at_18,
  c0_.updated_at AS updated_at_19,
  c0_.room_id AS room_id_20
FROM
  checkin c0_
WHERE
  c0_.building_id = ?
  AND c0_.check_out_date = ?

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_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.room_id AS room_id_20 FROM checkin c0_ WHERE c0_.building_id = '197396' AND c0_.check_out_date = '2025-08-19';

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

[
  "checkin_api"
]

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;