Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

The Italian Connection (1972)

Directed by Fernando Di Leo

Most recently watched by sensoria

Overview

When a shipment of heroin disappears between Italy and New York, a small-time pimp in Milan is framed for the theft. Two professional hitmen are dispatched from New York to find him, but the real thieves want to get rid of him before the New York killers get to him to eliminate any chance of them finding out he’s the wrong man.

Rated R | Length 100 minutes

Actors

Woody Strode | Cyril Cusack | Adolfo Celi | Luciana Paluzzi | Mario Adorf | Ulli Lommel | Henry Silva | Peter Berling | Sylva Koscina | Femi Benussi | Franco Fabrizi | Lara Wendel | Giuseppe Castellano | Gianni Macchia | Giovanni Cianfriglia | Gilberto Galimberti | Francesca Romana Coluzzi | Omero Capanna | Ettore Geri | Andrea Scotti | Vittorio Fanfoni | Virgilio Ponti | Giulio Baraghini | Pietro Ceccarelli | Guerrino Crivello | Giuliano Petrelli | Jessica Dublin | Domenico Cianfriglia | Imelde Marani | Franca Sciutto | Empedocle Buzzanca | Enrico Chiappafreddo | Renato Zero | Lina Franchi | Alberto Fogliani | Clemente Ukmar | Pasquale Fasciano | Sergio Ammirata | Diomira Vidotto

  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Overview / Movie Detail )  0.0228
Total Execution Time  0.0241
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,720 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4135
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0049 seconds)  (Hide)
0.0005   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'd567292283fc725f244e3ffa8676355942fd89b4'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('f3c7f8883e876857468f5e35bc4f86fa', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd567292283fc725f244e3ffa8676355942fd89b4'
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` = 4135
 LIMIT 1 
0.0004   SET SESSION group_concat_max_len = 12288 
0.0021   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` = 4135
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0005   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` = 4135
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4135 
0.0003   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)