******************** Script profiler ********************
Total time: 0.115962
Total SQL time: 0.011822
SQL count: 12 (selects: 8 | executes: 4)
Peak memory usage: 3.5M
Memory limit: 128M
1. user->login [class.cwebuser.php:86]
Parameters:Array
(
[user] => guest
[password] =>
[userData] => 1
)
| Result:Array
(
[userid] => 2
[alias] => guest
[name] => Default
[surname] => User
[url] =>
[autologin] => 0
[autologout] => 900
[lang] => en_GB
[refresh] => 30
[type] => 1
[theme] => default
[attempt_failed] => 0
[attempt_ip] =>
[attempt_clock] => 0
[rows_per_page] => 50
[debug_mode] => 1
[userip] => 38.107.179.221
[node] => Array
(
[name] => - unknown -
[nodeid] => 0
)
[sessionid] => b2a3391646bb5cfacc2813855c5016c4
[gui_access] => 0
)
|
SQL (0.000318):
set bytea_output = escaperequire_once() -> DBconnect() -> DBexecute()SQL (0.002044):
SELECT n.* FROM nodes n WHERE n.nodetype=1 ORDER BY n.nodeidrequire_once() -> DBselect()SQL (0.001772):
SELECT c.* FROM config c WHERE c.configid BETWEEN 000000000000000 AND 099999999999999select_config() -> DBselect()SQL (0.000206):
beginCWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionBegin() -> DBstart() -> DBexecute()SQL (0.002013):
SELECT u.userid,u.attempt_failed,u.attempt_clock,u.attempt_ip FROM users u WHERE u.alias='guest' AND u.userid BETWEEN 000000000000000 AND 099999999999999CWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->login() -> DBselect()SQL (0.001126):
SELECT g.usrgrpid FROM usrgrp g,users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid AND g.users_status=1 LIMIT 1 OFFSET 0CWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->login() -> check_perm2system() -> DBselect()SQL (0.000635):
SELECT MAX(g.gui_access) as gui_access FROM usrgrp g,users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpidCWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->login() -> DBselect()SQL (0.000435):
SELECT u.userid FROM users u WHERE u.alias='guest' AND u.passwd='d41d8cd98f00b204e9800998ecf8427e' AND u.userid BETWEEN 000000000000000 AND 099999999999999CWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->login() -> CUser->dbLogin() -> DBselect()SQL (0.001187):
INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('b2a3391646bb5cfacc2813855c5016c4',2,1337536130,0)CWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->login() -> DBexecute()SQL (0.00063):
SELECT u.userid,u.alias,u.name,u.surname,u.url,u.autologin,u.autologout,u.lang,u.refresh,u.type, u.theme,u.attempt_failed,u.attempt_ip,u.attempt_clock,u.rows_per_page FROM users u WHERE u.userid=2CWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->login() -> CUser->_getUserData() -> DBselect()SQL (0.000443):
SELECT ug.userid FROM usrgrp g,users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid AND g.debug_mode=1CWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> call_user_func() -> CUser->login() -> CUser->_getUserData() -> DBselect()SQL (0.001013):
commitCWebUser::checkAuthentication() -> CAPIObject->login() -> CAPIObject->__call() -> czbxrpc::call() -> czbxrpc::callAPI() -> czbxrpc::transactionEnd() -> DBend() -> DBcommit() -> DBexecute()