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.70.0150.00016.38
8.3.60.0090.00916.25
8.3.50.0150.00721.10
8.3.40.0090.00918.50
8.3.30.0070.00718.68
8.3.20.0040.00418.87
8.3.10.0040.00421.71
8.3.00.0030.00719.18
8.2.190.0080.00816.58
8.2.180.0090.00618.18
8.2.170.0120.00322.96
8.2.160.0030.01020.35
8.2.150.0070.01124.18
8.2.140.0000.00824.66
8.2.130.0000.00719.77
8.2.120.0070.00026.35
8.2.110.0050.00320.29
8.2.100.0040.00819.51
8.2.90.0040.00417.63
8.2.80.0090.00018.70
8.2.70.0080.00017.93
8.2.60.0030.00517.93
8.2.50.0040.00418.10
8.2.40.0000.00720.45
8.2.30.0040.00419.18
8.2.20.0020.00517.90
8.2.10.0040.00418.10
8.2.00.0050.00317.50
8.1.280.0030.01425.92
8.1.270.0060.00323.79
8.1.260.0040.00428.09
8.1.250.0040.00428.09
8.1.240.0030.00623.79
8.1.230.0080.00321.03
8.1.220.0050.00317.74
8.1.210.0030.00518.77
8.1.200.0030.00517.13
8.1.190.0060.00317.22
8.1.180.0050.00318.10
8.1.170.0000.00818.59
8.1.160.0030.00618.84
8.1.150.0080.00018.45
8.1.140.0000.00719.57
8.1.130.0030.00317.59
8.1.120.0040.00417.45
8.1.110.0000.00817.38
8.1.100.0050.00317.35
8.1.90.0070.00017.43
8.1.80.0040.00417.29
8.1.70.0030.00317.39
8.1.60.0000.00717.47
8.1.50.0050.00317.49
8.1.40.0070.00317.41
8.1.30.0060.00317.59
8.1.20.0070.00017.61
8.1.10.0050.00317.45
8.1.00.0030.00617.27
8.0.300.0000.00718.77
8.0.290.0030.00616.87
8.0.280.0000.00718.38
8.0.270.0040.00417.20
8.0.260.0030.00317.08
8.0.250.0000.00716.98
8.0.240.0030.00516.95
8.0.230.0040.00316.94
8.0.220.0000.00916.89
8.0.210.0000.00716.91
8.0.200.0030.00316.94
8.0.190.0060.00616.95
8.0.180.0030.00616.77
8.0.170.0050.00316.90
8.0.160.0030.00516.93
8.0.150.0050.00216.67
8.0.140.0000.00816.85
8.0.130.0080.00013.36
8.0.120.0050.00216.91
8.0.110.0000.00716.76
8.0.100.0000.00816.83
8.0.90.0040.00416.76
8.0.80.0040.01116.77
8.0.70.0040.00416.72
8.0.60.0000.00816.77
8.0.50.0040.00416.73
8.0.30.0110.00716.91
8.0.20.0130.00817.40
8.0.10.0040.00416.85
8.0.00.0090.00916.80
7.4.330.0030.00315.55
7.4.320.0000.00716.54
7.4.300.0000.00616.34
7.4.290.0000.00716.38
7.4.280.0040.00416.35
7.4.270.0040.00416.44
7.4.260.0110.00016.56
7.4.250.0040.00416.44
7.4.240.0070.00016.46
7.4.230.0050.00216.24
7.4.220.0050.00316.61
7.4.210.0140.00316.52
7.4.200.0000.00716.33
7.4.160.0060.00916.42
7.4.150.0030.01317.40
7.4.140.0110.00617.86
7.4.130.0120.00716.41
7.4.120.0100.00716.45
7.4.110.0120.00616.59
7.4.100.0070.01016.52
7.4.90.0130.01016.38
7.4.80.0060.01119.39
7.4.70.0080.00816.57
7.4.60.0160.00016.54
7.4.50.0000.01416.18
7.4.40.0110.00516.51
7.4.30.0030.01716.51
7.4.00.0000.01315.09
7.3.330.0050.00012.91
7.3.320.0000.00613.12
7.3.310.0000.00716.10
7.3.300.0030.00316.22
7.3.290.0090.00616.19
7.3.280.0110.00716.21
7.3.270.0080.00817.40
7.3.260.0060.01116.24
7.3.250.0110.00716.23
7.3.240.0120.00616.24
7.3.230.0120.00616.52
7.3.210.0040.01216.30
7.3.200.0100.01016.30
7.3.190.0060.01116.50
7.3.180.0030.01316.38
7.3.170.0100.00716.20
7.3.160.0090.00916.26
7.3.10.0090.00616.63
7.3.00.0070.00716.57
7.2.330.0100.00816.35
7.2.320.0130.00916.35
7.2.310.0060.00916.48
7.2.300.0170.00616.34
7.2.290.0120.00616.36
7.2.130.0060.00316.43
7.2.120.0110.00716.61
7.2.110.0030.01416.65
7.2.100.0130.00316.31
7.2.90.0110.00716.81
7.2.80.0160.00316.56
7.2.70.0030.01616.71
7.2.60.0140.00516.54
7.2.50.0070.00416.38
7.2.40.0080.00816.77
7.2.30.0060.00916.68
7.2.20.0060.00916.75
7.2.10.0070.00716.64
7.2.00.0080.00816.50
7.1.250.0000.01515.64
7.1.200.0040.00715.83
7.1.70.0040.00416.95
7.1.60.0160.00317.31
7.1.00.0030.07322.31
7.0.200.0600.00714.45
7.0.130.0070.06322.05
7.0.120.0070.08322.05
7.0.110.0030.06022.08
7.0.100.0100.05322.12
7.0.90.0130.05022.14
7.0.80.0000.06322.03
7.0.70.0030.06322.14
7.0.60.0130.05022.02
7.0.50.0070.08022.13
7.0.40.0000.06322.07
7.0.30.0130.06722.03
7.0.20.0070.06022.09
7.0.10.0070.07322.12
7.0.00.0030.07722.11
5.6.280.0030.06720.88
5.6.270.0070.08320.85
5.6.260.0130.04721.04
5.6.250.0030.05720.85
5.6.240.0030.06020.81
5.6.230.0030.06020.80
5.6.220.0100.05020.98
5.6.210.0170.04720.96
5.6.200.0230.06020.86
5.6.190.0130.05320.85
5.6.180.0100.07021.01
5.6.170.0230.05721.00
5.6.160.0100.05320.86
5.6.150.0070.06020.83
5.6.140.0130.05721.08
5.6.130.0030.06320.80
5.6.120.0070.06320.93
5.6.110.0130.06021.00
5.6.100.0170.05020.98
5.6.90.0200.05020.84
5.6.80.0130.05020.21
5.6.70.0200.04320.36
5.6.60.0100.05320.36
5.6.50.0130.05020.23
5.6.40.0130.05020.29
5.6.30.0070.05720.32
5.6.20.0100.05720.37
5.6.10.0100.05720.41
5.6.00.0100.05320.35

preferences:
72.23 ms | 401 KiB | 5 Q