0.0004940
| Memory Before: 2.29 Mb
| Memory After: 2.29 Mb
| Memory Used: 3.86 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 = 'c3ab4017de7b588b39485b10b4c9dcce' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* 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 index condition; Using where |
0.0004201
| Memory Before: 2.3 Mb
| Memory After: 2.3 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1765286527', user_id = '0', location = '/video/219/gipuzkoa-solidarioak-odol-emariren-aldeko-kanpaina-2015', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.221', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.'
WHERE session_hash = 'c3ab4017de7b588b39485b10b4c9dcce'
| 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 index condition |
0.0002952
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 4.98 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, t.total_column, s.l_width, s.c_width, s.r_width
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 | sqlgipsol.s.theme_id | 1 | |
0.0001099
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 3.18 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 | const | style_id_2,style_id | style_id_2 | 2 | const | 1 | |
0.0015121
| Memory Before: 5.49 Mb
| Memory After: 5.5 Mb
| Memory Used: 14.61 kb
| Rows: 1
| Slave: Yes
SELECT video_track.item_id
AS video_is_viewed, f.friend_id
AS is_friend, l.like_id
AS is_liked, v.*, vt.text_parsed
AS text, u.user_name, rate_id
AS has_rated, u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_video
AS v
LEFT JOIN phpfox_video_track
AS video_track
ON(video_track.item_id = v.video_id AND video_track.ip_address = '21673216221')
LEFT JOIN phpfox_friend
AS f
ON(f.user_id = v.user_id AND f.friend_user_id = 0)
LEFT JOIN phpfox_like
AS l
ON(l.type_id = 'video' AND l.item_id = v.video_id AND l.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.video_id = 219
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | vr | system | item_id,item_id_2 | MISSING KEY | | | | Const row not found |
| 1 | SIMPLE | v | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | vt | const | video_id | video_id | 4 | const | 1 | |
| 1 | SIMPLE | video_track | ref | item_id | item_id | 22 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | f | ref | user_check,user_id,top_friend,friend_user_id | friend_user_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | type_id_3|item_id | 81|4 | const,const | 1 (1%) | Using where; Using rowid filter |
0.0003700
| Memory Before: 5.6 Mb
| Memory After: 5.6 Mb
| Memory Used: 3.59 kb
| Rows: 0
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name
FROM phpfox_video_category_data
AS pcd
JOIN phpfox_video_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.video_id = 219
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 | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0003181
| Memory Before: 5.6 Mb
| Memory After: 5.61 Mb
| Memory Used: 3.41 kb
| Rows: 1
| Slave: Yes
SELECT video_url, embed_code
FROM phpfox_video_embed
WHERE video_id = 219
/* 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.0009110
| Memory Before: 5.67 Mb
| Memory After: 5.68 Mb
| Memory Used: 3.8 kb
| Rows: 0
| Slave: Yes
SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox_tag
WHERE item_id = 219 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,category_id_2 | item_id | 81 | const,const | 1 | Using index condition; Using where; Using filesort |
0.0001092
| Memory Before: 5.68 Mb
| Memory After: 5.68 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_video
WHERE in_process = 0 AND view_id = 0 AND item_id = 0 AND user_id = 6
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_video | ref | in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6 | in_process_3 | 10 | const,const,const,const | 650 | Using index |
0.0002921
| Memory Before: 7.12 Mb
| Memory After: 7.13 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002489
| Memory Before: 8.41 Mb
| Memory After: 8.42 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002220
| Memory Before: 8.5 Mb
| Memory After: 8.51 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001650
| Memory Before: 8.65 Mb
| Memory After: 8.66 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0000968
| Memory Before: 8.67 Mb
| Memory After: 8.68 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001931
| Memory Before: 8.68 Mb
| Memory After: 8.68 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001822
| Memory Before: 8.69 Mb
| Memory After: 8.69 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001090
| Memory Before: 8.7 Mb
| Memory After: 8.7 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'breadcrumb.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0000980
| Memory Before: 8.73 Mb
| Memory After: 8.73 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-breadcrumblist.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001390
| Memory Before: 8.74 Mb
| Memory After: 8.74 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-breadcrumbmenu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001719
| Memory Before: 8.74 Mb
| Memory After: 8.74 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0001481
| Memory Before: 8.75 Mb
| Memory After: 8.75 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001791
| Memory Before: 8.75 Mb
| Memory After: 8.76 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0001490
| Memory Before: 8.76 Mb
| Memory After: 8.77 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'video' AND name = 'view.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001330
| Memory Before: 8.92 Mb
| Memory After: 8.93 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'detail.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001471
| Memory Before: 10.75 Mb
| Memory After: 10.76 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'rate' AND name = 'display.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0007210
| Memory Before: 11.09 Mb
| Memory After: 11.1 Mb
| Memory Used: 3.13 kb
| Rows: 0
| Slave: Yes
SELECT action_id
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "video" AND item_id = 219 AND user_id = 0
LIMIT 1
/* 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.0034289
| Memory Before: 11.28 Mb
| Memory After: 11.29 Mb
| Memory Used: 10.14 kb
| Rows: 1
| Slave: Yes
SELECT l.like_id
AS is_liked, c.*, ct.text_parsed
AS text, u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_comment
AS c
LEFT JOIN phpfox_like
AS l
ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
JOIN phpfox_comment_text
AS ct
ON(ct.comment_id = c.comment_id)
JOIN phpfox_user
AS u
ON(u.user_id = c.user_id)
WHERE c.parent_id = 0 AND c.type_id = 'video' AND c.item_id = 219 AND c.view_id = 0
ORDER BY c.time_stamp
DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | c | ref | PRIMARY,user_id,type_id,parent_id,parent_id_2,view_id | type_id | 82 | const,const,const | 2 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|81 | sqlgipsol.c.comment_id | 1 (1%) | Using where; Using rowid filter |
| 1 | SIMPLE | ct | ref | comment_id | comment_id | 4 | sqlgipsol.c.comment_id | 1 | |
| 1 | SIMPLE | u | ref | PRIMARY,user_id | user_id | 4 | sqlgipsol.c.user_id | 1 | |
0.0012991
| Memory Before: 11.66 Mb
| Memory After: 11.67 Mb
| Memory Used: 6.7 kb
| Rows: 0
| Slave: Yes
SELECT l.*, u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like
AS l
JOIN phpfox_user
AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action
AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "video")
WHERE (l.type_id = 'video' OR l.type_id = 'video') AND l.item_id = 219
GROUP BY u.user_id
ORDER BY l.time_stamp
DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | system | type_id,type_id_2,type_id_3,item_id | MISSING KEY | | | | Const row not found; Using temporary; Using filesort |
| 1 | SIMPLE | l | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 | |
0.0005438
| Memory Before: 11.66 Mb
| Memory After: 11.66 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_action
AS a
JOIN phpfox_user
AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "video" AND a.item_id = 219
GROUP BY u.user_id
/* 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.0001159
| Memory Before: 11.67 Mb
| Memory After: 11.67 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001230
| Memory Before: 11.88 Mb
| Memory After: 11.89 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001600
| Memory Before: 11.97 Mb
| Memory After: 11.97 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001221
| Memory Before: 11.91 Mb
| Memory After: 11.91 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0008490
| Memory Before: 11.91 Mb
| Memory After: 11.92 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'comment' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0004821
| Memory Before: 12.09 Mb
| Memory After: 12.1 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'link.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001490
| Memory Before: 12.05 Mb
| Memory After: 12.06 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'captcha' AND name = 'form.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0036399
| Memory Before: 12.48 Mb
| Memory After: 12.48 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_video
AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND (m.title LIKE '%Gipuzkoa%' OR m.title LIKE '%Solidarioak%' OR m.title LIKE '%odol%' OR m.title LIKE '%emariren%' OR m.title LIKE '%aldeko%' OR m.title LIKE '%kanpaina%' OR m.title LIKE '%2015%')
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | in_process,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6 | in_process_4 | 7 | const,const,const,const | 921 | Using where; Using index |
0.0119150
| Memory Before: 12.48 Mb
| Memory After: 12.49 Mb
| Memory Used: 15.75 kb
| Rows: 10
| Slave: Yes
SELECT m.*, u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_video
AS m
JOIN phpfox_user
AS u
ON(u.user_id = m.user_id)
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND (m.title LIKE '%Gipuzkoa%' OR m.title LIKE '%Solidarioak%' OR m.title LIKE '%odol%' OR m.title LIKE '%emariren%' OR m.title LIKE '%aldeko%' OR m.title LIKE '%kanpaina%' OR m.title LIKE '%2015%')
ORDER BY m.time_stamp
DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | range | in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6 | in_process_2 | 7 | | 890 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.m.user_id | 1 | |
0.0001771
| Memory Before: 12.57 Mb
| Memory After: 12.57 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0000999
| Memory Before: 12.57 Mb
| Memory After: 12.58 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'related.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0000861
| Memory Before: 12.58 Mb
| Memory After: 12.58 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'related.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001299
| Memory Before: 12.64 Mb
| Memory After: 12.64 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001750
| Memory Before: 12.64 Mb
| Memory After: 12.65 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001011
| Memory Before: 12.65 Mb
| Memory After: 12.65 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001199
| Memory Before: 12.65 Mb
| Memory After: 12.65 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0000911
| Memory Before: 12.65 Mb
| Memory After: 12.65 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0000920
| Memory Before: 12.65 Mb
| Memory After: 12.65 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0000911
| Memory Before: 12.65 Mb
| Memory After: 12.66 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001130
| Memory Before: 12.65 Mb
| Memory After: 12.66 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001349
| Memory Before: 12.67 Mb
| Memory After: 12.68 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001380
| Memory Before: 12.67 Mb
| Memory After: 12.68 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'video' AND name = 'mini.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001669
| Memory Before: 12.65 Mb
| Memory After: 12.65 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |