0.0004442
| 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 ('0520bd258bb505b73e6b33838d3bbf48', 'd2b2f181ec998eb5e71c98ba28f03840', '0', '1371662411', '/group/', '0', '0', '0', '50.16.36.153', 'CCBot/2.0')
0.0001931
| 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.0002291
| Memory Before: 5.88 Mb
| Memory After: 5.88 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_group
AS m
WHERE m.is_public = 0 AND m.view_id IN(0,1)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | view_id,view_id_3,is_public_2,is_public | is_public_2 | 1 | const | 1 | Using where; Using index |
0.0012369
| Memory Before: 6.13 Mb
| Memory After: 6.13 Mb
| Memory Used: 1.55 kb
| Rows: 9
| Slave: Yes
SELECT ei.member_id, m.*, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox2_group
AS m
LEFT JOIN phpfox2_group_invite
AS ei
ON(ei.group_id = m.group_id AND ei.invited_user_id = 0)
JOIN phpfox2_user
AS u
ON(u.user_id = m.user_id)
WHERE m.is_public = 0 AND m.view_id IN(0,1)
GROUP BY m.group_id
ORDER BY m.is_featured
DESC , m.time_stamp
DESC
LIMIT 12
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | view_id,view_id_3,is_public_2,is_public,user_id | is_public_2 | 1 | const | 1 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | ei | ref | group_id,invited_user_id,group_id_2,group_id_3,group_id_4,group_id_5 | invited_user_id | 4 | const | 1 | |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.m.user_id | 1 | |
0.0001249
| Memory Before: 6.34 Mb
| Memory After: 6.34 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 = 9
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.0000679
| Memory Before: 6.34 Mb
| Memory After: 6.35 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 = 8
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.0000658
| Memory Before: 6.35 Mb
| Memory After: 6.35 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 = 7
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.0000632
| Memory Before: 6.36 Mb
| Memory After: 6.36 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 = 6
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.0000641
| Memory Before: 6.36 Mb
| Memory After: 6.36 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.0000801
| Memory Before: 6.37 Mb
| Memory After: 6.37 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 = 4
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.0000651
| Memory Before: 6.37 Mb
| Memory After: 6.38 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 = 3
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.0000601
| Memory Before: 6.38 Mb
| Memory After: 6.38 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 = 2
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.0000801
| Memory Before: 6.39 Mb
| Memory After: 6.39 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 = 1
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.0010371
| Memory Before: 8.66 Mb
| Memory After: 8.66 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 |
