My tail -n 100 /var/log/mysql/slow.log


    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33113  Schema: cphulkd  QC_hit: No
    # Query_time: 0.003485  Lock_time: 0.000067  Rows_sent: 285  Rows_examined: 2835
    SET timestamp=1451849801;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:36:43
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33114  Schema: cphulkd  QC_hit: No
    # Query_time: 0.006589  Lock_time: 0.000073  Rows_sent: 1220  Rows_examined: 3771
    SET timestamp=1451849803;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33115  Schema: cphulkd  QC_hit: No
    # Query_time: 0.004768  Lock_time: 0.000092  Rows_sent: 286  Rows_examined: 2838
    SET timestamp=1451849803;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:36:46
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33116  Schema: cphulkd  QC_hit: No
    # Query_time: 0.004408  Lock_time: 0.000070  Rows_sent: 287  Rows_examined: 2840
    SET timestamp=1451849806;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:36:48
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33117  Schema: cphulkd  QC_hit: No
    # Query_time: 0.004475  Lock_time: 0.000059  Rows_sent: 1221  Rows_examined: 3775
    SET timestamp=1451849808;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:36:49
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33118  Schema: cphulkd  QC_hit: No
    # Query_time: 0.005608  Lock_time: 0.000085  Rows_sent: 288  Rows_examined: 2843
    SET timestamp=1451849809;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:36:52
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33119  Schema: cphulkd  QC_hit: No
    # Query_time: 0.006510  Lock_time: 0.000069  Rows_sent: 1222  Rows_examined: 3778
    SET timestamp=1451849812;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:36:56
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33120  Schema: cphulkd  QC_hit: No
    # Query_time: 0.002198  Lock_time: 0.000058  Rows_sent: 289  Rows_examined: 2846
    SET timestamp=1451849816;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:36:57
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33121  Schema: cphulkd  QC_hit: No
    # Query_time: 0.004659  Lock_time: 0.000071  Rows_sent: 1223  Rows_examined: 3781
    SET timestamp=1451849817;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:36:59
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33122  Schema: cphulkd  QC_hit: No
    # Query_time: 0.004016  Lock_time: 0.000068  Rows_sent: 290  Rows_examined: 2849
    SET timestamp=1451849819;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:37:01
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33123  Schema: cphulkd  QC_hit: No
    # Query_time: 0.004466  Lock_time: 0.000108  Rows_sent: 291  Rows_examined: 2851
    SET timestamp=1451849821;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:37:02
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33124  Schema: cphulkd  QC_hit: No
    # Query_time: 0.008115  Lock_time: 0.000072  Rows_sent: 1224  Rows_examined: 3785
    SET timestamp=1451849822;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:37:05
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33125  Schema: cphulkd  QC_hit: No
    # Query_time: 0.004939  Lock_time: 0.000081  Rows_sent: 292  Rows_examined: 2854
    SET timestamp=1451849825;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:37:07
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33126  Schema: cphulkd  QC_hit: No
    # Query_time: 0.006385  Lock_time: 0.000074  Rows_sent: 1225  Rows_examined: 3788
    SET timestamp=1451849827;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:37:08
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33127  Schema: cphulkd  QC_hit: No
    # Query_time: 0.002580  Lock_time: 0.000055  Rows_sent: 293  Rows_examined: 2857
    SET timestamp=1451849828;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:37:11
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33128  Schema: cphulkd  QC_hit: No
    # Query_time: 0.004067  Lock_time: 0.000073  Rows_sent: 294  Rows_examined: 2859
    SET timestamp=1451849831;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��ΪΠ\\' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;
    # Time: 160103 21:37:12
    # User@Host: cphulkd[cphulkd] @ localhost []
    # Thread_id: 33129  Schema: cphulkd  QC_hit: No
    # Query_time: 0.005923  Lock_time: 0.000069  Rows_sent: 1226  Rows_examined: 3792
    SET timestamp=1451849832;
    SELECT USER,SERVICE,TYPE,TIMESTAMPDIFF(SECOND, '1970-01-01', LOGINTIME) as LOGINTIME,TIMESTAMPDIFF(SECOND, '1970-01-01', EXPTIME) as EXPTIME,AUTHTOKEN_HASH from login_track where EXPTIME > NOW() and ADDRESS='\0\0\0\0\0\0\0\0\0\0��_4δL' ORDER BY login_track.EXPTIME DESC /*get_unexpired_logins_by_address*/;