SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508985 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508985 [ RunTime:0.002296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247191,367007,709411,634995,133689,117931,455555,630384,806691,438131,451445,180245,49867,383871,689667,944333,353735,924121,653510,935461,99726,43464,274738,84519,740141,271312,416911,834952,923236,404345,187727,198237,269249,968236,741518,158760,717218,569593,609176,159892,57494,572288,1031229,358781,808420,504451,217876,285866,995916,759457,785147,107864,770570,208956,994230,1013727,346654,218833,619916,797735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]