900 ₴
Бензонасос на Mitsubishi Outlander XL 2012 року
900.0
Свалява
Знайдено 4 550 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3600
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 3150,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 4.87 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 ["svalyava","\/svalyava","svalyava\/","\/svalyava\/"] · 3.16 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 4.05 msSHOW TABLES · 3.2 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) [186357216,186337344,186328749,186318615,186317802,186309405,186290970,186275121,186271254,186265674,186255396,186247143,186246456,186245190,186232996,186213316,186212010,186212002,186211972,186211960,186211958,186211934,186211932,186198222,186183132,186178748,186160964,186130530,186126416,186120502,186104718,186091455,186068961,186060060,186038745,186034440,186032496,185994912,185994849,185959959,185954031,185933337,185923107,185908008,185885973,185880939,185874729,185861604,185859867,185816205] · 36.56 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 [185816205,185859867,185861604,185874729,185880939,185885973,185908008,185923107,185933337,185954031,185959959,185994849,185994912,186032496,186034440,186038745,186060060,186068961,186091455,186104718,186120502,186126416,186130530,186160964,186178748,186183132,186198222,186211932,186211934,186211958,186211960,186211972,186212002,186212010,186213316,186232996,186245190,186246456,186247143,186255396,186265674,186271254,186275121,186290970,186309405,186317802,186318615,186328749,186337344,186357216] · 1.42 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.13 ms