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 = 'legacy-qa.grupoaviatur.com' 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 = 'vuelos/MDE-CTG/2025-06-11/1-0-0?maxResults=200&ffType=price&url_product=https%3A%2F%2Flegacy-qa.grupoaviatur.com%2Fvuelos%2FMDE-CTG%2F2025-06-11%2F1-0-0&_=1745853040036' 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.code AS code_2,
  t0.description AS description_3,
  t0.isActive AS isActive_4
FROM
  payment_method t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3, t0.isActive AS isActive_4 FROM payment_method t0 WHERE t0.code = 'safety' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.siteCode AS siteCode_2,
  t0.tranKey AS tranKey_3,
  t0.isActive AS isActive_4,
  t0.isTest AS isTest_5,
  t0.user AS user_6,
  t0.password AS password_7,
  t0.currency AS currency_8,
  t0.testEndpoint AS testEndpoint_9,
  t0.productionEndpoint AS productionEndpoint_10,
  t0.siteId AS siteId_11,
  t0.placeToPayRest AS placeToPayRest_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.agency_id AS agency_id_14
FROM
  payment_method_agency t0
WHERE
  t0.agency_id = ?
  AND t0.payment_method_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.siteCode AS siteCode_2, t0.tranKey AS tranKey_3, t0.isActive AS isActive_4, t0.isTest AS isTest_5, t0.user AS user_6, t0.password AS password_7, t0.currency AS currency_8, t0.testEndpoint AS testEndpoint_9, t0.productionEndpoint AS productionEndpoint_10, t0.siteId AS siteId_11, t0.placeToPayRest AS placeToPayRest_12, t0.payment_method_id AS payment_method_id_13, t0.agency_id AS agency_id_14 FROM payment_method_agency t0 WHERE t0.agency_id = 152 AND t0.payment_method_id = 3 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_enable_special_discounts' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.iata AS iata_2,
  t0.isActive AS isActive_3,
  t0.PartyID AS PartyID_4
FROM
  available_currency t0

SELECT t0.id AS id_1, t0.iata AS iata_2, t0.isActive AS isActive_3, t0.PartyID AS PartyID_4 FROM available_currency t0;

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.iata AS iata_2,
  t0.city AS city_3,
  t0.country AS country_4,
  t0.countryCode AS countryCode_5,
  t0.hasAirport AS hasAirport_6,
  t0.coordinates AS coordinates_7
FROM
  search_cities t0
WHERE
  t0.iata IN (?, ?)

SELECT t0.id AS id_1, t0.iata AS iata_2, t0.city AS city_3, t0.country AS country_4, t0.countryCode AS countryCode_5, t0.hasAirport AS hasAirport_6, t0.coordinates AS coordinates_7 FROM search_cities t0 WHERE t0.iata IN ('MDE', 'CTG');

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_.preference AS preference_5,
  c0_.isActive AS isActive_6,
  c0_.maxTime AS maxTime_7,
  c0_.hasCombination AS hasCombination_8,
  c0_.errorCount AS errorCount_9,
  c0_.errorDatetime AS errorDatetime_10,
  c0_.provider_id AS provider_id_11,
  c0_.agency_id AS agency_id_12
FROM
  config_flight_agency c0_
WHERE
  c0_.agency_id = ?
  AND c0_.isActive = ?
  AND (
    c0_.errorCount < ?
    OR c0_.errorDatetime <= ?
  )
  AND c0_.preference IN (1, 2)
ORDER BY
  c0_.id ASC

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_.preference AS preference_5, c0_.isActive AS isActive_6, c0_.maxTime AS maxTime_7, c0_.hasCombination AS hasCombination_8, c0_.errorCount AS errorCount_9, c0_.errorDatetime AS errorDatetime_10, c0_.provider_id AS provider_id_11, c0_.agency_id AS agency_id_12 FROM config_flight_agency c0_ WHERE c0_.agency_id = 152 AND c0_.isActive = 1 AND (c0_.errorCount < 10 OR c0_.errorDatetime <= '2025-04-28 10:00:41') AND c0_.preference IN (1, 2) ORDER BY c0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.providerIdentifier AS providerIdentifier_2,
  t0.name AS name_3,
  t0.payment_type_id AS payment_type_id_4,
  t0.product_type_id AS product_type_id_5
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.providerIdentifier AS providerIdentifier_2, t0.name AS name_3, t0.payment_type_id AS payment_type_id_4, t0.product_type_id AS product_type_id_5 FROM provider t0 WHERE t0.id = 56;

SELECT
  t0.id AS id_1,
  t0.providerIdentifier AS providerIdentifier_2,
  t0.name AS name_3,
  t0.payment_type_id AS payment_type_id_4,
  t0.product_type_id AS product_type_id_5
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.providerIdentifier AS providerIdentifier_2, t0.name AS name_3, t0.payment_type_id AS payment_type_id_4, t0.product_type_id AS product_type_id_5 FROM provider t0 WHERE t0.id = 54;

SELECT
  t0.id AS id_1,
  t0.providerIdentifier AS providerIdentifier_2,
  t0.name AS name_3,
  t0.payment_type_id AS payment_type_id_4,
  t0.product_type_id AS product_type_id_5
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.providerIdentifier AS providerIdentifier_2, t0.name AS name_3, t0.payment_type_id AS payment_type_id_4, t0.product_type_id AS product_type_id_5 FROM provider t0 WHERE t0.id = 79;

SELECT
  t0.id AS id_1,
  t0.providerIdentifier AS providerIdentifier_2,
  t0.name AS name_3,
  t0.payment_type_id AS payment_type_id_4,
  t0.product_type_id AS product_type_id_5
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.providerIdentifier AS providerIdentifier_2, t0.name AS name_3, t0.payment_type_id AS payment_type_id_4, t0.product_type_id AS product_type_id_5 FROM provider t0 WHERE t0.id = 78;

SELECT
  t0.id AS id_1,
  t0.providerIdentifier AS providerIdentifier_2,
  t0.name AS name_3,
  t0.payment_type_id AS payment_type_id_4,
  t0.product_type_id AS product_type_id_5
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.providerIdentifier AS providerIdentifier_2, t0.name AS name_3, t0.payment_type_id AS payment_type_id_4, t0.product_type_id AS product_type_id_5 FROM provider t0 WHERE t0.id = 69;

SELECT
  t0.id AS id_1,
  t0.providerIdentifier AS providerIdentifier_2,
  t0.name AS name_3,
  t0.payment_type_id AS payment_type_id_4,
  t0.product_type_id AS product_type_id_5
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.providerIdentifier AS providerIdentifier_2, t0.name AS name_3, t0.payment_type_id AS payment_type_id_4, t0.product_type_id AS product_type_id_5 FROM provider t0 WHERE t0.id = 70;

SELECT
  t0.id AS id_1,
  t0.providerIdentifier AS providerIdentifier_2,
  t0.name AS name_3,
  t0.payment_type_id AS payment_type_id_4,
  t0.product_type_id AS product_type_id_5
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.providerIdentifier AS providerIdentifier_2, t0.name AS name_3, t0.payment_type_id AS payment_type_id_4, t0.product_type_id AS product_type_id_5 FROM provider t0 WHERE t0.id = 82;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.value AS value_2,
  p0_.description AS description_3,
  p0_.agency_id AS agency_id_4
FROM
  parameter p0_
WHERE
  p0_.name = 'negotiated_fare_code'
  AND p0_.agency_id = 152

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value AS value_2, p0_.description AS description_3, p0_.agency_id AS agency_id_4 FROM parameter p0_ WHERE p0_.name = 'negotiated_fare_code' AND p0_.agency_id = 152;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.product_type_id AS product_type_id_4
FROM
  verb t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.product_type_id AS product_type_id_4 FROM verb t0 WHERE t0.name = 'AirLowFareSearch' LIMIT 1;

SELECT
  distinct(countryCode)
FROM
  search_cities
WHERE
  iata = 'MDE'
  or iata = 'CTG'

SELECT distinct(countryCode) FROM search_cities WHERE iata = 'MDE' or iata='CTG';

SELECT
  distinct(countryCode)
FROM
  search_airports
WHERE
  iata = 'MDE'
  or iata = 'CTG'

SELECT distinct(countryCode) FROM search_airports WHERE iata = 'MDE' or iata='CTG';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.iataCode AS iataCode_3,
  t0.languageCode AS languageCode_4,
  t0.description AS description_5,
  t0.countryStateCode AS countryStateCode_6,
  t0.country_id AS country_id_7
FROM
  city t0
WHERE
  t0.iataCode = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.iataCode AS iataCode_3, t0.languageCode AS languageCode_4, t0.description AS description_5, t0.countryStateCode AS countryStateCode_6, t0.country_id AS country_id_7 FROM city t0 WHERE t0.iataCode = 'CTG' LIMIT 1;

select
  *,
  af.id as admin_fee_id
from
  admin_fee as af,
  airline as a
where
  af.isActive = 1
  and (
    af.airline_id IS NULL
    or af.airline_id = a.id
  )
  and (
    af.agency_id IS NULL
    or af.agency_id = '152'
  )
  and (
    af.city_id IS NULL
    or af.city_id = '6262'
  )
group by
  af.id
order by
  af.id desc,
  af.agency_id desc,
  af.city_id asc,
  af.airline_id asc,
  af.nonationalstop asc

select *, af.id as admin_fee_id from admin_fee as af, airline as a where af.isActive = 1 and (af.airline_id IS NULL or af.airline_id = a.id ) and (af.agency_id IS NULL or af.agency_id = '152') and (af.city_id IS NULL or af.city_id = '6262') group by af.id order by af.id desc, af.agency_id desc, af.city_id asc, af.airline_id asc, af.nonationalstop asc;

SELECT
  t0.product_id AS product_id_1,
  t0.productName AS productName_2,
  t0.descriptionProduct AS descriptionProduct_3,
  t0.qseCommissionMin AS qseCommissionMin_4,
  t0.qseCommissionMax AS qseCommissionMax_5,
  t0.percentageCommissionMin AS percentageCommissionMin_6,
  t0.percentageCommissionMax AS percentageCommissionMax_7,
  t0.qseCommissionPercentage AS qseCommissionPercentage_8,
  t0.taCommissionPercentage AS taCommissionPercentage_9
FROM
  agent_qse_product_commission t0
WHERE
  t0.productName = ?
LIMIT
  1

SELECT t0.product_id AS product_id_1, t0.productName AS productName_2, t0.descriptionProduct AS descriptionProduct_3, t0.qseCommissionMin AS qseCommissionMin_4, t0.qseCommissionMax AS qseCommissionMax_5, t0.percentageCommissionMin AS percentageCommissionMin_6, t0.percentageCommissionMax AS percentageCommissionMax_7, t0.qseCommissionPercentage AS qseCommissionPercentage_8, t0.taCommissionPercentage AS taCommissionPercentage_9 FROM agent_qse_product_commission t0 WHERE t0.productName = 'flight' LIMIT 1;

select
  distinct(iata)
FROM
  airline_validation,
  airline
WHERE
  airline_validation.airline_id = airline.id

select distinct(iata) FROM airline_validation, airline WHERE airline_validation.airline_id = airline.id;

select
  *
FROM
  blocked_fare
WHERE
  isActive = ?
  and url = ?
  and updatingDate >= ?

select * FROM blocked_fare WHERE isActive = 1 and url = '/vuelos/MDE-CTG/2025-06-11/1-0-0' and updatingDate >= '2025-04-28 09:10:55';

SELECT
  t0.id AS id_1,
  t0.farebasis AS farebasis_2,
  t0.airlineCode AS airlineCode_3,
  t0.flightDate AS flightDate_4,
  t0.creationDate AS creationDate_5,
  t0.updatingDate AS updatingDate_6,
  t0.type AS type_7,
  t0.isActive AS isActive_8
FROM
  special_composite_fare t0
WHERE
  t0.isActive = ?

SELECT t0.id AS id_1, t0.farebasis AS farebasis_2, t0.airlineCode AS airlineCode_3, t0.flightDate AS flightDate_4, t0.creationDate AS creationDate_5, t0.updatingDate AS updatingDate_6, t0.type AS type_7, t0.isActive AS isActive_8 FROM special_composite_fare t0 WHERE t0.isActive = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO bestprices (
  producturl, prices, bestprice, entrydate,
  entrytimes, trip, departure, round
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO bestprices (producturl, prices, bestprice, entrydate, entrytimes, trip, departure, round) VALUES ('/vuelos/MDE-CTG/2025-06-11/1-0-0', '{\"JA\":{\"flightPrice\":135290,\"flightPriceTA\":\"135290\",\"flightCurrency\":\"COP\",\"airlineName\":\"Jetsmart Airlines\",\"baseFare\":85000,\"compareValue\":93860,\"ta\":\"0\"},\"LA\":{\"flightPrice\":144740,\"flightPriceTA\":\"144740\",\"flightCurrency\":\"COP\",\"airlineName\":\"Latam Airlines\",\"baseFare\":\"101800\",\"compareValue\":93860,\"ta\":\"0\"},\"AV\":{\"flightPrice\":263740,\"flightPriceTA\":\"263740\",\"flightCurrency\":\"COP\",\"airlineName\":\"Avianca\",\"baseFare\":201800,\"compareValue\":201800,\"ta\":\"0\"}}', 135290, '2025-04-28 10:10:56', 1, 'MDE-CTG|O', '2025-06-11', '');

UPDATE
  search_cities
SET
  hasAirport = ?
WHERE
  id = ?

UPDATE search_cities SET hasAirport = '1' WHERE id = 1011;

UPDATE
  search_cities
SET
  hasAirport = ?
WHERE
  id = ?

UPDATE search_cities SET hasAirport = '1' WHERE id = 3687;

UPDATE
  agent_qse_product_commission
SET
  qseCommissionMin = ?,
  qseCommissionMax = ?,
  percentageCommissionMin = ?,
  percentageCommissionMax = ?,
  qseCommissionPercentage = ?,
  taCommissionPercentage = ?
WHERE
  product_id = ?

UPDATE agent_qse_product_commission SET qseCommissionMin = '15000', qseCommissionMax = '500000', percentageCommissionMin = '0', percentageCommissionMax = '0', qseCommissionPercentage = '0.65', taCommissionPercentage = '0.7' WHERE product_id = 1;

"COMMIT"

"COMMIT";

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 = ?
  AND t0.value = ?
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 = 'recommendation_airline_destiny' AND t0.value = 1 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 = 'service_web_branded_fare' 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