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