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
  e0_.id AS id_0,
  e0_.created_at AS created_at_1,
  e0_.updated_at AS updated_at_2,
  e0_.from_email AS from_email_3,
  e0_.from_name AS from_name_4,
  e0_.subject AS subject_5,
  e0_.text AS text_6,
  e0_.html AS html_7,
  e0_.recipient AS recipient_8,
  e0_.is_sent AS is_sent_9,
  e0_.sent_at AS sent_at_10,
  e0_.identifier AS identifier_11,
  e0_.created_by_id AS created_by_id_12,
  e0_.updated_by_id AS updated_by_id_13,
  e0_.smtp_settings_id AS smtp_settings_id_14
FROM
  email e0_
  INNER JOIN smtpsettings s1_ ON e0_.smtp_settings_id = s1_.id
WHERE
  e0_.is_sent = ?
  AND s1_.sending_emails = ?
ORDER BY
  e0_.created_at ASC
LIMIT
  300

SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.from_email AS from_email_3, e0_.from_name AS from_name_4, e0_.subject AS subject_5, e0_.text AS text_6, e0_.html AS html_7, e0_.recipient AS recipient_8, e0_.is_sent AS is_sent_9, e0_.sent_at AS sent_at_10, e0_.identifier AS identifier_11, e0_.created_by_id AS created_by_id_12, e0_.updated_by_id AS updated_by_id_13, e0_.smtp_settings_id AS smtp_settings_id_14 FROM email e0_ INNER JOIN smtpsettings s1_ ON e0_.smtp_settings_id = s1_.id WHERE e0_.is_sent = 0 AND s1_.sending_emails = 1 ORDER BY e0_.created_at ASC LIMIT 300;