SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481999 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481999 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798506,777484,820689,996170,117525,896847,939187,250768,868262,744987,846723,949566,16357,285608,855939,216947,301947,228597,842173,66967,686125,406373,187165,689019,296444,726204,34586,602361,416070,222117,991980,976051,791093,448343,253423,134869,401484,660111,988677,343324,507108,271187,225411,803553,469995,74837,1006664,556020,525000,840311,726056,45577,500060,585404,471247,17784,1046545,1020327,840859,888359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000991s ]