Recent Songs

SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = 'ece03a6fd1e2522387cbd228d3bbd6ad' AND s.id_hash = 'd0b63444099757fedc3d79aa837e804c'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref	session_hash,log_session	session_hash	32	const	1	Using where

INSERT INTO phpfox_log_view (user_id, ip_address, protocal, cache_data, time_stamp) VALUES ('0', '38.107.191.84', 'GET', 'a:4:{s:8:\"location\";s:7:\"/music/\";s:8:\"referrer\";N;s:10:\"user_agent\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:7:\"request\";s:29:\"a:1:{s:2:\"do\";s:7:\"/music/\";}\";}', '1283793807')

UPDATE phpfox_log_session SET last_activity = '1283793807', user_id = '0', location = '/music/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.191.84', user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)' WHERE session_hash = 'ece03a6fd1e2522387cbd228d3bbd6ad'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_log_session	ref	session_hash,log_session	session_hash	32	const	1	Using where

SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id
FROM phpfox_theme_style AS s
     JOIN phpfox_theme AS t
            ON(t.theme_id = s.theme_id)

WHERE s.is_default = 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref	is_default	is_default	1	const	1
1	SIMPLE	t	eq_ref	PRIMARY,theme_id	PRIMARY	2	deathdlr_fox.s.theme_id	1

SELECT folder AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_style	ref	style_id	style_id	2	const	1

SELECT folder AS parent_theme_folder
FROM phpfox_theme
WHERE theme_id = 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme	const	PRIMARY,theme_id	PRIMARY	2	const	1

SELECT COUNT(*)
FROM phpfox_music_song AS m
WHERE m.view_id = 0
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ref	view_id,view_id_2,view_id_4,view_id_5,view_id_6	view_id_4	1	const	5	Using index

SELECT m.*, ma.name AS album_name, ma.name_url AS album_url, mp.play_id AS is_on_profile, mp.user_id AS profile_user_id, vr.rate_id AS has_rated, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_music_song AS m
     JOIN phpfox_user AS u
            ON(u.user_id = m.user_id)
     LEFT JOIN phpfox_music_album AS ma
            ON(ma.album_id = m.album_id)
     LEFT JOIN phpfox_music_profile AS mp
            ON(mp.song_id = m.song_id AND mp.user_id = 0)
     LEFT JOIN phpfox_music_song_rating AS vr
            ON(vr.item_id = m.song_id AND vr.user_id = 0)

WHERE m.view_id = 0
ORDER BY m.is_featured DESC , m.time_stamp DESC
LIMIT 12
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ma	system	PRIMARY	MISSING KEY				const row not found
1	SIMPLE	m	ref	view_id,view_id_2,view_id_4,view_id_3,view_id_5,view_id_6,user_id	view_id	1	const	5	Using temporary; Using filesort
1	SIMPLE	mp	ALL	song_id	MISSING KEY			1
1	SIMPLE	vr	ALL	item_id,item_id_2	MISSING KEY			1
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	deathdlr_fox.m.user_id	1

SELECT count_view
FROM phpfox_ad
WHERE ad_id = 9
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	4	const	1

UPDATE phpfox_ad SET count_view = '71760' WHERE ad_id = 9

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	4	const	1

SELECT count_view
FROM phpfox_ad
WHERE ad_id = 20
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	4	const	1

UPDATE phpfox_ad SET count_view = '17535' WHERE ad_id = 20

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	4	const	1

SELECT count_view
FROM phpfox_ad
WHERE ad_id = 10
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	4	const	1

UPDATE phpfox_ad SET count_view = '113253' WHERE ad_id = 10

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	4	const	1

SELECT ms.song_id, ms.user_id, ms.album_id, ms.title, ms.title_url, ms.song_path, ms.server_id, ms.explicit, ms.duration, ms.time_stamp, ma.name_url AS album_url, u.user_name, mp.play_id AS is_on_profile, mp.user_id AS profile_user_id, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_music_song AS ms
     JOIN phpfox_user AS u
            ON(u.user_id = ms.user_id)
     LEFT JOIN phpfox_music_album AS ma
            ON(ma.album_id = ms.album_id)
     LEFT JOIN phpfox_music_profile AS mp
            ON(mp.song_id = ms.song_id AND mp.user_id = 0)

WHERE ms.view_id = 0
ORDER BY ms.time_stamp DESC
LIMIT 10
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ma	system	PRIMARY	MISSING KEY				const row not found
1	SIMPLE	ms	ref	view_id,view_id_2,view_id_4,view_id_3,view_id_5,view_id_6,user_id	view_id	1	const	5	Using temporary; Using filesort
1	SIMPLE	mp	ALL	song_id	MISSING KEY			1
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	deathdlr_fox.ms.user_id	1

SELECT count_view
FROM phpfox_ad
WHERE ad_id = 11
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	4	const	1

UPDATE phpfox_ad SET count_view = '113012' WHERE ad_id = 11

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	4	const	1