500 ₴
Корпус Apple Iphone Оригинал
500.0
Херсон
Знайдено 339 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "apple iphone",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"terms": {
"city_id": [
2209,
136,
2210,
3506,
3507,
3508,
3509,
3510,
3511,
3512,
3513,
3514,
3515,
3516,
3517,
3518,
3519,
3520,
3521,
3522,
3523,
3524,
3649,
6195,
6277,
6289,
6315,
6335,
6391,
6436,
6550,
6660,
6868,
6974,
7064,
7065,
7068,
7320,
7375,
7411,
7413,
7486,
7498,
7508,
7527,
7528,
7577,
7722,
7731,
7752,
7756,
7954,
8022,
8176,
8266,
8332,
8380,
8406,
8652,
8655,
8687,
8700,
8727,
8746,
8836,
8982,
9021,
9040,
9077,
9108,
9136,
9171,
9178,
9311,
9411,
9472,
9488,
9724,
9735,
9805,
9817,
9935,
10137,
10142,
10191,
10282,
10292,
10350,
10415,
10426,
10505,
10662,
10717,
10797,
10879,
10900,
11106,
11288,
11438,
11489,
11632,
11645,
11688,
11811,
11865,
11887,
11901,
12028,
12265,
12507,
12570,
12646,
12704,
12731
]
}
}
]
}
},
"sort": [
"_score",
{
"data_post": {
"order": "desc"
}
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true,
"aggs": {
"cities": {
"terms": {
"field": "city_id",
"size": 30
}
},
"cats": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
}SELECT c.* FROM `category` c ORDER BY c.id · 1.71 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 ["hersonskaya-oblast","\/hersonskaya-oblast","hersonskaya-oblast\/","\/hersonskaya-oblast\/"] · 0.77 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.4 msSELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2209] · 0.6 msSELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [136,2210,3506,3507,3508,3509,3510,3511,3512,3513,3514,3515,3516,3517,3518,3519,3520,3521,3522,3523,3524,3649,6195,6277,6289,6315,6335,6391,6436,6550,6660,6868,6974,7064,7065,7068,7320,7375,7411,7413,7486,7498,7508,7527,7528,7577,7722,7731,7752,7756,7954,8022,8176,8266,8332,8380,8406,8652,8655,8687,8700,8727,8746,8836,8982,9021,9040,9077,9108,9136,9171,9178,9311,9411,9472,9488,9724,9735,9805,9817,9935,10137,10142,10191,10282,10292,10350,10415,10426,10505,10662,10717,10797,10879,10900,11106,11288,11438,11489,11632,11645,11688,11811,11865,11887,11901,12028,12265,12507,12570,12646,12704,12731] · 1.32 msSHOW TABLES · 0.65 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) [203574056,188430516,187090824,186400812,183039501,182870640,182819667,182182630,179611395,189849549,188430498,187090788,186400782,185419230,182819661,182819655,182182624,181469623,179611371,179611363,179334415,198128419,196442795,196139531,196139525,189849543,189849537,189236634,189146116,188430468,187090860,187090752,187004496,186400740,186307683,186223296,185622234,185519520,184761859,184761820,184678543,183120342,183039576,183039549,183039519,182819673,182738484,182182636,181817332,181817278] · 14.28 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 [179334415,179611363,179611371,179611395,181469623,181817278,181817332,182182624,182182630,182182636,182738484,182819655,182819661,182819667,182819673,182870640,183039501,183039519,183039549,183039576,183120342,184678543,184761820,184761859,185419230,185519520,185622234,186223296,186307683,186400740,186400782,186400812,187004496,187090752,187090788,187090824,187090860,188430468,188430498,188430516,189146116,189236634,189849537,189849543,189849549,196139525,196139531,196442795,198128419,203574056] · 2.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 [2209] · 0.66 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.id IN (?,?,?) [136,3508,6195] · 0.24 ms