0.0004418
| 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 | session_hash | 96 | const | 1 | Using where |
0.0004499
| Memory Before: 1.6 Mb
| Memory After: 1.6 Mb
| Memory Used: 808 b
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1337702125', user_id = '0', location = '/group/cheap-ugg-boots/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.179.218', 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 | session_hash | 96 | const | 1 | Using where |
0.0003312
| Memory Before: 1.75 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.0003071
| 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.0002730
| 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.0002661
| 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.0004389
| 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.0181911
| 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 = 'cheap-ugg-boots'
/* 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.0007992
| Memory Before: 2.77 Mb
| Memory After: 2.77 Mb
| Memory Used: 592 b
| Rows: 2
| 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 = 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 | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0006161
| Memory Before: 2.91 Mb
| Memory After: 2.91 Mb
| Memory Used: 1.09 kb
| Rows: 3
| Slave: No
SELECT var_name, access_value
FROM phpfox_group_access
WHERE group_id = 2
/* 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 | 4 | |
0.0006609
| Memory Before: 3.89 Mb
| Memory After: 3.9 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 = 2
/* 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.0004890
| Memory Before: 4.04 Mb
| Memory After: 4.04 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 = 2
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.0009041
| Memory Before: 4.24 Mb
| Memory After: 4.24 Mb
| Memory Used: 480 b
| Rows: 3
| Slave: Yes
SELECT cron.*
FROM phpfox_cron
AS cron
JOIN phpfox_product
AS product
ON(product.product_id = cron.product_id AND product.is_active = 1)
JOIN phpfox_module
AS m
ON(m.module_id = cron.module_id AND m.is_active = 1)
WHERE cron.is_active = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | cron | ref | is_active | is_active | 1 | const | 2 | |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 78 | phpfoxdev.cron.product_id,const | 2 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 228 | phpfoxdev.cron.module_id,const | 5 | Using index |
0.0005851
| Memory Before: 4.25 Mb
| Memory After: 4.25 Mb
| Memory Used: 280 b
| Rows: -
| Slave: No
DELETE FROM phpfox_log_session
WHERE last_activity < '1337691325'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_log_session | range | specific_forum,general_forum,last_activity | specific_forum | 4 | | 1 | Using where |
0.0003200
| Memory Before: 4.24 Mb
| Memory After: 4.24 Mb
| Memory Used: 592 b
| Rows: -
| Slave: No
UPDATE phpfox_cron
SET next_run = '1337702185', last_run = '1337702125'
WHERE cron_id = 1
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_cron | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002630
| Memory Before: 4.25 Mb
| Memory After: 4.25 Mb
| Memory Used: 240 b
| Rows: -
| Slave: No
INSERT INTO phpfox_cron_log (cron_id, time_stamp) VALUES ('1', '1337702125')
0.0005341
| Memory Before: 6.11 Mb
| Memory After: 6.11 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 = 2 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.0005641
| Memory Before: 6.31 Mb
| Memory After: 6.32 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 = 2
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.0014689
| 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 = 2 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.0007660
| Memory Before: 6.55 Mb
| Memory After: 6.55 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 = 2 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.0003998
| 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 = 2 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.0005500
| Memory Before: 6.61 Mb
| Memory After: 6.61 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 = 2 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.0005929
| Memory Before: 6.89 Mb
| Memory After: 6.89 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 = 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.0009449
| 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 = 2 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 | |