Продати

Tom ford for — Робота

5 оголошень

AMP
Фільтри
Money Credit Offer & Project Financing
4 000 000 ₴
4000000.0

Money Credit Offer & Project Financing

Project financing program. We offer flexible financing for various projects by following the usual rigorous procedures. This funding program allows a customer to enjoy a low interest rate repayment for as low as 3% per year for a period of 1-30 years. We can approve a financing for up to $/EU50,000,…

Київ · 18.03.2025
Менеджер з підтримки клієнтів
30 000 ₴
30000.0

Менеджер з підтримки клієнтів

Описание работы Here is a fluent and professional English translation of your text: We-Webcompany — a company specializing in promoting businesses in the online space — is looking for talented Customer Support Managers.We offer:A fixed starting salary from UAH 28,000 for the initial periodCompetitiv…

Україна · 03.06.2025
Adaptive Robot Market: Revolutionizing Automation with Flexibility and Intelligence by 2030
4 950 ₴
4950.0

Adaptive Robot Market: Revolutionizing Automation with Flexibility and Intelligence by 2030

The Adaptive Robot Market is witnessing robust expansion as industries seek intelligent, flexible robotic systems capable of adjusting to dynamic tasks and environments. According to Market Research Future, the global market for adaptive robots is projected to reach USD 18.7 billion by 2030, growing…

Запоріжжя · 06.07.2025
How to Make Money With Lottery Spells That Work Immediately cell +27633555301 Powerful
100 ₴
100.0

How to Make Money With Lottery Spells That Work Immediately cell +27633555301 Powerful

What would you do if you were to win the lottery? This could be a truly life-changing moment as money problems could soon become something of the past. However, winning the lotto is something that many people will only ever wish for as they buy ticket after ticket and watch the money going to other…

Житомир · 26.03.2025
We Offer Real Credit Services. To The General Public, Now In Order To
5 000 000 ₴
5000000.0

We Offer Real Credit Services. To The General Public, Now In Order To

We Offer Real Credit Services. To The General Public, Now In Order To Improve Mankind And Save Those Who Have Bad Credit. Credits We Have Certified And 100% Reliable. We Make Sure That Our Customers Are Dealing With Every Encouragement With The Best Resources. Our Service Credit Is Very Easy And Eff…

Київ · 22.02.2025

Схожі запити

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

OK · 55.2 ms · SQL 10 (23.4 ms) · ES 1 (23.3 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

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

Elasticsearch

POST /abyhomcom/_search → 200 · 23.3 ms · знайдено 5, повернуто 5
тіло запиту
{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "tom ford for",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ],
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            29,
                            31,
                            30
                        ]
                    }
                }
            ]
        }
    },
    "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 · 1.22 ms
SHOW TABLES · 1.12 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) [176568262,183212490,186004185,177178717,174442168] · 0.83 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 [174442168,176568262,177178717,183212490,186004185] · 0.7 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.09 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.08 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 (?,?,?,?) [115,5,119,120] · 0.71 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 [29,31,30] · 14.59 ms
SELECT a.id, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute` a WHERE a.id IN (?,?,?,?,?,?,?,?) [2,165,207,537,622,634,635,643] · 1.3 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.78 ms