Symfony Profiler

(
  SELECT
    p1.*
  FROM
    parameter p1
  WHERE
    p1.agency_id = ?
)
UNION
  (
    SELECT
      p1.*
    FROM
      parameter p1
    WHERE
      (
        p1.name NOT IN (
          SELECT
            p2.name
          FROM
            parameter p2
          WHERE
            p2.agency_id = ?
        )
        AND p1.agency_id IS NULL
      )
  )

(SELECT p1.* FROM parameter p1
                    WHERE p1.agency_id = 152)
                    UNION
                    (SELECT p1.* FROM parameter p1
                    WHERE (p1.name NOT IN (SELECT p2.name FROM parameter p2
                    WHERE p2.agency_id = 152)
                    AND p1.agency_id IS NULL))
                ;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.description AS description_4,
  t0.agency_id AS agency_id_5
FROM
  parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.agency_id AS agency_id_5 FROM parameter t0 WHERE t0.name = 'aviatur_service_token' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.externalId AS externalId_2,
  t0.officeId AS officeId_3,
  t0.name AS name_4,
  t0.nit AS nit_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.mailContact AS mailContact_8,
  t0.mailBooking AS mailBooking_9,
  t0.mailOperations AS mailOperations_10,
  t0.mailVouchers AS mailVouchers_11,
  t0.domain AS domain_12,
  t0.domainSecure AS domainSecure_13,
  t0.domainOld AS domainOld_14,
  t0.urlRoute AS urlRoute_15,
  t0.idClientFacebook AS idClientFacebook_16,
  t0.idClientGoogle AS idClientGoogle_17,
  t0.customPort AS customPort_18,
  t0.phonesContact AS phonesContact_19,
  t0.socialmedia AS socialmedia_20,
  t0.assets_folder AS assets_folder_21,
  t0.twigFlux AS twigFlux_22,
  t0.customer_id AS customer_id_23
FROM
  agency t0
WHERE
  t0.domainSecure IN (?, ?)
LIMIT
  1

SELECT t0.id AS id_1, t0.externalId AS externalId_2, t0.officeId AS officeId_3, t0.name AS name_4, t0.nit AS nit_5, t0.phone AS phone_6, t0.address AS address_7, t0.mailContact AS mailContact_8, t0.mailBooking AS mailBooking_9, t0.mailOperations AS mailOperations_10, t0.mailVouchers AS mailVouchers_11, t0.domain AS domain_12, t0.domainSecure AS domainSecure_13, t0.domainOld AS domainOld_14, t0.urlRoute AS urlRoute_15, t0.idClientFacebook AS idClientFacebook_16, t0.idClientGoogle AS idClientGoogle_17, t0.customPort AS customPort_18, t0.phonesContact AS phonesContact_19, t0.socialmedia AS socialmedia_20, t0.assets_folder AS assets_folder_21, t0.twigFlux AS twigFlux_22, t0.customer_id AS customer_id_23 FROM agency t0 WHERE t0.domainSecure IN ('legacy-qa.grupoaviatur.com', 'legacy-qa.grupoaviatur.com') LIMIT 1;