Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Harold & Kumar Go to White Castle (2004)

Directed by Danny Leiner

Most recently watched by sleestakk, sensoria

Overview

Nerdy accountant Harold and his irrepressible friend, Kumar, get stoned watching television and find themselves utterly bewitched by a commercial for White Castle. Convinced there must be one nearby, the two set out on a late-night odyssey that takes them deep into New Jersey. Somehow, the boys manage to run afoul of rednecks, cops and even a car-stealing Neil Patrick Harris before getting anywhere near their beloved sliders.

Rated R | Length 88 minutes

Actors

Jamie Kennedy | Ryan Reynolds | Steve Braun | Anthony Anderson | Boyd Banks | Fred Willard | Paula Garcés | Christopher Meloni | David Krumholtz | Neil Patrick Harris | Brooke D'Orsay | Dov Tiefenbach | Malin Åkerman | Eddie Kaye Thomas | Kal Penn | Gary Anthony Williams | Jordan Prentice | Ethan Embry | Kate Kelton | John Cho | Jon Hurwitz | Hayden Schlossberg | Albert Howell | Shaun Majumder | Robert Tinkler | Dan Warry-Smith | Brad Borbridge | Bobby Lee | Angelo Tsarouchas | John Boylan | Thea Andrews | Siu Ta | Errol Sitahal | Sandy Jobin-Bevans | Christopher Thompson | Rick Sood | Dan Bochart | Mike Sheer | Frank Spadone | Gary Archibald

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0231
Total Execution Time  0.0246
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,344 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4751
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0039 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('c8e0d1be7b7ef1c0b017072af391beee', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
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` = 4751
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0014   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` = 4751
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` = 4751
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4751 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)