SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/tapochki/gray-devochkam-36-30-waldi.html' LIMIT 0,1 [0.00057816505432129 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('gray','devochkam','36','30','waldi') order by url [0.0016520023345947 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('gray','devochkam','36','30','waldi') order by url [0.0012190341949463 sec]
select id,url from pod_cat_brand where BINARY url IN ('gray','devochkam','36','30','waldi') [0.0019030570983887 sec]
SELECT id, url FROM pod_filter WHERE url IN ('gray','devochkam','36','30','waldi') [0.00043201446533203 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('gray','devochkam','36','30','waldi') [0.00076794624328613 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 (2300,1819,120,32) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00043916702270508 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.00042486190795898 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 (717) 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 (717) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.0033779144287109 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.00038504600524902 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.00054597854614258 sec]
SELECT g.id /* cats:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND g.is_present AND 1 UNION SELECT g.id /* cats:717 */ 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 (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON go.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND 1 [0.012815952301025 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b41996ebd4 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00045204162597656 sec]
INSERT INTO temp_brand_counts_6a2b41996ebd4 (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.is_present AND 1 UNION SELECT g.brand_id AS id, g.id AS gid /* cats:717 */ 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 (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON go.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (1032) [0.0014200210571289 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_6a2b41996ebd4 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.00072193145751953 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b41996ebd4 [0.00030303001403809 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:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:717 */ 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 (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON go.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND 1 ) A [0.0010929107666016 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 >= '501' and g.price <= '501',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 >= '501' and g.price <= '501',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 >= '501' and pcg.price <= '501') WHERE g.id in (436765) GROUP BY g.id ORDER BY g.ordr desc [0.0015230178833008 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 = 717 AND cb.brand_id = 1032 AND cb.is_active = 1 LIMIT 1 [0.00045204162597656 sec]
SELECT url FROM pod_cat_brand WHERE id = 1032 [0.00032496452331543 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419973753; CREATE TEMPORARY TABLE tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00046706199645996 sec]
INSERT INTO tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 (id) SELECT A.id FROM ( SELECT g.id /* cats:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND g.is_present AND 1 UNION SELECT g.id /* cats:717 */ 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 (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON go.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND 1 ) A [0.0016400814056396 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b419973753; CREATE TEMPORARY TABLE tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00048685073852539 sec]
INSERT INTO tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32,120,1819,2300) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 717 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.018002033233643 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419973753; CREATE TEMPORARY TABLE tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00038003921508789 sec]
INSERT IGNORE INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 p GROUP BY p.filter_id [0.00051712989807129 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_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 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.00046396255493164 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 [0.00023484230041504 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 [9.2029571533203E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419973753 [7.9870223999023E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3; CREATE TEMPORARY TABLE tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00031805038452148 sec]
INSERT INTO tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:717 */ 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 (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON go.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND 1 ) A [0.0010650157928467 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3; CREATE TEMPORARY TABLE tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00033307075500488 sec]
INSERT INTO tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32,120,1819,2300) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 717 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.00080394744873047 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3; CREATE TEMPORARY TABLE tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00030994415283203 sec]
INSERT IGNORE INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 p GROUP BY p.filter_id [0.00028800964355469 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_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 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.00035405158996582 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 [0.00022411346435547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 [9.7990036010742E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b4199791b3 [9.0122222900391E-5 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 (2300,1819,120) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00051212310791016 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701; CREATE TEMPORARY TABLE tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.0003058910369873 sec]
INSERT INTO tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 (id) SELECT A.id FROM ( SELECT g.id /* cats:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (120) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND g.is_present AND 1 UNION SELECT g.id /* cats:717 */ 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 (120) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND 1 ) A [0.00084114074707031 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701; CREATE TEMPORARY TABLE tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00029993057250977 sec]
INSERT INTO tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 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.0032680034637451 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701; CREATE TEMPORARY TABLE tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00031018257141113 sec]
INSERT INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 p GROUP BY p.filter_id [0.00025701522827148 sec]
INSERT IGNORE INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 c ON c.filter_id = pf.id WHERE pf.id in (32) AND c.filter_id IS NULL [0.00021696090698242 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_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 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.0002598762512207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 [0.00022602081298828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 [0.00010299682617188 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997a701 [0.0001070499420166 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3; CREATE TEMPORARY TABLE tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00028800964355469 sec]
INSERT INTO tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 (id) SELECT A.id FROM ( SELECT g.id /* cats:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND g.is_present AND 1 UNION SELECT g.id /* cats:717 */ 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 (32) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND 1 ) A [0.0010149478912354 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3; CREATE TEMPORARY TABLE tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00037288665771484 sec]
INSERT INTO tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 119 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.003525972366333 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3; CREATE TEMPORARY TABLE tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00035691261291504 sec]
INSERT INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 p GROUP BY p.filter_id [0.00033712387084961 sec]
INSERT IGNORE INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 c ON c.filter_id = pf.id WHERE pf.id in (120) AND c.filter_id IS NULL [0.00026702880859375 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_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 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.00027799606323242 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 [0.00027012825012207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 [0.00016021728515625 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997c6a3 [0.0001370906829834 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff; CREATE TEMPORARY TABLE tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00031495094299316 sec]
INSERT INTO tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) WHERE g.brand_id IN (1032) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:717 */ 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 (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) WHERE g.brand_id IN (1032) AND 1 ) A [0.00087285041809082 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff; CREATE TEMPORARY TABLE tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.00036382675170898 sec]
INSERT INTO tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 1816 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.0046079158782959 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff; CREATE TEMPORARY TABLE tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00041007995605469 sec]
INSERT INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff p GROUP BY p.filter_id [0.00038695335388184 sec]
INSERT INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff c ON c.filter_id = pf.id WHERE pf.id in (1819,2300) AND c.filter_id IS NULL [0.00041294097900391 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_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff 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.00043892860412598 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff [0.00030398368835449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff [0.00015807151794434 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b41997e8ff [0.00012803077697754 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0; CREATE TEMPORARY TABLE tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.0002439022064209 sec]
INSERT IGNORE INTO tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0 (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:717 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:717 */ 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 (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (120) INNER JOIN pod_good_filter gf2 ON go.id = gf2.id_good AND gf2.filter_id_value in (1819,2300) WHERE g.brand_id IN (1032) AND 1 ) A [0.0010590553283691 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0; CREATE TEMPORARY TABLE tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00038504600524902 sec]
INSERT IGNORE INTO tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0 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.00046110153198242 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0 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.00028896331787109 sec]
----------------------------- SELECT COUNT(*) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.00029802322387695 sec]
Array ( [0] => Array ( [COUNT(*)] => 27 ) ) SELECT COUNT(DISTINCT filter_id) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.00044989585876465 sec]
Array ( [0] => Array ( [COUNT(DISTINCT filter_id)] => 5 ) ) ----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0 [0.0002892017364502 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_b0jv0knds9v07s44d4cj5i30js_6a2b419980ef0 [0.00015997886657715 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00024318695068359 sec]
Низкие цены на Детские тапочки WALDI (ВAЛДИ) в интернет-магазине «Подушка». Купить Детские тапочки WALDI в Киеве и Украине
UA
RU
Вход в кабинет

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

ПЕРЕЙТИ
Магазин PODUSHKA ®
  1. Магазин PODUSHKA ®
  2. Детская одежда Детская одежда
  3. Детская обувь Детская обувь
  4. Детские тапочки Детские тапочки
  5. WALDI WALDI

Детские тапочки WALDI

Как выбрать обувь для ребёнка?
Найдено 1 товар
Вы выбрали
Очистить все фильтры
Детская обувь
Производитель
WALDI (1)
Больше производителей
Умные фильтры
Со скидкой!
Быстрая доставка
Новинка
Распродажа
Основной цвет
Серый (1)
Пол ребенка
девочкам (1)
Основной материал
велюр (1)
Сезонность
Весна/Осень (1)
Зимние (1)
Размер обуви
30 (1)
31 (1)
36 (1)
37 (1)
Цена
—
грн

Смотрите также
Сортировать:
по популярности
Тапочки для девочки Memory Ведмедик Waldi Home 311-006 серые
Тапочки для девочки Memory Ведмедик Waldi Home 311-006 серые
Код: 436765
delivary icon

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

размер 30-31

501 грн
В 1 клик Купить

размер 36-37

501 грн
В 1 клик Купить
Цена:
501 грн

Украинский бренд WALDI очень популярен среди родителей, а все потому, что детские тапочки WALDI отличаются удобством, практичностью, и очень полезны для малышей. Они подходят как для дома, так и для улицы или детского садика, дают коже ребенка дышать, пропуская воздух. К тому же, они отлично выглядят, сочетаются с детской одеждой, нравятся детям.

Купить тапочки WALDI для девочек и для мальчиков по доступной стоимости можно в нашем интернет-магазине!

Тапочки для правильного развития стопы

Детская нога существенно отличается от взрослой, она только формируется, и любая ошибка может привести к опасным последствиям. Поэтому детские тапочки WALDI станут лучшим решением, если вы хотите обеспечить своему ребенку гармоничное развитие. А все потому что:

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

Преимущества тапочек WALDI

Текстильные детские тапочки WALDI - лучшее решение для теплого времени года, так как они максимально комфортны в носке, имеют удобную форму, крепкий задник, который надежно фиксирует ноги малышей, но не ограничивает их в движениях. В ассортименте бренда есть как тапочки для дома и садика, так и варианты для дошкольников или школьников, уже бегающих по улице и занимающихся физкультурой. С такой обувью любая активность будет в радость!