SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/flanel/gray-hobby-mirson.html' LIMIT 0,1 [0.00089812278747559 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('gray','hobby','mirson') order by url [0.00085806846618652 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('gray','hobby','mirson') order by url [0.0005650520324707 sec]
select id,url from pod_cat_brand where BINARY url IN ('gray','hobby','mirson') [0.0010490417480469 sec]
select id from pod_structure where link='catalogue/104' and active='1' AND lang_ua='1' [0.0002589225769043 sec]
SELECT id, url FROM pod_filter WHERE url IN ('gray','hobby','mirson') [0.00034213066101074 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('gray','hobby','mirson') [0.00086307525634766 sec]
SELECT sc.url, sc.id AS super_category_id, sc.name_ua AS super_category_name, sc.templ_good_title_ua AS templ_good_title, sc.templ_good_kwds, sc.templ_good_desc_ua AS templ_good_desc, sc.templ_brand_title_ua AS templ_brand_title, sc.templ_brand_kwds, sc.templ_brand_desc_ua AS templ_brand_desc, sc.templ_cat_title_ua AS templ_cat_title, sc.templ_cat_kwds, sc.templ_cat_desc_ua AS templ_cat_desc, 1 AS o FROM pod_cat_category c LEFT JOIN pod_super_category sc ON sc.id=c.super_category_id WHERE c.id='3' [0.00037407875061035 sec]
SELECT id FROM pod_cat_category WHERE entry='104' [0.00028419494628906 sec]
SELECT g.id -- основні FROM pod_cat_good g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT g.id -- основні в допкатегорії FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present_all_mods AND g.entry =0 AND g.is_active [0.010592937469482 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2a806fdeebb ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00060510635375977 sec]
INSERT INTO temp_brand_counts_6a2a806fdeebb (id, gid) SELECT g.brand_id AS id, g.id AS gid -- основні FROM pod_cat_good g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE g.cat_id IN (104) AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT g.brand_id AS id, g.id AS gid -- основні в допкатегорії FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT id, null gid FROM pod_cat_category WHERE id in (352,1359) [0.017516136169434 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_6a2a806fdeebb 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.00051093101501465 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2a806fdeebb [0.00024199485778809 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 -- основні FROM pod_cat_good g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT MIN(g.price) AS min_price, MAX(g.price) AS max_price -- основні в допкатегорії FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price -- підтовари FROM pod_cat_good go INNER JOIN pod_cat_good 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) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price -- підтовари в допкатегорії FROM pod_cat_good go INNER JOIN pod_cat_good g ON go.entry = g.id INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0030767917633057 sec]
SELECT g.id, if(g.is_present and g.price >= '5749' and g.price <= '10719',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 >= '5749' and g.price <= '10719',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price FROM pod_cat_good g LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id and pcg.is_present=1 and pcg.is_present=1 and pcg.price >= '5749' and pcg.price <= '10719' WHERE g.id in (471656,471666,471681,494009,494300,494314) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0037481784820557 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 >= '5749' and g.price <= '10719',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 >= '5749' and g.price <= '10719',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 >= '5749' and pcg.price <= '10719') WHERE g.id in (471666,494314,471681,494009,471656,494300) GROUP BY g.id ORDER BY g.ordr desc [0.00223708152771 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.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 = '471656' AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.is_present DESC [0.00045919418334961 sec]
SELECT distinct 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_cat_good g 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_goods_group_goods ggd2 ON ggd2.good_id = 471656 LEFT JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id LEFT JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE g.id=ggd.good_id order by g.id= 471656 desc, g.is_present_all_mods desc [0.00035405158996582 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.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 = '471666' AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.is_present DESC [0.00026202201843262 sec]
SELECT distinct 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_cat_good g 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_goods_group_goods ggd2 ON ggd2.good_id = 471666 LEFT JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id LEFT JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE g.id=ggd.good_id order by g.id= 471666 desc, g.is_present_all_mods desc [0.00032496452331543 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.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 = '471681' AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.is_present DESC [0.00044608116149902 sec]
SELECT distinct 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_cat_good g 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_goods_group_goods ggd2 ON ggd2.good_id = 471681 LEFT JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id LEFT JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE g.id=ggd.good_id order by g.id= 471681 desc, g.is_present_all_mods desc [0.00034809112548828 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.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 = '494009' AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.is_present DESC [0.00030779838562012 sec]
SELECT distinct 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_cat_good g 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_goods_group_goods ggd2 ON ggd2.good_id = 494009 LEFT JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id LEFT JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE g.id=ggd.good_id order by g.id= 494009 desc, g.is_present_all_mods desc [0.000640869140625 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.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 = '494300' AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.is_present DESC [0.00028181076049805 sec]
SELECT distinct 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_cat_good g 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_goods_group_goods ggd2 ON ggd2.good_id = 494300 LEFT JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id LEFT JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE g.id=ggd.good_id order by g.id= 494300 desc, g.is_present_all_mods desc [0.00095987319946289 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.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 = '494314' AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.is_present DESC [0.00031399726867676 sec]
SELECT distinct 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_cat_good g 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_goods_group_goods ggd2 ON ggd2.good_id = 494314 LEFT JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id LEFT JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE g.id=ggd.good_id order by g.id= 494314 desc, g.is_present_all_mods desc [0.00050091743469238 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id in (352,1359) [0.00017905235290527 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id='352.1359' [0.00027108192443848 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010; CREATE TEMPORARY TABLE tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.0003659725189209 sec]
INSERT INTO tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 (id) SELECT A.id FROM ( SELECT g.id -- основні FROM pod_cat_good g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT g.id -- основні в допкатегорії FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present_all_mods AND g.entry =0 AND g.is_active ) A [0.00078701972961426 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010; CREATE TEMPORARY TABLE tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00026702880859375 sec]
INSERT INTO tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 104 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.0045349597930908 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010; CREATE TEMPORARY TABLE tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00042891502380371 sec]
INSERT IGNORE INTO tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 p GROUP BY p.filter_id [0.00040602684020996 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_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 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.0003960132598877 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 [0.00034499168395996 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 [0.00010395050048828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806fed010 [7.4863433837891E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395; CREATE TEMPORARY TABLE tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00032401084899902 sec]
INSERT INTO tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry -- основні FROM pod_cat_good g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT g.id as id, g.id as entry -- основні в допкатегорії FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT go.id as id, g.id as entry -- підтовари FROM pod_cat_good go INNER JOIN pod_cat_good 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) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active UNION SELECT go.id as id, g.id as entry -- підтовари в допкатегорії FROM pod_cat_good go INNER JOIN pod_cat_good g ON go.entry = g.id INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0023479461669922 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395; CREATE TEMPORARY TABLE tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00033903121948242 sec]
INSERT INTO tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 104 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.0011940002441406 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395; CREATE TEMPORARY TABLE tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00026702880859375 sec]
INSERT IGNORE INTO tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 p GROUP BY p.filter_id [0.00030803680419922 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_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 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.00025701522827148 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 [0.00020503997802734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 [0.00010800361633301 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806fef395 [9.7036361694336E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8; CREATE TEMPORARY TABLE tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00024509429931641 sec]
INSERT INTO tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 (id) SELECT A.id FROM ( SELECT g.id -- основні FROM pod_cat_good g USE INDEX (idx_cat_entry_active_present) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT g.id -- основні в допкатегорії FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present_all_mods AND g.entry =0 AND g.is_active ) A [0.0031890869140625 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8; CREATE TEMPORARY TABLE tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00025701522827148 sec]
INSERT INTO tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 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.0058369636535645 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8; CREATE TEMPORARY TABLE tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00036001205444336 sec]
INSERT INTO tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 p GROUP BY p.filter_id [0.00046682357788086 sec]
INSERT IGNORE INTO tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 c ON c.filter_id = pf.id WHERE pf.id in (32) AND c.filter_id IS NULL [0.00028491020202637 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_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 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.00072503089904785 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 [0.00031685829162598 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 [0.00011396408081055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff0be8 [0.00010395050048828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3; CREATE TEMPORARY TABLE tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00028586387634277 sec]
INSERT IGNORE INTO tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3 (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 -- основні FROM pod_cat_good g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT g.id as id, g.id as entry, g.sub_icon_id -- основні в допкатегорії FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND g.is_present AND g.is_present_all_mods AND g.entry =0 AND g.is_active UNION SELECT go.id as id, g.id as entry, go.sub_icon_id -- підтовари FROM pod_cat_good go INNER JOIN pod_cat_good 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) WHERE g.cat_id IN (104) AND g.brand_id IN (352,1359) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active UNION SELECT go.id as id, g.id as entry, go.sub_icon_id -- підтовари в допкатегорії FROM pod_cat_good go INNER JOIN pod_cat_good g ON go.entry = g.id INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) WHERE dc.dop_cat_id IN (104) AND g.brand_id IN (352,1359) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0043990612030029 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3; CREATE TEMPORARY TABLE tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00026607513427734 sec]
INSERT IGNORE INTO tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3 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.00031709671020508 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name_ua AS name, si.url FROM tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3 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.00018620491027832 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3 [0.00014185905456543 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_ard0v1vushs61mntgkg7hphhm1_6a2a806ff3fb3 [7.7009201049805E-5 sec]
Фланелева постільна білизна Hobby ... MirSon (Хoбби ... MірСoн) - великий вибір, фото, відгуки. Купити Фланелева постільна білизна Hobby ... MirSon в Києві і Україні

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

ПЕРЕЙТИ

Фланелева постільна білизна Hobby ... MirSon

Постільна білизна 001-008 Ash grey Pink фланель MirSon - 39 %
Постільна білизна 001-008 Ash grey Pink фланель MirSon
Код: 471656

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

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

Сімейний комплект
16 589 грн 10 119 грн

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

Сімейний комплект
17 573 грн 10 719 грн
(підковдра 143х210 см)
Ціна:
10 119 грн
Постільна білизна 002-005 Black Marengo фланель MirSon - 39 %
Постільна білизна 002-005 Black Marengo фланель MirSon
Код: 471666

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

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

Сімейний комплект
16 589 грн 10 119 грн

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

Сімейний комплект
17 573 грн 10 719 грн
(підковдра 143х210 см)
Ціна:
10 119 грн
Постільна білизна 004-001 Cappuchino Ash grey фланель MirSon - 39 %
Постільна білизна 004-001 Cappuchino Ash grey фланель MirSon
Код: 471681

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

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

Сімейний комплект
16 589 грн 10 119 грн

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

Сімейний комплект
17 573 грн 10 719 грн
(підковдра 143х210 см)
Ціна:
10 119 грн
Постільна білизна 004 Cappuchino фланель MirSon - 39 %
Постільна білизна 004 Cappuchino фланель MirSon
Код: 494009

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

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

Односпальний комплект
9 425 грн 5 749 грн

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

Полуторний комплект
10 655 грн 6 499 грн

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

Двоспальний комплект
11 114 грн 6 779 грн
Показати більше
Ціна:
5 749 грн 9 425 грн
Постільна білизна 001 Ash Grey фланель MirSon - 39 %
Постільна білизна 001 Ash Grey фланель MirSon
Код: 494300

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

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

Односпальний комплект
9 425 грн 5 749 грн

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

Полуторний комплект
10 655 грн 6 499 грн

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

Двоспальний комплект
11 114 грн 6 779 грн
Показати більше
Ціна:
5 749 грн 9 425 грн
Постільна білизна 005 Marengo фланель MirSon - 39 %
Постільна білизна 005 Marengo фланель MirSon
Код: 494314

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

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

Односпальний комплект
9 425 грн 5 749 грн

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

Полуторний комплект
10 655 грн 6 499 грн

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

Двоспальний комплект
11 114 грн 6 779 грн
Показати більше
Ціна:
5 749 грн 9 425 грн