SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000272
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000117
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: 323da08418818b81a1768cc9f9ed798c, a:6:{s:12:"sessionStart";i:1653539964;s:2:"ip";s:4:"Ͱ'";s:11:"sessionCsrf";s:16:"dwWgK9o6wAtB6mCG";s:9:"userAgent";s:40:"CCBot/2.0 (https://commoncrawl.org/faq/)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;}, 1653543564
Run Time: 0.000146
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
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),
robot_key = VALUES(robot_key)
Params: 0, Ͱ', Ͱ', EWRporta_ControllerPublic_Portal, Index, valid, , 1653539964,
Run Time: 0.000105
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: portal
Run Time: 0.000190
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.000176
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.000170
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | ALL | | | | | 3 | |
SELECT * FROM EWRporta_options
Run Time: 0.000146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_options | ALL | | | | | 17 | |
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 ('20') 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: 1653539964, 1653539964, 0, 15
Run Time: 1.453794
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | PRIMARY | | | | 103 | Using temporary; Using filesort |
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | xen.xf_node.node_id | 431 | Using where |
SIMPLE | EWRporta_promotes | eq_ref | PRIMARY | PRIMARY | 4 | xen.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | xen.xf_thread.first_post_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 ('20') 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: 1653539964, 1653539964
Run Time: 0.046537
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post | | | | 44876 | Using where |
SIMPLE | EWRporta_promotes | eq_ref | PRIMARY | PRIMARY | 4 | xen.xf_thread.thread_id | 1 | Using where |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: RecentNews
Run Time: 0.000245
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.000135
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.000143
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:"20";}s:8:"leftdate";s:1:"1";s:5:"limit";s:2:"15";s:7:"pagenav";s:1:"0";s:6:"social";s:1:"1";s:6:"sticky";s:1:"0";s:8:"truncate";s:4:"1000";s:7:"parseBB";b:1;s:5:"count";i:19249;}s:10:"RecentNews";a:15:{i:0;a:61:{s:9:"thread_id";i:56887;s:7:"node_id";i:20;s:5:"title";s:37:"All-new 2nd Gen 2023 Kia Niro Preview";s:11:"reply_count";i:9;s:10:"view_count";i:776;s:7:"user_id";i:3;s:8:"username";s:4:"xcel";s:9:"post_date";i:1651034510;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:443431;s:16:"first_post_likes";i:3;s:14:"last_post_date";i:1652213812;s:12:"last_post_id";i:443566;s:17:"last_post_user_id";i:763;s:18:"last_post_username";s:10:"WriConsult";s:9:"prefix_id";i:0;s:4:"tags";s:258:"a:4:{i:21085;a:2:{s:3:"tag";s:4:"2023";s:7:"tag_url";s:4:"2023";}i:933;a:2:{s:3:"tag";s:12:"cleanmpg.com";s:7:"tag_url";s:11:"cleanmpgcom";}i:6936;a:2:{s:3:"tag";s:3:"kia";s:7:"tag_url";s:3:"kia";}i:16039;a:2:{s:3:"tag";s:4:"niro";s:7:"tag_url";s:4:"niro";}}";s:5:"email";s:22:"WayneGerdes1@gmail.com";s:6:"gender";s:0:"";s:12:"custom_title";s:32:"PZEV, there's nothing like it :)";s:11:"language_id";i:1;s:8:"style_id";i:0;s:8:"timezone";s:15:"America/Chicago";s:7:"visible";i:1;s:16:"activity_visible";i:1;s:13:"user_group_id";i:3;s:19:"secondary_group_ids";s:7:"9,10,11";s:22:"display_style_group_id";i:3;s:25:"permission_combination_id";i:52;s:13:"message_count";i:53390;s:20:"conversations_unread";i:0;s:13:"register_date";i:1139332920;s:13:"last_activity";i:1653525698;s:13:"trophy_points";i:36;s:13:"alerts_unread";i:0;s:11:"avatar_date";i:1449454782;s:12:"avatar_width";i:80;s:13:"avatar_height";i:40;s:8:"gravatar";s:0:"";s:10:"user_state";s:5:"valid";s:12:"is_moderator";i:1;s:8:"is_admin";i:1;s:9:"is_banned";i:0;s:10:"like_count";i:6410;s:14:"warning_points";i:0;s:8:"is_staff";i:1;s:22:"xengallery_media_count";i:5716;s:22:"xengallery_album_count";i:0;s:22:"xengallery_media_quota";i:943861;s:7:"message";s:1002:"[URL='https://www.cleanmpg.com/community/index.php?threads/56887/']The second-gen Niro will arrive as a larger and more efficient compact CUV with the very latest infotainment and safety features.[/URL]
Wayne Gerdes – [URL='http://cleanmpg.com']CleanMPG[/URL] – April 13, 2022
[CENTER][B]2023 Kia Niro PHEV-33[/B]
[IMG]https://www.cleanmpg.com/community/index.php?media/35711/full[/IMG][/CENTER]
The all-new second gen 2023 Kia Niro CUV made its debut at the New York International Auto Show. And unlike the first gen - it took a while for the 2018 PHEV and 2019 BEV to be introduced after the 2017 Niro HEV was, the 2023 Niro will launch with the HEV, PHEV, and all-electric BEV available nationwide at launch this fall.
[B]2023 Kia Niro Exterior Design[/B]
The 2023 Niro exterior offers the same drag coefficient as its predecessor at 0.29. New is a reflective strip along the entire top of the front fascia just below the hood edge, angular undercutting DRLs with projector headlamps to...";s:12:"attach_count";i:0;s:10:"node_title";s:11:"In the News";s:12:"promote_date";i:1651034510;s:12:"promote_icon";N;s:12:"promote_data";s:54:"http://www.cleanmpg.com/photos/data/2/AmericanFlag.jpg";s:3:"day";s:2:"27";s:5:"month";O:14:"XenForo_Phrase":4:{s:14:"