SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483101 LIMIT 1 [ RunTime:0.001210s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483101 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980324,882010,860602,325415,357540,1036621,1008938,825783,841491,938937,530772,583596,247455,902703,879189,972097,1001850,840081,959559,803681,961026,87095,560975,628242,461104,959125,233800,867095,339315,255443,984584,1025564,651218,1006261,216661,908327,88404,169206,244840,646776,551836,74346,178071,835930,690053,866302,277164,114235,815385,598773,923171,637177,280326,833120,285126,59843,151895,568104,522413,208970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]