SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 902019 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 902019 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339060,539843,597068,480145,891222,270611,525273,970310,521893,612251,858340,716698,267033,380804,991652,540611,690832,568501,46706,41998,705030,822370,265420,254243,847168,552088,982003,478877,547191,122743,930065,229720,680287,48251,171149,929550,808736,159130,47853,773506,234559,174015,831381,21354,103302,280626,415214,812185,25355,286652,586784,582453,156960,918853,530240,739948,523560,251742,1038422,907741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 902019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 902019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]