000h 00m 00s Deals! 📉🤑
Home
Portal Community
Shop › Puzzles›Klassische Puzzle›Das Dorf des Weihnachtsmanns - Jan van Haasteren

Das Dorf des Weihnachtsmanns - Jan van Haasteren

5
·
Jumbo
·
Das Dorf des Weihnachtsmanns - Jan van Haasteren
Das Dorf des Weihnachtsmanns - Jan van Haasteren
Das Dorf des Weihnachtsmanns - Jan van Haasteren
Kategorien Klassische Puzzle, Puzzles
Tags Weihnachten, Schnee, Winter, Comic
Hersteller Jumbo
Versandgewicht ca. 800 g
Versandmasse ca. 37cm x 7cm x 28cm
loading ...

Zubehör

lädt ...
Load time174 ms - Unicorn powered webserver!
Querying time59 ms
Queries258
Memory peak usage6.5 Mb
Included files531 files - 7.29 Mb
thirty bees cache1.28 Mb
Global vars1.74 Mb
thirty bees version1.5.0
PrestaShop (emulated) version1.6.1.999
PHP version8.1.31 (OK)
MySQL version10.11.6-MariaDB-0+deb12u1-log (OK)
Memory limit512M
Max execution time600s
Smarty cachedisabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 57 ms 57 ms 2.47 Mb 2.54 Mb
__construct 0 ms 57 ms - Mb 2.54 Mb
init 10 ms 67 ms 1.02 Mb 3.50 Mb
setMedia 6 ms 74 ms 0.06 Mb 3.62 Mb
postProcess - ms 74 ms - Mb 3.62 Mb
initHeader 0 ms 74 ms - Mb 3.62 Mb
initContent 53 ms 127 ms 1.33 Mb 5.03 Mb
initFooter 4 ms 131 ms 0.11 Mb 5.07 Mb
display 43 ms 174 ms 1.27 Mb 6.53 Mb
Hook Time Memory Usage
hookdisplayHeader 20 ms - Mb
__construct 19 ms 4.00 Mb
hookdisplayFooter 3 ms - Mb
hookDisplayDeliveryDate 3 ms - Mb
hookproducttab 2 ms - Mb
hookproducttabcontent 2 ms - Mb
hookdisplayProductTabContent 1 ms - Mb
hookdisplayRevwsAverageRating 1 ms - Mb
hookdisplayProductExtraButtons 1 ms - Mb
hookdisplayBottomColumn 1 ms - Mb
hookmoduleRoutes 1 ms - Mb
hookactionFrontControllerSetMedia 0 ms - Mb
hookdisplayTab 0 ms - Mb
hookactionRegisterErrorHandlers - ms - Mb
hookdisplayTabContent - ms - Mb
hooktop - ms - Mb
hookdisplayTop - ms - Mb
hookdisplayRightColumnProduct - ms - Mb
hookdisplayProductTab - ms - Mb
hookDisplayProductEmailNotification - ms - Mb
hookdisplayTopColumn - ms - Mb
hookdisplayCenterColumnTop - ms - Mb
hookdisplayCenterColumnBottom - ms - Mb
23 hooks 54 ms 4.00 Mb
Module Time Memory Usage
tb_framework 17 ms - Mb
genzo_filter 5 ms - Mb
ph_relatedposts 4 ms - Mb
genzo_shipping 3 ms - Mb
genzo_search 3 ms - Mb
genzo_erp 2 ms - Mb
genzo_faq 2 ms - Mb
genzo_revws 2 ms - Mb
genzo_crm 2 ms - Mb
revws 2 ms - Mb
genzo_zar 1 ms - Mb
genzo_tags 1 ms - Mb
genzo_krona 1 ms - Mb
genzo_accounting 1 ms - Mb
ph_simpleblog 1 ms - Mb
genzo_questions 1 ms - Mb
collectlogs 1 ms - Mb
genzo_affiliate 1 ms 2.00 Mb
genzo_turnstile 1 ms - Mb
extraproducttab 1 ms - Mb
genzo_theme_configurator 1 ms - Mb
statsmodule 1 ms - Mb
genzo_shortcodes 1 ms 2.00 Mb
genzo_quiz 0 ms - Mb
genzo_category 0 ms - Mb
genzo_events 0 ms - Mb
genzo_portal 0 ms - Mb
27 modules 54 ms 4.00 Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 258 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE `id_product`
FROM `ps_product_lang`
WHERE (`link_rewrite` = 'das-dorf-des-weihnachtsmanns-jan-van-haasteren') AND (`id_lang` = 1) AND (`id_shop` = 3)
 11 42374 /classes/Dispatcher.php:1413 
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN `ps_stock_available` sa ON sa.id_product=p.id_product AND sa.quantity>0
WHERE (p.reference = '38973-Fundus') AND (p.active=1)
GROUP BY p.id_product LIMIT 1
 8.5 1 Yes /modules/genzo_erp/genzo_erp.php:716 
SELECT SQL_NO_CACHE *
FROM `ps_genzo_tags` t
INNER JOIN `ps_genzo_tags_lang` tl ON t.id_tag=tl.id_tag AND tl.id_lang=1
INNER JOIN `ps_genzo_tags_shop` ts ON t.id_tag=ts.id_tag AND ts.id_shop=3
INNER JOIN `ps_genzo_tags_product` tp ON t.id_tag=tp.id_tag AND tp.id_product=27333
WHERE (active = 1) AND (ignored = 0)
 1.8 819 /modules/genzo_tags/classes/Tag.php:169 
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`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`
 1.8 993 /classes/Configuration.php:529 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 1.4 2248 /classes/SpecificPrice.php:377 
SELECT SQL_NO_CACHE id_simpleblog_post, id_product
FROM `ps_simpleblog_related_post`
WHERE (id_product = 27333)
 1 6468 /modules/ph_relatedposts/models/SimpleBlogRelatedPost.php:35 
SELECT SQL_NO_CACHE 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 = 3 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 3) AND (mg.`id_shop` = 3 AND  mg.`id_group` IN (3))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 0.9 96 Yes Yes /classes/Hook.php:666 
SELECT SQL_NO_CACHE id_simpleblog_post, id_product
FROM `ps_simpleblog_related_post`
WHERE (id_product = 27333)
 0.8 6468 /modules/ph_relatedposts/models/SimpleBlogRelatedPost.php:35 
SELECT SQL_NO_CACHE id_simpleblog_post, id_product
FROM `ps_simpleblog_related_post`
WHERE (id_product = 27333)
 0.6 6468 /modules/ph_relatedposts/models/SimpleBlogRelatedPost.php:35 
SELECT SQL_NO_CACHE id_simpleblog_post, id_product
FROM `ps_simpleblog_related_post`
WHERE (id_product = 27333)
 0.6 6468 /modules/ph_relatedposts/models/SimpleBlogRelatedPost.php:35 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) 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, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-12-03 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=3)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 3 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 3 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=3)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
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 = 0 AND stock.id_shop = 3  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 27333 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 0.6 9 Yes /classes/Product.php:6276 
SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 3)
STRAIGHT_JOIN `ps_module` AS m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 0.5 236 /classes/Hook.php:192 
SELECT SQL_NO_CACHE fv.id_feature, fv.id_feature_value, gfvl.link_rewrite AS link_rewrite_feature_value, gfl.link_rewrite AS link_rewrite_feature, gfvl.link_custom
FROM `ps_feature_value` fv
INNER JOIN `ps_genzo_tags_feature_value` gfv ON fv.id_feature_value=gfv.id_feature_value
INNER JOIN `ps_genzo_tags_feature_value_lang` gfvl ON gfvl.id_feature_value_helper=gfv.id_feature_value_helper AND gfvl.id_lang = 1
INNER JOIN `ps_genzo_tags_feature` gf ON gf.id_feature = fv.id_feature
INNER JOIN `ps_genzo_tags_feature_lang` gfl ON gf.id_feature_helper = gfl.id_feature_helper
WHERE (gf.listing = 1 AND gfv.listing=1 AND gfl.link_rewrite!='' AND gfvl.link_rewrite!='')
GROUP BY fv.id_feature_value
 0.4 86 Yes Yes /override/classes/Product.php:350 
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 497)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 497
ORDER BY f.position, 
(CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
(CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
(CASE WHEN f.sorting='custom' THEN fv.position END) ASC
 0.4 5530 Yes /override/classes/Product.php:320 
SELECT SQL_NO_CACHE 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 = 3)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 3 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 66
AND category_shop.`active` = 1
AND cg.`id_group` =3
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.4 1 Yes Yes /classes/Category.php:1658 
SELECT SQL_NO_CACHE `tab`.`id_Tab`,`tablang`.`displayname`,IF(LENGTH(`tabContent`.`content`)>0,`tabContent`.`content`,`tablang`.`defaultContent`) AS content FROM `ps_extraproducttab` `tab` INNER JOIN `ps_extraproducttab_lang` `tablang` ON `tab`.`id_Tab` = `tablang`.`id_Tab`  LEFT JOIN `ps_extraproducttab_product_lang` `tabContent` ON `tab`.`id_Tab` = `tabContent`.`id_Tab` AND `tabContent`.`id_product` = 27333 AND `tabContent`.`id_lang` = 1 WHERE `tablang`.`id_lang` = 1 AND `tab`.`id_Tab` NOT IN (SELECT `id_Tab` FROM `ps_extraproducttab_product` WHERE `id_product` = 27333) HAVING LENGTH(content)>0 ORDER BY `tab`.`position` ASC;
 0.4 63 Yes /modules/extraproducttab/extraproducttab.php:663 
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 27333)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 27333
ORDER BY f.position, 
(CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
(CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
(CASE WHEN f.sorting='custom' THEN fv.position END) ASC
 0.4 11060 Yes /override/classes/Product.php:320 
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 4514)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 4514
ORDER BY f.position, 
(CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
(CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
(CASE WHEN f.sorting='custom' THEN fv.position END) ASC
 0.4 6636 Yes /override/classes/Product.php:320 
SELECT SQL_NO_CACHE `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
 0.4 0 /classes/Hook.php:799 
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 5068)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 5068
ORDER BY f.position, 
(CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
(CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
(CASE WHEN f.sorting='custom' THEN fv.position END) ASC
 0.4 5530 Yes /override/classes/Product.php:320 
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 498)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 498
ORDER BY f.position, 
(CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
(CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
(CASE WHEN f.sorting='custom' THEN fv.position END) ASC
 0.4 5530 Yes /override/classes/Product.php:320 
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 501)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 501
ORDER BY f.position, 
(CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
(CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
(CASE WHEN f.sorting='custom' THEN fv.position END) ASC
 0.4 5530 Yes /override/classes/Product.php:320 
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 2539)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 2539
ORDER BY f.position, 
(CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
(CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
(CASE WHEN f.sorting='custom' THEN fv.position END) ASC
 0.4 5530 Yes /override/classes/Product.php:320 
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
FROM ps_feature_product pf
LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 5918)
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3)
WHERE pf.id_product = 5918
ORDER BY f.position, 
(CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
(CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
(CASE WHEN f.sorting='custom' THEN fv.position END) ASC
 0.4 3318 Yes /override/classes/Product.php:320 
SELECT SQL_NO_CACHE 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 = 3 
ORDER BY LENGTH(ml.`url_rewrite`) DESC
 0.3 137 Yes /classes/Dispatcher.php:614 
SELECT SQL_NO_CACHE 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, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, 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 = 3)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 3  AND stock.id_shop_group = 0  )
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 = 3)
WHERE pa.`id_product` = 27333
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 0.3 1 Yes Yes /classes/Product.php:6228 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 27333) AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`))
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.3 2 Yes /classes/SpecificPrice.php:560 
SELECT SQL_NO_CACHE 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 = 3 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 3)
WHERE c.nleft <= 223
AND c.nright >= 224
AND c.nleft >= 1
AND c.nright <= 374
AND cl.id_lang = 1
AND category_shop.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
 0.2 187 Yes /classes/Tools.php:1825 
SELECT SQL_NO_CACHE *
FROM `ps_genzo_faq_section` s
INNER JOIN `ps_genzo_faq_section_lang` sl ON s.id_section=sl.id_section AND sl.id_lang=1
INNER JOIN `ps_genzo_faq_section_shop` ss ON s.id_section=ss.id_section AND ss.id_shop=3
INNER JOIN `ps_genzo_faq_section_entity` se ON s.id_section=se.id_section
INNER JOIN `ps_category_product` cp ON cp.id_product=27333
WHERE (entity_type='product_from_category') AND ((FIND_IN_SET(cp.id_category, entity_ids_include)>0))
GROUP BY s.id_section
ORDER BY s.position
 0.2 16 Yes Yes /modules/genzo_faq/model/Section.php:98 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 497) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 3 Yes /classes/SpecificPrice.php:253 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 27333) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 2 Yes /classes/SpecificPrice.php:253 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 223 AND c.nright >= 224)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_genzo_faq_section` s
INNER JOIN `ps_genzo_faq_section_lang` sl ON s.id_section=sl.id_section AND sl.id_lang=1
INNER JOIN `ps_genzo_faq_section_shop` ss ON s.id_section=ss.id_section AND ss.id_shop=3
INNER JOIN `ps_genzo_faq_section_entity` se ON s.id_section=se.id_section
WHERE (entity_type='product') AND ((entity_ids_include='*' AND (FIND_IN_SET(27333, entity_ids_exclude) = 0)) OR (FIND_IN_SET(27333, entity_ids_include)>0))
ORDER BY s.position
 0.2 16 Yes /modules/genzo_faq/model/Section.php:78 
SELECT SQL_NO_CACHE 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` = 1
WHERE (s.`deleted` = 0) AND (gs.`deleted` = 0)
ORDER BY gs.`name`, s.`name`
 0.2 4 Yes /classes/shop/Shop.php:707 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 223 AND c.nright >= 224)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 223 AND c.nright >= 224)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_genzo_faq_question` q
INNER JOIN `ps_genzo_faq_question_lang` l ON q.id_question=l.id_question AND l.id_lang=1
INNER JOIN `ps_genzo_faq_question_shop` s ON q.id_question=s.id_question AND s.id_shop=3
INNER JOIN `ps_genzo_faq_question_section` qs ON q.id_question=qs.id_question AND qs.id_section=1
WHERE (active = 1)
ORDER BY position
 0.2 11 Yes /modules/genzo_faq/model/Question.php:105 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 298 AND c.nright >= 299)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 501) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 2 Yes /classes/SpecificPrice.php:253 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 498) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 4 Yes /classes/SpecificPrice.php:253 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 5068) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 3 Yes /classes/SpecificPrice.php:253 
SELECT SQL_NO_CACHE *
FROM `ps_order_state` os
LEFT JOIN `ps_order_state_lang` `osl` ON os.`id_order_state` = osl.`id_order_state`
WHERE (osl.`id_lang` = 1) AND (`deleted` = 0) AND (`active` = 1)
ORDER BY `name` ASC
 0.2 34 Yes /classes/order/OrderState.php:158 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 2539) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 2 Yes /classes/SpecificPrice.php:253 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 5918) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 2 Yes /classes/SpecificPrice.php:253 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) +  IF (`id_country` = 19, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 3, 16, 0)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 4514) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
 0.2 2 Yes /classes/SpecificPrice.php:253 
SELECT SQL_NO_CACHE 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.genzo.ch' OR su.domain_ssl = 'www.genzo.ch') AND (s.`active` = 1) AND (s.`deleted` = 0)
ORDER BY LENGTH(CONCAT(su.`physical_uri`, su.`virtual_uri`)) DESC
 0.2 2 Yes /classes/shop/Shop.php:342 
SELECT SQL_NO_CACHE 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 = 3 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 3)
WHERE `id_lang` = 1
AND c.`id_parent` = 103
AND category_shop.`active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.2 9 Yes Yes /classes/Category.php:558 
SELECT SQL_NO_CACHE 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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 3)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 3)
WHERE pa.`id_product` = 27333
 0.2 1 /classes/Product.php:3830 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.2 1 /classes/shop/Shop.php:1218 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 296 AND c.nright >= 297)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_genzo_faq_question` q
INNER JOIN `ps_genzo_faq_question_lang` l ON q.id_question=l.id_question AND l.id_lang=1
INNER JOIN `ps_genzo_faq_question_shop` s ON q.id_question=s.id_question AND s.id_shop=3
INNER JOIN `ps_genzo_faq_question_section` qs ON q.id_question=qs.id_question AND qs.id_section=3
WHERE (active = 1)
ORDER BY position
 0.2 11 Yes /modules/genzo_faq/model/Question.php:105 
SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 497 AND r.deleted = 0 AND r.id_lang = 1 AND r.validated = 1 LIMIT 1
 0.2 6 /modules/revws/model/review.php:326 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 223 AND c.nright >= 224)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 296 AND c.nright >= 297)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE 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 = 3)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 27333
ORDER BY `position`
 0.2 3 Yes /classes/Product.php:5976 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 298 AND c.nright >= 299)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 27333) AND (b.`id_shop` = 3) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 296 AND c.nright >= 297)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 296 AND c.nright >= 297)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 27333 AND r.deleted = 0 AND r.id_lang = 1 AND r.validated = 1 LIMIT 1
 0.2 1 /modules/revws/model/review.php:326 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 294 AND c.nright >= 295)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
 0.2 1 /classes/Category.php:453 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 294 AND c.nright >= 295)
ORDER BY c.nleft
 0.2 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 498 AND r.deleted = 0 AND r.id_lang = 1 AND r.validated = 1 LIMIT 1
 0.1 10 /modules/revws/model/review.php:326 
SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 501 AND r.deleted = 0 AND r.id_lang = 1 AND r.validated = 1 LIMIT 1
 0.1 11 /modules/revws/model/review.php:326 
SELECT SQL_NO_CACHE 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` = 3) AND (s.`active` = 1) AND (s.`deleted` = 0) AND (su.`main` = 1) LIMIT 1
 0.1 1 /classes/shop/Shop.php:174 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 27333) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 27333) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 497) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 227) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category_lang`
WHERE (`link_rewrite` = 'das-dorf-des-weihnachtsmanns-jan-van-haasteren') AND (`id_lang` = 1) AND (`id_shop` = 3)
 0.1 188 /classes/Dispatcher.php:1466 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 296 AND c.nright >= 297)
ORDER BY c.nleft
 0.1 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 296 AND c.nright >= 297)
ORDER BY c.nleft
 0.1 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 296 AND c.nright >= 297)
ORDER BY c.nleft
 0.1 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 294 AND c.nright >= 295)
ORDER BY c.nleft
 0.1 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 294 AND c.nright >= 295)
ORDER BY c.nleft
 0.1 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 19
AND tr.`id_tax_rules_group` = 7
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.1 1 /classes/tax/TaxRulesTaxManager.php:129 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 223 AND c.nright >= 224)
ORDER BY c.nleft
 0.1 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 
WHERE (c.nleft <= 296 AND c.nright >= 297)
ORDER BY c.nleft
 0.1 187 Yes /classes/Product.php:7840 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 4514) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 501) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 5918) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 2539) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 228) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 2539 AND r.deleted = 0 AND r.id_lang = 1 AND r.validated = 1 LIMIT 1
 0.1 5 /modules/revws/model/review.php:326 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 3)
WHERE (`deleted` = 0) AND (c.`active` = 1)
ORDER BY `name` ASC
 0.1 16 Yes /classes/Currency.php:390 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 498) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE DISTINCT g.`id_group`, g.`reduction`, g.`price_display_method`, gl.`name`
FROM `ps_group` g
LEFT JOIN `ps_group_lang` `gl` ON g.`id_group` = gl.`id_group` AND gl.`id_lang` = 1
ORDER BY g.`id_group` ASC
 0.1 11 /classes/Group.php:152 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3
WHERE (a.`id_product` = 5068) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_product_supplier` a0
WHERE (a0.`id_product` = 27333)
GROUP BY a0.`id_supplier`
 0.1 1 Yes Yes /classes/PrestaShopCollection.php:650 
SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 5918 AND r.deleted = 0 AND r.id_lang = 1 AND r.validated = 1 LIMIT 1
 0.1 3 /modules/revws/model/review.php:326 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`)
FROM `ps_lang` l
INNER JOIN `ps_lang_shop` ls ON ls.`id_lang` = l.`id_lang`
WHERE (ls.`id_shop` = 3) AND (l.`active` = 1) LIMIT 1
 0.1 1 /classes/Language.php:385 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 3
WHERE (a.`id_country` = 19) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 3)
WHERE (`deleted` = 0)
ORDER BY `name` ASC
 0.1 16 Yes /classes/Currency.php:390 
SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 5068 AND r.deleted = 0 AND r.id_lang = 1 AND r.validated = 1 LIMIT 1
 0.1 1 /modules/revws/model/review.php:326 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 3
 0.1 49 /classes/module/Module.php:210 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 3
WHERE (a.`id_cms` = 58) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 27333)
 0.1 1 /classes/Product.php:1113 
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_lang` `pl` ON pl.`id_product` = p.`id_product`  AND pl.id_shop = 3 
WHERE (pl.`id_lang` = 1) AND (pl.`id_product` = 27333) AND (product_shop.`active` = 1) LIMIT 1
 0.1 1 /classes/Meta.php:323 
SELECT SQL_NO_CACHE *
FROM `ps_genzo_erp_product_extension` a
WHERE (a.`id_product` = 27333) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 103) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 19
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.1 0 /classes/tax/TaxRulesTaxManager.php:129 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 12) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE (`id_product` = 27333) AND (`id_shop` = 3)
 0.1 1 /Adapter/Adapter_EntityMapper.php:82 
SELECT SQL_NO_CACHE (SUM(ra.grade) / COUNT(1)) AS grade, COUNT(distinct r.id_review) as cnt
FROM ps_revws_review r
LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
WHERE r.entity_type = 'product' AND r.id_entity = 4514 AND r.deleted = 0 AND r.id_lang = 1 AND r.validated = 1 LIMIT 1
 0.1 1 /modules/revws/model/review.php:326 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` `h` ON h.`id_hook` = hm.`id_hook`
WHERE (h.`name` = 'moduleRoutes') AND (hm.`id_module` = 74) LIMIT 1
 0.1 1 /classes/module/Module.php:2969 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 426) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 422) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE 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` = 5) AND (m.`page` = 'product') LIMIT 1
 0.1 1 /classes/Theme.php:376 
SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 498)
 0.1 1 /classes/Product.php:1113 
SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 501)
 0.1 1 /classes/Product.php:1113 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 228) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 157) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 497)
 0.1 1 /classes/Product.php:1113 
SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 5068)
 0.1 1 /classes/Product.php:1113 
SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 5918)
 0.1 1 /classes/Product.php:1113 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` `h` ON h.`id_hook` = hm.`id_hook`
WHERE (h.`name` = 'displayPrestaHomeBlogAfterPostContent') AND (hm.`id_module` = 74) LIMIT 1
 0.1 1 /classes/module/Module.php:2969 
SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 2539)
 0.1 1 /classes/Product.php:1113 
SELECT SQL_NO_CACHE c.id_carrier
FROM `ps_carrier` c
INNER JOIN `ps_carrier_shop` cs ON c.id_carrier=cs.id_carrier
WHERE (deleted = 0 AND active = 1 AND `id_shop` = 3 )
 0.1 4 /modules/genzo_shipping/genzo_shipping.php:123 
SELECT SQL_NO_CACHE `id_product_download`
FROM `ps_product_download`
WHERE (`id_product` = 27333) AND (`active` = 1)
ORDER BY `id_product_download` DESC LIMIT 1
 0.1 0 /classes/ProductDownload.php:128 
SELECT SQL_NO_CACHE product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 3)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 3)
WHERE (p.`id_product` = 4514)
 0.1 1 /classes/Product.php:1113 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 3
WHERE (a.`id_cms` = 59) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE 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 = 3)
WHERE pa.id_product = 497 LIMIT 1
 0.1 1 /classes/Product.php:1313 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 421) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 5) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` `ls` ON l.`id_lang` = ls.`id_lang`
 0.1 1 /classes/Language.php:184 
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 3
WHERE (a.`id_manufacturer` = 39) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 66) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 422) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 12) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 426) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE 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` = 27333 AND ctg.`id_group` = 3 LIMIT 1
 0.1 4 /classes/Product.php:6805 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 227) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE *
FROM `ps_image_type`
ORDER BY `name` ASC
 0.1 11 Yes /classes/ImageType.php:253 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 3
WHERE (a.`id_cms` = 62) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 157) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 3
WHERE (a.`id_cms` = 60) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 3
WHERE (a.`id_cms` = 63) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.1 86 /classes/Hook.php:755 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 233) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE 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 = 3)
WHERE pa.id_product = 27333 LIMIT 1
 0.1 1 /classes/Product.php:1313 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 66) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 421) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 3
WHERE (a.`id_cms` = 61) AND (b.`id_shop` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 3
WHERE (a.`id_lang` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 3
WHERE (a.`id_currency` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE 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 = 3)
WHERE p.id_product = 27333
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-03 00:00:00",
INTERVAL 30 DAY
)
) > 0
 0.1 0 /classes/Product.php:810 
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 66
AND id_shop = 3 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1623 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 3 ) AND (c.`id_category` = 103) LIMIT 1
 0.1 1 /classes/Category.php:2187 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 3 
AND cl.`id_category` = 66 LIMIT 1
 0.1 0 /classes/Category.php:749 
SELECT SQL_NO_CACHE 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 = 3)
WHERE pa.id_product = 498 LIMIT 1
 0.1 1 /classes/Product.php:1313 
SELECT SQL_NO_CACHE id_game
FROM `ps_genzo_zar_game_product`
WHERE (id_product = 27333) LIMIT 1
 0.1 1 /modules/genzo_zar/classes/Game.php:58 
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth`
FROM `ps_category`
WHERE (`id_category` = 103) LIMIT 1
 0.1 1 /classes/Category.php:987 
SELECT SQL_NO_CACHE 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 = 3)
WHERE pa.id_product = 501 LIMIT 1
 0.1 1 /classes/Product.php:1313 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 3
WHERE (a.`id_category` = 1) AND (b.`id_shop` = 3) LIMIT 1
 0.1 0 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE `domain`, `domain_ssl`
FROM `ps_shop_url`
WHERE (`main` = 1) AND (`id_shop` = 3) LIMIT 1
 0.1 1 /classes/shop/ShopUrl.php:237 
SELECT SQL_NO_CACHE 1
FROM `ps_specific_price`
WHERE (`from` BETWEEN '2024-12-03 00:00:00' AND '2024-12-03 23:59:59') LIMIT 1
 0.1 1 /classes/SpecificPrice.php:328 
SELECT SQL_NO_CACHE 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` = 27333)
 0.1 1 /classes/Tag.php:322 
SELECT SQL_NO_CACHE 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 = 3)
WHERE pa.id_product = 2539 LIMIT 1
 0.1 1 /classes/Product.php:1313 
SELECT SQL_NO_CACHE 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 = 3)
WHERE pa.id_product = 4514 LIMIT 1
 0.1 1 /classes/Product.php:1313 
SELECT SQL_NO_CACHE 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 = 3)
WHERE pa.id_product = 5068 LIMIT 1
 0.1 1 /classes/Product.php:1313 
SELECT SQL_NO_CACHE 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 = 3)
WHERE pa.id_product = 5918 LIMIT 1
 0.1 1 /classes/Product.php:1313 
SELECT SQL_NO_CACHE active
FROM `ps_genzo_krona_action` a
WHERE (`module` = 'genzo_krona') AND (`key` = 'page_visit') LIMIT 1
 0.1 19 /modules/genzo_krona/classes/Action.php:108 
SELECT SQL_NO_CACHE `width`, `height`
FROM `ps_image_type`
WHERE (`name` = 'genzo_theme_large_default') LIMIT 1
 0.1 1 /classes/Image.php:549 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 27333) LIMIT 1
 0.1 1 /modules/genzo_shipping/genzo_shipping.php:112 
SELECT SQL_NO_CACHE `id_module`
FROM `ps_module_shop`
WHERE (`id_module` = 375) AND (`id_shop` = 3) LIMIT 1
 0.1 1 /classes/module/Module.php:1386 
SELECT SQL_NO_CACHE `id_module`, `name`
FROM `ps_module`
 0.1 49 /classes/module/Module.php:1631 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 497)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:460 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 27333) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:450 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) AS last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
 0.1 1 /classes/smarty/SmartyCustom.php:214 
SELECT SQL_NO_CACHE `width`, `height`
FROM `ps_image_type`
WHERE (`name` = 'genzo_theme_medium_default') LIMIT 1
 0.1 1 /classes/Image.php:549 
SELECT SQL_NO_CACHE `id_lang`, `iso_code`
FROM `ps_lang`
WHERE (`active` = 1)
 0.1 1 /classes/Language.php:283 
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 3
WHERE (a.`id_group` = 3) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 3 
AND cl.`id_category` = 66 LIMIT 1
 0.1 1 /classes/Category.php:749 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 6) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:74 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 27333
 0.1 4 /classes/Product.php:4876 
SELECT SQL_NO_CACHE `width`, `height`
FROM `ps_image_type`
WHERE (`name` = 'genzo_theme_home_default') LIMIT 1
 0.1 1 /classes/Image.php:549 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 3 
AND cl.`id_category` = 450 LIMIT 1
 0.1 1 /classes/Category.php:749 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 5918)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:460 
SELECT SQL_NO_CACHE name
FROM `ps_manufacturer`
WHERE (`id_manufacturer` = 39) LIMIT 1
 0.1 1 /override/classes/Manufacturer.php:16 
SELECT SQL_NO_CACHE *
FROM `ps_hook_module_exceptions`
WHERE (`id_shop` IN (3))
 0.1 2 /classes/module/Module.php:2842 
SELECT SQL_NO_CACHE `width`, `height`
FROM `ps_image_type`
WHERE (`name` = 'genzo_theme_cart_default') LIMIT 1
 0.1 1 /classes/Image.php:549 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 3 
AND cl.`id_category` = 448 LIMIT 1
 0.1 1 /classes/Category.php:749 
SELECT SQL_NO_CACHE 1
FROM `ps_specific_price`
WHERE (`to` BETWEEN '2024-12-03 00:00:00' AND '2024-12-03 23:59:59') LIMIT 1
 0.1 1 /classes/SpecificPrice.php:334 
SELECT SQL_NO_CACHE `id_module`
FROM `ps_module_shop`
WHERE (`id_module` = 74) AND (`id_shop` = 3) LIMIT 1
 0.1 1 /classes/module/Module.php:1386 
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth`
FROM `ps_category`
WHERE (`id_category` = 66) LIMIT 1
 0.1 1 /classes/Category.php:987 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 3 
AND cl.`id_category` = 449 LIMIT 1
 0.1 1 /classes/Category.php:749 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE (`id_tax` = 6)
 0.1 1 /Adapter/Adapter_EntityMapper.php:82 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 27333)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:460 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 5068)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:460 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5918) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:450 
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth`
FROM `ps_category`
WHERE (`id_category` = 450) LIMIT 1
 0.1 1 /classes/Category.php:987 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 501) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:450 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 3 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1623 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 497) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:450 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 2539)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:460 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 4514)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:460 
SELECT SQL_NO_CACHE bundle
FROM `ps_genzo_erp_product_extension`
WHERE (id_product = 27333) LIMIT 1
 0.1 1 /modules/genzo_erp/classes/ProductExtensionErp.php:349 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE (`id_group` = 3)
 0.1 1 /Adapter/Adapter_EntityMapper.php:82 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 498)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:460 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2539) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:450 
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 27333
AND id_shop = 3 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1623 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 498) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:450 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5068) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:450 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 27333 AND id_shop=3 LIMIT 1
 0.1 1 /classes/Product.php:1413 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 27333) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:801 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 501 AND id_shop=3 LIMIT 1
 0.1 1 /classes/Product.php:1413 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4514) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:450 
SELECT SQL_NO_CACHE `id_cms_category`
FROM `ps_cms`
WHERE (`id_cms` = 58) LIMIT 1
 0.1 1 /classes/Link.php:745 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = 501)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:460 
SELECT SQL_NO_CACHE `id_cms_category`
FROM `ps_cms`
WHERE (`id_cms` = 59) LIMIT 1
 0.1 1 /classes/Link.php:745 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4514 AND id_shop=3 LIMIT 1
 < 1 1 /classes/Product.php:1413 
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth`
FROM `ps_category`
WHERE (`id_category` = 449) LIMIT 1
 < 1 1 /classes/Category.php:987 
SELECT SQL_NO_CACHE `id_module`
FROM `ps_module_shop`
WHERE (`id_module` = 349) AND (`id_shop` = 3) LIMIT 1
 < 1 1 /classes/module/Module.php:1386 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 497 AND id_shop=3 LIMIT 1
 < 1 1 /classes/Product.php:1413 
SELECT SQL_NO_CACHE `nleft`, `nright`, `level_depth`
FROM `ps_category`
WHERE (`id_category` = 448) LIMIT 1
 < 1 1 /classes/Category.php:987 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5068 AND id_shop=3 LIMIT 1
 < 1 1 /classes/Product.php:1413 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 497) AND (`id_group` = 3) LIMIT 1
 < 1 0 /classes/GroupReduction.php:117 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 498 AND id_shop=3 LIMIT 1
 < 1 1 /classes/Product.php:1413 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2539 AND id_shop=3 LIMIT 1
 < 1 1 /classes/Product.php:1413 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5918 AND id_shop=3 LIMIT 1
 < 1 1 /classes/Product.php:1413 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 27333) AND (`id_group` = 3) LIMIT 1
 < 1 0 /classes/GroupReduction.php:117 
SELECT SQL_NO_CACHE `id_cms_category`
FROM `ps_cms`
WHERE (`id_cms` = 60) LIMIT 1
 < 1 1 /classes/Link.php:745 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 3 LIMIT 1
 < 1 1 /classes/ObjectModel.php:1623 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE (`id_group` = 3) LIMIT 1
 < 1 1 /classes/Group.php:235 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 27333) AND (id_product_attribute = 0) AND (id_shop = 3) AND (id_shop_group = 0) LIMIT 1
 < 1 1 /classes/stock/StockAvailable.php:772 
SELECT SQL_NO_CACHE `id_cms_category`
FROM `ps_cms`
WHERE (`id_cms` = 62) LIMIT 1
 < 1 1 /classes/Link.php:745 
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 3
AND id_shop = 3 LIMIT 1
 < 1 1 /classes/ObjectModel.php:1623 
SELECT SQL_NO_CACHE `name`
FROM `ps_supplier`
WHERE (`id_supplier` = 0) LIMIT 1
 < 1 0 /classes/Supplier.php:279 
SELECT SQL_NO_CACHE `id_cms_category`
FROM `ps_cms`
WHERE (`id_cms` = 61) LIMIT 1
 < 1 1 /classes/Link.php:745 
SELECT SQL_NO_CACHE `id_cms_category`
FROM `ps_cms`
WHERE (`id_cms` = 63) LIMIT 1
 < 1 1 /classes/Link.php:745 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 501) AND (`id_group` = 3) LIMIT 1
 < 1 0 /classes/GroupReduction.php:117 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 4514) AND (`id_group` = 3) LIMIT 1
 < 1 0 /classes/GroupReduction.php:117 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 2539) AND (`id_group` = 3) LIMIT 1
 < 1 0 /classes/GroupReduction.php:117 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 5068) AND (`id_group` = 3) LIMIT 1
 < 1 0 /classes/GroupReduction.php:117 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 498) AND (`id_group` = 3) LIMIT 1
 < 1 0 /classes/GroupReduction.php:117 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = 5918) AND (`id_group` = 3) LIMIT 1
 < 1 0 /classes/GroupReduction.php:117

Doubles

20
SELECT m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = XX
19
SELECT *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = XX AND cl.id_shop = XX 
WHERE (c.nleft <= XX AND c.nright >= XX)
ORDER BY c.nleft
10
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
10
SELECT c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = XX AND cl.id_shop = XX ) AND (c.`id_category` = XX) LIMIT XX
9
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
8
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 = XX)
				WHERE pa.id_product = XX LIMIT XX
8
SELECT `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE (`id_product` = XX)
ORDER BY `id_specific_price_priority` DESC LIMIT XX
8
SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX)) AS `score`
FROM `ps_specific_price`
WHERE (`id_shop` IN (XX, XX)) AND (`id_currency` IN (XX, XX)) AND (`id_country` IN (XX, XX)) AND (`id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)) AND (IF(`from_quantity` > XX, `from_quantity`, XX) <= XX)
ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
8
SELECT product_shop.`price`,
product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) AS id_product_attribute,
product_attribute_shop.`price` AS attribute_price,
product_attribute_shop.default_on,
product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
8
							SELECT `id_tax_rules_group`
							FROM `ps_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
8
SELECT `reduction`
FROM `ps_product_group_reduction_cache`
WHERE (`id_product` = XX) AND (`id_group` = XX) LIMIT XX
8
SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
8
				SELECT COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values
				FROM ps_feature_product pf
				LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = XX AND pfl.id_product = XX)
				LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX)
				LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value)
				LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX)
				LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX)
				 INNER JOIN ps_feature_shop feature_shop
		ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX)
				WHERE pf.id_product = XX
				ORDER BY f.position, 
				    (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC,
				    (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, 
				    (CASE WHEN f.sorting='custom' THEN fv.position END) ASC
8
          SELECT (SUM(ra.grade) / COUNT(XX)) AS grade, COUNT(distinct r.id_review) as cnt
            FROM ps_revws_review r
            LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review)
            WHERE r.entity_type = 'product' AND r.id_entity = XX AND r.deleted = XX AND r.id_lang = XX AND r.validated = XX LIMIT XX
6
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX
WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX
6
SELECT `id_cms_category`
FROM `ps_cms`
WHERE (`id_cms` = XX) LIMIT XX
5
			SELECT cl.`link_rewrite`
			FROM `ps_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
5
SELECT `nleft`, `nright`, `level_depth`
FROM `ps_category`
WHERE (`id_category` = XX) LIMIT XX
4
SELECT id_simpleblog_post, id_product
FROM `ps_simpleblog_related_post`
WHERE (id_product = XX)
3
SELECT `id_module`
FROM `ps_module_shop`
WHERE (`id_module` = XX) AND (`id_shop` = XX) LIMIT XX
2
				SELECT tr.*
				FROM `ps_tax_rule` tr
				JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
				WHERE trg.`active` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2
SELECT *
FROM `ps_genzo_faq_question` q
INNER JOIN `ps_genzo_faq_question_lang` l ON q.id_question=l.id_question AND l.id_lang=XX
INNER JOIN `ps_genzo_faq_question_shop` s ON q.id_question=s.id_question AND s.id_shop=XX
INNER JOIN `ps_genzo_faq_question_section` qs ON q.id_question=qs.id_question AND qs.id_section=XX
WHERE (active = XX)
ORDER BY position

Tables stress

50 category_lang
48 category
30 product_shop
25 module_shop
23 module
22 product
19 product_attribute_shop
14 stock_available
14 category_shop
13 product_lang
12 specific_price
12 cms
10 product_attribute
9 feature_value
8 specific_price_priority
8 product_group_reduction_cache
8 feature_product
8 feature_product_lang
8 feature_lang
8 feature_value_lang
8 feature
8 feature_shop
8 revws_review
8 revws_review_grade
6 hook
6 cms_lang
6 cms_shop
5 image_type
4 shop_url
4 shop
4 lang
4 lang_shop
4 hook_module
4 currency_shop
4 simpleblog_related_post
3 theme
3 group
3 currency
3 manufacturer
3 category_product
2 configuration
2 shop_group
2 hook_alias
2 group_lang
2 meta
2 group_shop
2 tax_rule
2 tax_rules_group
2 category_group
2 genzo_erp_product_extension
2 image_shop
2 image_lang
2 product_attribute_combination
2 attribute
2 attribute_lang
2 attribute_group_lang
2 attribute_shop
2 genzo_faq_section
2 genzo_faq_section_lang
2 genzo_faq_section_shop
2 genzo_faq_section_entity
2 genzo_faq_question
2 genzo_faq_question_lang
2 genzo_faq_question_shop
2 genzo_faq_question_section
1 configuration_lang
1 country
1 country_lang
1 country_shop
1 module_group
1 order_state
1 order_state_lang
1 meta_lang
1 theme_meta
1 supplier
1 tax
1 tax_lang
1 tag
1 product_tag
1 hook_module_exceptions
1 genzo_krona_action
1 product_supplier
1 product_download
1 image
1 attribute_group
1 accessory
1 genzo_tags_feature_value
1 genzo_tags_feature_value_lang
1 genzo_tags_feature
1 genzo_tags_feature_lang
1 manufacturer_lang
1 manufacturer_shop
1 genzo_tags
1 genzo_tags_lang
1 genzo_tags_shop
1 genzo_tags_product
1 smarty_last_flush
1 genzo_zar_game_product
1 extraproducttab
1 extraproducttab_lang
1 extraproducttab_product_lang
1 extraproducttab_product
1 carrier
1 carrier_shop

ObjectModel instances

NameInstancesSource
Category 31 /controllers/front/ProductController.php [190]
/override/classes/Link.php [90]
/override/classes/Link.php [103]
/override/classes/Link.php [103]
/override/classes/Link.php [90]
/override/classes/Link.php [103]
/override/classes/Product.php [642]
/override/classes/Product.php [642]
/override/classes/Product.php [642]
/override/classes/Product.php [642]
/override/classes/Link.php [90]
/override/classes/Link.php [103]
/override/classes/Link.php [90]
/override/classes/Link.php [90]
/override/classes/Link.php [90]
/override/classes/Link.php [90]
/override/classes/Link.php [103]
/override/classes/Link.php [103]
/override/classes/Link.php [90]
/override/classes/Link.php [90]
/override/classes/Link.php [103]
/override/classes/Link.php [90]
/override/classes/Link.php [90]
/override/classes/Link.php [103]
/override/classes/Link.php [90]
/override/classes/Link.php [90]
/override/classes/Link.php [103]
/override/classes/Link.php [90]
/override/classes/Link.php [90]
/override/classes/Link.php [103]
/override/classes/Link.php [90]
Product 18 /override/classes/Link.php [22]
/modules/genzo_erp/classes/ProductExtensionErp.php [124]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
/override/classes/Link.php [22]
CMS 6 /classes/Link.php [712]
/classes/Link.php [712]
/classes/Link.php [712]
/classes/Link.php [712]
/classes/Link.php [712]
/classes/Link.php [712]
Address 6 /classes/Product.php [732]
/classes/Product.php [783]
/classes/Product.php [1046]
/controllers/front/ProductController.php [550]
/controllers/front/ProductController.php [580]
/classes/Product.php [1656]
Manufacturer 2 /controllers/front/ProductController.php [323]
/override/classes/Product.php [685]
Language 2 /config/config.inc.php [198]
/classes/Tools.php [449]
ErpModule\ProductExtensionErp 1 /modules/genzo_erp/genzo_erp.php [1032]
Tax 1 /classes/tax/TaxRulesTaxManager.php [137]
Thirtybees\Core\View\Model\ProductViewModel 1 /classes/Product.php [717]
Shop 1 /config/config.inc.php [122]
Theme 1 /config/config.inc.php [123]
Cart 1 /classes/controller/FrontController.php [1487]
Currency 1 /classes/Tools.php [695]
Customer 1 /config/config.inc.php [223]
ShopGroup 1 /classes/shop/Shop.php [542]
Country 1 /config/config.inc.php [144]
Group 1 /classes/Cart.php [284]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines_custom.inc.php
4/config/defines.inc.php
5/config/settings.inc.php
6/config/autoload.php
7/config/alias.php
8/classes/PrestaShopAutoload.php
9/vendor/autoload.php
10/vendor/composer/autoload_real.php
11/vendor/composer/platform_check.php
12/vendor/composer/ClassLoader.php
13/vendor/composer/include_paths.php
14/vendor/composer/autoload_static.php
15/vendor/ralouphie/getallheaders/src/getallheaders.php
16/vendor/symfony/deprecation-contracts/function.php
17/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
18/vendor/guzzlehttp/guzzle/src/functions_include.php
19/vendor/guzzlehttp/guzzle/src/functions.php
20/vendor/jakeasmith/http_build_url/src/http_build_url.php
21/vendor/symfony/polyfill-mbstring/bootstrap.php
22/vendor/symfony/polyfill-mbstring/bootstrap80.php
23/cache/class_index.php
24/config/bootstrap.php
25/classes/core/ServiceLocator.php
26/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
27/classes/error/response/DebugErrorPage.php
28/classes/error/response/AbstractErrorPage.php
29/classes/error/response/ErrorResponseInterface.php
30/classes/error/ErrorHandler.php
31/classes/controller/Controller.php
32/classes/ObjectModel.php
33/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
34/classes/db/Db.php
35/classes/db/ReadOnlyConnection.php
36/classes/Tools.php
37/classes/Context.php
38/classes/shop/Shop.php
39/classes/Configuration.php
40/classes/db/DbQuery.php
41/classes/Validate.php
42/classes/cache/Cache.php
43/Adapter/Adapter_ServiceLocator.php
44/Adapter/Adapter_EntityMapper.php
45/classes/ImageManager.php
46/classes/Theme.php
47/config/defines_uri.inc.php
48/classes/Language.php
49/classes/Country.php
50/classes/PrestaShopCollection.php
51/classes/shop/ShopGroup.php
52/classes/Cookie.php
53/config/smarty.config.inc.php
54/classes/smarty/SmartyCustom.php
55/vendor/smarty/smarty/libs/Smarty.class.php
56/vendor/smarty/smarty/libs/functions.php
57/vendor/smarty/smarty/libs/Autoloader.php
58/vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php
59/vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php
60/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
61/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
62/vendor/smarty/smarty/libs/sysplugins/smarty_resource.php
63/vendor/smarty/smarty/libs/sysplugins/smarty_variable.php
64/vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php
65/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
66/vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php
67/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php
68/classes/Translate.php
69/classes/Customer.php
70/override/classes/Customer.php
71/classes/Group.php
72/classes/Link.php
73/override/classes/Link.php
74/classes/shop/ShopUrl.php
75/classes/Hook.php
76/vendor/mobiledetect/mobiledetectlib/src/MobileDetect.php
77/vendor/mobiledetect/mobiledetectlib/src/Cache/Cache.php
78/vendor/psr/simple-cache/src/CacheInterface.php
79/vendor/mobiledetect/mobiledetectlib/src/Cache/CacheItem.php
80/classes/module/Module.php
81/modules/collectlogs/collectlogs.php
82/modules/collectlogs/classes/Settings.php
83/modules/collectlogs/classes/Severity.php
84/modules/collectlogs/classes/TransformMessage.php
85/modules/collectlogs/classes/TransformMessageImpl.php
86/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php
87/vendor/smarty/smarty/libs/sysplugins/smarty_data.php
88/modules/collectlogs/classes/Logger.php
89/classes/Dispatcher.php
90/override/classes/Dispatcher.php
91/modules/ph_simpleblog/ph_simpleblog.php
92/modules/ph_simpleblog/assets/phpthumb/ThumbLib.inc.php
93/modules/ph_simpleblog/assets/phpthumb/PhpThumb.inc.php
94/modules/ph_simpleblog/assets/phpthumb/ThumbBase.inc.php
95/modules/ph_simpleblog/assets/phpthumb/GdThumb.inc.php
96/modules/ph_simpleblog/models/SimpleBlogHelper.php
97/modules/ph_simpleblog/models/SimpleBlogCategory.php
98/modules/ph_simpleblog/models/SimpleBlogPost.php
99/modules/ph_simpleblog/models/SimpleBlogPostType.php
100/modules/ph_simpleblog/models/SimpleBlogPostImage.php
101/modules/ph_simpleblog/models/SimpleBlogTag.php
102/modules/ph_simpleblog/models/SimpleBlogComment.php
103/modules/ph_simpleblog/models/SimpleBlogAuthor.php
104/themes/genzo_theme/modules/ph_simpleblog/translations/de.php
105/modules/ph_simpleblog/translations/de.php
106/modules/genzo_krona/genzo_krona.php
107/modules/genzo_krona/autoload.php
108/modules/genzo_krona/classes/Action.php
109/modules/genzo_krona/classes/ActionOrder.php
110/modules/genzo_krona/classes/Coupon.php
111/modules/genzo_krona/classes/Group.php
112/modules/genzo_krona/classes/Level.php
113/modules/genzo_krona/classes/Player.php
114/modules/genzo_krona/classes/PlayerHistory.php
115/modules/genzo_krona/classes/PlayerLevel.php
116/themes/genzo_theme/modules/genzo_krona/translations/de.php
117/modules/genzo_krona/translations/de.php
118/modules/revws/revws.php
119/modules/revws/app-translation.php
120/modules/revws/classes/csrf.php
121/modules/revws/classes/csv-reader.php
122/modules/revws/classes/color.php
123/modules/revws/classes/utils.php
124/modules/revws/classes/gdpr/interface.php
125/modules/revws/classes/gdpr/psgdpr.php
126/modules/revws/classes/gdpr/basic.php
127/modules/revws/classes/gdpr/gdpr.php
128/modules/revws/classes/settings.php
129/modules/revws/classes/permissions.php
130/modules/revws/classes/visitor-permissions.php
131/modules/revws/classes/employee-permissions.php
132/modules/revws/classes/no-permissions.php
133/modules/revws/classes/shapes.php
134/modules/revws/classes/visitor.php
135/modules/revws/classes/review-query.php
136/modules/revws/classes/notifications.php
137/modules/revws/classes/actor.php
138/modules/revws/classes/review-list.php
139/modules/revws/classes/front-app.php
140/modules/revws/classes/cron.php
141/modules/revws/classes/backup.php
142/modules/revws/classes/subscription.php
143/modules/revws/classes/email-request.php
144/modules/revws/classes/integration/datakick.php
145/modules/revws/classes/integration/krona.php
146/modules/revws/classes/migration-utils.php
147/modules/revws/classes/platform/platform.php
148/modules/revws/model/criterion.php
149/modules/revws/model/review.php
150/modules/revws/model/email.php
151/themes/genzo_theme/modules/revws/translations/de.php
152/modules/revws/translations/de.php
153/classes/order/OrderState.php
154/modules/genzo_affiliate/genzo_affiliate.php
155/modules/genzo_affiliate/autoload.php
156/modules/genzo_affiliate/classes/CommissionAffiliate.php
157/modules/genzo_affiliate/classes/InteractionAffiliate.php
158/modules/genzo_affiliate/classes/PartnerAffiliate.php
159/themes/genzo_theme/modules/genzo_affiliate/translations/de.php
160/modules/genzo_tags/genzo_tags.php
161/modules/genzo_tags/autoload.php
162/modules/genzo_tags/classes/Feature.php
163/modules/genzo_tags/classes/FeatureValue.php
164/modules/genzo_tags/classes/Synonym.php
165/modules/genzo_tags/classes/Tag.php
166/modules/genzo_tags/classes/TagRule.php
167/modules/genzo_tags/controllers/admin/AdminGenzoTagsController.php
168/classes/controller/ModuleAdminController.php
169/classes/controller/AdminController.php
170/override/classes/controller/AdminController.php
171/themes/genzo_theme/modules/genzo_tags/translations/de.php
172/modules/genzo_filter/genzo_filter.php
173/modules/genzo_erp/autoload.php
174/modules/genzo_search/autoload.php
175/modules/genzo_search/genzo_search.php
176/modules/genzo_search/classes/Result.php
177/modules/genzo_search/classes/SearchQuery.php
178/modules/genzo_search/classes/SearchQueryStat.php
179/modules/genzo_search/classes/Word.php
180/modules/genzo_shipping/autoload.php
181/modules/genzo_shipping/vendor/autoload.php
182/modules/genzo_shipping/vendor/composer/autoload_real.php
183/modules/genzo_shipping/vendor/composer/platform_check.php
184/modules/genzo_shipping/vendor/composer/autoload_static.php
185/modules/genzo_shipping/genzo_shipping.php
186/modules/genzo_shipping/classes/SwissPostApi.php
187/modules/genzo_erp/genzo_erp.php
188/modules/genzo_erp/vendor/autoload.php
189/modules/genzo_erp/vendor/composer/autoload_real.php
190/modules/genzo_erp/vendor/composer/platform_check.php
191/modules/genzo_erp/vendor/composer/autoload_static.php
192/modules/genzo_erp/vendor/symfony/polyfill-ctype/bootstrap.php
193/modules/genzo_erp/vendor/symfony/polyfill-ctype/bootstrap80.php
194/modules/genzo_erp/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
195/modules/genzo_erp/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
196/modules/genzo_erp/vendor/symfony/polyfill-php72/bootstrap.php
197/modules/genzo_erp/vendor/symfony/polyfill-intl-idn/bootstrap.php
198/modules/genzo_erp/classes/CategoryErp.php
199/modules/genzo_erp/classes/CompetitorErp.php
200/modules/genzo_erp/classes/ControlCenterTaskErp.php
201/modules/genzo_erp/classes/CronErp.php
202/modules/genzo_erp/classes/DonationProductErp.php
203/modules/genzo_erp/classes/DonationOrderErp.php
204/modules/genzo_erp/classes/EncodingErp.php
205/modules/genzo_erp/classes/FeatureProductErp.php
206/modules/genzo_erp/classes/FeatureProductValidationErp.php
207/modules/genzo_erp/classes/InventoryErp.php
208/modules/genzo_erp/classes/ManufacturerErp.php
209/modules/genzo_erp/classes/PriceErp.php
210/modules/genzo_erp/classes/PickingListDetailErp.php
211/modules/genzo_erp/classes/PickingListErp.php
212/modules/genzo_erp/classes/ProductBundleErp.php
213/modules/genzo_erp/classes/ProductErp.php
214/modules/genzo_crm/autoload.php
215/modules/genzo_crm/genzo_crm.php
216/modules/genzo_crm/classes/AddressCrm.php
217/modules/genzo_crm/classes/BoughtCartRuleCrm.php
218/modules/genzo_crm/classes/CronCrm.php
219/modules/genzo_crm/classes/CustomerConversionCrm.php
220/modules/genzo_crm/classes/CustomerConversionAggregatedCrm.php
221/modules/genzo_crm/classes/CustomerCrm.php
222/modules/genzo_crm/classes/CustomerDepositTransactionCrm.php
223/modules/genzo_crm/classes/CustomerEmailCrm.php
224/modules/genzo_crm/classes/CustomerEmailSubscriptionCrm.php
225/modules/genzo_crm/classes/CustomerFavouriteCrm.php
226/modules/genzo_crm/classes/CustomerFavouriteProductCrm.php
227/modules/genzo_crm/classes/CustomerJourneyCrm.php
228/modules/genzo_crm/classes/CustomerJourneyStepCrm.php
229/modules/genzo_crm/classes/CustomerLeadCrm.php
230/modules/genzo_crm/classes/CustomerLikeCrm.php
231/modules/genzo_crm/classes/CustomerProductRecommendationCrm.php
232/modules/genzo_crm/classes/CustomerScoreCrm.php
233/modules/genzo_crm/classes/CustomerTagCrm.php
234/modules/genzo_crm/classes/CustomerVoiceMessageCrm.php
235/modules/genzo_crm/classes/EntityStatCrm.php
236/modules/genzo_crm/classes/EmailCrm.php
237/modules/genzo_crm/classes/EmailRuleCrm.php
238/modules/genzo_crm/classes/EmailSubscriptionCrm.php
239/modules/genzo_crm/classes/JourneyCrm.php
240/modules/genzo_crm/classes/JourneyStepCrm.php
241/modules/genzo_crm/classes/OrderCrm.php
242/modules/genzo_crm/classes/PersonCrm.php
243/modules/genzo_crm/classes/PersonIgnoreCrm.php
244/modules/genzo_crm/classes/PreorderDetailCrm.php
245/modules/genzo_crm/classes/ScoreCrm.php
246/modules/genzo_crm/classes/ScoreRuleCrm.php
247/modules/genzo_crm/classes/ShortcodesCrm.php
248/modules/genzo_crm/classes/StageCrm.php
249/modules/genzo_crm/classes/StageRuleCrm.php
250/modules/genzo_crm/classes/SubModules.php
251/modules/genzo_crm/classes/TagCrm.php
252/modules/genzo_crm/classes/TagRuleCrm.php
253/modules/genzo_crm/classes/TagRuleGroupCrm.php
254/modules/genzo_crm/classes/VisitorCrm.php
255/modules/genzo_erp/classes/ProductExtensionErp.php
256/modules/genzo_erp/classes/ProductRelationErp.php
257/modules/genzo_erp/classes/ProductShoppingOfferErp.php
258/modules/genzo_erp/classes/ProductShoppingOfferCompetitorErp.php
259/modules/genzo_erp/classes/ProductSingleErp.php
260/modules/genzo_erp/classes/ShelfErp.php
261/modules/genzo_erp/classes/ShelfTypeErp.php
262/modules/genzo_erp/classes/ShelfTypeTrayErp.php
263/modules/genzo_erp/classes/SoldOutErp.php
264/modules/genzo_erp/classes/SourceErp.php
265/modules/genzo_erp/classes/SourceFetchErp.php
266/modules/genzo_erp/classes/SourceFetchRuleErp.php
267/modules/genzo_erp/classes/SourceProductErp.php
268/modules/genzo_zar/classes/bgg/Client.php
269/modules/genzo_zar/classes/bgg/BGG.php
270/modules/genzo_erp/classes/SourceProductSupplierErp.php
271/modules/genzo_erp/classes/SourceProductImageErp.php
272/modules/genzo_erp/classes/SourceProductHistoryErp.php
273/modules/genzo_erp/classes/SupplierErp.php
274/modules/genzo_erp/classes/WarehouseProductLocationStockErp.php
275/modules/genzo_erp/classes/sources/CarlettoErp.php
276/modules/genzo_erp/classes/sources/HappyshopsErp.php
277/modules/genzo_erp/classes/sources/BlackfireErp.php
278/modules/genzo_erp/classes/sources/MaxBersinger.php
279/modules/genzo_erp/classes/sources/PegasusErp.php
280/modules/genzo_erp/classes/sources/PuzzleMarktErp.php
281/modules/genzo_erp/classes/sources/SomboErp.php
282/modules/genzo_erp/classes/sources/SpielDirektErp.php
283/modules/genzo_erp/classes/sources/FataMorganaErp.php
284/modules/genzo_erp/classes/sources/CarlitRavensburgerErp.php
285/modules/genzo_erp/classes/sources/SwissgamesErp.php
286/modules/genzo_erp/classes/sources/CartaMediaErp.php
287/modules/genzo_erp/classes/sources/BnwDistributionErp.php
288/modules/genzo_erp/classes/sources/UniqueGamingErp.php
289/modules/genzo_erp/classes/sources/HeoErp.php
290/modules/genzo_erp/classes/sources/BoardGameBoxErp.php
291/modules/genzo_erp/classes/sources/WaveErp.php
292/modules/genzo_erp/classes/sources/FrontDepotErp.php
293/modules/genzo_erp/classes/sources/OlafFriese.php
294/modules/genzo_erp/classes/sources/DieSpieler.php
295/modules/genzo_erp/classes/sources/Wog.php
296/modules/genzo_erp/classes/sources/Galaxus.php
297/modules/genzo_erp/classes/sources/Brack.php
298/modules/genzo_erp/classes/sources/Exlibris.php
299/modules/genzo_erp/classes/sources/DasSpiel.php
300/modules/genzo_erp/classes/sources/Funshop.php
301/modules/genzo_erp/classes/sources/Microspot.php
302/modules/genzo_erp/classes/sources/OrellFuessli.php
303/modules/genzo_erp/classes/sources/Manor.php
304/modules/genzo_erp/classes/sources/Spielbude.php
305/modules/genzo_erp/classes/sources/Meinspielzeug.php
306/modules/genzo_erp/classes/sources/Ludonix.php
307/modules/genzo_erp/classes/sources/Jugglux.php
308/modules/genzo_erp/classes/sources/BoardGameRock.php
309/modules/genzo_erp/classes/sources/Spiilegge.php
310/modules/genzo_erp/classes/sources/Asmodee.php
311/modules/genzo_erp/classes/sources/AmazingToys.php
312/modules/genzo_erp/classes/sources/WhiteRabbit.php
313/modules/genzo_erp/classes/tasks/AbstractTask.php
314/modules/genzo_erp/classes/tasks/UpdateGoogleProductId.php
315/modules/genzo_erp/classes/tasks/CheckAddressDuplicates.php
316/modules/genzo_erp/classes/tasks/CheckProductFeatures.php
317/modules/genzo_erp/classes/tasks/CheckProductDimensions.php
318/modules/genzo_erp/classes/tasks/CheckSupplierPrices.php
319/modules/genzo_erp/classes/tasks/CheckProductImages.php
320/modules/genzo_erp/classes/tasks/RelocateWorstsellerProducts.php
321/modules/genzo_erp/classes/tasks/UpdateBggId.php
322/modules/genzo_erp/classes/tasks/UpdateManufacturer.php
323/modules/genzo_erp/classes/tasks/UpdateProductDescription.php
324/modules/genzo_erp/classes/tasks/CheckProductSale.php
325/modules/tb_framework/tb_framework.php
326/modules/tb_framework/controllers/front/FrameworkController.php
327/classes/controller/FrontController.php
328/override/controllers/front/FrontController.php
329/modules/genzo_filter/controllers/front/customproductlist.php
330/classes/controller/ModuleFrontController.php
331/themes/genzo_theme/modules/genzo_filter/translations/de.php
332/classes/SpielezarHelper.php
333/modules/genzo_category/classes/GenzoCategory.php
334/modules/genzo_portal/models/LinkPortal.php
335/modules/genzo_portal/autoload.php
336/modules/genzo_portal/genzo_portal.php
337/modules/genzo_portal/models/CategoryPortal.php
338/modules/genzo_zar/genzo_zar.php
339/modules/genzo_zar/classes/Game.php
340/modules/genzo_zar/classes/Rule.php
341/modules/genzo_zar/classes/Person.php
342/modules/genzo_zar/classes/Characteristic.php
343/modules/genzo_zar/classes/Publisher.php
344/modules/genzo_zar/translations/de.php
345/modules/genzo_events/genzo_events.php
346/modules/genzo_events/autoload.php
347/modules/genzo_events/model/Event.php
348/themes/genzo_theme/modules/genzo_events/translations/de.php
349/modules/genzo_faq/genzo_faq.php
350/modules/genzo_faq/autoload.php
351/modules/genzo_faq/model/Question.php
352/modules/genzo_faq/model/Section.php
353/themes/genzo_theme/modules/genzo_faq/translations/de.php
354/themes/genzo_theme/modules/genzo_portal/translations/de.php
355/modules/genzo_portal/translations/de.php
356/modules/genzo_questions/genzo_questions.php
357/modules/genzo_questions/autoload.php
358/modules/genzo_questions/models/Discussion.php
359/modules/genzo_questions/models/Message.php
360/modules/genzo_questions/controllers/front/discussionboard.php
361/modules/genzo_questions/classes/Question.php
362/modules/genzo_questions/classes/Answer.php
363/themes/genzo_theme/modules/genzo_questions/translations/de.php
364/modules/genzo_questions/translations/de.php
365/modules/genzo_quiz/genzo_quiz.php
366/modules/genzo_quiz/classes/Quiz.php
367/modules/genzo_quiz/classes/Question.php
368/modules/genzo_quiz/classes/Answer.php
369/modules/genzo_quiz/classes/Student.php
370/modules/genzo_quiz/classes/StudentAnswer.php
371/modules/genzo_quiz/classes/Group.php
372/modules/genzo_quiz/classes/CategoryQuiz.php
373/themes/genzo_theme/modules/genzo_quiz/translations/de.php
374/modules/genzo_quiz/translations/de.php
375/modules/genzo_revws/genzo_revws.php
376/themes/genzo_theme/modules/genzo_revws/translations/de.php
377/themes/genzo_theme/modules/genzo_search/translations/de.php
378/themes/genzo_theme/modules/tb_framework/translations/de.php
379/modules/genzo_theme_configurator/genzo_theme_configurator.php
380/themes/genzo_theme/modules/genzo_theme_configurator/translations/de.php
381/themes/genzo_theme/modules/genzo_erp/translations/de.php
382/themes/genzo_theme/modules/genzo_crm/translations/de.php
383/modules/genzo_crm/translations/de.php
384/controllers/front/ProductController.php
385/override/controllers/front/ProductController.php
386/classes/PageCache.php
387/themes/genzo_theme/lang/de.php
388/classes/Currency.php
389/classes/Cart.php
390/override/classes/Cart.php
391/classes/CartRule.php
392/override/classes/CartRule.php
393/classes/Meta.php
394/classes/Product.php
395/classes/core/InitializationCallback.php
396/override/classes/Product.php
397/classes/Pack.php
398/classes/webservice/WebserviceRequest.php
399/classes/ImageEntity.php
400/classes/Category.php
401/classes/view/model/ProductViewModel.php
402/classes/Manufacturer.php
403/override/classes/Manufacturer.php
404/classes/Supplier.php
405/classes/Address.php
406/classes/tax/TaxManagerFactory.php
407/classes/tax/TaxRulesTaxManager.php
408/classes/tax/TaxManagerInterface.php
409/Adapter/Adapter_Configuration.php
410/Core/Business/Core_Business_ConfigurationInterface.php
411/classes/tax/Tax.php
412/classes/tax/TaxCalculator.php
413/classes/Combination.php
414/classes/SpecificPrice.php
415/classes/GroupReduction.php
416/classes/Tag.php
417/classes/stock/StockAvailable.php
418/override/classes/stock/StockAvailable.php
419/classes/Media.php
420/override/classes/Media.php
421/modules/genzo_turnstile/genzo_turnstile.php
422/classes/workqueue/Scheduler.php
423/classes/workqueue/WorkQueueClient.php
424/vendor/jaybizzle/crawler-detect/src/CrawlerDetect.php
425/vendor/jaybizzle/crawler-detect/src/Fixtures/Crawlers.php
426/vendor/jaybizzle/crawler-detect/src/Fixtures/AbstractProvider.php
427/vendor/jaybizzle/crawler-detect/src/Fixtures/Exclusions.php
428/vendor/jaybizzle/crawler-detect/src/Fixtures/Headers.php
429/modules/revws/classes/platform/thirtybees.php
430/modules/revws/classes/platform/ps16.php
431/modules/genzo_shortcodes/genzo_shortcodes.php
432/modules/ph_simpleblog/controllers/front/single.php
433/themes/genzo_theme/modules/genzo_shortcodes/translations/de.php
434/modules/genzo_category/genzo_category.php
435/themes/genzo_theme/modules/genzo_category/translations/de.php
436/modules/genzo_category/translations/de.php
437/modules/genzo_crm/controllers/front/mywishlist.php
438/classes/ProductSupplier.php
439/modules/genzo_accounting/genzo_accounting.php
440/modules/genzo_accounting/autoload.php
441/modules/genzo_accounting/classes/TransactionAcc.php
442/modules/genzo_accounting/classes/TransactionDetailAcc.php
443/classes/pdf/HTMLTemplateBestellung.php
444/classes/pdf/HTMLTemplate.php
445/classes/pdf/HTMLTemplateErsteMahnung.php
446/classes/pdf/HTMLTemplateZweiteMahnung.php
447/classes/pdf/HTMLTemplatePreorderDeliverySlip.php
448/modules/genzo_accounting/vendor/autoload.php
449/modules/genzo_accounting/vendor/composer/autoload_real.php
450/modules/genzo_accounting/vendor/composer/platform_check.php
451/modules/genzo_accounting/vendor/composer/autoload_static.php
452/modules/genzo_accounting/vendor/symfony/polyfill-intl-icu/bootstrap.php
453/modules/genzo_accounting/controllers/admin/AdminGenzoAccountingTransactionsController.php
454/modules/statsmodule/statsmodule.php
455/modules/statsmodule/src/Utils.php
456/modules/statsmodule/src/ProductSalesView.php
457/classes/module/ModuleStats.php
458/themes/genzo_theme/modules/statsmodule/translations/de.php
459/classes/ProductDownload.php
460/classes/Image.php
461/classes/ImageType.php
462/classes/Feature.php
463/classes/FeatureValue.php
464/modules/ph_relatedposts/ph_relatedposts.php
465/modules/ph_relatedposts/models/SimpleBlogRelatedPost.php
466/themes/genzo_theme/modules/ph_relatedposts/translations/de.php
467/modules/ph_relatedposts/translations/de.php
468/modules/extraproducttab/extraproducttab.php
469/themes/genzo_theme/modules/extraproducttab/translations/de.php
470/modules/extraproducttab/translations/de.php
471/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
472/cache/smarty/compile/f1/50/c2/f150c2ebc64a16291797992d3654de7405e1216e_0.file.displayTop.tpl.php
473/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_capture.php
474/cache/smarty/compile/c2/52/74/c2527426c8afad1766c517689525ed4fdba31fe4_0.file.modal_default.tpl.php
475/vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php
476/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
477/cache/smarty/compile/76/51/f0/7651f0cec21497adcdd8f60cd84f57d7e8ca4542_0.file.displayFooter.tpl.php
478/cache/smarty/compile/1e/78/c4/1e78c4296380f086afac9ca8665902ecc2a0687d_0.file.product.tpl.php
479/vendor/smarty/smarty/libs/plugins/function.counter.php
480/vendor/smarty/smarty/libs/plugins/modifier.regex_replace.php
481/vendor/smarty/smarty/libs/plugins/modifier.count.php
482/cache/smarty/compile/4e/d1/d8/4ed1d8ce4900bd5bc865df773b5f9b3ea9f22713_0.file.errors.tpl.php
483/cache/smarty/compile/3c/cc/e4/3ccce4de0fa29b7ebc5639d5e2f5938333439eb3_0.file.product-list-features.tpl.php
484/vendor/smarty/smarty/libs/plugins/modifier.replace.php
485/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php
486/cache/smarty/compile/9a/82/02/9a8202fd5e51aa4f4c82f863a65fb776750e83b6_0.file.fancybox_default.tpl.php
487/cache/smarty/compile/26/d9/08/26d908089361e1fec3e811e21f345f01b366f370_0.file.product_extra_buttons.tpl.php
488/cache/smarty/compile/5c/db/fc/5cdbfc4252b227aa9cf6c7a3bb47e11681e00aca_0.file.feature-table.tpl.php
489/cache/smarty/compile/c4/06/4e/c4064e40d31ca32dbbb27be1357602908aa5edd7_0.file.accordion_default.tpl.php
490/cache/smarty/compile/40/f7/35/40f73546a0c2e4857a917fadfb79bc457f7739d5_0.file.tab_components.tpl.php
491/cache/smarty/compile/09/a9/fd/09a9fdae17c32fddcc706468b06cc109b8e403d1_0.file.buy-block.tpl.php
492/vendor/smarty/smarty/libs/plugins/function.math.php
493/themes/genzo_theme/modules/genzo_shipping/translations/de.php
494/modules/genzo_shipping/translations/de.php
495/cache/smarty/compile/ea/95/9c/ea959c6f57fd791a523e5418bc9aa4f9a083f7e4_0.file.delivery-date.tpl.php
496/vendor/smarty/smarty/libs/plugins/shared.make_timestamp.php
497/cache/smarty/compile/61/5a/8b/615a8bcb12237584227979ae7c831cc871c42c86_0.file.delivery-information.tpl.php
498/cache/smarty/compile/86/14/55/861455eca617874ee298b4e673961a4065043ed2_0.file.popover_default.tpl.php
499/cache/smarty/compile/8e/87/e0/8e87e050377cc21d3b242f59349de7fd45fcbcf8_0.file.invoice-information.tpl.php
500/cache/smarty/compile/94/89/b4/9489b4bb8dcf362518f8676e876b48db3f296670_0.file.card_product.tpl.php
501/cache/smarty/compile/e9/82/87/e982871ebcba2d905083737f91aabd199c0bcce6_0.file.carousel_components.tpl.php
502/classes/Encryptor.php
503/classes/PhpEncryption.php
504/vendor/defuse/php-encryption/src/Key.php
505/vendor/defuse/php-encryption/src/Encoding.php
506/vendor/defuse/php-encryption/src/Core.php
507/vendor/defuse/php-encryption/src/Crypto.php
508/vendor/defuse/php-encryption/src/KeyOrPassword.php
509/vendor/defuse/php-encryption/src/RuntimeTests.php
510/vendor/defuse/php-encryption/src/DerivedKeys.php
511/vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
512/vendor/defuse/php-encryption/src/Exception/CryptoException.php
513/cache/smarty/compile/55/32/2e/55322e7a17ee494cd0212d131fecbde91e067ee0_0.file.layout.tpl.php
514/cache/smarty/compile/e5/5d/05/e55d05f74ca4856c7811c5ae74f0ef3e80e75707_0.file.schema-markup.tpl.php
515/cache/smarty/compile/fb/18/1d/fb181dd400fe5a438a2fa15ce831f973c3aa3922_0.file.header.tpl.php
516/cache/smarty/compile/2e/0a/ee/2e0aeeb9d29bfb93fb71cd4581b3967602c5e1b1_0.file.menu-desktop.tpl.php
517/cache/smarty/compile/84/41/81/844181fcdce7bf7d70a3c859c8327a19df8f48ee_0.file.menu-desktop-login.tpl.php
518/cache/smarty/compile/cc/56/9a/cc569a31452fb1acd8e9f0837ec704bb66850e85_0.file.menu.tpl.php
519/cache/smarty/compile/6d/0b/a4/6d0ba4c53653e049deb1a966c94f65e4840d1c8b_0.file.breadcrumb.tpl.php
520/cache/smarty/compile/26/a5/5f/26a55f3985ced2079a9599799457d1e8c0d7eb62_0.file.displayBottomColumn.tpl.php
521/cache/smarty/compile/41/ab/58/41ab5806c3ea8d4e3d839a5aba7fdc9e9151b845_0.file.footer.tpl.php
522/classes/CMS.php
523/classes/CMSCategory.php
524/cache/smarty/compile/87/b1/50/87b1504746fa62e0740c2ac3000b3acfb52fa3ae_0.file.global_js_helper.tpl.php
525/cache/smarty/compile/04/ae/8b/04ae8bf577a7b559218db9697f9892266bd37b0f_0.file.menu-mobile.tpl.php
526/cache/smarty/compile/39/c1/65/39c16590ac5d95b184c7899d5fc1e81114825343_0.file.javascript.tpl.php
527/vendor/smarty/smarty/libs/plugins/shared.mb_str_replace.php