Page Time: 0.8004s

Memory: 6.1812 MB (Peak: 6.3327 MB)

Queries (13, time: 0.5653s, 70.6%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000118
    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 258
    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_member_stat`.*
    FROM `xf_member_stat`
    LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_member_stat`.`addon_id`)
    WHERE (`xf_member_stat`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_member_stat`.`addon_id` = ''))
    ORDER BY `xf_member_stat`.`display_order` ASC
    Run Time: 0.000153
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_member_statALL    6Using where; Using filesort
    SIMPLExf_addon_AddOn_1eq_refPRIMARYPRIMARY52cmclubcom_xf2xx.xf_member_stat.addon_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 1428
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 60
    4. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    5. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
    6. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    7. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    8. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    9. XF\App->run() in src/XF.php at line 524
    10. XF::runApp() in index.php at line 20
  3. SELECT user_id
    FROM xf_user
    WHERE question_solution_count > 0
    LIMIT 1
    Run Time: 0.000078
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userrangequestion_solution_countquestion_solution_count4 1Using where; Using index

    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/MemberStat/Solutions.php at line 11
    4. XF\MemberStat\Solutions::isVisible() in src/XF/Entity/MemberStat.php at line 60
    5. XF\Entity\MemberStat->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 328
    6. XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
    7. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
    8. XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 325
    9. XF\Mvc\Entity\AbstractCollection->filterViewable() in src/XF/Pub/Controller/Member.php at line 61
    10. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
    12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    15. XF\App->run() in src/XF.php at line 524
    16. XF::runApp() in index.php at line 20
  4. SELECT `xf_user`.*
    FROM `xf_user`
    
    WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`message_count` > 0) OR (`xf_user`.`message_count` < 0))
    ORDER BY `xf_user`.`message_count` DESC
    
    LIMIT 60
    Run Time: 0.000246
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userrangeuser_state,message_countmessage_count4 20135Using 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 1428
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 236
    4. XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
    5. XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
    6. XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 124
    7. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
    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
  5. SELECT `xf_user`.*
    FROM `xf_user`
    
    WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`reaction_score` > 0) OR (`xf_user`.`reaction_score` < 0))
    ORDER BY `xf_user`.`reaction_score` DESC
    
    LIMIT 60
    Run Time: 0.000222
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userrangeuser_state,reaction_scorereaction_score4 38Using 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 1428
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 236
    4. XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
    5. XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
    6. XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 124
    7. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
    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
  6. SELECT `xf_user`.*
    FROM `xf_user`
    
    WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`trophy_points` > 0) OR (`xf_user`.`trophy_points` < 0))
    ORDER BY `xf_user`.`trophy_points` DESC
    
    LIMIT 60
    Run Time: 0.000269
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userrangeuser_state,trophy_pointstrophy_points4 20135Using 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 1428
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 236
    4. XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
    5. XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
    6. XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 124
    7. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
    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 `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.*
    FROM `xf_user`
    INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`)
    INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
    WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user_profile_Profile_1`.`dob_day` = 29) AND (`xf_user_profile_Profile_1`.`dob_month` = 3) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1680124914) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
    ORDER BY `xf_user`.`username` ASC
    
    LIMIT 60
    Run Time: 0.562518
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_user_profile_Profile_1refPRIMARY,dobdob2const,const84Using temporary; Using filesort
    SIMPLExf_user_option_Option_2eq_refPRIMARYPRIMARY4cmclubcom_xf2xx.xf_user_profile_Profile_1.user_id1Using where
    SIMPLExf_usereq_refPRIMARY,user_state,last_activityPRIMARY4cmclubcom_xf2xx.xf_user_profile_Profile_1.user_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 1428
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/MemberStat/Birthdays.php at line 14
    4. XF\MemberStat\Birthdays::getBirthdayUsers() in src/XF/Service/MemberStat/Preparer.php at line 145
    5. XF\Service\MemberStat\Preparer->applyCallback() in src/XF/Service/MemberStat/Preparer.php at line 208
    6. XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
    7. XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
    8. XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 124
    9. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
    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
  8. SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.*
    FROM `xf_user`
    INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
    INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`)
    WHERE (`xf_user`.`user_id` IN (138357, 11464, 64391, 15803, 169486, 39, 7, 172810, 149526, 25074, 140950, 1, 56, 2631, 172507, 123036, 48796, 162333, 51983, 84684, 170407, 114527, 173111, 170620, 163198, 36870, 49252, 118172, 137849, 95017, 66392, 67462, 172479, 17603, 138470, 14629, 44529, 61198, 158053, 163628, 170308, 56611, 131818, 62136, 52305, 30753, 154620, 152806, 144995, 144419, 143346, 142061, 141362, 141323, 140959, 140781, 137681, 135194, 134767, 133876, 131217, 130514, 129470, 128394, 127635, 127354, 126935, 126836, 126241, 125617, 123733, 122812, 120826, 119727, 118786, 116727, 114774, 114325, 113987, 113862, 113560, 112314, 112053, 111917, 109326, 109010, 106591, 105819, 105458, 104086, 102935, 102090, 102016, 101981, 101859, 101180, 100501, 100372, 99257, 136411, 2, 1541, 164927, 126629, 301, 164987, 162716, 154132, 146970, 143864, 135961, 131586, 98381, 95909, 74837, 73205, 72125, 67639, 66791, 65944, 64956, 63970, 61742, 59738, 59063, 46885, 40100, 7447, 168, 21790, 42424, 11413, 58926, 888, 7777, 8410, 6, 1299, 58107, 29845, 4665, 26026, 44743, 85335, 1315, 78275, 2954, 27267, 21572, 31122, 19646, 743, 3123, 19191, 69546, 4672, 180, 12191, 171, 2800, 15240, 42414, 36429, 285, 13131, 284, 4, 23077, 802, 124844, 1820, 9999, 1546, 1405, 127442, 1857, 5, 11512, 74137, 79610, 25042, 10924, 805, 6568, 19240)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
    Run Time: 0.000551
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userrangePRIMARY,user_stateuser_state5 185Using index condition; Using where
    SIMPLExf_user_option_Option_1eq_refPRIMARYPRIMARY4cmclubcom_xf2xx.xf_user.user_id1 
    SIMPLExf_user_profile_Profile_2eq_refPRIMARYPRIMARY4cmclubcom_xf2xx.xf_user.user_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 1428
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 134
    4. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    5. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
    6. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    7. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    8. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    9. XF\App->run() in src/XF.php at line 524
    10. XF::runApp() in index.php at line 20
  9. SELECT view_date
    FROM xf_session_activity
    WHERE user_id = ? AND unique_key = ?
    Params: 0, ,�(a
    Run Time: 0.000430
    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 130
    4. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 48
    5. XenConcept\LoginAsUser\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
    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 258
    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
  10. -- 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: ,�(a, XF\Pub\Controller\Member, Index, valid, , 1711660914, , 0, ,�(a
    Run Time: 0.000202

    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 218
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 48
    4. XenConcept\LoginAsUser\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
    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 258
    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
  11. SELECT view_date
    FROM xf_session_activity
    WHERE user_id = ? AND unique_key = ?
    Params: 0, ,�(a
    Run Time: 0.000201
    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 130
    4. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 53
    5. XenConcept\LoginAsUser\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
    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 258
    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
  12. SELECT `xf_user`.*
    FROM `xf_user`
    
    WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
    ORDER BY `xf_user`.`register_date` DESC
    
    LIMIT 12
    Run Time: 0.000235
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userindexuser_stateregister_date4 24Using 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 1428
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewestMembers.php at line 24
    4. XF\Widget\NewestMembers->render() in internal_data/code_cache/widgets/_2_member_wrapper_newest_members.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/l5/s76/public/member_wrapper.php at line 39
    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
  13. SELECT `xf_addon`.*
    FROM `xf_addon`
    
    WHERE (`xf_addon`.`addon_id` = 'Tapatalk')
    
    
    LIMIT 1
    Run Time: 0.000103
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_addonconstPRIMARYPRIMARY52const1 

    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 1395
    3. XF\Mvc\Entity\Finder->fetchOne() in src/addons/Tapatalk/Listener/Hook.php at line 22
    4. Tapatalk\Listener\Hook::templateHook() in src/XF/Extension.php at line 49
    5. XF\Extension->fire() in src/XF/App.php at line 2994
    6. XF\App->fire() in src/XF/Template/Templater.php at line 1614
    7. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    8. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
    9. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    10. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    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

Included Files (226, 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/symfony/polyfill-mbstring/Resources/mb_convert_variables.php8
  15. src/vendor/ralouphie/getallheaders/src/getallheaders.php
  16. src/vendor/guzzlehttp/promises/src/functions_include.php
  17. src/vendor/guzzlehttp/promises/src/functions.php
  18. src/vendor/guzzlehttp/psr7/src/functions_include.php
  19. src/vendor/guzzlehttp/psr7/src/functions.php
  20. src/vendor/guzzlehttp/guzzle/src/functions_include.php
  21. src/vendor/guzzlehttp/guzzle/src/functions.php
  22. src/vendor/paragonie/sodium_compat/autoload.php
  23. src/vendor/paragonie/sodium_compat/autoload-php7.php
  24. src/vendor/paragonie/sodium_compat/src/Compat.php
  25. src/vendor/paragonie/sodium_compat/lib/namespaced.php
  26. src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
  27. src/vendor/paragonie/sodium_compat/lib/constants.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/addons/SV/RedisCache/Redis.php
  45. src/addons/SV/RedisCache/DoctrineCache/Redis.php
  46. src/addons/SV/RedisCache/DoctrineCache/CacheProvider.php
  47. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  48. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  49. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  50. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  51. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  52. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
  53. src/addons/SV/RedisCache/Traits/Cm_Cache_Backend_Redis.php
  54. src/addons/SV/RedisCache/Credis/Client.php
  55. src/addons/SV/RedisCache/Credis/Sentinel.php
  56. src/addons/SV/RedisCache/Traits/CacheTiming.php
  57. src/addons/SV/RedisCache/Traits/ReplicaSelect.php
  58. src/addons/SV/RedisCache/Globals.php
  59. src/XF/Extension.php
  60. src/XF/AddOn/Manager.php
  61. src/addons/SV/StandardLib/XF/AddOn/Manager.php
  62. src/XF/ComposerAutoload.php
  63. src/addons/ThemeHouse/Holidays/vendor/composer/autoload_namespaces.php
  64. src/addons/ThemeHouse/Holidays/vendor/composer/autoload_psr4.php
  65. src/addons/ThemeHouse/Holidays/vendor/composer/autoload_classmap.php
  66. src/addons/ThemeHouse/Holidays/vendor/composer/autoload_files.php
  67. src/addons/ThemeHouse/Holidays/vendor/symfony/polyfill-php80/bootstrap.php
  68. src/addons/ThemeHouse/Holidays/vendor/symfony/translation/Resources/functions.php
  69. src/addons/ThemeHouse/Holidays/vendor/roukmoute/polyfill-calendar/runtime/bootstrap.php
  70. src/addons/SV/RedisCache/Listener.php
  71. src/addons/SV/RedisCache/ContainerExtractor.php
  72. src/addons/KL/EditorManager/Listener/AppSetup.php
  73. src/addons/KL/EditorManager/EditorConfig.php
  74. src/addons/XenConcept/LoginAsUser/Listener/Listener.php
  75. src/addons/SV/StandardLib/XF/InputFilterer.php
  76. src/XF/Session/Session.php
  77. src/XF/Session/DbStorage.php
  78. src/XF/Session/StorageInterface.php
  79. src/XF/Util/Ip.php
  80. src/XF/Util/Random.php
  81. src/XF/Http/Response.php
  82. src/XF/Mvc/Entity/Manager.php
  83. src/XF/Mvc/Entity/ValueFormatter.php
  84. src/XF/Repository/User.php
  85. src/XF/Mvc/Entity/Repository.php
  86. src/addons/Tapatalk/XF/Repository/User.php
  87. src/XF/Entity/User.php
  88. src/XF/Mvc/Entity/Entity.php
  89. src/XF/Entity/LinkableInterface.php
  90. src/addons/DL6/bannedavatar/XF/Entity/User.php
  91. src/addons/ForoAgency/ColoredUsername/XF/Entity/User.php
  92. src/addons/OzzModz/GoogleSearch/XF/Entity/User.php
  93. src/addons/XenConcept/LoginAsUser/XF/Entity/User.php
  94. src/addons/SV/AdvancedBbCodesPack/XF/Entity/User.php
  95. src/XF/Mvc/Entity/Structure.php
  96. src/addons/X0815/Watermarker/Listener.php
  97. src/addons/AwesomeForo/FakeOnline/Listener/EntityStructure.php
  98. src/XF/Entity/UserAuth.php
  99. src/XF/Entity/UserOption.php
  100. src/addons/KL/EditorManager/XF/Entity/UserOption.php
  101. src/addons/ThemeHouse/Holidays/Listener/EntityStructure.php
  102. src/XF/Entity/UserProfile.php
  103. src/addons/KL/EditorManager/XF/Entity/UserProfile.php
  104. src/XF/Entity/UserPrivacy.php
  105. src/XF/Util/File.php
  106. src/XF/Language.php
  107. src/XF/Mvc/Dispatcher.php
  108. src/XF/Mvc/Router.php
  109. src/addons/XF301VB/Mvc/Router.php
  110. src/addons/SV/StandardLib/XF/Mvc/Router.php
  111. src/addons/SV/StandardLib/Repository/LinkBuilder.php
  112. src/XF/Mvc/RouteMatch.php
  113. src/XF/Util/Arr.php
  114. src/XF/Mvc/ParameterBag.php
  115. src/XF/Pub/Controller/Member.php
  116. src/XF/Pub/Controller/AbstractController.php
  117. src/XF/Mvc/Controller.php
  118. src/addons/AwesomeForo/FakeOnline/XF/Pub/Controller/Member.php
  119. src/XF/Util/Php.php
  120. src/XF/PermissionCache.php
  121. src/XF/PermissionSet.php
  122. src/XF/Db/Mysqli/Statement.php
  123. src/XF/Db/AbstractStatement.php
  124. src/XF/Repository/MemberStat.php
  125. src/XF/Entity/MemberStat.php
  126. src/XF/Finder/MemberStat.php
  127. src/XF/Mvc/Entity/Finder.php
  128. src/XF/Entity/AddOn.php
  129. src/XF/Mvc/Entity/ArrayCollection.php
  130. src/XF/Mvc/Entity/AbstractCollection.php
  131. src/XF/MemberStat/TrophyPoints.php
  132. src/XF/MemberStat/Solutions.php
  133. src/XF/Finder/User.php
  134. src/XF/Service/MemberStat/Preparer.php
  135. src/XF/Service/AbstractService.php
  136. src/XF/Searcher/User.php
  137. src/XF/Searcher/AbstractSearcher.php
  138. src/XF/Phrase.php
  139. src/XF/MemberStat/Birthdays.php
  140. src/XF/Mvc/Reply/View.php
  141. src/XF/Mvc/Reply/AbstractReply.php
  142. src/XF/Repository/SessionActivity.php
  143. src/addons/SV/RedisCache/XF/Repository/SessionActivity.php
  144. src/addons/SyTryC/CountRobots/Repository/SessionActivity.php
  145. src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php
  146. src/XF/Data/Robot.php
  147. src/addons/Tapatalk/Listener/ControllerPostDispatch.php
  148. src/XF/Style.php
  149. src/XF/Template/Templater.php
  150. src/addons/SV/MultiPrefix/XF/Template/Templater.php
  151. src/addons/DohTheme/Core/XF/Template/Templater.php
  152. src/addons/KL/EditorManager/XF/Template/Templater.php
  153. src/addons/LiamW/AllRichUsernames/XF/Template/Templater.php
  154. src/addons/SV/AdvancedBbCodesPack/XF/Template/Templater.php
  155. src/XF/DevelopmentOutput.php
  156. src/XF/DevelopmentOutput/Template.php
  157. src/XF/DevelopmentOutput/AbstractHandler.php
  158. src/XF/Template/WatcherInterface.php
  159. src/XF/SubContainer/BbCode.php
  160. src/XF/SubContainer/AbstractSubContainer.php
  161. src/XF/SubContainer/Widget.php
  162. src/addons/AwesomeForo/AwesomeCore/Listener.php
  163. src/addons/SV/StandardLib/TemplaterHelper.php
  164. src/addons/SV/StandardLib/Helper.php
  165. src/addons/SV/StandardLib/TemplaterAccess.php
  166. src/XF/CookieConsent.php
  167. src/XF/Captcha/Turnstile.php
  168. src/XF/Captcha/AbstractCaptcha.php
  169. src/XF/Repository/Payment.php
  170. src/XF/SimpleCache.php
  171. src/XF/Mvc/Renderer/Html.php
  172. src/XF/Mvc/Renderer/AbstractRenderer.php
  173. src/XF/Mvc/View.php
  174. src/XF/Template/Template.php
  175. src/addons/Tapatalk/Listener/Hook.php
  176. src/addons/KL/EditorManager/Listener/TemplaterTemplatePreRender.php
  177. internal_data/code_cache/templates/l5/s76/public/member_notable.php
  178. src/XF/PreEscaped.php
  179. internal_data/code_cache/templates/l5/s76/public/metadata_macros.php
  180. src/XF/Template/MacroState.php
  181. internal_data/code_cache/phrase_groups/l5/member_stat.php
  182. internal_data/code_cache/templates/l5/s76/public/member_wrapper.php
  183. internal_data/code_cache/widgets/_1_member_wrapper_find_member.php
  184. src/XF/Widget/WidgetConfig.php
  185. src/XF/Widget/FindMember.php
  186. src/XF/Widget/AbstractWidget.php
  187. internal_data/code_cache/phrase_groups/l5/widget.php
  188. internal_data/code_cache/phrase_groups/l5/widget_def.php
  189. src/XF/Widget/WidgetRenderer.php
  190. internal_data/code_cache/templates/l5/s76/public/widget_find_member.php
  191. src/addons/Tapatalk/Listener/TemplatePostRender.php
  192. internal_data/code_cache/widgets/_2_member_wrapper_newest_members.php
  193. src/XF/Widget/NewestMembers.php
  194. internal_data/code_cache/templates/l5/s76/public/widget_newest_members.php
  195. internal_data/code_cache/navigation_cache.php
  196. src/XF/NoticeList.php
  197. internal_data/code_cache/templates/l5/s76/public/notice_cookies.php
  198. src/XF/Criteria/User.php
  199. src/XF/Criteria/AbstractCriteria.php
  200. src/XF/Criteria/Page.php
  201. src/addons/ThemeHouse/Holidays/Listener/AppPubRenderPage.php
  202. src/XF/Repository/AddOn.php
  203. src/addons/Tapatalk/XF/Repository/AddOn.php
  204. mobiquo/smartbanner/head.inc.php
  205. src/addons/KL/EditorManager/Entity/Font.php
  206. src/addons/XENTR/Fantastic/Listener.php
  207. src/addons/XENTR/Revolution/Listener.php
  208. internal_data/code_cache/templates/l5/s76/public/PAGE_CONTAINER.php
  209. src/XF/Str/Formatter.php
  210. src/addons/KL/EditorManager/XF/Str/Formatter.php
  211. src/addons/Tapatalk/XF/Str/Formatter.php
  212. src/addons/SV/AdvancedBbCodesPack/XF/Str/Formatter.php
  213. internal_data/code_cache/templates/l5/s76/public/helper_js_global.php
  214. internal_data/code_cache/templates/l5/s76/public/font_awesome_setup.php
  215. internal_data/code_cache/templates/l5/s76/public/google_analytics.php
  216. internal_data/code_cache/templates/l5/s76/public/kl_em_PAGE_CONTAINER.php
  217. internal_data/code_cache/templates/l5/s76/public/xc_login_as_user_staff_bar.php
  218. internal_data/code_cache/phrase_groups/l5/nav.php
  219. internal_data/code_cache/templates/l5/s76/public/ozzmodz_googlesearch_google_search_menu.php
  220. internal_data/code_cache/phrase_groups/l5/button.php
  221. internal_data/code_cache/templates/l5/s76/public/_ads.php
  222. internal_data/code_cache/templates/l5/s76/public/notice_macros.php
  223. internal_data/code_cache/templates/l5/s76/public/browser_warning_macros.php
  224. internal_data/code_cache/templates/l5/s76/public/debug_macros.php
  225. src/XF/Debugger.php
  226. src/addons/SV/RedisCache/XF/Debugger.php

DB Connection Stats

bytes_sent10613
bytes_received279504
packets_sent154
packets_received1632
protocol_overhead_in6528
protocol_overhead_out616
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet495
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet194
bytes_received_prepare_response_packet83093
bytes_received_change_user_packet195098
packets_sent_command76
packets_received_ok0
packets_received_eof0
packets_received_rset_header55
packets_received_rset_field_meta0
packets_received_rset_row27
packets_received_prepare_response1091
packets_received_change_user432
result_set_queries24
non_result_set_queries3
no_index_used1
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets24
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed24
rows_fetched_from_server_normal0
rows_fetched_from_server_ps408
rows_buffered_from_client_normal0
rows_buffered_from_client_ps408
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_ps0
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_result23
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_bit1101
proto_binary_fetched_tinyint0
proto_binary_fetched_short6929
proto_binary_fetched_int242117
proto_binary_fetched_int0
proto_binary_fetched_bigint11821
proto_binary_fetched_decimal17
proto_binary_fetched_float0
proto_binary_fetched_double0
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_json4902
proto_binary_fetched_blob2128
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_prepare25
com_stmt_execute25
com_stmt_send_long_data0
com_stmt_close24
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps181830

Redis Connection stats (6, time: 0.0153s, 1.6%)

main

gets6
gets.time0.01525436
sets0
sets.time0
deletes0
deletes.time0
flushes0
flushes.time0
bytes_sent0
bytes_received204302
time_compression0
time_decompression0.008562561
time_encoding0
time_decoding0.005068313