SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.003568s ]
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.010637s ]
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 3870,10 [ RunTime:0.010820s ]
SHOW FULL COLUMNS FROM `cms_article_keywords` [ RunTime:0.001702s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '591' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001571s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '590' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001203s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '589' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001052s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '588' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001094s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '587' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001182s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '586' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001191s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '585' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001161s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '584' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001201s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '583' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001093s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '582' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001501s ]
SHOW FULL COLUMNS FROM `cms_article_cate` [ RunTime:0.001628s ]
SELECT * FROM `cms_article_cate` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000792s ]
SELECT * FROM `cms_article_cate` ORDER BY `sort` DESC [ RunTime:0.000782s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.025546s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.008900s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.003723s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.015073s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.003959s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.003818s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.011443s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.019939s ]
SHOW FULL COLUMNS FROM `cms_keywords` [ RunTime:0.003767s ]
SELECT * FROM `cms_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.001041s ]
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 10 [ RunTime:0.067590s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '191' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001054s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2875' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001172s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '650' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000953s ]
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.001047s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3218' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001177s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1710' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001356s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2721' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001371s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1155' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001931s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1083' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001426s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2894' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001223s ]
SHOW FULL COLUMNS FROM `cms_user_log` [ RunTime:0.001490s ]