1 300 $
Аренда кафе, м. Моршин.
250 м² 57200.0
Моршин
Знайдено 1 305 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3186
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 150,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.19 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 ["morshin","\/morshin","morshin\/","\/morshin\/"] · 1.25 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 4.06 msSHOW TABLES · 0.5 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) [216808083,216784708,216781246,216709864,216706153,216688273,216660706,216628495,216620137,216607987,216600304,216576898,216546310,216544435,216536800,216514591,216468910,216456229,216455680,216335071,216333880,216314422,216307159,216285478,216284017,216283978,216279184,216241075,216234595,216227212,216225547,216169813,216160000,216137383,216132481,216122053,216114814,216098860,216078343,216071386,216020464,216020014,216002902,215998132,215977843,215973118,215916205,215910919,215875822,215851618] · 93.46 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 [215851618,215875822,215910919,215916205,215973118,215977843,215998132,216002902,216020014,216020464,216071386,216078343,216098860,216114814,216122053,216132481,216137383,216160000,216169813,216225547,216227212,216234595,216241075,216279184,216283978,216284017,216285478,216307159,216314422,216333880,216335071,216455680,216456229,216468910,216514591,216536800,216544435,216546310,216576898,216600304,216607987,216620137,216628495,216660706,216688273,216706153,216709864,216781246,216784708,216808083] · 45.83 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] · 2.94 ms