SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/chemodany/gray-polyester-2e_bagscases.html' LIMIT 0,1 [0.00065088272094727 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('gray','polyester','2e_bagscases') order by url [0.00071191787719727 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('gray','polyester','2e_bagscases') order by url [0.00052094459533691 sec]
select id,url from pod_cat_brand where BINARY url IN ('gray','polyester','2e_bagscases') [0.00089597702026367 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 = 'chemodany' AND cb.brand_id = 1374 AND cb.is_active = 1 LIMIT 1 [0.00058197975158691 sec]
SELECT id, url FROM pod_filter WHERE url IN ('gray','polyester','2e_bagscases') [0.00064206123352051 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('gray','polyester','2e_bagscases') [0.00075483322143555 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.00050210952758789 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 (508) 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 (508) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.13768219947815 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.00051784515380859 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.0009768009185791 sec]
SELECT g.id /* cats:508 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) WHERE g.brand_id IN (1374) AND 1 [0.0010209083557129 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2af34076751 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00031495094299316 sec]
INSERT INTO temp_brand_counts_6a2af34076751 (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:508 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (1374) [0.0036020278930664 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_6a2af34076751 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.00057411193847656 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2af34076751 [0.0001671314239502 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:508 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) 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:508 */ 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) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) WHERE g.brand_id IN (1374) AND 1 ) A [0.00087594985961914 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:508 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) 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.002190113067627 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id in (1374) [0.00024104118347168 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 = 508 AND cb.brand_id = 1374 AND cb.is_active = 1 LIMIT 1 [0.00037693977355957 sec]
SELECT name_ua AS name, url FROM pod_cat_brand WHERE id='1374' [0.00023913383483887 sec]
SELECT url FROM pod_cat_brand WHERE id = 1374 [0.00020909309387207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba; CREATE TEMPORARY TABLE tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00059080123901367 sec]
INSERT INTO tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba (id) SELECT A.id FROM ( SELECT g.id /* cats:508 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) WHERE g.brand_id IN (1374) AND 1 ) A [0.0008080005645752 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba; CREATE TEMPORARY TABLE tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.0004279613494873 sec]
INSERT INTO tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32,392) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 508 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.0023510456085205 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba; CREATE TEMPORARY TABLE tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00036215782165527 sec]
INSERT IGNORE INTO tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba p GROUP BY p.filter_id [0.00034713745117188 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_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba 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.0003509521484375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba [0.00031089782714844 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba [0.00019311904907227 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407b9ba [0.00015401840209961 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8; CREATE TEMPORARY TABLE tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00026488304138184 sec]
INSERT INTO tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:508 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) WHERE g.brand_id IN (1374) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:508 */ 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) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) WHERE g.brand_id IN (1374) AND 1 ) A [0.00078296661376953 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8; CREATE TEMPORARY TABLE tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00031900405883789 sec]
INSERT INTO tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (32,392) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 508 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.00055217742919922 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8; CREATE TEMPORARY TABLE tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00036382675170898 sec]
INSERT IGNORE INTO tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 p GROUP BY p.filter_id [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_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 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.00024986267089844 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 [0.0002748966217041 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 [0.00012397766113281 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407d5c8 [0.00011110305786133 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924; CREATE TEMPORARY TABLE tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00026893615722656 sec]
INSERT INTO tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 (id) SELECT A.id FROM ( SELECT g.id /* cats:508 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (392) WHERE g.brand_id IN (1374) AND 1 ) A [0.00044584274291992 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924; CREATE TEMPORARY TABLE tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00032901763916016 sec]
INSERT INTO tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 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.00045394897460938 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924; CREATE TEMPORARY TABLE tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00031185150146484 sec]
INSERT INTO tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 p GROUP BY p.filter_id [0.00029206275939941 sec]
INSERT IGNORE INTO tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 c ON c.filter_id = pf.id WHERE pf.id in (32) AND c.filter_id IS NULL [0.00024199485778809 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_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 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.00031781196594238 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 [0.00027894973754883 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 [0.00013279914855957 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407e924 [0.00011301040649414 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34; CREATE TEMPORARY TABLE tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00035500526428223 sec]
INSERT INTO tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 (id) SELECT A.id FROM ( SELECT g.id /* cats:508 */ 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.0010559558868408 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34; CREATE TEMPORARY TABLE tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00045490264892578 sec]
INSERT INTO tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 122 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.0048630237579346 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34; CREATE TEMPORARY TABLE tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00033092498779297 sec]
INSERT INTO tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 p GROUP BY p.filter_id [0.0003809928894043 sec]
INSERT IGNORE INTO tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 c ON c.filter_id = pf.id WHERE pf.id in (392) AND c.filter_id IS NULL [0.00040388107299805 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_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 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.00038790702819824 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 [0.00032997131347656 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 [0.00016593933105469 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af3407fc34 [0.00017499923706055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532; CREATE TEMPORARY TABLE tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00024104118347168 sec]
INSERT IGNORE INTO tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532 (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:508 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (32) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) 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:508 */ 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) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (392) WHERE g.brand_id IN (1374) AND 1 ) A [0.000823974609375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532; CREATE TEMPORARY TABLE tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00040602684020996 sec]
INSERT IGNORE INTO tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532 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.0004570484161377 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name_ua AS name, si.url FROM tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532 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.00026297569274902 sec]
SELECT COUNT(*) FROM tmp_base_goods [0.00017499923706055 sec]
Array ( [0] => Array ( [COUNT(*)] => 186 ) ) SELECT COUNT(*) FROM tmp_sub_goods [0.00019478797912598 sec]
Array ( [0] => Array ( [COUNT(*)] => 0 ) ) SELECT COUNT(*) FROM pod_cat_filter WHERE category_id = 2 [0.00024008750915527 sec]
Array ( [0] => Array ( [COUNT(*)] => 4 ) ) SELECT COUNT(*) FROM pod_cat_filter WHERE category_id = 3 [0.00020790100097656 sec]
Array ( [0] => Array ( [COUNT(*)] => 5 ) ) EXPLAIN SELECT DISTINCT gf.id_good AS goods_id, f.id AS filter_id FROM pod_good_filter gf 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 WHERE gf.id_good IN (SELECT id FROM tmp_base_goods) [0.00050902366638184 sec]
Array ( [0] => Array ( [id] => 1 [select_type] => PRIMARY [table] => cf [type] => ref [possible_keys] => filter_id,category_id [key] => category_id [key_len] => 4 [ref] => const [rows] => 4 [Extra] => Using temporary ) [1] => Array ( [id] => 1 [select_type] => PRIMARY [table] => fm [type] => eq_ref [possible_keys] => PRIMARY,is_active,is_split [key] => PRIMARY [key_len] => 4 [ref] => pillow_db_test.cf.filter_id [rows] => 1 [Extra] => Using where ) [2] => Array ( [id] => 1 [select_type] => PRIMARY [table] => tmp_base_goods [type] => ALL [possible_keys] => PRIMARY [key] => [key_len] => [ref] => [rows] => 186 [Extra] => Using join buffer (flat, BNL join) ) [3] => Array ( [id] => 1 [select_type] => PRIMARY [table] => gf [type] => ref [possible_keys] => id_good,filter_id,idx_good_filter_composite,idx_filter_id_good,idx_filter_value_good,idx_filter_composite [key] => id_good [key_len] => 4 [ref] => pillow_db_test.tmp_base_goods.id [rows] => 1 [Extra] => Using where ) [4] => Array ( [id] => 1 [select_type] => PRIMARY [table] => f [type] => eq_ref [possible_keys] => PRIMARY,is_active [key] => PRIMARY [key_len] => 4 [ref] => pillow_db_test.gf.filter_id_value [rows] => 1 [Extra] => Using where ) ) DROP TEMPORARY TABLE IF EXISTS tmp_A_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532 [0.00018405914306641 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_1cs2pphbtia6thg2c35d0ppu5k_6a2af34082532 [9.1075897216797E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00029706954956055 sec]
Низькі ціни на Валізи на колесах 2E Bags & Cases (2E Бaгс & Кaсeс) - великий вибір, фото. Купити Валізи на колесах 2E Bags & Cases (2E Бaгс & Кaсeс) в Києві і Україні
UA
RU
Вхід в кабінет

DEVELOPMENT🌷ЗНИЖКИ ДО 70%

ПЕРЕЙТИ
Магазин PODUSHKA ®
  1. Магазин PODUSHKA ®
  2. Сумки Сумки
  3. Дорожня серія Дорожня серія
  4. Валізи на колесах Валізи на колесах
  5. 2E Bags & Cases 2E Bags & Cases

Валізи на колесах 2E Bags & Cases

Ви вибрали
Очистити всі фільтри
Дорожня серія
Виробник
Semi Line (2)
Більше виробників
Розумні фільтри
Зі знижкою!
Швидка доставка
Новинка
Розпродаж
Основний колір
Сірий (0)
Основний матеріал
поліестер (0)
Ціна
—
грн

Дивіться також
Сортувати:
За популярністю

Чемодан пластиковий 2E BagsCases Youngster великий 4 колеса 2E-SPPY-L-OG помаранчевий Дорожні валізи 2E Bags & Cases на чотирьох колесах - відмінні супутники в поїздках

Якщо ви любите подорожувати, довірте свої речі пластиковому валізі 2E Bags & Cases. Надійні, зручні і стильні моделі стануть вашими головними союзниками в будь-якій поїздці.

Чим зручні валізи 2E Bags & Cases

Матеріал. Всі вироби бренду виготовляються з поліпропілену. Матеріал не боїться ударів і механічних пошкоджень. Спеціальна плівка запобігає появі подряпин. Поліпропілен легко забарвлюється, тому купити валізу 2E Bags & Cases можна різних кольорів.

Колеса. Моделі з чотирма здвоєними колесами легко везти по різних покриттях. Вони без проблем їдуть по рівному покриттю. Проїжджаючи ділянки з бруківкою, виріб можна нахилити і котити на двох передніх колесах.

Замок. Вбудований кодовий TSA замок дозволяє вберегти багаж від злому. Чемодан пластиковий 2E BagsCases Youngster великий 4 колеса 2E-SPPY-L-LB блакитний

Основні критерії вибору

В інтернет-магазині «Подушка» можна купити валізи в дорогу різних розмірів:

  • Маленькі об'ємом до 40 л - для короткострокових поїздок в інше місто.
  • Середні висотою до 70 см і об'ємом 85 л - для відпочинку однієї людини на 1-2 тижні.
  • Великі висотою 80 см - для всієї родини, що зібралася в тривалу відпустку.

Всі моделі забезпечені зручними і міцними блискавками. Внутрішній простір оснащено кишенями для косметичних та засобів гігієни. Також дорожні валізи 2E Bags & Cases обладнані міцними висувними ручками, витримують великі навантаження і інтенсивну експлуатацію.