SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195448 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195448 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876449,915243,232915,378501,853112,50532,792702,63317,850945,43437,858198,1043008,886292,273056,544548,705230,224744,610137,111303,754469,708793,433970,210484,656863,946793,898126,953934,197942,556853,890806,306301,455703,454207,912067,680129,488140,148948,905284,214582,630311,1007770,858468,391968,744663,581279,71542,922460,459344,464628,753715,673893,582549,909365,341134,88603,342733,38941,470951,411852,184207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]