J-Music and Anime Radio :: Shinsen-Radio

Upcoming Shows

DJWicked

3 days, 19 hours

Affiliates

Recent Requests

Kana Hanazawa (Tomoka) & Rina Hidaka (Airi) & Youko Hikasa (Saki) & Yuka Iguchi (Maho) & Yui Ogura (Hinata) ~ Party Love ~Okkiku Naritai~	Goodwine	o_o
Momoiro Clover Z ~ Mouretsu Uchuu Koukyou Kyoku Dai Nana Gakushou "Mugen no Ai"	Goodwine	fake guitar playing is fake :/
KOTOKO ~ Light My Fire	aho	WOOHOHOHO! \:D/

Songs

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

Page 6 of 10, showing 20 records out of 200 total, starting on record 101, ending on 120

artist	title	genre	duration

I've & Kotoko	Sensitive (Remix)	Anime	04:34
I've & Kotoko	Close To Me	Anime	05:31
I've & Kotoko	Undying Love	Anime	05:26
I've & Kotoko	HALLUCINO	Anime	05:41
I've & Kotoko	Otona Ni Naru Tame No Kuuhoku	Anime	03:14
I've & Kotoko	YA KU SO KU	Anime	05:17
I've & Kotoko	Save Your Heart	Anime	05:22
I've & Kotoko	Satirize	Anime	04:51
I've & Kotoko	Natsukusa no Senro	Anime	05:60
I've & Kotoko	DROWNING	Anime	06:22
I've & Kotoko	Namida no Chikai	Anime	06:56
I've & Kotoko	FLY TO THE TOP	Anime	05:16
I've & Kotoko	Ouji yo -Tsuki no Ura kara-	Anime	05:41
I've & Kotoko	Kimi yo, Utsukushii Kaze ni nare	Anime	06:22
I've & Kotoko	I can't get over your best smile	Anime	06:15
I've & Kotoko	resolution of soul	Anime	05:38
I've & Kotoko	flow -Mizu no Umareta Basho-	Anime	05:48
I've & Kotoko	Disintegration	Anime	05:09
I've & Kotoko	Birthday eve	Anime	03:57
I've & Kotoko	Belvedia	Anime	04:11

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

Playing

Dj	Kagura-Moto
Artist	Buono!
Title	Kokoro No Tamago
Album	Honto No Jibun
Genre	Anime
Remaining	02:15
Listeners	29
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
  time1337650443
  timeout10
====
Request
Request

Cake Params
- controllersongs
- actionindex
- named
  page6
  Song.artistKOTOKO
- pass(empty)
- plugin(null)
- url
  exthtml
  urlsongs/index/page:6/Song.artist:KOTOKO
- form(empty)
- isAjax(false)
- paging
  Song
  page6
  current20
  count200
  prevPage(true)
  nextPage(true)
  pageCount10
  defaults
  limit20
  step1
  conditions
  Song.artist LIKE%KOTOKO%
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
  options
  page6
  limit20
  conditions
  Song.artist LIKE%KOTOKO%
  fields
  0ID
  1artist
  2title
  3album
  4genre
  5duration
$_GET
- urlsongs/index/page:6/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	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	13	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 '%KOTOKO%'	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 '%KOTOKO%' ORDER BY `date_added` DESC, `ID` DESC LIMIT 100, 20	20	20	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	40	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 20.71 MB

Message	Memory use
Component intitailization	15.06 MB
Controller action start	15.19 MB
Controller render start	15.73 MB
Component intitailization #2	19.00 MB
Controller action start #2	19.01 MB
Component intitailization #3	19.09 MB
Controller action start #3	19.10 MB
View render complete	18.90 MB

Timers

Total Request Time: 546 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	219.52
Component initialization and startup	2.85
Controller action	24.96
Render Controller Action	189.22
» Rendering View	186.85
» » Rendering APP/views/songs/index.ctp	112.38
» » Rendering APP/views/themed/shr-luv/layouts/default.ctp	73.98
» » » Rendering APP/views/elements/top.ctp	1.48
» » » Rendering APP/views/themed/shr-luv/elements/header.ctp	0.16
» » » Rendering APP/views/elements/column_left.ctp	4.60
» » » » Rendering APP/views/elements/menu.ctp	2.72
» » » » Rendering APP/views/elements/upcoming_shows.ctp	0.52
» » » » Rendering APP/views/elements/affiliates.ctp	0.74
» » » Rendering APP/views/elements/requests/content.ctp	5.23
» » » » Rendering APP/views/elements/paypal-saso.ctp	0.20
» » » Rendering APP/views/elements/column_right.ctp	58.40
» » » » Rendering APP/views/elements/playing.ctp	2.17
» » » » Rendering APP/views/elements/queued.ctp	5.50
» » » » » Component initialization and startup #2	0.91
Controller action #2	0.00
» » » » » Rendering APP/views/elements/donations.ctp	0.55
» » » » » Rendering APP/views/elements/most_requested.ctp	49.31
» » » » » » Component initialization and startup #3	0.94
Controller action #3	0.00
» » » » » Rendering APP/views/elements/powered_by.ctp	1.86

====

Log

Logs

====
Variables
View Variables
- queryData
  Song.artistKOTOKO
- query
  Song
  conditions
  Song.artist LIKE%KOTOKO%
  page6
- vfMaps
  Song.-allall
- songs
  0
  Song
  ID475
  artistI've & Kotoko
  titleSensitive (Remix)
  album
  genreAnime
  duration274.05
  id475
  1
  Song
  ID474
  artistI've & Kotoko
  titleClose To Me
  album
  genreAnime
  duration330.84
  id474
  2
  Song
  ID473
  artistI've & Kotoko
  titleUndying Love
  album
  genreAnime
  duration325.59
  id473
  3
  Song
  ID472
  artistI've & Kotoko
  titleHALLUCINO
  album
  genreAnime
  duration340.767
  id472
  4
  Song
  ID471
  artistI've & Kotoko
  titleOtona Ni Naru Tame No Kuuhoku
  album
  genreAnime
  duration194.115
  id471
  5
  Song
  ID470
  artistI've & Kotoko
  titleYA KU SO KU
  album
  genreAnime
  duration317.074
  id470
  6
  Song
  ID469
  artistI've & Kotoko
  titleSave Your Heart
  album
  genreAnime
  duration322.063
  id469
  7
  Song
  ID468
  artistI've & Kotoko
  titleSatirize
  album
  genreAnime
  duration290.951
  id468
  8
  Song
  ID467
  artistI've & Kotoko
  titleNatsukusa no Senro
  album
  genreAnime
  duration359.706
  id467
  9
  Song
  ID465
  artistI've & Kotoko
  titleDROWNING
  album
  genreAnime
  duration381.711
  id465
  10
  Song
  ID464
  artistI've & Kotoko
  titleNamida no Chikai
  album
  genreAnime
  duration415.698
  id464
  11
  Song
  ID463
  artistI've & Kotoko
  titleFLY TO THE TOP
  album
  genreAnime
  duration316.196
  id463
  12
  Song
  ID462
  artistI've & Kotoko
  titleOuji yo -Tsuki no Ura kara-
  album
  genreAnime
  duration341.352
  id462
  13
  Song
  ID461
  artistI've & Kotoko
  titleKimi yo, Utsukushii Kaze ni nare
  album
  genreAnime
  duration382.051
  id461
  14
  Song
  ID460
  artistI've & Kotoko
  titleI can't get over your best smile
  album
  genreAnime
  duration375.39
  id460
  15
  Song
  ID459
  artistI've & Kotoko
  titleresolution of soul
  album
  genreAnime
  duration338.009
  id459
  16
  Song
  ID458
  artistI've & Kotoko
  titleflow -Mizu no Umareta Basho-
  album
  genreAnime
  duration347.883
  id458
  17
  Song
  ID457
  artistI've & Kotoko
  titleDisintegration
  album
  genreAnime
  duration309.248
  id457
  18
  Song
  ID456
  artistI've & Kotoko
  titleBirthday eve
  album
  genreAnime
  duration236.732
  id456
  19
  Song
  ID455
  artistI've & Kotoko
  titleBelvedia
  album
  genreAnime
  duration251.256
  id455
- 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
  songID2857
  duration241.607
  artistBuono!
  titleKokoro no Tamago
  albumHonto no Jibun
  requestID0
  insertDate2012-05-21 22:12:17
  genreAnime
  Request
  ID(null)
  songID(null)
  name(null)
  msg(null)
  total_listeners29
- 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

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