SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205202 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205202 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115238,800333,462151,728319,491887,940969,214720,651585,6677,844263,859225,271063,314227,757595,27564,991706,112384,471598,772408,668852,392033,908582,1032555,222163,552850,909320,1016895,375701,9980,411088,552576,737471,818295,1039367,847603,454360,382137,916012,822534,290790,725966,134063,324909,773816,937437,238605,698213,833150,1019050,545063,562412,459138,396585,482859,1026443,256804,698595,621735,515445,211313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]