SHOW FULL COLUMNS FROM `tp_course_category` [ RunTime:0.001133s ]
SELECT `id`,`name`,`pid` FROM `tp_course_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000432s ]
SELECT `id` FROM `tp_course_category` WHERE `pid` = 1 [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `tp_course` [ RunTime:0.001474s ]
SELECT COUNT(*) AS think_count FROM `tp_course` WHERE `status` = 2 AND `delete_time` IS NULL AND `category_id` IN (1,2,3,4,5) [ RunTime:0.000696s ]
SELECT `id`,`title`,`subtitle`,`cover`,`price`,`market_price`,`price_negotiable`,`price_unit`,`course_type`,`age_groups`,`category_id`,`merchant_id`,`teacher_ids`,`view_count`,`sales_count` FROM `tp_course` WHERE `status` = 2 AND `delete_time` IS NULL AND `category_id` IN (1,2,3,4,5) ORDER BY `is_top` DESC,`is_recommend` DESC,`sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000497s ]
SHOW FULL COLUMNS FROM `tp_merchant` [ RunTime:0.001276s ]
SELECT `short_name`,`name`,`id` FROM `tp_merchant` WHERE `id` = 1 [ RunTime:0.000437s ]
SELECT `name`,`id` FROM `tp_course_category` WHERE `id` = 1 [ RunTime:0.000335s ]
SELECT `id`,`name` FROM `tp_course_category` WHERE `merchant_id` = 0 AND `is_nav` = 1 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 12 [ RunTime:0.000486s ]