Back to the Query Overview

Executed SQL

Statement
EXPLAIN QUERY PLAN SELECT seminar_table.seminar_id AS seminar_table_seminar_id, seminar_table.topic AS seminar_table_topic, seminar_table.url AS seminar_table_url, seminar_table.keywords AS seminar_table_keywords, seminar_table.metadesc AS seminar_table_metadesc, seminar_table.synopsis AS seminar_table_synopsis, seminar_table.description AS seminar_table_description, seminar_table.owner_id AS seminar_table_owner_id, seminar_table.approved AS seminar_table_approved, seminar_table.reviewed AS seminar_table_reviewed, seminar_table.reviewed_date AS seminar_table_reviewed_date, seminar_table.last_edited AS seminar_table_last_edited, seminar_table.datentime AS seminar_table_datentime, seminar_table.views AS seminar_table_views 
FROM seminar_table 
WHERE seminar_table.approved = 1 ORDER BY seminar_table.views DESC
 LIMIT ? OFFSET ?
Time0.3161 ms
Parameters[5, 0]

Execution Plan

SELECTIDORDERFROMDETAIL
000SCAN TABLE seminar_table (~100000 rows)
000USE TEMP B-TREE FOR ORDER BY