3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = "SELECT fc.forum_id,count(fc.forum_id)as total_comments ". "FROM ForumComments as fc ". "WHERE DATE_SUB( CURDATE( ) , INTERVAL 1 DAY ) <= 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.0140.00418.42
8.3.50.0050.01121.92
8.3.40.0110.00418.63
8.3.30.0040.01118.68
8.3.20.0070.00720.16
8.3.10.0080.00023.49
8.3.00.0080.00019.56
8.2.180.0070.01318.04
8.2.170.0120.00922.96
8.2.160.0100.00320.39
8.2.150.0080.00024.18
8.2.140.0040.00424.66
8.2.130.0000.00826.16
8.2.120.0040.00421.04
8.2.110.0040.00422.21
8.2.100.0110.00020.64
8.2.90.0050.00219.21
8.2.80.0080.00017.97
8.2.70.0090.00017.63
8.2.60.0040.00417.80
8.2.50.0030.00618.07
8.2.40.0000.00819.82
8.2.30.0040.00418.16
8.2.20.0040.00417.59
8.2.10.0050.00318.01
8.2.00.0040.00417.69
8.1.280.0040.01125.92
8.1.270.0000.00823.82
8.1.260.0040.00426.35
8.1.250.0040.00428.09
8.1.240.0030.00623.67
8.1.230.0080.00319.05
8.1.220.0040.00417.79
8.1.210.0050.00318.77
8.1.200.0060.00317.23
8.1.190.0040.00417.23
8.1.180.0000.00818.10
8.1.170.0040.00418.24
8.1.160.0030.00721.95
8.1.150.0000.00718.43
8.1.140.0000.00817.39
8.1.130.0000.00817.93
8.1.120.0070.00017.43
8.1.110.0090.00017.41
8.1.100.0070.00017.45
8.1.90.0000.00717.27
8.1.80.0040.00317.38
8.1.70.0040.00417.34
8.1.60.0000.00817.50
8.1.50.0040.00417.35
8.1.40.0040.00417.49
8.1.30.0000.00817.48
8.1.20.0000.00817.52
8.1.10.0060.00317.34
8.1.00.0060.00617.43
8.0.300.0050.00318.77
8.0.290.0000.00816.63
8.0.280.0000.00718.45
8.0.270.0030.00317.26
8.0.260.0030.00317.23
8.0.250.0000.00816.90
8.0.240.0030.00316.96
8.0.230.0070.00016.86
8.0.220.0050.00516.88
8.0.210.0030.00316.85
8.0.200.0000.00816.80
8.0.190.0030.00316.78
8.0.180.0000.00716.91
8.0.170.0080.00016.75
8.0.160.0000.00716.70
8.0.150.0050.00216.74
8.0.140.0000.00816.82
8.0.130.0000.00613.26
8.0.120.0060.00316.78
8.0.110.0070.00016.77
8.0.100.0040.00416.70
8.0.90.0000.00716.70
8.0.80.0100.01016.81
8.0.70.0040.00416.70
8.0.60.0080.00016.91
8.0.50.0040.00416.94
8.0.30.0060.01217.05
8.0.20.0090.01217.40
8.0.10.0050.00216.79
8.0.00.0080.00816.66
7.4.330.0000.00515.06
7.4.320.0030.00316.54
7.4.300.0030.00316.43
7.4.290.0000.00716.55
7.4.280.0040.00416.36
7.4.270.0030.00316.38
7.4.260.0070.00016.53
7.4.250.0040.00416.45
7.4.240.0020.00516.47
7.4.230.0070.00016.32
7.4.220.0140.00416.39
7.4.210.0140.00016.61
7.4.200.0030.00316.56
7.4.160.0130.01316.23
7.4.150.0100.01417.40
7.4.140.0090.00817.86
7.4.130.0080.00816.54
7.4.120.0150.00516.48
7.4.110.0100.00716.65
7.4.100.0150.00916.48
7.4.90.0120.00916.43
7.4.80.0140.01019.39
7.4.70.0060.00916.47
7.4.60.0100.00616.29
7.4.50.0030.00316.46
7.4.40.0090.00616.52
7.4.30.0080.00716.41
7.4.00.0090.00714.91
7.3.330.0030.00313.18
7.3.320.0020.00212.93
7.3.310.0000.00616.23
7.3.300.0080.00016.21
7.3.290.0130.00316.22
7.3.280.0110.00716.21
7.3.270.0100.00717.40
7.3.260.0060.01216.44
7.3.250.0090.01116.44
7.3.240.0100.00516.48
7.3.230.0100.00516.42
7.3.210.0050.01116.22
7.3.200.0110.00419.39
7.3.190.0120.00916.37
7.3.180.0160.00316.21
7.3.170.0110.01116.40
7.3.160.0100.00616.16
7.3.120.0030.01314.81
7.3.110.0070.01014.46
7.3.100.0150.00014.81
7.3.90.0140.00014.76
7.3.80.0000.01415.15
7.3.70.0070.00714.86
7.3.60.0080.00014.62
7.3.50.0100.00614.62
7.3.40.0030.01214.68
7.3.30.0030.00614.44
7.3.20.0040.01116.63
7.3.10.0100.00316.69
7.3.00.0030.00716.44
7.2.330.0130.00316.57
7.2.320.0120.00616.52
7.2.310.0100.00716.31
7.2.300.0070.01016.27
7.2.290.0120.00616.55
7.2.250.0170.00014.79
7.2.240.0070.01314.89
7.2.230.0120.00614.73
7.2.220.0050.00814.90
7.2.210.0060.01314.61
7.2.200.0060.00615.02
7.2.190.0080.00814.97
7.2.180.0090.00614.85
7.2.170.0070.00714.77
7.2.00.0230.00619.06
7.1.330.0000.01415.61
7.1.320.0040.01215.64
7.1.310.0040.01515.69
7.1.300.0090.00615.41
7.1.290.0070.00315.40
7.1.280.0100.00315.63
7.1.270.0070.00715.43
7.1.260.0070.00715.75
7.1.100.0040.01118.12
7.1.70.0000.00716.89
7.1.60.0070.01719.70
7.1.50.0180.00716.76
7.1.00.0100.07022.35
7.0.200.0050.00516.41
7.0.140.0100.06321.90
7.0.60.0030.08719.82
7.0.50.0070.08017.88
7.0.40.0000.06020.06
7.0.30.0230.08720.30
7.0.20.0270.04320.09
7.0.10.0170.05020.21
7.0.00.0100.04020.00
5.6.280.0070.07021.14
5.6.210.0070.06720.60
5.6.200.0030.09018.22
5.6.190.0030.04320.49
5.6.180.0070.07720.48
5.6.170.0070.04720.47
5.6.160.0100.07320.44
5.6.150.0030.06718.09
5.6.140.0030.05318.16
5.6.130.0130.07018.13
5.6.120.0070.05321.07
5.6.110.0070.04320.97
5.6.100.0030.08320.88
5.6.90.0130.07721.07
5.6.80.0170.06020.43
5.6.70.0200.07720.40
5.5.350.0000.07720.47
5.5.340.0100.06317.96
5.5.330.0070.07320.20
5.5.320.0330.04320.18
5.5.310.0470.06020.28
5.5.300.0070.08717.95
5.5.290.0030.05017.89
5.5.280.0030.08720.87
5.5.270.0030.08720.88
5.5.260.0070.04020.87
5.5.250.0070.08020.45
5.5.240.0030.05020.13
5.4.450.0730.04719.55
5.4.440.0530.04043.94
5.4.430.0430.04343.92
5.4.420.0100.03043.91
5.4.410.0500.04743.90
5.4.400.0430.03743.90
5.4.390.0330.03743.89
5.4.380.0100.05718.61
5.4.370.0070.05718.69
5.4.360.0030.06018.60
5.4.350.0170.05718.71
5.4.340.0170.04718.48
5.4.320.0070.04212.45
5.4.310.0040.04412.45
5.4.300.0060.03612.45
5.4.290.0060.03712.45
5.4.280.0060.03512.35
5.4.270.0080.03412.35
5.4.260.0070.03612.35
5.4.250.0070.03612.34
5.4.240.0060.03612.35
5.4.230.0050.03812.34
5.4.220.0080.03812.34
5.4.210.0070.03712.34
5.4.200.0070.04012.34
5.4.190.0060.03612.34
5.4.180.0090.03612.34
5.4.170.0070.03712.34
5.4.160.0090.03612.34
5.4.150.0070.03312.34
5.4.140.0080.04212.02
5.4.130.0080.03712.01
5.4.120.0090.03111.96
5.4.110.0060.04111.96
5.4.100.0050.03511.97
5.4.90.0050.03611.96
5.4.80.0080.03811.96
5.4.70.0050.03711.96
5.4.60.0040.03511.96
5.4.50.0110.03711.96
5.4.40.0050.03511.95
5.4.30.0080.03511.95
5.4.20.0090.03311.94
5.4.10.0050.03811.95
5.4.00.0040.03711.43
5.3.290.0060.03912.80
5.3.280.0090.04112.71
5.3.270.0060.04212.72
5.3.260.0020.04412.72
5.3.250.0070.04412.72
5.3.240.0090.03812.72
5.3.230.0090.03312.71
5.3.220.0100.03812.68
5.3.210.0110.03312.68
5.3.200.0060.03812.68
5.3.190.0050.03812.68
5.3.180.0100.03812.67
5.3.170.0120.04112.67
5.3.160.0050.03812.67
5.3.150.0050.03912.68
5.3.140.0110.03212.66
5.3.130.0010.04312.66
5.3.120.0090.04612.66
5.3.110.0080.03812.66
5.3.100.0060.03612.12
5.3.90.0070.03512.09
5.3.80.0140.03312.07
5.3.70.0060.03612.07
5.3.60.0080.03412.07
5.3.50.0060.03612.00
5.3.40.0090.03312.00
5.3.30.0060.03611.94
5.3.20.0040.04111.72
5.3.10.0050.03511.69
5.3.00.0080.03911.67
5.2.170.0050.0299.18
5.2.160.0070.0269.18
5.2.150.0030.0319.18
5.2.140.0070.0279.18
5.2.130.0060.0299.14
5.2.120.0050.0279.13
5.2.110.0080.0259.14
5.2.100.0060.0269.14
5.2.90.0050.0289.13
5.2.80.0020.0329.13
5.2.70.0060.0369.13
5.2.60.0040.0379.09
5.2.50.0070.0269.05
5.2.40.0030.0299.03
5.2.30.0040.0399.01
5.2.20.0050.0319.00
5.2.10.0050.0358.92
5.2.00.0030.0348.78
5.1.60.0050.0248.06
5.1.50.0030.0258.06
5.1.40.0060.0238.04
5.1.30.0070.0268.39
5.1.20.0110.0288.41
5.1.10.0040.0268.13
5.1.00.0060.0238.13
5.0.50.0050.0276.61
5.0.40.0020.0246.47
5.0.30.0030.0316.28
5.0.20.0040.0186.25
5.0.10.0030.0206.23
5.0.00.0020.0316.22
4.4.90.0060.0194.78
4.4.80.0040.0134.76
4.4.70.0040.0144.75
4.4.60.0030.0154.75
4.4.50.0020.0204.77
4.4.40.0050.0264.70
4.4.30.0040.0184.76
4.4.20.0000.0184.84
4.4.10.0050.0204.85
4.4.00.0020.0254.76
4.3.110.0030.0154.66
4.3.100.0020.0154.67
4.3.90.0040.0134.63
4.3.80.0050.0244.58
4.3.70.0000.0174.63
4.3.60.0040.0134.63
4.3.50.0030.0154.62
4.3.40.0020.0244.54
4.3.30.0040.0173.27
4.3.20.0020.0193.25
4.3.10.0020.0153.22
4.3.00.0030.01743.87

preferences:
36.84 ms | 401 KiB | 5 Q