Abe Loggins
Male
August 17, 1985
Fiernaz » Italy
Adam Croteau
Male
May 22, 1981
Romagnano Al Monte » Italy
Adan Nicolai
Male
March 13, 1980
Bari » Italy
Addie Humphreys
Male
March 2, 1981
San Pietro Del Gallo » Italy
Adelaida Medworth
Male
September 3, 1986
Eraclea Mare » Italy
Adeline Mazure
Male
October 17, 1982
Avetrana » Italy
Adolfo Child
Male
December 9, 1987
Villa Di Briano » Italy
Adolph Mayne
Male
September 27, 1989
Oggiona Con Santo Stefano » Italy
Adolph Schafer
Male
August 20, 1984
La Murgetta » Italy
Adriana Lyles
Male
March 21, 1983
Poggio Di Bretta » Italy
Adriene Echols
Male
January 8, 1982
Filogaso » Italy
Agnes Gribble
Male
January 18, 1982
Castelmezzano » Italy
Agustin Koertig
Male
March 26, 1981
Landiona » Italy
Agustin Perrett
Male
June 17, 1990
Turano » Italy
Ahmad Rice
Male
March 25, 1986
Morolo » Italy
Aidan Cornish
Male
October 3, 1982
Cossombrato » Italy
Aidan Gerald
Male
March 28, 1984
Marina Di Minturno » Italy
Aiden Quintana
Male
April 11, 1985
Buccheri » Italy
Aileen Kingsford
Male
June 28, 1985
Dosson » Italy
Aisha Sherwood
Male
July 4, 1989
Tolle » Italy
Alba Craney
Male
February 20, 1980
Dogato » Italy
Browse For:



Between Ages:
-
Located Within:
City:
ZIP/Postal Code:
Keywords:
within:

About Me


Interests


Details

Sort Results By:
phpFox Developers Debug Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula

Total Time:
0.4136701
PHP General Time:
0.0661573
GZIP:
enabled

Driver Version:
MySQL 5.5.62-0ubuntu0.14.04.1
SQL Time:
0.3475128
SQL Queries:
53
SQL Memory Usage:
79.79 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
3.07 Mb
Total Memory Usage (Including Debug):
3.21 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
198.13.61.26


Server Time Stamp:
March 29, 2020, 2:27 pm
PHP Version:
5.5.9-1ubuntu4.29
PHP Sapi:
apache2handler
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0000961 | Memory Before: 442.43 kb | Memory After: 443.94 kb | Memory Used: 1.51 kb | Rows: 1 | Slave: No
SELECT value_actual
FROM phpfox_setting
WHERE var_name = 'phpfox_version'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_settingrefvar_namevar_name102const1Using where
0.0012870 | Memory Before: 738.89 kb | Memory After: 740.24 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 ('74a5d7a90d0a28a95f8b679d09be4f23', 'c56fb43d525078d2aaf85f739d93f298', '0', '1585492028', '/user/browse/location_IT/', '0', '0', '0', '35.175.121.230', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0000749 | Memory Before: 873.39 kb | Memory After: 874.9 kb | Memory Used: 1.51 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_idPRIMARY2phpfoxfb.s.theme_id1 
0.0000510 | Memory Before: 876.73 kb | Memory After: 878.23 kb | Memory Used: 1.51 kb | Rows: 1 | Slave: No
SELECT folder AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_styleconststyle_id_2,style_idstyle_id_22const1 
0.0000839 | Memory Before: 1.36 Mb | Memory After: 1.37 Mb | Memory Used: 1.51 kb | Rows: 5 | 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_grouprangePRIMARY,user_group_idPRIMARY1 5Using where
0.0000689 | Memory Before: 1.56 Mb | Memory After: 1.57 Mb | Memory Used: 1.51 kb | Rows: 5 | 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_grouprangePRIMARY,user_group_idPRIMARY1 5Using where
0.2301900 | Memory Before: 1.86 Mb | Memory After: 1.86 Mb | Memory Used: 1.51 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.country_iso = 'IT' AND u.status_id = 0 AND u.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefstatus_idstatus_id2const,const17767Using where
1SIMPLEucveq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
1SIMPLEufieldeq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
0.1054168 | Memory Before: 1.87 Mb | Memory After: 1.87 Mb | Memory Used: 1.51 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.country_iso = 'IT' AND u.status_id = 0 AND u.view_id = 0
GROUP BY u.user_id
ORDER BY u.full_name ASC
LIMIT 21
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefPRIMARY,user_status,status_id,public_feed,status_id_2,user_idstatus_id_22const,const17767Using where; Using temporary
1SIMPLEucveq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
1SIMPLEufeq_refPRIMARYPRIMARY4phpfoxfb.u.user_id1 
1SIMPLEufieldeq_refuser_iduser_id4phpfoxfb.u.user_id1 
0.0004220 | Memory Before: 2.18 Mb | Memory After: 2.18 Mb | Memory Used: 1.51 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 = 5088) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0003240 | Memory Before: 2.19 Mb | Memory After: 2.2 Mb | Memory Used: 1.51 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 = 31728) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002279 | Memory Before: 2.21 Mb | Memory After: 2.21 Mb | Memory Used: 1.51 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 = 24352) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002391 | Memory Before: 2.22 Mb | Memory After: 2.22 Mb | Memory Used: 1.51 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 = 13308) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002410 | Memory Before: 2.23 Mb | Memory After: 2.23 Mb | Memory Used: 1.51 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 = 3892) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002608 | Memory Before: 2.24 Mb | Memory After: 2.24 Mb | Memory Used: 1.51 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 = 18126) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002100 | Memory Before: 2.25 Mb | Memory After: 2.25 Mb | Memory Used: 1.51 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 = 16678) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002620 | Memory Before: 2.26 Mb | Memory After: 2.26 Mb | Memory Used: 1.51 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 = 31883) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002232 | Memory Before: 2.27 Mb | Memory After: 2.27 Mb | Memory Used: 1.51 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 = 2977) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002501 | Memory Before: 2.28 Mb | Memory After: 2.28 Mb | Memory Used: 1.51 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 = 27255) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002351 | Memory Before: 2.29 Mb | Memory After: 2.29 Mb | Memory Used: 1.51 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 = 17276) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002401 | Memory Before: 2.3 Mb | Memory After: 2.3 Mb | Memory Used: 1.51 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 = 17614) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0005651 | Memory Before: 2.31 Mb | Memory After: 2.31 Mb | Memory Used: 1.51 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 = 10183) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002229 | Memory Before: 2.32 Mb | Memory After: 2.33 Mb | Memory Used: 1.51 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 = 17350) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002310 | Memory Before: 2.33 Mb | Memory After: 2.34 Mb | Memory Used: 1.51 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 = 19557) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002470 | Memory Before: 2.35 Mb | Memory After: 2.35 Mb | Memory Used: 1.51 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 = 15985) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002041 | Memory Before: 2.36 Mb | Memory After: 2.36 Mb | Memory Used: 1.51 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 = 11621) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002398 | Memory Before: 2.37 Mb | Memory After: 2.37 Mb | Memory Used: 1.51 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
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002191 | Memory Before: 2.38 Mb | Memory After: 2.38 Mb | Memory Used: 1.51 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 = 36635) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002511 | Memory Before: 2.39 Mb | Memory After: 2.39 Mb | Memory Used: 1.51 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 = 6163) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002780 | Memory Before: 2.4 Mb | Memory After: 2.4 Mb | Memory Used: 1.51 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 = 1860) AS sf
            ON(sf.friend_user_id = f.friend_user_id)

WHERE f.user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1PRIMARY   MISSING KEY    Impossible WHERE noticed after reading const tables
2DERIVEDphpfox_friendrefuser_check,user_id,top_friend,is_page,is_page_2user_check4 1Using where
0.0002091 | Memory Before: 2.26 Mb | Memory After: 2.26 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 5088 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0002170 | Memory Before: 2.27 Mb | Memory After: 2.27 Mb | Memory Used: 1.52 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 31728 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001919 | Memory Before: 2.28 Mb | Memory After: 2.28 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 24352 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001521 | Memory Before: 2.29 Mb | Memory After: 2.29 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 13308 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001578 | Memory Before: 2.3 Mb | Memory After: 2.3 Mb | Memory Used: 1.53 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 3892 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001352 | Memory Before: 2.31 Mb | Memory After: 2.32 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 18126 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001440 | Memory Before: 2.33 Mb | Memory After: 2.33 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 16678 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001221 | Memory Before: 2.34 Mb | Memory After: 2.34 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 31883 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001450 | Memory Before: 2.35 Mb | Memory After: 2.35 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 2977 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001640 | Memory Before: 2.36 Mb | Memory After: 2.36 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 27255 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0002069 | Memory Before: 2.37 Mb | Memory After: 2.37 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 17276 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001769 | Memory Before: 2.38 Mb | Memory After: 2.38 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 17614 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001931 | Memory Before: 2.39 Mb | Memory After: 2.39 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 10183 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0002348 | Memory Before: 2.4 Mb | Memory After: 2.4 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 17350 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001431 | Memory Before: 2.41 Mb | Memory After: 2.41 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 19557 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001349 | Memory Before: 2.42 Mb | Memory After: 2.43 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 15985 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001271 | Memory Before: 2.44 Mb | Memory After: 2.44 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 11621 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001779 | Memory Before: 2.45 Mb | Memory After: 2.45 Mb | Memory Used: 1.51 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   1Using where
0.0001221 | Memory Before: 2.46 Mb | Memory After: 2.46 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 36635 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001688 | Memory Before: 2.47 Mb | Memory After: 2.47 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 6163 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001330 | Memory Before: 2.48 Mb | Memory After: 2.48 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 1860 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0000660 | Memory Before: 2.42 Mb | Memory After: 2.42 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: No
SELECT groupid
FROM phpfox_user
WHERE user_name like 'user'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_userrangeuser_nameuser_name103 1Using where
0.0009730 | Memory Before: 2.94 Mb | Memory After: 2.94 Mb | Memory Used: 1.51 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.0001550 | Memory Before: 2.98 Mb | Memory After: 2.99 Mb | Memory Used: 1.51 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, 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   1Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4phpfoxfb.uf.user_id1 
Array
(
    [session] => 74a5d7a90d0a28a95f8b679d09be4f23
    [redirect] => /user/browse/location_IT/
)
Go to top