3v4l.org

run code in 300+ PHP versions simultaneously
<?php print_r(wordwrap('SELECT DISTINCT posting FROM \Common\Model\Entity\Posting posting WHERE posting.id = (SELECT max(subposting.id) FROM \Common\Model\Entity\Posting subposting INNER JOIN subposting.playlistPosting playlistPosting INNER JOIN playlistPosting.playlist playlist INNER JOIN subposting.postingLiveFeatures postingLiveFeatures LEFT JOIN subposting.video video LEFT JOIN subposting.audio audio LEFT JOIN subposting.pdf pdf WHERE posting.studio=:currentStudio AND playlist.id = 1 AND subposting.isOnPlayer = 1 AND playlist.isOn = 1 AND playlist.type = 1 AND ((subposting.isVideoPlayer = 1 and video.mediaPath is not null) or (subposting.isAudioPlayer = 1 and audio.mediaPath is not null) or (subposting.isPdf = 1 and pdf.inProgress = 0) or (postingLiveFeatures.isOn = 1)))'));

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.0000.01618.56
8.3.50.0230.00521.20
8.3.40.0070.00718.57
8.3.30.0190.00020.20
8.3.20.0040.00420.38
8.3.10.0080.00020.83
8.3.00.0070.00022.46
8.2.180.0120.00316.50
8.2.170.0140.00422.96
8.2.160.0060.00922.08
8.2.150.0040.00424.18
8.2.140.0080.00024.66
8.2.130.0040.00426.16
8.2.120.0000.00720.66
8.2.110.0030.00721.12
8.2.100.0040.00817.78
8.2.90.0000.00719.09
8.2.80.0000.00817.97
8.2.70.0080.00017.38
8.2.60.0030.00617.93
8.2.50.0040.00418.07
8.2.40.0050.00318.03
8.2.30.0040.00419.41
8.2.20.0050.00317.55
8.2.10.0050.00317.55
8.2.00.0040.00417.40
8.1.280.0090.00625.92
8.1.270.0000.00723.99
8.1.260.0040.00426.35
8.1.250.0000.00728.09
8.1.240.0050.00521.19
8.1.230.0000.01117.42
8.1.220.0080.00017.74
8.1.210.0040.00418.77
8.1.200.0030.00717.10
8.1.190.0000.00817.11
8.1.180.0040.00418.10
8.1.170.0030.00618.59
8.1.160.0070.00018.75
8.1.150.0050.00218.42
8.1.140.0000.00817.30
8.1.130.0000.00717.75
8.1.120.0050.00217.23
8.1.110.0000.00717.26
8.1.100.0000.00717.38
8.1.90.0070.00017.30
8.1.80.0000.00817.23
8.1.70.0000.00717.33
8.1.60.0030.00617.48
8.1.50.0000.00717.37
8.1.40.0080.00017.29
8.1.30.0070.00017.48
8.1.20.0080.00017.42
8.1.10.0040.00417.38
8.1.00.0050.00217.22
8.0.300.0070.00018.77
8.0.290.0070.00316.63
8.0.280.0000.00818.29
8.0.270.0000.00717.16
8.0.260.0000.00716.56
8.0.250.0000.00816.82
8.0.240.0040.00416.82
8.0.230.0030.00516.73
8.0.220.0000.00716.75
8.0.210.0000.00716.78
8.0.200.0060.00016.68
8.0.190.0070.00016.71
8.0.180.0070.00016.71
8.0.170.0000.00816.80
8.0.160.0070.00016.81
8.0.150.0030.00316.65
8.0.140.0090.00316.76
8.0.130.0030.00313.17
8.0.120.0000.00816.72
8.0.110.0000.00716.74
8.0.100.0040.00416.58
8.0.90.0000.00716.71
8.0.80.0090.00616.74
8.0.70.0070.00016.80
8.0.60.0040.00416.65
8.0.50.0070.00016.61
8.0.30.0110.00916.89
8.0.20.0080.01117.40
8.0.10.0000.00716.68
8.0.00.0150.00416.63
7.4.330.0020.00216.77
7.4.320.0030.00316.36
7.4.300.0000.00616.33
7.4.290.0070.00016.22
7.4.280.0000.00716.42
7.4.270.0030.00316.47
7.4.260.0050.00013.08
7.4.250.0000.00716.32
7.4.240.0040.00316.45
7.4.230.0070.00016.54
7.4.220.0060.01216.50
7.4.210.0050.01016.37
7.4.200.0070.00016.57
7.4.190.0000.00716.55
7.4.160.0080.00816.38
7.4.150.0060.01617.40
7.4.140.0080.01117.86
7.4.130.0120.00716.35
7.4.120.0120.00716.43
7.4.110.0070.01016.25
7.4.100.0090.00916.45
7.4.90.0090.00916.38
7.4.80.0090.00919.39
7.4.70.0100.00716.40
7.4.60.0120.00916.23
7.4.50.0040.00416.32
7.4.40.0030.00922.77
7.4.30.0120.00616.26
7.4.00.0100.00614.82
7.3.330.0000.00612.97
7.3.320.0020.00212.93
7.3.310.0000.00616.05
7.3.300.0030.00316.12
7.3.290.0100.00716.11
7.3.280.0120.00616.14
7.3.270.0130.00717.40
7.3.260.0130.00618.24
7.3.250.0110.00916.32
7.3.240.0030.01316.17
7.3.230.0030.01516.40
7.3.210.0100.01016.44
7.3.200.0140.00319.39
7.3.190.0110.00616.20
7.3.180.0060.01016.42
7.3.170.0070.00816.43
7.3.160.0090.01316.10
7.3.120.0090.00814.72
7.3.110.0040.01014.72
7.3.100.0070.00914.39
7.3.90.0050.00814.66
7.3.80.0000.01214.63
7.3.70.0090.00714.66
7.3.60.0090.00414.54
7.3.50.0060.00714.59
7.3.40.0030.00714.61
7.3.30.0050.00814.57
7.3.20.0050.00816.44
7.3.10.0060.00716.46
7.3.00.0040.00816.52
7.2.330.0000.01816.54
7.2.320.0070.01416.36
7.2.310.0090.00916.23
7.2.300.0060.01216.50
7.2.290.0060.01616.23
7.2.250.0130.00514.86
7.2.240.0090.00814.73
7.2.230.0040.01014.66
7.2.220.0050.01114.96
7.2.210.0060.00814.63
7.2.200.0070.00814.72
7.2.190.0060.00914.95
7.2.180.0070.00914.76
7.2.170.0090.00514.81
7.2.160.0040.01114.65
7.2.150.0000.01316.59
7.2.140.0030.01416.69
7.2.130.0110.00716.73
7.2.120.0060.00916.55
7.2.110.0090.00816.68
7.2.100.0070.00716.71
7.2.90.0100.00616.60
7.2.80.0070.00716.68
7.2.70.0060.00916.54
7.2.60.0130.00316.80
7.2.50.0030.01016.89
7.2.40.0130.00316.88
7.2.30.0030.01316.43
7.2.20.0070.00316.75
7.2.10.0060.00916.63
7.2.00.0050.01118.09
7.1.330.0110.00415.69
7.1.320.0040.00915.58
7.1.310.0070.00815.46
7.1.300.0010.01115.61
7.1.290.0070.00515.62
7.1.280.0060.00815.50
7.1.270.0020.01015.68
7.1.260.0040.01115.51
7.1.250.0130.00615.61
7.1.100.0080.00317.87
7.1.70.0040.00417.13
7.1.60.0100.01019.17
7.1.50.0070.00316.53
7.1.00.0000.05722.35
7.0.200.0030.00316.59
7.0.140.0030.07722.09
7.0.110.0130.04319.96
7.0.100.0130.05019.87
7.0.90.0070.04719.96
7.0.80.0130.07719.89
7.0.70.0130.06320.05
7.0.60.0130.08320.03
7.0.50.0200.04020.05
7.0.40.0170.07019.75
7.0.30.0070.07719.65
7.0.20.0130.07319.88
7.0.10.0130.08019.64
7.0.00.0030.09019.78
5.6.280.0000.07720.98
5.6.260.0030.05720.63
5.6.250.0100.07320.68
5.6.240.0130.03720.71
5.6.230.0070.05020.65
5.6.220.0070.07320.64
5.6.210.0070.04320.57
5.6.200.0100.09320.65
5.6.190.0130.07320.55
5.6.180.0130.03320.57
5.6.170.0300.06320.85
5.6.160.0100.04020.61
5.6.150.0070.05020.65
5.6.140.0000.06020.54
5.6.130.0070.08320.64
5.6.120.0030.09020.64
5.6.110.0030.03720.66
5.6.100.0000.04320.61
5.6.90.0100.04020.44
5.6.80.0030.04719.99
5.6.70.0100.07020.06
5.6.60.0170.07020.07
5.6.50.0070.04720.06
5.6.40.0130.07020.05
5.6.30.0070.03320.05
5.6.20.0130.06020.20
5.6.10.0000.06020.03
5.6.00.0070.04319.99
5.5.380.0100.03717.50
5.5.370.0070.05717.46
5.5.360.0030.04317.38
5.5.350.0130.07717.46
5.5.340.0030.05018.16
5.5.330.0030.08018.00
5.5.320.0070.07018.02
5.5.310.0100.07718.12
5.5.300.0100.06717.89
5.5.290.0030.08317.89
5.5.280.0070.06017.87
5.5.270.0030.05018.12
5.5.260.0030.04017.76
5.5.250.0000.04017.66
5.5.240.0130.07317.64
5.5.230.0030.03717.22
5.5.220.0100.07017.50
5.5.210.0200.07017.46
5.5.200.0070.05717.49
5.5.190.0030.08717.44
5.5.180.0070.07717.34
5.5.160.0070.06717.21
5.5.150.0130.06717.19
5.5.140.0130.06717.47
5.5.130.0070.03017.60
5.5.120.0030.03317.20
5.5.110.0030.04317.25
5.5.100.0100.06717.42
5.5.90.0030.03717.27
5.5.80.0070.03017.37
5.5.70.0000.04017.36
5.5.60.0030.06717.39
5.5.50.0070.07017.33
5.5.40.0000.03717.14
5.5.30.0000.06317.08
5.5.20.0100.07017.36
5.5.10.0000.06717.49
5.5.00.0070.07717.34
5.4.450.0170.07319.45
5.4.440.0070.04019.60
5.4.430.0030.05719.59
5.4.420.0030.06319.59
5.4.410.0000.04319.39
5.4.400.0070.07718.98
5.4.390.0030.07019.18
5.4.380.0070.07718.93
5.4.370.0070.08019.07
5.4.360.0000.08719.18
5.4.350.0100.03019.02
5.4.340.0100.02719.18
5.4.320.0100.06319.03
5.4.310.0070.07319.07
5.4.300.0030.08018.98
5.4.290.0100.07319.03
5.4.280.0130.04019.24
5.4.270.0100.07319.18
5.4.260.0070.08319.10
5.4.250.0070.07318.94
5.4.240.0030.07719.02
5.4.230.0030.08019.09
5.4.220.0170.07019.18
5.4.210.0070.07318.97
5.4.200.0100.07319.23
5.4.190.0070.07319.14
5.4.180.0130.06318.94
5.4.170.0000.04019.17
5.4.160.0130.06318.93
5.4.150.0170.06719.00
5.4.140.0100.05316.26
5.4.130.0100.03716.53
5.4.120.0130.07016.18
5.4.110.0100.06716.28
5.4.100.0070.07716.53
5.4.90.0030.07716.24
5.4.80.0100.07016.51
5.4.70.0070.04016.39
5.4.60.0000.05016.35
5.4.50.0130.03716.23
5.4.40.0000.07316.21
5.4.30.0030.05716.16
5.4.20.0030.05716.34
5.4.10.0100.06316.37
5.4.00.0070.07315.83
5.3.290.0130.07714.59
5.3.280.0000.07714.48
5.3.270.0030.07714.48
5.3.260.0000.05014.54
5.3.250.0070.04014.61
5.3.240.0070.07714.42
5.3.230.0030.04014.51
5.3.220.0130.08014.42
5.3.210.0070.07014.64
5.3.200.0030.07014.57
5.3.190.0030.07714.45
5.3.180.0200.03314.46
5.3.170.0030.06714.46
5.3.160.0030.08014.62
5.3.150.0100.03714.40
5.3.140.0000.07714.44
5.3.130.0070.07714.41
5.3.120.0070.04314.41
5.3.110.0100.04014.44
5.3.100.0070.05013.93
5.3.90.0070.07313.96
5.3.80.0170.05313.95
5.3.70.0100.07014.07
5.3.60.0170.04013.90
5.3.50.0170.06713.77
5.3.40.0070.04013.77
5.3.30.0070.04313.83
5.3.20.0100.07313.61
5.3.10.0100.06313.53
5.3.00.0070.06713.66
5.2.170.0100.03711.84
5.2.160.0000.04011.84
5.2.150.0000.06711.84
5.2.140.0170.05011.84
5.2.130.0130.05311.84
5.2.120.0070.05711.84
5.2.110.0070.05711.84
5.2.100.0100.05311.84
5.2.90.0030.06311.84
5.2.80.0130.03311.84
5.2.70.0070.04711.84
5.2.60.0070.04011.84
5.2.50.0070.06011.84
5.2.40.0030.06311.84
5.2.30.0070.06011.84
5.2.20.0170.04711.84
5.2.10.0030.04311.84
5.2.00.0070.02711.84
5.1.60.0070.04311.84
5.1.50.0070.05311.84
5.1.40.0000.03311.84
5.1.30.0030.03311.84
5.1.20.0030.05711.84
5.1.10.0030.06011.84
5.1.00.0030.05711.84
5.0.50.0030.02711.84
5.0.40.0000.05011.84
5.0.30.0030.05711.84
5.0.20.0030.04011.84
5.0.10.0030.03011.84
5.0.00.0070.05711.84
4.4.90.0000.03711.84
4.4.80.0130.00311.84
4.4.70.0030.04311.84
4.4.60.0000.03311.84
4.4.50.0070.03311.84
4.4.40.0100.04311.84
4.4.30.0000.03711.84
4.4.20.0000.04011.84
4.4.10.0030.03311.84
4.4.00.0030.05311.84
4.3.110.0000.03711.84
4.3.100.0000.03711.84
4.3.90.0000.03011.84
4.3.80.0030.03711.84
4.3.70.0000.01711.84
4.3.60.0000.03011.84
4.3.50.0000.02711.84
4.3.40.0000.05711.84
4.3.30.0070.03011.84
4.3.20.0000.02011.84
4.3.10.0000.03311.84
4.3.00.0030.03711.84

preferences:
40.97 ms | 401 KiB | 5 Q