3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = "SELECT vysledky2.cisloobch, vysledky2.datum, vysledky2.vysledek, dealersdata.nazevobch, dealersdata.mesto, dealersdata.zeme, psc, " + " (CASE WHEN prod_smlouva = 'True' OR serv_smlouva = 'True' THEN 'Ano' ELSE 'Ne' END) as skoda," + " (CASE WHEN prod_smlouva_v = 'True' OR serv_smlouva_v = 'True' OR serv_smlouva_a = 'True' OR prod_smlouva_a = 'True' OR serv_smlouva_n = 'True' OR prod_smlouva_n = 'True' OR serv_smlouva_s = 'True' OR prod_smlouva_s = 'True' THEN 'Ano' ELSE 'Ne' END) as ost_koncern" + " FROM vysledky2 JOIN" + " (select cisloobch, max(datum) as datum from vysledky2 where dotazid = 94 and vysledek not like '%ORA%' group by cisloobch) as nejvyssi"+ " on vysledky2.cisloobch = nejvyssi.cisloobch and vysledky2.datum = nejvyssi.datum"+ " JOIN dealersdata on vysledky2.cisloobch = dealersdata.cisloobch"+ " WHERE dealersdata.vyrazeny = 'False' AND jiny != 'True' "; 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.0140.00718.55
8.3.50.0140.00721.21
8.3.40.0040.01218.79
8.3.30.0150.00419.09
8.3.20.0030.01420.34
8.3.10.0080.00022.09
8.3.00.0070.00722.30
8.2.180.0100.01016.63
8.2.170.0090.00622.96
8.2.160.0100.00719.08
8.2.150.0030.00525.66
8.2.140.0000.00824.66
8.2.130.0070.00026.16
8.2.120.0150.00019.36
8.2.110.0030.00619.21
8.2.100.0050.00517.84
8.2.90.0040.00419.09
8.2.80.0000.00817.97
8.2.70.0060.00317.50
8.2.60.0060.00317.93
8.2.50.0040.00418.07
8.2.40.0080.00019.81
8.2.30.0000.00718.03
8.2.20.0060.00317.58
8.2.10.0030.00517.61
8.2.00.0030.00517.65
8.1.280.0070.01425.92
8.1.270.0040.00423.99
8.1.260.0030.00626.35
8.1.250.0060.00328.09
8.1.240.0000.00922.02
8.1.230.0000.01118.77
8.1.220.0000.00817.74
8.1.210.0040.00418.77
8.1.200.0090.00017.23
8.1.190.0040.00417.41
8.1.180.0030.00518.80
8.1.170.0040.00418.39
8.1.160.0000.00722.06
8.1.150.0000.00718.46
8.1.140.0040.00417.29
8.1.130.0070.00017.76
8.1.120.0070.00017.31
8.1.110.0050.00217.23
8.1.100.0000.00717.27
8.1.90.0040.00417.29
8.1.80.0020.00517.38
8.1.70.0040.00417.31
8.1.60.0000.01117.49
8.1.50.0040.00417.37
8.1.40.0030.00617.41
8.1.30.0000.00817.58
8.1.20.0000.00817.61
8.1.10.0000.00717.48
8.1.00.0030.00617.30
8.0.300.0070.00018.77
8.0.290.0070.00017.18
8.0.280.0040.00418.40
8.0.270.0070.00017.19
8.0.260.0000.00616.75
8.0.250.0000.00716.99
8.0.240.0030.00316.96
8.0.230.0000.00816.95
8.0.220.0030.00316.86
8.0.210.0070.00016.88
8.0.200.0070.00016.97
8.0.190.0000.00716.89
8.0.180.0070.00016.88
8.0.170.0030.00516.89
8.0.160.0000.00716.93
8.0.150.0000.00716.74
8.0.140.0070.00016.89
8.0.130.0070.00013.29
8.0.120.0000.00716.80
8.0.110.0000.00716.75
8.0.100.0030.00517.00
8.0.90.0000.00716.84
8.0.80.0060.00916.84
8.0.70.0000.00716.77
8.0.60.0000.00816.85
8.0.50.0000.00816.77
8.0.30.0110.00816.98
8.0.20.0110.01117.40
8.0.10.0000.00716.98
8.0.00.0080.01616.47
7.4.330.0030.00315.00
7.4.320.0030.00316.59
7.4.300.0030.00316.55
7.4.290.0040.00416.55
7.4.280.0030.00316.47
7.4.270.0030.00316.55
7.4.260.0000.00816.45
7.4.250.0040.00416.48
7.4.240.0020.00516.45
7.4.230.0030.00316.33
7.4.220.0070.01116.48
7.4.210.0050.00916.48
7.4.200.0070.00016.58
7.4.190.0040.00416.40
7.4.160.0100.00616.38
7.4.150.0040.01417.40
7.4.140.0100.00917.86
7.4.130.0080.01016.35
7.4.120.0080.01216.40
7.4.110.0120.00616.43
7.4.100.0070.01116.40
7.4.90.0120.00616.32
7.4.80.0110.00519.39
7.4.70.0050.01016.46
7.4.60.0120.00416.45
7.4.50.0040.00416.29
7.4.40.0070.01022.77
7.4.30.0030.01216.41
7.4.00.0000.01114.83
7.3.330.0000.00613.05
7.3.320.0050.00013.21
7.3.310.0040.00416.38
7.3.300.0030.00316.32
7.3.290.0040.01116.30
7.3.280.0090.00816.25
7.3.270.0100.00717.40
7.3.260.0170.00016.42
7.3.250.0120.00916.53
7.3.240.0120.00616.40
7.3.230.0120.00516.43
7.3.210.0150.00416.27
7.3.200.0030.01319.39
7.3.190.0180.00416.30
7.3.180.0100.00716.49
7.3.170.0000.02116.29
7.3.160.0100.01116.31
7.3.120.0000.01214.74
7.2.330.0130.01016.47
7.2.320.0150.00316.47
7.2.310.0110.00616.51
7.2.300.0030.01316.58
7.2.290.0110.00716.39
7.2.60.0060.00916.77
7.2.00.0060.00919.34
7.1.200.0110.00315.83
7.1.70.0000.00817.23
7.1.60.0030.00717.16
7.1.50.0210.01434.81
7.1.00.0030.04322.47
7.0.200.0040.00416.86
7.0.140.0030.07022.09
7.0.60.0030.09019.91
7.0.50.0000.06017.73
7.0.40.0070.04020.04
7.0.30.0270.04720.21
7.0.20.0230.07720.16
7.0.10.0170.04320.04
7.0.00.0070.05320.31
5.6.280.0030.09321.04
5.6.210.0070.06320.47
5.6.200.0000.05018.19
5.6.190.0030.05020.35
5.6.180.3500.04020.27
5.6.170.0200.06020.33
5.6.160.0170.08020.47
5.6.150.0030.05718.18
5.6.140.0030.07718.16
5.6.130.0100.04318.18
5.6.120.0170.06720.96
5.6.110.0170.07021.02
5.6.100.0100.06020.95
5.6.90.0000.04320.97
5.6.80.0100.07720.36
5.6.70.0330.06320.42
5.5.350.0330.09720.29
5.5.340.0070.03717.91
5.5.330.0070.08320.29
5.5.320.0270.07720.41
5.5.310.0200.04020.29
5.5.300.0070.04018.02
5.5.290.0070.03717.98
5.5.280.0100.05320.73
5.5.270.0100.07720.96
5.5.260.0070.08020.73
5.5.250.0100.06320.77
5.5.240.0100.06020.04
5.4.450.1000.05719.49
5.4.440.0730.06319.43
5.4.430.0170.04719.47
5.4.420.1100.04319.12
5.4.410.0570.06719.11
5.4.400.1030.06018.75
5.4.390.1370.07018.60
5.4.380.0200.06018.77
5.4.370.0100.05718.79
5.4.360.0200.04718.45
5.4.350.0170.05318.63
5.4.340.0070.06318.66
5.4.320.0060.03612.45
5.4.310.0050.04212.45
5.4.300.0060.04212.45
5.4.290.0100.04112.45
5.4.280.0070.03912.34
5.4.270.0120.03512.34
5.4.260.0070.06718.71
5.4.250.0100.04718.86
5.4.240.0100.04718.87
5.4.230.0100.04719.03
5.4.220.0000.06318.87
5.4.210.0070.07718.90
5.4.200.0170.04318.99
5.4.190.0070.05018.98
5.4.180.0100.05019.02
5.4.170.0100.05318.85
5.4.160.0030.05318.81
5.4.150.0130.05718.89
5.4.140.0100.05016.31
5.4.130.0100.04716.44
5.4.120.0130.04316.47
5.4.110.0130.04716.35
5.4.100.0070.05016.41
5.4.90.0030.07716.50
5.4.80.0100.07016.41
5.4.70.0100.05316.18
5.4.60.0100.04716.42
5.4.50.0030.06016.39
5.4.40.0170.06016.37
5.4.30.0070.04716.31
5.4.20.0130.04016.45
5.4.10.0070.05316.30
5.4.00.0070.04715.73
5.3.290.0070.04312.80
5.3.280.0070.05314.61
5.3.270.0100.05014.60
5.3.260.0170.06714.60
5.3.250.0070.05314.61
5.3.240.0000.06714.59
5.3.230.0170.06014.76
5.3.220.0070.05314.42
5.3.210.0130.04714.58
5.3.200.0030.05314.55
5.3.190.0130.05314.26
5.3.180.0100.04714.65
5.3.170.0000.05714.39
5.3.160.0100.07014.33
5.3.150.0070.05314.25
5.3.140.0170.05014.47
5.3.130.0100.05314.54
5.3.120.0130.04714.41
5.3.110.0030.05314.46
5.3.100.0030.05314.04
5.3.90.0070.05013.79
5.3.80.0070.05013.96
5.3.70.0130.06313.96
5.3.60.0130.06314.01
5.3.50.0100.04713.86
5.3.40.0070.05013.89
5.3.30.0170.04013.68
5.3.20.0070.06713.71
5.3.10.0000.05313.48
5.3.00.0030.05013.79
5.2.170.0100.03711.25
5.2.160.0100.03310.90
5.2.150.0030.04311.03
5.2.140.0070.04011.04
5.2.130.0100.03710.98
5.2.120.0100.05011.02
5.2.110.0030.04011.03
5.2.100.0170.04311.20
5.2.90.0000.04711.01
5.2.80.0070.04711.20
5.2.70.0100.03711.00
5.2.60.0070.04011.16
5.2.50.0000.05010.91
5.2.40.0100.03711.11
5.2.30.0030.04010.80
5.2.20.0070.03710.71
5.2.10.0030.04010.93
5.2.00.0030.06010.78
5.1.60.0070.0309.98
5.1.50.0000.0479.95
5.1.40.0100.0309.92
5.1.30.0130.02710.40
5.1.20.0100.03010.43
5.1.10.0070.0479.99
5.1.00.0030.03710.30
5.0.50.0070.0278.54
5.0.40.0070.0308.44
5.0.30.0000.0438.16
5.0.20.0030.0278.23
5.0.10.0070.0238.13
5.0.00.0070.0438.13
4.4.90.0070.0237.23
4.4.80.0070.0177.23
4.4.70.0070.0207.23
4.4.60.0070.0177.23
4.4.50.0000.0237.23
4.4.40.0030.0337.23
4.4.30.0000.0237.23
4.4.20.0030.0207.23
4.4.10.0100.0177.23
4.4.00.0000.0377.23
4.3.110.0030.0277.23
4.3.100.0000.0207.23
4.3.90.0000.0207.23
4.3.80.0030.0437.23
4.3.70.0000.0237.23
4.3.60.0070.0177.23
4.3.50.0000.0237.23
4.3.40.0100.0377.23
4.3.30.0000.0237.23
4.3.20.0030.0207.23
4.3.10.0030.0207.23
4.3.00.0230.0207.18

preferences:
45.87 ms | 401 KiB | 5 Q