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 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 next >>

Page 1 of 16, showing 20 records out of 315 total, starting on record 1, ending on 20

artist	title	album	genre	duration

The Pillows	Blues Drive Monster	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	03:27
The Pillows	Crazy Sunshine	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	04:09
The Pillows	Nightmare	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	01:03
The Pillows	Patricia	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	01:38
The Pillows	I Think I Can	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	07:39
The Pillows	Funny Bunny	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	03:39
The Pillows	Last Dinosaur	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	03:46
The Pillows	Another Morning	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	04:38
The Pillows	White Ash	Fooly Cooly Ost 2 - King Of Pirates	J-Rock	01:21
The Pillows	Ride On Shooting Star	Fooly Cooly OST 3	J-Rock	02:23
The Pillows	Come Down	Fooly Cooly OST 3	J-Rock	02:09
The Pillows	Sleepy Head	Fooly Cooly OST 3	J-Rock	03:02
The Pillows	I Think I Can	Fooly Cooly OST 3	J-Rock	03:01
The Pillows	Sad Sad Kiddie	Fooly Cooly OST 3	J-Rock	03:12
The Pillows	Funny Bunny	Fooly Cooly OST 3	J-Rock	03:37
The Pillows	Stalker	Fooly Cooly OST 3	J-Rock	02:37
The Pillows	Nightmare	Fooly Cooly OST 3	J-Rock	01:43
The Pillows	Little Busters	Fooly Cooly OST 3	J-Rock	03:46
The Pillows	Hybrid Rainbow	Fooly Cooly OST 3	J-Rock	04:00
The Pillows	Carnival	Fooly Cooly OST 3	J-Rock	03:50

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

Playing

Dj	Kagura-Moto
Artist	BECCA
Title	Leave Me Alone
Album	BEST
Genre	J-Rock
Remaining	02:25
Listeners	24
Requester

Queued

Jean-Jacques Burnel ~ You won't see me coming (FULL)

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
  time1337417140
  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
  page1
  Song.artistThe Pillows
  sortartist
  directionasc
- pass(empty)
- plugin(null)
- url
  exthtml
  urlsongs/index/page:1/Song.artist:The Pillows/sort:artist/direction:asc
- form(empty)
- isAjax(false)
- paging
  Song
  page1
  current20
  count315
  prevPage(false)
  nextPage(true)
  pageCount16
  defaults
  limit20
  step1
  conditions
  Song.artist LIKE%The%Pillows%
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
  options
  page1
  limit20
  conditions
  Song.artist LIKE%The%Pillows%
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
  order
  Song.artistasc
$_GET
- urlsongs/index/page:1/Song.artist:The Pillows/sort: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	1	maybe slow
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)	Actions
SHOW FULL COLUMNS FROM `smf_members`	57	57	8	maybe slow
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)
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	0
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 '%The%Pillows%'	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 '%The%Pillows%' ORDER BY `Song`.`artist` asc LIMIT 20	20	20	11	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-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	61	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 20.72 MB

Message	Memory use
Component intitailization	15.05 MB
Controller action start	15.18 MB
Controller render start	15.72 MB
Component intitailization #2	19.07 MB
Controller action start #2	19.08 MB
Component intitailization #3	19.16 MB
Controller action start #3	19.18 MB
View render complete	18.98 MB

Timers

Total Request Time: 2063 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	236.23
Component initialization and startup	2.53
Controller action	25.56
Render Controller Action	1625.78
» Rendering View	1623.29
» » Rendering APP/views/songs/index.ctp	158.78
» » Rendering APP/views/themed/shr-luv/layouts/default.ctp	1463.87
» » » Rendering APP/views/elements/top.ctp	1.44
» » » Rendering APP/views/themed/shr-luv/elements/header.ctp	0.17
» » » Rendering APP/views/elements/column_left.ctp	1371.90
» » » » Rendering APP/views/elements/menu.ctp	2.88
» » » » Rendering APP/views/elements/upcoming_shows.ctp	1367.49
» » » » Rendering APP/views/elements/affiliates.ctp	0.85
» » » Rendering APP/views/elements/requests/content.ctp	5.11
» » » » Rendering APP/views/elements/paypal-saso.ctp	0.17
» » » Rendering APP/views/elements/column_right.ctp	81.24
» » » » Rendering APP/views/elements/playing.ctp	2.19
» » » » Rendering APP/views/elements/queued.ctp	6.79
» » » » » Component initialization and startup #2	1.18
Controller action #2	0.00
» » » » » Rendering APP/views/elements/donations.ctp	0.59
» » » » » Rendering APP/views/elements/most_requested.ctp	70.80
» » » » » » Component initialization and startup #3	1.09
Controller action #3	0.00
» » » » » Rendering APP/views/elements/powered_by.ctp	1.82

====

Log

Logs

====
Variables
View Variables
- queryData
  Song.artistThe Pillows
- query
  Song
  conditions
  Song.artist LIKE%The%Pillows%
  directionasc
  page1
  sortartist
- vfMaps
  Song.-allall
- songs
  0
  Song
  ID2221
  artistThe Pillows
  titleBlues Drive Monster
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration206.55
  id2221
  1
  Song
  ID2222
  artistThe Pillows
  titleCrazy Sunshine
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration249.051
  id2222
  2
  Song
  ID2223
  artistThe Pillows
  titleNightmare
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration63.033
  id2223
  3
  Song
  ID2224
  artistThe Pillows
  titlePatricia
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration98.325
  id2224
  4
  Song
  ID2225
  artistThe Pillows
  titleI Think I Can
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration458.684
  id2225
  5
  Song
  ID2226
  artistThe Pillows
  titleFunny Bunny
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration219.037
  id2226
  6
  Song
  ID2227
  artistThe Pillows
  titleLast Dinosaur
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration225.515
  id2227
  7
  Song
  ID2228
  artistThe Pillows
  titleAnother Morning
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration277.656
  id2228
  8
  Song
  ID2229
  artistThe Pillows
  titleWhite Ash
  albumFooly Cooly Ost 2 - King Of Pirates
  genreJ-Rock
  duration80.823
  id2229
  9
  Song
  ID2230
  artistThe Pillows
  titleRide On Shooting Star
  albumFooly Cooly OST 3
  genreJ-Rock
  duration142.628
  id2230
  10
  Song
  ID2231
  artistThe Pillows
  titleCome Down
  albumFooly Cooly OST 3
  genreJ-Rock
  duration129.477
  id2231
  11
  Song
  ID2232
  artistThe Pillows
  titleSleepy Head
  albumFooly Cooly OST 3
  genreJ-Rock
  duration181.9
  id2232
  12
  Song
  ID2233
  artistThe Pillows
  titleI Think I Can
  albumFooly Cooly OST 3
  genreJ-Rock
  duration180.569
  id2233
  13
  Song
  ID2234
  artistThe Pillows
  titleSad Sad Kiddie
  albumFooly Cooly OST 3
  genreJ-Rock
  duration191.946
  id2234
  14
  Song
  ID2235
  artistThe Pillows
  titleFunny Bunny
  albumFooly Cooly OST 3
  genreJ-Rock
  duration217.126
  id2235
  15
  Song
  ID2236
  artistThe Pillows
  titleStalker
  albumFooly Cooly OST 3
  genreJ-Rock
  duration156.85
  id2236
  16
  Song
  ID2237
  artistThe Pillows
  titleNightmare
  albumFooly Cooly OST 3
  genreJ-Rock
  duration103.07
  id2237
  17
  Song
  ID2238
  artistThe Pillows
  titleLittle Busters
  albumFooly Cooly OST 3
  genreJ-Rock
  duration225.946
  id2238
  18
  Song
  ID2239
  artistThe Pillows
  titleHybrid Rainbow
  albumFooly Cooly OST 3
  genreJ-Rock
  duration240.428
  id2239
  19
  Song
  ID2240
  artistThe Pillows
  titleCarnival
  albumFooly Cooly OST 3
  genreJ-Rock
  duration229.703
  id2240
- 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
  songID8065
  duration239.522
  artistBECCA
  titleLeave Me Alone
  albumBEST
  requestID0
  insertDate2012-05-19 05:24:08
  genreJ-Rock
  Request
  ID(null)
  songID(null)
  name(null)
  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

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