Query Metrics
32
Database Queries
11
Different statements
8.39 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.68 ms (19.98%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.is_active AS is_active_5 FROM MLDev_Block t0 WHERE t0.alias = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "header-warning-message" 1 ] |
1.48 ms (17.62%) |
7 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"default-top"
]
|
1.39 ms (16.52%) |
7 |
SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = ? AND te.is_active = ? ORDER BY priority ASC
Parameters:
[ 1 1 ] |
0.84 ms (10.07%) |
1 |
SELECT t0.id AS id_1, t0.where_from AS where_from_2, t0.where_to AS where_to_3, t0.http_code AS http_code_4 FROM MLDev_Redirect t0 WHERE t0.where_from = ? LIMIT 1
Parameters:
[
"/partners"
]
|
0.54 ms (6.42%) |
2 |
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.isActive AS isActive_3, t0.title AS title_4, t0.description AS description_5, t0.link AS link_6, t0.path AS path_7, t0.uri AS uri_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.albumId AS albumId_11 FROM MLDev_Gallery_Item t0 WHERE t0.albumId = ? AND t0.isActive = ? ORDER BY t0.priority DESC, t0.created_at DESC
Parameters:
[ 1 1 ] |
0.50 ms (5.94%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.is_layout AS is_layout_4 FROM MLDev_Page_Template t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.50 ms (5.92%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.priority AS priority_3, t0.is_active AS is_active_4, t0.widget AS widget_5, t0.options AS options_6, t0.page_id AS page_id_7 FROM MLDev_Page_Content t0 WHERE (t0.is_active = ? AND t0.page_id = ?) ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[ 1 30 ] |
0.47 ms (5.59%) |
1 |
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.external_link AS external_link_2, m0_.name AS name_3, m0_.alias AS alias_4, m0_.route AS route_5, m0_.description AS description_6, m0_.priority AS priority_7, m0_.is_active AS is_active_8, m0_.image AS image_9, m0_.lft AS lft_10, m0_.lvl AS lvl_11, m0_.rgt AS rgt_12, m0_.created_at AS created_at_13, m0_.updated_at AS updated_at_14, m0_.parent_id AS parent_id_15, m0_.template_id AS template_id_16, m0_.layout_template_id AS layout_template_id_17, m0_.root_id AS root_id_18 FROM MLDev_Page m0_ WHERE m0_.parent_id IS NULL ORDER BY m0_.lft ASC
Parameters:
[] |
0.36 ms (4.34%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.robots AS robots_5, t0.isActive AS isActive_6, t0.isDefault AS isDefault_7 FROM MLDev_SeoSite t0 WHERE t0.isActive = ? AND t0.isDefault = ? LIMIT 1
Parameters:
[ 1 1 ] |
0.33 ms (3.91%) |
1 |
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.external_link AS external_link_2, m0_.name AS name_3, m0_.alias AS alias_4, m0_.route AS route_5, m0_.description AS description_6, m0_.priority AS priority_7, m0_.is_active AS is_active_8, m0_.image AS image_9, m0_.lft AS lft_10, m0_.lvl AS lvl_11, m0_.rgt AS rgt_12, m0_.created_at AS created_at_13, m0_.updated_at AS updated_at_14, m0_.parent_id AS parent_id_15, m0_.template_id AS template_id_16, m0_.layout_template_id AS layout_template_id_17, m0_.root_id AS root_id_18 FROM MLDev_Page m0_ WHERE (m0_.route = ? OR m0_.route = ?) AND m0_.is_active = 1 ORDER BY m0_.lft ASC, m0_.priority ASC
Parameters:
[ "/ru/partners" "/partners" ] |
0.31 ms (3.68%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.is_default AS is_default_5, t0.seo_site_id AS seo_site_id_6 FROM MLDev_SeoInfo t0 INNER JOIN MLDev_Page_SeoInfo ON t0.id = MLDev_Page_SeoInfo.seo_info_id WHERE MLDev_Page_SeoInfo.page_id = ?
Parameters:
[
30
]
|
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 |
---|---|
MLDev\BaseBundle\Entity\Page | No errors. |
App\Entity\Redirect | No errors. |
MLDev\BaseBundle\Entity\PageTemplate | No errors. |
MLDev\BaseBundle\Entity\Menu | No errors. |
MLDev\BaseBundle\Entity\PageContent | No errors. |
MLDev\BaseBundle\Entity\SeoInfo | No errors. |
MLDev\SeoSiteBundle\Entity\SeoSiteInfo | No errors. |
MLDev\BaseBundle\Entity\SeoSite | No errors. |
MLDev\SeoSiteBundle\Entity\SeoSite | No errors. |
MLDev\GalleryBundle\Entity\Item | No errors. |
MLDev\GalleryBundle\Entity\Album | No errors. |
MLDev\BaseBundle\Entity\Block | No errors. |