Page Time: 0.0323s

Memory: 4.4441 MB (Peak: 4.7454 MB)

Queries (11, time: 0.0108s, 33.5%)

  1. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000124
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
    6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
    7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
    8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
    9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    14. XF\App->run() in src/XF.php at line 524
    15. XF::runApp() in index.php at line 20
  2. SELECT `xf_mg_category`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_mg_category`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_mg_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')

ORDER BY `xf_mg_category`.`lft` ASC
    Run Time: 0.000165
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_mg_categoryALL    6Using filesort
    SIMPLExf_permission_cache_content_Permissions_1eq_refPRIMARYPRIMARY35const,const,sdn_xenforo.xf_mg_category.category_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AbstractCategoryTree.php at line 67
    4. XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/XFMG/ControllerPlugin/AbstractList.php at line 15
    5. XFMG\ControllerPlugin\AbstractList->getCategoryListData() in src/addons/XFMG/Pub/Controller/Media.php at line 23
    6. XFMG\Pub\Controller\Media->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    11. XF\App->run() in src/XF.php at line 524
    12. XF::runApp() in index.php at line 20
  3. SELECT COUNT(*)
FROM `xf_mg_media_item` FORCE INDEX (`media_date`)
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`)
WHERE (IF(`xf_mg_media_item`.`album_id` > 0, `xf_mg_album_Album_1`.`album_state` = 'visible', 1=1)) AND ((`xf_mg_media_item`.`category_id` IN (2, 3, 4, 5, 6, 1)) OR (`xf_mg_media_item`.`category_id` = 0 AND `xf_mg_album_Album_1`.`view_privacy` = 'public')) AND ((`xf_mg_media_item`.`media_state` IN ('visible')))
    Run Time: 0.000100
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_mg_media_itemALL    1244Using where
    SIMPLExf_mg_album_Album_1eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_media_item.album_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1385
    4. XF\Mvc\Entity\Finder->total() in src/addons/XFMG/ControllerPlugin/MediaList.php at line 52
    5. XFMG\ControllerPlugin\MediaList->getMediaListData() in src/addons/XFMG/Pub/Controller/Media.php at line 42
    6. XFMG\Pub\Controller\Media->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    11. XF\App->run() in src/XF.php at line 524
    12. XF::runApp() in index.php at line 20
  4. 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` FORCE INDEX (`media_date`)
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 (IF(`xf_mg_media_item`.`album_id` > 0, `xf_mg_album_Album_1`.`album_state` = 'visible', 1=1)) AND ((`xf_mg_media_item`.`category_id` IN (2, 3, 4, 5, 6, 1)) OR (`xf_mg_media_item`.`category_id` = 0 AND `xf_mg_album_Album_1`.`view_privacy` = 'public')) AND ((`xf_mg_media_item`.`media_state` IN ('visible')))
ORDER BY `xf_mg_media_item`.`media_date` DESC, `xf_mg_media_item`.`media_id` DESC

LIMIT 24 OFFSET 576
    Run Time: 0.008376
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_mg_media_itemindex media_date4 600Using where
    SIMPLExf_mg_album_Album_1eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_media_item.album_id1Using where
    SIMPLExf_mg_category_Category_2eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_media_item.category_id1 
    SIMPLExf_user_User_3eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_media_item.user_id1 
    SIMPLExf_attachment_Attachment_4refcontent_type_id_datecontent_type_id_date31const,sdn_xenforo.xf_mg_media_item.media_id1Using where
    SIMPLExf_attachment_data_Data_5eq_refPRIMARYPRIMARY4sdn_xenforo.xf_attachment_Attachment_4.data_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XFMG/ControllerPlugin/MediaList.php at line 65
    4. XFMG\ControllerPlugin\MediaList->getMediaListData() in src/addons/XFMG/Pub/Controller/Media.php at line 42
    5. XFMG\Pub\Controller\Media->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    10. XF\App->run() in src/XF.php at line 524
    11. XF::runApp() in index.php at line 20
  5. SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
    Params: 0,
    Run Time: 0.000153
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityconstPRIMARYPRIMARY22const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
    4. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/SV/UserActivity/XF/Repository/SessionActivity.php at line 35
    5. SV\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
    6. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
    7. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
    8. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
    9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    13. XF\App->run() in src/XF.php at line 524
    14. XF::runApp() in index.php at line 20
  6. -- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
	ip = ?,
	controller_name = ?,
	controller_action = ?,
	view_state = ?,
	params = ?,
	view_date = ?,
	robot_key = ?
WHERE user_id = ? AND unique_key = ?
    Params: , XFMG\Pub\Controller\Media, Index, valid, page=25, 1714227118, , 0,
    Run Time: 0.000134

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/SV/UserActivity/XF/Repository/SessionActivity.php at line 35
    4. SV\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
    5. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
    6. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
    7. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    12. XF\App->run() in src/XF.php at line 524
    13. XF::runApp() in index.php at line 20
  7. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 2
    Run Time: 0.000178
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
    6. XF\Entity\User->hasPermission() in src/addons/KL/UserImprovements/Template/Templater.php at line 32
    7. KL\UserImprovements\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 4563
    8. XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1132
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 511
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 242
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 83
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    15. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_index.php at line 156
    16. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
    17. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    18. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    19. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    20. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    21. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    22. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    23. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    24. XF\App->run() in src/XF.php at line 524
    25. XF::runApp() in index.php at line 20
  8. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 351
    Run Time: 0.000102
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
    6. XF\Entity\User->hasPermission() in src/addons/KL/UserImprovements/Template/Templater.php at line 32
    7. KL\UserImprovements\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 4563
    8. XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1132
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 511
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 242
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 83
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    15. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_index.php at line 156
    16. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
    17. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    18. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    19. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    20. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    21. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    22. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    23. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    24. XF\App->run() in src/XF.php at line 524
    25. XF::runApp() in index.php at line 20
  9. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 655
    Run Time: 0.000119
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
    6. XF\Entity\User->hasPermission() in src/addons/KL/UserImprovements/Template/Templater.php at line 32
    7. KL\UserImprovements\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 4563
    8. XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1132
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 511
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 242
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 83
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    15. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_index.php at line 156
    16. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
    17. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    18. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    19. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    20. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    21. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    22. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    23. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    24. XF\App->run() in src/XF.php at line 524
    25. XF::runApp() in index.php at line 20
  10. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 778
    Run Time: 0.000110
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
    6. XF\Entity\User->hasPermission() in src/addons/KL/UserImprovements/Template/Templater.php at line 32
    7. KL\UserImprovements\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 4563
    8. XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1132
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 511
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 242
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php at line 83
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    15. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l12/s30/public/xfmg_media_index.php at line 156
    16. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
    17. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    18. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    19. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    20. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    21. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    22. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    23. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    24. XF\App->run() in src/XF.php at line 524
    25. XF::runApp() in index.php at line 20
  11. SELECT `xf_mg_comment`.*, `xf_mg_album_Album_1`.*, `xf_mg_media_item_Media_2`.*, `xf_mg_category_Category_3`.*, `xf_mg_album_Album_4`.*, `xf_mg_category_Category_5`.*, `xf_mg_rating_Rating_6`.*
FROM `xf_mg_comment` FORCE INDEX (`comment_date`)
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_mg_category` AS `xf_mg_category_Category_3` ON (`xf_mg_category_Category_3`.`category_id` = `xf_mg_album_Album_1`.`category_id`)
LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_4` ON (`xf_mg_album_Album_4`.`album_id` = `xf_mg_media_item_Media_2`.`album_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_5` ON (`xf_mg_category_Category_5`.`category_id` = `xf_mg_media_item_Media_2`.`category_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`.`comment_state` = 'visible') AND (`xf_mg_comment`.`comment_date` > 1711635118) AND (IF(`xf_mg_comment`.`content_type` = 'xfmg_media', `xf_mg_media_item_Media_2`.`media_state` = 'visible' AND IF(`xf_mg_media_item_Media_2`.`album_id` > 0, `xf_mg_album_Album_4`.`album_state` = 'visible', 1=1), IF(`xf_mg_comment`.`content_type` = 'xfmg_album', `xf_mg_album_Album_1`.`album_state` = 'visible', 0)))
ORDER BY `xf_mg_comment`.`comment_date` DESC, `xf_mg_comment`.`comment_id` DESC

LIMIT 50
    Run Time: 0.001273
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_mg_commentrangecomment_datecomment_date4 1Using where
    SIMPLExf_mg_album_Album_1eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_comment.content_id1Using where
    SIMPLExf_mg_media_item_Media_2eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_comment.content_id1Using where
    SIMPLExf_mg_category_Category_3eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_album_Album_1.category_id1Using where
    SIMPLExf_mg_album_Album_4eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_media_item_Media_2.album_id1Using where
    SIMPLExf_mg_category_Category_5eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_media_item_Media_2.category_id1Using where
    SIMPLExf_mg_rating_Rating_6eq_refPRIMARYPRIMARY4sdn_xenforo.xf_mg_comment.rating_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XFMG/Widget/LatestComments.php at line 27
    4. XFMG\Widget\LatestComments->render() in internal_data/code_cache/widgets/_48_xfmg_gallery_wrapper_latest_comments.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1940
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l12/s30/public/xfmg_gallery_wrapper.php at line 74
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1052
    11. XF\Template\Templater->applyWrappedTemplate() in src/XF/Template/Templater.php at line 1670
    12. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    13. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    14. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    15. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    16. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    17. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    19. XF\App->run() in src/XF.php at line 524
    20. XF::runApp() in index.php at line 20

Included Files (219, XenForo Classes: 97)

  1. index.php
  2. src/XF.php
  3. src/vendor/autoload.php
  4. src/vendor/composer/autoload_real.php
  5. src/vendor/composer/ClassLoader.php
  6. src/vendor/composer/autoload_static.php
  7. src/vendor/laminas/laminas-zendframework-bridge/src/autoload.php
  8. src/vendor/laminas/laminas-zendframework-bridge/src/Autoloader.php
  9. src/vendor/laminas/laminas-zendframework-bridge/src/RewriteRules.php
  10. src/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
  11. src/vendor/symfony/polyfill-php72/bootstrap.php
  12. src/vendor/symfony/polyfill-intl-idn/bootstrap.php
  13. src/vendor/symfony/polyfill-mbstring/bootstrap.php
  14. src/vendor/ralouphie/getallheaders/src/getallheaders.php
  15. src/vendor/guzzlehttp/promises/src/functions_include.php
  16. src/vendor/guzzlehttp/promises/src/functions.php
  17. src/vendor/guzzlehttp/psr7/src/functions_include.php
  18. src/vendor/guzzlehttp/psr7/src/functions.php
  19. src/vendor/guzzlehttp/guzzle/src/functions_include.php
  20. src/vendor/guzzlehttp/guzzle/src/functions.php
  21. src/vendor/paragonie/sodium_compat/autoload.php
  22. src/vendor/paragonie/sodium_compat/autoload-php7.php
  23. src/vendor/paragonie/sodium_compat/src/Compat.php
  24. src/vendor/paragonie/sodium_compat/lib/namespaced.php
  25. src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
  26. src/vendor/paragonie/sodium_compat/lib/constants.php
  27. src/vendor/paragonie/sodium_compat/lib/php72compat.php
  28. src/vendor/paragonie/sodium_compat/lib/stream-xchacha20.php
  29. src/vendor/paragonie/sodium_compat/lib/ristretto255.php
  30. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
  31. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
  32. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  33. src/vendor/dokuwiki/utf8/utf8.php
  34. src/XF/Http/Request.php
  35. src/XF/InputFilterer.php
  36. src/XF/Pub/App.php
  37. src/XF/App.php
  38. src/XF/Container.php
  39. src/config.php
  40. src/XF/DataRegistry.php
  41. src/XF/Db/Mysqli/Adapter.php
  42. src/XF/Db/AbstractAdapter.php
  43. src/XF/CacheFactory.php
  44. src/XF/Cache/RedisCache.php
  45. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/RedisCache.php
  46. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  47. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  48. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  49. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  50. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  51. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
  52. src/XF/Extension.php
  53. src/XF/AddOn/Manager.php
  54. src/addons/XFMG/Listener.php
  55. src/addons/SV/StandardLib/XF/InputFilterer.php
  56. src/XF/Session/Session.php
  57. src/XF/Session/DbStorage.php
  58. src/XF/Session/StorageInterface.php
  59. src/XF/Util/Ip.php
  60. src/XF/Util/Random.php
  61. src/XF/Http/Response.php
  62. src/XF/Mvc/Entity/Manager.php
  63. src/XF/Mvc/Entity/ValueFormatter.php
  64. src/XF/Repository/User.php
  65. src/XF/Mvc/Entity/Repository.php
  66. src/XF/Entity/User.php
  67. src/XF/Mvc/Entity/Entity.php
  68. src/XF/Entity/LinkableInterface.php
  69. src/addons/Banxix/BumpThread/Entity/User.php
  70. src/addons/KL/UserImprovements/Entity/User.php
  71. src/addons/Scandals/xFGlossary/XF/Entity/User.php
  72. src/addons/xenMade/TPM/XF/Entity/User.php
  73. src/addons/XFMG/XF/Entity/User.php
  74. src/XF/Mvc/Entity/Structure.php
  75. src/addons/Scandals/xFGlossary/Listeners/User.php
  76. src/XF/Entity/UserAuth.php
  77. src/XF/Entity/UserOption.php
  78. src/XF/Entity/UserProfile.php
  79. src/XF/Entity/UserPrivacy.php
  80. src/addons/KL/UserImprovements/Entity/UserPrivacy.php
  81. src/XF/Util/File.php
  82. src/XF/Language.php
  83. src/XF/Mvc/Dispatcher.php
  84. src/XF/Mvc/Router.php
  85. src/addons/TurkishFriendlyLink/Listener.php
  86. src/XF/Mvc/RouteMatch.php
  87. src/XF/Util/Arr.php
  88. src/XF/Mvc/ParameterBag.php
  89. src/addons/XFMG/Pub/Controller/Media.php
  90. src/addons/XFMG/Pub/Controller/AbstractController.php
  91. src/XF/Pub/Controller/AbstractController.php
  92. src/XF/Mvc/Controller.php
  93. src/XF/Util/Php.php
  94. src/XF/PermissionCache.php
  95. src/XF/PermissionSet.php
  96. src/XF/Db/Mysqli/Statement.php
  97. src/XF/Db/AbstractStatement.php
  98. src/addons/XFMG/ControllerPlugin/MediaList.php
  99. src/addons/XFMG/ControllerPlugin/AbstractList.php
  100. src/XF/ControllerPlugin/AbstractPlugin.php
  101. src/addons/XFMG/Repository/Category.php
  102. src/XF/Repository/AbstractCategoryTree.php
  103. src/addons/XFMG/Entity/Category.php
  104. src/XF/Entity/AbstractCategoryTree.php
  105. src/XF/Phrase.php
  106. src/addons/XFMG/Repository/Media.php
  107. src/XF/Mvc/Entity/Finder.php
  108. src/XF/Entity/PermissionCacheContent.php
  109. src/XF/Mvc/Entity/Proxyable.php
  110. src/XF/Mvc/Entity/FinderCollection.php
  111. src/XF/Mvc/Entity/AbstractCollection.php
  112. src/XF/Mvc/Entity/ArrayCollection.php
  113. src/XF/Tree.php
  114. src/XF/SubTree.php
  115. src/addons/XFMG/Entity/MediaItem.php
  116. src/XF/BbCode/RenderableContentInterface.php
  117. src/addons/XFMG/Entity/CommentableTrait.php
  118. src/addons/XFMG/Entity/RateableTrait.php
  119. src/XF/Entity/ReactionTrait.php
  120. src/XF/Entity/BookmarkTrait.php
  121. src/addons/XFMG/Finder/MediaItem.php
  122. src/addons/XFMG/Entity/Album.php
  123. src/XF/Entity/Attachment.php
  124. src/addons/XFMG/XF/Entity/Attachment.php
  125. src/XF/Entity/AttachmentData.php
  126. src/addons/XFMG/XF/Entity/AttachmentData.php
  127. src/XF/Mvc/Entity/FinderExpression.php
  128. src/XF/Mvc/Reply/View.php
  129. src/XF/Mvc/Reply/AbstractReply.php
  130. src/XF/Repository/SessionActivity.php
  131. src/addons/SV/UserActivity/XF/Repository/SessionActivity.php
  132. src/XF/Data/Robot.php
  133. src/addons/SV/UserActivity/Repository/UserActivity.php
  134. src/XF/Style.php
  135. src/XF/Template/Templater.php
  136. src/addons/KL/UserImprovements/Template/Templater.php
  137. src/addons/SV/UserActivity/XF/Template/Templater.php
  138. src/addons/XenGenTr/XGTHariciBaglantiYonlendir/XF/Template/Templater.php
  139. src/addons/XenGenTr/XGTOnekSistemi/XF/Template/Templater.php
  140. src/addons/xenMade/TPM/XF/Template/Templater.php
  141. src/addons/SV/StandardLib/XF/Template/Templater.php
  142. src/addons/SV/LazyImageLoader/XF/Template/Templater.php
  143. src/XF/SubContainer/BbCode.php
  144. src/XF/SubContainer/AbstractSubContainer.php
  145. src/XF/SubContainer/Widget.php
  146. src/addons/XFMG/Template/TemplaterSetup.php
  147. src/addons/SV/LazyImageLoader/Listener.php
  148. src/addons/SV/LazyImageLoader/Helper.php
  149. src/XF/CookieConsent.php
  150. src/XF/Captcha/ReCaptcha.php
  151. src/XF/Captcha/AbstractCaptcha.php
  152. src/XF/Repository/Payment.php
  153. src/XF/Payment/PayPal.php
  154. src/XF/Payment/AbstractProvider.php
  155. src/XF/SimpleCache.php
  156. src/XF/Mvc/Renderer/Html.php
  157. src/XF/Mvc/Renderer/AbstractRenderer.php
  158. src/XF/Mvc/View.php
  159. src/XF/Template/Template.php
  160. internal_data/code_cache/templates/l12/s30/public/xfmg_media_index.php
  161. src/XF/PreEscaped.php
  162. internal_data/code_cache/templates/l12/s30/public/xfmg_media_list_macros.php
  163. src/XF/Template/MacroState.php
  164. internal_data/code_cache/templates/l12/s30/public/xfmg_page_macros.php
  165. internal_data/code_cache/templates/l12/s30/public/metadata_macros.php
  166. internal_data/code_cache/templates/l12/s30/public/page_nav.php
  167. internal_data/code_cache/templates/l12/s30/public/lightbox_macros.php
  168. src/XF/Str/Formatter.php
  169. internal_data/code_cache/templates/l12/s30/public/xfmg_gallery_wrapper.php
  170. internal_data/code_cache/templates/l12/s30/public/xfmg_category_list_macros.php
  171. internal_data/code_cache/widgets/_48_xfmg_gallery_wrapper_latest_comments.php
  172. src/XF/Widget/WidgetConfig.php
  173. src/addons/XFMG/Widget/LatestComments.php
  174. src/XF/Widget/AbstractWidget.php
  175. src/addons/XFMG/Repository/Comment.php
  176. src/addons/XFMG/Entity/Comment.php
  177. src/XF/Entity/QuotableInterface.php
  178. src/addons/XFMG/Finder/Comment.php
  179. src/addons/XFMG/Entity/Rating.php
  180. src/addons/XFMG/Finder/Album.php
  181. internal_data/code_cache/phrase_groups/l12/widget.php
  182. src/XF/Widget/WidgetRenderer.php
  183. internal_data/code_cache/templates/l12/s30/public/xfmg_widget_latest_comments.php
  184. internal_data/code_cache/widgets/_49_xfmg_gallery_wrapper_most_media_items.php
  185. src/XF/Widget/MemberStat.php
  186. internal_data/code_cache/widgets/_50_xfmg_statistics.php
  187. src/addons/XFMG/Widget/GalleryStatistics.php
  188. src/XF/SimpleCacheSet.php
  189. internal_data/code_cache/templates/l12/s30/public/xfmg_widget_gallery_statistics.php
  190. internal_data/code_cache/navigation_cache.php
  191. src/XF/Pub/Route/Search.php
  192. src/XF/NoticeList.php
  193. internal_data/code_cache/templates/l12/s30/public/PAGE_CONTAINER.php
  194. src/XF/Util/Color.php
  195. internal_data/code_cache/templates/l12/s30/public/xb_custom_fonts.php
  196. internal_data/code_cache/templates/l12/s30/public/helper_js_global.php
  197. internal_data/code_cache/templates/l12/s30/public/font_awesome_setup.php
  198. internal_data/code_cache/templates/l12/s30/public/google_analytics.php
  199. internal_data/code_cache/templates/l12/s30/public/xb_head.php
  200. internal_data/code_cache/phrase_groups/l12/nav.php
  201. internal_data/code_cache/phrase_groups/l12/button.php
  202. internal_data/code_cache/templates/l12/s30/public/xb_subnav_right.php
  203. internal_data/code_cache/templates/l12/s30/public/xb_canvas_panel_top.php
  204. internal_data/code_cache/templates/l12/s30/public/xb_canvas_panel_bottom.php
  205. internal_data/code_cache/templates/l12/s30/public/_ads.php
  206. internal_data/code_cache/templates/l12/s30/public/browser_warning_macros.php
  207. internal_data/code_cache/templates/l12/s30/public/xb_welcome.php
  208. internal_data/code_cache/templates/l12/s30/public/xb_footer_links.php
  209. internal_data/code_cache/templates/l12/s30/public/xb_footer.php
  210. src/XF/Widget/ForumStatistics.php
  211. internal_data/code_cache/phrase_groups/l12/widget_def.php
  212. internal_data/code_cache/templates/l12/s30/public/widget_forum_statistics.php
  213. src/XF/Widget/SharePage.php
  214. internal_data/code_cache/templates/l12/s30/public/widget_share_page.php
  215. internal_data/code_cache/templates/l12/s30/public/share_page_macros.php
  216. internal_data/code_cache/templates/l12/s30/public/debug_macros.php
  217. internal_data/code_cache/templates/l12/s30/public/xb_body_helper.php
  218. internal_data/code_cache/templates/l12/s30/public/xb_body.php
  219. src/XF/Debugger.php

DB Connection Stats

bytes_sent11154
bytes_received385449
packets_sent130
packets_received1118
protocol_overhead_in4472
protocol_overhead_out520
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet477
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet174
bytes_received_prepare_response_packet73483
bytes_received_change_user_packet310758
packets_sent_command64
packets_received_ok0
packets_received_eof0
packets_received_rset_header53
packets_received_rset_field_meta0
packets_received_rset_row23
packets_received_prepare_response939
packets_received_change_user80
result_set_queries20
non_result_set_queries3
no_index_used3
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets20
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed20
rows_fetched_from_server_normal0
rows_fetched_from_server_ps60
rows_buffered_from_client_normal0
rows_buffered_from_client_ps60
rows_fetched_from_client_normal_buffered0
rows_fetched_from_client_normal_unbuffered0
rows_fetched_from_client_ps_buffered0
rows_fetched_from_client_ps_unbuffered0
rows_fetched_from_client_ps_cursor0
rows_affected_normal0
rows_affected_ps0
rows_skipped_normal0
rows_skipped_ps60
copy_on_write_saved0
copy_on_write_performed0
command_buffer_too_small0
connect_success1
connect_failure0
connection_reused0
reconnect0
pconnect_success1
active_connections1
active_persistent_connections1
explicit_close0
implicit_close0
disconnect_close0
in_middle_of_command_close0
explicit_free_result0
implicit_free_result0
explicit_stmt_close0
implicit_stmt_close0
mem_emalloc_count0
mem_emalloc_amount0
mem_ecalloc_count0
mem_ecalloc_amount0
mem_erealloc_count0
mem_erealloc_amount0
mem_efree_count0
mem_efree_amount0
mem_malloc_count0
mem_malloc_amount0
mem_calloc_count0
mem_calloc_amount0
mem_realloc_count0
mem_realloc_amount0
mem_free_count0
mem_free_amount0
mem_estrndup_count0
mem_strndup_count0
mem_estrdup_count0
mem_strdup_count0
mem_edupl_count0
mem_dupl_count0
proto_text_fetched_null0
proto_text_fetched_bit0
proto_text_fetched_tinyint0
proto_text_fetched_short0
proto_text_fetched_int240
proto_text_fetched_int0
proto_text_fetched_bigint0
proto_text_fetched_decimal0
proto_text_fetched_float0
proto_text_fetched_double0
proto_text_fetched_date0
proto_text_fetched_year0
proto_text_fetched_time0
proto_text_fetched_datetime0
proto_text_fetched_timestamp0
proto_text_fetched_string0
proto_text_fetched_blob0
proto_text_fetched_enum0
proto_text_fetched_set0
proto_text_fetched_geometry0
proto_text_fetched_other0
proto_binary_fetched_null0
proto_binary_fetched_bit949
proto_binary_fetched_tinyint0
proto_binary_fetched_short262
proto_binary_fetched_int24176
proto_binary_fetched_int0
proto_binary_fetched_bigint1723
proto_binary_fetched_decimal47
proto_binary_fetched_float0
proto_binary_fetched_double52
proto_binary_fetched_date0
proto_binary_fetched_year0
proto_binary_fetched_time0
proto_binary_fetched_datetime0
proto_binary_fetched_timestamp0
proto_binary_fetched_string0
proto_binary_fetched_json749
proto_binary_fetched_blob269
proto_binary_fetched_enum0
proto_binary_fetched_set0
proto_binary_fetched_geometry0
proto_binary_fetched_other0
init_command_executed_count0
init_command_failed_count0
com_quit0
com_init_db0
com_query2
com_field_list0
com_create_db0
com_drop_db0
com_refresh0
com_shutdown0
com_statistics0
com_process_info0
com_connect0
com_process_kill0
com_debug0
com_ping0
com_time0
com_delayed_insert0
com_change_user0
com_binlog_dump0
com_table_dump0
com_connect_out0
com_register_slave0
com_stmt_prepare21
com_stmt_execute21
com_stmt_send_long_data0
com_stmt_close20
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps308728