SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/kastryuli/simax-lessner-tefal-barazzoni.html' LIMIT 0,1 [0.00027298927307129 sec]
select id,name,url, is_active from pod_cat_category where url = 'kastryuli' [0.00021100044250488 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('simax','lessner','tefal','barazzoni') order by url [0.00063300132751465 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('simax','lessner','tefal','barazzoni') order by url [0.00048089027404785 sec]
select id,url from pod_cat_brand where BINARY url = 'simax-lessner-tefal-barazzoni' [0.00083303451538086 sec]
select id,url from pod_cat_brand where url = 'simax-lessner-tefal-barazzoni' [0.00015521049499512 sec]
select id,url from pod_cat_brand where url in ('simax','lessner','tefal','barazzoni') [0.00030803680419922 sec]
select id from pod_structure where link='catalogue/115' and active='1' AND lang_ru='1' [0.00013995170593262 sec]
SELECT c.id, c.super_category_id, c.entry, c.name AS name, c.title AS cat_title, c.metakwds AS cat_kwds, c.metadesc AS cat_metadesc, c.descr AS cat_descr, cc.name AS parent_name, cc.url AS parent_url, c.url as curl, cc.image AS parent_image, c.seo_text AS seo_text, c.seo_text_mobile AS seo_text_mobile, c.action_text 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='115' [0.00026702880859375 sec]
SELECT id FROM pod_cat_category WHERE entry='115' [0.0001521110534668 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.00026106834411621 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.35520195960999 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.00039005279541016 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.0049929618835449 sec]
SELECT g.id /* cats:115 */ FROM tmp_base_goods g WHERE g.brand_id IN (2550,334,327,1448) AND 1 [0.00040197372436523 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b396af1be9 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00022482872009277 sec]
INSERT INTO temp_brand_counts_6a2b396af1be9 (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:115 */ FROM tmp_base_goods g WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (2550,334,327,1448) [0.0018599033355713 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_6a2b396af1be9 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.00058722496032715 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b396af1be9 [0.00011110305786133 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 WHERE g.brand_id IN (2550,334,327,1448) 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 WHERE g.brand_id IN (2550,334,327,1448) AND 1 ) A [0.0005180835723877 sec]
SELECT g.id /* cats:115 */,if(g.is_present and g.price >= '556' and g.price <= '23491',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 >= '556' and g.price <= '23491',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 >= '556' AND pcg.price <= '23491' WHERE g.id IN (480055,470160,468482,468480,484843,484841,484722,473079,473078,463175,463174,463173,463172,463171,463170,463169,463168,463167,463166,463165,463164,463163,463162,463161,463160,463159,463158,463157,463156,463155,463154,463153,463152,463151,463150,463149,463148,463147,463146,463145,463144,463143,463142,463141,463140,463134,463133,463132,463131,463130,463129,463123,463122,463121,463120,463119,463118,463113,463112,463111,463110,463109,463108,463103,463102,463101,463100,463099,463098,463094,463093,463092,463091,463090,463089,463086,463085,463084,463083,463082,463081,463080,461893,461892,461891,461890,461889,461888) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0031380653381348 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 >= '556' and g.price <= '23491',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 >= '556' and g.price <= '23491',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 >= '556' and pcg.price <= '23491') WHERE g.id in (480055,473078,470160,484722,484843,473079,484841,463085,463140,463172,461892,463123,463165,463112,463158,463101,463151,463091,463144,468480,463082,463132,463169,461889,463120,463162,463109,463155,463098,463148,463086,463141) GROUP BY g.id ORDER BY g.ordr desc [0.0024211406707764 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 (480055,473078,470160,484722,484843,473079,484841,461889,461892,463082,463085,463086,463091,463098,463101,463109,463112,463120,463123,463132,463140,463141,463144,463148,463151,463155,463158,463162,463165,463169,463172,468480) AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.0007929801940918 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 (480055,473078,470160,484722,484843,473079,484841,461889,461892,463082,463085,463086,463091,463098,463101,463109,463112,463120,463123,463132,463140,463141,463144,463148,463151,463155,463158,463162,463165,463169,463172,468480) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0060811042785645 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id in (2550,334,327,1448) [0.00029397010803223 sec]
SELECT p.id, p.dt, p.title 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='115' ORDER BY p.dt DESC LIMIT 1 [0.005547046661377 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='2550.334.327.1448' [0.00025606155395508 sec]
SELECT id, name AS name, filter_name AS filter_name, image, url FROM pod_cat_category WHERE entry=0 AND super_category_id=5 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00059795379638672 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=478 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00053310394287109 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=478 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00069999694824219 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=353 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.0003819465637207 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=353 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00045895576477051 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=270 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.0007929801940918 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=270 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00042915344238281 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=486 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00050115585327148 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=486 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00041103363037109 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=114 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00034999847412109 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=114 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00037002563476562 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=491 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00023007392883301 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=491 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00021696090698242 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=488 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00024819374084473 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=488 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00021696090698242 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=2957 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00014400482177734 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=2957 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00023984909057617 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=495 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00026798248291016 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=495 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00020599365234375 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=490 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00030612945556641 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=490 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00019001960754395 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=724 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00020289421081543 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=724 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00017118453979492 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=2448 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00017404556274414 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=2448 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00018405914306641 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=2194 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.0002601146697998 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=2194 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00017905235290527 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=854 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00020289421081543 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=854 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00019502639770508 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=1403 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00021100044250488 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=1403 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00019097328186035 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=1261 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00021195411682129 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=1261 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00021600723266602 sec]
SELECT id, name AS name, filter_name, url, ordr FROM pod_cat_category WHERE entry=4573 AND is_active=1 AND is_hidden=0 ORDER BY ordr [0.00038003921508789 sec]
SELECT c.id, c.name AS name, c.filter_name, c.url, p.ordr FROM pod_dop_category p LEFT JOIN pod_cat_category c ON c.id = p.cat_id WHERE p.dop_cat_id=4573 AND c.is_active=1 AND c.is_hidden=0 ORDER BY c.ordr [0.00040316581726074 sec]
SELECT id, name AS name, url, entry FROM pod_cat_category WHERE is_active='1' AND is_hidden='0' AND entry IN (478,353,270,486,114,491,488,2957,495,490,724,2448,2194,854,1403,1261,4573) ORDER BY ordr [0.0020458698272705 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_pr72ettloubii881n2bandppab_6a2b396b0db2f; CREATE TEMPORARY TABLE tmp_A_pr72ettloubii881n2bandppab_6a2b396b0db2f ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00028204917907715 sec]
INSERT INTO tmp_A_pr72ettloubii881n2bandppab_6a2b396b0db2f (id) SELECT A.id FROM ( SELECT g.id /* cats:115 */ FROM tmp_base_goods g WHERE g.brand_id IN (2550,334,327,1448) AND 1 ) A [0.00030398368835449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0db2f; CREATE TEMPORARY TABLE tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0db2f ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00019598007202148 sec]
INSERT INTO tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0db2f (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_pr72ettloubii881n2bandppab_6a2b396b0db2f A INNER JOIN pod_good_filter gf ON A.id = gf.id_good 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.0027501583099365 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pr72ettloubii881n2bandppab_6a2b396b0db2f; CREATE TEMPORARY TABLE tmp_counts_pr72ettloubii881n2bandppab_6a2b396b0db2f ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00022411346435547 sec]
INSERT IGNORE INTO tmp_counts_pr72ettloubii881n2bandppab_6a2b396b0db2f (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0db2f p GROUP BY p.filter_id [0.00022578239440918 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_pr72ettloubii881n2bandppab_6a2b396b0db2f 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.00021100044250488 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_pr72ettloubii881n2bandppab_6a2b396b0db2f [0.00018000602722168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0db2f [7.7962875366211E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pr72ettloubii881n2bandppab_6a2b396b0db2f [8.7976455688477E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_pr72ettloubii881n2bandppab_6a2b396b0f1b9; CREATE TEMPORARY TABLE tmp_A_pr72ettloubii881n2bandppab_6a2b396b0f1b9 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00014877319335938 sec]
INSERT INTO tmp_A_pr72ettloubii881n2bandppab_6a2b396b0f1b9 (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 (2550,334,327,1448) 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 (2550,334,327,1448) AND 1 ) A [0.00032711029052734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0f1b9; CREATE TEMPORARY TABLE tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0f1b9 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00019693374633789 sec]
INSERT INTO tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0f1b9 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_pr72ettloubii881n2bandppab_6a2b396b0f1b9 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good 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.0012061595916748 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pr72ettloubii881n2bandppab_6a2b396b0f1b9; CREATE TEMPORARY TABLE tmp_counts_pr72ettloubii881n2bandppab_6a2b396b0f1b9 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0001978874206543 sec]
INSERT IGNORE INTO tmp_counts_pr72ettloubii881n2bandppab_6a2b396b0f1b9 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0f1b9 p GROUP BY p.filter_id [0.00019598007202148 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_pr72ettloubii881n2bandppab_6a2b396b0f1b9 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.0002288818359375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_pr72ettloubii881n2bandppab_6a2b396b0f1b9 [0.00016093254089355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_pr72ettloubii881n2bandppab_6a2b396b0f1b9 [7.0095062255859E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pr72ettloubii881n2bandppab_6a2b396b0f1b9 [5.793571472168E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_pr72ettloubii881n2bandppab_6a2b396b102f2; CREATE TEMPORARY TABLE tmp_A_pr72ettloubii881n2bandppab_6a2b396b102f2 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00023293495178223 sec]
INSERT IGNORE INTO tmp_A_pr72ettloubii881n2bandppab_6a2b396b102f2 (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 WHERE g.brand_id IN (2550,334,327,1448) 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 WHERE g.brand_id IN (2550,334,327,1448) AND 1 ) A [0.00059700012207031 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pr72ettloubii881n2bandppab_6a2b396b102f2; CREATE TEMPORARY TABLE tmp_counts_pr72ettloubii881n2bandppab_6a2b396b102f2 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00033092498779297 sec]
INSERT IGNORE INTO tmp_counts_pr72ettloubii881n2bandppab_6a2b396b102f2 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_pr72ettloubii881n2bandppab_6a2b396b102f2 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.00032615661621094 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_pr72ettloubii881n2bandppab_6a2b396b102f2 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.00016117095947266 sec]
----------------------------- SELECT COUNT(*) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.0070879459381104 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.022241830825806 sec]
Array ( [0] => Array ( [COUNT(DISTINCT filter_id)] => 8 ) ) ----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_pr72ettloubii881n2bandppab_6a2b396b102f2 [0.00038003921508789 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_pr72ettloubii881n2bandppab_6a2b396b102f2 [0.00011897087097168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00023484230041504 sec]
Низкие цены на Кастрюли Simax ... Barazzoni (Сімaкс ... Бaрaззoні) – большой выбор, фото. Купить Кастрюли Simax ... Barazzoni (Сімaкс ... Бaрaззoні) в Киеве и Украине
UA
RU
Вход в кабинет

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

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

Кастрюли Simax ... Barazzoni

5 причин купить керамическую посуду
Найдено 88 товаров
Вы выбрали
Очистить все фильтры
Приготовление пищи
Производитель
GIPFEL (32)
Kamille (65)
Empire (1)
Vincent (2)
Lessner (3)
Больше производителей
Умные фильтры
Со скидкой!
Быстрая доставка
Новинка
Распродажа
Диаметр кастрюли
16 см (4)
20 см (2)
24 см (5)
26 см (1)
Более 26 см (2)
Объем кастрюли
Менее 1,5 л (2)
1,5 - 2 л (2)
2,1 - 3 л (2)
3,1 - 5 л (3)
5,1 - 7 л (3)
Более 7 л (3)
Показать больше
Материал
нержавеющая сталь (81)
алюминий (5)
стекло (1)
Антипригарное покрытие
Есть (74)
Нет (10)
Источник тепла
все виды плит (14)
газовые плиты (14)
индукционные плиты (13)
электрические плиты (14)
использование в духовке (1)
стеклокерамическая плита (13)
Показать больше
Особенности посуды
отверстие на крышке для выхода пара (8)
многослойное дно (7)
индукционное дно (8)
две ручки (12)
с носиком для слива (3)
Цена
—
грн

Смотрите также
Сортировать:
по популярности
Выбрать производителя
Кастрюля стеклянная с крышкой 2 л Nyko Simax s6073
Кастрюля стеклянная с крышкой 2 л Nyko Simax s6073
Код: 480055
delivary icon

Производитель: Simax (Чехия)

Цена:
556 грн
Мультикастрюля 20 см 2.5 л Opti Space Tefal G7371795 - 32 %
Мультикастрюля 20 см 2.5 л Opti Space Tefal G7371795
Код: 473078
delivary icon

Производитель: Tefal (Франция)

Цена:
1 299 грн 1 899 грн
Ковш алюминиевый 16 см 1.3 л Black Pro New Lessner 55872-16
Ковш алюминиевый 16 см 1.3 л Black Pro New Lessner 55872-16
Код: 470160
delivary icon

Производитель: Lessner (Великобритания)

Цена:
1 072 грн
Кастрюля с крышкой 24 см 5 л Daily Cook Tefal G7124645 - 20 %
Кастрюля с крышкой 24 см 5 л Daily Cook Tefal G7124645
Код: 484722

Производитель: Tefal (Франция)

Цена:
1 499 грн 1 879 грн
Кастрюля с крышкой 24 см 5 л Duetto Tefal G7194656 - 23 %
Кастрюля с крышкой 24 см 5 л Duetto Tefal G7194656
Код: 484843

Производитель: Tefal (Франция)

Цена:
1 799 грн 2 349 грн
Кастрюля с крышкой 24 см 5.3 л Unlimited Tefal G2554672 - 28 %
Кастрюля с крышкой 24 см 5.3 л Unlimited Tefal G2554672
Код: 473079

Производитель: Tefal (Франция)

Цена:
2 299 грн 3 199 грн
Кастрюля с крышкой 16 см 1.5 л Duetto Tefal G7194236 - 17 %
Кастрюля с крышкой 16 см 1.5 л Duetto Tefal G7194236
Код: 484841

Производитель: Tefal (Франция)

Цена:
1 099 грн 1 329 грн
Кастрюля My Lady 20 см, 3.5 л Barazzoni 510002020
Кастрюля My Lady 20 см, 3.5 л Barazzoni 510002020
Код: 461889

Производитель: Barazzoni (Италия)

1,8л
8л
3,5л
5,7л
Цена:
8 116 грн
Кастрюля My Lady 16 см, 1.8 л Barazzoni 510002016
Кастрюля My Lady 16 см, 1.8 л Barazzoni 510002016
Код: 461892

Производитель: Barazzoni (Италия)

1,8л
8л
3,5л
5,7л
Цена:
6 368 грн
Кастрюля 16 см, 1.4 л 160002016 BARAZZONI
Кастрюля 16 см, 1.4 л 160002016 BARAZZONI
Код: 463082

Производитель: Barazzoni (Италия)

13,5л
8л
4,4л
4,5л
3л
1,4л
Цена:
4 118 грн
Кастрюля CHEF LINE 16 см, 1.4 л 163102016 BARAZZONI
Кастрюля CHEF LINE 16 см, 1.4 л 163102016 BARAZZONI
Код: 463085

Производитель: Barazzoni (Италия)

13,5л
4,4л
4,5л
3л
2,1л
8л
1,4л
Цена:
2 618 грн
Набор посуды 8 предметов 277910 BARAZZONI
Набор посуды 8 предметов 277910 BARAZZONI
Код: 463086

Производитель: Barazzoni (Италия)

Цена:
17 413 грн
Кастрюля с крышкой PROFESSIONAL 28 см 11.8 л 169601028 BARAZZONI
Кастрюля с крышкой PROFESSIONAL 28 см 11.8 л 169601028 BARAZZONI
Код: 463091

Производитель: Barazzoni (Италия)

5,5л
3,2л
4,5л
11,8л
8,4л
Цена:
14 109 грн
Кастрюля CARATI 24 см, 7.7 л 170101024 BARAZZONI
Кастрюля CARATI 24 см, 7.7 л 170101024 BARAZZONI
Код: 463098

Производитель: Barazzoni (Италия)

11,8л
3л
4,7л
3,1л
1,5л
7,7л
Цена:
5 448 грн
Кастрюля CARATI 20 см, 3.1 л 170102020 BARAZZONI
Кастрюля CARATI 20 см, 3.1 л 170102020 BARAZZONI
Код: 463101

Производитель: Barazzoni (Италия)

11,8л
3л
4,7л
3,1л
1,5л
7,7л
Цена:
3 793 грн
Кастрюля TUMMY 26 см, 12 л 001001026 BARAZZONI
Кастрюля TUMMY 26 см, 12 л 001001026 BARAZZONI
Код: 463109

Производитель: Barazzoni (Италия)

12л
7,5л
4,25л
Цена:
9 397 грн
Кастрюля TUMMY 26 см, 7.25 л 001002026 BARAZZONI
Кастрюля TUMMY 26 см, 7.25 л 001002026 BARAZZONI
Код: 463112

Производитель: Barazzoni (Италия)

2,5л
5л
7,25л
Цена:
7 486 грн
Кастрюля TUMMY 26 см, 12 л 018001026 BARAZZONI
Кастрюля TUMMY 26 см, 12 л 018001026 BARAZZONI
Код: 463120

Производитель: Barazzoni (Италия)

12л
7,5л
Цена:
11 548 грн
Кастрюля TUMMY 22 см, 5 л 018002022 BARAZZONI
Кастрюля TUMMY 22 см, 5 л 018002022 BARAZZONI
Код: 463123

Производитель: Barazzoni (Италия)

7,25л
5л
2,5л
1,5л
Цена:
6 878 грн
Кастрюля DOLCE VITA 22 см, 6 л 267101022 BARAZZONI
Кастрюля DOLCE VITA 22 см, 6 л 267101022 BARAZZONI
Код: 463132

Производитель: Barazzoni (Италия)

8л
9,5л
4,6л
6л
Цена:
4 755 грн
Кастрюля DOLCE VITA 16 см, 1.4 л 267102016 BARAZZONI
Кастрюля DOLCE VITA 16 см, 1.4 л 267102016 BARAZZONI
Код: 463140

Производитель: Barazzoni (Италия)

3,8л
7,5л
6л
4,5л
3л
2,1л
1,4л
Цена:
2 774 грн
Кастрюля DOLCE VITA 18 см, 2.1 л 267102018 BARAZZONI
Кастрюля DOLCE VITA 18 см, 2.1 л 267102018 BARAZZONI
Код: 463141

Производитель: Barazzoni (Италия)

3л
2,1л
1,4л
3,8л
7,5л
6л
4,5л
Цена:
3 227 грн
Кастрюля DOLCE VITA 24 см, 4.5 л 267102024 BARAZZONI
Кастрюля DOLCE VITA 24 см, 4.5 л 267102024 BARAZZONI
Код: 463144

Производитель: Barazzoni (Италия)

7,5л
6л
4,5л
3л
2,1л
1,4л
3,8л
Цена:
4 486 грн
Кастрюля CHEF LINE 18 см, 2.1 л 163102018 BARAZZONI
Кастрюля CHEF LINE 18 см, 2.1 л 163102018 BARAZZONI
Код: 463148

Производитель: Barazzoni (Италия)

13,5л
4,4л
4,5л
3л
2,1л
8л
1,4л
Цена:
3 156 грн
Кастрюля низкая CHEF LINE 28 см, 4.4 л 163104028 BARAZZONI
Кастрюля низкая CHEF LINE 28 см, 4.4 л 163104028 BARAZZONI
Код: 463151

Производитель: Barazzoni (Италия)

2,1л
8л
1,4л
13,5л
4,4л
4,5л
3л
Цена:
5 194 грн
Кастрюля BONITA 22 см, 6 л 266101022 BARAZZONI
Кастрюля BONITA 22 см, 6 л 266101022 BARAZZONI
Код: 463155

Производитель: Barazzoni (Италия)

9,5л
4,6л
3,3л
6л
Цена:
4 090 грн
Кастрюля BONITA 14 см, 0.9 л 266102014 BARAZZONI
Кастрюля BONITA 14 см, 0.9 л 266102014 BARAZZONI
Код: 463158

Производитель: Barazzoni (Италия)

3,8л
2,1л
0,5л
0,9л
6л
4,5л
Цена:
1 910 грн
Кастрюля BONITA 26 см, 6 л 266102026 BARAZZONI
Кастрюля BONITA 26 см, 6 л 266102026 BARAZZONI
Код: 463162

Производитель: Barazzoni (Италия)

0,9л
6л
4,5л
3,8л
2,1л
0,5л
Цена:
5 080 грн
Кастрюля низкая BONITA 28 см, 4.5 л 266104028 BARAZZONI
Кастрюля низкая BONITA 28 см, 4.5 л 266104028 BARAZZONI
Код: 463165

Производитель: Barazzoni (Италия)

2,8л
4,5л
3,4л
Цена:
5 194 грн
Кастрюля с крышкой BLACK TITAN 24 см, 4.1л 85560202498 BARAZZONI
Кастрюля с крышкой BLACK TITAN 24 см, 4.1л 85560202498 BARAZZONI
Код: 463169

Производитель: Barazzoni (Италия)

2,4л
4,1л
Цена:
9 057 грн
Кастрюля низкая CARATI 24 см, 3 л 170104024 BARAZZONI
Кастрюля низкая CARATI 24 см, 3 л 170104024 BARAZZONI
Код: 463172

Производитель: Barazzoni (Италия)

11,8л
3л
4,7л
3,1л
1,5л
7,7л
Цена:
4 302 грн
Кастрюля с крышкой 2,2 л Lessner 55855-16
Кастрюля с крышкой 2,2 л Lessner 55855-16
Код: 468480

Производитель: Lessner (Великобритания)

2,2л
Цена:
779 грн
1 2 3