J-Music and Anime Radio :: Shinsen-Radio

Upcoming Shows

DJWicked

1 day, 13 hours

Affiliates

Recent Requests

Shouko Nakagawa ~ RAY OF LIGHT	Anonymous	For the lawls. :D
Maaya Sakamoto ~ Tune the Rainbow	Anonymous	rainbow as seen through polarized
ON/OFF ~ Futatsu no Kodou to Akai Tsumi	HikaruHirako	QwQ

Songs

<< previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 next >>

Page 1 of 10, showing 20 records out of 198 total, starting on record 1, ending on 20

artist	title	album	genre	duration

KOTOKO	Candy or Chocolate	Shakugan no Shana III OP Single - Light My Fire	J-Pop	05:05
KOTOKO	Light My Fire	Shakugan no Shana III OP Single - Light My Fire	Anime OP	03:49
KOTOKO	Raimei ga Nakugoro	Motto To LOVE-Ru OP Single - Loop-the-loop	Anime	05:56
KOTOKO	Loop-the-Loop	Motto To LOVE-Ru OP Single - Loop-the-loop	Anime OP	04:13
KOTOKO	Second Flight	Onegai Twins	Anime	05:43
KOTOKO	being	being	Anime	04:50
KOTOKO	Re-sublimity		Anime	04:43
KOTOKO	Snow Angel	I've - Compilation	Anime	04:27
KOTOKO	Re-sublimity (Karaoke)	(I've) KOTOKO - Re-sublimity	Anime	05:19
KOTOKO	Suppuration -core-	singleure-sublimity	Anime	05:37
KOTOKO	Love A Riddle	Onetei Image Theme Song	Anime	06:32
KOTOKO	I Can't Get Over Your Best Smile	Onegai Teacher	Anime	07:10
KOTOKO	Agony	Kannaduki no Miko OP & ED Single	Anime ED	04:22
KOTOKO	Agony (Instrumental)	Re-sublimity	Anime	04:22
KOTOKO	Ano Hi no Kimi e	Onegai Teacher: Vocal Best Album CD1 (LACA-9021)	Anime	06:12
KOTOKO	Cider	UZU-MAKI	J-Pop	04:53
KOTOKO	Goodbye Dear	UZU-MAKI	J-Pop	05:01
KOTOKO	Fuchidori no Sekai	UZU-MAKI	J-Pop	05:28
KOTOKO	Sekka no Shinwa -in X'mas mix-	UZU-MAKI	J-Pop	06:37
KOTOKO	Iruka	UZU-MAKI	J-Pop	04:52

<< previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 next >>

Playing

Dj	Kagura-Moto
Artist	Yui Horie
Title	Monochrome
Album	Papa No Iu Koto Wa Kikinasai! ED Single - Coloring
Genre	J-Pop
Remaining	01:05
Listeners	24
Requester	Anonymous

Queued

Yui Horie ~ Coloring

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
  time1329985620
  timeout10
====
Request
Request

Cake Params
- controllersongs
- actionindex
- named
  Song.artistKOTOKO
- pass(empty)
- plugin(null)
- url
  exthtml
  urlsongs/index/Song.artist:KOTOKO
- form(empty)
- isAjax(false)
- paging
  Song
  page1
  current20
  count198
  prevPage(false)
  nextPage(true)
  pageCount10
  defaults
  limit20
  step1
  conditions
  Song.artist LIKE%KOTOKO%
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
  options
  page1
  limit20
  conditions
  Song.artist LIKE%KOTOKO%
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
$_GET
- urlsongs/index/Song.artist:KOTOKO
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	0
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	1
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	0

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 `songlist` AS `Song` WHERE `Song`.`artist` LIKE '%KOTOKO%'	1	1	12	maybe slow
SELECT `Song`.`ID`, `Song`.`artist`, `Song`.`title`, `Song`.`album`, `Song`.`genre`, `Song`.`duration`, `Song`.`id` FROM `songlist` AS `Song` WHERE `Song`.`artist` LIKE '%KOTOKO%' ORDER BY `date_added` DESC, `ID` DESC LIMIT 20	20	20	28	maybe slow
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	1	1	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	24	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 20.04 MB

Message	Memory use
Component intitailization	14.53 MB
Controller action start	14.66 MB
Controller render start	15.20 MB
Component intitailization #2	18.47 MB
Controller action start #2	18.48 MB
Component intitailization #3	18.56 MB
Controller action start #3	18.58 MB
View render complete	18.38 MB

Timers

Total Request Time: 633 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	217.27
Component initialization and startup	10.14
Controller action	45.41
Render Controller Action	212.94
» Rendering View	210.68
» » Rendering APP/views/songs/index.ctp	143.74
» » Rendering APP/views/themed/shr-luv/layouts/default.ctp	66.46
» » » Rendering APP/views/elements/top.ctp	1.69
» » » Rendering APP/views/themed/shr-luv/elements/header.ctp	0.30
» » » Rendering APP/views/elements/column_left.ctp	5.15
» » » » Rendering APP/views/elements/menu.ctp	2.95
» » » » Rendering APP/views/elements/upcoming_shows.ctp	0.78
» » » » Rendering APP/views/elements/affiliates.ctp	0.78
» » » Rendering APP/views/elements/requests/content.ctp	8.20
» » » » Rendering APP/views/elements/paypal-saso.ctp	0.29
» » » Rendering APP/views/elements/column_right.ctp	46.80
» » » » Rendering APP/views/elements/playing.ctp	2.18
» » » » Rendering APP/views/elements/queued.ctp	7.59
» » » » » Component initialization and startup #2	1.01
Controller action #2	0.00
» » » » » Rendering APP/views/elements/donations.ctp	0.89
» » » » » Rendering APP/views/elements/most_requested.ctp	34.77
» » » » » » Component initialization and startup #3	1.11
Controller action #3	0.00
» » » » » Rendering APP/views/elements/powered_by.ctp	2.02

====

Log

Logs

====
Variables
View Variables
- queryData
  Song.artistKOTOKO
- query
  Song
  conditions
  Song.artist LIKE%KOTOKO%
- vfMaps
  Song.-allall
- songs
  0
  Song
  ID8657
  artistKOTOKO
  titleCandy or Chocolate
  albumShakugan no Shana III OP Single - Light My Fire
  genreJ-Pop
  duration304.953
  id8657
  1
  Song
  ID8656
  artistKOTOKO
  titleLight My Fire
  albumShakugan no Shana III OP Single - Light My Fire
  genreAnime OP
  duration229.12
  id8656
  2
  Song
  ID7347
  artistKOTOKO
  titleRaimei ga Nakugoro
  albumMotto To LOVE-Ru OP Single - Loop-the-loop
  genreAnime
  duration355.579
  id7347
  3
  Song
  ID7346
  artistKOTOKO
  titleLoop-the-Loop
  albumMotto To LOVE-Ru OP Single - Loop-the-loop
  genreAnime OP
  duration253.492
  id7346
  4
  Song
  ID5482
  artistKOTOKO
  titleSecond Flight
  albumOnegai Twins
  genreAnime
  duration342.7
  id5482
  5
  Song
  ID4381
  artistKOTOKO
  titlebeing
  albumbeing
  genreAnime
  duration289.593
  id4381
  6
  Song
  ID4346
  artistKOTOKO
  titleRe-sublimity
  album
  genreAnime
  duration282.671
  id4346
  7
  Song
  ID4328
  artistKOTOKO
  titleSnow Angel
  albumI've - Compilation
  genreAnime
  duration267.337
  id4328
  8
  Song
  ID4310
  artistKOTOKO
  titleRe-sublimity (Karaoke)
  album(I've) KOTOKO - Re-sublimity
  genreAnime
  duration318.563
  id4310
  9
  Song
  ID4296
  artistKOTOKO
  titleSuppuration -core-
  albumsingleure-sublimity
  genreAnime
  duration337.319
  id4296
  10
  Song
  ID4017
  artistKOTOKO
  titleLove A Riddle
  albumOnetei Image Theme Song
  genreAnime
  duration392.106
  id4017
  11
  Song
  ID3760
  artistKOTOKO
  titleI Can't Get Over Your Best Smile
  albumOnegai Teacher
  genreAnime
  duration430.43
  id3760
  12
  Song
  ID3731
  artistKOTOKO
  titleAgony
  albumKannaduki no Miko OP & ED Single
  genreAnime ED
  duration262.086
  id3731
  13
  Song
  ID3693
  artistKOTOKO
  titleAgony (Instrumental)
  albumRe-sublimity
  genreAnime
  duration261.616
  id3693
  14
  Song
  ID3686
  artistKOTOKO
  titleAno Hi no Kimi e
  albumOnegai Teacher: Vocal Best Album CD1 (LACA-9021)
  genreAnime
  duration372.454
  id3686
  15
  Song
  ID2705
  artistKOTOKO
  titleCider
  albumUZU-MAKI
  genreJ-Pop
  duration293.277
  id2705
  16
  Song
  ID2704
  artistKOTOKO
  titleGoodbye Dear
  albumUZU-MAKI
  genreJ-Pop
  duration300.591
  id2704
  17
  Song
  ID2703
  artistKOTOKO
  titleFuchidori no Sekai
  albumUZU-MAKI
  genreJ-Pop
  duration327.941
  id2703
  18
  Song
  ID2702
  artistKOTOKO
  titleSekka no Shinwa -in X'mas mix-
  albumUZU-MAKI
  genreJ-Pop
  duration396.722
  id2702
  19
  Song
  ID2701
  artistKOTOKO
  titleIruka
  albumUZU-MAKI
  genreJ-Pop
  duration292.023
  id2701
- 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
  songID8770
  duration246.544
  artistYui Horie
  titleMonochrome
  albumPapa no Iu Koto wa Kikinasai! ED Single - Coloring
  requestID43685
  insertDate2012-02-23 05:04:00
  genreJ-Pop
  Request
  ID43685
  songID8770
  nameAnonymous
  msg(null)
  total_listeners24
- 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

Songs

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