Dick Belair
Male
December 13, 1988
Colle San Magno » 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.2552068
PHP General Time:
0.0484578
GZIP:
enabled

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

Total Memory Usage:
2.7 Mb
Total Memory Usage (Including Debug):
2.76 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
198.13.61.26


Server Time Stamp:
March 29, 2020, 3:03 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.0000992 | Memory Before: 442.65 kb | Memory After: 444.16 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.0014739 | Memory Before: 739.89 kb | Memory After: 741.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 ('76f17098f22168620cb54a04d99febee', 'c56fb43d525078d2aaf85f739d93f298', '0', '1585494206', '/user/browse/location_IT/state_0/city-name_Colle San Magno/', '0', '0', '0', '35.175.121.230', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0000949 | Memory Before: 874.41 kb | Memory After: 875.92 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.0000660 | Memory Before: 877.75 kb | Memory After: 879.26 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.0001490 | Memory Before: 1.37 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.0001209 | Memory Before: 1.59 Mb | Memory After: 1.6 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.1138089 | Memory Before: 1.89 Mb | Memory After: 1.89 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 ufield.city_location = 'Colle San Magno' AND u.status_id = 0 AND u.view_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefstatus_idstatus_id2const,const19199Using where
1SIMPLEucveq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
1SIMPLEufieldeq_refuser_iduser_id4phpfoxfb.u.user_id1Using where
0.0894489 | Memory Before: 1.9 Mb | Memory After: 1.9 Mb | Memory Used: 1.51 kb | Rows: 1 | 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 ufield.city_location = 'Colle San Magno' 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,const19199Using where; Using temporary
1SIMPLEucveq_refuser_iduser_id4phpfoxfb.u.user_id1Using index
1SIMPLEufeq_refPRIMARYPRIMARY4phpfoxfb.u.user_id1 
1SIMPLEufieldeq_refuser_iduser_id4phpfoxfb.u.user_id1Using where
0.0003490 | Memory Before: 1.92 Mb | Memory After: 1.92 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 = 471) 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.0001891 | Memory Before: 1.94 Mb | Memory After: 1.94 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ban_data
WHERE user_id = 471 AND is_expired = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_ban_dataALL MISSING KEY   1Using where
0.0000780 | Memory Before: 2.07 Mb | Memory After: 2.07 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.0007870 | Memory Before: 2.56 Mb | Memory After: 2.56 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.0000842 | Memory Before: 2.61 Mb | Memory After: 2.61 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] => 76f17098f22168620cb54a04d99febee
    [redirect] => /user/browse/location_IT/state_0/city-name_Colle San Magno/
)
Go to top