https://www.troikaestate.ru/

Method
GET
HTTP Status
200
IP
52.167.144.235
Profiled on
Token
19661c

Query Metrics

80 Database Queries
37 Different statements
77.90 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 6.28 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_.showLot = 1 ORDER BY l0_.date DESC LIMIT 3
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
2 1.77 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_.showLot = 1 ORDER BY l0_.date DESC LIMIT 3
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
3 1.20 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_.showLot = 1 ORDER BY l0_.date DESC LIMIT 3
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
4 1.50 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_.showLot = 1 ORDER BY l0_.date DESC LIMIT 3
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
5 0.71 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.active AS active_4 FROM MenuItem t0 WHERE t0.active = ? ORDER BY t0.id DESC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
6 0.58 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.content AS content_5 FROM Home t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
7 1.20 ms 
SELECT t0.id AS id_1, t0.metaTitle AS metaTitle_2, t0.metaDescription AS metaDescription_3, t0.metaKeywords AS metaKeywords_4, t0.description AS description_5, t0.Header1 AS Header1_6, t0.Text1 AS Text1_7, t0.PromoHeader1 AS PromoHeader1_8, t0.PromoNHeader1 AS PromoNHeader1_9, t0.PromoText1 AS PromoText1_10, t0.PromoComplex1 AS PromoComplex1_11, t0.promoHeader2 AS promoHeader2_12, t0.PromoText2 AS PromoText2_13, t0.Apart AS Apart_14, t0.Parking AS Parking_15, t0.Child AS Child_16, t0.Infra AS Infra_17, t0.Diz AS Diz_18, t0.Complex2 AS Complex2_19, t0.PromoImg1 AS PromoImg1_20, t0.PromoImg2 AS PromoImg2_21, t0.Link1 AS Link1_22, t0.Ico1 AS Ico1_23, t0.Ico2 AS Ico2_24, t0.Ico3 AS Ico3_25, t0.Ico4 AS Ico4_26, t0.Ico5 AS Ico5_27, t0.LastHeader AS LastHeader_28, t0.LastText AS LastText_29, t0.promoType AS promoType_30, t0.complex AS complex_31, t0.settlement AS settlement_32, t0.business AS business_33, t0.country AS country_34, t0.filter AS filter_35 FROM MainPage t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
8 0.82 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.name2 AS name2_3, t0.link AS link_4, t0.imgLink AS imgLink_5 FROM TagSlot t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
9 0.80 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
Parameters: 
[]
View formatted query    View runnable query    Explain query
10 5.84 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: 
[]
View formatted query    View runnable query    Explain query
11 1.76 ms 
SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM Lot l1_ LEFT JOIN Settlement s0_ ON (s0_.id = l1_.settlementId) WHERE l1_.typeOperationId = 1 AND l1_.showLot = 1 AND l1_.typeLotId = 2 ORDER BY s0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
12 1.57 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 = 2 AND l1_.showLot = 1 AND l1_.typeLotId = 1 ORDER BY d0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
13 1.11 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 = 3 ORDER BY d0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
14 1.04 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 = 2 AND l1_.showLot = 1 AND l1_.typeLotId = 3 ORDER BY d0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
15 1.09 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 = 3 ORDER BY s0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 1.55 ms 
SELECT DISTINCT h0_.id AS id_0, h0_.name AS name_1 FROM Lot l1_ LEFT JOIN Highway h0_ ON (h0_.id = l1_.highwayId) WHERE l1_.typeOperationId = 1 AND l1_.showLot = 1 AND l1_.typeLotId = 2 ORDER BY h0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
17 1.22 ms 
SELECT DISTINCT h0_.id AS id_0, h0_.name AS name_1 FROM Lot l1_ LEFT JOIN Highway h0_ ON (h0_.id = l1_.highwayId) WHERE l1_.typeOperationId = 2 AND l1_.showLot = 1 AND l1_.typeLotId = 2 ORDER BY h0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 1.22 ms 
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1 FROM Lot l1_ LEFT JOIN Country c0_ ON (c0_.id = l1_.countryId) WHERE l1_.typeOperationId = 1 AND l1_.showLot = 1 AND l1_.typeLotId = 4 ORDER BY c0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
19 0.95 ms 
SELECT DISTINCT c0_.id AS id_0, c0_.name AS name_1 FROM Lot l1_ LEFT JOIN Country c0_ ON (c0_.id = l1_.countryId) WHERE l1_.typeOperationId = 2 AND l1_.showLot = 1 AND l1_.typeLotId = 4 ORDER BY c0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 0.45 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.comments AS comments_4, t0.visits AS visits_5, t0.date AS date_6, t0.link AS link_7, t0.img AS img_8 FROM Blog t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
21 1.72 ms 
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM ComplexPage c0_ WHERE c0_.isVisible = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 0.85 ms 
SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM ComplexPage c0_ WHERE c0_.isVisible = 1 ORDER BY c0_.id DESC LIMIT 10
Parameters: 
[]
View formatted query    View runnable query    Explain query
23 1.13 ms 
SELECT c0_.id AS id_0, c0_.seoTitle AS seoTitle_1, c0_.seoDescription AS seoDescription_2, c0_.seoKeywords AS seoKeywords_3, c0_.name AS name_4, c0_.url AS url_5, c0_.final AS final_6, c0_.price AS price_7, c0_.isVisible AS isVisible_8, c0_.priceForMeter AS priceForMeter_9, c0_.lat AS lat_10, c0_.lng AS lng_11, c0_.content AS content_12, c0_.complex AS complex_13, c0_.subway2Id AS subway2Id_14, c0_.area2Id AS area2Id_15, c0_.addressId AS addressId_16, c0_.typeComplexId AS typeComplexId_17, c0_.stageComplexId AS stageComplexId_18 FROM ComplexPage c0_ WHERE c0_.isVisible = 1 AND c0_.id IN (?) ORDER BY c0_.id DESC
Parameters: 
[
  [
    103
    102
    101
    100
    99
    98
    97
    96
    95
    94
  ]
]
View formatted query    View runnable query    Explain query
24 2.41 ms 
SELECT t0.id AS id_1, t0.seoTitle AS seoTitle_2, t0.seoDescription AS seoDescription_3, t0.seoKeywords AS seoKeywords_4, t0.name AS name_5, t0.url AS url_6, t0.final AS final_7, t0.price AS price_8, t0.isVisible AS isVisible_9, t0.priceForMeter AS priceForMeter_10, t0.lat AS lat_11, t0.lng AS lng_12, t0.content AS content_13, t0.complex AS complex_14, t0.subway2Id AS subway2Id_15, t0.area2Id AS area2Id_16, t0.addressId AS addressId_17, t0.typeComplexId AS typeComplexId_18, t0.stageComplexId AS stageComplexId_19 FROM ComplexPage t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
25 0.67 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM Area2 t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
26 0.74 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.cianId AS cianId_3 FROM Subway2 t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
27 1.36 ms 
SELECT count(l0_.id) AS sclr_0 FROM Lot l0_ WHERE l0_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query
28 5.86 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_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query
29 2.12 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_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC LIMIT 10
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query
30 0.82 ms 
SELECT count(l0_.id) AS sclr_0 FROM Lot l0_ WHERE l0_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC
Parameters: 
[
  1
  2
]
View formatted query    View runnable query    Explain query
31 2.28 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_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC
Parameters: 
[
  1
  2
]
View formatted query    View runnable query    Explain query
32 2.33 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_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC LIMIT 10
Parameters: 
[
  1
  2
]
View formatted query    View runnable query    Explain query
33 1.10 ms 
SELECT count(l0_.id) AS sclr_0 FROM Lot l0_ WHERE l0_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC
Parameters: 
[
  1
  3
]
View formatted query    View runnable query    Explain query
34 1.84 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_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC
Parameters: 
[
  1
  3
]
View formatted query    View runnable query    Explain query
35 1.96 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_.typeOperationId = ? AND l0_.showLot = 1 AND l0_.typeLotId = ? ORDER BY l0_.date DESC LIMIT 10
Parameters: 
[
  1
  3
]
View formatted query    View runnable query    Explain query
36 0.74 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 WHERE t0.id = ?
Parameters: 
[
  345
]
View formatted query    View runnable query    Explain query
37 1.02 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.complexId = ?
Parameters: 
[
  345
]
View formatted query    View runnable query    Explain query
38 0.66 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: 
[
  3598
]
View formatted query    View runnable query    Explain query
39 0.54 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: 
[
  3599
]
View formatted query    View runnable query    Explain query
40 0.52 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: 
[
  3600
]
View formatted query    View runnable query    Explain query
41 0.48 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: 
[
  3601
]
View formatted query    View runnable query    Explain query
42 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: 
[
  3595
]
View formatted query    View runnable query    Explain query
43 0.38 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 WHERE t0.id = ?
Parameters: 
[
  344
]
View formatted query    View runnable query    Explain query
44 0.33 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
45 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: 
[
  3451
]
View formatted query    View runnable query    Explain query
46 0.34 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 WHERE t0.id = ?
Parameters: 
[
  319
]
View formatted query    View runnable query    Explain query
47 0.29 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
48 0.38 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: 
[
  3547
]
View formatted query    View runnable query    Explain query
49 0.30 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 WHERE t0.id = ?
Parameters: 
[
  336
]
View formatted query    View runnable query    Explain query
50 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM District3 t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
51 0.40 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: 
[
  3594
]
View formatted query    View runnable query    Explain query
52 0.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.landing_id AS landing_id_5, t0.landing_id AS landing_id_6 FROM Settlement t0 WHERE t0.id = ?
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query
53 0.36 ms 
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3, t0.cianId AS cianId_4, t0.onSite AS onSite_5 FROM Highway t0 WHERE t0.id = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query
54 0.40 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: 
[
  3591
]
View formatted query    View runnable query    Explain query
55 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: 
[
  861
]
View formatted query    View runnable query    Explain query
56 0.43 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.landing_id AS landing_id_5, t0.landing_id AS landing_id_6 FROM Settlement t0 WHERE t0.id = ?
Parameters: 
[
  217
]
View formatted query    View runnable query    Explain query
57 0.32 ms 
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3, t0.cianId AS cianId_4, t0.onSite AS onSite_5 FROM Highway t0 WHERE t0.id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
58 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: 
[
  3469
]
View formatted query    View runnable query    Explain query
59 0.35 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.landing_id AS landing_id_5, t0.landing_id AS landing_id_6 FROM Settlement t0 WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
60 0.50 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: 
[
  3096
]
View formatted query    View runnable query    Explain query
61 0.33 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: 
[
  2006
]
View formatted query    View runnable query    Explain query
62 0.42 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters: 
[
  1558
]
View formatted query    View runnable query    Explain query
63 0.30 ms 
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3 FROM Country t0 WHERE t0.id = ?
Parameters: 
[
  436
]
View formatted query    View runnable query    Explain query
64 0.29 ms 
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3 FROM CountryCity t0 WHERE t0.id = ?
Parameters: 
[
  448
]
View formatted query    View runnable query    Explain query
65 0.47 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: 
[
  3091
]
View formatted query    View runnable query    Explain query
66 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: 
[
  2004
]
View formatted query    View runnable query    Explain query
67 0.28 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters: 
[
  1555
]
View formatted query    View runnable query    Explain query
68 0.30 ms 
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3 FROM Country t0 WHERE t0.id = ?
Parameters: 
[
  51
]
View formatted query    View runnable query    Explain query
69 0.30 ms 
SELECT t0.id AS id_1, t0.bid AS bid_2, t0.name AS name_3 FROM CountryCity t0 WHERE t0.id = ?
Parameters: 
[
  447
]
View formatted query    View runnable query    Explain query
70 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: 
[
  3092
]
View formatted query    View runnable query    Explain query
71 0.47 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: 
[
  3590
]
View formatted query    View runnable query    Explain query
72 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: 
[
  472
]
View formatted query    View runnable query    Explain query
73 0.34 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters: 
[
  1363
]
View formatted query    View runnable query    Explain query
74 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM BusinessCenter t0 WHERE t0.id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
75 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: 
[
  3537
]
View formatted query    View runnable query    Explain query
76 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: 
[
  2092
]
View formatted query    View runnable query    Explain query
77 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters: 
[
  1354
]
View formatted query    View runnable query    Explain query
78 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: 
[
  3538
]
View formatted query    View runnable query    Explain query
79 0.33 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: 
[
  2093
]
View formatted query    View runnable query    Explain query
80 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters: 
[
  1149
]
View formatted query    View runnable query    Explain query

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\Lot
  • The association Troika\MainBundle\Entity\Lot#infrastructures refers to the inverse side field Troika\MainBundle\Entity\LandingInfrastructureItems#landing which does not exist.
Troika\MainBundle\Entity\TypeOperation No errors.
Troika\MainBundle\Entity\StructureType No errors.
Troika\MainBundle\Entity\SaleType No errors.
Troika\MainBundle\Entity\AdminArea No errors.
Troika\MainBundle\Entity\TypeLot No errors.
Troika\MainBundle\Entity\PropertyType No errors.
Troika\MainBundle\Entity\StageHouse No errors.
Troika\MainBundle\Entity\TypeHouse No errors.
Troika\MainBundle\Entity\District No errors.
Troika\MainBundle\Entity\Subway2 No errors.
Troika\MainBundle\Entity\Area2 No errors.
Troika\MainBundle\Entity\District3 No errors.
Troika\MainBundle\Entity\Complex No errors.
Troika\MainBundle\Entity\Settlement No errors.
Troika\MainBundle\Entity\Highway No errors.
Troika\MainBundle\Entity\Country No errors.
Troika\MainBundle\Entity\BusinessCenter No errors.
Troika\MainBundle\Entity\CountryCity 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\MenuItem No errors.
Troika\MainBundle\Entity\Home No errors.
Troika\MainBundle\Entity\MainPage No errors.
Troika\MainBundle\Entity\FilterPreset No errors.
Troika\MainBundle\Entity\TagSlot No errors.
Troika\MainBundle\Entity\Blog No errors.
Troika\MainBundle\Entity\ComplexPage No errors.
Troika\MainBundle\Entity\TypeComplex No errors.
Troika\MainBundle\Entity\StageComplex No errors.
Troika\MainBundle\Entity\ComplexPhoto No errors.
Troika\MainBundle\Entity\ComplexOrders No errors.
Troika\MainBundle\Entity\Landing No errors.
Troika\MainBundle\Entity\Street No errors.
dobrowin | betleao | moverbet | winzada 777 | supremo | casadeapostas | dobrowin | betleao | moverbet | wazamba | fezbet | betsson | lvbet | dobrowin | betsul | pixbet | bwin | betobet | dobrowin | bet7 | betcris | blaze | 888 | betano | stake | stake | esportesdasorte | betmotion | rivalry | novibet | pinnacle | cbet | dobrowin | betleao | moverbet | gogowin | jogos win | campobet | mesk bet | infinity bet | betfury | doce | bet7k | jogowin | lobo888 | iribet | leao | dobrowin | allwin | aajogo | pgwin | greenbets | brapub | moverbet | onebra | flames | brdice | brwin | poplottery | queens | winbrl | omgbet | winbra | goinbet | codbet | betleao | fuwin | allwin568 | wingdus | juntosbet | today | talon777 | brlwin | fazobetai | pinup bet | bet sport | bet esporte | mrbet | premier bet | apostebet | spicy bet | prosport bet | bet nacional | luck | jogodeouro | heads bet | marjack bet | apostaganha | gbg bet | esoccer bet | esport bet | realbet | aposte e ganhe | aviator aposta | bet vitoria | imperador bet | realsbet | bet favorita | esportenet | flames bet | pague bet | betsury | doce888 | obabet | winzada | globalbet | bet77 | lottoland | 7gamesbet | dicasbet | esportivabet | tvbet | sportbet | misterjackbet | esportebet | nacionalbet | simplesbet | betestrela | batbet | Pk55 | Bet61 | Upsports Bet | roleta online | roleta | poker online | poker | blackjack online | bingo | 12bet | 33win | bet168 | bk8 | bong88 | bong99 | fcb8 | hb88 | hotlive | ibet888 | k8 | kubet77 | kubet | lode88 | mig8 | nbet | onebox63 | oxbet | s666 | sbobet | suncity | vwin | w88 | win2888 | zbet | xoso66 | zowin | sun | top88 | vnloto | 11bet | bet69 | 8xbet | Ceará | Paysandu | Juventude | Bahia | Sport | Cuiabá | Coritiba | Criciúma | Vitória | Fortaleza | Corinthians | São Paulo | Vasco | Grêmio | Fluminense | Cruzeiro | Botafogo | Flamengo | bingo slots | slots slots | hacker do slot | pg slot demo | slot win | pg slot soft | arne slot | riqueza slots | slots 777 | pg slot | 777 slot game | slot pg soft | hacker slot | 777 slots | slot-pg-soft | fortune ox demo grátis | demo fortune ox | fortune mouse demo | fortune ox demo | jogo fortune tiger | fortune tiger grátis | fortune tiger baixar | fortune tiger demo grátis | fortune tiger demo | fortune tiger 777 | 580bet | bet 7k | leao | luck 2 | john bet | 7755 bet | cbet | bet7 | pk55 | 8800 bet | doce | bet 4 | f12bet | bet7 | ggbet | bet77 | mrbet | bet61 | tvbet | pgwin | today | fuwin | brwin | bet7k | tv bet | allwin | stake | bwin 789 | lvbet | blaze | dj bet | umbet | b1bet | 20bet | bk bet | h2bet | 7kbet | fbbet | 9d bet | 9k bet | 73 bet | ktobet | 74 bet | betpix | betvip | batbet | onabet | f12bet | codbet | winbra | b2xbet | obabet | brlwin | onebra | winbrl | omgbet | queens | brdice | brapub | flames | betano | aajogo | iribet | pixbet | betsul | fezbet | curso beta | betway | bkbet | peixe beta | bet365 | pixbet | 4 play bet | 365bet | brxbet | 939 bet | seubet | cnc bet | gbg bet | 522bet | brl bet | pagbet | jonbet | jqk bet | 166bet | abc bet | bggbet | obabet | 136bet | mmabet | win bet | ir6 bet | 667bet | qqq bet | 193 bet | 3ss bet | 317 bet | kkk bet | 585 bet | 569 bet | vai bet | aaa bet | 969 bet | z11 bet | kw bet | 26 bet | mj bet | betio | 01 bet | ut bet | 9y bet | bet70 | f9 bet | hw bet | kg bet | 5e bet | bet br | hr bet | br bet | 75 bet | 03 bet | 6z bet | 6r bet | v6 bet | 78 bet | bt bet | 80 bet | 8g bet | 72 bet | xp bet | f12 bet | p9 bet | 5 bet | 4 bet | bet 4 | r7 bet | um bet | 29 bet | 5s bet | ck bet | pg bet | ea bet | 23 bet | bl bet | 3l bet | 2a bet | p7 bet | 888 bet | 707 bet | 361 bet | bet29 | 700 bet | 161 bet | bet777 | up bet | 58 bet | nn bet | 67 bet | 22 bet | 9g bet | 1x bet | bet10 | 70 bet | 2h bet | 9r bet | 16 bet | 81 bet | 7 bet | 5u bet | 6k bet | mg bet | b1 bet | 5h bet | je- bet | joya | hopa | nomini | ls bet | 1xbit | platin | ice bet | rant | bet us | bet go | 31 bet | slingo | flush | ice36 | weiss | bet9 | rabona | i bet | starda | dreams | bongo | snatch | 10 bet | daddy | metal | zep bet | drip | gama | drake | verde | shazam | wish | thor | exclusive | sol | highway | 500 casino | jazz | howl | supernova | sherbet | fresh | daddy | jet | wish | eclipse | inplay | drip | marvel | stake | scorpion | luxebet | drake | thor | puma | winzir | loki | shazam | rivalry | f1 casino | xgbet | sushi | bk8 | art casino | manga | pgasia | gemini | bingoplus | slot vip | help slot win | 8k8 slot | tadhana slot | jili slot | 55bmw slot | vip slot | nn777 slot | jili slot 777 | tg777 slot | w500 slot | phfun slot | bmw55 slot | sg777 slot | wj slot | slot free 100 | lucky cola slot | cc6 slot | taya777 slot | ph444 slot | slot games | fb777 slot | okebet slot | help slot | tg77 slot | phwin slot | vvjl slot | fc777 slot | slot vin | yy777 slot | define slot | define slot | inplay | 99bet | 60win | melbet | jollibet | jili slot | rich711 | tayabet | phl63 | unobet | 63jili | mwplay888 | gold99 | jolibet | ubet95 | nice88 | jili777 | nn777 | phlove | jiliko | 55bmw | phoenix game | 8k8 | cgebet | 7up gaming | diamond game | hellowin | win88 | big win | kabibe game | sabong bet | phcity | colorplay | tongits go | slotsgo | spinph | go perya | casino frenzy | aurora game | escala gaming | winning plus | bingo plus | ph dream | 747 live | niceph | lucky cola | pera play