SHOW FULL COLUMNS FROM `cp_category_site_pin` [ RunTime:0.001909s ]
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.000828s ]
SHOW FULL COLUMNS FROM `cp_category` [ RunTime:0.001409s ]
SELECT `name`,`id` FROM `cp_category` WHERE `id` IN (524,464,429,283) AND `deletetime` IS NULL AND `status` = 1 [ RunTime:0.000680s ]
SHOW FULL COLUMNS FROM `cp_article` [ RunTime:0.001357s ]
SELECT `category_id` FROM `cp_article` WHERE `id` IN (24,25) AND `site_id` = 4 [ RunTime:0.000601s ]
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.003265s ]
SHOW FULL COLUMNS FROM `cp_article_image` [ RunTime:0.001271s ]
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.000599s ]
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.000552s ]
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.000658s ]
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.000661s ]
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.000541s ]
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.000567s ]
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.000574s ]
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.000545s ]
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.000611s ]
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.000636s ]
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.000620s ]
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.000589s ]
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.000527s ]
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.000543s ]
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.000510s ]
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.000558s ]
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.000563s ]
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.000523s ]
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.000597s ]
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.000499s ]
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.000522s ]
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.000557s ]
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.000575s ]
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.000568s ]
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.000548s ]
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.000551s ]
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.000536s ]
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.000603s ]
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.000591s ]
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.000581s ]
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.000627s ]
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.000624s ]
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.000548s ]
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.000655s ]
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.001062s ]
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.000660s ]
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.000708s ]
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.000589s ]
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.000829s ]
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.000618s ]
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.000549s ]
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.000636s ]
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.001839s ]
SELECT * FROM `cp_category` WHERE `id` = 558 AND `deletetime` IS NULL AND `status` = 1 LIMIT 1 [ RunTime:0.000565s ]