550 ₴
Продам захист передньої зірки кові адванс
550.0
Шумськ
Знайдено 2 245 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3491
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 250,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.73 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 ["shumsk","\/shumsk","shumsk\/","\/shumsk\/"] · 0.99 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.46 msSHOW TABLES · 0.7 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) [214306029,214274607,214231296,214226622,214202856,214202844,214182830,214170245,214169738,214161443,214161440,214161437,214161434,214161431,214161428,214131546,214128522,214120076,214119552,214100848,214100578,214095850,214095808,214093410,214088654,214082116,214039498,214033402,214025730,213999840,213996628,213991118,213987378,213955760,213955164,213941910,213938616,213913754,213897156,213896766,213896632,213889428,213888262,213856941,213856686,213856614,213856611,213854931,213852846,213852831] · 25.43 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 [213852831,213852846,213854931,213856611,213856614,213856686,213856941,213888262,213889428,213896632,213896766,213897156,213913754,213938616,213941910,213955164,213955760,213987378,213991118,213996628,213999840,214025730,214033402,214039498,214082116,214088654,214093410,214095808,214095850,214100578,214100848,214119552,214120076,214128522,214131546,214161428,214161431,214161434,214161437,214161440,214161443,214169738,214170245,214182830,214202844,214202856,214226622,214231296,214274607,214306029] · 15.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.parent_id = ? LIMIT 3000 [5] · 1.1 ms