SELECT parent_id, content_type, COUNT(*) AS total
FROM `xf_xc_ua_node_session_activity`
WHERE `view_date` >= 1711663485
AND `content_type` in ('node', 'thread')
GROUP BY parent_id
Run Time: 0.000386
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xc_ua_node_session_activity | range | view_date | view_date | 4 | | 8 | Using where; Using temporary; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 165
- XF\Db\AbstractAdapter->fetchAllKeyed() in src/addons/XenConcept/UserActivity/Repository/NodeSessionActivity.php at line 232
- XenConcept\UserActivity\Repository\NodeSessionActivity->countUserNodeSessionActivityForForumListViewers() in src/addons/XenConcept/UserActivity/Listener/Listener.php at line 49
- XenConcept\UserActivity\Listener\Listener::appSetup()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 1890
- XF\App->setup() in src/XF/Pub/App.php at line 91
- 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 cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000158
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 1176
- XF\Entity\User->hasPermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 273
- DBTech\Shop\XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 913
- XF\Entity\User->canStartConversation() in src/addons/EAEAddons/ConversationTools/XF/Entity/User.php at line 13
- EAEAddons\ConversationTools\XF\Entity\User->canStartConversation() in src/addons/EAEAddons/ConversationTools/Listener.php at line 189
- EAEAddons\ConversationTools\Listener::appPubStartEnd()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Pub/App.php at line 199
- XF\Pub\App->start() in src/XF/App.php at line 2340
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_fc_user_devices`.*
FROM `xf_fc_user_devices`
WHERE (`xf_fc_user_devices`.`user_id` = 0) AND (`xf_fc_user_devices`.`status` != '1') AND (`xf_fc_user_devices`.`browser_token` = 0)
LIMIT 1
Run Time: 0.000423
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_fc_user_devices | ref | user_id | user_id | 4 | 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 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
- XF\Mvc\Entity\FinderCollection->offsetGet() in src/XF/Mvc/Entity/FinderCollection.php at line 111
- XF\Mvc\Entity\FinderCollection->offsetExists() in src/addons/nick97/recentlyuseddevices/XF/Entity/User.php at line 27
- nick97\recentlyuseddevices\XF\Entity\User->getCurrentVisitorLoggedDevice() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/nick97/recentlyuseddevices/Listener.php at line 127
- nick97\recentlyuseddevices\Listener::controllerPostDispatch()
- call_user_func_array() in src/XF/Extension.php at line 35
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Mvc/Controller.php at line 289
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.*
FROM `xf_mg_media_item`
LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`)
WHERE (`xf_mg_media_item`.`media_id` = '9631')
LIMIT 1
Run Time: 0.001679
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment_Attachment_4.data_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 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/addons/XFMG/Pub/Controller/AbstractController.php at line 55
- XFMG\Pub\Controller\AbstractController->assertViewableMediaItem() in src/addons/XFMG/Pub/Controller/Media.php at line 128
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- 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, xfmg_category, 8
Run Time: 0.000201
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/addons/XFMG/XF/Entity/User.php at line 33
- XFMG\XF\Entity\User->hasGalleryCategoryPermission() in src/addons/XFMG/Entity/Category.php at line 175
- XFMG\Entity\Category->hasPermission() in src/addons/XFMG/Entity/MediaItem.php at line 516
- XFMG\Entity\MediaItem->hasPermission() in src/addons/XFMG/Entity/MediaItem.php at line 99
- XFMG\Entity\MediaItem->canView() in src/addons/XFMG/Pub/Controller/AbstractController.php at line 61
- XFMG\Pub\Controller\AbstractController->assertViewableMediaItem() in src/addons/XFMG/Pub/Controller/Media.php at line 128
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_mg_comment`.*, `xf_mg_album_Album_1`.*, `xf_mg_media_item_Media_2`.*, `xf_user_User_3`.*, `xf_user_profile_Profile_4`.*, `xf_session_activity_Activity_5`.*, `xf_mg_rating_Rating_6`.*
FROM `xf_mg_comment`
LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_comment`.`content_type` = 'xfmg_album' AND `xf_mg_album_Album_1`.`album_id` = `xf_mg_comment`.`content_id`)
LEFT JOIN `xf_mg_media_item` AS `xf_mg_media_item_Media_2` ON (`xf_mg_comment`.`content_type` = 'xfmg_media' AND `xf_mg_media_item_Media_2`.`media_id` = `xf_mg_comment`.`content_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_comment`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_4` ON (`xf_user_profile_Profile_4`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_3`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_3`.`user_id`, ''))
LEFT JOIN `xf_mg_rating` AS `xf_mg_rating_Rating_6` ON (`xf_mg_rating_Rating_6`.`rating_id` = `xf_mg_comment`.`rating_id`)
WHERE (`xf_mg_comment`.`content_type` = 'xfmg_media') AND (`xf_mg_comment`.`content_id` = 9631) AND ((`xf_mg_comment`.`comment_state` IN ('visible')))
ORDER BY `xf_mg_comment`.`comment_date` ASC, `xf_mg_comment`.`comment_id` ASC
LIMIT 14
Run Time: 0.001282
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_album_Album_1 | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | xf_mg_comment | ref | content_type_content_id_comment_date | content_type_content_id_comment_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_mg_media_item_Media_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_mg_comment.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_3.user_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | edewan_db.xf_user_User_3.user_id,func | 1 | Using where |
SIMPLE | xf_mg_rating_Rating_6 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_mg_comment.rating_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 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFMG/Pub/Controller/Media.php at line 154
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_mg_comment`
WHERE (`xf_mg_comment`.`content_type` = 'xfmg_media') AND (`xf_mg_comment`.`content_id` = 9631) AND ((`xf_mg_comment`.`comment_state` IN ('visible')))
Run Time: 0.000295
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_comment | ref | content_type_content_id_comment_date | content_type_content_id_comment_date | 31 | const,const | 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 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1334
- XF\Mvc\Entity\Finder->total() in src/addons/XFMG/Pub/Controller/Media.php at line 157
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
INSERT INTO xf_mg_media_view
(media_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 9631
Run Time: 0.000132
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/addons/XFMG/Repository/Media.php at line 383
- XFMG\Repository\Media->logMediaView() in src/addons/XFMG/Pub/Controller/Media.php at line 161
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT rating_id
FROM xf_mg_rating
WHERE content_type = ?
AND content_id = ?
ORDER BY rating_date
Params: xfmg_media, 9631
Run Time: 0.000269
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_rating | ref | content_type_id_user_id | content_type_id_user_id | 31 | const,const | 1 | Using index condition; Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 170
- XF\Db\AbstractAdapter->fetchAllColumn() in src/addons/XFMG/Entity/RateableTrait.php at line 88
- XFMG\Entity\MediaItem->getRatingIds() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/XFMG/Pub/Controller/Media.php at line 168
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- 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`.`data_id` = 17754 AND `xf_attachment`.`xfmg_is_mirror_handler` = 1)
LIMIT 1
Run Time: 0.000399
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | data_id | data_id | 4 | const | 2 | Using where |
SIMPLE | xf_attachment_data_Data_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 168
- XF\Mvc\Entity\Manager->findOne() in src/addons/XFMG/Entity/MediaItem.php at line 1071
- XFMG\Entity\MediaItem->getMirrorAttachment() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/XFMG/Pub/Controller/Media.php at line 189
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.*, `xf_thread_Thread_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`)
LEFT JOIN `xf_thread` AS `xf_thread_Thread_2` ON (`xf_thread_Thread_2`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_2`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_4`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` = 31346)
LIMIT 1
Run Time: 0.001331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | const | 1 | |
SIMPLE | xf_thread_Thread_2 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_Thread_2.node_id | 1 | Using where |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_node_Node_4.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 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/App.php at line 2722
- XF\App->findByContentType() in src/XF/Attachment/AbstractHandler.php at line 86
- XF\Attachment\AbstractHandler->getContainerEntity() in src/XF/Entity/Attachment.php at line 242
- XF\Entity\Attachment->getContainer() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/XFMG/Pub/Controller/Media.php at line 190
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_snog_private_thread`.*
FROM `xf_snog_private_thread`
WHERE (`xf_snog_private_thread`.`thread_id` = 10865)
LIMIT 1
Run Time: 0.000189
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 394
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 186
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/Snog/PrivateThreads/XF/Entity/Thread.php at line 30
- Snog\PrivateThreads\XF\Entity\Thread->canView() in src/addons/Truonglv/Schedule/XF/Entity/Thread.php at line 46
- Truonglv\Schedule\XF\Entity\Thread->canView() in src/addons/SV/ViewStickyThreads/XF/Entity/Thread.php at line 9
- SV\ViewStickyThreads\XF\Entity\Thread->canView() in src/XF/Entity/Post.php at line 57
- XF\Entity\Post->canView() in src/addons/OzzModz/ScheduledContent/XF/Entity/Post.php at line 16
- OzzModz\ScheduledContent\XF\Entity\Post->canView() in src/addons/PB/HideRepliesInThread/XF/Entity/Post.php at line 9
- PB\HideRepliesInThread\XF\Entity\Post->canView() in src/addons/Truonglv/Schedule/XF/Entity/Post.php at line 49
- Truonglv\Schedule\XF\Entity\Post->canView() in src/addons/XFMG/Pub/Controller/Media.php at line 193
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_mg_media_item`
WHERE ((`xf_mg_media_item`.`media_state` IN ('visible'))) AND (`xf_mg_media_item`.`category_id` = 8) AND ((`xf_mg_media_item`.`media_date` > 1654192067) OR (`xf_mg_media_item`.`media_date` = 1654192067 AND `xf_mg_media_item`.`media_id` > 9631))
Run Time: 0.000380
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY,media_date,category_id_media_date | category_id_media_date | 12 | | 9 | 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 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1334
- XF\Mvc\Entity\Finder->total() in src/addons/XFMG/Repository/Media.php at line 233
- XFMG\Repository\Media->getCurrentPositionInCategory() in src/addons/XFMG/ControllerPlugin/FilmStrip.php at line 167
- XFMG\ControllerPlugin\FilmStrip->getPositionInContainer() in src/addons/XFMG/ControllerPlugin/FilmStrip.php at line 44
- XFMG\ControllerPlugin\FilmStrip->getFilmStripParamsForView() in src/addons/XFMG/Pub/Controller/Media.php at line 232
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.*
FROM `xf_mg_media_item`
LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`)
WHERE ((`xf_mg_media_item`.`media_state` IN ('visible'))) AND (`xf_mg_media_item`.`category_id` = 8)
ORDER BY `xf_mg_media_item`.`media_date` DESC, `xf_mg_media_item`.`media_id` DESC
LIMIT 9 OFFSET 4
Run Time: 0.001368
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | ref | category_id_media_date | category_id_media_date | 4 | const | 54 | Using where |
SIMPLE | xf_mg_album_Album_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_mg_media_item.album_id | 1 | |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,edewan_db.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment_Attachment_4.data_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 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFMG/ControllerPlugin/FilmStrip.php at line 48
- XFMG\ControllerPlugin\FilmStrip->getFilmStripParamsForView() in src/addons/XFMG/Pub/Controller/Media.php at line 232
- XFMG\Pub\Controller\Media->actionView() in src/addons/Nulumia/SeoTools/XFMG/Pub/Controller/Media.php at line 30
- Nulumia\SeoTools\XFMG\Pub\Controller\Media->actionView() in src/addons/MaZ/AMP/Compat/XFMG/Pub/Controller/Media.php at line 32
- MaZ\AMP\Compat\XFMG\Pub\Controller\Media->actionView() 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 2344
- 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, , , XFMG\Pub\Controller\Media, View, valid, media_id=9631, 1711664385,
Run Time: 0.000158
- 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/addons/XenConcept/UserActivity/XF/Repository/SessionActivity.php at line 20
- XenConcept\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
DELETE FROM `xf_xc_ua_node_session_activity` WHERE user_id = ? AND unique_key = ?
Params: 0,
Run Time: 0.000136
- 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 289
- XF\Db\AbstractAdapter->delete() in src/addons/XenConcept/UserActivity/Repository/NodeSessionActivity.php at line 165
- XenConcept\UserActivity\Repository\NodeSessionActivity->clearUserNodeActivity() in src/addons/XenConcept/UserActivity/Repository/NodeSessionActivity.php at line 48
- XenConcept\UserActivity\Repository\NodeSessionActivity->updateNodeSessionActivity() in src/addons/XenConcept/UserActivity/XF/Repository/SessionActivity.php at line 24
- XenConcept\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- 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 2344
- XF\App->run() in src/XF.php at line 512
- 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.000296
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 | 102 | const | 10 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_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 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 530
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
- 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 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_smilie`.*
FROM `xf_smilie`
WHERE (`xf_smilie`.`display_in_editor` = 1) AND (`xf_smilie`.`ozzmodz_sct_active` = 1)
ORDER BY `xf_smilie`.`display_order` ASC, `xf_smilie`.`display_order` ASC
Run Time: 0.000118
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_smilie | ALL | | | | | 91 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/UW/SmileysBar/Listener.php at line 51
- UW\SmileysBar\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_xentr_randomTips`.*
FROM `xf_xentr_randomTips`
ORDER BY `xf_xentr_randomTips`.`display_order` ASC
Run Time: 0.000099
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xentr_randomTips | ALL | | | | | 6 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XENTR/RandomTips/RandomList.php at line 134
- XENTR\RandomTips\RandomList->getRandomList() in src/addons/XENTR/RandomTips/Listener.php at line 21
- XENTR\RandomTips\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_xentr_randomTips`.*
FROM `xf_xentr_randomTips`
ORDER BY `xf_xentr_randomTips`.`display_order` ASC
Run Time: 0.000107
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xentr_randomTips | ALL | | | | | 6 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XENTR/RandomTips/RandomList.php at line 143
- XENTR\RandomTips\RandomList->getRandomList() in src/addons/XENTR/RandomTips/Listener.php at line 21
- XENTR\RandomTips\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_cv6_dice`.*
FROM `xf_cv6_dice`
WHERE (`xf_cv6_dice`.`active` = '1')
ORDER BY `xf_cv6_dice`.`display_order` ASC
Run Time: 0.000088
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cv6_dice | ALL | active | | | | 4 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/cv6/DiceRoller/Repository/Dice.php at line 50
- cv6\DiceRoller\Repository\Dice->getDiceForThreadView() in src/addons/cv6/DiceRoller/Listener.php at line 85
- cv6\DiceRoller\Listener::globalTemplateData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_seo_mg_media_meta`.*
FROM `xf_seo_mg_media_meta`
WHERE (`xf_seo_mg_media_meta`.`media_id` = 9631)
LIMIT 1
Run Time: 0.000272
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 394
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 186
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s1/public/xfmg_media_view.php at line 30
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('thread_x', 'mh_strip_visited_thread')
Params: 2
Run Time: 0.000315
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 2 | 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/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Phrase.php at line 59
- XF\Phrase->__toString()
- preg_replace() in src/addons/MMO/Hide/Data/HideTags.php at line 47
- MMO\Hide\Data\HideTags->stripHideTags() in src/addons/MMO/Hide/XF/Str/Formatter.php at line 44
- MMO\Hide\XF\Str\Formatter->snippetString() in src/XF/Template/Templater.php at line 4129
- XF\Template\Templater->fnSnippet()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/xfmg_media_view.php at line 58
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_dbtech_shop_item`.*, `xf_user_User_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_dbtech_shop_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_dbtech_shop_item`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_dbtech_shop_item`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'dbtech_shop_item' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_dbtech_shop_item`.`item_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
LEFT JOIN `xf_dbtech_shop_category` AS `xf_dbtech_shop_category_Category_3` ON (`xf_dbtech_shop_category_Category_3`.`category_id` = `xf_dbtech_shop_item`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'dbtech_shop_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_dbtech_shop_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
Run Time: 0.001494
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_dbtech_shop_item | ALL | | | | | 20 | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_dbtech_shop_item.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_dbtech_shop_item.item_id | 1 | Using where |
SIMPLE | xf_dbtech_shop_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_dbtech_shop_item.category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_dbtech_shop_category_Category_3.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 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/Shop/XF/Entity/User.php at line 228
- DBTech\Shop\XF\Entity\User->getDbtechShopPurchase() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/DBTech/Shop/Repository/Purchase.php at line 296
- DBTech\Shop\Repository\Purchase->getViewablePurchasesForUser() in src/addons/DBTech/Shop/Repository/Purchase.php at line 331
- DBTech\Shop\Repository\Purchase->filterActivePurchasesForUser() in src/addons/DBTech/Shop/XF/Template/Templater.php at line 101
- DBTech\Shop\XF\Template\Templater->fnUsernameClasses() in src/addons/Nulumia/SeoTools/XF/Template/Templater.php at line 64
- Nulumia\SeoTools\XF\Template\Templater->templaterFnUsernameUnlink() in src/addons/Nulumia/SeoTools/XF/Template/Templater.php at line 21
- Nulumia\SeoTools\XF\Template\Templater->fnUsernameLink() in src/addons/OzzModz/ShowDiscouragedStatus/XF/Template/Templater.php at line 9
- OzzModz\ShowDiscouragedStatus\XF\Template\Templater->fnUsernameLink() in src/addons/Smoke/MarkScammer/XF/Template/Templater.php at line 11
- Smoke\MarkScammer\XF\Template\Templater->fnUsernameLink() in src/addons/XENTR/RichUsernamePlus/XF/Template/Templater.php at line 15
- XENTR\RichUsernamePlus\XF\Template\Templater->fnUsernameLink() in src/addons/XV/Template/Templater.php at line 59
- XV\Template\Templater->fnUsernameLink() in src/addons/BS/SpeedFix/XF/Template/Templater.php at line 14
- BS\SpeedFix\XF\Template\Templater->fnUsernameLink()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/xfmg_media_view.php at line 147
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_xp_fm`.*
FROM `xf_xp_fm`
ORDER BY `xf_xp_fm`.`display_order` ASC
Run Time: 0.000142
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xp_fm | ALL | | | | | 3 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XP/FM/ButtonList.php at line 165
- XP\FM\ButtonList->getButtonList() in src/addons/XP/FM/Listener.php at line 42
- XP\FM\Listener::appPubRenderPage()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Pub/App.php at line 560
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_bm_ehdaa`.*
FROM `xf_bm_ehdaa`
ORDER BY `xf_bm_ehdaa`.`ehdaa_date` DESC
Run Time: 0.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_bm_ehdaa | ALL | | | | | 1 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Boussaid/Ehdaa/XF/Repository/Ehdaat.php at line 19
- Boussaid\Ehdaa\XF\Repository\Ehdaat->findEhdaa() in src/addons/Boussaid/Ehdaa/PageContainer.php at line 11
- Boussaid\Ehdaa\PageContainer::extend()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Template/Templater.php at line 1603
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_bm_ehdaa`.*
FROM `xf_bm_ehdaa`
ORDER BY `xf_bm_ehdaa`.`ehdaa_date` DESC
Run Time: 0.000063
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_bm_ehdaa | ALL | | | | | 1 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Boussaid/Ehdaa/PageContainer.php at line 13
- Boussaid\Ehdaa\PageContainer::extend()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Template/Templater.php at line 1603
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_style_StyleStats_1`.*, `xf_style_DefaultStyleStats_2`.*, `xf_user_privacy_Privacy_3`.*
FROM `xf_user`
LEFT JOIN `xf_style` AS `xf_style_StyleStats_1` ON (`xf_style_StyleStats_1`.`style_id` = `xf_user`.`style_id`)
LEFT JOIN `xf_style` AS `xf_style_DefaultStyleStats_2` ON (`xf_style_DefaultStyleStats_2`.`style_id` = '1')
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_3` ON (`xf_user_privacy_Privacy_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` = 916)
LIMIT 1
Run Time: 0.001062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_style_StyleStats_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_style_DefaultStyleStats_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/addons/BS/SpeedFix/FS/ExtendedHonorRoll/BestUserInXTime/Repository/BuserRepo.php at line 244
- BS\SpeedFix\FS\ExtendedHonorRoll\BestUserInXTime\Repository\BuserRepo->getActivePost() in src/addons/Shqawe/BestUserInXTime/Listener.php at line 73
- Shqawe\BestUserInXTime\Listener::getActiveThread()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Template/Templater.php at line 1603
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xfa_xcountdown`.*, `xfa_xcountdown_Parent_1`.*
FROM `xfa_xcountdown`
LEFT JOIN `xfa_xcountdown` AS `xfa_xcountdown_Parent_1` ON (`xfa_xcountdown_Parent_1`.`parent_id` = `xfa_xcountdown`.`parent_id`)
WHERE (`xfa_xcountdown`.`start_date` < 1711664385) AND (`xfa_xcountdown`.`end_date` > 1711664385) AND (`xfa_xcountdown`.`location` LIKE '%header%')
ORDER BY `xfa_xcountdown`.`end_date` ASC
Run Time: 0.001055
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xfa_xcountdown | ALL | | | | | 11 | Using where; Using temporary; Using filesort |
SIMPLE | xfa_xcountdown_Parent_1 | ALL | | | | | 11 | Using where; Using join buffer (flat, BNL join) |
- 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 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFA/MultipleCountdowns/Template.php at line 18
- XFA\MultipleCountdowns\Template::getHeaderCountdown()
- call_user_func() in src/XF/Template/Templater.php at line 1688
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 1218
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('ozzmodz_wau_forum_statistics_users')
Params: 2
Run Time: 0.000309
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | 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 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Template/Templater.php at line 3458
- XF\Template\Templater->fnPhraseDynamic() in src/addons/AL/ThreadFilter/XF/Template/Templater.php at line 53
- AL\ThreadFilter\XF\Template\Templater->fnPhraseDynamic()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 70
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1919
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/cxf_advanced_footer_widgets_links_above.php at line 12
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1673
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 2694
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('ozzmodz_wau_forum_statistics_messages')
Params: 2
Run Time: 0.000089
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | 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 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Template/Templater.php at line 3458
- XF\Template\Templater->fnPhraseDynamic() in src/addons/AL/ThreadFilter/XF/Template/Templater.php at line 53
- AL\ThreadFilter\XF\Template\Templater->fnPhraseDynamic()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 70
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1919
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/cxf_advanced_footer_widgets_links_above.php at line 12
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1673
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 2694
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('ozzmodz_wau_forum_statistics_threads')
Params: 2
Run Time: 0.000107
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | 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 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Template/Templater.php at line 3458
- XF\Template\Templater->fnPhraseDynamic() in src/addons/AL/ThreadFilter/XF/Template/Templater.php at line 53
- AL\ThreadFilter\XF\Template\Templater->fnPhraseDynamic()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 70
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1919
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/cxf_advanced_footer_widgets_links_above.php at line 12
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1673
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 2694
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- 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 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
bytes_sent | 26905 |
bytes_received | 711268 |
packets_sent | 370 |
packets_received | 4202 |
protocol_overhead_in | 16808 |
protocol_overhead_out | 1480 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1197 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 347 |
bytes_received_prepare_response_packet | 304830 |
bytes_received_change_user_packet | 403524 |
packets_sent_command | 184 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 133 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 63 |
packets_received_prepare_response | 3650 |
packets_received_change_user | 293 |
result_set_queries | 58 |
non_result_set_queries | 5 |
no_index_used | 9 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 58 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 60 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 235 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 235 |
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 | 235 |
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 | 757 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1459 |
proto_binary_fetched_int24 | 222 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 3759 |
proto_binary_fetched_decimal | 114 |
proto_binary_fetched_float | 200 |
proto_binary_fetched_double | 62 |
proto_binary_fetched_date | 213 |
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 | 1810 |
proto_binary_fetched_blob | 1231 |
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 | 61 |
com_stmt_execute | 61 |
com_stmt_send_long_data | 0 |
com_stmt_close | 60 |
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 | 397252 |