700 ₴
Актуатор турбіни 6nw008412
700.0
Клевань
Знайдено 1 199 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6359
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 450,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 0.95 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 ["klevan","\/klevan","klevan\/","\/klevan\/"] · 0.81 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.3 msSHOW TABLES · 1.05 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) [207762442,207743248,207663865,207626986,207626968,207612061,207609358,207585019,207561202,207551962,207518452,207515764,207475801,207475783,207475744,207475285,207475264,207466327,207363166,207360922,207346387,207333484,207308086,207294613,207247687,207247507,207242140,207166501,207091507,207085519,207031819,206998471,206998355,206996375,206981783,206956069,206944755,206911621,206905209,206882783,206882371,206845314,206845300,206792411,206126783,205976138,205963772,205859276,205806860,205806857] · 35 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 [205806857,205806860,205859276,205963772,205976138,206126783,206792411,206845300,206845314,206882371,206882783,206905209,206911621,206944755,206956069,206981783,206996375,206998355,206998471,207031819,207085519,207091507,207166501,207242140,207247507,207247687,207294613,207308086,207333484,207346387,207360922,207363166,207466327,207475264,207475285,207475744,207475783,207475801,207515764,207518452,207551962,207561202,207585019,207609358,207612061,207626968,207626986,207663865,207743248,207762442] · 15.21 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] · 2.52 ms