SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428056 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428056 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824906,896038,174006,208115,385798,1005038,640393,475544,614994,288737,501241,477375,286116,851484,112561,806095,2423,921835,42242,31786,238754,223056,213523,343615,473129,133920,526289,1029237,584419,992388,883496,330516,181648,386081,908908,575848,743558,113825,942664,1017322,745240,680653,348840,362925,978677,6702,306011,1009952,729673,159801,439868,260874,584471,810279,328268,369607,917081,819200,379805,4604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]