13 682 324 ₴
Продаж комерційної будівлі та земельної ділянки м Броди Львівськоїобл.
13682324.0
Броди
Знайдено 6 868 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3179
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3850,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.35 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 ["brody","\/brody","brody\/","\/brody\/"] · 0.54 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.61 msSHOW TABLES · 0.91 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) [196655521,196648405,196642147,196641055,196616089,196602994,196596394,196596337,196595275,196594978,196588621,196584067,196580195,196570077,196570063,196570059,196561373,196552539,196547963,196541960,196541891,196541843,196524290,196516217,196515512,196512407,196509332,196508747,196506608,196484252,196483364,196481309,196481258,196481252,196481228,196480967,196463408,196462997,196450802,196440086,196417754,196414943,196401806,196386785,196371413,196362836,196355936,196354673,196353497,196352291] · 28.42 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 [196352291,196353497,196354673,196355936,196362836,196371413,196386785,196401806,196414943,196417754,196440086,196450802,196462997,196463408,196480967,196481228,196481252,196481258,196481309,196483364,196484252,196506608,196508747,196509332,196512407,196515512,196516217,196524290,196541843,196541891,196541960,196547963,196552539,196561373,196570059,196570063,196570077,196580195,196584067,196588621,196594978,196595275,196596337,196596394,196602994,196616089,196641055,196642147,196648405,196655521] · 5.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.parent_id = ? LIMIT 3000 [5] · 0.93 ms