Back

SQL Details

Executed SQL
EXPLAIN SELECT `RecordedVideo`.id AS `RecordedVideo_id`, `RecordedVideo`.uuid AS `RecordedVideo_uuid`, `RecordedVideo`.`videoDate` AS `RecordedVideo_videoDate`, `RecordedVideo`.`owningUser` AS `RecordedVideo_owningUser`, `RecordedVideo`.`channelName` AS `RecordedVideo_channelName`, `RecordedVideo`.`channelID` AS `RecordedVideo_channelID`, `RecordedVideo`.description AS `RecordedVideo_description`, `RecordedVideo`.topic AS `RecordedVideo_topic`, `RecordedVideo`.views AS `RecordedVideo_views`, `RecordedVideo`.length AS `RecordedVideo_length`, `RecordedVideo`.`videoLocation` AS `RecordedVideo_videoLocation`, `RecordedVideo`.`thumbnailLocation` AS `RecordedVideo_thumbnailLocation`, `RecordedVideo`.`gifLocation` AS `RecordedVideo_gifLocation`, `RecordedVideo`.pending AS `RecordedVideo_pending`, `RecordedVideo`.`allowComments` AS `RecordedVideo_allowComments`, `RecordedVideo`.published AS `RecordedVideo_published`, `RecordedVideo`.`originalStreamID` AS `RecordedVideo_originalStreamID` FROM `RecordedVideo` WHERE `RecordedVideo`.id = %(id_1)s LIMIT %(param_1)s
Original query duration
1.0829 ms
ID SELECT_TYPE TABLE TYPE POSSIBLE_KEYS KEY KEY_LEN REF ROWS EXTRA
1 SIMPLE RecordedVideo const PRIMARY PRIMARY 4 const 1