450 ₴
Продам бризговики універсальні
450.0
Почаев
Найдено 3 857 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3488
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 750,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.12 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["pochaev","\/pochaev","pochaev\/","\/pochaev\/"] · 0.72 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.94 msSHOW TABLES · 1.35 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, ''), NULLIF(c.name_ua, '')) 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) [211997016,211965750,211948899,211948641,211922652,211911669,211875099,211841775,211839930,211838442,211819581,211819410,211806201,211801386,211801335,211801305,211801275,211800423,211795110,211793865,211720107,211705443,211703454,211696791,211690071,211660974,211645050,211640637,211600095,211598229,211586613,211575288,211540323,211514955,211513791,211512147,211506819,211461471,211428792,211393851,211297023,211286439,211286433,211286142,211286130,211286091,211258536,211257006,211241970,211217331] · 23.29 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [211217331,211241970,211257006,211258536,211286091,211286130,211286142,211286433,211286439,211297023,211393851,211428792,211461471,211506819,211512147,211513791,211514955,211540323,211575288,211586613,211598229,211600095,211640637,211645050,211660974,211690071,211696791,211703454,211705443,211720107,211793865,211795110,211800423,211801275,211801305,211801335,211801386,211806201,211819410,211819581,211838442,211839930,211841775,211875099,211911669,211922652,211948641,211948899,211965750,211997016] · 11.92 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 1.48 ms