Total memory used: 61.87 MB
1 (0.057)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.949)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (2.042)
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.075)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.144)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '43e47559ccea4779ab1e8d3f0f' AND `expire` > '2025-06-01 05:37:37'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (42.276)
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 (37.574)
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 (35.422)
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 (33.401)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'pullovers-and-sweaters' OR `keyword` LIKE '%/pullovers-and-sweaters') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (34.693)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'g-awjh053-varsity-zoodie' OR `keyword` LIKE '%/g-awjh053-varsity-zoodie') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
11 (0.233)
SELECT *
FROM `oc_currency`
/home/gajcom/htdocs/gajcom.si/system/library/cart/currency.php:10
12 (0.384)
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.245)
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.169)
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.129)
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.310)
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.201)
SELECT DISTINCT `extension`
FROM `oc_extension`
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:5
18 (0.142)
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.164)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (36.753)
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 (34.918)
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 (39.115)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'pullovers-and-sweaters' OR `keyword` LIKE '%/pullovers-and-sweaters') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (39.598)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'g-awjh053-varsity-zoodie' OR `keyword` LIKE '%/g-awjh053-varsity-zoodie') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.156)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
25 (0.233)
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
26 (0.695)
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.453)
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.241)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
29 (0.089)
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
30 (0.176)
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
31 (0.168)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5864' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
32 (0.279)
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.865)
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 (5864) 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.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 (5864)
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.223)
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 (5864)
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 (3.333)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:24
37 (3.400)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:24
38 (32.073)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
39 (0.770)
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` = '5864' 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
40 (0.266)
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` = '5864' 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
41 (0.197)
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` = '5864' 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
42 (0.133)
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
43 (0.132)
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
44 (0.197)
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
45 (0.155)
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
46 (0.115)
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
47 (0.239)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog|post' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
48 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '11' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
49 (0.117)
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
50 (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
51 (0.172)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'api/journal3/form' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
52 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'module_id' AND `value` = '198' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
53 (0.146)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
54 (0.119)
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
55 (0.101)
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
56 (0.109)
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
57 (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
58 (0.131)
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
59 (0.102)
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
60 (0.100)
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
61 (0.102)
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
62 (0.099)
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
63 (0.116)
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
64 (0.123)
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
65 (0.115)
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
66 (0.160)
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
67 (0.199)
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` = '227' 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
68 (0.158)
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
69 (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
70 (0.598)
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` = '5864' 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
71 (0.146)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
72 (0.160)
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='5864')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
73 (0.164)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
74 (0.089)
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
75 (0.149)
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
76 (0.123)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
77 (0.075)
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
78 (0.124)
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
79 (0.177)
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
80 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '56' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
81 (0.125)
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
82 (0.176)
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` = '5864' 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
83 (0.164)
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` = '5864' 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
84 (0.139)
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
85 (0.128)
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
86 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'product/review_list'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
87 (0.125)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
88 (0.112)
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
89 (0.102)
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
90 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
91 (0.156)
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
92 (0.133)
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
93 (0.124)
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
94 (0.159)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '5864'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
95 (0.162)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '5864' 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
96 (0.241)
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` = '5864' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
97 (0.568)
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` = '5864' AND pov.`product_option_id` = '10179' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
98 (0.321)
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` = '5864' AND pov.`product_option_id` = '10180' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
99 (0.192)
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` = '5864' 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
100 (0.127)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
101 (0.106)
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
102 (0.145)
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
103 (0.201)
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` = '5864' 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
104 (0.192)
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` = '5864' 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
105 (0.157)
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
106 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'G-AWJH053 | VARSITY ZOODIE' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
107 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'AWJH053' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
108 (0.121)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Pullovers and sweaters' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
109 (0.102)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '5864' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
110 (0.125)
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
111 (0.217)
SELECT
layout_id,
layout_data
FROM
`oc_journal3_layout`
WHERE
`layout_id` = '2'
OR `layout_id` = -1
ORDER BY
`layout_id` DESC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/layout.php:17
112 (0.142)
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
113 (0.415)
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 (5864)
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
114 (1.077)
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 (5810,5811,5832,5858,5860,5863,5872,5885) 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
115 (0.196)
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 (5810,5811,5832,5858,5860,5863,5872,5885)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
116 (0.512)
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 (5810,5811,5832,5858,5860,5863,5872,5885)
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
117 (0.145)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5810'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
118 (0.094)
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
119 (0.162)
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
120 (0.152)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5810' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
121 (0.123)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5811'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
122 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '335'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
123 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '335' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
124 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5811' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
125 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5832'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
126 (0.079)
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
127 (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
128 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5832' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
129 (0.127)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5858'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
130 (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
131 (0.128)
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
132 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5858' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
133 (0.110)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5860'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
134 (0.071)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '335'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
135 (0.120)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '335' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
136 (0.124)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5860' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
137 (0.112)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5863'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
138 (0.078)
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
139 (0.126)
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
140 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5863' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
141 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5872'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
142 (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
143 (0.149)
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
144 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5872' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
145 (0.128)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5885'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
146 (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
147 (0.129)
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
148 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5885' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
149 (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
150 (0.113)
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.141)
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.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
153 (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
154 (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
155 (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
156 (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
157 (8.493)
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 (227)
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 != '5864'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
158 (1.038)
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 (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465) 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
159 (0.192)
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 (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
160 (0.581)
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 (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465)
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
161 (0.143)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5806'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
162 (0.092)
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
163 (0.157)
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
164 (0.160)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5806' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
165 (0.134)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5914'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
166 (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
167 (0.133)
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
168 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5914' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
169 (0.124)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5807'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
170 (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
171 (0.134)
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
172 (0.154)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5807' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
173 (0.119)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11641'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
174 (0.082)
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
175 (0.129)
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
176 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11641' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
177 (0.135)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11998'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
178 (0.077)
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
179 (0.134)
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
180 (0.201)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11998' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
181 (0.123)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14412'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
182 (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
183 (0.161)
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
184 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14412' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
185 (0.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14553'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
186 (0.097)
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
187 (0.132)
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
188 (0.175)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14553' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
189 (0.111)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14548'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
190 (0.075)
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
191 (0.132)
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
192 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14548' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
193 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14413'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
194 (0.115)
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
195 (0.163)
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
196 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14413' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
197 (0.147)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14465'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
198 (0.113)
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
199 (0.139)
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
200 (0.160)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14465' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
201 (0.157)
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.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
203 (0.132)
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.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
205 (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
206 (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
207 (0.151)
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.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
209 (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
210 (1.159)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
211 (0.159)
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
212 (0.189)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
213 (0.153)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
214 (0.170)
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
215 (0.183)
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
216 (0.218)
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
217 (0.218)
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 (5864)
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
218 (0.605)
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 (5864) 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
219 (0.156)
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 (5864)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
220 (0.249)
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 (5864)
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
221 (0.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
222 (0.090)
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
223 (0.174)
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
224 (0.133)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
225 (0.137)
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
226 (0.100)
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
227 (0.176)
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
228 (0.158)
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
229 (0.116)
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
230 (0.093)
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
231 (0.137)
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
232 (0.144)
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
233 (0.111)
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
234 (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
235 (0.069)
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
236 (0.069)
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
237 (0.201)
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
238 (0.148)
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
239 (0.107)
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
240 (0.113)
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
241 (0.199)
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
242 (0.196)
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
243 (0.140)
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
244 (0.129)
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
245 (0.165)
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
246 (0.148)
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
247 (0.114)
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
248 (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
249 (0.101)
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
250 (0.091)
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
251 (0.179)
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
252 (0.198)
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
253 (0.160)
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
254 (0.093)
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
255 (0.162)
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
256 (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
257 (0.125)
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
258 (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
259 (0.126)
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
260 (0.127)
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
261 (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
262 (0.268)
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.122)
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.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
265 (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
266 (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
267 (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
268 (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
269 (0.095)
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
270 (0.113)
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
271 (0.136)
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.109)
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
273 (0.110)
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
274 (0.109)
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
275 (0.122)
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
276 (0.155)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
277 (0.166)
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
278 (0.203)
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
279 (0.154)
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
280 (0.178)
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
281 (0.143)
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
282 (0.147)
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
283 (0.208)
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
284 (0.141)
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
285 (0.149)
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
286 (0.135)
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
287 (0.150)
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
288 (0.139)
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
289 (0.324)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 06:37:38'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
290 (4.385)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.18', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/pullovers-and-sweaters/g-awjh053-varsity-zoodie', `referer` = 'https://gajcom.si/product/pullovers-and-sweaters/g-awjh053-varsity-zoodie', `date_added` = '2025-06-01 07:37:38'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
291 (0.223)
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
292 (0.161)
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
293 (0.162)
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
294 (0.417)
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
295 (0.163)
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
296 (0.134)
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
297 (0.121)
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
298 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
299 (0.116)
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: 81.05 MB
1 (0.057)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.949)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (2.042)
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.075)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.144)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '43e47559ccea4779ab1e8d3f0f' AND `expire` > '2025-06-01 05:37:37'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (42.276)
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 (37.574)
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 (35.422)
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 (33.401)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'pullovers-and-sweaters' OR `keyword` LIKE '%/pullovers-and-sweaters') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (34.693)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'g-awjh053-varsity-zoodie' OR `keyword` LIKE '%/g-awjh053-varsity-zoodie') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
11 (0.233)
SELECT *
FROM `oc_currency`
/home/gajcom/htdocs/gajcom.si/system/library/cart/currency.php:10
12 (0.384)
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.245)
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.169)
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.129)
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.310)
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.201)
SELECT DISTINCT `extension`
FROM `oc_extension`
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:5
18 (0.142)
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.164)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (36.753)
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 (34.918)
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 (39.115)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'pullovers-and-sweaters' OR `keyword` LIKE '%/pullovers-and-sweaters') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (39.598)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'g-awjh053-varsity-zoodie' OR `keyword` LIKE '%/g-awjh053-varsity-zoodie') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.156)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
25 (0.233)
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
26 (0.695)
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.453)
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.241)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
29 (0.089)
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
30 (0.176)
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
31 (0.168)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5864' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
32 (0.279)
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.865)
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 (5864) 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.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 (5864)
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.223)
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 (5864)
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 (3.333)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:24
37 (3.400)
SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:24
38 (32.073)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
39 (0.770)
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` = '5864' 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
40 (0.266)
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` = '5864' 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
41 (0.197)
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` = '5864' 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
42 (0.133)
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
43 (0.132)
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
44 (0.197)
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
45 (0.155)
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
46 (0.115)
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
47 (0.239)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog|post' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
48 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '11' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
49 (0.117)
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
50 (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
51 (0.172)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'api/journal3/form' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
52 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'module_id' AND `value` = '198' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
53 (0.146)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
54 (0.119)
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
55 (0.101)
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
56 (0.109)
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
57 (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
58 (0.131)
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
59 (0.102)
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
60 (0.100)
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
61 (0.102)
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
62 (0.099)
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
63 (0.116)
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
64 (0.123)
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
65 (0.115)
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
66 (0.160)
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
67 (0.199)
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` = '227' 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
68 (0.158)
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
69 (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
70 (0.598)
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` = '5864' 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
71 (0.146)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
72 (0.160)
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='5864')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
73 (0.164)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
74 (0.089)
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
75 (0.149)
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
76 (0.123)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
77 (0.075)
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
78 (0.124)
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
79 (0.177)
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
80 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '56' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
81 (0.125)
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
82 (0.176)
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` = '5864' 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
83 (0.164)
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` = '5864' 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
84 (0.139)
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
85 (0.128)
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
86 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'product/review_list'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
87 (0.125)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
88 (0.112)
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
89 (0.102)
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
90 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
91 (0.156)
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
92 (0.133)
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
93 (0.124)
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
94 (0.159)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '5864'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
95 (0.162)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '5864' 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
96 (0.241)
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` = '5864' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
97 (0.568)
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` = '5864' AND pov.`product_option_id` = '10179' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
98 (0.321)
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` = '5864' AND pov.`product_option_id` = '10180' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
99 (0.192)
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` = '5864' 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
100 (0.127)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
101 (0.106)
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
102 (0.145)
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
103 (0.201)
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` = '5864' 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
104 (0.192)
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` = '5864' 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
105 (0.157)
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
106 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'G-AWJH053 | VARSITY ZOODIE' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
107 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'AWJH053' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
108 (0.121)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Pullovers and sweaters' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
109 (0.102)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '5864' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
110 (0.125)
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
111 (0.217)
SELECT
layout_id,
layout_data
FROM
`oc_journal3_layout`
WHERE
`layout_id` = '2'
OR `layout_id` = -1
ORDER BY
`layout_id` DESC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/layout.php:17
112 (0.142)
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
113 (0.415)
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 (5864)
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
114 (1.077)
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 (5810,5811,5832,5858,5860,5863,5872,5885) 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
115 (0.196)
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 (5810,5811,5832,5858,5860,5863,5872,5885)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
116 (0.512)
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 (5810,5811,5832,5858,5860,5863,5872,5885)
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
117 (0.145)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5810'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
118 (0.094)
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
119 (0.162)
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
120 (0.152)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5810' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
121 (0.123)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5811'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
122 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '335'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
123 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '335' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
124 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5811' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
125 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5832'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
126 (0.079)
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
127 (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
128 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5832' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
129 (0.127)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5858'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
130 (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
131 (0.128)
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
132 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5858' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
133 (0.110)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5860'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
134 (0.071)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '335'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
135 (0.120)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '335' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
136 (0.124)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5860' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
137 (0.112)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5863'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
138 (0.078)
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
139 (0.126)
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
140 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5863' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
141 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5872'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
142 (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
143 (0.149)
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
144 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5872' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
145 (0.128)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5885'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
146 (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
147 (0.129)
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
148 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5885' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
149 (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
150 (0.113)
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.141)
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.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
153 (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
154 (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
155 (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
156 (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
157 (8.493)
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 (227)
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 != '5864'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
158 (1.038)
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 (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465) 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
159 (0.192)
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 (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
160 (0.581)
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 (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465)
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
161 (0.143)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5806'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
162 (0.092)
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
163 (0.157)
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
164 (0.160)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5806' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
165 (0.134)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5914'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
166 (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
167 (0.133)
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
168 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5914' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
169 (0.124)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5807'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
170 (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
171 (0.134)
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
172 (0.154)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5807' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
173 (0.119)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11641'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
174 (0.082)
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
175 (0.129)
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
176 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11641' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
177 (0.135)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11998'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
178 (0.077)
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
179 (0.134)
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
180 (0.201)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11998' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
181 (0.123)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14412'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
182 (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
183 (0.161)
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
184 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14412' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
185 (0.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14553'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
186 (0.097)
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
187 (0.132)
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
188 (0.175)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14553' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
189 (0.111)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14548'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
190 (0.075)
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
191 (0.132)
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
192 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14548' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
193 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14413'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
194 (0.115)
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
195 (0.163)
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
196 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14413' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
197 (0.147)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14465'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
198 (0.113)
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
199 (0.139)
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
200 (0.160)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14465' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
201 (0.157)
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.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
203 (0.132)
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.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
205 (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
206 (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
207 (0.151)
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.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
209 (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
210 (1.159)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
211 (0.159)
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
212 (0.189)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
213 (0.153)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
214 (0.170)
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
215 (0.183)
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
216 (0.218)
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
217 (0.218)
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 (5864)
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
218 (0.605)
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 (5864) 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
219 (0.156)
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 (5864)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
220 (0.249)
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 (5864)
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
221 (0.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
222 (0.090)
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
223 (0.174)
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
224 (0.133)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
225 (0.137)
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
226 (0.100)
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
227 (0.176)
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
228 (0.158)
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
229 (0.116)
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
230 (0.093)
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
231 (0.137)
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
232 (0.144)
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
233 (0.111)
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
234 (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
235 (0.069)
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
236 (0.069)
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
237 (0.201)
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
238 (0.148)
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
239 (0.107)
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
240 (0.113)
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
241 (0.199)
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
242 (0.196)
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
243 (0.140)
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
244 (0.129)
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
245 (0.165)
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
246 (0.148)
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
247 (0.114)
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
248 (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
249 (0.101)
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
250 (0.091)
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
251 (0.179)
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
252 (0.198)
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
253 (0.160)
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
254 (0.093)
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
255 (0.162)
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
256 (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
257 (0.125)
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
258 (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
259 (0.126)
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
260 (0.127)
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
261 (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
262 (0.268)
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.122)
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.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
265 (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
266 (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
267 (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
268 (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
269 (0.095)
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
270 (0.113)
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
271 (0.136)
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.109)
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
273 (0.110)
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
274 (0.109)
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
275 (0.122)
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
276 (0.155)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
277 (0.166)
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
278 (0.203)
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
279 (0.154)
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
280 (0.178)
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
281 (0.143)
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
282 (0.147)
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
283 (0.208)
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
284 (0.141)
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
285 (0.149)
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
286 (0.135)
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
287 (0.150)
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
288 (0.139)
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
289 (0.324)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 06:37:38'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
290 (4.385)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.18', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/pullovers-and-sweaters/g-awjh053-varsity-zoodie', `referer` = 'https://gajcom.si/product/pullovers-and-sweaters/g-awjh053-varsity-zoodie', `date_added` = '2025-06-01 07:37:38'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
291 (0.223)
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
292 (0.161)
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
293 (0.162)
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
294 (0.417)
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
295 (0.163)
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
296 (0.134)
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
297 (0.121)
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
298 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
299 (0.116)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
300 (0.160)
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.129)
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.133)
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.122)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
304 (0.106)
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
305 (0.123)
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.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
307 (0.144)
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
308 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
309 (0.106)
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
310 (0.767)
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
311 (0.133)
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
312 (0.148)
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
313 (0.099)
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
314 (0.180)
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
315 (0.187)
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
316 (0.148)
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
317 (0.116)
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
318 (0.073)
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
319 (0.153)
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
320 (0.140)
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
321 (0.128)
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
322 (0.140)
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
323 (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
324 (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
325 (0.143)
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
326 (0.128)
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
327 (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
328 (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
329 (0.135)
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
330 (0.131)
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
331 (0.122)
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
332 (0.085)
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
333 (0.134)
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
334 (0.156)
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
335 (0.154)
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
336 (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
337 (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
338 (0.100)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
339 (0.094)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
340 (0.113)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
341 (0.117)
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
342 (0.084)
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
343 (0.152)
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
344 (0.156)
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
345 (0.114)
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
346 (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
347 (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
348 (0.150)
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
349 (0.151)
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
350 (0.123)
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
351 (0.092)
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
352 (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
353 (0.144)
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
354 (0.147)
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
355 (0.129)
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
356 (0.083)
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
357 (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
358 (0.181)
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
359 (0.155)
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
360 (0.115)
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
361 (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
362 (0.133)
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.118)
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
364 (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
365 (0.132)
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
366 (0.141)
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
367 (0.140)
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
368 (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
369 (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
370 (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
371 (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
372 (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
373 (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
374 (0.117)
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
375 (0.102)
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
376 (0.151)
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
377 (0.141)
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
378 (0.111)
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
379 (0.072)
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
380 (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
381 (0.139)
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
382 (0.116)
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
383 (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
384 (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
385 (0.139)
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
386 (0.151)
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
387 (0.116)
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
388 (0.089)
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
389 (0.150)
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
390 (0.149)
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
391 (0.138)
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
392 (0.113)
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
393 (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
394 (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
395 (0.137)
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
396 (0.116)
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
397 (0.085)
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
398 (0.133)
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
399 (0.136)
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
400 (0.116)
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.114)
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.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
403 (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
404 (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
405 (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
406 (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
407 (0.116)
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.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
409 (0.110)
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
410 (0.109)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
411 (0.131)
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
412 (0.126)
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
413 (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
414 (0.141)
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
415 (0.145)
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
416 (0.118)
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
417 (0.092)
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.110)
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
420 (0.090)
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
421 (0.143)
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
422 (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
423 (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
424 (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
425 (0.114)
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
426 (0.081)
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
427 (0.143)
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
428 (0.137)
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
429 (0.109)
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
430 (0.077)
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
431 (0.158)
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
432 (0.151)
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
433 (0.118)
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
434 (0.081)
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
435 (0.134)
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
436 (0.135)
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
437 (0.100)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
438 (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
439 (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
440 (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
441 (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
442 (0.134)
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
443 (0.116)
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.105)
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
445 (0.105)
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
446 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
447 (0.143)
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
448 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
449 (0.110)
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
450 (0.125)
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
451 (0.108)
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
452 (0.105)
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
453 (0.106)
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
454 (0.186)
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
455 (0.116)
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
456 (0.122)
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
457 (0.141)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
458 (0.122)
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
459 (0.149)
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
460 (0.093)
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.160)
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.131)
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
463 (0.092)
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.140)
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.116)
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
466 (0.081)
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
467 (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
468 (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
469 (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
470 (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
471 (0.119)
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
472 (0.084)
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.162)
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.116)
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
475 (0.085)
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.134)
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.112)
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
478 (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
479 (0.134)
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
480 (0.109)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
481 (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
482 (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
483 (0.096)
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
484 (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
485 (0.118)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
486 (0.100)
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
487 (0.118)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
488 (0.132)
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
489 (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
490 (0.109)
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
491 (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
492 (0.108)
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
493 (0.144)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
494 (0.108)
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
495 (0.142)
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
496 (0.129)
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
497 (0.116)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
498 (0.139)
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
499 (0.178)
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
500 (0.142)
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
501 (0.124)
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
502 (0.177)
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
503 (0.137)
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
504 (0.145)
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
505 (0.141)
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
506 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/language'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
507 (0.113)
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
508 (0.126)
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
509 (0.135)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
510 (0.091)
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
511 (0.132)
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
512 (0.100)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/currency'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
513 (0.112)
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
514 (0.138)
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
515 (0.111)
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
516 (0.113)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/search'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
517 (0.133)
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
518 (0.133)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
519 (0.126)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
520 (0.116)
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
521 (0.111)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
522 (0.694)
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
523 (0.126)
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.090)
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.132)
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.097)
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.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
528 (0.099)
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.073)
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
530 (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
531 (0.091)
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
532 (0.104)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
533 (0.292)
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
534 (0.185)
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
535 (0.119)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
536 (0.121)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
537 (0.114)
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
538 (0.111)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
539 (0.107)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
540 (0.145)
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
541 (0.121)
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
542 (0.124)
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
543 (0.123)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
544 (0.119)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
545 (0.107)
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
546 (0.107)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
547 (0.635)
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
548 (0.099)
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.071)
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.111)
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.060)
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.086)
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.067)
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
555 (0.061)
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
556 (0.083)
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
557 (0.097)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
558 (0.260)
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
559 (0.129)
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
560 (0.108)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
561 (0.113)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
562 (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
563 (0.129)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '43e47559ccea4779ab1e8d3f0f'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
564 (0.103)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/cart'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
565 (0.138)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/css'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
566 (0.115)
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
567 (0.135)
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
568 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/header'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
569 (0.162)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
570 (0.110)
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
571 (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
572 (0.155)
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
573 (0.107)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
574 (0.073)
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
575 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
576 (0.165)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5864' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
577 (0.143)
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
578 (0.098)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
579 (0.072)
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
580 (0.120)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
581 (0.125)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5864' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
582 (0.124)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5864'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
583 (0.081)
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
584 (0.130)
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
585 (0.229)
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 = '5864'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:474
586 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
Promotional Gifts
Keychains0
Drinkware0
Office0
Bag hangers0
Ball Pens0
Ball pens with lid/roller0
Cardholders0
Cases and pouches0
Document folders0
Eco ball pens0
Erasers and sharpeners0
Fountain pen0
Highlighters0
Metal Ball Pens0
Mousepads0
Notepads and notebooks0
Office decorations0
Pencils and mehcanical pencils0
Plastic ball pens0
Rulers0
Sticky Notepads0
Writing sets0
Antistress balls0
Candies0
Car accessories0
Cleaning cloths0
Fashion accessories0
For the house0
Fridge magnets0
FrigusVultus bamboo promotional gifts0
Gift boxes0
Glass Trophies0
Kids0
-32x32.png){kind=small}
Lanyards0
Lighters0
Personal care0
Pets0
Promo Accesories0
Promo Bags0
Promo Textile0
Puzzle0
Reflective products0
Sport accessories0
Summer0
Technology0
Tools0
Travel0
Inkless pens0
Gift box0
Christmas promo gifts0
Promotional Apparel
Chef's Jackets0
T-shirts0
Polo shirts0
Pullovers and Sweaters0
Sport0
Fleece0
Jackets0
Bodywarmer0
Shirts0
Business0
Knitted pullover0
Troursers/Skirts/Dresses0
Workwear & Safety0
Bags0
Frottier0
Underwear0
Caps0
Accessories0
Baby0
Kidswear0
Umbrellas0
Shoes0
Packing material0
Gajcom Gourmet0
Toys - Rubber and Plush0
Keyrings0
Pillows0
Promotional gifts0
Printing and embroidery materials0
Promotional gifts ideas0
-32x32.jpg){kind=small}
Top offer
-32x32.jpg){kind=small}
Showroom
-32x32.jpg){kind=small}
Stanley&Stella
Our Brands
-32x32.jpg){kind=small}
About print option
About us
Blog
-220x220.png "Lanyards")
Shop by Brand
-24x24.jpg){kind=small}
Selected products
-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")
Brands
-24x24.jpg){kind=small}
Stanley/Stella
-24x24.jpg){kind=small}
Print and embroidery
-24x24.jpg){kind=small}
Showroom
Connections
-90x90w.png "Just Cool")
