3v4l.org

run code in 300+ PHP versions simultaneously
<?php $timestamp = "201511"; $username= "ryan"; $password= "12345"; $SQL_query = <<<EOT SELECT reg_id as ID, what_mach_op, address, farm_breeding_mating, farm_calve, farm_drenching, farm_feed_req, farm_detect_treat_lame, farm_detect_treat_mast, if(isnull(date_begin) || year(date_begin)<=1970, null, Date_format(date_begin, '%d/%m/%Y')) as begin_date, if(isnull(date_finish) || year(date_finish)<=1970, null, Date_format(date_finish, '%d/%m/%Y')) as finish_date, country_birth, farm_calf_health, EmployeeClientNo, country_app, num_dep, if(isnull(date_birth) || year(date_birth)<=1970, null, Date_format(date_birth, '%d/%m/%Y')) as birth_date, drv_lic_n_proj_exp, email, lvl_eng, gather_exp, first_name, full_name, sex, health_prob, height, last_name, farm_mach_maint, farm_drive_motor, farm_drive_quad, farm_drv_tractor, farm_wagon, marital_status, farm_milking_herr, farm_milking_rot, farm_shed_setup, mobile_phone, nation, if(isnull(date_pass) || year(date_pass)<=1970, null, Date_format(date_pass, '%d/%m/%Y')) as expire_date, farm_fencing, farm_hay, farm_weed, list_qual, home_phone, job_position, pref_name, emplo_det, emplo_as, emplo_ref1_comp, emplo_ref1_contact, emplo_ref1_name, emplo_ref1_pos, emplo_ref2_company, emplo_ref2_contact, emplo_ref2_name, emplo_ref2_pos, emplo_contact_them, weight, facebook, skype, up_photo, up_cv, if(isnull(data_created) || year(data_created)<=1970, null, DATE_FORMAT(data_created, '%d/%m/%Y %h:%i%:%s')) as DateCreated, if(isnull(data_created) || year(data_created)<=1970, null, DATE_FORMAT(data_created, '%Y%m')) as TimeStamp FROM $tbl_name WHERE length(EmployeeClientNo) > '1' AND TimeStamp = $timestamp AND area = 'Farming' "; EOT; echo $SQL_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.70.0120.00616.75
8.3.60.0060.01216.63
8.3.50.0110.00821.80
8.3.40.0070.00718.75
8.3.30.0110.00418.67
8.3.20.0040.00420.39
8.3.10.0080.00023.70
8.3.00.0040.00419.38
8.2.180.0040.01418.29
8.2.170.0040.01122.96
8.2.160.0030.01020.42
8.2.150.0080.00024.18
8.2.140.0070.00024.66
8.2.130.0060.00319.26
8.2.120.0040.00426.35
8.2.110.0040.00419.13
8.2.100.0070.00418.09
8.2.90.0040.00419.09
8.2.80.0060.00317.97
8.2.70.0090.00317.63
8.2.60.0040.00417.90
8.2.50.0080.00018.07
8.2.40.0040.00419.27
8.2.30.0000.00820.55
8.2.20.0060.00317.69
8.2.10.0080.00018.20
8.2.00.0040.00418.12
8.1.280.0070.01325.92
8.1.270.0000.00823.91
8.1.260.0050.00228.09
8.1.250.0040.00428.09
8.1.240.0060.00323.84
8.1.230.0080.00420.80
8.1.220.0030.00717.74
8.1.210.0060.00318.77
8.1.200.0030.00617.23
8.1.190.0080.00017.25
8.1.180.0040.00418.10
8.1.170.0000.00718.78
8.1.160.0050.00221.93
8.1.150.0030.00518.75
8.1.140.0080.00019.54
8.1.130.0050.00217.58
8.1.120.0040.00417.41
8.1.110.0000.00817.44
8.1.100.0030.00317.38
8.1.90.0040.00417.29
8.1.80.0070.00017.37
8.1.70.0030.00317.35
8.1.60.0070.00017.42
8.1.50.0080.00017.43
8.1.40.0040.00417.38
8.1.30.0030.00517.47
8.1.20.0000.00817.57
8.1.10.0030.00617.47
8.1.00.0000.00717.48
8.0.300.0000.00718.77
8.0.290.0000.00716.75
8.0.280.0030.00318.48
8.0.270.0030.00317.27
8.0.260.0000.00617.18
8.0.250.0030.00517.00
8.0.240.0060.00317.08
8.0.230.0070.00016.96
8.0.220.0030.00316.86
8.0.210.0000.00717.01
8.0.200.0000.00617.01
8.0.190.0070.00016.87
8.0.180.0040.00416.88
8.0.170.0040.00416.96
8.0.160.0040.00417.07
8.0.150.0000.00716.98
8.0.140.0030.00316.81
8.0.130.0000.00513.44
8.0.120.0050.00316.98
8.0.110.0000.00717.00
8.0.100.0030.00516.85
8.0.90.0050.00216.77
8.0.80.0030.01816.96
8.0.70.0040.00416.93
8.0.60.0000.00716.98
8.0.50.0040.00416.77
8.0.30.0070.01317.03
8.0.20.0210.01217.40
8.0.10.0040.00417.07
8.0.00.0100.00716.70
7.4.330.0000.00516.67
7.4.320.0030.00316.55
7.4.300.0000.00616.46
7.4.290.0040.00416.55
7.4.280.0050.00316.53
7.4.270.0030.00316.52
7.4.260.0050.00216.56
7.4.250.0070.00016.42
7.4.240.0000.00716.52
7.4.230.0030.00316.65
7.4.220.0090.01316.48
7.4.210.0120.00616.45
7.4.200.0030.00316.38
7.4.160.0090.00616.47
7.4.150.0060.01117.40
7.4.140.0110.00917.86
7.4.130.0120.00616.55
7.4.120.0020.01516.36
7.4.110.0100.00616.48
7.4.100.0110.01216.62
7.4.90.0060.01216.55
7.4.80.0060.01219.39
7.4.70.0120.00616.64
7.4.60.0120.00316.43
7.4.50.0090.00616.42
7.4.40.0110.00616.42
7.4.30.0090.00916.48
7.4.00.0070.01314.88
7.3.330.0030.00313.25
7.3.320.0050.00013.34
7.3.310.0070.00016.39
7.3.300.0070.00016.13
7.3.290.0060.00916.34
7.3.280.0090.00616.32
7.3.270.0160.00017.40
7.3.260.0110.00616.43
7.3.240.0110.00816.48
7.3.230.0130.00316.47
7.3.210.0040.01316.40
7.3.200.0100.01116.60
7.3.190.0060.01116.30
7.3.180.0030.01316.44
7.3.170.0070.01016.54
7.3.160.0140.00316.45
7.3.120.0090.00914.76
7.3.110.0060.01314.79
7.3.100.0060.00914.80
7.3.90.0070.01014.98
7.3.80.0060.00915.14
7.3.70.0050.00814.73
7.3.60.0040.00414.74
7.3.50.0000.01114.50
7.3.40.0090.00614.84
7.3.30.0030.01014.63
7.3.20.0030.01316.61
7.3.10.0090.00616.62
7.3.00.0060.00616.66
7.2.330.0090.00916.44
7.2.320.0100.00716.55
7.2.310.0050.01016.52
7.2.300.0090.01516.48
7.2.290.0130.01016.57
7.2.250.0070.01114.85
7.2.240.0040.01415.08
7.2.230.0030.01015.03
7.2.220.0000.01415.07
7.2.210.0030.00915.03
7.2.200.0070.01014.88
7.2.190.0070.00715.00
7.2.180.0040.01114.78
7.2.170.0100.00314.95
7.2.160.0070.00714.97
7.2.150.0060.00916.70
7.2.140.0110.00016.82
7.2.130.0030.00916.66
7.2.120.0090.00316.80
7.2.110.0040.01116.73
7.2.100.0000.01616.55
7.2.90.0030.00616.53
7.2.80.0060.00916.86
7.2.70.0030.01416.84
7.2.60.0050.00916.59
7.2.50.0040.00716.53
7.2.40.0060.00316.88
7.2.30.0060.00616.60
7.2.20.0060.00616.82
7.2.10.0070.01016.57
7.2.00.0030.01017.91
7.1.330.0000.01515.79
7.1.320.0110.00015.75
7.1.310.0030.01015.52
7.1.300.0030.00915.63
7.1.290.0070.00715.74
7.1.280.0060.00315.46
7.1.270.0090.00615.45
7.1.260.0030.00915.42
7.1.250.0070.01015.38
7.1.200.0040.00815.36
7.1.100.0000.01317.89
7.1.70.0030.00717.03
7.1.60.0100.01619.48
7.1.50.0030.00716.93
7.1.00.0000.08022.31
7.0.200.1460.00714.75
7.0.60.0170.07320.07
7.0.50.0130.07317.85
7.0.40.0170.08020.24
7.0.30.0330.05720.17
7.0.20.0230.05720.13
7.0.10.0070.08320.33
7.0.00.0100.05320.04
5.6.210.0000.09020.62
5.6.200.0070.06718.12
5.6.190.0100.04020.61
5.6.180.0330.07320.33
5.6.170.0370.07020.49
5.6.160.0130.07020.48
5.6.150.0130.06718.19
5.6.140.0070.08718.11
5.6.130.0070.08318.18
5.6.120.0070.08320.94
5.6.110.0070.04721.00
5.6.100.0030.06021.08
5.6.90.0070.08720.96
5.6.80.0030.03720.56
5.5.350.3070.03720.52
5.5.340.0100.08317.97
5.5.330.0000.08320.47
5.5.320.0000.05720.29
5.5.310.0230.03720.27
5.5.300.0070.05717.96
5.5.290.0170.05718.01
5.5.280.0070.08020.89
5.5.270.0130.03020.76
5.5.260.0170.05320.86
5.5.250.0070.06020.55
5.5.240.0130.04320.15

preferences:
50.47 ms | 401 KiB | 5 Q