10 000 $
Jaguar X-Type
440000.0
Херсон
Знайдено 136 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "type",
"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 · 2.31 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\/"] · 2.37 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.39 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.57 msSHOW TABLES · 0.9 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) [179373385,204177627,187170213,185922564,185242698,214032122,189684279,187170279,187170225,175846500,182089330,180234181,178370100,175846476,197822873,196442663,176567152,175846632,175846518,219207222,188831895,186917370,207761206,187395201,175846596,175846590,168498049,211199427,199276279,188831889,203655386,187170315,187170231,187170219,182870610,180549373,175846488,175543401,196442747,196442627,189014871,187781265,187170207,184506031,184505919,175846572,175846506,175543457,195703826,195703820] · 39.62 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 [168498049,175543401,175543457,175846476,175846488,175846500,175846506,175846518,175846572,175846590,175846596,175846632,176567152,178370100,179373385,180234181,180549373,182089330,182870610,184505919,184506031,185242698,185922564,186917370,187170207,187170213,187170219,187170225,187170231,187170279,187170315,187395201,187781265,188831889,188831895,189014871,189684279,195703820,195703826,196442627,196442663,196442747,197822873,199276279,203655386,204177627,207761206,211199427,214032122,219207222] · 2.2 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] · 2.46 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,3506,6195,3508,3512,3513,3518] · 1.49 ms