DEV BUILD (branch: deploy) - NOT FOR PUBLIC USE
 

Check out our latest Fleet Action!

 

Test 1

Description

This is a test

Criteria

  • Test

Winners

Submissions

Managed By the

Office of the Chief of Staff

This service is managed by the Office of the Chief of Staff. If you have questions about this service, please contact an office staff member.

Load Time: 0.52 seconds

Total SQL Queries: 117

1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '141167' AND wp_posts.post_type = 'competition' ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (57386) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140034) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 140034 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141379) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141379 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 63687 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120430) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 120430 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (124110) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 124110 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141300) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141300 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 57386 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (130166) ORDER BY meta_id ASC
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 = '2121' ) ) 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 (27493) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 27493 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (22416) ORDER BY meta_id ASC
1 SELECT wp_posts.* 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 = '2121' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (100181) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 100181 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141628) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141628 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141627) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141414 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 = '2208' ) ) 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 = 130166 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 130094 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 39959 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 43189 LIMIT 1
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 = 13085 LIMIT 1
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 (35640) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 35640 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (43189) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141377) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 130078 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141377 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 41676 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120199) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16348 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140177) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 53711 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (139971) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 63693 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (130078) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 120199 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 140177 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 139971 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (39959) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29604) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141167) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141808 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141801 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141799 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141797 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141794 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141791 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141740 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141631 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141625 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141627 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141416 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141806 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141810 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141822 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141812 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141814 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141816 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141818 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 = 86412 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18640) ORDER BY meta_id ASC
1 SELECT wp_posts.* 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
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141390,141378,141376) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'competition' AND wp_postmeta.meta_value = '141167' ) ) AND wp_posts.post_type = 'competition_sub' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'pending')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1759) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '1759' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141820 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141824 LIMIT 1
1 SELECT wp_posts.* 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 = '2208' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2208) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (97970) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 97970 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141626) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141626 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141625) ORDER BY meta_id ASC
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 = '2468' ) ) 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 (56930) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 56930 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (52541) ORDER BY meta_id ASC
1 SELECT wp_posts.* 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 = '2468' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2121) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2121' LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '2208' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141826 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2468) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2468' LIMIT 1
1 SELECT DISTINCT p.* FROM wp_posts p INNER JOIN wp_postmeta AS pm ON pm.post_id = p.ID WHERE p.post_type = "events" AND pm.meta_key LIKE "event_comps_%_competition" AND pm.meta_value = 141167;
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 = 86415 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141833) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141833 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141832) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141830 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141832 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141828 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1