SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320097 LIMIT 1 [ RunTime:0.001886s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320097 [ RunTime:0.002444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706138,1013041,695773,503146,284966,581648,1004689,129080,905646,982074,934370,687415,154434,699459,527738,543656,801847,657194,549284,455596,19343,194272,238866,870982,967564,177808,939695,824472,165857,15060,616019,872545,654745,688986,882895,762590,641414,4231,519963,699487,787126,591335,669366,596043,814830,613715,679026,621334,846883,776717,526256,1000842,277662,1018532,72250,763462,578153,151334,396667,72282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]