5 200 $
Renault Logan
228800.0
Звенигородка
Знайдено 4 911 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3360
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 4300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.34 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 ["zvenigorodka","\/zvenigorodka","zvenigorodka\/","\/zvenigorodka\/"] · 0.56 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.38 msSHOW TABLES · 0.61 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) [177532543,177460907,177460279,177458693,177458559,177439071,177358879,177353245,177333010,177304741,177302884,177250403,177233695,177219567,177214179,177173969,177170187,177152275,177151531,177133271,177130495,177121641,177114829,177109227,177109209,177024599,177012245,177004157,176985459,176985137,176972755,176971629,176913418,176860933,176830792,176815918,176812999,176811592,176811151,176788294,176784439,176755671,176737235,176734333,176723999,176688550,176652628,176609493,176609259,176553460] · 30.01 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 [176553460,176609259,176609493,176652628,176688550,176723999,176734333,176737235,176755671,176784439,176788294,176811151,176811592,176812999,176815918,176830792,176860933,176913418,176971629,176972755,176985137,176985459,177004157,177012245,177024599,177109209,177109227,177114829,177121641,177130495,177133271,177151531,177152275,177170187,177173969,177214179,177219567,177233695,177250403,177302884,177304741,177333010,177353245,177358879,177439071,177458559,177458693,177460279,177460907,177532543] · 1.12 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.62 ms