Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Where Do We Go Now? (2011)

Directed by Nadine Labaki

Most recently watched by BTSjunkie

Overview

On a remote, isolated, unnamed Lebanese village inhabited by both Muslims and Christians. The village is surrounded by land mines and only reachable by a small bridge. As civil strife engulfed the country, the women in the village learn of this fact and try, by various means and to varying success, to keep their men in the dark, sabotaging the village radio, then destroying the village TV.

Length 110 minutes

Actors

Nadine Labaki | Claude Msawbaa | Leyla Hakim | Yvonne Maalouf | Antoinette Noufaily | Julian Farhat

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0275
Total Execution Time  0.0290
  GET DATA  
No GET data exists
  MEMORY USAGE  
506,312 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3607
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0079 seconds)  (Hide)
0.0007  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '359481d662904730536c346f76267da94198e5ed'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('2d459ce8edb4e281ebc378347f95701a', 300) AS ci_session_lock ?>
0.0035  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '359481d662904730536c346f76267da94198e5ed'
AND `ip_address` = '216.73.216.6' ?>
0.0006  
SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 3607
 LIMIT 1 ?>
0.0002  
SET SESSION group_concat_max_len = 12288 ?>
0.0015  
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` = 3607
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` = 3607
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0004  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3607 ?>
0.0003  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)