SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/tensel/black-gray-nav5070.html' LIMIT 0,1 [0.00070095062255859 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('black','gray','nav5070') order by url [0.0019781589508057 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('black','gray','nav5070') order by url [0.0014829635620117 sec]
select id from pod_structure where link='catalogue/103' and active='1' AND lang_ua='1' [0.00041890144348145 sec]
SELECT id, url FROM pod_filter WHERE url IN ('black','gray','nav5070') [0.00032496452331543 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('black','gray','nav5070') [0.00026392936706543 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='103' [0.00023484230041504 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.00025200843811035 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 (103) 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 (103) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.0086929798126221 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.00021696090698242 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.0017049312591553 sec]
SELECT g.id -- основні (tmp) FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (25,32) 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 -- підтовари (tmp) 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 (25,32) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 [0.0084600448608398 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2ad89a9ccb8 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00036907196044922 sec]
INSERT INTO temp_brand_counts_6a2ad89a9ccb8 (id, gid) SELECT g.brand_id AS id, g.id AS gid -- основні (tmp) FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (25,32) 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 -- підтовари (tmp) 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 (25,32) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 [0.00091195106506348 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_6a2ad89a9ccb8 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.00036096572875977 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2ad89a9ccb8 [9.3936920166016E-5 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 -- основні (tmp) FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (25,32) 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 -- підтовари (tmp) 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 (25,32) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 ) A [0.00057291984558105 sec]
SELECT g.id,if(g.is_present and g.price >= '3818' and g.price <= '17899',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 >= '3818' and g.price <= '17899',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 >= '3818' AND pcg.price <= '17899' WHERE g.id IN (462004,479008,481836,485738,485739,487944,488024,488084,488124,498039) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0019731521606445 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 >= '3818' and g.price <= '17899',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 >= '3818' and g.price <= '17899',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 >= '3818' and pcg.price <= '17899') WHERE g.id in (488024,485738,488084,462004,485739,488124,479008,487944,498039,481836) GROUP BY g.id ORDER BY g.ordr desc [0.0028319358825684 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 (462004,479008,481836,485738,485739,487944,488024,488084,488124,498039) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00087690353393555 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 (462004,479008,481836,485738,485739,487944,488024,488084,488124,498039) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0018661022186279 sec]
SELECT id, name_ua AS name, url FROM pod_filter WHERE id in (25,32,2885) AND is_active='1' [0.00026512145996094 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 = 103 AND f.id = '25' LIMIT 1 [0.00068807601928711 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 = 103 AND f.url = 'black' LIMIT 1 [0.00026297569274902 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='103' ORDER BY p.dt DESC LIMIT 1 [0.0036818981170654 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!='103' ORDER BY ordr [0.00058197975158691 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99; CREATE TEMPORARY TABLE tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.0002601146697998 sec]
INSERT INTO tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 (id) SELECT A.id FROM ( SELECT g.id -- основні (tmp) FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (25,32) 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 -- підтовари (tmp) 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 (25,32) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 ) A [0.00099992752075195 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99; CREATE TEMPORARY TABLE tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00019407272338867 sec]
INSERT INTO tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (25,32,2885) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 103 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.01093602180481 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99; CREATE TEMPORARY TABLE tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00025105476379395 sec]
INSERT IGNORE INTO tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 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_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 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.00028896331787109 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 [0.00014996528625488 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 [6.103515625E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa3a99 [6.6995620727539E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8; CREATE TEMPORARY TABLE tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00029110908508301 sec]
INSERT INTO tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry -- основні (tmp) FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (25,32) 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 -- підтовари (tmp) 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 (25,32) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 ) A [0.0011508464813232 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8; CREATE TEMPORARY TABLE tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00029301643371582 sec]
INSERT INTO tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (25,32,2885) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 103 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.00079989433288574 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8; CREATE TEMPORARY TABLE tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00033402442932129 sec]
INSERT IGNORE INTO tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 p GROUP BY p.filter_id [0.00021791458129883 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_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 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.00018095970153809 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 [0.00023603439331055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 [0.00011205673217773 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa74e8 [8.9168548583984E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c; CREATE TEMPORARY TABLE tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00021195411682129 sec]
INSERT INTO tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c (id) SELECT A.id FROM ( SELECT g.id -- основні (tmp) 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 -- підтовари (tmp) 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.0010209083557129 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c; CREATE TEMPORARY TABLE tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00024104118347168 sec]
INSERT INTO tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c 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.0028650760650635 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c; CREATE TEMPORARY TABLE tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0003960132598877 sec]
INSERT INTO tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c p GROUP BY p.filter_id [0.00038790702819824 sec]
INSERT IGNORE INTO tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c c ON c.filter_id = pf.id WHERE pf.id in (25,32) AND c.filter_id IS NULL [0.00038599967956543 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_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c 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.00051021575927734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c [0.0003809928894043 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c [0.00018501281738281 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aa8b7c [0.00020909309387207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea; CREATE TEMPORARY TABLE tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00017118453979492 sec]
INSERT INTO tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry -- основні (tmp) FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (25,32) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry -- підтовари (tmp) 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 (25,32) WHERE 1 ) A [0.0008389949798584 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea; CREATE TEMPORARY TABLE tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.00024509429931641 sec]
INSERT INTO tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea 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.0025639533996582 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea; CREATE TEMPORARY TABLE tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00023984909057617 sec]
INSERT INTO tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea p GROUP BY p.filter_id [0.00022101402282715 sec]
INSERT INTO tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea c ON c.filter_id = pf.id WHERE pf.id in (2885) AND c.filter_id IS NULL [0.0001671314239502 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_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea 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.00021004676818848 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea [0.00031590461730957 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea [0.00013017654418945 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aaadea [0.00014519691467285 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f; CREATE TEMPORARY TABLE tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.0003960132598877 sec]
INSERT IGNORE INTO tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f (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 -- основні (tmp) FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (25,32) 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 -- підтовари (tmp) 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 (25,32) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (2885) WHERE 1 ) A [0.0021069049835205 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f; CREATE TEMPORARY TABLE tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00039315223693848 sec]
INSERT IGNORE INTO tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f 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.00058412551879883 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name_ua AS name, si.url FROM tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f 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.00044989585876465 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f [0.00022482872009277 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_hlqo2m6spr7qh1l9uo0qb2ilsr_6a2ad89aac75f [0.00010514259338379 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.0002291202545166 sec]
Тенсел постільна білизна - купити постільну білизну з тенсела Чорний, Сірий, наволочки 50х70 см в Україні, ціна в каталозі інтернет магазину Podushka.com.ua

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

ПЕРЕЙТИ

Тенсел постільна білизна : чорний, сірий, наволочки 50х70 см

Постільна білизна Teofilo Beige тенсел Luxury Linens
Постільна білизна Teofilo Beige тенсел Luxury Linens
Код: 462004

Виробник: LUXURY LINENS (Испания)

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

Сімейний комплект
14 050 грн
Ціна:
9 234 грн
Постільна білизна Лепато тенсел Home Line
Постільна білизна Лепато тенсел Home Line
Код: 479008

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

Ціна:
4 074 грн
Постільна білизна Т-02 тенсел Вілюта
Постільна білизна Т-02 тенсел Вілюта
Код: 481836

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

Ціна:
3 818 грн
Постільна білизна Imperial Tencel 06 Gray MirSon з вишивкою - 30 %
Постільна білизна Imperial Tencel 06 Gray MirSon з вишивкою
Код: 485738

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

Ціна:
17 899 грн 25 570 грн
Постільна білизна Imperial Tencel 05 Sea wave MirSon з вишивкою - 30 %
Постільна білизна Imperial Tencel 05 Sea wave MirSon з вишивкою
Код: 485739

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

Ціна:
17 899 грн 25 570 грн
Комплект постільної білизни Aura ліоцелл Pagoti антрацитовий
Комплект постільної білизни Aura ліоцелл Pagoti антрацитовий
Код: 487944

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

Полуторний комплект (2 наволочки 50х70 см)

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

Полуторний комплект (2 наволочки 70х70 см)

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

Полуторний комплект (4 наволочки 50х70 см)

Полуторний комплект
Показати більше
Ціна:
5 299 грн
Комплект постільної білизни Aura ліоцелл Pagoti темно-сірий
Комплект постільної білизни Aura ліоцелл Pagoti темно-сірий
Код: 488024

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

Полуторний комплект (2 наволочки 50х70 см)

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

Полуторний комплект (2 наволочки 70х70 см)

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

Полуторний комплект (4 наволочки 50х70 см)

Полуторний комплект
Показати більше
Ціна:
5 299 грн
Комплект постільної білизни Aura ліоцелл Pagoti світло-сірий
Комплект постільної білизни Aura ліоцелл Pagoti світло-сірий
Код: 488084

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

Полуторний комплект (2 наволочки 50х70 см)

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

Полуторний комплект (2 наволочки 70х70 см)

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

Полуторний комплект (4 наволочки 50х70 см)

Полуторний комплект
Показати більше
Ціна:
5 299 грн
Комплект постільної білизни Aura ліоцелл Pagoti чорний
Комплект постільної білизни Aura ліоцелл Pagoti чорний
Код: 488124

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

Полуторний комплект (2 наволочки 50х70 см)

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

Полуторний комплект (2 наволочки 70х70 см)

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

Полуторний комплект (4 наволочки 50х70 см)

Полуторний комплект
Показати більше
Ціна:
5 299 грн
Постільна білизна Tencel 06 Gray MirSon - 40 %
Постільна білизна Tencel 06 Gray MirSon
Код: 498039

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

Односпальний комплект (підковдра 143х210 см)

Односпальний комплект
16 699 грн 10 019 грн

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

Полуторний комплект
17 999 грн 10 799 грн

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

Двоспальний комплект
18 482 грн 11 089 грн
Показати більше
Ціна:
10 019 грн 16 699 грн