Symfony Profiler

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

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

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;

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

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 (103, 102, 101, 100, 99, 98, 97, 96, 95, 94) ORDER BY c0_.id DESC;

SELECT 
  count(DISTINCT c0_.id) AS sclr_0 
FROM 
  ComplexPage c0_ 
WHERE 
  c0_.isVisible = 1

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM ComplexPage c0_ WHERE c0_.isVisible = 1;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.description AS description_3, 
  t0.keywords AS keywords_4, 
  t0.seoLabelFirst AS seoLabelFirst_5, 
  t0.seoLabelSecond AS seoLabelSecond_6 
FROM 
  Novostroy t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.seoLabelFirst AS seoLabelFirst_5, t0.seoLabelSecond AS seoLabelSecond_6 FROM Novostroy t0 WHERE t0.id = 1;

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.name AS name_2 
FROM 
  Area2 t0

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

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2 
FROM 
  TypeComplex t0

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

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

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;

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

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

SELECT 
  t0.id AS id_1, 
  t0.route AS route_2, 
  t0.description AS description_3, 
  t0.title AS title_4, 
  t0.text AS text_5 
FROM 
  SeoText t0 
WHERE 
  t0.route = ? 
ORDER BY 
  t0.id DESC 
LIMIT 
  1

SELECT t0.id AS id_1, t0.route AS route_2, t0.description AS description_3, t0.title AS title_4, t0.text AS text_5 FROM SeoText t0 WHERE t0.route = '/complex' ORDER BY t0.id DESC LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2 
FROM 
  StageComplex t0

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

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

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;