Опис

Deadmau5 – 4x4=12

Matrix / Runout: 9190612 AA21159-01 manufactured by optimal media production
Mastering SID Code: ifpi L573
Mould SID Code: IFPI 9727
Barcode: 50*****906120
Made in E.U.
Condition: M / M-

Каталог фірмових CD
(в наявності)

Частина 2

Dead Can Dance – Spleen and Ideal (1985, U.K.)
– Within The Realm Of A Dying Sun (1987, U.K.)
– The Serpent's Egg (1988, U.S.A.)
– Aion (1990, U.K.)
– Into The Labyrinth (1993, U.K. / U.S.A.)
– A Passage In Time (1993, U.K. / U.S.A.)
– Toward The Within (1994, U.S.A.)
– Spiritchaser (1996, U.S.A.)
– Dead Can Dance • Garden Of The Arcane Delights (2008, U.S.A.)
– Anastasis (2012, U.K.)
– Dionysus (2016, E.U.)
Deadmau5 – 4x4=12 (2010, E.U.)
Dear Mr. President – Dear Mr. President (1988, U.S.A.)
Def Leppard – Hysteria (1987, E.U.)
Deftones – Adrenaline (1995, E.U.)
– Around The Fur (1997, E.U.)
– White Pony (2000, E.U.)
– Deftones (2003, E.U.)
– Diamond Eyes (2010, E.U.)
– Koi No Yokan (2012, E.U.)
Demi Lovato – Confident (2015, E.U.)
Depeche Mode ‎– Speak & Spell (1981, France / 2006, E.U.)
– Construction Time Again (1983, France / Germany)
– Some Great Reward (1984, U.S.A.)
– People Are People (1984, U.S.A.)
– Catching Up With DM (1985, U.S.A.)
– Black Celebration (1986, U.S.A.)
– Music For The Masses (1987, Germany / U.S.A.)
– 101 / Disc A + B / 2 CD (1989, E.U. / Holland / U.S.A.)
– Violator (1990, E.U. / U.S.A.)
– World In My Eyes (1990, U.S.A.)
– Behind The Wheel (1992, U.S.A.)
– Songs Of Faith And Devotion (1993, U.S.A.)
– I Feel You ( 1993, U.S.A.)
– Walking In My Shoes (1993, Germany)
– Songs Of Faith And Devotion / Live (1993, Germany / U.K.)
– Ultra (1997, Canada / Benelux / U.S.A.)
– Barrel Of A Gun (1997, Germany / U.K.)
– It's No Good (1997, U.K.)
– Home (1997, U.K.)
– Only When I Lose Myself (1998, U.K.)
– The Singles 81 - 85 (1998, U.S.A.)
– Exciter (2001, E.U. / U.S.A.)
– I Feel Loved (2001, U.K.)
– Dream On (2001, U.K.)
– Freelove (2001, U.K.)
– The Singles 81 - 98 / 3 CD Box (2001, E.U.)
– Remixes 81 - 98 / 3 CD Box (2001, E.U.)
– Remixes 81 - 04 / 2 CD (2004, E.U.)
– Remixes 81 - 04 / 3 CD Box (2004, U.K.)
– The Singles 86 - 98 / 2 CD (2004, France / U.S.A.)
– Playing the Angel (2005, E.U. / U.S.A.)
– The Best Of / Volume 1 (2009, E.U.)
– Tour Of The Universe: Barcelona / 2 CD + 2 DVD (2010, U.K.)
– Delta Machine (2013, E.U.)
– Spirit / CD / 2 CD (2017, E.U.)
– Spirits in the Forest / 2 CD + 2 DVD (2020, Germany)
– Memento Mori (2023, U.S.A.)
Blasphemous Rumours – An Electronic Tribute To Depeche Mode (2002, U.K.)
Dido – No Angel (1999, U.S.A.)
– Life For Rent (2003, U.S.A.)
– Safe Trip Home (2008, E.U.)
– Girl Who Got Away (2013, U.K.)
– Still On My Mind (2019, E.U.)
Dio – Holy Diver (1983, E.U.)
Dire Straits – Communiqué (1979, Germany)
– Making Movies (1980, France)
– Money For Nothing (1988, E.U. / U.S.A.)
– Brothers In Arms (1995, E.U.)
Dream Command – Fire On The Moon (1990, Germany)
Dua Lipa – Dua Lipa (2017, U.K.)
– Future Nostalgia (2020, E.U.)
Dub Tractor – Delay (2000, Denmark)
Duran Duran – Duran Duran (1981, Japan / 2003, U.S.A.)
– Rio (1982, 1994 E.U.)
– Arena (1984, U.S.A.)
– Decade (1989, U.S.A.)
– Duran Duran (1993, U.S.A.)
– Electric Barbarella ( 1997, U.S.A.)
– Greatest (1998, E.U.)
– Astronaut (2004, E.U.)

Eagles – Hotel California (1976, E.U. / Germany)
– Their Greatest Hits 197********1976, E.U. / U.S.A.)
Earl Sweatshirt – Doris (2013, E.U.)
Earth Wind & Fire – Touch the World ( 1987, Austria)
Eilish, Billie – Dont Smile At Me (2019, U.S.A.)
– Happier Than Ever (2021, U.S.A.)
Elbow – Cast Of Thousands / CD + DVD (2003, U.K.)
Electric Light Orchestra – Secret Messages (1983, E.U.)
– Light Years: The Very Best Of ELO ‎ (1997, E.U.)
– All Over The World (2005, E.U.)
Emerson Lake & Palmer – Emerson Lake & Palmer (2001, U.K.)
Eminem – The Marshall Mathers LP (2000, U.K.)
– The Eminem Show (2002, E.U. / U.S.A.)
– Encore (2004, E.U.)
– Relapse (2009, E.U.)
– Recovery (2010, E.U.)
– The Marshall Mathers LP2 (2013, E.U.)
– Revival (2017, E.U.)
Enigma – The Cross Of Changes (1993, U.S.A.)
– Le Roi Est Mort, Vive Le Roi! (1996, E.U.)
– Love Sensuality Devotion: The Greatest Hits (2001, U.S.A.)
Eno, Brian – Another Green World ( 1975, U.K.)
– Nerve Net (1992, U.S.A.)
Eno, Brian With Daniel Lanois & Roger Eno – Apollo (1994, E.U. / U.S.A.)
Eno, Brian + David Byrne – My Life In The Bush Of Ghosts (2005, E.U.)
– Before And After Science (2009, E.U.)
Enya ‎– Enya (1992, U.S.A.)
– Paint The Sky With Stars - The Best Of Enya (1997, U.S.A.)
Erasure – Wild! (1989, U.S.A.)
Esthetic Education ‎– Leave Us Alone / Machine (2005, Ukraine)
Evanescence – Fallen (2002, E.U. / U.S.A.)
– Evanescence (2011, E.U.)

Falco – Helden Von Heute (2001, E.U.)
Ferry, Bryan – Dylanesque (2007, E.U.)
Ferry, Bryan + Roxy Music – The Platinum Collection / 3 CD (2004, E.U.)
Fields Of The Nephilim – Dawnrazor (1987, Germany)
– Revelations / 2 CD (1993, U.K.)
– Fallen / 2 CD (2002, U.K.)
– From The Fire (2002, Germany)
Fish – Vigil in a Wilderness of Mirrors (1990, U.K.)
– Songs From The Mirror (1993, E.U.)
FKA Twigs – LP1 (2014, U.K. / U.S.A.)
Fleetwood Mac – Greatest Hits (1988, E.U.)
– Behind The Mask (1995, U.S.A.)
Florence + The Machine – Lungs (2009, U.K.)
– Between Two Lungs / 2 CD (2010, E.U.)
– Ceremonials / CD, 2 CD (2011, E.U.)
– How Big, How Blue, How Beautiful (2015, E.U. / Australasia)
– High As Hope (2018, E.U.)
Foals – Antidotes (2008, U.K.)
– Total Life Forever (2010, U.K.)
– Holy Fire / CD + DVD (2013, E.U.)
– What Went Down (2015, E.U.)
– Everything Not Saved Will Be Lost, Pt. 1 + Pt. 2 (2019, U.K.)
– Life Is Yours (2022, Germany)
Foreigner – 4 (1981, Germany)
– Agent Provocateur (1984, Germany)
Four Tet – Rounds (2003, U.K.)
Frank Black ‎– The Live EP (1996, E.U.)
Frankie Goes To Hollywood – Bang! The Greatest Hits (1993, Germany / U.K.)
Freewheelers, The ‎– Little Miss Fortune (1991, U.S.A.)
– No More Booze (1991, U.S.A.)
Frishberg, Dave – Classics (1991, U.S.A.)
Front 242 – 05:22:09:12 Off (1993, Austria)
– 06:21:03:11 Up Evil (1993, U.S.A.)
Future Islands – Singles (2014, U.K.)
– As Long As You Are (2020, U.K.)
Future Sound Of London, The – Lifeforms / 2 CD (1994, U.K.)
– ISDN (1995, Holland / U.K.)
– The Isness (2002, U.S.A.)
– Accelerator (2016, U.K.)

Gabriel, Peter – Us (1992, U.K. / U.S.A.)
‎– Up (1990, U.S.A.)
– Shaking The Tree - Sixteen Golden Greats (1990, U.S.A.)
– Passion (1989, U.S.A. / Canada)
– OVO (2000, E.U.)
– So (2002, E.U. / U.S.A.)
– Scratch My Back (2010, E.U.)
Gahan, Dave ‎– Paper Monsters / CD + DVD (2003, E.U. / U.S.A.)
– Hourglass / CD + DVD (2007, E.U.)
Gahan, Dave & Soulsavers – Angels and Ghosts (2015, E.U.)
– Imposter (2021, E.U.)
Gallagher, Liam – As You Were (2017, E.U.)
Garbage – Version 2.0 (1998, U.S.A.)
Gardot, Melody – Worrisome Heart (2008, E.U.)
– My One And Only Thrill (2009, E.U.)
– The Absence (2012, E.U.)
– Currency Of Man (2015, E.U.)
– Sunset In The Blue (2020, E.U.)
Geesin, Ron & Roger Waters – Music From The Body (1970, U.S.A.)
Genesis – Selling England By The Pound (1986, U.K.)
– We Can't Dance (1991, E.U. / U.S.A.)
Gerrard, Lisa – The Mirror Pool (1995, U.K.)
Gerrard, Lisa & Pieter Bourke ‎– Duality (1998, U.K. / U.S.A.)
Gerrard, Lisa & Patrick Cassady – Immortal Memory (2004, U.K.)
Glass Animals – Zaba (2014, U.K.)
Gilmour, David – Live In Gdańsk / 2 CD + DVD (2008, E.U.)
Glass, Phillip – Solo Piano (1989, E.U.)
God Machine, The – Scenes from the Second Storey (1993, U.S.A.)
Goldfrapp – Black Cherry (2003, E.U. / U.S.A.)
– Felt Mountain ( 2000, U.S.A.)
– Supernature (2005, E.U.)
González, José – Veneer (2005, U.K.)
Good, The Bad, The Queen,The – The Good (2007, E.U.)
– Merrie Land / CD + Hardbook (2018, U.K.)
Gore, Martin L. – Counterfeit E.P (1989, Holland / U.K. / U.S.A.)
– Counterfeit² (2003, E.U. / U.S.A.)
– MG (2015, U.K.)
Gorillaz – Gorillaz (2001, E.U.)
– G Sides (2001, U.K.)
– Demon Days (2005, E.U.)
– D-sides / 2 CD (2007, E.U.)
– The Fall (2011, E.U.)
– Plastic Beach / CD, CD + DVD (2014, E.U.)
– Humanz (2017, E.U.)
– The Now Now (2018, E.U.)
Groove Armada – Vertigo (1999, E.U. / U.S.A.)

Hammill, Peter – In Camera (1974, E.U.)
– The Love Songs (1984, U.K.)
– Fireships (1992, Germany)
Hancock, Herbie – Perfect Machine (1988, Austria)
Hard-Fi ‎– Stars Of CCTV (2006, U.S.A.)
Harket, Morten – Out Of My Hands (2012, E.U.)
Hollis, Mark – Mark Hollis (1998, U.K.)
Holst / John Williams – The Planets / Star Wars Suite (2011, E.U.)
Hooverphonic – A New Stereophonic Sound Spectacular (1996, U.S.A.)
– Blue Wonder Power Milk (1998, U.S.A.)
– The Magnificent Tree (2000, E.U.)

* Початок каталогу в Частині 1, закінчення в Частині 3-5

* Усі опубліковані фото реальні і виключно власних компакт-дисків

* Асортимент регулярно оновлюється та поповнюється

* Кожному зацікавленому - каталог із понад 1000 наявними CD

* Можливість замовлення практично будь-якого компакт-диска або вінілу

* Повний асортимент – у Telegram-спільноті cd4people

* OLX доставка за умови, що покупець покриває комісію, яку OLX утримує з продажу

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

OK · 442.5 ms · SQL 13 (16.4 ms) · ES 3 (406.5 ms) · PHP 8.5.12 · 1.1 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 49.3 ms · знайдено 4988, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            77
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 125
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 202317463
                    }
                }
            ]
        }
    },
    "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 · 40 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 202317463
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 317.2 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "city_id": 125
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    77
                                ]
                            }
                        },
                        {
                            "terms": {
                                "city_id": [
                                    2180,
                                    125,
                                    2181,
                                    2183,
                                    2184,
                                    2714,
                                    3178,
                                    3179,
                                    3180,
                                    3181,
                                    3182,
                                    3183,
                                    3184,
                                    3185,
                                    3186,
                                    3187,
                                    3188,
                                    3189,
                                    3190,
                                    3191,
                                    3192,
                                    3193,
                                    3194,
                                    3195,
                                    3196,
                                    3197,
                                    3198,
                                    3199,
                                    3200,
                                    3622,
                                    3632,
                                    3635,
                                    3637,
                                    3640,
                                    3643,
                                    3651,
                                    3653,
                                    3656,
                                    6148,
                                    6150,
                                    6159,
                                    6201,
                                    6203,
                                    6211,
                                    6213,
                                    6219,
                                    6248,
                                    6252,
                                    6254,
                                    6273,
                                    6290,
                                    6298,
                                    6303,
                                    6324,
                                    6372,
                                    6420,
                                    6467,
                                    6489,
                                    6501,
                                    6513,
                                    6514,
                                    6515,
                                    6534,
                                    6540,
                                    6555,
                                    6574,
                                    6597,
                                    6605,
                                    6642,
                                    6650,
                                    6659,
                                    6662,
                                    6677,
                                    6678,
                                    6754,
                                    6757,
                                    6768,
                                    6786,
                                    6808,
                                    6823,
                                    6861,
                                    6888,
                                    6901,
                                    6902,
                                    6936,
                                    6951,
                                    6961,
                                    6972,
                                    6976,
                                    6982,
                                    6989,
                                    7002,
                                    7033,
                                    7036,
                                    7041,
                                    7048,
                                    7071,
                                    7073,
                                    7098,
                                    7107,
                                    7134,
                                    7139,
                                    7158,
                                    7164,
                                    7169,
                                    7176,
                                    7178,
                                    7191,
                                    7200,
                                    7251,
                                    7275,
                                    7290,
                                    7301,
                                    7328,
                                    7334,
                                    7344,
                                    7397,
                                    7418,
                                    7433,
                                    7434,
                                    7446,
                                    7459,
                                    7483,
                                    7485,
                                    7496,
                                    7499,
                                    7500,
                                    7517,
                                    7529,
                                    7544,
                                    7548,
                                    7559,
                                    7578,
                                    7590,
                                    7607,
                                    7642,
                                    7645,
                                    7655,
                                    7664,
                                    7687,
                                    7694,
                                    7706,
                                    7735,
                                    7748,
                                    7757,
                                    7764,
                                    7774,
                                    7776,
                                    7799,
                                    7803,
                                    7813,
                                    7817,
                                    7820,
                                    7830,
                                    7837,
                                    7850,
                                    7854,
                                    7874,
                                    7882,
                                    7885,
                                    7891,
                                    7902,
                                    7908,
                                    7935,
                                    7979,
                                    7987,
                                    7990,
                                    8015,
                                    8047,
                                    8065,
                                    8073,
                                    8075,
                                    8082,
                                    8105,
                                    8107,
                                    8111,
                                    8125,
                                    8134,
                                    8143,
                                    8147,
                                    8155,
                                    8162,
                                    8163,
                                    8184,
                                    8193,
                                    8211,
                                    8222,
                                    8223,
                                    8225,
                                    8237,
                                    8240,
                                    8241,
                                    8263,
                                    8288,
                                    8300,
                                    8301,
                                    8315,
                                    8316,
                                    8333,
                                    8366,
                                    8390,
                                    8412,
                                    8519,
                                    8550,
                                    8564,
                                    8568,
                                    8579,
                                    8601,
                                    8609,
                                    8628,
                                    8663,
                                    8678,
                                    8690,
                                    8713,
                                    8716,
                                    8747,
                                    8750,
                                    8761,
                                    8784,
                                    8803,
                                    8812,
                                    8815,
                                    8822,
                                    8824,
                                    8833,
                                    8867,
                                    8908,
                                    8925,
                                    8937,
                                    8939,
                                    8951,
                                    8956,
                                    8958,
                                    8964,
                                    8975,
                                    9009,
                                    9023,
                                    9069,
                                    9074,
                                    9087,
                                    9093,
                                    9099,
                                    9104,
                                    9113,
                                    9117,
                                    9122,
                                    9134,
                                    9139,
                                    9142,
                                    9152,
                                    9163,
                                    9168,
                                    9184,
                                    9196,
                                    9217,
                                    9231,
                                    9235,
                                    9238,
                                    9240,
                                    9245,
                                    9248,
                                    9264,
                                    9274,
                                    9283,
                                    9289,
                                    9325,
                                    9343,
                                    9344,
                                    9346,
                                    9364,
                                    9372,
                                    9375,
                                    9376,
                                    9379,
                                    9380,
                                    9385,
                                    9396,
                                    9402,
                                    9407,
                                    9421,
                                    9443,
                                    9447,
                                    9448,
                                    9452,
                                    9460,
                                    9464,
                                    9468,
                                    9493,
                                    9509,
                                    9549,
                                    9564,
                                    9602,
                                    9609,
                                    9619,
                                    9629,
                                    9639,
                                    9645,
                                    9646,
                                    9657,
                                    9660,
                                    9674,
                                    9681,
                                    9691,
                                    9728,
                                    9737,
                                    9738,
                                    9740,
                                    9746,
                                    9756,
                                    9762,
                                    9778,
                                    9797,
                                    9824,
                                    9846,
                                    9858,
                                    9860,
                                    9891,
                                    9896,
                                    9901,
                                    9908,
                                    9910,
                                    9918,
                                    9921,
                                    9929,
                                    9937,
                                    9942,
                                    9955,
                                    9958,
                                    9967,
                                    9992,
                                    9995,
                                    10020,
                                    10022,
                                    10024,
                                    10026,
                                    10029,
                                    10030,
                                    10056,
                                    10085,
                                    10104,
                                    10116,
                                    10123,
                                    10127,
                                    10129,
                                    10144,
                                    10150,
                                    10152,
                                    10155,
                                    10158,
                                    10190,
                                    10198,
                                    10201,
                                    10218,
                                    10249,
                                    10264,
                                    10269,
                                    10270,
                                    10280,
                                    10313,
                                    10321,
                                    10331,
                                    10343,
                                    10351,
                                    10355,
                                    10361,
                                    10369,
                                    10375,
                                    10380,
                                    10390,
                                    10432,
                                    10434,
                                    10437,
                                    10455,
                                    10462,
                                    10485,
                                    10494,
                                    10509,
                                    10517,
                                    10519,
                                    10520,
                                    10525,
                                    10527,
                                    10540,
                                    10541,
                                    10547,
                                    10558,
                                    10600,
                                    10619,
                                    10633,
                                    10637,
                                    10645,
                                    10647,
                                    10649,
                                    10658,
                                    10664,
                                    10671,
                                    10689,
                                    10719,
                                    10757,
                                    10768,
                                    10788,
                                    10801,
                                    10804,
                                    10805,
                                    10808,
                                    10813,
                                    10826,
                                    10829,
                                    10830,
                                    10854,
                                    10859,
                                    10861,
                                    10866,
                                    10876,
                                    10911,
                                    10924,
                                    10940,
                                    10955,
                                    10958,
                                    10966,
                                    10988,
                                    10996,
                                    10998,
                                    11014,
                                    11030,
                                    11035,
                                    11043,
                                    11045,
                                    11054,
                                    11057,
                                    11063,
                                    11072,
                                    11073,
                                    11076,
                                    11082,
                                    11084,
                                    11126,
                                    11133,
                                    11146,
                                    11147,
                                    11148,
                                    11167,
                                    11176,
                                    11214,
                                    11224,
                                    11244,
                                    11269,
                                    11289,
                                    11290,
                                    11298,
                                    11299,
                                    11308,
                                    11319,
                                    11328,
                                    11331,
                                    11351,
                                    11361,
                                    11409,
                                    11435,
                                    11441,
                                    11449,
                                    11457,
                                    11483,
                                    11493,
                                    11500,
                                    11525,
                                    11558,
                                    11564,
                                    11567,
                                    11574,
                                    11575,
                                    11623,
                                    11625,
                                    11629,
                                    11644,
                                    11656,
                                    11659,
                                    11675,
                                    11682,
                                    11714,
                                    11715,
                                    11718,
                                    11721,
                                    11731,
                                    11771,
                                    11773,
                                    11775,
                                    11786,
                                    11788,
                                    11790,
                                    11793,
                                    11828,
                                    11831,
                                    11837,
                                    11881,
                                    11902,
                                    11904,
                                    11920,
                                    11924,
                                    11925,
                                    11954,
                                    11955,
                                    11961,
                                    11977,
                                    11979,
                                    11984,
                                    11993,
                                    12002,
                                    12006,
                                    12009,
                                    12021,
                                    12025,
                                    12069,
                                    12070,
                                    12082,
                                    12093,
                                    12101,
                                    12110,
                                    12114,
                                    12120,
                                    12122,
                                    12123,
                                    12127,
                                    12131,
                                    12132,
                                    12146,
                                    12147,
                                    12151,
                                    12153,
                                    12182,
                                    12187,
                                    12190,
                                    12234,
                                    12237,
                                    12248,
                                    12281,
                                    12288,
                                    12292,
                                    12314,
                                    12323,
                                    12327,
                                    12337,
                                    12340,
                                    12355,
                                    12359,
                                    12376,
                                    12398,
                                    12412,
                                    12425,
                                    12426,
                                    12427,
                                    12443,
                                    12445,
                                    12451,
                                    12455,
                                    12473,
                                    12493,
                                    12500,
                                    12537,
                                    12555,
                                    12565,
                                    12593,
                                    12597,
                                    12603,
                                    12655,
                                    12661,
                                    12671,
                                    12678,
                                    12679,
                                    12682,
                                    12697,
                                    12699
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 1.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) [202317463] · 1.7 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 [202317463] · 0.78 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) [219281098,219215461,219215458,219215455,219213866,219161282,219161276,219161270] · 1.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 [219161270,219161276,219161282,219213866,219215455,219215458,219215461,219281098] · 2.28 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.68 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 (?) [125] · 0.55 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.55 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 (?) [2180] · 1.17 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2180] · 0.77 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [125,2181,2183,2184,2714,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3198,3199,3200,3622,3632,3635,3637,3640,3643,3651,3653,3656,6148,6150,6159,6201,6203,6211,6213,6219,6248,6252,6254,6273,6290,6298,6303,6324,6372,6420,6467,6489,6501,6513,6514,6515,6534,6540,6555,6574,6597,6605,6642,6650,6659,6662,6677,6678,6754,6757,6768,6786,6808,6823,6861,6888,6901,6902,6936,6951,6961,6972,6976,6982,6989,7002,7033,7036,7041,7048,7071,7073,7098,7107,7134,7139,7158,7164,7169,7176,7178,7191,7200,7251,7275,7290,7301,7328,7334,7344,7397,7418,7433,7434,7446,7459,7483,7485,7496,7499,7500,7517,7529,7544,7548,7559,7578,7590,7607,7642,7645,7655,7664,7687,7694,7706,7735,7748,7757,7764,7774,7776,7799,7803,7813,7817,7820,7830,7837,7850,7854,7874,7882,7885,7891,7902,7908,7935,7979,7987,7990,8015,8047,8065,8073,8075,8082,8105,8107,8111,8125,8134,8143,8147,8155,8162,8163,8184,8193,8211,8222,8223,8225,8237,8240,8241,8263,8288,8300,8301,8315,8316,8333,8366,8390,8412,8519,8550,8564,8568,8579,8601,8609,8628,8663,8678,8690,8713,8716,8747,8750,8761,8784,8803,8812,8815,8822,8824,8833,8867,8908,8925,8937,8939,8951,8956,8958,8964,8975,9009,9023,9069,9074,9087,9093,9099,9104,9113,9117,9122,9134,9139,9142,9152,9163,9168,9184,9196,9217,9231,9235,9238,9240,9245,9248,9264,9274,9283,9289,9325,9343,9344,9346,9364,9372,9375,9376,9379,9380,9385,9396,9402,9407,9421,9443,9447,9448,9452,9460,9464,9468,9493,9509,9549,9564,9602,9609,9619,9629,9639,9645,9646,9657,9660,9674,9681,9691,9728,9737,9738,9740,9746,9756,9762,9778,9797,9824,9846,9858,9860,9891,9896,9901,9908,9910,9918,9921,9929,9937,9942,9955,9958,9967,9992,9995,10020,10022,10024,10026,10029,10030,10056,10085,10104,10116,10123,10127,10129,10144,10150,10152,10155,10158,10190,10198,10201,10218,10249,10264,10269,10270,10280,10313,10321,10331,10343,10351,10355,10361,10369,10375,10380,10390,10432,10434,10437,10455,10462,10485,10494,10509,10517,10519,10520,10525,10527,10540,10541,10547,10558,10600,10619,10633,10637,10645,10647,10649,10658,10664,10671,10689,10719,10757,10768,10788,10801,10804,10805,10808,10813,10826,10829,10830,10854,10859,10861,10866,10876,10911,10924,10940,10955,10958,10966,10988,10996,10998,11014,11030,11035,11043,11045,11054,11057,11063,11072,11073,11076,11082,11084,11126,11133,11146,11147,11148,11167,11176,11214,11224,11244,11269,11289,11290,11298,11299,11308,11319,11328,11331,11351,11361,11409,11435,11441,11449,11457,11483,11493,11500,11525,11558,11564,11567,11574,11575,11623,11625,11629,11644,11656,11659,11675,11682,11714,11715,11718,11721,11731,11771,11773,11775,11786,11788,11790,11793,11828,11831,11837,11881,11902,11904,11920,11924,11925,11954,11955,11961,11977,11979,11984,11993,12002,12006,12009,12021,12025,12069,12070,12082,12093,12101,12110,12114,12120,12122,12123,12127,12131,12132,12146,12147,12151,12153,12182,12187,12190,12234,12237,12248,12281,12288,12292,12314,12323,12327,12337,12340,12355,12359,12376,12398,12412,12425,12426,12427,12443,12445,12451,12455,12473,12493,12500,12537,12555,12565,12593,12597,12603,12655,12661,12671,12678,12679,12682,12697,12699] · 2.98 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [125,2181,2183,3194,3198,6290,3178,3179,6203,3188,3181,3200,6159,3622,3196,6148,7548,6324,6252,2714,3190,3180,3197,3187,6248,3186,6219,3192,8240,3195] · 1.17 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.05 ms