SOEHNLE

Difuzor aroma Soehnle Lucca 80ml, 3.5 ore, Alb

Difuzor aroma Soehnle Lucca 80ml, 3.5 ore, Alb

Descriere Extravagantul difuzor de aroma Lucca, cu design-ul sau extraordinar, va va transporta i..

274,00Lei Fără TVA: 274,00Lei

Difuzor electric aromaterapie cu led Soehnle Venezia Limited Edition 100 ml

Difuzor electric aromaterapie cu led Soehnle Venezia Limited Edition 100 ml

Descriere Difuzorul electric aromaterapie cu led Soehnle Venezia Limited Edition 100 ml creeaza o..

305,00Lei Fără TVA: 305,00Lei

Airfresh Connect 500 cu Bluetooth®

Airfresh Connect 500 cu Bluetooth®

Descriere Airfresh Connect 500 cu Bluetooth® Airfresh Connect 500 cu conexiune Bluetooth&r..

1.100,00Lei Fără TVA: 1.100,00Lei

FILTRU DE ÎNLOCUIRE PENTRU AIRFRESH CLEAN CONNECT 500 BLUETOOTH®

FILTRU DE ÎNLOCUIRE PENTRU AIRFRESH CLEAN CONNECT 500 BLUETOOTH®

Descriere Filtru de înlocuire pentru Airfresh Clean Connect 500 Bluetooth® Si..

230,00Lei Fără TVA: 230,00Lei

FILTRU SOEHNLE HYGRO 500

FILTRU SOEHNLE HYGRO 500

Descriere Filtru Soehnle Hygro 500 Filtru de inlocuire a umidificatorului Airfresh Hygro 500. F..

95,00Lei Fără TVA: 95,00Lei

FILTRU SOEHNLE AIRFRESH WASH 500

FILTRU SOEHNLE AIRFRESH WASH 500

Descriere Filtru Soehnle AirFresh Wash 500 Sistem de filtrare cu trei straturi (prefiltre / filt..

80,00Lei Fără TVA: 80,00Lei

Filtru Soehnle Airfresh Clean 300

Filtru Soehnle Airfresh Clean 300

Descriere Filtru Soehnle Airfresh Clean 300 Sistemul de filtrare cu trei straturi (filtrul pre..

160,00Lei Fără TVA: 160,00Lei

PURIFICATOR SOEHNLE AIRFRESH CLEAN 300

PURIFICATOR SOEHNLE AIRFRESH CLEAN 300

    Descriere Aer curat si sanatos Praf, polen, bacterii, gaze. Nu pute..

729,00Lei Fără TVA: 729,00Lei

ULEI AROMATERAPIE SOEHNLE VANILIE 10 ML

ULEI AROMATERAPIE SOEHNLE VANILIE 10 ML

Descriere Ulei aromaterapie Soehnle vanilie 10 ml Uleiul de vanilie este cunoscut pentru efect..

25,99Lei 41,65Lei Fără TVA: 25,99Lei

ULEI AROMATERAPIE SOEHNLE LAVANDA 10 ML

ULEI AROMATERAPIE SOEHNLE LAVANDA 10 ML

Descriere Ulei aromaterapie Soehnle lavanda 10 ml Uleiul de lavanda este cunoscut pentru efect..

25,99Lei 41,68Lei Fără TVA: 25,99Lei

ULEI AROMATERAPIE SOEHNLE TRANDAFIR 10 ML

ULEI AROMATERAPIE SOEHNLE TRANDAFIR 10 ML

Descriere Ulei aromaterapie Soehnle trandafir 10 ml Uleiul de trandafir creeaza o atmosfera de..

25,99Lei 46,50Lei Fără TVA: 25,99Lei

Cantar digital de bucatarie Soehnle Page Evolution, 5kg, 1 gr, BAMBUS

Cantar digital de bucatarie Soehnle Page Evolution, 5kg, 1 gr, BAMBUS

Descriere Bambusul - natural și la modă. Cantarul de bucătărie digitală Bamboo aduce o prospeț..

80,99Lei 129,98Lei Fără TVA: 80,99Lei

PURIFICATOR SOEHNLE AIRFRESH WASH 500

PURIFICATOR SOEHNLE AIRFRESH WASH 500

Descriere Aer sanatos, curat si umidificat natural Aer curat si sanatos, de la un singur apa..

1.200,00Lei Fără TVA: 1.200,00Lei

UMIDIFICATOR SOEHNLE HYGRO 500

UMIDIFICATOR SOEHNLE HYGRO 500

Descriere Purificator Soehnle Hygro 500  Mai ales in timpul iernii, starea noastra de b..

799,99Lei Fără TVA: 799,99Lei

Difuzor aroma Soehnle Ravenna 80ml, 3.5 ore, Alb

Difuzor aroma Soehnle Ravenna 80ml, 3.5 ore, Alb

Difuzor aroma Soehnle Ravenna 80ml, 3.5 ore, Alb   Designul elegant al difuzorului de aro..

234,99Lei 293,73Lei Fără TVA: 234,99Lei

Afişare 16 - 30 din 39 (3 pagini)
Queries: 304, Total time: 47.402 ms [By time] [By id] [By file]
1 (0.166)
SELECT `data`
FROM `oc_session`
WHERE session_id = 'b71a86de4ca21fa52ca1926c7b' AND expire > 1664161881
/home/magazine/public_html/system/library/session/db.php:21
2 (0.122)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/magazine/public_html/system/library/openbay.php:61
3 (0.168)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/magazine/public_html/catalog/model/design/translation.php:6
4 (0.141)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/magazine/public_html/system/library/openbay.php:61
5 (0.144)
SELECT `data`
FROM `oc_session`
WHERE session_id = '708b13b979e55865d546ddb003' AND expire > 1664161881
/home/magazine/public_html/system/library/session/db.php:21
6 (0.105)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://magazinelectro.ro/'
/home/magazine/storage/modification/catalog/controller/startup/startup.php:6
7 (1.790)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/magazine/storage/modification/catalog/controller/startup/startup.php:25
8 (0.138)
SELECT *
FROM oc_seo_url
WHERE keyword = 'soehnle'
/home/magazine/storage/modification/catalog/controller/startup/startup.php:125
9 (0.102)
SELECT *
FROM oc_currency
/home/magazine/public_html/system/library/cart/currency.php:10
10 (0.250)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/magazine/public_html/system/library/cart/tax.php:16
11 (0.212)
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 = '2688')
ORDER BY tr1.priority ASC
/home/magazine/public_html/system/library/cart/tax.php:44
12 (0.188)
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'
/home/magazine/public_html/system/library/cart/weight.php:10
13 (0.134)
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'
/home/magazine/public_html/system/library/cart/length.php:10
14 (0.127)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/magazine/public_html/system/library/cart/cart.php:15
15 (0.104)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/magazine/public_html/system/library/openbay.php:61
16 (0.224)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/magazine/public_html/catalog/model/setting/event.php:4
17 (0.133)
SELECT *
FROM oc_seo_url
WHERE keyword = 'soehnle' AND store_id = '0'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:19
18 (0.145)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:132
19 (0.193)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:164
20 (0.183)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '1'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:132
21 (0.174)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '1'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:164
22 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=12' AND language_id = '1'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:164
23 (0.100)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/manufacturer' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
24 (0.177)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=common/home' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
25 (0.165)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
26 (0.121)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '12' AND m2s.store_id = '0'
/home/magazine/public_html/catalog/model/catalog/manufacturer.php:4
27 (0.133)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
28 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
29 (0.109)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
30 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/compare' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
31 (0.311)
SELECT COUNT(DISTINCT p.product_id) AS total
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)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '12'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:561
32 (0.869)
SELECT p.product_id, (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 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
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)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '12' GROUP BY p.product_id
ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 15,15
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:207
33 (0.377)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '111' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
34 (0.347)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '110' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
35 (0.326)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
36 (0.348)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '108' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
37 (0.342)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '107' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
38 (0.334)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '106' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
39 (0.350)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '105' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
40 (0.355)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '104' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
41 (0.340)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '86' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
42 (0.347)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '85' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
43 (0.346)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '84' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
44 (0.332)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '82' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
45 (0.345)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '67' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
46 (0.343)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '66' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
47 (0.360)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND 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(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '60' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:8
48 (0.128)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
49 (0.123)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=111' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
50 (0.124)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
51 (0.085)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
52 (0.088)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
53 (0.086)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
54 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
55 (0.083)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
56 (0.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
57 (0.085)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=109' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
58 (0.095)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
59 (0.083)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
60 (0.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
61 (0.131)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=108' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
62 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
63 (0.110)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
64 (0.083)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
65 (0.084)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=107' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
66 (0.095)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
67 (0.084)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
68 (0.086)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
69 (0.109)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=106' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
70 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
71 (0.084)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
72 (0.082)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
73 (0.083)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=105' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
74 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
75 (0.092)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
76 (0.087)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
77 (0.111)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=104' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
78 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
79 (0.084)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
80 (0.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
81 (0.108)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=86' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
82 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
83 (0.084)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
84 (0.082)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
85 (0.137)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=85' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
86 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
87 (0.084)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
88 (0.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
89 (0.106)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=84' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
90 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
91 (0.083)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
92 (0.086)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
93 (0.128)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=82' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
94 (0.122)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
95 (0.084)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
96 (0.082)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
97 (0.104)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=67' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
98 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
99 (0.084)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
100 (0.111)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
101 (0.130)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=66' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
102 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
103 (0.083)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
104 (0.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
105 (0.101)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=60' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
106 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/product' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
107 (0.084)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
108 (0.078)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
109 (0.100)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
110 (0.093)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=p.sort_order' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
111 (0.092)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=ASC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
112 (0.078)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
113 (0.094)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
114 (0.092)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=pd.name' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
115 (0.089)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=ASC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
116 (0.120)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
117 (0.119)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
118 (0.117)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=pd.name' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
119 (0.109)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=DESC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
120 (0.099)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
121 (0.111)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
122 (0.109)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=p.price' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
123 (0.105)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=ASC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
124 (0.095)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
125 (0.109)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
126 (0.106)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=p.price' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
127 (0.110)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=DESC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
128 (0.095)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
129 (0.109)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
130 (0.108)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=rating' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
131 (0.105)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=DESC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
132 (0.094)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
133 (0.109)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
134 (0.108)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=rating' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
135 (0.104)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=ASC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
136 (0.095)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
137 (0.109)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
138 (0.106)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=p.model' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
139 (0.104)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=ASC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
140 (0.093)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
141 (0.108)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
142 (0.107)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=p.model' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
143 (0.106)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=DESC' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
144 (0.149)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
145 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
146 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=15' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
147 (0.085)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
148 (0.098)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
149 (0.085)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=25' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
150 (0.078)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
151 (0.095)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
152 (0.083)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=50' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
153 (0.082)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
154 (0.095)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
155 (0.082)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=75' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
156 (0.077)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
157 (0.093)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
158 (0.082)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=100' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
159 (0.080)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
160 (0.094)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
161 (0.092)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route={page}' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
162 (0.078)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
163 (0.095)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
164 (0.082)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
165 (0.076)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
166 (0.093)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
167 (0.082)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
168 (0.076)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
169 (0.093)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
170 (0.081)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=3' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
171 (0.100)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=common/home' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
172 (0.113)
SELECT sd.title, m.name, m.image , sd.language_id, sd.meta_keywords, sd.meta_description
FROM `oc_manufacturer` m
LEFT JOIN `oc_seo_data` sd ON (sd.id = m.manufacturer_id AND sd.type='manufacturer')
WHERE m.manufacturer_id = '12'
/home/magazine/public_html/system/library/seo/manufacturer.php:20
173 (0.089)
SELECT *
FROM oc_language
WHERE status = 1
ORDER BY sort_order ASC
/home/magazine/public_html/system/library/seo/manufacturer.php:29
174 (0.077)
SELECT keyword
FROM oc_seo_url
WHERE query = 'manufacturer_id=12' AND language_id ='2'
/home/magazine/public_html/system/library/seo/manufacturer.php:32
175 (0.071)
SELECT keyword
FROM oc_seo_url
WHERE query = 'manufacturer_id=12' AND language_id ='1'
/home/magazine/public_html/system/library/seo/manufacturer.php:32
176 (0.070)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/magazine/public_html/catalog/model/design/layout.php:4
177 (0.062)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_left'
ORDER BY sort_order
/home/magazine/public_html/catalog/model/design/layout.php:14
178 (0.098)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/column_left'
/home/magazine/public_html/catalog/model/design/theme.php:4
179 (0.200)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/magazine/public_html/catalog/model/design/layout.php:4
180 (0.121)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_right'
ORDER BY sort_order
/home/magazine/public_html/catalog/model/design/layout.php:14
181 (0.096)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/column_right'
/home/magazine/public_html/catalog/model/design/theme.php:4
182 (0.175)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/magazine/public_html/catalog/model/design/layout.php:4
183 (0.141)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'content_top'
ORDER BY sort_order
/home/magazine/public_html/catalog/model/design/layout.php:14
184 (0.094)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/content_top'
/home/magazine/public_html/catalog/model/design/theme.php:4
185 (0.137)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/magazine/public_html/catalog/model/design/layout.php:4
186 (0.106)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'content_bottom'
ORDER BY sort_order
/home/magazine/public_html/catalog/model/design/layout.php:14
187 (0.093)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/content_bottom'
/home/magazine/public_html/catalog/model/design/theme.php:4
188 (0.106)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
189 (0.820)
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
/home/magazine/public_html/catalog/model/catalog/information.php:10
190 (0.140)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=7' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
191 (0.101)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/information' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
192 (0.082)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=3' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
193 (0.094)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/information' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
194 (0.069)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=11' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
195 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/information' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
196 (0.085)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=11' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
197 (0.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=5' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
198 (0.093)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/information' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
199 (0.078)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=14' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
200 (0.093)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/information' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
201 (0.078)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information_id=15' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
202 (0.091)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/information' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
203 (0.100)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/contact' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
204 (0.089)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/return/add' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
205 (0.105)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/sitemap' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
206 (0.102)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/tracking' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
207 (0.102)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
208 (0.099)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/voucher' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
209 (0.098)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=affiliate/login' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
210 (0.113)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/special' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
211 (0.091)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/account' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
212 (0.095)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/order' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
213 (0.100)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/wishlist' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
214 (0.098)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/newsletter' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
215 (0.113)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2022-09-26 02:11:21'
/home/magazine/public_html/catalog/model/tool/online.php:4
216 (0.093)
REPLACE INTO `oc_customer_online` SET `ip` = '18.208.187.128', `customer_id` = '0', `url` = 'https://www.magazinelectro.ro/soehnle?page=2', `referer` = '', `date_added` = '2022-09-26 03:11:21'
/home/magazine/public_html/catalog/model/tool/online.php:6
217 (0.051)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/footer'
/home/magazine/public_html/catalog/model/design/theme.php:4
218 (0.143)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/magazine/public_html/catalog/model/setting/extension.php:4
219 (0.101)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
220 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/account' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
221 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/logout' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
222 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=common/home' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
223 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/wishlist' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
224 (0.179)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/account' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
225 (0.184)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/register' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
226 (0.132)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/login' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
227 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/order' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
228 (0.101)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/transaction' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
229 (0.095)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/download' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
230 (0.095)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=account/logout' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
231 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=checkout/cart' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
232 (0.140)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=checkout/checkout' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
233 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=information/contact' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
234 (0.054)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
235 (0.094)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=common/language/language' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
236 (0.087)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
237 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
238 (0.128)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
239 (0.073)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/language'
/home/magazine/public_html/catalog/model/design/theme.php:4
240 (0.109)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
241 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=common/currency/currency' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
242 (0.133)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:206
243 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/manufacturer/info' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
244 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=2' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
245 (0.085)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/currency'
/home/magazine/public_html/catalog/model/design/theme.php:4
246 (0.124)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
247 (0.049)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/search'
/home/magazine/public_html/catalog/model/design/theme.php:4
248 (0.079)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
249 (0.092)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '708b13b979e55865d546ddb003'
/home/magazine/public_html/system/library/cart/cart.php:36
250 (0.071)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/magazine/public_html/catalog/model/setting/extension.php:4
251 (0.094)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
252 (0.108)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '708b13b979e55865d546ddb003'
/home/magazine/public_html/system/library/cart/cart.php:36
253 (0.111)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '708b13b979e55865d546ddb003'
/home/magazine/public_html/system/library/cart/cart.php:36
254 (0.088)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/credit' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
255 (0.091)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/magazine/public_html/system/library/cart/customer.php:122
256 (0.089)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
257 (0.109)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '708b13b979e55865d546ddb003'
/home/magazine/public_html/system/library/cart/cart.php:36
258 (0.111)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '708b13b979e55865d546ddb003'
/home/magazine/public_html/system/library/cart/cart.php:36
259 (0.178)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=checkout/cart' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
260 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=checkout/checkout' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
261 (0.090)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/cart'
/home/magazine/public_html/catalog/model/design/theme.php:4
262 (0.215)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'popup'
/home/magazine/public_html/catalog/model/setting/setting.php:6
263 (0.099)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
264 (0.413)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/magazine/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
265 (0.485)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '1' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/magazine/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
266 (0.150)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
267 (0.104)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=12' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
268 (0.099)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
269 (1.134)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '12'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:561
270 (0.124)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
271 (0.114)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
272 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
273 (1.087)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '3'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:561
274 (0.111)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
275 (0.107)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=14' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
276 (0.100)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
277 (1.271)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '14'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:561
278 (0.091)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
279 (0.074)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=41' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
280 (0.096)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
281 (1.096)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '41'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:561
282 (0.090)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
283 (0.084)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=15' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
284 (0.098)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
285 (1.181)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '15'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:561
286 (0.090)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
287 (0.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=19' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
288 (0.098)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
289 (1.047)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '19'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:561
290 (0.087)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
291 (0.079)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=10' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
292 (0.098)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
293 (1.045)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '10'
/home/magazine/public_html/vqmod/vqcache/vq2-_home_magazine_storage_modification_catalog_model_catalog_product.php:561
294 (0.087)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
295 (0.103)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
296 (0.254)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '2' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/magazine/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
297 (0.092)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=2' AND store_id = '0' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:217
298 (0.098)
SELECT *
FROM `oc_seo_url`
WHERE `query` = 'route=product/category' AND language_id = '2'
/home/magazine/storage/modification/catalog/controller/startup/seo_url.php:239
299 (0.052)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'ro-ro')
/home/magazine/public_html/catalog/model/design/translation.php:6
300 (0.045)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/search'
/home/magazine/public_html/catalog/model/design/theme.php:4
301 (0.098)
SELECT g.gallimage_id,gd.name
FROM oc_gallimage g
LEFT JOIN oc_gallimage_description gd ON (g.gallimage_id = gd.gallimage_id)
WHERE status = 1
ORDER BY sort_order DESC
/home/magazine/public_html/catalog/model/extension/gallery/gallimage.php:23
302 (0.084)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/menu'
/home/magazine/public_html/catalog/model/design/theme.php:4
303 (0.095)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'common/header'
/home/magazine/public_html/catalog/model/design/theme.php:4
304 (0.107)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'madame' AND route = 'product/manufacturer_info'
/home/magazine/public_html/catalog/model/design/theme.php:4