1 400 $
Opel Astra
61600.0
Арциз
Знайдено 1 238 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3154
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 750,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.05 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 ["arciz","\/arciz","arciz\/","\/arciz\/"] · 0.4 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.53 msSHOW TABLES · 0.82 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) [195328721,195310226,195310223,195298088,195234110,195136289,195111767,195083177,194967422,194926958,194829731,194829698,194759591,194737049,194688173,194623244,194621963,194599064,194557226,194555177,194471075,194436005,194424389,194423864,194275862,194226674,194195726,194108312,194055356,194001995,193947171,193905011,193857359,193757348,193751407,193676273,193650881,193632116,193603538,193603484,193599722,193534072,193512004,193480342,193421521,193421299,193386133,193355503,193286149,193265647] · 32.81 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 [193265647,193286149,193355503,193386133,193421299,193421521,193480342,193512004,193534072,193599722,193603484,193603538,193632116,193650881,193676273,193751407,193757348,193857359,193905011,193947171,194001995,194055356,194108312,194195726,194226674,194275862,194423864,194424389,194436005,194471075,194555177,194557226,194599064,194621963,194623244,194688173,194737049,194759591,194829698,194829731,194926958,194967422,195083177,195111767,195136289,195234110,195298088,195310223,195310226,195328721] · 0.89 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.77 ms