3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = "select ex.opening_minutes as opening, asset.assetID, ex.google_code as exch_google_code, asset.google_code as asset_google_code from selected_asset as sa". " inner join asset on asset.assetID = sa.assetID". " inner join asset_exchange ae on ae.assetID = sa.assetID". " inner join exchange as ex on ex.exchangeID = ae.exchangeID". " where ae.exchangeID = ".$exchangeID." and sa.brokerID = ".$brokerID; $extension = ""; if ($result = mysqli_query($this->db, $sql) ) { while ($rec = $result->fetch_assoc()){ $asset_google_code = $rec["asset_google_code"]; $exchange_google_code = $rec["exch_google_code"]; $assetentry = array ( $rec["assetID"] => $asset_google_code ); $this->assets[] = $assetentry; $extension .= trim($exchange_google_code) .":".$asset_google_code.","; } } //$extension = rtrim($extension, ","); $extension .= "'"; $sql = "select ex.opening_minutes as opening from exchange as ex where ex.exchangeID = ".$exchangeID; if ($result = mysqli_query($this->db, $sql) ) { while ($rec = $result->fetch_assoc()){ $this->opening_minutes = "+" . $rec["opening"]." minutes"; } } $this->closetime = $this->opening->modify ($this->opening_minutes); $this->closetime = $this->closetime->format( "Y-m-d H:i:s");

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.0060.00916.88
8.3.50.0060.00822.00
8.3.40.0150.00318.87
8.3.30.0070.00719.08
8.3.20.0040.00420.34
8.3.10.0040.00423.61
8.3.00.0060.00319.25
8.2.180.0070.01118.43
8.2.170.0100.01022.96
8.2.160.0180.00320.39
8.2.150.0070.00024.18
8.2.140.0030.00524.66
8.2.130.0050.00326.16
8.2.120.0140.00021.91
8.2.110.0100.00720.21
8.2.100.0060.00617.72
8.2.90.0030.00519.09
8.2.80.0040.00417.97
8.2.70.0050.00317.63
8.2.60.0080.00018.04
8.2.50.0080.00018.07
8.2.40.0040.00419.93
8.2.30.0030.00518.16
8.2.20.0040.00417.86
8.2.10.0000.00718.04
8.2.00.0050.00217.88
8.1.280.0000.01525.92
8.1.270.0050.00323.96
8.1.260.0090.00026.35
8.1.250.0050.00328.09
8.1.240.0030.00622.13
8.1.230.0060.00620.91
8.1.220.0000.00917.74
8.1.210.0000.00818.77
8.1.200.0110.00217.35
8.1.190.0050.00317.23
8.1.180.0000.00818.10
8.1.170.0030.00618.43
8.1.160.0040.00422.10
8.1.150.0040.00418.68
8.1.140.0050.00217.49
8.1.130.0070.00017.80
8.1.120.0000.00717.42
8.1.110.0020.00517.39
8.1.100.0040.00417.49
8.1.90.0040.00417.40
8.1.80.0040.00317.50
8.1.70.0030.00317.50
8.1.60.0000.00917.68
8.1.50.0040.00417.50
8.1.40.0000.00717.56
8.1.30.0030.00617.59
8.1.20.0000.00917.71
8.1.10.0040.00417.51
8.1.00.0040.00417.56
8.0.300.0040.00418.77
8.0.290.0040.00417.00
8.0.280.0030.00418.49
8.0.270.0040.00417.22
8.0.260.0000.00817.22
8.0.250.0040.00417.05
8.0.240.0040.00417.11
8.0.230.0000.00717.02
8.0.220.0080.00016.97
8.0.210.0070.00017.00
8.0.200.0030.00317.10
8.0.190.0040.00417.01
8.0.180.0040.00417.00
8.0.170.0040.00416.92
8.0.160.0040.00416.88
8.0.150.0030.00317.02
8.0.140.0000.00716.89
8.0.130.0030.00613.36
8.0.120.0040.00416.94
8.0.110.0060.00316.97
8.0.100.0000.00716.86
8.0.90.0000.00717.06
8.0.80.0030.01317.01
8.0.70.0050.00216.84
8.0.60.0040.00417.05
8.0.50.0040.00416.90
8.0.30.0110.00817.14
8.0.20.0110.00817.40
8.0.10.0040.00417.09
8.0.00.0110.00716.91
7.4.330.0050.00015.09
7.4.320.0000.00716.45
7.4.300.0030.00316.60
7.4.290.0030.00316.68
7.4.280.0030.00616.54
7.4.270.0070.00016.66
7.4.260.0040.00416.44
7.4.250.0040.00416.66
7.4.240.0020.00516.58
7.4.230.0030.00316.68
7.4.220.0070.01116.75
7.4.210.0080.00716.69
7.4.200.0040.00416.64
7.4.190.0070.00016.79
7.4.160.0130.00316.63
7.4.150.0100.00617.40
7.4.140.0050.01617.86
7.4.130.0090.00916.58
7.4.120.0120.00516.52
7.4.110.0070.01016.54
7.4.100.0070.01116.66
7.4.90.0110.00716.64
7.4.80.0120.01019.39
7.4.70.0080.00816.53
7.4.60.0100.01016.50
7.4.50.0050.00316.74
7.4.40.0090.00916.45
7.4.30.0110.00816.70
7.4.10.0110.00714.75
7.4.00.0080.00915.01
7.3.330.0000.00513.08
7.3.320.0000.00713.31
7.3.310.0040.00416.34
7.3.300.0000.00716.34
7.3.290.0050.00816.37
7.3.280.0070.01216.37
7.3.270.0060.01017.40
7.3.260.0150.00716.41
7.3.250.0050.01416.50
7.3.240.0090.01316.65
7.3.230.0160.00416.44
7.3.210.0170.00016.29
7.3.200.0070.01019.39
7.3.190.0070.01416.33
7.3.180.0070.00916.41
7.3.170.0170.00016.36
7.3.160.0190.00316.63
7.3.130.0120.00414.62
7.3.120.0090.00714.87
7.3.110.0050.01114.90
7.3.100.0050.01014.99
7.3.90.0020.00914.72
7.3.80.0060.00714.89
7.3.70.0020.01014.85
7.3.60.0110.00514.79
7.3.50.0020.01314.76
7.3.40.0070.00714.88
7.3.30.0090.00714.75
7.3.20.0070.00816.57
7.3.10.0020.00816.42
7.3.00.0040.00916.41
7.2.330.0080.01616.75
7.2.320.0030.01416.35
7.2.310.0070.01416.33
7.2.300.0090.01216.32
7.2.290.0060.01116.80
7.2.260.0060.00914.62
7.2.250.0090.00914.99
7.2.240.0050.01214.77
7.2.230.0090.00814.75
7.2.220.0030.00915.01
7.2.210.0050.00815.04
7.2.200.0030.00814.78
7.2.190.0030.01014.81
7.2.180.0000.01015.05
7.2.170.0020.01414.84
7.2.160.0040.01115.05
7.2.150.0060.01016.90
7.2.140.0110.00716.78
7.2.130.0120.00616.85
7.2.120.0060.00616.86
7.2.110.0120.00016.66
7.2.100.0110.00016.71
7.2.90.0100.00316.85
7.2.80.0040.01116.86
7.2.70.0060.00916.86
7.2.60.0040.01216.82
7.2.50.0060.00616.58
7.2.40.0060.00616.77
7.2.30.0080.00416.73
7.2.20.0030.01016.84
7.2.10.0080.00816.88
7.2.00.0030.01318.02
7.1.330.0060.00915.84
7.1.320.0030.00615.67
7.1.310.0020.01115.65
7.1.300.0030.00515.43
7.1.290.0080.00515.59
7.1.280.0050.00915.69
7.1.270.0050.01115.67
7.1.260.0050.00915.46
7.1.250.0060.00915.49
7.1.240.0030.01015.29
7.1.230.0070.00315.46
7.1.220.0070.00715.55
7.1.210.0060.00715.66
7.1.200.0110.00215.65
7.1.190.0030.00615.59
7.1.180.0030.00915.77
7.1.170.0070.01015.60
7.1.160.0040.00415.48
7.1.150.0110.00415.66
7.1.140.0030.00815.55
7.1.130.0030.00715.50
7.1.120.0090.00315.75
7.1.110.0000.01415.59
7.1.100.0000.00916.81
7.1.90.0100.00415.47
7.1.80.0050.00515.47
7.1.70.0030.00816.46
7.1.60.0040.01517.55
7.1.50.0100.00916.15
7.1.40.0030.01015.71
7.1.30.0030.01015.32
7.1.20.0070.00315.81
7.1.10.0030.00815.67
7.1.00.0020.04519.08
7.0.330.0070.01015.46
7.0.320.0030.01315.38
7.0.310.0060.00615.49
7.0.300.0030.01215.37
7.0.290.0040.00715.19
7.0.280.0040.00815.44
7.0.270.0100.00315.19
7.0.260.0040.00715.33
7.0.250.0030.00815.33
7.0.240.0100.00315.36
7.0.230.0060.00915.15
7.0.220.0000.01115.50
7.0.210.0030.01115.02
7.0.200.0020.00815.90
7.0.190.0040.00815.27
7.0.180.0110.00415.21
7.0.170.0070.01015.32
7.0.160.0040.00715.49
7.0.150.0060.00315.27
7.0.140.0030.03918.63
7.0.130.0070.00415.31
7.0.120.0050.00515.17
7.0.110.0000.01315.41
7.0.100.0100.00315.36
7.0.90.0000.00815.36
7.0.80.0000.01615.07
7.0.70.0090.00915.32
7.0.60.0080.03017.60
7.0.50.0060.03816.68
7.0.40.0100.04016.88
7.0.30.0190.03116.69
7.0.20.0170.02716.78
7.0.10.0100.03416.73
7.0.00.0070.02316.73
5.6.400.0090.00613.79
5.6.390.0040.00714.20
5.6.380.0030.00714.00
5.6.370.0030.01214.05
5.6.360.0070.00714.04
5.6.350.0060.00613.93
5.6.340.0070.00414.27
5.6.330.0030.00714.47
5.6.320.0090.00313.89
5.6.310.0100.00314.12
5.6.300.0120.00314.11
5.6.290.0070.01014.34
5.6.280.0050.03817.34
5.6.270.0060.00614.01
5.6.260.0000.01113.94
5.6.250.0030.01014.31
5.6.240.0030.01114.25
5.6.230.0040.01414.00
5.6.220.0070.01114.04
5.6.210.0060.03117.32
5.6.200.0060.03016.18
5.6.190.0070.02917.29
5.6.180.0220.03517.54
5.6.170.0120.02317.38
5.6.160.0050.02517.27
5.6.150.0110.03616.26
5.6.140.0070.02316.18
5.6.130.0010.03116.19
5.6.120.0030.04717.54
5.6.110.0050.04617.52
5.6.100.0050.04717.42
5.6.90.0030.04817.67
5.6.80.0050.04717.32
5.6.70.0070.00014.04
5.6.60.0060.00614.20
5.6.50.0030.00714.38
5.6.40.0080.00413.91
5.6.30.0070.00714.01
5.6.20.0040.00713.96
5.6.10.0070.00714.03
5.6.00.0100.00314.13
5.5.380.0070.00414.08
5.5.370.0100.01013.92
5.5.360.0140.00014.08
5.5.350.0100.04117.14
5.5.340.0070.02516.11
5.5.330.0100.03217.29
5.5.320.0170.04317.18
5.5.310.0230.03017.22
5.5.300.0040.04916.03
5.5.290.0070.04516.05
5.5.280.0030.03217.29
5.5.270.0040.02417.58
5.5.260.0080.03317.54
5.5.250.0050.03917.28
5.5.240.0050.04217.21
5.5.230.0030.01013.72
5.5.220.0030.00913.91
5.5.210.0030.00614.18
5.5.200.0110.00413.78
5.5.190.0000.01313.85
5.5.180.0100.00413.84
5.5.170.0050.00514.05
5.5.160.0030.00913.89
5.5.150.0030.00913.91
5.5.140.0130.00313.94
5.5.130.0100.00314.13
5.5.120.0040.01214.17
5.5.110.0060.00614.30
5.5.100.0070.00713.80
5.5.90.0120.00314.17
5.5.80.0040.01114.11
5.5.70.0070.01014.22
5.5.60.0050.00513.93
5.5.50.0030.00613.62
5.5.40.0050.00913.72
5.5.30.0090.00614.21
5.5.20.0070.00313.88
5.5.10.0030.01013.72
5.5.00.0040.00713.98
5.4.450.0080.02815.15
5.4.440.0280.03515.17
5.4.430.0370.03015.26
5.4.420.0430.00515.18
5.4.410.0130.02814.98
5.4.400.0030.03914.81
5.4.390.0100.02914.73
5.4.380.0080.03614.63
5.4.370.0130.01814.81
5.4.360.0070.02214.69
5.4.350.0080.01911.26
5.4.340.0040.02511.39
5.4.330.0030.00710.86
5.4.320.0060.02011.68
5.4.310.0100.02611.61
5.4.300.0060.02211.61
5.4.290.0130.03211.56
5.4.280.0040.02511.61
5.4.270.0020.03111.45
5.4.260.0070.02111.55
5.4.250.0040.02211.56
5.4.240.0060.02311.50
5.4.230.0040.02711.43
5.4.220.0050.02011.56
5.4.210.0070.01911.60
5.4.200.0050.02211.59
5.4.190.0040.02911.57
5.4.180.0070.02011.47
5.4.170.0060.02311.62
5.4.160.0040.02111.66
5.4.150.0060.01911.58
5.4.140.0060.02011.51
5.4.130.0060.02011.44
5.4.120.0080.02911.42
5.4.110.0110.02111.42
5.4.100.0020.02411.41
5.4.90.0050.02611.33
5.4.80.0050.02711.32
5.4.70.0050.02511.39
5.4.60.0050.02411.32
5.4.50.0050.02211.39
5.4.40.0040.02211.37
5.4.30.0050.02011.38
5.4.20.0050.02311.33
5.4.10.0050.03011.43
5.4.00.0080.02611.13
5.3.290.0020.02411.65
5.3.280.0080.02511.48
5.3.270.0050.02811.52
5.3.260.0040.02911.63
5.3.250.0090.01911.59
5.3.240.0070.02811.53
5.3.230.0050.03011.57
5.3.220.0070.01911.51
5.3.210.0060.02211.38
5.3.200.0020.02511.52
5.3.190.0070.02611.41
5.3.180.0040.03011.52
5.3.170.0050.05511.57
5.3.160.0050.04111.47
5.3.150.0090.02911.61
5.3.140.0060.03411.46
5.3.130.0150.04511.53
5.3.120.0050.03211.52
5.3.110.0100.02911.49
5.3.100.0040.02811.25
5.3.90.0060.03411.26
5.3.80.0060.02911.24
5.3.70.0060.03111.14
5.3.60.0070.02611.20
5.3.50.0050.02211.18
5.3.40.0060.02911.12
5.3.30.0120.02711.15
5.3.20.0040.03611.01
5.3.10.0060.02110.89
5.3.00.0070.02810.92
5.2.170.0030.0489.20
5.2.160.0030.0459.20
5.2.150.0080.0329.20
5.2.140.0080.0429.19
5.2.130.0060.0429.16
5.2.120.0070.0549.16
5.2.110.0030.0439.16
5.2.100.0020.0389.16
5.2.90.0040.0319.16
5.2.80.0030.0349.16
5.2.70.0060.0349.16
5.2.60.0060.0359.11
5.2.50.0060.0489.08
5.2.40.0060.0419.05
5.2.30.0040.0329.03
5.2.20.0040.0339.02
5.2.10.0040.0338.94
5.2.00.0090.0318.80
5.1.60.0060.0268.09
5.1.50.0040.0248.08
5.1.40.0020.0268.06
5.1.30.0030.0278.41
5.1.20.0040.0278.43
5.1.10.0050.0308.16
5.1.00.0050.0358.16
5.0.50.0040.0256.64
5.0.40.0050.0206.50
5.0.30.0030.0366.31
5.0.20.0070.0276.28
5.0.10.0090.0316.26
5.0.00.0060.0326.25
4.4.90.0030.0164.78
4.4.80.0010.0184.75
4.4.70.0020.0204.75
4.4.60.0030.0164.76
4.4.50.0010.0194.77
4.4.40.0030.0284.71
4.4.30.0070.0284.76
4.4.20.0040.0204.85
4.4.10.0030.0214.85
4.4.00.0050.0274.76
4.3.110.0030.0164.67
4.3.100.0020.0174.67
4.3.90.0030.0174.63
4.3.80.0050.0394.59
4.3.70.0110.0244.63
4.3.60.0030.0194.63
4.3.50.0050.0184.63
4.3.40.0020.0304.54
4.3.30.0020.0173.30
4.3.20.0010.0173.28
4.3.10.0050.0143.23
4.3.00.0000.0236.70

preferences:
45.81 ms | 401 KiB | 5 Q