TYPE IN!
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'u9jobmo64rq5oegrfp79ldj364' | 1 | 1 | 1 | |
| 2 | 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`.`isdefault` = 1 AND `Post`.`private` = 0 AND `Post`.`isjapanese` = 0 ORDER BY rand() ASC LIMIT 1 | 1 | 1 | 3452 |
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` FROM `posts` AS `Post` WHERE `Post`.`isdefault` = 1 AND `Post`.`private` = 0 AND `Post`.`isjapanese` = 0 ORDER BY rand() ASC LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Post | ALL | 1253155 | Using where; Using temporary; Using filesort |
Peak Memory Use 6.38 MB
| Message | Memory use |
|---|---|
| Component intitailization | 4.65 MB |
| Controller action start | 4.74 MB |
| Controller render start | 5.06 MB |
| View render complete | 6.13 MB |
Total Request Time: 3969 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 35.69 | |
| Component initialization and startup | 4.73 | |
| Controller action | 3453.90 | |
| Render Controller Action | 68.18 | |
| » Rendering View | 67.43 | |
| » » Rendering APP/views/posts/compose.ctp | 60.86 | |
| » » » Rendering APP/views/elements/ads_top.ctp | 0.16 | |
| » » » Rendering APP/views/elements/ads_bottom.ctp | 0.12 | |
| » » Rendering APP/views/layouts/typograffit.ctp | 5.50 | |
| » » » Rendering APP/views/elements/tmenu_guest.ctp | 0.66 |
There were no log entries made this request
There were no log entries made this request
