SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482584 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482584 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937743,98823,57305,63351,975544,121301,944202,318261,586441,821843,125787,196182,208077,877172,321940,259300,746164,789875,341050,16315,488240,412563,611136,34996,20642,156002,78656,15608,33116,350029,615840,66167,89357,980118,15867,422087,701591,988384,922087,109848,181798,1018395,149651,139562,101586,726101,516366,968583,496213,972737,442751,971202,334481,328163,444057,163636,380449,260866,597091,288400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]