2 800 ₴
Форсунки om651 w212
2800.0
Васильків
Знайдено 14 664 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3084
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 5450,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.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 ["vasilkov","\/vasilkov","vasilkov\/","\/vasilkov\/"] · 1.21 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.86 msSHOW TABLES · 1.06 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) [207504154,207498124,207497911,207497392,207496912,207493099,207492895,207492073,207489190,207488683,207479665,207476839,207475531,207473185,207470323,207470131,207460759,207460558,207459640,207459532,207454609,207450931,207443236,207441871,207439924,207437239,207435856,207435592,207432262,207430819,207429715,207429043,207426400,207425128,207424447,207420847,207419293,207417796,207409675,207402613,207401179,207400519,207400432,207399493,207399478,207398989,207397321,207396613,207396391,207393838] · 35.16 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 [207393838,207396391,207396613,207397321,207398989,207399478,207399493,207400432,207400519,207401179,207402613,207409675,207417796,207419293,207420847,207424447,207425128,207426400,207429043,207429715,207430819,207432262,207435592,207435856,207437239,207439924,207441871,207443236,207450931,207454609,207459532,207459640,207460558,207460759,207470131,207470323,207473185,207475531,207476839,207479665,207488683,207489190,207492073,207492895,207493099,207496912,207497392,207497911,207498124,207504154] · 9.55 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.23 ms