Çiçek Sepeti

0 ürün

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

Çiçek Sepeti

GET /cicek-sepeti?fiyat=1000-2000 Time: 36.59 ms Memory: 2 MB SQL: 14 / 16.24 ms Slowest: 2.31 ms Errors: 0 Env: prod

Request
GET /cicek-sepeti?fiyat=1000-2000
IP: 216.73.217.106

Runtime
36.59 ms
2 MB peak

Database
14 queries
0 failed

Mode
test: off
env: prod

PHP Errors

No PHP errors recorded.

SQL Queries

1	ok	2.31 ms	prepared.select	`select id, langname, shortname, protection from language where aktif=:active order by protection desc, id asc` Params: {"active":"1"}
2	ok	0.95 ms	prepared.select	`select * from settings` Params: []
3	ok	1.07 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":"cicek-sepeti","content_type":"1","empty_seo_product_category":"","seo_product_category":"","content_type_order":"1","empty_seo_product_category_order":""}
4	ok	1.77 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":"cicek-sepeti","category_active":"1","category_language_id":1,"category_slug":"cicek-sepeti","category_product_group":"0"}
5	ok	1.02 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	0.98 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	0.8 ms	prepared.select	`select * from il order by ilad asc, queue desc` Params: []
8	ok	1.01 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":"cicek-sepeti"}
9	ok	0.68 ms	prepared.select	`select catid from order_products where catid=:category_id limit 1` Params: {"category_id":37}
10	ok	1.77 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":37,"product_group":"0","category_active":"1","publish":"1","is_add_product":"0","language_id":1,"site_seller_id":"0","min_price":1000,"max_price":2000}
11	ok	1.45 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":37,"product_group":"0","category_active":"1","publish":"1","is_add_product":"0","language_id":1,"site_seller_id":"0","min_price":1000,"max_price":2000}
12	ok	0.72 ms	prepared.select	`select * from home_page_products where categorygroupid=:category_group_id order by orderx asc` Params: {"category_group_id":"Y6N9u7ze64kGZQEBL5GFvZNM8SN8zLy9P77720"}
13	ok	0.8 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}
14	ok	0.91 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":37,"prev_type":"2"}

Application Logs

No application logs recorded.

Marks

2.73 ms - bootstrap.runtime_configured

[]