Executed SQL

SELECT `Clips`.id AS `Clips_id`, `Clips`.`thumbnailLocation` AS `Clips_thumbnailLocation`, `Channel`.`owningUser` AS `Channel_owningUser`, `Clips`.views AS `Clips_views`, `Clips`.length AS `Clips_length`, `Clips`.`clipName` AS `Clips_clipName`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelName` AS `Channel_channelName`, `RecordedVideo`.topic AS `RecordedVideo_topic`, `RecordedVideo`.`videoDate` AS `RecordedVideo_videoDate`, user.`pictureLocation` AS `user_pictureLocation`, `Clips`.`parentVideo` AS `Clips_parentVideo` FROM `Clips` INNER JOIN `RecordedVideo` ON `Clips`.`parentVideo` = `RecordedVideo`.id INNER JOIN `Channel` ON `Channel`.id = `RecordedVideo`.`channelID` INNER JOIN user ON user.id = `Channel`.`owningUser` WHERE `Clips`.published = true ORDER BY `Clips`.views DESC LIMIT %(param_1)s

Original query duration

1.0543 ms

CLIPS_ID	CLIPS_THUMBNAILLOCATION	CHANNEL_OWNINGUSER	CLIPS_VIEWS	CLIPS_LENGTH	CLIPS_CLIPNAME	CHANNEL_PROTECTED	CHANNEL_CHANNELNAME	RECORDEDVIDEO_TOPIC	RECORDEDVIDEO_VIDEODATE	USER_PICTURELOCATION	CLIPS_PARENTVIDEO
1	dcac1e8c-396b-40c2-a715-ee9e56b3fb7f/clips/clip-1.png	1	1	10.0	CLIP1	1	nFluanced Code	3	2023-05-06 05:45:32	05bc3f64-359e-4e8f-ae3c-c46ac0a892cb.gif	3