SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002729s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280117 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280117 [ RunTime:0.004454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140848,48862,996414,921175,274616,191837,27782,470123,622981,344058,960937,55795,599893,99243,873124,134383,491888,231915,562975,800606,563648,371444,21010,40188,145541,439005,381579,405054,296269,754896,159352,996933,552404,909549,232824,86614,297670,167359,555612,805324,133006,343862,198794,712103,604046,589708,573357,819950,250443,811499,41547,710422,266598,837997,430398,750047,22065,144325,889456,529940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]