Movielogr

movie poster

View on: IMDb | TMDb

There's Something About Mary (1998)

Directed by Bobby Farrelly, Peter Farrelly

Overview

For Ted, prom night went about as bad as it’s possible for any night to go. Thirteen years later, he finally gets another chance with his old prom date, only to run up against other suitors including the sleazy detective he hired to find her.

Rated R | Length 119 minutes

Actors

Steve Sweeney | Chris Elliott | Willie Garson | Matt Dillon | Scott Rosenberg | Jeffrey Tambor | Cameron Diaz | W. Earl Brown | Ben Stiller | Lee Evans | Lin Shaye | Markie Post | Sarah Silverman | Brett Favre | Richard Tyson | Harland Williams | Khandi Alexander | Richard Jenkins | Daniel Greene | Zen Gesner | Keith David | Jackie Flynn | Lenny Clarke | Jon Mone | David Shackelford | Jonathan Richman | Rob Moran | Steve Tyler | Cindy Oliver | David Goryl | Cory Pendergast | Tracy Anne George | Danny Murphy | Caryl Lippman West | Deborah Smith Ford | Mercy Lopez | Kris Meyer | Lori Brener | Debbie Howard | Michael Budge | James 'Sporty' Ahern | Marnie Alexenburg | Kelley Schneider | Max Murphy | Nancy Farrelly | Sean Gildea | Hillary Matthews | George Bedard | Bill Beauchene | John Stroehman | Terry Mullany | Brad Blank | Tom Leasca | Brian Mone | Paul Pelletier | Billy Smith | Jim Blake | Jevon White | Tommy Larkins | John-Eliot Jordan | A.B. Cassidy | Jesse Farrelly | Cord Newman | Ken Rogerson | Will Coogan | Herbie Flynn | Michael Burke | Heather Rosbeck | Jeffrey P. Lerner | Warren Tashjian | Kelly Roarke | Mariann Farrelly | James Gifford | Rick Michaels | Richard Fitzpatrick | Paul Homza | Maureen Griffin | Zack Lee | Valerie Bruce | Kelly O'Brien | Mike Charpentier | Peter Grundy | Michael 'The Cannon' Gannon | Peter Conway | Ann Conway | Susan O'Day | Jack Shields | Fallon Shields | Bob Grundy | Kathy Beauchene | Manny Barrows | James Gaiero | Sheila Mone | Barbara O'Connor | Tim Sheehan | Richie Balsbaugh | Tim Robbie | Providence Wissel | Ruth Michelle Meyer | Billy Meyer | Brian McGlaughlin | Pete Anicelli | Duana Knight | Meda Thomas | Jeanie Flynn | Kevin Civale | Michael Cheney | Rick Coleman | Emilio Diaz | Ed Nelson | Brian Stuebe | Don Daley | Clem Franek | Julia Hissom | Robin Gau | Monique Pelletier | Nicholas Greenbury | Andrew Greenbury | Phil Rosenberg | John Adamonis | Kyle Adamonis | Neil Pomfret | Ruth Pomfret | Josh Miller | Don Julio | Al Quinn

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0239
Total Execution Time  0.0252
  GET DATA  
No GET data exists
  MEMORY USAGE  
529,008 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6720
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0064 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('dec3988d182f21d16f58e9c2027d2707'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
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` = 6720
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len 12288 
0.0041   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` = 6720
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` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 6720
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6720 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)