J-Music and Anime Radio :: Shinsen-Radio

Upcoming Shows

Affiliates

Recent Requests

Boom Boom Satellites ~ Easy Action	aho	\:D/
Round Table ~ Let Me Be With You feat. Nino	Anonymous	
Detroit Metal City ~ SATSUGAI	aho	D:

Queued

<< previous | next >>

Page 0 of 1, showing 0 records out of 0 total, starting on record 0, ending on 0

Artist	Title	Album	Genre	Duration

<< previous | next >>

Playing

Dj	Kagura-Moto
Artist	Kalafina
Title	Magia
Album	Mahou Shoujo Madoka Magica ED Single - Magia
Genre	Anime ED
Remaining	02:05
Listeners	23
Requester

Queued

May Donations
0 of

Goal:
Current: 0
Last Month: 0

April Top 10

Artist	Title
Momoiro Clover Z	Mouretsu Uchuu Koukyou Kyoku Dai Nana Gakushou "Mugen no Ai"
MUCC	Nirvana
Momoiro Clover Z	LOST CHILD
supercell	My Dearest
EGOIST	The Everlasting Guilty Crown
Kana Hanazawa (Ruri) & Yuuichi Nakamurai (Kyousuke)	Shokuzai no Serenade
ClariS	Naisho no Hanashi
Toyasaki Aki & Hisaka Youko & Satou Satomi & Kotobuki Minako	Don't Say "Lazy"
May'n	Brain Diver
Yousei Teikoku	Kuusou Mesorogiwi

History
Request History
4 previous requests available
====
Session
Session
- Config
  userAgentb237457851c17d4fcca55141fcdc6690
  time1337406795
  timeout10
- rand_code95c864a91b1223a591d3cb7530ae87d5
- USER_AGENTCCBot/1.0 (+http://www.commoncrawl.org/bot.html)
- Message(empty)
- Auth
  redirect/debug_kit/toolbar_access/history_state/4
====
Request
Request

Cake Params
- controllerqueues
- actionindex
- named
  page0
  sortSong.artist
  directionasc
- pass(empty)
- plugin(null)
- url
  exthtml
  urlqueues/index/page:0/sort:Song.artist/direction:asc
- form(empty)
- isAjax(false)
- paging
  Queue
  page0
  current0
  count0
  prevPage(false)
  nextPage(false)
  pageCount0
  defaults
  limit20
  step1
  fields
  0ID
  1songID
  2sortID
  3requests
  4requestID
  ordersortID ASC
  contain
  Song
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
  conditions(empty)
  options
  page0
  limit20
  fields
  0ID
  1songID
  2sortID
  3requests
  4requestID
  order
  Song.artistasc
  contain
  Song
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
  conditions(empty)
$_GET
- urlqueues/index/page:0/sort:Song.artist/direction:asc
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys
  0controller
  1action
- options(empty)
- defaults
  actionindex
  plugin(null)
- template/:controller/:action/*
- _greedy(true)
- _compiledRoute#^/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Log

Sql Logs

default

Query	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	0
SHOW FULL COLUMNS FROM `acos`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `aros_acos`	7	7	0
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	0
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 Explain:

Click an "Explain" link above, to see the query explanation.

old_smf

Query	Affected	Num. rows	Took (ms)
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	0
SHOW FULL COLUMNS FROM `smf_membergroups`	6	6	0
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	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

shr_djs

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `historylist`	26	26	1
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	1	maybe slow
SHOW FULL COLUMNS FROM `requestlist`	9	9	1	maybe slow
SHOW FULL COLUMNS FROM `queuelist`	6	6	1	maybe slow

Query Explain:

Click an "Explain" link above, to see the query explanation.

kagura

Query	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 `queuelist` AS `Queue` LEFT JOIN `songlist` AS `Song` ON (`Queue`.`songID` = `Song`.`id`) WHERE 1 = 1	1	1	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 `Song`.`artist` asc LIMIT 20	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	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	68	maybe slow

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 20.00 MB

Message	Memory use
Component intitailization	14.71 MB
Controller action start	14.83 MB
Controller render start	15.33 MB
Component intitailization #2	18.79 MB
Controller action start #2	18.80 MB
View render complete	18.64 MB

Timers

Total Request Time: 1471 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	215.91
Component initialization and startup	3.00
Controller action	4.91
Render Controller Action	1157.28
» Rendering View	1155.05
» » Rendering APP/views/queues/index.ctp	20.50
» » Rendering APP/views/themed/shr-luv/layouts/default.ctp	1134.07
» » » Rendering APP/views/elements/top.ctp	1.56
» » » Rendering APP/views/themed/shr-luv/elements/header.ctp	0.18
» » » Rendering APP/views/elements/column_left.ctp	1030.72
» » » » Rendering APP/views/elements/menu.ctp	2.66
» » » » Rendering APP/views/elements/upcoming_shows.ctp	1026.56
» » » » Rendering APP/views/elements/affiliates.ctp	0.83
» » » Rendering APP/views/elements/requests/content.ctp	13.05
» » » » Rendering APP/views/elements/paypal-saso.ctp	0.21
» » » Rendering APP/views/elements/column_right.ctp	84.38
» » » » Rendering APP/views/elements/playing.ctp	2.41
» » » » Rendering APP/views/elements/queued.ctp	0.18
» » » » Rendering APP/views/elements/donations.ctp	0.54
» » » » Rendering APP/views/elements/most_requested.ctp	80.41
» » » » » Component initialization and startup #2	1.01
Controller action #2	0.00
» » » » Rendering APP/views/elements/powered_by.ctp	1.85

====

Log

Logs

====
Variables
View Variables
- queueModelQueue
- queues(empty)
- playing
  Dj
  id3
  uuid(null)
  smf_member_id1
  namekagura
  nicknameKagura-Moto
  databasedjs_kagura2
  db_configkagura
  enabled1
  requestable1
  request_disabled_messageRequests have been disabled by the dj.
  request_methodsql
  queue_visible1
  sam1
  sam_port1221
  sam_host172.16.248.129
  mpd0
  created2008-11-10 23:07:03
  modified2010-08-19 00:42:45
  SmfMember
  ID_MEMBER1
  ID_GROUP1
  realNamecandybar
  avatarhttp://www.shinsen-radio.org/img/samurai-chiisai.jpg
  ID_POST_GROUP8
  Song
  songID7984
  duration312.631
  artistKalafina
  titleMagia
  albumMahou Shoujo Madoka Magica ED Single - Magia
  requestID0
  insertDate2012-05-19 02:30:09
  genreAnime ED
  Request
  ID(null)
  songID(null)
  name(null)
  msg(null)
  total_listeners23
- menu
  Home Page
  display
  titleHome
  url
  plugin(null)
  admin(false)
  controllerpages
  actiondisplay
  0home
  Requests
  index
  titleRequests
  url
  plugin
  controllerrequests
  actionindex
  admin(false)
  Djs
  index
  titleDjs
  url
  plugin
  controllerdjs
  actionindex
  admin(false)
  Songs
  index
  titleSongs
  url
  plugin
  controllersongs
  actionindex
  admin(false)
  most_requested
  titleMost Requested
  url
  plugin
  controllersongs
  actionmost_requested
  admin(false)
  Queues
  index
  titleQueues
  url
  plugin
  controllerqueues
  actionindex
  admin(false)
  Affiliates
  index
  titleAffiliates
  url
  plugin
  controlleraffiliates
  actionindex
  admin(false)
  Song Histories
  index
  titleSong Histories
  url
  plugin
  controllersong_histories
  actionindex
  admin(false)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0simpleGraph
  1number
  2htmlToolbar
  3toolbar
  4gdata
  5time
  6radio
  7paginator
  8jqueryEngine
  9js
  10cache
  11form
  12html
  13session
====

Menu

Upcoming Shows

Affiliates

Recent Requests

Queued

Playing

Queued

May Donations 0 of

April Top 10

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

old_smf

Query Explain:

shr_djs

Query Explain:

kagura

Query Explain:

Memory

Timers

Logs

View Variables

May Donations
0 of