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.000180
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 36 | 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 1753
- XF\App->preLoadData() in src/XF/App.php at line 1741
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 363
- XF::setupApp() in src/XF.php at line 386
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000087
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 36
- 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 320
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_rm_resource`.*, `xf_rm_resource_feature_Featured_1`.*, `xf_user_User_2`.*, `xf_rm_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_rm_resource_update_Description_5`.*, `xf_rm_resource_version_CurrentVersion_6`.*, `xf_thread_Discussion_7`.*, `xf_forum_Forum_8`.*, `xf_node_Node_9`.*, `xf_permission_cache_content_Permissions_10`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_rm_resource_feature` AS `xf_rm_resource_feature_Featured_1` ON (`xf_rm_resource_feature_Featured_1`.`resource_id` = `xf_rm_resource`.`resource_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_3` ON (`xf_rm_category_Category_3`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_rm_category_Category_3`.`resource_category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_rm_resource_update` AS `xf_rm_resource_update_Description_5` ON (`xf_rm_resource_update_Description_5`.`resource_update_id` = `xf_rm_resource`.`description_update_id`)
LEFT JOIN `xf_rm_resource_version` AS `xf_rm_resource_version_CurrentVersion_6` ON (`xf_rm_resource_version_CurrentVersion_6`.`resource_version_id` = `xf_rm_resource`.`current_version_id`)
LEFT JOIN `xf_thread` AS `xf_thread_Discussion_7` ON (`xf_thread_Discussion_7`.`thread_id` = `xf_rm_resource`.`discussion_thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_8` ON (`xf_forum_Forum_8`.`node_id` = `xf_thread_Discussion_7`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_9` ON (`xf_node_Node_9`.`node_id` = `xf_forum_Forum_8`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_10` ON (`xf_permission_cache_content_Permissions_10`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_10`.`content_id` = `xf_node_Node_9`.`node_id` AND `xf_permission_cache_content_Permissions_10`.`permission_combination_id` = '1')
WHERE (`xf_rm_resource`.`resource_id` = '325')
LIMIT 1
Run Time: 0.001087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_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 | xf_rm_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 | xf_rm_resource_update_Description_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_version_CurrentVersion_6 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_Discussion_7 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_forum_Forum_8 | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | xf_node_Node_9 | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | xf_permission_cache_content_Permissions_10 | const | PRIMARY | | | | 1 | Impossible ON condition |
- 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/addons/XFRM/Pub/Controller/ResourceItem.php at line 1454
- XFRM\Pub\Controller\ResourceItem->assertViewableResource() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 143
- XFRM\Pub\Controller\ResourceItem->actionView() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_rm_resource`.*, `xf_user_User_1`.*, `xf_rm_resource_version_CurrentVersion_2`.*, `xf_rm_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_version` AS `xf_rm_resource_version_CurrentVersion_2` ON (`xf_rm_resource_version_CurrentVersion_2`.`resource_version_id` = `xf_rm_resource`.`current_version_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_3` ON (`xf_rm_category_Category_3`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_rm_category_Category_3`.`resource_category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_rm_resource`.`resource_state` = 'visible') AND (`xf_rm_resource`.`user_id` = 2676) AND (`xf_rm_resource`.`resource_id` <> 325)
ORDER BY `xf_rm_resource`.`last_update` DESC
LIMIT 5
Run Time: 0.000766
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ref | PRIMARY,user_id_last_update | user_id_last_update | 4 | const | 6 | Using where |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_version_CurrentVersion_2 | eq_ref | PRIMARY | PRIMARY | 4 | xf.xf_rm_resource.current_version_id | 1 | |
SIMPLE | xf_rm_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | xf.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xf.xf_rm_category_Category_3.resource_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/XFRM/Pub/Controller/ResourceItem.php at line 177
- XFRM\Pub\Controller\ResourceItem->actionView() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
INSERT INTO xf_rm_resource_view
(resource_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 325
Run Time: 0.000086
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/addons/XFRM/Repository/ResourceItem.php at line 291
- XFRM\Repository\ResourceItem->logResourceView() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 200
- XFRM\Pub\Controller\ResourceItem->actionView() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- 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, , , XFRM\Pub\Controller\ResourceItem, View, valid, resource_id=325, 1576361893,
Run Time: 0.000112
- 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/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 48
- XenConcept\LoginAsUser\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 343
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('xfrmResourceFields')
Run Time: 0.000966
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 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/DataRegistry.php at line 226
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1644
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 3028
- XF\App->container() in src/addons/XFRM/Entity/ResourceItem.php at line 669
- XFRM\Entity\ResourceItem->getCustomFields() in src/XF/Mvc/Entity/Entity.php at line 148
- 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/s2/public/xfrm_resource_view.php at line 119
- 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 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
LOCK TABLES ncww_adpositions, ncww_ads WRITE
Run Time: 0.000099
- XF\Db\AbstractAdapter->rawQuery() in src/addons/NCWW/Ad/Listener.php at line 14
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT * FROM `ncww_ads` WHERE position =1 AND expires >= CURDATE();
Run Time: 0.000205
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ncww_ads | ALL | | | | | 8 | 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 155
- XF\Db\AbstractAdapter->fetchAll() in src/addons/NCWW/Ad/Listener.php at line 17
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT * FROM `ncww_adpositions` WHERE position =1
Run Time: 0.000118
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ncww_adpositions | 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 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/NCWW/Ad/Listener.php at line 24
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
REPLACE INTO `ncww_ads` (`ad_id`, `title`, `image1`, `image2`, `link1`, `link2`, `position`, `expires`, `displays`, `rate`, `advertiser`, `contact`, `email`, `mailing`, `phone`, `notes`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: 4, GPS Hardwoods (Glen Samuels), https://ncwoodworker.net/forums/index.php?media/gps-new-gif.124494/full, , http://www.gpshardwoods.com/, , 1, 2020-01-15, 6987342, Right Side Tombstone Ad 185x225 - $150/Qtr, GPS Hardwoods, Glen Samuels, gpshardwoods@gmail.com, 7744 Watkins Ford Rd., Kernersville, NC 27284, 352-895-4170,
Run Time: 0.002839
- 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 221
- XF\Db\AbstractAdapter->insert() in src/addons/NCWW/Ad/Listener.php at line 48
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
REPLACE INTO `ncww_adpositions` (`position`, `rotor`) VALUES (?, ?)
Params: 1, 2
Run Time: 0.003002
- 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 221
- XF\Db\AbstractAdapter->insert() in src/addons/NCWW/Ad/Listener.php at line 49
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
UNLOCK TABLES ncww_adpositions, ncww_ads
Run Time: 0.000100
- XF\Db\AbstractAdapter->rawQuery() in src/addons/NCWW/Ad/Listener.php at line 51
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
LOCK TABLES ncww_adpositions, ncww_ads WRITE
Run Time: 0.000088
- XF\Db\AbstractAdapter->rawQuery() in src/addons/NCWW/Ad/Listener.php at line 14
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT * FROM `ncww_ads` WHERE position =1 AND expires >= CURDATE();
Run Time: 0.000254
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ncww_ads | ALL | | | | | 8 | 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 155
- XF\Db\AbstractAdapter->fetchAll() in src/addons/NCWW/Ad/Listener.php at line 17
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT * FROM `ncww_adpositions` WHERE position =1
Run Time: 0.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ncww_adpositions | 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 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/NCWW/Ad/Listener.php at line 24
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
REPLACE INTO `ncww_ads` (`ad_id`, `title`, `image1`, `image2`, `link1`, `link2`, `position`, `expires`, `displays`, `rate`, `advertiser`, `contact`, `email`, `mailing`, `phone`, `notes`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: 6, Steve Wall Lumber Company, https://ncwoodworker.net/forums/index.php?media/steve-wall-jpg.124009/full, , http://www.walllumber.com, , 1, 2020-01-15, 3441208, Right Side Tombstone Ad 185x225 - $150/Qtr, Steve Wall Lumber Co, , , P.O. Box 287 Mayodan, NC 27027, ,
Run Time: 0.002199
- 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 221
- XF\Db\AbstractAdapter->insert() in src/addons/NCWW/Ad/Listener.php at line 48
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
REPLACE INTO `ncww_adpositions` (`position`, `rotor`) VALUES (?, ?)
Params: 1, 0
Run Time: 0.002817
- 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 221
- XF\Db\AbstractAdapter->insert() in src/addons/NCWW/Ad/Listener.php at line 49
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
UNLOCK TABLES ncww_adpositions, ncww_ads
Run Time: 0.000082
- XF\Db\AbstractAdapter->rawQuery() in src/addons/NCWW/Ad/Listener.php at line 51
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_widget_NCWW_tombstone_ad.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/Html.php at line 16
- XF\Widget\Html->render() in internal_data/code_cache/widgets/_19_NCWW_tombstone_ad.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 533
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*
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_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_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_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`node_id` IN (151))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 20
Run Time: 0.000317
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | const | 271 | Using index condition; Using where; Using filesort |
SIMPLE | xf_forum_Forum_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | xf.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | xf.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xf.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/Widget/NewThreads.php at line 69
- XF\Widget\NewThreads->render() in internal_data/code_cache/widgets/_20_Forsale_Sidebar.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- 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 src/XF/Pub/App.php at line 534
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_addon`.*
FROM `xf_addon`
WHERE (`xf_addon`.`addon_id` = 'Tapatalk')
LIMIT 1
Run Time: 0.000090
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 52 | 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/addons/Tapatalk/Listener/Hook.php at line 22
- Tapatalk\Listener\Hook::templateHook()
- call_user_func_array() in src/XF/Extension.php at line 35
- XF\Extension->fire() in src/XF/App.php at line 2648
- XF\App->fire() in src/XF/Template/Templater.php at line 1297
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
LOCK TABLES ncww_adpositions, ncww_ads WRITE
Run Time: 0.000095
- XF\Db\AbstractAdapter->rawQuery() in src/addons/NCWW/Ad/Listener.php at line 14
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_ads.php at line 14
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 644
- XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l1/s2/public/PAGE_CONTAINER.php at line 1011
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT * FROM `ncww_ads` WHERE position =0 AND expires >= CURDATE();
Run Time: 0.000239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ncww_ads | ALL | | | | | 8 | 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 155
- XF\Db\AbstractAdapter->fetchAll() in src/addons/NCWW/Ad/Listener.php at line 17
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_ads.php at line 14
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 644
- XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l1/s2/public/PAGE_CONTAINER.php at line 1011
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT * FROM `ncww_adpositions` WHERE position =0
Run Time: 0.000130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ncww_adpositions | 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 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/NCWW/Ad/Listener.php at line 24
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_ads.php at line 14
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 644
- XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l1/s2/public/PAGE_CONTAINER.php at line 1011
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
REPLACE INTO `ncww_ads` (`ad_id`, `title`, `image1`, `image2`, `link1`, `link2`, `position`, `expires`, `displays`, `rate`, `advertiser`, `contact`, `email`, `mailing`, `phone`, `notes`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: 2, West Penn Hardwoods, /forums/index.php?media/2015-grand-opening-west-penn-banner-png.123409/full, , https://www.wphardwoods.com/, , 0, 2020-01-15, 4027101, Top Banner Ad 750 x 100 - $300 /QTR, West Penn Hardwoods, , , , ,
Run Time: 0.002293
- 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 221
- XF\Db\AbstractAdapter->insert() in src/addons/NCWW/Ad/Listener.php at line 48
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_ads.php at line 14
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 644
- XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l1/s2/public/PAGE_CONTAINER.php at line 1011
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
REPLACE INTO `ncww_adpositions` (`position`, `rotor`) VALUES (?, ?)
Params: 0, 0
Run Time: 0.003175
- 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 221
- XF\Db\AbstractAdapter->insert() in src/addons/NCWW/Ad/Listener.php at line 49
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_ads.php at line 14
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 644
- XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l1/s2/public/PAGE_CONTAINER.php at line 1011
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
UNLOCK TABLES ncww_adpositions, ncww_ads
Run Time: 0.000062
- XF\Db\AbstractAdapter->rawQuery() in src/addons/NCWW/Ad/Listener.php at line 51
- NCWW\Ad\Listener::getAd()
- call_user_func() in src/XF/Template/Templater.php at line 1403
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s2/public/_ads.php at line 14
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 644
- XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l1/s2/public/PAGE_CONTAINER.php at line 1011
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
bytes_sent | 16839 |
bytes_received | 291530 |
packets_sent | 220 |
packets_received | 1456 |
protocol_overhead_in | 5824 |
protocol_overhead_out | 880 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 441 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 1320 |
bytes_received_prepare_response_packet | 85369 |
bytes_received_change_user_packet | 203637 |
packets_sent_command | 109 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 49 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 42 |
packets_received_prepare_response | 1196 |
packets_received_change_user | 133 |
result_set_queries | 26 |
non_result_set_queries | 10 |
no_index_used | 6 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 26 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 33 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 107 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 107 |
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 | 107 |
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 | 186 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 459 |
proto_binary_fetched_int24 | 168 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1376 |
proto_binary_fetched_decimal | 62 |
proto_binary_fetched_float | 6 |
proto_binary_fetched_double | 12 |
proto_binary_fetched_date | 31 |
proto_binary_fetched_year | 8 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 966 |
proto_binary_fetched_blob | 269 |
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 | 8 |
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 | 34 |
com_stmt_execute | 34 |
com_stmt_send_long_data | 0 |
com_stmt_close | 33 |
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 | 201186 |