1 000 ₴
Продається по запчастинах 99
1000.0
Черляни
Знайдено 343 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7902
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.18 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 ["cherlyany","\/cherlyany","cherlyany\/","\/cherlyany\/"] · 1.24 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.34 msSHOW TABLES · 0.55 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) [207014415,206908297,206908275,206908055,206894303,206878853,206876407,206848943,206848936,206848772,206848692,206848652,205839905,205795925,205795445,205772315,205762322,205721561,205721270,205713215,205632206,205571360,205409084,205330160,204863522,204830381,204580808,204394100,204393389,204351959,204150501,204149688,204149634,204099702,204092523,203953182,203923515,203923482,203611484,203403881,203372357,203156341,202618287,202616501,202616319,202569685,202433145,202408663,202408367,202408341] · 19.54 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 [202408341,202408367,202408663,202433145,202569685,202616319,202616501,202618287,203156341,203372357,203403881,203611484,203923482,203923515,203953182,204092523,204099702,204149634,204149688,204150501,204351959,204393389,204394100,204580808,204830381,204863522,205330160,205409084,205571360,205632206,205713215,205721270,205721561,205762322,205772315,205795445,205795925,205839905,206848652,206848692,206848772,206848936,206848943,206876407,206878853,206894303,206908055,206908275,206908297,207014415] · 1.27 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.89 ms