Movielogr

Home

movie poster

Average Rating: 5/10

View on: IMDb | TMDb

The X Files: I Want to Believe (2008)

Directed by Chris Carter

Most recently watched by sensoria, sleestakk

Overview

Six years after the events of The X-Files series finale, former FBI agent Doctor Dana Scully is now a staff physician at Our Lady of Sorrows, a Catholic hospital, and treating a boy named Christian who has Sandhoff disease, a terminal brain condition. FBI agent Drummy arrives to ask Scully’s help in locating Fox Mulder, the fugitive former head of the X-Files division, and says they will call off its manhunt for him if he will help investigate the disappearances of several women, including young FBI agent Monica Banan.  Mulder and Scully are called back to duty by the FBI when a former priest claims to be receiving psychic visions pertaining to a kidnapped agent.

Rated PG-13 | Length 104 minutes

Actors

Xzibit | Callum Keith Rennie | Amanda Peet | Billy Connolly | Gillian Anderson | Chris Carter | David Duchovny | Mitch Pileggi | Adam Godley | Alex Diakun | Nicki Aycox | Xantha Radley | Sarah-Jane Redmond | Donavon Stinson | Joseph Patrick Finn | Stephen E. Miller | Lorena Gale | Dave Cote | Babs Chula | Fagin Woodcock | Marco Niccoli | Carrie Ruscheinsky | Spencer Maybee | Veronika Hadrava | Denis Krasnogolov | Patrick Keating | Dion Johnstone | Christina D'Alimonte | Vanesa Tomasino | Luvia Petersen | Marci T. House | Beth Siegler | Stacee Copeland | Tom Charron | Brent O'Connor | Paul Mitton | Vanessa Morley | Celeste Insell | Lynne Burnett | Teana-Marie Smith | Michael Stevens | Roger Horchow

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0187
Total Execution Time  0.0201
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,800 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2074
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0040 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '5451bb98abafdef88edc72627dd3bde3239bfcec'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('5c24173565d226510fab4de758bef2a7', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5451bb98abafdef88edc72627dd3bde3239bfcec'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 2074
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0016   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filename, GROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directors, GROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_ids, GROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actors, GROUP_CONCAT(DISTINCT(ACT.tmdb_actor_id) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actor_ids
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movie_posters` `MP` ON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMD` ON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DR` ON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMA` ON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 2074
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0008   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 2074
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2074 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 12 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)