SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023334 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023334 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254707,983899,947315,874862,129810,377831,677026,378140,151885,556367,196657,644393,915409,613170,800576,166602,860849,700464,942785,353191,439773,452492,1040288,549021,644364,793162,359477,745498,1034641,266852,1032283,124867,574670,446981,825911,216745,1030410,731997,414068,304394,367284,110157,736043,323719,570219,471057,927017,930176,479261,23327,86382,640958,11415,193617,3968,655250,1016188,626554,945694,510462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]