magento 的一些Sql查询
2024-08-28 20:22:05
1,模拟使用getName()获取产品名称的sql
SELECT `value` AS product_name FROM yo_catalog_product_entity_varchar WHERE entity_type_id = (SELECT entity_type_id FROM yo_eav_entity_type WHERE entity_type_code = 'catalog_product') AND attribute_id = (SELECT attribute_id FROM yo_eav_attribute WHERE attribute_code = 'name' AND entity_type_id = (SELECT entity_type_id FROM yo_eav_entity_type WHERE entity_type_code = 'catalog_product'))
2,Mage::getModel('catalog/product')->getCollection()的sql输出
SELECT `e` . * , `price_index`.`price` , `price_index`.`tax_class_id` , `price_index`.`final_price` , IF( price_index.tier_price IS NOT NULL , LEAST( price_index.min_price, price_index.tier_price ) , price_index.min_price ) AS `minimal_price` , `price_index`.`min_price` , `price_index`.`max_price` , `price_index`.`tier_price`
FROM `yo_catalog_product_entity` AS `e`
INNER JOIN `yo_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id
AND price_index.website_id = ''
AND price_index.customer_group_id = ''
LIMIT 0 , 30
SELECT `e` . * , `price_index`.`price` , `price_index`.`tax_class_id` , `price_index`.`final_price` , IF( price_index.tier_price IS NOT NULL , LEAST(price_index.min_price, price_index.tier_price ) , price_index.min_price ) AS `minimal_price` , `price_index`.`min_price` , `price_index`.`max_price` ,`price_index`.`tier_price`
FROM `yo_catalog_product_entity` AS `e`
INNER JOIN `yo_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id
AND price_index.website_id = '1'
AND price_index.customer_group_id = '4'
LIMIT 0 , 30
最新文章
- linux——常用命令与脚本
- c#自制视屏监控
- Linux VM acquisition
- JMeter教程01-下载和安装
- urllib2
- jQuery扩展工具方法
- HDU2177:取(2堆)石子游戏(威佐夫博弈)
- 第六篇、git常用的命令
- Qt绘图之QGraphicsScene QGraphicsView QGraphicsItem详解
- NSIS:判断程序是否运行并进行卸载
- impress.js初体验
- JavaScript基础学习(七)—BOM
- MyBatis_通过resultMap解决不一致的问题
- Qt中的ui指针和this指针
- 性能测试工具Locust的使用
- Spring Boot事务管理(下)
- html5中JavaScript删除全部节点
- oracle12建立非C##用户并且导入数据
- Chrome,你这坑人的默认非安全端口
- java stackoverflowerror与outofmemoryerror区别(转)