Query Metrics

36 Database Queries
14 Different statements
362.71 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 25.63 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 6.68 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.in_about AS in_about_3, t0.sort AS sort_4, t0.in_contact AS in_contact_5, t6.id AS id_7, t6.name AS name_8, t6.post AS post_9, t6.phone AS phone_10, t6.phone_comment AS phone_comment_11, t6.email AS email_12, t6.enabled AS enabled_13, t6.image AS image_14, t6.preview AS preview_15, t6.created AS created_16, t6.updated AS updated_17, t6.priority AS priority_18, t6.category_id AS category_id_19 FROM person_category t0 LEFT JOIN person t6 ON t6.category_id = t0.id ORDER BY t0.sort ASC
Parameters:
[]
3 14.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.post AS post_3, t0.phone AS phone_4, t0.phone_comment AS phone_comment_5, t0.email AS email_6, t0.enabled AS enabled_7, t0.image AS image_8, t0.preview AS preview_9, t0.created AS created_10, t0.updated AS updated_11, t0.priority AS priority_12, t0.category_id AS category_id_13 FROM person t0 WHERE t0.category_id = ? AND t0.enabled = ? ORDER BY t0.priority ASC
Parameters:
[
  1
  1
]
4 11.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.post AS post_3, t0.phone AS phone_4, t0.phone_comment AS phone_comment_5, t0.email AS email_6, t0.enabled AS enabled_7, t0.image AS image_8, t0.preview AS preview_9, t0.created AS created_10, t0.updated AS updated_11, t0.priority AS priority_12, t0.category_id AS category_id_13 FROM person t0 WHERE t0.enabled = ? ORDER BY t0.priority ASC
Parameters:
[
  1
]
5 11.12 ms
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 = ?
Parameters:
[
  1
]
6 14.37 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_1"
]
7 7.45 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_2"
]
8 11.43 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_3"
]
9 30.65 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3 FROM gallery t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
10 13.56 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"
]
11 11.48 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
]
12 6.25 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM document_group t0
Parameters:
[]
13 11.09 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
]
14 7.13 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"
]
15 12.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:
[
  "project"
]
16 13.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:
[
  "korolev"
]
17 13.44 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"
]
18 11.77 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"
]
19 11.51 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"
]
20 11.21 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
]
21 7.37 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
]
22 11.23 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
]
23 11.15 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
]
24 34.25 ms
SELECT DATABASE()
Parameters:
[]
25 7.86 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "mos_portal"
]
26 18.16 ms
SELECT DATABASE()
Parameters:
[]
27 2.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.created AS created_4, t0.updated AS updated_5, t0.image AS image_6, t0.document_group_id AS document_group_id_7 FROM document t0 WHERE t0.document_group_id = ?
Parameters:
[
  1
]
28 1.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.created AS created_4, t0.updated AS updated_5, t0.image AS image_6, t0.document_group_id AS document_group_id_7 FROM document t0 WHERE t0.document_group_id = ?
Parameters:
[
  2
]
29 1.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.created AS created_4, t0.updated AS updated_5, t0.image AS image_6, t0.document_group_id AS document_group_id_7 FROM document t0 WHERE t0.document_group_id = ?
Parameters:
[
  3
]
30 0.98 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.created AS created_4, t0.updated AS updated_5, t0.image AS image_6, t0.document_group_id AS document_group_id_7 FROM document t0 WHERE t0.document_group_id = ?
Parameters:
[
  4
]
31 1.08 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.created AS created_4, t0.updated AS updated_5, t0.image AS image_6, t0.document_group_id AS document_group_id_7 FROM document t0 WHERE t0.document_group_id = ?
Parameters:
[
  5
]
32 1.69 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "presentForm"
]
33 1.78 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emailSuccess"
]
34 2.36 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "formSuccess"
]
35 1.60 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "formS"
]
36 1.97 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "formS2"
]

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\PersonCategory No errors.
App\Entity\Person No errors.
App\Entity\LocalProject No errors.
App\Entity\ProjectDistict No errors.
App\Entity\Page No errors.
App\Entity\Gallery No errors.
App\Entity\GalleryItem No errors.
App\Entity\Project No errors.
App\Entity\DocumentGroup No errors.
App\Entity\Document No errors.
App\Entity\Menu No errors.
App\Entity\LocalProjectImage No errors.
App\Entity\Publication No errors.
App\Entity\ProjectRezident No errors.
App\Entity\ProjectItem No errors.
App\Entity\ProjectContentGroup No errors.
App\Entity\PublicationCategory No errors.
App\Entity\PublicationImage No errors.
App\Entity\ProjectItemImage No errors.
App\Entity\ServiceCompany No errors.
App\Entity\Review No errors.
App\Entity\JukService No errors.
App\Entity\Smi No errors.
App\Entity\Chart No errors.
App\Entity\Setting No errors.
App\Entity\User No errors.
App\Entity\Itog No errors.
App\Entity\Subscribtion No errors.
App\Entity\JukIcon No errors.
App\Entity\Map No errors.
App\Entity\Order No errors.
App\Entity\UserOrder No errors.
App\Entity\JukSmi No errors.
App\Entity\PriceIndex No errors.
App\Entity\ChartValue No errors.
App\Entity\PriceIndexItem No errors.
App\Entity\Partner No errors.
Vich\UploaderBundle\Entity\File No errors.