SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41151 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41151 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481228,67113,504978,89363,884362,15757,111055,381476,310924,725176,435828,552737,43494,409733,301812,873217,561776,601823,549724,590314,60161,107037,792865,339148,210981,434107,896098,477785,171894,37162,1037028,791787,892128,224985,655206,921454,574746,692491,226070,379654,452850,983111,226745,623853,295830,1039628,592161,62928,882517,38318,621423,66047,477333,460936,1030979,557425,35765,967831,247305,440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]