Online PHP editor | perf for jdoS9

<?php public function syncSocialWithPin($userinfo, &$status) { //istanzio db SLAVE e recupero l'user ID del nuovo utente sullo SLAVE $db = JFusionFactory::getDatabase($this->getJname()); $query_pin = $db->getQuery(true) ->select('id') ->from('#__users') ->where('username=' ."'$userinfo->username'"); $db->setQuery($query_pin); $user_id_pin = $db->loadResult(); // SLAVE id -> #__users //istanzio db MASTER e recupero id MASTER $database_master = JFactory::getDBO(); $select_user_id = $database_master->getQuery(true) ->select('id') ->from('#__users') ->where('username='."'$userinfo->username'"); $database_master->setQuery($select_user_id); $master_user_id = $database_master->loadResult(); // MASTER id -> #__users //Recupero info Joomsocial // $query_users_fields = $database_master->getQuery(true) // ->select('value') // ->from('#__community_fields_values') // ->where('user_id='.$master_user_id .' AND field_id=8'); // $database_master->setQuery($query_users_fields); // $masterdbresults = $database_master->loadResult(); //Joomsocial infos // controllo che la query abbia un risultato! $pinimport = new stdClass(); // obj da importare $pinimport->user_id = $user_id_pin; $pinimport->first_name = $userinfo->name; $pinimport->username = $userinfo->username; $pinimport->email = $userinfo->email; $pinimport->location = $master_user_id; $pinimport->created_date = date('Y-m-d H:i:s', time()); $pinimport->updated_date = date('Y-m-d H:i:s', time()); $pinimport->activation = ''; //TEST IT!!!! //Controllo se l'utente è già presente su social pinboard $updatedinfo = $db->getQuery(true) ->select('*') ->from('#__pin_user_settings') ->where('email='."'$userinfo->email'"); $db->setQuery($updatedinfo); $datacheck = $db->loadObjectList(); $emptycheck = (array) $datacheck; // typecasto ad array per controllare se è vuoto! // if(empty(get_object_vars($datacheck) // un 1liner per vedere se l'oggetto è vuoto if (empty($emptycheck)) { // se NON è presente INSERT tutto $db->insertObject('#__pin_user_settings', $pinimport); $status['debug']="l'utente è presente su SocialPinboard, emptycheck positivo!"; } // else if controlla ogni campo presente e vedi se è diverso da quelli passati nell'oggetto $userinfo // foreach ($datacheck as $d) { // if ($d->username != $userinfo->username) // { // $usernameupdate = $db->getQuery(true) // ->insert("'$d->username'") // ->in(#__user); // $db->setQuery($usernameupdate); // $db->query() // $db->execute() // $status['debug']= "Usernamer Modificato" .$userinfo->username. "in".$d->username; // } // // if ($d->email != $userinfo->email) // { // $emailupdate = $db->getQuery(true) // ->insert("'$d->email'") // ->in(#__user); // $db->setQuery($emailupdate); // $db->query() // $db->execute() // $status['debug']= "Email Modificato" .$userinfo->email. "in".$d->email; // } // // if ($d->first_name != $userinfo->first_name) // { // $firstnameupdate = $db->getQuery(true) // ->insert("'$d->first_name'") // ->in(#__user); // $db->setQuery($firstnameupdate); // $db->query() // $db->execute() // $status['debug']= "First_name Modificato" .$userinfo->first_name. "in".$d->first_name; // } // // if ($d->location != $userinfo->location) // { // $locationupdate = $db->getQuery(true) // ->insert("'$d->location'") // ->in(#__user); // $db->setQuery($locationupdate); // $db->query() // $db->execute() // $status['debug']= "Location Modificato" .$userinfo->location. "in".$d->location; // } // //} return $status; } /*

Version	System time (s)	User time (s)	Memory (MiB)
5.4.27	0.004	0.038	12.36
5.4.26	0.006	0.038	12.36
5.4.25	0.008	0.036	12.36
5.4.24	0.004	0.038	12.37
5.4.23	0.008	0.039	12.36
5.4.22	0.008	0.039	12.35
5.4.21	0.007	0.037	12.36
5.4.20	0.008	0.041	12.35
5.4.19	0.007	0.043	12.35
5.4.18	0.008	0.044	12.35
5.4.17	0.008	0.043	12.36
5.4.16	0.007	0.042	12.35
5.4.15	0.009	0.039	12.34
5.4.14	0.005	0.040	12.04
5.4.13	0.007	0.036	12.02
5.4.12	0.008	0.034	11.98
5.4.11	0.009	0.034	11.98
5.4.10	0.006	0.036	11.98
5.4.9	0.004	0.039	11.98
5.4.8	0.010	0.041	11.98
5.4.7	0.007	0.038	11.98
5.4.6	0.007	0.034	11.98
5.4.5	0.003	0.039	11.98
5.4.4	0.005	0.038	11.96
5.4.3	0.004	0.039	11.96
5.4.2	0.005	0.036	11.95
5.4.1	0.009	0.032	11.96
5.4.0	0.007	0.036	11.45
5.3.28	0.007	0.037	12.71
5.3.27	0.008	0.042	12.72
5.3.26	0.007	0.045	12.72
5.3.25	0.009	0.045	12.72
5.3.24	0.007	0.047	12.72
5.3.23	0.008	0.037	12.71
5.3.22	0.009	0.036	12.68
5.3.21	0.004	0.043	12.68
5.3.20	0.007	0.036	12.68
5.3.19	0.008	0.035	12.68
5.3.18	0.007	0.036	12.67
5.3.17	0.009	0.035	12.67
5.3.16	0.007	0.036	12.67
5.3.15	0.007	0.043	12.67
5.3.14	0.009	0.041	12.66
5.3.13	0.006	0.047	12.66
5.3.12	0.009	0.043	12.66
5.3.11	0.007	0.038	12.66
5.3.10	0.008	0.036	12.12
5.3.9	0.007	0.036	12.08
5.3.8	0.007	0.036	12.07
5.3.7	0.006	0.036	12.07
5.3.6	0.009	0.037	12.06
5.3.5	0.005	0.041	12.00
5.3.4	0.005	0.038	12.00
5.3.3	0.006	0.035	11.94
5.3.2	0.007	0.036	11.70
5.3.1	0.004	0.038	11.65
5.3.0	0.007	0.037	11.64