{{title}}

{{message}}

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

Total Time:
0.3115489
PHP General Time:
0.2980741
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.0134748
SQL Queries:
22
SQL Memory Usage:
112.45 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
2.65 Mb
Total Memory Usage (Including Debug):
2.72 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
185.55.227.64


Server Time Stamp:
January 22, 2018, 12:13 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.0025630 | Memory Before: 752.85 kb | Memory After: 754.2 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 ('a2fc74c25bd01562902730f84acd4085', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516580028', '/video/category/17/سرگرمی/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0001931 | Memory Before: 920.4 kb | Memory After: 925.69 kb | Memory Used: 5.29 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.0001609 | Memory Before: 1.35 Mb | Memory After: 1.35 Mb | Memory Used: 4.8 kb | Rows: 0 | Slave: Yes
SELECT i.*, io.phrase_var as option_phrase_var
FROM phpfox_input_field AS i
     LEFT JOIN phpfox_input_option AS io
            ON(io.field_id = i.field_id)

WHERE module_id = "video"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0006289 | Memory Before: 1.51 Mb | Memory After: 1.51 Mb | Memory Used: 4.71 kb | Rows: 0 | Slave: Yes
SELECT *, COUNT(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'video' AND tag_url = ''
GROUP BY tag_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_tagrefPRIMARY,category_id,tag_url,user_search,user_search_general,category_id_2tag_url257const1Using index condition; Using where; Using temporary; Using filesort
0.0007591 | Memory Before: 1.53 Mb | Memory After: 1.53 Mb | Memory Used: 3.14 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_video AS m
INNER      JOIN phpfox_video_category_data AS mcd
            ON(mcd.video_id = m.video_id)

WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND mcd.category_id = 17
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcdrefcategory_id,video_idcategory_id4const1 
1SIMPLEmeq_refPRIMARY,in_process,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6PRIMARY4majmaih1_majma.mcd.video_id1Using where
0.0007710 | Memory Before: 1.56 Mb | Memory After: 1.57 Mb | Memory Used: 13.94 kb | Rows: 3 | Slave: Yes
SELECT v.*, 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_video AS v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)

WHERE v.is_featured = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEvALLuser_idMISSING KEY   25Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.v.user_id1 
0.0002210 | Memory Before: 1.61 Mb | Memory After: 1.62 Mb | Memory Used: 3.19 kb | Rows: 1 | Slave: No
SELECT category_id
FROM phpfox_video_category
WHERE category_id = '17'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_video_categoryconstPRIMARYPRIMARY3const1Using index
0.0001960 | Memory Before: 1.61 Mb | Memory After: 1.62 Mb | Memory Used: 3.4 kb | Rows: 1 | Slave: No
SELECT pc.category_id, pc.parent_id
FROM phpfox_video_category AS pc
WHERE pc.category_id = 17
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpcconstPRIMARYPRIMARY3const1 
0.0000660 | Memory Before: 1.61 Mb | Memory After: 1.61 Mb | Memory Used: 3.38 kb | Rows: 0 | Slave: No
SELECT pc.category_id, pc.parent_id
FROM phpfox_video_category AS pc
WHERE pc.category_id = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0000820 | Memory Before: 1.61 Mb | Memory After: 1.62 Mb | Memory Used: 4.75 kb | Rows: 1 | Slave: No
SELECT *
FROM phpfox_video_category
WHERE category_id IN(17)
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_video_categoryconstPRIMARYPRIMARY3const1 
0.0009849 | Memory Before: 1.69 Mb | Memory After: 1.69 Mb | Memory Used: 5.05 kb | Rows: 1 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'video.index' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefPRIMARY,product_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28majmaih1_majma.m.product_id,const1Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_id77majmaih1_majma.m.module_id1Using where
0.0002291 | Memory Before: 1.69 Mb | Memory After: 1.7 Mb | Memory Used: 4.96 kb | Rows: 0 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'video' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefPRIMARY,product_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28majmaih1_majma.m.product_id,const1Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_id77majmaih1_majma.m.module_id1Using where
0.0004308 | Memory Before: 1.69 Mb | Memory After: 1.7 Mb | Memory Used: 5.22 kb | Rows: 7 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrangeproduct_id,parent_idparent_id3 8Using index condition; Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28majmaih1_majma.m.product_id,const1Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_id77majmaih1_majma.m.module_id1Using where
0.0001640 | Memory Before: 2.36 Mb | Memory After: 2.37 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT mc.category_id, mc.name
FROM phpfox_video_category AS mc
WHERE mc.parent_id = 17 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmcrefparent_id,is_activeparent_id4const,const1Using where; Using filesort
0.0027680 | Memory Before: 2.46 Mb | Memory After: 2.46 Mb | Memory Used: 3.3 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'controller' AND module_id = 'video' AND name = 'index.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002780 | Memory Before: 2.48 Mb | Memory After: 2.5 Mb | Memory Used: 16.75 kb | Rows: 0 | Slave: No
SELECT s.*, v.*, ve.embed_code, 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_video AS v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)
     JOIN phpfox_ad_sponsor AS s
            ON(s.item_id = v.video_id)
     LEFT JOIN phpfox_video_embed AS ve
            ON(ve.video_id = v.video_id)

WHERE v.in_process = 0 AND v.view_id = 0 AND v.is_sponsor = 1 AND s.module_id = "video"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001321 | Memory Before: 2.51 Mb | Memory After: 2.51 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0002379 | Memory Before: 2.52 Mb | Memory After: 2.52 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'video' AND name = 'featured.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001330 | Memory Before: 2.52 Mb | Memory After: 2.52 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'video' AND name = 'featured.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001340 | Memory Before: 2.58 Mb | Memory After: 2.59 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001230 | Memory Before: 2.62 Mb | Memory After: 2.63 Mb | Memory Used: 9.45 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "video|featured"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0022190 | Memory Before: 2.58 Mb | Memory After: 2.59 Mb | Memory Used: 3.79 kb | Rows: 0 | Slave: Yes
SELECT category_id, tag_text AS tag, tag_url, COUNT(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'video' AND added > 1514852028
GROUP BY tag_text, tag_url
HAVING total > 1
ORDER BY total DESC
LIMIT 10
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_tagrefcategory_id,user_search,user_search_general,category_id_2category_id77const6Using index condition; Using where; Using temporary; Using filesort
Array
(
    [session] => a2fc74c25bd01562902730f84acd4085
    [redirect] => /video/category/17/سرگرمی/
)