1 900 $
Mazda 3
83600.0
Острог
Найдено 4 635 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3503
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3350,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.14 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["ostrog","\/ostrog","ostrog\/","\/ostrog\/"] · 1.28 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.65 msSHOW TABLES · 0.94 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, ''), NULLIF(c.name_ua, '')) 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) [186613437,186611151,186607953,186598197,186589566,186537315,186510180,186498801,186498774,186435282,186408255,186402942,186393762,186393471,186340266,186339771,186336201,186269052,186265668,186254949,186254925,186251091,186250830,186233724,186210540,186196918,186194992,186186282,186185650,186152124,186151248,186090393,186089154,186081708,186081186,186079671,186079614,186069735,186063810,186061293,186060678,186057222,186055548,186053190,186044394,186024459,186005400,186005211,186004965,185995182] · 42.31 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [185995182,186004965,186005211,186005400,186024459,186044394,186053190,186055548,186057222,186060678,186061293,186063810,186069735,186079614,186079671,186081186,186081708,186089154,186090393,186151248,186152124,186185650,186186282,186194992,186196918,186210540,186233724,186250830,186251091,186254925,186254949,186265668,186269052,186336201,186339771,186340266,186393471,186393762,186402942,186408255,186435282,186498774,186498801,186510180,186537315,186589566,186598197,186607953,186611151,186613437] · 2.86 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 0.52 ms