SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/konstruktory_dlya_malchikov/o_6-developing-constructor_sets-transformery-lego.html' LIMIT 0,1 [0.00063300132751465 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('o_6','developing','constructor_sets','transformery','lego') order by url [0.0016331672668457 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('o_6','developing','constructor_sets','transformery','lego') order by url [0.0011990070343018 sec]
select id,url from pod_cat_brand where BINARY url IN ('o_6','developing','constructor_sets','transformery','lego') [0.0018219947814941 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.00063705444335938 sec]
SELECT id, url FROM pod_filter WHERE url IN ('o_6','developing','constructor_sets','transformery','lego') [0.0017199516296387 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('o_6','developing','constructor_sets','transformery','lego') [0.0013458728790283 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.00058197975158691 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.3202211856842 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.00032901763916016 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.0004279613494873 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 (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) AND g.is_present AND 1 UNION SELECT g.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 go.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) AND 1 [0.0061500072479248 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2b4b9ac8f22 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.000244140625 sec]
INSERT INTO temp_brand_counts_6a2b4b9ac8f22 (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 (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.is_present AND 1 UNION SELECT g.brand_id AS id, g.id AS gid /* 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 go.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (349) [0.00096297264099121 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_6a2b4b9ac8f22 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.00040102005004883 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2b4b9ac8f22 [0.00012993812561035 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 (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) 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 go.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) AND 1 ) A [0.00086402893066406 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:446 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) AND g.is_present AND 1 UNION SELECT g.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 go.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) 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.0015032291412354 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.00033903121948242 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3; CREATE TEMPORARY TABLE tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00037288665771484 sec]
INSERT INTO tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 (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 (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) AND g.is_present AND 1 UNION SELECT g.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 go.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) AND 1 ) A [0.00062012672424316 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3; CREATE TEMPORARY TABLE tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00022387504577637 sec]
INSERT INTO tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (364,463,466,3460) 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.0076191425323486 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3; CREATE TEMPORARY TABLE tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00025105476379395 sec]
INSERT IGNORE INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 p GROUP BY p.filter_id [0.00018095970153809 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_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 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.00016283988952637 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 [0.00017499923706055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 [8.392333984375E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acc5f3 [7.8916549682617E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da; CREATE TEMPORARY TABLE tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00018095970153809 sec]
INSERT INTO tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da (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 (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) 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 go.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) AND 1 ) A [0.00045585632324219 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da; CREATE TEMPORARY TABLE tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00021100044250488 sec]
INSERT INTO tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (364,463,466,3460) 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.00032901763916016 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da; CREATE TEMPORARY TABLE tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00021100044250488 sec]
INSERT IGNORE INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da p GROUP BY p.filter_id [0.00017285346984863 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_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da 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.0001370906829834 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da [0.00016093254089355 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da [9.2983245849609E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acf0da [8.2015991210938E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22; CREATE TEMPORARY TABLE tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00016117095947266 sec]
INSERT INTO tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 (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 (3460) 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 (3460) WHERE g.brand_id IN (349) AND 1 ) A [0.00037908554077148 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22; CREATE TEMPORARY TABLE tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.00021791458129883 sec]
INSERT INTO tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 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.0042350292205811 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22; CREATE TEMPORARY TABLE tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00023388862609863 sec]
INSERT INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 p GROUP BY p.filter_id [0.00024008750915527 sec]
INSERT INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 c ON c.filter_id = pf.id WHERE pf.id in (364) AND c.filter_id IS NULL [0.0001990795135498 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_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 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.00018000602722168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 [0.00017690658569336 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 [8.2015991210938E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9acff22 [9.2029571533203E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5; CREATE TEMPORARY TABLE tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00016403198242188 sec]
INSERT INTO tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 (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 (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3460) WHERE g.brand_id IN (349) AND g.is_present AND 1 UNION SELECT g.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 go.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (3460) WHERE g.brand_id IN (349) AND 1 ) A [0.00041103363037109 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5; CREATE TEMPORARY TABLE tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00023293495178223 sec]
INSERT INTO tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 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.0026330947875977 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5; CREATE TEMPORARY TABLE tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00025296211242676 sec]
INSERT INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 p GROUP BY p.filter_id [0.00019192695617676 sec]
INSERT IGNORE INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 c ON c.filter_id = pf.id WHERE pf.id in (463,466) AND c.filter_id IS NULL [0.0001981258392334 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_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 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.00026702880859375 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 [0.00029897689819336 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 [0.00014400482177734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad1dd5 [0.00026106834411621 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718; CREATE TEMPORARY TABLE tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.0001378059387207 sec]
INSERT INTO tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 (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 (364) 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 1 UNION SELECT g.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 go.id = gf0.id_good AND gf0.filter_id_value in (364) 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 1 ) A [0.00098299980163574 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718; CREATE TEMPORARY TABLE tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00018811225891113 sec]
INSERT INTO tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 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.0019619464874268 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718; CREATE TEMPORARY TABLE tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00030303001403809 sec]
INSERT INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 p GROUP BY p.filter_id [0.00020694732666016 sec]
INSERT IGNORE INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 c ON c.filter_id = pf.id WHERE pf.id in (3460) AND c.filter_id IS NULL [0.00015711784362793 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_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 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.00019001960754395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 [0.00025486946105957 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 [0.00012707710266113 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad3718 [0.00010204315185547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54; CREATE TEMPORARY TABLE tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00018191337585449 sec]
INSERT IGNORE INTO tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54 (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 (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) 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 go.id = gf0.id_good AND gf0.filter_id_value in (364) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (463,466) INNER JOIN pod_good_filter gf2 ON g.id = gf2.id_good AND gf2.filter_id_value in (3460) WHERE g.brand_id IN (349) AND 1 ) A [0.00049996376037598 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54; CREATE TEMPORARY TABLE tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00023984909057617 sec]
INSERT IGNORE INTO tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54 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.00025081634521484 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54 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.00015902519226074 sec]
----------------------------- SELECT COUNT(*) FROM pod_good_filter WHERE id_good IN (SELECT id FROM tmp_base_goods); [0.0025041103363037 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.0033910274505615 sec]
Array ( [0] => Array ( [COUNT(DISTINCT filter_id)] => 4 ) ) ----------------------------- DROP TEMPORARY TABLE IF EXISTS tmp_A_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54 [0.00022411346435547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2gu6r35eopka560i9giqnvd70o_6a2b4b9ad4e54 [6.3896179199219E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00011205673217773 sec]
Низкие цены на Конструктор для мальчиков LEGO (ЛEГO) – большой выбор, фото. Купить Конструктор для мальчиков LEGO (ЛEГO) в Киеве и Украине
UA
RU
Вход в кабинет

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

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

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

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

Смотрите также
Сортировать:
по популярности

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

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

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

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

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

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

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

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

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

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

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