3v4l.org

run code in 300+ PHP versions simultaneously
<?php $json = <<< 'JSON' {"main_sql":"select now(), col2, col3 as col3$_key_ , round(sum(col4)/%placeholder1%) as f_sum_col4$_key2, round((sum(col5)/%placeholder1%/1000000)*8) as f_sum_col5$_key3 from table1 where col6 != 'string1' and col8 NOT like '%STRING2%' and col9 like '%STRING3%' and col7 > %placeholder1% group by col2, col3 having ((sum(col4)/%placeholder1%) > 100000) or ((sum(col5)/%placeholder1%/1000000)*8) > 1000 order by f_sum_col5$_key3 DESC limit 100 "} JSON; var_dump(json_decode($json, true));

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.0090.00916.48
8.3.50.0090.00921.04
8.3.40.0100.01018.73
8.3.30.0140.00018.48
8.3.20.0080.00018.90
8.3.10.0040.00421.91
8.3.00.0040.00718.85
8.2.180.0120.00316.63
8.2.170.0100.01022.96
8.2.160.0100.00320.53
8.2.150.0040.01524.18
8.2.140.0070.00024.66
8.2.130.0070.00019.70
8.2.120.0050.00226.35
8.2.110.0170.00720.99
8.2.100.0110.00017.72
8.2.90.0040.00418.03
8.2.80.0040.00417.97
8.2.70.0000.00917.93
8.2.60.0080.00018.22
8.2.50.0000.01018.10
8.2.40.0040.00420.42
8.2.30.0050.00219.07
8.2.20.0040.00417.90
8.2.10.0040.00417.87
8.2.00.0060.00317.72
8.1.280.0120.00625.92
8.1.270.0040.00423.99
8.1.260.0000.00826.35
8.1.250.0000.00728.09
8.1.240.0040.00423.79
8.1.230.0090.00321.03
8.1.220.0040.00417.74
8.1.210.0040.00420.62
8.1.200.0000.00817.10
8.1.190.0030.00616.98
8.1.180.0000.00818.10
8.1.170.0080.00018.46
8.1.160.0070.00018.90
8.1.150.0000.00720.31
8.1.140.0000.00719.51
8.1.130.0030.00317.55
8.1.120.0070.00017.39
8.1.110.0060.00317.38
8.1.100.0040.00417.32
8.1.90.0050.00317.40
8.1.80.0070.00017.41
8.1.70.0000.00717.29
8.1.60.0030.00617.53
8.1.50.0040.00417.37
8.1.40.0100.00017.50
8.1.30.0080.00017.58
8.1.20.0000.00717.55
8.1.10.0030.00617.46
8.1.00.0040.00417.40
8.0.300.0000.00719.90
8.0.290.0000.01316.58
8.0.280.0000.00718.29
8.0.270.0030.00417.20
8.0.260.0030.00317.10
8.0.250.0000.00716.95
8.0.240.0030.00316.85
8.0.230.0000.00716.98
8.0.220.0030.00616.90
8.0.210.0040.00416.88
8.0.200.0030.00316.94
8.0.190.0000.00716.83
8.0.180.0000.01016.90
8.0.170.0000.00816.91
8.0.160.0040.00416.80
8.0.150.0000.00816.90
8.0.140.0000.00816.86
8.0.130.0050.00013.30
8.0.120.0040.00416.85
8.0.110.0070.00016.84
8.0.100.0070.00016.75
8.0.90.0080.00016.75
8.0.80.0040.01116.89
8.0.70.0040.00416.83
8.0.60.0050.00316.92
8.0.50.0080.00016.77
8.0.30.0130.00617.04
8.0.20.0080.01217.40
8.0.10.0080.00017.07
8.0.00.0070.01616.66
7.4.330.0000.00515.55
7.4.320.0000.00716.53
7.4.300.0000.00616.39
7.4.290.0070.00016.33
7.4.280.0000.00716.46
7.4.270.0000.00716.36
7.4.260.0030.00716.50
7.4.250.0070.00016.51
7.4.240.0040.00416.39
7.4.230.0000.00716.47
7.4.220.0150.01016.43
7.4.210.0120.00316.55
7.4.200.0000.00716.28
7.4.160.0060.01016.30
7.4.150.0050.01317.40
7.4.140.0080.01417.86
7.4.130.0090.00816.42
7.4.120.0080.01116.41
7.4.110.0040.01616.42
7.4.100.0090.00916.54
7.4.90.0030.01316.58
7.4.80.0060.01119.39
7.4.70.0080.00816.43
7.4.60.0070.01016.49
7.4.50.0070.00716.32
7.4.40.0040.01216.20
7.4.30.0060.01616.41
7.4.00.0100.00714.90
7.3.330.0000.00513.04
7.3.320.0060.00013.04
7.3.310.0000.00716.02
7.3.300.0030.00316.22
7.3.290.0050.00916.22
7.3.280.0070.01116.20
7.3.270.0160.00017.40
7.3.260.0120.01016.23
7.3.250.0070.01116.27
7.3.240.0110.00716.35
7.3.230.0060.01216.47
7.3.210.0100.00616.35
7.3.200.0030.01416.46
7.3.190.0030.01316.21
7.3.180.0090.00616.23
7.3.170.0070.01016.19
7.3.160.0150.00316.32
7.2.330.0040.01616.56
7.2.320.0100.00716.13
7.2.310.0070.01016.23
7.2.300.0180.00416.22
7.2.290.0030.01216.37
7.2.60.0000.01316.80
7.1.200.0060.00815.72
7.1.70.0000.00917.08
7.1.60.0070.00316.86
7.1.00.0130.06722.31
7.0.200.0360.00714.52
7.0.130.0130.05022.06
7.0.120.0070.05722.10
7.0.110.0070.06021.95
7.0.100.0000.06022.16
7.0.90.0030.06022.11
7.0.80.0070.05321.97
7.0.70.0030.06022.06
7.0.60.0100.05722.11
7.0.50.0100.05322.10
7.0.40.0070.05722.08
7.0.30.0070.06022.06
7.0.20.0100.05321.98
7.0.10.0030.06022.06
7.0.00.0100.06721.98
5.6.280.0130.05021.05
5.6.270.0130.05321.04
5.6.260.0130.06721.08
5.6.250.0030.05721.08
5.6.240.0000.08020.84
5.6.230.0030.06020.88
5.6.220.0100.07021.02
5.6.210.0130.05020.96
5.6.200.0130.05321.00
5.6.190.0130.05320.85
5.6.180.0070.06721.07
5.6.170.0170.04720.84
5.6.160.0130.07020.99
5.6.150.0130.06020.98
5.6.140.0030.06021.01
5.6.130.0100.05020.93
5.6.120.0070.06020.92
5.6.110.0070.06020.98
5.6.100.0030.06020.75
5.6.90.0200.04021.06
5.6.80.0000.05720.39
5.6.70.0070.05020.39
5.6.60.0070.06720.12
5.6.50.0070.05320.42
5.6.40.0000.06020.30
5.6.30.0030.05720.37
5.6.20.0100.05020.29
5.6.10.0030.05320.11
5.6.00.0070.05720.17

preferences:
32.66 ms | 401 KiB | 5 Q