9

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?

14

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 '11 at 22:20
  • 5
    There is also a drush commando do set some variables: drush views-dev – Daniel Wehner Jun 7 '11 at 11:50
  • @Daniel Nice, I didn't know that one. – marcvangend Jun 7 '11 at 12:30
  • but I have to search 'drupal 7 views settings have no Show the SQL query'drush views-dev works for me. – bluesky_still Dec 26 '12 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 '13 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.