10 000 ₴
Сдам квартиру студию
10000.0
Дачне
Знайдено 955 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6332
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 600,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.39 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 ["dachnoe","\/dachnoe","dachnoe\/","\/dachnoe\/"] · 0.69 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.36 msSHOW TABLES · 3.72 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) [198391577,198381058,198381034,198381028,198381022,198350060,198269019,198141649,198082936,198059301,198032341,197955109,197946877,197946859,197919655,197898418,197886616,197865229,197847044,197829626,197715161,197714756,197649545,197565116,197419682,197389904,197388413,197388365,197286671,197189805,197157160,197041594,196987129,196955797,196914601,196890517,196873549,196872100,196843456,196842283,196806007,196699960,196605046,196585533,196576641,196571235,196560643,196538066,196525922,196507769] · 62.63 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 [196507769,196525922,196538066,196560643,196571235,196576641,196585533,196605046,196699960,196806007,196842283,196843456,196872100,196873549,196890517,196914601,196955797,196987129,197041594,197157160,197189805,197286671,197388365,197388413,197389904,197419682,197565116,197649545,197714756,197715161,197829626,197847044,197865229,197886616,197898418,197919655,197946859,197946877,197955109,198032341,198059301,198082936,198141649,198269019,198350060,198381022,198381028,198381034,198381058,198391577] · 1.2 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.59 ms