Page Time: 0.1512s

Memory: 15.9421 MB (Peak: 16.1145 MB)

Queries (82, time: 0.0227s, 15.0%)

  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', '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.002758
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY27 38Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/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 1901
    6. XF\App->preLoadData() in src/XF/App.php at line 1889
    7. XF\App->setup() in src/XF/Pub/App.php at line 93
    8. XF\Pub\App->setup() in src/XF.php at line 485
    9. XF::setupApp() in src/XF.php at line 508
    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.000291
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1178
    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 125
    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 2347
    14. XF\App->run() in src/XF.php at line 512
    15. XF::runApp() in index.php at line 20
  3. SELECT `xf_rm_category`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_rm_category`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_rm_category`.`resource_category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_rm_category`.`resource_category_id` = '34')


LIMIT 1
    Run Time: 0.000360
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_categoryconstPRIMARYPRIMARY4const1 
    SIMPLExf_permission_cache_content_Permissions_1constPRIMARYPRIMARY35const,const,const1 

    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 1354
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
    4. XF\Mvc\Entity\Manager->find() in src/addons/XFRM/Pub/Controller/Category.php at line 438
    5. XFRM\Pub\Controller\Category->assertViewableCategory() in src/addons/XFRM/Pub/Controller/Category.php at line 25
    6. XFRM\Pub\Controller\Category->actionIndex() in src/addons/Andy/QuickSearch/XFRM/Pub/Controller/Category.php at line 12
    7. Andy\QuickSearch\XFRM\Pub\Controller\Category->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    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 2347
    12. XF\App->run() in src/XF.php at line 512
    13. XF::runApp() in index.php at line 20
  4. SELECT `xf_rm_category`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_rm_category`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_rm_category`.`resource_category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')

ORDER BY `xf_rm_category`.`lft` ASC
    Run Time: 0.000596
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_categoryALL    29Using filesort
    SIMPLExf_permission_cache_content_Permissions_1eq_refPRIMARYPRIMARY35const,const,gamemod1_test2.xf_rm_category.resource_category_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AbstractCategoryTree.php at line 67
    4. XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/XFRM/ControllerPlugin/Overview.php at line 12
    5. XFRM\ControllerPlugin\Overview->getCategoryListData() in src/addons/XFRM/Pub/Controller/Category.php at line 30
    6. XFRM\Pub\Controller\Category->actionIndex() in src/addons/Andy/QuickSearch/XFRM/Pub/Controller/Category.php at line 12
    7. Andy\QuickSearch\XFRM\Pub\Controller\Category->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    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 2347
    12. XF\App->run() in src/XF.php at line 512
    13. XF::runApp() in index.php at line 20
  5. SELECT COUNT(*)
FROM `xf_rm_resource` 
INNER JOIN (
                    select link.resource_id
                    from xf_sv_resource_prefix_link link
                    join xf_rm_resource on (xf_rm_resource.resource_id = link.resource_id)
                    where link.prefix_id in (37) AND (xf_rm_resource.resource_category_id in (46, 40, 41, 45, 42, 39, 43, 44, 38, 34))
                    group by link.resource_id
                    having count(*) >= 1
                ) AS `prefixLink_5` ON (`prefixLink_5`.`resource_id` = `xf_rm_resource`.`resource_id`)

WHERE (`xf_rm_resource`.`resource_category_id` IN (46, 40, 41, 45, 42, 39, 43, 44, 38, 34)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
    Run Time: 0.001217
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARY<derived2>ALL    185 
    PRIMARYxf_rm_resourceeq_refPRIMARY,category_last_update,category_rating_weightedPRIMARY4prefixLink_5.resource_id1Using where
    DERIVEDxf_rm_resourcerangePRIMARY,category_last_update,category_rating_weightedcategory_last_update4 185Using where; Using index; Using temporary
    DERIVEDlinkeq_refPRIMARYPRIMARY8gamemod1_test2.xf_rm_resource.resource_id,const1Using 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 1342
    4. XF\Mvc\Entity\Finder->total() in src/addons/XFRM/ControllerPlugin/Overview.php at line 39
    5. XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/Category.php at line 42
    6. XFRM\Pub\Controller\Category->actionIndex() in src/addons/Andy/QuickSearch/XFRM/Pub/Controller/Category.php at line 12
    7. Andy\QuickSearch\XFRM\Pub\Controller\Category->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    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 2347
    12. XF\App->run() in src/XF.php at line 512
    13. XF::runApp() in index.php at line 20
  6. SELECT `xf_rm_resource`.*, `xf_user_User_1`.*, `xf_rm_resource_version_CurrentVersion_2`.*, `xf_rm_resource_feature_Featured_3`.*, `xf_rm_category_Category_4`.*
FROM `xf_rm_resource` 
INNER JOIN (
                    select link.resource_id
                    from xf_sv_resource_prefix_link link
                    join xf_rm_resource on (xf_rm_resource.resource_id = link.resource_id)
                    where link.prefix_id in (37) AND (xf_rm_resource.resource_category_id in (46, 40, 41, 45, 42, 39, 43, 44, 38, 34))
                    group by link.resource_id
                    having count(*) >= 1
                ) AS `prefixLink_5` ON (`prefixLink_5`.`resource_id` = `xf_rm_resource`.`resource_id`)
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_version` AS `xf_rm_resource_version_CurrentVersion_2` ON (`xf_rm_resource_version_CurrentVersion_2`.`resource_version_id` = `xf_rm_resource`.`current_version_id`)
LEFT JOIN `xf_rm_resource_feature` AS `xf_rm_resource_feature_Featured_3` ON (`xf_rm_resource_feature_Featured_3`.`resource_id` = `xf_rm_resource`.`resource_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_4` ON (`xf_rm_category_Category_4`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
WHERE (`xf_rm_resource`.`resource_category_id` IN (46, 40, 41, 45, 42, 39, 43, 44, 38, 34)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
ORDER BY `xf_rm_resource`.`last_update` DESC

LIMIT 10
    Run Time: 0.001544
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARY<derived2>ALL    185Using temporary; Using filesort
    PRIMARYxf_rm_resourceeq_refPRIMARY,category_last_update,category_rating_weightedPRIMARY4prefixLink_5.resource_id1Using where
    PRIMARYxf_user_User_1eq_refPRIMARYPRIMARY4gamemod1_test2.xf_rm_resource.user_id1 
    PRIMARYxf_rm_resource_version_CurrentVersion_2eq_refPRIMARYPRIMARY4gamemod1_test2.xf_rm_resource.current_version_id1 
    PRIMARYxf_rm_resource_feature_Featured_3eq_refPRIMARYPRIMARY4prefixLink_5.resource_id1 
    PRIMARYxf_rm_category_Category_4eq_refPRIMARYPRIMARY4gamemod1_test2.xf_rm_resource.resource_category_id1 
    DERIVEDxf_rm_resourcerangePRIMARY,category_last_update,category_rating_weightedcategory_last_update4 185Using where; Using index; Using temporary
    DERIVEDlinkeq_refPRIMARYPRIMARY8gamemod1_test2.xf_rm_resource.resource_id,const1Using index

    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 1387
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/ControllerPlugin/Overview.php at line 45
    4. XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/Category.php at line 42
    5. XFRM\Pub\Controller\Category->actionIndex() in src/addons/Andy/QuickSearch/XFRM/Pub/Controller/Category.php at line 12
    6. Andy\QuickSearch\XFRM\Pub\Controller\Category->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
    11. XF\App->run() in src/XF.php at line 512
    12. XF::runApp() in index.php at line 20
  7. -- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
	(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
	(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
	controller_name = VALUES(controller_name),
	controller_action = VALUES(controller_action),
	view_state = VALUES(view_state),
	params = VALUES(params),
	view_date = VALUES(view_date),
	robot_key = VALUES(robot_key)
    Params: 0, , , XFRM\Pub\Controller\Category, Index, valid, resource_category_id=34, 1714322666,
    Run Time: 0.000099

    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 158
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
    4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
    5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 289
    6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
    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 2347
    11. XF\App->run() in src/XF.php at line 512
    12. XF::runApp() in index.php at line 20
  8. SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
    Run Time: 0.001193
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_siropu_ads_manager_adreftype,status,status_display_orderstatus102const7Using where; Using temporary; Using filesort
    SIMPLExf_siropu_ads_manager_package_Package_1ALLPRIMARY   1Using where; Using join buffer (hash join)
    SIMPLExf_template_MasterTemplate_2eq_reftype_title_style_idtype_title_style_id128const,func,const1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 530
    4. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
    5. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
    6. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
    7. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 69
    8. XF\Extension->fire() in src/XF/App.php at line 2845
    9. XF\App->fire() in src/XF/App.php at line 2072
    10. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1942
    11. XF\App->preRender() in src/XF/Pub/App.php at line 450
    12. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
    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 2347
    15. XF\App->run() in src/XF.php at line 512
    16. XF::runApp() in index.php at line 20
  9. Run Time: 0.000197
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
      3. 
	
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
      4. 
	
    4. XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 498
      5. 
	
    5. Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 441
      6. 
	
    6. Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 533
      7. 
	
    7. Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
      8. 
	
    8. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
      9. 
	
    9. XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 538
      10. 
	
    10. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
      11. 
	
    11. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
      12. 
	
    12. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
      13. 
	
    13. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 69
      14. 
	
    14. XF\Extension->fire() in src/XF/App.php at line 2845
      15. 
	
    15. XF\App->fire() in src/XF/App.php at line 2072
      16. 
	
    16. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1942
      17. 
	
    17. XF\App->preRender() in src/XF/Pub/App.php at line 450
      18. 
	
    18. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
      19. 
	
    19. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      20. 
	
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      21. 
	
    21. XF\App->run() in src/XF.php at line 512
      22. 
	
    22. XF::runApp() in index.php at line 20
      23. 

    10. 

  10. Run Time: 0.000213
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
      3. 
	
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
      4. 
	
    4. XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 498
      5. 
	
    5. Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 441
      6. 
	
    6. Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 533
      7. 
	
    7. Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
      8. 
	
    8. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
      9. 
	
    9. XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 538
      10. 
	
    10. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
      11. 
	
    11. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
      12. 
	
    12. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
      13. 
	
    13. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 69
      14. 
	
    14. XF\Extension->fire() in src/XF/App.php at line 2845
      15. 
	
    15. XF\App->fire() in src/XF/App.php at line 2072
      16. 
	
    16. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1942
      17. 
	
    17. XF\App->preRender() in src/XF/Pub/App.php at line 450
      18. 
	
    18. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
      19. 
	
    19. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      20. 
	
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      21. 
	
    21. XF\App->run() in src/XF.php at line 512
      22. 
	
    22. XF::runApp() in index.php at line 20
      23. 

    11. 

  11. Run Time: 0.000178
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
      3. 
	
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
      4. 
	
    4. XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 498
      5. 
	
    5. Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 441
      6. 
	
    6. Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 533
      7. 
	
    7. Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
      8. 
	
    8. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
      9. 
	
    9. XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 538
      10. 
	
    10. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
      11. 
	
    11. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
      12. 
	
    12. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
      13. 
	
    13. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 69
      14. 
	
    14. XF\Extension->fire() in src/XF/App.php at line 2845
      15. 
	
    15. XF\App->fire() in src/XF/App.php at line 2072
      16. 
	
    16. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1942
      17. 
	
    17. XF\App->preRender() in src/XF/Pub/App.php at line 450
      18. 
	
    18. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
      19. 
	
    19. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      20. 
	
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      21. 
	
    21. XF\App->run() in src/XF.php at line 512
      22. 
	
    22. XF::runApp() in index.php at line 20
      23. 

    12. 

  12. Run Time: 0.000168
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
      3. 
	
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
      4. 
	
    4. XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 498
      5. 
	
    5. Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 441
      6. 
	
    6. Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 533
      7. 
	
    7. Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
      8. 
	
    8. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
      9. 
	
    9. XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 538
      10. 
	
    10. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
      11. 
	
    11. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
      12. 
	
    12. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
      13. 
	
    13. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 69
      14. 
	
    14. XF\Extension->fire() in src/XF/App.php at line 2845
      15. 
	
    15. XF\App->fire() in src/XF/App.php at line 2072
      16. 
	
    16. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1942
      17. 
	
    17. XF\App->preRender() in src/XF/Pub/App.php at line 450
      18. 
	
    18. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
      19. 
	
    19. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      20. 
	
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      21. 
	
    21. XF\App->run() in src/XF.php at line 512
      22. 
	
    22. XF::runApp() in index.php at line 20
      23. 

    13. 

  13. Run Time: 0.000148
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
      3. 
	
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
      4. 
	
    4. XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 498
      5. 
	
    5. Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 441
      6. 
	
    6. Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 533
      7. 
	
    7. Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
      8. 
	
    8. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
      9. 
	
    9. XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 538
      10. 
	
    10. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
      11. 
	
    11. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
      12. 
	
    12. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
      13. 
	
    13. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 69
      14. 
	
    14. XF\Extension->fire() in src/XF/App.php at line 2845
      15. 
	
    15. XF\App->fire() in src/XF/App.php at line 2072
      16. 
	
    16. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1942
      17. 
	
    17. XF\App->preRender() in src/XF/Pub/App.php at line 450
      18. 
	
    18. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
      19. 
	
    19. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      20. 
	
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      21. 
	
    21. XF\App->run() in src/XF.php at line 512
      22. 
	
    22. XF::runApp() in index.php at line 20
      23. 

    14. 

  14. Run Time: 0.000145
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
      3. 
	
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
      4. 
	
    4. XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 498
      5. 
	
    5. Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 441
      6. 
	
    6. Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 533
      7. 
	
    7. Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
      8. 
	
    8. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
      9. 
	
    9. XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 538
      10. 
	
    10. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
      11. 
	
    11. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
      12. 
	
    12. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
      13. 
	
    13. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 69
      14. 
	
    14. XF\Extension->fire() in src/XF/App.php at line 2845
      15. 
	
    15. XF\App->fire() in src/XF/App.php at line 2072
      16. 
	
    16. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1942
      17. 
	
    17. XF\App->preRender() in src/XF/Pub/App.php at line 450
      18. 
	
    18. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
      19. 
	
    19. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      20. 
	
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      21. 
	
    21. XF\App->run() in src/XF.php at line 512
      22. 
	
    22. XF::runApp() in index.php at line 20
      23. 

    15. 

  15. SELECT `xf_rm_resource`.*, `xf_rm_resource_feature_Featured_1`.*, `xf_user_User_2`.*, `xf_rm_resource_version_CurrentVersion_3`.*
FROM `xf_rm_resource`
INNER JOIN `xf_rm_resource_feature` AS `xf_rm_resource_feature_Featured_1` ON (`xf_rm_resource_feature_Featured_1`.`resource_id` = `xf_rm_resource`.`resource_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_version` AS `xf_rm_resource_version_CurrentVersion_3` ON (`xf_rm_resource_version_CurrentVersion_3`.`resource_version_id` = `xf_rm_resource`.`current_version_id`)
WHERE (`xf_rm_resource`.`resource_category_id` IN (46, 40, 41, 45, 42, 39, 43, 44, 38, 34)) AND (`xf_rm_resource`.`resource_state` = 'visible')
ORDER BY RAND() ASC

LIMIT 10
    Run Time: 0.000985
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resource_feature_Featured_1indexPRIMARYfeature_date4 1Using index; Using temporary; Using filesort
    SIMPLExf_rm_resourceeq_refPRIMARY,category_last_update,category_rating_weightedPRIMARY4gamemod1_test2.xf_rm_resource_feature_Featured_1.resource_id1Using where
    SIMPLExf_user_User_2eq_refPRIMARYPRIMARY4gamemod1_test2.xf_rm_resource.user_id1 
    SIMPLExf_rm_resource_version_CurrentVersion_3eq_refPRIMARYPRIMARY4gamemod1_test2.xf_rm_resource.current_version_id1 

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
      3. 
	
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/Widget/FeaturedResources.php at line 101
      4. 
	
    4. XFRM\Widget\FeaturedResources->render() in internal_data/code_cache/widgets/_11_xfrm_list_featured_resources.php at line 5
      5. 
	
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7509
      6. 
	
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
      7. 
	
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1928
      8. 
	
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 194
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    16. 

  16. SELECT `xf_rm_resource_prefix`.*
FROM `xf_rm_resource_prefix`

WHERE (`xf_rm_resource_prefix`.`prefix_id` IN (88, 87, 69, 71, 70, 68, 67, 66, 65, 64, 63, 62, 61, 60, 59, 58, 57, 56, 55, 54, 53, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11))
ORDER BY `xf_rm_resource_prefix`.`materialized_order` ASC
    Run Time: 0.000605
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resource_prefixALLPRIMARY   78Using where; Using filesort

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
      3. 
	
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/Entity/Category.php at line 231
      4. 
	
    4. XFRM\Entity\Category->getPrefixes() in src/XF/Mvc/Entity/Entity.php at line 159
      5. 
	
    5. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 117
      6. 
	
    6. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 205
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      8. 
	
    8. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      9. 
	
    9. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      10. 
	
    10. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      11. 
	
    11. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      12. 
	
    12. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      13. 
	
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      14. 
	
    14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      15. 
	
    15. XF\App->run() in src/XF.php at line 512
      16. 
	
    16. XF::runApp() in index.php at line 20
      17. 

    17. 

  17. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 88)
    Run Time: 0.000317
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    18. 

  18. SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('xfrmPrefixes')
    Run Time: 0.000155
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY27const1 

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
      3. 
	
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 139
      4. 
	
    4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
      5. 
	
    5. XF\DataRegistry->get() in src/XF/DataRegistry.php at line 227
      6. 
	
    6. XF\DataRegistry->offsetGet() in src/XF/App.php at line 1792
      7. 
	
    7. XF\App->XF\{closure}() in src/XF/Container.php at line 30
      8. 
	
    8. XF\Container->offsetGet() in src/XF/App.php at line 3309
      9. 
	
    9. XF\App->container() in src/XF/Template/Templater.php at line 3563
      10. 
	
    10. XF\Template\Templater->getPrefixPhrase() in src/XF/Template/Templater.php at line 3543
      11. 
	
    11. XF\Template\Templater->fnPrefixTitle() in src/XF/Template/Templater.php at line 1128
      12. 
	
    12. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 56
      13. 
	
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      14. 
	
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      15. 
	
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      16. 
	
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      17. 
	
    17. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      18. 
	
    18. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      19. 
	
    19. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      20. 
	
    20. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      21. 
	
    21. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      22. 
	
    22. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      23. 
	
    23. XF\App->run() in src/XF.php at line 512
      24. 
	
    24. XF::runApp() in index.php at line 20
      25. 

    19. 

  19. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 87)
    Run Time: 0.000204
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    20. 

  20. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 69)
    Run Time: 0.000202
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    21. 

  21. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 71)
    Run Time: 0.000182
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    22. 

  22. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 70)
    Run Time: 0.000164
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    23. 

  23. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 68)
    Run Time: 0.000153
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    24. 

  24. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 67)
    Run Time: 0.000188
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    25. 

  25. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 66)
    Run Time: 0.000184
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    26. 

  26. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 65)
    Run Time: 0.000154
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    27. 

  27. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 64)
    Run Time: 0.000218
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    28. 

  28. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 63)
    Run Time: 0.000258
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    29. 

  29. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 62)
    Run Time: 0.000233
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    30. 

  30. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 61)
    Run Time: 0.000388
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    31. 

  31. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 60)
    Run Time: 0.000236
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    32. 

  32. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 59)
    Run Time: 0.000228
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    33. 

  33. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 58)
    Run Time: 0.000214
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    34. 

  34. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 57)
    Run Time: 0.000265
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    35. 

  35. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 56)
    Run Time: 0.000213
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    36. 

  36. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 55)
    Run Time: 0.000208
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    37. 

  37. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 54)
    Run Time: 0.000221
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    38. 

  38. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 53)
    Run Time: 0.000194
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    39. 

  39. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 52)
    Run Time: 0.000190
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    40. 

  40. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 51)
    Run Time: 0.000221
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    41. 

  41. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 50)
    Run Time: 0.000253
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    42. 

  42. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 49)
    Run Time: 0.000206
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    43. 

  43. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 48)
    Run Time: 0.000205
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    44. 

  44. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 47)
    Run Time: 0.000223
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    45. 

  45. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 46)
    Run Time: 0.000220
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    46. 

  46. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 45)
    Run Time: 0.000247
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    47. 

  47. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 44)
    Run Time: 0.000238
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    48. 

  48. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 43)
    Run Time: 0.000160
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    49. 

  49. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 42)
    Run Time: 0.000141
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    50. 

  50. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 41)
    Run Time: 0.000143
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    51. 

  51. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 40)
    Run Time: 0.000133
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    52. 

  52. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 39)
    Run Time: 0.000124
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    53. 

  53. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 38)
    Run Time: 0.000122
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    54. 

  54. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 37)
    Run Time: 0.000130
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    55. 

  55. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 36)
    Run Time: 0.000124
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    56. 

  56. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 35)
    Run Time: 0.000170
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    57. 

  57. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 34)
    Run Time: 0.000165
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    58. 

  58. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 33)
    Run Time: 0.000140
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    59. 

  59. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 32)
    Run Time: 0.000137
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    60. 

  60. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 31)
    Run Time: 0.000135
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    61. 

  61. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 30)
    Run Time: 0.000127
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    62. 

  62. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 29)
    Run Time: 0.000166
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    63. 

  63. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 28)
    Run Time: 0.000151
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    64. 

  64. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 27)
    Run Time: 0.000134
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    65. 

  65. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 26)
    Run Time: 0.000144
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    66. 

  66. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 25)
    Run Time: 0.000168
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    67. 

  67. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 24)
    Run Time: 0.000129
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    68. 

  68. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 23)
    Run Time: 0.000119
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    69. 

  69. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 22)
    Run Time: 0.000119
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    70. 

  70. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 21)
    Run Time: 0.000123
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    71. 

  71. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 20)
    Run Time: 0.000119
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    72. 

  72. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 19)
    Run Time: 0.000120
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    73. 

  73. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 18)
    Run Time: 0.000199
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    74. 

  74. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 17)
    Run Time: 0.000152
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    75. 

  75. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 16)
    Run Time: 0.000138
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    76. 

  76. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 15)
    Run Time: 0.000160
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    77. 

  77. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 14)
    Run Time: 0.000128
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    78. 

  78. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 13)
    Run Time: 0.000136
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idcategory_last_update4const2Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    79. 

  79. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 12)
    Run Time: 0.000122
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    80. 

  80. SELECT COUNT(*)
FROM `xf_rm_resource`

WHERE (`xf_rm_resource`.`resource_category_id` = 34 AND `xf_rm_resource`.`prefix_id` = 11)
    Run Time: 0.000168
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_rm_resourcerefcategory_last_update,category_rating_weighted,prefix_idprefix_id4const1Using where

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
      3. 
	
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
      4. 
	
    4. XF\Mvc\Entity\Finder->total() in src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php at line 16
      5. 
	
    5. SyTryC\PrefixFilter\XFRM\Entity\ResourcePrefix->getTotalPrefixes() in src/XF/Template/Templater.php at line 1191
      6. 
	
    6. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php at line 38
      7. 
	
    7. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 824
      8. 
	
    8. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php at line 200
      9. 
	
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      10. 
	
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
      11. 
	
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
      12. 
	
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
      13. 
	
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
      14. 
	
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
      15. 
	
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      16. 
	
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      17. 
	
    17. XF\App->run() in src/XF.php at line 512
      18. 
	
    18. XF::runApp() in index.php at line 20
      19. 

    81. 

  81. SELECT `xf_wutime_adblock`.*
FROM `xf_wutime_adblock`

WHERE (`xf_wutime_adblock`.`status` = 'New')


LIMIT 1
    Run Time: 0.000409
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_wutime_adblockrefstatusstatus1const1 

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
      3. 
	
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
      4. 
	
    4. XF\Mvc\Entity\Manager->findOne() in src/addons/Wutime/AdBlock/Listener.php at line 15
      5. 
	
    5. Wutime\AdBlock\Listener::templaterTemplatePreRenderPublicScriptDetection() in src/XF/Extension.php at line 52
      6. 
	
    6. XF\Extension->fire() in src/XF/App.php at line 2845
      7. 
	
    7. XF\App->fire() in src/XF/Template/Templater.php at line 1610
      8. 
	
    8. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1680
      9. 
	
    9. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s12/public/PAGE_CONTAINER.php at line 2314
      10. 
	
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
      11. 
	
    11. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 564
      12. 
	
    12. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2145
      13. 
	
    13. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
      14. 
	
    14. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
      15. 
	
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2347
      16. 
	
    16. XF\App->run() in src/XF.php at line 512
      17. 
	
    17. XF::runApp() in index.php at line 20
      18. 

    82. 

  82. -- XFDB=noForceAllWrite
INSERT INTO xf_session
	(session_id, session_data, expiry_date)
VALUES
	(?, ?, ?)
ON DUPLICATE KEY UPDATE
	session_data = VALUES(session_data),
	expiry_date = VALUES(expiry_date)
    Params: 4CFhlMpIkjygRAl6LQA1e_5-2JBh1Abv, , 1714337066
    Run Time: 0.000201

      	
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
      2. 
	
    2. XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
      3. 
	
    3. XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 217
      4. 
	
    4. XF\Session\Session->save() in src/XF/Pub/App.php at line 462
      5. 
	
    5. XF\Pub\App->complete() in src/XF/App.php at line 2350
      6. 
	
    6. XF\App->run() in src/XF.php at line 512
      7. 
	
    7. XF::runApp() in index.php at line 20
      8. 

    83. 

Included Files (245, XenForo Classes: 89)
  1. index.php
    2. 

  2. src/XF.php
    3. 

  3. src/vendor/autoload.php
    4. 

  4. src/vendor/composer/autoload_real.php
    5. 

  5. src/vendor/composer/ClassLoader.php
    6. 

  6. src/vendor/composer/autoload_static.php
    7. 

  7. src/vendor/laminas/laminas-zendframework-bridge/src/autoload.php
    8. 

  8. src/vendor/laminas/laminas-zendframework-bridge/src/Autoloader.php
    9. 

  9. src/vendor/laminas/laminas-zendframework-bridge/src/RewriteRules.php
    10. 

  10. src/vendor/symfony/polyfill-mbstring/bootstrap.php
    11. 

  11. src/vendor/ralouphie/getallheaders/src/getallheaders.php
    12. 

  12. src/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
    13. 

  13. src/vendor/symfony/polyfill-php72/bootstrap.php
    14. 

  14. src/vendor/guzzlehttp/promises/src/functions_include.php
    15. 

  15. src/vendor/guzzlehttp/promises/src/functions.php
    16. 

  16. src/vendor/guzzlehttp/psr7/src/functions_include.php
    17. 

  17. src/vendor/guzzlehttp/psr7/src/functions.php
    18. 

  18. src/vendor/symfony/polyfill-intl-idn/bootstrap.php
    19. 

  19. src/vendor/guzzlehttp/guzzle/src/functions_include.php
    20. 

  20. src/vendor/guzzlehttp/guzzle/src/functions.php
    21. 

  21. src/vendor/paragonie/sodium_compat/autoload.php
    22. 

  22. src/vendor/paragonie/sodium_compat/autoload-php7.php
    23. 

  23. src/vendor/paragonie/sodium_compat/src/Compat.php
    24. 

  24. src/vendor/paragonie/sodium_compat/src/SodiumException.php
    25. 

  25. src/vendor/paragonie/sodium_compat/lib/namespaced.php
    26. 

  26. src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
    27. 

  27. src/vendor/paragonie/sodium_compat/lib/constants.php
    28. 

  28. src/vendor/paragonie/sodium_compat/lib/php72compat_const.php
    29. 

  29. src/vendor/paragonie/sodium_compat/lib/php72compat.php
    30. 

  30. src/vendor/paragonie/sodium_compat/lib/stream-xchacha20.php
    31. 

  31. src/vendor/paragonie/sodium_compat/lib/ristretto255.php
    32. 

  32. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
    33. 

  33. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
    34. 

  34. src/vendor/symfony/var-dumper/Resources/functions/dump.php
    35. 

  35. src/vendor/dokuwiki/utf8/utf8.php
    36. 

  36. src/XF/Http/Request.php
    37. 

  37. src/XF/InputFilterer.php
    38. 

  38. src/XF/Pub/App.php
    39. 

  39. src/XF/App.php
    40. 

  40. src/XF/Container.php
    41. 

  41. src/config.php
    42. 

  42. src/XF/DataRegistry.php
    43. 

  43. src/XF/Db/Mysqli/Adapter.php
    44. 

  44. src/XF/Db/AbstractAdapter.php
    45. 

  45. src/XF/Db/Mysqli/Statement.php
    46. 

  46. src/XF/Db/AbstractStatement.php
    47. 

  47. src/XF/Extension.php
    48. 

  48. src/XF/AddOn/Manager.php
    49. 

  49. src/XF/ComposerAutoload.php
    50. 

  50. src/addons/cv6/CustomFields/vendor/composer/autoload_namespaces.php
    51. 

  51. src/addons/cv6/CustomFields/vendor/composer/autoload_psr4.php
    52. 

  52. src/addons/cv6/CustomFields/vendor/composer/autoload_classmap.php
    53. 

  53. src/addons/AL/Core/Listener/AppSetup.php
    54. 

  54. src/addons/AddonsLab/Core/vendor/autoload.php
    55. 

  55. src/addons/AddonsLab/Core/vendor/composer/autoload_real.php
    56. 

  56. src/addons/AddonsLab/Core/vendor/composer/autoload_static.php
    57. 

  57. src/addons/Siropu/AdsManager/Listener.php
    58. 

  58. src/addons/XFRM/Listener.php
    59. 

  59. src/addons/AL/Core/Extension.php
    60. 

  60. src/addons/SV/StandardLib/XF/InputFilterer.php
    61. 

  61. src/XF/Session/Session.php
    62. 

  62. src/XF/Session/DbStorage.php
    63. 

  63. src/XF/Session/StorageInterface.php
    64. 

  64. src/XF/Util/Ip.php
    65. 

  65. src/XF/Util/Random.php
    66. 

  66. src/XF/Http/Response.php
    67. 

  67. src/XF/Mvc/Entity/Manager.php
    68. 

  68. src/XF/Mvc/Entity/ValueFormatter.php
    69. 

  69. src/XF/Repository/User.php
    70. 

  70. src/XF/Mvc/Entity/Repository.php
    71. 

  71. src/XF/Entity/User.php
    72. 

  72. src/XF/Mvc/Entity/Entity.php
    73. 

  73. src/XF/Entity/LinkableInterface.php
    74. 

  74. src/addons/AVForums/TagEssentials/XF/Entity/User.php
    75. 

  75. src/addons/Siropu/AdsManager/XF/Entity/User.php
    76. 

  76. src/addons/XenSoluce/SEOOptimization/XF/Entity/User.php
    77. 

  77. src/addons/XFRM/XF/Entity/User.php
    78. 

  78. src/XF/Mvc/Entity/Structure.php
    79. 

  79. src/addons/XenSoluce/SEOOptimization/Listener.php
    80. 

  80. src/XF/Entity/UserAuth.php
    81. 

  81. src/XF/Entity/UserOption.php
    82. 

  82. src/XF/Entity/UserProfile.php
    83. 

  83. src/addons/cv6/CustomFields/XF/Entity/UserProfile.php
    84. 

  84. src/XF/Entity/UserPrivacy.php
    85. 

  85. src/XF/Util/File.php
    86. 

  86. src/XF/Language.php
    87. 

  87. src/XF/Mvc/Dispatcher.php
    88. 

  88. src/XF/Mvc/Router.php
    89. 

  89. src/XF/Mvc/RouteMatch.php
    90. 

  90. src/XF/Util/Arr.php
    91. 

  91. src/XF/Mvc/ParameterBag.php
    92. 

  92. src/addons/XFRM/Pub/Controller/Category.php
    93. 

  93. src/XF/Pub/Controller/AbstractController.php
    94. 

  94. src/XF/Mvc/Controller.php
    95. 

  95. src/addons/Andy/QuickSearch/XFRM/Pub/Controller/Category.php
    96. 

  96. src/addons/SV/MultiPrefix/XFRM/Pub/Controller/Category.php
    97. 

  97. src/XF/Util/Php.php
    98. 

  98. src/XF/PermissionCache.php
    99. 

  99. src/XF/PermissionSet.php
    100. 

  100. src/addons/XFRM/Entity/Category.php
    101. 

  101. src/XF/Entity/AbstractCategoryTree.php
    102. 

  102. src/addons/SV/MultiPrefix/XFRM/Entity/Category.php
    103. 

  103. src/XF/Mvc/Entity/Finder.php
    104. 

  104. src/XF/Entity/PermissionCacheContent.php
    105. 

  105. src/XF/Mvc/Entity/Proxyable.php
    106. 

  106. src/XF/Mvc/Entity/FinderCollection.php
    107. 

  107. src/XF/Mvc/Entity/AbstractCollection.php
    108. 

  108. src/addons/XFRM/ControllerPlugin/Category.php
    109. 

  109. src/XF/ControllerPlugin/AbstractPlugin.php
    110. 

  110. src/addons/XFRM/ControllerPlugin/Overview.php
    111. 

  111. src/addons/SV/MultiPrefix/XFRM/ControllerPlugin/Overview.php
    112. 

  112. src/addons/XFRM/Repository/Category.php
    113. 

  113. src/XF/Repository/AbstractCategoryTree.php
    114. 

  114. src/XF/Mvc/Entity/ArrayCollection.php
    115. 

  115. src/XF/Tree.php
    116. 

  116. src/XF/SubTree.php
    117. 

  117. src/XF/Str/Formatter.php
    118. 

  118. src/addons/XFRM/Repository/ResourceItem.php
    119. 

  119. src/addons/XFRM/Entity/ResourceItem.php
    120. 

  120. src/XF/Entity/BookmarkTrait.php
    121. 

  121. src/addons/cv6/CustomFields/XF/Entity/ResourceItem.php
    122. 

  122. src/addons/XenSoluce/SEOOptimization/XFRM/Entity/ResourceItem.php
    123. 

  123. src/addons/SV/MultiPrefix/XFRM/Entity/ResourceItem.php
    124. 

  124. src/addons/SV/MultiPrefix/Behavior/MultiPrefixable.php
    125. 

  125. src/XF/Mvc/Entity/Behavior.php
    126. 

  126. src/addons/XFRM/Finder/ResourceItem.php
    127. 

  127. src/addons/SV/MultiPrefix/XFRM/Finder/ResourceItem.php
    128. 

  128. src/addons/SV/StandardLib/Finder/SqlJoinTrait.php
    129. 

  129. src/addons/XFRM/Entity/ResourceVersion.php
    130. 

  130. src/addons/XFRM/Entity/ResourceFeature.php
    131. 

  131. src/XF/Mvc/Reply/View.php
    132. 

  132. src/XF/Mvc/Reply/AbstractReply.php
    133. 

  133. src/XF/Repository/SessionActivity.php
    134. 

  134. src/XF/Data/Robot.php
    135. 

  135. src/XF/Style.php
    136. 

  136. src/XF/Template/Templater.php
    137. 

  137. src/addons/SV/MultiPrefix/XF/Template/Templater.php
    138. 

  138. src/addons/SV/StandardLib/XF/Template/Templater.php
    139. 

  139. src/XF/SubContainer/BbCode.php
    140. 

  140. src/XF/SubContainer/AbstractSubContainer.php
    141. 

  141. src/XF/SubContainer/Widget.php
    142. 

  142. src/addons/AL/Core/Listener/TemplaterSetup.php
    143. 

  143. src/addons/Wutime/AdBlock/Listener.php
    144. 

  144. src/addons/XFRM/Template/TemplaterSetup.php
    145. 

  145. src/addons/XenSoluce/SEOOptimization/Template/TemplaterSetup.php
    146. 

  146. src/XF/SimpleCache.php
    147. 

  147. src/addons/Siropu/AdsManager/Template/Ad.php
    148. 

  148. src/addons/Siropu/AdsManager/Util/Arr.php
    149. 

  149. src/addons/Siropu/AdsManager/Repository/Ad.php
    150. 

  150. src/addons/Siropu/AdsManager/Entity/Ad.php
    151. 

  151. src/addons/Siropu/AdsManager/Entity/AbstractEntity.php
    152. 

  152. src/addons/Siropu/AdsManager/Finder/Ad.php
    153. 

  153. src/addons/Siropu/AdsManager/Entity/Package.php
    154. 

  154. src/XF/Entity/Template.php
    155. 

  155. src/addons/Siropu/AdsManager/Repository/ClickFraud.php
    156. 

  156. src/addons/Siropu/AdsManager/Entity/ClickFraud.php
    157. 

  157. src/addons/Siropu/AdsManager/Entity/AbstractStats.php
    158. 

  158. src/XF/Criteria/User.php
    159. 

  159. src/XF/Criteria/AbstractCriteria.php
    160. 

  160. src/XF/Criteria/Page.php
    161. 

  161. src/addons/Siropu/AdsManager/XF/Criteria/Page.php
    162. 

  162. src/addons/Siropu/AdsManager/Criteria/Device.php
    163. 

  163. src/addons/Siropu/AdsManager/Vendor/MobileDetect/Mobile_Detect.php
    164. 

  164. src/addons/Siropu/AdsManager/Criteria/Geo.php
    165. 

  165. src/addons/Siropu/AdsManager/Vendor/MaxMind/autoload.php
    166. 

  166. src/addons/Siropu/AdsManager/Vendor/MaxMind/composer/autoload_real.php
    167. 

  167. src/addons/Siropu/AdsManager/Vendor/MaxMind/composer/autoload_static.php
    168. 

  168. src/addons/Siropu/AdsManager/Vendor/MaxMind/geoip2/geoip2/src/Database/Reader.php
    169. 

  169. src/addons/Siropu/AdsManager/Vendor/MaxMind/geoip2/geoip2/src/ProviderInterface.php
    170. 

  170. src/addons/Siropu/AdsManager/Vendor/MaxMind/maxmind-db/reader/src/MaxMind/Db/Reader.php
    171. 

  171. src/addons/Siropu/AdsManager/Criteria/Position.php
    172. 

  172. src/XF/Mvc/Renderer/Html.php
    173. 

  173. src/XF/Mvc/Renderer/AbstractRenderer.php
    174. 

  174. src/XF/Mvc/View.php
    175. 

  175. src/XF/Template/Template.php
    176. 

  176. internal_data/code_cache/templates/l1/s12/public/xfrm_category_view.php
    177. 

  177. src/XF/PreEscaped.php
    178. 

  178. internal_data/code_cache/templates/l1/s12/public/metadata_macros.php
    179. 

  179. src/XF/Template/MacroState.php
    180. 

  180. internal_data/code_cache/templates/l1/s12/public/xfrm_resource_page_macros.php
    181. 

  181. internal_data/code_cache/widgets/_11_xfrm_list_featured_resources.php
    182. 

  182. src/XF/Widget/WidgetConfig.php
    183. 

  183. src/addons/XFRM/Widget/FeaturedResources.php
    184. 

  184. src/XF/Widget/AbstractWidget.php
    185. 

  185. src/XF/Mvc/Entity/FinderExpression.php
    186. 

  186. src/XF/Phrase.php
    187. 

  187. internal_data/code_cache/phrase_groups/l1/widget.php
    188. 

  188. internal_data/code_cache/phrase_groups/l1/widget_def.php
    189. 

  189. src/XF/Widget/WidgetRenderer.php
    190. 

  190. internal_data/code_cache/templates/l1/s12/public/xfrm_widget_featured_resources.php
    191. 

  191. src/addons/XFRM/Entity/ResourcePrefix.php
    192. 

  192. src/XF/Entity/AbstractPrefix.php
    193. 

  193. src/addons/SyTryC/PrefixFilter/XFRM/Entity/ResourcePrefix.php
    194. 

  194. src/addons/SV/MultiPrefix/XFRM/Entity/ResourcePrefix.php
    195. 

  195. internal_data/code_cache/templates/l1/s12/public/sc_prefix_macros.php
    196. 

  196. internal_data/code_cache/phrase_groups/l1/resource_prefix.php
    197. 

  197. internal_data/code_cache/templates/l1/s12/public/xfrm_overview_macros.php
    198. 

  198. internal_data/code_cache/templates/l1/s12/public/sv_multiprefix_filter.php
    199. 

  199. internal_data/code_cache/templates/l1/s12/public/xfrm_resource_list_macros.php
    200. 

  200. internal_data/code_cache/templates/l1/s12/public/rating_macros.php
    201. 

  201. internal_data/code_cache/templates/l1/s12/public/siropu_ads_manager_ad_macros.php
    202. 

  202. src/addons/Siropu/AdsManager/Service/Stats/Tracker.php
    203. 

  203. src/XF/Service/AbstractService.php
    204. 

  204. internal_data/code_cache/templates/l1/s12/public/xfrm_category_list_macros.php
    205. 

  205. internal_data/code_cache/widgets/_25_oyunwiki_minecraft_reklam.php
    206. 

  206. src/XF/Widget/Html.php
    207. 

  207. internal_data/code_cache/templates/l1/s12/public/_widget_oyunwiki_minecraft_reklam.php
    208. 

  208. internal_data/code_cache/templates/l1/s12/public/widget_html.php
    209. 

  209. internal_data/code_cache/widgets/_21_sidebar_reklam_3.php
    210. 

  210. internal_data/code_cache/templates/l1/s12/public/_widget_sidebar_reklam_3.php
    211. 

  211. internal_data/code_cache/navigation_cache.php
    212. 

  212. src/XF/NoticeList.php
    213. 

  213. internal_data/code_cache/templates/l1/s12/public/PAGE_CONTAINER.php
    214. 

  214. src/XF/Util/Color.php
    215. 

  215. internal_data/code_cache/templates/l1/s12/public/helper_js_global.php
    216. 

  216. internal_data/code_cache/templates/l1/s12/public/font_awesome_setup.php
    217. 

  217. internal_data/code_cache/templates/l1/s12/public/google_analytics.php
    218. 

  218. internal_data/code_cache/templates/l1/s12/public/xenfocus_onload_js.php
    219. 

  219. internal_data/code_cache/templates/l1/s12/public/xenfocus_onload_js_extra.php
    220. 

  220. internal_data/code_cache/templates/l1/s12/public/xenfocus_event_logo.php
    221. 

  221. src/XF/Pub/Route/Search.php
    222. 

  222. internal_data/code_cache/phrase_groups/l1/button.php
    223. 

  223. internal_data/code_cache/phrase_groups/l1/nav.php
    224. 

  224. internal_data/code_cache/templates/l1/s12/public/_ads.php
    225. 

  225. internal_data/code_cache/templates/l1/s12/public/xenfocus_social.php
    226. 

  226. internal_data/code_cache/templates/l1/s12/public/xenfocus_countdown.php
    227. 

  227. internal_data/code_cache/templates/l1/s12/public/browser_warning_macros.php
    228. 

  228. internal_data/code_cache/templates/l1/s12/public/xenfocus_footer.php
    229. 

  229. internal_data/code_cache/templates/l1/s12/public/xenfocus_branding.php
    230. 

  230. internal_data/code_cache/templates/l1/s12/public/debug_macros.php
    231. 

  231. internal_data/code_cache/templates/l1/s12/public/xenfocus_mobile_navigation_bar.php
    232. 

  232. internal_data/code_cache/templates/l1/s12/public/xenfocus_editor.php
    233. 

  233. internal_data/code_cache/templates/l1/s12/public/xenfocus_editor_hook_1.php
    234. 

  234. internal_data/code_cache/templates/l1/s12/public/xenfocus_editor_hook_2.php
    235. 

  235. internal_data/code_cache/templates/l1/s12/public/siropu_ads_manager_ad_js.php
    236. 

  236. internal_data/code_cache/templates/l1/s12/public/xenfocus_js.php
    237. 

  237. internal_data/code_cache/templates/l1/s12/public/xenfocus_countdown_js.php
    238. 

  238. internal_data/code_cache/templates/l1/s12/public/xenfocus_event_overlay.php
    239. 

  239. internal_data/code_cache/templates/l1/s12/public/xenfocus_extra_js.php
    240. 

  240. src/addons/Wutime/AdBlock/Entity/JavaScript.php
    241. 

  241. internal_data/code_cache/templates/l1/s12/public/wutime_adblock_script_detection.php
    242. 

  242. internal_data/code_cache/templates/l1/s12/public/wutime_adblock_detect_javascript_only.php
    243. 

  243. internal_data/code_cache/templates/l1/s12/public/wutime_adblock_styles.less.php
    244. 

  244. src/addons/Wutime/AdBlock/AdBlock.php
    245. 

  245. src/XF/Debugger.php
    246.