SQL query surveillance

  • Mads Phikamphon

    (@madsphi)


    10 years, 3 months ago

    Hi,

    I need to check how WP/Woocommerce queries the database, so we can make an administrative tool for our shop.

    So is there a way to view/log how WP/Woocommerce queries the database?

    For example a debugging plugin or a “secret” WP setting.

    Thanks,
    Mads

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    10 years, 3 months ago

    Try the ‘query’ filter. This is part of the global $wpdb object which all WP developers are expected to use. If Woo does not use it and makes it’s own mySQL calls, this filter will not capture it.

    I believe all the various query methods provided by the wpdb class eventually go through this filter, but I can;t be absolutely sure. You’ll probably want to just write each query string to a log file for later analysis.

Viewing 1 replies (of 1 total)
  • The topic ‘SQL query surveillance’ is closed to new replies.