URL SHORTENER FIX QUERIES

I always contact my hosting to find problems with my site and here is the review Hi, We don't see the queries fixed. There are still mainly two 'slow' queries which negatively affect your website's performance, as follows: 1. # Query_time: 1.731232 Lock_time: 0.000127 Rows_sent: 1 Rows_examined: 1030836 use taffixbi285kce7q; SET timestamp=1463209117; select *, count(distinct views.views_id) as ViewCount from campaigns left join views ON views.views_campaign_id = campaigns.campaigns_id left join rates on rates.rates_id = campaigns.campaigns_rates_id where campaigns.campaigns_budget_used_today < campaigns.campaigns_daily_budget and campaigns.campaigns_current_budget > 0 and campaigns.campaigns_approved = 1 and campaigns.campaigns_status = 0 and campaigns.campaigns_payment_accepted = 1 and campaigns_device = 1 or campaigns.campaigns_device = 0 and rates_location = '' or rates.rates_location IS NULL group by campaigns.campaigns_daily_budget having ViewCount <= campaigns.campaigns_ordered_views * 1000 order by campaigns.campaigns_daily_budget asc; 2. # Query_time: 0.771863 Lock_time: 0.000030 Rows_sent: 515420 Rows_examined: 515420 use taffixbi285kce7q; SET timestamp=1463209114; select * from views; ​The query at the provided screenshot is different​, "select * from views limit 0, 30". It uses 'limit', returns just 30 rows and takes 0.6ms to complete, while the query used by your script selects all the 515,420 rows, for some unknown reason, and it takes much longer, more than 700ms. It is hard to think of any reason why the script needs to download the whole table from the database, and it seems like a poor script implementation which should be fixed. ​We see both queries very frequently, ​like about 1-2 queries per second on average. Taking into account the current level of traffic at your site (1-4 requests per second), it means that almost every request to the site results in running a code which executes one of the queries, and is slow because of that. That is a serious performance flaw in your script and hopefully your developer could fix it.