SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000583
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_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, 316127585, 316127585, EWRporta_ControllerPublic_Portal, Index, valid, , 1610746981
Run Time: 0.003069
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: portal
Run Time: 0.000491
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.000486
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_blocks | index | | PRIMARY | 77 | | 8 | Using where |
SELECT * FROM EWRporta_caches
Run Time: 0.000386
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | ALL | | | | | 7 | |
SELECT * FROM EWRporta_options
Run Time: 0.000423
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_options | ALL | | | | | 16 | |
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 ('49') 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: 1610746981, 1610746981, 0, 5
Run Time: 10.056161
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | PRIMARY | | | | 32 | Using temporary; Using filesort |
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_last_post_date | node_id_sticky_last_post_date | 4 | smsmast_xenforo.xf_node.node_id | 14516 | Using where |
SIMPLE | EWRporta_promotes | eq_ref | PRIMARY | PRIMARY | 4 | smsmast_xenforo.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | smsmast_xenforo.xf_thread.user_id | 1 | |
SIMPLE | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | smsmast_xenforo.xf_thread.first_post_id | 1 | |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 863032
Run Time: 0.000467
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | smsmast_xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 863031
Run Time: 0.000357
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | smsmast_xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 863030
Run Time: 0.000341
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | smsmast_xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 863029
Run Time: 0.000315
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | smsmast_xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 863028
Run Time: 0.000409
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | smsmast_xenforo.EWRporta_categories.category_id,const | 1 | Using index |
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 ('49') 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: 1610746981, 1610746981
Run Time: 2.034455
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 | | | | 812905 | Using where |
SIMPLE | EWRporta_promotes | eq_ref | PRIMARY | PRIMARY | 4 | smsmast_xenforo.xf_thread.thread_id | 1 | Using where |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: RecentNews
Run Time: 0.000429
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: RecentNews
Run Time: 0.000262
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.000093
UPDATE `EWRporta_caches` SET `results` = ?, `date` = ? WHERE (block_id = 'RecentNews')
Params: a:2:{s:6:"option";a:9:{s:5:"forum";a:1:{i:0;s:2:"49";}s:8:"leftdate";s:1:"1";s:5:"limit";s:1:"5";s:7:"pagenav";s:1:"1";s:6:"social";s:1:"0";s:6:"sticky";s:1:"0";s:8:"truncate";s:4:"1000";s:7:"parseBB";b:1;s:5:"count";i:239;}s:10:"RecentNews";a:5:{i:0;a:57:{s:9:"thread_id";i:863032;s:7:"node_id";i:49;s:5:"title";s:41:"HP Envy x360 Review: Ryzen powered 2-in-1";s:11:"reply_count";i:0;s:10:"view_count";i:1;s:7:"user_id";i:13036;s:8:"username";s:16:"Golden Retriever";s:9:"post_date";i:1610738544;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:0;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:1077854;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1610738544;s:12:"last_post_id";i:1077854;s:17:"last_post_user_id";i:13036;s:18:"last_post_username";s:16:"Golden Retriever";s:9:"prefix_id";i:0;s:5:"email";s:20:"smsmasters@gmail.com";s:6:"gender";s:0:"";s:12:"custom_title";s:0:"";s:11:"language_id";i:1;s:8:"style_id";i:0;s:8:"timezone";s:13:"Europe/London";s:7:"visible";i:0;s:13:"user_group_id";i:2;s:19:"secondary_group_ids";s:0:"";s:22:"display_style_group_id";i:2;s:25:"permission_combination_id";i:2;s:13:"message_count";i:798198;s:20:"conversations_unread";i:9;s:13:"register_date";i:1159635780;s:13:"last_activity";i:1439283108;s:13:"trophy_points";i:38;s:13:"alerts_unread";i:0;s:11:"avatar_date";i:0;s:12:"avatar_width";i:0;s:13:"avatar_height";i:0;s:8:"gravatar";s:0:"";s:10:"user_state";s:5:"valid";s:12:"is_moderator";i:0;s:8:"is_admin";i:0;s:9:"is_banned";i:0;s:10:"like_count";i:7;s:14:"warning_points";i:0;s:8:"eucookie";i:0;s:7:"message";s:564:"The HP Envy x360 is an affordable and versatile all-rounder that looks superb, has solid build quality and smooth movement, and it's barely heavier or thicker than more expensive and conventional laptops.
[URL='https://www.techspot.com/review/2179-hp-envy-x360/'][IMG]https://static.techspot.com/images/rss/rss_buttons_01.png[/IMG][/URL][URL='https://www.techspot.com/review/2179-hp-envy-x360/#comments'][IMG]https://static.techspot.com/images/rss/rss_buttons_02.png[/IMG][/URL]
[url="https://www.techspot.com/review/2179-hp-envy-x360/"]Continue reading...[/url]";s:12:"attach_count";i:0;s:10:"node_title";s:14:"Home Page News";s:12:"promote_date";i:1610738544;s:12:"promote_icon";N;s:12:"promote_data";s:76:"https://static.techspot.com/articles-info/2179/images/2021-01-06-image-4.jpg";s:10:"categories";a:0:{}s:3:"day";s:2:"15";s:5:"month";O:14:"XenForo_Phrase":4:{s:14:"