Symfony Profiler

SELECT
  t0.rec_id AS rec_id_1,
  t0.parent_id AS parent_id_2,
  t0.fName AS fName_3,
  t0.fDescription AS fDescription_4,
  t0.fNameEng AS fNameEng_5,
  t0.fNameRd AS fNameRd_6,
  t0.fNameVn AS fNameVn_7,
  t0.fNamePr AS fNamePr_8,
  t0.fNameDt AS fNameDt_9,
  t0.fNameTr AS fNameTr_10,
  t0.fNameUkr AS fNameUkr_11,
  t0.fNameUkrRd AS fNameUkrRd_12,
  t0.fNameUkrVn AS fNameUkrVn_13,
  t0.fNameUkrPr AS fNameUkrPr_14,
  t0.fNameUkrDt AS fNameUkrDt_15,
  t0.fNameIata AS fNameIata_16,
  t0.fNameURI AS fNameURI_17,
  t0.fAdvert AS fAdvert_18,
  t0.fAnchor AS fAnchor_19,
  t0.fJump AS fJump_20,
  t0.fTarget AS fTarget_21,
  t0.fPriority AS fPriority_22,
  t0.fSort AS fSort_23,
  t0.fActive AS fActive_24,
  t0.fSouthWest AS fSouthWest_25,
  t0.fNorthEast AS fNorthEast_26,
  t0.fZoom AS fZoom_27,
  t0.fRegPath AS fRegPath_28,
  t0.fNameEe AS fNameEe_29,
  t0.fNameEeRd AS fNameEeRd_30,
  t0.fNameEeVn AS fNameEeVn_31,
  t0.fNameEePr AS fNameEePr_32,
  t0.fNameEeDt AS fNameEeDt_33,
  t0.fNameLt AS fNameLt_34,
  t0.fNameLtRd AS fNameLtRd_35,
  t0.fNameLtVn AS fNameLtVn_36,
  t0.fNameLtPr AS fNameLtPr_37,
  t0.fNameLtDt AS fNameLtDt_38,
  t0.fNameLv AS fNameLv_39,
  t0.fNameLvRd AS fNameLvRd_40,
  t0.fNameLvVn AS fNameLvVn_41,
  t0.fNameLvPr AS fNameLvPr_42,
  t0.fNameLvDt AS fNameLvDt_43,
  t0.fNamePl AS fNamePl_44,
  t0.fNamePlRd AS fNamePlRd_45,
  t0.fNamePlVn AS fNamePlVn_46,
  t0.fNamePlPr AS fNamePlPr_47,
  t0.fNamePlDt AS fNamePlDt_48,
  t0.fNameUz AS fNameUz_49,
  t0.fNameUzRd AS fNameUzRd_50,
  t0.fNameUzVn AS fNameUzVn_51,
  t0.fNameUzPr AS fNameUzPr_52,
  t0.fNameUzDt AS fNameUzDt_53,
  t0.fNameRo AS fNameRo_54,
  t0.fNameRoRd AS fNameRoRd_55,
  t0.fNameRoVn AS fNameRoVn_56,
  t0.fNameRoPr AS fNameRoPr_57,
  t0.fNameRoDt AS fNameRoDt_58,
  t0.fNameKk AS fNameKk_59,
  t0.fNameKkRd AS fNameKkRd_60,
  t0.fNameKkVn AS fNameKkVn_61,
  t0.fNameKkPr AS fNameKkPr_62,
  t0.fNameKkDt AS fNameKkDt_63,
  t0.parent_id AS parent_id_64,
  t0.fAnchor AS fAnchor_65
FROM
  otpusk.tRegions t0
WHERE
  t0.rec_id = ?
LIMIT
  1

SELECT t0.rec_id AS rec_id_1, t0.parent_id AS parent_id_2, t0.fName AS fName_3, t0.fDescription AS fDescription_4, t0.fNameEng AS fNameEng_5, t0.fNameRd AS fNameRd_6, t0.fNameVn AS fNameVn_7, t0.fNamePr AS fNamePr_8, t0.fNameDt AS fNameDt_9, t0.fNameTr AS fNameTr_10, t0.fNameUkr AS fNameUkr_11, t0.fNameUkrRd AS fNameUkrRd_12, t0.fNameUkrVn AS fNameUkrVn_13, t0.fNameUkrPr AS fNameUkrPr_14, t0.fNameUkrDt AS fNameUkrDt_15, t0.fNameIata AS fNameIata_16, t0.fNameURI AS fNameURI_17, t0.fAdvert AS fAdvert_18, t0.fAnchor AS fAnchor_19, t0.fJump AS fJump_20, t0.fTarget AS fTarget_21, t0.fPriority AS fPriority_22, t0.fSort AS fSort_23, t0.fActive AS fActive_24, t0.fSouthWest AS fSouthWest_25, t0.fNorthEast AS fNorthEast_26, t0.fZoom AS fZoom_27, t0.fRegPath AS fRegPath_28, t0.fNameEe AS fNameEe_29, t0.fNameEeRd AS fNameEeRd_30, t0.fNameEeVn AS fNameEeVn_31, t0.fNameEePr AS fNameEePr_32, t0.fNameEeDt AS fNameEeDt_33, t0.fNameLt AS fNameLt_34, t0.fNameLtRd AS fNameLtRd_35, t0.fNameLtVn AS fNameLtVn_36, t0.fNameLtPr AS fNameLtPr_37, t0.fNameLtDt AS fNameLtDt_38, t0.fNameLv AS fNameLv_39, t0.fNameLvRd AS fNameLvRd_40, t0.fNameLvVn AS fNameLvVn_41, t0.fNameLvPr AS fNameLvPr_42, t0.fNameLvDt AS fNameLvDt_43, t0.fNamePl AS fNamePl_44, t0.fNamePlRd AS fNamePlRd_45, t0.fNamePlVn AS fNamePlVn_46, t0.fNamePlPr AS fNamePlPr_47, t0.fNamePlDt AS fNamePlDt_48, t0.fNameUz AS fNameUz_49, t0.fNameUzRd AS fNameUzRd_50, t0.fNameUzVn AS fNameUzVn_51, t0.fNameUzPr AS fNameUzPr_52, t0.fNameUzDt AS fNameUzDt_53, t0.fNameRo AS fNameRo_54, t0.fNameRoRd AS fNameRoRd_55, t0.fNameRoVn AS fNameRoVn_56, t0.fNameRoPr AS fNameRoPr_57, t0.fNameRoDt AS fNameRoDt_58, t0.fNameKk AS fNameKk_59, t0.fNameKkRd AS fNameKkRd_60, t0.fNameKkVn AS fNameKkVn_61, t0.fNameKkPr AS fNameKkPr_62, t0.fNameKkDt AS fNameKkDt_63, t0.parent_id AS parent_id_64, t0.fAnchor AS fAnchor_65 FROM otpusk.tRegions t0 WHERE t0.rec_id = 5114 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.countries AS countries_3,
  t0.period AS period_4,
  t0.type AS type_5,
  t0.regions AS regions_6,
  t0.price_per_day AS price_per_day_7,
  t0.fare AS fare_8,
  t0.days AS days_9,
  t0.rate_from AS rate_from_10,
  t0.rate_to AS rate_to_11,
  t0.star2_coef AS star2_coef_12,
  t0.star3_coef AS star3_coef_13,
  t0.star4_coef AS star4_coef_14,
  t0.star5_coef AS star5_coef_15,
  t0.is_default AS is_default_16,
  t0.image AS image_17,
  t0.auction_source_id AS auction_source_id_18
FROM
  auction_rules t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.countries AS countries_3, t0.period AS period_4, t0.type AS type_5, t0.regions AS regions_6, t0.price_per_day AS price_per_day_7, t0.fare AS fare_8, t0.days AS days_9, t0.rate_from AS rate_from_10, t0.rate_to AS rate_to_11, t0.star2_coef AS star2_coef_12, t0.star3_coef AS star3_coef_13, t0.star4_coef AS star4_coef_14, t0.star5_coef AS star5_coef_15, t0.is_default AS is_default_16, t0.image AS image_17, t0.auction_source_id AS auction_source_id_18 FROM auction_rules t0 WHERE t0.name = 'Отпуск Деф' LIMIT 1;

SELECT
  a0_.country AS country_0
FROM
  auction_requests a0_

SELECT a0_.country AS country_0 FROM auction_requests a0_;

SELECT
  a0_.city_from AS city_from_0
FROM
  auction_requests a0_

SELECT a0_.city_from AS city_from_0 FROM auction_requests a0_;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  auction_requests a0_
WHERE
  a0_.status NOT IN (?)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM auction_requests a0_ WHERE a0_.status NOT IN (4, 5, 6);

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.status AS status_1,
  a0_.id AS id_2
FROM
  auction_requests a0_
WHERE
  a0_.status NOT IN (?)
ORDER BY
  a0_.status ASC,
  a0_.id DESC
LIMIT
  12

SELECT DISTINCT a0_.id AS id_0, a0_.status AS status_1, a0_.id AS id_2 FROM auction_requests a0_ WHERE a0_.status NOT IN (4, 5, 6) ORDER BY a0_.status ASC, a0_.id DESC LIMIT 12;

SELECT
  a0_.id AS id_0,
  a0_.description AS description_1,
  a0_.adult AS adult_2,
  a0_.children AS children_3,
  a0_.date_from AS date_from_4,
  a0_.date_to AS date_to_5,
  a0_.other_date AS other_date_6,
  a0_.duration_from AS duration_from_7,
  a0_.duration_to AS duration_to_8,
  a0_.user_name AS user_name_9,
  a0_.user_phone AS user_phone_10,
  a0_.user_email AS user_email_11,
  a0_.city_from AS city_from_12,
  a0_.region_from AS region_from_13,
  a0_.rule_data AS rule_data_14,
  a0_.info_data AS info_data_15,
  a0_.crm_data AS crm_data_16,
  a0_.children_age AS children_age_17,
  a0_.url AS url_18,
  a0_.status AS status_19,
  a0_.country AS country_20,
  a0_.resort AS resort_21,
  a0_.hotel AS hotel_22,
  a0_.star AS star_23,
  a0_.price AS price_24,
  a0_.type AS type_25,
  a0_.communication AS communication_26,
  a0_.price_top AS price_top_27,
  a0_.period AS period_28,
  a0_.price_bottom AS price_bottom_29,
  a0_.notifications AS notifications_30,
  a0_.remotely AS remotely_31,
  a0_.ip AS ip_32,
  a0_.city_ip_from AS city_ip_from_33,
  a0_.region_ip_from AS region_ip_from_34,
  a0_.created_at AS created_at_35,
  a0_.updated_at AS updated_at_36,
  a0_.auction_source_id AS auction_source_id_37
FROM
  auction_requests a0_
WHERE
  a0_.status NOT IN (?)
  AND a0_.id IN (?)
ORDER BY
  a0_.status ASC,
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.adult AS adult_2, a0_.children AS children_3, a0_.date_from AS date_from_4, a0_.date_to AS date_to_5, a0_.other_date AS other_date_6, a0_.duration_from AS duration_from_7, a0_.duration_to AS duration_to_8, a0_.user_name AS user_name_9, a0_.user_phone AS user_phone_10, a0_.user_email AS user_email_11, a0_.city_from AS city_from_12, a0_.region_from AS region_from_13, a0_.rule_data AS rule_data_14, a0_.info_data AS info_data_15, a0_.crm_data AS crm_data_16, a0_.children_age AS children_age_17, a0_.url AS url_18, a0_.status AS status_19, a0_.country AS country_20, a0_.resort AS resort_21, a0_.hotel AS hotel_22, a0_.star AS star_23, a0_.price AS price_24, a0_.type AS type_25, a0_.communication AS communication_26, a0_.price_top AS price_top_27, a0_.period AS period_28, a0_.price_bottom AS price_bottom_29, a0_.notifications AS notifications_30, a0_.remotely AS remotely_31, a0_.ip AS ip_32, a0_.city_ip_from AS city_ip_from_33, a0_.region_ip_from AS region_ip_from_34, a0_.created_at AS created_at_35, a0_.updated_at AS updated_at_36, a0_.auction_source_id AS auction_source_id_37 FROM auction_requests a0_ WHERE a0_.status NOT IN (4, 5, 6) AND a0_.id IN (27437, 27436, 27435, 27434, 27433, 27432, 27431, 27430, 27428, 27427, 27426, 27425) ORDER BY a0_.status ASC, a0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_admin AS name_admin_3,
  t0.active AS active_4
FROM
  auction_sources t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_admin AS name_admin_3, t0.active AS active_4 FROM auction_sources t0 WHERE t0.active = 0;

SELECT
  t0.rec_id AS rec_id_1,
  t0.fCountryID AS fCountryID_2,
  t0.fIATA AS fIATA_3,
  t0.fName AS fName_4,
  t0.fNameAlt AS fNameAlt_5,
  t0.fNameEng AS fNameEng_6,
  t0.fNameRd AS fNameRd_7,
  t0.fNameVn AS fNameVn_8,
  t0.fNamePr AS fNamePr_9,
  t0.fNameDt AS fNameDt_10,
  t0.fNameUkr AS fNameUkr_11,
  t0.fNameUkrRd AS fNameUkrRd_12,
  t0.fNameUkrVn AS fNameUkrVn_13,
  t0.fNameUkrPr AS fNameUkrPr_14,
  t0.fNameUkrDt AS fNameUkrDt_15,
  t0.fNameTr AS fNameTr_16,
  t0.fTarget AS fTarget_17,
  t0.fArrivals AS fArrivals_18,
  t0.fPriority AS fPriority_19,
  t0.searchWeight AS searchWeight_20,
  t0.fSouthWest AS fSouthWest_21,
  t0.fNorthEast AS fNorthEast_22,
  t0.fZoom AS fZoom_23,
  t0.gallery_id AS gallery_id_24,
  t0.cityWeight AS cityWeight_25,
  t0.image AS image_26,
  t0.language AS language_27,
  t0.language_ukr AS language_ukr_28,
  t0.currencyName AS currencyName_29,
  t0.currencyName_ukr AS currencyName_ukr_30,
  t0.flightTime AS flightTime_31,
  t0.timeLocal AS timeLocal_32,
  t0.coffeeCost AS coffeeCost_33,
  t0.foodCost AS foodCost_34
FROM
  otpusk.tCities t0
WHERE
  t0.rec_id = ?
LIMIT
  1

SELECT t0.rec_id AS rec_id_1, t0.fCountryID AS fCountryID_2, t0.fIATA AS fIATA_3, t0.fName AS fName_4, t0.fNameAlt AS fNameAlt_5, t0.fNameEng AS fNameEng_6, t0.fNameRd AS fNameRd_7, t0.fNameVn AS fNameVn_8, t0.fNamePr AS fNamePr_9, t0.fNameDt AS fNameDt_10, t0.fNameUkr AS fNameUkr_11, t0.fNameUkrRd AS fNameUkrRd_12, t0.fNameUkrVn AS fNameUkrVn_13, t0.fNameUkrPr AS fNameUkrPr_14, t0.fNameUkrDt AS fNameUkrDt_15, t0.fNameTr AS fNameTr_16, t0.fTarget AS fTarget_17, t0.fArrivals AS fArrivals_18, t0.fPriority AS fPriority_19, t0.searchWeight AS searchWeight_20, t0.fSouthWest AS fSouthWest_21, t0.fNorthEast AS fNorthEast_22, t0.fZoom AS fZoom_23, t0.gallery_id AS gallery_id_24, t0.cityWeight AS cityWeight_25, t0.image AS image_26, t0.language AS language_27, t0.language_ukr AS language_ukr_28, t0.currencyName AS currencyName_29, t0.currencyName_ukr AS currencyName_ukr_30, t0.flightTime AS flightTime_31, t0.timeLocal AS timeLocal_32, t0.coffeeCost AS coffeeCost_33, t0.foodCost AS foodCost_34 FROM otpusk.tCities t0 WHERE t0.rec_id = 1544 LIMIT 1;

SELECT
  t0.rec_id AS rec_id_1,
  t0.fCode AS fCode_2,
  t0.fIATA AS fIATA_3,
  t0.fCountry AS fCountry_4,
  t0.fNameAlt AS fNameAlt_5,
  t0.fNameRd AS fNameRd_6,
  t0.fNameVn AS fNameVn_7,
  t0.fNamePr AS fNamePr_8,
  t0.fNameDt AS fNameDt_9,
  t0.fNameUkr AS fNameUkr_10,
  t0.fNameUkrRd AS fNameUkrRd_11,
  t0.fNameUkrVn AS fNameUkrVn_12,
  t0.fNameUkrPr AS fNameUkrPr_13,
  t0.fNameUkrDt AS fNameUkrDt_14,
  t0.fNameTr AS fNameTr_15,
  t0.fCapitalID AS fCapitalID_16,
  t0.fContinent AS fContinent_17,
  t0.fTour AS fTour_18,
  t0.fTransport AS fTransport_19,
  t0.fCurrency AS fCurrency_20,
  t0.fVisa AS fVisa_21,
  t0.fOnRequest AS fOnRequest_22,
  t0.fPriority AS fPriority_23,
  t0.searchWeight AS searchWeight_24,
  t0.fSouthWest AS fSouthWest_25,
  t0.fNorthEast AS fNorthEast_26,
  t0.fZoom AS fZoom_27,
  t0.fService AS fService_28,
  t0.fServiceTab AS fServiceTab_29,
  t0.fServiceIcon AS fServiceIcon_30,
  t0.pageWeight AS pageWeight_31,
  t0.priceSegment AS priceSegment_32,
  t0.flightTime AS flightTime_33,
  t0.seasonalityMonths AS seasonalityMonths_34,
  t0.attendance AS attendance_35,
  t0.image AS image_36,
  t0.visaforcountrycard AS visaforcountrycard_37,
  t0.attendance_ukr AS attendance_ukr_38,
  t0.visaforcountrycard_ukr AS visaforcountrycard_ukr_39,
  t0.timeLocal AS timeLocal_40,
  t0.language AS language_41,
  t0.language_ukr AS language_ukr_42,
  t0.currencyName AS currencyName_43,
  t0.currencyName_ukr AS currencyName_ukr_44,
  t0.coffeeCost AS coffeeCost_45,
  t0.foodCost AS foodCost_46
FROM
  otpusk.tCountries t0
WHERE
  t0.rec_id = ?
LIMIT
  1

SELECT t0.rec_id AS rec_id_1, t0.fCode AS fCode_2, t0.fIATA AS fIATA_3, t0.fCountry AS fCountry_4, t0.fNameAlt AS fNameAlt_5, t0.fNameRd AS fNameRd_6, t0.fNameVn AS fNameVn_7, t0.fNamePr AS fNamePr_8, t0.fNameDt AS fNameDt_9, t0.fNameUkr AS fNameUkr_10, t0.fNameUkrRd AS fNameUkrRd_11, t0.fNameUkrVn AS fNameUkrVn_12, t0.fNameUkrPr AS fNameUkrPr_13, t0.fNameUkrDt AS fNameUkrDt_14, t0.fNameTr AS fNameTr_15, t0.fCapitalID AS fCapitalID_16, t0.fContinent AS fContinent_17, t0.fTour AS fTour_18, t0.fTransport AS fTransport_19, t0.fCurrency AS fCurrency_20, t0.fVisa AS fVisa_21, t0.fOnRequest AS fOnRequest_22, t0.fPriority AS fPriority_23, t0.searchWeight AS searchWeight_24, t0.fSouthWest AS fSouthWest_25, t0.fNorthEast AS fNorthEast_26, t0.fZoom AS fZoom_27, t0.fService AS fService_28, t0.fServiceTab AS fServiceTab_29, t0.fServiceIcon AS fServiceIcon_30, t0.pageWeight AS pageWeight_31, t0.priceSegment AS priceSegment_32, t0.flightTime AS flightTime_33, t0.seasonalityMonths AS seasonalityMonths_34, t0.attendance AS attendance_35, t0.image AS image_36, t0.visaforcountrycard AS visaforcountrycard_37, t0.attendance_ukr AS attendance_ukr_38, t0.visaforcountrycard_ukr AS visaforcountrycard_ukr_39, t0.timeLocal AS timeLocal_40, t0.language AS language_41, t0.language_ukr AS language_ukr_42, t0.currencyName AS currencyName_43, t0.currencyName_ukr AS currencyName_ukr_44, t0.coffeeCost AS coffeeCost_45, t0.foodCost AS foodCost_46 FROM otpusk.tCountries t0 WHERE t0.rec_id = 116 LIMIT 1;

SELECT
  t0.rec_id AS rec_id_1,
  t0.fCountryID AS fCountryID_2,
  t0.fIATA AS fIATA_3,
  t0.fName AS fName_4,
  t0.fNameAlt AS fNameAlt_5,
  t0.fNameEng AS fNameEng_6,
  t0.fNameRd AS fNameRd_7,
  t0.fNameVn AS fNameVn_8,
  t0.fNamePr AS fNamePr_9,
  t0.fNameDt AS fNameDt_10,
  t0.fNameUkr AS fNameUkr_11,
  t0.fNameUkrRd AS fNameUkrRd_12,
  t0.fNameUkrVn AS fNameUkrVn_13,
  t0.fNameUkrPr AS fNameUkrPr_14,
  t0.fNameUkrDt AS fNameUkrDt_15,
  t0.fNameTr AS fNameTr_16,
  t0.fTarget AS fTarget_17,
  t0.fArrivals AS fArrivals_18,
  t0.fPriority AS fPriority_19,
  t0.searchWeight AS searchWeight_20,
  t0.fSouthWest AS fSouthWest_21,
  t0.fNorthEast AS fNorthEast_22,
  t0.fZoom AS fZoom_23,
  t0.gallery_id AS gallery_id_24,
  t0.cityWeight AS cityWeight_25,
  t0.image AS image_26,
  t0.language AS language_27,
  t0.language_ukr AS language_ukr_28,
  t0.currencyName AS currencyName_29,
  t0.currencyName_ukr AS currencyName_ukr_30,
  t0.flightTime AS flightTime_31,
  t0.timeLocal AS timeLocal_32,
  t0.coffeeCost AS coffeeCost_33,
  t0.foodCost AS foodCost_34
FROM
  otpusk.tCities t0
WHERE
  t0.rec_id IS NULL
LIMIT
  1

SELECT t0.rec_id AS rec_id_1, t0.fCountryID AS fCountryID_2, t0.fIATA AS fIATA_3, t0.fName AS fName_4, t0.fNameAlt AS fNameAlt_5, t0.fNameEng AS fNameEng_6, t0.fNameRd AS fNameRd_7, t0.fNameVn AS fNameVn_8, t0.fNamePr AS fNamePr_9, t0.fNameDt AS fNameDt_10, t0.fNameUkr AS fNameUkr_11, t0.fNameUkrRd AS fNameUkrRd_12, t0.fNameUkrVn AS fNameUkrVn_13, t0.fNameUkrPr AS fNameUkrPr_14, t0.fNameUkrDt AS fNameUkrDt_15, t0.fNameTr AS fNameTr_16, t0.fTarget AS fTarget_17, t0.fArrivals AS fArrivals_18, t0.fPriority AS fPriority_19, t0.searchWeight AS searchWeight_20, t0.fSouthWest AS fSouthWest_21, t0.fNorthEast AS fNorthEast_22, t0.fZoom AS fZoom_23, t0.gallery_id AS gallery_id_24, t0.cityWeight AS cityWeight_25, t0.image AS image_26, t0.language AS language_27, t0.language_ukr AS language_ukr_28, t0.currencyName AS currencyName_29, t0.currencyName_ukr AS currencyName_ukr_30, t0.flightTime AS flightTime_31, t0.timeLocal AS timeLocal_32, t0.coffeeCost AS coffeeCost_33, t0.foodCost AS foodCost_34 FROM otpusk.tCities t0 WHERE t0.rec_id IS NULL LIMIT 1;