[ DB ] CONNECT:[ UseTime:0.004111s ] mysql:host=rm-uf62rd00w555hmb6lno.mysql.rds.aliyuncs.com;port=3306;dbname=sportzb8;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tbl_d_slide` [ RunTime:0.002780s ]
[ SQL ] SELECT * FROM `tbl_d_slide` WHERE ( column_id=1 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.002597s ]
[ SQL ] SELECT
distinct a.id,a.title,a.is_home_recommend
FROM
tbl_b_column c,
tbl_d_cat ca,
tbl_r_tag_cat rtc,
tbl_d_tag t,
tbl_r_tag_article rta,
tbl_d_article a
WHERE c.id='1' AND ca.id='212'
AND c.id = ca.column_id
AND ca.id = rtc.cat_id
AND rtc.tag_id = t.id
AND t.id = rta.tag_id
AND rta.article_id = a.id
AND a.status=1
ORDER BY a.is_home_recommend desc,a.id DESC
LIMIT 0, '11' [ RunTime:0.006516s ]
[ SQL ] SELECT
a.id,
a.cover,
a.title
FROM
`tbl_d_recommend` r,
`tbl_d_article` a
WHERE r.column_id = 1
AND a.status=1
AND r.`article_id`=a.id
AND a.cover IS NOT NULL
AND a.cover != ''
ORDER BY r.sort
LIMIT 4 [ RunTime:0.002623s ]
[ SQL ] SELECT
a.id,
a.cover,
a.title,
a.content,
a.add_time
FROM
`tbl_d_article` a
WHERE a.status=1
AND a.cover IS NOT NULL
AND a.cover != ''
and a.level2_id <>1190
ORDER BY id desc
LIMIT 4 [ RunTime:0.003649s ]
[ SQL ] SELECT
t.id,
t.`title`
FROM
`tbl_d_article` a,
`tbl_r_tag_article` ta,
tbl_d_tag t
WHERE a.id = 88889
AND a.status=1
AND a.id = ta.`article_id`
AND ta.`tag_id` = t.id [ RunTime:0.004261s ]
[ SQL ] SELECT
t.id,
t.`title`
FROM
`tbl_d_article` a,
`tbl_r_tag_article` ta,
tbl_d_tag t
WHERE a.id = 88888
AND a.status=1
AND a.id = ta.`article_id`
AND ta.`tag_id` = t.id [ RunTime:0.004301s ]
[ SQL ] SELECT
t.id,
t.`title`
FROM
`tbl_d_article` a,
`tbl_r_tag_article` ta,
tbl_d_tag t
WHERE a.id = 88887
AND a.status=1
AND a.id = ta.`article_id`
AND ta.`tag_id` = t.id [ RunTime:0.004292s ]
[ SQL ] SELECT
t.id,
t.`title`
FROM
`tbl_d_article` a,
`tbl_r_tag_article` ta,
tbl_d_tag t
WHERE a.id = 88886
AND a.status=1
AND a.id = ta.`article_id`
AND ta.`tag_id` = t.id [ RunTime:0.004189s ]
[ SQL ] SELECT DISTINCT
a.id,
a.title,
a.cover
FROM
tbl_d_article a
WHERE level2_id ='1190'
AND a.status = 1
ORDER BY a.id DESC
LIMIT 0, 12 [ RunTime:0.003533s ]
[ SQL ] SELECT * FROM `tbl_b_column` WHERE id IN (1005,1009,1007,1008,1010,1017) [ RunTime:0.004784s ]
[ SQL ] SELECT DISTINCT
a.id,
a.title,
a.cover
FROM
tbl_d_article a
WHERE level2_id ='1005'
AND a.status = 1
ORDER BY a.id DESC
LIMIT 0, 12 [ RunTime:0.002574s ]
[ SQL ] SELECT DISTINCT
a.id,
a.title,
a.cover
FROM
tbl_d_article a
WHERE level2_id ='1007'
AND a.status = 1
ORDER BY a.id DESC
LIMIT 0, 12 [ RunTime:0.002619s ]
[ SQL ] SELECT DISTINCT
a.id,
a.title,
a.cover
FROM
tbl_d_article a
WHERE level2_id ='1008'
AND a.status = 1
ORDER BY a.id DESC
LIMIT 0, 12 [ RunTime:0.002650s ]
[ SQL ] SELECT DISTINCT
a.id,
a.title,
a.cover
FROM
tbl_d_article a
WHERE level2_id ='1009'
AND a.status = 1
ORDER BY a.id DESC
LIMIT 0, 12 [ RunTime:0.002605s ]
[ SQL ] SELECT DISTINCT
a.id,
a.title,
a.cover
FROM
tbl_d_article a
WHERE level2_id ='1010'
AND a.status = 1
ORDER BY a.id DESC
LIMIT 0, 12 [ RunTime:0.003148s ]
[ SQL ] SELECT DISTINCT
a.id,
a.title,
a.cover
FROM
tbl_d_article a
WHERE level2_id ='1017'
AND a.status = 1
ORDER BY a.id DESC
LIMIT 0, 12 [ RunTime:0.002842s ]
