I have an 4 tables join query, when i execute without "where" takes like 13 seconds with where takes like 8 minutes. 

I have no idea what to do in my mind when u use where to filter improve query perfomance but i'm mistaken

```
SELECT distinct  tb_ProdutoComercial.nm_prodcomerc as tx_nome,
         tb_parceiro.id_prodcomerc_pr as id_produto
        FROM  tb_vendedor
       left join  tb_tokenidparc
       on  tb_vendedor.nu_cdVendedorS4E =  tb_tokenidparc.nu_cdVendedor4E_tk 
       left join  tb_parceiro
       on  tb_tokenidparc.nu_cdCorretoraS4E_tk =  tb_parceiro.id_corretora_pr
       left join  tb_ProdutoComercial
       on  tb_ProdutoComercial.id_prodcomerc =  tb_parceiro.id_prodcomerc_pr
      where tb_ProdutoComercial.en_status = '1'

```

[EXPLAIN With Where](https://i.stack.imgur.com/uTd2C.png)
[EXPLAIN Without Where](https://i.stack.imgur.com/clFtI.png)

I'm looking for something with the same perfomance without where