Query Metrics
144
Database Queries
16
Different statements
72.44 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.08 ms |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.exclusive AS exclusive_3, t0.name AS name_4, t0.seotitle AS seotitle_5, t0.seodesc AS seodesc_6, t0.metaKeywords AS metaKeywords_7, t0.areaMin AS areaMin_8, t0.areaMax AS areaMax_9, t0.priceMin AS priceMin_10, t0.priceMax AS priceMax_11, t0.homesteadMin AS homesteadMin_12, t0.homesteadMax AS homesteadMax_13, t0.mkaddistMin AS mkaddistMin_14, t0.mkaddistMax AS mkaddistMax_15, t0.roomsMin AS roomsMin_16, t0.roomsMax AS roomsMax_17, t0.text AS text_18, t0.seotext1 AS seotext1_19, t0.seotext2 AS seotext2_20, t0.h1 AS h1_21, t0.District3_id AS District3_id_22, t0.Subway2_id AS Subway2_id_23, t0.Area2_id AS Area2_id_24, t0.TypeHouse_id AS TypeHouse_id_25, t0.SaleType_id AS SaleType_id_26, t0.Stage_id AS Stage_id_27, t0.Highway_id AS Highway_id_28, t0.Settlement_id AS Settlement_id_29, t0.Country_id AS Country_id_30, t0.CountryCity_id AS CountryCity_id_31, t0.TypeOperation_id AS TypeOperation_id_32, t0.TypeLot_id AS TypeLot_id_33 FROM FilterPreset t0 WHERE t0.alias = ?
Parameters:
[
"elit_kvartiry"
]
|
| 2 | 0.70 ms |
SELECT t0.id AS id_1, t0.route AS route_2, t0.description AS description_3, t0.title AS title_4, t0.text AS text_5 FROM SeoText t0 WHERE t0.route = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
"/elit_kvartiry?page=7&text=%D1%82%D0%B5%D0%B0%D1%82%D1%80%D0%B0%D0%BB%D1%8C%D0%BD%D1%8B%D0%B9%2B%D0%B4%D0%BE%D0%BC"
]
|
| 3 | 0.67 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.seoLabelFirst AS seoLabelFirst_5, t0.seoLabelSecond AS seoLabelSecond_6, t0.titleRent AS titleRent_7, t0.descriptionRent AS descriptionRent_8, t0.keywordsRent AS keywordsRent_9, t0.seoLabelRentFirst AS seoLabelRentFirst_10, t0.seoLabelRentSecond AS seoLabelRentSecond_11, t0.h1 AS h1_12, t0.h1Rent AS h1Rent_13 FROM City t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 4 | 1.33 ms |
SELECT count(l0_.id) AS sclr_0 FROM Lot l0_ WHERE l0_.typeLotId = ? AND l0_.typeOperationId = ? AND l0_.showLot = 1
Parameters:
[ 1 1 ] |
| 5 | 2.41 ms |
SELECT l0_.id AS id_0, l0_.district3Id AS district3Id_1, l0_.addressId AS addressId_2, l0_.subway2Id AS subway2Id_3, l0_.comment AS comment_4, l0_.freePlan AS freePlan_5, l0_.rooms AS rooms_6, l0_.price AS price_7, l0_.lastPrice AS lastPrice_8, l0_.oldPrice AS oldPrice_9, l0_.originalPrice AS originalPrice_10, l0_.area AS area_11, l0_.mkadDistance AS mkadDistance_12, l0_.exclusive AS exclusive_13, l0_.bedrooms AS bedrooms_14, l0_.wc AS wc_15, l0_.repair AS repair_16, l0_.stype AS stype_17, l0_.floor AS floor_18, l0_.floorAll AS floorAll_19, l0_.livArea AS livArea_20, l0_.kitArea AS kitArea_21, l0_.description AS description_22, l0_.pdfDescription AS pdfDescription_23, l0_.homesteadArea AS homesteadArea_24, l0_.video AS video_25, l0_.commission AS commission_26, l0_.clientCommission AS clientCommission_27, l0_.typeLotId AS typeLotId_28, l0_.propertyTypeId AS propertyTypeId_29, l0_.stageHouseId AS stageHouseId_30, l0_.typeHouseId AS typeHouseId_31, l0_.districtId AS districtId_32, l0_.complexId AS complexId_33, l0_.settlementId AS settlementId_34, l0_.highwayId AS highwayId_35, l0_.countryId AS countryId_36, l0_.typeOperationId AS typeOperationId_37, l0_.businessId AS businessId_38, l0_.countryCityId AS countryCityId_39, l0_.date AS date_40, l0_.currency AS currency_41, l0_.showDifference AS showDifference_42, l0_.isNew AS isNew_43, l0_.dollars AS dollars_44, l0_.bid AS bid_45, l0_.furnishing AS furnishing_46, l0_.virtualTourLink AS virtualTourLink_47, l0_.virtualTourImage AS virtualTourImage_48, l0_.saleDate AS saleDate_49, l0_.showLot AS showLot_50, l0_.target AS target_51, l0_.contractType AS contractType_52, l0_.commerceType AS commerceType_53, l0_.cianPremium AS cianPremium_54, l0_.cianTop3 AS cianTop3_55, l0_.suburbanZone AS suburbanZone_56, l0_.notshowLotinCian AS notshowLotinCian_57, l0_.forDay AS forDay_58, l0_.prepay AS prepay_59, l0_.deposit AS deposit_60, l0_.mebelKitchen AS mebelKitchen_61, l0_.rfgr AS rfgr_62, l0_.pets AS pets_63, l0_.kids AS kids_64, l0_.tv AS tv_65, l0_.wm AS wm_66, l0_.lodgia AS lodgia_67, l0_.balcony AS balcony_68, l0_.elevators AS elevators_69, l0_.rentComunnalka AS rentComunnalka_70, l0_.rentComunnalkaSum AS rentComunnalkaSum_71, l0_.rentPledge AS rentPledge_72, l0_.yandexCoord AS yandexCoord_73, l0_.x AS x_74, l0_.y AS y_75, l0_.communications AS communications_76, l0_.advantage AS advantage_77, l0_.kvadroomVas AS kvadroomVas_78, l0_.notshowLotinYandex AS notshowLotinYandex_79, l0_.pervichkaVtorichka AS pervichkaVtorichka_80, l0_.bet AS bet_81, l0_.typeOperationId AS typeOperationId_82, l0_.structureTypeId AS structureTypeId_83, l0_.structureTypeId AS structureTypeId_84, l0_.adminAreaId AS adminAreaId_85, l0_.typeLotId AS typeLotId_86, l0_.propertyTypeId AS propertyTypeId_87, l0_.stageHouseId AS stageHouseId_88, l0_.typeHouseId AS typeHouseId_89, l0_.districtId AS districtId_90, l0_.subway2Id AS subway2Id_91, l0_.area2Id AS area2Id_92, l0_.district3Id AS district3Id_93, l0_.complexId AS complexId_94, l0_.settlementId AS settlementId_95, l0_.highwayId AS highwayId_96, l0_.countryId AS countryId_97, l0_.businessId AS businessId_98, l0_.countryCityId AS countryCityId_99, l0_.addressId AS addressId_100 FROM Lot l0_ WHERE l0_.typeLotId = ? AND l0_.typeOperationId = ? AND l0_.showLot = 1 ORDER BY l0_.date DESC LIMIT 10 OFFSET 60
Parameters:
[ 1 1 ] |
| 6 | 5.13 ms |
SELECT t0.id AS id_1, t0.district3Id AS district3Id_2, t0.addressId AS addressId_3, t0.subway2Id AS subway2Id_4, t0.comment AS comment_5, t0.freePlan AS freePlan_6, t0.rooms AS rooms_7, t0.price AS price_8, t0.lastPrice AS lastPrice_9, t0.oldPrice AS oldPrice_10, t0.originalPrice AS originalPrice_11, t0.area AS area_12, t0.mkadDistance AS mkadDistance_13, t0.exclusive AS exclusive_14, t0.bedrooms AS bedrooms_15, t0.wc AS wc_16, t0.repair AS repair_17, t0.stype AS stype_18, t0.floor AS floor_19, t0.floorAll AS floorAll_20, t0.livArea AS livArea_21, t0.kitArea AS kitArea_22, t0.description AS description_23, t0.pdfDescription AS pdfDescription_24, t0.homesteadArea AS homesteadArea_25, t0.video AS video_26, t0.commission AS commission_27, t0.clientCommission AS clientCommission_28, t0.typeLotId AS typeLotId_29, t0.propertyTypeId AS propertyTypeId_30, t0.stageHouseId AS stageHouseId_31, t0.typeHouseId AS typeHouseId_32, t0.districtId AS districtId_33, t0.complexId AS complexId_34, t0.settlementId AS settlementId_35, t0.highwayId AS highwayId_36, t0.countryId AS countryId_37, t0.typeOperationId AS typeOperationId_38, t0.businessId AS businessId_39, t0.countryCityId AS countryCityId_40, t0.date AS date_41, t0.currency AS currency_42, t0.showDifference AS showDifference_43, t0.isNew AS isNew_44, t0.dollars AS dollars_45, t0.bid AS bid_46, t0.furnishing AS furnishing_47, t0.virtualTourLink AS virtualTourLink_48, t0.virtualTourImage AS virtualTourImage_49, t0.saleDate AS saleDate_50, t0.showLot AS showLot_51, t0.target AS target_52, t0.contractType AS contractType_53, t0.commerceType AS commerceType_54, t0.cianPremium AS cianPremium_55, t0.cianTop3 AS cianTop3_56, t0.suburbanZone AS suburbanZone_57, t0.notshowLotinCian AS notshowLotinCian_58, t0.forDay AS forDay_59, t0.prepay AS prepay_60, t0.deposit AS deposit_61, t0.mebelKitchen AS mebelKitchen_62, t0.rfgr AS rfgr_63, t0.pets AS pets_64, t0.kids AS kids_65, t0.tv AS tv_66, t0.wm AS wm_67, t0.lodgia AS lodgia_68, t0.balcony AS balcony_69, t0.elevators AS elevators_70, t0.rentComunnalka AS rentComunnalka_71, t0.rentComunnalkaSum AS rentComunnalkaSum_72, t0.rentPledge AS rentPledge_73, t0.yandexCoord AS yandexCoord_74, t0.x AS x_75, t0.y AS y_76, t0.communications AS communications_77, t0.advantage AS advantage_78, t0.kvadroomVas AS kvadroomVas_79, t0.notshowLotinYandex AS notshowLotinYandex_80, t0.pervichkaVtorichka AS pervichkaVtorichka_81, t0.bet AS bet_82, t0.typeOperationId AS typeOperationId_83, t0.structureTypeId AS structureTypeId_84, t0.structureTypeId AS structureTypeId_85, t0.adminAreaId AS adminAreaId_86, t0.typeLotId AS typeLotId_87, t0.propertyTypeId AS propertyTypeId_88, t0.stageHouseId AS stageHouseId_89, t0.typeHouseId AS typeHouseId_90, t0.districtId AS districtId_91, t0.subway2Id AS subway2Id_92, t0.area2Id AS area2Id_93, t0.district3Id AS district3Id_94, t0.complexId AS complexId_95, t0.settlementId AS settlementId_96, t0.highwayId AS highwayId_97, t0.countryId AS countryId_98, t0.businessId AS businessId_99, t0.countryCityId AS countryCityId_100, t0.addressId AS addressId_101 FROM Lot t0 WHERE t0.typeLotId = ? AND t0.typeOperationId = ? AND t0.showLot = ?
Parameters:
[ 1 1 1 ] |
| 7 | 1.04 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
252
]
|
| 8 | 0.84 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1218
]
|
| 9 | 0.62 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
17
]
|
| 10 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1117
]
|
| 11 | 0.48 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
86
]
|
| 12 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1361
]
|
| 13 | 0.44 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
45
]
|
| 14 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1149
]
|
| 15 | 0.48 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1299
]
|
| 16 | 0.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1265
]
|
| 17 | 0.41 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1942
]
|
| 18 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1532
]
|
| 19 | 0.29 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
62
]
|
| 20 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1147
]
|
| 21 | 0.31 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1639
]
|
| 22 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1261
]
|
| 23 | 0.39 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1831
]
|
| 24 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1299
]
|
| 25 | 0.40 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1770
]
|
| 26 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1450
]
|
| 27 | 0.37 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 28 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1186
]
|
| 29 | 0.43 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2099
]
|
| 30 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1520
]
|
| 31 | 0.29 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
828
]
|
| 32 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1173
]
|
| 33 | 0.31 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
250
]
|
| 34 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1200
]
|
| 35 | 0.31 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2103
]
|
| 36 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1610
]
|
| 37 | 0.28 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
807
]
|
| 38 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1142
]
|
| 39 | 0.43 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1778
]
|
| 40 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1250
]
|
| 41 | 0.35 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1929
]
|
| 42 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1342
]
|
| 43 | 0.28 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
65
]
|
| 44 | 0.30 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1911
]
|
| 45 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1192
]
|
| 46 | 0.31 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2020
]
|
| 47 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1286
]
|
| 48 | 0.30 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1800
]
|
| 49 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1300
]
|
| 50 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2030
]
|
| 51 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1456
]
|
| 52 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1743
]
|
| 53 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1447
]
|
| 54 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2032
]
|
| 55 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1568
]
|
| 56 | 0.29 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2007
]
|
| 57 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1559
]
|
| 58 | 0.30 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1944
]
|
| 59 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1533
]
|
| 60 | 0.29 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2038
]
|
| 61 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1574
]
|
| 62 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2040
]
|
| 63 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1577
]
|
| 64 | 0.29 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1526
]
|
| 65 | 0.29 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1413
]
|
| 66 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1307
]
|
| 67 | 0.28 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2025
]
|
| 68 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1296
]
|
| 69 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
31
]
|
| 70 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1366
]
|
| 71 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2058
]
|
| 72 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1283
]
|
| 73 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1499
]
|
| 74 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1136
]
|
| 75 | 0.32 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2069
]
|
| 76 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1591
]
|
| 77 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
287
]
|
| 78 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1160
]
|
| 79 | 0.27 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2076
]
|
| 80 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1144
]
|
| 81 | 0.29 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
49
]
|
| 82 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1156
]
|
| 83 | 0.38 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1492
]
|
| 84 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1238
]
|
| 85 | 0.38 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1910
]
|
| 86 | 0.37 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2081
]
|
| 87 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1599
]
|
| 88 | 0.31 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2083
]
|
| 89 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1600
]
|
| 90 | 0.40 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
63
]
|
| 91 | 0.38 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1874
]
|
| 92 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1507
]
|
| 93 | 0.41 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2088
]
|
| 94 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1214
]
|
| 95 | 0.39 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2089
]
|
| 96 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1373
]
|
| 97 | 0.39 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
492
]
|
| 98 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1163
]
|
| 99 | 0.45 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2098
]
|
| 100 | 0.46 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2101
]
|
| 101 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1608
]
|
| 102 | 0.39 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2096
]
|
| 103 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1605
]
|
| 104 | 0.53 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
820
]
|
| 105 | 0.82 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1280
]
|
| 106 | 0.47 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
832
]
|
| 107 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1301
]
|
| 108 | 0.41 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2106
]
|
| 109 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1612
]
|
| 110 | 0.40 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2107
]
|
| 111 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1293
]
|
| 112 | 0.38 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1643
]
|
| 113 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1363
]
|
| 114 | 0.40 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2109
]
|
| 115 | 0.43 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1491
]
|
| 116 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1157
]
|
| 117 | 0.53 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
1512
]
|
| 118 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1325
]
|
| 119 | 0.44 ms |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2113
]
|
| 120 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1616
]
|
| 121 | 3.27 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM Lot l1_ LEFT JOIN Subway2 s0_ ON (s0_.id = l1_.subway2Id) WHERE l1_.typeOperationId = 1 AND l1_.showLot = 1 AND l1_.typeLotId = 1 ORDER BY s0_.name ASC
Parameters:
[] |
| 122 | 2.94 ms |
SELECT DISTINCT d0_.id AS id_0, d0_.name AS name_1 FROM Lot l1_ LEFT JOIN District3 d0_ ON (d0_.id = l1_.district3Id) WHERE l1_.typeOperationId = 1 AND l1_.showLot = 1 AND l1_.typeLotId = 1 ORDER BY d0_.name ASC
Parameters:
[] |
| 123 | 0.79 ms |
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3, t0.typeLot AS typeLot_4 FROM TypeHouse t0 WHERE t0.typeLot = ?
Parameters:
[
1
]
|
| 124 | 0.57 ms |
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3 FROM StageHouse t0
Parameters:
[] |
| 125 | 1.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.landing_id AS landing_id_3, t0.cian_id AS cian_id_4, t0.landing_id AS landing_id_5 FROM Complex t0
Parameters:
[] |
| 126 | 0.65 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Tag t0
Parameters:
[] |
| 127 | 0.77 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
3256
]
|
| 128 | 0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 129 | 0.91 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
3261
]
|
| 130 | 0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters:
[
23
]
|
| 131 | 0.71 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
1727
]
|
| 132 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters:
[
55
]
|
| 133 | 0.45 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
3179
]
|
| 134 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 135 | 0.42 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
2511
]
|
| 136 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters:
[
17
]
|
| 137 | 0.41 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
2725
]
|
| 138 | 0.43 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
3335
]
|
| 139 | 0.39 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
665
]
|
| 140 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 141 | 0.44 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
3189
]
|
| 142 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters:
[
19
]
|
| 143 | 0.63 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isPlanning AS isPlanning_3, t0.isMain AS isMain_4, t0.deleteIt AS deleteIt_5, t0.lot AS lot_6 FROM Photo t0 WHERE t0.lot = ? ORDER BY t0.isMain DESC
Parameters:
[
3132
]
|
| 144 | 0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters:
[
5
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Troika\MainBundle\Entity\FilterPreset | No errors. |
| Troika\MainBundle\Entity\District3 | No errors. |
| Troika\MainBundle\Entity\Subway2 | No errors. |
| Troika\MainBundle\Entity\Area2 | No errors. |
| Troika\MainBundle\Entity\TypeHouse | No errors. |
| Troika\MainBundle\Entity\SaleType | No errors. |
| Troika\MainBundle\Entity\StageHouse | No errors. |
| Troika\MainBundle\Entity\Highway | No errors. |
| Troika\MainBundle\Entity\Settlement | No errors. |
| Troika\MainBundle\Entity\Country | No errors. |
| Troika\MainBundle\Entity\CountryCity | No errors. |
| Troika\MainBundle\Entity\TypeOperation | No errors. |
| Troika\MainBundle\Entity\TypeLot | No errors. |
| Troika\MainBundle\Entity\SeoText | No errors. |
| Troika\MainBundle\Entity\City | No errors. |
| Troika\MainBundle\Entity\Lot |
|
| Troika\MainBundle\Entity\StructureType | No errors. |
| Troika\MainBundle\Entity\AdminArea | No errors. |
| Troika\MainBundle\Entity\PropertyType | No errors. |
| Troika\MainBundle\Entity\District | No errors. |
| Troika\MainBundle\Entity\Complex | No errors. |
| Troika\MainBundle\Entity\BusinessCenter | No errors. |
| Troika\MainBundle\Entity\Address | No errors. |
| Troika\MainBundle\Entity\Photo | No errors. |
| Troika\MainBundle\Entity\FieldGroup | No errors. |
| Troika\MainBundle\Entity\PartnerPhoto | No errors. |
| Troika\MainBundle\Entity\Tag | No errors. |
| Troika\MainBundle\Entity\LandingInfrastructureItems | No errors. |
| Troika\MainBundle\Entity\Street | No errors. |
| Troika\MainBundle\Entity\Landing | No errors. |