Movielogr

movie poster

View on: IMDb | TMDb

Torrente 3: The Protector (2005)

Directed by Santiago Segura

Overview

A popular and beautiful politician plans to expose the evil-doings of a multinational corporation. Hoping to silence her, the corporation’s top executives decide to hire the most incompetent detective they can find to act as her bodyguard.

Length 91 minutes

Actors

Oliver Stone | John Landis | Guillermo del Toro | Santiago Segura | Tony Leblanc | Enrique Villén | Nicolás Fernández Luna | Yvonne Sciò | Javier Gutiérrez | José Mota | Fabio Testi | Helga Liné | Iker Casillas | Iván Helguera | José María Gutiérrez | Jimmy Barnatán | Marcos Mundstock | Dani Martín | Carlos Pumares | Carlos Iglesias | Florentino Fernández | Ruth Zanon | Enrique Sarasola | Andreu Buenafuente | Carlos Latre | Marisa Medina | Chiquito de la Calzada | Silvia Gambino | Pablo Pinedo | José María Rubio | Santiago Urrialde | Luis Larrodera | Carmen Ruiz | Fernando Torres | Edda Díaz | Jaime Ordóñez | Eduardo Gómez | Eduardo García | Maite Pastor | José Ramón Zabaleta | Richy Castellanos | Cañita Brava | Xavier Deltell | Torbe | Damián Ramos | Fernando Sáez | María Dolores González | Luixy Toledo | José Manuel Moya | El Risitas | Usun Yoon | El Fary | Carola Baleztena | Mad Crampi | Juan Miguel Fernández | Jerónimo Cantero | Fernando Torrente | Paco Collado | Martin Czehmester | Nicolás Rodríguez-Villar | Jorge Segura | Orlando Abad | Santiago Barullo | Regino Arellano | José M. Grande | César Román | Héctor Alba | Methieu Fremont | Jaime Lacasa | Susana Rugama | Briguithe Valderrama | Lucía Lapiedra | María Luisa Osorio | Emiliana Olmedo | Ana María Sobrino | Hicham Malayo | Mario Calvo Gutiérrez | Bea Morillas | Vanesa Zamora | María Jesús Blascerra | Habdou Diarra | Albert Canil | Lee Lorentz | Fofito | Mami Quevedo | Fran Murcia | Juanma Ortega | Cristina Charro | Matías Prats Jr.

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Overview / Movie Detail )  0.0228
Total Execution Time  0.0248
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,056 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/7002
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0043 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '0f14f38d66fbb9c0c97efbfb543265942f201416'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('0160ea8945697e0b98276bc6faafabab'300) AS ci_session_lock 
0.0004   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '0f14f38d66fbb9c0c97efbfb543265942f201416'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 7002
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len 12288 
0.0019   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 7002
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0003   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 7002
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 7002 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)