1 000 ₴
Моторчик люка BMW series 1, 3, 4
1000.0
Ромни
Знайдено 10 450 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2994
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1200,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 4.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.url IN (?, ?, ?, ?) LIMIT 1 ["romny","\/romny","romny\/","\/romny\/"] · 1.09 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.87 msSHOW TABLES · 0.72 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) [216512881,216511759,216508237,216499159,216496345,216491185,216490036,216488572,216476809,216471187,216471112,216469093,216468166,216464392,216462586,216462337,216450604,216460606,216458557,216452242,216451669,216451555,216448543,216441007,216440008,216439303,216439171,216437422,216437344,216435784,216431731,216431725,216426133,216422791,216415183,216410785,216410716,216407356,216406612,216404977,216399265,216392554,216390205,216389833,216388525,216387790,216381166,216380023,216379417,216370363] · 47.37 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 [216370363,216379417,216380023,216381166,216387790,216388525,216389833,216390205,216392554,216399265,216404977,216406612,216407356,216410716,216410785,216415183,216422791,216426133,216431725,216431731,216435784,216437344,216437422,216439171,216439303,216440008,216441007,216448543,216451555,216451669,216452242,216458557,216460606,216462337,216462586,216464392,216468166,216469093,216471112,216471187,216476809,216488572,216490036,216491185,216496345,216499159,216508237,216511759,216512881] · 16.63 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] · 4.53 ms