400 ₴
Босоніжки Lasocki 26 розмір
400.0
Умань
Знайдено 30 602 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2218
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 9050,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.72 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 ["uman","\/uman","uman\/","\/uman\/"] · 0.62 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.31 msSHOW TABLES · 0.46 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) [209938961,209936009,209930492,209927489,209924543,209907281,209903435,209903186,209902994,209902301,209901890,209900363,209899655,209898923,209898194,209897237,209896568,209896460,209896046,209895644,209893475,209891453,209888162,209888054,209884304,209880416,209878340,209877818,209876813,209876453,209874446,209874344,209874317,209874041,209873870,209872325,209872142,209871917,209871734,209869592,209868041,209867690,209866646,209865104,209863400,209861510,209861354,209860583,209858237,209857610] · 151.98 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 [209857610,209858237,209860583,209861354,209861510,209863400,209865104,209866646,209867690,209868041,209869592,209871734,209871917,209872142,209872325,209873870,209874041,209874317,209874344,209874446,209876453,209876813,209877818,209878340,209880416,209884304,209888054,209888162,209891453,209893475,209895644,209896046,209896460,209896568,209897237,209898194,209898923,209899655,209900363,209901890,209902301,209902994,209903186,209903435,209907281,209924543,209927489,209930492,209936009,209938961] · 24.72 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.96 ms