999 ₴
Мотор 4.2 дизель Nissan Patrol+КПП
999.0
Білі Ослави
Знайдено 555 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 9125
}
}
]
}
},
"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 · 6.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.url IN (?, ?, ?, ?) LIMIT 1 ["belye-oslavy","\/belye-oslavy","belye-oslavy\/","\/belye-oslavy\/"] · 2.91 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.99 msSHOW TABLES · 4.03 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) [215916751,215811743,215757080,215677469,215609994,215609829,215586336,215532336,215411712,215385866,215377791,215340908,215340334,215318884,215265960,215265822,215149236,215051130,215007033,214943625,214915940,214915934,214914852,214637529,214470717,214377741,214373574,214316598,214286820,214265082,214288200,214231764,214041684,214025290,214025280,214025202,214000900,213913810,213705321,213530322,213530301,213529965,213528144,213020181,212912424,212842341,212810682,212764500,212762349,212761488] · 53.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 [212761488,212762349,212764500,212810682,212842341,212912424,213020181,213528144,213529965,213530301,213530322,213705321,213913810,214000900,214025202,214025280,214025290,214041684,214231764,214288200,214316598,214373574,214377741,214470717,214637529,214914852,214915934,214915940,214943625,215007033,215051130,215149236,215265822,215265960,215318884,215340334,215340908,215377791,215385866,215411712,215532336,215586336,215609829,215609994,215677469,215757080,215811743,215916751] · 9.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] · 0.56 ms