Movielogr

movie poster

Average Rating: 5.5/10

View on: IMDb | TMDb

Love & Other Drugs (2010)

Directed by Edward Zwick

Most recently watched by noahphex, suspectk

Overview

Maggie is an alluring free spirit who won’t let anyone – or anything – tie her down. But she meets her match in Jamie, whose relentless and nearly infallible charm serves him well with the ladies and the cutthroat world of pharmaceutical sales. Maggie and Jamie’s evolving relationship takes them both by surprise, as they find themselves under the influence of the ultimate drug: love.

Rated R | Length 112 minutes

Actors

Jake Gyllenhaal | Anne Hathaway | Kimberly Scott | Hank Azaria | Gabriel Macht | Oliver Platt | Deidre Goodwin | George Segal | Jill Clayburgh | Judy Greer | Katheryn Winnick | Peter Friedman | Josh Gad | Kate Jennings Grant | Nikki DeLoach | Jaimie Alexander | Michael Buffer | Loretta Higgins | Brian Hutchison | Conan O'Brien | Scott Cohen | Michael Chernus | Rick Applegate | Joe Forgione | Aaron Bernard | Bingo O'Malley | Kevin McClatchy | David Dale McCue | Geneva Carr | Vanessa Aspillaga | Natalie Gold | Sharon Wilkins | Constance Brenneman | Ian Harding | Ian Novick | Teri Clark | Maximilian Osinski | Harry O'Toole | John W. Iwanonkiw | Robert R. Bell | Lisa Ann Goldsmith | Morgan Wolk | Jo Newman | Maïté Schwartz | Michael Benjamin Washington | Kyle Fields | Larissa Emanuele | Megan Ferguson | Dorothy Silver | Tess Soltau | Kate Easton | Jennifer Delaeo | Joan Augustin | Ray Godshall Sr. | Nayli Russo | Mark Golik | Alissa Collins | Jean Zarzour | David Morse | Nicole Perrone | Lucy Roucis | Josh Breslow | Nicole Thomas | Jasper Soffer | Kwame Rakes | Dana Dancho | Patricia Cray | Kristin Spatafore | Christina Fandino | Diedra Arthur-O'Ree | Stephanie Bankosh | David Barckhoff | Ralph Browning | Nicole George | Ryan Goimarac | Sharyn Kmieciak | Wayne Leya | Christian Pearson | Chris A. Riskus | Michael K. Sieg | Laura Welsh | Brooke Miyasaki | Kimberly M. Rizzo | Jackson Nunn | Jason Bernard | Gwyneth E. Larsen

  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Movie Detail )  0.0228
Total Execution Time  0.0246
  GET DATA  
No GET data exists
  MEMORY USAGE  
529,816 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3362
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0051 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '5451bb98abafdef88edc72627dd3bde3239bfcec'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('5c24173565d226510fab4de758bef2a7'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5451bb98abafdef88edc72627dd3bde3239bfcec'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 3362
 LIMIT 1 
0.0006   SET SESSION group_concat_max_len 12288 
0.0023   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` = 3362
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` = 3362
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3362 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 13 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)