Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.vendor AS vendor_1,
  p0_.model AS model_2,
  p0_.image AS image_3,
  p0_.image_name_opt AS image_name_opt_4,
  p0_.sale AS sale_5,
  p0_.hit AS hit_6,
  p0_.weight AS weight_7,
  p0_.width AS width_8,
  p0_.diameter AS diameter_9,
  p0_.int_code AS int_code_10,
  p0_.vendor_code AS vendor_code_11,
  p0_.updated_at AS updated_at_12,
  p0_.available AS available_13,
  p0_.calculated_price AS calculated_price_14,
  p0_.calculated_price_ext AS calculated_price_ext_15,
  p0_.calculated_external AS calculated_external_16,
  p0_.season AS season_17,
  p0_.studded AS studded_18,
  p0_.height AS height_19,
  p0_."load" AS load_20,
  p0_.speed AS speed_21,
  p0_.design AS design_22,
  p0_.runflat AS runflat_23,
  p0_.usa AS usa_24,
  p0_.screws AS screws_25,
  p0_.hole AS hole_26,
  p0_.pcd AS pcd_27,
  p0_.et AS et_28,
  p0_.color AS color_29,
  p0_.stamped AS stamped_30,
  p0_.calculated_pcd AS calculated_pcd_31,
  p0_.calculated_count AS calculated_count_32,
  p0_.slug AS slug_33,
  p0_.p_type AS p_type_34
FROM
  product p0_
WHERE
  (
    (p0_.hit = true)
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1', '2')

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, p0_.p_type AS p_type_34 FROM product p0_ WHERE ((p0_.hit = true) AND (p0_.available=true)) AND p0_.p_type IN ('1', '2');

SELECT
  p0_.id AS id_0,
  p0_.vendor AS vendor_1,
  p0_.model AS model_2,
  p0_.image AS image_3,
  p0_.image_name_opt AS image_name_opt_4,
  p0_.sale AS sale_5,
  p0_.hit AS hit_6,
  p0_.weight AS weight_7,
  p0_.width AS width_8,
  p0_.diameter AS diameter_9,
  p0_.int_code AS int_code_10,
  p0_.vendor_code AS vendor_code_11,
  p0_.updated_at AS updated_at_12,
  p0_.available AS available_13,
  p0_.calculated_price AS calculated_price_14,
  p0_.calculated_price_ext AS calculated_price_ext_15,
  p0_.calculated_external AS calculated_external_16,
  p0_.season AS season_17,
  p0_.studded AS studded_18,
  p0_.height AS height_19,
  p0_."load" AS load_20,
  p0_.speed AS speed_21,
  p0_.design AS design_22,
  p0_.runflat AS runflat_23,
  p0_.usa AS usa_24,
  p0_.screws AS screws_25,
  p0_.hole AS hole_26,
  p0_.pcd AS pcd_27,
  p0_.et AS et_28,
  p0_.color AS color_29,
  p0_.stamped AS stamped_30,
  p0_.calculated_pcd AS calculated_pcd_31,
  p0_.calculated_count AS calculated_count_32,
  p0_.slug AS slug_33,
  p0_.p_type AS p_type_34
FROM
  product p0_
WHERE
  (
    (p0_.sale = true)
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1', '2')

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, p0_.p_type AS p_type_34 FROM product p0_ WHERE ((p0_.sale = true) AND (p0_.available=true)) AND p0_.p_type IN ('1', '2');

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.image AS image_4,
  i0_.description_add AS description_add_5,
  i0_.keywords AS keywords_6,
  i0_.slug AS slug_7,
  i0_.ib_type AS ib_type_8,
  i0_.group_id AS group_id_9
FROM
  info_block i0_
WHERE
  i0_.ib_type IN ('1')
ORDER BY
  i0_.created_at DESC
LIMIT
  3

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.ib_type AS ib_type_8, i0_.group_id AS group_id_9 FROM info_block i0_ WHERE i0_.ib_type IN ('1') ORDER BY i0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'nsk' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'nsk' LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.image AS image_4,
  i0_.description_add AS description_add_5,
  i0_.keywords AS keywords_6,
  i0_.slug AS slug_7,
  i0_.expires_after AS expires_after_8,
  i0_.show_as_action AS show_as_action_9,
  i0_.show_as_banner AS show_as_banner_10,
  i0_.banner_priority AS banner_priority_11,
  i0_.banner_url AS banner_url_12,
  i0_.url AS url_13,
  i0_.ib_type AS ib_type_14,
  i0_.group_id AS group_id_15
FROM
  info_block i0_
WHERE
  (
    i0_.show_as_banner = true
    AND i0_.created_at <= CURRENT_DATE
    AND i0_.expires_after >= CURRENT_DATE
  )
  AND i0_.ib_type IN ('2')
ORDER BY
  i0_.banner_priority ASC

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.ib_type AS ib_type_14, i0_.group_id AS group_id_15 FROM info_block i0_ WHERE (i0_.show_as_banner = true AND i0_.created_at <= CURRENT_DATE AND i0_.expires_after >= CURRENT_DATE) AND i0_.ib_type IN ('2') ORDER BY i0_.banner_priority ASC;

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.image AS image_4,
  i0_.description_add AS description_add_5,
  i0_.keywords AS keywords_6,
  i0_.slug AS slug_7,
  i0_.expires_after AS expires_after_8,
  i0_.show_as_action AS show_as_action_9,
  i0_.show_as_banner AS show_as_banner_10,
  i0_.banner_priority AS banner_priority_11,
  i0_.banner_url AS banner_url_12,
  i0_.url AS url_13,
  i0_.ib_type AS ib_type_14,
  i0_.group_id AS group_id_15
FROM
  info_block i0_
WHERE
  (
    i0_.show_as_banner = true
    AND i0_.created_at <= CURRENT_DATE
    AND i0_.expires_after >= CURRENT_DATE
  )
  AND i0_.ib_type IN ('2')
ORDER BY
  i0_.banner_priority ASC

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.ib_type AS ib_type_14, i0_.group_id AS group_id_15 FROM info_block i0_ WHERE (i0_.show_as_banner = true AND i0_.created_at <= CURRENT_DATE AND i0_.expires_after >= CURRENT_DATE) AND i0_.ib_type IN ('2') ORDER BY i0_.banner_priority ASC;

SELECT
  t0_.id AS id_0,
  t0_.town AS town_1,
  t0_.name AS name_2,
  t0_.seo_name AS seo_name_3
FROM
  town t0_
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC;