SHOW FULL COLUMNS FROM `hx_classes` [ RunTime:0.000862s ]
SELECT * FROM `hx_classes` WHERE ( `id` = 14 AND `status` = 1 ) AND `hx_classes`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000507s ]
SHOW FULL COLUMNS FROM `hx_tags` [ RunTime:0.000561s ]
SHOW FULL COLUMNS FROM `hx_classes_tags_rs` [ RunTime:0.000500s ]
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` = '14' ) AND `hx_tags`.`delete_time` IS NULL [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `hx_teacher` [ RunTime:0.000633s ]
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.000306s ]
SHOW FULL COLUMNS FROM `hx_classes_course` [ RunTime:0.000697s ]
SELECT id as classes_course_id,`title`,`classes_id`,`id` FROM `hx_classes_course` WHERE ( `classes_id` = 14 AND `status` = 1 ) AND `hx_classes_course`.`delete_time` IS NULL ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000471s ]
SHOW FULL COLUMNS FROM `hx_classes_course_video` [ RunTime:0.000683s ]
SELECT `classes_course_id`,`video_id`,`title` FROM `hx_classes_course_video` WHERE ( `classes_id` = 14 ) AND `hx_classes_course_video`.`delete_time` IS NULL [ RunTime:0.000694s ]
SHOW FULL COLUMNS FROM `hx_video` [ RunTime:0.000692s ]
SELECT `duration`,`id` FROM `hx_video` WHERE ( `id` IN (564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,498,499,500,501,502,503,504,505,506,507,490,491,492,493,494,495,496,497,482,483,484,485,486,487,488,489,466,467,468,469,470,471,472,473,448,449,450,451,452,453,454,455,456,457,432,433,434,435,436,437,438,439,405,406,407,408,409,410,411,412,413,414) ) AND `hx_video`.`delete_time` IS NULL [ RunTime:0.000849s ]
SHOW FULL COLUMNS FROM `hx_classes_collect` [ RunTime:0.000531s ]
SELECT `id` FROM `hx_classes_collect` WHERE `classes_id` = 14 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000281s ]
SELECT COUNT(*) AS think_count FROM `hx_classes_collect` WHERE `classes_id` = 14 [ RunTime:0.000246s ]
SHOW FULL COLUMNS FROM `hx_common_all` [ RunTime:0.000517s ]
SELECT COUNT(*) AS think_count FROM `hx_common_all` WHERE `classes_id` = 14 AND `delete_time` IS NULL AND `type_id` = 1 [ RunTime:0.011644s ]
SELECT sum(score) as total_score,`type_id` FROM `hx_common_all` WHERE `classes_id` = 14 AND `delete_time` IS NULL GROUP BY `type_id` [ RunTime:0.012286s ]
SELECT `users_id`,`total_score`,`create_time`,`remark` FROM `hx_common_all` WHERE `classes_id` = 14 AND `delete_time` IS NULL AND `type_id` = 1 LIMIT 3 [ RunTime:0.024263s ]
SHOW FULL COLUMNS FROM `hx_order` [ RunTime:0.015078s ]
SELECT COUNT(*) AS think_count FROM `hx_order` WHERE ( `classes_id` = 14 AND `order_status` = 2 ) AND `hx_order`.`delete_time` IS NULL [ RunTime:0.000470s ]
SELECT `id` FROM `hx_order` WHERE ( `classes_id` = 14 AND `order_status` = 2 AND `users_id` = 0 ) AND `hx_order`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000338s ]