Customer service - Contact us

 

For all questions about your orders delivery.

For all questions about orders or products.

To deal with our customer support for returns.

Welcome to the Customer Care service for 0cm.com.

For instant answers to frequent enquiries about 0cm.com and your online shopping experience, please browse our Customer Care topics.

If our Customer Care topics do not satisfy you please contact us via the contact form it will automatically send an e-mail to us.

Fill in the box on this page.

Administrative Offices:

0cm.com

Rm C, 2/F., Capital Trade Centre,

62 Tsun Yip Street, Kwun Tong,

Hong Kong SAR, 999077

Configuration Information
  • Controller | ContactController
  • Shop Name | 0cm
  • 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 :Yes
  • Smart cache for JavaScript :Yes
  • Minify HTML :Yes
  • Compress inline JavaScript in HTML :Yes
  • Apache optimization :Yes
  • Ciphering :
  • Algorithm : Keep the custom BlowFish class.
  • Caching :
  • Use cache :Yes
  • Caching system : Memcached
Load time
  • Total : 1.079s
  • config: 1ms
  • Controller::init(): 9ms
  • Controller::setMedia(): 1ms
  • Controller::postProcess(): 0ms
  • Controller::initHeader(): 0ms
  • Controller::initContent(): 538ms
  • Controller::initFooter(): 10ms
  • Controller::display(): 521ms
Memory peak usage
  • Total : 19.25 Mb
  • config: -0.04 Mb
  • Controller::init(): 1.52 Mb
  • Controller::setMedia(): 0.01 Mb
  • Controller::postProcess(): 0 Mb
  • Controller::initHeader(): 0.01 Mb
  • Controller::initContent(): 9.55 Mb
  • Controller::initFooter(): 0.67 Mb
  • Controller::display(): 0.44 Mb
Size of included files (297 files)
  • Total : 5.51Mb
Globals variables
  • Globals (> 1 Ko only) : 8865 Ko
  • context : ≈ 3941.1 Ko
  • smarty : ≈ 3872.9 Ko
  • _MODULES : ≈ 307.9 Ko
  • _LANG : ≈ 186.9 Ko
  • cookie : ≈ 152 Ko
  • customer : ≈ 45.3 Ko
  • NQ_ID : ≈ 33.1 Ko
  • container : ≈ 32.4 Ko
  • cart : ≈ 32.2 Ko
  • FPS_MONTH : ≈ 26.8 Ko
  • defaultCountry : ≈ 23.7 Ko
  • default_country : ≈ 23.6 Ko
  • FPS_CONFIGURATION : ≈ 23.4 Ko
  • FPS_CONFIG_CSS : ≈ 23.2 Ko
  • FBPSC_MONTH : ≈ 21.6 Ko
  • FPS_CSS_DEFAULT : ≈ 20.6 Ko
  • currency : ≈ 19.8 Ko
  • language : ≈ 16.8 Ko
  • FBPSC_REF_LANG : ≈ 9.4 Ko
  • FBPSC_CONNECTORS : ≈ 9.3 Ko
  • _SERVER : ≈ 8.3 Ko
  • FBPSC_ZONE : ≈ 7.5 Ko
  • FBPSC_HOOKS : ≈ 5.9 Ko
  • FPS_HOOKS : ≈ 5.7 Ko
  • FPS_TEXT_SIZE : ≈ 3.8 Ko
  • FBPSC_CONFIGURATION : ≈ 1.9 Ko
  • FPS_BORDER_SIZE : ≈ 1.8 Ko
  • FBPSC_JS_MSG : ≈ 1.7 Ko
  • link : ≈ 1.1 Ko
  • FPS_REVIEWS_LABEL_DEFAULT_TRANSLATE : ≈ 1.1 Ko
SQL Queries : 1453 queries  |  Time spent querying : 170ms
Stopwatch (with SQL_NO_CACHE)

0.944 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 /data/wwwroot/www.0cm.com/classes/Configuration.php (line 145)
  • from /classes/Configuration.php (line 145)
  • from /classes/Configuration.php (line 181)
  • from /classes/Configuration.php (line 237)
  • from /classes/shop/Shop.php (line 366)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.382 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 = "contact" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Theme.php (line 274)
  • from /classes/Theme.php (line 274)
  • from /classes/controller/FrontController.php (line 146)
  • from /classes/controller/Controller.php (line 131)
  • from /classes/Dispatcher.php (line 366)
  • from /index.php (line 28)

0.381 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 /data/wwwroot/www.0cm.com/classes/ObjectModel.php (line 469)
  • from /classes/ObjectModel.php (line 469)
  • from /classes/ObjectModel.php (line 431)
  • from /classes/Guest.php (line 191)
  • from /modules/statsdata/statsdata.php (line 74)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1018)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.361 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 /data/wwwroot/www.0cm.com/classes/Hook.php (line 234)
  • from /classes/Hook.php (line 234)
  • from /classes/Hook.php (line 273)
  • from /classes/tax/TaxManagerFactory.php (line 67)
  • from /classes/tax/TaxManagerFactory.php (line 47)
  • from /classes/Product.php (line 4779)
  • from /classes/Product.php (line 491)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.346 ms SELECT SQL_NO_CACHE `id_guest` FROM `ps_connections` WHERE `id_guest` = ? AND `date_add` > '?-?-? ?:?:?' AND id_shop_group = ? ORDER BY `date_add` DESC LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Connection.php (line 135)
  • from /classes/Connection.php (line 135)
  • from /classes/Connection.php (line 85)
  • from /modules/statsdata/statsdata.php (line 104)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1018)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.289 ms SELECT id_page_type FROM ps_page_type WHERE name = 'contact' LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Page.php (line 97)
  • from /classes/Page.php (line 97)
  • from /classes/Page.php (line 52)
  • from /classes/Connection.php (line 147)
  • from /classes/Connection.php (line 85)
  • from /modules/statsdata/statsdata.php (line 104)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1018)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.269 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 (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 /data/wwwroot/www.0cm.com/classes/Hook.php (line 353)
  • from /classes/Hook.php (line 353)
  • from /override/classes/Hook.php (line 46)
  • from /classes/Dispatcher.php (line 413)
  • from /override/classes/Dispatcher.php (line 106)
  • from /classes/Dispatcher.php (line 230)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.263 ms SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "contact" OR m.page = "contact" ) AND ml.id_lang = ? AND ml.id_shop = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Meta.php (line 142)
  • from /classes/Meta.php (line 142)
  • from /classes/Meta.php (line 225)
  • from /classes/Meta.php (line 212)
  • from /classes/controller/FrontController.php (line 403)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.256 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='a?e?e?af?c?f?d?d?b?a?' AND cache_id="homecategory|?|?|?|?|?|?" AND compile_id="" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 225)
  • from /classes/SmartyCustom.php (line 225)
  • from /classes/SmartyCustom.php (line 163)
  • from /classes/SmartyCustom.php (line 126)
  • from /classes/module/Module.php (line 2274)
  • from /classes/module/Module.php (line 2320)
  • from /modules/homecategory/homecategory.php (line 728)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.23 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='?f?e?fb?cc?f?ace?f?adcfc?' AND cache_id="homecategory|?|?|?|?|?|?" AND compile_id="" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 225)
  • from /classes/SmartyCustom.php (line 225)
  • from /classes/SmartyCustom.php (line 163)
  • from /classes/SmartyCustom.php (line 126)
  • from /classes/module/Module.php (line 2274)
  • from /classes/module/Module.php (line 2248)
  • from /modules/homecategory/homecategory.php (line 732)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.22 ms INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('?', '?', '?', '', '?', '?', '?-?-? ?:?:?')
  • in /data/wwwroot/www.0cm.com/classes/ObjectModel.php (line 469)
  • from /classes/ObjectModel.php (line 469)
  • from /classes/Connection.php (line 154)
  • from /classes/Connection.php (line 85)
  • from /modules/statsdata/statsdata.php (line 104)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1018)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.204 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 /data/wwwroot/www.0cm.com/classes/Dispatcher.php (line 454)
  • from /classes/Dispatcher.php (line 454)
  • from /override/classes/Dispatcher.php (line 106)
  • from /classes/Dispatcher.php (line 230)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.199 ms SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Page.php (line 78)
  • from /classes/Page.php (line 78)
  • from /classes/Connection.php (line 147)
  • from /classes/Connection.php (line 85)
  • from /modules/statsdata/statsdata.php (line 104)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1018)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.184 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 /data/wwwroot/www.0cm.com/classes/Hook.php (line 131)
  • from /classes/Hook.php (line 131)
  • from /override/classes/Hook.php (line 50)
  • from /classes/Dispatcher.php (line 413)
  • from /override/classes/Dispatcher.php (line 106)
  • from /classes/Dispatcher.php (line 230)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.174 ms SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` USE INDEX (id_product_?) WHERE `id_product` IN (?, ?) AND `id_product_attribute` IN (?, ?) AND `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_customer` IN (?, ?) AND ( (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) ) AND id_cart IN (?, ?) 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 /data/wwwroot/www.0cm.com/override/classes/SpecificPrice.php (line 66)
  • from /override/classes/SpecificPrice.php (line 66)
  • from /override/classes/Product.php (line 464)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.169 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 /data/wwwroot/www.0cm.com/modules/nq_navigation/classes/NavigationTab.php (line 143)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 143)
  • from /modules/nq_navigation/nq_navigation.php (line 389)
  • from /modules/nq_navigation/nq_navigation.php (line 121)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.152 ms SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/shop/Shop.php (line 1033)
  • from /classes/shop/Shop.php (line 1033)
  • from /classes/Configuration.php (line 186)
  • from /classes/Configuration.php (line 237)
  • from /classes/shop/Shop.php (line 366)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.149 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 /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/Product.php (line 477)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.147 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 /data/wwwroot/www.0cm.com/classes/Manufacturer.php (line 178)
  • from /classes/Manufacturer.php (line 178)
  • from /modules/nq_navigation/nq_navigation.php (line 168)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.144 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 /data/wwwroot/www.0cm.com/classes/module/Module.php (line 270)
  • from /classes/module/Module.php (line 270)
  • 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 1125)
  • from /classes/module/Module.php (line 1089)
  • from /override/classes/Hook.php (line 60)
  • from /classes/Dispatcher.php (line 413)
  • from /override/classes/Dispatcher.php (line 106)
  • from /classes/Dispatcher.php (line 230)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.136 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 /data/wwwroot/www.0cm.com/override/classes/Product.php (line 490)
  • from /override/classes/Product.php (line 490)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.133 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.?cm.com' OR su.domain_ssl = 'www.?cm.com') AND s.active = ? AND s.deleted = ? ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
  • in /data/wwwroot/www.0cm.com/classes/shop/Shop.php (line 333)
  • from /classes/shop/Shop.php (line 333)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.132 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 /data/wwwroot/www.0cm.com/modules/nq_navigation/classes/NavigationTab.php (line 213)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 213)
  • from /modules/nq_navigation/nq_navigation.php (line 120)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.131 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 /data/wwwroot/www.0cm.com/classes/shop/Shop.php (line 654)
  • from /classes/shop/Shop.php (line 654)
  • from /classes/shop/Shop.php (line 709)
  • from /classes/Configuration.php (line 234)
  • from /classes/shop/Shop.php (line 366)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.126 ms SELECT * FROM `ps_hook_alias`
  • in /data/wwwroot/www.0cm.com/classes/Hook.php (line 188)
  • from /classes/Hook.php (line 188)
  • from /classes/Hook.php (line 208)
  • from /classes/Hook.php (line 380)
  • from /override/classes/Hook.php (line 46)
  • from /classes/Dispatcher.php (line 413)
  • from /override/classes/Dispatcher.php (line 106)
  • from /classes/Dispatcher.php (line 230)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.125 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 /data/wwwroot/www.0cm.com/classes/Currency.php (line 222)
  • from /classes/Currency.php (line 222)
  • from /classes/controller/FrontController.php (line 460)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.123 ms SELECT * FROM `ps_contact` c LEFT JOIN ps_contact_shop contact_shop ON (contact_shop.id_contact = c.id_contact AND contact_shop.id_shop = ?) LEFT JOIN `ps_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`) WHERE cl.`id_lang` = ? AND contact_shop.`id_shop` IN (?) GROUP BY c.`id_contact` ORDER BY `name` ASC
  • in /data/wwwroot/www.0cm.com/classes/Contact.php (line 77)
  • from /classes/Contact.php (line 77)
  • from /controllers/front/ContactController.php (line 253)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.121 ms SELECT * FROM ps_memcached_servers
  • in /data/wwwroot/www.0cm.com/classes/cache/CacheMemcache.php (line 253)
  • from /classes/cache/CacheMemcache.php (line 253)
  • from /classes/cache/CacheMemcache.php (line 63)
  • from /classes/cache/CacheMemcache.php (line 45)
  • from /classes/cache/Cache.php (line 131)
  • from /classes/db/Db.php (line 605)
  • from /classes/shop/Shop.php (line 333)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.121 ms SELECT * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = ?) LIMIT ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/shop/Shop.php (line 515)
  • from /config/config.inc.php (line 157)
  • from /index.php (line 27)

0.119 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 /data/wwwroot/www.0cm.com/classes/shop/Shop.php (line 202)
  • from /classes/shop/Shop.php (line 202)
  • from /classes/shop/Shop.php (line 133)
  • from /classes/shop/Shop.php (line 393)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.117 ms SELECT c.*, cl.* FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = ? AND cl.id_shop = ? ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = ?) WHERE c.`id_category` = ? AND cs.`id_shop` = ? AND c.`id_parent` != ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Category.php (line 1161)
  • from /classes/Category.php (line 1161)
  • from /override/classes/Link.php (line 89)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 220)
  • from /modules/nq_navigation/nq_navigation.php (line 120)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.117 ms SELECT * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = ? AND cl.id_shop = ? WHERE (c.nleft <= ? AND c.nright >= ?) ORDER BY c.nleft
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 5585)
  • from /classes/Product.php (line 5585)
  • from /classes/Link.php (line 137)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 119)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.117 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 /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /config/config.inc.php (line 133)
  • from /index.php (line 27)

0.116 ms SELECT product_attribute_shop.id_product_attribute 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 product_attribute_shop.default_on = ? AND pa.id_product = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 714)
  • from /classes/Product.php (line 714)
  • from /override/classes/Product.php (line 439)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.114 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 /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/Category.php (line 137)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 219)
  • from /modules/nq_navigation/nq_navigation.php (line 120)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.114 ms SELECT DISTINCT c.* FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = ?) WHERE `level_depth` = ?
  • in /data/wwwroot/www.0cm.com/classes/Category.php (line 1587)
  • from /classes/Category.php (line 1587)
  • from /classes/Category.php (line 1138)
  • from /override/classes/Link.php (line 89)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 220)
  • from /modules/nq_navigation/nq_navigation.php (line 120)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.113 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 /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/Language.php (line 90)
  • from /config/config.inc.php (line 186)
  • from /index.php (line 27)

0.111 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 /data/wwwroot/www.0cm.com/classes/Language.php (line 841)
  • from /classes/Language.php (line 841)
  • from /classes/Language.php (line 938)
  • from /classes/Dispatcher.php (line 397)
  • from /classes/Dispatcher.php (line 221)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.111 ms SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = ? AND id_shop = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/ObjectModel.php (line 1388)
  • from /classes/ObjectModel.php (line 1388)
  • from /classes/Tools.php (line 474)
  • from /classes/controller/FrontController.php (line 241)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.11 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 /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/Currency.php (line 103)
  • from /classes/Currency.php (line 436)
  • from /classes/Tools.php (line 579)
  • from /classes/controller/FrontController.php (line 289)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.109 ms SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) WHERE p.id_product = ? AND DATEDIFF( product_shop.`date_add`, DATE_SUB( "?-?-? ?:?:?", INTERVAL ? DAY ) ) > ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 1195)
  • from /classes/Product.php (line 1195)
  • from /classes/Product.php (line 493)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.108 ms SELECT * FROM `ps_image_type`
  • in /data/wwwroot/www.0cm.com/classes/ImageType.php (line 142)
  • from /classes/ImageType.php (line 142)
  • from /classes/ImageType.php (line 169)
  • from /modules/facebookpsshoptab/conf/common.conf.php (line 209)
  • from /modules/facebookpsshoptab/facebookpsshoptab.php (line 128)
  • 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 1125)
  • from /classes/module/Module.php (line 1089)
  • from /override/classes/Hook.php (line 156)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.108 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 /data/wwwroot/www.0cm.com/classes/Currency.php (line 455)
  • from /classes/Currency.php (line 455)
  • from /classes/Currency.php (line 461)
  • from /classes/module/Module.php (line 2224)
  • from /modules/homecategory/homecategory.php (line 728)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.108 ms SELECT product_attribute_shop.id_product_attribute 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 = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 700)
  • from /classes/Product.php (line 700)
  • from /override/classes/Product.php (line 439)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.107 ms SELECT id_shop FROM `ps_group_shop` WHERE `id_group` = ? AND id_shop = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/ObjectModel.php (line 1388)
  • from /classes/ObjectModel.php (line 1388)
  • from /classes/Group.php (line 329)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 356)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.107 ms SELECT * FROM ps_navigation_entry e JOIN ps_navigation_entry_lang el ON el.id_entry = e.id_entry AND el.id_lang = ? WHERE e.active = ?
  • in /data/wwwroot/www.0cm.com/modules/nq_navigation/classes/NavigationEntry.php (line 59)
  • from /modules/nq_navigation/classes/NavigationEntry.php (line 59)
  • from /modules/nq_navigation/nq_navigation.php (line 125)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.106 ms SELECT domain, domain_ssl FROM ps_shop_url WHERE main = ? AND id_shop = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/shop/ShopUrl.php (line 163)
  • from /classes/shop/ShopUrl.php (line 163)
  • from /classes/shop/ShopUrl.php (line 177)
  • from /classes/Tools.php (line 304)
  • from /classes/Link.php (line 52)
  • from /config/config.inc.php (line 223)
  • from /index.php (line 27)

0.106 ms SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = ? AND id_shop = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/ObjectModel.php (line 1388)
  • from /classes/ObjectModel.php (line 1388)
  • from /classes/Tools.php (line 584)
  • from /classes/controller/FrontController.php (line 289)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.105 ms SELECT * FROM `ps_shop` a WHERE (a.`id_shop` = ?) LIMIT ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/shop/Shop.php (line 131)
  • from /classes/shop/Shop.php (line 393)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.105 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 /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/Group.php (line 75)
  • from /classes/Group.php (line 327)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 356)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.104 ms SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
  • in /data/wwwroot/www.0cm.com/classes/Language.php (line 736)
  • from /classes/Language.php (line 736)
  • from /config/config.inc.php (line 130)
  • from /index.php (line 27)

0.103 ms SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = ?) WHERE i.`id_product` = ? AND image_shop.`cover` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 2588)
  • from /classes/Product.php (line 2588)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 115)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.102 ms SELECT * FROM `ps_theme` a WHERE (a.`id_theme` = ?) LIMIT ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /config/config.inc.php (line 106)
  • from /index.php (line 27)

0.102 ms SELECT UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 150)
  • from /classes/SmartyCustom.php (line 150)
  • from /classes/SmartyCustom.php (line 126)
  • from /classes/module/Module.php (line 2274)
  • from /classes/module/Module.php (line 2320)
  • from /modules/homecategory/homecategory.php (line 728)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.101 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/stock/StockAvailable.php (line 379)
  • from /classes/stock/StockAvailable.php (line 379)
  • from /classes/Product.php (line 5596)
  • from /classes/Product.php (line 503)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.101 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = ? AND `active` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Manufacturer.php (line 241)
  • from /classes/Manufacturer.php (line 241)
  • from /classes/Product.php (line 485)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.1 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/SpecificPrice.php (line 189)
  • from /classes/SpecificPrice.php (line 189)
  • from /classes/SpecificPrice.php (line 169)
  • from /override/classes/SpecificPrice.php (line 43)
  • from /override/classes/Product.php (line 464)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.098 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = ? AND `id_group` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/GroupReduction.php (line 144)
  • from /classes/GroupReduction.php (line 144)
  • from /override/classes/Product.php (line 616)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.098 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "braintreejs" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2136)
  • from /modules/braintreejs/braintreejs.php (line 59)
  • 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 1125)
  • from /classes/module/Module.php (line 1089)
  • from /override/classes/Hook.php (line 156)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.097 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "cloudcache" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2136)
  • from /modules/facebookpsshoptab/lib/module-tools_class.php (line 933)
  • from /modules/facebookpsshoptab/facebookpsshoptab.php (line 181)
  • 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 1125)
  • from /classes/module/Module.php (line 1089)
  • from /override/classes/Hook.php (line 156)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.097 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "faktiva_clean_urls" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2163)
  • from /override/classes/Dispatcher.php (line 7)
  • from /classes/Dispatcher.php (line 230)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.096 ms SELECT * FROM `ps_navigation_tab` a WHERE (a.`id_navigation_tab` = ?) LIMIT ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /modules/nq_navigation/nq_navigation.php (line 384)
  • from /modules/nq_navigation/nq_navigation.php (line 121)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.096 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 4761)
  • from /classes/Product.php (line 4761)
  • from /override/classes/Product.php (line 547)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.096 ms SELECT `id_country` FROM `ps_country` WHERE `iso_code` = 'US' LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Country.php (line 170)
  • from /classes/Country.php (line 170)
  • from /classes/controller/FrontController.php (line 890)
  • from /classes/controller/FrontController.php (line 261)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.095 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (?)
  • in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2086)
  • from /classes/module/Module.php (line 2086)
  • from /override/classes/Hook.php (line 133)
  • from /override/controllers/front/ContactController.php (line 34)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.095 ms SELECT UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 99)
  • from /classes/SmartyCustom.php (line 99)
  • from /classes/SmartyCustom.php (line 123)
  • from /classes/module/Module.php (line 2274)
  • from /classes/module/Module.php (line 2248)
  • from /modules/recaptcha/recaptcha.php (line 379)
  • from /modules/recaptcha/recaptcha.php (line 369)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /override/controllers/front/ContactController.php (line 34)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.094 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Group.php (line 132)
  • from /classes/Group.php (line 132)
  • from /override/classes/Product.php (line 622)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.094 ms SELECT pc.* FROM `ps_pcharming` pc WHERE pc.`id_currency` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/modules/pricecharming/includes/pricecharming.php (line 11)
  • from /modules/pricecharming/includes/pricecharming.php (line 11)
  • from /override/classes/Product.php (line 640)
  • from /classes/Product.php (line 2739)
  • from /classes/Product.php (line 498)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.094 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = ? AND cl.id_shop = ? AND cl.`id_category` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Category.php (line 1003)
  • from /classes/Category.php (line 1003)
  • from /classes/Product.php (line 507)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.093 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/stock/StockAvailable.php (line 724)
  • from /classes/stock/StockAvailable.php (line 724)
  • from /classes/Product.php (line 5597)
  • from /classes/Product.php (line 503)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.093 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/stock/StockAvailable.php (line 701)
  • from /classes/stock/StockAvailable.php (line 701)
  • from /classes/Product.php (line 5598)
  • from /classes/Product.php (line 503)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.093 ms SELECT * FROM `ps_group_lang` WHERE `id_group` = ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 70)
  • from /Adapter/Adapter_EntityMapper.php (line 70)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/Group.php (line 75)
  • from /classes/Group.php (line 327)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 356)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /override/controllers/front/ContactController.php (line 36)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.093 ms SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Category.php (line 1400)
  • from /classes/Category.php (line 1400)
  • from /classes/Product.php (line 5578)
  • from /classes/Link.php (line 137)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 119)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.092 ms SELECT COUNT(*) FROM ps_shop LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/shop/Shop.php (line 1034)
  • from /classes/shop/Shop.php (line 1034)
  • from /classes/Configuration.php (line 186)
  • from /classes/Configuration.php (line 237)
  • from /classes/shop/Shop.php (line 366)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.092 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=?
  • in /data/wwwroot/www.0cm.com/classes/Tag.php (line 201)
  • from /classes/Tag.php (line 201)
  • from /classes/Product.php (line 501)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.091 ms SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = ? LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = ? WHERE (a.`id_manufacturer` = ?) LIMIT ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
  • from /Adapter/Adapter_EntityMapper.php (line 62)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/Manufacturer.php (line 103)
  • from /override/classes/Link.php (line 131)
  • from /cache/smarty/compile/de/31/28/de312835ca03d00f7123f4b40b3a20fee8af53d6.file.footer.tpl.php (line 143)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/be/e2/b8/bee2b880b5e4484143180b13fb84bd0f788ef655.file.layout.tpl.php (line 42)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/Controller.php (line 505)
  • from /classes/controller/FrontController.php (line 722)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.091 ms SELECT id_required_field, object_name, field_name FROM ps_required_field
  • in /data/wwwroot/www.0cm.com/classes/ObjectModel.php (line 1311)
  • from /classes/ObjectModel.php (line 1311)
  • from /classes/ObjectModel.php (line 1323)
  • from /classes/ObjectModel.php (line 958)
  • from /classes/ObjectModel.php (line 877)
  • from /classes/ObjectModel.php (line 245)
  • from /classes/ObjectModel.php (line 469)
  • from /classes/ObjectModel.php (line 431)
  • from /classes/Guest.php (line 191)
  • from /modules/statsdata/statsdata.php (line 74)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1018)
  • from /override/classes/controller/Controller.php (line 58)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.09 ms SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Supplier.php (line 185)
  • from /classes/Supplier.php (line 185)
  • from /classes/Product.php (line 486)
  • from /override/classes/Product.php (line 365)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 113)
  • from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /classes/module/Module.php (line 2248)
  • from /modules/nq_navigation/nq_navigation.php (line 360)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.088 ms SELECT * FROM `ps_navigation_tab_lang` WHERE `id_navigation_tab` = ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 70)
  • from /Adapter/Adapter_EntityMapper.php (line 70)
  • from /classes/ObjectModel.php (line 232)
  • from /modules/nq_navigation/nq_navigation.php (line 384)
  • from /modules/nq_navigation/nq_navigation.php (line 121)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ContactController.php (line 223)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.081 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blockwishlist" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2163)
  • from /cache/smarty/compile/a0/41/3f/a0413f5e2e4afac3e97b8c2ebec9c7dbda931655.file.header.tpl.php (line 318)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/be/e2/b8/bee2b880b5e4484143180b13fb84bd0f788ef655.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/Controller.php (line 505)
  • from /classes/controller/FrontController.php (line 722)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.074 ms SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = ? AND `id_shop` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2164)
  • from /classes/module/Module.php (line 2164)
  • from /override/classes/Dispatcher.php (line 7)
  • from /classes/Dispatcher.php (line 230)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.071 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "favoriteproducts" LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2500)
  • from /classes/module/Module.php (line 2163)
  • from /cache/smarty/compile/a0/41/3f/a0413f5e2e4afac3e97b8c2ebec9c7dbda931655.file.header.tpl.php (line 325)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 329)
  • from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
  • from /cache/smarty/compile/be/e2/b8/bee2b880b5e4484143180b13fb84bd0f788ef655.file.layout.tpl.php (line 38)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/Controller.php (line 505)
  • from /classes/controller/FrontController.php (line 722)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)
Doubles (IDs replaced by "?")

826 SELECT c.*, cl.* FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = ? AND cl.id_shop = ? ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = ?) WHERE c.`id_category` = ? AND cs.`id_shop` = ? AND c.`id_parent` != ? LIMIT ?
157 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 ?
52 SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=?
52 SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
52 SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) WHERE p.id_product = ? AND DATEDIFF( product_shop.`date_add`, DATE_SUB( "?-?-? ?:?:?", INTERVAL ? DAY ) ) > ?
52 SELECT * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = ? AND cl.id_shop = ? WHERE (c.nleft <= ? AND c.nright >= ?) ORDER BY c.nleft
52 SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
22 SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = ? LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = ? WHERE (a.`id_manufacturer` = ?) LIMIT ?
17 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
17 SELECT * FROM `ps_navigation_tab` a WHERE (a.`id_navigation_tab` = ?) LIMIT ?
17 SELECT * FROM `ps_navigation_tab_lang` WHERE `id_navigation_tab` = ?
14 SELECT * FROM ps_navigation_entry e JOIN ps_navigation_entry_lang el ON el.id_entry = e.id_entry AND el.id_lang = ? WHERE e.active = ?
8 SELECT pc.* FROM `ps_pcharming` pc WHERE pc.`id_currency` = ? LIMIT ?
4 SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = ?) WHERE i.`id_product` = ? AND image_shop.`cover` = ? LIMIT ?
4 SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` USE INDEX (id_product_?) WHERE `id_product` IN (?, ?) AND `id_product_attribute` IN (?, ?) AND `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_customer` IN (?, ?) AND ( (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) ) AND id_cart IN (?, ?) 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 ?
4 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` = ?)
4 SELECT product_attribute_shop.id_product_attribute 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 product_attribute_shop.default_on = ? AND pa.id_product = ? LIMIT ?
4 SELECT product_attribute_shop.id_product_attribute 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 = ? LIMIT ?
4 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 ?
4 SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = ? AND `active` = ? LIMIT ?
4 SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = ? LIMIT ?
4 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? LIMIT ?
4 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC LIMIT ?
4 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
4 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = ? LIMIT ?
4 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = ? AND cl.id_shop = ? AND cl.`id_category` = ? LIMIT ?
4 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = ? AND `id_group` = ? LIMIT ?
3 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
3 SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = ? AND `id_shop` = ? LIMIT ?
Tables stress

1057 category_lang
1040 category
983 category_shop
108 stock_available
64 product_shop
60 product
52 product_tag
52 tag
29 manufacturer
25 manufacturer_shop
25 manufacturer_lang
21 product_lang
18 navigation_tab_lang
18 navigation_tab
17 navigation_block
17 navigation_tab_link
17 navigation_tab_block
17 navigation_tab_link_lang
17 navigation_tab_block_lang
14 navigation_entry_lang
14 navigation_entry
12 product_attribute_shop
8 module
8 product_attribute
8 pcharming
6 module_shop
5 shop
4 shop_url
4 image
4 lang_shop
4 image_shop
4 product_group_reduction_cache
4 supplier
4 currency_shop
4 specific_price
4 specific_price_priority
4 hook
3 meta
3 currency
3 lang
3 theme
2 smarty_lazy_cache
2 hook_module
2 country
2 configuration
2 shop_group
2 meta_lang
2 hook_alias
2 smarty_last_flush
2 group
2 group_shop
1 page
1 page_type
1 connections
1 contact
1 required_field
1 contact_shop
1 contact_lang
1 memcached_servers
1 country_shop
1 country_lang
1 configuration_lang
1 module_group
1 theme_meta
1 group_lang
1 hook_module_exceptions
1 image_type
Hook processing : 701ms - 13.76Mb
  • moduleRoutes : 5ms - 0.77Mb
  • prestatemplate: 0ms - 0.06Mb
  • contactFormBottom : 2ms - 0.2Mb
  • recaptcha: 2ms - 0.2Mb
  • displayHeader : 28ms - 4.19Mb
  • blockcart: 1ms - 0.08Mb
  • blocklayered: 0ms - 0.18Mb
  • homeslider: 0ms - 0.09Mb
  • blockuserinfo: 0ms - 0.06Mb
  • blocknewsletter: 0ms - 0.08Mb
  • blockviewed: 0ms - 0.06Mb
  • nq_universe: 0ms - 0.09Mb
  • socialsharing: 0ms - 0.06Mb
  • blockbestsellers: 0ms - 0.06Mb
  • nq_categoryhomepage: 0ms - 0.06Mb
  • nq_navigation: 1ms - 0.27Mb
  • infinitescroll: 0ms - 0.06Mb
  • favoriteproducts: 1ms - 0.08Mb
  • nq_mosaic: 0ms - 0.06Mb
  • nq_morefeature: 0ms - 0.07Mb
  • shoperize: 1ms - 0.26Mb
  • facebookpsconnect: 3ms - 0.18Mb
  • nq_brands: 0ms - 0.14Mb
  • ganalytics: 1ms - 0.08Mb
  • mailalerts: 0ms - 0.14Mb
  • nq_follow_brand: 1ms - 0.1Mb
  • braintreejs: 1ms - 0.17Mb
  • hreflang_on_pages: 1ms - 0.08Mb
  • nq_checkcurrency: 0ms - 0.05Mb
  • doofinder: 4ms - 0.1Mb
  • categoryslider: 0ms - 0.1Mb
  • genderpushes: 0ms - 0.1Mb
  • recaptcha: 0ms - 0Mb
  • nq_genderchoice: 0ms - 0.06Mb
  • codegenerator: 0ms - 0.06Mb
  • cedamazon: 0ms - 0.19Mb
  • cedrakutenaffiliate: 0ms - 0.06Mb
  • homefeatured: 0ms - 0.06Mb
  • facebookpsshoptab: 2ms - 0.4Mb
  • wkfacebookwallfeed: 0ms - 0.06Mb
  • ambjolisearch: 1ms - 0.25Mb
  • homecategory: 3ms - 0.18Mb
  • displayTop : 509ms - 5.21Mb
  • blockuserinfo: 0ms - 0.02Mb
  • nq_navigation: 507ms - 5.22Mb
  • infinitescroll: 0ms - -0.09Mb
  • facebookpsconnect: 0ms - 0.03Mb
  • ambjolisearch: 1ms - 0.02Mb
  • displayDailySpecialWomen : 10ms - 0.05Mb
  • nq_dailyspecial: 10ms - 0.05Mb
  • displayDailySpecialMen : 10ms - 0.05Mb
  • nq_dailyspecial: 10ms - 0.05Mb
  • displayDailySpecialKids : 10ms - 0.06Mb
  • nq_dailyspecial: 10ms - 0.06Mb
  • displayDailySpecialHome : 10ms - 0.06Mb
  • nq_dailyspecial: 10ms - 0.06Mb
  • displayFooter : 10ms - 0.65Mb
  • statsdata: 4ms - 0.39Mb
  • nq_footerlinks: 3ms - 0.09Mb
  • blocknewsletter: 1ms - 0.02Mb
  • happybirthday: 0ms - 0.06Mb
  • facebookpsconnect: 0ms - 0.04Mb
  • ganalytics: 0ms - 0Mb
  • commissionfactory: 0ms - 0.05Mb
  • cedrakutenaffiliate: 0ms - 0Mb
  • displayNav : 1ms - 0.03Mb
  • blockuserinfo: 1ms - 0.02Mb
  • blockcart: 0ms - 0.01Mb