3 500 ₴
Фаркоп пассат б6
3500.0
Краматорськ
Знайдено 19 879 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2139
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 8400,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.7 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 ["kramatorsk","\/kramatorsk","kramatorsk\/","\/kramatorsk\/"] · 0.92 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.88 msSHOW TABLES · 0.77 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) [204486995,204485405,204484403,204483764,204483230,204475379,204475109,204471146,204471035,204471032,204470036,204468956,204467042,204462977,204462932,204461579,204452960,204448727,204448478,204447866,204447662,204446600,204445775,204445670,204445631,204445391,204444467,204432161,204431726,204431198,204429848,204428756,204424544,204424538,204424277,204423674,204423614,204423353,204423041,204418295,204417755,204411371,204405638,204404966,204404810,204403577,204402572,204400460,204399224,204399206] · 42.5 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 [204399206,204399224,204400460,204402572,204403577,204404810,204404966,204405638,204411371,204417755,204418295,204423041,204423353,204423614,204423674,204424277,204424538,204424544,204428756,204429848,204431198,204431726,204432161,204444467,204445391,204445631,204445670,204445775,204446600,204447662,204447866,204448478,204448727,204452960,204461579,204462932,204462977,204467042,204468956,204470036,204471032,204471035,204471146,204475109,204475379,204483230,204483764,204484403,204485405,204486995] · 0.69 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] · 0.4 ms