7 200 $
Suzuki Grand Vitara
316800.0
Гадяч
Знайдено 4 073 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3218
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3900,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.61 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 ["gadyach","\/gadyach","gadyach\/","\/gadyach\/"] · 0.66 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.33 msSHOW TABLES · 0.65 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) [170407615,170386171,170372059,170368198,170361157,170325808,170278261,170268499,170266654,170265379,170259895,170199034,170140534,170060869,170014285,169983874,169957255,169939549,169939537,169939516,169935529,169925047,169912558,169889335,169887568,169886461,169857052,169828378,169795234,169793776,169788811,169787608,169780336,169778095,169777186,169767736,169753534,169717885,169713697,169712746,169704049,169703185,169697506,169687642,169685668,169677787,169642171,169633021,169627018,169625677] · 73.32 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 [169625677,169627018,169633021,169642171,169677787,169685668,169687642,169697506,169703185,169704049,169712746,169713697,169717885,169753534,169767736,169777186,169778095,169780336,169787608,169788811,169793776,169795234,169828378,169857052,169886461,169887568,169889335,169912558,169925047,169935529,169939516,169939537,169939549,169957255,169983874,170014285,170060869,170140534,170199034,170259895,170265379,170266654,170268499,170278261,170325808,170361157,170368198,170372059,170386171,170407615] · 3.28 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] · 3.42 ms