SHOW FULL COLUMNS FROM `jx_classobject` [ RunTime:0.000850s ]
SELECT * FROM `jx_classobject` WHERE `cid` = 87 LIMIT 1 [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `jx_setmeal` [ RunTime:0.000700s ]
SELECT * FROM `jx_setmeal` WHERE `pid` = 0 LIMIT 1 [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `jx_appraise` [ RunTime:0.000639s ]
SELECT `a`.*,`m`.`mobile`,`m`.`headimgurl` FROM `jx_appraise` `a` LEFT JOIN `jx_member` `m` ON `a`.`userid`=`m`.`member_id` WHERE `a`.`lessonid` = '87' AND `a`.`status` = 1 [ RunTime:0.001019s ]
SHOW FULL COLUMNS FROM `jx_video_path` [ RunTime:0.000659s ]
SELECT COUNT(*) AS think_count FROM `jx_video_path` WHERE `class_id` = 87 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `jx_userclass` [ RunTime:0.000679s ]
SELECT COUNT(*) AS think_count FROM `jx_userclass` WHERE `classid` = '87' [ RunTime:0.000334s ]
SHOW FULL COLUMNS FROM `jx_teacher` [ RunTime:0.000635s ]
SELECT * FROM `jx_teacher` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000308s ]
SELECT `cid`,`objectname` FROM `jx_classobject` WHERE `pid` = 0 AND `status` = 1 ORDER BY `cid` DESC LIMIT 6 [ RunTime:0.000704s ]
SHOW FULL COLUMNS FROM `jx_lessonword` [ RunTime:0.000628s ]
SELECT COUNT(*) AS think_count FROM `jx_lessonword` WHERE `lessonid` = 87 AND `status` = 1 [ RunTime:0.000347s ]
SELECT * FROM `jx_video_path` WHERE `class_id` = 87 ORDER BY `bsort` ASC [ RunTime:0.000345s ]
SELECT * FROM `jx_lessonword` WHERE `lessonid` = 87 AND `status` = 1 LIMIT 1 [ RunTime:0.000330s ]
SELECT COUNT(*) AS think_count FROM `jx_appraise` WHERE `lessonid` = 87 AND `status` = 1 [ RunTime:0.000641s ]