Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* MediaList Query */ SELECT `data_mediagallery`.`channel` AS `channel`, `data_mediagallery`.`length` AS duration, `data_mediagallery`.`filetype` AS `filetype`, `data_mediagallery`.`hits` AS `hits`, `data_mediagallery`.`id` AS `id`, `data_mediagallery`.`length` AS `length`, `data_mediagallery`.`message` AS `message`, `data_mediagallery`.`metadata` AS `metadata`, `data_mediagallery`.`notdeniedcomments` AS notdeniedcomments, `data_mediagallery`.`title` AS `title`, `data_mediagallery`.`uid` AS `uid`, `data_mediagallery`.`upload` AS `upload`, `users`.`user` AS user_name, `data_mediagallery`.`vhost` AS `vhost`, `data_mediagallery`.`votecount` AS `votecount` FROM data_mediagallery INNER JOIN sphinxmedia ON sphinxmedia.id = data_mediagallery.id LEFT JOIN users ON users.id = data_mediagallery.uid WHERE (1=1) AND (data_mediagallery.channelleft BETWEEN 12 AND 19) AND (data_mediagallery.context = 1) AND (data_mediagallery.hidden = 0) AND (data_mediagallery.moderationstatus IN (0,1)) AND (data_mediagallery.status IN (3)) AND (data_mediagallery.vhost = 629) AND (sphinxmedia.query='mode=extended2;index=media,mediadelta;canada bestfriends pumpkin spice fruit explosion walnut crunch coffee turkey bacon club early mornings late nights memories traditions decaf coffee friends;filter=moderationstatus,0,1;filter=vhost,629;range=channelleft,12,19;filter=status,3;filter=context,1;filter=hidden,0;sort=extended:upload DESC;limit=5;offset=0;maxmatches=1000;') ORDER BY `data_mediagallery`.`upload` DESC LIMIT 0, 5 |
- explain /* MediaList Query */ SELECT `data_mediagallery`.`channel` AS `channel`, `data_mediagallery`.`length` AS duration, `data_mediagallery`.`filetype` AS `filetype`, `data_mediagallery`.`hits` AS `hits`, `data_mediagallery`.`id` AS `id`, `data_mediagallery`.`length` AS `length`, `data_mediagallery`.`message` AS `message`, `data_mediagallery`.`metadata` AS `metadata`, `data_mediagallery`.`notdeniedcomments` AS notdeniedcomments, `data_mediagallery`.`title` AS `title`, `data_mediagallery`.`uid` AS `uid`, `data_mediagallery`.`upload` AS `upload`, `users`.`user` AS user_name, `data_mediagallery`.`vhost` AS `vhost`, `data_mediagallery`.`votecount` AS `votecount` FROM data_mediagallery INNER JOIN sphinxmedia ON sphinxmedia.id = data_mediagallery.id LEFT JOIN users ON users.id = data_mediagallery.uid WHERE (1=1) AND (data_mediagallery.channelleft BETWEEN 12 AND 19) AND (data_mediagallery.context = 1) AND (data_mediagallery.hidden = 0) AND (data_mediagallery.moderationstatus IN (0,1)) AND (data_mediagallery.status IN (3)) AND (data_mediagallery.vhost = 629) AND (sphinxmedia.query='mode=extended2;index=media,mediadelta;canada bestfriends pumpkin spice fruit explosion walnut crunch coffee turkey bacon club early mornings late nights memories traditions decaf coffee friends;filter=moderationstatus,0,1;filter=vhost,629;range=channelleft,12,19;filter=status,3;filter=context,1;filter=hidden,0;sort=extended:upload DESC;limit=5;offset=0;maxmatches=1000;') ORDER BY `data_mediagallery`.`upload` DESC LIMIT 0, 5 ;
- +----+-------------+-------------------+--------+-----------------------------------------------------------------------------------------------------------------+---------+---------+-----------------------------------+------+--------------------------------------------------------------------+
- | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
- +----+-------------+-------------------+--------+-----------------------------------------------------------------------------------------------------------------+---------+---------+-----------------------------------+------+--------------------------------------------------------------------+
- | 1 | SIMPLE | sphinxmedia | ref | query | query | 3002 | const | 3 | Using where with pushed condition; Using temporary; Using filesort |
- | 1 | SIMPLE | data_mediagallery | eq_ref | PRIMARY,vhostupload,vhostmodstatus,complexfiletype,vhostcontext,hockeynews_custom,externalcomments,vhostchannel | PRIMARY | 4 | sabretooth2.sphinxmedia.id | 1 | Using where |
- | 1 | SIMPLE | users | eq_ref | PRIMARY | PRIMARY | 4 | sabretooth2.data_mediagallery.uid | 1 | |
- +----+-------------+-------------------+--------+-----------------------------------------------------------------------------------------------------------------+---------+---------+-----------------------------------+------+--------------------------------------------------------------------+
Add Comment
Please, Sign In to add comment