Questo pezzo inaugura una serie di articoli dedicati alle software house che hanno creato delle pietre miliari nella storia dei videogiochi ma che hanno purtroppo dovuto arrendersi ai problemi economici, scivolando nell'oblio.
Iniziamo quindi parlando della francese Delphine Software.
Un breve excursus sulla storia del MMORPG e sul suo stato dell'arte
Recensito per voi l'ultimo capolavoro della "fantasia finale"!
Le avventure di Lighting e dei suoi prodi compagni vi resteranno nel cuore!
Questo pezzo inaugura una serie di articoli dedicati alle software house che hanno creato delle pietre miliari nella storia dei videogiochi ma che hanno purtroppo dovuto arrendersi ai problemi economici, scivolando nell'oblio.
Iniziamo quindi parlando della francese Delphine Software.
Torna l'ingegner Isaac Clarke, ossessionato dalla pazzia e dai terrificanti necromorfi.
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 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 | 3 | |
| 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 | 10 | |
| 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 16:35:01' 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 | |
| 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 16:35:01' 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 | 1 | maybe slow |
| SELECT `Article`.`slug`, `Article`.`title`, `Article`.`abstract` 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`.`publish_date` < '2013-05-19 16:35:01' AND ((`Article`.`expiration_date` > '2013-05-19') OR (`Article`.`expiration_date` IS NULL)) AND NOT (`Article`.`stub` = '1') ORDER BY rand() ASC LIMIT 5 | 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`.`type_id` = 2 AND `Article`.`publish_date` < '2013-05-19 16:35:01' AND `Article`.`stub` = '0' AND ((`Article`.`expiration_date` > '2013-05-19') OR (`Article`.`expiration_date` IS NULL)) ORDER BY `Article`.`publish_date` desc LIMIT 10 | 2 | 2 | 1 | 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` IN (6, 4) AND `ArticlesPlatform`.`platform_id` = `Platform`.`id`) | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` 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`.`type_id` = 2 AND `Article`.`publish_date` < '2013-05-19 16:35:01' AND `Article`.`stub` = '0' AND ((`Article`.`expiration_date` > '2013-05-19') OR (`Article`.`expiration_date` IS NULL)) | 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 | 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 | 0 | |
| 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 |
Peak Memory Use 28.39 MB
| Message | Memory use |
|---|---|
| Component initialization | 4.39 MB |
| Controller action start | 6.01 MB |
| Controller render start | 13.38 MB |
| View render complete | 15.66 MB |
Total Request Time: 5872 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 340.63 | |
| Component initialization and startup | 14.06 | |
| Controller action | 175.47 | |
| Render Controller Action | 70.72 | |
| » Rendering View | 69.34 | |
| » » Rendering APP/View/Articles/lista.ctp | 8.48 | |
| » » » Rendering APP/View/Elements/adsense_liste.ctp | 4.84 | |
| » » Rendering APP/View/Layouts/list.ctp | 31.35 | |
| » » » Rendering APP/View/Elements/framescreen.ctp | 0.25 | |
| » » » Rendering APP/View/Elements/vociscreen.ctp | 0.44 | |
| » » » Rendering APP/View/Elements/adsense_top.ctp | 0.14 | |
| » » » Rendering APP/View/Elements/adsense_topmenu.ctp | 0.11 | |
| » » » Rendering APP/View/Elements/searchbox.ctp | 0.12 | |
| » » » Rendering APP/View/Elements/menu_platforms.ctp | 0.44 | |
| » » » Rendering APP/View/Elements/nextreleases.ctp | 7.14 | |
| » » » » Rendering APP/View/Elements/adsense_sidebar_sx.ctp | 0.14 | |
| » » » Rendering APP/View/Elements/lastspecial.ctp | 3.26 | |
| » » » Rendering APP/View/Elements/top10.ctp | 0.54 | |
| » » » Rendering APP/View/Elements/randomarticle.ctp | 11.45 | |
| » » » » Rendering APP/View/Elements/adsense_sidebar_dx.ctp | 0.15 | |
| » » » Rendering APP/View/Elements/footer.ctp | 0.10 | |
| » » » Rendering APP/View/Elements/link_sites.ctp | 0.09 |