Продати

Alpha 110, Львів

3 оголошення

AMP
Фільтри
Canon EOS R5 Mark II, Canon EOS R3, Canon EOS R5, Canon EOS R6 Mark II, Canon R6, Nikon Z9, Nikon Z8
55 794 ₴
55794.0

Canon EOS R5 Mark II, Canon EOS R3, Canon EOS R5, Canon EOS R6 Mark II, Canon R6, Nikon Z9, Nikon Z8

Canon EOS R5 Mark II, Canon EOS R3, Canon EOS R5, Canon EOS R6 Mark II, Canon EOS R6, Canon EOS R7, Canon EOS 1D X Mark III, Canon EOS 5D Mark IV, Nikon Z9, Nikon Z8, Nikon Z 7II, Nikon Z7, Nikon D6, Nikon D850, Nikon D780, Sony Alpha A7R III, Sony Alpha a7R IV бездзеркальна камера , Зв'яжіться з на…

Львів · 21.01.2026
Yaesu FTM-200DE/DR Mobile Transceiver
22 928 ₴
22928.0

Yaesu FTM-200DE/DR Mobile Transceiver

Оригінальний опис від виробника: Yaesu is pleased to introduce the new FTM-200DR – 50W VHF/UHF Dual Band C4FM/ FM Mobile Transceiver. The new FTM-200DR is a C4FM Digital multi-functional transceiver with a single receiver. The FTM-200DR delivers reliable and stable 50W transmit performance. The heav…

Львів · 04.05.2026
380 англомовних коміксів Marvel, DC, Image, Spawn, Venom, Batman, Spider-Man
29 999 ₴
29999.0

380 англомовних коміксів Marvel, DC, Image, Spawn, Venom, Batman, Spider-Man

Продам 380 коміксів, запитуйте в особисті точніші дані бо тут весь список не вліз і даю лише частину 1. Eclipse #5 (Image Comics, 2016) — Б/В 2. Eclipse #5 (Image Comics, 2016) — Б/В [дубль] 3. Black Canary #10 (DC Comics, 2016) — Б/В 4. Black Canary #8 (DC Comics, 2016) — Б/В 5. Mockingbird #3 (Mar…

Львів · 28.06.2026

Схожі запити

Оголошення по областях

OK · 28.9 ms · SQL 8 (8 ms) · ES 1 (13.3 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

Маршрут: категорія —, місто city #125 · ES: всього 3, id на сторінці: 3 · знайдено в БД: 3

Elasticsearch

POST /abyhomcom/_search → 200 · 13.3 ms · знайдено 3, повернуто 3
тіло запиту
{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "alpha 110",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ],
            "filter": [
                {
                    "term": {
                        "city_id": 125
                    }
                }
            ]
        }
    },
    "sort": [
        "_score",
        {
            "data_post": {
                "order": "desc"
            }
        }
    ],
    "from": 0,
    "size": 50,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true,
    "aggs": {
        "cats": {
            "terms": {
                "field": "category_id",
                "size": 2000
            }
        }
    }
}

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 0.71 ms
SELECT 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 ["lvov","\/lvov","lvov\/","\/lvov\/"] · 0.28 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.2 ms
SHOW TABLES · 0.39 ms
SELECT 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) [201607087,207641077,212557458] · 2.77 ms
SELECT 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 [201607087,207641077,212557458] · 1.31 ms
SELECT 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.01 ms
SELECT 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.33 ms