100 ₴
Хрестовина карданного валу ЗІЛ (ціна договірна)
100.0
Веселе
Знайдено 217 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3205
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 150,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 4.06 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 ["veseloe","\/veseloe","veseloe\/","\/veseloe\/"] · 0.54 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.37 msSHOW TABLES · 0.73 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) [195839078,195831809,195620720,195528347,195502091,195502013,195483404,195357149,195200753,194914463,194912885,194613239,194290454,193476871,192546127,192456202,192436417,192273781,191133738,190876950,190847457,190795425,190753425,189802728,189795582,189742176,189122103,188738049,187823670,187318191,186209828,185966184,185270655,183944513,183910187,183814298,183366177,181772269,181741012,180903544,180805531,178821739,178748977,178745410,178481932,178350108,175638698,175304237,174606550,173387707] · 77.81 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 [173387707,174606550,175304237,175638698,178350108,178481932,178745410,178748977,178821739,180805531,180903544,181741012,181772269,183366177,183814298,183910187,183944513,185270655,185966184,186209828,187318191,187823670,188738049,189122103,189742176,189795582,189802728,190753425,190795425,190876950,191133738,192273781,192436417,192456202,192546127,193476871,194290454,194613239,194912885,194914463,195200753,195357149,195483404,195502013,195502091,195528347,195620720,195831809,195839078] · 1.08 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.92 ms