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', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.000359
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 38 | 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/DataRegistry.php at line 139
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 1899
- XF\App->preLoadData() in src/XF/App.php at line 1887
- XF\App->setup() in src/XF/Pub/App.php at line 93
- XF\Pub\App->setup() in src/XF.php at line 485
- XF::setupApp() in src/XF.php at line 508
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('nfTicketCounts')
Run Time: 0.000079
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | 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 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 139
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 227
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1790
- XF\App->XF\{closure}() in src/XF/Container.php at line 30
- XF\Container->offsetGet() in src/XF/Container.php at line 86
- XF\Container->__get() in src/addons/NF/Tickets/Listener.php at line 55
- NF\Tickets\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2843
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2341
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_nf_tickets_status`.*
FROM `xf_nf_tickets_status`
WHERE (`xf_nf_tickets_status`.`active` = 1) AND (`xf_nf_tickets_status`.`include_in_counts` = 1)
ORDER BY `xf_nf_tickets_status`.`display_order` ASC
Run Time: 0.000082
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_nf_tickets_status | ALL | | | | | 3 | 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 1387
- XF\Mvc\Entity\Finder->fetch() in src/addons/NF/Tickets/Finder/Ticket.php at line 125
- NF\Tickets\Finder\Ticket->isCounted() in src/addons/NF/Tickets/Listener.php at line 63
- NF\Tickets\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2843
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2341
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_nf_tickets_ticket`.*
FROM `xf_nf_tickets_ticket`
WHERE (`xf_nf_tickets_ticket`.`status_id` IN (1))
Run Time: 0.000173
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_nf_tickets_ticket | ALL | | | | | 2938 | 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 1387
- XF\Mvc\Entity\Finder->fetch() in src/addons/NF/Tickets/Listener.php at line 63
- NF\Tickets\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2843
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2341
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_nf_tickets_category`.*
FROM `xf_nf_tickets_category`
WHERE (`xf_nf_tickets_category`.`ticket_category_id` = 5)
LIMIT 1
Run Time: 0.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_nf_tickets_category | const | PRIMARY,parent_category_id_lft | 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 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 396
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 188
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/addons/NF/Tickets/Entity/Ticket.php at line 182
- NF\Tickets\Entity\Ticket->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/NF/Tickets/Listener.php at line 63
- NF\Tickets\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2843
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2341
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, nf_tickets_category, 5
Run Time: 0.000032
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,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/PermissionCache.php at line 83
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/addons/NF/Tickets/XF/Entity/User.php at line 103
- NF\Tickets\XF\Entity\User->hasTicketCategoryPermission() in src/addons/NF/Tickets/Entity/Category.php at line 184
- NF\Tickets\Entity\Category->hasPermission() in src/addons/NF/Tickets/Entity/Category.php at line 111
- NF\Tickets\Entity\Category->canView() in src/addons/NF/Tickets/Entity/Ticket.php at line 182
- NF\Tickets\Entity\Ticket->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/NF/Tickets/Listener.php at line 63
- NF\Tickets\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2843
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2341
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_nf_tickets_category`.*
FROM `xf_nf_tickets_category`
WHERE (`xf_nf_tickets_category`.`ticket_category_id` = 4)
LIMIT 1
Run Time: 0.000055
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_nf_tickets_category | const | PRIMARY,parent_category_id_lft | 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 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 396
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 188
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/addons/NF/Tickets/Entity/Ticket.php at line 182
- NF\Tickets\Entity\Ticket->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/NF/Tickets/Listener.php at line 63
- NF\Tickets\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2843
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2341
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, nf_tickets_category, 4
Run Time: 0.000027
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,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/PermissionCache.php at line 83
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/addons/NF/Tickets/XF/Entity/User.php at line 103
- NF\Tickets\XF\Entity\User->hasTicketCategoryPermission() in src/addons/NF/Tickets/Entity/Category.php at line 184
- NF\Tickets\Entity\Category->hasPermission() in src/addons/NF/Tickets/Entity/Category.php at line 111
- NF\Tickets\Entity\Category->canView() in src/addons/NF/Tickets/Entity/Ticket.php at line 182
- NF\Tickets\Entity\Ticket->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/NF/Tickets/Listener.php at line 63
- NF\Tickets\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2843
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2341
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000034
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/XF/Entity/User.php at line 1178
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 244
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 22
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 125
- 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 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `cf_product`.*, `cf_product_feature_Featured_1`.*, `xf_user_User_2`.*, `cf_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*, `cf_product_update_Description_5`.*, `cf_product_version_CurrentVersion_6`.*
FROM `cf_product`
LEFT JOIN `cf_product_feature` AS `cf_product_feature_Featured_1` ON (`cf_product_feature_Featured_1`.`product_id` = `cf_product`.`product_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `cf_product`.`user_id`)
LEFT JOIN `cf_category` AS `cf_category_Category_3` ON (`cf_category_Category_3`.`product_category_id` = `cf_product`.`product_category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'product_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `cf_category_Category_3`.`product_category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `cf_product_update` AS `cf_product_update_Description_5` ON (`cf_product_update_Description_5`.`product_update_id` = `cf_product`.`description_update_id`)
LEFT JOIN `cf_product_version` AS `cf_product_version_CurrentVersion_6` ON (`cf_product_version_CurrentVersion_6`.`product_version_id` = `cf_product`.`current_version_id`)
WHERE (`cf_product`.`product_id` = '1065')
LIMIT 1
Run Time: 0.000574
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | cf_product | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | cf_product_feature_Featured_1 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_user_User_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | cf_category_Category_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SIMPLE | cf_product_update_Description_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | cf_product_version_CurrentVersion_6 | 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 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/addons/CF/Pub/Controller/ProductItem.php at line 1479
- CF\Pub\Controller\ProductItem->assertViewableProduct() in src/addons/CF/Pub/Controller/ProductItem.php at line 123
- CF\Pub\Controller\ProductItem->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 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `cf_product`.*, `xf_user_User_1`.*, `cf_product_version_CurrentVersion_2`.*, `cf_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `cf_product`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `cf_product`.`user_id`)
LEFT JOIN `cf_product_version` AS `cf_product_version_CurrentVersion_2` ON (`cf_product_version_CurrentVersion_2`.`product_version_id` = `cf_product`.`current_version_id`)
LEFT JOIN `cf_category` AS `cf_category_Category_3` ON (`cf_category_Category_3`.`product_category_id` = `cf_product`.`product_category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'product_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `cf_category_Category_3`.`product_category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`cf_product`.`product_state` = 'visible') AND (`cf_product`.`user_id` = 2564) AND (`cf_product`.`product_id` <> 1065)
ORDER BY `cf_product`.`last_update` DESC
LIMIT 5
Run Time: 0.000538
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | cf_product | ref | PRIMARY,user_id_last_update | user_id_last_update | 4 | const | 332 | Using where |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | cf_product_version_CurrentVersion_2 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.current_version_id | 1 | |
SIMPLE | cf_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | chnkfctry.cf_product.product_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chnkfctry.cf_category_Category_3.product_category_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 1387
- XF\Mvc\Entity\Finder->fetch() in src/addons/CF/Pub/Controller/ProductItem.php at line 157
- CF\Pub\Controller\ProductItem->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 2345
- XF\App->run() in src/XF.php at line 512
- 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, "