SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196903 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196903 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231828,599649,388667,965948,411874,173043,689546,268770,882038,889156,428672,386960,681583,33075,184036,154788,644278,381070,966010,155069,536713,980738,563460,269908,334465,802415,895472,598932,655067,150084,552073,826565,678744,718391,309792,496293,440392,4531,1021209,563972,599873,407899,165100,847614,148898,82405,412025,697583,505736,36334,616871,258826,1016715,305974,484289,960463,329853,966040,1048708,106808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]