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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.referer AS referer_4,
  t0.embebed AS embebed_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.email AS email_8,
  t0.officeId AS officeId_9,
  t0.phonesContact AS phonesContact_10,
  t0.agency_id AS agency_id_11
FROM
  whitemark t0
WHERE
  t0.agency_id = ?
  AND t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.referer AS referer_4, t0.embebed AS embebed_5, t0.phone AS phone_6, t0.address AS address_7, t0.email AS email_8, t0.officeId AS officeId_9, t0.phonesContact AS phonesContact_10, t0.agency_id AS agency_id_11 FROM whitemark t0 WHERE t0.agency_id = 152 AND t0.url = '' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.wsUrl AS wsUrl_2,
  t0.urlType AS urlType_3,
  t0.type AS type_4,
  t0.isActive AS isActive_5,
  t0.agency_id AS agency_id_6,
  t0.provider_id AS provider_id_7
FROM
  config_hotel_agency t0
WHERE
  t0.agency_id = ?

SELECT t0.id AS id_1, t0.wsUrl AS wsUrl_2, t0.urlType AS urlType_3, t0.type AS type_4, t0.isActive AS isActive_5, t0.agency_id AS agency_id_6, t0.provider_id AS provider_id_7 FROM config_hotel_agency t0 WHERE t0.agency_id = 152;

SELECT
  t0.id AS id_1,
  t0.wsUrl AS wsUrl_2,
  t0.message AS message_3,
  t0.officeId AS officeId_4,
  t0.externalId AS externalId_5,
  t0.preference AS preference_6,
  t0.isActive AS isActive_7,
  t0.maxTime AS maxTime_8,
  t0.hasCombination AS hasCombination_9,
  t0.errorCount AS errorCount_10,
  t0.errorDatetime AS errorDatetime_11,
  t0.provider_id AS provider_id_12,
  t0.agency_id AS agency_id_13
FROM
  config_flight_agency t0
WHERE
  t0.agency_id = ?

SELECT t0.id AS id_1, t0.wsUrl AS wsUrl_2, t0.message AS message_3, t0.officeId AS officeId_4, t0.externalId AS externalId_5, t0.preference AS preference_6, t0.isActive AS isActive_7, t0.maxTime AS maxTime_8, t0.hasCombination AS hasCombination_9, t0.errorCount AS errorCount_10, t0.errorDatetime AS errorDatetime_11, t0.provider_id AS provider_id_12, t0.agency_id AS agency_id_13 FROM config_flight_agency t0 WHERE t0.agency_id = 152;

SELECT
  s0_.id AS id_0,
  s0_.url AS url_1,
  s0_.title AS title_2,
  s0_.description AS description_3,
  s0_.metatitle AS metatitle_4,
  s0_.keywords AS keywords_5,
  s0_.creationDate AS creationDate_6,
  s0_.updateDate AS updateDate_7,
  s0_.ipAddress AS ipAddress_8,
  s0_.agency_id AS agency_id_9,
  s0_.customer_id AS customer_id_10
FROM
  seo_header s0_
WHERE
  s0_.url = ?
  AND (
    s0_.agency_id = ?
    OR s0_.agency_id IS NULL
  )
LIMIT
  1

SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.title AS title_2, s0_.description AS description_3, s0_.metatitle AS metatitle_4, s0_.keywords AS keywords_5, s0_.creationDate AS creationDate_6, s0_.updateDate AS updateDate_7, s0_.ipAddress AS ipAddress_8, s0_.agency_id AS agency_id_9, s0_.customer_id AS customer_id_10 FROM seo_header s0_ WHERE s0_.url = 'contenidos/tarjeta-debito-internacional' AND (s0_.agency_id = 152 OR s0_.agency_id IS NULL) LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.keywords AS keywords_2,
  c0_.url AS url_3,
  c0_.description AS description_4,
  c0_.text AS text_5,
  c0_.publicationStartDate AS publicationStartDate_6,
  c0_.publicationEndDate AS publicationEndDate_7,
  c0_.creationDate AS creationDate_8,
  c0_.isActive AS isActive_9,
  c0_.user_id AS user_id_10,
  c0_.agency_id AS agency_id_11
FROM
  content c0_
WHERE
  (c0_.agency_id = ?)
  AND c0_.url = ?

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.keywords AS keywords_2, c0_.url AS url_3, c0_.description AS description_4, c0_.text AS text_5, c0_.publicationStartDate AS publicationStartDate_6, c0_.publicationEndDate AS publicationEndDate_7, c0_.creationDate AS creationDate_8, c0_.isActive AS isActive_9, c0_.user_id AS user_id_10, c0_.agency_id AS agency_id_11 FROM content c0_ WHERE (c0_.agency_id = 152) AND c0_.url = 'tarjeta-debito-internacional';

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.name AS name_3,
  t0.content AS content_4,
  t0.agency_id AS agency_id_5
FROM
  seo_index t0
WHERE
  t0.agency_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.name AS name_3, t0.content AS content_4, t0.agency_id AS agency_id_5 FROM seo_index t0 WHERE t0.agency_id = 152;

SELECT
  p0_.id AS id_0,
  p0_.siteCode AS siteCode_1,
  p0_.tranKey AS tranKey_2,
  p0_.isActive AS isActive_3,
  p0_.isTest AS isTest_4,
  p0_.user AS user_5,
  p0_.password AS password_6,
  p0_.currency AS currency_7,
  p0_.testEndpoint AS testEndpoint_8,
  p0_.productionEndpoint AS productionEndpoint_9,
  p0_.siteId AS siteId_10,
  p0_.placeToPayRest AS placeToPayRest_11,
  p1_.id AS id_12,
  p1_.code AS code_13,
  p1_.description AS description_14,
  p1_.isActive AS isActive_15,
  p0_.payment_method_id AS payment_method_id_16,
  p0_.agency_id AS agency_id_17
FROM
  payment_method_agency p0_
  INNER JOIN payment_method p1_ ON p0_.payment_method_id = p1_.id
WHERE
  p0_.agency_id = ?
  AND p0_.isActive = ?
  AND p1_.code LIKE '%world%'

SELECT p0_.id AS id_0, p0_.siteCode AS siteCode_1, p0_.tranKey AS tranKey_2, p0_.isActive AS isActive_3, p0_.isTest AS isTest_4, p0_.user AS user_5, p0_.password AS password_6, p0_.currency AS currency_7, p0_.testEndpoint AS testEndpoint_8, p0_.productionEndpoint AS productionEndpoint_9, p0_.siteId AS siteId_10, p0_.placeToPayRest AS placeToPayRest_11, p1_.id AS id_12, p1_.code AS code_13, p1_.description AS description_14, p1_.isActive AS isActive_15, p0_.payment_method_id AS payment_method_id_16, p0_.agency_id AS agency_id_17 FROM payment_method_agency p0_ INNER JOIN payment_method p1_ ON p0_.payment_method_id = p1_.id WHERE p0_.agency_id = 152 AND p0_.isActive = 1 AND p1_.code LIKE '%world%';

SELECT
  hi.saleRate,
  hi.finantialRate,
  hi.conversionRate,
  hi.date
FROM
  historical_rate hi
ORDER BY
  hi.date DESC
LIMIT
  1

SELECT hi.saleRate, hi.finantialRate, hi.conversionRate, hi.date FROM historical_rate hi ORDER BY hi.date DESC LIMIT 1 ;

SELECT
  t0.id AS id_1,
  t0.startDate AS startDate_2,
  t0.endDate AS endDate_3,
  t0.home_promo_list_id AS home_promo_list_id_4
FROM
  home_promo_time t0
WHERE
  t0.home_promo_list_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.startDate AS startDate_2, t0.endDate AS endDate_3, t0.home_promo_list_id AS home_promo_list_id_4 FROM home_promo_time t0 WHERE t0.home_promo_list_id = 2 LIMIT 1;