SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460840 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460840 [ RunTime:0.003649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295167,725562,619086,155123,1024158,140109,805107,365411,1007567,763479,346376,355057,158072,447704,466174,455647,921500,102065,349273,47792,820777,381627,32472,131251,53845,998989,1020321,100645,428218,575230,755642,853482,467008,649024,692382,462377,346816,127507,485042,250568,162551,438020,540151,431846,447252,981048,619795,44631,944674,33344,816595,434546,1008915,676041,503363,586276,397727,618756,757190,939904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]