Meny
Varukorg

Whippetselar

Whippetselar

Våra selar är speciellt framtagna för att passa vinthundar. De tillverkas i fyra olika storlekar och passar italiensk vinthund, whippet, saluki mfl samt borzoi mfl. Man kan även använda dem till valpar. Då kompletterat med funktionen att minska storleken. Selarna tillverkas i slitstark svart polypropylen och är vadderade med svart teddy fram runt bröstet så att de blir mjuka och sköna. Selarnas detaljer går att få i många olika färger. Som alternativ till de färgade detaljerna finns ett färgat band med invävd reflex. Vi anpassar även selarna efter hundens mått om ni skulle önska andra storlekar.

Whippetsele Whippetsele
Hot 1 - 4 veckor
Rymningssäker sele till whippet, tillverkad i slitstark svart polypropylen. Detaljer i färgerna röd, vinröd, silver, svart, blå, lila, gul eller grön. Selens bröstband kan fodras med svart teddy. Selarna är i första hand anpassade till whippet och finns i två storlekar, medium och large. Medium stor..
190,00SEK
Exkl moms:152,00SEK
Whippetsele reflex Whippetsele reflex
Hot 1 - 4 veckor
Rymningssäker sele till whippet, tillverkad i slitstark svart polypropylen. Detaljer med invävd reflex i färgerna röd, svart eller blå. Selens bröstband kan fodras med svart teddy. Selarna är i första hand anpassade till whippet och finns i två storlekar, medium och large. Medium är avpassad för “no..
190,00SEK
Exkl moms:152,00SEK
Whippetsele reflex Whippetsele reflex
Hot 1 - 4 veckor
Rymningssäker sele till whippet, tillverkad i slitstark svart polypropylen. Detaljer med invävd reflex i färgerna svart/blå, svart/rosa, svart/olivgrön, svart/silver, svart/röd, svart/neongul eller svart/lila. Selens bröstband kan fodras med svart teddy. Selarna är i första hand anpassade för whippe..
190,00SEK
Exkl moms:152,00SEK
Whippetsele mesh Whippetsele mesh
Hot 1 - 4 veckor
Rymningssäker sele till whippet, tillverkad i slitstark svart polypropylen. Detaljer med invävd reflex i färgerna svart/blå, svart/rosa, svart/olivgrön, svart/silver, svart/röd, svart/neongul eller svart/lila. Selens bröstband är fodrat med mesh. Selarna är i första hand anpassade till whippet och f..
240,00SEK
Exkl moms:192,00SEK
Sverigeselen
1 - 4 veckor
Rymningssäker sele tillverkad i slitstark polypropylen, vadderad med fleece. Selarna är i första hand anpassade för vinthundar. Denna sele finns i tre storlekar. Storlek M passar normalstora whippet, storlek L passar större whippets, medan XL passar greyhound, galgo espanol, saluki mfl...
240,00SEK
Exkl moms:192,00SEK
Visar 1 till 5 av 5 (1 sidor)
Vi använder cookies på vår hemsida. Genom att besöka vår webbplats samtycker du till vår användning av cookies.  Läs mer...
e('crossorigin','*'); s0.parentNode.insertBefore(s1,s0); })();
Queries: 937, Total time: 1,050.136 ms [By time] [By id] [By file]
1 (0.209)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
2 (0.194)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/torshammar/domains/torshammarens.se/public_html/system/library/openbay.php:61
3 (0.239)
SELECT `data`
FROM `oc_session`
WHERE session_id = '0cbacbf0f191ad21eb2639e007' AND expire > 1569072877
/home/torshammar/domains/torshammarens.se/public_html/system/library/session/db.php:21
4 (0.110)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://torshammarens.se/'
/home/torshammar/domains/torshammarens.se/public_html/catalog/controller/startup/startup.php:6
5 (6.501)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/torshammar/domains/torshammarens.se/public_html/catalog/controller/startup/startup.php:25
6 (0.241)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/localisation/language.php:15
7 (0.236)
SELECT *
FROM oc_currency
/home/torshammar/domains/torshammarens.se/public_html/system/library/cart/currency.php:10
8 (0.692)
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 = '8' AND z2gz.country_id = '203' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3094')
ORDER BY tr1.priority ASC
/home/torshammar/domains/torshammarens.se/public_html/system/library/cart/tax.php:16
9 (0.320)
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 = '8' AND z2gz.country_id = '203' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3094')
ORDER BY tr1.priority ASC
/home/torshammar/domains/torshammarens.se/public_html/system/library/cart/tax.php:44
10 (0.206)
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/torshammar/domains/torshammarens.se/public_html/system/library/cart/weight.php:10
11 (0.186)
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/torshammar/domains/torshammarens.se/public_html/system/library/cart/length.php:10
12 (0.512)
SELECT value
FROM oc_setting
WHERE `key` like 'sms_status'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:435
13 (0.302)
SELECT *
FROM oc_product
INNER JOIN oc_product_to_store ON oc_product.product_id = oc_product_to_store.product_id
WHERE model like 'InfoSMS' AND store_id = 0;
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:419
14 (0.457)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_system_library_cart_cart.php:18
15 (0.140)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/torshammar/domains/torshammarens.se/public_html/system/library/openbay.php:61
16 (0.712)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/event.php:4
17 (0.251)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
18 (0.143)
SELECT count(*) AS total
FROM `oc_journal3_skin`
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/settings.php:112
19 (0.202)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
20 (0.334)
SELECT *
FROM `oc_journal3_variable`
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/settings.php:12
21 (2.105)
SELECT *
FROM `oc_journal3_style`
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/settings.php:25
22 (0.869)
SELECT setting_name, setting_value, serialized
FROM `oc_journal3_setting`
WHERE `store_id` = '0' OR `store_id` = '0'
ORDER BY store_id ASC
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/settings.php:62
23 (2.780)
SELECT setting_name, setting_value, serialized
FROM `oc_journal3_skin_setting`
WHERE `skin_id` = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/settings.php:83
24 (0.277)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '8'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
25 (0.180)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '5'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
26 (0.323)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
27 (0.117)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
28 (0.107)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/css'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
29 (0.350)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
30 (0.173)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
31 (1.494)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_label'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:14
32 (10.637)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' GROUP BY p.product_id
ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0, 50
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
33 (8.086)
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 = '8' 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 = '8' 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 = '8') 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 IN (11021,11013,11012,11011,11010,11009,11008,11007,11006,11005,11004,11003,11002,11001,11000,10999,10998,10997,10996,10995,10994,10993,10992,10991,10990,10989,10988,10987,10986,10985,10984,10983,10982,10981,10980,10979,10966,10965,10963,10960,10959,10957,10949,10948,10947,10945,10944,10943,10931,10921) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
34 (38.195)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed , SUM(op.quantity) AS sales
FROM `oc_order_product` op
LEFT JOIN `oc_order` o ON (o.order_id = op.order_id)
LEFT JOIN `oc_product` p ON (p.product_id = op.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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND o.order_status_id > '0' GROUP BY p.product_id
ORDER BY sales DESC, LCASE(pd.name) DESC LIMIT 0, 10
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
35 (4.998)
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 = '8' 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 = '8' 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 = '8') 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 IN (9275,85,10802,2989,10307,9276,10634,2930,2998,10510) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
36 (5.090)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND COALESCE( ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) , ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) , p.price) <= 0 GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
37 (3.218)
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 = '8' 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 = '8' 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 = '8') 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 IN (360,257) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
38 (0.472)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p.manufacturer_id IN (16) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 99
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
39 (0.132)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
40 (1.548)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_exclude_button'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:14
41 (0.146)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
42 (1.117)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_extra_button'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:14
43 (0.140)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
44 (2.017)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_blocks'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:14
45 (37.965)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed , SUM(op.quantity) AS sales
FROM `oc_order_product` op
LEFT JOIN `oc_order` o ON (o.order_id = op.order_id)
LEFT JOIN `oc_product` p ON (p.product_id = op.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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND o.order_status_id > '0' GROUP BY p.product_id
ORDER BY sales DESC, LCASE(pd.name) DESC LIMIT 0, 15
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
46 (5.630)
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 = '8' 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 = '8' 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 = '8') 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 IN (9275,85,10802,2989,10307,9276,10634,2930,2998,10510,2985,2997,2984,10805,6621) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
47 (7.637)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (549,585,586,595,553,528,555,539,550,541,542,468,606,603,611,478,480,557,588,98,80,551,604) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 9999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
48 (15.005)
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 = '8' 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 = '8' 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 = '8') 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 IN (10878,10873,10868,10874,10869,10875,10870,10876,10871,10877,10872,10879,4,1,2967,10781,10782,10750,10752,10743,10741,10749,10745,10744,10755,10754,10747,10742,10748,10746,10751,10713,10753,116,10512,2985,10904,2986,10347,2965,117,10636,10965,3,10960,2998,2974,2968,2966,2,5,2930,8967,8968,8963,8969,8964,9793,8965,8966,10540,10963,2969,6,7,2976,2977,2975,2970,2973,2971,2972,8,10966,9,10867,11021,10943,10921,10532,11,12,13,14,15,16,17,10762,85,10513,10634,6621,10895,2989,10514,10633,9276,10505,10894,9275,10317,10806,10307,10805,10893,10802,10499,10900,10500,10892,10756,10501,10502,2925,10635,10323,10320,10321,10521) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
49 (4.734)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND COALESCE( ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) , ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) , p.price) >= 560 GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 9999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
50 (0.786)
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 = '8' 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 = '8' 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 = '8') 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 IN (2997) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
51 (0.723)
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 = '8' 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 = '8' 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 = '8') 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 IN (2984) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
52 (3.532)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (360,361,554,362,364,363,559,377,544,612,617,619) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 9999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
53 (8.662)
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 = '8' 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 = '8' 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 = '8') 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 IN (10236,10857,10863,10860,6901,10846,11013,6904,10233,10859,10865,10242,10483,10545,10479,10235,10858,6903,10338,10232,10527,10474,10234,10855,10862,10845,10945,10482,6905,10231,10334,10544,10478,10326,10526,10475,10856,10861,10844,11012,10481,6906,10237,10543,10477,10944,10847,10337,10346,10848,10525,10476,10637,10850,10851,10852,10853,10866,10948,10949,10854,10947,10864) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
54 (0.800)
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 = '8' 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 = '8' 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 = '8') 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 IN (4) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
55 (0.687)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (479) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 9999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
56 (2.794)
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 = '8' 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 = '8' 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 = '8') 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 IN (10931,10510) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
57 (0.740)
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 = '8' 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 = '8' 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 = '8') 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 IN (10350) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
58 (2.509)
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 = '8' 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 = '8' 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 = '8') 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 IN (10316,10353,10313) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
59 (2.280)
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 = '8' 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 = '8' 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 = '8') 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 IN (10352,10314,10315) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
60 (2.465)
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 = '8' 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 = '8' 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 = '8') 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 IN (10343,10344) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
61 (2.188)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (544) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
62 (8.669)
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 = '8' 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 = '8' 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 = '8') 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 IN (10236,10233,10235,10232,10234,10231) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
63 (7.970)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (363,364,559,362,612,560) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
64 (22.959)
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 = '8' 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 = '8' 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 = '8') 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 IN (6901,10846,6904,10865,10242,10483,10545,10479,6903,10338,10527,10474,10845,10482,6905,10334,10544,10478,10326,10526,10475,10844,10481,6906,10237,10543,10477,10337,10525,10476) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
65 (2.292)
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 = '8' 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 = '8' 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 = '8') 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 IN (116) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
66 (2.039)
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 = '8' 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 = '8' 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 = '8') 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 IN (1) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
67 (2.136)
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 = '8' 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 = '8' 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 = '8') 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 IN (3) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
68 (2.065)
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 = '8' 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 = '8' 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 = '8') 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 IN (2) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
69 (2.067)
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 = '8' 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 = '8' 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 = '8') 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 IN (5) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
70 (2.207)
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 = '8' 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 = '8' 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 = '8') 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 IN (6) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
71 (2.282)
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 = '8' 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 = '8' 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 = '8') 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 IN (7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
72 (2.760)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (468) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 5
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
73 (8.707)
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 = '8' 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 = '8' 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 = '8') 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 IN (8966,8967,8968,8963,8969) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
74 (2.211)
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 = '8' 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 = '8' 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 = '8') 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 IN (8) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
75 (1.982)
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 = '8' 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 = '8' 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 = '8') 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 IN (9) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
76 (2.057)
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 = '8' 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 = '8' 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 = '8') 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 IN (12) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
77 (1.955)
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 = '8' 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 = '8' 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 = '8') 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 IN (11) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
78 (2.010)
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 = '8' 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 = '8' 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 = '8') 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 IN (13) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
79 (2.053)
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 = '8' 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 = '8' 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 = '8') 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 IN (14) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
80 (2.145)
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 = '8' 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 = '8' 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 = '8') 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 IN (16) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
81 (6.483)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (539,550,541,542,588,589,590,592,591,549,468) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
82 (16.699)
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 = '8' 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 = '8' 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 = '8') 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 IN (10875,10870,10876,10871,10877,10872,10878,10873,10868,10874,10869,10879,2985,2986,10904,10347,2998,8966,8967,8968,8963,8969,8964,9793,8965,10867,10317,2997,10316,10756,2984,10350,10344) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
83 (2.469)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 = '8' 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 = '8') 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 IN (15) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
84 (2.158)
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 = '8' 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 = '8' 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 = '8') 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 IN (17) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
85 (2.186)
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 = '8' 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 = '8' 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 = '8') 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 IN (2967) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
86 (1.987)
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 = '8' 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 = '8' 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 = '8') 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 IN (2965) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
87 (2.024)
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 = '8' 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 = '8' 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 = '8') 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 IN (117) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
88 (2.080)
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 = '8' 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 = '8' 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 = '8') 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 IN (2974) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
89 (2.365)
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 = '8' 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 = '8' 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 = '8') 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 IN (2968) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
90 (2.216)
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 = '8' 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 = '8' 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 = '8') 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 IN (2966) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
91 (2.177)
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 = '8' 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 = '8' 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 = '8') 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 IN (2969) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
92 (2.061)
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 = '8' 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 = '8' 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 = '8') 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 IN (2976) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
93 (2.042)
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 = '8' 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 = '8' 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 = '8') 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 IN (2977) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
94 (2.084)
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 = '8' 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 = '8' 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 = '8') 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 IN (2975) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
95 (3.306)
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 = '8' 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 = '8' 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 = '8') 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 IN (2970) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
96 (2.092)
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 = '8' 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 = '8' 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 = '8') 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 IN (2973) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
97 (2.052)
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 = '8' 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 = '8' 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 = '8') 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 IN (2971) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
98 (2.080)
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 = '8' 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 = '8' 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 = '8') 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 IN (2972) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
99 (3.224)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (360,361,554,617) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
100 (10.518)
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 = '8' 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 = '8' 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 = '8') 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 IN (10857,10863,10860,11013,10859,10858,10855,10862,10945,10856,10861,11012) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
101 (7.632)
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 = '8' 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 = '8' 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 = '8') 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 IN (10896,10897,10898,10899,10943) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
102 (4.704)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (478,480,557,479) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
103 (13.135)
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 = '8' 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 = '8' 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 = '8') 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 IN (10512,2930,10931,85,10513,6621,2989,10514,9276,10510,9275,10806,10805,10802,2925) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
104 (3.475)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id IN (528,555,553) GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 999
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
105 (9.718)
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 = '8' 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 = '8' 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 = '8') 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 IN (10532,10895,10894,10893,10499,10900,10500,10892,10501,10502) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
106 (0.463)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
107 (3.316)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_tabs'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:14
108 (0.421)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
109 (15.877)
SELECT product_id, image
FROM oc_product_image
WHERE sort_order = ( SELECT MIN(sort_order)
FROM oc_product_image AS p
WHERE p.product_id = oc_product_image.product_id )
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:102
110 (0.439)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
111 (1.711)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:132
112 (0.351)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/category' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
113 (0.849)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
114 (5.151)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
115 (0.985)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
116 (1.440)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
117 (5.615)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '74' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
118 (0.903)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
119 (1.432)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
120 (0.807)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
121 (0.605)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
122 (5.191)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '478' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
123 (0.892)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
124 (1.346)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
125 (0.745)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
126 (0.586)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
127 (0.796)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
128 (5.090)
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 = '478' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:10
129 (0.908)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
130 (1.367)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
131 (1.239)
SELECT COUNT(DISTINCT p.product_id) total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478'
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
132 (3.228)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 12
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
133 (11.291)
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 = '8' 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 = '8' 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 = '8') 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 IN (85,2989,9275,10802,2925) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
134 (0.931)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
135 (0.544)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
136 (0.886)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=85' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
137 (0.650)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
138 (0.562)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
139 (0.855)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2989' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
140 (0.735)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
141 (0.577)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
142 (0.904)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=9275' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
143 (0.792)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
144 (0.547)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
145 (0.649)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10802' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
146 (0.629)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
147 (0.595)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
148 (0.830)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2925' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
149 (0.561)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
150 (0.450)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
151 (0.539)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
152 (0.562)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
153 (0.513)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
154 (0.495)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
155 (0.574)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
156 (0.452)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
157 (0.531)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
158 (0.468)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
159 (0.495)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
160 (0.531)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
161 (0.510)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
162 (0.442)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
163 (0.572)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
164 (0.518)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
165 (0.530)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
166 (0.522)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
167 (0.596)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
168 (0.516)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
169 (0.513)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
170 (0.596)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
171 (0.488)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
172 (0.476)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
173 (0.564)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
174 (0.528)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
175 (0.516)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
176 (0.549)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
177 (0.597)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
178 (0.486)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
179 (0.497)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
180 (0.557)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=478' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
181 (0.589)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
182 (0.346)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
183 (0.380)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '478' AND store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:55
184 (1.147)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/layout.php:4
185 (0.501)
SELECT layout_id, layout_data
FROM `oc_journal3_layout`
WHERE `layout_id` = '78' OR `layout_id` = -1
ORDER BY `layout_id` DESC
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/layout.php:16
186 (0.368)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
187 (0.348)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/category' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
188 (1.057)
SELECT COUNT(DISTINCT p.product_id) total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478'
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
189 (0.628)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '36'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
190 (2.406)
SELECT MIN(COALESCE( ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) , ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) , p.price)) AS min, MAX(COALESCE( ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) , ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) , p.price)) AS max
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478'
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
191 (0.914)
SELECT MAX(c.category_id) id, MAX(cd.name) value, MAX(c.image) image, COUNT(*) total
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)
LEFT JOIN `oc_product_to_category`p2c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_product` p ON (p.product_id = p2c.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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.parent_id = '478' GROUP BY c.category_id HAVING COUNT(*) > 0
ORDER BY c.sort_order, LCASE(cd.name) ASC
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
192 (1.011)
SELECT max(m.manufacturer_id) id, MAX(m.name) value, MAX(m.image) image, COUNT(*) total
FROM `oc_manufacturer` m
LEFT JOIN `oc_manufacturer_to_store` m2s ON (m.manufacturer_id = m2s.manufacturer_id)
LEFT JOIN `oc_product` p ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478' AND m2s.store_id = '0' GROUP BY m.manufacturer_id HAVING COUNT(*) > 0
ORDER BY m.sort_order ASC, m.name ASC
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
193 (5.387)
SELECT MAX(a.attribute_id) attribute_id, MAX(ad.name) attribute_name, MAX(pa.text) value, COUNT(*) total
FROM `oc_product` p
LEFT JOIN `oc_product_attribute` pa ON (p.product_id = pa.product_id)
LEFT JOIN `oc_attribute` a ON (a.attribute_id = pa.attribute_id)
LEFT JOIN `oc_attribute_description` ad ON (ad.attribute_id = a.attribute_id)
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478' AND pa.language_id = '2' AND ad.language_id = '2' GROUP BY lower(pa.text), a.attribute_id HAVING COUNT(*) > 0
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
194 (4.653)
SELECT MAX(pov.option_id) option_id, MAX(od.name) option_name, MAX(ovd.option_value_id) id, MAX(ovd.name) value, COUNT(*) total, ov.image image
FROM `oc_product` p
LEFT JOIN `oc_product_option_value` pov ON (p.product_id = pov.product_id)
LEFT JOIN `oc_option_value` ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (pov.option_value_id = ovd.option_value_id)
LEFT JOIN `oc_option_description` od ON (pov.option_id = od.option_id)
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478' AND od.language_id = '2' AND ovd.language_id = '2' GROUP BY pov.option_value_id HAVING COUNT(*) > 0
ORDER BY ov.sort_order, ovd.name
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
195 (2.553)
SELECT f.filter_id id, fd.name filter_name, fg.filter_group_id filter_group_id, fgd.name filter_group_name, COUNT(*) total
FROM `oc_product` p
LEFT JOIN `oc_product_filter` pf ON (p.product_id = pf.product_id)
LEFT JOIN `oc_filter` f ON (f.filter_id = pf.filter_id)
LEFT JOIN `oc_filter_description` fd ON (fd.filter_id = pf.filter_id)
LEFT JOIN `oc_filter_group` fg ON (fg.filter_group_id = fd.filter_group_id)
LEFT JOIN `oc_filter_group_description` fgd ON (fd.filter_group_id = fgd.filter_group_id)
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478' AND fd.language_id = '2' AND fgd.language_id = '2' GROUP BY pf.filter_id HAVING COUNT(*) > 0
ORDER BY f.sort_order, fd.name
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
196 (0.690)
SELECT tag
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478'
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
197 (0.706)
SELECT IF(p.quantity > 0, 1, 0) AS availability, COUNT(*) AS total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '478' GROUP BY CASE WHEN p.quantity > 0 THEN 1 ELSE 0 END
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
198 (0.339)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
199 (0.266)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
200 (0.279)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/filter'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
201 (0.697)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
202 (0.492)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
203 (0.243)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
204 (0.263)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
205 (0.263)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
206 (0.308)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
207 (0.233)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
208 (0.281)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/column_left'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
209 (0.261)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
210 (0.308)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '477'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
211 (0.405)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
212 (0.274)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '137'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
213 (0.222)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
214 (0.199)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
215 (0.206)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/notification'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
216 (0.273)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
217 (0.376)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '56'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
218 (0.269)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
219 (0.256)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
220 (0.253)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/header_notice'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
221 (0.227)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
222 (0.219)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
223 (0.242)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
224 (0.209)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
225 (0.444)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '3'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
226 (3.291)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
227 (0.553)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
228 (0.789)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
229 (0.437)
SELECT *
FROM oc_journal3_setting
WHERE store_id = '0' AND `setting_name` = 'blogPageKeyword'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/blog.php:621
230 (0.894)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
231 (5.529)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '618' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
232 (0.967)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
233 (1.442)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
234 (0.630)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
235 (0.640)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=618' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
236 (5.160)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '561' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
237 (0.918)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
238 (1.347)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
239 (0.706)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
240 (0.604)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=561' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
241 (0.374)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
242 (0.430)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '69'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
243 (5.771)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '74' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
244 (0.921)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
245 (1.380)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
246 (0.689)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
247 (0.518)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
248 (0.807)
SELECT COUNT(*) AS total
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 = '74' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:126
249 (5.712)
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 = '74' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 5
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:150
250 (0.719)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
251 (0.545)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
252 (0.711)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
253 (0.540)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
254 (0.742)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
255 (0.573)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
256 (0.636)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
257 (0.556)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
258 (0.648)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
259 (0.549)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
260 (5.410)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '75' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
261 (0.938)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
262 (1.432)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
263 (0.707)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
264 (0.537)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
265 (0.805)
SELECT COUNT(*) AS total
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 = '75' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:126
266 (5.931)
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 = '75' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 5
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:150
267 (0.719)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
268 (0.555)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
269 (0.622)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
270 (0.554)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
271 (0.720)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
272 (0.573)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
273 (0.711)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
274 (0.558)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
275 (0.736)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
276 (0.507)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
277 (5.385)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '420' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
278 (0.998)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
279 (1.363)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
280 (0.647)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
281 (0.557)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
282 (0.626)
SELECT COUNT(*) AS total
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 = '420' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:126
283 (5.589)
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 = '420' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 5
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:150
284 (0.625)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
285 (0.477)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
286 (0.704)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
287 (0.536)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
288 (0.715)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
289 (0.564)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
290 (5.738)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '76' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
291 (1.007)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
292 (1.373)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
293 (0.735)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
294 (0.485)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
295 (0.721)
SELECT COUNT(*) AS total
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 = '76' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:126
296 (5.667)
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 = '76' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 5
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:150
297 (0.757)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
298 (0.478)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
299 (0.707)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
300 (0.563)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
301 (0.642)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
302 (0.579)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
303 (0.715)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
304 (0.499)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
305 (5.392)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '77' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
306 (1.031)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
307 (1.415)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
308 (0.670)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
309 (0.476)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
310 (0.766)
SELECT COUNT(*) AS total
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 = '77' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:126
311 (5.443)
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 = '77' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 5
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:150
312 (0.631)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
313 (0.565)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
314 (0.637)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
315 (0.511)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
316 (0.625)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
317 (0.485)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
318 (0.625)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
319 (1.024)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
320 (0.726)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
321 (0.555)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
322 (5.623)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '606' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
323 (0.869)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
324 (1.331)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
325 (0.720)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
326 (0.576)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
327 (0.685)
SELECT COUNT(*) AS total
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 = '606' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:126
328 (5.267)
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 = '606' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 5
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:150
329 (0.717)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
330 (0.519)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
331 (0.687)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
332 (0.565)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
333 (5.151)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '602' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
334 (0.932)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
335 (1.357)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
336 (0.732)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
337 (0.545)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
338 (0.645)
SELECT COUNT(*) AS total
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 = '602' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:126
339 (5.470)
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 = '602' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 5
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:150
340 (0.636)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
341 (0.576)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
342 (0.716)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
343 (0.560)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
344 (0.718)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
345 (0.575)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
346 (0.634)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
347 (0.554)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
348 (0.631)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
349 (0.575)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
350 (5.134)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '148' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
351 (0.899)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
352 (1.337)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
353 (0.635)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
354 (0.590)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
355 (0.710)
SELECT COUNT(*) AS total
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 = '148' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:126
356 (5.358)
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 = '148' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 5
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/category.php:150
357 (0.647)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
358 (0.581)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
359 (0.634)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
360 (0.559)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
361 (0.635)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
362 (0.558)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
363 (0.635)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
364 (0.559)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
365 (5.392)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '620' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
366 (1.021)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
367 (1.496)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
368 (1.065)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
369 (0.541)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
370 (1.236)
SELECT COUNT(DISTINCT p.product_id) total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '620'
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
371 (2.409)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '620' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 5
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
372 (9.116)
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 = '8' 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 = '8' 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 = '8') 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 IN (10879,2925,10944,10346,10637) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
373 (0.813)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
374 (0.557)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
375 (0.730)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10879' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
376 (0.614)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
377 (0.488)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
378 (0.819)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=2925' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
379 (0.651)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
380 (0.483)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
381 (0.754)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10944' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
382 (0.613)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
383 (0.587)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
384 (0.692)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10346' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
385 (0.612)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
386 (0.470)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
387 (0.574)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10637' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
388 (5.507)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '618' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/catalog/category.php:4
389 (0.886)
SELECT *
FROM oc_extension
ORDER BY code
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/extension/module/d_seo_module.php:13
390 (1.371)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/setting/setting.php:6
391 (0.869)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
392 (0.545)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
393 (1.760)
SELECT COUNT(DISTINCT p.product_id) total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '618'
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
394 (5.896)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '618' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 5
/home/torshammar/domains/torshammarens.se/public_html/system/library/journal3/opencart/model.php:38
395 (8.923)
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 = '8' 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 = '8' 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 = '8') 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 IN (11009,10989,10990,10988,11004) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
396 (0.768)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
397 (0.582)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
398 (0.831)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=11009' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
399 (0.560)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
400 (0.551)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
401 (0.760)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10989' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
402 (0.638)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
403 (0.513)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
404 (0.762)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10990' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
405 (0.634)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
406 (0.490)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
407 (0.710)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10988' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
408 (0.792)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
409 (0.501)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:224
410 (0.733)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=11004' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
411 (0.470)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
412 (0.340)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
413 (0.392)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/catalog'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
414 (0.298)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
415 (0.251)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
416 (0.321)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
417 (0.333)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
418 (0.354)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
419 (0.495)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '412'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
420 (9.529)
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 = '8' 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 = '8' 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 = '8') 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 IN (10989,11007,11009,10993,10998) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/product.php:27
421 (0.676)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
422 (0.815)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10989' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
423 (0.672)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
424 (0.824)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=11007' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
425 (0.597)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
426 (0.721)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=11009' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
427 (0.643)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
428 (0.797)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10993' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
429 (1.000)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
430 (0.823)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=10998' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:183
431 (0.374)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
432 (0.344)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
433 (0.431)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/products'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
434 (0.404)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
435 (0.521)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '445'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
436 (0.459)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
437 (0.241)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
438 (0.289)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/blocks'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
439 (0.374)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
440 (0.290)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
441 (0.290)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
442 (0.330)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
443 (0.296)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
444 (0.310)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
445 (0.315)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
446 (0.287)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
447 (0.316)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
448 (0.405)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '2'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
449 (0.790)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
450 (0.487)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
451 (0.246)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
452 (0.249)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
453 (0.236)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
454 (0.281)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '240'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
455 (0.510)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
456 (0.536)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '2'
/home/torshammar/domains/torshammarens.se/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_startup_seo_url.php:212
457 (0.260)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/oneall' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
458 (0.210)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oneall_widget'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
459 (0.299)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/theme.php:4
460 (0.319)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
461 (0.278)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '0'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
462 (0.317)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'sv-se')
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/design/translation.php:6
463 (0.428)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '13'
/home/torshammar/domains/torshammarens.se/public_html/catalog/model/journal3/module.php:8
464 (0.664)</