SHOW FULL COLUMNS FROM `hc_country` [ RunTime:0.000579s ]
SELECT `name`,`lid` FROM `hc_country` WHERE `is_delete` = 0 [ RunTime:0.000393s ]
SHOW FULL COLUMNS FROM `hc_job` [ RunTime:0.000595s ]
SELECT COUNT(*) AS think_count FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 AND `country` IN ('丹麦','乌克兰','俄罗斯','保加利亚','克罗地亚','冰岛','列支敦士登','匈牙利','北马其顿','卢森堡','圣马力诺','塞尔维亚','塞浦路斯','奥地利','安道尔','希腊','德国','意大利','拉脱维亚','挪威','捷克','摩尔多瓦','摩纳哥','斯洛伐克','斯洛文尼亚','梵蒂冈','比利时','法国','波兰','波斯尼亚和黑塞哥维那','爱尔兰','爱沙尼亚','瑞典','瑞士','白俄罗斯','科索沃','立陶宛','罗马尼亚','芬兰','英国','荷兰','葡萄牙','西班牙','阿尔巴尼亚','马耳他','黑山') AND `istop` > 0 ) [ RunTime:0.000918s ]
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 `istop` > 0 ) ORDER BY istop DESC, isurgent DESC, is_hot DESC, newtime DESC, addtime DESC, id DESC LIMIT 12,12 [ RunTime:0.000693s ]
SHOW FULL COLUMNS FROM `www_setup` [ RunTime:0.000368s ]
SELECT `value`,`alias` FROM `www_setup` WHERE `is_delete` = 0 [ RunTime:0.000266s ]