SHOW FULL COLUMNS FROM `hx_classes` [ RunTime:0.000726s ]
SELECT * FROM `hx_classes` WHERE ( `id` = 12 AND `status` = 1 ) AND `hx_classes`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000519s ]
SHOW FULL COLUMNS FROM `hx_tags` [ RunTime:0.000461s ]
SHOW FULL COLUMNS FROM `hx_classes_tags_rs` [ RunTime:0.000391s ]
SELECT `hx_tags`.*,`pivot`.`classes_id` AS `pivot__classes_id`,`pivot`.`tags_id` AS `pivot__tags_id` FROM `hx_tags` INNER JOIN `hx_classes_tags_rs` `pivot` ON `pivot`.`tags_id`=`hx_tags`.`id` WHERE ( `pivot`.`classes_id` = '12' ) AND `hx_tags`.`delete_time` IS NULL [ RunTime:0.000366s ]
SHOW FULL COLUMNS FROM `hx_teacher` [ RunTime:0.000568s ]
SELECT `teacher_title`,`name`,`wx_img`,`id`,`avatar` FROM `hx_teacher` WHERE ( `id` = 708 ) AND `hx_teacher`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `hx_classes_course` [ RunTime:0.000557s ]
SELECT id as classes_course_id,`title`,`classes_id`,`id` FROM `hx_classes_course` WHERE ( `classes_id` = 12 AND `status` = 1 ) AND `hx_classes_course`.`delete_time` IS NULL ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000381s ]
SHOW FULL COLUMNS FROM `hx_classes_course_video` [ RunTime:0.000555s ]
SELECT `classes_course_id`,`video_id`,`title` FROM `hx_classes_course_video` WHERE ( `classes_id` = 12 ) AND `hx_classes_course_video`.`delete_time` IS NULL [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `hx_video` [ RunTime:0.000606s ]
SELECT `duration`,`id` FROM `hx_video` WHERE ( `id` IN (40,41,42,43,44,45,46,47,48,49,50,51,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163) ) AND `hx_video`.`delete_time` IS NULL [ RunTime:0.000902s ]
SHOW FULL COLUMNS FROM `hx_classes_collect` [ RunTime:0.000619s ]
SELECT `id` FROM `hx_classes_collect` WHERE `classes_id` = 12 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000323s ]
SELECT COUNT(*) AS think_count FROM `hx_classes_collect` WHERE `classes_id` = 12 [ RunTime:0.000238s ]
SHOW FULL COLUMNS FROM `hx_common_all` [ RunTime:0.000577s ]
SELECT COUNT(*) AS think_count FROM `hx_common_all` WHERE `classes_id` = 12 AND `delete_time` IS NULL AND `type_id` = 1 [ RunTime:0.014435s ]
SELECT sum(score) as total_score,`type_id` FROM `hx_common_all` WHERE `classes_id` = 12 AND `delete_time` IS NULL GROUP BY `type_id` [ RunTime:0.015777s ]
SELECT `users_id`,`total_score`,`create_time`,`remark` FROM `hx_common_all` WHERE `classes_id` = 12 AND `delete_time` IS NULL AND `type_id` = 1 LIMIT 3 [ RunTime:0.018129s ]
SHOW FULL COLUMNS FROM `hx_order` [ RunTime:0.000730s ]
SELECT COUNT(*) AS think_count FROM `hx_order` WHERE ( `classes_id` = 12 AND `order_status` = 2 ) AND `hx_order`.`delete_time` IS NULL [ RunTime:0.000427s ]
SELECT `id` FROM `hx_order` WHERE ( `classes_id` = 12 AND `order_status` = 2 AND `users_id` = 0 ) AND `hx_order`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000347s ]