Les Petits Cadeaux utilise des cookies afin de vous offrir une navigation sûre et agréable. En poursuivant votre navigation sur notre site, vous déclarez accepter leur utilisation. Pour en savoir plus, c’est par ici
Configuration Information
  • Controller | BestSalesController
  • Shop Name | LesPetitsCadeaux
  • Shop ID | 1
  • Theme | theme_nq
  • Theme Directory | theme_nq
Performance parameters
  • Smarty :
  • Cache des templates : Recompile templates if the files have been updated
  • Cache :Yes
  • Console de débogage : Do not open console
  • Optional features :
  • Combinations :Yes
  • Features :Yes
  • CCC (Combine, Compress and Cache) :
  • Smart cache for CSS :No
  • Smart cache for JavaScript :No
  • Minify HTML :No
  • Compress inline JavaScript in HTML :No
  • Apache optimization :No
  • Ciphering :
  • Algorithm : Keep the custom BlowFish class.
  • Caching :
  • Use cache :No
  • Caching system : Memcached
Load time
  • Total : 109ms
  • config: 0ms
  • Controller::init(): 1ms
  • Controller::setMedia(): 0ms
  • Controller::postProcess(): 0ms
  • Controller::initHeader(): 0ms
  • Controller::initContent(): 63ms
  • Controller::initFooter(): 7ms
  • Controller::display(): 37ms
Memory peak usage
  • Total : 20.85 Mb
  • config: -0.01 Mb
  • Controller::init(): 1.04 Mb
  • Controller::setMedia(): 0.07 Mb
  • Controller::postProcess(): 0 Mb
  • Controller::initHeader(): 0 Mb
  • Controller::initContent(): 7.71 Mb
  • Controller::initFooter(): 0.65 Mb
  • Controller::display(): 3.6 Mb
Size of included files (360 files)
  • Total : 5.59Mb
Globals variables
  • Globals (> 1 Ko only) : 8997 Ko
  • context : ≈ 3749.6 Ko
  • smarty : ≈ 3543.5 Ko
  • _MODULES : ≈ 1239.2 Ko
  • _LANG : ≈ 243.5 Ko
  • customer : ≈ 47.5 Ko
  • cart : ≈ 32.1 Ko
  • container : ≈ 26 Ko
  • default_country : ≈ 23.5 Ko
  • defaultCountry : ≈ 22.9 Ko
  • currency : ≈ 19.2 Ko
  • language : ≈ 16.8 Ko
  • _SERVER : ≈ 10.3 Ko
  • NQ_ID : ≈ 10.2 Ko
  • _MODULE : ≈ 4 Ko
  • cookie : ≈ 3.7 Ko
  • link : ≈ 1.1 Ko
SQL Queries : 582 queries  |  Time spent querying : 31ms
Stopwatch (with SQL_NO_CACHE)

8.271 ms SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, ?) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,?) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("?-?-? ?:?:?", INTERVAL ? DAY)) > ? AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = ? AND product_attribute_shop.id_shop=?) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = ? AND pl.id_shop = ? LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=? AND image_shop.id_shop=?) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = ?) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = ? AND tr.`id_state` = ? LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = ? AND stock.id_shop = ? AND stock.id_shop_group = ? ) WHERE product_shop.`active` = ? AND p.`visibility` != 'none' AND EXISTS(SELECT ? FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = ?) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT ?, ?
  • in /var/www/lespetitscadeaux.com/classes/ProductSale.php (line 140)
  • from /classes/ProductSale.php (line 140)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

2.044 ms SELECT p.ID as post_id, post_date, post_title, post_content, guid as post_link, pm?.meta_value as thumbnail_url, pm?.meta_value as thumbnail_meta FROM wp_posts p LEFT JOIN wp_postmeta as pm? ON p.ID = pm?.post_id AND pm?.meta_key = "_thumbnail_id" LEFT JOIN wp_postmeta as pm? ON pm?.post_id = pm?.meta_value AND pm?.meta_key = "_wp_attached_file" LEFT JOIN wp_postmeta as pm? ON pm?.post_id = pm?.meta_value AND pm?.meta_key = "_wp_attachment_metadata" WHERE p.post_status = "publish" ORDER BY p.post_date DESC
  • in /var/www/lespetitscadeaux.com/modules/nq_wordpress/bridge/Wordpress.php (line 202)
  • from /modules/nq_wordpress/bridge/Wordpress.php (line 202)
  • from /modules/nq_wordpress/nq_wordpress.php (line 58)
  • from /modules/nq_wordpress/nq_wordpress.php (line 71)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.254 ms SELECT c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
  • in /var/www/lespetitscadeaux.com/classes/Configuration.php (line 148)
  • from /classes/Configuration.php (line 148)
  • from /classes/Configuration.php (line 185)
  • from /classes/Configuration.php (line 247)
  • from /classes/shop/Shop.php (line 369)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.224 ms INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('?', '?', '?', '', '?', '?', '?-?-? ?:?:?')
  • in /var/www/lespetitscadeaux.com/classes/ObjectModel.php (line 487)
  • from /classes/ObjectModel.php (line 487)
  • from /classes/Connection.php (line 158)
  • from /classes/Connection.php (line 86)
  • from /modules/statsdata/statsdata.php (line 142)
  • from /modules/statsdata/statsdata.php (line 81)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.201 ms SHOW TABLES FROM lespetitscadeaux LIKE 'wp_posts'
  • in /var/www/lespetitscadeaux.com/modules/nq_wordpress/bridge/Wordpress.php (line 187)
  • from /modules/nq_wordpress/bridge/Wordpress.php (line 187)
  • from /modules/nq_wordpress/nq_wordpress.php (line 58)
  • from /modules/nq_wordpress/nq_wordpress.php (line 71)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.193 ms SHOW TABLES FROM lespetitscadeaux LIKE 'wp_terms'
  • in /var/www/lespetitscadeaux.com/modules/nq_wordpress/bridge/Wordpress.php (line 172)
  • from /modules/nq_wordpress/bridge/Wordpress.php (line 172)
  • from /modules/nq_wordpress/bridge/Wordpress.php (line 207)
  • from /modules/nq_wordpress/nq_wordpress.php (line 58)
  • from /modules/nq_wordpress/nq_wordpress.php (line 71)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.168 ms SELECT SQL_NO_CACHE `id_guest` FROM `ps_connections` WHERE `id_guest` = ? AND `date_add` > '?-?-? ?:?:?' AND id_shop IN (?) ORDER BY `date_add` DESC LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Connection.php (line 138)
  • from /classes/Connection.php (line 138)
  • from /classes/Connection.php (line 86)
  • from /modules/statsdata/statsdata.php (line 142)
  • from /modules/statsdata/statsdata.php (line 81)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.166 ms INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '', '?')
  • in /var/www/lespetitscadeaux.com/classes/ObjectModel.php (line 487)
  • from /classes/ObjectModel.php (line 487)
  • from /classes/ObjectModel.php (line 445)
  • from /classes/Guest.php (line 193)
  • from /modules/statsdata/statsdata.php (line 104)
  • from /modules/statsdata/statsdata.php (line 80)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.104 ms SELECT h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = ?) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
  • in /var/www/lespetitscadeaux.com/classes/Hook.php (line 236)
  • from /classes/Hook.php (line 236)
  • from /classes/Hook.php (line 275)
  • from /classes/tax/TaxManagerFactory.php (line 67)
  • from /classes/tax/TaxManagerFactory.php (line 46)
  • from /classes/Product.php (line 3053)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.099 ms SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = ? AND module_shop.enable_device & ?) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = ?) AND (mg.`id_shop` = ? AND mg.`id_group` IN (?)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
  • in /var/www/lespetitscadeaux.com/classes/Hook.php (line 355)
  • from /classes/Hook.php (line 355)
  • from /override/classes/Hook.php (line 46)
  • from /classes/Dispatcher.php (line 407)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.06 ms SELECT `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name
  • in /var/www/lespetitscadeaux.com/classes/Hook.php (line 131)
  • from /classes/Hook.php (line 131)
  • from /override/classes/Hook.php (line 50)
  • from /classes/Dispatcher.php (line 407)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.059 ms SELECT l.*, ll.*, tbl.custom_name, b.template, b.name as block_name, cl.name as category_name, cl.description as description, pl.name as product_name FROM ps_navigation_tab_link l LEFT JOIN ps_navigation_block b ON b.id_navigation_block = l.id_navigation_block LEFT JOIN ps_navigation_tab_link_lang ll ON ll.id_navigation_tab_link = l.id_navigation_tab_link AND ll.id_lang = ? LEFT JOIN ps_navigation_tab_block tb ON tb.id_navigation_block = b.id_navigation_block AND tb.id_navigation_tab = l.id_navigation_tab LEFT JOIN ps_navigation_tab_block_lang tbl ON tbl.id_navigation_tab_block = tb.id_navigation_tab_block and tbl.id_lang = ? LEFT JOIN ps_category_lang cl ON cl.id_category = l.id_category AND cl.id_lang = ? AND cl.id_shop = ? LEFT JOIN ps_product_lang pl ON pl.id_product = l.id_product AND pl.id_lang = ? AND pl.id_shop = ? WHERE l.id_navigation_tab = ? AND l.active = ? ORDER BY ordre, position
  • in /var/www/lespetitscadeaux.com/modules/nq_navigation/classes/NavigationTab.php (line 137)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 137)
  • from /modules/nq_navigation/nq_navigation.php (line 178)
  • from /modules/nq_navigation/nq_navigation.php (line 148)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.055 ms SELECT DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != ?
  • in /var/www/lespetitscadeaux.com/classes/SpecificPrice.php (line 238)
  • from /classes/SpecificPrice.php (line 238)
  • from /classes/SpecificPrice.php (line 283)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2977)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.051 ms SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.lespetitscadeaux.com' OR su.domain_ssl = 'www.lespetitscadeaux.com') AND s.active = ? AND s.deleted = ? ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
  • in /var/www/lespetitscadeaux.com/classes/shop/Shop.php (line 334)
  • from /classes/shop/Shop.php (line 334)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.05 ms SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_product` IN (?, ?) AND `id_customer` = ? AND `id_product_attribute` = ? AND `id_cart` = ? AND (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) AND IF(`from_quantity` > ?, `from_quantity`, ?) <= ? ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SpecificPrice.php (line 362)
  • from /classes/SpecificPrice.php (line 362)
  • from /classes/Product.php (line 2977)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.05 ms SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "best-sales" OR m.page = "bestsales" ) AND ml.id_lang = ? AND ml.id_shop = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Meta.php (line 149)
  • from /classes/Meta.php (line 149)
  • from /classes/Meta.php (line 234)
  • from /classes/Meta.php (line 221)
  • from /classes/controller/FrontController.php (line 393)
  • from /override/classes/controller/FrontController.php (line 20)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.049 ms SELECT ID as post_id, post_date, post_title, post_content, guid as post_link, pm?.meta_value as thumbnail_url, pm?.meta_value as thumbnail_meta FROM wp_posts p LEFT JOIN wp_postmeta as pm? ON p.ID = pm?.post_id AND pm?.meta_key = "_thumbnail_id" LEFT JOIN wp_postmeta as pm? ON pm?.post_id = pm?.meta_value AND pm?.meta_key = "_wp_attached_file" LEFT JOIN wp_postmeta as pm? ON pm?.post_id = pm?.meta_value AND pm?.meta_key = "_wp_attachment_metadata" WHERE p.post_type = "post" AND p.post_status = "publish" ORDER BY post_date DESC LIMIT ?,?
  • in /var/www/lespetitscadeaux.com/modules/nq_wordpress/bridge/Wordpress.php (line 112)
  • from /modules/nq_wordpress/bridge/Wordpress.php (line 112)
  • from /modules/nq_wordpress/nq_wordpress.php (line 59)
  • from /modules/nq_wordpress/nq_wordpress.php (line 71)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.049 ms SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_product` = ? AND `id_customer` = ? AND `id_product_attribute` = ? AND `id_cart` = ? AND (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) AND IF(`from_quantity` > ?, `from_quantity`, ?) <= ? ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SpecificPrice.php (line 362)
  • from /classes/SpecificPrice.php (line 362)
  • from /classes/Product.php (line 2977)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.046 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = ? LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = ? WHERE (a.`id_product` = ?) AND (b.`id_shop` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Product.php (line 477)
  • from /override/classes/Product.php (line 29)
  • from /classes/Link.php (line 104)
  • from /classes/Product.php (line 4284)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.045 ms SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = ? LIMIT ? ) as mshop FROM `ps_module` m
  • in /var/www/lespetitscadeaux.com/classes/module/Module.php (line 277)
  • from /classes/module/Module.php (line 277)
  • from /modules/nq_cache/nq_cache.php (line 14)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1142)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 60)
  • from /classes/Dispatcher.php (line 407)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.043 ms SELECT gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = ? WHERE s.deleted = ? AND gs.deleted = ? ORDER BY gs.name, s.name
  • in /var/www/lespetitscadeaux.com/classes/shop/Shop.php (line 663)
  • from /classes/shop/Shop.php (line 663)
  • from /classes/shop/Shop.php (line 717)
  • from /classes/Configuration.php (line 244)
  • from /classes/shop/Shop.php (line 369)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.043 ms SELECT * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = ?) WHERE `deleted` = ? AND c.`active` = ? ORDER BY `name` ASC
  • in /var/www/lespetitscadeaux.com/classes/Currency.php (line 231)
  • from /classes/Currency.php (line 231)
  • from /classes/controller/FrontController.php (line 453)
  • from /override/classes/controller/FrontController.php (line 20)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.042 ms SELECT COUNT(ps.`id_product`) AS nb FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON p.`id_product` = ps.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) WHERE product_shop.`active` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/ProductSale.php (line 53)
  • from /classes/ProductSale.php (line 53)
  • from /controllers/front/BestSalesController.php (line 37)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.04 ms SELECT * FROM ps_navigation_tab t JOIN ps_navigation_tab_lang tl ON tl.id_navigation_tab = t.id_navigation_tab AND id_lang = ? WHERE active = ? AND id_shop = ? ORDER BY position
  • in /var/www/lespetitscadeaux.com/modules/nq_navigation/classes/NavigationTab.php (line 207)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 207)
  • from /modules/nq_navigation/nq_navigation.php (line 147)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.04 ms SELECT id_required_field, object_name, field_name FROM ps_required_field
  • in /var/www/lespetitscadeaux.com/classes/ObjectModel.php (line 1376)
  • from /classes/ObjectModel.php (line 1376)
  • from /classes/ObjectModel.php (line 1387)
  • from /classes/ObjectModel.php (line 999)
  • from /classes/ObjectModel.php (line 914)
  • from /classes/ObjectModel.php (line 246)
  • from /classes/ObjectModel.php (line 487)
  • from /classes/ObjectModel.php (line 445)
  • from /classes/Guest.php (line 193)
  • from /modules/statsdata/statsdata.php (line 104)
  • from /modules/statsdata/statsdata.php (line 80)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.04 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = ? LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = ? WHERE (a.`id_cms` = ?) AND (b.`id_shop` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Link.php (line 265)
  • from /modules/nq_cnilbanner/nq_cnilbanner.php (line 38)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.04 ms SELECT m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = ? ) ORDER BY LENGTH(ml.url_rewrite) DESC
  • in /var/www/lespetitscadeaux.com/classes/Dispatcher.php (line 452)
  • from /classes/Dispatcher.php (line 452)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.039 ms SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = ? WHERE (a.`id_country` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /modules/paypal/paypal.php (line 116)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1137)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 162)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.037 ms SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = ?) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE pf.id_product = ? ORDER BY f.position ASC
  • in /var/www/lespetitscadeaux.com/classes/Product.php (line 4458)
  • from /classes/Product.php (line 4458)
  • from /classes/Product.php (line 4371)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.037 ms SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = ? AND tr.`id_country` = ? AND tr.`id_tax_rules_group` = ? AND tr.`id_state` IN (?, ?) AND ('?' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = ? AND tr.`zipcode_from` IN(?, '?'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
  • in /var/www/lespetitscadeaux.com/classes/tax/TaxRulesTaxManager.php (line 109)
  • from /classes/tax/TaxRulesTaxManager.php (line 109)
  • from /classes/Product.php (line 3054)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.036 ms SELECT hm.`id_module` FROM `ps_hook_module` hm, `ps_hook` h WHERE hm.`id_module` = ? AND h.`id_hook` = ? AND h.`id_hook` = hm.`id_hook` AND `id_shop` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/module/Module.php (line 909)
  • from /classes/module/Module.php (line 909)
  • from /modules/nq_navigation/nq_navigation.php (line 45)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1142)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 162)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.035 ms SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = ? LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = ? WHERE (a.`id_category` = ?) AND (b.`id_shop` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Category.php (line 137)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 150)
  • from /modules/nq_navigation/nq_navigation.php (line 178)
  • from /modules/nq_navigation/nq_navigation.php (line 148)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.035 ms SELECT COUNT(DISTINCT c.id_currency) FROM `ps_currency` c LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = ?) WHERE c.`active` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Currency.php (line 472)
  • from /classes/Currency.php (line 472)
  • from /classes/Currency.php (line 479)
  • from /classes/module/Module.php (line 2283)
  • from /modules/blocksearch/blocksearch.php (line 109)
  • from /modules/blocksearch/blocksearch.php (line 125)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 265)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 265)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.035 ms SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,?) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = ?) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = ?) WHERE (p.`id_product` = ?)
  • in /var/www/lespetitscadeaux.com/classes/Product.php (line 3002)
  • from /classes/Product.php (line 3002)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.035 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='?c?f?aac?bc?a?de?b?e' AND cache_id="blockbanner|?|?|?|?" AND compile_id="" LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SmartyCustom.php (line 215)
  • from /classes/SmartyCustom.php (line 215)
  • from /classes/SmartyCustom.php (line 153)
  • from /classes/SmartyCustom.php (line 120)
  • from /classes/module/Module.php (line 2335)
  • from /classes/module/Module.php (line 2309)
  • from /modules/blockbanner/blockbanner.php (line 108)
  • from /modules/blockbanner/blockbanner.php (line 118)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 271)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 271)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.035 ms SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Group.php (line 144)
  • from /classes/Group.php (line 144)
  • from /classes/Group.php (line 151)
  • from /classes/order/Order.php (line 290)
  • from /modules/systempay/systempay.php (line 76)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1142)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 162)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.034 ms SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =? AND m.page = "best-sales" LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Theme.php (line 275)
  • from /classes/Theme.php (line 275)
  • from /classes/controller/FrontController.php (line 147)
  • from /classes/controller/Controller.php (line 134)
  • from /classes/Dispatcher.php (line 359)
  • from /index.php (line 28)

0.034 ms SELECT * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/shop/Shop.php (line 518)
  • from /config/config.inc.php (line 166)
  • from /index.php (line 27)

0.034 ms SELECT * FROM ps_footercol a JOIN ps_footercol_lang b ON b.id_footercol = a.id_footercol AND id_lang = ?
  • in /var/www/lespetitscadeaux.com/modules/nq_footerlinks/classes/FooterCol.php (line 35)
  • from /modules/nq_footerlinks/classes/FooterCol.php (line 35)
  • from /modules/nq_footerlinks/classes/FooterLink.php (line 52)
  • from /modules/nq_footerlinks/nq_footerlinks.php (line 133)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.034 ms SELECT * FROM `ps_hook_alias`
  • in /var/www/lespetitscadeaux.com/classes/Hook.php (line 187)
  • from /classes/Hook.php (line 187)
  • from /classes/Hook.php (line 209)
  • from /classes/Hook.php (line 381)
  • from /override/classes/Hook.php (line 46)
  • from /classes/Dispatcher.php (line 407)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.034 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (?)
  • in /var/www/lespetitscadeaux.com/classes/module/Module.php (line 2141)
  • from /classes/module/Module.php (line 2141)
  • from /override/classes/Hook.php (line 139)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.033 ms SELECT * FROM `ps_shop` a WHERE (a.`id_shop` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/shop/Shop.php (line 131)
  • from /classes/shop/Shop.php (line 397)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.033 ms SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/shop/Shop.php (line 1067)
  • from /classes/shop/Shop.php (line 1067)
  • from /classes/Configuration.php (line 191)
  • from /classes/Configuration.php (line 247)
  • from /classes/shop/Shop.php (line 369)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.033 ms SELECT * FROM ps_footerlink a JOIN ps_footerlink_lang b ON b.id_footerlink = a.id_footerlink AND id_lang = ? WHERE ? AND active = ? ORDER BY position
  • in /var/www/lespetitscadeaux.com/modules/nq_footerlinks/classes/FooterLink.php (line 68)
  • from /modules/nq_footerlinks/classes/FooterLink.php (line 68)
  • from /modules/nq_footerlinks/nq_footerlinks.php (line 133)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.032 ms SELECT * FROM `ps_image_type`
  • in /var/www/lespetitscadeaux.com/classes/ImageType.php (line 143)
  • from /classes/ImageType.php (line 143)
  • from /classes/ImageType.php (line 174)
  • from /controllers/front/BestSalesController.php (line 51)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.031 ms SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) WHERE pa.`id_product_attribute` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Combination.php (line 344)
  • from /classes/Combination.php (line 344)
  • from /classes/Product.php (line 1177)
  • from /classes/Product.php (line 4288)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.031 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "nq_configurator" LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2217)
  • from /override/classes/Cart.php (line 99)
  • from /modules/blockcart/blockcart.php (line 62)
  • from /modules/blockcart/blockcart.php (line 212)
  • from /modules/blockcart/blockcart.php (line 265)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.031 ms SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = ? LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = ? WHERE (a.`id_country` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /config/config.inc.php (line 142)
  • from /index.php (line 27)

0.03 ms SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
  • in /var/www/lespetitscadeaux.com/classes/Language.php (line 777)
  • from /classes/Language.php (line 777)
  • from /config/config.inc.php (line 139)
  • from /index.php (line 27)

0.03 ms SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = ?) INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = ?) WHERE m.`active` = ? ORDER BY m.`name` ASC
  • in /var/www/lespetitscadeaux.com/classes/Manufacturer.php (line 181)
  • from /classes/Manufacturer.php (line 181)
  • from /modules/nq_navigation/nq_navigation.php (line 151)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.029 ms SELECT COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SpecificPrice.php (line 230)
  • from /classes/SpecificPrice.php (line 230)
  • from /classes/SpecificPrice.php (line 283)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2977)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.029 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SpecificPrice.php (line 198)
  • from /classes/SpecificPrice.php (line 198)
  • from /classes/SpecificPrice.php (line 176)
  • from /classes/SpecificPrice.php (line 350)
  • from /classes/Product.php (line 2977)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.028 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='?b?f?ce?a?f?e?f' AND cache_id="blocksearch-top|?|?|?|?" AND compile_id="" LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SmartyCustom.php (line 215)
  • from /classes/SmartyCustom.php (line 215)
  • from /classes/SmartyCustom.php (line 153)
  • from /classes/SmartyCustom.php (line 120)
  • from /classes/module/Module.php (line 2335)
  • from /classes/module/Module.php (line 2384)
  • from /modules/blocksearch/blocksearch.php (line 110)
  • from /modules/blocksearch/blocksearch.php (line 125)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 265)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 265)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.028 ms SELECT id_page_type FROM ps_page_type WHERE name = 'bestsales' LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Page.php (line 97)
  • from /classes/Page.php (line 97)
  • from /classes/Page.php (line 52)
  • from /classes/Connection.php (line 150)
  • from /classes/Connection.php (line 86)
  • from /modules/statsdata/statsdata.php (line 142)
  • from /modules/statsdata/statsdata.php (line 81)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.028 ms SELECT UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SmartyCustom.php (line 95)
  • from /classes/SmartyCustom.php (line 95)
  • from /classes/SmartyCustom.php (line 118)
  • from /classes/module/Module.php (line 2335)
  • from /classes/module/Module.php (line 2309)
  • from /modules/paypal/paypal.php (line 2479)
  • from /modules/paypal/paypal.php (line 890)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.028 ms SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = ? WHERE (a.`id_currency` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Currency.php (line 103)
  • from /classes/Currency.php (line 451)
  • from /classes/Tools.php (line 617)
  • from /classes/controller/FrontController.php (line 289)
  • from /override/classes/controller/FrontController.php (line 20)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.028 ms SELECT * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = ? WHERE (a.`id_group` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Group.php (line 75)
  • from /classes/Group.php (line 346)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 348)
  • from /override/classes/controller/FrontController.php (line 20)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.028 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "paypal" LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2195)
  • from /modules/paypal/paypal.php (line 136)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1137)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 162)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.028 ms SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = ? AND s.active = ? AND s.deleted = ? AND su.main = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/shop/Shop.php (line 203)
  • from /classes/shop/Shop.php (line 203)
  • from /classes/shop/Shop.php (line 133)
  • from /classes/shop/Shop.php (line 397)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.028 ms SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = ? WHERE (a.`id_lang` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Language.php (line 90)
  • from /config/config.inc.php (line 195)
  • from /index.php (line 27)

0.027 ms SELECT domain, domain_ssl FROM ps_shop_url WHERE main = ? AND id_shop = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/shop/ShopUrl.php (line 169)
  • from /classes/shop/ShopUrl.php (line 169)
  • from /classes/shop/ShopUrl.php (line 183)
  • from /classes/Tools.php (line 314)
  • from /classes/Link.php (line 52)
  • from /config/config.inc.php (line 234)
  • from /index.php (line 27)

0.027 ms SELECT COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SpecificPrice.php (line 230)
  • from /classes/SpecificPrice.php (line 230)
  • from /classes/SpecificPrice.php (line 291)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2977)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.027 ms SELECT t.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON (tt.term_id = t.term_id) INNER JOIN wp_term_relationships AS tr ON (tr.term_taxonomy_id = tt.term_taxonomy_id) WHERE tt.taxonomy = "category" AND tr.object_id = (?) ORDER BY t.name ASC
  • in /var/www/lespetitscadeaux.com/modules/nq_wordpress/bridge/Wordpress.php (line 183)
  • from /modules/nq_wordpress/bridge/Wordpress.php (line 183)
  • from /modules/nq_wordpress/bridge/Wordpress.php (line 207)
  • from /modules/nq_wordpress/nq_wordpress.php (line 58)
  • from /modules/nq_wordpress/nq_wordpress.php (line 71)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.026 ms SELECT * FROM `ps_navigation_tab` a WHERE (a.`id_navigation_tab` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /modules/nq_navigation/nq_navigation.php (line 173)
  • from /modules/nq_navigation/nq_navigation.php (line 148)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.026 ms SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = ?) WHERE l.`active` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Language.php (line 894)
  • from /classes/Language.php (line 894)
  • from /classes/Language.php (line 992)
  • from /classes/Dispatcher.php (line 391)
  • from /classes/Dispatcher.php (line 217)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.026 ms SELECT * FROM `ps_country_lang` WHERE `id_country` = ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 68)
  • from /Adapter/Adapter_EntityMapper.php (line 68)
  • from /classes/ObjectModel.php (line 233)
  • from /modules/paypal/paypal.php (line 116)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1137)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 162)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.026 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop = ?) AND (id_shop_group = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/stock/StockAvailable.php (line 380)
  • from /classes/stock/StockAvailable.php (line 380)
  • from /classes/Product.php (line 3285)
  • from /classes/Product.php (line 4358)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.026 ms SELECT UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SmartyCustom.php (line 142)
  • from /classes/SmartyCustom.php (line 142)
  • from /classes/SmartyCustom.php (line 120)
  • from /classes/module/Module.php (line 2335)
  • from /classes/module/Module.php (line 2384)
  • from /modules/blocksearch/blocksearch.php (line 110)
  • from /modules/blocksearch/blocksearch.php (line 125)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 265)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 265)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.026 ms SELECT * FROM `ps_tax` a WHERE (a.`id_tax` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/tax/TaxRulesTaxManager.php (line 115)
  • from /classes/Product.php (line 3054)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.025 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /controllers/front/BestSalesController.php (line 51)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.024 ms SELECT ? FROM `ps_specific_price` WHERE `from` BETWEEN '?-?-? ?:?:?' AND '?-?-? ?:?:?' LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SpecificPrice.php (line 302)
  • from /classes/SpecificPrice.php (line 302)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2977)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.024 ms SELECT * FROM `ps_theme` a WHERE (a.`id_theme` = ?) LIMIT ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /config/config.inc.php (line 115)
  • from /index.php (line 27)

0.023 ms SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = ? AND `id_shop` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/module/Module.php (line 2218)
  • from /classes/module/Module.php (line 2218)
  • from /override/classes/Cart.php (line 99)
  • from /modules/blockcart/blockcart.php (line 62)
  • from /modules/blockcart/blockcart.php (line 212)
  • from /modules/blockcart/blockcart.php (line 265)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.023 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = ? AND cl.id_shop = ? AND cl.`id_category` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Category.php (line 1054)
  • from /classes/Category.php (line 1054)
  • from /classes/Product.php (line 4283)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.022 ms SELECT id_shop FROM ps_shop
  • in /var/www/lespetitscadeaux.com/classes/shop/Shop.php (line 697)
  • from /classes/shop/Shop.php (line 697)
  • from /classes/module/Module.php (line 898)
  • from /modules/nq_navigation/nq_navigation.php (line 45)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1142)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 162)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.022 ms SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = ? AND id_shop = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/ObjectModel.php (line 1459)
  • from /classes/ObjectModel.php (line 1459)
  • from /classes/Tools.php (line 501)
  • from /override/classes/Tools.php (line 7)
  • from /classes/controller/FrontController.php (line 241)
  • from /override/classes/controller/FrontController.php (line 20)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.022 ms SELECT version FROM `ps_module` WHERE name = 'paypal' LIMIT ?
  • in /var/www/lespetitscadeaux.com/modules/paypal/paypal.php (line 327)
  • from /modules/paypal/paypal.php (line 327)
  • from /modules/paypal/paypal.php (line 137)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1137)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 162)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 25)
  • from /controllers/front/BestSalesController.php (line 34)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.022 ms SELECT * FROM `ps_tax_lang` WHERE `id_tax` = ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 68)
  • from /Adapter/Adapter_EntityMapper.php (line 68)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/tax/TaxRulesTaxManager.php (line 115)
  • from /classes/Product.php (line 3054)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.021 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = ? AND `id_group` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/GroupReduction.php (line 149)
  • from /classes/GroupReduction.php (line 149)
  • from /classes/Product.php (line 3115)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.021 ms SELECT ? FROM `ps_specific_price` WHERE `to` BETWEEN '?-?-? ?:?:?' AND '?-?-? ?:?:?' LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/SpecificPrice.php (line 306)
  • from /classes/SpecificPrice.php (line 306)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2977)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.021 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Group.php (line 133)
  • from /classes/Group.php (line 133)
  • from /classes/Product.php (line 3119)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.021 ms SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Page.php (line 77)
  • from /classes/Page.php (line 77)
  • from /classes/Connection.php (line 150)
  • from /classes/Connection.php (line 86)
  • from /modules/statsdata/statsdata.php (line 142)
  • from /modules/statsdata/statsdata.php (line 81)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 251)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.021 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/Product.php (line 5037)
  • from /classes/Product.php (line 5037)
  • from /classes/Product.php (line 3053)
  • from /classes/Product.php (line 2902)
  • from /classes/Product.php (line 4296)
  • from /classes/Product.php (line 4428)
  • from /classes/ProductSale.php (line 148)
  • from /controllers/front/BestSalesController.php (line 44)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.02 ms SELECT * FROM `ps_navigation_tab_lang` WHERE `id_navigation_tab` = ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 68)
  • from /Adapter/Adapter_EntityMapper.php (line 68)
  • from /classes/ObjectModel.php (line 233)
  • from /modules/nq_navigation/nq_navigation.php (line 173)
  • from /modules/nq_navigation/nq_navigation.php (line 148)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 249)
  • from /config/smarty.config.inc.php (line 203)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 266)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /cache/smarty/compile/af/d7/a8/afd7a8e231ad892d35a22768247db84c6d062a85.file.header.tpl.php (line 211)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 317)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/ae/49/b0/ae49b038b8a145f951b4d555c26cde835a1b37c1.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 110)
  • from /classes/controller/Controller.php (line 529)
  • from /classes/controller/FrontController.php (line 723)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.019 ms SELECT id_shop FROM `ps_group_shop` WHERE `id_group` = ? AND id_shop = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/ObjectModel.php (line 1459)
  • from /classes/ObjectModel.php (line 1459)
  • from /classes/Group.php (line 349)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 348)
  • from /override/classes/controller/FrontController.php (line 20)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.019 ms SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = ? AND id_shop = ? LIMIT ?
  • in /var/www/lespetitscadeaux.com/classes/ObjectModel.php (line 1459)
  • from /classes/ObjectModel.php (line 1459)
  • from /classes/Tools.php (line 621)
  • from /classes/controller/FrontController.php (line 289)
  • from /override/classes/controller/FrontController.php (line 20)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.017 ms SELECT * FROM `ps_group_lang` WHERE `id_group` = ?
  • in /var/www/lespetitscadeaux.com/Adapter/Adapter_EntityMapper.php (line 68)
  • from /Adapter/Adapter_EntityMapper.php (line 68)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Group.php (line 75)
  • from /classes/Group.php (line 346)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 348)
  • from /override/classes/controller/FrontController.php (line 20)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)
Doubles (IDs replaced by "?")

66 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop = ?) AND (id_shop_group = ?) LIMIT ?
53 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = ? LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = ? WHERE (a.`id_category` = ?) AND (b.`id_shop` = ?) LIMIT ?
44 SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,?) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = ?) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = ?) WHERE (p.`id_product` = ?)
44 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC LIMIT ?
44 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? LIMIT ?
44 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = ? LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = ? WHERE (a.`id_product` = ?) AND (b.`id_shop` = ?) LIMIT ?
44 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = ? AND `id_group` = ? LIMIT ?
44 SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = ?) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE pf.id_product = ? ORDER BY f.position ASC
29 SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_product` = ? AND `id_customer` = ? AND `id_product_attribute` = ? AND `id_cart` = ? AND (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) AND IF(`from_quantity` > ?, `from_quantity`, ?) <= ? ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT ?
22 SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) WHERE pa.`id_product_attribute` = ? LIMIT ?
18 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = ? AND cl.id_shop = ? AND cl.`id_category` = ? LIMIT ?
15 SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_product` IN (?, ?) AND `id_customer` = ? AND `id_product_attribute` = ? AND `id_cart` = ? AND (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) AND IF(`from_quantity` > ?, `from_quantity`, ?) <= ? ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT ?
12 SELECT l.*, ll.*, tbl.custom_name, b.template, b.name as block_name, cl.name as category_name, cl.description as description, pl.name as product_name FROM ps_navigation_tab_link l LEFT JOIN ps_navigation_block b ON b.id_navigation_block = l.id_navigation_block LEFT JOIN ps_navigation_tab_link_lang ll ON ll.id_navigation_tab_link = l.id_navigation_tab_link AND ll.id_lang = ? LEFT JOIN ps_navigation_tab_block tb ON tb.id_navigation_block = b.id_navigation_block AND tb.id_navigation_tab = l.id_navigation_tab LEFT JOIN ps_navigation_tab_block_lang tbl ON tbl.id_navigation_tab_block = tb.id_navigation_tab_block and tbl.id_lang = ? LEFT JOIN ps_category_lang cl ON cl.id_category = l.id_category AND cl.id_lang = ? AND cl.id_shop = ? LEFT JOIN ps_product_lang pl ON pl.id_product = l.id_product AND pl.id_lang = ? AND pl.id_shop = ? WHERE l.id_navigation_tab = ? AND l.active = ? ORDER BY ordre, position
6 SELECT * FROM `ps_navigation_tab_lang` WHERE `id_navigation_tab` = ?
6 SELECT * FROM `ps_navigation_tab` a WHERE (a.`id_navigation_tab` = ?) LIMIT ?
4 SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = ?) INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = ?) WHERE m.`active` = ? ORDER BY m.`name` ASC
4 SELECT t.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON (tt.term_id = t.term_id) INNER JOIN wp_term_relationships AS tr ON (tr.term_taxonomy_id = tt.term_taxonomy_id) WHERE tt.taxonomy = "category" AND tr.object_id = (?) ORDER BY t.name ASC
4 SHOW TABLES FROM lespetitscadeaux LIKE 'wp_terms'
4 SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = ? LIMIT ? ) as mshop FROM `ps_module` m
3 SELECT hm.`id_module` FROM `ps_hook_module` hm, `ps_hook` h WHERE hm.`id_module` = ? AND h.`id_hook` = ? AND h.`id_hook` = hm.`id_hook` AND `id_shop` = ? LIMIT ?
2 SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = ? LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = ? WHERE (a.`id_cms` = ?) AND (b.`id_shop` = ?) LIMIT ?
2 SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT ?
2 SELECT * FROM ps_navigation_tab t JOIN ps_navigation_tab_lang tl ON tl.id_navigation_tab = t.id_navigation_tab AND id_lang = ? WHERE active = ? AND id_shop = ? ORDER BY position
2 SHOW TABLES FROM lespetitscadeaux LIKE 'wp_posts'
2 SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = ? AND tr.`id_country` = ? AND tr.`id_tax_rules_group` = ? AND tr.`id_state` IN (?, ?) AND ('?' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = ? AND tr.`zipcode_from` IN(?, '?'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
Tables stress

134 product_shop
90 product
83 category_lang
67 product_attribute_shop
67 stock_available
57 product_lang
53 category
53 category_shop
49 specific_price
44 feature_value_lang
44 specific_price_priority
44 feature_lang
44 feature_product
44 product_group_reduction_cache
44 feature
44 feature_shop
22 product_attribute
12 navigation_tab_link_lang
12 navigation_tab_block_lang
12 navigation_block
12 navigation_tab_block
12 navigation_tab_link
9 module
8 navigation_tab
8 navigation_tab_lang
7 module_shop
5 manufacturer
5 shop
5 hook_module
4 lang_shop
4 shop_url
4 hook
4 manufacturer_shop
4 currency_shop
4 manufacturer_lang
3 configuration
3 currency
3 meta
3 group
3 theme
3 lang
3 tax_rule
2 product_sale
2 country
2 country_lang
2 cms_shop
2 country_shop
2 cms_lang
2 image_type
2 cms
2 tax_rules_group
2 shop_group
2 tax
2 hook_alias
2 smarty_lazy_cache
2 group_shop
2 meta_lang
2 smarty_last_flush
1 footerlink_lang
1 footerlink
1 configuration_lang
1 module_group
1 category_product
1 category_group
1 image_lang
1 image_shop
1 hook_module_exceptions
1 group_lang
1 theme_meta
1 tax_lang
1 page
1 footercol
1 page_type
1 connections
1 required_field
1 footercol_lang
Hook processing : 48ms - 10.27Mb
  • moduleRoutes : 4ms - 2.09Mb
  • nq_batmanagement: 0ms - 0.07Mb
  • colissimo: 1ms - 1.35Mb
  • displayHeader : 12ms - 3.9Mb
  • blockuserinfo: 0ms - 0.08Mb
  • blockcart: 0ms - 0.08Mb
  • nq_navigation: 0ms - 0.23Mb
  • nq_footerlinks: 0ms - 0.12Mb
  • editorial: 0ms - 0.1Mb
  • blocklanguages: 0ms - 0.05Mb
  • nq_homepush: 0ms - 0.1Mb
  • blockbestsellers: 0ms - 0.06Mb
  • nq_wordpress: 0ms - 0.06Mb
  • homeslider: 0ms - 0.12Mb
  • blocksearch: 0ms - 0.05Mb
  • systempay: 1ms - 0.71Mb
  • paypal: 1ms - 0.6Mb
  • blockwishlist: 1ms - 0.09Mb
  • nq_social: 1ms - 0.09Mb
  • blockreinsurance: 0ms - 0.09Mb
  • blocklayered: 1ms - 0.18Mb
  • nq_infinitescroll: 0ms - 0.05Mb
  • nq_citybyzipcode: 0ms - 0.06Mb
  • nq_configurator: 0ms - 0.08Mb
  • nq_samples: 0ms - 0.06Mb
  • nq_estimatedelivery: 0ms - 0.06Mb
  • nq_batmanagement: 0ms - 0Mb
  • nq_cnilbanner: 1ms - 0.26Mb
  • mailalerts: 1ms - 0.15Mb
  • nq_tags: 0ms - 0.08Mb
  • colissimo: 0ms - 0Mb
  • blockbanner: 1ms - 0.05Mb
  • steavisgarantis: 0ms - 0.16Mb
  • cdw_microdata: 0ms - 0.06Mb
  • displayTop : 1ms - 0.2Mb
  • blockuserinfo: 0ms - 0.02Mb
  • blockcart: 1ms - 0.16Mb
  • blockwishlist: 0ms - 0.01Mb
  • paypal: 0ms - 0Mb
  • displayLeftColumn : 0ms - 0Mb
  • blocklayered: 0ms - 0Mb
  • steavisgarantis: 0ms - 0Mb
  • displayRightColumn : 0ms - 0Mb
  • steavisgarantis: 0ms - 0Mb
  • displayFooter : 7ms - 0.63Mb
  • statsdata: 2ms - 0.38Mb
  • nq_wordpress: 4ms - 0.14Mb
  • nq_footerlinks: 0ms - 0.12Mb
  • nq_cnilbanner: 0ms - 0Mb
  • steavisgarantis: 0ms - -0.01Mb
  • cdw_microdata: 0ms - 0Mb
  • displayProductPriceBlock : 0ms - 0Mb
  • steavisgarantis: 0ms - 0Mb
  • displayProductListReviews : 0ms - 0.02Mb
  • steavisgarantis: 0ms - 0.02Mb
  • displayNavMobile : 13ms - 1.23Mb
  • blocksearch: 0ms - 0Mb
  • nq_navigation: 13ms - 1.22Mb
  • blockuserinfo: 0ms - 0Mb
  • blocklanguages: 0ms - 0Mb
  • displayBanner : 0ms - 0Mb
  • blocklanguages: 0ms - 0Mb
  • displayNav : 4ms - 0.76Mb
  • nq_navigation: 4ms - 0.73Mb
  • blocksearch: 0ms - 0.03Mb
  • displayInfoBanner : 0ms - 0.04Mb
  • blockbanner: 0ms - 0.04Mb