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.003511
| 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.000330
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT article.*
,
user.*, user_profile.*, IF(user.username IS NULL, article.username, user.username) AS username,
0 AS is_watched,
0 AS has_rated
FROM xf_nflj_ams_article AS article
LEFT JOIN xf_user AS user ON
(user.user_id = article.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = article.user_id)
WHERE article.article_id = ?
Params: 11
Run Time: 0.001053
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | article | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT category.*
,
permission.cache_value AS category_permission_cache
FROM xf_nflj_ams_category AS category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'ams_category'
AND permission.content_id = category.category_id)
WHERE category.category_id = ?
Params: 3
Run Time: 0.000687
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
UPDATE `xf_nflj_ams_article` SET `cover_image_id` = ? WHERE (article_id = 11)
Params: 0
Run Time: 0.000433
UPDATE `xf_nflj_ams_article` SET `cover_image_cache` = ? WHERE (article_id = 11)
Params: a:0:{}
Run Time: 0.000288
SELECT *
FROM xf_liked_content
WHERE content_type = ?
AND content_id = ?
AND like_user_id = ?
Params: ams_article, 11, 0
Run Time: 0.000493
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | | | | | | | | no matching row in const table |
SELECT comment.*
,
user.*, user_profile.*, 0 AS like_date
FROM xf_nflj_ams_comment AS comment
INNER JOIN xf_user AS user ON
(user.user_id = comment.user_id)
INNER JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = comment.user_id)
WHERE (comment.article_id = 11) AND (comment.comment_state IN ('visible'))
ORDER BY comment.likes DESC, comment.comment_date DESC
LIMIT 10Run Time: 0.000959
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | comment | ALL | user_id | | | | 1 | Using where; Using filesort |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | pigforum_com.comment.user_id | 1 | |
| SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | pigforum_com.comment.user_id | 1 | |
SELECT COUNT(*)
FROM xf_nflj_ams_comment AS comment
WHERE (comment.article_id = 11) AND (comment.comment_state IN ('visible'))Run Time: 0.000351
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | comment | ALL | | | | | 1 | Using where |
SELECT thread.*
,
node.title AS node_title, node.node_name,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT 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.thread_id = ?
Params: 1116
Run Time: 0.000506
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
INSERT INTO xf_nflj_ams_article_view
(article_id)
VALUES
(?)
Params: 11
Run Time: 0.003723
SELECT article.*
,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, article.username, user.username) AS username,
permission.cache_value AS category_permission_cache
FROM xf_nflj_ams_article AS article
LEFT JOIN xf_nflj_ams_category AS category ON
(category.category_id = article.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = article.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = article.user_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'ams_category'
AND permission.content_id = article.category_id)
WHERE (article.category_id = 3) AND (article.article_id <> 11) AND (article.article_state = 'visible')
ORDER BY article.publish_date DESC
LIMIT 5
Run Time: 0.001663
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | article | index | PRIMARY,category_id,category_last_update,category_rating_weighted,category_author_rating,category_id_publish_date | publish_date | 4 | | 7 | Using where |
| SIMPLE | category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | pigforum_com.article.user_id | 1 | |
| SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | pigforum_com.article.user_id | 1 | |
| SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | Using where |
SELECT article.*
,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, article.username, user.username) AS username,
permission.cache_value AS category_permission_cache
FROM xf_nflj_ams_article AS article
LEFT JOIN xf_nflj_ams_category AS category ON
(category.category_id = article.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = article.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = article.user_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'ams_category'
AND permission.content_id = article.category_id)
WHERE (article.user_id = 156) AND (article.article_id <> 11) AND (article.article_state = 'visible')
ORDER BY article.rating_avg DESC, article.last_update
LIMIT 5
Run Time: 0.004238
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | article | range | PRIMARY,user_id,user_id_last_update,user_id_publish_date | user_id | 8 | | 28 | Using index condition; Using where; Using temporary; Using filesort |
| SIMPLE | category | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (Block Nested Loop) |
| SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,pigforum_com.article.category_id | 1 | Using where |
SELECT distinct(tag_content.tag_id)
FROM xf_tag_content as tag_content
INNER JOIN xf_tag AS tag
ON (tag.tag_id = tag_content.tag_id AND tag.use_count >= ?)
WHERE tag_content.content_type = 'ams_article'
AND tag_content.visible = 1
ORDER BY tag.use_count DESC
LIMIT 25
Params: 1
Run Time: 0.000575
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | tag_content | ref | content_type_id_tag,tag_id_content_date | content_type_id_tag | 27 | const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| SIMPLE | tag | eq_ref | PRIMARY,use_count | PRIMARY | 4 | pigforum_com.tag_content.tag_id | 1 | Using where; Distinct |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: simpleCache, a:13:{s:26:"waindigo_lastXmlUploadDate";i:1494034790;s:18:"showcaseStatsCache";a:8:{s:10:"categories";s:0:"";s:17:"system_categories";i:2;s:5:"items";i:1;s:5:"views";s:3:"543";s:8:"comments";s:1:"0";s:12:"user_reviews";s:1:"0";s:6:"images";s:1:"1";s:14:"lastUpdateDate";i:1611550962;}s:22:"showcaseTopBlocksCache";a:4:{s:15:"topContributors";a:1:{i:0;a:39:{s:7:"user_id";i:1;s:8:"username";s:2:"PF";s:5:"email";s:24:"
[email protected]";s:6:"gender";s:0:"";s:12:"custom_title";s:0:"";s:11:"language_id";i:1;s:8:"style_id";i:5;s:8:"timezone";s:15:"America/Chicago";s:7:"visible";i:1;s:16:"activity_visible";i:1;s:13:"user_group_id";i:2;s:19:"secondary_group_ids";s:3:"3,4";s:22:"display_style_group_id";i:3;s:25:"permission_combination_id";i:14;s:13:"message_count";i:269;s:20:"conversations_unread";i:0;s:13:"register_date";i:1375997280;s:13:"last_activity";i:1581431615;s:13:"trophy_points";i:16;s:13:"alerts_unread";i:0;s:11:"avatar_date";i:1512221572;s:12:"avatar_width";i:192;s:13:"avatar_height";i:341;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:0;s:14:"warning_points";i:0;s:8:"is_staff";i:1;s:14:"showcase_count";i:1;s:22:"xengallery_media_count";i:0;s:22:"xengallery_album_count";i:0;s:22:"xengallery_media_quota";i:0;s:17:"ams_article_count";i:7;s:16:"ams_series_count";i:0;s:21:"cta_ft_featured_count";i:1;s:5:"count";i:1;}}s:13:"topCommenters";a:0:{}s:16:"topUserReviewers";a:0:{}s:14:"lastUpdateDate";i:1611550962;}s:11:"scTagsCache";a:2:{s:8:"tagCloud";a:7:{i:37;a:6:{s:6:"tag_id";i:37;s:3:"tag";s:3:"4-h";s:7:"tag_url";s:3:"4-h";s:9:"use_count";i:1;s:13:"last_use_date";i:1494279443;s:9:"permanent";i:0;}i:34;a:6:{s:6:"tag_id";i:34;s:3:"tag";s:5:"berks";s:7:"tag_url";s:5:"berks";s:9:"use_count";i:1;s:13:"last_use_date";i:1494279443;s:9:"permanent";i:0;}i:32;a:6:{s:6:"tag_id";i:32;s:3:"tag";s:23:"carpenterfamilyshowpigs";s:7:"tag_url";s:23:"carpenterfamilyshowpigs";s:9:"use_count";i:1;s:13:"last_use_date";i:1494279443;s:9:"permanent";i:0;}i:36;a:6:{s:6:"tag_id";i:36;s:3:"tag";s:10:"crossbreds";s:7:"tag_url";s:10:"crossbreds";s:9:"use_count";i:1;s:13:"last_use_date";i:1494279443;s:9:"permanent";i:0;}i:38;a:6:{s:6:"tag_id";i:38;s:3:"tag";s:7:"indiana";s:7:"tag_url";s:7:"indiana";s:9:"use_count";i:1;s:13:"last_use_date";i:1494279443;s:9:"permanent";i:0;}i:35;a:6:{s:6:"tag_id";i:35;s:3:"tag";s:5:"spots";s:7:"tag_url";s:5:"spots";s:9:"use_count";i:1;s:13:"last_use_date";i:1494279443;s:9:"permanent";i:0;}i:33;a:6:{s:6:"tag_id";i:33;s:3:"tag";s:5:"yorks";s:7:"tag_url";s:5:"yorks";s:9:"use_count";i:1;s:13:"last_use_date";i:1494279443;s:9:"permanent";i:0;}}s:14:"lastUpdateDate";i:1611545876;}s:23:"amsFeaturedAuthorsCache";a:2:{s:15:"featuredAuthors";a:0:{}s:14:"lastUpdateDate";i:1611550962;}s:26:"xengalleryRandomMediaCache";a:12:{i:0;i:7;i:1;i:8;i:2;i:9;i:3;i:10;i:4;i:11;i:5;i:1;i:6;i:2;i:7;i:3;i:8;i:4;i:9;i:5;i:18;i:6;i:34;i:12;}s:25:"xengalleryStatisticsCache";a:6:{s:14:"category_count";i:17;s:11:"album_count";i:5;s:12:"upload_count";i:13;s:11:"embed_count";i:0;s:13:"comment_count";i:1;s:10:"disk_usage";s:8:"13491481";}s:13:"amsStatsCache";a:7:{s:10:"categories";s:0:"";s:8:"articles";i:77;s:5:"views";s:6:"203735";s:8:"comments";s:1:"0";s:12:"user_reviews";s:1:"0";s:6:"images";s:2:"76";s:14:"lastUpdateDate";i:1611550962;}s:17:"amsTopBlocksCache";a:4:{s:15:"topContributors";a:6:{i:156;a:8:{s:7:"user_id";i:156;s:8:"username";s:7:"uvengwa";s:11:"avatar_date";i:0;s:12:"avatar_width";i:0;s:13:"avatar_height";i:0;s:8:"gravatar";s:0:"";s:6:"gender";s:0:"";s:17:"ams_article_count";i:29;}i:253;a:8:{s:7:"user_id";i:253;s:8:"username";s:7:"GPS1504";s:11:"avatar_date";i:0;s:12:"avatar_width";i:0;s:13:"avatar_height";i:0;s:8:"gravatar";s:0:"";s:6:"gender";s:0:"";s:17:"ams_article_count";i:26;}i:254;a:8:{s:7:"user_id";i:254;s:8:"username";s:14:"CathleenVought";s:11:"avatar_date";i:0;s:12:"avatar_width";i:0;s:13:"avatar_height";i:0;s:8:"gravatar";s:0:"";s:6:"gender";s:0:"";s:17:"ams_article_count";i:12;}i:1;a:8:{s:7:"user_id";i:1;s:8:"username";s:2:"PF";s:11:"avatar_date";i:1512221572;s:12:"avatar_width";i:192;s:13:"avatar_height";i:341;s:8:"gravatar";s:0:"";s:6:"gender";s:0:"";s:17:"ams_article_count";i:7;}i:158;a:8:{s:7:"user_id";i:158;s:8:"username";s:8:"broussey";s:11:"avatar_date";i:0;s:12:"avatar_width";i:0;s:13:"avatar_height";i:0;s:8:"gravatar";s:0:"";s:6:"gender";s:0:"";s:17:"ams_article_count";i:2;}i:860;a:8:{s:7:"user_id";i:860;s:8:"username";s:7:"MELISSA";s:11:"avatar_date";i:0;s:12:"avatar_width";i:0;s:13:"avatar_height";i:0;s:8:"gravatar";s:0:"";s:6:"gender";s:6:"female";s:17:"ams_article_count";i:1;}}s:13:"topCommenters";a:0:{}s:16:"topUserReviewers";a:0:{}s:14:"lastUpdateDate";i:1611550962;}s:7:"widgets";a:13:{i:16;a:9:{s:9:"widget_id";i:16;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Empty";s:8:"position";s:10:"forum_list";s:13:"display_order";i:10;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:17;a:9:{s:9:"widget_id";i:17;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Empty";s:8:"position";s:14:"member_notable";s:13:"display_order";i:10;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:18;a:9:{s:9:"widget_id";i:18;s:5:"title";s:0:"";s:5:"class";s:38:"WidgetFramework_WidgetRenderer_Threads";s:8:"position";s:47:"hook:cta_featuredthreads_featured_custom_bottom";s:13:"display_order";i:10;s:6:"active";i:1;s:7:"options";a:18:{s:4:"type";s:14:"latest_replies";s:6:"cutoff";i:15;s:6:"forums";a:0:{}s:6:"sticky";s:0:"";s:8:"prefixes";a:0:{}s:9:"open_only";i:0;s:8:"as_guest";i:0;s:6:"is_new";i:0;s:5:"limit";i:9;s:6:"layout";s:0:"";s:9:"tab_group";s:0:"";s:13:"cache_seconds";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:1:{s:47:"hook:cta_featuredthreads_featured_custom_bottom";a:2:{i:0;s:28:"cta_featuredthreads_featured";i:1;s:42:"cta_featuredthreads_featured_custom_bottom";}}s:14:"widget_page_id";i:0;}i:19;a:9:{s:9:"widget_id";i:19;s:5:"title";s:0:"";s:5:"class";s:42:"WidgetFramework_WidgetRenderer_OnlineStaff";s:8:"position";s:10:"forum_list";s:13:"display_order";i:20;s:6:"active";i:1;s:7:"options";a:7:{s:9:"tab_group";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:1;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:20;a:9:{s:9:"widget_id";i:20;s:5:"title";s:0:"";s:5:"class";s:40:"WidgetFramework_WidgetRenderer_UsersFind";s:8:"position";s:14:"member_notable";s:13:"display_order";i:20;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:21;a:9:{s:9:"widget_id";i:21;s:5:"title";s:0:"";s:5:"class";s:42:"WidgetFramework_WidgetRenderer_OnlineUsers";s:8:"position";s:60:"forum_list, hook:cta_featuredthreads_featured_custom_sidebar";s:13:"display_order";i:30;s:6:"active";i:1;s:7:"options";a:9:{s:14:"hide_following";i:0;s:4:"rich";i:0;s:9:"tab_group";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:1;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:1:{s:48:"hook:cta_featuredthreads_featured_custom_sidebar";a:2:{i:0;s:28:"cta_featuredthreads_featured";i:1;s:43:"cta_featuredthreads_featured_custom_sidebar";}}s:14:"widget_page_id";i:0;}i:22;a:9:{s:9:"widget_id";i:22;s:5:"title";s:0:"";s:5:"class";s:43:"WidgetFramework_WidgetRenderer_ProfilePosts";s:8:"position";s:10:"forum_list";s:13:"display_order";i:30;s:6:"active";i:0;s:7:"options";a:1:{s:16:"show_update_form";s:1:"1";}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:23;a:9:{s:9:"widget_id";i:23;s:5:"title";s:0:"";s:5:"class";s:39:"WidgetFramework_WidgetRenderer_Birthday";s:8:"position";s:14:"member_notable";s:13:"display_order";i:30;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:24;a:9:{s:9:"widget_id";i:24;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Stats";s:8:"position";s:10:"forum_list";s:13:"display_order";i:40;s:6:"active";i:1;s:7:"options";a:7:{s:9:"tab_group";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:1;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:25;a:9:{s:9:"widget_id";i:25;s:5:"title";s:0:"";s:5:"class";s:41:"WidgetFramework_WidgetRenderer_UsersStaff";s:8:"position";s:14:"member_notable";s:13:"display_order";i:40;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:26;a:9:{s:9:"widget_id";i:26;s:5:"title";s:0:"";s:5:"class";s:44:"WidgetFramework_WidgetRenderer_ShareThisPage";s:8:"position";s:10:"forum_list";s:13:"display_order";i:50;s:6:"active";i:0;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:27;a:9:{s:9:"widget_id";i:27;s:5:"title";s:0:"";s:5:"class";s:47:"WidgetFramework_WidgetRenderer_FacebookFacepile";s:8:"position";s:14:"member_notable";s:13:"display_order";i:50;s:6:"active";i:0;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:28;a:9:{s:9:"widget_id";i:28;s:5:"title";s:0:"";s:5:"class";s:38:"WidgetFramework_WidgetRenderer_Threads";s:8:"position";s:35:"forum_list, forum_view, thread_view";s:13:"display_order";i:50;s:6:"active";i:1;s:7:"options";a:18:{s:4:"type";s:14:"latest_replies";s:6:"cutoff";i:10;s:6:"forums";a:0:{}s:6:"sticky";s:0:"";s:8:"prefixes";a:0:{}s:9:"open_only";i:0;s:8:"as_guest";i:0;s:6:"is_new";i:0;s:5:"limit";i:9;s:6:"layout";s:0:"";s:9:"tab_group";s:0:"";s:13:"cache_seconds";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:1;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}}s:17:"invalidated_cache";a:28:{i:6;i:1494258684;i:5;i:1494258690;i:12;i:1500908435;i:1;i:1500908435;i:11;i:1494269724;i:3;i:1500908435;i:4;i:1500908435;i:13;i:1497903491;i:9;i:1500908435;i:2;i:1500908435;i:14;i:1500908435;i:15;i:1500908435;i:7;i:1500908435;i:8;i:1500908435;i:10;i:1500908435;i:16;i:1500908435;i:17;i:1500908435;i:18;i:1592959401;i:19;i:1500908800;i:20;i:1500908435;i:21;i:1500908435;i:22;i:1500908435;i:23;i:1611458570;i:24;i:1500908435;i:25;i:1500908435;i:26;i:1500908435;i:27;i:1500908435;i:28;i:1592959401;}s:12:"amsTagsCache";a:2:{s:8:"tagCloud";a:0:{}s:14:"lastUpdateDate";i:1611556187;}s:16:"userUpgradeCount";i:2;}
Run Time: 0.003816
SELECT category.*
,
permission.cache_value AS category_permission_cache
FROM xf_nflj_ams_category AS category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'ams_category'
AND permission.content_id = category.category_id)
ORDER BY category.lft
Run Time: 0.000613
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | category | ALL | | | | | 1 | Using filesort |
| SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,pigforum_com.category.category_id | 1 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 98c2c78928c0e4bcab1bbfcdf086980a, , 1611559787
Run Time: 0.002804
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, , , NFLJ_AMS_ControllerPublic_Article, View, valid, article_id=11, 1611556187,
Run Time: 0.007125