SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484502 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484502 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529452,307158,263094,390212,857403,846863,550450,257643,667654,3242,275634,763393,286148,163617,164492,188361,330890,453531,822607,332720,909045,411355,772934,734664,777429,562845,786953,275772,590824,1007979,400961,944853,374574,933514,740988,872350,872693,981835,740454,766570,992172,640218,84875,1015594,82968,610251,716849,313818,61201,885818,758480,73320,895267,489988,463771,994700,209546,850576,287970,429400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]