Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created AS created_3,
  t0.enabled AS enabled_4,
  t0.is_main AS is_main_5,
  t0.anons AS anons_6,
  t0.content AS content_7,
  t0.seo_title AS seo_title_8,
  t0.seo_description AS seo_description_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.updated AS updated_11,
  t0.image AS image_12,
  t0.preview AS preview_13,
  t0.video_link AS video_link_14,
  t0.link AS link_15,
  t0.slug AS slug_16,
  t0.video AS video_17,
  t0.image_alt AS image_alt_18,
  t0.category_id AS category_id_19,
  t0.parent_id AS parent_id_20,
  t0.local_project_id AS local_project_id_21
FROM
  publication t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.created DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.is_main AS is_main_5, t0.anons AS anons_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.updated AS updated_11, t0.image AS image_12, t0.preview AS preview_13, t0.video_link AS video_link_14, t0.link AS link_15, t0.slug AS slug_16, t0.video AS video_17, t0.image_alt AS image_alt_18, t0.category_id AS category_id_19, t0.parent_id AS parent_id_20, t0.local_project_id AS local_project_id_21 FROM publication t0 WHERE t0.enabled = 1 ORDER BY t0.created DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created AS created_3,
  t0.enabled AS enabled_4,
  t0.is_main AS is_main_5,
  t0.anons AS anons_6,
  t0.content AS content_7,
  t0.seo_title AS seo_title_8,
  t0.seo_description AS seo_description_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.updated AS updated_11,
  t0.image AS image_12,
  t0.preview AS preview_13,
  t0.video_link AS video_link_14,
  t0.link AS link_15,
  t0.slug AS slug_16,
  t0.video AS video_17,
  t0.image_alt AS image_alt_18,
  t0.category_id AS category_id_19,
  t0.parent_id AS parent_id_20,
  t0.local_project_id AS local_project_id_21
FROM
  publication t0
WHERE
  t0.enabled = ?
  AND t0.category_id = ?
ORDER BY
  t0.created DESC
LIMIT
  6

SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.is_main AS is_main_5, t0.anons AS anons_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.updated AS updated_11, t0.image AS image_12, t0.preview AS preview_13, t0.video_link AS video_link_14, t0.link AS link_15, t0.slug AS slug_16, t0.video AS video_17, t0.image_alt AS image_alt_18, t0.category_id AS category_id_19, t0.parent_id AS parent_id_20, t0.local_project_id AS local_project_id_21 FROM publication t0 WHERE t0.enabled = 1 AND t0.category_id = 1 ORDER BY t0.created DESC LIMIT 6;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.price AS price_3,
  t0.price_index_id AS price_index_id_4
FROM
  price_index_item t0
WHERE
  t0.price_index_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = 16 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.sort AS sort_2,
  t0.page_id AS page_id_3,
  t0.block_id AS block_id_4
FROM
  page_page_block t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.page_id AS page_id_3, t0.block_id AS block_id_4 FROM page_page_block t0 WHERE t0.page_id = 7 ORDER BY t0.sort ASC;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created AS created_3,
  t0.enabled AS enabled_4,
  t0.is_main AS is_main_5,
  t0.anons AS anons_6,
  t0.content AS content_7,
  t0.seo_title AS seo_title_8,
  t0.seo_description AS seo_description_9,
  t0.seo_keywords AS seo_keywords_10,
  t0.updated AS updated_11,
  t0.image AS image_12,
  t0.preview AS preview_13,
  t0.video_link AS video_link_14,
  t0.link AS link_15,
  t0.slug AS slug_16,
  t0.video AS video_17,
  t0.image_alt AS image_alt_18,
  t0.category_id AS category_id_19,
  t0.parent_id AS parent_id_20,
  t0.local_project_id AS local_project_id_21
FROM
  publication t0
WHERE
  t0.enabled = ?
  AND t0.is_main = ?
  AND t0.category_id = ?
ORDER BY
  t0.created DESC
LIMIT
  6

SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.is_main AS is_main_5, t0.anons AS anons_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.updated AS updated_11, t0.image AS image_12, t0.preview AS preview_13, t0.video_link AS video_link_14, t0.link AS link_15, t0.slug AS slug_16, t0.video AS video_17, t0.image_alt AS image_alt_18, t0.category_id AS category_id_19, t0.parent_id AS parent_id_20, t0.local_project_id AS local_project_id_21 FROM publication t0 WHERE t0.enabled = 1 AND t0.is_main = 1 AND t0.category_id = 2 ORDER BY t0.created DESC LIMIT 6;

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'mos_portal'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.enabled AS enabled_3,
  t0.content AS content_4,
  t0.seo_title AS seo_title_5,
  t0.seo_description AS seo_description_6,
  t0.seo_keywords AS seo_keywords_7,
  t0.slug AS slug_8
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.content AS content_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.slug AS slug_8 FROM page t0 WHERE t0.slug = 'main' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.company_image AS company_image_2,
  t0.person_image AS person_image_3,
  t0.person_title AS person_title_4,
  t0.persont_post AS persont_post_5,
  t0.content AS content_6,
  t0.created AS created_7,
  t0.updated AS updated_8
FROM
  review t0

SELECT t0.id AS id_1, t0.company_image AS company_image_2, t0.person_image AS person_image_3, t0.person_title AS person_title_4, t0.persont_post AS persont_post_5, t0.content AS content_6, t0.created AS created_7, t0.updated AS updated_8 FROM review t0;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.image AS image_2,
  l0_.preview AS preview_3,
  l0_.ph1 AS ph1_4,
  l0_.ph2 AS ph2_5,
  l0_.amount_investment AS amount_investment_6,
  l0_.work_place AS work_place_7,
  l0_.enabled AS enabled_8,
  l0_.created AS created_9,
  l0_.updated AS updated_10,
  l0_.content AS content_11,
  l0_.implementation_period AS implementation_period_12,
  l0_.fact1_title AS fact1_title_13,
  l0_.fact1_value AS fact1_value_14,
  l0_.fact2_title AS fact2_title_15,
  l0_.fact2_value AS fact2_value_16,
  l0_.fact3_title AS fact3_title_17,
  l0_.fact3_value AS fact3_value_18,
  l0_.content2 AS content2_19,
  l0_.map_string AS map_string_20,
  l0_.location AS location_21,
  l0_.sort AS sort_22,
  l0_.loc_x AS loc_x_23,
  l0_.loc_y AS loc_y_24,
  l0_.seo_title AS seo_title_25,
  l0_.seo_description AS seo_description_26,
  l0_.seo_keywords AS seo_keywords_27,
  l0_.distict_id AS distict_id_28
FROM
  local_project l0_
WHERE
  l0_.enabled = 1
ORDER BY
  l0_.sort ASC
LIMIT
  4

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.image AS image_2, l0_.preview AS preview_3, l0_.ph1 AS ph1_4, l0_.ph2 AS ph2_5, l0_.amount_investment AS amount_investment_6, l0_.work_place AS work_place_7, l0_.enabled AS enabled_8, l0_.created AS created_9, l0_.updated AS updated_10, l0_.content AS content_11, l0_.implementation_period AS implementation_period_12, l0_.fact1_title AS fact1_title_13, l0_.fact1_value AS fact1_value_14, l0_.fact2_title AS fact2_title_15, l0_.fact2_value AS fact2_value_16, l0_.fact3_title AS fact3_title_17, l0_.fact3_value AS fact3_value_18, l0_.content2 AS content2_19, l0_.map_string AS map_string_20, l0_.location AS location_21, l0_.sort AS sort_22, l0_.loc_x AS loc_x_23, l0_.loc_y AS loc_y_24, l0_.seo_title AS seo_title_25, l0_.seo_description AS seo_description_26, l0_.seo_keywords AS seo_keywords_27, l0_.distict_id AS distict_id_28 FROM local_project l0_ WHERE l0_.enabled = 1 ORDER BY l0_.sort ASC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.content AS content_4,
  t0.module AS module_5,
  t0.menu_title AS menu_title_6,
  t0.in_menu AS in_menu_7
FROM
  page_block t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.content AS content_4, t0.module AS module_5, t0.menu_title AS menu_title_6, t0.in_menu AS in_menu_7 FROM page_block t0 WHERE t0.name = 'presentForm' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.remoteness AS remoteness_4,
  t0.square AS square_5,
  t0.content AS content_6,
  t0.infrastructure AS infrastructure_7,
  t0.location AS location_8,
  t0.created AS created_9,
  t0.updated AS updated_10,
  t0.logo AS logo_11,
  t0.image AS image_12
FROM
  price_index t0
WHERE
  t0.type = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.remoteness AS remoteness_4, t0.square AS square_5, t0.content AS content_6, t0.infrastructure AS infrastructure_7, t0.location AS location_8, t0.created AS created_9, t0.updated AS updated_10, t0.logo AS logo_11, t0.image AS image_12 FROM price_index t0 WHERE t0.type = 'home' ORDER BY t0.id DESC;

SELECT
  MONTH(p0_.date) AS sclr_0,
  AVG(p0_.price) AS sclr_1
FROM
  price_index_item p0_
  LEFT JOIN price_index p1_ ON p0_.price_index_id = p1_.id
WHERE
  p1_.type = ?
GROUP BY
  sclr_0
ORDER BY
  p0_.date ASC
LIMIT
  6

SELECT MONTH(p0_.date) AS sclr_0, AVG(p0_.price) AS sclr_1 FROM price_index_item p0_ LEFT JOIN price_index p1_ ON p0_.price_index_id = p1_.id WHERE p1_.type = 'home' GROUP BY sclr_0 ORDER BY p0_.date ASC LIMIT 6;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.content AS content_4,
  t0.module AS module_5,
  t0.menu_title AS menu_title_6,
  t0.in_menu AS in_menu_7
FROM
  page_block t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.content AS content_4, t0.module AS module_5, t0.menu_title AS menu_title_6, t0.in_menu AS in_menu_7 FROM page_block t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.enabled AS enabled_3,
  t0.mkad AS mkad_4,
  t0.area AS area_5,
  t0.created AS created_6,
  t0.map_script AS map_script_7,
  t0.main_settings AS main_settings_8,
  t0.content AS content_9,
  t0.presentation AS presentation_10,
  t0.updated AS updated_11,
  t0.distict_id AS distict_id_12,
  t0.gallery_id AS gallery_id_13
FROM
  project t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.mkad AS mkad_4, t0.area AS area_5, t0.created AS created_6, t0.map_script AS map_script_7, t0.main_settings AS main_settings_8, t0.content AS content_9, t0.presentation AS presentation_10, t0.updated AS updated_11, t0.distict_id AS distict_id_12, t0.gallery_id AS gallery_id_13 FROM project t0 WHERE t0.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.enabled AS enabled_4,
  t0.sort AS sort_5,
  t0.parent_id AS parent_id_6
FROM
  menu t0
WHERE
  t0.enabled = ?
  AND t0.parent_id IS NULL
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.sort AS sort_5, t0.parent_id AS parent_id_6 FROM menu t0 WHERE t0.enabled = 1 AND t0.parent_id IS NULL ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created AS created_3,
  t0.updated AS updated_4,
  t0.enabled AS enabled_5,
  t0.image AS image_6,
  t0.site AS site_7
FROM
  partner t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.updated AS updated_4, t0.enabled AS enabled_5, t0.image AS image_6, t0.site AS site_7 FROM partner t0 WHERE t0.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.preview AS preview_4,
  t0.ph1 AS ph1_5,
  t0.ph2 AS ph2_6,
  t0.amount_investment AS amount_investment_7,
  t0.work_place AS work_place_8,
  t0.enabled AS enabled_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.content AS content_12,
  t0.implementation_period AS implementation_period_13,
  t0.fact1_title AS fact1_title_14,
  t0.fact1_value AS fact1_value_15,
  t0.fact2_title AS fact2_title_16,
  t0.fact2_value AS fact2_value_17,
  t0.fact3_title AS fact3_title_18,
  t0.fact3_value AS fact3_value_19,
  t0.content2 AS content2_20,
  t0.map_string AS map_string_21,
  t0.location AS location_22,
  t0.sort AS sort_23,
  t0.loc_x AS loc_x_24,
  t0.loc_y AS loc_y_25,
  t0.seo_title AS seo_title_26,
  t0.seo_description AS seo_description_27,
  t0.seo_keywords AS seo_keywords_28,
  t0.distict_id AS distict_id_29
FROM
  local_project t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.preview AS preview_4, t0.ph1 AS ph1_5, t0.ph2 AS ph2_6, t0.amount_investment AS amount_investment_7, t0.work_place AS work_place_8, t0.enabled AS enabled_9, t0.created AS created_10, t0.updated AS updated_11, t0.content AS content_12, t0.implementation_period AS implementation_period_13, t0.fact1_title AS fact1_title_14, t0.fact1_value AS fact1_value_15, t0.fact2_title AS fact2_title_16, t0.fact2_value AS fact2_value_17, t0.fact3_title AS fact3_title_18, t0.fact3_value AS fact3_value_19, t0.content2 AS content2_20, t0.map_string AS map_string_21, t0.location AS location_22, t0.sort AS sort_23, t0.loc_x AS loc_x_24, t0.loc_y AS loc_y_25, t0.seo_title AS seo_title_26, t0.seo_description AS seo_description_27, t0.seo_keywords AS seo_keywords_28, t0.distict_id AS distict_id_29 FROM local_project t0 WHERE t0.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.count_company AS count_company_3,
  t0.count_workplace AS count_workplace_4,
  t0.count_invest AS count_invest_5
FROM
  itog t0
ORDER BY
  t0.title DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.count_company AS count_company_3, t0.count_workplace AS count_workplace_4, t0.count_invest AS count_invest_5 FROM itog t0 ORDER BY t0.title DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.enabled AS enabled_3,
  t0.slug AS slug_4,
  t0.seo_title AS seo_title_5,
  t0.seo_description AS seo_description_6
FROM
  publication_category t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6 FROM publication_category t0 WHERE t0.enabled = 1;