Symfony Profiler

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.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
  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 = 'priceindex' LIMIT 1;

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 = 14 ORDER BY t0.sort ASC;

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
  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.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 = 11 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 = ?
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 = 10 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 = ?
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 = 9 ORDER BY t0.date 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 = ?
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 = 'area' ORDER BY t0.id 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 = ?
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 = 14 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 = ?
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 = 13 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 = ?
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 = 8 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 = ?
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 = 7 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 = ?
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 = 5 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 = ?
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 = 4 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 = ?
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 = 3 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 = ?
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 = 2 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 = ?
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 = 1 ORDER BY t0.date 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
  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 = 'area' GROUP BY sclr_0 ORDER BY p0_.date ASC LIMIT 6;

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.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 = 'about' 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 = ?
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 = 'project' 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 = ?
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 = 'korolev' 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 = ?
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 = 'publications' 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 = ?
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 = 'contacts' 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 = ?
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 = 'o-regione' LIMIT 1;

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 = 11 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 = ?
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 = 10 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 = ?
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 = 8 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 = ?
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 = 12 ORDER BY t0.sort ASC;

SELECT
  DATABASE()

SELECT DATABASE();

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
  DATABASE()

SELECT DATABASE();

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;