SHOW FULL COLUMNS FROM `hc_job` [ RunTime:0.000682s ]
UPDATE `hc_job` SET `hits` = `hits` + 1 WHERE `id` = 4503 [ RunTime:0.004888s ]
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` = 4503 LIMIT 1 [ RunTime:0.000298s ]
SELECT `id`,`name`,`country`,`people`,`money` FROM `hc_job` WHERE ( `ishow` = 1 AND `audit` = 1 AND `is_delete` = 0 ) AND `country` = '伊拉克' AND `id` <> 4503 ORDER BY istop=1 DESC, id DESC LIMIT 3 [ RunTime:0.000760s ]
SHOW FULL COLUMNS FROM `hc_country` [ RunTime:0.000606s ]
SELECT * FROM `hc_country` WHERE `name` = '伊拉克' AND `ishow` = 1 AND `state` = 1 AND `is_delete` = 0 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000457s ]
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.001040s ]
SHOW FULL COLUMNS FROM `www_setup` [ RunTime:0.000420s ]
SELECT `value`,`alias` FROM `www_setup` WHERE `is_delete` = 0 [ RunTime:0.000291s ]