SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/pledy/blue-odnotonnye-simvoly.html' LIMIT 0,1 [0.00047898292541504 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('blue','odnotonnye','simvoly') order by url [0.0016741752624512 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('blue','odnotonnye','simvoly') order by url [0.0012540817260742 sec]
SELECT id, url FROM pod_filter WHERE url IN ('blue','odnotonnye','simvoly') [0.00076508522033691 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('blue','odnotonnye','simvoly') [0.00051999092102051 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 (23,2524,2530) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00041389465332031 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.00042510032653809 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 (11,33,55,61,84,94,101,163,162,206,212,290,291,328,59,60,2380,571,194,295,317,542) 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 (11,33,55,61,84,94,101,163,162,206,212,290,291,328,59,60,2380,571,194,295,317,542) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.084160089492798 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.00043511390686035 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.0098159313201904 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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) WHERE 1 [0.024260997772217 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2acb8553475 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00098896026611328 sec]
INSERT INTO temp_brand_counts_6a2acb8553475 (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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) WHERE 1 [0.0030310153961182 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_6a2acb8553475 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.00082802772521973 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2acb8553475 [0.0002129077911377 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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) 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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) WHERE 1 ) A [0.0026378631591797 sec]
SELECT g.id, if(g.is_present and g.price >= '471' and g.price <= '5227',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 >= '471' and g.price <= '5227',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 >= '471' and pcg.price <= '5227' WHERE g.id in (270787,418386,509637,217995,237845,286103,454854,432285,446607,467774,503977,278701,286107,391444,400981,409487,414484,476264,393634,490939,498342,393595,454925,478679,404803) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0036649703979492 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 >= '471' and g.price <= '5227',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 >= '471' and g.price <= '5227',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 >= '471' and pcg.price <= '5227') WHERE g.id in (503977,418386,404803,286107,237845,278701,286103,217995,270787,391444,432285,467774,498342,393595,409487,446607,476264,393634,414484,454854,478679,509637,400981,454925,490939) GROUP BY g.id ORDER BY g.ordr desc [0.0017671585083008 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 (503977,418386,404803,286107,237845,278701,286103,217995,270787,391444,393595,393634,400981,409487,414484,432285,446607,454854,454925,467774,476264,478679,490939,498342,509637) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00066995620727539 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 (503977,418386,404803,286107,237845,278701,286103,217995,270787,391444,393595,393634,400981,409487,414484,432285,446607,454854,454925,467774,476264,478679,490939,498342,509637) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0066978931427002 sec]
SELECT id, name AS name, url FROM pod_filter WHERE id in (23,2524,2530) AND is_active='1' [0.00024294853210449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb; CREATE TEMPORARY TABLE tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00029993057250977 sec]
INSERT INTO tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb (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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) WHERE 1 ) A [0.0012941360473633 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb; CREATE TEMPORARY TABLE tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00022697448730469 sec]
INSERT INTO tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (23,2524,2530) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 11 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.01387095451355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb; CREATE TEMPORARY TABLE tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0005040168762207 sec]
INSERT IGNORE INTO tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb p GROUP BY p.filter_id [0.00046706199645996 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_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb 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.00045204162597656 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb [0.00034403800964355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb [0.00017404556274414 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb855c3eb [0.00013589859008789 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5; CREATE TEMPORARY TABLE tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.0002741813659668 sec]
INSERT INTO tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 (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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) 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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) WHERE 1 ) A [0.0034759044647217 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5; CREATE TEMPORARY TABLE tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.0004420280456543 sec]
INSERT INTO tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (23,2524,2530) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 11 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.0027749538421631 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5; CREATE TEMPORARY TABLE tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0003669261932373 sec]
INSERT IGNORE INTO tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 p GROUP BY p.filter_id [0.00041007995605469 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_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 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_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 [0.00031614303588867 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 [0.00015807151794434 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8560ef5 [0.0001518726348877 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 (2524,2530) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00055384635925293 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5; CREATE TEMPORARY TABLE tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00043606758117676 sec]
INSERT INTO tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 (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 (2524,2530) WHERE 1 ) A [0.0044219493865967 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5; CREATE TEMPORARY TABLE tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00045084953308105 sec]
INSERT INTO tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 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.015228033065796 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5; CREATE TEMPORARY TABLE tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00054001808166504 sec]
INSERT INTO tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 p GROUP BY p.filter_id [0.00047612190246582 sec]
INSERT IGNORE INTO tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 c ON c.filter_id = pf.id WHERE pf.id in (23) AND c.filter_id IS NULL [0.00027608871459961 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_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 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.00043916702270508 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 [0.00027894973754883 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 [0.00011897087097168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8563bb5 [0.00011610984802246 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92; CREATE TEMPORARY TABLE tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00028491020202637 sec]
INSERT INTO tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 (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 (23) WHERE 1 ) A [0.0043671131134033 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92; CREATE TEMPORARY TABLE tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00038290023803711 sec]
INSERT INTO tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 2521 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.012531042098999 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92; CREATE TEMPORARY TABLE tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00027012825012207 sec]
INSERT INTO tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 p GROUP BY p.filter_id [0.0002748966217041 sec]
INSERT IGNORE INTO tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 c ON c.filter_id = pf.id WHERE pf.id in (2524,2530) AND c.filter_id IS NULL [0.00023293495178223 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_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 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.00022411346435547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 [0.00030612945556641 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 [9.8943710327148E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb8569d92 [8.2015991210938E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18; CREATE TEMPORARY TABLE tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00020599365234375 sec]
INSERT IGNORE INTO tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18 (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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) 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 (23) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (2524,2530) WHERE 1 ) A [0.001507043838501 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18; CREATE TEMPORARY TABLE tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00023698806762695 sec]
INSERT IGNORE INTO tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18 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.00032806396484375 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18 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.00016498565673828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18 [0.00015783309936523 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1f9iaoqsbub7i5uplhqbgslifn_6a2acb856ef18 [7.2002410888672E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00015401840209961 sec]
Пледы Синий/Голубой, однотонные, символы купить в Украине и Киеве, цена в каталоге интернет-магазина Podushka.com.ua
UA
RU
Вход в кабинет

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

ПЕРЕЙТИ
Магазин PODUSHKA ®
  1. Магазин PODUSHKA ®
  2. Домашний текстиль Домашний текстиль
  3. Пледы Пледы

Пледы : синий/голубой, однотонные, символы

Какой выбрать плед?
Найдено 25 товаров
Вы выбрали
Очистить все фильтры
Пледы
Производитель
SoundSleep (1)
MirSon (2)
Прованс (5)
Love You (3)
Home line (1)
Больше производителей
Умные фильтры
Со скидкой!
Быстрая доставка
Новинка
Распродажа
Основной цвет
Белый/Молочный (9)
Бежевый/Кремовый (27)
Синий/Голубой (25)
Красный/Бордовый (8)
Фиолетовый/Сиреневый (2)
Розовый/Пудровый (14)
Серый (40)
Коричневый (16)
Зеленый/Салатовый (11)
Бирюзовый/Аквамариновый (3)
Оранжевый/Абрикосовый (4)
Черный (3)
Желтый/Песочный (1)
Хаки (3)
Показать больше
Размер пледа
размер 110х150 (±10) см (1)
размер 110х170 (±10) см (1)
размер 130х170 (±10) см (4)
размер 130х200 (±10) см (1)
размер 140х180 (±10) см (4)
размер 140х200 (±10) см (2)
размер 150х200 (±10) см (5)
размер 160х220 (±10) см (1)
размер 170х210 (±10) см (1)
размер 180х220 (±10) см (2)
размер 200х220 (±10) см (7)
размер 200х240 (±10) см (1)
Показать больше
Тип рисунка
цветы (5)
животные (1)
однотонные (22)
геометрический рисунок (4)
детский рисунок (1)
звезды (6)
абстракция (3)
символы (3)
полоски/клетка (10)
новогодний (5)
этнический (4)
Показать больше
Цена
—
грн

Смотрите также
Сортировать:
по популярности
Выбрать производителя
Плед Sherpa Ardesto темно-синий
Плед Sherpa Ardesto темно-синий
Код: 503977

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

Цена:
999 грн
Плед хлопковый SoundSleep Wings синий
star line
8
Плед хлопковый SoundSleep Wings синий
Код: 418386
delivary icon

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

Цена:
738 грн
Плед шерстяной с кашемиром Ardesto Leonardo Moon бежево-голубой
Плед шерстяной с кашемиром Ardesto Leonardo Moon бежево-голубой
Код: 404803

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

Цена:
1 698 грн
Плед-накидка Barine Wave indigo синий
Плед-накидка Barine Wave indigo синий
Код: 286107

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

Цена:
4 669 грн
Плед шерстяной LiMaSo LT1067 Juno
Плед шерстяной LiMaSo LT1067 Juno
Код: 237845

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

Цена:
1 705 грн
Плед вязаный Прованс Soft косы синий меланж 020
Плед вязаный Прованс Soft косы синий меланж 020
Код: 278701

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

размер 90х130 см

960 грн
В 1 клик Купить
Цена:
960 грн
Плед-накидка Barine Wool basket indigo синий
Плед-накидка Barine Wool basket indigo синий
Код: 286103

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

Цена:
3 502 грн
Плед-накидка Barine Tan denim
Плед-накидка Barine Tan denim
Код: 217995

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

Цена:
3 308 грн
Плед-накидка Barine Stone throw denim
Плед-накидка Barine Stone throw denim
Код: 270787

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

Цена:
2 196 грн
Плед вязаный хлопковый Exclusive Nature Прованс синий
Плед вязаный хлопковый Exclusive Nature Прованс синий
Код: 391444

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

Цена:
1 592 грн
Флисовый плед 1002 Damask Blue Mirson - 40 %
Флисовый плед 1002 Damask Blue Mirson
Код: 393595

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

Цена:
1 419 грн 2 365 грн
Флисовый плед 1012 Aurora Blue Mirson - 40 %
Флисовый плед 1012 Aurora Blue Mirson
Код: 393634

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

размер 180х200 см

2 615 грн 1 569 грн
В 1 клик Купить
Цена:
1 569 грн 2 615 грн
Плед Украина Прованс
Плед Украина Прованс
Код: 400981

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

Цена:
795 грн
Плед вязаный Косы Прованс васильковый
Плед вязаный Косы Прованс васильковый
Код: 409487

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

Цена:
906 грн
Плед вязаный ручной работы Homytex синий
Плед вязаный ручной работы Homytex синий
Код: 414484

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

Цена:
5 227 грн
Плед Сердце 500242 велсофт Selena
Плед Сердце 500242 велсофт Selena
Код: 432285

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

размер 200х210 см

942 грн
В 1 клик Купить
Цена:
696 грн
Плед-покрывало микрофибра-шерпа Homytex синий
Плед-покрывало микрофибра-шерпа Homytex синий
Код: 446607

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

Цена:
2 467 грн
Плед Ardesto Flannel синий
Плед Ardesto Flannel синий
Код: 454854

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

размер 200х220 см

819 грн
В 1 клик Купить
Цена:
819 грн
Флисовый плед Love you синий
Флисовый плед Love you синий
Код: 454925

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

размер 200х220 см

750 грн
В 1 клик Купить
Цена:
538 грн
Плед фланелевый Ardesto Flannel синий темный
Плед фланелевый Ardesto Flannel синий темный
Код: 467774

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

Цена:
659 грн
Плед вязаный Cotton Прованс синий
Плед вязаный Cotton Прованс синий
Код: 476264

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

размер 200х220 см

2 499 грн
В 1 клик Купить
Цена:
1 192 грн
Флисовый однотонный плед Деним Home Line
Флисовый однотонный плед Деним Home Line
Код: 478679

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

Цена:
471 грн
Плед Pappy Sky фланель Soho
Плед Pappy Sky фланель Soho
Код: 490939

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

размер 200х220 см

629 грн
В 1 клик Купить
Цена:
629 грн
Флисовый плед Love you синий однотонный
Флисовый плед Love you синий однотонный
Код: 498342

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

размер 200х220 см

565 грн
В 1 клик Купить
Цена:
565 грн
Простынь-покрывало вафельное Пике Морская-волна Love You Новинка
Простынь-покрывало вафельное Пике Морская-волна Love You
Код: 509637

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

Цена:
1 350 грн