I want to look at the MySQL query built by Views. In views 2 it just shows while I can't seem to find it in the View 3 UI. Is it still available?

1 Answer 1


You can choose to display the query; it's a checkbox called "Show the SQL query" on the Views settings page (admin/structure/views/settings).

  • I was looking all over for it and it was right there.
    – Adam S
    Jun 5, 2011 at 22:20
  • 5
    There is also a drush commando do set some variables: drush views-dev Jun 7, 2011 at 11:50
  • @Daniel Nice, I didn't know that one. Jun 7, 2011 at 12:30
  • but I have to search 'drupal 7 views settings have no Show the SQL query'drush views-dev works for me. Dec 26, 2012 at 4:42
  • I see this checkbox in the source code but it has "display:none" in the CSS style. Does this option depend on some other module or setting?
    – Nic
    Feb 18, 2013 at 16:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.