Re: Optimize a query

[Rick James]

How many rows are returned by that first query?
What is the value of key_buffer_size?
How much RAM do you have?

SELECT  `tbl`.*
    FROM  `jos_clothes_view_products` AS `tbl`
    WHERE  `tbl`.`cat1` != 'NULL'
      AND  `tbl`.`enabled` = '1'
    ORDER BY  `created_on` DESC , `ordering` ASC
    LIMIT  0 , 20;

might benefit from a compound index:
INDEX(created_on, ordering)