[ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=192.168.4.240;dbname=cgdsj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `zp` [ RunTime:0.008440s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zp` WHERE ( zptype=1 and (ComTrade like '%广告%') ) LIMIT 1 [ RunTime:0.001729s ]
[ SQL ] SELECT * FROM `zp` WHERE ( zptype=1 and (ComTrade like '%广告%') ) ORDER BY `updatetime` DESC LIMIT 0,30 [ RunTime:0.002265s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zp` WHERE ( zptype=1 and (ComTrade like '%广告%') ) ORDER BY `updatetime` DESC LIMIT 1 [ RunTime:0.001251s ]
[ SQL ] SHOW COLUMNS FROM `fbanner_ad` [ RunTime:0.003983s ]
[ SQL ] SELECT * FROM `fbanner_ad` WHERE ( FadClass='117' and FShow=1 and FIsDel=0 ) ORDER BY `FOrders` ASC,`FAddtime` DESC LIMIT 5 [ RunTime:0.001146s ]
[ SQL ] SELECT * FROM `fbanner_ad` WHERE ( FadClass='112' and FShow=1 and FIsDel=0 ) ORDER BY `FOrders` ASC,`FAddtime` DESC LIMIT 4 [ RunTime:0.001179s ]
[ SQL ] SHOW COLUMNS FROM `zy` [ RunTime:0.003001s ]
[ SQL ] SELECT `zyid`,`zyname` FROM `zy` WHERE ( 1=1 ) [ RunTime:0.004524s ]
[ SQL ] SHOW COLUMNS FROM `trade_zw` [ RunTime:0.003831s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=0 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.003209s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001873s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001340s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001540s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001122s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001137s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001206s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001275s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001059s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001095s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001188s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001214s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001338s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001173s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001024s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001179s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001093s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001114s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001076s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001132s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001297s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.002030s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001247s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001733s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001409s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001326s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001259s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001232s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001684s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001395s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001508s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001013s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001108s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001209s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001085s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001267s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001004s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001112s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001047s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001076s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001420s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=6600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001294s ]
[ SQL ] SHOW COLUMNS FROM `region` [ RunTime:0.007947s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001329s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001166s ]