5 000 ₴
Продам капот Форд Фьюжн USA/Mondeo 5
5000.0
Тернівка
Знайдено 3 166 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3148
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3000,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.31 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 ["ternovka","\/ternovka","ternovka\/","\/ternovka\/"] · 1.05 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.41 msSHOW TABLES · 0.85 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) [175542362,175457651,175446105,175425241,175385733,175326409,175288699,175227499,175212613,175151419,174991294,174990205,174816112,174806152,174792568,174792037,174748432,174739312,174671311,174638251,174625360,174622804,174604804,174533620,174487807,174355144,174277417,174149716,174084901,173903200,173892667,173892289,173761861,173760211,173737969,173713873,173696869,173670679,173542666,173497441,173460496,173460466,173358175,173345296,173286541,173216827,173205676,173188414,173174851,173109145] · 37.96 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 [173109145,173174851,173188414,173205676,173216827,173286541,173345296,173358175,173460466,173460496,173497441,173542666,173670679,173696869,173713873,173737969,173760211,173761861,173892289,173892667,173903200,174084901,174149716,174277417,174355144,174487807,174533620,174604804,174622804,174625360,174638251,174671311,174739312,174748432,174792037,174792568,174806152,174816112,174990205,174991294,175151419,175212613,175227499,175288699,175326409,175385733,175425241,175446105,175457651,175542362] · 1.56 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 ms