3v4l.org

run code in 300+ PHP versions simultaneously
<?php $yesterday = date('Y-m-d', strtotime("-1 days")); $sql = "SELECT fc.forum_id,count(fc.forum_id)as total_comments ". "FROM ForumComments as fc ". "WHERE $yesterday <= fc.updated_at ". "GROUP BY fc.forum_id ". "ORDER BY total_comments DESC "; echo($sql);

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.0120.00918.64
8.3.50.0130.00822.11
8.3.40.0000.01518.85
8.3.30.0140.00018.92
8.3.20.0030.00520.37
8.3.10.0040.00423.52
8.3.00.0080.00019.69
8.2.180.0150.00316.88
8.2.170.0070.01322.96
8.2.160.0110.00420.53
8.2.150.0090.00024.18
8.2.140.0040.00424.66
8.2.130.0030.00526.16
8.2.120.0000.00820.98
8.2.110.0060.00322.38
8.2.100.0070.00417.89
8.2.90.0040.00419.34
8.2.80.0090.00017.97
8.2.70.0040.00417.75
8.2.60.0000.00818.05
8.2.50.0050.00318.07
8.2.40.0000.00818.34
8.2.30.0000.00718.46
8.2.20.0070.00017.82
8.2.10.0040.00418.11
8.2.00.0030.00619.70
8.1.280.0100.01025.92
8.1.270.0080.00023.89
8.1.260.0070.00026.35
8.1.250.0070.00028.09
8.1.240.0030.00623.86
8.1.230.0100.00019.06
8.1.220.0080.00017.77
8.1.210.0000.00818.77
8.1.200.0080.00017.48
8.1.190.0030.00517.48
8.1.180.0030.00618.10
8.1.170.0000.00818.77
8.1.160.0030.00522.05
8.1.150.0000.00818.90
8.1.140.0080.00017.63
8.1.130.0030.00317.97
8.1.120.0050.00317.65
8.1.110.0030.00517.61
8.1.100.0000.00717.73
8.1.90.0030.00317.75
8.1.80.0050.00217.66
8.1.70.0000.00717.73
8.1.60.0060.00317.70
8.1.50.0040.00417.62
8.1.40.0020.00517.72
8.1.30.0000.00817.79
8.1.20.0040.00417.88
8.1.10.0040.00417.66
8.1.00.0030.00717.70
8.0.300.0030.00618.77
8.0.290.0070.00016.72
8.0.280.0000.00718.51
8.0.270.0070.00017.44
8.0.260.0000.00717.45
8.0.250.0030.00317.28
8.0.240.0000.00717.23
8.0.230.0000.00717.18
8.0.220.0040.00417.08
8.0.210.0030.00317.15
8.0.200.0070.00017.14
8.0.190.0000.00717.14
8.0.180.0000.00817.21
8.0.170.0080.00017.09
8.0.160.0030.00417.01
8.0.150.0050.00217.08
8.0.140.0040.00417.08
8.0.130.0000.00613.53
8.0.120.0000.00717.10
8.0.110.0030.00517.06
8.0.100.0070.00017.02
8.0.90.0050.00217.05
8.0.80.0000.01617.18
8.0.70.0000.00717.02
8.0.60.0070.00016.97
8.0.50.0070.00017.02
8.0.30.0130.00617.18
8.0.20.0100.01017.48
8.0.10.0050.00317.25
8.0.00.0140.00716.92
7.4.330.0030.00315.03
7.4.320.0030.00316.70
7.4.300.0060.00016.65
7.4.290.0030.00316.72
7.4.280.0040.00416.63
7.4.270.0000.00716.67
7.4.260.0000.00716.57
7.4.250.0000.00716.63
7.4.240.0040.00316.62
7.4.230.0000.00716.85
7.4.220.0140.00716.78
7.4.210.0090.00916.58
7.4.200.0070.00016.54
7.4.160.0090.00917.00
7.4.150.0080.01117.40
7.4.140.0100.01017.86
7.4.130.0110.00516.61
7.4.120.0050.01316.67
7.4.110.0140.00316.75
7.4.100.0030.01416.59
7.4.90.0100.00716.76
7.4.80.0120.00619.39
7.4.70.0030.01316.79
7.4.60.0070.01016.72
7.4.50.0040.00416.61
7.4.40.0100.00616.58
7.4.30.0100.00716.67
7.4.00.0060.01214.84
7.3.330.0000.00613.45
7.3.320.0030.00313.22
7.3.310.0090.00016.53
7.3.300.0040.00416.37
7.3.290.0130.00716.55
7.3.280.0060.01116.50
7.3.270.0100.01017.40
7.3.260.0170.00716.51
7.3.250.0140.00316.87
7.3.240.0060.01516.80
7.3.230.0110.00616.72
7.3.210.0180.00416.68
7.3.200.0030.01319.39
7.3.190.0110.00516.73
7.3.180.0070.01016.63
7.3.170.0110.00516.66
7.3.160.0130.00316.78
7.3.120.0100.00315.07
7.2.330.0140.00416.91
7.2.320.0000.01616.89
7.2.310.0110.00616.57
7.2.300.0040.01216.95
7.2.290.0060.01016.70
7.2.00.0070.00419.54
7.1.200.0100.00316.04
7.1.100.0090.00518.35
7.1.70.0040.00417.52
7.1.60.0100.01419.70
7.1.50.0100.01317.02
7.1.00.0030.07722.48
7.0.200.0000.01116.66
7.0.140.0070.06722.09
7.0.100.0030.06719.99
7.0.90.0100.07720.02
7.0.80.0070.07720.02
7.0.70.0100.06719.93
7.0.60.0100.08320.01
7.0.50.0100.07720.38
7.0.40.0030.05020.00
7.0.30.0070.09320.10
7.0.20.0070.06720.19
7.0.10.0030.08020.08
7.0.00.0100.08020.07
5.6.280.0070.07021.10
5.6.250.0170.07320.56
5.6.240.0100.07320.63
5.6.230.0130.06320.63
5.6.220.0070.07720.45
5.6.210.0100.08020.63
5.6.200.0030.06721.11
5.6.190.0070.05020.97
5.6.180.0170.04021.13
5.6.170.0070.06321.01
5.6.160.0100.08021.14
5.6.150.0130.08321.01
5.6.140.0030.05021.07
5.6.130.0170.07320.94
5.6.120.0100.08321.13
5.6.110.0070.08320.94
5.6.100.0100.07720.91
5.6.90.0100.07020.92
5.6.80.0070.08320.55
5.6.70.0070.08020.54
5.6.60.0130.07720.41
5.6.50.0100.08020.48
5.6.40.0130.07320.30
5.6.30.0070.07720.29
5.6.20.0030.08020.30
5.6.10.0170.06720.39
5.6.00.0070.08320.36
5.5.380.0030.08020.45
5.5.370.0070.08720.36
5.5.360.0170.06020.44
5.5.350.0100.08020.47
5.5.340.0130.07320.86
5.5.330.0130.06020.80
5.5.320.0030.09020.89
5.5.310.0030.07020.91
5.5.300.0030.05320.79
5.5.290.0070.06720.92
5.5.280.0070.06720.83
5.5.270.0130.04720.77
5.5.260.0070.07020.80
5.5.250.0070.08720.69
5.5.240.0100.08320.17
5.5.230.0100.08020.10
5.5.220.0170.06720.17
5.5.210.0070.07720.29
5.5.200.0100.06720.18
5.5.190.0100.07320.16
5.5.180.0130.07320.23
5.5.160.0070.08020.25
5.5.150.0130.07320.20
5.5.140.0170.07320.11
5.5.130.0100.06020.13
5.5.120.0130.08020.12
5.5.110.0030.08720.13
5.5.100.0100.07320.11
5.5.90.0030.08720.06
5.5.80.0130.07720.03
5.5.70.0030.05020.13
5.5.60.0100.08019.99
5.5.50.0000.06720.04
5.5.40.0030.08020.15
5.5.30.0030.05020.13
5.5.20.0100.07720.02
5.5.10.0100.07020.10
5.5.00.0070.05020.06
5.4.450.0130.06319.27
5.4.440.0130.07019.35
5.4.430.0100.07019.43
5.4.420.0100.07719.21
5.4.410.0170.07019.09
5.4.400.0100.07019.12
5.4.390.0100.06319.03
5.4.380.0230.06019.13
5.4.370.0030.08319.10
5.4.360.0070.08019.05
5.4.350.0170.04719.14
5.4.340.0070.07019.04
5.4.320.0070.07019.06
5.4.310.0070.07318.96
5.4.300.0170.08718.81
5.4.290.0070.06019.09
5.4.280.0070.07719.16
5.4.270.0100.08019.22
5.4.260.0000.05019.12
5.4.250.0000.08318.90
5.4.240.0030.07718.80
5.4.230.0030.07018.82
5.4.220.0130.08018.93
5.4.210.0170.06319.11
5.4.200.0070.07319.11
5.4.190.0070.08019.02
5.4.180.0100.07718.80
5.4.170.0100.06019.05
5.4.160.0000.06719.07
5.4.150.0130.07019.07
5.4.140.0100.05016.43
5.4.130.0070.06316.41
5.4.120.0070.07016.42
5.4.110.0000.07016.36
5.4.100.0030.07316.29
5.4.90.0070.07316.26
5.4.80.0000.07016.24
5.4.70.0030.04016.40
5.4.60.0070.03716.28
5.4.50.0070.07016.38
5.4.40.0030.06316.23
5.4.30.0030.05716.23
5.4.20.0070.06716.41
5.4.10.0130.05316.39
5.4.00.0130.07015.83
5.3.290.0030.08314.65
5.3.280.0130.07314.58
5.3.270.0030.07714.59
5.3.260.0130.07014.54
5.3.250.0170.07314.60
5.3.240.0100.04314.56
5.3.230.0030.07314.43
5.3.220.0100.07014.42
5.3.210.0000.07714.56
5.3.200.0070.07714.57
5.3.190.0100.07014.56
5.3.180.0100.06314.39
5.3.170.0030.04014.57
5.3.160.0070.05314.50
5.3.150.0030.04714.54
5.3.140.0100.05014.49
5.3.130.0070.04714.55
5.3.120.0070.07314.41
5.3.110.0030.06314.45
5.3.100.0100.06713.87
5.3.90.0070.04013.87
5.3.80.0070.03713.86
5.3.70.0000.04313.77
5.3.60.0070.03713.98
5.3.50.0100.05713.80
5.3.40.0030.04313.80
5.3.30.0100.04713.90
5.3.20.0070.04713.66
5.3.10.0030.04713.51
5.3.00.0000.08013.49
5.2.170.0030.04711.09
5.2.160.0100.04011.00
5.2.150.0100.05311.10
5.2.140.0000.07011.12
5.2.130.0070.06010.89
5.2.120.0100.04311.09
5.2.110.0070.04011.06
5.2.100.0100.05310.89
5.2.90.0070.05311.05
5.2.80.0200.03011.14
5.2.70.0000.04010.93
5.2.60.0170.04011.04
5.2.50.0100.06011.00
5.2.40.0100.06010.99
5.2.30.0070.06010.82
5.2.20.0000.06310.95
5.2.10.0070.06010.71
5.2.00.0100.05710.64
5.1.60.0100.04710.35
5.1.50.0100.02710.35
5.1.40.0070.02710.35
5.1.30.0000.05010.38
5.1.20.0000.03310.35
5.1.10.0030.05310.35
5.1.00.0000.06010.35
5.0.50.0000.04710.35
5.0.40.0030.02710.35
5.0.30.0070.05010.35
5.0.20.0000.04310.35
5.0.10.0000.02310.35
5.0.00.0070.05710.35
4.4.90.0000.02010.35
4.4.80.0030.01710.35
4.4.70.0000.03710.35
4.4.60.0030.03710.35
4.4.50.0030.03310.35
4.4.40.0000.03310.35
4.4.30.0000.02010.35
4.4.20.0030.03310.35
4.4.10.0070.03010.35
4.4.00.0000.04010.35
4.3.110.0000.01710.35
4.3.100.0000.02710.35
4.3.90.0000.02010.35
4.3.80.0030.02310.35
4.3.70.0030.02010.35
4.3.60.0030.01310.35
4.3.50.0000.03310.35
4.3.40.0000.02710.35
4.3.30.0000.01710.35
4.3.20.0000.01710.35
4.3.10.0000.01710.35
4.3.00.0000.02310.35

preferences:
34.15 ms | 401 KiB | 5 Q