Продати

Hackrf one — Хобі та спорт

4 оголошення

AMP
Фільтри
Книга One Million Followers by Brendan Kane для збільшення охоплень
900 ₴
900.0

Книга One Million Followers by Brendan Kane для збільшення охоплень

Brendan Kane One Million Followers, Updated Edition: How I Built a Massive Social Following in 30 Days English edition Over 60 billion online messages are sent on digital platforms every day, and only a select few succeed in the mad scramble for customer attention. This means that the question for a…

Стрий · 12.02.2026
Cryptography and Network Security by Stallings Книга НОВАЯ
3 600 ₴
3600.0

Cryptography and Network Security by Stallings Книга НОВАЯ

КНИГА ВЫСЫЛАЕТСЯ НАЛОЖЕННЫМ ПЛАТЕЖОМ НОВОЙ ПОЧТОЙ Cryptography and Network Security: Principles and Practice, Global Edition 2016 by William Stallings Printed in the USA. Книга новая, ею HE пользовались. Stallings’ Cryptography and Network Security, Seventh Edition, introduces the reader to the comp…

Харків · 17.10.2025
Future Crimes: Everything Is Connected, Everyone Is Vulnerable
800 ₴
800.0

Future Crimes: Everything Is Connected, Everyone Is Vulnerable

КНИГА ВЫСЫЛАЕТСЯ НАЛОЖЕННЫМ ПЛАТЕЖОМ НОВОЙ ПОЧТОЙ Future Crimes: Everything Is Connected, Everyone Is Vulnerable and What We Can Do About It, 2015 by Marc Goodman Printed in the USA. Книга новая, ею не пользовались. Review “Addictive….[I]ntroduces readers to this brave new world of technology, where…

Харків · 10.01.2025
Лайфхаки для Walt Disney World: понад 350 секретів парку Сьюзен Венесс
350 ₴
350.0

Лайфхаки для Walt Disney World: понад 350 секретів парку Сьюзен Венесс

Walt Disney World Hacks: 350+ Park Secrets for Making the Most of Your Walt Disney World Vacation (Disney Hidden Magic Gift Series) Лайфгаки для парків Волта Діснея: понад 350 секретів парків, щоб отримати максимум від вашої відпустки у Волта Діснея (серія прихованих магічних подарунків Disney) Maxi…

Кривий Ріг · 22.05.2026

Схожі запити

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

OK · 115.5 ms · SQL 9 (74.8 ms) · ES 1 (26.7 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

Маршрут: категорія #76 /hobbi-i-sport/, місто — · ES: всього 4, id на сторінці: 4 · знайдено в БД: 4

Elasticsearch

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

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 2.2 ms
SHOW TABLES · 1.05 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) [202860247,195168317,167991637,209555056] · 4.07 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 [167991637,195168317,202860247,209555056] · 1.18 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.49 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] · 0.91 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.id IN (?,?,?) [135,2101,2183] · 2.02 ms
SELECT v.attribute_id, v.value, COUNT(*) AS cnt FROM (SELECT p.id FROM `post` p WHERE p.category_id IN (?,?,?,?,?,?,?) AND (1) ORDER BY p.id DESC LIMIT 3000) s JOIN `attribute_value` v ON v.post_id = s.id WHERE v.value IS NOT NULL AND v.value <> '' AND CHAR_LENGTH(v.value) <= 60 GROUP BY v.attribute_id, v.value [76,82,81,80,79,78,77] · 60.91 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] · 2 ms