31 500 $
Продам ухоженную 1-но комн. квартиру на 7-м Небе.
30 м² 1386000.0
Авангард
Знайдено 7 357 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6208
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2700,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.45 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["avangard","\/avangard","avangard\/","\/avangard\/"] · 0.78 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.85 msSHOW TABLES · 1.2 msSELECT p.id, p.category_id, p.city_id, p.region AS region_id, p.vendor AS vendor_id, p.name, p.description, p.name AS name_orig, p.price, p.currency, p.bargain, p.conditions, p.url, p.img, p.view AS views, p.data_post, p.data_edit, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS city_name, c.url AS city_slug FROM `post` p LEFT JOIN `city` c ON c.id = p.city_id WHERE p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (1=1) [207983398,207976387,207972532,207966790,207966604,207966511,207964303,207962770,207932902,207918955,207915832,207913483,207911209,207909790,207905818,207895498,207892402,207891673,207881938,207879922,207869314,207865249,207861118,207861007,207859975,207847990,207845857,207843775,207843205,207840415,207840352,207840244,207838516,207836701,207801283,207790579,207788533,207783907,207781237,207780613,207762187,207760543,207758770,207757996,207738307,207733927,207732436,207710671,207706708,207675139] · 43.89 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute_value` v JOIN `attribute` a ON a.id = v.attribute_id WHERE v.post_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND v.value IS NOT NULL AND v.value <> '' ORDER BY a.id [207675139,207706708,207710671,207732436,207733927,207738307,207757996,207758770,207760543,207762187,207780613,207781237,207783907,207788533,207790579,207801283,207836701,207838516,207840244,207840352,207840415,207843205,207843775,207845857,207847990,207859975,207861007,207861118,207865249,207869314,207879922,207881938,207891673,207892402,207895498,207905818,207909790,207911209,207913483,207915832,207918955,207932902,207962770,207964303,207966511,207966604,207966790,207972532,207976387,207983398] · 46.59 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 0.9 ms