Symfony Profiler

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 
WHERE 
  t0.url = ?

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 WHERE t0.url = 'lucky_1905';

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

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

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

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

SELECT 
  t0.id AS id_1, 
  t0.path AS path_2, 
  t0.isMain AS isMain_3, 
  t0.deleteIt AS deleteIt_4, 
  t0.complex AS complex_5 
FROM 
  ComplexPhoto t0 
WHERE 
  t0.complex = ? 
ORDER BY 
  t0.isMain DESC

SELECT t0.id AS id_1, t0.path AS path_2, t0.isMain AS isMain_3, t0.deleteIt AS deleteIt_4, t0.complex AS complex_5 FROM ComplexPhoto t0 WHERE t0.complex = 47 ORDER BY t0.isMain DESC;

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

SELECT t0.id AS id_1, t0.name AS name_2 FROM Area2 t0 WHERE t0.id = 86;

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

SELECT t0.id AS id_1, t0.name AS name_2 FROM TypeComplex t0 WHERE t0.id = 1;

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

SELECT t0.id AS id_1, t0.name AS name_2 FROM StageComplex t0 WHERE t0.id = 1;

SELECT 
  t0.id AS id_1, 
  t0.willDelete AS willDelete_2, 
  t0.name AS name_3, 
  t0.spaceFrom AS spaceFrom_4, 
  t0.spaceTo AS spaceTo_5, 
  t0.priceFrom AS priceFrom_6, 
  t0.priceTo AS priceTo_7, 
  t0.complex AS complex_8 
FROM 
  ComplexOrders t0 
WHERE 
  t0.complex = ?

SELECT t0.id AS id_1, t0.willDelete AS willDelete_2, t0.name AS name_3, t0.spaceFrom AS spaceFrom_4, t0.spaceTo AS spaceTo_5, t0.priceFrom AS priceFrom_6, t0.priceTo AS priceTo_7, t0.complex AS complex_8 FROM ComplexOrders t0 WHERE t0.complex = 47;

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

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

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