SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294699 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294699 [ RunTime:0.001407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100110,23718,153123,201009,334070,180520,795126,911225,459258,382095,719731,835110,540275,468612,676010,1031694,702326,663377,562944,716625,230002,19114,869588,311586,118437,815144,123122,21629,804826,89072,695845,817546,742833,336594,569801,672389,281401,427387,911469,50812,246969,1017079,641815,772088,765729,480439,579296,1010706,474967,411981,411143,575146,621908,599442,243458,571811,976500,637001,152952,652147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]