SHOW FULL COLUMNS FROM `hc_country` [ RunTime:0.000568s ]
SELECT `name`,`lid` FROM `hc_country` WHERE `is_delete` = 0 [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `hc_job` [ RunTime:0.000523s ]
SELECT COUNT(*) AS think_count FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 AND `country` IN ('东加','图瓦卢','基里巴斯','密克罗尼西亚联邦','巴布亚新几内亚','帕劳','所罗门群岛','斐济','新西兰','汤加','澳大利亚','瑙鲁','瓦努阿图','萨摩亚','马绍尔群岛') AND `is_hot` = 1 ) [ RunTime:0.000502s ]
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 `is_hot` = 1 ) ORDER BY istop DESC, isurgent DESC, is_hot DESC, newtime DESC, addtime DESC, id DESC LIMIT 0,12 [ RunTime:0.000591s ]
SHOW FULL COLUMNS FROM `www_setup` [ RunTime:0.000405s ]
SELECT `value`,`alias` FROM `www_setup` WHERE `is_delete` = 0 [ RunTime:0.000248s ]