SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/postelnoe_bele/flowers-eda_f.html' LIMIT 0,1 [0.00051212310791016 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('flowers','eda_f') order by url [0.0015659332275391 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('flowers','eda_f') order by url [0.0011889934539795 sec]
SELECT id, url FROM pod_filter WHERE url IN ('flowers','eda_f') [0.00047922134399414 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('flowers','eda_f') [0.00050497055053711 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 (3543,14) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00043797492980957 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.00047683715820312 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.75319504737854 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.00036191940307617 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.36138701438904 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 (14,3543) WHERE 1 [0.088643074035645 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2fcb43714a5 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00072002410888672 sec]
INSERT INTO temp_brand_counts_6a2fcb43714a5 (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 (14,3543) WHERE 1 [0.049233198165894 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_6a2fcb43714a5 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.0018181800842285 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2fcb43714a5 [0.00028681755065918 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 (14,3543) 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 (14,3543) WHERE 1 ) A [0.022952079772949 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 (128012,147467,153693,154258,187284,200571,238127,270464,332734,332872,334574,334585,334598,334602,335678,335697,335701,335894,335917,336909,338962,345899,348698,349429,394162,417534,423089,459341,463967,468068,476523,482533,485647,485654,497609,497984,500264,507115,507120,507132,507139,507146,180261,270101,270104,270461,288649,293702,293706,293709,299749,308630,312933,317774,317777,319140,322754,324267,332616,332617,332668,332724,332742,332745,332757,332760,332776,332783,332799,332805,332811,332815,332819,332827,332831,332839,332843,332847,332851,333015,333156,333335,333339,333351,334577,335586,335590,335596,335682,335693,335707,335721,335776,335778,335781,335783,335810,335887,335888,335896,335905,335912,336896,336907,337547,338960,338961,338972,338982,341419,341422,342729,343262,343270,343291,344848,344909,344914,344918,345842,345892,345911,345951,348115,348118,348137,348229,348233,348237,348241,348245,348249,348257,348265,348277,348290,348373,348393,348401,348405,348417,348429,348701,349359,349424,349455,349483,349495,349515,349531,349709,349713,349721,349737,349893,349905,349921,349944,363706,363722,363726,363738,363742,363746,367553,367557,367560,367800,367803,367823,367826,367829,367844,367853,367856,367862,367869,374181,375158,385404,394132,408119,408122,408129,408130,417522,417528,417531,417542,422989,423096,423097,423100,423101,423103,423136,423137,423139,423141,423142,426445,430622,430623,430624,430633,430636,430651,430734,430738,430746,431430,431454,432250,432258,432388,432391,432392,432394,432396,432400,432404,432408,432523,432527,432531,432543,432547,432550,432554,432696,432708,432720,432736,433020,433022,434093,434097,434101,434105,434109,434121,434134,434144,434148,434156,434172,434180,434221,434225,434623,434627,434655,434659,434779,434784,435707,435835,436046,436048,436056,436060,436102,436244,436248,436252,436257,436259,436271,436896,436897,439189,439193,439954,439958,441329,441337,441345,441897,441899,441900,444018,447602,447606,447610,447614,447618,448413,448417,448425,448716,448742,449196,449200,450307,450314,450320,450823,451452,451459,452696,452700,453174,453178,456396,456401,456406,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,473093,473107,473112,473148,473167,473423,474530,474542,474546,474550,474554,474558,474562,475218,475311,475319,476227,476239,476243,476247,476251,476255,476415,476422,476436,476530,476610,476692,476696,476700,477672,477676,478359,479009,479010,479012,479014,479015,479017,479019,481827,481831,482050,482054,482457,483043,483053,483057,483059,483073,483077,483082,483092,483096,483098,483100,483129,485570,485577,485595,485602,485636,485661,485676,491261,491265,497614,497623,497646,497652,497666,497671,497676,497778,497794,497942,497948,497979,500256,500260,500268,500277,500281,500285,500289,500293,500297,500301,500316,500332,500350,500354,500358,500389,500393,500397,500401,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,335350,335357,336361,337671,338012,338014,347341,347364,348491,393544,404898,405505,428160,428163,428207,428228,473661,473665,478106,478817,498308,2600,2610,2807,2845,2914,4696,5391,5392,5400,5423,6086,11679,11681,17060,25606,26587,26592,46233,48090,51222,64276,64562,74477,81463,94948,94977,129334,138634,155066,238535,248830,262588,262592,313646,317762,317765,322700,335564,335566,337672,345781,348150,348177,348180,348584,348624,349741,351547,363758,366473,374184,375155,377093,381031,381033,392789,401071,404886,404892,404909,405831,408195,408198,408313,408319,409236,409389,409391,419804,419805,428146,428152,428166,428210,430344,430660,430798,430799,430801,430802,430803,430940,430942,430947,430955,430959,430960,430964,430968,430980,430988,430992,430996,431004,431008,431016,431020,431024,431032,431240,431254,431262,431270,431282,431294,431298,434611,434615,434619,436070,439085,439097,439153,446996,450546,450547,450708,453194,453198,453206,453210,464074,464079,464084,465684,465692,467478,467490,467494,471525,471585,473655,473669,473713,473715,473717,474298,474310,476797,476818,476974,476976,476977,477815,477817,477820,477821,477822,477824,477825,477827,477829,477830,477831,477832,477838,477839,477927,478099,478107,478203,478815,478820,482495,482502,482635,482650,482655,483159,483165,483168,483958,483963,483968,483973,483988,483998,487766,487769,487774,487782,487784,487792,487799,488557,490840,490841,493957,493959,493961,498263,498264,498266,498298,504479,504483,504487,506680,506686,506690,506693,392766,392768,392769,392770,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,312361,312379,312391,372485,472410,472420,472425,492280,492281,492282,492285,492287,492288,492290,492291,492295,408121,480001,471414,482062,482064,482074,317377,413629,413632,434692,434693,434695,434696,464717,464724,464755,464765,477701,478101,478102,478104,478548,478549,478550,478551,478553,478554,478555,494940,494951,494958,498299,498301,2936,207919,284216,326530,341111,408201,436272,441902,453603,456400,456405,470755,470757,477035,477237,477241,477248,477249,482866,485312,501920,501921,503860,503861,503862,471314,471320,471330,471332,283905,286110,286111,317174,325983,350411,350412,350414,350415,413476,413478,413481,413482,413487,413488,413492,413493,413573,413574,434707,434709,434710,434711,478400,478401,478404,478405,478406,483138,483140,483145,483147,498221,498242,499545,499553,507690,507691,478196,479007,479008,481192,481195,481836,481837,481851,481852,341459,431318,431322,432105,432113,432118,441904,441907,441908,465717,497163,497272,497280,498946,503626,503627,503628,503629,503630,503632,34696,87573,138639,138641,182931,237222,317379,364782,364806,364812,395871,411326,411358,411372,411384,411778,417509,418503,433088,441826,449658,449663,449674,464058,470675,470684,471578,475451,476856,477164,477166,478216,481967,485274,485550,488483,493425,493705,497091,498154,498156,499719,500005,500027,503729,503751,22536,83299,85041,95898,138235,158605,172065,172068,176615,188854,192120,192127,192129,192130,192198,192199,193473,193477,193480,248350,253216,259116,263875,271528,273306,277854,286149,292784,292785,292786,293599,299605,308635,308638,309191,309904,309906,317167,317169,317179,326459,330686,332835,333195,334856,335491,335505,335506,335508,335551,335555,338969,339779,348722,349113,349117,349129,349883,349884,350287,350288,350297,350333,364801,373674,376197,376682,376692,385440,385448,385452,385456,395715,411351,411362,411376,411396,411399,411799,413575,413586,413588,413589,413615,415050,415051,415064,418339,418341,418343,418344,418346,418347,418348,418517,418525,418539,430655,430657,430659,435468,435694,435700,435702,435708,436067,436253,436889,436890,436891,449770,470605,470622,470634,470636,470638,470650,470657,470669,470677,471437,471442,471576,472678,475272,475277,475282,475290,475293,475337,475340,475348,475356,475360,475364,475366,475510,475525,475540,475724,476017,476457,476464,476478,476728,476845,476875,476878,476884,476890,476894,476896,476897,476899,476902,476903,476904,476905,476906,476907,476966,476967,476969,476973,477004,477009,477161,477168,477171,478255,478256,478259,478263,478264,478265,478267,478272,478273,481917,481923,481927,481933,481940,481944,481947,481951,481959,481963,481983,481987,481999,482008,483174,483176,483179,485224,485267,485383,485554,488470,488478,488480,488491,488496,488507,488510,488518,488519,488521,488543,490843,490850,490852,490854,490855,490857,490859,490862,490866,493429,493437,497030,497034,497056,497058,497065,497082,497141,497147,498158,498159,498162,498167,498168,498169,498172,498173,498175,498176,498177,498178,498778,498924,499455,499458,499466,500002,500009,500044,500701,500711,500714,500724,500737,500743,500853,500931,500938,500959,500962,500994,501019,501027,501112,501139,501142,501145,501158,501185,502044,502423,502427,502431,502468,502585,502622,502623,502624,502627,502629,502648,502650,502652,502654,502655,502657,502659,502660,502661,502662,502664,502666,502668,502670,502672,502674,502676,502677,502679,502681,502683,502687,502688,503731,503733,503735,503741,503750,503758,503762,503764,503766,503767,503770,505147,505150,505156,505162,505254,507658,507666,507687,508996,417958,417962,417974,480223,480224,480225,493546,493556,497044,478973,493573,493575,497047,497049,497053,499478,503809,503819,507578,507584,507588,343303,474318,474348,500436,500442,416399,416423,416429,459470,459479,391929,391941,391945,391958,391962,402847,404705,406393,407267,407271,407299,407303,407307,409224,409225,409234,409371,413423,413427,413431,413435,431379,432412,432416,434057,434061,434069,434445,434461,434469,434481,435580,435584,435604,435616,435620,435624,435628,435636,435689,435795,435878,435882,435895,435904,435909,435914,436029,436037,436240,436270,436888,440215,440223,440935,440947,450871,450887,459474,459485,460965,460977,464676,464684,464701,464706,464719,473439,473443,473447,473451,473523,477888,477892,477896,477900,477904,478610,478614,478630,478638,478646,441901,459431,459435,484160,484174,485409,485416,485423,485517,108872,108875,135350,135352,135363,191412,191415,191416,191417,403057,427853,428318,408152,471583,481198,481201,481204,481207,481857,509679,459536,471619,471620,488756,488774,488786) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.15016293525696 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,476845,503741,497141,497666,465684,450546,409391,502431,350333,317377,477827,478820,477838,476856,497147,332811,485267,502662,503452,419805,413487) GROUP BY g.id ORDER BY g.ordr desc [0.011134147644043 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,503452,413487,419805) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.0012979507446289 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,503452,413487,419805) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0070178508758545 sec]
SELECT id, name AS name, url FROM pod_filter WHERE id in (3543,14) AND is_active='1' [0.00036787986755371 sec]
SELECT cf.id, cf.info AS info, cf.title AS title, cf.metadesc AS metadesc, cf.seo_text AS seo_text, cf.tagH1 AS tagH1, cf.is_active FROM pod_set_cat_filter cf INNER JOIN pod_filter f ON cf.filter_value_id = f.id WHERE cf.cat_id = 3 AND f.id = '3543' LIMIT 1 [0.00037503242492676 sec]
SELECT cf.id, cf.info AS info, cf.title AS title, cf.metadesc AS metadesc, cf.seo_text AS seo_text, cf.tagH1 AS tagH1, cf.is_active FROM pod_set_cat_subicon cf INNER JOIN pod_sub_icon f ON cf.subicon_id = f.id WHERE cf.cat_id = 3 AND f.url = 'flowers' LIMIT 1 [0.00051188468933105 sec]
SELECT id, name AS name, url, entry FROM pod_cat_category WHERE is_active='1' AND is_hidden='0' AND entry='0' AND super_category_id='1' AND id!='3' ORDER BY ordr [0.00065302848815918 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6; CREATE TEMPORARY TABLE tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6 ( 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_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6 (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 (14,3543) 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.15037178993225 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6; CREATE TEMPORARY TABLE tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00036191940307617 sec]
INSERT IGNORE INTO tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6 p GROUP BY p.filter_id [0.0014350414276123 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_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6 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.00036978721618652 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6 [0.00022506713867188 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43b1ad6 [0.00012779235839844 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa; CREATE TEMPORARY TABLE tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00018501281738281 sec]
INSERT INTO tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa (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 (14,3543) 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.054366827011108 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa; CREATE TEMPORARY TABLE tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00055193901062012 sec]
INSERT IGNORE INTO tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa p GROUP BY p.filter_id [0.0010640621185303 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_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa 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.0005488395690918 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa [0.00038814544677734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43d78fa [0.00019192695617676 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee; CREATE TEMPORARY TABLE tmp_A_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee ( 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.00031399726867676 sec]
INSERT IGNORE INTO tmp_A_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee (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 (14,3543) 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 (14,3543) WHERE 1 ) A [0.12647914886475 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee; CREATE TEMPORARY TABLE tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00040197372436523 sec]
INSERT IGNORE INTO tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee 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.0020668506622314 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee 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.00035405158996582 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee [0.0002291202545166 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_acbh6jhugnhj8l6supjar5i7f9_6a2fcb43e62ee [9.1791152954102E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00016307830810547 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 грн
Постельное белье Matilde Powder сатин-люкс First choice
Постельное белье Matilde Powder сатин-люкс First choice
Код: 413487

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

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

Семейный комплект
Цена:
3 906 грн
Комплект постельного белья Farafenni SoundSleep сатин - 10 %
Комплект постельного белья Farafenni SoundSleep сатин
Код: 419805
delivary icon

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

Цена:
3 816 грн 4 240 грн
1 2 3 4 5 6 7 8 9 10