Comment 0 for bug 746866

OOPS-1916L440

https://code.launchpad.net/%7Embp/+branches

User: Martin Pool
Branch: launchpad-rev-12696
Revno: 12696
SQL time: 10073 ms
Non-sql time: 1666 ms
Total time: 11739 ms
Statement Count: 78

5137ms SQL-launchpad-main-master
SELECT DISTINCT BugBranch.branch
FROM Bug,
     BugBranch
WHERE BugBranch.branch IN (451217,
                           451208,
                           451207,
                           451206,
                           310641,
                           450226,
                           449792,
                           449762,
                           449192,
                           449190,
                           444685,
                           439423,
                           436128,
                           421710,
                           317004,
                           374978,
                           404904,
                           412011,
                           411115,
                           245099,
                           400223,
                           377965,
                           373979,
                           372939,
                           372691,
                           362490,
                           362566,
                           362564,
                           361252,
                           359795,
                           359423,
                           357633,
                           355943,
                           348553,
                           322307,
                           319438,
                           316198,
                           316197,
                           315929,
                           310090,
                           308190,
                           305716,
                           305524,
                           296541,
                           294443,
                           245102,
                           275463,
                           273980,
                           40682,
                           34254,
                           175815,
                           152799,
                           115607,
                           81913,
                           81670,
                           62623,
                           52209,
                           42949,
                           39318,
                           38448,
                           37654,
                           12332,
                           30797,
                           21766,
                           13518,
                           16918,
                           12486,
                           10605,
                           10457,
                           5670,
                           9447,
                           7882,
                           4233,
                           3674,
                           2510,
                           2469)
  AND Bug.id = BugBranch.bug
  AND (Bug.private = FALSE
       OR Bug.id IN
         (SELECT BugSubscription.bug
          FROM BugSubscription,
               TeamParticipation
          WHERE TeamParticipation.team = BugSubscription.person
            AND TeamParticipation.person = 67034))