Carti scrise de autor(i) GABRIEL GARCIA MARQUEZ

A TRAI PENTRU A-TI POVESTI VIATA

Stoc limitat
CRONICA UNEI MORTI ANUNTATE

Stoc limitat
CRONICA UNEI MORTI ANUNTATE

Stoc limitat
DESPRE DRAGOSTE SI ALTI DEMONI

Stoc limitat
GENERALUL IN LABIRINTUL SAU

Stoc limitat
O VIATA GERALD MARTIN

Stoc limitat
TOAMNA PATRIARHULUI

Stoc limitat
TOAMNA PATRIARHULUI
Nou

Stoc limitat
TOAMNA PATRIARHULUI

Stoc limitat
TOAMNA PATRIARHULUI

Stoc limitat
CEAS RAU

Stoc epuizat
CENT'ANNI DI SOLITUDINE

Stoc epuizat
Afişare 1 - 15 din 49 (4 pagini)
Queries: 144, Total time: 944.116 ms [By time] [By id] [By file]
1 (0.127)
SELECT `data`
FROM `oc_session`
WHERE session_id = '5429e0ba2f76904612224cac50' AND expire > 1680428884
/var/www/clients/client1/web1/web/system/library/session/db.php:41
2 (0.704)
SELECT `data`
FROM `oc_session`
WHERE session_id = '8b4eb10187b43e132021cd2db6' AND expire > 1680428884
/var/www/clients/client1/web1/web/system/library/session/db.php:41
3 (0.457)
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.263)
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.389)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/storage/modification/system/library/cart/currency.php:10
6 (0.796)
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/storage/modification/system/library/cart/tax.php:36
7 (0.886)
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/storage/modification/system/library/cart/tax.php:50
8 (0.543)
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.477)
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 (3.941)
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.816)
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.486)
SELECT *
FROM oc_seo_url
WHERE keyword = 'GABRIEL-GARCIA-MARQUEZ' AND store_id = '0'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:37
13 (0.305)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '3322' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
14 (0.325)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
15 (0.826)
DROP TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:747
16 (86.169)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, if (SUM(if((f.filter_group = "m0" AND filter_id IN ('3322')), 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(MIN(pov.price) IS NOT NULL, MIN(pov.price), p.price))) * (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
ORDER BY price ASC) 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 = '3322' GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/extension/module/brainyfilter.php:748
17 (0.152)
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:1125
18 (0.371)
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 0, 15
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:179
19 (24.543)
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 = '130866' 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.158)
SELECT *
FROM oc_product_image
WHERE product_id = '130866'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1019
21 (0.208)
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 = '130866' 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:877
22 (0.273)
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 = '130866' 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:887
23 (13.043)
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 = '130866' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
24 (21.388)
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 = '130866' AND pov.product_option_id = '37730' 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:943
25 (24.517)
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 = '128444' 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.103)
SELECT *
FROM oc_product_image
WHERE product_id = '128444'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1019
27 (0.152)
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 = '128444' 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:877
28 (0.240)
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 = '128444' 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:887
29 (12.963)
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 = '128444' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
30 (21.403)
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 = '128444' AND pov.product_option_id = '33358' 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:943
31 (24.421)
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 = '128020' 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.101)
SELECT *
FROM oc_product_image
WHERE product_id = '128020'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1019
33 (0.153)
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 = '128020' 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:877
34 (0.241)
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 = '128020' 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:887
35 (12.920)
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 = '128020' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
36 (21.338)
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 = '128020' AND pov.product_option_id = '32475' 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:943
37 (24.444)
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 = '132226' 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.099)
SELECT *
FROM oc_product_image
WHERE product_id = '132226'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1019
39 (0.160)
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 = '132226' 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:877
40 (0.237)
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 = '132226' 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:887
41 (13.024)
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 = '132226' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
42 (21.416)
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 = '132226' AND pov.product_option_id = '40031' 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:943
43 (24.364)
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 = '95498' 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.099)
SELECT *
FROM oc_product_image
WHERE product_id = '95498'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1019
45 (0.152)
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 = '95498' 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:877
46 (0.238)
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 = '95498' 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:887
47 (12.979)
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 = '95498' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
48 (21.281)
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 = '95498' AND pov.product_option_id = '32839' 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:943
49 (24.316)
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 = '90957' 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.100)
SELECT *
FROM oc_product_image
WHERE product_id = '90957'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:1019
51 (0.157)
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 = '90957' 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:877
52 (0.235)
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 = '90957' 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:887
53 (13.202)
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 = '90957' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
54 (12.932)
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 = '128431' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
55 (21.329)
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 = '128431' AND pov.product_option_id = '33303' 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:943
56 (0.111)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
57 (13.083)
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 = '130866' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
58 (21.385)
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 = '130866' AND pov.product_option_id = '37730' 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:943
59 (0.157)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
60 (12.980)
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 = '128031' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
61 (21.373)
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 = '128031' AND pov.product_option_id = '32511' 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:943
62 (0.153)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
63 (12.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 = '126793' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
64 (21.391)
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 = '126793' AND pov.product_option_id = '29810' 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:943
65 (0.110)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
66 (12.723)
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 = '79304' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
67 (21.361)
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 = '79304' AND pov.product_option_id = '10000' 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:943
68 (0.157)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
69 (12.887)
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 = '124154' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
70 (21.326)
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 = '124154' AND pov.product_option_id = '23957' 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:943
71 (0.107)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
72 (13.002)
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 = '128444' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
73 (21.500)
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 = '128444' AND pov.product_option_id = '33358' 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:943
74 (0.121)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
75 (13.081)
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 = '27632' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
76 (21.449)
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 = '27632' AND pov.product_option_id = '33269' 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:943
77 (0.150)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
78 (12.780)
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 = '58117' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
79 (21.581)
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 = '58117' AND pov.product_option_id = '18514' 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:943
80 (0.149)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
81 (13.140)
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 = '92356' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
82 (21.403)
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 = '92356' AND pov.product_option_id = '34609' 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:943
83 (0.150)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
84 (13.243)
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 = '12838' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
85 (21.970)
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 = '12838' AND pov.product_option_id = '14171' 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:943
86 (0.164)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
87 (13.561)
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 = '128020' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
88 (21.905)
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 = '128020' AND pov.product_option_id = '32475' 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:943
89 (0.113)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
90 (0.118)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=128020' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
91 (13.683)
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 = '132226' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
92 (23.941)
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 = '132226' AND pov.product_option_id = '40031' 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:943
93 (0.122)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
94 (0.105)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=132226' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
95 (13.087)
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 = '95498' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
96 (21.378)
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 = '95498' AND pov.product_option_id = '32839' 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:943
97 (0.181)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
98 (0.189)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=95498' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
99 (13.343)
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 = '90957' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/clients/client1/web1/web/storage/modification/catalog/model/catalog/product.php:933
100 (0.127)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
101 (0.125)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=90957' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
102 (0.091)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
103 (0.069)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
104 (0.056)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
105 (0.141)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
106 (0.125)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
107 (0.057)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
108 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
109 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
110 (0.055)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
111 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
112 (0.055)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
113 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
114 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
115 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
116 (0.057)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
117 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
118 (0.064)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
119 (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
120 (0.056)
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
121 (0.111)
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
122 (0.087)
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
123 (0.053)
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
124 (0.062)
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
125 (0.106)
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
126 (0.127)
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
127 (1.308)
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
128 (0.100)
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
129 (0.095)
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
130 (0.057)
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
131 (0.116)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
132 (0.100)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
133 (0.130)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=3322' AND store_id = '0' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/controller/startup/seo_url.php:169
134 (0.131)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8b4eb10187b43e132021cd2db6'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
135 (0.097)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/clients/client1/web1/web/catalog/model/setting/extension.php:4
136 (0.060)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8b4eb10187b43e132021cd2db6'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
137 (0.053)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8b4eb10187b43e132021cd2db6'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
138 (0.113)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8b4eb10187b43e132021cd2db6'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
139 (0.131)
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
140 (0.124)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8b4eb10187b43e132021cd2db6'
/var/www/clients/client1/web1/web/system/library/cart/cart.php:71
141 (0.108)
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
142 (1.281)
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
143 (0.144)
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
144 (0.123)
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