SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577893 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577893 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233838,204564,150291,690147,852441,858683,40110,998275,878008,749849,418588,637553,422835,143072,791042,28681,611386,226616,923519,850334,531948,79800,465736,33112,263036,320843,495395,625783,473604,989437,823416,2192,236408,63155,1015307,258158,1044368,70901,562314,585552,702058,954382,916835,216371,152648,313535,727292,255658,997139,612133,851139,51774,816184,691794,577399,977795,115915,761442,685221,380689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]