1 000 ₴
Радіатор охолодження BMW F10 2.0бензин.
1000.0
Плоске
Знайдено 332 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6788
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 150,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 8.21 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 ["ploskoe","\/ploskoe","ploskoe\/","\/ploskoe\/"] · 0.73 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.34 msSHOW TABLES · 1.06 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) [207413779,207390877,207384445,207295762,207244579,207121654,207010567,206976495,206949853,206811557,205876190,205855727,205733759,205652816,205421624,205406753,205360466,205226429,204988784,204309963,204306000,204170073,204024594,203949714,203796003,203795928,203676344,203470598,203272493,203154988,202932697,202912960,202682707,202658373,202629641,202604611,202531919,202466385,202432273,202299229,202272781,202267199,202244344,202106119,201866541,201791393,201738040,201678955,201670597,201654451] · 204.77 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 [201654451,201670597,201678955,201738040,201791393,201866541,202106119,202244344,202267199,202272781,202299229,202432273,202466385,202531919,202604611,202629641,202658373,202682707,202912960,202932697,203154988,203272493,203470598,203795928,203796003,203949714,204024594,204170073,204306000,204309963,204988784,205226429,205360466,205406753,205421624,205652816,205733759,205855727,205876190,206811557,206949853,206976495,207010567,207121654,207244579,207295762,207384445,207390877,207413779] · 19.56 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] · 6.21 ms