SELECT url_to, r404 FROM pod_redirect WHERE BINARY REPLACE(url_from,'/ru/','/') = '/14_fevralya/first_choice-poolparty-devays_maker-tescoma-la_maison.html' LIMIT 0,1 [0.00022006034851074 sec]
SELECT pod_filter.id,pod_filter.url FROM pod_filter WHERE BINARY pod_filter.url IN ('first_choice','poolparty','devays_maker','tescoma','la_maison') order by url [0.00098204612731934 sec]
SELECT pod_sub_icon.id,pod_sub_icon.url FROM pod_sub_icon WHERE BINARY pod_sub_icon.url IN ('first_choice','poolparty','devays_maker','tescoma','la_maison') order by url [0.00065398216247559 sec]
select id,url from pod_cat_brand where BINARY url = 'first_choice-poolparty-devays_maker-tescoma-la_maison' [0.0037050247192383 sec]
select id,url from pod_cat_brand where url = 'first_choice-poolparty-devays_maker-tescoma-la_maison' [0.00036311149597168 sec]
select id,url from pod_cat_brand where url in ('first_choice','poolparty','devays_maker','tescoma','la_maison') [0.00060415267944336 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.00029110908508301 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.20050096511841 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.00034594535827637 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.020449161529541 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,2457,1060,1984) AND 1 [0.0003669261932373 sec]
CREATE TEMPORARY TABLE temp_brand_counts_6a2fd40594d7c ( id INT, gid INT, INDEX idx_id (id), INDEX idx_gid (gid) ) [0.0003819465637207 sec]
INSERT INTO temp_brand_counts_6a2fd40594d7c (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,2457,1060,1984) [0.009127140045166 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_6a2fd40594d7c 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.0020968914031982 sec]
DROP TEMPORARY TABLE IF EXISTS temp_brand_counts_6a2fd40594d7c [0.00021505355834961 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,2457,1060,1984) 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,2457,1060,1984) AND 1 ) A [0.00055408477783203 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,273436,301156,296715,509658,509630,509596,506648,478352,478349,478348,478343,478338,478291,509594,509593) GROUP BY g.id ORDER BY g.ordr desc LIMIT 0, 32 [0.0017948150634766 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,478338,478343,509596,506648,509594,478348,350331,350332,413709,412181,273436,478291,509630,509593,296715,509658,478349,301156,478352) GROUP BY g.id ORDER BY g.ordr desc [0.0034840106964111 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,478338,478343,509596,506648,509594,478348,350331,350332,413709,412181,273436,478291,296715,301156,478349,478352,509593,509630,509658) AND g.is_active = '1' ORDER BY g.entry, g.is_present DESC [0.00060391426086426 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,478338,478343,509596,506648,509594,478348,350331,350332,413709,412181,273436,478291,296715,301156,478349,478352,509593,509630,509658) ORDER BY ggd2.good_id, g.is_present_all_mods DESC [0.0050098896026611 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id in (1405,292,2457,1060,1984) [0.0002899169921875 sec]
SELECT name AS name, url FROM pod_cat_brand WHERE id='1405.292.2457.1060.1984' [0.00020718574523926 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce; CREATE TEMPORARY TABLE tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00045013427734375 sec]
INSERT INTO tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce (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.0016391277313232 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce; CREATE TEMPORARY TABLE tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00029397010803223 sec]
INSERT IGNORE INTO tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce p GROUP BY p.filter_id [0.00026917457580566 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_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce 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.00024986267089844 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce [0.0002589225769043 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059cdce [0.00011801719665527 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c; CREATE TEMPORARY TABLE tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c ( goods_id INT NOT NULL, filter_id INT NOT NULL, PRIMARY KEY (goods_id, filter_id) ) ENGINE=MEMORY; [0.00025415420532227 sec]
INSERT INTO tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c (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.000640869140625 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c; CREATE TEMPORARY TABLE tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c ( filter_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00032591819763184 sec]
INSERT IGNORE INTO tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c (filter_id, count) SELECT p.filter_id, COUNT(*) AS count FROM tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c p GROUP BY p.filter_id [0.00023603439331055 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_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c 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.00021791458129883 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_pairs_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c [0.00022315979003906 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059dd1c [0.00013589859008789 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d; CREATE TEMPORARY TABLE tmp_A_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d ( 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.00024294853210449 sec]
INSERT IGNORE INTO tmp_A_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d (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,2457,1060,1984) 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,2457,1060,1984) AND 1 ) A [0.0005650520324707 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d; CREATE TEMPORARY TABLE tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d ( sub_icon_id INT NOT NULL PRIMARY KEY, count INT NOT NULL ) ENGINE=MEMORY; [0.00032401084899902 sec]
INSERT IGNORE INTO tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d (sub_icon_id, count) SELECT sub_icon_id, COUNT(DISTINCT entry) AS count FROM ( SELECT A.entry, A.sub_icon_id FROM tmp_A_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d 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.00050020217895508 sec]
SELECT c.sub_icon_id AS id, c.count, si.entry, si.name AS name, si.url FROM tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d 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.00024795532226562 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_A_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d [0.00025200843811035 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_counts_55e0v0gpdpevsm6ou615llgode_6a2fd4059e81d [0.00015687942504883 sec]
DROP TEMPORARY TABLE IF EXISTS tmp_base_goods; DROP TEMPORARY TABLE IF EXISTS tmp_sub_goods [0.00017285346984863 sec]
Подарки на 14 февраля First choice ... La Maison (Фьост чойс ... Лa Maісoн) – большой выбор, фото, отзывы. Купить Подарки на 14 февраля First choice ... La Maison в Киеве и Украине

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

ПЕРЕЙТИ

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

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

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

Цена:
4 082 грн
Набор Himel La Maison 3 полотенца и парфюм для белья
Набор Himel La Maison 3 полотенца и парфюм для белья
Код: 478338

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

Цена:
2 079 грн
Набор Karna La Maison 3 полотенца и парфюм для белья
Набор Karna La Maison 3 полотенца и парфюм для белья
Код: 478343

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

Цена:
2 079 грн
Набор Rome La Maison 3 полотенца и парфюм для белья Новинка
Набор Rome La Maison 3 полотенца и парфюм для белья
Код: 509596

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

Цена:
2 079 грн
Набор Lovely La Maison 3 полотенца и парфюм для белья Новинка
Набор Lovely La Maison 3 полотенца и парфюм для белья
Код: 506648

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

Цена:
2 079 грн
Набор Della gri La Maison 3 полотенца и парфюм для белья Новинка
Набор Della gri La Maison 3 полотенца и парфюм для белья
Код: 509594

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

Цена:
2 079 грн
Набор Mely La Maison 3 полотенца и парфюм для белья
Набор Mely La Maison 3 полотенца и парфюм для белья
Код: 478348

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

Цена:
2 079 грн
Постельное белье 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 грн
Кожаная ключница-цветок Poolparty золотистая keychain-flower-gold
Кожаная ключница-цветок Poolparty золотистая keychain-flower-gold
Код: 273436
delivary icon

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

Цена:
691 грн
Набор Ferge La Maison 3 полотенца и парфюм для белья
Набор Ferge La Maison 3 полотенца и парфюм для белья
Код: 478291
delivary icon

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

Цена:
2 079 грн
Форма в виде сердца Tescoma Delica 23см 623160
Форма в виде сердца Tescoma Delica 23см 623160
Код: 296715

Производитель: Tescoma (Чехия)

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

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

Цена:
337 грн
Набор Meor La Maison 3 полотенца и парфюм для белья
Набор Meor La Maison 3 полотенца и парфюм для белья
Код: 478349

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

Цена:
2 079 грн
Набор Nomi La Maison 3 полотенца и парфюм для белья
Набор Nomi La Maison 3 полотенца и парфюм для белья
Код: 478352

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

Цена:
2 079 грн
Набор Babe La Maison 3 полотенца и парфюм для белья Новинка
Набор Babe La Maison 3 полотенца и парфюм для белья
Код: 509593

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

Цена:
2 079 грн
Набор Tima La Maison 3 полотенца и парфюм для белья Новинка
Набор Tima La Maison 3 полотенца и парфюм для белья
Код: 509630

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

Цена:
2 079 грн
Набор Wilma La Maison 3 полотенца и парфюм для белья Новинка
Набор Wilma La Maison 3 полотенца и парфюм для белья
Код: 509658

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

Цена:
2 079 грн