1 (0.154)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://hyperkeys.sk/'
/data/web/virtuals/126558/virtual/www/index.php:61
2 (4.319)
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.226)
SELECT *
FROM `oc_language`
WHERE status = '1'
/data/web/virtuals/126558/virtual/www/index.php:185
4 (0.216)
SELECT *
FROM oc_currency
/data/web/virtuals/126558/virtual/www/system/library/currency.php:13
5 (0.153)
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.128)
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.184)
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.152)
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.604)
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.183)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/data/web/virtuals/126558/virtual/www/system/library/openbay.php:117
11 (0.131)
SELECT *
FROM oc_event
/data/web/virtuals/126558/virtual/www/index.php:286
12 (0.202)
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 (0.362)
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 (0.719)
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.262)
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.454)
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.507)
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.138)
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.126)
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.127)
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.550)
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.084)
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 (1.317)
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 (1.809)
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.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
26 (0.164)
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.132)
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.128)
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.169)
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.416)
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.150)
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.191)
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.260)
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 (2.469)
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.580)
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.488)
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.151)
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.122)
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 (2.017)
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 = '149' 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.807)
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.202)
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.178)
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.158)
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
44 (12.149)
SELECT
*
FROM
oc_url_alias
WHERE
smp_language_id IS NULL OR smp_language_id = 2
ORDER BY smp_language_id ASC
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_controller_common_seo_mega_pack_pro_url.php:1204
45 (8.157)
SELECT
*
FROM
oc_url_alias
WHERE
smp_language_id IS NULL OR smp_language_id = 2
ORDER BY smp_language_id ASC
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_controller_common_seo_mega_pack_pro_url.php:1204
46 (17.103)
SELECT
*
FROM
oc_url_alias
WHERE
smp_language_id IS NULL OR smp_language_id = 2
ORDER BY smp_language_id ASC
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_controller_common_seo_mega_pack_pro_url.php:1204
47 (1.980)
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
48 (0.459)
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
49 (0.431)
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
50 (0.690)
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
51 (0.155)
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
52 (1.046)
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
53 (9.040)
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
54 (11.339)
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
55 (6.206)
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
56 (2.694)
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
57 (0.167)
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
58 (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 = '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
59 (7.000)
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
60 (6.979)
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
61 (5.125)
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
62 (3.358)
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
63 (1.743)
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
64 (0.847)
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
65 (0.887)
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
66 (0.180)
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
67 (0.186)
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
68 (0.156)
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
69 (0.151)
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
70 (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 = '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
71 (0.191)
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
72 (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 = '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
73 (0.145)
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
74 (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 = '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
75 (0.154)
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
76 (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 = '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
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 = '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
78 (0.131)
SELECT *
FROM oc_module
WHERE module_id = '35'
/data/web/virtuals/126558/virtual/www/catalog/model/extension/module.php:4
79 (0.191)
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
80 (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
81 (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
82 (0.167)
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
83 (0.133)
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
84 (0.132)
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
85 (0.207)
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
86 (0.215)
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
87 (0.184)
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
88 (0.307)
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
89 (0.141)
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
90 (0.298)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
91 (0.144)
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
92 (0.477)
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
93 (0.141)
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
94 (0.167)
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
95 (3.269)
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
96 (0.568)
SELECT date_end
FROM oc_product_special
WHERE product_id='289'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
97 (0.178)
SELECT date_end
FROM oc_product_special
WHERE product_id='78'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
98 (0.141)
SELECT date_end
FROM oc_product_special
WHERE product_id='663'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
99 (0.139)
SELECT date_end
FROM oc_product_special
WHERE product_id='814'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
100 (0.138)
SELECT date_end
FROM oc_product_special
WHERE product_id='162'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
101 (0.137)
SELECT date_end
FROM oc_product_special
WHERE product_id='930'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
102 (0.138)
SELECT date_end
FROM oc_product_special
WHERE product_id='1150'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
103 (0.140)
SELECT date_end
FROM oc_product_special
WHERE product_id='1202'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
104 (0.140)
SELECT date_end
FROM oc_product_special
WHERE product_id='1238'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
105 (0.141)
SELECT date_end
FROM oc_product_special
WHERE product_id='1305'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
106 (0.139)
SELECT date_end
FROM oc_product_special
WHERE product_id='1320'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
107 (0.136)
SELECT date_end
FROM oc_product_special
WHERE product_id='213'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
108 (0.766)
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
109 (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
110 (1.923)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
111 (0.535)
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
112 (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
113 (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
114 (0.254)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
115 (0.124)
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
116 (0.133)
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
117 (0.156)
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
118 (0.234)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
119 (0.721)
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
120 (0.252)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'SignUpCoupons'
/data/web/virtuals/126558/virtual/www/catalog/model/setting/setting.php:6
121 (0.151)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
122 (0.843)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '20ec1369563b7052525c22bcec8f94a4'
/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122
123 (0.165)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
124 (0.150)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '20ec1369563b7052525c22bcec8f94a4'
/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122
125 (0.186)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/data/web/virtuals/126558/virtual/www/system/library/customer.php:129
126 (0.185)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '20ec1369563b7052525c22bcec8f94a4'
/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122
127 (0.176)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '20ec1369563b7052525c22bcec8f94a4'
/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122
128 (0.151)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '20ec1369563b7052525c22bcec8f94a4'
/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122
129 (0.155)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
130 (0.140)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '20ec1369563b7052525c22bcec8f94a4'
/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122
131 (0.143)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/data/web/virtuals/126558/virtual/www/system/library/customer.php:129
132 (0.137)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '20ec1369563b7052525c22bcec8f94a4'
/data/web/virtuals/126558/virtual/www/system/storage/modification/system/library/cart.php:122
133 (0.205)
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
134 (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
135 (0.540)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
136 (0.304)
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
137 (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
138 (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
139 (0.236)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
140 (0.187)
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
141 (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
142 (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
143 (0.237)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
144 (0.132)
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
145 (0.151)
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
146 (0.126)
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
147 (0.267)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
148 (0.125)
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
149 (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
150 (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
151 (0.285)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
152 (0.130)
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
153 (0.278)
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
154 (0.167)
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
155 (0.153)
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
156 (0.130)
SELECT *
FROM oc_mega_menu_links
WHERE id = 12
/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543
157 (0.186)
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
158 (0.128)
SELECT *
FROM oc_mega_menu_links
WHERE id = 14
/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543
159 (0.134)
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
160 (0.128)
SELECT *
FROM oc_mega_menu_links
WHERE id = 16
/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543
161 (0.165)
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
162 (0.125)
SELECT *
FROM oc_mega_menu_links
WHERE id = 13
/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543
163 (0.134)
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
164 (0.122)
SELECT *
FROM oc_mega_menu_links
WHERE id = 17
/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543
165 (0.138)
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
166 (0.127)
SELECT *
FROM oc_mega_menu_links
WHERE id = 15
/data/web/virtuals/126558/virtual/www/catalog/model/menu/megamenu.php:543
167 (4.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 = '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
168 (0.151)
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
169 (0.197)
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
170 (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 = '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
171 (0.183)
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
172 (0.218)
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
173 (0.178)
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
174 (0.179)
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
175 (0.178)
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
176 (0.173)
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
177 (0.217)
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
178 (0.169)
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
179 (0.174)
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
180 (1.680)
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
181 (0.151)
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
182 (0.175)
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
183 (0.151)
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
184 (0.152)
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
185 (0.145)
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
186 (0.172)
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
187 (0.157)
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
188 (0.291)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
189 (0.130)
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
190 (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
191 (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
192 (0.625)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
193 (0.134)
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
194 (0.198)
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
195 (0.512)
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
196 (0.276)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
197 (0.170)
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
198 (0.841)
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
199 (0.132)
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
200 (0.254)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
201 (0.124)
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
202 (0.134)
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
203 (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
204 (0.253)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
205 (0.126)
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
206 (0.133)
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
207 (0.156)
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
208 (0.252)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
209 (0.132)
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
210 (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
211 (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
212 (0.259)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
213 (0.175)
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
214 (1.833)
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
215 (5.658)
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
216 (13.672)
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
217 (6.114)
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
218 (4.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 = '96'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php:929
219 (0.335)
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
220 (0.215)
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
221 (9.441)
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
222 (16.910)
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
223 (9.802)
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
224 (2.649)
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
225 (1.747)
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
226 (0.762)
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
227 (0.905)
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
228 (0.376)
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
229 (0.154)
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
230 (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 = '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
231 (0.156)
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
232 (0.134)
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
233 (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 = '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
234 (0.169)
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
235 (0.857)
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
236 (0.156)
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
237 (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 = '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
238 (0.142)
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
239 (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 = '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
240 (0.148)
SELECT *
FROM oc_module
WHERE module_id = '35'
/data/web/virtuals/126558/virtual/www/catalog/model/extension/module.php:4
241 (0.166)
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
242 (0.145)
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
243 (0.281)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
244 (0.132)
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
245 (0.133)
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
246 (0.148)
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
247 (0.255)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
248 (0.125)
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
249 (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
250 (0.155)
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
251 (0.272)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
252 (0.132)
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
253 (0.229)
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
254 (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
255 (0.244)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
256 (0.127)
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
257 (0.366)
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
258 (0.131)
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
259 (0.292)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
260 (0.132)
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
261 (0.133)
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
262 (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
263 (0.250)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
264 (1.841)
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
265 (0.133)
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
266 (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
267 (0.245)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
268 (0.128)
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
269 (0.149)
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
270 (0.121)
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
271 (0.447)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
272 (0.125)
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
273 (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
274 (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
275 (0.394)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
276 (0.126)
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
277 (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
278 (0.121)
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
279 (0.243)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
280 (0.148)
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
281 (0.130)
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
282 (1.990)
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
283 (0.387)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
284 (0.160)
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
285 (0.229)
SELECT date_end
FROM oc_product_special
WHERE product_id='78'
/data/web/virtuals/126558/virtual/www/system/library/themeoptions.php:115
286 (0.193)
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
287 (0.389)
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
288 (0.904)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/data/web/virtuals/126558/virtual/www/vqmod/vqcache/vq2-catalog_model_extension_extension.php:17
289 (0.160)
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
Platforma
Žáner
Ako aktivovať hru?
Hra zadarmo
Darčekové poukazy
Kontakt
Zasielame len digitálny kľúč, ktorým si vieš hru aktivovať. Digitálny kľúč zasielame emailom vo väčšine prípadov do niekoľkých minút. Nezasielame hry na fyzických digitálnych nosičoch (CD, DVD...).
Ku každej objednávke dostaneš náhodnú Steam hru zadarmo.
