Symfony Profiler

SELECT 
  a0_.id AS id_0, 
  a0_.name AS name_1, 
  a0_.bid AS bid_2, 
  a0_.date AS date_3, 
  a0_.description AS description_4, 
  a0_.mailtext AS mailtext_5, 
  a0_.file AS file_6, 
  a0_.img AS img_7, 
  a0_.sended AS sended_8, 
  a0_.published AS published_9, 
  a0_.slug AS slug_10, 
  a0_.text AS text_11, 
  a0_.shortText AS shortText_12, 
  a0_.metaTitle AS metaTitle_13, 
  a0_.metaDescription AS metaDescription_14, 
  a0_.metaKeywords AS metaKeywords_15 
FROM 
  Analytic a0_ 
WHERE 
  a0_.slug = ? 
  AND a0_.published = 1 
LIMIT 
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.bid AS bid_2, a0_.date AS date_3, a0_.description AS description_4, a0_.mailtext AS mailtext_5, a0_.file AS file_6, a0_.img AS img_7, a0_.sended AS sended_8, a0_.published AS published_9, a0_.slug AS slug_10, a0_.text AS text_11, a0_.shortText AS shortText_12, a0_.metaTitle AS metaTitle_13, a0_.metaDescription AS metaDescription_14, a0_.metaKeywords AS metaKeywords_15 FROM Analytic a0_ WHERE a0_.slug = 'stoimost_kvadratnogo_metra_v_cao_prevysila_1_mln_rubley' AND a0_.published = 1 LIMIT 1;

select 
  left(date, 4) as date, 
  count(*) 
from 
  Analytic 
where 
  published = 1 
group by 
  left(date, 4) 
order by 
  left(date, 4) DESC

select left(date,4) as date, 
       count(*) from Analytic where published = 1 group by left(date,4) order by left(date,4) DESC;

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;