Опис

Компютер має дуже гарний стан.
SSD диск Kingston SSDNow A400 120GB 2.5" SATAIII

Жорсткий диск Western Digital Red Plus 2TB 5400rpm 64МB WD20EFRX 3.5 SATA III

Оперативна пам'ять HyperX DDR4-4000 16384MB PC4-32000 (Kit of 2x8192) Predator RGB (HX440C19PB3AK2/16)

Монітор 34" LG UltraGear 34UC79G-B 2560х1080

Відеокарта Gigabyte PCI-Ex GeForce RTX 2080 Aorus Xtreme 8GB GDDR6 (256bit)

Материнська плата Asus ROG Strix Z490-E Gaming (s1200, Intel Z490, PCI-Ex16)

Процесор Intel Core i7-10700K 3.8GHz / 16MB (BX8070110700K) s1200 BOX

SSD диск Samsung 970 Evo Plus 250GB M.2 PCIe 3.0 x4 V-NAND MLC (MZ-V7S250BW)

Жорсткий диск Western Digital Red 2TB 5400rpm 256MB WD20EFAX 3.5" SATA III

Блок живлення Seasonic Prime Ultra Gold SSR-850GD Ultra 850W

Дивіться будь-ласка всі мої оголошення.

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

OK · 1130.2 ms · SQL 9 (40.3 ms) · ES 3 (1070.3 ms) · PHP 8.5.12 · 0.8 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 53.2 ms · знайдено 55962, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            56
                        ]
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 211958445
                    }
                }
            ]
        }
    },
    "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 · 63.5 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 211958445
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 953.6 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": [
                                    56
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 2.29 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) [211958445] · 2.53 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 [211958445] · 28.48 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) [219279052,219279049,219279046,219279043,219279040,219279037,219279034,219279031] · 0.69 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 [219279031,219279034,219279037,219279040,219279043,219279046,219279049,219279052] · 0.58 ms
SELECT c.* FROM `category` c ORDER BY c.id · 2.63 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,135,125,127,117,120,121,116,124,2101,126,132,129,119,133,128,138,137,139,140,122,2107,2165,134,3092,6283,2167,6334,3085,6214] · 1.16 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.43 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] · 1.49 ms