1 200 ₴
Двері на Газель водійська та пасажирська
1200.0
Ромни
Знайдено 10 456 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2994
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 6850,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.83 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 ["romny","\/romny","romny\/","\/romny\/"] · 2.37 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.6 msSHOW TABLES · 1.44 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) [194615927,194610497,194606975,194605580,194603171,194601011,194586485,194585840,194584973,194574212,194569040,194516927,194511530,194491298,194470508,194464979,194449556,194439641,194423567,194421977,194420486,194417966,194411963,194387861,194382347,194369291,194368376,194367296,194343146,194342774,194323727,194297702,194283662,194273576,194256095,194256041,194246108,194241734,194231786,194219813,194217566,194217131,194212526,194202419,194198366,194181203,194178875,194174159,194169158,194148020] · 23.53 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 [194148020,194169158,194174159,194178875,194181203,194198366,194202419,194212526,194217131,194217566,194219813,194231786,194241734,194246108,194256041,194256095,194273576,194283662,194297702,194323727,194342774,194343146,194367296,194368376,194369291,194382347,194387861,194411963,194417966,194420486,194421977,194423567,194439641,194449556,194464979,194470508,194491298,194511530,194516927,194569040,194574212,194584973,194585840,194586485,194601011,194603171,194605580,194606975,194610497,194615927] · 1.05 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] · 1.65 ms