3v4l.org

run code in 300+ PHP versions simultaneously
<?php function pdo_named_in_clause_from_array($array, $name = 'in') { $in = $data = 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++; $in[] = ':' . $key; $data[$key] = $value; } return array(implode(', ', $in), $data); } $inList = [1, 2, 3]; list($inClause, $inData) = pdo_named_in_clause_from_array($inList, 'id'); $query = " UPDATE table SET value1 = :val1, value2 = :val2 WHERE id IN (" . $inClause . ") "; $data = array('val1' => 'Hello', 'val2' => 'World') + $inData; 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.0110.00418.43
8.3.50.0180.00521.34
8.3.40.0070.00719.21
8.3.30.0070.00719.27
8.3.20.0040.00420.13
8.3.10.0040.00423.61
8.3.00.0030.00519.63
8.2.180.0110.00716.48
8.2.170.0070.00722.96
8.2.160.0150.00320.20
8.2.150.0000.00824.18
8.2.140.0000.00824.66
8.2.130.0050.00326.16
8.2.120.0000.00820.02
8.2.110.0000.00820.30
8.2.100.0120.00018.28
8.2.90.0060.00319.17
8.2.80.0030.00617.97
8.2.70.0050.00318.00
8.2.60.0100.00017.93
8.2.50.0050.00318.07
8.2.40.0080.00019.94
8.2.30.0040.00418.09
8.2.20.0040.00417.86
8.2.10.0050.00218.24
8.2.00.0030.00617.99
8.1.280.0070.01425.92
8.1.270.0060.00322.22
8.1.260.0050.00326.35
8.1.250.0050.00228.09
8.1.240.0090.00023.72
8.1.230.0040.00819.16
8.1.220.0030.00517.78
8.1.210.0030.00518.77
8.1.200.0000.00917.38
8.1.190.0060.00317.60
8.1.180.0000.00818.10
8.1.170.0080.00018.77
8.1.160.0000.00722.05
8.1.150.0000.00818.81
8.1.140.0050.00217.57
8.1.130.0070.00019.60
8.1.120.0000.00717.63
8.1.110.0040.00417.62
8.1.100.0000.00717.56
8.1.90.0050.00217.52
8.1.80.0000.00817.52
8.1.70.0020.00517.64
8.1.60.0000.00917.67
8.1.50.0030.00617.60
8.1.40.0000.00817.71
8.1.30.0000.00817.70
8.1.20.0080.00017.86
8.1.10.0000.00817.71
8.1.00.0000.00817.73
8.0.300.0000.00718.77
8.0.290.0000.00816.75
8.0.280.0030.00518.50
8.0.270.0000.00717.30
8.0.260.0070.00018.49
8.0.250.0030.00317.20
8.0.240.0000.00717.12
8.0.230.0040.00417.14
8.0.220.0000.00717.16
8.0.210.0040.00417.13
8.0.200.0040.00417.08
8.0.190.0000.00717.21
8.0.180.0000.01017.18
8.0.170.0040.00417.16
8.0.160.0030.00317.24
8.0.150.0000.00717.14
8.0.140.0020.00517.09
8.0.130.0050.00513.44
8.0.120.0040.00417.13
8.0.110.0000.00917.09
8.0.100.0040.00417.02
8.0.90.0040.00417.12
8.0.80.0120.00317.17
8.0.70.0000.00717.20
8.0.60.0000.00717.07
8.0.50.0050.00217.13
8.0.30.0100.01317.26
8.0.20.0090.01517.40
8.0.10.0000.00817.08
8.0.00.0120.00617.14
7.4.330.0000.00515.02
7.4.320.0040.00416.79
7.4.300.0000.00616.72
7.4.290.0030.00316.64
7.4.280.0030.00716.75
7.4.270.0070.00016.85
7.4.260.0040.00416.77
7.4.250.0000.00716.63
7.4.240.0000.00716.84
7.4.230.0020.00516.64
7.4.220.0120.01516.92
7.4.210.0090.00516.85
7.4.200.0000.00716.68
7.4.160.0000.01616.77
7.4.150.0090.00917.40
7.4.140.0050.01617.86
7.4.130.0120.00716.84
7.4.120.0110.00616.75
7.4.110.0030.01416.90
7.4.100.0140.00316.81
7.4.90.0140.00316.80
7.4.80.0170.00619.39
7.4.70.0040.01216.80
7.4.60.0110.01116.68
7.4.50.0030.00616.59
7.4.40.0060.01516.75
7.4.30.0090.01316.60
7.4.00.0060.01015.28
7.3.330.0000.00513.33
7.3.320.0060.00013.50
7.3.310.0000.00816.44
7.3.300.0030.00316.38
7.3.290.0080.01116.55
7.3.280.0130.00616.54
7.3.270.0090.01017.40
7.3.260.0060.01816.89
7.3.250.0060.01116.69
7.3.240.0090.00916.60
7.3.230.0190.01916.59
7.3.210.0100.00616.88
7.3.200.0120.00619.39
7.3.190.0090.00816.88
7.3.180.0150.00016.78
7.3.170.0060.01216.51
7.3.160.0100.00716.59
7.3.120.0110.00715.21
7.3.110.0070.00714.80
7.3.100.0060.00614.92
7.3.90.0040.00815.14
7.3.80.0030.00814.98
7.3.70.0030.00714.84
7.3.60.0040.01114.95
7.3.50.0060.01015.08
7.3.40.0040.01115.01
7.3.30.0030.01215.04
7.3.20.0030.01216.98
7.3.10.0040.00816.68
7.3.00.0070.00616.57
7.2.330.0170.00016.73
7.2.320.0120.00616.72
7.2.310.0090.01217.09
7.2.300.0110.00516.94
7.2.290.0070.01716.88
7.2.250.0090.00915.14
7.2.240.0070.01315.38
7.2.230.0060.00915.34
7.2.220.0060.00615.41
7.2.210.0130.00315.20
7.2.200.0070.00715.15
7.2.190.0090.00615.36
7.2.180.0040.00715.32
7.2.170.0070.01015.20
7.2.130.0020.01217.03
7.2.120.0050.00817.10
7.2.110.0050.01116.97
7.2.100.0070.00716.98
7.2.90.0080.00717.08
7.2.80.0070.00517.05
7.2.70.0050.00817.13
7.2.60.0020.00917.14
7.2.50.0120.00217.13
7.2.40.0080.00817.23
7.2.30.0080.00517.20
7.2.20.0090.00417.13
7.2.10.0130.00617.10
7.2.00.0040.00917.90
7.1.330.0120.00316.14
7.1.320.0060.00616.13
7.1.310.0070.00715.94
7.1.300.0070.00715.86
7.1.290.0030.01316.02
7.1.280.0100.00315.87
7.1.270.0060.00616.02
7.1.260.0090.00316.08
7.1.250.0050.00815.93
7.1.240.0030.01215.68
7.1.230.0090.00315.96
7.1.220.0070.00415.67
7.1.210.0000.01015.96
7.1.200.0050.00616.07
7.1.190.0030.00615.95
7.1.180.0070.01015.57
7.1.170.0070.00715.80
7.1.160.0040.01115.86
7.1.150.0040.00415.82
7.1.140.0070.01015.74
7.1.130.0000.01415.88
7.1.120.0040.01116.05
7.1.110.0090.00616.09
7.1.100.0040.00817.15
7.1.90.0100.00716.10
7.1.80.0150.00315.98
7.1.70.0000.01016.65
7.1.60.0030.01517.56
7.1.50.0100.00616.52
7.1.40.0030.01015.99
7.1.30.0040.01115.89
7.1.20.0070.00715.95
7.1.10.0130.00015.99
7.1.00.0070.04019.27
7.0.330.0090.00615.47
7.0.320.0030.00715.52
7.0.310.0000.01115.31
7.0.300.0090.00315.74
7.0.290.0000.01315.56
7.0.280.0120.00015.46
7.0.270.0070.01015.68
7.0.260.0040.01215.63
7.0.250.0060.00315.50
7.0.240.0040.01115.64
7.0.230.0030.00815.80
7.0.220.0070.01415.65
7.0.210.0030.01315.46
7.0.200.0020.00716.08
7.0.190.0000.01415.55
7.0.180.0060.00315.27
7.0.170.0080.00815.59
7.0.160.0030.01315.38
7.0.150.0000.01715.66
7.0.140.0070.04118.68
7.0.130.0000.01015.63
7.0.120.0030.01015.62
7.0.110.0060.00615.74
7.0.100.0100.00615.58
7.0.90.0060.00915.61
7.0.80.0070.00715.54
7.0.70.0050.00515.37
7.0.60.0090.03917.91
7.0.50.0110.03016.71
7.0.40.0020.05216.89
7.0.30.0130.04316.93
7.0.20.0190.02316.76
7.0.10.0130.04316.85
7.0.00.0050.04216.87
5.6.380.0040.00814.67
5.6.370.0070.00714.70
5.6.360.0040.01114.64
5.6.350.0030.01114.57
5.6.340.0030.00714.36
5.6.330.0030.00614.61
5.6.320.0100.00314.45
5.6.310.0150.00314.93
5.6.300.0090.00014.02
5.6.290.0060.00614.54
5.6.280.0070.04017.73
5.6.270.0040.01114.75
5.6.260.0060.00614.65
5.6.250.0050.00514.81
5.6.240.0070.00714.58
5.6.230.0030.01014.33
5.6.220.0060.00614.73
5.6.210.0050.02517.77
5.6.200.0050.02316.29
5.6.190.0070.02217.41
5.6.180.0220.04117.34
5.6.170.0200.03317.61
5.6.160.0050.02517.53
5.6.150.0100.03516.40
5.6.140.0090.02616.10
5.6.130.0090.04016.21
5.6.120.0030.03117.66
5.6.110.0160.03717.70
5.6.100.0150.04217.58
5.6.90.0060.02417.81
5.6.80.0090.02917.30
5.6.70.1480.02317.35
5.6.60.0070.00714.48
5.6.50.0030.01014.39
5.6.40.0080.00614.11
5.6.30.0040.00914.33
5.6.20.0070.00714.29
5.6.10.0040.00814.20
5.6.00.0060.00614.29
5.5.380.0000.01011.45
5.5.370.0040.00710.97
5.5.360.0000.01011.39
5.5.350.0080.02715.77
5.5.340.0120.03114.61
5.5.330.0090.02815.82
5.5.320.0040.04815.87
5.5.310.0150.04915.74
5.5.300.0070.04014.64
5.5.290.0030.02214.47
5.5.280.0050.02916.08
5.5.270.0020.04816.08
5.5.260.0040.04915.98
5.5.250.0080.04015.90
5.5.240.0060.02915.83
5.5.230.0070.00711.14
5.5.220.0030.01011.08
5.5.210.0060.00611.23
5.5.200.0070.00411.12
5.5.190.0060.00611.30
5.5.180.0050.01011.13
5.5.170.0040.00711.35
5.5.160.0000.00711.00
5.5.150.0080.00411.07
5.5.140.0080.00411.06
5.5.130.0000.00811.41
5.5.120.0040.00411.51
5.5.110.0040.00411.20
5.5.100.0030.00910.96
5.5.90.0000.01511.26
5.5.80.0030.00511.25
5.5.70.0080.00511.01
5.5.60.0030.00710.95
5.5.50.0000.00711.14
5.5.40.0070.00311.21
5.5.30.0040.01210.96
5.5.20.0060.00610.96
5.5.10.0030.00911.29
5.5.00.0000.01211.21
5.4.450.0480.04215.17
5.4.440.0420.03315.41
5.4.430.0440.03215.28
5.4.420.0380.00215.42
5.4.410.0330.00615.20
5.4.400.0340.00315.04
5.4.390.0340.00314.96
5.4.380.0330.00415.08
5.4.370.0360.00215.09
5.4.360.0440.00215.11
5.4.350.0400.00515.03
5.4.340.0050.02211.51
5.4.330.0050.00511.27
5.4.320.0070.02011.83
5.4.310.0050.03711.63
5.4.300.0080.03311.82
5.4.290.0050.02211.79
5.4.280.0030.02211.69
5.4.270.0090.02211.73
5.4.260.0060.02911.79
5.4.250.0070.02811.89
5.4.240.0060.03011.92
5.4.230.0010.02811.81
5.4.220.0040.02011.91
5.4.210.0100.01711.71
5.4.200.0070.02211.88
5.4.190.0050.02211.73
5.4.180.0070.02011.75
5.4.170.0030.02211.78
5.4.160.0050.02611.71
5.4.150.0070.01911.78
5.4.140.0090.01911.47
5.4.130.0060.02211.64
5.4.120.0040.02111.65
5.4.110.0090.01911.80
5.4.100.0090.02211.64
5.4.90.0120.02211.73
5.4.80.0060.02411.71
5.4.70.0060.02411.68
5.4.60.0070.02111.65
5.4.50.0030.02311.59
5.4.40.0060.01811.58
5.4.30.0060.01911.67
5.4.20.0040.02411.57
5.4.10.0080.02111.68
5.4.00.0060.02511.28
5.3.290.0080.02811.51
5.3.280.0070.02011.45
5.3.270.0060.02211.57
5.3.260.0050.02211.54
5.3.250.0040.02311.53
5.3.240.0050.02211.38
5.3.230.0040.02611.45
5.3.220.0140.02611.49
5.3.210.0070.02511.48
5.3.200.0090.02111.48
5.3.190.0080.02911.38
5.3.180.0080.03211.49
5.3.170.0040.02611.55
5.3.160.0090.03511.58
5.3.150.0060.02411.56
5.3.140.0060.02311.41
5.3.130.0080.03111.53
5.3.120.0090.02611.51
5.3.110.0070.02911.48
5.3.100.0090.02311.19
5.3.90.0070.02211.27
5.3.80.0080.02211.18
5.3.70.0070.01811.19
5.3.60.0090.02611.21
5.3.50.0140.02311.12
5.3.40.0080.02611.15
5.3.30.0040.03011.13
5.3.20.0060.02610.91
5.3.10.0050.01910.97
5.3.00.0080.02110.80
5.2.170.0040.0199.25
5.2.160.0080.0149.28
5.2.150.0050.0199.25
5.2.140.0080.0199.24
5.2.130.0040.0199.25
5.2.120.0070.0219.26
5.2.110.0080.0219.23
5.2.100.0020.0259.23
5.2.90.0080.0239.26
5.2.80.0070.0209.22
5.2.70.0060.0239.23
5.2.60.0050.0199.20
5.2.50.0050.0189.19
5.2.40.0040.0179.24
5.2.30.0040.0199.16
5.2.20.0100.0219.16
5.2.10.0070.0209.11
5.2.00.0070.0189.04
5.1.60.0070.0148.68
5.1.50.0060.0178.68
5.1.40.0060.0158.67
5.1.30.0040.0178.85
5.1.20.0040.0188.86
5.1.10.0070.0148.72
5.1.00.0050.0198.72
5.0.50.0040.0127.97
5.0.40.0050.0137.89
5.0.30.0040.0217.80
5.0.20.0040.0107.78
5.0.10.0050.0137.78
5.0.00.0030.0227.77
4.4.90.0050.0097.03
4.4.80.0040.0097.01
4.4.70.0020.0097.01
4.4.60.0030.0107.02
4.4.50.0030.0137.02
4.4.40.0050.0136.99
4.4.30.0060.0107.02
4.4.20.0050.0127.06
4.4.10.0050.0077.06
4.4.00.0020.0197.02
4.3.110.0020.0136.97
4.3.100.0060.0096.97
4.3.90.0040.0126.95
4.3.80.0020.0156.93
4.3.70.0030.0106.95
4.3.60.0050.0086.95
4.3.50.0020.0156.95
4.3.40.0040.0156.90
4.3.30.0040.0106.29
4.3.20.0040.0106.28
4.3.10.0030.0106.26
4.3.00.0110.0108.17

preferences:
40.38 ms | 401 KiB | 5 Q