cancel
Showing results for 
Search instead for 
Did you mean: 

Different mysql queries after cache enable

Different mysql queries after cache enable

The search speed on my page is slower after enabled cache. I activated mysql log and there is big difference beetwen size of logs. Main difference is a few hundred queries in cached version  like this :

SQL: SELECT `e`.`entity_id` FROM `catalog_product_super_link` AS `l`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = l.parent_id WHERE (l.product_id IN('125769'))
SQL: SELECT `tbl_selection`.`product_id`, `tbl_selection`.`parent_product_id`, `tbl_selection`.`option_id`, `parent`.*, `tbl_option`.`required` FROM `catalog_product_bundle_selection` AS `tbl_selection`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = tbl_selection.product_id AND e.required_options=0
INNER JOIN `catalog_product_entity` AS `parent` ON tbl_selection.parent_product_id = parent.entity_id
INNER JOIN `catalog_product_bundle_option` AS `tbl_option` ON tbl_option.option_id = tbl_selection.option_id WHERE (parent.entity_id = :parent_id)
BIND: array (
':parent_id' => '125769',
)

 I have only simple products on site. There is no such queries when cache is disabled. There is any way to optimise / disable this?