Context Navigation

Back to Ticket #585

Ticket #585: sql.report.log

File sql.report.log, 230.4 KB (added by jim, 3 years ago)
Processed slow query log - puffin 5 sep 2013

Line
1	################################################################################
2
3	MySQL Slow Query Log Parser v 0.1 Alpha
4
5	Thu Sep 05 12:19:29 +0100 2013
6	Output for ../sql-slow-query.log ordered by
7
8	################################################################################
9
10
11	################################################################################
12	1 Queries
13	user: spacetransitionn[spacetransitionn]
14	url: localhost
15	ip: []
16	Taking 233519 seconds to complete
17	Locking for 0 seconds
18	Average time: 233519, Median time 233519
19	Average lock: 0, Median lock 0
20
21	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
22	SET timestamp=XXX;
23	SELECT module, delta, rid FROM block_role;
24	################################################################################
25	1 Queries
26	user: transitionnetw_0[transitionnetw_0]
27	url: localhost
28	ip: []
29	Taking 230727 seconds to complete
30	Locking for 0 seconds
31	Average time: 230727, Median time 230727
32	Average lock: 0, Median lock 0
33
34	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
35	use transitionnetw_XXX;
36	SET timestamp=XXX;
37	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
38	FROM node node
39	LEFT JOIN content_field_em_video node_data_field_em_video ON node.vid = node_data_field_em_video.vid
40	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)) AND ((node_data_field_em_video.field_em_video_embed) LIKE (XXX))
41	)) count_alias;
42	################################################################################
43	1 Queries
44	user: transitionnetw_0[transitionnetw_0]
45	url: localhost
46	ip: []
47	Taking 226737 seconds to complete
48	Locking for 0 seconds
49	Average time: 226737, Median time 226737
50	Average lock: 0, Median lock 0
51
52	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
53	use transitionnetw_XXX;
54	SET timestamp=XXX;
55	SELECT css_class, module, delta FROM block_class;
56	################################################################################
57	1 Queries
58	user: transitionnetw_0[transitionnetw_0]
59	url: localhost
60	ip: []
61	Taking 241878 seconds to complete
62	Locking for 0 seconds
63	Average time: 241878, Median time 241878
64	Average lock: 0, Median lock 0
65
66	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
67	use transitionnetw_XXX;
68	SET timestamp=XXX;
69	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
70	FROM node node
71	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
72	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
73	WHERE ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
74	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
75	) count_alias;
76	################################################################################
77	1 Queries
78	user: transitionnetw_0[transitionnetw_0]
79	url: localhost
80	ip: []
81	Taking 225767 seconds to complete
82	Locking for 0 seconds
83	Average time: 225767, Median time 225767
84	Average lock: 0, Median lock 0
85
86	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
87	use transitionnetw_XXX;
88	SET timestamp=XXX;
89	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
90	FROM node node
91	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
92	LEFT JOIN location location ON location_instance.lid = location.lid
93	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < XXX.XXX)
94	)) count_alias;
95	################################################################################
96	1 Queries
97	user: transitionnetw_0[transitionnetw_0]
98	url: localhost
99	ip: []
100	Taking 210909 seconds to complete
101	Locking for 0 seconds
102	Average time: 210909, Median time 210909
103	Average lock: 0, Median lock 0
104
105	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
106	SET timestamp=XXX;
107	SELECT COUNT() FROM (SELECT i.type, i.sid, XXX (XXX.XXX * SUM(i.score * t.count)) + XXX * POW(XXX, (GREATEST(MAX(n.created), MAX(n.changed), COALESCE(MAX(c.last_comment_timestamp), XXX)) - XXX) * XXX.XXXe-XXX) + XXX * (XXX.XXX - XXX.XXX / (XXX.XXX + MAX(c.comment_count) * XXX.XXX)) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid INNER JOIN node_access na ON na.nid = n.nid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE n.status = XXX AND (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND (i.word = XXX OR i.word = XXX) AND i.type = XXX GROUP BY i.type, i.sid HAVING COUNT(*) >= XXX) nXXX;
108	################################################################################
109	1 Queries
110	user: debian-sys-maint[debian-sys-maint]
111	url: localhost
112	ip: []
113	Taking 219247 seconds to complete
114	Locking for 0 seconds
115	Average time: 219247, Median time 219247
116	Average lock: 0, Median lock 0
117
118	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
119	SET timestamp=XXX;
120	SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN (XXX,XXX) AND Data_free > XXX AND NOT ENGINE=XXX;
121	################################################################################
122	1 Queries
123	user: transitionnetw_0[transitionnetw_0]
124	url: localhost
125	ip: []
126	Taking 204925 seconds to complete
127	Locking for 0 seconds
128	Average time: 204925, Median time 204925
129	Average lock: 0, Median lock 0
130
131	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
132	use transitionnetw_XXX;
133	SET timestamp=XXX;
134	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
135	FROM node node
136	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
137	LEFT JOIN location location ON location_instance.lid = location.lid
138	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > XXX.XXX AND location.longitude < XXX.XXX)
139	)) count_alias;
140	################################################################################
141	1 Queries
142	user: transitionnetw_0[transitionnetw_0]
143	url: localhost
144	ip: []
145	Taking 231215 seconds to complete
146	Locking for 0 seconds
147	Average time: 231215, Median time 231215
148	Average lock: 0, Median lock 0
149
150	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
151	SET timestamp=XXX;
152	SELECT * FROM panels_renderer_pipeline t__XXX WHERE name IN (XXX);
153	################################################################################
154	1 Queries
155	user: transitionnetw_0[transitionnetw_0]
156	url: localhost
157	ip: []
158	Taking 235161 seconds to complete
159	Locking for 0 seconds
160	Average time: 235161, Median time 235161
161	Average lock: 0, Median lock 0
162
163	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
164	SET timestamp=XXX;
165	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
166	FROM node node
167	LEFT JOIN content_field_contact_media node_data_field_contact_media ON node.vid = node_data_field_contact_media.vid
168	LEFT JOIN users users_node_data_field_contact_media ON node_data_field_contact_media.field_contact_media_uid = users_node_data_field_contact_media.uid
169	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node_data_field_contact_media.field_contact_media_uid IS NOT NULL)
170	)) count_alias;
171	################################################################################
172	1 Queries
173	user: transitionnetw_0[transitionnetw_0]
174	url: localhost
175	ip: []
176	Taking 228539 seconds to complete
177	Locking for 0 seconds
178	Average time: 228539, Median time 228539
179	Average lock: 0, Median lock 0
180
181	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
182	use transitionnetw_XXX;
183	SET timestamp=XXX;
184	SELECT count(field_image_fid)
185	FROM content_field_image
186	WHERE field_image_fid = XXX;
187	################################################################################
188	1 Queries
189	user: transitionnetw_0[transitionnetw_0]
190	url: localhost
191	ip: []
192	Taking 213345 seconds to complete
193	Locking for 0 seconds
194	Average time: 213345, Median time 213345
195	Average lock: 0, Median lock 0
196
197	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
198	use transitionnetw_XXX;
199	SET timestamp=XXX;
200	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
201	node.sticky AS node_sticky,
202	node.created AS node_created
203	FROM node node
204	INNER JOIN users users ON node.uid = users.uid
205	WHERE (node.status = XXX) AND (node.type in (XXX)) AND (users.name = XXX)
206	GROUP BY nid
207	ORDER BY node_sticky DESC, node_created DESC
208	) count_alias;
209	################################################################################
210	1 Queries
211	user: masterpuffinwe_0[masterpuffinwe_0]
212	url: localhost
213	ip: []
214	Taking 203740 seconds to complete
215	Locking for 0 seconds
216	Average time: 203740, Median time 203740
217	Average lock: 0, Median lock 0
218
219	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
220	use masterpuffinwe_XXX;
221	SET timestamp=XXX;
222	DELETE FROM history WHERE timestamp < XXX;
223	################################################################################
224	1 Queries
225	user: transitionnetw_0[transitionnetw_0]
226	url: localhost
227	ip: []
228	Taking 239304 seconds to complete
229	Locking for 0 seconds
230	Average time: 239304, Median time 239304
231	Average lock: 0, Median lock 0
232
233	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
234	use transitionnetw_XXX;
235	SET timestamp=XXX;
236	SELECT u.name, u.uid FROM users u WHERE (u.name LIKE XXX) ORDER BY u.name ASC;
237	################################################################################
238	1 Queries
239	user: transitionnetw_0[transitionnetw_0]
240	url: localhost
241	ip: []
242	Taking 225570 seconds to complete
243	Locking for 0 seconds
244	Average time: 225570, Median time 225570
245	Average lock: 0, Median lock 0
246
247	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
248	use transitionnetw_XXX;
249	SET timestamp=XXX;
250	SELECT f.*, u.nid FROM files f INNER JOIN upload u ON f.fid = u.fid WHERE filepath = XXXn\XXX;
251	################################################################################
252	1 Queries
253	user: transitionnetw_0[transitionnetw_0]
254	url: localhost
255	ip: []
256	Taking 224489 seconds to complete
257	Locking for 0 seconds
258	Average time: 224489, Median time 224489
259	Average lock: 0, Median lock 0
260
261	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
262	use transitionnetw_XXX;
263	SET timestamp=XXX;
264	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
265	node.title AS node_title,
266	node.language AS node_language,
267	location.province AS location_province,
268	location.country AS location_country
269	FROM node node
270	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
271	LEFT JOIN location location ON location_instance.lid = location.lid
272	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node.status = XXX)
273	)GROUP BY nid
274	ORDER BY node_title ASC
275	) count_alias;
276	################################################################################
277	1 Queries
278	user: transitionnetw_0[transitionnetw_0]
279	url: localhost
280	ip: []
281	Taking 239563 seconds to complete
282	Locking for 0 seconds
283	Average time: 239563, Median time 239563
284	Average lock: 0, Median lock 0
285
286	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
287	use transitionnetw_XXX;
288	SET timestamp=XXX;
289	SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (XXX,XXX,XXX,XXX,XXX);
290	################################################################################
291	1 Queries
292	user: transitionnetw_0[transitionnetw_0]
293	url: localhost
294	ip: []
295	Taking 206140 seconds to complete
296	Locking for 0 seconds
297	Average time: 206140, Median time 206140
298	Average lock: 0, Median lock 0
299
300	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
301	SET timestamp=XXX;
302	SELECT fid, title FROM aggregator_feed ORDER BY fid;
303	################################################################################
304	1 Queries
305	user: transitionnetw_0[transitionnetw_0]
306	url: localhost
307	ip: []
308	Taking 238884 seconds to complete
309	Locking for 0 seconds
310	Average time: 238884, Median time 238884
311	Average lock: 0, Median lock 0
312
313	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
314	SET timestamp=XXX;
315	SELECT name, filename FROM system WHERE status = XXX;
316	################################################################################
317	1 Queries
318	user: transitionnetw_0[transitionnetw_0]
319	url: localhost
320	ip: []
321	Taking 240756 seconds to complete
322	Locking for 0 seconds
323	Average time: 240756, Median time 240756
324	Average lock: 0, Median lock 0
325
326	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
327	use transitionnetw_XXX;
328	SET timestamp=XXX;
329	SELECT DISTINCT node.nid AS nid,
330	node.title AS node_title,
331	node.language AS node_language,
332	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
333	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
334	node.type AS node_type,
335	node.vid AS node_vid
336	FROM node node
337	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
338	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
339	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
340	AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX))
341	);
342	################################################################################
343	1 Queries
344	user: transitionnetw_0[transitionnetw_0]
345	url: localhost
346	ip: []
347	Taking 218065 seconds to complete
348	Locking for 0 seconds
349	Average time: 218065, Median time 218065
350	Average lock: 0, Median lock 0
351
352	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
353	use transitionnetw_XXX;
354	SET timestamp=XXX;
355	SELECT t.word AS realword, i.word FROM search_total t LEFT JOIN search_index i ON t.word = i.word WHERE i.word IS NULL;
356	################################################################################
357	1 Queries
358	user: transitionnetw_0[transitionnetw_0]
359	url: localhost
360	ip: []
361	Taking 207655 seconds to complete
362	Locking for 0 seconds
363	Average time: 207655, Median time 207655
364	Average lock: 0, Median lock 0
365
366	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
367	use transitionnetw_XXX;
368	SET timestamp=XXX;
369	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
370	node.title AS node_title,
371	node.language AS node_language,
372	node.type AS node_type,
373	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
374	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
375	node.vid AS node_vid,
376	location.lid AS location_lid
377	FROM node node
378	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
379	LEFT JOIN content_field_occurs node_data_field_occursXXX ON node.vid = node_data_field_occursXXX.vid
380	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
381	LEFT JOIN location location ON location_instance.lid = location.lid
382	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)))
383	AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX) OR ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occursXXX.field_occurs_value, XXX), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occursXXX.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)))
384	)GROUP BY nid
385	ORDER BY node_data_field_occurs_field_occurs_value ASC
386	) count_alias;
387	################################################################################
388	1 Queries
389	user: newstransition_0[newstransition_0]
390	url: localhost
391	ip: []
392	Taking 213064 seconds to complete
393	Locking for 0 seconds
394	Average time: 213064, Median time 213064
395	Average lock: 0, Median lock 0
396
397	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
398	SET timestamp=XXX;
399	SELECT node.nid AS nid,
400	node.title AS node_title,
401	feeds_data_feed_fast.timestamp AS feeds_data_feed_fast_timestamp,
402	location.country AS location_country
403	FROM node node
404	LEFT JOIN feeds_node_item feeds_node_item ON node.nid = feeds_node_item.nid
405	LEFT JOIN node node_feeds_node_item ON feeds_node_item.feed_nid = node_feeds_node_item.nid
406	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
407	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
408	LEFT JOIN location location ON location_instance.lid = location.lid
409	WHERE (node.type in (XXX)) AND (node.status = XXX)
410	ORDER BY feeds_data_feed_fast_timestamp DESC, node_title ASC
411	LIMIT XXX, XXX;
412	################################################################################
413	1 Queries
414	user: transitionnetw_0[transitionnetw_0]
415	url: localhost
416	ip: []
417	Taking 222518 seconds to complete
418	Locking for 0 seconds
419	Average time: 222518, Median time 222518
420	Average lock: 0, Median lock 0
421
422	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
423	use transitionnetw_XXX;
424	SET timestamp=XXX;
425	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
426	node.title AS node_title,
427	node.language AS node_language,
428	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
429	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
430	node.type AS node_type,
431	node.vid AS node_vid
432	FROM node node
433	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
434	LEFT JOIN content_field_stage node_data_field_stage ON node.vid = node_data_field_stage.vid
435	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_stage.field_stage_nid = XXX ))
436	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
437	)GROUP BY nid
438	ORDER BY node_data_field_occurs_field_occurs_value ASC
439	) count_alias;
440	################################################################################
441	1 Queries
442	user: transitionnetw_0[transitionnetw_0]
443	url: localhost
444	ip: []
445	Taking 241265 seconds to complete
446	Locking for 0 seconds
447	Average time: 241265, Median time 241265
448	Average lock: 0, Median lock 0
449
450	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
451	SET timestamp=XXX;
452	SELECT v.* FROM vocabulary v INNER JOIN vocabulary_node_types n ON v.vid = n.vid WHERE n.type = XXX ORDER BY v.weight, v.name;
453	################################################################################
454	1 Queries
455	user: transitionnetw_0[transitionnetw_0]
456	url: localhost
457	ip: []
458	Taking 225404 seconds to complete
459	Locking for 0 seconds
460	Average time: 225404, Median time 225404
461	Average lock: 0, Median lock 0
462
463	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
464	use transitionnetw_XXX;
465	SET timestamp=XXX;
466	SELECT * FROM files WHERE filepath = XXX;
467	################################################################################
468	1 Queries
469	user: transitionnetw_0[transitionnetw_0]
470	url: localhost
471	ip: []
472	Taking 221028 seconds to complete
473	Locking for 0 seconds
474	Average time: 221028, Median time 221028
475	Average lock: 0, Median lock 0
476
477	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
478	SET timestamp=XXX;
479	SELECT uid, name FROM users WHERE status = XXX AND access > XXX ORDER BY created DESC;
480	################################################################################
481	1 Queries
482	user: transitionnetw_0[transitionnetw_0]
483	url: localhost
484	ip: []
485	Taking 226205 seconds to complete
486	Locking for 0 seconds
487	Average time: 226205, Median time 226205
488	Average lock: 0, Median lock 0
489
490	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
491	SET timestamp=XXX;
492	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
493	node.sticky AS node_sticky,
494	node.created AS node_created
495	FROM node node
496	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX))
497	)GROUP BY nid
498	ORDER BY node_sticky DESC, node_created DESC
499	) count_alias;
500	################################################################################
501	1 Queries
502	user: debian-sys-maint[debian-sys-maint]
503	url: localhost
504	ip: []
505	Taking 219250 seconds to complete
506	Locking for 0 seconds
507	Average time: 219250, Median time 219250
508	Average lock: 0, Median lock 0
509
510	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
511	SET timestamp=XXX;
512	SELECT IFNULL(SUM(INDEX_LENGTH),XXX) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN (XXX) AND ENGINE = XXX;
513	################################################################################
514	1 Queries
515	user: transitionnetw_0[transitionnetw_0]
516	url: localhost
517	ip: []
518	Taking 230418 seconds to complete
519	Locking for 0 seconds
520	Average time: 230418, Median time 230418
521	Average lock: 0, Median lock 0
522
523	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
524	SET timestamp=XXX;
525	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
526	node.title AS node_title,
527	node.language AS node_language,
528	users.name AS users_name,
529	users.uid AS users_uid,
530	node.created AS node_created,
531	'' AS customfield_markup_XXX,
532	'' AS customfield_markup_XXX,
533	node.sticky AS node_sticky
534	FROM node node
535	LEFT JOIN content_field_blog_sr_rel_stage node_data_field_blog_sr_rel_stage ON node.vid = node_data_field_blog_sr_rel_stage.vid
536	INNER JOIN users users ON node.uid = users.uid
537	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_blog_sr_rel_stage.field_blog_sr_rel_stage_nid = XXX )
538	)GROUP BY nid
539	ORDER BY node_sticky DESC, node_created DESC
540	) count_alias;
541	################################################################################
542	1 Queries
543	user: transitionnetw_0[transitionnetw_0]
544	url: localhost
545	ip: []
546	Taking 213184 seconds to complete
547	Locking for 0 seconds
548	Average time: 213184, Median time 213184
549	Average lock: 0, Median lock 0
550
551	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
552	SET timestamp=XXX;
553	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
554	node.sticky AS node_sticky,
555	node.created AS node_created
556	FROM node node
557	WHERE (node.status = XXX) AND (node.type in (XXX))
558	GROUP BY nid
559	ORDER BY node_sticky DESC, node_created DESC
560	) count_alias;
561	################################################################################
562	1 Queries
563	user: transitionnetw_0[transitionnetw_0]
564	url: localhost
565	ip: []
566	Taking 235210 seconds to complete
567	Locking for 0 seconds
568	Average time: 235210, Median time 235210
569	Average lock: 0, Median lock 0
570
571	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
572	SET timestamp=XXX;
573	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
574	node.title AS node_title,
575	node.language AS node_language,
576	location.province AS location_province,
577	location.country AS location_country,
578	node_data_field_status.field_status_value AS node_data_field_status_field_status_value,
579	node.type AS node_type,
580	node.vid AS node_vid
581	FROM node node
582	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
583	LEFT JOIN location location ON location_instance.lid = location.lid
584	LEFT JOIN content_type_initiative_profile node_data_field_status ON node.vid = node_data_field_status.vid
585	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX, XXX)) AND (node.status = XXX)
586	)GROUP BY nid
587	ORDER BY node_title ASC
588	) count_alias;
589	################################################################################
590	1 Queries
591	user: transitionnetw_0[transitionnetw_0]
592	url: localhost
593	ip: []
594	Taking 238884 seconds to complete
595	Locking for 0 seconds
596	Average time: 238884, Median time 238884
597	Average lock: 0, Median lock 0
598
599	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
600	SET timestamp=XXX;
601	SELECT ml.link_path, ml.mlid, ml.router_path, ml.updated FROM menu_links ml WHERE ml.updated = XXX OR (router_path NOT IN (XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX) AND external = XXX AND customized = XXX);
602	################################################################################
603	1 Queries
604	user: transitionnetw_0[transitionnetw_0]
605	url: localhost
606	ip: []
607	Taking 238961 seconds to complete
608	Locking for 0 seconds
609	Average time: 238961, Median time 238961
610	Average lock: 0, Median lock 0
611
612	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
613	SET timestamp=XXX;
614	SELECT brb.*
615	FROM
616	botcha_recipebook brb;
617	################################################################################
618	1 Queries
619	user: transitionnetw_0[transitionnetw_0]
620	url: localhost
621	ip: []
622	Taking 238884 seconds to complete
623	Locking for 0 seconds
624	Average time: 238884, Median time 238884
625	Average lock: 0, Median lock 0
626
627	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
628	SET timestamp=XXX;
629	SELECT menu_name FROM menu_links WHERE expanded != XXX GROUP BY menu_name;
630	################################################################################
631	1 Queries
632	user: transitionnetw_0[transitionnetw_0]
633	url: localhost
634	ip: []
635	Taking 226656 seconds to complete
636	Locking for 0 seconds
637	Average time: 226656, Median time 226656
638	Average lock: 0, Median lock 0
639
640	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
641	use transitionnetw_XXX;
642	SET timestamp=XXX;
643	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
644	FROM node node
645	INNER JOIN nodequeue_nodes nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND nodequeue_nodes_node.qid = XXX
646	LEFT JOIN content_type_resource node_data_field_asset_type ON node.vid = node_data_field_asset_type.vid
647	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
648	LEFT JOIN location location ON location_instance.lid = location.lid
649	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX))
650	)) count_alias;
651	################################################################################
652	1 Queries
653	user: transitionnetw_0[transitionnetw_0]
654	url: localhost
655	ip: []
656	Taking 239054 seconds to complete
657	Locking for 0 seconds
658	Average time: 239054, Median time 239054
659	Average lock: 0, Median lock 0
660
661	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
662	SET timestamp=XXX;
663	SELECT name, schema_version FROM system WHERE type = XXX;
664	################################################################################
665	1 Queries
666	user: transitionnetw_0[transitionnetw_0]
667	url: localhost
668	ip: []
669	Taking 239563 seconds to complete
670	Locking for 0 seconds
671	Average time: 239563, Median time 239563
672	Average lock: 0, Median lock 0
673
674	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
675	SET timestamp=XXX;
676	SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (XXX,XXX,XXX,XXX,XXX);
677	################################################################################
678	1 Queries
679	user: spacetransitionn[spacetransitionn]
680	url: localhost
681	ip: []
682	Taking 224085 seconds to complete
683	Locking for 0 seconds
684	Average time: 224085, Median time 224085
685	Average lock: 0, Median lock 0
686
687	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
688	SET timestamp=XXX;
689	SELECT t.*
690	FROM
691	field_data_message_text t
692	WHERE (entity_type = XXX) AND (entity_id IN (XXX, XXX, XXX, XXX, XXX, XXX)) AND (language IN (XXX)) AND (deleted = XXX)
693	ORDER BY delta ASC;
694	################################################################################
695	1 Queries
696	user: transitionnetw_0[transitionnetw_0]
697	url: localhost
698	ip: []
699	Taking 238884 seconds to complete
700	Locking for 0 seconds
701	Average time: 238884, Median time 238884
702	Average lock: 0, Median lock 0
703
704	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
705	SET timestamp=XXX;
706	SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC;
707	################################################################################
708	1 Queries
709	user: tnpuffinwebarchn[tnpuffinwebarchn]
710	url: localhost
711	ip: []
712	Taking 225419 seconds to complete
713	Locking for 0 seconds
714	Average time: 225419, Median time 225419
715	Average lock: 0, Median lock 0
716
717	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
718	SET timestamp=XXX;
719	SELECT count(n.nid) FROM node n
720	LEFT JOIN hosting_site hs ON n.nid = hs.nid
721	LEFT JOIN hosting_advanced_cron hac ON n.nid = hac.nid
722	WHERE n.type = XXX AND hs.status = XXX
723	AND ((hac.cron_interval IS NOT NULL AND hac.cron_interval > XXX)
724	OR (hac.cron_interval IS NULL AND XXX > XXX));
725	################################################################################
726	1 Queries
727	user: root[root]
728	url: localhost
729	ip: []
730	Taking 219454 seconds to complete
731	Locking for 0 seconds
732	Average time: 219454, Median time 219454
733	Average lock: 0, Median lock 0
734
735	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
736	SET timestamp=XXX;
737	/!XXX SELECT COUNT() FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE=XXX */;
738	################################################################################
739	1 Queries
740	user: spacetransitionn[spacetransitionn]
741	url: localhost
742	ip: []
743	Taking 233519 seconds to complete
744	Locking for 0 seconds
745	Average time: 233519, Median time 233519
746	Average lock: 0, Median lock 0
747
748	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
749	SET timestamp=XXX;
750	SELECT base.id AS id, base.name AS name, base.label AS label, base.plugin AS plugin, base.active AS active, base.weight AS weight, base.status AS status, base.dirty AS dirty, base.module AS module, base.access_exposed AS access_exposed, base.data AS data
751	FROM
752	rules_config base
753	WHERE (base.plugin IN (XXX, XXX, XXX, XXX, XXX));
754	################################################################################
755	1 Queries
756	user: transitionnetw_0[transitionnetw_0]
757	url: localhost
758	ip: []
759	Taking 237625 seconds to complete
760	Locking for 0 seconds
761	Average time: 237625, Median time 237625
762	Average lock: 0, Median lock 0
763
764	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
765	SET timestamp=XXX;
766	SELECT DISTINCT t.tid, COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( n.status = XXX )GROUP BY t.tid;
767	################################################################################
768	1 Queries
769	user: spacetransitionn[spacetransitionn]
770	url: localhost
771	ip: []
772	Taking 233519 seconds to complete
773	Locking for 0 seconds
774	Average time: 233519, Median time 233519
775	Average lock: 0, Median lock 0
776
777	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
778	use spacetransitionn;
779	SET timestamp=XXX;
780	SELECT t__XXX.*
781	FROM
782	panelizer_defaults t__XXX
783	WHERE (name IN (XXX, XXX, XXX));
784	################################################################################
785	1 Queries
786	user: transitionnetw_0[transitionnetw_0]
787	url: localhost
788	ip: []
789	Taking 213902 seconds to complete
790	Locking for 0 seconds
791	Average time: 213902, Median time 213902
792	Average lock: 0, Median lock 0
793
794	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
795	use transitionnetw_XXX;
796	SET timestamp=XXX;
797	SELECT DISTINCT node.nid AS nid,
798	node.title AS node_title,
799	node.language AS node_language,
800	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
801	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
802	node.type AS node_type,
803	node.vid AS node_vid
804	FROM node node
805	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
806	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
807	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
808	AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX))
809	)ORDER BY node_data_field_occurs_field_occurs_value ASC;
810	################################################################################
811	1 Queries
812	user: transitionnetw_0[transitionnetw_0]
813	url: localhost
814	ip: []
815	Taking 206514 seconds to complete
816	Locking for 0 seconds
817	Average time: 206514, Median time 206514
818	Average lock: 0, Median lock 0
819
820	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
821	SET timestamp=XXX;
822	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
823	node.title AS node_title,
824	node.language AS node_language,
825	location.province AS location_province,
826	location.country AS location_country,
827	node_data_field_status.field_status_value AS node_data_field_status_field_status_value,
828	node.type AS node_type,
829	node.vid AS node_vid
830	FROM node node
831	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
832	LEFT JOIN location location ON location_instance.lid = location.lid
833	LEFT JOIN content_type_initiative_profile node_data_field_status ON node.vid = node_data_field_status.vid
834	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX, XXX)) AND (node.status = XXX) AND (location.country = XXX)
835	)GROUP BY nid
836	ORDER BY node_title ASC
837	) count_alias;
838	################################################################################
839	1 Queries
840	user: transitionnetw_0[transitionnetw_0]
841	url: localhost
842	ip: []
843	Taking 240085 seconds to complete
844	Locking for 0 seconds
845	Average time: 240085, Median time 240085
846	Average lock: 0, Median lock 0
847
848	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
849	SET timestamp=XXX;
850	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
851	FROM node node
852	LEFT JOIN content_field_em_video node_data_field_em_video ON node.vid = node_data_field_em_video.vid
853	WHERE (node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)) AND ((node_data_field_em_video.field_em_video_embed) LIKE (XXX))
854	) count_alias;
855	################################################################################
856	1 Queries
857	user: newstransition_0[newstransition_0]
858	url: localhost
859	ip: []
860	Taking 218102 seconds to complete
861	Locking for 0 seconds
862	Average time: 218102, Median time 218102
863	Average lock: 0, Median lock 0
864
865	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
866	SET timestamp=XXX;
867	SELECT tn.vid AS node_vid, td.*, v.name as vocabulary FROM term_data td INNER JOIN term_node tn ON td.tid = tn.tid INNER JOIN vocabulary v ON v.vid = td.vid WHERE tn.vid IN (XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX) AND td.vid IN (XXX) ORDER BY td.weight, td.name;
868	################################################################################
869	1 Queries
870	user: transitionnetw_0[transitionnetw_0]
871	url: localhost
872	ip: []
873	Taking 229852 seconds to complete
874	Locking for 0 seconds
875	Average time: 229852, Median time 229852
876	Average lock: 0, Median lock 0
877
878	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
879	use transitionnetw_XXX;
880	SET timestamp=XXX;
881	SELECT t.tid, t.* FROM term_data t WHERE t.name = XXX;
882	################################################################################
883	1 Queries
884	user: transitionnetw_0[transitionnetw_0]
885	url: localhost
886	ip: []
887	Taking 231122 seconds to complete
888	Locking for 0 seconds
889	Average time: 231122, Median time 231122
890	Average lock: 0, Median lock 0
891
892	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
893	SET timestamp=XXX;
894	SELECT n.nid FROM node n LEFT JOIN search_dataset d ON d.type = XXX AND d.sid = n.nid WHERE d.sid IS NULL OR d.reindex <> XXX ORDER BY d.reindex ASC, n.nid ASC LIMIT XXX, XXX;
895	################################################################################
896	1 Queries
897	user: transitionnetw_0[transitionnetw_0]
898	url: localhost
899	ip: []
900	Taking 229958 seconds to complete
901	Locking for 0 seconds
902	Average time: 229958, Median time 229958
903	Average lock: 0, Median lock 0
904
905	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
906	SET timestamp=XXX;
907	UPDATE notifications SET language = XXX WHERE uid = XXX;
908	################################################################################
909	1 Queries
910	user: transitionnetw_0[transitionnetw_0]
911	url: localhost
912	ip: []
913	Taking 210267 seconds to complete
914	Locking for 0 seconds
915	Average time: 210267, Median time 210267
916	Average lock: 0, Median lock 0
917
918	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
919	use transitionnetw_XXX;
920	SET timestamp=XXX;
921	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
922	FROM node node
923	INNER JOIN users users ON node.uid = users.uid
924	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( users.uid = XXX
925	)) count_alias;
926	################################################################################
927	1 Queries
928	user: newstransition_0[newstransition_0]
929	url: localhost
930	ip: []
931	Taking 208177 seconds to complete
932	Locking for 0 seconds
933	Average time: 208177, Median time 208177
934	Average lock: 0, Median lock 0
935
936	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
937	use newstransition_XXX;
938	SET timestamp=XXX;
939	SELECT COUNT(*) FROM (SELECT node.nid AS nid
940	FROM node node
941	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
942	LEFT JOIN location location ON location_instance.lid = location.lid
943	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
944	WHERE location.country = XXX
945	) count_alias;
946	################################################################################
947	1 Queries
948	user: transitionnetw_0[transitionnetw_0]
949	url: localhost
950	ip: []
951	Taking 226755 seconds to complete
952	Locking for 0 seconds
953	Average time: 226755, Median time 226755
954	Average lock: 0, Median lock 0
955
956	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
957	SET timestamp=XXX;
958	SELECT css_class, module, delta FROM block_class;
959	################################################################################
960	1 Queries
961	user: transitionnetw_0[transitionnetw_0]
962	url: localhost
963	ip: []
964	Taking 235798 seconds to complete
965	Locking for 0 seconds
966	Average time: 235798, Median time 235798
967	Average lock: 0, Median lock 0
968
969	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
970	SET timestamp=XXX;
971	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
972	node.sticky AS node_sticky,
973	node.created AS node_created
974	FROM node node
975	LEFT JOIN term_node term_node ON node.vid = term_node.vid
976	LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
977	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX, XXX, XXX)) AND (UPPER(term_data.name) = UPPER(XXX))
978	)GROUP BY nid
979	ORDER BY node_sticky DESC, node_created DESC
980	) count_alias;
981	################################################################################
982	1 Queries
983	user: transitionnetw_0[transitionnetw_0]
984	url: localhost
985	ip: []
986	Taking 208710 seconds to complete
987	Locking for 0 seconds
988	Average time: 208710, Median time 208710
989	Average lock: 0, Median lock 0
990
991	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
992	SET timestamp=XXX;
993	SELECT src, dst FROM url_alias WHERE src IN(XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX) AND (language = XXX OR language = '') ORDER BY language ASC;
994	################################################################################
995	1 Queries
996	user: masterpuffinwe_0[masterpuffinwe_0]
997	url: localhost
998	ip: []
999	Taking 219870 seconds to complete
1000	Locking for 0 seconds
1001	Average time: 219870, Median time 219870
1002	Average lock: 0, Median lock 0
1003
1004	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1005	use masterpuffinwe_XXX;
1006	SET timestamp=XXX;
1007	SELECT XXX FROM access WHERE type = XXX AND XXX LIKE mask AND status = XXX LIMIT XXX, XXX;
1008	################################################################################
1009	1 Queries
1010	user: transitionnetw_0[transitionnetw_0]
1011	url: localhost
1012	ip: []
1013	Taking 210773 seconds to complete
1014	Locking for 0 seconds
1015	Average time: 210773, Median time 210773
1016	Average lock: 0, Median lock 0
1017
1018	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1019	use transitionnetw_XXX;
1020	SET timestamp=XXX;
1021	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
1022	FROM node node
1023	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1024	LEFT JOIN location location ON location_instance.lid = location.lid
1025	LEFT JOIN content_type_project_profile node_data_field_project_summary ON node.vid = node_data_field_project_summary.vid
1026	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < XXX.XXX)
1027	)) count_alias;
1028	################################################################################
1029	1 Queries
1030	user: transitionnetw_0[transitionnetw_0]
1031	url: localhost
1032	ip: []
1033	Taking 231122 seconds to complete
1034	Locking for 0 seconds
1035	Average time: 231122, Median time 231122
1036	Average lock: 0, Median lock 0
1037
1038	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1039	SET timestamp=XXX;
1040	SELECT COUNT(*) FROM node_revisions r INNER JOIN node n ON r.nid = n.nid WHERE n.nid IN (SELECT r.nid FROM node_revisions r INNER JOIN node n ON r.nid = n.nid AND r.vid <> n.vid WHERE r.timestamp < XXX AND n.type IN(XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX) );
1041	################################################################################
1042	1 Queries
1043	user: transitionnetw_0[transitionnetw_0]
1044	url: localhost
1045	ip: []
1046	Taking 238884 seconds to complete
1047	Locking for 0 seconds
1048	Average time: 238884, Median time 238884
1049	Average lock: 0, Median lock 0
1050
1051	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1052	SET timestamp=XXX;
1053	SELECT * FROM backup_migrate_destinations;
1054	################################################################################
1055	1 Queries
1056	user: transitionnetw_0[transitionnetw_0]
1057	url: localhost
1058	ip: []
1059	Taking 225746 seconds to complete
1060	Locking for 0 seconds
1061	Average time: 225746, Median time 225746
1062	Average lock: 0, Median lock 0
1063
1064	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1065	SET timestamp=XXX;
1066	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
1067	FROM node node
1068	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1069	LEFT JOIN location location ON location_instance.lid = location.lid
1070	LEFT JOIN content_type_project_profile node_data_field_project_summary ON node.vid = node_data_field_project_summary.vid
1071	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < XXX.XXX)
1072	)) count_alias;
1073	################################################################################
1074	1 Queries
1075	user: transitionnetw_0[transitionnetw_0]
1076	url: localhost
1077	ip: []
1078	Taking 236525 seconds to complete
1079	Locking for 0 seconds
1080	Average time: 236525, Median time 236525
1081	Average lock: 0, Median lock 0
1082
1083	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1084	use transitionnetw_XXX;
1085	SET timestamp=XXX;
1086	SELECT COUNT(*) FROM node n INNER JOIN users u ON n.uid = u.uid;
1087	################################################################################
1088	1 Queries
1089	user: debian-sys-maint[debian-sys-maint]
1090	url: localhost
1091	ip: []
1092	Taking 219237 seconds to complete
1093	Locking for 0 seconds
1094	Average time: 219237, Median time 219237
1095	Average lock: 0, Median lock 0
1096
1097	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1098	SET timestamp=XXX;
1099	SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN (XXX,XXX) AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC;
1100	################################################################################
1101	1 Queries
1102	user: transitionnetw_0[transitionnetw_0]
1103	url: localhost
1104	ip: []
1105	Taking 229690 seconds to complete
1106	Locking for 0 seconds
1107	Average time: 229690, Median time 229690
1108	Average lock: 0, Median lock 0
1109
1110	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1111	SET timestamp=XXX;
1112	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
1113	FROM node node
1114	LEFT JOIN votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = XXX AND votingapi_cache_node_percent_vote_average.value_type = XXX AND votingapi_cache_node_percent_vote_average.tag = XXX AND votingapi_cache_node_percent_vote_average.function = XXX)
1115	LEFT JOIN content_type_resource node_data_field_asset_type ON node.vid = node_data_field_asset_type.vid
1116	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1117	LEFT JOIN location location ON location_instance.lid = location.lid
1118	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX))
1119	)) count_alias;
1120	################################################################################
1121	1 Queries
1122	user: newstransition_0[newstransition_0]
1123	url: localhost
1124	ip: []
1125	Taking 224853 seconds to complete
1126	Locking for 0 seconds
1127	Average time: 224853, Median time 224853
1128	Average lock: 0, Median lock 0
1129
1130	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1131	use newstransition_XXX;
1132	SET timestamp=XXX;
1133	SELECT node.nid AS nid,
1134	feeds_data_feed_fast.title AS feeds_data_feed_fast_title,
1135	feeds_data_feed_fast.timestamp AS feeds_data_feed_fast_timestamp,
1136	feeds_data_feed_fast.url AS feeds_data_feed_fast_url,
1137	feeds_data_feed_fast.description AS feeds_data_feed_fast_description,
1138	node.title AS node_title,
1139	node.vid AS node_vid,
1140	location.latitude AS location_latitude,
1141	location.longitude AS location_longitude
1142	FROM node node
1143	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
1144	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
1145	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
1146	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
1147	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
1148	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1149	LEFT JOIN location location ON location_instance.lid = location.lid
1150	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > XXX AND location.longitude < XXX)
1151	ORDER BY feeds_data_feed_fast_timestamp DESC
1152	LIMIT XXX, XXX;
1153	################################################################################
1154	1 Queries
1155	user: transitionnetw_0[transitionnetw_0]
1156	url: localhost
1157	ip: []
1158	Taking 225969 seconds to complete
1159	Locking for 0 seconds
1160	Average time: 225969, Median time 225969
1161	Average lock: 0, Median lock 0
1162
1163	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1164	use transitionnetw_XXX;
1165	SET timestamp=XXX;
1166	SELECT tid, COUNT(nid) AS topic_count, SUM(nid_comment_count) AS comment_count
1167	FROM (
1168	SELECT r.tid AS tid, n.nid AS nid, l.comment_count AS nid_comment_count
1169	FROM node n
1170	INNER JOIN node_comment_statistics l ON n.nid = l.nid
1171	INNER JOIN term_node r ON n.vid = r.vid
1172	INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( n.status = XXX
1173	)GROUP BY r.tid, n.nid, l.comment_count) AS forum_content_list
1174	GROUP BY tid;
1175	################################################################################
1176	1 Queries
1177	user: transitionnetw_0[transitionnetw_0]
1178	url: localhost
1179	ip: []
1180	Taking 226752 seconds to complete
1181	Locking for 0 seconds
1182	Average time: 226752, Median time 226752
1183	Average lock: 0, Median lock 0
1184
1185	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1186	SET timestamp=XXX;
1187	SELECT name, weight FROM page_manager_weights WHERE name IN (XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX, XXX);
1188	################################################################################
1189	1 Queries
1190	user: transitionnetw_0[transitionnetw_0]
1191	url: localhost
1192	ip: []
1193	Taking 214389 seconds to complete
1194	Locking for 0 seconds
1195	Average time: 214389, Median time 214389
1196	Average lock: 0, Median lock 0
1197
1198	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1199	SET timestamp=XXX;
1200	SELECT DISTINCT node.nid AS nid,
1201	node.title AS node_title,
1202	node.language AS node_language,
1203	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
1204	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
1205	node.type AS node_type,
1206	node.vid AS node_vid
1207	FROM node node
1208	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
1209	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
1210	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
1211	AND ((ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)) <= XXX AND ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)) >= XXX))
1212	)ORDER BY node_data_field_occurs_field_occurs_value ASC;
1213	################################################################################
1214	1 Queries
1215	user: transitionnetw_0[transitionnetw_0]
1216	url: localhost
1217	ip: []
1218	Taking 239563 seconds to complete
1219	Locking for 0 seconds
1220	Average time: 239563, Median time 239563
1221	Average lock: 0, Median lock 0
1222
1223	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1224	SET timestamp=XXX;
1225	SELECT n.nid FROM node n LEFT JOIN xmlsitemap x ON x.type = XXX AND n.nid = x.id WHERE x.id IS NULL AND n.type IN (XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX,XXX) ORDER BY n.nid DESC LIMIT XXX, XXX;
1226	################################################################################
1227	1 Queries
1228	user: transitionnetw_0[transitionnetw_0]
1229	url: localhost
1230	ip: []
1231	Taking 230260 seconds to complete
1232	Locking for 0 seconds
1233	Average time: 230260, Median time 230260
1234	Average lock: 0, Median lock 0
1235
1236	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1237	SET timestamp=XXX;
1238	SELECT COUNT() FROM (SELECT i.type, i.sid, XXX (XXX.XXX * SUM(i.score * t.count)) + XXX * POW(XXX, (GREATEST(MAX(n.created), MAX(n.changed), COALESCE(MAX(c.last_comment_timestamp), XXX)) - XXX) * XXX.XXXe-XXX) + XXX * (XXX.XXX - XXX.XXX / (XXX.XXX + MAX(c.comment_count) * XXX.XXX)) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE n.status = XXX AND (i.word = XXX) AND i.type = XXX GROUP BY i.type, i.sid HAVING COUNT(*) >= XXX) nXXX;
1239	################################################################################
1240	1 Queries
1241	user: transitionnetw_0[transitionnetw_0]
1242	url: localhost
1243	ip: []
1244	Taking 224582 seconds to complete
1245	Locking for 0 seconds
1246	Average time: 224582, Median time 224582
1247	Average lock: 0, Median lock 0
1248
1249	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1250	use transitionnetw_XXX;
1251	SET timestamp=XXX;
1252	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1253	node.title AS node_title,
1254	node.language AS node_language,
1255	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
1256	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
1257	node.type AS node_type,
1258	node.vid AS node_vid,
1259	location.lid AS location_lid
1260	FROM node node
1261	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
1262	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
1263	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1264	LEFT JOIN location location ON location_instance.lid = location.lid
1265	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
1266	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
1267	)GROUP BY nid
1268	ORDER BY node_data_field_occurs_field_occurs_value ASC
1269	) count_alias;
1270	################################################################################
1271	1 Queries
1272	user: transitionnetw_0[transitionnetw_0]
1273	url: localhost
1274	ip: []
1275	Taking 239563 seconds to complete
1276	Locking for 0 seconds
1277	Average time: 239563, Median time 239563
1278	Average lock: 0, Median lock 0
1279
1280	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1281	use transitionnetw_XXX;
1282	SET timestamp=XXX;
1283	SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (XXX,XXX,XXX,XXX);
1284	################################################################################
1285	1 Queries
1286	user: transitionnetw_0[transitionnetw_0]
1287	url: localhost
1288	ip: []
1289	Taking 225856 seconds to complete
1290	Locking for 0 seconds
1291	Average time: 225856, Median time 225856
1292	Average lock: 0, Median lock 0
1293
1294	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1295	use transitionnetw_XXX;
1296	SET timestamp=XXX;
1297	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1298	node.title AS node_title,
1299	node.language AS node_language,
1300	og.og_description AS og_og_description,
1301	users.name AS users_name,
1302	users.uid AS users_uid,
1303	node.changed AS node_changed,
1304	(SELECT COUNT(n.nid) FROM node n INNER JOIN og_ancestry oga ON n.nid = oga.nid WHERE n.status = XXX AND oga.group_nid = og.nid) AS post_count,
1305	og.nid AS og_nid,
1306	(SELECT COUNT(*) FROM og_uid ou INNER JOIN users u ON ou.uid = u.uid WHERE ou.nid = og_nid AND u.status > XXX AND ou.is_active >= XXX AND ou.is_admin >= XXX ) AS member_count,
1307	og.og_selective AS og_og_selective
1308	FROM node node
1309	LEFT JOIN og og ON node.nid = og.nid
1310	INNER JOIN users users ON node.uid = users.uid
1311	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (node.type IN (XXX)) AND (og.og_directory <> XXX)
1312	)GROUP BY nid
1313	ORDER BY node_title ASC
1314	) count_alias;
1315	################################################################################
1316	1 Queries
1317	user: tnpuffinwebarchn[tnpuffinwebarchn]
1318	url: localhost
1319	ip: []
1320	Taking 233181 seconds to complete
1321	Locking for 0 seconds
1322	Average time: 233181, Median time 233181
1323	Average lock: 0, Median lock 0
1324
1325	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1326	use tnpuffinwebarchn;
1327	SET timestamp=XXX;
1328	SELECT XXX FROM access WHERE type = XXX AND XXX LIKE mask AND status = XXX LIMIT XXX, XXX;
1329	################################################################################
1330	1 Queries
1331	user: transitionnetw_0[transitionnetw_0]
1332	url: localhost
1333	ip: []
1334	Taking 217405 seconds to complete
1335	Locking for 0 seconds
1336	Average time: 217405, Median time 217405
1337	Average lock: 0, Median lock 0
1338
1339	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1340	SET timestamp=XXX;
1341	SELECT COUNT(*) FROM (SELECT DISTINCT term_node.tid AS term_node_tid,
1342	term_data.name AS term_data_name,
1343	COUNT(node.nid) AS num_records
1344	FROM node node
1345	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
1346	INNER JOIN term_node term_node ON node.vid = term_node.vid
1347	LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
1348	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (og_ancestry.group_nid = XXX )
1349	)GROUP BY term_data_name, term_node_tid
1350	ORDER BY term_data_name ASC
1351	) count_alias;
1352	################################################################################
1353	1 Queries
1354	user: masterpuffinwe_0[masterpuffinwe_0]
1355	url: localhost
1356	ip: []
1357	Taking 231260 seconds to complete
1358	Locking for 0 seconds
1359	Average time: 231260, Median time 231260
1360	Average lock: 0, Median lock 0
1361
1362	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1363	use masterpuffinwe_XXX;
1364	SET timestamp=XXX;
1365	UPDATE variable SET value = XXX WHERE name = XXX;
1366	################################################################################
1367	1 Queries
1368	user: transitionnetw_0[transitionnetw_0]
1369	url: localhost
1370	ip: []
1371	Taking 220246 seconds to complete
1372	Locking for 0 seconds
1373	Average time: 220246, Median time 220246
1374	Average lock: 0, Median lock 0
1375
1376	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1377	use transitionnetw_XXX;
1378	SET timestamp=XXX;
1379	SELECT status, COUNT(*) AS num FROM notifications WHERE uid = XXX GROUP BY status;
1380	################################################################################
1381	1 Queries
1382	user: newstransition_0[newstransition_0]
1383	url: localhost
1384	ip: []
1385	Taking 215303 seconds to complete
1386	Locking for 0 seconds
1387	Average time: 215303, Median time 215303
1388	Average lock: 0, Median lock 0
1389
1390	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1391	use newstransition_XXX;
1392	SET timestamp=XXX;
1393	SELECT COUNT(*) FROM (SELECT node.nid AS nid
1394	FROM node node
1395	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
1396	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
1397	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
1398	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
1399	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
1400	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1401	LEFT JOIN location location ON location_instance.lid = location.lid
1402	WHERE term_node_value_XXX.tid = XXX
1403	) count_alias;
1404	################################################################################
1405	1 Queries
1406	user: newstransition_0[newstransition_0]
1407	url: localhost
1408	ip: []
1409	Taking 211611 seconds to complete
1410	Locking for 0 seconds
1411	Average time: 211611, Median time 211611
1412	Average lock: 0, Median lock 0
1413
1414	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1415	use newstransition_XXX;
1416	SET timestamp=XXX;
1417	SELECT COUNT(*) FROM (SELECT node.nid AS nid
1418	FROM node node
1419	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
1420	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
1421	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
1422	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
1423	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
1424	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1425	LEFT JOIN location location ON location_instance.lid = location.lid
1426	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > -XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < XXX.XXX)
1427	) count_alias;
1428	################################################################################
1429	2 Queries
1430	user: transitionnetw_0[transitionnetw_0]
1431	url: localhost
1432	ip: []
1433	Taking 219497 236723 seconds to complete
1434	Locking for 0 0 seconds
1435	Average time: 228110, Median time 236723
1436	Average lock: 0, Median lock 0
1437
1438	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1439	SET timestamp=XXX;
1440	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1441	node.title AS node_title,
1442	node.language AS node_language,
1443	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
1444	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
1445	node.type AS node_type,
1446	node.vid AS node_vid
1447	FROM node node
1448	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
1449	LEFT JOIN content_field_stage node_data_field_stage ON node.vid = node_data_field_stage.vid
1450	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_stage.field_stage_nid = XXX ))
1451	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
1452	)GROUP BY nid
1453	ORDER BY node_data_field_occurs_field_occurs_value ASC
1454	) count_alias;
1455	################################################################################
1456	2 Queries
1457	user: transitionnetw_0[transitionnetw_0]
1458	url: localhost
1459	ip: []
1460	Taking 206902 229238 seconds to complete
1461	Locking for 0 0 seconds
1462	Average time: 218070, Median time 229238
1463	Average lock: 0, Median lock 0
1464
1465	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1466	use transitionnetw_XXX;
1467	SET timestamp=XXX;
1468	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1469	node.title AS node_title,
1470	node.language AS node_language,
1471	location.province AS location_province,
1472	location.country AS location_country,
1473	node_data_field_status.field_status_value AS node_data_field_status_field_status_value,
1474	node.type AS node_type,
1475	node.vid AS node_vid
1476	FROM node node
1477	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1478	LEFT JOIN location location ON location_instance.lid = location.lid
1479	LEFT JOIN content_type_initiative_profile node_data_field_status ON node.vid = node_data_field_status.vid
1480	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX, XXX)) AND (node.status = XXX) AND (location.country = XXX)
1481	)GROUP BY nid
1482	ORDER BY node_title ASC
1483	) count_alias;
1484	################################################################################
1485	2 Queries
1486	user: spacetransitionn[spacetransitionn]
1487	url: localhost
1488	ip: []
1489	Taking 218184 224085 seconds to complete
1490	Locking for 0 0 seconds
1491	Average time: 221134, Median time 224085
1492	Average lock: 0, Median lock 0
1493
1494	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1495	SET timestamp=XXX;
1496	DELETE FROM batch
1497	WHERE (timestamp < XXX);
1498	################################################################################
1499	2 Queries
1500	user: spacetransitionn[spacetransitionn]
1501	url: localhost
1502	ip: []
1503	Taking 232467 232993 seconds to complete
1504	Locking for 0 0 seconds
1505	Average time: 232730, Median time 232993
1506	Average lock: 0, Median lock 0
1507
1508	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1509	use spacetransitionn;
1510	SET timestamp=XXX;
1511	SELECT rules_dependencies.id AS id, rules_dependencies.module AS module
1512	FROM
1513	rules_dependencies rules_dependencies
1514	WHERE (id IN (XXX, XXX, XXX));
1515	################################################################################
1516	2 Queries
1517	user: transitionnetw_0[transitionnetw_0]
1518	url: localhost
1519	ip: []
1520	Taking 208057 235592 seconds to complete
1521	Locking for 0 0 seconds
1522	Average time: 221824, Median time 235592
1523	Average lock: 0, Median lock 0
1524
1525	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1526	use transitionnetw_XXX;
1527	SET timestamp=XXX;
1528	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1529	node.title AS node_title,
1530	node.language AS node_language,
1531	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
1532	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
1533	node.type AS node_type,
1534	node.vid AS node_vid,
1535	location.lid AS location_lid
1536	FROM node node
1537	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
1538	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1539	LEFT JOIN location location ON location_instance.lid = location.lid
1540	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX)))
1541	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
1542	)GROUP BY nid
1543	ORDER BY node_data_field_occurs_field_occurs_value ASC
1544	) count_alias;
1545	################################################################################
1546	2 Queries
1547	user: masterpuffinwe_0[masterpuffinwe_0]
1548	url: localhost
1549	ip: []
1550	Taking 223068 234877 seconds to complete
1551	Locking for 0 0 seconds
1552	Average time: 228972, Median time 234877
1553	Average lock: 0, Median lock 0
1554
1555	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1556	SET timestamp=XXX;
1557	UPDATE hosting_site SET last_cron=XXX WHERE nid=XXX;
1558	################################################################################
1559	2 Queries
1560	user: transitionnetw_0[transitionnetw_0]
1561	url: localhost
1562	ip: []
1563	Taking 231122 239563 seconds to complete
1564	Locking for 0 0 seconds
1565	Average time: 235342, Median time 239563
1566	Average lock: 0, Median lock 0
1567
1568	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1569	SET timestamp=XXX;
1570	DELETE FROM flood WHERE timestamp < XXX;
1571	################################################################################
1572	2 Queries
1573	user: transitionnetw_0[transitionnetw_0]
1574	url: localhost
1575	ip: []
1576	Taking 232924 240148 seconds to complete
1577	Locking for 0 0 seconds
1578	Average time: 236536, Median time 240148
1579	Average lock: 0, Median lock 0
1580
1581	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1582	SET timestamp=XXX;
1583	INSERT INTO notifications_queue (uid, mdid, send_method, sid, module, eid, send_interval, language, cron, created, conditions) SELECT DISTINCT s.uid, s.mdid, s.send_method, s.sid, s.module, XXX, s.send_interval, s.language, s.cron, XXX, s.conditions FROM notifications s LEFT JOIN notifications_fields f ON s.sid = f.sid WHERE (s.status = XXX) AND (s.event_type = XXX) AND (s.send_interval >= XXX) AND (s.uid <> XXX) AND ((f.field = XXX AND f.intval = XXX) OR (f.field = XXX AND f.value = XXX) OR (f.field = XXX AND f.intval = XXX)) GROUP BY s.uid, s.mdid, s.send_method, s.sid, s.module, s.send_interval, s.cron, s.conditions, s.language HAVING s.conditions = count(f.sid);
1584	################################################################################
1585	2 Queries
1586	user: newstransition_0[newstransition_0]
1587	url: localhost
1588	ip: []
1589	Taking 230917 237474 seconds to complete
1590	Locking for 0 0 seconds
1591	Average time: 234195, Median time 237474
1592	Average lock: 0, Median lock 0
1593
1594	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1595	use newstransition_XXX;
1596	SET timestamp=XXX;
1597	SELECT * FROM job_schedule WHERE scheduled = XXX AND next < XXX ORDER BY next ASC LIMIT XXX, XXX;
1598	################################################################################
1599	2 Queries
1600	user: transitionnetw_0[transitionnetw_0]
1601	url: localhost
1602	ip: []
1603	Taking 236588 241532 seconds to complete
1604	Locking for 0 0 seconds
1605	Average time: 239060, Median time 241532
1606	Average lock: 0, Median lock 0
1607
1608	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1609	SET timestamp=XXX;
1610	DELETE FROM nodehierarchy WHERE nid = XXX OR parent = XXX;
1611	################################################################################
1612	2 Queries
1613	user: transitionnetw_0[transitionnetw_0]
1614	url: localhost
1615	ip: []
1616	Taking 233276 235209 seconds to complete
1617	Locking for 0 0 seconds
1618	Average time: 234242, Median time 235209
1619	Average lock: 0, Median lock 0
1620
1621	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1622	SET timestamp=XXX;
1623	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
1624	FROM node node
1625	INNER JOIN users users ON node.uid = users.uid
1626	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( users.uid = XXX
1627	)) count_alias;
1628	################################################################################
1629	2 Queries
1630	user: transitionnetw_0[transitionnetw_0]
1631	url: localhost
1632	ip: []
1633	Taking 214871 215473 seconds to complete
1634	Locking for 0 0 seconds
1635	Average time: 215172, Median time 215473
1636	Average lock: 0, Median lock 0
1637
1638	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1639	use transitionnetw_XXX;
1640	SET timestamp=XXX;
1641	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1642	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value
1643	FROM node node
1644	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
1645	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
1646	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX ))
1647	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
1648	)GROUP BY nid
1649	ORDER BY node_data_field_occurs_field_occurs_value DESC
1650	) count_alias;
1651	################################################################################
1652	2 Queries
1653	user: transitionnetw_0[transitionnetw_0]
1654	url: localhost
1655	ip: []
1656	Taking 206140 223966 seconds to complete
1657	Locking for 0 0 seconds
1658	Average time: 215053, Median time 223966
1659	Average lock: 0, Median lock 0
1660
1661	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1662	SET timestamp=XXX;
1663	SELECT * FROM aggregator_feed WHERE checked + refresh < XXX;
1664	################################################################################
1665	2 Queries
1666	user: newstransition_0[newstransition_0]
1667	url: localhost
1668	ip: []
1669	Taking 218296 231020 seconds to complete
1670	Locking for 0 0 seconds
1671	Average time: 224658, Median time 231020
1672	Average lock: 0, Median lock 0
1673
1674	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1675	use newstransition_XXX;
1676	SET timestamp=XXX;
1677	SELECT t.*,v.weight AS v_weight_unused FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = XXX ORDER BY v.weight, t.weight, t.name;
1678	################################################################################
1679	2 Queries
1680	user: transitionnetw_0[transitionnetw_0]
1681	url: localhost
1682	ip: []
1683	Taking 205759 223186 seconds to complete
1684	Locking for 0 0 seconds
1685	Average time: 214472, Median time 223186
1686	Average lock: 0, Median lock 0
1687
1688	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1689	use transitionnetw_XXX;
1690	SET timestamp=XXX;
1691	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
1692	FROM node node
1693	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
1694	INNER JOIN term_node term_node ON node.vid = term_node.vid
1695	LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
1696	INNER JOIN users users ON node.uid = users.uid
1697	INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
1698	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (og_ancestry.group_nid = XXX ) AND (term_node.tid = XXX)
1699	)) count_alias;
1700	################################################################################
1701	2 Queries
1702	user: spacetransitionn[spacetransitionn]
1703	url: localhost
1704	ip: []
1705	Taking 206246 232993 seconds to complete
1706	Locking for 0 0 seconds
1707	Average time: 219619, Median time 232993
1708	Average lock: 0, Median lock 0
1709
1710	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1711	use spacetransitionn;
1712	SET timestamp=XXX;
1713	SELECT t.*
1714	FROM
1715	field_data_message_text t
1716	WHERE (entity_type = XXX) AND (entity_id IN (XXX, XXX, XXX, XXX, XXX, XXX)) AND (language IN (XXX)) AND (deleted = XXX)
1717	ORDER BY delta ASC;
1718	################################################################################
1719	2 Queries
1720	user: transitionnetw_0[transitionnetw_0]
1721	url: localhost
1722	ip: []
1723	Taking 225372 228539 seconds to complete
1724	Locking for 0 0 seconds
1725	Average time: 226955, Median time 228539
1726	Average lock: 0, Median lock 0
1727
1728	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1729	SET timestamp=XXX;
1730	SELECT count(field_image_fid)
1731	FROM content_field_image
1732	WHERE field_image_fid = XXX;
1733	################################################################################
1734	2 Queries
1735	user: transitionnetw_0[transitionnetw_0]
1736	url: localhost
1737	ip: []
1738	Taking 233205 239441 seconds to complete
1739	Locking for 0 0 seconds
1740	Average time: 236323, Median time 239441
1741	Average lock: 0, Median lock 0
1742
1743	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1744	SET timestamp=XXX;
1745	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1746	node.sticky AS node_sticky,
1747	node.created AS node_created
1748	FROM node node
1749	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX, XXX))
1750	)GROUP BY nid
1751	ORDER BY node_sticky DESC, node_created DESC
1752	) count_alias;
1753	################################################################################
1754	2 Queries
1755	user: transitionnetw_0[transitionnetw_0]
1756	url: localhost
1757	ip: []
1758	Taking 218065 239563 seconds to complete
1759	Locking for 0 0 seconds
1760	Average time: 228814, Median time 239563
1761	Average lock: 0, Median lock 0
1762
1763	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1764	use transitionnetw_XXX;
1765	SET timestamp=XXX;
1766	SELECT DISTINCT s.* FROM notifications s INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid WHERE (s.mdid = XXX) AND (s.type = XXX) AND (s.event_type = XXX) AND (s.module = XXX) AND (s.send_interval = XXX) AND (s.conditions = XXX) AND ((fXXX.field = XXX AND fXXX.intval = XXX) AND (fXXX.field = XXX AND fXXX.value = XXX));
1767	################################################################################
1768	2 Queries
1769	user: transitionnetw_0[transitionnetw_0]
1770	url: localhost
1771	ip: []
1772	Taking 229120 239639 seconds to complete
1773	Locking for 0 0 seconds
1774	Average time: 234379, Median time 239639
1775	Average lock: 0, Median lock 0
1776
1777	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1778	use transitionnetw_XXX;
1779	SET timestamp=XXX;
1780	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1781	node.sticky AS node_sticky,
1782	node.created AS node_created
1783	FROM node node
1784	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX, XXX))
1785	)GROUP BY nid
1786	ORDER BY node_sticky DESC, node_created DESC
1787	) count_alias;
1788	################################################################################
1789	2 Queries
1790	user: transitionnetw_0[transitionnetw_0]
1791	url: localhost
1792	ip: []
1793	Taking 213202 226313 seconds to complete
1794	Locking for 0 0 seconds
1795	Average time: 219757, Median time 226313
1796	Average lock: 0, Median lock 0
1797
1798	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1799	SET timestamp=XXX;
1800	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1801	node.title AS node_title,
1802	node.language AS node_language,
1803	node.changed AS node_changed
1804	FROM node node
1805	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
1806	WHERE (node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX )
1807	GROUP BY nid
1808	ORDER BY node_changed DESC
1809	) count_alias;
1810	################################################################################
1811	2 Queries
1812	user: transitionnetw_0[transitionnetw_0]
1813	url: localhost
1814	ip: []
1815	Taking 237648 240694 seconds to complete
1816	Locking for 0 0 seconds
1817	Average time: 239171, Median time 240694
1818	Average lock: 0, Median lock 0
1819
1820	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1821	use transitionnetw_XXX;
1822	SET timestamp=XXX;
1823	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1824	node.title AS node_title,
1825	node.language AS node_language
1826	FROM node node
1827	LEFT JOIN content_type_profile node_data_field_user_location ON node.vid = node_data_field_user_location.vid
1828	LEFT JOIN location location_node_data_field_user_location ON node_data_field_user_location.field_user_location_lid = location_node_data_field_user_location.lid
1829	INNER JOIN content_field_roles_offered node_data_field_roles_offered ON node.vid = node_data_field_roles_offered.vid
1830	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node.status = XXX) AND (node_data_field_roles_offered.field_roles_offered_value = XXX)
1831	)GROUP BY nid
1832	ORDER BY node_title ASC
1833	) count_alias;
1834	################################################################################
1835	2 Queries
1836	user: transitionnetw_0[transitionnetw_0]
1837	url: localhost
1838	ip: []
1839	Taking 229452 232470 seconds to complete
1840	Locking for 0 0 seconds
1841	Average time: 230961, Median time 232470
1842	Average lock: 0, Median lock 0
1843
1844	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1845	use transitionnetw_XXX;
1846	SET timestamp=XXX;
1847	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1848	node.title AS node_title,
1849	node.language AS node_language,
1850	location.province AS location_province,
1851	location.country AS location_country,
1852	node.changed AS node_changed
1853	FROM node node
1854	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1855	LEFT JOIN location location ON location_instance.lid = location.lid
1856	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node.status = XXX)
1857	)GROUP BY nid
1858	ORDER BY node_changed ASC
1859	) count_alias;
1860	################################################################################
1861	2 Queries
1862	user: transitionnetw_0[transitionnetw_0]
1863	url: localhost
1864	ip: []
1865	Taking 207761 233037 seconds to complete
1866	Locking for 0 0 seconds
1867	Average time: 220399, Median time 233037
1868	Average lock: 0, Median lock 0
1869
1870	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1871	SET timestamp=XXX;
1872	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
1873	node.title AS node_title,
1874	node.language AS node_language,
1875	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
1876	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
1877	node.type AS node_type,
1878	node.vid AS node_vid
1879	FROM node node
1880	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
1881	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
1882	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX ))
1883	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
1884	)GROUP BY nid
1885	ORDER BY node_data_field_occurs_field_occurs_value ASC
1886	) count_alias;
1887	################################################################################
1888	2 Queries
1889	user: newstransition_0[newstransition_0]
1890	url: localhost
1891	ip: []
1892	Taking 233486 235427 seconds to complete
1893	Locking for 0 0 seconds
1894	Average time: 234456, Median time 235427
1895	Average lock: 0, Median lock 0
1896
1897	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1898	SET timestamp=XXX;
1899	SELECT * FROM job_schedule WHERE scheduled = XXX AND next < XXX ORDER BY next ASC LIMIT XXX, XXX;
1900	################################################################################
1901	2 Queries
1902	user: transitionnetw_0[transitionnetw_0]
1903	url: localhost
1904	ip: []
1905	Taking 238884 239054 seconds to complete
1906	Locking for 0 0 seconds
1907	Average time: 238969, Median time 239054
1908	Average lock: 0, Median lock 0
1909
1910	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1911	SET timestamp=XXX;
1912	SELECT filename, name, type, status, throttle, schema_version FROM system WHERE type = XXX;
1913	################################################################################
1914	2 Queries
1915	user: transitionnetw_0[transitionnetw_0]
1916	url: localhost
1917	ip: []
1918	Taking 217571 239856 seconds to complete
1919	Locking for 0 0 seconds
1920	Average time: 228713, Median time 239856
1921	Average lock: 0, Median lock 0
1922
1923	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1924	use transitionnetw_XXX;
1925	SET timestamp=XXX;
1926	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
1927	FROM node node
1928	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
1929	LEFT JOIN location location ON location_instance.lid = location.lid
1930	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < -XXX.XXX)
1931	)) count_alias;
1932	################################################################################
1933	2 Queries
1934	user: transitionnetw_0[transitionnetw_0]
1935	url: localhost
1936	ip: []
1937	Taking 228301 230921 seconds to complete
1938	Locking for 0 0 seconds
1939	Average time: 229611, Median time 230921
1940	Average lock: 0, Median lock 0
1941
1942	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1943	SET timestamp=XXX;
1944	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
1945	FROM node node
1946	INNER JOIN users users ON node.uid = users.uid
1947	WHERE users.uid = XXX
1948	) count_alias;
1949	################################################################################
1950	2 Queries
1951	user: transitionnetw_0[transitionnetw_0]
1952	url: localhost
1953	ip: []
1954	Taking 212564 215953 seconds to complete
1955	Locking for 0 0 seconds
1956	Average time: 214258, Median time 215953
1957	Average lock: 0, Median lock 0
1958
1959	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1960	SET timestamp=XXX;
1961	SELECT DISTINCT node.nid AS nid,
1962	node.title AS node_title,
1963	node.language AS node_language,
1964	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
1965	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
1966	node.type AS node_type,
1967	node.vid AS node_vid
1968	FROM node node
1969	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
1970	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX)))
1971	AND ((ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)) <= XXX AND ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)) >= XXX))
1972	);
1973	################################################################################
1974	2 Queries
1975	user: root[root]
1976	url: localhost
1977	ip: []
1978	Taking 219383 219423 seconds to complete
1979	Locking for 0 0 seconds
1980	Average time: 219403, Median time 219423
1981	Average lock: 0, Median lock 0
1982
1983	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1984	SET timestamp=XXX;
1985	/!XXX SELECT IFNULL(SUM(INDEX_LENGTH),XXX) from information_schema.TABLES where ENGINE=XXX /;
1986	################################################################################
1987	2 Queries
1988	user: transitionnetw_0[transitionnetw_0]
1989	url: localhost
1990	ip: []
1991	Taking 238895 239138 seconds to complete
1992	Locking for 0 0 seconds
1993	Average time: 239016, Median time 239138
1994	Average lock: 0, Median lock 0
1995
1996	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
1997	SET timestamp=XXX;
1998	SELECT name, weight FROM system WHERE name IN (XXX,XXX,XXX,XXX) AND status = XXX ORDER BY weight ASC;
1999	################################################################################
2000	2 Queries
2001	user: transitionnetw_0[transitionnetw_0]
2002	url: localhost
2003	ip: []
2004	Taking 230274 233411 seconds to complete
2005	Locking for 0 0 seconds
2006	Average time: 231842, Median time 233411
2007	Average lock: 0, Median lock 0
2008
2009	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2010	SET timestamp=XXX;
2011	SELECT COUNT() FROM (SELECT i.type, i.sid, XXX (XXX.XXX * SUM(i.score * t.count)) + XXX * POW(XXX, (GREATEST(MAX(n.created), MAX(n.changed), COALESCE(MAX(c.last_comment_timestamp), XXX)) - XXX) * XXX.XXXe-XXX) + XXX * (XXX.XXX - XXX.XXX / (XXX.XXX + MAX(c.comment_count) * XXX.XXX)) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid INNER JOIN node_access na ON na.nid = n.nid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE n.status = XXX AND (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND (i.word = XXX) AND i.type = XXX GROUP BY i.type, i.sid HAVING COUNT(*) >= XXX) nXXX;
2012	################################################################################
2013	2 Queries
2014	user: transitionnetw_0[transitionnetw_0]
2015	url: localhost
2016	ip: []
2017	Taking 231122 231122 seconds to complete
2018	Locking for 0 0 seconds
2019	Average time: 231122, Median time 231122
2020	Average lock: 0, Median lock 0
2021
2022	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2023	SET timestamp=XXX;
2024	UPDATE search_total SET count = XXX.XXX WHERE word = XXX;
2025	################################################################################
2026	2 Queries
2027	user: transitionnetw_0[transitionnetw_0]
2028	url: localhost
2029	ip: []
2030	Taking 239461 239565 seconds to complete
2031	Locking for 0 0 seconds
2032	Average time: 239513, Median time 239565
2033	Average lock: 0, Median lock 0
2034
2035	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2036	SET timestamp=XXX;
2037	SELECT DISTINCT node.nid AS nid,
2038	node.title AS node_title,
2039	node.language AS node_language,
2040	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2041	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2042	node.type AS node_type,
2043	node.vid AS node_vid
2044	FROM node node
2045	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
2046	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2047	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
2048	AND ((ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)) <= XXX AND ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)) >= XXX))
2049	);
2050	################################################################################
2051	2 Queries
2052	user: transitionnetw_0[transitionnetw_0]
2053	url: localhost
2054	ip: []
2055	Taking 241534 241628 seconds to complete
2056	Locking for 0 0 seconds
2057	Average time: 241581, Median time 241628
2058	Average lock: 0, Median lock 0
2059
2060	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2061	SET timestamp=XXX;
2062	SELECT DISTINCT n.*, u.name FROM node n INNER JOIN users u ON n.uid = u.uid ORDER BY n.changed DESC LIMIT XXX, XXX;
2063	################################################################################
2064	2 Queries
2065	user: transitionnetw_0[transitionnetw_0]
2066	url: localhost
2067	ip: []
2068	Taking 224814 238310 seconds to complete
2069	Locking for 0 0 seconds
2070	Average time: 231562, Median time 238310
2071	Average lock: 0, Median lock 0
2072
2073	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2074	use transitionnetw_XXX;
2075	SET timestamp=XXX;
2076	SELECT DISTINCT node.nid AS nid,
2077	XXX AS location_distance,
2078	node.title AS node_title,
2079	node.language AS node_language,
2080	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2081	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2082	node.type AS node_type,
2083	node.vid AS node_vid
2084	FROM node node
2085	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2086	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2087	LEFT JOIN location location ON location_instance.lid = location.lid
2088	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.type in (XXX, XXX, XXX, XXX)) AND (node.status = XXX))
2089	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
2090	)ORDER BY node_data_field_occurs_field_occurs_value ASC
2091	LIMIT XXX, XXX;
2092	################################################################################
2093	2 Queries
2094	user: transitionnetw_0[transitionnetw_0]
2095	url: localhost
2096	ip: []
2097	Taking 236582 241530 seconds to complete
2098	Locking for 0 0 seconds
2099	Average time: 239056, Median time 241530
2100	Average lock: 0, Median lock 0
2101
2102	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2103	SET timestamp=XXX;
2104	SELECT count(nid) as children_count FROM nodehierarchy h WHERE h.parent = XXX;
2105	################################################################################
2106	2 Queries
2107	user: newstransition_0[newstransition_0]
2108	url: localhost
2109	ip: []
2110	Taking 209942 216503 seconds to complete
2111	Locking for 0 0 seconds
2112	Average time: 213222, Median time 216503
2113	Average lock: 0, Median lock 0
2114
2115	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2116	SET timestamp=XXX;
2117	SELECT COUNT(*) FROM (SELECT node.nid AS nid
2118	FROM node node
2119	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
2120	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
2121	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
2122	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
2123	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
2124	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2125	LEFT JOIN location location ON location_instance.lid = location.lid
2126	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > -XXX.XXX AND location.latitude < -XXX.XXX AND location.longitude > XXX.XXX AND location.longitude < XXX.XXX)
2127	) count_alias;
2128	################################################################################
2129	2 Queries
2130	user: tnpuffinwebarchn[tnpuffinwebarchn]
2131	url: localhost
2132	ip: []
2133	Taking 206495 222087 seconds to complete
2134	Locking for 0 0 seconds
2135	Average time: 214291, Median time 222087
2136	Average lock: 0, Median lock 0
2137
2138	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2139	use tnpuffinwebarchn;
2140	SET timestamp=XXX;
2141	SELECT n.nid, hs.last_cron, hac.cron_interval FROM node n LEFT JOIN hosting_site hs ON n.nid = hs.nid LEFT JOIN hosting_advanced_cron hac ON n.nid = hac.nid WHERE n.type = XXX AND hs.status = XXX ORDER BY hs.last_cron ASC, n.nid ASC;
2142	################################################################################
2143	2 Queries
2144	user: transitionnetw_0[transitionnetw_0]
2145	url: localhost
2146	ip: []
2147	Taking 220149 234112 seconds to complete
2148	Locking for 0 0 seconds
2149	Average time: 227130, Median time 234112
2150	Average lock: 0, Median lock 0
2151
2152	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2153	SET timestamp=XXX;
2154	SELECT vid, nid, field_bios_fid AS fid, field_bios_list AS list, field_bios_data AS data
2155	FROM content_field_bios
2156	WHERE field_bios_fid = XXX;
2157	################################################################################
2158	2 Queries
2159	user: spacetransitionn[spacetransitionn]
2160	url: localhost
2161	ip: []
2162	Taking 212639 224085 seconds to complete
2163	Locking for 0 0 seconds
2164	Average time: 218362, Median time 224085
2165	Average lock: 0, Median lock 0
2166
2167	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2168	use spacetransitionn;
2169	SET timestamp=XXX;
2170	SELECT data, item_id FROM queue q WHERE expire = XXX AND name = XXX ORDER BY created ASC LIMIT XXX, XXX;
2171	################################################################################
2172	2 Queries
2173	user: transitionnetw_0[transitionnetw_0]
2174	url: localhost
2175	ip: []
2176	Taking 231293 236773 seconds to complete
2177	Locking for 0 0 seconds
2178	Average time: 234033, Median time 236773
2179	Average lock: 0, Median lock 0
2180
2181	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2182	use transitionnetw_XXX;
2183	SET timestamp=XXX;
2184	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2185	node.sticky AS node_sticky,
2186	node.created AS node_created
2187	FROM node node
2188	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX))
2189	)GROUP BY nid
2190	ORDER BY node_sticky DESC, node_created DESC
2191	) count_alias;
2192	################################################################################
2193	2 Queries
2194	user: transitionnetw_0[transitionnetw_0]
2195	url: localhost
2196	ip: []
2197	Taking 226752 231215 seconds to complete
2198	Locking for 0 0 seconds
2199	Average time: 228983, Median time 231215
2200	Average lock: 0, Median lock 0
2201
2202	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2203	SET timestamp=XXX;
2204	SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid ORDER BY v.weight, v.name;
2205	################################################################################
2206	2 Queries
2207	user: transitionnetw_0[transitionnetw_0]
2208	url: localhost
2209	ip: []
2210	Taking 231122 239563 seconds to complete
2211	Locking for 0 0 seconds
2212	Average time: 235342, Median time 239563
2213	Average lock: 0, Median lock 0
2214
2215	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2216	SET timestamp=XXX;
2217	SELECT n.title, n.nid FROM webform w LEFT JOIN node n ON w.nid = n.nid WHERE w.block = XXX AND n.type IN (XXX);
2218	################################################################################
2219	2 Queries
2220	user: transitionnetw_0[transitionnetw_0]
2221	url: localhost
2222	ip: []
2223	Taking 234263 237566 seconds to complete
2224	Locking for 0 0 seconds
2225	Average time: 235914, Median time 237566
2226	Average lock: 0, Median lock 0
2227
2228	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2229	use transitionnetw_XXX;
2230	SET timestamp=XXX;
2231	SELECT COUNT() FROM (SELECT i.type, i.sid, XXX (XXX.XXX * SUM(i.score * t.count)) + XXX * POW(XXX, (GREATEST(MAX(n.created), MAX(n.changed), COALESCE(MAX(c.last_comment_timestamp), XXX)) - XXX) * XXX.XXXe-XXX) + XXX * (XXX.XXX - XXX.XXX / (XXX.XXX + MAX(c.comment_count) * XXX.XXX)) AS score FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid INNER JOIN node_access na ON na.nid = n.nid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE n.status = XXX AND (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND (i.word = XXX) AND i.type = XXX GROUP BY i.type, i.sid HAVING COUNT(*) >= XXX) nXXX;
2232	################################################################################
2233	2 Queries
2234	user: transitionnetw_0[transitionnetw_0]
2235	url: localhost
2236	ip: []
2237	Taking 227456 235034 seconds to complete
2238	Locking for 0 0 seconds
2239	Average time: 231245, Median time 235034
2240	Average lock: 0, Median lock 0
2241
2242	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2243	SET timestamp=XXX;
2244	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
2245	FROM node node
2246	LEFT JOIN content_field_em_video node_data_field_em_video ON node.vid = node_data_field_em_video.vid
2247	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)) AND ((node_data_field_em_video.field_em_video_embed) LIKE (XXX))
2248	)) count_alias;
2249	################################################################################
2250	2 Queries
2251	user: transitionnetw_0[transitionnetw_0]
2252	url: localhost
2253	ip: []
2254	Taking 228029 232767 seconds to complete
2255	Locking for 0 0 seconds
2256	Average time: 230398, Median time 232767
2257	Average lock: 0, Median lock 0
2258
2259	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2260	use transitionnetw_XXX;
2261	SET timestamp=XXX;
2262	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
2263	FROM node node
2264	LEFT JOIN og_uid og_uid ON node.nid = og_uid.nid
2265	LEFT JOIN og og ON node.nid = og.nid
2266	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type IN (XXX)) AND (og_uid.uid = XXX)
2267	)) count_alias;
2268	################################################################################
2269	2 Queries
2270	user: transitionnetw_0[transitionnetw_0]
2271	url: localhost
2272	ip: []
2273	Taking 224365 226395 seconds to complete
2274	Locking for 0 0 seconds
2275	Average time: 225380, Median time 226395
2276	Average lock: 0, Median lock 0
2277
2278	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2279	use transitionnetw_XXX;
2280	SET timestamp=XXX;
2281	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2282	node.title AS node_title,
2283	node.language AS node_language,
2284	node.changed AS node_changed
2285	FROM node node
2286	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
2287	WHERE (node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX )
2288	GROUP BY nid
2289	ORDER BY node_changed DESC
2290	) count_alias;
2291	################################################################################
2292	2 Queries
2293	user: transitionnetw_0[transitionnetw_0]
2294	url: localhost
2295	ip: []
2296	Taking 224526 233608 seconds to complete
2297	Locking for 0 0 seconds
2298	Average time: 229067, Median time 233608
2299	Average lock: 0, Median lock 0
2300
2301	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2302	SET timestamp=XXX;
2303	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
2304	FROM node node
2305	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2306	LEFT JOIN location location ON location_instance.lid = location.lid
2307	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < -XXX.XXX)
2308	)) count_alias;
2309	################################################################################
2310	2 Queries
2311	user: transitionnetw_0[transitionnetw_0]
2312	url: localhost
2313	ip: []
2314	Taking 226151 235278 seconds to complete
2315	Locking for 0 0 seconds
2316	Average time: 230714, Median time 235278
2317	Average lock: 0, Median lock 0
2318
2319	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2320	SET timestamp=XXX;
2321	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2322	node_data_field_initnumber.field_initnumber_value AS node_data_field_initnumber_field_initnumber_value,
2323	node.language AS node_language,
2324	node.type AS node_type,
2325	node.vid AS node_vid,
2326	node.title AS node_title,
2327	location.province AS location_province,
2328	location.country AS location_country
2329	FROM node node
2330	INNER JOIN content_type_initiative_profile node_data_field_status ON node.vid = node_data_field_status.vid
2331	LEFT JOIN content_type_initiative_profile node_data_field_initnumber ON node.vid = node_data_field_initnumber.vid
2332	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2333	LEFT JOIN location location ON location_instance.lid = location.lid
2334	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node.status = XXX) AND (node_data_field_status.field_status_value = XXX)
2335	)GROUP BY nid
2336	ORDER BY node_data_field_initnumber_field_initnumber_value ASC
2337	) count_alias;
2338	################################################################################
2339	2 Queries
2340	user: transitionnetw_0[transitionnetw_0]
2341	url: localhost
2342	ip: []
2343	Taking 213219 213273 seconds to complete
2344	Locking for 0 0 seconds
2345	Average time: 213246, Median time 213273
2346	Average lock: 0, Median lock 0
2347
2348	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2349	use transitionnetw_XXX;
2350	SET timestamp=XXX;
2351	SELECT DISTINCT node.nid AS nid,
2352	node.title AS node_title,
2353	node.language AS node_language,
2354	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2355	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2356	node.type AS node_type,
2357	node.vid AS node_vid
2358	FROM node node
2359	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2360	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX)))
2361	AND ((ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)) <= XXX AND ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)) >= XXX))
2362	);
2363	################################################################################
2364	3 Queries
2365	user: transitionnetw_0[transitionnetw_0]
2366	url: localhost
2367	ip: []
2368	Taking 236797 240053 240146 seconds to complete
2369	Locking for 0 0 0 seconds
2370	Average time: 238998, Median time 240053
2371	Average lock: 0, Median lock 0
2372
2373	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2374	use transitionnetw_XXX;
2375	SET timestamp=XXX;
2376	SELECT DISTINCT node.nid AS nid,
2377	node.title AS node_title,
2378	node.language AS node_language,
2379	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2380	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2381	node.type AS node_type,
2382	node.vid AS node_vid
2383	FROM node node
2384	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
2385	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2386	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
2387	AND ((ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)) <= XXX AND ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)) >= XXX))
2388	);
2389	################################################################################
2390	3 Queries
2391	user: transitionnetw_0[transitionnetw_0]
2392	url: localhost
2393	ip: []
2394	Taking 210828 228226 237398 seconds to complete
2395	Locking for 0 0 0 seconds
2396	Average time: 225484, Median time 228226
2397	Average lock: 0, Median lock 0
2398
2399	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2400	SET timestamp=XXX;
2401	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
2402	FROM node node
2403	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2404	LEFT JOIN location location ON location_instance.lid = location.lid
2405	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < XXX.XXX)
2406	)) count_alias;
2407	################################################################################
2408	3 Queries
2409	user: transitionnetw_0[transitionnetw_0]
2410	url: localhost
2411	ip: []
2412	Taking 231122 239563 239563 seconds to complete
2413	Locking for 0 0 0 seconds
2414	Average time: 236749, Median time 239563
2415	Average lock: 0, Median lock 0
2416
2417	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2418	SET timestamp=XXX;
2419	SELECT src, dst FROM url_alias WHERE language = XXX ORDER BY pid;
2420	################################################################################
2421	3 Queries
2422	user: transitionnetw_0[transitionnetw_0]
2423	url: localhost
2424	ip: []
2425	Taking 212526 218065 231122 seconds to complete
2426	Locking for 0 0 0 seconds
2427	Average time: 220571, Median time 218065
2428	Average lock: 0, Median lock 0
2429
2430	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2431	use transitionnetw_XXX;
2432	SET timestamp=XXX;
2433	SELECT * FROM aggregator_feed WHERE checked + refresh < XXX;
2434	################################################################################
2435	3 Queries
2436	user: newstransition_0[newstransition_0]
2437	url: localhost
2438	ip: []
2439	Taking 206605 211202 218002 seconds to complete
2440	Locking for 0 0 0 seconds
2441	Average time: 211936, Median time 211202
2442	Average lock: 0, Median lock 0
2443
2444	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2445	SET timestamp=XXX;
2446	SELECT COUNT(*) FROM (SELECT node.nid AS nid
2447	FROM node node
2448	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
2449	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
2450	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
2451	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
2452	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
2453	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2454	LEFT JOIN location location ON location_instance.lid = location.lid
2455	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > XXX.XXX AND location.longitude < XXX.XXX)
2456	) count_alias;
2457	################################################################################
2458	3 Queries
2459	user: transitionnetw_0[transitionnetw_0]
2460	url: localhost
2461	ip: []
2462	Taking 228683 235269 240602 seconds to complete
2463	Locking for 0 0 0 seconds
2464	Average time: 234851, Median time 235269
2465	Average lock: 0, Median lock 0
2466
2467	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2468	use transitionnetw_XXX;
2469	SET timestamp=XXX;
2470	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2471	node.title AS node_title,
2472	node.language AS node_language,
2473	node.type AS node_type,
2474	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2475	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2476	node.vid AS node_vid,
2477	location.lid AS location_lid
2478	FROM node node
2479	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2480	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2481	LEFT JOIN location location ON location_instance.lid = location.lid
2482	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)))
2483	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
2484	)GROUP BY nid
2485	ORDER BY node_data_field_occurs_field_occurs_value ASC
2486	) count_alias;
2487	################################################################################
2488	3 Queries
2489	user: transitionnetw_0[transitionnetw_0]
2490	url: localhost
2491	ip: []
2492	Taking 226768 238935 238936 seconds to complete
2493	Locking for 0 0 0 seconds
2494	Average time: 234879, Median time 238935
2495	Average lock: 0, Median lock 0
2496
2497	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2498	SET timestamp=XXX;
2499	SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title;
2500	################################################################################
2501	3 Queries
2502	user: transitionnetw_0[transitionnetw_0]
2503	url: localhost
2504	ip: []
2505	Taking 230410 234688 234796 seconds to complete
2506	Locking for 0 0 0 seconds
2507	Average time: 233298, Median time 234688
2508	Average lock: 0, Median lock 0
2509
2510	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2511	SET timestamp=XXX;
2512	SELECT DISTINCT s.* FROM notifications s INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid WHERE (s.uid = XXX) AND (s.type = XXX) AND (s.conditions = XXX) AND ((fXXX.field = XXX AND fXXX.value = XXX));
2513	################################################################################
2514	3 Queries
2515	user: transitionnetw_0[transitionnetw_0]
2516	url: localhost
2517	ip: []
2518	Taking 228375 228522 232642 seconds to complete
2519	Locking for 0 0 0 seconds
2520	Average time: 229846, Median time 228522
2521	Average lock: 0, Median lock 0
2522
2523	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2524	SET timestamp=XXX;
2525	SELECT nfi.field_name, nfi.label
2526	FROM content_node_field_instance nfi
2527	INNER JOIN content_node_field nf ON nfi.field_name = nf.field_name
2528	WHERE nfi.type_name = XXX AND nf.active = XXX AND nf.locked = XXX;
2529	################################################################################
2530	3 Queries
2531	user: transitionnetw_0[transitionnetw_0]
2532	url: localhost
2533	ip: []
2534	Taking 226191 238954 240979 seconds to complete
2535	Locking for 0 0 0 seconds
2536	Average time: 235374, Median time 238954
2537	Average lock: 0, Median lock 0
2538
2539	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2540	SET timestamp=XXX;
2541	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2542	node.sticky AS node_sticky,
2543	node.created AS node_created
2544	FROM node node
2545	INNER JOIN users users ON node.uid = users.uid
2546	WHERE (node.status = XXX) AND (node.type in (XXX, XXX)) AND (users.name = XXX)
2547	GROUP BY nid
2548	ORDER BY node_sticky DESC, node_created DESC
2549	) count_alias;
2550	################################################################################
2551	3 Queries
2552	user: transitionnetw_0[transitionnetw_0]
2553	url: localhost
2554	ip: []
2555	Taking 214243 225344 234595 seconds to complete
2556	Locking for 0 0 0 seconds
2557	Average time: 224727, Median time 225344
2558	Average lock: 0, Median lock 0
2559
2560	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2561	use transitionnetw_XXX;
2562	SET timestamp=XXX;
2563	SELECT DISTINCT node.nid AS nid,
2564	node.title AS node_title,
2565	node.language AS node_language,
2566	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2567	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2568	node.type AS node_type,
2569	node.vid AS node_vid
2570	FROM node node
2571	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
2572	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2573	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
2574	AND ((ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)) <= XXX AND ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)) >= XXX))
2575	)ORDER BY node_data_field_occurs_field_occurs_value ASC;
2576	################################################################################
2577	3 Queries
2578	user: newstransition_0[newstransition_0]
2579	url: localhost
2580	ip: []
2581	Taking 220011 234158 238400 seconds to complete
2582	Locking for 0 0 0 seconds
2583	Average time: 230856, Median time 234158
2584	Average lock: 0, Median lock 0
2585
2586	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2587	use newstransition_XXX;
2588	SET timestamp=XXX;
2589	SELECT node.nid AS nid,
2590	feeds_data_feed_fast.title AS feeds_data_feed_fast_title,
2591	feeds_data_feed_fast.timestamp AS feeds_data_feed_fast_timestamp,
2592	feeds_data_feed_fast.url AS feeds_data_feed_fast_url,
2593	feeds_data_feed_fast.description AS feeds_data_feed_fast_description,
2594	node.title AS node_title,
2595	node.vid AS node_vid,
2596	location.latitude AS location_latitude,
2597	location.longitude AS location_longitude
2598	FROM node node
2599	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
2600	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
2601	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
2602	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
2603	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
2604	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2605	LEFT JOIN location location ON location_instance.lid = location.lid
2606	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < XXX.XXX)
2607	ORDER BY feeds_data_feed_fast_timestamp DESC
2608	LIMIT XXX, XXX;
2609	################################################################################
2610	3 Queries
2611	user: transitionnetw_0[transitionnetw_0]
2612	url: localhost
2613	ip: []
2614	Taking 234620 234661 234825 seconds to complete
2615	Locking for 0 0 0 seconds
2616	Average time: 234702, Median time 234661
2617	Average lock: 0, Median lock 0
2618
2619	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2620	SET timestamp=XXX;
2621	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
2622	FROM node node
2623	INNER JOIN nodequeue_nodes nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND nodequeue_nodes_node.qid = XXX
2624	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2625	LEFT JOIN location location ON location_instance.lid = location.lid
2626	INNER JOIN content_type_resource node_data_field_asset_type ON node.vid = node_data_field_asset_type.vid
2627	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (node.language in (XXX)) AND (location.country = XXX) AND (node_data_field_asset_type.field_asset_type_value = XXX)
2628	)) count_alias;
2629	################################################################################
2630	3 Queries
2631	user: transitionnetw_0[transitionnetw_0]
2632	url: localhost
2633	ip: []
2634	Taking 214701 216262 228150 seconds to complete
2635	Locking for 0 0 0 seconds
2636	Average time: 219704, Median time 216262
2637	Average lock: 0, Median lock 0
2638
2639	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2640	use transitionnetw_XXX;
2641	SET timestamp=XXX;
2642	SELECT DISTINCT node.nid AS nid,
2643	node.title AS node_title,
2644	node.language AS node_language,
2645	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2646	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2647	node.type AS node_type,
2648	node.vid AS node_vid
2649	FROM node node
2650	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2651	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX)))
2652	AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX))
2653	);
2654	################################################################################
2655	3 Queries
2656	user: transitionnetw_0[transitionnetw_0]
2657	url: localhost
2658	ip: []
2659	Taking 224351 224464 232953 seconds to complete
2660	Locking for 0 0 0 seconds
2661	Average time: 227256, Median time 224464
2662	Average lock: 0, Median lock 0
2663
2664	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2665	use transitionnetw_XXX;
2666	SET timestamp=XXX;
2667	SELECT h.nid FROM nodehierarchy h WHERE h.parent = XXX ORDER BY h.order_by ASC;
2668	################################################################################
2669	4 Queries
2670	user: transitionnetw_0[transitionnetw_0]
2671	url: localhost
2672	ip: []
2673	Taking 216636 220149 228354 229912 seconds to complete
2674	Locking for 0 0 0 0 seconds
2675	Average time: 223762, Median time 228354
2676	Average lock: 0, Median lock 0
2677
2678	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2679	SET timestamp=XXX;
2680	SELECT vid, nid, field_featured_image_fid AS fid, field_featured_image_list AS list, field_featured_image_data AS data
2681	FROM content_field_featured_image
2682	WHERE field_featured_image_fid = XXX;
2683	################################################################################
2684	4 Queries
2685	user: spacetransitionn[spacetransitionn]
2686	url: localhost
2687	ip: []
2688	Taking 212639 218184 232467 240659 seconds to complete
2689	Locking for 0 0 0 0 seconds
2690	Average time: 225987, Median time 232467
2691	Average lock: 0, Median lock 0
2692
2693	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2694	use spacetransitionn;
2695	SET timestamp=XXX;
2696	DELETE FROM history
2697	WHERE (timestamp < XXX);
2698	################################################################################
2699	4 Queries
2700	user: transitionnetw_0[transitionnetw_0]
2701	url: localhost
2702	ip: []
2703	Taking 236601 241507 241534 241628 seconds to complete
2704	Locking for 0 0 0 0 seconds
2705	Average time: 240317, Median time 241534
2706	Average lock: 0, Median lock 0
2707
2708	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2709	SET timestamp=XXX;
2710	SELECT COUNT(*) FROM node n INNER JOIN users u ON n.uid = u.uid;
2711	################################################################################
2712	4 Queries
2713	user: transitionnetw_0[transitionnetw_0]
2714	url: localhost
2715	ip: []
2716	Taking 226752 226755 229767 231215 seconds to complete
2717	Locking for 0 0 0 0 seconds
2718	Average time: 228622, Median time 229767
2719	Average lock: 0, Median lock 0
2720
2721	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2722	SET timestamp=XXX;
2723	SELECT * FROM languages ORDER BY weight ASC, name ASC;
2724	################################################################################
2725	4 Queries
2726	user: transitionnetw_0[transitionnetw_0]
2727	url: localhost
2728	ip: []
2729	Taking 213179 226739 238962 238963 seconds to complete
2730	Locking for 0 0 0 0 seconds
2731	Average time: 229460, Median time 238962
2732	Average lock: 0, Median lock 0
2733
2734	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2735	SET timestamp=XXX;
2736	SELECT bf.*
2737	FROM
2738	botcha_form bf;
2739	################################################################################
2740	4 Queries
2741	user: transitionnetw_0[transitionnetw_0]
2742	url: localhost
2743	ip: []
2744	Taking 224879 226579 227655 235339 seconds to complete
2745	Locking for 0 0 0 0 seconds
2746	Average time: 228613, Median time 227655
2747	Average lock: 0, Median lock 0
2748
2749	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2750	SET timestamp=XXX;
2751	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2752	node.title AS node_title,
2753	node.language AS node_language
2754	FROM node node
2755	LEFT JOIN content_type_profile node_data_field_user_location ON node.vid = node_data_field_user_location.vid
2756	LEFT JOIN location location_node_data_field_user_location ON node_data_field_user_location.field_user_location_lid = location_node_data_field_user_location.lid
2757	INNER JOIN content_field_roles_offered node_data_field_roles_offered ON node.vid = node_data_field_roles_offered.vid
2758	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node.status = XXX) AND (node_data_field_roles_offered.field_roles_offered_value = XXX)
2759	)GROUP BY nid
2760	ORDER BY node_title ASC
2761	) count_alias;
2762	################################################################################
2763	4 Queries
2764	user: transitionnetw_0[transitionnetw_0]
2765	url: localhost
2766	ip: []
2767	Taking 220278 235672 236668 240955 seconds to complete
2768	Locking for 0 0 0 0 seconds
2769	Average time: 233393, Median time 236668
2770	Average lock: 0, Median lock 0
2771
2772	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2773	SET timestamp=XXX;
2774	SELECT tid, COUNT(nid) AS topic_count, SUM(nid_comment_count) AS comment_count
2775	FROM (
2776	SELECT r.tid AS tid, n.nid AS nid, l.comment_count AS nid_comment_count
2777	FROM node n
2778	INNER JOIN node_comment_statistics l ON n.nid = l.nid
2779	INNER JOIN term_node r ON n.vid = r.vid
2780	INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( n.status = XXX
2781	)GROUP BY r.tid, n.nid, l.comment_count) AS forum_content_list
2782	GROUP BY tid;
2783	################################################################################
2784	4 Queries
2785	user: transitionnetw_0[transitionnetw_0]
2786	url: localhost
2787	ip: []
2788	Taking 229330 234004 234534 241446 seconds to complete
2789	Locking for 0 0 0 0 seconds
2790	Average time: 234828, Median time 234534
2791	Average lock: 0, Median lock 0
2792
2793	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2794	SET timestamp=XXX;
2795	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
2796	FROM node node
2797	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2798	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
2799	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node_data_field_event_type.field_event_type_value = XXX) AND (node.type in (XXX)))
2800	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
2801	)) count_alias;
2802	################################################################################
2803	4 Queries
2804	user: transitionnetw_0[transitionnetw_0]
2805	url: localhost
2806	ip: []
2807	Taking 206342 206661 212624 214822 seconds to complete
2808	Locking for 0 0 0 0 seconds
2809	Average time: 210112, Median time 212624
2810	Average lock: 0, Median lock 0
2811
2812	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2813	use transitionnetw_XXX;
2814	SET timestamp=XXX;
2815	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2816	node.created AS node_created
2817	FROM node node
2818	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
2819	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX )
2820	)GROUP BY nid
2821	ORDER BY node_created DESC
2822	) count_alias;
2823	################################################################################
2824	4 Queries
2825	user: transitionnetw_0[transitionnetw_0]
2826	url: localhost
2827	ip: []
2828	Taking 228188 228375 237872 238865 seconds to complete
2829	Locking for 0 0 0 0 seconds
2830	Average time: 233325, Median time 237872
2831	Average lock: 0, Median lock 0
2832
2833	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2834	SET timestamp=XXX;
2835	SELECT DISTINCT s.* FROM notifications s INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid WHERE (s.uid = XXX) AND (s.type = XXX) AND (s.conditions = XXX) AND ((fXXX.field = XXX AND fXXX.intval = XXX) AND (fXXX.field = XXX AND fXXX.value = XXX));
2836	################################################################################
2837	4 Queries
2838	user: transitionnetw_0[transitionnetw_0]
2839	url: localhost
2840	ip: []
2841	Taking 215039 227636 229374 238941 seconds to complete
2842	Locking for 0 0 0 0 seconds
2843	Average time: 227747, Median time 229374
2844	Average lock: 0, Median lock 0
2845
2846	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2847	SET timestamp=XXX;
2848	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2849	node.created AS node_created
2850	FROM node node
2851	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
2852	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX )
2853	)GROUP BY nid
2854	ORDER BY node_created DESC
2855	) count_alias;
2856	################################################################################
2857	4 Queries
2858	user: newstransition_0[newstransition_0]
2859	url: localhost
2860	ip: []
2861	Taking 213007 232680 238367 240144 seconds to complete
2862	Locking for 0 0 0 0 seconds
2863	Average time: 231049, Median time 238367
2864	Average lock: 0, Median lock 0
2865
2866	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2867	SET timestamp=XXX;
2868	SELECT node.nid AS nid,
2869	feeds_data_feed_fast.title AS feeds_data_feed_fast_title,
2870	feeds_data_feed_fast.timestamp AS feeds_data_feed_fast_timestamp,
2871	feeds_data_feed_fast.url AS feeds_data_feed_fast_url,
2872	feeds_data_feed_fast.description AS feeds_data_feed_fast_description,
2873	node.title AS node_title,
2874	node.vid AS node_vid,
2875	location.latitude AS location_latitude,
2876	location.longitude AS location_longitude
2877	FROM node node
2878	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
2879	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
2880	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
2881	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
2882	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
2883	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2884	LEFT JOIN location location ON location_instance.lid = location.lid
2885	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > XXX.XXX AND location.longitude < XXX.XXX)
2886	ORDER BY feeds_data_feed_fast_timestamp DESC
2887	LIMIT XXX, XXX;
2888	################################################################################
2889	4 Queries
2890	user: transitionnetw_0[transitionnetw_0]
2891	url: localhost
2892	ip: []
2893	Taking 230057 231237 234519 234548 seconds to complete
2894	Locking for 0 0 0 0 seconds
2895	Average time: 232590, Median time 234519
2896	Average lock: 0, Median lock 0
2897
2898	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2899	SET timestamp=XXX;
2900	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
2901	FROM node node
2902	INNER JOIN nodequeue_nodes nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND nodequeue_nodes_node.qid = XXX
2903	LEFT JOIN content_type_resource node_data_field_asset_type ON node.vid = node_data_field_asset_type.vid
2904	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2905	LEFT JOIN location location ON location_instance.lid = location.lid
2906	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX))
2907	)) count_alias;
2908	################################################################################
2909	4 Queries
2910	user: transitionnetw_0[transitionnetw_0]
2911	url: localhost
2912	ip: []
2913	Taking 222676 227097 234544 235626 seconds to complete
2914	Locking for 0 0 0 0 seconds
2915	Average time: 229985, Median time 234544
2916	Average lock: 0, Median lock 0
2917
2918	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2919	SET timestamp=XXX;
2920	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2921	node.title AS node_title,
2922	node.language AS node_language,
2923	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2924	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2925	node.type AS node_type,
2926	node.vid AS node_vid,
2927	location.lid AS location_lid
2928	FROM node node
2929	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2930	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2931	LEFT JOIN location location ON location_instance.lid = location.lid
2932	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)))
2933	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
2934	)GROUP BY nid
2935	ORDER BY node_data_field_occurs_field_occurs_value ASC
2936	) count_alias;
2937	################################################################################
2938	4 Queries
2939	user: transitionnetw_0[transitionnetw_0]
2940	url: localhost
2941	ip: []
2942	Taking 206140 212526 218065 239563 seconds to complete
2943	Locking for 0 0 0 0 seconds
2944	Average time: 219073, Median time 218065
2945	Average lock: 0, Median lock 0
2946
2947	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2948	SET timestamp=XXX;
2949	DELETE FROM abuse_status WHERE type=XXX AND oid NOT IN (SELECT nid FROM node);
2950	################################################################################
2951	4 Queries
2952	user: transitionnetw_0[transitionnetw_0]
2953	url: localhost
2954	ip: []
2955	Taking 208123 217829 222904 241780 seconds to complete
2956	Locking for 0 0 0 0 seconds
2957	Average time: 222659, Median time 222904
2958	Average lock: 0, Median lock 0
2959
2960	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2961	SET timestamp=XXX;
2962	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
2963	node.title AS node_title,
2964	node.language AS node_language,
2965	node.type AS node_type,
2966	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
2967	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
2968	node.vid AS node_vid,
2969	location.lid AS location_lid
2970	FROM node node
2971	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
2972	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
2973	LEFT JOIN location location ON location_instance.lid = location.lid
2974	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)))
2975	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
2976	)GROUP BY nid
2977	ORDER BY node_data_field_occurs_field_occurs_value ASC
2978	) count_alias;
2979	################################################################################
2980	4 Queries
2981	user: spacetransitionn[spacetransitionn]
2982	url: localhost
2983	ip: []
2984	Taking 206246 212639 218184 240659 seconds to complete
2985	Locking for 0 0 0 0 seconds
2986	Average time: 219432, Median time 218184
2987	Average lock: 0, Median lock 0
2988
2989	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
2990	SET timestamp=XXX;
2991	SELECT rules_dependencies.id AS id, rules_dependencies.module AS module
2992	FROM
2993	rules_dependencies rules_dependencies
2994	WHERE (id IN (XXX, XXX, XXX));
2995	################################################################################
2996	4 Queries
2997	user: newstransition_0[newstransition_0]
2998	url: localhost
2999	ip: []
3000	Taking 214555 218828 227197 241742 seconds to complete
3001	Locking for 0 0 0 0 seconds
3002	Average time: 225580, Median time 227197
3003	Average lock: 0, Median lock 0
3004
3005	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3006	use newstransition_XXX;
3007	SET timestamp=XXX;
3008	SELECT * FROM variable;
3009	################################################################################
3010	5 Queries
3011	user: transitionnetw_0[transitionnetw_0]
3012	url: localhost
3013	ip: []
3014	Taking 204818 206452 210040 210601 222588 seconds to complete
3015	Locking for 0 0 0 0 0 seconds
3016	Average time: 210899, Median time 210040
3017	Average lock: 0, Median lock 0
3018
3019	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3020	use transitionnetw_XXX;
3021	SET timestamp=XXX;
3022	SELECT vid, nid, field_featured_image_fid AS fid, field_featured_image_list AS list, field_featured_image_data AS data
3023	FROM content_field_featured_image
3024	WHERE field_featured_image_fid = XXX;
3025	################################################################################
3026	5 Queries
3027	user: transitionnetw_0[transitionnetw_0]
3028	url: localhost
3029	ip: []
3030	Taking 240540 240898 241027 241243 241384 seconds to complete
3031	Locking for 0 0 0 0 0 seconds
3032	Average time: 241018, Median time 241027
3033	Average lock: 0, Median lock 0
3034
3035	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3036	SET timestamp=XXX;
3037	SELECT DISTINCT node.nid AS nid,
3038	node.title AS node_title,
3039	node.language AS node_language,
3040	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
3041	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
3042	node.type AS node_type,
3043	node.vid AS node_vid
3044	FROM node node
3045	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
3046	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
3047	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
3048	AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX))
3049	);
3050	################################################################################
3051	5 Queries
3052	user: transitionnetw_0[transitionnetw_0]
3053	url: localhost
3054	ip: []
3055	Taking 215411 223865 224386 231148 235227 seconds to complete
3056	Locking for 0 0 0 0 0 seconds
3057	Average time: 226007, Median time 224386
3058	Average lock: 0, Median lock 0
3059
3060	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3061	SET timestamp=XXX;
3062	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3063	node.title AS node_title,
3064	node.language AS node_language,
3065	location_node_data_field_user_location.country AS location_node_data_field_user_location_country,
3066	node.type AS node_type,
3067	node.vid AS node_vid
3068	FROM node node
3069	LEFT JOIN content_type_profile node_data_field_user_location ON node.vid = node_data_field_user_location.vid
3070	LEFT JOIN location location_node_data_field_user_location ON node_data_field_user_location.field_user_location_lid = location_node_data_field_user_location.lid
3071	INNER JOIN users users ON node.uid = users.uid
3072	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node.status = XXX) AND (users.status <> XXX)
3073	)GROUP BY nid
3074	ORDER BY node_title ASC
3075	) count_alias;
3076	################################################################################
3077	5 Queries
3078	user: transitionnetw_0[transitionnetw_0]
3079	url: localhost
3080	ip: []
3081	Taking 229752 230066 232953 236588 240413 seconds to complete
3082	Locking for 0 0 0 0 0 seconds
3083	Average time: 233954, Median time 232953
3084	Average lock: 0, Median lock 0
3085
3086	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3087	SET timestamp=XXX;
3088	SELECT SUBSTRING_INDEX(src, XXX, XXX) AS path FROM url_alias GROUP BY path;
3089	################################################################################
3090	5 Queries
3091	user: transitionnetw_0[transitionnetw_0]
3092	url: localhost
3093	ip: []
3094	Taking 206229 206547 216612 221240 237877 seconds to complete
3095	Locking for 0 0 0 0 0 seconds
3096	Average time: 217701, Median time 216612
3097	Average lock: 0, Median lock 0
3098
3099	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3100	use transitionnetw_XXX;
3101	SET timestamp=XXX;
3102	DELETE FROM semaphore WHERE value = XXX;
3103	################################################################################
3104	5 Queries
3105	user: transitionnetw_0[transitionnetw_0]
3106	url: localhost
3107	ip: []
3108	Taking 216668 219142 219724 220503 220626 seconds to complete
3109	Locking for 0 0 0 0 0 seconds
3110	Average time: 219332, Median time 219724
3111	Average lock: 0, Median lock 0
3112
3113	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3114	use transitionnetw_XXX;
3115	SET timestamp=XXX;
3116	SELECT vid, nid, field_profile_photo_fid AS fid, field_profile_photo_list AS list, field_profile_photo_data AS data
3117	FROM content_type_profile
3118	WHERE field_profile_photo_fid = XXX;
3119	################################################################################
3120	5 Queries
3121	user: transitionnetw_0[transitionnetw_0]
3122	url: localhost
3123	ip: []
3124	Taking 223878 225893 230180 230651 238716 seconds to complete
3125	Locking for 0 0 0 0 0 seconds
3126	Average time: 229863, Median time 230180
3127	Average lock: 0, Median lock 0
3128
3129	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3130	SET timestamp=XXX;
3131	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
3132	FROM node node
3133	LEFT JOIN og_uid og_uid ON node.nid = og_uid.nid
3134	LEFT JOIN og og ON node.nid = og.nid
3135	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type IN (XXX)) AND (og_uid.uid = XXX)
3136	)) count_alias;
3137	################################################################################
3138	5 Queries
3139	user: transitionnetw_0[transitionnetw_0]
3140	url: localhost
3141	ip: []
3142	Taking 227846 230632 235196 238888 240728 seconds to complete
3143	Locking for 0 0 0 0 0 seconds
3144	Average time: 234658, Median time 235196
3145	Average lock: 0, Median lock 0
3146
3147	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3148	SET timestamp=XXX;
3149	SELECT DISTINCT node.nid AS nid,
3150	XXX AS location_distance,
3151	node.title AS node_title,
3152	node.language AS node_language,
3153	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
3154	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
3155	node.type AS node_type,
3156	node.vid AS node_vid
3157	FROM node node
3158	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
3159	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3160	LEFT JOIN location location ON location_instance.lid = location.lid
3161	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.type in (XXX, XXX, XXX, XXX)) AND (node.status = XXX))
3162	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
3163	)ORDER BY node_data_field_occurs_field_occurs_value ASC
3164	LIMIT XXX, XXX;
3165	################################################################################
3166	5 Queries
3167	user: spacetransitionn[spacetransitionn]
3168	url: localhost
3169	ip: []
3170	Taking 206246 212639 232467 232993 240659 seconds to complete
3171	Locking for 0 0 0 0 0 seconds
3172	Average time: 225000, Median time 232467
3173	Average lock: 0, Median lock 0
3174
3175	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3176	use spacetransitionn;
3177	SET timestamp=XXX;
3178	DELETE FROM batch
3179	WHERE (timestamp < XXX);
3180	################################################################################
3181	5 Queries
3182	user: transitionnetw_0[transitionnetw_0]
3183	url: localhost
3184	ip: []
3185	Taking 205413 209176 218138 225417 226255 seconds to complete
3186	Locking for 0 0 0 0 0 seconds
3187	Average time: 216879, Median time 218138
3188	Average lock: 0, Median lock 0
3189
3190	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3191	SET timestamp=XXX;
3192	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
3193	FROM node node
3194	INNER JOIN term_node term_node ON node.vid = term_node.vid
3195	LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
3196	INNER JOIN users users ON node.uid = users.uid
3197	INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
3198	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (term_node.tid = XXX)
3199	)) count_alias;
3200	################################################################################
3201	5 Queries
3202	user: transitionnetw_0[transitionnetw_0]
3203	url: localhost
3204	ip: []
3205	Taking 207974 223996 227963 234667 235565 seconds to complete
3206	Locking for 0 0 0 0 0 seconds
3207	Average time: 226033, Median time 227963
3208	Average lock: 0, Median lock 0
3209
3210	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3211	SET timestamp=XXX;
3212	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3213	node.title AS node_title,
3214	node.language AS node_language,
3215	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
3216	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
3217	node.type AS node_type,
3218	node.vid AS node_vid,
3219	location.lid AS location_lid
3220	FROM node node
3221	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
3222	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
3223	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3224	LEFT JOIN location location ON location_instance.lid = location.lid
3225	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
3226	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
3227	)GROUP BY nid
3228	ORDER BY node_data_field_occurs_field_occurs_value ASC
3229	) count_alias;
3230	################################################################################
3231	5 Queries
3232	user: transitionnetw_0[transitionnetw_0]
3233	url: localhost
3234	ip: []
3235	Taking 228251 231206 236158 237533 237577 seconds to complete
3236	Locking for 0 0 0 0 0 seconds
3237	Average time: 234145, Median time 236158
3238	Average lock: 0, Median lock 0
3239
3240	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3241	SET timestamp=XXX;
3242	SELECT DISTINCT node.nid AS nid,
3243	node.title AS node_title,
3244	node.language AS node_language,
3245	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
3246	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
3247	node.type AS node_type,
3248	node.vid AS node_vid
3249	FROM node node
3250	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
3251	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
3252	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
3253	AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX))
3254	)ORDER BY node_data_field_occurs_field_occurs_value ASC;
3255	################################################################################
3256	5 Queries
3257	user: transitionnetw_0[transitionnetw_0]
3258	url: localhost
3259	ip: []
3260	Taking 228344 229024 229477 234610 239915 seconds to complete
3261	Locking for 0 0 0 0 0 seconds
3262	Average time: 232274, Median time 229477
3263	Average lock: 0, Median lock 0
3264
3265	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3266	SET timestamp=XXX;
3267	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3268	node.sticky AS node_sticky,
3269	node.created AS node_created
3270	FROM node node
3271	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)))
3272	AND ((DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.created), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node.created), SEC_TO_TIME(XXX)), XXX) >= XXX))
3273	)GROUP BY nid
3274	ORDER BY node_sticky DESC, node_created DESC
3275	) count_alias;
3276	################################################################################
3277	5 Queries
3278	user: transitionnetw_0[transitionnetw_0]
3279	url: localhost
3280	ip: []
3281	Taking 208802 217791 218831 235149 235745 seconds to complete
3282	Locking for 0 0 0 0 0 seconds
3283	Average time: 223263, Median time 218831
3284	Average lock: 0, Median lock 0
3285
3286	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3287	use transitionnetw_XXX;
3288	SET timestamp=XXX;
3289	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3290	node.title AS node_title,
3291	node.language AS node_language,
3292	location.province AS location_province,
3293	location.country AS location_country,
3294	node_data_field_status.field_status_value AS node_data_field_status_field_status_value,
3295	node.type AS node_type,
3296	node.vid AS node_vid
3297	FROM node node
3298	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3299	LEFT JOIN location location ON location_instance.lid = location.lid
3300	LEFT JOIN content_type_initiative_profile node_data_field_status ON node.vid = node_data_field_status.vid
3301	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX, XXX)) AND (node.status = XXX) AND (SUBSTR(node.title, XXX, XXX) = XXX)
3302	)GROUP BY nid
3303	ORDER BY node_title ASC
3304	) count_alias;
3305	################################################################################
3306	6 Queries
3307	user: transitionnetw_0[transitionnetw_0]
3308	url: localhost
3309	ip: []
3310	Taking 206140 212526 218065 223966 231122 239563 seconds to complete
3311	Locking for 0 0 0 0 0 0 seconds
3312	Average time: 221897, Median time 223966
3313	Average lock: 0, Median lock 0
3314
3315	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3316	SET timestamp=XXX;
3317	DELETE FROM mollom WHERE changed < XXX;
3318	################################################################################
3319	6 Queries
3320	user: transitionnetw_0[transitionnetw_0]
3321	url: localhost
3322	ip: []
3323	Taking 224381 228342 228666 230971 234811 238717 seconds to complete
3324	Locking for 0 0 0 0 0 0 seconds
3325	Average time: 230981, Median time 230971
3326	Average lock: 0, Median lock 0
3327
3328	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3329	SET timestamp=XXX;
3330	SELECT rid FROM path_redirect WHERE (redirect = XXX) ORDER BY source ASC;
3331	################################################################################
3332	6 Queries
3333	user: transitionnetw_0[transitionnetw_0]
3334	url: localhost
3335	ip: []
3336	Taking 208518 208520 208773 220154 228428 239170 seconds to complete
3337	Locking for 0 0 0 0 0 0 seconds
3338	Average time: 218927, Median time 220154
3339	Average lock: 0, Median lock 0
3340
3341	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3342	SET timestamp=XXX;
3343	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3344	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value
3345	FROM node node
3346	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
3347	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
3348	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX ))
3349	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
3350	)GROUP BY nid
3351	ORDER BY node_data_field_occurs_field_occurs_value DESC
3352	) count_alias;
3353	################################################################################
3354	6 Queries
3355	user: transitionnetw_0[transitionnetw_0]
3356	url: localhost
3357	ip: []
3358	Taking 212440 214674 220377 222901 233921 238302 seconds to complete
3359	Locking for 0 0 0 0 0 0 seconds
3360	Average time: 223769, Median time 222901
3361	Average lock: 0, Median lock 0
3362
3363	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3364	SET timestamp=XXX;
3365	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3366	node.sticky AS node_sticky,
3367	node.created AS node_created
3368	FROM node node
3369	INNER JOIN users users ON node.uid = users.uid
3370	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (users.name = XXX)
3371	)GROUP BY nid
3372	ORDER BY node_sticky DESC, node_created DESC
3373	) count_alias;
3374	################################################################################
3375	6 Queries
3376	user: spacetransitionn[spacetransitionn]
3377	url: localhost
3378	ip: []
3379	Taking 205187 218154 224073 232456 232972 233519 seconds to complete
3380	Locking for 0 0 0 0 0 0 seconds
3381	Average time: 224393, Median time 232456
3382	Average lock: 0, Median lock 0
3383
3384	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3385	use spacetransitionn;
3386	SET timestamp=XXX;
3387	SELECT name, value FROM variable;
3388	################################################################################
3389	6 Queries
3390	user: transitionnetw_0[transitionnetw_0]
3391	url: localhost
3392	ip: []
3393	Taking 206140 212526 223966 231122 231507 239563 seconds to complete
3394	Locking for 0 0 0 0 0 0 seconds
3395	Average time: 224137, Median time 231122
3396	Average lock: 0, Median lock 0
3397
3398	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3399	SET timestamp=XXX;
3400	SELECT t.word AS realword, i.word FROM search_total t LEFT JOIN search_index i ON t.word = i.word WHERE i.word IS NULL;
3401	################################################################################
3402	7 Queries
3403	user: transitionnetw_0[transitionnetw_0]
3404	url: localhost
3405	ip: []
3406	Taking 213196 223679 226294 226540 228164 237872 241562 seconds to complete
3407	Locking for 0 0 0 0 0 0 0 seconds
3408	Average time: 228186, Median time 226540
3409	Average lock: 0, Median lock 0
3410
3411	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3412	SET timestamp=XXX;
3413	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
3414	FROM node node
3415	LEFT JOIN og_uid og_uid ON node.nid = og_uid.nid
3416	LEFT JOIN og og ON node.nid = og.nid
3417	WHERE (node.status = XXX) AND (node.type IN (XXX)) AND (og_uid.uid = XXX)
3418	) count_alias;
3419	################################################################################
3420	7 Queries
3421	user: transitionnetw_0[transitionnetw_0]
3422	url: localhost
3423	ip: []
3424	Taking 230066 231168 232725 234789 240148 240413 241992 seconds to complete
3425	Locking for 0 0 0 0 0 0 0 seconds
3426	Average time: 235900, Median time 234789
3427	Average lock: 0, Median lock 0
3428
3429	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3430	SET timestamp=XXX;
3431	SELECT h.nid FROM nodehierarchy h WHERE h.parent = XXX ORDER BY h.order_by ASC;
3432	################################################################################
3433	7 Queries
3434	user: transitionnetw_0[transitionnetw_0]
3435	url: localhost
3436	ip: []
3437	Taking 208277 215165 216904 219831 220117 221096 238265 seconds to complete
3438	Locking for 0 0 0 0 0 0 0 seconds
3439	Average time: 219950, Median time 219831
3440	Average lock: 0, Median lock 0
3441
3442	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3443	SET timestamp=XXX;
3444	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3445	node.title AS node_title,
3446	node.language AS node_language,
3447	node.type AS node_type,
3448	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
3449	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
3450	node.vid AS node_vid,
3451	location.lid AS location_lid
3452	FROM node node
3453	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
3454	LEFT JOIN content_field_occurs node_data_field_occursXXX ON node.vid = node_data_field_occursXXX.vid
3455	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3456	LEFT JOIN location location ON location_instance.lid = location.lid
3457	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX, XXX)))
3458	AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX) OR ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occursXXX.field_occurs_value, XXX), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occursXXX.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)))
3459	)GROUP BY nid
3460	ORDER BY node_data_field_occurs_field_occurs_value ASC
3461	) count_alias;
3462	################################################################################
3463	7 Queries
3464	user: transitionnetw_0[transitionnetw_0]
3465	url: localhost
3466	ip: []
3467	Taking 209370 211566 224543 225738 228726 236553 237922 seconds to complete
3468	Locking for 0 0 0 0 0 0 0 seconds
3469	Average time: 224916, Median time 225738
3470	Average lock: 0, Median lock 0
3471
3472	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3473	SET timestamp=XXX;
3474	SELECT DISTINCT node.nid AS nid,
3475	node.title AS node_title,
3476	node.language AS node_language,
3477	node_data_field_occurs.field_occurs_value AS node_data_field_occurs_field_occurs_value,
3478	node_data_field_occurs.field_occurs_valueXXX AS node_data_field_occurs_field_occurs_valueXXX,
3479	node.type AS node_type,
3480	node.vid AS node_vid
3481	FROM node node
3482	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
3483	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX, XXX, XXX)))
3484	AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_value, XXX), SEC_TO_TIME(XXX)), XXX) <= XXX AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX))
3485	);
3486	################################################################################
3487	8 Queries
3488	user: transitionnetw_0[transitionnetw_0]
3489	url: localhost
3490	ip: []
3491	Taking 227344 229612 231797 233135 233587 236745 236801 236817 seconds to complete
3492	Locking for 0 0 0 0 0 0 0 0 seconds
3493	Average time: 233229, Median time 233587
3494	Average lock: 0, Median lock 0
3495
3496	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3497	SET timestamp=XXX;
3498	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
3499	FROM node node
3500	LEFT JOIN votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = XXX AND votingapi_cache_node_percent_vote_average.value_type = XXX AND votingapi_cache_node_percent_vote_average.tag = XXX AND votingapi_cache_node_percent_vote_average.function = XXX)
3501	LEFT JOIN content_field_resource_rel_stage node_data_field_resource_rel_stage ON node.vid = node_data_field_resource_rel_stage.vid
3502	LEFT JOIN content_type_resource node_data_field_asset_type ON node.vid = node_data_field_asset_type.vid
3503	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_resource_rel_stage.field_resource_rel_stage_nid = XXX )
3504	)) count_alias;
3505	################################################################################
3506	8 Queries
3507	user: newstransition_0[newstransition_0]
3508	url: localhost
3509	ip: []
3510	Taking 222337 225067 230436 237009 237747 237985 238436 241051 seconds to complete
3511	Locking for 0 0 0 0 0 0 0 0 seconds
3512	Average time: 233758, Median time 237747
3513	Average lock: 0, Median lock 0
3514
3515	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3516	use newstransition_XXX;
3517	SET timestamp=XXX;
3518	SELECT node.nid AS nid,
3519	feeds_data_feed_fast.title AS feeds_data_feed_fast_title,
3520	feeds_data_feed_fast.timestamp AS feeds_data_feed_fast_timestamp,
3521	feeds_data_feed_fast.url AS feeds_data_feed_fast_url,
3522	feeds_data_feed_fast.description AS feeds_data_feed_fast_description,
3523	node.title AS node_title,
3524	node.vid AS node_vid,
3525	location.latitude AS location_latitude,
3526	location.longitude AS location_longitude
3527	FROM node node
3528	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
3529	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
3530	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
3531	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
3532	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
3533	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3534	LEFT JOIN location location ON location_instance.lid = location.lid
3535	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > -XXX.XXX AND location.latitude < -XXX.XXX AND location.longitude > XXX.XXX AND location.longitude < XXX.XXX)
3536	ORDER BY feeds_data_feed_fast_timestamp DESC
3537	LIMIT XXX, XXX;
3538	################################################################################
3539	8 Queries
3540	user: transitionnetw_0[transitionnetw_0]
3541	url: localhost
3542	ip: []
3543	Taking 220926 221150 224959 225735 227780 229326 230576 230905 seconds to complete
3544	Locking for 0 0 0 0 0 0 0 0 seconds
3545	Average time: 226419, Median time 227780
3546	Average lock: 0, Median lock 0
3547
3548	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3549	use transitionnetw_XXX;
3550	SET timestamp=XXX;
3551	SELECT DISTINCT s.* FROM notifications s INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid WHERE (s.uid = XXX) AND (s.type = XXX) AND (s.conditions = XXX) AND ((fXXX.field = XXX AND fXXX.intval = XXX));
3552	################################################################################
3553	8 Queries
3554	user: newstransition_0[newstransition_0]
3555	url: localhost
3556	ip: []
3557	Taking 213584 216311 219269 223115 225301 233463 234636 240051 seconds to complete
3558	Locking for 0 0 0 0 0 0 0 0 seconds
3559	Average time: 225716, Median time 225301
3560	Average lock: 0, Median lock 0
3561
3562	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3563	SET timestamp=XXX;
3564	SELECT node.nid AS nid,
3565	feeds_data_feed_fast.title AS feeds_data_feed_fast_title,
3566	feeds_data_feed_fast.timestamp AS feeds_data_feed_fast_timestamp,
3567	feeds_data_feed_fast.url AS feeds_data_feed_fast_url,
3568	feeds_data_feed_fast.description AS feeds_data_feed_fast_description,
3569	node.title AS node_title,
3570	node.vid AS node_vid,
3571	location.latitude AS location_latitude,
3572	location.longitude AS location_longitude
3573	FROM node node
3574	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
3575	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
3576	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
3577	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
3578	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
3579	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3580	LEFT JOIN location location ON location_instance.lid = location.lid
3581	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < -XXX.XXX)
3582	ORDER BY feeds_data_feed_fast_timestamp DESC
3583	LIMIT XXX, XXX;
3584	################################################################################
3585	9 Queries
3586	user: spacetransitionn[spacetransitionn]
3587	url: localhost
3588	ip: []
3589	Taking 206246 206246 206246 212639 212639 218184 224085 224085 240659 seconds to complete
3590	Locking for 0 0 0 0 0 0 0 0 0 seconds
3591	Average time: 216781, Median time 212639
3592	Average lock: 0, Median lock 0
3593
3594	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3595	SET timestamp=XXX;
3596	SELECT data, item_id FROM queue q WHERE expire = XXX AND name = XXX ORDER BY created ASC LIMIT XXX, XXX;
3597	################################################################################
3598	10 Queries
3599	user: newstransition_0[newstransition_0]
3600	url: localhost
3601	ip: []
3602	Taking 204813 to 217272 seconds to complete
3603	Locking for 0 to 0 seconds
3604	Average time: 211520, Median time 214181
3605	Average lock: 0, Median lock 0
3606
3607	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3608	use newstransition_XXX;
3609	SET timestamp=XXX;
3610	SELECT COUNT(*) FROM (SELECT node.nid AS nid
3611	FROM node node
3612	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
3613	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
3614	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
3615	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
3616	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
3617	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3618	LEFT JOIN location location ON location_instance.lid = location.lid
3619	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > XXX.XXX AND location.longitude < XXX.XXX)
3620	) count_alias;
3621	################################################################################
3622	10 Queries
3623	user: transitionnetw_0[transitionnetw_0]
3624	url: localhost
3625	ip: []
3626	Taking 214347 to 240532 seconds to complete
3627	Locking for 0 to 0 seconds
3628	Average time: 224131, Median time 220431
3629	Average lock: 0, Median lock 0
3630
3631	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3632	use transitionnetw_XXX;
3633	SET timestamp=XXX;
3634	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3635	node.sticky AS node_sticky,
3636	node.created AS node_created
3637	FROM node node
3638	INNER JOIN users users ON node.uid = users.uid
3639	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (users.name = XXX)
3640	)GROUP BY nid
3641	ORDER BY node_sticky DESC, node_created DESC
3642	) count_alias;
3643	################################################################################
3644	10 Queries
3645	user: transitionnetw_0[transitionnetw_0]
3646	url: localhost
3647	ip: []
3648	Taking 203388 to 240034 seconds to complete
3649	Locking for 0 to 0 seconds
3650	Average time: 225798, Median time 227816
3651	Average lock: 0, Median lock 0
3652
3653	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3654	use transitionnetw_XXX;
3655	SET timestamp=XXX;
3656	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3657	node.sticky AS node_sticky,
3658	node.created AS node_created
3659	FROM node node
3660	INNER JOIN users users ON node.uid = users.uid
3661	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX, XXX)) AND (users.name = XXX)
3662	)GROUP BY nid
3663	ORDER BY node_sticky DESC, node_created DESC
3664	) count_alias;
3665	################################################################################
3666	11 Queries
3667	user: masterpuffinwe_0[masterpuffinwe_0]
3668	url: localhost
3669	ip: []
3670	Taking 203838 to 233706 seconds to complete
3671	Locking for 0 to 0 seconds
3672	Average time: 221571, Median time 223140
3673	Average lock: 0, Median lock 0
3674
3675	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3676	use masterpuffinwe_XXX;
3677	SET timestamp=XXX;
3678	SELECT count(nid) FROM hosting_site WHERE (status IN (XXX));
3679	################################################################################
3680	11 Queries
3681	user: newstransition_0[newstransition_0]
3682	url: localhost
3683	ip: []
3684	Taking 208569 to 216669 seconds to complete
3685	Locking for 0 to 0 seconds
3686	Average time: 213803, Median time 214217
3687	Average lock: 0, Median lock 0
3688
3689	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3690	use newstransition_XXX;
3691	SET timestamp=XXX;
3692	SELECT COUNT(*) FROM (SELECT node.nid AS nid
3693	FROM node node
3694	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
3695	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
3696	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
3697	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
3698	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
3699	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3700	LEFT JOIN location location ON location_instance.lid = location.lid
3701	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > -XXX.XXX AND location.latitude < -XXX.XXX AND location.longitude > XXX.XXX AND location.longitude < XXX.XXX)
3702	) count_alias;
3703	################################################################################
3704	12 Queries
3705	user: transitionnetw_0[transitionnetw_0]
3706	url: localhost
3707	ip: []
3708	Taking 224721 to 241586 seconds to complete
3709	Locking for 0 to 0 seconds
3710	Average time: 232795, Median time 232887
3711	Average lock: 0, Median lock 0
3712
3713	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3714	SET timestamp=XXX;
3715	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
3716	FROM node node
3717	LEFT JOIN term_node term_node ON node.vid = term_node.vid
3718	LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
3719	LEFT JOIN comments comments ON node.nid = comments.nid
3720	INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
3721	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (term_data.vid in (XXX)) AND (comments.status = XXX)
3722	)) count_alias;
3723	################################################################################
3724	12 Queries
3725	user: spacetransitionn[spacetransitionn]
3726	url: localhost
3727	ip: []
3728	Taking 206246 to 240659 seconds to complete
3729	Locking for 0 to 0 seconds
3730	Average time: 223970, Median time 224085
3731	Average lock: 0, Median lock 0
3732
3733	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3734	SET timestamp=XXX;
3735	SELECT mt.*
3736	FROM
3737	message_type mt;
3738	################################################################################
3739	12 Queries
3740	user: transitionnetw_0[transitionnetw_0]
3741	url: localhost
3742	ip: []
3743	Taking 205188 to 237134 seconds to complete
3744	Locking for 0 to 0 seconds
3745	Average time: 213951, Median time 209532
3746	Average lock: 0, Median lock 0
3747
3748	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3749	use transitionnetw_XXX;
3750	SET timestamp=XXX;
3751	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3752	node.title AS node_title,
3753	node.language AS node_language,
3754	node.changed AS node_changed
3755	FROM node node
3756	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
3757	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX )
3758	)GROUP BY nid
3759	ORDER BY node_changed DESC
3760	) count_alias;
3761	################################################################################
3762	13 Queries
3763	user: transitionnetw_0[transitionnetw_0]
3764	url: localhost
3765	ip: []
3766	Taking 205384 to 237260 seconds to complete
3767	Locking for 0 to 0 seconds
3768	Average time: 218218, Median time 215986
3769	Average lock: 0, Median lock 0
3770
3771	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3772	use transitionnetw_XXX;
3773	SET timestamp=XXX;
3774	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3775	node.title AS node_title,
3776	node.language AS node_language,
3777	location_node_data_field_user_location.country AS location_node_data_field_user_location_country,
3778	node.type AS node_type,
3779	node.vid AS node_vid
3780	FROM node node
3781	LEFT JOIN content_type_profile node_data_field_user_location ON node.vid = node_data_field_user_location.vid
3782	LEFT JOIN location location_node_data_field_user_location ON node_data_field_user_location.field_user_location_lid = location_node_data_field_user_location.lid
3783	INNER JOIN users users ON node.uid = users.uid
3784	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node.status = XXX) AND (users.status <> XXX) AND (SUBSTR(node.title, XXX, XXX) = XXX)
3785	)GROUP BY nid
3786	ORDER BY node_title ASC
3787	) count_alias;
3788	################################################################################
3789	14 Queries
3790	user: transitionnetw_0[transitionnetw_0]
3791	url: localhost
3792	ip: []
3793	Taking 224353 to 240460 seconds to complete
3794	Locking for 0 to 0 seconds
3795	Average time: 231826, Median time 230408
3796	Average lock: 0, Median lock 0
3797
3798	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3799	SET timestamp=XXX;
3800	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3801	node.sticky AS node_sticky,
3802	node.created AS node_created
3803	FROM node node
3804	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX))
3805	)GROUP BY nid
3806	ORDER BY node_sticky DESC, node_created DESC
3807	) count_alias;
3808	################################################################################
3809	15 Queries
3810	user: tnpuffinwebarchn[tnpuffinwebarchn]
3811	url: localhost
3812	ip: []
3813	Taking 206237 to 241707 seconds to complete
3814	Locking for 0 to 0 seconds
3815	Average time: 225132, Median time 225293
3816	Average lock: 0, Median lock 0
3817
3818	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3819	use tnpuffinwebarchn;
3820	SET timestamp=XXX;
3821	UPDATE hosting_site SET last_cron=XXX WHERE nid=XXX;
3822	################################################################################
3823	16 Queries
3824	user: newstransition_0[newstransition_0]
3825	url: localhost
3826	ip: []
3827	Taking 204064 to 219335 seconds to complete
3828	Locking for 0 to 0 seconds
3829	Average time: 211319, Median time 211316
3830	Average lock: 0, Median lock 0
3831
3832	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3833	SET timestamp=XXX;
3834	SELECT COUNT(*) FROM (SELECT node.nid AS nid
3835	FROM node node
3836	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
3837	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
3838	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
3839	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
3840	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
3841	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3842	LEFT JOIN location location ON location_instance.lid = location.lid
3843	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < -XXX.XXX)
3844	) count_alias;
3845	################################################################################
3846	17 Queries
3847	user: transitionnetw_0[transitionnetw_0]
3848	url: localhost
3849	ip: []
3850	Taking 205316 to 240189 seconds to complete
3851	Locking for 0 to 0 seconds
3852	Average time: 229018, Median time 232917
3853	Average lock: 0, Median lock 0
3854
3855	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3856	use transitionnetw_XXX;
3857	SET timestamp=XXX;
3858	SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = XXX ORDER BY v.weight, t.weight, t.name LIMIT XXX, XXX;
3859	################################################################################
3860	18 Queries
3861	user: newstransition_0[newstransition_0]
3862	url: localhost
3863	ip: []
3864	Taking 205111 to 233453 seconds to complete
3865	Locking for 0 to 0 seconds
3866	Average time: 219845, Median time 221171
3867	Average lock: 0, Median lock 0
3868
3869	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3870	use newstransition_XXX;
3871	SET timestamp=XXX;
3872	SELECT XXX FROM access WHERE type = XXX AND XXX LIKE mask AND status = XXX LIMIT XXX, XXX;
3873	################################################################################
3874	19 Queries
3875	user: transitionnetw_0[transitionnetw_0]
3876	url: localhost
3877	ip: []
3878	Taking 232748 to 239406 seconds to complete
3879	Locking for 0 to 0 seconds
3880	Average time: 238916, Median time 239251
3881	Average lock: 0, Median lock 0
3882
3883	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3884	SET timestamp=XXX;
3885	SELECT u.name, u.uid FROM users u WHERE (u.name LIKE XXX) ORDER BY u.name ASC;
3886	################################################################################
3887	19 Queries
3888	user: transitionnetw_0[transitionnetw_0]
3889	url: localhost
3890	ip: []
3891	Taking 209277 to 240657 seconds to complete
3892	Locking for 0 to 0 seconds
3893	Average time: 227874, Median time 225458
3894	Average lock: 0, Median lock 0
3895
3896	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3897	SET timestamp=XXX;
3898	SELECT * FROM files WHERE filepath = XXX;
3899	################################################################################
3900	19 Queries
3901	user: masterpuffinwe_0[masterpuffinwe_0]
3902	url: localhost
3903	ip: []
3904	Taking 204810 to 241985 seconds to complete
3905	Locking for 0 to 0 seconds
3906	Average time: 220603, Median time 218993
3907	Average lock: 0, Median lock 0
3908
3909	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3910	SET timestamp=XXX;
3911	SELECT count(nid) FROM hosting_site WHERE (status IN (XXX));
3912	################################################################################
3913	19 Queries
3914	user: transitionnetw_0[transitionnetw_0]
3915	url: localhost
3916	ip: []
3917	Taking 213214 to 241670 seconds to complete
3918	Locking for 0 to 0 seconds
3919	Average time: 229539, Median time 228748
3920	Average lock: 0, Median lock 0
3921
3922	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3923	SET timestamp=XXX;
3924	SELECT DISTINCT s.* FROM notifications s INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid WHERE (s.uid = XXX) AND (s.type = XXX) AND (s.conditions = XXX) AND ((fXXX.field = XXX AND fXXX.intval = XXX));
3925	################################################################################
3926	20 Queries
3927	user: transitionnetw_0[transitionnetw_0]
3928	url: localhost
3929	ip: []
3930	Taking 205563 to 240407 seconds to complete
3931	Locking for 0 to 0 seconds
3932	Average time: 219367, Median time 220205
3933	Average lock: 0, Median lock 0
3934
3935	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3936	use transitionnetw_XXX;
3937	SET timestamp=XXX;
3938	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
3939	FROM node node
3940	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
3941	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
3942	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
3943	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
3944	)) count_alias;
3945	################################################################################
3946	20 Queries
3947	user: newstransition_0[newstransition_0]
3948	url: localhost
3949	ip: []
3950	Taking 204800 to 241742 seconds to complete
3951	Locking for 0 to 0 seconds
3952	Average time: 224783, Median time 225299
3953	Average lock: 0, Median lock 0
3954
3955	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3956	use newstransition_XXX;
3957	SET timestamp=XXX;
3958	DELETE FROM history WHERE timestamp < XXX;
3959	################################################################################
3960	21 Queries
3961	user: tnpuffinwebarchn[tnpuffinwebarchn]
3962	url: localhost
3963	ip: []
3964	Taking 204890 to 241869 seconds to complete
3965	Locking for 0 to 0 seconds
3966	Average time: 223273, Median time 224071
3967	Average lock: 0, Median lock 0
3968
3969	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3970	SET timestamp=XXX;
3971	SELECT n.nid, hs.last_cron, hac.cron_interval FROM node n LEFT JOIN hosting_site hs ON n.nid = hs.nid LEFT JOIN hosting_advanced_cron hac ON n.nid = hac.nid WHERE n.type = XXX AND hs.status = XXX ORDER BY hs.last_cron ASC, n.nid ASC;
3972	################################################################################
3973	21 Queries
3974	user: transitionnetw_0[transitionnetw_0]
3975	url: localhost
3976	ip: []
3977	Taking 204946 to 241920 seconds to complete
3978	Locking for 0 to 0 seconds
3979	Average time: 223973, Median time 222255
3980	Average lock: 0, Median lock 0
3981
3982	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
3983	SET timestamp=XXX;
3984	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
3985	node.title AS node_title,
3986	node.language AS node_language,
3987	location.province AS location_province,
3988	location.country AS location_country,
3989	node_data_field_status.field_status_value AS node_data_field_status_field_status_value,
3990	node.type AS node_type,
3991	node.vid AS node_vid
3992	FROM node node
3993	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
3994	LEFT JOIN location location ON location_instance.lid = location.lid
3995	LEFT JOIN content_type_initiative_profile node_data_field_status ON node.vid = node_data_field_status.vid
3996	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX, XXX)) AND (node.status = XXX) AND (SUBSTR(node.title, XXX, XXX) = XXX)
3997	)GROUP BY nid
3998	ORDER BY node_title ASC
3999	) count_alias;
4000	################################################################################
4001	23 Queries
4002	user: masterpuffinwe_0[masterpuffinwe_0]
4003	url: localhost
4004	ip: []
4005	Taking 203800 to 241963 seconds to complete
4006	Locking for 0 to 0 seconds
4007	Average time: 223031, Median time 223966
4008	Average lock: 0, Median lock 0
4009
4010	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4011	SET timestamp=XXX;
4012	DELETE FROM history WHERE timestamp < XXX;
4013	################################################################################
4014	23 Queries
4015	user: transitionnetw_0[transitionnetw_0]
4016	url: localhost
4017	ip: []
4018	Taking 202861 to 239432 seconds to complete
4019	Locking for 0 to 0 seconds
4020	Average time: 218533, Median time 215867
4021	Average lock: 0, Median lock 0
4022
4023	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4024	SET timestamp=XXX;
4025	SELECT vid, nid, field_profile_photo_fid AS fid, field_profile_photo_list AS list, field_profile_photo_data AS data
4026	FROM content_type_profile
4027	WHERE field_profile_photo_fid = XXX;
4028	################################################################################
4029	23 Queries
4030	user: tnpuffinwebarchn[tnpuffinwebarchn]
4031	url: localhost
4032	ip: []
4033	Taking 206231 to 241847 seconds to complete
4034	Locking for 0 to 0 seconds
4035	Average time: 222521, Median time 220496
4036	Average lock: 0, Median lock 0
4037
4038	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4039	use tnpuffinwebarchn;
4040	SET timestamp=XXX;
4041	SELECT count(nid) FROM hosting_site WHERE (status IN (XXX));
4042	################################################################################
4043	24 Queries
4044	user: transitionnetw_0[transitionnetw_0]
4045	url: localhost
4046	ip: []
4047	Taking 211145 to 240536 seconds to complete
4048	Locking for 0 to 0 seconds
4049	Average time: 225426, Median time 226317
4050	Average lock: 0, Median lock 0
4051
4052	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4053	SET timestamp=XXX;
4054	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
4055	node.title AS node_title,
4056	node.language AS node_language,
4057	node.changed AS node_changed
4058	FROM node node
4059	LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
4060	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX)) AND (og_ancestry.group_nid = XXX )
4061	)GROUP BY nid
4062	ORDER BY node_changed DESC
4063	) count_alias;
4064	################################################################################
4065	27 Queries
4066	user: transitionnetw_0[transitionnetw_0]
4067	url: localhost
4068	ip: []
4069	Taking 205045 to 240657 seconds to complete
4070	Locking for 0 to 0 seconds
4071	Average time: 225045, Median time 225157
4072	Average lock: 0, Median lock 0
4073
4074	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4075	use transitionnetw_XXX;
4076	SET timestamp=XXX;
4077	SELECT f.*, u.nid FROM files f INNER JOIN upload u ON f.fid = u.fid WHERE filepath = XXX;
4078	################################################################################
4079	30 Queries
4080	user: masterpuffinwe_0[masterpuffinwe_0]
4081	url: localhost
4082	ip: []
4083	Taking 205454 to 241956 seconds to complete
4084	Locking for 0 to 0 seconds
4085	Average time: 222431, Median time 222062
4086	Average lock: 0, Median lock 0
4087
4088	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4089	use masterpuffinwe_XXX;
4090	SET timestamp=XXX;
4091	SELECT n.nid FROM node n LEFT JOIN hosting_site s ON n.nid=s.nid WHERE n.type=XXX and s.status = XXX ORDER BY s.last_cron ASC, n.nid ASC;
4092	################################################################################
4093	31 Queries
4094	user: transitionnetw_0[transitionnetw_0]
4095	url: localhost
4096	ip: []
4097	Taking 208996 to 242078 seconds to complete
4098	Locking for 0 to 0 seconds
4099	Average time: 221195, Median time 222450
4100	Average lock: 0, Median lock 0
4101
4102	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4103	use transitionnetw_XXX;
4104	SET timestamp=XXX;
4105	SELECT name FROM users WHERE LOWER(mail) = LOWER(XXX);
4106	################################################################################
4107	32 Queries
4108	user: transitionnetw_0[transitionnetw_0]
4109	url: localhost
4110	ip: []
4111	Taking 205218 to 240893 seconds to complete
4112	Locking for 0 to 0 seconds
4113	Average time: 227674, Median time 227268
4114	Average lock: 0, Median lock 0
4115
4116	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4117	SET timestamp=XXX;
4118	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
4119	node.sticky AS node_sticky,
4120	node.created AS node_created
4121	FROM node node
4122	INNER JOIN users users ON node.uid = users.uid
4123	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.status = XXX) AND (node.type in (XXX, XXX)) AND (users.name = XXX)
4124	)GROUP BY nid
4125	ORDER BY node_sticky DESC, node_created DESC
4126	) count_alias;
4127	################################################################################
4128	33 Queries
4129	user: transitionnetw_0[transitionnetw_0]
4130	url: localhost
4131	ip: []
4132	Taking 204972 to 241698 seconds to complete
4133	Locking for 0 to 0 seconds
4134	Average time: 225511, Median time 228271
4135	Average lock: 0, Median lock 0
4136
4137	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4138	SET timestamp=XXX;
4139	SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = XXX ORDER BY v.weight, t.weight, t.name LIMIT XXX, XXX;
4140	################################################################################
4141	34 Queries
4142	user: newstransition_0[newstransition_0]
4143	url: localhost
4144	ip: []
4145	Taking 209975 to 241489 seconds to complete
4146	Locking for 0 to 0 seconds
4147	Average time: 230085, Median time 232664
4148	Average lock: 0, Median lock 0
4149
4150	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4151	use newstransition_XXX;
4152	SET timestamp=XXX;
4153	SELECT node.nid AS nid,
4154	feeds_data_feed_fast.title AS feeds_data_feed_fast_title,
4155	feeds_data_feed_fast.timestamp AS feeds_data_feed_fast_timestamp,
4156	feeds_data_feed_fast.url AS feeds_data_feed_fast_url,
4157	feeds_data_feed_fast.description AS feeds_data_feed_fast_description,
4158	node.title AS node_title,
4159	node.vid AS node_vid,
4160	location.latitude AS location_latitude,
4161	location.longitude AS location_longitude
4162	FROM node node
4163	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
4164	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
4165	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
4166	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
4167	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
4168	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
4169	LEFT JOIN location location ON location_instance.lid = location.lid
4170	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > XXX.XXX AND location.longitude < XXX.XXX)
4171	ORDER BY feeds_data_feed_fast_timestamp DESC
4172	LIMIT XXX, XXX;
4173	################################################################################
4174	36 Queries
4175	user: transitionnetw_0[transitionnetw_0]
4176	url: localhost
4177	ip: []
4178	Taking 206433 to 240454 seconds to complete
4179	Locking for 0 to 0 seconds
4180	Average time: 226477, Median time 229329
4181	Average lock: 0, Median lock 0
4182
4183	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4184	SET timestamp=XXX;
4185	SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid
4186	FROM node node
4187	INNER JOIN content_type_event node_data_field_event_type ON node.vid = node_data_field_event_type.vid
4188	LEFT JOIN content_field_occurs node_data_field_occurs ON node.vid = node_data_field_occurs.vid
4189	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( ((node.status = XXX) AND (node.type in (XXX)) AND (node_data_field_event_type.field_event_type_value = XXX))
4190	AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_occurs.field_occurs_valueXXX, XXX), SEC_TO_TIME(XXX)), XXX) >= XXX)
4191	)) count_alias;
4192	################################################################################
4193	37 Queries
4194	user: transitionnetw_0[transitionnetw_0]
4195	url: localhost
4196	ip: []
4197	Taking 205239 to 241671 seconds to complete
4198	Locking for 0 to 0 seconds
4199	Average time: 226178, Median time 227046
4200	Average lock: 0, Median lock 0
4201
4202	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4203	use transitionnetw_XXX;
4204	SET timestamp=XXX;
4205	SELECT * FROM variable;
4206	################################################################################
4207	37 Queries
4208	user: transitionnetw_0[transitionnetw_0]
4209	url: localhost
4210	ip: []
4211	Taking 205204 to 241511 seconds to complete
4212	Locking for 0 to 0 seconds
4213	Average time: 221256, Median time 220070
4214	Average lock: 0, Median lock 0
4215
4216	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4217	SET timestamp=XXX;
4218	SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
4219	node.title AS node_title,
4220	node.language AS node_language,
4221	location_node_data_field_user_location.country AS location_node_data_field_user_location_country,
4222	node.type AS node_type,
4223	node.vid AS node_vid
4224	FROM node node
4225	LEFT JOIN content_type_profile node_data_field_user_location ON node.vid = node_data_field_user_location.vid
4226	LEFT JOIN location location_node_data_field_user_location ON node_data_field_user_location.field_user_location_lid = location_node_data_field_user_location.lid
4227	INNER JOIN users users ON node.uid = users.uid
4228	INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= XXX AND ((na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX) OR (na.gid = XXX AND na.realm = XXX))) AND ( (node.type in (XXX)) AND (node.status = XXX) AND (users.status <> XXX) AND (SUBSTR(node.title, XXX, XXX) = XXX)
4229	)GROUP BY nid
4230	ORDER BY node_title ASC
4231	) count_alias;
4232	################################################################################
4233	49 Queries
4234	user: transitionnetw_0[transitionnetw_0]
4235	url: localhost
4236	ip: []
4237	Taking 206140 to 239563 seconds to complete
4238	Locking for 0 to 0 seconds
4239	Average time: 221290, Median time 218065
4240	Average lock: 0, Median lock 0
4241
4242	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4243	SET timestamp=XXX;
4244	SELECT DISTINCT s.* FROM notifications s INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid INNER JOIN notifications_fields fXXX ON fXXX.sid = s.sid WHERE (s.mdid = XXX) AND (s.type = XXX) AND (s.event_type = XXX) AND (s.module = XXX) AND (s.send_interval = XXX) AND (s.conditions = XXX) AND ((fXXX.field = XXX AND fXXX.intval = XXX) AND (fXXX.field = XXX AND fXXX.value = XXX));
4245	################################################################################
4246	51 Queries
4247	user: transitionnetw_0[transitionnetw_0]
4248	url: localhost
4249	ip: []
4250	Taking 204688 to 241391 seconds to complete
4251	Locking for 0 to 0 seconds
4252	Average time: 223274, Median time 224689
4253	Average lock: 0, Median lock 0
4254
4255	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4256	SET timestamp=XXX;
4257	DELETE FROM semaphore WHERE value = XXX;
4258	################################################################################
4259	67 Queries
4260	user: transitionnetw_0[transitionnetw_0]
4261	url: localhost
4262	ip: []
4263	Taking 203821 to 241842 seconds to complete
4264	Locking for 0 to 0 seconds
4265	Average time: 227997, Median time 229164
4266	Average lock: 0, Median lock 0
4267
4268	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4269	use transitionnetw_XXX;
4270	SET timestamp=XXX;
4271	SELECT t.*,v.weight AS v_weight_unused FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = XXX ORDER BY v.weight, t.weight, t.name;
4272	################################################################################
4273	69 Queries
4274	user: newstransition_0[newstransition_0]
4275	url: localhost
4276	ip: []
4277	Taking 203892 to 219326 seconds to complete
4278	Locking for 0 to 0 seconds
4279	Average time: 212141, Median time 212082
4280	Average lock: 0, Median lock 0
4281
4282	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4283	use newstransition_XXX;
4284	SET timestamp=XXX;
4285	SELECT COUNT(*) FROM (SELECT node.nid AS nid
4286	FROM node node
4287	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
4288	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
4289	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
4290	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
4291	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
4292	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
4293	LEFT JOIN location location ON location_instance.lid = location.lid
4294	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < -XXX.XXX)
4295	) count_alias;
4296	################################################################################
4297	72 Queries
4298	user: transitionnetw_0[transitionnetw_0]
4299	url: localhost
4300	ip: []
4301	Taking 205607 to 241560 seconds to complete
4302	Locking for 0 to 0 seconds
4303	Average time: 224968, Median time 225068
4304	Average lock: 0, Median lock 0
4305
4306	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4307	SET timestamp=XXX;
4308	SELECT name FROM users WHERE LOWER(mail) = LOWER(XXX);
4309	################################################################################
4310	74 Queries
4311	user: transitionnetw_0[transitionnetw_0]
4312	url: localhost
4313	ip: []
4314	Taking 203915 to 241842 seconds to complete
4315	Locking for 0 to 0 seconds
4316	Average time: 228264, Median time 230046
4317	Average lock: 0, Median lock 0
4318
4319	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4320	SET timestamp=XXX;
4321	SELECT f.*, u.nid FROM files f INNER JOIN upload u ON f.fid = u.fid WHERE filepath = XXX;
4322	################################################################################
4323	84 Queries
4324	user: newstransition_0[newstransition_0]
4325	url: localhost
4326	ip: []
4327	Taking 212657 to 240884 seconds to complete
4328	Locking for 0 to 0 seconds
4329	Average time: 228971, Median time 228452
4330	Average lock: 0, Median lock 0
4331
4332	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4333	use newstransition_XXX;
4334	SET timestamp=XXX;
4335	SELECT node.nid AS nid,
4336	feeds_data_feed_fast.title AS feeds_data_feed_fast_title,
4337	feeds_data_feed_fast.timestamp AS feeds_data_feed_fast_timestamp,
4338	feeds_data_feed_fast.url AS feeds_data_feed_fast_url,
4339	feeds_data_feed_fast.description AS feeds_data_feed_fast_description,
4340	node.title AS node_title,
4341	node.vid AS node_vid,
4342	location.latitude AS location_latitude,
4343	location.longitude AS location_longitude
4344	FROM node node
4345	LEFT JOIN content_type_transition_se_feed_meta node_data_field_location ON node.vid = node_data_field_location.vid
4346	INNER JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
4347	LEFT JOIN feeds_data_feed_fast feeds_data_feed_fast ON node.nid = feeds_data_feed_fast.feed_nid
4348	INNER JOIN node node_feeds_data_feed_fast ON feeds_data_feed_fast.feed_nid = node_feeds_data_feed_fast.nid
4349	INNER JOIN term_node term_node_value_XXX ON node.vid = term_node_value_XXX.vid AND term_node_value_XXX.tid = XXX
4350	LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
4351	LEFT JOIN location location ON location_instance.lid = location.lid
4352	WHERE (term_node_value_XXX.tid = XXX) AND (location.latitude > XXX.XXX AND location.latitude < XXX.XXX AND location.longitude > -XXX.XXX AND location.longitude < -XXX.XXX)
4353	ORDER BY feeds_data_feed_fast_timestamp DESC
4354	LIMIT XXX, XXX;
4355	################################################################################
4356	230 Queries
4357	user: transitionnetw_0[transitionnetw_0]
4358	url: localhost
4359	ip: []
4360	Taking 204671 to 241999 seconds to complete
4361	Locking for 0 to 0 seconds
4362	Average time: 230513, Median time 232564
4363	Average lock: 0, Median lock 0
4364
4365	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4366	SET timestamp=XXX;
4367	SELECT t.*,v.weight AS v_weight_unused FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = XXX ORDER BY v.weight, t.weight, t.name;
4368	################################################################################
4369	293 Queries
4370	user: masterpuffinwe_0[masterpuffinwe_0]
4371	url: localhost
4372	ip: []
4373	Taking 203156 to 242077 seconds to complete
4374	Locking for 0 to 0 seconds
4375	Average time: 221657, Median time 220484
4376	Average lock: 0, Median lock 0
4377
4378	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4379	use masterpuffinwe_XXX;
4380	SET timestamp=XXX;
4381	SELECT * FROM variable;
4382	################################################################################
4383	297 Queries
4384	user: tnpuffinwebarchn[tnpuffinwebarchn]
4385	url: localhost
4386	ip: []
4387	Taking 204781 to 241705 seconds to complete
4388	Locking for 0 to 0 seconds
4389	Average time: 221752, Median time 220560
4390	Average lock: 0, Median lock 0
4391
4392	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4393	use tnpuffinwebarchn;
4394	SET timestamp=XXX;
4395	SELECT * FROM variable;
4396	################################################################################
4397	302 Queries
4398	user: transitionnetw_0[transitionnetw_0]
4399	url: localhost
4400	ip: []
4401	Taking 203267 to 241990 seconds to complete
4402	Locking for 0 to 0 seconds
4403	Average time: 221625, Median time 220566
4404	Average lock: 0, Median lock 0
4405
4406	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4407	use transitionnetw_XXX;
4408	SET timestamp=XXX;
4409	SELECT XXX FROM access WHERE type = XXX AND XXX LIKE mask AND status = XXX LIMIT XXX, XXX;
4410	################################################################################
4411	428 Queries
4412	user: tnpuffinwebarchn[tnpuffinwebarchn]
4413	url: localhost
4414	ip: []
4415	Taking 203800 to 241968 seconds to complete
4416	Locking for 0 to 0 seconds
4417	Average time: 222136, Median time 221042
4418	Average lock: 0, Median lock 0
4419
4420	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4421	SET timestamp=XXX;
4422	SELECT * FROM variable;
4423	################################################################################
4424	634 Queries
4425	user: transitionnetw_0[transitionnetw_0]
4426	url: localhost
4427	ip: []
4428	Taking 203391 to 242034 seconds to complete
4429	Locking for 0 to 0 seconds
4430	Average time: 223762, Median time 223813
4431	Average lock: 0, Median lock 0
4432
4433	# Query_time: XXX.XXX Lock_time: XXX.XXX Rows_sent: XXX Rows_examined: XXX
4434	SET timestamp=XXX;
4435	SELECT XXX FROM access WHERE type = XXX AND XXX LIKE mask AND status = XXX LIMIT XXX, XXX;

Download in other formats:

Original Format