Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

El Mariachi (1992)

Directed by Robert Rodriguez

Most recently watched by sleestakk

Overview

El Mariachi just wants to play his guitar and carry on the family tradition. Unfortunately, the town he tries to find work in has another visitor, a killer who carries his guns in a guitar case. The drug lord and his henchmen mistake el Mariachi for the killer, Azul, and chase him around town trying to kill him and get his guitar case.

Rated R | Length 81 minutes

Actors

Carlos Gallardo | Consuelo Gómez | Jaime de Hoyos | Peter Marquardt | Juan García | Reinol Martinez | Ramiro Gomez | Fernando Martinez | María Castillo | Jesuso López | Luis Baro | Oscar Fabila | Poncho Ramon | Roberto Martinez | Manuel Acosta | Walter Vargas | Virgen Delgado | Juanita Vargas | Yolanda Puga | Jaime Rodriguez | Luis Cadena | Alfredo Martinez | Gerardo Jaquez | Mario Mata | Daniel Delgado | Rosendo Ortiz | Cesar Cadena | Jose Salinas | Robert Santoyo | Sabas Perez | Guadenico Martin | Maximo Martin | DiFonso Quezada | Manuel Vejor | Alfredo Cisneros | Alejandro Peña | Israel Reyes | Clara Scott | Samuel Quiroz | Roberto Delgado | Fermin Barron | Tito Tortuga

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