46 000 ₴
АКБ Deye SE 5.1 pro B
46000.0
Підгородне
Знайдено 4 749 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3646
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2700,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.99 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 ["podgorodnoe","\/podgorodnoe","podgorodnoe\/","\/podgorodnoe\/"] · 6.55 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.33 msSHOW TABLES · 0.64 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) [199804006,199786936,199784662,199783876,199782262,199766944,199761313,199748293,199707796,199707436,199701607,199701478,199638157,199625842,199593739,199587088,199586845,199571458,199570513,199524655,199504249,199488442,199475590,199465345,199463830,199423192,199413355,199412875,199408825,199408789,199402561,199398127,199391347,199376989,199348873,199310230,199290850,199258171,199251976,199242799,199223272,199222867,199202008,199201318,199200892,199200598,199200541,199200493,199200247,199200169] · 128.93 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 [199200169,199200247,199200493,199200541,199200598,199200892,199201318,199202008,199222867,199223272,199242799,199251976,199258171,199290850,199310230,199348873,199376989,199391347,199398127,199402561,199408789,199408825,199412875,199413355,199423192,199463830,199465345,199475590,199488442,199504249,199524655,199570513,199571458,199586845,199587088,199593739,199625842,199638157,199701478,199701607,199707436,199707796,199748293,199761313,199766944,199782262,199783876,199784662,199786936,199804006] · 1.6 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.72 ms