To view Cookies, add CookieComponent to Controller
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `aros` | 7 | 7 | 1 | |
| 2 | DESCRIBE `acos` | 7 | 7 | 1 | |
| 3 | DESCRIBE `aros_acos` | 7 | 7 | 1 | |
| 4 | DESCRIBE `events` | 10 | 10 | 1 | |
| 5 | SELECT *, IF( (weekly_recurrance), IF( (event_date < CURDATE( )), DATE_ADD(CURDATE( ), INTERVAL (IF( (0 > (WEEKDAY(event_date) - WEEKDAY(CURDATE( )))), (WEEKDAY(event_date) - WEEKDAY(CURDATE( ))) + 7, (WEEKDAY(event_date) - WEEKDAY(CURDATE( ))) )) DAY), event_date ), event_date ) AS true_date FROM `events` AS `Event` WHERE `active` = 1 AND publish_date <= CURDATE( ) AND IF( (weekly_recurrance), IF( (event_date < CURDATE( )), DATE_ADD(CURDATE( ), INTERVAL (IF( (0 > (WEEKDAY(event_date) - WEEKDAY(CURDATE( )))), (WEEKDAY(event_date) - WEEKDAY(CURDATE( ))) + 7, (WEEKDAY(event_date) - WEEKDAY(CURDATE( ))) )) DAY), event_date ), event_date ) >= CURDATE( ) ORDER BY `true_date` ASC | 0 | 0 | 1 | |
| 6 | DESCRIBE `settings` | 4 | 4 | 1 | |
| 7 | SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | query |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Impossible WHERE noticed after reading const tables | SELECT *, IF( (weekly_recurrance), IF( (event_date < CURDATE( )), DATE_ADD(CURDATE( ), INTERVAL (IF( (0 > (WEEKDAY(event_date) - WEEKDAY(CURDATE( )))), (WEEKDAY(event_date) - WEEKDAY(CURDATE( ))) + 7, (WEEKDAY(event_date) - WEEKDAY(CURDATE( ))) )) DAY), event_date ), event_date ) AS true_date FROM `events` AS `Event` WHERE `active` = 1 AND publish_date <= CURDATE( ) AND IF( (weekly_recurrance), IF( (event_date < CURDATE( )), DATE_ADD(CURDATE( ), INTERVAL (IF( (0 > (WEEKDAY(event_date) - WEEKDAY(CURDATE( )))), (WEEKDAY(event_date) - WEEKDAY(CURDATE( ))) + 7, (WEEKDAY(event_date) - WEEKDAY(CURDATE( ))) )) DAY), event_date ), event_date ) >= CURDATE( ) ORDER BY `true_date` ASC |
Current Memory Use 3.60 MB
Peak Memory Use 3.68 MB
Total Request Time: 1.002807 (seconds)
| Message | Time in seconds | Graph |
|---|---|---|
| Component initialization and startup | 0.011860 | |
| Controller Action | 0.010070 | |
| Render Controller Action | 0.022740 | |
| Rendering View | 0.021860 | |
| Rendering APP/views/events/index.ctp | 0.005760 | |
| Rendering APP/views/layouts/default.ctp | 0.013800 |
There were no log entries made this request
There were no log entries made this request