Debian Codegraph @

test/slow-logs/slow014.log

raw
1 # User@Host: root[root] @ localhost []
2 # Thread_id: 103375137 Schema: db1 Last_errno: 0 Killed: 0
3 # Query_time: 0.000179 Lock_time: 0.000047 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0 Rows_read: 1
4 # Bytes_sent: 2004 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
5 # InnoDB_trx_id: 2552F3B37
6 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
7 # Filesort: No Filesort_on_disk: No Merge_passes: 0
8 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
9 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
10 # InnoDB_pages_distinct: 3
11 SET timestamp=1398555955;
12 SELECT * FROM cache
13 WHERE `cacheid` IN ('id15965');
14 # User@Host: root[root] @ localhost []
15 # Thread_id: 103375137 Schema: db1 Last_errno: 0 Killed: 0
16 # Query_time: 0.000628 Lock_time: 0.000161 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0
17 # Bytes_sent: 323 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0
18 # InnoDB_trx_id: 2552F3B38
19 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
20 # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
21 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
22 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
23 # InnoDB_pages_distinct: 3
24 SET timestamp=1398555955;
25 ### Channels ###
26 SELECT sourcetable, IF(f.lastcontent = 0, f.lastupdate, f.lastcontent) AS lastactivity,
27 f.totalcount AS activity, type.class AS type,
28 (f.nodeoptions & 512) AS noUnsubscribe
29 FROM node AS f
30 INNER JOIN contenttype AS type ON type.contenttypeid = f.contenttypeid
31
32 INNER JOIN subscribed AS sd ON sd.did = f.nodeid AND sd.userid = 15965
33 UNION ALL
34
35 ### Users ###
36 SELECT f.name AS title, f.userid AS keyval, 'user' AS sourcetable, IFNULL(f.lastpost, f.joindate) AS lastactivity,
37 f.posts as activity, 'Member' AS type,
38 0 AS noUnsubscribe
39 FROM user AS f
40 INNER JOIN userlist AS ul ON ul.relationid = f.userid AND ul.userid = 15965
41 WHERE ul.type = 'f' AND ul.aq = 'yes'
42 ORDER BY title ASC LIMIT 100;
43 # User@Host: root[root] @ localhost []
44 # Thread_id: 103375137 Schema: db1 Last_errno: 0 Killed: 0
45 # Query_time: 0.000420 Lock_time: 0.000116 Rows_sent: 1 Rows_examined: 0 Rows_affected: 0 Rows_read: 0
46 # Bytes_sent: 60 Tmp_tables: 2 Tmp_disk_tables: 0 Tmp_table_sizes: 0
47 # InnoDB_trx_id: 2552F3B39
48 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
49 # Filesort: No Filesort_on_disk: No Merge_passes: 0
50 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
51 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
52 # InnoDB_pages_distinct: 3
53 SET timestamp=1398555955;
54 SELECT COUNT(userfing.keyval) AS total
55 FROM
56 ((### All Content ###
57 SELECT f.nodeid AS keyval
58 FROM node AS f
59 INNER JOIN subscribed AS sd ON sd.did = f.nodeid AND sd.userid = 15965) UNION ALL (
60 ### Users ###
61 SELECT f.userid AS keyval
62 FROM user AS f
63 INNER JOIN userlist AS ul ON ul.relationid = f.userid AND ul.userid = 15965
64 WHERE ul.type = 'f' AND ul.aq = 'yes')
65 ) AS userfing;
66 # User@Host: root[root] @ localhost []
67 # Thread_id: 103375137 Schema: db1 Last_errno: 0 Killed: 0
68 # Query_time: 0.000457 Lock_time: 0.000144 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0
69 # Bytes_sent: 359 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0
70 # InnoDB_trx_id: 2552F3B3A
71 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
72 # Filesort: Yes Filesort_on_disk: No Merge_passes: 0
73 # InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
74 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
75 # InnoDB_pages_distinct: 1
76 SET timestamp=1398555955;
77 SELECT u.userid, u.name AS name, u.usergroupid AS usergroupid, IFNULL(u.lastactivity, u.joindate) as lastactivity,
78 IFNULL((SELECT userid FROM userlist AS ul2 WHERE ul2.userid = 15965 AND ul2.relationid = u.userid AND ul2.type = 'f' AND ul2.aq = 'yes'), 0) as isFollowing,
79 IFNULL((SELECT userid FROM userlist AS ul2 WHERE ul2.userid = 15965 AND ul2.relationid = u.userid AND ul2.type = 'f' AND ul2.aq = 'pending'), 0) as isPending
80 FROM user AS u
81 INNER JOIN userlist AS ul ON (u.userid = ul.userid AND ul.relationid = 15965)
82
83 WHERE ul.type = 'f' AND ul.aq = 'yes'
84 ORDER BY name ASC
85 LIMIT 0, 100;