1 000 ₴
Стол письмовий в гарному стані
1000.0
Малин
Найдено 4 333 объявления
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3067
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 200,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.78 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["malin","\/malin","malin\/","\/malin\/"] · 0.42 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.33 msSHOW TABLES · 0.84 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, ''), NULLIF(c.name_ua, '')) 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) [218308112,218301458,218300630,218296655,218296291,218295977,218295297,218258830,218258371,218257771,218257435,218257036,218256709,218237056,218243077,218239228,218226826,218223109,218182840,218181526,218181235,218178814,218143255,218127820,218119840,218117428,218117305,218094280,218087488,218082313,218074105,218074093,218064325,218061445,218052589,218050024,218043403,218037298,218027815,218024518,218018725,218018278,218014153,218005627,217991878,217976469,217976339,217976119,217976031,217964920] · 20.53 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [217964920,217976031,217976119,217976339,217976469,217991878,218005627,218014153,218018278,218018725,218024518,218027815,218037298,218043403,218050024,218052589,218061445,218064325,218074093,218074105,218082313,218087488,218094280,218117305,218117428,218119840,218127820,218143255,218178814,218181235,218181526,218182840,218223109,218226826,218239228,218243077,218256709,218257036,218257435,218257771,218258371,218258830,218295297,218295977,218296291,218296655,218300630,218301458,218308112] · 42.52 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 1.33 ms