Beyaz Rüya Dünyası

Name: Beyaz Rüya Dünyası
Brand: Nihat Petek
SKU: NP2442
Price: 671.00 TRY
Availability: InStock

671,00 TL

Ürün Kodu: NP2442

Bu ürünle beraber alabileceğiniz ek ürünler

Mutlu Ayıcık

270,00 TL

Seni Seviyorum Mini Pankart

10,00 TL

Başarılar Dilerim

10,00 TL

Özür Dilerim Pankart

10,00 TL

Kırmızı Gül

50,00 TL

Beyaz Gül

150,00 TL

Minik Maskot Ayıcık

70,00 TL

İyi ki Doğdun Mini Pankart

10,00 TL

ÜRÜN DETAYLARI

38 cm boyundaki turuncu silindirik kutunun içinde özenle hazırlanmış olan Beyaz Rüya Dünyası, modern tasarım ve doğal güzelliğin kusursuz uyumunu sunuyor.

Bu aranjmanda yer alan beyaz şebboy ve beyaz papatyalar, saflığın, zarafetin ve huzurun simgesi olarak öne çıkıyor.

SON GEZDİKLERİNİZ

Aynı Gün Teslimat

Sevgilime Beyaz Gerbera

(1)

621,00 TL

Aynı Gün Teslimat

Papatyaların Gül Buketi

(2)

751,00 TL

Aynı Gün Teslimat

SİZİN İÇİN ÖNERDİKLERİMİZ

Aynı Gün Teslimat

Aşkımın Sembolü Orkidem

1.744,00 TL

Aynı Gün Teslimat

Aşkın Sen Hali

(3)

788,00 TL

Aynı Gün Teslimat

Aşkın Melodisi

1.072,00 TL

Aynı Gün Teslimat

Kırmızı Gül ve Fiyonklu Ayıcık

661,00 TL

1	ok	3.3 ms	prepared.select	`select id, langname, shortname, protection from language where aktif=:active order by protection desc, id asc` Params: {"active":"1"}
2	ok	2.13 ms	prepared.select	`select * from settings` Params: []
3	ok	1.42 ms	prepared.select	`select contenttype, seoprodcat from contents where publish=:publish and langid=:language_id and customurl=:slug and ( (contenttype=:content_type and seoprodcat=:empty_seo_product_category) or seoprodcat<>:seo_product_category ) order by case when contenttype=:content_type_order and seoprodcat=:empty_seo_product_category_order then 0 else 1 end limit 1` Params: {"publish":"1","language_id":1,"slug":"beyaz-ruya-dunyasi-np2442","content_type":"1","empty_seo_product_category":"","seo_product_category":"","content_type_order":"1","empty_seo_product_category_order":""}
4	ok	1.94 ms	prepared.select	`select route_type from ( select 'product' as route_type from products where publish=:product_publish and langid=:product_language_id and customurl=:product_slug limit 1 ) product_route union all select route_type from ( select 'category' as route_type from categoriesproduct where active=:category_active and langid=:category_language_id and customurl=:category_slug and productgroup=:category_product_group limit 1 ) category_route limit 1` Params: {"product_publish":"1","product_language_id":1,"product_slug":"beyaz-ruya-dunyasi-np2442","category_active":"1","category_language_id":1,"category_slug":"beyaz-ruya-dunyasi-np2442","category_product_group":"0"}
5	ok	1.25 ms	prepared.select	select nav_menu_items.id, nav_menu_items.menu_id, nav_menu_items.parent_item_id, nav_menu_items.type, nav_menu_items.original_item_id, nav_menu_items.title, nav_menu_items.url, nav_menu_items.newtab, nav_menu_items.newtag, nav_menu_items.orderx from nav_menu left join nav_menu_items on nav_menu_items.menu_id = nav_menu.id where nav_menu.publish=:publish and nav_menu.position=:position and nav_menu.language=:language_id and nav_menu_items.id is not null order by nav_menu_items.parent_item_id asc, nav_menu_items.orderx asc Params: {"publish":"1","position":1,"language_id":1}
6	ok	1.34 ms	prepared.select	select id, customurl, title from categoriesproduct where id in (:target_id_0,:target_id_1,:target_id_2,:target_id_3,:target_id_4,:target_id_5,:target_id_6,:target_id_7,:target_id_8,:target_id_9,:target_id_10,:target_id_11,:target_id_12,:target_id_13,:target_id_14,:target_id_15,:target_id_16,:target_id_17,:target_id_18,:target_id_19,:target_id_20,:target_id_21,:target_id_22,:target_id_23,:target_id_24,:target_id_25,:target_id_26,:target_id_27,:target_id_28,:target_id_29,:target_id_30,:target_id_31,:target_id_32,:target_id_33,:target_id_34,:target_id_35,:target_id_36,:target_id_37,:target_id_38,:target_id_39,:target_id_40,:target_id_41,:target_id_42,:target_id_43,:target_id_44,:target_id_45,:target_id_46,:target_id_47,:target_id_48,:target_id_49,:target_id_50,:target_id_51,:target_id_52) Params: {"target_id_0":1,"target_id_1":4,"target_id_2":48,"target_id_3":52,"target_id_4":17,"target_id_5":39,"target_id_6":11,"target_id_7":15,"target_id_8":6,"target_id_9":7,"target_id_10":14,"target_id_11":9,"target_id_12":13,"target_id_13":16,"target_id_14":12,"target_id_15":8,"target_id_16":5,"target_id_17":10,"target_id_18":105,"target_id_19":70,"target_id_20":30,"target_id_21":69,"target_id_22":99,"target_id_23":249,"target_id_24":257,"target_id_25":106,"target_id_26":153,"target_id_27":253,"target_id_28":113,"target_id_29":114,"target_id_30":116,"target_id_31":282,"target_id_32":241,"target_id_33":112,"target_id_34":110,"target_id_35":175,"target_id_36":273,"target_id_37":50,"target_id_38":51,"target_id_39":18,"target_id_40":19,"target_id_41":283,"target_id_42":44,"target_id_43":41,"target_id_44":46,"target_id_45":40,"target_id_46":28,"target_id_47":23,"target_id_48":25,"target_id_49":22,"target_id_50":26,"target_id_51":27,"target_id_52":24}
7	ok	1 ms	prepared.select	`select * from il order by ilad asc, queue desc` Params: []
8	ok	3.12 ms	prepared.select	select products.id, products.groupid, products.title, products.metatitle, products.fileuploadlimit, products.sendtype, products.metadescription, products.301move, products.seller_id, products.price, products.price2, products.stock, products.stockcode, products.kdv, products.readx, products.content, products.issale, products.addprodlist, products.typex, products.customurl, products.kdvdahil, products.deliverytext, products.allowfileupload, products.barcode as gtincode, media.pathfile as mpathfile, media.path as mpath, media.titlefile, thumbs.pathfile as tpathfile, thumbs.path as tpath, categoriesproduct.title as ctitle, categoriesproduct.customurl as ccustomurl, categoriesproduct.groupid as cgroupid, categoriesproduct.id as cid, categoriesproduct.type as ctype, categoriesproduct.clocktype, categoryproduct.maincat from products inner join media_relation on media_relation.content_id = products.id inner join media on media.id = media_relation.media_id inner join thumbs on thumbs.media_i... Params: {"thumb_template_id":"1","content_type":"3","prev_type":"1","slug":"beyaz-ruya-dunyasi-np2442","publish":"1","language_id":1,"is_add_product":"0","category_active":"1","main_category":"1"}
9	ok	0.85 ms	prepared.select	`select id, parentid, title, customurl from categoriesproduct where active=:active and langid=:language_id and id=:category_id limit 1` Params: {"active":"1","language_id":1,"category_id":1}
10	ok	0.69 ms	prepared.select	`select id, prodid, boxtype, boxlabel, boxmaxlength from product_specialbox where prodid=:product_id` Params: {"product_id":2782}
11	ok	1.06 ms	prepared.select	select thumbs.pathfile as thumb_pathfile, thumbs.path as thumb_path, thumbs.template_id as thumb_template_id, media.titlefile, media.id as media_id, media.pathfile as media_pathfile, media.path as media_path, media.type, media.videothumb from media_relation left join thumbs on thumbs.media_id = media_relation.media_id left join media on media.id = media_relation.media_id where media_relation.content_type=:content_type and media_relation.content_id=:product_id order by media_relation.prev_type asc, media_relation.orderx asc Params: {"content_type":"3","product_id":2782}
12	ok	0.7 ms	prepared.select	`select namesurname, created_at, texts, vote, image from comments where agree=:agree and prodid=:product_id order by id desc limit 0,25` Params: {"agree":"1","product_id":2782}
13	ok	433.01 ms	prepared.select	select products.id, products.title, products.readx, products.metadescription as description, products.customurl, products.groupid, products.price, products.price2, products.kdv, products.kdvdahil, products.sendtype from categoriesproduct inner join categoryproduct on categoryproduct.categorygroupid = categoriesproduct.groupid inner join products on products.groupid = categoryproduct.productgroupid where categoryproduct.categorygroupid=:category_group_id and products.publish=:publish and products.langid=:language_id and products.isaddprod=:is_add_product and products.customurl<>:excluded_slug and not exists ( select 1 from product_recipe main_system_product_recipe inner join seller_blockrecipe main_system_blockrecipe on main_system_blockrecipe.recipeid = main_system_product_recipe.recipe_id where main_system_blockrecipe.sellerid = 0 and main_system_product_recipe.product_id = products.groupid ) group by products.groupid order by rand() limit 0,10 Params: {"category_group_id":"5RFS4n9M9avJ55Pm8Wh4UTGpvCZfyu3e817802","publish":"1","language_id":1,"is_add_product":"0","excluded_slug":"beyaz-ruya-dunyasi-np2442"}
14	ok	3.4 ms	prepared.select	select media_relation.content_id, media.id, media.pathfile, media.path, media.titlefile, media.type, media.videothumb, media_relation.prev_type, media_relation.custom_content from media_relation left join media on media.id = media_relation.media_id where media_relation.content_id in (:product_id_0,:product_id_1,:product_id_2,:product_id_3,:product_id_4,:product_id_5,:product_id_6,:product_id_7,:product_id_8,:product_id_9) and media_relation.content_type=:content_type order by media_relation.content_id asc, media_relation.orderx asc Params: {"product_id_0":1010,"product_id_1":1533,"product_id_2":4493,"product_id_3":1787,"product_id_4":158,"product_id_5":3975,"product_id_6":5435,"product_id_7":4367,"product_id_8":172,"product_id_9":2810,"content_type":"3"}
15	ok	3.04 ms	prepared.select	`select media_id, template_id, pathfile, path from thumbs where media_id in (:media_id_0,:media_id_1,:media_id_2,:media_id_3,:media_id_4,:media_id_5,:media_id_6,:media_id_7,:media_id_8,:media_id_9,:media_id_10,:media_id_11,:media_id_12,:media_id_13,:media_id_14)` Params: {"media_id_0":7662,"media_id_1":7882,"media_id_2":256,"media_id_3":1465,"media_id_4":1464,"media_id_5":5658,"media_id_6":2568,"media_id_7":2567,"media_id_8":4233,"media_id_9":5714,"media_id_10":5716,"media_id_11":6359,"media_id_12":6357,"media_id_13":6515,"media_id_14":7748}
16	ok	2.69 ms	prepared.select	`select prodid, count(*) as comment_count, coalesce(sum(vote),0) as votesum from comments where agree=:agree and prodid in (:comment_product_id_0,:comment_product_id_1,:comment_product_id_2,:comment_product_id_3,:comment_product_id_4,:comment_product_id_5,:comment_product_id_6,:comment_product_id_7,:comment_product_id_8,:comment_product_id_9) group by prodid` Params: {"comment_product_id_0":1010,"comment_product_id_1":1533,"comment_product_id_2":4493,"comment_product_id_3":1787,"comment_product_id_4":158,"comment_product_id_5":3975,"comment_product_id_6":5435,"comment_product_id_7":4367,"comment_product_id_8":172,"comment_product_id_9":2810,"agree":"1"}
17	ok	5.01 ms	prepared.select	select products.id, products.title, products.readx, products.metadescription as description, products.customurl, products.groupid, products.price, products.price2, products.kdv, products.kdvdahil, products.sendtype from products where products.publish=:publish and products.langid=:language_id and products.isaddprod=:is_add_product and products.seller_id=:site_seller_id and products.id in (:visited_product_id_0,:visited_product_id_1,:visited_product_id_2,:visited_product_id_3,:visited_product_id_4,:visited_product_id_5,:visited_product_id_6,:visited_product_id_7,:visited_product_id_8) and not exists ( select 1 from product_recipe main_system_product_recipe inner join seller_blockrecipe main_system_blockrecipe on main_system_blockrecipe.recipeid = main_system_product_recipe.recipe_id where main_system_blockrecipe.sellerid = 0 and main_system_product_recipe.product_id = products.groupid ) group by products.groupid order by field(products.id, 654,2737,1886,4265,3041,3083,840,3416,2782) ... Params: {"visited_product_id_0":654,"visited_product_id_1":2737,"visited_product_id_2":1886,"visited_product_id_3":4265,"visited_product_id_4":3041,"visited_product_id_5":3083,"visited_product_id_6":840,"visited_product_id_7":3416,"visited_product_id_8":2782,"publish":"1","language_id":1,"is_add_product":"0","site_seller_id":"0"}
18	ok	3.73 ms	prepared.select	select media_relation.content_id, media.id, media.pathfile, media.path, media.titlefile, media.type, media.videothumb, media_relation.prev_type, media_relation.custom_content from media_relation left join media on media.id = media_relation.media_id where media_relation.content_id in (:product_id_0,:product_id_1,:product_id_2,:product_id_3,:product_id_4,:product_id_5,:product_id_6,:product_id_7,:product_id_8) and media_relation.content_type=:content_type order by media_relation.content_id asc, media_relation.orderx asc Params: {"product_id_0":654,"product_id_1":2737,"product_id_2":1886,"product_id_3":4265,"product_id_4":3041,"product_id_5":3083,"product_id_6":840,"product_id_7":3416,"product_id_8":2782,"content_type":"3"}
19	ok	3.98 ms	prepared.select	`select media_id, template_id, pathfile, path from thumbs where media_id in (:media_id_0,:media_id_1,:media_id_2,:media_id_3,:media_id_4,:media_id_5,:media_id_6,:media_id_7,:media_id_8,:media_id_9,:media_id_10,:media_id_11,:media_id_12,:media_id_13,:media_id_14)` Params: {"media_id_0":990,"media_id_1":1265,"media_id_2":1127,"media_id_3":1121,"media_id_4":1120,"media_id_5":2770,"media_id_6":2788,"media_id_7":4137,"media_id_8":4205,"media_id_9":4465,"media_id_10":4507,"media_id_11":4881,"media_id_12":6156,"media_id_13":6135,"media_id_14":6157}
20	ok	3.23 ms	prepared.select	`select prodid, count(*) as comment_count, coalesce(sum(vote),0) as votesum from comments where agree=:agree and prodid in (:comment_product_id_0,:comment_product_id_1,:comment_product_id_2,:comment_product_id_3,:comment_product_id_4,:comment_product_id_5,:comment_product_id_6,:comment_product_id_7,:comment_product_id_8) group by prodid` Params: {"comment_product_id_0":654,"comment_product_id_1":2737,"comment_product_id_2":1886,"comment_product_id_3":4265,"comment_product_id_4":3041,"comment_product_id_5":3083,"comment_product_id_6":840,"comment_product_id_7":3416,"comment_product_id_8":2782,"agree":"1"}
21	ok	2.54 ms	prepared.select	select product_attribute_sku.*, attribute_items.id, attribute_items.title, attribute_items.customurl, attribute_items.queue, attribute_items.color, attribute_groups.id as gid, attribute_groups.title as gtitle, attribute_groups.customurl as gcustomurl, attribute_groups.type, attribute_groups.queue as gqueue from product_attribute_sku left join attribute_items on attribute_items.id = product_attribute_sku.attribute_id left join attribute_groups on attribute_items.parentgroupid = attribute_groups.id where product_attribute_sku.product_id=:product_id and attribute_items.langid=:language_id and attribute_groups.langid=:language_id and product_attribute_sku.stock>:minimum_stock order by attribute_groups.queue desc, attribute_items.queue desc Params: {"product_id":2782,"language_id":1,"minimum_stock":1}
22	ok	2.24 ms	prepared.execute	`update products set readx=readx+1 where id=:product_id` Params: {"product_id":2782}

Mutlu Ayıcık

Seni Seviyorum Mini Pankart

Başarılar Dilerim

Özür Dilerim Pankart

Kırmızı Gül

Beyaz Gül

Minik Maskot Ayıcık

İyi ki Doğdun Mini Pankart

ÜRÜN DETAYLARI

Sevgilime Beyaz Gerbera

Papatyaların Gül Buketi

Frezya Sarı Dokunuşları

Asaletin Pandorası

Aşkın Çikolata Dokunuşu

Çikolata ve Gül Efsanesi

Hoşgeldin Güzel Bebek

Ayıcıkla Çiçek Sevinci