SHOW FULL COLUMNS FROM `qc_regions` [ RunTime:0.000460s ]
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.000371s ]
SHOW FULL COLUMNS FROM `qc_abouts` [ RunTime:0.000971s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 1 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.000295s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 2 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.004463s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 3 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `qc_joblist` [ RunTime:0.002712s ]
SELECT COUNT(*) AS think_count FROM `qc_joblist` WHERE ( `istate` = 3 AND ( `names` LIKE '%开单员%' OR `ltdname` LIKE '%开单员%' ) AND `salarystart` >= 2000 ) [ RunTime:0.047428s ]
SELECT `id`,`names`,`ltdid`,`ltdname`,`address`,`district`,`city`,`street`,`salarystart`,`salaryend`,`salaryunit`,`uptime`,`educatname`,`workyearname`,`benefitname`,`peoplenum`,`peopleunit`,`istop`,`topendtime` FROM `qc_joblist` WHERE ( `istate` = 3 AND ( `names` LIKE '%开单员%' OR `ltdname` LIKE '%开单员%' ) AND `salarystart` >= 2000 ) ORDER BY `istop` DESC,`isurgent` DESC,`uptime` DESC LIMIT 0,15 [ RunTime:0.048068s ]
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.000437s ]
SELECT `id`,`names`,`ltdname`,`salarystart`,`salaryend`,`salaryunit` FROM `qc_joblist` WHERE `istate` = 3 ORDER BY `uptime` DESC LIMIT 10 [ RunTime:0.000578s ]