3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = 'SELECT ff.id AS field_id, c.id AS calculation_id, c.answer AS calculation_answer, c.operation AS calculation_operation, c.value AS calculation_value, c.variable AS calculation_variable FROM calculations c RIGHT JOIN form_field ff ON ff.id = c.field_id INNER JOIN form f ON f.id = ff.form_id AND f.id = :form_id'; 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.40.0110.00718.75
8.3.30.0140.00018.95
8.3.20.0030.00520.39
8.3.10.0080.00023.69
8.3.00.0000.00719.05
8.2.170.0070.00722.96
8.2.160.0130.00722.21
8.2.150.0040.00424.18
8.2.140.0070.00024.66
8.2.130.0070.00026.16
8.2.120.0050.00319.54
8.2.110.0150.00020.91
8.2.100.0060.00617.78
8.2.90.0040.00419.51
8.2.80.0040.00417.97
8.2.70.0060.00317.80
8.2.60.0060.00317.97
8.2.50.0000.00818.10
8.2.40.0040.00419.36
8.2.30.0040.00419.15
8.2.20.0000.00717.59
8.2.10.0000.00718.10
8.2.00.0040.00417.56
8.1.270.0120.00318.95
8.1.260.0050.00526.35
8.1.250.0040.00428.09
8.1.240.0030.00620.59
8.1.230.0090.00319.00
8.1.220.0080.00017.74
8.1.210.0040.00418.77
8.1.200.0030.00617.13
8.1.190.0030.00517.30
8.1.180.0060.00318.10
8.1.170.0000.00820.68
8.1.160.0070.00018.94
8.1.150.0050.00218.69
8.1.140.0050.00317.42
8.1.130.0030.00317.73
8.1.120.0040.00417.33
8.1.110.0040.00417.27
8.1.100.0000.00717.35
8.1.90.0040.00417.43
8.1.80.0070.00017.42
8.1.70.0030.00317.30
8.1.60.0040.00417.50
8.1.50.0050.00317.35
8.1.40.0000.00817.45
8.1.30.0030.00617.61
8.1.20.0000.00817.56
8.1.10.0050.00317.56
8.1.00.0040.00417.33
8.0.300.0040.00421.96
8.0.290.0000.00716.88
8.0.280.0030.00318.45
8.0.270.0030.00317.20
8.0.260.0070.00017.29
8.0.250.0050.00216.87
8.0.240.0000.00816.94
8.0.230.0070.00016.82
8.0.220.0030.00316.74
8.0.210.0040.00416.72
8.0.200.0000.00716.93
8.0.190.0050.00316.89
8.0.180.0000.00816.83
8.0.170.0030.00516.89
8.0.160.0000.00716.73
8.0.150.0080.00316.75
8.0.140.0040.00416.75
8.0.130.0050.00013.25
8.0.120.0030.00516.66
8.0.110.0040.00416.75
8.0.100.0000.00716.64
8.0.90.0050.00216.72
8.0.80.0090.00616.75
8.0.70.0000.00716.63
8.0.60.0040.00416.61
8.0.50.0030.00516.70
8.0.30.0090.01016.87
8.0.20.0060.01217.40
8.0.10.0000.00717.06
8.0.00.0080.01016.72
7.4.330.0020.00215.14
7.4.320.0060.00016.54
7.4.300.0030.00316.44
7.4.290.0040.00416.37
7.4.280.0040.00416.40
7.4.270.0000.00816.38
7.4.260.0070.00316.32
7.4.250.0070.00016.51
7.4.240.0020.00616.42
7.4.230.0030.00316.63
7.4.220.0140.00616.64
7.4.210.0140.00716.39
7.4.200.0070.00016.55
7.4.160.0110.00716.30
7.4.150.0100.01017.40
7.4.140.0120.00817.86
7.4.130.0160.00316.50
7.4.120.0130.00616.42
7.4.110.0170.00616.43
7.4.100.0090.00916.36
7.4.90.0060.01016.46
7.4.80.0110.00719.39
7.4.70.0120.00916.38
7.4.60.0100.00716.36
7.4.50.0040.00416.36
7.4.40.0050.01316.56
7.4.30.0120.00316.37
7.4.00.0060.01114.91
7.3.330.0030.00313.04
7.3.320.0020.00213.08
7.3.310.0000.00716.29
7.3.300.0030.00316.04
7.3.290.0080.00716.23
7.3.280.0100.00916.17
7.3.270.0150.00317.40
7.3.260.0090.01116.16
7.3.250.0120.00416.33
7.3.240.0030.01316.13
7.3.230.0060.00916.39
7.3.210.0060.01016.25
7.3.200.0100.00719.39
7.3.190.0030.01416.37
7.3.180.0060.01016.22
7.3.170.0060.01516.38
7.3.160.0130.00316.23
7.2.330.0070.01116.64
7.2.320.0100.00716.54
7.2.310.0100.00716.17
7.2.300.0140.00516.64
7.2.290.0030.01416.56
7.2.00.0070.00319.25
7.1.100.0040.00718.00
7.1.70.0030.00616.79
7.1.60.0100.01419.22
7.1.50.0070.01016.23
7.1.00.0070.07322.54
7.0.200.0030.00316.62
7.0.140.0030.05721.96
7.0.60.0070.04019.94
7.0.50.0000.04317.89
7.0.40.0170.08020.05
7.0.30.0200.08720.00
7.0.20.0270.05020.12
7.0.10.0100.05720.04
7.0.00.0130.04320.16
5.6.210.0030.04020.56
5.6.200.0100.03718.11
5.6.190.0100.04020.35
5.6.180.0270.05720.41
5.6.170.0200.04720.71
5.6.160.0100.03720.49
5.6.150.0100.05718.16
5.6.140.0130.07018.18
5.6.130.0100.03318.22
5.6.120.0100.07721.09
5.6.110.0130.08020.98
5.6.100.0070.07721.00
5.6.90.0000.04721.12
5.6.80.0100.06020.41
5.5.350.0300.06720.40
5.5.340.0000.05017.99
5.5.330.0070.05020.22
5.5.320.0200.08020.32
5.5.310.0230.08020.41
5.5.300.0130.07017.89
5.5.290.0030.04018.01
5.5.280.0070.05320.68
5.5.270.0100.07720.63
5.5.260.0070.04720.72
5.5.250.0070.08020.68
5.5.240.0100.07020.25
5.4.450.0300.05319.52
5.4.440.0730.07319.66
5.4.430.0600.05719.54
5.4.420.0600.06719.55
5.4.410.0770.05719.51
5.4.400.0700.05019.05
5.4.390.0470.05318.84
5.4.380.0300.05318.70
5.4.370.0330.04318.77
5.4.360.0200.05018.65
5.4.350.0230.07318.69
5.4.340.0230.05318.70
5.4.320.0130.06718.61
5.4.310.0200.05318.46
5.4.300.0230.05018.62
5.4.290.0330.04018.47
5.4.280.0300.06318.49
5.4.270.0200.06318.61
5.4.260.0230.05018.52
5.4.250.0270.05718.58
5.4.240.0230.06018.62
5.4.230.0330.05318.68
5.4.220.0370.06018.64
5.4.210.0230.06318.51
5.4.200.0200.07316.48
5.4.190.0230.05318.50
5.4.180.0300.04718.69
5.4.170.0200.06018.48
5.4.160.0330.05318.59
5.4.150.0230.06318.56
5.4.140.0230.04716.05
5.4.130.0130.05716.13
5.4.120.0170.05016.19
5.4.110.0230.04316.08
5.4.100.0030.06716.05
5.4.90.0300.04016.16
5.4.80.0170.05016.24
5.4.70.0230.06716.32
5.4.60.0230.04716.20
5.4.50.0130.05316.08
5.4.40.0170.05316.09
5.4.30.0170.05316.16
5.4.20.0170.05016.08
5.4.10.0200.05016.21
5.4.00.0270.04015.61
5.3.290.0270.06314.76
5.3.280.0430.04014.63
5.3.270.0170.06014.59
5.3.260.0200.08014.59
5.3.250.0300.04314.57
5.3.240.0170.06714.58
5.3.230.0170.06014.58
5.3.220.0370.03714.61
5.3.210.0070.07314.56
5.3.200.0130.08014.47
5.3.190.0130.05714.59
5.3.180.0230.04714.65
5.3.170.0270.04314.54
5.3.160.0130.06014.66
5.3.150.0270.04714.63
5.3.140.0130.06014.48
5.3.130.0300.04714.52
5.3.120.0230.05314.64
5.3.110.0170.05714.63
5.3.100.0270.05014.01
5.3.90.0230.06313.93
5.3.80.0170.05313.95
5.3.70.0230.05013.95
5.3.60.0230.04713.98
5.3.50.0230.05013.86
5.3.40.0230.04713.88
5.3.30.0300.03713.85
5.3.20.0230.04313.66
5.3.10.0130.07313.63
5.3.00.0170.05313.63
5.2.170.0100.04711.14
5.2.160.0270.05011.11
5.2.150.0230.03711.11
5.2.140.0200.04011.29
5.2.130.0100.04311.10
5.2.120.0270.03011.10
5.2.110.0200.04011.14
5.2.100.0100.04311.14
5.2.90.0170.04011.03
5.2.80.0200.04711.17
5.2.70.0130.04311.08
5.2.60.0300.03711.07
5.2.50.0030.05311.04
5.2.40.0270.04010.99
5.2.30.0130.04310.94
5.2.20.0130.04310.95
5.2.10.0230.03710.83
5.2.00.0230.03310.73
5.1.60.0230.02710.05
5.1.50.0170.0379.98
5.1.40.0070.0579.98
5.1.30.0170.03310.32
5.1.20.0130.05010.41
5.1.10.0100.05010.20
5.1.00.0200.03310.13
5.0.50.0170.0278.68
5.0.40.0100.0308.50
5.0.30.0200.0378.25
5.0.20.0030.0338.41
5.0.10.0130.0308.20
5.0.00.0130.0438.20
4.4.90.0000.0306.74
4.4.80.0100.0206.74
4.4.70.0130.0236.74
4.4.60.0130.0176.74
4.4.50.0100.0276.74
4.4.40.0170.0406.74
4.4.30.0030.0306.74
4.4.20.0030.0306.74
4.4.10.0130.0236.74
4.4.00.0100.0336.74
4.3.110.0070.0236.74
4.3.100.0030.0236.74
4.3.90.0130.0206.74
4.3.80.0100.0336.74
4.3.70.0070.0206.74
4.3.60.0030.0276.74
4.3.50.0070.0306.74
4.3.40.0030.0476.74
4.3.30.0070.0236.74
4.3.20.0030.0276.74
4.3.10.0070.0206.74
4.3.00.0030.0207.59

preferences:
46.24 ms | 400 KiB | 5 Q