0.0004470
| 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 ('ee106e60e1edada74bcd19f8701b8911', '4ca9f1300ee33ebb5cb53b4bba8430cc', '0', '1369256274', '/user/browse/from_33/to_34/', '0', '0', '0', '54.226.5.29', 'CCBot/2.0')
0.0001540
| 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.0106740
| Memory Before: 6.66 Mb
| Memory After: 6.66 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_user
AS u
JOIN phpfox2_user_field
AS ufield
ON(ufield.user_id = u.user_id)
WHERE u.birthday_search <= '315532800' AND ufield.dob_setting IN(0,1,2) AND u.birthday_search >= '283996800' AND ufield.dob_setting IN(0,1,2) AND u.status_id = 0 AND u.view_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | ref | PRIMARY,user_status,status_id | status_id | 2 | const,const | 1207 | Using where |
| 1 | SIMPLE | ufield | eq_ref | user_id | user_id | 4 | truckel0_phpfox.u.user_id | 1 | Using where |
0.0327790
| Memory Before: 6.72 Mb
| Memory After: 6.72 Mb
| Memory Used: 1.55 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 phpfox2_user
AS u
LEFT JOIN phpfox2_user_featured
AS uf
ON(uf.user_id = u.user_id)
JOIN phpfox2_user_field
AS ufield
ON(ufield.user_id = u.user_id)
WHERE u.birthday_search <= '315532800' AND ufield.dob_setting IN(0,1,2) AND u.birthday_search >= '283996800' AND ufield.dob_setting IN(0,1,2) 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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | ref | PRIMARY,user_status,status_id | status_id | 2 | const,const | 1207 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | uf | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.u.user_id | 1 | |
| 1 | SIMPLE | ufield | eq_ref | user_id | user_id | 4 | truckel0_phpfox.u.user_id | 1 | Using where |
0.0003960
| Memory Before: 6.96 Mb
| Memory After: 6.96 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1400 AND is_expired = 0
/* 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.0001969
| Memory Before: 7.04 Mb
| Memory After: 7.04 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 455 AND is_expired = 0
/* 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.0014160
| Memory Before: 7.05 Mb
| Memory After: 7.05 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1684 AND is_expired = 0
/* 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.0001850
| Memory Before: 7.06 Mb
| Memory After: 7.06 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1364 AND is_expired = 0
/* 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.0009320
| Memory Before: 7.07 Mb
| Memory After: 7.07 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1481 AND is_expired = 0
/* 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.0007629
| Memory Before: 7.07 Mb
| Memory After: 7.08 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 590 AND is_expired = 0
/* 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.0013640
| Memory Before: 7.08 Mb
| Memory After: 7.08 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 309 AND is_expired = 0
/* 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.0013461
| Memory Before: 7.09 Mb
| Memory After: 7.09 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 2027 AND is_expired = 0
/* 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.0016918
| Memory Before: 7.1 Mb
| Memory After: 7.1 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 354 AND is_expired = 0
/* 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.0016620
| Memory Before: 7.11 Mb
| Memory After: 7.11 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1243 AND is_expired = 0
/* 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.0022550
| Memory Before: 7.12 Mb
| Memory After: 7.12 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1500 AND is_expired = 0
/* 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.0020850
| Memory Before: 7.12 Mb
| Memory After: 7.13 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 543 AND is_expired = 0
/* 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.0000851
| Memory Before: 7.13 Mb
| Memory After: 7.13 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1992 AND is_expired = 0
/* 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.0001230
| Memory Before: 7.14 Mb
| Memory After: 7.14 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1055 AND is_expired = 0
/* 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.0007000
| Memory Before: 7.15 Mb
| Memory After: 7.15 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1484 AND is_expired = 0
/* 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.0045960
| Memory Before: 7.16 Mb
| Memory After: 7.16 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 604 AND is_expired = 0
/* 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.0009620
| Memory Before: 7.16 Mb
| Memory After: 7.17 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1379 AND is_expired = 0
/* 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.0001371
| Memory Before: 7.17 Mb
| Memory After: 7.17 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 208 AND is_expired = 0
/* 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.0047121
| Memory Before: 7.18 Mb
| Memory After: 7.18 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 980 AND is_expired = 0
/* 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.0156710
| Memory Before: 7.19 Mb
| Memory After: 7.19 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1499 AND is_expired = 0
/* 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.0041640
| Memory Before: 7.2 Mb
| Memory After: 7.2 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 545 AND is_expired = 0
/* 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.0056281
| Memory Before: 9.19 Mb
| Memory After: 9.19 Mb
| Memory Used: 1.56 kb
| Rows: 0
| 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 phpfox2_user
AS u
LEFT JOIN phpfox2_user_rating
AS ur
ON(ur.item_id = u.user_id AND ur.user_id = 0)
JOIN phpfox2_user_group
AS ug
ON(ug.user_group_id = u.user_group_id)
JOIN phpfox2_user_space
AS user_space
ON(user_space.user_id = u.user_id)
JOIN phpfox2_user_field
AS user_field
ON(user_field.user_id = u.user_id)
JOIN phpfox2_user_activity
AS user_activity
ON(user_activity.user_id = u.user_id)
LEFT JOIN phpfox2_theme_style
AS ts
ON(ts.style_id = user_field.designer_style_id)
LEFT JOIN phpfox2_theme
AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN phpfox2_log_session
AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
WHERE u.user_id = 0
/* 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 |