SHOW FULL COLUMNS FROM `cp_category_site_pin` [ RunTime:0.001779s ]
SELECT `category_id`,`pin_sort` FROM `cp_category_site_pin` WHERE `site_id` = 4 AND `is_pinned` = 1 ORDER BY `pin_sort` DESC LIMIT 8 [ RunTime:0.000895s ]
SHOW FULL COLUMNS FROM `cp_category` [ RunTime:0.001439s ]
SELECT `name`,`id` FROM `cp_category` WHERE `id` IN (524,464,429,283) AND `deletetime` IS NULL AND `status` = 1 [ RunTime:0.000732s ]
SHOW FULL COLUMNS FROM `cp_article` [ RunTime:0.001517s ]
SELECT `category_id` FROM `cp_article` WHERE `id` IN (24,25) AND `site_id` = 4 [ RunTime:0.000715s ]
SELECT `a`.`id`,`a`.`title`,`a`.`summary`,`a`.`content`,`a`.`createtime`,`a`.`updatetime`,`a`.`author`,`a`.`sort`,`a`.`publish_time`,c.name as category_name,c.id as category_id FROM `cp_article` `a` LEFT JOIN `cp_category` `c` ON `a`.`category_id`=`c`.`id` WHERE `a`.`site_id` = '4' AND `a`.`deletetime` IS NULL AND `a`.`status` = '1' ORDER BY `a`.`sort` DESC,`a`.`createtime` DESC [ RunTime:0.003446s ]
SHOW FULL COLUMNS FROM `cp_article_image` [ RunTime:0.001263s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '57' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000765s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '56' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000712s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '55' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000572s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '54' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000589s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '53' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000586s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '52' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000578s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '51' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000593s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '50' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000573s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '49' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000603s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '48' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000627s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '47' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000578s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '46' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000549s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '45' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000656s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '25' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000565s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '24' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000670s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '44' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000618s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '43' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000615s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '42' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000598s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '41' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000592s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '40' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000566s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '39' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000677s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '38' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000628s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '37' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000600s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '36' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000586s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '35' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000660s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '34' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000593s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '33' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000574s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '32' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000586s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '31' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000646s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '30' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000544s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '29' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000680s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '28' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000599s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '27' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000588s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '26' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000633s ]
SELECT a.id, a.title, a.sort, a.createtime, c.name as category_name, c.id as category_id, COALESCE(COUNT(cmt.id), 0) as comment_count FROM `cp_article` `a` LEFT JOIN `cp_category` `c` ON `a`.`category_id`=`c`.`id` LEFT JOIN `cp_article_comment` `cmt` ON `a`.`id`=cmt.article_id AND cmt.deletetime IS NULL WHERE `a`.`site_id` = '4' AND `a`.`deletetime` IS NULL AND `a`.`status` = '1' GROUP BY `a`.`id` ORDER BY COUNT(cmt.id) DESC, a.createtime DESC LIMIT 3 [ RunTime:0.000995s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '57' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.001056s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '56' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000687s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '55' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000657s ]
SELECT `a`.`id`,`a`.`title`,`a`.`createtime`,`a`.`publish_time`,c.name as category_name,c.id as category_id FROM `cp_article` `a` LEFT JOIN `cp_category` `c` ON `a`.`category_id`=`c`.`id` WHERE `a`.`site_id` = '4' AND `a`.`deletetime` IS NULL AND `a`.`status` = '1' ORDER BY `a`.`createtime` DESC,`a`.`publish_time` DESC LIMIT 3 [ RunTime:0.000864s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '57' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000959s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '56' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000595s ]
SELECT `f`.`path` FROM `cp_article_image` `ai` LEFT JOIN `files` `f` ON `ai`.`file_id`=`f`.`id` WHERE `ai`.`article_id` = '55' AND `ai`.`type` = '1' ORDER BY `ai`.`sort` ASC LIMIT 1 [ RunTime:0.000555s ]
SELECT c.id, c.name, c.sort, COALESCE(pin.is_pinned, 0) as is_pinned, COALESCE(pin.pin_sort, 0) as pin_sort FROM `cp_category` `c` LEFT JOIN `cp_category_site_pin` `pin` ON `c`.`id`=pin.category_id AND pin.site_id = 4 WHERE `c`.`deletetime` IS NULL AND `c`.`status` = '1' ORDER BY COALESCE(pin.is_pinned, 0) DESC, COALESCE(pin.pin_sort, 0) DESC, c.sort DESC, c.id ASC LIMIT 36 [ RunTime:0.002053s ]
SELECT * FROM `cp_category` WHERE `id` = 564 AND `deletetime` IS NULL AND `status` = 1 LIMIT 1 [ RunTime:0.000753s ]