70 €
Фонарі ліхтарі фонарь Caddy ляда розпашонка 04-20р підходять
Ківерці
Знайдено 8 502 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3608
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3750,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.28 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 ["kivercy","\/kivercy","kivercy\/","\/kivercy\/"] · 0.61 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.69 msSHOW TABLES · 15.5 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) [203347562,203347076,203335424,203329499,203328680,203324084,203321843,203317832,203317802,203315741,203310932,203310173,203310077,203304416,203271587,203271197,203265641,203256572,203255327,203245106,203237933,203234252,203234147,203232605,203212184,203209004,203206004,203202146,203199419,203160274,203158429,203157535,203156422,203155132,203155069,203148022,203144617,203143090,203143027,203142010,203141791,203141782,203141737,203141038,203141008,203141005,203137249,203098723,203098612,203095669] · 42.12 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 [203095669,203098612,203098723,203137249,203141005,203141008,203141038,203141737,203141782,203141791,203142010,203143027,203143090,203144617,203148022,203155069,203155132,203156422,203157535,203158429,203160274,203199419,203202146,203206004,203209004,203212184,203232605,203234147,203234252,203237933,203245106,203255327,203256572,203265641,203271197,203271587,203304416,203310077,203310173,203310932,203315741,203317802,203317832,203321843,203324084,203328680,203329499,203335424,203347076,203347562] · 1.81 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.94 ms