| 1 |
3.62 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.id = ?
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.id = ?
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.id = '2211';
|
| 2 |
1.52 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.id = ? AND t0.typeLotId = ?
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.id = ?
AND t0.typeLotId = ?
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.id = '2211' AND t0.typeLotId = 2;
|