4 440 $
Kawasaki KLX 230
3 000 км 195360.0
Богуслав
Знайдено 3 156 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3081
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1250,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.39 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 ["boguslav","\/boguslav","boguslav\/","\/boguslav\/"] · 0.42 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.32 msSHOW TABLES · 0.97 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) [207341449,207338653,207311539,207266149,207227710,207214861,207196645,207190891,207095557,207095242,207093739,207077674,207058833,207046777,207025169,207019077,207019015,207016803,207008943,206993573,206985691,206967941,206959811,206958777,206947175,206946283,206919615,206910323,206905455,206890647,206879877,206854042,206852889,206847168,206843152,206838707,206835307,206828003,206818237,206802679,206797175,206791721,206785495,206124671,206118842,206092406,206070278,206049209,206043029,206016194] · 39.21 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 [206016194,206043029,206049209,206070278,206092406,206118842,206124671,206785495,206791721,206797175,206802679,206818237,206828003,206835307,206838707,206843152,206847168,206852889,206854042,206879877,206890647,206905455,206910323,206919615,206946283,206947175,206958777,206959811,206967941,206985691,206993573,207008943,207016803,207019015,207019077,207025169,207046777,207058833,207077674,207093739,207095242,207095557,207190891,207196645,207214861,207227710,207266149,207311539,207338653,207341449] · 13.84 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.95 ms