SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'cron', 'simpleCache', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'smilies', 'bbCode', 'threadPrefixes', 'trophyUserTitles', 'reportCounts', 'moderationCounts', 'notices', 'userFieldsInfo')Run Time: 0.010492
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 77 | | 20 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('ads', 'adPositions', 'adTypes')Run Time: 0.000521
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 77 | | 3 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000695
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: ecb1f82b3b9a466e87c3e996ca80ab10, a:5:{s:12:"sessionStart";i:1369623337;s:2:"ip";i:1796506068;s:9:"userAgent";s:9:"CCBot/2.0";s:7:"isRobot";b:0;s:16:"previousActivity";i:0;}, 1369626937
Run Time: 0.000485
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date)
Params: 0, 1796506068, 1796506068, EWRporta_ControllerPublic_Portal, Index, valid, , 1369623337
Run Time: 0.000337
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: portal
Run Time: 0.000707
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_layouts | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *, 'disabled' AS position
FROM EWRporta_blocks
WHERE active = 1
ORDER BY block_id ASC
Run Time: 0.001005
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_blocks | index | | PRIMARY | 77 | | 10 | Using where |
SELECT * FROM EWRporta_caches
Run Time: 0.001016
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_caches | ALL | | | | | 3 | |
SELECT * FROM EWRporta_options
Run Time: 0.000838
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_options | ALL | | | | | 32 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: dark_postrating_ratings
Run Time: 0.000577
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT session_activity.*
,
user.*,
user_profile.*,
user_option.*
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (15,17,18,19,20,21,22,23,24,25,26)) as positive_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (16)) as negative_rating_count
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
WHERE (session_activity.view_date > 1369622437)
ORDER BY session_activity.view_date DESC
Run Time: 0.001875
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | session_activity | ALL | view_date | | | | 61 | Using where; Using filesort |
| PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.session_activity.user_id | 1 | |
| PRIMARY | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.user.user_id | 1 | |
| PRIMARY | user_option | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.user.user_id | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | eq_ref | user_id_rating | user_id_rating | 8 | db420879983.user.user_id,const | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | db420879983.user.user_id | 2 | Using where |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1369364137) AND thread.node_id IN ('6', '7', '16', '8', '10', '39')
ORDER BY thread.last_post_date DESC
LIMIT 10Run Time: 0.002089
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | range | node_id_last_post_date,node_id_sticky_last_post_date,last_post_date | last_post_date | 4 | | 7 | Using where |
| SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.thread.node_id | 1 | |
| SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 85 | const,const,db420879983.node.node_id | 1 | |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.thread.user_id | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 6
Run Time: 0.000615
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 85 | const,const,const | 1 | |
SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title,
IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
FROM xf_thread
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE (xf_thread.node_id IN ('6') OR EWRporta_promotes.promote_date < ?)
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY promote_date DESC
LIMIT ?, ?Params: 1369623337, 1369623337, 0, 3
Run Time: 0.059182
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ALL | PRIMARY | | | | 10 | Using temporary; Using filesort |
| SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_last_post_date | node_id_last_post_date | 4 | db420879983.xf_node.node_id | 343 | Using where |
| SIMPLE | EWRporta_promotes | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.xf_thread.thread_id | 1 | Using where |
| SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.xf_thread.user_id | 1 | |
| SIMPLE | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.xf_thread.first_post_id | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (71755)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000847
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 81 | const,const | 1 | Using where |
| SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.attachment.data_id | 1 | |
SELECT COUNT(*) AS total
FROM xf_thread
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE (xf_thread.node_id IN ('6') OR EWRporta_promotes.promote_date < ?)
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?Params: 1369623337, 1369623337
Run Time: 0.016077
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_last_post_date | | | | 6188 | Using where |
| SIMPLE | EWRporta_promotes | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.xf_thread.thread_id | 1 | Using where |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: RecentNews2
Run Time: 0.000730
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_caches | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: RecentNews2
Run Time: 0.000557
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRporta_caches | const | PRIMARY | PRIMARY | 77 | const | 1 | |
begin
Run Time: 0.000430
UPDATE `EWRporta_caches` SET `date` = ? WHERE (block_id = 'RecentNews2')
Params: 1369623337
Run Time: 0.000475
commit
Run Time: 0.003887
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000315
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRcarta_pages | const | page_slug | page_slug | 302 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'EWRblock_RecentSlider', 'EWRblock_SharePage', 'EWRblock_OnlineUsers', 'EWRblock_BoardTotals', 'EWRblock_FaceBook', 'EWRblock_Twitter', 'EWRblock_RecentThreads', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'EWRblock_RecentNews2', 'EWRporta_Portal', 'notice_cookies', 'EWRporta_Navtabs', 'xi_sportsbook_tab_links', 'xfr_useralbums_links', 'xi_stocktrader_tab_links', 'son_prs_tab_links', 'EWRcarta_Navtabs', 'forumwatch_navigation_tabs_forums', 'ThreadStarter', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?Params: 2, 1
Run Time: 0.002597
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 25 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('home', 'wiki')Params: 1
Run Time: 0.000371
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 231 | | 2 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('notice_cookies')Params: 1
Run Time: 0.000399
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 231 | const,const | 1 | |
SELECT *
FROM merc_ad_last_view
ORDER BY view_date ASC
Run Time: 0.000675
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | merc_ad_last_view | system | | | | | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('merc_code_render')
AND style_id = ?
AND language_id = ?Params: 2, 1
Run Time: 0.000526
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT *
FROM xf_notification
ORDER BY notification_id
Run Time: 0.000916
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_notification | index | | PRIMARY | 4 | | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('GritterNotifications')
AND style_id = ?
AND language_id = ?Params: 2, 1
Run Time: 0.000465
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('cta_countdown_main')
AND style_id = ?
AND language_id = ?Params: 2, 1
Run Time: 0.001025
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT post.*, thread.*, user.*
FROM xf_post AS post
LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)
LEFT JOIN xf_user AS user ON (user.user_id = post.user_id)
WHERE NOT ISNULL(thread.thread_id)
AND post.message_state = 'visible'
AND user.is_banned = 0
GROUP BY post.post_id
ORDER BY post.post_date DESC
LIMIT 5Run Time: 2.885498
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | ALL | PRIMARY | | | | 6188 | Using where; Using temporary; Using filesort |
| SIMPLE | post | ref | thread_id_post_date,thread_id_position,user_id | thread_id_position | 4 | db420879983.thread.thread_id | 4 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.post.user_id | 1 | Using where |
SELECT
post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
user.*, IF(user.username IS NULL, post.username, user.username) AS username, session.view_date, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 15) as dark_postrating_15_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 16) as dark_postrating_16_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 17) as dark_postrating_17_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 18) as dark_postrating_18_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 19) as dark_postrating_19_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 20) as dark_postrating_20_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 21) as dark_postrating_21_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 22) as dark_postrating_22_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 23) as dark_postrating_23_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 24) as dark_postrating_24_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 25) as dark_postrating_25_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 26) as dark_postrating_26_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (15,17,18,19,20,21,22,23,24,25,26)) as positive_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (16)) as negative_rating_count
,
pr2.rating
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)LEFT OUTER JOIN xf_session_activity AS session ON post.user_id = session.user_id
LEFT JOIN dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 0)
WHERE post.post_id IN (71765, 71764, 71763, 71762, 71761)
Run Time: 0.004811
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | post | range | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | | 5 | Using where |
| PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.post.user_id | 1 | |
| PRIMARY | session | ALL | PRIMARY | | | | 61 | |
| PRIMARY | pr2 | eq_ref | post_id_user_id,post_id_rating,user_id_rating | post_id_user_id | 8 | db420879983.post.post_id,const | 1 | |
| PRIMARY | thread | eq_ref | PRIMARY | PRIMARY | 4 | db420879983.post.thread_id | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | eq_ref | user_id_rating | user_id_rating | 8 | db420879983.post.user_id,const | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | db420879983.post.user_id | 2 | Using where |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
| DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | db420879983.post.post_id,const | 1 | Using index |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('borbole_recent_posts_sidebar')
AND style_id = ?
AND language_id = ?Params: 2, 1
Run Time: 0.015300
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
INSERT INTO merc_ad_view (ad_id)
VALUES (2)
Run Time: 0.000449
REPLACE INTO merc_ad_last_view
(ad_id, view_date)
VALUES
(2, 1369623337)
Run Time: 0.000653