SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/postelnoe_bele/gray-soundsleep.html' LIMIT 0,1 [0.00068306922912598 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('gray','soundsleep') order by url [0.001784086227417 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('gray','soundsleep') order by url [0.0013518333435059 sec]
select id,url from pod_cat_brand where BINARY url IN ('gray','soundsleep') [0.002108097076416 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 = 1039
AND cb.is_active = 1
LIMIT 1 [0.00077390670776367 sec]
SELECT id, url FROM pod_filter WHERE url IN ('gray','soundsleep') [0.00051093101501465 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('gray','soundsleep') [0.00047087669372559 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.00052595138549805 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.74226379394531 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.00040197372436523 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.42853593826294 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 (32)
WHERE g.brand_id IN (1039) AND
1
[0.020286798477173 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2fd2ff43d84 (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.0010452270507812 sec]
INSERT INTO temp_brand_counts_6a2fd2ff43d84 (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 (32)
WHERE 1
UNION
SELECT id, null gid
FROM pod_cat_category
WHERE id in (1039) [0.11798596382141 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_6a2fd2ff43d84
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.0017800331115723 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2fd2ff43d84 [0.00023698806762695 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 (32)
WHERE g.brand_id IN (1039) 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 (32)
WHERE g.brand_id IN (1039) AND
1
) A
[0.0016121864318848 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 */,if(g.is_present and g.price >= '293' and g.price <= '5970',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 >= '293' and g.price <= '5970',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 >= '293' AND pcg.price <= '5970'
WHERE g.id IN (485461,446756,400266,302602,502712,393763,239385,477525,419805,360597,507171,507110,502446,497989,497676,497671,497661,497652,497623,490418,473792,400215,507146,507120,507115,497984,473783,468068)
GROUP BY g.id
ORDER BY g.ordr desc
LIMIT 0, 32 [0.0051460266113281 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 >= '293' and g.price <= '5970',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 >= '293' and g.price <= '5970',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 >= '293' and pcg.price <= '5970')
WHERE g.id in (473792,497984,502446,419805,497989,497671,485461,497661,497676,497652,400266,477525,497623,239385,393763,490418,473783,302602,400215,360597,507171,507115,446756,507120,502712,468068,507146,507110)
GROUP BY g.id
ORDER BY g.ordr desc [0.007861852645874 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 (473792,497984,502446,419805,497989,497671,485461,497661,497676,497652,400266,477525,497623,239385,393763,490418,473783,302602,400215,360597,446756,468068,507110,502712,507115,507120,507146,507171) AND g.is_present = '1' AND g.is_active = '1'
ORDER BY g.entry, g.is_present DESC [0.0013270378112793 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 (473792,497984,502446,419805,497989,497671,485461,497661,497676,497652,400266,477525,497623,239385,393763,490418,473783,302602,400215,360597,446756,468068,507110,502712,507115,507120,507146,507171)
ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.01723313331604 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 = 3
AND cb.brand_id = 1039
AND cb.is_active = 1
LIMIT 1 [0.0004279613494873 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9;
CREATE TEMPORARY TABLE tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00044608116149902 sec]
INSERT INTO tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9 (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 (32)
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.21683812141418 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9;
CREATE TEMPORARY TABLE tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00038695335388184 sec]
INSERT IGNORE INTO tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9 p
GROUP BY p.filter_id [0.0015239715576172 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_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9 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.00036287307739258 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9 [0.00024008750915527 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ff6e2c9 [0.00010585784912109 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf;
CREATE TEMPORARY TABLE tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00018119812011719 sec]
INSERT INTO tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf (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 (32)
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.055964946746826 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf;
CREATE TEMPORARY TABLE tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00038003921508789 sec]
INSERT IGNORE INTO tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf p
GROUP BY p.filter_id [0.00053000450134277 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_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf 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.00028705596923828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf [0.00024580955505371 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffa44bf [9.2029571533203E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2;
CREATE TEMPORARY TABLE tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00017404556274414 sec]
INSERT INTO tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 (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.044995069503784 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2;
CREATE TEMPORARY TABLE tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00035285949707031 sec]
INSERT INTO tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 p
GROUP BY p.filter_id [0.00078392028808594 sec]
INSERT IGNORE INTO tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 c ON c.filter_id = pf.id
WHERE pf.id in (32) AND c.filter_id IS NULL [0.00018596649169922 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_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 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.00024604797363281 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 [0.00022006034851074 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffb2bd2 [9.8943710327148E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c;
CREATE TEMPORARY TABLE tmp_A_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c (
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.00016498565673828 sec]
INSERT IGNORE INTO tmp_A_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c (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 (32)
WHERE g.brand_id IN (1039) 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 (32)
WHERE g.brand_id IN (1039) AND
1
) A [0.0082669258117676 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c;
CREATE TEMPORARY TABLE tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00024008750915527 sec]
INSERT IGNORE INTO tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c 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.00031900405883789 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name AS name,
si.url
FROM tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c 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.00019097328186035 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c [0.00018811225891113 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_lshtge791brhmkr0u10cscbk5q_6a2fd2ffbea4c [8.2969665527344E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00014805793762207 sec]
Постельное белье SoundSleep (СаундСлип) – большой выбор, фото, отзывы. Купить Постельное белье SoundSleep в Киеве и Украине
Украинская ТМ SoundSleep занимается изготовлением высококачественного домашнего текстиля. Этот производитель предлагает покупателям следующий ассортимент продукции:
комплекты постельного белья;
ортопедические и простые подушки;
демисезонные, летние и теплые одеяла;
скатерти, салфетки;
прочий текстиль.
Продукция компании SoundSleep известна потребителям своим высоким качеством, доступной стоимостью и примечательными декоративными свойствами.
Состав постельного белья SoundSleep
Комплекты от этого производителя создаются из прочных, износостойких, качественных материй. Используемые ткани являются натуральными, что обеспечивает им безопасность использования. Компания предлагает покупателям постельное белье SoundSleep из следующих материалов:
поплин;
сатин;
ранфорс;
жаккард;
бязь.
Эти ткани обладают широким перечнем полезных потребительских качеств:
они приятны к коже;
материи легко пропускают воздух;
они обладают хорошей гигроскопичностью;
они эффективно удерживают тепло, обеспечивая комфортный отдых в прохладный сезон.
Дизайн постельного белья SoundSleep
Комплекты постельного от ТМ SoundSleep имеют благородный, эстетически привлекательный вид. Они могут иметь спокойную, нежную, романтическую окраску или яркую, сочную расцветку. Многие изделия украшены вышитыми узорами, орнаментом, реалистичными объемными изображениями. Широкий выбор моделей постельного белья SoundSleep и его практичность позволяет использовать постельные комплекты в качестве универсального подарка на любой праздник. Продукция компании SoundSleep обеспечивает здоровый и качественный отдых потребителю.
Ваш заказ оформлен! На e-mail отправлено письмо с подтверждением В ближайшее время с Вами свяжется менеджер Спасибо за заказ!
Ваш профиль будет удален навсегда. Его нельзя восстановить. Продолжить?
Оставьте свой номер телефона и наши менеджеры вам перезвонят
Оплату картами Visa и MasterCard обеспечивает сервис онлайн-платежей Portmone.com. Безопасность оплаты подтверждена международным аудитом PCI DSS. Служба поддержки: тел. +380(44)2000902