CartRule runs 10'000 times

[Chill_user]

Hello to all,

I have an painfull situation during "payment" process.

I have about 10'000 queries running and 90% of them are CartRule.php class

About cartrules in BO: 39 cart rules active.

PS: 1.7.5.2

Can somebody provide some help?

Thank you

[joseantgv]

Could you paste the query executed 10.000 times?

[Chill_user]

Stopwatch SQL - 17911 queries

I noticed few queries is repeating but this one is repeating most times:

1. SELECT SQL_NO_CACHE *
   FROM uhep_cart_rule_product_rule pr
   LEFT JOIN uhep_cart_rule_product_rule_value prv ON pr.id_product_rule = prv.id_product_rule
   WHERE pr.id_product_rule_group = 224

   Path: /classes/CartRule.php:606, here is the function in CartRule.php:

   public function getProductRules($id_product_rule_group)
       {
           if (!Validate::isLoadedObject($this) || $this->product_restriction == 0) {
               return array();
           }
   
           $productRules = array();
           $results = Db::getInstance()->executeS('
   		SELECT *
   		FROM ' . _DB_PREFIX_ . 'cart_rule_product_rule pr
   		LEFT JOIN ' . _DB_PREFIX_ . 'cart_rule_product_rule_value prv ON pr.id_product_rule = prv.id_product_rule
   		WHERE pr.id_product_rule_group = ' . (int) $id_product_rule_group);
           foreach ($results as $row) {
               if (!isset($productRules[$row['id_product_rule']])) {
                   $productRules[$row['id_product_rule']] = array('type' => $row['type'], 'values' => array());
               }
               $productRules[$row['id_product_rule']]['values'][] = $row['id_item'];
           }
   
           return $productRules;
       }

   I really dont understand why this function is repeating but: IF I delete all cart rules, it runs about 3000 queries instead of 10'000-15'000 queries

Edited February 17, 2020 by Amantha Bill (see edit history)