SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409043 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409043 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250850,382331,1039959,923852,212041,1029015,976040,748873,887568,156986,716323,279831,613306,937910,653931,410364,894345,927133,401019,456255,547790,344626,777831,617052,662669,728472,563008,475299,86212,100555,423427,670080,357505,785990,553265,328231,59966,227388,196546,113079,880661,3831,926879,469745,670438,343529,678644,236185,266485,596285,986262,729806,1043145,302431,261197,910699,434029,292683,353246,1015693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]