Продати

Tom ford for — Коти

4 оголошення

AMP
Фільтри
4 beautiful bengal kittens for sale
380 ₴
380.0

4 beautiful bengal kittens for sale

4 beautiful bengal kittens for sale The 4 gorgeous boys are still available For sale we have our beautiful litter of 4 bengal kittens looking for their forever homes. We have one girl and three boys in this litter. They have been raised in great conditions with a family including a young child and t…

Київ · 08.02.2026
2 Male Elf Ear Sphynx!!
500 ₴
500.0

2 Male Elf Ear Sphynx!!

I have 2 male Elf Ear Sphynx for sale but the catch is they have to go together. The Black one is Ziggy. He is right around 11 months old. He is SUPER social, when he’s hungry he’ll tell you, when he wants his litter box clean he’ll tell you, and if your laying down, trying to cook, or even just try…

Київ · 06.08.2025
Cute male and female Persian Kittens for sale
368 ₴
368.0

Cute male and female Persian Kittens for sale

Cute male and female Persian Kittens for sale We have two male and one female Persian Kittens available. They are 11 weeks old and have very good temperament, very playful. Kittens are up to date on all their shots and de-worming and come with their health papers and vet records.

Київ · 08.02.2026
Шотландське мармурове кошеня
3 500 ₴
3500.0

Шотландське мармурове кошеня

Продається справжній кото-аристократ від клубних батьків з мармуровим візерунком! Шотландський прямовухий хлопчик, 6 місяців, з окрасом, який можна сплутати з дизайнерським інтер’єром. Колір — чорно-сріблястий мармур з білими «шкарпетками» і підборіддям, як у справжнього джентльмена. Він: • вже вміє…

Київ · 25.11.2025

Схожі запити

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

OK · 78.8 ms · SQL 9 (19.3 ms) · ES 1 (49.9 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

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

Elasticsearch

POST /abyhomcom/_search → 200 · 49.9 ms · знайдено 4, повернуто 4
тіло запиту
{
    "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": [
                            34
                        ]
                    }
                }
            ]
        }
    },
    "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.74 ms
SHOW TABLES · 1.51 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) [202538979,188709549,202539173,197438043] · 3.04 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 [188709549,197438043,202538979,202539173] · 1.65 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.64 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.51 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] · 0.4 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 [34] · 7.5 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.26 ms