3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = sprintf('SELECT * FROM %s INNER JOIN %s a ON (a.user_id = created_by) LEFT JOIN %s b ON (b.user_id = modified_by) WHERE provider_name LIKE "%%?%%" LIMIT ?,?', TABLE_NAME1, TABLE_NAME2, TABLE_NAME3);

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.70.0120.00318.43
8.3.60.0110.00416.73
8.3.50.0090.00622.05
8.3.40.0150.00018.84
8.3.30.0030.01019.02
8.3.20.0070.00020.29
8.3.10.0040.00423.48
8.3.00.0000.00820.74
8.2.180.0080.00816.63
8.2.170.0100.00319.04
8.2.160.0080.00822.96
8.2.150.0030.00624.18
8.2.140.0040.00424.66
8.2.130.0070.00026.16
8.2.120.0060.00320.75
8.2.110.0060.00322.08
8.2.100.0060.00619.58
8.2.90.0070.00019.23
8.2.80.0080.00017.97
8.2.70.0080.00017.63
8.2.60.0040.00717.80
8.2.50.0050.00318.07
8.2.40.0040.00418.16
8.2.30.0040.00418.21
8.2.20.0000.00817.73
8.2.10.0040.00418.06
8.2.00.0000.00817.62
8.1.280.0040.01125.92
8.1.270.0080.00023.83
8.1.260.0040.00426.35
8.1.250.0000.00728.09
8.1.240.0080.00022.18
8.1.230.0110.00019.09
8.1.220.0060.00317.74
8.1.210.0030.00518.77
8.1.200.0060.00317.35
8.1.190.0000.00817.23
8.1.180.0050.00318.10
8.1.170.0000.00918.46
8.1.160.0070.00021.92
8.1.150.0000.00718.56
8.1.140.0060.00317.36
8.1.130.0030.00317.77
8.1.120.0090.00017.44
8.1.110.0000.00817.38
8.1.100.0000.00717.39
8.1.90.0040.00417.36
8.1.80.0080.00017.39
8.1.70.0070.00017.26
8.1.60.0050.00317.58
8.1.50.0050.00317.34
8.1.40.0030.00517.32
8.1.30.0000.00817.48
8.1.20.0070.00017.49
8.1.10.0000.00717.45
8.1.00.0000.00817.34
8.0.300.0050.00218.77
8.0.290.0070.00017.16
8.0.280.0030.00518.32
8.0.270.0050.00317.33
8.0.260.0030.00517.27
8.0.250.0030.00316.96
8.0.240.0040.00417.04
8.0.230.0030.00317.03
8.0.220.0000.00716.83
8.0.210.0000.00717.02
8.0.200.0030.00316.93
8.0.190.0000.00717.04
8.0.180.0040.00416.95
8.0.170.0080.00017.05
8.0.160.0000.00716.81
8.0.150.0000.00716.98
8.0.140.0040.00416.85
8.0.130.0000.00813.43
8.0.120.0040.00416.97
8.0.110.0040.00416.99
8.0.100.0000.00716.93
8.0.90.0080.00017.02
8.0.80.0060.01216.93
8.0.70.0000.00716.99
8.0.60.0000.00816.83
8.0.50.0020.00516.87
8.0.30.0100.00917.17
8.0.20.0080.01417.40
8.0.10.0040.00416.99
8.0.00.0110.00816.69
7.4.330.0030.00315.07
7.4.320.0000.00616.60
7.4.300.0000.00816.45
7.4.290.0000.00616.64
7.4.280.0050.00516.49
7.4.270.0030.00616.57
7.4.260.0070.00016.50
7.4.250.0000.00716.50
7.4.240.0060.00216.58
7.4.230.0030.00316.35
7.4.220.0070.01116.54
7.4.210.0070.01116.46
7.4.200.0070.00016.39
7.4.190.0030.00316.66
7.4.160.0040.01816.46
7.4.150.0090.01017.40
7.4.140.0110.00617.86
7.4.130.0110.00516.48
7.4.120.0090.01116.54
7.4.110.0200.00316.66
7.4.100.0140.00616.64
7.4.90.0070.01016.65
7.4.80.0080.01219.39
7.4.70.0090.00916.53
7.4.60.0090.00916.48
7.4.50.0050.00016.32
7.4.40.0140.00316.54
7.4.30.0100.00716.34
7.4.00.0070.01014.84
7.3.330.0030.00312.92
7.3.320.0020.00213.04
7.3.310.0040.00416.05
7.3.300.0070.00016.21
7.3.290.0070.01416.23
7.3.280.0110.00516.18
7.3.270.0070.01017.40
7.3.260.0100.00716.37
7.3.250.0110.00816.46
7.3.240.0090.00616.48
7.3.230.0140.01016.39
7.3.210.0070.01116.31
7.3.200.0100.00719.39
7.3.190.0130.00316.45
7.3.180.0030.01916.22
7.3.170.0080.00816.36
7.3.160.0120.00416.42
7.3.120.0070.00714.87
7.3.10.0130.00016.44
7.3.00.0040.01116.35
7.2.330.0070.01116.58
7.2.320.0180.00616.58
7.2.310.0090.00916.57
7.2.300.0080.00816.56
7.2.290.0170.00016.29
7.2.130.0080.00816.68
7.2.120.0040.00816.88
7.2.110.0100.00616.79
7.2.100.0060.00916.37
7.2.90.0040.00816.76
7.2.80.0070.00716.75
7.2.70.0070.00416.69
7.2.60.0070.01016.89
7.2.50.0000.01116.59
7.2.40.0090.00316.56
7.2.30.0000.01116.91
7.2.20.0070.01116.57
7.2.10.0030.01316.63
7.2.00.0030.00716.91
7.1.250.0030.00615.70
7.1.240.0030.00615.41
7.1.230.0030.00615.65
7.1.220.0100.00315.81
7.1.210.0000.00815.79
7.1.200.0080.00315.44
7.1.190.0140.00015.81
7.1.180.0080.00015.81
7.1.170.0070.00715.66
7.1.160.0060.00615.73
7.1.150.0100.00315.31
7.1.140.0030.01415.66
7.1.130.0080.00015.66
7.1.120.0030.01115.68
7.1.110.0060.00315.78
7.1.100.0070.00715.51
7.1.90.0030.01415.85
7.1.80.0060.00615.70
7.1.70.0020.00716.30
7.1.60.0050.01417.68
7.1.50.0050.01016.06
7.1.40.0040.00715.37
7.1.30.0070.01015.57
7.1.20.0080.00415.43
7.1.10.0070.00415.27
7.1.00.0000.04718.93
7.0.330.0040.01115.42
7.0.320.0060.00914.86
7.0.310.0070.00715.18
7.0.300.0040.00714.96
7.0.290.0070.00715.07
7.0.280.0030.00915.23
7.0.270.0070.01015.01
7.0.260.0060.00615.24
7.0.250.0040.01115.43
7.0.240.0080.00814.98
7.0.230.0040.01115.39
7.0.220.0100.00315.17
7.0.210.0060.00615.25
7.0.200.0150.00514.76
7.0.190.0030.00815.07
7.0.180.0030.01115.32
7.0.170.0080.00814.91
7.0.160.0030.00614.89
7.0.150.0040.01115.21
7.0.140.0030.04218.45
7.0.130.0040.01115.19
7.0.120.0000.00815.23
7.0.110.0110.00315.39
7.0.100.0090.00615.16
7.0.90.0070.00714.84
7.0.80.0070.01015.15
7.0.70.0030.00515.00
7.0.60.0030.04817.59
7.0.50.0070.02216.41
7.0.40.0020.03016.79
7.0.30.0140.03916.63
7.0.20.0100.02716.46
7.0.10.0050.04516.63
7.0.00.0040.02316.68
5.6.380.0060.00314.18
5.6.370.0080.00614.07
5.6.360.0130.00313.99
5.6.350.0070.00714.12
5.6.340.0070.00414.00
5.6.330.0030.01314.20
5.6.320.0000.00913.81
5.6.310.0030.00714.20
5.6.300.0070.00714.34
5.6.290.0100.00614.04
5.6.280.0100.03417.55
5.6.270.0120.00313.94
5.6.260.0060.00614.12
5.6.250.0060.00914.08
5.6.240.0030.00714.16
5.6.230.0090.00013.88
5.6.220.0030.01014.10
5.6.210.0070.03617.45
5.6.200.0100.04616.12
5.6.190.0080.03117.49
5.6.180.0120.02617.29
5.6.170.0180.03517.31
5.6.160.0070.02317.26
5.6.150.0100.03016.19
5.6.140.0080.03616.34
5.6.130.0040.02516.12
5.6.120.0050.03317.46
5.6.110.0120.04017.69
5.6.100.0100.04317.45
5.6.90.0110.03517.53
5.6.80.0140.04217.04
5.6.70.0030.00914.11
5.6.60.0060.01013.84
5.6.50.0050.00513.99
5.6.40.0040.01113.98
5.6.30.0070.00714.00
5.6.20.0000.01114.23
5.6.10.0070.00714.04
5.6.00.0070.00714.12
5.5.380.0030.00910.59
5.5.370.0030.00711.00
5.5.360.0030.00911.04
5.5.350.0150.03915.75
5.5.340.0050.04114.37
5.5.330.0040.02815.67
5.5.320.0080.04615.65
5.5.310.0100.02815.43
5.5.300.0050.03514.27
5.5.290.0080.03014.51
5.5.280.0090.03215.87
5.5.270.0120.04015.66
5.5.260.0030.03215.99
5.5.250.0100.02515.66
5.5.240.0120.04115.56
5.5.230.0000.00910.92
5.5.220.0030.00611.02
5.5.210.0000.01210.83
5.5.200.0030.00911.04
5.5.190.0070.00410.98
5.5.180.0000.01210.87
5.5.170.0070.00710.92
5.5.160.0060.00610.84
5.5.150.0000.01010.49
5.5.140.0040.00710.80
5.5.130.0040.00411.07
5.5.120.0000.00610.76
5.5.110.0060.00010.63
5.5.100.0000.00610.65
5.5.90.0040.00410.73
5.5.80.0070.00710.82
5.5.70.0060.00610.93
5.5.60.0040.00710.66
5.5.50.0040.00710.81
5.5.40.0070.00310.48
5.5.30.0100.00010.93
5.5.20.0080.00010.59
5.5.10.0040.00410.88
5.5.00.0000.01110.75
5.4.450.0160.02515.24
5.4.440.0080.02715.08
5.4.430.0150.02614.96
5.4.420.0040.03515.06
5.4.410.0130.02714.68
5.4.400.0170.02714.75
5.4.390.0160.02714.68
5.4.380.0120.03114.53
5.4.370.0140.03114.54
5.4.360.0200.02314.61
5.4.350.0060.03011.39
5.4.340.0050.02211.40
5.4.330.0000.01110.51
5.4.320.0070.02111.45
5.4.310.0040.02311.62
5.4.300.0080.02811.64
5.4.290.0070.02811.60
5.4.280.0050.02911.63
5.4.270.0080.02511.52
5.4.260.0070.03011.51
5.4.250.0090.02511.42
5.4.240.0050.03311.38
5.4.230.0080.02511.54
5.4.220.0040.02711.54
5.4.210.0050.02511.63
5.4.200.0040.02711.47
5.4.190.0070.02611.55
5.4.180.0080.02511.46
5.4.170.0060.02711.33
5.4.160.0070.01711.49
5.4.150.0040.01911.55
5.4.140.0040.02411.43
5.4.130.0040.02011.24
5.4.120.0050.02011.21
5.4.110.0060.02311.36
5.4.100.0100.02511.38
5.4.90.0060.04111.36
5.4.80.0070.02611.39
5.4.70.0060.02211.35
5.4.60.0080.02511.40
5.4.50.0060.03311.37
5.4.40.0150.05711.22
5.4.30.0080.03911.35
5.4.20.0030.02911.29
5.4.10.0080.01911.27
5.4.00.0050.02011.17
5.3.290.0050.02611.63
5.3.280.0020.02911.53
5.3.270.0050.02311.64
5.3.260.0030.02511.49
5.3.250.0060.02311.59
5.3.240.0060.03111.47
5.3.230.0070.02711.55
5.3.220.0070.02911.54
5.3.210.0070.02211.50
5.3.200.0060.02211.48
5.3.190.0040.02311.54
5.3.180.0050.02211.52
5.3.170.0040.02411.46
5.3.160.0050.02311.62
5.3.150.0020.02911.49
5.3.140.0070.02511.42
5.3.130.0060.02111.45
5.3.120.0040.02211.45
5.3.110.0040.02511.57
5.3.100.0080.02011.23
5.3.90.0030.02411.27
5.3.80.0070.02311.13
5.3.70.0040.02311.16
5.3.60.0040.02911.20
5.3.50.0040.02011.16
5.3.40.0030.02311.08
5.3.30.0050.02311.11
5.3.20.0070.01810.91
5.3.10.0050.02310.89
5.3.00.0040.02610.79
5.2.170.0040.0189.29
5.2.160.0050.0179.29
5.2.150.0040.0199.33
5.2.140.0060.0189.29
5.2.130.0050.0159.27
5.2.120.0040.0179.27
5.2.110.0060.0239.28
5.2.100.0030.0239.28
5.2.90.0040.0229.31
5.2.80.0040.0229.27
5.2.70.0060.0239.27
5.2.60.0040.0259.25
5.2.50.0060.0219.23
5.2.40.0040.0209.22
5.2.30.0080.0169.21
5.2.20.0040.0209.20
5.2.10.0020.0199.16
5.2.00.0090.0149.10
5.1.60.0040.0148.74
5.1.50.0050.0188.73
5.1.40.0030.0168.73
5.1.30.0070.0168.90
5.1.20.0050.0188.91
5.1.10.0030.0218.78
5.1.00.0060.0178.78
5.0.50.0050.0148.01
5.0.40.0070.0157.94
5.0.30.0040.0267.85
5.0.20.0020.0167.84
5.0.10.0030.0167.82
5.0.00.0020.0237.82
4.4.90.0040.0097.10
4.4.80.0020.0127.09
4.4.70.0020.0127.09
4.4.60.0020.0097.08
4.4.50.0030.0117.09
4.4.40.0020.0157.06
4.4.30.0010.0127.08
4.4.20.0040.0087.13
4.4.10.0030.0107.13
4.4.00.0030.0167.09
4.3.110.0020.0147.04
4.3.100.0030.0127.04
4.3.90.0040.0127.03
4.3.80.0030.0207.00
4.3.70.0040.0107.02
4.3.60.0040.0217.02
4.3.50.0040.0137.02
4.3.40.0030.0176.98
4.3.30.0020.0106.35
4.3.20.0020.0116.33
4.3.10.0010.0106.32
4.3.00.0020.01213.17

preferences:
36.82 ms | 401 KiB | 5 Q