# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 84.657053 Lock_time: 10.948963 Rows_sent: 2 Rows_examined: 47415 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687329 AND a.mptt_left BETWEEN 1 AND 6 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.728222 Lock_time: 10.021006 Rows_sent: 3 Rows_examined: 47398 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 684238 AND a.mptt_left BETWEEN 1 AND 8 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.753718 Lock_time: 10.045860 Rows_sent: 2 Rows_examined: 47396 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 679688 AND a.mptt_left BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 127.140832 Lock_time: 53.433754 Rows_sent: 3 Rows_examined: 47401 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 686873 AND a.mptt_left BETWEEN 1 AND 8 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.769109 Lock_time: 10.059694 Rows_sent: 1 Rows_examined: 47384 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687233 AND a.mptt_left BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 81.653933 Lock_time: 7.945210 Rows_sent: 3 Rows_examined: 47417 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 673761 AND a.mptt_left BETWEEN 1 AND 8 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.863051 Lock_time: 10.152647 Rows_sent: 5 Rows_examined: 47441 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 415885 AND a.mptt_left BETWEEN 1 AND 12 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.758822 Lock_time: 10.049066 Rows_sent: 3 Rows_examined: 47434 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 672933 AND a.mptt_left BETWEEN 1 AND 8 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.752769 Lock_time: 10.043086 Rows_sent: 2 Rows_examined: 47387 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 676194 AND a.mptt_left BETWEEN 1 AND 6 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.742959 Lock_time: 10.033943 Rows_sent: 1 Rows_examined: 47388 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 674416 AND a.mptt_left BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.822980 Lock_time: 10.111709 Rows_sent: 5 Rows_examined: 47437 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 627946 AND a.mptt_left BETWEEN 1 AND 12 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.928872 Lock_time: 10.215044 Rows_sent: 6 Rows_examined: 47476 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 421923 AND a.mptt_left BETWEEN 1 AND 14 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.751601 Lock_time: 10.038792 Rows_sent: 3 Rows_examined: 47434 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 672933 AND a.mptt_left BETWEEN 1 AND 8 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.797589 Lock_time: 10.082620 Rows_sent: 3 Rows_examined: 47427 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687291 AND a.mptt_left BETWEEN 1 AND 8 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 130.401273 Lock_time: 56.684031 Rows_sent: 5 Rows_examined: 47445 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 104055 AND a.mptt_left BETWEEN 1 AND 12 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.785951 Lock_time: 10.070407 Rows_sent: 3 Rows_examined: 47434 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 672933 AND a.mptt_left BETWEEN 1 AND 8 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 84.084903 Lock_time: 10.368280 Rows_sent: 4 Rows_examined: 47409 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 642601 AND a.mptt_left BETWEEN 1 AND 10 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.757652 Lock_time: 10.040226 Rows_sent: 1 Rows_examined: 47382 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 677044 AND a.mptt_left BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.726013 Lock_time: 10.008721 Rows_sent: 6 Rows_examined: 47461 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 683350 AND a.mptt_left BETWEEN 1 AND 14 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 84.099554 Lock_time: 10.375752 Rows_sent: 2 Rows_examined: 47391 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 645392 AND a.mptt_left BETWEEN 1 AND 6 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 84.155354 Lock_time: 10.431377 Rows_sent: 9 Rows_examined: 47426 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 401869 AND a.mptt_left BETWEEN 1 AND 20 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.778235 Lock_time: 10.054797 Rows_sent: 5 Rows_examined: 47439 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687183 AND a.mptt_left BETWEEN 1 AND 12 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.775194 Lock_time: 10.050523 Rows_sent: 11 Rows_examined: 47536 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687226 AND a.mptt_left BETWEEN 1 AND 24 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.883131 Lock_time: 10.157410 Rows_sent: 16 Rows_examined: 47487 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 102379 AND a.mptt_left BETWEEN 1 AND 34 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 132.626439 Lock_time: 58.899154 Rows_sent: 4 Rows_examined: 47420 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 139752 AND a.mptt_left BETWEEN 1 AND 10 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 84.100424 Lock_time: 10.372114 Rows_sent: 4 Rows_examined: 47407 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 142210 AND a.mptt_left BETWEEN 1 AND 10 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.884038 Lock_time: 10.155929 Rows_sent: 2 Rows_examined: 47410 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 673446 AND a.mptt_left BETWEEN 1 AND 6 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.727072 Lock_time: 9.997490 Rows_sent: 8 Rows_examined: 47529 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 676962 AND a.mptt_left BETWEEN 1 AND 18 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.787296 Lock_time: 10.056923 Rows_sent: 9 Rows_examined: 47496 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 612778 AND a.mptt_left BETWEEN 1 AND 20 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.845463 Lock_time: 10.114298 Rows_sent: 2 Rows_examined: 47415 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687329 AND a.mptt_left BETWEEN 1 AND 6 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.766200 Lock_time: 10.034877 Rows_sent: 7 Rows_examined: 47483 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687137 AND a.mptt_left BETWEEN 1 AND 14 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.823684 Lock_time: 10.090532 Rows_sent: 18 Rows_examined: 47595 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 650705 AND a.mptt_left BETWEEN 1 AND 38 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.785799 Lock_time: 10.053153 Rows_sent: 1 Rows_examined: 47382 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687108 AND a.mptt_left BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.935752 Lock_time: 10.202299 Rows_sent: 11 Rows_examined: 47536 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687226 AND a.mptt_left BETWEEN 1 AND 24 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.753350 Lock_time: 10.019945 Rows_sent: 7 Rows_examined: 47483 SET timestamp=1339526363; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687137 AND a.mptt_left BETWEEN 1 AND 14 ORDER BY a.date_recorded ASC; # Time: 120612 13:39:24 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 84.170385 Lock_time: 10.431821 Rows_sent: 16 Rows_examined: 47487 SET timestamp=1339526364; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 102379 AND a.mptt_left BETWEEN 1 AND 34 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 132.620011 Lock_time: 58.876629 Rows_sent: 4 Rows_examined: 47420 SET timestamp=1339526364; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 139752 AND a.mptt_left BETWEEN 1 AND 10 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.785370 Lock_time: 10.043636 Rows_sent: 9 Rows_examined: 47496 SET timestamp=1339526364; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 612778 AND a.mptt_left BETWEEN 1 AND 20 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.881367 Lock_time: 10.122872 Rows_sent: 23 Rows_examined: 47650 SET timestamp=1339526364; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 647699 AND a.mptt_left BETWEEN 1 AND 48 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 70.243407 Lock_time: 0.000188 Rows_sent: 1 Rows_examined: 47397 SET timestamp=1339526364; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 567979 AND a.mptt_left BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 68.884012 Lock_time: 0.000262 Rows_sent: 9 Rows_examined: 47535 SET timestamp=1339526364; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 523855 AND a.mptt_left BETWEEN 1 AND 22 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 64.797578 Lock_time: 0.000235 Rows_sent: 2 Rows_examined: 47394 SET timestamp=1339526364; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 682385 AND a.mptt_left BETWEEN 1 AND 6 ORDER BY a.date_recorded ASC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 64.931975 Lock_time: 0.000181 Rows_sent: 1 Rows_examined: 47382 SET timestamp=1339526364; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value as user_fullname FROM oinkoink_bp_activity a, oinkoink_users u, oinkoink_bp_xprofile_data pd WHERE u.ID = a.user_id AND pd.user_id = a.user_id AND pd.field_id = 1 AND a.type = 'activity_comment' AND a.item_id = 687152 AND a.mptt_left BETWEEN 1 AND 4 ORDER BY a.date_recorded ASC; # Time: 120612 13:39:25 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 70.500337 Lock_time: 0.000327 Rows_sent: 20 Rows_examined: 56461 SET timestamp=1339526365; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM oinkoink_bp_activity a LEFT JOIN oinkoink_users u ON a.user_id = u.ID WHERE a.component IN ( 'groups' ) AND a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.item_id IN ( 550 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 0, 20; # Time: 120612 13:39:26 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 80.840424 Lock_time: 0.000234 Rows_sent: 1 Rows_examined: 32470 SET timestamp=1339526366; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.component IN ( 'groups' ) AND a.type IN ( 'activity_update' ) AND a.item_id IN ( 355 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # Time: 120612 13:39:27 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 80.267061 Lock_time: 2.710301 Rows_sent: 20 Rows_examined: 32510 SET timestamp=1339526367; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM oinkoink_bp_activity a LEFT JOIN oinkoink_users u ON a.user_id = u.ID WHERE a.component IN ( 'groups' ) AND a.type IN ( 'activity_update' ) AND a.item_id IN ( 355 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 0, 20; # Time: 120612 13:39:28 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 141.124176 Lock_time: 0.000097 Rows_sent: 1 Rows_examined: 263361 SET timestamp=1339526368; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 141.217117 Lock_time: 0.000107 Rows_sent: 1 Rows_examined: 263361 SET timestamp=1339526368; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 147.526048 Lock_time: 0.000115 Rows_sent: 1 Rows_examined: 263361 SET timestamp=1339526368; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # Time: 120612 13:39:29 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 142.243672 Lock_time: 0.000107 Rows_sent: 1 Rows_examined: 263361 SET timestamp=1339526369; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 142.678522 Lock_time: 0.000165 Rows_sent: 1 Rows_examined: 263361 SET timestamp=1339526369; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # Time: 120612 13:39:30 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 79.984826 Lock_time: 0.000164 Rows_sent: 1 Rows_examined: 136246 SET timestamp=1339526370; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.component IN ( 'groups' ) AND a.item_id IN ( 2313 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # Time: 120612 13:39:33 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 69.954740 Lock_time: 0.000103 Rows_sent: 1 Rows_examined: 263361 SET timestamp=1339526373; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 70.394600 Lock_time: 0.000082 Rows_sent: 1 Rows_examined: 263361 SET timestamp=1339526373; SELECT count(a.id) FROM oinkoink_bp_activity a WHERE a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC; # Time: 120612 13:39:38 # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 155.584826 Lock_time: 67.459831 Rows_sent: 15 Rows_examined: 542165 SET timestamp=1339526378; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM oinkoink_bp_activity a LEFT JOIN oinkoink_users u ON a.user_id = u.ID WHERE a.component IN ( 'groups' ) AND a.item_id IN ( 2440 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 0, 20; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.731199 Lock_time: 0.000178 Rows_sent: 4 Rows_examined: 542154 SET timestamp=1339526378; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM oinkoink_bp_activity a LEFT JOIN oinkoink_users u ON a.user_id = u.ID WHERE a.component IN ( 'groups' ) AND a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.item_id IN ( 2912 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 0, 20; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 125.135236 Lock_time: 36.954538 Rows_sent: 15 Rows_examined: 542165 SET timestamp=1339526378; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM oinkoink_bp_activity a LEFT JOIN oinkoink_users u ON a.user_id = u.ID WHERE a.component IN ( 'groups' ) AND a.item_id IN ( 2440 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 0, 20; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 142.206793 Lock_time: 53.988699 Rows_sent: 10 Rows_examined: 542180 SET timestamp=1339526378; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM oinkoink_bp_activity a LEFT JOIN oinkoink_users u ON a.user_id = u.ID WHERE a.component IN ( 'groups' ) AND a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.item_id IN ( 1612 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 20, 20; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 83.828226 Lock_time: 0.000179 Rows_sent: 4 Rows_examined: 542154 SET timestamp=1339526378; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM oinkoink_bp_activity a LEFT JOIN oinkoink_users u ON a.user_id = u.ID WHERE a.component IN ( 'groups' ) AND a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.item_id IN ( 2912 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 0, 20; # User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255] # Query_time: 84.041071 Lock_time: 0.000323 Rows_sent: 16 Rows_examined: 542166 SET timestamp=1339526378; SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM oinkoink_bp_activity a LEFT JOIN oinkoink_users u ON a.user_id = u.ID WHERE a.component IN ( 'groups' ) AND a.type IN ( 'new_blog_post','new_forum_topic','activity_update','joined_group' ) AND a.item_id IN ( 2708 ) AND a.hide_sitewide = 0 AND a.type != 'activity_comment' ORDER BY a.date_recorded DESC LIMIT 0, 20;