dmczxzxdmczxzx dmczxzxdmczxzx
Log In
:

dmczxzxdmczxzx's Quizzes

dmczxzxdmczxzx has not added any quizzes yet.
Powered By phpFox Version 2.0.4
Copyright ©2005 - 2012, Benc Enterprises AB
phpFox Developers Debug
Debug Details
Version:
2.0.4
Product Code Name:
Arctic

Total Time:
0.7418571
PHP General Time:
0.7123068
GZIP:
enabled

Driver Version:
MySQL 5.0.22
SQL Time:
0.0295503
SQL Queries:
23
SQL Memory Usage:
10.78 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
5.32 Mb
Total Memory Usage (Including Debug):
5.48 Mb
Memory Limit:
32 Mb (64M)

Load Balancing Enabled:
No
Requests From:
79.99.42.26


Server Time Stamp:
February 23, 2012, 6:08 am
PHP Version:
5.1.6
PHP Sapi:
apache2handler
PHP safe_mode:
false
PHP open_basedir:
true
Operating System:
Linux
SQL Queries
0.0111041 | Memory Before: 1.59 Mb | Memory After: 1.59 Mb | Memory Used: 368 b | Rows: 1 | Slave: No
SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = '378ef59ecebb3f9eb99fa0c3dd8729ae' AND s.id_hash = 'af7937af3e4465b9039e98887dc0bc04'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_hash,log_sessionsession_hash96const1Using where
0.0094960 | Memory Before: 1.6 Mb | Memory After: 1.6 Mb | Memory Used: 792 b | Rows: - | Slave: No
UPDATE phpfox_log_session SET last_activity = '1329977311', user_id = '0', location = '/dmczxzx/quiz/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.179.216', user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)' WHERE session_hash = '378ef59ecebb3f9eb99fa0c3dd8729ae'
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_log_sessionrefsession_hash,log_sessionsession_hash96const1Using where
0.0003240 | Memory Before: 1.75 Mb | Memory After: 1.75 Mb | Memory Used: 264 b | Rows: 3 | Slave: No
SELECT loc_id,loc_name,isbanned
FROM sc_locswitch
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsc_locswitchALL MISSING KEY   3 
0.0002952 | Memory Before: 1.76 Mb | Memory After: 1.76 Mb | Memory Used: 728 b | Rows: 1 | Slave: No
SELECT count(*)
FROM phpfox_country
WHERE isbanned =1 and country_iso = ''
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0002570 | Memory Before: 1.76 Mb | Memory After: 1.76 Mb | Memory Used: 328 b | Rows: 1 | Slave: No
SELECT count(*)
FROM sc_city_ban
WHERE isbanned =1 and city = 'Unknown'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0002670 | Memory Before: 1.76 Mb | Memory After: 1.76 Mb | Memory Used: 344 b | Rows: 1 | Slave: No
SELECT count(*)
FROM sc_zip_ban
WHERE isbanned =1 and zip = 'Unknown'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0005059 | Memory Before: 2.18 Mb | Memory After: 2.18 Mb | Memory Used: 912 b | 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
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_idPRIMARY2phpfoxdev.s.theme_id1 
0.0012178 | Memory Before: 2.66 Mb | Memory After: 2.66 Mb | Memory Used: 584 b | Rows: 1 | Slave: Yes
SELECT ur.rate_id AS has_rated, 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.parent_id AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title
FROM phpfox_user AS u
     LEFT JOIN phpfox_user_rating AS ur
            ON(ur.item_id = u.user_id AND ur.user_id = 0)
     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)
     LEFT JOIN phpfox_theme AS t
            ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_log_session AS ls
            ON(ls.user_id = u.user_id AND ls.im_hide = 0)

WHERE u.user_name = 'dmczxzx'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEursystemitem_id,item_id_2MISSING KEY    const row not found
1SIMPLEurefPRIMARY,user_name,user_group_iduser_name303const1Using where
1SIMPLEugrefuser_group_iduser_group_id1phpfoxdev.u.user_group_id2Using where
1SIMPLEuser_spaceeq_refuser_iduser_id4phpfoxdev.u.user_id2 
1SIMPLEuser_activityeq_refuser_iduser_id4phpfoxdev.user_space.user_id1Using where
1SIMPLEuser_fieldeq_refuser_iduser_id4phpfoxdev.user_activity.user_id1Using where
1SIMPLEtsrefstyle_idstyle_id2phpfoxdev.user_field.designer_style_id1 
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2phpfoxdev.ts.theme_id1 
1SIMPLElsrefuser_id,user_id_2user_id5phpfoxdev.user_space.user_id,const20Using index
0.0002880 | Memory Before: 2.79 Mb | Memory After: 2.79 Mb | Memory Used: 280 b | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_user_blocked
WHERE user_id = 146 AND block_user_id = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003462 | Memory Before: 2.83 Mb | Memory After: 2.83 Mb | Memory Used: 728 b | Rows: 0 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 146
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_privacyrefuser_id,user_id_2user_id4const1 
0.0005741 | Memory Before: 3.13 Mb | Memory After: 3.13 Mb | Memory Used: 856 b | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_quiz AS q
     JOIN phpfox_user AS u
            ON(u.user_id = q.user_id)

WHERE q.user_id = 146 AND (view_id = 0 OR (view_id = 1 AND q.user_id = 0)) AND (q.privacy = 1 OR (q.privacy != 1 && q.user_id = 0))
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0004771 | Memory Before: 3.17 Mb | Memory After: 3.17 Mb | Memory Used: 536 b | Rows: 0 | Slave: Yes
SELECT q.*, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_quiz AS q
     JOIN phpfox_user AS u
            ON(u.user_id = q.user_id)

WHERE q.user_id = 146 AND (view_id = 0 OR (view_id = 1 AND q.user_id = 0)) AND (q.privacy = 1 OR (q.privacy != 1 && q.user_id = 0))
ORDER BY q.time_stamp DESC
LIMIT 10
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0005579 | Memory Before: 3.33 Mb | Memory After: 3.33 Mb | Memory Used: 464 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003550 | Memory Before: 3.33 Mb | Memory After: 3.33 Mb | Memory Used: 384 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0006020 | Memory Before: 3.44 Mb | Memory After: 3.44 Mb | Memory Used: 480 b | Rows: 3 | Slave: Yes
SELECT cron.*
FROM phpfox_cron AS cron
     JOIN phpfox_product AS product
            ON(product.product_id = cron.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = cron.module_id AND m.is_active = 1)

WHERE cron.is_active = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcronrefis_activeis_active1const2 
1SIMPLEproductrefis_active,product_active,product_idproduct_active78phpfoxdev.cron.product_id,const2Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active228phpfoxdev.cron.module_id,const5Using index
0.0003641 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 264 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 9
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003538 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 264 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 10
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003669 | Memory Before: 3.66 Mb | Memory After: 3.66 Mb | Memory Used: 264 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 6
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003641 | Memory Before: 4.01 Mb | Memory After: 4.01 Mb | Memory Used: 560 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 7
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003641 | Memory Before: 5.3 Mb | Memory After: 5.3 Mb | Memory Used: 600 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 2
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003600 | Memory Before: 5.31 Mb | Memory After: 5.31 Mb | Memory Used: 400 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 4
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003550 | Memory Before: 5.31 Mb | Memory After: 5.31 Mb | Memory Used: 320 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 8
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003550 | Memory Before: 5.31 Mb | Memory After: 5.31 Mb | Memory Used: 320 b | Rows: 0 | Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 5
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
Session
Array
(
    [session] => 378ef59ecebb3f9eb99fa0c3dd8729ae
    [theme] => a:5:{s:8:"style_id";s:1:"1";s:15:"style_parent_id";s:1:"0";s:17:"style_folder_name";s:7:"default";s:17:"theme_folder_name";s:7:"default";s:15:"theme_parent_id";s:1:"0";}
    [redirect] => /dmczxzx/quiz/
)
Cookie
Array
(
    [phpfox1visit] => 1329976487
)