Version:
2.1.0
Product Code Name:
Arctic
Total Time:
0.7722230
PHP General Time:
0.4214781
GZIP:
enabled
Driver Version:
MySQL 5.1.68-cll
SQL Time:
0.3507449
SQL Queries:
8
SQL Memory Usage:
12.35 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
8.08 Mb
Total Memory Usage (Including Debug):
8.31 Mb
Memory Limit:
32 Mb (64M)
Load Balancing Enabled:
No
Requests From:
174.127.109.132
Server Time Stamp:
May 22, 2013, 1:30 pm
PHP Version:
5.3.23
PHP Sapi:
cgi-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
0.0704610
| Memory Before: 3.41 Mb
| Memory After: 3.41 Mb
| Memory Used: 1.47 kb
| Rows: -
| Slave: No
INSERT INTO phpfox2_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('a28371cc1fbc20799f4208ba991bab98', 'bf4ce0c74c3c4e4d8748213d6100c68b', '0', '1369229440', '/quiz/', '0', '0', '0', '23.22.76.170', 'CCBot/2.0')
0.0001600
| Memory Before: 4.35 Mb
| Memory After: 4.35 Mb
| Memory Used: 1.55 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
FROM phpfox2_theme_style
AS s
JOIN phpfox2_theme
AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | system | is_default | MISSING KEY | | | 1 | |
| 1 | SIMPLE | t | system | PRIMARY,theme_id | MISSING KEY | | | 1 | |
0.2775290
| Memory Before: 4.96 Mb
| Memory After: 4.96 Mb
| Memory Used: 1.55 kb
| Rows: 30
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_quiz
AS q
JOIN phpfox2_user
AS u
ON(u.user_id = q.user_id)
WHERE q.view_id = 0 AND (q.privacy = 1 OR (q.privacy != 1 && q.user_id = 0))
GROUP BY q.quiz_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | q | ALL | view_id,browsing,user_id | MISSING KEY | | | 30 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.q.user_id | 1 | Using index |
0.0011971
| Memory Before: 5.2 Mb
| Memory After: 5.21 Mb
| Memory Used: 1.55 kb
| Rows: 10
| 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 phpfox2_quiz
AS q
JOIN phpfox2_user
AS u
ON(u.user_id = q.user_id)
WHERE q.view_id = 0 AND (q.privacy = 1 OR (q.privacy != 1 && q.user_id = 0))
GROUP BY q.quiz_id
ORDER BY q.time_stamp
DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | q | range | view_id,browsing,user_id | view_id | 1 | | 29 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.q.user_id | 1 | |
0.0008781
| Memory Before: 7.54 Mb
| Memory After: 7.54 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox2_ad
WHERE is_active = 1 AND location = 2
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0002298
| Memory Before: 8.06 Mb
| Memory After: 8.06 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox2_ad
WHERE is_active = 1 AND location = 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0000989
| Memory Before: 8.06 Mb
| Memory After: 8.07 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox2_ad
WHERE is_active = 1 AND location = 8
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0001910
| Memory Before: 8.07 Mb
| Memory After: 8.07 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox2_ad
WHERE is_active = 1 AND location = 5
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
Array
(
[session] => a28371cc1fbc20799f4208ba991bab98
[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] => /quiz/
)
