[ DB ] CONNECT:[ UseTime:0.002949s ] mysql:host=192.168.4.240;dbname=cgdsj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `zp` [ RunTime:0.007111s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zp` WHERE ( zptype=1 and (ComTrade like '%餐饮%') ) LIMIT 1 [ RunTime:0.001614s ]
[ SQL ] SELECT * FROM `zp` WHERE ( zptype=1 and (ComTrade like '%餐饮%') ) ORDER BY `updatetime` DESC LIMIT 0,30 [ RunTime:0.002751s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `zp` WHERE ( zptype=1 and (ComTrade like '%餐饮%') ) ORDER BY `updatetime` DESC LIMIT 1 [ RunTime:0.001637s ]
[ SQL ] SHOW COLUMNS FROM `fbanner_ad` [ RunTime:0.004254s ]
[ SQL ] SELECT * FROM `fbanner_ad` WHERE ( FadClass='117' and FShow=1 and FIsDel=0 ) ORDER BY `FOrders` ASC,`FAddtime` DESC LIMIT 5 [ RunTime:0.001519s ]
[ SQL ] SELECT * FROM `fbanner_ad` WHERE ( FadClass='112' and FShow=1 and FIsDel=0 ) ORDER BY `FOrders` ASC,`FAddtime` DESC LIMIT 4 [ RunTime:0.001615s ]
[ SQL ] SHOW COLUMNS FROM `zy` [ RunTime:0.004606s ]
[ SQL ] SELECT `zyid`,`zyname` FROM `zy` WHERE ( 1=1 ) [ RunTime:0.006033s ]
[ SQL ] SHOW COLUMNS FROM `trade_zw` [ RunTime:0.004980s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=0 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001816s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001849s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001446s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001531s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001478s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001223s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001565s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001543s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001409s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001686s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=1900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001321s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001356s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001562s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001472s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001537s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001427s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001453s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001462s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001343s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.004737s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=2900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.002564s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3000 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001855s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3100 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001812s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001558s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001820s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001720s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001935s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001495s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001845s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=3800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001498s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4200 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001659s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4300 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001732s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001745s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4500 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.002090s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001437s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4700 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001728s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001797s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=4900 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001734s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5400 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001525s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001551s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=5800 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001765s ]
[ SQL ] SELECT * FROM `trade_zw` WHERE ( parentid=6600 and isShow=1 ) ORDER BY `orders` ASC [ RunTime:0.001835s ]
[ SQL ] SHOW COLUMNS FROM `region` [ RunTime:0.006533s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530114003000 LIMIT 1 [ RunTime:0.001533s ]
[ SQL ] SHOW COLUMNS FROM `region_town` [ RunTime:0.006903s ]
[ SQL ] SELECT * FROM `region_town` WHERE `provinceId` = '530114003000' LIMIT 1 [ RunTime:0.018383s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530114 LIMIT 1 [ RunTime:0.002039s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001481s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001722s ]
[ SQL ] SELECT * FROM `region` WHERE `provinceId` = 530100 LIMIT 1 [ RunTime:0.001413s ]