SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/razvivayushchie/animals_developing-developing_musical-sorter-trefl-learning_resources.html' LIMIT 0,1 [0.00049901008605957 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('animals_developing','developing_musical','sorter','trefl','learning_resources') order by url [0.0015039443969727 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('animals_developing','developing_musical','sorter','trefl','learning_resources') order by url [0.0010409355163574 sec]
select id,url from pod_cat_brand where BINARY url IN ('animals_developing','developing_musical','sorter','trefl','learning_resources') [0.0016140937805176 sec]
SELECT id, url FROM pod_filter WHERE url IN ('animals_developing','developing_musical','sorter','trefl','learning_resources') [0.00078511238098145 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('animals_developing','developing_musical','sorter','trefl','learning_resources') [0.00081896781921387 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; CREATE TEMPORARY TABLE tmp_base_goods (id INT NOT NULL PRIMARY KEY) ENGINE=MEMORY [0.0004270076751709 sec]
INSERT INTO tmp_base_goods (id) SELECT DISTINCT g.id FROM pod_cat_good g WHERE g.cat_id IN (146) 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 (146) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.0051720142364502 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.00038886070251465 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.0018038749694824 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 (501,502,630) WHERE g.brand_id IN (937,1991) AND g.is_present_all_mods AND g.is_active [0.023429155349731 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2ac4dca23dc ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00024795532226562 sec]
INSERT INTO temp_brand_counts_6a2ac4dca23dc (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 (501,502,630) WHERE g.is_present_all_mods AND g.is_active UNION SELECT id, null gid FROM pod_cat_category WHERE id in (937,1991) [0.0049669742584229 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_6a2ac4dca23dc 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.0004279613494873 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2ac4dca23dc [0.00014615058898926 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 (501,502,630) WHERE g.brand_id IN (937,1991) 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 g.id = gf0.id_good AND gf0.filter_id_value in (501,502,630) WHERE g.brand_id IN (937,1991) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.00073504447937012 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940; CREATE TEMPORARY TABLE tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00041317939758301 sec]
INSERT INTO tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 (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 (501,502,630) WHERE g.brand_id IN (937,1991) AND g.is_present_all_mods AND g.is_active ) A [0.0011930465698242 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940; CREATE TEMPORARY TABLE tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00034499168395996 sec]
INSERT INTO tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (501,502,630) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 146 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.0073320865631104 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940; CREATE TEMPORARY TABLE tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00031018257141113 sec]
INSERT IGNORE INTO tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 p GROUP BY p.filter_id [0.00025582313537598 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_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 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.00024604797363281 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 [0.00020122528076172 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 [0.0001060962677002 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca6940 [0.00014615058898926 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3; CREATE TEMPORARY TABLE tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.0002591609954834 sec]
INSERT INTO tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 (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 (501,502,630) WHERE g.brand_id IN (937,1991) 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 (501,502,630) WHERE g.brand_id IN (937,1991) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0015738010406494 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3; CREATE TEMPORARY TABLE tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00030994415283203 sec]
INSERT INTO tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (501,502,630) INNER JOIN pod_cat_filter cf ON gf.filter_id = cf.filter_id AND cf.category_id = 146 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.0011599063873291 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3; CREATE TEMPORARY TABLE tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00030899047851562 sec]
INSERT IGNORE INTO tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 p GROUP BY p.filter_id [0.00029110908508301 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_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 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.00037312507629395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 [0.00022411346435547 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 [0.00011396408081055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dca96f3 [9.7990036010742E-5 sec]
SELECT f.id as filter_id, 0 as count, f.entry, f.name, f.url, f.ord, fm.name as mname, fm.url as murl, fm.ord as mord FROM pod_filter f INNER JOIN pod_filter fm ON f.entry = fm.id WHERE f.id = 630 AND f.is_active AND fm.is_active [0.00036406517028809 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066; CREATE TEMPORARY TABLE tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00029802322387695 sec]
INSERT IGNORE INTO tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066 (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 (501,502,630) WHERE g.brand_id IN (937,1991) 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 g.id = gf0.id_good AND gf0.filter_id_value in (501,502,630) WHERE g.brand_id IN (937,1991) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.00075483322143555 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066; CREATE TEMPORARY TABLE tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00019383430480957 sec]
INSERT IGNORE INTO tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066 (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066 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.00020003318786621 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066 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.00014019012451172 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066 [0.0001380443572998 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4dcab066 [6.8902969360352E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00011396408081055 sec]
Низкие цены на Развивающие игрушки Trefl ... Learning Resources (Tрeфл ... Лирнінг Рeсoуркeс) – большой выбор, фото. Купить Развивающие игрушки Trefl ... Learning Resources (Tрeфл ... Лирнінг Рeсoуркeс) в Киеве и Украине

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

Магазин PODUSHKA ®

Магазин PODUSHKA ®
Игрушки для детей Игрушки для детей
Игрушки для малышей Игрушки для малышей
Развивающие игрушки Развивающие игрушки
Trefl ... Learning Resources Trefl ... Learning Resources

Развивающие игрушки Trefl ... Learning Resources

Как правильно выбрать игрушку для ребенка