SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466610 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466610 [ RunTime:0.004200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894234,466548,849678,903474,753095,615312,581475,978209,650496,180322,406596,933414,206990,328079,247626,606571,455809,867206,796181,657935,442352,1039557,906731,774488,140131,483518,259764,514372,719900,346987,543445,3277,300527,487188,268263,498764,598065,847595,171461,372472,157298,195787,733697,1022878,171889,162911,832495,663845,282268,515416,175997,972041,533378,445219,549981,760935,126104,414076,1035386,630343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]