Shorts - 0cm

Configuration Information

Controller | CategoryController
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.101s
config: 0ms
Controller::init(): 14ms
Controller::setMedia(): 2ms
Controller::postProcess(): 3ms
Controller::initHeader(): 0ms
Controller::initContent(): 558ms
Controller::initFooter(): 9ms
Controller::display(): 515ms

Memory peak usage

Total : 19.98 Mb
config: 0.01 Mb
Controller::init(): 1.57 Mb
Controller::setMedia(): 0.13 Mb
Controller::postProcess(): 0.25 Mb
Controller::initHeader(): 0.01 Mb
Controller::initContent(): 9.8 Mb
Controller::initFooter(): 0.67 Mb
Controller::display(): 0.5 Mb

Size of included files (301 files)

Total : 5.53Mb

Globals variables

Globals (> 1 Ko only) : 9353 Ko
context : ≈ 4196.4 Ko
smarty : ≈ 4105.3 Ko
_MODULES : ≈ 307.6 Ko
_LANG : ≈ 186.5 Ko
cookie : ≈ 152.2 Ko
customer : ≈ 45.4 Ko
NQ_ID : ≈ 33.1 Ko
container : ≈ 32.4 Ko
cart : ≈ 32.1 Ko
FPS_MONTH : ≈ 26.8 Ko
defaultCountry : ≈ 23.7 Ko
default_country : ≈ 23.6 Ko
FPS_CONFIGURATION : ≈ 23.3 Ko
FPS_CONFIG_CSS : ≈ 23.1 Ko
FBPSC_MONTH : ≈ 21.5 Ko
FPS_CSS_DEFAULT : ≈ 20.6 Ko
currency : ≈ 19.8 Ko
language : ≈ 16.9 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 : 1537 queries | Time spent querying : 177ms

Stopwatch (with SQL_NO_CACHE)

0.876 ms CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY SELECT cp.id_product, MIN(cp.position) position FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= ? AND c.nright <= ? AND c.active = ?) JOIN `ps_product` p USING (id_product) LEFT JOIN `ps_stock_available` sa ON (sa.id_product = p.id_product AND sa.id_shop_group = ? AND sa.id_shop = ? ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) LEFT JOIN ps_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = ? AND stock.id_shop_group = ? AND stock.id_shop = ? ) WHERE ? AND product_shop.`active` = ? AND product_shop.`visibility` IN ("both", "catalog") AND sa.quantity > ? AND stock.quantity > ? GROUP BY cp.id_product ORDER BY position, id_product

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 1951)
from /modules/blocklayered/blocklayered.php (line 1951)
from /modules/blocklayered/blocklayered.php (line 3235)
from /modules/blocklayered/blocklayered.php (line 654)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /controllers/front/CategoryController.php (line 220)
from /override/controllers/front/CategoryController.php (line 217)
from /controllers/front/CategoryController.php (line 146)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.872 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.756 ms SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = ?) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = ? AND cl.id_shop = ? ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = ? AND `active` = ? AND cg.`id_group` =? GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC

in /data/wwwroot/www.0cm.com/classes/Category.php (line 634)
from /classes/Category.php (line 634)
from /controllers/front/CategoryController.php (line 200)
from /controllers/front/CategoryController.php (line 145)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.646 ms CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= ? AND c.nright <= ? AND c.active = ?) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = ?) INNER JOIN ps_product p ON (p.id_product=cp.id_product) WHERE product_shop.`active` = ? AND product_shop.`visibility` IN ("both", "catalog")

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2147)
from /modules/blocklayered/blocklayered.php (line 2147)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.498 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.451 ms SELECT c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # FROM ps_category_product cp LEFT JOIN ps_product p ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) WHERE cp.id_category = c.id_category AND product_shop.active = ? AND product_shop.`visibility` IN ("both", "catalog") ) count_products FROM ps_category c LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = ? and cl.id_lang = ?) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (?)) WHERE c.nleft > ? AND c.nright < ? AND c.active = ? GROUP BY c.id_category ORDER BY c.nleft, c.position

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2387)
from /modules/blocklayered/blocklayered.php (line 2387)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.431 ms SELECT COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group, a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group, liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title FROM ps_layered_product_attribute lpa INNER JOIN ps_attribute a ON a.id_attribute = lpa.id_attribute INNER JOIN ps_attribute_lang al ON al.id_attribute = a.id_attribute AND al.id_lang = ? INNER JOIN ps_cat_restriction p ON p.id_product = lpa.id_product INNER JOIN ps_attribute_group ag ON ag.id_attribute_group = lpa.id_attribute_group INNER JOIN ps_attribute_group_lang agl ON agl.id_attribute_group = lpa.id_attribute_group AND agl.id_lang = ? LEFT JOIN ps_layered_indexable_attribute_group_lang_value liagl ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = ?) LEFT JOIN ps_layered_indexable_attribute_lang_value lial ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = ?) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) WHERE lpa.id_attribute_group = ? AND lpa.`id_shop` = ? GROUP BY lpa.id_attribute ORDER BY ag.`position` ASC, a.`position` ASC

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2387)
from /modules/blocklayered/blocklayered.php (line 2387)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.393 ms SELECT c.id_category, cl.name, cl.link_rewrite FROM ps_category c LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = ? ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = ?) WHERE c.nleft <= ? AND c.nright >= ? AND c.nleft >= ? AND c.nright <= ? AND cl.id_lang = ? AND c.active = ? AND c.level_depth > ? ORDER BY c.level_depth ASC

in /data/wwwroot/www.0cm.com/classes/Tools.php (line 1251)
from /classes/Tools.php (line 1251)
from /controllers/front/CategoryController.php (line 155)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.381 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.359 ms SELECT `id_category` FROM `ps_category_lang` WHERE `link_rewrite` = 'shorts' AND `id_lang` = ? AND `id_shop` = ? LIMIT ?

in /data/wwwroot/www.0cm.com/override/classes/Dispatcher.php (line 398)
from /override/classes/Dispatcher.php (line 398)
from /override/classes/Dispatcher.php (line 274)
from /classes/Dispatcher.php (line 261)
from /index.php (line 28)

0.332 ms ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product), ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE, ADD KEY `condition` (`condition`,`id_product`) USING BTREE, ADD KEY `weight` (`weight`,`id_product`) USING BTREE

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2153)
from /modules/blocklayered/blocklayered.php (line 2153)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.331 ms SELECT s.* FROM `ps_scene_category` sc LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN ps_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = ?) LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = ? AND sl.id_lang = ? AND s.active = ? ORDER BY sl.name ASC

in /data/wwwroot/www.0cm.com/classes/Scene.php (line 218)
from /classes/Scene.php (line 218)
from /controllers/front/CategoryController.php (line 61)
from /override/classes/controller/Controller.php (line 31)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.327 ms SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value, COUNT(DISTINCT p.id_product) nbr, lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title FROM ps_feature_product fp INNER JOIN ps_cat_restriction p ON p.id_product = fp.id_product LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = ?) INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = ?)) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_layered_indexable_feature_lang_value lifl ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = ?) LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = ?) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) WHERE fp.id_feature = ? GROUP BY fv.id_feature_value

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2387)
from /modules/blocklayered/blocklayered.php (line 2387)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.308 ms SELECT b.id_parent_entry FROM ps_navigation_tab_link a JOIN ps_navigation_tab b ON b.id_navigation_tab = a.id_navigation_tab WHERE a.id_category = ? LIMIT ?

in /data/wwwroot/www.0cm.com/modules/nq_navigation/nq_navigation.php (line 420)
from /modules/nq_navigation/nq_navigation.php (line 420)
from /modules/nq_navigation/nq_navigation.php (line 167)
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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.301 ms ALTER TABLE ps_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 1963)
from /modules/blocklayered/blocklayered.php (line 1963)
from /modules/blocklayered/blocklayered.php (line 3235)
from /modules/blocklayered/blocklayered.php (line 654)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /controllers/front/CategoryController.php (line 220)
from /override/controllers/front/CategoryController.php (line 217)
from /controllers/front/CategoryController.php (line 146)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.29 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.26 ms SELECT type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = ? AND id_shop = ? GROUP BY `type`, id_value ORDER BY position ASC

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2133)
from /modules/blocklayered/blocklayered.php (line 2133)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.26 ms SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = ? AND `id_object` = ? 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.248 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.246 ms SELECT COUNT(*) FROM ps_layered_category WHERE id_category = ? AND id_shop = ? LIMIT ?

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 636)
from /modules/blocklayered/blocklayered.php (line 636)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /controllers/front/CategoryController.php (line 220)
from /override/controllers/front/CategoryController.php (line 217)
from /controllers/front/CategoryController.php (line 146)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.239 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.239 ms SELECT `id_category` FROM `ps_category_lang` WHERE `link_rewrite` = 'shorts' AND `id_lang` = ? AND `id_shop` = ?

in /data/wwwroot/www.0cm.com/override/controllers/front/CategoryController.php (line 79)
from /override/controllers/front/CategoryController.php (line 79)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.238 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.237 ms SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = ? WHERE (a.`id_category` = ?) 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 /override/controllers/front/CategoryController.php (line 150)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.226 ms SELECT * FROM `ps_category_lang` WHERE `id_category` = ? AND `id_shop` = ?

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/Category.php (line 137)
from /override/controllers/front/CategoryController.php (line 150)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.221 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/Category.php (line 1419)
from /controllers/front/CategoryController.php (line 81)
from /classes/controller/FrontController.php (line 412)
from /override/classes/controller/FrontController.php (line 53)
from /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.213 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.19 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.185 ms SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `ps_category_lang` cl WHERE cl.`id_lang` = ? AND cl.`id_category` = ? AND cl.id_shop = ? LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Meta.php (line 282)
from /classes/Meta.php (line 282)
from /classes/Meta.php (line 201)
from /classes/controller/FrontController.php (line 403)
from /override/classes/controller/FrontController.php (line 53)
from /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.184 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.179 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.164 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.159 ms SELECT COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer, m.name FROM ps_cat_restriction p INNER JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) WHERE ? GROUP BY p.id_manufacturer ORDER BY m.name

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2387)
from /modules/blocklayered/blocklayered.php (line 2387)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.153 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.151 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = ? AND ctg.`id_group` = ? LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Category.php (line 1247)
from /classes/Category.php (line 1247)
from /controllers/front/CategoryController.php (line 117)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.149 ms SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = ? AND id_shop = ? LIMIT ?

in /data/wwwroot/www.0cm.com/classes/ObjectModel.php (line 1388)
from /classes/ObjectModel.php (line 1388)
from /controllers/front/CategoryController.php (line 81)
from /classes/controller/FrontController.php (line 412)
from /override/classes/controller/FrontController.php (line 53)
from /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.149 ms SELECT s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = ? INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = ?) WHERE (s.`active` = ?) GROUP BY s.id_supplier ORDER BY s.`name` ASC

in /data/wwwroot/www.0cm.com/classes/Supplier.php (line 124)
from /classes/Supplier.php (line 124)
from /controllers/front/CategoryController.php (line 163)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.147 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.146 ms DROP TEMPORARY TABLE IF EXISTS ps_cat_filter_restriction

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 1937)
from /modules/blocklayered/blocklayered.php (line 1937)
from /modules/blocklayered/blocklayered.php (line 3235)
from /modules/blocklayered/blocklayered.php (line 654)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /controllers/front/CategoryController.php (line 220)
from /override/controllers/front/CategoryController.php (line 217)
from /controllers/front/CategoryController.php (line 146)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.14 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.138 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.136 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.135 ms DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2137)
from /modules/blocklayered/blocklayered.php (line 2137)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.124 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.121 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.119 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.117 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.115 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 /controllers/front/CategoryController.php (line 105)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.114 ms SELECT COUNT(*) FROM ps_cat_filter_restriction LIMIT ?

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2012)
from /modules/blocklayered/blocklayered.php (line 2012)
from /modules/blocklayered/blocklayered.php (line 3235)
from /modules/blocklayered/blocklayered.php (line 654)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /controllers/front/CategoryController.php (line 220)
from /override/controllers/front/CategoryController.php (line 217)
from /controllers/front/CategoryController.php (line 146)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.113 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.112 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.112 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 /controllers/front/CategoryController.php (line 88)
from /classes/controller/FrontController.php (line 412)
from /override/classes/controller/FrontController.php (line 53)
from /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.111 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.111 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.108 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.107 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.106 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.106 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.105 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 /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.104 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.103 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.102 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 = "category" 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.102 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.101 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.1 ms SELECT id_page_type FROM ps_page_type WHERE name = 'category' 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.1 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.099 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.099 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 /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.099 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.098 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.097 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
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` = "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.097 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.097 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.097 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 /controllers/front/CategoryController.php (line 88)
from /classes/controller/FrontController.php (line 412)
from /override/classes/controller/FrontController.php (line 53)
from /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.096 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.095 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.093 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.093 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.093 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.092 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.091 ms SELECT * FROM `ps_image_type` WHERE ? ORDER BY `name` ASC

in /data/wwwroot/www.0cm.com/classes/ImageType.php (line 107)
from /classes/ImageType.php (line 107)
from /override/classes/controller/FrontController.php (line 94)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.091 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)

0.09 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 /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.09 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.09 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.089 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '?c?ace?e?ca?c?f?bd?d' LIMIT ?

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 1721)
from /modules/blocklayered/blocklayered.php (line 1721)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.088 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.087 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.087 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.087 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.087 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.086 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'large_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.085 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = 'de?ab?a?c?d?af?aa?c?c?' LIMIT ?

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 1721)
from /modules/blocklayered/blocklayered.php (line 1721)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.085 ms SELECT public_name FROM `ps_attribute_group_lang` agl LEFT JOIN `ps_layered_indexable_attribute_group` liag ON liag.id_attribute_group = agl.id_attribute_group WHERE indexable IS NULL OR indexable = ? AND id_lang = ?

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2726)
from /modules/blocklayered/blocklayered.php (line 2726)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.085 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.083 ms SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '?cd?b?a?d?d?c?b?f' LIMIT ?

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 1721)
from /modules/blocklayered/blocklayered.php (line 1721)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.082 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 /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.081 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 /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.081 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/favoriteproducts/favoriteproducts.php (line 109)
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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
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` = "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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.08 ms SELECT name FROM `ps_feature_lang` fl LEFT JOIN `ps_layered_indexable_feature` lif ON lif.id_feature = fl.id_feature WHERE indexable IS NULL OR indexable = ? AND id_lang = ?

in /data/wwwroot/www.0cm.com/modules/blocklayered/blocklayered.php (line 2736)
from /modules/blocklayered/blocklayered.php (line 2736)
from /modules/blocklayered/blocklayered.php (line 687)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 245)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.08 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.078 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 /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.078 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 /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.077 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'carousel?x' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.077 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.077 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/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.076 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 /controllers/front/CategoryController.php (line 107)
from /override/controllers/front/CategoryController.php (line 132)
from /override/classes/controller/Controller.php (line 23)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.075 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.075 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.073 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.073 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'scene_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.073 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'cart_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.072 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 /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/CategoryController.php (line 131)
from /override/controllers/front/CategoryController.php (line 34)
from /override/classes/controller/Controller.php (line 50)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.072 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.072 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'small_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.072 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.072 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'product_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.071 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'thickbox_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.07 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'original_default' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.069 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'nq_social_share' LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
from /classes/Image.php (line 441)
from /override/classes/controller/FrontController.php (line 96)
from /override/classes/controller/Controller.php (line 36)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

Doubles (IDs replaced by "?")

855 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 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 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 * 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 ?

52 SELECT depends_on_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 * FROM `ps_navigation_tab_lang` WHERE `id_navigation_tab` = ?

17 SELECT * FROM `ps_navigation_tab` a WHERE (a.`id_navigation_tab` = ?) 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

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 ?

6 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = ? LIMIT ?

4 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = ? AND `id_group` = ? LIMIT ?

4 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? 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 `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = ? AND `active` = ? 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_supplier` WHERE `id_supplier` = ? 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC 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 product_attribute_shop.default_on = ? AND pa.id_product = ? 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 *, ( 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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = ? AND cl.id_shop = ? AND cl.`id_category` = ? 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 ?

3 SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '?c?ace?e?ca?c?f?bd?d' LIMIT ?

3 SELECT * FROM `ps_category_lang` WHERE `id_category` = ? AND `id_shop` = ?

3 SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = 'de?ab?a?c?d?af?aa?c?c?' LIMIT ?

3 SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '?cd?b?a?d?d?c?b?f' LIMIT ?

3 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = ? WHERE (a.`id_category` = ?) 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 ?

2 SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value, COUNT(DISTINCT p.id_product) nbr, lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title FROM ps_feature_product fp INNER JOIN ps_cat_restriction p ON p.id_product = fp.id_product LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = ?) INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = ?)) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_layered_indexable_feature_lang_value lifl ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = ?) LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = ?) LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) WHERE fp.id_feature = ? GROUP BY fv.id_feature_value

Tables stress

1095 category_lang

1079 category

1018 category_shop

110 stock_available

67 product_shop

63 product

52 product_tag

52 tag

34 manufacturer

25 manufacturer_shop

25 manufacturer_lang

21 product_lang

19 navigation_tab

18 navigation_tab_link

18 navigation_tab_lang

17 navigation_tab_block_lang

17 navigation_block

17 navigation_tab_link_lang

17 navigation_tab_block

15 image_type

14 navigation_entry_lang

14 navigation_entry

12 product_attribute_shop

9 layered_friendly_url

8 pcharming

8 module

8 product_attribute

6 module_shop

5 shop

5 supplier

4 shop_url

4 cat_restriction

4 specific_price

4 specific_price_priority

4 lang_shop

4 product_group_reduction_cache

4 image

4 currency_shop

4 hook

4 image_shop

3 lang

3 feature_lang

3 category_group

3 theme

3 currency

3 category_product

2 group

2 smarty_last_flush

2 country

2 smarty_lazy_cache

2 meta

2 layered_indexable_feature_value_lang_value

2 hook_alias

2 shop_group

2 configuration

2 feature_value

2 layered_indexable_feature_lang_value

2 layered_category

2 group_shop

2 attribute_group_lang

2 feature_product

2 feature_value_lang

2 hook_module

1 connections

1 supplier_lang

1 required_field

1 supplier_shop

1 cat_filter_restriction

1 page

1 page_type

1 attribute_lang

1 theme_meta

1 group_lang

1 scene_category

1 scene

1 meta_lang

1 module_group

1 configuration_lang

1 country_lang

1 country_shop

1 scene_shop

1 scene_lang

1 layered_indexable_attribute_group_lang_value

1 layered_indexable_attribute_lang_value

1 layered_indexable_attribute_group

1 attribute_group

1 memcached_servers

1 hook_module_exceptions

1 layered_product_attribute

1 attribute

1 layered_indexable_feature

Hook processing : 717ms - 13.7Mb

moduleRoutes : 5ms - 0.77Mb
prestatemplate: 0ms - 0.06Mb

displayHeader : 39ms - 4.44Mb
blockcart: 1ms - 0.09Mb
blocklayered: 8ms - 0.33Mb
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.09Mb
nq_mosaic: 0ms - 0.06Mb
nq_morefeature: 0ms - 0.07Mb
shoperize: 1ms - 0.26Mb
facebookpsconnect: 3ms - 0.22Mb
nq_brands: 0ms - 0.14Mb
ganalytics: 1ms - 0.08Mb
mailalerts: 0ms - 0.14Mb
nq_follow_brand: 1ms - 0.1Mb
braintreejs: 1ms - 0.19Mb
hreflang_on_pages: 2ms - 0.09Mb
nq_checkcurrency: 0ms - 0.05Mb
doofinder: 4ms - 0.1Mb
categoryslider: 1ms - 0.12Mb
genderpushes: 0ms - 0.1Mb
recaptcha: 0ms - 0.06Mb
nq_genderchoice: 0ms - 0.06Mb
codegenerator: 0ms - 0.06Mb
cedamazon: 0ms - 0.19Mb
cedrakutenaffiliate: 0ms - 0.06Mb
homefeatured: 0ms - 0.06Mb
facebookpsshoptab: 2ms - 0.32Mb
wkfacebookwallfeed: 0ms - 0.06Mb
ambjolisearch: 1ms - 0.26Mb
homecategory: 3ms - 0.18Mb

displayTop : 507ms - 4.99Mb
blockuserinfo: 0ms - 0.02Mb
nq_navigation: 505ms - 4.99Mb
infinitescroll: 0ms - -0.09Mb
facebookpsconnect: 0ms - 0.04Mb
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

displayLeftColumn : 2ms - 0.07Mb
blocklayered: 1ms - -0.01Mb
facebookpsconnect: 0ms - 0.04Mb
wkfacebookwallfeed: 1ms - 0.04Mb

displayRightColumn : 0ms - 0.03Mb
facebookpsconnect: 0ms - 0.03Mb
wkfacebookwallfeed: 0ms - 0Mb

actionProductListOverride : 4ms - 0.06Mb
blocklayered: 4ms - 0.06Mb

displayFooter : 9ms - 0.65Mb
statsdata: 4ms - 0.37Mb
nq_footerlinks: 3ms - 0.09Mb
blocknewsletter: 1ms - 0.02Mb
happybirthday: 0ms - 0.06Mb
facebookpsconnect: 1ms - 0.04Mb
ganalytics: 0ms - 0Mb
commissionfactory: 0ms - 0.05Mb
cedrakutenaffiliate: 0ms - 0Mb

displayViewed : 0ms - 0Mb
blockviewed: 0ms - 0Mb

displayNav : 1ms - 0.03Mb
blockuserinfo: 1ms - 0.02Mb
blockcart: 0ms - 0.01Mb

Shopping cart (0)

Sale: 18000+ items at up to 80% off