array(3) {
["attribute"]=>
string(206) "SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [one_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'"
["AttributeValue"]=>
string(184) "SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [one_attribute_value] WHERE ( 1=1 AND attr_id='5' )) AS thinkphp) AS T1 "
}
我要查关联查询的字段id是10,为什么关联的字段会变成5,我试了改变查询主表id,而关联的字段自动除以2,有大神知道原因吗?
最佳答案