102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
# File 'lib/rails-footnotes/notes/queries_note.rb', line 102
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
|