SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';
1
1
0
SHOW FULL COLUMNS FROM `acos`
8
8
0
SHOW FULL COLUMNS FROM `aros_acos`
7
7
0
SHOW FULL COLUMNS FROM `djs`
18
18
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
Error
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
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
Error
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
0
SHOW FULL COLUMNS FROM `queuelist`
6
6
0
Query Explain:
Click an "Explain" link above, to see the query explanation.
kagura
Query
Error
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 `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
1
maybe slow
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-1-31 00:00:00' AND Request.t_stamp >= '2012-1-1 00:00:00' GROUP BY Song.id, Song.artist, Song.title ORDER BY RequestCount DESC LIMIT 10
10
10
21
maybe slow
Query Explain:
Click an "Explain" link above, to see the query explanation.
© 2006-2012 Shinsen-Radio.org
