There’s a world of problems needing innovative thinkers to tackle them. The Global Challenge offers a space to define and discuss ways to solve these problems. Student who are ready to tackle any of these problems are encouraged to create a team and collaborate with others to develop their projects. Check back regularly for updates and new problems.
![]()
Problems identify basic obstacles to the well-being of communities around the world. In posting problems, we’d like you to define the problem, describe the context in which the problem is experienced, propose ways to think about solutions, and tell us how you think MIT can help.
Having trouble getting started? Contact us and we’d be happy to talk it over by phone.
SUPPORTED BY: See all 
Support MIT IDEAS Global Challenge:
No previous requests logged.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `problems` | 12 | 12 | 0 | |
| 2 | DESCRIBE `users` | 30 | 30 | 1 | |
| 3 | DESCRIBE `groups` | 4 | 4 | 0 | |
| 4 | DESCRIBE `profiles` | 19 | 19 | 0 | |
| 5 | DESCRIBE `votes` | 6 | 6 | 0 | |
| 6 | DESCRIBE `teams` | 32 | 32 | 1 | |
| 7 | DESCRIBE `challenges` | 8 | 8 | 0 | |
| 8 | DESCRIBE `images` | 14 | 14 | 0 | |
| 9 | DESCRIBE `pages` | 6 | 6 | 0 | |
| 10 | DESCRIBE `entities` | 11 | 11 | 0 | |
| 11 | DESCRIBE `elements` | 5 | 5 | 0 | |
| 12 | DESCRIBE `homepages` | 7 | 7 | 0 | |
| 13 | DESCRIBE `elements_homepages` | 3 | 3 | 0 | |
| 14 | DESCRIBE `categories` | 4 | 4 | 0 | |
| 15 | DESCRIBE `help` | 12 | 12 | 0 | |
| 16 | DESCRIBE `helptypes` | 5 | 5 | 0 | |
| 17 | DESCRIBE `help_categories` | 3 | 3 | 0 | |
| 18 | DESCRIBE `categories_teams` | 3 | 3 | 0 | |
| 19 | DESCRIBE `problems_categories` | 3 | 3 | 0 | |
| 20 | DESCRIBE `challenges_categories` | 3 | 3 | 0 | |
| 21 | DESCRIBE `teams_partners` | 11 | 11 | 0 | |
| 22 | DESCRIBE `teams_invites` | 7 | 7 | 0 | |
| 23 | DESCRIBE `proposals` | 11 | 11 | 0 | |
| 24 | DESCRIBE `proposalfiles` | 8 | 8 | 0 | |
| 25 | DESCRIBE `feedbacks` | 11 | 11 | 0 | |
| 26 | DESCRIBE `grants` | 9 | 9 | 0 | |
| 27 | DESCRIBE `grantitems` | 9 | 9 | 0 | |
| 28 | DESCRIBE `grants_users` | 4 | 4 | 0 | |
| 29 | DESCRIBE `proposals_users` | 4 | 4 | 0 | |
| 30 | DESCRIBE `videos` | 11 | 11 | 0 | |
| 31 | DESCRIBE `team_followers` | 5 | 5 | 0 | |
| 32 | DESCRIBE `comments` | 14 | 14 | 0 | |
| 33 | DESCRIBE `likes` | 4 | 4 | 0 | |
| 34 | DESCRIBE `teams_users` | 5 | 5 | 0 | |
| 35 | DESCRIBE `updates` | 7 | 7 | 0 | |
| 36 | DESCRIBE `cake_sessions_users` | 4 | 4 | 0 | |
| 37 | DESCRIBE `problem_followers` | 5 | 5 | 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` = '2nk41t5r7rukia81vka53r0p34' | 0 | 0 | 0 | |
| 41 | SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE 1 = 1 | 10 | 10 | 0 | |
| 42 | SELECT `Image`.`category_id`, `Image`.`dir`, `Image`.`filename` FROM `images` AS `Image` WHERE `Image`.`category_id` IN (1, 2, 3, 4, 5, 6, 8, 9, 10, 11) | 20 | 20 | 0 | |
| 43 | SELECT COUNT(*) AS `count` FROM `problems` AS `Problem` WHERE `Problem`.`published` <>'0000-00-00' | 1 | 1 | 0 | |
| 44 | 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`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country`, `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 `users` AS `User` ON (`Problem`.`user_id` = `User`.`id`) LEFT JOIN `images` AS `Image` ON (`Image`.`problem_id` = `Problem`.`id`) WHERE `Problem`.`published` <>'0000-00-00' ORDER BY `Problem`.`id` desc LIMIT 12 | 11 | 11 | 0 | |
| 45 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 19050 | 1 | 1 | 0 | |
| 46 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 19050 | 1 | 1 | 0 | |
| 47 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 19050 | 1 | 1 | 0 | |
| 48 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 19050 | 1 | 1 | 0 | |
| 49 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 19050 | 1 | 1 | 0 | |
| 50 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 19050 | 1 | 1 | 0 | |
| 51 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 19050 | 1 | 1 | 0 | |
| 52 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 19050 | 1 | 1 | 0 | |
| 53 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 24335 | 1 | 1 | 0 | |
| 54 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 24335 | 1 | 1 | 0 | |
| 55 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 12591 | 1 | 1 | 0 | |
| 56 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 12591 | 1 | 1 | 0 | |
| 57 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 3055 | 1 | 1 | 0 | |
| 58 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 3055 | 1 | 1 | 0 | |
| 59 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 2174 | 1 | 1 | 0 | |
| 60 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 2174 | 1 | 1 | 0 | |
| 61 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 9 | 1 | 1 | 0 | |
| 62 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 9 | 1 | 1 | 0 | |
| 63 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 2038 | 1 | 1 | 0 | |
| 64 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 2038 | 1 | 1 | 0 | |
| 65 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`group_id`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`hometown`, `User`.`course`, `User`.`grad_year`, `User`.`department`, `User`.`competition_updates`, `User`.`confirmed`, `User`.`confirmation_token`, `User`.`active`, `User`.`contestyear`, `User`.`type`, `User`.`terms_and_conditions`, `User`.`vote_count`, `User`.`teams_user_count`, `User`.`ip_address`, `User`.`stuffimfollowing_updates`, `User`.`verified`, `User`.`phone`, `User`.`phone_type`, `User`.`verify_code`, `User`.`verify_count`, `User`.`ip_country` FROM `users` AS `User` WHERE `User`.`id` = 330 | 1 | 1 | 0 | |
| 66 | SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`user_id`, `Profile`.`public`, `Profile`.`areas_of_interest`, `Profile`.`skills`, `Profile`.`bio`, `Profile`.`organization`, `Profile`.`country`, `Profile`.`province`, `Profile`.`city`, `Profile`.`glocation`, `Profile`.`lat`, `Profile`.`lon`, `Profile`.`linkedin`, `Profile`.`twitter`, `Profile`.`facebook` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 330 | 1 | 1 | 0 | |
| 67 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 79 | 1 | 1 | 0 | |
| 68 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 76 | 1 | 1 | 0 | |
| 69 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 75 | 1 | 1 | 0 | |
| 70 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 74 | 1 | 1 | 0 | |
| 71 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 69 | 1 | 1 | 0 | |
| 72 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 42 | 1 | 1 | 0 | |
| 73 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 38 | 1 | 1 | 0 | |
| 74 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 14 | 1 | 1 | 0 | |
| 75 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 13 | 1 | 1 | 0 | |
| 76 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 10 | 1 | 1 | 0 | |
| 77 | SELECT `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 `images` AS `Image` WHERE `Image`.`problem_id` = 9 | 1 | 1 | 0 | |
| 78 | SELECT `ProblemFollower`.`id`, `ProblemFollower`.`user_id`, `ProblemFollower`.`problem_id`, `ProblemFollower`.`created`, `ProblemFollower`.`modified` FROM `problem_followers` AS `ProblemFollower` WHERE `user_id` IS NULL AND `ProblemFollower`.`problem_id` IN (79, 76, 75, 74, 69, 42, 38, 14, 13, 10, 9) | 0 | 0 | 0 | |
| 79 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified`, `ProblemsCategory`.`id`, `ProblemsCategory`.`problem_id`, `ProblemsCategory`.`category_id` FROM `categories` AS `Category` JOIN `problems_categories` AS `ProblemsCategory` ON (`ProblemsCategory`.`problem_id` IN (79, 76, 75, 74, 69, 42, 38, 14, 13, 10, 9) AND `ProblemsCategory`.`category_id` = `Category`.`id`) | 25 | 25 | 0 |
Warning No slow queries!, or your database does not support EXPLAIN
Peak Memory Use 10.35 MB
| Message | Memory use |
|---|---|
| Component intitailization | 6.11 MB |
| Controller action start | 6.16 MB |
| Controller render start | 8.40 MB |
| View render complete | 9.84 MB |
Total Request Time: 356 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 120.83 | |
| Component initialization and startup | 36.51 | |
| Controller action | 42.84 | |
| Render Controller Action | 72.75 | |
| » Rendering View | 71.51 | |
| » » Rendering APP/views/problems/index.ctp | 38.50 | |
| » » » Rendering APP/views/elements/problem_grid.ctp | 3.00 | |
| » » » Rendering APP/views/elements/problems/cta_problem_list.ctp | 2.61 | |
| » » Rendering APP/views/layouts/default.ctp | 32.23 | |
| » » » Rendering APP/views/elements/signedout.ctp | 7.31 |
There were no log entries made this request
There were no log entries made this request
