Query Metrics
3
Database Queries
3
Different statements
79.69 ms
Query time
3
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
26.95 ms (0.00%) |
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 = ? LIMIT 1
Parameters:
[
23008
]
|
|
26.44 ms (0.00%) |
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
Parameters:
[
13
]
|
|
26.30 ms (0.00%) |
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 = ? LIMIT 1
Parameters:
[
1559
]
|
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 |
|
| App\EntityOtpusk\Tregions |
|
| 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 |
|
| App\EntityOtpusk\Thotels | No errors. |
| App\EntityOtpusk\Cruises | No errors. |