SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418830 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418830 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843228,983684,23744,404386,87074,384065,177902,190723,93601,949380,1023837,770119,892888,663270,103891,126233,441970,894676,793386,332690,412721,167566,72752,69988,587458,410527,920864,148428,376377,100064,976389,973977,205890,904241,855951,721816,607916,606794,474458,1009833,73998,789631,286215,610072,341915,124945,962699,274273,438141,13949,250283,387822,298171,321813,825814,251728,1008068,207050,728942,101495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]