# 7.5s user time, 50ms system time, 30.34M rss, 183.84M vsz
# Current date: Wed Sep 21 10:42:55 2016
# Hostname: a1-dba-test-242-13.hz
# Files: /tmp/mysql.log
# Overall: 43.49k total, 724 unique, 0 QPS, 0x concurrency _______________
# Time range: 2009-21-16 10:41:48 to 10:42:39
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            69s       0      3s     2ms     1ms    38ms    89us
# Query size         6.59M       6  63.93k  158.96  685.39  734.89   15.25

# Profile
# Rank Query ID           Response time Calls R/Call V/M   Item
# ==== ================== ============= ===== ====== ===== ===============
#    1 0xDCF45E9122385173 33.7369 49.2%   183 0.1844  1.14 SELECT pc_biz_cmd
#    2 0x66B0846276AC815B  7.7713 11.3%     5 1.5543  0.01 SELECT pash_task
#    3 0x072188590E5A800F  5.2590  7.7%    55 0.0956  0.01 UPDATE user_device_binding_?
#    4 0x9DEF42AD5AB7F619  3.8926  5.7%   309 0.0126  1.09 SELECT monitor_warn_alarm
#    5 0x373C1389A3A714B5  2.7793  4.1%   290 0.0096  0.18 SELECT monitor_warn_alarm
#    6 0x4BD422D2670A7D86  2.3258  3.4%  1026 0.0023  0.00 SELECT act_schedule_record
#    7 0x3AEAAD0E15D725B5  1.0602  1.5% 13792 0.0001  0.00 SET
#    8 0x6373CFBF65A5D262  0.7944  1.2%     1 0.7944  0.00 SELECT pro_send_message
#    9 0x813031B8BBC3B329  0.6609  1.0%  6796 0.0001  0.00 COMMIT
#   10 0xED524610C9A69722  0.5176  0.8%  1115 0.0005  0.00 SELECT webapi_resolv
#   11 0x598768759E6A3081  0.5171  0.8%    32 0.0162  0.00 SELECT dc_doctor
#   12 0xD0BD2F56C5769BDA  0.4730  0.7%    51 0.0093  0.00 SELECT act_task
#   13 0x8C581E58F159ECF0  0.4601  0.7%     1 0.4601  0.00 SELECT hp_session_user_course_phase
#   14 0x18EC0094FCA82DC0  0.4547  0.7%  4965 0.0001  0.00 SELECT
#   15 0xA3FC98ADD72B21BE  0.4403  0.6%   820 0.0005  0.00 SELECT pro_prize
#   16 0x8F1936056D7E6840  0.3906  0.6%   200 0.0020  0.00
#   17 0x388CF7AB93322FB7  0.3478  0.5%   688 0.0005  0.00 SELECT hp_course_phase
#   18 0x7F8F3903B256C9CD  0.2882  0.4%   508 0.0006  0.00 SELECT hp_session
#   19 0x943798A09019B333  0.2164  0.3%  2948 0.0001  0.00 SHOW WARNINGS
#   20 0xDA326394FC0842CC  0.1726  0.3%     1 0.1726  0.00 SELECT diagnose_dept_tag diagnose_suspect_tag
# MISC 0xMISC              6.0305  8.8%  9707 0.0006   0.0 <704 ITEMS>

# Query 1: 0 QPS, 0x concurrency, ID 0xDCF45E9122385173 at byte 4562893 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 1.14
# Time range: 2009-21-16 10:41:49 to 10:42:38
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     183
# Exec time     49     34s   251us      3s   184ms   526ms   458ms    20ms
# Query size     1  90.89k     502     516  508.57  511.45       7  487.09
# String:
# Hosts        10.128.241.156:59241 (54/29%)... 6 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us  ###################
#   1ms  ################################################################
#  10ms  #############################
# 100ms  ###########################################################
#    1s  #######
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'pc_biz_cmd'\G
#    SHOW CREATE TABLE `pc_biz_cmd`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT

		id, biz_id, biz_type, server_ip, fail_reason, env_tag,
		is_doing, status, retry_times, max_retry_times, next_exe_time, enable_start_date,
		enable_end_date, gmt_create, gmt_modify,account_no

		FROM pc_biz_cmd
		WHERE

		        (STATUS = 'I' or STATUS = 'W') AND IS_DOING = 'n' AND
		        NEXT_EXE_TIME <= now()
		        and enable_start_date <= now()
		        and enable_end_date > now()
		        and biz_type = 'EXPIRED'
		        and env_tag = 'test'

		limit 1000\G

# Query 2: 0 QPS, 0x concurrency, ID 0x66B0846276AC815B at byte 7105914 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2009-21-16 10:42:09 to 10:42:31
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0       5
# Exec time     11      8s      1s      2s      2s      2s   143ms      1s
# Query size     0     773     154     155  154.60  151.03       0  151.03
# String:
# Hosts        10.128.176.229:62217 (3/60%)... 1 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms
#    1s  ################################################################
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'pash_task'\G
#    SHOW CREATE TABLE `pash_task`\G
# EXPLAIN /*!50100 PARTITIONS*/
select count(*) from pash_task



     WHERE (  params in
                  (
                    'alicebot-hp_test'
                  ) )\G

# Query 3: 0 QPS, 0x concurrency, ID 0x072188590E5A800F at byte 1622373 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2009-21-16 10:41:49 to 10:42:11
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0      55
# Exec time      7      5s    38ms   135ms    96ms   122ms    26ms   105ms
# Query size     0  11.55k     215     215     215     215       0     215
# String:
# Hosts        10.128.241.164:62456 (26/47%)... 3 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms  #################################
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'user_device_binding_0407'\G
#    SHOW CREATE TABLE `user_device_binding_0407`\G
update user_device_binding_0407
         SET user_id = 1126140407,

        domain_id = 1000,

        active = 1
        where
        user_id = 1126140407

         and domain_id = 1000\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select  user_id = 1126140407,

        domain_id = 1000,

        active = 1 from user_device_binding_0407 where
        user_id = 1126140407

         and domain_id = 1000\G

# Query 4: 0 QPS, 0x concurrency, ID 0x9DEF42AD5AB7F619 at byte 10792338 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 1.09
# Time range: 2009-21-16 10:41:50 to 10:42:38
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     309
# Exec time      5      4s       0      1s    13ms     2ms   117ms   568us
# Query size     2 193.92k     634     651  642.65  621.67       0  621.67
# String:
# Hosts        10.128.242.174:35953 (33/10%)... 24 more
# Users        unknown_us... (293/94%), pajk_monit... (16/5%)
# Query_time distribution
#   1us
#  10us
# 100us  ################################################################
#   1ms  #######
#  10ms  #
# 100ms
#    1s  #
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'monitor_warn_alarm'\G
#    SHOW CREATE TABLE `monitor_warn_alarm`\G
# EXPLAIN /*!50100 PARTITIONS*/
select

    id,parent_id,app_id,server_id,plugin_name,item_id,item_name, alarm_id,alarm_level, alarm_times,warn_times, alarm_content,alarm_rules,send_status,warn_alarm_status,
    not_send_reason,occur_time,retrieve_time,create_time, update_time, collect_message

		from monitor_warn_alarm
		where 1=1

			and app_id = 151



			and server_id = 234



			and plugin_name = 'Dubbo_Provider'


			and item_id = 1611



			and alarm_id = 1315




			and warn_alarm_status = 'occurred'





			and create_time>DATE_SUB(CURDATE(), INTERVAL 1 WEEK)


		order by create_time desc\G

# Query 5: 0 QPS, 0x concurrency, ID 0x373C1389A3A714B5 at byte 2477307 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.18
# Time range: 2009-21-16 10:41:49 to 10:42:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     290
# Exec time      4      3s   208us   428ms    10ms    22ms    41ms     2ms
# Query size     2 159.67k     562     565  563.80  563.87    1.50  537.02
# String:
# Hosts        10.128.176.176:33052 (38/13%)... 23 more
# Users        unknown_us... (289/99%), pajk_monit... (1/0%)
# Query_time distribution
#   1us
#  10us
# 100us  ##############################################
#   1ms  ################################################################
#  10ms  ############
# 100ms  #
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'monitor_warn_alarm'\G
#    SHOW CREATE TABLE `monitor_warn_alarm`\G
# EXPLAIN /*!50100 PARTITIONS*/
select

    id,parent_id,app_id,server_id,plugin_name,item_id,item_name, alarm_id,alarm_level, alarm_times,warn_times, alarm_content,alarm_rules,send_status,warn_alarm_status,
    not_send_reason,occur_time,retrieve_time,create_time, update_time, collect_message

		from monitor_warn_alarm
		where 1=1

			and app_id = 151



			and server_id = 234



			and plugin_name = 'Runtime'



			and item_name = 'health_check'





			and warn_alarm_status = 'occurred'






		order by create_time desc\G

# Query 6: 0 QPS, 0x concurrency, ID 0x4BD422D2670A7D86 at byte 3147070 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:42:00 to 10:42:19
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          2    1026
# Exec time      3      2s       0     6ms     2ms     3ms   771us     2ms
# Query size     1  69.32k      67      70   69.18   69.19    1.29   65.89
# String:
# Hosts        10.129.184.48:53846 (952/92%)... 2 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us  #
#   1ms  ################################################################
#  10ms
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'act_schedule_record'\G
#    SHOW CREATE TABLE `act_schedule_record`\G
# EXPLAIN /*!50100 PARTITIONS*/
select IFNULL(count(*),0) from act_schedule_record where task_id=15315\G

# Query 7: 0 QPS, 0x concurrency, ID 0x3AEAAD0E15D725B5 at byte 3264016 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:41:48 to 10:42:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         31   13792
# Exec time      1      1s       0     2ms    76us   125us    60us    69us
# Query size     3 215.50k      16      16      16      16       0      16
# String:
# Hosts        10.128.176.175:60797 (718/5%)... 321 more
# Users        unknown_us... (13045/94%), pash (602/4%)... 9 more
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ###############
#   1ms  #
#  10ms
# 100ms
#    1s
#  10s+
SET autocommit=1\G

# Query 8: 0 QPS, 0x concurrency, ID 0x6373CFBF65A5D262 at byte 2210073 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2009-21-16 10:42:00
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0       1
# Exec time      1   794ms   794ms   794ms   794ms   794ms       0   794ms
# Query size     0     238     238     238     238     238       0     238
# String:
# Hosts        10.129.184.46:52155
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'pro_send_message'\G
#    SHOW CREATE TABLE `pro_send_message`\G
# EXPLAIN /*!50100 PARTITIONS*/
select
    id, user_id, mobile, msg, status, gmt_created, gmt_modified,code

      from  pro_send_message

         WHERE  status in
              (
                10
              )


            LIMIT 0,300\G

# Query 9: 0 QPS, 0x concurrency, ID 0x813031B8BBC3B329 at byte 10949123 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:41:48 to 10:42:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         15    6796
# Exec time      0   661ms       0     3ms    97us   287us   155us    57us
# Query size     0  39.82k       6       6       6       6       0       6
# String:
# Hosts        10.128.176.175:60797 (364/5%)... 291 more
# Users        unknown_us... (6551/96%), pash (199/2%)... 2 more
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ###########
#   1ms  #
#  10ms
# 100ms
#    1s
#  10s+
commit\G

# Query 10: 0 QPS, 0x concurrency, ID 0xED524610C9A69722 at byte 4187839 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:42:01 to 10:42:04
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          2    1115
# Exec time      0   518ms       0     2ms   464us   657us   143us   467us
# Query size     8 574.97k     516     541  528.04  511.45    3.39  511.45
# String:
# Hosts        10.128.176.201:33555 (284/25%)... 3 more
# Users        httpdns
# Query_time distribution
#   1us
#  10us
# 100us  ################################################################
#   1ms  #
#  10ms
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'webapi_resolv'\G
#    SHOW CREATE TABLE `webapi_resolv`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `webapi_resolv`.`id`, `webapi_resolv`.`create_time`, `webapi_resolv`.`create_user`, `webapi_resolv`.`change_time`, `webapi_resolv`.`host`, `webapi_resolv`.`match_method`, `webapi_resolv`.`match_key`, `webapi_resolv`.`ips`, `webapi_resolv`.`ttl`, `webapi_resolv`.`is_alive`, `webapi_resolv`.`status`, `webapi_resolv`.`add_update`, `webapi_resolv`.`del_update` FROM `webapi_resolv` WHERE (`webapi_resolv`.`match_method` = 'uid' AND `webapi_resolv`.`host` = 'www.baidu.com' AND NOT (`webapi_resolv`.`del_update` = 1))\G

# Query 11: 0 QPS, 0x concurrency, ID 0x598768759E6A3081 at byte 4720681 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:41:52 to 10:42:38
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0      32
# Exec time      0   517ms     8ms    32ms    16ms    20ms     5ms    16ms
# Query size     0   3.78k     121     121     121     121       0     121
# String:
# Hosts        10.128.242.181:48186 (14/43%)... 2 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  #########
#  10ms  ################################################################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'dc_doctor'\G
#    SHOW CREATE TABLE `dc_doctor`\G
# EXPLAIN /*!50100 PARTITIONS*/
select user_id from dc_doctor where status='A' and doctor_source=0 and cap_switch_bits<>0 and cap_switch_bits is not null\G

# Query 12: 0 QPS, 0x concurrency, ID 0xD0BD2F56C5769BDA at byte 8453777 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:42:00 to 10:42:18
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0      51
# Exec time      0   473ms   977us    17ms     9ms    15ms     4ms    10ms
# Query size     0  35.16k     705     707  705.96  685.39       0  685.39
# String:
# Hosts        10.129.184.48:53846 (49/96%)... 1 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ########################################################
#  10ms  ################################################################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'act_task'\G
#    SHOW CREATE TABLE `act_task`\G
# EXPLAIN /*!50100 PARTITIONS*/
select

       t.id,t.name,t.summary,t.description, t.detail, t.domain_id,t.tag,t.type,t.remind_ahead,t.remind,t.status,t.version,t.recommend,t.photo_url,t.repeat_mode,
       t.mon,t.tues,t.wednes,t.thurs,t.fri,t.satur,t.sun,t.date,t.time,t.remind_time,
       t.show_time_type,t.show_time,t.remind_title,t.remind_content,remind_type,conditions_type,t.gmt_created, t.gmt_modified,
       t.start_time, t.end_time

        from act_task t where t.domain_id=1000


            and t.status in
             (
                10
             )







            order by id desc


            LIMIT 1020,20\G

# Query 13: 0 QPS, 0x concurrency, ID 0x8C581E58F159ECF0 at byte 5591759 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2009-21-16 10:42:09
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0       1
# Exec time      0   460ms   460ms   460ms   460ms   460ms       0   460ms
# Query size     0     931     931     931     931     931       0     931
# String:
# Hosts        10.128.242.236:34522
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'hp_session_user_course_phase'\G
#    SHOW CREATE TABLE `hp_session_user_course_phase`\G
# EXPLAIN /*!50100 PARTITIONS*/
select sessionuse0_.id as id1_27_, sessionuse0_.attend_status as attend_s2_27_, sessionuse0_.coach_id as coach_id3_27_, sessionuse0_.course_id as course_i4_27_, sessionuse0_.course_phase_id as course_p5_27_, sessionuse0_.course_type as course_t6_27_, sessionuse0_.created_at as created_7_27_, sessionuse0_.end_at as end_at8_27_, sessionuse0_.plan_end_at as plan_end9_27_, sessionuse0_.plan_start_at as plan_st10_27_, sessionuse0_.remind_count as remind_11_27_, sessionuse0_.remind_status as remind_12_27_, sessionuse0_.session_id as session13_27_, sessionuse0_.start_at as start_a14_27_, sessionuse0_.tag as tag15_27_, sessionuse0_.tag_id as tag_id16_27_, sessionuse0_.updated_at as updated17_27_, sessionuse0_.user_id as user_id18_27_ from hp_session_user_course_phase sessionuse0_ where sessionuse0_.plan_start_at<='2016-09-21 00:00:00.238' and sessionuse0_.plan_end_at>='2016-09-21 00:00:00.238' and sessionuse0_.attend_status=0\G

# Query 14: 0 QPS, 0x concurrency, ID 0x18EC0094FCA82DC0 at byte 5353305 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:41:48 to 10:42:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         11    4965
# Exec time      0   455ms       0     1ms    91us   152us    69us    80us
# Query size     2 140.61k      29      29      29      29       0      29
# String:
# Hosts        10.128.176.175:60797 (385/7%)... 247 more
# Users        unknown_us... (4638/93%), pash (239/4%)... 3 more
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ##############################
#   1ms  #
#  10ms
# 100ms
#    1s
#  10s+
# EXPLAIN /*!50100 PARTITIONS*/
select @@session.tx_read_only\G

# Query 15: 0 QPS, 0x concurrency, ID 0xA3FC98ADD72B21BE at byte 1729859 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:42:00 to 10:42:06
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1     820
# Exec time      0   440ms       0     2ms   536us   799us   197us   515us
# Query size     5 388.77k     485     486  485.49  463.90       0  463.90
# String:
# Hosts        10.129.184.46:52034
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us  ################################################################
#   1ms  #
#  10ms
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'pro_prize'\G
#    SHOW CREATE TABLE `pro_prize`\G
# EXPLAIN /*!50100 PARTITIONS*/
select

    id, name, icon_url, worth, unit, total, used_num, description, level, day, credit, type, code, odds, random_range, activity_id, version, gmt_created, gmt_modified, share_img
    ,seller_id, store_id, sku_id, spu_id, batch_id

        from pro_prize
         WHERE  activity_id = 20



                and day = DATE('2016-01-04 12:03:00')
            order by activity_id, day, level

                LIMIT 0,20\G

# Query 16: 0 QPS, 0x concurrency, ID 0x8F1936056D7E6840 at byte 8793105 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:41:48 to 10:42:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     200
# Exec time      0   391ms   754us     4ms     2ms     3ms   613us     2ms
# Query size     2 181.25k     928     928     928     928       0     928
# String:
# Hosts        10.128.176.225:56858 (1/0%)... 199 more
# Users        pash
# Query_time distribution
#   1us
#  10us
# 100us  #########
#   1ms  ################################################################
#  10ms
# 100ms
#    1s
#  10s+
USE `pash`;
/* mysql-connector-java-5.1.31 ( Revision: alexander.soklakov@oracle.com-20140520065950-groqzzbvxprqdmnz ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect'\G

# Query 17: 0 QPS, 0x concurrency, ID 0x388CF7AB93322FB7 at byte 7176469 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:42:09 to 10:42:26
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1     688
# Exec time      0   348ms   169us     1ms   505us   761us   181us   490us
# Query size     4 290.92k     433     433     433     433       0     433
# String:
# Hosts        10.128.242.236:34562 (52/7%)... 19 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us  ################################################################
#   1ms  #
#  10ms
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'hp_course_phase'\G
#    SHOW CREATE TABLE `hp_course_phase`\G
# EXPLAIN /*!50100 PARTITIONS*/
select coursephas0_.id as id1_9_, coursephas0_.course_id as course_i2_9_, coursephas0_.created_at as created_3_9_, coursephas0_.description as descript4_9_, coursephas0_.name as name5_9_, coursephas0_.phase_order as phase_or6_9_, coursephas0_.question_id as question7_9_, coursephas0_.updated_at as updated_8_9_ from hp_course_phase coursephas0_ where coursephas0_.course_id=642 order by coursephas0_.phase_order, coursephas0_.id ASC\G

# Query 18: 0 QPS, 0x concurrency, ID 0x7F8F3903B256C9CD at byte 8377688 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:42:10 to 10:42:26
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1     508
# Exec time      0   288ms   212us     1ms   567us   839us   195us   568us
# Query size     7 523.54k   1.03k   1.03k   1.03k 1012.63       0 1012.63
# String:
# Hosts        10.128.242.236:34520 (37/7%)... 19 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us  ################################################################
#   1ms  #
#  10ms
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'hp_session'\G
#    SHOW CREATE TABLE `hp_session`\G
# EXPLAIN /*!50100 PARTITIONS*/
select session0_.id as id1_24_, session0_.attend_status as attend_s2_24_, session0_.bill_phase_id as bill_pha3_24_, session0_.bill_time as bill_tim4_24_, session0_.coach_id as coach_id5_24_, session0_.course_type as course_t6_24_, session0_.created_at as created_7_24_, session0_.end_at as end_at8_24_, session0_.order_status as order_st9_24_, session0_.phase_plan_end_at as phase_p10_24_, session0_.phase_plan_start_at as phase_p11_24_, session0_.plan_end_at as plan_en12_24_, session0_.plan_start_at as plan_st13_24_, session0_.session_id as session14_24_, session0_.session_status as session15_24_, session0_.start_at as start_a16_24_, session0_.tag_id as tag_id17_24_, session0_.template_id as templat18_24_, session0_.template_type as templat19_24_, session0_.updated_at as updated20_24_, session0_.user_id as user_id21_24_, session0_.is_valid as is_vali22_24_ from hp_session session0_ where session0_.user_id=20084850201 and session0_.coach_id=2491360400 and session0_.template_type=1 and session0_.template_id=609 order by session0_.created_at desc\G

# Query 19: 0 QPS, 0x concurrency, ID 0x943798A09019B333 at byte 9329014 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2009-21-16 10:42:01 to 10:42:33
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          6    2948
# Exec time      0   216ms    21us   714us    73us   113us    32us    73us
# Query size     0  37.43k      13      13      13      13       0      13
# String:
# Hosts        10.128.242.236:34562 (191/6%)... 26 more
# Users        unknown_user
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ##########
#   1ms
#  10ms
# 100ms
#    1s
#  10s+
SHOW WARNINGS\G

# Query 20: 0 QPS, 0x concurrency, ID 0xDA326394FC0842CC at byte 102741 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2009-21-16 10:41:49
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0       1
# Exec time      0   173ms   173ms   173ms   173ms   173ms       0   173ms
# Query size     0     209     209     209     209     209       0     209
# String:
# Hosts        10.128.176.23:25941
# Users        unknown_user
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS LIKE 'diagnose_dept_tag'\G
#    SHOW CREATE TABLE `diagnose_dept_tag`\G
#    SHOW TABLE STATUS LIKE 'diagnose_suspect_tag'\G
#    SHOW CREATE TABLE `diagnose_suspect_tag`\G
USE `unknown_database`;
SELECT dst.*,ddt.order_no
        FROM diagnose_dept_tag ddt,diagnose_suspect_tag dst
        WHERE ddt.tag_code = dst.code AND ddt.dc_dept_id=79
        ORDER BY ID
        LIMIT 0,10;\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT dst.*,ddt.order_no
        FROM diagnose_dept_tag ddt,diagnose_suspect_tag dst
        WHERE ddt.tag_code = dst.code AND ddt.dc_dept_id=79
        ORDER BY ID
        LIMIT 0,10;\G