20 500 $
Дом в самом центре Чугуева
60 м² 902000.0
Чугуїв
Знайдено 7 510 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3130
}
}
]
}
},
"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.33 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 ["chuguev","\/chuguev","chuguev\/","\/chuguev\/"] · 0.6 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.98 msSHOW TABLES · 1.32 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) [210519374,210499427,210513986,210512918,210504170,210503495,210483464,210475703,210455420,210454172,210452963,210434174,210431249,210429920,210425975,210425441,210425399,210425216,210424841,210424790,210424742,210424703,210420377,210416813,210400364,210399404,210398495,210378917,210376175,210374570,210363890,210363503,210359039,210354689,210336113,210334118,210325529,210321380,210315026,210311312,210308060,210303572,210294449,210293111,210289448,210285596,210285554,210276983,210275549,210264599] · 48.21 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 [210264599,210275549,210276983,210285554,210285596,210289448,210293111,210294449,210303572,210308060,210311312,210315026,210321380,210325529,210334118,210336113,210354689,210359039,210363503,210363890,210374570,210376175,210378917,210398495,210399404,210400364,210416813,210420377,210424703,210424742,210424790,210424841,210425216,210425399,210425441,210425975,210429920,210431249,210434174,210452963,210454172,210455420,210475703,210483464,210503495,210504170,210512918,210513986,210519374] · 22.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] · 1.19 ms