Page Time: 0.1675s

Memory: 11.8302 MB (Peak: 12.1616 MB)

Queries (48, time: 0.0252s, 15.1%)

1. SELECT data_key, data_value
   FROM xf_data_registry
   WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')

   Run Time: 0.002559

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	range	PRIMARY	PRIMARY	27		39	Using where

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
   3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 139
   4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
   5. XF\DataRegistry->get() in src/XF/App.php at line 2036
   6. XF\App->preLoadData() in src/XF/App.php at line 2024
   7. XF\App->setup() in src/XF/Pub/App.php at line 94
   8. XF\Pub\App->setup() in src/XF.php at line 497
   9. XF::setupApp() in src/XF.php at line 520
   10. XF::runApp() in index.php at line 20

2. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.000381

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

   
   
   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 1218
   6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 244
   7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 22
   8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
   9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
   10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
   11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
   12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
   13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
   14. XF\App->run() in src/XF.php at line 524
   15. XF::runApp() in index.php at line 20

3. SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.*
   FROM `xf_user`
   LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
   LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_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` = '408435')
   
   
   LIMIT 1

   Run Time: 0.001551

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_user	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	xf_user_option_Option_1	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	xf_user_privacy_Privacy_2	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	xf_user_profile_Profile_3	const	PRIMARY	PRIMARY	4	const	1

   
   
   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 1397
   3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
   4. XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Member.php at line 1238
   5. XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 229
   6. XF\Pub\Controller\Member->actionView() in src/XF/Mvc/Dispatcher.php at line 352
   7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
   8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
   9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
   10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
   11. XF\App->run() in src/XF.php at line 524
   12. XF::runApp() in index.php at line 20

4. SELECT `xf_news_feed`.*, `xf_user_User_1`.*
   FROM `xf_news_feed`
   LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_news_feed`.`user_id`)
   WHERE (`xf_news_feed`.`user_id` = 408435)
   ORDER BY `xf_news_feed`.`event_date` DESC
   
   LIMIT 100

   Run Time: 0.000461

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_news_feed	ref	userId_eventDate	userId_eventDate	4	const	1	Using where
   SIMPLE	xf_user_User_1	const	PRIMARY	PRIMARY	4	const	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
   3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 323
   4. XF\Pub\Controller\Member->actionView() in src/XF/Mvc/Dispatcher.php at line 352
   5. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
   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 2483
   9. XF\App->run() in src/XF.php at line 524
   10. XF::runApp() in index.php at line 20

5. SELECT view_date
   FROM xf_session_activity
   WHERE user_id = ? AND unique_key = ?

   Params: 0,
   Run Time: 0.000177

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_session_activity	const	PRIMARY	PRIMARY	22	const,const	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
   4. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
   5. xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
   6. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
   7. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
   8. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
   9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
   10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
   11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
   12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
   13. XF\App->run() in src/XF.php at line 524
   14. XF::runApp() in index.php at line 20

6. -- XFDB=noForceAllWrite
   UPDATE xf_session_activity
   SET
   	ip = ?,
   	controller_name = ?,
   	controller_action = ?,
   	view_state = ?,
   	params = ?,
   	view_date = ?,
   	robot_key = ?
   WHERE user_id = ? AND unique_key = ?

   Params: , XF\Pub\Controller\Member, View, valid, user_id=408435, 1695530747, , 0,
   Run Time: 0.000164
   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
   2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
   3. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
   4. xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
   5. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
   6. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
   7. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
   8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
   9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
   10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
   11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
   12. XF\App->run() in src/XF.php at line 524
   13. XF::runApp() in index.php at line 20

7. SELECT `xf_siropu_keyword_linking_keyword`.*
   FROM `xf_siropu_keyword_linking_keyword`
   
   WHERE (`xf_siropu_keyword_linking_keyword`.`enabled` = 1)
   ORDER BY `xf_siropu_keyword_linking_keyword`.`priority` DESC, `xf_siropu_keyword_linking_keyword`.`keyword_id` ASC

   Run Time: 0.000246

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_siropu_keyword_linking_keyword	ref	enabled_priority	enabled_priority	1	const	1	Using index condition; Using filesort

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
   3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/KeywordLinking/Keyword.php at line 158
   4. Siropu\KeywordLinking\Keyword->__construct() in src/addons/Siropu/KeywordLinking/Listener.php at line 14
   5. Siropu\KeywordLinking\Listener::templaterGlobalData() in src/XF/Extension.php at line 69
   6. XF\Extension->fire() in src/XF/App.php at line 2990
   7. XF\App->fire() in src/XF/App.php at line 2208
   8. XF\App->getGlobalTemplateData() in src/XF/App.php at line 2077
   9. XF\App->preRender() in src/XF/Pub/App.php at line 451
   10. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
   11. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
   12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
   13. XF\App->run() in src/XF.php at line 524
   14. XF::runApp() in index.php at line 20

8. SELECT COUNT(*)
   FROM `xf_siropu_username_change_history`
   
   WHERE (`xf_siropu_username_change_history`.`user_id` = 408435)

   Run Time: 0.000146

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_siropu_username_change_history	ref	user_id	user_id	4	const	1	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/Mvc/Entity/Finder.php at line 1385
   4. XF\Mvc\Entity\Finder->total() in src/addons/Siropu/UsernameChange/Listener.php at line 13
   5. Siropu\UsernameChange\Listener::templaterTemplatePreRender() in src/XF/Extension.php at line 52
   6. XF\Extension->fire() in src/XF/App.php at line 2990
   7. XF\App->fire() in src/XF/Template/Templater.php at line 1611
   8. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
   9. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
   10. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
   11. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
   12. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
   13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
   14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
   15. XF\App->run() in src/XF.php at line 524
   16. XF::runApp() in index.php at line 20

9. SELECT `xf_session_activity`.*
   FROM `xf_session_activity`
   
   WHERE (`xf_session_activity`.`user_id` = 408435) AND (`xf_session_activity`.`unique_key` = '408435')
   
   
   LIMIT 1

   Run Time: 0.000275

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE								no matching row in const table

   
   
   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 1397
   3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
   4. XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
   5. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 404
   6. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 196
   7. XF\Mvc\Entity\Entity->get() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 20
   8. XFA\CustomUsernameIcons\XF\Entity\User->get() in src/XF/Mvc/Entity/Entity.php at line 119
   9. XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 312
   10. XF\Entity\User->getLastActivity() in src/XF/Mvc/Entity/Entity.php at line 167
   11. XF\Mvc\Entity\Entity->get() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 20
   12. XFA\CustomUsernameIcons\XF\Entity\User->get() in src/XF/Mvc/Entity/Entity.php at line 119
   13. XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 521
   14. XF\Entity\User->canViewOnlineStatus() in src/XF/Template/Templater.php at line 4268
   15. XF\Template\Templater->fnUserActivity() in src/XF/Template/Templater.php at line 1129
   16. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/member_view.php at line 187
   17. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
   18. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
   19. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
   20. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
   21. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
   22. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
   23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
   24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
   25. XF\App->run() in src/XF.php at line 524
   26. XF::runApp() in index.php at line 20

10. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?

    Params: 2
    Run Time: 0.000160

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

    
    
    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 1218
    6. XF\Entity\User->hasPermission() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 40
    7. XFA\CustomUsernameIcons\XF\Entity\User->canXfaSelectCustomUsernameIcon() in src/addons/XFA/CustomUsernameIcons/XF/Template/Templater.php at line 72
    8. XFA\CustomUsernameIcons\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1129
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/member_view.php at line 218
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    18. XF\App->run() in src/XF.php at line 524
    19. XF::runApp() in index.php at line 20

11. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('svContentRatingsRTC')

    Run Time: 0.000473

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_data_registry	const	PRIMARY	PRIMARY	27	const	1

    
    
    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 177
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 139
    4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
    5. XF\DataRegistry->get() in src/XF/DataRegistry.php at line 228
    6. XF\DataRegistry->offsetGet() in src/XF/App.php at line 1927
    7. XF\App->XF\{closure}() in src/XF/Container.php at line 31
    8. XF\Container->offsetGet() in src/XF/App.php at line 3454
    9. XF\App->container() in src/addons/SV/ContentRatings/Repository/ReactionCategory.php at line 71
    10. SV\ContentRatings\Repository\ReactionCategory->getContainerReactionsCategories() in src/addons/SV/ContentRatings/Repository/ReactionCategory.php at line 87
    11. SV\ContentRatings\Repository\ReactionCategory->getReactionCategoriesAsEntities() in src/addons/SV/ContentRatings/Listener.php at line 599
    12. SV\ContentRatings\Listener::templaterTemplatePreRender() in src/XF/Extension.php at line 52
    13. XF\Extension->fire() in src/XF/App.php at line 2990
    14. XF\App->fire() in src/XF/Template/Templater.php at line 1611
    15. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    16. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/member_macros.php at line 224
    17. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    18. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/member_view.php at line 257
    19. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    20. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    21. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    22. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    23. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    24. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    25. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    26. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    27. XF\App->run() in src/XF.php at line 524
    28. XF::runApp() in index.php at line 20

12. SELECT `xf_user`.*
    FROM `xf_user`
    
    WHERE (`xf_user`.`siropu_chat_last_activity` >= 1695527747)

    Run Time: 0.001440

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_user	range	siropu_chat_last_activity	siropu_chat_last_activity	4		53	Using index condition

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/Chat/Repository/User.php at line 60
    4. Siropu\Chat\Repository\User->getActiveUserCount() in src/addons/Siropu/Chat/Navigation/Tab.php at line 35
    5. Siropu\Chat\Navigation\Tab::chat() in internal_data/code_cache/navigation_cache.php at line 362
    6. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7652
    7. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
    8. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
    9. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    10. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    11. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    13. XF\App->run() in src/XF.php at line 524
    14. XF::runApp() in index.php at line 20

13. SELECT `xf_siropu_chat_room`.*
    FROM `xf_siropu_chat_room`
    
    WHERE (`xf_siropu_chat_room`.`room_id` IN (1)) AND (`xf_siropu_chat_room`.`room_state` = 'visible')

    Run Time: 0.000413

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_siropu_chat_room	const	PRIMARY	PRIMARY	4	const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/Chat/Data.php at line 114
    4. Siropu\Chat\Data->setRoomParams() in src/addons/Siropu/Chat/Data.php at line 82
    5. Siropu\Chat\Data->getViewParams() in src/addons/Siropu/Chat/Widget/Chat.php at line 163
    6. Siropu\Chat\Widget\Chat->render() in internal_data/code_cache/widgets/_68_siropu_chat.php at line 5
    7. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7679
    8. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    9. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1937
    10. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    12. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    13. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    14. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    17. XF\App->run() in src/XF.php at line 524
    18. XF::runApp() in index.php at line 20

14. SELECT `xf_siropu_chat_message`.*, `xf_user_User_1`.*
    FROM `xf_siropu_chat_message`
    LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_siropu_chat_message`.`message_user_id`)
    WHERE (`xf_siropu_chat_message`.`message_room_id` = 1) AND (`xf_siropu_chat_message`.`message_is_ignored` IN (0, 0))
    ORDER BY `xf_siropu_chat_message`.`message_id` DESC
    
    LIMIT 50

    Run Time: 0.001920

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_siropu_chat_message	ref	message_room_id,message_is_ignored	message_room_id	4	const	7305	Using where
    SIMPLE	xf_user_User_1	eq_ref	PRIMARY	PRIMARY	4	blackspi_webdb_backup.xf_siropu_chat_message.message_user_id	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/Chat/Data.php at line 141
    4. Siropu\Chat\Data->setRoomParams() in src/addons/Siropu/Chat/Data.php at line 82
    5. Siropu\Chat\Data->getViewParams() in src/addons/Siropu/Chat/Widget/Chat.php at line 163
    6. Siropu\Chat\Widget\Chat->render() in internal_data/code_cache/widgets/_68_siropu_chat.php at line 5
    7. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7679
    8. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    9. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1937
    10. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    12. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    13. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    14. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    17. XF\App->run() in src/XF.php at line 524
    18. XF::runApp() in index.php at line 20

15. SELECT `xf_user`.*
    FROM `xf_user`
    
    WHERE (`xf_user`.`siropu_chat_last_activity` >= 1695527747) AND (`xf_user`.`siropu_chat_room_id` IN (1))
    ORDER BY `xf_user`.`siropu_chat_last_activity` DESC

    Run Time: 0.001111

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_user	range	siropu_chat_room_id,siropu_chat_last_activity	siropu_chat_last_activity	4		53	Using index condition; Using where

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/Chat/Repository/User.php at line 44
    4. Siropu\Chat\Repository\User->findActiveUsersForList() in src/addons/Siropu/Chat/Data.php at line 154
    5. Siropu\Chat\Data->setRoomParams() in src/addons/Siropu/Chat/Data.php at line 82
    6. Siropu\Chat\Data->getViewParams() in src/addons/Siropu/Chat/Widget/Chat.php at line 163
    7. Siropu\Chat\Widget\Chat->render() in internal_data/code_cache/widgets/_68_siropu_chat.php at line 5
    8. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7679
    9. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    10. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1937
    11. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    13. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    14. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    15. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    18. XF\App->run() in src/XF.php at line 524
    19. XF::runApp() in index.php at line 20

16. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?

    Params: 1165
    Run Time: 0.000271

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

    
    
    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 1218
    6. XF\Entity\User->hasPermission() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 40
    7. XFA\CustomUsernameIcons\XF\Entity\User->canXfaSelectCustomUsernameIcon() in src/addons/XFA/CustomUsernameIcons/XF/Template/Templater.php at line 72
    8. XFA\CustomUsernameIcons\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1129
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 77
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 20
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 579
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    15. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    16. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    17. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    18. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    19. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    20. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    21. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    22. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    25. XF\App->run() in src/XF.php at line 524
    26. XF::runApp() in index.php at line 20

17. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?

    Params: 224
    Run Time: 0.000200

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

    
    
    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 1218
    6. XF\Entity\User->hasPermission() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 40
    7. XFA\CustomUsernameIcons\XF\Entity\User->canXfaSelectCustomUsernameIcon() in src/addons/XFA/CustomUsernameIcons/XF/Template/Templater.php at line 72
    8. XFA\CustomUsernameIcons\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1129
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 77
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 20
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 579
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    15. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    16. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    17. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    18. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    19. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    20. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    21. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    22. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    25. XF\App->run() in src/XF.php at line 524
    26. XF::runApp() in index.php at line 20

18. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?

    Params: 1164
    Run Time: 0.000217

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

    
    
    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 1218
    6. XF\Entity\User->hasPermission() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 40
    7. XFA\CustomUsernameIcons\XF\Entity\User->canXfaSelectCustomUsernameIcon() in src/addons/XFA/CustomUsernameIcons/XF/Template/Templater.php at line 72
    8. XFA\CustomUsernameIcons\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1129
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 77
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 20
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 579
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    15. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    16. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    17. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    18. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    19. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    20. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    21. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    22. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    25. XF\App->run() in src/XF.php at line 524
    26. XF::runApp() in index.php at line 20

19. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?

    Params: 82
    Run Time: 0.000194

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

    
    
    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 1218
    6. XF\Entity\User->hasPermission() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 40
    7. XFA\CustomUsernameIcons\XF\Entity\User->canXfaSelectCustomUsernameIcon() in src/addons/XFA/CustomUsernameIcons/XF/Template/Templater.php at line 72
    8. XFA\CustomUsernameIcons\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1129
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 77
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 20
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 579
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    15. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    16. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    17. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    18. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    19. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    20. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    21. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    22. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    25. XF\App->run() in src/XF.php at line 524
    26. XF::runApp() in index.php at line 20

20. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('mvb_tooltip_description')

    Params: 1
    Run Time: 0.000683

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_phrase_compiled	const	PRIMARY	PRIMARY	106	const,const	1

    
    
    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 177
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 374
    4. XF\Language->loadPhrases() in src/XF/Language.php at line 261
    5. XF\Language->getPhraseText() in src/XF/Language.php at line 132
    6. XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
    7. XF\Phrase->render() in src/XF/Phrase.php at line 61
    8. XF\Phrase->__toString() in src/addons/MMO/VerifiedBadge/XF/Template/Templater.php at line 13
    9. MMO\VerifiedBadge\XF\Template\Templater->fnUsernameLink() in src/addons/XFA/CustomUsernameIcons/XF/Template/Templater.php at line 18
    10. XFA\CustomUsernameIcons\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1129
    11. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 77
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    13. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_user_list.php at line 20
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    15. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 579
    16. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    17. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    18. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    19. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    20. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    21. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    22. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    23. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    24. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    25. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    26. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    27. XF\App->run() in src/XF.php at line 524
    28. XF::runApp() in index.php at line 20

21. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('svContentRatingsRT')

    Run Time: 0.000220

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_data_registry	const	PRIMARY	PRIMARY	27	const	1

    
    
    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 177
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 139
    4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
    5. XF\DataRegistry->get() in src/XF/DataRegistry.php at line 228
    6. XF\DataRegistry->offsetGet() in src/XF/App.php at line 1927
    7. XF\App->XF\{closure}() in src/XF/Container.php at line 31
    8. XF\Container->offsetGet() in src/XF/App.php at line 3454
    9. XF\App->container() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 25
    10. SV\ContentRatings\XF\Repository\Reaction->getContainerReactions() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 236
    11. SV\ContentRatings\XF\Repository\Reaction->getReactionsAsEntities() in src/addons/SV/ContentRatings/Listener.php at line 397
    12. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    13. XF\Extension->fire() in src/XF/App.php at line 2990
    14. XF\App->fire() in src/XF/Template/Templater.php at line 762
    15. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    16. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    17. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    18. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    19. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    20. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    21. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    22. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    23. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    24. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    25. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    26. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    27. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    28. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    29. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    30. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    31. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    32. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    33. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    34. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    35. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    36. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    37. XF\App->run() in src/XF.php at line 524
    38. XF::runApp() in index.php at line 20

22. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20621) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000559

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

23. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?

    Params: 1303
    Run Time: 0.000242

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

    
    
    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 1218
    6. XF\Entity\User->hasPermission() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 40
    7. XFA\CustomUsernameIcons\XF\Entity\User->canXfaSelectCustomUsernameIcon() in src/addons/XFA/CustomUsernameIcons/XF/Template/Templater.php at line 72
    8. XFA\CustomUsernameIcons\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1129
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 37
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    13. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    14. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    16. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    17. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    18. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    19. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    20. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    21. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    22. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    23. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    24. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    25. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    26. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    27. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    28. XF\App->run() in src/XF.php at line 524
    29. XF::runApp() in index.php at line 20

24. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20622) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000318

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

25. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20623) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000269

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

26. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20624) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000217

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

27. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?

    Params: 1160
    Run Time: 0.000175

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

    
    
    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 1218
    6. XF\Entity\User->hasPermission() in src/addons/XFA/CustomUsernameIcons/XF/Entity/User.php at line 40
    7. XFA\CustomUsernameIcons\XF\Entity\User->canXfaSelectCustomUsernameIcon() in src/addons/XFA/CustomUsernameIcons/XF/Template/Templater.php at line 72
    8. XFA\CustomUsernameIcons\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1129
    9. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 37
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    11. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    13. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    14. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    16. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    17. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    18. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    19. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    20. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    21. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    22. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    23. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    24. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    25. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    26. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    27. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    28. XF\App->run() in src/XF.php at line 524
    29. XF::runApp() in index.php at line 20

28. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20625) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000238

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

29. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20626) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000236

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

30. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20627) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000215

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

31. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20631) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000233

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

32. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20632) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000212

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

33. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20635) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.001092

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

34. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20636) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.001166

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

35. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20637) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000426

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

36. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20638) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000378

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

37. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20639) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000759

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

38. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20640) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000581

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

39. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20641) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000529

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

40. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20642) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000548

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

41. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20643) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000418

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

42. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20644) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000462

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

43. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20645) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000396

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

44. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20646) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000304

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

45. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20647) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000446

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

46. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20648) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000628

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

47. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20649) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000466

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20

48. SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*
    FROM `xf_reaction_content`
    LEFT JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`)
    WHERE (`xf_reaction_content`.`content_type` = 'siropu_chat_room_message') AND (`xf_reaction_content`.`content_id` = 20650) AND (`xf_reaction_content`.`reaction_user_id` = 0)
    ORDER BY `xf_reaction_content`.`reaction_date` ASC
    
    LIMIT 1

    Run Time: 0.000446

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								no matching row in const table

    
    
    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 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
    4. XF\Mvc\Entity\FinderCollection->offsetGet() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 1218
    5. SV\ContentRatings\XF\Repository\Reaction->getVisitorReactionId() in src/addons/SV/ContentRatings/Listener.php at line 529
    6. SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 52
    7. XF\Extension->fire() in src/XF/App.php at line 2990
    8. XF\App->fire() in src/XF/Template/Templater.php at line 762
    9. XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 862
    10. XF\Template\Templater->renderMacro() in src/addons/SV/ContentRatings/XF/Template/Templater.php at line 307
    11. SV\ContentRatings\XF\Template\Templater->fnSvReactions() in src/XF/Template/Templater.php at line 1129
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_helper.php at line 137
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_room_message_row.php at line 31
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
    17. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s108/public/siropu_chat_message_list.php at line 17
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 825
    19. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s108/public/siropu_chat.php at line 585
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    21. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    22. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    23. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1937
    24. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s108/public/PAGE_CONTAINER.php at line 2382
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
    26. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    27. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
    28. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    29. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    30. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    31. XF\App->run() in src/XF.php at line 524
    32. XF::runApp() in index.php at line 20