8 000 ₴
Мотор от ВАЗ 2107
8000.0
Сонячне
Знайдено 2 481 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6258
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2250,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.17 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 ["solnechnoe","\/solnechnoe","solnechnoe\/","\/solnechnoe\/"] · 1 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.41 msSHOW TABLES · 1.1 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) [180970288,180917113,180913486,180861859,180831850,180822496,180821038,180818854,180737356,180735247,180712585,180703288,180670435,180613615,180606973,180573064,180558547,180547375,180494974,180293374,180292459,180292072,180214150,180204121,180090175,180062818,179916133,179817793,179809907,179808813,179797267,179797069,179695729,179671299,179671037,179652843,179645301,179477995,179269864,179269783,179269246,179269057,179268331,179268262,179222731,179171425,179118961,178868257,178762192,178719109] · 27.61 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 [178719109,178762192,178868257,179118961,179171425,179222731,179268262,179268331,179269057,179269246,179269783,179269864,179477995,179645301,179652843,179671037,179671299,179695729,179797069,179797267,179808813,179809907,179817793,179916133,180062818,180090175,180204121,180214150,180292072,180292459,180293374,180494974,180547375,180558547,180573064,180606973,180613615,180670435,180703288,180712585,180735247,180737356,180818854,180821038,180822496,180831850,180861859,180913486,180917113,180970288] · 2.02 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] · 2.02 ms