# Time: 161003 17:56:46
# User@Host: Tornado[Tornado] @ localhost []
# Query_time: 53.622122  Lock_time: 0.000221 Rows_sent: 30  Rows_examined: 504570325
SET timestamp=1475506606;
SELECT `w`.*, `c`.`category_name`, `c`.`category_slug`, `c`.`category_parent_id`, `c`.`category_status`, `c`.`cFullSlug`, `c`.`cFullName`, `u`.`user_name`, `u`.`user_email`, `t`.`tags`, `d`.`total_downloads`, `v`.`total_views`, `f`.`total_favourites`, `vo`.`vote_up`, `vo`.`vote_down`
FROM `WS_wallpapers` `w`
LEFT JOIN (SELECT `t2`.*, GROUP_CONCAT(c.category_slug order by c1.lvl desc SEPARATOR '/') AS cFullSlug, GROUP_CONCAT(c.category_name order by c1.lvl desc SEPARATOR '|') AS cFullName
FROM `WS_closures` `c1`
LEFT JOIN `WS_category` `c` ON `c`.`category_seq_id` = `c1`.`ancestor`
LEFT JOIN `WS_category` `t2` ON `t2`.`category_seq_id` = `c1`.`descendant`
GROUP BY `c1`.`descendant`) as c ON `c`.`category_seq_id` = `w`.`category_seq_id`
LEFT JOIN (SELECT `tt_wid` as `tag_w_id`, `tt_tagString` as `tags`
FROM `WS_wallpapers_temp_tags`) as t ON `t`.`tag_w_id` = `w`.`wallpaper_seq_id`
LEFT JOIN (SELECT `td_count` AS `total_downloads`, `td_wid` as `wd_wid`
FROM `WS_wallpapers_temp_downloads`) as d ON `d`.`wd_wid` = `w`.`wallpaper_seq_id`
LEFT JOIN (SELECT `tv_views_count` as `total_views`, `tv_wid` as `wv_wid`
FROM `WS_wallpapers_temp_views`) as v ON `v`.`wv_wid` = `w`.`wallpaper_seq_id`
LEFT JOIN (SELECT `tf_count` AS `total_favourites`, `tf_wid` as `wf_wid`
FROM `WS_wallpapers_temp_favourites`) as f ON `f`.`wf_wid` = `w`.`wallpaper_seq_id`
LEFT JOIN (SELECT `tvd_up` AS `vote_up`, `tvd_down` AS `vote_down`, `tvd_wid` `vote_wid`
FROM `WS_wallpapers_temp_votes`) as vo ON `vo`.`vote_wid` = `w`.`wallpaper_seq_id`
LEFT JOIN `WS_user` `u` ON `u`.`user_seq_id` = `w`.`user_seq_id`
WHERE `w`.`wallpaper_status` = 1
AND `w`.`wallpaper_approved` = 1
ORDER BY `w`.`wallpaper_date_created` DESC
 LIMIT 30;
# Time: 161003 17:57:09
# User@Host: Tornado[Tornado] @ localhost []
# Query_time: 48.657780  Lock_time: 0.000235 Rows_sent: 20  Rows_examined: 504570315
SET timestamp=1475506629;
SELECT `w`.*, `c`.`category_name`, `c`.`category_slug`, `c`.`category_parent_id`, `c`.`category_status`, `c`.`cFullSlug`, `c`.`cFullName`, `u`.`user_name`, `u`.`user_email`, `t`.`tags`, `d`.`total_downloads`, `v`.`total_views`, `f`.`total_favourites`, `vo`.`vote_up`, `vo`.`vote_down`
FROM `WS_wallpapers` `w`
LEFT JOIN (SELECT `t2`.*, GROUP_CONCAT(c.category_slug order by c1.lvl desc SEPARATOR '/') AS cFullSlug, GROUP_CONCAT(c.category_name order by c1.lvl desc SEPARATOR '|') AS cFullName
FROM `WS_closures` `c1`
LEFT JOIN `WS_category` `c` ON `c`.`category_seq_id` = `c1`.`ancestor`
LEFT JOIN `WS_category` `t2` ON `t2`.`category_seq_id` = `c1`.`descendant`
GROUP BY `c1`.`descendant`) as c ON `c`.`category_seq_id` = `w`.`category_seq_id`
LEFT JOIN (SELECT `tt_wid` as `tag_w_id`, `tt_tagString` as `tags`
FROM `WS_wallpapers_temp_tags`) as t ON `t`.`tag_w_id` = `w`.`wallpaper_seq_id`
LEFT JOIN (SELECT `td_count` AS `total_downloads`, `td_wid` as `wd_wid`
FROM `WS_wallpapers_temp_downloads`) as d ON `d`.`wd_wid` = `w`.`wallpaper_seq_id`
LEFT JOIN (SELECT `tv_views_count` as `total_views`, `tv_wid` as `wv_wid`
FROM `WS_wallpapers_temp_views`) as v ON `v`.`wv_wid` = `w`.`wallpaper_seq_id`
LEFT JOIN (SELECT `tf_count` AS `total_favourites`, `tf_wid` as `wf_wid`
FROM `WS_wallpapers_temp_favourites`) as f ON `f`.`wf_wid` = `w`.`wallpaper_seq_id`
LEFT JOIN (SELECT `tvd_up` AS `vote_up`, `tvd_down` AS `vote_down`, `tvd_wid` `vote_wid`
FROM `WS_wallpapers_temp_votes`) as vo ON `vo`.`vote_wid` = `w`.`wallpaper_seq_id`
LEFT JOIN `WS_user` `u` ON `u`.`user_seq_id` = `w`.`user_seq_id`
WHERE `w`.`wallpaper_status` = 1
AND `w`.`wallpaper_approved` = 1
ORDER BY RAND()
 LIMIT 20;
# Time: 161003 18:01:27
# User@Host: root[root] @ localhost []
# Query_time: 66.765957  Lock_time: 0.000364 Rows_sent: 30  Rows_examined: 504570325
SET timestamp=1475506887;
SELECT STRAIGHT_JOIN `w`.*, `c`.`category_name`, `c`.`category_slug`, `c`.`category_parent_id`, `c`.`category_status`, `c`.`cFullSlug`, `c`.`cFullName`, `u`.`user_name`, `u`.`user_email`, `t`.`tags`, `d`.`total_downloads`, `v`.`total_views`, `f`.`total_favourites`, `vo`.`vote_up`, `vo`.`vote_down` FROM `WS_wallpapers` `w` LEFT JOIN (SELECT `t2`.*, GROUP_CONCAT(c.category_slug order by c1.lvl desc SEPARATOR '/') AS cFullSlug, GROUP_CONCAT(c.category_name order by c1.lvl desc SEPARATOR '|') AS cFullName FROM `WS_closures` `c1` LEFT JOIN `WS_category` `c` ON `c`.`category_seq_id` = `c1`.`ancestor` LEFT JOIN `WS_category` `t2` ON `t2`.`category_seq_id` = `c1`.`descendant` GROUP BY `c1`.`descendant`) as c ON `c`.`category_seq_id` = `w`.`category_seq_id` LEFT JOIN (SELECT `tt_wid` as `tag_w_id`, `tt_tagString` as `tags` FROM `WS_wallpapers_temp_tags`) as t ON `t`.`tag_w_id` = `w`.`wallpaper_seq_id` LEFT JOIN (SELECT `td_count` AS `total_downloads`, `td_wid` as `wd_wid` FROM `WS_wallpapers_temp_downloads`) as d ON `d`.`wd_wid` = `w`.`wallpaper_seq_id` LEFT JOIN (SELECT `tv_views_count` as `total_views`, `tv_wid` as `wv_wid` FROM `WS_wallpapers_temp_views`) as v ON `v`.`wv_wid` = `w`.`wallpaper_seq_id` LEFT JOIN (SELECT `tf_count` AS `total_favourites`, `tf_wid` as `wf_wid` FROM `WS_wallpapers_temp_favourites`) as f ON `f`.`wf_wid` = `w`.`wallpaper_seq_id` LEFT JOIN (SELECT `tvd_up` AS `vote_up`, `tvd_down` AS `vote_down`, `tvd_wid` `vote_wid` FROM `WS_wallpapers_temp_votes`) as vo ON `vo`.`vote_wid` = `w`.`wallpaper_seq_id` LEFT JOIN `WS_user` `u` ON `u`.`user_seq_id` = `w`.`user_seq_id` WHERE `w`.`wallpaper_status` = 1 AND `w`.`wallpaper_approved` = 1 ORDER BY `w`.`wallpaper_date_created` DESC LIMIT 30;