From 9d5fe1eb2dfd6d8fc62508d8d0c1932e181ad95c Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Thu, 22 Aug 2013 11:42:05 -0700 Subject: [PATCH] Avoid profiler spam for numeric IN() clauses for each possible number of items * This currently can be seen in several category queries with IN() clauses on graphite Change-Id: I04e7745c7d4f11f5f2905c7f86f1558a9fdb0b5c --- includes/db/Database.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/includes/db/Database.php b/includes/db/Database.php index 0b2cc986b7..0082103d8a 100644 --- a/includes/db/Database.php +++ b/includes/db/Database.php @@ -1605,7 +1605,8 @@ abstract class DatabaseBase implements IDatabase, DatabaseType { $sql = preg_replace( '/\s+/', ' ', $sql ); # All numbers => N - $sql = preg_replace( '/-?[0-9]+/s', 'N', $sql ); + $sql = preg_replace( '/-?\d+(,-?\d+)+/s', 'N,...,N', $sql ); + $sql = preg_replace( '/-?\d+/s', 'N', $sql ); return $sql; } -- 2.20.1