Movielogr

Home

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

Carancho (2010)

Directed by Pablo Trapero

Most recently watched by noahphex

Overview

Sosa is a lawyer who haunts hospital waiting rooms hoping to represent the victims of traffic accidents in insurance claims. When he falls in love with ambulance medic Luján, he tries to leave this dark business but the shady law firm that he works for won’t let him off that easily.

Rated R | Length 107 minutes

Actors

Pablo Trapero | Ricardo Darín | Martina Gusman | Roberto Maciel | Francisco Acosta | Darío Valenzuela | Héctor Bordoni | Carlos Weber | Graciana Chironi | Roberto Artiagoitía | Loren Acuña | Susana Varela | Gabriel Almirón | Eduardo Peralta | Jose Luis Arias | Federico Esquerro | Fabio Ronzano | Isidora Cabezón | José Manuel Espeche | Rocio Robles | Pino Siano | Pablo Galarza | Martín Trapero | Carmen Chironi | Maria Soledad Bravo | María Luz Morteo | José María Rivara | Julian Juarez | Federico Silva | Cristian De Asís | José Ramírez | Claudia Gargiulo | Miguel Ángel Olivera | Roberto Suárez | Daniela Gorosito | Paco Pilco | Gustavo Leiva | Matías Anchorena | Fernando Garín | Mariana Casalins | Guilermina Ruiz Díaz | Mariel Fiorito | Daniela Lobianco | Jesús Tola | Patricio Ferreyra | Carlos Carrozo | Néstor Quiñones | Claudio Monetti | Víctor Verdejo

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0211
Total Execution Time  0.0224
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,976 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2831
  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` = '0b31483df5a6cc6937271b63ebafab522c50b44d'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('4651f22aa9261a715de81a8574d1fe18', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '0b31483df5a6cc6937271b63ebafab522c50b44d'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 2831
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0022   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` = 2831
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` = 2831
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2831 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)