Temporary hack until notice_profile_id_idx is updated to (profile_id, id) instead of (profile_id, created, id). It's been falling back to PRIMARY instead, which is really very inefficient for a profile that hasn't posted in a few months. Even though forcing the index will cause a filesort, it's usually going to be better. Even for large profiles it seems much faster than the badly-indexed query.
Temporary hack until notice_profile_id_idx is updated
to (profile_id, id) instead of (profile_id, created, id).
It's been falling back to PRIMARY instead, which is really
very inefficient for a profile that hasn't posted in a few
months. Even though forcing the index will cause a filesort,
it's usually going to be better. Even for large profiles it
seems much faster than the badly-indexed query.

eXcomm/gnu-social,zh/statusnet,xebia/statusnet-oauth2,sikevux/bsk-social,bankonme/gnu-social,furtherfield/gnu-social,znarf/statusnet-ladistribution,Piratas/tortuga,zh/statusnet,chimo/social,Piratas/tortuga,eXcomm/gnu-social,sikevux/bsk-social,xebia/statusnet-oauth2,eXcomm/gnu-social,zh/statusnet,studio666/gnu-social,charlycoste/StatusNet,UngPirat/freesocial,gnusocial/mainline,sikevux/bsk-social,shashi/StatusNet,brion/StatusNet,d3vgru/StatusNet,shashi/StatusNet,charnimda/lgbtpzn-social,zcopley/StatusNet,faulteh/gnu-social,zcopley/StatusNet,bankonme/gnu-social,minmb/statusnet,charlycoste/StatusNet,gnusocial/mainline,gnusocial/mainline,csarven/statusnet,minmb/statusnet,znarf/statusnet-ladistribution,csarven/statusnet,faulteh/gnu-social,zcopley/StatusNet,xebia/statusnet-oauth2,foocorp/gnu-social,d3vgru/StatusNet,charnimda/lgbtpzn-social,UngPirat/freesocial,zcopley/zcopleys-statusnet-clone,csarven/statusnet,chimo/social,zcopley/zcopleys-statusnet-clone,faulteh/gnu-social,znarf/statusnet-ladistribution,bankonme/gnu-social,Piratas/tortuga,Piratas/tortuga,studio666/gnu-social,UngPirat/freesocial,studio666/gnu-social,eXcomm/gnu-social,faulteh/gnu-social,csarven/statusnet,brion/StatusNet,d3vgru/StatusNet,charlycoste/StatusNet,foocorp/gnu-social,brion/StatusNet,shashi/StatusNet,foocorp/gnu-social,gnusocial/mainline,sikevux/bsk-social,zcopley/zcopleys-statusnet-clone,chimo/social,furtherfield/gnu-social,bankonme/gnu-social,studio666/gnu-social,minmb/statusnet,furtherfield/gnu-social,charnimda/lgbtpzn-social,furtherfield/gnu-social