Recensito per voi l'ultimo capolavoro della "fantasia finale"!
Le avventure di Lighting e dei suoi prodi compagni vi resteranno nel cuore!
No post data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `Banner`.`id`, `Banner`.`caption`, `Banner`.`img_banner`, `Banner`.`article_id`, `Banner`.`news_id`, `Banner`.`link`, `Banner`.`visible`, `Banner`.`publish_date`, `Banner`.`expiration_date`, `Banner`.`modified`, `Banner`.`created`, `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`abstract`, `Article`.`body`, `Article`.`vote`, `Article`.`game_id`, `Article`.`type_id`, `Article`.`good`, `Article`.`bad`, `Article`.`expiration_date`, `Article`.`publish_date`, `Article`.`stub`, `Article`.`created`, `Article`.`modified`, `Article`.`thread_id`, `Article`.`author_id`, `Article`.`image_link`, `News`.`id`, `News`.`title`, `News`.`slug`, `News`.`body`, `News`.`abstract`, `News`.`expiration_date`, `News`.`publish_date`, `News`.`game_id`, `News`.`author_id`, `News`.`source`, `News`.`source_link`, `News`.`news_thumb`, `News`.`stub`, `News`.`created`, `News`.`modified`, `News`.`thread_id` FROM `banners` AS `Banner` LEFT JOIN `articles` AS `Article` ON (`Banner`.`article_id` = `Article`.`id`) LEFT JOIN `news` AS `News` ON (`Banner`.`news_id` = `News`.`id`) WHERE `visible` = '1' ORDER BY `Banner`.`publish_date` DESC, `Banner`.`id` DESC | 4 | 4 | 1 | maybe slow |
| SELECT `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`abstract`, `Article`.`body`, `Article`.`vote`, `Article`.`game_id`, `Article`.`type_id`, `Article`.`good`, `Article`.`bad`, `Article`.`expiration_date`, `Article`.`publish_date`, `Article`.`stub`, `Article`.`created`, `Article`.`modified`, `Article`.`thread_id`, `Article`.`author_id`, `Article`.`image_link`, `Author`.`id`, `Author`.`username`, `Author`.`password`, `Author`.`email`, `Author`.`birthdate`, `Author`.`role_id`, `Game`.`id`, `Game`.`title`, `Game`.`slug`, `Game`.`description`, `Game`.`release_date`, `Game`.`developer_id`, `Game`.`publisher_id`, `Game`.`esrb_id`, `Game`.`website`, `Game`.`img_cover`, `Game`.`image_link`, `Game`.`created`, `Game`.`modified`, `Game`.`affiliate_link`, `Type`.`id`, `Type`.`name` FROM `articles` AS `Article` LEFT JOIN `users` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `games` AS `Game` ON (`Article`.`game_id` = `Game`.`id`) LEFT JOIN `types` AS `Type` ON (`Article`.`type_id` = `Type`.`id`) WHERE `Article`.`id` = 6 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`alias`, `Platform`.`description`, `Platform`.`website`, `Platform`.`created`, `Platform`.`modified`, `ArticlesPlatform`.`id`, `ArticlesPlatform`.`article_id`, `ArticlesPlatform`.`platform_id` FROM `platforms` AS `Platform` JOIN `articles_platforms` AS `ArticlesPlatform` ON (`ArticlesPlatform`.`article_id` = 6 AND `ArticlesPlatform`.`platform_id` = `Platform`.`id`) | 0 | 0 | 1 | maybe slow |
| SELECT `News`.`id`, `News`.`title`, `News`.`slug`, `News`.`body`, `News`.`abstract`, `News`.`expiration_date`, `News`.`publish_date`, `News`.`game_id`, `News`.`author_id`, `News`.`source`, `News`.`source_link`, `News`.`news_thumb`, `News`.`stub`, `News`.`created`, `News`.`modified`, `News`.`thread_id`, `Author`.`id`, `Author`.`username`, `Author`.`password`, `Author`.`email`, `Author`.`birthdate`, `Author`.`role_id`, `Game`.`id`, `Game`.`title`, `Game`.`slug`, `Game`.`description`, `Game`.`release_date`, `Game`.`developer_id`, `Game`.`publisher_id`, `Game`.`esrb_id`, `Game`.`website`, `Game`.`img_cover`, `Game`.`image_link`, `Game`.`created`, `Game`.`modified`, `Game`.`affiliate_link` FROM `news` AS `News` LEFT JOIN `users` AS `Author` ON (`News`.`author_id` = `Author`.`id`) LEFT JOIN `games` AS `Game` ON (`News`.`game_id` = `Game`.`id`) WHERE `News`.`id` = 52 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`alias`, `Platform`.`description`, `Platform`.`website`, `Platform`.`created`, `Platform`.`modified`, `NewsPlatform`.`id`, `NewsPlatform`.`news_id`, `NewsPlatform`.`platform_id` FROM `platforms` AS `Platform` JOIN `news_platforms` AS `NewsPlatform` ON (`NewsPlatform`.`news_id` = 52 AND `NewsPlatform`.`platform_id` = `Platform`.`id`) | 1 | 1 | 1 | |
| SELECT `News`.`id`, `News`.`title`, `News`.`slug`, `News`.`body`, `News`.`abstract`, `News`.`expiration_date`, `News`.`publish_date`, `News`.`game_id`, `News`.`author_id`, `News`.`source`, `News`.`source_link`, `News`.`news_thumb`, `News`.`stub`, `News`.`created`, `News`.`modified`, `News`.`thread_id`, `Author`.`id`, `Author`.`username`, `Author`.`password`, `Author`.`email`, `Author`.`birthdate`, `Author`.`role_id`, `Game`.`id`, `Game`.`title`, `Game`.`slug`, `Game`.`description`, `Game`.`release_date`, `Game`.`developer_id`, `Game`.`publisher_id`, `Game`.`esrb_id`, `Game`.`website`, `Game`.`img_cover`, `Game`.`image_link`, `Game`.`created`, `Game`.`modified`, `Game`.`affiliate_link` FROM `news` AS `News` LEFT JOIN `users` AS `Author` ON (`News`.`author_id` = `Author`.`id`) LEFT JOIN `games` AS `Game` ON (`News`.`game_id` = `Game`.`id`) WHERE `News`.`id` = 33 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`alias`, `Platform`.`description`, `Platform`.`website`, `Platform`.`created`, `Platform`.`modified`, `NewsPlatform`.`id`, `NewsPlatform`.`news_id`, `NewsPlatform`.`platform_id` FROM `platforms` AS `Platform` JOIN `news_platforms` AS `NewsPlatform` ON (`NewsPlatform`.`news_id` = 33 AND `NewsPlatform`.`platform_id` = `Platform`.`id`) | 1 | 1 | 1 | |
| SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`alias`, `Platform`.`description`, `Platform`.`website`, `Platform`.`created`, `Platform`.`modified` FROM `platforms` AS `Platform` WHERE 1 = 1 | 7 | 7 | 0 | |
| SELECT `Game`.`id`, `Game`.`title`, `Game`.`slug`, `Game`.`description`, `Game`.`release_date`, `Game`.`developer_id`, `Game`.`publisher_id`, `Game`.`esrb_id`, `Game`.`website`, `Game`.`img_cover`, `Game`.`image_link`, `Game`.`created`, `Game`.`modified`, `Game`.`affiliate_link`, `GamesPlatform`.`id`, `GamesPlatform`.`game_id`, `GamesPlatform`.`platform_id` FROM `games` AS `Game` JOIN `games_platforms` AS `GamesPlatform` ON (`GamesPlatform`.`platform_id` IN (1, 2, 4, 5, 6, 7, 8) AND `GamesPlatform`.`game_id` = `Game`.`id`) | 229 | 229 | 4 | |
| SELECT `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`abstract`, `Article`.`body`, `Article`.`vote`, `Article`.`game_id`, `Article`.`type_id`, `Article`.`good`, `Article`.`bad`, `Article`.`expiration_date`, `Article`.`publish_date`, `Article`.`stub`, `Article`.`created`, `Article`.`modified`, `Article`.`thread_id`, `Article`.`author_id`, `Article`.`image_link`, `ArticlesPlatform`.`id`, `ArticlesPlatform`.`article_id`, `ArticlesPlatform`.`platform_id` FROM `articles` AS `Article` JOIN `articles_platforms` AS `ArticlesPlatform` ON (`ArticlesPlatform`.`platform_id` IN (1, 2, 4, 5, 6, 7, 8) AND `ArticlesPlatform`.`article_id` = `Article`.`id`) | 7 | 7 | 2 | maybe slow |
| SELECT `News`.`id`, `News`.`title`, `News`.`slug`, `News`.`body`, `News`.`abstract`, `News`.`expiration_date`, `News`.`publish_date`, `News`.`game_id`, `News`.`author_id`, `News`.`source`, `News`.`source_link`, `News`.`news_thumb`, `News`.`stub`, `News`.`created`, `News`.`modified`, `News`.`thread_id`, `NewsPlatform`.`id`, `NewsPlatform`.`news_id`, `NewsPlatform`.`platform_id` FROM `news` AS `News` JOIN `news_platforms` AS `NewsPlatform` ON (`NewsPlatform`.`platform_id` IN (1, 2, 4, 5, 6, 7, 8) AND `NewsPlatform`.`news_id` = `News`.`id`) | 334 | 334 | 11 | |
| SELECT `Game`.`slug`, `Game`.`title`, `Game`.`release_date`, `Game`.`id` FROM `games` AS `Game` LEFT JOIN `publishers` AS `Publisher` ON (`Game`.`publisher_id` = `Publisher`.`id`) LEFT JOIN `developers` AS `Developer` ON (`Game`.`developer_id` = `Developer`.`id`) WHERE `release_date` > '2013-05-19' ORDER BY `release_date` ASC LIMIT 6 | 0 | 0 | 1 | maybe slow |
| SELECT `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`abstract`, `Article`.`body`, `Article`.`vote`, `Article`.`game_id`, `Article`.`type_id`, `Article`.`good`, `Article`.`bad`, `Article`.`expiration_date`, `Article`.`publish_date`, `Article`.`stub`, `Article`.`created`, `Article`.`modified`, `Article`.`thread_id`, `Article`.`author_id`, `Article`.`image_link`, `Author`.`id`, `Author`.`username`, `Author`.`password`, `Author`.`email`, `Author`.`birthdate`, `Author`.`role_id`, `Game`.`id`, `Game`.`title`, `Game`.`slug`, `Game`.`description`, `Game`.`release_date`, `Game`.`developer_id`, `Game`.`publisher_id`, `Game`.`esrb_id`, `Game`.`website`, `Game`.`img_cover`, `Game`.`image_link`, `Game`.`created`, `Game`.`modified`, `Game`.`affiliate_link`, `Type`.`id`, `Type`.`name` FROM `articles` AS `Article` LEFT JOIN `users` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `games` AS `Game` ON (`Article`.`game_id` = `Game`.`id`) LEFT JOIN `types` AS `Type` ON (`Article`.`type_id` = `Type`.`id`) WHERE `type_id` = 1 AND `Article`.`publish_date` < '2013-05-19 18:51:23' AND ((`Article`.`expiration_date` > '2013-05-19') OR (`Article`.`expiration_date` IS NULL)) AND NOT (`Article`.`stub` = '1') ORDER BY `Article`.`vote` DESC LIMIT 10 | 1 | 1 | 1 | |
| SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`alias`, `Platform`.`description`, `Platform`.`website`, `Platform`.`created`, `Platform`.`modified`, `ArticlesPlatform`.`id`, `ArticlesPlatform`.`article_id`, `ArticlesPlatform`.`platform_id` FROM `platforms` AS `Platform` JOIN `articles_platforms` AS `ArticlesPlatform` ON (`ArticlesPlatform`.`article_id` = 7 AND `ArticlesPlatform`.`platform_id` = `Platform`.`id`) | 2 | 2 | 0 | |
| SELECT `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`abstract`, `Article`.`body`, `Article`.`vote`, `Article`.`game_id`, `Article`.`type_id`, `Article`.`good`, `Article`.`bad`, `Article`.`expiration_date`, `Article`.`publish_date`, `Article`.`stub`, `Article`.`created`, `Article`.`modified`, `Article`.`thread_id`, `Article`.`author_id`, `Article`.`image_link`, `Author`.`id`, `Author`.`username`, `Author`.`password`, `Author`.`email`, `Author`.`birthdate`, `Author`.`role_id`, `Game`.`id`, `Game`.`title`, `Game`.`slug`, `Game`.`description`, `Game`.`release_date`, `Game`.`developer_id`, `Game`.`publisher_id`, `Game`.`esrb_id`, `Game`.`website`, `Game`.`img_cover`, `Game`.`image_link`, `Game`.`created`, `Game`.`modified`, `Game`.`affiliate_link`, `Type`.`id`, `Type`.`name` FROM `articles` AS `Article` LEFT JOIN `users` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `games` AS `Game` ON (`Article`.`game_id` = `Game`.`id`) LEFT JOIN `types` AS `Type` ON (`Article`.`type_id` = `Type`.`id`) WHERE `type_id` = 1 AND `Article`.`publish_date` < '2013-05-19 18:51:23' AND ((`Article`.`expiration_date` > '2013-05-19') OR (`Article`.`expiration_date` IS NULL)) AND NOT (`Article`.`stub` = '1') ORDER BY `Article`.`publish_date` DESC LIMIT 5 | 1 | 1 | 1 | |
| SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`alias`, `Platform`.`description`, `Platform`.`website`, `Platform`.`created`, `Platform`.`modified`, `ArticlesPlatform`.`id`, `ArticlesPlatform`.`article_id`, `ArticlesPlatform`.`platform_id` FROM `platforms` AS `Platform` JOIN `articles_platforms` AS `ArticlesPlatform` ON (`ArticlesPlatform`.`article_id` = 7 AND `ArticlesPlatform`.`platform_id` = `Platform`.`id`) | 2 | 2 | 0 | |
| SELECT `Article`.`slug`, `Article`.`title`, `Article`.`abstract`, `Article`.`image_link` FROM `articles` AS `Article` LEFT JOIN `users` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) LEFT JOIN `games` AS `Game` ON (`Article`.`game_id` = `Game`.`id`) LEFT JOIN `types` AS `Type` ON (`Article`.`type_id` = `Type`.`id`) WHERE `type_id` = 2 AND `Article`.`publish_date` < '2013-05-19 18:51:23' AND ((`Article`.`expiration_date` > '2013-05-19') OR (`Article`.`expiration_date` IS NULL)) AND NOT (`Article`.`stub` = '1') ORDER BY `Article`.`publish_date` DESC LIMIT 1 | 1 | 1 | 1 |
Peak Memory Use 23.02 MB
| Message | Memory use |
|---|---|
| Component initialization | 4.27 MB |
| Controller action start | 5.35 MB |
| Controller render start | 12.50 MB |
| View render complete | 14.57 MB |
Total Request Time: 4493 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 57.95 | |
| Component initialization and startup | 13.81 | |
| Controller action | 155.83 | |
| Render Controller Action | 69.52 | |
| » Rendering View | 68.33 | |
| » » Rendering APP/View/Contact/index.ctp | 25.15 | |
| » » Rendering APP/View/Layouts/home.ctp | 27.24 | |
| » » » Rendering APP/View/Elements/framescreen.ctp | 0.26 | |
| » » » Rendering APP/View/Elements/vociscreen.ctp | 0.49 | |
| » » » Rendering APP/View/Elements/adsense_top.ctp | 0.12 | |
| » » » Rendering APP/View/Elements/adsense_topmenu.ctp | 0.12 | |
| » » » Rendering APP/View/Elements/searchbox.ctp | 0.14 | |
| » » » Rendering APP/View/Elements/menu_platforms.ctp | 0.45 | |
| » » » Rendering APP/View/Elements/nextreleases.ctp | 0.41 | |
| » » » » Rendering APP/View/Elements/adsense_sidebar_sx.ctp | 0.12 | |
| » » » Rendering APP/View/Elements/lastspecial.ctp | 0.17 | |
| » » » Rendering APP/View/Elements/top10.ctp | 0.17 | |
| » » » Rendering APP/View/Elements/latest_reviews.ctp | 4.05 | |
| » » » » Rendering APP/View/Elements/adsense_sidebar_dx.ctp | 0.13 | |
| » » » Rendering APP/View/Elements/twitter.ctp | 4.91 | |
| » » » Rendering APP/View/Elements/footer.ctp | 0.14 | |
| » » » Rendering APP/View/Elements/link_sites.ctp | 0.12 |