58 000 ₴
New Apple MacBook Air 15 M5 16Gb / 512Gb
58000.0
Морське
Знайдено 39 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7745
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.48 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 ["morskoe","\/morskoe","morskoe\/","\/morskoe\/"] · 2.3 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.94 msSHOW TABLES · 0.53 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) [218944181,218373479,218266837,217654588,216698797,215538144,214368714,214197609,213878424,213485913,213000393,211368588,210718088,210535433,210504704,210049622,209656626,208573108,206093231,205209131,205116884,204300627,203728568,203723056,203686061,203537837,200495308,199787131,199521205,198010642,197595104,197540714,197124763,195619631,194738315,194721299,186396756,185520975,175417669] · 23.32 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 [175417669,185520975,186396756,194721299,194738315,195619631,197124763,197540714,197595104,198010642,199521205,199787131,200495308,203537837,203686061,203723056,203728568,204300627,205116884,205209131,206093231,208573108,209656626,210049622,210504704,210535433,210718088,211368588,213000393,213485913,213878424,214197609,214368714,215538144,216698797,217654588,218266837,218373479,218944181] · 6.22 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.32 ms