SHOW FULL COLUMNS FROM `categories` [ RunTime:0.005313s ]
SELECT id,name FROM `categories` WHERE `is_deleted` = 0 [ RunTime:0.000575s ]
SHOW FULL COLUMNS FROM `articles` [ RunTime:0.001544s ]
SELECT COUNT(*) AS think_count FROM `articles` LEFT JOIN `categories` ON `articles`.`category_id`=`categories`.`id` LEFT JOIN `users` ON `articles`.`user_id`=`users`.`id` LEFT JOIN `files` ON `articles`.`thumb_file_id`=`files`.`id` WHERE `articles`.`status` = '1' AND `articles`.`is_deleted` = '0' [ RunTime:0.000853s ]
SELECT `articles`.`id`,`articles`.`title`,`articles`.`abstract`,`articles`.`content`,`articles`.`created_at`,`articles`.`thumb_file_id`,`files`.`path`,`categories`.`name`,`users`.`username`,`articles`.`category_id` FROM `articles` LEFT JOIN `categories` ON `articles`.`category_id`=`categories`.`id` LEFT JOIN `users` ON `articles`.`user_id`=`users`.`id` LEFT JOIN `files` ON `articles`.`thumb_file_id`=`files`.`id` WHERE `articles`.`status` = '1' AND `articles`.`is_deleted` = '0' ORDER BY `articles`.`updated_at` DESC LIMIT 0,5 [ RunTime:0.000572s ]
