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.000668
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 1759
- XF\App->preLoadData() in src/XF/App.php at line 1747
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 364
- XF::setupApp() in src/XF.php at line 387
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/addons/SV/ModeratorEssentials/XF/Entity/User.php at line 29
- SV\ModeratorEssentials\XF\Entity\User->canViewModeratorPanel() in src/addons/SV/ModeratorEssentials/XF/Entity/User.php at line 52
- SV\ModeratorEssentials\XF\Entity\User->canViewModeratorLogCounts() in src/addons/SV/ModeratorEssentials/Listener.php at line 44
- SV\ModeratorEssentials\Listener::appPubStartEnd()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2654
- XF\App->fire() in src/XF/Pub/App.php at line 192
- XF\Pub\App->start() in src/XF/App.php at line 2180
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_post_FirstPost_2`.*, `xf_user_User_3`.*, `xf_user_option_Option_4`.*, `xf_user_profile_Profile_5`.*, `xf_user_privacy_Privacy_6`.*, `xf_session_activity_Activity_7`.*, `xf_sv_content_mentions_Mentions_8`.*, `xf_thfeature_feature_THFeature_9`.*, `xf_forum_Forum_10`.*, `xf_node_Node_11`.*, `xf_permission_cache_content_Permissions_12`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_2` ON (`xf_post_FirstPost_2`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_post_FirstPost_2`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_4` ON (`xf_user_option_Option_4`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_5` ON (`xf_user_profile_Profile_5`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_6` ON (`xf_user_privacy_Privacy_6`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_7` ON (`xf_session_activity_Activity_7`.`user_id` = `xf_user_User_3`.`user_id` AND `xf_session_activity_Activity_7`.`unique_key` = CONCAT(`xf_user_User_3`.`user_id`, ''))
LEFT JOIN `xf_sv_content_mentions` AS `xf_sv_content_mentions_Mentions_8` ON (`xf_sv_content_mentions_Mentions_8`.`content_type` = 'post' AND `xf_sv_content_mentions_Mentions_8`.`content_id` = `xf_post_FirstPost_2`.`post_id`)
LEFT JOIN `xf_thfeature_feature` AS `xf_thfeature_feature_THFeature_9` ON (`xf_thfeature_feature_THFeature_9`.`content_type` = 'thread' AND `xf_thfeature_feature_THFeature_9`.`content_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_10` ON (`xf_forum_Forum_10`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_11` ON (`xf_node_Node_11`.`node_id` = `xf_forum_Forum_10`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_12` ON (`xf_permission_cache_content_Permissions_12`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_12`.`content_id` = `xf_node_Node_11`.`node_id` AND `xf_permission_cache_content_Permissions_12`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '49670')
LIMIT 1
Run Time: 0.002022
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_post_FirstPost_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_profile_Profile_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_6 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_session_activity_Activity_7 | const | PRIMARY | PRIMARY | 22 | const,const | 0 | Unique row not found |
SIMPLE | xf_sv_content_mentions_Mentions_8 | const | PRIMARY | PRIMARY | 31 | const,const | 0 | Unique row not found |
SIMPLE | xf_thfeature_feature_THFeature_9 | ALL | | | | | 33 | Using where |
SIMPLE | xf_forum_Forum_10 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_11 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_forum_Forum_10.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_12 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,smokingm_db.xf_node_Node_11.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 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1372
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 12
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_session_activity_Activity_5`.*, `xf_sv_content_mentions_Mentions_6`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
LEFT JOIN `xf_sv_content_mentions` AS `xf_sv_content_mentions_Mentions_6` ON (`xf_sv_content_mentions_Mentions_6`.`content_type` = 'post' AND `xf_sv_content_mentions_Mentions_6`.`content_id` = `xf_post`.`post_id`)
WHERE (`xf_post`.`thread_id` = 49670) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.001543
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 10 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | smokingm_db.xf_user_User_1.user_id,func | 1 | Using where |
SIMPLE | xf_sv_content_mentions_Mentions_6 | eq_ref | PRIMARY | PRIMARY | 31 | const,smokingm_db.xf_post.post_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/Pub/Controller/Thread.php at line 35
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` IN (1692))
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000452
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Attachment.php at line 214
- XF\Repository\Attachment->addAttachmentsToContent() in src/addons/SV/UserEssentials/XF/Repository/Attachment.php at line 17
- SV\UserEssentials\XF\Repository\Attachment->addAttachmentsToContent() in src/XF/Pub/Controller/Thread.php at line 53
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT alert_id
FROM xf_user_alert
WHERE alerted_user_id = ?
AND view_date = 0
AND event_date < ?
AND content_type IN ('post')
AND content_id IN (1692, 1696, 1718, 1727, 1769, 1775, 2773, 2852, 2868, 2873)
Params: 0, 1576023841
Run Time: 0.000389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_alert | range | alertedUserId_eventDate,contentType_contentId,viewDate_eventDate | alertedUserId_eventDate | 8 | | 1 | Using index condition; 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 170
- XF\Db\AbstractAdapter->fetchAllColumn() in src/addons/SV/AlertImprovements/XF/Repository/UserAlert.php at line 681
- SV\AlertImprovements\XF\Repository\UserAlert->markAlertsReadForContentIds() in src/addons/SV/AlertImprovements/XF/Repository/UserAlert.php at line 638
- SV\AlertImprovements\XF\Repository\UserAlert->markUserAlertsReadForContent() in src/XF/Pub/Controller/Thread.php at line 57
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 49670
Run Time: 0.000091
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 193
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 90
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XF\Pub\Controller\Thread, Index, valid, thread_id=49670, 1576023841,
Run Time: 0.000243
- 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/XF/Pub/Controller/AbstractController.php at line 81
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Run Time: 0.000258
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status_display_order | 77 | const | 29 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 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/Siropu/AdsManager/Template/Ad.php at line 441
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 306
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 297
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2654
- XF\App->fire() in src/XF/App.php at line 1922
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1800
- XF\App->preRender() in src/XF/Pub/App.php at line 432
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('keyword', 'affiliate')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY RAND() ASC
Run Time: 0.001823
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status | 77 | const | 29 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_siropu_ads_manager_ad.package_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 546
- Siropu\AdsManager\Template\Ad->loadFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 310
- Siropu\AdsManager\Template\Ad->setFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 301
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2654
- XF\App->fire() in src/XF/App.php at line 1922
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1800
- XF\App->preRender() in src/XF/Pub/App.php at line 432
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_thread` FORCE INDEX (`last_post_date`)
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')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1573431841)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 10
Run Time: 0.000442
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 1090 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,smokingm_db.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.last_post_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewPosts.php at line 87
- XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_9_forum_overview_new_posts.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- 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 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 676
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_wte_widget_cache`.*
FROM `xf_wte_widget_cache`
WHERE (`xf_wte_widget_cache`.`cache_id` = 'b7bee9682a2e1fa5cf044b24b511297a')
LIMIT 1
Run Time: 0.000055
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_wte_widget_cache | const | PRIMARY | PRIMARY | 34 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/addons/Truonglv/WidgetThreadEnhance/Repository/Cache.php at line 18
- Truonglv\WidgetThreadEnhance\Repository\Cache->findById() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 372
- Truonglv\WidgetThreadEnhance\Widget\Threads->getThreadIdsFromCache() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 341
- Truonglv\WidgetThreadEnhance\Widget\Threads->getThreadIds() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 70
- Truonglv\WidgetThreadEnhance\Widget\Threads->render() in internal_data/code_cache/widgets/_32_PopularThreads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- 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 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 676
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
WHERE (`xf_thread`.`thread_id` IN (293046, 293055, 293085, 293065, 293053, 293114, 293058, 293136, 293047, 293056)) AND (`xf_thread`.`discussion_state` = 'visible')
Run Time: 0.000274
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 10 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.user_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_forum_Forum_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/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 102
- Truonglv\WidgetThreadEnhance\Widget\Threads->render() in internal_data/code_cache/widgets/_32_PopularThreads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- 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 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 676
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- 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, node, 3154
Run Time: 0.000075
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 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 73
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 936
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 61
- XF\Entity\Thread->canView() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 110
- Truonglv\WidgetThreadEnhance\Widget\Threads->render() in internal_data/code_cache/widgets/_32_PopularThreads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- 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 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 676
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('forumStatistics')
Run Time: 0.000069
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 1650
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2257
- XF\App->__get() in src/XF/Widget/ForumStatistics.php at line 10
- XF\Widget\ForumStatistics->render() in src/XF/Template/Templater.php at line 1675
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l1/s16/public/xb_footer.php at line 40
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 706
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s16/public/xb_footer.php at line 235
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1393
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s16/public/PAGE_CONTAINER.php at line 1991
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1995
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
bytes_sent | 20233 |
bytes_received | 1235685 |
packets_sent | 172 |
packets_received | 2378 |
protocol_overhead_in | 9512 |
protocol_overhead_out | 688 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 540 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 176 |
bytes_received_prepare_response_packet | 181906 |
bytes_received_change_user_packet | 1052381 |
packets_sent_command | 85 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 60 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 30 |
packets_received_prepare_response | 2088 |
packets_received_change_user | 170 |
result_set_queries | 26 |
non_result_set_queries | 4 |
no_index_used | 1 |
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 | 27 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 144 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 144 |
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 | 144 |
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 | 360 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 927 |
proto_binary_fetched_int24 | 232 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 2709 |
proto_binary_fetched_decimal | 86 |
proto_binary_fetched_float | 145 |
proto_binary_fetched_double | 0 |
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 | 1531 |
proto_binary_fetched_blob | 1243 |
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 | 2 |
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 | 28 |
com_stmt_execute | 28 |
com_stmt_send_long_data | 0 |
com_stmt_close | 27 |
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 | 1047385 |