17 000 $
Ексклюзив. Продам світлу 2х кімнатну квартиру в місті Узин
748000.0
Вечеря
Знайдено 1 534 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3105
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 850,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.31 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 ["uzin","\/uzin","uzin\/","\/uzin\/"] · 1.2 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.69 msSHOW TABLES · 0.82 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) [202441253,202394752,202384193,202373359,202353133,202330480,202312648,202311826,202309921,202304927,202256902,202252942,202219474,202161049,202148866,202092937,202031077,201962985,201935611,201924681,201889183,201861991,201827081,201800339,201785011,201776573,201773008,201756139,201744307,201690626,201686777,201661553,201655289,201644583,201632995,201601501,201555815,201551499,201542413,201540585,201511873,201480403,201479739,201479483,201466031,201432649,201431737,201401386,201388919,201346629] · 26.9 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 [201346629,201388919,201401386,201431737,201432649,201466031,201479483,201479739,201480403,201511873,201540585,201542413,201551499,201555815,201601501,201632995,201644583,201655289,201661553,201686777,201690626,201744307,201756139,201773008,201776573,201785011,201800339,201827081,201861991,201889183,201924681,201935611,201962985,202031077,202092937,202148866,202161049,202219474,202252942,202256902,202304927,202309921,202311826,202312648,202330480,202353133,202373359,202384193,202394752,202441253] · 1.17 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.96 ms