Load Time: 1.9 seconds
Total SQL Queries: 98
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 = 14000 |
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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86412) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 38616 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 86412 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 = '1759' ) ) 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 (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 = 8 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 49761 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49387) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86415) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 49387 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16756) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 39441 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 16756 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 = '1036' ) ) 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 = 46727 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 51347 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 54181 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 59139 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 86415 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 = '2240' ) ) 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 = 60242 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147855) ORDER BY meta_id 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 = 136019 LIMIT 1 |
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 = 'fleet_action' ) ) 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 (159902,159903) 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 (159902, 159903) ORDER BY t.name ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (159903,159902) |
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 (145801) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 145801 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 147855 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 33287 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147854) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 147854 LIMIT 1 |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2266) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2266' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29444) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 29444 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27965) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 36519 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 27965 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 = '25' ) ) 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 = 59725 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 61504 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33203, 18806, 18790, 18640, 18572, 18328) ORDER BY meta_id ASC |
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 = 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29111) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 29111 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (138222) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 137879 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 138222 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33203,18806,18640,18572,18328) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147962) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (837,1036,669,1759,2240,25) 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 (35121, 31032, 18790, 18679) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35121,31032,18790,18679) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2266,837,2223,694) 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 (137879,136672,132101,130350,101306,101227,101199,101195,72585,69728,69949,68609,67541,65861,61515,61504,60242,59725,59139,54181,51347,46727,39441,8,38616,36519) 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 (19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278, 19278) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19278) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (19278) 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 = 14000 AND t2.approver_user_id IS NOT NULL ORDER BY t2.date DESC |
1 | SELECT * FROM wp_posts WHERE ID = 147962 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 = '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 * FROM wp_posts WHERE ID = 61515 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (72349) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 65861 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 67541 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 68609 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 69949 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 69728 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 72585 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 101195 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 101199 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 101227 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 72349 LIMIT 1 |
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 (8915) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 101306 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 8915 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 = '694' ) ) 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 = 130350 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 132101 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 = 45544 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31802) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 136672 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |