SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480701 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480701 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032342,365389,99508,152026,957563,291768,12183,50188,951026,556019,165210,518109,684411,826905,631050,732162,489273,446396,332444,304480,245363,540628,945688,716717,623416,230895,1032014,796746,254416,499384,389784,97047,35786,605129,704096,200060,149038,484701,1047489,1046134,746719,837484,784447,144544,1031244,42039,152049,123508,16799,596321,200499,153963,888735,881703,318918,1027598,597109,108263,126800,501659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]