SHOW FULL COLUMNS FROM `xfys_proj` [ RunTime:0.001413s ]
SELECT COUNT(*) AS think_count FROM `xfys_proj` `x1` WHERE ( x1.isvalid=1 ) LIMIT 1 [ RunTime:0.000377s ]
SELECT x1.* ,if((x1.tel=0),1,0) is_sbr,if((x1.cbr_tel=0),1,0) is_cbr, if((x1.id in (select project_id from xfys_proj_pdphrymd x2 where x2.mobile = 0 and dw_type='查验方')), 1, 0) is_cyr FROM `xfys_proj` `x1` WHERE ( x1.isvalid=1 ) ORDER BY is_sbr desc,x1.creattime desc,is_cyr desc,is_cbr desc LIMIT 0,30 [ RunTime:0.064466s ]
SELECT `ssq` FROM `xfys_proj` [ RunTime:0.000799s ]
