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 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 next >>

Page 9 of 24910, showing 20 records out of 498194 total, starting on record 161, ending on 180

Artist	Title	Album	Requested	Duration

B'z	Dawn Runner	Sayonara kizu darakeno hibi yo	no	03:05
Kobukuro	Kun heno shudaika	Bakuman OP Single - Blue Bird	no	05:42
Shinsen	Emo Kids		no	00:06
MintJam	-Two Shadows-	Vivid Colors	no	05:20
HALCALI	Ni Fuku Hoshi	Strwaberry Chips	no	03:44
May'n	Chase the world	Accel World OP Single - Chase the world	yes	03:45
Kana Hanazawa (Ruri) & Yuuichi Nakamurai (Kyousuke)	Shokuzai no Serenade	Ore no Imouto ga Konna ni Kawaii Wake ga nai ED14/15 Single - Shokuzai no Serenade	yes	04:18
YUI	again	Fullmetal Alchemist Brotherhood OP1 Single - again	no	04:18
marble	Suisai Candy	Mashiroiro Symphony ED Single - Suisai Candy	no	04:21
FACT	attack me if you dare	Eat Your Words	no	01:21
kanon x kanon	Umigame Soup	Shiki OP2 Single - Calendula Requiem	no	02:20
Shinsen	Girls ;_;		no	00:05
miwa	amayadori	BLEACH OP12 Single - chAngE	no	04:05
Dragon Ash	21st Century Riot	Lily Of Da Valley	no	02:36
Yui Horie	Coloring	Papa no Iu Koto wa Kikinasai! ED Single - Coloring	no	03:49
LAST ALLIANCE	HEKIREKI	Hajime no Ippo Next Challenger OP Single - new dawn	no	04:09
The Pillows	Walkin'on The Spiral	Good Dreams	no	03:25
MELL	Love illusion	MIRAGE	no	05:02
Shinsen	Furu Furu Mooon		no	00:09
Nakagawa Shoko	diamond high	Fullmetal Alchemist Brotherhood ED5 Single - RAY OF LIGHT	no	04:32

<< previous | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 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	01:50
Listeners	25
Requester

Queued

ROUND TABLE feat. Nino ~ Puzzle

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
  time1337407755
  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
  page9
- pass(empty)
- plugin(null)
- url
  exthtml
  urlsong_histories/index/page:9
- form(empty)
- isAjax(false)
- paging
  SongHistory
  page9
  current20
  count498194
  prevPage(true)
  nextPage(true)
  pageCount24910
  defaults
  limit20
  step1
  fields
  0ID
  1songID
  2requestID
  3artist
  4album
  5title
  6duration
  orderSongHistory.date_played DESC
  conditions(empty)
  options
  page9
  limit20
  fields
  0ID
  1songID
  2requestID
  3artist
  4album
  5title
  6duration
  orderSongHistory.date_played DESC
  conditions(empty)
$_GET
- urlsong_histories/index/page:9
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	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)
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	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	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 `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	2309	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`.`date_played` DESC LIMIT 160, 20	20	20	4	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	43	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 21.36 MB

Message	Memory use
Component intitailization	15.45 MB
Controller action start	15.57 MB
Controller render start	16.11 MB
Component intitailization #2	19.45 MB
Controller action start #2	19.46 MB
Component intitailization #3	19.64 MB
Controller action start #3	19.65 MB
View render complete	19.46 MB

Timers

Total Request Time: 3974 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	230.43
Component initialization and startup	2.72
Controller action	2317.26
Render Controller Action	1306.00
» Rendering View	1302.30
» » Rendering APP/views/song_histories/index.ctp	180.86
» » Rendering APP/views/themed/shr-luv/layouts/default.ctp	1120.92
» » » Rendering APP/views/elements/top.ctp	1.58
» » » Rendering APP/views/themed/shr-luv/elements/header.ctp	0.17
» » » Rendering APP/views/elements/column_left.ctp	1044.09
» » » » Rendering APP/views/elements/menu.ctp	2.71
» » » » Rendering APP/views/elements/upcoming_shows.ctp	1039.72
» » » » Rendering APP/views/elements/affiliates.ctp	0.93
» » » Rendering APP/views/elements/requests/content.ctp	6.03
» » » » Rendering APP/views/elements/paypal-saso.ctp	0.27
» » » Rendering APP/views/elements/column_right.ctp	64.60
» » » » Rendering APP/views/elements/playing.ctp	2.50
» » » » Rendering APP/views/elements/queued.ctp	7.22
» » » » » Component initialization and startup #2	1.10
Controller action #2	0.00
» » » » » Rendering APP/views/elements/donations.ctp	0.90
» » » » » Rendering APP/views/elements/most_requested.ctp	53.00
» » » » » » Component initialization and startup #3	0.95
Controller action #3	0.00
» » » » » Rendering APP/views/elements/powered_by.ctp	1.85

====

Log

Logs

====
Variables
View Variables
- queryData(empty)
- query
  page9
- vfMaps(null)
- songs
  0
  SongHistory
  ID498037
  songID8125
  requestID0
  artistB'z
  albumSayonara kizu darakeno hibi yo
  titleDawn Runner
  duration185.265
  1
  SongHistory
  ID498036
  songID7988
  requestID0
  artistKobukuro
  albumBakuman OP Single - Blue Bird
  titleKun heno shudaika
  duration341.551
  2
  SongHistory
  ID498035
  songID4220
  requestID0
  artistShinsen
  album
  titleEmo Kids
  duration6.452
  3
  SongHistory
  ID498034
  songID5761
  requestID0
  artistMintJam
  albumVivid Colors
  title-Two Shadows-
  duration319.64
  4
  SongHistory
  ID498033
  songID1958
  requestID0
  artistHALCALI
  albumStrwaberry Chips
  titleNi Fuku Hoshi
  duration223.961
  5
  SongHistory
  ID498032
  songID9028
  requestID50387
  artistMay'n
  albumAccel World OP Single - Chase the world
  titleChase the world
  duration224.862
  6
  SongHistory
  ID498031
  songID8423
  requestID50386
  artistKana Hanazawa (Ruri) & Yuuichi Nakamurai (Kyousuke)
  albumOre no Imouto ga Konna ni Kawaii Wake ga nai ED14/15 Single - Shokuzai no Serenade
  titleShokuzai no Serenade
  duration258.299
  7
  SongHistory
  ID498030
  songID6002
  requestID0
  artistYUI
  albumFullmetal Alchemist Brotherhood OP1 Single - again
  titleagain
  duration257.541
  8
  SongHistory
  ID498029
  songID8660
  requestID0
  artistmarble
  albumMashiroiro Symphony ED Single - Suisai Candy
  titleSuisai Candy
  duration260.65
  9
  SongHistory
  ID498028
  songID8086
  requestID0
  artistFACT
  albumEat Your Words
  titleattack me if you dare
  duration81.241
  10
  SongHistory
  ID498027
  songID7689
  requestID0
  artistkanon x kanon
  albumShiki OP2 Single - Calendula Requiem
  titleUmigame Soup
  duration140.392
  11
  SongHistory
  ID498026
  songID4216
  requestID0
  artistShinsen
  album
  titleGirls ;_;
  duration4.676
  12
  SongHistory
  ID498025
  songID6844
  requestID0
  artistmiwa
  albumBLEACH OP12 Single - chAngE
  titleamayadori
  duration244.924
  13
  SongHistory
  ID498024
  songID1313
  requestID0
  artistDragon Ash
  albumLily Of Da Valley
  title21st Century Riot
  duration155.742
  14
  SongHistory
  ID498023
  songID8769
  requestID0
  artistYui Horie
  albumPapa no Iu Koto wa Kikinasai! ED Single - Coloring
  titleColoring
  duration228.807
  15
  SongHistory
  ID498022
  songID6566
  requestID0
  artistLAST ALLIANCE
  albumHajime no Ippo Next Challenger OP Single - new dawn
  titleHEKIREKI
  duration249.391
  16
  SongHistory
  ID498021
  songID2378
  requestID0
  artistThe Pillows
  albumGood Dreams
  titleWalkin'on The Spiral
  duration204.989
  17
  SongHistory
  ID498020
  songID7476
  requestID0
  artistMELL
  albumMIRAGE
  titleLove illusion
  duration301.537
  18
  SongHistory
  ID498019
  songID4215
  requestID0
  artistShinsen
  album
  titleFuru Furu Mooon
  duration9.378
  19
  SongHistory
  ID498018
  songID6084
  requestID0
  artistNakagawa Shoko
  albumFullmetal Alchemist Brotherhood ED5 Single - RAY OF LIGHT
  titlediamond high
  duration272.431
- 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_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

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