128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
|
# File 'lib/rails-footnotes/notes/queries_note.rb', line 128
def execute_with_analyzer(query, name = nil)
query_results = nil
time = Benchmark.realtime { query_results = execute_without_analyzer(query, name) }
if query =~ /^(select|create|update|delete)\b/i
type = $&.downcase.to_sym
explain = nil
if adapter_name == 'MySQL' && type == :select
log_silence do
explain = execute_without_analyzer("EXPLAIN #{query}", name)
end
end
Footnotes::Notes::QueriesNote.sql << Footnotes::Extensions::Sql.new(type, name, time, query, explain)
end
query_results
end
|