[ DB ] CONNECT:[ UseTime:0.005346s ] mysql:host=rm-fbkj-out-01.mysql.rds.aliyuncs.com;port=3366;dbname=huidianmall;charset=utf8
[ SQL ] SHOW COLUMNS FROM `huidian_web_setting` [ RunTime:0.003442s ]
[ SQL ] SELECT * FROM `huidian_web_setting` WHERE `web_id` = 1 LIMIT 1 [ RunTime:0.002990s ]
[ SQL ] SHOW COLUMNS FROM `huidian_goods_baseinfo` [ RunTime:0.003411s ]
[ SQL ] SELECT `id`,`is_sys`,`mt_id`,`shop_id`,`from_type`,`pcate`,`ccate`,`type`,`displayorder`,`title`,`keywords`,`shorttitle`,`thumb`,`mini_thumb`,`unit`,`goodssn`,`productsn`,`oldprice`,`vipprice`,`standardprice`,`total`,`totalcnf`,`sales`,`salesreal`,`weight`,`hasoption`,`isnew`,`isbaokuan`,`ishot`,`istemai`,`isgood`,`isbbs`,`isjingpin`,`isbrand`,`isrecommand`,`isyiqing`,`cash`,`dispatchtype`,`dispatchid`,`dispatchprice`,`longdispatchprice`,`toolongdispatchprice`,`minprice`,`maxprice`,`maxbuy`,`minbuy`,`timesbuy`,`subtitle`,`province_id`,`city_id`,`area_id`,`showtotal`,`viewcount`,`checked`,`deleted`,`addtime`,`edittime`,`status`,`activityId` FROM `huidian_goods_baseinfo` WHERE `pcate` = 1248 AND `deleted` = 2 AND `status` = 1 ORDER BY `addtime` DESC LIMIT 0,16 [ RunTime:0.003819s ]
[ SQL ] SHOW COLUMNS FROM `huidian_goods_category` [ RunTime:0.003662s ]
[ SQL ] SELECT * FROM `huidian_goods_category` WHERE `id` = 1248 AND `is_show` = 1 LIMIT 1 [ RunTime:0.002996s ]
[ SQL ] SELECT * FROM `huidian_goods_category` WHERE `parentid` = 1248 AND `is_show` = 1 [ RunTime:0.002917s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `huidian_goods_baseinfo` WHERE `total` > 0 AND `pcate` = 1248 AND `deleted` = 2 AND `status` = 1 [ RunTime:0.003107s ]