Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.url AS url_3,
  t0.client_id AS client_id_4
FROM
  client_url t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.url AS url_3, t0.client_id AS client_id_4 FROM client_url t0 WHERE t0.url = 'hub-dev.czech-kiosk.com' 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.created_by_id AS created_by_id_6,
  t0.updated_by_id AS updated_by_id_7,
  t0.type_id AS type_id_8,
  t0.contact_address_id AS contact_address_id_9,
  t0.default_pmssettings_id AS default_pmssettings_id_10,
  t0.default_payment_gateway_settings_id AS default_payment_gateway_settings_id_11,
  t0.default_smtpsettings_id AS default_smtpsettings_id_12
FROM
  client 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.identifier AS identifier_4, t0.name AS name_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.type_id AS type_id_8, t0.contact_address_id AS contact_address_id_9, t0.default_pmssettings_id AS default_pmssettings_id_10, t0.default_payment_gateway_settings_id AS default_payment_gateway_settings_id_11, t0.default_smtpsettings_id AS default_smtpsettings_id_12 FROM client t0 WHERE t0.id = 4;

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.client_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.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.client_id = 4;

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

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

SELECT
  s0_.id AS id_0,
  s0_.from_number AS from_number_1,
  s0_.text AS text_2,
  s0_.recipient AS recipient_3,
  s0_.is_sent AS is_sent_4,
  s0_.created_at AS created_at_5,
  s0_.sent_at AS sent_at_6,
  s0_.guid AS guid_7,
  s0_.send_at AS send_at_8,
  s0_.priority AS priority_9,
  s0_.is_sent_to_queue AS is_sent_to_queue_10,
  s0_.sent_to_queue_at AS sent_to_queue_at_11,
  s0_.system_note AS system_note_12
FROM
  sms s0_
WHERE
  s0_.is_sent_to_queue = ?
  AND s0_.send_at <= ?
ORDER BY
  s0_.created_at ASC
LIMIT
  10

SELECT s0_.id AS id_0, s0_.from_number AS from_number_1, s0_.text AS text_2, s0_.recipient AS recipient_3, s0_.is_sent AS is_sent_4, s0_.created_at AS created_at_5, s0_.sent_at AS sent_at_6, s0_.guid AS guid_7, s0_.send_at AS send_at_8, s0_.priority AS priority_9, s0_.is_sent_to_queue AS is_sent_to_queue_10, s0_.sent_to_queue_at AS sent_to_queue_at_11, s0_.system_note AS system_note_12 FROM sms s0_ WHERE s0_.is_sent_to_queue = 0 AND s0_.send_at <= '2025-07-29 13:18:01' ORDER BY s0_.created_at ASC LIMIT 10;