SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.001173s ]
SELECT COUNT(*) AS think_count FROM `cms_article` `a` LEFT JOIN `cms_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' AND `a`.`cate_id` = '7' LIMIT 1 [ RunTime:0.006228s ]
SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,`a`.`create_time`,`a`.`read`,`a`.`desc`,`f`.`filepath` FROM `cms_article` `a` LEFT JOIN `cms_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' AND `a`.`cate_id` = '7' ORDER BY `a`.`id` DESC LIMIT 2780,20 [ RunTime:0.004925s ]
SHOW FULL COLUMNS FROM `cms_article_keywords` [ RunTime:0.001098s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1681' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000978s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1680' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001674s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1679' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000553s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1678' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000665s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1677' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000537s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1676' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000588s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1675' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000511s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1674' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000501s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1673' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000549s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1672' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000604s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1671' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000523s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1670' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000547s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1669' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000572s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1668' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000555s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1667' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000590s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1666' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000570s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1665' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000617s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1664' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000534s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1663' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000521s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1662' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `cms_article_cate` [ RunTime:0.000841s ]
SELECT * FROM `cms_article_cate` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000656s ]
SELECT * FROM `cms_article_cate` ORDER BY `sort` DESC [ RunTime:0.000499s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002727s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.002374s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.002263s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.002226s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.002258s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.002225s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.002378s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.002241s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 9 AND `status` = 1 LIMIT 1 [ RunTime:0.002195s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 10 AND `status` = 1 LIMIT 1 [ RunTime:0.002233s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 11 AND `status` = 1 LIMIT 1 [ RunTime:0.002252s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 12 AND `status` = 1 LIMIT 1 [ RunTime:0.002148s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 13 AND `status` = 1 LIMIT 1 [ RunTime:0.002187s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 14 AND `status` = 1 LIMIT 1 [ RunTime:0.003309s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 15 AND `status` = 1 LIMIT 1 [ RunTime:0.002328s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 16 AND `status` = 1 LIMIT 1 [ RunTime:0.002206s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 17 AND `status` = 1 LIMIT 1 [ RunTime:0.002378s ]
SHOW FULL COLUMNS FROM `cms_keywords` [ RunTime:0.000840s ]
SELECT * FROM `cms_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.000755s ]
SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,`a`.`create_time`,`a`.`read`,`a`.`desc`,`f`.`filepath` FROM `cms_article` `a` LEFT JOIN `cms_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' ORDER BY rand() , a.id desc LIMIT 20 [ RunTime:0.020558s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '345' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000868s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1339' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000642s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '902' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000530s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '4318' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000552s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1495' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000516s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1143' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000518s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2333' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000592s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3159' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000977s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2867' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000531s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1302' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000617s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3669' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000546s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1365' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000658s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1108' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000585s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2369' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000594s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3081' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000540s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3285' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000564s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1901' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000486s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1701' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000557s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3804' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000521s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '4128' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000550s ]
SHOW FULL COLUMNS FROM `cms_user_log` [ RunTime:0.000849s ]