Prev item Next item
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)
  • Bobdog Plain Orange Sweater (B43ZS905)

By buying this product you can collect up to 5 loyalty points. Your cart will total 5 points that can be converted into a voucher of $2.50.


Bobdog Plain Orange Sweater (B43ZS905)

$55.90
$190.90
-71%
A long-standing #plain #orange sweater is always an essential component in your wardrobe for daily mix-and-match and to create a smart and modish appearance.
Read more
Measurement
Composition
Color option:
Size guide
Wash Care  |  

Free Shipping Worldwide
  • Add to Wishlist
Share:

Recently viewed

Configuration Information
  • Controller | ProductController
  • 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.407s
  • config: 0ms
  • Controller::init(): 24ms
  • Controller::setMedia(): 1ms
  • Controller::postProcess(): 3ms
  • Controller::initHeader(): 0ms
  • Controller::initContent(): 770ms
  • Controller::initFooter(): 10ms
  • Controller::display(): 598ms
Memory peak usage
  • Total : 24.7 Mb
  • config: 0.01 Mb
  • Controller::init(): 3.03 Mb
  • Controller::setMedia(): 0.07 Mb
  • Controller::postProcess(): 0.24 Mb
  • Controller::initHeader(): 0.01 Mb
  • Controller::initContent(): 10.19 Mb
  • Controller::initFooter(): 0.74 Mb
  • Controller::display(): 3.6 Mb
Size of included files (288 files)
  • Total : 5.23Mb
Globals variables
  • Globals (> 1 Ko only) : 5375 Ko
  • context : ≈ 4808 Ko
  • _MODULES : ≈ 335.8 Ko
  • _LANG : ≈ 186.4 Ko
  • cookie : ≈ 152.2 Ko
  • customer : ≈ 45.3 Ko
  • NQ_ID : ≈ 31.4 Ko
  • cart : ≈ 30.7 Ko
  • container : ≈ 29.8 Ko
  • defaultCountry : ≈ 24.3 Ko
  • default_country : ≈ 23.4 Ko
  • FBPSC_MONTH : ≈ 21.5 Ko
  • currency : ≈ 19.2 Ko
  • language : ≈ 16.9 Ko
  • FBPSC_REF_LANG : ≈ 9.4 Ko
  • FBPSC_CONNECTORS : ≈ 9.1 Ko
  • _SERVER : ≈ 7.8 Ko
  • FBPSC_ZONE : ≈ 7.5 Ko
  • FBPSC_HOOKS : ≈ 5.9 Ko
  • FBPSC_CONFIGURATION : ≈ 1.9 Ko
  • FBPSC_JS_MSG : ≈ 1.7 Ko
  • link : ≈ 1.1 Ko
SQL Queries : 2209 queries  |  Time spent querying : 352ms
Stopwatch (with SQL_NO_CACHE)

15.121 ms SELECT DISTINCT od.product_id FROM ps_orders o LEFT JOIN ps_order_detail od ON(od.`id_order` = o.`id_order`) LEFT JOIN ps_product p ON(od.`product_id` = p.`id_product`) LEFT JOIN ps_category_product cp ON(p.`id_product` = cp.`id_product`) LEFT JOIN ps_category ca ON (cp.`id_category` = ca.`id_category`) WHERE od.`product_id` <> ? AND ca.`nleft` > ? AND ca.`nright` < ? AND p.active = true ORDER BY o.date_add DESC LIMIT ?
  • in /data/wwwroot/www.0cm.com/modules/blockbestsellers/blockbestsellers.php (line 412)
  • from /modules/blockbestsellers/blockbestsellers.php (line 412)
  • from /modules/blockbestsellers/blockbestsellers.php (line 315)
  • from /modules/blockbestsellers/blockbestsellers.php (line 360)
  • from /modules/blockbestsellers/blockbestsellers.php (line 370)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 226)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

7.914 ms SELECT * FROM `ps_product_supplier` ps LEFT JOIN `ps_product_lang` psl ON psl.id_product = ps.id_product AND psl.id_lang = ? LEFT JOIN `ps_product_shop` product_shop ON product_shop.id_product = ps.id_product AND product_shop.id_shop = ? AND active = ? WHERE ps.product_supplier_reference IN ( SELECT psbis.product_supplier_reference FROM `ps_product_supplier` psbis WHERE psbis.id_product = ? AND psbis.product_supplier_reference != "" AND psbis.id_product_attribute <> ? AND psbis.id_supplier = ps.id_supplier GROUP BY psbis.product_supplier_reference) AND ps.id_product != ? AND ps.id_product_attribute <> ? GROUP BY ps.id_product
  • in /data/wwwroot/www.0cm.com/modules/nq_color_option/nq_color_option.php (line 59)
  • from /modules/nq_color_option/nq_color_option.php (line 59)
  • from /modules/nq_color_option/nq_color_option.php (line 125)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 949)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 949)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

1.304 ms SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, ?) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, ?) id_product_attribute, DATEDIFF( p.`date_add`, DATE_SUB( "?-?-? ?:?:?", INTERVAL ? DAY ) ) > ? AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `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_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = ? AND product_attribute_shop.id_shop=?) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = ? AND pl.id_shop = ? ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = ? AND cl.id_shop = ? ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=? AND image_shop.id_shop=?) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = ?) LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = ? AND stock.id_shop_group = ? AND stock.id_shop = ? ) WHERE `id_product_?` = ? AND product_shop.`active` = ? AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 3406)
  • from /classes/Product.php (line 3406)
  • from /controllers/front/ProductController.php (line 258)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

1.273 ms SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, ?) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`measurement_specific`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type` 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 = ?) LEFT JOIN ps_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, ?) AND stock.id_shop_group = ? AND stock.id_shop = ? ) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = ?) WHERE pa.`id_product` = ? AND al.`id_lang` = ? AND agl.`id_lang` = ? GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
  • in /data/wwwroot/www.0cm.com/override/classes/Product.php (line 1424)
  • from /override/classes/Product.php (line 1424)
  • from /override/controllers/front/ProductController.php (line 165)
  • from /controllers/front/ProductController.php (line 243)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.884 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 /override/controllers/front/ProductController.php (line 103)
  • from /controllers/front/ProductController.php (line 236)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.789 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.668 ms SELECT MAX(image_shop.id_image) id_image, p.id_product, il.legend, product_shop.active, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite 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_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = ? ) LEFT JOIN ps_image i ON (i.id_product = p.id_product) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = ? AND image_shop.cover=?) LEFT JOIN ps_image_lang il ON (il.id_image = image_shop.id_image AND il.id_lang = ?) LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = ? ) WHERE p.id_product IN (?) AND pl.id_lang = ? AND cl.id_lang = ? GROUP BY product_shop.id_product
  • in /data/wwwroot/www.0cm.com/modules/blockviewed/blockviewed.php (line 95)
  • from /modules/blockviewed/blockviewed.php (line 95)
  • from /modules/blockviewed/blockviewed.php (line 221)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1553)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1553)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.618 ms SELECT * FROM `ps_category` a? LEFT JOIN `ps_category_lang` `a?` ON (a?.`id_category` = a?.`id_category`) WHERE (a?.`nleft` > ?) AND (a?.`nright` < ?) AND (a?.`id_lang` = ?) HAVING (a?.`id_category` IN(?, ?))
  • in /data/wwwroot/www.0cm.com/classes/PrestaShopCollection.php (line 356)
  • from /classes/PrestaShopCollection.php (line 356)
  • from /classes/PrestaShopCollection.php (line 450)
  • from /modules/blockbestsellers/blockbestsellers.php (line 385)
  • from /modules/blockbestsellers/blockbestsellers.php (line 394)
  • from /modules/blockbestsellers/blockbestsellers.php (line 315)
  • from /modules/blockbestsellers/blockbestsellers.php (line 360)
  • from /modules/blockbestsellers/blockbestsellers.php (line 370)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 226)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.614 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = ? WHERE (a.`id_product` = ?) 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/blockviewed/blockviewed.php (line 158)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.585 ms SELECT name, value, pf.id_feature, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = ?) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE pf.id_product = ? ORDER BY f.position ASC
  • in /data/wwwroot/www.0cm.com/override/classes/Product.php (line 391)
  • from /override/classes/Product.php (line 391)
  • from /classes/Product.php (line 4149)
  • from /classes/Product.php (line 4200)
  • from /override/classes/Product.php (line 1075)
  • from /modules/nq_navigation/nq_navigation.php (line 337)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.576 ms SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = ?) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = ?) LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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 = ?) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = ?) WHERE pa.`id_product` = ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 5407)
  • from /classes/Product.php (line 5407)
  • from /controllers/front/ProductController.php (line 562)
  • from /controllers/front/ProductController.php (line 246)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.572 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 /override/controllers/front/ProductController.php (line 82)
  • from /controllers/front/ProductController.php (line 236)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.558 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_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`) ) ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
  • in /data/wwwroot/www.0cm.com/classes/SpecificPrice.php (line 299)
  • from /classes/SpecificPrice.php (line 299)
  • from /controllers/front/ProductController.php (line 333)
  • from /controllers/front/ProductController.php (line 238)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.491 ms SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = ?) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = ?) WHERE i.`id_product` = ? ORDER BY `position`
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 2568)
  • from /classes/Product.php (line 2568)
  • from /controllers/front/ProductController.php (line 369)
  • from /controllers/front/ProductController.php (line 241)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.484 ms SELECT cp.id_product, pl.link_rewrite, cp.position, pl.name FROM ps_category_product cp LEFT JOIN ps_product_lang pl ON (cp.id_product = pl.id_product) LEFT JOIN ps_product p ON (cp.id_product = p.id_product) WHERE p.id_category_default = ? AND (cp.position < ? ) AND cp.id_category = ? AND pl.id_lang = ? AND p.active = ? ORDER BY cp.position DESC LIMIT ?
  • in /data/wwwroot/www.0cm.com/override/classes/Product.php (line 1172)
  • from /override/classes/Product.php (line 1172)
  • from /override/controllers/front/ProductController.php (line 9)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.478 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 /classes/Link.php (line 101)
  • from /classes/Link.php (line 557)
  • from /classes/controller/FrontController.php (line 476)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /controllers/front/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.463 ms SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) 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 = ?) LEFT JOIN `ps_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = ?) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 5345)
  • from /classes/Product.php (line 5345)
  • from /controllers/front/ProductController.php (line 562)
  • from /controllers/front/ProductController.php (line 246)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.456 ms SELECT cp.id_product, pl.link_rewrite, cp.position, pl.name FROM ps_category_product cp LEFT JOIN ps_product_lang pl ON (cp.id_product = pl.id_product) LEFT JOIN ps_product p ON (cp.id_product = p.id_product) WHERE p.id_category_default = ? AND (cp.position > ? ) AND cp.id_category = ? AND pl.id_lang = ? AND p.active = ? ORDER BY cp.position ASC LIMIT ?
  • in /data/wwwroot/www.0cm.com/override/classes/Product.php (line 1183)
  • from /override/classes/Product.php (line 1183)
  • from /override/controllers/front/ProductController.php (line 9)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.441 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.424 ms SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (?, ?, ?, ?, ?, ?) AND il.`id_lang` = ? ORDER by i.`position`
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 2075)
  • from /classes/Product.php (line 2075)
  • from /override/controllers/front/ProductController.php (line 168)
  • from /controllers/front/ProductController.php (line 243)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.411 ms SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = ? ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) WHERE pl.id_lang = ? AND pl.id_product = ? AND product_shop.active = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Meta.php (line 250)
  • from /classes/Meta.php (line 250)
  • from /classes/Meta.php (line 199)
  • from /classes/controller/FrontController.php (line 403)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /controllers/front/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.401 ms SELECT p.*, pl.*, il.legend, image_shop.id_image FROM ps_product p LEFT JOIN ps_product_lang pl ON(p.`id_product` = pl.`id_product` AND pl.`id_lang` = ? AND pl.`id_shop` = ?) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=? AND image_shop.id_shop=?) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = ?) WHERE p.`id_product` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/modules/blockbestsellers/blockbestsellers.php (line 426)
  • from /modules/blockbestsellers/blockbestsellers.php (line 426)
  • from /modules/blockbestsellers/blockbestsellers.php (line 315)
  • from /modules/blockbestsellers/blockbestsellers.php (line 360)
  • from /modules/blockbestsellers/blockbestsellers.php (line 370)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 226)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.393 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = ? 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/Product.php (line 477)
  • from /override/classes/Product.php (line 365)
  • from /modules/blockviewed/blockviewed.php (line 158)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.378 ms SELECT COUNT(*) 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 2121)
  • from /classes/Product.php (line 2121)
  • from /modules/nq_color_option/nq_color_option.php (line 41)
  • from /modules/nq_color_option/nq_color_option.php (line 125)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 949)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 949)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.347 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.338 ms SELECT * FROM `ps_image` i LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = ? AND il.`id_lang` = ? ORDER BY i.`position` ASC
  • in /data/wwwroot/www.0cm.com/classes/Image.php (line 181)
  • from /classes/Image.php (line 181)
  • from /modules/nq_color_option/nq_color_option.php (line 130)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 949)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 949)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.332 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = ? LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = ? WHERE (a.`id_cms` = ?) AND (b.`id_shop` = ?) LIMIT ?
  • in /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/Link.php (line 247)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 988)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.327 ms SELECT `id_category` FROM `ps_category_product` WHERE `id_product` = ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 2467)
  • from /classes/Product.php (line 2467)
  • from /override/controllers/front/ProductController.php (line 75)
  • from /controllers/front/ProductController.php (line 236)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.326 ms SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, ?) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, product_shop.`date_add` > "?-?-?" as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,?) id_product_attribute FROM `ps_product` p LEFT JOIN `ps_category_product` `cp` ON cp.`id_product` = p.`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_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = ? AND pl.id_shop = ? LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=? AND image_shop.id_shop=? LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = ? LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = ? AND product_attribute_shop.id_shop=? LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = ? AND stock.id_shop_group = ? AND stock.id_shop = ? ) WHERE (cp.`id_category` = ?) AND (product_shop.`active` = ?) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "?-?-?") GROUP BY product_shop.id_product ORDER BY p.`date_add` DESC LIMIT ?
  • in /data/wwwroot/www.0cm.com/override/classes/Product.php (line 1060)
  • from /override/classes/Product.php (line 1060)
  • from /modules/nq_navigation/nq_navigation.php (line 337)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.324 ms UPDATE `ps_smarty_lazy_cache` SET filepath='socialsharing_header/?/?/?/?/?/?/?/c?/?a/?f/c?a?f?dd?f?e?c?a?c?b?db?a.socialsharing_header.tpl.php' WHERE `template_hash`='b?b?d?f?fb?ffcd?ca?a?' AND cache_id="socialsharing_header|?|?|?|?|?|?|?" AND compile_id=""
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 193)
  • from /classes/SmartyCustom.php (line 193)
  • from /classes/SmartyCustom.php (line 324)
  • from /classes/module/Module.php (line 2248)
  • from /modules/socialsharing/socialsharing.php (line 179)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.322 ms UPDATE `ps_smarty_lazy_cache` SET filepath='socialsharing/?/?/?/?/?/?/?/bf/d?/c?/bfd?c?d?be?a?c?e?e?fbdabd?c?cddefd.socialsharing.tpl.php' WHERE `template_hash`='?f?e?a?b?fad?d?d' AND cache_id="socialsharing|?|?|?|?|?|?|?" AND compile_id=""
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 193)
  • from /classes/SmartyCustom.php (line 193)
  • from /classes/SmartyCustom.php (line 324)
  • from /classes/module/Module.php (line 2248)
  • from /modules/socialsharing/socialsharing.php (line 211)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1262)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1262)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.319 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/socialsharing/socialsharing.php (line 173)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.318 ms SELECT pa.`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` = ? ORDER BY product_attribute_shop.`price` DESC LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 3018)
  • from /classes/Product.php (line 3018)
  • from /modules/loyalty/loyalty.php (line 286)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 278)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.317 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='?c?e?cf?afb?c' AND cache_id="blocksearch-top|?|?|?|?|?|?" 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/blocksearch/blocksearch.php (line 110)
  • from /modules/blocksearch/blocksearch.php (line 130)
  • 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/a0/41/3f/a0413f5e2e4afac3e97b8c2ebec9c7dbda931655.file.header.tpl.php (line 251)
  • from /cache/smarty/compile/a0/41/3f/a0413f5e2e4afac3e97b8c2ebec9c7dbda931655.file.header.tpl.php (line 251)
  • 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.308 ms SELECT id_shop FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/ObjectModel.php (line 1388)
  • from /classes/ObjectModel.php (line 1388)
  • from /controllers/front/ProductController.php (line 101)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.305 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.301 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.289 ms SELECT ctg.`id_group` FROM `ps_category_product` cp INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`) WHERE cp.`id_product` = ? AND ctg.`id_group` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 4649)
  • from /classes/Product.php (line 4649)
  • from /classes/Product.php (line 4633)
  • from /controllers/front/ProductController.php (line 136)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.285 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.276 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 433)
  • from /modules/nq_navigation/nq_navigation.php (line 433)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.271 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.269 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.264 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.264 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.263 ms SELECT * FROM `ps_image` a LEFT JOIN `ps_image_shop` `c` ON a.`id_image` = c.`id_image` AND c.`id_shop` = ? WHERE (a.`id_image` = ?) 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/Image.php (line 80)
  • from /override/controllers/front/ProductController.php (line 21)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.262 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.262 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.257 ms SELECT `id_product` FROM `ps_product_lang` WHERE `link_rewrite` = 'bobdog-plain-orange-sweater-b?zs?' AND `id_lang` = ? AND `id_shop` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/override/classes/Dispatcher.php (line 369)
  • from /override/classes/Dispatcher.php (line 369)
  • from /override/classes/Dispatcher.php (line 272)
  • from /classes/Dispatcher.php (line 261)
  • from /index.php (line 28)

0.253 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 /modules/blockbestsellers/blockbestsellers.php (line 384)
  • from /modules/blockbestsellers/blockbestsellers.php (line 394)
  • from /modules/blockbestsellers/blockbestsellers.php (line 315)
  • from /modules/blockbestsellers/blockbestsellers.php (line 360)
  • from /modules/blockbestsellers/blockbestsellers.php (line 370)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 226)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.246 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 /modules/blockbestsellers/blockbestsellers.php (line 384)
  • from /modules/blockbestsellers/blockbestsellers.php (line 394)
  • from /modules/blockbestsellers/blockbestsellers.php (line 315)
  • from /modules/blockbestsellers/blockbestsellers.php (line 360)
  • from /modules/blockbestsellers/blockbestsellers.php (line 370)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 226)
  • from /config/smarty.config.inc.php (line 204)
  • from (line undefined)
  • from /config/smarty.config.inc.php (line 264)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1549)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.246 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='?f?e?a?b?fad?d?d' AND cache_id="socialsharing|?|?|?|?|?|?|?" 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/socialsharing/socialsharing.php (line 200)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1262)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1262)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.242 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 /classes/Link.php (line 101)
  • from /classes/Link.php (line 557)
  • from /classes/controller/FrontController.php (line 476)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /controllers/front/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.24 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.24 ms SELECT a.id_product_? AS "id_product" FROM `ps_accessory` a WHERE a.id_product_? = ?
  • in /data/wwwroot/www.0cm.com/modules/nq_color_option/nq_color_option.php (line 71)
  • from /modules/nq_color_option/nq_color_option.php (line 71)
  • from /modules/nq_color_option/nq_color_option.php (line 115)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 949)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 949)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.226 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='b?b?d?f?fb?ffcd?ca?a?' AND cache_id="socialsharing_header|?|?|?|?|?|?|?" 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/socialsharing/socialsharing.php (line 166)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.219 ms SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = ?
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 2059)
  • from /classes/Product.php (line 2059)
  • from /override/controllers/front/ProductController.php (line 168)
  • from /controllers/front/ProductController.php (line 243)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.215 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.215 ms SELECT a.id_parent_entry FROM ps_navigation_tab a WHERE a.id_category = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/modules/nq_navigation/nq_navigation.php (line 436)
  • from /modules/nq_navigation/nq_navigation.php (line 436)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.211 ms SELECT position FROM ps_category_product WHERE id_product = ? AND id_category = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/override/classes/Product.php (line 1159)
  • from /override/classes/Product.php (line 1159)
  • from /override/controllers/front/ProductController.php (line 9)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.207 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.207 ms SELECT * FROM `ps_image_lang` WHERE `id_image` = ?
  • 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/Image.php (line 80)
  • from /override/controllers/front/ProductController.php (line 21)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.183 ms INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('?f?e?a?b?fad?d?d',"socialsharing|?|?|?|?|?|?|?","","?-?-? ?:?:?")
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 273)
  • from /classes/SmartyCustom.php (line 273)
  • from /classes/SmartyCustom.php (line 166)
  • from /classes/SmartyCustom.php (line 126)
  • from /classes/module/Module.php (line 2274)
  • from /classes/module/Module.php (line 2320)
  • from /modules/socialsharing/socialsharing.php (line 200)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1262)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1262)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.183 ms INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('b?b?d?f?fb?ffcd?ca?a?',"socialsharing_header|?|?|?|?|?|?|?","","?-?-? ?:?:?")
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 273)
  • from /classes/SmartyCustom.php (line 273)
  • from /classes/SmartyCustom.php (line 166)
  • from /classes/SmartyCustom.php (line 126)
  • from /classes/module/Module.php (line 2274)
  • from /classes/module/Module.php (line 2320)
  • from /modules/socialsharing/socialsharing.php (line 166)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.182 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.176 ms SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Category.php (line 1400)
  • from /classes/Category.php (line 1400)
  • from /classes/Product.php (line 5578)
  • from /classes/Link.php (line 137)
  • from /classes/Link.php (line 557)
  • from /classes/controller/FrontController.php (line 476)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /controllers/front/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.173 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.173 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.171 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.171 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.162 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.158 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.149 ms SELECT id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE `id_product` IN (?,?,?,?,?,?,?,?) ORDER BY f.position ASC
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 3535)
  • from /classes/Product.php (line 3535)
  • from /override/classes/Product.php (line 1074)
  • from /modules/nq_navigation/nq_navigation.php (line 337)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.148 ms SELECT id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE `id_product` IN (?,?,?,?,?,?,?,?,?,?) ORDER BY f.position ASC
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 3535)
  • from /classes/Product.php (line 3535)
  • from /override/classes/Product.php (line 1074)
  • from /modules/nq_navigation/nq_navigation.php (line 337)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.145 ms SELECT id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE `id_product` IN (?,?,?,?) ORDER BY f.position ASC
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 3535)
  • from /classes/Product.php (line 3535)
  • from /override/classes/Product.php (line 1074)
  • from /modules/nq_navigation/nq_navigation.php (line 337)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.142 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.141 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.14 ms SELECT id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE `id_product` IN (?,?) ORDER BY f.position ASC
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 3535)
  • from /classes/Product.php (line 3535)
  • from /override/classes/Product.php (line 1074)
  • from /modules/nq_navigation/nq_navigation.php (line 337)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.138 ms SELECT id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE `id_product` IN (?) ORDER BY f.position ASC
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 3535)
  • from /classes/Product.php (line 3535)
  • from /override/classes/Product.php (line 1074)
  • from /modules/nq_navigation/nq_navigation.php (line 337)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

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

0.132 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.131 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.13 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.129 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 /modules/nq_navigation/nq_navigation.php (line 317)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.128 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/ProductController.php (line 167)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.128 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.127 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/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.127 ms SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`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 `id_lang` = ? AND c.`id_parent` = ? AND `active` = ? GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
  • in /data/wwwroot/www.0cm.com/classes/Category.php (line 825)
  • from /classes/Category.php (line 825)
  • from /classes/Category.php (line 776)
  • from /override/controllers/front/ProductController.php (line 113)
  • from /controllers/front/ProductController.php (line 236)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.124 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.124 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.123 ms SELECT DISTINCT c.* FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = ?) WHERE `level_depth` = ?
  • in /data/wwwroot/www.0cm.com/classes/Category.php (line 1587)
  • from /classes/Category.php (line 1587)
  • from /classes/Category.php (line 1138)
  • from /override/classes/Link.php (line 89)
  • from /modules/nq_navigation/classes/NavigationTab.php (line 220)
  • from /modules/nq_navigation/nq_navigation.php (line 120)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.122 ms SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = ? WHERE (a.`id_country` = ?) LIMIT ?
  • in /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/controller/FrontController.php (line 894)
  • from /classes/controller/FrontController.php (line 261)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /controllers/front/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.12 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 233)
  • 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.119 ms SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = ? AND s.active = ? AND s.deleted = ? AND su.main = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/shop/Shop.php (line 202)
  • from /classes/shop/Shop.php (line 202)
  • from /classes/shop/Shop.php (line 133)
  • from /classes/shop/Shop.php (line 393)
  • from /config/config.inc.php (line 105)
  • from /index.php (line 27)

0.118 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blockcategories" 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 /controllers/front/ProductController.php (line 168)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.118 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.118 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.118 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.117 ms SELECT * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = ? AND cl.id_shop = ? WHERE (c.nleft <= ? AND c.nright >= ?) ORDER BY c.nleft
  • in /data/wwwroot/www.0cm.com/classes/Product.php (line 5585)
  • from /classes/Product.php (line 5585)
  • from /classes/Link.php (line 137)
  • from /classes/Link.php (line 557)
  • from /classes/controller/FrontController.php (line 476)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /controllers/front/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.117 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.117 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 = "product" 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.117 ms SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) WHERE pa.`id_product_attribute` = ? LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Combination.php (line 331)
  • from /classes/Combination.php (line 331)
  • from /classes/Product.php (line 1101)
  • from /classes/Product.php (line 4065)
  • from /classes/Product.php (line 4200)
  • from /override/classes/Product.php (line 1075)
  • from /modules/nq_navigation/nq_navigation.php (line 337)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.116 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.115 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/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.115 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.113 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/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.113 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.112 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.112 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.112 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blocklayered" 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 /classes/Product.php (line 5332)
  • from /controllers/front/ProductController.php (line 562)
  • from /controllers/front/ProductController.php (line 246)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.109 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/socialsharing/socialsharing.php (line 166)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.109 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.107 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/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.106 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.105 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.104 ms SELECT id_page_type FROM ps_page_type WHERE name = 'product' 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.104 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.104 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.103 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.103 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.103 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.102 ms SELECT * FROM `ps_country_lang` WHERE `id_country` = ?
  • 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/controller/FrontController.php (line 894)
  • from /classes/controller/FrontController.php (line 261)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /controllers/front/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.101 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 /controllers/front/ProductController.php (line 401)
  • from /controllers/front/ProductController.php (line 241)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.1 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium' LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/Image.php (line 441)
  • from /classes/Image.php (line 441)
  • from /modules/blockviewed/blockviewed.php (line 134)
  • from /modules/blockviewed/blockviewed.php (line 221)
  • 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/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1553)
  • from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1553)
  • from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
  • from /classes/SmartyCustom.php (line 115)
  • from /classes/controller/FrontController.php (line 712)
  • from /override/classes/controller/Controller.php (line 73)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.1 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/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.099 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • 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 /controllers/front/ProductController.php (line 84)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.099 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 238)
  • 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.098 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.098 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.098 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.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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

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

0.095 ms SELECT UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT ?
  • in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 99)
  • from /classes/SmartyCustom.php (line 99)
  • from /classes/SmartyCustom.php (line 123)
  • from /classes/module/Module.php (line 2274)
  • from /classes/module/Module.php (line 2320)
  • from /modules/socialsharing/socialsharing.php (line 166)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.094 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/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.094 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/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.093 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.093 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.093 ms SELECT * FROM `ps_group_lang` WHERE `id_group` = ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 70)
  • from /Adapter/Adapter_EntityMapper.php (line 70)
  • from /classes/ObjectModel.php (line 232)
  • from /classes/Group.php (line 75)
  • from /classes/Group.php (line 327)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 356)
  • from /override/classes/controller/FrontController.php (line 53)
  • from /controllers/front/ProductController.php (line 81)
  • from /override/controllers/front/ProductController.php (line 153)
  • from /override/classes/controller/Controller.php (line 23)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.093 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/socialsharing/socialsharing.php (line 166)
  • 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/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.092 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.092 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.092 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.09 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.089 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.088 ms SELECT * FROM `ps_navigation_tab_lang` WHERE `id_navigation_tab` = ?
  • in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 70)
  • from /Adapter/Adapter_EntityMapper.php (line 70)
  • from /classes/ObjectModel.php (line 232)
  • from /modules/nq_navigation/nq_navigation.php (line 384)
  • from /modules/nq_navigation/nq_navigation.php (line 121)
  • from /classes/Hook.php (line 569)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 112)
  • from /controllers/front/ProductController.php (line 180)
  • from /override/controllers/front/ProductController.php (line 6)
  • from /override/classes/controller/Controller.php (line 50)
  • from /classes/Dispatcher.php (line 373)
  • from /index.php (line 28)

0.088 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)
Doubles (IDs replaced by "?")

758 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 ?
140 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 ?
120 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
111 SELECT pc.* FROM `ps_pcharming` pc WHERE pc.`id_currency` = ? LIMIT ?
88 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
66 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 ?
66 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 ?
60 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC LIMIT ?
60 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` = ?)
60 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? LIMIT ?
60 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = ? AND `id_group` = ? LIMIT ?
53 SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
53 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`=?
53 SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?
53 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 ) ) > ?
40 SELECT name, value, pf.id_feature, fvl.id_feature_value FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = ?) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE pf.id_product = ? ORDER BY f.position ASC
39 SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) WHERE pa.`id_product_attribute` = ? LIMIT ?
23 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 ?
21 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 ?
21 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 ?
17 SELECT l.*, ll.*, tbl.custom_name, b.template, b.name as block_name, cl.name as category_name, cl.description as description, pl.name as product_name FROM ps_navigation_tab_link l LEFT JOIN ps_navigation_block b ON b.id_navigation_block = l.id_navigation_block LEFT JOIN ps_navigation_tab_link_lang ll ON ll.id_navigation_tab_link = l.id_navigation_tab_link AND ll.id_lang = ? LEFT JOIN ps_navigation_tab_block tb ON tb.id_navigation_block = b.id_navigation_block AND tb.id_navigation_tab = l.id_navigation_tab LEFT JOIN ps_navigation_tab_block_lang tbl ON tbl.id_navigation_tab_block = tb.id_navigation_tab_block and tbl.id_lang = ? LEFT JOIN ps_category_lang cl ON cl.id_category = l.id_category AND cl.id_lang = ? AND cl.id_shop = ? LEFT JOIN ps_product_lang pl ON pl.id_product = l.id_product AND pl.id_lang = ? AND pl.id_shop = ? WHERE l.id_navigation_tab = ? AND l.active = ? ORDER BY ordre, position
17 SELECT * FROM `ps_navigation_tab_lang` WHERE `id_navigation_tab` = ?
17 SELECT * FROM `ps_navigation_tab` a WHERE (a.`id_navigation_tab` = ?) LIMIT ?
16 SELECT p.*, pl.*, il.legend, image_shop.id_image FROM ps_product p LEFT JOIN ps_product_lang pl ON(p.`id_product` = pl.`id_product` AND pl.`id_lang` = ? AND pl.`id_shop` = ?) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=? AND image_shop.id_shop=?) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = ?) WHERE p.`id_product` = ? LIMIT ?
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 = ?
10 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = ? LIMIT ?
9 SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, ?) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, product_shop.`date_add` > "?-?-?" as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,?) id_product_attribute FROM `ps_product` p LEFT JOIN `ps_category_product` `cp` ON cp.`id_product` = p.`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_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = ? AND pl.id_shop = ? LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=? AND image_shop.id_shop=? LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = ? LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = ? AND product_attribute_shop.id_shop=? LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = ? AND stock.id_shop_group = ? AND stock.id_shop = ? ) WHERE (cp.`id_category` = ?) AND (product_shop.`active` = ?) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "?-?-?") GROUP BY product_shop.id_product ORDER BY p.`date_add` DESC LIMIT ?
9 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = ? AND cl.id_shop = ? AND cl.`id_category` = ? LIMIT ?
7 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 ?
5 SELECT * FROM `ps_image` i LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = ? AND il.`id_lang` = ? ORDER BY i.`position` ASC
4 SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = ? LIMIT ?
4 SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = ? AND `active` = ? LIMIT ?
4 SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = ? AND `id_shop` = ? 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 * FROM `ps_category` a? LEFT JOIN `ps_category_lang` `a?` ON (a?.`id_category` = a?.`id_category`) WHERE (a?.`nleft` > ?) AND (a?.`nright` < ?) AND (a?.`id_lang` = ?) HAVING (a?.`id_category` IN(?, ?))
3 SELECT * FROM `ps_category_lang` WHERE `id_category` = ? AND `id_shop` = ?
3 SELECT id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE `id_product` IN (?) ORDER BY f.position ASC
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
2 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('b?b?d?f?fb?ffcd?ca?a?',"socialsharing_header|?|?|?|?|?|?|?","","?-?-? ?:?:?")
2 SELECT * FROM `ps_image` a LEFT JOIN `ps_image_shop` `c` ON a.`id_image` = c.`id_image` AND c.`id_shop` = ? WHERE (a.`id_image` = ?) LIMIT ?
2 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('?f?e?a?b?fad?d?d',"socialsharing|?|?|?|?|?|?|?","","?-?-? ?:?:?")
2 SELECT id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE `id_product` IN (?,?,?,?,?,?,?,?,?,?) ORDER BY f.position ASC
2 SELECT `id_product` FROM `ps_product_lang` WHERE `link_rewrite` = 'bobdog-plain-orange-sweater-b?zs?' AND `id_lang` = ? AND `id_shop` = ? LIMIT ?
2 SELECT id_product, name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE `id_product` IN (?,?) ORDER BY f.position ASC
2 SELECT * FROM `ps_image_lang` WHERE `id_image` = ?
Tables stress

1056 category_lang
1039 category
904 category_shop
254 product_shop
211 product
205 stock_available
156 product_attribute_shop
117 product_lang
111 pcharming
87 product_attribute
67 specific_price
60 product_group_reduction_cache
60 specific_price_priority
53 product_tag
53 tag
49 feature_value_lang
49 feature_product
49 feature
49 feature_lang
49 feature_shop
40 manufacturer
37 image_shop
36 image_lang
26 manufacturer_lang
26 manufacturer_shop
20 navigation_tab
18 navigation_tab_lang
18 navigation_tab_link
17 navigation_tab_block
17 navigation_tab_link_lang
17 navigation_block
17 navigation_tab_block_lang
17 image
15 image_type
15 category_product
14 navigation_entry_lang
14 navigation_entry
9 module
7 module_shop
5 shop
4 hook
4 supplier
4 lang_shop
4 shop_url
4 currency_shop
3 theme
3 lang
3 country
3 attribute
3 smarty_lazy_cache
3 product_attribute_combination
3 currency
2 attribute_shop
2 accessory
2 product_supplier
2 attribute_lang
2 attribute_group_lang
2 category_group
2 hook_module
2 hook_alias
2 country_shop
2 smarty_last_flush
2 shop_group
2 configuration
2 meta
2 country_lang
2 group
2 group_shop
1 hook_module_exceptions
1 page
1 page_type
1 cms
1 cms_lang
1 order_detail
1 cms_shop
1 connections
1 orders
1 memcached_servers
1 attribute_group
1 module_group
1 theme_meta
1 group_lang
1 configuration_lang
1 meta_lang
1 layered_indexable_attribute_lang_value
1 product_attribute_image
1 required_field
Hook processing : 1.055s - 13.15Mb
  • moduleRoutes : 6ms - 0.7Mb
  • prestatemplate: 0ms - 0.06Mb
  • displayHeader : 33ms - 3.49Mb
  • blockcart: 1ms - 0.09Mb
  • blocklayered: 0ms - 0.18Mb
  • homeslider: 0ms - 0.09Mb
  • blockuserinfo: 0ms - 0.06Mb
  • blocknewsletter: 1ms - 0.08Mb
  • blockviewed: 2ms - 0.1Mb
  • nq_universe: 0ms - 0.09Mb
  • socialsharing: 6ms - 0.23Mb
  • blockbestsellers: 1ms - 0.06Mb
  • nq_categoryhomepage: 0ms - 0.06Mb
  • nq_navigation: 1ms - 0.27Mb
  • infinitescroll: 1ms - 0.06Mb
  • favoriteproducts: 1ms - 0.09Mb
  • blocksearch: 0ms - 0.06Mb
  • nq_mosaic: 0ms - 0.06Mb
  • nq_morefeature: 0ms - 0.07Mb
  • shoperize: 1ms - 0.26Mb
  • facebookpsconnect: 4ms - 0.24Mb
  • nq_brands: 0ms - 0.14Mb
  • ganalytics: 1ms - 0.08Mb
  • mailalerts: 1ms - 0.14Mb
  • nq_follow_brand: 1ms - 0.11Mb
  • braintreejs: 1ms - 0.19Mb
  • hreflang_on_pages: 2ms - 0.13Mb
  • nq_checkcurrency: 1ms - 0.05Mb
  • doofinder: 5ms - 0.11Mb
  • categoryslider: 0ms - 0.1Mb
  • genderpushes: 0ms - 0.1Mb
  • recaptcha: 0ms - 0.06Mb
  • nq_genderchoice: 0ms - 0.06Mb
  • codegenerator: 0ms - 0.06Mb
  • displayTop : 697ms - 5.43Mb
  • blockuserinfo: 0ms - 0.02Mb
  • nq_navigation: 695ms - 5.44Mb
  • infinitescroll: 0ms - -0.08Mb
  • facebookpsconnect: 1ms - 0.05Mb
  • displayDailySpecialWomen : 10ms - 0.05Mb
  • nq_dailyspecial: 10ms - 0.05Mb
  • displayDailySpecialMen : 11ms - 0.05Mb
  • nq_dailyspecial: 11ms - 0.05Mb
  • displayDailySpecialKids : 11ms - 0.05Mb
  • nq_dailyspecial: 10ms - 0.05Mb
  • displayDailySpecialHome : 10ms - 0.05Mb
  • nq_dailyspecial: 10ms - 0.05Mb
  • displayLeftColumn : 1ms - 0.09Mb
  • blocklayered: 0ms - 0Mb
  • facebookpsconnect: 1ms - 0.09Mb
  • displayRightColumn : 0ms - 0.03Mb
  • facebookpsconnect: 0ms - 0.03Mb
  • displayFooterProduct : 0ms - 0Mb
  • ganalytics: 0ms - 0Mb
  • displayLeftColumnProduct : 1ms - 0.05Mb
  • favoriteproducts: 1ms - 0.05Mb
  • displayRightColumnProduct : 3ms - 0.21Mb
  • loyalty: 3ms - 0.21Mb
  • actionProductOutOfStock : 1ms - 0.08Mb
  • mailalerts: 1ms - 0.08Mb
  • displayProductButtons : 0ms - 0.01Mb
  • favoriteproducts: 0ms - 0.01Mb
  • displayFooter : 10ms - 0.71Mb
  • statsdata: 4ms - 0.38Mb
  • nq_footerlinks: 3ms - 0.12Mb
  • blocknewsletter: 2ms - 0.05Mb
  • happybirthday: 0ms - 0.06Mb
  • facebookpsconnect: 1ms - 0.05Mb
  • ganalytics: 0ms - 0Mb
  • commissionfactory: 0ms - 0.05Mb
  • displayNqColorOption : 22ms - 0.27Mb
  • nq_color_option: 22ms - 0.27Mb
  • displayNqFollowBrand : 1ms - 0.03Mb
  • nq_follow_brand: 1ms - 0.03Mb
  • displaySocialSharing : 4ms - 0.1Mb
  • socialsharing: 4ms - 0.1Mb
  • displayTopSellers : 115ms - 0.78Mb
  • blockbestsellers: 115ms - 0.78Mb
  • displayViewed : 3ms - 0.08Mb
  • blockviewed: 3ms - 0.08Mb
  • displayNav : 1ms - 0.04Mb
  • blockuserinfo: 1ms - 0.03Mb
  • blockcart: 0ms - 0.01Mb
  • displaySearchBar : 1ms - 0.04Mb
  • blocksearch: 1ms - 0.04Mb