Page Time: 0.0454s

Memory: 8.1332 MB (Peak: 8.9030 MB)

Queries (30, time: 0.0072s, 15.8%)

  1. DELETE  FROM `xf_dbtech_security_session` WHERE last_activity_date < ?
    Params: 1608194000
    Run Time: 0.000295

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 289
    3. XF\Db\AbstractAdapter->delete() in src/addons/DBTech/Security/Repository/Session.php at line 38
    4. DBTech\Security\Repository\Session->deleteOldSessions() in src/addons/DBTech/Security/XF/Session/Session.php at line 17
    5. DBTech\Security\XF\Session\Session->start() in src/XF/App.php at line 860
    6. XF\App->XF\{closure}() in src/XF/Container.php at line 28
    7. XF\Container->offsetGet() in src/XF/Pub/App.php at line 45
    8. XF\Pub\App->XF\Pub\{closure}() in src/XF/Container.php at line 28
    9. XF\Container->offsetGet() in src/XF/App.php at line 2636
    10. XF\App->session() in src/XF/Pub/App.php at line 150
    11. XF\Pub\App->start() in src/XF/App.php at line 2296
    12. XF\App->run() in src/XF.php at line 488
    13. XF::runApp() in index.php at line 20
  2. SELECT `xf_dbtech_security_session`.*
FROM `xf_dbtech_security_session`

WHERE (`xf_dbtech_security_session`.`session_id` = 'ec73a4604064b3a5372ccfd167c4ff7a')


LIMIT 1
    Run Time: 0.000077
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_security_sessionconstPRIMARYPRIMARY34const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Entity.php at line 806
    4. XF\Mvc\Entity\Entity->_verifyUniqueValue() in src/XF/Mvc/Entity/Entity.php at line 662
    5. XF\Mvc\Entity\Entity->set() in src/XF/Mvc/Entity/Entity.php at line 567
    6. XF\Mvc\Entity\Entity->__set() in src/addons/DBTech/Security/Repository/Session.php at line 71
    7. DBTech\Security\Repository\Session->createSession() in src/addons/DBTech/Security/Listener.php at line 87
    8. DBTech\Security\Listener::appPubStartEnd()
    9. call_user_func_array() in src/XF/Extension.php at line 67
    10. XF\Extension->fire() in src/XF/App.php at line 2797
    11. XF\App->fire() in src/XF/Pub/App.php at line 199
    12. XF\Pub\App->start() in src/XF/App.php at line 2296
    13. XF\App->run() in src/XF.php at line 488
    14. XF::runApp() in index.php at line 20
  3. BEGIN
    Run Time: 0.000026

    1. XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 381
    2. XF\Db\AbstractAdapter->beginTransaction() in src/XF/Mvc/Entity/Entity.php at line 1235
    3. XF\Mvc\Entity\Entity->save() in src/addons/DBTech/Security/Repository/Session.php at line 74
    4. DBTech\Security\Repository\Session->createSession() in src/addons/DBTech/Security/Listener.php at line 87
    5. DBTech\Security\Listener::appPubStartEnd()
    6. call_user_func_array() in src/XF/Extension.php at line 67
    7. XF\Extension->fire() in src/XF/App.php at line 2797
    8. XF\App->fire() in src/XF/Pub/App.php at line 199
    9. XF\Pub\App->start() in src/XF/App.php at line 2296
    10. XF\App->run() in src/XF.php at line 488
    11. XF::runApp() in index.php at line 20
  4. INSERT  INTO `xf_dbtech_security_session` (`session_id`, `user_id`, `user_agent`, `start_date`, `last_activity_date`) VALUES (?, ?, ?, ?, ?)
    Params: ec73a4604064b3a5372ccfd167c4ff7a, 0, CCBot/2.0 (https://commoncrawl.org/faq/), 1610786000, 1610786000
    Run Time: 0.000066

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
    3. XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
    4. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
    5. XF\Mvc\Entity\Entity->save() in src/addons/DBTech/Security/Repository/Session.php at line 74
    6. DBTech\Security\Repository\Session->createSession() in src/addons/DBTech/Security/Listener.php at line 87
    7. DBTech\Security\Listener::appPubStartEnd()
    8. call_user_func_array() in src/XF/Extension.php at line 67
    9. XF\Extension->fire() in src/XF/App.php at line 2797
    10. XF\App->fire() in src/XF/Pub/App.php at line 199
    11. XF\Pub\App->start() in src/XF/App.php at line 2296
    12. XF\App->run() in src/XF.php at line 488
    13. XF::runApp() in index.php at line 20
  5. COMMIT
    Run Time: 0.000123

    1. XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 403
    2. XF\Db\AbstractAdapter->commit() in src/XF/Mvc/Entity/Entity.php at line 1286
    3. XF\Mvc\Entity\Entity->save() in src/addons/DBTech/Security/Repository/Session.php at line 74
    4. DBTech\Security\Repository\Session->createSession() in src/addons/DBTech/Security/Listener.php at line 87
    5. DBTech\Security\Listener::appPubStartEnd()
    6. call_user_func_array() in src/XF/Extension.php at line 67
    7. XF\Extension->fire() in src/XF/App.php at line 2797
    8. XF\App->fire() in src/XF/Pub/App.php at line 199
    9. XF\Pub\App->start() in src/XF/App.php at line 2296
    10. XF\App->run() in src/XF.php at line 488
    11. XF::runApp() in index.php at line 20
  6. SELECT `xf_nf_tickets_status`.*
FROM `xf_nf_tickets_status`

WHERE (`xf_nf_tickets_status`.`active` = 1) AND (`xf_nf_tickets_status`.`include_in_counts` = 1)
ORDER BY `xf_nf_tickets_status`.`display_order` ASC
    Run Time: 0.000092
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nf_tickets_statusALL    4Using where; Using filesort

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/NF/Tickets/Finder/Ticket.php at line 121
    4. NF\Tickets\Finder\Ticket->isCounted() in src/addons/NF/Tickets/Listener.php at line 63
    5. NF\Tickets\Listener::appPubStartEnd()
    6. call_user_func_array() in src/XF/Extension.php at line 67
    7. XF\Extension->fire() in src/XF/App.php at line 2797
    8. XF\App->fire() in src/XF/Pub/App.php at line 199
    9. XF\Pub\App->start() in src/XF/App.php at line 2296
    10. XF\App->run() in src/XF.php at line 488
    11. XF::runApp() in index.php at line 20
  7. SELECT `xf_nf_tickets_ticket`.*
FROM `xf_nf_tickets_ticket`

WHERE (`xf_nf_tickets_ticket`.`status_id` IN (1, 2))
    Run Time: 0.000165
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nf_tickets_ticketALL    66Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/NF/Tickets/Listener.php at line 63
    4. NF\Tickets\Listener::appPubStartEnd()
    5. call_user_func_array() in src/XF/Extension.php at line 67
    6. XF\Extension->fire() in src/XF/App.php at line 2797
    7. XF\App->fire() in src/XF/Pub/App.php at line 199
    8. XF\Pub\App->start() in src/XF/App.php at line 2296
    9. XF\App->run() in src/XF.php at line 488
    10. XF::runApp() in index.php at line 20
  8. SELECT `xf_nf_tickets_category`.*
FROM `xf_nf_tickets_category`

WHERE (`xf_nf_tickets_category`.`ticket_category_id` = 3)


LIMIT 1
    Run Time: 0.000090
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nf_tickets_categoryconstPRIMARY,parent_category_id_lftPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
    4. XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
    5. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 394
    6. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 186
    7. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
    8. XF\Mvc\Entity\Entity->__get() in src/addons/NF/Tickets/Entity/Ticket.php at line 183
    9. NF\Tickets\Entity\Ticket->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 320
    10. XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
    11. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 189
    12. XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 321
    13. XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/NF/Tickets/Listener.php at line 63
    14. NF\Tickets\Listener::appPubStartEnd()
    15. call_user_func_array() in src/XF/Extension.php at line 67
    16. XF\Extension->fire() in src/XF/App.php at line 2797
    17. XF\App->fire() in src/XF/Pub/App.php at line 199
    18. XF\Pub\App->start() in src/XF/App.php at line 2296
    19. XF\App->run() in src/XF.php at line 488
    20. XF::runApp() in index.php at line 20
  9. SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
    Params: 1, nf_tickets_category, 3
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/addons/NF/Tickets/XF/Entity/User.php at line 108
    6. NF\Tickets\XF\Entity\User->hasTicketCategoryPermission() in src/addons/NF/Tickets/Entity/Category.php at line 186
    7. NF\Tickets\Entity\Category->hasPermission() in src/addons/NF/Tickets/Entity/Category.php at line 112
    8. NF\Tickets\Entity\Category->canView() in src/addons/NF/Tickets/Entity/Ticket.php at line 183
    9. NF\Tickets\Entity\Ticket->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 320
    10. XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
    11. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 189
    12. XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 321
    13. XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/NF/Tickets/Listener.php at line 63
    14. NF\Tickets\Listener::appPubStartEnd()
    15. call_user_func_array() in src/XF/Extension.php at line 67
    16. XF\Extension->fire() in src/XF/App.php at line 2797
    17. XF\App->fire() in src/XF/Pub/App.php at line 199
    18. XF\Pub\App->start() in src/XF/App.php at line 2296
    19. XF\App->run() in src/XF.php at line 488
    20. XF::runApp() in index.php at line 20
  10. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000061
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1176
    6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 242
    7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
    8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
    9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 349
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    14. XF\App->run() in src/XF.php at line 488
    15. XF::runApp() in index.php at line 20
  11. SELECT `xf_user`.*, `xf_user_privacy_Privacy_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_1` ON (`xf_user_privacy_Privacy_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` = '9825')


LIMIT 1
    Run Time: 0.000399
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLExf_user_privacy_Privacy_1constPRIMARYPRIMARY4const1 
    SIMPLExf_user_option_Option_2constPRIMARYPRIMARY4const1 
    SIMPLExf_user_profile_Profile_3constPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
    4. XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Member.php at line 1209
    5. XF\Pub\Controller\Member->assertViewableUser() in src/addons/SV/WarningImprovements/XF/Pub/Controller/Member.php at line 125
    6. SV\WarningImprovements\XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 330
    7. XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    12. XF\App->run() in src/XF.php at line 488
    13. XF::runApp() in index.php at line 20
  12. SELECT `xf_user_follow`.*, `xf_user_FollowUser_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_option_Option_3`.*
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_FollowUser_1` ON (`xf_user_FollowUser_1`.`user_id` = `xf_user_follow`.`follow_user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_FollowUser_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_FollowUser_1`.`user_id`)
WHERE (`xf_user_FollowUser_1`.`is_banned` = 0) AND (`xf_user_FollowUser_1`.`user_state` = 'valid') AND (`xf_user_follow`.`user_id` = 9825)
ORDER BY RAND() ASC

LIMIT 12
    Run Time: 0.000481
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_user_followrefPRIMARY,follow_user_idPRIMARY4const2Using temporary; Using filesort
    SIMPLExf_user_profile_Profile_2eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_user_follow.follow_user_id1 
    SIMPLExf_user_FollowUser_1eq_refPRIMARY,user_statePRIMARY4rdforum_xenforo.xf_user_follow.follow_user_id1Using where
    SIMPLExf_user_option_Option_3eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_user_follow.follow_user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 342
    4. XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
    5. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    6. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    7. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    8. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    9. XF\App->run() in src/XF.php at line 488
    10. XF::runApp() in index.php at line 20
  13. SELECT COUNT(*)
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_FollowUser_1` ON (`xf_user_FollowUser_1`.`user_id` = `xf_user_follow`.`follow_user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_FollowUser_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_FollowUser_1`.`user_id`)
WHERE (`xf_user_FollowUser_1`.`is_banned` = 0) AND (`xf_user_FollowUser_1`.`user_state` = 'valid') AND (`xf_user_follow`.`user_id` = 9825)
    Run Time: 0.000128
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_user_followrefPRIMARY,follow_user_idPRIMARY4const2Using index
    SIMPLExf_user_profile_Profile_2eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_user_follow.follow_user_id1Using index
    SIMPLExf_user_FollowUser_1eq_refPRIMARY,user_statePRIMARY4rdforum_xenforo.xf_user_follow.follow_user_id1Using where
    SIMPLExf_user_option_Option_3eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_user_follow.follow_user_id1Using index

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1334
    4. XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/Member.php at line 343
    5. XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    10. XF\App->run() in src/XF.php at line 488
    11. XF::runApp() in index.php at line 20
  14. SELECT `xf_user_follow`.*, `xf_user_User_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_option_Option_3`.*
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_follow`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_1`.`user_id`)
WHERE (`xf_user_User_1`.`is_banned` = 0) AND (`xf_user_User_1`.`user_state` = 'valid') AND (`xf_user_follow`.`follow_user_id` = 9825)
ORDER BY RAND() ASC

LIMIT 12
    Run Time: 0.000346
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_user_followrefPRIMARY,follow_user_idfollow_user_id4const1Using temporary; Using filesort
    SIMPLExf_user_profile_Profile_2eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_user_follow.user_id1 
    SIMPLExf_user_User_1eq_refPRIMARY,user_statePRIMARY4rdforum_xenforo.xf_user_follow.user_id1Using where
    SIMPLExf_user_option_Option_3eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_user_follow.user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 349
    4. XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
    5. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    6. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    7. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    8. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    9. XF\App->run() in src/XF.php at line 488
    10. XF::runApp() in index.php at line 20
  15. SELECT COUNT(*)
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_follow`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_1`.`user_id`)
WHERE (`xf_user_User_1`.`is_banned` = 0) AND (`xf_user_User_1`.`user_state` = 'valid') AND (`xf_user_follow`.`follow_user_id` = 9825)
    Run Time: 0.000103
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_user_followrefPRIMARY,follow_user_idfollow_user_id4const1Using index
    SIMPLExf_user_profile_Profile_2eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_user_follow.user_id1Using index
    SIMPLExf_user_User_1eq_refPRIMARY,user_statePRIMARY4rdforum_xenforo.xf_user_follow.user_id1Using where
    SIMPLExf_user_option_Option_3eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_user_follow.user_id1Using index

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1334
    4. XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/Member.php at line 350
    5. XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    10. XF\App->run() in src/XF.php at line 488
    11. XF::runApp() in index.php at line 20
  16. -- 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, ׹a, ׹a, XF\Pub\Controller\Member, About, valid, user_id=9825, 1610786000, CommonCrawl
    Run Time: 0.000050

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
    4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
    5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
    6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    11. XF\App->run() in src/XF.php at line 488
    12. XF::runApp() in index.php at line 20
  17. 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.000253
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_siropu_ads_manager_adreftype,status,status_display_orderstatus_display_order102const1Using where
    SIMPLExf_siropu_ads_manager_package_Package_1eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_siropu_ads_manager_ad.package_id1 
    SIMPLExf_template_MasterTemplate_2eq_reftype_title_style_idtype_title_style_id128const,func,const1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 501
    4. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 336
    5. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 327
    6. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
    7. Siropu\AdsManager\Listener::templaterGlobalData()
    8. call_user_func_array() in src/XF/Extension.php at line 67
    9. XF\Extension->fire() in src/XF/App.php at line 2797
    10. XF\App->fire() in src/XF/App.php at line 2032
    11. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1903
    12. XF\App->preRender() in src/XF/Pub/App.php at line 448
    13. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
    14. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    16. XF\App->run() in src/XF.php at line 488
    17. XF::runApp() in index.php at line 20
  18. SELECT `xf_siropu_ads_manager_click_fraud`.*
FROM `xf_siropu_ads_manager_click_fraud`

WHERE (`xf_siropu_ads_manager_click_fraud`.`ad_id` = 18 AND `xf_siropu_ads_manager_click_fraud`.`ip` = '׹a')


LIMIT 1
    Run Time: 0.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 168
    4. XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 482
    5. Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 425
    6. Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 504
    7. Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
    8. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 189
    9. XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 509
    10. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 336
    11. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 327
    12. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
    13. Siropu\AdsManager\Listener::templaterGlobalData()
    14. call_user_func_array() in src/XF/Extension.php at line 67
    15. XF\Extension->fire() in src/XF/App.php at line 2797
    16. XF\App->fire() in src/XF/App.php at line 2032
    17. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1903
    18. XF\App->preRender() in src/XF/Pub/App.php at line 448
    19. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
    20. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    21. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    22. XF\App->run() in src/XF.php at line 488
    23. XF::runApp() in index.php at line 20
  19. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 1496
    Run Time: 0.000061
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1176
    6. XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 942
    7. XF\Entity\User->canReceiveConversation() in src/XF/Entity/User.php at line 922
    8. XF\Entity\User->canStartConversationWith()
    9. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    10. XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s59/public/member_about.php at line 118
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1626
    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 48
    14. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    15. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    16. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    17. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    19. XF\App->run() in src/XF.php at line 488
    20. XF::runApp() in index.php at line 20
  20. SELECT `xf_node`.*
FROM `xf_node`

WHERE (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
    Run Time: 0.000464
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_noderefdisplay_in_listdisplay_in_list1const141 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Node.php at line 17
    4. XF\Repository\Node->getNodeList() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 22
    5. XFA\ForumSales\XF\Entity\User->canSellItem()
    6. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    7. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 415
    8. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    9. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    10. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    11. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    12. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    15. XF\App->run() in src/XF.php at line 488
    16. XF::runApp() in index.php at line 20
  21. SELECT `xf_category`.*, `xf_node_Node_1`.*
FROM `xf_category`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
WHERE (`xf_category`.`node_id` IN (50, 109, 180, 4, 36, 99, 146, 147, 270, 23, 48, 259, 44, 27, 209))
    Run Time: 0.000149
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_categoryindexPRIMARYPRIMARY4 19Using where; Using index
    SIMPLExf_node_Node_1eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_category.node_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 144
    5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
    6. XF\Repository\Node->getNodeList() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 22
    7. XFA\ForumSales\XF\Entity\User->canSellItem()
    8. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    9. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 415
    10. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    11. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    12. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    13. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    14. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    17. XF\App->run() in src/XF.php at line 488
    18. XF::runApp() in index.php at line 20
  22. SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*, `xf_user_LastPoster_4`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_forum`.`last_post_user_id`)
WHERE (`xf_forum`.`node_id` IN (274, 243, 269, 266, 246, 249, 276, 271, 63, 267, 282, 207, 277, 281, 258, 260, 208, 242, 199, 220, 197, 193, 254, 192, 189, 191, 190, 257, 54, 42, 179, 185, 221, 222, 234, 231, 62, 251, 5, 250, 264, 6, 37, 38, 39, 12, 225, 108, 107, 112, 58, 59, 263, 275, 55, 14, 18, 15, 273, 175, 170, 278, 163, 169, 16, 213, 17, 56, 57, 140, 22, 176, 223, 253, 21, 20, 95, 155, 25, 272, 161, 178, 142, 24, 143, 49, 40, 43, 255, 41, 232, 280, 262, 132, 11, 194, 45, 47, 46, 53, 105, 212, 183, 166, 104, 103, 35, 141, 28, 29, 67, 30, 31, 32, 33, 68, 34, 210, 268, 279, 159, 177, 171, 135, 174, 74))
    Run Time: 0.002920
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_forumALLPRIMARY   151Using where
    SIMPLExf_node_Node_1eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_forum.node_id1 
    SIMPLExf_user_LastPostUser_2eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_forum.last_post_user_id1 
    SIMPLExf_thread_LastThread_3eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_forum.last_thread_id1 
    SIMPLExf_user_LastPoster_4eq_refPRIMARYPRIMARY4rdforum_xenforo.xf_forum.last_post_user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 144
    5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
    6. XF\Repository\Node->getNodeList() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 22
    7. XFA\ForumSales\XF\Entity\User->canSellItem()
    8. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    9. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 415
    10. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    11. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    12. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    13. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    14. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    17. XF\App->run() in src/XF.php at line 488
    18. XF::runApp() in index.php at line 20
  23. SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
    Params: 1, node
    Run Time: 0.000240
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentrefPRIMARYPRIMARY31const,const248Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/PermissionCache.php at line 102
    4. XF\PermissionCache->cacheAllContentPerms() in src/XF/Entity/User.php at line 1197
    5. XF\Entity\User->cacheNodePermissions() in src/XF/Repository/Node.php at line 158
    6. XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
    7. XF\Repository\Node->getNodeList() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 22
    8. XFA\ForumSales\XF\Entity\User->canSellItem()
    9. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    10. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 415
    11. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    12. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    13. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    14. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    15. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    18. XF\App->run() in src/XF.php at line 488
    19. XF::runApp() in index.php at line 20
  24. SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
    Params: 1, node, 171
    Run Time: 0.000054
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 52
    8. XF\Entity\Node->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 320
    9. XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
    10. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 189
    11. XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 321
    12. XF\Mvc\Entity\AbstractCollection->filterViewable() in src/XF/Repository/Node.php at line 159
    13. XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
    14. XF\Repository\Node->getNodeList() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 22
    15. XFA\ForumSales\XF\Entity\User->canSellItem()
    16. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    17. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 415
    18. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    19. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    20. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    21. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    22. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    25. XF\App->run() in src/XF.php at line 488
    26. XF::runApp() in index.php at line 20
  25. SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
    Params: 1, node, 135
    Run Time: 0.000051
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 52
    8. XF\Entity\Node->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 320
    9. XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
    10. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 189
    11. XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 321
    12. XF\Mvc\Entity\AbstractCollection->filterViewable() in src/XF/Repository/Node.php at line 159
    13. XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
    14. XF\Repository\Node->getNodeList() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 22
    15. XFA\ForumSales\XF\Entity\User->canSellItem()
    16. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    17. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 415
    18. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    19. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    20. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    21. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    22. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    25. XF\App->run() in src/XF.php at line 488
    26. XF::runApp() in index.php at line 20
  26. SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
    Params: 1, node, 174
    Run Time: 0.000050
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 52
    8. XF\Entity\Node->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 320
    9. XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
    10. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 189
    11. XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 321
    12. XF\Mvc\Entity\AbstractCollection->filterViewable() in src/XF/Repository/Node.php at line 159
    13. XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
    14. XF\Repository\Node->getNodeList() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 22
    15. XFA\ForumSales\XF\Entity\User->canSellItem()
    16. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    17. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 415
    18. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    19. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    20. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    21. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    22. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    25. XF\App->run() in src/XF.php at line 488
    26. XF::runApp() in index.php at line 20
  27. SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
    Params: 1, node, 74
    Run Time: 0.000049
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 52
    8. XF\Entity\Node->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 320
    9. XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
    10. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 189
    11. XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 321
    12. XF\Mvc\Entity\AbstractCollection->filterViewable() in src/XF/Repository/Node.php at line 159
    13. XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
    14. XF\Repository\Node->getNodeList() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 22
    15. XFA\ForumSales\XF\Entity\User->canSellItem()
    16. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    17. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 415
    18. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    19. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    20. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    21. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    22. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    25. XF\App->run() in src/XF.php at line 488
    26. XF::runApp() in index.php at line 20
  28. SELECT `xfa_fss_transaction`.*, `xf_thread_Thread_1`.*
FROM `xfa_fss_transaction`
INNER JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xfa_fss_transaction`.`thread_id`)
WHERE (`xfa_fss_transaction`.`user_id` = 0) AND (`xfa_fss_transaction`.`txn_id` <> '')


LIMIT 1
    Run Time: 0.000128
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExfa_fss_transactionALL    1Using where
    SIMPLExf_thread_Thread_1eq_refPRIMARYPRIMARY4rdforum_xenforo.xfa_fss_transaction.thread_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
    3. XF\Mvc\Entity\Finder->fetchOne() in src/addons/XFA/ForumSales/XF/Entity/User.php at line 46
    4. XFA\ForumSales\XF\Entity\User->hasBoughtItem()
    5. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    6. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 427
    7. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7378
    8. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 575
    9. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 526
    10. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
    11. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
    12. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    14. XF\App->run() in src/XF.php at line 488
    15. XF::runApp() in index.php at line 20
  29. SELECT `xf_dbtech_security_watcher`.*
FROM `xf_dbtech_security_watcher`


ORDER BY `xf_dbtech_security_watcher`.`watcher_type` ASC, `xf_dbtech_security_watcher`.`priority` DESC
    Run Time: 0.000061
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_security_watcherALL    1Using filesort

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/Security/Repository/Watcher.php at line 78
    4. DBTech\Security\Repository\Watcher->getCacheData() in src/addons/DBTech/Security/Repository/Watcher.php at line 93
    5. DBTech\Security\Repository\Watcher->rebuildCache() in src/addons/DBTech/Security/Watcher/AbstractHandler.php at line 83
    6. DBTech\Security\Watcher\AbstractHandler->init() in src/addons/DBTech/Security/Watcher/ConfigTamper.php at line 25
    7. DBTech\Security\Watcher\ConfigTamper->init() in src/addons/DBTech/Security/Watcher/AbstractHandler.php at line 70
    8. DBTech\Security\Watcher\AbstractHandler->__construct() in src/addons/DBTech/Security/Repository/Watcher.php at line 65
    9. DBTech\Security\Repository\Watcher->getHandler() in src/addons/DBTech/Security/Listener.php at line 265
    10. DBTech\Security\Listener::dispatcherPostRender()
    11. call_user_func_array() in src/XF/Extension.php at line 67
    12. XF\Extension->fire() in src/XF/App.php at line 2797
    13. XF\App->fire() in src/XF/Mvc/Dispatcher.php at line 407
    14. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    16. XF\App->run() in src/XF.php at line 488
    17. XF::runApp() in index.php at line 20
  30. INSERT INTO xf_data_registry
	(data_key, data_value)
VALUES
	(?, ?)
ON DUPLICATE KEY UPDATE
	data_value = VALUES(data_value)
    Params: dbtSecurityWatchers, a:0:{}
    Run Time: 0.000057

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/DataRegistry.php at line 177
    3. XF\DataRegistry->set() in src/addons/DBTech/Security/Repository/Watcher.php at line 94
    4. DBTech\Security\Repository\Watcher->rebuildCache() in src/addons/DBTech/Security/Watcher/AbstractHandler.php at line 83
    5. DBTech\Security\Watcher\AbstractHandler->init() in src/addons/DBTech/Security/Watcher/ConfigTamper.php at line 25
    6. DBTech\Security\Watcher\ConfigTamper->init() in src/addons/DBTech/Security/Watcher/AbstractHandler.php at line 70
    7. DBTech\Security\Watcher\AbstractHandler->__construct() in src/addons/DBTech/Security/Repository/Watcher.php at line 65
    8. DBTech\Security\Repository\Watcher->getHandler() in src/addons/DBTech/Security/Listener.php at line 265
    9. DBTech\Security\Listener::dispatcherPostRender()
    10. call_user_func_array() in src/XF/Extension.php at line 67
    11. XF\Extension->fire() in src/XF/App.php at line 2797
    12. XF\App->fire() in src/XF/Mvc/Dispatcher.php at line 407
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    15. XF\App->run() in src/XF.php at line 488
    16. XF::runApp() in index.php at line 20

Included Files (311, 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/paragonie/random_compat/lib/random.php
  11. src/vendor/symfony/polyfill-mbstring/bootstrap.php
  12. src/vendor/ralouphie/getallheaders/src/getallheaders.php
  13. src/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
  14. src/vendor/symfony/polyfill-php70/bootstrap.php
  15. src/vendor/symfony/polyfill-php72/bootstrap.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/symfony/polyfill-intl-idn/bootstrap.php
  21. src/vendor/guzzlehttp/guzzle/src/functions_include.php
  22. src/vendor/guzzlehttp/guzzle/src/functions.php
  23. src/vendor/paragonie/sodium_compat/autoload.php
  24. src/vendor/paragonie/sodium_compat/autoload-php7.php
  25. src/vendor/paragonie/sodium_compat/src/SodiumException.php
  26. src/vendor/paragonie/sodium_compat/lib/namespaced.php
  27. src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
  28. src/vendor/paragonie/sodium_compat/lib/constants.php
  29. src/vendor/paragonie/sodium_compat/src/Compat.php
  30. src/vendor/paragonie/sodium_compat/lib/php72compat_const.php
  31. src/vendor/paragonie/sodium_compat/lib/php72compat.php
  32. src/vendor/symfony/polyfill-ctype/bootstrap.php
  33. src/vendor/symfony/polyfill-iconv/bootstrap.php
  34. src/vendor/symfony/polyfill-php56/bootstrap.php
  35. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
  36. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
  37. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  38. src/vendor/dokuwiki/utf8/utf8.php
  39. src/XF/Http/Request.php
  40. src/XF/InputFilterer.php
  41. src/XF/Pub/App.php
  42. src/XF/App.php
  43. src/XF/Container.php
  44. src/config.php
  45. src/XF/DataRegistry.php
  46. src/XF/Db/Mysqli/Adapter.php
  47. src/XF/Db/AbstractAdapter.php
  48. src/XF/CacheFactory.php
  49. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
  50. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
  51. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  52. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  53. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  54. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  55. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  56. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
  57. src/XF/Extension.php
  58. src/XF/AddOn/Manager.php
  59. src/XF/ComposerAutoload.php
  60. src/addons/DBTech/Security/vendor/composer/autoload_namespaces.php
  61. src/addons/DBTech/Security/vendor/composer/autoload_psr4.php
  62. src/addons/DBTech/Security/vendor/composer/autoload_classmap.php
  63. src/addons/DBTech/Security/vendor/composer/autoload_files.php
  64. src/addons/DBTech/Security/vendor/symfony/polyfill-php80/bootstrap.php
  65. src/addons/DBTech/Security/vendor/beberlei/assert/lib/Assert/functions.php
  66. src/addons/DBTech/Security/vendor/symfony/deprecation-contracts/function.php
  67. src/addons/DBTech/Security/vendor/ramsey/uuid/src/functions.php
  68. src/addons/DBTech/Security/vendor-custom/web-token/jwt-core/AlgorithmManager.php
  69. src/addons/SV/SignupAbuseBlocking/_vendor/composer/autoload_namespaces.php
  70. src/addons/SV/SignupAbuseBlocking/_vendor/composer/autoload_psr4.php
  71. src/addons/SV/SignupAbuseBlocking/_vendor/composer/autoload_classmap.php
  72. src/addons/DBTech/Security/Listener.php
  73. src/addons/NF/Tickets/Listener.php
  74. src/addons/SV/SignupAbuseBlocking/Listener.php
  75. src/addons/Siropu/AdsManager/Listener.php
  76. src/addons/XFMG/Listener.php
  77. src/addons/XenAddons/AMS/Listener.php
  78. src/addons/DBTech/UserTagging/Listener.php
  79. src/addons/SV/SignupAbuseBlocking/appSetup.php
  80. src/XF/Mvc/Entity/Manager.php
  81. src/XF/Mvc/Entity/ValueFormatter.php
  82. src/addons/SV/SignupAbuseBlocking/Repository/LinkBuilder.php
  83. src/XF/Mvc/Entity/Repository.php
  84. src/XF/Mvc/Router.php
  85. src/addons/SV/StandardLib/XF/InputFilterer.php
  86. src/XF/Session/Session.php
  87. src/addons/DBTech/Security/XF/Session/Session.php
  88. src/addons/LiteSpeedCache/XF/Session/Session.php
  89. src/XF/Session/CacheStorage.php
  90. src/XF/Session/StorageInterface.php
  91. src/addons/DBTech/Security/Repository/Session.php
  92. src/XF/Db/Mysqli/Statement.php
  93. src/XF/Db/AbstractStatement.php
  94. src/XF/Util/Ip.php
  95. src/XF/Util/Random.php
  96. src/XF/Http/Response.php
  97. src/XF/Repository/User.php
  98. src/addons/NF/Tickets/XF/Repository/User.php
  99. src/XF/Entity/User.php
  100. src/XF/Mvc/Entity/Entity.php
  101. src/XF/Entity/LinkableInterface.php
  102. src/addons/DBTech/Security/XF/Entity/User.php
  103. src/addons/DBTech/UserTagging/XF/Entity/User.php
  104. src/addons/EWR/Discord/Entity/User.php
  105. src/addons/NF/Tickets/XF/Entity/User.php
  106. src/addons/Siropu/AdsManager/XF/Entity/User.php
  107. src/addons/Snog/Flags/XF/Entity/User.php
  108. src/addons/SV/ExpiringUserUpgrades/XF/Entity/User.php
  109. src/addons/Truonglv/IgnoreContent/XF/Entity/User.php
  110. src/addons/XenAddons/AMS/XF/Entity/User.php
  111. src/addons/XFA/ForumSales/XF/Entity/User.php
  112. src/addons/XFMG/XF/Entity/User.php
  113. src/addons/SV/WarningImprovements/XF/Entity/User.php
  114. src/addons/SV/SignupAbuseBlocking/XF/Entity/User.php
  115. src/addons/SV/SearchImprovements/XF/Entity/User.php
  116. src/XF/Mvc/Entity/Structure.php
  117. src/addons/Andy/Trader/XF/Entity/Listener.php
  118. src/addons/Snog/Forms/Listener.php
  119. src/addons/XFA/ForumSales/Listener.php
  120. src/XF/Entity/UserAuth.php
  121. src/addons/DBTech/Security/XF/Entity/UserAuth.php
  122. src/XF/Entity/UserOption.php
  123. src/addons/DBTech/Security/XF/Entity/UserOption.php
  124. src/addons/DBTech/UserTagging/XF/Entity/UserOption.php
  125. src/addons/EWR/Discord/Entity/UserOption.php
  126. src/addons/SV/ExpiringUserUpgrades/XF/Entity/UserOption.php
  127. src/addons/SV/WarningImprovements/XF/Entity/UserOption.php
  128. src/addons/SV/SearchImprovements/XF/Entity/UserOption.php
  129. src/XF/Entity/UserProfile.php
  130. src/addons/XenAddons/AMS/XF/Entity/UserProfile.php
  131. src/addons/SV/SignupAbuseBlocking/XF/Entity/UserProfile.php
  132. src/XF/Entity/UserPrivacy.php
  133. src/addons/DBTech/UserTagging/XF/Entity/UserPrivacy.php
  134. src/addons/Snog/Flags/XF/Entity/UserPrivacy.php
  135. src/addons/Snog/Flags/Listener.php
  136. src/XF/Util/File.php
  137. src/addons/SV/WarningImprovements/Listener.php
  138. src/XF/Language.php
  139. src/addons/DBTech/Security/Entity/Session.php
  140. src/XF/Util/Php.php
  141. src/XF/Mvc/Entity/Finder.php
  142. src/addons/NF/Tickets/Entity/Ticket.php
  143. src/XF/Entity/BookmarkTrait.php
  144. src/XF/Entity/ReactionTrait.php
  145. src/addons/NF/Tickets/Finder/Ticket.php
  146. src/addons/NF/Tickets/Repository/Status.php
  147. src/addons/NF/Tickets/Entity/Status.php
  148. src/addons/NF/Tickets/Finder/Status.php
  149. src/XF/Mvc/Entity/ArrayCollection.php
  150. src/XF/Mvc/Entity/AbstractCollection.php
  151. src/addons/NF/Tickets/Entity/Category.php
  152. src/XF/Entity/AbstractCategoryTree.php
  153. src/XF/PermissionCache.php
  154. src/XF/PermissionSet.php
  155. src/XF/Mvc/Dispatcher.php
  156. src/XF/Mvc/RouteMatch.php
  157. src/XF/Util/Arr.php
  158. src/XF/Mvc/ParameterBag.php
  159. src/XF/Pub/Controller/Member.php
  160. src/XF/Pub/Controller/AbstractController.php
  161. src/XF/Mvc/Controller.php
  162. src/addons/DBTech/UserTagging/XF/Pub/Controller/Member.php
  163. src/addons/NF/Tickets/XF/Pub/Controller/Member.php
  164. src/addons/SV/WarningImprovements/XF/Pub/Controller/Member.php
  165. src/addons/SV/SignupAbuseBlocking/XF/Pub/Controller/Member.php
  166. src/addons/SV/WarningImprovements/Globals.php
  167. src/XF/Finder/User.php
  168. src/XF/Repository/UserFollow.php
  169. src/XF/Entity/UserFollow.php
  170. src/XF/Mvc/Entity/FinderExpression.php
  171. src/XF/Mvc/Reply/View.php
  172. src/XF/Mvc/Reply/AbstractReply.php
  173. src/XF/Repository/SessionActivity.php
  174. src/XF/Data/Robot.php
  175. src/addons/DBTech/Security/XF/Data/Robot.php
  176. src/addons/DBTech/Security/3rdParty/spiders.php
  177. src/addons/LiteSpeedCache/Listener.php
  178. src/XF/Style.php
  179. src/XF/Template/Templater.php
  180. src/addons/DBTech/UserTagging/XF/Template/Templater.php
  181. src/addons/NF/Tickets/XF/Template/Templater.php
  182. src/addons/RDF/UserBanner/Template/Templater.php
  183. src/addons/SV/StandardLib/XF/Template/Templater.php
  184. src/XF/DevelopmentOutput.php
  185. src/XF/DevelopmentOutput/Template.php
  186. src/XF/DevelopmentOutput/AbstractHandler.php
  187. src/XF/Template/WatcherInterface.php
  188. src/XF/SubContainer/BbCode.php
  189. src/XF/SubContainer/AbstractSubContainer.php
  190. src/XF/SubContainer/Widget.php
  191. src/addons/XFMG/Template/TemplaterSetup.php
  192. src/addons/XenAddons/AMS/Template/TemplaterSetup.php
  193. src/XF/SimpleCache.php
  194. src/addons/Siropu/AdsManager/Template/Ad.php
  195. src/addons/Siropu/AdsManager/Util/Arr.php
  196. src/addons/Siropu/AdsManager/Repository/Ad.php
  197. src/addons/Siropu/AdsManager/Entity/Ad.php
  198. src/addons/Siropu/AdsManager/Entity/AbstractEntity.php
  199. src/addons/Siropu/AdsManager/Finder/Ad.php
  200. src/addons/Siropu/AdsManager/Entity/Package.php
  201. src/XF/Entity/Template.php
  202. src/addons/DBTech/Security/XF/Entity/Template.php
  203. src/addons/Siropu/AdsManager/Repository/ClickFraud.php
  204. src/addons/Siropu/AdsManager/Entity/ClickFraud.php
  205. src/addons/Siropu/AdsManager/Entity/AbstractStats.php
  206. src/XF/Mvc/Renderer/Html.php
  207. src/XF/Mvc/Renderer/AbstractRenderer.php
  208. src/XF/Mvc/View.php
  209. src/XF/Template/Template.php
  210. internal_data/code_cache/templates/l2/s59/public/member_about.php
  211. src/XF/PreEscaped.php
  212. src/XF/Str/Formatter.php
  213. src/addons/DBTech/UserTagging/XF/Str/Formatter.php
  214. src/XF/CustomField/DefinitionSet.php
  215. src/XF/CustomField/Set.php
  216. internal_data/code_cache/templates/l2/s59/public/custom_fields_macros.php
  217. src/XF/Template/MacroState.php
  218. src/XF/Util/Color.php
  219. src/addons/XFA/NodesIconTweak/Listener.php
  220. internal_data/code_cache/navigation_cache.php
  221. src/XF/Phrase.php
  222. src/XF/Pub/Route/Search.php
  223. src/XF/Repository/Node.php
  224. src/addons/XFA/Core/XF/Repository/Node.php
  225. src/XF/Entity/Node.php
  226. src/addons/EWR/Discord/Entity/Node.php
  227. src/addons/XFA/NodesIconTweak/XF/Entity/Node.php
  228. src/XF/Finder/Node.php
  229. src/XF/Entity/Category.php
  230. src/XF/Entity/AbstractNode.php
  231. src/XF/Entity/Forum.php
  232. src/addons/DBTech/UserTagging/XF/Entity/Forum.php
  233. src/addons/Snog/Forms/XF/Entity/Forum.php
  234. src/addons/Truonglv/IgnoreContent/XF/Entity/Forum.php
  235. src/addons/XFA/Core/XF/Entity/Forum.php
  236. src/addons/XFA/ForumSales/XF/Entity/Forum.php
  237. src/addons/XFES/XF/Entity/Forum.php
  238. src/addons/XFMG/XF/Entity/Forum.php
  239. src/XF/Entity/Thread.php
  240. src/XF/Entity/ContentVoteTrait.php
  241. src/addons/DBTech/UserTagging/XF/Entity/Thread.php
  242. src/addons/EWR/Discord/Entity/Thread.php
  243. src/addons/NF/Tickets/XF/Entity/Thread.php
  244. src/addons/Snog/Forms/XF/Entity/Thread.php
  245. src/addons/Truonglv/IgnoreContent/XF/Entity/Thread.php
  246. src/addons/XFA/ForumSales/XF/Entity/Thread.php
  247. src/addons/XFA/WhoReadThisThread/XF/Entity/Thread.php
  248. src/addons/XFES/XF/Entity/Thread.php
  249. src/addons/XFMG/XF/Entity/Thread.php
  250. src/addons/SV/MultipleAccountToThread/XF/Entity/Thread.php
  251. src/addons/XFA/ForumSales/Entity/Transaction.php
  252. src/addons/EWR/Discord/Listener/Navigation.php
  253. src/XF/NoticeList.php
  254. src/XF/Criteria/User.php
  255. src/XF/Criteria/AbstractCriteria.php
  256. internal_data/code_cache/templates/l2/s59/public/PAGE_CONTAINER.php
  257. src/XF/CssRenderer.php
  258. src/XF/Less/RtlVisitorPre.php
  259. src/vendor/oyejorge/less.php/lib/Less/VisitorReplacing.php
  260. src/vendor/oyejorge/less.php/lib/Less/Visitor.php
  261. src/XF/Less/RtlVisitor.php
  262. src/vendor/oyejorge/less.php/lib/Less/Parser.php
  263. src/vendor/oyejorge/less.php/lib/Less/Cache.php
  264. src/vendor/oyejorge/less.php/lib/Less/Version.php
  265. src/vendor/oyejorge/less.php/lib/Less/Environment.php
  266. src/vendor/oyejorge/less.php/lib/Less/Tree/Color.php
  267. src/vendor/oyejorge/less.php/lib/Less/Tree.php
  268. src/vendor/oyejorge/less.php/lib/Less/Tree/Expression.php
  269. src/vendor/oyejorge/less.php/lib/Less/Tree/Value.php
  270. src/vendor/oyejorge/less.php/lib/Less/Tree/Rule.php
  271. src/vendor/oyejorge/less.php/lib/Less/Tree/Element.php
  272. src/vendor/oyejorge/less.php/lib/Less/Tree/Selector.php
  273. src/vendor/oyejorge/less.php/lib/Less/Tree/Keyword.php
  274. src/vendor/oyejorge/less.php/lib/Less/Tree/Variable.php
  275. src/vendor/oyejorge/less.php/lib/Less/Tree/Ruleset.php
  276. src/vendor/oyejorge/less.php/lib/Less/Tree/DefaultFunc.php
  277. src/vendor/oyejorge/less.php/lib/Less/Visitor/joinSelector.php
  278. src/vendor/oyejorge/less.php/lib/Less/Visitor/toCSS.php
  279. src/vendor/oyejorge/less.php/lib/Less/Output.php
  280. src/vendor/oyejorge/less.php/lib/Less/Functions.php
  281. internal_data/code_cache/templates/l2/s59/public/metadata_macros.php
  282. internal_data/code_cache/templates/l2/s59/public/xb_custom_fonts.php
  283. internal_data/code_cache/templates/l2/s59/public/helper_js_global.php
  284. internal_data/code_cache/templates/l2/s59/public/font_awesome_setup.php
  285. internal_data/code_cache/templates/l2/s59/public/at_mai_analytics.php
  286. internal_data/code_cache/templates/l2/s59/public/xb_head.php
  287. internal_data/code_cache/templates/l2/s59/public/siropu_ads_manager_ad_macros.php
  288. internal_data/code_cache/templates/l2/s59/public/nf_tickets_staff_bar_macros.php
  289. internal_data/code_cache/templates/l2/s59/public/_ads.php
  290. internal_data/code_cache/phrase_groups/l2/nav.php
  291. internal_data/code_cache/phrase_groups/l2/button.php
  292. internal_data/code_cache/templates/l2/s59/public/xb_subnav_right.php
  293. internal_data/code_cache/templates/l2/s59/public/xb_canvas_panel_top.php
  294. internal_data/code_cache/templates/l2/s59/public/xb_canvas_panel_bottom.php
  295. internal_data/code_cache/templates/l2/s59/public/browser_warning_macros.php
  296. internal_data/code_cache/templates/l2/s59/public/xb_welcome.php
  297. internal_data/code_cache/templates/l2/s59/public/xb_footer_links.php
  298. src/addons/DBTech/UserTagging/Template/Callback/Copyright.php
  299. src/addons/DBTech/Security/Template/Callback/Copyright.php
  300. internal_data/code_cache/templates/l2/s59/public/debug_macros.php
  301. internal_data/code_cache/templates/l2/s59/public/siropu_ads_manager_ad_js.php
  302. src/addons/Siropu/AdsManager/Vendor/MobileDetect/Mobile_Detect.php
  303. internal_data/code_cache/templates/l2/s59/public/dbtech_security_fingerprint.php
  304. internal_data/code_cache/templates/l2/s59/public/xb_body_helper.php
  305. internal_data/code_cache/templates/l2/s59/public/xb_body.php
  306. src/addons/DBTech/Security/Repository/Watcher.php
  307. src/addons/DBTech/Security/Watcher/ConfigTamper.php
  308. src/addons/DBTech/Security/Watcher/AbstractHandler.php
  309. src/addons/DBTech/Security/Entity/Watcher.php
  310. src/addons/DBTech/Security/Finder/Watcher.php
  311. src/XF/Debugger.php

DB Connection Stats

bytes_sent20941
bytes_received817322
packets_sent320
packets_received3345
protocol_overhead_in13380
protocol_overhead_out1280
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet828
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet330
bytes_received_prepare_response_packet243981
bytes_received_change_user_packet571022
packets_sent_command159
packets_received_ok0
packets_received_eof0
packets_received_rset_header92
packets_received_rset_field_meta0
packets_received_rset_row56
packets_received_prepare_response2615
packets_received_change_user528
result_set_queries48
non_result_set_queries8
no_index_used10
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets48
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed51
rows_fetched_from_server_normal0
rows_fetched_from_server_ps480
rows_buffered_from_client_normal0
rows_buffered_from_client_ps480
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_ps480
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_bit4107
proto_binary_fetched_tinyint0
proto_binary_fetched_short6713
proto_binary_fetched_int241524
proto_binary_fetched_int0
proto_binary_fetched_bigint20413
proto_binary_fetched_decimal91
proto_binary_fetched_float2810
proto_binary_fetched_double759
proto_binary_fetched_date42
proto_binary_fetched_year0
proto_binary_fetched_time0
proto_binary_fetched_datetime0
proto_binary_fetched_timestamp0
proto_binary_fetched_string0
proto_binary_fetched_json7338
proto_binary_fetched_blob2589
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_query4
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_prepare52
com_stmt_execute52
com_stmt_send_long_data0
com_stmt_close51
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps549013