Movielogr

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Zack and Miri Make a Porno (2008)

Directed by Kevin Smith

Most recently watched by noahphex, jenerator, sleestakk, sensoria

Overview

Lifelong platonic friends Zack and Miri look to solve their respective cash-flow problems by making an adult film together. As the cameras roll, however, the duo begin to sense that they may have more feelings for each other than they previously thought.

Rated R | Length 102 minutes

Actors

Elizabeth Banks | Traci Lords | Tom Savini | Justin Long | David Early | Brandon Routh | Seth Rogen | Jason Mewes | Jeff Anderson | Jennifer Schwalbach Smith | Ricky Mabe | Tyler Labine | Lauren Miller | Craig Robinson | Gerry Bednob | Milos Milicevic | Marie Blanchard | Jim Norton | Katie Morgan | Tisha Campbell-Martin | Kenny Hotz | Mattt Potter | Alice Eisner | Jean-Pierre Nutini | James W. Smith | Ricki Raxxx | Danielle Fortwangler | Lena Cheney | Katelyn Hoffman | Ashley Kunich | Jackson Nunn | Anne Wade | Edward Janda | Nicholas Lombardi | Chris Milan

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0240
Total Execution Time  0.0254
  GET DATA  
No GET data exists
  MEMORY USAGE  
516,752 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2508
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0036 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '9d8325598f67f8d000f3d634db0bb497c2ce2591'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('8db010fd09304d0a7c9043e74054db5a', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9d8325598f67f8d000f3d634db0bb497c2ce2591'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 2508
 LIMIT 1 ?>
0.0003  
SET SESSION group_concat_max_len = 12288 ?>
0.0011  
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` = 2508
GROUP BY `title_id` ?>
0.0004  
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` = 2508
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0002  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2508 ?>
0.0002  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)