options |
{
"alias": {
"newhouse_project": "a",
"newhouse_project_part": "b",
"newhouse_roomplan": "c"
},
"join": [
[
{
"newhouse_project_part": "b"
},
"LEFT",
"a.id=b.pid"
],
[
{
"newhouse_roomplan": "c"
},
"LEFT",
"a.id=c.pId"
]
],
"multi": {
"AND": {
"a.cityId": [
"341200"
],
"c.typeArea": [
[
[
"egt",
"300"
]
]
],
"0": [
[
"exp",
"FIND_IN_SET(3,b.buildFeature)"
]
],
"a.status": [
1
]
}
},
"where": {
"AND": {
"a.cityId": "341200",
"c.typeArea": [
[
"egt",
"300"
]
],
"0": [
"exp",
"FIND_IN_SET(3,b.buildFeature)"
],
"a.status": 1
}
},
"group": "a.id",
"field": [
"count(*)"
],
"table": "newhouse_project",
"data": [],
"strict": true,
"master": false,
"lock": false,
"fetch_pdo": false,
"fetch_sql": true,
"distinct": false,
"union": "",
"having": "",
"limit": "",
"order": "",
"force": "",
"comment": ""
} |
binds |
{
"id": 1,
"projectName": 2,
"logo": 2,
"thumb": 2,
"cityId": 1,
"terminal": 1,
"spelling": 2,
"areaId": 1,
"zoneId": 1,
"propertyType": 1,
"buildType": 2,
"saleState": 1,
"longitude": 1,
"latitude": 1,
"specialOffers": 2,
"offerDate": 2,
"projectAddr": 2,
"salePhone": 2,
"freePhone": 2,
"openInfo": 2,
"houseAttribute": 1,
"renovateState": 2,
"juniorSchool": 2,
"middleSchool": 2,
"isSynthesis": 1,
"createTime": 1,
"updateTime": 1,
"listOrder": 1,
"status": 1,
"posIds": 1,
"hits": 1,
"seoTitle": 2,
"seoKeywords": 2,
"seoDescription": 2,
"realtyConsultant": 2,
"wechat_bgimage": 2,
"is_zfh": 1,
"start_date": 2,
"end_date": 2,
"zfh_house_id": 1
} |