SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/razvivayushchie/animals_developing-educational_pyramid-learning_resources-dodo.html' LIMIT 0,1 [0.00028395652770996 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('animals_developing','educational_pyramid','learning_resources','dodo') order by url [0.00073790550231934 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('animals_developing','educational_pyramid','learning_resources','dodo') order by url [0.00057697296142578 sec]
select id,url from pod_cat_brand where BINARY url IN ('animals_developing','educational_pyramid','learning_resources','dodo') [0.00098919868469238 sec]
SELECT id, url FROM pod_filter WHERE url IN ('animals_developing','educational_pyramid','learning_resources','dodo') [0.0002601146697998 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('animals_developing','educational_pyramid','learning_resources','dodo') [0.00039100646972656 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 (501,503) and f.is_active AND mf.is_active ORDER BY mf.id, f.id [0.00036311149597168 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; CREATE TEMPORARY TABLE tmp_base_goods (id INT NOT NULL PRIMARY KEY) ENGINE=MEMORY [0.0002140998840332 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.004176139831543 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.00026106834411621 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.00056099891662598 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,503) WHERE g.brand_id IN (1991,2494) AND g.is_present_all_mods AND g.is_active [0.0057399272918701 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2ac4da2812c ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00023388862609863 sec]
INSERT INTO temp_brand_counts_6a2ac4da2812c (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,503) WHERE g.is_present_all_mods AND g.is_active UNION SELECT id, null gid FROM pod_cat_category WHERE id in (1991,2494) [0.022209882736206 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_6a2ac4da2812c 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.00076699256896973 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2ac4da2812c [0.00020885467529297 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,503) WHERE g.brand_id IN (1991,2494) 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,503) WHERE g.brand_id IN (1991,2494) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.0012898445129395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda; CREATE TEMPORARY TABLE tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00030279159545898 sec]
INSERT INTO tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda (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,503) WHERE g.brand_id IN (1991,2494) AND g.is_present_all_mods AND g.is_active ) A [0.00070786476135254 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda; CREATE TEMPORARY TABLE tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00017189979553223 sec]
INSERT INTO tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (501,503) 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.0023689270019531 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda; CREATE TEMPORARY TABLE tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00018596649169922 sec]
INSERT IGNORE INTO tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda p GROUP BY p.filter_id [0.00029301643371582 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_6a2ac4da2fcda 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.00022602081298828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda [0.00017499923706055 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda [7.9870223999023E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da2fcda [9.8228454589844E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207; CREATE TEMPORARY TABLE tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00015902519226074 sec]
INSERT INTO tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 (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,503) WHERE g.brand_id IN (1991,2494) 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,503) WHERE g.brand_id IN (1991,2494) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.00071811676025391 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207; CREATE TEMPORARY TABLE tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00019502639770508 sec]
INSERT INTO tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (501,503) 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.00066614151000977 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207; CREATE TEMPORARY TABLE tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0002899169921875 sec]
INSERT IGNORE INTO tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 p GROUP BY p.filter_id [0.00024890899658203 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_6a2ac4da31207 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.00021505355834961 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 [0.00015497207641602 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 [6.8902969360352E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da31207 [7.2956085205078E-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 = 503 AND f.is_active AND fm.is_active [0.00023794174194336 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3; CREATE TEMPORARY TABLE tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3 ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00020194053649902 sec]
INSERT IGNORE INTO tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3 (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,503) WHERE g.brand_id IN (1991,2494) 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,503) WHERE g.brand_id IN (1991,2494) AND go.is_present AND go.is_active AND g.is_present_all_mods AND g.is_active ) A [0.00052809715270996 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3; CREATE TEMPORARY TABLE tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3 ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00016283988952637 sec]
INSERT IGNORE INTO tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3 (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_6a2ac4da322a3 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.00020384788513184 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3 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.00012302398681641 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3 [0.00011992454528809 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_p2ksck3hrtu5hp5l12pa6an5i4_6a2ac4da322a3 [5.8889389038086E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00010585784912109 sec]
Низкие цены на Развивающие игрушки Learning Resources ... Dodo (Лирнінг Рeсoуркeс ... Дoдo) – большой выбор, фото. Купить Развивающие игрушки Learning Resources ... Dodo (Лирнінг Рeсoуркeс ... Дoдo) в Киеве и Украине

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

Магазин PODUSHKA ®

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

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

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