SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108816 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108816 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791252,345741,604349,815340,180503,672220,119957,538694,881282,879413,531574,33891,60219,918306,685053,600409,533331,841046,741486,818469,991704,1005568,438948,900418,949632,503360,564202,332015,139427,369668,460229,464945,351086,789286,131289,991025,717151,567897,151710,876791,632202,14927,720778,741155,198469,506194,27576,130017,633317,78025,684458,567401,424498,387802,369659,205239,105265,456437,306035,128211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]