SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686293 LIMIT 1 [ RunTime:0.000727s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686293 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926688,1882,732950,267661,952020,653004,491883,157262,981356,73903,2302,179571,896139,346944,261893,136153,606170,1038051,29291,35651,582051,711880,140220,683365,480069,361188,89941,470700,76055,87711,14398,825728,243277,1026616,809013,975902,396438,638320,949335,92070,658078,1020396,809476,602227,479770,227944,323906,148793,508832,963167,909163,782553,325813,301478,370198,313280,610842,466525,590491,772420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004454s ]