Movielogr

Home

movie poster

Rating: 3.5 stars

Seen 1 time

Seen on: 08/12/2012

View on: IMDb | TMDb

The Campaign (2012)

Directed by Jay Roach

Comedy

Most recently watched by suspectk, sleestakk

Overview

Two rival politicians compete to win an election to represent their small North Carolina congressional district in the United States House of Representatives.

Rated R | Length 85 minutes

Actors

Dan Aykroyd | John Goodman | Brian Cox | John Lithgow | Dennis Miller | Tzi Ma | Will Ferrell | Dylan McDermott | Dustin Milligan | Jason Sudeikis | Zach Galifianakis | Steve Tom | Jack McBrayer | Chris Matthews | Dane Rhodes | Mikki Val | Billy Slaughter | Bill Maher | Kevin Beard | Danny Hanemann | Marco St. John | Lance E. Nichols | Thomas Middleditch | J.D. Evermore | Joe Chrest | Trey Burvant | Karen Maruyama | Katherine LaNasa | Josh Lawson | Patrick Weathers | John Cenatiempo | Seth Morris | Kate Miner | Amelia Jackson-Gray | Mike Mizanin | Rob Mariano | Loriel Hennington | Sarah Baker | Millard Darden | Kya Haywood | Ramona Tyler | Tyne Stecklein | Paul Zies | Krystal Ellsworth | Luka Jones | Glen Warner | Scott A. Martin | Danny Vinson | Grant Goodman | John L. Armijo | Dacia Fernandez | Tara Copeland | Grant Case | P. J. Byrne | Joe Scarborough | Lawrence O'Donnell | Piers Morgan | Randy Bachman | Wolf Blitzer | Ed Schultz | Taryn Terrell | Mika Brzezinski | Bobby Tisdale | Bill Martin Williams | Kayla Jenee Radomski | Heather Lawless | Glen Hobgood | Madison Wolfe | Matt Borel | Gerry May | Randall D. Cunningham | Jason Kirkpatrick | Tom Bubrig | Mark Joyce | Chaz Smith | Frank Drank | Rowan Joseph | Aaron Jay Rome | Robert Larriviere | Gus Rhodes | Willie Geist | Colleen Craig | Leslea Fisher | Jay Oliver | Jim Sojka | Jordan Sudduth | Peaches Davis | Christine Tonry | John F. Daniel | Lee Christian | Claire Frederiksen | Brian Matney | Daniel Vincent | Harlon Miller | Amber Dawn Landrum | Brittany Perry-Russell | Parker Lovein | Carl J. Walker | Kasey Emas | Marc Lafrance | Brent Howard Knudsen | Mick Dalla-Vee | Elizabeth Diane Wells | John D. Reaves | Stephanie Dotson | Early Whitesides | Catherine Shreves | Dustan Costine | Tim Hickey | Allison Bryant | Rhonda Laizer | Julia Adams | Christi Barlow | Nick Blady | Tom Cain | Jean-Luc Charboneau | Felder Charbonnet | Jennifer Culicchia | Raymond Delaune | Christy B. Devarauxx | Jerry Esslinger Jr. | Cy Fahrenholtz | Elizabeth Foley | Leni Ford | William G. Gil | Jennifer Hinrichs | Timothy Hinrichs | Sara Kenley | Kristal Kincaid | A.J. Leitell | Jeffery Nowell | Jonathan Ray | Christine Craft Regusa | Annette Doucet Sharpe | Terry Lee Smith | Joseph Uzzell | David Michael Warren | Ever Eloise Landrum | Charles Frederick Turner | Steve Wilkins

Comments

No comments yet. Log in and be the first!

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movie Detail )  0.0238
Total Execution Time  0.0253
  GET DATA  
No GET data exists
  MEMORY USAGE  
556,152 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/suspectk/movie_detail/9141
  CLASS/METHOD  
members/movie_detail
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 17 (0.0081 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '3d4e563d90569ee6fa16df299d705a698b97914f'
AND `ip_address` = '216.73.216.111' 
0.0007   SELECT GET_LOCK('434c6d043783bc2d90d6a6386c81ab1b', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3d4e563d90569ee6fa16df299d705a698b97914f'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'suspectk'
 LIMIT 1 
0.0003   SELECT `MV`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`movie_id` = 9141
AND `MV`.`user_id` = 68
 LIMIT 1 
0.0003   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 68
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0037   SELECT `MV`.`title_id`, `MV`.`movie_id`, COUNT(DISTINCT MV.title_id) AS mv_count, `title`, `prefix`, `year`, `imdb_link`, `MT`.`imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, `genre_id_01`, `genre_id_02`, `genre_id_03`, MAX(MP.filename) AS filename, `G1`.`genre_name` AS `genre_name_01`, `G2`.`genre_name` AS `genre_name_02`, `G3`.`genre_name` AS `genre_name_03`, `date_viewed`, `notes`, `MV`.`format_id`, `FMT`.`format_name`, `MV`.`source_id`, `SRC`.`source_name`, `MV`.`device_id`, `DVC`.`device_name`, `MV`.`rating_id`, `STR`.`star_rating`, `rewatch`, 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_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_movie_posters` `MP` ON `MV`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_lookup_genres` `G1` ON `MV`.`genre_id_01` = `G1`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G2` ON `MV`.`genre_id_02` = `G2`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G3` ON `MV`.`genre_id_03` = `G3`.`genre_id`
LEFT JOIN `ml_lookup_formats` `FMT` ON `MV`.`format_id` = `FMT`.`format_id`
LEFT JOIN `ml_lookup_sources` `SRC` ON `MV`.`source_id` = `SRC`.`source_id`
LEFT JOIN `ml_lookup_devices` `DVC` ON `MV`.`device_id` = `DVC`.`device_id`
LEFT JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_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 `MV`.`movie_id` = 9141
AND `MV`.`user_id` = 68
ORDER BY `date_viewed` DESC 
0.0001   SET SESSION group_concat_max_len = 1024 
0.0002   SELECT `event_title`, `JME`.`event_id`
FROM `ml_junction_movies_events` `JME`
LEFT JOIN `ml_movie_events` `EV` ON `JME`.`event_id` = `EV`.`event_id`
WHERE `JME`.`movie_id` = 9141 
0.0002   SELECT `tag`, `JMT`.`tag_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_tags` `MT` ON `JMT`.`tag_id` = `MT`.`tag_id`
WHERE `JMT`.`movie_id` = 9141 
0.0002   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 68
 LIMIT 1 
0.0002   SELECT `rating_id`
FROM `ml_movies` `MV`
WHERE `MV`.`user_id` = 68
AND `MV`.`movie_id` = 9141
 LIMIT 1 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_five_star` `MR`
WHERE `MR`.`rating_id` = '16'
 LIMIT 1 
0.0003   SELECT `MV2`.`date_viewed`, `MV2`.`movie_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_movies` `MV2` ON `MV`.`title_id` = `MV2`.`title_id` AND `MV`.`user_id` = `MV2`.`user_id`
WHERE `MV`.`user_id` = 68
AND `MV`.`movie_id` = 9141
GROUP BY `MV2`.`movie_id`
ORDER BY `MV2`.`date_viewed` DESC 
0.0002   SELECT `comment_id`, `comment`, `commenter_id`, `timestamp`, `username`, `email_address`
FROM `ml_comments` `MC`
JOIN `ml_users` `MU` ON `MU`.`user_id` = `MC`.`commenter_id`
WHERE `movie_id` = 9141 
0.0002   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` = 5280
ORDER BY `date_viewed` DESC
 LIMIT 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)