5 000 ₴
Ручна Копка септиків
5000.0
Боярка
Найдено 10 557 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2445
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1600,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 5.83 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 ["boyarka","\/boyarka","boyarka\/","\/boyarka\/"] · 0.69 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.3 msSHOW TABLES · 0.39 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) [216034561,216034552,216030331,216029512,216029158,216026878,216026596,216026497,216018496,216016933,216011089,216010843,216009193,215998483,215997799,215997769,215996068,215994466,215994205,215994109,215993695,215981401,215979955,215979928,215975005,215966959,215964886,215964829,215964157,215962735,215961013,215959975,215959723,215958370,215953984,215949391,215949133,215949124,215949007,215948296,215946403,215940400,215939461,215937943,215937331,215936539,215935813,215934748,215934376,215933866] · 29.31 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 [215933866,215934376,215934748,215935813,215936539,215937331,215937943,215939461,215940400,215946403,215948296,215949007,215949124,215949133,215949391,215953984,215958370,215959723,215959975,215961013,215962735,215964157,215964829,215964886,215966959,215975005,215979928,215979955,215981401,215993695,215994109,215994205,215994466,215996068,215997769,215997799,215998483,216009193,216010843,216011089,216016933,216018496,216026497,216026596,216026878,216029158,216029512,216030331,216034552,216034561] · 49.19 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] · 0.46 ms