WORKLOAD REPOSITORY report for Yihaodian

Host NameIp addrPortDb roleVersionUptime
pis2410.0.2.24 3306 master 5.5.25a 0y 3m 15d 2h 10mi 41s

Snap IdSnap TimeThreads_connectedThreads_running
Begin Snap:11072013-05-04 05:14:06166.00 6.00
End Snap:18632013-05-04 17:50:08183.00 5.00
Elapsed:  45362 (seconds)  

Report Summary

BeginEnd
query_cache_size :0.00 0.00
thread_cache_size :100.00 100.00
table_definition_cache :400.00 400.00
max_connections :1000.00 1000.00
table_open_cache :4096.00 4096.00
slow_launch_time :2.00 2.00
max_heap_table_size :16777216.00 16777216.00
tmp_table_size :33554432.00 33554432.00
open_files_limit :65535.00 65535.00
Max_used_connections :247.00 247.00
Threads_connected :166.00 183.00
Threads_cached :47.00 30.00
Threads_created :1236.00 1236.00
Threads_running :6.00 5.00
Connections :366637.00 369296.00
key_buffer_size :10737418240.00 10737418240.00
join_buffer_size :131072.00 131072.00
sort_buffer_size :4194304.00 4194304.00
Key_blocks_not_flushed :0.00 0.00
Key_blocks_unused :8485068.00 8485068.00
Key_blocks_used :13704.00 13704.00
Key_read_requests :33395146752.00 33663537152.00
Key_reads :8.00 8.00
Key_write_requests :1017990976.00 1045048576.00
Key_writes :0.00 0.00
Questions :22121043968.00 22282878976.00
Com_select :17358739456.00 17482725376.00
Com_insert :2038784896.00 2054694528.00
Com_update :2556918784.00 2577709056.00
Com_delete :131552400.00 132410104.00
Bytes_received :4480045154304.00 4514300559360.00
Bytes_sent :10532285317120.00 10604516474880.00
Qcache_hits :0.00 0.00
Qcache_inserts :0.00 0.00
Select_full_join :73316.00 73316.00
Select_scan :5266076.00 5306202.00
Slow_queries :4608426.00 4645891.00
Com_commit :10853086.00 10888188.00
Com_rollback :32638.00 32790.00
Open_files :87.00 89.00
Open_table_definitions :205.00 205.00
Open_tables :666.00 667.00
Opened_files :360853920.00 360871232.00
Opened_table_definitions :649.00 649.00
Opened_tables :2833.00 2834.00
Created_tmp_disk_tables :776418.00 780610.00
Created_tmp_files :26965.00 27114.00
Created_tmp_tables :2964195.00 2978347.00
Binlog_cache_disk_use :4725882.00 4726614.00
Binlog_cache_use :4705357824.00 4742844928.00
Aborted_clients :7112.00 7121.00
Sort_merge_passes :54993.00 55305.00
Sort_range :251949296.00 257183696.00
Sort_rows :4046371840.00 4069623040.00
Sort_scan :1257558.00 1258810.00
Table_locks_immediate :68051636224.00 68418306048.00
Table_locks_waited :0.00 0.00
Handler_read_first :4236846.00 4268236.00
Handler_read_key :26276941824.00 26655909888.00
Handler_read_last :122947.00 123082.00
Handler_read_next :3996812050432.00 4026496712704.00
Handler_read_prev :8631639040.00 8638999552.00
Handler_read_rnd :3910545152.00 3925926656.00
Handler_read_rnd_next :660292698112.00 665144983552.00
Innodb_rows_inserted :2494949888.00 2511041536.00
Innodb_rows_updated :2744862720.00 2769755392.00
Innodb_rows_deleted :1402831104.00 1410035328.00
Innodb_rows_read :4533951922176.00 4566992551936.00
Innodb_buffer_pool_read_requests:10864356753408.0010941985980416.00
Innodb_buffer_pool_reads :229682624.00 231128096.00
Innodb_buffer_pool_pages_data :3785060.00 3760607.00
Innodb_buffer_pool_pages_free :0.00 0.00
Innodb_buffer_pool_pages_dirty :3408.00 30138.00
Innodb_buffer_pool_pages_flushed:2195601920.002211833088.00
Innodb_data_reads :308351456.00 310099264.00
Innodb_data_writes :11558119424.00 11648568320.00
Innodb_data_read :5051990933504.00 5080627019776.00
Innodb_data_written :81757713989632.00 82352701177856.00
Innodb_os_log_fsyncs :15810196.00 15889408.00
Innodb_os_log_written :9814455353344.00 9877608988672.00
history_list :1197.00 57524.00
log_bytes_written :7266411479040.00 7291710996480.00
log_bytes_flushed :7266409381888.00 7291710996480.00
last_checkpoint :7266406236160.00 7291647033344.00
queries_inside :0.00 0.00
queries_queued :0.00 0.00
read_views :2.00 3.00
innodb_open_files :300.00 300.00
innodb_log_waits :56.00 56.00

Load Profile

Per Second
TPS: 827
Com_select(s): 2733
Com_insert(s): 350
Com_update(s): 458
Com_delete(s): 18
Innodb t_row PS: 1062
Innodb_rows_inserted(s):354
Innodb_rows_updated(s): 548
Innodb_rows_deleted(s): 158
Innodb_rows_read(/s): 728376
Innodb_data_reads(s): 38
Innodb_data_writes(s): 1993
Innodb_data_read(kb/s):616
Innodb_data_written(kb/s):12809
Innodb_os_log_fsyncs(s):1
Innodb_os_log_written(kb/s):1359

Instance Efficiency Percentages (Target 100%)

key_buffer_read_hits %:100
key_buffer_write_hits %:100
Innodb_buffer_read_hits %:99.99
Query_cache_hits %:0
Thread_cache_hits %:100

Top 10 Timed Events

event_namewait time(picsecond)wait count
wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond4603270636072080037001744
wait/io/file/innodb/innodb_data_file422982136839375018938373
wait/synch/rwlock/innodb/btr_search_latch287667612480375024566139901
wait/synch/mutex/innodb/buf_pool_mutex22080509090068506505828117
wait/io/file/innodb/innodb_log_file61768444013775074018616
wait/io/file/sql/binlog499282346214450149486134
wait/synch/rwlock/innodb/index_tree_rw_lock2844453203649001607246049
wait/synch/mutex/sql/LOG::LOCK_log202240883524050277586429
wait/synch/mutex/innodb/log_sys_mutex153511390484550501317239
wait/synch/mutex/innodb/kernel_mutex1494989846424001586908524

Top 10 read file Events

event_nameread bytesread count
wait/io/file/myisam/dfile333133200517409231
wait/io/file/innodb/innodb_data_file286360535041747806
wait/io/file/sql/binlog27484110265111910709
wait/io/file/myisam/kfile16222738384
wait/io/file/sql/partition22816496
wait/io/file/sql/dbopt00
wait/io/file/csv/update00
wait/io/file/sql/init00
wait/io/file/sql/send_file00
wait/io/file/sql/misc00

Top 10 write file Events

event_nameread bytesread count
wait/io/file/innodb/innodb_data_file53307962163216510589
wait/io/file/innodb/innodb_log_file6315560704073938326
wait/io/file/sql/binlog2748411029137572930
wait/io/file/myisam/dfile261557329772283226
wait/io/file/sql/slow_log70889349668196
wait/io/file/myisam/kfile206664159766
wait/io/file/sql/binlog_index88426
wait/io/file/sql/dbopt00
wait/io/file/csv/update00
wait/io/file/sql/init00

Operating System Load Statistics - Detail

Snap Timeload1load5load15
2013-05-04 05:14:061.151.341.37
2013-05-04 05:27:060.721.031.21
2013-05-04 05:40:072.992.682.00
2013-05-04 05:53:063.573.372.74
2013-05-04 06:06:064.014.243.64
2013-05-04 06:19:063.904.123.91
2013-05-04 06:32:073.694.204.15
2013-05-04 06:45:063.363.483.81
2013-05-04 06:58:063.093.533.62
2013-05-04 07:11:063.693.753.75
2013-05-04 07:24:061.842.633.21
2013-05-04 07:37:062.442.302.60
2013-05-04 07:50:072.932.482.48
2013-05-04 08:03:072.272.522.47
2013-05-04 08:16:072.852.672.53
2013-05-04 08:29:061.992.292.41
2013-05-04 08:42:062.972.822.62
2013-05-04 08:55:062.822.592.65
2013-05-04 09:08:061.772.352.53
2013-05-04 09:21:062.762.362.38
2013-05-04 09:34:061.582.072.22
2013-05-04 09:47:062.232.282.23
2013-05-04 10:00:073.702.842.44
2013-05-04 10:13:071.752.392.55
2013-05-04 10:26:062.522.312.38
2013-05-04 10:39:061.501.922.11
2013-05-04 10:52:062.202.202.16
2013-05-04 11:05:073.022.662.41
2013-05-04 11:18:062.742.972.68
2013-05-04 11:31:062.452.392.46
2013-05-04 11:44:072.272.462.40
2013-05-04 11:57:061.752.082.23
2013-05-04 12:10:072.372.312.30
2013-05-04 12:23:071.732.192.25
2013-05-04 12:36:072.582.382.28
2013-05-04 12:49:061.522.072.19
2013-05-04 13:02:072.902.582.35
2013-05-04 13:15:072.422.322.29
2013-05-04 13:28:061.812.102.20
2013-05-04 13:41:072.902.302.19
2013-05-04 13:54:071.552.022.16
2013-05-04 14:07:072.302.442.33
2013-05-04 14:20:072.282.262.27
2013-05-04 14:33:071.652.062.17
2013-05-04 14:46:072.732.382.23
2013-05-04 14:59:071.842.172.19
2013-05-04 15:12:072.502.502.40
2013-05-04 15:25:072.612.372.35
2013-05-04 15:38:081.762.082.18
2013-05-04 15:51:072.862.402.24
2013-05-04 16:04:071.492.032.12
2013-05-04 16:17:072.292.252.15
2013-05-04 16:30:073.032.742.43
2013-05-04 16:43:072.682.842.66
2013-05-04 16:56:072.332.642.66
2013-05-04 17:09:071.742.292.49
2013-05-04 17:22:072.302.342.41
2013-05-04 17:35:082.592.462.38
2013-05-04 17:48:072.232.492.43
2013-05-04 17:50:082.852.552.45

Operating System CPU Statistics - Detail

Snap Timeusersystemidleiowait
2013-05-04 05:14:0617.003.0080.000.00
2013-05-04 05:27:064.000.0096.000.00
2013-05-04 05:40:0715.002.0083.000.00
2013-05-04 05:53:0617.000.0082.000.00
2013-05-04 06:06:0611.001.0088.000.00
2013-05-04 06:19:0614.002.0084.000.00
2013-05-04 06:32:0712.001.0086.000.00
2013-05-04 06:45:0610.002.0088.000.00
2013-05-04 06:58:068.002.0090.000.00
2013-05-04 07:11:0610.002.0088.000.00
2013-05-04 07:24:0610.002.0088.000.00
2013-05-04 07:37:069.001.0090.000.00
2013-05-04 07:50:076.001.0093.000.00
2013-05-04 08:03:075.000.0094.000.00
2013-05-04 08:16:078.001.0091.000.00
2013-05-04 08:29:067.001.0091.000.00
2013-05-04 08:42:069.000.0091.000.00
2013-05-04 08:55:069.002.0089.000.00
2013-05-04 09:08:065.001.0094.000.00
2013-05-04 09:21:066.001.0093.001.00
2013-05-04 09:34:068.001.0091.000.00
2013-05-04 09:47:064.000.0096.000.00
2013-05-04 10:00:0719.004.0077.001.00
2013-05-04 10:13:075.000.0095.000.00
2013-05-04 10:26:0610.001.0089.000.00
2013-05-04 10:39:067.001.0092.000.00
2013-05-04 10:52:068.000.0092.000.00
2013-05-04 11:05:0710.000.0089.000.00
2013-05-04 11:18:064.000.0096.000.00
2013-05-04 11:31:0610.001.0089.001.00
2013-05-04 11:44:079.001.0090.000.00
2013-05-04 11:57:067.001.0092.000.00
2013-05-04 12:10:0713.000.0086.000.00
2013-05-04 12:23:074.000.0096.000.00
2013-05-04 12:36:0710.000.0089.000.00
2013-05-04 12:49:065.000.0094.000.00
2013-05-04 13:02:075.000.0095.000.00
2013-05-04 13:15:078.000.0091.001.00
2013-05-04 13:28:064.000.0096.000.00
2013-05-04 13:41:0710.001.0089.000.00
2013-05-04 13:54:0710.002.0089.000.00
2013-05-04 14:07:078.000.0092.000.00
2013-05-04 14:20:0710.001.0088.000.00
2013-05-04 14:33:074.000.0096.000.00
2013-05-04 14:46:0710.000.0089.000.00
2013-05-04 14:59:0711.002.0087.000.00
2013-05-04 15:12:074.000.0096.000.00
2013-05-04 15:25:075.001.0094.000.00
2013-05-04 15:38:084.000.0096.000.00
2013-05-04 15:51:076.000.0093.000.00
2013-05-04 16:04:075.000.0094.000.00
2013-05-04 16:17:075.000.0095.000.00
2013-05-04 16:30:0711.001.0087.000.00
2013-05-04 16:43:079.000.0091.000.00
2013-05-04 16:56:0711.001.0088.000.00
2013-05-04 17:09:078.000.0092.000.00
2013-05-04 17:22:078.000.0092.000.00
2013-05-04 17:35:0810.001.0087.002.00
2013-05-04 17:48:074.000.0096.000.00
2013-05-04 17:50:0810.000.0089.001.00

Operating System IO Statistics - Detail

Snap Timerd_ios_swr_ios_srkbswkbsqueuesvc_tbusy
2013-05-04 05:14:0617.8817.88282.122650.330.153.7213.31
2013-05-04 05:27:060.000.000.000.000.000.000.00
2013-05-04 05:40:071.00220.6315.978310.150.080.081.70
2013-05-04 05:53:060.0010.990.001758.530.010.450.50
2013-05-04 06:06:060.0077.770.004119.980.020.080.60
2013-05-04 06:19:0613.9814.98223.631581.360.124.0711.78
2013-05-04 06:32:070.00124.330.006246.170.030.020.30
2013-05-04 06:45:0611.94111.40190.975744.880.110.769.35
2013-05-04 06:58:060.00167.160.005727.360.050.040.60
2013-05-04 07:11:063.99253.3763.848502.740.060.174.49
2013-05-04 07:24:0612.90151.86206.456570.720.140.6711.02
2013-05-04 07:37:060.0099.710.005404.240.030.080.80
2013-05-04 07:50:076.9645.71111.302023.350.061.135.96
2013-05-04 08:03:070.0094.410.003128.450.010.030.30
2013-05-04 08:16:077.94123.13127.104245.920.110.678.84
2013-05-04 08:29:061.994.9731.79739.070.022.571.79
2013-05-04 08:42:060.0049.900.001772.310.000.020.10
2013-05-04 08:55:0611.9617.93191.281087.920.113.6710.96
2013-05-04 09:08:061.001162.193.9857078.610.160.066.47
2013-05-04 09:21:0614.9018.87238.411327.150.154.5315.30
2013-05-04 09:34:060.003.970.00131.130.000.500.20
2013-05-04 09:47:060.004.980.0047.760.000.400.20
2013-05-04 10:00:0728.8973.72446.333000.750.211.8218.63
2013-05-04 10:13:070.00108.280.0010219.870.030.101.09
2013-05-04 10:26:0615.9715.97251.582435.940.133.9412.58
2013-05-04 10:39:068.946.96143.11155.030.063.505.57
2013-05-04 10:52:060.003.980.0075.620.000.000.00
2013-05-04 11:05:077.9842.91127.732718.340.071.356.89
2013-05-04 11:18:060.004.980.0099.540.000.000.00
2013-05-04 11:31:068.984.99143.641049.380.1611.1415.56
2013-05-04 11:44:0716.913.98270.5363.660.125.3311.14
2013-05-04 11:57:0625.8211.92548.121290.860.112.429.14
2013-05-04 12:10:0716.9913.99271.89783.670.124.0012.39
2013-05-04 12:23:070.000.000.000.000.000.000.00
2013-05-04 12:36:076.9914.97111.771544.780.072.866.29
2013-05-04 12:49:063.980.0063.660.000.0410.504.18
2013-05-04 13:02:070.002.990.0027.910.000.330.10
2013-05-04 13:15:0710.9510.95175.12481.590.198.6418.91
2013-05-04 13:28:060.000.000.000.000.000.000.00
2013-05-04 13:41:071.0018.9815.981374.280.020.801.60
2013-05-04 13:54:074.988.9779.70996.260.042.713.79
2013-05-04 14:07:070.000.000.000.000.000.000.00
2013-05-04 14:20:0721.8922.89366.171667.660.132.3610.55
2013-05-04 14:33:070.004.980.0067.750.000.200.10
2013-05-04 14:46:073.0020.9747.941310.360.031.002.40
2013-05-04 14:59:078.941984.77143.0559642.380.380.0611.62
2013-05-04 15:12:070.000.000.000.000.000.000.00
2013-05-04 15:25:075.9617.8795.32718.910.031.122.68
2013-05-04 15:38:080.000.000.000.000.000.000.00
2013-05-04 15:51:0712.9523.91207.221414.690.082.278.37
2013-05-04 16:04:070.992.9815.8819.850.011.750.69
2013-05-04 16:17:070.004.990.0095.880.000.000.00
2013-05-04 16:30:0714.981204.49239.7034440.950.270.1113.38
2013-05-04 16:43:070.0011.990.001074.660.000.080.10
2013-05-04 16:56:079.993185.02159.8091669.410.390.0514.58
2013-05-04 17:09:070.004.000.00895.630.000.500.20
2013-05-04 17:22:070.000.000.000.000.000.000.00
2013-05-04 17:35:0816.892949.34270.2081790.730.950.1851.95
2013-05-04 17:48:070.000.000.000.000.000.000.00
2013-05-04 17:50:0814.9711.98239.501233.430.134.5612.27

Operating System Other Statistics - Detail

Snap Timeswap_inswap_outnet_recvnet_sendfile_systemtotal_mbused_mbused_pctmount_point
2013-05-04 05:14:060.000.000.000.00/dev/cciss/c0d1p11689489.001322935.0083.00/data
2013-05-04 05:27:060.000.000.000.00/dev/cciss/c0d1p11689489.001323122.0083.00/data
2013-05-04 05:40:070.000.000.000.00/dev/cciss/c0d1p11689489.001324125.0083.00/data
2013-05-04 05:53:060.000.000.000.00/dev/cciss/c0d1p11689489.001325213.0083.00/data
2013-05-04 06:06:060.000.000.000.00/dev/cciss/c0d1p11689489.001326098.0083.00/data
2013-05-04 06:19:060.000.000.000.00/dev/cciss/c0d1p11689489.001326908.0083.00/data
2013-05-04 06:32:070.000.000.000.00/dev/cciss/c0d1p11689489.001328030.0083.00/data
2013-05-04 06:45:060.000.000.000.00/dev/cciss/c0d1p11689489.001329377.0083.00/data
2013-05-04 06:58:060.000.000.000.00/dev/cciss/c0d1p11689489.001330412.0083.00/data
2013-05-04 07:11:060.000.000.000.00/dev/cciss/c0d1p11689489.001331636.0084.00/data
2013-05-04 07:24:060.000.000.000.00/dev/cciss/c0d1p11689489.001332653.0084.00/data
2013-05-04 07:37:060.000.000.000.00/dev/cciss/c0d1p11689489.001333240.0084.00/data
2013-05-04 07:50:070.000.000.000.00/dev/cciss/c0d1p11689489.001333836.0084.00/data
2013-05-04 08:03:070.000.000.000.00/dev/cciss/c0d1p11689489.001334515.0084.00/data
2013-05-04 08:16:070.000.000.000.00/dev/cciss/c0d1p11689489.001335137.0084.00/data
2013-05-04 08:29:060.000.000.000.00/dev/cciss/c0d1p11689489.001335723.0084.00/data
2013-05-04 08:42:060.000.000.000.00/dev/cciss/c0d1p11689489.001336342.0084.00/data
2013-05-04 08:55:060.000.000.000.00/dev/cciss/c0d1p11689489.001336891.0084.00/data
2013-05-04 09:08:060.000.000.000.00/dev/cciss/c0d1p11689489.001337293.0084.00/data
2013-05-04 09:21:060.000.000.000.00/dev/cciss/c0d1p11689489.001337663.0084.00/data
2013-05-04 09:34:060.000.000.000.00/dev/cciss/c0d1p11689489.001337927.0084.00/data
2013-05-04 09:47:060.000.000.000.00/dev/cciss/c0d1p11689489.001338213.0084.00/data
2013-05-04 10:00:070.000.000.000.00/dev/cciss/c0d1p11689489.001338464.0084.00/data
2013-05-04 10:13:070.000.000.000.00/dev/cciss/c0d1p11689489.001338864.0084.00/data
2013-05-04 10:26:060.000.000.000.00/dev/cciss/c0d1p11689489.001339183.0084.00/data
2013-05-04 10:39:060.000.000.000.00/dev/cciss/c0d1p11689489.001339426.0084.00/data
2013-05-04 10:52:060.000.000.000.00/dev/cciss/c0d1p11689489.001339733.0084.00/data
2013-05-04 11:05:070.000.000.000.00/dev/cciss/c0d1p11689489.001340146.0084.00/data
2013-05-04 11:18:060.000.000.000.00/dev/cciss/c0d1p11689489.001340788.0084.00/data
2013-05-04 11:31:060.000.000.000.00/dev/cciss/c0d1p11689489.001341031.0084.00/data
2013-05-04 11:44:070.000.000.000.00/dev/cciss/c0d1p11689489.001341296.0084.00/data
2013-05-04 11:57:060.000.000.000.00/dev/cciss/c0d1p11689489.001341588.0084.00/data
2013-05-04 12:10:070.000.000.000.00/dev/cciss/c0d1p11689489.001342948.0084.00/data
2013-05-04 12:23:070.000.000.000.00/dev/cciss/c0d1p11689489.001343265.0084.00/data
2013-05-04 12:36:070.000.000.000.00/dev/cciss/c0d1p11689489.001343548.0084.00/data
2013-05-04 12:49:060.000.000.000.00/dev/cciss/c0d1p11689489.001343826.0084.00/data
2013-05-04 13:02:070.000.000.000.00/dev/cciss/c0d1p11689489.001344169.0084.00/data
2013-05-04 13:15:070.000.000.000.00/dev/cciss/c0d1p11689489.001344467.0084.00/data
2013-05-04 13:28:060.000.000.000.00/dev/cciss/c0d1p11689489.001344706.0084.00/data
2013-05-04 13:41:070.000.000.000.00/dev/cciss/c0d1p11689489.001344957.0084.00/data
2013-05-04 13:54:070.000.000.000.00/dev/cciss/c0d1p11689489.001345220.0084.00/data
2013-05-04 14:07:070.000.000.000.00/dev/cciss/c0d1p11689489.001345567.0084.00/data
2013-05-04 14:20:070.000.000.000.00/dev/cciss/c0d1p11689489.001345815.0084.00/data
2013-05-04 14:33:070.000.000.000.00/dev/cciss/c0d1p11689489.001346012.0084.00/data
2013-05-04 14:46:070.000.000.000.00/dev/cciss/c0d1p11689489.001346225.0084.00/data
2013-05-04 14:59:070.000.000.000.00/dev/cciss/c0d1p11689489.001346477.0084.00/data
2013-05-04 15:12:070.000.000.000.00/dev/cciss/c0d1p11689489.001346861.0084.00/data
2013-05-04 15:25:070.000.000.000.00/dev/cciss/c0d1p11689489.001347123.0085.00/data
2013-05-04 15:38:080.000.000.000.00/dev/cciss/c0d1p11689489.001347356.0085.00/data
2013-05-04 15:51:070.000.000.000.00/dev/cciss/c0d1p11689489.001347612.0085.00/data
2013-05-04 16:04:070.000.000.000.00/dev/cciss/c0d1p11689489.001347848.0085.00/data
2013-05-04 16:17:070.000.000.000.00/dev/cciss/c0d1p11689489.001348143.0085.00/data
2013-05-04 16:30:070.000.000.000.00/dev/cciss/c0d1p11689489.001348591.0085.00/data
2013-05-04 16:43:070.000.000.000.00/dev/cciss/c0d1p11689489.001349165.0085.00/data
2013-05-04 16:56:070.000.000.000.00/dev/cciss/c0d1p11689489.001349689.0085.00/data
2013-05-04 17:09:070.000.000.000.00/dev/cciss/c0d1p11689489.001349981.0085.00/data
2013-05-04 17:22:070.000.000.000.00/dev/cciss/c0d1p11689489.001350323.0085.00/data
2013-05-04 17:35:080.000.000.000.00/dev/cciss/c0d1p11689489.001350602.0085.00/data
2013-05-04 17:48:070.000.000.000.00/dev/cciss/c0d1p11689489.001350944.0085.00/data
2013-05-04 17:50:080.000.000.000.00/dev/cciss/c0d1p11689489.001351012.0085.00/data

TOP 20 SQL - Detail

checksumdb namets_mints_maxts_cntQuery_time_sumQuery_time_pct_95Lock_time_sumLock_time_pct_95Rows_sent_sumRows_sent_pct_95sample
15454156676126657069pis2013-05-04 01:40:452013-05-04 06:37:404722310.2911.94610.0269680.0000847669471855964.412SELECT DISTINCT PRODUCT_CODE as productCode, SITE_ID as siteId, MERCHANT_ID as merchantId FROM T_PRODUCT_STAT_FOOLPROOF LIMIT 1000 OFFSET 229000
15010507374449773715pis2013-05-04 05:35:302013-05-04 07:21:486692272.254.083770.0489470.0000981283216819874.75SELECT c.product_id,p.marchent_id FROM T_YHD_PRODUCT_CATEGORY c left join T_YHD_PRODUCT p on c.PRODUCT_ID = p.PRODUCT_ID WHERE p.marchent_id = 8154 AND ( c.supplier = '' OR c.supplier IS NULL )
9633168515919646209pis2013-05-04 05:35:252013-05-04 07:21:416691448.582.507080.0295060.000076886122960SELECT pbk.product_id FROM T_YHD_PRODUCT pbk WHERE pbk.MARCHENT_ID = 6267 and pbk.LAST_UPDATE < '2013-05-04'
3903956879490624385pis2013-05-04 05:35:272013-05-04 07:21:44669774.5231.539130.0629330.00012523913730SELECT product_id FROM ( SELECT p.product_id ,c.category_id_lv2 ,c.category_id_lv3 ,c.category_id_lv4 ,c.category_id_lv5 FROM T_YHD_PRODUCT p LEFT JOIN T_YHD_PRODUCT_CATEGORY c ON p.product_id = c.product_id where p.marchent_id = 6904 ) t WHERE ( t.category_id_lv2 IS NULL OR t.category_id_lv2 = 0 )
13371613263247887872pis2013-05-04 05:27:572013-05-04 06:32:01682765.931.465840.0319430.00006973796821SELECT count(pbk.product_id) FROM T_YHD_PRODUCT pbk WHERE pbk.MARCHENT_ID = 6592
3270574017019830148pis2013-05-04 07:57:562013-05-04 23:58:028452291.7440.05855880.5375070.000113596143363.88931SELECT ID, MONITOR_ID, PRODUCT_CODE, SITE_ID, OPPON_PRODUCT_CODE, OPPON_PRODUCT_URL, CRAWL_TIME, CRAWL_STATUS, OPPON_HIS_PRICE, OPPON_HIS_STOCK, CREATE_TIME, UPDATE_TIME FROM T_CRAWLER_MONITOR_TASK WHERE MONITOR_ID=106 AND PRODUCT_CODE='0030493880' AND CREATE_TIME >= '2013-05-04 14:00:00' AND CREATE_TIME < '2013-05-04 15:00:00'
17710069963806941383pis2013-05-04 00:58:112013-05-04 11:40:3893226.3544.727470.0070140.000119276931select COUNT(typ.PRODUCT_CODE) as skuCount , COUNT(DISTINCT typ.BRAND_CUT) brandCount FROM T_YHD_PRODUCT_CATEGORY typc ,T_YHD_PRODUCT typ WHERE typc.PRODUCT_ID =typ.PRODUCT_ID AND MARCHENT_ID=1 AND CAN_SALE =1 and CAN_SHOW=1 AND IS_GIFT =0 AND typ.IS_YIHAODIAN = 1 AND (CATEGORY_ID_LV2 =123 or CATEGORY_ID_LV3 =123 or CATEGORY_ID_LV4 =123 or CATEGORY_ID_LV5 =123)
15618355159869730084pis2013-05-04 06:57:552013-05-04 07:04:4058100.8583.70410.0052420.0001449856848964.412SELECT pbk.PRODUCT_CODE as productCode , pbk.STRIP_CODE as stripCode , pbk.PRODUCT_NAME as productName , pbk.CAN_SALE as canSale , pbk.CAN_SHOW as canShow , pbk.IS_GIFT as isGift , pbk.MARCHENT_ID as marchentId, pbk.PRICE as price FROM T_YHD_PRODUCT pbk WHERE product_sby_type <> 1 and pbk.MARCHENT_ID =1 AND pbk.can_sale = 1 AND pbk.can_show = 1 AND pbk.is_gift = 0 ORDER BY PRODUCT_ID ASC LIMIT 1000 offset 55000
9419910834448586535pis2013-05-04 01:00:172013-05-04 11:40:27679.434713.17060.000560.0001135969623.6524select CATEGORY_ID_LV3 as categoryId , COUNT(typ.PRODUCT_CODE) as skuCount , COUNT(DISTINCT typ.BRAND_CUT) brandCount FROM T_YHD_PRODUCT_CATEGORY typc ,T_YHD_PRODUCT typ WHERE typc.PRODUCT_ID =typ.PRODUCT_ID AND MARCHENT_ID=1 AND CAN_SALE =1 and CAN_SHOW=1 AND IS_GIFT =0 AND CATEGORY_ID_LV3 > 0 AND typ.IS_YIHAODIAN = 1 AND CATEGORY_ID_LV2 =123 GROUP BY CATEGORY_ID_LV3
5763853265089067730pis2013-05-04 17:30:192013-05-04 19:58:24568.215419.45890.0005370.000125239250005000SELECT distinct pbk.product_code FROM T_YHD_PRODUCT pbk,T_YHD_PRODUCT_CATEGORY ppr WHERE pbk.product_id = ppr.product_id and pbk.product_type <> 1 and pbk.product_type <> 3 AND (ppr.category_id_lv2 =5135 or ppr.category_id_lv3 =5135 or ppr.category_id_lv4 =5135 or ppr.category_id_lv5 =5135 ) AND pbk.can_show = 1 AND pbk.is_gift = 0 AND pbk.MARCHENT_ID in ( 1 , 2 , 3 , 8 ) AND pbk.product_code > '0000459336' order by pbk.product_code ASC limit 5000
3854049795172627246pis2013-05-04 08:57:582013-05-04 17:28:4054741.43210.1798650.5485440.00166255462421964.412SELECT TP.PRODUCT_CODE productCode, if(isnull(TP.MERCHANT_NAME),FALSE,TRUE) as isInShop FROM( SELECT SITE_ID, PRODUCT_CODE, MERCHANT_NAME FROM T_PRODUCT WHERE SITE_ID = 1002 AND PRODUCT_CODE IN ( 'B009GCBBU6' , 'B0084V35RC' , 'B008LRMCQ4' , 'B003TUGJC6' , 'B0013J3XG0' , 'B003TUGCHI' , 'B003TUEFYA' , 'B000PH9HEI' , 'B005OIE0NQ' , 'B008Y7R8HY' , 'B009HO6FH2' , 'B002HORBL8' , 'B007SR99IM' , 'B008VOGHP4' , 'B0095N3P1Y' , 'B0095N3NCK' , 'B004HEY52E' , 'B0091PMQ4I' , 'B0091PMVFM' , 'B002KMK4SO' , 'B0010MGSV2' , 'B003LY3ICO' , 'B0058SPNGA' , 'B0085R4L5K' , 'B008EGVTIY' , 'B003KZK5ES' , 'B008J9JR30' , 'B003U6GPEQ' , 'B003U6GPEQ' , 'B004NYA0M2' , 'B004NYA0M2' , 'B0086SXDFW' , 'B003BNYDFQ' , 'B005J29LVI' , 'B005J29LVI' , 'B00303FR02' , 'B00303FR02' , 'B00303FR0W' , 'B00303FR0W' , 'B004EHXXM2' , 'B004EHXXM2' , 'B004S0AS28' , 'B004S0AS28' , 'B0057BLUH4' , 'B0095RF87O' , 'B005U97V3U' , 'B0095RF6VW' , 'B0049H9MI6' , 'B005TPX72Y' , 'B009EOXTF6' , 'B009ALKMBC' , 'B008KFB0EW' , 'B0094AKKK2' , 'B0094AKKNO' , 'B0094AKKBG' , 'B008KFB574' , 'B001L1R6Q8' , 'B0010LDH4O' , 'B006MC75F8' , 'B004XL6L3C' , 'B005HMTKPM' , 'B004TJ4FCM' , 'B0057K7PTM' , 'B0058QP178' , 'B006UAJ1EU' , 'B0063PRLCG' , 'B008HYR0FO' , 'B000VZ4X34' , 'B004FN2EAM' , 'B005WOSC40' , 'B004I44TUQ' , 'B008BGIC5K' , 'B005PU4L64' , 'B008QUXGNY' , 'B009QTTTZS' , 'B0093IPZD2' , 'B0093IQ1XA' , 'B008KY2F38' , 'B008KY2H9U' , 'B005FO1TR4' , 'B008VOIXCE' , 'B006FDTS5Y' , 'B008CMX44M' , 'B007QHK4VK' , 'B0057L9L02' , 'B004IEAX9M' , 'B003P0WTAQ' , 'B003NNUN62' , 'B007K52EAW' , 'B007K52EXY' , 'B004R9DYVC' , 'B006R1BDHU' , 'B004ZWEABY' , 'B008AGGZQ4' , 'B008AGLVBS' , 'B006VASS2K' , 'B006VASSI4' , 'B005OIDZUA' , 'B003NNVPKA' , 'B004FPHDAG' , 'B009HMVA42' , 'B009HMVA42' , 'B007Q8HEUI' , 'B007HYX0EA' , 'B009NCCG12' , 'B005WPK13E' , 'B008MU1RQ6' , 'B0051L77XQ' , 'B007JRO8RS' , 'B008GOW0HI' , 'B005AQ81YG' , 'B009DYD3OY' , 'B006B3WJKO' , 'B0094BPFFG' , 'B008YOYU3W' , 'B004DCAUEC' , 'B007QJFWE2' , 'B008MU1RQ6' , 'B004XV0BQA' , 'B006CF2GM2' , 'B006UAAGAS' , 'B008H9NJT0' , 'B004OR2FP8' , 'B007HM68X2' , 'B007HM6IJQ' , 'B007CZLSCK' , 'B007HM6MB0' , 'B007HM6CLU' , 'B007GIOYWO' , 'B007CZLTYC' , 'B007HM6OF4' , 'B007HM6IQ4' , 'B007HM6C10' , 'B007HM6LUW' , 'B007HM6I64' , 'B007HM6K9E' , 'B007HM6GCA' , 'B007HM6C38' , 'B007HM6JAE' , 'B007HM6MZ6' , 'B007HM6LDY' , 'B007HM6QY8' , 'B007GIP0GS' , 'B007HM6OZE' , 'B007HM6NVO' , 'B007HM6HJC' , 'B007HM6F3K' , 'B007HM69MW' , 'B007HM68L4' , 'B007GIOZWI' , 'B007HM6PVM' , 'B007GIP0P4' , 'B007F53B5E' , 'B00497XVW4' , 'B003NNVPKK' , 'B002C1U1EU' , 'B001OC699Y' , 'B00A30WFLO' , 'B00A30WMDK' , 'B00A30WJV0' , 'B0030DFECS' , 'B0030DFE5A' , 'B0030DFE5K' , 'B0030DFE8C' , 'B0016L0VHE' , 'B0030DFE3M' , 'B002PLLYZ2' , 'B0088W9E68' , 'B0088W9C4M' , 'B008565Y5M' , 'B008PO8VIG' , 'B008FKLTPC' , 'B009745AVY' , 'B009P0TVH4' , 'B008HO401G' , 'B009746D88' , 'B009SK5YKE' , 'B008HO3V52' , 'B009DBBJ3E' , 'B009P0TZNO' , 'B009P0TNWM' , 'B009DBBZZ6' , 'B009C0418Q' , 'B008H1T4PQ' , 'B008R6LWSS' , 'B009C45J6K' , 'B007PZ2984' , 'B008H1T3MK' , 'B008DCPE1C' , 'B004JLMGOE' , 'B0058MJB0U' , 'B008H07PDA' , 'B009A44O9K' , 'B002SNAFF2' , 'B0010LCWHM' , 'B004HEYDTO' , 'B0057M2EJ6' , 'B0071369KE' , 'B004UTK8BS' , 'B007A8LJ50' , 'B007GN0ESC' , 'B007136B7A' , 'B009C044JW' , 'B009C049MO' , 'B009C0480W' , 'B00A2LNMFC' , 'B00A2LO2VK' , 'B009YSZROS' , 'B008U45Y7C' , 'B0087X9MPG' , 'B0090FPPY2' , 'B006FDH91Y' , 'B009YDA112' , 'B006LF1U2K' , 'B004R96HLQ' , 'B004AYD450' , 'B008DC0480' , 'B007RSL4A8' , 'B0095RF2Z2' , 'B009HMNWJS' , 'B00A745U72' , 'B0049HAWI0' , 'B00ADDUF3G' , 'B004ZJQ88U' , 'B005NGJCBY' , 'B005NGJBDI' , 'B005NGJBRE' , 'B005NGJBRE' , 'B0092L1U02' , 'B004AYD43C' , 'B00A1W37D4' , 'B006HYLMLY' , 'B004AYD41O' , 'B007ZM1VW2' , 'B003SEHN3W' , 'B007OSKDD0' , 'B006TANTNK' , 'B0079F5UHC' , 'B008H9EF2U' , 'B008H9EV6A' , 'B008H9EHB4' , 'B009IFDX6G' , 'B008H8Z9HQ' , 'B0098I094M' , 'B009SZYOQY' , 'B009SZYSTW' , 'B009S32EAE' , 'B005EPASJ4' , 'B009GXUPPC' , 'B00835R796' , 'B0084Y4JL0' , 'B003U6GTJW' , 'B004IYJJVK' , 'B00508MRIA' , 'B0089SSGKG' , 'B005LTPYHE' , 'B008OOWUBQ' , 'B007THB9OI' , 'B009SZYUZE' , 'B009SZYMLG' , 'B004H3W8Z6' , 'B007SILJMK' , 'B0044KMJK6' , 'B00A0A41JG' , 'B00ASIK112' , 'B001R4CM0Y' , 'B0090VPMXA' , 'B009A653BQ' , 'B00A3P8NRE' , 'B0085ZGBLY' , null , 'B007N02K80' , 'B003JKKP9E' , 'B004R96HLQ' , 'B004R96HKC' , 'B004R96HN4' , 'B004AM7110' , 'B004AYD41Y' , 'B004AM711A' , 'B005PKSNL8' , 'B0089JQXRS' , 'B0015XNXBE' , 'B009PIB8BI' , 'B0062I2M1Y' , 'B005XW1C8O' , 'B0090EGA4W' , 'B005OUWX10' , 'B00AJF6QYA' , 'B005XJ8ERE' , 'B005XJ8KCS' , 'B003DNS9UE' , 'B0080AGMFY' , 'B0031Y7Q7M' , 'B0099IBF6W' , 'B0018JBJ5C' , 'B0095BE9GQ' , 'B0095BEC22' , 'B003TFF62K' , 'B008HB2HVE' , 'B00AM7V906' , 'B008GRT64U' , 'B00AM7V8X4' , 'B00AM7V8YS' , 'B00AM7V8Y8' , 'B00AM7V8XY' , 'B0045TI97S' , 'B0075TWZES' , 'B0064774CK' , 'B0080APDBI' , 'B008DBC7K4' , 'B002OED778' , 'B006UAJ26C' , 'B006UAJ2HG' , 'B008FLDAZI' , 'B007UXEPQU' , 'B007PVZB2E' , 'B005PKRPKI' , 'B007T4V87O' , 'B001L1R6TK' , 'B00A6680H8' , 'B00AUOWQO4' , 'B007HWTBDG' , 'B007IQOTM4' , 'B008X08E3O' , 'B0085SM6DS' , 'B005TMSN4E' , 'B003P8OZ6O' , 'B004X87AIA' , 'B006G8I930' , 'B003P8OYU6' , 'B003P8OZ5U' , 'B0062VRHD4' , 'B004E2B1EO' , 'B00798XNPA' , 'B00480Q12O' , 'B0099K6XA8' , 'B004YIWE7G' , 'B004YIWEQM' , 'B00480Q0WK' , 'B00480Q0XE' , 'B00480Q160' , 'B00480Q0ZC' , 'B008KGUK56' , 'B008PAM44C' , 'B0084BUKXO' , 'B00809IJD8' , 'B005251IMW' , 'B005GY4R1S' , 'B0096IKA9S' , 'B006GWQX2A' , 'B007HWT3H0' , 'B008KGY4OY' , 'B00742FXF4' , 'B009VW37CG' , 'B009SJRD9K' , 'B00AY86N9U' , 'B00AYP6Y2O' , 'B0055B3OM0' , 'B007K52CHC' , 'B005UKXSEK' , 'B003ZK6NNU' , 'B003XU5SWO' , 'B008TND43U' , 'B000FQOYK6' , 'B002T1GH46' , 'B003OA59TK' , 'B0090VPOKG' , 'B00AFNU30Y' , 'B00AFNU3KY' , 'B00AFNVJ3O' , 'B0082CJ25M' , 'B0082CFCLA' , 'B0043D0YO2' , 'B0094E4B94' , 'B0094E46SU' , 'B0030DFE7S' , 'B006WWZ3X4' , 'B000BIVY2Y' , 'B003FYG1G0' , 'B0030DFEBO' , 'B0030DFECI' , 'B00A6N6FKU' , 'B009FRMLZ6' , 'B00ASIQ5JE' , 'B009SG1KY2' , 'B009SG1KWE' , 'B009SG1OMA' , 'B009SG1L1O' , 'B00ASIQ710' , 'B008KWK1H2' , 'B00A7IFPS2' , 'B009SG1OIO' , 'B008EGXCKW' , 'B004K1FKO6' , 'B0099K9IYG' , 'B0095BH51M' , 'B005VNISOG' , 'B00562E0XU' , 'B006B2LS4I' , 'B00ASIQ422' , 'B004FGN458' , 'B002QGUE7U' , 'B0021L9B1A' , 'B0021L9AXO' , 'B003FZBB4G' , 'B004XV098A' , 'B003VJN5F4' , 'B009VYCTWI' , 'B00A86X5WG' , 'B00A86X6QG' , 'B005MLZ7KA' , 'B0031M9EDI' , 'B0088W1L9Q' , 'B007ZVPZU2' , 'B008JBEC4M' , 'B00ABB14AI' , 'B009RG79ZM' , 'B006G86MZM' , 'B007K535FA' , 'B008YPSPSM' , 'B004XG5QY2' , 'B00A44NHDO' , 'B0095BH5PI' , 'B0099K4KB2' , 'B0099K4PQC' , 'B0099K8M3E' , 'B0099K9ERW' , 'B009SG1KSI' , 'B004ZJR1WW' , 'B009SG1ON4' , 'B00ASHYK3S' , 'B009SG1L0A' , 'B009SG1L1E' , 'B009SG1KW4' , 'B004FCZRPC' , 'B005NGDB8E' , 'B004W75SLI' , 'B007MXH074' , 'B007QJFWQ0' , 'B008V4GLPU' , 'B0079DIY7M' , 'B0079DIY7M' , 'B0079DIY7M' , 'B0079DIY7M' , 'B009GDOVHU' , 'B009MJ9GM8' , 'B0081PESFE' , 'B0081PESMW' , 'B009MJFIT8' , 'B007Q886MS' , 'B008P9IC8U' , 'B00A9QSK9S' , 'B00AXD74XA' , 'B0044DFJOQ' , 'B00499BZ9I' , 'B004BX9CM4' , 'B004ZJQWNG' , 'B008YPSEF6' , 'B003NNVPL4' , 'B007CSZFKI' , 'B008RFN55C' , 'B0069DJN0A' , 'B006Y8O8EQ' , 'B009ZQZ0MI' , 'B009ZQX10G' , 'B006PN92YQ' , 'B00ASIQ5IK' , 'B00553W7R6' , 'B009SG1L32' , 'B00AMFUBEI' , 'B00AJF846I' , 'B008HWINNY' , 'B008RFP1H2' , 'B00AA8VZ60' , 'B008BDD91A' , 'B00ALPB3PK' , 'B008RFN3DQ' , 'B0076UJPS0' , 'B006FDH4W8' , 'B004RIA2C2' , 'B003AC1XZG' , 'B000F4H5FO' , 'B003YXYPM4' , 'B003L20YWS' , 'B002JPKC2K' , 'B004UJHTCY' , 'B008QVALAO' , 'B007QJFYT0' , 'B007PZ28SU' , 'B0087VGISC' , 'B008JVYC88' , 'B0085SM5SO' , 'B009VAHW0Q' , 'B00AAOVFFU' , 'B00AB8T6KG' , 'B00ACW57FE' , 'B00A0GI85I' , 'B009X50EW2' , 'B0069GSC68' , 'B004S5TQEE' , 'B0073QGBZC' , 'B008Y8Z9TW' , 'B008Y9XH86' , 'B008Y9K6YO' , 'B008YA261E' , 'B008YAA69I' , 'B008YTGECW' , 'B008YTGSY6' , 'B008YTGLXY' , 'B008YTH04I' , 'B008YTH75U' , 'B007CSZFJE' , 'B0010M4C9M' , 'B006UNL0B4' , 'B009DAOF9K' , 'B008XFVHCO' , 'B004NG8644' , 'B004NG8644' , 'B008PKXEIC' , 'B009SHJCDC' , 'B009T08ZFO' , 'B008LU5GOQ' , 'B0069K5VMW' , 'B008RJKUR4' , 'B006Z4X5TS' , 'B0044DFLRG' , 'B00809YJ6E' , 'B00AMAA8IM' , 'B00AX4LW5U' , 'B005EDUMSI' , 'B0086LLUG8' , 'B00A7OXYUC' , 'B00798LQ1I' , 'B007XQXP92' , 'B00841074G' , 'B008410A16' , 'B008TMI39Q' , 'B007K48SMQ' , 'B0089V1JTI' , 'B005WNZ0I2' , 'B007X1HEK8' , 'B004VLZE8C' , 'B0031ET3NM' , 'B008N6WFCY' , 'B009O8EFB4' , 'B009YSZROS' , 'B009YSZROS' , 'B009A6599M' , 'B004ZJQ5E2' , 'B008N6WCX6' , 'B004ZJQOX4' , 'B004ZJQ6NM' , 'B009YT0D50' , 'B009GAZ1VI' , 'B0083GK4XG' , 'B005HGSBIU' , 'B009SINHR8' , 'B009SIQ4IM' , 'B00667IORW' , 'B008H831PS' , 'B004HHON1Y' , 'B006DVDA2A' , 'B004F9PNEA' , 'B00A9FLSI4' , 'B008KTIV2W' , 'B0094BDWTM' , 'B008B3254W' , 'B008O2D256' , 'B002K8P3K2' , 'B0047COJWC' , 'B00APVLUKI' , 'B00A2L868K' , 'B00A2L868K' , 'B00A2L868K' , 'B009SJA626' , 'B009T0A8XQ' , 'B004KJEWII' , 'B008KVYVB0' , 'B0095OF6DS' , 'B008DCPGOM' , 'B002HORHIA' , 'B001ECR1BO' , 'B005HGZEXU' , 'B005HGZFFC' , 'B004E0Z42Q' , 'B009CKDWMM' , 'B005EE5FVG' , 'B001KYQDMO' , 'B004KVD2IM' , 'B007J74NIW' , 'B008RRW7UY' , 'B008AFFJCQ' , 'B004T7L3YC' , 'B005F234AQ' , 'B008OQMOOW' , 'B004PMTIP2' , 'B00A6L31NG' , 'B00841074G' , 'B00841099O' , 'B008TMOG0Q' , 'B008QV6P6I' , 'B003NNVPKK' , 'B007EJ70E4' , 'B005NGFKQK' , 'B006U93WLE' , 'B001TOZTZ2' , 'B005WNZ0I2' , 'B006OJE3GS' , 'B006OJ8454' , 'B005WNZ1RM' , 'B00475BNQY' , 'B006OJ8454' , 'B006JW240W' , 'B0084CP55G' , 'B0087VVK6M' , 'B0087VVW0Q' , 'B001GLO8QE' , 'B007YYWRTM' , 'B005NEKNWS' , 'B00ANGNL7K' , 'B0088UZA8G' , 'B0073N9STG' , 'B003P8Q9M2' , 'B00AIG0MHC' , 'B003P8Q9M2' , 'B007GIOYKQ' , 'B00AHA3CQ2' , 'B004K6LI8S' , 'B005DWKALE' , 'B005KG96O0' , 'B00436F4GM' , 'B003OA4N7O' , 'B00AFNTC6K' , 'B007Y44BVE' , 'B008CMBT0S' , 'B007JUCOZS' , 'B002AKIYVK' , 'B005D5RDRU' , 'B007IOD48G' , 'B007JCYER2' , 'B007J9PTSI' , 'B0053F4TKY' , 'B0053F4TKY' , 'B005WOSC40' , 'B006OGOJBA' , 'B009T1GJEM' , 'B00AJAY96C' , 'B00AJAY70K' , 'B00AJAY55W' , 'B00ATA9Z66' , 'B008BP54AW' , 'B002VUBF88' , 'B004I43ZG0' , 'B007IQ0D6K' , 'B0081DOXFG' , 'B006FDWYAA' , 'B00ASIQ5H6' , 'B00590HGG2' , 'B00B8N7TB6' , 'B005LMWGNQ' , 'B004WH2L5E' , 'B008RFMUVW' , 'B00AXFUM64' , 'B00B70U76E' , 'B003NNUI1C' , 'B003NNUI1W' , 'B002P6843M' , 'B007YDMP5Y' , 'B009ALUL8G' , 'B009AM5TPU' , 'B006OTAVIM' , 'B008RFP2JE' , 'B00ASUTEX6' , 'B007N0JEW0' , 'B008ADXTKM' , 'B00186JD9Y' , 'B005FD3XS8' , 'B0089VDNXS' , 'B003EYUR8O' , 'B008I19YXM' , 'B00B8N7Q3C' , 'B007A6A9LW' , 'B009SF4H1G' , 'B0097JS52A' , 'B009ELCP8Q' , 'B007J8Y90S' , 'B00B3Q2X4G' , 'B00B3Q9SQM' , 'B00B3QKGFY' , 'B00B3QRY18' , 'B00B3QXTDA' , 'B00B4482Y2' , 'B00B46FPTU' , 'B00B46NY4S' , 'B00B46ZG7Q' , 'B00B3R4PAK' , 'B00B46ST0M' , 'B00B46VSNW' , 'B00B4745NG' , 'B00B42IPBY' , 'B00BIF2MWK' , 'B008LU4HKK' , 'B006TSVMFO' , 'B008IXW8E2' , 'B008IXUAV0' , 'B001TOZTYS' , 'B008IXX21A' , 'B00ASUTDXC' , 'B006FDXUS0' , 'B0090Y6IQW' , 'B00813BHXW' , 'B008RFNIEA' , 'B0076RY36C' , 'B00BJGVN7I' , 'B00ASUUS0O' , 'B006OHOXQA' , 'B009A4X73Y' , 'B00B4482Y2' , 'B00B3R4PAK' , 'B00B46ZG7Q' , 'B005EE56O2' , 'B004VDI9GE' , 'B0041IYYVS' , 'B005G79WXS' , 'B00AFNUKQG' , 'B009VXFY08' , 'B00AHRR5A4' , 'B004HKI2WC' , 'B006FEG0CM' , 'B00AT9ZCUA' , 'B0095D4YX2' , 'B008U4QD8G' , 'B0094A3WMA' , 'B007B8X4HA' , 'B008ERH630' , 'B00ASUTDIM' , 'B004NG8644' , 'B006B2LRR6' , 'B007V9B7JG' , 'B007M7X1BO' , 'B003WIG9FC' , 'B007E5VMBU' , 'B00ASUUOD0' , 'B008RFNACK' , 'B0090Y9MQ0' , 'B009NMY03O' , 'B008J817EI' , 'B00ANM4MC2' , 'B00A4X2E3E' , 'B00A1ZQB3O' , 'B00A6MGIWG' , 'B00AH4N0BA' , 'B0098U4XKQ' , 'B0098UIHA8' , 'B0098UO1EY' , 'B0098URXMG' , 'B00APBPGIA' , 'B0098U4XKQ' , 'B0098UIHA8' , 'B0098UO1EY' , 'B009GCBBU6' , 'B009SG1L0U' , 'B008WXWNPW' , 'B003SE5WHQ' , 'B0089HEZ6G' , 'B008RFNCK0' , 'B006FDWIEW' , 'B00A7OKG44' , 'B008VOIXCE' , 'B008YSS2AU' , 'B009RG7IBC' , 'B008XW57NW' , 'B00855LUO2' , 'B00ANITW3K' , 'B00BLZMNKS' , 'B00BLZMKEW' , 'B00B5QRNLC' , 'B00ASIRESA' , 'B009EOXGTU' , 'B00A2LO2VK' , 'B00B58OFPC' , 'B00ARARQP0' , 'B00405RHFC' , 'B00AAQUKRM' , 'B004IYJKC8' , 'B00A2LO6P2' , 'B00A2LNRXY' , 'B00A2LNOQE' , 'B009C03VZ0' , 'B00B58OANO' , 'B00B58OACU' , 'B008BQD0YS' , 'B00AZSR1JU' , 'B008EGWZQY' , 'B009VYCTWI' , 'B008EGWZQY' , 'B008TMO9DU' , 'B00B6ZF91S' , 'B00AR9SO1Q' , 'B00BQ8R8TG' , 'B00BQ8RO22' , 'B00A9Q00YQ' , 'B009P0TNC2' , 'B009P0TMR8' , 'B009GQROHQ' , 'B00BJBZLZS' , 'B008616S7E' , 'B009ELQCHG' , 'B00AZE7ZRW' , 'B00AZE80H6' , 'B003ZHU3Q6' , 'B008709GKK' , 'B006U8X8LO' , 'B005TC9EXS' , 'B001MVID00' , 'B004GTY82M' , 'B00ASIQ5JE' , 'B0032FP9D8' , 'B0032FP9CE' , 'B008M20JJA' , 'B00ASUU8Q8' , 'B0042P6P4E' , 'B0094DBEIG' , 'B00A6MGIWQ' , 'B00AFODYKE' , 'B008RFNETE' , 'B008RFNE5I' , 'B008I001MG' , 'B009S5W8RQ' , 'B00AGD3XC8' , 'B00AH6JTW2' , 'B006JI04Z8' , 'B006JI05YS' , 'B006PA18FK' , 'B007T5I8C6' , 'B008N6WCX6' , 'B00ABCDQFI' , 'B009ZR3TMK' , 'B009WEZ6L8' , 'B00ABCDMLQ' , 'B009R0VCCO' , 'B00ABCDQFI' , 'B008MVHAN4' , 'B008CV6ZBW' , 'B00B4LIT7U' , 'B00B4LIOOS' , 'B00BIECK0K' , 'B00ABX9TWG' , 'B00AJHKR2A' , 'B00A86PP6U' , 'B00A86R99G' , 'B003OA3VH2' , 'B007AP80IW' , 'B007F9QV70' , 'B004FTOZ08' , 'B007AC7XR4' , 'B005LU31PK' , 'B007IPQXV0' , 'B006V9N8BW' , 'B004QZB15I' , 'B00A15S4MK' , 'B0030DFE8W' , 'B003ELOSCI' , 'B006HXO3HK' , 'B006GLSDWY' , 'B004PEIC8O' , 'B007EHAA0M' , 'B0058LUFE2' , 'B009ZQX10G' , 'B004BJ2D6A' , 'B00AHU0J4A' , 'B008MLW1GU' , 'B004WB12BO' , 'B007SICBTK' , 'B001AHJJJA' , 'B00495ZAWU' , 'B004ZJC7YE' , 'B002ZOU4SW' , 'B003YXZ1TA' , 'B00422LY48' , 'B0029NZUW4' , 'B00186JD9O' , 'B0087OXTJA' , 'B00775A7L8' , 'B00A0DQZY2' , 'B008D8CJSW' , 'B0094E3WO4' , 'B0029NZUZQ' , 'B007K4FWJS' , 'B007W1ORJK' , 'B006TU0NBQ' , 'B007THPRE6' , 'B007K4FU0O' , 'B003OA59TK' , 'B008EHMKYK' , 'B008EHOE4O' , 'B005AEP0Z6' , 'B005AEP1IC' , 'B004J18UXU' , 'B00855M80M' , 'B00855MBPO' , 'B001OC699Y' , 'B007K48SMQ' , 'B0017QUZSS' , 'B0017R09Q0' , 'B0010MAHG4' , 'B0010MAPXY' , 'B008VNCHUO' , 'B009T1D5P8' , 'B004I8VABI' , 'B0081Z0EGQ' , 'B0031ET3L4' , 'B004THYRL8' , 'B0079VM4F2' , 'B0031Y7Q7M' , 'B007TS8YK4' , 'B005WQ27K8' , 'B0079JKQ2C' , 'B007JT6Z9A' , 'B007HYU318' , 'B007ELOK68' , 'B008XW532C' , 'B008VOIXCE' , 'B0060IEHGY' , 'B004HKI5BK' , 'B004OQ0FX8' , 'B004ASNZUA' , 'B004ASNZWI' , 'B004IYJIIO' , 'B003OA3UPK' , 'B002LA34KA' , 'B003MS1BX2' , 'B009E1L1N6' , 'B008RFMSBO' , 'B003TSCUDA' , 'B009X77J64' , 'B0087LRRXW' , 'B004AM6CLK' , 'B004AM6CNS' , 'B007G4H7YU' , 'B004FTOZ08' , 'B004XUPVZC' , 'B0087YMQYE' , 'B002CZP8FI' , 'B008AFUUKM' , 'B008AE4ZVS' , 'B0080KKXMW' , 'B00ADGYNRC' , 'B00BYPJJ66' , 'B00B1NL6U8' , 'B00ADGYND6' , 'B007Y44MUY' , 'B00B4NBOTI' , 'B00ABX9VVA' , 'B00B4LK3WY' , 'B008331HD0' , 'B00B1NA62M' , 'B00B1NA62M' , 'B007NFDNHW' , 'B007PMQVPY' , 'B007A2L5PA' , 'B007FNGPH2' , 'B009SG1L0A' , 'B00ASIQ8DC' , 'B008RFMG5W' , 'B00AVS3Z08' , 'B001871SCS' , 'B0062ID8LM' , 'B008MFZA46' , 'B0095AZTH0' , 'B008MT9O2G' , 'B007HZZ8F8' , 'B008GB6NKG' , 'B008BRXBNC' , 'B007VLRR6G' , 'B007VLRQH6' , 'B00C1B2LV2' , 'B009HJ4DM6' , 'B009HKG0GC' , 'B003Z9KM3I' , 'B00AFODWJC' , 'B003OA3UOG' , 'B00B17JIXQ' , 'B00A8AJ9AO' , 'B005LUL4L8' , 'B008EGXAMC' , 'B00BLCPFVK' , 'B005B7AXF4' , 'B003PJ6ZJS' , 'B0051K85K6' , 'B0096FEX0I' , 'B008RFMO4A' , 'B007STN922' , 'B009YT054E' , 'B00B1O9VYU' , 'B00AXUKANY' , 'B00B1OA26Q' , 'B00B1OA1GW' , 'B00ARBS590' , 'B00B6ZFA3A' ) ORDER BY UPDATE_TIME DESC )AS TP GROUP BY TP.SITE_ID, TP.PRODUCT_CODE
3166598479956815359pis2013-05-04 00:58:082013-05-04 11:38:06334.801211.94610.00020.00007688619331SELECT DISTINCT ppr.category_id_lv2 as item_key , ppr.category_name_lv2 as item_value FROM T_YHD_PRODUCT_CATEGORY ppr
12810663936458699799pis2013-05-04 07:12:562013-05-04 23:42:543427.6310.8570450.0029620.000113596341SELECT ID, CATEGORY_ID_LV1, CATEGORY_ID_LV2, BRAND, MERCHANT_ID, DEC_PRICE_ADOPT_COMPLETE_AMO, DEC_PRICE_ADOPT_PROCESSING_AMO, DEC_PRICE_NOT_ADOPT_NOT_REASON_AMO, DEC_PRICE_NOT_ADOPT_HAVE_REASON_AMO, DEC_PRICE_NOT_ADOPT_NEW_PRICE_AMO, DEC_PRICE_NOT_ADOPT_SELF_CHANGE_AMO, DECREASE_PRICE_NOT_REACT_AMOUNT, INC_PRICE_ADOPT_COMPLETE_AMO, INC_PRICE_ADOPT_PROCESSING_AMO, INC_PRICE_NOT_ADOPT_NOT_REASON_AMO, INC_PRICE_NOT_ADOPT_HAVE_REASON_AMO, INC_PRICE_NOT_ADOPT_NEW_PRICE_AMO, INC_PRICE_NOT_ADOPT_SELF_CHANGE_AMO, INCREASE_PRICE_NOT_REACT_AMOUNT, CREATE_TIME, TIME_TYPE, JOB_RUN_TIME FROM T_PRICING_TRACK_REPORT WHERE TO_DAYS(CREATE_TIME) < TO_DAYS(NOW()) ORDER BY CREATE_TIME DESC LIMIT 1
12633800433906396939pis2013-05-04 01:03:292013-05-04 07:00:517823.66430.4328660.0059960.000098128322152284SELECT ID id, SITE_ID siteId, TYPE type, FILE_PATH filePath, CREATE_TIME createTime, UPDATE_TIME updateTime, CONTENT content FROM T_CRAWLERMGR_CONF ORDER BY UPDATE_TIME DESC
9719434314791848575pis2013-05-04 10:57:592013-05-04 21:57:57414.56753.70410.0004040.000119276200005000SELECT distinct pbk.product_code FROM T_YHD_PRODUCT pbk,T_YHD_PRODUCT_CATEGORY ppr WHERE pbk.product_id = ppr.product_id and pbk.product_type <> 1 and pbk.product_type <> 3 AND (ppr.category_id_lv2 =950340 or ppr.category_id_lv3 =950340 or ppr.category_id_lv4 =950340 or ppr.category_id_lv5 =950340 ) AND pbk.can_show = 1 AND pbk.is_gift = 0 AND pbk.MARCHENT_ID in ( 1 , 2 , 3 , 8 ) order by pbk.product_code ASC limit 5000
6656938958379425913pis2013-05-04 05:58:102013-05-04 05:58:10114.45614.4560.0000550.00005500insert into T_PRICING_RESULT_HIS select * from T_PRICING_RESULT WHERE CREATE_TIME < '2013-05-04 00:00:00'
14940449752034288830pis2013-05-04 05:58:232013-05-04 05:58:23112.988312.98830.0000460.00004600delete from T_PRICING_RESULT WHERE CREATE_TIME < '2013-05-04 00:00:00'
7276400147147321848pis2013-05-04 08:58:142013-05-04 14:58:182111.85750.8162340.0017540.0001252391507909553.44select ID, PRODUCT_ID, PRODUCT_NAME, PRODUCT_CODE, OPPON_PRODUCT_CODE, OPPON_PRODUCT_NAME, OPPON_PRODUCT_URL, SITE_ID, SCORE, CREATE_TIME, IS_MANUAL, CREATOR_ID, IS_DELETE, IS_AUTO, IS_CONFIRM, DATA_STATUS, MERCHANT_ID, UPDATE_TIME, IS_CHAMPION, IS_CANDIDATE, FORMULA_YMBOLS, FORMULA_NUMBER, REMARKS, IS_BARCODE, IS_DOUBT, IS_INSHOP FROM T_MATCH WHERE IS_DELETE = 0 AND IS_CONFIRM = 1 AND SITE_ID = 1002 LIMIT 10000 OFFSET 40000
10141560581724573013pis2013-05-04 11:56:352013-05-04 11:56:35110.365110.36510.0046330.00463316831683SELECT wcc.PRODUCT_ID AS productId, wcc.PRODUCT_CODE AS productCode, wcc.SITE AS site, wcc.PRICE AS price, wcc.AREA as area, wcc.UPDATE_DATE as updateDate, wcc.COLLECT_DATE as collectDate, wcc.CREATE_DATE as createDate FROM T_TEMP_WCC AS wcc WHERE wcc.CREATE_DATE = '2013-04-26 11:35:33' AND wcc.PRODUCT_CODE in ( '0048894684' , '0009830937' , '0047499365' , '0020185619' , '0009608575' , '0024412348' , '0047499354' , '0009608586' , '0077356253' , '0048339986' , '0016891535' , '0047892535' , '0024412337' , '0048339997' , '0000387699' , '0047499376' , '0049005712' , '0071906724' , '0024412326' , '0000352114' , '0026772281' , '0017627111' , '0022400813' , '0047499321' , '0009608531' , '0047892513' , '0017627122' , '0026772292' , '0065075301' , '0077356208' , '0022400802' , '0071906702' , '0047499310' , '0065075312' , '0026772258' , '0009608553' , '0015770748' , '0026772270' , '0077356231' , '0026772269' , '0009608564' , '0043023707' , '0010795898' , '0026772236' , '0070521685' , '0044104418' , '0044104430' , '0026772247' , '0020185686' , '0017027075' , '0044104429' , '0047499309' , '0026772214' , '0020185664' , '0022400824' , '0070427428' , '0048894639' , '0024319720' , '0049005701' , '0019957416' , '0009624719' , '0009964027' , '0048894640' , '0030978622' , '0021545244' , '0009987831' , '0009830971' , '0026772203' , '0024412304' , '0048894651' , '0009987820' , '0009830960' , '0024319708' , '0021545233' , '0010188906' , '0009964050' , '0009987819' , '0021545222' , '0018859217' , '0048894662' , '0018859206' , '0021545211' , '0048894673' , '0021545277' , '0009987864' , '0054907436' , '0070427360' , '0009706745' , '0017600383' , '0009987875' , '0021545288' , '0070427359' , '0054907425' , '0009706734' , '0009829612' , '0010367972' , '0021545255' , '0070521630' , '0000456791' , '0022239209' , '0010367938' , '0022239210' , '0009706767' , '0062092288' , '0070521629' , '0009829601' , '0072245853' , '0009624720' , '0021545266' , '0009706756' , '0010196039' , '0065107633' , '0010367950' , '0072245864' , '0070521618' , '0010367916' , '0062565553' , '0020197211' , '0062092266' , '0060192190' , '0065107622' , '0024319673' , '0032944686' , '0017600349' , '0060151691' , '0010868914' , '0070521641' , '0062565564' , '0050308435' , '0072245886' , '0020197200' , '0062092277' , '0024319684' , '0065107611' , '0017600338' , '0071924204' , '0050308468' , '0010266894' , '0021545299' , '0070521674' , '0017600372' , '0065107600' , '0009829645' , '0009706723' , '0000456746' , '0070521663' , '0017600361' , '0062565586' , '0020197222' , '0060151680' , '0032944697' , '0000456757' , '0009706712' , '0017600305' , '0073831068' , '0071924226' , '0048339931' , '0078520635' , '0024595399' , '0022239265' , '0062565520' , '0071924215' , '0048339920' , '0024595388' , '0017600327' , '0048339919' , '0024412291' , '0062565531' , '0054907481' , '0071924237' , '0048339908' , '0073831035' , '0078520646' , '0071906791' , '0047499398' , '0009706789' , '0022239232' , '0054907470' , '0075850805' , '0071906780' , '0048339975' , '0000387677' , '0009706790' , '0009706778' , '0022239221' , '0000352103' , '0048339964' , '0060905499' , '0054907469' , '0000387666' , '0038971367' , '0073831080' , '0054907458' , '0054642476' , '0037149001' , '0054907447' , '0048339942' , '0000218804' , '0017995345' , '0073831079' , '0068735035' , '0026772178' , '0030560613' , '0026772190' , '0068735046' , '0030560602' , '0000352238' , '0010933309' , '0010655739' , '0076452045' , '0016865795' , '0020598612' , '0073831104' , '0020185722' , '0068735024' , '0018859193' , '0073831115' , '0046928727' , '0068735079' , '0073831126' , '0042034402' , '0046928738' , '0068735080' , '0018859171' , '0046928749' , '0073831137' , '0018859160' , '0037503096' , '0068735057' , '0073831148' , '0018859148' , '0068735068' , '0075078238' , '0047499423' , '0010266907' , '0018859137' , '0000409223' , '0075068121' , '0070531087' , '0022400733' , '0011669300' , '0068735091' , '0010266929' , '0060104258' , '0046928705' , '0000025058' , '0075078227' , '0010266918' , '0010510904' , '0020185755' , '0011669322' , '0010266941' , '0060104270' , '0075068176' , '0075078205' , '0011669311' , '0010266930' , '0022484317' , '0000386243' , '0021545368' , '0022484328' , '0010266963' , '0022484340' , '0011669333' , '0022484339' , '0021545357' , '0076452090' , '0010266952' , '0009987944' , '0075068143' , '0009987966' , '0021545379' , '0010266974' , '0038971447' , '0022100965' , '0009706643' , '0018867179' , '0022187048' , '0010266985' , '0024479774' , '0038971436' , '0022100954' , '0000386221' , '0038971470' , '0075078192' , '0038971469' , '0022100943' , '0009706621' , '0009563988' , '0038971458' , '0022100932' , '0024479752' , '0009706610' , '0011370335' , '0049483887' , '0000456871' , '0013249746' , '0009706609' , '0015948717' , '0011370324' , '0013249757' , '0062565677' , '0017995276' , '0015948728' , '0056508588' , '0066999299' , '0017995287' , '0062565688' , '0048669370' , '0024479796' , '0000456826' , '0048431987' , '0062565655' , '0037503110' , '0050812254' , '0020675621' , '0030560577' , '0062565666' , '0073831159' , '0050812265' , '0030560544' , '0000456848' , '0062565633' , '0048541259' , '0050812276' , '0030560555' , '0072788137' , '0009706698' , '0000456860' , '0073831171' , '0062565644' , '0009706687' , '0026565582' , '0022100921' , '0062565611' , '0010767358' , '0000387779' , '0000352205' , '0009706676' , '0052440990' , '0026565571' , '0062565622' , '0042034377' , '0000387768' , '0073831193' , '0009706665' , '0051588068' , '0026565560' , '0042034388' , '0026565559' , '0030560599' , '0009706654' , '0029861992' , '0051588057' , '0037503132' , '0042034399' , '0062565600' , '0026565548' , '0018102642' , '0027310083' , '0052440923' , '0068614799' , '0039579878' , '0018102653' , '0039579890' , '0017301994' , '0039579889' , '0011087595' , '0065327415' , '0060113760' , '0060113726' , '0018698903' , '0052440901' , '0017301983' , '0065100916' , '0068614777' , '0060113737' , '0060112609' , '0010655831' , '0017301972' , '0068614766' , '0010655864' , '0054645920' , '0027310038' , '0060113793' , '0052440967' , '0010655853' , '0052440956' , '0060113771' , '0031176746' , '0027310016' , '0052440945' , '0010872409' , '0049522136' , '0060113782' , '0052440934' , '0022484204' , '0026752181' , '0068614711' , '0071281840' , '0071110286' , '0073950808' , '0070066396' , '0017600178' , '0024507968' , '0018698969' , '0025150918' , '0054645964' , '0011548520' , '0073950820' , '0024507980' , '0022484215' , '0026752192' , '0068614700' , '0017600190' , '0071281851' , '0071110275' , '0011370755' , '0017600189' , '0024507979' , '0018698958' , '0073950819' , '0070066385' , '0010608012' , '0054645953' , '0025150929' , '0020185404' , '0011548519' , '0073950831' , '0017626163' , '0000456484' , '0071281862' , '0025150930' , '0054645942' , '0017626174' , '0019424794' , '0071281873' , '0025150941' , '0054645931' , '0018698970' , '0020185460' , '0011370788' , '0071281806' , '0019424783' , '0020185459' , '0018698925' , '0038160337' , '0060113704' , '0068614744' , '0025150963' , '0011370799' , '0071281817' , '0020185448' , '0018698914' , '0038160326' , '0075850690' , '0054645997' , '0060113715' , '0025150974' , '0011370766' , '0068614733' , '0060112643' , '0050007084' , '0071281828' , '0017719709' , '0026752158' , '0020185437' , '0054645986' , '0070066374' , '0018698947' , '0038160315' , '0011370777' , '0050007073' , '0026752170' , '0019424750' , '0071281839' , '0026752169' , '0054645975' , '0018698936' , '0017600101' , '0009706949' , '0016048412' , '0011669297' , '0009700009' , '0000456531' , '0056489226' , '0055711041' , '0019424738' , '0040330936' , '0016377041' , '0022484293' , '0016048423' , '0042555099' , '0049351237' , '0017600123' , '0000456508' , '0009706961' , '0016048434' , '0011669275' , '0049797979' , '0022239414' , '0022484282' , '0016377029' , '0010619053' , '0056489248' , '0020185471' , '0009700021' , '0017600112' , '0055711029' , '0056489260' , '0022239403' , '0022484271' , '0011669286' , '0073950795' , '0016377018' , '0056489259' , '0019424727' , '0009700010' , '0011669253' , '0018698992' , '0009706983' , '0071281771' , '0043964905' , '0022484259' , '0016377007' , '0022239425' , '0011669264' , '0009563864' , '0017600134' , '0010193176' , '0019424705' , '0071281760' , '0009563853' , '0010193165' , '0071281793' , '0022484237' , '0067235658' , '0016048401' , '0017600156' , '0071281782' , '0043964916' , '0031176735' , '0062565702' , '0010539545' , '0031176724' , '0062565713' , '0010539556' , '0052440854' , '0031176713' , '0031176702' , '0010539578' , '0065100905' , '0018699008' , '0018699019' , '0010655900' , '0018699031' , '0010655911' , '0016048489' , '0060631712' , '0070066454' , '0068614664' , '0060113851' , '0071110300' , '0010655955' , '0072441997' , '0071906804' , '0070066443' , '0068614653' , '0060113862' , '0010655944' , '0070066432' , '0068614686' , '0071110322' , '0060113873' , '0010655933' , '0071906826' , '0012721947' , '0018699053' , '0060112745' , '0070066421' , '0068614675' , '0071110311' , '0060113884' , '0010655922' , '0070066410' , '0000440664' , '0047499274' , '0070066409' , '0060113895' , '0068614697' , '0000218860' , '0012721969' , '0018696076' , '0000440675' , '0012721970' , '0010655988' , '0047499263' , '0020861692' , '0022265378' , '0010655977' , '0050788799' , '0012721981' , '0022265389' , '0000440653' , '0012721992' , '0010655966' , '0065249447' , '0019424681' , '0050660565' , '0065249458' , '0019424670' , '0062092313' , '0009987706' , '0071110344' , '0070066498' , '0075850781' , '0020185551' , '0060113806' , '0062092335' , '0040330914' , '0071110333' , '0070066487' , '0075850792' , '0060113817' , '0018697922' , '0026752261' , '0040330903' , '0070066476' , '0068614642' , '0016377085' , '0062092357' , '0026752272' , '0060113840' , '0018697900' , '0009706905' , '0070066465' , '0016377096' , '0062092346' , '0026752249' , '0044104452' , '0020197119' , '0009706847' , '0020185584' , '0020197120' , '0075850747' , '0049482511' , '0009987762' , '0021545175' , '0024595413' , '0026752238' , '0020847089' , '0020197108' , '0017600236' , '0021545186' , '0049482500' , '0009987773' , '0024595402' , '0044104474' , '0009706825' , '0022484180' , '0075850770' , '0017600225' , '0021545197' , '0075850769' , '0009706814' , '0044104463' , '0017600214' , '0075850758' , '0022484168' , '0026564250' , '0026752205' , '0009705355' , '0022239334' , '0044104496' , '0022484113' , '0009706892' , '0040330878' , '0043023683' , '0020197164' , '0017600292' , '0071110297' , '0010585929' , '0009829714' , '0033198946' , '0009705344' , '0000456677' , '0040330890' , '0022239323' , '0022484102' , '0009987739' , '0043023694' , '0020197153' , '0017600281' , '0021545142' , '0017600269' , '0000386470' , '0046927382' , '0022484135' , '0021545153' , '0020197142' , '0017600270' , '0017600258' , '0060631698' , '0009706858' , '0022239301' , '0000386458' , '0024595424' , '0021545164' , '0023661736' , '0043023672' , '0020197131' , '0060151704' , '0074960148' , '0009705311' , '0022239378' , '0020197197' , '0074960137' , '0026564283' , '0046712565' , '0020197186' , '0074960126' , '0047499285' , '0049654797' , '0022239356' , '0016532200' , '0000440697' , '0026564272' , '0074960115' , '0047499296' , '0022239345' , '0016532211' , '0016048387' , '0026564261' , '0074960104' , '0000210060' , '0070493515' , '0017600203' , '0060151771' , '0022239389' , '0050309096' , '0000465203' , '0021364932' , '0077232963' , '0050309085' , '0021364943' , '0083038339' , '0011873420' , '0031176597' , '0021364954' , '0077232941' , '0053363250' , '0053363249' , '0021364965' , '0050309052' , '0011649595' , '0061596494' , '0073831422' , '0072043802' , '0050309041' , '0021364909' , '0077232929' , '0083550850' , '0013144564' , '0083550849' , '0011792293' , '0073831411' , '0050309074' , '0061596472' , '0058748133' , '0013144553' , '0021364910' , '0073831400' , '0083550816' , '0011792282' , '0010543698' , '0050309063' , '0077232907' , '0061596461' , '0021364921' , '0011792271' , '0060113566' , '0011792260' , '0073831466' , '0024220788' , '0009647396' , '0016891988' , '0061596449' , '0011792259' , '0011649551' , '0070066501' , '0000470008' , '0068050544' , '0073831455' , '0020174792' , '0025150792' , '0053042356' , '0011792248' , '0070066512' , '0028047021' , '0073831444' , '0011649573' , '0010434829' , '0070066523' , '0022148385' , '0011792237' , '0020874106' , '0073831433' , '0060113533' , '0056157007' , '0022148396' , '0011649584' , '0010434818' , '0011792226' , '0011649506' , '0075077020' , '0037303983' , '0011792215' , '0025150769' , '0027270311' , '0073831499' , '0011792204' , '0076206558' , '0025150781' , '0075077042' , '0011649528' , '0073831488' , '0060113500' , '0027270333' , '0076206525' , '0075077031' , '0039030143' , '0025150770' , '0011649539' , '0073831477' , '0027270322' , '0037303994' , '0028047009' , '0076206514' , '0011143014' , '0078774046' , '0000391253' , '0009647443' , '0059784928' , '0016891911' , '0011143025' , '0054492454' , '0022148443' , '0010971730' , '0021803645' , '0012091688' , '0017027508' , '0011143036' , '0059784940' , '0022148432' , '0010096078' , '0054492443' , '0021803678' , '0009647465' , '0016864725' , '0010434783' , '0011143047' , '0022148421' , '0078774013' , '0054492432' , '0021803667' , '0016891922' , '0016864714' , '0010434794' , '0054492421' , '0022148498' , '0016864747' , '0009647487' , '0060113475' , '0054492410' , '0027270275' , '0022148487' , '0011143069' , '0044064735' , '0049612002' , '0016864736' , '0010546904' , '0021803689' , '0027270286' , '0022148476' , '0010096034' , '0016864770' , '0010434738' , '0054492409' , '0016864769' , '0016891977' , '0011143081' , '0060113453' , '0010096045' , '0044064757' , '0016864758' , '0011143092' , '0068050533' , '0010365976' , '0049612057' , '0017634376' , '0054430578' , '0050309121' , '0010096012' , '0066955315' , '0010096023' , '0050309132' , '0016864781' , '0083038271' , '0049612035' , '0017634398' , '0083550872' , '0050309143' , '0048340029' , '0009540323' , '0009540312' , '0050309154' , '0048340018' , '0013144600' , '0000191708' , '0022148409' , '0021364987' , '0038160495' , '0048340007' , '0022148410' , '0083038248' , '0009705264' , '0042395584' , '0021364976' , '0038160484' , '0078774079' , '0077232996' , '0017634343' , '0050309109' , '0009705275' , '0038160473' , '0026565048' , '0017634354' , '0077232985' , '0049612068' , '0021364998' , '0051882509' , '0024389104' , '0009647410' , '0051882510' , '0050309110' , '0026565060' , '0037349294' , '0071281715' , '0039030052' , '0025150861' , '0054223108' , '0038160439' , '0061596381' , '0024099954' , '0021364841' , '0011792191' , '0025150850' , '0012878783' , '0025150849' , '0021380518' , '0073831502' , '0024389002' , '0050811091' , '0025150838' , '0038160451' , '0069348603' , '0050309198' , '0025150827' , '0011792157' , '0073831524' , '0071281759' , '0024389080' , '0011792146' , '0050309187' , '0025150816' , '0073831513' , '0000471476' , '0071281748' , '0069798943' , '0037542511' , '0010738155' , '0081386176' , '0050309176' , '0025150805' , '0011792179' , '0073831546' , '0011792180' , '0071281737' , '0000471465' , '0037542500' , '0081386165' , '0013677504' , '0011792168' , '0050309165' , '0038160417' , '0073831535' , '0000471454' , '0071281726' , '0000471443' , '0064452682' , '0012878716' , '0073831568' , '0011370813' , '0068050453' , '0073995058' , '0061596314' , '0000471432' , '0031176622' , '0000478831' , '0064452671' , '0012878727' , '0000378256' , '0073831557' , '0011370802' , '0060113657' , '0081386187' , '0010738144' , '0000478808' , '0010539181' , '0064452660' , '0031176655' , '0064452659' , '0076179992' , '0009769113' , '0000471410' , '0073831579' , '0011370824' , '0068050420' , '0060113679' , '0037349216' , '0064452648' , '0000378289' , '0000478864' , '0020174861' , '0000471409' , '0076206638' , '0033099853' , '0039030018' , '0010539169' , '0000355511' , '0012878761' , '0000478875' , '0025150894' , '0000378290' , '0000391037' , '0039030029' , '0011143116' , '0076179925' , '0012878772' , '0060113646' , '0039030030' , '0025150883' , '0068050475' , '0012878738' , '0000378267' , '0031176699' , '0000391048' , '0011143105' , '0037349272' , '0060113635' , '0025150872' , '0031176688' , '0064452693' , '0012878749' , '0076206672' , '0041319997' , '0012878750' , '0037349261' , '0065122158' , '0016891819' , '0009769066' , '0017634434' , '0017846081' , '0011143161' , '0060151997' , '0009769055' , '0017634445' , '0060151986' , '0009647578' , '0017634412' , '0011143138' , '0075077053' , '0009647567' , '0015698983' , '0017634423' , '0011143149' , '0009769077' , '0075077064' , '0076206616' , '0011143150' , '0022148352' , '0021803598' , '0016891853' , '0017634401' , '0010539205' , '0010452230' , '0046712327' , '0049612104' , '0000352681' , '0016891842' , '0050811104' , '0022148374' , '0080847490' , '0031176600' , '0021803576' , '0017846025' , '0060151975' , '0016891831' , '0011143183' , '0049612137' , '0043455294' , '0022148363' , '0067587422' , '0038160393' , '0050309267' , '0073437419' , '0049612160' , '0073437420' , '0050811126' , '0000386685' , '0050309278' , '0025150907' , '0018698890' , '0050811115' , '0042690653' , '0050309245' , '0050811148' , '0021364896' , '0050309256' , '0073437431' , '0050309223' , '0050786351' , '0021364885' , '0042690686' , '0017634478' , '0024099910' , '0011108502' , '0050309234' , '0065509764' , '0017634490' , '0021364874' , '0049612193' , '0024099921' , '0042690697' , '0017634489' , '0050811159' , '0038160348' , '0050309201' , '0009647523' , '0009654006' , '0000386652' , '0048569308' , '0038160371' , '0017634456' , '0024099932' , '0011873431' , '0050309212' , '0000386663' , '0000286715' , '0069348670' , '0024099943' , '0069348669' , '0042690675' , '0017634467' , '0011873442' , '0072757938' , '0054893991' , '0054430421' , '0042690711' , '0050309290' , '0037377858' , '0000471330' , '0019835451' , '0050309289' , '0072757949' , '0054430410' , '0042690700' , '0020185891' , '0080155175' , '0037377869' , '0076206398' , '0019835484' , '0000471363' , '0072757916' , '0054430443' , '0042690733' , '0039415220' , '0054893968' , '0018696394' , '0019835473' , '0000471352' , '0054893980' , '0037377881' , '0054430432' , '0054893979' , '0020185879' , '0076206376' , '0000471385' , '0039415242' , '0037349192' , '0054893946' , '0000471374' , '0068050384' , '0054893957' , '0061596289' , '0080155131' , '0054430409' , '0017771492' , '0000471396' , '0072757972' , '0054893935' , '0018696361' , '0011792453' , '0054893902' , '0020279236' , '0020185802' , '0081387862' , '0070531189' , '0017771481' , '0065263458' , '0022201316' , '0070531190' , '0011792442' , '0054893913' , '0065263470' , '0012151336' , '0081316076' , '0065263469' , '0056171778' , '0011792431' , '0080847547' , '0077233068' , '0065263481' , '0081387840' , '0037542497' , '0073831240' , '0011792420' , '0077233079' , '0037542486' , '0065263492' , '0077233080' , '0065320641' , '0081316098' , '0050097080' , '0073831239' , '0070424974' , '0049794209' , '0077233046' , '0022201361' , '0000146327' , '0073831228' , '0027849667' , '0000478922' , '0050097091' , '0070531145' , '0065263414' , '0081387895' , '0077233057' , '0011792486' , '0000146316' , '0072757905' , '0065263425' , '0081387884' , '0020185824' , '0020279214' , '0010580708' , '0011792475' , '0080847503' , '0077233024' , '0017634605' , '0022201338' , '0073831206' , '0019835440' , '0016891762' , '0065263436' , '0042774618' , '0081316043' , '0070531123' , '0081387873' , '0012151314' , '0049794210' , '0080847514' , '0077233035' , '0065263447' , '0016891773' , '0070531134' , '0065320685' , '0009706541' , '0081316112' , '0070531112' , '0078774239' , '0060541653' , '0065195064' , '0078774240' , '0049794118' , '0009706552' , '0070531101' , '0000191559' , '0000386709' , '0017634503' , '0049794129' , '0043671029' , '0081316134' , '0017019102' , '0009706563' , '0065263403' , '0065195042' , '0078774217' , '0017846161' , '0060541631' , '0054905781' , '0049794130' , '0083037494' , '0081316123' , '0065195053' , '0049794141' , '0083038099' , '0080847570' , '0009706585' , '0000386732' , '0017634536' , '0058617097' , '0009835589' , '0049794152' , '0060541620' , '0083037416' , '0011792419' , '0080847569' , '0049794163' , '0050309303' , '0024780210' , '0083037449' , '0058617075' , '0017634558' , '0010539136' , '0073691631' , '0049794174' , '0012151278' , '0083037450' , '0044292026' , '0080847581' , '0050309314' , '0017634570' , '0083037438' , '0058617086' , '0017634569' , '0012151289' , '0018696305' , '0049794196' , '0076228198' , '0058617053' , '0017634581' , '0054430385' , '0050309325' , '0076228187' , '0058617064' , '0054430396' , '0050309336' , '0000387837' , '0083038022' , '0058617031' , '0058617042' , '0050309358' , '0076228154' , '0042690744' , '0058617019' , '0080307375' , '0054430341' , '0050309369' , '0058617020' , '0009706507' , '0050309370' , '0054430352' , '0000573193' , '0000210322' , '0076228176' , '0050309381' , '0009706518' , '0054893899' , '0026967588' , '0054430363' , '0076228165' , '0058617008' , '0009706529' , '0050309392' , '0054893888' , '0083038055' , '0026967577' , '0054430374' , '0000471249' , '0028220011' , '0076206489' , '0042268633' , '0054430567' , '0050097104' , '0013509450' , '0020185982' , '0011792395' , '0068615305' , '0028220000' , '0013509449' , '0054430556' , '0050097115' , '0020185993' , '0068615316' , '0080066008' , '0054430545' , '0065107586' , '0013509472' , '0009540334' , '0020279190' , '0080066019' , '0010580695' , '0083550963' , '0080066020' , '0009540345' , '0054430534' , '0081387919' , '0054907936' , '0050097148' , '0054430523' , '0081387920' , '0050097160' , '0081387908' , '0054907925' , '0065107597' , '0050097159' , '0054430512' , '0037349045' , '0083038226' , '0065263378' , '0050097126' , '0054430501' , '0009540378' , '0081387942' , '0011063380' , '0018696452' , '0080155028' , '0068388318' , '0054905805' , '0065263389' , '0054907947' , '0009540389' , '0050097137' , '0081387931' , '0065263390' , '0018696463' , '0038922995' , '0020185904' , '0011792317' , '0081387964' , '0051055562' , '0019835519' , '0073831364' , '0011792306' , '0038922984' , '0081387953' , '0011097657' , '0019835508' , '0065263367' , '0073831353' , '0081387986' , '0020279112' , '0020123426' , '0038922973' , '0011792339' , '0010795901' , '0037349034' , '0054492374' , '0053042685' , '0042399702' , '0011792340' , '0073831386' , '0081387975' , '0011792328' , '0038922962' , '0022357091' , '0073831375' , '0054492396' , '0038922951' , '0080847627' , '0076206445' , '0020185948' , '0000191695' , '0049794107' , '0050822010' , '0069183386' , '0060113420' , '0011792362' , '0060113408' , '0013509483' , '0020185959' , '0038922940' , '0011240009' , '0081387997' , '0050822009' , '0020177848' , '0011792351' , '0020185960' , '0038922939' , '0051055584' , '0044064779' , '0073831342' , '0016891626' , '0050822032' , '0000574083' , '0011792384' , '0014313327' , '0020185971' , '0051055573' , '0019835520' , '0000437923' , '0044064768' , '0009558412' , '0073831331' , '0048339646' , '0011792373' , '0014313316' , '0081316010' , '0016891615' , '0017634638' , '0080232140' , '0038922917' , '0080232151' , '0011087982' , '0000391333' , '0060113351' , '0017634616' , '0077233013' , '0076228234' , '0080232162' , '0078774104' , '0011087993' , '0083037585' , '0053042607' , '0037400343' , '0077233002' , '0073831397' , '0050309427' , '0009706483' , '0011087960' , '0017194853' , '0083037574' , '0009706494' , '0060113384' , '0078774126' , '0076228201' , '0012055128' , '0083037563' , '0051055608' , '0050309405' , '0078774159' , '0027270344' , '0078774160' , '0012055117' , '0083037552' , '0000437887' , '0050309416' , '0080307422' , '0012055106' , '0018696441' , '0083037530' , '0078774182' , '0024138043' , '0022148501' , '0083037529' , '0018696430' , '0017846207' , '0011087937' , '0083037518' , '0083038124' , '0024138021' , '0054430498' , '0083037507' , '0077232872' , '0024138032' , '0078774193' , '0080307466' , '0022148512' , '0049794094' , '0019957392' , '0054430476' , '0069297058' , '0024780174' , '0083038180' , '0054430487' , '0069297069' , '0024780185' , '0069297070' , '0084605390' , '0021547739' , '0054430454' , '0076228278' , '0017846218' , '0011375158' , '0024780152' , '0054430465' , '0083550996' , '0024780163' , '0080065936' , '0068732478' , '0056373310' , '0071468478' , '0080065947' , '0080154989' , '0038454250' , '0050845857' , '0032951056' , '0037709947' , '0054430114' , '0072133234' , '0048005443' , '0024605387' , '0080065958' , '0032951067' , '0017026856' , '0038454261' , '0065924494' , '0072133245' , '0054430103' , '0071468490' , '0024605398' , '0080065969' , '0022357206' , '0071468489' , '0056373309' , '0032951078' , '0080154967' , '0080065970' , '0072133256' , '0065924483' , '0021916847' , '0032951089' , '0077591878' , '0054430170' , '0011872723' , '0073686427' , '0000250088' , '0010267546' , '0054430169' , '0065924472' , '0080065981' , '0016890838' , '0010188199' , '0011872712' , '0024605376' , '0000250099' , '0054430158' , '0080065992' , '0038456507' , '0065924461' , '0018891979' , '0009568427' , '0077591856' , '0048005409' , '0011113589' , '0010188188' , '0011872701' , '0038456518' , '0065924450' , '0021916814' , '0050839117' , '0054430147' , '0000573386' , '0011113590' , '0077591867' , '0011113578' , '0010267579' , '0050839128' , '0038456529' , '0054430136' , '0011142328' , '0000471181' , '0065924449' , '0065924438' , '0010808647' , '0021098248' , '0078020970' , '0011872767' , '0050169114' , '0010267502' , '0077269331' , '0018695471' , '0010808658' , '0027611581' , '0010947805' , '0016890805' , '0021098259' , '0078020981' , '0050169103' , '0011872756' , '0048005498' , '0066857076' , '0080154901' , '0021098260' , '0077269342' , '0065924416' , '0010808625' , '0027611570' , '0044111946' , '0010368179' , '0010267524' , '0011872745' , '0054430192' , '0050169136' , '0021098271' , '0009700601' , '0027611569' , '0010808636' , '0065924405' , '0078020969' , '0044111957' , '0010267535' , '0054430181' , '0050169125' , '0011872734' , '0027611558' , '0072133267' , '0050828278' , '0021916870' , '0010808603' , '0021098204' , '0027611547' , '0026755680' , '0066857021' , '0048005465' , '0013371943' , '0021916869' , '0010808614' , '0049505397' , '0009700656' , '0009830153' , '0011104419' , '0066857032' , '0021916892' , '0050828290' , '0048005487' , '0013371965' , '0010947861' , '0050828289' , '0010266054' , '0021916881' , '0048005476' , '0010947872' , '0011872778' , '0066857112' , '0000475127' , '0011143434' , '0000477270' , '0015463066' , '0010650109' , '0044295183' , '0011143445' , '0080302949' , '0009699723' , '0076675406' , '0066857134' , '0066999937' , '0052817002' , '0011143412' , '0066999926' , '0050169090' , '0009699701' , '0011104395' , '0019078592' , '0000173148' , '0000486920' , '0066999959' , '0048929697' , '0022357193' , '0019078581' , '0058280094' , '0011104384' , '0066999960' , '0011143478' , '0056351907' , '0026248851' , '0010376257' , '0011104373' , '0009699767' , '0011143489' , '0059789978' , '0026248862' , '0010808670' , '0058280072' , '0025892357' , '0018695493' , '0066999982' , '0026248873' , '0058280083' , '0040491314' , '0018695482' , '0010808669' , '0025892346' , '0011143467' , '0059789990' , '0066999971' , '0010406425' , '0022357148' , '0056352035' , '0048929653' , '0075851682' , '0022357160' , '0011033208' , '0019313485' , '0022357159' , '0013509529' , '0022247809' , '0010406403' , '0009699778' , '0022357171' , '0019313496' , '0022247810' , '0048929675' , '0000471136' , '0038456450' , '0022357182' , '0013509552' , '0022247821' , '0048929686' , '0013509563' , '0000471114' , '0038456472' , '0056352079' , '0058667360' , '0022247832' , '0080065903' , '0054430205' , '0020413132' , '0013509574' , '0078521194' , '0022357115' , '0000471125' , '0075851637' , '0022247843' , '0051556231' , '0013509585' , '0012031526' , '0070625591' , '0040866817' , '0022357126' , '0077591903' , '0038456494' , '0080065925' , '0019313452' , '0010926973' , '0048121488' , '0022247854' , '0051556220' , '0013509596' , '0057338064' , '0048994805' , '0075851660' , '0075851659' , '0000475138' , '0022357137' , '0000471103' , '0010926984' , '0080065914' , '0049614702' , '0077591936' , '0019313305' , '0021365026' , '0020186065' , '0054430227' , '0073685402' , '0074481520' , '0039228609' , '0021916972' , '0065120403' , '0040866851' , '0021365037' , '0084542574' , '0060453761' , '0054430216' , '0074481531' , '0040866828' , '0021365048' , '0018891888' , '0077591958' , '0065318652' , '0054430250' , '0018695506' , '0020186043' , '0074481542' , '0054430249' , '0070625502' , '0039228621' , '0021365059' , '0065318641' , '0018891899' , '0032951170' , '0018695517' , '0020186054' , '0054430238' , '0021365060' , '0019180564' , '0040866840' , '0077591970' , '0054430272' , '0013509632' , '0038193781' , '0040866895' , '0000350958' , '0065924574' , '0033015666' , '0009830211' , '0054430261' , '0048005512' , '0038193770' , '0070625513' , '0010947907' , '0021916927' , '0000350969' , '0065924563' , '0054430294' , '0048005501' , '0077591992' , '0024605489' , '0033015699' , '0000471090' , '0013509610' , '0065924596' , '0037545963' , '0021365093' , '0021916916' , '0054430283' , '0084542596' , '0033015688' , '0070625535' , '0024307991' , '0065924585' , '0021916905' , '0073685413' , '0010702917' , '0037545985' , '0065924530' , '0010266123' , '0018695562' , '0065924529' , '0010947941' , '0075827724' , '0010267648' , '0073685479' , '0010702906' , '0010267660' , '0010266134' , '0018695573' , '0065924518' , '0033015622' , '0011104317' , '0010267659' , '0065924552' , '0010266101' , '0077239135' , '0046360661' , '0010947918' , '0018695584' , '0038193769' , '0033015655' , '0011104328' , '0065924541' , '0044608006' , '0037545996' , '0073685457' , '0018695595' , '0010947930' , '0065930907' , '0027374498' , '0011007300' , '0010267637' , '0049614699' , '0033015644' , '0010051726' , '0020186021' , '0050169056' , '0018695528' , '0065318674' , '0066857167' , '0010406287' , '0020186032' , '0075827757' , '0018695539' , '0065318663' , '0066857178' , '0074481508' , '0018695540' , '0022201383' , '0009830266' , '0010947963' , '0065924507' , '0020186009' , '0018695551' , '0073685491' , '0074481519' , '0012376497' , '0022201394' , '0050169023' , '0020186010' , '0009830277' , '0032951136' , '0010947974' , '0065318685' , '0081316156' , '0026755726' , '0080063032' , '0030494021' , '0010406367' , '0011104282' , '0040480884' , '0081316145' , '0030494032' , '0011104271' , '0040480895' , '0010406378' , '0080063009' , '0010266076' , '0012376453' , '0075827780' , '0081316167' , '0030494009' , '0026755759' , '0025892288' , '0030494010' , '0010702951' , '0030494065' , '0014100028' , '0039228596' , '0010702962' , '0014100040' , '0010406334' , '0080063065' , '0078020992' , '0075635460' , '0000208560' , '0011104260' , '0077239102' , '0016736337' , '0014100006' , '0010702928' , '0075635459' , '0010406356' , '0014100017' , '0026755715' , '0018891913' , '0016736315' , '0022201407' , '0000475069' , '0014100073' , '0070625444' , '0018891902' , '0010746346' , '0013509676' , '0000475058' , '0014100084' , '0024605423' , '0009699676' , '0014100051' , '0024605456' , '0000477305' , '0013509654' , '0038456530' , '0030494098' , '0070625466' , '0018891924' , '0014100062' , '0024605445' , '0070625477' , '0040866942' , '0040480840' , '0009699698' , '0070625488' , '0054430307' , '0040480851' , '0013509687' , '0070625499' , '0054430318' , '0040866919' , '0019313316' , '0040480873' , '0038456574' , '0054430329' , '0054430330' , '0024605401' , '0011007297' , '0016890792' , '0040866908' , '0080065743' , '0010418298' , '0069348567' , '0072611746' , '0071468672' , '0027684759' , '0040866953' , '0010267308' , '0084137495' , '0041432159' , '0080065754' , '0010418287' , '0010267320' , '0071468661' , '0010267331' , '0041432148' , '0080065765' , '0010418276' , '0065924698' , '0069348545' , '0084137473' , '0048710072' , '0040866975' , '0080065776' , '0010418265' , '0010267342' , '0065924687' , '0016478630' , '0081763260' , '0044622299' , '0072611713' , '0027684760' , '0048710061' , '0010162682' , '0040866986' , '0071468683' , '0064810022' , '0014014949' , '0010267353' , '0018695620' , '0044622277' , '0014014938' , '0080065710' , '0010267364' , '0084137462' , '0080065709' , '0051695331' , '0084137428' , '0080065721' , '0010656185' , '0018695608' , '0084542687' , '0044622255' , '0084137439' , '0080065732' , '0033015597' , '0084137440' , '0041961084' , '0084542698' , '0020186112' , '0010656163' , '0084137406' , '0065924632' , '0020963944' , '0009700894' , '0010656174' , '0084137417' , '0065924621' , '0010083133' , '0065924609' , '0075852947' , '0071468616' , '0009700883' , '0065924610' , '0014014927' , '0075852936' , '0071468605' , '0020963922' , '0009700872' , '0018696703' , '0020186145' , '0010656152' , '0014014916' , '0011104204' , '0064810033' , '0013258156' , '0071468638' , '0011143296' , '0065120390' , '0065120389' , '0065924676' , '0080065787' , '0064810044' , '0011104215' , '0033099886' , '0023273452' , '0041432193' , '0065924665' , '0080065798' , '0010656130' , '0071468650' , '0072611768' , '0010188382' , '0033099875' , '0065924654' , '0010083188' , '0065120367' , '0069348589' , '0041432182' , '0022614773' , '0084542610' , '0072611757' , '0033099864' , '0011143263' , '0071468649' , '0065924643' , '0041432171' , '0000191980' , '0011104146' , '0019313281' , '0025973017' , '0011143241' , '0013438965' , '0000208673' , '0025973006' , '0027374501' , '0033099977' , '0013438954' , '0022614740' , '0015698938' , '0013438987' , '0022614739' , '0033099944' , '0011143230' , '0027374523' , '0013438976' , '0022614728' , '0033099955' , '0065924701' , '0010188304' , '0018839195' , '0010083213' , '0000208640' , '0014742973' , '0033099922' , '0022614717' , '0027374534' , '0075852958' , '0025973062' , '0075852970' , '0010188315' , '0037544993' , '0011143207' , '0033099933' , '0022614706' , '0013438998' , '0025973051' , '0012997147' , '0075852969' , '0000573513' , '0025973039' , '0020927235' , '0075852981' , '0000208662' , '0014742995' , '0033099900' , '0025973040' , '0012997136' , '0057650074' , '0025973028' , '0000208651' , '0033099911' , '0012997125' , '0012997114' , '0025360661' , '0010267284' , '0019553107' , '0010418323' , '0044622233' , '0012997103' , '0010267273' , '0000478591' , '0010418334' , '0010674803' , '0056097893' , '0025360683' , '0000478580' , '0044622211' , '0025360672' , '0061556976' , '0010267295' , '0011104191' , '0010418312' , '0010985736' , '0010418367' , '0000478546' , '0019313247' , '0010418378' , '0013438943' , '0048564621' , '0019313258' , '0010418345' , '0010985769' , '0075306320' , '0019313269' , '0010694254' , '0080065878' , '0076675393' , '0048564654' , '0009701808' , '0080065890' , '0010368022' , '0080065889' , '0024388963' , '0049363782' , '0048564665' , '0009540878' , '0080065856' , '0048564632' , '0078856403' , '0009540889' , '0080065867' , '0048564643' , '0044628888' , '0009540890' , '0010694209' , '0048929722' , '0050309018' , '0010694210' , '0080065834' , '0041432217' , '0044628877' , '0048929711' , '0080065845' , '0041432206' , '0050309007' , '0050309030' , '0016890996' , '0048929700' , '0020186281' , '0080065812' , '0071468592' , '0067268524' , '0075851706' , '0065318403' , '0018737945' , '0080065823' , '0071468581' , '0041432228' , '0050309029' , '0010694221' , '0009647352' , '0010434647' , '0065924734' , '0022614693' , '0020186270' , '0051043619' , '0010083280' , '0056373229' , '0010188202' , '0073626332' , '0065924723' , '0020186269' , '0073058432' , '0056351974' , '0065924756' , '0009624242' , '0020186236' , '0056373241' , '0073058421' , '0065924745' , '0000573455' , '0010083257' , '0058280130' , '0020186247' , '0056351996' , '0054430078' , '0013258292' , '0073058410' , '0056373252' , '0024506136' , '0010808501' , '0018839140' , '0010188257' , '0073626365' , '0010434681' , '0033099988' , '0012997090' , '0056373263' , '0021637650' , '0009624231' , '0000573477' , '0011143376' , '0073626376' , '0071468514' , '0010434670' , '0054430090' , '0010083291' , '0010188280' , '0056373274' , '0065240359' , '0065924790' , '0010808523' , '0016890918' , '0010188279' , '0056373285' , '0084542701' , '0019088494' , '0011104102' , '0073626354' , '0065924789' , '0011143398' , '0010434658' , '0010188268' , '0069333159' , '0010083315' , '0010808556' , '0000478615' , '0048121524' , '0077269320' , '0069333148' , '0011143343' , '0012014550' , '0065318390' , '0010808545' , '0056097951' , '0000478604' , '0056373296' , '0048121535' , '0078521207' , '0056097928' , '0000478637' , '0012997078' , '0011143365' , '0075852890' , '0078521230' , '0073261515' , '0010808567' , '0048121557' , '0031188428' , '0012997067' , '0022247785' , '0056097984' , '0073261526' , '0065924803' , '0053041900' , '0011649448' , '0010808590' , '0010808589' , '0073261537' , '0065924814' , '0010434727' , '0011649437' , '0075852867' , '0066857009' , '0011649460' , '0000208764' , '0000573411' , '0011143310' , '0073261548' , '0065924825' , '0078521263' , '0041530205' , '0056097973' , '0011649459' , '0000573400' , '0011143321' , '0073261559' , '0065924836' , '0010434705' , '0078521274' , '0000364487' , '0048121513' , '0073261560' , '0080065801' , '0063346849' , '0011649482' , '0013507681' , '0010036916' , '0063346838' , '0011649471' , '0021280104' , '0048929733' , '0084061416' , '0048929744' , '0010406516' , '0011649493' , '0076675360' , '0048121568' , '0076675359' , '0051310544' , '0000478648' , '0010694174' , '0073949301' , '0010406538' , '0048339226' , '0012155156' , '0051310555' , '0076675382' , '0010694185' , '0063346827' , '0060978645' , '0051310566' , '0076675371' , '0010694196' , '0016532119' , '0010378866' , '0022484066' , '0084137622' , '0038875660' , '0019313805' , '0016532108' , '0038875659' , '0084137611' , '0019313816' , '0016532131' , '0038875671' , '0010378888' , '0020994212' , '0084137600' , '0019313827' , '0016532120' , '0010485640' , '0020994201' , '0065924869' , '0012722008' , '0055041913' , '0010147316' , '0011100939' , '0073261593' , '0021172792' , '0030494452' , '0055041902' , '0020762792' , '0011100928' , '0010485662' , '0065924847' , '0084137644' , '0010485695' , '0073261571' , '0065924858' , '0084137633' , '0073261582' , '0072786960' , '0016532197' , '0055041957' , '0018695879' , '0019999667' , '0016532186' , '0055041946' , '0018695868' , '0010368555' , '0019981454' , '0055041935' , '0010368588' , '0046715575' , '0055041924' , '0010368577' , '0046715586' , '0020185288' , '0073432970' , '0075263046' , '0046715597' , '0054681991' , '0010511032' , '0016532153' , '0019313838' , '0075263057' , '0010378833' , '0010368599' , '0016532142' , '0073432958' , '0010511021' , '0010378844' , '0060954178' , '0054681979' , '0059790011' , '0016532175' , '0073432981' , '0000279458' , '0054681968' , '0010378855' , '0055041968' , '0016532164' , '0026451138' , '0081750756' , '0068614971' , '0021545653' , '0050105210' , '0067235818' , '0081750745' , '0054681957' , '0021545664' , '0043964756' , '0055041888' , '0081750734' , '0068614993' , '0067235807' , '0010368602' , '0020762805' , '0055041899' , '0081750723' , '0010368613' , '0000151597' , '0081750712' , '0068614926' , '0021545697' , '0081750701' , '0013019142' , '0010746039' , '0078856129' , '0050105243' , '0043964790' , '0011105003' , '0070625126' , '0050105232' , '0068614948' , '0000208866' , '0068614960' , '0068614959' , '0010083440' , '0011128793' , '0030494372' , '0060112803' , '0010083451' , '0009825234' , '0030494361' , '0050105276' , '0011569554' , '0073261651' , '0029862053' , '0021172850' , '0030494383' , '0050095993' , '0042428126' , '0039478063' , '0020994223' , '0010083406' , '0042060424' , '0081750790' , '0073261639' , '0039478074' , '0021545620' , '0020994234' , '0081750789' , '0029862064' , '0073261628' , '0039478085' , '0000387279' , '0060112869' , '0073261617' , '0000387280' , '0039478096' , '0000387268' , '0021545642' , '0081750767' , '0024066613' , '0080065696' , '0016532017' , '0076506406' , '0010188495' , '0010692021' , '0018197029' , '0021172690' , '0080065685' , '0019313703' , '0016592657' , '0010692032' , '0038930277' , '0022160209' , '0026445976' , '0080065663' , '0018197007' , '0011555763' , '0010656005' , '0019553094' , '0016592635' , '0026445987' , '0084137519' , '0011128782' , '0010656038' , '0009829930' , '0026577560' , '0010485582' , '0072134464' , '0011034494' , '0026577559' , '0000387304' , '0050860167' , '0010188451' , '0020191462' , '0022160210' , '0011555741' , '0010656027' , '0009829941' , '0040112638' , '0010485571' , '0011034483' , '0010188462' , '0026577548' , '0000387315' , '0017233680' , '0021172689' , '0010083495' , '0010656050' , '0084137542' , '0010188473' , '0010656049' , '0010083484' , '0009829929' , '0040112616' , '0070629504' , '0010188484' , '0067235761' , '0068614915' , '0041990969' , '0019553049' , '0040112605' , '0016532095' , '0067235772' , '0068614904' , '0010550240' , '0070629526' , '0019553038' , '0026577593' , '0010656061' , '0053205097' , '0016532084' , '0000279527' , '0073040229' , '0019424807' , '0026577582' , '0019553027' , '0025360730' , '0084137575' , '0037147425' , '0016532073' , '0020185391' , '0049351124' , '0018695982' , '0019553016' , '0026577571' , '0010656083' , '0053205075' , '0049351113' , '0020185380' , '0012344762' , '0016532062' , '0019313736' , '0019553083' , '0025360729' , '0020185379' , '0016532051' , '0012344773' , '0016592691' , '0019313747' , '0084137597' , '0047726090' , '0043964825' , '0025360718' , '0010511167' , '0019553072' , '0016592668' , '0075306331' , '0019313714' , '0012344740' , '0019424841' , '0016532040' , '0041990992' , '0010511156' , '0019553061' , '0016532039' , '0025360707' , '0010692010' , '0000536856' , '0016592679' , '0019313725' , '0014157096' , '0012344751' , '0041990981' , '0019553050' , '0016532028' , '0010692009' , '0067235749' , '0067271447' , '0048710027' , '0043964870' , '0010511123' , '0056489271' , '0010083508' , '0068614880' , '0056489282' , '0010511134' , '0068614879' , '0010083519' , '0000208935' , '0048710049' , '0046715600' , '0020185302' , '0067235705' , '0056489293' , '0043964892' , '0012344795' , '0048710050' , '0000208902' , '0020116545' , '0048710038' , '0010511112' , '0043964881' , '0012344784' , '0068614857' , '0068614824' , '0019553005' , '0068614835' , '0020116578' , '0048710005' , '0000208946' , '0068614802' , '0020116589' , '0050105130' , '0073355530' , '0078856243' , '0061883907' , '0068614813' , '0020831907' , '0050105152' , '0081750698' , '0021545700' , '0021172736' , '0069293921' , '0010083586' , '0000387360' , '0050105141' , '0010947430' , '0076506360' , '0081750687' , '0021545711' , '0010188406' , '0069293910' , '0022160141' , '0021172747' , '0050105174' , '0078856287' , '0000387337' , '0010188440' , '0011398917' , '0000208991' , '0022160152' , '0021172758' , '0000387326' , '0010188428' , '0060112916' , '0022160163' , '0021172769' , '0050105196' , '0022160174' , '0010095575' , '0081750654' , '0021545744' , '0069091061' , '0011398939' , '0050105185' , '0022160185' , '0021172703' , '0010095564' , '0021545755' , '0011398928' , '0010947441' , '0000387382' , '0022160196' , '0021172714' , '0069293943' , '0081750676' , '0021545722' , '0020994336' , '0040491654' , '0060112961' , '0069293932' , '0081750665' , '0020994347' , '0011182288' , '0024778072' , '0050022361' , '0027825747' , '0017096387' , '0078855239' , '0056168037' , '0030494203' , '0050022372' , '0017096376' , '0078855228' , '0056168004' , '0030494214' , '0012344808' , '0027825770' , '0073341705' , '0078855217' , '0020082524' , '0014157132' , '0010147101' , '0056168015' , '0030494225' , '0020185095' , '0012344819' , '0020191348' , '0078855206' , '0010147112' , '0078855284' , '0025486242' , '0075635426' , '0010095586' , '0027825792' , '0078855273' , '0015777783' , '0009783088' , '0020082513' , '0080063087' , '0010095597' , '0020994416' , '0027825781' , '0020994450' , '0078739523' , '0078855262' , '0015777772' , '0075635448' , '0040146201' , '0072133096' , '0066999302' , '0020191393' , '0075635437' , '0024778083' , '0041561380' , '0057931687' , '0012344864' , '0040480908' , '0012452378' , '0012452390' , '0011033093' , '0019313601' , '0054200781' , '0040480919' , '0073947509' , '0020185017' , '0019313612' , '0011033082' , '0000243801' , '0019313623' , '0012452367' , '0078855295' , '0027826842' , '0024479898' , '0020185039' , '0012344820' , '0010166786' , '0019313634' , '0039228507' , '0021545493' , '0019313645' , '0016033480' , '0024479876' , '0073685504' , '0019313656' , '0012344842' , '0038875820' , '0024479887' , '0027826853' , '0073685515' , '0019313667' , '0020083629' , '0012344853' , '0019313689' , '0021365004' , '0060104383' , '0011143649' , '0021545448' , '0016033479' , '0047726114' , '0024479865' , '0053205031' , '0019313678' , '0021545460' , '0021365015' , '0021545459' , '0047726103' , '0024479854' , '0040480986' , '0021545471' , '0010028703' , '0036447844' , '0067271765' , '0016033457' , '0024479843' , '0080063101' , '0040480975' , '0010095611' , '0019313690' , '0024479832' , '0011143616' , '0080063112' , '0042540603' , '0053205064' , '0040480964' , '0010095600' , '0010166719' , '0040480953' , '0010147098' , '0021545404' , '0010166708' , '0021545415' , '0024479810' , '0020083594' , '0060104361' , '0010166731' , '0070712015' , '0024479809' , '0040480931' , '0021545426' , '0010166720' , '0040480920' , '0020083572' , '0021545437' , '0080063167' , '0010406232' , '0010095677' , '0020994461' , '0010485822' , '0080063178' , '0020191417' , '0010083655' , '0010095666' , '0009699994' , '0020994472' , '0010479035' , '0030494190' , '0080063189' , '0010147076' , '0010095699' , '0075635357' , '0027612813' , '0010485844' , '0020994483' , '0054197374' , '0011143694' , '0010095688' , '0009699972' , '0010147065' , '0016102753' , '0030494178' , '0027612802' , '0009699961' , '0020191440' , '0011143683' , '0080063123' , '0030494123' , '0020191451' , '0010095622' , '0009699950' , '0080063134' , '0010406265' , '0075635380' , '0000351644' , '0022160016' , '0050022349' , '0037503165' , '0050022350' , '0010479024' , '0014078934' , '0030494145' , '0011143650' , '0010406243' , '0020191439' , '0011209419' , '0010147214' , '0010947758' , '0010188688' , '0029862008' , '0076888976' , '0054197410' , '0044065056' , '0011209420' , '0030494349' , '0054197421' , '0030494350' , '0010188699' , '0029862019' , '0044065067' , '0020994518' , '0030494316' , '0010947736' , '0010485786' , '0030494327' , '0010947725' , '0076888987' , '0039217124' , '0054197409' , '0010947714' , '0038875784' , '0000209825' , '0010485775' , '0030494305' , '0071703849' , '0020191268' , '0015948137' , '0038875762' , '0072133198' , '0055066187' , '0054197432' , '0038875773' , '0055041855' , '0009624673' , '0000154621' , '0038875740' , '0058726764' , '0020762850' , '0055041844' , '0060163339' , '0011033195' , '0055
7042016394532756353pis2013-05-04 08:58:262013-05-04 14:58:27277.240640.3926220.0019440.00008073042282899553.44select ID, PRODUCT_ID, PRODUCT_NAME, PRODUCT_CODE, OPPON_PRODUCT_CODE, OPPON_PRODUCT_NAME, OPPON_PRODUCT_URL, SITE_ID, SCORE, CREATE_TIME, IS_CHAMPION, MERCHANT_ID, IS_DELETE, IS_BARCODE, IS_DOUBT, IS_SEARCH, IS_INSHOP FROM T_MATCH_CANDIDATE WHERE SITE_ID = 1002 AND IS_DELETE = 0 LIMIT 10000 OFFSET 80000

End of Report