SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482029 LIMIT 1 [ RunTime:0.001411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482029 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686263,1018102,339962,115072,873205,27459,199866,167892,179006,495297,169031,217753,208978,633388,219108,813777,108505,563744,1025417,184187,711075,978492,778633,865529,406737,775018,120923,608481,502686,898907,546934,1032270,552218,11177,960162,103945,322942,414603,755593,771335,837533,679928,639468,395488,944043,744652,99228,39053,860132,960905,560298,969626,20185,935758,75850,1026691,324054,837642,1018209,339048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]