SHOW FULL COLUMNS FROM `pg_config` [ RunTime:0.001006s ]
SHOW FULL COLUMNS FROM `pg_xuzhoujob_resume` [ RunTime:0.001226s ]
SELECT COUNT(*) AS think_count FROM `pg_xuzhoujob_resume` WHERE ( (`juzhudi` LIKE '%鼓楼%' OR `juzhudi` LIKE '%殷庄%' OR `juzhudi` LIKE '%九里%' OR `juzhudi` LIKE '%朝阳%' OR `juzhudi` LIKE '%金山桥%' OR `juzhudi` LIKE '%大黄山%' OR `juzhudi` LIKE '%大庙%') OR (`yixiangquyu` LIKE '%鼓楼%' OR `yixiangquyu` LIKE '%殷庄%' OR `yixiangquyu` LIKE '%九里%' OR `yixiangquyu` LIKE '%朝阳%' OR `yixiangquyu` LIKE '%金山桥%' OR `yixiangquyu` LIKE '%大黄山%' OR `yixiangquyu` LIKE '%大庙%') ) LIMIT 1 [ RunTime:0.995196s ]
SELECT * FROM `pg_xuzhoujob_resume` WHERE ( (`juzhudi` LIKE '%鼓楼%' OR `juzhudi` LIKE '%殷庄%' OR `juzhudi` LIKE '%九里%' OR `juzhudi` LIKE '%朝阳%' OR `juzhudi` LIKE '%金山桥%' OR `juzhudi` LIKE '%大黄山%' OR `juzhudi` LIKE '%大庙%') OR (`yixiangquyu` LIKE '%鼓楼%' OR `yixiangquyu` LIKE '%殷庄%' OR `yixiangquyu` LIKE '%九里%' OR `yixiangquyu` LIKE '%朝阳%' OR `yixiangquyu` LIKE '%金山桥%' OR `yixiangquyu` LIKE '%大黄山%' OR `yixiangquyu` LIKE '%大庙%') ) ORDER BY `updatetime` DESC,`id` DESC LIMIT 9240,20 [ RunTime:0.319361s ]