SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508915 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508915 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459342,876226,575966,971265,644649,347190,110381,884694,375435,381281,1010470,572128,370946,972199,104881,834743,805723,822002,778516,849403,323190,551693,3046,65561,228018,774846,78648,524185,153325,630656,38498,137065,383476,282561,241528,734790,804963,216809,288638,139019,402803,217011,454324,127361,84649,727521,113133,601198,924428,431835,715123,7950,404295,886314,208620,157291,654212,383367,227199,471201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]