<?php

/**
 * AggregatorTestBase::getDefaultFeedItemCount()
 */
function _mb_set_1() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT COUNT(*) FROM node_field_data n WHERE n.promote = 1 AND n.status = 1", // Monolingual
        "SELECT COUNT(DISTINCT nid) FROM node_field_data n WHERE n.promote = 1 AND n.status = 1", // Multilingual: 25%-30%
        "SELECT COUNT(*) FROM node_field_data n WHERE n.promote = 1 AND n.status = 1 AND default_langcode = 1", // Multilingual: 150%-160%
        "SELECT COUNT(nid) FROM node_field_data n WHERE n.promote = 1 AND n.status = 1 AND default_langcode = 1", // Multilingual: even slower
      ),
    );
  }
}

/**
 * CommentStorageController::updateNodeStatistics()
 */
function _mb_set_3() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT uid, created FROM node_field_data WHERE nid = 1", // Monolingual
        "SELECT uid, created FROM node_field_data WHERE nid = 1 LIMIT 1", // Multilingual (meaningless?): ~0%
        "SELECT uid, created FROM node_field_data WHERE nid = 1 AND default_langcode = 1", // Multilingual: 3%
      ),
    );
  }
}

/**
 * comment.module:comment_get_recent()
 */
function _mb_set_4() {
  if (module_exists("comment")) {
    return array(
      "cases" => array(
        "SELECT c.* FROM comment c INNER JOIN node_field_data n ON n.nid = c.nid WHERE c.status = 1 AND n.status = 1 ORDER BY c.created DESC, c.cid DESC LIMIT 10 OFFSET 0", // Monolingual
        "SELECT c.* FROM comment c INNER JOIN node_field_data n ON n.nid = c.nid WHERE c.status = 1 AND n.status = 1 AND n.default_langcode = 1 ORDER BY c.created DESC, c.cid DESC LIMIT 10 OFFSET 0", // Multilingual: filtered by default language: ~0%
        "SELECT c.* FROM comment c INNER JOIN node_field_data n ON n.nid = c.nid WHERE c.status = 1 AND n.status = 1 AND n.langcode = 'und' ORDER BY c.created DESC, c.cid DESC LIMIT 10 OFFSET 0", // Multilingual: filtered by language: 5%-7%
        "SELECT c.* FROM comment c INNER JOIN node_field_data n ON n.nid = c.nid WHERE c.status = 1 AND n.status = 1 GROUP BY c.cid ORDER BY c.created DESC, c.cid DESC LIMIT 10 OFFSET 0", // Multilingual: grouped by id: 1500%-1600%
      ),
    );
  }
}

/**
 * forum.module:forum_forum_load()
 */
function _mb_set_5() {
  if (module_exists("forum")) {
    return array(
      "cases" => array(
        "SELECT f.tid AS tid, COUNT(n.nid) AS topic_count, SUM(ncs.comment_count) AS comment_count FROM node_field_data n INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN forum f ON n.vid = f.vid WHERE (n.status = 1) GROUP BY tid", // Monolingual
        "SELECT f.tid AS tid, COUNT(n.nid) AS topic_count, SUM(ncs.comment_count) AS comment_count FROM node_field_data n INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN forum f ON n.vid = f.vid WHERE (n.status = 1) AND n.default_langcode = 1 GROUP BY tid", // Multilingual: filtered by default language: 0%-1%
        "SELECT f.tid AS tid, COUNT(n.nid) AS topic_count, SUM(ncs.comment_count) AS comment_count FROM node_field_data n INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN forum f ON n.vid = f.vid WHERE (n.status = 1) AND n.langcode = 'en' GROUP BY tid", // Multilingual: filtered by language: 1%-2%
      ),
    );
  }
}

/**
 * forum.module:forum_forum_load()
 */
function _mb_set_6() {
  if (module_exists("forum")) {
    return array(
      "cases" => array(
        "SELECT ncs.last_comment_timestamp AS last_comment_timestamp, ncs.last_comment_uid AS last_comment_uid, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u.name END AS last_comment_name FROM node_field_data n INNER JOIN forum f ON n.vid = f.vid AND f.tid = 1 INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u ON ncs.last_comment_uid = u.uid WHERE (n.status = 1) ORDER BY last_comment_timestamp DESC LIMIT 1 OFFSET 0", // Monolingual
        "SELECT ncs.last_comment_timestamp AS last_comment_timestamp, ncs.last_comment_uid AS last_comment_uid, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u.name END AS last_comment_name FROM node_field_data n INNER JOIN forum f ON n.vid = f.vid AND f.tid = 1 INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u ON ncs.last_comment_uid = u.uid WHERE (n.status = 1) AND n.default_langcode = 1 ORDER BY last_comment_timestamp DESC LIMIT 1 OFFSET 0", // Multilingual: filtered by default language: ~-4%
        "SELECT ncs.last_comment_timestamp AS last_comment_timestamp, ncs.last_comment_uid AS last_comment_uid, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u.name END AS last_comment_name FROM node_field_data n INNER JOIN forum f ON n.vid = f.vid AND f.tid = 1 INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u ON ncs.last_comment_uid = u.uid WHERE (n.status = 1) AND n.langcode = 'en' ORDER BY last_comment_timestamp DESC LIMIT 1 OFFSET 0", // Multilingual: filtered by language: ~0%
      ),
    );
  }
}

/**
 * forum.module:_forum_topics_unread()
 */
function _mb_set_7() {
  if (module_exists("forum")) {
    return array(
      "cases" => array(
        "SELECT COUNT(n.nid) AS count FROM node_field_data n INNER JOIN forum f ON n.vid = f.vid AND f.tid = 1 LEFT OUTER JOIN history h ON n.nid = h.nid AND h.uid = 1 WHERE (status = 1) AND (n.created > 0) AND (h.nid IS NULL)", // Monolingual
        "SELECT COUNT(DISTINCT n.nid) AS count FROM node_field_data n INNER JOIN forum f ON n.vid = f.vid AND f.tid = 1 LEFT OUTER JOIN history h ON n.nid = h.nid AND h.uid = 1 WHERE (status = 1) AND (n.created > 0) AND (h.nid IS NULL)", // Monolingual language-aware: 3%-5%
        "SELECT COUNT(n.nid) AS count FROM node_field_data n INNER JOIN forum f ON n.vid = f.vid AND f.tid = 1 LEFT OUTER JOIN history h ON n.nid = h.nid AND h.uid = 1 WHERE (status = 1) AND (n.created > 0) AND (n.default_langcode = 1) AND (h.nid IS NULL)", // Multilingual: filtered by default language: ~0%
        "SELECT COUNT(n.nid) AS count FROM node_field_data n INNER JOIN forum f ON n.vid = f.vid AND f.tid = 1 LEFT OUTER JOIN history h ON n.nid = h.nid AND h.uid = 1 WHERE (status = 1) AND (n.created > 0) AND (n.langcode = 'en') AND (h.nid IS NULL)", // Multilingual: filtered by language: ~0%
      ),
    );
  }
}

/**
 * forum.module:_forum_topics_unread()
 */
function _mb_set_8() {
  if (module_exists("forum")) {
    return array(
      "cases" => array(
        "SELECT n.nid AS nid, ncs.cid AS cid, ncs.last_comment_uid AS last_comment_uid, ncs.last_comment_timestamp AS last_comment_timestamp, ncs.comment_count AS comment_count, f.tid AS forum_tid, u.name AS name, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u2.name END AS last_comment_name FROM node_field_data n INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN forum_index f ON f.nid = ncs.nid INNER JOIN users u ON n.uid = u.uid INNER JOIN users u2 ON ncs.last_comment_uid = u2.uid WHERE (n.nid IN (1105, 1107)) ORDER BY f.sticky DESC, f.last_comment_timestamp DESC", // Monolingual
        "SELECT n.nid AS nid, ncs.cid AS cid, ncs.last_comment_uid AS last_comment_uid, ncs.last_comment_timestamp AS last_comment_timestamp, ncs.comment_count AS comment_count, f.tid AS forum_tid, u.name AS name, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u2.name END AS last_comment_name FROM node_field_data n INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN forum_index f ON f.nid = ncs.nid INNER JOIN users u ON n.uid = u.uid INNER JOIN users u2 ON ncs.last_comment_uid = u2.uid WHERE (n.nid IN (1105, 1107)) GROUP BY n.nid ORDER BY f.sticky DESC, f.last_comment_timestamp DESC", // Monolingual language-aware: 10%-15%
        "SELECT n.nid AS nid, ncs.cid AS cid, ncs.last_comment_uid AS last_comment_uid, ncs.last_comment_timestamp AS last_comment_timestamp, ncs.comment_count AS comment_count, f.tid AS forum_tid, u.name AS name, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u2.name END AS last_comment_name FROM node_field_data n INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN forum_index f ON f.nid = ncs.nid INNER JOIN users u ON n.uid = u.uid INNER JOIN users u2 ON ncs.last_comment_uid = u2.uid WHERE (n.nid IN (1105, 1107)) AND n.default_langcode = 1 ORDER BY f.sticky DESC, f.last_comment_timestamp DESC", // Multilingual: filtered by default language: 0%-1%
        "SELECT n.nid AS nid, ncs.cid AS cid, ncs.last_comment_uid AS last_comment_uid, ncs.last_comment_timestamp AS last_comment_timestamp, ncs.comment_count AS comment_count, f.tid AS forum_tid, u.name AS name, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u2.name END AS last_comment_name FROM node_field_data n INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN forum_index f ON f.nid = ncs.nid INNER JOIN users u ON n.uid = u.uid INNER JOIN users u2 ON ncs.last_comment_uid = u2.uid WHERE (n.nid IN (1105, 1107)) AND n.langcode = 'en' ORDER BY f.sticky DESC, f.last_comment_timestamp DESC", // Multilingual: filtered by language: 1%-2%
      ),
    );
  }
}

/**
 * book.module:book_get_books()
 */
function _mb_set_9() {
  if (module_exists("forum")) {
    return array(
      "cases" => array(
        "SELECT uid, created FROM node_field_data WHERE nid = 1107", // Monolingual
        "SELECT uid, created FROM node_field_data WHERE nid = 1107 LIMIT 1", // Monolingual language-aware: ~-3%
        "SELECT uid, created FROM node_field_data WHERE nid = 1107 AND default_langcode = 1", // Multilingual: filtered by default language: 1%-2%
        "SELECT uid, created FROM node_field_data WHERE nid = 1107 AND langcode = 'en'", // Multilingual: filtered by language: ~2.5%
      ),
    );
  }
}

/**
 * node.module:node_user_predelete()
 */
function _mb_set_10() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT n.nid AS nid FROM node_field_data n WHERE uid = 1", // Monolingual
        "SELECT DISTINCT n.nid AS nid FROM node_field_data n WHERE uid = 1", // Monolingual language-aware: ~-3%
        "SELECT n.nid AS nid FROM node_field_data n WHERE uid = 1 GROUP BY nid", // Monolingual language-aware: 1%-2%
      ),
    );
  }
}

/**
 * node.module:node_user_predelete()
 */
function _mb_set_11() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT vid FROM node_field_revision WHERE uid = 1", // Monolingual
        "SELECT DISTINCT vid FROM node_field_revision WHERE uid = 1", // Monolingual language-aware: 11-13%
        "SELECT vid FROM node_field_revision WHERE uid = 1 GROUP BY nid", // Monolingual language-aware: 4.5%-6%
      ),
    );
  }
}

/**
 * node.module:_node_revision_access()
 */
function _mb_set_12() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT COUNT(*) FROM node_field_revision WHERE nid = 1", // Monolingual
        "SELECT COUNT(vid) FROM node_field_revision WHERE nid = 1", // Monolingual: 0%-2%
        "SELECT COUNT(DISTINCT vid) FROM node_field_revision WHERE nid = 1", // Monolingual language-aware: 11%-16%
        "SELECT COUNT(*) FROM node_field_revision WHERE nid = 1 AND default_langcode = 1", // Multilingual: filtered by default language: 2%-6%
        "SELECT COUNT(vid) FROM node_field_revision WHERE nid = 1 AND default_langcode = 1", // Multilingual: filtered by default language: 2%-6%
      ),
    );
  }
}

/**
 * node.module:node_last_changed()
 */
function _mb_set_13() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT changed FROM node_field_data WHERE nid = 1", // Monolingual
        "SELECT changed FROM node_field_data WHERE nid = 1 ORDER BY changed DESC LIMIT 1", // Multilingual: 7%-9%
        "SELECT changed FROM node_field_data WHERE nid = 1 AND default_langcode = 1", // Multilingual: filtered by default language: ~2%
        "SELECT changed FROM node_field_data WHERE nid = 1 AND langcode = 'en'", // Multilingual: filtered by language: ~2%
      ),
    );
  }
}

/**
 * node.module:node_revision_list()
 */
function _mb_set_14() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT nr.vid, nr.title, nr.log, nr.revision_uid AS uid, n.vid AS current_vid, nr.revision_timestamp, u.name FROM node_field_revision nr LEFT JOIN {node} n ON n.vid = nr.vid INNER JOIN {users} u ON u.uid = nr.revision_uid WHERE nr.nid = 1 ORDER BY nr.vid DESC", // Monolingual
        "SELECT nr.vid, nr.title, nr.log, nr.revision_uid AS uid, n.vid AS current_vid, nr.revision_timestamp, u.name FROM node_field_revision nr LEFT JOIN {node} n ON n.vid = nr.vid INNER JOIN {users} u ON u.uid = nr.revision_uid WHERE nr.nid = 1 AND default_langcode = 1 ORDER BY nr.vid DESC", // Multilingual: filtered by default language:
      ),
    );
  }
}

/**
 * node.module:node_get_recent()
 */
function _mb_set_15() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT n.nid AS nid FROM node_field_data n WHERE (n.promote = 1) AND (n.status = 1) ORDER BY n.created DESC LIMIT 10 OFFSET 0", // Monolingual
        "SELECT DISTINCT n.nid AS nid FROM node_field_data n WHERE (n.promote = 1) AND (n.status = 1) ORDER BY n.created DESC LIMIT 10 OFFSET 0", // Monolingual (language-aware): 15%-16%
        "SELECT n.nid AS nid FROM node_field_data n WHERE (n.promote = 1) AND (n.status = 1) GROUP BY n.nid ORDER BY n.created DESC LIMIT 10 OFFSET 0", // Monolingual (language-aware): 15%-16%
        "SELECT n.nid AS nid FROM node_field_data n WHERE (n.promote = 1) AND (n.status = 1) AND n.default_langcode = 1 ORDER BY n.created DESC LIMIT 10 OFFSET 0", // Multilingual: filtered by default language: ~-57%
        "SELECT n.nid AS nid FROM node_field_data n WHERE (n.promote = 1) AND (n.status = 1) AND n.langcode = 'und' ORDER BY n.created DESC LIMIT 10 OFFSET 0", // Multilingual: filtered by language: 6%-9%
      ),
    );
  }
}

/**
 * node.module:node_feed()
 */
function _mb_set_16() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT n.nid AS nid FROM node_field_data n WHERE (n.promote = 1) AND (n.status = 1) ORDER BY n.created DESC LIMIT 10 OFFSET 0", // Monolingual
        "SELECT DISTINCT n.nid AS nid FROM node_field_data n WHERE (n.promote = 1) AND (n.status = 1) ORDER BY n.created DESC LIMIT 10 OFFSET 0", // Monolingual (language-aware): 10%-13%
        "SELECT n.nid AS nid FROM node_field_data n WHERE (n.promote = 1) AND (n.status = 1) GROUP BY n.nid ORDER BY n.created DESC LIMIT 10 OFFSET 0", // Monolingual (language-aware): 10%-13%
      ),
    );
  }
}

/**
 * node.module:node_revision_delete_confirm_submit()
 */
function _mb_set_17() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT COUNT(vid) FROM node_field_revision WHERE nid = 1", // Monolingual
        "SELECT COUNT(DISTINCT vid) FROM node_field_revision WHERE nid = 1", // Monolingual (language-aware): 13%-14%
        "SELECT COUNT(*) FROM node_field_revision WHERE nid = 1 AND default_langcode = 1", // Multilingual: filtered by default language: 1%-2%
      ),
    );
  }
}

/**
 * statistics.module:statistics_title_list()
 */
function _mb_set_18() {
  if (module_exists("statistics")) {
    return array(
      "cases" => array(
        "SELECT n.nid AS nid, n.title AS title, u.uid AS uid, u.name AS name FROM node_field_data n INNER JOIN {node_counter} s ON n.nid = s.nid INNER JOIN {users} u ON n.uid = u.uid WHERE (timestamp <> 0) AND (n.status = 1) ORDER BY timestamp DESC LIMIT 10 OFFSET 0", // Monolingual
        "SELECT n.nid AS nid, n.title AS title, u.uid AS uid, u.name AS name FROM node_field_data n INNER JOIN {node_counter} s ON n.nid = s.nid INNER JOIN {users} u ON n.uid = u.uid WHERE (timestamp <> 0) AND (n.status = 1) GROUP BY n.nid ORDER BY timestamp DESC LIMIT 10 OFFSET 0", // Monolingual (language-aware): ~10%
        "SELECT n.nid AS nid, n.title AS title, u.uid AS uid, u.name AS name FROM node_field_data n INNER JOIN {node_counter} s ON n.nid = s.nid INNER JOIN {users} u ON n.uid = u.uid WHERE (timestamp <> 0) AND (n.status = 1) AND (n.default_langcode = 1) ORDER BY timestamp DESC LIMIT 10 OFFSET 0", // Multilingual: filtered by default language: 1%-2%
      ),
    );
  }
}

/**
 * tracker.module:tracker_cron()
 */
function _mb_set_19() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT nid, uid, status FROM node_field_data WHERE nid <= 1000 ORDER BY nid DESC", // Monolingual
        "SELECT nid, uid, status FROM node_field_data WHERE nid <= 1000 GROUP BY nid ORDER BY nid DESC", // Monolingual (language-aware): ~4%
        "SELECT nid, uid, status FROM node_field_data WHERE nid <= 1000 AND default_langcode = 1 ORDER BY nid DESC", // Multilingual: filtered by default language: ~8%
        "SELECT nid, uid, status FROM node_field_data WHERE nid <= 1000 AND langcode = 'und' ORDER BY nid DESC", // Multilingual: filtered by default language: ~10%
      ),
    );
  }
}

/**
 * tracker.module:_tracker_add()
 */
function _mb_set_20() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT nid, status, uid, changed FROM node_field_data WHERE nid = 1 ORDER BY changed DESC, status DESC", // Monolingual
        "SELECT nid, status, uid, changed FROM node_field_data WHERE nid = 1 ORDER BY changed DESC, status DESC LIMIT 1", // Monolingual (language-aware): ~-0.5%
        "SELECT nid, status, uid, changed FROM node_field_data WHERE nid = 1 AND default_langcode = 1 ORDER BY changed DESC, status DESC", // Multilingual: filtered by default language: ~2%
        "SELECT nid, status, uid, changed FROM node_field_data WHERE nid = 1 AND langcode = 'und' ORDER BY nid DESC", // Multilingual: filtered by default language: ~-3%
      ),
    );
  }
}

/**
 * tracker.module:_tracker_calculate_changed()
 */
function _mb_set_21() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT changed FROM node_field_data WHERE nid = 1", // Monolingual
        "SELECT changed FROM node_field_data WHERE nid = 1 ORDER BY changed DESC LIMIT 1", // Monolingual (language-aware): ~7%
        "SELECT changed FROM node_field_data WHERE nid = 1 AND default_langcode = 1", // Multilingual: filtered by default language: ~2%
        "SELECT changed FROM node_field_data WHERE nid = 1 AND langcode = 'und'", // Multilingual: filtered by default language: ~4.5%
      ),
    );
  }
}

/**
 * tracker.module:tracker_page()
 */
function _mb_set_22() {
  if (module_exists("node")) {
    return array(
      "cases" => array(
        "SELECT n.nid, l.comment_count FROM node_field_data n INNER JOIN node_comment_statistics l ON n.nid = l.nid WHERE n.nid IN (1,2,3) ORDER BY n.changed DESC", // Monolingual
        "SELECT DISTINCT n.nid, l.comment_count FROM node_field_data n INNER JOIN node_comment_statistics l ON n.nid = l.nid WHERE n.nid IN (1,2,3) ORDER BY n.changed DESC", // Monolingual (language-aware): ~2%
        "SELECT n.nid, l.comment_count FROM node_field_data n INNER JOIN node_comment_statistics l ON n.nid = l.nid WHERE n.nid IN (1,2,3) AND n.default_langcode = 1 ORDER BY n.changed DESC", // Multilingual: filtered by default language: ~1%
        "SELECT n.nid, l.comment_count FROM node_field_data n INNER JOIN node_comment_statistics l ON n.nid = l.nid WHERE n.nid IN (1,2,3) AND n.langcode = 'und' ORDER BY n.changed DESC", // Multilingual: filtered by default language: ~3%
      ),
    );
  }
}

/**
 * Kind of front page
 */
function _mb_set_23() {
  if (module_exists("node")) {
    $table = db_table_exists("node_field_data") ? "node_field_data" : "node";
    return array(
      "cases" => array(
        "SELECT title FROM {" . $table . "} WHERE status = 1 AND promote = 1 ORDER BY created", // Monolingual
      ),
    );
  }
}