Discrimination Against Women Essay

Submitted By Kartieya
Words: 1121
Pages: 5

Time Stamp Method for HomePage_SearchKeyword

Time Stamp Method for HomePage_SearchPid sss Time Stamp Method for HomePage

Time Stamp Method for TopNavigation

Time Stamp Method for LeftNavigation_NoProducts

Time Stamp Method for ChangeView

Time Stamp Method for UpdateItem

Time Stamp Method for ViewProductDetail_NoStock

Time Stamp For AddToBag_No_Stock
No getting Time Stamp

DB request For HomePage_SearchKeyword
No getting DB calls.

DB request For HomePage_SearchPid
No getting DB calls

DB request For HomePage
No getting DB calls

DB calls for TopNavigation
Total db calls for TopNavigation are = 27760
Top 10 db request that have taken maximum time DB Request | Execution | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | 231 | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | 189 | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | 185 | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | 169 | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | 141 | SELECT T1.ID,T1.CONTENT_TYPE FROM KLS_CONTENT_ITEM T1, DCS_FOLDER T2 LEFT OUTER JOIN KLS_FOLDER T3 ON T3.FOLDER_ID=T2.PARENT_FOLDER_ID WHERE T2.FOLDER_ID=T1.PARENT_FOLDER_ID AND ((T3.EVENT = ?) AND (T2.NAME = ?) AND (T1.START_DATE < ?) AND (T1.END_DATE > ?)) | 136 |

DB calls for LeftNavigation_NoProducts
Total db calls for LeftNavigation_NoProducts are = 29
Top 10 db request that have taken maximum time DB Request | Execution | SELECT T1.ID FROM KLS_PROD_RECOMMEND_CONF T1 WHERE (T1.SALE_EVENT_ID = ?) | 304 | SELECT T1.ID FROM KLS_PROD_RECOMMEND_CONF T1 WHERE (T1.SALE_EVENT_ID = ?) | 125 | SELECT T1.ID FROM…