Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | DESCRIBE `posts` | 16 | 16 | 2 | |
2 | DESCRIBE `users` | 8 | 8 | 8 | |
3 | DESCRIBE `groups` | 2 | 2 | 1 | |
4 | DESCRIBE `sources` | 17 | 17 | 2 | |
5 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'gu732uov4smf0phkhcrldj14g0' | 1 | 1 | 1 | |
6 | SELECT `Post`.`id`, `Post`.`body`, `Post`.`user_id`, `Post`.`ip`, `Post`.`hash`, `Post`.`active`, `Post`.`isdefault`, `Post`.`isjapanese`, `Post`.`issample`, `Post`.`iscaptcha`, `Post`.`private`, `Post`.`current_tag`, `Post`.`width`, `Post`.`height`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`active`, `User`.`group_id`, `User`.`created`, `User`.`modified` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`hash` = 'AFIGaLsiCAu4' LIMIT 1 | 1 | 1 | 2 | |
7 | SELECT `Post`.`id`, `Post`.`body`, `Post`.`user_id`, `Post`.`ip`, `Post`.`hash`, `Post`.`active`, `Post`.`isdefault`, `Post`.`isjapanese`, `Post`.`issample`, `Post`.`iscaptcha`, `Post`.`private`, `Post`.`current_tag`, `Post`.`width`, `Post`.`height`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`active`, `User`.`group_id`, `User`.`created`, `User`.`modified` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`hash` = 'AFIGaLsiCAu4' LIMIT 1 | 1 | 1 | 1 | |
8 | SELECT `Post`.`id`, `Post`.`body`, `Post`.`user_id`, `Post`.`ip`, `Post`.`hash`, `Post`.`active`, `Post`.`isdefault`, `Post`.`isjapanese`, `Post`.`issample`, `Post`.`iscaptcha`, `Post`.`private`, `Post`.`current_tag`, `Post`.`width`, `Post`.`height`, `Post`.`created`, `Post`.`modified` FROM `posts` AS `Post` WHERE `Post`.`id` > 262484 AND `private` = 0 ORDER BY `Post`.`id` ASC LIMIT 1 | 1 | 1 | 1 | |
9 | SELECT `Post`.`id`, `Post`.`body`, `Post`.`user_id`, `Post`.`ip`, `Post`.`hash`, `Post`.`active`, `Post`.`isdefault`, `Post`.`isjapanese`, `Post`.`issample`, `Post`.`iscaptcha`, `Post`.`private`, `Post`.`current_tag`, `Post`.`width`, `Post`.`height`, `Post`.`created`, `Post`.`modified` FROM `posts` AS `Post` WHERE `Post`.`id` < 262484 AND `private` = 0 ORDER BY `Post`.`id` DESC LIMIT 1 | 1 | 1 | 1 |
Query: SELECT `Post`.`id`, `Post`.`body`, `Post`.`user_id`, `Post`.`ip`, `Post`.`hash`, `Post`.`active`, `Post`.`isdefault`, `Post`.`isjapanese`, `Post`.`issample`, `Post`.`iscaptcha`, `Post`.`private`, `Post`.`current_tag`, `Post`.`width`, `Post`.`height`, `Post`.`created`, `Post`.`modified`, `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`active`, `User`.`group_id`, `User`.`created`, `User`.`modified` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`hash` = 'AFIGaLsiCAu4' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | Post | ref | hash | hash | 36 | const | 1 | Using where |
1 | SIMPLE | User | eq_ref | PRIMARY | PRIMARY | 4 | typograffit.Post.user_id | 1 |
Peak Memory Use 6.58 MB
Message | Memory use |
---|---|
Component intitailization | 4.64 MB |
Controller action start | 4.74 MB |
Controller render start | 5.21 MB |
View render complete | 6.29 MB |
Total Request Time: 589 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 74.20 | |
Component initialization and startup | 11.30 | |
Controller action | 11.50 | |
Render Controller Action | 26.71 | |
» Rendering View | 25.78 | |
» » Rendering APP/views/posts/compose.ctp | 18.46 | |
» » » Rendering APP/views/elements/ads_top.ctp | 0.16 | |
» » » Rendering APP/views/elements/ads_bottom.ctp | 0.15 | |
» » Rendering APP/views/layouts/typograffit.ctp | 6.01 | |
» » » Rendering APP/views/elements/tmenu_guest.ctp | 0.77 |
There were no log entries made this request
There were no log entries made this request