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->clause = 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.43
8.3.50.0140.00521.17
8.3.40.0090.00619.21
8.3.30.0060.00919.18
8.3.20.0050.00320.34
8.3.10.0040.00423.48
8.3.00.0060.00319.63
8.2.180.0170.00316.88
8.2.170.0140.00719.18
8.2.160.0110.00422.96
8.2.150.0050.00324.18
8.2.140.0070.00324.66
8.2.130.0100.00026.16
8.2.120.0000.00722.31
8.2.110.0030.00620.52
8.2.100.0070.00418.16
8.2.90.0080.00019.21
8.2.80.0050.00317.97
8.2.70.0030.00517.73
8.2.60.0030.00617.93
8.2.50.0030.00518.07
8.2.40.0050.00319.88
8.2.30.0070.00018.18
8.2.20.0000.00717.97
8.2.10.0040.00418.23
8.2.00.0000.00817.90
8.1.280.0120.00325.92
8.1.270.0090.00023.69
8.1.260.0000.00826.35
8.1.250.0040.00428.09
8.1.240.0090.00023.84
8.1.230.0070.00319.13
8.1.220.0080.00017.79
8.1.210.0040.00418.77
8.1.200.0060.00317.38
8.1.190.0000.00817.48
8.1.180.0000.00718.10
8.1.170.0000.00818.66
8.1.160.0040.00421.97
8.1.150.0070.00018.99
8.1.140.0040.00417.55
8.1.130.0070.00017.88
8.1.120.0050.00217.55
8.1.110.0050.00317.70
8.1.100.0040.00417.63
8.1.90.0040.00417.54
8.1.80.0000.00717.64
8.1.70.0000.00717.59
8.1.60.0090.00017.59
8.1.50.0000.00817.59
8.1.40.0030.00717.58
8.1.30.0050.00317.75
8.1.20.0000.00817.73
8.1.10.0000.00817.78
8.1.00.0020.00517.72
8.0.300.0040.00418.77
8.0.290.0040.00416.88
8.0.280.0040.00418.38
8.0.270.0070.00017.28
8.0.260.0000.00617.22
8.0.250.0040.00417.21
8.0.240.0030.00317.25
8.0.230.0030.00317.19
8.0.220.0070.00017.10
8.0.210.0040.00417.09
8.0.200.0000.00617.21
8.0.190.0000.00717.24
8.0.180.0040.00717.09
8.0.170.0030.00517.07
8.0.160.0080.00017.12
8.0.150.0000.00717.05
8.0.140.0000.00717.02
8.0.130.0040.00313.52
8.0.120.0080.00017.11
8.0.110.0000.00817.10
8.0.100.0080.00017.00
8.0.90.0080.00017.11
8.0.80.0100.00717.18
8.0.70.0030.00517.12
8.0.60.0040.00417.18
8.0.50.0040.00417.16
8.0.30.0030.01617.32
8.0.20.0170.00717.63
8.0.10.0040.00417.29
8.0.00.0080.01017.13
7.4.330.0000.00615.02
7.4.320.0080.00016.73
7.4.300.0000.00716.89
7.4.290.0050.00216.76
7.4.280.0040.00816.73
7.4.270.0000.00816.77
7.4.260.0040.00416.85
7.4.250.0040.00416.86
7.4.240.0010.00616.75
7.4.230.0070.00016.82
7.4.220.0130.00716.88
7.4.210.0040.01016.79
7.4.200.0040.00416.87
7.4.160.0040.01216.73
7.4.150.0090.00917.40
7.4.140.0160.01617.86
7.4.130.0080.00916.75
7.4.120.0090.00816.88
7.4.110.0080.00816.63
7.4.100.0070.01816.93
7.4.90.0040.01316.99
7.4.80.0060.01219.39
7.4.70.0100.00716.79
7.4.60.0110.01216.90
7.4.50.0000.00816.92
7.4.40.0130.00916.80
7.4.30.0060.01216.68
7.4.00.0080.01015.16
7.3.330.0030.00313.48
7.3.320.0030.00313.59
7.3.310.0000.00716.60
7.3.300.0040.00316.60
7.3.290.0070.01116.59
7.3.280.0090.00816.56
7.3.270.0090.00917.40
7.3.260.0190.00316.83
7.3.250.0050.01216.52
7.3.240.0190.00016.92
7.3.230.0160.00616.58
7.3.210.0070.01016.77
7.3.200.0140.00619.39
7.3.190.0120.00416.82
7.3.180.0090.00616.86
7.3.170.0060.01116.86
7.3.160.0080.00816.59
7.3.120.0070.01314.95
7.3.110.0120.00615.13
7.3.100.0060.00914.90
7.3.90.0030.01314.96
7.3.80.0090.00315.30
7.3.70.0060.00614.86
7.3.60.0090.00615.22
7.3.50.0060.00814.95
7.3.40.0000.01014.82
7.3.30.0080.00815.10
7.3.20.0070.01316.61
7.3.10.0070.01016.86
7.3.00.0060.01316.83
7.2.330.0110.00716.99
7.2.320.0110.01116.86
7.2.310.0170.00616.99
7.2.300.0200.00316.88
7.2.290.0060.01216.92
7.2.250.0060.01215.29
7.2.240.0070.01115.52
7.2.230.0060.00915.30
7.2.220.0030.01415.44
7.2.210.0060.00615.16
7.2.200.0060.00915.32
7.2.190.0060.00315.46
7.2.180.0030.01015.41
7.2.170.0000.01314.84
7.1.330.0040.01115.71
7.1.320.0100.00716.17
7.1.310.0030.01016.04
7.1.300.0030.00915.80
7.1.290.0100.00315.90
7.1.280.0140.00015.92
7.1.270.0070.01116.01
7.1.260.0090.00916.06
7.1.200.0000.00716.08
7.1.70.0000.00817.19
7.1.60.0070.01719.11
7.1.50.0070.01717.18
7.1.00.0030.07722.42
7.0.200.0030.00716.66
7.0.140.0030.07022.18
7.0.60.0130.04719.87
7.0.50.0000.09317.92
7.0.40.0100.04320.08
7.0.30.0330.07320.26
7.0.20.0300.08320.14
7.0.10.0100.06320.12
7.0.00.0030.04320.29
5.6.280.0130.06720.99
5.6.210.0100.07720.65
5.6.200.0000.08718.21
5.6.190.0030.08320.58
5.6.180.0270.04020.55
5.6.170.0230.07720.50
5.6.160.0130.07720.76
5.6.150.0070.08018.18
5.6.140.0030.07718.27
5.6.130.0070.04018.21
5.6.120.0030.08720.90
5.6.110.0070.05321.01
5.6.100.0070.08721.11
5.6.90.0070.03721.00
5.6.80.0030.04020.39
5.5.350.0130.03320.45
5.5.340.0100.08017.98
5.5.330.0030.04320.36
5.5.320.0200.04320.25
5.5.310.0370.07320.24
5.5.300.0070.04717.94
5.5.290.0130.05718.08
5.5.280.0070.06720.89
5.5.270.0100.04320.88
5.5.260.0000.04320.96
5.5.250.0030.06720.69
5.5.240.0100.06720.17
5.4.450.0830.06019.62
5.4.440.0400.05719.59
5.4.430.0170.05019.35
5.4.420.0630.00019.43
5.4.410.0730.00019.28
5.4.400.0630.00019.08
5.4.390.0630.00019.16
5.4.380.0670.00019.01
5.4.370.0870.00019.02
5.4.360.0600.00019.11
5.4.350.0900.00019.01
5.4.340.0070.03712.02
5.4.320.0050.04012.50
5.4.310.0070.03812.51
5.4.300.0030.04012.51
5.4.290.0060.04012.50
5.4.280.0050.03612.40
5.4.270.0050.04012.40
5.4.260.0090.03412.40
5.4.250.0100.04112.40
5.4.240.0080.03412.40
5.4.230.0110.03812.39
5.4.220.0060.03812.39
5.4.210.0090.03612.39
5.4.200.0050.03912.39
5.4.190.0070.03912.39
5.4.180.0110.03412.39
5.4.170.0100.03612.41
5.4.160.0030.04012.40
5.4.150.0080.03412.40
5.4.140.0040.04212.08
5.4.130.0060.03612.07
5.4.120.0060.03712.03
5.4.110.0100.04612.02
5.4.100.0050.04812.02
5.4.90.0060.04612.02
5.4.80.0090.03612.02
5.4.70.0070.03612.02
5.4.60.0040.04012.01
5.4.50.0040.04212.01
5.4.40.0060.03812.00
5.4.30.0040.04412.00
5.4.20.0060.03512.00
5.4.10.0030.04012.00
5.4.00.0080.03811.48
5.3.290.0050.04212.80
5.3.280.0070.03912.70
5.3.270.0080.04112.73
5.3.260.0070.04212.72
5.3.250.0060.04512.72
5.3.240.0080.03912.72
5.3.230.0070.03712.71
5.3.220.0070.04712.68
5.3.210.0070.03912.68
5.3.200.0090.03912.68
5.3.190.0070.04112.68
5.3.180.0070.03812.67
5.3.170.0070.04312.67
5.3.160.0060.04112.68
5.3.150.0070.03812.68
5.3.140.0060.04012.66
5.3.130.0040.04212.66
5.3.120.0050.05112.66
5.3.110.0120.04112.66
5.3.100.0070.04012.14
5.3.90.0080.04012.12
5.3.80.0080.03512.11
5.3.70.0020.04212.11
5.3.60.0060.03912.10
5.3.50.0090.04012.04
5.3.40.0050.03812.04
5.3.30.0090.03412.00
5.3.20.0060.03611.78
5.3.10.0070.03411.75
5.3.00.0070.03811.73
5.2.170.0070.0309.22
5.2.160.0020.0319.23
5.2.150.0070.0359.22
5.2.140.0040.0359.22
5.2.130.0040.0339.18
5.2.120.0060.0319.18
5.2.110.0070.0379.19
5.2.100.0060.0319.18
5.2.90.0040.0319.18
5.2.80.0040.0329.17
5.2.70.0060.0359.18
5.2.60.0030.0449.14
5.2.50.0080.0349.11
5.2.40.0050.0309.08
5.2.30.0030.0339.05
5.2.20.0070.0299.05
5.2.10.0110.0338.95
5.2.00.0110.0368.82
5.1.60.0070.0338.09
5.1.50.0040.0338.09
5.1.40.0030.0288.07
5.1.30.0040.0268.42
5.1.20.0070.0278.45
5.1.10.0060.0278.17
5.1.00.0080.0278.18
5.0.50.0040.0236.64
5.0.40.0030.0226.50
5.0.30.0060.0326.32
5.0.20.0040.0286.28
5.0.10.0090.0326.26
5.0.00.0060.0336.25
4.4.90.0040.0154.78
4.4.80.0050.0134.76
4.4.70.0040.0164.75
4.4.60.0030.0154.75
4.4.50.0040.0164.77
4.4.40.0010.0274.70
4.4.30.0030.0164.76
4.4.20.0050.0144.85
4.4.10.0020.0194.85
4.4.00.0030.0334.76
4.3.110.0060.0134.67
4.3.100.0040.0174.67
4.3.90.0040.0184.63
4.3.80.0030.0274.59
4.3.70.0050.0144.63
4.3.60.0050.0154.63
4.3.50.0030.0154.63
4.3.40.0060.0224.54
4.3.30.0040.0153.30
4.3.20.0040.0193.28
4.3.10.0030.0213.24
4.3.00.0100.0137.15

preferences:
64.55 ms | 401 KiB | 5 Q