SHOW FULL COLUMNS FROM `hc_job` [ RunTime:0.001496s ]
UPDATE `hc_job` SET `hits` = `hits` + 1 WHERE `id` = 4440 [ RunTime:0.005122s ]
SELECT `id`,`name`,`country`,`people`,`money`,`tags`,`note`,`hits`,`istop`,`master`,`contact`,`addtime` FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 ) AND `id` = 4440 LIMIT 1 [ RunTime:0.000297s ]
SELECT `id`,`name`,`country`,`people`,`money` FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 ) AND `country` = '新加坡' AND `id` <> 4440 ORDER BY istop=1 DESC, id DESC LIMIT 3 [ RunTime:0.000639s ]
SHOW FULL COLUMNS FROM `hc_country` [ RunTime:0.000666s ]
SELECT * FROM `hc_country` WHERE `name` = '新加坡' AND `ishow` = 1 AND `state` = 1 AND `is_delete` = 0 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000420s ]
SELECT country, COUNT(*) AS n FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 ) AND `country` <> '' GROUP BY `country` ORDER BY `n` DESC LIMIT 12 [ RunTime:0.001486s ]
SHOW FULL COLUMNS FROM `www_setup` [ RunTime:0.001062s ]
SELECT `value`,`alias` FROM `www_setup` WHERE `is_delete` = 0 [ RunTime:0.001238s ]