{{title}}

{{message}}

عضویت
مجمعی ها
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
0.1747718
PHP General Time:
0.1714687
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.0033031
SQL Queries:
8
SQL Memory Usage:
51.45 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
2.64 Mb
Total Memory Usage (Including Debug):
2.7 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:19 am
PHP Version:
5.6.33
PHP Sapi:
cgi-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0001781 | Memory Before: 753.29 kb | Memory After: 754.64 kb | Memory Used: 1.35 kb | Rows: - | Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('8c7a46a11adace1fdb00711c96da463d', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516580361', '/music/album/16/مولودی-نیمه-شعبان/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002079 | Memory Before: 922.23 kb | Memory After: 927.57 kb | Memory Used: 5.34 kb | Rows: 1 | Slave: No
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, t.total_column, s.l_width, s.c_width, s.r_width
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefis_defaultis_default1const1 
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2majmaih1_majma.s.theme_id1 
0.0012591 | Memory Before: 1.25 Mb | Memory After: 1.26 Mb | Memory Used: 12.24 kb | Rows: 1 | Slave: Yes
SELECT lik.like_id AS is_liked, f.friend_id AS is_friend, ma.*, mat.text_parsed AS text, u.user_name, vr.rate_id AS has_rated, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_music_album AS ma
     LEFT JOIN phpfox_like AS lik
            ON(lik.type_id = 'music_album' AND lik.item_id = ma.album_id AND lik.user_id = 0)
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = ma.user_id AND f.friend_user_id = 0)
     JOIN phpfox_music_album_text AS mat
            ON(mat.album_id = ma.album_id)
     JOIN phpfox_user AS u
            ON(u.user_id = ma.user_id)
     LEFT JOIN phpfox_music_album_rating AS vr
            ON(vr.item_id = ma.album_id AND vr.user_id = 0)

WHERE ma.album_id = 16
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmaconstPRIMARY,user_idPRIMARY4const1 
1SIMPLEmatconstalbum_idalbum_id4const1 
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1 
1SIMPLElikreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
1SIMPLEfconstuser_check,user_id,top_friend,friend_user_iduser_check8const,const1Using where
1SIMPLEvrrefitem_id,item_id_2item_id8const,const1 
0.0002449 | Memory Before: 2.36 Mb | Memory After: 2.36 Mb | Memory Used: 3.14 kb | Rows: 0 | Slave: Yes
SELECT action_id
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "music-album" AND item_id = 16 AND user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_actionreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using where
0.0004680 | Memory Before: 2.42 Mb | Memory After: 2.42 Mb | Memory Used: 7.02 kb | Rows: 0 | Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "music-album")

WHERE (l.type_id = 'music_album' OR l.type_id = 'music-album') AND l.item_id = 16
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 36
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrangetype_id,type_id_2,type_id_3,item_idtype_id81 2Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0002332 | Memory Before: 2.43 Mb | Memory After: 2.43 Mb | Memory Used: 5.62 kb | Rows: 0 | Slave: No
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'music_album' AND l.item_id = 16
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.l.user_id1 
0.0002470 | Memory Before: 2.44 Mb | Memory After: 2.44 Mb | Memory Used: 5.46 kb | Rows: 0 | Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "music-album" AND a.item_id = 16
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using index condition; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.a.user_id1 
0.0004649 | Memory Before: 2.51 Mb | Memory After: 2.52 Mb | Memory Used: 11.28 kb | Rows: 7 | Slave: Yes
SELECT ms.song_id, ms.user_id, ms.album_id, ms.title, ms.total_play, ms.song_path, ms.is_featured, ms.view_id, ms.server_id, ms.explicit, ms.duration, ms.time_stamp, ma.name AS album_url, u.user_name, mp.play_id AS is_on_profile, mp.user_id AS profile_user_id, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
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 AND ms.album_id = 16 AND ms.user_id = 90
ORDER BY ms.ordering ASC, ms.time_stamp DESC

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmpsystemsong_idMISSING KEY    const row not found
1SIMPLEuconstPRIMARY,user_idPRIMARY4const1Using filesort
1SIMPLEmsrefuser_id,view_id_3,view_id,view_id_2,view_id_4,view_id_5,view_id_6,view_id_7user_id4const8Using where
1SIMPLEmaconstPRIMARYPRIMARY4const1 
Array
(
    [session] => 8c7a46a11adace1fdb00711c96da463d
    [redirect] => /music/album/16/مولودی-نیمه-شعبان/
)