Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Happy Face Murders (1999)

Directed by Brian Trenchard-Smith

Most recently watched by noahphex

Overview

An eccentric older woman implicates her brutal & controlling lover in the murder of a young girl. Absorbed with “Murder She Wrote” and “Matlock”, she creates details of the murder from clues she picks up from the detectives on the case. Implicating herself and sentenced to jail, she then recants her testimony. But no one believes her until clues surface from the real killer that he is still out there, has killed before, and will kill again. He signs his messages with Happy Faces.

Rated R | Length 98 minutes

Actors

Emily Hampshire | Bruce Gray | Henry Thomas | Ann-Margret | Nicholas Campbell | Marg Helgenberger | David McIlwraith | Marcia Bennett | Raoul Bhaneja | Richard Blackburn | Sarain Boylan | J.C. MacKenzie | Lynne Deragon | Rick Peters | James Downing | Len Doncheff | Katya Gardner | Anthony J. Mifsud | Jackie Richardson | Vickie Papavs | Christina Collins | Sonia Dhillon Tully | Carole Mackereth | Sean Dick

  BENCHMARKS  
Loading Time: Base Classes  0.0020
Controller Execution Time ( Overview / Movie Detail )  0.0245
Total Execution Time  0.0265
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,472 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2897
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0039 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '9569bbff4de7f138de5f880ee79d0594c2a89b53'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('cd2e7828cb41c1e419246309c40c4ac5', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9569bbff4de7f138de5f880ee79d0594c2a89b53'
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` = 2897
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0014   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` = 2897
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` = 2897
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2897 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)