500 $
Мотор Ford Fusion 2009 г мотор 1.4L Duratec 16V EFI DOHC (75/80PS)
22000.0
Прилуки
Знайдено 15 772 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2222
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 5450,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.35 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 ["priluki","\/priluki","priluki\/","\/priluki\/"] · 0.48 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.6 msSHOW TABLES · 0.89 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) [207634039,207633529,207632089,207622783,207617224,207617053,207609307,207608722,207604708,207604705,207603352,207589342,207589117,207583357,207582490,207582343,207582313,207569029,207568948,207566272,207561484,207560359,207558937,207551614,207550627,207544348,207543148,207536683,207536455,207536119,207533797,207532072,207528658,207527623,207527368,207526906,207525469,207525337,207525295,207525250,207524686,207523786,207523747,207520717,207518764,207515689,207514870,207513439,207512653,207508603] · 33.9 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 [207508603,207512653,207513439,207514870,207515689,207518764,207520717,207523747,207523786,207524686,207525250,207525295,207525337,207525469,207526906,207527368,207527623,207528658,207532072,207533797,207536119,207536455,207536683,207543148,207544348,207550627,207551614,207558937,207560359,207561484,207566272,207568948,207569029,207582313,207582343,207582490,207583357,207589117,207589342,207603352,207604705,207604708,207608722,207609307,207617053,207617224,207622783,207632089,207633529,207634039] · 9.88 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.92 ms