reverted:
--- b/core/modules/comment/src/Plugin/views/field/NodeNewComments.php
+++ a/core/modules/comment/src/Plugin/views/field/NodeNewComments.php
@@ -155,17 +155,9 @@
     }
 
     if ($nids) {
+      $result = $this->database->query("SELECT n.nid, COUNT(c.cid) as num_comments FROM {node} n INNER JOIN {comment_field_data} c ON n.nid = c.entity_id AND c.entity_type = 'node' AND c.default_langcode = 1
+        LEFT JOIN {history} h ON h.nid = n.nid AND h.uid = :h_uid WHERE n.nid IN ( :nids[] )
+        AND c.changed > GREATEST(COALESCE(h.timestamp, :timestamp1), :timestamp2) AND c.status = :status GROUP BY n.nid", [
-      $sql = <<<SQL
-      SELECT n.nid, COUNT(c.cid) as num_comments
-      FROM {node} n
-        INNER JOIN {comment_field_data} c ON n.nid = c.entity_id AND c.entity_type = 'node' AND c.default_langcode = 1
-        LEFT JOIN {history} h ON h.nid = n.nid AND h.uid = :h_uid
-      WHERE n.nid IN ( :nids[] )
-        AND c.changed > GREATEST(COALESCE(h.timestamp, :timestamp1), :timestamp2) AND c.status = :status
-      GROUP BY n.nid
-      SQL;
-
-      $result = $this->database->query($sql, [
         ':status' => CommentInterface::PUBLISHED,
         ':h_uid' => $user->id(),
         ':nids[]' => $nids,
diff -u b/core/modules/views_ui/tests/src/Functional/SettingsTest.php b/core/modules/views_ui/tests/src/Functional/SettingsTest.php
--- b/core/modules/views_ui/tests/src/Functional/SettingsTest.php
+++ b/core/modules/views_ui/tests/src/Functional/SettingsTest.php
@@ -169,7 +169,7 @@
   /**
    * Tests the "performance" setting bug in the Edit UI reported as #2404039.
    */
-  function testEditUI2404039() {
+  public function testEditUI2404039() {
     $this->drupalLogin($this->adminUser);
   }