1 | 12:07:37.827439 IP (tos 0x8, ttl 64, id 50840, offset 0, flags [DF], proto TCP (6), length 419, bad cksum 0 (->74b2)!)
|
---|
2 | 127.0.0.1.54268 > 127.0.0.1.3306: Flags [P.], cksum 0xff97 (incorrect -> 0xbb5b), seq 78026:78393, ack 80361, win 65535, options [nop,nop,TS val 882630265 ecr 882630265], length 367
|
---|
3 | 0x0000: 4508 01a3 c698 4000 4006 0000 7f00 0001 E.....@.@.......
|
---|
4 | 0x0010: 7f00 0001 d3fc 0cea 2f2b abd5 0921 aeb0 ......../+...!..
|
---|
5 | 0x0020: 8018 ffff ff97 0000 0101 080a 349b de79 ............4..y
|
---|
6 | 0x0030: 349b de79 6b01 0000 0353 454c 4543 5420 4..yk....SELECT.
|
---|
7 | 0x0040: 6071 7565 7269 6573 5f74 6167 602e 6069 `queries_tag`.`i
|
---|
8 | 0x0050: 6460 2c20 6071 7565 7269 6573 5f74 6167 d`,.`queries_tag
|
---|
9 | 0x0060: 602e 606e 616d 6560 2c20 6071 7565 7269 `.`name`,.`queri
|
---|
10 | 0x0070: 6573 5f74 6167 602e 6070 6172 656e 745f es_tag`.`parent_
|
---|
11 | 0x0080: 6964 602c 2060 7175 6572 6965 735f 7461 id`,.`queries_ta
|
---|
12 | 0x0090: 6760 2e60 6361 7465 676f 7279 5f69 6460 g`.`category_id`
|
---|
13 | 0x00a0: 2046 524f 4d20 6071 7565 7269 6573 5f74 .FROM.`queries_t
|
---|
14 | 0x00b0: 6167 6020 5748 4552 4520 4e4f 5420 2828 ag`.WHERE.NOT.((
|
---|
15 | 0x00c0: 6071 7565 7269 6573 5f74 6167 602e 6069 `queries_tag`.`i
|
---|
16 | 0x00d0: 6460 2049 4e20 2853 454c 4543 5420 5530 d`.IN.(SELECT.U0
|
---|
17 | 0x00e0: 2e60 6964 6020 4652 4f4d 2060 7175 6572 .`id`.FROM.`quer
|
---|
18 | 0x00f0: 6965 735f 7461 6760 2055 3020 4c45 4654 ies_tag`.U0.LEFT
|
---|
19 | 0x0100: 204f 5554 4552 204a 4f49 4e20 6071 7565 .OUTER.JOIN.`que
|
---|
20 | 0x0110: 7269 6573 5f74 6167 6020 5531 204f 4e20 ries_tag`.U1.ON.
|
---|
21 | 0x0120: 2855 302e 6069 6460 203d 2055 312e 6070 (U0.`id`.=.U1.`p
|
---|
22 | 0x0130: 6172 656e 745f 6964 6029 2057 4845 5245 arent_id`).WHERE
|
---|
23 | 0x0140: 2055 312e 6069 6460 2049 5320 4e55 4c4c .U1.`id`.IS.NULL
|
---|
24 | 0x0150: 2920 414e 4420 4e4f 5420 2860 7175 6572 ).AND.NOT.(`quer
|
---|
25 | 0x0160: 6965 735f 7461 6760 2e60 6964 6020 4953 ies_tag`.`id`.IS
|
---|
26 | 0x0170: 204e 554c 4c29 2929 204f 5244 4552 2042 .NULL))).ORDER.B
|
---|
27 | 0x0180: 5920 6071 7565 7269 6573 5f74 6167 602e Y.`queries_tag`.
|
---|
28 | 0x0190: 606e 616d 6560 2041 5343 204c 494d 4954 `name`.ASC.LIMIT
|
---|
29 | 0x01a0: 2032 31 .21
|
---|
30 | 12:07:37.827466 IP (tos 0x8, ttl 64, id 3760, offset 0, flags [DF], proto TCP (6), length 52, bad cksum 0 (->2e0a)!)
|
---|
31 | 127.0.0.1.3306 > 127.0.0.1.54268: Flags [.], cksum 0xfe28 (incorrect -> 0xdd68), seq 80361, ack 78393, win 65535, options [nop,nop,TS val 882630265 ecr 882630265], length 0
|
---|
32 | 0x0000: 4508 0034 0eb0 4000 4006 0000 7f00 0001 E..4..@.@.......
|
---|
33 | 0x0010: 7f00 0001 0cea d3fc 0921 aeb0 2f2b ad44 .........!../+.D
|
---|
34 | 0x0020: 8010 ffff fe28 0000 0101 080a 349b de79 .....(......4..y
|
---|
35 | 0x0030: 349b de79 4..y
|
---|
36 | 12:07:37.827910 IP (tos 0x8, ttl 64, id 50563, offset 0, flags [DF], proto TCP (6), length 383, bad cksum 0 (->75eb)!)
|
---|
37 | 127.0.0.1.3306 > 127.0.0.1.54268: Flags [P.], cksum 0xff73 (incorrect -> 0x31ce), seq 80361:80692, ack 78393, win 65535, options [nop,nop,TS val 882630265 ecr 882630265], length 331
|
---|
38 | 0x0000: 4508 017f c583 4000 4006 0000 7f00 0001 E.....@.@.......
|
---|
39 | 0x0010: 7f00 0001 0cea d3fc 0921 aeb0 2f2b ad44 .........!../+.D
|
---|
40 | 0x0020: 8018 ffff ff73 0000 0101 080a 349b de79 .....s......4..y
|
---|
41 | 0x0030: 349b de79 0100 0001 0437 0000 0203 6465 4..y.....7....de
|
---|
42 | 0x0040: 6607 7465 7374 5f74 310b 7175 6572 6965 f.test_t1.querie
|
---|
43 | 0x0050: 735f 7461 670b 7175 6572 6965 735f 7461 s_tag.queries_ta
|
---|
44 | 0x0060: 6702 6964 0269 640c 3f00 0b00 0000 0303 g.id.id.?.......
|
---|
45 | 0x0070: 4200 0000 3b00 0003 0364 6566 0774 6573 B...;....def.tes
|
---|
46 | 0x0080: 745f 7431 0b71 7565 7269 6573 5f74 6167 t_t1.queries_tag
|
---|
47 | 0x0090: 0b71 7565 7269 6573 5f74 6167 046e 616d .queries_tag.nam
|
---|
48 | 0x00a0: 6504 6e61 6d65 0c21 001e 0000 00fd 0110 e.name.!........
|
---|
49 | 0x00b0: 0000 0045 0000 0403 6465 6607 7465 7374 ...E....def.test
|
---|
50 | 0x00c0: 5f74 310b 7175 6572 6965 735f 7461 670b _t1.queries_tag.
|
---|
51 | 0x00d0: 7175 6572 6965 735f 7461 6709 7061 7265 queries_tag.pare
|
---|
52 | 0x00e0: 6e74 5f69 6409 7061 7265 6e74 5f69 640c nt_id.parent_id.
|
---|
53 | 0x00f0: 3f00 0b00 0000 0308 4000 0000 4900 0005 ?.......@...I...
|
---|
54 | 0x0100: 0364 6566 0774 6573 745f 7431 0b71 7565 .def.test_t1.que
|
---|
55 | 0x0110: 7269 6573 5f74 6167 0b71 7565 7269 6573 ries_tag.queries
|
---|
56 | 0x0120: 5f74 6167 0b63 6174 6567 6f72 795f 6964 _tag.category_id
|
---|
57 | 0x0130: 0b63 6174 6567 6f72 795f 6964 0c3f 000b .category_id.?..
|
---|
58 | 0x0140: 0000 0003 0840 0000 0005 0000 06fe 0000 .....@..........
|
---|
59 | 0x0150: 2100 0800 0007 0131 0274 31fb 0134 0800 !......1.t1..4..
|
---|
60 | 0x0160: 0008 0133 0274 3301 31fb 0800 0009 0134 ...3.t3.1......4
|
---|
61 | 0x0170: 0274 3401 33fb 0500 000a fe00 0021 00 .t4.3........!.
|
---|
62 | 12:07:37.827936 IP (tos 0x8, ttl 64, id 2259, offset 0, flags [DF], proto TCP (6), length 52, bad cksum 0 (->33e7)!)
|
---|
63 | 127.0.0.1.54268 > 127.0.0.1.3306: Flags [.], cksum 0xfe28 (incorrect -> 0xdc1d), seq 78393, ack 80692, win 65535, options [nop,nop,TS val 882630265 ecr 882630265], length 0
|
---|
64 | 0x0000: 4508 0034 08d3 4000 4006 0000 7f00 0001 E..4..@.@.......
|
---|
65 | 0x0010: 7f00 0001 d3fc 0cea 2f2b ad44 0921 affb ......../+.D.!..
|
---|
66 | 0x0020: 8010 ffff fe28 0000 0101 080a 349b de79 .....(......4..y
|
---|
67 | 0x0030: 349b de79 4..y
|
---|
68 | 12:08:12.890997 IP (tos 0x8, ttl 64, id 33211, offset 0, flags [DF], proto TCP (6), length 57, bad cksum 0 (->baf9)!)
|
---|
69 | 127.0.0.1.54268 > 127.0.0.1.3306: Flags [P.], cksum 0xfe2d (incorrect -> 0xcbb2), seq 78393:78398, ack 80692, win 65535, options [nop,nop,TS val 882630615 ecr 882630265], length 5
|
---|
70 | 0x0000: 4508 0039 81bb 4000 4006 0000 7f00 0001 E..9..@.@.......
|
---|
71 | 0x0010: 7f00 0001 d3fc 0cea 2f2b ad44 0921 affb ......../+.D.!..
|
---|
72 | 0x0020: 8018 ffff fe2d 0000 0101 080a 349b dfd7 .....-......4...
|
---|
73 | 0x0030: 349b de79 0100 0000 0e 4..y.....
|
---|
74 | 12:08:12.891040 IP (tos 0x8, ttl 64, id 52446, offset 0, flags [DF], proto TCP (6), length 52, bad cksum 0 (->6fdb)!)
|
---|
75 | 127.0.0.1.3306 > 127.0.0.1.54268: Flags [.], cksum 0xfe28 (incorrect -> 0xd95c), seq 80692, ack 78398, win 65535, options [nop,nop,TS val 882630615 ecr 882630615], length 0
|
---|
76 | 0x0000: 4508 0034 ccde 4000 4006 0000 7f00 0001 E..4..@.@.......
|
---|
77 | 0x0010: 7f00 0001 0cea d3fc 0921 affb 2f2b ad49 .........!../+.I
|
---|
78 | 0x0020: 8010 ffff fe28 0000 0101 080a 349b dfd7 .....(......4...
|
---|
79 | 0x0030: 349b dfd7 4...
|
---|
80 | 12:08:12.891127 IP (tos 0x8, ttl 64, id 57335, offset 0, flags [DF], proto TCP (6), length 63, bad cksum 0 (->5cb7)!)
|
---|
81 | 127.0.0.1.3306 > 127.0.0.1.54268: Flags [P.], cksum 0xfe33 (incorrect -> 0xd247), seq 80692:80703, ack 78398, win 65535, options [nop,nop,TS val 882630615 ecr 882630615], length 11
|
---|
82 | 0x0000: 4508 003f dff7 4000 4006 0000 7f00 0001 E..?..@.@.......
|
---|
83 | 0x0010: 7f00 0001 0cea d3fc 0921 affb 2f2b ad49 .........!../+.I
|
---|
84 | 0x0020: 8018 ffff fe33 0000 0101 080a 349b dfd7 .....3......4...
|
---|
85 | 0x0030: 349b dfd7 0700 0001 0000 0001 0000 00 4..............
|
---|
86 | 12:08:12.891140 IP (tos 0x8, ttl 64, id 6891, offset 0, flags [DF], proto TCP (6), length 52, bad cksum 0 (->21cf)!)
|
---|
87 | 127.0.0.1.54268 > 127.0.0.1.3306: Flags [.], cksum 0xfe28 (incorrect -> 0xd951), seq 78398, ack 80703, win 65535, options [nop,nop,TS val 882630615 ecr 882630615], length 0
|
---|
88 | 0x0000: 4508 0034 1aeb 4000 4006 0000 7f00 0001 E..4..@.@.......
|
---|
89 | 0x0010: 7f00 0001 d3fc 0cea 2f2b ad49 0921 b006 ......../+.I.!..
|
---|
90 | 0x0020: 8010 ffff fe28 0000 0101 080a 349b dfd7 .....(......4...
|
---|
91 | 0x0030: 349b dfd7 4...
|
---|
92 | 12:08:12.891255 IP (tos 0x8, ttl 64, id 26510, offset 0, flags [DF], proto TCP (6), length 419, bad cksum 0 (->d3bc)!)
|
---|
93 | 127.0.0.1.54268 > 127.0.0.1.3306: Flags [P.], cksum 0xff97 (incorrect -> 0xb5d5), seq 78398:78765, ack 80703, win 65535, options [nop,nop,TS val 882630615 ecr 882630615], length 367
|
---|
94 | 0x0000: 4508 01a3 678e 4000 4006 0000 7f00 0001 E...g.@.@.......
|
---|
95 | 0x0010: 7f00 0001 d3fc 0cea 2f2b ad49 0921 b006 ......../+.I.!..
|
---|
96 | 0x0020: 8018 ffff ff97 0000 0101 080a 349b dfd7 ............4...
|
---|
97 | 0x0030: 349b dfd7 6b01 0000 0353 454c 4543 5420 4...k....SELECT.
|
---|
98 | 0x0040: 6071 7565 7269 6573 5f74 6167 602e 6069 `queries_tag`.`i
|
---|
99 | 0x0050: 6460 2c20 6071 7565 7269 6573 5f74 6167 d`,.`queries_tag
|
---|
100 | 0x0060: 602e 606e 616d 6560 2c20 6071 7565 7269 `.`name`,.`queri
|
---|
101 | 0x0070: 6573 5f74 6167 602e 6070 6172 656e 745f es_tag`.`parent_
|
---|
102 | 0x0080: 6964 602c 2060 7175 6572 6965 735f 7461 id`,.`queries_ta
|
---|
103 | 0x0090: 6760 2e60 6361 7465 676f 7279 5f69 6460 g`.`category_id`
|
---|
104 | 0x00a0: 2046 524f 4d20 6071 7565 7269 6573 5f74 .FROM.`queries_t
|
---|
105 | 0x00b0: 6167 6020 5748 4552 4520 4e4f 5420 2828 ag`.WHERE.NOT.((
|
---|
106 | 0x00c0: 6071 7565 7269 6573 5f74 6167 602e 6069 `queries_tag`.`i
|
---|
107 | 0x00d0: 6460 2049 4e20 2853 454c 4543 5420 5530 d`.IN.(SELECT.U0
|
---|
108 | 0x00e0: 2e60 6964 6020 4652 4f4d 2060 7175 6572 .`id`.FROM.`quer
|
---|
109 | 0x00f0: 6965 735f 7461 6760 2055 3020 4c45 4654 ies_tag`.U0.LEFT
|
---|
110 | 0x0100: 204f 5554 4552 204a 4f49 4e20 6071 7565 .OUTER.JOIN.`que
|
---|
111 | 0x0110: 7269 6573 5f74 6167 6020 5531 204f 4e20 ries_tag`.U1.ON.
|
---|
112 | 0x0120: 2855 302e 6069 6460 203d 2055 312e 6070 (U0.`id`.=.U1.`p
|
---|
113 | 0x0130: 6172 656e 745f 6964 6029 2057 4845 5245 arent_id`).WHERE
|
---|
114 | 0x0140: 2055 312e 6069 6460 2049 5320 4e55 4c4c .U1.`id`.IS.NULL
|
---|
115 | 0x0150: 2920 414e 4420 4e4f 5420 2860 7175 6572 ).AND.NOT.(`quer
|
---|
116 | 0x0160: 6965 735f 7461 6760 2e60 6964 6020 4953 ies_tag`.`id`.IS
|
---|
117 | 0x0170: 204e 554c 4c29 2929 204f 5244 4552 2042 .NULL))).ORDER.B
|
---|
118 | 0x0180: 5920 6071 7565 7269 6573 5f74 6167 602e Y.`queries_tag`.
|
---|
119 | 0x0190: 606e 616d 6560 2041 5343 204c 494d 4954 `name`.ASC.LIMIT
|
---|
120 | 0x01a0: 2032 31 .21
|
---|
121 | 12:08:12.891268 IP (tos 0x8, ttl 64, id 44738, offset 0, flags [DF], proto TCP (6), length 52, bad cksum 0 (->8df7)!)
|
---|
122 | 127.0.0.1.3306 > 127.0.0.1.54268: Flags [.], cksum 0xfe28 (incorrect -> 0xd7e2), seq 80703, ack 78765, win 65535, options [nop,nop,TS val 882630615 ecr 882630615], length 0
|
---|
123 | 0x0000: 4508 0034 aec2 4000 4006 0000 7f00 0001 E..4..@.@.......
|
---|
124 | 0x0010: 7f00 0001 0cea d3fc 0921 b006 2f2b aeb8 .........!../+..
|
---|
125 | 0x0020: 8010 ffff fe28 0000 0101 080a 349b dfd7 .....(......4...
|
---|
126 | 0x0030: 349b dfd7 4...
|
---|
127 | 12:08:12.891708 IP (tos 0x8, ttl 64, id 17348, offset 0, flags [DF], proto TCP (6), length 371, bad cksum 0 (->f7b6)!)
|
---|
128 | 127.0.0.1.3306 > 127.0.0.1.54268: Flags [P.], cksum 0xff67 (incorrect -> 0xa002), seq 80703:81022, ack 78765, win 65535, options [nop,nop,TS val 882630615 ecr 882630615], length 319
|
---|
129 | 0x0000: 4508 0173 43c4 4000 4006 0000 7f00 0001 E..sC.@.@.......
|
---|
130 | 0x0010: 7f00 0001 0cea d3fc 0921 b006 2f2b aeb8 .........!../+..
|
---|
131 | 0x0020: 8018 ffff ff67 0000 0101 080a 349b dfd7 .....g......4...
|
---|
132 | 0x0030: 349b dfd7 0100 0001 0437 0000 0203 6465 4........7....de
|
---|
133 | 0x0040: 6607 7465 7374 5f74 310b 7175 6572 6965 f.test_t1.querie
|
---|
134 | 0x0050: 735f 7461 670b 7175 6572 6965 735f 7461 s_tag.queries_ta
|
---|
135 | 0x0060: 6702 6964 0269 640c 3f00 0b00 0000 0303 g.id.id.?.......
|
---|
136 | 0x0070: 4200 0000 3b00 0003 0364 6566 0774 6573 B...;....def.tes
|
---|
137 | 0x0080: 745f 7431 0b71 7565 7269 6573 5f74 6167 t_t1.queries_tag
|
---|
138 | 0x0090: 0b71 7565 7269 6573 5f74 6167 046e 616d .queries_tag.nam
|
---|
139 | 0x00a0: 6504 6e61 6d65 0c21 001e 0000 00fd 0110 e.name.!........
|
---|
140 | 0x00b0: 0000 0045 0000 0403 6465 6607 7465 7374 ...E....def.test
|
---|
141 | 0x00c0: 5f74 310b 7175 6572 6965 735f 7461 670b _t1.queries_tag.
|
---|
142 | 0x00d0: 7175 6572 6965 735f 7461 6709 7061 7265 queries_tag.pare
|
---|
143 | 0x00e0: 6e74 5f69 6409 7061 7265 6e74 5f69 640c nt_id.parent_id.
|
---|
144 | 0x00f0: 3f00 0b00 0000 0308 4000 0000 4900 0005 ?.......@...I...
|
---|
145 | 0x0100: 0364 6566 0774 6573 745f 7431 0b71 7565 .def.test_t1.que
|
---|
146 | 0x0110: 7269 6573 5f74 6167 0b71 7565 7269 6573 ries_tag.queries
|
---|
147 | 0x0120: 5f74 6167 0b63 6174 6567 6f72 795f 6964 _tag.category_id
|
---|
148 | 0x0130: 0b63 6174 6567 6f72 795f 6964 0c3f 000b .category_id.?..
|
---|
149 | 0x0140: 0000 0003 0840 0000 0005 0000 06fe 0000 .....@..........
|
---|
150 | 0x0150: 2100 0800 0007 0131 0274 31fb 0134 0800 !......1.t1..4..
|
---|
151 | 0x0160: 0008 0133 0274 3301 31fb 0500 0009 fe00 ...3.t3.1.......
|
---|
152 | 0x0170: 0021 00 .!.
|
---|
153 | 12:08:12.891723 IP (tos 0x8, ttl 64, id 45268, offset 0, flags [DF], proto TCP (6), length 52, bad cksum 0 (->8be5)!)
|
---|
154 | 127.0.0.1.54268 > 127.0.0.1.3306: Flags [.], cksum 0xfe28 (incorrect -> 0xd6a3), seq 78765, ack 81022, win 65535, options [nop,nop,TS val 882630615 ecr 882630615], length 0
|
---|
155 | 0x0000: 4508 0034 b0d4 4000 4006 0000 7f00 0001 E..4..@.@.......
|
---|
156 | 0x0010: 7f00 0001 d3fc 0cea 2f2b aeb8 0921 b145 ......../+...!.E
|
---|
157 | 0x0020: 8010 ffff fe28 0000 0101 080a 349b dfd7 .....(......4...
|
---|
158 | 0x0030: 349b dfd7 4...
|
---|