Page Time: 0.1496s

Memory: 5.2427 MB (Peak: 5.8377 MB)

Queries (36, time: 0.0282s, 18.8%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000361
    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_dbtech_ecommerce_category`.*, `xf_permission_cache_content_Permissions_1`.*
    FROM `xf_dbtech_ecommerce_category`
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'dbtech_ecommerce_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_dbtech_ecommerce_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
    
    ORDER BY `xf_dbtech_ecommerce_category`.`lft` ASC
    Run Time: 0.000768
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_categoryALL    16Using filesort
    SIMPLExf_permission_cache_content_Permissions_1eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_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/DBTech/eCommerce/ControllerPlugin/Overview.php at line 22
    5. DBTech\eCommerce\ControllerPlugin\Overview->getCategoryListData() in src/addons/DBTech/eCommerce/Pub/Controller/Product.php at line 58
    6. DBTech\eCommerce\Pub\Controller\Product->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
  3. SELECT COUNT(*)
    FROM `xf_dbtech_ecommerce_product`
    
    WHERE (`xf_dbtech_ecommerce_product`.`product_category_id` IN (1, 17, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)) AND (`xf_dbtech_ecommerce_product`.`parent_product_id` = 0) AND ((`xf_dbtech_ecommerce_product`.`product_state` IN ('visible')))
    Run Time: 0.000365
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_productALLcategory_last_update,category_rating_weighted   97Using 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/DBTech/eCommerce/ControllerPlugin/Overview.php at line 55
    5. DBTech\eCommerce\ControllerPlugin\Overview->getCoreListData() in src/addons/DBTech/eCommerce/Pub/Controller/Product.php at line 61
    6. DBTech\eCommerce\Pub\Controller\Product->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
  4. SELECT `xf_dbtech_ecommerce_product`.*, `xf_dbtech_ecommerce_product_sale_Sale_1`.*, `xf_dbtech_ecommerce_download_LatestVersion_2`.*, `xf_permission_cache_content_Permissions_3`.*, `xf_user_User_4`.*, `xf_dbtech_ecommerce_category_Category_5`.*, `xf_permission_cache_content_Permissions_6`.*
    FROM `xf_dbtech_ecommerce_product`
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_1` ON (`xf_dbtech_ecommerce_product_sale_Sale_1`.`product_id` = `xf_dbtech_ecommerce_product`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_download` AS `xf_dbtech_ecommerce_download_LatestVersion_2` ON (`xf_dbtech_ecommerce_download_LatestVersion_2`.`download_id` = `xf_dbtech_ecommerce_product`.`latest_version_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'dbtech_ecommerce_product' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_dbtech_ecommerce_product`.`product_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
    LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_dbtech_ecommerce_product`.`user_id`)
    LEFT JOIN `xf_dbtech_ecommerce_category` AS `xf_dbtech_ecommerce_category_Category_5` ON (`xf_dbtech_ecommerce_category_Category_5`.`category_id` = `xf_dbtech_ecommerce_product`.`product_category_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'dbtech_ecommerce_category' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_dbtech_ecommerce_category_Category_5`.`category_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1')
    WHERE (`xf_dbtech_ecommerce_product`.`product_category_id` IN (1, 17, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)) AND (`xf_dbtech_ecommerce_product`.`parent_product_id` = 0) AND ((`xf_dbtech_ecommerce_product`.`product_state` IN ('visible')))
    ORDER BY `xf_dbtech_ecommerce_product`.`last_update` DESC
    
    LIMIT 20
    Run Time: 0.006758
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_productALLcategory_last_update,category_rating_weighted   97Using where; Using temporary; Using filesort
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_1ALLPRIMARY   1Using where; Using join buffer (Block Nested Loop)
    SIMPLExf_dbtech_ecommerce_download_LatestVersion_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product.latest_version_id1 
    SIMPLExf_permission_cache_content_Permissions_3eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_product.product_id1Using where
    SIMPLExf_user_User_4eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product.user_id1 
    SIMPLExf_dbtech_ecommerce_category_Category_5eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product.product_category_id1 
    SIMPLExf_permission_cache_content_Permissions_6eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_category_Category_5.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/addons/DBTech/eCommerce/ControllerPlugin/Overview.php at line 61
    4. DBTech\eCommerce\ControllerPlugin\Overview->getCoreListData() in src/addons/DBTech/eCommerce/Pub/Controller/Product.php at line 61
    5. DBTech\eCommerce\Pub\Controller\Product->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
    7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    10. XF\App->run() in src/XF.php at line 390
    11. XF::runApp() in index.php at line 20
  5. -- 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, 暁, 暁, DBTech\eCommerce\Pub\Controller\Product, Index, valid, , 1590458695,
    Run Time: 0.000203

    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
  6. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 90)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000778
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  7. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 89)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000573
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  8. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 88)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000539
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  9. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 17)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000623
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  10. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 78)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000547
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  11. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 16)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000526
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  12. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 86)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000565
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  13. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 12)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000540
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  14. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 14)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000747
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  15. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 11)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000578
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  16. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 10)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000698
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  17. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 13)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000536
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  18. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 94)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000559
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  19. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 18)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.001035
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  20. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 105)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000562
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  21. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 15)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000547
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  22. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 97)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000532
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  23. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 100)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000531
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  24. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 103)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000531
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 492
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 145
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    18. XF\App->run() in src/XF.php at line 390
    19. XF::runApp() in index.php at line 20
  25. SELECT `xf_dbtech_ecommerce_product`.*, `xf_dbtech_ecommerce_category_Category_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*
    FROM `xf_dbtech_ecommerce_product`
    LEFT JOIN `xf_dbtech_ecommerce_category` AS `xf_dbtech_ecommerce_category_Category_1` ON (`xf_dbtech_ecommerce_category_Category_1`.`category_id` = `xf_dbtech_ecommerce_product`.`product_category_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'dbtech_ecommerce_category' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_dbtech_ecommerce_category_Category_1`.`category_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
    LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_dbtech_ecommerce_product`.`user_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'dbtech_ecommerce_product' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_dbtech_ecommerce_product`.`product_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
    WHERE (`xf_dbtech_ecommerce_product`.`parent_product_id` = 0) AND (`xf_dbtech_ecommerce_product`.`rating_count` > 0) AND (`xf_dbtech_ecommerce_product`.`product_state` = 'visible')
    ORDER BY `xf_dbtech_ecommerce_product`.`rating_weighted` DESC
    
    LIMIT 10
    Run Time: 0.001401
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_productindex rating_weighted4 10Using where
    SIMPLExf_dbtech_ecommerce_category_Category_1eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product.product_category_id1 
    SIMPLExf_permission_cache_content_Permissions_2eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_category_Category_1.category_id1Using where
    SIMPLExf_user_User_3eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product.user_id1 
    SIMPLExf_permission_cache_content_Permissions_4eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_product.product_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/DBTech/eCommerce/Widget/TopProducts.php at line 101
    4. DBTech\eCommerce\Widget\TopProducts->render() in internal_data/code_cache/widgets/_11_dbtech_ecommerce_list_top_products.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1620
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 249
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    17. XF\App->run() in src/XF.php at line 390
    18. XF::runApp() in index.php at line 20
  26. SELECT `xf_dbtech_ecommerce_product_cost`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_cost`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_cost`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_cost`.`product_id` = 93)
    ORDER BY `xf_dbtech_ecommerce_product_cost`.`cost_amount` ASC
    Run Time: 0.000542
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_costALL    64Using where; Using filesort
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_sale_Sale_2eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_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/Mvc/Entity/Manager.php at line 378
    4. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    5. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    6. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    7. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 574
    8. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    9. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_widget_top_products.php at line 117
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    12. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    13. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1620
    14. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 249
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    16. 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
  27. SELECT `xf_dbtech_ecommerce_product_sale`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_dbtech_ecommerce_product_sale_Sale_2`.*
    FROM `xf_dbtech_ecommerce_product_sale`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_sale`.`product_id`)
    LEFT JOIN `xf_dbtech_ecommerce_product_sale` AS `xf_dbtech_ecommerce_product_sale_Sale_2` ON (`xf_dbtech_ecommerce_product_sale_Sale_2`.`product_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_product_sale`.`product_id` = 93)
    
    
    LIMIT 1
    Run Time: 0.000385
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables

    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 1261
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
    4. XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
    5. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    6. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    7. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
    8. XF\Mvc\Entity\Entity->__get() in src/addons/DBTech/eCommerce/Entity/ProductCost.php at line 122
    9. DBTech\eCommerce\Entity\ProductCost->getPrice() in src/addons/DBTech/eCommerce/Entity/Product.php at line 228
    10. DBTech\eCommerce\Entity\Product->getStartingPrice() in src/XF/Mvc/Entity/Entity.php at line 148
    11. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    12. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 579
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_widget_top_products.php at line 117
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    16. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    17. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    18. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1620
    19. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 249
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    21. 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
  28. SELECT `xf_dbtech_ecommerce_download`.*, `xf_dbtech_ecommerce_product_Product_1`.*
    FROM `xf_dbtech_ecommerce_download`
    LEFT JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_download`.`product_id`)
    WHERE (`xf_dbtech_ecommerce_download`.`download_id` = 128)
    
    
    LIMIT 1
    Run Time: 0.000468
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_downloadconstPRIMARYPRIMARY4const1 
    SIMPLExf_dbtech_ecommerce_product_Product_1constPRIMARYPRIMARY4const1 

    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 1261
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
    4. XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
    5. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
    6. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
    7. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
    8. XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php at line 618
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    10. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_widget_top_products.php at line 117
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    12. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    13. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    14. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1620
    15. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 249
    16. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    17. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    18. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    19. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    20. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    21. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    22. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    23. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    24. XF\App->run() in src/XF.php at line 390
    25. XF::runApp() in index.php at line 20
  29. SELECT `xf_dbtech_ecommerce_product_rating`.*, `xf_dbtech_ecommerce_product_Product_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_dbtech_ecommerce_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_User_5`.*
    FROM `xf_dbtech_ecommerce_product_rating`
    INNER JOIN `xf_dbtech_ecommerce_product` AS `xf_dbtech_ecommerce_product_Product_1` ON (`xf_dbtech_ecommerce_product_Product_1`.`product_id` = `xf_dbtech_ecommerce_product_rating`.`product_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'dbtech_ecommerce_product' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
    LEFT JOIN `xf_dbtech_ecommerce_category` AS `xf_dbtech_ecommerce_category_Category_3` ON (`xf_dbtech_ecommerce_category_Category_3`.`category_id` = `xf_dbtech_ecommerce_product_Product_1`.`product_category_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'dbtech_ecommerce_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_dbtech_ecommerce_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
    LEFT JOIN `xf_user` AS `xf_user_User_5` ON (`xf_user_User_5`.`user_id` = `xf_dbtech_ecommerce_product_rating`.`user_id`)
    WHERE (`xf_dbtech_ecommerce_product_Product_1`.`product_state` = 'visible' AND `xf_dbtech_ecommerce_product_rating`.`rating_state` = 'visible' AND `xf_dbtech_ecommerce_product_rating`.`is_review` = 1) AND (`xf_dbtech_ecommerce_product_rating`.`rating_date` > 1587866695)
    ORDER BY `xf_dbtech_ecommerce_product_rating`.`rating_date` DESC
    
    LIMIT 10
    Run Time: 0.001166
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_product_ratingrangeproduct_user_id,product_id_rating_date,rating_daterating_date4 3Using index condition; Using where
    SIMPLExf_dbtech_ecommerce_product_Product_1eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_rating.product_id1Using where
    SIMPLExf_permission_cache_content_Permissions_2eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_product_rating.product_id1Using where
    SIMPLExf_dbtech_ecommerce_category_Category_3eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_Product_1.product_category_id1 
    SIMPLExf_permission_cache_content_Permissions_4eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_category_Category_3.category_id1Using where
    SIMPLExf_user_User_5eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product_rating.user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/eCommerce/Widget/LatestReviews.php at line 38
    4. DBTech\eCommerce\Widget\LatestReviews->render() in internal_data/code_cache/widgets/_12_dbtech_ecommerce_overview_latest_reviews.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1620
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 249
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    17. XF\App->run() in src/XF.php at line 390
    18. XF::runApp() in index.php at line 20
  30. SELECT `xf_member_stat`.*
    FROM `xf_member_stat`
    
    WHERE (`xf_member_stat`.`member_stat_key` = 'dbtech_ecommerce_most_products')
    
    
    LIMIT 1
    Run Time: 0.000225
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_member_statconstmember_stat_keymember_stat_key52const1 

    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 1261
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 168
    4. XF\Mvc\Entity\Manager->findOne() in src/XF/Widget/AbstractWidget.php at line 184
    5. XF\Widget\AbstractWidget->findOne() in src/XF/Widget/MemberStat.php at line 37
    6. XF\Widget\MemberStat->render() in internal_data/code_cache/widgets/_13_dbtech_ecommerce_overview_top_authors.php at line 5
    7. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
    8. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    9. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1620
    10. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 249
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    12. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    13. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    14. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    15. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    16. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    17. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    19. XF\App->run() in src/XF.php at line 390
    20. XF::runApp() in index.php at line 20
  31. SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.*
    FROM `xf_user`
    INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
    INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`)
    WHERE (`xf_user`.`user_id` IN (1)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
    Run Time: 0.000519
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userconstPRIMARY,user_statePRIMARY4const1 
    SIMPLExf_user_option_Option_1constPRIMARYPRIMARY4const1 
    SIMPLExf_user_profile_Profile_2constPRIMARYPRIMARY4const1 

    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/Widget/MemberStat.php at line 55
    4. XF\Widget\MemberStat->render() in internal_data/code_cache/widgets/_13_dbtech_ecommerce_overview_top_authors.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1620
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php at line 249
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    17. XF\App->run() in src/XF.php at line 390
    18. XF::runApp() in index.php at line 20
  32. SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
    FROM `xf_node`
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
    WHERE (`xf_node`.`node_id` IN (46, 7, 8, 13, 9, 14, 25, 15, 23, 26))
    Run Time: 0.000471
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_noderangePRIMARYPRIMARY4 10Using where
    SIMPLExf_permission_cache_content_Permissions_1eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_node.node_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/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 193
    5. XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
    6. XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 256
    7. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6628
    8. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
    9. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
    10. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
    11. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
    12. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    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
  33. SELECT `xf_page`.*, `xf_node_Node_1`.*
    FROM `xf_page`
    LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_page`.`node_id`)
    WHERE (`xf_page`.`node_id` IN (7, 8, 9, 13, 14, 25, 26, 46))
    Run Time: 0.000380
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_pageALLPRIMARY   31Using where
    SIMPLExf_node_Node_1eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_page.node_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 129
    5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 227
    6. XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
    7. XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 256
    8. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6628
    9. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
    10. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
    11. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
    12. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    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
  34. SELECT `xf_category`.*, `xf_node_Node_1`.*
    FROM `xf_category`
    LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
    WHERE (`xf_category`.`node_id` IN (15))
    Run Time: 0.000226
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_categoryconstPRIMARYPRIMARY4const1Using index
    SIMPLExf_node_Node_1constPRIMARYPRIMARY4const1 

    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/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 129
    5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 227
    6. XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
    7. XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 256
    8. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6628
    9. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
    10. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
    11. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
    12. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    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
  35. SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
    FROM `xf_forum`
    LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
    LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
    LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
    WHERE (`xf_forum`.`node_id` IN (23))
    Run Time: 0.000703
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_forumconstPRIMARYPRIMARY4const1 
    SIMPLExf_node_Node_1constPRIMARYPRIMARY4const1 
    SIMPLExf_user_LastPostUser_2constPRIMARYPRIMARY4const1 
    SIMPLExf_thread_LastThread_3constPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 129
    5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 227
    6. XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
    7. XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 256
    8. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6628
    9. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
    10. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
    11. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
    12. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    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
  36. SELECT `xf_dbtech_ecommerce_product`.*, `xf_dbtech_ecommerce_category_Category_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*
    FROM `xf_dbtech_ecommerce_product`
    LEFT JOIN `xf_dbtech_ecommerce_category` AS `xf_dbtech_ecommerce_category_Category_1` ON (`xf_dbtech_ecommerce_category_Category_1`.`category_id` = `xf_dbtech_ecommerce_product`.`product_category_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'dbtech_ecommerce_category' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_dbtech_ecommerce_category_Category_1`.`category_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
    LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_dbtech_ecommerce_product`.`user_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'dbtech_ecommerce_product' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_dbtech_ecommerce_product`.`product_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
    WHERE (`xf_dbtech_ecommerce_product`.`product_state` = 'visible') AND (`xf_dbtech_ecommerce_product`.`parent_product_id` = 0)
    ORDER BY `xf_dbtech_ecommerce_product`.`last_update` DESC
    
    LIMIT 10
    Run Time: 0.001681
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_ecommerce_productindex last_update4 10Using where
    SIMPLExf_dbtech_ecommerce_category_Category_1eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product.product_category_id1 
    SIMPLExf_permission_cache_content_Permissions_2eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_category_Category_1.category_id1Using where
    SIMPLExf_user_User_3eq_refPRIMARYPRIMARY4nulumia_nlxen.xf_dbtech_ecommerce_product.user_id1 
    SIMPLExf_permission_cache_content_Permissions_4eq_refPRIMARYPRIMARY35const,const,nulumia_nlxen.xf_dbtech_ecommerce_product.product_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/DBTech/eCommerce/Widget/NewProducts.php at line 99
    4. DBTech\eCommerce\Widget\NewProducts->render() in src/addons/Nulumia/EcommerceTweaks/DBTech/eCommerce/Widget/NewProducts.php at line 16
    5. Nulumia\EcommerceTweaks\DBTech\eCommerce\Widget\NewProducts->render() in internal_data/code_cache/widgets/_28_latest_products_footer_widget.php at line 5
    6. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
    7. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    8. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1620
    9. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s3/public/nl_flexcolumns.php at line 144
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
    12. XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s3/public/nl_helper_macros.php at line 207
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s3/public/PAGE_CONTAINER.php at line 1598
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
    16. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 547
    17. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
    18. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
    19. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
    21. XF\App->run() in src/XF.php at line 390
    22. XF::runApp() in index.php at line 20

Included Files (250, XenForo Classes: 113)

  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/paragonie/sodium_compat/lib/php72compat.php
  23. src/vendor/symfony/polyfill-ctype/bootstrap.php
  24. src/vendor/symfony/polyfill-php56/bootstrap.php
  25. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
  26. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
  27. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  28. src/vendor/dokuwiki/utf8/utf8.php
  29. src/XF/Http/Request.php
  30. src/XF/InputFilterer.php
  31. src/XF/Pub/App.php
  32. src/XF/App.php
  33. src/XF/Container.php
  34. src/config.php
  35. src/XF/DataRegistry.php
  36. src/XF/Db/Mysqli/Adapter.php
  37. src/XF/Db/AbstractAdapter.php
  38. src/XF/CacheFactory.php
  39. src/XF/Cache/RedisCache.php
  40. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/RedisCache.php
  41. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  42. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  43. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  44. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  45. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  46. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
  47. src/XF/Extension.php
  48. src/XF/AddOn/Manager.php
  49. src/XF/ComposerAutoload.php
  50. src/addons/DBTech/eCommerce/vendor/composer/autoload_namespaces.php
  51. src/addons/DBTech/eCommerce/vendor/composer/autoload_psr4.php
  52. src/addons/DBTech/eCommerce/vendor/composer/autoload_classmap.php
  53. src/addons/DBTech/eCommerce/Listener.php
  54. src/addons/XFMG/Listener.php
  55. src/addons/ThemeHouse/ImageOptimizer/Listener/App.php
  56. src/addons/ThemeHouse/Core/AutoLoad.php
  57. src/addons/ThemeHouse/Core/AutoLoad/20170817.php
  58. src/addons/ThemeHouse/ImageOptimizer/vendor/composer/autoload_namespaces.php
  59. src/addons/ThemeHouse/ImageOptimizer/vendor/composer/autoload_psr4.php
  60. src/addons/ThemeHouse/ImageOptimizer/vendor/composer/autoload_classmap.php
  61. src/XF/Session/Session.php
  62. src/XF/Session/DbStorage.php
  63. src/XF/Session/StorageInterface.php
  64. src/XF/Util/Ip.php
  65. src/XF/Util/Random.php
  66. src/XF/Http/Response.php
  67. src/XF/Mvc/Entity/Manager.php
  68. src/XF/Mvc/Entity/ValueFormatter.php
  69. src/XF/Repository/User.php
  70. src/XF/Mvc/Entity/Repository.php
  71. src/XF/Entity/User.php
  72. src/XF/Mvc/Entity/Entity.php
  73. src/addons/DBTech/eCommerce/XF/Entity/User.php
  74. src/addons/XFMG/XF/Entity/User.php
  75. src/addons/ThemeHouse/ImageOptimizer/XF/Entity/User.php
  76. src/addons/ThemeHouse/ImageOptimizer/Traits/ImageOptimizerStatusTrait.php
  77. src/XF/Mvc/Entity/Structure.php
  78. src/XF/Entity/UserAuth.php
  79. src/XF/Entity/UserOption.php
  80. src/addons/DBTech/eCommerce/XF/Entity/UserOption.php
  81. src/XF/Entity/UserProfile.php
  82. src/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/DBTech/eCommerce/Pub/Controller/Product.php
  91. src/XF/Pub/Controller/AbstractController.php
  92. src/XF/Mvc/Controller.php
  93. src/addons/SV/MultiPrefix/DBTech/eCommerce/Pub/Controller/Product.php
  94. src/XF/Util/Php.php
  95. src/XF/PermissionCache.php
  96. src/XF/PermissionSet.php
  97. src/XF/Db/Mysqli/Statement.php
  98. src/XF/Db/AbstractStatement.php
  99. src/addons/DBTech/eCommerce/ControllerPlugin/Overview.php
  100. src/XF/ControllerPlugin/AbstractPlugin.php
  101. src/addons/SV/MultiPrefix/DBTech/eCommerce/ControllerPlugin/Overview.php
  102. src/addons/DBTech/eCommerce/Repository/Category.php
  103. src/XF/Repository/AbstractCategoryTree.php
  104. src/addons/DBTech/eCommerce/Entity/Category.php
  105. src/XF/Entity/AbstractCategoryTree.php
  106. src/addons/SV/MultiPrefix/DBTech/eCommerce/Entity/Category.php
  107. src/addons/Nulumia/SeoDebug/Listener.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/DBTech/eCommerce/Repository/Product.php
  118. src/addons/DBTech/eCommerce/Entity/Product.php
  119. src/XF/Entity/ReactionTrait.php
  120. src/XF/Entity/BookmarkTrait.php
  121. src/XF/BbCode/RenderableContentInterface.php
  122. src/addons/SV/MultiPrefix/DBTech/eCommerce/Entity/Product.php
  123. src/addons/SV/MultiPrefix/Behavior/MultiPrefixable.php
  124. src/XF/Mvc/Entity/Behavior.php
  125. src/addons/DBTech/eCommerce/Finder/Product.php
  126. src/addons/SV/MultiPrefix/DBTech/eCommerce/Finder/Product.php
  127. src/addons/SV/Utils/Finder/SqlJoinTrait.php
  128. src/addons/DBTech/eCommerce/Entity/ProductSale.php
  129. src/addons/DBTech/eCommerce/Entity/Download.php
  130. src/XF/Mvc/Reply/View.php
  131. src/XF/Mvc/Reply/AbstractReply.php
  132. src/XF/Repository/SessionActivity.php
  133. src/XF/Data/Robot.php
  134. src/XF/Style.php
  135. src/XF/Template/Templater.php
  136. src/addons/SV/MultiPrefix/XF/Template/Templater.php
  137. src/XF/DevelopmentOutput.php
  138. src/XF/DevelopmentOutput/Template.php
  139. src/XF/DevelopmentOutput/AbstractHandler.php
  140. src/XF/Template/WatcherInterface.php
  141. src/XF/SubContainer/BbCode.php
  142. src/XF/SubContainer/AbstractSubContainer.php
  143. src/XF/SubContainer/Widget.php
  144. src/addons/XFMG/Template/TemplaterSetup.php
  145. src/XF/SimpleCache.php
  146. src/XF/Mvc/Renderer/Html.php
  147. src/XF/Mvc/Renderer/AbstractRenderer.php
  148. src/XF/Mvc/View.php
  149. src/XF/Template/Template.php
  150. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview.php
  151. src/XF/PreEscaped.php
  152. internal_data/code_cache/templates/l1/s3/public/metadata_macros.php
  153. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_overview_macros.php
  154. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_list_macros.php
  155. src/XF/Phrase.php
  156. internal_data/code_cache/phrase_groups/l1/dbtech_ecommerce_product_tag.php
  157. internal_data/code_cache/templates/l1/s3/public/rating_macros.php
  158. src/addons/DBTech/eCommerce/Entity/ProductCost.php
  159. src/XF/Data/Currency.php
  160. internal_data/code_cache/templates/l1/s3/public/page_nav.php
  161. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_category_list_macros.php
  162. internal_data/code_cache/widgets/_52_sidebar_quicklinks.php
  163. src/XF/Widget/WidgetConfig.php
  164. src/XF/Widget/Html.php
  165. src/XF/Widget/AbstractWidget.php
  166. internal_data/code_cache/phrase_groups/l1/widget.php
  167. internal_data/code_cache/templates/l1/s3/public/_widget_sidebar_quicklinks.php
  168. src/XF/Widget/WidgetRenderer.php
  169. internal_data/code_cache/templates/l1/s3/public/widget_html.php
  170. internal_data/code_cache/widgets/_11_dbtech_ecommerce_list_top_products.php
  171. src/addons/DBTech/eCommerce/Widget/TopProducts.php
  172. internal_data/code_cache/phrase_groups/l1/widget_def.php
  173. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_widget_top_products.php
  174. src/addons/DBTech/eCommerce/Finder/Download.php
  175. internal_data/code_cache/widgets/_12_dbtech_ecommerce_overview_latest_reviews.php
  176. src/addons/DBTech/eCommerce/Widget/LatestReviews.php
  177. src/addons/DBTech/eCommerce/Repository/ProductRating.php
  178. src/addons/DBTech/eCommerce/Entity/ProductRating.php
  179. src/addons/DBTech/eCommerce/Finder/ProductRating.php
  180. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_widget_latest_reviews.php
  181. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_product_review_macros.php
  182. src/XF/Util/Color.php
  183. internal_data/code_cache/widgets/_13_dbtech_ecommerce_overview_top_authors.php
  184. src/XF/Widget/MemberStat.php
  185. src/XF/Entity/MemberStat.php
  186. src/XF/Finder/MemberStat.php
  187. src/XF/Service/MemberStat/Preparer.php
  188. src/XF/Service/AbstractService.php
  189. src/XF/Searcher/User.php
  190. src/XF/Searcher/AbstractSearcher.php
  191. src/addons/DBTech/eCommerce/XF/Searcher/User.php
  192. src/XF/Finder/User.php
  193. internal_data/code_cache/templates/l1/s3/public/widget_member_stat.php
  194. internal_data/code_cache/templates/l1/s3/public/member_notable.php
  195. internal_data/code_cache/phrase_groups/l1/member_stat.php
  196. internal_data/code_cache/navigation_cache.php
  197. src/XF/Navigation/NodeType.php
  198. src/XF/Navigation/AbstractType.php
  199. src/XF/Pub/Route/Search.php
  200. src/XF/Entity/Node.php
  201. src/XF/Finder/Node.php
  202. src/XF/Repository/Node.php
  203. src/XF/Entity/Page.php
  204. src/XF/Entity/AbstractNode.php
  205. src/XF/Entity/Category.php
  206. src/XF/Entity/Forum.php
  207. src/addons/SV/MultiPrefix/XF/Entity/Forum.php
  208. src/XF/Entity/Thread.php
  209. src/addons/EWR/Porta/Entity/Thread.php
  210. src/addons/SV/MultiPrefix/XF/Entity/Thread.php
  211. src/XF/Pub/Route/Category.php
  212. src/XF/Mvc/RouteBuiltLink.php
  213. src/XF/NoticeList.php
  214. internal_data/code_cache/templates/l1/s3/public/notice_cookies.php
  215. src/XF/Criteria/User.php
  216. src/XF/Criteria/AbstractCriteria.php
  217. src/XF/Criteria/Page.php
  218. internal_data/code_cache/templates/l1/s3/public/PAGE_CONTAINER.php
  219. internal_data/code_cache/templates/l1/s3/public/nl_body_classes.php
  220. internal_data/code_cache/templates/l1/s3/public/bodytag_macros.php
  221. src/XF/CssRenderer.php
  222. src/addons/SV/RedisCache/XF/CssRenderer.php
  223. internal_data/code_cache/templates/l1/s3/public/helper_js_global.php
  224. internal_data/code_cache/templates/l1/s3/public/font_awesome_setup.php
  225. internal_data/code_cache/templates/l1/s3/public/google_analytics.php
  226. internal_data/code_cache/templates/l1/s3/public/nl_topbar.php
  227. internal_data/code_cache/templates/l1/s3/public/nl_social_macros.php
  228. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_navbar_checkout.php
  229. internal_data/code_cache/phrase_groups/l1/button.php
  230. internal_data/code_cache/templates/l1/s3/public/_ads.php
  231. internal_data/code_cache/phrase_groups/l1/nav.php
  232. internal_data/code_cache/templates/l1/s3/public/nl_theme_hooks.php
  233. internal_data/code_cache/templates/l1/s3/public/nl_helper_macros.php
  234. internal_data/code_cache/templates/l1/s3/public/nl_slider_insert_macros.php
  235. internal_data/code_cache/widgets/_16_flex_feature_grid.php
  236. internal_data/code_cache/templates/l1/s3/public/_widget_flex_feature_grid.php
  237. internal_data/code_cache/templates/l1/s3/public/nl_flexslider_macros.php
  238. internal_data/code_cache/templates/l1/s3/public/notice_macros.php
  239. internal_data/code_cache/templates/l1/s3/public/browser_warning_macros.php
  240. internal_data/code_cache/templates/l1/s3/public/nl_flexcolumns.php
  241. internal_data/code_cache/widgets/_28_latest_products_footer_widget.php
  242. src/addons/DBTech/eCommerce/Widget/NewProducts.php
  243. src/addons/Nulumia/EcommerceTweaks/DBTech/eCommerce/Widget/NewProducts.php
  244. internal_data/code_cache/templates/l1/s3/public/dbtech_ecommerce_widget_new_products.php
  245. src/addons/DBTech/eCommerce/Template/Callback/Copyright.php
  246. internal_data/code_cache/templates/l1/s3/public/nl_footer_copyright.php
  247. internal_data/code_cache/templates/l1/s3/public/debug_macros.php
  248. internal_data/code_cache/templates/l1/s3/public/nl_functions_js.php
  249. internal_data/code_cache/phrase_groups/l1/reaction_title.php
  250. src/XF/Debugger.php

DB Connection Stats

bytes_sent56019
bytes_received941927
packets_sent430
packets_received5577
protocol_overhead_in22308
protocol_overhead_out1720
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet972
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet383
bytes_received_prepare_response_packet576778
bytes_received_change_user_packet362219
packets_sent_command214
packets_received_ok0
packets_received_eof0
packets_received_rset_header108
packets_received_rset_field_meta0
packets_received_rset_row73
packets_received_prepare_response5045
packets_received_change_user278
result_set_queries70
non_result_set_queries3
no_index_used26
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets70
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed70
rows_fetched_from_server_normal0
rows_fetched_from_server_ps208
rows_buffered_from_client_normal0
rows_buffered_from_client_ps208
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_ps208
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_bit459
proto_binary_fetched_tinyint0
proto_binary_fetched_short942
proto_binary_fetched_int24346
proto_binary_fetched_int0
proto_binary_fetched_bigint4077
proto_binary_fetched_decimal208
proto_binary_fetched_float85
proto_binary_fetched_double128
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_json2203
proto_binary_fetched_blob1385
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_prepare71
com_stmt_execute71
com_stmt_send_long_data0
com_stmt_close70
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps355306