rendered paste body+----+--------------------+----------+------+----------------+----------------+---------+-------------------------------------+-------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+--------------------+----------+------+----------------+----------------+---------+-------------------------------------+-------+--------------------------+
| 1 | PRIMARY | retailer | ALL | NULL | NULL | NULL | NULL | 45 | Using where |
| 2 | DEPENDENT SUBQUERY | sales | ref | fk_retailer_id | fk_retailer_id | 4 | data_warehouse.retailer.retailer_id | 34834 | Using where; Using index |
+----+--------------------+----------+------+----------------+----------------+---------+-------------------------------------+-------+--------------------------+