11 500 $
Audi Q7
506000.0
Іршава
Знайдено 5 251 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3596
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 4200,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.58 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 ["irshava","\/irshava","irshava\/","\/irshava\/"] · 0.45 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.87 msSHOW TABLES · 0.83 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) [178906657,178905748,178902130,178893211,178886764,178867615,178862716,178848577,178846504,178827430,178826422,178824436,178821841,178810342,178810297,178810240,178810054,178807642,178806544,178795870,178794541,178753120,178752586,178749736,178749685,178749643,178749298,178747924,178746655,178740520,178733170,178732549,178711762,178604104,178551418,178544794,178532626,178453534,178452187,178445110,178422699,178406769,178364364,178327785,178301994,178289931,178273521,178271349,178265550,178264287] · 54.11 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 [178264287,178265550,178271349,178273521,178289931,178301994,178327785,178364364,178406769,178422699,178445110,178452187,178453534,178532626,178544794,178551418,178604104,178711762,178732549,178733170,178740520,178746655,178747924,178749298,178749643,178749685,178749736,178752586,178753120,178794541,178795870,178806544,178807642,178810054,178810240,178810297,178810342,178821841,178824436,178826422,178827430,178846504,178848577,178862716,178867615,178886764,178893211,178902130,178905748,178906657] · 1.02 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] · 1.92 ms