SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.000373
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 44 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/App.php at line 1766
- XF\App->preLoadData() in src/XF/App.php at line 1754
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 364
- XF::setupApp() in src/XF.php at line 387
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000082
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 349
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '1439')
LIMIT 1
Run Time: 0.000365
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1379
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 12
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 11
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenConcept/RestrictGuestViews/XF/Pub/Controller/Thread.php at line 22
- XenConcept\RestrictGuestViews\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_session_activity_Activity_5`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 1439) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.000979
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 20 | Using index condition; Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | desifak1_xenforodb1.xf_user_User_1.user_id,func | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 35
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 11
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenConcept/RestrictGuestViews/XF/Pub/Controller/Thread.php at line 22
- XenConcept\RestrictGuestViews\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 1439
Run Time: 0.000035
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 193
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 90
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 11
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenConcept/RestrictGuestViews/XF/Pub/Controller/Thread.php at line 22
- XenConcept\RestrictGuestViews\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread_prefix`.*
FROM `xf_thread_prefix`
WHERE (`xf_thread_prefix`.`prefix_id` IN (10, 11, 2, 3, 4, 17, 39, 16, 28, 29, 1, 24, 25, 14, 15, 41))
ORDER BY `xf_thread_prefix`.`materialized_order` ASC
Run Time: 0.000157
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread_prefix | ALL | PRIMARY | | | | 43 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Entity/Forum.php at line 220
- XF\Entity\Forum->getPrefixes() in src/addons/xenMade/SEO/Repository/NoIndex.php at line 35
- xenMade\SEO\Repository\NoIndex->noIndex() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 368
- xenMade\SEO\XF\Pub\Controller\Thread->changeSeoData() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 599
- xenMade\SEO\XF\Pub\Controller\Thread->changeSeoFromRes() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 34
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenConcept/RestrictGuestViews/XF/Pub/Controller/Thread.php at line 22
- XenConcept\RestrictGuestViews\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 67137)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000151
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 427
- xenMade\SEO\XF\Pub\Controller\Thread->changeSeoData() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 599
- xenMade\SEO\XF\Pub\Controller\Thread->changeSeoFromRes() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 34
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenConcept/RestrictGuestViews/XF/Pub/Controller/Thread.php at line 22
- XenConcept\RestrictGuestViews\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_af_as_user_award`.*, `xf_af_as_award_Award_1`.*
FROM `xf_af_as_user_award`
INNER JOIN `xf_af_as_award` AS `xf_af_as_award_Award_1` ON (`xf_af_as_award_Award_1`.`award_id` = `xf_af_as_user_award`.`award_id`)
WHERE (`xf_af_as_user_award`.`user_id` IN (5591, 5591, 155, 1320, 146, 5591, 5591, 5591, 810, 529, 1097, 1097, 8510, 817, 5591, 5591, 1812, 60, 4557, 481)) AND (`xf_af_as_user_award`.`status` = 'approved') AND (`xf_af_as_user_award`.`is_featured` = 1) AND (`xf_af_as_award_Award_1`.`can_feature` = 1)
ORDER BY `xf_af_as_user_award`.`display_order` ASC
Run Time: 0.000236
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_af_as_user_award | range | award_id,user_id,status,is_featured,award_id_status | user_id | 4 | | 13 | Using index condition; Using where; Using filesort |
SIMPLE | xf_af_as_award_Award_1 | eq_ref | PRIMARY,can_feature | PRIMARY | 4 | desifak1_xenforodb1.xf_af_as_user_award.award_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/AddonFlare/AwardSystem/Repository/UserAward.php at line 184
- AddonFlare\AwardSystem\Repository\UserAward->addUserAwardsToContent() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 18
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenConcept/RestrictGuestViews/XF/Pub/Controller/Thread.php at line 22
- XenConcept\RestrictGuestViews\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
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, , , XF\Pub\Controller\Thread, Index, valid, thread_id=1439, 1614309554, ccbot
Run Time: 0.000051
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 5591) AND (`xf_session_activity`.`unique_key` = '5591')
LIMIT 1
Run Time: 0.000060
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 300
- XF\Entity\User->getLastActivity() in src/XF/Mvc/Entity/Entity.php at line 148
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 467
- XF\Entity\User->canViewOnlineStatus() in src/XF/Entity/User.php at line 228
- XF\Entity\User->isOnline()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 14
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 12
Run Time: 0.000054
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 98
- CMTV\Badges\Repository\UserBadge->getAllowedFeaturedBadges() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 75
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 5591) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000325
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 5591) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000407
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 15
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 98
- CMTV\Badges\Repository\UserBadge->getAllowedFeaturedBadges() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 75
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 155) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000337
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 1320) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000330
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 146) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000324
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 5591) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000325
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 5591) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000325
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 5591) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000311
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 810) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000262
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 529) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000255
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 1097) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000269
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 1097) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000255
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 8510) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000253
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 817) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000250
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 5591) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000247
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 5591) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000252
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 1812) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000253
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 60) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000272
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 45
Run Time: 0.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 98
- CMTV\Badges\Repository\UserBadge->getAllowedFeaturedBadges() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 75
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 4557) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000321
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_cmtv_badges_user_badge`.*, `xf_cmtv_badges_badge_Badge_1`.*
FROM `xf_cmtv_badges_user_badge`
LEFT JOIN `xf_cmtv_badges_badge` AS `xf_cmtv_badges_badge_Badge_1` ON (`xf_cmtv_badges_badge_Badge_1`.`badge_id` = `xf_cmtv_badges_user_badge`.`badge_id`)
LEFT JOIN `xf_cmtv_badges_badge_category` AS `xf_cmtv_badges_badge_category_Category_2` ON (`xf_cmtv_badges_badge_category_Category_2`.`badge_category_id` = `xf_cmtv_badges_badge_Badge_1`.`badge_category_id`)
WHERE (`xf_cmtv_badges_user_badge`.`user_id` = 481) AND (`xf_cmtv_badges_user_badge`.`featured` = 1)
ORDER BY `xf_cmtv_badges_badge_category_Category_2`.`display_order` ASC, `xf_cmtv_badges_badge_Badge_1`.`display_order` ASC
LIMIT 4
Run Time: 0.000291
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cmtv_badges_user_badge | ALL | | | | | 63 | Using where; Using temporary; Using filesort |
SIMPLE | xf_cmtv_badges_badge_Badge_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_user_badge.badge_id | 1 | |
SIMPLE | xf_cmtv_badges_badge_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_cmtv_badges_badge_Badge_1.badge_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/CMTV/Badges/Repository/UserBadge.php at line 93
- CMTV\Badges\Repository\UserBadge->getFeaturedUserBadges() in src/addons/CMTV/Badges/XF/Entity/User.php at line 79
- CMTV\Badges\XF\Entity\User->getFeaturedBadges()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s1/public/CMTV_Badges_featured_badges_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/message_macros.php at line 83
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/post_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 569
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT search_index.content_type, search_index.content_id
FROM xf_search_index AS search_index
WHERE MATCH(search_index.title, search_index.message, search_index.metadata) AGAINST ('Malayalam Actress Rare -_md_thread_1439 +_md_node_13 -_md_hidden_1' IN BOOLEAN MODE) AND search_index.content_type = 'thread'
ORDER BY search_index.item_date DESC
LIMIT 200
Run Time: 0.189810
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | search_index | fulltext | PRIMARY,title_message_metadata | title_message_metadata | 0 | | 1 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 160
- XF\Db\AbstractAdapter->fetchAllNum() in src/XF/Search/Source/MySqlFt.php at line 291
- XF\Search\Source\MySqlFt->search() in src/XF/Search/Search.php at line 175
- XF\Search\Search->search() in src/XF/Repository/Search.php at line 34
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 30
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_17_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 713
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (2757, 2756, 2755, 2754, 2753, 2751, 2750, 2749, 2748, 2745, 2741, 2740, 2739, 2736, 2735, 2732, 2729, 2728, 2727, 2724, 2723, 2722, 2721, 2719, 2718, 2717, 2716, 2714, 2713, 2711, 2710, 2708, 2706, 2705, 2701, 2700, 2699, 2697, 2696, 2692, 2690, 2688, 2687, 2684, 2683, 2682, 2680, 2679, 2678, 2677, 2674, 2672, 2671, 2668, 2667, 2666, 2664, 2663, 2661, 2658, 2655, 2653, 2647, 2644, 2640, 2639, 2635, 2634, 2633, 2632, 2631, 2630, 2629, 2627, 2625, 2624, 2622, 2618, 2617, 2615, 2614, 2613, 2608, 2607, 2606, 2604, 2599, 2597, 2595, 2591, 2590, 2584, 2579, 2576, 2575, 2574, 2573, 2572, 2571, 2570, 2556, 2553, 2552, 2549, 2543, 2534, 2531, 2530, 2514, 2513, 2503, 2499, 2498, 2497, 2496, 2491, 2490, 2489, 2488, 2487, 2486, 2484, 2482, 2479, 2470, 2469, 2466, 2464, 2463, 2462, 2461, 2459, 2453, 2451, 2447, 2444, 2437, 2435, 2433, 2432, 2431, 2426, 2422, 2420, 2411, 2388, 2386, 2385, 2368, 2366, 2365, 2364, 2362, 2359, 2358, 2357, 2356, 2354, 2352, 2347, 2346, 2345, 2344, 2340, 2337, 2336, 2333, 2332, 2331, 2327, 2313, 2312, 2309, 2297, 2295, 2294, 2293, 2290, 2288, 2287, 2283, 2282, 2280, 2278, 2277, 2275, 2273, 2272, 2271, 2270, 2269, 2264, 2263, 2262, 2260, 2259, 2252, 2254, 2250, 2249))
Run Time: 0.002241
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,desifak1_xenforodb1.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2556
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 227
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 177
- XF\Search\Search->search() in src/XF/Repository/Search.php at line 34
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 30
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_17_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 713
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
BEGIN
Run Time: 0.000020
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 381
- XF\Db\AbstractAdapter->beginTransaction() in src/XF/Mvc/Entity/Entity.php at line 1188
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/Search.php at line 41
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 30
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_17_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 713
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
INSERT INTO `xf_search` (`search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `warnings`, `query_hash`, `user_id`, `result_count`, `search_results`, `search_id`, `user_results`, `search_date`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: thread, | Malayalam | Actress | Rare, [], date, 0, [], d978215a2f5b0519f220342ea43c7e6f, 0, 200, {"thread-2757":["thread",2757],"thread-2756":["thread",2756],"thread-2755":["thread",2755],"thread-2754":["thread",2754],"thread-2753":["thread",2753],"thread-2751":["thread",2751],"thread-2750":["thread",2750],"thread-2749":["thread",2749],"thread-2748":["thread",2748],"thread-2745":["thread",2745],"thread-2741":["thread",2741],"thread-2740":["thread",2740],"thread-2739":["thread",2739],"thread-2736":["thread",2736],"thread-2735":["thread",2735],"thread-2732":["thread",2732],"thread-2729":["thread",2729],"thread-2728":["thread",2728],"thread-2727":["thread",2727],"thread-2724":["thread",2724],"thread-2723":["thread",2723],"thread-2722":["thread",2722],"thread-2721":["thread",2721],"thread-2719":["thread",2719],"thread-2718":["thread",2718],"thread-2717":["thread",2717],"thread-2716":["thread",2716],"thread-2714":["thread",2714],"thread-2713":["thread",2713],"thread-2711":["thread",2711],"thread-2710":["thread",2710],"thread-2708":["thread",2708],"thread-2706":["thread",2706],"thread-2705":["thread",2705],"thread-2701":["thread",2701],"thread-2700":["thread",2700],"thread-2699":["thread",2699],"thread-2697":["thread",2697],"thread-2696":["thread",2696],"thread-2692":["thread",2692],"thread-2690":["thread",2690],"thread-2688":["thread",2688],"thread-2687":["thread",2687],"thread-2684":["thread",2684],"thread-2683":["thread",2683],"thread-2682":["thread",2682],"thread-2680":["thread",2680],"thread-2679":["thread",2679],"thread-2678":["thread",2678],"thread-2677":["thread",2677],"thread-2674":["thread",2674],"thread-2672":["thread",2672],"thread-2671":["thread",2671],"thread-2668":["thread",2668],"thread-2667":["thread",2667],"thread-2666":["thread",2666],"thread-2664":["thread",2664],"thread-2663":["thread",2663],"thread-2661":["thread",2661],"thread-2658":["thread",2658],"thread-2655":["thread",2655],"thread-2653":["thread",2653],"thread-2647":["thread",2647],"thread-2644":["thread",2644],"thread-2640":["thread",2640],"thread-2639":["thread",2639],"thread-2635":["thread",2635],"thread-2634":["thread",2634],"thread-2633":["thread",2633],"thread-2632":["thread",2632],"thread-2631":["thread",2631],"thread-2630":["thread",2630],"thread-2629":["thread",2629],"thread-2627":["thread",2627],"thread-2625":["thread",2625],"thread-2624":["thread",2624],"thread-2622":["thread",2622],"thread-2618":["thread",2618],"thread-2617":["thread",2617],"thread-2615":["thread",2615],"thread-2614":["thread",2614],"thread-2613":["thread",2613],"thread-2608":["thread",2608],"thread-2607":["thread",2607],"thread-2606":["thread",2606],"thread-2604":["thread",2604],"thread-2599":["thread",2599],"thread-2597":["thread",2597],"thread-2595":["thread",2595],"thread-2591":["thread",2591],"thread-2590":["thread",2590],"thread-2584":["thread",2584],"thread-2579":["thread",2579],"thread-2576":["thread",2576],"thread-2575":["thread",2575],"thread-2574":["thread",2574],"thread-2573":["thread",2573],"thread-2572":["thread",2572],"thread-2571":["thread",2571],"thread-2570":["thread",2570],"thread-2556":["thread",2556],"thread-2553":["thread",2553],"thread-2552":["thread",2552],"thread-2549":["thread",2549],"thread-2543":["thread",2543],"thread-2534":["thread",2534],"thread-2531":["thread",2531],"thread-2530":["thread",2530],"thread-2514":["thread",2514],"thread-2513":["thread",2513],"thread-2503":["thread",2503],"thread-2499":["thread",2499],"thread-2498":["thread",2498],"thread-2497":["thread",2497],"thread-2496":["thread",2496],"thread-2491":["thread",2491],"thread-2490":["thread",2490],"thread-2489":["thread",2489],"thread-2488":["thread",2488],"thread-2487":["thread",2487],"thread-2486":["thread",2486],"thread-2484":["thread",2484],"thread-2482":["thread",2482],"thread-2479":["thread",2479],"thread-2470":["thread",2470],"thread-2469":["thread",2469],"thread-2466":["thread",2466],"thread-2464":["thread",2464],"thread-2463":["thread",2463],"thread-2462":["thread",2462],"thread-2461":["thread",2461],"thread-2459":["thread",2459],"thread-2453":["thread",2453],"thread-2451":["thread",2451],"thread-2447":["thread",2447],"thread-2444":["thread",2444],"thread-2437":["thread",2437],"thread-2435":["thread",2435],"thread-2433":["thread",2433],"thread-2432":["thread",2432],"thread-2431":["thread",2431],"thread-2426":["thread",2426],"thread-2422":["thread",2422],"thread-2420":["thread",2420],"thread-2411":["thread",2411],"thread-2388":["thread",2388],"thread-2386":["thread",2386],"thread-2385":["thread",2385],"thread-2368":["thread",2368],"thread-2366":["thread",2366],"thread-2365":["thread",2365],"thread-2364":["thread",2364],"thread-2362":["thread",2362],"thread-2359":["thread",2359],"thread-2358":["thread",2358],"thread-2357":["thread",2357],"thread-2356":["thread",2356],"thread-2354":["thread",2354],"thread-2352":["thread",2352],"thread-2347":["thread",2347],"thread-2346":["thread",2346],"thread-2345":["thread",2345],"thread-2344":["thread",2344],"thread-2340":["thread",2340],"thread-2337":["thread",2337],"thread-2336":["thread",2336],"thread-2333":["thread",2333],"thread-2332":["thread",2332],"thread-2331":["thread",2331],"thread-2327":["thread",2327],"thread-2313":["thread",2313],"thread-2312":["thread",2312],"thread-2309":["thread",2309],"thread-2297":["thread",2297],"thread-2295":["thread",2295],"thread-2294":["thread",2294],"thread-2293":["thread",2293],"thread-2290":["thread",2290],"thread-2288":["thread",2288],"thread-2287":["thread",2287],"thread-2283":["thread",2283],"thread-2282":["thread",2282],"thread-2280":["thread",2280],"thread-2278":["thread",2278],"thread-2277":["thread",2277],"thread-2275":["thread",2275],"thread-2273":["thread",2273],"thread-2272":["thread",2272],"thread-2271":["thread",2271],"thread-2270":["thread",2270],"thread-2269":["thread",2269],"thread-2264":["thread",2264],"thread-2263":["thread",2263],"thread-2262":["thread",2262],"thread-2260":["thread",2260],"thread-2259":["thread",2259],"thread-2252":["thread",2252],"thread-2254":["thread",2254],"thread-2250":["thread",2250],"thread-2249":["thread",2249]}, , [], 1614309554
Run Time: 0.000125
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1463
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1195
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/Search.php at line 41
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 30
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_17_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 713
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
COMMIT
Run Time: 0.001385
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 403
- XF\Db\AbstractAdapter->commit() in src/XF/Mvc/Entity/Entity.php at line 1239
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/Search.php at line 41
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 30
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_17_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 713
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (2757, 2756, 2755, 2754, 2753, 2751, 2750, 2749, 2748, 2745, 2741, 2740, 2739, 2736, 2735, 2732, 2729, 2728, 2727, 2724, 2723, 2722, 2721, 2719, 2718, 2717, 2716, 2714, 2713, 2711, 2710, 2708, 2706, 2705, 2701, 2700, 2699, 2697, 2696, 2692, 2690, 2688, 2687, 2684, 2683, 2682, 2680, 2679, 2678, 2677, 2674, 2672, 2671, 2668, 2667, 2666, 2664, 2663, 2661, 2658, 2655, 2653, 2647, 2644, 2640, 2639, 2635, 2634, 2633, 2632, 2631, 2630, 2629, 2627, 2625, 2624, 2622, 2618, 2617, 2615, 2614, 2613, 2608, 2607, 2606, 2604, 2599, 2597, 2595, 2591, 2590, 2584, 2579, 2576, 2575, 2574, 2573, 2572, 2571, 2570, 2556, 2553, 2552, 2549, 2543, 2534, 2531, 2530, 2514, 2513, 2503, 2499, 2498, 2497, 2496, 2491, 2490, 2489, 2488, 2487, 2486, 2484, 2482, 2479, 2470, 2469, 2466, 2464, 2463, 2462, 2461, 2459, 2453, 2451, 2447, 2444, 2437, 2435, 2433, 2432, 2431, 2426, 2422, 2420, 2411, 2388, 2386, 2385, 2368, 2366, 2365, 2364, 2362, 2359, 2358, 2357, 2356, 2354, 2352, 2347, 2346, 2345, 2344, 2340, 2337, 2336, 2333, 2332, 2331, 2327, 2313, 2312, 2309, 2297, 2295, 2294, 2293, 2290, 2288, 2287, 2283, 2282, 2280, 2278, 2277, 2275, 2273, 2272, 2271, 2270, 2269, 2264, 2263, 2262, 2260, 2259, 2252, 2254, 2250, 2249))
Run Time: 0.002122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | desifak1_xenforodb1.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,desifak1_xenforodb1.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2556
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 227
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
- XF\ResultSet->limitResults() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 28
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 30
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_17_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 713
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 19747)
LIMIT 1
Run Time: 0.000117
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s1/public/thread_list_macros.php at line 337
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/widget_similar_threads.php at line 75
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 713
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 8404)
LIMIT 1
Run Time: 0.000105
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s1/public/thread_list_macros.php at line 337
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s1/public/widget_similar_threads.php at line 75
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/thread_view.php at line 713
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2191
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20