20 000 $
продажа Хотяновка
880000.0
Хочановка
Знайдено 1 205 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6199
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 6.87 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 ["hotyanovka","\/hotyanovka","hotyanovka\/","\/hotyanovka\/"] · 0.55 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.22 msSHOW TABLES · 0.83 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) [219903462,219898406,219845694,219843894,219841002,219741230,219737450,219698990,219678550,219678530,219678506,219668742,219632058,219591898,219591714,219572467,219530950,219530710,219515782,219509578,219452371,219450799,219435277,219434023,219422854,219369061,219361300,219346426,219338401,219294499,219285190,219283849,219173054,219172631,219158285,219143375,219101498,219074852,219030845,218961743,218961707,218867870,218840681,218772110,218739926,218666252,218602334,218587346,218554946,218541536] · 13.08 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 [218541536,218554946,218587346,218602334,218666252,218739926,218772110,218840681,218867870,218961707,218961743,219030845,219074852,219101498,219143375,219158285,219172631,219173054,219283849,219285190,219294499,219338401,219346426,219361300,219369061,219422854,219434023,219435277,219450799,219452371,219509578,219515782,219530710,219530950,219572467,219591714,219591898,219632058,219668742,219678506,219678530,219678550,219698990,219737450,219741230,219841002,219843894,219845694,219898406,219903462] · 38.06 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.53 ms