I am trying to optimize of website, currently my website is very slow it took almost 13 seconds in first load than it
drop to 5 seconds , all images are optimized and
css and js are merged.
Executed 199 queries in 3.1630139350891 seconds
Average query length: 0.015894542387382 seconds
Queries per second: 62.914676977038
Longest query length: 3.0591471195221
SELECT `main_table`.`entity_id`, main_table.`name`, main_table.`path`, `main_table`.`is_active`, `main_table`.`is_anchor`, `url_rewrite`.`request_path` FROM `mg_catalog_category_flat_store_5` AS `main_table` LEFT JOIN `mg_core_url_rewrite` AS `url_rewrite` ON url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND url_rewrite.store_id = 5 AND url_rewrite.id_path LIKE 'category/%' WHERE (main_table.include_in_menu = '1') AND (main_table.is_active = '1') AND (main_table.path like '1/2/%') ORDER BY `main_table`.`position` ASC
135,305 rows approx are there in
On Home page swatches are enabled on some SE posts i found that some time swatches make website a bit slow but i don't want to disable them.