SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311978 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311978 [ RunTime:0.002834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908518,202386,611699,146961,707999,576494,875365,831009,654147,140636,1020144,901623,711593,374121,463328,458058,56335,878681,173285,469130,797482,213401,608628,201851,909693,833070,200479,67034,732378,843310,734477,332037,582103,943537,856898,796126,238285,907231,83705,178163,154895,806319,305948,475692,303823,337936,56412,401478,935738,507084,61360,933152,709012,641884,241059,237543,84875,706383,630384,963054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]