1 170 ₴
Фильтр тонкой очистки для заправочной станции Silver FL-F11, 25 мм
1170.0
Жидачів
Знайдено 84 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6213
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1 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 ["jidachev","\/jidachev","jidachev\/","\/jidachev\/"] · 0.63 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.31 msSHOW TABLES · 1.27 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) [201926655,201926649,201926641,201530797,200445682,200438863,200436628,199652335,198128590,197853301,194305757,189697560,189348375,187508064,187270479,187270461,187260546,186742188,183806063,182394322,179754101,179334160,176415752,175872216,175872180,175872150,175872117,175872093,175872060,175864599,175864581,175864563,175327843,171709096] · 24.91 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 [171709096,175327843,175864563,175864581,175864599,175872060,175872093,175872117,175872150,175872180,175872216,176415752,179334160,179754101,182394322,183806063,186742188,187260546,187270461,187270479,187508064,189348375,189697560,194305757,197853301,198128590,199652335,200436628,200438863,200445682,201530797,201926641,201926649,201926655] · 3.12 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