J-Music and Anime Radio :: Shinsen-Radio

Upcoming Shows

DJWicked

1 day, 14 hours

Affiliates

Recent Requests

Maaya Sakamoto ~ Tune the Rainbow	Anonymous	rainbow as seen through polarized
ON/OFF ~ Futatsu no Kodou to Akai Tsumi	HikaruHirako	QwQ
the GazettE ~ Red	Anonymous	^^

Kokoro Odoru -original version- by nobodyknows+

Artist	nobodyknows+
Title	Kokoro Odoru -original version-
Album	Do You Know?
Length	4:12
Year	2004
Genre	J-Rap
Last played	41 minutes ago
Played	229 times
Requested	85 times
Last Requested	1 day, 7 hours ago

Playing

Dj	Kagura-Moto
Artist	Mami Kawada
Title	No Buts!
Album	To Aru Majutsu No Index II OP Single - No Buts!
Genre	Anime OP
Remaining	00:05
Listeners	25
Requester	Anonymous

Queued

February Donations
0 of

Goal:
Current: 0
Last Month: 0

January Top 10

Artist	Title
supercell	My Dearest
Galileo Galilei	Aoi Shiori
VELTPUNCH	CRAWL
Yousei Teikoku	Kuusou Mesorogiwi
Fear, and Loathing in Las Vegas	Chase the Light!
ELISA (Oratorio The World God Only Knows)	God only knows
SPYAIR	Samurai Heart (Some Like Hot!!)
DUSTZ	spiral
marble	Suisai Candy
Natsuko Asou	Perfect-area complete!

History
Request History
4 previous requests available
====
Session
Session
- Config
  userAgentb237457851c17d4fcca55141fcdc6690
  time1329984627
  timeout10
====
Request
Request

Cake Params
- named(empty)
- pass
  05210
- controllersongs
- actionview
- plugin(null)
- url
  exthtml
  urlradio/songinfo/5210
- form(empty)
- isAjax(false)
$_GET
- urlradio/songinfo/5210
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults
  controllersongs
  actionview
  plugin(null)
- template/radio/songinfo/*
- _greedy(true)
- _compiledRoute#^/radio/songinfo(?:/(?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	8	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	14	maybe slow
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)	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	8	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	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	2	maybe slow
SHOW FULL COLUMNS FROM `requestlist`	9	9	7	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 `Song`.`ID`, `Song`.`filename`, `Song`.`diskID`, `Song`.`flags`, `Song`.`songtype`, `Song`.`status`, `Song`.`weight`, `Song`.`balance`, `Song`.`date_added`, `Song`.`date_played`, `Song`.`date_artist_played`, `Song`.`date_album_played`, `Song`.`date_title_played`, `Song`.`duration`, `Song`.`artist`, `Song`.`title`, `Song`.`album`, `Song`.`label`, `Song`.`pline`, `Song`.`trackno`, `Song`.`composer`, `Song`.`ISRC`, `Song`.`catalog`, `Song`.`UPC`, `Song`.`feeagency`, `Song`.`albumyear`, `Song`.`genre`, `Song`.`website`, `Song`.`buycd`, `Song`.`info`, `Song`.`lyrics`, `Song`.`picture`, `Song`.`count_played`, `Song`.`count_requested`, `Song`.`last_requested`, `Song`.`count_performances`, `Song`.`xfade`, `Song`.`bpm`, `Song`.`mood`, `Song`.`rating`, `Song`.`overlay`, `Song`.`playlimit_count`, `Song`.`playlimit_action`, `Song`.`songrights`, `Song`.`adz_listID`, `Song`.`id` FROM `songlist` AS `Song` WHERE `Song`.`id` = '5210' ORDER BY `date_added` DESC, `ID` DESC LIMIT 1	1	1	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	0
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-1-31 00:00:00' AND Request.t_stamp >= '2012-1-1 00:00:00' GROUP BY Song.id, Song.artist, Song.title ORDER BY RequestCount DESC LIMIT 10	10	10	25	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 19.51 MB

Message	Memory use
Component intitailization	14.52 MB
Controller action start	14.65 MB
Controller render start	15.22 MB
Component intitailization #2	18.41 MB
Controller action start #2	18.43 MB
Component intitailization #3	18.50 MB
Controller action start #3	18.51 MB
View render complete	18.34 MB

Timers

Total Request Time: 412 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	230.96
Component initialization and startup	2.48
Controller action	12.42
Render Controller Action	94.49
» Rendering View	92.04
» » Rendering APP/views/songs/view.ctp	27.11
» » » Rendering APP/views/elements/album_art.ctp	0.32
» » Rendering APP/views/themed/shr-luv/layouts/default.ctp	64.37
» » » Rendering APP/views/elements/top.ctp	1.68
» » » Rendering APP/views/themed/shr-luv/elements/header.ctp	0.16
» » » Rendering APP/views/elements/column_left.ctp	5.60
» » » » Rendering APP/views/elements/menu.ctp	2.98
» » » » Rendering APP/views/elements/upcoming_shows.ctp	0.59
» » » » Rendering APP/views/elements/affiliates.ctp	1.35
» » » Rendering APP/views/elements/requests/content.ctp	5.98
» » » » Rendering APP/views/elements/paypal-saso.ctp	0.26
» » » Rendering APP/views/elements/column_right.ctp	46.11
» » » » Rendering APP/views/elements/playing.ctp	2.37
» » » » Rendering APP/views/elements/queued.ctp	6.75
» » » » » Component initialization and startup #2	1.38
Controller action #2	0.00
» » » » » Rendering APP/views/elements/donations.ctp	0.68
» » » » » Rendering APP/views/elements/most_requested.ctp	35.44
» » » » » » Component initialization and startup #3	1.22
Controller action #3	0.00
» » » » » Rendering APP/views/elements/powered_by.ctp	1.90

====

Log

Logs

====
Variables
View Variables
- song
  Song
  ID5210
  filenamez:\music\nobodyknows+ incomplete disco\nobodyknows+ - Do You Know - Kokoro Odoru -original version-.mp3
  diskID0
  flagsNNNNNNNNNN
  songtypeS
  status0
  weight266
  balance2.89782
  date_added2009-05-11 19:35:47
  date_played2012-02-23 04:09:00
  date_artist_played2012-02-23 04:09:00
  date_album_played2012-02-23 04:09:00
  date_title_played2012-02-23 04:09:00
  duration251.716
  artistnobodyknows+
  titleKokoro Odoru -original version-
  albumDo You Know?
  labelSONY MUSIC ENTERTAINMENT
  pline
  trackno7
  composernobodyknows+
  ISRC
  catalog
  UPC
  feeagency
  albumyear2004
  genreJ-Rap
  website
  buycd
  info(null)
  lyrics(null)
  picture
  count_played229
  count_requested85
  last_requested2012-02-21 21:01:51
  count_performances4812
  xfade
  bpm0
  mood
  rating0
  overlayno
  playlimit_count0
  playlimit_actionnone
  songrightsbroadcast
  adz_listID0
  id5210
- 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
  songID7466
  duration215.144
  artistMami Kawada
  titleNo buts!
  albumTo Aru Majutsu no Index II OP Single - No buts!
  requestID43682
  insertDate2012-02-23 04:46:57
  genreAnime OP
  Request
  ID43682
  songID7466
  nameAnonymous
  msg(null)
  total_listeners25
- 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
  7cache
  8session
  9jqueryEngine
  10js
  11paginator
  12html
  13form
  14filter
====

Menu

Upcoming Shows

DJWicked

Affiliates

Recent Requests

Kokoro Odoru -original version- by nobodyknows+

Playing

Queued

February Donations 0 of

January 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

February Donations
0 of