3 700 $
Audi A6
162800.0
Бучач
Знайдено 7 197 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3477
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 6300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.58 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 ["buchach","\/buchach","buchach\/","\/buchach\/"] · 0.52 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.38 msSHOW TABLES · 0.46 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) [176640036,176623307,176605383,176552083,176547202,176491696,176451067,176446994,176446049,176433797,176430332,176418761,176415644,176391926,176388526,176386126,176359611,176359308,176354544,176354202,176352030,176345370,176345193,176320653,176299632,176294811,176292606,176284011,176221503,176189676,176161479,176159715,176158914,176154396,176135799,176134749,176130726,176112915,176080614,176078076,176077374,176051577,176050341,176029872,175996683,175973784,175955772,175932207,175892856,175865778] · 49.3 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 [175865778,175892856,175932207,175955772,175973784,175996683,176029872,176050341,176051577,176077374,176078076,176080614,176112915,176130726,176134749,176135799,176154396,176158914,176159715,176161479,176189676,176221503,176284011,176292606,176294811,176299632,176320653,176345193,176345370,176352030,176354202,176354544,176359308,176359611,176386126,176388526,176391926,176415644,176418761,176430332,176433797,176446049,176446994,176451067,176491696,176547202,176552083,176605383,176623307,176640036] · 5.9 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.48 ms