Mine

EXPLAIN SELECT customer.last_name, address.phone, film.title	FROM rental INNER JOIN customer ON rental.customer_id = customer.customer_id		INNER JOIN address ON customer.address_id = address.address_id		INNER JOIN inventory ON rental.inventory_id = inventory.inventory_id		INNER JOIN film ON inventory.film_id = film.film_id	WHERE rental.return_date IS NULL		AND rental_date < CURRENT_DATE - INTERVAL film.rental_duration DAY		AND address.phone LIKE '19%'\G*************************** 1. row ***************************           id: 1  select_type: SIMPLE        table: film         type: ALLpossible_keys: PRIMARY          key: NULL      key_len: NULL          ref: NULL         rows: 1058        Extra:*************************** 2. row ***************************           id: 1  select_type: SIMPLE        table: inventory         type: refpossible_keys: PRIMARY,idx_fk_film_id          key: idx_fk_film_id      key_len: 2          ref: sakila.film.film_id         rows: 2        Extra: Using index*************************** 3. row ***************************           id: 1  select_type: SIMPLE        table: rental         type: refpossible_keys: rental_date,idx_fk_inventory_id,idx_fk_customer_id          key: idx_fk_inventory_id      key_len: 3          ref: sakila.inventory.inventory_id         rows: 1        Extra: Using where*************************** 4. row ***************************           id: 1  select_type: SIMPLE        table: customer         type: eq_refpossible_keys: PRIMARY,idx_fk_address_id          key: PRIMARY      key_len: 2          ref: sakila.rental.customer_id         rows: 1        Extra:*************************** 5. row ***************************           id: 1  select_type: SIMPLE        table: address         type: eq_refpossible_keys: PRIMARY          key: PRIMARY      key_len: 2          ref: sakila.customer.address_id         rows: 1        Extra: Using where5 rows in set (0.21 sec)