3v4l.org

run code in 300+ PHP versions simultaneously
<?php class NamedInClause { public $data; public $clause; public function __construct(array $array, $name = 'in') { $placeholders = array(); $i = 0; $name = preg_replace('/[^a-z0-9_]+/', '', (string)$name); if (!preg_match('/^[a-z]/i', $name)) { throw new \InvalidArgumentException('Placeholder name ' . $name . ': must begin with a letter'); } foreach ($array as $value) { $key = $name . $i++; $placeholders[] = ':' . $key; $this->data[$key] = $value; } $this->string = implode(', ', $placeholders); } } $inClause = new NamedInClause([1, 2, 3], 'id'); // Build the query string $query = " UPDATE table SET value1 = :val1, value2 = :val2 WHERE id IN (" . $inClause->clause . ") "; // Create the data array. Get an array of concrete values and merge the IN clause data $data = array('val1' => 'Hello', 'val2' => 'World') + $inClause->data; var_dump($query, $data); /* $stmt = $db->prepare($query); $stmt->execute($data); */

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

VersionSystem time (s)User time (s)Memory (MiB)
8.3.60.0070.00718.80
8.3.50.0120.00521.37
8.3.40.0040.01419.04
8.3.30.0110.00419.21
8.3.20.0040.00420.34
8.3.10.0080.00023.66
8.3.00.0080.00019.50
8.2.180.0060.01316.75
8.2.170.0100.01022.96
8.2.160.0140.00720.34
8.2.150.0040.00424.18
8.2.140.0030.00524.66
8.2.130.0100.00026.16
8.2.120.0110.00422.18
8.2.110.0030.00620.29
8.2.100.0000.01218.03
8.2.90.0030.00519.25
8.2.80.0030.00517.97
8.2.70.0000.00817.88
8.2.60.0060.00617.93
8.2.50.0030.00618.07
8.2.40.0050.00320.05
8.2.30.0050.00218.16
8.2.20.0040.00417.87
8.2.10.0030.00518.03
8.2.00.0040.00417.90
8.1.280.0140.00325.92
8.1.270.0040.00422.19
8.1.260.0040.00426.35
8.1.250.0040.00428.09
8.1.240.0110.00023.91
8.1.230.0030.00923.86
8.1.220.0060.00317.80
8.1.210.0040.00418.77
8.1.200.0060.00317.60
8.1.190.0060.00317.47
8.1.180.0030.00618.10
8.1.170.0030.00518.84
8.1.160.0020.00522.08
8.1.150.0040.00419.06
8.1.140.0040.00417.61
8.1.130.0000.00717.92
8.1.120.0050.00217.54
8.1.110.0030.00517.62
8.1.100.0000.00717.54
8.1.90.0070.00017.63
8.1.80.0030.00617.64
8.1.70.0000.00817.52
8.1.60.0030.00517.81
8.1.50.0000.00817.75
8.1.40.0030.00617.71
8.1.30.0030.00517.69
8.1.20.0030.00617.85
8.1.10.0030.00617.64
8.1.00.0030.00517.58
8.0.300.0070.00018.77
8.0.290.0000.00717.00
8.0.280.0020.00518.44
8.0.270.0040.00317.34
8.0.260.0030.00317.31
8.0.250.0000.00717.17
8.0.240.0070.00017.24
8.0.230.0000.00817.08
8.0.220.0030.00317.00
8.0.210.0030.00517.14
8.0.200.0020.00517.09
8.0.190.0050.00217.21
8.0.180.0000.00817.20
8.0.170.0080.00017.16
8.0.160.0030.00517.20
8.0.150.0000.00716.98
8.0.140.0020.00517.09
8.0.130.0070.00313.57
8.0.120.0040.00417.13
8.0.110.0000.00917.12
8.0.100.0000.00717.12
8.0.90.0070.00016.96
8.0.80.0070.01017.09
8.0.70.0050.00317.25
8.0.60.0020.00517.22
8.0.50.0040.00416.96
8.0.30.0120.00917.50
8.0.20.0110.01317.43
8.0.10.0000.00817.13
8.0.00.0070.01017.10
7.4.330.0000.00515.02
7.4.320.0090.00016.68
7.4.300.0060.00016.85
7.4.290.0000.00716.85
7.4.280.0000.01016.59
7.4.270.0000.00716.89
7.4.260.0000.00716.73
7.4.250.0030.00516.62
7.4.240.0040.00416.81
7.4.230.0030.00316.67
7.4.220.0080.01316.86
7.4.210.0070.00716.75
7.4.200.0000.00816.85
7.4.160.0100.00716.73
7.4.150.0160.00917.40
7.4.140.0100.01017.86
7.4.130.0090.00916.73
7.4.120.0060.01116.75
7.4.110.0030.01316.71
7.4.100.0090.01317.02
7.4.90.0110.00616.62
7.4.80.0060.01219.39
7.4.70.0040.01716.73
7.4.60.0090.00917.02
7.4.50.0000.00916.59
7.4.40.0130.01016.77
7.4.30.0090.00916.73
7.4.10.0000.01915.37
7.4.00.0020.01714.93
7.3.330.0030.00313.50
7.3.320.0030.00313.57
7.3.310.0030.00416.57
7.3.300.0000.00716.57
7.3.290.0110.00716.52
7.3.280.0080.00916.57
7.3.270.0110.00717.40
7.3.260.0140.00416.60
7.3.250.0110.00616.49
7.3.240.0070.01016.89
7.3.230.0100.01616.68
7.3.210.0100.00716.58
7.3.200.0100.01019.39
7.3.190.0120.01216.80
7.3.180.0080.00816.62
7.3.170.0060.01116.81
7.3.160.0040.01316.50
7.3.130.0120.00314.70
7.3.120.0160.00315.06
7.3.110.0140.00715.32
7.3.100.0100.00615.14
7.3.90.0090.00015.12
7.3.80.0110.00415.15
7.3.70.0130.00315.18
7.3.60.0100.00314.90
7.3.50.0150.00015.03
7.3.40.0070.01015.11
7.3.30.0000.01614.88
7.3.20.0030.00916.84
7.3.10.0030.01516.75
7.3.00.0030.01117.06
7.2.330.0100.01316.79
7.2.320.0100.00616.89
7.2.310.0170.00716.90
7.2.300.0070.01016.86
7.2.290.0150.00317.02
7.2.260.0080.01115.07
7.2.250.0120.00615.44
7.2.240.0070.00715.33
7.2.230.0130.00315.48
7.2.220.0000.01615.12
7.2.210.0070.01015.52
7.2.200.0030.01015.13
7.2.190.0070.01115.23
7.2.180.0030.00715.46
7.2.170.0090.00915.33
7.2.160.0000.01815.05
7.2.150.0030.01317.14
7.2.140.0000.01417.30
7.2.130.0070.01117.04
7.2.120.0060.00917.14
7.2.110.0030.00616.85
7.2.100.0050.00517.18
7.2.90.0070.01017.31
7.2.80.0070.01117.19
7.2.70.0070.01017.07
7.2.60.0100.00616.98
7.2.50.0090.00617.08
7.2.40.0140.00017.00
7.2.30.0070.00717.14
7.2.20.0080.00816.97
7.2.10.0030.00617.14
7.2.00.0070.01116.99
7.1.330.0060.00615.90
7.1.320.0000.01115.68
7.1.310.0150.00016.14
7.1.300.0000.01516.03
7.1.290.0060.00316.18
7.1.280.0060.00916.14
7.1.270.0000.01115.75
7.1.260.0030.00915.97
7.1.250.0040.01115.95
7.1.240.0030.01016.04
7.1.230.0030.00915.94
7.1.220.0040.01116.11
7.1.210.0090.00616.06
7.1.200.0000.01216.10
7.1.190.0030.01015.93
7.1.180.0060.00915.98
7.1.170.0080.00415.96
7.1.160.0040.00415.98
7.1.150.0040.01015.78
7.1.140.0030.01416.07
7.1.130.0030.00916.00
7.1.120.0090.00616.07
7.1.110.0030.00915.94
7.1.100.0070.01016.19
7.1.90.0110.00415.79
7.1.80.0060.00315.98
7.1.70.0040.00416.57
7.1.60.0100.01017.62
7.1.50.0120.00816.48
7.1.40.0030.01016.04
7.1.30.0030.01015.98
7.1.20.0040.00816.01
7.1.10.0060.00916.20
7.1.00.0050.04219.24
7.0.330.0030.00715.40
7.0.320.0070.00715.73
7.0.310.0030.00915.61
7.0.300.0040.00815.75
7.0.290.0000.01315.45
7.0.280.0050.00315.51
7.0.270.0070.00715.50
7.0.260.0000.01115.42
7.0.250.0030.00715.72
7.0.240.0040.00415.57
7.0.230.0030.00715.66
7.0.220.0030.00615.60
7.0.210.0070.00715.50
7.0.200.0020.00716.21
7.0.190.0120.00315.55
7.0.180.0090.00315.48
7.0.170.0060.00615.60
7.0.160.0060.00615.53
7.0.150.0030.01415.77
7.0.140.0100.03518.89
7.0.130.0000.01315.63
7.0.120.0070.00715.36
7.0.110.0070.02217.72
7.0.100.0080.02717.92
7.0.90.0080.03017.74
7.0.80.0060.03317.84
7.0.70.0050.02417.78
7.0.60.0070.04517.75
7.0.50.0080.03817.66
7.0.40.0110.03516.81
7.0.30.0110.04116.69
7.0.20.0060.02316.67
7.0.10.0070.02416.81
7.0.00.0030.03016.64
5.6.400.0080.00814.70
5.6.390.0070.00714.43
5.6.380.0120.00614.73
5.6.370.0070.00714.89
5.6.360.0000.01214.76
5.6.350.0040.00814.66
5.6.340.0090.00614.83
5.6.330.0100.00614.66
5.6.320.0100.00314.61
5.6.310.0070.00714.36
5.6.300.0050.01014.76
5.6.290.0060.01814.75
5.6.280.0080.03817.74
5.6.270.0040.01114.51
5.6.260.0030.04417.79
5.6.250.0080.02317.76
5.6.240.0060.03917.74
5.6.230.0060.02817.58
5.6.220.0060.02917.62
5.6.210.0040.02717.59
5.6.200.0050.02517.70
5.6.190.0050.04717.46
5.6.180.0040.02017.56
5.6.170.0070.01817.57
5.6.160.0050.02017.69
5.6.150.0050.04217.68
5.6.140.0030.03517.48
5.6.130.0010.02517.48
5.6.120.0050.02817.60
5.6.110.0040.02417.76
5.6.100.0050.02417.57
5.6.90.0030.02317.52
5.6.80.0080.02117.29
5.6.70.0110.01617.22
5.6.60.0080.01817.24
5.6.50.0080.04317.07
5.6.40.0070.02517.24
5.6.30.0030.02617.28
5.6.20.0020.04117.31
5.6.10.0100.02717.26
5.6.00.0050.02117.35
5.5.380.0060.02316.02
5.5.370.0100.01716.08
5.5.360.0050.02216.06
5.5.350.0030.04116.06
5.5.340.0070.02316.21
5.5.330.0070.03016.26
5.5.320.0030.02816.28
5.5.310.0030.02416.44
5.5.300.0070.04016.44
5.5.290.0020.02516.34
5.5.280.0030.02316.15
5.5.270.0050.03316.21
5.5.260.0030.02116.21
5.5.250.0000.03316.21
5.5.240.0050.02716.05
5.5.230.0050.02716.01
5.5.220.0030.02815.88
5.5.210.0050.01815.98
5.5.200.0040.03515.80
5.5.190.0050.02516.10
5.5.180.0060.02015.95
5.5.170.0070.00714.44
5.5.160.0050.03215.94
5.5.150.0020.02516.01
5.5.140.0020.02615.83
5.5.130.0060.02615.82
5.5.120.0070.02916.03
5.5.110.0080.03115.93
5.5.100.0090.02715.80
5.5.90.0030.02316.03
5.5.80.0080.02215.93
5.5.70.0050.02015.98
5.5.60.0100.01815.88
5.5.50.0040.02215.90
5.5.40.0050.04215.84
5.5.30.0050.04015.80
5.5.20.0020.03815.96
5.5.10.0070.02615.93
5.5.00.0040.03015.95
5.4.450.0030.02115.32
5.4.440.0050.02015.23
5.4.430.0050.03415.27
5.4.420.0030.02615.22
5.4.410.0060.02315.33
5.4.400.0080.02415.38
5.4.390.0050.03015.03
5.4.380.0050.02215.19
5.4.370.0050.02315.17
5.4.360.0020.03015.21
5.4.350.0050.03015.24
5.4.340.0050.02215.15
5.4.330.0030.00711.31
5.4.320.0080.02715.13
5.4.310.0020.02515.23
5.4.300.0060.01815.19
5.4.290.0030.03715.07
5.4.280.0020.02615.34
5.4.270.0030.02015.19
5.4.260.0020.03815.08
5.4.250.0030.02615.12
5.4.240.0030.02315.10
5.4.230.0020.02214.95
5.4.220.0050.02615.10
5.4.210.0060.02515.27
5.4.200.0080.02215.07
5.4.190.0020.02615.30
5.4.180.0070.02015.31
5.4.170.0050.03115.13
5.4.160.0040.01715.14
5.4.150.0040.02615.06
5.4.140.0060.04013.79
5.4.130.0010.02113.94
5.4.120.0020.02313.74
5.4.110.0000.02913.70
5.4.100.0020.03713.90
5.4.90.0050.02313.75
5.4.80.0070.02613.77
5.4.70.0020.03313.86
5.4.60.0050.01413.92
5.4.50.0020.02713.74
5.4.40.0030.02213.72
5.4.30.0080.03013.71
5.4.20.0050.02213.86
5.4.10.0000.03413.88
5.4.00.0070.01813.38
5.3.290.0070.08014.70
5.3.280.0070.03314.64
5.3.270.0000.04314.74
5.3.260.0070.04014.70
5.3.250.0030.03014.64
5.3.240.0030.04014.75
5.3.230.0000.03714.61
5.3.220.0070.03714.55
5.3.210.0030.03714.59
5.3.200.0070.03014.59
5.3.190.0030.03714.43
5.3.180.0070.05714.67
5.3.170.0070.03014.53
5.3.160.0030.03714.59
5.3.150.0100.02714.69
5.3.140.0000.06314.52
5.3.130.0070.05014.56
5.3.120.0030.03314.64
5.3.110.0070.03314.51
5.3.100.0070.03314.13
5.3.90.0030.05014.04
5.3.80.0100.02314.11
5.3.70.0030.04714.15
5.3.60.0170.02314.02
5.3.50.0030.03013.94
5.3.40.0070.03014.09
5.3.30.0000.03014.14
5.3.20.0100.05713.70
5.3.10.0070.05013.80
5.3.00.0030.03313.72
5.2.170.0030.03011.95
5.2.160.0000.02711.95
5.2.150.0070.03711.95
5.2.140.0000.02711.95
5.2.130.0030.02711.95
5.2.120.0100.02011.95
5.2.110.0000.02711.95
5.2.100.0030.02311.95
5.2.90.0070.02011.95
5.2.80.0030.03711.95
5.2.70.0000.04011.95
5.2.60.0070.02311.95
5.2.50.0030.03011.95
5.2.40.0030.02711.95
5.2.30.0000.03011.95
5.2.20.0000.03011.95
5.2.10.0070.02711.95
5.2.00.0030.03311.95
5.1.60.0100.01711.95
5.1.50.0000.05011.95
5.1.40.0100.04011.95
5.1.30.0030.02011.95
5.1.20.0000.04711.95
5.1.10.0030.03011.95
5.1.00.0000.02311.95
5.0.50.0000.02011.95
5.0.40.0000.01711.95
5.0.30.0030.03011.95
5.0.20.0030.01711.95
5.0.10.0000.01711.95
5.0.00.0030.02711.95
4.4.90.0000.01711.95
4.4.80.0000.02311.95
4.4.70.0030.01311.95
4.4.60.0030.01311.95
4.4.50.0030.01011.95
4.4.40.0000.02311.95
4.4.30.0070.02311.95
4.4.20.0000.01711.95
4.4.10.0000.01311.95
4.4.00.0030.02311.95
4.3.110.0000.01311.95
4.3.100.0030.01311.95
4.3.90.0030.01311.95
4.3.80.0070.02011.95
4.3.70.0000.01711.95
4.3.60.0000.01311.95
4.3.50.0000.01711.95
4.3.40.0000.02011.95
4.3.30.0000.01711.95
4.3.20.0000.01711.95
4.3.10.0030.01011.95
4.3.00.0000.01311.95

preferences:
47.42 ms | 401 KiB | 5 Q