0.0004749
| 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 = 'f3d5a875be8fdbc3758a1d3b831bc010' AND s.id_hash = 'af7937af3e4465b9039e98887dc0bc04'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ref | session_hash,log_session | log_session | 192 | const,const | 1 | Using where |
0.0004721
| Memory Before: 1.6 Mb
| Memory After: 1.6 Mb
| Memory Used: 808 b
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1337701479', user_id = '0', location = '/group/a-guide-to-types-of-wedding-dresses/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.179.217', user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
WHERE session_hash = 'f3d5a875be8fdbc3758a1d3b831bc010'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_log_session | ref | session_hash,log_session | log_session | 96 | const | 1 | Using where |
0.0003240
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 264 b
| Rows: 3
| Slave: No
SELECT loc_id,loc_name,isbanned
FROM sc_locswitch
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | sc_locswitch | ALL | | MISSING KEY | | | 3 | |
0.0002999
| 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 */
| 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.0002601
| 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 */
| 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.0002649
| 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 */
| 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.0004368
| 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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | phpfoxdev.s.theme_id | 1 | |
0.0008290
| Memory Before: 2.66 Mb
| Memory After: 2.66 Mb
| Memory Used: 384 b
| 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 phpfox_group
AS e
JOIN phpfox_user
AS u
ON(u.user_id = e.user_id)
JOIN phpfox_group_text
AS et
ON(et.group_id = e.group_id)
LEFT JOIN phpfox_theme_style
AS ts
ON(ts.style_id = e.designer_style_id)
LEFT JOIN phpfox_theme
AS t
ON(t.theme_id = ts.theme_id)
WHERE e.title_url = 'a-guide-to-types-of-wedding-dresses'
/* 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 | view_id_2 | 767 | const | 1 | Using where |
| 1 | SIMPLE | ts | ref | style_id | style_id | 2 | phpfoxdev.e.designer_style_id | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | phpfoxdev.ts.theme_id | 1 | |
| 1 | SIMPLE | et | ref | group_id | group_id | 4 | phpfoxdev.e.group_id | 7 | |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxdev.e.user_id | 1 | |
0.0004902
| Memory Before: 2.77 Mb
| Memory After: 2.77 Mb
| Memory Used: 592 b
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_group_category_data
AS pcd
JOIN phpfox_group_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.group_id = 37
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 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0003941
| Memory Before: 2.9 Mb
| Memory After: 2.91 Mb
| Memory Used: 1.17 kb
| Rows: 3
| Slave: No
SELECT var_name, access_value
FROM phpfox_group_access
WHERE group_id = 37
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_access | ref | group_id | group_id | 4 | const | 3 | |
0.0004489
| Memory Before: 3.89 Mb
| Memory After: 3.89 Mb
| Memory Used: 240 b
| Rows: 0
| Slave: No
SELECT gi.is_admin, g.group_id
FROM phpfox_group
AS g
JOIN phpfox_group_invite
AS gi
ON(gi.group_id = g.group_id AND gi.invited_user_id = 0)
WHERE g.group_id = 37
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | g | const | PRIMARY,group_id | PRIMARY | 4 | const | 1 | Using index |
| 1 | SIMPLE | gi | ref | group_id,invited_user_id,group_id_2,group_id_3,group_id_4,group_id_5 | group_id | 4 | const | 1 | Using where |
0.0003011
| Memory Before: 4.03 Mb
| Memory After: 4.03 Mb
| Memory Used: 744 b
| Rows: 0
| Slave: Yes
SELECT cache_id, block_id, ordering, is_hidden
FROM phpfox_group_design_order
WHERE group_id = 37
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.0005322
| Memory Before: 6.1 Mb
| Memory After: 6.1 Mb
| Memory Used: 536 b
| Rows: 1
| Slave: Yes
SELECT u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, g.user_id
AS creator_id
FROM phpfox_group_invite
AS gi
JOIN phpfox_group
AS g
ON(g.group_id = gi.group_id)
JOIN phpfox_user
AS u
ON(u.user_id = gi.invited_user_id)
WHERE gi.group_id = 37 AND gi.is_admin = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | g | const | PRIMARY,group_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | gi | ref | group_id,invited_user_id,group_id_2,group_id_3,group_id_4,group_id_5 | group_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxdev.gi.invited_user_id | 1 | |
0.0003831
| Memory Before: 6.31 Mb
| Memory After: 6.31 Mb
| Memory Used: 568 b
| Rows: 0
| Slave: Yes
SELECT s.shout_id, s.text, s.time_stamp, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_group_shoutbox
AS s
JOIN phpfox_user
AS u
ON(u.user_id = s.user_id)
WHERE item_id = 37
ORDER BY s.time_stamp
DESC
LIMIT 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.0012250
| Memory Before: 6.42 Mb
| Memory After: 6.42 Mb
| Memory Used: 304 b
| Rows: 0
| Slave: Yes
SELECT m.event_id, m.title, m.title_url, m.tag_line, m.image_path, m.server_id, m.start_time, m.location, m.country_iso, m.city, m.module_id, m.item_id
FROM phpfox_event
AS m
WHERE m.view_id = 0 AND m.module_id = 'group' AND m.item_id = 37 AND m.start_time >= '1337644800'
ORDER BY m.start_time ASC
LIMIT 5
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | view_id_3,module_id,view_id,view_id_2 | module_id | 231 | const,const | 1 | Using where; Using filesort |
0.0005581
| Memory Before: 6.54 Mb
| Memory After: 6.54 Mb
| Memory Used: 328 b
| Rows: 0
| Slave: Yes
SELECT ft.title, ft.title_url, ft.time_stamp, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_forum_thread
AS ft
JOIN phpfox_user
AS u
ON(u.user_id = ft.user_id)
WHERE ft.group_id = 37 AND ft.view_id = 0 AND ft.is_announcement = 0
ORDER BY ft.time_stamp
DESC
LIMIT 5
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | ft | ref | group_id,group_id_2 | group_id | 5 | const,const | 1 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxdev.ft.user_id | 1 | |
0.0004001
| Memory Before: 6.57 Mb
| Memory After: 6.57 Mb
| Memory Used: 688 b
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_group_invite
WHERE group_id = 37 AND member_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_group_invite | ref | group_id,group_id_2,group_id_3,group_id_4,group_id_5 | group_id | 4 | const | 1 | Using where |
0.0005550
| Memory Before: 6.6 Mb
| Memory After: 6.6 Mb
| Memory Used: 552 b
| Rows: 1
| Slave: Yes
SELECT ei.*, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_group_invite
AS ei
LEFT JOIN phpfox_user
AS u
ON(u.user_id = ei.invited_user_id)
WHERE ei.group_id = 37 AND ei.member_id = 1
ORDER BY ei.invite_id
DESC
LIMIT 6
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | ei | ref | group_id,group_id_2,group_id_3,group_id_4,group_id_5 | group_id | 4 | const | 1 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxdev.ei.invited_user_id | 1 | |
0.0003669
| Memory Before: 6.88 Mb
| Memory After: 6.88 Mb
| Memory Used: 744 b
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_video
AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.module_id = 'group' AND m.item_id = 37
/* 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.0005820
| Memory Before: 7.03 Mb
| Memory After: 7.03 Mb
| Memory Used: 752 b
| Rows: 0
| Slave: Yes
SELECT p.destination, p.server_id, p.title_url, p.title, p.mature, p.album_id, pa.name_url
AS album_url, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_photo
AS p
JOIN phpfox_user
AS u
ON(u.user_id = p.user_id)
LEFT JOIN phpfox_photo_album
AS pa
ON(pa.album_id = p.album_id)
WHERE p.view_id = 0 AND p.group_id = 37 AND p.privacy = 0
ORDER BY p.time_stamp
DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pa | system | PRIMARY,album_id | MISSING KEY | | | | const row not found |
| 1 | SIMPLE | p | ref | view_id,view_id_2,view_id_3,view_id_4,view_id_5 | view_id | 6 | const,const,const | 1 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxdev.p.user_id | 1 | |