SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335316 LIMIT 1 [ RunTime:0.002381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335316 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584933,27018,655320,742058,857127,505225,560484,296611,760450,836057,8943,169616,198285,64543,872885,123181,203704,846900,159383,285727,674801,575112,140949,589245,560482,97145,936863,339569,590049,963125,93961,264811,289769,962252,274949,1044471,166773,12646,509542,556957,824623,790311,106929,376747,261585,893093,294325,548820,434785,459923,804078,21083,436122,144672,845916,420094,250443,339491,815497,91793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001802s ]