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 `homepages` | 7 | 7 | 0 | |
| 2 | DESCRIBE `elements` | 5 | 5 | 0 | |
| 3 | DESCRIBE `images` | 14 | 14 | 0 | |
| 4 | DESCRIBE `pages` | 6 | 6 | 0 | |
| 5 | DESCRIBE `entities` | 11 | 11 | 0 | |
| 6 | DESCRIBE `teams` | 32 | 32 | 1 | |
| 7 | DESCRIBE `problems` | 12 | 12 | 0 | |
| 8 | DESCRIBE `users` | 30 | 30 | 1 | |
| 9 | DESCRIBE `groups` | 4 | 4 | 0 | |
| 10 | DESCRIBE `profiles` | 19 | 19 | 0 | |
| 11 | DESCRIBE `votes` | 6 | 6 | 0 | |
| 12 | DESCRIBE `comments` | 14 | 14 | 0 | |
| 13 | DESCRIBE `likes` | 4 | 4 | 0 | |
| 14 | DESCRIBE `cake_sessions_users` | 4 | 4 | 0 | |
| 15 | DESCRIBE `proposals` | 11 | 11 | 0 | |
| 16 | DESCRIBE `proposalfiles` | 8 | 8 | 0 | |
| 17 | DESCRIBE `feedbacks` | 11 | 11 | 0 | |
| 18 | DESCRIBE `grants` | 9 | 9 | 0 | |
| 19 | DESCRIBE `grantitems` | 9 | 9 | 0 | |
| 20 | DESCRIBE `grants_users` | 4 | 4 | 0 | |
| 21 | DESCRIBE `proposals_users` | 4 | 4 | 0 | |
| 22 | DESCRIBE `teams_users` | 5 | 5 | 0 | |
| 23 | DESCRIBE `problem_followers` | 5 | 5 | 0 | |
| 24 | DESCRIBE `updates` | 7 | 7 | 0 | |
| 25 | DESCRIBE `categories` | 4 | 4 | 0 | |
| 26 | DESCRIBE `help` | 12 | 12 | 0 | |
| 27 | DESCRIBE `helptypes` | 5 | 5 | 0 | |
| 28 | DESCRIBE `help_categories` | 3 | 3 | 0 | |
| 29 | DESCRIBE `categories_teams` | 3 | 3 | 0 | |
| 30 | DESCRIBE `problems_categories` | 3 | 3 | 0 | |
| 31 | DESCRIBE `challenges` | 8 | 8 | 0 | |
| 32 | DESCRIBE `challenges_categories` | 3 | 3 | 0 | |
| 33 | DESCRIBE `teams_partners` | 11 | 11 | 0 | |
| 34 | DESCRIBE `teams_invites` | 7 | 7 | 0 | |
| 35 | DESCRIBE `videos` | 11 | 11 | 0 | |
| 36 | DESCRIBE `team_followers` | 5 | 5 | 0 | |
| 37 | DESCRIBE `elements_homepages` | 3 | 3 | 0 | |
| 38 | DESCRIBE `competitions` | 21 | 21 | 0 | |
| 39 | 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 | |
| 40 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'c1gvt0jl0n50ilut6esmi68830' | 0 | 0 | 0 | |
| 41 | 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 | |
| 42 | 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 (50, 316, 219) AND `Team`.`name` <>'' AND `Team`.`email` <>'' AND `Team`.`pitch` <>'' AND `Team`.`intent` <>'' AND `Team`.`impact` <>'' AND `Team`.`whoweare` <>'' AND `Team`.`glocation` <>'' | 0 | 0 | 0 | |
| 43 | 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 | 1 |
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 |
Query: 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
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Problem | ALL | 67 | Using where; Using temporary; Using filesort | ||||
| 1 | SIMPLE | Image | ref | problem_id | problem_id | 4 | mitgc_beta.Problem.id | 7 |
Peak Memory Use 9.05 MB
| Message | Memory use |
|---|---|
| Component intitailization | 6.10 MB |
| Controller action start | 6.17 MB |
| Controller render start | 7.35 MB |
| Component intitailization #2 | 8.66 MB |
| Controller action start #2 | 8.66 MB |
| View render complete | 8.60 MB |
Total Request Time: 285 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 93.33 | |
| Component initialization and startup | 3.92 | |
| Controller action | 7.84 | |
| Render Controller Action | 81.12 | |
| » Rendering View | 79.99 | |
| » » Rendering APP/views/home/index.ctp | 48.57 | |
| » » » Rendering APP/views/elements/home/main_elements.ctp | 12.87 | |
| » » » » Component initialization and startup #2 | 7.20 | |
| Controller action #2 | 0.00 | |
| » » » » Rendering APP/views/elements/home/contribute_box.ctp | 4.43 | |
| » » » » Rendering APP/views/elements/presentedBy.ctp | 0.18 | |
| » » » Rendering APP/views/layouts/default.ctp | 30.60 | |
| » » » » Rendering APP/views/elements/signedout.ctp | 6.88 |
There were no log entries made this request
There were no log entries made this request
