SHOW FULL COLUMNS FROM `categories` [ RunTime:0.005845s ]
SELECT id,name FROM `categories` WHERE `is_deleted` = 0 [ RunTime:0.000659s ]
SHOW FULL COLUMNS FROM `portfolio` [ RunTime:0.002056s ]
SELECT COUNT(*) AS think_count FROM `portfolio` `p` LEFT JOIN `users` ON `p`.`user_id`=`users`.`id` LEFT JOIN `files` ON `p`.`file_id`=`files`.`id` WHERE `is_deleted` = 0 [ RunTime:0.001030s ]
SELECT `p`.`id`,`p`.`name`,`p`.`url`,`p`.`description`,`p`.`file_id`,`files`.`path`,`files`.`thumb_path`,`users`.`username`,`users`.`avatar`,`p`.`created_at` FROM `portfolio` `p` LEFT JOIN `users` ON `p`.`user_id`=`users`.`id` LEFT JOIN `files` ON `p`.`file_id`=`files`.`id` WHERE `is_deleted` = 0 LIMIT 0,5 [ RunTime:0.000611s ]