SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002774s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488842 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488842 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431300,435901,344566,1043148,795692,92085,714503,792595,142707,863782,110909,810709,95837,829810,628707,500476,1019676,188247,711281,358037,35126,982991,1003681,256489,941046,940981,891553,468067,529345,332036,564472,32870,338682,414267,640605,258725,186911,853412,295738,318593,823005,240570,993420,632198,71120,217834,347635,715105,145431,866254,425566,995560,397909,742429,640749,173568,470682,552206,982229,107883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002397s ]