SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/postelnoe_bele/paskhalnyy-tep.html' LIMIT 0,1 [0.00030994415283203 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('paskhalnyy','tep') order by url [0.0009000301361084 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('paskhalnyy','tep') order by url [0.00054502487182617 sec]
select id,url from pod_cat_brand where BINARY url IN ('paskhalnyy','tep') [0.00092601776123047 sec]
select id from pod_structure where link='catalogue/3' and active='1' AND lang_ru='1' [0.00020599365234375 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.00034809112548828 sec]
SELECT id, url FROM pod_filter WHERE url IN ('paskhalnyy','tep') [0.0002739429473877 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('paskhalnyy','tep') [0.00020003318786621 sec]
SELECT c.id, c.super_category_id, c.entry,
c.name AS name, c.title AS cat_title, c.metakwds AS cat_kwds,
c.metadesc AS cat_metadesc,
c.descr AS cat_descr,
cc.name AS parent_name, cc.url AS parent_url, c.url as curl, cc.image AS parent_image,
c.seo_text AS seo_text,
c.seo_text_mobile AS seo_text_mobile,
c.action_text AS action_text,
c.view_type, c.is_delivery_custom, c.hide_subcat_sidebar, c.image
FROM pod_cat_category c
LEFT JOIN pod_cat_category cc ON cc.id=c.entry
WHERE c.id='3' [0.00032401084899902 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 (3425) and f.is_active AND mf.is_active
ORDER BY mf.id, f.id [0.00016999244689941 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.0003058910369873 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.69356393814087 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.00044584274291992 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.37403702735901 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 (3425)
WHERE g.brand_id IN (1005) AND
1
[0.001209020614624 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b39f5562fb (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.00042605400085449 sec]
INSERT INTO temp_brand_counts_6a2b39f5562fb (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 (3425)
WHERE 1
UNION
SELECT id, null gid
FROM pod_cat_category
WHERE id in (1005) [0.0011169910430908 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_6a2b39f5562fb
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.00073385238647461 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b39f5562fb [0.00024294853210449 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 (3425)
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 (3425)
WHERE g.brand_id IN (1005) AND
1
) A
[0.0010139942169189 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 (3425)
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.0015568733215332 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 = 1005
AND cb.is_active = 1
LIMIT 1 [0.00026106834411621 sec]
SELECT p.id, p.dt, p.title as title, p.descr, p.thumb, p.url, s.link
FROM pod_publication p
LEFT JOIN pod_pub_type pt ON pt.id=p.rub_id
LEFT JOIN pod_structure s ON pt.page_id=s.id
LEFT JOIN pod_cat_public cp ON (cp.public_id = p.id)
WHERE p.rub_id = 2 AND p.active='1' AND cp.category_id='3'
ORDER BY p.dt DESC LIMIT 1 [0.0057029724121094 sec]
SELECT id, name AS name, url, entry FROM pod_cat_category WHERE is_active='1' AND is_hidden='0' AND entry IN (1,2,11,605,4389,2952,2746,5,13,514,894,52,36,237,77,2615,12,473,207,113,1011,39,183,70,2332,2888,242,610,636,1057,2903) ORDER BY ordr [0.0046911239624023 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4;
CREATE TEMPORARY TABLE tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.0004279613494873 sec]
INSERT INTO tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 (id) SELECT A.id 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 (3425)
WHERE g.brand_id IN (1005) AND
1
) A [0.00066995620727539 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4;
CREATE TEMPORARY TABLE tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00034689903259277 sec]
INSERT INTO tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (3425)
INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 3
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.0087740421295166 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4;
CREATE TEMPORARY TABLE tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00035214424133301 sec]
INSERT IGNORE INTO tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 p
GROUP BY p.filter_id [0.00021195411682129 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_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 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.00018692016601562 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 [0.00017905235290527 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 [0.00012302398681641 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f55d8d4 [8.5115432739258E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae;
CREATE TEMPORARY TABLE tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae (
id INT NOT NULL,
entry INT NOT NULL,
PRIMARY KEY (id),
KEY idx_entry (entry)
) ENGINE=MEMORY; [0.00019216537475586 sec]
INSERT INTO tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae (id, entry) SELECT A.id, A.entry FROM (
SELECT g.id as id, g.id as entry /* 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 (3425)
WHERE g.brand_id IN (1005) AND
g.is_present AND
1
UNION
SELECT go.id as id, g.id as entry /* 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 (3425)
WHERE g.brand_id IN (1005) AND
1
) A [0.00046300888061523 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae;
CREATE TEMPORARY TABLE tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.0002129077911377 sec]
INSERT INTO tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae (goods_id, filter_id)
SELECT DISTINCT
A.entry AS goods_id,
f.id AS filter_id
FROM tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (3425)
INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 3
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.00028586387634277 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae;
CREATE TEMPORARY TABLE tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00018596649169922 sec]
INSERT IGNORE INTO tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae p
GROUP BY p.filter_id [0.00019407272338867 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_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae 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.00014019012451172 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae [0.00015401840209961 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae [7.2956085205078E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f560aae [7.2002410888672E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d;
CREATE TEMPORARY TABLE tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.0001378059387207 sec]
INSERT INTO tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d (id) SELECT A.id 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
WHERE g.brand_id IN (1005) AND
1
) A [0.00028204917907715 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d;
CREATE TEMPORARY TABLE tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d (
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_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 8
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.014075040817261 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d;
CREATE TEMPORARY TABLE tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00032711029052734 sec]
INSERT INTO tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d p
GROUP BY p.filter_id [0.00031304359436035 sec]
INSERT IGNORE INTO tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d c ON c.filter_id = pf.id
WHERE pf.id in (3425) AND c.filter_id IS NULL [0.00018692016601562 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_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d 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.00023102760314941 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d [0.00022006034851074 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d [0.00013303756713867 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f56170d [0.00032687187194824 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9;
CREATE TEMPORARY TABLE tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9 (
entry INT NOT NULL,
sub_icon_id INT NOT NULL,
PRIMARY KEY (entry, sub_icon_id)
) ENGINE=MEMORY; [0.00017094612121582 sec]
INSERT IGNORE INTO tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9 (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 (3425)
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 (3425)
WHERE g.brand_id IN (1005) AND
1
) A [0.00071501731872559 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9;
CREATE TEMPORARY TABLE tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9 (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00029993057250977 sec]
INSERT IGNORE INTO tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9 (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9 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.00029587745666504 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name AS name,
si.url
FROM tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9 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.00016689300537109 sec]
-----------------------------
SELECT COUNT(*) FROM pod_good_filter
WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.066923856735229 sec]
Array
(
[0] => Array
(
[COUNT(*)] => 19873
)
)
SELECT COUNT(DISTINCT filter_id) FROM pod_good_filter
WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.16860389709473 sec]
Array
(
[0] => Array
(
[COUNT(DISTINCT filter_id)] => 10
)
)
-----------------------------
DROP TEMPORARY TABLE IF EXISTS tmp_A_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9 [0.00037693977355957 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_sc7kfe785o4uj0omn0k4cl9c38_6a2b39f565dc9 [0.00011396408081055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.0003669261932373 sec]
Постельное белье ТЕП - купить постельное белье ТЕП в Киеве и Украине: отзывы > Podushka
Украинский производитель спальных принадлежностей создает продукцию на собственной фабрике с 1996 года. Изделия проходят 4-хуровневый контроль качества, что исключает поступление брака в продажу. Во время пошива изделий учитывается усадка ткани, поэтому постельное белье ТЕП никогда не изменяет размеров.
5 нюансов, на которые стоит обратить внимание при выборе
Преимущества белья постельного ТЕП делают его фаворитом на украинском рынке текстиля. Среди главных плюсов продукции:
Натуральные ткани. Изделия шьются из хлопка плотностью 112 г/кв.м. Постельное белье ТЕП хорошо впитывает влагу, дышит, не накапливает пыль и статическое электричество. Принадлежности выдерживают многократные стирки, не рвутся.
Дизайн. Эксклюзивный дизайн — это уже повод купить постельное белье ТЕП. На изделиях расцветают цветы, меняются времена года и обитают мультяшные персонажи. Вы можете выбрать сет с абстрактными рисунками и геометрическими формами. Цвета на постельном белье «ТЕП» не выгорают. Применение стойких красителей обеспечивает стойкий цвет, который не теряет яркости после нескольких лет использования.
Пошив. Украинские швеи создают спальные аксессуары как для себя. Ровные и крепкие швы порадуют самых требовательных хозяек.
Комплектация. В интернет-магазине представлены комплекты, включающие простыню, пододеяльник и 2 наволочки. Все, что нужно для комфортного сна в одной ПВХ-упаковке. Размеры. Семейные, полуторные, евро, двуспальные, подростковые — постельные сеты ТЕП представлены в большом ассортименте для детей и взрослых.
Где приобрести спальные принадлежности украинского производителя
В интернет-магазине «Подушка» можно купить постельное белье Теп в Киеве с доставкой в Харьков, Днепропетровск, Львов и Одессу. В каталоге представлены спальные аксессуары для поклонников разных стилей:
классические изделия в приглушенной цветовой гамме с растительными узорами
красочные принадлежности с абстрактными рисунками
белье постельное «ТЕП» с забавными яркими картинками
лаконичные аксессуары для интерьеров в стиле Минимализм
романтические комплекты в розового-лавандовых тонах
мужские наборы ТЕП в приглушенных тонах с ненавязчивым принтом.
Закажите постельный сет по выгодной цене с доставкой по всей Украине — подарите себе и близким комфортный сон.
Ваш заказ оформлен! На e-mail отправлено письмо с подтверждением В ближайшее время с Вами свяжется менеджер Спасибо за заказ!
Ваш профиль будет удален навсегда. Его нельзя восстановить. Продолжить?
Оставьте свой номер телефона и наши менеджеры вам перезвонят
Оплату картами Visa и MasterCard обеспечивает сервис онлайн-платежей Portmone.com. Безопасность оплаты подтверждена международным аудитом PCI DSS. Служба поддержки: тел. +380(44)2000902