7 150 $
Nissan Navara
314600.0
Рокитне
Знайдено 5 985 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3505
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2850,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 70.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 ["rokitnoe","\/rokitnoe","rokitnoe\/","\/rokitnoe\/"] · 1.66 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.26 msSHOW TABLES · 0.48 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) [202315343,202315319,202315145,202314971,202310134,202310101,202309918,202308835,202308358,202302095,202300143,202278469,202272265,202272040,202249273,202245376,202241458,202230790,202229638,202214200,202212073,202208431,202189117,202170109,202163245,202145407,202131943,202127008,202125850,202121482,202115380,202106500,202105705,202102813,202101595,202090732,202090390,202083277,202064105,202061107,202054713,202053737,202053709,202047844,202044136,202039264,202032085,202029238,202007181,202005485] · 25.67 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 [202005485,202007181,202029238,202032085,202039264,202044136,202047844,202053709,202053737,202054713,202061107,202064105,202083277,202090390,202090732,202101595,202102813,202105705,202106500,202115380,202121482,202125850,202127008,202131943,202145407,202163245,202170109,202189117,202208431,202212073,202214200,202229638,202230790,202241458,202245376,202249273,202272040,202272265,202278469,202300143,202302095,202308358,202308835,202309918,202310101,202310134,202314971,202315145,202315319,202315343] · 1.76 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] · 2.47 ms