SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547252 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547252 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581768,609931,820446,281103,979361,278669,16212,868141,936611,960321,645815,157009,309504,915739,960439,430265,724612,600083,734211,768085,1000153,71420,474588,454936,105655,288913,177749,399304,1020415,307162,786476,741586,896480,408248,186183,966280,397915,48555,972271,884550,760658,630516,745418,60173,223338,974092,596560,896987,319631,652188,847298,478801,1022546,453232,1032553,503965,616168,857554,967796,48761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]