SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483140 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483140 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463809,480610,599645,1005568,390318,322776,183879,882653,759143,795820,883166,826535,171780,79968,622660,23789,189451,153065,57205,390983,815438,325760,436286,191464,423334,826315,600923,330633,580893,933276,356844,706883,482231,553899,581471,244989,588125,256050,86807,878660,520396,18338,202649,698981,471780,105145,684662,14128,542097,362997,467941,97883,951244,410643,223856,487079,882144,22233,870417,16683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001548s ]