SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000215
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: bcc25812756c21ff36f7252bf6a7a174, , 1696155553
Run Time: 0.002655
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, , , ForumCube_Psychopath_ControllerPublic_Test, Index, valid, , 1696151953,
Run Time: 0.000177
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('fc_test', 'fc_psychopath_test_tab', 'fc_bookshelf_tab', 'fc_donationLink')
Params: 1
Run Time: 0.000096
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 4 | Using where |
SELECT resource_category.*
,
permission.cache_value AS category_permission_cache
FROM xf_resource_category AS resource_category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'resource_category'
AND permission.content_id = resource_category.resource_category_id)
ORDER BY resource_category.lft
Run Time: 0.000307
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource_category | ALL | | | | | 3 | Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,psychopa_vanilla.resource_category.resource_category_id | 1 | Using where |
SELECT resource.*
,
category.*, category.last_update AS category_last_update, resource.last_update,
resource_update.message AS description,
user.*, user_profile.*, IF(user.username IS NULL, resource.username, user.username) AS username
FROM xf_resource AS resource
LEFT JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
LEFT JOIN xf_resource_update AS resource_update ON
(resource_update.resource_update_id = resource.description_update_id)
LEFT JOIN xf_user AS user ON
(user.user_id = resource.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = resource.user_id)
WHERE (resource.resource_category_id IN (1, 2, 3)) AND (resource.resource_state IN ('visible'))
ORDER BY resource.fb DESC
LIMIT 4
Run Time: 0.000829
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 148 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.resource_category_id | 1 | Using where |
SIMPLE | resource_update | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.description_update_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | psychopa_vanilla.resource.user_id | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc__1_fc_test_form, a:1:{s:15:"fc_test_form_35";a:3:{s:4:"html";s:3073:"<div class="avatarList">
<ul>
<li class="resource-341 resource-category-2">
<a href="articles/5-things-sociopaths-and-narcissists-say-to-make-you-feel-crazy.341/" class="avatar NoOverlay">
<img src="data/resource_icons_thumnail/0/341.jpg?1446469140" class="resourceIcon" style="float:left;" width="48" height="48" />
</a>
<div style="overflow:hidden;">
<a href="articles/5-things-sociopaths-and-narcissists-say-to-make-you-feel-crazy.341/">5 Things Sociopaths and Narcissists Say to Make You Feel Crazy</a>
<div style="margin-top:3px;margin-bottom:23px;"><span class="a2a_img a2a_i_facebook" style="display:inline-block;float:left !important;"></span><span class="a2a_count" style="display:inline-block;">43,922</span></div>
</div>
</li>
<li class="resource-212 resource-category-2">
<a href="articles/30-red-flags-of-manipulative-people.212/" class="avatar NoOverlay">
<img src="data/resource_icons_thumnail/0/212.jpg?1366297800" class="resourceIcon" style="float:left;" width="48" height="48" />
</a>
<div style="overflow:hidden;">
<a href="articles/30-red-flags-of-manipulative-people.212/">30 Red Flags of Manipulative People</a>
<div style="margin-top:3px;margin-bottom:23px;"><span class="a2a_img a2a_i_facebook" style="display:inline-block;float:left !important;"></span><span class="a2a_count" style="display:inline-block;">30,563</span></div>
</div>
</li>
<li class="resource-270 resource-category-3">
<a href="articles/why-does-it-take-so-long-to-get-over-a-relationship-with-a-psychopath.270/" class="avatar NoOverlay">
<img src="data/resource_icons_thumnail/0/270.jpg?1377097380" class="resourceIcon" style="float:left;" width="48" height="48" />
</a>
<div style="overflow:hidden;">
<a href="articles/why-does-it-take-so-long-to-get-over-a-relationship-with-a-psychopath.270/">Why Does it Take So Long to Get Over a Relationship with a Psychopath?</a>
<div style="margin-top:3px;margin-bottom:23px;"><span class="a2a_img a2a_i_facebook" style="display:inline-block;float:left !important;"></span><span class="a2a_count" style="display:inline-block;">23,275</span></div>
</div>
</li>
<li class="resource-300 resource-category-2">
<a href="articles/7-signs-of-hypocrites-the-people-they-target.300/" class="avatar NoOverlay">
<img src="data/resource_icons_thumnail/0/300.jpg?1391001000" class="resourceIcon" style="float:left;" width="48" height="48" />
</a>
<div style="overflow:hidden;">
<a href="articles/7-signs-of-hypocrites-the-people-they-target.300/">7 Signs of Hypocrites & The People They Target</a>
<div style="margin-top:3px;margin-bottom:23px;"><span class="a2a_img a2a_i_facebook" style="display:inline-block;float:left !important;"></span><span class="a2a_count" style="display:inline-block;">23,152</span></div>
</div>
</li>
</ul>
</div>";s:4:"time";i:1696151953;s:9:"extraData";a:1:{s:17:"requiredExternals";a:1:{s:3:"css";a:1:{i:0;s:10:"wf_default";}}}}}
Run Time: 0.000771