SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/konstruktory_dlya_malchikov/developing-constructor_sets-space-trains-lego.html' LIMIT 0,1 [0.00048995018005371 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('developing','constructor_sets','space','trains','lego') order by url [0.001594066619873 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('developing','constructor_sets','space','trains','lego') order by url [0.0012011528015137 sec]
select id,url from pod_cat_brand where BINARY url IN ('developing','constructor_sets','space','trains','lego') [0.0019710063934326 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 = 'konstruktory_dlya_malchikov' AND cb.brand_id = 349 AND cb.is_active = 1 LIMIT 1 [0.00055789947509766 sec]
SELECT id, url FROM pod_filter WHERE url IN ('developing','constructor_sets','space','trains','lego') [0.00084400177001953 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('developing','constructor_sets','space','trains','lego') [0.00093197822570801 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.00051999092102051 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 (446) 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 (446) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.30347299575806 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.00058698654174805 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.0014331340789795 sec]
SELECT g.id /* cats:446 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND 1 [0.0045030117034912 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b8c6eed2ae ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.0009620189666748 sec]
INSERT INTO temp_brand_counts_6a2b8c6eed2ae (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:446 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (349) [0.0019571781158447 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_6a2b8c6eed2ae 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.00072503089904785 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b8c6eed2ae [0.00026488304138184 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:446 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:446 */ 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 (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND 1 ) A [0.00086212158203125 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.00042295455932617 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf; CREATE TEMPORARY TABLE tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00047421455383301 sec]
INSERT INTO tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf (id) SELECT A.id FROM ( SELECT g.id /* cats:446 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND 1 ) A [0.00088095664978027 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf; CREATE TEMPORARY TABLE tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00043201446533203 sec]
INSERT INTO tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (463,466,3452,3465) 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.0099360942840576 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf; CREATE TEMPORARY TABLE tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00050592422485352 sec]
INSERT IGNORE INTO tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf p GROUP BY p.filter_id [0.00041103363037109 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_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf 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.00044393539428711 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf [0.00035500526428223 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf [0.00014495849609375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6ef1fbf [0.00013494491577148 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc; CREATE TEMPORARY TABLE tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00030994415283203 sec]
INSERT INTO tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* cats:446 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* cats:446 */ 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 (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND 1 ) A [0.00099420547485352 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc; CREATE TEMPORARY TABLE tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00035405158996582 sec]
INSERT INTO tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (463,466,3452,3465) 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.0014870166778564 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc; CREATE TEMPORARY TABLE tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00036907196044922 sec]
INSERT IGNORE INTO tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc p GROUP BY p.filter_id [0.00039792060852051 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_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc 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.00043988227844238 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc [0.00027012825012207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc [0.00012588500976562 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f018cc [0.00014495849609375 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 (3452,3465) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00053906440734863 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696; CREATE TEMPORARY TABLE tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.0003969669342041 sec]
INSERT INTO tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 (id) SELECT A.id FROM ( SELECT g.id /* cats:446 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND 1 ) A [0.00059103965759277 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696; CREATE TEMPORARY TABLE tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00036811828613281 sec]
INSERT INTO tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 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.001662015914917 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696; CREATE TEMPORARY TABLE tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0003669261932373 sec]
INSERT INTO tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 p GROUP BY p.filter_id [0.00033879280090332 sec]
INSERT IGNORE INTO tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 c ON c.filter_id = pf.id WHERE pf.id in (463,466) AND c.filter_id IS NULL [0.00033688545227051 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_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 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.00043082237243652 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 [0.00027298927307129 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 [0.00012707710266113 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f03696 [0.00012397766113281 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191; CREATE TEMPORARY TABLE tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00027608871459961 sec]
INSERT INTO tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 (id) SELECT A.id FROM ( SELECT g.id /* cats:446 */ FROM tmp_base_goods g 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 1 ) A [0.00061702728271484 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191; CREATE TEMPORARY TABLE tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00034403800964355 sec]
INSERT INTO tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 3436 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.0022819042205811 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191; CREATE TEMPORARY TABLE tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00034379959106445 sec]
INSERT INTO tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 p GROUP BY p.filter_id [0.00034499168395996 sec]
INSERT IGNORE INTO tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 c ON c.filter_id = pf.id WHERE pf.id in (3452,3465) AND c.filter_id IS NULL [0.00039982795715332 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_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 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.00040507316589355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 [0.00031304359436035 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 [0.00017213821411133 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f05191 [0.00021886825561523 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00; CREATE TEMPORARY TABLE tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00039410591125488 sec]
INSERT IGNORE INTO tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00 (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:446 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:446 */ 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 (463,466) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3452,3465) WHERE g.brand_id IN (349) AND 1 ) A [0.0010969638824463 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00; CREATE TEMPORARY TABLE tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00033807754516602 sec]
INSERT IGNORE INTO tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00 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.00040102005004883 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00 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.00033116340637207 sec]
----------------------------- SELECT COUNT(*) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.0039501190185547 sec]
Array ( [0] => Array ( [COUNT(*)] => 606 ) ) SELECT COUNT(DISTINCT filter_id) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.0056822299957275 sec]
Array ( [0] => Array ( [COUNT(DISTINCT filter_id)] => 4 ) ) ----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00 [0.00031185150146484 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_amidd0md2vhq2bj1nfu5npeitd_6a2b8c6f06e00 [0.00013208389282227 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.0001981258392334 sec]
Низкие цены на Конструктор для мальчиков LEGO (ЛEГO) – большой выбор, фото. Купить Конструктор для мальчиков LEGO (ЛEГO) в Киеве и Украине
UA
RU
Вход в кабинет

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

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

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

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

Смотрите также
Сортировать:
по популярности
Конструктор Lego Creator Космический шаттл 31134
Конструктор Lego Creator Космический шаттл 31134
Код: 452030

Производитель: LEGO (Дания)

Цена:
479 грн

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

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

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

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

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

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

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

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

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

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

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