SHOW FULL COLUMNS FROM `cp_category_site_pin` [ RunTime:0.001781s ]
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.000851s ]
SHOW FULL COLUMNS FROM `cp_category` [ RunTime:0.001424s ]
SELECT `name`,`id` FROM `cp_category` WHERE `id` IN (524,464,429,283) AND `deletetime` IS NULL AND `status` = 1 [ RunTime:0.000776s ]
SHOW FULL COLUMNS FROM `cp_article` [ RunTime:0.001430s ]
SELECT `category_id` FROM `cp_article` WHERE `id` IN (24,25) AND `site_id` = 4 [ RunTime:0.000971s ]
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.005334s ]
SHOW FULL COLUMNS FROM `cp_article_image` [ RunTime:0.001330s ]
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.000662s ]
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.000754s ]
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.001901s ]
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.000576s ]
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.000684s ]
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.000555s ]
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.000546s ]
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.000544s ]
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.000550s ]
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.000520s ]
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.000548s ]
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.000541s ]
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.000529s ]
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.000641s ]
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.000540s ]
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.000543s ]
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.000513s ]
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.000533s ]
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.000683s ]
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.000639s ]
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.000561s ]
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.000577s ]
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.000555s ]
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.000543s ]
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.000535s ]
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.000620s ]
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.000602s ]
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.000711s ]
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.000564s ]
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.000566s ]
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.000634s ]
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.000568s ]
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.000552s ]
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.001238s ]
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.000614s ]
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.000607s ]
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.000623s ]
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.000681s ]
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.000645s ]
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.000605s ]
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.000665s ]
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.002454s ]
SELECT * FROM `cp_category` WHERE `id` = 566 AND `deletetime` IS NULL AND `status` = 1 LIMIT 1 [ RunTime:0.000628s ]