SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 352581 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 352581 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95063,528002,1005022,643598,901809,5266,477142,830741,919758,818529,867102,215312,682866,558701,362902,419701,431060,393021,769806,146267,1005160,735419,159790,498530,755244,516039,633930,1024095,441400,524660,120140,470644,508143,553893,58300,126974,660028,834050,362295,516134,213434,116016,188095,912823,898591,371465,836784,634764,266244,626510,32924,833195,710294,253918,533139,640468,460131,869388,951644,416985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 352581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 352581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]