SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/razvivayushchie/o_3-o_4-animals_developing-learning_resources-dodo.html' LIMIT 0,1 [0.00035786628723145 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('o_3','o_4','animals_developing','learning_resources','dodo') order by url [0.00078797340393066 sec]
SELECT id, url FROM pod_sub_icon WHERE url IN ('o_3','o_4','animals_developing','learning_resources','dodo') [0.00039792060852051 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.00032997131347656 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 (146) 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 (146) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.25660705566406 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.00058102607727051 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.0016310214996338 sec]
SELECT g.id /* cats:146 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (265,362) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (501) WHERE g.brand_id IN (1991,2494) AND g.is_present AND 1 UNION SELECT g.id /* cats:146 */ 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 (265,362) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (501) WHERE g.brand_id IN (1991,2494) AND 1 [0.013933897018433 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613; CREATE TEMPORARY TABLE tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00034618377685547 sec]
INSERT INTO tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613 (goods_id, filter_id) SELECT DISTINCT t.id AS goods_id, f.id AS filter_id FROM pod_cat_filter cf INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 0 AND fm.is_active INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good) ON gf.filter_id = cf.filter_id AND gf.cat_id IN (146) AND gf.filter_id_value NOT IN (265,362,501) INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active INNER JOIN tmp_base_goods t ON gf.id_good = t.id WHERE cf.category_id = 146 [0.0019412040710449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613; CREATE TEMPORARY TABLE tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00022602081298828 sec]
INSERT IGNORE INTO tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613 p GROUP BY p.filter_id [0.00026106834411621 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613 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.00027608871459961 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613 [0.00019216537475586 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c4613 [7.0095062255859E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae; CREATE TEMPORARY TABLE tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00017213821411133 sec]
INSERT INTO tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae (goods_id, filter_id) SELECT DISTINCT ts.entry AS goods_id, f.id AS filter_id FROM pod_cat_filter cf INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good) ON gf.filter_id = cf.filter_id AND gf.cat_id IN (146) AND gf.filter_id_value NOT IN (265,362,501) INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active INNER JOIN tmp_sub_goods ts ON gf.id_good = ts.id WHERE cf.category_id = 146 [0.0002901554107666 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae; CREATE TEMPORARY TABLE tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00017499923706055 sec]
INSERT IGNORE INTO tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae p GROUP BY p.filter_id [0.00016403198242188 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae 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.00013995170593262 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae [0.00015711784362793 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c55ae [7.2956085205078E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5; CREATE TEMPORARY TABLE tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 ( 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_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 (goods_id, filter_id) SELECT DISTINCT ts.entry AS goods_id, f.id AS filter_id FROM pod_cat_filter cf INNER JOIN pod_filter fm ON cf.filter_id = fm.id AND fm.is_split = 1 AND fm.is_active INNER JOIN pod_good_filter gf USE INDEX (idx_cat_filter_good) ON gf.filter_id = cf.filter_id AND gf.cat_id IN (146) AND gf.filter_id = 262 INNER JOIN pod_filter f ON gf.filter_id_value = f.id AND f.is_active INNER JOIN tmp_sub_goods ts ON gf.id_good = ts.id WHERE cf.category_id = 146 [0.00028681755065918 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5; CREATE TEMPORARY TABLE tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00018787384033203 sec]
INSERT INTO tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 p GROUP BY p.filter_id [0.00015592575073242 sec]
INSERT INTO tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 c ON c.filter_id = pf.id WHERE pf.id in (265,362) AND c.filter_id IS NULL [0.00018000602722168 sec]
SELECT c.filter_id, c.count, f.entry, f.name_ua AS name, f.url, f.ord, fm.name_ua AS mname, fm.url AS murl, fm.ord AS mord FROM tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 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.00020503997802734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 [0.00013899803161621 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c5da5 [6.9856643676758E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe; CREATE TEMPORARY TABLE tmp_A_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00022101402282715 sec]
INSERT IGNORE INTO tmp_A_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe (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:146 */ FROM tmp_base_goods g INNER JOIN pod_good_filter gf0 ON g.id = gf0.id_good AND gf0.filter_id_value in (265,362) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (501) WHERE g.brand_id IN (1991,2494) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:146 */ 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 (265,362) INNER JOIN pod_good_filter gf1 ON g.id = gf1.id_good AND gf1.filter_id_value in (501) WHERE g.brand_id IN (1991,2494) AND 1 ) A [0.00061488151550293 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe; CREATE TEMPORARY TABLE tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00022101402282715 sec]
INSERT IGNORE INTO tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe 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.00029301643371582 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name_ua AS name, si.url FROM tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe 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.00018191337585449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe [0.00019001960754395 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_2g0on5t0973s0s0te7cqobdjl5_6a2ba937c68fe [8.5115432739258E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00016117095947266 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

Як правильно вибрати іграшку для дитини