0.0003281
| 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 ('7594abd1c67962e510c23b381c2e1771', '1aaf2349a3ed40ef0f86f3e65294a991', '0', '1369183035', '/group/safety-suggestions-and-ideas/member/', '0', '0', '0', '107.22.156.205', 'CCBot/2.0')
0.0001791
| 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.2521460
| Memory Before: 5.27 Mb
| Memory After: 5.28 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: No
SELECT e.*, et.description_parsed
AS description, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, ts.style_id
AS designer_style_id, ts.folder
AS designer_style_folder, t.folder
AS designer_theme_folder
FROM phpfox2_group
AS e
JOIN phpfox2_user
AS u
ON(u.user_id = e.user_id)
JOIN phpfox2_group_text
AS et
ON(et.group_id = e.group_id)
LEFT JOIN phpfox2_theme_style
AS ts
ON(ts.style_id = e.designer_style_id)
LEFT JOIN phpfox2_theme
AS t
ON(t.theme_id = ts.theme_id)
WHERE e.title_url = 'safety-suggestions-and-ideas'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | e | ref | PRIMARY,group_id,view_id_2,user_id | view_id_2 | 257 | const | 1 | Using where |
| 1 | SIMPLE | ts | ref | style_id | style_id | 2 | truckel0_phpfox.e.designer_style_id | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | truckel0_phpfox.ts.theme_id | 1 | |
| 1 | SIMPLE | et | ref | group_id | group_id | 4 | truckel0_phpfox.e.group_id | 2 | |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.e.user_id | 1 | |
0.0001421
| Memory Before: 5.45 Mb
| Memory After: 5.45 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox2_group_category_data
AS pcd
JOIN phpfox2_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 5
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,group_id | group_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | truckel0_phpfox.pcd.category_id | 1 | Using where |
0.0001581
| Memory Before: 5.72 Mb
| Memory After: 5.73 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: No
SELECT var_name, access_value
FROM phpfox2_group_access
WHERE group_id = 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 |
0.0003979
| Memory Before: 7.55 Mb
| Memory After: 7.55 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT cache_id, block_id, ordering, is_hidden
FROM phpfox2_group_design_order
WHERE group_id = 5
ORDER BY ordering ASC
/* 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.0523741
| Memory Before: 9.35 Mb
| Memory After: 9.35 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_user
AS u
JOIN phpfox2_group_invite
AS gi
ON(gi.group_id = 5 AND gi.member_id = 1 AND gi.invited_user_id = u.user_id)
JOIN phpfox2_user_field
AS ufield
ON(ufield.user_id = u.user_id)
WHERE 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 | gi | ref | group_id,invited_user_id,group_id_2,group_id_3,group_id_4,group_id_5 | group_id_2 | 5 | const,const | 35 | Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_status,status_id | PRIMARY | 4 | truckel0_phpfox.gi.invited_user_id | 1 | Using where |
| 1 | SIMPLE | ufield | eq_ref | user_id | user_id | 4 | truckel0_phpfox.u.user_id | 1 | Using where; Using index |
0.0151031
| Memory Before: 9.41 Mb
| Memory After: 9.41 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
JOIN phpfox2_group_invite
AS gi
ON(gi.group_id = 5 AND gi.member_id = 1 AND gi.invited_user_id = u.user_id)
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.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 | gi | ref | group_id,invited_user_id,group_id_2,group_id_3,group_id_4,group_id_5 | group_id_2 | 5 | const,const | 35 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_status,status_id | PRIMARY | 4 | truckel0_phpfox.gi.invited_user_id | 1 | Using where |
| 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.gi.invited_user_id | 1 | |
0.0001969
| Memory Before: 9.77 Mb
| Memory After: 9.77 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 470 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.0009809
| Memory Before: 9.85 Mb
| Memory After: 9.86 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 44 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.0004041
| Memory Before: 9.86 Mb
| Memory After: 9.86 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 31 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.0003440
| Memory Before: 9.87 Mb
| Memory After: 9.87 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 22 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.0001330
| Memory Before: 9.88 Mb
| Memory After: 9.88 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 73 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.0001190
| Memory Before: 9.89 Mb
| Memory After: 9.89 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 67 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.0027812
| Memory Before: 9.9 Mb
| Memory After: 9.9 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 68 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.0003591
| Memory Before: 9.9 Mb
| Memory After: 9.9 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 72 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.0001380
| Memory Before: 9.91 Mb
| Memory After: 9.91 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 849 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.0001099
| Memory Before: 9.92 Mb
| Memory After: 9.92 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 34 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.0000780
| Memory Before: 9.93 Mb
| Memory After: 9.93 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 18 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.0001140
| Memory Before: 9.94 Mb
| Memory After: 9.94 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 11 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.0001221
| Memory Before: 9.94 Mb
| Memory After: 9.95 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 13 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.0011241
| Memory Before: 9.95 Mb
| Memory After: 9.95 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 76 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.0009871
| Memory Before: 9.96 Mb
| Memory After: 9.96 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 580 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.0009260
| Memory Before: 9.97 Mb
| Memory After: 9.97 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 907 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.0009098
| Memory Before: 9.98 Mb
| Memory After: 9.98 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 2 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.0009768
| Memory Before: 9.99 Mb
| Memory After: 9.99 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 45 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.0009871
| Memory Before: 9.99 Mb
| Memory After: 10 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 1336 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.0009501
| Memory Before: 10 Mb
| Memory After: 10 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 60 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.0009181
| Memory Before: 10.01 Mb
| Memory After: 10.01 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox2_ban_data
WHERE user_id = 19 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.0012660
| Memory Before: 11.69 Mb
| Memory After: 11.69 Mb
| Memory Used: 1.55 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 |