Back

SQL Details

Executed SQL
EXPLAIN QUERY PLAN
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.3211 ms
SELECTID ORDER FROM DETAIL
0 0 0 SCAN TABLE users
0 1 1 SEARCH TABLE groups AS groups_1 USING INTEGER PRIMARY KEY (rowid=?)