Online PHP editor | perf for KRVFT

<?php // 1- connect to db require("DatabaseConfigegb1.php"); // define quesry //StartFrom $decrypted_txt = decrypt(str_replace(" ", "+",$_GET['number'])); // $decrypted_txt = str_replace(" ", "+",$_GET['number']); if( empty($decrypted_txt) ) { die("Error in number");} if( mb_substr($decrypted_txt, 0, 2)== "20"){ $decrypted_txtnew= substr_replace($decrypted_txt, "", 0, 2); }elseif (mb_substr($decrypted_txt, 0, 4)== "0020"){ $decrypted_txtnew= substr_replace($decrypted_txt, "", 0, 4); }elseif (mb_substr($decrypted_txt, 0, 3)== "020"){ $decrypted_txtnew= substr_replace($decrypted_txt, "", 0, 3); }elseif (mb_substr($decrypted_txt, 0, 1)== "0"){ $decrypted_txtnew= substr_replace($decrypted_txt, "", 0, 1); }else{ $decrypted_txtnew= $decrypted_txt; } $query="SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('%" . $decrypted_txtnew. "') GROUP BY name UNION SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('0" . $decrypted_txtnew . "') GROUP BY name UNION SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('20" . $decrypted_txtnew . "') GROUP BY name UNION SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('0020" . $decrypted_txtnew . "') GROUP BY name "; $query1="SELECT numberphone as 'id' ,name as 'name', numberphone as 'number', addrass as 'addrass' FROM list_numbers WHERE MATCH(numberphone,name) AGAINST('20" . $decrypted_txtnew . "') GROUP BY name "; $query2="SELECT id as 'id' ,name as 'name', number as 'number', ' ' as 'addrass' FROM list_numbers WHERE MATCH(number,name) AGAINST('0020" . $decrypted_txtnew . "') AND codecoutnry='EG' GROUP BY name "; $startTime = time(); $result= mysqli_query($connecteg1, $query); $result1= mysqli_query($connecteg2, $query1); $result2= mysqli_query($connect2, $query2); if(! $result && ! $result1 && ! $result2 ) { die("Error in query");} //get data from database $output=array(); while($row= mysqli_fetch_assoc($result)) { $output[]=escapeJsonString($row); //$row['id'] } while($row2= mysqli_fetch_assoc($result2)) { $output[]=escapeJsonString($row2); } while($row1= mysqli_fetch_assoc($result1)) { $output[]=escapeJsonString($row1); } $endTime = time(); if ($output) { print( "{". "'info':'". json_encode($output) ."'}");// this will print the output in json } else{ print("error"); } function encrypt($wordEnc) { $key16 = substr("egbti23456122313", 0, 16); $key16Hex = unpack('H*', $key16); return openssl_encrypt($word, 'AES-128-CBC', $key16, 0, hex2bin($key16Hex[1])); } function decrypt($wordDec) { $key16 = substr("egbti23456122313", 0, 16); $key16Hex = unpack('H*', $key16); return openssl_decrypt($wordDec, "AES-128-CBC", $key16, 0, hex2bin($key16Hex[1])); } function escapeJsonString($value) { $escapers = array( "\"", '\'',"+"); $replacements = array(" ", " ",""); $result = str_replace($escapers, $replacements, $value); return $result; } // 4 clear mysqli_free_result($result); //5- close connection mysqli_close($connecteg1); ?>

Version	System time (s)	User time (s)	Memory (MiB)
8.3.2	0.010	0.010	21.90
8.3.1	0.009	0.009	21.77
8.3.0	0.017	0.003	18.82
8.2.15	0.012	0.006	20.70
8.2.14	0.016	0.003	22.09
8.2.13	0.012	0.003	20.51
8.2.12	0.007	0.007	19.27
8.2.11	0.003	0.017	19.39
8.2.10	0.017	0.003	18.97
8.2.9	0.009	0.006	18.95
8.2.8	0.008	0.008	19.21
8.2.7	0.019	0.003	18.73
8.2.6	0.014	0.007	18.89
8.2.5	0.012	0.003	19.18
8.2.4	0.006	0.009	18.75
8.2.3	0.010	0.007	18.84
8.2.2	0.008	0.008	18.65
8.2.1	0.000	0.016	18.79
8.2.0	0.012	0.003	18.68
8.1.27	0.004	0.011	22.36
8.1.26	0.007	0.014	22.07
8.1.25	0.011	0.004	22.31
8.1.24	0.009	0.006	18.61
8.1.23	0.016	0.006	18.40
8.1.22	0.011	0.007	18.98
8.1.21	0.012	0.009	18.59
8.1.20	0.017	0.003	18.97
8.1.19	0.013	0.010	18.80
8.1.18	0.016	0.000	18.38
8.1.17	0.007	0.015	18.86
8.1.16	0.012	0.006	18.57
8.1.15	0.014	0.010	18.85
8.1.14	0.010	0.006	18.53
8.1.13	0.009	0.006	18.72
8.1.12	0.004	0.011	18.80
8.1.11	0.011	0.004	18.63
8.1.10	0.018	0.000	19.59
8.1.9	0.007	0.011	18.38
8.1.8	0.014	0.003	19.84
8.1.7	0.010	0.007	18.53
8.1.6	0.012	0.003	18.80
8.1.5	0.015	0.000	18.71
8.1.4	0.004	0.011	18.88
8.1.3	0.007	0.007	19.16
8.1.2	0.011	0.004	20.18
8.1.1	0.012	0.003	18.88
8.1.0	0.009	0.006	18.77