3v4l.org

run code in 300+ PHP versions simultaneously
<?php // This library is to rewrite MSYQL queries into formatted text class query2text { private $key_arr; public function addline ($query,$keyword) { $fixed = str_ireplace(" ".$keyword,"<br>&nbsp;".$keyword,$query); return $fixed; } public function convert($query) { $key_arr = array("FROM","LEFT JOIN","RIGHT JOIN","INNER JOIN","OUTER JOIN","WHERE","AND","OR","ORDER","GROUP"); foreach($key_arr AS $key) { $query = $this->addline($query,$key); } $query .= "<br><br>\n"; return $query; } } $query = "SELECT patients.patient_id,patients.last_name,patients.first_name,appts.*,appt_types.type,appt_types.color,appt_types.bgcolor" . ",DATE_FORMAT(appts.start,'%m/%d/%Y') AS date" . ",DATE_FORMAT(appts.start,'%h:%i %p') AS time" . ",TIMEDIFF(appts.end,appts.start) AS duration" . " FROM patients,appts,appt_types" . " WHERE appts.cancelled IS NULL" . " AND YEAR(appts.start)='" . $year . "'" . " AND MONTH(appts.start)='" . $month . "'" . " AND DAY(appts.start)='" . $day . "'" . " AND patients.patient_id = appts.patient_id" . " AND appts.type = appt_types.appt_type_id"; $q2t = new query2text(); echo "<hr>" . $q2t->convert($query) . "<hr>\n";

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.00318.55
8.3.50.0140.00822.11
8.3.40.0040.01118.79
8.3.30.0060.00919.08
8.3.20.0070.00020.34
8.3.10.0080.00422.04
8.3.00.0040.00422.40
8.2.180.0090.00616.63
8.2.170.0070.01122.96
8.2.160.0030.01020.89
8.2.150.0040.00424.18
8.2.140.0090.00024.66
8.2.130.0030.00526.16
8.2.120.0060.00319.36
8.2.110.0000.00920.23
8.2.100.0080.00417.84
8.2.90.0000.00819.21
8.2.80.0000.00818.05
8.2.70.0080.00017.61
8.2.60.0000.00717.93
8.2.50.0080.00018.07
8.2.40.0040.00418.34
8.2.30.0050.00318.15
8.2.20.0070.00017.67
8.2.10.0080.00017.83
8.2.00.0040.00417.70
8.1.280.0040.01125.92
8.1.270.0050.00322.02
8.1.260.0000.00726.35
8.1.250.0040.00428.09
8.1.240.0030.00623.98
8.1.230.0040.00821.04
8.1.220.0040.00417.79
8.1.210.0060.00318.77
8.1.200.0060.00317.23
8.1.190.0080.00017.30
8.1.180.0040.00418.10
8.1.170.0000.00818.64
8.1.160.0000.00822.03
8.1.150.0040.00418.65
8.1.140.0040.00417.35
8.1.130.0080.00017.85
8.1.120.0070.00017.44
8.1.110.0070.00017.49
8.1.100.0000.00717.43
8.1.90.0040.00417.47
8.1.80.0000.00717.47
8.1.70.0030.00317.50
8.1.60.0080.00017.57
8.1.50.0030.00617.55
8.1.40.0040.00417.55
8.1.30.0000.00817.63
8.1.20.0050.00317.69
8.1.10.0000.00817.53
8.1.00.0050.00317.45
8.0.300.0080.00018.77
8.0.290.0000.00717.16
8.0.280.0030.00318.47
8.0.270.0000.00817.23
8.0.260.0070.00017.00
8.0.250.0030.00317.05
8.0.240.0040.00417.02
8.0.230.0030.00316.93
8.0.220.0020.00516.95
8.0.210.0040.00417.01
8.0.200.0000.00817.02
8.0.190.0040.00417.09
8.0.180.0020.00516.89
8.0.170.0040.00417.03
8.0.160.0040.00416.93
8.0.150.0080.00316.95
8.0.140.0040.00416.83
8.0.130.0030.00313.38
8.0.120.0000.00816.80
8.0.110.0000.00717.02
8.0.100.0040.00416.99
8.0.90.0030.00516.76
8.0.80.0090.00616.93
8.0.70.0000.00816.96
8.0.60.0040.00416.84
8.0.50.0020.00516.88
8.0.30.0140.00617.07
8.0.20.0080.01017.42
8.0.10.0000.00816.95
8.0.00.0130.00716.86
7.4.330.0000.00515.00
7.4.320.0030.00316.65
7.4.300.0030.00316.64
7.4.290.0000.00616.52
7.4.280.0000.00716.38
7.4.270.0080.00016.58
7.4.260.0000.01016.50
7.4.250.0070.00016.59
7.4.240.0040.00416.54
7.4.230.0070.00016.66
7.4.220.0160.01016.63
7.4.210.0090.00716.59
7.4.200.0000.00716.66
7.4.190.0000.00716.70
7.4.160.0120.00916.70
7.4.150.0070.01417.40
7.4.140.0110.00817.86
7.4.130.0090.01116.72
7.4.120.0080.01016.54
7.4.110.0130.00316.62
7.4.100.0030.02016.64
7.4.90.0100.01016.48
7.4.80.0130.01019.39
7.4.70.0120.00616.49
7.4.60.0080.01416.38
7.4.50.0030.00616.65
7.4.40.0000.01322.77
7.4.30.0190.00316.61
7.4.10.0070.01015.07
7.4.00.0100.00614.91
7.3.330.0030.00313.33
7.3.320.0000.00513.31
7.3.310.0030.00516.38
7.3.300.0030.00316.31
7.3.290.0100.01016.44
7.3.280.0080.00916.36
7.3.270.0030.01317.40
7.3.260.0120.00816.56
7.3.250.0090.00716.47
7.3.240.0090.00916.43
7.3.230.0190.00016.40
7.3.210.0070.01016.63
7.3.200.0110.01119.39
7.3.190.0070.01016.67
7.3.180.0110.00616.60
7.3.170.0160.00316.53
7.3.160.0060.00916.66
7.3.130.0090.00915.07
7.3.120.0100.00814.73
7.3.110.0060.00914.86
7.3.100.0080.00614.75
7.3.90.0040.01415.00
7.3.80.0070.00715.02
7.3.70.0050.00514.50
7.3.60.0060.00614.86
7.3.50.0000.01214.88
7.3.40.0030.00614.88
7.3.30.0090.00014.89
7.3.20.0030.01016.54
7.3.10.0080.00516.71
7.3.00.0100.00216.71
7.2.330.0140.00716.53
7.2.320.0130.01016.83
7.2.310.0090.00916.73
7.2.300.0040.01216.84
7.2.290.0040.01216.80
7.2.260.0130.00715.01
7.2.250.0050.01014.75
7.2.240.0090.00615.02
7.2.230.0070.00715.14
7.2.220.0060.00314.93
7.2.210.0000.00915.11
7.2.200.0120.00414.96
7.2.190.0090.00315.06
7.2.180.0030.00915.14
7.2.170.0030.00915.21
7.2.160.0100.00014.98
7.2.150.0000.01416.64
7.2.140.0000.01116.70
7.2.130.0070.00716.95
7.2.120.0110.00716.97
7.2.110.0080.00916.94
7.2.100.0090.00616.94
7.2.90.0070.01016.80
7.2.80.0060.00516.97
7.2.70.0060.01016.87
7.2.60.0100.00516.79
7.2.50.0070.00716.96
7.2.40.0060.00716.80
7.2.30.0090.00317.05
7.2.20.0030.01417.03
7.2.10.0060.00917.05
7.2.00.0050.01116.98
7.1.330.0030.01216.05
7.1.320.0030.01015.70
7.1.310.0100.00015.98
7.1.300.0070.00315.92
7.1.290.0110.00415.77
7.1.280.0080.00015.62
7.1.270.0000.01415.92
7.1.260.0000.01015.59
7.1.250.0030.01116.00
7.1.240.0110.00315.81
7.1.230.0020.00715.89
7.1.220.0030.00915.80
7.1.210.0000.01516.00
7.1.200.0120.00315.68
7.1.190.0060.00615.89
7.1.180.0030.01315.86
7.1.170.0040.01115.83
7.1.160.0060.00816.05
7.1.150.0060.01115.77
7.1.140.0040.01115.66
7.1.130.0060.00915.98
7.1.120.0000.00815.90
7.1.110.0100.00315.93
7.1.100.0120.00016.02
7.1.90.0000.01315.89
7.1.80.0060.00615.66
7.1.70.0030.00916.43
7.1.60.0050.01016.38
7.1.50.0050.01016.30
7.1.40.0040.01115.97
7.1.30.0090.00315.74
7.1.20.0040.00815.61
7.1.10.0080.00315.83
7.1.00.0030.04419.18
7.0.330.0080.00315.49
7.0.320.0060.00915.39
7.0.310.0030.01015.21
7.0.300.0030.00615.44
7.0.290.0000.01215.43
7.0.280.0030.01115.42
7.0.270.0040.00715.38
7.0.260.0060.01115.60
7.0.250.0000.00815.66
7.0.240.0030.00615.58
7.0.230.0060.00615.33
7.0.220.0070.00715.43
7.0.210.0140.00015.25
7.0.200.0080.00616.23
7.0.190.0030.01315.31
7.0.180.0040.00815.53
7.0.170.0030.01015.46
7.0.160.0100.00315.36
7.0.150.0060.00615.42
7.0.140.0050.03718.63
7.0.130.0090.00315.29
7.0.120.0030.00615.29
7.0.110.0030.00615.55
7.0.100.0060.00615.42
7.0.90.0090.00315.18
7.0.80.0030.01015.42
7.0.70.0050.00815.44
7.0.60.0100.04217.69
7.0.50.0050.02516.67
7.0.40.0070.02516.79
7.0.30.0130.02216.88
7.0.20.0100.04816.82
7.0.10.0120.02416.84
7.0.00.0070.04716.85
5.6.400.0090.00314.37
5.6.390.0100.00714.61
5.6.380.0080.00414.48
5.6.370.0070.00314.56
5.6.360.0130.00014.63
5.6.350.0090.00314.06
5.6.340.0070.00414.64
5.6.330.0070.00714.19
5.6.320.0070.00714.64
5.6.310.0060.00614.30
5.6.300.0040.00814.33
5.6.290.0030.00614.51
5.6.280.0050.04017.57
5.6.270.0090.00614.21
5.6.260.0000.01314.57
5.6.250.0070.00714.61
5.6.240.0050.00514.39
5.6.230.0060.00914.28
5.6.220.0000.01014.49
5.6.210.0030.04517.45
5.6.200.0090.02316.20
5.6.190.0060.02717.46
5.6.180.0180.02317.38
5.6.170.0180.03817.53
5.6.160.0060.04417.51
5.6.150.0040.02816.32
5.6.140.0050.03116.41
5.6.130.0100.02016.27
5.6.120.0060.03817.83
5.6.110.0130.03817.69
5.6.100.0070.04517.77
5.6.90.0070.02517.53
5.6.80.0050.04117.29
5.6.70.0060.02617.35
5.6.60.0060.00914.31
5.6.50.0040.00414.28
5.6.40.0030.01014.26
5.6.30.0040.00814.66
5.6.20.0100.00314.37
5.6.10.0070.01014.34
5.6.00.0070.01014.17
5.5.380.0100.00314.28
5.5.370.0050.00914.38
5.5.360.0080.00414.29
5.5.350.0150.02017.33
5.5.340.0120.03016.27
5.5.330.0080.02317.19
5.5.320.0030.04817.49
5.5.310.0140.03617.40
5.5.300.0080.03616.34
5.5.290.0070.02816.23
5.5.280.0050.04517.76
5.5.270.0070.04317.47
5.5.260.0030.02717.47
5.5.250.0150.03817.62
5.5.240.0020.02917.25
5.5.230.0040.00814.10
5.5.220.0030.00914.11
5.5.210.0100.00314.09
5.5.200.0090.00614.43
5.5.190.0000.00914.14
5.5.180.0070.00714.41
5.5.170.0170.00014.07
5.5.160.0110.00614.33
5.5.150.0040.00814.12
5.5.140.0080.00414.46
5.5.130.0000.00914.50
5.5.120.0000.01314.41
5.5.110.0070.00314.17
5.5.100.0070.00714.19
5.5.90.0070.01014.37
5.5.80.0040.00814.51
5.5.70.0060.00613.89
5.5.60.0100.00714.35
5.5.50.0000.01514.50
5.5.40.0000.01514.55
5.5.30.0070.00413.97
5.5.20.0100.00314.24
5.5.10.0040.01114.29
5.5.00.0080.00613.76
5.4.450.0100.04516.22
5.4.440.0100.03116.36
5.4.430.0050.03216.23
5.4.420.0100.02816.32
5.4.410.0070.02816.14
5.4.400.0480.03515.88
5.4.390.0510.03015.93
5.4.380.0150.03515.88
5.4.370.0050.02615.89
5.4.360.0070.01815.99
5.4.350.0040.02112.64
5.4.340.0070.01812.63
5.4.330.0070.00313.24
5.4.320.0090.01912.88
5.4.310.0050.02612.88
5.4.300.0030.02312.88
5.4.290.0060.02212.88
5.4.280.0040.02512.82
5.4.270.0050.02616.12
5.4.260.0080.02516.10
5.4.250.0060.04016.08
5.4.240.0150.03016.02
5.4.230.0070.03616.04
5.4.220.0030.03716.09
5.4.210.0100.02716.02
5.4.200.0100.02515.99
5.4.190.0070.03215.99
5.4.180.0050.04016.11
5.4.170.0140.02416.09
5.4.160.0030.03316.09
5.4.150.0100.03316.13
5.4.140.0020.03514.79
5.4.130.0050.02914.90
5.4.120.0130.02214.89
5.4.110.0080.02714.94
5.4.100.0020.03414.82
5.4.90.0080.02314.89
5.4.80.0070.03714.87
5.4.70.0120.02314.88
5.4.60.0120.03114.82
5.4.50.0130.02314.89
5.4.40.0020.03214.82
5.4.30.0100.02614.87
5.4.20.0100.03514.80
5.4.10.0130.02714.86
5.4.00.0050.03014.54
5.3.290.0060.02313.02
5.3.280.0050.03913.92
5.3.270.0060.03513.93
5.3.260.0060.04113.84
5.3.250.0070.03913.92
5.3.240.0010.03813.94
5.3.230.0080.03714.01
5.3.220.0080.03014.00
5.3.210.0090.03413.83
5.3.200.0080.03613.94
5.3.190.0000.03314.00
5.3.180.0020.03613.91
5.3.170.0100.02313.91
5.3.160.0100.03014.00
5.3.150.0020.03214.00
5.3.140.0060.03413.90
5.3.130.0000.03813.99
5.3.120.0020.03913.91
5.3.110.0150.03013.89
5.3.100.0020.03413.65
5.3.90.0050.03113.64
5.3.80.0110.02213.66
5.3.70.0060.03513.67
5.3.60.0050.03513.71
5.3.50.0080.02713.64
5.3.40.0030.03413.61
5.3.30.0050.04013.49
5.3.20.0120.03313.47
5.3.10.0130.02613.46
5.3.00.0060.04013.46
5.2.170.0100.04011.24
5.2.160.0030.06311.06
5.2.150.0000.06311.06
5.2.140.0000.05011.14
5.2.130.0100.04011.19
5.2.120.0130.03011.07
5.2.110.0100.06311.33
5.2.100.0000.04311.29
5.2.90.0100.05011.10
5.2.80.0130.05011.19
5.2.70.0100.04010.93
5.2.60.0070.03711.14
5.2.50.0100.04010.93
5.2.40.0070.04011.01
5.2.30.0130.03310.81
5.2.20.0000.04710.96
5.2.10.0100.03310.93
5.2.00.0100.04310.69
5.1.60.0070.05010.06
5.1.50.0130.04010.25
5.1.40.0000.05010.05
5.1.30.0070.04010.43
5.1.20.0100.03310.41
5.1.10.0070.03310.06
5.1.00.0000.04310.04
5.0.50.0000.0338.79
5.0.40.0000.0408.79
5.0.30.0030.0608.79
5.0.20.0070.0308.79
5.0.10.0000.0338.79
5.0.00.0070.0478.79
4.4.90.0100.0178.79
4.4.80.0100.0208.79
4.4.70.0000.0238.79
4.4.60.0030.0208.79
4.4.50.0000.0308.79
4.4.40.0070.0438.79
4.4.30.0000.0238.79
4.4.20.0100.0238.79
4.4.10.0070.0178.79
4.4.00.0000.0378.79
4.3.110.0000.0238.79
4.3.100.0070.0178.79
4.3.90.0000.0238.79
4.3.80.0030.0338.79
4.3.70.0030.0208.79
4.3.60.0030.0208.79
4.3.50.0030.0278.79
4.3.40.0000.0338.79
4.3.30.0030.0208.79
4.3.20.0000.0238.79
4.3.10.0030.0208.79
4.3.00.0070.0206.88

preferences:
53.93 ms | 401 KiB | 5 Q