1 | mysql> select * from recordedseek where chanid=8035 and starttime=20131027145701 order by mark, type; |
---|
2 | +--------+---------------------+------+----------+------+ |
---|
3 | | chanid | starttime | mark | offset | type | |
---|
4 | +--------+---------------------+------+----------+------+ |
---|
5 | | 8035 | 2013-10-27 14:57:01 | 0 | 0 | 9 | |
---|
6 | | 8035 | 2013-10-27 14:57:01 | 0 | 0 | 33 | |
---|
7 | | 8035 | 2013-10-27 14:57:01 | 32 | 1287236 | 9 | |
---|
8 | | 8035 | 2013-10-27 14:57:01 | 32 | 1280 | 33 | |
---|
9 | | 8035 | 2013-10-27 14:57:01 | 64 | 2698740 | 9 | |
---|
10 | | 8035 | 2013-10-27 14:57:01 | 64 | 2560 | 33 | |
---|
11 | | 8035 | 2013-10-27 14:57:01 | 96 | 4149348 | 9 | |
---|
12 | | 8035 | 2013-10-27 14:57:01 | 96 | 3840 | 33 | |
---|
13 | | 8035 | 2013-10-27 14:57:01 | 128 | 5580780 | 9 | |
---|
14 | | 8035 | 2013-10-27 14:57:01 | 128 | 5120 | 33 | |
---|
15 | | 8035 | 2013-10-27 14:57:01 | 156 | 6907684 | 9 | |
---|
16 | | 8035 | 2013-10-27 14:57:01 | 156 | 6240 | 33 | |
---|
17 | | 8035 | 2013-10-27 14:57:01 | 188 | 8661724 | 9 | |
---|
18 | | 8035 | 2013-10-27 14:57:01 | 188 | 7520 | 33 | |
---|
19 | | 8035 | 2013-10-27 14:57:01 | 208 | 9933544 | 9 | |
---|
20 | | 8035 | 2013-10-27 14:57:01 | 208 | 8320 | 33 | |
---|
21 | | 8035 | 2013-10-27 14:57:01 | 240 | 11584936 | 9 | |
---|
22 | | 8035 | 2013-10-27 14:57:01 | 240 | 9600 | 33 | |
---|
23 | | 8035 | 2013-10-27 14:57:01 | 272 | 13289720 | 9 | |
---|
24 | | 8035 | 2013-10-27 14:57:01 | 272 | 10880 | 33 | |
---|
25 | | 8035 | 2013-10-27 14:57:01 | 304 | 15146972 | 9 | |
---|
26 | | 8035 | 2013-10-27 14:57:01 | 304 | 12160 | 33 | |
---|
27 | | 8035 | 2013-10-27 14:57:01 | 320 | 16239816 | 9 | |
---|
28 | | 8035 | 2013-10-27 14:57:01 | 320 | 12800 | 33 | |
---|
29 | | 8035 | 2013-10-27 14:57:01 | 352 | 17886132 | 9 | |
---|
30 | | 8035 | 2013-10-27 14:57:01 | 352 | 14080 | 33 | |
---|
31 | | 8035 | 2013-10-27 14:57:01 | 384 | 19705784 | 9 | |
---|
32 | | 8035 | 2013-10-27 14:57:01 | 384 | 15360 | 33 | |
---|
33 | | 8035 | 2013-10-27 14:57:01 | 416 | 21508704 | 9 | |
---|
34 | | 8035 | 2013-10-27 14:57:01 | 416 | 16640 | 33 | |
---|
35 | | 8035 | 2013-10-27 14:57:01 | 448 | 23531208 | 9 | |
---|
36 | | 8035 | 2013-10-27 14:57:01 | 448 | 17920 | 33 | |
---|
37 | | 8035 | 2013-10-27 14:57:01 | 480 | 25540552 | 9 | |
---|
38 | | 8035 | 2013-10-27 14:57:01 | 480 | 19200 | 33 | |
---|
39 | | 8035 | 2013-10-27 14:57:01 | 512 | 27460032 | 9 | |
---|
40 | | 8035 | 2013-10-27 14:57:01 | 512 | 20480 | 33 | |
---|
41 | | 8035 | 2013-10-27 14:57:01 | 544 | 29441364 | 9 | |
---|
42 | | 8035 | 2013-10-27 14:57:01 | 544 | 21760 | 33 | |
---|
43 | | 8035 | 2013-10-27 14:57:01 | 576 | 31340540 | 9 | |
---|
44 | | 8035 | 2013-10-27 14:57:01 | 576 | 23040 | 33 | |
---|
45 | | 8035 | 2013-10-27 14:57:01 | 608 | 33045888 | 9 | |
---|
46 | | 8035 | 2013-10-27 14:57:01 | 608 | 24320 | 33 | |
---|
47 | | 8035 | 2013-10-27 14:57:01 | 640 | 34614372 | 9 | |
---|
48 | | 8035 | 2013-10-27 14:57:01 | 640 | 25600 | 33 | |
---|
49 | | 8035 | 2013-10-27 14:57:01 | 672 | 36169696 | 9 | |
---|
50 | | 8035 | 2013-10-27 14:57:01 | 672 | 26880 | 33 | |
---|
51 | | 8035 | 2013-10-27 14:57:01 | 704 | 37655836 | 9 | |
---|
52 | | 8035 | 2013-10-27 14:57:01 | 704 | 28160 | 33 | |
---|
53 | | 8035 | 2013-10-27 14:57:01 | 736 | 39179952 | 9 | |
---|
54 | | 8035 | 2013-10-27 14:57:01 | 736 | 29440 | 33 | |
---|
55 | | 8035 | 2013-10-27 14:57:01 | 768 | 40731328 | 9 | |
---|
56 | | 8035 | 2013-10-27 14:57:01 | 768 | 30720 | 33 | |
---|
57 | | 8035 | 2013-10-27 14:57:01 | 800 | 42232884 | 9 | |
---|
58 | | 8035 | 2013-10-27 14:57:01 | 800 | 32000 | 33 | |
---|
59 | | 8035 | 2013-10-27 14:57:01 | 832 | 43824680 | 9 | |
---|
60 | | 8035 | 2013-10-27 14:57:01 | 832 | 33280 | 33 | |
---|
61 | | 8035 | 2013-10-27 14:57:01 | 864 | 45525704 | 9 | |
---|
62 | | 8035 | 2013-10-27 14:57:01 | 864 | 34560 | 33 | |
---|
63 | | 8035 | 2013-10-27 14:57:01 | 896 | 47144008 | 9 | |
---|
64 | | 8035 | 2013-10-27 14:57:01 | 896 | 35840 | 33 | |
---|
65 | | 8035 | 2013-10-27 14:57:01 | 928 | 48882820 | 9 | |
---|
66 | | 8035 | 2013-10-27 14:57:01 | 928 | 37120 | 33 | |
---|
67 | | 8035 | 2013-10-27 14:57:01 | 960 | 50577452 | 9 | |
---|
68 | | 8035 | 2013-10-27 14:57:01 | 960 | 38400 | 33 | |
---|
69 | | 8035 | 2013-10-27 14:57:01 | 992 | 52489224 | 9 | |
---|
70 | | 8035 | 2013-10-27 14:57:01 | 992 | 39680 | 33 | |
---|
71 | | 8035 | 2013-10-27 14:57:01 | 1024 | 54511352 | 9 | |
---|
72 | | 8035 | 2013-10-27 14:57:01 | 1024 | 40960 | 33 | |
---|
73 | | 8035 | 2013-10-27 14:57:01 | 1056 | 56476516 | 9 | |
---|
74 | | 8035 | 2013-10-27 14:57:01 | 1056 | 42240 | 33 | |
---|
75 | | 8035 | 2013-10-27 14:57:01 | 1088 | 57956640 | 9 | |
---|
76 | | 8035 | 2013-10-27 14:57:01 | 1088 | 43520 | 33 | |
---|
77 | | 8035 | 2013-10-27 14:57:01 | 1120 | 59404616 | 9 | |
---|
78 | | 8035 | 2013-10-27 14:57:01 | 1120 | 44800 | 33 | |
---|
79 | | 8035 | 2013-10-27 14:57:01 | 1152 | 60850524 | 9 | |
---|
80 | | 8035 | 2013-10-27 14:57:01 | 1152 | 46080 | 33 | |
---|
81 | | 8035 | 2013-10-27 14:57:01 | 1188 | 62375956 | 9 | |
---|
82 | | 8035 | 2013-10-27 14:57:01 | 1188 | 47520 | 33 | |
---|
83 | | 8035 | 2013-10-27 14:57:01 | 1220 | 63327800 | 9 | |
---|
84 | | 8035 | 2013-10-27 14:57:01 | 1220 | 48800 | 33 | |
---|
85 | | 8035 | 2013-10-27 14:57:01 | 1252 | 64324764 | 9 | |
---|
86 | | 8035 | 2013-10-27 14:57:01 | 1252 | 50080 | 33 | |
---|
87 | | 8035 | 2013-10-27 14:57:01 | 1284 | 65628168 | 9 | |
---|
88 | | 8035 | 2013-10-27 14:57:01 | 1284 | 51360 | 33 | |
---|
89 | | 8035 | 2013-10-27 14:57:01 | 1316 | 66812192 | 9 | |
---|
90 | | 8035 | 2013-10-27 14:57:01 | 1316 | 52640 | 33 | |
---|
91 | | 8035 | 2013-10-27 14:57:01 | 1348 | 67713840 | 9 | |
---|
92 | | 8035 | 2013-10-27 14:57:01 | 1348 | 53920 | 33 | |
---|
93 | | 8035 | 2013-10-27 14:57:01 | 1380 | 68117852 | 9 | |
---|
94 | | 8035 | 2013-10-27 14:57:01 | 1380 | 55200 | 33 | |
---|
95 | | 8035 | 2013-10-27 14:57:01 | 1412 | 69033976 | 9 | |
---|
96 | | 8035 | 2013-10-27 14:57:01 | 1412 | 56480 | 33 | |
---|
97 | | 8035 | 2013-10-27 14:57:01 | 1444 | 70196756 | 9 | |
---|
98 | | 8035 | 2013-10-27 14:57:01 | 1444 | 57760 | 33 | |
---|
99 | | 8035 | 2013-10-27 14:57:01 | 1476 | 71458612 | 9 | |
---|
100 | | 8035 | 2013-10-27 14:57:01 | 1476 | 59040 | 33 | |
---|
101 | | 8035 | 2013-10-27 14:57:01 | 1508 | 72779124 | 9 | |
---|
102 | | 8035 | 2013-10-27 14:57:01 | 1508 | 60320 | 33 | |
---|
103 | +--------+---------------------+------+----------+------+ |
---|
104 | 98 rows in set (0.00 sec) |
---|