Recent Requests
|
|
Requests
Page 1 of 2511, showing 20 records out of 50207 total, starting on record 1, ending on 20
To view Cookies, add CookieComponent to Controller
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SHOW FULL COLUMNS FROM `djs` | 18 | 18 | 1 | maybe slow | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | ||
| SHOW FULL COLUMNS FROM `aros` | 8 | 8 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `acos` | 8 | 8 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `aros_acos` | 7 | 7 | 1 | maybe slow | |
| SELECT `Dj`.`name` FROM `djs` AS `Dj` WHERE `Dj`.`enabled` = 1 | 9 | 9 | 0 | ||
| SELECT `Dj`.`id`, `Dj`.`uuid`, `Dj`.`smf_member_id`, `Dj`.`name`, `Dj`.`nickname`, `Dj`.`database`, `Dj`.`db_config`, `Dj`.`enabled`, `Dj`.`requestable`, `Dj`.`request_disabled_message`, `Dj`.`request_method`, `Dj`.`queue_visible`, `Dj`.`sam`, `Dj`.`sam_port`, `Dj`.`sam_host`, `Dj`.`mpd`, `Dj`.`created`, `Dj`.`modified` FROM `djs` AS `Dj` WHERE `Dj`.`name` = 'kagura' LIMIT 1 | 1 | 1 | 1 | ||
| SELECT `Dj`.`name` FROM `djs` AS `Dj` WHERE `Dj`.`enabled` = 1 | 9 | 9 | 0 | ||
| SELECT `Dj`.`id`, `Dj`.`db_config`, `Dj`.`database` FROM `djs` AS `Dj` WHERE `Dj`.`name` = 'kagura' LIMIT 1 | 1 | 1 | 0 |
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SHOW FULL COLUMNS FROM `smf_members` | 57 | 57 | 1 | ||
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 9 | maybe slow | |
| SHOW FULL COLUMNS FROM `smf_membergroups` | 6 | 6 | 1 | maybe slow | |
| SELECT `SmfMember`.`ID_MEMBER`, `SmfMember`.`ID_GROUP`, `SmfMember`.`realName`, `SmfMember`.`avatar`, `SmfMember`.`ID_POST_GROUP` FROM `smf_members` AS `SmfMember` WHERE `SmfMember`.`ID_MEMBER` = 1 | 1 | 1 | 1 |
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SHOW FULL COLUMNS FROM `historylist` | 26 | 26 | 5 | maybe slow | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | ||
| SHOW FULL COLUMNS FROM `songlist` | 45 | 45 | 1 | ||
| SHOW FULL COLUMNS FROM `categorylist` | 4 | 4 | 8 | maybe slow | |
| SHOW FULL COLUMNS FROM `requestlist` | 9 | 9 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `queuelist` | 6 | 6 | 0 |
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SELECT `SongHistory`.`songID`, `SongHistory`.`duration`, `SongHistory`.`artist`, `SongHistory`.`title`, `SongHistory`.`album`, `SongHistory`.`requestID`, `SongHistory`.`insertDate`, `Song`.`genre`, `Request`.`ID`, `Request`.`songID`, `Request`.`name`, `Request`.`msg`, `Song`.`id` FROM `historylist` AS `SongHistory` LEFT JOIN `songlist` AS `Song` ON (`SongHistory`.`songID` = `Song`.`id`) LEFT JOIN `requestlist` AS `Request` ON (`SongHistory`.`requestID` = `Request`.`ID`) WHERE 1 = 1 ORDER BY `SongHistory`.`ID` DESC LIMIT 1 | 1 | 1 | 0 | ||
| SELECT COUNT(*) AS `count` FROM `requestlist` AS `Request` LEFT JOIN `songlist` AS `Song` ON (`Request`.`songID` = `Song`.`id`) WHERE 1 = 1 | 1 | 1 | 205 | maybe slow | |
| SELECT `Request`.`ID`, `Request`.`songID`, `Request`.`name`, `Request`.`msg`, `Song`.`ID`, `Song`.`title`, `Song`.`artist` FROM `requestlist` AS `Request` LEFT JOIN `songlist` AS `Song` ON (`Request`.`songID` = `Song`.`id`) WHERE 1 = 1 ORDER BY `Request`.`name` asc LIMIT 20 | 20 | 20 | 634 | maybe slow | |
| SELECT `Queue`.`ID`, `Queue`.`songID`, `Queue`.`sortID`, `Queue`.`requests`, `Queue`.`requestID`, `Queue`.`auxdata` FROM `queuelist` AS `Queue` WHERE `Queue`.`requestID` IN (3, 4, 5, 6, 9, 10, 12, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) | 0 | 0 | 0 | ||
| SELECT `Request`.`ID`, `Request`.`songID`, `Request`.`name`, `Request`.`msg`, `Song`.`ID`, `Song`.`artist`, `Song`.`title`, `Song`.`id` FROM `requestlist` AS `Request` LEFT JOIN `songlist` AS `Song` ON (`Request`.`songID` = `Song`.`id`) WHERE msg IS NOT NULL AND msg != '' ORDER BY `Request`.`ID` DESC LIMIT 3 | 3 | 3 | 0 | ||
| SELECT `Queue`.`ID`, `Queue`.`songID`, `Queue`.`sortID`, `Queue`.`requests`, `Queue`.`requestID`, `Song`.`ID`, `Song`.`artist`, `Song`.`title`, `Song`.`album`, `Song`.`genre`, `Song`.`duration`, `Song`.`id` FROM `queuelist` AS `Queue` LEFT JOIN `songlist` AS `Song` ON (`Queue`.`songID` = `Song`.`id`) WHERE 1 = 1 ORDER BY `sortID` ASC | 0 | 0 | 1 | maybe slow | |
| SELECT Song.ID, Song.title, Song.artist, count(Song.ID) as RequestCount FROM songlist as Song, requestlist as Request WHERE Request.songID = Song.ID AND Request.code = 200 AND Request.t_stamp <= '2012-4-30 00:00:00' AND Request.t_stamp >= '2012-4-1 00:00:00' GROUP BY Song.id, Song.artist, Song.title ORDER BY RequestCount DESC LIMIT 10 | 10 | 10 | 74 | maybe slow |
Peak Memory Use 21.15 MB
| Message | Memory use |
|---|---|
| Component intitailization | 15.24 MB |
| Controller action start | 15.37 MB |
| Controller render start | 15.94 MB |
| Component intitailization #2 | 19.27 MB |
| Controller action start #2 | 19.28 MB |
| Component intitailization #3 | 19.45 MB |
| Controller action start #3 | 19.46 MB |
| View render complete | 19.28 MB |
Total Request Time: 2601 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 367.88 | |
| Component initialization and startup | 2.94 | |
| Controller action | 871.15 | |
| Render Controller Action | 1201.41 | |
| » Rendering View | 1199.12 | |
| » » Rendering APP/views/requests/index.ctp | 80.35 | |
| » » Rendering APP/views/themed/shr-luv/layouts/default.ctp | 1118.24 | |
| » » » Rendering APP/views/elements/top.ctp | 1.46 | |
| » » » Rendering APP/views/themed/shr-luv/elements/header.ctp | 0.23 | |
| » » » Rendering APP/views/elements/column_left.ctp | 998.25 | |
| » » » » Rendering APP/views/elements/menu.ctp | 2.71 | |
| » » » » Rendering APP/views/elements/upcoming_shows.ctp | 994.01 | |
| » » » » Rendering APP/views/elements/affiliates.ctp | 0.79 | |
| » » » Rendering APP/views/elements/requests/content.ctp | 5.34 | |
| » » » » Rendering APP/views/elements/paypal-saso.ctp | 0.25 | |
| » » » Rendering APP/views/elements/column_right.ctp | 108.77 | |
| » » » » Rendering APP/views/elements/playing.ctp | 2.39 | |
| » » » » Rendering APP/views/elements/queued.ctp | 17.11 | |
| » » » » » Component initialization and startup #2 | 2.06 | |
| Controller action #2 | 0.00 | |
| » » » » » Rendering APP/views/elements/donations.ctp | 1.07 | |
| » » » » » Rendering APP/views/elements/most_requested.ctp | 86.73 | |
| » » » » » » Component initialization and startup #3 | 0.96 | |
| Controller action #3 | 0.00 | |
| » » » » » Rendering APP/views/elements/powered_by.ctp | 1.99 |