Symfony Profiler

SELECT
  t0.expiration AS expiration_1,
  t0.ready AS ready_2,
  t0.error AS error_3,
  t0.id AS id_4,
  t0.uid AS uid_5,
  t0.createdAt AS createdAt_6,
  t0.updatedAt AS updatedAt_7,
  t0.touchedAt AS touchedAt_8,
  t0.data_privateKey AS data_privateKey_9,
  t0.data_intermediateCertificates AS data_intermediateCertificates_10,
  t0.data_certficate AS data_certficate_11,
  t0.data_certificateSigningRequest AS data_certificateSigningRequest_12,
  t0.domain AS domain_13,
  t0.tenant AS tenant_14,
  t0.createdBy AS createdBy_15,
  t0.updatedBy AS updatedBy_16,
  t0.touchedBy AS touchedBy_17,
  t0._discr,
  t0.csr_email AS csr_email_18,
  t0.csr_organization AS csr_organization_19,
  t0.csr_unit AS csr_unit_20,
  t0.csr_country AS csr_country_21,
  t0.csr_province AS csr_province_22,
  t0.csr_locality AS csr_locality_23,
  t0.le_challenge AS le_challenge_24,
  t0.le_token AS le_token_25,
  t0.le_payload AS le_payload_26
FROM
  cms__domain__ssl_certificate t0
WHERE
  t0.id = ?
  AND t0._discr IN ('custom', 'lets-encrypt')

SELECT t0.expiration AS expiration_1, t0.ready AS ready_2, t0.error AS error_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.data_privateKey AS data_privateKey_9, t0.data_intermediateCertificates AS data_intermediateCertificates_10, t0.data_certficate AS data_certficate_11, t0.data_certificateSigningRequest AS data_certificateSigningRequest_12, t0.domain AS domain_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17, t0._discr, t0.csr_email AS csr_email_18, t0.csr_organization AS csr_organization_19, t0.csr_unit AS csr_unit_20, t0.csr_country AS csr_country_21, t0.csr_province AS csr_province_22, t0.csr_locality AS csr_locality_23, t0.le_challenge AS le_challenge_24, t0.le_token AS le_token_25, t0.le_payload AS le_payload_26 FROM cms__domain__ssl_certificate t0 WHERE t0.id = 5 AND t0._discr IN ('custom', 'lets-encrypt');

SELECT
  c0_.name AS name_0,
  c0_.httpsUpgrade AS httpsUpgrade_1,
  c0_.id AS id_2,
  c0_.uid AS uid_3,
  c0_.createdAt AS createdAt_4,
  c0_.updatedAt AS updatedAt_5,
  c0_.touchedAt AS touchedAt_6,
  c0_.redirection_enabled AS redirection_enabled_7,
  c0_.redirection_host AS redirection_host_8,
  c0_.redirection_path AS redirection_path_9,
  c0_.redirection_appendPath AS redirection_appendPath_10,
  c0_.redirection_query AS redirection_query_11,
  c0_.redirection_appendQuery AS redirection_appendQuery_12,
  c0_.redirection_code AS redirection_code_13,
  c0_.apex AS apex_14,
  c0_.certificate AS certificate_15,
  c0_.tenant AS tenant_16,
  c0_.createdBy AS createdBy_17,
  c0_.updatedBy AS updatedBy_18,
  c0_.touchedBy AS touchedBy_19
FROM
  cms__domain__domain c0_
  LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id
WHERE
  (
    c0_.name = ?
    AND c1_.host = ?
  )
  OR (
    c0_.name = ?
    AND c1_.host = ?
  )
LIMIT
  1

SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.redirection_enabled AS redirection_enabled_7, c0_.redirection_host AS redirection_host_8, c0_.redirection_path AS redirection_path_9, c0_.redirection_appendPath AS redirection_appendPath_10, c0_.redirection_query AS redirection_query_11, c0_.redirection_appendQuery AS redirection_appendQuery_12, c0_.redirection_code AS redirection_code_13, c0_.apex AS apex_14, c0_.certificate AS certificate_15, c0_.tenant AS tenant_16, c0_.createdBy AS createdBy_17, c0_.updatedBy AS updatedBy_18, c0_.touchedBy AS touchedBy_19 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id WHERE (c0_.name = '' AND c1_.host = 'campusstein.com') OR (c0_.name = 'campusstein' AND c1_.host = 'com') LIMIT 1;

SELECT
  t0.host AS host_1,
  t0.id AS id_2,
  t0.uid AS uid_3,
  t0.createdAt AS createdAt_4,
  t0.updatedAt AS updatedAt_5,
  t0.touchedAt AS touchedAt_6,
  t0.verification_code AS verification_code_7,
  t0.verification_date AS verification_date_8,
  t0.tenant AS tenant_9,
  t0.createdBy AS createdBy_10,
  t0.updatedBy AS updatedBy_11,
  t0.touchedBy AS touchedBy_12
FROM
  cms__domain__apex t0
WHERE
  t0.id = ?
  AND (
    (t0.tenant = 7)
  )

SELECT t0.host AS host_1, t0.id AS id_2, t0.uid AS uid_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.touchedAt AS touchedAt_6, t0.verification_code AS verification_code_7, t0.verification_date AS verification_date_8, t0.tenant AS tenant_9, t0.createdBy AS createdBy_10, t0.updatedBy AS updatedBy_11, t0.touchedBy AS touchedBy_12 FROM cms__domain__apex t0 WHERE t0.id = 3 AND ((t0.tenant = 7));