Aaron Nieves
Male
December 25, 1988
Wenneberg » Austria
Abby Burdge
Male
March 11, 1980
Muhlbach » Austria
Abby Manifold
Male
August 1, 1986
Aschbach Bei Furstenfeld » Austria
Abby Soule
Male
February 26, 1981
Gasteig » Austria
Abdul Gamble
Male
September 8, 1988
Hasenberg » Austria
Abigail Clowes
Male
February 17, 1988
Kogl » Austria
Abigail Jacobson
Male
February 21, 1990
Schalkham » Austria
Ada Cintron
Male
January 11, 1980
Grossarl » Austria
Ada Steere
Male
October 27, 1982
Grassendorf » Austria
Adalberto Crutchfield
Male
April 20, 1987
Hormsdorf » Austria
Adam Horton
Male
January 8, 1988
Jetzles » Austria
Adan Mathew
Male
October 13, 1980
Mitterlimberg » Austria
Adela Quintero
Male
February 28, 1986
Holzhauseln » Austria
Adelaide Ciotti
Male
September 4, 1986
Krottendorf » Austria
Adelaide Junkins
Male
August 4, 1981
Prettles » Austria
Adelaide Koehler
Male
January 8, 1987
Wien » Austria
Adelaide Wannemaker
Male
October 21, 1984
Zaun » Austria
Adeline Council
Male
June 16, 1985
Harterding » Austria
Adrian Soriano
Male
February 16, 1987
Bad Blumau » Austria
Adriana Putilin
Male
September 10, 1986
Georgenberg » Austria
Adriene Fowell
Male
June 27, 1983
Mitterberg » Austria
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.4111190
PHP General Time:
0.0672832
GZIP:
enabled

Driver Version:
MySQL 5.5.62-0ubuntu0.14.04.1
SQL Time:
0.3438358
SQL Queries:
53
SQL Memory Usage:
79.78 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, 3:01 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.0000999 | 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.0012648 | 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 ('bb7d20efd3b14018072e105ae43af2dd', 'c56fb43d525078d2aaf85f739d93f298', '0', '1585494104', '/user/browse/location_AT/', '0', '0', '0', '35.175.121.230', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0000761 | 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.0000920 | 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.0001059 | 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.2281599 | 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 = 'AT' AND u.status_id = 0 AND u.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefstatus_idstatus_id2const,const19342Using where
1SIMPLEucveq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
1SIMPLEufieldeq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
0.1034350 | 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 = 'AT' 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,const19342Using where; Using temporary
1SIMPLEucveq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
1SIMPLEufeq_refPRIMARYPRIMARY4phpfoxfb.u.user_id1 
1SIMPLEufieldeq_refuser_iduser_id4phpfoxfb.u.user_id1 
0.0004530 | 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 = 18515) 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.0002739 | 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 = 7347) 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.0002170 | 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 = 731) 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.0003159 | 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 = 14631) 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.0002282 | 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 = 21442) 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.0002420 | 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 = 22280) 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.0002270 | 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 = 13607) 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.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 = 22510) 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.0003481 | 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 = 3440) 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.0002260 | 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 = 11095) 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.0002241 | 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 = 23530) 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.0002019 | 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 = 10829) 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.0002899 | 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 = 6216) 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.0002582 | 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 = 23923) 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.0002010 | 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 = 7263) 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.0002270 | 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 = 21253) 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.0002170 | 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 = 233) 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.0002110 | 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 = 2471) 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.0002818 | 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 = 39602) 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.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 = 26087) 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.0003819 | 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 = 5777) 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.0003948 | Memory Before: 2.25 Mb | Memory After: 2.26 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 18515 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001879 | Memory Before: 2.27 Mb | Memory After: 2.27 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 7347 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001910 | 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 = 731 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001562 | 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 = 14631 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001299 | 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 = 21442 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001988 | Memory Before: 2.31 Mb | Memory After: 2.31 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 22280 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001209 | Memory Before: 2.32 Mb | Memory After: 2.33 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 13607 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001671 | Memory Before: 2.33 Mb | Memory After: 2.34 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 22510 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001800 | 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 = 3440 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0002148 | 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 = 11095 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001659 | 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 = 23530 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0002620 | 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 = 10829 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001500 | 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 = 6216 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001569 | 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 = 23923 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001349 | 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 = 7263 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001681 | Memory Before: 2.42 Mb | Memory After: 2.42 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 21253 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001481 | Memory Before: 2.43 Mb | Memory After: 2.44 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 233 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001459 | Memory Before: 2.44 Mb | Memory After: 2.45 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 2471 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001650 | 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 = 39602 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001152 | 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 = 26087 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001578 | 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 = 5777 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0000651 | 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.0012019 | 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.0000880 | Memory Before: 2.98 Mb | Memory After: 2.98 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] => bb7d20efd3b14018072e105ae43af2dd
    [redirect] => /user/browse/location_AT/
)
Go to top