Query Metrics

20 Database Queries
7 Different statements
47.95 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.99 ms
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
Parameters:
[]
2 1.63 ms
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.id = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  1
  1
]
3 2.79 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ? AND t0.type = ?
Parameters:
[
  1
  "0"
]
4 2.14 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ? AND t0.type = ?
Parameters:
[
  1
  "0"
]
5 3.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ? AND t0.type = ?
Parameters:
[
  1
  "1"
]
6 2.92 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ? AND t0.type = ?
Parameters:
[
  1
  "1"
]
7 1.59 ms
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
Parameters:
[
  "project"
]
8 1.57 ms
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
Parameters:
[
  8
]
9 3.84 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ?
Parameters:
[
  1
]
10 5.62 ms
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
Parameters:
[
  1
]
11 5.12 ms
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
Parameters:
[
  "about"
]
12 1.93 ms
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
Parameters:
[
  "project"
]
13 1.35 ms
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
Parameters:
[
  "korolev"
]
14 1.01 ms
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
Parameters:
[
  "publications"
]
15 0.90 ms
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
Parameters:
[
  "contacts"
]
16 0.89 ms
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
Parameters:
[
  "o-regione"
]
17 1.07 ms
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
Parameters:
[
  11
]
18 2.41 ms
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
Parameters:
[
  10
]
19 1.43 ms
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
Parameters:
[
  8
]
20 1.54 ms
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
Parameters:
[
  12
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\PageBlock No errors.
App\Entity\PagePageBlock No errors.
App\Entity\Project No errors.
App\Entity\ProjectDistict No errors.
App\Entity\Gallery No errors.
App\Entity\ProjectRezident No errors.
App\Entity\ProjectItem No errors.
App\Entity\ProjectContentGroup No errors.
App\Entity\ProjectItemImage No errors.
App\Entity\Page No errors.
App\Entity\Menu No errors.