User 'motobelfqtmtbpre' has exceeded the 'max_questions' resource (current value: 40000)
SELECT p.`id_product` id_product
FROM `ps_product` p
INNER JOIN ps_category_product cp
ON p.id_product = cp.id_product
INNER JOIN ps_category c ON (c.id_category = cp.id_category AND
c.nleft >= 820
AND c.nright <= 821
AND c.active = 1) INNER JOIN ps_product_shop asso_shop_product
ON asso_shop_product.id_product = p.id_product
AND asso_shop_product.id_shop IN(1)
WHERE 1 AND p.active = 1 GROUP BY id_product
at line 604 in file classes/db/Db.php
598. if ($webservice_call && $errno)
599. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. Query was : '.$sql, 97);
600. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
601. {
602. if ($sql)
603. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
604. throw new PrestaShopDatabaseException($this->getMsgError());
605. }
606. }
607.
608. /**
302. if ($sql instanceof DbQuery)
303. $sql = $sql->build();
304.
305. $this->result = $this->_query($sql);
306. if (_PS_DEBUG_SQL_) {
307. $this->displayError($sql);
308. }
309. return $this->result;
310. }
311.
312. /**
Argument [0] SELECT p.`id_product` id_product FROM `ps_product` p INNER JOIN ps_category_product cp ON p.id_product = cp.id_product INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 820 AND c.nright <= 821 AND c.active = 1) INNER JOIN ps_product_shop asso_shop_product ON asso_shop_product.id_product = p.id_product AND asso_shop_product.id_shop IN(1) WHERE 1 AND p.active = 1 GROUP BY id_product
2431. }
2432.
2433. private static function query($sql_query)
2434. {
2435. if (version_compare(_PS_VERSION_,'1.5','>'))
2436. return Db::getInstance(_PS_USE_SQL_SLAVE_)->query($sql_query);
2437. else
2438. return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql_query, false);
2439. }
2440.
2441. public function getFilterBlock($selected_filters = array())
Argument [0] SELECT p.`id_product` id_product FROM `ps_product` p INNER JOIN ps_category_product cp ON p.id_product = cp.id_product INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 820 AND c.nright <= 821 AND c.active = 1) INNER JOIN ps_product_shop asso_shop_product ON asso_shop_product.id_product = p.id_product AND asso_shop_product.id_shop IN(1) WHERE 1 AND p.active = 1 GROUP BY id_product
2365. $all_products_in = self::query('
2366. SELECT p.`id_product` id_product
2367. FROM `'._DB_PREFIX_.'product` p
2368. '.$price_filter_query_in.'
2369. '.$query_filters_from.'
2370. WHERE 1 '.$query_filters_where.' GROUP BY id_product');
2371.
2372. $product_id_list = array();
2373.
2374. while ($product = DB::getInstance()->nextRow($all_products_in))
2375. $product_id_list[] = (int)$product['id_product'];
Argument [0] SELECT p.`id_product` id_product FROM `ps_product` p INNER JOIN ps_category_product cp ON p.id_product = cp.id_product INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 820 AND c.nright <= 821 AND c.active = 1) INNER JOIN ps_product_shop asso_shop_product ON asso_shop_product.id_product = p.id_product AND asso_shop_product.id_shop IN(1) WHERE 1 AND p.active = 1 GROUP BY id_product
3788.
3789. public function getProducts($selected_filters, &$products, &$nb_products, &$p, &$n, &$pages_nb, &$start, &$stop, &$range)
3790. {
3791. global $cookie;
3792.
3793. $products = $this->getProductByFilters($selected_filters);
3794. $products = Product::getProductsProperties((int)$cookie->id_lang, $products);
3795.
3796. $nb_products = $this->nbr_products;
3797. $range = 2; /* how many pages around page selected */
3798.
Argument [0]
Array
(
[category] => Array
(
)
)
477. if (is_array($filter_block['title_values']))
478. foreach ($filter_block['title_values'] as $key => $val)
479. $title .= ' – '.$key.' '.implode('/', $val);
480.
481. $smarty->assign('categoryNameComplement', $title);
482. $this->getProducts($selected_filters, $params['catProducts'], $params['nbProducts'], $p, $n, $pages_nb, $start, $stop, $range);
483. // Need a nofollow on the pagination links?
484. $smarty->assign('no_follow', $filter_block['no_follow']);
485. }
486.
487. public function hookAfterSaveProduct($params)
Argument [0]
Array
(
[category] => Array
(
)
)
Argument [1]
Array
(
)
Argument [2]
Argument [3]
Argument [4]
Argument [5]
Argument [6]
Argument [7]
Argument [8]
369. $time_start2 = microtime(true);
370. // Call hook method
371. if ($hook_callable)
372. $display = $moduleInstance->{'hook'.$hook_name}($hookArgs);
373. else if ($hook_retro_callable)
374. $display = $moduleInstance->{'hook'.$retro_hook_name}($hookArgs);
375. $time_end = microtime(true);
376. $delay = $time_end - $time_start2;
377. if($delay > 0.1) {
378. $delay = $time_end - $time_start;
379. // error_log(__FILE__ . ' ' . __LINE__ . ' ' . $delay . ' ' . 'hook'.$hook_name . ' ' . $array['module']);
Argument [0]
Array
(
[nbProducts] =>
[catProducts] => Array
(
)
[hookExecuted] => 1
[cookie] => Cookie Object
(
[_content:protected] => Array
(
[date_add] => 2025-12-25 21:35:41
[id_lang] => 4
[id_currency] => 1
[last_visited_category] => 677
[viewed] => 8130
)
[_name:protected] => 9ffb800e76372160cbb02415dccd7dec
[_expire:protected] => 1768422944
[_domain:protected] => www.motobel.fr
[_path:protected] => /
[_cipherTool:protected] => Rijndael Object
(
[_key:protected] => rvUDbYI459NJcS1aso30RCsjKuNfWogd
[_iv:protected] => eâxû¤@Š2ì% µàÀäZ
)
[_key:protected] => 2foI3Yh6FaLaoun9kvM1ixgrCxR6RQ9wd8G9tDpzIKVTI9eSCjuIJaEc
[_iv:protected] => fTLNORxn
[_modified:protected] =>
)
[cart] => Cart Object
(
[id] =>
[id_group_shop] => 1
[id_shop] => 1
[id_address_delivery] => 0
[id_address_invoice] => 0
[id_currency] => 1
[id_customer] =>
[id_guest] => 0
[id_lang] => 4
[recyclable] => 1
[gift] => 0
[gift_message] =>
[date_add] =>
[secure_key] =>
[id_carrier] => 0
[date_upd] =>
[checkedTos] =>
[pictures] =>
[textFields] =>
[delivery_option] =>
[allow_seperated_package] =>
[_products:protected] =>
[_taxCalculationMethod:protected] => 0
[webserviceParameters:protected] => Array
(
[fields] => Array
(
[id_address_delivery] => Array
(
[xlink_resource] => addresses
)
[id_address_invoice] => Array
(
[xlink_resource] => addresses
)
[id_currency] => Array
(
[xlink_resource] => currencies
)
[id_customer] => Array
(
[xlink_resource] => customers
)
[id_guest] => Array
(
[xlink_resource] => guests
)
[id_lang] => Array
(
[xlink_resource] => languages
)
)
[associations] => Array
(
[cart_rows] => Array
(
[resource] => cart_row
[virtual_entity] => 1
[fields] => Array
(
[id_product] => Array
(
[required] => 1
[xlink_resource] => products
)
[id_product_attribute] => Array
(
[required] => 1
[xlink_resource] => combinations
)
[quantity] => Array
(
[required] => 1
)
)
)
)
)
[get_shop_from_context:ObjectModelCore:private] => 1
[table:protected] => cart
[identifier:protected] => id_cart
[fieldsRequired:protected] => Array
(
[0] => id_currency
[1] => id_lang
)
[fieldsSize:protected] => Array
(
[secure_key] => 32
)
[fieldsValidate:protected] => Array
(
[id_group_shop] => isUnsignedId
[id_shop] => isUnsignedId
[id_address_delivery] => isUnsignedId
[id_address_invoice] => isUnsignedId
[id_carrier] => isUnsignedId
[id_currency] => isUnsignedId
[id_customer] => isUnsignedId
[id_guest] => isUnsignedId
[id_lang] => isUnsignedId
[recyclable] => isBool
[gift] => isBool
[gift_message] => isMessage
[allow_seperated_package] => isBool
[date_add] => isDateFormat
[date_upd] => isDateFormat
)
[fieldsRequiredLang:protected] => Array
(
)
[fieldsSizeLang:protected] => Array
(
)
[fieldsValidateLang:protected] => Array
(
)
[tables:protected] => Array
(
)
[image_dir:protected] =>
[image_format:protected] => jpg
[def:protected] => Array
(
[table] => cart
[primary] => id_cart
[fields] => Array
(
[id_group_shop] => Array
(
[type] => 1
[validate] => isUnsignedId
)
[id_shop] => Array
(
[type] => 1
[validate] => isUnsignedId
)
[id_address_delivery] => Array
(
[type] => 1
[validate] => isUnsignedId
)
[id_address_invoice] => Array
(
[type] => 1
[validate] => isUnsignedId
)
[id_carrier] => Array
(
[type] => 1
[validate] => isUnsignedId
)
[id_currency] => Array
(
[type] => 1
[validate] => isUnsignedId
[required] => 1
)
[id_customer] => Array
(
[type] => 1
[validate] => isUnsignedId
)
[id_guest] => Array
(
[type] => 1
[validate] => isUnsignedId
)
[id_lang] => Array
(
[type] => 1
[validate] => isUnsignedId
[required] => 1
)
[recyclable] => Array
(
[type] => 2
[validate] => isBool
)
[gift] => Array
(
[type] => 2
[validate] => isBool
)
[gift_message] => Array
(
[type] => 3
[validate] => isMessage
)
[delivery_option] => Array
(
[type] => 3
)
[secure_key] => Array
(
[type] => 3
[size] => 32
)
[allow_seperated_package] => Array
(
[type] => 2
[validate] => isBool
)
[date_add] => Array
(
[type] => 5
[validate] => isDateFormat
)
[date_upd] => Array
(
[type] => 5
[validate] => isDateFormat
)
)
[classname] => Cart Object
*RECURSION*
)
)
[altern] => 1
)
184. $hookExecuted = false;
185. Hook::exec('actionProductListOverride', array(
186. 'nbProducts' => &$this->nbProducts,
187. 'catProducts' => &$this->cat_products,
188. 'hookExecuted' => &$hookExecuted,
189. ));
190.
191. // The hook was not executed, standard working
192. if (!$hookExecuted)
193. {
194. $this->context->smarty->assign('categoryNameComplement', '');
Argument [0]
actionProductListOverride
Argument [1]
Array
(
[nbProducts] =>
[catProducts] => Array
(
)
[hookExecuted] => 1
)
109. $this->productSort(); // Product sort must be called before assignProductList()
110.
111. $this->assignScenes();
112. $this->assignSubcategories();
113. if ($this->category->id != 1)
114. $this->assignProductList();
115. // print_r($this->cat_products);
116. // mail('blaise@motobel.fr', 'Debug shop initContent', print_r($this->cat_products, true));
117.
118. $this->context->smarty->assign(array(
119. 'category' => $this->category,
163. }
164. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
165. $this->initHeader();
166.
167. if ($this->viewAccess()) {
168. $this->initContent();
169. }
170. else {
171. $this->errors[] = Tools::displayError('Access denied.');
172. }
173.
390. {
391. $mycontroller = Controller::getController($controller_class);
392. if( $_SERVER['REMOTE_ADDR']== IP_DEBUG_BLAISE) {
393. // mail('blaise2@motobel.fr', $time_start . ' ' . __FILE__ . ' ' . __LINE__, $_SERVER['REQUEST_URI'] . print_r($this, true));
394. }
395. $mycontroller->run();
396. if( $_SERVER['REMOTE_ADDR']== IP_DEBUG_BLAISE) {
397. // mail('blaise2@motobel.fr', $time_start . ' ' . __FILE__ . ' ' . __LINE__, $_SERVER['REQUEST_URI'] . print_r($this, true));
398. }
399. }
400. catch (PrestaShopException $e)
75.
76. if( $_SERVER['REMOTE_ADDR']== IP_DEBUG_BLAISE) {
77. //mail('blaise2@motobel.fr', $time_start . ' ' . __FILE__ . ' ' . __LINE__, $_SERVER['REQUEST_URI']);
78. }
79.
80. Dispatcher::getInstance()->dispatch();
81.
82. $time_end = microtime(true);
83. $delay = $time_end - $time_start;
84. if($delay > 1) {
85. // error_log(__FILE__ . ' ' . __LINE__ . ' ' . $delay);