实验要求
本次练习是必选练习之一。
练习目的
本次练习目的掌握 OceanBase 的执行计划查看方法，包括 explain 命令和查看实际执行计划。
练习条件
有 服务器，内存资源至少 12G*1 台，部署有 OceanBase 集群（单副本或三副本都可以）。
练习内容
请记录并分享下列内容：
（必选）使用 BenmarkSQL 运行 TPC-C ，并发数不用很高，5~10 并发即可（根据机器资源）。
（必选）分析 TPC-C TOP SQL，并查看 3条 SQL 的 解析执行计划 和 实际执行计划。
（可选）使用 OceanBase 的 Outline 对 其中一条 SQL 进行限流（限制并发为 1 ）。
（可选）导入 TPC-H schema 和数据，数据量不用太大 100M 即可。查看 TPC-H 5条 SQL 的解析执行计划和实际执行计划。
参考资料
社区版官网-文档-学习中心-入门教程：OceanBase 入门到实战教程
社区版官网-博客-入门实战：开源博客
练习要求
请用文章记录实践练习的环境、过程和问题（可选）、总结等，图文并茂。如果企业内部有安全限制，可以对 IP 、 密码等打码或者修改。如果不允许截图，可以用文字适当补充说明。
分享的文章行文语句通顺，有条理，字数不少于 500 字。
发布：OceanBase 社区版官网问答区或社区版博客（准备word 版本稿件给运营 @Hope，钉钉：hopelee21@dingtalk.com），也可以在CSDN、开源中国、Itpub、知乎等技术社区发布，在问答区附上作业链接及简要说明。
评分
OBCP 考试券获取说明
OceanBase 入门到实战教程总共有 6 个练习，完成必选的 4 个练习，表示你掌握教程分享的学习技能，可以结业，并赠送全额 OBCP 考试券。本次练习为必选练习，请同学们积极参与哦～
其他
后期运营会针对同学的分享进行优秀评选，符合作业奖励规则的同学会给予积分奖励。
优秀作品 OceanBase 会在官方渠道实名推广。
我们欢迎同学们通过提 Issue、提交Pull Request 等方式参与 OceanBase github 社区 贡献。
实践过程如下
实验环境
笔记本基本信息： MacBook Pro 10.15.7/ Intel i7 3.1 GHz/16G/500G VMware Fusion 12.1.2 Guest OS：centos 7.9 12G内存 40G磁盘空间 mysql数据库使用的是percona 8.0.27， oceanbase集群用的是手动部署的单节点集群。
使用 BenmarkSQL 运行 TPC-C
下载BenmarkSQL
git clone https://github.com/obpilot/benchmarksql-5.0.git
编辑props.ob配置文件
这个配置文件在/root/benchmarksql-5.0/run/目录下，编辑后的内容如下：
[root@localhost run]# cat props.ob db=oracle driver=com.alipay.oceanbase.obproxy.mysql.jdbc.Driver conn=jdbc:oceanbase://127.1:2883/tpccdb?useUnicode=true&characterEncoding=utf-8 user=root@my_tenant#obdemo password=root123 warehouses=2 loadWorkers=1 terminals=5 //To run specified transactions per terminal- runMins must equal zero runTxnsPerTerminal=0 //To run for specified minutes- runTxnsPerTerminal must equal zero runMins=5 //Number of total transactions per minute limitTxnsPerMin=0 //Set to true to run in 4.x compatible mode. Set to false to use the //entire configured database evenly. terminalWarehouseFixed=true //The following five values must add up to 100 newOrderWeight=45 paymentWeight=43 orderStatusWeight=4 deliveryWeight=4 stockLevelWeight=4 // Directory name to create for collecting detailed result data. // Comment this out to suppress. resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS osCollectorScript=./misc/os_collector_linux.py osCollectorInterval=1
运行创建表语句
[root@localhost run]# ./runSQL.sh props.ob sql.common/tableCreates.sql # ------------------------------------------------------------ # Loading SQL file sql.common/tableCreates.sql # ------------------------------------------------------------ create table bmsql_config ( cfg_name varchar(30) primary key, cfg_value varchar(50) ); create table bmsql_warehouse ( w_id integer not null, w_ytd decimal(12,2), w_tax decimal(4,4), w_name varchar(10), w_street_1 varchar(20), w_street_2 varchar(20), w_city varchar(20), w_state char(2), w_zip char(9) ); create table bmsql_district ( d_w_id integer not null, d_id integer not null, d_ytd decimal(12,2), d_tax decimal(4,4), d_next_o_id integer, d_name varchar(10), d_street_1 varchar(20), d_street_2 varchar(20), d_city varchar(20), d_state char(2), d_zip char(9) ); create table bmsql_customer ( c_w_id integer not null, c_d_id integer not null, c_id integer not null, c_discount decimal(4,4), c_credit char(2), c_last varchar(16), c_first varchar(16), c_credit_lim decimal(12,2), c_balance decimal(12,2), c_ytd_payment decimal(12,2), c_payment_cnt integer, c_delivery_cnt integer, c_street_1 varchar(20), c_street_2 varchar(20), c_city varchar(20), c_state char(2), c_zip char(9), c_phone char(16), c_since timestamp, c_middle char(2), c_data varchar(500) ); create sequence bmsql_hist_id_seq; You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'sequence bmsql_hist_id_seq' at line 1 create table bmsql_history ( hist_id integer, h_c_id integer, h_c_d_id integer, h_c_w_id integer, h_d_id integer, h_w_id integer, h_date timestamp, h_amount decimal(6,2), h_data varchar(24) ); create table bmsql_new_order ( no_w_id integer not null, no_d_id integer not null, no_o_id integer not null ); create table bmsql_oorder ( o_w_id integer not null, o_d_id integer not null, o_id integer not null, o_c_id integer, o_carrier_id integer, o_ol_cnt integer, o_all_local integer, o_entry_d timestamp ); create table bmsql_order_line ( ol_w_id integer not null, ol_d_id integer not null, ol_o_id integer not null, ol_number integer not null, ol_i_id integer not null, ol_delivery_d timestamp, ol_amount decimal(6,2), ol_supply_w_id integer, ol_quantity integer, ol_dist_info char(24) ); create table bmsql_item ( i_id integer not null, i_name varchar(24), i_price decimal(5,2), i_data varchar(50), i_im_id integer ); create table bmsql_stock ( s_w_id integer not null, s_i_id integer not null, s_quantity integer, s_ytd integer, s_order_cnt integer, s_remote_cnt integer, s_data varchar(50), s_dist_01 char(24), s_dist_02 char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10 char(24) );
这里出了点小问题，这个脚本报找不到funcs.sh文件，应该是环境变量的问题，不过通过更改脚本中funcs.sh路径为绝对路径也可以解决这个问题：
解决方法可以直接
[root@localhost run]# ./runSQL.sh props.ob sql.common/tableCreates.sql
再运行创建表的命令，表创建正常了，下面的脚本都需要做这样的更改
数据装载
装载前先优化一下测试租户的设置，避免大事务超时，先登陆到租户
obclient -h127.0.0.1 -P 2883 -u root@my_tenant -p -A -c 设置以下租户全局变量： set global ob_timestamp_service='GTS' ; set global autocommit=ON; set global ob_query_timeout=36000000000; set global ob_trx_timeout=36000000000; set global max_allowed_packet=67108864; set global ob_sql_work_area_percentage=100; set global parallel_max_servers=800; set global parallel_servers_target=800;
运行脚本，装载数据，输出显示装载成功，由于是笔记本电脑，仓库数选的小一些
[admin@localhost ~]$ obclient -h127.0.0.1 -uroot@my_tenant -P2883 -p -c -A test Enter password: Welcome to the OceanBase. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.6.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [test]> MySQL [test]> CREATE DATABASE `tpccdb` DEFAULT CHARACTER SET = utf8mb4 REPLICA_NUM = 1; Query OK, 1 row affected (0.039 sec) MySQL [test]> MySQL [test]> show databases; +--------------------+ | Database | +--------------------+ | oceanbase | | information_schema | | mysql | | test | | sakila | | mydb | | tpccdb | +--------------------+ 7 rows in set (0.030 sec) [root@localhost run]# ./runLoader.sh props.ob Starting BenchmarkSQL LoadData driver=com.alipay.oceanbase.obproxy.mysql.jdbc.Driver conn=jdbc:oceanbase://127.1:2883/tpccdb?useUnicode=true&characterEncoding=utf-8 user=root@my_tenant#obdemo password=*********** warehouses=2 loadWorkers=1 fileLocation (not defined) csvNullValue (not defined - using default 'NULL') Worker 000: Loading ITEM Worker 000: Loading ITEM done Worker 000: Loading Warehouse 1 Worker 000: Loading Warehouse 1 done Worker 000: Loading Warehouse 2 Worker 000: Loading Warehouse 2 done
登陆到数据库，创建两个索引
MySQL [(none)]> use tpccdb
Database changed
MySQL [tpccdb]> create index bmsql_customer_idx1 on bmsql_customer (c_w_id, c_d_id, c_last, c_first) local;
Query OK, 0 rows affected (1.060 sec)
MySQL [tpccdb]> create index bmsql_oorder_idx1 on bmsql_oorder (o_w_id, o_d_id, o_carrier_id, o_id) local;
Query OK, 0 rows affected (0.778 sec)
运行TPCC测试
[root@localhost run]# ./runBenchmark.sh props.ob 16:34:13,017 [main] INFO jTPCC : Term-00, 16:34:13,024 [main] INFO jTPCC : Term-00, +-------------------------------------------------------------+ 16:34:13,024 [main] INFO jTPCC : Term-00, BenchmarkSQL v5.0 16:34:13,024 [main] INFO jTPCC : Term-00, +-------------------------------------------------------------+ 16:34:13,024 [main] INFO jTPCC : Term-00, (c) 2003, Raul Barbosa 16:34:13,024 [main] INFO jTPCC : Term-00, (c) 2004-2016, Denis Lussier 16:34:13,032 [main] INFO jTPCC : Term-00, (c) 2016, Jan Wieck 16:34:13,032 [main] INFO jTPCC : Term-00, +-------------------------------------------------------------+ 16:34:13,032 [main] INFO jTPCC : Term-00, 16:34:13,032 [main] INFO jTPCC : Term-00, db=oracle 16:34:13,032 [main] INFO jTPCC : Term-00, driver=com.alipay.oceanbase.obproxy.mysql.jdbc.Driver 16:34:13,032 [main] INFO jTPCC : Term-00, conn=jdbc:oceanbase://127.1:2883/tpccdb?useUnicode=true&characterEncoding=utf-8 16:34:13,032 [main] INFO jTPCC : Term-00, user=root@my_tenant#obdemo 16:34:13,032 [main] INFO jTPCC : Term-00, 16:34:13,033 [main] INFO jTPCC : Term-00, warehouses=2 16:34:13,033 [main] INFO jTPCC : Term-00, terminals=5 16:34:13,036 [main] INFO jTPCC : Term-00, runMins=5 16:34:13,036 [main] INFO jTPCC : Term-00, limitTxnsPerMin=0 16:34:13,037 [main] INFO jTPCC : Term-00, terminalWarehouseFixed=true 16:34:13,037 [main] INFO jTPCC : Term-00, 16:34:13,037 [main] INFO jTPCC : Term-00, newOrderWeight=45 16:34:13,037 [main] INFO jTPCC : Term-00, paymentWeight=43 16:34:13,037 [main] INFO jTPCC : Term-00, orderStatusWeight=4 16:34:13,037 [main] INFO jTPCC : Term-00, deliveryWeight=4 16:34:13,040 [main] INFO jTPCC : Term-00, stockLevelWeight=4 16:34:13,040 [main] INFO jTPCC : Term-00, 16:34:13,040 [main] INFO jTPCC : Term-00, resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS 16:34:13,040 [main] INFO jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py 16:34:13,040 [main] INFO jTPCC : Term-00, 16:34:13,131 [main] INFO jTPCC : Term-00, copied props.ob to my_result_2022-05-05_163413/run.properties 16:34:13,131 [main] INFO jTPCC : Term-00, created my_result_2022-05-05_163413/data/runInfo.csv for runID 8 16:34:13,131 [main] INFO jTPCC : Term-00, writing per transaction results to my_result_2022-05-05_163413/data/result.csv 16:34:13,132 [main] INFO jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py 16:34:13,132 [main] INFO jTPCC : Term-00, osCollectorInterval=1 16:34:13,133 [main] INFO jTPCC : Term-00, osCollectorSSHAddr=null 16:34:13,133 [main] INFO jTPCC : Term-00, osCollectorDevices=null 16:34:13,348 [main] INFO jTPCC : Term-00, 16:34:13,861 [main] INFO jTPCC : Term-00, C value for C_LAST during load: 182 16:34:13,864 [main] INFO jTPCC : Term-00, C value for C_LAST this run: 97 16:34:13,864 [main] INFO jTPCC : Term-00, Term-00, Running Average tpmTOTAL: 9.39 Current tpmTOTAL: 312 Memory Usage: 31MB / 192MB 16:39:52,629 [Thread-5] INFO jTPCC : Term-00, 16:39:52,629 [Thread-5] INFO jTPCC : Term-00, 16:39:52,629 [Thread-5] INFO jTPCC : Term-00, Measured tpmC (NewOrders) = 4.96 16:39:52,629 [Thread-5] INFO jTPCC : Term-00, Measured tpmTOTAL = 9.39 16:39:52,629 [Thread-5] INFO jTPCC : Term-00, Session Start = 2022-05-05 16:34:14 16:39:52,629 [Thread-5] INFO jTPCC : Term-00, Session End = 2022-05-05 16:39:52 16:39:52,629 [Thread-5] INFO jTPCC : Term-00, Transaction Count = 52
毕竟是笔记本电脑，内存仅有16G， tpmC才4.96， 五分钟一共运行了52个事务，指标低了点。
TPC-C TOP SQL分析
查询TOP sql
MySQL [oceanbase]> SELECT sql_id, count(*),round(avg(elapsed_time)) avg_elapsed_time,
-> round(avg(execute_time)) avg_exec_time
-> FROM gv$sql_audit s
-> WHERE 1=1
-> and user_name='root'
-> and request_time <= time_to_usec(DATE_SUB(current_timestamp, INTERVAL 30 MINUTE) )
-> GROUP BY sql_id
-> order by avg_elapsed_time desc limit 10;
+----------------------------------+----------+------------------+---------------+
| sql_id | count(*) | avg_elapsed_time | avg_exec_time |
+----------------------------------+----------+------------------+---------------+
| 4929A6584407F7480446BB199288BB93 | 1 | 712849 | 285777 |
| EE39C54A681A14F7555EAB8EAEF25A96 | 2 | 699755 | 359217 |
| 54B72414744A5BC01FE2ACC0F462131E | 1 | 251522 | 251199 |
| D1FB9E09FD5374E01C56A0313929AB59 | 1 | 189055 | 188603 |
| 2447C440D7D94DAA18896F2EEFBD4D4C | 1 | 119091 | 118813 |
| 7E4721D8365262EE06FC3AE4C343580A | 1 | 113831 | 111004 |
| 73305E6A90C0A9C7A93BA23A2881777A | 1 | 107260 | 105891 |
| BB5F150ECF08DB7B9B227D5582AFE93E | 1 | 105969 | 105296 |
| 2D1366676CD073B5199DF5888FB3B0D9 | 1 | 105238 | 104815 |
| 49E1673CDABDC24B09B1E20E10F29F55 | 1 | 101673 | 101329 |
+----------------------------------+----------+------------------+---------------+
对elapsed时间最长的前三条sql进行分析
查询获取实际执行计划需要的必要信息
MySQL [oceanbase]> SELECT sql_id, count(*), round(avg(elapsed_time)) avg_elapsed_time,
-> round(avg(execute_time)) avg_exec_time,
-> s.svr_ip,
-> s.svr_port,
-> s.tenant_id,
-> s.plan_id
-> FROM gv$sql_audit s
-> WHERE 1=1
-> and request_time <= time_to_usec(DATE_SUB(current_timestamp, INTERVAL 30 MINUTE) )
-> GROUP BY sql_id
-> order by avg_elapsed_time desc limit 3;
+----------------------------------+----------+------------------+---------------+-----------+----------+-----------+---------+
| sql_id | count(*) | avg_elapsed_time | avg_exec_time | svr_ip | svr_port | tenant_id | plan_id |
+----------------------------------+----------+------------------+---------------+-----------+----------+-----------+---------+
| 4929A6584407F7480446BB199288BB93 | 1 | 712849 | 285777 | 127.0.0.1 | 2882 | 1001 | 29 |
| EE39C54A681A14F7555EAB8EAEF25A96 | 2 | 699755 | 359217 | 127.0.0.1 | 2882 | 1001 | 26 |
| 54B72414744A5BC01FE2ACC0F462131E | 1 | 251522 | 251199 | 127.0.0.1 | 2882 | 1001 | 0 |
+----------------------------------+----------+------------------+---------------+-----------+----------+-----------+---------+
获取第一条sql的文本
MySQL [oceanbase]> select distinct query_sql from gv$sql_audit where sql_id='4929A6584407F7480446BB199288BB93'\G
*************************** 1. row ***************************
query_sql: INSERT INTO payment (payment_id,customer_id,staff_id,rental_id,amount,payment_date,last_update) VALUES('14337','532','1','16014','5.99','2005-08-23 21:18:31','2006-02-15 22:21:16') ,('14338','532','1','14616','0.99','2006-02-14 15:16:03','2006-02-15 22:21:16') ,('14339','533','1','173','0.99','2005-05-26 03:42:10','2006-02-15 22:21:16') ,('14340','533','2','190','1.99','2005-05-26 06:11:28','2006-02-15 22:21:16') ,('14341','533','1','615','5.99','2005-05-28 15:35:52','2006-02-15 22:21:16') ,('14342','533','1','1421','5.99','2005-06-15 17:57:04','2006-02-15 22:21:16') ,('14343','533','1','1652','0.99','2005-06-16 09:31:37','2006-02-15 22:21:16') ,('14344','533','1','1859','0.99','2005-06-17 01:13:38','2006-02-15 22:21:16') ,('14345','533','1','1954','2.99','2005-06-17 08:37:55','2006-02-15 22:21:17') ,('14346','533','2','2770','6.99','2005-06-19 17:54:22','2006-02-15 22:21:17') ,('14347','533','1','2956','0.99','2005-06-20 06:47:23','2006-02-15 22:21:17') ,('14348','533','1','4112','8.99','2005-07-07 06:49:09','2006-02-15 22:21:17') ,('14349','533','1','4788','4.99','2005-07-08 16:17:35','2006-02-15 22:21:17') ,('14350','533','2','6781','2.99','2005-07-12 16:21:47','2006-02-15 22:21:17') ,('14351','533','2','6834','0.99','2005-07-12 18:53:37','2006-02-15 22:21:17') ,('14352','533','2','6837','9.99','2005-07-12 18:59:45','2006-02-15 22:21:17') ,('14353','533','2','7555','4.99','2005-07-27 22:17:05','2006-02-15 22:21:17') ,('14354','533','1','8093','8.99','2005-07-28 18:29:16','2006-02-15 22:21:17') ,('14355','533','2','8104','2.99','2005-07-28 18:59:36','2006-02-15 22:21:17') ,('14356','533','2','8250','2.99','2005-07-29 00:49:15','2006-02-15 22:21:17') ,('14357','533','1','8471','2.99','2005-07-29 08:32:11','2006-02-15 22:21:17') ,('14358','533','1','8676','1.99','2005-07-29 15:59:06','2006-02-15 22:21:17') ,('14359','533','2','8786','1.99','2005-07-29 20:39:49','2006-02-15 22:21:17') ,('14360','533','2','10090','3.99','2005-07-31 20:22:01','2006-02-15 22:21:17') ,('14361','533','1','10380','2.99','2005-08-01 06:34:36','2006-02-15 22:21:18') ,('14362','533','1','10614','6.99','2005-08-01 14:57:00','2006-02-15 22:21:18') ,('14363','533','2','11524','7.99','2005-08-17 00:10:55','2006-02-15 22:21:18') ,('14364','533','1','11758','8.99','2005-08-17 09:33:02','2006-02-15 22:21:18') ,('14365','533','1','11918','2.99','2005-08-17 16:08:42','2006-02-15 22:21:18') ,('14366','533','1','12602','0.99','2005-08-18 16:49:50','2006-02-15 22:21:18') ,('14367','533','1','12655','6.99','2005-08-18 18:57:44','2006-02-15 22:21:18') ,('14368','533','1','14263','7.99','2005-08-21 06:08:15','2006-02-15 22:21:18') ,('14369','533','1','14800','4.99','2005-08-22 00:46:18','2006-02-15 22:21:18') ,('14370','533','2','16006','0.99','2005-08-23 21:01:09','2006-02-15 22:21:18') ,('14371','533','2','14018','2.99','2006-02-14 15:16:03','2006-02-15 22:21:18') ,('14372','534','2','304','5.99','2005-05-26 21:21:28','2006-02-15 22:21:18') ,('14373','534','2','940','0.99','2005-05-30 15:01:02','2006-02-15 22:21:18') ,('14374','534','1','1610','4.99','2005-06-16 06:36:33','2006-02-15 22:21:18') ,('14375','534','1','1673','2.99','2005-06-16 10:40:17','2006-02-15 22:21:18') ,('14376','534','1','2436','0.99','2005-06-18 18:13:32','2006-02-15 22:21:19') ,('14377','534','2','3213','1.99','2005-06-21 01:05:19','2006-02-15 22:21:19') ,('14378','534','1','3216','4.99','2005-06-21 01:19:37','2006-02-15 22:21:19') ,('14379','534','1','3735','2.99','2005-07-06 11:42:04','2006-02-15 22:21:19') ,('14380','534','2','4998','4.99','2005-07-09 01:07:21','2006-02-15 22:21:19') ,('14381','534','2','7113','2.99','2005-07-27 05:41:20','2006-02-15 22:21:19') ,('14382','534','1','7662','2.99','2005-07-28 02:16:08','2006-02-15 22:21:19') ,('14383','534','2','8633','0.99','2005-07-29 14:19:53','2006-02-15 22:21:19') ,('14384','534','1','9456','5.99','2005-07-30 22:22:16','2006-02-15 22:21:19') ,('14385','534','2','9464','4.99','2005-07-30 22:31:31','2006-02-15 22:21:19') ,('14386','534','2','10465','5.99','2005-08-01 09:45:25','2006-02-15 22:21:19') ,('14387','534','2','10725','6.99','2005-08-01 19:11:04','2006-02-15 22:21:19') ,('14388','534','1','10796','0.99','2005-08-01 21:56:41','2006-02-15 22:21:19') ,('14389','534','2','11180','5.99','2005-08-02 10:54:30','2006-02-15 22:21:19') ,('14390','534','2','12305','2.99','2005-08-18 05:46:29','2006-02-15 22:21:19') ,('14391','534','1','12691','5.99','2005-08-18 20:07:46','2006-02-15 22:21:20') ,('14392','534','2','12798','4.99','2005-08-19 00:24:33','2006-02-15 22:21:20') ,('14393','534','2','13294','0.99','2005-08-19 18:36:35','2006-02-15 22:21:20') ,('14394','534','2','14816','1.99','2005-08-22 01:15:51','2006-02-15 22:21:20') ,('14395','534','1','14526','2.99','2006-02-14 15:16:03','2006-02-15 22:21:20') ,('14396','535','1','37','0.99','2005-05-25 04:44:31','2006-02-15 22:21:20') ,('14397','535','2','541','2.99','2005-05-28 06:41:58','2006-02-15 22:21:20') ,('14398','535','1','778','3.99','2005-05-29 14:09:53','2006-02-15 22:21:20') ,('14399','535','2','959','4.99','2005-05-30 18:07:00','2006-02-15 22:21:20') ,('14400','535','1','1712','4.99','2005-06-16 14:25:09','2006-02-15 22:21:20') ,('14401','535','1','3228','4.99','2005-06-21 02:20:24','2006-02-15 22:21:20') ,('14402','535','1','4331','4.99','2005-07-07 18:22:30','2006-02-15 22:21:20') ,('14403','535','1','4718','6.99','2005-07-08 12:32:08','2006-02-15 22:21:20') ,('14404','535','1','4743','2.99','2005-07-08 13:42:36','2006-02-15 22:21:20') ,('14405','535','2','4914','6.99','2005-07-08 21:30:53','2006-02-15 22:21:20') ,('14406','535','1','5588','0.99','2005-07-10 04:21:10','2006-02-15 22:21:21') ,('14407','535','2','5890','8.99','2005-07-10 20:00:25','2006-02-15 22:21:21') ,('14408','535','1','6504','2.99','2005-07-12 03:19:14','2006-02-15 22:21:21') ,('14409','535','1','8395','2.99','2005-07-29 06:03:30','2006-02-15 22:21:21') ,('14410','535','1','8645','4.99','2005-07-29 14:47:45','2006-02-15 22:21:21') ,('14411','535','2','9440','0.99','2005-07-30 21:40:15','2006-02-15 22:21:21') ,('14412','535','1','9524','4.99','2005-07-31 01:01:06','2006-02-15 22:21:21') ,('14413','535','2','10322','5.99','2005-08-01 04:44:13','2006-02-15 22:21:21') ,('14414','535','2','10353','3.99','2005-08-01 05:46:33','2006-02-15 22:21:21') ,('14415','535','2','11736','8.99','2005-08-17 08:40:55','2006-02-15 22:21:21') ,('14416','535','1','11855','7.99','2005-08-17 13:43:07','2006-02-15 22:21:21') ,('14417','535','2','12168','2.99','2005-08-18 01:03:52','2006-02-15 22:21:21') ,('14418','535','1','12233','0.99','2005-08-18 03:16:54','2006-02-15 22:21:21') ,('14419','535','2','12673','4.99','2005-08-18 19:21:56','2006-02-15 22:21:21') ,('14420','535','1','12732','0.99','2005-08-18 21:57:50','2006-02-15 22:21:21') ,('14421','535','2','12750','1.99','2005-08-18 22:32:39','2006-02-15 22:21:21') ,('14422','535','1','13631','4.99','2005-08-20 07:07:37','2006-02-15 22:21:22') ,('14423','535','1','13852','0.99','2005-08-20 14:45:23','2006-02-15 22:21:22') ,('14424','535','1','14522','4.99','2005-08-21 15:01:34','2006-02-15 22:21:22') ,('14425','535','2','15075','5.99','2005-08-22 11:04:52','2006-02-15 22:21:22') ,('14426','535','1','15287','6.99','2005-08-22 19:19:37','2006-02-15 22:21:22') ,('14427','535','1','16017','0.99','2005-08-23 21:27:11','2006-02-15 22:21:22') ,('14428','536','1','237','0.99','2005-05-26 12:15:13','2006-02-15 22:21:22') ,('14429','536','1','929','6.99','2005-05-30 12:32:39','2006-02-15 22:21:22') ,('14430','536','1','1582','4.99','2005-06-16 04:31:57','2006-02-15 22:21:22') ,('14431','536','2','1962','2.99','2005-06-17 09:08:58','2006-02-15 22:21:22') ,('14432','536','2','2403','2.99','2005-06-18 16:33:22','2006-02-15 22:21:22') ,('14433','536','1','3483','4.99','2005-07-05 23:13:51','2006-02-15 22:21:22') ,('14434','536','1','3514','0.99','2005-07-06 00:46:54','2006-02-15 22:21:22') ,('14435','536','1','4448','2.99','2005-07-07 23:17:12','2006-02-15 22:21:22') ,('14436','536','2','5196','0.99','2005-07-09 10:43:34','2006-02-15 22:21:22') ,('14437','536','1','6400','5.99','2005-07-11 22:43:44','2006-02-15 22:21:23') ,('14438','536','1','7065','4.99','2005-07-27 03:53:43','2006-02-15 22:21:23') ,('14439','536','2','8535','4.99','2005-07-29 10:32:33','2006-02-15 22:21:23') ,('14440','536','1','8679','4.99','2005-07-29 16:07:47','2006-02-15 22:21:23') ,('14441','536','1','8958','2.99','2005-07-30 03:34:26','2006-02-15 22:21:23') ,('14442','536','1','9411','8.99','2005-07-30 20:38:22','2006-02-15 22:21:23') ,('14443','536','1','9727','4.99','2005-07-31 08:39:13','2006-02-15 22:21:23') ,('14444','536','2','10019','3.99','2005-07-31 18:20:56','2006-02-15 22:21:23') ,('14445','536','1','11473','6.99','2005-08-02 21:52:03','2006-02-15 22:21:23') ,('14446','536','1','11826','2.99','2005-08-17 12:43:46','2006-02-15 22:21:23') ,('14447','536','2','11977','4.99','2005-08-17 18:01:15','2006-02-15 22:21:23') ,('14448','536','2','12052','8.99','2005-08-17 20:57:02','2006-02-15 22:21:23') ,('14449','536','2','13505','4.99','2005-08-20 02:05:57','2006-02-15 22:21:23') ,('14450','536','1','15130','7.99','2005-08-22 13:04:32','2006-02-15 22:21:23') ,('14451','536','1','15978','8.99','2005-08-23 20:08:18','2006-02-15 22:21:23') ,('14452','536','1','15979','0.99','2005-08-23 20:08:26','2006-02-15 22:21:24') ,('14453','537','2','603','4.99','2005-05-28 14:27:51','2006-02-15 22:21:24') ,('14454','537','1','1445','2.99','2005-06-15 19:10:07','2006-02-15 22:21:24') ,('14455','537','2','2184','2.99','2005-06-18 01:10:36','2006-02-15 22:21:24') ,('14456','537','1','2586','8.99','2005-06-19 05:05:11','2006-02-15 22:21:24') ,('14457','537','2','3134','8.99','2005-06-20 19:29:09','2006-02-15 22:21:24') ,('14458','537','1','3555','0.99','2005-07-06 02:45:35','2006-02-15 22:21:24') ,('14459','537','2','3853','0.99','2005-07-06 16:59:20','2006-02-15 22:21:24') ,('14460','537','1','5630','2.99','2005-07-10 06:08:14','2006-02-15 22:21:24') ,('14461','537','2','5877','5.99','2005-07-10 19:08:51','2006-02-15 22:21:24') ,('14462','537','2','6310','2.99','2005-07-11 18:14:05','2006-02-15 22:21:24') ,('14463','537','1','6409','4.99','2005-07-11 23:05:49','2006-02-15 22:21:24') ,('14464','537','1','6746','0.99','2005-07-12 14:33:01','2006-02-15 22:21:24') ,('14465','537','1','7179','2.99','2005-07-27 08:10:29','2006-02-15 22:21:24') ,('14466','537','2','7810','4.99','2005-07-28 08:00:38','2006-02-15 22:21:24') ,('14467','537','2','8126','4.99','2005-07-28 19:32:41','2006-02-15 22:21:25') ,('14468','537','2','8256','4.99','2005-07-29 01:02:42','2006-02-15 22:21:25') ,('14469','537','1','9967','2.99','2005-07-31 16:31:17','2006-02-15 22:21:25') ,('14470','537','2','12984','4.99','2005-08-19 07:06:51','2006-02-15 22:21:25') ,('14471','537','2','13885','4.99','2005-08-20 15:32:09','2006-02-15 22:21:25') ,('14472','537','1','14010','4.99','2005-08-20 20:29:46','2006-02-15 22:21:25') ,('14473','537','2','14506','0.99','2005-08-21 14:32:27','2006-02-15 22:21:25') ,('14474','537','1','14670','0.99','2005-08-21 19:54:11','2006-02-15 22:21:25') ,('14475','537','1','15149','2.99','2005-08-22 14:08:06','2006-02-15 22:21:25') ,('14476','537','1','15832','8.99','2005-08-23 15:21:35','2006-02-15 22:21:25') ,('14477','537','1','13419','4.99','2006-02-14 15:16:03','2006-02-15 22:21:25') ,('14478','538','2','594','2.99','2005-05-28 13:41:56','2006-02-15 22:21:25') ,('14479','538','2','734','4.99','2005-05-29 07:38:52','2006-02-15 22:21:25') ,('14480','538','1','1314','5.99','2005-06-15 10:21:45','2006-02-15 22:21:25') ,('14481','538','1','1912','4.99','2005-06-17 05:18:32','2006-02-15 22:21:25') ,('14482','538','1','2682','4.99','2005-06-19 12:18:17','2006-02-15 22:21:26') ,('14483','538','2','3189','2.99','2005-06-20 23:19:33','2006-02-15 22:21:26') ,('14484','538','2','3554','4.99','2005-07-06 02:37:10','2006-02-15 22:21:26') ,('14485','538','2','5135','8.99','2005-07-09 07:53:22','2006-02-15 22:21:26') ,('14486','538','1','5369','4.99','2005-07-09 18:42:16','2006-02-15 22:21:26') ,('14487','538','1','5486','2.99','2005-07-09 23:57:44','2006-02-15 22:21:26') ,('14488','538','1','5898','2.99','2005-07-10 20:18:09','2006-02-15 22:21:26') ,('14489','538','2','6130','2.99','2005-07-11 08:19:56','2006-02-15 22:21:26') ,('14490','538','1','6332','0.99','2005-07-11 19:19:06','2006-02-15 22:21:26') ,('14491','538','2','6936','0.99','2005-07-26 23:13:34','2006-02-15 22:21:26') ,('14492','538','1','7694','0.99','2005-07-28 03:39:25','2006-02-15 22:21:26') ,('14493','538','1','8765','0.99','2005-07-29 19:40:08','2006-02-15 22:21:26') ,('14494','538','1','9307','0.99','2005-07-30 16:52:43','2006-02-15 22:21:26') ,('14495','538','1','9643','4.99','2005-07-31 05:35:48','2006-02-15 22:21:26') ,('14496','538','2','9897','4.99','2005-07-31 14:11:57','2006-02-15 22:21:26') ,('14497','538','2','9939','8.99','2005-07-31 15:29:00','2006-02-15 22:21:27') ,('14498','538','2','10701','3.99','2005-08-01 18:28:17','2006-02-15 22:21:27') ,('14499','538','1','10732','5.99','2005-08-01 19:25:18','2006-02-15 22:21:27') ,('14500','538','1','10962','4.99','2005-08-02 03:48:13','2006-02-15 22:21:27') ,('14501','538','2','12089','5.99','2005-08-17 22:20:29','2006-02-15 22:21:27') ,('14502','538','1','13544','1.99','2005-08-20 03:44:26','2006-02-15 22:21:27') ,('14503','538','2','13770','4.99','2005-08-20 11:45:54','2006-02-15 22:21:27') ,('14504','538','2','14572','2.99','2005-08-21 16:44:31','2006-02-15 22:21:27') ,('14505','538','1','14591','0.99','2005-08-21 17:30:09','2006-02-15 22:21:27') ,('14506','538','1','15343','6.99','2005-08-22 21:01:25','2006-02-15 22:21:27') ,('14507','539','2','250','4.99','2005-05-26 14:30:24','2006-02-15 22:21:27') ,('14508','539','1','342','0.99','2005-05-27 04:11:04','2006-02-15 22:21:27') ,('14509','539','2','1282','3.99','2005-06-15 08:25:33','2006-02-15 22:21:27') ,('14510','539','1','1327','0.99','2005-06-15 11:11:39','2006-02-15 22:21:27') ,('14511','539','2','1444','4.99','2005-06-15 19:08:16','2006-02-15 22:21:27') ,('14512','539','1','4035','2.99','2005-07-07 02:45:02','2006-02-15 22:21:27') ,('14513','539','1','4247','0.99','2005-07-07 13:51:54','2006-02-15 22:21:28') ,('14514','539','2','5086','4.99','2005-07-09 05:40:04','2006-02-15 22:21:28') ,('14515','539','2','5139','7.99','2005-07-09 08:01:51','2006-02-15 22:21:28') ,('14516','539','2','5493','2.99','2005-07-10 00:11:44','2006-02-15 22:21:28') ,('14517','539','2','6874','5.99','2005-07-12 20:20:53','2006-02-15 22:21:28') ,('14518','539','1','7781','2.99','2005-07-28 07:13:20','2006-02-15 22:21:28') ,('14519','539','2','8247','6.99','2005-07-29 00:41:38','2006-02-15 22:21:28') ,('14520','539','2','8761','5.99','2005-07-29 19:26:47','2006-02-15 22:21:28') ,('14521','539','2','9250','0.99','2005-07-30 14:18:16','2006-02-15 22:21:28') ,('14522','539','1','9777','7.99','2005-07-31 10:01:06','2006-02-15 22:21:28') ,('14523','539','1','9796','4.99','2005-07-31 10:52:43','2006-02-15 22:21:28') ,('14524','539','2','10922','3.99','2005-08-02 02:14:40','2006-02-15 22:21:28') ,('14525','539','1','12848','2.99','2005-08-19 02:05:11','2006-02-15 22:21:28') ,('14526','539','2','13615','2.99','2005-08-20 06:28:53','2006-02-15 22:21:28') ,('14527','539','2','13778','5.99','2005-08-20 12:03:44','2006-02-15 22:21:28') ,('14528','539','1','15356','2.99','2005-08-22 21:24:19','2006-02-15 22:21:29') ,('14529','540','2','1263','2.99','2005-06-15 06:56:39','2006-02-15 22:21:29') ,('14530','540','2','1290','4.99','2005-06-15 08:52:44','2006-02-15 22:21:29') ,('14531','540','2','2640','2.99','2005-06-19 09:26:13','2006-02-15 22:21:29') ,('14532','540','1','2953','3.99','2005-06-20 06:39:11','2006-02-15 22:21:29') ,('14533','540','1','3340','3.99','2005-06-21 10:37:23','2006-02-15 22:21:29') ,('14534','540','2','4628','4.99','2005-07-08 08:25:52','2006-02-15 22:21:29') ,('14535','540','2','4991','4.99','2005-07-09 00:49:03','2006-02-15 22:21:29') ,('14536','540','1','6103','2.99','2005-07-11 06:59:55','2006-02-15 22:21:29') ,('14537','540','2','6145','7.99','2005-07-11 09:07:01','2006-02-15 22:21:29') ,('14538','540','2','6182','2.99','2005-07-11 11:11:38','2006-02-15 22:21:29') ,('14539','540','1','6748','6.99','2005-07-12 14:39:27','2006-02-15 22:21:29') ,('14540','540','1','6919','0.99','2005-07-12 22:32:17','2006-02-15 22:21:29') ,('14541','540','2','9762','4.99','2005-07-31 09:32:54','2006-02-15 22:21:29') ,('14542','540','2','9815','2.99','2005-07-31 11:30:51','2006-02-15 22:21:29') ,('14543','540','1','10924','8.99','2005-08-02 02:20:19','2006-02-15 22:21:30') ,('14544','540','1','11198','3.99','2005-08-02 11:45:15','2006-02-15 22:21:30') ,('14545','540','2','11324','4.99','2005-08-02 16:31:17','2006-02-15 22:21:30') ,('14546','540','2','11432','6.99','2005-08-02 20:10:01','2006-02-15 22:21:30') ,('14547','540','2','12058','8.99','2005-08-17 21:07:41','2006-02-15 22:21:30') ,('14548','540','2','12201','4.99','2005-08-18 02:14:06','2006-02-15 22:21:30') ,('14549','540','1','12300','6.99','2005-08-18 05:36:14','2006-02-15 22:21:30') ,('14550','540','2','14910','0.99','2005-08-22 04:50:52','2006-02-15 22:21:30') ,('14551','540','2','15079','2.99','2005-08-22 11:09:56','2006-02-15 22:21:30') ,('14552','540','2','15953','3.99','2005-08-23 19:13:46','2006-02-15 22:21:30') ,('14553','541','1','1021','7.99','2005-05-31 03:16:15','2006-02-15 22:21:30') ,('14554','541','1','1066','4.99','2005-05-31 09:07:33','2006-02-15 22:21:30') ,('14555','541','2','1986','2.99','2005-06-17 10:34:59','2006-02-15 22:21:30') ,('14556','541','1','2708','6.99','2005-06-19 13:59:05','2006-02-15 22:21:30') ,('14557','541','1','5018','2.99','2005-07-09 02:01:05','2006-02-15 22:21:30') ,('14558','541','2','5197','4.99','2005-07-09 10:43:54','2006-02-15 22:21:31') ,('14559','541','2','6468','7.99','2005-07-12 01:27:09','2006-02-15 22:21:31') ,('14560','541','2','6718','2.99','2005-07-12 13:38:06','2006-02-15 22:21:31') ,('14561','541','1','8113','8.99','2005-07-28 19:14:00','2006-02-15 22:21:31') ,('14562','541','1','8322','4.99','2005-07-29 03:52:49','2006-02-15 22:21:31') ,('14563','541','2','9603','0.99','2005-07-31 03:43:43','2006-02-15 22:21:31') ,('14564','541','1','10306','5.99','2005-08-01 04:19:18','2006-02-15 22:21:31') ,('14565','541','2','11273','0.99','2005-08-02 14:20:55','2006-02-15 22:21:31') ,('14566','541','1','12306','4.99','2005-08-18 05:47:55','2006-02-15 22:21:31') ,('14567','541','2','12395','4.99','2005-08-18 09:06:30','2006-02-15 22:21:31') ,('14568','541','1','12894','7.99','2005-08-19 03:49:28','2006-02-15 22:21:31') ,('14569','541','2','13239','4.99','2005-08-19 16:22:13','2006-02-15 22:21:31') ,('14570','541','2','13640','0.99','2005-08-20 07:22:53','2006-02-15 22:21:31') ,('14571','541','2','14938','6.99','2005-08-22 05:52:39','2006-02-15 22:21:31') ,('14572','541','1','15071','4.99','2005-08-22 10:58:43','2006-02-15 22:21:31') ,('14573','541','2','15141','3.99','2005-08-22 13:41:49','2006-02-15 22:21:32') ,('14574','541','1','15223','1.99','2005-08-22 17:13:39','2006-02-15 22:21:32') ,('14575','541','1','15421','0.99','2005-08-22 23:56:37','2006-02-15 22:21:32') ,('14576','541','2','15924','1.99','2005-08-23 18:08:59','2006-02-15 22:21:32') ,('14577','542','1','220','4.99','2005-05-26 10:06:49','2006-02-15 22:21:32') ,('14578','542','2','376','4.99','2005-05-27 08:58:15','2006-02-15 22:21:32') ,('14579','542','1','2610','4.99','2005-06-19 07:16:20','2006-02-15 22:21:32') ,('14580','542','2','2957','10.99','2005-06-20 06:53:47','2006-02-15 22:21:32') ,('14581','542','2','5293','0.99','2005-07-09 15:17:23','2006-02-15 22:21:32') ,('14582','542','1','5477','6.99','2005-07-09 23:43:49','2006-02-15 22:21:32') ,('14583','542','2','6077','5.99','2005-07-11 05:06:08','2006-02-15 22:21:32') ,('14584','542','2','6325','5.99','2005-07-11 19:06:01','2006-02-15 22:21:32') ,('14585','542','1','6887','9.99','2005-07-12 21:00:23','2006-02-15 22:21:32') ,('14586','542','2','7672','8.99','2005-07-28 02:49:41','2006-02-15 22:21:32') ,('14587','542','1','8533','4.99','2005-07-29 10:29:16','2006-02-15 22:21:32') ,('14588','542','2','8544','3.99','2005-07-29 11:02:08','2006-02-15 22:21:33') ,('14589','542','1','10280','4.99','2005-08-01 03:27:15','2006-02-15 22:21:33') ,('14590','542','2','11583','0.99','2005-08-17 02:08:13','2006-02-15 22:21:33') ,('14591','542','2','11903','2.99','2005-08-17 15:37:45','2006-02-15 22:21:33') ,('14592','542','1','12819','0.99','2005-08-19 01:05:05','2006-02-15 22:21:33') ,('14593','542','1','13447','0.99','2005-08-20 00:09:36','2006-02-15 22:21:33') ,('14594','542','2','14982','9.99','2005-08-22 07:20:55','2006-02-15 22:21:33') ,('14595','543','1','243','6.99','2005-05-26 13:06:05','2006-02-15 22:21:33') ,('14596','543','2','476','1.99','2005-05-27 22:31:36','2006-02-15 22:21:33') ,('14597','543','2','1720','4.99','2005-06-16 15:00:14','2006-02-15 22:21:33') ,('14598','543','1','2426','2.99','2005-06-18 17:40:44','2006-02-15 22:21:33') ,('14599','543','2','3070','4.99','2005-06-20 14:15:39','2006-02-15 22:21:33') ,('14600','543','1','3128','2.99','2005-06-20 18:41:47','2006-02-15 22:21:33') ,('14601','543','2','3467','5.99','2005-06-21 22:19:25','2006-02-15 22:21:33') ,('14602','543','1','4887','2.99','2005-07-08 19:59:14','2006-02-15 22:21:33') ,('14603','543','2','5467','4.99','2005-07-09 23:05:47','2006-02-15 22:21:34') ,('14604','543','2','6013','4.99','2005-07-11 02:02:03','2006-02-15 22:21:34') ,('14605','543','2','7312','2.99','2005-07-27 13:03:14','2006-02-15 22:21:34') ,('14606','543','1','8580','2.99','2005-07-29 12:00:27','2006-02-15 22:21:34') ,('14607','543','2','8845','4.99','2005-07-29 23:06:13','2006-02-15 22:21:34') ,('14608','543','1','9505','2.99','2005-07-31 00:11:19','2006-02-15 22:21:34') ,('14609','543','1','9999','0.99','2005-07-31 17:40:53','2006-02-15 22:21:34') ,('14610','543','2','10257','0.99','2005-08-01 02:49:43','2006-02-15 22:21:34') ,('14611','543','1','10520','4.99','2005-08-01 11:45:58','2006-02-15 22:21:34') ,('14612','543','2','11241','9.99','2005-08-02 13:29:24','2006-02-15 22:21:34') ,('14613','543','1','11681','2.99','2005-08-17 06:13:30','2006-02-15 22:21:34') ,('14614','543','1','13187','0.99','2005-08-19 14:24:48','2006-02-15 22:21:34') ,('14615','543','2','15281','1.99','2005-08-22 19:10:26','2006-02-15 22:21:34') ,('14616','543','1','15785','1.99','2005-08-23 13:46:27','2006-02-15 22:21:34') ,('14617','544','1','397','2.99','2005-05-27 12:29:02','2006-02-15 22:21:34') ,('14618','544','1','864','2.99','2005-05-30 03:27:17','2006-02-15 22:21:35') ,('14619','544','1','1248','1.99','2005-06-15 05:33:52','2006-02-15 22:21:35') ,('14620','544','2','1434','10.99','2005-06-15 18:30:46','2006-02-15 22:21:35') ,('14621','544','1','2373','0.99','2005-06-18 14:37:57','2006-02-15 22:21:35') ,('14622','544','1','2395','2.99','2005-06-18 15:45:15','2006-02-15 22:21:35') ,('14623','544','1','4395','0.99','2005-07-07 21:13:22','2006-02-15 22:21:35') ,('14624','544','1','4703','2.99','2005-07-08 11:44:56','2006-02-15 22:21:35') ,('14625','544','2','4847','6.99','2005-07-08 18:29:13','2006-02-15 22:21:35') ,('14626','544','2','8566','2.99','2005-07-29 11:35:46','2006-02-15 22:21:35') ,('14627','544','1','8937','5.99','2005-07-30 02:53:21','2006-02-15 22:21:35') ,('14628','544','1','8963','9.99','2005-07-30 03:46:26','2006-02-15 22:21:35') ,('14629','544','1','10735','0.99','2005-08-01 19:29:45','2006-02-15 22:21:35') ,('14630','544','1','11401','3.99','2005-08-02 19:05:06','2006-02-15 22:21:35') ,('14631','544','2','11766','2.99','2005-08-17 09:58:40','2006-02-15 22:21:35') ,('14632','544','2','12640','3.99','2005-08-18 18:14:49','2006-02-15 22:21:36') ,('14633','544','2','14142','4.99','2005-08-21 02:07:43','2006-02-15 22:21:36') ,('14634','544','1','14498','4.99','2005-08-21 14:10:44','2006-02-15 22:21:36') ,('14635','544','2','14651','8.99','2005-08-21 19:31:09','2006-02-15 22:21:36') ,('14636','544','1','14981','2.99','2005-08-22 07:19:05','2006-02-15 22:21:36') ,('14637','544','1','15219','6.99','2005-08-22 17:00:31','2006-02-15 22:21:36') ,('14638','544','1','15605','4.99','2005-08-23 06:48:47','2006-02-15 22:21:36') ,('14639','545','2','248','0.99','2005-05-26 14:07:58','2006-02-15 22:21:36') ,('14640','545','2','715','3.99','2005-05-29 04:22:41','2006-02-15 22:21:36') ,('14641','545','1','2123','2.99','2005-06-17 20:48:30','2006-02-15 22:21:36') ,('14642','545','2','3693','8.99','2005-07-06 09:56:09','2006-02-15 22:21:36') ,('14643','545','1','3975','5.99','2005-07-06 23:00:09','2006-02-15 22:21:36') ,('14644','545','1','4597','5.99','2005-07-08 06:43:42','2006-02-15 22:21:36') ,('14645','545','1','5264','0.99','2005-07-09 14:11:28','2006-02-15 22:21:36') ,('14646','545','1','7078','5.99','2005-07-27 04:16:37','2006-02-15 22:21:36') ,('14647','545','2','8599','3.99','2005-07-29 12:58:52','2006-02-15 22:21:37') ,('14648','545','2','8848','2.99','2005-07-29 23:20:58','2006-02-15 22:21:37') ,('14649','545','2','9810','2.99','2005-07-31 11:22:41','2006-02-15 22:21:37') ,('14650','545','2','9942','4.99','2005-07-31 15:35:43','2006-02-15 22:21:37') ,('14651','545','2','10931','2.99','2005-08-02 02:44:59','2006-02-15 22:21:37') ,('14652','545','2','11760','2.99','2005-08-17 09:44:22','2006-02-15 22:21:37') ,('14653','545','1','12098','4.99','2005-08-17 22:38:31','2006-02-15 22:21:37') ,('14654','545','1','12349','2.99','2005-08-18 07:23:42','2006-02-15 22:21:37') ,('14655','545','2','12667','10.99','2005-08-18 19:11:45','2006-02-15 22:21:37') ,('14656','545','1','12800','2.99','2005-08-19 00:27:11','2006-02-15 22:21:37') ,('14657','545','1','13595','4.99','2005-08-20 05:54:27','2006-02-15 22:21:37') ,('14658','545','1','15585','0.99','2005-08-23 05:55:22','2006-02-15 22:21:37') ,('14659','545','2','15998','4.99','2005-08-23 20:41:09','2006-02-15 22:21:37') ,('14660','546','1','197','5.99','2005-05-26 06:59:21','2006-02-15 22:21:37') ,('14661','546','1','482','6.99','2005-05-27 22:53:02','2006-02-15 22:21:37') ,('14662','546','1','1181','1.99','2005-06-15 00:42:17','2006-02-15 22:21:38') ,('14663','546','2','1403','0.99','2005-06-15 16:31:59','2006-02-15 22:21:38') ,('14664','546','1','1787','3.99','2005-06-16 19:30:59','2006-02-15 22:21:38') ,('14665','546','1','2361','5.99','2005-06-18 13:19:05','2006-02-15 22:21:38') ,('14666','546','1','3738','4.99','2005-07-06 11:50:57','2006-02-15 22:21:38') ,('14667','546','2','4664','0.99','2005-07-08 10:01:28','2006-02-15 22:21:38') ,('14668','546','1','4734','0.99','2005-07-08 13:12:12','2006-02-15 22:21:38') ,('14669','546','1','5629','0.99','2005-07-10 06:02:25','2006-02-15 22:21:38') ,('14670','546','2','6758','9.99','2005-07-12 15:13:49','2006-02-15 22:21:38') ,('14671','546','1','6786','2.99','2005-07-12 16:32:33','2006-02-15 22:21:38') ,('14672','546','2','6910','6.99','2005-07-12 22:11:21','2006-02-15 22:21:38') ,('14673','546','1','8532','4.99','2005-07-29 10:26:56','2006-02-15 22:21:38') ,('14674','546','1','9087','4.99','2005-07-30 08:19:47','2006-02-15 22:21:38') ,('14675','546','1',null,'3.99','2005-07-30 21:16:20','2006-02-15 22:21:38') ,('14676','546','2','9626','1.99','2005-07-31 04:37:41','2006-02-15 22:21:38') ,('14677','546','2','10370','0.99','2005-08-01 06:18:04','2006-02-15 22:21:39') ,('14678','546','2','11352','5.99','2005-08-02 17:29:39','2006-02-15 22:21:39') ,('14679','546','1','11797','4.99','2005-08-17 11:17:21','2006-02-15 22:21:39') ,('14680','546','2','12591','2.99','2005-08-18 16:16:41','2006-02-15 22:21:39') ,('14681','546','2','13850','5.99','2005-08-20 14:43:03','2006-02-15 22:21:39') ,('14682','546','1','14797','4.99','2005-08-22 00:41:24','2006-02-15 22:21:39') ,('14683','546','1','14829','2.99','2005-08-22 01:35:37','2006-02-15 22:21:39') ,('14684','546','1','14929','3.99','2005-08-22 05:32:38','2006-02-15 22:21:39') ,('14685','546','2','15565','4.99','2005-08-23 05:13:09','2006-02-15 22:21:39') ,('14686','547','1','306','0.99','2005-05-26 21:31:57','2006-02-15 22:21:39') ,('14687','547','2','443','8.99','2005-05-27 18:35:20','2006-02-15 22:21:39') ,('14688','547','2','1094','1.99','2005-05-31 13:03:49','2006-02-15 22:21:39') ,('14689','547','2','2022','8.99','2005-06-17 12:44:39','2006-02-15 22:21:39') ,('14690','547','2','3679','4.99','2005-07-06 09:15:57','2006-02-15 22:21:39') ,('14691','547','1','3765','4.99','2005-07-06 13:01:47','2006-02-15 22:21:40') ,('14692','547','2','5327','4.99','2005-07-09 16:39:49','2006-02-15 22:21:40') ,('14693','547','2','5854','4.99','2005-07-10 17:47:34','2006-02-15 22:21:40') ,('14694','547','1','6605','0.99','2005-07-12 08:01:07','2006-02-15 22:21:40') ,('14695','547','2','7420','4.99','2005-07-27 17:09:39','2006-02-15 22:21:40') ,('14696','547','2','7547','3.99','2005-07-27 21:51:48','2006-02-15 22:21:40') ,('14697','547','1','7835','4.99','2005-07-28 08:49:39','2006-02-15 22:21:40') ,('14698','547','1','7859','3.99','2005-07-28 09:57:17','2006-02-15 22:21:40') ,('14699','547','1','8828','2.99','2005-07-29 22:32:54','2006-02-15 22:21:40') ,('14700','547','1','10903','2.99','2005-08-02 01:41:59','2006-02-15 22:21:40') ,('14701','547','1','10980','4.99','2005-08-02 04:17:32','2006-02-15 22:21:40') ,('14702','547','2','11170','5.99','2005-08-02 10:21:53','2006-02-15 22:21:40') ,('14703','547','2','11361','0.99','2005-08-02 17:46:34','2006-02-15 22:21:40') ,('14704','547','1','12579','0.99','2005-08-18 15:47:49','2006-02-15 22:21:40') ,('14705','547','2','12943','2.99','2005-08-19 05:46:26','2006-02-15 22:21:40') ,('14706','547','2','13307','2.99','2005-08-19 18:58:44','2006-02-15 22:21:41') ,('14707','547','1','14510','9.99','2005-08-21 14:44:41','2006-02-15 22:21:41') ,('14708','547','2','14884','4.99','2005-08-22 03:57:08','2006-02-15 22:21:41') ,('14709','548','2','177','6.99','2005-05-26 04:14:29','2006-02-15 22:21:41') ,('14710','548','1','743','4.99','2005-05-29 08:39:02','2006-02-15 22:21:41') ,('14711','548','2','872','3.99','2005-05-30 05:03:04','2006-02-15 22:21:41') ,('14712','548','1','1326','1.99','2005-06-15 11:07:39','2006-02-15 22:21:41') ,('14713','548','1','2280','2.99','2005-06-18 06:46:54','2006-02-15 22:21:41') ,('14714','548','2','2978','0.99','2005-06-20 08:25:16','2006-02-15 22:21:41') ,('14715','548','1','3686','2.99','2005-07-06 09:37:50','2006-02-15 22:21:41') ,('14716','548','2','3777','2.99','2005-07-06 13:36:48','2006-02-15 22:21:41') ,('14717','548','1','4155','7.99','2005-07-07 09:00:49','2006-02-15 22:21:41') ,('14718','548','2','5138','4.99','2005-07-09 08:00:46','2006-02-15 22:21:41') ,('14719','548','2','6490','4.99','2005-07-12 02:28:03','2006-02-15 22:21:41') ,('14720','548','1','9614','5.99','2005-07-31 03:59:31','2006-02-15 22:21:41') ,('14721','548','2','10318','0.99','2005-08-01 04:36:53','2006-02-15 22:21:42') ,('14722','548','1','12860','5.99','2005-08-19 02:24:41','2006-02-15 22:21:42') ,('14723','548','1','13691','3.99','2005-08-20 09:07:39','2006-02-15 22:21:42') ,('14724','548','2','13730','7.99','2005-08-20 10:17:09','2006-02-15 22:21:42') ,('14725','548','2','14188','0.99','2005-08-21 03:32:04','2006-02-15 22:21:42') ,('14726','548','2','14723','6.99','2005-08-21 21:52:32','2006-02-15 22:21:42') ,('14727','548','1','13584','0.99','2006-02-14 15:16:03','2006-02-15 22:21:42') ,('14728','549','1','6','0.99','2005-05-24 23:08:07','2006-02-15 22:21:42') ,('14729','549','2','852','4.99','2005-05-30 01:36:57','2006-02-15 22:21:42') ,('14730','549','1','906','3.99','2005-05-30 10:30:38','2006-02-15 22:21:42') ,('14731','549','2','1086','4.99','2005-05-31 11:17:37','2006-02-15 22:21:42') ,('14732','549','1','2050','2.99','2005-06-17 15:07:30','2006-02-15 22:21:42') ,('14733','549','2','3523','2.99','2005-07-06 01:01:38','2006-02-15 22:21:42') ,('14734','549','2','3892','4.99','2005-07-06 18:58:58','2006-02-15 22:21:42') ,('14735','549','1','4447','0.99','2005-07-07 23:15:28','2006-02-15 22:21:42') ,('14736','549','1','7252','7.99','2005-07-27 10:45:28','2006-02-15 22:21:43') ,('14737','549','2','8239','0.99','2005-07-29 00:31:39','2006-02-15 22:21:43') ,('14738','549','1','8316','4.99','2005-07-29 03:38:49','2006-02-15 22:21:43') ,('14739','549','2','9445','7.99','2005-07-30 21:50:42','2006-02-15 22:21:43') ,('14740','549','2','9511','9.99','2005-07-31 00:25:05','2006-02-15 22:21:43') ,('14741','549','2','9887','0.99','2005-07-31 14:00:32','2006-02-15 22:21:43') ,('14742','549','2','10281','0.99','2005-08-01 03:28:33','2006-02-15 22:21:43') ,('14743','549','2','11737','4.99','2005-08-17 08:42:08','2006-02-15 22:21:43') ,('14744','549','2','11878','2.99','2005-08-17 14:23:52','2006-02-15 22:21:43') ,('14745','549','2','12634','2.99','2005-08-18 17:58:14','2006-02-15 22:21:43') ,('14746','549','2','12747','4.99','2005-08-18 22:28:22','2006-02-15 22:21:43') ,('14747','549','1','14434','0.99','2005-08-21 11:40:46','2006-02-15 22:21:43') ,('14748','550','2','922','7.99','2005-05-30 11:55:55','2006-02-15 22:21:43') ,('14749','550','1','1233','6.99','2005-06-15 04:18:37','2006-02-15 22:21:43') ,('14750','550','1','1863','3.99','2005-06-17 01:31:46','2006-02-15 22:21:43') ,('14751','550','2','1883','4.99','2005-06-17 03:18:51','2006-02-15 22:21:44') ,('14752','550','1','3154','2.99','2005-06-20 20:44:40','2006-02-15 22:21:44') ,('14753','550','2','3236','9.99','2005-06-21 02:47:43','2006-02-15 22:21:44') ,('14754','550','1','3272','10.99','2005-06-21 05:18:27','2006-02-15 22:21:44') ,('14755','550','1','3979','4.99','2005-07-06 23:04:35','2006-02-15 22:21:44') ,('14756','550','1','5727','4.99','2005-07-10 11:25:28','2006-02-15 22:21:44') ,('14757','550','1','6695','2.99','2005-07-12 12:39:39','2006-02-15 22:21:44') ,('14758','550','1','7030','0.99','2005-07-27 03:01:40','2006-02-15 22:21:44') ,('14759','550','2','7838','2.99','2005-07-28 09:00:21','2006-02-15 22:21:44') ,('14760','550','1','8628','6.99','2005-07-29 14:06:24','2006-02-15 22:21:44') ,('14761','550','2','8838','2.99','2005-07-29 22:52:23','2006-02-15 22:21:44') ,('14762','550','1','8959','8.99','2005-07-30 03:35:49','2006-02-15 22:21:44') ,('14763','550','1','9616','2.99','2005-07-31 04:05:01','2006-02-15 22:21:44') ,('14764','550','1','9748','0.99','2005-07-31 09:17:56','2006-02-15 22:21:44') ,('14765','550','2','10140','4.99','2005-07-31 22:03:20','2006-02-15 22:21:44') ,('14766','550','1','11246','2.99','2005-08-02 13:33:56','2006-02-15 22:21:45') ,('14767','550','2','11320','0.99','2005-08-02 16:13:28','2006-02-15 22:21:45') ,('14768','550','1','11969','4.99','2005-08-17 17:49:37','2006-02-15 22:21:45') ,('14769','550','1','12063','2.99','2005-08-17 21:24:48','2006-02-15 22:21:45') ,('14770','550','2','12077','4.99','2005-08-17 21:59:14','2006-02-15 22:21:45') ,('14771','550','1','13114','10.99','2005-08-19 11:27:32','2006-02-15 22:21:45') ,('14772','550','2','14071','2.99','2005-08-20 23:01:56','2006-02-15 22:21:45') ,('14773','550','2','14127','4.99','2005-08-21 01:33:32','2006-02-15 22:21:45') ,('14774','550','2','14375','6.99','2005-08-21 09:46:35','2006-02-15 22:21:45') ,('14775','550','1','14687','4.99','2005-08-21 20:32:16','2006-02-15 22:21:45') ,('14776','550','2','15431','9.99','2005-08-23 00:26:47','2006-02-15 22:21:45') ,('14777','550','1','15883','0.99','2005-08-23 16:44:56','2006-02-15 22:21:45') ,('14778','550','2','15977','4.99','2005-08-23 20:07:10','2006-02-15 22:21:45') ,('14779','550','2','11757','2.99','2006-02-14 15:16:03','2006-02-15 22:21:45') ,('14780','551','2','155','7.99','2005-05-26 01:15:05','2006-02-15 22:21:45') ,('14781','551','1','728','2.99','2005-05-29 06:12:38','2006-02-15 22:21:46') ,('14782','551','1','795','0.99','2005-05-29 16:57:39','2006-02-15 22:21:46') ,('14783','551','2','969','4.99','2005-05-30 19:23:48','2006-02-15 22:21:46') ,('14784','551','2','1005','3.99','2005-05-31 00:53:25','2006-02-15 22:21:46') ,('14785','551','2','2069','4.99','2005-06-17 16:19:39','2006-02-15 22:21:46') ,('14786','551','1','2776','3.99','2005-06-19 18:16:24','2006-02-15 22:21:46') ,('14787','551','2','3996','5.99','2005-07-06 23:46:43','2006-02-15 22:21:46') ,('14788','551','1','5201','1.99','2005-07-09 10:52:53','2006-02-15 22:21:46') ,('14789','551','2','5528','0.99','2005-07-10 02:09:21','2006-02-15 22:21:46') ,('14790','551','1','6041','0.99','2005-07-11 03:14:58','2006-02-15 22:21:46') ,('14791','551','2','7095','9.99','2005-07-27 04:51:15','2006-02-15 22:21:46') ,('14792','551','1','8986','0.99','2005-07-30 04:37:20','2006-02-15 22:21:46') ,('14793','551','1','9287','2.99','2005-07-30 15:35:39','2006-02-15 22:21:46') ,('14794','551','2','9765','4.99','2005-07-31 09:44:40','2006-02-15 22:21:46') ,('14795','551','2','11380','0.99','2005-08-02 18:17:32','2006-02-15 22:21:46') ,('14796','551','2','11883','2.99','2005-08-17 14:41:28','2006-02-15 22:21:47') ,('14797','551','2','12208','4.99','2005-08-18 02:25:25','2006-02-15 22:21:47') ,('14798','551','2','12868','0.99','2005-08-19 02:47:19','2006-02-15 22:21:47') ,('14799','551','1','13439','3.99','2005-08-19 23:42:16','2006-02-15 22:21:47') ,('14800','551','1','14420','0.99','2005-08-21 11:16:15','2006-02-15 22:21:47') ,('14801','551','2','14609','4.99','2005-08-21 17:57:26','2006-02-15 22:21:47') ,('14802','551','2','14633','2.99','2005-08-21 18:51:10','2006-02-15 22:21:47') ,('14803','551','1','14833','2.99','2005-08-22 01:45:18','2006-02-15 22:21:47') ,('14804','551','1','15377','4.99','2005-08-22 22:22:33','2006-02-15 22:21:47') ,('14805','551','2','15390','6.99','2005-08-22 22:57:25','2006-02-15 22:21:47') ,('14806','552','2','174','0.99','2005-05-26 03:44:10','2006-02-15 22:21:47') ,('14807','552','2','2320','0.99','2005-06-18 09:24:50','2006-02-15 22:21:47') ,('14808','552','2','3397','4.99','2005-06-21 15:30:11','2006-02-15 22:21:47') ,('14809','552','1','4477','6.99','2005-07-08 00:38:24','2006-02-15 22:21:47') ,('14810','552','1','5213','7.99','2005-07-09 11:39:43','2006-02-15 22:21:48') ,('14811','552','2','6189','4.99','2005-07-11 11:36:03','2006-02-15 22:21:48') ,('14812','552','1','7772','2.99','2005-07-28 06:59:09','2006-02-15 22:21:48') ,('14813','552','1','8085','2.99','2005-07-28 18:13:15','2006-02-15 22:21:48') ,('14814','552','2','8192','2.99','2005-07-28 22:49:11','2006-02-15 22:21:48') ,('14815','552','2','8614','5.99','2005-07-29 13:32:05','2006-02-15 22:21:48') ,('14816','552','2','8894','4.99','2005-07-30 00:48:31','2006-02-15 22:21:48') ,('14817','552','1','9342','8.99','2005-07-30 18:09:56','2006-02-15 22:21:48') ,('14818','552','1','11146','1.99','2005-08-02 09:45:32','2006-02-15 22:21:48') ,('14819','552','2','11205','4.99','2005-08-02 11:56:54','2006-02-15 22:21:48') ,('14820','552','2','11300','7.99','2005-08-02 15:37:42','2006-02-15 22:21:48') ,('14821','552','2','12433','4.99','2005-08-18 10:37:49','2006-02-15 22:21:48') ,('14822','552','2','12880','2.99','2005-08-19 03:27:17','2006-02-15 22:21:48') ,('14823','552','2','13574','2.99','2005-08-20 05:10:39','2006-02-15 22:21:48') ,('14824','552','1','13693','0.99','2005-08-20 09:11:42','2006-02-15 22:21:48') ,('14825','552','2','14724','4.99','2005-08-21 21:53:47','2006-02-15 22:21:49') ,('14826','552','2','15700','2.99','2005-08-23 10:21:21','2006-02-15 22:21:49') ,('14827','553','2','789','4.99','2005-05-29 16:17:07','2006-02-15 22:21:49') ,('14828','553','2','1862','3.99','2005-06-17 01:29:30','2006-02-15 22:21:49') ,('14829','553','1','2460','8.99','2005-06-18 19:54:13','2006-02-15 22:21:49') ,('14830','553','2','3103','6.99','2005-06-20 16:58:19','2006-02-15 22:21:49') ,('14831','553','1','3495','6.99','2005-07-05 23:50:04','2006-02-15 22:21:49') ,('14832','553','2','3793','4.99','2005-07-06 14:32:44','2006-02-15 22:21:49') ,('14833','553','2','3859','2.99','2005-07-06 17:18:15','2006-02-15 22:21:49') ,('14834','553','1','3890','4.99','2005-07-06 18:58:15','2006-02-15 22:21:49') ,('14835','553','2','3891','4.99','2005-07-06 18:58:25','2006-02-15 22:21:49') ,('14836','553','2','3942','4.99','2005-07-06 21:21:34','2006-02-15 22:21:49') ,('14837','553','1','4257','4.99','2005-07-07 14:18:41','2006-02-15 22:21:49') ,('14838','553','2','4662','0.99','2005-07-08 09:58:54','2006-02-15 22:21:49') ,('14839','553','2','4845','4.99','2005-07-08 18:28:20','2006-02-15 22:21:49') ,('14840','553','2','4941','3.99','2005-07-08 22:39:10','2006-02-15 22:21:50') ,('14841','553','1','6069','2.99','2005-07-11 04:44:59','2006-02-15 22:21:50') ,('14842','553','2','6657','0.99','2005-07-12 11:11:36','2006-02-15 22:21:50') ,('14843','553','1','6812','6.99','2005-07-12 18:03:25','2006-02-15 22:21:50') ,('14844','553','1','7890','4.99','2005-07-28 10:43:40','2006-02-15 22:21:50') ,('14845','553','2','9272','4.99','2005-07-30 15:05:22','2006-02-15 22:21:50') ,('14846','553','2','9601','2.99','2005-07-31 03:42:17','2006-02-15 22:21:50') ,('14847','553','2','11710','4.99','2005-08-17 07:29:44','2006-02-15 22:21:50') ,('14848','553','1','13972','2.99','2005-08-20 18:52:17','2006-02-15 22:21:50') ,('14849','553','1','15042','4.99','2005-08-22 09:47:37','2006-02-15 22:21:50') ,('14850','553','1','15506','0.99','2005-08-23 02:48:24','2006-02-15 22:21:50') ,('14851','554','1','607','2.99','2005-05-28 15:02:41','2006-02-15 22:21:50') ,('14852','554','1','817','2.99','2005-05-29 20:39:14','2006-02-15 22:21:50') ,('14853','554','1','1959','4.99','2005-06-17 08:54:10','2006-02-15 22:21:50') ,('14854','554','1','2279','6.99','2005-06-18 06:38:22','2006-02-15 22:21:50') ,('14855','554','2','3278','2.99','2005-06-21 05:41:30','2006-02-15 22:21:51') ,('14856','554','1','3312','6.99','2005-06-21 08:05:32','2006-02-15 22:21:51') ,('14857','554','2','4902','4.99','2005-07-08 20:49:30','2006-02-15 22:21:51') ,('14858','554','1','5527','2.99','2005-07-10 02:06:01','2006-02-15 22:21:51') ,('14859','554','1','5968','5.99','2005-07-11 00:03:11','2006-02-15 22:21:51') ,('14860','554','1','6144','2.99','2005-07-11 09:02:53','2006-02-15 22:21:51') ,('14861','554','1','10612','6.99','2005-08-01 14:55:31','2006-02-15 22:21:51') ,('14862','554','2','10829','7.99','2005-08-01 23:17:06','2006-02-15 22:21:51') ,('14863','554','2','11589','9.99','2005-08-17 02:28:22','2006-02-15 22:21:51') ,('14864','554','1','11873','0.99','2005-08-17 14:14:39','2006-02-15 22:21:51') ,('14865','554','1','12010','8.99','2005-08-17 19:17:54','2006-02-15 22:21:51') ,('14866','554','1','12014','0.99','2005-08-17 19:29:44','2006-02-15 22:21:51') ,('14867','554','2','13139','4.99','2005-08-19 12:32:10','2006-02-15 22:21:51') ,('14868','554','2','14015','2.99','2005-08-20 20:47:43','2006-02-15 22:21:51') ,('14869','554','1','14098','3.99','2005-08-21 00:30:32','2006-02-15 22:21:51') ,('14870','554','1','14469','0.99','2005-08-21 13:07:24','2006-02-15 22:21:52') ,('14871','554','1','14626','2.99','2005-08-21 18:35:44','2006-02-15 22:21:52') ,('14872','554','2','15690','4.99','2005-08-23 09:53:30','2006-02-15 22:21:52') ,('14873','555','2','3232','1.99','2005-06-21 02:30:37','2006-02-15 22:21:52') ,('14874','555','2','4875','2.99','2005-07-08 19:24:17','2006-02-15 22:21:52') ,('14875','555','1','8161','0.99','2005-07-28 21:11:00','2006-02-15 22:21:52') ,('14876','555','1','8245','3.99','2005-07-29 00:37:09','2006-02-15 22:21:52') ,('14877','555','1','9299','5.99','2005-07-30 16:32:51','2006-02-15 22:21:52') ,('14878','555','2','9990','7.99','2005-07-31 17:24:21','2006-02-15 22:21:52') ,('14879','555','2','10076','7.99','2005-07-31 20:00:34','2006-02-15 22:21:52') ,('14880','555','1','10921','3.99','2005-08-02 02:14:33','2006-02-15 22:21:52') ,('14881','555','1','11168','4.99','2005-08-02 10:19:42','2006-02-15 22:21:52') ,('14882','555','1','11718','4.99','2005-08-17 07:44:42','2006-02-15 22:21:52') ,('14883','555','2','11747','2.99','2005-08-17 09:03:31','2006-02-15 22:21:52') ,('14884','555','2','12091','4.99','2005-08-17 22:22:50','2006-02-15 22:21:52') ,('14885','555','2','12150','2.99','2005-08-18 00:13:55','2006-02-15 22:21:53') ,('14886','555','2','12182','2.99','2005-08-18 01:30:19','2006-02-15 22:21:53') ,('14887','555','1','12388','2.99','2005-08-18 08:48:09','2006-02-15 22:21:53') ,('14888','555','1','12883','4.99','2005-08-19 03:33:47','2006-02-15 22:21:53') ,('14889','555','2','15102','6.99','2005-08-22 11:58:58','2006-02-15 22:21:53') ,('14890','556','1','184','0.99','2005-05-26 05:29:49','2006-02-15 22:21:53') ,('14891','556','2','772','5.99','2005-05-29 13:08:06','2006-02-15 22:21:53') ,('14892','556','1','1083','3.99','2005-05-31 11:04:48','2006-02-15 22:21:53') ,('14893','556','1','2092','6.99','2005-06-17 18:12:16','2006-02-15 22:21:53') ,('14894','556','2','2593','5.99','2005-06-19 05:40:11','2006-02-15 22:21:53') ,('14895','556','2','2986','0.99','2005-06-20 08:50:28','2006-02-15 22:21:53') ,('14896','556','1','3093','4.99','2005-06-20 16:06:14','2006-02-15 22:21:53') ,('14897','556','2','3438','6.99','2005-06-21 19:31:40','2006-02-15 22:21:53') ,('14898','556','2','4719','2.99','2005-07-08 12:33:00','2006-02-15 22:21:53') ,('14899','556','2','4839','3.99','2005-07-08 18:13:10','2006-02-15 22:21:54') ,('14900','556','1','4846','0.99','2005-07-08 18:29:05','2006-02-15 22:21:54') ,('14901','556','2','5722','0.99','2005-07-10 11:10:04','2006-02-15 22:21:54') ,('14902','556','2','6484','2.99','2005-07-12 02:04:10','2006-02-15 22:21:54') ,('14903','556','1','8909','5.99','2005-07-30 01:28:03','2006-02-15 22:21:54') ,('14904','556','2','10106','4.99','2005-07-31 21:00:47','2006-02-15 22:21:54') ,('14905','556','2','10518','6.99','2005-08-01 11:44:08','2006-02-15 22:21:54') ,('14906','556','1','11466','1.99','2005-08-02 21:46:46','2006-02-15 22:21:54') ,('14907','556','2','11804','3.99','2005-08-17 11:42:45','2006-02-15 22:21:54') ,('14908','556','1','12045','4.99','2005-08-17 20:40:46','2006-02-15 22:21:54') ,('14909','556','1','14176','2.99','2005-08-21 03:09:23','2006-02-15 22:21:54') ,('14910','556','1','15568','2.99','2005-08-23 05:24:09','2006-02-15 22:21:54') ,('14911','557','2','467','4.99','2005-05-27 21:10:03','2006-02-15 22:21:54') ,('14912','557','1','478','4.99','2005-05-27 22:38:20','2006-02-15 22:21:54') ,('14913','557','1','1666','0.99','2005-06-16 10:17:19','2006-02-15 22:21:54') ,('14914','557','2','2988','6.99','2005-06-20 08:59:08','2006-02-15 22:21:55') ,('14915','557','1','3050','3.99','2005-06-20 13:03:03','2006-02-15 22:21:55') ,('14916','557','1','4651','0.99','2005-07-08 09:39:39','2006-02-15 22:21:55') ,('14917','557','1','4851','1.99','2005-07-08 18:40:05','2006-02-15 22:21:55') ,('14918','557','1','6459','0.99','2005-07-12 01:12:03','2006-02-15 22:21:55') ,('14919','557','2','6713','3.99','2005-07-12 13:27:36','2006-02-15 22:21:55') ,('14920','557','2','6823','4.99','2005-07-12 18:24:31','2006-02-15 22:21:55') ,('14921','557','2','6898','0.99','2005-07-12 21:39:04','2006-02-15 22:21:55') ,('14922','557','1','9336','0.99','2005-07-30 18:01:15','2006-02-15 22:21:55') ,('14923','557','1','9341','2.99','2005-07-30 18:07:58','2006-02-15 22:21:55') ,('14924','557','2','9366','1.99','2005-07-30 18:48:57','2006-02-15 22:21:55') ,('14925','557','2','9367','6.99','2005-07-30 18:49:58','2006-02-15 22:21:55') ,('14926','557','1','11181','0.99','2005-08-02 10:55:03','2006-02-15 22:21:55') ,('14927','557','1','12555','1.99','2005-08-18 14:49:22','2006-02-15 22:21:55') ,('14928','557','1','12789','2.99','2005-08-19 00:16:19','2006-02-15 22:21:55') ,('14929','557','1','13540','2.99','2005-08-20 03:41:23','2006-02-15 22:21:56') ,('14930','557','2','13794','2.99','2005-08-20 12:25:32','2006-02-15 22:21:56') ,('14931','557','2','15236','0.99','2005-08-22 17:44:27','2006-02-15 22:21:56') ,('14932','557','2','15570','5.99','2005-08-23 05:24:55','2006-02-15 22:21:56') ,('14933','557','2','15914','0.99','2005-08-23 17:49:26','2006-02-15 22:21:56') ,('14934','557','1','14278','4.99','2006-02-14 15:16:03','2006-02-15 22:21:56') ,('14935','558','2','1967','4.99','2005-06-17 09:19:52','2006-02-15 22:21:56') ,('14936','558','1','2411','1.99','2005-06-18 16:55:54','2006-02-15 22:21:56') ,('14937','558','2','2544','4.99','2005-06-19 02:16:17','2006-02-15 22:21:56') ,('14938','558','2','3016','4.99','2005-06-20 10:55:08','2006-02-15 22:21:56') ,('14939','558','2','3451','10.99','2005-06-21 21:10:39','2006-02-15 22:21:56') ,('14940','558','1','3731','9.99','2005-07-06 11:33:36','2006-02-15 22:21:56') ,('14941','558','1','3954','0.99','2005-07-06 21:57:44','2006-02-15 22:21:56') ,('14942','558','1','3990','3.99','2005-07-06 23:32:44','2006-02-15 22:21:56') ,('14943','558','1','4192','5.99','2005-07-07 10:57:06','2006-02-15 22:21:57') ,('14944','558','1','4932','2.99','2005-07-08 22:17:40','2006-02-15 22:21:57') ,('14945','558','2','5375','6.99','2005-07-09 18:52:55','2006-02-15 22:21:57') ,('14946','558','1','5492','3.99','2005-07-10 00:11:09','2006-02-15 22:21:57') ,('14947','558','2','6278','7.99','2005-07-11 16:20:02','2006-02-15 22:21:57') ,('14948','558','2','6479','9.99','2005-07-12 01:49:00','2006-02-15 22:21:57') ,('14949','558','2','6742','4.99','2005-07-12 14:25:31','2006-02-15 22:21:57') ,('14950','558','1','6757','0.99','2005-07-12 15:09:48','2006-02-15 22:21:57') ,('14951','558','1','7424','0.99','2005-07-27 17:14:19','2006-02-15 22:21:57') ,('14952','558','1','8523','2.99','2005-07-29 10:18:27','2006-02-15 22:21:57') ,('14953','558','1','8858','4.99','2005-07-29 23:44:35','2006-02-15 22:21:57') ,('14954','558','1','8889','2.99','2005-07-30 00:39:43','2006-02-15 22:21:57') ,('14955','558','2','10707','0.99','2005-08-01 18:41:34','2006-02-15 22:21:57') ,('14956','558','1','11268','0.99','2005-08-02 14:10:39','2006-02-15 22:21:57') ,('14957','558','2','11567','5.99','2005-08-17 01:28:43','2006-02-15 22:21:57') ,('14958','558','2','12040','6.99','2005-08-17 20:29:56','2006-02-15 22:21:58') ,('14959','558','1','12194','1.99','2005-08-18 02:04:47','2006-02-15 22:21:58') ,('14960','558','2','13566','5.99','2005-08-20 04:45:32','2006-02-15 22:21:58') ,('14961','558','2','14235','7.99','2005-08-21 05:08:42','2006-02-15 22:21:58') ,('14962','558','1','14286','5.99','2005-08-21 06:53:53','2006-02-15 22:21:58') ,('14963','559','2','2576','4.99','2005-06-19 04:34:15','2006-02-15 22:21:58') ,('14964','559','1','2706','0.99','2005-06-19 13:56:51','2006-02-15 22:21:58') ,('14965','559','2','3046','4.99','2005-06-20 12:42:59','2006-02-15 22:21:58') ,('14966','559','1','3370','1.99','2005-06-21 13:27:01','2006-02-15 22:21:58') ,('14967','559','1','3674','5.99','2005-07-06 09:03:13','2006-02-15 22:21:58') ,('14968','559','1','4120','4.99','2005-07-07 07:07:03','2006-02-15 22:21:58') ,('14969','559','1','4370','7.99','2005-07-07 20:05:36','2006-02-15 22:21:58') ,('14970','559','2','5396','1.99','2005-07-09 19:42:52','2006-02-15 22:21:58') ,('14971','559','1','6201','4.99','2005-07-11 12:18:07','2006-02-15 22:21:58') ,('14972','559','1','6915','2.99','2005-07-12 22:28:09','2006-02-15 22:21:58') ,('14973','559','1','7169','1.99','2005-07-27 07:51:39','2006-02-15 22:21:59') ,('14974','559','1','7680','1.99','2005-07-28 02:59:08','2006-02-15 22:21:59') ,('14975','559','1','8631','1.99','2005-07-29 14:08:06','2006-02-15 22:21:59') ,('14976','559','2','9134','0.99','2005-07-30 10:00:21','2006-02-15 22:21:59') ,('14977','559','1','9877','2.99','2005-07-31 13:41:57','2006-02-15 22:21:59') ,('14978','559','2','10146','2.99','2005-07-31 22:17:56','2006-02-15 22:21:59') ,('14979','559','1','10377','3.99','2005-08-01 06:28:28','2006-02-15 22:21:59') ,('14980','559','1','10669','8.99','2005-08-01 17:03:28','2006-02-15 22:21:59') ,('14981','559','2','10876','0.99','2005-08-02 00:31:58','2006-02-15 22:21:59') ,('14982','559','2','11136','1.99','2005-08-02 09:22:57','2006-02-15 22:21:59') ,('14983','559','1','13234','1.99','2005-08-19 16:17:15','2006-02-15 22:21:59') ,('14984','559','2','13248','6.99','2005-08-19 16:47:41','2006-02-15 22:21:59') ,('14985','559','2','13322','4.99','2005-08-19 19:43:08','2006-02-15 22:21:59') ,('14986','559','1','13845','5.99','2005-08-20 14:31:21','2006-02-15 22:21:59') ,('14987','559','1','14342','4.99','2005-08-21 08:39:26','2006-02-15 22:22:00') ,('14988','559','2','14622','4.99','2005-08-21 18:25:59','2006-02-15 22:22:00') ,('14989','559','2','15440','4.99','2005-08-23 00:37:21','2006-02-15 22:22:00') ,('14990','559','1','15877','4.99','2005-08-23 16:33:33','2006-02-15 22:22:00') ,('14991','560','1','137','2.99','2005-05-25 22:25:18','2006-02-15 22:22:00') ,('14992','560','1','1271','4.99','2005-06-15 07:32:24','2006-02-15 22:22:00') ,('14993','560','2','1572','1.99','2005-06-16 03:23:22','2006-02-15 22:22:00') ,('14994','560','1','3941','4.99','2005-07-06 21:20:37','2006-02-15 22:22:00') ,('14995','560','1','4298','2.99','2005-07-07 16:27:25','2006-02-15 22:22:00') ,('14996','560','2','4375','9.99','2005-07-07 20:20:29','2006-02-15 22:22:00') ,('14997','560','1','4453','0.99','2005-07-07 23:32:39','2006-02-15 22:22:00') ,('14998','560','2','5208','2.99','2005-07-09 11:16:56','2006-02-15 22:22:00') ,('14999','560','1','6410','4.99','2005-07-11 23:08:06','2006-02-15 22:22:00') ,('15000','560','1','6945','2.99','2005-07-26 23:35:29','2006-02-15 22:22:00') ,('15001','560','2','7202','4.99','2005-07-27 09:00:20','2006-02-15 22:22:00') ,('15002','560','1','7891','3.99','2005-07-28 10:43:56','2006-02-15 22:22:01') ,('15003','560','1','8753','2.99','2005-07-29 19:15:50','2006-02-15 22:22:01') ,('15004','560','2','8861','5.99','2005-07-29 23:47:29','2006-02-15 22:22:01') ,('15005','560','2','8906','4.99','2005-07-30 01:21:39','2006-02-15 22:22:01') ,('15006','560','1','9265','0.99','2005-07-30 14:55:25','2006-02-15 22:22:01') ,('15007','560','2','9895','5.99','2005-07-31 14:07:56','2006-02-15 22:22:01') ,('15008','560','2','10480','4.99','2005-08-01 10:13:41','2006-02-15 22:22:01') ,('15009','560','1','10702','4.99','2005-08-01 18:34:59','2006-02-15 22:22:01') ,('15010','560','1','10733','7.99','2005-08-01 19:28:01','2006-02-15 22:22:01') ,('15011','560','1','11334','7.99','2005-08-02 16:53:20','2006-02-15 22:22:01') ,('15012','560','1','11788','4.99','2005-08-17 10:59:18','2006-02-15 22:22:01') ,('15013','560','2','14008','5.99','2005-08-20 20:26:00','2006-02-15 22:22:01') ,('15014','560','1','14341','1.99','2005-08-21 08:38:24','2006-02-15 22:22:01') ,('15015','560','2','14363','4.99','2005-08-21 09:20:03','2006-02-15 22:22:01') ,('15016','560','1','14436','2.99','2005-08-21 11:48:27','2006-02-15 22:22:01') ,('15017','560','2','14785','2.99','2005-08-22 00:24:37','2006-02-15 22:22:02') ,('15018','560','1','15352','6.99','2005-08-22 21:16:54','2006-02-15 22:22:02') ,('15019','560','2','12116','5.98','2006-02-14 15:16:03','2006-02-15 22:22:02') ,('15020','560','2','14425','0.00','2006-02-14 15:16:03','2006-02-15 22:22:02') ,('15021','561','1','902','4.99','2005-05-30 09:53:36','2006-02-15 22:22:02') ,('15022','561','2','971','4.99','2005-05-30 20:10:52','2006-02-15 22:22:02') ,('15023','561','2','1193','2.99','2005-06-15 01:24:20','2006-02-15 22:22:02') ,('15024','561','2','1505','2.99','2005-06-15 22:12:50','2006-02-15 22:22:02') ,('15025','561','2','1620','4.99','2005-06-16 07:21:30','2006-02-15 22:22:02') ,('15026','561','1','2119','4.99','2005-06-17 20:34:42','2006-02-15 22:22:02') ,('15027','561','1','2357','5.99','2005-06-18 12:59:41','2006-02-15 22:22:02') ,('15028','561','1','2548','0.99','2005-06-19 02:45:35','2006-02-15 22:22:02') ,('15029','561','1','2950','4.99','2005-06-20 06:08:36','2006-02-15 22:22:02') ,('15030','561','1','3160','4.99','2005-06-20 21:20:51','2006-02-15 22:22:02') ,('15031','561','1','3427','0.99','2005-06-21 18:31:09','2006-02-15 22:22:03') ,('15032','561','2','6361','2.99','2005-07-11 21:09:14','2006-02-15 22:22:03') ,('15033','561','1','6435','0.99','2005-07-12 00:16:19','2006-02-15 22:22:03') ,('15034','561','1','6621','0.99','2005-07-12 08:57:30','2006-02-15 22:22:03') ,('15035','561','1','6843','4.99','2005-07-12 19:14:05','2006-02-15 22:22:03') ,('15036','561','1','7698','0.99','2005-07-28 03:44:14','2006-02-15 22:22:03') ,('15037','561','1','8504','10.99','2005-07-29 09:20:16','2006-02-15 22:22:03') ,('15038','561','2','9839','7.99','2005-07-31 12:21:16','2006-02-15 22:22:03') ,('15039','561','2','10317','2.99','2005-08-01 04:35:34','2006-02-15 22:22:03') ,('15040','561','1','10907','4.99','2005-08-02 01:51:48','2006-02-15 22:22:03') ,('15041','561','1','11371','2.99','2005-08-02 18:07:36','2006-02-15 22:22:03') ,('15042','561','2','11402','2.99','2005-08-02 19:07:21','2006-02-15 22:22:03') ,('15043','561','2','12441','2.99','2005-08-18 10:47:57','2006-02-15 22:22:03') ,('15044','561','2','14139','0.99','2005-08-21 02:04:33','2006-02-15 22:22:03') ,('15045','561','1','15573','0.99','2005-08-23 05:28:36','2006-02-15 22:22:03') ,('15046','561','1','15946','2.99','2005-08-23 18:54:07','2006-02-15 22:22:04') ,('15047','561','1','14415','0.99','2006-02-14 15:16:03','2006-02-15 22:22:04') ,('15048','562','2','788','2.99','2005-05-29 16:13:55','2006-02-15 22:22:04') ,('15049','562','1','941','2.99','2005-05-30 15:02:25','2006-02-15 22:22:04') ,('15050','562','1','1139','5.99','2005-05-31 19:34:52','2006-02-15 22:22:04') ,('15051','562','1','1998','3.99','2005-06-17 11:24:57','2006-02-15 22:22:04') ,('15052','562','1','2705','4.99','2005-06-19 13:54:30','2006-02-15 22:22:04') ,('15053','562','1','2746','3.99','2005-06-19 16:21:40','2006-02-15 22:22:04') ,('15054','562','2','3242','4.99','2005-06-21 02:56:24','2006-02-15 22:22:04') ,('15055','562','2','4732','5.99','2005-07-08 13:09:45','2006-02-15 22:22:04') ,('15056','562','1','4802','4.99','2005-07-08 16:55:17','2006-02-15 22:22:04') ,('15057','562','2','5360','0.99','2005-07-09 18:14:03','2006-02-15 22:22:04') ,('15058','562','2','6065','6.99','2005-07-11 04:25:51','2006-02-15 22:22:04') ,('15059','562','1','6607','8.99','2005-07-12 08:08:50','2006-02-15 22:22:04') ,('15060','562','2','7166','3.99','2005-07-27 07:36:56','2006-02-15 22:22:04') ,('15061','562','1','7430','2.99','2005-07-27 17:26:14','2006-02-15 22:22:05') ,('15062','562','2','7560','2.99','2005-07-27 22:20:17','2006-02-15 22:22:05') ,('15063','562','2','8132','0.99','2005-07-28 19:57:31','2006-02-15 22:22:05') ,('15064','562','2','10868','6.99','2005-08-02 00:25:15','2006-02-15 22:22:05') ,('15065','562','2','12008','4.99','2005-08-17 19:16:18','2006-02-15 22:22:05') ,('15066','562','1','12248','5.99','2005-08-18 03:53:18','2006-02-15 22:22:05') ,('15067','562','2','13225','2.99','2005-08-19 15:54:33','2006-02-15 22:22:05') ,('15068','562','2','13347','10.99','2005-08-19 20:28:48','2006-02-15 22:22:05') ,('15069','562','2','13639','0.99','2005-08-20 07:22:07','2006-02-15 22:22:05') ,('15070','562','1','15212','2.99','2005-08-22 16:44:26','2006-02-15 22:22:05') ,('15071','562','2','15475','2.99','2005-08-23 01:44:43','2006-02-15 22:22:05') ,('15072','562','1','15900','1.99','2005-08-23 17:16:30','2006-02-15 22:22:05') ,('15073','563','1','758','4.99','2005-05-29 10:31:56','2006-02-15 22:22:05') ,('15074','563','2','773','5.99','2005-05-29 13:18:05','2006-02-15 22:22:05') ,('15075','563','2','1545','4.99','2005-06-16 01:31:23','2006-02-15 22:22:06') ,('15076','563','2','2573','0.99','2005-06-19 04:23:18','2006-02-15 22:22:06') ,('15077','563','1','4106','1.99','2005-07-07 06:33:35','2006-02-15 22:22:06') ,('15078','563','2','4436','0.99','2005-07-07 22:52:04','2006-02-15 22:22:06') ,('15079','563','1','4565','3.99','2005-07-08 05:12:28','2006-02-15 22:22:06') ,('15080','563','2','4629','6.99','2005-07-08 08:31:26','2006-02-15 22:22:06') ,('15081','563','2','4711','2.99','2005-07-08 12:06:58','2006-02-15 22:22:06') ,('15082','563','2','4776','5.99','2005-07-08 15:44:20','2006-02-15 22:22:06') ,('15083','563','2','4808','3.99','2005-07-08 17:02:49','2006-02-15 22:22:06') ,('15084','563','2','4825','4.99','2005-07-08 17:43:01','2006-02-15 22:22:06') ,('15085','563','1','4883','0.99','2005-07-08 19:46:58','2006-02-15 22:22:06') ,('15086','563','1','5406','0.99','2005-07-09 20:13:23','2006-02-15 22:22:06') ,('15087','563','2','6326','2.99','2005-07-11 19:06:55','2006-02-15 22:22:06') ,('15088','563','2','7612','0.99','2005-07-28 00:11:55','2006-02-15 22:22:06') ,('15089','563','1','8262','1.99','2005-07-29 01:11:18','2006-02-15 22:22:06') ,('15090','563','1','8610','5.99','2005-07-29 13:25:02','2006-02-15 22:22:07') ,('15091','563','2','8632','6.99','2005-07-29 14:11:25','2006-02-15 22:22:07') ,('15092','563','2','8812','7.99','2005-07-29 21:47:40','2006-02-15 22:22:07') ,('15093','563','2','11829','0.99','2005-08-17 12:52:04','2006-02-15 22:22:07') ,('15094','563','1','12039','1.99','2005-08-17 20:29:08','2006-02-15 22:22:07') ,('15095','563','1','12202','1.99','2005-08-18 02:14:08','2006-02-15 22:22:07') ,('15096','563','1','12832','2.99','2005-08-19 01:41:44','2006-02-15 22:22:07') ,('15097','563','2','13863','9.99','2005-08-20 14:57:50','2006-02-15 22:22:07') ,('15098','563','2','14592','4.99','2005-08-21 17:30:17','2006-02-15 22:22:07') ,('15099','563','2','15507','0.99','2005-08-23 02:48:26','2006-02-15 22:22:07') ,('15100','563','2','15638','3.99','2005-08-23 07:54:54','2006-02-15 22:22:07') ,('15101','563','1','15850','4.99','2005-08-23 15:45:42','2006-02-15 22:22:07') ,('15102','564','2','195','5.99','2005-05-26 06:52:36','2006-02-15 22:22:07') ,('15103','564','1','985','2.99','2005-05-30 22:18:35','2006-02-15 22:22:07') ,('15104','564','2','1705','2.99','2005-06-16 13:59:42','2006-02-15 22:22:07') ,('15105','564','1','4196','2.99','2005-07-07 11:06:33','2006-02-15 22:22:08') ,('15106','564','2','4385','0.99','2005-07-07 20:48:38','2006-02-15 22:22:08') ,('15107','564','1','6973','2.99','2005-07-27 00:32:04','2006-02-15 22:22:08') ,('15108','564','2','7470','10.99','2005-07-27 19:01:03','2006-02-15 22:22:08') ,('15109','564','2','8426','4.99','2005-07-29 07:07:48','2006-02-15 22:22:08') ,('15110','564','1','8874','0.99','2005-07-30 00:14:45','2006-02-15 22:22:08') ,('15111','564','2','9063','3.99','2005-07-30 07:24:34','2006-02-15 22:22:08') ,('15112','564','2','9929','2.99','2005-07-31 15:17:24','2006-02-15 22:22:08') ,('15113','564','1','10129','6.99','2005-07-31 21:41:35','2006-02-15 22:22:08') ,('15114','564','2','10352','1.99','2005-08-01 05:44:36','2006-02-15 22:22:08') ,('15115','564','2','10401','4.99','2005-08-01 07:27:09','2006-02-15 22:22:08') ,('15116','564','1','10528','2.99','2005-08-01 11:56:22','2006-02-15 22:22:08') ,('15117','564','2','11768','2.99','2005-08-17 10:02:29','2006-02-15 22:22:08') ,('15118','564','2','12197','6.99','2005-08-18 02:08:58','2006-02-15 22:22:08') ,('15119','564','2','12617','2.99','2005-08-18 17:22:48','2006-02-15 22:22:09') ,('15120','564','2','13324','0.99','2005-08-19 19:51:00','2006-02-15 22:22:09') ,('15121','564','2','13558','0.99','2005-08-20 04:13:17','2006-02-15 22:22:09') ,('15122','564','1','13701','0.99','2005-08-20 09:27:05','2006-02-15 22:22:09') ,('15123','564','2','14439','5.99','2005-08-21 11:52:41','2006-02-15 22:22:09') ,('15124','564','1','14593','0.99','2005-08-21 17:33:18','2006-02-15 22:22:09') ,('15125','564','2','15059','8.99','2005-08-22 10:22:00','2006-02-15 22:22:09') ,('15126','565','1','458','6.99','2005-05-27 19:58:36','2006-02-15 22:22:09') ,('15127','565','1','1004','0.99','2005-05-31 00:48:36','2006-02-15 22:22:09') ,('15128','565','2','1460','4.99','2005-06-15 20:27:02','2006-02-15 22:22:09') ,('15129','565','1','2321','5.99','2005-06-18 09:42:42','2006-02-15 22:22:09') ,('15130','565','1','3300','5.99','2005-06-21 07:25:01','2006-02-15 22:22:09') ,('15131','565','2','3470','0.99','2005-07-05 22:49:24','2006-02-15 22:22:09') ,('15132','565','1','3838','2.99','2005-07-06 16:29:43','2006-02-15 22:22:09') ,('15133','565','1','4413','2.99','2005-07-07 22:00:04','2006-02-15 22:22:09') ,('15134','565','2','5020','0.99','2005-07-09 02:07:56','2006-02-15 22:22:10') ,('15135','565','1','5124','4.99','2005-07-09 07:25:19','2006-02-15 22:22:10') ,('15136','565','1','6264','2.99','2005-07-11 15:42:35','2006-02-15 22:22:10') ,('15137','565','1','6627','2.99','2005-07-12 09:16:46','2006-02-15 22:22:10') ,('15138','565','1','6699','0.99','2005-07-12 12:45:21','2006-02-15 22:22:10') ,('15139','565','2','7242','5.99','2005-07-27 10:25:51','2006-02-15 22:22:10') ,('15140','565','1','9628','2.99','2005-07-31 04:51:11','2006-02-15 22:22:10') ,('15141','565','1','10025','5.99','2005-07-31 18:29:09','2006-02-15 22:22:10') ,('15142','565','2','10776','10.99','2005-08-01 20:59:58','2006-02-15 22:22:10') ,('15143','565','2','10913','3.99','2005-08-02 02:04:03','2006-02-15 22:22:10') ,('15144','565','2','11189','6.99','2005-08-02 11:17:23','2006-02-15 22:22:10') ,('15145','565','1','11399','3.99','2005-08-02 18:56:28','2006-02-15 22:22:10') ,('15146','565','2','11506','4.99','2005-08-16 23:25:48','2006-02-15 22:22:10') ,('15147','565','1','11588','3.99','2005-08-17 02:26:23','2006-02-15 22:22:10') ,('15148','565','1','11795','2.99','2005-08-17 11:13:38','2006-02-15 22:22:10') ,('15149','565','2','12743','5.99','2005-08-18 22:22:31','2006-02-15 22:22:11') ,('15150','565','2','13195','4.99','2005-08-19 14:39:14','2006-02-15 22:22:11') ,('15151','565','2','13217','4.99','2005-08-19 15:38:39','2006-02-15 22:22:11') ,('15152','565','1','13362','0.99','2005-08-19 21:07:54','2006-02-15 22:22:11') ,('15153','565','1','13925','8.99','2005-08-20 17:05:34','2006-02-15 22:22:11') ,('15154','565','1','15885','2.99','2005-08-23 16:50:43','2006-02-15 22:22:11') ,('15155','566','2','234','5.99','2005-05-26 11:47:20','2006-02-15 22:22:11') ,('15156','566','2','768','4.99','2005-05-29 12:30:46','2006-02-15 22:22:11') ,('15157','566','1','1635','5.99','2005-06-16 08:26:56','2006-02-15 22:22:11') ,('15158','566','2','1982','4.99','2005-06-17 10:12:15','2006-02-15 22:22:11') ,('15159','566','1','2367','0.99','2005-06-18 14:00:31','2006-02-15 22:22:11') ,('15160','566','1','3379','4.99','2005-06-21 13:54:58','2006-02-15 22:22:11') ,('15161','566','2','3663','4.99','2005-07-06 08:15:47','2006-02-15 22
1 row in set (0.058 sec)
第一个sql_id 有两个不同的文本，这两个文本的不同仅仅是传入参数不同，可以共享执行计划，这个计划的plan_id 为40，运行下面sql查询这条语句的实际执行计划
SELECT ip, plan_depth, plan_line_id,operator,name,rows,cost,property from oceanbase.`gv$plan_cache_plan_explain`
where tenant_id=1001 AND ip = '127.0.0.1' AND port=2882 AND plan_id=40;
查询结果为空集，看来这条语句的实际执行计划已经被从缓存里刷出去了，切换到tpcc db运行以下这条语句后，再进行查询，得到下面的执行计划
MySQL [oceanbase]> SELECT ip, plan_depth, plan_line_id,operator,name,rows,cost,property from oceanbase.`gv$plan_cache_plan_explain`
-> where tenant_id=1001 AND ip = '127.0.0.1' AND port=2882 AND plan_id=29;
+-----------+------------+--------------+-------------------+------+------+------+----------+
| ip | plan_depth | plan_line_id | operator | name | rows | cost | property |
+-----------+------------+--------------+-------------------+------+------+------+----------+
| 127.0.0.1 | 0 | 0 | PHY_INSERT_ON_DUP | NULL | 1713 | 472 | NULL |
| 127.0.0.1 | 1 | 1 | PHY_EXPR_VALUES | NULL | 1713 | 236 | NULL |
+-----------+------------+--------------+-------------------+------+------+------+----------+
这条语句的解释执行计划如下：
*************************** 1. row ***************************
Query Plan: ============================================
|ID|OPERATOR |NAME |EST. ROWS|COST |
--------------------------------------------
|0 |TABLE SCAN|bmsql_stock|9 |248250|
============================================
Outputs & filters:
-------------------------------------
0 - output([bmsql_stock.s_quantity], [bmsql_stock.s_data], [bmsql_stock.s_dist_01], [bmsql_stock.s_dist_02], [bmsql_stock.s_dist_03], [bmsql_stock.s_dist_04], [bmsql_stock.s_dist_05], [bmsql_stock.s_dist_06], [bmsql_stock.s_dist_07], [bmsql_stock.s_dist_08], [bmsql_stock.s_dist_09], [bmsql_stock.s_dist_10]), filter([bmsql_stock.s_w_id = 2], [bmsql_stock.s_i_id = 10652]),
access([bmsql_stock.s_w_id], [bmsql_stock.s_i_id], [bmsql_stock.s_quantity], [bmsql_stock.s_data], [bmsql_stock.s_dist_01], [bmsql_stock.s_dist_02], [bmsql_stock.s_dist_03], [bmsql_stock.s_dist_04], [bmsql_stock.s_dist_05], [bmsql_stock.s_dist_06], [bmsql_stock.s_dist_07], [bmsql_stock.s_dist_08], [bmsql_stock.s_dist_09], [bmsql_stock.s_dist_10]), partitions(p0)
1 row in set (0.016 sec)
可以看到，这条语句实际的执行计划和解释执行计划是相同的，都做了全表扫描，成本显示也相同。
获取第二条语句的文本
MySQL [oceanbase]> select query_sql from gv$sql_audit where sql_id='F59A700FA168324279B0DBC25E19760F';
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| query_sql |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock WHERE s_w_id = 2 AND s_quantity < 13 AND s_i_id IN (SELECT ol_i_id FROM bmsql_district JOIN bmsql_order_line ON ol_w_id = d_w_id AND ol_d_id = d_id AND ol_o_id >= d_next_o_id - 20 AND ol_o_id < d_next_o_id WHERE d_w_id = 2 AND d_id = 8 ) ) |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.069 sec)
实际执行计划
MySQL [oceanbase]> SELECT ip, plan_depth, plan_line_id,operator,name,rows,cost,property from oceanbase.`gv$plan_cache_plan_explain` where tenant_id=1001 AND ip = '127.0.0.1' AND port=2882 AND plan_id=42\G;
*************************** 1. row ***************************
ip: 127.0.0.1
plan_depth: 0
plan_line_id: 0
operator: PHY_SCALAR_AGGREGATE
name: NULL
rows: 1
cost: 811804
property: NULL
*************************** 2. row ***************************
ip: 127.0.0.1
plan_depth: 1
plan_line_id: 1
operator: PHY_HASH_JOIN
name: NULL
rows: 2
cost: 811804
property: NULL
*************************** 3. row ***************************
ip: 127.0.0.1
plan_depth: 2
plan_line_id: 2
operator: PHY_SUBPLAN_SCAN
name: NULL
rows: 1
cost: 612151
property: NULL
*************************** 4. row ***************************
ip: 127.0.0.1
plan_depth: 3
plan_line_id: 3
operator: PHY_NESTED_LOOP_JOIN
name: NULL
rows: 1
cost: 612151
property: NULL
*************************** 5. row ***************************
ip: 127.0.0.1
plan_depth: 4
plan_line_id: 4
operator: PHY_TABLE_SCAN
name: bmsql_order_line
rows: 40
cost: 612101
property: table_rows:404006, physical_range_rows:600330, logical_range_rows:404006, index_back_rows:0, output_rows:39, est_method:local_storage, avaiable_index_name[bmsql_order_line], estimation info[table_id:1100611139453797, (table_type:1, version:0-1-1, logical_rc:0, physical_rc:0), (table_type:7, version:1-1643245354224215-1643245354224215, logical_rc:0, physical_rc:173262), (table_type:0, version:1643245354224215-1643245354224215-9223372036854775807, logical_rc:404006, physical_rc:427068)]
*************************** 6. row ***************************
ip: 127.0.0.1
plan_depth: 4
plan_line_id: 5
operator: PHY_MATERIAL
name: NULL
rows: 1
cost: 50
property: NULL
*************************** 7. row ***************************
ip: 127.0.0.1
plan_depth: 5
plan_line_id: 6
operator: PHY_TABLE_SCAN
name: bmsql_district
rows: 1
cost: 50
property: table_rows:20, physical_range_rows:20, logical_range_rows:20, index_back_rows:0, output_rows:0, est_method:local_storage, avaiable_index_name[bmsql_district], estimation info[table_id:1100611139453792, (table_type:1, version:0-1-1, logical_rc:0, physical_rc:0), (table_type:7, version:1-1643245354224215-1643245354224215, logical_rc:0, physical_rc:0), (table_type:0, version:1643245354224215-1643245354224215-9223372036854775807, logical_rc:20, physical_rc:20)]
*************************** 8. row ***************************
ip: 127.0.0.1
plan_depth: 2
plan_line_id: 7
operator: PHY_TABLE_SCAN
name: bmsql_stock
rows: 91
cost: 199621
property: table_rows:91148, physical_range_rows:200114, logical_range_rows:91148, index_back_rows:0, output_rows:90, est_method:local_storage, avaiable_index_name[bmsql_stock], estimation info[table_id:1100611139453798, (table_type:1, version:0-1-1, logical_rc:0, physical_rc:0), (table_type:7, version:1-1643245354224215-1643245354224215, logical_rc:0, physical_rc:96654), (table_type:0, version:1643245354224215-1643245354224215-9223372036854775807, logical_rc:91148, physical_rc:103460)]
8 rows in set (0.005 sec)
解释执行计划
explain SELECT count(*) AS low_stock FROM (SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock
WHERE s_w_id = 2 AND s_quantity < 13 AND s_i_id IN (
SELECT ol_i_id FROM bmsql_district JOIN bmsql_order_line ON ol_w_id = d_w_id
AND ol_d_id = d_id AND ol_o_id >= d_next_o_id - 20 AND ol_o_id < d_next_o_id WHERE d_w_id = 2 AND d_id = 8))\G;
MySQL [tpccdb]> explain SELECT count(*) AS low_stock FROM (SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock
-> WHERE s_w_id = 2 AND s_quantity < 13 AND s_i_id IN (
-> SELECT ol_i_id FROM bmsql_district JOIN bmsql_order_line ON ol_w_id = d_w_id
-> AND ol_d_id = d_id AND ol_o_id >= d_next_o_id - 20 AND ol_o_id < d_next_o_id WHERE d_w_id = 2 AND d_id = 8))\G;
*************************** 1. row ***************************
Query Plan: ============================================================
|ID|OPERATOR |NAME |EST. ROWS|COST |
------------------------------------------------------------
|0 |SCALAR GROUP BY | |1 |812132|
|1 | HASH RIGHT SEMI JOIN| |2 |812131|
|2 | SUBPLAN SCAN |VIEW1 |1 |612420|
|3 | NESTED-LOOP JOIN | |1 |612419|
|4 | TABLE SCAN |bmsql_order_line|37 |612369|
|5 | MATERIAL | |1 |51 |
|6 | TABLE SCAN |bmsql_district |1 |51 |
|7 | TABLE SCAN |bmsql_stock |86 |199683|
============================================================
Outputs & filters:
-------------------------------------
0 - output([T_FUN_COUNT(*)]), filter(nil),
group(nil), agg_func([T_FUN_COUNT(*)])
1 - output([1]), filter(nil),
equal_conds([bmsql_stock.s_i_id = VIEW1.ol_i_id]), other_conds(nil)
2 - output([VIEW1.ol_i_id]), filter(nil),
access([VIEW1.ol_i_id])
3 - output([bmsql_order_line.ol_i_id]), filter(nil),
conds([bmsql_order_line.ol_o_id >= bmsql_district.d_next_o_id - 20], [bmsql_order_line.ol_o_id < bmsql_district.d_next_o_id]), nl_params_(nil)
4 - output([bmsql_order_line.ol_o_id], [bmsql_order_line.ol_i_id]), filter([bmsql_order_line.ol_w_id = 2], [bmsql_order_line.ol_d_id = 8]),
access([bmsql_order_line.ol_w_id], [bmsql_order_line.ol_d_id], [bmsql_order_line.ol_o_id], [bmsql_order_line.ol_i_id]), partitions(p0)
5 - output([bmsql_district.d_next_o_id]), filter(nil)
6 - output([bmsql_district.d_next_o_id]), filter([bmsql_district.d_w_id = 2], [bmsql_district.d_id = 8], [bmsql_district.d_next_o_id > bmsql_district.d_next_o_id - 20]),
access([bmsql_district.d_w_id], [bmsql_district.d_id], [bmsql_district.d_next_o_id]), partitions(p0)
7 - output([bmsql_stock.s_i_id]), filter([bmsql_stock.s_w_id = 2], [bmsql_stock.s_quantity < 13]),
access([bmsql_stock.s_w_id], [bmsql_stock.s_quantity], [bmsql_stock.s_i_id]), partitions(p0)
1 row in set (0.016 sec)
这条语句的解释执行计划和实际执行计划也是相同的
获取第三条语句的文本
MySQL [oceanbase]> select query_sql from gv$sql_audit where sql_id='5984364296F35BE1B71CD5622426385A'; +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | query_sql | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | SELECT ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d FROM bmsql_order_line WHERE ol_w_id = 2 AND ol_d_id = 4 AND ol_o_id = 1182 ORDER BY ol_w_id, ol_d_id, ol_o_id, ol_number | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.060 sec)
实际执行计划
MySQL [oceanbase]> SELECT ip, plan_depth, plan_line_id,operator,name,rows,cost,property from oceanbase.`gv$plan_cache_plan_explain` where tenant_id=1001 AND ip = '127.0.0.1' AND port=2882 AND plan_id=30\G
*************************** 1. row ***************************
ip: 127.0.0.1
plan_depth: 0
plan_line_id: 0
operator: PHY_SCALAR_AGGREGATE
name: NULL
rows: 1
cost: 7615
property: NULL
*************************** 2. row ***************************
ip: 127.0.0.1
plan_depth: 1
plan_line_id: 1
operator: PHY_TABLE_SCAN
name: payment(idx_fk_staff_id)
rows: 15988
cost: 4561
property: table_rows:16015, physical_range_rows:15988, logical_range_rows:15988, index_back_rows:0, output_rows:15988, est_method:local_storage, avaiable_index_name[idx_fk_staff_id,idx_fk_customer_id,fk_payment_rental,payment], estimation info[table_id:1100611139453839, (table_type:1, version:0-1-1, logical_rc:0, physical_rc:0), (table_type:0, version:1-1-9223372036854775807, logical_rc:15988, physical_rc:15988)]
2 rows in set (0.008 sec)
解释执行计划
explain SELECT ol_i_id, ol_supply_w_id, ol_quantity,
ol_amount, ol_delivery_d
FROM bmsql_order_line WHERE ol_w_id = 2 AND ol_d_id = 4 AND ol_o_id = 1182
ORDER BY ol_w_id, ol_d_id, ol_o_id, ol_number\G;
MySQL [tpccdb]> explain SELECT ol_i_id, ol_supply_w_id, ol_quantity,
-> ol_amount, ol_delivery_d
-> FROM bmsql_order_line WHERE ol_w_id = 2 AND ol_d_id = 4 AND ol_o_id = 1182
-> ORDER BY ol_w_id, ol_d_id, ol_o_id, ol_number\G;
*************************** 1. row ***************************
Query Plan: ==================================================
|ID|OPERATOR |NAME |EST. ROWS|COST |
--------------------------------------------------
|0 |SORT | |1 |779182|
|1 | TABLE SCAN|bmsql_order_line|1 |779181|
==================================================
Outputs & filters:
-------------------------------------
0 - output([bmsql_order_line.ol_i_id], [bmsql_order_line.ol_supply_w_id], [bmsql_order_line.ol_quantity], [bmsql_order_line.ol_amount], [bmsql_order_line.ol_delivery_d]), filter(nil), sort_keys([bmsql_order_line.ol_number, ASC])
1 - output([bmsql_order_line.ol_i_id], [bmsql_order_line.ol_supply_w_id], [bmsql_order_line.ol_quantity], [bmsql_order_line.ol_amount], [bmsql_order_line.ol_delivery_d], [bmsql_order_line.ol_number]), filter([bmsql_order_line.ol_w_id = 2], [bmsql_order_line.ol_d_id = 4], [bmsql_order_line.ol_o_id = 1182]),
access([bmsql_order_line.ol_w_id], [bmsql_order_line.ol_d_id], [bmsql_order_line.ol_o_id], [bmsql_order_line.ol_i_id], [bmsql_order_line.ol_supply_w_id], [bmsql_order_line.ol_quantity], [bmsql_order_line.ol_amount], [bmsql_order_line.ol_delivery_d], [bmsql_order_line.ol_number]), partitions(p0)
1 row in set (0.007 sec)
这条语句的解释执行计划和实际执行计划也是相同的，都是全表扫描之后进行排序。
结论，后面在研究一下官方文档，本身oeanbase数据字典也比较少，所以看起来还是比较快的。
1724
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
