Total memory used: 61.82 MB
1 (0.049)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.650)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (1.279)
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.074)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.138)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '8715e510aa73ca78bc2cafb2b2' AND `expire` > '2025-06-01 05:09:36'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (66.701)
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 (65.639)
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 (73.764)
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 (67.862)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'jackets' OR `keyword` LIKE '%/jackets') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (34.834)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-stanley-voyager-wool-like-padded-jacket' OR `keyword` LIKE '%/stanleystella-stanley-voyager-wool-like-padded-jacket') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
11 (0.234)
SELECT *
FROM `oc_currency`
/home/gajcom/htdocs/gajcom.si/system/library/cart/currency.php:10
12 (0.407)
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 (1.892)
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.196)
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.142)
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.291)
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.229)
SELECT DISTINCT `extension`
FROM `oc_extension`
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:5
18 (0.163)
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.201)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (48.798)
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 (47.330)
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 (38.636)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'jackets' OR `keyword` LIKE '%/jackets') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (37.458)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-stanley-voyager-wool-like-padded-jacket' OR `keyword` LIKE '%/stanleystella-stanley-voyager-wool-like-padded-jacket') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.338)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
25 (0.108)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
26 (0.237)
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.171)
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.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
29 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
30 (0.160)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
31 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '523' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
32 (0.268)
SELECT *
FROM `oc_event`
WHERE `status` = '1'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/event.php:5
33 (1.237)
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 (523) 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.208)
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 (523)
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.281)
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 (523)
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 (27.637)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
37 (0.775)
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` = '523' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:6
38 (0.276)
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` = '523' AND agd.`language_id` = '1' GROUP BY ag.`attribute_group_id`
ORDER BY ag.`sort_order`, agd.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:255
39 (0.247)
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` = '523' AND a.`attribute_group_id` = '14' AND ad.`language_id` = '1' AND pa.`language_id` = '1'
ORDER BY a.`sort_order`, ad.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:260
40 (0.149)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_blocks_attributes'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
41 (0.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
42 (0.176)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/login' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
43 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/register' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
44 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_blocks_reviews'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
45 (0.159)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
46 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
47 (0.149)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
48 (0.126)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
49 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
50 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/form'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
51 (0.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
52 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
53 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
54 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
55 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
56 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
57 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
58 (0.116)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
59 (0.109)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/gajcom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
60 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
61 (0.200)
SELECT DISTINCT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`category_id` = '230' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/category.php:7
62 (0.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
63 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
64 (0.616)
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` = '523' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:6
65 (0.137)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
66 (0.168)
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='523')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
67 (0.154)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
68 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
69 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
70 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
71 (0.078)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
72 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
73 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer|info' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
74 (0.136)
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
75 (0.148)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
76 (0.225)
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` = '523' AND p.`date_available` <= NOW() AND p.`status` = '1' AND r.`status` = '1' AND pd.`language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/review.php:25
77 (0.209)
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` = '523' AND p.`date_available` <= NOW() AND p.`status` = '1' AND r.`status` = '1' AND pd.`language_id` = '1'
ORDER BY r.`date_added` DESC LIMIT 0,5
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/review.php:19
78 (0.177)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/review|list' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
79 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '{page}' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
80 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'product/review_list'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
81 (0.135)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
82 (0.111)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
83 (0.122)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
84 (0.147)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
85 (0.196)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/wishlist|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
86 (0.182)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/compare|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
87 (0.175)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'tool/upload' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
88 (0.202)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '523'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
89 (0.198)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '523' AND `customer_group_id` = '1' AND `quantity` > 1 AND ((`date_start` = '0000-00-00' OR `date_start` < NOW()) AND (`date_end` = '0000-00-00' OR `date_end` > NOW()))
ORDER BY `quantity` ASC, `priority` ASC, `price` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:328
90 (0.326)
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` = '523' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
91 (0.538)
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` = '523' AND pov.`product_option_id` = '932' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
92 (0.506)
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` = '523' AND pov.`product_option_id` = '933' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
93 (0.258)
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` = '523' AND ps.`customer_group_id` = '1' AND spd.`language_id` = '1' AND sp.`status` = '1'
ORDER BY sp.`sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:486
94 (0.169)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
95 (0.122)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
96 (0.202)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
97 (0.293)
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` = '523' AND agd.`language_id` = '1' GROUP BY ag.`attribute_group_id`
ORDER BY ag.`sort_order`, agd.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:255
98 (0.266)
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` = '523' AND a.`attribute_group_id` = '14' AND ad.`language_id` = '1' AND pa.`language_id` = '1'
ORDER BY a.`sort_order`, ad.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:260
99 (0.225)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/search' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
100 (0.201)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'StanleyStella / Stanley Voyager Wool-Like / Padded Jacket' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
101 (0.193)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'STJM889' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
102 (0.196)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Jackets' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
103 (0.131)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '523' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
104 (0.168)
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
105 (0.167)
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
106 (0.481)
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 (523)
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
107 (1.562)
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 (522,524,525,549,550,551,552,10405,10406,10409) 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
108 (0.265)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (522,524,525,549,550,551,552,10405,10406,10409)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
109 (0.471)
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 (522,524,525,549,550,551,552,10405,10406,10409)
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
110 (0.183)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '522'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
111 (0.120)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
112 (0.216)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
113 (0.210)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '522' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
114 (0.150)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '524'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
115 (0.109)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
116 (0.183)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
117 (0.196)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '524' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
118 (0.143)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '525'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
119 (0.104)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
120 (0.176)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
121 (0.202)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '525' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
122 (0.149)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '549'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
123 (0.108)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
124 (0.204)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
125 (0.198)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '549' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
126 (0.144)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '550'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
127 (0.105)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
128 (0.179)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
129 (0.206)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '550' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
130 (0.148)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '551'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
131 (0.097)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
132 (0.181)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
133 (0.192)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '551' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
134 (0.142)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '552'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
135 (0.098)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
136 (0.170)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
137 (0.176)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '552' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
138 (0.141)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10405'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
139 (0.098)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
140 (0.182)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
141 (0.190)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '10405' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
142 (0.147)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10406'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
143 (0.106)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
144 (0.175)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
145 (0.215)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '10406' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
146 (0.147)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10409'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
147 (0.112)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
148 (0.189)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
149 (0.210)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '10409' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
150 (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
151 (0.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
152 (0.142)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
153 (0.138)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
154 (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
155 (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
156 (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
157 (0.152)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
158 (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
159 (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
160 (22.923)
SELECT *
FROM `oc_product` p
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.category_id IN (230)
AND p.status = '1'
AND p.date_available <= NOW()
AND pd.language_id = '1'
AND p2s.store_id = '0'
AND c.status = '1'
AND c2s.store_id = '0'
AND p.product_id != '523'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
161 (1.208)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (12026,11926,11572,14533,14410,14340,14400,11570,11623,14569) 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
162 (0.216)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (12026,11926,11572,14533,14410,14340,14400,11570,11623,14569)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
163 (0.374)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (12026,11926,11572,14533,14410,14340,14400,11570,11623,14569)
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
164 (0.145)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
165 (0.111)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
166 (0.228)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
167 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12026' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
168 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11926'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
169 (0.086)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
170 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
171 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11926' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
172 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11572'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
173 (0.094)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
174 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
175 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11572' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
176 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14533'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
177 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
178 (0.140)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
179 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14533' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
180 (0.134)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14410'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
181 (0.087)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
182 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
183 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14410' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
184 (0.125)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14340'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
185 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
186 (0.136)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
187 (0.171)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14340' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
188 (0.131)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14400'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
189 (0.101)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
190 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
191 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14400' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
192 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11570'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
193 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
194 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
195 (0.172)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11570' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
196 (0.117)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11623'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
197 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
198 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
199 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11623' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
200 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14569'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
201 (0.084)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
202 (0.187)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
203 (0.168)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14569' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
204 (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
205 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
206 (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
207 (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
208 (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
209 (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
210 (0.117)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
211 (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
212 (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
213 (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
214 (0.104)
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
215 (0.111)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
216 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
217 (0.115)
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
218 (0.145)
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
219 (0.148)
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
220 (0.263)
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 (523, 11213)
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
221 (0.937)
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 (523,11213) 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
222 (0.198)
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 (523,11213)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
223 (0.234)
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 (523,11213)
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
224 (0.138)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
225 (0.095)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
226 (0.186)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
227 (0.133)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11213'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
228 (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
229 (0.140)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
230 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11213' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
231 (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
232 (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
233 (0.120)
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
234 (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
235 (0.141)
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
236 (0.151)
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
237 (0.118)
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
238 (0.083)
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
239 (0.159)
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
240 (0.244)
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
241 (0.121)
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
242 (0.087)
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
243 (0.075)
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
244 (0.063)
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
245 (0.135)
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
246 (0.147)
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
247 (0.122)
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
248 (0.091)
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
249 (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
250 (0.135)
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
251 (0.117)
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
252 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
253 (0.148)
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
254 (0.139)
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
255 (0.122)
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
256 (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
257 (0.064)
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
258 (0.061)
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
259 (0.139)
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
260 (0.137)
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
261 (0.117)
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
262 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
263 (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
264 (0.130)
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
265 (0.102)
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
266 (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
267 (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
268 (0.143)
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
269 (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
270 (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
271 (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
272 (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
273 (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
274 (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
275 (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
276 (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
277 (0.112)
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
278 (0.119)
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
279 (0.111)
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
280 (0.135)
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
281 (0.149)
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
282 (0.141)
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
283 (0.153)
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
284 (0.140)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
285 (0.189)
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
286 (0.256)
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
287 (0.214)
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
288 (0.191)
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
289 (0.219)
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
290 (0.201)
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
291 (0.210)
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
292 (0.196)
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
293 (0.211)
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
294 (0.189)
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
295 (0.185)
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
296 (0.183)
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
297 (0.534)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 06:09:37'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
298 (0.217)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.180', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/jackets/stanleystella-stanley-voyager-wool-like-padded-jacket', `referer` = 'https://gajcom.si/product/jackets/stanleystella-stanley-voyager-wool-like-padded-jacket', `date_added` = '2025-06-01 07:09:37'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
299 (0.261)
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
300 (0.179)
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
301 (0.199)
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
302 (0.213)
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
303 (0.197)
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
304 (0.185)
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
305 (0.475)
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
306 (0.135)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
307 (0.176)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
Total memory used: 80.53 MB
1 (0.049)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.650)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (1.279)
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.074)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.138)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '8715e510aa73ca78bc2cafb2b2' AND `expire` > '2025-06-01 05:09:36'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (66.701)
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 (65.639)
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 (73.764)
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 (67.862)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'jackets' OR `keyword` LIKE '%/jackets') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (34.834)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-stanley-voyager-wool-like-padded-jacket' OR `keyword` LIKE '%/stanleystella-stanley-voyager-wool-like-padded-jacket') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
11 (0.234)
SELECT *
FROM `oc_currency`
/home/gajcom/htdocs/gajcom.si/system/library/cart/currency.php:10
12 (0.407)
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 (1.892)
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.196)
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.142)
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.291)
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.229)
SELECT DISTINCT `extension`
FROM `oc_extension`
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:5
18 (0.163)
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.201)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (48.798)
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 (47.330)
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 (38.636)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'jackets' OR `keyword` LIKE '%/jackets') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (37.458)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-stanley-voyager-wool-like-padded-jacket' OR `keyword` LIKE '%/stanleystella-stanley-voyager-wool-like-padded-jacket') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.338)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
25 (0.108)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
26 (0.237)
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.171)
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.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
29 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
30 (0.160)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
31 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '523' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
32 (0.268)
SELECT *
FROM `oc_event`
WHERE `status` = '1'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/event.php:5
33 (1.237)
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 (523) 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.208)
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 (523)
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.281)
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 (523)
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 (27.637)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
37 (0.775)
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` = '523' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:6
38 (0.276)
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` = '523' AND agd.`language_id` = '1' GROUP BY ag.`attribute_group_id`
ORDER BY ag.`sort_order`, agd.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:255
39 (0.247)
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` = '523' AND a.`attribute_group_id` = '14' AND ad.`language_id` = '1' AND pa.`language_id` = '1'
ORDER BY a.`sort_order`, ad.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:260
40 (0.149)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_blocks_attributes'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
41 (0.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
42 (0.176)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/login' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
43 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/register' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
44 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_blocks_reviews'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
45 (0.159)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
46 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
47 (0.149)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
48 (0.126)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
49 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
50 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/form'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
51 (0.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
52 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
53 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
54 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
55 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
56 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
57 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
58 (0.116)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
59 (0.109)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/gajcom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
60 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
61 (0.200)
SELECT DISTINCT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`category_id` = '230' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/category.php:7
62 (0.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
63 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
64 (0.616)
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` = '523' AND pd.`language_id` = '1' AND p.`status` = '1' AND p.`date_available` <= NOW() AND p2s.`store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:6
65 (0.137)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
66 (0.168)
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='523')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
67 (0.154)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
68 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
69 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
70 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
71 (0.078)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
72 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
73 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer|info' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
74 (0.136)
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
75 (0.148)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
76 (0.225)
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` = '523' AND p.`date_available` <= NOW() AND p.`status` = '1' AND r.`status` = '1' AND pd.`language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/review.php:25
77 (0.209)
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` = '523' AND p.`date_available` <= NOW() AND p.`status` = '1' AND r.`status` = '1' AND pd.`language_id` = '1'
ORDER BY r.`date_added` DESC LIMIT 0,5
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/review.php:19
78 (0.177)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/review|list' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
79 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '{page}' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
80 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'product/review_list'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
81 (0.135)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
82 (0.111)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
83 (0.122)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
84 (0.147)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/product/review'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
85 (0.196)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/wishlist|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
86 (0.182)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/compare|add' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
87 (0.175)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'tool/upload' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
88 (0.202)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '523'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
89 (0.198)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '523' AND `customer_group_id` = '1' AND `quantity` > 1 AND ((`date_start` = '0000-00-00' OR `date_start` < NOW()) AND (`date_end` = '0000-00-00' OR `date_end` > NOW()))
ORDER BY `quantity` ASC, `priority` ASC, `price` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:328
90 (0.326)
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` = '523' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
91 (0.538)
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` = '523' AND pov.`product_option_id` = '932' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
92 (0.506)
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` = '523' AND pov.`product_option_id` = '933' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
93 (0.258)
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` = '523' AND ps.`customer_group_id` = '1' AND spd.`language_id` = '1' AND sp.`status` = '1'
ORDER BY sp.`sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:486
94 (0.169)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
95 (0.122)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
96 (0.202)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
97 (0.293)
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` = '523' AND agd.`language_id` = '1' GROUP BY ag.`attribute_group_id`
ORDER BY ag.`sort_order`, agd.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:255
98 (0.266)
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` = '523' AND a.`attribute_group_id` = '14' AND ad.`language_id` = '1' AND pa.`language_id` = '1'
ORDER BY a.`sort_order`, ad.`name`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:260
99 (0.225)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/search' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
100 (0.201)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'StanleyStella / Stanley Voyager Wool-Like / Padded Jacket' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
101 (0.193)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'STJM889' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
102 (0.196)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Jackets' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
103 (0.131)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '523' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
104 (0.168)
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
105 (0.167)
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
106 (0.481)
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 (523)
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
107 (1.562)
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 (522,524,525,549,550,551,552,10405,10406,10409) 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
108 (0.265)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (522,524,525,549,550,551,552,10405,10406,10409)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
109 (0.471)
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 (522,524,525,549,550,551,552,10405,10406,10409)
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
110 (0.183)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '522'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
111 (0.120)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
112 (0.216)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
113 (0.210)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '522' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
114 (0.150)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '524'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
115 (0.109)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
116 (0.183)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
117 (0.196)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '524' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
118 (0.143)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '525'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
119 (0.104)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
120 (0.176)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
121 (0.202)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '525' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
122 (0.149)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '549'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
123 (0.108)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
124 (0.204)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
125 (0.198)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '549' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
126 (0.144)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '550'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
127 (0.105)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
128 (0.179)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
129 (0.206)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '550' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
130 (0.148)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '551'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
131 (0.097)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
132 (0.181)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
133 (0.192)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '551' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
134 (0.142)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '552'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
135 (0.098)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
136 (0.170)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
137 (0.176)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '552' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
138 (0.141)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10405'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
139 (0.098)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
140 (0.182)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
141 (0.190)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '10405' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
142 (0.147)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10406'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
143 (0.106)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
144 (0.175)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
145 (0.215)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '10406' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
146 (0.147)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10409'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
147 (0.112)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
148 (0.189)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
149 (0.210)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '10409' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
150 (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
151 (0.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
152 (0.142)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
153 (0.138)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
154 (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
155 (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
156 (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
157 (0.152)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
158 (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
159 (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
160 (22.923)
SELECT *
FROM `oc_product` p
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.category_id IN (230)
AND p.status = '1'
AND p.date_available <= NOW()
AND pd.language_id = '1'
AND p2s.store_id = '0'
AND c.status = '1'
AND c2s.store_id = '0'
AND p.product_id != '523'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
161 (1.208)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (12026,11926,11572,14533,14410,14340,14400,11570,11623,14569) 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
162 (0.216)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND ps.date_end != '0000-00-00' AND ps.date_end > NOW())
AND product_id IN (12026,11926,11572,14533,14410,14340,14400,11570,11623,14569)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
163 (0.374)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (12026,11926,11572,14533,14410,14340,14400,11570,11623,14569)
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
164 (0.145)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12026'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
165 (0.111)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
166 (0.228)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
167 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12026' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
168 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11926'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
169 (0.086)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
170 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
171 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11926' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
172 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11572'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
173 (0.094)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
174 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
175 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11572' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
176 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14533'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
177 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
178 (0.140)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
179 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14533' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
180 (0.134)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14410'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
181 (0.087)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
182 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
183 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14410' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
184 (0.125)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14340'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
185 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
186 (0.136)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
187 (0.171)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14340' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
188 (0.131)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14400'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
189 (0.101)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
190 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
191 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14400' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
192 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11570'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
193 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
194 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
195 (0.172)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11570' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
196 (0.117)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11623'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
197 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
198 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
199 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11623' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
200 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14569'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
201 (0.084)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
202 (0.187)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
203 (0.168)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14569' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
204 (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
205 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
206 (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
207 (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
208 (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
209 (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
210 (0.117)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
211 (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
212 (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
213 (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
214 (0.104)
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
215 (0.111)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
216 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
217 (0.115)
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
218 (0.145)
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
219 (0.148)
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
220 (0.263)
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 (523, 11213)
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
221 (0.937)
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 (523,11213) 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
222 (0.198)
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 (523,11213)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
223 (0.234)
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 (523,11213)
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
224 (0.138)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
225 (0.095)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
226 (0.186)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
227 (0.133)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11213'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
228 (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
229 (0.140)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
230 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11213' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
231 (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
232 (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
233 (0.120)
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
234 (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
235 (0.141)
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
236 (0.151)
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
237 (0.118)
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
238 (0.083)
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
239 (0.159)
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
240 (0.244)
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
241 (0.121)
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
242 (0.087)
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
243 (0.075)
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
244 (0.063)
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
245 (0.135)
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
246 (0.147)
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
247 (0.122)
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
248 (0.091)
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
249 (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
250 (0.135)
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
251 (0.117)
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
252 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
253 (0.148)
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
254 (0.139)
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
255 (0.122)
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
256 (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
257 (0.064)
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
258 (0.061)
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
259 (0.139)
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
260 (0.137)
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
261 (0.117)
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
262 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
263 (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
264 (0.130)
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
265 (0.102)
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
266 (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
267 (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
268 (0.143)
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
269 (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
270 (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
271 (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
272 (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
273 (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
274 (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
275 (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
276 (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
277 (0.112)
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
278 (0.119)
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
279 (0.111)
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
280 (0.135)
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
281 (0.149)
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
282 (0.141)
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
283 (0.153)
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
284 (0.140)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
285 (0.189)
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
286 (0.256)
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
287 (0.214)
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
288 (0.191)
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
289 (0.219)
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
290 (0.201)
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
291 (0.210)
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
292 (0.196)
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
293 (0.211)
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
294 (0.189)
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
295 (0.185)
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
296 (0.183)
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
297 (0.534)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 06:09:37'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
298 (0.217)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.180', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/jackets/stanleystella-stanley-voyager-wool-like-padded-jacket', `referer` = 'https://gajcom.si/product/jackets/stanleystella-stanley-voyager-wool-like-padded-jacket', `date_added` = '2025-06-01 07:09:37'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
299 (0.261)
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
300 (0.179)
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
301 (0.199)
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
302 (0.213)
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
303 (0.197)
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
304 (0.185)
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
305 (0.475)
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
306 (0.135)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
307 (0.176)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
308 (0.190)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
309 (0.139)
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
310 (0.150)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
311 (0.143)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
312 (0.115)
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
313 (0.130)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
314 (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
315 (0.145)
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
316 (0.159)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
317 (0.141)
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
318 (0.160)
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
319 (0.143)
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
320 (0.153)
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
321 (0.108)
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
322 (0.229)
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
323 (0.210)
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
324 (0.179)
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
325 (0.128)
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
326 (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
327 (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
328 (0.150)
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
329 (0.134)
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
330 (0.109)
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
331 (0.076)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
332 (0.143)
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
333 (0.147)
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
334 (0.146)
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
335 (0.091)
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
336 (0.136)
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
337 (0.155)
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
338 (0.139)
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
339 (0.127)
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
340 (0.094)
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
341 (0.148)
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
342 (0.161)
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
343 (0.142)
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
344 (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
345 (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
346 (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
347 (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
348 (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
349 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '1305'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
350 (0.135)
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
351 (0.182)
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
352 (0.174)
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
353 (0.136)
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
354 (0.098)
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
355 (0.173)
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
356 (0.147)
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
357 (0.137)
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
358 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
359 (0.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
360 (0.147)
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
361 (0.141)
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
362 (0.110)
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
363 (0.075)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
364 (0.124)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
365 (0.135)
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
366 (0.129)
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
367 (0.105)
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
368 (0.075)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
369 (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
370 (0.119)
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
371 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
372 (0.143)
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
373 (0.148)
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
374 (0.139)
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
375 (0.121)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
376 (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
377 (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
378 (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
379 (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
380 (0.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
381 (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
382 (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
383 (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
384 (0.143)
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
385 (0.112)
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
386 (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
387 (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
388 (0.137)
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
389 (0.111)
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
390 (0.078)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
391 (0.126)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
392 (0.166)
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
393 (0.143)
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
394 (0.112)
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
395 (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
396 (0.121)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
397 (0.147)
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
398 (0.129)
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
399 (0.115)
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
400 (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
401 (0.121)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
402 (0.134)
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
403 (0.113)
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
404 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
405 (0.131)
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
406 (0.149)
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
407 (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
408 (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
409 (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
410 (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
411 (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
412 (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
413 (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
414 (0.113)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
415 (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
416 (0.101)
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
417 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
418 (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
419 (0.118)
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
420 (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
421 (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
422 (0.141)
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
423 (0.111)
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
424 (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
425 (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
426 (0.108)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
427 (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
428 (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
429 (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
430 (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
431 (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
432 (0.126)
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
433 (0.083)
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
434 (0.135)
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
435 (0.143)
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
436 (0.114)
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
437 (0.093)
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
438 (0.131)
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
439 (0.136)
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
440 (0.110)
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
441 (0.073)
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
442 (0.131)
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
443 (0.140)
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
444 (0.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
445 (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
446 (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
447 (0.102)
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
448 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
449 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
450 (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
451 (0.104)
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
452 (0.104)
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
453 (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
454 (0.103)
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
455 (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
456 (0.099)
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
457 (0.115)
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
458 (0.114)
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
459 (0.115)
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
460 (0.103)
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
461 (0.138)
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
462 (0.110)
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
463 (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
464 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
465 (0.119)
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
466 (0.122)
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
467 (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
468 (0.138)
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
469 (0.117)
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
470 (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
471 (0.120)
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
472 (0.111)
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
473 (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
474 (0.152)
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
475 (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
476 (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
477 (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
478 (0.110)
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
479 (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
480 (0.144)
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
481 (0.114)
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
482 (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
483 (0.129)
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
484 (0.113)
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
485 (0.073)
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
486 (0.126)
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
487 (0.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
488 (0.103)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
489 (0.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
490 (0.097)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
491 (0.101)
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.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
493 (0.108)
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
494 (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
495 (0.104)
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
496 (0.272)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
497 (0.124)
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
498 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
499 (0.118)
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
500 (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
501 (0.097)
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
502 (0.119)
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
503 (0.403)
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
504 (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
505 (0.307)
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
506 (0.156)
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
507 (0.179)
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
508 (0.243)
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
509 (0.982)
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
510 (0.156)
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
511 (0.146)
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
512 (0.148)
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
513 (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
514 (0.105)
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
515 (0.137)
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
516 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
517 (0.075)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
518 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
519 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/currency'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
520 (0.110)
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
521 (0.128)
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
522 (0.118)
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
523 (0.102)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/search'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
524 (0.100)
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
525 (0.122)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
526 (0.122)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
527 (0.120)
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
528 (0.104)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
529 (0.699)
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
530 (0.103)
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
531 (0.072)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
532 (0.123)
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
533 (0.072)
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
534 (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
535 (0.089)
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
536 (0.069)
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
537 (0.068)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
538 (0.089)
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
539 (0.110)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
540 (0.315)
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
541 (0.120)
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
542 (0.107)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
543 (0.111)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
544 (0.113)
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
545 (0.098)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
546 (0.094)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
547 (0.131)
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
548 (0.123)
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
549 (0.133)
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
550 (0.110)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
551 (0.102)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
552 (0.102)
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
553 (0.099)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
554 (0.661)
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
555 (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
556 (0.068)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
557 (0.095)
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
558 (0.070)
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
559 (0.057)
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
560 (0.088)
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
561 (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
562 (0.062)
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
563 (0.089)
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
564 (0.096)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
565 (0.296)
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
566 (0.117)
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
567 (0.095)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
568 (0.104)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
569 (0.098)
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
570 (0.104)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '8715e510aa73ca78bc2cafb2b2'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
571 (0.083)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/cart'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
572 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/css'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
573 (0.102)
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
574 (0.111)
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
575 (0.099)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/header'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
576 (0.156)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
577 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
578 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
579 (0.152)
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
580 (0.103)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
581 (0.071)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
582 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
583 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '523' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
584 (0.129)
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
585 (0.106)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
586 (0.068)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
587 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
588 (0.128)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '523' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
589 (0.130)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '523'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
590 (0.075)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '230'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
591 (0.128)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '230' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
592 (0.214)
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 = '523'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:474
593 (0.106)
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")
