820 ₴
Доска пола 100м сосна. Пиломатериал в ассортименте.
820.0
Нікополь
Знайдено 9 932 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2131
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 4350,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.91 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 ["nikopol","\/nikopol","nikopol\/","\/nikopol\/"] · 0.99 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.59 msSHOW TABLES · 1.33 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) [206875783,206864199,206855116,206854786,206853228,206852996,206851923,206850736,206850560,206849066,206846390,206846033,206845468,206844083,206843269,206842414,206841735,206834093,206828057,206822849,206821517,206815547,206807069,206791464,206791354,206791338,206791302,206791245,206791187,206790525,206790364,206789150,206789043,206789000,206788857,206786899,206786669,206786320,206783083,206127302,206107874,206096930,206094248,206088752,206083823,206079296,206075516,206058623,206053781,206025629] · 26.1 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 [206025629,206053781,206058623,206075516,206079296,206083823,206088752,206094248,206096930,206107874,206127302,206783083,206786320,206786669,206786899,206788857,206789000,206789043,206789150,206790364,206790525,206791187,206791245,206791302,206791338,206791354,206791464,206807069,206815547,206821517,206822849,206828057,206834093,206841735,206842414,206843269,206844083,206845468,206846033,206846390,206849066,206850560,206850736,206851923,206852996,206853228,206854786,206855116,206864199,206875783] · 71.94 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.41 ms