Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

79.69 ms Query time

3 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	26.95 ms	SELECT t0.rec_id AS rec_id_1, t0.lastUpdate AS lastUpdate_2, t0.fCityID AS fCityID_3, t0.fName AS fName_4, t0.fNameUkr AS fNameUkr_5, t0.fTranslit AS fTranslit_6, t0.fTranslitRu AS fTranslitRu_7, t0.fStars AS fStars_8, t0.fStarsAdd AS fStarsAdd_9, t0.fCat AS fCat_10, t0.fBeach AS fBeach_11, t0.fForm AS fForm_12, t0.fArea AS fArea_13, t0.fPriority AS fPriority_14, t0.fSouthWest AS fSouthWest_15, t0.fNorthEast AS fNorthEast_16, t0.fZoom AS fZoom_17, t0.fPaid AS fPaid_18, t0.fActive AS fActive_19, t0.fRefsConfirm AS fRefsConfirm_20, t0.fRating AS fRating_21, t0.fReviews AS fReviews_22, t0.fTopRate AS fTopRate_23, t0.fAvgVotes AS fAvgVotes_24, t0.fLastMsgType AS fLastMsgType_25, t0.fLastMsgDate AS fLastMsgDate_26, t0.notFoundVideo AS notFoundVideo_27, t0.people AS people_28, t0.children AS children_29, t0.seniors AS seniors_30, t0.busines AS busines_31, t0.single AS single_32, t0.chainId AS chainId_33 FROM otpusk.tHotels t0 WHERE t0.rec_id = ? LIMIT 1 Parameters: [`23008`] View formatted query View runnable query Explain query SELECT t0.rec_id AS rec_id_1, t0.lastUpdate AS lastUpdate_2, t0.fCityID AS fCityID_3, t0.fName AS fName_4, t0.fNameUkr AS fNameUkr_5, t0.fTranslit AS fTranslit_6, t0.fTranslitRu AS fTranslitRu_7, t0.fStars AS fStars_8, t0.fStarsAdd AS fStarsAdd_9, t0.fCat AS fCat_10, t0.fBeach AS fBeach_11, t0.fForm AS fForm_12, t0.fArea AS fArea_13, t0.fPriority AS fPriority_14, t0.fSouthWest AS fSouthWest_15, t0.fNorthEast AS fNorthEast_16, t0.fZoom AS fZoom_17, t0.fPaid AS fPaid_18, t0.fActive AS fActive_19, t0.fRefsConfirm AS fRefsConfirm_20, t0.fRating AS fRating_21, t0.fReviews AS fReviews_22, t0.fTopRate AS fTopRate_23, t0.fAvgVotes AS fAvgVotes_24, t0.fLastMsgType AS fLastMsgType_25, t0.fLastMsgDate AS fLastMsgDate_26, t0.notFoundVideo AS notFoundVideo_27, t0.people AS people_28, t0.children AS children_29, t0.seniors AS seniors_30, t0.busines AS busines_31, t0.single AS single_32, t0.chainId AS chainId_33 FROM otpusk.tHotels t0 WHERE t0.rec_id = ? LIMIT 1 SELECT t0.rec_id AS rec_id_1, t0.lastUpdate AS lastUpdate_2, t0.fCityID AS fCityID_3, t0.fName AS fName_4, t0.fNameUkr AS fNameUkr_5, t0.fTranslit AS fTranslit_6, t0.fTranslitRu AS fTranslitRu_7, t0.fStars AS fStars_8, t0.fStarsAdd AS fStarsAdd_9, t0.fCat AS fCat_10, t0.fBeach AS fBeach_11, t0.fForm AS fForm_12, t0.fArea AS fArea_13, t0.fPriority AS fPriority_14, t0.fSouthWest AS fSouthWest_15, t0.fNorthEast AS fNorthEast_16, t0.fZoom AS fZoom_17, t0.fPaid AS fPaid_18, t0.fActive AS fActive_19, t0.fRefsConfirm AS fRefsConfirm_20, t0.fRating AS fRating_21, t0.fReviews AS fReviews_22, t0.fTopRate AS fTopRate_23, t0.fAvgVotes AS fAvgVotes_24, t0.fLastMsgType AS fLastMsgType_25, t0.fLastMsgDate AS fLastMsgDate_26, t0.notFoundVideo AS notFoundVideo_27, t0.people AS people_28, t0.children AS children_29, t0.seniors AS seniors_30, t0.busines AS busines_31, t0.single AS single_32, t0.chainId AS chainId_33 FROM otpusk.tHotels t0 WHERE t0.rec_id = 23008 LIMIT 1;
2	26.30 ms	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 Parameters: [`1559`] View formatted query View runnable query Explain query 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 = 1559 LIMIT 1;
3	26.44 ms	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 Parameters: [`13`] View formatted query View runnable query Explain query 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 = 13 LIMIT 1;

#▲

Time

Info

26.95 ms

SELECT t0.rec_id AS rec_id_1, t0.lastUpdate AS lastUpdate_2, t0.fCityID AS fCityID_3, t0.fName AS fName_4, t0.fNameUkr AS fNameUkr_5, t0.fTranslit AS fTranslit_6, t0.fTranslitRu AS fTranslitRu_7, t0.fStars AS fStars_8, t0.fStarsAdd AS fStarsAdd_9, t0.fCat AS fCat_10, t0.fBeach AS fBeach_11, t0.fForm AS fForm_12, t0.fArea AS fArea_13, t0.fPriority AS fPriority_14, t0.fSouthWest AS fSouthWest_15, t0.fNorthEast AS fNorthEast_16, t0.fZoom AS fZoom_17, t0.fPaid AS fPaid_18, t0.fActive AS fActive_19, t0.fRefsConfirm AS fRefsConfirm_20, t0.fRating AS fRating_21, t0.fReviews AS fReviews_22, t0.fTopRate AS fTopRate_23, t0.fAvgVotes AS fAvgVotes_24, t0.fLastMsgType AS fLastMsgType_25, t0.fLastMsgDate AS fLastMsgDate_26, t0.notFoundVideo AS notFoundVideo_27, t0.people AS people_28, t0.children AS children_29, t0.seniors AS seniors_30, t0.busines AS busines_31, t0.single AS single_32, t0.chainId AS chainId_33 FROM otpusk.tHotels t0 WHERE t0.rec_id = ? LIMIT 1

Parameters:

[
  23008
]

View formatted query View runnable query Explain query

SELECT
  t0.rec_id AS rec_id_1,
  t0.lastUpdate AS lastUpdate_2,
  t0.fCityID AS fCityID_3,
  t0.fName AS fName_4,
  t0.fNameUkr AS fNameUkr_5,
  t0.fTranslit AS fTranslit_6,
  t0.fTranslitRu AS fTranslitRu_7,
  t0.fStars AS fStars_8,
  t0.fStarsAdd AS fStarsAdd_9,
  t0.fCat AS fCat_10,
  t0.fBeach AS fBeach_11,
  t0.fForm AS fForm_12,
  t0.fArea AS fArea_13,
  t0.fPriority AS fPriority_14,
  t0.fSouthWest AS fSouthWest_15,
  t0.fNorthEast AS fNorthEast_16,
  t0.fZoom AS fZoom_17,
  t0.fPaid AS fPaid_18,
  t0.fActive AS fActive_19,
  t0.fRefsConfirm AS fRefsConfirm_20,
  t0.fRating AS fRating_21,
  t0.fReviews AS fReviews_22,
  t0.fTopRate AS fTopRate_23,
  t0.fAvgVotes AS fAvgVotes_24,
  t0.fLastMsgType AS fLastMsgType_25,
  t0.fLastMsgDate AS fLastMsgDate_26,
  t0.notFoundVideo AS notFoundVideo_27,
  t0.people AS people_28,
  t0.children AS children_29,
  t0.seniors AS seniors_30,
  t0.busines AS busines_31,
  t0.single AS single_32,
  t0.chainId AS chainId_33
FROM
  otpusk.tHotels t0
WHERE
  t0.rec_id = ?
LIMIT
  1

SELECT t0.rec_id AS rec_id_1, t0.lastUpdate AS lastUpdate_2, t0.fCityID AS fCityID_3, t0.fName AS fName_4, t0.fNameUkr AS fNameUkr_5, t0.fTranslit AS fTranslit_6, t0.fTranslitRu AS fTranslitRu_7, t0.fStars AS fStars_8, t0.fStarsAdd AS fStarsAdd_9, t0.fCat AS fCat_10, t0.fBeach AS fBeach_11, t0.fForm AS fForm_12, t0.fArea AS fArea_13, t0.fPriority AS fPriority_14, t0.fSouthWest AS fSouthWest_15, t0.fNorthEast AS fNorthEast_16, t0.fZoom AS fZoom_17, t0.fPaid AS fPaid_18, t0.fActive AS fActive_19, t0.fRefsConfirm AS fRefsConfirm_20, t0.fRating AS fRating_21, t0.fReviews AS fReviews_22, t0.fTopRate AS fTopRate_23, t0.fAvgVotes AS fAvgVotes_24, t0.fLastMsgType AS fLastMsgType_25, t0.fLastMsgDate AS fLastMsgDate_26, t0.notFoundVideo AS notFoundVideo_27, t0.people AS people_28, t0.children AS children_29, t0.seniors AS seniors_30, t0.busines AS busines_31, t0.single AS single_32, t0.chainId AS chainId_33 FROM otpusk.tHotels t0 WHERE t0.rec_id = 23008 LIMIT 1;

26.30 ms

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

Parameters:

[
  1559
]

View formatted query View runnable query Explain query

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

26.44 ms

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

Parameters:

[
  13
]

View formatted query View runnable query Explain query

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

otpusk connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
otpusk	doctrine.dbal.otpusk_connection

Entity Managers

Name	Service
auto_generate_proxy_classes	doctrine.orm.auto_generate_proxy_classes_entity_manager
auto_mapping	doctrine.orm.auto_mapping_entity_manager
default	doctrine.orm.default_entity_manager
otpusk	doctrine.orm.otpusk_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

auto_generate_proxy_classes entity manager

No loaded entities.

auto_mapping entity manager

No loaded entities.

default entity manager

Class	Mapping errors
App\Entity\AuctionRule	No errors.
App\Entity\ReturnRequests	No errors.
App\Entity\AuctionRequest	No errors.
App\EntityOtpusk\Tcities	No errors.
App\EntityOtpusk\Tcountries	The association App\EntityOtpusk\Tcountries#markets refers to the owning side field App\EntityOtpusk\Markets#country which does not exist.
App\EntityOtpusk\Tregions	The association App\EntityOtpusk\Tregions#region refers to the inverse side field App\EntityOtpusk\Tregions#regions which does not exist. The association App\EntityOtpusk\Tregions#city refers to the owning side field App\EntityOtpusk\Tcities#region which does not exist.
App\Entity\ManagerLogs	No errors.
App\EntityOtpusk\Thotels	No errors.
App\EntityOtpusk\Cruises	No errors.
App\Entity\BlackList	No errors.
App\EntityOtpusk\Markets	No errors.

otpusk entity manager

Class	Mapping errors
App\EntityOtpusk\Tcities	No errors.
App\EntityOtpusk\Tcountries	The association App\EntityOtpusk\Tcountries#markets refers to the owning side field App\EntityOtpusk\Markets#country which does not exist.
App\EntityOtpusk\Thotels	No errors.
App\EntityOtpusk\Cruises	No errors.

Symfony Profiler

https://staging.auction.dev.otpusk.odev.io/api/stats?action=3&checkIn=&cid=861476471.1748884308&countryId=13&food=&fromCity=&id=23008&nights=&operatorId=&position=1&price=undefined&roomId=&sid=s1751544950%24o2%24g0%24t1751544950%24j60%24l0%24h0&source=1&transport=

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

otpusk connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

auto_generate_proxy_classes entity manager

auto_mapping entity manager

default entity manager

otpusk entity manager