SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/konstruktory_dlya_malchikov/o_12-developing-constructor_sets-lego.html' LIMIT 0,1 [0.00068092346191406 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('o_12','developing','constructor_sets','lego') order by url [0.0018739700317383 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('o_12','developing','constructor_sets','lego') order by url [0.0012879371643066 sec]
select id,url from pod_cat_brand where BINARY url IN ('o_12','developing','constructor_sets','lego') [0.0019989013671875 sec]
SELECT id, url FROM pod_filter WHERE url IN ('o_12','developing','constructor_sets','lego') [0.0010170936584473 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('o_12','developing','constructor_sets','lego') [0.00087499618530273 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 (466,463,373) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00042009353637695 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; CREATE TEMPORARY TABLE tmp_base_goods (id INT NOT NULL PRIMARY KEY) ENGINE=MEMORY [0.00041604042053223 sec]
INSERT INTO tmp_base_goods (id) SELECT DISTINCT g.id FROM pod_cat_good g WHERE g.cat_id IN (446) AND g.entry=0 AND g.is_active AND g.is_present_all_mods UNION SELECT DISTINCT g.id FROM pod_cat_good g INNER JOIN pod_dop_cat_category dc ON dc.good_id = g.id WHERE dc.dop_cat_id IN (446) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.0061719417572021 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, KEY idx_entry (entry)) ENGINE=MEMORY [0.00046420097351074 sec]
INSERT INTO tmp_sub_goods (id, entry) SELECT go.id, go.entry 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.0010910034179688 sec]
SELECT g.id -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT g.id -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active [0.017429113388062 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2ac71b349be ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00082683563232422 sec]
INSERT INTO temp_brand_counts_6a2ac71b349be (id, gid) SELECT g.brand_id AS id, g.id AS gid -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT g.brand_id AS id, g.id AS gid -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active UNION SELECT id, null gid FROM pod_cat_category WHERE id in (349) [0.0040040016174316 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_6a2ac71b349be 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.00064611434936523 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2ac71b349be [0.00018310546875 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 -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.001305103302002 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 -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT g.id -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) 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.0025079250335693 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 = 446 AND cb.brand_id = 349 AND cb.is_active = 1 LIMIT 1 [0.00039196014404297 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6; CREATE TEMPORARY TABLE tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00054192543029785 sec]
INSERT INTO tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 (id) SELECT A.id FROM ( SELECT g.id -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT g.id -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0014331340789795 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6; CREATE TEMPORARY TABLE tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 ( 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_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (373,463,466) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 446 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.0072870254516602 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6; CREATE TEMPORARY TABLE tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00044703483581543 sec]
INSERT IGNORE INTO tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 p GROUP BY p.filter_id [0.00034880638122559 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_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 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.00032210350036621 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 [0.00031805038452148 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 [0.00017309188842773 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3a6f6 [0.00014495849609375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940; CREATE TEMPORARY TABLE tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00030303001403809 sec]
INSERT INTO tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT go.id as id, g.id as entry -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0031058788299561 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940; CREATE TEMPORARY TABLE tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00039100646972656 sec]
INSERT INTO tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (373,463,466) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 446 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.00064396858215332 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940; CREATE TEMPORARY TABLE tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00035619735717773 sec]
INSERT IGNORE INTO tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 p GROUP BY p.filter_id [0.00028300285339355 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_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 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_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 [0.00027799606323242 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 [0.00012707710266113 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3d940 [0.00012683868408203 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7; CREATE TEMPORARY TABLE tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00034213066101074 sec]
INSERT INTO tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT go.id as id, g.id as entry -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0013389587402344 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7; CREATE TEMPORARY TABLE tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.0003809928894043 sec]
INSERT INTO tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 262 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.0043091773986816 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7; CREATE TEMPORARY TABLE tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00037693977355957 sec]
INSERT INTO tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 p GROUP BY p.filter_id [0.00037097930908203 sec]
INSERT INTO tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 c ON c.filter_id = pf.id WHERE pf.id in (373) AND c.filter_id IS NULL [0.00026607513427734 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_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 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.00036311149597168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 [0.00026583671569824 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 [0.00012302398681641 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b3f8f7 [0.00013518333435059 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f; CREATE TEMPORARY TABLE tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00035190582275391 sec]
INSERT INTO tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f (id) SELECT A.id FROM ( SELECT g.id -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (373) WHERE g.brand_id IN (349) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT g.id -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (373) WHERE g.brand_id IN (349) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0012948513031006 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f; CREATE TEMPORARY TABLE tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00040197372436523 sec]
INSERT INTO tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 461 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.0019500255584717 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f; CREATE TEMPORARY TABLE tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00043201446533203 sec]
INSERT INTO tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f p GROUP BY p.filter_id [0.0003659725189209 sec]
INSERT IGNORE INTO tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f c ON c.filter_id = pf.id WHERE pf.id in (463,466) AND c.filter_id IS NULL [0.00035500526428223 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_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f 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.00041294097900391 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f [0.0003209114074707 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f [0.00015902519226074 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4221f [0.00018596649169922 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a; CREATE TEMPORARY TABLE tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00026178359985352 sec]
INSERT IGNORE INTO tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a (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 -- основні (tmp) FROM tmp_base_goods t INNER JOIN pod_cat_good g ON t.id = g.id INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND g.is_present AND g.is_present_all_mods AND g.is_active UNION SELECT go.id as id, g.id as entry, go.sub_icon_id -- підтовари (tmp) FROM tmp_sub_goods t INNER JOIN pod_cat_good go ON t.id = go.id INNER JOIN pod_cat_good g ON t.entry = g.id INNER JOIN pod_good_filter gf0 ON go.id = gf0.id_good AND gf0.filter_id_value in (373) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) WHERE g.brand_id IN (349) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0015149116516113 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a; CREATE TEMPORARY TABLE tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00047206878662109 sec]
INSERT IGNORE INTO tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a 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.00056099891662598 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a 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.00036501884460449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a [0.00046086311340332 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_rfoqpknoth8t1njd82u15rrj83_6a2ac71b4410a [0.00016117095947266 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00027298927307129 sec]
Низкие цены на Конструктор для мальчиков LEGO (ЛEГO) – большой выбор, фото. Купить Конструктор для мальчиков LEGO (ЛEГO) в Киеве и Украине
UA
RU
Вход в кабинет

DEVELOPMENT🌷СКИДКИ ДО 70%

ПЕРЕЙТИ
Магазин PODUSHKA ®
  1. Магазин PODUSHKA ®
  2. Игрушки для детей Игрушки для детей
  3. Детские конструкторы Детские конструкторы
  4. Конструктор для мальчиков Конструктор для мальчиков
  5. LEGO LEGO

Конструктор для мальчиков LEGO

Как правильно выбрать игрушку для ребенка
Вы выбрали
Очистить все фильтры
Детские конструкторы
Производитель
Cobi (3)
Stem (1)
Больше производителей
Умные фильтры
Со скидкой!
Быстрая доставка
Новинка
Распродажа
Возраст ребенка
3 года (1)
4 года (2)
5 лет (2)
6 лет (4)
7 лет (3)
8 лет (2)
9 лет (2)
10 лет (1)
12 лет (0)
Показать больше
Тип конструктора
развивающие (0)
наборы (0)
Цена
—
грн

Смотрите также
Сортировать:
по популярности
Выбрать производителя

Конструкторы для мальчиков Lego — мир увлекательных игр

Конструктор Lego Ninjago Железные удары судьбы Лего — датская компания, которая занимается производством развивающих игрушек с 1934 года. За 80 лет существования конструкторы для мальчиков Lego обрели мировую популярность, стали легендой и примером для подражания. В чем же их секрет? Во-первых, все детали Лего рассчитаны на тысячи соединений-разъединений, поэтому с ними можно играть очень долгое время. Во вторых, в ассортименте бренда огромное количество тематических наборов, которые делают сюжетные игры максимально реалистичными и интересными. Третье преимущество конструкторов Lego — универсальность. Детали разных наборов можно соединять между собой, что открывает перед детьми безграничные возможности для увлекательного досуга.

Значение конструктора в развитии мальчика

Детское времяпрепровождение может быть разным… Ребенок может целыми днями смотреть мультфильмы, а может играть с конструктором Lego City. В процессе постройки зданий и создания роботов малыш активно развивает мелкую моторику, логику, воображение и сообразительность. Кроме того он учится усидчивости, что очень важно в период подготовки к школе. Ребенок концентрирует внимание, учится самостоятельной игре, а также осваивает такие важные понятия как форма, цвет и размер.

Также группа американских ученых доказала, что развитие пространственного мышления во время сборки конструкторов влияет на дальнейшие успехи детей в математике. Исследования показали: чем проворнее ребенок управляется с конструктором, тем лучше справляется со счетом.

Самые популярные наборы

В интернет-магазине «Подушка» вы можете купить конструкторы для мальчиков Lego на любой вкус:Конструктор Lego City Aerport Служба аэропорта для VIP-клиентов

Транспортные средства. Развозить на ярком фургоне пиццу, ограбить банк на бульдозере и убежать на буксире от полисменов — все это возможно с этими красочными игрушками.

Конструкторы Lego Ninjago. Эти наборы позволяют стать частью популярного мультфильма «Ниндзяго», разыгрывать различные сценки с любыми персонажами и даже пострелять из катапульты.

Постройки. Возвести средневековый замок и устроить турнир для рыцарей или построить передвижную тюрьму, из которой собирается сбежать воришка — с конструкторами Lego ребенку под силу абсолютно все.

Приключенческие наборы. Эти конструкторы для мальчиков Lego знакомят детей с трудовыми буднями полицейских, пожарных, спасателей и докторов. Малыши смогут тушить огонь, ловить преступников, ремонтировать машины и выполнять еще множество интересных действий, которые для него подготовили инженеры Lego.