Added cDisplayOrder to index Pages.cPointerID to avoid filesort
Added cDisplayOrder to index Pages.cPointerID to avoid filesort

Added cPointerID to Index Pages.uID to avoid merge sort filter

Added index Pages.pkgID for potential join to packages table

Added index Pages.cParentMaxDisplay so that they query optimizer can use a full index and only return the first record it finds

Modified all the cIs fields that were being indexed to have the cID BEFORE the cIs(template,Active,SystemPage) because in every case I could find these were being joined to another table when they were being used, which meant it was always using the primary key for the join instead of these indexes.


Former-commit-id: c933c274c58bf27bcf7fc32b063884fc53e9b249
triplei/concrete5-8,deek87/concrete5,jaromirdalecky/concrete5,triplei/concrete5-8,haeflimi/concrete5,rikzuiderlicht/concrete5,MrKarlDilkington/concrete5,MrKarlDilkington/concrete5,concrete5/concrete5,mlocati/concrete5,mlocati/concrete5,jaromirdalecky/concrete5,rikzuiderlicht/concrete5,concrete5/concrete5,hissy/concrete5,deek87/concrete5,mainio/concrete5,triplei/concrete5-8,acliss19xx/concrete5,mainio/concrete5,hissy/concrete5,mlocati/concrete5,deek87/concrete5,biplobice/concrete5,rikzuiderlicht/concrete5,hissy/concrete5,MrKarlDilkington/concrete5,mainio/concrete5,jaromirdalecky/concrete5,deek87/concrete5,a3020/concrete5,a3020/concrete5,haeflimi/concrete5,KorvinSzanto/concrete5,olsgreen/concrete5,acliss19xx/concrete5,olsgreen/concrete5,biplobice/concrete5,biplobice/concrete5,jaromirdalecky/concrete5,haeflimi/concrete5,concrete5/concrete5,mlocati/concrete5,acliss19xx/concrete5,KorvinSzanto/concrete5,biplobice/concrete5,haeflimi/concrete5,concrete5/concrete5,hissy/concrete5,olsgreen/concrete5,KorvinSzanto/concrete5