SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.002227s ]
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.011490s ]
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 3930,10 [ RunTime:0.011641s ]
SHOW FULL COLUMNS FROM `cms_article_keywords` [ RunTime:0.001847s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '531' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001684s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '530' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001210s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '529' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001188s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '528' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001446s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '527' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001251s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '526' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001668s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '525' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001854s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '524' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001399s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '523' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000991s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '522' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001022s ]
SHOW FULL COLUMNS FROM `cms_article_cate` [ RunTime:0.002497s ]
SELECT * FROM `cms_article_cate` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001270s ]
SELECT * FROM `cms_article_cate` ORDER BY `sort` DESC [ RunTime:0.001075s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.004881s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.004926s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.004692s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.004619s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.004526s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.004853s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.004696s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.003814s ]
SHOW FULL COLUMNS FROM `cms_keywords` [ RunTime:0.001746s ]
SELECT * FROM `cms_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.001416s ]
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.047981s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '128' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.003424s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2670' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001199s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '4118' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001310s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '514' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001138s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1282' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001183s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3781' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001436s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3938' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001059s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1012' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001017s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3558' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001015s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '920' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001018s ]
SHOW FULL COLUMNS FROM `cms_user_log` [ RunTime:0.002616s ]