5 000 ₴
Голова компресора со7 б.
5000.0
Горохів
Знайдено 2 516 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3605
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.45 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 ["gorohov","\/gorohov","gorohov\/","\/gorohov\/"] · 1 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.5 msSHOW TABLES · 2.19 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) [203167975,203167609,203155936,203134480,203133031,203101696,203100373,203099335,203094088,203061538,203051872,203031832,203026786,203022613,202986781,202947169,202918402,202917718,202916263,202884931,202869127,202845955,202844308,202826434,202817783,202797658,202776913,202772425,202758475,202732564,202729462,202724011,202701118,202681169,202658993,202635855,202625325,202599507,202595881,202593673,202581517,202575913,202566775,202553001,202515985,202496402,202489517,202486729,202445408,202429741] · 34.8 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 [202429741,202445408,202486729,202489517,202496402,202515985,202553001,202566775,202575913,202581517,202593673,202595881,202599507,202625325,202635855,202658993,202681169,202701118,202724011,202729462,202732564,202758475,202772425,202776913,202797658,202817783,202826434,202844308,202845955,202869127,202884931,202916263,202917718,202918402,202947169,202986781,203022613,203026786,203031832,203051872,203061538,203094088,203099335,203100373,203101696,203133031,203134480,203155936,203167609,203167975] · 24.03 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.72 ms