SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581198 LIMIT 1 [ RunTime:0.001186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581198 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905373,250846,838793,604548,1014006,121377,796858,103456,384884,909613,682092,13357,632486,182764,280174,798675,422929,797795,855983,268601,983325,809093,196681,335664,883160,303890,620847,285903,790469,118305,826765,733928,594054,541293,871264,920120,809166,815835,112957,532760,863478,409995,260079,241473,664599,18729,551296,972567,498407,757728,919718,129771,583079,549822,103968,680910,277689,889515,513405,145051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]