DVD 101.闪亮青春02.向着梦想奔跑03.出发04.麦田童话05.孔雀飞来06.太平声声07.校园之花08.成长09.红10.一行白鹭上青天11.田埂上12.有朋自远方来13.鄂伦春童话14.向天歌15.童年16.十五岁17.我的舞台我的梦18.飞翔 DVD 201.灵动的生命02.搓莜面03.舂米飘香04.红领巾创领未来05.家有儿女06.嘎跷蹦嘎07.绿池清波08.荷趣09.踩山10....
SHOW FULL COLUMNS FROM `zl_user_token` [ RunTime:0.000605s ]
SELECT `b`.* FROM `zl_user_token` `a` INNER JOIN `zl_user` `b` ON `a`.`user_id`=`b`.`user_id` WHERE `token` IS NULL AND `device_type` = 'pc' LIMIT 1 [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `zl_class` [ RunTime:0.000506s ]
SELECT `parentclass` FROM `zl_class` WHERE `classid` = 7 LIMIT 1 [ RunTime:0.000244s ]
SELECT * FROM `zl_class` WHERE `classid` IN (5,47,7) AND `classid` <> 5 ORDER BY field(classid,5,47,7) [ RunTime:0.000367s ]
SELECT `classname` FROM `zl_class` WHERE `classid` = 7 LIMIT 1 [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `zl_portal` [ RunTime:0.000567s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `zl_portal` `p` INNER JOIN `zl_class` `c` ON `c`.`classid`=`p`.`classid` WHERE ( `c`.`classid` = '7' OR `c`.`parentclass` LIKE '%|7|%' ) AND `onshow` = 1 GROUP BY `p`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`p`.`classid`,`c`.`classname`,`p`.`title`,`titlepic`,`newstext`,`price`,`buyfen`,`newstime`,`p`.`onclick` FROM `zl_portal` `p` INNER JOIN `zl_class` `c` ON `c`.`classid`=`p`.`classid` WHERE ( `c`.`classid` = '7' OR `c`.`parentclass` LIKE '%|7|%' ) AND `onshow` = 1 GROUP BY `p`.`id` ORDER BY `newstime` DESC,`isgood` DESC,`firsttitle` DESC,`p`.`onclick` DESC LIMIT 0,20 [ RunTime:0.000868s ]