query ist drinnen:
| 49 | dev.sqldebug | 1 | showing sql | |
und das ist der output:
querys: 8
0 SELECT * FROM settings
1 SELECT * FROM extensions WHERE active=1 AND admin=0
2 SELECT * FROM tree WHERE deleted=0 ORDER BY title ASC
3 SELECT users_login.usersid, users_login.lasttrydate, users_login.login_trial
FROM users_login
JOIN users ON (users.id = users_login.usersid)
WHERE users.name = 'admin' AND users.enabled = '1'
4 SELECT id, defaultgroup, admin, rightedit, treecache, theme, language
FROM users
WHERE users.name = 'admin' AND users.password = '5f4dcc3b5aa765d61d8327deb882cf99' AND users.enabled = '1'
LIMIT 1
5 SELECT users_login.usersid, users_login.lasttrydate, users_login.login_trial
FROM users_login
JOIN users ON (users.id = users_login.usersid)
WHERE users.name = 'admin' AND users.enabled = '1'
6 UPDATE users_login
SET login_trial = login_trial+1, lasttrydate = 1180088783
WHERE usersid = '1'
7 SELECT * FROM tree WHERE deleted=0 AND ((otherrights > 0) OR (`group`=0 AND grouprights > 0) OR (owner=0 AND userrights>0)) ORDER BY title ASC
danke
