Symfony Profiler

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 IN (1, 2, 3) 
  AND l0_.typeOperationId IN (1, 2) 
  AND l0_.showLot = 1

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 IN (1, 2, 3) AND l0_.typeOperationId IN (1, 2) AND l0_.showLot = 1;

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 = ?

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 = 63;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2 
FROM 
  Street t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = 1160;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.cianId AS cianId_3 
FROM 
  Subway2 t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.cianId AS cianId_3 FROM Subway2 t0 WHERE t0.id = 16;

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

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 = 3529 ORDER BY t0.isMain DESC;

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 = ?

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 = 38;