SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/kastryuli/pan_22-pan_24-ringel.html' LIMIT 0,1 [0.0002439022064209 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('pan_22','pan_24','ringel') order by url [0.00068902969360352 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('pan_22','pan_24','ringel') order by url [0.00048589706420898 sec]
select id,url from pod_cat_brand where BINARY url IN ('pan_22','pan_24','ringel') [0.00090384483337402 sec]
SELECT cb.metaindex, cb.metafollow FROM pod_set_cat_brand cb INNER JOIN pod_cat_category c ON cb.cat_id = c.id WHERE c.url = 'kastryuli' AND cb.brand_id = 1415 AND cb.is_active = 1 LIMIT 1 [0.00023198127746582 sec]
SELECT id, url FROM pod_filter WHERE url IN ('pan_22','pan_24','ringel') [0.00026583671569824 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('pan_22','pan_24','ringel') [0.00017786026000977 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.00019502639770508 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 (115) 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 (115) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.36679983139038 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.00029706954956055 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.0038750171661377 sec]
SELECT g.id /* cats:115 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (93,95) WHERE g.brand_id IN (1415) AND g.is_present AND 1 UNION SELECT g.id /* cats:115 */ 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 (93,95) WHERE g.brand_id IN (1415) AND 1 [0.0040621757507324 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b7a3b76579 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00022292137145996 sec]
INSERT INTO temp_brand_counts_6a2b7a3b76579 (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:115 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (93,95) WHERE g.is_present AND 1 UNION SELECT g.brand_id AS id, g.id AS gid /* cats:115 */ 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 (93,95) WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (1415) [0.0029761791229248 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_6a2b7a3b76579 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.00043797492980957 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b7a3b76579 [0.00011301040649414 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:115 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (93,95) WHERE g.brand_id IN (1415) AND g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:115 */ 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 (93,95) WHERE g.brand_id IN (1415) AND 1 ) A [0.00055503845214844 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 >= '832' and g.price <= '2924',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 >= '832' and g.price <= '2924',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 >= '832' and pcg.price <= '2924') WHERE g.id in (215357,215356,280284,230436,461342,420392,427003,267067,477643,420396,438940,420400,438941,355035,420451) GROUP BY g.id ORDER BY g.ordr desc [0.0040068626403809 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 (215357,215356,280284,230436,267067,355035,420392,420396,420400,420451,427003,438940,438941,461342,477643) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00038003921508789 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 (215357,215356,280284,230436,267067,355035,420392,420396,420400,420451,427003,438940,438941,461342,477643) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0027740001678467 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id in (1415) [0.00014400482177734 sec]
SELECT cb.id, cb.info AS info, cb.title AS title, cb.metadesc AS metadesc, cb.seo_text AS seo_text, cb.tagH1 AS tagH1, cb.canonical, cb.is_active FROM pod_set_cat_brand cb WHERE cb.cat_id = 115 AND cb.brand_id = 1415 AND cb.is_active = 1 LIMIT 1 [0.00030708312988281 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='1415' [0.00018692016601562 sec]
SELECT url FROM pod_cat_brand WHERE id = 1415 [0.0001370906829834 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2; CREATE TEMPORARY TABLE tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00039410591125488 sec]
INSERT INTO tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 (id) SELECT A.id FROM ( SELECT g.id /* cats:115 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (93,95) WHERE g.brand_id IN (1415) AND g.is_present AND 1 UNION SELECT g.id /* cats:115 */ 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 (93,95) WHERE g.brand_id IN (1415) AND 1 ) A [0.00074601173400879 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2; CREATE TEMPORARY TABLE tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00022411346435547 sec]
INSERT INTO tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (93,95) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 115 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.0064401626586914 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2; CREATE TEMPORARY TABLE tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00030112266540527 sec]
INSERT IGNORE INTO tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 p GROUP BY p.filter_id [0.00021100044250488 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_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 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.00022077560424805 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 [0.00016903877258301 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 [5.8889389038086E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7c0d2 [5.2928924560547E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd; CREATE TEMPORARY TABLE tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00013399124145508 sec]
INSERT INTO tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:115 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (93,95) WHERE g.brand_id IN (1415) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:115 */ 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 (93,95) WHERE g.brand_id IN (1415) AND 1 ) A [0.00052881240844727 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd; CREATE TEMPORARY TABLE tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00017499923706055 sec]
INSERT INTO tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (93,95) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 115 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.00063109397888184 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd; CREATE TEMPORARY TABLE tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00014495849609375 sec]
INSERT IGNORE INTO tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd p GROUP BY p.filter_id [0.00015902519226074 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_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd 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.00020503997802734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd [0.00012993812561035 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd [6.3896179199219E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7e5bd [5.8889389038086E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff; CREATE TEMPORARY TABLE tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.0001380443572998 sec]
INSERT INTO tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:115 */ FROM tmp_base_goods g WHERE g.brand_id IN (1415) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:115 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id WHERE g.brand_id IN (1415) AND 1 ) A [0.00025105476379395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff; CREATE TEMPORARY TABLE tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.00016903877258301 sec]
INSERT INTO tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 86 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.0041799545288086 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff; CREATE TEMPORARY TABLE tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00018191337585449 sec]
INSERT INTO tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff p GROUP BY p.filter_id [0.0001828670501709 sec]
INSERT INTO tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff c ON c.filter_id = pf.id WHERE pf.id in (93,95) AND c.filter_id IS NULL [0.00014805793762207 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_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff 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.00020813941955566 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff [0.00012803077697754 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff [5.9843063354492E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b7f0ff [5.5789947509766E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04; CREATE TEMPORARY TABLE tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00016498565673828 sec]
INSERT IGNORE INTO tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04 (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:115 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (93,95) WHERE g.brand_id IN (1415) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:115 */ 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 (93,95) WHERE g.brand_id IN (1415) AND 1 ) A [0.00059413909912109 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04; CREATE TEMPORARY TABLE tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00017809867858887 sec]
INSERT IGNORE INTO tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04 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.00023698806762695 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04 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.00012898445129395 sec]
----------------------------- SELECT COUNT(*) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.0066759586334229 sec]
Array ( [0] => Array ( [COUNT(*)] => 4005 ) ) SELECT COUNT(DISTINCT filter_id) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.019140958786011 sec]
Array ( [0] => Array ( [COUNT(DISTINCT filter_id)] => 8 ) ) ----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04 [0.00019192695617676 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_csq75sabf5ntvnigi95gl7m5ab_6a2b7a3b80a04 [9.8943710327148E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00010991096496582 sec]
Низкие цены на Кастрюли Ringel (Рінгeл) – большой выбор, фото. Купить Кастрюли Ringel (Рінгeл) в Киеве и Украине
UA
RU
Вход в кабинет

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

ПЕРЕЙТИ
Магазин PODUSHKA ®
  1. Магазин PODUSHKA ®
  2. Посуда, товары для дома Посуда, товары для дома
  3. Приготовление пищи Приготовление пищи
  4. Кастрюли Кастрюли
  5. Ringel Ringel

Кастрюли Ringel

5 причин купить керамическую посуду
Найдено 15 товаров
Вы выбрали
Очистить все фильтры
Приготовление пищи
Производитель
GIPFEL (1)
Kamille (17)
Vincent (1)
MAESTRO (23)
Tramontina (3)
Больше производителей
Умные фильтры
Со скидкой!
Быстрая доставка
Новинка
Распродажа
Диаметр кастрюли
Менее 14 см (2)
14 см (3)
16 см (12)
18 см (10)
20 см (9)
22 см (10)
24 см (5)
26 см (3)
Более 26 см (3)
Показать больше
Объем кастрюли
2,1 - 3 л (1)
3,1 - 5 л (10)
5,1 - 7 л (4)
Материал
нержавеющая сталь (11)
алюминий (3)
чугун (1)
Антипригарное покрытие
Есть (3)
Нет (10)
Источник тепла
все виды плит (10)
газовые плиты (5)
индукционные плиты (5)
электрические плиты (5)
стеклокерамическая плита (4)
Особенности посуды
отверстие на крышке для выхода пара (8)
многослойное дно (6)
индукционное дно (4)
две ручки (7)
Цена
—
грн

Смотрите также
Сортировать:
по популярности
Выбрать производителя
Кастрюля Bonn (4.7 л) 22 см Ringel RG-2003-22
Кастрюля Bonn (4.7 л) 22 см Ringel RG-2003-22
Код: 215357

Производитель: Ringel (Германия)

3,6л
2,6л
4,7л
6,1л
Цена:
1 206 грн
Кастрюля Bonn (6.1 л) 24 см Ringel RG-2003-24
Кастрюля Bonn (6.1 л) 24 см Ringel RG-2003-24
Код: 215356

Производитель: Ringel (Германия)

3,6л
2,6л
4,7л
6,1л
Цена:
1 354 грн
Кастрюля с крышкой Ringel Meyer 4.2 л 22 см RG-2008-22 - 30 %
Кастрюля с крышкой Ringel Meyer 4.2 л 22 см RG-2008-22
Код: 280284

Производитель: Ringel (Германия)

4.2л
2.3л
5.5л
Цена:
832 грн 1 188 грн
Кастрюля с крышкой Ringel Zitrone 24x12 см 4.2л RG-2108-24/1
Кастрюля с крышкой Ringel Zitrone 24x12 см 4.2л RG-2108-24/1
Код: 230436

Производитель: Ringel (Германия)

4.2л
Цена:
2 424 грн
Кастрюля с крышкой Ringel Meyer 24 см 5.5 л RG-2008-24 - 30 %
Кастрюля с крышкой Ringel Meyer 24 см 5.5 л RG-2008-24
Код: 267067

Производитель: Ringel (Германия)

5.5л
4.2л
2.3л
Цена:
956 грн 1 366 грн
Кастрюля с крышкой 22см 4.75л Riegel Ringel RG-2016-22
Кастрюля с крышкой 22см 4.75л Riegel Ringel RG-2016-22
Код: 355035

Производитель: Ringel (Германия)

4л
3л
4.75л
2,2л
Цена:
1 172 грн
Кастрюля с крышкой Ringel Prime 22см 4.7л RG-2019-22
Кастрюля с крышкой Ringel Prime 22см 4.7л RG-2019-22
Код: 420392

Производитель: Ringel (Германия)

4,7л
3,6л
1,9л
Цена:
1 662 грн
Кастрюля с крышкой Ringel Fusion 22см 4.7л RG-2020-22
Кастрюля с крышкой Ringel Fusion 22см 4.7л RG-2020-22
Код: 420396

Производитель: Ringel (Германия)

4,7л
3,6л
2,6л
1,9л
Цена:
1 774 грн
Кастрюля с крышкой Ringel Hanover 22см 4.5л
Кастрюля с крышкой Ringel Hanover 22см 4.5л
Код: 420400

Производитель: Ringel (Германия)

1,8л
3,5л
4,5л
2,3л
Цена:
1 334 грн
Кастрюля с крышкой Ringel Expert 22см 4.6л RG-2018-22
Кастрюля с крышкой Ringel Expert 22см 4.6л RG-2018-22
Код: 420451

Производитель: Ringel (Германия)

1,5л
4,5л
3,5л
2,5л
Цена:
1 490 грн
Кастрюля чугунная с крышкой Ringel Essen 22 см 2.9 л Rg-2300-22
Кастрюля чугунная с крышкой Ringel Essen 22 см 2.9 л Rg-2300-22
Код: 427003

Производитель: Ringel (Германия)

4,8л
2,9л
Цена:
2 924 грн
Кастрюля с крышкой Ringel Zira 24 см 6.3 л RG-21006-24h
Кастрюля с крышкой Ringel Zira 24 см 6.3 л RG-21006-24h
Код: 438940

Производитель: Ringel (Германия)

Цена:
2 296 грн
Кастрюля с крышкой Ringel Zira 24 см 4.1 л RG-21006-24
Кастрюля с крышкой Ringel Zira 24 см 4.1 л RG-21006-24
Код: 438941

Производитель: Ringel (Германия)

Цена:
2 020 грн
Кастрюля с крышкой 4.2 л 22 см Grey Line Ringel RG-2022-22
Кастрюля с крышкой 4.2 л 22 см Grey Line Ringel RG-2022-22
Код: 461342

Производитель: Ringel (Германия)

4,2л
3,2л
2,3л
1,6л
Цена:
1 286 грн
Кастрюля с крышкой 5.2 л 22 см Salsa Ringel RG-2034-22
Кастрюля с крышкой 5.2 л 22 см Salsa Ringel RG-2034-22
Код: 477643

Производитель: Ringel (Германия)

5,2л
3,1л
8,4л
Цена:
1 504 грн

Кастрюли Ringel — стальной характер, потрясающий вкус!

Под торговой маркой Ringel выпускается посуда и кухонные аксессуары, удачно сочетающие высокое качество, современные технологии и авторский дизайн. Примером добросовестной работы бренда стали кастрюли Ringel.

Стильные коллекции, вдохновляющие на создание кулинарных шедевров

  • «Kinder» из нержавеющей стали с тройным капсульным дном
  • «Zitrone» — яркие кастрюли Ringel из утолщенного литого алюминия с антипригарной поверхностью Mega-Stone. Изделия можно использовать в духовке и на любой варочной панели.
  • «Dita» из нержавеющей стали с зеркальным внутренним покрытием. Каждая кастрюля Ringel из этой серии оснащена крышкой из жаропрочного стекла.
  • «Bonn» из нержавейки с отверстиями для слива воды.

Где приобрести сертифицированную посуду Рингел в Киеве

Хотите готовить с удовольствием? В нашем интернет-магазине можно купить кастрюли по приемлемой цене с доставкой на дом. Высококачественные кухонные принадлежности с продуманным дизайном позволяют баловать семью вкусными и здоровыми блюдами без лишних хлопот.