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.00052094459533691 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.29741811752319 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.00047683715820312 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.00071406364440918 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b; CREATE TEMPORARY TABLE tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00044989585876465 sec]
INSERT INTO tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b (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 (556,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.0022001266479492 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b; CREATE TEMPORARY TABLE tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00034689903259277 sec]
INSERT IGNORE INTO tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b p GROUP BY p.filter_id [0.0003819465637207 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_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b 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.0004270076751709 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b [0.00028586387634277 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc7642b [0.00011706352233887 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167; CREATE TEMPORARY TABLE tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.0003049373626709 sec]
INSERT INTO tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 (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 = 499 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.0011119842529297 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167; CREATE TEMPORARY TABLE tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00037002563476562 sec]
INSERT INTO tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 p GROUP BY p.filter_id [0.00035691261291504 sec]
INSERT IGNORE INTO tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 c ON c.filter_id = pf.id WHERE pf.id in (501) AND c.filter_id IS NULL [0.00025200843811035 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_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 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.00040006637573242 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 [0.00026607513427734 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_geebg09gc1n79qc4eee54kanbu_6a2bacdc78167 [0.00011992454528809 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.0002439022064209 sec]
Низькі ціни на Розвиваючі іграшки Cubika ... Learning Resources (Кубікa ... Лирнінг Рeсoуркeс) - великий вибір, фото. Купити Розвиваючі іграшки Cubika ... Learning Resources (Кубікa ... Лирнінг Рeсoуркeс) в Києві і Україні

DEVELOPMENT🌷ЗНИЖКИ ДО 70%

Магазин PODUSHKA ®

Магазин PODUSHKA ®
Іграшки для дітей Іграшки для дітей
Іграшки для малюків Іграшки для малюків
Розвиваючі іграшки Розвиваючі іграшки
Cubika ... Learning Resources Cubika ... Learning Resources

Розвиваючі іграшки Cubika ... Learning Resources

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