400 €
Подушки переднего подрамника Mercedes W140
Чайки
Знайдено 2 768 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6198
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 850,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.65 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 ["chayki","\/chayki","chayki\/","\/chayki\/"] · 1.68 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.4 msSHOW TABLES · 0.94 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) [212901177,212868657,212860110,212844996,212832072,212821557,212810370,212808468,212765328,212760384,212733555,212731860,212731653,212726655,212725314,212700609,212694339,212652309,212652204,212634879,212626122,212626080,212624790,212623335,212620998,212586225,212582589,212542209,212536917,212535717,212535444,212524011,212517777,212515122,212515044,212504970,212501322,212477514,212435733,212421273,212410662,212357730,212351748,212344575,212318268,212318250,212317569,212315445,212289735,212266083] · 34.88 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 [212266083,212289735,212315445,212317569,212318250,212318268,212344575,212351748,212357730,212410662,212421273,212435733,212477514,212501322,212504970,212515044,212515122,212517777,212524011,212535444,212535717,212536917,212542209,212582589,212586225,212620998,212623335,212624790,212626080,212626122,212634879,212652204,212652309,212694339,212700609,212725314,212726655,212731653,212731860,212733555,212760384,212765328,212808468,212810370,212821557,212832072,212844996,212860110,212868657,212901177] · 30.62 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.98 ms