dave's profile

Threads: 2

Comments: 1

Registered: 5 years ago

Often used Tags: What are tags?

Recent Threads: View All

Ruby on Rails framework 5 years ago by dave with 5 comments. Tags: 1l, rubyonrails, college, bored Hey guys, haven't been here in a while. College has put a different perspective on what I spend my time doing online, but you can never really forget some things of particular interest. What if we...

Nice 5 years ago by dave with 11 comments. Tags: nice, 1l, idea Nice, so simple, and sleek too.

The Wall

| View All

wall-to-wall

5 years ago, k4st wrote:

wall-to-wall

5 years ago, k4st wrote:

So you like it sofar?

Query	Query Time	Affected Rows
SELECT * FROM k4_users WHERE user_id=15 GROUP BY user_id LIMIT 1	0.6011	1
SELECT t.tag_name, COUNT(tt.tag_id) AS tag_count FROM k4_tags t, k4_thread_users tu JOIN k4_thread_tags tt USING (thread_id) WHERE t.tag_id=tt.tag_id AND tu.thread_id=tt.thread_id AND tu.user_id=15 GROUP BY t.tag_id ORDER BY tag_count DESC, t.tag_name ASC LIMIT 0,50	0.6026	6
SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu WHERE t.user_id=15 AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id ORDER BY created DESC LIMIT 10	0.6066	2
SELECT wp.*, u.name AS poster_name FROM k4_wall_posts wp LEFT JOIN k4_users u ON wp.poster_id=u.user_id WHERE wp.user_id=15 AND (wp.private < 1 OR wp.private=1 AND wp.poster_id=1) GROUP BY wp.post_id ORDER BY created DESC LIMIT 10	0.609	2

Query

Query Time

Affected Rows

SELECT * FROM k4_users WHERE user_id=15 GROUP BY user_id LIMIT 1

0.6011

1

SELECT t.tag_name, COUNT(tt.tag_id) AS tag_count FROM k4_tags t, k4_thread_users tu JOIN k4_thread_tags tt USING (thread_id) WHERE t.tag_id=tt.tag_id AND tu.thread_id=tt.thread_id AND tu.user_id=15 GROUP BY t.tag_id ORDER BY tag_count DESC, t.tag_name ASC LIMIT 0,50

0.6026

6

SELECT DISTINCT t.thread_id, t.*, ts.tag_name, GROUP_CONCAT(ts.tag_name SEPARATOR ',') AS tags, u.name AS user_name, uu.name AS edit_user_name FROM k4_thread_tags tt, k4_tags ts, k4_threads t, k4_users u, k4_users uu WHERE t.user_id=15 AND t.thread_id=tt.thread_id AND ts.tag_id=tt.tag_id AND t.user_id=u.user_id AND t.edit_user_id=uu.user_id GROUP BY t.thread_id ORDER BY created DESC LIMIT 10

0.6066

2

SELECT wp.*, u.name AS poster_name FROM k4_wall_posts wp LEFT JOIN k4_users u ON wp.poster_id=u.user_id WHERE wp.user_id=15 AND (wp.private < 1 OR wp.private=1 AND wp.poster_id=1) GROUP BY wp.post_id ORDER BY created DESC LIMIT 10

dave's profile

The Wall

0.6011

1

0.6026

6

0.6066

2

0.609

2