SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80283 LIMIT 1 [ RunTime:0.010261s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80283 [ RunTime:0.004258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51209,1041123,325384,494502,941626,692495,377418,38867,337181,935383,200007,988238,393124,526336,485285,113840,779251,790843,431460,414375,105156,651191,719469,1043144,1021489,792724,992702,369519,228358,650136,796868,390703,1037337,547387,158952,682659,722070,440205,994823,397155,124149,614241,106296,18779,263776,748505,543428,593296,1020713,194795,234741,25641,875247,677836,876151,147625,804502,162576,981471,482363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]