3v4l.org

run code in 300+ PHP versions simultaneously
<?php $select = 'SELECT DISTINCT t.id as "t.id",t.creation_date as "t.creation_date",t.default_language_code as "t.default_language_code",t.name as "t.name",t.description as "t.description",t.document_store_path as "t.document_store_path",t.type as "t.type",t.left_value as "t.left_value",t.right_value as "t.right_value",t.event_id as "t.event_id",t.parent_id as "t.parent_id",t2.id as "t2.id",t2.creation_date as "t2.creation_date",t2.default_language_code as "t2.default_language_code",t2.name as "t2.name",t2.description as "t2.description",t2.document_store_path as "t2.document_store_path",t2.type as "t2.type",t2.left_value as "t2.left_value",t2.right_value as "t2.right_value",t2.event_id as "t2.event_id",t2.parent_id as "t2.parent_id"'; $from = 'FROM team t , (SELECT t.* FROM team t LEFT JOIN team_role tr ON (t.id = tr.team_id) WHERE tr.participant_id = ? UNION SELECT t.* FROM team t LEFT JOIN team_role tr ON (t.id = tr.team_id) LEFT JOIN unit_role ur ON (tr.unit_id = ur.unit_id) WHERE ur.participant_id = ?) as dt LEFT JOIN team t2 ON ("t.parent_id" = t2.id)'; $where = 'WHERE t.left_value < dt.left_value and t.right_value > dt.right_value and t.event_id = dt.event_id'; $sql = $select . ' ' . $from . ' ' . $where; 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.60.0120.00618.18
8.3.50.0210.00721.95
8.3.40.0090.00618.54
8.3.30.0110.00418.96
8.3.20.0000.00720.33
8.3.10.0080.00021.98
8.3.00.0040.00422.40
8.2.180.0140.00716.50
8.2.170.0000.01422.96
8.2.160.0000.01421.03
8.2.150.0090.00024.18
8.2.140.0040.00424.66
8.2.130.0000.00826.16
8.2.120.0040.00417.75
8.2.110.0030.00620.46
8.2.100.0090.00317.84
8.2.90.0070.00019.08
8.2.80.0000.00818.04
8.2.70.0040.00417.50
8.2.60.0050.00318.04
8.2.50.0040.00418.07
8.2.40.0000.00818.09
8.2.30.0040.00417.96
8.2.20.0040.00417.68
8.2.10.0050.00319.41
8.2.00.0040.00417.75
8.1.280.0130.00925.92
8.1.270.0070.00023.96
8.1.260.0070.00026.35
8.1.250.0000.00828.09
8.1.240.0060.00323.77
8.1.230.0080.00322.11
8.1.220.0040.00417.74
8.1.210.0040.00418.77
8.1.200.0030.00617.35
8.1.190.0040.00417.39
8.1.180.0030.00518.10
8.1.170.0000.00918.59
8.1.160.0070.00322.08
8.1.150.0000.01018.65
8.1.140.0040.00417.48
8.1.130.0000.00717.84
8.1.120.0050.00317.50
8.1.110.0080.00017.38
8.1.100.0000.00717.52
8.1.90.0050.00317.45
8.1.80.0040.00317.37
8.1.70.0000.00717.46
8.1.60.0040.00417.64
8.1.50.0040.00417.51
8.1.40.0000.00817.43
8.1.30.0090.00017.63
8.1.20.0080.00017.63
8.1.10.0070.00017.54
8.1.00.0040.00417.47
8.0.300.0070.00018.77
8.0.290.0040.00417.05
8.0.280.0000.00718.47
8.0.270.0030.00617.28
8.0.260.0030.00316.81
8.0.250.0000.00817.01
8.0.240.0000.00716.99
8.0.230.0070.00017.00
8.0.220.0030.00316.85
8.0.210.0050.00216.87
8.0.200.0030.00316.91
8.0.190.0080.00017.02
8.0.180.0070.00016.96
8.0.170.0040.00416.94
8.0.160.0000.00716.93
8.0.150.0000.00716.93
8.0.140.0050.00216.78
8.0.130.0050.00013.30
8.0.120.0000.00816.78
8.0.110.0050.00216.82
8.0.100.0000.00716.96
8.0.90.0040.00416.78
8.0.80.0100.00616.84
8.0.70.0070.00016.75
8.0.60.0000.00816.85
8.0.50.0000.00716.88
8.0.30.0140.00617.11
8.0.20.0080.01017.40
8.0.10.0050.00316.86
8.0.00.0120.00716.76
7.4.330.0030.00315.09
7.4.320.0000.00616.65
7.4.300.0000.00616.61
7.4.290.0000.00716.57
7.4.280.0030.00316.53
7.4.270.0050.00216.55
7.4.260.0000.00716.64
7.4.250.0000.00716.42
7.4.240.0020.00516.57
7.4.230.0020.00516.66
7.4.220.0000.01916.63
7.4.210.0060.00816.52
7.4.200.0040.00416.55
7.4.190.0070.00016.38
7.4.160.0030.01216.54
7.4.150.0080.01117.40
7.4.140.0080.01117.86
7.4.130.0100.00616.51
7.4.120.0100.00716.62
7.4.110.0100.00716.68
7.4.100.0090.00916.30
7.4.90.0070.01016.41
7.4.80.0090.01216.43
7.4.70.0060.01516.54
7.4.60.0030.01216.42
7.4.50.0030.00316.33
7.4.40.0030.01222.77
7.4.30.0040.01216.25
7.4.10.0090.00916.56
7.4.00.0130.00715.66
7.3.330.0050.00013.02
7.3.320.0000.00513.19
7.3.310.0030.00316.23
7.3.300.0030.00316.15
7.3.290.0100.00316.26
7.3.280.0120.00716.32
7.3.270.0100.00617.40
7.3.260.0100.00716.38
7.3.250.0180.00216.38
7.3.240.0110.00616.30
7.3.230.0150.00316.51
7.3.210.0070.01216.28
7.3.200.0070.01019.39
7.3.190.0150.00616.74
7.3.180.0130.00716.64
7.3.170.0110.00716.38
7.3.160.0090.00916.21
7.3.130.0060.01116.41
7.3.120.0030.01515.54
7.3.110.0130.00316.20
7.3.100.0030.00616.19
7.3.90.0100.00016.19
7.3.80.0070.00716.57
7.3.70.0140.00016.38
7.3.60.0030.00616.23
7.3.50.0090.00616.10
7.3.40.0040.01116.22
7.3.30.0060.00616.42
7.3.20.0060.00918.04
7.3.10.0090.00517.39
7.3.00.0070.00917.30
7.2.330.0150.00316.31
7.2.320.0100.00716.38
7.2.310.0110.01516.76
7.2.300.0110.01216.41
7.2.290.0030.01316.39
7.2.260.0130.00716.39
7.2.250.0070.01316.07
7.2.240.0030.01016.61
7.2.230.0030.01216.59
7.2.220.0060.00716.57
7.2.210.0070.01016.47
7.2.200.0070.00716.55
7.2.190.0040.01216.55
7.2.180.0030.01016.43
7.2.170.0040.00816.56
7.2.160.0060.00616.34
7.2.150.0060.01018.40
7.2.140.0000.01118.30
7.2.130.0050.00817.52
7.2.120.0070.00617.62
7.2.110.0050.01017.55
7.2.100.0070.00617.56
7.2.90.0050.00717.58
7.2.80.0060.01117.53
7.2.70.0090.00517.53
7.2.60.0110.00517.60
7.2.50.0080.00817.54
7.2.40.0060.00817.63
7.2.30.0060.00917.46
7.2.20.0080.00517.57
7.2.10.0050.00917.57
7.2.00.0050.00618.20
7.1.330.0070.00717.22
7.1.320.0030.00617.13
7.1.310.0090.00617.40
7.1.300.0070.00717.32
7.1.290.0040.00817.37
7.1.280.0060.00317.13
7.1.270.0060.00617.37
7.1.260.0070.01017.15
7.1.250.0080.00816.46
7.1.240.0070.00717.23
7.1.230.0030.00617.11
7.1.220.0000.01117.07
7.1.210.0030.01017.06
7.1.200.0060.00617.23
7.1.190.0030.00717.36
7.1.180.0070.00717.23
7.1.170.0060.00317.16
7.1.160.0070.00717.21
7.1.150.0030.00917.37
7.1.140.0070.00717.30
7.1.130.0030.01017.32
7.1.120.0000.00917.29
7.1.110.0070.00717.15
7.1.100.0050.00717.71
7.1.90.0070.00317.16
7.1.80.0100.00717.09
7.1.70.0070.00717.03
7.1.60.0120.00818.50
7.1.50.0090.01117.17
7.1.40.0060.00617.36
7.1.30.0100.00317.36
7.1.20.0050.00517.21
7.1.10.0070.01017.22
7.1.00.0030.04919.81
7.0.330.0080.00817.02
7.0.320.0040.01116.98
7.0.310.0140.00016.80
7.0.300.0030.00916.80
7.0.290.0070.00716.84
7.0.280.0070.00316.95
7.0.270.0030.01216.90
7.0.260.0100.00717.00
7.0.250.0110.00417.07
7.0.240.0070.01016.99
7.0.230.0090.00916.89
7.0.220.0030.00717.02
7.0.210.0040.01116.95
7.0.200.0060.00916.87
7.0.190.0060.00916.79
7.0.180.0030.01016.84
7.0.170.0040.01116.93
7.0.160.0030.01016.70
7.0.150.0030.01016.92
7.0.140.0060.03919.44
7.0.130.0030.00916.96
7.0.120.0060.00916.79
7.0.110.0000.01116.82
7.0.100.0040.00816.86
7.0.90.0040.01116.91
7.0.80.0040.00716.91
7.0.70.0100.00317.06
7.0.60.0090.04018.40
7.0.50.0050.03317.31
7.0.40.0080.04717.44
7.0.30.0150.04517.49
7.0.20.0140.04417.58
7.0.10.0150.03917.55
7.0.00.0070.02717.56
5.6.400.0060.00915.71
5.6.390.0040.01215.57
5.6.380.0030.01015.41
5.6.370.0040.01115.63
5.6.360.0030.00715.64
5.6.350.0030.01215.96
5.6.340.0030.01015.86
5.6.330.0000.00915.84
5.6.320.0030.00615.82
5.6.310.0000.01415.77
5.6.300.0030.00915.52
5.6.290.0100.00315.54
5.6.280.0070.03818.37
5.6.270.0150.00415.71
5.6.260.0070.00415.86
5.6.250.0040.00715.75
5.6.240.0030.01015.65
5.6.230.0030.00815.84
5.6.220.0060.01215.70
5.6.210.0120.03718.22
5.6.200.0050.02717.00
5.6.190.0100.04418.26
5.6.180.1770.02718.20
5.6.170.0210.02918.09
5.6.160.0080.03818.01
5.6.150.0100.03516.82
5.6.140.0050.04217.11
5.6.130.0040.02616.99
5.6.120.0050.02618.46
5.6.110.0100.04218.35
5.6.100.0070.05018.49
5.6.90.0110.03618.31
5.6.80.0110.03618.05
5.6.70.0230.03818.00
5.6.60.0030.01315.54
5.6.50.0080.00415.66
5.6.40.0080.00815.65
5.6.30.0000.01015.90
5.6.20.0090.00315.85
5.6.10.0030.01015.56
5.6.00.0030.00615.59
5.5.380.0060.00615.67
5.5.370.0100.00315.51
5.5.360.0040.00815.52
5.5.350.0060.03017.90
5.5.340.0080.04216.64
5.5.330.0090.02017.83
5.5.320.0080.02817.76
5.5.310.0200.03717.92
5.5.300.0060.03516.92
5.5.290.0070.02216.82
5.5.280.0050.04518.05
5.5.270.0050.04018.02
5.5.260.0070.02718.04
5.5.250.0080.02718.04
5.5.240.0020.04817.83
5.5.230.0040.00815.32
5.5.220.0070.01015.41
5.5.210.0030.00615.27
5.5.200.0000.01315.52
5.5.190.0130.00315.59
5.5.180.0050.00815.34
5.5.170.0030.00915.60
5.5.160.0060.00615.53
5.5.150.0070.00715.57
5.5.140.0030.00615.77
5.5.130.0030.00915.70
5.5.120.0070.00715.53
5.5.110.0030.00615.52
5.5.100.0060.00915.20
5.5.90.0120.00315.41
5.5.80.0030.01215.58
5.5.70.0070.00415.32
5.5.60.0040.01215.52
5.5.50.0000.01115.41
5.5.40.0040.01115.49
5.5.30.0040.00815.43
5.5.20.0060.00615.61
5.5.10.0090.00315.47
5.5.00.0000.01115.47
5.4.450.0540.03816.08
5.4.440.0070.03515.91
5.4.430.0150.02215.93
5.4.420.0280.02816.06
5.4.410.0070.02815.69
5.4.400.0230.02615.53
5.4.390.0250.03215.49
5.4.380.0070.03115.32
5.4.370.0050.02315.56
5.4.360.0070.03015.44
5.4.350.0060.02012.23
5.4.340.0030.02412.18
5.4.330.0030.00312.31
5.4.320.0090.02312.37
5.4.310.0020.02312.40
5.4.300.0070.02012.45
5.4.290.0030.02812.51
5.4.280.0080.02512.34
5.4.270.0040.02812.38
5.4.260.0040.02712.45
5.4.250.0100.01812.38
5.4.240.0040.02312.43
5.4.230.0060.02712.26
5.4.220.0040.02112.41
5.4.210.0100.01812.39
5.4.200.0090.02112.29
5.4.190.0090.02612.34
5.4.180.0100.02412.30
5.4.170.0080.02812.34
5.4.160.0070.02812.31
5.4.150.0120.02512.36
5.4.140.0110.02512.17
5.4.130.0140.02312.20
5.4.120.0120.02212.21
5.4.110.0130.02312.16
5.4.100.0110.02612.13
5.4.90.0090.02712.15
5.4.80.0090.02412.16
5.4.70.0130.02012.18
5.4.60.0100.02412.18
5.4.50.0130.02212.17
5.4.40.0110.02312.17
5.4.30.0070.02612.13
5.4.20.0150.02012.13
5.4.10.0080.02412.12
5.4.00.0150.03311.92
5.3.290.0070.02812.85
5.3.280.0040.02912.76
5.3.270.0090.02712.87
5.3.260.0100.02612.89
5.3.250.0190.03412.78
5.3.240.0080.03112.76
5.3.230.0100.02612.85
5.3.220.0120.02512.61
5.3.210.0070.02812.63
5.3.200.0140.02312.66
5.3.190.0150.02112.63
5.3.180.0100.02712.79
5.3.170.0110.02512.79
5.3.160.0100.02512.77
5.3.150.0110.02712.73
5.3.140.0120.02312.74
5.3.130.0140.04112.79
5.3.120.0150.02412.72
5.3.110.0110.02612.77
5.3.100.0150.02212.45
5.3.90.0150.03612.49
5.3.80.0110.02512.31
5.3.70.0070.02812.33
5.3.60.0110.02612.38
5.3.50.0100.02312.35
5.3.40.0080.02812.35
5.3.30.0060.03012.38
5.3.20.0070.02812.24
5.3.10.0070.02812.12
5.3.00.0110.02112.05
5.2.170.0140.0349.19
5.2.160.0170.0319.18
5.2.150.0150.0329.19
5.2.140.0110.0379.18
5.2.130.0160.0319.14
5.2.120.0140.0329.14
5.2.110.0140.0339.14
5.2.100.0140.0349.15
5.2.90.0150.0339.15
5.2.80.0120.0379.14
5.2.70.0100.0379.14
5.2.60.0090.0389.09
5.2.50.0080.0399.06
5.2.40.0120.0359.04
5.2.30.0100.0369.01
5.2.20.0120.0369.01
5.2.10.0130.0338.93
5.2.00.0110.0358.78
5.1.60.0100.0308.07
5.1.50.0100.0318.06
5.1.40.0100.0308.05
5.1.30.0160.0288.40
5.1.20.0140.0318.43
5.1.10.0110.0338.14
5.1.00.0160.0268.14
5.0.50.0070.0276.63
5.0.40.0070.0256.48
5.0.30.0110.0336.30
5.0.20.0090.0236.27
5.0.10.0070.0246.24
5.0.00.0120.0356.23
4.4.90.0070.0194.78
4.4.80.0060.0194.75
4.4.70.0120.0144.75
4.4.60.0060.0214.75
4.4.50.0080.0204.77
4.4.40.0080.0284.71
4.4.30.0080.0184.76
4.4.20.0070.0194.84
4.4.10.0060.0214.85
4.4.00.0090.0274.76
4.3.110.0050.0204.67
4.3.100.0070.0184.66
4.3.90.0080.0194.64
4.3.80.0050.0304.58
4.3.70.0090.0154.63
4.3.60.0090.0154.62
4.3.50.0080.0174.63
4.3.40.0070.0274.54
4.3.30.0040.0193.29
4.3.20.0040.0193.27
4.3.10.0030.0213.23
4.3.00.0130.0237.46

preferences:
40.75 ms | 401 KiB | 5 Q