Опис

Пропоную черенки сортових пеларгоній ,пересилаю новою почтою після оплати на карту,утеплюю. ЛиАПопелюшка 150 Лиа Бомболео 200 Сибирськая роза 180 Cook s Scarlet and White 130 April Snow 100 Rococo130 Jean Caws 120 Just Jipp Deacon Moonlight 130 Platinum 80 Richard Hodgson 120 Vectis Finery 80 Шелк Лебедушка 120 jyvaskyla 100 Jou 130 Pac Salmon Queen 100 Pac Salmon Princesses 120 Pac Salmon comtess100 Pac Viva Corolina 100 Pac Viva Maria 130 Brigstone 80,100 Salmon Picotte 100 Diana Palmer 120 bold minstrel 120 Bold Sunrise 130 Diana Luaise 120 Soren 120 Flaffy-150 ИВ -Скромница 150 ИВ -Олюшка 150 Юзиз Персей 350 Виват Моя Мрія 300 Тамара 100 Something Special 150 Edvards Green eye 120 Pac viva Madeleine 110 Frank Headly 100 J.C.Mrs.Mappin 150 Red Pandora 130 Шелк Аврора 100 Шелк Лагуна 1100 Mariyme 100 Whernside Tribune 120 Flic Flac Red 120 Dovepoint 100 Jagersthing hidingebro Roda 100 Sutarve igor Rosalinda 100 Lake 80 Lara Harmony 130 Morfar 100 Monte Vidio 100 Maverick Star 100 Monica Klauber100 Mrs Salter Bevis 80 кактусная бронь Norland Pink 120 Norland Red 100 Odensjo Rodulvan 120 Odensjo Black Mamba 100 бронь Saxdalens Selma120 Odensjo Vanessa 100 Sutarves Anna Sun 150 Lady Mawis Pilkington 140 Horning Ferry120 Ununges Molly 150 Butterfly Brian West 120 Ив Чардаш 120 Susan Payne 100 Dream Lover 100 Fallen Angel 90 Francis Gibbons 130 Mormor 150 Sister Henry 100 PAC Bergpalais 100 Trumps100 100 Scarlett rambler 90 Jackpot Wild Rose 90 Magnus 100 Jägershus Börre 160 Jägershus Moster Kerstin 300 Jagershus Oslogutten 280 Santa Maria Centennial 100 Ю Диско 130 Ю Полонез 200 Ю Дика Роза 180 Юг Соломея 120 Юг Принцеса Грейс 200 бронь Юг Купина 150 Юг Мурка 120 Юг Нина 200 Юґ Ветер Перемен 120 Hanna Novis 350 кущик Принц Густав 400 бронь Trumps 120 волна Фиeна 120 Brookside Betti 120 Dovedale 120 Kenny's double 100 Bold Beacon 80 Bold Princess 120 Bold Gold 120 Bold Special 80 Bold Carmine 100 Cagolmytin 120 Diameri Scarlet 100 Селеста Джулія 120 Drottining mamarethe 120 Pac Lubo 100 Oh Madreal Rose 200 Edvards Courtney 120 Edwards Romany 80 Frou Frou спорт 120 Grainger's Antique Rose 80 Giekle Parme DZ 100 Elnaryds Miranda 120 HOT SPOT Coral 100 Dovepoint 100 Jagersthing hidingebro Roda 100 Sutarve igor Rosalinda 100 Brookside Miranda 130 Brookside Polka130 Jagershus Falej 180 Gerda 100 Denis Surtave 150 Jinky 120 Aina 120 Лиа Гипноз 300 Лиа Мілфей 200 Лиа Фієста 150 Lovely Very 250 Rococo 120 Mabraska Mare Ardon 130 Eras M. 180 Dulan Gregory 120 Ю Моя Прелесть 200 Blue Spring 130 Сооk's Scarlet and White100 Ирида Майский салют 100 Ирида Клюква в Сахаре150 бронь Ирида Бронзовая Птица 100 Розовая Жемчужина 120 бронь Юг Єсения 130 Ю Джига 100 Ю Мадам Де Помпадур 280 бронь Ю Маршмеллоу 100 Ю Княгиня 350 Ю Сиреневий туман 200 Ю Серин 150 Ирол Колдовской Сапфір 300 Емануель 400 ИВ Королева Бірми 200 Fir Trees Silver Wedding 180 Ом Кружева 180 Kenny's Double 100 'Odensjö Made in Sweden 140 Odensjo Tintomara 120 Odensjö Ljus och Varme 150 Odensjö Poetry in Motion 120 Odensjo Sofia Arden 120 Odensjo Eloise 140 Odensjo stilla Flirt 150 Swainham limelight 100 Odensjo Vanessa 130 Miss Rosa 130 Saga 120 Wendi reed 100 Servivor Idols Rosalinda 120 Highfield's Prime Donna 100 Scarlett rambler 90 Jackpot Wild Rose 90 Magnus 100

Схожі оголошення

OK · 656.2 ms · SQL 13 (41.8 ms) · ES 3 (569.3 ms) · PHP 8.5.12 · 0.8 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 141.1 ms · знайдено 2, повернуто 2
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            47
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 6893
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 207944443
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "data_post": {
                "order": "desc"
            }
        },
        {
            "id": "desc"
        }
    ],
    "from": 0,
    "size": 8,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true
}
POST /abyhomcom/_search → 200 · 117.6 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 207944443
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 310.6 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "city_id": 6893
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    47
                                ]
                            }
                        },
                        {
                            "terms": {
                                "city_id": [
                                    2216,
                                    138,
                                    2217,
                                    2218,
                                    2711,
                                    3357,
                                    3358,
                                    3359,
                                    3360,
                                    3361,
                                    3362,
                                    3363,
                                    3364,
                                    3365,
                                    3366,
                                    3367,
                                    3368,
                                    3369,
                                    3370,
                                    3371,
                                    3372,
                                    3373,
                                    6163,
                                    6342,
                                    6375,
                                    6418,
                                    6435,
                                    6557,
                                    6692,
                                    6712,
                                    6893,
                                    6913,
                                    6962,
                                    7043,
                                    7062,
                                    7129,
                                    7141,
                                    7159,
                                    7199,
                                    7215,
                                    7230,
                                    7286,
                                    7295,
                                    7318,
                                    7319,
                                    7336,
                                    7351,
                                    7360,
                                    7425,
                                    7431,
                                    7506,
                                    7675,
                                    7702,
                                    7724,
                                    7743,
                                    7761,
                                    7810,
                                    7887,
                                    7905,
                                    7949,
                                    7997,
                                    8112,
                                    8126,
                                    8129,
                                    8166,
                                    8202,
                                    8254,
                                    8345,
                                    8391,
                                    8562,
                                    8570,
                                    8599,
                                    8607,
                                    8624,
                                    8693,
                                    8741,
                                    8766,
                                    8795,
                                    8818,
                                    8829,
                                    8861,
                                    8906,
                                    8917,
                                    8961,
                                    8983,
                                    8987,
                                    9015,
                                    9016,
                                    9033,
                                    9088,
                                    9130,
                                    9132,
                                    9190,
                                    9202,
                                    9212,
                                    9227,
                                    9291,
                                    9302,
                                    9326,
                                    9391,
                                    9413,
                                    9463,
                                    9498,
                                    9536,
                                    9597,
                                    9633,
                                    9644,
                                    9671,
                                    9685,
                                    9712,
                                    9747,
                                    9779,
                                    9881,
                                    9906,
                                    9922,
                                    9959,
                                    9960,
                                    9966,
                                    9970,
                                    10034,
                                    10105,
                                    10117,
                                    10121,
                                    10138,
                                    10179,
                                    10226,
                                    10311,
                                    10318,
                                    10334,
                                    10340,
                                    10341,
                                    10360,
                                    10383,
                                    10384,
                                    10403,
                                    10414,
                                    10427,
                                    10447,
                                    10465,
                                    10477,
                                    10486,
                                    10496,
                                    10560,
                                    10589,
                                    10641,
                                    10679,
                                    10741,
                                    10857,
                                    11010,
                                    11027,
                                    11034,
                                    11053,
                                    11055,
                                    11064,
                                    11066,
                                    11097,
                                    11108,
                                    11111,
                                    11142,
                                    11155,
                                    11177,
                                    11180,
                                    11236,
                                    11241,
                                    11250,
                                    11275,
                                    11280,
                                    11306,
                                    11324,
                                    11329,
                                    11342,
                                    11367,
                                    11455,
                                    11459,
                                    11512,
                                    11520,
                                    11541,
                                    11597,
                                    11604,
                                    11650,
                                    11720,
                                    11727,
                                    11745,
                                    11747,
                                    11814,
                                    11889,
                                    11896,
                                    11910,
                                    11918,
                                    11956,
                                    11989,
                                    12038,
                                    12055,
                                    12137,
                                    12144,
                                    12157,
                                    12160,
                                    12163,
                                    12198,
                                    12206,
                                    12231,
                                    12232,
                                    12287,
                                    12341,
                                    12403,
                                    12408,
                                    12441,
                                    12456,
                                    12506,
                                    12509,
                                    12530,
                                    12541,
                                    12543,
                                    12617,
                                    12659,
                                    12675,
                                    12688,
                                    12695
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 1.59 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) [207944443] · 3.87 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 [207944443] · 2.57 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) [212116983,175992708] · 2.9 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 [175992708,212116983] · 7.36 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.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.id IN (?) [6893] · 0.36 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.52 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 (?) [2216] · 0.54 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2216] · 0.34 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [138,2217,2218,2711,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,6163,6342,6375,6418,6435,6557,6692,6712,6893,6913,6962,7043,7062,7129,7141,7159,7199,7215,7230,7286,7295,7318,7319,7336,7351,7360,7425,7431,7506,7675,7702,7724,7743,7761,7810,7887,7905,7949,7997,8112,8126,8129,8166,8202,8254,8345,8391,8562,8570,8599,8607,8624,8693,8741,8766,8795,8818,8829,8861,8906,8917,8961,8983,8987,9015,9016,9033,9088,9130,9132,9190,9202,9212,9227,9291,9302,9326,9391,9413,9463,9498,9536,9597,9633,9644,9671,9685,9712,9747,9779,9881,9906,9922,9959,9960,9966,9970,10034,10105,10117,10121,10138,10179,10226,10311,10318,10334,10340,10341,10360,10383,10384,10403,10414,10427,10447,10465,10477,10486,10496,10560,10589,10641,10679,10741,10857,11010,11027,11034,11053,11055,11064,11066,11097,11108,11111,11142,11155,11177,11180,11236,11241,11250,11275,11280,11306,11324,11329,11342,11367,11455,11459,11512,11520,11541,11597,11604,11650,11720,11727,11745,11747,11814,11889,11896,11910,11918,11956,11989,12038,12055,12137,12144,12157,12160,12163,12198,12206,12231,12232,12287,12341,12403,12408,12441,12456,12506,12509,12530,12541,12543,12617,12659,12675,12688,12695] · 1.59 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [138,2217,2218,3369,3365,3366,6163,6893,7159,3360,3361,3373,11541,3372,6913,6962,7215,7319,7810,7949,10318] · 8.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.parent_id = ? LIMIT 3000 [5] · 11.54 ms