200 ₴
Старовинний залізничний свічковий ліхтар
200.0
Ланівці
Знайдено 1 185 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3484
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 13.95 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 ["lanovcy","\/lanovcy","lanovcy\/","\/lanovcy\/"] · 5.21 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 3.36 msSHOW TABLES · 7.85 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) [211753302,211695243,211667214,211666896,211607868,211349505,211340679,211268529,211261590,211107090,211072068,210998436,210974208,210951514,210928046,210867466,210860602,210859000,210811172,210810696,210805608,210794354,210794308,210653700,210649026,210648956,210612604,210576629,210379244,210335645,210305492,210004484,210003710,210003146,209785457,209769479,209727569,209709374,209621326,209616037,209613859,209608078,209600956,209581648,209562610,209527780,209483965,209447473,209444794,209443795] · 180.4 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 [209443795,209444794,209447473,209483965,209527780,209562610,209581648,209600956,209608078,209613859,209616037,209621326,209709374,209727569,209769479,209785457,210003146,210003710,210004484,210305492,210335645,210379244,210576629,210612604,210648956,210649026,210653700,210794308,210794354,210805608,210810696,210811172,210859000,210860602,210867466,210928046,210951514,210974208,210998436,211072068,211107090,211261590,211268529,211340679,211349505,211607868,211666896,211667214,211695243,211753302] · 131.22 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] · 2.88 ms