6 000 ₴
Продам ноутбук у ідеальному стані ASUS F541U.
6000.0
Богуслав
Знайдено 3 154 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3081
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1450,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.09 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 ["boguslav","\/boguslav","boguslav\/","\/boguslav\/"] · 0.55 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.37 msSHOW TABLES · 1.24 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) [203952891,203951940,203943090,203879433,203855724,203820273,203814102,203811333,203751108,203745122,203731680,203731678,203730656,203725776,203671256,203667737,203658920,203645454,203643814,203632740,203600459,203540474,203530004,203527901,203509067,203500223,203495138,203492579,203479487,203478509,203462069,203461013,203423210,203400725,203394386,203392265,203385254,203374655,203357045,203326880,203311502,203311310,203306306,203263718,203259581,203243837,203238926,203234006,203230343,203206307] · 44.62 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 [203206307,203230343,203234006,203238926,203243837,203259581,203263718,203306306,203311310,203311502,203326880,203357045,203374655,203385254,203392265,203394386,203400725,203423210,203461013,203462069,203478509,203479487,203492579,203495138,203500223,203509067,203527901,203530004,203540474,203600459,203632740,203643814,203645454,203658920,203667737,203671256,203725776,203730656,203731678,203731680,203745122,203751108,203811333,203814102,203820273,203855724,203879433,203943090,203951940,203952891] · 1.25 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.61 ms