Load Time: 0.69 seconds
Total SQL Queries: 79
| 2 | SELECT id, user_id, award_id, post_id, game_id, ribbon_count, word_count, approver_user_id, date, description, approved_date FROM bfms_ribbons WHERE id = 19581 |
| 1 | SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '669' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 78890 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140308) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 140308 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49761) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 79869 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 49761 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 79941 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 62011 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 91841 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 91858 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 92088 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 92440 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 120389 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 123107 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 125183 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 78526 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 58736 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (101623) ORDER BY meta_id ASC |
| 1 | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('group_news_category') AND tr.object_id IN (173660, 173993) ORDER BY t.name ASC |
| 1 | SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment') |
| 1 | SELECT * FROM wp_posts WHERE ID = 88217 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 32091 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170919) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (170919) |
| 1 | SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'event_status' AND wp_postmeta.meta_value = 'In Progress' ) AND ( mt1.meta_key = 'event_type' AND mt1.meta_value IN ('fleet_action','fiction_campaign') ) ) AND wp_posts.post_type = 'events' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (173660,173993) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (173993,173660) |
| 1 | SELECT * FROM wp_posts WHERE ID = 52608 LIMIT 1 |
| 1 | SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'group_news' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 2 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (162678) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 162678 LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2425) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2425' LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 50653 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 52609 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 127238 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 101623 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (0) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (837) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29114) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 29114 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (57228) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 162495 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 57228 LIMIT 1 |
| 1 | SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2425' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18790) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (50450, 35121, 31032, 18790, 18572) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 31802 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (50450,35121,31032,18790,18572) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2425,2223,837,2266,669) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (162495,162440,162428,162384,154537,150913,150228,99460,133227,127238,125183,123107,120389,92440,92088,91858,91841,79941,79869,78890,78526,62011,58736,52608,52609,50653) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281, 19281) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19281) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (19281) AND wp_posts.post_type = 'award' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT t2.* FROM bfms_ribbons as t1 INNER JOIN bfms_ribbons as t2 ON t1.award_id = t2.award_id AND t1.user_id = t2.user_id WHERE t1.id = 19581 AND t2.approver_user_id IS NOT NULL ORDER BY t2.date DESC |
| 1 | SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2223' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31802) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (71721) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 162384 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 133227 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 71721 LIMIT 1 |
| 1 | SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2266' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 99460 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 150228 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 150913 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 154537 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147962) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 45544 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 147962 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (24691) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 162428 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 24691 LIMIT 1 |
| 1 | SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '837' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 162440 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (45544) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |