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)
5.4.260.0040.04412.33
5.4.250.0070.03712.33
5.4.240.0080.03812.33
5.4.230.0050.03812.32
5.4.220.0070.03612.32
5.4.210.0070.03512.32
5.4.200.0080.03812.32
5.4.190.0070.03812.32
5.4.180.0060.03912.32
5.4.170.0060.03712.32
5.4.160.0070.03612.32
5.4.150.0070.04312.31
5.4.140.0090.04512.00
5.4.130.0050.05211.98
5.4.120.0030.04111.95
5.4.110.0050.04411.94
5.4.100.0080.03911.95
5.4.90.0070.04711.95
5.4.80.0040.04811.95
5.4.70.0080.03411.95
5.4.60.0050.04111.94
5.4.50.0070.04111.94
5.4.40.0070.04111.93
5.4.30.0100.04311.93
5.4.20.0060.04311.92
5.4.10.0070.04011.93
5.4.00.0090.04511.42
5.3.280.0070.04712.71
5.3.270.0080.05312.72
5.3.260.0050.04512.72
5.3.250.0090.05312.72
5.3.240.0080.04612.72
5.3.230.0070.04112.71
5.3.220.0070.03512.68
5.3.210.0100.04512.68
5.3.200.0050.04012.68
5.3.190.0050.04312.68
5.3.180.0070.04412.67
5.3.170.0070.04812.67
5.3.160.0070.03612.67
5.3.150.0070.03912.67
5.3.140.0060.03912.66
5.3.130.0070.04112.66
5.3.120.0070.03912.66
5.3.110.0060.03812.65
5.3.100.0050.03912.12
5.3.90.0050.03912.08
5.3.80.0070.03512.07
5.3.70.0040.04012.07
5.3.60.0050.03712.06
5.3.50.0050.03712.00
5.3.40.0050.04012.00
5.3.30.0070.03611.94
5.3.20.0070.04011.70
5.3.10.0070.03811.65
5.3.00.0060.04011.64

preferences:
140.08 ms | 1386 KiB | 7 Q