SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105231 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105231 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323864,345683,127304,937805,765172,361987,962818,746731,796926,918858,307460,5545,984085,342505,486560,535960,816547,968975,481550,885156,869945,802752,347732,750662,896798,370433,834320,853920,981128,921724,859137,317990,85174,814825,789821,257048,1016546,742415,601134,875848,880158,1028803,1003931,915119,1025517,290475,446669,841347,1036276,376373,692272,21664,767912,392285,918105,863914,768502,656770,604257,290346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]