J-Music and Anime Radio :: Shinsen-Radio

Upcoming Shows

Affiliates

Recent Requests

MONKEY MAJIK ~ Open Happiness	Anonymous	A change from heavy metal. =_=
Momoiro Clover Z ~ Mouretsu Uchuu Koukyou Kyoku Dai Nana Gakushou "Mugen no Ai"	Goodwine	Needed this :)
Boom Boom Satellites ~ Easy Action	aho	\:D/

Songs

<< previous | next >>

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

artist	title	album	genre	duration

azusa	Rainco Rainbow	Amagami SS+ ED Single - Kokuhaku	J-Pop	03:06
azusa	Anata no Tame ni	Amagami SS+ ED Single - Kokuhaku	J-Pop	04:32
azusa	Kokuhaku	Amagami SS+ ED Single - Kokuhaku	Anime ED	04:36
azusa	Shiny Day	Amagami SS+ OP Single - Check my soul	J-Pop	03:46
azusa	Check my soul	Amagami SS+ OP Single - Check my soul	Anime OP	03:36
azusa	All For You	Amagami SS+ OP Single - Check my soul	J-Pop	03:50
Hikaru Midorikawa (Yoh) & Kenichi Suzumura (Tsubasa) & Jun Fukuyama (Azusa)	Starry Days Vocal Version	Starry Sky Main Theme Single - Starry Days	Anime	03:49
azusa	pastel	Astarotte no Omocha! ED Single - Manatsu no Photograph	J-Pop	04:43
azusa	Good Day!	Astarotte no Omocha! ED Single - Manatsu no Photograph	J-Pop	03:17
azusa	Manatsu no Photograph	Astarotte no Omocha! ED Single - Manatsu no Photograph	Anime ED	04:27
azusa	I wish	Moshidora OP Single - Yume Note	J-Pop	04:08
azusa	Precious time	Moshidora OP Single - Yume Note	J-Pop	04:12
azusa	Yume Note	Moshidora OP Single - Yume Note	Anime OP	03:49
Azusa Kataoka	Diamond Sparkle	Single	Anime	03:32

<< previous | next >>

Playing

Dj	Kagura-Moto
Artist	MONKEY MAJIK
Title	Open Happiness
Album	MONKEY MAJIK BEST ~10years & Forever~
Genre	J-Pop
Remaining	01:24
Listeners	21
Requester	Anonymous
A change from heavy metal. =_=

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
  time1337414364
  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
- controllersongs
- actionindex
- named
  Song.artistazusa
- pass(empty)
- plugin(null)
- url
  exthtml
  urlsongs/index/Song.artist:azusa
- form(empty)
- isAjax(false)
- paging
  Song
  page1
  current14
  count14
  prevPage(false)
  nextPage(false)
  pageCount1
  defaults
  limit20
  step1
  conditions
  Song.artist LIKE%azusa%
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
  options
  page1
  limit20
  conditions
  Song.artist LIKE%azusa%
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
$_GET
- urlsongs/index/Song.artist:azusa
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	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	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)	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	0
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	0
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 '%azusa%'	1	1	10	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 '%azusa%' ORDER BY `date_added` DESC, `ID` DESC LIMIT 20	14	14	10	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	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-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	64	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 20.61 MB

Message	Memory use
Component intitailization	15.04 MB
Controller action start	15.17 MB
Controller render start	15.70 MB
Component intitailization #2	19.03 MB
Controller action start #2	19.04 MB
Component intitailization #3	19.12 MB
Controller action start #3	19.13 MB
View render complete	18.94 MB

Timers

Total Request Time: 1900 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	192.03
Component initialization and startup	2.48
Controller action	25.17
Render Controller Action	1511.42
» Rendering View	1509.24
» » Rendering APP/views/songs/index.ctp	83.65
» » Rendering APP/views/themed/shr-luv/layouts/default.ctp	1425.11
» » » Rendering APP/views/elements/top.ctp	1.51
» » » Rendering APP/views/themed/shr-luv/elements/header.ctp	0.21
» » » Rendering APP/views/elements/column_left.ctp	1328.73
» » » » Rendering APP/views/elements/menu.ctp	2.91
» » » » Rendering APP/views/elements/upcoming_shows.ctp	1324.02
» » » » Rendering APP/views/elements/affiliates.ctp	0.94
» » » Rendering APP/views/elements/requests/content.ctp	6.23
» » » » Rendering APP/views/elements/paypal-saso.ctp	0.21
» » » Rendering APP/views/elements/column_right.ctp	83.70
» » » » Rendering APP/views/elements/playing.ctp	2.46
» » » » Rendering APP/views/elements/queued.ctp	5.72
» » » » » Component initialization and startup #2	0.93
Controller action #2	0.00
» » » » » Rendering APP/views/elements/donations.ctp	0.57
» » » » » Rendering APP/views/elements/most_requested.ctp	74.03
» » » » » » Component initialization and startup #3	0.93
Controller action #3	0.00
» » » » » Rendering APP/views/elements/powered_by.ctp	2.39

====

Log

Logs

====
Variables
View Variables
- queryData
  Song.artistazusa
- query
  Song
  conditions
  Song.artist LIKE%azusa%
- vfMaps
  Song.-allall
- songs
  0
  Song
  ID8795
  artistazusa
  titleRainco Rainbow
  albumAmagami SS+ ED Single - Kokuhaku
  genreJ-Pop
  duration185.522
  id8795
  1
  Song
  ID8794
  artistazusa
  titleAnata no Tame ni
  albumAmagami SS+ ED Single - Kokuhaku
  genreJ-Pop
  duration272.379
  id8794
  2
  Song
  ID8793
  artistazusa
  titleKokuhaku
  albumAmagami SS+ ED Single - Kokuhaku
  genreAnime ED
  duration275.67
  id8793
  3
  Song
  ID8773
  artistazusa
  titleShiny Day
  albumAmagami SS+ OP Single - Check my soul
  genreJ-Pop
  duration226.116
  id8773
  4
  Song
  ID8772
  artistazusa
  titleCheck my soul
  albumAmagami SS+ OP Single - Check my soul
  genreAnime OP
  duration216.137
  id8772
  5
  Song
  ID8771
  artistazusa
  titleAll For You
  albumAmagami SS+ OP Single - Check my soul
  genreJ-Pop
  duration229.721
  id8771
  6
  Song
  ID8353
  artistHikaru Midorikawa (Yoh) & Kenichi Suzumura (Tsubasa) & Jun Fukuyama (Azusa)
  titleStarry Days Vocal Version
  albumStarry Sky Main Theme Single - Starry Days
  genreAnime
  duration229.433
  id8353
  7
  Song
  ID8316
  artistazusa
  titlepastel
  albumAstarotte no Omocha! ED Single - Manatsu no Photograph
  genreJ-Pop
  duration283.402
  id8316
  8
  Song
  ID8315
  artistazusa
  titleGood Day!
  albumAstarotte no Omocha! ED Single - Manatsu no Photograph
  genreJ-Pop
  duration197.407
  id8315
  9
  Song
  ID8314
  artistazusa
  titleManatsu no Photograph
  albumAstarotte no Omocha! ED Single - Manatsu no Photograph
  genreAnime ED
  duration266.867
  id8314
  10
  Song
  ID8196
  artistazusa
  titleI wish
  albumMoshidora OP Single - Yume Note
  genreJ-Pop
  duration247.641
  id8196
  11
  Song
  ID8195
  artistazusa
  titlePrecious time
  albumMoshidora OP Single - Yume Note
  genreJ-Pop
  duration251.82
  id8195
  12
  Song
  ID8194
  artistazusa
  titleYume Note
  albumMoshidora OP Single - Yume Note
  genreAnime OP
  duration228.963
  id8194
  13
  Song
  ID2869
  artistAzusa Kataoka
  titleDiamond Sparkle
  albumSingle
  genreAnime
  duration212.01
  id2869
- 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
  songID6742
  duration252.343
  artistMONKEY MAJIK
  titleOpen Happiness
  albumMONKEY MAJIK BEST ~10years & Forever~
  requestID50418
  insertDate2012-05-19 04:36:38
  genreJ-Pop
  Request
  ID50418
  songID6742
  nameAnonymous
  msgA change from heavy metal. =_=
  total_listeners21
- 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

Affiliates

Recent Requests

Songs

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