SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59708 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59708 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6389,687480,686888,119046,36868,765371,522320,756843,194783,890636,354991,773299,230349,1034713,187345,737609,985562,460005,861040,184674,215453,244512,318772,458458,344452,561517,334246,211031,991948,952519,477700,592149,896660,560689,455680,11920,1008003,154892,544434,548604,590957,294055,975731,1016342,204028,649079,821673,524297,921625,58207,345570,724510,955524,808060,472763,454365,908783,437503,367879,649623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]