concrete5 MySQL pain

EXPLAIN SELECT p1.cID, pt.ctHandle FROM Pages p1
 LEFT JOIN Pages p2 ON (p1.cPointerID = p2.cID)
 LEFT JOIN PageTypes pt ON (pt.ctID = (if (p2.cID is null, p1.ctID, p2.ctID)))
 LEFT JOIN PagePaths ON (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1)
 LEFT JOIN PageSearchIndex psi ON (psi.cID = if(p2.cID is null, p1.cID, p2.cID))
 INNER JOIN CollectionVersions cv ON (cv.cID = if(p2.cID is null, p1.cID, p2.cID) AND cvID =
  (SELECT MAX(cvID) FROM CollectionVersions
   WHERE cID = cv.cID)) INNER JOIN Collections c ON (c.cID = if(p2.cID is null, p1.cID, p2.cID))
    LEFT JOIN CollectionSearchIndexAttributes ON (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID))
    WHERE 1=1 AND p1.cParentID = '0' AND
     (p1.cIsTemplate = 0 OR p2.cIsTemplate = 0) AND
     (p1.cID NOT IN (5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55,65,66,67,68,69) OR
      p2.cID NOT IN (5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55,65,66,67,68,69))