Back

SQL Details

Executed SQL
SELECT users.password AS users_password, users.id AS users_id, users.username AS users_username, users.email AS users_email, users.date_joined AS users_date_joined, users.lastseen AS users_lastseen, users.birthday AS users_birthday, users.gender AS users_gender, users.website AS users_website, users.location AS users_location, users.signature AS users_signature, users.avatar AS users_avatar, users.notes AS users_notes, users.last_failed_login AS users_last_failed_login, users.login_attempts AS users_login_attempts, users.activated AS users_activated, users.theme AS users_theme, users.language AS users_language, users.post_count AS users_post_count, users.primary_group_id AS users_primary_group_id, groups_1.id AS groups_1_id, groups_1.name AS groups_1_name, groups_1.description AS groups_1_description, groups_1.admin AS groups_1_admin, groups_1.super_mod AS groups_1_super_mod, groups_1.mod AS groups_1_mod, groups_1.guest AS groups_1_guest, groups_1.banned AS groups_1_banned, groups_1.mod_edituser AS groups_1_mod_edituser, groups_1.mod_banuser AS groups_1_mod_banuser, groups_1.editpost AS groups_1_editpost, groups_1.deletepost AS groups_1_deletepost, groups_1.deletetopic AS groups_1_deletetopic, groups_1.posttopic AS groups_1_posttopic, groups_1.postreply AS groups_1_postreply 
FROM users LEFT OUTER JOIN groups AS groups_1 ON groups_1.id = users.primary_group_id ORDER BY users.id DESC
 LIMIT ? OFFSET ?
Original query duration
0.2980 ms
USERS_PASSWORD USERS_ID USERS_USERNAME USERS_EMAIL USERS_DATE_JOINED USERS_LASTSEEN USERS_BIRTHDAY USERS_GENDER USERS_WEBSITE USERS_LOCATION USERS_SIGNATURE USERS_AVATAR USERS_NOTES USERS_LAST_FAILED_LOGIN USERS_LOGIN_ATTEMPTS USERS_ACTIVATED USERS_THEME USERS_LANGUAGE USERS_POST_COUNT USERS_PRIMARY_GROUP_ID GROUPS_1_ID GROUPS_1_NAME GROUPS_1_DESCRIPTION GROUPS_1_ADMIN GROUPS_1_SUPER_MOD GROUPS_1_MOD GROUPS_1_GUEST GROUPS_1_BANNED GROUPS_1_MOD_EDITUSER GROUPS_1_MOD_BANUSER GROUPS_1_EDITPOST GROUPS_1_DELETEPOST GROUPS_1_DELETETOPIC GROUPS_1_POSTTOPIC GROUPS_1_POSTREPLY
pbkdf2:sha1:1000$eFoATIty$f2ecce7f8dba56e3842ee0d9af3f700752cb311c 2 Luryidoarrord river8hodinius@rambler.ru 2016-12-04 21:05:53.177165 2016-12-04 21:05:53.184059 None None None None None None None None 0 0 None en 0 4 4 Member The Member Group 0 0 0 0 0 0 0 1 0 0 1 1