World Wallpapers

World Grab the RSS for this category

  • Tokyo Carousel

    Tokyo Carousel

  • Savannah Storm

    Savannah Storm

  • The Golden Dome

    The Golden Dome

  MEMORY USAGE  
6,731,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0351
Controller Execution Time ( Categories / Show )  0.8447
Total Execution Time  0.8800
  URI STRING  
/categories/show/14
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  QUERIES (104)  
0.0006  SELECT * FROM permissions WHERE parent_id = 0 ORDER BY ID DESC
0.0005  SELECT * FROM permissions WHERE parent_id = '42' ORDER BY ID ASC
0.0005  SELECT * FROM permissions WHERE parent_id = '38' ORDER BY ID ASC
0.0005  SELECT * FROM permissions WHERE parent_id = '34' ORDER BY ID ASC
0.0004  SELECT * FROM permissions WHERE parent_id = '29' ORDER BY ID ASC
0.0005  SELECT * FROM permissions WHERE parent_id = '22' ORDER BY ID ASC
0.0005  SELECT * FROM permissions WHERE parent_id = '15' ORDER BY ID ASC
0.0005  SELECT * FROM permissions WHERE parent_id = '8' ORDER BY ID ASC
0.0005  SELECT * FROM permissions WHERE parent_id = '1' ORDER BY ID ASC
0.0021  SELECT lang_key, lang_value from lang WHERE language = 'english'
0.0006  SELECT * FROM categories WHERE ID = '14'
0.0007  SELECT * FROM categories WHERE lft > '261' AND rgt < '262' ORDER BY order1 ASC
0.0021  SELECT SQL_CALC_FOUND_ROWS * FROM `wallpapers` WHERE `active` = 1 AND parent_id = 0 AND ( cat_id = 14) ORDER BY `date_added` DESC LIMIT 0, 15
0.0007  SELECT SQL_CALC_FOUND_ROWS * FROM `wallpapers` WHERE `active` = 1 AND parent_id = 0 AND ( cat_id = 14) ORDER BY `date_added` DESC LIMIT 0, 15
0.0005  SELECT * FROM categories WHERE ID = '14'
0.0006  SELECT * FROM categories WHERE ID = '14'
0.0020  SELECT ID, title, id_parent FROM categories WHERE lft < '261' AND rgt > '262' ORDER BY lft ASC
0.0006  SELECT * FROM categories WHERE ID = '14'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '261' AND rgt > '262' ORDER BY lft ASC
0.0022  SELECT * FROM categories WHERE id_parent = 14 ORDER BY order1 ASC, title
0.0015  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '596'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '261' AND rgt > '262' ORDER BY lft ASC
0.0023  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '592'
0.0021  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '586'
0.0007  SELECT * FROM categories WHERE id_parent = 0 ORDER BY order1 ASC, title
0.0005  SELECT * FROM categories WHERE ID = '2'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '1' AND rgt > '2' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '3'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '3' AND rgt > '4' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '4'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '5' AND rgt > '130' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '5'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '131' AND rgt > '132' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '6'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '133' AND rgt > '134' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '7'
0.0004  SELECT title, id_parent FROM categories WHERE lft < '135' AND rgt > '136' ORDER BY lft ASC
0.0004  SELECT * FROM categories WHERE ID = '8'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '137' AND rgt > '138' ORDER BY lft ASC
0.0006  SELECT * FROM categories WHERE ID = '9'
0.0004  SELECT title, id_parent FROM categories WHERE lft < '139' AND rgt > '148' ORDER BY lft ASC
0.0004  SELECT * FROM categories WHERE ID = '10'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '149' AND rgt > '160' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '11'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '161' AND rgt > '164' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '12'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '165' AND rgt > '258' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '13'
0.0004  SELECT title, id_parent FROM categories WHERE lft < '259' AND rgt > '260' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '14'
0.0004  SELECT title, id_parent FROM categories WHERE lft < '261' AND rgt > '262' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '24'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '263' AND rgt > '264' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '25'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '265' AND rgt > '266' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '69'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '267' AND rgt > '268' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '70'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '269' AND rgt > '270' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '71'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '271' AND rgt > '272' ORDER BY lft ASC
0.0005  SELECT * FROM categories WHERE ID = '139'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '273' AND rgt > '276' ORDER BY lft ASC
0.0017  SELECT * FROM tags WHERE ID = 1
0.0004  SELECT tag FROM tag_exclusion
0.0030  SELECT * FROM partners ORDER BY ID DESC
0.0023  SELECT DISTINCT users.*, SUM(votes.vote_value)/COUNT(votes.ID) AS score, COUNT(votes.ID) as nr_votes FROM wallpapers INNER JOIN votes ON (wallpapers.ID = votes.item_id) INNER JOIN users ON (wallpapers.user_id = users.ID) WHERE (wallpapers.active = 1) GROUP BY users.ID HAVING nr_votes > 5 ORDER BY score DESC LIMIT 10
0.0122  SELECT DISTINCT users.*, COUNT(*) AS nr FROM wallpapers INNER JOIN users ON (wallpapers.user_id = users.ID) WHERE (wallpapers.active = 1) GROUP BY users.ID ORDER BY nr DESC LIMIT 10
0.0013  SELECT * FROM categories WHERE ID = '14'
0.0057  SELECT * FROM categories WHERE ID = '14'
0.0006  SELECT * FROM categories WHERE ID = '14'
0.0405  SELECT u.* , SUM(dwloads) as total_downloads FROM ( ( SELECT wallpapers.* , COUNT(downloads.ID) AS dwloads FROM wallpapers INNER JOIN downloads ON downloads.item_id = wallpapers.ID WHERE wallpapers.parent_id = 0 GROUP BY wallpapers.ID ) UNION ALL ( SELECT wallpapers.* , COUNT(downloads.ID) AS dwloads FROM wallpapers INNER JOIN wallpapers as child ON child.parent_id = wallpapers.ID INNER JOIN downloads ON downloads.item_id = child.ID WHERE wallpapers.parent_id = 0 GROUP BY wallpapers.ID ) ) AS u GROUP BY ID ORDER BY total_downloads DESC LIMIT 10
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1582'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '274' AND rgt > '275' ORDER BY lft ASC
0.0006  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '428'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '133' AND rgt > '134' ORDER BY lft ASC
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1552'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '155' AND rgt > '156' ORDER BY lft ASC
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '373'
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '456'
0.0007  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '579'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '259' AND rgt > '260' ORDER BY lft ASC
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '449'
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1363'
0.0007  SELECT title, id_parent FROM categories WHERE lft < '153' AND rgt > '154' ORDER BY lft ASC
0.0007  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '355'
0.0013  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '474'
0.0005  SELECT wallpapers.ID, wallpapers.file_title, SUM(votes.vote_value)/COUNT(votes.ID) as score, COUNT(votes.ID) as nr_votes FROM wallpapers INNER JOIN votes ON(wallpapers.ID=votes.item_id) WHERE wallpapers.active=1 GROUP BY wallpapers.ID HAVING nr_votes > 3 ORDER BY score DESC LIMIT 10
0.0009  SELECT * FROM wallpapers WHERE active = 1 ORDER BY date_added DESC LIMIT 10
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1589'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '102' AND rgt > '103' ORDER BY lft ASC
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1588'
0.0010  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1580'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '8' AND rgt > '9' ORDER BY lft ASC
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1578'
0.0008  SELECT title, id_parent FROM categories WHERE lft < '269' AND rgt > '270' ORDER BY lft ASC
0.0009  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1574'
0.0010  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1570'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '271' AND rgt > '272' ORDER BY lft ASC
0.0011  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1568'
0.0008  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1566'
0.0005  SELECT title, id_parent FROM categories WHERE lft < '157' AND rgt > '158' ORDER BY lft ASC
0.0009  SELECT wallpapers.*, categories.lft AS lft, categories.rgt AS rgt, categories.title AS cat_title, users.Username AS Username FROM wallpapers INNER JOIN categories ON ( wallpapers.cat_id = categories.ID ) INNER JOIN users ON ( wallpapers.user_id = users.ID ) WHERE wallpapers.ID = '1564'
0.0007  SELECT title, id_parent FROM categories WHERE lft < '167' AND rgt > '168' ORDER BY lft ASC