Sign in with an MIT Certificate »
Not signed up yet? Register »
IDEAS Global Challenge Spring Generator Dinner
Thursday, February 23; 7:00-9:00pm
MIT's Student Center, Lobdell Dining Room (W20-208)
RSVPs are appreciated but not required - email globalchallenge-rsvp [at] mit.edu.
Facebook event: http://www.facebook.com/events/177378162363056/
View All Events
SUPPORTED BY: See all 
Support MIT IDEAS Global Challenge:
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `entities` | 11 | 11 | 0 | |
| 2 | DESCRIBE `images` | 14 | 14 | 0 | |
| 3 | DESCRIBE `pages` | 6 | 6 | 0 | |
| 4 | DESCRIBE `elements` | 5 | 5 | 0 | |
| 5 | DESCRIBE `homepages` | 7 | 7 | 0 | |
| 6 | DESCRIBE `elements_homepages` | 3 | 3 | 0 | |
| 7 | DESCRIBE `teams` | 32 | 32 | 1 | |
| 8 | DESCRIBE `problems` | 12 | 12 | 0 | |
| 9 | DESCRIBE `users` | 30 | 30 | 1 | |
| 10 | DESCRIBE `groups` | 4 | 4 | 0 | |
| 11 | DESCRIBE `profiles` | 19 | 19 | 1 | |
| 12 | DESCRIBE `votes` | 6 | 6 | 0 | |
| 13 | DESCRIBE `comments` | 14 | 14 | 1 | |
| 14 | DESCRIBE `likes` | 4 | 4 | 0 | |
| 15 | DESCRIBE `cake_sessions_users` | 4 | 4 | 0 | |
| 16 | DESCRIBE `proposals` | 11 | 11 | 0 | |
| 17 | DESCRIBE `proposalfiles` | 8 | 8 | 0 | |
| 18 | DESCRIBE `feedbacks` | 11 | 11 | 0 | |
| 19 | DESCRIBE `grants` | 9 | 9 | 0 | |
| 20 | DESCRIBE `grantitems` | 9 | 9 | 0 | |
| 21 | DESCRIBE `grants_users` | 4 | 4 | 0 | |
| 22 | DESCRIBE `proposals_users` | 4 | 4 | 0 | |
| 23 | DESCRIBE `teams_users` | 5 | 5 | 0 | |
| 24 | DESCRIBE `problem_followers` | 5 | 5 | 0 | |
| 25 | DESCRIBE `updates` | 7 | 7 | 0 | |
| 26 | DESCRIBE `categories` | 4 | 4 | 0 | |
| 27 | DESCRIBE `help` | 12 | 12 | 0 | |
| 28 | DESCRIBE `helptypes` | 5 | 5 | 0 | |
| 29 | DESCRIBE `help_categories` | 3 | 3 | 0 | |
| 30 | DESCRIBE `categories_teams` | 3 | 3 | 0 | |
| 31 | DESCRIBE `problems_categories` | 3 | 3 | 0 | |
| 32 | DESCRIBE `challenges` | 8 | 8 | 0 | |
| 33 | DESCRIBE `challenges_categories` | 3 | 3 | 0 | |
| 34 | DESCRIBE `teams_partners` | 11 | 11 | 0 | |
| 35 | DESCRIBE `teams_invites` | 7 | 7 | 0 | |
| 36 | DESCRIBE `videos` | 11 | 11 | 0 | |
| 37 | DESCRIBE `team_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` = 'srgf8jp1k12c7bc3vf23imbsp5' | 0 | 0 | 0 | |
| 41 | SELECT `Entity`.`id`, `Entity`.`title`, `Entity`.`type`, `Entity`.`body`, `Entity`.`link`, `Entity`.`published`, `Entity`.`date`, `Entity`.`contestyear`, `Entity`.`created`, `Entity`.`modified`, `Entity`.`archived` FROM `entities` AS `Entity` WHERE `Entity`.`id` = 212 LIMIT 1 | 1 | 1 | 0 | |
| 42 | 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`.`entity_id` = (212) | 1 | 1 | 0 | |
| 43 | SELECT date_format(date, "%M %Y") AS archive_date, count(date) AS total, `Entity`.`id` FROM `entities` AS `Entity` WHERE `Entity`.`type` = 2 AND `Entity`.`published` = 1 GROUP BY archive_date ORDER BY `date` desc | 36 | 36 | 0 | |
| 44 | 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`.`entity_id` IN (324, 323, 322, 320, 272, 275, 283, 268, 267, 270, 261, 262, 186, 187, 190, 208, 188, 200, 181, 142, 168, 131, 119, 85, 84, 73, 82, 71, 75, 52, 62, 56, 60, 8, 7, 3) | 32 | 32 | 0 |
Warning No slow queries!, or your database does not support EXPLAIN
Peak Memory Use 9.69 MB
| Message | Memory use |
|---|---|
| Component intitailization | 6.14 MB |
| Controller action start | 6.21 MB |
| Controller render start | 7.45 MB |
| View render complete | 8.55 MB |
Total Request Time: 554 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 123.88 | |
| Component initialization and startup | 36.93 | |
| Controller action | 11.09 | |
| Render Controller Action | 115.98 | |
| » Rendering View | 114.75 | |
| » » Rendering APP/views/entities/view.ctp | 81.84 | |
| » » Rendering APP/views/layouts/default.ctp | 32.09 | |
| » » » Rendering APP/views/elements/signedout.ctp | 7.32 |
There were no log entries made this request
There were no log entries made this request
Back To All Events
