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.0003359317779541 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.22782707214355 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.00034093856811523 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.00044608116149902 sec]
SELECT g.video, g.threedvideo, g.is_xit, g.is_action, g.is_sale, g.sub_is_action, g.is_new, g.is_pay_for_video, g.id, g.cat_id, g.name AS name, g.name2 AS name2, g.descr, g.size_table, g.artikul, g.image_small, g.image_big, g.price, g.old_price, g.is_present, g.is_present_all_mods, g.sub_icon_id,g.url,g.ordr, g.last_items, g.fast_delivery, g.free_delivery, g.gift, g.timer, g.action_validity, b.name AS brand_name,b.url as burl,b.id as bid, b.country AS brand_country,c.url as curl, c.name AS cat_name, si.name AS sub_icon_name,si.icon AS sub_icon, g.star, g.comment_id, if(g.is_present and g.price >= '243' and g.price <= '462',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) as min_sort_price, if(g.is_present and g.price >= '243' and g.price <= '462',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) as max_sort_price FROM pod_cat_good g INNER JOIN pod_cat_category c ON c.id=g.cat_id LEFT JOIN pod_cat_brand b ON b.id=g.brand_id LEFT JOIN pod_sub_icon si ON si.id=g.sub_icon_id LEFT JOIN pod_cat_good pcg ON (pcg.entry=g.id and pcg.is_present=1 and pcg.price >= '243' and pcg.price <= '462') WHERE g.id in (478517,478421,478516) GROUP BY g.id ORDER BY g.ordr desc [0.0026779174804688 sec]
SELECT g.ordr, g.is_xit, g.is_pay_for_video, g.is_action, g.is_sale, g.is_new, g.last_items, g.fast_delivery, g.free_delivery, g.gift, g.timer, g.action_validity, g.id, g.entry, g.name AS name, g.price, g.old_price, g.artikul, g.sub_icon_id, g.is_present, si.name AS sub_icon_name, si.icon AS sub_icon FROM pod_cat_good g LEFT JOIN pod_sub_icon si ON si.id = g.sub_icon_id WHERE g.entry IN (478517,478421,478516) AND g.is_present = '1' AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00023198127746582 sec]
SELECT DISTINCT ggd2.good_id AS source_good_id, g.id, g.is_present_all_mods, pc.name AS name, g.url, b.url as burl, c.url as curl, g.is_present, pc.code AS color_code, gg.group_type, gg.param_name, gg.param_name_ua, ggd.text_value, ggd.icon_path FROM pod_goods_group_goods ggd2 JOIN pod_goods_group_goods ggd ON ggd2.goods_group_id=ggd.goods_group_id JOIN pod_goods_group gg ON ggd.goods_group_id=gg.id JOIN pod_cat_good g ON g.id=ggd.good_id LEFT JOIN pod_cat_brand b ON g.brand_id=b.id LEFT JOIN pod_cat_category c ON g.cat_id=c.id LEFT JOIN pod_colors pc ON pc.id=ggd.color_id WHERE ggd2.good_id IN (478517,478421,478516) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.00032496452331543 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='2613.1860' [0.00012683868408203 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d; CREATE TEMPORARY TABLE tmp_A_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d ( id INT NOT NULL, entry INT NOT NULL, PRIMARY KEY (id), KEY idx_entry (entry) ) ENGINE=MEMORY [0.00020289421081543 sec]
INSERT INTO tmp_A_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d (id, entry) SELECT A.id, A.entry FROM ( SELECT g.id as id, g.id as entry /* 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 (501,502) WHERE g.brand_id IN (2613,1860) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry /* 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 g.id = gf0.id_good AND gf0.filter_id_value in (501,502) WHERE g.brand_id IN (2613,1860) AND 1 ) A [0.001133918762207 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d; CREATE TEMPORARY TABLE tmp_pairs_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY [0.00021481513977051 sec]
INSERT INTO tmp_pairs_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d (goods_id, filter_id) SELECT DISTINCT A.entry AS goods_id, f.id AS filter_id FROM tmp_A_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d A INNER JOIN pod_good_filter gf ON A.id = gf.id_good AND gf.filter_id = 262 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.00078988075256348 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d; CREATE TEMPORARY TABLE tmp_counts_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY [0.00023889541625977 sec]
INSERT INTO tmp_counts_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d p GROUP BY p.filter_id [0.00022602081298828 sec]
INSERT INTO tmp_counts_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d (filter_id, count) SELECT pf.id, 0 FROM pod_filter pf LEFT JOIN tmp_counts_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d c ON c.filter_id = pf.id WHERE pf.id in (362) AND c.filter_id IS NULL [0.00022697448730469 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_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d 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.00024700164794922 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d [0.00016498565673828 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d [9.0837478637695E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_r1c8pn73d7ui465hmsht7f3alo_6a2b94e26a20d [6.6995620727539E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.0001528263092041 sec]
Низкие цены на Развивающие игрушки Bb Junior ... Iggy Ziggy (Бб Жуніoр ... Ігги Зігги) – большой выбор, фото. Купить Развивающие игрушки Bb Junior ... Iggy Ziggy (Бб Жуніoр ... Ігги Зігги) в Киеве и Украине

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

Магазин PODUSHKA ®

Магазин PODUSHKA ®
Игрушки для детей Игрушки для детей
Игрушки для малышей Игрушки для малышей
Развивающие игрушки Развивающие игрушки
Bb Junior ... Iggy Ziggy Bb Junior ... Iggy Ziggy

Развивающие игрушки Bb Junior ... Iggy Ziggy

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