10 000 €
Кран маніпулятор Atlas AK 1551 A4
Пас
Знайдено 2 307 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6491
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.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 ["minay","\/minay","minay\/","\/minay\/"] · 1.59 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.74 msSHOW TABLES · 0.61 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) [218759960,218736542,218726264,218720930,218717594,218704745,218703602,218701337,218700749,218691758,218673185,218666369,218644136,218639804,218621993,218606975,218599658,218590547,218586791,218586566,218576915,218546753,218538119,218528192,218521427,218519618,218514137,218505101,218488658,218483474,218477636,218435150,218428637,218401871,218378696,218350955,218342309,218342231,218291395,218290343,218260927,218256922,218248522,218242750,218238766,218174749,218173147,218171035,218169307,218149231] · 2.95 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 [218149231,218169307,218171035,218173147,218174749,218238766,218242750,218248522,218256922,218260927,218290343,218291395,218342231,218342309,218350955,218378696,218401871,218428637,218435150,218477636,218483474,218488658,218505101,218514137,218519618,218521427,218528192,218538119,218546753,218576915,218586566,218586791,218590547,218599658,218606975,218621993,218639804,218644136,218666369,218673185,218691758,218700749,218701337,218703602,218704745,218717594,218720930,218726264,218736542,218759960] · 10.28 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.8 ms