Опис

OLX Доставка за домовленістю.

Дивиться інші мої оголошення

Tелеграм Канал Nose_garage:
t.me/+SsybkAt5z-tlODEy

Фото №1:
Volvo 240 Drift Camper - 600₴
Porsche 935 - 300₴
1971 Porsche 911 - 350₴
Porsche Panamera Orange Dollar General Exclusive - 200₴
Porsche 911 GT3 CUP First Editions - 250₴
Porsche 904 - 110₴
96 Porsche Carrera - 120₴
Porsche 914 Safari - 150₴
Audi RS E-Tron GT Red - 150₴

Фото №2:
2008 Hot Wheels Tesla Roadster Red - 400₴
Lancia Stratos #037 - 200₴
Pagani Huayra Gran Turismo - 150₴
Aston Martin 1963 DB5 Green - 200₴
'67 Chevelle SS 396 Disney Pixar - 200₴
2009 70 Chevelle SS Wagon - 225₴
Chevy Nomad #502 Red - 150₴
Chevy Nomad #106 Orange - 150₴

Фото №3:
C-3PO Star Wars - 400₴
Volkswagen Hauler Custom Blue CGJ45 - 350₴
Volkswagen Baja Bug Green сіра/зелена HCX74 - 125₴
Volkswagen Baja Bug Blue голуба HCW52 - 125₴
Volkswagen SP2 Red 2019 FYF71 - 200₴
2003 First Editions Meyers Manx - 225₴
2018 Morris Mini Nightburnerz - 200₴
'67 Austin Mini Van 54th Anniversary Pearl & Chrome - 200₴

Фото №4:
1998 Mazda MX-5 Miata Sugar Rush #741 - 350₴
2017 Mazda RX-7 Then and Now - 200₴
Datsun Fairlady 2000 Blue and Pink #54 - 200₴
Custom '01 Acura Integra GSR White - 200₴
94 Toyota Supra Tooned Fast & Furious - 110₴
Liberty Walk GT Nissan 35GT-RR Ver.2 - 130₴
Toyota Off-Road truck - 150₴
Fairlady 2000 Fifteen Black - 175₴
Fairlady 2000 Fifteen Blue - 175₴
Fairlady 2000 Legends of Speed Yellow - 150₴

Фото №5:
1995 '58 Corvette Coupe Purple #341 - 250₴
1995 '58 Corvette Coupe Pink - 250₴
1996 Silver Series II '57 Chevy Chrome - 150₴
Corvette Convertible Tropicool Series #696 - 200₴
Custom 66 GTO Wagon Hot Wagons - 200₴
Chevy Monte Carlo Concept Car #087 - 200₴
'52 Chevy Rod Squad - 200₴
‘67 Pontiac GTO Tiger #226 - 225₴
2005 First Editions 1969 Pontiac Firebird T/A - 200₴

Фото №6:
1991 '40'S Woodie #217 Green/Black - 250₴
Armored Car Black #185 - 225₴
1998 Ice Cream Truck Black Label #693 - 250₴
2015 Super Van Red - 250₴
2015 Bread Box HW City - 250₴
82 Dodge Rampage Red - 120₴
'70 Dodge Power Wagon Yellow - 150₴
2020 RAM 1500 Rebel Green - 150₴
2007 Dodge Power Wagon Green - 225₴
2011 Dodge Charger Drift Red - 250₴
2001 Dodge Sidewinder #088 - 200₴

Фото №7:
1970 Ford Escort RS1600 Brian O'Conner - 120₴
Ford GT-40 Black - 150₴
2016 Ford GT Race Silver - 150₴
08 Ford Focus Cult Racers Red - 200₴
69 Ford Mustang Boss 302 Falken - 150₴
2005 Ford Mustang Dream Garage Green - 150₴
1998 Ford Mustang Mach 1 First Edition #670 - 225₴
Custom '56 Ford Truck - 150₴
2000 '33 Ford Roadster #8 Green Hot Rod - 150₴
2000 Deuce Roadster Silver First Editions - 200₴
2001 Deuce Roadster #195 - 200₴
1999 Phantom Corsair First Editions - 200₴
2001 Old #3 First Editions Red - 150₴
1999 Track T First Editions - 150₴

Фото №8:
Batman Forever Batmobile Black - 150₴
The Batman Batmobile Siver - 150₴
Batman Batplane - 150₴
Star Wars X-34 Landspeeder - 120₴
1991 Swingfire #214 - 200₴
2004 Classics Series 1 T-Bucket #24 Blue - 325₴
Canyon Carver Dream Garage - 175₴
Whatta Drag #213 - 150₴
Twin Mill 55th Anniversary - 70₴
2011 Blvd. Bruiser Purple - 200₴
Avant Garde - 200₴

---

Solido
BMC BM Creations
Tarmac
Schuco
Hot Wheels
Matchbox
Majorette
GreenLight
ERA CAR
Auto World
Johnny Lightning
SIKU
Corgi
Dinky
Машинки
Bburago
New ray
Altaya
Vanguards
Abrex
Norev
Cararama Hongwell
Racing Champions
Nascar
Yatming Road Signature

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

OK · 920.9 ms · SQL 13 (127.6 ms) · ES 3 (761.1 ms) · PHP 8.5.12 · 0.9 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 103.5 ms · знайдено 6007, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            77
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 127
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 174497623
                    }
                }
            ]
        }
    },
    "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 · 70.1 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 174497623
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 587.5 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "city_id": 127
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    77
                                ]
                            }
                        },
                        {
                            "terms": {
                                "city_id": [
                                    2188,
                                    127,
                                    2189,
                                    2190,
                                    2191,
                                    3153,
                                    3154,
                                    3155,
                                    3156,
                                    3157,
                                    3158,
                                    3159,
                                    3160,
                                    3161,
                                    3162,
                                    3163,
                                    3164,
                                    3165,
                                    3166,
                                    3168,
                                    3169,
                                    3170,
                                    3171,
                                    3172,
                                    3173,
                                    3174,
                                    3175,
                                    3176,
                                    3177,
                                    3638,
                                    3650,
                                    6057,
                                    6131,
                                    6168,
                                    6171,
                                    6181,
                                    6185,
                                    6196,
                                    6204,
                                    6243,
                                    6259,
                                    6262,
                                    6281,
                                    6287,
                                    6296,
                                    6318,
                                    6349,
                                    6380,
                                    6383,
                                    6393,
                                    6470,
                                    6531,
                                    6545,
                                    6556,
                                    6628,
                                    6647,
                                    6682,
                                    6704,
                                    6756,
                                    6758,
                                    6784,
                                    6862,
                                    6953,
                                    6995,
                                    7015,
                                    7021,
                                    7030,
                                    7040,
                                    7077,
                                    7114,
                                    7138,
                                    7146,
                                    7175,
                                    7186,
                                    7197,
                                    7202,
                                    7207,
                                    7263,
                                    7303,
                                    7304,
                                    7314,
                                    7366,
                                    7417,
                                    7445,
                                    7475,
                                    7503,
                                    7533,
                                    7558,
                                    7677,
                                    7732,
                                    7760,
                                    7795,
                                    7845,
                                    7851,
                                    7943,
                                    7975,
                                    8034,
                                    8061,
                                    8093,
                                    8101,
                                    8172,
                                    8214,
                                    8235,
                                    8251,
                                    8270,
                                    8297,
                                    8330,
                                    8393,
                                    8582,
                                    8664,
                                    8689,
                                    8720,
                                    8852,
                                    8960,
                                    8972,
                                    8996,
                                    9079,
                                    9138,
                                    9141,
                                    9183,
                                    9215,
                                    9229,
                                    9246,
                                    9250,
                                    9300,
                                    9337,
                                    9424,
                                    9508,
                                    9520,
                                    9616,
                                    9701,
                                    9808,
                                    9813,
                                    9885,
                                    9925,
                                    9943,
                                    9971,
                                    9997,
                                    10103,
                                    10118,
                                    10308,
                                    10353,
                                    10362,
                                    10368,
                                    10371,
                                    10441,
                                    10559,
                                    10561,
                                    10669,
                                    10698,
                                    10783,
                                    10812,
                                    10868,
                                    10965,
                                    10994,
                                    11056,
                                    11096,
                                    11119,
                                    11149,
                                    11207,
                                    11270,
                                    11272,
                                    11277,
                                    11347,
                                    11379,
                                    11436,
                                    11462,
                                    11473,
                                    11496,
                                    11551,
                                    11559,
                                    11578,
                                    11592,
                                    11624,
                                    11635,
                                    11691,
                                    11698,
                                    11706,
                                    11803,
                                    11820,
                                    11825,
                                    11903,
                                    11992,
                                    12011,
                                    12097,
                                    12209,
                                    12243,
                                    12275,
                                    12293,
                                    12350,
                                    12436,
                                    12444,
                                    12472,
                                    12504,
                                    12528,
                                    12535,
                                    12538,
                                    12558,
                                    12572,
                                    12604,
                                    12633,
                                    12637,
                                    12665,
                                    12677
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 10.79 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) [174497623] · 2.42 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 [174497623] · 1.12 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) [219438070,219437830,219437758,219437689,219437665,219437662,219437602,219437587] · 2.33 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 [219437587,219437602,219437662,219437665,219437689,219437758,219437830,219438070] · 1.09 ms
SELECT c.* FROM `category` c ORDER BY c.id · 101.75 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 (?) [127] · 0.72 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.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 (?) [2188] · 0.44 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2188] · 0.35 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [127,2189,2190,2191,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3638,3650,6057,6131,6168,6171,6181,6185,6196,6204,6243,6259,6262,6281,6287,6296,6318,6349,6380,6383,6393,6470,6531,6545,6556,6628,6647,6682,6704,6756,6758,6784,6862,6953,6995,7015,7021,7030,7040,7077,7114,7138,7146,7175,7186,7197,7202,7207,7263,7303,7304,7314,7366,7417,7445,7475,7503,7533,7558,7677,7732,7760,7795,7845,7851,7943,7975,8034,8061,8093,8101,8172,8214,8235,8251,8270,8297,8330,8393,8582,8664,8689,8720,8852,8960,8972,8996,9079,9138,9141,9183,9215,9229,9246,9250,9300,9337,9424,9508,9520,9616,9701,9808,9813,9885,9925,9943,9971,9997,10103,10118,10308,10353,10362,10368,10371,10441,10559,10561,10669,10698,10783,10812,10868,10965,10994,11056,11096,11119,11149,11207,11270,11272,11277,11347,11379,11436,11462,11473,11496,11551,11559,11578,11592,11624,11635,11691,11698,11706,11803,11820,11825,11903,11992,12011,12097,12209,12243,12275,12293,12350,12436,12444,12472,12504,12528,12535,12538,12558,12572,12604,12633,12637,12665,12677] · 2.56 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [127,2191,2190,2189,6171,6131,3156,3169,6168,3154,3171,3650,3158,6196,6470,6349,3155,3168,3172,6185,9616,6296,3159,6243,6393,6281,6556,7040,6756,9813] · 1.19 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.35 ms