200 ₴
Продам на москвич 412
200.0
Пухівка
Знайдено 940 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6250
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 400,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.56 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 ["puhovka","\/puhovka","puhovka\/","\/puhovka\/"] · 0.59 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.3 msSHOW TABLES · 0.87 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) [207302260,207295483,207280453,207263173,207224566,207170221,207150463,207149824,207073599,207110125,207102205,207036867,207035623,207031031,206993307,206950767,206919563,206895999,206889397,206870467,206862455,206855097,206846467,206846455,206834243,206817503,206790473,206123066,206100428,206050937,206027069,205999688,205913516,205834376,205804508,205798268,205783646,205744256,205737878,205737104,205681925,205671617,205665950,205573448,205552376,205519322,205518905,205444691,205439858,205435085] · 21.66 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 [205435085,205439858,205444691,205518905,205519322,205552376,205573448,205665950,205671617,205681925,205737104,205737878,205744256,205783646,205798268,205804508,205834376,205913516,205999688,206027069,206050937,206100428,206123066,206790473,206817503,206834243,206846455,206846467,206855097,206862455,206870467,206889397,206895999,206919563,206950767,206993307,207031031,207035623,207036867,207102205,207110125,207149824,207150463,207170221,207224566,207263173,207280453,207295483,207302260] · 13.27 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.84 ms