SHOW FULL COLUMNS FROM `hc_job` [ RunTime:0.000645s ]
UPDATE `hc_job` SET `hits` = `hits` + 1 WHERE `id` = 4272 [ RunTime:0.003940s ]
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` = 4272 LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`name`,`country`,`people`,`money` FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 ) AND `country` = '泰国' AND `id` <> 4272 ORDER BY istop=1 DESC, id DESC LIMIT 3 [ RunTime:0.000618s ]
SHOW FULL COLUMNS FROM `hc_country` [ RunTime:0.000472s ]
SELECT * FROM `hc_country` WHERE `name` = '泰国' AND `ishow` = 1 AND `state` = 1 AND `is_delete` = 0 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000379s ]
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.000770s ]
SHOW FULL COLUMNS FROM `www_setup` [ RunTime:0.000425s ]
SELECT `value`,`alias` FROM `www_setup` WHERE `is_delete` = 0 [ RunTime:0.000255s ]