SHOW FULL COLUMNS FROM `hx_classes` [ RunTime:0.000732s ]
SELECT * FROM `hx_classes` WHERE ( `id` = 1289 AND `status` = 1 ) AND `hx_classes`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000531s ]
SHOW FULL COLUMNS FROM `hx_tags` [ RunTime:0.000471s ]
SHOW FULL COLUMNS FROM `hx_classes_tags_rs` [ RunTime:0.000413s ]
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` = '1289' ) AND `hx_tags`.`delete_time` IS NULL [ RunTime:0.000355s ]
SHOW FULL COLUMNS FROM `hx_teacher` [ RunTime:0.000609s ]
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.000329s ]
SHOW FULL COLUMNS FROM `hx_classes_course` [ RunTime:0.000513s ]
SELECT id as classes_course_id,`title`,`classes_id`,`id` FROM `hx_classes_course` WHERE ( `classes_id` = 1289 AND `status` = 1 ) AND `hx_classes_course`.`delete_time` IS NULL ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `hx_classes_course_video` [ RunTime:0.000484s ]
SELECT `classes_course_id`,`video_id`,`title` FROM `hx_classes_course_video` WHERE ( `classes_id` = 1289 ) AND `hx_classes_course_video`.`delete_time` IS NULL [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `hx_video` [ RunTime:0.000564s ]
SELECT `duration`,`id` FROM `hx_video` WHERE ( `id` IN (40,41,42,43,44,45,46,47,48,49,50,51,3934,3935,3820,9489,9490,9491,9492,9493,9494,9495,9496,9497,9498,9499,9500,9501,9502,9503,9504,9505,9506,9507,9508,9509,9510,9511,9512,9513,9514,9515,9516,9517,9518,9519,9520,9521,9522,9523,9524,9525,9526,9527,9432,9433,9434,9435,9436,9437,9438,9439,9440,9441,9442,9443,9444,9445,9446,9447,9448,9449,9450,9451,9452,9453,9454,9455,9456,9457,9458,9459,9460,9461,9462,9463,9464,9465,9466,9467,9468,9469,9470,9471,9472,9473,9474,9475,9476,9477,9478,9479,9480,9481,9482,9483,9419,9420,9421,9422,9423,9424,9425,9426,9427,9428,9429,9430,9431) ) AND `hx_video`.`delete_time` IS NULL [ RunTime:0.000889s ]
SHOW FULL COLUMNS FROM `hx_classes_collect` [ RunTime:0.000521s ]
SELECT `id` FROM `hx_classes_collect` WHERE `classes_id` = 1289 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000312s ]
SELECT COUNT(*) AS think_count FROM `hx_classes_collect` WHERE `classes_id` = 1289 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `hx_common_all` [ RunTime:0.000517s ]
SELECT COUNT(*) AS think_count FROM `hx_common_all` WHERE `classes_id` = 1289 AND `delete_time` IS NULL AND `type_id` = 1 [ RunTime:0.007619s ]
SELECT sum(score) as total_score,`type_id` FROM `hx_common_all` WHERE `classes_id` = 1289 AND `delete_time` IS NULL GROUP BY `type_id` [ RunTime:0.008457s ]
SELECT `users_id`,`total_score`,`create_time`,`remark` FROM `hx_common_all` WHERE `classes_id` = 1289 AND `delete_time` IS NULL AND `type_id` = 1 LIMIT 3 [ RunTime:0.009830s ]
SHOW FULL COLUMNS FROM `hx_order` [ RunTime:0.000735s ]
SELECT COUNT(*) AS think_count FROM `hx_order` WHERE ( `classes_id` = 1289 AND `order_status` = 2 ) AND `hx_order`.`delete_time` IS NULL [ RunTime:0.000422s ]
SELECT `id` FROM `hx_order` WHERE ( `classes_id` = 1289 AND `order_status` = 2 AND `users_id` = 0 ) AND `hx_order`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000347s ]