Опис

Больше фигурок вы найдете у меня в прифиле

Состояние: очень хорошее, без дефектов
Возможно не большой торг

В наличии есть: Advanced Models, Agents, Animal Crossing, Architecture, Art, Atlantis, Avatar, Batman, Belville, Ben 10: Alien Force, BIONICLE, Bluey, Boost, Botanicals, Brick Sketches, BrickHeadz, Bricks and More, Cars, Castle, City, Classic, Collectible Minifigures, Creator, Creator Expert, DC Super Hero Girls, Dimensions, Dino, Disney, DOTS, DREAMZzz, DUPLO, Education, Elves, Exo-Force, Fabuland, Ferrari, FORMA, Fortnite, Friends, Fusion, Games, Ghostbusters, Harry Potter, Hidden Side, Horizon, Indiana Jones, Ideas, Icons, Jurassic Park, Jurassic World, LEGO Art, LEGO Avatar, LEGO Batman, LEGO City, LEGO Disney, LEGO Education, LEGO Games, LEGO House, LEGO Ideas, LEGO Icons, LEGO Indiana Jones, LEGO Marvel, LEGO Minecraft, LEGO Movie, LEGO NINJAGO, LEGO Originals, LEGO Scooby-Doo, LEGO Sonic the Hedgehog, LEGO Speed Champions, LEGO Star Wars, LEGO Super Mario, LEGO Technic, LEGO The Hobbit, LEGO The Lord of the Rings, LEGO The Simpsons, LEGO Toy Story, LEGO Universe, Legends of Chima, Life on Mars, Lord of the Rings, MINDSTORMS, Minecraft, Minifigures, Modular Buildings, Monster Fighters, Monkie Kid, Mixels, Nexo Knights, NINJAGO, Overwatch, Paradisa, Pharaoh’s Quest, Pirates, Pirates of the Caribbean, Power Miners, Prince of Persia, Promos, Quatro, Racers, Rock Raiders, Scooby-Doo, Seasonal, Shima, Sonic the Hedgehog, Space, Space Police, Speed Champions, Spider-Man, Sports, Star Wars, Stranger Things, Super Heroes, Super Mario, Technic, Teenage Mutant Ninja Turtles, The Angry Birds Movie, The Hobbit, The LEGO Movie, The LEGO NINJAGO Movie, The Lord of the Rings, The Simpsons, The Walking Dead, Time Cruisers, Town, Train, Ultra Agents, Universal Building Set, Vikings, Western, World City, X-Men, Znap. Batman, The LEGO Batman Movie, DC Comics Super Heroes, Superman, Wonder Woman, Justice League, Marvel Super Heroes, Avengers, Spider-Man, Iron Man, Captain America, Thor, Guardians of the Galaxy, Black Panther, X-Men, Deadpool, Venom, Wolverine, Fantastic Four, Ant-Man, Doctor Strange, Black Widow, Shang-Chi, Eternals, Star Wars, The Mandalorian, The Clone Wars, Rebels, The Bad Batch, The Book of Boba Fett, Obi-Wan Kenobi, Andor, Ahsoka, Indiana Jones, Harry Potter, Fantastic Beasts, The Lord of the Rings, The Hobbit, Jurassic Park, Jurassic World, Pirates of the Caribbean, Prince of Persia, Avatar, Avatar: The Way of Water, Back to the Future, Ghostbusters, Stranger Things, The Simpsons, Scooby-Doo, Teenage Mutant Ninja Turtles, Sonic the Hedgehog, Minecraft, Fortnite, Super Mario, Animal Crossing, Pokémon, Overwatch, Horizon, Assassin’s Creed, The Walking Dead, The Angry Birds Movie, Toy Story, Cars, The Incredibles, Minions, Despicable Me, Disney, Pixar, Muppets, Looney Tunes, Winnie-the-Pooh, The Nightmare Before Christmas, The Lord of the Rings, The LEGO Movie, The LEGO Movie 2, The LEGO Ninjago Movie, Ninjago, Monkie Kid, Nexo Knights, Legends of Chima, Bionicle, Hero Factory, Exo-Force, Rock Raiders, Power Miners, Atlantis, Pharaoh’s Quest, Adventurers, Alpha Team, Agents, Ultra Agents, Monster Fighters, Hidden Side, Time Cruisers, Space Police, Galaxy Squad, Life on Mars, Mars Mission, Alien Conquest, Ice Planet, Blacktron, M-Tron, Classic Space, Castle, Knights’ Kingdom, Kingdoms, Pirates, Imperial Soldiers, Vikings, Western, Wild West, Town, World City, City, Train, Racers, Speed Champions, Technic, Creator, Creator Expert, Icons, Architecture, Art, Ideas, BrickHeadz, Mixels, Friends, Elves, Belville, Scala, Dots, Duplo, Quatro, Fabuland, Mindstorms, Boost, Education, Collectible Minifigures.

Минифигурки человечки фигурки фігурки мініфігурки лего ніндзяго ниндзяго

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

OK · 2732.3 ms · SQL 9 (9 ms) · ES 3 (2710.9 ms) · PHP 8.5.12 · 0.8 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 256.9 ms · знайдено 86306, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            17
                        ]
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 215779874
                    }
                }
            ]
        }
    },
    "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 · 157.6 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 215779874
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 2296.4 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "match_all": {}
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    17
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 1.17 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) [215779874] · 1.27 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 [215779874] · 0.55 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) [219250111,219250108,219250105,219250102,219250099,219250096,219250093,219250090] · 1.41 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 [219250090,219250093,219250096,219250099,219250102,219250105,219250108,219250111] · 1.51 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.81 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,127,135,117,125,121,2165,126,116,2166,2101,120,2203,132,128,122,137,133,139,129,138,124,119,140,2107,3092,2167,134,6283,3085] · 0.62 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.85 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.83 ms