Executed SQL

SELECT `RecordedVideo`.id AS `RecordedVideo_id`, `RecordedVideo`.`owningUser` AS `RecordedVideo_owningUser`, `RecordedVideo`.views AS `RecordedVideo_views`, `RecordedVideo`.length AS `RecordedVideo_length`, `RecordedVideo`.`thumbnailLocation` AS `RecordedVideo_thumbnailLocation`, `RecordedVideo`.`channelName` AS `RecordedVideo_channelName`, `RecordedVideo`.topic AS `RecordedVideo_topic`, `RecordedVideo`.`videoDate` AS `RecordedVideo_videoDate`, user.`pictureLocation` AS `user_pictureLocation`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelName` AS `ChanName` FROM `RecordedVideo` INNER JOIN `Channel` ON `RecordedVideo`.`channelID` = `Channel`.id INNER JOIN user ON `RecordedVideo`.`owningUser` = user.id WHERE `RecordedVideo`.pending = false AND `RecordedVideo`.published = true ORDER BY `RecordedVideo`.views DESC LIMIT %(param_1)s

Original query duration

1.1461 ms

RECORDEDVIDEO_ID	RECORDEDVIDEO_OWNINGUSER	RECORDEDVIDEO_VIEWS	RECORDEDVIDEO_LENGTH	RECORDEDVIDEO_THUMBNAILLOCATION	RECORDEDVIDEO_CHANNELNAME	RECORDEDVIDEO_TOPIC	RECORDEDVIDEO_VIDEODATE	USER_PICTURELOCATION	CHANNEL_PROTECTED	CHANNAME
2	1	566	12.0033	d0898601-3ba4-4b0a-a020-59c2cb63b677/96423a6e-89df-4028-8e00-13b5f515c0b7_20230415_145841.png	ENCOM Logo	1	2023-04-15 14:58:41	05bc3f64-359e-4e8f-ae3c-c46ac0a892cb.gif	0	nFxed Gaming
3	1	9	39.4094	dcac1e8c-396b-40c2-a715-ee9e56b3fb7f/dcac1e8c-396b-40c2-a715-ee9e56b3fb7f-1683351932_20230506_004532.png	2023-05-06 05:45	3	2023-05-06 05:45:32	05bc3f64-359e-4e8f-ae3c-c46ac0a892cb.gif	1	nFluanced Code