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:

Song Histories

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

Page 1 of 24910, showing 20 records out of 498194 total, starting on record 1, ending on 20

Artist	Title	Album	Requested	Duration

Kawai Kenji	COMMUNIST CAMP	Gundam 00 Original Soundtrack 01	no	01:51
RIP SLYME	MORE & MORE	GOOD JOB!	no	03:60
move	BREAK IN2 THE NITE (t-kimura broken beat mix)	remixers play move	no	05:17
Tommy february6	Since Yesterday	Everyday At The Bus Stop	no	04:06
The Brilliant Green	Intro - THE WINTER ALBUM	THE WINTER ALBUM	no	01:05
Onmyouza	mokumokuren	Youka Ninpouchou	no	06:60
The Pillows	Moon Margaret	Penalty Life	no	03:59
Nami (Akemi Okamura) & Robin (Yuriko Yamaguchi)	Hurricane Girls Remix Version Remixed by kors k(Upsurge)	Hurricane Girls	no	05:04
SEATBELTS	Hamduche	Ask DNA Cowboy Bebop -Knockin' on heaven's door-	no	01:54
L'arc en Ciel	What is love	ark	no	04:14
Yoko Kanno	Fingers	COWBOY BEBOP O.S.T. FUTURE BLUES	no	04:25
move	Singin' 4 U	Words Of The Mind	no	05:18
Infected Mushroom	In Front of Me	Vicious Delicious	no	04:29
Ikimonogakari	HANABI	BLEACH THE BEST	no	04:27
Dream	Get Over (Special Mix)	Hikaru no Go - Best Of	no	10:19
The Pillows	Sono Mirai Wa Ima	Sono Mirai Wa Ima	no	03:26
ALI PROJECT	GOD DIVA	.hack//Roots Original Soundtrack	no	04:15
Yuta, Toshi, Chiho And Jiro's Session	Sad Sad Kiddie		no	03:40
Negishi Satori	STARGAZER ~Hoshi no Tobira~	Gundam Seed	no	04:31
Shunichi Miyamoto	Caged Bird	DNAngel	no	05:40

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

Playing

Dj	Kagura-Moto
Artist	Megumi Nakajima (Ranka Lee)
Title	Houkago Overflow
Album	Macross Frontier ~Sayonara No Tsubasa~ Netabare Album The End Of "triangle"
Genre	Anime
Remaining	05:10
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
  time1337407554
  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
- controllersong_histories
- actionindex
- named
  page1
  sortrequestID
  directionasc
- pass(empty)
- plugin(null)
- url
  exthtml
  urlsong_histories/index/page:1/sort:requestID/direction:asc
- form(empty)
- isAjax(false)
- paging
  SongHistory
  page1
  current20
  count498194
  prevPage(false)
  nextPage(true)
  pageCount24910
  defaults
  limit20
  step1
  fields
  0ID
  1songID
  2requestID
  3artist
  4album
  5title
  6duration
  orderSongHistory.date_played DESC
  conditions(empty)
  options
  page1
  limit20
  fields
  0ID
  1songID
  2requestID
  3artist
  4album
  5title
  6duration
  order
  SongHistory.requestIDasc
  conditions(empty)
$_GET
- urlsong_histories/index/page:1/sort:requestID/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	2	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	2
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	4	maybe slow
SHOW FULL COLUMNS FROM `smf_membergroups`	6	6	3	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	2
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 `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	1	1	2999	maybe slow
SELECT `SongHistory`.`ID`, `SongHistory`.`songID`, `SongHistory`.`requestID`, `SongHistory`.`artist`, `SongHistory`.`album`, `SongHistory`.`title`, `SongHistory`.`duration` 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`.`requestID` asc LIMIT 20	20	20	404	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	42	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 20.85 MB

Message	Memory use
Component intitailization	15.02 MB
Controller action start	15.14 MB
Controller render start	15.68 MB
Component intitailization #2	19.02 MB
Controller action start #2	19.03 MB
Component intitailization #3	19.20 MB
Controller action start #3	19.22 MB
View render complete	19.02 MB

Timers

Total Request Time: 5284 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	266.14
Component initialization and startup	3.22
Controller action	3407.50
Render Controller Action	1506.59
» Rendering View	1504.13
» » Rendering APP/views/song_histories/index.ctp	99.94
» » Rendering APP/views/themed/shr-luv/layouts/default.ctp	1403.69
» » » Rendering APP/views/elements/top.ctp	1.44
» » » Rendering APP/views/themed/shr-luv/elements/header.ctp	0.37
» » » Rendering APP/views/elements/column_left.ctp	1328.96
» » » » Rendering APP/views/elements/menu.ctp	2.79
» » » » Rendering APP/views/elements/upcoming_shows.ctp	1324.50
» » » » Rendering APP/views/elements/affiliates.ctp	0.94
» » » Rendering APP/views/elements/requests/content.ctp	6.43
» » » » Rendering APP/views/elements/paypal-saso.ctp	0.26
» » » Rendering APP/views/elements/column_right.ctp	62.07
» » » » Rendering APP/views/elements/playing.ctp	2.48
» » » » Rendering APP/views/elements/queued.ctp	5.98
» » » » » Component initialization and startup #2	0.92
Controller action #2	0.00
» » » » » Rendering APP/views/elements/donations.ctp	0.57
» » » » » Rendering APP/views/elements/most_requested.ctp	52.13
» » » » » » Component initialization and startup #3	0.96
Controller action #3	0.00
» » » » » Rendering APP/views/elements/powered_by.ctp	2.17

====

Log

Logs

====
Variables
View Variables
- queryData(empty)
- query
  directionasc
  page1
  sortrequestID
- vfMaps(null)
- songs
  0
  SongHistory
  ID1
  songID19
  requestID0
  artistKawai Kenji
  albumGundam 00 Original Soundtrack 01
  titleCOMMUNIST CAMP
  duration111.047
  1
  SongHistory
  ID2
  songID929
  requestID0
  artistRIP SLYME
  albumGOOD JOB!
  titleMORE & MORE
  duration239.607
  2
  SongHistory
  ID3
  songID774
  requestID0
  artistmove
  albumremixers play move
  titleBREAK IN2 THE NITE (t-kimura broken beat mix)
  duration316.862
  3
  SongHistory
  ID4
  songID831
  requestID0
  artistTommy february6
  albumEveryday At The Bus Stop
  titleSince Yesterday
  duration246.021
  4
  SongHistory
  ID5
  songID679
  requestID0
  artistThe Brilliant Green
  albumTHE WINTER ALBUM
  titleIntro - THE WINTER ALBUM
  duration64.575
  5
  SongHistory
  ID6
  songID575
  requestID0
  artistOnmyouza
  albumYouka Ninpouchou
  titlemokumokuren
  duration419.971
  6
  SongHistory
  ID7
  songID2404
  requestID0
  artistThe Pillows
  albumPenalty Life
  titleMoon Margaret
  duration239.308
  7
  SongHistory
  ID8
  songID2991
  requestID0
  artistNami (Akemi Okamura) & Robin (Yuriko Yamaguchi)
  albumHurricane Girls
  titleHurricane Girls Remix Version Remixed by kors k(Upsurge)
  duration303.909
  8
  SongHistory
  ID9
  songID3070
  requestID0
  artistSEATBELTS
  albumAsk DNA Cowboy Bebop -Knockin' on heaven's door-
  titleHamduche
  duration114.129
  9
  SongHistory
  ID10
  songID1524
  requestID0
  artistL'arc en Ciel
  albumark
  titleWhat is love
  duration253.858
  10
  SongHistory
  ID11
  songID3062
  requestID0
  artistYoko Kanno
  albumCOWBOY BEBOP O.S.T. FUTURE BLUES
  titleFingers
  duration264.568
  11
  SongHistory
  ID12
  songID800
  requestID0
  artistmove
  albumWords Of The Mind
  titleSingin' 4 U
  duration317.623
  12
  SongHistory
  ID13
  songID1366
  requestID0
  artistInfected Mushroom
  albumVicious Delicious
  titleIn Front of Me
  duration268.696
  13
  SongHistory
  ID14
  songID4291
  requestID0
  artistIkimonogakari
  albumBLEACH THE BEST
  titleHANABI
  duration267.468
  14
  SongHistory
  ID15
  songID3881
  requestID0
  artistDream
  albumHikaru no Go - Best Of
  titleGet Over (Special Mix)
  duration618.736
  15
  SongHistory
  ID16
  songID2268
  requestID0
  artistThe Pillows
  albumSono Mirai Wa Ima
  titleSono Mirai Wa Ima
  duration205.954
  16
  SongHistory
  ID17
  songID2981
  requestID0
  artistALI PROJECT
  album.hack//Roots Original Soundtrack
  titleGOD DIVA
  duration255.164
  17
  SongHistory
  ID18
  songID2475
  requestID0
  artistYuta, Toshi, Chiho And Jiro's Session
  album
  titleSad Sad Kiddie
  duration220.238
  18
  SongHistory
  ID19
  songID4010
  requestID0
  artistNegishi Satori
  albumGundam Seed
  titleSTARGAZER ~Hoshi no Tobira~
  duration270.785
  19
  SongHistory
  ID20
  songID3891
  requestID0
  artistShunichi Miyamoto
  albumDNAngel
  titleCaged Bird
  duration339.801
- 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
  songID8116
  duration330.475
  artistMegumi Nakajima (Ranka Lee)
  titleHoukago Overflow
  albumMacross Frontier ~Sayonara no Tsubasa~ netabare album the end of "triangle"
  requestID0
  insertDate2012-05-19 02:45:39
  genreAnime
  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
  7cache
  8session
  9jqueryEngine
  10js
  11paginator
  12html
  13form
  14filter
====

Menu

Upcoming Shows

Affiliates

Recent Requests

Song Histories

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