Продати

Tom ford out — Тварини

7 оголошень

AMP
Фільтри
4 scottish 2 Fold, 2 Straight, 2 Gold, 2 Silver
300 ₴
300.0

4 scottish 2 Fold, 2 Straight, 2 Gold, 2 Silver

4 SCOTTISH 2 Fold, 2 Straight, 2 Gold, 2 Silver 4 cute kittens out of 5 All BOYS 2 FOLD (1 GOLD, 1 SILVER) £800 2 STRAIGHT (1 GOLD 1 SILVER Dad Scottish gold straight Mum British Blue Straight Both parent are Pedigree - I put extremely many efforts to provide all kittens neat, tidy and joyful surrou…

Київ · 08.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
Продам Той Пуделя
15 000 ₴
15000.0

Продам Той Пуделя

Продам той пуделя. Хлопчик, 2 місяці. Грайливе та активне цуценя. Народився 5.04.2025 року. Тато ред 28 см в холці, мама абрикос 26 см в холці. Хлопчик привчений до пелюшок ! Вага дорослих буде 4-5 кг. На момент переїзду будуть мати вакцинації та обробки по віку ! Пишіть на вайбер або телеграм бо мо…

Кременчук · 08.06.2025
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
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
Super red arowana fish and stingray fish for sale
8 425 ₴
8425.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…

Вінниця · 19.01.2025

Схожі запити

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

OK · 1478.9 ms · SQL 9 (1390.4 ms) · ES 1 (38.6 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

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

Elasticsearch

POST /abyhomcom/_search → 200 · 38.6 ms · знайдено 7, повернуто 7
тіло запиту
{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "tom ford out",
                        "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
                        ]
                    }
                }
            ]
        }
    },
    "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 · 10.2 ms
SHOW TABLES · 1.54 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) [202539107,202538979,183420804,188709549,202443575,169663921,169506973] · 2.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 [169506973,169663921,183420804,188709549,202443575,202538979,202539107] · 0.82 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 12.33 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] · 4.77 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,116,2107] · 13.92 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] · 1337.93 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] · 6.87 ms