980 ₴
Черевики Quechua Cross rock
980.0
Може
Знайдено 11 499 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6243
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 950,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.45 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 ["limanka","\/limanka","limanka\/","\/limanka\/"] · 0.96 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.38 msSHOW TABLES · 0.32 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) [217272337,217269115,217266922,217266646,217251946,217251217,217250299,217248397,217246468,217243738,217242238,217241047,217236301,217227424,217219969,217219867,217219765,217219732,217209010,217204651,217204423,217204234,217203004,217200643,217200622,217199413,217197595,217197259,217197205,217195981,217190929,217190497,217185727,217185562,217176199,217168534,217164433,217164367,217163818,217162804,217162432,217162309,217156795,217156567,217156510,217154644,217153066,217151485,217148050,217147720] · 52.86 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 [217147720,217148050,217151485,217153066,217154644,217156510,217156567,217156795,217162309,217162432,217162804,217163818,217164367,217164433,217168534,217176199,217185562,217185727,217190497,217190929,217195981,217197205,217197259,217197595,217199413,217200622,217200643,217203004,217204234,217204423,217204651,217209010,217219732,217219765,217219867,217219969,217227424,217236301,217241047,217242238,217243738,217246468,217248397,217250299,217251217,217251946,217266646,217266922,217269115,217272337] · 42.54 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.39 ms