Продати

Tom ford for — Тварини, Київ

8 оголошень

AMP
Фільтри
Bitchon Frise puppy for sale
377 ₴
377.0

Bitchon Frise puppy for sale

Bitchon Frise puppy for sale Ready to leave now, we have for sale 3 gorgeous girls n 2 handsome boys one Girl with curly n smooth coats wanting a loving home, playful, loving puppies who love children n family’s.wormed ,fled. These puppies are good for those who have allergies and don’t shed hair ,…

Київ · 06.02.2026
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
adorable Frenchie puppies for sale
600 ₴
600.0

adorable Frenchie puppies for sale

My adorable Frenchie puppies are very active and friendly to other house pets and kids and has gotten all round of shots including deworming parvo and rabies vaccination, AKC registered. Contact for more information Email. Ligakvas@yahoo.com

Київ · 08.05.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
Beautiful English Bulldog Puppies
390 ₴
390.0

Beautiful English Bulldog Puppies

Beautiful English Bulldog Puppies We have 2 beautiful English Bulldog puppies now ready for their forever homes. One boy and one girl left. Puppies have had both vaccinations, microchipped and are wormed up to date. They have been raised in our family home and are well socialised with children and o…

Київ · 06.02.2026
Super red arowana fish and stingray fish for sale
Договірна
0.0

Super red arowana fish and stingray fish for sale

WE SUPPLY BEST QUALITY STINGRAY FISHES LIKE MOTORO FISH, FRESHWATER STINGRAY FISH, FRESHWATER FLORIDA STINGRAY FISH, FRESHWATER HYSTRIX FISH AND AROWANA FISHES OF ALL KINDS LIKE, ASIAN RED AROWANA FISH, SUPER RED AROWANA FISH, RTG AROWANA FISH, CHILI RED AROWANA FISH, GOLDEN RED AROWANA FISH AND MAN…

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

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

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

Київ · 25.11.2025

Схожі запити

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

OK · 352.8 ms · SQL 9 (212.8 ms) · ES 1 (130.1 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

Маршрут: категорія #32 /zhivotnye/, місто city #115 · ES: всього 8, id на сторінці: 8 · знайдено в БД: 8

Elasticsearch

POST /abyhomcom/_search → 200 · 130.1 ms · знайдено 8, повернуто 8
тіло запиту
{
    "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": [
                            32,
                            40,
                            39,
                            38,
                            37,
                            36,
                            35,
                            34,
                            33
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 115
                    }
                }
            ]
        }
    },
    "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 · 3.32 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 ["kiev","\/kiev","kiev\/","\/kiev\/"] · 0.83 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.82 ms
SHOW TABLES · 0.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) [202443695,202538979,188709549,180904021,202539173,202443575,169663921,197438043] · 5.13 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 [169663921,180904021,188709549,197438043,202443575,202443695,202538979,202539173] · 0.61 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.74 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 [32,40,39,38,37,36,35,34,33] · 199.96 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.88 ms