Symfony Profiler

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.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_ath' 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 = ?
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 = 'aval_public_key_auth' 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 = ?
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 = 'aval_public_key_auth' 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.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
  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.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
  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 = '' AND (s0_.agency_id = 152 OR s0_.agency_id IS NULL) LIMIT 1;

(
  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
  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
  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_payment_world_pay' LIMIT 1;

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;

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_aval_redirection' LIMIT 1;

SELECT
  h0_.id AS id_0,
  h0_.startDate AS startDate_1,
  h0_.endDate AS endDate_2,
  h1_.id AS id_3,
  h1_.type AS type_4,
  h1_.conditions AS conditions_5,
  h1_.title AS title_6,
  h1_.subtitle AS subtitle_7,
  h1_.image AS image_8,
  h1_.online AS online_9,
  h0_.home_promo_list_id AS home_promo_list_id_10,
  h1_.agency_id AS agency_id_11
FROM
  home_promo_time h0_
  INNER JOIN home_promo_list h1_ ON h0_.home_promo_list_id = h1_.id
WHERE
  h1_.type = ?

SELECT h0_.id AS id_0, h0_.startDate AS startDate_1, h0_.endDate AS endDate_2, h1_.id AS id_3, h1_.type AS type_4, h1_.conditions AS conditions_5, h1_.title AS title_6, h1_.subtitle AS subtitle_7, h1_.image AS image_8, h1_.online AS online_9, h0_.home_promo_list_id AS home_promo_list_id_10, h1_.agency_id AS agency_id_11 FROM home_promo_time h0_ INNER JOIN home_promo_list h1_ ON h0_.home_promo_list_id = h1_.id WHERE h1_.type = 'black-friday-col';

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_background_home_image' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.route AS route_1,
  p0_.availableSeats AS availableSeats_2,
  p0_.flightType AS flightType_3,
  p0_.params AS params_4,
  p0_.isActive AS isActive_5,
  p0_.creationDate AS creationDate_6,
  p0_.airline_id AS airline_id_7,
  p0_.agency_id AS agency_id_8
FROM
  promo_search_agency p0_
WHERE
  p0_.isActive = ?
  AND p0_.agency_id = ?
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.route AS route_1, p0_.availableSeats AS availableSeats_2, p0_.flightType AS flightType_3, p0_.params AS params_4, p0_.isActive AS isActive_5, p0_.creationDate AS creationDate_6, p0_.airline_id AS airline_id_7, p0_.agency_id AS agency_id_8 FROM promo_search_agency p0_ WHERE p0_.isActive = 1 AND p0_.agency_id = 152 ORDER BY p0_.id DESC;

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 = 'agency_excluded_list_promotional_cards' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.conditions AS conditions_3,
  t0.title AS title_4,
  t0.subtitle AS subtitle_5,
  t0.image AS image_6,
  t0.online AS online_7,
  t8.id AS id_9,
  t8.startDate AS startDate_10,
  t8.endDate AS endDate_11,
  t8.home_promo_list_id AS home_promo_list_id_12,
  t0.agency_id AS agency_id_13
FROM
  home_promo_list t0
  LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id
WHERE
  t0.type = ?
  AND t0.agency_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.conditions AS conditions_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.image AS image_6, t0.online AS online_7, t8.id AS id_9, t8.startDate AS startDate_10, t8.endDate AS endDate_11, t8.home_promo_list_id AS home_promo_list_id_12, t0.agency_id AS agency_id_13 FROM home_promo_list t0 LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id WHERE t0.type = 'main' AND t0.agency_id = 152 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.switch AS switch_3,
  t0.mobile AS mobile_4,
  t0.toUpdate AS toUpdate_5,
  t0.title AS title_6,
  t0.titleSwitch AS titleSwitch_7,
  t0.price AS price_8,
  t0.content AS content_9,
  t0.details AS details_10,
  t0.duration AS duration_11,
  t0.path AS path_12,
  t0.link AS link_13,
  t0.linkSwitch AS linkSwitch_14,
  t0.promoSize AS promoSize_15,
  t0.date AS date_16,
  t0.home_promo_list_id AS home_promo_list_id_17
FROM
  home_promo t0
WHERE
  t0.home_promo_list_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.size AS size_2, t0.switch AS switch_3, t0.mobile AS mobile_4, t0.toUpdate AS toUpdate_5, t0.title AS title_6, t0.titleSwitch AS titleSwitch_7, t0.price AS price_8, t0.content AS content_9, t0.details AS details_10, t0.duration AS duration_11, t0.path AS path_12, t0.link AS link_13, t0.linkSwitch AS linkSwitch_14, t0.promoSize AS promoSize_15, t0.date AS date_16, t0.home_promo_list_id AS home_promo_list_id_17 FROM home_promo t0 WHERE t0.home_promo_list_id = 1 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.conditions AS conditions_3,
  t0.title AS title_4,
  t0.subtitle AS subtitle_5,
  t0.image AS image_6,
  t0.online AS online_7,
  t8.id AS id_9,
  t8.startDate AS startDate_10,
  t8.endDate AS endDate_11,
  t8.home_promo_list_id AS home_promo_list_id_12,
  t0.agency_id AS agency_id_13
FROM
  home_promo_list t0
  LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id
WHERE
  t0.type = ?
  AND t0.agency_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.conditions AS conditions_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.image AS image_6, t0.online AS online_7, t8.id AS id_9, t8.startDate AS startDate_10, t8.endDate AS endDate_11, t8.home_promo_list_id AS home_promo_list_id_12, t0.agency_id AS agency_id_13 FROM home_promo_list t0 LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id WHERE t0.type = 'main-banners' AND t0.agency_id = 152 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.switch AS switch_3,
  t0.mobile AS mobile_4,
  t0.toUpdate AS toUpdate_5,
  t0.title AS title_6,
  t0.titleSwitch AS titleSwitch_7,
  t0.price AS price_8,
  t0.content AS content_9,
  t0.details AS details_10,
  t0.duration AS duration_11,
  t0.path AS path_12,
  t0.link AS link_13,
  t0.linkSwitch AS linkSwitch_14,
  t0.promoSize AS promoSize_15,
  t0.date AS date_16,
  t0.home_promo_list_id AS home_promo_list_id_17
FROM
  home_promo t0
WHERE
  t0.home_promo_list_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.size AS size_2, t0.switch AS switch_3, t0.mobile AS mobile_4, t0.toUpdate AS toUpdate_5, t0.title AS title_6, t0.titleSwitch AS titleSwitch_7, t0.price AS price_8, t0.content AS content_9, t0.details AS details_10, t0.duration AS duration_11, t0.path AS path_12, t0.link AS link_13, t0.linkSwitch AS linkSwitch_14, t0.promoSize AS promoSize_15, t0.date AS date_16, t0.home_promo_list_id AS home_promo_list_id_17 FROM home_promo t0 WHERE t0.home_promo_list_id = 1057 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.conditions AS conditions_3,
  t0.title AS title_4,
  t0.subtitle AS subtitle_5,
  t0.image AS image_6,
  t0.online AS online_7,
  t8.id AS id_9,
  t8.startDate AS startDate_10,
  t8.endDate AS endDate_11,
  t8.home_promo_list_id AS home_promo_list_id_12,
  t0.agency_id AS agency_id_13
FROM
  home_promo_list t0
  LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id
WHERE
  t0.type = ?
  AND t0.agency_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.conditions AS conditions_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.image AS image_6, t0.online AS online_7, t8.id AS id_9, t8.startDate AS startDate_10, t8.endDate AS endDate_11, t8.home_promo_list_id AS home_promo_list_id_12, t0.agency_id AS agency_id_13 FROM home_promo_list t0 LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id WHERE t0.type = 'main-escapadas' AND t0.agency_id = 152 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.switch AS switch_3,
  t0.mobile AS mobile_4,
  t0.toUpdate AS toUpdate_5,
  t0.title AS title_6,
  t0.titleSwitch AS titleSwitch_7,
  t0.price AS price_8,
  t0.content AS content_9,
  t0.details AS details_10,
  t0.duration AS duration_11,
  t0.path AS path_12,
  t0.link AS link_13,
  t0.linkSwitch AS linkSwitch_14,
  t0.promoSize AS promoSize_15,
  t0.date AS date_16,
  t0.home_promo_list_id AS home_promo_list_id_17
FROM
  home_promo t0
WHERE
  t0.home_promo_list_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.size AS size_2, t0.switch AS switch_3, t0.mobile AS mobile_4, t0.toUpdate AS toUpdate_5, t0.title AS title_6, t0.titleSwitch AS titleSwitch_7, t0.price AS price_8, t0.content AS content_9, t0.details AS details_10, t0.duration AS duration_11, t0.path AS path_12, t0.link AS link_13, t0.linkSwitch AS linkSwitch_14, t0.promoSize AS promoSize_15, t0.date AS date_16, t0.home_promo_list_id AS home_promo_list_id_17 FROM home_promo t0 WHERE t0.home_promo_list_id = 1081 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.conditions AS conditions_3,
  t0.title AS title_4,
  t0.subtitle AS subtitle_5,
  t0.image AS image_6,
  t0.online AS online_7,
  t8.id AS id_9,
  t8.startDate AS startDate_10,
  t8.endDate AS endDate_11,
  t8.home_promo_list_id AS home_promo_list_id_12,
  t0.agency_id AS agency_id_13
FROM
  home_promo_list t0
  LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id
WHERE
  t0.type = ?
  AND t0.agency_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.conditions AS conditions_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.image AS image_6, t0.online AS online_7, t8.id AS id_9, t8.startDate AS startDate_10, t8.endDate AS endDate_11, t8.home_promo_list_id AS home_promo_list_id_12, t0.agency_id AS agency_id_13 FROM home_promo_list t0 LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id WHERE t0.type = 'main-experiencias' AND t0.agency_id = 152 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.switch AS switch_3,
  t0.mobile AS mobile_4,
  t0.toUpdate AS toUpdate_5,
  t0.title AS title_6,
  t0.titleSwitch AS titleSwitch_7,
  t0.price AS price_8,
  t0.content AS content_9,
  t0.details AS details_10,
  t0.duration AS duration_11,
  t0.path AS path_12,
  t0.link AS link_13,
  t0.linkSwitch AS linkSwitch_14,
  t0.promoSize AS promoSize_15,
  t0.date AS date_16,
  t0.home_promo_list_id AS home_promo_list_id_17
FROM
  home_promo t0
WHERE
  t0.home_promo_list_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.size AS size_2, t0.switch AS switch_3, t0.mobile AS mobile_4, t0.toUpdate AS toUpdate_5, t0.title AS title_6, t0.titleSwitch AS titleSwitch_7, t0.price AS price_8, t0.content AS content_9, t0.details AS details_10, t0.duration AS duration_11, t0.path AS path_12, t0.link AS link_13, t0.linkSwitch AS linkSwitch_14, t0.promoSize AS promoSize_15, t0.date AS date_16, t0.home_promo_list_id AS home_promo_list_id_17 FROM home_promo t0 WHERE t0.home_promo_list_id = 1082 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.conditions AS conditions_3,
  t0.title AS title_4,
  t0.subtitle AS subtitle_5,
  t0.image AS image_6,
  t0.online AS online_7,
  t8.id AS id_9,
  t8.startDate AS startDate_10,
  t8.endDate AS endDate_11,
  t8.home_promo_list_id AS home_promo_list_id_12,
  t0.agency_id AS agency_id_13
FROM
  home_promo_list t0
  LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id
WHERE
  t0.type = ?
  AND t0.agency_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.conditions AS conditions_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.image AS image_6, t0.online AS online_7, t8.id AS id_9, t8.startDate AS startDate_10, t8.endDate AS endDate_11, t8.home_promo_list_id AS home_promo_list_id_12, t0.agency_id AS agency_id_13 FROM home_promo_list t0 LEFT JOIN home_promo_time t8 ON t8.home_promo_list_id = t0.id WHERE t0.type = 'main-recommendations' AND t0.agency_id = 152 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.switch AS switch_3,
  t0.mobile AS mobile_4,
  t0.toUpdate AS toUpdate_5,
  t0.title AS title_6,
  t0.titleSwitch AS titleSwitch_7,
  t0.price AS price_8,
  t0.content AS content_9,
  t0.details AS details_10,
  t0.duration AS duration_11,
  t0.path AS path_12,
  t0.link AS link_13,
  t0.linkSwitch AS linkSwitch_14,
  t0.promoSize AS promoSize_15,
  t0.date AS date_16,
  t0.home_promo_list_id AS home_promo_list_id_17
FROM
  home_promo t0
WHERE
  t0.home_promo_list_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.size AS size_2, t0.switch AS switch_3, t0.mobile AS mobile_4, t0.toUpdate AS toUpdate_5, t0.title AS title_6, t0.titleSwitch AS titleSwitch_7, t0.price AS price_8, t0.content AS content_9, t0.details AS details_10, t0.duration AS duration_11, t0.path AS path_12, t0.link AS link_13, t0.linkSwitch AS linkSwitch_14, t0.promoSize AS promoSize_15, t0.date AS date_16, t0.home_promo_list_id AS home_promo_list_id_17 FROM home_promo t0 WHERE t0.home_promo_list_id = 1056 ORDER BY t0.date DESC;

SELECT
  c0_.id AS id_0,
  c0_.wsUrl AS wsUrl_1,
  c0_.message AS message_2,
  c0_.officeId AS officeId_3,
  c0_.externalId AS externalId_4,
  c0_.override AS override_5,
  c0_.isActive AS isActive_6,
  c0_.provider_id AS provider_id_7,
  c0_.agency_id AS agency_id_8
FROM
  config_flight_calendar_agency c0_
WHERE
  c0_.agency_id = ?
  AND c0_.isActive = ?
ORDER BY
  c0_.id ASC