Yılbaşı

2 ürün

0-1000 TL 1000-2000 TL 2000+ TL Temizle

Aynı Gün Teslimat

Yılbaşı Orkidesinin Tadı

2.096,00 TL

Aynı Gün Teslimat

Mor Orkdidenin Lezzeti

2.096,00 TL

Yılbaşı

GET /yilbasi?fiyat=2000-20000 Time: 153.14 ms Memory: 4 MB SQL: 18 / 102.88 ms Slowest: 31.05 ms Errors: 0 Env: prod

Request
GET /yilbasi?fiyat=2000-20000
IP: 216.73.217.106

Runtime
153.14 ms
4 MB peak

Database
18 queries
0 failed

Mode
test: off
env: prod

PHP Errors

No PHP errors recorded.

SQL Queries

1	ok	5.97 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.06 ms	prepared.select	`select * from settings` Params: []
3	ok	10.4 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":"yilbasi","content_type":"1","empty_seo_product_category":"","seo_product_category":"","content_type_order":"1","empty_seo_product_category_order":""}
4	ok	3.22 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":"yilbasi","category_active":"1","category_language_id":1,"category_slug":"yilbasi","category_product_group":"0"}
5	ok	2.34 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	3.19 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.82 ms	prepared.select	`select * from il order by ilad asc, queue desc` Params: []
8	ok	1.97 ms	prepared.select	`select id, groupid, parentid, customurl, title, content, metatitle, metadescription, 301move from categoriesproduct where active=:active and langid=:language_id and customurl=:custom_url limit 1` Params: {"active":"1","language_id":1,"custom_url":"yilbasi"}
9	ok	1.8 ms	prepared.select	`select catid from order_products where catid=:category_id limit 1` Params: {"category_id":84}
10	ok	31.05 ms	prepared.select	select products.id, products.title, products.groupid, products.price, products.price2, products.kdvdahil, products.kdv, products.customurl, products.sendtype, categoryproduct.categorygroupid from categoriesproduct inner join categoryproduct on categoryproduct.categorygroupid = categoriesproduct.groupid inner join products on products.groupid = categoryproduct.productgroupid where (categoriesproduct.parentid=:category_id or categoriesproduct.id=:category_id) and categoriesproduct.productgroup=:product_group and categoriesproduct.active=:category_active and products.publish=:publish and products.isaddprod=:is_add_product and products.langid=:language_id 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 ) and products.seller_id=:site_... Params: {"category_id":84,"product_group":"0","category_active":"1","publish":"1","is_add_product":"0","language_id":1,"site_seller_id":"0","min_price":2000,"max_price":20000}
11	ok	23.99 ms	prepared.select	select count(*) as total from ( select products.groupid from categoriesproduct inner join categoryproduct on categoryproduct.categorygroupid = categoriesproduct.groupid inner join products on products.groupid = categoryproduct.productgroupid where (categoriesproduct.parentid=:category_id or categoriesproduct.id=:category_id) and categoriesproduct.productgroup=:product_group and categoriesproduct.active=:category_active and products.publish=:publish and products.isaddprod=:is_add_product and products.langid=:language_id 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 ) and products.seller_id=:site_seller_id and IFNULL(products.price2,products.price) >= :min_price and IFNULL(products.price2,products.price) <= :max_price group by pr... Params: {"category_id":84,"product_group":"0","category_active":"1","publish":"1","is_add_product":"0","language_id":1,"site_seller_id":"0","min_price":2000,"max_price":20000}
12	ok	2.18 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) and media_relation.content_type=:content_type order by media_relation.content_id asc, media_relation.orderx asc` Params: {"product_id_0":3828,"product_id_1":3842,"content_type":"3"}
13	ok	1.92 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)` Params: {"media_id_0":5483,"media_id_1":5482,"media_id_2":5490,"media_id_3":5497}
14	ok	3.1 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) group by prodid` Params: {"comment_product_id_0":3828,"comment_product_id_1":3842,"agree":"1"}
15	ok	2.19 ms	prepared.select	`select * from home_page_products where categorygroupid=:category_group_id order by orderx asc` Params: {"category_group_id":"pGB8kukp9vWSUp3QjryEXJGy9YAru4AJe25707"}
16	ok	1.77 ms	prepared.select	`select id, titlefile, pathfile, path, type, videothumb, created_at from media where id=:media_id limit 1` Params: {"media_id":7264}
17	ok	1.82 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":78}
18	ok	2.09 ms	prepared.select	`select media.pathfile as media_pathfile, media.path as media_path, media_relation.custom_content as custom_content from media_relation left join media on media_relation.media_id = media.id where media_relation.content_type=:content_type and media_relation.content_id=:category_id and media_relation.prev_type=:prev_type limit 1` Params: {"content_type":"4","category_id":84,"prev_type":"2"}

Application Logs

No application logs recorded.

Marks

6.94 ms - bootstrap.runtime_configured

[]