46 000 $
продажа Рыбник
2024000.0
Рибалка
Знайдено 93 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 9737
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.25 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 ["rybnik","\/rybnik","rybnik\/","\/rybnik\/"] · 4.77 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.29 msSHOW TABLES · 1.05 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) [205681892,205618511,205526537,204141657,204102381,203993676,203288621,203275193,203275181,203275127,203275115,202356623,202338285,202157569,200543239,199412920,197384525,196291361,196289699,196093802,195832520,195648233,195648167,195648146,194438609,192674461,192674428,192674389,192337348,192092728,191801788,185361825,184897677,183254928,180789169,180788806,180735664,180455656,179931448,178005222,177953085,177347836,175527625] · 51.92 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 [175527625,177347836,177953085,178005222,179931448,180455656,180735664,180788806,180789169,183254928,184897677,185361825,191801788,192092728,192337348,192674389,192674428,192674461,194438609,195648146,195648167,195648233,195832520,196093802,196289699,196291361,197384525,199412920,200543239,202157569,202338285,202356623,203275115,203275127,203275181,203275193,203288621,203993676,204102381,204141657,205526537,205618511,205681892] · 1.97 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.74 ms