SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535975 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535975 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187856,224514,369487,166150,728578,417402,520592,471105,16015,314550,888679,275779,991982,241625,96278,104200,126936,145902,47605,973554,350416,812345,795522,659622,722339,568739,532674,353449,393573,24912,796129,591074,739835,811059,911611,489379,976839,999394,203091,625665,930061,990742,189593,588471,978084,399243,782005,458951,229526,925907,451336,603081,440138,688292,102307,819080,1002221,69853,977239,21078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]