SELECT url_to, r404
FROM pod_redirect
WHERE BINARY REPLACE(url_from,'/ru/','/') = '/gorodskie/gray-2e_bagscases.html' LIMIT 0,1 [0.00048112869262695 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('gray','2e_bagscases') order by url [0.0018308162689209 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('gray','2e_bagscases') order by url [0.00082492828369141 sec]
select id,url from pod_cat_brand where BINARY url IN ('gray','2e_bagscases') [0.0012760162353516 sec]
select id from pod_structure where link='catalogue/481' and active='1' AND lang_ua='1' [0.00039100646972656 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 = 'gorodskie'
AND cb.brand_id = 1374
AND cb.is_active = 1
LIMIT 1 [0.00059390068054199 sec]
SELECT id, url FROM pod_filter WHERE url IN ('gray','2e_bagscases') [0.00048184394836426 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('gray','2e_bagscases') [0.00026893615722656 sec]
SELECT sc.url, sc.id AS super_category_id,
sc.name_ua AS super_category_name,
sc.templ_good_title_ua AS templ_good_title, sc.templ_good_kwds,
sc.templ_good_desc_ua AS templ_good_desc,
sc.templ_brand_title_ua AS templ_brand_title, sc.templ_brand_kwds,
sc.templ_brand_desc_ua AS templ_brand_desc,
sc.templ_cat_title_ua AS templ_cat_title, sc.templ_cat_kwds,
sc.templ_cat_desc_ua AS templ_cat_desc, 1 AS o
FROM pod_cat_category c
LEFT JOIN pod_super_category sc ON sc.id=c.super_category_id
WHERE c.id='480' [0.00035595893859863 sec]
SELECT id FROM pod_cat_category WHERE entry='481' [0.00018501281738281 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.00026416778564453 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 (481) 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 (481) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.30752992630005 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.00045990943908691 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.0011389255523682 sec]
SELECT g.id /* cats:481 */
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 (1374) AND
1
[0.0041391849517822 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b0013dd0e9 (
id INT,
gid INT,
INDEX idx_id (id),
INDEX idx_gid (gid)
) [0.00061583518981934 sec]
INSERT INTO temp_brand_counts_6a2b0013dd0e9 (id, gid)
SELECT g.brand_id AS id, g.id AS gid /* cats:481 */
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 (1374) [0.0042300224304199 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_6a2b0013dd0e9
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.00055599212646484 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b0013dd0e9 [0.0001380443572998 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:481 */
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 (1374) AND
g.is_present AND
1
UNION
SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:481 */
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 (1374) AND
1
) A
[0.00040102005004883 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:481 */
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 (1374) 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.0016369819641113 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id in (1374) [0.00015401840209961 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 = 481
AND cb.brand_id = 1374
AND cb.is_active = 1
LIMIT 1 [0.00019717216491699 sec]
SELECT p.id, p.dt, p.title_ua 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='481'
ORDER BY p.dt DESC LIMIT 1 [0.0042240619659424 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id='1374' [0.0001368522644043 sec]
SELECT url FROM pod_cat_brand WHERE id = 1374 [0.00021696090698242 sec]
SELECT id, name_ua AS name, url, entry FROM pod_cat_category WHERE is_active='1' AND is_hidden='0' AND entry='0'
AND super_category_id='8' AND id!='481' ORDER BY ordr [0.0006561279296875 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab;
CREATE TEMPORARY TABLE tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.00030612945556641 sec]
INSERT INTO tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab (id) SELECT A.id FROM (
SELECT g.id /* cats:481 */
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 (1374) AND
1
) A [0.00057005882263184 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab;
CREATE TEMPORARY TABLE tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00033283233642578 sec]
INSERT INTO tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32)
INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 481
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.0039160251617432 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab;
CREATE TEMPORARY TABLE tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00034809112548828 sec]
INSERT IGNORE INTO tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab p
GROUP BY p.filter_id [0.00029897689819336 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_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab 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.00026798248291016 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab [0.00024080276489258 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab [0.00013089179992676 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e30ab [0.00011301040649414 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e;
CREATE TEMPORARY TABLE tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e (
id INT NOT NULL,
entry INT NOT NULL,
PRIMARY KEY (id),
KEY idx_entry (entry)
) ENGINE=MEMORY; [0.00021886825561523 sec]
INSERT INTO tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e (id, entry) SELECT A.id, A.entry FROM (
SELECT g.id as id, g.id as entry /* cats:481 */
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 (1374) AND
g.is_present AND
1
UNION
SELECT go.id as id, g.id as entry /* cats:481 */
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 (1374) AND
1
) A [0.00051283836364746 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e;
CREATE TEMPORARY TABLE tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00031399726867676 sec]
INSERT INTO tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e (goods_id, filter_id)
SELECT DISTINCT
A.entry AS goods_id,
f.id AS filter_id
FROM tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e A
INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32)
INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 481
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.00046992301940918 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e;
CREATE TEMPORARY TABLE tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.0002281665802002 sec]
INSERT IGNORE INTO tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e p
GROUP BY p.filter_id [0.00019502639770508 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_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e 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.00022506713867188 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e [0.00015711784362793 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e [8.702278137207E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e4e3e [7.4148178100586E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00;
CREATE TEMPORARY TABLE tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 (
id INT NOT NULL,
PRIMARY KEY (id)
) ENGINE=MEMORY; [0.00017213821411133 sec]
INSERT INTO tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 (id) SELECT A.id FROM (
SELECT g.id /* cats:481 */
FROM tmp_base_goods g
WHERE g.brand_id IN (1374) AND
1
) A [0.00025486946105957 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00;
CREATE TEMPORARY TABLE tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 (
goods_id INT NOT NULL,
filter_id INT NOT NULL,
PRIMARY KEY (goods_id, filter_id)
) ENGINE=MEMORY; [0.00020599365234375 sec]
INSERT INTO tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 (goods_id, filter_id)
SELECT DISTINCT
A.id AS goods_id,
f.id AS filter_id
FROM tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 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.0015020370483398 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00;
CREATE TEMPORARY TABLE tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 (
filter_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00020194053649902 sec]
INSERT INTO tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 (filter_id, count)
SELECT
p.filter_id,
COUNT(*) AS count
FROM tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 p
GROUP BY p.filter_id [0.00022196769714355 sec]
INSERT IGNORE INTO tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 (filter_id, count)
SELECT pf.id, 0
FROM pod_filter pf
LEFT JOIN tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 c ON c.filter_id = pf.id
WHERE pf.id in (32) AND c.filter_id IS NULL [0.00025796890258789 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_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 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.00030899047851562 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 [0.00020503997802734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 [0.00010919570922852 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e5b00 [8.2015991210938E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43;
CREATE TEMPORARY TABLE tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43 (
entry INT NOT NULL,
sub_icon_id INT NOT NULL,
PRIMARY KEY (entry, sub_icon_id)
) ENGINE=MEMORY; [0.00023317337036133 sec]
INSERT IGNORE INTO tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43 (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:481 */
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 (1374) AND
g.is_present AND
1
UNION
SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:481 */
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 (1374) AND
1
) A [0.00050902366638184 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43;
CREATE TEMPORARY TABLE tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43 (
sub_icon_id INT NOT NULL PRIMARY KEY,
count INT NOT NULL
) ENGINE=MEMORY; [0.00020909309387207 sec]
INSERT IGNORE INTO tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43 (sub_icon_id, count)
SELECT
sub_icon_id,
COUNT(DISTINCT entry) AS count
FROM (
SELECT A.entry, A.sub_icon_id
FROM tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43 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.00023508071899414 sec]
SELECT
c.sub_icon_id AS id,
c.count,
si.entry,
si.name_ua AS name,
si.url
FROM tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43 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.00013613700866699 sec]
-----------------------------
SELECT COUNT(*) FROM pod_good_filter
WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.0032789707183838 sec]
Array
(
[0] => Array
(
[COUNT(*)] => 749
)
)
SELECT COUNT(DISTINCT filter_id) FROM pod_good_filter
WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.0036580562591553 sec]
Array
(
[0] => Array
(
[COUNT(DISTINCT filter_id)] => 4
)
)
-----------------------------
DROP TEMPORARY TABLE IF EXISTS tmp_A_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43 [0.00016188621520996 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_uaf0grc1brkqe9hlpae3e4nuqn_6a2b0013e6b43 [0.00015091896057129 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods;
DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00020384788513184 sec]
Низькі ціни на Міський рюкзак 2E Bags & Cases (2E Бaгс & Кaсeс) - великий вибір, фото. Купити Міський рюкзак 2E Bags & Cases (2E Бaгс & Кaсeс) в Києві і Україні
Міські рюкзаки 2E Bags & Cases - стильні органайзери для активних особистостей
Вранці на тренування, потім на роботу, ввечері пікнік в парку і кіно з друзями ... Куди ж покласти спортивну форму, ланч і ноутбук? Звичайно ж, в міській рюкзак 2E Bags & Cases. Він стане головним союзників в досягненні поставлених цілей. Всі необхідні речі будуть з вами. При цьому руки залишаться вільними для девайса і склянки запашної кави.
Особливості рюкзаків для міста
Міські рюкзаки мають стильний і продуманий дизайн. Їх головна особливість - грамотно організоване внутрішній простір. У таких моделях є відділення для ноутбука, кишені для flash-накопичувачів і канцелярського приладдя. Деякі вироби укомплектовані дощовиками.
Правила вибору міського рюкзака
Матеріал. Рюкзаки для міста 2E Bags & Cases шиються з водонепроникного нейлону 900D. Матеріал стійкий до розривів, механічних пошкоджень і погодних умов.
Вага. Ідеальними вважаються моделі вагою не більше 1 кг, так як вони не додають хребту зайве навантаження. Обсяг. Сучасні міські рюкзаки об'ємом до 15 л - вибір дівчат. Вони вміщають пару книг, ноутбук з діагоналлю 13 "і косметичку. Моделі 2E Bags & Cases об'ємом до 20 л дозволяють носити з собою всі необхідні речі: лептоп діагоналлю 14 ", документи, підручники, книги. Вироби об'ємом 30-35 л вміщають спортивну форму, ноутбук діагоналлю 19 "і різні дрібниці.
Лямки. Потужні і широкі лямки рівномірно розподіляють навантаження на хребет, що зменшує втому під час тривалих походів по місту. Краще, якщо вони регулюються по довжині. Це дозволяє вибрати найбільш комфортне положення, відповідне зростання користувача.
Вентильована спинка. Деякі рюкзаки 2E Bags & Cases оснащені «дихаючими» спинками, запобігають утворенню «парникового ефекту» в спекотні літні дні.
Ваше замовлення оформлено! На e-mail відправлено лист з підтвердженням Найближчим часом з Вами зв'яжеться менеджер Дякємо за замовлення!
Ваш профіль буде видалений назавжди. Його не можна відновити. Продовжити?
Залиште свій номер телефону і наші менеджери Вам зателефонують
Оплату картами Visa і MasterCard забезпечує сервіс онлайн-платежів Portmone.com. Безпека оплати підтверджена міжнародним аудитом PCI DSS. Служба підтримки: тел. +380 (44) 2000902