Debug Drupal EntityFieldQuery and Views Queries

debug_drupal_queries

/**
 * Implements hook_query_alter
 */
function modulename_query_alter($query) {
  if ($query->hasTag('debug') && module_exists('devel')) {
    dpm(strtr((string) $query, $query->getArguments()));
  }
}

/* When using an EntityFieldQuery */
$query = new EntityFieldQuery();
$query->entityCondition('entity_type', 'node')
  ->entityCondition('bundle', 'serie')
  ->fieldCondition('og_group_ref', 'target_id', $country->nid)
  ->fieldCondition('og_vocabulary', 'target_id', 'NULL', '!=')
  /* see hook_query_alter */
  ->addTag('debug');

/**
 * Implements of hook_views_query_alter()
 */
function modulename_views_query_alter(&$view, &$query) {
  $query->add_tag('debug');
}