SHOW FULL COLUMNS FROM `cate` [ RunTime:0.064911s ]
SELECT * FROM `cate` WHERE `pid` = 0 AND `status` = 1 [ RunTime:0.063607s ]
SELECT * FROM `cate` WHERE `status` = 1 AND `pid` = 21 [ RunTime:0.063510s ]
SHOW FULL COLUMNS FROM `subject` [ RunTime:0.066791s ]
SELECT * FROM `subject` WHERE `status` = 1 AND `cate_id` = 27 [ RunTime:0.063433s ]
SHOW FULL COLUMNS FROM `course` [ RunTime:0.064344s ]
SHOW FULL COLUMNS FROM `lesson` [ RunTime:0.065449s ]
SELECT *,(SELECT COUNT(*) AS think_count FROM `lesson` `count_table` WHERE `status` = 1 AND ( `count_table`.`course_id` =course.id ) ORDER BY `sort`,`id`) AS `lesson_count` FROM `course` WHERE `status` = 1 AND `subject_id` = 133 AND `cate_id` = 27 LIMIT 20 [ RunTime:0.064081s ]
