SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/postelnoe_bele/white-3d-tep.html' LIMIT 0,1 [0.00048184394836426 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('white','3d','tep') order by url [0.0012719631195068 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('white','3d','tep') order by url [0.00093698501586914 sec]
select id,url from pod_cat_brand where BINARY url IN ('white','3d','tep') [0.0016369819641113 sec]
SELECT cb.metaindex, cb.metafollow
FROM pod_set_cat_brand cb
INNER JOIN pod_cat_category c ON cb.cat_id = c.id
WHERE c.url = 'postelnoe_bele'
AND cb.brand_id = 1005
AND cb.is_active = 1
LIMIT 1 [0.00068902969360352 sec]
SELECT id, url FROM pod_filter WHERE url IN ('white','3d','tep') [0.000701904296875 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('white','3d','tep') [0.00063204765319824 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.00057220458984375 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 (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) 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 (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.68917012214661 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.00048995018005371 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.42508006095886 sec]
SELECT g.id /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (391)
INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (21)
WHERE g.brand_id IN (1005) AND
1
[0.0067040920257568 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a300959b5c1d (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.00028300285339355 sec]
INSERT INTO temp_brand_counts_6a300959b5c1d (id, gid)
SELECT g.brand_id AS id, g.id AS gid /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (391)
INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (21)
WHERE 1
UNION
SELECT id, null gid
FROM pod_cat_category
WHERE id in (1005) [0.0017261505126953 sec]
SELECT b.id, b.name_ua AS name, pc.name_ua 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_6a300959b5c1d
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.00037908554077148 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a300959b5c1d [0.00012898445129395 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:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (391)
INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (21)
WHERE g.brand_id IN (1005) AND
g.is_present AND
1
UNION
SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */
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 (391)
INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (21)
WHERE g.brand_id IN (1005) AND
1
) A
[0.00046300888061523 sec]
SELECT g.id,if(g.is_present and g.price >= '0' and g.price <= '99999',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 >= '0' and g.price <= '99999',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price
FROM (
SELECT g.id /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (391)
INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (21)
WHERE g.brand_id IN (1005) AND
1
) a INNER JOIN pod_cat_good g ON a.id = g.id
LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id and pcg.is_present=1 and pcg.is_present=1 and pcg.price >= '0' and pcg.price <= '99999' GROUP BY g.id
ORDER BY g.ordr desc
LIMIT 0, 32 [0.0008549690246582 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id in (1005) [0.00017690658569336 sec]
SELECT cb.id,
cb.info_ua AS info,
cb.title_ua AS title,
cb.metadesc_ua AS metadesc,
cb.seo_text_ua AS seo_text,
cb.tagH1_ua AS tagH1,
cb.canonical,
cb.is_active
FROM pod_set_cat_brand cb
WHERE
cb.cat_id = 3
AND cb.brand_id = 1005
AND cb.is_active = 1
LIMIT 1 [0.0002439022064209 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id='1005' [0.00020599365234375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6;
CREATE TEMPORARY TABLE tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00045609474182129 sec]
INSERT INTO tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6 (goods_id, filter_id)
SELECT DISTINCT
t.id AS goods_id,
f.id AS filter_id
FROM pod_cat_filter cf
INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active
INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good)
ON gf.filter_id = cf.filter_id AND gf.cat_id IN (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND gf.filter_id_value NOT IN (391,21)
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active
INNER JOIN tmp_base_goods t ON gf.id_good = t.id
WHERE cf.category_id = 3 [0.17076587677002 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6;
CREATE TEMPORARY TABLE tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.0003211498260498 sec]
INSERT IGNORE INTO tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6 p
GROUP BY p.filter_id [0.0014660358428955 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name_ua AS name,
f.url,
f.ord,
fm.name_ua AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6 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.00035381317138672 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6 [0.00025701522827148 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959b9fa6 [9.2029571533203E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc;
CREATE TEMPORARY TABLE tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00017094612121582 sec]
INSERT INTO tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc (goods_id, filter_id)
SELECT DISTINCT
ts.entry AS goods_id,
f.id AS filter_id
FROM pod_cat_filter cf
INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active
INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good)
ON gf.filter_id = cf.filter_id AND gf.cat_id IN (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND gf.filter_id_value NOT IN (391,21)
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active
INNER JOIN tmp_sub_goods ts ON gf.id_good = ts.id
WHERE cf.category_id = 3 [0.065269947052002 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc;
CREATE TEMPORARY TABLE tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.0003669261932373 sec]
INSERT IGNORE INTO tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc p
GROUP BY p.filter_id [0.00049805641174316 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name_ua AS name,
f.url,
f.ord,
fm.name_ua AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc 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.00035381317138672 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc [0.00034284591674805 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a300959e4cfc [0.00017809867858887 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e;
CREATE TEMPORARY TABLE tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00025486946105957 sec]
INSERT INTO tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e (goods_id, filter_id)
SELECT DISTINCT
t.id AS goods_id,
f.id AS filter_id
FROM pod_cat_filter cf
INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active
INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good)
ON gf.filter_id = cf.filter_id AND gf.cat_id IN (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND gf.filter_id = 8
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active
INNER JOIN tmp_base_goods t ON gf.id_good = t.id
WHERE cf.category_id = 3 [0.03721809387207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e;
CREATE TEMPORARY TABLE tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00024700164794922 sec]
INSERT INTO tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e p
GROUP BY p.filter_id [0.00069594383239746 sec]
INSERT IGNORE INTO tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e c ON c.filter_id = pf.id
WHERE pf.id in (391) AND c.filter_id IS NULL [0.00014805793762207 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name_ua AS name,
f.url,
f.ord,
fm.name_ua AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e 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.00022983551025391 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e [0.0001990795135498 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a01a5e [7.7962875366211E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8;
CREATE TEMPORARY TABLE tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00016212463378906 sec]
INSERT INTO tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 (goods_id, filter_id)
SELECT DISTINCT
t.id AS goods_id,
f.id AS filter_id
FROM pod_cat_filter cf
INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active
INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good)
ON gf.filter_id = cf.filter_id AND gf.cat_id IN (3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689) AND gf.filter_id = 20
INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active
INNER JOIN tmp_base_goods t ON gf.id_good = t.id
WHERE cf.category_id = 3 [0.0485520362854 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8;
CREATE TEMPORARY TABLE tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00042009353637695 sec]
INSERT INTO tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 p
GROUP BY p.filter_id [0.00080394744873047 sec]
INSERT IGNORE INTO tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 c ON c.filter_id = pf.id
WHERE pf.id in (21) AND c.filter_id IS NULL [0.00018310546875 sec]
SELECT
c.filter_id,
c.count,
f.entry,
f.name_ua AS name,
f.url,
f.ord,
fm.name_ua AS mname,
fm.url AS murl,
fm.ord AS mord
FROM tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 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.00024199485778809 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 [0.00019407272338867 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a0baa8 [8.7976455688477E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8;
CREATE TEMPORARY TABLE tmp_A_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8 (
entry INT NOT NULL,
sub_icon_id INT NOT NULL,
PRIMARY KEY (entry, sub_icon_id),
INDEX idx_sub_icon_id (sub_icon_id)
) ENGINE=MEMORY; [0.00019502639770508 sec]
INSERT IGNORE INTO tmp_A_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8 (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:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */
FROM tmp_base_goods g
INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (391)
INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (21)
WHERE g.brand_id IN (1005) AND
g.is_present AND
1
UNION
SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:3,365,18,34,82,158,205,263,332,363,471,1881,3489,16,17,62,76,2927,95,35,99,49,81,72,469,552,2973,102,104,103,3014,202,3019,1149,319,247,299,2078,2237,2630,1052,1092,19,211,213,334,337,80,556,140,1039,689 */
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 (391)
INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (21)
WHERE g.brand_id IN (1005) AND
1
) A [0.00079894065856934 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8;
CREATE TEMPORARY TABLE tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8 (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00022387504577637 sec]
INSERT IGNORE INTO tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8 (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8 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.00026488304138184 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name_ua AS name,
si.url
FROM tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8 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.00017499923706055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8 [0.00016093254089355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_d12bho9cqoujkne5hvb8fq76mm_6a30095a187e8 [7.3909759521484E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00012087821960449 sec]
Постільна білизна ТЕП - купити постільна білизна ТЕП в Києві і Україні: відгуки> Podushka
Український виробник спальних приладдя створює продукцію на власній фабриці з 1996 року. Вироби проходять 4-орівневий контроль якості, що виключає надходження шлюбу в продаж. Під час пошиття виробів враховується усадка тканини, тому постільна білизна ТЕП ніколи не зраджує розмірів.
5 нюансів, на які варто звернути увагу при виборі
Переваги білизни постільної ТЕП роблять його фаворитом на українському ринку текстилю. Серед головних плюсів продукції:
Натуральні тканини. Вироби шиються з бавовни щільністю 112 г / кв.м. Постільна білизна ТЕП добре вбирає вологу, дихає, не накопичує пил і статичну електрику. Приналежності витримують багаторазові прання, не рвуться.
Дизайн. Ексклюзивний дизайн - це вже привід купити постільна білизна ТЕП. На виробах розквітають квіти, змінюються пори року і живуть мультяшні персонажі. Ви можете вибрати сет з абстрактними малюнками і геометричними формами. Кольори на постільній білизні «ТЕП» не вигоряють. Застосування стійких барвників забезпечує стійкий колір, який не втрачає яскравості після декількох років використання.
Пошиття. Українські швачки створюють спальні аксесуари як для себе. Рівні і міцні шви порадують найвимогливіших господинь.
Комплектація. В інтернет-магазині представлені комплекти, що включають простирадло, підодіяльник і 2 наволочки. Все, що потрібно для комфортного сну в одній ПВХ-упаковці. Розміри. Сімейні, полуторні, євро, двоспальні, підліткові - постільні сети ТЕП представлені у великому асортименті для дітей і дорослих.
Де придбати спальне приладдя українського виробника
В інтернет-магазині «Подушка» можна купити постільна білизна Теп в Києві з доставкою в Харків, Дніпропетровськ, Львів і Одесу. У каталозі представлені спальні аксесуари для шанувальників різних стилів:
класичні вироби в приглушеною кольоровій гамі з рослинними візерунками
барвисті приналежності з абстрактними малюнками
білизна постільна «ТЕП» з кумедними яскравими картинками
лаконічні аксесуари для інтер'єрів в стилі мінімалізм
романтичні комплекти в рожевого-лавандових тонах
чоловічі набори ТЕП в приглушених тонах з ненав'язливим принтом.
Замовте постільний сет за вигідною ціною з доставкою по всій Україні - подаруйте собі і близьким комфортний сон.
Ваше замовлення оформлено! На e-mail відправлено лист з підтвердженням Найближчим часом з Вами зв'яжеться менеджер Дякємо за замовлення!
Ваш профіль буде видалений назавжди. Його не можна відновити. Продовжити?
Залиште свій номер телефону і наші менеджери Вам зателефонують
Оплату картами Visa і MasterCard забезпечує сервіс онлайн-платежів Portmone.com. Безпека оплати підтверджена міжнародним аудитом PCI DSS. Служба підтримки: тел. +380 (44) 2000902