SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012890 LIMIT 1 [ RunTime:0.001137s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012890 [ RunTime:0.002425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683472,609267,114127,555479,697056,1003035,783427,673996,645514,672077,760660,748327,662601,657970,72455,127008,512156,255009,559675,659376,741451,860375,955498,787583,57972,517700,204538,289120,416757,556740,422735,624943,431285,453231,184458,284658,468320,565424,917143,438723,139669,875536,673378,553456,291031,330910,171785,647885,428908,380099,34643,430786,725727,36209,106982,626187,483112,961154,753560,956719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]