200 €
Продам Бампер передній Мерседес Мл164
Динівці
Знайдено 227 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 9530
}
}
]
}
},
"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 · 2.5 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 ["dinovcy","\/dinovcy","dinovcy\/","\/dinovcy\/"] · 3.51 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.47 msSHOW TABLES · 1.75 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) [213806082,213806046,213771258,213651417,213647574,213530163,213530025,213529221,213528558,213414534,213317550,212894190,212894160,212617521,212156529,212156478,212132538,212037330,211984185,211660932,211491285,211281831,211253922,211181538,211149552,211015450,210989038,210972254,210971030,210955460,210859088,210848146,210733888,210690760,210613440,210541559,210306956,210187958,209981627,209980772,209854565,209800943,209685530,209531128,209530234,209118373,209118193,209117812,209117635,208538155] · 30.17 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 [208538155,209117635,209117812,209118193,209118373,209530234,209531128,209685530,209800943,209854565,209980772,209981627,210187958,210306956,210541559,210613440,210690760,210733888,210848146,210859088,210955460,210971030,210972254,210989038,211015450,211149552,211181538,211253922,211281831,211491285,211660932,211984185,212037330,212132538,212156478,212156529,212617521,212894160,212894190,213317550,213414534,213528558,213529221,213530025,213530163,213647574,213651417,213771258,213806046,213806082] · 24.21 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.79 ms