SHOW FULL COLUMNS FROM `qc_regions` [ RunTime:0.000538s ]
SELECT `id`,`names` FROM `qc_regions` WHERE `id` IN (19,30,23,28,21,20,18,17,16,15,14,13,12,11,10,9,8,7,6) [ RunTime:0.001029s ]
SHOW FULL COLUMNS FROM `qc_abouts` [ RunTime:0.000570s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 1 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.000268s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 2 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.000276s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 3 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `qc_resumes` [ RunTime:0.000870s ]
SELECT COUNT(*) AS think_count FROM `qc_resumes` WHERE ( `istate` = 1 AND `seekstate` < 5 AND `regionid` = 16 AND `workyearname` = '6年以上' AND ( `seekpositioname` LIKE '%煮饭%' OR `nickname` LIKE '%煮饭%' OR `names` LIKE '%煮饭%' ) AND `educatname` = '初中' ) [ RunTime:0.071063s ]
SELECT `id`,`names`,`nickname`,`gender`,`age`,`educatname`,`workyearname`,`seekpositioname`,`seekregioname`,`regionid`,`istop`,`salary_moonstart`,`salary_moonend`,`uptime` FROM `qc_resumes` WHERE ( `istate` = 1 AND `seekstate` < 5 AND `regionid` = 16 AND `workyearname` = '6年以上' AND ( `seekpositioname` LIKE '%煮饭%' OR `nickname` LIKE '%煮饭%' OR `names` LIKE '%煮饭%' ) AND `educatname` = '初中' ) ORDER BY `istop` DESC,`uptime` DESC LIMIT 0,20 [ RunTime:0.111969s ]
SELECT `id`,`names` FROM `qc_regions` WHERE `id` IN (19,30,23,28,21,20,18,17,16,15,14,13,12,11,10,9,8,7,6) [ RunTime:0.000315s ]
SELECT `id`,`names`,`nickname`,`gender`,`age`,`workyearname`,`seekpositioname` FROM `qc_resumes` WHERE `istate` = 1 AND `seekstate` < 5 ORDER BY `uptime` DESC LIMIT 8 [ RunTime:0.084747s ]