SHOW FULL COLUMNS FROM `hc_country` [ RunTime:0.000996s ]
SELECT `name`,`lid` FROM `hc_country` WHERE `is_delete` = 0 [ RunTime:0.001138s ]
SHOW FULL COLUMNS FROM `hc_job` [ RunTime:0.001615s ]
SELECT COUNT(*) AS think_count FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 AND `country` IN ('中非共和国','乌干达','乍得','佛得角','冈比亚','几内亚','几内亚比绍','刚果(布)','刚果(金)','利比亚','利比里亚','加纳','加蓬','南苏丹','南非','博茨瓦纳','卢旺达','厄立特里亚','吉布提','喀麦隆','圣多美和普林西比','坦桑尼亚','埃及','埃塞俄比亚','塞内加尔','塞拉利昂','塞舌尔','多哥','安哥拉','尼日利亚','尼日尔','布基纳法索','布隆迪','摩洛哥','斯威士兰','毛里塔尼亚','毛里求斯','津巴布韦','科摩罗','科特迪瓦','突尼斯','索马里','纳米比亚','肯尼亚','苏丹','莫桑比克','莱索托','贝宁','赞比亚','赤道几内亚','阿尔及利亚','马拉维','马达加斯加','马里') AND `isurgent` > 0 ) [ RunTime:0.001840s ]
SELECT `id`,`name`,`country`,`cat`,`people`,`money`,`tags`,`hits`,`istop`,`isurgent`,`is_hot`,`newtime`,`addtime` FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 AND `country` IN ('中非共和国','乌干达','乍得','佛得角','冈比亚','几内亚','几内亚比绍','刚果(布)','刚果(金)','利比亚','利比里亚','加纳','加蓬','南苏丹','南非','博茨瓦纳','卢旺达','厄立特里亚','吉布提','喀麦隆','圣多美和普林西比','坦桑尼亚','埃及','埃塞俄比亚','塞内加尔','塞拉利昂','塞舌尔','多哥','安哥拉','尼日利亚','尼日尔','布基纳法索','布隆迪','摩洛哥','斯威士兰','毛里塔尼亚','毛里求斯','津巴布韦','科摩罗','科特迪瓦','突尼斯','索马里','纳米比亚','肯尼亚','苏丹','莫桑比克','莱索托','贝宁','赞比亚','赤道几内亚','阿尔及利亚','马拉维','马达加斯加','马里') AND `isurgent` > 0 ) ORDER BY istop DESC, isurgent DESC, is_hot DESC, newtime DESC, addtime DESC, id DESC LIMIT 120,12 [ RunTime:0.002140s ]
SHOW FULL COLUMNS FROM `www_setup` [ RunTime:0.000422s ]
SELECT `value`,`alias` FROM `www_setup` WHERE `is_delete` = 0 [ RunTime:0.000270s ]