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; } $clause->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.0040.01118.68
8.3.50.0290.00521.24
8.3.40.0120.00919.21
8.3.30.0140.00019.04
8.3.20.0030.00520.35
8.3.10.0000.00723.66
8.3.00.0040.00419.51
8.2.180.0100.00625.92
8.2.170.0090.00619.26
8.2.160.0170.00322.96
8.2.150.0030.00725.66
8.2.140.0080.00024.66
8.2.130.0090.00026.16
8.2.120.0040.00422.20
8.2.110.0030.00622.23
8.2.100.0070.00718.03
8.2.90.0000.00817.97
8.2.80.0040.00417.97
8.2.70.0040.00418.03
8.2.60.0000.00818.03
8.2.50.0070.00418.10
8.2.40.0050.00320.42
8.2.30.0030.00618.19
8.2.20.0000.00818.06
8.2.10.0030.00618.16
8.2.00.0080.00017.87
8.1.280.0030.01925.92
8.1.270.0090.01222.27
8.1.260.0070.00026.35
8.1.250.0040.00428.09
8.1.240.0030.00622.59
8.1.230.0040.00720.84
8.1.220.0030.00617.90
8.1.210.0080.00018.87
8.1.200.0060.00617.60
8.1.190.0050.00317.60
8.1.180.0050.00318.10
8.1.170.0040.00418.71
8.1.160.0040.00421.99
8.1.150.0000.00719.00
8.1.140.0040.00417.55
8.1.130.0040.00417.82
8.1.120.0000.00717.65
8.1.110.0040.00417.64
8.1.100.0040.00417.57
8.1.90.0000.00717.69
8.1.80.0040.00417.64
8.1.70.0000.00817.61
8.1.60.0030.00517.66
8.1.50.0040.00417.74
8.1.40.0030.00517.71
8.1.30.0030.00517.72
8.1.20.0030.00617.77
8.1.10.0050.00317.72
8.1.00.0060.00317.70
8.0.300.0060.00320.11
8.0.290.0070.00017.00
8.0.280.0000.00718.38
8.0.270.0070.00017.22
8.0.260.0030.00317.31
8.0.250.0030.00317.11
8.0.240.0030.00317.20
8.0.230.0030.00317.16
8.0.220.0030.00517.18
8.0.210.0070.00017.18
8.0.200.0000.00617.20
8.0.190.0040.00417.24
8.0.180.0030.00717.05
8.0.170.0050.00316.99
8.0.160.0040.00417.18
8.0.150.0040.00417.09
8.0.140.0070.00017.07
8.0.130.0040.00413.53
8.0.120.0000.00817.11
8.0.110.0040.00417.14
8.0.100.0000.00817.24
8.0.90.0070.00017.11
8.0.80.0120.00317.07
8.0.70.0050.00216.93
8.0.60.0040.00416.99
8.0.50.0000.00717.12
8.0.30.0130.01017.27
8.0.20.0130.00817.46
8.0.10.0000.00817.21
8.0.00.0110.00717.04
7.4.330.0000.00615.02
7.4.320.0030.00516.89
7.4.300.0000.00816.75
7.4.290.0000.00716.84
7.4.280.0080.00316.60
7.4.270.0000.00716.89
7.4.260.0070.00016.73
7.4.250.0040.00416.84
7.4.240.0060.00216.88
7.4.230.0030.00316.66
7.4.220.0090.01216.95
7.4.210.0110.00316.88
7.4.200.0040.00416.85
7.4.160.0080.00816.63
7.4.150.0110.00717.40
7.4.140.0130.00617.86
7.4.130.0080.01116.70
7.4.120.0080.01216.67
7.4.110.0220.01816.79
7.4.100.0170.00016.63
7.4.90.0060.01216.80
7.4.80.0130.01319.39
7.4.70.0060.01216.67
7.4.60.0090.00916.80
7.4.50.0030.00616.54
7.4.40.0130.00316.78
7.4.30.0070.01016.64
7.4.00.0080.01015.21
7.3.330.0050.00013.68
7.3.320.0040.00413.59
7.3.310.0040.00416.51
7.3.300.0000.00716.43
7.3.290.0080.01116.56
7.3.280.0100.00816.58
7.3.270.0100.01617.40
7.3.260.0140.00316.62
7.3.250.0170.00616.63
7.3.240.0160.00316.91
7.3.230.0160.00916.80
7.3.210.0090.00916.70
7.3.200.0090.01019.39
7.3.190.0140.00716.77
7.3.180.0120.00416.71
7.3.170.0140.00716.95
7.3.160.0040.01816.80
7.3.120.0090.01215.02
7.3.110.0000.01315.08
7.3.100.0000.01414.88
7.3.90.0080.00615.12
7.3.80.0060.00315.20
7.3.70.0140.00315.20
7.3.60.0060.00915.16
7.3.50.0040.00414.72
7.3.40.0070.00715.11
7.3.30.0050.00514.97
7.3.20.0000.01216.74
7.3.10.0030.00616.63
7.3.00.0060.00616.68
7.2.330.0040.01416.87
7.2.320.0040.01316.62
7.2.310.0070.01016.89
7.2.300.0090.01216.94
7.2.290.0190.00316.90
7.2.250.0070.01415.52
7.2.240.0070.00715.29
7.2.230.0070.01014.97
7.2.220.0100.00715.21
7.2.210.0090.00415.11
7.2.200.0070.00715.26
7.2.190.0030.00915.28
7.2.180.0060.00315.48
7.2.170.0000.01015.25
7.1.330.0000.01515.89
7.1.320.0040.01116.02
7.1.310.0030.00715.97
7.1.300.0090.00315.98
7.1.290.0140.00015.71
7.1.280.0060.00915.75
7.1.270.0100.00316.06
7.1.260.0000.00915.79
7.1.200.0030.00615.96
7.1.70.0030.00717.19
7.1.60.0140.01119.11
7.1.50.0100.01317.27
7.1.00.0000.08022.35
7.0.200.0070.00717.12
7.0.140.0070.06722.00
7.0.60.0070.08720.03
7.0.50.0100.03717.93
7.0.40.0000.09320.11
7.0.30.0230.07720.22
7.0.20.0430.07320.23
7.0.10.0230.07720.24
7.0.00.0070.05020.10
5.6.280.0030.07321.11
5.6.210.0030.06720.61
5.6.200.0030.08718.19
5.6.190.0100.07720.39
5.6.180.3270.03720.38
5.6.170.0300.05320.50
5.6.160.0030.04020.50
5.6.150.0070.04718.17
5.6.140.0070.06318.17
5.6.130.0030.08318.14
5.6.120.0100.04020.99
5.6.110.0100.07720.99
5.6.100.0230.06720.89
5.6.90.0130.07320.89
5.6.80.0030.05320.41
5.6.70.4130.03020.34
5.5.350.0270.08020.36
5.5.340.0030.05018.04
5.5.330.0070.07720.43
5.5.320.0170.04020.32
5.5.310.0270.06020.23
5.5.300.0070.05018.08
5.5.290.0130.06717.98
5.5.280.0070.07320.91
5.5.270.0070.08320.96
5.5.260.0000.08320.90
5.5.250.0130.05320.55
5.5.240.0070.08320.29
5.4.450.0070.04319.25
5.4.440.0570.06019.31
5.4.430.0670.06019.52
5.4.420.0730.00019.52
5.4.410.0700.00019.10
5.4.400.0630.00019.23
5.4.390.0800.00019.24
5.4.380.0630.00019.21
5.4.370.0630.00019.01
5.4.360.0630.00019.02
5.4.350.0800.00019.02
5.4.340.0030.03812.02
5.4.320.0060.03612.51
5.4.310.0040.04012.50
5.4.300.0070.04012.51
5.4.290.0100.03712.51
5.4.280.0060.03912.41
5.4.270.0070.03812.41
5.4.260.0080.03612.40
5.4.250.0050.04112.41
5.4.240.0060.03612.40
5.4.230.0120.03812.39
5.4.220.0070.03612.39
5.4.210.0050.03612.39
5.4.200.0040.03912.39
5.4.190.0050.04412.39
5.4.180.0060.04012.39
5.4.170.0050.03912.41
5.4.160.0040.03912.40
5.4.150.0060.03812.39
5.4.140.0080.03512.08
5.4.130.0070.03512.07
5.4.120.0070.03412.03
5.4.110.0040.04312.02
5.4.100.0080.04112.02
5.4.90.0070.03912.02
5.4.80.0070.04412.02
5.4.70.0070.04012.02
5.4.60.0060.03412.01
5.4.50.0050.03512.02
5.4.40.0060.04212.00
5.4.30.0040.03812.00
5.4.20.0040.03612.00
5.4.10.0090.03212.00
5.4.00.0060.03811.48
5.3.290.0080.04712.80
5.3.280.0050.04412.71
5.3.270.0020.04712.72
5.3.260.0040.04212.72
5.3.250.0080.04312.72
5.3.240.0060.03912.72
5.3.230.0070.03812.71
5.3.220.0040.04012.68
5.3.210.0080.05312.68
5.3.200.0100.04312.68
5.3.190.0080.03612.68
5.3.180.0070.04112.68
5.3.170.0060.04012.67
5.3.160.0050.04112.67
5.3.150.0030.04012.68
5.3.140.0040.03812.66
5.3.130.0070.03812.66
5.3.120.0040.03912.66
5.3.110.0070.03812.66
5.3.100.0050.03812.14
5.3.90.0050.04012.12
5.3.80.0050.03712.11
5.3.70.0070.03712.11
5.3.60.0090.03812.10
5.3.50.0110.03512.04
5.3.40.0070.03812.04
5.3.30.0060.03712.00
5.3.20.0040.04211.78
5.3.10.0080.03811.75
5.3.00.0090.03711.73
5.2.170.0050.0309.22
5.2.160.0050.0329.22
5.2.150.0070.0289.22
5.2.140.0040.0329.22
5.2.130.0060.0299.18
5.2.120.0040.0369.18
5.2.110.0050.0329.19
5.2.100.0010.0329.18
5.2.90.0020.0319.18
5.2.80.0050.0339.18
5.2.70.0030.0349.18
5.2.60.0030.0329.14
5.2.50.0040.0309.11
5.2.40.0040.0349.08
5.2.30.0080.0289.05
5.2.20.0040.0359.04
5.2.10.0060.0288.95
5.2.00.0020.0338.82
5.1.60.0050.0248.10
5.1.50.0040.0268.09
5.1.40.0030.0288.07
5.1.30.0060.0258.42
5.1.20.0050.0288.45
5.1.10.0060.0278.17
5.1.00.0040.0268.17
5.0.50.0050.0236.64
5.0.40.0010.0236.50
5.0.30.0010.0346.32
5.0.20.0030.0206.28
5.0.10.0020.0296.26
5.0.00.0030.0326.25
4.4.90.0030.0164.78
4.4.80.0030.0154.76
4.4.70.0050.0134.75
4.4.60.0030.0184.75
4.4.50.0060.0194.77
4.4.40.0020.0274.71
4.4.30.0030.0164.76
4.4.20.0050.0134.84
4.4.10.0020.0164.85
4.4.00.0010.0274.76
4.3.110.0050.0134.67
4.3.100.0020.0184.67
4.3.90.0030.0164.64
4.3.80.0030.0244.59
4.3.70.0030.0184.63
4.3.60.0040.0144.63
4.3.50.0030.0194.63
4.3.40.0030.0264.54
4.3.30.0030.0173.30
4.3.20.0020.0173.28
4.3.10.0010.0183.24
4.3.00.0200.01712.27

preferences:
46.12 ms | 401 KiB | 5 Q