Page Time: 0.1565s

Memory: 6.6868 MB (Peak: 6.9315 MB)

Queries (16, time: 0.0383s, 24.5%)

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

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
    6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
    7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
    8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
    9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 320
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    14. XF\App->run() in src/XF.php at line 390
    15. XF::runApp() in index.php at line 20
  2. SELECT `xf_xa_sc_category`.*, `xf_permission_cache_content_Permissions_1`.*
    FROM `xf_xa_sc_category`
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'sc_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_sc_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
    
    ORDER BY `xf_xa_sc_category`.`lft` ASC
    Run Time: 0.000751
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_sc_categoryALL    17Using filesort
    SIMPLExf_permission_cache_content_Permissions_1eq_refPRIMARYPRIMARY35const,const,nzwarrio_fans.xf_xa_sc_category.category_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AbstractCategoryTree.php at line 67
    4. XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 12
    5. XenAddons\Showcase\ControllerPlugin\ItemList->getCategoryListData() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 38
    6. AL\ShowcaseFilter\XenAddons\Showcase\ControllerPlugin\ItemList->getCategoryListData() in src/addons/XenAddons/Showcase/Pub/Controller/Item.php at line 29
    7. XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 34
    8. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    13. XF\App->run() in src/XF.php at line 390
    14. XF::runApp() in index.php at line 20
  3. SELECT COUNT(*)
    FROM `xf_xa_sc_item`
    
    WHERE (`xf_xa_sc_item`.`category_id` IN (14, 17, 7, 9, 8, 11, 12, 2, 18, 4, 5, 15, 13, 3, 6, 10, 16)) AND ((`xf_xa_sc_item`.`item_state` IN ('visible')))
    Run Time: 0.000179
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_sc_itemALLcategory_last_update,category_rating_weighted,category_author_rating   376Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1249
    4. XF\Mvc\Entity\Finder->total() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 38
    5. XenAddons\Showcase\ControllerPlugin\ItemList->getItemListData() in src/addons/XenAddons/Showcase/Pub/Controller/Item.php at line 32
    6. XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 34
    7. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    12. XF\App->run() in src/XF.php at line 390
    13. XF::runApp() in index.php at line 20
  4. SELECT `xf_xa_sc_item`.*, `xf_xa_sc_category_Category_1`.*, `xf_user_User_2`.*, `xf_attachment_CoverImage_3`.*, `xf_attachment_data_Data_4`.*, `xf_xa_sc_item_feature_Featured_5`.*
    FROM `xf_xa_sc_item`
    LEFT JOIN `xf_xa_sc_category` AS `xf_xa_sc_category_Category_1` ON (`xf_xa_sc_category_Category_1`.`category_id` = `xf_xa_sc_item`.`category_id`)
    LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_xa_sc_item`.`user_id`)
    LEFT JOIN `xf_attachment` AS `xf_attachment_CoverImage_3` ON (`xf_attachment_CoverImage_3`.`content_type` = 'sc_item' AND `xf_attachment_CoverImage_3`.`content_id` = `xf_xa_sc_item`.`item_id` AND `xf_attachment_CoverImage_3`.`attachment_id` = `xf_xa_sc_item`.`cover_image_id`)
    LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_4` ON (`xf_attachment_data_Data_4`.`data_id` = `xf_attachment_CoverImage_3`.`data_id`)
    LEFT JOIN `xf_xa_sc_item_feature` AS `xf_xa_sc_item_feature_Featured_5` ON (`xf_xa_sc_item_feature_Featured_5`.`item_id` = `xf_xa_sc_item`.`item_id`)
    WHERE (`xf_xa_sc_item`.`category_id` IN (14, 17, 7, 9, 8, 11, 12, 2, 18, 4, 5, 15, 13, 3, 6, 10, 16)) AND ((`xf_xa_sc_item`.`item_state` IN ('visible')))
    ORDER BY `xf_xa_sc_item`.`last_update` DESC
    
    LIMIT 24 OFFSET 432
    Run Time: 0.023905
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_sc_itemALLcategory_last_update,category_rating_weighted,category_author_rating   376Using where; Using filesort
    SIMPLExf_xa_sc_category_Category_1eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_xa_sc_item.category_id1 
    SIMPLExf_user_User_2eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_xa_sc_item.user_id1 
    SIMPLExf_attachment_CoverImage_3eq_refPRIMARY,content_type_id_datePRIMARY4nzwarrio_fans.xf_xa_sc_item.cover_image_id1Using where
    SIMPLExf_attachment_data_Data_4eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_attachment_CoverImage_3.data_id1Using where
    SIMPLExf_xa_sc_item_feature_Featured_5eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_xa_sc_item.item_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 86
    4. XenAddons\Showcase\ControllerPlugin\ItemList->getItemListData() in src/addons/XenAddons/Showcase/Pub/Controller/Item.php at line 32
    5. XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 34
    6. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    11. XF\App->run() in src/XF.php at line 390
    12. XF::runApp() in index.php at line 20
  5. SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
    FROM `xf_attachment`
    LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
    WHERE (`xf_attachment`.`content_type` = 'sc_item' AND `xf_attachment`.`content_id` IN (240, 239, 238, 237, 236, 235, 234, 233, 232, 231, 221, 220, 218, 217, 216, 215, 211, 180, 115, 105, 104, 94, 71, 31))
    ORDER BY `xf_attachment`.`attach_date` ASC
    Run Time: 0.002452
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrangecontent_type_id_datecontent_type_id_date31 158Using index condition; Using filesort
    SIMPLExf_attachment_data_Data_1eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_attachment.data_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Attachment.php at line 214
    4. XF\Repository\Attachment->addAttachmentsToContent() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 90
    5. XenAddons\Showcase\ControllerPlugin\ItemList->getItemListData() in src/addons/XenAddons/Showcase/Pub/Controller/Item.php at line 32
    6. XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 34
    7. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    12. XF\App->run() in src/XF.php at line 390
    13. XF::runApp() in index.php at line 20
  6. SELECT `xf_xa_sc_item`.*, `xf_xa_sc_category_Category_1`.*, `xf_user_User_2`.*, `xf_attachment_CoverImage_3`.*, `xf_attachment_data_Data_4`.*, `xf_xa_sc_item_feature_Featured_5`.*
    FROM `xf_xa_sc_item`
    LEFT JOIN `xf_xa_sc_category` AS `xf_xa_sc_category_Category_1` ON (`xf_xa_sc_category_Category_1`.`category_id` = `xf_xa_sc_item`.`category_id`)
    LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_xa_sc_item`.`user_id`)
    LEFT JOIN `xf_attachment` AS `xf_attachment_CoverImage_3` ON (`xf_attachment_CoverImage_3`.`content_type` = 'sc_item' AND `xf_attachment_CoverImage_3`.`content_id` = `xf_xa_sc_item`.`item_id` AND `xf_attachment_CoverImage_3`.`attachment_id` = `xf_xa_sc_item`.`cover_image_id`)
    LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_4` ON (`xf_attachment_data_Data_4`.`data_id` = `xf_attachment_CoverImage_3`.`data_id`)
    INNER JOIN `xf_xa_sc_item_feature` AS `xf_xa_sc_item_feature_Featured_5` ON (`xf_xa_sc_item_feature_Featured_5`.`item_id` = `xf_xa_sc_item`.`item_id`)
    WHERE (`xf_xa_sc_item`.`category_id` IN (14, 17, 7, 9, 8, 11, 12, 2, 18, 4, 5, 15, 13, 3, 6, 10, 16)) AND (`xf_xa_sc_item`.`item_state` = 'visible')
    ORDER BY RAND() ASC
    
    LIMIT 5
    Run Time: 0.008218
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_sc_item_feature_Featured_5indexPRIMARYfeature_date4 14Using index; Using temporary; Using filesort
    SIMPLExf_xa_sc_itemeq_refPRIMARY,category_last_update,category_rating_weighted,category_author_ratingPRIMARY4nzwarrio_fans.xf_xa_sc_item_feature_Featured_5.item_id1Using where
    SIMPLExf_xa_sc_category_Category_1eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_xa_sc_item.category_id1 
    SIMPLExf_user_User_2eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_xa_sc_item.user_id1 
    SIMPLExf_attachment_CoverImage_3eq_refPRIMARY,content_type_id_datePRIMARY4nzwarrio_fans.xf_xa_sc_item.cover_image_id1Using where
    SIMPLExf_attachment_data_Data_4eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_attachment_CoverImage_3.data_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 97
    4. XenAddons\Showcase\ControllerPlugin\ItemList->getItemListData() in src/addons/XenAddons/Showcase/Pub/Controller/Item.php at line 32
    5. XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 34
    6. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    11. XF\App->run() in src/XF.php at line 390
    12. XF::runApp() in index.php at line 20
  7. SELECT `xf_xa_sc_category`.*, `xf_permission_cache_content_Permissions_1`.*
    FROM `xf_xa_sc_category`
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'sc_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_sc_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
    
    ORDER BY `xf_xa_sc_category`.`lft` ASC
    Run Time: 0.000216
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_sc_categoryALL    17Using filesort
    SIMPLExf_permission_cache_content_Permissions_1eq_refPRIMARYPRIMARY35const,const,nzwarrio_fans.xf_xa_sc_category.category_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AbstractCategoryTree.php at line 67
    4. XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 147
    5. AL\ShowcaseFilter\XenAddons\Showcase\ControllerPlugin\ItemList->getAvailableItemSorts() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 373
    6. XenAddons\Showcase\ControllerPlugin\ItemList->getItemFilterInput() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 85
    7. AL\ShowcaseFilter\XenAddons\Showcase\ControllerPlugin\ItemList->getItemFilterInput() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 430
    8. XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 66
    9. AL\ShowcaseFilter\XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 43
    10. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    15. XF\App->run() in src/XF.php at line 390
    16. XF::runApp() in index.php at line 20
  8. SELECT `xf_xa_sc_category`.*, `xf_permission_cache_content_Permissions_1`.*
    FROM `xf_xa_sc_category`
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'sc_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_sc_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
    
    ORDER BY `xf_xa_sc_category`.`lft` ASC
    Run Time: 0.000164
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_sc_categoryALL    17Using filesort
    SIMPLExf_permission_cache_content_Permissions_1eq_refPRIMARYPRIMARY35const,const,nzwarrio_fans.xf_xa_sc_category.category_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AbstractCategoryTree.php at line 67
    4. XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 450
    5. XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 66
    6. AL\ShowcaseFilter\XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 43
    7. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    12. XF\App->run() in src/XF.php at line 390
    13. XF::runApp() in index.php at line 20
  9. SELECT prefix_id
    FROM xf_xa_sc_category_prefix
    WHERE category_id IN (14, 17, 7, 9, 8, 11, 12, 2, 18, 4, 5, 15, 13, 3, 6, 10, 16)
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_sc_category_prefixindexPRIMARYPRIMARY8 1Using where; Using index

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 170
    3. XF\Db\AbstractAdapter->fetchAllColumn() in src/XF/Repository/AbstractPrefixMap.php at line 185
    4. XF\Repository\AbstractPrefixMap->getPrefixIdsInContent() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 457
    5. XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 66
    6. AL\ShowcaseFilter\XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 43
    7. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    12. XF\App->run() in src/XF.php at line 390
    13. XF::runApp() in index.php at line 20
  10. SELECT `xf_xa_sc_item_prefix`.*
    FROM `xf_xa_sc_item_prefix`
    
    WHERE (0)
    ORDER BY `xf_xa_sc_item_prefix`.`materialized_order` ASC
    Run Time: 0.000080
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 460
    4. XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 66
    5. AL\ShowcaseFilter\XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 43
    6. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    11. XF\App->run() in src/XF.php at line 390
    12. XF::runApp() in index.php at line 20
  11. SELECT `xf_xa_sc_category`.*, `xf_permission_cache_content_Permissions_1`.*
    FROM `xf_xa_sc_category`
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'sc_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_sc_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
    
    ORDER BY `xf_xa_sc_category`.`lft` ASC
    Run Time: 0.000332
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_sc_categoryALL    17Using filesort
    SIMPLExf_permission_cache_content_Permissions_1eq_refPRIMARYPRIMARY35const,const,nzwarrio_fans.xf_xa_sc_category.category_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AbstractCategoryTree.php at line 67
    4. XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php at line 74
    5. AL\ShowcaseFilter\XenAddons\Showcase\ControllerPlugin\ItemList->actionFilters() in src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php at line 43
    6. AL\ShowcaseFilter\XenAddons\Showcase\Pub\Controller\Item->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    11. XF\App->run() in src/XF.php at line 390
    12. XF::runApp() in index.php at line 20
  12. -- 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, , , XenAddons\Showcase\Pub\Controller\Item, Index, valid, , 1566245721,
    Run Time: 0.000305

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
    4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
    5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
    6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 343
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    11. XF\App->run() in src/XF.php at line 390
    12. XF::runApp() in index.php at line 20
  13. 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.000897
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_siropu_ads_manager_adALLtype,status,status_display_order   6Using where; Using filesort
    SIMPLExf_siropu_ads_manager_package_Package_1eq_refPRIMARYPRIMARY4nzwarrio_fans.xf_siropu_ads_manager_ad.package_id1 
    SIMPLExf_template_MasterTemplate_2eq_reftype_title_style_idtype_title_style_id128const,func,const1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 407
    4. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 267
    5. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 258
    6. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 27
    7. Siropu\AdsManager\Listener::templaterGlobalData()
    8. call_user_func_array() in src/XF/Extension.php at line 67
    9. XF\Extension->fire() in src/XF/App.php at line 2647
    10. XF\App->fire() in src/XF/App.php at line 1915
    11. XF\App->getGlobalTemplateData() in src/XF/App.php at line 1793
    12. XF\App->preRender() in src/XF/Pub/App.php at line 435
    13. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 355
    14. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    16. XF\App->run() in src/XF.php at line 390
    17. XF::runApp() in index.php at line 20
  14. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('kl_em_hidden_content')
    Params: 1
    Run Time: 0.000160
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 351
    4. XF\Language->loadPhrases() in src/XF/Language.php at line 249
    5. XF\Language->getPhraseText() in src/XF/Language.php at line 167
    6. XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
    7. XF\Phrase->render() in src/XF/Phrase.php at line 59
    8. XF\Phrase->__toString()
    9. preg_replace() in src/addons/KL/EditorManager/XF/Str/Formatter.php at line 41
    10. KL\EditorManager\XF\Str\Formatter->snippetString() in src/XF/Template/Templater.php at line 3514
    11. XF\Template\Templater->fnSnippet()
    12. call_user_func_array() in src/XF/Template/Templater.php at line 922
    13. XF\Template\Templater->fn() in internal_data/code_cache/templates/l1/s19/public/metadata_macros.php at line 140
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    15. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s19/public/metadata_macros.php at line 40
    16. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    17. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s19/public/xa_sc_index.php at line 14
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    19. XF\Template\Templater->renderTemplate() in src/addons/AL/ShowcaseFilter/XF/Template/Templater.php at line 95
    20. AL\ShowcaseFilter\XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
    21. BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    22. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    23. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    24. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    25. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    26. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    27. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    28. XF\App->run() in src/XF.php at line 390
    29. XF::runApp() in index.php at line 20
  15. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 277
    Run Time: 0.000256
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
    6. XF\Entity\User->hasPermission() in src/addons/ThemeHouse/UserImprovements/XF/Template/Templater.php at line 23
    7. ThemeHouse\UserImprovements\XF\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 3876
    8. XF\Template\Templater->fnUsernameLink()
    9. call_user_func_array() in src/XF/Template/Templater.php at line 922
    10. XF\Template\Templater->fn() in internal_data/code_cache/templates/l1/s19/public/xa_sc_item_list_macros.php at line 237
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    12. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s19/public/xa_sc_index.php at line 218
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    14. XF\Template\Templater->renderTemplate() in src/addons/AL/ShowcaseFilter/XF/Template/Templater.php at line 95
    15. AL\ShowcaseFilter\XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
    16. BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    17. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    18. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    19. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    20. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    21. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    22. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    23. XF\App->run() in src/XF.php at line 390
    24. XF::runApp() in index.php at line 20
  16. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 270
    Run Time: 0.000102
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
    6. XF\Entity\User->hasPermission() in src/addons/ThemeHouse/UserImprovements/XF/Template/Templater.php at line 23
    7. ThemeHouse\UserImprovements\XF\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 3876
    8. XF\Template\Templater->fnUsernameLink()
    9. call_user_func_array() in src/XF/Template/Templater.php at line 922
    10. XF\Template\Templater->fn() in internal_data/code_cache/templates/l1/s19/public/xa_sc_item_list_macros.php at line 237
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    12. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s19/public/xa_sc_index.php at line 218
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    14. XF\Template\Templater->renderTemplate() in src/addons/AL/ShowcaseFilter/XF/Template/Templater.php at line 95
    15. AL\ShowcaseFilter\XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
    16. BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    17. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    18. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    19. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    20. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    21. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    22. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    23. XF\App->run() in src/XF.php at line 390
    24. XF::runApp() in index.php at line 20

Included Files (308, XenForo Classes: 105)

  1. index.php
  2. src/XF.php
  3. src/vendor/autoload.php
  4. src/vendor/composer/autoload_real.php
  5. src/vendor/composer/ClassLoader.php
  6. src/vendor/composer/autoload_static.php
  7. src/vendor/symfony/polyfill-mbstring/bootstrap.php
  8. src/vendor/paragonie/random_compat/lib/random.php
  9. src/vendor/ralouphie/getallheaders/src/getallheaders.php
  10. src/vendor/guzzlehttp/promises/src/functions_include.php
  11. src/vendor/guzzlehttp/promises/src/functions.php
  12. src/vendor/guzzlehttp/psr7/src/functions_include.php
  13. src/vendor/guzzlehttp/psr7/src/functions.php
  14. src/vendor/guzzlehttp/guzzle/src/functions_include.php
  15. src/vendor/guzzlehttp/guzzle/src/functions.php
  16. src/vendor/paragonie/sodium_compat/autoload.php
  17. src/vendor/paragonie/sodium_compat/src/SodiumException.php
  18. src/vendor/paragonie/sodium_compat/lib/namespaced.php
  19. src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
  20. src/vendor/paragonie/sodium_compat/lib/constants.php
  21. src/vendor/paragonie/sodium_compat/src/Compat.php
  22. src/vendor/symfony/polyfill-ctype/bootstrap.php
  23. src/vendor/symfony/polyfill-php56/bootstrap.php
  24. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
  25. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
  26. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  27. src/vendor/dokuwiki/utf8/utf8.php
  28. src/XF/Http/Request.php
  29. src/XF/InputFilterer.php
  30. src/XF/Pub/App.php
  31. src/XF/App.php
  32. src/XF/Container.php
  33. src/config.php
  34. src/XF/DataRegistry.php
  35. src/XF/Db/Mysqli/Adapter.php
  36. src/XF/Db/AbstractAdapter.php
  37. src/XF/CacheFactory.php
  38. src/XF/Cache/MemcachedCache.php
  39. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MemcachedCache.php
  40. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  41. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  42. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  43. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  44. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  45. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
  46. src/XF/Extension.php
  47. src/XF/AddOn/Manager.php
  48. src/addons/BR/ModernStatistic/Listener.php
  49. src/addons/Siropu/AdsManager/Listener.php
  50. src/addons/ThemeHouse/ReactPlus/Listener/App.php
  51. src/addons/XenAddons/AMS/Listener.php
  52. src/addons/XenAddons/Showcase/Listener.php
  53. src/addons/XenAddons/Sportsbook/Listener.php
  54. src/addons/XFMG/Listener.php
  55. src/XF/PageCache.php
  56. src/XF/Session/Session.php
  57. src/XF/Session/CacheStorage.php
  58. src/XF/Session/StorageInterface.php
  59. src/XF/Util/Ip.php
  60. src/XF/Util/Random.php
  61. src/XF/Http/Response.php
  62. src/XF/Mvc/Entity/Manager.php
  63. src/XF/Mvc/Entity/ValueFormatter.php
  64. src/XF/Repository/User.php
  65. src/XF/Mvc/Entity/Repository.php
  66. src/XF/Entity/User.php
  67. src/XF/Mvc/Entity/Entity.php
  68. src/addons/ThemeHouse/UserImprovements/XF/Entity/User.php
  69. src/addons/XenAddons/AMS/XF/Entity/User.php
  70. src/addons/XenAddons/Pickem/XF/Entity/User.php
  71. src/addons/Siropu/AdsManager/XF/Entity/User.php
  72. src/addons/XenAddons/Showcase/XF/Entity/User.php
  73. src/addons/XenAddons/Sportsbook/XF/Entity/User.php
  74. src/addons/XFMG/XF/Entity/User.php
  75. src/XF/Mvc/Entity/Structure.php
  76. src/addons/KL/EditorManager/Listener/EntityStructure.php
  77. src/XF/Entity/UserAuth.php
  78. src/XF/Entity/UserOption.php
  79. src/XF/Entity/UserProfile.php
  80. src/addons/XenAddons/AMS/XF/Entity/UserProfile.php
  81. src/XF/Entity/UserPrivacy.php
  82. src/addons/ThemeHouse/UserImprovements/XF/Entity/UserPrivacy.php
  83. src/XF/Util/File.php
  84. src/XF/Language.php
  85. src/XF/Mvc/Dispatcher.php
  86. src/XF/Mvc/Router.php
  87. src/XF/Mvc/RouteMatch.php
  88. src/XF/Util/Arr.php
  89. src/XF/Mvc/ParameterBag.php
  90. src/addons/XenAddons/Showcase/Pub/Controller/Item.php
  91. src/addons/XenAddons/Showcase/Pub/Controller/AbstractController.php
  92. src/XF/Pub/Controller/AbstractController.php
  93. src/XF/Mvc/Controller.php
  94. src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Pub/Controller/Item.php
  95. src/XF/Util/Php.php
  96. src/XF/PermissionCache.php
  97. src/XF/PermissionSet.php
  98. src/XF/Db/Mysqli/Statement.php
  99. src/XF/Db/AbstractStatement.php
  100. src/addons/XenAddons/Showcase/ControllerPlugin/ItemList.php
  101. src/XF/ControllerPlugin/AbstractPlugin.php
  102. src/addons/AL/ShowcaseFilter/XenAddons/Showcase/ControllerPlugin/ItemList.php
  103. src/addons/XenAddons/Showcase/Repository/Category.php
  104. src/XF/Repository/AbstractCategoryTree.php
  105. src/addons/XenAddons/Showcase/Entity/Category.php
  106. src/XF/Entity/AbstractCategoryTree.php
  107. src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Entity/Category.php
  108. src/XF/Mvc/Entity/Finder.php
  109. src/XF/Entity/PermissionCacheContent.php
  110. src/XF/Mvc/Entity/Proxyable.php
  111. src/XF/Mvc/Entity/FinderCollection.php
  112. src/XF/Mvc/Entity/AbstractCollection.php
  113. src/XF/Mvc/Entity/ArrayCollection.php
  114. src/XF/Tree.php
  115. src/XF/SubTree.php
  116. src/XF/Str/Formatter.php
  117. src/addons/KL/EditorManager/XF/Str/Formatter.php
  118. src/addons/XenAddons/Showcase/Repository/Item.php
  119. src/addons/XenAddons/Showcase/Entity/Item.php
  120. src/addons/XenAddons/Showcase/Entity/CommentableTrait.php
  121. src/XF/Entity/ReactionTrait.php
  122. src/XF/Entity/BookmarkTrait.php
  123. src/XF/BbCode/RenderableContentInterface.php
  124. src/addons/AL/ShowcaseFilter/XenAddons/Showcase/Entity/Item.php
  125. src/addons/AL/ShowcaseFilter/App.php
  126. src/addons/AddonsLab/Core/App.php
  127. src/addons/AddonsLab/Core/Xf2/AppTrait.php
  128. src/addons/AL/FilterFramework/FilterApp.php
  129. src/addons/AL/ShowcaseFilter/Service/ContentTypeProvider.php
  130. src/XF/Service/AbstractService.php
  131. src/addons/AL/FilterFramework/ContentTypeProviderInterface.php
  132. src/addons/AL/FilterFramework/Service/ContextProvider.php
  133. src/addons/XenAddons/Showcase/Finder/Item.php
  134. src/XF/Entity/Attachment.php
  135. src/XF/Entity/AttachmentData.php
  136. src/addons/XenAddons/Showcase/Entity/ItemFeature.php
  137. src/XF/CustomField/DefinitionSet.php
  138. src/XF/CustomField/Definition.php
  139. src/addons/AL/ShowcaseFilter/XF/CustomField/Definition.php
  140. src/XF/Repository/Attachment.php
  141. src/XF/Mvc/Entity/FinderExpression.php
  142. src/XF/Mvc/Reply/View.php
  143. src/XF/Mvc/Reply/AbstractReply.php
  144. src/addons/XenAddons/Showcase/Repository/CategoryPrefix.php
  145. src/XF/Repository/AbstractPrefixMap.php
  146. src/addons/XenAddons/Showcase/Entity/CategoryPrefix.php
  147. src/XF/Entity/AbstractPrefixMap.php
  148. src/addons/XenAddons/Showcase/Repository/ItemPrefix.php
  149. src/XF/Repository/AbstractPrefix.php
  150. src/addons/XenAddons/Showcase/Entity/ItemPrefix.php
  151. src/XF/Entity/AbstractPrefix.php
  152. src/addons/AddonsLab/Core/Xf2/Xf2OptionProvider.php
  153. src/addons/AddonsLab/Core/OptionProviderInterface.php
  154. src/addons/AddonsLab/Core/Xf2/Xf2RegistryProvider.php
  155. src/addons/AddonsLab/Core/RegistryProviderInterface.php
  156. src/addons/AL/FilterFramework/Service/RequestHelper.php
  157. src/addons/AL/FilterFramework/Service/DisplayFormatter.php
  158. src/XF/Repository/SessionActivity.php
  159. src/XF/Data/Robot.php
  160. src/XF/Style.php
  161. src/XF/Template/Templater.php
  162. src/addons/xenMade/KWM/XF/Template/Templater.php
  163. src/addons/ThemeHouse/UserImprovements/XF/Template/Templater.php
  164. src/addons/AL/ShowcaseFilter/XF/Template/Templater.php
  165. src/addons/ThemeHouse/ReactPlus/XF/Template/Templater.php
  166. src/addons/BR/ModernStatistic/XF/Template/Templater.php
  167. src/addons/xenMade/KWM/Util/Replacer.php
  168. src/XF/SimpleCache.php
  169. src/XF/SimpleCacheSet.php
  170. src/XF/DevelopmentOutput.php
  171. src/XF/DevelopmentOutput/Template.php
  172. src/XF/DevelopmentOutput/AbstractHandler.php
  173. src/XF/Template/WatcherInterface.php
  174. src/XF/SubContainer/BbCode.php
  175. src/XF/SubContainer/AbstractSubContainer.php
  176. src/XF/SubContainer/Widget.php
  177. src/addons/ThemeHouse/ReactPlus/Listener/Templater.php
  178. src/addons/XenAddons/Pickem/Listener.php
  179. src/addons/XFMG/Template/TemplaterSetup.php
  180. src/addons/MJCore/Listener.php
  181. src/addons/MJCore/Helpers.php
  182. src/addons/MJCore/1000000/Listener.php
  183. src/addons/Siropu/AdsManager/Template/Ad.php
  184. src/addons/Siropu/AdsManager/Util/Arr.php
  185. src/addons/Siropu/AdsManager/Repository/Ad.php
  186. src/addons/Siropu/AdsManager/Entity/Ad.php
  187. src/addons/Siropu/AdsManager/Entity/AbstractEntity.php
  188. src/addons/Siropu/AdsManager/Finder/Ad.php
  189. src/addons/Siropu/AdsManager/Entity/Package.php
  190. src/XF/Entity/Template.php
  191. src/XF/Criteria/User.php
  192. src/XF/Criteria/AbstractCriteria.php
  193. src/XF/Criteria/Page.php
  194. src/addons/Siropu/AdsManager/Criteria/Device.php
  195. src/addons/Siropu/AdsManager/Vendor/MobileDetect/Mobile_Detect.php
  196. src/addons/Siropu/AdsManager/Criteria/Geo.php
  197. src/addons/Siropu/AdsManager/Vendor/MaxMind/autoload.php
  198. src/addons/Siropu/AdsManager/Vendor/MaxMind/composer/autoload_real.php
  199. src/addons/Siropu/AdsManager/Vendor/MaxMind/composer/autoload_static.php
  200. src/addons/Siropu/AdsManager/Criteria/Position.php
  201. src/addons/Siropu/Custom404Page/Listener.php
  202. src/XF/Mvc/Renderer/Html.php
  203. src/XF/Mvc/Renderer/AbstractRenderer.php
  204. src/XF/Mvc/View.php
  205. src/XF/Template/Template.php
  206. src/addons/xenMade/KWM/Listener.php
  207. internal_data/code_cache/templates/l1/s19/public/xa_sc_index.php
  208. src/XF/PreEscaped.php
  209. internal_data/code_cache/templates/l1/s19/public/metadata_macros.php
  210. src/XF/Phrase.php
  211. internal_data/code_cache/templates/l1/s19/public/xa_sc_index_macros.php
  212. internal_data/code_cache/templates/l1/s19/public/alsf_above_showcase_filter_container.php
  213. internal_data/code_cache/templates/l1/s19/public/page_nav.php
  214. internal_data/code_cache/templates/l1/s19/public/alsf_category_view_active_filters.php
  215. internal_data/code_cache/templates/l1/s19/public/alsf_filter_icon_replace_filter.php
  216. internal_data/code_cache/templates/l1/s19/public/xa_sc_item_list_macros.php
  217. src/XF/CustomField/Set.php
  218. internal_data/code_cache/templates/l1/s19/public/alsf_list_prefix.php
  219. internal_data/code_cache/templates/l1/s19/public/alsf_list_metadata.php
  220. internal_data/code_cache/templates/l1/s19/public/alsf_sc_item_field_column_list.php
  221. internal_data/code_cache/templates/l1/s19/public/rating_macros.php
  222. internal_data/code_cache/templates/l1/s19/public/xa_sc_category_list_macros.php
  223. internal_data/code_cache/widgets/_30_default_showcase_filter_widget.php
  224. src/XF/Widget/WidgetConfig.php
  225. src/addons/AL/ShowcaseFilter/Widget/ShowcaseFilter.php
  226. src/XF/Widget/AbstractWidget.php
  227. internal_data/code_cache/phrase_groups/l1/widget.php
  228. src/XF/Widget/WidgetRenderer.php
  229. internal_data/code_cache/templates/l1/s19/public/alsf_sidebar_filter_container.php
  230. internal_data/code_cache/templates/l1/s19/public/xa_sc_filters.php
  231. internal_data/code_cache/templates/l1/s19/public/alsf_showcase_filter_popup_form.php
  232. internal_data/code_cache/templates/l1/s19/public/alsf_showcase_filter_form_macros.php
  233. internal_data/code_cache/templates/l1/s19/public/token_input.php
  234. internal_data/code_cache/phrase_groups/l1/xa_sc_item_field_title.php
  235. internal_data/code_cache/templates/l1/s19/public/alsf_sc_item_field_form_element.php
  236. internal_data/code_cache/widgets/_16_xa_sc_showcase_statistics.php
  237. src/addons/XenAddons/Showcase/Widget/ShowcaseStatistics.php
  238. internal_data/code_cache/phrase_groups/l1/widget_def.php
  239. internal_data/code_cache/templates/l1/s19/public/xa_sc_widget_showcase_statistics.php
  240. internal_data/code_cache/navigation_cache.php
  241. src/XF/Pub/Route/Search.php
  242. src/XF/NoticeList.php
  243. src/addons/AddonsLab/Licensing/LicenseValidationService.php
  244. src/addons/AddonsLab/Licensing/Checker.php
  245. src/addons/AL/ShowcaseFilter/Licensing/Engine/Xf2.php
  246. src/addons/AddonsLab/Licensing/Engine/Xf2.php
  247. src/addons/AddonsLab/Licensing/Engine/AbstractEngine.php
  248. src/addons/AddonsLab/Licensing/Engine/AbstractEngineInterface.php
  249. src/addons/AddonsLab/Licensing/StorageDriver/File.php
  250. src/addons/AddonsLab/Licensing/StorageDriver/AbstractStorageDriver.php
  251. src/addons/AddonsLab/Licensing/StorageDriver/Database.php
  252. src/addons/AddonsLab/Licensing/LicenseData.php
  253. src/addons/AddonsLab/Licensing/Encoder.php
  254. src/addons/KL/EditorManager/Listener/TemplaterTemplatePreRender.php
  255. src/addons/KL/EditorManager/Repository/Font.php
  256. internal_data/code_cache/templates/l1/s19/public/PAGE_CONTAINER.php
  257. src/XF/CssRenderer.php
  258. src/addons/ThemeHouse/ReactPlus/XF/CssRenderer.php
  259. src/XF/Less/RtlVisitorPre.php
  260. src/vendor/oyejorge/less.php/lib/Less/VisitorReplacing.php
  261. src/vendor/oyejorge/less.php/lib/Less/Visitor.php
  262. src/XF/Less/RtlVisitor.php
  263. src/vendor/oyejorge/less.php/lib/Less/Parser.php
  264. src/vendor/oyejorge/less.php/lib/Less/Cache.php
  265. src/vendor/oyejorge/less.php/lib/Less/Version.php
  266. src/vendor/oyejorge/less.php/lib/Less/Environment.php
  267. src/vendor/oyejorge/less.php/lib/Less/Tree/Color.php
  268. src/vendor/oyejorge/less.php/lib/Less/Tree.php
  269. src/vendor/oyejorge/less.php/lib/Less/Tree/Expression.php
  270. src/vendor/oyejorge/less.php/lib/Less/Tree/Value.php
  271. src/vendor/oyejorge/less.php/lib/Less/Tree/Rule.php
  272. src/vendor/oyejorge/less.php/lib/Less/Tree/Element.php
  273. src/vendor/oyejorge/less.php/lib/Less/Tree/Selector.php
  274. src/vendor/oyejorge/less.php/lib/Less/Tree/Keyword.php
  275. src/vendor/oyejorge/less.php/lib/Less/Tree/Variable.php
  276. src/vendor/oyejorge/less.php/lib/Less/Tree/Ruleset.php
  277. src/vendor/oyejorge/less.php/lib/Less/Tree/DefaultFunc.php
  278. src/vendor/oyejorge/less.php/lib/Less/Visitor/joinSelector.php
  279. src/vendor/oyejorge/less.php/lib/Less/Visitor/toCSS.php
  280. src/vendor/oyejorge/less.php/lib/Less/Output.php
  281. src/vendor/oyejorge/less.php/lib/Less/Functions.php
  282. internal_data/code_cache/templates/l1/s19/public/xb_custom_fonts.php
  283. internal_data/code_cache/templates/l1/s19/public/helper_js_global.php
  284. internal_data/code_cache/templates/l1/s19/public/font_awesome_setup.php
  285. internal_data/code_cache/templates/l1/s19/public/google_analytics.php
  286. internal_data/code_cache/templates/l1/s19/public/xb_head.php
  287. internal_data/code_cache/templates/l1/s19/public/siropu_ads_manager_ad_macros.php
  288. internal_data/code_cache/templates/l1/s19/public/kl_em_PAGE_CONTAINER.php
  289. src/addons/Siropu/AdsManager/Service/Stats/Tracker.php
  290. internal_data/code_cache/templates/l1/s19/public/siropu_ads_manager_content_below_unit.php
  291. internal_data/code_cache/templates/l1/s19/public/_ads.php
  292. src/addons/BR/ModernStatistic/Service/ModernStatistic/Render.php
  293. src/addons/BR/ModernStatistic/Repository/ModernStatistic.php
  294. internal_data/code_cache/templates/l1/s19/public/xb_social_icons.php
  295. internal_data/code_cache/phrase_groups/l1/nav.php
  296. internal_data/code_cache/templates/l1/s19/public/alsf_filter_icon_search.php
  297. internal_data/code_cache/phrase_groups/l1/button.php
  298. internal_data/code_cache/templates/l1/s19/public/alsf_filter_mobile.php
  299. internal_data/code_cache/templates/l1/s19/public/xb_welcome.php
  300. internal_data/code_cache/templates/l1/s19/public/browser_warning_macros.php
  301. internal_data/code_cache/templates/l1/s19/public/xb_footer.php
  302. internal_data/code_cache/templates/l1/s19/public/debug_macros.php
  303. internal_data/code_cache/templates/l1/s19/public/siropu_ads_manager_ad_js.php
  304. internal_data/code_cache/templates/l1/s19/public/th_reactplus_reaction_macros.php
  305. internal_data/code_cache/templates/l1/s19/public/xb_body_helper.php
  306. internal_data/code_cache/templates/l1/s19/public/xb_body.php
  307. internal_data/code_cache/phrase_groups/l1/reaction_title.php
  308. src/XF/Debugger.php

DB Connection Stats

bytes_sent16208
bytes_received511585
packets_sent190
packets_received2268
protocol_overhead_in9072
protocol_overhead_out760
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet621
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet183
bytes_received_prepare_response_packet158223
bytes_received_change_user_packet351808
packets_sent_command94
packets_received_ok0
packets_received_eof0
packets_received_rset_header69
packets_received_rset_field_meta0
packets_received_rset_row33
packets_received_prepare_response1805
packets_received_change_user328
result_set_queries30
non_result_set_queries3
no_index_used9
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets30
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed30
rows_fetched_from_server_normal0
rows_fetched_from_server_ps298
rows_buffered_from_client_normal0
rows_buffered_from_client_ps298
rows_fetched_from_client_normal_buffered0
rows_fetched_from_client_normal_unbuffered0
rows_fetched_from_client_ps_buffered0
rows_fetched_from_client_ps_unbuffered0
rows_fetched_from_client_ps_cursor0
rows_affected_normal0
rows_affected_ps0
rows_skipped_normal0
rows_skipped_ps298
copy_on_write_saved0
copy_on_write_performed0
command_buffer_too_small0
connect_success1
connect_failure0
connection_reused0
reconnect0
pconnect_success1
active_connections1
active_persistent_connections1
explicit_close0
implicit_close0
disconnect_close0
in_middle_of_command_close0
explicit_free_result0
implicit_free_result0
explicit_stmt_close0
implicit_stmt_close0
mem_emalloc_count0
mem_emalloc_amount0
mem_ecalloc_count0
mem_ecalloc_amount0
mem_erealloc_count0
mem_erealloc_amount0
mem_efree_count0
mem_efree_amount0
mem_malloc_count0
mem_malloc_amount0
mem_calloc_count0
mem_calloc_amount0
mem_realloc_count0
mem_realloc_amount0
mem_free_count0
mem_free_amount0
mem_estrndup_count0
mem_strndup_count0
mem_estrdup_count0
mem_strdup_count0
mem_edupl_count0
mem_dupl_count0
proto_text_fetched_null0
proto_text_fetched_bit0
proto_text_fetched_tinyint0
proto_text_fetched_short0
proto_text_fetched_int240
proto_text_fetched_int0
proto_text_fetched_bigint0
proto_text_fetched_decimal0
proto_text_fetched_float0
proto_text_fetched_double0
proto_text_fetched_date0
proto_text_fetched_year0
proto_text_fetched_time0
proto_text_fetched_datetime0
proto_text_fetched_timestamp0
proto_text_fetched_string0
proto_text_fetched_blob0
proto_text_fetched_enum0
proto_text_fetched_set0
proto_text_fetched_geometry0
proto_text_fetched_other0
proto_binary_fetched_null0
proto_binary_fetched_bit527
proto_binary_fetched_tinyint0
proto_binary_fetched_short1996
proto_binary_fetched_int24339
proto_binary_fetched_int0
proto_binary_fetched_bigint5978
proto_binary_fetched_decimal64
proto_binary_fetched_float35
proto_binary_fetched_double116
proto_binary_fetched_date0
proto_binary_fetched_year0
proto_binary_fetched_time0
proto_binary_fetched_datetime0
proto_binary_fetched_timestamp0
proto_binary_fetched_string0
proto_binary_fetched_json3084
proto_binary_fetched_blob1747
proto_binary_fetched_enum0
proto_binary_fetched_set0
proto_binary_fetched_geometry0
proto_binary_fetched_other0
init_command_executed_count0
init_command_failed_count0
com_quit0
com_init_db0
com_query2
com_field_list0
com_create_db0
com_drop_db0
com_refresh0
com_shutdown0
com_statistics0
com_process_info0
com_connect0
com_process_kill0
com_debug0
com_ping0
com_time0
com_delayed_insert0
com_change_user0
com_binlog_dump0
com_table_dump0
com_connect_out0
com_register_slave0
com_stmt_prepare31
com_stmt_execute31
com_stmt_send_long_data0
com_stmt_close30
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps343008