SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/14_fevralya/first_choice-noble-devays_maker.html' LIMIT 0,1 [0.00052595138549805 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('first_choice','noble','devays_maker') order by url [0.0017189979553223 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('first_choice','noble','devays_maker') order by url [0.0011930465698242 sec]
select id,url from pod_cat_brand where BINARY url = 'first_choice-noble-devays_maker' [0.0019018650054932 sec]
select id,url from pod_cat_brand where url = 'first_choice-noble-devays_maker' [0.00061297416687012 sec]
select id,url from pod_cat_brand where url in ('first_choice','noble','devays_maker') [0.00083684921264648 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.00054597854614258 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 (883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375) 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 (883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375) AND g.entry=0 AND g.is_active AND g.is_present_all_mods [0.37775015830994 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.00040292739868164 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.033991098403931 sec]
SELECT g.id /* cats:883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375 */ FROM tmp_base_goods g WHERE g.brand_id IN (1405,292,1202) AND 1 [0.00034809112548828 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2fbcb50de36 ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.00070905685424805 sec]
INSERT INTO temp_brand_counts_6a2fbcb50de36 (id, gid) SELECT g.brand_id AS id, g.id AS gid /* cats:883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375 */ FROM tmp_base_goods g WHERE 1 UNION SELECT id, null gid FROM pod_cat_category WHERE id in (1405,292,1202) [0.0086188316345215 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_6a2fbcb50de36 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.0019659996032715 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2fbcb50de36 [0.00026321411132812 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 /* cats:883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375 */ FROM tmp_base_goods g WHERE g.brand_id IN (1405,292,1202) AND g.is_present AND 1 UNION SELECT MIN(go.price) AS min_price, MAX(go.price) AS max_price /* cats:883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id WHERE g.brand_id IN (1405,292,1202) AND 1 ) A [0.00046110153198242 sec]
SELECT g.id /* cats:883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375 */,if(g.is_present and g.price >= '337' and g.price <= '4284',least(g.price,ifnull(min(pcg.price),g.price)),ifnull(min(pcg.price),g.price)) min_sort_price, if(g.is_present and g.price >= '337' and g.price <= '4284',greatest(g.price,ifnull(max(pcg.price),g.price)),ifnull(max(pcg.price),g.price)) max_sort_price FROM tmp_base_goods g LEFT JOIN pod_cat_good pcg ON pcg.entry=g.id AND pcg.is_present=1 AND pcg.price >= '337' AND pcg.price <= '4284' WHERE g.id IN (350332,350331,326269,413709,412181,471183,471182,471181,457424,145429,301156) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0032758712768555 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 >= '337' and g.price <= '4284',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 >= '337' and g.price <= '4284',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 >= '337' and pcg.price <= '4284') WHERE g.id in (326269,145429,457424,350331,350332,413709,412181,471183,471181,301156,471182) GROUP BY g.id ORDER BY g.ordr desc [0.0029850006103516 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 (326269,145429,457424,350331,350332,413709,412181,301156,471181,471182,471183) AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00063800811767578 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 (326269,145429,457424,350331,350332,413709,412181,301156,471181,471182,471183) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0039410591125488 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id in (1405,292,1202) [0.00032687187194824 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='1405.292.1202' [0.00026202201843262 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e; CREATE TEMPORARY TABLE tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00050091743469238 sec]
INSERT INTO tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e (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 (883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375) 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 = 883 [0.0019681453704834 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e; CREATE TEMPORARY TABLE tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00036287307739258 sec]
INSERT IGNORE INTO tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e p GROUP BY p.filter_id [0.00037908554077148 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_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e 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.00030398368835449 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e [0.00028014183044434 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51706e [0.0001218318939209 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f; CREATE TEMPORARY TABLE tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00028586387634277 sec]
INSERT INTO tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f (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 (883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375) 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 = 883 [0.00070905685424805 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f; CREATE TEMPORARY TABLE tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00047802925109863 sec]
INSERT IGNORE INTO tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f p GROUP BY p.filter_id [0.00027704238891602 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_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f 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.0002601146697998 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f [0.00033783912658691 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51842f [8.392333984375E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a; CREATE TEMPORARY TABLE tmp_A_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a ( entry INT NOT NULL, sub_icon_id INT NOT NULL, PRIMARY KEY (entry, sub_icon_id), INDEX idx_sub_icon_id (sub_icon_id) ) ENGINE=MEMORY; [0.00022697448730469 sec]
INSERT IGNORE INTO tmp_A_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a (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:883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375 */ FROM tmp_base_goods g WHERE g.brand_id IN (1405,292,1202) AND g.is_present AND 1 UNION SELECT go.id as id, g.id as entry, go.sub_icon_id /* cats:883,884,885,886,887,1165,1163,1166,2172,2173,888,889,1167,1375 */ FROM tmp_sub_goods go INNER JOIN tmp_base_goods g ON go.entry = g.id WHERE g.brand_id IN (1405,292,1202) AND 1 ) A [0.00049996376037598 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a; CREATE TEMPORARY TABLE tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00021481513977051 sec]
INSERT IGNORE INTO tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a 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.00040507316589355 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a 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.00024890899658203 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a [0.00018715858459473 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_nhmp3c40mj86enhk5tgo0kbc28_6a2fbcb51927a [8.392333984375E-5 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00013899803161621 sec]
Подарки на 14 февраля First choice ... Devays Maker (Фьост чойс ... Дeвaис Maкeр) – большой выбор, фото, отзывы. Купить Подарки на 14 февраля First choice ... Devays Maker в Киеве и Украине

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

ПЕРЕЙТИ

Подарки на 14 февраля First choice ... Devays Maker

Постельное белье VIP сатин 3D Swan pudra First choice Хит продаж
Постельное белье VIP сатин 3D Swan pudra First choice
Код: 326269

Производитель: First choice (Турция)

Цена:
4 082 грн
Подушка ортопедическая Noble Ergolight-Ergowave - 40 %
Подушка ортопедическая Noble Ergolight-Ergowave
Код: 145429
delivary icon

Производитель: Noble (Украина)

размер 32х49 см Ergolight

1 625 грн 975 грн

размер 40х58 см Ergowave

2 113 грн 1 268 грн
Цена:
975 грн 1 625 грн
Подушка ортопедическая Sweeten Gel Power L Noble Highfoam Хит продаж - 40 %
Подушка ортопедическая Sweeten Gel Power L Noble Highfoam
Код: 457424

Производитель: Noble (Украина)

Цена:
2 454 грн 4 090 грн
Постельное белье Edmon navy blue ранфорс First choice
Постельное белье Edmon navy blue ранфорс First choice
Код: 350331

Производитель: First choice (Турция)

Цена:
2 646 грн
Постельное белье Edmon dark red ранфорс First choice
Постельное белье Edmon dark red ранфорс First choice
Код: 350332

Производитель: First choice (Турция)

Цена:
2 646 грн
Постельное белье Timeless Powder сатин-делюкс First choice
Постельное белье Timeless Powder сатин-делюкс First choice
Код: 413709

Производитель: First choice (Турция)

Цена:
4 284 грн
Постельное белье Alfa Powder сатин-люкс First choice
Постельное белье Alfa Powder сатин-люкс First choice
Код: 412181

Производитель: First choice (Турция)

Цена:
4 284 грн
Кошелек кожаный Devays Maker сердца 30-0114-465
Кошелек кожаный Devays Maker сердца 30-0114-465
Код: 301156

Производитель: Devays Maker (Украина)

Цена:
337 грн
Подушка ортопедическая Highfoam Iconic M-line Noble - 40 %
Подушка ортопедическая Highfoam Iconic M-line Noble
Код: 471181

Производитель: Noble (Украина)

Цена:
1 764 грн 2 940 грн
Подушка ортопедическая Highfoam Iconic Air M-line Noble - 40 %
Подушка ортопедическая Highfoam Iconic Air M-line Noble
Код: 471182

Производитель: Noble (Украина)

Цена:
1 764 грн 2 940 грн
Подушка ортопедическая Ergolight Air M-line Noble - 40 %
Подушка ортопедическая Ergolight Air M-line Noble
Код: 471183

Производитель: Noble (Украина)

Цена:
975 грн 1 625 грн