6 ₴
Продам Ячмінь 6гр Пшеницю 6гр , Кукурузу 6 гр
6.0
Просяне
Знайдено 62 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 9314
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.76 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 ["prosyanoe","\/prosyanoe","prosyanoe\/","\/prosyanoe\/"] · 1.66 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.6 msSHOW TABLES · 0.86 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) [218967734,218963693,217947509,217566010,217529440,217469491,217453228,217299358,217075813,216350515,216198493,216187867,215728406,215476230,215361285,215283129,215225910,215159262,214971684,214924284,212565879,212314365,210202403,209653161,209443360,208819246,208310260,205564937,200687029,200239405,198824983,198222921,198042477,197554676,197461238,197399279,196911808,196850311,196699534,196377281,196200224,195895343,195442946,195117911,193361341,193338501,192726847,192461284,192460612,192460228] · 18.98 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 [192460228,192460612,192461284,192726847,193338501,193361341,195117911,195442946,195895343,196200224,196377281,196699534,196850311,196911808,197399279,197461238,197554676,198042477,198222921,198824983,200239405,200687029,205564937,208310260,208819246,209443360,209653161,210202403,212314365,212565879,214924284,214971684,215159262,215225910,215283129,215361285,215476230,215728406,216187867,216198493,216350515,217075813,217299358,217453228,217469491,217529440,217566010,217947509,218963693,218967734] · 2.29 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.58 ms