| 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; |