SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425116 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425116 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692080,109398,531294,862233,170907,400018,744490,1016583,179575,1013297,697568,345795,116230,280689,631959,1004158,560071,347994,96795,571740,763006,801800,774689,769065,410999,1042825,764617,442898,776931,444400,396649,509575,674013,215827,659667,218178,906563,217649,195688,914128,318734,969599,560001,589495,613101,412465,238403,541049,1027388,328331,222676,767764,788876,460757,586181,235113,562868,308315,319765,360856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001360s ]