1 550 ₴
Ліхтар Subaru Outback 96-04 BG BH фонарь Субару аутбек Аутбэк стоп фар
1550.0
Костопіль
Знайдено 14 183 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3501
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3900,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 4.63 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 ["kostopol","\/kostopol","kostopol\/","\/kostopol\/"] · 1.33 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 3.37 msSHOW TABLES · 0.68 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) [210657026,210657022,210657018,210657014,210657006,210656992,210656974,210656956,210656914,210656898,210656882,210656870,210656856,210656842,210656788,210656746,210656712,210656698,210656082,210655942,210654374,210652342,210649670,210649538,210648108,210647490,210646086,210632764,210627360,210625260,210620906,210619206,210618432,210614712,210614708,210613590,210613498,210611723,210609626,210599468,210577856,210577103,210571661,210566291,210545882,210545678,210544709,210542495,210533168,210522839] · 23.18 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 [210522839,210533168,210542495,210544709,210545678,210545882,210566291,210571661,210577103,210577856,210599468,210609626,210611723,210613498,210613590,210614708,210614712,210618432,210619206,210620906,210625260,210627360,210632764,210646086,210647490,210648108,210649538,210649670,210652342,210654374,210655942,210656082,210656698,210656712,210656746,210656788,210656842,210656856,210656870,210656882,210656898,210656914,210656956,210656974,210656992,210657006,210657014,210657018,210657022,210657026] · 5.6 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.01 ms