SHOW COLUMNS FROM `zz_config` [ RunTime:0.015625s ]
SELECT `varname`,`value` FROM `zz_config` [ RunTime:0.000000s ]
SHOW COLUMNS FROM `zz_species` [ RunTime:0.015625s ]
SELECT * FROM `zz_species` WHERE ( s_fId=0 ) [ RunTime:0.015625s ]
SELECT * FROM `zz_species` WHERE ( s_fId=1 ) [ RunTime:0.000000s ]
SELECT * FROM `zz_species` WHERE ( s_fId=7 ) [ RunTime:0.000000s ]
SELECT * FROM `zz_species` WHERE ( s_fId=46 ) [ RunTime:0.000000s ]
SELECT * FROM `zz_species` WHERE ( s_fId=49 ) [ RunTime:0.000000s ]
SHOW COLUMNS FROM `zz_species` [ RunTime:0.000000s ]
SELECT * FROM `zz_species` WHERE ( s_fId=8 and tj=0 ) [ RunTime:0.015625s ]
SELECT * FROM `zz_species` WHERE ( s_fId=8 and tj=1 ) [ RunTime:0.000000s ]
SELECT * FROM `zz_species` WHERE ( s_fId=8 and tj=0 ) [ RunTime:0.000000s ]
SELECT * FROM `zz_species` WHERE ( s_fId=8 and tj=1 ) [ RunTime:0.000000s ]
SHOW COLUMNS FROM `zz_products` [ RunTime:0.015625s ]
SELECT COUNT(*) AS tp_count FROM `zz_products` WHERE ( `p_sId1` = 8 ) AND ( `p_sId3` = 100 ) AND ( `price` > 8 ) AND ( `characteristic` LIKE '%品牌开发商%' ) AND ( `buildingtype` LIKE '%住宅%' ) LIMIT 1 [ RunTime:0.015625s ]
SELECT * FROM `zz_products` WHERE ( `p_sId1` = 8 ) AND ( `p_sId3` = 100 ) AND ( `price` > 8 ) AND ( `characteristic` LIKE '%品牌开发商%' ) AND ( `buildingtype` LIKE '%住宅%' ) ORDER BY p_id desc LIMIT 0,12 [ RunTime:0.000000s ]
SELECT `s_Name` FROM `zz_species` WHERE ( s_Id=26 ) LIMIT 1 [ RunTime:0.000000s ]
SELECT `s_Name` FROM `zz_species` WHERE ( s_Id=100 ) LIMIT 1 [ RunTime:0.000000s ]
SELECT * FROM `zz_products` WHERE ( lx=2 and p_sId1=8 ) ORDER BY p_id desc LIMIT 0,10 [ RunTime:0.000000s ]
