"All those years of nerding it up, thinking it'd be hot one day..."
Posted on 29/12/10
by irate
in Over Heard |
97 Views
Select Category
- Pranks
- Office
- Funny
- Over Heard
- Family
- Friends
To view Cookies, add CookieComponent to Controller
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SHOW FULL COLUMNS FROM `cake_sessions` | 3 | 3 | 3 | ||
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 2 | maybe slow | |
| SHOW FULL COLUMNS FROM `posts` | 9 | 9 | 3 | maybe slow | |
| SHOW FULL COLUMNS FROM `users` | 26 | 26 | 4 | maybe slow | |
| SHOW FULL COLUMNS FROM `groups` | 4 | 4 | 3 | maybe slow | |
| SHOW FULL COLUMNS FROM `subscriptions` | 9 | 9 | 215 | maybe slow | |
| SHOW FULL COLUMNS FROM `categories` | 2 | 2 | 2 | ||
| SHOW FULL COLUMNS FROM `media` | 11 | 11 | 3 | maybe slow | |
| SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_sessions` AS `Session` WHERE `id` = 'o6QlrrPVTgx-oKxUkW1Z63' LIMIT 1 | 1 | 1 | 2 | maybe slow | |
| SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`name` = 'Over Heard' LIMIT 1 | 1 | 1 | 2 | maybe slow | |
| SELECT COUNT(*) AS `count` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Post`.`category_id` = `Category`.`id`) LEFT JOIN `media` AS `Media` ON (`Media`.`model` = "Post" AND `Media`.`foreignKey` = `Post`.`id`) WHERE `Post`.`category_id` = 4 | 1 | 1 | 11 | maybe slow | |
| SELECT `Post`.`id`, `Post`.`category_id`, `Post`.`user_id`, `Post`.`content`, `Post`.`slug`, `Post`.`nsfw`, `Post`.`ttl_views`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`firstname`, `User`.`facebook_link`, `User`.`name`, `Category`.`id`, `Category`.`name`, `Media`.`id`, `Media`.`model`, `Media`.`type`, `Media`.`foreignKey`, `Media`.`address`, `Media`.`bucket`, `Media`.`thumbnail`, `Media`.`fullimage`, `Media`.`original`, `Media`.`created`, `Media`.`modified` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Post`.`category_id` = `Category`.`id`) LEFT JOIN `media` AS `Media` ON (`Media`.`model` = "Post" AND `Media`.`foreignKey` = `Post`.`id`) WHERE `Post`.`category_id` = 4 ORDER BY `Post`.`created` DESC LIMIT 24, 8 | 1 | 1 | 4 | maybe slow | |
| SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE 1 = 1 | 6 | 6 | 3 | maybe slow |
Peak Memory Use 14.76 MB
| Message | Memory use |
|---|---|
| Component intitailization | 11.46 MB |
| Controller action start | 11.56 MB |
| Controller render start | 11.64 MB |
| View render complete | 14.48 MB |
Total Request Time: 478 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 372.28 | |
| Component initialization and startup | 6.10 | |
| Controller action | 30.61 | |
| Render Controller Action | 36.81 | |
| » Rendering View | 34.82 | |
| » » Rendering APP/views/posts/index.ctp | 28.61 | |
| » » » Rendering APP/views/elements/posts/add.ctp | 0.29 | |
| » » » Rendering APP/views/elements/posts/list.ctp | 2.72 | |
| » » » » Rendering APP/views/elements/user/avatar.ctp | 0.33 | |
| » » » » Rendering APP/views/elements/social/like.ctp | 0.17 | |
| » » » » Rendering APP/views/elements/posts/media.ctp | 0.13 | |
| » » » Rendering APP/views/elements/paginate.ctp | 2.25 | |
| » » Rendering APP/views/layouts/default.ctp | 5.54 | |
| » » » Rendering APP/views/elements/misc/google_analytics.ctp | 0.17 | |
| » » » Rendering APP/views/elements/header.ctp | 0.55 | |
| » » » Rendering APP/views/elements/sidebar.ctp | 2.15 | |
| » » » » Rendering APP/views/elements/sidebar/search.ctp | 0.22 | |
| » » » » Rendering APP/views/elements/adverts/zone_1.ctp | 0.12 | |
| » » » » Rendering APP/views/elements/sidebar/most-active.ctp | 0.12 | |
| » » » » Rendering APP/views/elements/adverts/zone_2.ctp | 0.12 | |
| » » » Rendering APP/views/elements/footer.ctp | 0.14 |