SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642843 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642843 [ RunTime:0.002415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972305,750079,146650,493343,692961,144279,422855,153392,52300,121993,651828,584950,431836,180559,721616,94660,919388,196348,168389,808714,703715,892129,907558,479702,845099,730792,1038419,602441,38428,925325,975136,557036,427347,40744,690526,376351,250978,196893,672984,782886,237175,763944,1015016,1015182,1029716,709056,1003399,392571,199529,1036372,960797,312407,144106,442621,758317,281876,378283,220499,220083,989051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]