Balneaire Colorful Knitted Floral Bikini Coffee Shorts (50156)

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.428s
config: 0ms
Controller::init(): 25ms
Controller::setMedia(): 1ms
Controller::postProcess(): 3ms
Controller::initHeader(): 0ms
Controller::initContent(): 624ms
Controller::initFooter(): 10ms
Controller::display(): 765ms

Memory peak usage

Total : 22.31 Mb
config: 0.01 Mb
Controller::init(): 3.12 Mb
Controller::setMedia(): 0.07 Mb
Controller::postProcess(): 0.25 Mb
Controller::initHeader(): 0.01 Mb
Controller::initContent(): 8.73 Mb
Controller::initFooter(): 0.68 Mb
Controller::display(): 2.27 Mb

Size of included files (322 files)

Total : 5.8Mb

Globals variables

Globals (> 1 Ko only) : 9947 Ko
context : ≈ 4545 Ko
smarty : ≈ 4318.1 Ko
_MODULES : ≈ 339.8 Ko
_LANG : ≈ 186.7 Ko
cookie : ≈ 152.3 Ko
customer : ≈ 45.4 Ko
container : ≈ 33.6 Ko
NQ_ID : ≈ 32.9 Ko
cart : ≈ 32.1 Ko
FPS_MONTH : ≈ 26.8 Ko
defaultCountry : ≈ 23.7 Ko
default_country : ≈ 23.5 Ko
FPS_CONFIGURATION : ≈ 23.3 Ko
FPS_CONFIG_CSS : ≈ 23.1 Ko
FBPSC_MONTH : ≈ 21.5 Ko
FPS_CSS_DEFAULT : ≈ 20.5 Ko
currency : ≈ 19.8 Ko
language : ≈ 16.9 Ko
FBPSC_REF_LANG : ≈ 9.4 Ko
FBPSC_CONNECTORS : ≈ 9.3 Ko
_SERVER : ≈ 8.4 Ko
FBPSC_ZONE : ≈ 7.5 Ko
FBPSC_HOOKS : ≈ 5.9 Ko
FPS_HOOKS : ≈ 5.7 Ko
FPS_TEXT_SIZE : ≈ 3.8 Ko
FBPSC_CONFIGURATION : ≈ 1.9 Ko
FPS_BORDER_SIZE : ≈ 1.8 Ko
FBPSC_JS_MSG : ≈ 1.7 Ko
link : ≈ 1.1 Ko
FPS_REVIEWS_LABEL_DEFAULT_TRANSLATE : ≈ 1.1 Ko

SQL Queries : 1905 queries | Time spent querying : 292ms

Stopwatch (with SQL_NO_CACHE)

17.939 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 1572)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1572)
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)

4.407 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 965)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 965)
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)

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

1.647 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 1572)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1572)
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.415 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)

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

1.204 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.125 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.585 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 1576)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1576)
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.515 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` = ? AND a.`id_attribute` NOT IN(?)

in /data/wwwroot/www.0cm.com/classes/Product.php (line 5389)
from /classes/Product.php (line 5389)
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.512 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.507 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.505 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.488 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.423 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.416 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.382 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 4234)
from /controllers/front/ProductController.php (line 273)
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.375 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.358 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.355 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.354 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.345 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.315 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.296 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.286 ms SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = ?) WHERE i.`id_product` = ? AND image_shop.`cover` = ? LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Product.php (line 2588)
from /classes/Product.php (line 2588)
from /modules/nq_dailyspecial/nq_dailyspecial.php (line 115)
from /modules/nq_dailyspecial/nq_dailyspecial.php (line 134)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 243)
from /config/smarty.config.inc.php (line 204)
from (line undefined)
from /config/smarty.config.inc.php (line 264)
from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
from /cache/smarty/compile/b4/fa/4b/b4fa4bea6261c001c6c10874516caba0ec56a651.file.nq_navigation.tpl.php (line 219)
from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
from /classes/SmartyCustom.php (line 329)
from /classes/module/Module.php (line 2248)
from /modules/nq_navigation/nq_navigation.php (line 360)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 243)
from /classes/controller/FrontController.php (line 580)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/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.282 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.28 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.277 ms SELECT `id_product` FROM `ps_product_lang` WHERE `link_rewrite` = 'balneaire-colorful-knitted-floral-bikini-coffee-top-and-shorts-?' 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.276 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.272 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.27 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 1285)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1285)
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.265 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='a?e?e?af?c?f?d?d?b?a?' AND cache_id="homecategory|?|?|?|?|?|?" AND compile_id="" LIMIT ?

in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 225)
from /classes/SmartyCustom.php (line 225)
from /classes/SmartyCustom.php (line 163)
from /classes/SmartyCustom.php (line 126)
from /classes/module/Module.php (line 2274)
from /classes/module/Module.php (line 2320)
from /modules/homecategory/homecategory.php (line 728)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 243)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/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.263 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 965)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 965)
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.26 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 1572)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1572)
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.25 ms SELECT g.`id_attribute_group`, g.`url_name` as `group` FROM `ps_layered_indexable_attribute_group_lang_value` g LEFT JOIN `ps_attribute` a ON (a.`id_attribute_group` = g.`id_attribute_group`) WHERE a.`id_attribute` = ? AND g.`id_lang` = ? AND g.`url_name` IS NOT NULL AND g.`url_name` != ''

in /data/wwwroot/www.0cm.com/classes/Product.php (line 5361)
from /classes/Product.php (line 5361)
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.248 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.238 ms SELECT `id_country` FROM `ps_country` WHERE `iso_code` = 'US' AND active = ? LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Country.php (line 170)
from /classes/Country.php (line 170)
from /classes/Tools.php (line 555)
from /controllers/front/ProductController.php (line 309)
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.229 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.224 ms SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='?f?e?fb?cc?f?ace?f?adcfc?' AND cache_id="homecategory|?|?|?|?|?|?" AND compile_id="" LIMIT ?

in /data/wwwroot/www.0cm.com/classes/SmartyCustom.php (line 225)
from /classes/SmartyCustom.php (line 225)
from /classes/SmartyCustom.php (line 163)
from /classes/SmartyCustom.php (line 126)
from /classes/module/Module.php (line 2274)
from /classes/module/Module.php (line 2248)
from /modules/homecategory/homecategory.php (line 732)
from /classes/Hook.php (line 569)
from /override/classes/Hook.php (line 243)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/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.222 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.22 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.218 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 965)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 965)
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.215 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.209 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.208 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.204 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.201 ms SELECT m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = ? ) ORDER BY LENGTH(ml.url_rewrite) DESC

in /data/wwwroot/www.0cm.com/classes/Dispatcher.php (line 454)
from /classes/Dispatcher.php (line 454)
from /override/classes/Dispatcher.php (line 106)
from /classes/Dispatcher.php (line 230)
from /classes/Dispatcher.php (line 193)
from /index.php (line 28)

0.199 ms SELECT `id_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.191 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.188 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.184 ms SELECT `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name

in /data/wwwroot/www.0cm.com/classes/Hook.php (line 131)
from /classes/Hook.php (line 131)
from /override/classes/Hook.php (line 50)
from /classes/Dispatcher.php (line 413)
from /override/classes/Dispatcher.php (line 106)
from /classes/Dispatcher.php (line 230)
from /classes/Dispatcher.php (line 193)
from /index.php (line 28)

0.181 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 1572)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1572)
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.167 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.165 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.163 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.162 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.148 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.143 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.142 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.139 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.138 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.137 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.133 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.131 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.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.127 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.127 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.126 ms SELECT * FROM `ps_hook_alias`

in /data/wwwroot/www.0cm.com/classes/Hook.php (line 188)
from /classes/Hook.php (line 188)
from /classes/Hook.php (line 208)
from /classes/Hook.php (line 380)
from /override/classes/Hook.php (line 46)
from /classes/Dispatcher.php (line 413)
from /override/classes/Dispatcher.php (line 106)
from /classes/Dispatcher.php (line 230)
from /classes/Dispatcher.php (line 193)
from /index.php (line 28)

0.126 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 1572)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1572)
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.121 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.121 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.121 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.12 ms SELECT * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = ?) LIMIT ?

in /data/wwwroot/www.0cm.com/Adapter/Adapter_EntityMapper.php (line 62)
from /Adapter/Adapter_EntityMapper.php (line 62)
from /classes/ObjectModel.php (line 232)
from /classes/shop/Shop.php (line 515)
from /config/config.inc.php (line 157)
from /index.php (line 27)

0.119 ms SELECT * 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.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 * 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 /controllers/front/ProductController.php (line 271)
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 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.116 ms SELECT * FROM `ps_image_type`

in /data/wwwroot/www.0cm.com/classes/ImageType.php (line 142)
from /classes/ImageType.php (line 142)
from /classes/ImageType.php (line 169)
from /modules/facebookpsshoptab/conf/common.conf.php (line 209)
from /modules/facebookpsshoptab/facebookpsshoptab.php (line 128)
from (line undefined)
from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
from /Adapter/Adapter_ServiceLocator.php (line 52)
from /classes/module/Module.php (line 1125)
from /classes/module/Module.php (line 1089)
from /override/classes/Hook.php (line 156)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/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.115 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.115 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.114 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.114 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.113 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blockwishlist" LIMIT ?

in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2500)
from /classes/module/Module.php (line 2500)
from /classes/module/Module.php (line 2163)
from /cache/smarty/compile/a0/41/3f/a0413f5e2e4afac3e97b8c2ebec9c7dbda931655.file.header.tpl.php (line 318)
from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
from /classes/SmartyCustom.php (line 329)
from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
from /cache/smarty/compile/be/e2/b8/bee2b880b5e4484143180b13fb84bd0f788ef655.file.layout.tpl.php (line 38)
from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
from /classes/SmartyCustom.php (line 115)
from /classes/controller/Controller.php (line 505)
from /classes/controller/FrontController.php (line 722)
from /override/classes/controller/Controller.php (line 73)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.113 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.112 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.112 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.112 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.112 ms SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = ?) WHERE l.`active` = ? LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Language.php (line 841)
from /classes/Language.php (line 841)
from /classes/Language.php (line 938)
from /classes/Dispatcher.php (line 397)
from /classes/Dispatcher.php (line 221)
from /classes/Dispatcher.php (line 193)
from /index.php (line 28)

0.111 ms SELECT * 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.105 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.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.103 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.102 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.102 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.102 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.102 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.101 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = ? AND `active` = ? LIMIT ?

in /data/wwwroot/www.0cm.com/classes/Manufacturer.php (line 241)
from /classes/Manufacturer.php (line 241)
from /classes/Product.php (line 485)
from /override/classes/Product.php (line 365)
from /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.101 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.1 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.1 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.1 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.099 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.099 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'carousel?x' LIMIT ?

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

0.098 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.098 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.098 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.098 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.097 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.097 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.097 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.097 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.097 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.097 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.096 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.096 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.096 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.096 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.095 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.095 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.094 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.094 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.094 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 1576)
from /cache/smarty/compile/9a/2a/5f/9a2a5f7954e25807079eec2477e45bc0653b832d.file.product.tpl.php (line 1576)
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.093 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "favoriteproducts" LIMIT ?

in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2500)
from /classes/module/Module.php (line 2500)
from /classes/module/Module.php (line 2163)
from /cache/smarty/compile/a0/41/3f/a0413f5e2e4afac3e97b8c2ebec9c7dbda931655.file.header.tpl.php (line 325)
from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
from /classes/SmartyCustom.php (line 329)
from /tools/smarty/sysplugins/smarty_internal_template.php (line 303)
from /cache/smarty/compile/be/e2/b8/bee2b880b5e4484143180b13fb84bd0f788ef655.file.layout.tpl.php (line 38)
from /tools/smarty/sysplugins/smarty_internal_templatebase.php (line 188)
from /classes/SmartyCustom.php (line 115)
from /classes/controller/Controller.php (line 505)
from /classes/controller/FrontController.php (line 722)
from /override/classes/controller/Controller.php (line 73)
from /classes/Dispatcher.php (line 373)
from /index.php (line 28)

0.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.092 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "cloudcache" LIMIT ?

in /data/wwwroot/www.0cm.com/classes/module/Module.php (line 2500)
from /classes/module/Module.php (line 2500)
from /classes/module/Module.php (line 2136)
from /modules/facebookpsshoptab/lib/module-tools_class.php (line 933)
from /modules/facebookpsshoptab/facebookpsshoptab.php (line 181)
from (line undefined)
from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
from /Adapter/Adapter_ServiceLocator.php (line 52)
from /classes/module/Module.php (line 1125)
from /classes/module/Module.php (line 1089)
from /override/classes/Hook.php (line 156)
from /classes/controller/FrontController.php (line 579)
from /override/classes/controller/FrontController.php (line 112)
from /controllers/front/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.091 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.091 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.091 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.091 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.089 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.088 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.088 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.087 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.087 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.086 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.084 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.084 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 "?")

842 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 ?

158 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 ?

90 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

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

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 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`=?

42 SELECT pc.* FROM `ps_pcharming` pc WHERE pc.`id_currency` = ? LIMIT ?

37 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 ?

36 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 ?

35 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 ?

35 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? LIMIT ?

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

35 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` = ?)

35 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC LIMIT ?

30 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 ?

22 SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = ? LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = ? WHERE (a.`id_manufacturer` = ?) LIMIT ?

17 SELECT * FROM `ps_navigation_tab_lang` WHERE `id_navigation_tab` = ?

17 SELECT l.*, ll.*, tbl.custom_name, b.template, b.name as block_name, cl.name as category_name, cl.description as description, pl.name as product_name FROM ps_navigation_tab_link l LEFT JOIN ps_navigation_block b ON b.id_navigation_block = l.id_navigation_block LEFT JOIN ps_navigation_tab_link_lang ll ON ll.id_navigation_tab_link = l.id_navigation_tab_link AND ll.id_lang = ? LEFT JOIN ps_navigation_tab_block tb ON tb.id_navigation_block = b.id_navigation_block AND tb.id_navigation_tab = l.id_navigation_tab LEFT JOIN ps_navigation_tab_block_lang tbl ON tbl.id_navigation_tab_block = tb.id_navigation_tab_block and tbl.id_lang = ? LEFT JOIN ps_category_lang cl ON cl.id_category = l.id_category AND cl.id_lang = ? AND cl.id_shop = ? LEFT JOIN ps_product_lang pl ON pl.id_product = l.id_product AND pl.id_lang = ? AND pl.id_shop = ? WHERE l.id_navigation_tab = ? AND l.active = ? ORDER BY ordre, position

17 SELECT * FROM `ps_navigation_tab` a WHERE (a.`id_navigation_tab` = ?) LIMIT ?

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 = ?

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

12 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop_group = ?) AND (id_shop = ?) LIMIT ?

4 SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = ? AND `id_shop` = ? LIMIT ?

4 SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = ? AND `active` = ? LIMIT ?

3 SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = ?) INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = ?) WHERE m.`active` = ? ORDER BY m.`name` ASC

3 SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = ? LIMIT ?

2 SELECT * FROM `ps_image_lang` WHERE `id_image` = ?

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 SELECT `id_product` FROM `ps_product_lang` WHERE `link_rewrite` = 'balneaire-colorful-knitted-floral-bikini-coffee-top-and-shorts-?' AND `id_lang` = ? AND `id_shop` = ? LIMIT ?

Tables stress

1127 category_lang

1110 category

1004 category_shop

166 product_shop

162 product

113 stock_available

111 product_attribute_shop

93 product_lang

76 product_attribute

53 product_tag

53 tag

42 pcharming

42 image_shop

37 specific_price

36 image_lang

35 specific_price_priority

35 product_group_reduction_cache

30 manufacturer

25 manufacturer_shop

25 manufacturer_lang

20 navigation_tab

18 navigation_tab_lang

18 navigation_tab_link

17 navigation_tab_block

17 navigation_tab_block_lang

17 navigation_tab_link_lang

17 navigation_block

16 image_type

14 navigation_entry_lang

14 navigation_entry

12 image

10 module

7 module_shop

6 category_product

5 shop

4 smarty_lazy_cache

4 attribute

4 shop_url

4 currency_shop

4 lang_shop

4 hook

3 lang

3 supplier

3 theme

3 product_attribute_combination

3 currency

3 country

2 accessory

2 product_supplier

2 attribute_shop

2 attribute_group_lang

2 shop_group

2 attribute_lang

2 configuration

2 hook_alias

2 meta

2 group

2 group_shop

2 smarty_last_flush

2 category_group

2 hook_module

1 feature

1 feature_value_lang

1 feature_lang

1 order_detail

1 feature_shop

1 required_field

1 orders

1 group_lang

1 feature_product

1 page_type

1 connections

1 page

1 product_attribute_image

1 hook_module_exceptions

1 configuration_lang

1 module_group

1 country_shop

1 memcached_servers

1 attribute_group

1 layered_indexable_attribute_lang_value

1 country_lang

1 theme_meta

1 meta_lang

1 layered_indexable_attribute_group_lang_value

Hook processing : 959ms - 11.91Mb

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

displayHeader : 50ms - 4.38Mb
blockcart: 1ms - 0.09Mb
blocklayered: 0ms - 0.18Mb
homeslider: 0ms - 0.09Mb
blockuserinfo: 0ms - 0.06Mb
blocknewsletter: 0ms - 0.08Mb
blockviewed: 2ms - 0.1Mb
nq_universe: 0ms - 0.09Mb
socialsharing: 13ms - 0.15Mb
blockbestsellers: 1ms - 0.06Mb
nq_categoryhomepage: 0ms - 0.06Mb
nq_navigation: 1ms - 0.27Mb
infinitescroll: 1ms - 0.06Mb
favoriteproducts: 1ms - 0.08Mb
nq_mosaic: 0ms - 0.06Mb
nq_morefeature: 0ms - 0.07Mb
shoperize: 1ms - 0.26Mb
facebookpsconnect: 5ms - 0.22Mb
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: 1ms - 0.1Mb
nq_checkcurrency: 0ms - 0.05Mb
doofinder: 6ms - 0.1Mb
categoryslider: 0ms - 0.1Mb
genderpushes: 0ms - 0.1Mb
recaptcha: 0ms - 0.06Mb
nq_genderchoice: 0ms - 0.06Mb
codegenerator: 0ms - 0.06Mb
cedamazon: 0ms - 0.19Mb
cedrakutenaffiliate: 0ms - 0.06Mb
homefeatured: 0ms - 0.06Mb
facebookpsshoptab: 3ms - 0.32Mb
wkfacebookwallfeed: 0ms - 0.06Mb
ambjolisearch: 1ms - 0.27Mb
homecategory: 3ms - 0.15Mb

displayTop : 539ms - 3.21Mb
blockuserinfo: 0ms - 0.02Mb
nq_navigation: 536ms - 3.22Mb
infinitescroll: 0ms - -0.08Mb
facebookpsconnect: 1ms - 0.04Mb
ambjolisearch: 1ms - 0.02Mb

displayDailySpecialWomen : 10ms - 0.05Mb
nq_dailyspecial: 10ms - 0.05Mb

displayDailySpecialMen : 10ms - 0.05Mb
nq_dailyspecial: 10ms - 0.05Mb

displayDailySpecialKids : 10ms - 0.06Mb
nq_dailyspecial: 10ms - 0.06Mb

displayDailySpecialHome : 10ms - 0.06Mb
nq_dailyspecial: 10ms - 0.06Mb

displayLeftColumn : 1ms - 0.08Mb
blocklayered: 0ms - 0Mb
facebookpsconnect: 0ms - 0.04Mb
wkfacebookwallfeed: 1ms - 0.04Mb

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

displayFooterProduct : 0ms - 0Mb
ganalytics: 0ms - 0Mb

displayLeftColumnProduct : 1ms - 0.05Mb
favoriteproducts: 1ms - 0.05Mb

displayRightColumnProduct : 3ms - 0.17Mb
loyalty: 3ms - 0.17Mb

actionProductOutOfStock : 1ms - 0.05Mb
mailalerts: 1ms - 0.05Mb

displayProductButtons : 0ms - 0.01Mb
favoriteproducts: 0ms - 0.01Mb

displayFooter : 10ms - 0.66Mb
statsdata: 4ms - 0.38Mb
nq_footerlinks: 3ms - 0.09Mb
blocknewsletter: 1ms - 0.02Mb
happybirthday: 0ms - 0.06Mb
facebookpsconnect: 1ms - 0.05Mb
ganalytics: 0ms - 0Mb
commissionfactory: 0ms - 0.05Mb
cedrakutenaffiliate: 0ms - 0Mb

displayNqColorOption : 7ms - 0.12Mb
nq_color_option: 7ms - 0.12Mb

displayNqFollowBrand : 2ms - 0.02Mb
nq_follow_brand: 2ms - 0.02Mb

displaySocialSharing : 13ms - 0.02Mb
socialsharing: 13ms - 0.02Mb

displayTopSellers : 169ms - 1.35Mb
blockbestsellers: 169ms - 1.35Mb

displayViewed : 3ms - 0.04Mb
blockviewed: 3ms - 0.04Mb

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

Shopping cart (0)

Balneaire Colorful Knitted Floral Bikini Coffee Shorts (50156)

Recommendation

Recently viewed