test/dummy/log/development.log in query_report-1.0.0 vs test/dummy/log/development.log in query_report-1.0.1

- old
+ new

@@ -30609,5 +30609,900 @@ CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-28 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-28 00:00:00.000000')) Invoice Load (0.5ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-28 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-28 00:00:00.000000')) Rendered text template (0.0ms) Sent data (1.9ms) Completed 200 OK in 3035ms (Views: 1.8ms | ActiveRecord: 0.8ms) +Connecting to database specified by database.yml + + +Started GET "/" for 127.0.0.1 at 2013-08-29 09:55:21 +0600 +Processing by InvoicesController#index as HTML +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (7.4ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (2.1ms) + Invoice Load (0.5ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.3ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (125.2ms) +Completed 200 OK in 450ms (Views: 211.1ms | ActiveRecord: 5.2ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /application.css - 200 OK (8ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /invoices.css - 200 OK (2ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /scaffold.css - 200 OK (1ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /jquery.js - 200 OK (8ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /users.css - 200 OK (5ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /users.js - 200 OK (2ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /invoices.js - 200 OK (2ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /jquery_ujs.js - 200 OK (3ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 09:55:22 +0600 +Served asset /application.js - 200 OK (10ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 09:57:45 +0600 +Processing by InvoicesController#index as HTML +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (2.6ms) + Invoice Load (1.1ms) SELECT "invoices".* FROM "invoices"  + Invoice Load (1.1ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Invoice Load (0.5ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (1289.3ms) +Completed 500 Internal Server Error in 1315ms + +ActionView::Template::Error (undefined local variable or method `path' for #<#<Class:0x007ff134736978>:0x007ff1348e1fe8>): + 1: <%= render :partial => "query_report/search", locals: {report: @report} %> + 2: <br/> + 3: + 4: <%= link_to_download_report_pdf %> + 5: <%= link_to_download_report_csv %> + 6: + 7: <% if @report.has_chart? and @report.enable_chart? and @report.chart_on_web? %> + app/controllers/invoices_controller.rb:10:in `index' + + + Rendered /usr/local/rvm/gems/ruby-1.9.3-p429/gems/actionpack-3.2.13/lib/action_dispatch/middleware/templates/rescues/_trace.erb (2.9ms) + Rendered /usr/local/rvm/gems/ruby-1.9.3-p429/gems/actionpack-3.2.13/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (2.4ms) + Rendered /usr/local/rvm/gems/ruby-1.9.3-p429/gems/actionpack-3.2.13/lib/action_dispatch/middleware/templates/rescues/template_error.erb within rescues/layout (17.7ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 09:58:01 +0600 +Processing by InvoicesController#index as HTML +  (0.3ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (2.3ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (1.3ms) + Invoice Load (0.5ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (39.3ms) +Completed 200 OK in 68ms (Views: 45.4ms | ActiveRecord: 2.0ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /invoices.css - 200 OK (0ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /application.css - 200 OK (0ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /users.css - 200 OK (0ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /jquery_ujs.js - 200 OK (0ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /scaffold.css - 200 OK (2ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /jquery.js - 200 OK (0ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /invoices.js - 200 OK (0ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /users.js - 200 OK (0ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:02 +0600 +Served asset /application.js - 200 OK (1ms) + + +Started GET "/?format=" for 127.0.0.1 at 2013-08-29 09:58:05 +0600 +Processing by InvoicesController#index as +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +Completed 406 Not Acceptable in 18ms (ActiveRecord: 0.6ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Processing by InvoicesController#index as HTML +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (2.6ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (1.3ms) + Invoice Load (0.4ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.3ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (67.8ms) +Completed 200 OK in 100ms (Views: 77.3ms | ActiveRecord: 2.2ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /application.css - 304 Not Modified (9ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /jquery.js - 304 Not Modified (3ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /jquery_ujs.js - 304 Not Modified (0ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /users.css - 304 Not Modified (0ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /invoices.css - 304 Not Modified (0ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /scaffold.css - 304 Not Modified (0ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /invoices.js - 304 Not Modified (0ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /users.js - 304 Not Modified (0ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:30 +0600 +Served asset /application.js - 304 Not Modified (1ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 09:58:52 +0600 +Processing by InvoicesController#index as HTML +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (2.6ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (1.3ms) + Invoice Load (0.4ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.4ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (69.0ms) +Completed 200 OK in 143ms (Views: 118.8ms | ActiveRecord: 2.2ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /application.css - 304 Not Modified (20ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /scaffold.css - 304 Not Modified (0ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /jquery.js - 304 Not Modified (9ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /users.css - 304 Not Modified (0ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /invoices.css - 304 Not Modified (0ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /jquery_ujs.js - 304 Not Modified (0ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /invoices.js - 304 Not Modified (0ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /users.js - 304 Not Modified (0ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 09:58:53 +0600 +Served asset /application.js - 304 Not Modified (2ms) + + +Started GET "/?format=pdf" for 127.0.0.1 at 2013-08-29 09:58:56 +0600 +Processing by InvoicesController#index as PDF +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Invoice Load (1.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered text template (0.0ms) +Sent data (11.9ms) +Completed 200 OK in 7578ms (Views: 11.7ms | ActiveRecord: 1.8ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Processing by InvoicesController#index as HTML +  (0.3ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (2.4ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (1.2ms) + Invoice Load (0.4ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.3ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (105.9ms) +Completed 200 OK in 134ms (Views: 115.2ms | ActiveRecord: 1.4ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /application.css - 304 Not Modified (17ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /jquery.js - 304 Not Modified (2ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /users.css - 304 Not Modified (0ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /invoices.css - 304 Not Modified (0ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /scaffold.css - 304 Not Modified (0ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /jquery_ujs.js - 304 Not Modified (3ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /invoices.js - 304 Not Modified (0ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /users.js - 304 Not Modified (0ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 09:59:22 +0600 +Served asset /application.js - 304 Not Modified (1ms) + + +Started GET "/?format=pdf" for 127.0.0.1 at 2013-08-29 09:59:25 +0600 +Processing by InvoicesController#index as PDF +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Invoice Load (1.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered text template (0.0ms) +Sent data (1.1ms) +Completed 200 OK in 7146ms (Views: 0.9ms | ActiveRecord: 1.8ms) +Connecting to database specified by database.yml + + +Started GET "/" for 127.0.0.1 at 2013-08-29 10:02:18 +0600 +Processing by InvoicesController#index as HTML +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (7.3ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (2.1ms) + Invoice Load (0.5ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.3ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (124.3ms) +Completed 200 OK in 415ms (Views: 195.7ms | ActiveRecord: 36.6ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 10:02:18 +0600 +Served asset /application.css - 200 OK (21ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 10:02:19 +0600 +Served asset /jquery_ujs.js - 200 OK (3ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 10:02:19 +0600 +Served asset /scaffold.css - 200 OK (2ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 10:02:19 +0600 +Served asset /jquery.js - 200 OK (7ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 10:02:19 +0600 +Served asset /users.css - 200 OK (3ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 10:02:19 +0600 +Served asset /invoices.css - 200 OK (7ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 10:02:19 +0600 +Served asset /invoices.js - 200 OK (3ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 10:02:19 +0600 +Served asset /users.js - 200 OK (2ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 10:02:19 +0600 +Served asset /application.js - 200 OK (10ms) + + +Started GET "/?format=pdf" for 127.0.0.1 at 2013-08-29 10:02:22 +0600 +Processing by InvoicesController#index as PDF +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Invoice Load (1.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered text template (0.0ms) +Sent data (4.5ms) +Completed 200 OK in 7910ms (Views: 4.3ms | ActiveRecord: 1.9ms) +Connecting to database specified by database.yml +Connecting to database specified by database.yml + + +Started GET "/" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Processing by InvoicesController#index as HTML +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (7.2ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (2.1ms) + Invoice Load (0.5ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.4ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (126.4ms) +Completed 200 OK in 382ms (Views: 193.4ms | ActiveRecord: 5.3ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /application.css - 304 Not Modified (14ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /scaffold.css - 304 Not Modified (2ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /invoices.css - 304 Not Modified (2ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /users.css - 304 Not Modified (3ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /jquery_ujs.js - 304 Not Modified (2ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /jquery.js - 304 Not Modified (5ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /invoices.js - 304 Not Modified (2ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /users.js - 304 Not Modified (2ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 10:03:45 +0600 +Served asset /application.js - 304 Not Modified (8ms) + + +Started GET "/?format=pdf" for 127.0.0.1 at 2013-08-29 10:03:49 +0600 +Processing by InvoicesController#index as PDF +  (1.3ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Invoice Load (1.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered text template (0.0ms) +Sent data (4.2ms) +Completed 200 OK in 7760ms (Views: 4.0ms | ActiveRecord: 2.8ms) +Connecting to database specified by database.yml + + +Started GET "/" for 127.0.0.1 at 2013-08-29 10:26:42 +0600 +Processing by InvoicesController#index as HTML +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (3.8ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (1.1ms) + Invoice Load (0.3ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (69.8ms) +Completed 200 OK in 216ms (Views: 107.8ms | ActiveRecord: 2.7ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 10:26:42 +0600 +Served asset /invoices.css - 304 Not Modified (3ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 10:26:42 +0600 +Served asset /users.js - 304 Not Modified (6ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 10:26:42 +0600 +Served asset /scaffold.css - 304 Not Modified (2ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 10:26:42 +0600 +Served asset /users.css - 304 Not Modified (2ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Processing by InvoicesController#index as HTML +  (0.4ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (2.6ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (1.2ms) + Invoice Load (0.5ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.3ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (53.9ms) +Completed 200 OK in 86ms (Views: 64.0ms | ActiveRecord: 1.4ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /application.css - 200 OK (24ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /users.css - 200 OK (0ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /scaffold.css - 200 OK (0ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /invoices.css - 200 OK (0ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /jquery.js - 200 OK (4ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /jquery_ujs.js - 200 OK (1ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /invoices.js - 200 OK (1ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /users.js - 200 OK (0ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 10:26:49 +0600 +Served asset /application.js - 200 OK (5ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Processing by InvoicesController#index as HTML +  (0.3ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.3ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (2.6ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (1.2ms) + Invoice Load (0.5ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.3ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (99.6ms) +Completed 200 OK in 134ms (Views: 108.6ms | ActiveRecord: 2.2ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /application.css - 200 OK (7ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /jquery_ujs.js - 200 OK (0ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /invoices.css - 200 OK (0ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /jquery.js - 200 OK (0ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /scaffold.css - 200 OK (0ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /users.css - 200 OK (0ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /invoices.js - 200 OK (0ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /users.js - 200 OK (0ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 10:27:57 +0600 +Served asset /application.js - 200 OK (1ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 10:34:25 +0600 +Processing by InvoicesController#index as HTML +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (1.0ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.5ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.1ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (40.8ms) +Completed 200 OK in 53ms (Views: 44.4ms | ActiveRecord: 0.5ms) +Connecting to database specified by database.yml + + +Started GET "/" for 127.0.0.1 at 2013-08-29 11:01:58 +0600 +Processing by InvoicesController#index as HTML +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (3.0ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.8ms) + Invoice Load (0.3ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (54.8ms) +Completed 200 OK in 159ms (Views: 68.8ms | ActiveRecord: 2.2ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /application.css - 200 OK (6ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /invoices.css - 200 OK (1ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /jquery.js - 200 OK (5ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /scaffold.css - 200 OK (1ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /jquery_ujs.js - 200 OK (3ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /users.css - 200 OK (1ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /users.js - 200 OK (0ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /invoices.js - 200 OK (0ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 11:01:59 +0600 +Served asset /application.js - 200 OK (5ms) + + +Started GET "/?utf8=%E2%9C%93&q%5Btitle_cont%5D=&q%5Bcreated_at_gteq%5D=2013-03-29&q%5Bcreated_at_lteq%5D=2013-09-29&q%5Bpaid_eq%5D=&commit=Search" for 127.0.0.1 at 2013-08-29 11:02:10 +0600 +Processing by InvoicesController#index as HTML + Parameters: {"utf8"=>"✓", "q"=>{"title_cont"=>"", "created_at_gteq"=>"2013-03-29", "created_at_lteq"=>"2013-09-29", "paid_eq"=>""}, "commit"=>"Search"} +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (1.1ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.5ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.1ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (21.3ms) +Completed 200 OK in 55ms (Views: 25.1ms | ActiveRecord: 0.6ms) + + +Started GET "/?utf8=%E2%9C%93&q%5Btitle_cont%5D=&q%5Bcreated_at_gteq%5D=2013-03-29&q%5Bcreated_at_lteq%5D=2013-09-29&q%5Bpaid_eq%5D=&commit=Search" for 127.0.0.1 at 2013-08-29 11:02:38 +0600 +Processing by InvoicesController#index as HTML + Parameters: {"utf8"=>"✓", "q"=>{"title_cont"=>"", "created_at_gteq"=>"2013-03-29", "created_at_lteq"=>"2013-09-29", "paid_eq"=>""}, "commit"=>"Search"} +  (0.1ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (1.2ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.5ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (48.3ms) +Completed 200 OK in 63ms (Views: 51.9ms | ActiveRecord: 1.0ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 11:04:15 +0600 +Processing by InvoicesController#index as HTML +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (1.0ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.5ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (20.5ms) +Completed 200 OK in 33ms (Views: 24.0ms | ActiveRecord: 0.7ms) +Connecting to database specified by database.yml + + +Started GET "/" for 127.0.0.1 at 2013-08-29 11:04:38 +0600 +Processing by InvoicesController#index as HTML +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (3.0ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.9ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (54.2ms) +Completed 200 OK in 158ms (Views: 68.2ms | ActiveRecord: 2.1ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Processing by InvoicesController#index as HTML +  (0.1ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (1.1ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.5ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (45.4ms) +Completed 200 OK in 58ms (Views: 49.0ms | ActiveRecord: 0.9ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /application.css - 200 OK (8ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /users.css - 200 OK (1ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /jquery.js - 200 OK (4ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /scaffold.css - 200 OK (1ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /invoices.css - 200 OK (1ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /jquery_ujs.js - 200 OK (1ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /invoices.js - 200 OK (1ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /users.js - 200 OK (1ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 11:06:51 +0600 +Served asset /application.js - 200 OK (6ms) + + +Started GET "/?utf8=%E2%9C%93&q%5Btitle_cont%5D=&q%5Bcreated_at_gteq%5D=2013-03-29&q%5Bcreated_at_lteq%5D=2013-09-29&q%5Bpaid_eq%5D=true&commit=Search" for 127.0.0.1 at 2013-08-29 11:06:56 +0600 +Processing by InvoicesController#index as HTML + Parameters: {"utf8"=>"✓", "q"=>{"title_cont"=>"", "created_at_gteq"=>"2013-03-29", "created_at_lteq"=>"2013-09-29", "paid_eq"=>"true"}, "commit"=>"Search"} +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (1.0ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.5ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) LIMIT 25 OFFSET 0 +  (0.1ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (10.8ms) +Completed 200 OK in 46ms (Views: 14.7ms | ActiveRecord: 0.6ms) +Connecting to database specified by database.yml + + +Started GET "/?utf8=%E2%9C%93&q%5Btitle_cont%5D=&q%5Bcreated_at_gteq%5D=2013-03-29&q%5Bcreated_at_lteq%5D=2013-09-29&q%5Bpaid_eq%5D=true&commit=Search" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Processing by InvoicesController#index as HTML + Parameters: {"utf8"=>"✓", "q"=>{"title_cont"=>"", "created_at_gteq"=>"2013-03-29", "created_at_lteq"=>"2013-09-29", "paid_eq"=>"true"}, "commit"=>"Search"} +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (3.1ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.9ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000' AND "invoices"."paid" = 't')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (45.0ms) +Completed 200 OK in 155ms (Views: 59.6ms | ActiveRecord: 2.3ms) + + +Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /application.css - 200 OK (31ms) + + +Started GET "/assets/invoices.css?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /invoices.css - 200 OK (1ms) + + +Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /jquery_ujs.js - 200 OK (2ms) + + +Started GET "/assets/users.css?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /users.css - 200 OK (1ms) + + +Started GET "/assets/scaffold.css?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /scaffold.css - 200 OK (2ms) + + +Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /jquery.js - 200 OK (1ms) + + +Started GET "/assets/invoices.js?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /invoices.js - 200 OK (1ms) + + +Started GET "/assets/users.js?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /users.js - 200 OK (1ms) + + +Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-08-29 11:07:08 +0600 +Served asset /application.js - 200 OK (5ms) + + +Started GET "/" for 127.0.0.1 at 2013-08-29 11:07:59 +0600 +Processing by InvoicesController#index as HTML +  (0.1ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (1.0ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.5ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.2ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (28.0ms) +Completed 200 OK in 41ms (Views: 31.8ms | ActiveRecord: 0.8ms) + + +Started GET "/?utf8=%E2%9C%93&q%5Btitle_cont%5D=&q%5Bcreated_at_gteq%5D=2013-03-29&q%5Bcreated_at_lteq%5D=2013-09-29&q%5Bpaid_eq%5D=&commit=Search" for 127.0.0.1 at 2013-08-29 11:08:04 +0600 +Processing by InvoicesController#index as HTML + Parameters: {"utf8"=>"✓", "q"=>{"title_cont"=>"", "created_at_gteq"=>"2013-03-29", "created_at_lteq"=>"2013-09-29", "paid_eq"=>""}, "commit"=>"Search"} +  (0.2ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) +  (0.1ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_charged") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + CACHE (0.0ms) SELECT SUM("invoices"."total_paid") AS sum_id FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/_search.html.erb (1.1ms) + Rendered /home/jitu/projects/query_report/app/views/query_report/_charts.html.erb (0.5ms) + Invoice Load (0.2ms) SELECT "invoices".* FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) LIMIT 25 OFFSET 0 +  (0.1ms) SELECT COUNT(*) FROM "invoices" WHERE (("invoices"."created_at" >= '2013-03-29 00:00:00.000000' AND "invoices"."created_at" <= '2013-09-29 00:00:00.000000')) + Rendered /home/jitu/projects/query_report/app/views/query_report/list.html.erb within layouts/application (46.6ms) +Completed 200 OK in 61ms (Views: 50.4ms | ActiveRecord: 0.6ms)