Total memory used: 61.82 MB
1 (0.044)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.138)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (1.079)
SELECT *
FROM `oc_setting`
WHERE `store_id` = '0' OR `store_id` = 0
ORDER BY `store_id` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/setting.php:5
4 (0.064)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.134)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '8a3596d2d0ad24d74f571cc14b' AND `expire` > '2025-06-01 04:59:41'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (42.739)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '' OR `keyword` LIKE '%/') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
7 (69.811)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'en' OR `keyword` LIKE '%/en') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
8 (82.371)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'product' OR `keyword` LIKE '%/product') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
9 (82.078)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'jackets' OR `keyword` LIKE '%/jackets') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (82.516)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer' OR `keyword` LIKE '%/021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
11 (0.269)
SELECT *
FROM `oc_currency`
/home/gajcom/htdocs/gajcom.si/system/library/cart/currency.php:10
12 (0.408)
SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'shipping' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC
/home/gajcom/htdocs/gajcom.si/system/library/cart/tax.php:12
13 (0.237)
SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'store' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC
/home/gajcom/htdocs/gajcom.si/system/library/cart/tax.php:40
14 (0.167)
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` = '1'
/home/gajcom/htdocs/gajcom.si/system/library/cart/weight.php:10
15 (0.132)
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` = '1'
/home/gajcom/htdocs/gajcom.si/system/library/cart/length.php:10
16 (0.317)
DELETE
FROM `oc_cart`
WHERE (`api_id` > '0' OR `customer_id` = '0') AND `date_added` < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:15
17 (0.220)
SELECT DISTINCT `extension`
FROM `oc_extension`
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:5
18 (0.126)
SELECT *
FROM `oc_startup`
WHERE `status` = '1'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/startup.php:5
19 (0.199)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (69.406)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'en' OR `keyword` LIKE '%/en') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
21 (64.436)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'product' OR `keyword` LIKE '%/product') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
22 (68.986)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'jackets' OR `keyword` LIKE '%/jackets') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (65.209)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer' OR `keyword` LIKE '%/021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.369)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
25 (0.117)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
26 (0.219)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/product' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
27 (0.157)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'en-gb' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
28 (0.137)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
29 (0.085)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
30 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
31 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12026' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
32 (0.254)
SELECT *
FROM `oc_event`
WHERE `status` = '1'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/event.php:5
33 (0.893)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (12026) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
34 (0.165)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (12026)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
35 (0.224)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (12026)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
36 (17.078)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
37 (1.048)
SELECT DISTINCT *, pd.`name` AS name, p.`image`, m.`name` AS manufacturer, (SELECT `price`
FROM `oc_product_discount` pd2
WHERE pd2.`product_id` = p.`product_id` AND pd2.`customer_group_id` = '1' AND pd2.`quantity` = '1' AND ((pd2.`date_start` = '0000-00-00' OR pd2.`date_start` < NOW()) AND (pd2.`date_end` = '0000-00-00' OR pd2.`date_end` > NOW()))
ORDER BY pd2.`priority` ASC, pd2.`price` ASC LIMIT 1) AS `discount`, (SELECT `price`
FROM `oc_product_special` ps
WHERE ps.`product_id` = p.`product_id` AND ps.`customer_group_id` = '1' AND ((ps.`date_start` = '0000-00-00' OR ps.`date_start` < NOW()) AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > NOW()))
ORDER BY ps.`priority` ASC, ps.`price` ASC LIMIT 1) AS `special`, (SELECT `points`
FROM `oc_product_reward` pr
WHERE pr.`product_id` = p.`product_id` AND pr.`customer_group_id` = '1') AS `reward`, (SELECT ss.`name`
FROM `oc_stock_status` ss
WHERE ss.`stock_status_id` = p.`stock_status_id` AND ss.`language_id` = '1') 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` = '1') 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` = '1') 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` = '12026' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:6
38 (0.365)
SELECT ag.`attribute_group_id`, agd.`name`
FROM `oc_product_attribute` pa
LEFT JOIN `oc_attribute` a ON (pa.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_group` ag ON (a.`attribute_group_id` = ag.`attribute_group_id`)
LEFT JOIN `oc_attribute_group_description` agd ON (ag.`attribute_group_id` = agd.`attribute_group_id`)
WHERE pa.`product_id` = '12026' AND agd.`language_id` = '1' GROUP BY ag.`attribute_group_id`
ORDER BY ag.`sort_order`, agd.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:255
39 (0.233)
SELECT a.`attribute_id`, ad.`name`, pa.`text`
FROM `oc_product_attribute` pa
LEFT JOIN `oc_attribute` a ON (pa.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_description` ad ON (a.`attribute_id` = ad.`attribute_id`)
WHERE pa.`product_id` = '12026' AND a.`attribute_group_id` = '14' AND ad.`language_id` = '1' AND pa.`language_id` = '1'
ORDER BY a.`sort_order`, ad.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:260
40 (0.154)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_blocks_attributes'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
41 (0.178)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
42 (0.239)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/login' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
43 (0.221)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/register' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
44 (0.169)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_blocks_reviews'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
45 (0.191)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
46 (0.168)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
47 (0.199)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
48 (0.166)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
49 (0.144)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
50 (0.145)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/form'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
51 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
52 (0.175)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
53 (0.156)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
54 (0.151)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
55 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
56 (0.139)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
57 (0.129)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
58 (0.146)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
59 (0.158)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/gajcom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
60 (0.207)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
61 (0.238)
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` = '230' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/category.php:7
62 (0.271)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/category' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
63 (0.202)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
64 (0.676)
SELECT DISTINCT *, pd.`name` AS name, p.`image`, m.`name` AS manufacturer, (SELECT `price`
FROM `oc_product_discount` pd2
WHERE pd2.`product_id` = p.`product_id` AND pd2.`customer_group_id` = '1' AND pd2.`quantity` = '1' AND ((pd2.`date_start` = '0000-00-00' OR pd2.`date_start` < NOW()) AND (pd2.`date_end` = '0000-00-00' OR pd2.`date_end` > NOW()))
ORDER BY pd2.`priority` ASC, pd2.`price` ASC LIMIT 1) AS `discount`, (SELECT `price`
FROM `oc_product_special` ps
WHERE ps.`product_id` = p.`product_id` AND ps.`customer_group_id` = '1' AND ((ps.`date_start` = '0000-00-00' OR ps.`date_start` < NOW()) AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > NOW()))
ORDER BY ps.`priority` ASC, ps.`price` ASC LIMIT 1) AS `special`, (SELECT `points`
FROM `oc_product_reward` pr
WHERE pr.`product_id` = p.`product_id` AND pr.`customer_group_id` = '1') AS `reward`, (SELECT ss.`name`
FROM `oc_stock_status` ss
WHERE ss.`stock_status_id` = p.`stock_status_id` AND ss.`language_id` = '1') 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` = '1') 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` = '1') 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` = '12026' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:6
65 (0.166)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
66 (0.213)
SELECT *
FROM oc_category c
WHERE c.`category_id` IN (SELECT oc_product_to_category.category_id
FROM oc_product_to_category
WHERE oc_product_to_category.product_id='12026')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
67 (0.161)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
68 (0.109)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
69 (0.211)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
70 (0.148)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
71 (0.102)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
72 (0.180)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
73 (0.200)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer|info' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
74 (0.180)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '9' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
75 (0.159)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
76 (0.202)
SELECT COUNT(*) AS `total`
FROM `oc_review` r
LEFT JOIN `oc_product` p ON (r.`product_id` = p.`product_id`)
LEFT JOIN `oc_product_description` pd ON (p.`product_id` = pd.`product_id`)
WHERE p.`product_id` = '12026' AND p.`date_available` <= NOW() AND p.`status` = '1' AND r.`status` = '1' AND pd.`language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/review.php:25
77 (0.205)
SELECT r.`author`, r.`rating`, r.`text`, r.`date_added`
FROM `oc_review` r
LEFT JOIN `oc_product` p ON (r.`product_id` = p.`product_id`)
LEFT JOIN `oc_product_description` pd ON (p.`product_id` = pd.`product_id`)
WHERE r.`product_id` = '12026' AND p.`date_available` <= NOW() AND p.`status` = '1' AND r.`status` = '1' AND pd.`language_id` = '1'
ORDER BY r.`date_added` DESC LIMIT 0,5
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/review.php:19
78 (0.182)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/review|list' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
79 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '{page}' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
80 (0.136)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'product/review_list'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
81 (0.160)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
82 (0.137)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
83 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
84 (0.138)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
85 (0.208)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/wishlist|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
86 (0.188)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/compare|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
87 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'tool/upload' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
88 (0.212)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '12026'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
89 (0.339)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '12026' AND `customer_group_id` = '1' AND `quantity` > 1 AND ((`date_start` = '0000-00-00' OR `date_start` < NOW()) AND (`date_end` = '0000-00-00' OR `date_end` > NOW()))
ORDER BY `quantity` ASC, `priority` ASC, `price` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:328
90 (0.446)
SELECT *
FROM `oc_product_option` po
LEFT JOIN `oc_option` o ON (po.`option_id` = o.`option_id`)
LEFT JOIN `oc_option_description` od ON (o.`option_id` = od.`option_id`)
WHERE po.`product_id` = '12026' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
91 (0.388)
SELECT *
FROM `oc_product_option_value` pov
LEFT JOIN `oc_option_value` ov ON (pov.`option_value_id` = ov.`option_value_id`)
LEFT JOIN `oc_option_value_description` ovd ON (ov.`option_value_id` = ovd.`option_value_id`)
WHERE pov.`product_id` = '12026' AND pov.`product_option_id` = '19207' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
92 (0.972)
SELECT *
FROM `oc_product_option_value` pov
LEFT JOIN `oc_option_value` ov ON (pov.`option_value_id` = ov.`option_value_id`)
LEFT JOIN `oc_option_value_description` ovd ON (ov.`option_value_id` = ovd.`option_value_id`)
WHERE pov.`product_id` = '12026' AND pov.`product_option_id` = '19208' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
93 (0.233)
SELECT *
FROM `oc_product_subscription` ps
LEFT JOIN `oc_subscription_plan` sp ON (ps.`subscription_plan_id` = sp.`subscription_plan_id`)
LEFT JOIN `oc_subscription_plan_description` spd ON (sp.`subscription_plan_id` = spd.`subscription_plan_id`)
WHERE ps.`product_id` = '12026' AND ps.`customer_group_id` = '1' AND spd.`language_id` = '1' AND sp.`status` = '1'
ORDER BY sp.`sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:486
94 (0.165)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
95 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
96 (0.192)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
97 (0.250)
SELECT ag.`attribute_group_id`, agd.`name`
FROM `oc_product_attribute` pa
LEFT JOIN `oc_attribute` a ON (pa.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_group` ag ON (a.`attribute_group_id` = ag.`attribute_group_id`)
LEFT JOIN `oc_attribute_group_description` agd ON (ag.`attribute_group_id` = agd.`attribute_group_id`)
WHERE pa.`product_id` = '12026' AND agd.`language_id` = '1' GROUP BY ag.`attribute_group_id`
ORDER BY ag.`sort_order`, agd.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:255
98 (0.296)
SELECT a.`attribute_id`, ad.`name`, pa.`text`
FROM `oc_product_attribute` pa
LEFT JOIN `oc_attribute` a ON (pa.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_description` ad ON (a.`attribute_id` = ad.`attribute_id`)
WHERE pa.`product_id` = '12026' AND a.`attribute_group_id` = '14' AND ad.`language_id` = '1' AND pa.`language_id` = '1'
ORDER BY a.`sort_order`, ad.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:260
99 (0.341)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/search' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
100 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'James ' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
101 (0.301)
SELECT *
FROM `oc_seo_url`
WHERE `key` = ' Nicholson | JN 1327 | Ladies\' Stretch Fleece Bodywarmer' AND `value` = '' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
102 (0.199)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = '02.1327' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
103 (0.162)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Jackets' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
104 (0.100)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '12026' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
105 (0.135)
SELECT *
FROM `oc_layout_route`
WHERE 'product/product' LIKE `route` AND `store_id` = '0'
ORDER BY `route` DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/catalog/model/design/layout.php:5
106 (0.120)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
107 (0.309)
SELECT *
FROM `oc_product_related` pr
LEFT JOIN `oc_product` p ON (pr.related_id = p.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
pr.product_id IN (12026)
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:181
108 (1.016)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (2885,2886,2889,2897,2932,2933,2939,11570,11623) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
109 (0.265)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (2885,2886,2889,2897,2932,2933,2939,11570,11623)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
110 (0.689)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (2885,2886,2889,2897,2932,2933,2939,11570,11623)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
111 (0.255)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2885'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
112 (0.208)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
113 (0.234)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
114 (0.152)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2885' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
115 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2886'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
116 (0.181)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
117 (0.282)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
118 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2886' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
119 (0.513)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2889'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
120 (0.094)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
121 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
122 (0.153)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2889' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
123 (0.108)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2897'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
124 (0.182)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
125 (0.297)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
126 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2897' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
127 (0.128)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2932'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
128 (0.172)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
129 (0.208)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
130 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2932' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
131 (0.108)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2933'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
132 (0.187)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
133 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
134 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2933' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
135 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2939'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
136 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
137 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
138 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2939' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
139 (0.124)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11570'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
140 (0.086)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
141 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
142 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11570' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
143 (0.343)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11623'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
144 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
145 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
146 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11623' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
147 (0.522)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
148 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
149 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
150 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
151 (0.098)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
152 (0.107)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
153 (0.097)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
154 (0.142)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
155 (0.097)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
156 (15.349)
SELECT *
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_product_to_category` p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.category_id IN (230)
AND p.status = '1'
AND p.date_available <= NOW()
AND pd.language_id = '1'
AND p2s.store_id = '0'
AND c.status = '1'
AND c2s.store_id = '0'
AND p.product_id != '12026'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
157 (3.974)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (11926,11572,14533,14410,14340,14400,11570,11623,14569,3492) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
158 (1.173)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (11926,11572,14533,14410,14340,14400,11570,11623,14569,3492)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
159 (2.050)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (11926,11572,14533,14410,14340,14400,11570,11623,14569,3492)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
160 (0.395)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11926'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
161 (0.100)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
162 (0.660)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
163 (0.235)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11926' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
164 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11572'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
165 (0.227)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
166 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
167 (0.364)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11572' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
168 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14533'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
169 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
170 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
171 (0.152)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14533' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
172 (0.129)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14410'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
173 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
174 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
175 (0.188)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14410' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
176 (0.190)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14340'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
177 (0.084)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
178 (0.207)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
179 (0.236)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14340' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
180 (0.209)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14400'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
181 (0.095)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
182 (0.233)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
183 (0.165)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14400' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
184 (0.138)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11570'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
185 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
186 (0.160)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
187 (0.232)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11623'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
188 (0.102)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
189 (0.163)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
190 (0.178)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14569'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
191 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
192 (0.177)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
193 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14569' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
194 (0.176)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3492'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
195 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
196 (0.136)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
197 (0.262)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '3492' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
198 (0.135)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
199 (0.128)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
200 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
201 (0.192)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
202 (0.143)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
203 (0.215)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
204 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
205 (0.120)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
206 (0.177)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
207 (0.142)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
208 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
209 (0.202)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
210 (0.134)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
211 (0.154)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/notification'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
212 (0.197)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/header_notice'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
213 (0.162)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
214 (0.188)
SELECT
p.product_id
FROM `oc_product` p
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p.product_id IN (12026)
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:408
215 (0.584)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (12026) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
216 (0.167)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (12026)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
217 (0.186)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (12026)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
218 (0.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
219 (0.085)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
220 (0.174)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
221 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
222 (0.135)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '430'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
223 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
224 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
225 (0.163)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '430' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
226 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '431'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
227 (0.076)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '229'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
228 (0.153)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '229' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
229 (0.168)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '431' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
230 (0.123)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '440'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
231 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '289'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
232 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '286'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
233 (0.062)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '254'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
234 (0.172)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_286_289' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
235 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '440' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
236 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '442'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
237 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
238 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
239 (0.152)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '442' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
240 (0.120)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '443'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
241 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
242 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
243 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '443' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
244 (0.127)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '444'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
245 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '369'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
246 (0.067)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '255'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
247 (0.101)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '254'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
248 (0.181)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_255_369' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
249 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '444' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
250 (0.121)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
251 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
252 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
253 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '449' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
254 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
255 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
256 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
257 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '450' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
258 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
259 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
260 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
261 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
262 (0.127)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
263 (0.127)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
264 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
265 (0.111)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
266 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
267 (0.164)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/image'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
268 (0.127)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
269 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/catalog'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
270 (0.198)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/newsletter'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
271 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
272 (0.120)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/icons_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
273 (0.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
274 (0.105)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
275 (0.167)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/contact' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
276 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/returns|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
277 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/gdpr' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
278 (0.135)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/sitemap' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
279 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
280 (0.125)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/voucher' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
281 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/special' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
282 (0.126)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/account' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
283 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/order' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
284 (0.126)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/wishlist' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
285 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/newsletter' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
286 (0.306)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 05:59:42'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
287 (0.180)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.231', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/jackets/021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer', `referer` = 'https://gajcom.si/product/jackets/021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer', `date_added` = '2025-06-01 06:59:42'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
288 (0.181)
SELECT DISTINCT *
FROM `oc_information` i
LEFT JOIN `oc_information_description` id ON (i.`information_id` = id.`information_id`)
LEFT JOIN `oc_information_to_store` i2s ON (i.`information_id` = i2s.`information_id`)
WHERE i.`information_id` = '3' AND id.`language_id` = '1' AND i2s.`store_id` = '0' AND i.`status` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/information.php:5
289 (0.507)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
290 (0.326)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/information|info' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
291 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'information_id' AND `value` = '3' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
292 (0.167)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/cookie|confirm' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
293 (0.177)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'agree' AND `value` = '1' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
294 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'agree' AND `value` = '0' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
295 (0.086)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
296 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
Total memory used: 80.14 MB
1 (0.044)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.138)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (1.079)
SELECT *
FROM `oc_setting`
WHERE `store_id` = '0' OR `store_id` = 0
ORDER BY `store_id` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/setting.php:5
4 (0.064)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.134)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '8a3596d2d0ad24d74f571cc14b' AND `expire` > '2025-06-01 04:59:41'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (42.739)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '' OR `keyword` LIKE '%/') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
7 (69.811)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'en' OR `keyword` LIKE '%/en') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
8 (82.371)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'product' OR `keyword` LIKE '%/product') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
9 (82.078)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'jackets' OR `keyword` LIKE '%/jackets') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (82.516)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer' OR `keyword` LIKE '%/021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
11 (0.269)
SELECT *
FROM `oc_currency`
/home/gajcom/htdocs/gajcom.si/system/library/cart/currency.php:10
12 (0.408)
SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'shipping' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC
/home/gajcom/htdocs/gajcom.si/system/library/cart/tax.php:12
13 (0.237)
SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'store' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC
/home/gajcom/htdocs/gajcom.si/system/library/cart/tax.php:40
14 (0.167)
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` = '1'
/home/gajcom/htdocs/gajcom.si/system/library/cart/weight.php:10
15 (0.132)
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` = '1'
/home/gajcom/htdocs/gajcom.si/system/library/cart/length.php:10
16 (0.317)
DELETE
FROM `oc_cart`
WHERE (`api_id` > '0' OR `customer_id` = '0') AND `date_added` < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:15
17 (0.220)
SELECT DISTINCT `extension`
FROM `oc_extension`
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:5
18 (0.126)
SELECT *
FROM `oc_startup`
WHERE `status` = '1'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/startup.php:5
19 (0.199)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (69.406)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'en' OR `keyword` LIKE '%/en') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
21 (64.436)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'product' OR `keyword` LIKE '%/product') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
22 (68.986)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'jackets' OR `keyword` LIKE '%/jackets') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (65.209)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer' OR `keyword` LIKE '%/021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.369)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
25 (0.117)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
26 (0.219)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/product' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
27 (0.157)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'en-gb' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
28 (0.137)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
29 (0.085)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
30 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
31 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12026' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
32 (0.254)
SELECT *
FROM `oc_event`
WHERE `status` = '1'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/event.php:5
33 (0.893)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (12026) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
34 (0.165)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (12026)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
35 (0.224)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (12026)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
36 (17.078)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
37 (1.048)
SELECT DISTINCT *, pd.`name` AS name, p.`image`, m.`name` AS manufacturer, (SELECT `price`
FROM `oc_product_discount` pd2
WHERE pd2.`product_id` = p.`product_id` AND pd2.`customer_group_id` = '1' AND pd2.`quantity` = '1' AND ((pd2.`date_start` = '0000-00-00' OR pd2.`date_start` < NOW()) AND (pd2.`date_end` = '0000-00-00' OR pd2.`date_end` > NOW()))
ORDER BY pd2.`priority` ASC, pd2.`price` ASC LIMIT 1) AS `discount`, (SELECT `price`
FROM `oc_product_special` ps
WHERE ps.`product_id` = p.`product_id` AND ps.`customer_group_id` = '1' AND ((ps.`date_start` = '0000-00-00' OR ps.`date_start` < NOW()) AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > NOW()))
ORDER BY ps.`priority` ASC, ps.`price` ASC LIMIT 1) AS `special`, (SELECT `points`
FROM `oc_product_reward` pr
WHERE pr.`product_id` = p.`product_id` AND pr.`customer_group_id` = '1') AS `reward`, (SELECT ss.`name`
FROM `oc_stock_status` ss
WHERE ss.`stock_status_id` = p.`stock_status_id` AND ss.`language_id` = '1') 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` = '1') 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` = '1') 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` = '12026' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:6
38 (0.365)
SELECT ag.`attribute_group_id`, agd.`name`
FROM `oc_product_attribute` pa
LEFT JOIN `oc_attribute` a ON (pa.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_group` ag ON (a.`attribute_group_id` = ag.`attribute_group_id`)
LEFT JOIN `oc_attribute_group_description` agd ON (ag.`attribute_group_id` = agd.`attribute_group_id`)
WHERE pa.`product_id` = '12026' AND agd.`language_id` = '1' GROUP BY ag.`attribute_group_id`
ORDER BY ag.`sort_order`, agd.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:255
39 (0.233)
SELECT a.`attribute_id`, ad.`name`, pa.`text`
FROM `oc_product_attribute` pa
LEFT JOIN `oc_attribute` a ON (pa.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_description` ad ON (a.`attribute_id` = ad.`attribute_id`)
WHERE pa.`product_id` = '12026' AND a.`attribute_group_id` = '14' AND ad.`language_id` = '1' AND pa.`language_id` = '1'
ORDER BY a.`sort_order`, ad.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:260
40 (0.154)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_blocks_attributes'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
41 (0.178)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
42 (0.239)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/login' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
43 (0.221)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/register' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
44 (0.169)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_blocks_reviews'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
45 (0.191)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
46 (0.168)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
47 (0.199)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
48 (0.166)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
49 (0.144)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
50 (0.145)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/form'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
51 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
52 (0.175)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
53 (0.156)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
54 (0.151)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
55 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
56 (0.139)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
57 (0.129)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
58 (0.146)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
59 (0.158)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/gajcom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
60 (0.207)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
61 (0.238)
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` = '230' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/category.php:7
62 (0.271)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/category' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
63 (0.202)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
64 (0.676)
SELECT DISTINCT *, pd.`name` AS name, p.`image`, m.`name` AS manufacturer, (SELECT `price`
FROM `oc_product_discount` pd2
WHERE pd2.`product_id` = p.`product_id` AND pd2.`customer_group_id` = '1' AND pd2.`quantity` = '1' AND ((pd2.`date_start` = '0000-00-00' OR pd2.`date_start` < NOW()) AND (pd2.`date_end` = '0000-00-00' OR pd2.`date_end` > NOW()))
ORDER BY pd2.`priority` ASC, pd2.`price` ASC LIMIT 1) AS `discount`, (SELECT `price`
FROM `oc_product_special` ps
WHERE ps.`product_id` = p.`product_id` AND ps.`customer_group_id` = '1' AND ((ps.`date_start` = '0000-00-00' OR ps.`date_start` < NOW()) AND (ps.`date_end` = '0000-00-00' OR ps.`date_end` > NOW()))
ORDER BY ps.`priority` ASC, ps.`price` ASC LIMIT 1) AS `special`, (SELECT `points`
FROM `oc_product_reward` pr
WHERE pr.`product_id` = p.`product_id` AND pr.`customer_group_id` = '1') AS `reward`, (SELECT ss.`name`
FROM `oc_stock_status` ss
WHERE ss.`stock_status_id` = p.`stock_status_id` AND ss.`language_id` = '1') 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` = '1') 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` = '1') 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` = '12026' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:6
65 (0.166)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
66 (0.213)
SELECT *
FROM oc_category c
WHERE c.`category_id` IN (SELECT oc_product_to_category.category_id
FROM oc_product_to_category
WHERE oc_product_to_category.product_id='12026')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
67 (0.161)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
68 (0.109)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
69 (0.211)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
70 (0.148)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
71 (0.102)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
72 (0.180)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
73 (0.200)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer|info' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
74 (0.180)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '9' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
75 (0.159)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
76 (0.202)
SELECT COUNT(*) AS `total`
FROM `oc_review` r
LEFT JOIN `oc_product` p ON (r.`product_id` = p.`product_id`)
LEFT JOIN `oc_product_description` pd ON (p.`product_id` = pd.`product_id`)
WHERE p.`product_id` = '12026' AND p.`date_available` <= NOW() AND p.`status` = '1' AND r.`status` = '1' AND pd.`language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/review.php:25
77 (0.205)
SELECT r.`author`, r.`rating`, r.`text`, r.`date_added`
FROM `oc_review` r
LEFT JOIN `oc_product` p ON (r.`product_id` = p.`product_id`)
LEFT JOIN `oc_product_description` pd ON (p.`product_id` = pd.`product_id`)
WHERE r.`product_id` = '12026' AND p.`date_available` <= NOW() AND p.`status` = '1' AND r.`status` = '1' AND pd.`language_id` = '1'
ORDER BY r.`date_added` DESC LIMIT 0,5
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/review.php:19
78 (0.182)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/review|list' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
79 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '{page}' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
80 (0.136)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'product/review_list'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
81 (0.160)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
82 (0.137)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
83 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
84 (0.138)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
85 (0.208)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/wishlist|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
86 (0.188)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/compare|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
87 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'tool/upload' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
88 (0.212)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '12026'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
89 (0.339)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '12026' AND `customer_group_id` = '1' AND `quantity` > 1 AND ((`date_start` = '0000-00-00' OR `date_start` < NOW()) AND (`date_end` = '0000-00-00' OR `date_end` > NOW()))
ORDER BY `quantity` ASC, `priority` ASC, `price` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:328
90 (0.446)
SELECT *
FROM `oc_product_option` po
LEFT JOIN `oc_option` o ON (po.`option_id` = o.`option_id`)
LEFT JOIN `oc_option_description` od ON (o.`option_id` = od.`option_id`)
WHERE po.`product_id` = '12026' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
91 (0.388)
SELECT *
FROM `oc_product_option_value` pov
LEFT JOIN `oc_option_value` ov ON (pov.`option_value_id` = ov.`option_value_id`)
LEFT JOIN `oc_option_value_description` ovd ON (ov.`option_value_id` = ovd.`option_value_id`)
WHERE pov.`product_id` = '12026' AND pov.`product_option_id` = '19207' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
92 (0.972)
SELECT *
FROM `oc_product_option_value` pov
LEFT JOIN `oc_option_value` ov ON (pov.`option_value_id` = ov.`option_value_id`)
LEFT JOIN `oc_option_value_description` ovd ON (ov.`option_value_id` = ovd.`option_value_id`)
WHERE pov.`product_id` = '12026' AND pov.`product_option_id` = '19208' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
93 (0.233)
SELECT *
FROM `oc_product_subscription` ps
LEFT JOIN `oc_subscription_plan` sp ON (ps.`subscription_plan_id` = sp.`subscription_plan_id`)
LEFT JOIN `oc_subscription_plan_description` spd ON (sp.`subscription_plan_id` = spd.`subscription_plan_id`)
WHERE ps.`product_id` = '12026' AND ps.`customer_group_id` = '1' AND spd.`language_id` = '1' AND sp.`status` = '1'
ORDER BY sp.`sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:486
94 (0.165)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
95 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
96 (0.192)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
97 (0.250)
SELECT ag.`attribute_group_id`, agd.`name`
FROM `oc_product_attribute` pa
LEFT JOIN `oc_attribute` a ON (pa.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_group` ag ON (a.`attribute_group_id` = ag.`attribute_group_id`)
LEFT JOIN `oc_attribute_group_description` agd ON (ag.`attribute_group_id` = agd.`attribute_group_id`)
WHERE pa.`product_id` = '12026' AND agd.`language_id` = '1' GROUP BY ag.`attribute_group_id`
ORDER BY ag.`sort_order`, agd.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:255
98 (0.296)
SELECT a.`attribute_id`, ad.`name`, pa.`text`
FROM `oc_product_attribute` pa
LEFT JOIN `oc_attribute` a ON (pa.`attribute_id` = a.`attribute_id`)
LEFT JOIN `oc_attribute_description` ad ON (a.`attribute_id` = ad.`attribute_id`)
WHERE pa.`product_id` = '12026' AND a.`attribute_group_id` = '14' AND ad.`language_id` = '1' AND pa.`language_id` = '1'
ORDER BY a.`sort_order`, ad.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:260
99 (0.341)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/search' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
100 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'James ' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
101 (0.301)
SELECT *
FROM `oc_seo_url`
WHERE `key` = ' Nicholson | JN 1327 | Ladies\' Stretch Fleece Bodywarmer' AND `value` = '' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
102 (0.199)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = '02.1327' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
103 (0.162)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Jackets' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
104 (0.100)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '12026' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
105 (0.135)
SELECT *
FROM `oc_layout_route`
WHERE 'product/product' LIKE `route` AND `store_id` = '0'
ORDER BY `route` DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/catalog/model/design/layout.php:5
106 (0.120)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
107 (0.309)
SELECT *
FROM `oc_product_related` pr
LEFT JOIN `oc_product` p ON (pr.related_id = p.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
pr.product_id IN (12026)
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:181
108 (1.016)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (2885,2886,2889,2897,2932,2933,2939,11570,11623) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
109 (0.265)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (2885,2886,2889,2897,2932,2933,2939,11570,11623)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
110 (0.689)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (2885,2886,2889,2897,2932,2933,2939,11570,11623)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
111 (0.255)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2885'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
112 (0.208)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
113 (0.234)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
114 (0.152)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2885' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
115 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2886'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
116 (0.181)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
117 (0.282)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
118 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2886' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
119 (0.513)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2889'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
120 (0.094)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
121 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
122 (0.153)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2889' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
123 (0.108)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2897'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
124 (0.182)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
125 (0.297)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
126 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2897' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
127 (0.128)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2932'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
128 (0.172)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
129 (0.208)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
130 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2932' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
131 (0.108)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2933'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
132 (0.187)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
133 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
134 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2933' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
135 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '2939'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
136 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
137 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
138 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '2939' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
139 (0.124)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11570'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
140 (0.086)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
141 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
142 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11570' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
143 (0.343)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11623'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
144 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
145 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
146 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11623' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
147 (0.522)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
148 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
149 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
150 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
151 (0.098)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
152 (0.107)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
153 (0.097)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
154 (0.142)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
155 (0.097)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
156 (15.349)
SELECT *
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_product_to_category` p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.category_id IN (230)
AND p.status = '1'
AND p.date_available <= NOW()
AND pd.language_id = '1'
AND p2s.store_id = '0'
AND c.status = '1'
AND c2s.store_id = '0'
AND p.product_id != '12026'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
157 (3.974)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (11926,11572,14533,14410,14340,14400,11570,11623,14569,3492) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
158 (1.173)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (11926,11572,14533,14410,14340,14400,11570,11623,14569,3492)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
159 (2.050)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (11926,11572,14533,14410,14340,14400,11570,11623,14569,3492)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
160 (0.395)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11926'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
161 (0.100)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
162 (0.660)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
163 (0.235)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11926' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
164 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11572'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
165 (0.227)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
166 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
167 (0.364)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11572' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
168 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14533'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
169 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
170 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
171 (0.152)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14533' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
172 (0.129)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14410'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
173 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
174 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
175 (0.188)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14410' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
176 (0.190)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14340'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
177 (0.084)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
178 (0.207)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
179 (0.236)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14340' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
180 (0.209)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14400'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
181 (0.095)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
182 (0.233)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
183 (0.165)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14400' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
184 (0.138)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11570'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
185 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
186 (0.160)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
187 (0.232)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11623'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
188 (0.102)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
189 (0.163)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
190 (0.178)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14569'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
191 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
192 (0.177)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
193 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14569' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
194 (0.176)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3492'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
195 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
196 (0.136)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
197 (0.262)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '3492' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
198 (0.135)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
199 (0.128)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
200 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
201 (0.192)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
202 (0.143)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
203 (0.215)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
204 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
205 (0.120)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
206 (0.177)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
207 (0.142)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
208 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
209 (0.202)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
210 (0.134)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
211 (0.154)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/notification'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
212 (0.197)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/header_notice'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
213 (0.162)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
214 (0.188)
SELECT
p.product_id
FROM `oc_product` p
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p.product_id IN (12026)
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:408
215 (0.584)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (12026) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
216 (0.167)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (12026)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
217 (0.186)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (12026)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
218 (0.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
219 (0.085)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
220 (0.174)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
221 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
222 (0.135)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '430'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
223 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
224 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
225 (0.163)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '430' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
226 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '431'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
227 (0.076)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '229'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
228 (0.153)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '229' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
229 (0.168)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '431' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
230 (0.123)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '440'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
231 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '289'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
232 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '286'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
233 (0.062)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '254'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
234 (0.172)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_286_289' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
235 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '440' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
236 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '442'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
237 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
238 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
239 (0.152)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '442' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
240 (0.120)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '443'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
241 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
242 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
243 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '443' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
244 (0.127)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '444'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
245 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '369'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
246 (0.067)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '255'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
247 (0.101)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '254'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
248 (0.181)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_255_369' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
249 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '444' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
250 (0.121)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
251 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
252 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
253 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '449' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
254 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
255 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
256 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
257 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '450' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
258 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
259 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
260 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
261 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
262 (0.127)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
263 (0.127)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
264 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
265 (0.111)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
266 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
267 (0.164)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/image'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
268 (0.127)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
269 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/catalog'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
270 (0.198)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/newsletter'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
271 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
272 (0.120)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/icons_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
273 (0.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
274 (0.105)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
275 (0.167)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/contact' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
276 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/returns|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
277 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/gdpr' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
278 (0.135)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/sitemap' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
279 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
280 (0.125)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/voucher' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
281 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/special' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
282 (0.126)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/account' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
283 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/order' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
284 (0.126)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/wishlist' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
285 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/newsletter' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
286 (0.306)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 05:59:42'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
287 (0.180)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.231', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/jackets/021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer', `referer` = 'https://gajcom.si/product/jackets/021327-james-and-nicholson-jn-1327-ladies-stretch-fleece-bodywarmer', `date_added` = '2025-06-01 06:59:42'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
288 (0.181)
SELECT DISTINCT *
FROM `oc_information` i
LEFT JOIN `oc_information_description` id ON (i.`information_id` = id.`information_id`)
LEFT JOIN `oc_information_to_store` i2s ON (i.`information_id` = i2s.`information_id`)
WHERE i.`information_id` = '3' AND id.`language_id` = '1' AND i2s.`store_id` = '0' AND i.`status` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/information.php:5
289 (0.507)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
290 (0.326)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/information|info' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
291 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'information_id' AND `value` = '3' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
292 (0.167)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/cookie|confirm' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
293 (0.177)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'agree' AND `value` = '1' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
294 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'agree' AND `value` = '0' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
295 (0.086)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
296 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
297 (0.099)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
298 (0.134)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
299 (0.136)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
300 (0.234)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
301 (0.120)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
302 (0.122)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
303 (0.140)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
304 (0.103)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
305 (0.507)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
306 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/main_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
307 (0.147)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
308 (0.229)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
309 (0.162)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4338'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
310 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
311 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
312 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4338' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
313 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '3' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
314 (0.236)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '454'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
315 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
316 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
317 (0.226)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '454' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
318 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '8' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
319 (0.102)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4399'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
320 (0.071)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
321 (0.121)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
322 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4399' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
323 (0.132)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5932'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
324 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
325 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
326 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5932' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
327 (0.136)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '51' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
328 (0.109)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4882'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
329 (0.075)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
330 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
331 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4882' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
332 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '28' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
333 (0.099)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
334 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
335 (0.096)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
336 (0.091)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
337 (0.092)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
338 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '1305'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
339 (0.131)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
340 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
341 (0.153)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '1305' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
342 (0.111)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11201'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
343 (0.076)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
344 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
345 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11201' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
346 (0.140)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '4' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
347 (0.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5306'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
348 (0.130)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
349 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
350 (0.153)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5306' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
351 (0.237)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '42' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
352 (0.182)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3473'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
353 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
354 (0.124)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
355 (0.175)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '3473' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
356 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '15' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
357 (0.106)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4399'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
358 (0.103)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
359 (0.210)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
360 (0.106)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12731'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
361 (0.190)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
362 (0.140)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
363 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12731' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
364 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '122' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
365 (0.102)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
366 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
367 (0.177)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
368 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
369 (0.118)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
370 (0.201)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
371 (0.200)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12723'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
372 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
373 (0.191)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
374 (0.128)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12723' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
375 (0.097)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4414'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
376 (0.071)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
377 (0.185)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
378 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4414' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
379 (0.108)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11632'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
380 (0.150)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
381 (0.135)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
382 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11632' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
383 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '113' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
384 (0.195)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5381'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
385 (0.212)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
386 (0.183)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
387 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5381' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
388 (0.238)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '21' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
389 (0.109)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5419'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
390 (0.255)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
391 (0.225)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
392 (0.132)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5419' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
393 (0.122)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '532'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
394 (0.199)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
395 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
396 (0.225)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '532' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
397 (0.095)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
398 (0.160)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
399 (0.138)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
400 (0.209)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
401 (0.117)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
402 (0.166)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
403 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
404 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
405 (0.100)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
406 (0.120)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
407 (0.107)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
408 (0.105)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
409 (0.201)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10407'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
410 (0.085)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
411 (0.118)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
412 (0.170)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '10407' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
413 (0.108)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
414 (0.076)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
415 (0.194)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
416 (0.108)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
417 (0.173)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
418 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
419 (0.103)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
420 (0.097)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
421 (0.083)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
422 (0.183)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '666'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
423 (0.099)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
424 (0.217)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
425 (0.187)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '666' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
426 (0.100)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '665'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
427 (0.075)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
428 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
429 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '665' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
430 (0.168)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '673'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
431 (0.071)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
432 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
433 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '673' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
434 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
435 (0.080)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
436 (0.128)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
437 (0.097)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
438 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
439 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
440 (0.100)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
441 (0.098)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/image'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
442 (0.111)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/text'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
443 (0.117)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
444 (0.826)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
445 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
446 (0.134)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/main_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
447 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/main_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
448 (0.324)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
449 (0.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
450 (0.122)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
451 (0.124)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
452 (0.147)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/image'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
453 (0.229)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/text'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
454 (0.204)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
455 (0.110)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
456 (0.255)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10407'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
457 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
458 (0.196)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
459 (0.134)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
460 (0.163)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
461 (0.185)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
462 (0.169)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
463 (0.242)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
464 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
465 (0.279)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
466 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
467 (0.144)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
468 (0.188)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '666'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
469 (0.095)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
470 (0.244)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
471 (0.112)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '665'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
472 (0.094)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
473 (0.221)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
474 (0.201)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '673'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
475 (0.185)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
476 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
477 (0.081)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
478 (0.210)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
479 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
480 (0.100)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
481 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
482 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
483 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
484 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
485 (0.113)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
486 (0.249)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
487 (0.128)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
488 (0.103)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
489 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
490 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
491 (0.103)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/main_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
492 (0.122)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
493 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
494 (0.102)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
495 (0.122)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/header'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
496 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/cart' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
497 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/checkout' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
498 (0.119)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/language'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
499 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
500 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'sl-SI' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
501 (0.250)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
502 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'de-de' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
503 (0.160)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/language'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
504 (0.268)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/currency'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
505 (0.276)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/currency|save' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
506 (0.187)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
507 (0.380)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
508 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
509 (0.107)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/currency'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
510 (0.184)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/search'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
511 (0.349)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'search' AND `value` = '' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
512 (0.440)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/search'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
513 (0.140)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/search'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
514 (0.134)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/cart'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
515 (0.141)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
516 (0.147)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
517 (0.137)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/sub_total'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
518 (0.116)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
519 (0.676)
SELECT *
FROM oc_setting
WHERE `code` = 'total_category_product_based_fee'
ORDER BY `key` ASC
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:1151
520 (0.130)
SELECT *
FROM oc_country
WHERE country_id = 190
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:90
521 (0.106)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
522 (0.125)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
523 (0.096)
SELECT *
FROM oc_country
WHERE country_id = 190
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:90
524 (0.066)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
525 (0.113)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
526 (0.079)
SELECT *
FROM oc_country
WHERE country_id = 190
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:90
527 (0.063)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
528 (0.104)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
529 (0.114)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
530 (0.300)
SELECT *
FROM oc_setting
WHERE `key` = 'config_currency' AND store_id = 0
ORDER BY setting_id DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:189
531 (0.138)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/credit'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
532 (0.122)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
533 (0.138)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
534 (0.161)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/total'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
535 (0.143)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
536 (0.122)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
537 (0.170)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/cart|info' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
538 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/cart|remove' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
539 (0.148)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/voucher|remove' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
540 (0.144)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
541 (0.114)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
542 (0.128)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/sub_total'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
543 (0.114)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
544 (0.640)
SELECT *
FROM oc_setting
WHERE `code` = 'total_category_product_based_fee'
ORDER BY `key` ASC
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:1151
545 (0.089)
SELECT *
FROM oc_country
WHERE country_id = 190
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:90
546 (0.072)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
547 (0.139)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
548 (0.081)
SELECT *
FROM oc_country
WHERE country_id = 190
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:90
549 (0.066)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
550 (0.105)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
551 (0.075)
SELECT *
FROM oc_country
WHERE country_id = 190
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:90
552 (0.068)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
553 (0.097)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
554 (0.108)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
555 (0.265)
SELECT *
FROM oc_setting
WHERE `key` = 'config_currency' AND store_id = 0
ORDER BY setting_id DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:189
556 (0.143)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/credit'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
557 (0.097)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
558 (0.140)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
559 (0.115)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/total'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
560 (0.116)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8a3596d2d0ad24d74f571cc14b'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
561 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/cart'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
562 (0.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/css'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
563 (0.573)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/headers/desktop/classic'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
564 (0.151)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/headers/mobile/header_mobile_1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
565 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/header'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
566 (0.216)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
567 (0.305)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
568 (0.224)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
569 (0.323)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/product' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
570 (0.122)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
571 (0.120)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
572 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
573 (0.189)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12026' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
574 (0.169)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/product' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
575 (0.111)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
576 (0.681)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
577 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
578 (0.172)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12026' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
579 (0.152)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
580 (0.189)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
581 (0.172)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
582 (0.264)
SELECT
SUM(op.quantity) AS quantity
FROM `oc_order_product` op
LEFT JOIN `oc_order` o ON op.order_id = o.order_id
WHERE o.order_status_id <> 0 AND op.product_id = '12026'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:474
583 (0.142)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
-32x32.png){kind=small}
-32x32.jpg){kind=small}
-32x32.jpg){kind=small}
-32x32.jpg){kind=small}
-90x90w.png "Just Cool")
-32x32.jpg){kind=small}
-220x220.png "Lanyards")
-24x24.jpg){kind=small}
-250x250h.jpg "B&C | #E190 | Heavy T-Shirt")
-250x250h.jpg "B&C | #E190 | Heavy T-Shirt")
-250x250h.jpg "B&C | #Inspire E150_° | Men's T-Shirt")
-250x250h.jpg "Neutral | O60001 | Men's Heavy Organic T-Shirt")
-250x250h.jpg "Neutral | O60001 | Men's Heavy Organic T-Shirt")
-250x250h.jpg "05.2020 Stedman | Classic-T Organic Unisex | Unisex Organic T-Shirt")
-250x250h.jpg "SOL'S | Boxy Men | Men's Oversize T-Shirt")
-250x250h.jpg "SOL'S | Boxy Men | Men's Oversize T-Shirt")
-250x250h.jpg "Kariban | K3008 | Oversize T-Shirt")
-250x250h.jpg "Kariban | K3008 | Oversize T-Shirt")
-250x250h.jpg "SOL'S | Legacy | Oversize Unisex T-Shirt")
-24x24.jpg){kind=small}
-24x24.jpg){kind=small}
-24x24.jpg){kind=small}
-190x190h.jpg "05.5420 Stedman Lux | Padded Jacket")
