Context Navigation

Back to Ticket #4251

Ticket #4251: SlowQueryLog-Cleaned.txt

File SlowQueryLog-Cleaned.txt, 31.5 KB (added by TheBeardedOne, 14 years ago)

Line
1	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
2	# Query_time: 84.657053 Lock_time: 10.948963 Rows_sent: 2 Rows_examined: 47415
3	SET timestamp=1339526363;
4	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;
5	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
6	# Query_time: 83.728222 Lock_time: 10.021006 Rows_sent: 3 Rows_examined: 47398
7	SET timestamp=1339526363;
8	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;
9	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
10	# Query_time: 83.753718 Lock_time: 10.045860 Rows_sent: 2 Rows_examined: 47396
11	SET timestamp=1339526363;
12	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;
13	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
14	# Query_time: 127.140832 Lock_time: 53.433754 Rows_sent: 3 Rows_examined: 47401
15	SET timestamp=1339526363;
16	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;
17	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
18	# Query_time: 83.769109 Lock_time: 10.059694 Rows_sent: 1 Rows_examined: 47384
19	SET timestamp=1339526363;
20	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;
21	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
22	# Query_time: 81.653933 Lock_time: 7.945210 Rows_sent: 3 Rows_examined: 47417
23	SET timestamp=1339526363;
24	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;
25	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
26	# Query_time: 83.863051 Lock_time: 10.152647 Rows_sent: 5 Rows_examined: 47441
27	SET timestamp=1339526363;
28	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;
29	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
30	# Query_time: 83.758822 Lock_time: 10.049066 Rows_sent: 3 Rows_examined: 47434
31	SET timestamp=1339526363;
32	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;
33	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
34	# Query_time: 83.752769 Lock_time: 10.043086 Rows_sent: 2 Rows_examined: 47387
35	SET timestamp=1339526363;
36	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;
37	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
38	# Query_time: 83.742959 Lock_time: 10.033943 Rows_sent: 1 Rows_examined: 47388
39	SET timestamp=1339526363;
40	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;
41	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
42	# Query_time: 83.822980 Lock_time: 10.111709 Rows_sent: 5 Rows_examined: 47437
43	SET timestamp=1339526363;
44	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;
45	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
46	# Query_time: 83.928872 Lock_time: 10.215044 Rows_sent: 6 Rows_examined: 47476
47	SET timestamp=1339526363;
48	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;
49	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
50	# Query_time: 83.751601 Lock_time: 10.038792 Rows_sent: 3 Rows_examined: 47434
51	SET timestamp=1339526363;
52	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;
53	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
54	# Query_time: 83.797589 Lock_time: 10.082620 Rows_sent: 3 Rows_examined: 47427
55	SET timestamp=1339526363;
56	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;
57	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
58	# Query_time: 130.401273 Lock_time: 56.684031 Rows_sent: 5 Rows_examined: 47445
59	SET timestamp=1339526363;
60	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;
61	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
62	# Query_time: 83.785951 Lock_time: 10.070407 Rows_sent: 3 Rows_examined: 47434
63	SET timestamp=1339526363;
64	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;
65	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
66	# Query_time: 84.084903 Lock_time: 10.368280 Rows_sent: 4 Rows_examined: 47409
67	SET timestamp=1339526363;
68	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;
69	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
70	# Query_time: 83.757652 Lock_time: 10.040226 Rows_sent: 1 Rows_examined: 47382
71	SET timestamp=1339526363;
72	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;
73	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
74	# Query_time: 83.726013 Lock_time: 10.008721 Rows_sent: 6 Rows_examined: 47461
75	SET timestamp=1339526363;
76	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;
77	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
78	# Query_time: 84.099554 Lock_time: 10.375752 Rows_sent: 2 Rows_examined: 47391
79	SET timestamp=1339526363;
80	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;
81	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
82	# Query_time: 84.155354 Lock_time: 10.431377 Rows_sent: 9 Rows_examined: 47426
83	SET timestamp=1339526363;
84	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;
85	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
86	# Query_time: 83.778235 Lock_time: 10.054797 Rows_sent: 5 Rows_examined: 47439
87	SET timestamp=1339526363;
88	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;
89	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
90	# Query_time: 83.775194 Lock_time: 10.050523 Rows_sent: 11 Rows_examined: 47536
91	SET timestamp=1339526363;
92	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;
93	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
94	# Query_time: 83.883131 Lock_time: 10.157410 Rows_sent: 16 Rows_examined: 47487
95	SET timestamp=1339526363;
96	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;
97	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
98	# Query_time: 132.626439 Lock_time: 58.899154 Rows_sent: 4 Rows_examined: 47420
99	SET timestamp=1339526363;
100	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;
101	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
102	# Query_time: 84.100424 Lock_time: 10.372114 Rows_sent: 4 Rows_examined: 47407
103	SET timestamp=1339526363;
104	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;
105	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
106	# Query_time: 83.884038 Lock_time: 10.155929 Rows_sent: 2 Rows_examined: 47410
107	SET timestamp=1339526363;
108	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;
109	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
110	# Query_time: 83.727072 Lock_time: 9.997490 Rows_sent: 8 Rows_examined: 47529
111	SET timestamp=1339526363;
112	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;
113	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
114	# Query_time: 83.787296 Lock_time: 10.056923 Rows_sent: 9 Rows_examined: 47496
115	SET timestamp=1339526363;
116	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;
117	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
118	# Query_time: 83.845463 Lock_time: 10.114298 Rows_sent: 2 Rows_examined: 47415
119	SET timestamp=1339526363;
120	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;
121	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
122	# Query_time: 83.766200 Lock_time: 10.034877 Rows_sent: 7 Rows_examined: 47483
123	SET timestamp=1339526363;
124	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;
125	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
126	# Query_time: 83.823684 Lock_time: 10.090532 Rows_sent: 18 Rows_examined: 47595
127	SET timestamp=1339526363;
128	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;
129	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
130	# Query_time: 83.785799 Lock_time: 10.053153 Rows_sent: 1 Rows_examined: 47382
131	SET timestamp=1339526363;
132	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;
133	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
134	# Query_time: 83.935752 Lock_time: 10.202299 Rows_sent: 11 Rows_examined: 47536
135	SET timestamp=1339526363;
136	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;
137	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
138	# Query_time: 83.753350 Lock_time: 10.019945 Rows_sent: 7 Rows_examined: 47483
139	SET timestamp=1339526363;
140	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;
141	# Time: 120612 13:39:24
142	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
143	# Query_time: 84.170385 Lock_time: 10.431821 Rows_sent: 16 Rows_examined: 47487
144	SET timestamp=1339526364;
145	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;
146	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
147	# Query_time: 132.620011 Lock_time: 58.876629 Rows_sent: 4 Rows_examined: 47420
148	SET timestamp=1339526364;
149	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;
150	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
151	# Query_time: 83.785370 Lock_time: 10.043636 Rows_sent: 9 Rows_examined: 47496
152	SET timestamp=1339526364;
153	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;
154	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
155	# Query_time: 83.881367 Lock_time: 10.122872 Rows_sent: 23 Rows_examined: 47650
156	SET timestamp=1339526364;
157	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;
158	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
159	# Query_time: 70.243407 Lock_time: 0.000188 Rows_sent: 1 Rows_examined: 47397
160	SET timestamp=1339526364;
161	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;
162	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
163	# Query_time: 68.884012 Lock_time: 0.000262 Rows_sent: 9 Rows_examined: 47535
164	SET timestamp=1339526364;
165	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;
166	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
167	# Query_time: 64.797578 Lock_time: 0.000235 Rows_sent: 2 Rows_examined: 47394
168	SET timestamp=1339526364;
169	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;
170	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
171	# Query_time: 64.931975 Lock_time: 0.000181 Rows_sent: 1 Rows_examined: 47382
172	SET timestamp=1339526364;
173	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;
174	# Time: 120612 13:39:25
175	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
176	# Query_time: 70.500337 Lock_time: 0.000327 Rows_sent: 20 Rows_examined: 56461
177	SET timestamp=1339526365;
178	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;
179	# Time: 120612 13:39:26
180	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
181	# Query_time: 80.840424 Lock_time: 0.000234 Rows_sent: 1 Rows_examined: 32470
182	SET timestamp=1339526366;
183	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;
184	# Time: 120612 13:39:27
185	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
186	# Query_time: 80.267061 Lock_time: 2.710301 Rows_sent: 20 Rows_examined: 32510
187	SET timestamp=1339526367;
188	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;
189	# Time: 120612 13:39:28
190	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
191	# Query_time: 141.124176 Lock_time: 0.000097 Rows_sent: 1 Rows_examined: 263361
192	SET timestamp=1339526368;
193	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;
194	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
195	# Query_time: 141.217117 Lock_time: 0.000107 Rows_sent: 1 Rows_examined: 263361
196	SET timestamp=1339526368;
197	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;
198	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
199	# Query_time: 147.526048 Lock_time: 0.000115 Rows_sent: 1 Rows_examined: 263361
200	SET timestamp=1339526368;
201	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;
202	# Time: 120612 13:39:29
203	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
204	# Query_time: 142.243672 Lock_time: 0.000107 Rows_sent: 1 Rows_examined: 263361
205	SET timestamp=1339526369;
206	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;
207	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
208	# Query_time: 142.678522 Lock_time: 0.000165 Rows_sent: 1 Rows_examined: 263361
209	SET timestamp=1339526369;
210	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;
211	# Time: 120612 13:39:30
212	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
213	# Query_time: 79.984826 Lock_time: 0.000164 Rows_sent: 1 Rows_examined: 136246
214	SET timestamp=1339526370;
215	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;
216	# Time: 120612 13:39:33
217	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
218	# Query_time: 69.954740 Lock_time: 0.000103 Rows_sent: 1 Rows_examined: 263361
219	SET timestamp=1339526373;
220	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;
221	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
222	# Query_time: 70.394600 Lock_time: 0.000082 Rows_sent: 1 Rows_examined: 263361
223	SET timestamp=1339526373;
224	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;
225	# Time: 120612 13:39:38
226	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
227	# Query_time: 155.584826 Lock_time: 67.459831 Rows_sent: 15 Rows_examined: 542165
228	SET timestamp=1339526378;
229	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;
230	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
231	# Query_time: 83.731199 Lock_time: 0.000178 Rows_sent: 4 Rows_examined: 542154
232	SET timestamp=1339526378;
233	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;
234	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
235	# Query_time: 125.135236 Lock_time: 36.954538 Rows_sent: 15 Rows_examined: 542165
236	SET timestamp=1339526378;
237	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;
238	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
239	# Query_time: 142.206793 Lock_time: 53.988699 Rows_sent: 10 Rows_examined: 542180
240	SET timestamp=1339526378;
241	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;
242	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
243	# Query_time: 83.828226 Lock_time: 0.000179 Rows_sent: 4 Rows_examined: 542154
244	SET timestamp=1339526378;
245	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;
246	# User@Host: rufusrufusrufus[rufusrufusrufus] @ buddypress.example.com [255.255.255.255]
247	# Query_time: 84.041071 Lock_time: 0.000323 Rows_sent: 16 Rows_examined: 542166
248	SET timestamp=1339526378;
249	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;
250

Trac UI Preferences

Download in other formats:

Original Format

BuddyPress.org

Context Navigation

Ticket #4251: SlowQueryLog-Cleaned.txt

Download in other formats: