Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

My Stepmother Is an Alien (1988)

Directed by Richard Benjamin

Most recently watched by noahphex

Overview

Trying to rescue her home planet from destruction, a gorgeous extraterrestrial named Celeste arrives on Earth and begins her scientific research. She woos quirky scientist Dr. Steve Mills, a widower with a young daughter. Before long, Celeste finds herself in love with Steve and her new life on Earth, where she experiences true intimacy for the first time. But when she loses sight of her mission, she begins to question where she belongs.

Rated PG-13 | Length 108 minutes

Actors

Kim Basinger | Dan Aykroyd | Earl Boen | Juliette Lewis | Harry Shearer | Suzie Plakson | Seth Green | Jon Lovitz | Joseph Maher | Alyson Hannigan | Peter Bromilow | Tony Jay | Ann Prentiss | Jim Jackman | Adrian Sparks | Maxine Wasa | Karen Haber | Wesley Mann | Jim Doughan | Tanya Fenmore | Robert Benedetti | Gabi | Kevin McDermott | Robyn Mandell | Chere Rae | Amy Kirkpatrick | James Edward Veurink | Nina Henderson | Jay McCaslin | Lisa Croisette | Sophia Bowen | Shea Bowen | Gina Raymond | Susan Carlsberg | Michele Rogers

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0254
Total Execution Time  0.0270
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,704 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4962
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0044 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('018ff58b57b009f1d2b2870c60743909', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4962
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len = 12288 
0.0020   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` = 4962
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0004   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` = 4962
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4962 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)