#0 [time:0.0002s] SET character_set_connection=utf8mb4, character_set_results=utf8mb4, character_set_client=binary, sql_mode=''
#1 [time:0.0004s] SELECT * FROM le_cms_article WHERE id='8991' LIMIT 1 [explain type: const | rows: 1]
#2 [time:0.0005s] SELECT * FROM le_cms_article_data WHERE id='8991' LIMIT 1 [explain type: const | rows: 1]
#3 [time:0.0003s] SELECT * FROM le_cms_article_views WHERE id='8991' LIMIT 1 [explain type: const | rows: 1]
#4 [time:0.0010s] UPDATE LOW_PRIORITY le_cms_article_views SET views=views+1 WHERE id='8991' LIMIT 1
#5 [time:0.0004s] SELECT id FROM le_cms_article WHERE cid='5' AND id<'8991' ORDER BY id DESC LIMIT 0,1 [explain type: range | rows: 20384]
#6 [time:0.0003s] SELECT * FROM le_cms_article WHERE id='8989' LIMIT 1 [explain type: const | rows: 1]
#7 [time:0.0003s] SELECT id FROM le_cms_article WHERE cid='5' AND id>'8991' ORDER BY id ASC LIMIT 0,1 [explain type: range | rows: 9282]
#8 [time:0.0002s] SELECT like_id FROM le_likes WHERE mid='2' AND id='8991' AND ip='3628718116' [explain type: | rows: ]
#9 [time:0.0017s] SELECT tagid FROM le_cms_article_tag ORDER BY count DESC [explain type: index | rows: 6317]
#10 [time:0.0002s] SELECT tagid,id FROM le_cms_article_tag_data WHERE tagid='694' ORDER BY id DESC LIMIT 0,5 [explain type: ref | rows: 3181]
#11 [time:0.0002s] SELECT COUNT(*) AS num FROM le_cms_comment WHERE mid='2' [explain type: ref | rows: 716]
#12 [time:0.0001s] SELECT COUNT(*) AS num FROM le_category WHERE mid='2' [explain type: ref | rows: 28]
#13 [time:0.0002s] SET character_set_connection=utf8mb4, character_set_results=utf8mb4, character_set_client=binary, sql_mode=''
#14 [time:0.0512s] SELECT SUM(views) as views FROM le_cms_article_views [explain type: index | rows: 223147]
#15 [time:0.0004s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#16 [time:0.0003s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#17 [time:0.0003s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#18 [time:0.0003s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#19 [time:0.0003s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#20 [time:0.0003s] SELECT * FROM le_cms_article WHERE id='18624' LIMIT 1 [explain type: const | rows: 1]
#21 [time:0.0003s] SELECT * FROM le_cms_article WHERE id='147067' LIMIT 1 [explain type: const | rows: 1]
#22 [time:0.0002s] SELECT * FROM le_cms_article WHERE id='57695' LIMIT 1 [explain type: const | rows: 1]
#23 [time:0.0003s] SELECT id FROM le_cms_article_views WHERE cid='5' ORDER BY views DESC LIMIT 0,4 [explain type: ref | rows: 19788]
#24 [time:0.0004s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#25 [time:0.0003s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#26 [time:0.0003s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#27 [time:0.0003s] SELECT t1.id FROM le_cms_article AS t1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM le_cms_article)) AS id) AS t2 WHERE t1.id >= t2.id LIMIT 1 [explain type: system | rows: 1]
#28 [time:0.0003s] SELECT * FROM le_cms_article WHERE id='185608' LIMIT 1 [explain type: const | rows: 1]
#29 [time:0.0003s] SELECT * FROM le_cms_article WHERE id='213633' LIMIT 1 [explain type: const | rows: 1]
评论列表
发表评论