magento - 关于在magento 1.7.0.2中最受欢迎的排序

产品浏览量最大的文件位于：

App/code/local/Mage/Catalog/Block/Product/Mostviewed.php

我添加了以下代码：

class Mage_Catalog_Block_Product_Mostviewed extends Mage_Catalog_Block_Product_Abstract
{
    public function __construct(){
        parent::__construct();
        $storeId = Mage::app()->getStore()->getId();
        $collection = Mage::getResourceModel('reports/product_collection')->addViewsCount();
        $collection->getSelect()->joinInner(array('e2' => 'catalog_product_flat_'.$storeId), 'e2.entity_id = e.entity_id');
        $collection->addAttributeToSelect('*');

        //$collection->printlogquery(true);
        //exit();
        $this->setProductCollection($collection);
    }

    protected function _prepareLayout()
    {
        parent::_prepareLayout();

        $toolbar = $this->getLayout()->createBlock('catalog/product_list_toolbar', microtime())
            ->setCollection($this->getProductCollection());

        $pager = $this->getLayout()->createBlock('page/html_pager', microtime());
        $toolbar->setChild('product_list_toolbar_pager', $pager);

        $this->setChild('toolbar', $toolbar);
        $this->getProductCollection()->load();

        return $this;
    }

    public function getPagerHtml()
    {
        return $this->getChildHtml('toolbar');
    }
}

未添加addViewsCount()打印sql：

SELECT `e`.*, `e2`.*
   FROM `catalog_product_entity` AS `e`
   INNER JOIN `catalog_product_flat_1` AS `e2`
      ON e2.entity_id = e.entity_id

添加addViewsCount()打印sql：

SELECT COUNT(report_table_views.event_id) AS `views`, `e`.*, `e2`.*
   FROM `report_event` AS `report_table_views`
   INNER JOIN `catalog_product_entity` AS `e`
      ON e.entity_id = report_table_views.object_id AND e.entity_type_id = 4
   INNER JOIN `catalog_product_flat_1` AS `e2`
      ON e2.entity_id = e.entity_id
   WHERE (report_table_views.event_type_id = 1)
   GROUP BY `e`.`entity_id`
   HAVING (COUNT(report_table_views.event_id) > 0)
   ORDER BY `views` DESC

通过不工作添加了addViewsCount()排序，在删除addViewsCount()中工作。

如何解决？

编辑：
现在问题已解决，我的mysql DB出问题了，代码没问题，谢谢@liyakat @Alex。

最佳答案

您可以通过Mage_Reports_Model_Resource_Product_Collection模型获取视图计数。

//将$to和$from设置为空字符串以禁用时间范围过滤

$storeId = Mage::app()->getStore()->getId();
    $products = Mage::getResourceModel('reports/product_collection')
    ->addAttributeToSelect('*')
    ->setStoreId($storeId)
    ->addStoreFilter($storeId)
    ->addViewsCount()
    ->joinField('inventory_in_stock', 'cataloginventory/stock_item',
                            'is_in_stock', 'product_id=entity_id', '{{table}}.is_in_stock=1');



    Mage::getSingleton('catalog/product_status')
        ->addVisibleFilterToCollection($products);
    Mage::getSingleton('catalog/product_visibility')
        ->addVisibleInCatalogFilterToCollection($products);
    $products->getSelect()->limit( 15 );
   return $products;

请让我知道我是否可以帮助您更多