Carti scrise de autor(i) GERARD DE VILLIERS

TRADARE IN CIA

Stoc limitat
ULTIMUL CONTRACT

Stoc limitat
UN SFARSIT FARA GLORIE

Stoc limitat
VADUVA AIATOLAHULUI

Stoc limitat
VADUVELE DIN HONG KONG

Stoc limitat
VIESPAR IN ANGOLA

Stoc limitat
VRAJITORII DIN LISABONA

Stoc limitat
ZBORUL 007 NU MAI RASPUNDE

Stoc limitat
ADIO ZAIR, ADIO MOBUTU

Stoc epuizat
AFACEREA CARINA

Stoc epuizat
AFACEREA IRANGATE REVINE!

Stoc epuizat
AFACEREA KARINA A SAS

Stoc epuizat
AFACEREA KIRSANOV

Stoc epuizat
AGENDA KOSOVO SAS

Stoc epuizat
AL-QAIDA ATACA! VOL 2

Stoc epuizat
Afişare 121 - 135 din 288 (20 pagini)
Queries: 163, Total time: 1,871.139 ms [By time] [By id] [By file]
1 (0.537)
SELECT `data`
FROM `oc_session`
WHERE session_id = '1abaabcf13341f24becb1e6d1b' AND expire > 1713057335
/var/www/clients/client1/web1/web/system/library/session/db.php:41
2 (0.479)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'f8166ea550d7cd8e3f4bf76084' AND expire > 1713057335
/var/www/clients/client1/web1/web/system/library/session/db.php:41
3 (0.409)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://anticariat-ursu.ro/'
/var/www/clients/client1/web1/web/catalog/controller/startup/startup.php:6
4 (3.227)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/clients/client1/web1/web/catalog/controller/startup/startup.php:25
5 (0.440)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/storage/modification/system/library/cart/currency.php:10
6 (0.825)
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 = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2703')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/cart/tax.php:30
7 (0.871)
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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2703')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/cart/tax.php:44
8 (0.566)
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'
/var/www/clients/client1/web1/web/system/library/cart/weight.php:10
9 (0.609)
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'
/var/www/clients/client1/web1/web/system/library/cart/length.php:10
10 (5.475)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 DAY)
/var/www/clients/client1/web1/web/system/library/cart/cart.php:29
11 (0.207)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/clients/client1/web1/web/catalog/model/setting/event.php:4
12 (0.170)
SELECT *
FROM oc_seo_url
WHERE keyword = 'GERARD-DE-VILLIERS' AND store_id = '0'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:37
13 (0.347)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '525' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
14 (0.305)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
15 (0.283)
DROP TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:745
16 (113.258)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, p.tax_class_id, if (SUM(if((f.filter_group = "m0" AND filter_id IN ('525')), 1, 0)) > 0, 1, 0) AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), IF(pov.price IS NOT NULL, pov.price, 0))) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
LEFT JOIN `oc_product_discount` AS pd2 ON (pd2.product_id = p.product_id 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()) AND pd2.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT product_id, price
FROM `oc_product_option_value`
WHERE quantity > '0' GROUP BY product_id) AS pov ON (pov.product_id = p.product_id)
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`
WHERE customer_group_id = '1' AND ((based = 'store' AND country_id = '175' AND zone_id IN ('0', '2703')) OR (based = 'payment' AND country_id = '175' AND zone_id IN ('0', '2703'))) GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p.date_available <= NOW() AND p.manufacturer_id = '525' GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:746
17 (0.232)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1145
18 (1.028)
SELECT p.*, pp.sort_order, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pd.name ASC, IF ((p.quantity) > 0, 1, 0) LIMIT 120, 15
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:179
19 (37.973)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '33249' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
20 (0.184)
SELECT *
FROM oc_product_image
WHERE product_id = '33249'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
21 (0.240)
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 = '33249' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
22 (0.323)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '33249' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
23 (24.989)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '33249' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
24 (41.461)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '33249' AND pov.product_option_id = '54228' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
25 (37.209)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '33260' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
26 (0.181)
SELECT *
FROM oc_product_image
WHERE product_id = '33260'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
27 (0.204)
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 = '33260' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
28 (0.317)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '33260' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
29 (23.126)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '33260' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
30 (41.433)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '33260' AND pov.product_option_id = '19834' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
31 (38.121)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '77100' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
32 (0.187)
SELECT *
FROM oc_product_image
WHERE product_id = '77100'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
33 (0.187)
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 = '77100' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
34 (0.353)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '77100' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
35 (23.476)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '77100' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
36 (42.791)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '77100' AND pov.product_option_id = '19855' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
37 (36.958)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '21702' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
38 (0.146)
SELECT *
FROM oc_product_image
WHERE product_id = '21702'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
39 (0.215)
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 = '21702' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
40 (0.339)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '21702' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
41 (23.793)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '21702' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
42 (41.212)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '21702' AND pov.product_option_id = '19831' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
43 (38.697)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '21638' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
44 (0.127)
SELECT *
FROM oc_product_image
WHERE product_id = '21638'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
45 (0.214)
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 = '21638' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
46 (0.366)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '21638' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
47 (22.651)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '21638' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
48 (40.873)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '21638' AND pov.product_option_id = '20485' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
49 (36.034)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '83606' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
50 (0.212)
SELECT *
FROM oc_product_image
WHERE product_id = '83606'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
51 (0.246)
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 = '83606' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
52 (0.381)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '83606' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
53 (22.049)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '83606' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
54 (40.405)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '83606' AND pov.product_option_id = '54218' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
55 (35.968)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '83603' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
56 (0.155)
SELECT *
FROM oc_product_image
WHERE product_id = '83603'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
57 (0.207)
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 = '83603' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
58 (0.324)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '83603' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
59 (22.129)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '83603' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
60 (40.386)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '83603' AND pov.product_option_id = '17398' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
61 (36.212)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '108894' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
62 (0.160)
SELECT *
FROM oc_product_image
WHERE product_id = '108894'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
63 (0.206)
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 = '108894' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
64 (0.287)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '108894' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
65 (22.147)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '108894' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
66 (35.944)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT cd.name
FROM oc_product_to_category p2c
LEFT JOIN oc_category_description cd ON p2c.category_id = cd.category_id
WHERE p.product_id = p2c.product_id LIMIT 1) AS category, (SELECT p2c2.category_id
FROM oc_product_to_category p2c2
WHERE p.product_id = p2c2.product_id LIMIT 1) AS category_id,(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 pr.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(1) 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, IF(pov.price IS NOT NULL, pov.price, p.price) AS price, p.product_id
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)
LEFT JOIN (SELECT MIN(povv.price) AS price, povv.product_id
FROM oc_product_option_value povv
WHERE povv.quantity > 0 GROUP BY povv.product_id) pov ON (pov.product_id = p.product_id)
WHERE p.product_id = '108854' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:30
67 (0.205)
SELECT *
FROM oc_product_image
WHERE product_id = '108854'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1039
68 (0.233)
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 = '108854' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:897
69 (0.307)
SELECT a.attribute_id, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '108854' AND a.attribute_group_id = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:907
70 (22.032)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '108854' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
71 (40.374)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '108854' AND pov.product_option_id = '19821' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
72 (22.187)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '33249' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
73 (40.444)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '33249' AND pov.product_option_id = '54228' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
74 (0.140)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
75 (22.189)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '29472' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
76 (40.531)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '29472' AND pov.product_option_id = '54223' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
77 (0.148)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
78 (23.242)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '33260' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
79 (43.156)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '33260' AND pov.product_option_id = '19834' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
80 (0.143)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
81 (24.095)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '77100' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
82 (41.937)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '77100' AND pov.product_option_id = '19855' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
83 (0.185)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
84 (0.171)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=77100' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
85 (24.046)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '33257' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
86 (41.715)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '33257' AND pov.product_option_id = '20210' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
87 (0.193)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
88 (23.968)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '21702' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
89 (43.208)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '21702' AND pov.product_option_id = '19831' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
90 (0.174)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
91 (24.055)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '21638' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
92 (42.034)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '21638' AND pov.product_option_id = '20485' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
93 (0.131)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
94 (22.623)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '63068' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
95 (41.331)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '63068' AND pov.product_option_id = '20211' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
96 (0.154)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
97 (22.937)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '83606' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
98 (41.719)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '83606' AND pov.product_option_id = '54218' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
99 (0.201)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
100 (0.193)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=83606' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
101 (23.889)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '76439' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
102 (0.130)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
103 (22.427)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '83603' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
104 (42.134)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '83603' AND pov.product_option_id = '17398' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
105 (0.195)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
106 (0.193)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=83603' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
107 (23.601)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '108894' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
108 (0.090)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
109 (0.072)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=108894' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
110 (23.320)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '21705' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
111 (41.172)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '21705' AND pov.product_option_id = '19848' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
112 (0.188)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
113 (0.206)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=21705' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
114 (23.209)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '108854' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
115 (41.430)
SELECT * , SUM(quantity) AS quantity
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '108854' AND pov.product_option_id = '19821' AND ovd.language_id = '2' AND pov.quantity > '0' GROUP BY pov.option_value_id, pov.price
ORDER BY pov.price
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:963
116 (0.139)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
117 (0.185)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=108854' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
118 (30.128)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '76200' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:953
119 (0.141)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
120 (0.115)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
121 (0.068)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
122 (0.064)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
123 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
124 (0.061)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
125 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
126 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
127 (0.064)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
128 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
129 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
130 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
131 (0.059)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
132 (0.059)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
133 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
134 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
135 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
136 (0.059)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
137 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
138 (0.062)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
139 (0.059)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_left'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
140 (0.059)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
141 (0.054)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_right'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
142 (0.112)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
143 (0.111)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'content_top'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
144 (0.061)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
145 (0.053)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
146 (1.639)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:10
147 (0.169)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=6' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
148 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=3' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
149 (0.070)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=5' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
150 (0.066)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
151 (0.150)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
152 (0.124)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=525' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
153 (0.120)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f8166ea550d7cd8e3f4bf76084'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
154 (0.105)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
155 (0.114)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f8166ea550d7cd8e3f4bf76084'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
156 (0.073)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f8166ea550d7cd8e3f4bf76084'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
157 (0.056)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f8166ea550d7cd8e3f4bf76084'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
158 (0.071)
SELECT *
FROM `oc_pb_bundles`
WHERE `store_id`='0' AND `products` != '' AND `status`= '1' AND `date_available` <= NOW()
ORDER BY `sort_order` ASC
/var/www/clients/client1/web1/web/catalog/model/extension/module/productbundles.php:92
159 (0.058)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f8166ea550d7cd8e3f4bf76084'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
160 (0.051)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/clients/client1/web1/web/system/library/cart/customer.php:243
161 (1.993)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:10
162 (0.118)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=7' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
163 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169