Опис

1.Givenchy Pour Homme Blue Label.
2.Givenchy Pour Homme.
3.Christian Dior Fahrenheit.
4.Penhaligon's The Tragedy of Lord George.
5. Mancera Amore Caffe.
6.Dior Sauvage.
7.Giorgio Armani Acqua di Giò Absolu Instinct.
8.Giorgio Armani Acqua di Gio Pour Homme.
9.Giorgio Armani Emporio Armani Stronger With You.
10.Carolina Herrera 212 Men Eau de Toilette.
11.Versace Man Eau Fraiche.
12.Montale Wood & Spices.
13.Tom Ford Lost Cherry.
14.Ford Tobacco Vanille.
15.Lalique Encre Noire.
16.Creed Aventus.
17.Parfums de Marly Sedley
18.Hugo Boss The Collection Noble Wood
19.Lacoste Eau de Lacoste L.12.12 Blanc.
20.Lacoste Essential Sport.
21.Jean Paul Gaultier Scandal Pour Homme.
22.Paco Rabanne Phantom.
23.Antonio Banderas Blue Seduction for Men.
24.Chanel Allure Homme Sport.
25.Chanel Egoiste Platinum.
26.Zielinski & Rozen Vanilla Blend.
27.Hermes Terre d'Hermes.
28.Chanel Bleu de Chanel.
29. Yves Saint Laurent L'Homme.
30.Moschino Toy Boy.
31.Versace Pour Homme Dylan Blue.
32.Kenzo Pour Homme.
33.Dolce & Gabbana The One For Men.
34.Bvlgari Aqva Pour Homme.
35.Paco Rabanne Invictus.
36.Paco Rabanne 1 Million.
37.Lacoste Essential.
38.Dolce&Gabbana Q by Dolce&Gabbana.
39.Noble Royale L'Imperatrice Gardenia.
40.Armand Basi In Red .
41.Dolce&Gabbana 3 L'Imperatrice.
42.Calvin Klein Euphoria.
43.Marc-Antoine Barrois Ganymede.
44.Attar Collection The Queen of Sheba.
45.Yves Saint Laurent Mon Paris.
46.ArteOlfatto Black Hashish.
47.Dolce & Gabbana The Only One.
48.Tiziana Terenzi Cassiopea.
49.Tiziana Terenzi Kirke.
50.Tiziana Terenzi Ursa.
51.Tiziana Terenzi Casanova.
52.Trussardi Uomo. 
53.Trussardi Donna .
54.Kilian Paris Black Phantom Memento Mori.
55.Givenchy Ange ou Démon Le Secret.
56. Dolce&Gabbana Light Blue.
57.Dolce & Gabbana The One.
58.Kenzo L'Eau par Kenzo.
59.Guerlain Rose Cherie.
60.Creed Millésime Impérial.
61.Viktor & Rolf Flowerbomb Nectar.
62.Dior Miss Dior Blooming Bouquet.
63.Paco Rabanne Fame.
64.Parfums de Marly Delina Exclusif.
65.Nina Ricci.
66.Nina Ricci Bella.
67.Acqua di Parma Blu Mediterraneo Mirto di Panarea.
68.Lancôme Trésor Midnight Rose.
69.Giorgio Armani Acqua di Gioia.
70.Donna Karan DKNY Be Delicious.
71.Xerjoff Casamorati 1888 Lira.
72.Xerjoff Casamorati 1888 Bouquet Ideale.
73.Xerjoff Casamorati 1888.
74.Gucci Guilty.
75.Giorgio Armani My Way.
76.Escentric Molecules Escentric 05.
77.Escentric Molecules Molecule 02.
78.Escentric Molecules Molecule 05.
79.Yves Saint Laurent Black Opium.
80.Moschino Toy 2 Bubble Gum.
81.Maison Francis Kurkdjian Baccarat Rouge 540 Extrait
82.Tom Ford Metallique.
83.Tom Ford Private Blend Neroli Portofino.
84.Lanvin Modern Princess.
85.Lanvin Eclat d'Arpège.
86.Victoria's Secret Bombshell Celebration.
87.Victoria's Secret Bombshell Summer.
88.Victoria's Secret Crush.
89.Victoria's Secret Bombshell.
90.Versace Versense.
91.Versace Eros Pour Femme.
92.Versace Bright Crystal.
93.Versace Bright Crystal Absolu.
94.Chanel Chance Eau Fraiche.
95.Chanel Chance Eau Tendre.
96.By Kilian Do It For Love.
97.Kilian Forbidden Games.
98.Kilian Good Girl Gone Bad Extreme.
99.Kilian Intoxicated.
100.Attar Collection, модель Musk Kashmir.
101.Hayati Attar Collection.
102.Giorgio Armani Si.
103.Moschino Funny.
104.Lacoste Eau de Lacoste L.12.12 Pour Elle Sparkling.
105.Chanel Coco Mademoiselle.
106.Paco Rabanne Lady Million.
107.Paco Rabanne Olympea.
108.Chanel Gabrielle.
109.Christian Dior J'adore.
110.Sospiro Perfumes Accento.
111.Lacoste Pour Femme.
112.Kilian Angels' Share.
113.Tom Ford Black Orchid.
114.Paco Rabanne 1 Million Lucky.
115.Versace Pour Homme.
116.Nasomatto Black Afgano.
117.Armand Basi In Blue.
118.Montale Golden Sand.
119.Dsquared2 He Wood.
120.Jean Paul Gaultier Le Beau.
121.Paco Rabanne Pure XS Night.
122.Hugo Boss Boss Bottled Tonic.
123.Carolina Herrera Bad Boy.

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

OK · 1683.5 ms · SQL 10 (243.2 ms) · ES 3 (1429.3 ms) · PHP 8.5.12 · 0.8 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 15.9 ms · знайдено 10, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            84
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 3505
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 204373871
                    }
                }
            ]
        }
    },
    "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 · 8.1 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 204373871
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 1405.3 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "city_id": 3505
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    84
                                ]
                            }
                        },
                        {
                            "term": {
                                "region": 2198
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        },
        "by_region": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    84
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "region",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 1.5 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) [204373871] · 78.91 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 [204373871] · 1.66 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) [197863733,197190227,197140707,196990552,196894939,195076007,194635511,192543202] · 157.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 [192543202,194635511,195076007,196894939,196990552,197140707,197190227,197863733] · 1.7 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.45 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 (?) [3505] · 0.34 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.41 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 (?) [2198] · 0.29 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.65 ms