Abbie Andersen
Male
June 16, 1981
Marseille » France
Abbie Ginn
Male
May 3, 1987
Salon-De-Provence » France
Abby Lawley
Male
March 23, 1980
Paris » France
Abel McCall
Male
July 23, 1985
Pontault-Combault » France
Abel Sperry
Male
June 15, 1986
Villeurbanne » France
Abigail Markley
Male
August 26, 1990
Saintes » France
Abraham Macmillan
Male
November 22, 1980
Saint-Germain-En-Laye » France
Abraham Toney
Male
May 4, 1988
Hazebrouck » France
Ada Queale
Male
July 7, 1982
Le Tampon » France
Adalberto Somerset
Male
July 13, 1990
Muret » France
Adalberto Woodd
Male
June 13, 1988
Villeneuve-D'ascq » France
Adam Wampler
Male
February 25, 1982
Marseille » France
Adan Hann
Male
January 3, 1987
Montbeliard » France
Addie Murch
Male
September 15, 1986
Montpellier » France
Adela Atencio
Male
May 3, 1986
Marseille » France
Adelaide Brodzky
Male
July 20, 1985
Libourne » France
Adelaide Schweizer
Male
November 27, 1990
Amiens » France
Adele Kitson
Male
August 1, 1987
Rosny-Sous-Bois » France
Adeline Hogue
Male
November 1, 1986
Cachan » France
Adell McGovern
Male
September 7, 1987
Chalon-Sur-Saone » France
Adolph Dettmann
Male
August 12, 1982
Fontenay-Sous-Bois » France
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.4179120
PHP General Time:
0.065265
GZIP:
enabled

Driver Version:
MySQL 5.5.62-0ubuntu0.14.04.1
SQL Time:
0.3526470
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, 4:16 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.0000870 | 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.0012519 | Memory Before: 738.91 kb | Memory After: 740.27 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 ('2f6e20b8c795816efc7ae518ff5321ec', 'c56fb43d525078d2aaf85f739d93f298', '0', '1585498597', '/user/browse/location_FR/', '0', '0', '0', '35.175.121.230', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0000901 | Memory Before: 873.45 kb | Memory After: 874.96 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.0000648 | Memory Before: 876.79 kb | Memory After: 878.3 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.0001321 | 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.0000780 | 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.2325859 | 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 = 'FR' AND u.status_id = 0 AND u.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefstatus_idstatus_id2const,const20846Using where
1SIMPLEucveq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
1SIMPLEufieldeq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
0.1086781 | 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 = 'FR' 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,const20846Using where; Using temporary
1SIMPLEucveq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
1SIMPLEufeq_refPRIMARYPRIMARY4phpfoxfb.u.user_id1 
1SIMPLEufieldeq_refuser_iduser_id4phpfoxfb.u.user_id1 
0.0005569 | 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 = 17599) 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.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 = 1197) 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.0002730 | 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 = 21023) 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.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 = 3350) 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.0002050 | 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 = 26004) 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.0002179 | 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 = 14824) 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.0002291 | 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 = 11678) 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.0002069 | 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 = 12282) 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.0002949 | 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 = 15610) 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.0002489 | 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 = 26551) 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.0001962 | 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 = 10066) 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.0002539 | 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 = 29081) 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.0002482 | 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 = 9181) 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.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 = 14862) 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.0002611 | 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 = 2658) 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.0002980 | 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 = 27294) 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.0001931 | 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 = 7366) 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.0002348 | 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 = 31599) 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.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 = 14218) 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.0002239 | 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 = 20380) 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.0002129 | 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 = 13220) 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.0001788 | 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 = 17599 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001390 | 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 = 1197 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001290 | 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 = 21023 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001321 | 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 = 3350 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001600 | 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 = 26004 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001240 | 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 = 14824 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001330 | 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 = 11678 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001509 | 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 = 12282 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001240 | 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 = 15610 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001330 | 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 = 26551 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001371 | 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 = 10066 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001709 | 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 = 29081 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001249 | 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 = 9181 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001171 | 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 = 14862 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001528 | 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 = 2658 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001490 | 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 = 27294 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001862 | 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 = 7366 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001221 | 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 = 31599 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001988 | 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 = 14218 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001390 | 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 = 20380 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0001900 | 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 = 13220 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0000701 | 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.0011768 | 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.0000789 | 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] => 2f6e20b8c795816efc7ae518ff5321ec
    [redirect] => /user/browse/location_FR/
)
Go to top