How to display the origin of an SQL query in the rails server console?

Question

In development mode, I would like to be able to see in the console where an SQL query was fired.

What is currently showing up in my console (dumb example query)

User Load (1.7ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 65 LIMIT 1

What I would like to see

application_controller.rb:68
User Load (1.7ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 65 LIMIT 1

Does this answer your question? [How to get the line of code that triggers a query?](https://stackoverflow.com/questions/10911371/how-to-get-the-line-of-code-that-triggers-a-query) — Tachyons, Nov 16 '21 at 01:20

score 1 · Answer 1 · answered Mar 10 '19 at 15:02

1

For future Googlers: The gem active_record_query_trace can also do that and more.

answered Mar 10 '19 at 15:02

BrunoF

score 0 · Accepted Answer · answered Jun 06 '13 at 19:33

0

answered Jun 06 '13 at 19:33

aabes

2 Answers2