SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.002867s ]
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.007871s ]
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 3820,10 [ RunTime:0.008144s ]
SHOW FULL COLUMNS FROM `cms_article_keywords` [ RunTime:0.001126s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '641' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000751s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '640' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000769s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '639' 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` = '638' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000996s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '637' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000807s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '636' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000753s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '635' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000675s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '634' 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` = '633' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000640s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '632' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000540s ]
SHOW FULL COLUMNS FROM `cms_article_cate` [ RunTime:0.001245s ]
SELECT * FROM `cms_article_cate` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000630s ]
SELECT * FROM `cms_article_cate` ORDER BY `sort` DESC [ RunTime:0.000641s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002776s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.002505s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.002506s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.002631s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.002893s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.002796s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.002909s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.002533s ]
SHOW FULL COLUMNS FROM `cms_keywords` [ RunTime:0.001089s ]
SELECT * FROM `cms_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.000687s ]
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.023060s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3798' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000919s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3253' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000635s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1345' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000578s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3138' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000782s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2014' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001016s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3953' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000637s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '692' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000568s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1965' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001157s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1127' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000816s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2115' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001077s ]
SHOW FULL COLUMNS FROM `cms_user_log` [ RunTime:0.000904s ]