[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:dbname=zhaoxinbao;host=localhost;charset=utf8
[ SQL ] SHOW COLUMNS FROM `zxb_user_list` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_user_list` WHERE `isUse` = 1 AND `id` = 0 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `zxb_city_list` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_city_list` WHERE `pid` = 0 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_city_list` WHERE `name` = '' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_city_list` WHERE `name` = '美国' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `zxb_ads_list` [ RunTime:0.000000s ]
[ SQL ] SELECT `title`,`linkURL` FROM `zxb_ads_list` WHERE `classID` = 1 ORDER BY sortID asc [ RunTime:0.000000s ]
[ SQL ] SELECT `title`,`subTitle`,`content`,`linkURL` FROM `zxb_ads_list` WHERE `classID` = 3 ORDER BY sortID asc [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `zxb_order_list` [ RunTime:0.000000s ]
[ SQL ] UPDATE `zxb_order_list` SET `status`=-1,`status_1Date`='2019-10-19 23:11:31',`memoList`='24小时未付款，订单自动关闭。' WHERE ( status=0 and addDate<'2019-10-18 23:11:31' ) [ RunTime:0.000000s ]
[ SQL ] UPDATE `zxb_order_list` SET `status`=3,`status3Date`='2019-10-19 23:11:31' WHERE ( status=2 and goodsID in(select id from zxb_goods_list where moneyDate<'2019-10-19 23:11:31') ) [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `zxb_attribute_list` [ RunTime:0.015625s ]
[ SQL ] SELECT `content` FROM `zxb_attribute_list` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `content` FROM `zxb_attribute_list` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `content` FROM `zxb_attribute_list` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `photo`,`title`,`linkURL` FROM `zxb_ads_list` WHERE `classID` = 2 ORDER BY sortID asc [ RunTime:0.000000s ]
[ SQL ] SELECT `photo`,`title`,`linkURL` FROM `zxb_ads_list` WHERE `classID` = 4 ORDER BY content like '%广东省%' desc,sortID asc [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `zxb_school_list` [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`logo`,`name`,`domain` FROM `zxb_school_list` WHERE `isUse` = 1 AND `homeHot` = 1 ORDER BY vip desc,prov=440000 desc,sortID asc,scoreZXB desc,scoreUser desc [ RunTime:0.000000s ]
[ SQL ] SELECT `photo`,`title`,`linkURL` FROM `zxb_ads_list` WHERE `classID` = 5 ORDER BY content like '%广东省%' desc,sortID asc [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `zxb_goods_list` [ RunTime:0.000000s ]
[ SQL ] SELECT `goods`.*,school.name as schoolName,school.stype as schoolType,school.logo as logo FROM `zxb_goods_list` `goods` INNER JOIN `zxb_school_list` `school` ON `goods`.`schoolID`=`school`.`id` WHERE `goods`.`isUse` = 1 AND `goods`.`isCheck` = 1 AND ( goods.schoolID<>28 ) AND `goods`.`endDate` >= '2019-10-19 23:11:31' ORDER BY id desc LIMIT 10 [ RunTime:0.015625s ]
[ SQL ] SHOW COLUMNS FROM `zxb_goods_class_list` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `classID` = 0 AND `isUse` = 1 AND `isHome` = 1 ORDER BY sortID asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 1 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 7 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 8 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 9 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 10 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 11 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 12 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 84 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT `goods`.*,school.name as schoolName,school.stype as schoolType,school.logo as logo FROM `zxb_goods_list` `goods` INNER JOIN `zxb_school_list` `school` ON `goods`.`schoolID`=`school`.`id` WHERE `goods`.`isUse` = 1 AND `goods`.`isCheck` = 1 AND `goods`.`classID` IN ('1','7','8','9','10','11','12','84') AND `goods`.`endDate` >= '2019-10-19 23:11:31' ORDER BY goods.prov=440000 desc,goods.vipSort asc,goods.sortID asc LIMIT 8 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 2 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 13 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 14 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT `goods`.*,school.name as schoolName,school.stype as schoolType,school.logo as logo FROM `zxb_goods_list` `goods` INNER JOIN `zxb_school_list` `school` ON `goods`.`schoolID`=`school`.`id` WHERE `goods`.`isUse` = 1 AND `goods`.`isCheck` = 1 AND `goods`.`classID` IN ('2','13','14') AND `goods`.`endDate` >= '2019-10-19 23:11:31' ORDER BY goods.prov=440000 desc,goods.vipSort asc,goods.sortID asc LIMIT 8 [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 3 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 21 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 22 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 23 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 24 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 25 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT `goods`.*,school.name as schoolName,school.stype as schoolType,school.logo as logo FROM `zxb_goods_list` `goods` INNER JOIN `zxb_school_list` `school` ON `goods`.`schoolID`=`school`.`id` WHERE `goods`.`isUse` = 1 AND `goods`.`isCheck` = 1 AND `goods`.`classID` IN ('3','21','22','23','24','25') AND `goods`.`endDate` >= '2019-10-19 23:11:31' ORDER BY goods.prov=440000 desc,goods.vipSort asc,goods.sortID asc LIMIT 8 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 4 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 26 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 27 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 28 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 29 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT `goods`.*,school.name as schoolName,school.stype as schoolType,school.logo as logo FROM `zxb_goods_list` `goods` INNER JOIN `zxb_school_list` `school` ON `goods`.`schoolID`=`school`.`id` WHERE `goods`.`isUse` = 1 AND `goods`.`isCheck` = 1 AND `goods`.`classID` IN ('4','26','27','28','29') AND `goods`.`endDate` >= '2019-10-19 23:11:31' ORDER BY goods.prov=440000 desc,goods.vipSort asc,goods.sortID asc LIMIT 8 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 5 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 30 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 31 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 32 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 33 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 34 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 35 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 36 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 37 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 38 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 39 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 40 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 85 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 86 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_goods_class_list` WHERE `isUse` = 1 AND `classID` = 87 ORDER BY sortID asc,id asc [ RunTime:0.000000s ]
[ SQL ] SELECT `goods`.*,school.name as schoolName,school.stype as schoolType,school.logo as logo FROM `zxb_goods_list` `goods` INNER JOIN `zxb_school_list` `school` ON `goods`.`schoolID`=`school`.`id` WHERE `goods`.`isUse` = 1 AND `goods`.`isCheck` = 1 AND `goods`.`classID` IN ('5','30','31','32','33','34','35','36','37','38','39','40','85','86','87') AND `goods`.`endDate` >= '2019-10-19 23:11:31' ORDER BY goods.prov=440000 desc,goods.vipSort asc,goods.sortID asc LIMIT 8 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `zxb_news_list` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `zxb_news_list` WHERE ( isUse=1 and isSystem=1 and (MATCH (tags) AGAINST ('|高招直播|') or title like '%高招直播%') ) ORDER BY isTop desc,(isHot>0 and addDate>'2019-10-16 23:11:31') desc,sortID desc,prov=440000 desc LIMIT 6 [ RunTime:0.218750s ]
[ SQL ] SELECT * FROM `zxb_news_list` WHERE ( isUse=1 and isSystem=1 and (MATCH (tags) AGAINST ('|自学考试|') or title like '%自学考试%') ) ORDER BY isTop desc,(isHot>0 and addDate>'2019-10-16 23:11:31') desc,sortID desc,prov=440000 desc LIMIT 6 [ RunTime:0.218750s ]
[ SQL ] SELECT * FROM `zxb_news_list` WHERE ( isUse=1 and isSystem=1 and (MATCH (tags) AGAINST ('|成人教育|') or title like '%成人教育%') ) ORDER BY isTop desc,(isHot>0 and addDate>'2019-10-16 23:11:31') desc,sortID desc,prov=440000 desc LIMIT 6 [ RunTime:0.218750s ]
[ SQL ] SHOW COLUMNS FROM `zxb_page_list` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zxb_page_list` WHERE ( isUse=1 and id=100 ) LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `content` FROM `zxb_attribute_list` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `content` FROM `zxb_attribute_list` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zxb_user_list` LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `content` FROM `zxb_attribute_list` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zxb_school_list` WHERE `isUse` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `content` FROM `zxb_attribute_list` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zxb_school_list` WHERE `isUse` = 0 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `content` FROM `zxb_attribute_list` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zxb_goods_list` WHERE `isUse` = 1 AND `isCheck` = 1 LIMIT 1 [ RunTime:0.000000s ]
小翼科普
丰源教育
暨大珠海分校
岭东培训
成科教育