SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148811 LIMIT 1 [ RunTime:0.001044s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148811 [ RunTime:0.002988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957194,219404,815954,170167,787272,296115,78448,355915,913056,933681,799574,96413,739744,487546,604063,498986,344815,197488,892980,641060,871969,890629,1016685,1006227,850053,356361,981923,438661,144808,240685,102660,557305,4091,598705,352122,556840,852331,283798,844063,243379,226750,294017,799674,1019974,121521,202441,718327,93318,181444,15191,1024508,68008,621661,375770,330681,77979,698383,426447,220709,954678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001882s ]