SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548082 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548082 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874122,938468,203158,920052,865258,42135,1040976,901332,1028669,105615,984446,419405,418778,134774,876599,842892,732462,693095,573550,131022,283507,296605,488135,672461,661409,307296,718969,520850,632180,894085,736010,633075,985440,813648,258566,816971,728400,274318,936759,525691,936167,764707,996257,1000395,113532,967658,965959,224414,526730,451084,23354,739672,276422,77247,945377,799162,475690,123209,411037,448993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]