Queries
#▲ | Time | Info |
---|---|---|
1 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.templet AS templet_4, t0.uri AS uri_5, t0.meta_title AS meta_title_6, t0.is_show_title AS is_show_title_7, t0.meta_description AS meta_description_8, t0.is_show_description AS is_show_description_9, t0.page_id AS page_id_10, t0.is_show AS is_show_11, t0.deletable AS deletable_12, t0.usable AS usable_13, t0.is_page AS is_page_14, t0.is_home AS is_home_15, t0.type AS type_16, t0.sort AS sort_17 FROM page t0 WHERE t0.uri = ? LIMIT 1
Parameters: [atricle]
|
2 | 0.42 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.stock_code AS stock_code_3, t0.short_title AS short_title_4, t0.description AS description_5, t0.content AS content_6, t0.sort AS sort_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status AS status_10, t0.is_deleted AS is_deleted_11, t0.is_recommend AS is_recommend_12, t0.case_id AS case_id_13, t0.page_id AS page_id_14 FROM article t0 WHERE t0.id = ?
Parameters: ['1284']
|
3 | 0.13 ms |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.title_len AS title_len_2, m0_.title_omit AS title_omit_3, m0_.description AS description_4, m0_.is_show_title AS is_show_title_5, m0_.is_show_short AS is_show_short_6, m0_.per_page AS per_page_7, m0_.position AS position_8, m0_.style_sheet AS style_sheet_9, m0_.content AS content_10, m0_.type AS type_11, m0_.content_list AS content_list_12, m0_.more_url AS more_url_13, m0_.params AS params_14, m0_.sort AS sort_15, m0_.is_repeat AS is_repeat_16, m0_.orderby AS orderby_17, m1_.id AS id_18, m1_.sort AS sort_19, p2_.id AS id_20, p2_.name AS name_21, p2_.description AS description_22, p2_.templet AS templet_23, p2_.uri AS uri_24, p2_.meta_title AS meta_title_25, p2_.is_show_title AS is_show_title_26, p2_.meta_description AS meta_description_27, p2_.is_show_description AS is_show_description_28, p2_.page_id AS page_id_29, p2_.is_show AS is_show_30, p2_.deletable AS deletable_31, p2_.usable AS usable_32, p2_.is_page AS is_page_33, p2_.is_home AS is_home_34, p2_.type AS type_35, p2_.sort AS sort_36, m0_.tag_id AS tag_id_37, m1_.moudle_id AS moudle_id_38, m1_.page_id AS page_id_39 FROM moudle m0_ LEFT JOIN moudle_page m1_ ON m0_.id = m1_.moudle_id LEFT JOIN page p2_ ON m1_.page_id = p2_.id WHERE m0_.position LIKE ? AND p2_.id = ? ORDER BY m1_.sort ASC
Parameters: ['%left%', 2]
|
4 | 0.13 ms |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.title_len AS title_len_2, m0_.title_omit AS title_omit_3, m0_.description AS description_4, m0_.is_show_title AS is_show_title_5, m0_.is_show_short AS is_show_short_6, m0_.per_page AS per_page_7, m0_.position AS position_8, m0_.style_sheet AS style_sheet_9, m0_.content AS content_10, m0_.type AS type_11, m0_.content_list AS content_list_12, m0_.more_url AS more_url_13, m0_.params AS params_14, m0_.sort AS sort_15, m0_.is_repeat AS is_repeat_16, m0_.orderby AS orderby_17, m1_.id AS id_18, m1_.sort AS sort_19, p2_.id AS id_20, p2_.name AS name_21, p2_.description AS description_22, p2_.templet AS templet_23, p2_.uri AS uri_24, p2_.meta_title AS meta_title_25, p2_.is_show_title AS is_show_title_26, p2_.meta_description AS meta_description_27, p2_.is_show_description AS is_show_description_28, p2_.page_id AS page_id_29, p2_.is_show AS is_show_30, p2_.deletable AS deletable_31, p2_.usable AS usable_32, p2_.is_page AS is_page_33, p2_.is_home AS is_home_34, p2_.type AS type_35, p2_.sort AS sort_36, m0_.tag_id AS tag_id_37, m1_.moudle_id AS moudle_id_38, m1_.page_id AS page_id_39 FROM moudle m0_ LEFT JOIN moudle_page m1_ ON m0_.id = m1_.moudle_id LEFT JOIN page p2_ ON m1_.page_id = p2_.id WHERE m0_.position LIKE ? AND p2_.id = ? ORDER BY m1_.sort ASC
Parameters: ['%right%', 2]
|
5 | 0.10 ms |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.is_show AS is_show_2, n1_.id AS id_3, n0_.uri AS uri_4 FROM navigator n0_ LEFT JOIN navigator n1_ ON n0_.parent_id = n1_.id WHERE n0_.is_show = 1 ORDER BY n0_.sort ASC
Parameters: { }
|
6 | 0.33 ms |
SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.tag_id AS tag_id_3, t0.article_id AS article_id_4 FROM article_tag t0 WHERE t0.is_default = ? AND t0.article_id = ? LIMIT 1
Parameters: [1, 1284]
|
7 | 0.41 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.stock_code AS stock_code_2, a0_.short_title AS short_title_3, a0_.description AS description_4, a0_.content AS content_5, a0_.sort AS sort_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.status AS status_9, a0_.is_deleted AS is_deleted_10, a0_.is_recommend AS is_recommend_11, a0_.case_id AS case_id_12, a0_.page_id AS page_id_13 FROM article a0_ LEFT JOIN article_tag a1_ ON a0_.id = a1_.article_id WHERE (a0_.id < ? AND a1_.tag_id = ?) AND a0_.status = 0 ORDER BY a0_.id DESC LIMIT 1
Parameters: [1284, 14]
|
8 | 0.37 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.stock_code AS stock_code_2, a0_.short_title AS short_title_3, a0_.description AS description_4, a0_.content AS content_5, a0_.sort AS sort_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.status AS status_9, a0_.is_deleted AS is_deleted_10, a0_.is_recommend AS is_recommend_11, a0_.case_id AS case_id_12, a0_.page_id AS page_id_13 FROM article a0_ LEFT JOIN article_tag a1_ ON a0_.id = a1_.article_id WHERE (a0_.id > ? AND a1_.tag_id = ?) AND a0_.status = 0 ORDER BY a0_.id ASC LIMIT 1
Parameters: [1284, 14]
|
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 |
---|---|
Lag\Bundles\Admin\PageBundle\Entity\Page | No errors. |
Lag\Bundles\Admin\PageBundle\Entity\MoudlePage | No errors. |
Lag\Bundles\Admin\ArticleBundle\Entity\Article |
|
Lag\Bundles\Admin\CaseBundle\Entity\_Case | No errors. |
Lag\Bundles\Admin\ArticleBundle\Entity\ArticleTag | No errors. |
Lag\Bundles\Admin\MoudleBundle\Entity\Moudle | No errors. |
Lag\Bundles\Admin\TagBundle\Entity\Tag | No errors. |
Lag\Bundles\NavigatorBundle\Entity\Navigator | No errors. |
Lag\Bundles\Admin\CaseBundle\Entity\Batch |
|
Lag\Bundles\Admin\CaseBundle\Entity\ExDate | No errors. |
Lag\Bundles\Admin\ClientBundle\Entity\Client | No errors. |
Lag\Bundles\Admin\CaseBundle\Entity\_CaseClientInfo | No errors. |
Lag\Bundles\Admin\ClientBundle\Entity\ClientNotice | No errors. |
Lag\Bundles\Admin\CaseBundle\Entity\_CaseTip | No errors. |
Lag\Bundles\Admin\ClientBundle\Entity\ClientCalculatedInfo | No errors. |