SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535390 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535390 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763593,528148,369829,592468,615052,923969,84687,536962,844899,442811,160529,429020,52850,491149,362730,747882,602361,428505,644606,698390,446616,266316,564141,230535,451895,140331,605975,991818,267829,677411,686528,760664,162160,870576,904947,477758,138208,135078,787921,446251,920754,838964,351944,635725,926223,576203,1012474,1039558,649628,750668,1022293,672446,279049,292611,993927,899694,290160,288949,504945,416095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]