A Los Angeles un filmato per l'atteso titolo di SCEJ
No post data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`alias`, `Platform`.`description`, `Platform`.`website`, `Platform`.`created`, `Platform`.`modified` FROM `platforms` AS `Platform` WHERE `Platform`.`alias` = 'psvita' LIMIT 1 | 1 | 1 | 1 | |
| 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` = 8 AND `GamesPlatform`.`game_id` = `Game`.`id`) | 2 | 2 | 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`, `ArticlesPlatform`.`id`, `ArticlesPlatform`.`article_id`, `ArticlesPlatform`.`platform_id` FROM `articles` AS `Article` JOIN `articles_platforms` AS `ArticlesPlatform` ON (`ArticlesPlatform`.`platform_id` = 8 AND `ArticlesPlatform`.`article_id` = `Article`.`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`, `NewsPlatform`.`id`, `NewsPlatform`.`news_id`, `NewsPlatform`.`platform_id` FROM `news` AS `News` JOIN `news_platforms` AS `NewsPlatform` ON (`NewsPlatform`.`platform_id` = 8 AND `NewsPlatform`.`news_id` = `News`.`id`) | 1 | 1 | 2 | maybe slow |
| SELECT `Platform`.`id`, `Platform`.`name`, `Platform`.`alias`, `Platform`.`description`, `Platform`.`website`, `Platform`.`created`, `Platform`.`modified` FROM `platforms` AS `Platform` WHERE 1 = 1 | 7 | 7 | 1 | maybe slow |
| 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 | 6 | |
| 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 | 3 | 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 | 17 | 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`, `NewsPlatform`.`id`, `NewsPlatform`.`news_id`, `NewsPlatform`.`platform_id`, `FilterPlatform`.`id`, `FilterPlatform`.`name`, `FilterPlatform`.`alias`, `FilterPlatform`.`description`, `FilterPlatform`.`website`, `FilterPlatform`.`created`, `FilterPlatform`.`modified` 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`) LEFT JOIN `news_platforms` AS `NewsPlatform` ON (`NewsPlatform`.`news_id` = `News`.`id`) LEFT JOIN `platforms` AS `FilterPlatform` ON (`FilterPlatform`.`id` = `NewsPlatform`.`platform_id`) WHERE `News`.`publish_date` < '2013-05-22 15:35:49' AND ((`News`.`expiration_date` > '2013-05-22') OR (`News`.`expiration_date` IS NULL)) AND NOT (`News`.`stub` = '1') AND `FilterPlatform`.`alias` = 'psvita' ORDER BY `publish_date` DESC LIMIT 15 | 1 | 1 | 4 | maybe slow |
| 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` = 253 AND `NewsPlatform`.`platform_id` = `Platform`.`id`) | 1 | 1 | 1 | |
| 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-22' ORDER BY `release_date` ASC LIMIT 6 | 0 | 0 | 1 | maybe slow |
| 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-22' AND `release_date` >= '2013-05-15' ORDER BY `release_date` DESC 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`, `ArticlesPlatform`.`id`, `ArticlesPlatform`.`article_id`, `ArticlesPlatform`.`platform_id`, `FilterPlatform`.`id`, `FilterPlatform`.`name`, `FilterPlatform`.`alias`, `FilterPlatform`.`description`, `FilterPlatform`.`website`, `FilterPlatform`.`created`, `FilterPlatform`.`modified` 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`) LEFT JOIN `articles_platforms` AS `ArticlesPlatform` ON (`ArticlesPlatform`.`article_id` = `Article`.`id`) LEFT JOIN `platforms` AS `FilterPlatform` ON (`FilterPlatform`.`id` = `ArticlesPlatform`.`platform_id`) WHERE `type_id` = 1 AND `Article`.`publish_date` < '2013-05-22 15:35:49' AND ((`Article`.`expiration_date` > '2013-05-22') OR (`Article`.`expiration_date` IS NULL)) AND NOT (`Article`.`stub` = '1') AND `FilterPlatform`.`alias` = 'psvita' ORDER BY `Article`.`vote` DESC LIMIT 10 | 0 | 0 | 4 | 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`, `ArticlesPlatform`.`id`, `ArticlesPlatform`.`article_id`, `ArticlesPlatform`.`platform_id`, `FilterPlatform`.`id`, `FilterPlatform`.`name`, `FilterPlatform`.`alias`, `FilterPlatform`.`description`, `FilterPlatform`.`website`, `FilterPlatform`.`created`, `FilterPlatform`.`modified` 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`) LEFT JOIN `articles_platforms` AS `ArticlesPlatform` ON (`ArticlesPlatform`.`article_id` = `Article`.`id`) LEFT JOIN `platforms` AS `FilterPlatform` ON (`FilterPlatform`.`id` = `ArticlesPlatform`.`platform_id`) WHERE `type_id` = 1 AND `Article`.`publish_date` < '2013-05-22 15:35:49' AND ((`Article`.`expiration_date` > '2013-05-22') OR (`Article`.`expiration_date` IS NULL)) AND NOT (`Article`.`stub` = '1') AND `FilterPlatform`.`alias` = 'psvita' ORDER BY `Article`.`publish_date` DESC LIMIT 5 | 0 | 0 | 5 | maybe slow |
| 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-22 15:35:49' AND ((`Article`.`expiration_date` > '2013-05-22') OR (`Article`.`expiration_date` IS NULL)) AND NOT (`Article`.`stub` = '1') ORDER BY `Article`.`publish_date` DESC LIMIT 1 | 1 | 1 | 1 | |
| 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 | 3 | 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 | 2 | maybe slow |
| 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 | 2 | maybe slow |
| 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 |
Peak Memory Use 27.34 MB
| Message | Memory use |
|---|---|
| Component initialization | 4.27 MB |
| Controller action start | 5.37 MB |
| Controller render start | 12.53 MB |
| View render complete | 14.47 MB |
Total Request Time: 5769 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 63.97 | |
| Component initialization and startup | 11.04 | |
| Controller action | 310.12 | |
| Render Controller Action | 65.84 | |
| » Rendering View | 64.72 | |
| » » Rendering APP/View/Home/index.ctp | 18.46 | |
| » » » Rendering APP/View/Elements/latestnews.ctp | 11.24 | |
| » » » » Rendering APP/View/Elements/adsense_news.ctp | 0.12 | |
| » » Rendering APP/View/Layouts/home.ctp | 35.37 | |
| » » » Rendering APP/View/Elements/framescreen.ctp | 0.26 | |
| » » » Rendering APP/View/Elements/vociscreen.ctp | 0.47 | |
| » » » Rendering APP/View/Elements/adsense_top.ctp | 0.13 | |
| » » » Rendering APP/View/Elements/topmenu.ctp | 7.01 | |
| » » » Rendering APP/View/Elements/searchbox.ctp | 0.13 | |
| » » » Rendering APP/View/Elements/menu_platforms.ctp | 0.45 | |
| » » » Rendering APP/View/Elements/nextreleases.ctp | 7.62 | |
| » » » » Rendering APP/View/Elements/adsense_sidebar_sx.ctp | 0.17 | |
| » » » Rendering APP/View/Elements/lastspecial.ctp | 3.09 | |
| » » » Rendering APP/View/Elements/top10.ctp | 0.32 | |
| » » » Rendering APP/View/Elements/latest_reviews.ctp | 3.44 | |
| » » » » Rendering APP/View/Elements/adsense_sidebar_dx.ctp | 0.12 | |
| » » » Rendering APP/View/Elements/twitter.ctp | 1.44 | |
| » » » Rendering APP/View/Elements/footer.ctp | 0.13 | |
| » » » Rendering APP/View/Elements/link_sites.ctp | 0.19 |