[ DB ] CONNECT:[ UseTime:0.004279s ] mysql:host=rm-uf62rd00w555hmb6lno.mysql.rds.aliyuncs.com;port=3306;dbname=sportzb8;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tbl_d_slide` [ RunTime:0.002862s ]
[ SQL ] SELECT * FROM `tbl_d_slide` WHERE ( column_id=1 ) ORDER BY `sort` ASC,`id` DESC [ RunTime:0.002721s ]
[ SQL ] SHOW COLUMNS FROM `tbl_b_column` [ RunTime:0.002925s ]
[ SQL ] SELECT * FROM `tbl_b_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.002693s ]
[ 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.005499s ]
[ 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.002972s ]
[ 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.003842s ]
[ SQL ] SELECT
t.id,
t.`title`
FROM
`tbl_d_article` a,
`tbl_r_tag_article` ta,
tbl_d_tag t
WHERE a.id = 88560
AND a.status=1
AND a.id = ta.`article_id`
AND ta.`tag_id` = t.id [ RunTime:0.003011s ]
[ SQL ] SELECT
t.id,
t.`title`
FROM
`tbl_d_article` a,
`tbl_r_tag_article` ta,
tbl_d_tag t
WHERE a.id = 88559
AND a.status=1
AND a.id = ta.`article_id`
AND ta.`tag_id` = t.id [ RunTime:0.002954s ]
[ SQL ] SELECT
t.id,
t.`title`
FROM
`tbl_d_article` a,
`tbl_r_tag_article` ta,
tbl_d_tag t
WHERE a.id = 88558
AND a.status=1
AND a.id = ta.`article_id`
AND ta.`tag_id` = t.id [ RunTime:0.002982s ]
[ SQL ] SELECT
t.id,
t.`title`
FROM
`tbl_d_article` a,
`tbl_r_tag_article` ta,
tbl_d_tag t
WHERE a.id = 88557
AND a.status=1
AND a.id = ta.`article_id`
AND ta.`tag_id` = t.id [ RunTime:0.002977s ]
[ 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.002891s ]
[ SQL ] SELECT * FROM `tbl_b_column` WHERE id IN (1005,1009,1007,1008,1010,1017) [ RunTime:0.005082s ]
[ 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.002634s ]
[ 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.002740s ]
[ 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.002824s ]
[ 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.002689s ]
[ 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.002836s ]
[ 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.002673s ]
