三次典型的Http请求日志

一、请求css等静态资源

2017-03-13 11:00:16.336 [http-apr-80-exec-1] DEBUG o.s.w.servlet.DispatcherServlet - DispatcherServlet with name 'DispatcherServlet' processing GET request for [/bigData/css/bootstrap.min.css]
2017-03-13 11:00:16.336 [http-apr-80-exec-1] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Looking up handler method for path /css/bootstrap.min.css
2017-03-13 11:00:16.337 [http-apr-80-exec-1] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Did not find handler method for [/css/bootstrap.min.css]
2017-03-13 11:00:16.337 [http-apr-80-exec-1] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Looking up handler method for path /css/bootstrap.min.css
2017-03-13 11:00:16.337 [http-apr-80-exec-1] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Did not find handler method for [/css/bootstrap.min.css]
2017-03-13 11:00:16.337 [http-apr-80-exec-1] DEBUG o.s.w.s.h.SimpleUrlHandlerMapping - Matching patterns for request [/css/bootstrap.min.css] are [/css/**]
2017-03-13 11:00:16.337 [http-apr-80-exec-1] DEBUG o.s.w.s.h.SimpleUrlHandlerMapping - URI Template variables for request [/css/bootstrap.min.css] are {}
2017-03-13 11:00:16.337 [http-apr-80-exec-1] DEBUG o.s.w.s.h.SimpleUrlHandlerMapping - Mapping [/css/bootstrap.min.css] to HandlerExecutionChain with handler [ResourceHttpRequestHandler [locations=[ServletContext resource [/css/]], resolvers=[org.springframework.web.servlet.resource.PathResourceResolver@1b2c38bc]]] and 1 interceptor
2017-03-13 11:00:16.337 [http-apr-80-exec-1] DEBUG o.s.w.servlet.DispatcherServlet - Last-Modified value for [/bigData/css/bootstrap.min.css] is: -1
2017-03-13 11:00:16.340 [http-apr-80-exec-1] DEBUG o.s.w.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'DispatcherServlet': assuming HandlerAdapter completed request handling
2017-03-13 11:00:16.340 [http-apr-80-exec-1] DEBUG o.s.w.servlet.DispatcherServlet - Successfully completed request

二、请求html页面（通过Controller跳转）

2017-03-13 11:00:16.289 [http-apr-80-exec-6] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Returning cached instance of singleton bean 'environment'
2017-03-13 11:00:16.295 [http-apr-80-exec-6] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Returning cached instance of singleton bean 'environment'
2017-03-13 11:00:16.296 [http-apr-80-exec-6] DEBUG o.s.w.servlet.DispatcherServlet - DispatcherServlet with name 'DispatcherServlet' processing GET request for [/bigData/violationModel.html]
2017-03-13 11:00:16.296 [http-apr-80-exec-6] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Looking up handler method for path /violationModel.html
2017-03-13 11:00:16.296 [http-apr-80-exec-6] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Returning handler method [public java.lang.String com.fable.controller.IndexController.violationModel()]
2017-03-13 11:00:16.296 [http-apr-80-exec-6] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Returning cached instance of singleton bean 'indexController'
2017-03-13 11:00:16.296 [http-apr-80-exec-6] DEBUG o.s.w.servlet.DispatcherServlet - Last-Modified value for [/bigData/violationModel.html] is: -1
2017-03-13 11:00:16.297 [http-apr-80-exec-6] DEBUG o.s.w.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.JstlView: name 'violationModel'; URL [/WEB-INF/pages/violationModel.html]] in DispatcherServlet with name 'DispatcherServlet'
2017-03-13 11:00:16.297 [http-apr-80-exec-6] DEBUG o.s.web.servlet.view.JstlView - Forwarding to resource [/WEB-INF/pages/violationModel.html] in InternalResourceView 'violationModel'
2017-03-13 11:00:16.297 [http-apr-80-exec-6] DEBUG o.s.w.servlet.DispatcherServlet - DispatcherServlet with name 'DispatcherServlet' processing GET request for [/bigData/WEB-INF/pages/violationModel.html]
2017-03-13 11:00:16.297 [http-apr-80-exec-6] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Looking up handler method for path /WEB-INF/pages/violationModel.html
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Did not find handler method for [/WEB-INF/pages/violationModel.html]
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Looking up handler method for path /WEB-INF/pages/violationModel.html
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Did not find handler method for [/WEB-INF/pages/violationModel.html]
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.s.h.SimpleUrlHandlerMapping - Matching patterns for request [/WEB-INF/pages/violationModel.html] are [/**]
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.s.h.SimpleUrlHandlerMapping - URI Template variables for request [/WEB-INF/pages/violationModel.html] are {}
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.s.h.SimpleUrlHandlerMapping - Mapping [/WEB-INF/pages/violationModel.html] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.DefaultServletHttpRequestHandler@369cc1f5] and 1 interceptor
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.servlet.DispatcherServlet - Last-Modified value for [/bigData/WEB-INF/pages/violationModel.html] is: -1
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'DispatcherServlet': assuming HandlerAdapter completed request handling
2017-03-13 11:00:16.298 [http-apr-80-exec-6] DEBUG o.s.w.servlet.DispatcherServlet - Successfully completed request

三、ajax请求（有数据库交互）

2017-03-13 11:00:16.806 [http-apr-80-exec-10] DEBUG o.s.w.servlet.DispatcherServlet - DispatcherServlet with name 'DispatcherServlet' processing GET request for [/bigData/ClientIllegalEvent/eventHistogram]
2017-03-13 11:00:16.807 [http-apr-80-exec-10] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Looking up handler method for path /ClientIllegalEvent/eventHistogram
2017-03-13 11:00:16.807 [http-apr-80-exec-10] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Returning handler method [java.util.Map<java.lang.String, java.util.List<com.fable.common.LabelValuePair<java.lang.String, java.lang.Integer>>> com.fable.controller.ClientIllegalEventController.getEventHistogram()]
2017-03-13 11:00:16.807 [http-apr-80-exec-10] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Returning cached instance of singleton bean 'clientIllegalEventController'
2017-03-13 11:00:16.807 [http-apr-80-exec-10] DEBUG o.s.w.servlet.DispatcherServlet - Last-Modified value for [/bigData/ClientIllegalEvent/eventHistogram] is: -1
2017-03-13 11:00:16.808 [http-apr-80-exec-10] DEBUG o.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
2017-03-13 11:00:16.808 [http-apr-80-exec-10] DEBUG o.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b521c34]
2017-03-13 11:00:16.808 [http-apr-80-exec-10] DEBUG o.s.j.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
2017-03-13 11:00:16.809 [http-apr-80-exec-10] DEBUG log4jdbc.debug - driver name is MySQL Connector Java
2017-03-13 11:00:16.809 [http-apr-80-exec-10] DEBUG o.s.j.datasource.DataSourceUtils - Registering transaction synchronization for JDBC Connection
2017-03-13 11:00:16.809 [http-apr-80-exec-10] DEBUG o.m.s.t.SpringManagedTransaction - JDBC Connection [net.sf.log4jdbc.ConnectionSpy@24828256] will be managed by Spring
2017-03-13 11:00:16.809 [http-apr-80-exec-10] DEBUG c.f.m.C.selectLasted5DayEvents - ==>  Preparing: SELECT `CountTime` label,GROUP_CONCAT(IllegalCount ORDER BY IllegalCount DESC) value FROM ( SELECT a.CountTime,a.IllegalCount FROM ClientIllegalEventSortTopN a WHERE (a.`CountTime` BETWEEN '2017-03-08' AND '2017-03-12') AND 5>=( SELECT COUNT(*) FROM ClientIllegalEventSortTopN b WHERE a.CountTime=b.CountTime AND a.IllegalCount<=b.IllegalCount)) tmp GROUP BY `CountTime` ORDER BY CountTime 
2017-03-13 11:00:16.810 [http-apr-80-exec-10] DEBUG c.f.m.C.selectLasted5DayEvents - ==> Parameters: 
2017-03-13 11:00:16.810 [http-apr-80-exec-10] INFO  jdbc.sqlonly - 
SELECT `CountTime` label,GROUP_CONCAT(IllegalCount ORDER BY IllegalCount DESC) value
        FROM (  SELECT a.CountTime,a.IllegalCount
                FROM ClientIllegalEventSortTopN a
                WHERE (a.`CountTime` BETWEEN '2017-03-08' AND '2017-03-12')
                    AND 5>=(
                        SELECT COUNT(*)
                        FROM ClientIllegalEventSortTopN b
                        WHERE a.CountTime=b.CountTime AND a.IllegalCount<=b.IllegalCount)) tmp
        GROUP BY `CountTime`
        ORDER BY CountTime
2017-03-13 11:00:16.820 [http-apr-80-exec-10] DEBUG c.f.m.C.selectLasted5DayEvents - <==      Total: 5
2017-03-13 11:00:16.820 [http-apr-80-exec-10] DEBUG o.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b521c34]
2017-03-13 11:00:16.821 [http-apr-80-exec-10] DEBUG o.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b521c34]
2017-03-13 11:00:16.821 [http-apr-80-exec-10] DEBUG o.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b521c34]
2017-03-13 11:00:16.821 [http-apr-80-exec-10] DEBUG o.s.j.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
2017-03-13 11:00:16.823 [http-apr-80-exec-10] DEBUG o.s.w.s.m.m.a.RequestResponseBodyMethodProcessor - Written [{2017-03-08=[com.fable.common.LabelValuePair@70786633, com.fable.common.LabelValuePair@4f0ab7b6, com.fable.common.LabelValuePair@5c40e537, com.fable.common.LabelValuePair@7bce8fd2, com.fable.common.LabelValuePair@48342766], 2017-03-09=[com.fable.common.LabelValuePair@52199ed1, com.fable.common.LabelValuePair@9abb0f8, com.fable.common.LabelValuePair@6941e00, com.fable.common.LabelValuePair@6f7216a3, com.fable.common.LabelValuePair@7183e28a], 2017-03-10=[com.fable.common.LabelValuePair@25fbb032, com.fable.common.LabelValuePair@3b9ce93, com.fable.common.LabelValuePair@7c810749, com.fable.common.LabelValuePair@12783de1, com.fable.common.LabelValuePair@6afa75bc], 2017-03-11=[com.fable.common.LabelValuePair@27fae326, com.fable.common.LabelValuePair@53b503df, com.fable.common.LabelValuePair@71ab7d, com.fable.common.LabelValuePair@399f695a, com.fable.common.LabelValuePair@490c4e9c], 2017-03-12=[com.fable.common.LabelValuePair@325c0799, com.fable.common.LabelValuePair@3ffb68ec, com.fable.common.LabelValuePair@7d6c13f0, com.fable.common.LabelValuePair@56bfda6f, com.fable.common.LabelValuePair@40d7fee]}] as "application/json;charset=UTF-8" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@5e8694bb]
2017-03-13 11:00:16.823 [http-apr-80-exec-10] DEBUG o.s.w.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'DispatcherServlet': assuming HandlerAdapter completed request handling
2017-03-13 11:00:16.823 [http-apr-80-exec-10] DEBUG o.s.w.servlet.DispatcherServlet - Successfully completed request
2017-03-13 11:01:01.798 [HikariPool-1 housekeeper] DEBUG c.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)