Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

36th Precinct (2004)

Directed by Olivier Marchal

Most recently watched by sensoria

Overview

The film takes place in Paris, where two cops are competing for the vacant seat of chief of police while in the middle of a search for a gang of violent thieves. The movie is directed by Olivier Marchal, a former police officer who spent 12 years with the French police before creating this story, which is taken in part from real facts that happened during the 1980s in France.

Length 111 minutes

Actors

Valeria Golino | Stéphane Metzger | Daniel Auteuil | Daniel Duval | Anne Consigny | Jo Prestia | Gérard Depardieu | André Dussollier | Mylène Demongeot | Aurore Auteuil | Mylène Jampanoï | Roschdy Zem | Ivan Franek | Cyrille Hertel | Olivier Marchal | Francis Renaud | Catherine Marchal | Guy Lecluyse | Vincent Moscato | Ludovic Berthillot | Denis Sylvain | Alain Figlarz | Christophe Rouzaud | Solène Biasch | Frédéric Maranber | Eric Defosse | Laurent Olmedo | Thierry Guerrib | Stéphane Orsolani | Anna D'Annunzio | Jean-Louis Bihoreau | Philippe Chaubet | Patrick Médioni | Lexie Kendrick | Serge Beuchat | Christine Chansou | Christian Geffroy | Stéphanie Coubard

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0220
Total Execution Time  0.0234
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,728 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4210
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0045 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '09ebdffde6304ba62c51b5f5dd6f2a37d38827de'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT GET_LOCK('d05c65cb440f72c151573ebe685ee6da', 300) AS ci_session_lock 
0.0004   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '09ebdffde6304ba62c51b5f5dd6f2a37d38827de'
AND `ip_address` = '216.73.216.137' 
0.0004   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4210
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0018   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` = 4210
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` = 4210
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4210 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)