@ 2015-11-12T04:11:23Z <?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;
$SQL_query
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
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).
Version System time (s) User time (s) Memory (MiB) 5.6.15 0.010 0.063 18.19 5.6.14 0.007 0.070 18.13 5.6.13 0.013 0.077 18.18 5.6.12 0.010 0.080 21.05 5.6.11 0.000 0.067 20.98 5.6.10 0.010 0.080 21.11 5.6.9 0.013 0.080 20.94 5.6.8 0.013 0.033 20.33 5.5.30 0.007 0.053 17.91 5.5.29 0.003 0.047 17.95 5.5.28 0.017 0.077 20.88 5.5.27 0.000 0.050 20.84 5.5.26 0.010 0.077 20.89 5.5.25 0.013 0.060 20.75 5.5.24 0.023 0.073 20.36
preferences:dark mode live preview
126.19 ms | 1398 KiB | 7 Q