3v4l.org

run code in 300+ PHP versions simultaneously
<?php $query = 'SELECT COUNT( `orders`.order_id ) AS `cnt`, ' . '`orders`.`payment_type`, `orders`.`package_id`, `orders`.`country_id`, ' . '`payment_cost`.`cost`, `vat`, SUM(`orders`.`amount`) AS `omzet` ' . 'FROM `orders`, ' . 'WHERE `orders`.`status` IN(:success, :verified) ' . "AND DATE_FORMAT( `orders`.`payment_date` , '%m-%y' ) = :date " . 'AND `orders`.`payment_type`=`payment_cost`.`payment_type` ' . 'AND `orders`.`package_id`=`payment_cost`.`package_id` ' . 'AND `orders`.`country_id`=`payment_cost`.`country_id` ' . 'GROUP BY `orders`.`payment_type`, `orders`.`country_id`, `orders`.`package_id` ' . 'ORDER BY payment_type, country_id ASC'; echo $query;

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.0030.01016.49
8.3.50.0070.01021.86
8.3.40.0150.00618.81
8.3.30.0120.00318.92
8.3.20.0070.00020.37
8.3.10.0070.00023.48
8.3.00.0040.00417.80
8.2.180.0120.00916.50
8.2.170.0130.00322.96
8.2.160.0030.01020.39
8.2.150.0070.00024.18
8.2.140.0080.00024.66
8.2.130.0040.00426.16
8.2.120.0060.00321.09
8.2.110.0070.00321.06
8.2.100.0040.00818.13
8.2.90.0040.00419.17
8.2.80.0000.00817.97
8.2.70.0000.00917.49
8.2.60.0000.00818.04
8.2.50.0060.00318.07
8.2.40.0000.00918.16
8.2.30.0000.00818.27
8.2.20.0050.00317.58
8.2.10.0000.00717.99
8.2.00.0080.00017.68
8.1.280.0120.00625.92
8.1.270.0050.00323.96
8.1.260.0070.00026.35
8.1.250.0040.00428.09
8.1.240.0090.00021.15
8.1.230.0070.00417.83
8.1.220.0030.00517.74
8.1.210.0000.00918.77
8.1.200.0060.00317.23
8.1.190.0040.00417.23
8.1.180.0000.00818.10
8.1.170.0030.00618.70
8.1.160.0000.00722.02
8.1.150.0040.00418.75
8.1.140.0040.00417.47
8.1.130.0030.00317.76
8.1.120.0030.00517.44
8.1.110.0040.00417.47
8.1.100.0030.00317.42
8.1.90.0070.00017.35
8.1.80.0000.01017.29
8.1.70.0000.00717.39
8.1.60.0060.00317.53
8.1.50.0040.00417.40
8.1.40.0020.00517.36
8.1.30.0060.00317.65
8.1.20.0040.00417.62
8.1.10.0030.00517.51
8.1.00.0030.00617.54
8.0.300.0000.00718.77
8.0.290.0040.00416.75
8.0.280.0000.00718.46
8.0.270.0000.00717.22
8.0.260.0040.00417.15
8.0.250.0030.00316.96
8.0.240.0040.00716.96
8.0.230.0030.00316.89
8.0.220.0030.00316.83
8.0.210.0070.00016.74
8.0.200.0000.00716.88
8.0.190.0040.00416.76
8.0.180.0070.00016.92
8.0.170.0040.00416.88
8.0.160.0000.00716.73
8.0.150.0030.00316.78
8.0.140.0040.00416.80
8.0.130.0030.00313.24
8.0.120.0080.00016.80
8.0.110.0070.00016.80
8.0.100.0040.00416.82
8.0.90.0000.00816.77
8.0.80.0040.01116.77
8.0.70.0040.00416.71
8.0.60.0000.00816.85
8.0.50.0000.00716.87
8.0.30.0100.01217.01
8.0.20.0130.01217.40
8.0.10.0040.00417.03
8.0.00.0070.01016.81
7.4.330.0000.00615.00
7.4.320.0030.00316.46
7.4.300.0050.00216.41
7.4.290.0000.00816.54
7.4.280.0000.00816.53
7.4.270.0070.00016.56
7.4.260.0110.00016.35
7.4.250.0040.00416.45
7.4.240.0000.00716.57
7.4.230.0040.00416.27
7.4.220.0070.01016.54
7.4.210.0060.00916.43
7.4.200.0000.00816.68
7.4.160.0100.00716.41
7.4.150.0090.00917.40
7.4.140.0120.00717.86
7.4.130.0080.00816.50
7.4.120.0150.00516.53
7.4.110.0160.00016.31
7.4.100.0060.01516.46
7.4.90.0030.01316.56
7.4.80.0190.00619.39
7.4.70.0030.01316.39
7.4.60.0070.01016.41
7.4.50.0050.00016.54
7.4.40.0100.01016.57
7.4.30.0090.00616.57
7.4.00.0120.00415.07
7.3.330.0000.00513.11
7.3.320.0020.00213.16
7.3.310.0040.00416.18
7.3.300.0040.00416.23
7.3.290.0080.01116.25
7.3.280.0100.00816.22
7.3.270.0060.01217.40
7.3.260.0130.00316.54
7.3.250.0080.00816.27
7.3.240.0080.00816.27
7.3.230.0110.00716.39
7.3.210.0140.00316.32
7.3.200.0130.00919.39
7.3.190.0130.00316.29
7.3.180.0120.00316.38
7.3.170.0090.00616.46
7.3.160.0130.00316.21
7.3.120.0030.01014.54
7.3.10.0150.00316.48
7.3.00.0150.00416.37
7.2.330.0070.01316.48
7.2.320.0070.01016.52
7.2.310.0060.01016.39
7.2.300.0140.00416.30
7.2.290.0060.00916.44
7.2.130.0110.00716.19
7.2.120.0170.00216.70
7.2.110.0090.00916.45
7.2.100.0060.00916.20
7.2.90.0090.01516.13
7.2.80.0060.01216.45
7.2.70.0130.00816.27
7.2.60.0150.00816.59
7.2.50.0180.01116.15
7.2.40.0060.01016.66
7.2.30.0100.01716.27
7.2.20.0200.00716.54
7.2.10.0190.01116.23
7.2.00.0100.01218.06
7.1.250.0110.00315.24
7.1.100.0040.00818.01
7.1.70.0050.00516.71
7.1.60.0040.02219.70
7.1.50.0070.01116.46
7.1.00.0030.07322.44
7.0.200.0000.01016.81
7.0.140.0030.07321.95
7.0.100.0470.07719.92
7.0.90.0500.08019.90
7.0.80.0500.07319.95
7.0.70.0370.07020.00
7.0.60.0430.08019.95
7.0.50.0470.05020.18
7.0.40.0000.08320.15
7.0.30.0200.07020.09
7.0.20.0130.08020.19
7.0.10.0030.09320.13
7.0.00.0100.07720.04
5.6.280.0030.07321.12
5.6.250.0130.07020.49
5.6.240.0130.07720.66
5.6.230.0200.06020.53
5.6.220.0100.07320.58
5.6.210.0030.06020.61
5.6.200.0100.08321.14
5.6.190.0170.07321.06
5.6.180.0130.08321.08
5.6.170.0130.08021.07
5.6.160.0130.07721.17
5.6.150.0100.05020.93
5.6.140.0100.07721.03
5.6.130.0100.08021.08
5.6.120.0100.08020.94
5.6.110.0030.09720.93
5.6.100.0100.08321.03
5.6.90.0170.07321.06
5.6.80.0000.08720.55
5.6.70.0170.06720.50
5.6.60.0030.08320.41
5.6.50.0070.07020.43
5.6.40.0100.07320.40
5.6.30.0070.04720.46
5.6.20.0030.08320.37
5.6.10.0130.06720.37
5.6.00.0030.08720.42
5.5.380.0130.07720.41
5.5.370.0130.07320.39
5.5.360.0070.08320.40
5.5.350.0170.07320.46
5.5.340.0100.07720.80
5.5.330.0130.07020.76
5.5.320.0170.06320.88
5.5.310.0070.08320.77
5.5.300.0130.07320.83
5.5.290.0100.07720.87
5.5.280.0100.08020.88
5.5.270.0070.08020.91
5.5.260.0200.07720.63
5.5.250.0070.07720.68
5.5.240.0070.05020.21
5.5.230.0030.08320.15
5.5.220.0070.04720.17
5.5.210.0100.07320.27
5.5.200.0170.03720.25
5.5.190.0100.07320.15
5.5.180.0130.07020.14
5.5.160.0200.07320.09
5.5.150.0070.08020.25
5.5.140.0070.07720.07
5.5.130.0030.08020.23
5.5.120.0070.08020.11
5.5.110.0130.07020.27
5.5.100.0070.06720.17
5.5.90.0170.06020.06
5.5.80.0100.07320.07
5.5.70.0100.04719.93
5.5.60.0130.07020.00
5.5.50.0030.08020.04
5.5.40.0000.06720.04
5.5.30.0100.07720.04
5.5.20.0100.07320.07
5.5.10.0130.06720.02
5.5.00.0100.07320.07
5.4.450.0070.08319.36
5.4.440.0130.04319.40
5.4.430.0030.08319.35
5.4.420.0070.08019.48
5.4.410.0070.07719.43
5.4.400.0100.04718.82
5.4.390.0070.05719.15
5.4.380.0170.06319.15
5.4.370.0130.06719.03
5.4.360.0100.04018.81
5.4.350.0170.06718.97
5.4.340.0170.06719.09
5.4.320.0100.07019.03
5.4.310.0070.04719.10
5.4.300.0070.04719.04
5.4.290.0100.04319.05
5.4.280.0170.07319.06
5.4.270.0130.07319.02
5.4.260.0070.07318.81
5.4.250.0070.07718.88
5.4.240.0100.07319.11
5.4.230.0070.06018.89
5.4.220.0100.05718.78
5.4.210.0000.06318.97
5.4.200.0070.07719.18
5.4.190.0100.07718.95
5.4.180.0170.05718.89
5.4.170.0070.06719.11
5.4.160.0070.07018.95
5.4.150.0030.06718.76
5.4.140.0070.07716.38
5.4.130.0130.06716.33
5.4.120.0070.06716.26
5.4.110.0070.05716.33
5.4.100.0130.06016.18
5.4.90.0100.05716.21
5.4.80.0100.06016.33
5.4.70.0030.07316.32
5.4.60.0070.04016.32
5.4.50.0100.06716.39
5.4.40.0100.06716.45
5.4.30.0030.07316.24
5.4.20.0070.07016.40
5.4.10.0030.08016.19
5.4.00.0030.07315.73
5.3.290.0100.07014.52
5.3.280.0030.04714.46
5.3.270.0000.07714.46
5.3.260.0030.07014.59
5.3.250.0100.07014.59
5.3.240.0130.07014.61
5.3.230.0100.06714.42
5.3.220.0100.06314.54
5.3.210.0170.06714.53
5.3.200.0070.07714.53
5.3.190.0130.06714.42
5.3.180.0030.07314.47
5.3.170.0030.05714.56
5.3.160.0030.08014.42
5.3.150.0070.07314.56
5.3.140.0100.05014.54
5.3.130.0030.05314.50
5.3.120.0100.05314.51
5.3.110.0070.07014.54
5.3.100.0070.07314.03
5.3.90.0030.07713.93
5.3.80.0070.07314.01
5.3.70.0100.06714.00
5.3.60.0030.04713.86
5.3.50.0100.07013.94
5.3.40.0070.07313.95
5.3.30.0030.06013.87
5.3.20.0030.07313.55
5.3.10.0030.07313.51
5.3.00.0130.07013.50
5.2.170.0030.07011.20
5.2.160.0070.06311.14
5.2.150.0070.06711.21
5.2.140.0030.03311.19
5.2.130.0130.05311.09
5.2.120.0030.05011.15
5.2.110.0030.06311.09
5.2.100.0030.06311.10
5.2.90.0030.06311.05
5.2.80.0070.06311.09
5.2.70.0100.05711.09
5.2.60.0130.05010.87
5.2.50.0070.04711.02
5.2.40.0030.06310.99
5.2.30.0070.06010.79
5.2.20.0030.06310.95
5.2.10.0030.06010.72
5.2.00.0070.05010.74
5.1.60.0070.05310.06
5.1.50.0100.0539.99
5.1.40.0100.05010.02
5.1.30.0030.06010.27
5.1.20.0000.06010.38
5.1.10.0030.05010.08
5.1.00.0030.05010.11
5.0.50.0100.0438.61
5.0.40.0030.0438.28
5.0.30.0030.0638.27
5.0.20.0130.0308.27
5.0.10.0000.0478.27
5.0.00.0000.0678.27
4.4.90.0070.0308.27
4.4.80.0030.0338.27
4.4.70.0000.0378.27
4.4.60.0030.0338.27
4.4.50.0030.0338.27
4.4.40.0030.0478.27
4.4.30.0030.0378.27
4.4.20.0030.0338.27
4.4.10.0070.0178.27
4.4.00.0030.0378.27
4.3.110.0030.0338.27
4.3.100.0100.0278.27
4.3.90.0000.0378.27
4.3.80.0070.0478.27
4.3.70.0030.0378.27
4.3.60.0000.0378.27
4.3.50.0000.0408.27
4.3.40.0070.0478.27
4.3.30.0030.0338.27
4.3.20.0030.0278.27
4.3.10.0000.0378.27
4.3.00.0030.0308.27

preferences:
41.44 ms | 401 KiB | 5 Q