来自模型的Magento SQL查询

inWHen当我运行这个SQL查询时，我得到的结果是：

SELECT `productId`, `title`, `description`, `imageUrlStr`, `mrp`, `price`, `productUrl`, `categories`, `productBrand`, `deliveryTime`, `inStock`, `codAvailable`, `emiAvailable`, `offers`, `discount`, `cashBack`, `size`, `color`, `sizeUnit`, `sizeVariants`, `colorVariants` FROM `homeliv`.`table_furniture` WHERE productId in ('SOFE94HW8TPTGPNX','BDDE9EKAZ2GZZJGN') LIMIT 100

然而，当我在Magento中运行这个时，我得到了两行，但结果是空的。

$products = Mage::getModel("similar/table")->getCollection()->addFieldToFilter('productId',array('in' => $ids));
 foreach ($products as $p){
        Mage::log("Id====>".$p->getProductId());
        Mage::log("ImageSrc=====>".$p->getImageUrlStr());
        Mage::log("Product Url====>".$p->getProductUrl());
        Mage::log("Product Url==========================================================>");
    }

这是我在日志文件中得到的：

Id====>
2016-03-29T11:08:35+00:00 DEBUG (7): ImageSrc=====>
2016-03-29T11:08:35+00:00 DEBUG (7): Product Url====>
2016-03-29T11:08:35+00:00 DEBUG (7):==========================================================>
2016-03-29T11:08:35+00:00 DEBUG (7): Id====>
2016-03-29T11:08:35+00:00 DEBUG (7): ImageSrc=====>
2016-03-29T11:08:35+00:00 DEBUG (7): Product Url====>
2016-03-29T11:08:35+00:00 DEBUG (7):==========================================================>

我的主id是字符串，id数组是问题中的字符串数组。从magento打印的查询是

SELECT `main_table`.* FROM `flipkart_furniture` AS `main_table` WHERE (productId IN('SOFE94HW8TPTGPNX', 'SOFE94HW5FE4EXQM', 'BDDE9EKAZ2GZZJGN', 'BDDEBB94DHWXAMFC')) which gives result in mysql. Don't know what is wrong here