SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328513 LIMIT 1 [ RunTime:0.002047s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328513 [ RunTime:0.004399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457440,301506,821210,226346,910052,601732,806849,362522,763965,738486,172339,40046,124762,100715,330067,985304,463550,109973,443664,693545,109173,579429,166003,375236,501859,267568,391218,308857,950546,920884,458943,165541,525245,819258,1026984,952924,434899,318119,350506,714739,916996,99509,895888,753074,220830,958152,857656,619902,309378,223661,776474,715812,142638,630178,785941,43207,30746,873387,420128,418246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001420s ]