Movielogr

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

Dogma (1999)

Directed by Kevin Smith

Most recently watched by sleestakk

Overview

The latest battle in the eternal war between Good and Evil has come to New Jersey in the late, late 20th Century. Angels, demons, apostles and prophets (of a sort) walk among the cynics and innocents of America and duke it out for the fate of humankind.

Rated R | Length 130 minutes

Actors

Ethan Suplee | Ben Affleck | Matt Damon | Chris Rock | Salma Hayek | Alan Rickman | Bud Cort | Jonathan Gordon | Linda Fiorentino | Jason Lee | George Carlin | Jason Mewes | Kevin Smith | Dwight Ewell | Scott Mosier | Janeane Garofalo | Brian O'Halloran | Jeff Anderson | Walt Flanagan | Robert Holtzman | Guinevere Turner | Mark Joy | Monica Hampton | Derrick Sanders | Alanis Morissette | Betty Aberlin | Javon Johnson | Ernest O'Donnell | Bryan Johnson | Brendan McFadden | Kitao Sakurai | Brian Quinn | Vincent Pereira | Adrienne Wehr | Ming Chen | Dan Etheridge | Matthew Maher | Nancy Mosser | Joe Shelby | Bob Schreck | Benjamin J. Cain Jr. | Jim Mahfood | Kimberly Loughran | Nancy Bach | Barret Hackney | Jared Pfennigwerth | Joe Nozemack | J.E. Smith | Chris Kittinger | Linda Levine | Derek Milosavljevic | Lesley Braden | Armando Rodriguez | Richard Baderinwa

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0220
Total Execution Time  0.0234
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,936 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4902
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0043 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'a15090d5a8437a3fbf850af16096dd5dcbe6167d'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('5fd932da10ab59ebf7d8abedcfe4efec'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a15090d5a8437a3fbf850af16096dd5dcbe6167d'
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` = 4902
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0022   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 4902
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0002   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 4902
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4902 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)