http://gudong.pro/app_dev.php/page/atricle?aid=7442

Queries

# Time Info
1 0.25 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.39 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: ['7442']
3 0.16 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.27 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.13 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.43 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, 7442]
7 0.43 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: [7442, 23]
8 0.36 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: [7442, 23]
9 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_len AS title_len_3, t0.title_omit AS title_omit_4, t0.description AS description_5, t0.is_show_title AS is_show_title_6, t0.is_show_short AS is_show_short_7, t0.per_page AS per_page_8, t0.position AS position_9, t0.style_sheet AS style_sheet_10, t0.content AS content_11, t0.type AS type_12, t0.content_list AS content_list_13, t0.more_url AS more_url_14, t0.params AS params_15, t0.sort AS sort_16, t0.is_repeat AS is_repeat_17, t0.orderby AS orderby_18, t0.tag_id AS tag_id_19 FROM moudle t0 WHERE t0.type = ? LIMIT 1
Parameters: [mod_search_list]
10 0.11 ms
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.moudle_id AS moudle_id_3, t0.page_id AS page_id_4 FROM moudle_page t0 WHERE t0.moudle_id = ? LIMIT 1
Parameters: [47]
11 0.12 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.id = ?
Parameters: [5]
12 5.65 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_ WHERE (a0_.stock_code = ? AND a0_.id <> ?) AND a0_.status = 0 ORDER BY a0_.is_recommend DESC, a0_.created_at DESC LIMIT 6
Parameters: ['002445', '7442']
13 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_len AS title_len_3, t0.title_omit AS title_omit_4, t0.description AS description_5, t0.is_show_title AS is_show_title_6, t0.is_show_short AS is_show_short_7, t0.per_page AS per_page_8, t0.position AS position_9, t0.style_sheet AS style_sheet_10, t0.content AS content_11, t0.type AS type_12, t0.content_list AS content_list_13, t0.more_url AS more_url_14, t0.params AS params_15, t0.sort AS sort_16, t0.is_repeat AS is_repeat_17, t0.orderby AS orderby_18, t0.tag_id AS tag_id_19 FROM moudle t0 WHERE t0.type = ? LIMIT 1
Parameters: [mod_default_paginate_by_tag]
14 0.10 ms
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.moudle_id AS moudle_id_3, t0.page_id AS page_id_4 FROM moudle_page t0 WHERE t0.moudle_id = ? LIMIT 1
Parameters: [41]
15 0.11 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.id = ?
Parameters: [6]
16 0.18 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 LEFT JOIN tag t2_ ON a1_.tag_id = t2_.id WHERE t2_.id = ? AND a0_.status = 0 ORDER BY a0_.is_recommend DESC, a0_.created_at DESC LIMIT 16
Parameters: [12]
17 0.14 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_len AS title_len_3, t0.title_omit AS title_omit_4, t0.description AS description_5, t0.is_show_title AS is_show_title_6, t0.is_show_short AS is_show_short_7, t0.per_page AS per_page_8, t0.position AS position_9, t0.style_sheet AS style_sheet_10, t0.content AS content_11, t0.type AS type_12, t0.content_list AS content_list_13, t0.more_url AS more_url_14, t0.params AS params_15, t0.sort AS sort_16, t0.is_repeat AS is_repeat_17, t0.orderby AS orderby_18, t0.tag_id AS tag_id_19 FROM moudle t0 WHERE t0.position = ? LIMIT 1
Parameters: [bottom_contact]
18 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_len AS title_len_3, t0.title_omit AS title_omit_4, t0.description AS description_5, t0.is_show_title AS is_show_title_6, t0.is_show_short AS is_show_short_7, t0.per_page AS per_page_8, t0.position AS position_9, t0.style_sheet AS style_sheet_10, t0.content AS content_11, t0.type AS type_12, t0.content_list AS content_list_13, t0.more_url AS more_url_14, t0.params AS params_15, t0.sort AS sort_16, t0.is_repeat AS is_repeat_17, t0.orderby AS orderby_18, t0.tag_id AS tag_id_19 FROM moudle t0 WHERE t0.position = ? LIMIT 1
Parameters: [bottom_qr]
19 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_len AS title_len_3, t0.title_omit AS title_omit_4, t0.description AS description_5, t0.is_show_title AS is_show_title_6, t0.is_show_short AS is_show_short_7, t0.per_page AS per_page_8, t0.position AS position_9, t0.style_sheet AS style_sheet_10, t0.content AS content_11, t0.type AS type_12, t0.content_list AS content_list_13, t0.more_url AS more_url_14, t0.params AS params_15, t0.sort AS sort_16, t0.is_repeat AS is_repeat_17, t0.orderby AS orderby_18, t0.tag_id AS tag_id_19 FROM moudle t0 WHERE t0.position = ? LIMIT 1
Parameters: [bottom_flink]

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
  • The association Lag\Bundles\Admin\ArticleBundle\Entity\Article#page refers to the inverse side field Lag\Bundles\Admin\PageBundle\Entity\Page#articles which does not exist.
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
  • The association Lag\Bundles\Admin\CaseBundle\Entity\Batch#client_tips refers to the owning side field Lag\Bundles\Admin\ClientBundle\Entity\ClientTip#batch which does not exist.
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.
Lag\Bundles\Admin\CaseBundle\Entity\BatchStage No errors.
Lag\Bundles\Admin\CaseBundle\Entity\BatchStep No errors.
Lag\Bundles\Admin\ClientBundle\Entity\ClientTip
  • The association Lag\Bundles\Admin\ClientBundle\Entity\ClientTip#client refers to the inverse side field Lag\Bundles\Admin\ClientBundle\Entity\Client#client_tips which does not exist.
Lag\Bundles\Admin\CaseBundle\Entity\BatchTip No errors.
Lag\Bundles\Admin\ClientBundle\Entity\ClientDealInfo
  • The association Lag\Bundles\Admin\ClientBundle\Entity\ClientDealInfo#client_account refers to the inverse side field Lag\Bundles\Admin\ClientBundle\Entity\ClientAccount#client_deal_infos which does not exist.
Lag\Bundles\Admin\ClientBundle\Entity\ClientAccount
  • The mappings Lag\Bundles\Admin\ClientBundle\Entity\ClientAccount#clinet_deal_infos and Lag\Bundles\Admin\ClientBundle\Entity\ClientDealInfo#client_account are inconsistent with each other.
Lag\Bundles\Admin\ClientBundle\Entity\ClientTag No errors.