SHOW FULL COLUMNS FROM `es_news` [ RunTime:0.071944s ]
SELECT * FROM `es_news` WHERE `ispid` = 6 AND `nid` = 2024 AND `isshow` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.071628s ]
UPDATE `es_news` SET `vtime` = `vtime` + 21 WHERE `ispid` = 6 AND `nid` = 2024 AND `isshow` = 1 AND `status` = 1 [ RunTime:0.071736s ]
SHOW FULL COLUMNS FROM `es_course` [ RunTime:0.071843s ]
SELECT a.id,a.title,a.files,a.uid,a.names,a.ctype,a.xtags,a.ttags,a.catname,a.shdesc,sum(b.price) amount FROM `es_course` `a` INNER JOIN `es_cucost` `b` ON `a`.`id`=`b`.`cuid` INNER JOIN `es_orgcom` `c` ON `a`.`uid`=c.uid and c.status=1 and c.isauth=1 WHERE `a`.`status` = '1' AND `a`.`ispid` = '6' AND ( ishot=1 and ctype=1 ) GROUP BY `a`.`id` ORDER BY a.sort desc,a.id asc LIMIT 2 [ RunTime:0.072593s ]
SELECT `nid`,`uid`,`title`,`files`,`video`,`vtime`,`ztime`,`album`,`shdesc`,`source`,`createtime` FROM `es_news` WHERE `isshow` = 1 AND `status` = 1 AND `ispick` = 1 AND `ispid` = 6 AND `platform` IN (1,99) AND ( nid<>2024 ) ORDER BY `sort` DESC,`nid` DESC LIMIT 6 [ RunTime:0.073312s ]