SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319841 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319841 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10090,541069,315613,241257,780171,367292,395087,416428,221275,365433,685371,47893,404460,728249,954598,197555,191569,108782,513479,604631,349063,58559,928634,246400,238217,114155,760016,832465,427551,360579,315771,672547,901887,128182,333113,578731,644556,685989,997476,560548,957120,948294,453861,355595,641276,225846,776191,102763,342034,1015433,900412,5980,94320,458351,744121,839036,514574,692561,819813,922688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]