DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; CREATE TEMPORARY TABLE tmp_base_goods (id INT NOT NULL PRIMARY KEY) ENGINE=MEMORY [0.00047397613525391 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.0054121017456055 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.00033712387084961 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.0010890960693359 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2ac4c6af5ea ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00035500526428223 sec]
INSERT INTO temp_brand_counts_6a2ac4c6af5ea (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) 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.0030779838562012 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_6a2ac4c6af5ea 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.00060892105102539 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2ac4c6af5ea [0.00024700164794922 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42; CREATE TEMPORARY TABLE tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00023794174194336 sec]
INSERT INTO tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 (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) WHERE g.brand_id IN (1991,2494) AND g.is_present_all_mods AND g.is_active ) A [0.0037510395050049 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42; CREATE TEMPORARY TABLE tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00018000602722168 sec]
INSERT INTO tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (501) 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.0010440349578857 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42; CREATE TEMPORARY TABLE tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.0001981258392334 sec]
INSERT IGNORE INTO tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 p GROUP BY p.filter_id [0.00014495849609375 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_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 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.00013589859008789 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 [0.00013613700866699 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 [5.4121017456055E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b1c42 [6.5088272094727E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8; CREATE TEMPORARY TABLE tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY; [0.00013899803161621 sec]
INSERT INTO tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 (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) 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) 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.00057387351989746 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8; CREATE TEMPORARY TABLE tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00019288063049316 sec]
INSERT INTO tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id_value NOT IN (501) 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.00035595893859863 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8; CREATE TEMPORARY TABLE tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00016999244689941 sec]
INSERT IGNORE INTO tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 p GROUP BY p.filter_id [0.00014805793762207 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_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 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.00017094612121582 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 [0.00011205673217773 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 [5.2213668823242E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b35e8 [4.7922134399414E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d; CREATE TEMPORARY TABLE tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d ( id INT NOT NULL, PRIMARY KEY (id) ) ENGINE=MEMORY; [0.00013017654418945 sec]
INSERT INTO tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d (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 WHERE g.brand_id IN (1991,2494) AND g.is_present_all_mods AND g.is_active ) A [0.00032901763916016 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d; CREATE TEMPORARY TABLE tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00015401840209961 sec]
INSERT INTO tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d (goods_id, filter_id) SELECT DISTINCT A.id AS goods_id, f.id AS filter_id FROM tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 499 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.0010099411010742 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d; CREATE TEMPORARY TABLE tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00015497207641602 sec]
INSERT INTO tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d p GROUP BY p.filter_id [0.00014615058898926 sec]
INSERT IGNORE INTO tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d c ON c.filter_id = pf.id WHERE pf.id in (501) AND c.filter_id IS NULL [0.00011301040649414 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_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d 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.00016999244689941 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d [0.00012779235839844 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d [5.793571472168E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b401d [5.3882598876953E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b; CREATE TEMPORARY TABLE tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id) ) ENGINE=MEMORY; [0.00013613700866699 sec]
INSERT IGNORE INTO tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b (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) 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) 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.00085902214050293 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b; CREATE TEMPORARY TABLE tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00015091896057129 sec]
INSERT IGNORE INTO tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b 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.00016093254089355 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b 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.00010490417480469 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b [9.4890594482422E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_t61pc4krg4fhs6eb1q191k596o_6a2ac4c6b4c4b [4.6014785766602E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [9.7990036010742E-5 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

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