SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266084 LIMIT 1 [ RunTime:0.002519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266084 [ RunTime:0.002280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984375,1030678,932269,648599,40503,876148,249025,736185,252332,1040641,297642,477078,419229,428820,598945,447252,285370,698231,165579,27149,89714,876058,545995,35332,909074,884496,340743,182921,744160,264204,477193,623369,941165,240444,94620,991486,465759,619073,54359,214482,215701,485123,614583,14274,585834,662691,923717,120409,86141,617987,842441,320177,509341,806399,661312,205692,513937,500909,632560,312038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]