Load Time: 1 seconds
Total SQL Queries: 137
2 | SELECT id, user_id, award_id, post_id, game_id, ribbon_count, word_count, approver_user_id, date, description FROM bfms_ribbons WHERE id = 3922 |
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 = '1356' ) ) 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 = 40599 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40738 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40876 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (39638) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 39638 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33287) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 42629 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 33287 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (23607) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 23607 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (13085) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 43558 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 13085 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 44206 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 39973 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 44499 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 44503 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 45059 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 46789 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 47055 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 47436 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141744) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 141744 LIMIT 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 = 48447 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 * FROM wp_posts WHERE ID = 49214 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 49531 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 39981 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 39612 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 53159 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 ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment') |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (122202) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (122202) |
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 (140618,140922) 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 (140618, 140922) ORDER BY t.name ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (140922,140618) |
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 (64972) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 64972 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 36824 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 36832 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 36836 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 36990 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 49387 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38814 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 = 37000 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 = 37437 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 37439 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38203 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38205 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38208 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38216 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38224 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38226 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38228 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38808 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 52508 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 53803 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 (35488, 33203, 20144, 18806, 18790, 18640, 18279) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 93140 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 93149 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 93275 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (50679) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 50679 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 = 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 (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 (27480) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 93562 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 27480 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 = '2184' ) ) 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 (35488,33203,18806,18640,18279) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 78809 LIMIT 1 |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (837,2109,2269,1759,1356,2240,1036) 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 (27204, 20144, 18790) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (20144,18790) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2184,837,2109) 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 (27204) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27204) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2184) 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 (39612,38814,38808,38228,38226,38224,38216,38208,38205,38203,37439,37437,37000,36990,36836,36832,36824,0) AND wp_posts.post_type = 'post' 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 (93562,93275,93149,93140,88374,78809,73148,72745,67508,65820,65818,65814,61022,58307,59738,59736,59734,59732,59730,59728,59726,57959,56221,56190,55574,55145,54792,54607,54240,53985,53803,53159,52508,49531,49214,48447,47436,47055,46789,45059,44503,44499,44206,43558,42629,40876,40738,40599,39981,39973) 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) ORDER BY meta_id ASC |
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, 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 = 3922 AND t2.approver_user_id IS NOT NULL ORDER BY t2.date DESC |
1 | SELECT * FROM wp_posts WHERE ID = 88374 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 73148 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 53985 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (21788) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (41139) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 41139 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35486) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 54240 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 35486 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 = '2269' ) ) 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 = 54607 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 54792 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 55145 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 55574 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 56190 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 56221 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (58039) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 58039 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 57959 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 72745 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 59738 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 67508 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 65820 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 65818 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 65814 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 61022 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 58307 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 59736 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 21788 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 59734 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 59732 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 59730 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 59728 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 59726 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 = '2109' ) ) 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 = 12371 LIMIT 1 |