[ SQL ] SELECT * FROM `gz_config` WHERE `closed` = 0 LIMIT 1 [ RunTime:0.001573s ]
[ SQL ] SELECT * FROM `gz_config` WHERE `closed` = 0 LIMIT 1 [ RunTime:0.001856s ]
[ SQL ] SELECT `is_showask` FROM `gz_show_switch` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000680s ]
[ SQL ] SELECT `is_live` FROM `gz_show_switch` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000616s ]
[ SQL ] SHOW COLUMNS FROM `gz_webmenu` [ RunTime:0.003244s ]
[ SQL ] SELECT `url`,`title`,`type`,`seo_keywords`,`seo_description` FROM `gz_webmenu` WHERE `status` = 1 AND `closed` = 0 ORDER BY orderby asc LIMIT 0,7 [ RunTime:0.000588s ]
[ SQL ] SHOW COLUMNS FROM `gz_link` [ RunTime:0.001660s ]
[ SQL ] SELECT `title`,`url` FROM `gz_link` WHERE `status` = 1 AND `closed` = 0 ORDER BY orderby desc [ RunTime:0.000418s ]
[ SQL ] SHOW COLUMNS FROM `gz_course` [ RunTime:0.003090s ]
[ SQL ] SELECT * FROM `gz_course` WHERE `closed` = 0 AND `cid` = 28 ORDER BY orderby desc LIMIT 1 [ RunTime:0.001179s ]
[ SQL ] SHOW COLUMNS FROM `gz_course_category` [ RunTime:0.002544s ]
[ SQL ] SELECT `cate_name` FROM `gz_course_category` WHERE `id` = 126 LIMIT 1 [ RunTime:0.000986s ]
[ SQL ] SELECT `cate_name` FROM `gz_course_category` WHERE `id` = 127 AND `closed` = 0 LIMIT 1 [ RunTime:0.001978s ]
[ SQL ] SHOW COLUMNS FROM `gz_course_introduce` [ RunTime:0.003730s ]
[ SQL ] SELECT * FROM `gz_course_introduce` WHERE `cid` = 28 AND `closed` = 0 ORDER BY `orderby` desc [ RunTime:0.001192s ]
[ SQL ] SHOW COLUMNS FROM `gz_video_category` [ RunTime:0.006041s ]
[ SQL ] SELECT `id`,`cid`,`cate_name` FROM `gz_video_category` WHERE `cid` = 28 AND `closed` = 0 ORDER BY `orderby` asc [ RunTime:0.002160s ]
[ SQL ] SHOW COLUMNS FROM `gz_order` [ RunTime:0.001665s ]
[ SQL ] SELECT `uid` FROM `gz_order` WHERE `course_id` = 28 AND `pay_status` = 1 AND `closed` = 0 GROUP BY `uid` [ RunTime:0.000438s ]
[ SQL ] SHOW COLUMNS FROM `gz_user` [ RunTime:0.001207s ]
[ SQL ] SELECT `uid`,`uname`,`face` FROM `gz_user` WHERE `uid` IN (5,8,28,59,86) AND `closed` = 0 [ RunTime:0.000511s ]
[ SQL ] SELECT * FROM `gz_user` WHERE `uid` IS NULL AND `closed` = 0 LIMIT 1 [ RunTime:0.000488s ]
[ SQL ] SELECT `is_testitemshop` FROM `gz_show_switch` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000432s ]
[ SQL ] SHOW COLUMNS FROM `gz_testitem_bank` [ RunTime:0.001078s ]
[ SQL ] SELECT * FROM `gz_testitem_bank` WHERE `closed` = 0 AND `audit` = 1 AND `course_id` = 28 ORDER BY course_id asc [ RunTime:0.000597s ]
[ SQL ] SELECT `id` FROM `gz_video_category` WHERE `cid` = 28 AND `audit` = 1 [ RunTime:0.000263s ]
[ SQL ] SHOW COLUMNS FROM `gz_video` [ RunTime:0.001067s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `gz_video` WHERE `cid` = 28 AND `tid` IN (41,42,49,50) AND `audit` = 1 AND `live_id` = 0 AND `closed` = 0 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `gz_video` WHERE `cid` = 28 AND `tid` IN (41,42,49,50) AND `audit` = 1 AND `live_id` > 0 AND `closed` = 0 LIMIT 1 [ RunTime:0.000357s ]
[ SQL ] SHOW COLUMNS FROM `gz_study_record` [ RunTime:0.000794s ]
[ SQL ] SELECT `a`.`video_id`,`a`.`duration` FROM `gz_study_record` `a` INNER JOIN `gz_video` `b` ON `a`.`video_id`=`b`.`id` WHERE `a`.`user_id` IS NULL AND `a`.`closed` = 0 AND `a`.`course_id` = '28' AND `b`.`audit` = 1 AND `b`.`closed` = 0 ORDER BY a.update_time desc LIMIT 1 [ RunTime:0.000894s ]
[ SQL ] SELECT `id` FROM `gz_video` WHERE `cid` = 28 AND `closed` = 0 AND `audit` = 1 AND `live_id` = 0 ORDER BY orderby asc LIMIT 1 [ RunTime:0.000438s ]
购买
