Duvida sobre log do TSQLMonitor
Salve Galera,
Resolvi testar aquele TSQLMonitor em uma aplicação teste aqui, e achei estranho o resultado dele,
uma unica consulta resultou 258 eventos no log.
Alguém sabe me explicar o que são esses eventos do MySQL e se isso é normal?
Segue log abaixo:
1 - select * from cliente where id_cliente = NULL
2 - MySQL - mysql_real_query
3 - MySQL - mysql_field_count
4 - MySQL - mysql_store_result
5 - MySQL - mysql_fetch_field
6 - MySQL - mysql_fetch_row
7 - MySQL - mysql_free_result
8 - MySQL - mysql_escape_string
9 - MySQL - mysql_escape_string
10 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, CASE WHEN NON_UNIQUE = 0 THEN INDEX_NAME ELSE NULL END, INDEX_NAME='PRIMARY', NON_UNIQUE=0, 1=1 FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) GROUP BY 1, 2, 3 ,4 ORDER BY 1, 2, 3, 4
11 - MySQL - mysql_real_query
12 - MySQL - mysql_field_count
13 - MySQL - mysql_store_result
14 - MySQL - mysql_fetch_field
15 - MySQL - mysql_fetch_row
16 - MySQL - mysql_fetch_lengths
17 - MySQL - mysql_escape_string
18 - MySQL - mysql_escape_string
19 - MySQL - mysql_escape_string
20 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
21 - MySQL - mysql_real_query
22 - MySQL - mysql_field_count
23 - MySQL - mysql_store_result
24 - MySQL - mysql_fetch_field
25 - MySQL - mysql_fetch_row
26 - MySQL - mysql_fetch_lengths
27 - MySQL - mysql_fetch_row
28 - MySQL - mysql_fetch_lengths
29 - MySQL - mysql_fetch_row
30 - MySQL - mysql_fetch_lengths
31 - MySQL - mysql_fetch_row
32 - MySQL - mysql_fetch_lengths
33 - MySQL - mysql_fetch_row
34 - MySQL - mysql_fetch_lengths
35 - MySQL - mysql_fetch_row
36 - MySQL - mysql_free_result
37 - MySQL - mysql_fetch_row
38 - MySQL - mysql_fetch_lengths
39 - MySQL - mysql_escape_string
40 - MySQL - mysql_escape_string
41 - MySQL - mysql_escape_string
42 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
43 - MySQL - mysql_real_query
44 - MySQL - mysql_field_count
45 - MySQL - mysql_store_result
46 - MySQL - mysql_fetch_field
47 - MySQL - mysql_fetch_row
48 - MySQL - mysql_fetch_lengths
49 - MySQL - mysql_fetch_row
50 - MySQL - mysql_fetch_lengths
51 - MySQL - mysql_fetch_row
52 - MySQL - mysql_fetch_lengths
53 - MySQL - mysql_fetch_row
54 - MySQL - mysql_fetch_lengths
55 - MySQL - mysql_fetch_row
56 - MySQL - mysql_fetch_lengths
57 - MySQL - mysql_fetch_row
58 - MySQL - mysql_free_result
59 - MySQL - mysql_fetch_row
60 - MySQL - mysql_fetch_lengths
61 - MySQL - mysql_escape_string
62 - MySQL - mysql_escape_string
63 - MySQL - mysql_escape_string
64 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
65 - MySQL - mysql_real_query
66 - MySQL - mysql_field_count
67 - MySQL - mysql_store_result
68 - MySQL - mysql_fetch_field
69 - MySQL - mysql_fetch_row
70 - MySQL - mysql_fetch_lengths
71 - MySQL - mysql_fetch_row
72 - MySQL - mysql_fetch_lengths
73 - MySQL - mysql_fetch_row
74 - MySQL - mysql_fetch_lengths
75 - MySQL - mysql_fetch_row
76 - MySQL - mysql_fetch_lengths
77 - MySQL - mysql_fetch_row
78 - MySQL - mysql_fetch_lengths
79 - MySQL - mysql_fetch_row
80 - MySQL - mysql_free_result
81 - MySQL - mysql_fetch_row
82 - MySQL - mysql_fetch_lengths
83 - MySQL - mysql_escape_string
84 - MySQL - mysql_escape_string
85 - MySQL - mysql_escape_string
86 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
87 - MySQL - mysql_real_query
88 - MySQL - mysql_field_count
89 - MySQL - mysql_store_result
90 - MySQL - mysql_fetch_field
91 - MySQL - mysql_fetch_row
92 - MySQL - mysql_fetch_lengths
93 - MySQL - mysql_fetch_row
94 - MySQL - mysql_fetch_lengths
95 - MySQL - mysql_fetch_row
96 - MySQL - mysql_fetch_lengths
97 - MySQL - mysql_fetch_row
98 - MySQL - mysql_fetch_lengths
99 - MySQL - mysql_fetch_row
100 - MySQL - mysql_fetch_lengths
101 - MySQL - mysql_fetch_row
102 - MySQL - mysql_free_result
103 - MySQL - mysql_fetch_row
104 - MySQL - mysql_fetch_lengths
105 - MySQL - mysql_escape_string
106 - MySQL - mysql_escape_string
107 - MySQL - mysql_escape_string
108 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
109 - MySQL - mysql_real_query
110 - MySQL - mysql_field_count
111 - MySQL - mysql_store_result
112 - MySQL - mysql_fetch_field
113 - MySQL - mysql_fetch_row
114 - MySQL - mysql_fetch_lengths
115 - MySQL - mysql_fetch_row
116 - MySQL - mysql_fetch_lengths
117 - MySQL - mysql_fetch_row
118 - MySQL - mysql_fetch_lengths
119 - MySQL - mysql_fetch_row
120 - MySQL - mysql_fetch_lengths
121 - MySQL - mysql_fetch_row
122 - MySQL - mysql_fetch_lengths
123 - MySQL - mysql_fetch_row
124 - MySQL - mysql_free_result
125 - MySQL - mysql_fetch_row
126 - MySQL - mysql_free_result
127 - select * from cidade where id_estado = NULL
128 - MySQL - mysql_real_query
129 - MySQL - mysql_field_count
130 - MySQL - mysql_store_result
131 - MySQL - mysql_fetch_field
132 - MySQL - mysql_escape_string
133 - MySQL - mysql_escape_string
134 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, CASE WHEN NON_UNIQUE = 0 THEN INDEX_NAME ELSE NULL END, INDEX_NAME='PRIMARY', NON_UNIQUE=0, 1=1 FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cidade' OR (1=2)) GROUP BY 1, 2, 3 ,4 ORDER BY 1, 2, 3, 4
135 - MySQL - mysql_real_query
136 - MySQL - mysql_field_count
137 - MySQL - mysql_store_result
138 - MySQL - mysql_fetch_field
139 - MySQL - mysql_fetch_row
140 - MySQL - mysql_fetch_lengths
141 - MySQL - mysql_escape_string
142 - MySQL - mysql_escape_string
143 - MySQL - mysql_escape_string
144 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cidade' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
145 - MySQL - mysql_real_query
146 - MySQL - mysql_field_count
147 - MySQL - mysql_store_result
148 - MySQL - mysql_fetch_field
149 - MySQL - mysql_fetch_row
150 - MySQL - mysql_fetch_lengths
151 - MySQL - mysql_fetch_row
152 - MySQL - mysql_fetch_lengths
153 - MySQL - mysql_fetch_row
154 - MySQL - mysql_free_result
155 - MySQL - mysql_fetch_row
156 - MySQL - mysql_fetch_lengths
157 - MySQL - mysql_escape_string
158 - MySQL - mysql_escape_string
159 - MySQL - mysql_escape_string
160 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cidade' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
161 - MySQL - mysql_real_query
162 - MySQL - mysql_field_count
163 - MySQL - mysql_store_result
164 - MySQL - mysql_fetch_field
165 - MySQL - mysql_fetch_row
166 - MySQL - mysql_fetch_lengths
167 - MySQL - mysql_fetch_row
168 - MySQL - mysql_fetch_lengths
169 - MySQL - mysql_fetch_row
170 - MySQL - mysql_free_result
171 - MySQL - mysql_fetch_row
172 - MySQL - mysql_free_result
173 - MySQL - mysql_fetch_row
174 - MySQL - mysql_free_result
175 - select * from estado
176 - MySQL - mysql_real_query
177 - MySQL - mysql_field_count
178 - MySQL - mysql_store_result
179 - MySQL - mysql_fetch_field
180 - MySQL - mysql_escape_string
181 - MySQL - mysql_escape_string
182 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, CASE WHEN NON_UNIQUE = 0 THEN INDEX_NAME ELSE NULL END, INDEX_NAME='PRIMARY', NON_UNIQUE=0, 1=1 FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'estado' OR (1=2)) GROUP BY 1, 2, 3 ,4 ORDER BY 1, 2, 3, 4
183 - MySQL - mysql_real_query
184 - MySQL - mysql_field_count
185 - MySQL - mysql_store_result
186 - MySQL - mysql_fetch_field
187 - MySQL - mysql_fetch_row
188 - MySQL - mysql_fetch_lengths
189 - MySQL - mysql_escape_string
190 - MySQL - mysql_escape_string
191 - MySQL - mysql_escape_string
192 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'estado' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
193 - MySQL - mysql_real_query
194 - MySQL - mysql_field_count
195 - MySQL - mysql_store_result
196 - MySQL - mysql_fetch_field
197 - MySQL - mysql_fetch_row
198 - MySQL - mysql_fetch_lengths
199 - MySQL - mysql_fetch_row
200 - MySQL - mysql_free_result
201 - MySQL - mysql_fetch_row
202 - MySQL - mysql_free_result
203 - MySQL - mysql_fetch_row
204 - MySQL - mysql_fetch_lengths
205 - MySQL - mysql_fetch_row
206 - MySQL - mysql_fetch_lengths
207 - MySQL - mysql_fetch_row
208 - MySQL - mysql_fetch_lengths
209 - MySQL - mysql_fetch_row
210 - MySQL - mysql_fetch_lengths
211 - MySQL - mysql_fetch_row
212 - MySQL - mysql_fetch_lengths
213 - MySQL - mysql_fetch_row
214 - MySQL - mysql_fetch_lengths
215 - MySQL - mysql_fetch_row
216 - MySQL - mysql_fetch_lengths
217 - MySQL - mysql_fetch_row
218 - MySQL - mysql_fetch_lengths
219 - MySQL - mysql_fetch_row
220 - MySQL - mysql_fetch_lengths
221 - MySQL - mysql_fetch_row
222 - MySQL - mysql_fetch_lengths
223 - MySQL - mysql_fetch_row
224 - MySQL - mysql_fetch_lengths
225 - MySQL - mysql_fetch_row
226 - MySQL - mysql_fetch_lengths
227 - MySQL - mysql_fetch_row
228 - MySQL - mysql_fetch_lengths
229 - MySQL - mysql_fetch_row
230 - MySQL - mysql_fetch_lengths
231 - MySQL - mysql_fetch_row
232 - MySQL - mysql_fetch_lengths
233 - MySQL - mysql_fetch_row
234 - MySQL - mysql_fetch_lengths
235 - MySQL - mysql_fetch_row
236 - MySQL - mysql_fetch_lengths
237 - MySQL - mysql_fetch_row
238 - MySQL - mysql_fetch_lengths
239 - MySQL - mysql_fetch_row
240 - MySQL - mysql_fetch_lengths
241 - MySQL - mysql_fetch_row
242 - MySQL - mysql_fetch_lengths
243 - MySQL - mysql_fetch_row
244 - MySQL - mysql_fetch_lengths
245 - MySQL - mysql_fetch_row
246 - MySQL - mysql_fetch_lengths
247 - MySQL - mysql_fetch_row
248 - MySQL - mysql_fetch_lengths
249 - MySQL - mysql_fetch_row
250 - MySQL - mysql_fetch_lengths
251 - MySQL - mysql_fetch_row
252 - MySQL - mysql_fetch_lengths
253 - MySQL - mysql_fetch_row
254 - MySQL - mysql_fetch_lengths
255 - MySQL - mysql_fetch_row
256 - MySQL - mysql_fetch_lengths
257 - MySQL - mysql_fetch_row
258 - MySQL - mysql_free_result
Resolvi testar aquele TSQLMonitor em uma aplicação teste aqui, e achei estranho o resultado dele,
uma unica consulta resultou 258 eventos no log.
Alguém sabe me explicar o que são esses eventos do MySQL e se isso é normal?
Segue log abaixo:
1 - select * from cliente where id_cliente = NULL
2 - MySQL - mysql_real_query
3 - MySQL - mysql_field_count
4 - MySQL - mysql_store_result
5 - MySQL - mysql_fetch_field
6 - MySQL - mysql_fetch_row
7 - MySQL - mysql_free_result
8 - MySQL - mysql_escape_string
9 - MySQL - mysql_escape_string
10 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, CASE WHEN NON_UNIQUE = 0 THEN INDEX_NAME ELSE NULL END, INDEX_NAME='PRIMARY', NON_UNIQUE=0, 1=1 FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) GROUP BY 1, 2, 3 ,4 ORDER BY 1, 2, 3, 4
11 - MySQL - mysql_real_query
12 - MySQL - mysql_field_count
13 - MySQL - mysql_store_result
14 - MySQL - mysql_fetch_field
15 - MySQL - mysql_fetch_row
16 - MySQL - mysql_fetch_lengths
17 - MySQL - mysql_escape_string
18 - MySQL - mysql_escape_string
19 - MySQL - mysql_escape_string
20 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
21 - MySQL - mysql_real_query
22 - MySQL - mysql_field_count
23 - MySQL - mysql_store_result
24 - MySQL - mysql_fetch_field
25 - MySQL - mysql_fetch_row
26 - MySQL - mysql_fetch_lengths
27 - MySQL - mysql_fetch_row
28 - MySQL - mysql_fetch_lengths
29 - MySQL - mysql_fetch_row
30 - MySQL - mysql_fetch_lengths
31 - MySQL - mysql_fetch_row
32 - MySQL - mysql_fetch_lengths
33 - MySQL - mysql_fetch_row
34 - MySQL - mysql_fetch_lengths
35 - MySQL - mysql_fetch_row
36 - MySQL - mysql_free_result
37 - MySQL - mysql_fetch_row
38 - MySQL - mysql_fetch_lengths
39 - MySQL - mysql_escape_string
40 - MySQL - mysql_escape_string
41 - MySQL - mysql_escape_string
42 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
43 - MySQL - mysql_real_query
44 - MySQL - mysql_field_count
45 - MySQL - mysql_store_result
46 - MySQL - mysql_fetch_field
47 - MySQL - mysql_fetch_row
48 - MySQL - mysql_fetch_lengths
49 - MySQL - mysql_fetch_row
50 - MySQL - mysql_fetch_lengths
51 - MySQL - mysql_fetch_row
52 - MySQL - mysql_fetch_lengths
53 - MySQL - mysql_fetch_row
54 - MySQL - mysql_fetch_lengths
55 - MySQL - mysql_fetch_row
56 - MySQL - mysql_fetch_lengths
57 - MySQL - mysql_fetch_row
58 - MySQL - mysql_free_result
59 - MySQL - mysql_fetch_row
60 - MySQL - mysql_fetch_lengths
61 - MySQL - mysql_escape_string
62 - MySQL - mysql_escape_string
63 - MySQL - mysql_escape_string
64 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
65 - MySQL - mysql_real_query
66 - MySQL - mysql_field_count
67 - MySQL - mysql_store_result
68 - MySQL - mysql_fetch_field
69 - MySQL - mysql_fetch_row
70 - MySQL - mysql_fetch_lengths
71 - MySQL - mysql_fetch_row
72 - MySQL - mysql_fetch_lengths
73 - MySQL - mysql_fetch_row
74 - MySQL - mysql_fetch_lengths
75 - MySQL - mysql_fetch_row
76 - MySQL - mysql_fetch_lengths
77 - MySQL - mysql_fetch_row
78 - MySQL - mysql_fetch_lengths
79 - MySQL - mysql_fetch_row
80 - MySQL - mysql_free_result
81 - MySQL - mysql_fetch_row
82 - MySQL - mysql_fetch_lengths
83 - MySQL - mysql_escape_string
84 - MySQL - mysql_escape_string
85 - MySQL - mysql_escape_string
86 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
87 - MySQL - mysql_real_query
88 - MySQL - mysql_field_count
89 - MySQL - mysql_store_result
90 - MySQL - mysql_fetch_field
91 - MySQL - mysql_fetch_row
92 - MySQL - mysql_fetch_lengths
93 - MySQL - mysql_fetch_row
94 - MySQL - mysql_fetch_lengths
95 - MySQL - mysql_fetch_row
96 - MySQL - mysql_fetch_lengths
97 - MySQL - mysql_fetch_row
98 - MySQL - mysql_fetch_lengths
99 - MySQL - mysql_fetch_row
100 - MySQL - mysql_fetch_lengths
101 - MySQL - mysql_fetch_row
102 - MySQL - mysql_free_result
103 - MySQL - mysql_fetch_row
104 - MySQL - mysql_fetch_lengths
105 - MySQL - mysql_escape_string
106 - MySQL - mysql_escape_string
107 - MySQL - mysql_escape_string
108 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cliente' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
109 - MySQL - mysql_real_query
110 - MySQL - mysql_field_count
111 - MySQL - mysql_store_result
112 - MySQL - mysql_fetch_field
113 - MySQL - mysql_fetch_row
114 - MySQL - mysql_fetch_lengths
115 - MySQL - mysql_fetch_row
116 - MySQL - mysql_fetch_lengths
117 - MySQL - mysql_fetch_row
118 - MySQL - mysql_fetch_lengths
119 - MySQL - mysql_fetch_row
120 - MySQL - mysql_fetch_lengths
121 - MySQL - mysql_fetch_row
122 - MySQL - mysql_fetch_lengths
123 - MySQL - mysql_fetch_row
124 - MySQL - mysql_free_result
125 - MySQL - mysql_fetch_row
126 - MySQL - mysql_free_result
127 - select * from cidade where id_estado = NULL
128 - MySQL - mysql_real_query
129 - MySQL - mysql_field_count
130 - MySQL - mysql_store_result
131 - MySQL - mysql_fetch_field
132 - MySQL - mysql_escape_string
133 - MySQL - mysql_escape_string
134 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, CASE WHEN NON_UNIQUE = 0 THEN INDEX_NAME ELSE NULL END, INDEX_NAME='PRIMARY', NON_UNIQUE=0, 1=1 FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cidade' OR (1=2)) GROUP BY 1, 2, 3 ,4 ORDER BY 1, 2, 3, 4
135 - MySQL - mysql_real_query
136 - MySQL - mysql_field_count
137 - MySQL - mysql_store_result
138 - MySQL - mysql_fetch_field
139 - MySQL - mysql_fetch_row
140 - MySQL - mysql_fetch_lengths
141 - MySQL - mysql_escape_string
142 - MySQL - mysql_escape_string
143 - MySQL - mysql_escape_string
144 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cidade' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
145 - MySQL - mysql_real_query
146 - MySQL - mysql_field_count
147 - MySQL - mysql_store_result
148 - MySQL - mysql_fetch_field
149 - MySQL - mysql_fetch_row
150 - MySQL - mysql_fetch_lengths
151 - MySQL - mysql_fetch_row
152 - MySQL - mysql_fetch_lengths
153 - MySQL - mysql_fetch_row
154 - MySQL - mysql_free_result
155 - MySQL - mysql_fetch_row
156 - MySQL - mysql_fetch_lengths
157 - MySQL - mysql_escape_string
158 - MySQL - mysql_escape_string
159 - MySQL - mysql_escape_string
160 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'cidade' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
161 - MySQL - mysql_real_query
162 - MySQL - mysql_field_count
163 - MySQL - mysql_store_result
164 - MySQL - mysql_fetch_field
165 - MySQL - mysql_fetch_row
166 - MySQL - mysql_fetch_lengths
167 - MySQL - mysql_fetch_row
168 - MySQL - mysql_fetch_lengths
169 - MySQL - mysql_fetch_row
170 - MySQL - mysql_free_result
171 - MySQL - mysql_fetch_row
172 - MySQL - mysql_free_result
173 - MySQL - mysql_fetch_row
174 - MySQL - mysql_free_result
175 - select * from estado
176 - MySQL - mysql_real_query
177 - MySQL - mysql_field_count
178 - MySQL - mysql_store_result
179 - MySQL - mysql_fetch_field
180 - MySQL - mysql_escape_string
181 - MySQL - mysql_escape_string
182 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, CASE WHEN NON_UNIQUE = 0 THEN INDEX_NAME ELSE NULL END, INDEX_NAME='PRIMARY', NON_UNIQUE=0, 1=1 FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'estado' OR (1=2)) GROUP BY 1, 2, 3 ,4 ORDER BY 1, 2, 3, 4
183 - MySQL - mysql_real_query
184 - MySQL - mysql_field_count
185 - MySQL - mysql_store_result
186 - MySQL - mysql_fetch_field
187 - MySQL - mysql_fetch_row
188 - MySQL - mysql_fetch_lengths
189 - MySQL - mysql_escape_string
190 - MySQL - mysql_escape_string
191 - MySQL - mysql_escape_string
192 - SELECT TABLE_SCHEMA, CAST(NULL AS CHAR(1)), TABLE_NAME, INDEX_NAME, COLUMN_NAME, SEQ_IN_INDEX, COLLATION='A' FROM INFORMATION_SCHEMA.STATISTICS WHERE (TABLE_SCHEMA = 'bar' OR (1=2)) AND (1=1 OR 1=2) AND (TABLE_NAME = 'estado' OR (1=2)) AND (INDEX_NAME = 'A' OR (1=1)) ORDER BY 1, 2, 3, 4, SEQ_IN_INDEX
193 - MySQL - mysql_real_query
194 - MySQL - mysql_field_count
195 - MySQL - mysql_store_result
196 - MySQL - mysql_fetch_field
197 - MySQL - mysql_fetch_row
198 - MySQL - mysql_fetch_lengths
199 - MySQL - mysql_fetch_row
200 - MySQL - mysql_free_result
201 - MySQL - mysql_fetch_row
202 - MySQL - mysql_free_result
203 - MySQL - mysql_fetch_row
204 - MySQL - mysql_fetch_lengths
205 - MySQL - mysql_fetch_row
206 - MySQL - mysql_fetch_lengths
207 - MySQL - mysql_fetch_row
208 - MySQL - mysql_fetch_lengths
209 - MySQL - mysql_fetch_row
210 - MySQL - mysql_fetch_lengths
211 - MySQL - mysql_fetch_row
212 - MySQL - mysql_fetch_lengths
213 - MySQL - mysql_fetch_row
214 - MySQL - mysql_fetch_lengths
215 - MySQL - mysql_fetch_row
216 - MySQL - mysql_fetch_lengths
217 - MySQL - mysql_fetch_row
218 - MySQL - mysql_fetch_lengths
219 - MySQL - mysql_fetch_row
220 - MySQL - mysql_fetch_lengths
221 - MySQL - mysql_fetch_row
222 - MySQL - mysql_fetch_lengths
223 - MySQL - mysql_fetch_row
224 - MySQL - mysql_fetch_lengths
225 - MySQL - mysql_fetch_row
226 - MySQL - mysql_fetch_lengths
227 - MySQL - mysql_fetch_row
228 - MySQL - mysql_fetch_lengths
229 - MySQL - mysql_fetch_row
230 - MySQL - mysql_fetch_lengths
231 - MySQL - mysql_fetch_row
232 - MySQL - mysql_fetch_lengths
233 - MySQL - mysql_fetch_row
234 - MySQL - mysql_fetch_lengths
235 - MySQL - mysql_fetch_row
236 - MySQL - mysql_fetch_lengths
237 - MySQL - mysql_fetch_row
238 - MySQL - mysql_fetch_lengths
239 - MySQL - mysql_fetch_row
240 - MySQL - mysql_fetch_lengths
241 - MySQL - mysql_fetch_row
242 - MySQL - mysql_fetch_lengths
243 - MySQL - mysql_fetch_row
244 - MySQL - mysql_fetch_lengths
245 - MySQL - mysql_fetch_row
246 - MySQL - mysql_fetch_lengths
247 - MySQL - mysql_fetch_row
248 - MySQL - mysql_fetch_lengths
249 - MySQL - mysql_fetch_row
250 - MySQL - mysql_fetch_lengths
251 - MySQL - mysql_fetch_row
252 - MySQL - mysql_fetch_lengths
253 - MySQL - mysql_fetch_row
254 - MySQL - mysql_fetch_lengths
255 - MySQL - mysql_fetch_row
256 - MySQL - mysql_fetch_lengths
257 - MySQL - mysql_fetch_row
258 - MySQL - mysql_free_result
Janderson Campelo
Curtidas 0
Respostas
Janderson Campelo
04/01/2014
Nada ? Ninguém sabe sobre isso ?
GOSTEI 0
Marco Salles
04/01/2014
Vc esta utilizando o SQLMonitor1.TraceList para gerar o Log ???
Qual a instrução que vc esta utilizando ???
[]sds
Qual a instrução que vc esta utilizando ???
[]sds
GOSTEI 0
Janderson Campelo
04/01/2014
Exatamente!
No evento OnTrace eu mandei ele imprimir o TraceList.
No evento OnTrace eu mandei ele imprimir o TraceList.
GOSTEI 0
Marco Salles
04/01/2014
Exatamente!
No evento OnTrace eu mandei ele imprimir o TraceList.
No evento OnTrace eu mandei ele imprimir o TraceList.
Utilize o traceinfo.message
GOSTEI 0