0.0002789
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 1.12 kb
| 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 = 'ece03a6fd1e2522387cbd228d3bbd6ad' AND s.id_hash = 'd0b63444099757fedc3d79aa837e804c'
/* 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 | 32 | const | 1 | Using where |
0.0001359
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_view (user_id, ip_address, protocal, cache_data, time_stamp) VALUES ('0', '38.107.191.83', 'GET', 'a:4:{s:8:\"location\";s:57:\"/Jared/video/outlook-portland-7-26-09-gypsy-queens-seg-4/\";s:8:\"referrer\";N;s:10:\"user_agent\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:7:\"request\";s:80:\"a:1:{s:2:\"do\";s:57:\"/Jared/video/outlook-portland-7-26-09-gypsy-queens-seg-4/\";}\";}', '1283793248')
0.0001850
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1283793248', user_id = '0', location = '/Jared/video/outlook-portland-7-26-09-gypsy-queens-seg-4/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.191.83', user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
WHERE session_hash = 'ece03a6fd1e2522387cbd228d3bbd6ad'
| 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 | 32 | const | 1 | Using where |
0.0002129
| Memory Before: 2.33 Mb
| Memory After: 2.34 Mb
| Memory Used: 1.13 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 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 | deathdlr_fox.s.theme_id | 1 | |
0.0000880
| Memory Before: 2.34 Mb
| Memory After: 2.34 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT folder
AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_style | ref | style_id | style_id | 2 | const | 1 | |
0.0000739
| Memory Before: 2.34 Mb
| Memory After: 2.34 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT folder
AS parent_theme_folder
FROM phpfox_theme
WHERE theme_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme | const | PRIMARY,theme_id | PRIMARY | 2 | const | 1 | |
0.0002649
| Memory Before: 2.96 Mb
| Memory After: 2.97 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT u.*
FROM phpfox_user
AS u
WHERE u.user_name = 'Jared'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | ref | user_name | user_name | 103 | const | 1 | Using where |
0.0002251
| Memory Before: 3.1 Mb
| Memory After: 3.1 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_user_blocked
WHERE user_id = 1 AND block_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 |
0.0006900
| Memory Before: 3.29 Mb
| Memory After: 3.29 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT video_track.item_id
AS video_is_viewed, v.*, vt.text_parsed
AS text, u.user_name, rate_id
AS has_rated, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_video
AS v
LEFT JOIN phpfox_video_track
AS video_track
ON(video_track.item_id = v.video_id AND video_track.user_id = 0)
JOIN phpfox_user
AS u
ON(u.user_id = v.user_id)
LEFT JOIN phpfox_video_text
AS vt
ON(vt.video_id = v.video_id)
LEFT JOIN phpfox_video_rating
AS vr
ON(vr.item_id = v.video_id AND vr.user_id = 0)
WHERE v.module_id = 'video' AND v.item_id = 0 AND v.title_url = 'outlook-portland-7-26-09-gypsy-queens-seg-4'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | v | ref | view_id,user_id | view_id | 340 | const,const,const | 1 | Using where |
| 1 | SIMPLE | vt | eq_ref | video_id | video_id | 4 | deathdlr_fox.v.video_id | 1 | |
| 1 | SIMPLE | vr | ALL | item_id,item_id_2 | MISSING KEY | | | 1 | |
| 1 | SIMPLE | video_track | ref | item_id | item_id | 8 | deathdlr_fox.v.video_id,const | 2 | Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | deathdlr_fox.v.user_id | 1 | |
0.0002880
| Memory Before: 3.4 Mb
| Memory After: 3.4 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_video_category_data
AS pcd
JOIN phpfox_video_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.video_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,video_id | video_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | deathdlr_fox.pcd.category_id | 1 | Using where |
0.0000920
| Memory Before: 3.4 Mb
| Memory After: 3.41 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT video_url, embed_code
FROM phpfox_video_embed
WHERE video_id = 5
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_video_embed | const | video_id | video_id | 4 | const | 1 | |
0.0010591
| Memory Before: 3.47 Mb
| Memory After: 3.47 Mb
| Memory Used: 1.12 kb
| Rows: 0
| Slave: Yes
SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox_tag
WHERE item_id = 5 AND category_id = 'video'
ORDER BY tag_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_tag | ref | item_id,category_id,user_search,user_search_general,item_id_2,item_id_3 | item_id | 81 | const,const | 1 | Using where; Using filesort |
0.0002508
| Memory Before: 3.89 Mb
| Memory After: 3.89 Mb
| Memory Used: 1.12 kb
| Rows: 2
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 2 | |
0.0001020
| Memory Before: 3.92 Mb
| Memory After: 3.92 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT count_view
FROM phpfox_ad
WHERE ad_id = 9
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0001070
| Memory Before: 3.92 Mb
| Memory After: 3.92 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = '71748'
WHERE ad_id = 9
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0002120
| Memory Before: 3.92 Mb
| Memory After: 3.92 Mb
| Memory Used: 1.12 kb
| Rows: 5
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 4 | |
0.0000780
| Memory Before: 3.93 Mb
| Memory After: 3.93 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT count_view
FROM phpfox_ad
WHERE ad_id = 15
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000789
| Memory Before: 3.93 Mb
| Memory After: 3.93 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = '32504'
WHERE ad_id = 15
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0004768
| Memory Before: 4.06 Mb
| Memory After: 4.07 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
DELETE FROM phpfox_log_session
WHERE last_activity < '1283792348'
| 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.0002151
| Memory Before: 4.06 Mb
| Memory After: 4.07 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_cron
SET next_run = '1283796848', last_run = '1283793248'
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.0001600
| Memory Before: 4.06 Mb
| Memory After: 4.07 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_cron_log (cron_id, time_stamp) VALUES ('1', '1283793248')
0.0002389
| Memory Before: 4.46 Mb
| Memory After: 4.47 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 9
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 1 | |
0.0000820
| Memory Before: 4.47 Mb
| Memory After: 4.47 Mb
| Memory Used: 1.13 kb
| Rows: 1
| Slave: Yes
SELECT count_view
FROM phpfox_ad
WHERE ad_id = 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000901
| Memory Before: 4.47 Mb
| Memory After: 4.47 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = '113240'
WHERE ad_id = 10
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0001771
| Memory Before: 4.6 Mb
| Memory After: 4.6 Mb
| Memory Used: 1.13 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 1 | |
0.0001531
| Memory Before: 4.6 Mb
| Memory After: 4.6 Mb
| Memory Used: 1.12 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 6
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 1 | |
0.0001941
| Memory Before: 5.03 Mb
| Memory After: 5.03 Mb
| Memory Used: 1.12 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 7
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 1 | |
0.0003030
| Memory Before: 5.21 Mb
| Memory After: 5.21 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_video
AS m
WHERE m.video_id != 5 AND m.in_process = 0 AND m.view_id = 0 AND m.user_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,in_process,video_id_2,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,video_id,video_id_3,view_id_3,user_id,view_id_4 | view_id_4 | 5 | const,const | 6 | Using where |
0.0004861
| Memory Before: 5.25 Mb
| Memory After: 5.25 Mb
| Memory Used: 1.12 kb
| Rows: 6
| Slave: Yes
SELECT m.*, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_video
AS m
JOIN phpfox_user
AS u
ON(u.user_id = m.user_id)
WHERE m.video_id != 5 AND m.in_process = 0 AND m.view_id = 0 AND m.user_id = 1
ORDER BY m.is_featured
DESC , m.time_stamp
DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | m | ref | PRIMARY,in_process,video_id_2,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,video_id,video_id_3,view_id_3,user_id,view_id_4 | view_id_4 | 5 | const,const | 6 | Using where |
0.0002589
| Memory Before: 5.29 Mb
| Memory After: 5.29 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_video
AS m
WHERE m.video_id != 5 AND m.in_process = 0 AND m.view_id = 0 AND m.title LIKE '%Gypsy Queens - Seg 4 - Outlook Portland 7/26/09%'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,in_process,video_id_2,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,video_id,video_id_3,view_id_3,view_id_4 | in_process | 1 | const | 7 | Using where |
0.0001869
| Memory Before: 5.29 Mb
| Memory After: 5.29 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 2
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 1 | |
0.0002100
| Memory Before: 5.61 Mb
| Memory After: 5.61 Mb
| Memory Used: 1.13 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 1 | |
0.0001500
| Memory Before: 5.61 Mb
| Memory After: 5.61 Mb
| Memory Used: 1.13 kb
| Rows: 0
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 8
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 1 | |
0.0001681
| Memory Before: 5.62 Mb
| Memory After: 5.62 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT *
FROM phpfox_ad
WHERE is_active = 1 AND location = 5
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | ref | is_active | is_active | 2 | const,const | 1 | |
0.0000801
| Memory Before: 5.62 Mb
| Memory After: 5.62 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT count_view
FROM phpfox_ad
WHERE ad_id = 11
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000980
| Memory Before: 5.62 Mb
| Memory After: 5.62 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = '112999'
WHERE ad_id = 11
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |