SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/postelnoe_bele/abstract-flowers.html' LIMIT 0,1 [0.00056290626525879 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('abstract','flowers') order by url [0.0016069412231445 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('abstract','flowers') order by url [0.0011820793151855 sec]
SELECT id, url FROM pod_filter WHERE url IN ('abstract','flowers') [0.00062704086303711 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('abstract','flowers') [0.00043606758117676 sec]
SELECT f.id, mf.id as mf_id, mf.is_split FROM pod_filter f INNER JOIN pod_filter mf ON f.entry = mf.id WHERE f.id in (10,14) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00043416023254395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; CREATE TEMPORARY TABLE tmp_base_goods ( id INT NOT NULL PRIMARY KEY, brand_id INT, price DECIMAL(10,2), old_price DECIMAL(10,2), ordr INT, is_present TINYINT(1), sub_icon_id INT, fast_delivery TINYINT(1), is_new TINYINT(1), is_sale TINYINT(1), KEY idx_brand (brand_id) ) ENGINE=MEMORY [0.00042819976806641 sec]
INSERT INTO tmp_base_goods (id, brand_id, price, old_price, ordr, is_present, sub_icon_id, fast_delivery, is_new, is_sale) SELECT g.id, g.brand_id, g.price, g.old_price, g.ordr, g.is_present, g.sub_icon_id, g.fast_delivery, g.is_new, g.is_sale FROM pod_cat_good g WHERE g.cat_id IN (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND g.entry=0 AND g.is_active AND g.is_present_all_mods UNION SELECT g.id, g.brand_id, g.price, g.old_price, g.ordr, g.is_present, g.sub_icon_id, g.fast_delivery, g.is_new, g.is_sale FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id WHERE dc.dop_cat_id IN (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.80338382720947 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods; CREATE TEMPORARY TABLE tmp_sub_goods ( id INT NOT NULL PRIMARY KEY, entry INT NOT NULL, price DECIMAL(10,2), old_price DECIMAL(10,2), sub_icon_id INT, is_present TINYINT(1), fast_delivery TINYINT(1), is_new TINYINT(1), is_sale TINYINT(1), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00054192543029785 sec]
INSERT INTO tmp_sub_goods (id, entry, price, old_price, sub_icon_id, is_present, fast_delivery, is_new, is_sale) SELECT go.id, go.entry, go.price, go.old_price, go.sub_icon_id, go.is_present, go.fast_delivery, go.is_new, go.is_sale FROM pod_cat_good go INNER JOIN tmp_base_goods t ON go.entry = t.id WHERE go.is_active AND go.is_present [0.44423699378967 sec]
SELECT g.id /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (10,14) WHERE 1 [0.17144107818604 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2fcabd4705a ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00036096572875977 sec]
INSERT INTO temp_brand_counts_6a2fcabd4705a (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (10,14) WHERE 1 [0.027281999588013 sec]
SELECT b.id, b.name AS name, pc.name AS country, b.country_id, b.image_icon, b.url, b.ordr, pc.code, COALESCE(tc.count, 0) as count FROM pod_cat_brand b INNER JOIN ( SELECT id, COUNT(gid) as count FROM temp_brand_counts_6a2fcabd4705a GROUP BY id HAVING COUNT(gid) > 0 ) tc ON b.id = tc.id LEFT JOIN pod_country pc ON (pc.id = b.country_id AND pc.is_active = 1) WHERE b.is_active = '1' ORDER BY b.ordr [0.0016481876373291 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2fcabd4705a [0.0001981258392334 sec]
SELECT MIN(min_price) AS min_price, MAX(max_price) AS max_price FROM ( SELECT MIN(g.price) AS min_price, MAX(g.price) AS max_price /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (10,14) WHERE g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (10,14) WHERE 1 ) A [0.026782989501953 sec]
SELECT g.id /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */,if(g.is_present and g.price >= '484' and g.price <= '15119',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) min_sort_price, if(g.is_present and g.price >= '484' and g.price <= '15119',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price FROM tmp_base_goods g LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id AND pcg.is_present=1 AND pcg.price >= '484' AND pcg.price <= '15119' WHERE g.id IN (92902,128012,147467,153693,154258,187284,200571,238127,270464,332734,332872,334574,334585,334598,334602,335678,335697,335701,335701,335705,335894,335917,336909,338962,345899,348698,349429,394162,417534,423089,459341,463967,468068,476523,482533,485647,485654,497984,500248,500264,507115,507120,507132,507139,507146,79045,180261,269752,269761,270101,270101,270104,270461,288649,293702,293706,293706,293709,293709,299749,308630,308630,312933,317774,317777,319140,322681,322754,324267,324270,324285,332616,332617,332638,332654,332668,332668,332724,332742,332745,332757,332760,332769,332776,332783,332789,332799,332805,332811,332815,332819,332827,332831,332839,332843,332847,332851,332917,332929,333015,333156,333335,333339,333351,334577,335586,335590,335596,335682,335693,335707,335721,335776,335778,335781,335783,335810,335881,335882,335887,335888,335896,335905,335912,336896,336907,337547,338960,338961,338972,338982,341419,341422,342729,343262,343270,343291,344848,344848,344868,344884,344888,344909,344914,344918,345842,345848,345892,345911,345951,348115,348118,348121,348137,348229,348233,348237,348241,348245,348249,348257,348265,348277,348290,348373,348393,348401,348405,348417,348425,348429,348438,348442,348461,348701,349355,349359,349363,349371,349424,349455,349483,349495,349515,349531,349709,349713,349721,349737,349893,349901,349905,349921,349944,363706,363722,363726,363738,363742,363746,367553,367557,367560,367800,367803,367803,367811,367823,367826,367829,367844,367853,367856,367862,367869,374181,375158,385341,385345,385349,385353,385357,385361,385365,385369,385373,385377,385404,385408,385412,385416,385420,385428,394132,408119,408122,408129,408130,409506,417522,417522,417528,417531,417539,417542,422989,423096,423097,423100,423101,423103,423136,423137,423139,423141,423142,423145,425909,426445,430622,430622,430623,430624,430633,430636,430640,430644,430651,430651,430734,430738,430746,430750,430754,431419,431428,431430,431454,432250,432258,432388,432391,432392,432394,432396,432400,432404,432408,432523,432527,432531,432535,432539,432543,432547,432550,432554,432696,432708,432720,432736,433020,433022,433029,434093,434097,434101,434105,434109,434121,434130,434134,434144,434148,434152,434156,434172,434180,434221,434225,434623,434627,434627,434655,434659,434779,434784,435707,435835,436046,436048,436056,436060,436102,436244,436246,436248,436252,436257,436259,436271,436896,436896,436897,439177,439189,439193,439954,439958,440509,440686,440690,440694,441329,441337,441345,441897,441898,441899,441900,444002,444018,447602,447606,447610,447614,447618,448395,448399,448413,448417,448425,448716,448742,449196,449200,450307,450314,450319,450320,450823,451452,451459,452696,452700,453174,453178,456396,456401,456406,456410,456447,458591,459996,460000,460005,460009,460013,462317,462321,462325,462349,462353,464194,464198,464202,464723,464728,464746,466458,466462,466470,466474,466478,470473,472531,472536,473093,473107,473112,473143,473148,473153,473167,473174,473188,473195,473415,473423,474530,474542,474546,474550,474554,474558,474562,475218,475246,475311,475315,475319,475323,476227,476235,476239,476243,476247,476251,476255,476415,476422,476436,476530,476603,476610,476684,476688,476692,476696,476700,477672,477676,478359,479009,479010,479011,479012,479014,479015,479017,479019,481817,481822,481827,481831,482042,482054,482457,483043,483043,483048,483053,483057,483059,483073,483077,483082,483092,483096,483098,483100,483122,483124,483129,484032,485570,485577,485595,485602,485616,485636,485661,485676,487021,487028,487052,488935,491261,491265,497614,497623,497639,497646,497652,497661,497666,497671,497676,497696,497708,497778,497790,497794,497942,497948,497973,497979,500256,500260,500268,500277,500285,500285,500289,500293,500297,500301,500305,500316,500332,500350,500354,500358,500368,500389,500393,500397,500401,500411,500414,503452,503458,504941,504953,504959,504982,504988,504995,507110,507153,507164,507171,508844,509138,509142,2853,5056,5396,5425,21085,21087,22596,22598,45302,155686,204364,268073,334592,335350,335357,336361,337671,338012,338014,347341,347364,348491,393544,401068,404898,405505,428157,428160,428163,428207,428228,473661,473665,478106,478817,498308,2600,2610,2807,2845,2914,4696,5058,5391,5392,5400,5423,6086,11679,11681,17060,25606,26587,26592,46233,48090,51222,64276,64562,74477,81463,94948,94948,94974,94977,129334,138634,155066,175962,209851,237974,238535,248830,262588,262592,309376,313646,317762,317765,318518,319673,322692,322700,335564,335566,335576,337672,345781,348150,348177,348180,348584,348620,348624,349741,351547,363758,366473,366853,374184,375155,377093,381031,381033,392787,392789,392790,401071,401077,404886,404892,404909,405831,408065,408195,408198,408307,408313,408319,409236,409237,409238,409389,409391,419804,419805,428146,428152,428166,428169,428210,428216,430344,430660,430798,430799,430801,430802,430803,430804,430809,430812,430940,430942,430947,430955,430959,430960,430964,430968,430980,430984,430988,430992,430996,431000,431004,431008,431016,431020,431024,431032,431239,431240,431244,431254,431262,431270,431274,431282,431290,431294,431298,434599,434611,434615,434619,436070,439085,439089,439097,439149,439153,446996,450546,450547,450708,453194,453198,453206,453210,461003,464074,464079,464084,465684,465692,467474,467478,467486,467490,467494,471525,471585,473576,473655,473669,473713,473715,473717,474298,474310,476797,476804,476818,476974,476976,476977,477814,477815,477817,477820,477821,477822,477824,477825,477827,477829,477830,477830,477831,477832,477838,477839,477840,477841,477842,477920,477927,478099,478107,478203,478815,478820,480003,482495,482502,482635,482650,482655,483159,483165,483168,483171,483958,483963,483968,483973,483978,483988,483998,487766,487769,487774,487782,487784,487792,487799,488557,488558,490840,490841,493957,493959,493961,493966,498258,498263,498264,498266,498298,504479,504483,504487,504491,504495,506680,506686,506690,506693,506696,392766,392767,392768,392769,392770,392771,392772,392773,392774,392775,392776,392777,392778,392779,392780,392781,5113,6106,6114,6356,10694,11122,26778,35294,43767,43768,43769,43770,43771,43772,43773,55974,231661,231667,264207,264208,312361,312379,312387,312391,372485,472410,472420,472425,492280,492281,492282,492285,492287,492288,492290,492291,492295,408121,480001,471414,482062,482064,482074,489045,317377,351990,413629,413632,434692,434693,434695,434696,464665,464700,464705,464717,464724,464755,464757,464758,464765,464766,477701,478101,478102,478104,478548,478549,478550,478551,478553,478554,478555,494940,494951,494958,498299,498301,2936,207919,284216,326530,335627,341111,341111,408201,418363,418365,436272,441902,453603,456400,456405,470755,470757,477035,477237,477241,477248,477249,481821,481826,482866,499285,501920,501921,503858,503860,503861,503862,471314,471320,471330,471332,114214,283905,286110,286111,312367,317174,325983,350411,350412,350414,350415,372438,413476,413478,413481,413482,413487,413488,413489,413490,413492,413493,413573,413574,434707,434708,434709,434710,434711,434712,471328,471447,471467,471474,471477,478400,478401,478404,478405,478406,483138,483140,483145,483147,498221,498242,499545,499550,499553,507690,507691,462001,478196,479007,479008,481192,481195,481836,481837,481851,481852,509677,341459,431306,431318,431322,432105,432109,432113,432118,441904,441907,441908,465700,465717,467265,467269,467277,497163,497272,497276,497280,497284,498946,503626,503627,503628,503629,503630,503631,503632,7545,34696,87573,138639,138641,158367,182931,188230,237222,317379,364782,364806,364812,392021,395871,411326,411358,411372,411380,411384,411405,411778,417509,418503,425433,425437,433088,433109,441826,449658,449663,449674,464058,470675,470684,470730,470745,471572,471578,475335,475451,476856,477164,477166,478216,481967,481979,485232,485236,485274,485550,488522,493425,493475,493705,497091,498154,498156,498161,499440,499449,499462,499719,500005,500027,502626,503729,503751,22536,83299,85041,95898,138235,158605,158606,172065,172068,176615,186756,188854,192120,192127,192129,192130,192198,192199,193473,193477,193480,193480,248350,253216,259116,263875,271528,273284,273306,275083,277854,286149,292784,292785,292786,293599,299605,302795,308635,308638,308644,309191,309904,309906,317167,317169,317179,326459,330686,332835,333195,334856,335480,335491,335502,335505,335506,335508,335551,335555,335629,338969,339779,348722,349113,349117,349129,349883,349884,350287,350288,350297,350333,350334,352044,364801,370039,373674,376197,376510,376682,376692,385432,385440,385448,385452,385456,395715,411351,411362,411376,411396,411399,411799,413575,413586,413588,413589,413615,415050,415051,415058,415064,415064,418005,418015,418339,418341,418343,418344,418346,418347,418348,418505,418509,418517,418525,418539,430655,430657,430659,433092,433101,435468,435694,435700,435702,435708,436067,436253,436889,436890,436891,449770,470605,470608,470619,470622,470634,470636,470638,470642,470650,470657,470661,470669,470671,470677,471437,471442,471576,472678,472683,473071,475272,475277,475282,475286,475288,475290,475293,475337,475340,475344,475348,475356,475360,475364,475366,475510,475520,475525,475530,475540,475545,475565,475572,475724,475998,476017,476457,476464,476478,476721,476728,476845,476848,476850,476875,476878,476884,476890,476894,476896,476897,476899,476902,476903,476904,476905,476906,476907,476966,476967,476969,476973,477004,477009,477161,477168,477171,478252,478254,478255,478256,478259,478263,478264,478265,478267,478272,478273,481917,481923,481927,481933,481940,481944,481947,481951,481955,481959,481963,481975,481983,481987,481991,481999,482008,483174,483176,483179,483182,485224,485267,485281,485383,485554,488470,488475,488478,488480,488489,488491,488491,488496,488504,488507,488510,488518,488519,488521,488524,488543,490843,490850,490852,490854,490855,490857,490859,490862,490863,490866,493417,493421,493429,493433,493437,493452,493694,497030,497034,497056,497058,497063,497065,497082,497096,497141,497147,498158,498159,498162,498162,498167,498168,498169,498172,498173,498175,498176,498177,498178,498180,498181,498778,498778,498924,499455,499458,499466,499707,499711,500002,500009,500019,500044,500048,500701,500701,500711,500714,500724,500724,500737,500740,500743,500820,500853,500923,500931,500938,500959,500962,500966,500986,500994,501019,501027,501027,501112,501132,501139,501139,501142,501145,501158,501185,502044,502423,502427,502431,502468,502584,502585,502622,502623,502624,502627,502629,502630,502632,502648,502650,502652,502654,502655,502657,502659,502660,502661,502662,502664,502666,502668,502670,502672,502674,502676,502677,502679,502681,502683,502687,502688,503728,503731,503733,503734,503735,503741,503743,503750,503752,503758,503762,503764,503766,503767,503770,505147,505150,505156,505162,505254,505271,507658,507659,507666,507687,508996,417958,417962,417974,480223,480224,480225,480226,481914,485363,493546,493556,497044,503826,299877,478973,478978,493573,493573,493574,493575,497047,497049,497053,499478,503803,503809,503819,507578,507584,507588,343303,343766,349761,474318,474348,474366,500433,500436,500442,416399,416423,416429,459470,459479,347655,391929,391941,391945,391958,391962,402705,402847,404705,406393,406395,406397,407267,407271,407299,407303,407307,409224,409225,409228,409229,409234,409371,413423,413427,413431,413435,431367,431371,431379,431387,431395,432412,432416,434057,434061,434065,434069,434445,434453,434457,434461,434465,434469,434481,434493,434497,434501,435580,435584,435596,435604,435608,435616,435620,435624,435628,435636,435640,435689,435795,435878,435882,435895,435904,435909,435914,436029,436037,436240,436270,436888,436895,440207,440215,440223,440227,440935,440947,450871,450887,459474,459485,460961,460965,460977,464676,464684,464688,464692,464701,464706,464719,473439,473443,473447,473451,473523,477888,477892,477896,477900,477904,478610,478614,478630,478638,478642,478646,482347,459448,441901,459427,459431,459435,484160,484174,485409,485416,485423,485517,108872,108875,135349,135350,135352,135363,191412,191415,191416,191417,403051,403057,403062,427853,428308,428318,494821,408152,434025,471583,481198,481201,481204,481207,481857,509670,509674,509679,320225,459532,459536,488765,425376,471616,471619,471620,488756,488774,488786,502741) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.034420013427734 sec]
SELECT g.video, g.threedvideo, g.is_xit, g.is_action, g.is_sale, g.sub_is_action, g.is_new, g.is_pay_for_video, g.id, g.cat_id, g.name AS name, g.name2 AS name2, g.descr, g.size_table, g.artikul, g.image_small, g.image_big, g.price, g.old_price, g.is_present, g.is_present_all_mods, g.sub_icon_id,g.url,g.ordr, g.last_items, g.fast_delivery, g.free_delivery, g.gift, g.timer, g.action_validity, b.name AS brand_name,b.url as burl,b.id as bid, b.country AS brand_country,c.url as curl, c.name AS cat_name, si.name AS sub_icon_name,si.icon AS sub_icon, g.star, g.comment_id, if(g.is_present and g.price >= '484' and g.price <= '15119',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) as min_sort_price, if(g.is_present and g.price >= '484' and g.price <= '15119',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) as max_sort_price FROM pod_cat_good g INNER JOIN pod_cat_category c ON c.id=g.cat_id LEFT JOIN pod_cat_brand b ON b.id=g.brand_id LEFT JOIN pod_sub_icon si ON si.id=g.sub_icon_id LEFT JOIN pod_cat_good pcg ON (pcg.entry=g.id and pcg.is_present=1 and pcg.price >= '484' and pcg.price <= '15119') WHERE g.id in (497614,497646,502427,502468,497984,502423,419804,481967,430964,493425,509142,503741,476845,497141,497666,465684,450546,409391,502431,477827,485267,502662,332811,476856,477838,478820,497147,317377,350333,502741,503452,497708) GROUP BY g.id ORDER BY g.ordr desc [0.0081009864807129 sec]
SELECT g.ordr, g.is_xit, g.is_pay_for_video, g.is_action, g.is_sale, g.is_new, g.last_items, g.fast_delivery, g.free_delivery, g.gift, g.timer, g.action_validity, g.id, g.entry, g.name AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name AS sub_icon_name, si.icon AS sub_icon FROM pod_cat_good g LEFT JOIN pod_sub_icon si ON si.id = g.sub_icon_id WHERE g.entry IN (497614,497646,502427,502468,497984,502423,419804,481967,430964,493425,476845,503741,509142,497141,497666,465684,450546,409391,502431,317377,332811,350333,476856,477827,477838,478820,485267,497147,502662,502741,503452,497708) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00064992904663086 sec]
SELECT DISTINCT ggd2.good_id AS source_good_id, g.id, g.is_present_all_mods, pc.name AS name, g.url, b.url as burl, c.url as curl, g.is_present, pc.code AS color_code, gg.group_type, gg.param_name, gg.param_name_ua, ggd.text_value, ggd.icon_path FROM pod_goods_group_goods ggd2 JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id JOIN pod_cat_good g ON g.id=ggd.good_id LEFT JOIN pod_cat_brand b ON g.brand_id=b.id LEFT JOIN pod_cat_category c ON g.cat_id=c.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE ggd2.good_id IN (497614,497646,502427,502468,497984,502423,419804,481967,430964,493425,476845,503741,509142,497141,497666,465684,450546,409391,502431,317377,332811,350333,476856,477827,477838,478820,485267,497147,502662,502741,503452,497708) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.003007173538208 sec]
SELECT id, name AS name, url FROM pod_filter WHERE id in (10,14) AND is_active='1' [0.00021505355834961 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a; CREATE TEMPORARY TABLE tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00026082992553711 sec]
INSERT INTO tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a (goods_id, filter_id) SELECT DISTINCT t.id AS goods_id, f.id AS filter_id FROM pod_cat_filter cf INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good) ON gf.filter_id = cf.filter_id AND gf.cat_id IN (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND gf.filter_id_value NOT IN (10,14) INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active INNER JOIN tmp_base_goods t ON gf.id_good = t.id WHERE cf.category_id = 3 [0.1610279083252 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a; CREATE TEMPORARY TABLE tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00038599967956543 sec]
INSERT IGNORE INTO tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a p GROUP BY p.filter_id [0.0013868808746338 sec]
SELECT c.filter_id, c.count, f.entry, f.name AS name, f.url, f.ord, fm.name AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a c INNER JOIN pod_filter f ON c.filter_id = f.id INNER JOIN pod_filter fm ON f.entry = fm.id ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00038290023803711 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a [0.00022006034851074 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd63b1a [0.00010490417480469 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256; CREATE TEMPORARY TABLE tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00018405914306641 sec]
INSERT INTO tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256 (goods_id, filter_id) SELECT DISTINCT ts.entry AS goods_id, f.id AS filter_id FROM pod_cat_filter cf INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good) ON gf.filter_id = cf.filter_id AND gf.cat_id IN (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND gf.filter_id_value NOT IN (10,14) INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active INNER JOIN tmp_sub_goods ts ON gf.id_good = ts.id WHERE cf.category_id = 3 [0.047113180160522 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256; CREATE TEMPORARY TABLE tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00031709671020508 sec]
INSERT IGNORE INTO tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256 p GROUP BY p.filter_id [0.00045013427734375 sec]
SELECT c.filter_id, c.count, f.entry, f.name AS name, f.url, f.ord, fm.name AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256 c INNER JOIN pod_filter f ON c.filter_id = f.id INNER JOIN pod_filter fm ON f.entry = fm.id ORDER BY fm.ord DESC, f.ord DESC, c.filter_id [0.00023508071899414 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256 [0.00016307830810547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd8c256 [8.082389831543E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518; CREATE TEMPORARY TABLE tmp_A_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id), INDEX idx_sub_icon_id (sub_icon_id) ) ENGINE=MEMORY; [0.00014495849609375 sec]
INSERT IGNORE INTO tmp_A_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518 (entry, sub_icon_id) SELECT DISTINCT A.entry, A.sub_icon_id FROM ( SELECT g.id as id, g.id as entry, g.sub_icon_id /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (10,14) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (10,14) WHERE 1 ) A [0.022424936294556 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518; CREATE TEMPORARY TABLE tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00040888786315918 sec]
INSERT IGNORE INTO tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518 A INNER JOIN pod_sub_icon si ON A.sub_icon_id = si.id AND si.is_active_filter = 1 ) AA GROUP BY sub_icon_id [0.0014920234680176 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518 c INNER JOIN pod_sub_icon si ON c.sub_icon_id = si.id AND si.is_active_filter = 1 ORDER BY si.ordr, si.name [0.00027704238891602 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518 [0.00026702880859375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_e7cq2ll4qhdc13qjo013soeqf7_6a2fcabd98518 [0.00010299682617188 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.0001990795135498 sec]
Постельное белье Абстракция, Цветы купить в Киеве с доставкой по Украине ⭐️ Podushka

DEVELOPMENT🌷СКИДКИ ДО 70%

ПЕРЕЙТИ

Постельное белье : абстракция, цветы

Комплект постельного белья SoundSleep Fiona бязь белый Хит продаж - 30 %
Комплект постельного белья SoundSleep Fiona бязь белый
Код: 497614
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный евро комплект

Двуспальный евро комплект
1 567 грн 1 097 грн
Цена:
751 грн 1 073 грн
Комплект постельного белья SoundSleep Sintia бязь белый - 30 %
Комплект постельного белья SoundSleep Sintia бязь белый
Код: 497646
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный евро комплект

Двуспальный евро комплект
1 567 грн 1 097 грн

Семейный комплект

Семейный комплект
Цена:
751 грн 1 073 грн
Комплект постельного белья хлопковый Ethereal Flore SoundSleep ранфорс Новинка
Комплект постельного белья хлопковый Ethereal Flore SoundSleep ранфорс
Код: 502427
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный комплект

Двуспальный комплект

Двуспальный евро комплект

Двуспальный евро комплект
Цена:
1 279 грн
Комплект постельного белья хлопковый Blue Bloom SoundSleep ранфорс - 20 %
Комплект постельного белья хлопковый Blue Bloom SoundSleep ранфорс
Код: 502468
delivary icon

Производитель: SoundSleep (Украина)

Цена:
1 799 грн 2 249 грн
Комплект постельного белья SoundSleep Leaflets бязь серый Хит продаж - 30 %
Комплект постельного белья SoundSleep Leaflets бязь серый
Код: 497984
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный комплект

Двуспальный комплект
1 401 грн 981 грн

Семейный комплект

Семейный комплект
1 966 грн 1 376 грн
Показать больше
Цена:
981 грн 1 401 грн
Комплект постельного белья хлопковый Royal Blossom SoundSleep ранфорс Хит продаж Новинка
Комплект постельного белья хлопковый Royal Blossom SoundSleep ранфорс
Код: 502423
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный комплект

Двуспальный комплект

Двуспальный евро комплект

Двуспальный евро комплект
Показать больше
Цена:
1 279 грн
Комплект постельного белья Burlington SoundSleep премиум сатин - 10 %
Комплект постельного белья Burlington SoundSleep премиум сатин
Код: 419804
delivary icon

Производитель: SoundSleep (Украина)

Семейный комплект

Семейный комплект
4 980 грн 4 482 грн
Цена:
3 816 грн 4 240 грн
Постельное белье 24346 ранфорс Вилюта
Постельное белье 24346 ранфорс Вилюта
Код: 481967
delivary icon

Производитель: Вилюта (Украина)

Двуспальный евро комплект

Двуспальный евро комплект

Семейный комплект

Семейный комплект
Цена:
1 096 грн
Постельное белье Цветочное утро 300198 сатин Selena - 10 %
Постельное белье Цветочное утро 300198 сатин Selena
Код: 430964

Производитель: Selena (Украина)

Двуспальный комплект

Двуспальный комплект
1 312 грн 1 180 грн

Двуспальный евро комплект

Двуспальный евро комплект
1 463 грн 1 317 грн
Показать больше
Цена:
1 000 грн 1 110 грн
Постельное белье 25358 ранфорс Вилюта
Постельное белье 25358 ранфорс Вилюта
Код: 493425

Производитель: Вилюта (Украина)

Двуспальный евро комплект

Двуспальный евро комплект

Семейный комплект

Семейный комплект
Цена:
1 096 грн
Постельное белье Cozy Breezeway ранфорс Altinbasak
Постельное белье Cozy Breezeway ранфорс Altinbasak
Код: 476845

Производитель: Altinbasak (Турция)

Двуспальный евро комплект

Двуспальный евро комплект

Семейный комплект

Семейный комплект
Цена:
1 897 грн
Постельное белье 25353 ранфорс Вилюта простынь на резинке
Постельное белье 25353 ранфорс Вилюта простынь на резинке
Код: 503741

Производитель: Вилюта (Украина)

Двуспальный евро комплект, простынь на резинке (простынь 160х200 см)

Двуспальный евро комплект, простынь на резинке

Двуспальный евро комплект, простынь на резинке (простынь 180х200 см)

Двуспальный евро комплект, простынь на резинке
Цена:
1 161 грн
Постельное белье Лавандовый вечер 100892 бязь-люкс Selena Новинка
Постельное белье Лавандовый вечер 100892 бязь-люкс Selena
Код: 509142

Производитель: Selena (Украина)

Двуспальный комплект

Двуспальный комплект

Двуспальный евро комплект

Двуспальный евро комплект
Показать больше
Цена:
864 грн
Комплект постельного белья Storing SoundSleep ранфорс светло-зеленый - 15 %
Комплект постельного белья Storing SoundSleep ранфорс светло-зеленый
Код: 497141
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный комплект

Двуспальный комплект
1 437 грн 1 221 грн

Двуспальный евро комплект

Двуспальный евро комплект
Цена:
1 142 грн 1 343 грн
Комплект постельного белья SoundSleep Fareo бязь светло-бирюзовый Хит продаж - 30 %
Комплект постельного белья SoundSleep Fareo бязь светло-бирюзовый
Код: 497666
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный евро комплект

Двуспальный евро комплект
1 567 грн 1 097 грн
Цена:
751 грн 1 073 грн
Комплект постельного белья Евро Elle Wildflowers Rose Soho
Комплект постельного белья Евро Elle Wildflowers Rose Soho
Код: 465684
delivary icon

Производитель: Soho (КНР)

Цена:
4 899 грн
Постельное белье Salina сатин Lotus Home
Постельное белье Salina сатин Lotus Home
Код: 450546
delivary icon

Производитель: Lotus Home (Украина)

Цена:
2 499 грн
Постельное белье сатин Premium Delcina Berry La Romano
Постельное белье сатин Premium Delcina Berry La Romano
Код: 409391

Производитель: La Romano (Турция)

Цена:
5 733 грн
Комплект постельного белья хлопковый Velvet Petals SoundSleep ранфорс Хит продаж
Комплект постельного белья хлопковый Velvet Petals SoundSleep ранфорс
Код: 502431
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный комплект

Двуспальный комплект
Цена:
1 279 грн
Постельное белье First choice VIP Moonlight satin Buhara pudra
Постельное белье First choice VIP Moonlight satin Buhara pudra
Код: 317377

Производитель: First choice (Турция)

Цена:
5 292 грн
Комплект постельного белья Selena Адель 100249
Комплект постельного белья Selena Адель 100249
Код: 332811
delivary icon

Производитель: Selena (Украина)

Двуспальный комплект

Двуспальный комплект

Двуспальный евро комплект

Двуспальный евро комплект
Показать больше
Цена:
786 грн
Постельное белье Rina ранфорс First choice
Постельное белье Rina ранфорс First choice
Код: 350333

Производитель: First choice (Турция)

Цена:
2 646 грн
Постельное белье Lava Puce ранфорс Altinbasak
Постельное белье Lava Puce ранфорс Altinbasak
Код: 476856

Производитель: Altinbasak (Турция)

Двуспальный евро комплект

Двуспальный евро комплект

Семейный комплект

Семейный комплект
Цена:
2 344 грн
Постельное белье Holea Tapestry сатин-премиум La Romano
Постельное белье Holea Tapestry сатин-премиум La Romano
Код: 477827

Производитель: La Romano (Турция)

Цена:
5 733 грн
Постельное белье Madena Beige сатин-премиум La Romano
Постельное белье Madena Beige сатин-премиум La Romano
Код: 477838

Производитель: La Romano (Турция)

Полуторный комплект

Полуторный комплект

Семейный комплект

Семейный комплект
Цена:
4 284 грн
Постельное белье Leaf сатин 3D First choice
Постельное белье Leaf сатин 3D First choice
Код: 478820
delivary icon

Производитель: First choice (Турция)

Цена:
5 733 грн
Постельное белье 25362 ранфорс Вилюта
Постельное белье 25362 ранфорс Вилюта
Код: 485267

Производитель: Вилюта (Украина)

Двуспальный комплект

Двуспальный комплект

Семейный комплект

Семейный комплект
Цена:
799 грн
Комплект постельного белья Leotio SoundSleep ранфорс голубой
Комплект постельного белья Leotio SoundSleep ранфорс голубой
Код: 497147
delivary icon

Производитель: SoundSleep (Украина)

Цена:
1 343 грн
Постельное белье Marea Blue ранфорс Homesko
Постельное белье Marea Blue ранфорс Homesko
Код: 502662

Производитель: Homesko (Турция)

Двуспальный евро комплект, простынь на резинке

Двуспальный евро комплект, простынь на резинке
Цена:
1 953 грн
Комплект постельного белья Black Marble Emily микрофибра черно-белый - 20 %
Комплект постельного белья Black Marble Emily микрофибра черно-белый
Код: 502741
delivary icon

Производитель: Emily (Украина)

Цена:
585 грн 731 грн
Комплект постельного белья SoundSleep Ratlin бязь сине-голубой Хит продаж - 30 %
Комплект постельного белья SoundSleep Ratlin бязь сине-голубой
Код: 497708
delivary icon

Производитель: SoundSleep (Украина)

Двуспальный евро комплект

Двуспальный евро комплект
1 567 грн 1 097 грн
Цена:
751 грн 1 073 грн
1 2 3 4 5 6 7 8 9 10