SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/stonewash/gray-turquoise-nav5070.html' LIMIT 0,1 [0.0004119873046875 sec]
select id,name,url, is_active from pod_cat_category where url = 'stonewash' [0.00042390823364258 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('gray','turquoise','nav5070') order by url [0.0016388893127441 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('gray','turquoise','nav5070') order by url [0.0011379718780518 sec]
select id from pod_structure where link='catalogue/2078' and active='1' AND lang_ua='1' [0.00030207633972168 sec]
SELECT id, url FROM pod_filter WHERE url IN ('gray','turquoise','nav5070') [0.00058293342590332 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('gray','turquoise','nav5070') [0.0005040168762207 sec]
SELECT c.id, c.super_category_id, c.entry, c.name_ua AS name, c.title_ua AS cat_title, c.metakwds AS cat_kwds, c.metadesc_ua AS cat_metadesc, c.descr_ua AS cat_descr, cc.name_ua AS parent_name, cc.url AS parent_url, c.url as curl, cc.image AS parent_image, c.seo_text_ua AS seo_text, c.seo_text_mobile_ua AS seo_text_mobile, c.action_text_ua AS action_text, c.view_type, c.is_delivery_custom, c.hide_subcat_sidebar, c.image FROM pod_cat_category c LEFT JOIN pod_cat_category cc ON cc.id=c.entry WHERE c.id='2078' [0.00037717819213867 sec]
SELECT id FROM pod_cat_category WHERE entry='2078' [0.00023794174194336 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.00031805038452148 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 (2078) 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 (2078) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.015594005584717 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.00020909309387207 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.0031001567840576 sec]
SELECT g.id /* cats:2078 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,117) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE g.is_present AND 1 UNION SELECT g.id /* cats:2078 */ 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 (32,117) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 [0.010615825653076 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b3d8f6dfed ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00027704238891602 sec]
INSERT INTO temp_brand_counts_6a2b3d8f6dfed (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:2078 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,117) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE g.is_present AND 1 UNION SELECT g.brand_id AS id, g.id AS gid /* cats:2078 */ 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 (32,117) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 [0.0024900436401367 sec]
SELECT b.id, b.name_ua AS name, pc.name_ua 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_6a2b3d8f6dfed 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.0006258487701416 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b3d8f6dfed [0.00012803077697754 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:2078 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,117) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:2078 */ 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 (32,117) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 ) A [0.0016138553619385 sec]
SELECT g.id /* cats:2078 */,if(g.is_present and g.price >= '1456' and g.price <= '7059',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 >= '1456' and g.price <= '7059',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 >= '1456' AND pcg.price <= '7059' WHERE g.id IN (239385,393763,404876,428323,436667,436673,459088,493847,498014,502712,503672,503678,507566,509007,509025,509575,509576,509617,509623,433353,471549,475494,475503) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0028450489044189 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_ua AS name, g.name2_ua 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_ua AS brand_name,b.url as burl,b.id as bid, b.country AS brand_country,c.url as curl, c.name_ua AS cat_name, si.name_ua AS sub_icon_name,si.icon AS sub_icon, g.star, g.comment_id, if(g.is_present and g.price >= '1456' and g.price <= '7059',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 >= '1456' and g.price <= '7059',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 >= '1456' and pcg.price <= '7059') WHERE g.id in (239385,393763,404876,428323,507566,475494,509576,502712,436673,509007,475503,509617,503672,459088,509025,493847,433353,509623,503678,471549,509575,498014,436667) GROUP BY g.id ORDER BY g.ordr desc [0.0020971298217773 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_ua AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name_ua 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 (239385,393763,404876,428323,433353,436667,436673,459088,471549,475494,475503,493847,509007,498014,509025,502712,509575,503672,509576,503678,509617,507566,509623) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00038504600524902 sec]
SELECT DISTINCT ggd2.good_id AS source_good_id, g.id, g.is_present_all_mods, pc.name_ua 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 (239385,393763,404876,428323,433353,436667,436673,459088,471549,475494,475503,493847,509007,498014,509025,502712,509575,503672,509576,503678,509617,507566,509623) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0051290988922119 sec]
SELECT id, name_ua AS name, url FROM pod_filter WHERE id in (32,2885,117) AND is_active='1' [0.00014901161193848 sec]
SELECT cf.id, cf.info_ua AS info, cf.title_ua AS title, cf.metadesc_ua AS metadesc, cf.seo_text_ua AS seo_text, cf.tagH1_ua 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 = 2078 AND f.id = '32' LIMIT 1 [0.00014615058898926 sec]
SELECT cf.id, cf.info_ua AS info, cf.title_ua AS title, cf.metadesc_ua AS metadesc, cf.seo_text_ua AS seo_text, cf.tagH1_ua 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 = 2078 AND f.url = 'gray' LIMIT 1 [0.00017905235290527 sec]
SELECT p.id, p.dt, p.title_ua as title, p.descr, p.thumb, p.url, s.link FROM pod_publication p LEFT JOIN pod_pub_type pt ON pt.id=p.rub_id LEFT JOIN pod_structure s ON pt.page_id=s.id LEFT JOIN pod_cat_public cp ON (cp.public_id = p.id) WHERE p.rub_id = 2 AND p.active='1' AND cp.category_id='2078' ORDER BY p.dt DESC LIMIT 1 [0.0054678916931152 sec]
SELECT id, name_ua 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!='2078' ORDER BY ordr [0.00076007843017578 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f; CREATE TEMPORARY TABLE tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00026917457580566 sec]
INSERT INTO tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f (id) SELECT A.id FROM ( SELECT g.id /* cats:2078 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,117) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE g.is_present AND 1 UNION SELECT g.id /* cats:2078 */ 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 (32,117) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 ) A [0.001460075378418 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f; CREATE TEMPORARY TABLE tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00026202201843262 sec]
INSERT INTO tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32,117,2885) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 2078 INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.0099070072174072 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f; CREATE TEMPORARY TABLE tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00027084350585938 sec]
INSERT IGNORE INTO tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f p GROUP BY p.filter_id [0.00026798248291016 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f 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.00038504600524902 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f [0.0002589225769043 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f [0.00011706352233887 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7597f [0.00011897087097168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6; CREATE TEMPORARY TABLE tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00022697448730469 sec]
INSERT INTO tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:2078 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,117) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:2078 */ 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 (32,117) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 ) A [0.001349925994873 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6; CREATE TEMPORARY TABLE tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00029897689819336 sec]
INSERT INTO tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32,117,2885) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 2078 INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.0018661022186279 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6; CREATE TEMPORARY TABLE tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00029301643371582 sec]
INSERT IGNORE INTO tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 p GROUP BY p.filter_id [0.00060081481933594 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 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.00041890144348145 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 [0.00025320053100586 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 [0.00011777877807617 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f792c6 [0.00014805793762207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2; CREATE TEMPORARY TABLE tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00023412704467773 sec]
INSERT INTO tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 (id) SELECT A.id FROM ( SELECT g.id /* cats:2078 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (2885) WHERE g.is_present AND 1 UNION SELECT g.id /* cats:2078 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (2885) WHERE 1 ) A [0.0021741390228271 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2; CREATE TEMPORARY TABLE tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00029897689819336 sec]
INSERT INTO tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 20 INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.0055739879608154 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2; CREATE TEMPORARY TABLE tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00040507316589355 sec]
INSERT INTO tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 p GROUP BY p.filter_id [0.00043797492980957 sec]
INSERT IGNORE INTO tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 c ON c.filter_id = pf.id WHERE pf.id in (32,117) AND c.filter_id IS NULL [0.00034499168395996 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 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.00042295455932617 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 [0.00028300285339355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 [0.00012087821960449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7afa2 [0.00010991096496582 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0; CREATE TEMPORARY TABLE tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00025081634521484 sec]
INSERT INTO tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:2078 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,117) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:2078 */ 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 (32,117) WHERE 1 ) A [0.0015718936920166 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0; CREATE TEMPORARY TABLE tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.00034713745117188 sec]
INSERT INTO tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 2883 INNER JOIN pod_filter fm ON gf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active [0.0070860385894775 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0; CREATE TEMPORARY TABLE tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00024509429931641 sec]
INSERT INTO tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 p GROUP BY p.filter_id [0.0002140998840332 sec]
INSERT INTO tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 c ON c.filter_id = pf.id WHERE pf.id in (2885) AND c.filter_id IS NULL [0.00015997886657715 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 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.0001680850982666 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 [0.00016593933105469 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 [0.00010800361633301 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f7dfc0 [8.2015991210938E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a; CREATE TEMPORARY TABLE tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00015020370483398 sec]
INSERT IGNORE INTO tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a (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:2078 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,117) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:2078 */ 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 (32,117) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 ) A [0.00078105926513672 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a; CREATE TEMPORARY TABLE tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00019407272338867 sec]
INSERT IGNORE INTO tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a 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.00029206275939941 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name_ua AS name, si.url FROM tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a 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.00020408630371094 sec]
----------------------------- SELECT COUNT(*) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.00029611587524414 sec]
Array ( [0] => Array ( [COUNT(*)] => 328 ) ) SELECT COUNT(DISTINCT filter_id) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.00049400329589844 sec]
Array ( [0] => Array ( [COUNT(DISTINCT filter_id)] => 4 ) ) ----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a [0.00020909309387207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_11fubiu04i6vt19pa72bju89ge_6a2b3d8f80d9a [7.5101852416992E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00011610984802246 sec]
Постільну білизну варена бавовна stonewash купити в Україні та Києві за вигідною ціною в Podushka
UA
RU
Вхід в кабінет

DEVELOPMENT🌷ЗНИЖКИ ДО 70%

ПЕРЕЙТИ
Магазин PODUSHKA ®
  1. Магазин PODUSHKA ®
  2. Домашній текстиль Домашній текстиль
  3. Постільна білизна Постільна білизна
  4. Постільна білизна варена бавовна stonewash Постільна білизна варена бавовна stonewash

Постільна білизна варена бавовна stonewash : сірий, бірюзовий/аквамариновий, наволочки 50х70 см

Знайдено 23 товари
Ви вибрали
Очистити всі фільтри
Постільна білизна
Матеріал:
Виробник
SoundSleep (3)
Вілюта (3)
MirSon (1)
Love You (2)
Lotus Home (1)
Більше виробників
Розумні фільтри
Зі знижкою!
Швидка доставка
Новинка
Розпродаж
Розмір
Односпальний комплект (5)
Полуторний комплект (3)
Двоспальний євро комплект (13)
Сімейний комплект (9)
Двоспальний комплект (4)
Двоспальний євро комплект King Size (1)
Показати більше
Основний колір
Білий/Молочний (17)
Бежевий/Кремовий (2)
Синій/Блакитний (13)
Червоний/Бордовий (1)
Фіолетовий/Бузковий (1)
Рожевий/Пудра (8)
Сірий (22)
Коричневий (1)
Зелений/Салатовий (14)
Бірюзовий/Аквамариновий (2)
Помаранчевий/Абрикосовий (1)
Жовтий/Пісочний (2)
Хакі (1)
Показати більше
Тип застібки
на блискавці (12)
на ґудзиках (4)
Розмір підковдри
145х210 см односпальний (3)
160х220 см полуторний (2)
175х215 см двоспальний (3)
200х220 см двоспальний євро (12)
Наволочки в комплекті
наволочки 50х70 см (23)
Ціна
—
грн

Дивіться також
Сортувати:
За популярністю
Вибрати виробника
Комплект постільної білизни SoundSleep Stonewash Adriatic dark gray темно-сірий - 20 %
star line
5
Комплект постільної білизни SoundSleep Stonewash Adriatic dark gray темно-сірий
Код: 239385
delivary icon

Виробник: SoundSleep (Украина)

Сімейний комплект

Сімейний комплект
7 462 грн 5 970 грн
В 1 клік Купити
Ціна:
4 974 грн 6 217 грн
Комплект постільної білизни SoundSleep Stonewash TOMMY LIGHT світло-сірий - 10 %
star line
3
Комплект постільної білизни SoundSleep Stonewash TOMMY LIGHT світло-сірий
Код: 393763
delivary icon

Виробник: SoundSleep (Украина)

Ціна:
4 960 грн 5 511 грн
Постільна білизна Love You варена бавовна сірий
Постільна білизна Love You варена бавовна сірий
Код: 404876

Виробник: Love You (КНР)

Сімейний комплект

Сімейний комплект
5 653 грн
В 1 клік Купити
Ціна:
4 610 грн
Постільна білизна WC01 варена бавовна Love You
Постільна білизна WC01 варена бавовна Love You
Код: 428323

Виробник: Love You (КНР)

Сімейний комплект

Сімейний комплект
5 408 грн
В 1 клік Купити
Ціна:
4 179 грн
Постільна білизна Wash 65 варена бавовна Tiare
Постільна білизна Wash 65 варена бавовна Tiare
Код: 433353

Виробник: Tiare (Украина)

Односпальний комплект

Односпальний комплект
1 456 грн
В 1 клік Купити

Сімейний комплект

Сімейний комплект
2 341 грн
В 1 клік Купити
Ціна:
1 456 грн
Постільна білизна W-0019 варена бавовна Bella Villa
Постільна білизна W-0019 варена бавовна Bella Villa
Код: 436667

Виробник: Bella Villa (КНР)

Ціна:
3 221 грн
Постільна білизна W-0016 варена бавовна Bella Villa
Постільна білизна W-0016 варена бавовна Bella Villa
Код: 436673

Виробник: Bella Villa (КНР)

Ціна:
3 221 грн
Постільна білизна Rebeca бавовна Lotus Home сірий
Постільна білизна Rebeca бавовна Lotus Home сірий
Код: 459088

Виробник: Lotus Home (Украина)

Сімейний комплект

Сімейний комплект
5 428 грн
В 1 клік Купити
Ціна:
4 323 грн
Постільна білизна Wash 78 варена бавовна Tiare
Постільна білизна Wash 78 варена бавовна Tiare
Код: 471549

Виробник: Tiare (Украина)

Односпальний комплект

Односпальний комплект
1 456 грн
В 1 клік Купити

Сімейний комплект

Сімейний комплект
2 341 грн
В 1 клік Купити
Ціна:
1 456 грн
Постільна білизна Wash 37 варена бавовна Tiare
Постільна білизна Wash 37 варена бавовна Tiare
Код: 475494

Виробник: Tiare (Украина)

Односпальний комплект

Односпальний комплект
1 456 грн
В 1 клік Купити
Ціна:
1 456 грн
Постільна білизна Wash 69 варена бавовна Tiare
Постільна білизна Wash 69 варена бавовна Tiare
Код: 475503

Виробник: Tiare (Украина)

Односпальний комплект

Односпальний комплект
1 456 грн
В 1 клік Купити
Ціна:
1 456 грн
Постільна білизна Wash 84 варена бавовна Tiare
Постільна білизна Wash 84 варена бавовна Tiare
Код: 493847

Виробник: Tiare (Украина)

Сімейний комплект

Сімейний комплект
2 341 грн
В 1 клік Купити
Ціна:
1 456 грн
Постільна білизна Armen Charcoal варена бавовна La Maison Новинка
Постільна білизна Armen Charcoal варена бавовна La Maison
Код: 509007

Виробник: La Maison (Турция)

Ціна:
5 418 грн
Постільна білизна 40-0022 Enchanted Evening варена бавовна MirSon - 49 %
Постільна білизна 40-0022 Enchanted Evening варена бавовна MirSon
Код: 498014

Виробник: MirSon (Украина)

Полуторний комплект (підковдра 160х220 см)

Полуторний комплект
9 979 грн 5 089 грн
В 1 клік Купити

Двоспальний євро комплект King Size

Двоспальний євро комплект King Size
13 842 грн 7 059 грн
В 1 клік Купити
Ціна:
5 089 грн 9 979 грн
Постільна білизна Mariella Charcoal варена бавовна La Maison Новинка
Постільна білизна Mariella Charcoal варена бавовна La Maison
Код: 509025

Виробник: La Maison (Турция)

Ціна:
3 969 грн
Набір комплект постільної білизни SoundSleep Stonewash Tommy dark сірий + в подарунок кухонні махрові рушники турецькі жаккардові 2 шт
star line
1
Набір комплект постільної білизни SoundSleep Stonewash Tommy dark сірий + в подарунок кухонні махрові рушники турецькі жаккардові 2 шт
Код: 502712

Виробник: SoundSleep (Украина)

Двоспальний євро комплект + набір з 2 рушників

Двоспальний євро комплект
5 447 грн
В 1 клік Купити
Ціна:
5 447 грн
Постільна білизна Ruba Stone-Crystal варена бавовна La Maison Новинка
Постільна білизна Ruba Stone-Crystal варена бавовна La Maison
Код: 509575

Виробник: La Maison (Турция)

Ціна:
4 284 грн
Постільна білизна Wash Printed 08 варена бавовна Вілюта
Постільна білизна Wash Printed 08 варена бавовна Вілюта
Код: 503672

Виробник: Вілюта (Украина)

Двоспальний євро комплект

Двоспальний євро комплект
2 034 грн
В 1 клік Купити

Сімейний комплект

Сімейний комплект
2 455 грн
В 1 клік Купити
Ціна:
1 800 грн
Постільна білизна Ruba Stone-Mist green варена бавовна La Maison Новинка
Постільна білизна Ruba Stone-Mist green варена бавовна La Maison
Код: 509576

Виробник: La Maison (Турция)

Ціна:
4 284 грн
Постільна білизна Wash Printed 11 варена бавовна Вілюта
Постільна білизна Wash Printed 11 варена бавовна Вілюта
Код: 503678

Виробник: Вілюта (Украина)

Сімейний комплект

Сімейний комплект
2 455 грн
В 1 клік Купити
Ціна:
1 800 грн
Постільна білизна Weens Charcoal варена бавовна La Maison Новинка
Постільна білизна Weens Charcoal варена бавовна La Maison
Код: 509617

Виробник: La Maison (Турция)

Ціна:
4 725 грн
Постільна білизна Wash Printed 09 варена бавовна Вілюта Новинка
Постільна білизна Wash Printed 09 варена бавовна Вілюта
Код: 507566

Виробник: Вілюта (Украина)

Сімейний комплект

Сімейний комплект
2 455 грн
В 1 клік Купити
Ціна:
1 800 грн
Постільна білизна Weens Stone варена бавовна La Maison Новинка
Постільна білизна Weens Stone варена бавовна La Maison
Код: 509623

Виробник: La Maison (Турция)

Ціна:
4 725 грн