Query Metrics
23
Database Queries
10
Different statements
285.83 ms
Query time
0
Invalid entities
Queries
| #▲ | 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
]
|
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. |