{{title}}

{{message}}

عضویت
مجمعی ها
مرور برای:



بین سن:
-
واقع شده بین:
شهر:
کد پستی:
کلمات کلیدی:
از:

درباره من

درباره من:
کسی که دوست دارم ملاقات کنم:
سرگروه شما کیست؟:

علاقه ها

علاقه ها:
موزیک:
فیلم ها:
موبایل:
مرتب سازی نتایج از:
مرد
شهریور 20, 1379
اصفهان » ایران
امیرحسین طغیانی
مرد
اسفند 22, 1377
اصفهان » ایران
امیرحسین قنبری
مرد
اسفند 30, 1375
امیرحسین قندهاری
مرد
فروردین 14, 1371
امیرحسین لطفی
مرد
شهریور 16, 1377
اصفهان » ایران
امیرحسین مسائلی
مرد
آبان 3, 1376
امیرحسین منتظری
مرد
آبان 16, 1377
اصفهان » ایران
امیرحسین مهتاب
مرد
خرداد 21, 1377
امیرحسین میرمجربیان
مرد
خرداد 24, 1375
اصفهان » ایران
امیرحسین پسران
مرد
فروردین 31, 1377
اصفهان » ایران
امیررضا شیرازی
مرد
خرداد 5, 1377
اصفهان » ایران
امیررضا صفایی
مرد
آذر 27, 1378
امیررضاروحی بروجنی
مرد
آذر 28, 1375
اصفهان » ایران
10 از 10
امیرعباس جهانگیری
مرد
مهر 18, 1378
شاهین شهر » ایران
امیرمحمد زرگری
مرد
آبان 28, 1376
ایران
امین امانی فر
مرد
بهمن 21, 1374
ایران
امین ذاکری
مرد
شهریور 25, 1376
اصفهان » ایران
10 از 10
ایمان حبیب اللهی
مرد
مهر 16, 1378
بنیامین ساربانی
مرد
خرداد 21, 1375
بهزاد خليليان
مرد
اسفند 29, 1987
جعفری
مرد
اردیبهشت 16, 1999
اصفهان » ایران
جواد معین الدین
phpFox Developers Debug Toggle JavaScript Console
Version:
3.7.7
Product Code Name:
Nebula

Total Time:
0.8510561
PHP General Time:
0.7630585
GZIP:
enabled

Driver Version:
MySQL 5.6.38
SQL Time:
0.0879976
SQL Queries:
75
SQL Memory Usage:
711.46 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
4.27 Mb
Total Memory Usage (Including Debug):
4.47 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.0005689 | Memory Before: 752.1 kb | Memory After: 753.45 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 ('46f0a427ff20c80e7d3d6f8a660aea33', 'a687a865daaa9d91b7bc673116035fd1', '0', '1516580377', '/user/browse/page_2/', '0', '0', '0', '54.226.41.91', 'CCBot/2.0 (http://commoncrawl.org/faq/)')
0.0002780 | Memory Before: 920.28 kb | Memory After: 925.59 kb | Memory Used: 5.3 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.0004930 | Memory Before: 1.5 Mb | Memory After: 1.5 Mb | Memory Used: 5.39 kb | Rows: 13 | Slave: No
SELECT user_group.*
FROM phpfox_user_group AS user_group
WHERE user_group.user_group_id > 0
ORDER BY user_group.user_group_id ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuser_groupALLPRIMARY,user_group_idMISSING KEY   13Using where; Using filesort
0.0002191 | Memory Before: 1.7 Mb | Memory After: 1.7 Mb | Memory Used: 5.4 kb | Rows: 13 | Slave: No
SELECT user_group.*
FROM phpfox_user_group AS user_group
WHERE user_group.user_group_id > 0
ORDER BY user_group.user_group_id ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuser_groupALLPRIMARY,user_group_idMISSING KEY   13Using where; Using filesort
0.0026450 | Memory Before: 1.93 Mb | Memory After: 1.97 Mb | Memory Used: 39.57 kb | Rows: 490 | Slave: Yes
SELECT m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '4' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   490Using where
1SIMPLEmrefmodule_id,module_is_activemodule_id77majmaih1_majma.user_group_setting.module_id1Using index
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,majmaih1_majma.user_group_setting.setting_id1 
0.0074639 | Memory Before: 2.31 Mb | Memory After: 2.36 Mb | Memory Used: 47.53 kb | Rows: 490 | Slave: Yes
SELECT ugc.default_value, inherit_id, m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     LEFT JOIN phpfox_user_group_custom AS ugc
            ON(ugc.user_group_id = 6 AND ugc.module_id = user_group_setting.module_id AND ugc.name = user_group_setting.name)
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = 6)
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '6' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEugconstPRIMARY,user_group_idPRIMARY1const1 
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   490Using where
1SIMPLEmrefmodule_id,module_is_activemodule_id77majmaih1_majma.user_group_setting.module_id1Using index
1SIMPLEugcrefuser_group_iduser_group_id330const,majmaih1_majma.user_group_setting.module_id,majmaih1_majma.user_group_setting.name1 
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,majmaih1_majma.user_group_setting.setting_id1 
0.0058291 | Memory Before: 2.45 Mb | Memory After: 2.5 Mb | Memory Used: 47.54 kb | Rows: 490 | Slave: Yes
SELECT ugc.default_value, inherit_id, m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     LEFT JOIN phpfox_user_group_custom AS ugc
            ON(ugc.user_group_id = 7 AND ugc.module_id = user_group_setting.module_id AND ugc.name = user_group_setting.name)
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = 7)
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '7' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEugconstPRIMARY,user_group_idPRIMARY1const1 
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   490Using where
1SIMPLEmrefmodule_id,module_is_activemodule_id77majmaih1_majma.user_group_setting.module_id1Using index
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,majmaih1_majma.user_group_setting.setting_id1 
1SIMPLEugcrefuser_group_iduser_group_id330const,majmaih1_majma.user_group_setting.module_id,majmaih1_majma.user_group_setting.name1 
0.0056131 | Memory Before: 2.61 Mb | Memory After: 2.66 Mb | Memory Used: 47.54 kb | Rows: 490 | Slave: Yes
SELECT ugc.default_value, inherit_id, m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     LEFT JOIN phpfox_user_group_custom AS ugc
            ON(ugc.user_group_id = 9 AND ugc.module_id = user_group_setting.module_id AND ugc.name = user_group_setting.name)
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = 9)
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '9' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEugconstPRIMARY,user_group_idPRIMARY1const1 
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   490Using where
1SIMPLEmrefmodule_id,module_is_activemodule_id77majmaih1_majma.user_group_setting.module_id1Using index
1SIMPLEugcrefuser_group_iduser_group_id330const,majmaih1_majma.user_group_setting.module_id,majmaih1_majma.user_group_setting.name1 
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,majmaih1_majma.user_group_setting.setting_id1 
0.0051460 | Memory Before: 2.7 Mb | Memory After: 2.75 Mb | Memory Used: 47.53 kb | Rows: 490 | Slave: Yes
SELECT ugc.default_value, inherit_id, m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     LEFT JOIN phpfox_user_group_custom AS ugc
            ON(ugc.user_group_id = 10 AND ugc.module_id = user_group_setting.module_id AND ugc.name = user_group_setting.name)
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = 10)
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '10' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEugconstPRIMARY,user_group_idPRIMARY1const1 
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   490Using where
1SIMPLEmrefmodule_id,module_is_activemodule_id77majmaih1_majma.user_group_setting.module_id1Using index
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,majmaih1_majma.user_group_setting.setting_id1 
1SIMPLEugcrefuser_group_iduser_group_id330const,majmaih1_majma.user_group_setting.module_id,majmaih1_majma.user_group_setting.name1 
0.0056801 | Memory Before: 2.79 Mb | Memory After: 2.84 Mb | Memory Used: 47.54 kb | Rows: 490 | Slave: Yes
SELECT ugc.default_value, inherit_id, m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     LEFT JOIN phpfox_user_group_custom AS ugc
            ON(ugc.user_group_id = 11 AND ugc.module_id = user_group_setting.module_id AND ugc.name = user_group_setting.name)
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = 11)
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '11' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEugconstPRIMARY,user_group_idPRIMARY1const1 
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   490Using where
1SIMPLEmrefmodule_id,module_is_activemodule_id77majmaih1_majma.user_group_setting.module_id1Using index
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,majmaih1_majma.user_group_setting.setting_id1 
1SIMPLEugcrefuser_group_iduser_group_id330const,majmaih1_majma.user_group_setting.module_id,majmaih1_majma.user_group_setting.name1 
0.0057030 | Memory Before: 2.88 Mb | Memory After: 2.92 Mb | Memory Used: 47.55 kb | Rows: 490 | Slave: Yes
SELECT ugc.default_value, inherit_id, m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     LEFT JOIN phpfox_user_group_custom AS ugc
            ON(ugc.user_group_id = 12 AND ugc.module_id = user_group_setting.module_id AND ugc.name = user_group_setting.name)
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = 12)
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '12' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEugconstPRIMARY,user_group_idPRIMARY1const1 
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   490Using where
1SIMPLEmrefmodule_id,module_is_activemodule_id77majmaih1_majma.user_group_setting.module_id1Using index
1SIMPLEugcrefuser_group_iduser_group_id330const,majmaih1_majma.user_group_setting.module_id,majmaih1_majma.user_group_setting.name1 
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,majmaih1_majma.user_group_setting.setting_id1 
0.0056899 | Memory Before: 2.97 Mb | Memory After: 3.01 Mb | Memory Used: 47.54 kb | Rows: 490 | Slave: Yes
SELECT ugc.default_value, inherit_id, m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     LEFT JOIN phpfox_user_group_custom AS ugc
            ON(ugc.user_group_id = 13 AND ugc.module_id = user_group_setting.module_id AND ugc.name = user_group_setting.name)
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = 13)
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '13' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEugconstPRIMARY,user_group_idPRIMARY1const1 
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   490Using where
1SIMPLEmrefmodule_id,module_is_activemodule_id77majmaih1_majma.user_group_setting.module_id1Using index
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,majmaih1_majma.user_group_setting.setting_id1 
1SIMPLEugcrefuser_group_iduser_group_id330const,majmaih1_majma.user_group_setting.module_id,majmaih1_majma.user_group_setting.name1 
0.0023730 | Memory Before: 3.03 Mb | Memory After: 3.04 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_user AS u
FORCE INDEX (status_id)
     LEFT JOIN phpfox_user_custom AS ucv
            ON(ucv.user_id = u.user_id)
     JOIN phpfox_user_field AS ufield
            ON(ufield.user_id = u.user_id)

WHERE u.status_id = 0 AND u.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefstatus_idstatus_id2const,const219 
1SIMPLEufieldeq_refuser_iduser_id4majmaih1_majma.u.user_id1Using index
1SIMPLEucveq_refuser_iduser_id4majmaih1_majma.u.user_id1Using index
0.0153909 | Memory Before: 3.05 Mb | Memory After: 3.08 Mb | Memory Used: 37.37 kb | Rows: 21 | Slave: Yes
SELECT uf.user_id as is_featured, uf.ordering as featured_order, u.status_id as unverified, u.*, ufield.*
FROM phpfox_user AS u
     LEFT JOIN phpfox_user_custom AS ucv
            ON(ucv.user_id = u.user_id)
     LEFT JOIN phpfox_user_featured AS uf
            ON(uf.user_id = u.user_id)
     JOIN phpfox_user_field AS ufield
            ON(ufield.user_id = u.user_id)

WHERE u.status_id = 0 AND u.view_id = 0
GROUP BY u.user_id
ORDER BY u.full_name ASC
LIMIT 21 OFF SET 21
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefPRIMARY,user_status,status_id,public_feed,status_id_2,user_idpublic_feed2const,const196Using where; Using temporary; Using filesort
1SIMPLEufieldeq_refuser_iduser_id4majmaih1_majma.u.user_id1 
1SIMPLEucveq_refuser_iduser_id4majmaih1_majma.u.user_id1Using index
1SIMPLEufeq_refPRIMARYPRIMARY4majmaih1_majma.u.user_id1 
0.0012059 | Memory Before: 3.11 Mb | Memory After: 3.11 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 424) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const4Using index
0.0003350 | Memory Before: 3.12 Mb | Memory After: 3.12 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 414) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id4Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const43Using index
0.0007241 | Memory Before: 3.13 Mb | Memory After: 3.14 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 88) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const15Using index
0.0007429 | Memory Before: 3.14 Mb | Memory After: 3.15 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 43) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id9Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const91Using index
0.0038550 | Memory Before: 3.15 Mb | Memory After: 3.16 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 129) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const28Using index
0.0007060 | Memory Before: 3.16 Mb | Memory After: 3.17 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 111) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const17Using index
0.0005400 | Memory Before: 3.18 Mb | Memory After: 3.18 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 152) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const17Using index
0.0008171 | Memory Before: 3.19 Mb | Memory After: 3.19 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 176) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const25Using index
0.0006239 | Memory Before: 3.2 Mb | Memory After: 3.2 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 16) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const23Using index
0.0002692 | Memory Before: 3.21 Mb | Memory After: 3.21 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 114) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const27Using index
0.0001690 | Memory Before: 3.22 Mb | Memory After: 3.22 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 153) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id10Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const103Using index
0.0001640 | Memory Before: 3.23 Mb | Memory After: 3.23 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 445) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4const1Using where
0.0037799 | Memory Before: 3.24 Mb | Memory After: 3.24 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 161) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id3Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const33Using index
0.0003729 | Memory Before: 3.25 Mb | Memory After: 3.25 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 452) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id3Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const34Using index
0.0001822 | Memory Before: 3.26 Mb | Memory After: 3.26 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 149) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id5Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const51Using index
0.0005429 | Memory Before: 3.27 Mb | Memory After: 3.28 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 57) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const29Using index
0.0001669 | Memory Before: 3.28 Mb | Memory After: 3.29 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 113) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id5Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const50Using index
0.0001822 | Memory Before: 3.29 Mb | Memory After: 3.3 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 272) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const21Using index
0.0001490 | Memory Before: 3.31 Mb | Memory After: 3.31 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 238) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4const1Using where
0.0001509 | Memory Before: 3.32 Mb | Memory After: 3.32 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 560) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id2Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4const1Using where
0.0001731 | Memory Before: 3.33 Mb | Memory After: 3.33 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_friend AS f
INNER      JOIN ( SELECT friend_user_id FROM phpfox_friend WHERE is_page = 0 AND user_id = 282) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARYfrefuser_check,user_id,top_friend,friend_user_iduser_check4const1Using index
1PRIMARY<derived2>ref<auto_key0><auto_key0>4majmaih1_majma.f.friend_user_id4Using index
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2is_page_25const,const43Using index
0.0003312 | Memory Before: 3.17 Mb | Memory After: 3.18 Mb | Memory Used: 4.92 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 424 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0001130 | Memory Before: 3.19 Mb | Memory After: 3.19 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 414 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000951 | Memory Before: 3.2 Mb | Memory After: 3.2 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 88 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000851 | Memory Before: 3.21 Mb | Memory After: 3.21 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 43 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000811 | Memory Before: 3.22 Mb | Memory After: 3.22 Mb | Memory Used: 4.95 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 129 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000789 | Memory Before: 3.23 Mb | Memory After: 3.23 Mb | Memory Used: 5.05 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 111 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000761 | Memory Before: 3.24 Mb | Memory After: 3.25 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 152 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000761 | Memory Before: 3.25 Mb | Memory After: 3.26 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 176 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000842 | Memory Before: 3.26 Mb | Memory After: 3.27 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 16 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000799 | Memory Before: 3.27 Mb | Memory After: 3.28 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 114 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000739 | Memory Before: 3.28 Mb | Memory After: 3.29 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 153 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000749 | Memory Before: 3.3 Mb | Memory After: 3.3 Mb | Memory Used: 4.89 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 445 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000739 | Memory Before: 3.31 Mb | Memory After: 3.31 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 161 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000751 | Memory Before: 3.32 Mb | Memory After: 3.32 Mb | Memory Used: 4.89 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 452 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000741 | Memory Before: 3.33 Mb | Memory After: 3.33 Mb | Memory Used: 4.89 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 149 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000970 | Memory Before: 3.34 Mb | Memory After: 3.35 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 57 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000811 | Memory Before: 3.35 Mb | Memory After: 3.36 Mb | Memory Used: 4.89 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 113 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000789 | Memory Before: 3.36 Mb | Memory After: 3.37 Mb | Memory Used: 4.89 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 272 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000970 | Memory Before: 3.37 Mb | Memory After: 3.38 Mb | Memory Used: 4.89 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 238 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000761 | Memory Before: 3.38 Mb | Memory After: 3.39 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 560 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0000749 | Memory Before: 3.4 Mb | Memory After: 3.4 Mb | Memory Used: 4.89 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 282 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   30Using where
0.0002711 | Memory Before: 3.23 Mb | Memory After: 3.23 Mb | Memory Used: 3.48 kb | Rows: 3 | Slave: No
SELECT group_id, phrase_var_name
FROM phpfox_custom_group
WHERE type_id = 'user_profile' AND is_active = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_custom_groupALL MISSING KEY   3Using where
0.0002241 | Memory Before: 3.25 Mb | Memory After: 3.25 Mb | Memory Used: 4.05 kb | Rows: 3 | Slave: Yes
SELECT field_id, field_name, phrase_var_name, var_type
FROM phpfox_custom_field
WHERE group_id = 1 AND is_active = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_custom_fieldALL MISSING KEY   8Using where
0.0003319 | Memory Before: 3.25 Mb | Memory After: 3.26 Mb | Memory Used: 4.52 kb | Rows: 39 | Slave: No
SELECT option_id, phrase_var_name
FROM phpfox_custom_option
WHERE field_id = 9
ORDER BY option_id ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_custom_optionALLfield_idMISSING KEY   39Using where; Using filesort
0.0000951 | Memory Before: 3.28 Mb | Memory After: 3.28 Mb | Memory Used: 4.13 kb | Rows: 4 | Slave: Yes
SELECT field_id, field_name, phrase_var_name, var_type
FROM phpfox_custom_field
WHERE group_id = 2 AND is_active = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_custom_fieldALL MISSING KEY   8Using where
0.0000808 | Memory Before: 3.29 Mb | Memory After: 3.29 Mb | Memory Used: 3.94 kb | Rows: 0 | Slave: Yes
SELECT field_id, field_name, phrase_var_name, var_type
FROM phpfox_custom_field
WHERE group_id = 3 AND is_active = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_custom_fieldALL MISSING KEY   8Using where
0.0020609 | Memory Before: 3.34 Mb | Memory After: 3.34 Mb | Memory Used: 4.98 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 = 'user.browse' 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.0002089 | Memory Before: 3.34 Mb | Memory After: 3.35 Mb | Memory Used: 4.99 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 = 'user' 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.0005300 | Memory Before: 3.34 Mb | Memory After: 3.35 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.0003760 | Memory Before: 3.87 Mb | Memory After: 3.87 Mb | Memory Used: 3.32 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'block' AND module_id = 'user' AND name = 'filter.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0009582 | Memory Before: 3.94 Mb | Memory After: 3.98 Mb | Memory Used: 34.14 kb | Rows: 0 | Slave: Yes
SELECT p.photo_id as cover_photo_exists, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id AS is_online, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user AS u
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = u.user_group_id)
     JOIN phpfox_user_space AS user_space
            ON(user_space.user_id = u.user_id)
     JOIN phpfox_user_field AS user_field
            ON(user_field.user_id = u.user_id)
     JOIN phpfox_user_activity AS user_activity
            ON(user_activity.user_id = u.user_id)
     LEFT JOIN phpfox_theme_style AS ts
            ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
     LEFT JOIN phpfox_theme AS t
            ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_user_featured AS uf
            ON(uf.user_id = u.user_id)
     LEFT JOIN phpfox_log_session AS ls
            ON(ls.user_id = u.user_id AND ls.im_hide = 0)
     LEFT JOIN phpfox_photo AS p
            ON(p.photo_id = user_field.cover_photo)

WHERE u.user_id = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0002759 | Memory Before: 3.95 Mb | Memory After: 3.95 Mb | Memory Used: 3.39 kb | Rows: 0 | Slave: No
SELECT child_id, name
FROM phpfox_country_child
WHERE country_iso = ''
ORDER BY ordering ASC, name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_country_childrefcountry_isocountry_iso2const1Using index condition; Using where; Using filesort
0.0002220 | Memory Before: 3.95 Mb | Memory After: 3.95 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 = 'core' AND name = 'country-child.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002038 | Memory Before: 3.95 Mb | Memory After: 3.95 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 = 'custom' AND name = 'foreachcustom.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0003099 | Memory Before: 4 Mb | Memory After: 4.01 Mb | Memory Used: 8.02 kb | Rows: 23 | 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, uf.ordering
FROM phpfox_user AS u
     JOIN phpfox_user_featured AS uf
            ON(uf.user_id = u.user_id)

ORDER BY ordering DESC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEufALLPRIMARYMISSING KEY   23Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4majmaih1_majma.uf.user_id1 
0.0001550 | Memory Before: 4.04 Mb | Memory After: 4.05 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.0001271 | Memory Before: 4.05 Mb | Memory After: 4.06 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 = 'user' 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.0001321 | Memory Before: 4.06 Mb | Memory After: 4.06 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 = 'user' 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.0001900 | Memory Before: 4.21 Mb | Memory After: 4.22 Mb | Memory Used: 9.46 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "user|featured"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003221 | Memory Before: 4.16 Mb | Memory After: 4.16 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'default' AND type_id = 'controller' AND module_id = 'user' AND name = 'browse.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
Array
(
    [session] => 46f0a427ff20c80e7d3d6f8a660aea33
    [redirect] => /user/browse/page_2/
)