250 $
Коробка передач Iveco Daily E4 2.3 hpt 5ступка 5s300 01b07 кпп
11000.0
Долина
Знайдено 10 622 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3453
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 8850,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.34 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 ["dolina","\/dolina","dolina\/","\/dolina\/"] · 0.79 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.36 msSHOW TABLES · 0.88 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) [181608958,181598794,181598395,181597831,181590913,181586725,181585864,181585591,181585510,181585225,181584697,181574569,181557841,181554010,181549507,181549189,181548925,181544710,181531615,181515541,181515262,181513927,181510885,181506655,181489855,181489834,181487392,181487188,181465759,181460065,181421725,181419127,181415035,181414576,181413607,181410070,181406704,181381390,181369471,181368106,181366876,181365202,181363519,181359436,181358917,181357000,181356451,181328068,181322410,181318333] · 69.08 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 [181318333,181322410,181328068,181356451,181357000,181358917,181359436,181363519,181365202,181366876,181368106,181369471,181381390,181406704,181410070,181413607,181414576,181415035,181419127,181421725,181460065,181465759,181487188,181487392,181489834,181489855,181506655,181510885,181513927,181515262,181515541,181531615,181544710,181548925,181549189,181549507,181554010,181557841,181574569,181584697,181585225,181585510,181585591,181585864,181586725,181590913,181597831,181598395,181598794,181608958] · 1.49 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.33 ms