2 000 $
Dodge Ram Van
88000.0
Сарата
Знайдено 792 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3172
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 650,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.79 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 ["sarata","\/sarata","sarata\/","\/sarata\/"] · 1.28 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.59 msSHOW TABLES · 11.14 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) [179717479,179473333,179387563,179387362,179387191,179372095,179178700,179081461,178906303,178734652,178730098,178665532,178629898,178430597,178412997,178274070,178256409,178157502,178072407,178016550,177995028,177954747,177639349,177630760,177591877,177542596,177253709,177253087,177239697,177217557,176988469,176978145,176666896,176652556,176506180,176452579,176377635,176297265,176297088,175818447,175814130,175759074,175713624,175571510,175553404,175419523,175288349,175150615,175095529,174911590] · 56.38 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 [174911590,175095529,175150615,175288349,175419523,175553404,175571510,175713624,175759074,175814130,175818447,176297088,176297265,176377635,176452579,176506180,176652556,176666896,176978145,176988469,177217557,177239697,177253087,177253709,177542596,177591877,177630760,177639349,177954747,177995028,178016550,178072407,178157502,178256409,178274070,178412997,178430597,178629898,178665532,178730098,178734652,178906303,179081461,179178700,179372095,179387191,179387362,179387563,179473333,179717479] · 1.71 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.39 ms