Query Metrics
34
Database Queries
14
Different statements
359.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
116.26 ms (32.37%) |
10 |
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"
]
|
|
52.43 ms (14.60%) |
5 |
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
]
|
|
52.41 ms (14.59%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
30.65 ms (8.54%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3 FROM gallery t0 WHERE t0.enabled = ?
Parameters:
[
1
]
|
|
25.63 ms (7.14%) |
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
Parameters:
[] |
|
14.22 ms (3.96%) |
1 |
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 ] |
|
11.49 ms (3.20%) |
1 |
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
]
|
|
11.12 ms (3.10%) |
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 = ?
Parameters:
[
1
]
|
|
11.09 ms (3.09%) |
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
Parameters:
[
1
]
|
|
7.86 ms (2.19%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"mos_portal"
]
|
|
7.21 ms (2.01%) |
5 |
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
]
|
|
6.68 ms (1.86%) |
1 |
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:
[] |
|
6.25 ms (1.74%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM document_group t0
Parameters:
[] |
|
5.82 ms (1.62%) |
3 |
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"
]
|
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. |