Movielogr

Home

movie poster

View on: IMDb | TMDb

The Flintstones in Viva Rock Vegas (2000)

Directed by Brian Levant

Overview

The Flintstones are at it again. The Flintstones and the Rubbles head for Rock Vegas with Fred hoping to court the lovely Wilma. Nothing will stand in the way of love, except for the conniving Chip Rockefeller who is the playboy born in Baysville but who has made it in the cutthroat town of Rock Vegas. Will Fred win Wilma’s love?

Rated PG | Length 90 minutes

Actors

Kevin Grevioux | Stephen Baldwin | Jack McGee | Alan Cumming | Rosie O'Donnell | Irwin Keyes | Joseph Barbera | William Hanna | Mark Addy | Kristen Johnston | Jane Krakowski | Joan Collins | Thomas Gibson | Harvey Korman | Alex Meneses | Nigel John Taylor | Tony Longo | Danny Woodburn | John Stephenson | Jason Kravits | Mary Jo Smith | Mel Blanc | Taylor Negron | Kristen Stewart | Brian Mahoney | Duane Davis | John Cho | Jessica Page | Nora Burns | Steve Schirripa | Beverly Sanders | Richard Karron | David Jean Thomas | Buck Kartalian | Heather Simpson | Joel Virgel | Chene Lawson | Ted Rooney | Rachel Winfree | Mark Kubr | John Wills Martin | Cheryl Holdridge | Jim Doughan | Darlene Dillinger | Tracie Burton | Matt Griesser | Kim Timbers-Patteri | Tracie Hendricks | Brian Coughlin | Jennifer Simard | Alisa Hensley | Lucille M. Oliver | Jacqueline Case | Katherine Miller | Ann Martel Mahoney | Walter Gertz | Jennifer Arden | Jennifer Bachler | Teresa Chapman | Betsy Chang | Kristen Dinsmore | Helena Hultberg | Cristal Williams

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0222
Total Execution Time  0.0236
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,400 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6895
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0046 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '3881a0483f2d8ebe22f2d0e2e6d8ea264b1aae3c'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT GET_LOCK('ef74624ec06051b8b8efa86fe40d6c4e', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3881a0483f2d8ebe22f2d0e2e6d8ea264b1aae3c'
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` = 6895
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len = 12288 
0.0021   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` = 6895
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` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 6895
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6895 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)