[ SQL ] SELECT * FROM `gz_config` WHERE `closed` = 0 LIMIT 1 [ RunTime:0.000313s ]
[ SQL ] SELECT * FROM `gz_config` WHERE `closed` = 0 LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SELECT `is_showask` FROM `gz_show_switch` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT `is_live` FROM `gz_show_switch` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000085s ]
[ SQL ] SHOW COLUMNS FROM `gz_webmenu` [ RunTime:0.000306s ]
[ 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.000119s ]
[ SQL ] SHOW COLUMNS FROM `gz_link` [ RunTime:0.000300s ]
[ SQL ] SELECT `title`,`url` FROM `gz_link` WHERE `status` = 1 AND `closed` = 0 ORDER BY orderby desc [ RunTime:0.000107s ]
[ SQL ] SHOW COLUMNS FROM `gz_course` [ RunTime:0.000473s ]
[ SQL ] SELECT `a`.`cid`,`a`.`goods_type`,`a`.`banner`,`a`.`price`,`a`.`title`,`a`.`desc`,`a`.`study_count`,`a`.`virtual_amount`,`b`.`cate_name`,(a.study_count+a.virtual_amount) as total_count,`a`.`course_mode`,`a`.`course_people` FROM `gz_course` `a` LEFT JOIN `gz_course_category` `b` ON `a`.`sub_id`=`b`.`id` WHERE `a`.`closed` = '0' AND `a`.`isgood` = '1' AND `a`.`audit` = '1' AND `a`.`goods_type` <> 2 ORDER BY a.orderby desc,a.create_time desc LIMIT 10 [ RunTime:0.000177s ]
[ SQL ] select v.transcoding_id,v.new,v.title,v.live_id,v.id,v.cid,v.tid,v.video_path,v.transcoding_path,v.free,v.lenght,IFNULL(s.status,0) as status,IFNULL(s.study_time,0) as study_time from gz_video v left join (select vid,status,study_time from gz_study_list where cid = 30 and cleaned = 0 and closed = 0 group by vid) s on v.id = s.vid where v.cid = 30 and v.closed = 0 and v.audit = 1 order by orderby asc [ RunTime:0.000266s ]
[ SQL ] select v.transcoding_id,v.new,v.title,v.live_id,v.id,v.cid,v.tid,v.video_path,v.transcoding_path,v.free,v.lenght,IFNULL(s.status,0) as status,IFNULL(s.study_time,0) as study_time from gz_video v left join (select vid,status,study_time from gz_study_list where cid = 28 and cleaned = 0 and closed = 0 group by vid) s on v.id = s.vid where v.cid = 28 and v.closed = 0 and v.audit = 1 order by orderby asc [ RunTime:0.000157s ]
[ SQL ] SELECT `a`.`cid`,`a`.`goods_type`,`a`.`banner`,`a`.`price`,`a`.`title`,`a`.`desc`,`a`.`study_count`,`a`.`virtual_amount`,`b`.`cate_name`,(a.study_count+a.virtual_amount) as total_count,`a`.`course_mode`,`a`.`course_people` FROM `gz_course` `a` LEFT JOIN `gz_course_category` `b` ON `a`.`sub_id`=`b`.`id` WHERE `a`.`closed` = '0' AND `a`.`audit` = '1' AND `a`.`goods_type` <> 2 ORDER BY total_count desc LIMIT 10 [ RunTime:0.000171s ]
[ SQL ] select v.transcoding_id,v.new,v.title,v.live_id,v.id,v.cid,v.tid,v.video_path,v.transcoding_path,v.free,v.lenght,IFNULL(s.status,0) as status,IFNULL(s.study_time,0) as study_time from gz_video v left join (select vid,status,study_time from gz_study_list where cid = 30 and cleaned = 0 and closed = 0 group by vid) s on v.id = s.vid where v.cid = 30 and v.closed = 0 and v.audit = 1 order by orderby asc [ RunTime:0.000159s ]
[ SQL ] select v.transcoding_id,v.new,v.title,v.live_id,v.id,v.cid,v.tid,v.video_path,v.transcoding_path,v.free,v.lenght,IFNULL(s.status,0) as status,IFNULL(s.study_time,0) as study_time from gz_video v left join (select vid,status,study_time from gz_study_list where cid = 28 and cleaned = 0 and closed = 0 group by vid) s on v.id = s.vid where v.cid = 28 and v.closed = 0 and v.audit = 1 order by orderby asc [ RunTime:0.000142s ]
[ SQL ] SHOW COLUMNS FROM `gz_course_category` [ RunTime:0.000306s ]
[ SQL ] SELECT `id`,`pid`,`cate_name` FROM `gz_course_category` WHERE `closed` = 0 ORDER BY orderby desc [ RunTime:0.000112s ]
[ SQL ] SHOW COLUMNS FROM `gz_adv_item` [ RunTime:0.000362s ]
[ SQL ] SELECT `photopath`,`link` FROM `gz_adv_item` WHERE `adv_id` = 3 AND `closed` = 0 ORDER BY orderby desc [ RunTime:0.000110s ]
[ SQL ] SHOW COLUMNS FROM `gz_live` [ RunTime:0.000451s ]
[ SQL ] SELECT `id`,`title`,`price`,`start_time`,`state`,`image`,`banner`,`vid`,`live_status`,`playback`,`live_mode`,`live_people` FROM `gz_live` WHERE `closed` = 0 AND `sell_alone` = 1 AND `status` = 1 ORDER BY live_status asc LIMIT 5 [ RunTime:0.000133s ]
[ SQL ] SHOW COLUMNS FROM `gz_package` [ RunTime:0.000400s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `gz_package` WHERE `audit` = 1 AND `closed` = 0 LIMIT 1 [ RunTime:0.000111s ]
[ SQL ] SELECT `id`,`title`,`price`,`banner`,`course_id` FROM `gz_package` WHERE `audit` = 1 AND `closed` = 0 ORDER BY create_time desc LIMIT 0,4 [ RunTime:0.000102s ]
[ SQL ] SHOW COLUMNS FROM `gz_article` [ RunTime:0.000385s ]
[ SQL ] SELECT `id`,`photopath`,`title`,`desc`,`create_time`,`views` FROM `gz_article` WHERE `audit` = 1 AND `closed` = 0 ORDER BY views desc LIMIT 4 [ RunTime:0.000117s ]
