Symfony Profiler

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

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 = 'search' LIMIT 1;

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

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 '%left%' AND p2_.id = 5 ORDER BY m1_.sort ASC;

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

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 '%right%' AND p2_.id = 5 ORDER BY m1_.sort ASC;

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

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;

SELECT 
  count(DISTINCT a0_.id) AS sclr_0 
FROM 
  article a0_ 
WHERE 
  a0_.stock_code = ? 
  AND a0_.status = 0

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.stock_code = '600696' AND a0_.status = 0;

SELECT 
  DISTINCT a0_.id AS id_0, 
  a0_.is_recommend AS is_recommend_1, 
  a0_.created_at AS created_at_2 
FROM 
  article a0_ 
WHERE 
  a0_.stock_code = ? 
  AND a0_.status = 0 
ORDER BY 
  a0_.is_recommend DESC, 
  a0_.created_at DESC 
LIMIT 
  30 OFFSET 0

SELECT DISTINCT a0_.id AS id_0, a0_.is_recommend AS is_recommend_1, a0_.created_at AS created_at_2 FROM article a0_ WHERE a0_.stock_code = '600696' AND a0_.status = 0 ORDER BY a0_.is_recommend DESC, a0_.created_at DESC LIMIT 30 OFFSET 0;

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_.status = 0 
  AND a0_.id IN (?) 
ORDER BY 
  a0_.is_recommend DESC, 
  a0_.created_at DESC

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 = '600696' AND a0_.status = 0 AND a0_.id IN ('7520', '5285', '5114', '4578', '4464', '4116', '3764', '3584', '3578', '3180', '2834', '2473', '2047', '2027', '1307', '1204', '892', '722', '111', '60') ORDER BY a0_.is_recommend DESC, a0_.created_at DESC;

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 = ?

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 = 2;