[ DB ] CONNECT:[ UseTime:0.001917s ] mysql:host=192.168.4.240;dbname=cgdsj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `zp` [ RunTime:0.026057s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zp` WHERE ( zptype=1 and (ComTrade like '%快速消费品%') ) LIMIT 1 [ RunTime:0.044980s ]
[ SQL ] SELECT * FROM `zp` WHERE ( zptype=1 and (ComTrade like '%快速消费品%') ) ORDER BY `updatetime` DESC LIMIT 0,30 [ RunTime:0.004562s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zp` WHERE ( zptype=1 and (ComTrade like '%快速消费品%') ) ORDER BY `updatetime` DESC LIMIT 1 [ RunTime:0.002098s ]
[ SQL ] SHOW COLUMNS FROM `fbanner_ad` [ RunTime:0.008126s ]
[ SQL ] SELECT * FROM `fbanner_ad` WHERE ( FadClass='117' and FShow=1 and FIsDel=0 ) ORDER BY `FOrders` ASC,`FAddtime` DESC LIMIT 5 [ RunTime:0.001774s ]
[ SQL ] SELECT * FROM `fbanner_ad` WHERE ( FadClass='112' and FShow=1 and FIsDel=0 ) ORDER BY `FOrders` ASC,`FAddtime` DESC LIMIT 4 [ RunTime:0.001515s ]
[ SQL ] SHOW COLUMNS FROM `zy` [ RunTime:0.003608s ]
[ SQL ] SELECT `zyid`,`zyname` FROM `zy` WHERE ( 1=1 ) [ RunTime:0.006004s ]
[ SQL ] SHOW COLUMNS FROM `trade_zw` [ RunTime:0.003235s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=0 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001671s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.002693s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001938s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001866s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.002077s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001994s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001499s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001308s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001074s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001163s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001113s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001169s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001103s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001470s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001055s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001350s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001112s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001115s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001188s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001070s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001035s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001143s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001167s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.000998s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001099s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001095s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001231s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001018s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001140s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001342s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001290s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001266s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001158s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001315s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001282s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001466s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001239s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001561s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001609s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001644s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001490s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=6600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001317s ]
[ SQL ] SHOW COLUMNS FROM `region` [ RunTime:0.004813s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001207s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001112s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001235s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001091s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001123s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001255s ]