SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000235
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/addons/ThemeHouse/Monetize/XF/PermissionSet.php at line 27
- ThemeHouse\Monetize\XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT feedback.*,
ratedinfo.fb_total AS rated_fb_total, feedback.foruserid AS rated_user_id, rateduser.username AS rated_username,
raterinfo.fb_total AS rater_fb_total, feedback.fromuserid AS rater_user_id, rateruser.username AS rater_username
FROM xf_xc_feedback_feedback AS feedback
LEFT JOIN xf_xc_feedback_user AS ratedinfo ON ratedinfo.user_id=feedback.foruserid
LEFT JOIN xf_xc_feedback_user AS raterinfo ON raterinfo.user_id=feedback.fromuserid
LEFT JOIN xf_user AS rateduser ON rateduser.user_id=feedback.foruserid
LEFT JOIN xf_user AS rateruser ON rateruser.user_id=feedback.fromuserid
WHERE feedback.fb_id = ?
Params: 74135
Run Time: 0.000611
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | feedback | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | ratedinfo | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | raterinfo | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | rateduser | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | rateruser | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/XenCentral/Feedback/Repository/Feedback.php at line 83
- XenCentral\Feedback\Repository\Feedback->getFeedbackById() in src/addons/XenCentral/Feedback/Pub/Controller/Feedback.php at line 35
- XenCentral\Feedback\Pub\Controller\Feedback->actionView() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_th_pageopt_image_formats_THPageOptImageFormats_1`.*
FROM `xf_user`
LEFT JOIN `xf_th_pageopt_image_formats` AS `xf_th_pageopt_image_formats_THPageOptImageFormats_1` ON (`xf_th_pageopt_image_formats_THPageOptImageFormats_1`.`content_id` = `xf_user`.`user_id` AND `xf_th_pageopt_image_formats_THPageOptImageFormats_1`.`content_type` = 'user')
WHERE (`xf_user`.`user_id` = 103912)
LIMIT 1
Run Time: 0.000876
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_th_pageopt_image_formats_THPageOptImageFormats_1 | ALL | | | | | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/addons/XenCentral/Feedback/Pub/Controller/Feedback.php at line 43
- XenCentral\Feedback\Pub\Controller\Feedback->actionView() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_xc_feedback_comment`.*, `xf_user_User_1`.*
FROM `xf_xc_feedback_comment`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xc_feedback_comment`.`user_id`)
WHERE (`xf_xc_feedback_comment`.`fb_id` = '74135')
ORDER BY `xf_xc_feedback_comment`.`dateline` ASC
Run Time: 0.000915
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xc_feedback_comment | ref | fb_id | fb_id | 4 | const | 1 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_xc_feedback_comment.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/addons/XenCentral/Feedback/Repository/Comment.php at line 36
- XenCentral\Feedback\Repository\Comment->getAllComments() in src/addons/XenCentral/Feedback/Pub/Controller/Feedback.php at line 47
- XenCentral\Feedback\Pub\Controller\Feedback->actionView() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_xc_feedback_user`.*, `xf_user_User_1`.*
FROM `xf_xc_feedback_user`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xc_feedback_user`.`user_id`)
WHERE (`xf_xc_feedback_user`.`user_id` = '103912')
Run Time: 0.000662
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xc_feedback_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/addons/XenCentral/Feedback/Repository/User.php at line 30
- XenCentral\Feedback\Repository\User->getUserById() in src/addons/XenCentral/Feedback/Pub/Controller/Feedback.php at line 52
- XenCentral\Feedback\Pub\Controller\Feedback->actionView() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT feedback.*,
ratedinfo.fb_total AS rated_fb_total, feedback.foruserid AS rated_user_id, rateduser.username AS rated_username,
raterinfo.fb_total AS rater_fb_total, feedback.fromuserid AS rater_user_id, rateruser.username AS rater_username
FROM xf_xc_feedback_feedback AS feedback
LEFT JOIN xf_xc_feedback_user AS ratedinfo ON ratedinfo.user_id=feedback.foruserid
LEFT JOIN xf_xc_feedback_user AS raterinfo ON raterinfo.user_id=feedback.fromuserid
LEFT JOIN xf_user AS rateduser ON rateduser.user_id=feedback.foruserid
LEFT JOIN xf_user AS rateruser ON rateruser.user_id=feedback.fromuserid
ORDER BY feedback.dateline DESC
LIMIT 10
Run Time: 0.039890
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | feedback | ALL | | | | | 46168 | Using filesort |
SIMPLE | ratedinfo | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.feedback.foruserid | 1 | |
SIMPLE | raterinfo | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.feedback.fromuserid | 1 | |
SIMPLE | rateduser | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.feedback.foruserid | 1 | |
SIMPLE | rateruser | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.feedback.fromuserid | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 157
- XF\Db\AbstractAdapter->fetchAll() in src/addons/XenCentral/Feedback/Repository/Feedback.php at line 289
- XenCentral\Feedback\Repository\Feedback->getLatestFeedback() in src/addons/XenCentral/Feedback/Pub/Controller/FeedbackAbstractController.php at line 146
- XenCentral\Feedback\Pub\Controller\Feedback->getSidebar() in src/addons/XenCentral/Feedback/Pub/Controller/Feedback.php at line 54
- XenCentral\Feedback\Pub\Controller\Feedback->actionView() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_xc_feedback_user`.*, `xf_user_User_1`.*
FROM `xf_xc_feedback_user`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xc_feedback_user`.`user_id`)
WHERE (`xf_xc_feedback_user`.`fb_positivetotal` > 0)
ORDER BY `xf_xc_feedback_user`.`fb_total` DESC
LIMIT 10
Run Time: 0.005421
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xc_feedback_user | ALL | | | | | 10305 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_xc_feedback_user.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/addons/XenCentral/Feedback/Repository/User.php at line 72
- XenCentral\Feedback\Repository\User->getTopTraders() in src/addons/XenCentral/Feedback/Pub/Controller/FeedbackAbstractController.php at line 153
- XenCentral\Feedback\Pub\Controller\Feedback->getSidebar() in src/addons/XenCentral/Feedback/Pub/Controller/Feedback.php at line 54
- XenCentral\Feedback\Pub\Controller\Feedback->actionView() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0,
Run Time: 0.000360
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: , XenCentral\Feedback\Pub\Controller\Feedback, View, valid, fb_id=74135, 1715310723, , 0,
Run Time: 0.000601
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_xc_feedback_activity`.*
FROM `xf_xc_feedback_activity`
WHERE (`xf_xc_feedback_activity`.`log_hash` = '\'53c9d313c152498f7f6d8b450de26c8')
LIMIT 1
Run Time: 0.000270
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xc_feedback_activity | const | PRIMARY | PRIMARY | 130 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Entity.php at line 817
- XF\Mvc\Entity\Entity->_verifyUniqueValue() in src/XF/Mvc/Entity/Entity.php at line 673
- XF\Mvc\Entity\Entity->set() in src/addons/XenCentral/Feedback/Repository/Activity.php at line 53
- XenCentral\Feedback\Repository\Activity->save() in src/addons/XenCentral/Feedback/Listener.php at line 231
- XenCentral\Feedback\Listener::postview() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Mvc/Controller.php at line 362
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
BEGIN
Run Time: 0.000208
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 383
- XF\Db\AbstractAdapter->beginTransaction() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/addons/XenCentral/Feedback/Repository/Activity.php at line 58
- XenCentral\Feedback\Repository\Activity->save() in src/addons/XenCentral/Feedback/Listener.php at line 231
- XenCentral\Feedback\Listener::postview() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Mvc/Controller.php at line 362
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
INSERT INTO `xf_xc_feedback_activity` (`user_id`, `log_hash`, `phrase`, `args`, `link`, `state`, `dateline`) VALUES (?, ?, ?, ?, ?, ?, ?)
Params: 0, '53c9d313c152498f7f6d8b450de26c8, xcfs_logactivity_viewing_feedback, a:1:{s:8:"username";s:5:"JS624";}, /shooting/feedback/feedback/74135/view, public, 1715310723
Run Time: 0.000227
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/addons/XenCentral/Feedback/Repository/Activity.php at line 58
- XenCentral\Feedback\Repository\Activity->save() in src/addons/XenCentral/Feedback/Listener.php at line 231
- XenCentral\Feedback\Listener::postview() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Mvc/Controller.php at line 362
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
COMMIT
Run Time: 0.000489
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 405
- XF\Db\AbstractAdapter->commit() in src/XF/Mvc/Entity/Entity.php at line 1297
- XF\Mvc\Entity\Entity->save() in src/addons/XenCentral/Feedback/Repository/Activity.php at line 58
- XenCentral\Feedback\Repository\Activity->save() in src/addons/XenCentral/Feedback/Listener.php at line 231
- XenCentral\Feedback\Listener::postview() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Mvc/Controller.php at line 362
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_th_xlink_platform_link`.*
FROM `xf_th_xlink_platform_link`
WHERE (`xf_th_xlink_platform_link`.`platform_id` IN (4))
Run Time: 0.000197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_th_xlink_platform_link | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/addons/ThemeHouse/XLink/Navigation/RemoteNavigation.php at line 122
- ThemeHouse\XLink\Navigation\RemoteNavigation::loadPlatformLinks() in src/addons/ThemeHouse/XLink/Navigation/RemoteNavigation.php at line 79
- ThemeHouse\XLink\Navigation\RemoteNavigation::displayPlatformExtended() in /usr/share/nginx/sites/production/xf_code_cache/navigation_cache.php at line 108
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_audfeeds_feed`.*
FROM `xf_audfeeds_feed`
WHERE (`xf_audfeeds_feed`.`active` = 1)
ORDER BY `xf_audfeeds_feed`.`display_order` ASC
Run Time: 0.000369
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_feed | ALL | active | | | | 14 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Repository/Feed.php at line 207
- Audentio\Feeds\Repository\Feed->getFeedsForList() in src/addons/Audentio/Feeds/Listener/Pub/TemplaterTemplatePreRender.php at line 26
- Audentio\Feeds\Listener\Pub\TemplaterTemplatePreRender::audfeedsTabBar() in src/XF/Extension.php at line 64
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Template/Templater.php at line 1613
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1683
- XF\Template\Templater->includeTemplate() in /usr/share/nginx/sites/production/xf_code_cache/templates/l1/s15/public/PAGE_CONTAINER.php at line 3504
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, node
Run Time: 0.000625
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 32 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/PermissionCache.php at line 112
- XF\PermissionCache->cacheAllContentPerms() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 83
- Audentio\Feeds\Feed\ThreadFeed->canView() in src/addons/Audentio/Feeds/Entity/Feed.php at line 274
- Audentio\Feeds\Entity\Feed->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 328
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 329
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/Audentio/Feeds/Repository/Feed.php at line 208
- Audentio\Feeds\Repository\Feed->getFeedsForList() in src/addons/Audentio/Feeds/Listener/Pub/TemplaterTemplatePreRender.php at line 26
- Audentio\Feeds\Listener\Pub\TemplaterTemplatePreRender::audfeedsTabBar() in src/XF/Extension.php at line 64
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Template/Templater.php at line 1613
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1683
- XF\Template\Templater->includeTemplate() in /usr/share/nginx/sites/production/xf_code_cache/templates/l1/s15/public/PAGE_CONTAINER.php at line 3504
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, audfeed_thread_feed
Run Time: 0.000156
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 4 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/PermissionCache.php at line 112
- XF\PermissionCache->cacheAllContentPerms() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 84
- Audentio\Feeds\Feed\ThreadFeed->canView() in src/addons/Audentio/Feeds/Entity/Feed.php at line 274
- Audentio\Feeds\Entity\Feed->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 328
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 329
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/Audentio/Feeds/Repository/Feed.php at line 208
- Audentio\Feeds\Repository\Feed->getFeedsForList() in src/addons/Audentio/Feeds/Listener/Pub/TemplaterTemplatePreRender.php at line 26
- Audentio\Feeds\Listener\Pub\TemplaterTemplatePreRender::audfeedsTabBar() in src/XF/Extension.php at line 64
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Template/Templater.php at line 1613
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1683
- XF\Template\Templater->includeTemplate() in /usr/share/nginx/sites/production/xf_code_cache/templates/l1/s15/public/PAGE_CONTAINER.php at line 3504
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_audfeeds_thread_feed`.*, `xf_audfeeds_thread_feed_watch_Watch_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_audfeeds_thread_feed`
LEFT JOIN `xf_audfeeds_thread_feed_watch` AS `xf_audfeeds_thread_feed_watch_Watch_1` ON (`xf_audfeeds_thread_feed_watch_Watch_1`.`thread_feed_id` = `xf_audfeeds_thread_feed`.`thread_feed_id` AND `xf_audfeeds_thread_feed_watch_Watch_1`.`user_id` = '0')
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'audfeed_thread_feed' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_audfeeds_thread_feed`.`thread_feed_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
Run Time: 0.000309
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_thread_feed | ALL | | | | | 4 | |
SIMPLE | xf_audfeeds_thread_feed_watch_Watch_1 | eq_ref | PRIMARY | PRIMARY | 8 | const,production_xf.xf_audfeeds_thread_feed.thread_feed_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.xf_audfeeds_thread_feed.thread_feed_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 99
- Audentio\Feeds\Feed\ThreadFeed->getThreadFeed() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 85
- Audentio\Feeds\Feed\ThreadFeed->canView() in src/addons/Audentio/Feeds/Entity/Feed.php at line 274
- Audentio\Feeds\Entity\Feed->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 328
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 329
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/Audentio/Feeds/Repository/Feed.php at line 208
- Audentio\Feeds\Repository\Feed->getFeedsForList() in src/addons/Audentio/Feeds/Listener/Pub/TemplaterTemplatePreRender.php at line 26
- Audentio\Feeds\Listener\Pub\TemplaterTemplatePreRender::audfeedsTabBar() in src/XF/Extension.php at line 64
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Template/Templater.php at line 1613
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1683
- XF\Template\Templater->includeTemplate() in /usr/share/nginx/sites/production/xf_code_cache/templates/l1/s15/public/PAGE_CONTAINER.php at line 3504
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
bytes_sent | 11596 |
bytes_received | 146426 |
packets_sent | 188 |
packets_received | 1277 |
protocol_overhead_in | 5108 |
protocol_overhead_out | 752 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 612 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 247 |
bytes_received_prepare_response_packet | 75590 |
bytes_received_change_user_packet | 69225 |
packets_sent_command | 93 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 68 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 34 |
packets_received_prepare_response | 1014 |
packets_received_change_user | 129 |
result_set_queries | 28 |
non_result_set_queries | 6 |
no_index_used | 5 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 28 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 29 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 101 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 101 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 101 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 88 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 143 |
proto_binary_fetched_int24 | 65 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 640 |
proto_binary_fetched_decimal | 40 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 50 |
proto_binary_fetched_date | 0 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 457 |
proto_binary_fetched_blob | 85 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 4 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 30 |
com_stmt_execute | 30 |
com_stmt_send_long_data | 0 |
com_stmt_close | 29 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 67674 |