SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/skaterti/gray-silver-120cm_less.html' LIMIT 0,1 [0.0003349781036377 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('gray','silver','120cm_less') order by url [0.00072598457336426 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('gray','silver','120cm_less') order by url [0.00051999092102051 sec]
select id from pod_structure where link='catalogue/12' and active='1' AND lang_ru='1' [0.00018692016601562 sec]
SELECT id, url FROM pod_filter WHERE url IN ('gray','silver','120cm_less') [0.0005500316619873 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('gray','silver','120cm_less') [0.00044488906860352 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 (1031,32,85) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00022506713867188 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.00024008750915527 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 (12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196) 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 (12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.26493501663208 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.00035405158996582 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.02907919883728 sec]
SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,85) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE g.is_present AND 1 UNION SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ 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,85) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE 1 [0.05980396270752 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b99d133e1f ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00026297569274902 sec]
INSERT INTO temp_brand_counts_6a2b99d133e1f (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,85) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE g.is_present AND 1 UNION SELECT g.brand_id AS id, g.id AS gid /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ 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,85) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE 1 [0.012362003326416 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_6a2b99d133e1f 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.00056290626525879 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b99d133e1f [0.00015497207641602 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:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,85) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ 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,85) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE 1 ) A [0.014081954956055 sec]
SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */,if(g.is_present and g.price >= '49' and g.price <= '1690',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 >= '49' and g.price <= '1690',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 >= '49' AND pcg.price <= '1690' WHERE g.id IN (412602,412603,468200,468203,468249,503289,503291,507490,426426,447883,458707,458719,458842,465835,465841,465842,465854,485130,485132,487222,498894,498899,460360,460361,462184,462190,466230,468201,468202,470351,470357,473818,473819,473830,473831,478721,482914,482916,482917,482919,483619,483629,492138,494093,494213,503287,507700,507701,373360,422165,430464,430885,462186,462192,468322,470349,478558,478559,478564,480677,480678,482287,483617,483620,483627,487128,494092,494094,227890,228747,228773,228784,229104,264577,281520,340236,375618,386705,386951,386973,399949,460353,492137,507487,507702,507796) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0040161609649658 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 >= '49' and g.price <= '1690',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 >= '49' and g.price <= '1690',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 >= '49' and pcg.price <= '1690') WHERE g.id in (426426,503287,465854,503289,483620,507796,483619,503291,480678,480677,478721,494094,494093,494092,465841,465842,229104,465835,386951,227890,458842,482287,422165,473831,507487,375618,468322,485132,462184,482919,447883,507702) GROUP BY g.id ORDER BY g.ordr desc [0.0034470558166504 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 (426426,503287,465854,503289,483620,507796,483619,503291,480678,480677,478721,494094,494093,494092,465841,465842,229104,465835,386951,227890,375618,422165,447883,458842,462184,468322,473831,482287,482919,485132,507487,507702) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00085306167602539 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 (426426,503287,465854,503289,483620,507796,483619,503291,480678,480677,478721,494094,494093,494092,465841,465842,229104,465835,386951,227890,375618,422165,447883,458842,462184,468322,473831,482287,482919,485132,507487,507702) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0047750473022461 sec]
SELECT id, name AS name, url FROM pod_filter WHERE id in (1031,32,85) AND is_active='1' [0.0002598762512207 sec]
SELECT cf.id, cf.info AS info, cf.title AS title, cf.metadesc AS metadesc, cf.seo_text AS seo_text, cf.tagH1 AS tagH1, cf.is_active FROM pod_set_cat_filter cf INNER JOIN pod_filter f ON cf.filter_value_id = f.id WHERE cf.cat_id = 12 AND f.id = '1031' LIMIT 1 [0.00026917457580566 sec]
SELECT cf.id, cf.info AS info, cf.title AS title, cf.metadesc AS metadesc, cf.seo_text AS seo_text, cf.tagH1 AS tagH1, cf.is_active FROM pod_set_cat_subicon cf INNER JOIN pod_sub_icon f ON cf.subicon_id = f.id WHERE cf.cat_id = 12 AND f.url = 'gray' LIMIT 1 [0.00030803680419922 sec]
SELECT id, name AS name, url, entry FROM pod_cat_category WHERE is_active='1' AND is_hidden='0' AND entry='0' AND super_category_id='1' AND id!='12' ORDER BY ordr [0.00074195861816406 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677; CREATE TEMPORARY TABLE tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.0003509521484375 sec]
INSERT INTO tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 (id) SELECT A.id FROM ( SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,85) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE g.is_present AND 1 UNION SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ 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,85) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE 1 ) A [0.011616230010986 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677; CREATE TEMPORARY TABLE tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00027608871459961 sec]
INSERT INTO tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32,85,1031) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 12 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.029545068740845 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677; CREATE TEMPORARY TABLE tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0003821849822998 sec]
INSERT IGNORE INTO tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 p GROUP BY p.filter_id [0.00040197372436523 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_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 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.0003659725189209 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 [0.00023698806762695 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 [0.00014019012451172 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d142677 [0.00010418891906738 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0; CREATE TEMPORARY TABLE tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.0001978874206543 sec]
INSERT INTO tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,85) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ 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,85) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE 1 ) A [0.01096510887146 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0; CREATE TEMPORARY TABLE tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.0003509521484375 sec]
INSERT INTO tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32,85,1031) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 12 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.0043308734893799 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0; CREATE TEMPORARY TABLE tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0002589225769043 sec]
INSERT IGNORE INTO tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 p GROUP BY p.filter_id [0.00029301643371582 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_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 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.00024795532226562 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 [0.00021600723266602 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 [9.1075897216797E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d14d6d0 [8.8930130004883E-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 (1031) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00027203559875488 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327; CREATE TEMPORARY TABLE tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00038695335388184 sec]
INSERT INTO tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 (id) SELECT A.id FROM ( SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (1031) WHERE g.is_present AND 1 UNION SELECT g.id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ 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 (1031) WHERE 1 ) A [0.0034551620483398 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327; CREATE TEMPORARY TABLE tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00037193298339844 sec]
INSERT INTO tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 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.027354001998901 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327; CREATE TEMPORARY TABLE tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00041294097900391 sec]
INSERT INTO tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 p GROUP BY p.filter_id [0.00043201446533203 sec]
INSERT IGNORE INTO tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 c ON c.filter_id = pf.id WHERE pf.id in (32,85) AND c.filter_id IS NULL [0.00031805038452148 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_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 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.00031495094299316 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 [0.00026106834411621 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 [0.00011014938354492 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d152327 [0.00010299682617188 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5; CREATE TEMPORARY TABLE tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00021100044250488 sec]
INSERT INTO tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,85) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ 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,85) WHERE 1 ) A [0.0097341537475586 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5; CREATE TEMPORARY TABLE tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.00031304359436035 sec]
INSERT INTO tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 1030 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.038820028305054 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5; CREATE TEMPORARY TABLE tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00049304962158203 sec]
INSERT INTO tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 p GROUP BY p.filter_id [0.00060296058654785 sec]
INSERT INTO tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 c ON c.filter_id = pf.id WHERE pf.id in (1031) AND c.filter_id IS NULL [0.00037598609924316 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_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 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.00037693977355957 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 [0.00028610229492188 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 [0.00012397766113281 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d15aea5 [0.00011110305786133 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4; CREATE TEMPORARY TABLE tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00026202201843262 sec]
INSERT IGNORE INTO tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4 (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:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32,85) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:12,330,458,722,217,470,124,122,170,1913,444,526,296,126,123,1093,196 */ 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,85) INNER JOIN pod_good_filter gf1 ON go.id = gf1.id_good AND gf1.filter_id_value in (1031) WHERE 1 ) A [0.016700029373169 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4; CREATE TEMPORARY TABLE tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00043487548828125 sec]
INSERT IGNORE INTO tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4 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.00066208839416504 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4 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.00030112266540527 sec]
----------------------------- SELECT COUNT(*) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.023771047592163 sec]
Array ( [0] => Array ( [COUNT(*)] => 8062 ) ) SELECT COUNT(DISTINCT filter_id) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.029217004776001 sec]
Array ( [0] => Array ( [COUNT(DISTINCT filter_id)] => 9 ) ) ----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4 [0.00038409233093262 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_aat7k7dhk5ujftanc4fn5b11gm_6a2b99d167dd4 [0.00021195411682129 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00030183792114258 sec]
Скатерти - купить скатерть в Украине и Киеве, цена в каталоге, интернет магазин Podushka.com.ua
UA
RU
Вход в кабинет

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

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

Скатерти : серый, серебристый, 120 см и менее

Как правильно выбрать скатерть: размер, форма, цвет.
Найдено 86 товаров
Вы выбрали
Очистить все фильтры
Скатерти
Материал:
Производитель
SoundSleep (5)
MirSon (2)
Прованс (40)
Home line (5)
ТЕП (2)
Больше производителей
Умные фильтры
Со скидкой!
Быстрая доставка
Новинка
Распродажа
Размер
размер 30х100 см (2)
Основной цвет
Белый/Молочный (5)
Бежевый/Кремовый (4)
Синий/Голубой (1)
Красный/Бордовый (5)
Фиолетовый/Сиреневый (2)
Розовый/Пудровый (2)
Серый (85)
Коричневый (2)
Зеленый/Салатовый (1)
Бирюзовый/Аквамариновый (1)
Оранжевый/Абрикосовый (6)
Черный (17)
Желтый/Песочный (2)
Золотой (6)
Серебристый (2)
Разноцветный (4)
Хаки (3)
Показать больше
Квадратные скатерти
размер 100х100см (13)
от 80 до 95см (2)
Длина скатерти
140 см и меньше (77)
141-160 см (10)
161-190 см (6)
Ширина скатерти
120 см и менее (86)
121-130 см (4)
131-140 см (76)
141-150 см (18)
151-160 см (6)
161-180 см (12)
181-200 см (1)
Показать больше
Наборы для
6 персон и менее (8)
Вид скатерти
скатерть (39)
салфетка (26)
настольник (2)
дорожка (17)
набор (2)
раннер (18)
Показать больше
Тип рисунка
цветы (24)
животные (7)
однотонные (34)
геометрический рисунок (6)
абстракция (6)
еда (2)
полоски/клетка (1)
новогодний (11)
люди (1)
пасхальный (6)
этнический (2)
Показать больше
Цена
—
грн

Смотрите также
Сортировать:
по популярности
Выбрать производителя
Скатерть кухонная Код Незламної Нації SoundSleep серо-синяя - 40 %
Скатерть кухонная Код Незламної Нації SoundSleep серо-синяя
Код: 426426
delivary icon

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

размер 140х180 см

1 814 грн 789 грн
В 1 клик Купить
Цена:
789 грн 1 324 грн
Сервировочная салфетка Jordan Sonex серая
Сервировочная салфетка Jordan Sonex серая
Код: 503287

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

Цена:
192 грн
Ранер новогодний водостойкий Winter Love SoundSleep серый - 20 %
Ранер новогодний водостойкий Winter Love SoundSleep серый
Код: 465854
delivary icon

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

Цена:
184 грн 230 грн
Ранер Jordan Sonex серый
Ранер Jordan Sonex серый
Код: 503289

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

Цена:
528 грн
Скатерть хлопковая Раф Прованс
Скатерть хлопковая Раф Прованс
Код: 483620

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

размер 136х180 см

489 грн
В 1 клик Купить
Цена:
336 грн
Скатерть гобеленовая Лавандовый садик Прованс Новинка
Скатерть гобеленовая Лавандовый садик Прованс
Код: 507796

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

размер 135х140 см

1 690 грн
В 1 клик Купить
Показать больше
Цена:
960 грн
Салфетка Раф Прованс
Салфетка Раф Прованс
Код: 483619

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

Цена:
49 грн
Скатерть прямоугольная Jordan Sonex серая
Скатерть прямоугольная Jordan Sonex серая
Код: 503291

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

Цена:
1 368 грн
Скатерть хлопковая Flora Прованс
Скатерть хлопковая Flora Прованс
Код: 480678

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

размер 132х180 см

490 грн
В 1 клик Купить
Цена:
390 грн
Дорожка хлопковая Flora Прованс
Дорожка хлопковая Flora Прованс
Код: 480677

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

Цена:
249 грн
Чехол для столовых приборов Листья Прованс
Чехол для столовых приборов Листья Прованс
Код: 478721

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

Цена:
62 грн
Скатерть новогодняя Noel Прованс
Скатерть новогодняя Noel Прованс
Код: 494094

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

размер 136х180 см

449 грн
В 1 клик Купить
Цена:
329 грн
Салфетка новогодняя Noel Прованс
Салфетка новогодняя Noel Прованс
Код: 494093

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

Цена:
62 грн
Дорожка новогодняя Noel Прованс
Дорожка новогодняя Noel Прованс
Код: 494092

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

Цена:
134 грн
Ранер водостойкий SoundSleep Loisa темно-серый - 10 %
Ранер водостойкий SoundSleep Loisa темно-серый
Код: 465841
delivary icon

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

Цена:
201 грн 223 грн
Ранер водостойкий SoundSleep Loisa серый - 10 %
Ранер водостойкий SoundSleep Loisa серый
Код: 465842
delivary icon

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

Цена:
201 грн 223 грн
Скатерть гобеленовая LiMaSo SKG21
Скатерть гобеленовая LiMaSo SKG21
Код: 229104

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

размер 137х137 см

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

диаметр 140 см

1 328 грн
В 1 клик Купить
Показать больше
Цена:
586 грн
Скатерть водостойкая SoundSleep Loisa темно-серый - 24 %
Скатерть водостойкая SoundSleep Loisa темно-серый
Код: 465835
delivary icon

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

размер 130х180 см

647 грн 489 грн
В 1 клик Купить
Цена:
485 грн
Скатерть гобеленовая LiMaSo ZOOM004
Скатерть гобеленовая LiMaSo ZOOM004
Код: 386951

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

Показать больше
Цена:
989 грн
Скатерть гобеленовая LiMaSo SK0065
Скатерть гобеленовая LiMaSo SK0065
Код: 227890

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

Показать больше
Цена:
943 грн
Скатерть гобеленовая новогодняя Estrellas Lefard
Скатерть гобеленовая новогодняя Estrellas Lefard
Код: 375618

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

размер 140х140 см

1 655 грн
В 1 клик Купить
Цена:
1 025 грн
Скатерть хлопковая Кот на кухне Home Line серо-сиреневая
Скатерть хлопковая Кот на кухне Home Line серо-сиреневая
Код: 422165

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

размер 150х150 см

262 грн
В 1 клик Купить
Цена:
225 грн
Скатерть пятноустойчивая Айс вензель Simfoni Прованс
Скатерть пятноустойчивая Айс вензель Simfoni Прованс
Код: 447883

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

Цена:
890 грн
Скатерть водоотталкивающая Shadow Cosas
Скатерть водоотталкивающая Shadow Cosas
Код: 458842

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

размер 100х140 см

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

размер 100х180 см

1 290 грн
В 1 клик Купить
Показать больше
Цена:
1 190 грн
Салфетка Grand серая Прованс
Салфетка Grand серая Прованс
Код: 462184

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

Цена:
99 грн
Ранер хлопковый Oliver Ardesto светло-серый
Ранер хлопковый Oliver Ardesto светло-серый
Код: 468322

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

Цена:
299 грн
Чехол для столовых приборов Barcelona Gray Прованс
Чехол для столовых приборов Barcelona Gray Прованс
Код: 473831

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

Цена:
55 грн
Скатерть хлопковая Рыбки Home Line серый
Скатерть хлопковая Рыбки Home Line серый
Код: 482287

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

Цена:
225 грн
Салфетка круглая Каберне серая Прованс с рюшем
Салфетка круглая Каберне серая Прованс с рюшем
Код: 482919

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

Цена:
249 грн
Дорожка водоотталкивающая V11 Grey DUCK Ecotton
Дорожка водоотталкивающая V11 Grey DUCK Ecotton
Код: 485132

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

Цена:
305 грн
Раннер гобеленовый Lefard серый Новинка
Раннер гобеленовый Lefard серый
Код: 507487

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

Цена:
503 грн
Скатерть гобеленовая Очарование Прованс Новинка
Скатерть гобеленовая Очарование Прованс
Код: 507702

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

размер 135х140 см

1 690 грн
В 1 клик Купить
Показать больше
Цена:
960 грн
1 2 3