SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675251 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675251 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416285,833504,472672,578972,381588,950157,808360,576249,304442,416515,133969,288886,791112,704819,973375,81601,341056,952257,490894,870147,590274,767160,51309,932045,120177,152954,47015,384209,346740,592131,30713,1034108,905264,88330,268340,568893,351542,741018,663803,390358,867858,878104,963557,617349,951655,160523,972717,752873,596792,655324,875104,214532,763093,338994,30831,747007,593925,666988,815741,177269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]