This year we awarded $72,000 to 13 teams to help them realize their ideas with communities around the world
May 13, 2013 to May 13, 2014.
See the
Competition Lifecycle » 
![]()
IDEAS Global Challenge invites the worldwide MIT community and their collaborators to participate in student-led innovation as public service. Learn more...
SUPPORTED BY: See all 
Support MIT IDEAS Global Challenge:
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `grantitems` | 9 | 9 | 0 | |
| 2 | DESCRIBE `grants_users` | 4 | 4 | 0 | |
| 3 | DESCRIBE `proposals_users` | 4 | 4 | 0 | |
| 4 | DESCRIBE `teams_users` | 5 | 5 | 0 | |
| 5 | DESCRIBE `problem_followers` | 5 | 5 | 0 | |
| 6 | DESCRIBE `updates` | 7 | 7 | 0 | |
| 7 | DESCRIBE `categories` | 4 | 4 | 0 | |
| 8 | DESCRIBE `help` | 12 | 12 | 0 | |
| 9 | DESCRIBE `helptypes` | 5 | 5 | 0 | |
| 10 | DESCRIBE `help_categories` | 3 | 3 | 0 | |
| 11 | DESCRIBE `categories_teams` | 3 | 3 | 0 | |
| 12 | DESCRIBE `problems_categories` | 3 | 3 | 0 | |
| 13 | DESCRIBE `challenges` | 8 | 8 | 0 | |
| 14 | DESCRIBE `challenges_categories` | 3 | 3 | 0 | |
| 15 | DESCRIBE `teams_partners` | 11 | 11 | 0 | |
| 16 | DESCRIBE `teams_invites` | 7 | 7 | 0 | |
| 17 | DESCRIBE `videos` | 11 | 11 | 0 | |
| 18 | DESCRIBE `team_followers` | 5 | 5 | 0 | |
| 19 | DESCRIBE `competitions` | 21 | 21 | 0 | |
| 20 | SELECT `Competition`.`id`, `Competition`.`allow_initial_proposals`, `Competition`.`allow_final_proposals`, `Competition`.`allow_voting`, `Competition`.`show_create_team_cta`, `Competition`.`comp_year`, `Competition`.`team_comp_year`, `Competition`.`allow_cert_registration`, `Competition`.`allow_cert_login`, `Competition`.`allow_grants`, `Competition`.`enable_optin`, `Competition`.`show_explore_problems`, `Competition`.`show_discover_teams`, `Competition`.`show_join_support`, `Competition`.`show_create_team`, `Competition`.`show_offer_help`, `Competition`.`show_volunteer_for`, `Competition`.`show_browse_help`, `Competition`.`show_counting_votes`, `Competition`.`show_microsite`, `Competition`.`microsite_state` FROM `competitions` AS `Competition` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| 21 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'j3bgnj63m0b1bfnv294g2t39e5' | 0 | 0 | 0 | |
| 22 | SELECT `TeamsUsers`.`team_id`, COUNT(user_id) as total FROM `teams_users` AS `TeamsUsers` WHERE 1 = 1 GROUP BY team_id HAVING total>=2 ORDER BY rand() ASC LIMIT 10 | 10 | 10 | 1 | |
| 23 | SELECT `Team`.`id`, `Team`.`contestyear`, `Team`.`name`, `Team`.`created`, `Team`.`modified`, `Team`.`email`, `Team`.`inglobalchallenge`, `Team`.`pitch`, `Team`.`intent`, `Team`.`impact`, `Team`.`rawlocation`, `Team`.`lat`, `Team`.`lon`, `Team`.`glocation`, `Team`.`category_other`, `Team`.`whoweare`, `Team`.`url`, `Team`.`blog`, `Team`.`twitter`, `Team`.`twitter_import`, `Team`.`facebook`, `Team`.`problem_id`, `Team`.`challenge_id`, `Team`.`winner`, `Team`.`winnertype`, `Team`.`shortpitch`, `Team`.`vote_count`, `Team`.`active`, `Team`.`facebook_page_id`, `Team`.`follower_count`, `Team`.`comment_count`, `Team`.`in_the_field`, `Image`.`id`, `Image`.`filename`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified`, `Image`.`page_id`, `Image`.`entity_id`, `Image`.`element_id`, `Image`.`team_id`, `Image`.`problem_id`, `Image`.`category_id`, `Image`.`challenge_id` FROM `teams` AS `Team` LEFT JOIN `images` AS `Image` ON (`Image`.`team_id` = `Team`.`id`) WHERE `Team`.`inglobalchallenge` = 1 AND `Team`.`id` IN (38, 69, 292) AND `Team`.`name` <>'' AND `Team`.`email` <>'' AND `Team`.`pitch` <>'' AND `Team`.`intent` <>'' AND `Team`.`impact` <>'' AND `Team`.`whoweare` <>'' AND `Team`.`glocation` <>'' | 0 | 0 | 0 | |
| 24 | SELECT `Problem`.`id`, `Problem`.`description`, `Problem`.`created`, `Problem`.`modified`, `Problem`.`contestyear`, `Problem`.`user_id`, `Problem`.`title`, `Problem`.`published`, `Problem`.`agree`, `Problem`.`category_suggestion`, `Problem`.`follower_count`, `Problem`.`comment_count`, `Image`.`id`, `Image`.`filename`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified`, `Image`.`page_id`, `Image`.`entity_id`, `Image`.`element_id`, `Image`.`team_id`, `Image`.`problem_id`, `Image`.`category_id`, `Image`.`challenge_id` FROM `problems` AS `Problem` LEFT JOIN `images` AS `Image` ON (`Image`.`problem_id` = `Problem`.`id`) WHERE `Problem`.`published` <>'0000-00-00' ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 3 |
Query: SELECT `TeamsUsers`.`team_id`, COUNT(user_id) as total FROM `teams_users` AS `TeamsUsers` WHERE 1 = 1 GROUP BY team_id HAVING total>=2 ORDER BY rand() ASC LIMIT 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | TeamsUsers | ALL | 1199 | Using temporary; Using filesort |
Peak Memory Use 9.21 MB
| Message | Memory use |
|---|---|
| Component intitailization | 6.09 MB |
| Controller action start | 6.18 MB |
| Controller render start | 7.01 MB |
| Component intitailization #2 | 8.32 MB |
| Controller action start #2 | 8.32 MB |
| View render complete | 8.26 MB |
Total Request Time: 303 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 88.12 | |
| Component initialization and startup | 37.80 | |
| Controller action | 10.36 | |
| Render Controller Action | 58.28 | |
| » Rendering View | 57.25 | |
| » » Rendering APP/views/home/index.ctp | 27.16 | |
| » » » Rendering APP/views/elements/home/main_elements.ctp | 11.46 | |
| » » » » Component initialization and startup #2 | 6.10 | |
| Controller action #2 | 0.00 | |
| » » » » Rendering APP/views/elements/home/contribute_box.ctp | 4.28 | |
| » » » » Rendering APP/views/elements/presentedBy.ctp | 0.18 | |
| » » » Rendering APP/views/layouts/default.ctp | 29.37 | |
| » » » » Rendering APP/views/elements/signedout.ctp | 6.70 |
There were no log entries made this request
There were no log entries made this request
