SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513381 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513381 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327039,85569,25384,389880,399166,414555,179219,988482,786205,958462,931397,222587,918994,1017686,1024901,36747,858098,250246,994619,14099,707673,536559,925371,494779,106470,150069,497921,226128,841983,759453,388450,429520,15594,871552,425413,186617,630659,988183,505163,980089,716342,577582,512679,697450,836789,385146,163880,977969,432672,375354,659703,523698,695608,965836,336619,4066,385257,212726,266947,448862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]