1 450 $
Daewoo Lanos
63800.0
Чугуїв
Знайдено 7 530 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3130
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 4950,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 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.url IN (?, ?, ?, ?) LIMIT 1 ["chuguev","\/chuguev","chuguev\/","\/chuguev\/"] · 0.75 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.21 msSHOW TABLES · 0.46 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) [198389591,198383138,198375888,198374896,198374346,198372918,198360066,198350738,198343932,198340914,198338796,198337878,198335438,198333692,198330661,198330646,198330028,198329848,198329659,198305123,198293643,198289837,198271223,198262199,198260723,198253287,198252729,198252423,198247471,198247209,198246751,198234435,198218287,198215495,198212467,198211773,198183844,198179905,198162112,198160039,198159850,198159583,198158764,198158686,198156691,198145966,198139417,198139366,198125119,198123127] · 37.54 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 [198123127,198125119,198139366,198139417,198145966,198156691,198158686,198158764,198159583,198159850,198160039,198162112,198179905,198183844,198211773,198212467,198215495,198218287,198234435,198246751,198247209,198247471,198252423,198252729,198253287,198260723,198262199,198271223,198289837,198293643,198305123,198329659,198329848,198330028,198330646,198330661,198333692,198335438,198337878,198338796,198340914,198343932,198350738,198360066,198372918,198374346,198374896,198375888,198383138,198389591] · 43.81 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.34 ms