SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.001282s ]
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.006489s ]
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 1240,20 [ RunTime:0.002908s ]
SHOW FULL COLUMNS FROM `cms_article_keywords` [ RunTime:0.001181s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3221' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000913s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3220' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000758s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3219' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000732s ]
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.000734s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3217' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000749s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3216' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000772s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3215' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000756s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3214' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000732s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3213' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000702s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3212' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000742s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3211' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000693s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3210' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000671s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3209' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000710s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3208' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000708s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3207' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000691s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3206' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000703s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3205' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000767s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3204' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000698s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3203' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000687s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3202' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000695s ]
SHOW FULL COLUMNS FROM `cms_article_cate` [ RunTime:0.001177s ]
SELECT * FROM `cms_article_cate` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000643s ]
SELECT * FROM `cms_article_cate` ORDER BY `sort` DESC [ RunTime:0.000587s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.002627s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.002569s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.002554s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.002505s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.002552s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.002572s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.002871s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.002584s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 9 AND `status` = 1 LIMIT 1 [ RunTime:0.002527s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 10 AND `status` = 1 LIMIT 1 [ RunTime:0.002754s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 11 AND `status` = 1 LIMIT 1 [ RunTime:0.003306s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 12 AND `status` = 1 LIMIT 1 [ RunTime:0.002554s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 13 AND `status` = 1 LIMIT 1 [ RunTime:0.002519s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 14 AND `status` = 1 LIMIT 1 [ RunTime:0.002516s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 15 AND `status` = 1 LIMIT 1 [ RunTime:0.002514s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 16 AND `status` = 1 LIMIT 1 [ RunTime:0.002492s ]
SELECT COUNT(*) AS think_count FROM `cms_article` WHERE `cate_id` = 17 AND `status` = 1 LIMIT 1 [ RunTime:0.002537s ]
SHOW FULL COLUMNS FROM `cms_keywords` [ RunTime:0.001109s ]
SELECT * FROM `cms_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.000959s ]
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.025383s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2223' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000915s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '4304' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000682s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3378' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000667s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '4385' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000754s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1859' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000806s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2974' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000727s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3582' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000708s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2691' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000743s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '2742' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000692s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '327' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000805s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3372' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000706s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '800' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000688s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1883' 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` = '3795' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000756s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '3877' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000815s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1242' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000705s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '813' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000686s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '1343' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000700s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '252' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000813s ]
SELECT `k`.`id`,`k`.`title` FROM `cms_article_keywords` `a` LEFT JOIN `cms_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '124' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000812s ]
SHOW FULL COLUMNS FROM `cms_user_log` [ RunTime:0.001089s ]