3 200 ₴
Генератор Toyota Corolla E15 1,33 2012 рік
3200.0
Білецьківка
Знайдено 99 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7746
}
}
]
}
},
"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 · 1.82 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 ["beleckovka","\/beleckovka","beleckovka\/","\/beleckovka\/"] · 0.98 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.35 msSHOW TABLES · 1.57 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) [205008632,204473114,204173748,203990820,203622362,203562059,203064454,202538673,202240450,202003777,201684901,200809612,200657668,200452861,199859875,197951758,197947147,197770643,197703953,197459378,197436371,196852153,194702123,193614485,192400507,191785435,190850544,187790265,187788075,187761366,187600542,187422882,186156120,186022326,185837373,185829831,185036820,184754611,183658716,181777831,181440112,181006189,178633411,178497484,177082255,176288094,176045814,168892783,166996666] · 42.56 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 [166996666,168892783,176045814,176288094,177082255,178497484,178633411,181006189,181440112,181777831,183658716,184754611,185036820,185829831,185837373,186022326,186156120,187422882,187600542,187761366,187788075,187790265,190850544,191785435,192400507,193614485,194702123,196852153,197436371,197459378,197703953,197770643,197947147,197951758,199859875,200452861,200657668,200809612,201684901,202003777,202240450,202538673,203562059,203622362,203990820,204173748,204473114,205008632] · 1.42 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.12 ms