array(3) {
["attribute"]=>
string(207) "SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [onegar_attribute] WHERE ( attr_id =10 )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1)"
["_think_"]=>
string(91) "SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='onegar_attribute_value'"
["Attribute_value"]=>
string(184) "SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [onegar_attribute_value] WHERE ( 1=1 AND attr_id='5' )) AS thinkphp) AS T1 "
}
我想查表attribute的attr_id=10的数据和关联attribute_value表的数据
protected $_li
'attr_value' => array(
'mapping_type' => self::HAS_MANY,
'class_name' => 'Attribute_value',
'foreign_key' => 'attr_id',
'mapping_name' => 'attr_value_list',
),
);
这是我的关联模型设置
最佳答案