The Witcher 3: Wild Hunt pre GOG.com / PC

1 (0.247)

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://hyperkeys.sk/'

/data/web/virtuals/126558/virtual/www/index.php:61

2 (5.788)

SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

/data/web/virtuals/126558/virtual/www/index.php:73

3 (0.210)

SELECT *
FROM `oc_language`
WHERE status = '1'

/data/web/virtuals/126558/virtual/www/index.php:185

4 (0.197)

SELECT *
FROM oc_currency

/data/web/virtuals/126558/virtual/www/system/library/currency.php:13

5 (0.174)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '189' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC

/data/web/virtuals/126558/virtual/www/system/library/tax.php:26

6 (0.130)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '189' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC

/data/web/virtuals/126558/virtual/www/system/library/tax.php:54

7 (0.455)

SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'

/data/web/virtuals/126558/virtual/www/system/library/weight.php:9

8 (0.151)

SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'

/data/web/virtuals/126558/virtual/www/system/library/length.php:9

9 (0.457)

DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)

/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:14

10 (0.186)

SELECT *
FROM oc_extension
WHERE `type` = 'openbay'

/data/web/virtuals/126558/virtual/www/system/library/openbay.php:117

11 (0.130)

SELECT *
FROM oc_event

/data/web/virtuals/126558/virtual/www/index.php:286

12 (0.239)

SELECT *
FROM `oc_language`
WHERE code ='sk_SK' LIMIT 1

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_controller_common_seo_mega_pack_pro_url.php:131

13 (1.579)

SELECT new_link
FROM oc_redirects_smp
WHERE broken_link LIKE 'https://www.hyperkeys.sk/the-witcher-3-wild-hunt/' OR broken_link LIKE '/the-witcher-3-wild-hunt/' OR broken_link LIKE 'https://www.hyperkeys.sk/the-witcher-3-wild-hunt/' OR broken_link LIKE '/the-witcher-3-wild-hunt/' OR broken_link LIKE 'https://www.hyperkeys.sk/the-witcher-3-wild-hunt/' OR broken_link LIKE '/the-witcher-3-wild-hunt/' OR broken_link LIKE 'https://www.hyperkeys.sk/the-witcher-3-wild-hunt/' OR broken_link LIKE '/the-witcher-3-wild-hunt/' LIMIT 1

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_controller_common_seo_mega_pack_pro_url.php:595

14 (1.351)

SELECT *
FROM oc_url_alias
WHERE keyword = 'the-witcher-3-wild-hunt'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_controller_common_seo_mega_pack_pro_url.php:338

15 (0.350)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

16 (2.201)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '106' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:115

17 (0.427)

SELECT *
FROM oc_simple_reward sr
LEFT JOIN oc_simple_reward_to_store sr2s ON (sr.simple_reward_id = sr2s.simple_reward_id)
WHERE sr.status = TRUE AND ((sr.date_start = '0000-00-00' OR sr.date_start < NOW()) AND (sr.date_end = '0000-00-00' OR sr.date_end > NOW())) AND sr2s.store_id = '0'
ORDER BY sr.simple_reward_id ASC

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:13

18 (0.160)

SELECT *
FROM oc_simple_reward
WHERE simple_reward_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:4

19 (0.139)

SELECT *
FROM oc_simple_reward_value
WHERE simple_reward_id = '1' AND customer_group_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:19

20 (0.153)

SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id ='9' AND ss.language_id = '2'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:128

21 (0.443)

SELECT *
FROM oc_product_discount
WHERE product_id = '106' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:691

22 (1.650)

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '106' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:541

23 (2.076)

SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '106' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:776

24 (2.311)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '53' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:115

25 (0.617)

SELECT *
FROM oc_simple_reward sr
LEFT JOIN oc_simple_reward_to_store sr2s ON (sr.simple_reward_id = sr2s.simple_reward_id)
WHERE sr.status = TRUE AND ((sr.date_start = '0000-00-00' OR sr.date_start < NOW()) AND (sr.date_end = '0000-00-00' OR sr.date_end > NOW())) AND sr2s.store_id = '0'
ORDER BY sr.simple_reward_id ASC

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:13

26 (0.204)

SELECT *
FROM oc_simple_reward
WHERE simple_reward_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:4

27 (0.156)

SELECT *
FROM oc_simple_reward_value
WHERE simple_reward_id = '1' AND customer_group_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:19

28 (0.145)

SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id ='9' AND ss.language_id = '2'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:128

29 (2.813)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '88' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:115

30 (0.597)

SELECT *
FROM oc_simple_reward sr
LEFT JOIN oc_simple_reward_to_store sr2s ON (sr.simple_reward_id = sr2s.simple_reward_id)
WHERE sr.status = TRUE AND ((sr.date_start = '0000-00-00' OR sr.date_start < NOW()) AND (sr.date_end = '0000-00-00' OR sr.date_end > NOW())) AND sr2s.store_id = '0'
ORDER BY sr.simple_reward_id ASC

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:13

31 (0.511)

SELECT *
FROM oc_simple_reward
WHERE simple_reward_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:4

32 (0.235)

SELECT *
FROM oc_simple_reward_value
WHERE simple_reward_id = '1' AND customer_group_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:19

33 (0.297)

SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id ='5' AND ss.language_id = '2'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:128

34 (1.916)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '112' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:115

35 (0.389)

SELECT *
FROM oc_simple_reward sr
LEFT JOIN oc_simple_reward_to_store sr2s ON (sr.simple_reward_id = sr2s.simple_reward_id)
WHERE sr.status = TRUE AND ((sr.date_start = '0000-00-00' OR sr.date_start < NOW()) AND (sr.date_end = '0000-00-00' OR sr.date_end > NOW())) AND sr2s.store_id = '0'
ORDER BY sr.simple_reward_id ASC

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:13

36 (0.169)

SELECT *
FROM oc_simple_reward
WHERE simple_reward_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:4

37 (0.140)

SELECT *
FROM oc_simple_reward_value
WHERE simple_reward_id = '1' AND customer_group_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:19

38 (0.134)

SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id ='5' AND ss.language_id = '2'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:128

39 (3.233)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '143' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:115

40 (0.744)

SELECT *
FROM oc_simple_reward sr
LEFT JOIN oc_simple_reward_to_store sr2s ON (sr.simple_reward_id = sr2s.simple_reward_id)
WHERE sr.status = TRUE AND ((sr.date_start = '0000-00-00' OR sr.date_start < NOW()) AND (sr.date_end = '0000-00-00' OR sr.date_end > NOW())) AND sr2s.store_id = '0'
ORDER BY sr.simple_reward_id ASC

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:13

41 (0.176)

SELECT *
FROM oc_simple_reward
WHERE simple_reward_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:4

42 (0.142)

SELECT *
FROM oc_simple_reward_value
WHERE simple_reward_id = '1' AND customer_group_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:19

43 (0.126)

SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id ='10' AND ss.language_id = '2'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:128

44 (1.935)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '158' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:115

45 (0.395)

SELECT *
FROM oc_simple_reward sr
LEFT JOIN oc_simple_reward_to_store sr2s ON (sr.simple_reward_id = sr2s.simple_reward_id)
WHERE sr.status = TRUE AND ((sr.date_start = '0000-00-00' OR sr.date_start < NOW()) AND (sr.date_end = '0000-00-00' OR sr.date_end > NOW())) AND sr2s.store_id = '0'
ORDER BY sr.simple_reward_id ASC

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:13

46 (0.517)

SELECT *
FROM oc_simple_reward
WHERE simple_reward_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:4

47 (0.141)

SELECT *
FROM oc_simple_reward_value
WHERE simple_reward_id = '1' AND customer_group_id = '1'

/data/web/virtuals/126558/virtual/www/catalog/model/catalog/simple_reward.php:19

48 (0.480)

SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id ='9' AND ss.language_id = '2'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:128

49 (0.478)

SELECT `pd`.*
FROM `oc_product_recurring` `pp` JOIN `oc_recurring_description` `pd` ON `pd`.`language_id` = 2 AND `pd`.`recurring_id` = `pp`.`recurring_id` JOIN `oc_recurring` `p` ON `p`.`recurring_id` = `pd`.`recurring_id`
WHERE `product_id` = 106 AND `status` = 1 AND `customer_group_id` = 1
ORDER BY `sort_order` ASC

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:939

50 (0.400)

UPDATE oc_product SET viewed = (viewed + 1), viewed_week = (viewed_week + 1)
WHERE product_id = '106'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:5

51 (0.382)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

52 (0.151)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

53 (0.149)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

54 (1.502)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '99'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

55 (10.983)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '89'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

56 (31.127)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '59'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

57 (4.948)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '90'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

58 (5.061)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '96'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

59 (0.209)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

60 (0.323)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

61 (6.851)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '91'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

62 (8.471)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '94'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

63 (6.612)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '93'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

64 (2.211)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '95'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

65 (3.179)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '92'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

66 (0.676)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '98'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

67 (0.886)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '100'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

68 (0.165)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '99' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

69 (0.143)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '89' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

70 (0.161)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

71 (0.133)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '90' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

72 (0.133)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

73 (0.149)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

74 (0.133)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '94' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

75 (0.139)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '93' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

76 (0.135)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

77 (0.144)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '92' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

78 (0.137)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '98' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

79 (0.158)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

80 (0.119)

SELECT *
FROM oc_module
WHERE module_id = '35'

/data/web/virtuals/126558/virtual/www/catalog/model/extension/module.php:4

81 (0.202)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

82 (0.137)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

83 (0.157)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

84 (0.179)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

85 (0.153)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

86 (0.152)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

87 (1.242)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

88 (0.222)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

89 (0.319)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

90 (0.239)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

91 (0.134)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

92 (2.710)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

93 (0.790)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'customfooter_top'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

94 (0.429)

SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '106' AND `store_id` = '0'

/data/web/virtuals/126558/virtual/www/system/library/mfilter_core.php:1

95 (1.830)

SELECT *
FROM `oc_layout_route`
WHERE 'product/product' LIKE `route` AND `store_id` = '0'
ORDER BY `route` DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/system/library/mfilter_core.php:1

96 (0.136)

SELECT *
FROM `oc_layout_module`
WHERE `layout_id` = '2' AND `code` LIKE 'mega_filter%'
ORDER BY `sort_order`

/data/web/virtuals/126558/virtual/www/system/library/mfilter_core.php:1

97 (3.896)

SELECT *
FROM(SELECT DISTINCT ps.product_id, (SELECT AVG(rating)
FROM oc_review r1
WHERE r1.product_id = ps.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id`
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY LCASE(pd.name) ASC, LCASE(pd.name) ASC) AS `tmp` LIMIT 0,12

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:441

98 (0.584)

SELECT date_end
FROM oc_product_special
WHERE product_id='161'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

99 (0.180)

SELECT date_end
FROM oc_product_special
WHERE product_id='94'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

100 (0.192)

SELECT date_end
FROM oc_product_special
WHERE product_id='394'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

101 (0.156)

SELECT date_end
FROM oc_product_special
WHERE product_id='69'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

102 (0.141)

SELECT date_end
FROM oc_product_special
WHERE product_id='403'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

103 (0.143)

SELECT date_end
FROM oc_product_special
WHERE product_id='116'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

104 (0.145)

SELECT date_end
FROM oc_product_special
WHERE product_id='477'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

105 (0.153)

SELECT date_end
FROM oc_product_special
WHERE product_id='490'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

106 (0.159)

SELECT date_end
FROM oc_product_special
WHERE product_id='505'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

107 (0.148)

SELECT date_end
FROM oc_product_special
WHERE product_id='663'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

108 (0.139)

SELECT date_end
FROM oc_product_special
WHERE product_id='669'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

109 (0.167)

SELECT date_end
FROM oc_product_special
WHERE product_id='122'

/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115

110 (2.600)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

111 (0.144)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

112 (0.290)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

113 (0.136)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'customfooter_bottom'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

114 (0.140)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

115 (0.128)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

116 (0.270)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

117 (0.129)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'customfooter'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

118 (0.163)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

119 (0.129)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

120 (0.273)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

121 (0.128)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'footer'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

122 (0.238)

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'SignUpCoupons'

/data/web/virtuals/126558/virtual/www/catalog/model/setting/setting.php:6

123 (0.212)

SELECT *
FROM oc_extension
WHERE `type` = 'analytics'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

124 (0.747)

SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '0cea67e1d4ca0102eac86891d44db02f'

/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122

125 (0.169)

SELECT *
FROM oc_extension
WHERE `type` = 'total'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

126 (0.151)

SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '0cea67e1d4ca0102eac86891d44db02f'

/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122

127 (0.198)

SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'

/data/web/virtuals/126558/virtual/www/system/library/customer.php:129

128 (0.174)

SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '0cea67e1d4ca0102eac86891d44db02f'

/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122

129 (0.162)

SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '0cea67e1d4ca0102eac86891d44db02f'

/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122

130 (0.147)

SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '0cea67e1d4ca0102eac86891d44db02f'

/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122

131 (0.163)

SELECT *
FROM oc_extension
WHERE `type` = 'total'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

132 (0.139)

SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '0cea67e1d4ca0102eac86891d44db02f'

/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122

133 (0.153)

SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'

/data/web/virtuals/126558/virtual/www/system/library/customer.php:129

134 (0.123)

SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '0cea67e1d4ca0102eac86891d44db02f'

/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122

135 (0.224)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

136 (0.151)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

137 (0.274)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

138 (0.150)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'popup'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

139 (0.136)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

140 (0.129)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

141 (0.233)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

142 (0.131)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'header_notice'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

143 (0.150)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

144 (0.127)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

145 (0.245)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

146 (0.150)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'cookie'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

147 (0.509)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

148 (0.127)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

149 (0.278)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

150 (0.132)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'top_block'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

151 (0.143)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

152 (0.146)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

153 (0.252)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

154 (0.151)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'menu'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

155 (0.253)

SELECT *
FROM oc_mega_menu
WHERE parent_id='0' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:12

156 (0.178)

SELECT *
FROM oc_mega_menu
WHERE parent_id='11' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:76

157 (0.161)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '12' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

158 (0.136)

SELECT *
FROM oc_mega_menu_links
WHERE id = 12

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543

159 (0.144)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

160 (0.136)

SELECT *
FROM oc_mega_menu_links
WHERE id = 14

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543

161 (0.142)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '16' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

162 (0.127)

SELECT *
FROM oc_mega_menu_links
WHERE id = 16

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543

163 (0.142)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '13' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

164 (0.135)

SELECT *
FROM oc_mega_menu_links
WHERE id = 13

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543

165 (0.140)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '17' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

166 (0.127)

SELECT *
FROM oc_mega_menu_links
WHERE id = 17

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543

167 (0.141)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '15' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

168 (0.128)

SELECT *
FROM oc_mega_menu_links
WHERE id = 15

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543

169 (1.314)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:115

170 (0.177)

SELECT *
FROM oc_mega_menu
WHERE parent_id='14' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:76

171 (0.178)

SELECT *
FROM oc_mega_menu
WHERE parent_id='15' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:76

172 (0.184)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '99' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

173 (0.200)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '89' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

174 (0.200)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

175 (0.170)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '90' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

176 (0.170)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '96' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

177 (0.198)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

178 (0.171)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '94' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

179 (0.185)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '93' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

180 (0.828)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

181 (0.198)

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '92' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:4

182 (1.631)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:115

183 (0.171)

SELECT *
FROM oc_mega_menu
WHERE parent_id='16' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:76

184 (0.148)

SELECT *
FROM oc_mega_menu
WHERE parent_id='18' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:76

185 (0.162)

SELECT *
FROM oc_mega_menu
WHERE parent_id='20' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:76

186 (0.173)

SELECT *
FROM oc_mega_menu
WHERE parent_id='23' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:76

187 (0.165)

SELECT *
FROM oc_mega_menu
WHERE parent_id='24' AND status='0' AND module_id='0'
ORDER BY rang

/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:76

188 (0.171)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

189 (0.146)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

190 (0.232)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

191 (0.133)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'menu2'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

192 (0.508)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

193 (0.147)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

194 (0.264)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

195 (0.149)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'slideshow'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

196 (0.225)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

197 (0.128)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

198 (0.313)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

199 (0.127)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'breadcrumb'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

200 (0.140)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

201 (0.125)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

202 (0.272)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

203 (0.145)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'preface_left'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

204 (0.139)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

205 (0.125)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

206 (0.277)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

207 (0.148)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'preface_right'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

208 (0.137)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

209 (0.168)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

210 (0.256)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

211 (0.124)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'preface_fullwidth'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

212 (0.274)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

213 (0.175)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

214 (0.267)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

215 (0.493)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

216 (1.096)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '99'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

217 (6.162)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '89'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

218 (29.540)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '59'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

219 (3.832)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '90'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

220 (3.197)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '96'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

221 (0.168)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

222 (0.157)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

223 (5.129)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '91'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

224 (6.698)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '94'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

225 (5.470)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '93'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

226 (2.749)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '95'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

227 (2.464)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '92'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

228 (0.715)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '98'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

229 (0.884)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '100'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929

230 (0.182)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '99' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

231 (0.136)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '89' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

232 (1.114)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

233 (0.159)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '90' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

234 (0.150)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

235 (0.130)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

236 (0.128)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '94' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

237 (0.152)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '93' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

238 (0.148)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

239 (0.132)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '92' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

240 (0.130)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '98' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

241 (0.170)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

/data/web/virtuals/126558/virtual/www/system/storage/modification/catalog/model/catalog/category.php:10

242 (0.121)

SELECT *
FROM oc_module
WHERE module_id = '35'

/data/web/virtuals/126558/virtual/www/catalog/model/extension/module.php:4

243 (0.175)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

244 (0.130)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

245 (0.289)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

246 (0.133)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_big_column'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

247 (0.156)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

248 (0.120)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

249 (0.252)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

250 (0.126)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

251 (0.136)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

252 (0.119)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

253 (0.269)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

254 (0.128)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

255 (0.146)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

256 (0.120)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

257 (2.855)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

258 (0.291)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'product_custom_block'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

259 (0.137)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

260 (0.123)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

261 (0.262)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

262 (0.129)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'product_image_top'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

263 (0.132)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

264 (0.120)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

265 (0.252)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

266 (0.123)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'product_image_bottom'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

267 (3.132)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

268 (0.128)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

269 (0.275)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

270 (0.127)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'product_options_center'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

271 (0.185)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

272 (0.139)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

273 (0.291)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

274 (0.133)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'product_enquiry'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

275 (0.131)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

276 (0.122)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

277 (0.272)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

278 (0.430)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'product_question'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

279 (0.132)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

280 (0.144)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

281 (0.252)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

282 (0.136)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'product_options_bottom'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

283 (0.150)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

284 (0.123)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

285 (0.249)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

286 (0.132)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'product_over_tabs'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

287 (0.171)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '106' AND store_id = '0'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:800

288 (0.125)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:4

289 (0.271)

SELECT *
FROM oc_extension
WHERE `type` = 'module'

/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17

290 (0.124)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order

/data/web/virtuals/126558/virtual/www/catalog/model/design/layout.php:14

LEN digitálna distribúcia + DARČEK

Napísať hodnotenie

U nás môžete platiť

Rýchlosť doručenia

Hra zadarmo

Zákaznícka podpora

4INTERNET, s.r.o.
KVP 1
040 23 Košice

O spoločnosti

Všetko o nákupe

Spojte sa s nami

The Witcher 3: Wild Hunt pre GOG.com / PC

LEN digitálna distribúcia + DARČEK

Napísať hodnotenie

U nás môžete platiť

Rýchlosť doručenia

Hra zadarmo

Zákaznícka podpora

4INTERNET, s.r.o. KVP 1 040 23 Košice

O spoločnosti

Všetko o nákupe

Spojte sa s nami

4INTERNET, s.r.o.
KVP 1
040 23 Košice