Total memory used: 61.82 MB
1 (0.040)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.215)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (1.653)
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.062)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.134)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = 'ae46b27681e241c95053302ac9' AND `expire` > '2025-06-01 04:33:29'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (53.287)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '' OR `keyword` LIKE '%/') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
7 (69.356)
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 (64.689)
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 (66.247)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'pullovers-and-sweaters' OR `keyword` LIKE '%/pullovers-and-sweaters') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (65.399)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-matcher-crew-neck-sweatshirts' OR `keyword` LIKE '%/stanleystella-matcher-crew-neck-sweatshirts') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
11 (0.245)
SELECT *
FROM `oc_currency`
/home/gajcom/htdocs/gajcom.si/system/library/cart/currency.php:10
12 (0.375)
SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'shipping' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC
/home/gajcom/htdocs/gajcom.si/system/library/cart/tax.php:12
13 (0.199)
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.152)
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.153)
SELECT *
FROM `oc_length_class` mc
LEFT JOIN `oc_length_class_description` mcd ON (mc.`length_class_id` = mcd.`length_class_id`)
WHERE mcd.`language_id` = '1'
/home/gajcom/htdocs/gajcom.si/system/library/cart/length.php:10
16 (0.317)
DELETE
FROM `oc_cart`
WHERE (`api_id` > '0' OR `customer_id` = '0') AND `date_added` < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:15
17 (0.204)
SELECT DISTINCT `extension`
FROM `oc_extension`
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:5
18 (0.122)
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.184)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (53.665)
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 (45.756)
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 (53.255)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'pullovers-and-sweaters' OR `keyword` LIKE '%/pullovers-and-sweaters') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (51.944)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-matcher-crew-neck-sweatshirts' OR `keyword` LIKE '%/stanleystella-matcher-crew-neck-sweatshirts') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.327)
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
25 (0.118)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
26 (0.212)
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.155)
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.107)
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
29 (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
30 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
31 (0.158)
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
32 (0.256)
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.124)
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 (450) 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.177)
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 (450)
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.262)
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 (450)
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 (24.410)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
37 (0.684)
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` = '450' 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` = '450' 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.208)
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` = '450' 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.141)
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.135)
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.178)
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.148)
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.112)
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.133)
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.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
47 (0.129)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
48 (0.112)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
49 (0.112)
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.103)
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.109)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
52 (0.153)
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.120)
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.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
55 (0.120)
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.122)
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.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
58 (0.131)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
59 (0.130)
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.179)
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.228)
SELECT DISTINCT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`category_id` = '227' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/category.php:7
62 (0.184)
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.171)
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
64 (0.663)
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` = '450' 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.150)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
66 (0.186)
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='450')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
67 (0.131)
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
68 (0.110)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
69 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
70 (0.115)
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
71 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
72 (0.170)
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
73 (0.152)
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.142)
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.113)
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.173)
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` = '450' 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.167)
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` = '450' 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.160)
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.140)
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.130)
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.154)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
82 (0.154)
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.132)
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.112)
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.160)
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.135)
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.152)
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.183)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '450'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
89 (0.174)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '450' 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.291)
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` = '450' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
91 (0.701)
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` = '450' AND pov.`product_option_id` = '803' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
92 (0.404)
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` = '450' AND pov.`product_option_id` = '804' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
93 (0.233)
SELECT *
FROM `oc_product_subscription` ps
LEFT JOIN `oc_subscription_plan` sp ON (ps.`subscription_plan_id` = sp.`subscription_plan_id`)
LEFT JOIN `oc_subscription_plan_description` spd ON (sp.`subscription_plan_id` = spd.`subscription_plan_id`)
WHERE ps.`product_id` = '450' 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.143)
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
95 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
96 (0.147)
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
97 (0.248)
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` = '450' 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.216)
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` = '450' 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.183)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/search' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
100 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'StanleyStella / Matcher / Crew neck sweatshirts' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
101 (0.136)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'STSU799' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
102 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Pullovers and sweaters' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
103 (0.114)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '450' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
104 (0.159)
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.128)
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.295)
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 (450)
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 (0.920)
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 (461,503,536,592,11203,11212) 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.201)
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 (461,503,536,592,11203,11212)
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.439)
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 (461,503,536,592,11203,11212)
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.135)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '461'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
111 (0.093)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
112 (0.151)
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
113 (0.185)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '461' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
114 (0.127)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '503'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
115 (0.084)
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
116 (0.170)
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
117 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '503' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
118 (0.142)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '536'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
119 (0.086)
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
120 (0.175)
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
121 (0.183)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '536' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
122 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '592'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
123 (0.097)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
124 (0.157)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
125 (0.167)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '592' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
126 (0.121)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11203'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
127 (0.094)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
128 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
129 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11203' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
130 (0.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11212'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
131 (0.093)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
132 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
133 (0.157)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11212' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
134 (0.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
135 (0.135)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
136 (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
137 (0.124)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
138 (0.127)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
139 (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
140 (7.590)
SELECT *
FROM `oc_product` p
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.category_id IN (227)
AND p.status = '1'
AND p.date_available <= NOW()
AND pd.language_id = '1'
AND p2s.store_id = '0'
AND c.status = '1'
AND c2s.store_id = '0'
AND p.product_id != '450'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
141 (0.993)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
142 (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 (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
143 (0.615)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
144 (0.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5806'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
145 (0.091)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
146 (0.151)
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
147 (0.170)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5806' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
148 (0.134)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5914'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
149 (0.088)
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
150 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
151 (0.153)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5914' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
152 (0.117)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5807'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
153 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
154 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
155 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5807' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
156 (0.121)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11641'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
157 (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
158 (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
159 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11641' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
160 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11998'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
161 (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
162 (0.123)
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
163 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11998' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
164 (0.117)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14412'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
165 (0.076)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
166 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
167 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14412' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
168 (0.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14553'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
169 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
170 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
171 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14553' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
172 (0.111)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14548'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
173 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
174 (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
175 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14548' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
176 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14413'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
177 (0.092)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
178 (0.154)
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
179 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14413' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
180 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14465'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
181 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
182 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
183 (0.125)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14465' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
184 (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
185 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
186 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
187 (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
188 (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
189 (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
190 (0.118)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
191 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
192 (0.139)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
193 (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
194 (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
195 (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
196 (0.128)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
197 (0.121)
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
198 (0.127)
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
199 (0.134)
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
200 (0.195)
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 (450, 8844)
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
201 (0.794)
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 (450,8844) 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
202 (0.175)
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 (450,8844)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
203 (0.282)
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 (450,8844)
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
204 (0.129)
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
205 (0.095)
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
206 (0.159)
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
207 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '8844'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
208 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '311'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
209 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '298'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
210 (0.084)
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
211 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_298_311' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
212 (0.162)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '8844' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
213 (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
214 (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
215 (0.127)
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
216 (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
217 (0.135)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
218 (0.146)
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
219 (0.115)
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
220 (0.096)
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
221 (0.132)
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
222 (0.137)
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
223 (0.112)
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
224 (0.074)
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
225 (0.065)
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
226 (0.074)
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
227 (0.123)
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
228 (0.136)
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
229 (0.118)
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
230 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
231 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
232 (0.140)
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
233 (0.115)
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
234 (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
235 (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
236 (0.135)
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
237 (0.114)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '444'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
238 (0.078)
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
239 (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
240 (0.075)
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
241 (0.137)
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
242 (0.138)
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
243 (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
244 (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
245 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
246 (0.150)
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
247 (0.118)
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
248 (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
249 (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
250 (0.134)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
251 (0.130)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
252 (0.140)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
253 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
254 (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
255 (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
256 (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
257 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
258 (0.106)
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
259 (0.121)
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
260 (0.122)
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
261 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/catalog'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
262 (0.128)
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
263 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
264 (0.126)
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
265 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
266 (0.156)
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
267 (0.182)
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
268 (0.148)
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
269 (0.154)
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
270 (0.148)
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
271 (0.154)
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
272 (0.144)
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
273 (0.138)
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
274 (0.137)
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
275 (0.134)
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
276 (0.134)
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
277 (0.143)
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
278 (0.348)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 05:33:30'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
279 (0.207)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.193', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/pullovers-and-sweaters/stanleystella-matcher-crew-neck-sweatshirts', `referer` = 'https://gajcom.si/product/pullovers-and-sweaters/stanleystella-matcher-crew-neck-sweatshirts', `date_added` = '2025-06-01 06:33:30'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
280 (0.202)
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
281 (0.126)
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
282 (0.182)
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
283 (0.181)
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
284 (0.163)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/cookie|confirm' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
285 (0.147)
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
286 (0.157)
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
287 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
288 (0.138)
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.03 MB
1 (0.040)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.215)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (1.653)
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.062)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.134)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = 'ae46b27681e241c95053302ac9' AND `expire` > '2025-06-01 04:33:29'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (53.287)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '' OR `keyword` LIKE '%/') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
7 (69.356)
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 (64.689)
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 (66.247)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'pullovers-and-sweaters' OR `keyword` LIKE '%/pullovers-and-sweaters') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (65.399)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-matcher-crew-neck-sweatshirts' OR `keyword` LIKE '%/stanleystella-matcher-crew-neck-sweatshirts') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
11 (0.245)
SELECT *
FROM `oc_currency`
/home/gajcom/htdocs/gajcom.si/system/library/cart/currency.php:10
12 (0.375)
SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'shipping' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC
/home/gajcom/htdocs/gajcom.si/system/library/cart/tax.php:12
13 (0.199)
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.152)
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.153)
SELECT *
FROM `oc_length_class` mc
LEFT JOIN `oc_length_class_description` mcd ON (mc.`length_class_id` = mcd.`length_class_id`)
WHERE mcd.`language_id` = '1'
/home/gajcom/htdocs/gajcom.si/system/library/cart/length.php:10
16 (0.317)
DELETE
FROM `oc_cart`
WHERE (`api_id` > '0' OR `customer_id` = '0') AND `date_added` < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:15
17 (0.204)
SELECT DISTINCT `extension`
FROM `oc_extension`
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:5
18 (0.122)
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.184)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (53.665)
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 (45.756)
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 (53.255)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'pullovers-and-sweaters' OR `keyword` LIKE '%/pullovers-and-sweaters') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (51.944)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-matcher-crew-neck-sweatshirts' OR `keyword` LIKE '%/stanleystella-matcher-crew-neck-sweatshirts') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.327)
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
25 (0.118)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
26 (0.212)
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.155)
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.107)
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
29 (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
30 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
31 (0.158)
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
32 (0.256)
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.124)
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 (450) 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.177)
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 (450)
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.262)
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 (450)
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 (24.410)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
37 (0.684)
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` = '450' 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` = '450' 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.208)
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` = '450' 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.141)
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.135)
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.178)
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.148)
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.112)
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.133)
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.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
47 (0.129)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
48 (0.112)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
49 (0.112)
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.103)
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.109)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
52 (0.153)
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.120)
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.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
55 (0.120)
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.122)
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.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
58 (0.131)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
59 (0.130)
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.179)
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.228)
SELECT DISTINCT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`category_id` = '227' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/category.php:7
62 (0.184)
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.171)
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
64 (0.663)
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` = '450' 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.150)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
66 (0.186)
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='450')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
67 (0.131)
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
68 (0.110)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
69 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
70 (0.115)
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
71 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
72 (0.170)
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
73 (0.152)
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.142)
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.113)
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.173)
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` = '450' 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.167)
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` = '450' 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.160)
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.140)
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.130)
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.154)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
82 (0.154)
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.132)
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.112)
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.160)
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.135)
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.152)
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.183)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '450'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
89 (0.174)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '450' 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.291)
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` = '450' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
91 (0.701)
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` = '450' AND pov.`product_option_id` = '803' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
92 (0.404)
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` = '450' AND pov.`product_option_id` = '804' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
93 (0.233)
SELECT *
FROM `oc_product_subscription` ps
LEFT JOIN `oc_subscription_plan` sp ON (ps.`subscription_plan_id` = sp.`subscription_plan_id`)
LEFT JOIN `oc_subscription_plan_description` spd ON (sp.`subscription_plan_id` = spd.`subscription_plan_id`)
WHERE ps.`product_id` = '450' 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.143)
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
95 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
96 (0.147)
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
97 (0.248)
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` = '450' 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.216)
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` = '450' 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.183)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/search' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
100 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'StanleyStella / Matcher / Crew neck sweatshirts' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
101 (0.136)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'STSU799' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
102 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Pullovers and sweaters' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
103 (0.114)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '450' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
104 (0.159)
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.128)
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.295)
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 (450)
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 (0.920)
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 (461,503,536,592,11203,11212) 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.201)
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 (461,503,536,592,11203,11212)
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.439)
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 (461,503,536,592,11203,11212)
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.135)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '461'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
111 (0.093)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
112 (0.151)
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
113 (0.185)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '461' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
114 (0.127)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '503'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
115 (0.084)
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
116 (0.170)
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
117 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '503' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
118 (0.142)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '536'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
119 (0.086)
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
120 (0.175)
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
121 (0.183)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '536' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
122 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '592'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
123 (0.097)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
124 (0.157)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
125 (0.167)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '592' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
126 (0.121)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11203'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
127 (0.094)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
128 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
129 (0.161)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11203' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
130 (0.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11212'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
131 (0.093)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
132 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
133 (0.157)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11212' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
134 (0.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
135 (0.135)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
136 (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
137 (0.124)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
138 (0.127)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
139 (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
140 (7.590)
SELECT *
FROM `oc_product` p
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE
c.category_id IN (227)
AND p.status = '1'
AND p.date_available <= NOW()
AND pd.language_id = '1'
AND p2s.store_id = '0'
AND c.status = '1'
AND c2s.store_id = '0'
AND p.product_id != '450'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
141 (0.993)
SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:27
142 (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 (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
143 (0.615)
SELECT
pi.product_id,
pi.image
FROM oc_product_image pi
INNER JOIN (
SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (5806,5914,5807,11641,11998,14412,14553,14548,14413,14465)
GROUP BY product_id
) pi2
WHERE
pi.product_id = pi2.product_id
AND pi.sort_order = pi2.sort_order
GROUP BY product_id
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:117
144 (0.139)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5806'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
145 (0.091)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
146 (0.151)
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
147 (0.170)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5806' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
148 (0.134)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5914'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
149 (0.088)
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
150 (0.142)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
151 (0.153)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5914' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
152 (0.117)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5807'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
153 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
154 (0.158)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
155 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5807' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
156 (0.121)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11641'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
157 (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
158 (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
159 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11641' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
160 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11998'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
161 (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
162 (0.123)
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
163 (0.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11998' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
164 (0.117)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14412'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
165 (0.076)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
166 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
167 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14412' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
168 (0.116)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14553'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
169 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
170 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
171 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14553' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
172 (0.111)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14548'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
173 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
174 (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
175 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14548' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
176 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14413'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
177 (0.092)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
178 (0.154)
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
179 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14413' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
180 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14465'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
181 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
182 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
183 (0.125)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14465' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
184 (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
185 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
186 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
187 (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
188 (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
189 (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
190 (0.118)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
191 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
192 (0.139)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
193 (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
194 (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
195 (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
196 (0.128)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
197 (0.121)
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
198 (0.127)
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
199 (0.134)
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
200 (0.195)
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 (450, 8844)
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
201 (0.794)
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 (450,8844) 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
202 (0.175)
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 (450,8844)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
203 (0.282)
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 (450,8844)
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
204 (0.129)
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
205 (0.095)
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
206 (0.159)
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
207 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '8844'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
208 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '311'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
209 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '298'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
210 (0.084)
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
211 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_298_311' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
212 (0.162)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '8844' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
213 (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
214 (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
215 (0.127)
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
216 (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
217 (0.135)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
218 (0.146)
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
219 (0.115)
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
220 (0.096)
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
221 (0.132)
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
222 (0.137)
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
223 (0.112)
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
224 (0.074)
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
225 (0.065)
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
226 (0.074)
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
227 (0.123)
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
228 (0.136)
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
229 (0.118)
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
230 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
231 (0.159)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
232 (0.140)
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
233 (0.115)
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
234 (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
235 (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
236 (0.135)
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
237 (0.114)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '444'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
238 (0.078)
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
239 (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
240 (0.075)
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
241 (0.137)
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
242 (0.138)
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
243 (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
244 (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
245 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
246 (0.150)
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
247 (0.118)
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
248 (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
249 (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
250 (0.134)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
251 (0.130)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
252 (0.140)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
253 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
254 (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
255 (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
256 (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
257 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
258 (0.106)
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
259 (0.121)
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
260 (0.122)
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
261 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/catalog'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
262 (0.128)
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
263 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
264 (0.126)
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
265 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
266 (0.156)
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
267 (0.182)
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
268 (0.148)
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
269 (0.154)
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
270 (0.148)
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
271 (0.154)
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
272 (0.144)
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
273 (0.138)
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
274 (0.137)
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
275 (0.134)
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
276 (0.134)
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
277 (0.143)
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
278 (0.348)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 05:33:30'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
279 (0.207)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.193', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/pullovers-and-sweaters/stanleystella-matcher-crew-neck-sweatshirts', `referer` = 'https://gajcom.si/product/pullovers-and-sweaters/stanleystella-matcher-crew-neck-sweatshirts', `date_added` = '2025-06-01 06:33:30'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
280 (0.202)
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
281 (0.126)
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
282 (0.182)
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
283 (0.181)
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
284 (0.163)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/cookie|confirm' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
285 (0.147)
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
286 (0.157)
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
287 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
288 (0.138)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
289 (0.130)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
290 (0.105)
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
291 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
292 (0.120)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
293 (0.105)
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
294 (0.100)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
295 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
296 (0.106)
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
297 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
298 (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
299 (0.133)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
300 (0.141)
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
301 (0.128)
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
302 (0.087)
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
303 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
304 (0.156)
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
305 (0.143)
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
306 (0.115)
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
307 (0.096)
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
308 (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
309 (0.137)
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
310 (0.135)
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
311 (0.137)
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
312 (0.088)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
313 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
314 (0.138)
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
315 (0.116)
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
316 (0.095)
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
317 (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
318 (0.138)
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
319 (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
320 (0.129)
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
321 (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
322 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
323 (0.132)
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
324 (0.127)
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
325 (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
326 (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
327 (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
328 (0.134)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
329 (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
330 (0.133)
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
331 (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
332 (0.163)
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.144)
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
334 (0.118)
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
335 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
336 (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
337 (0.141)
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
338 (0.115)
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
339 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
340 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
341 (0.142)
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
342 (0.136)
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
343 (0.114)
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
344 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
345 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
346 (0.142)
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
347 (0.151)
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
348 (0.112)
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
349 (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
350 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
351 (0.115)
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
352 (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
353 (0.130)
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
354 (0.139)
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
355 (0.138)
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
356 (0.118)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
357 (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
358 (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
359 (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
360 (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
361 (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
362 (0.113)
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
363 (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
364 (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
365 (0.152)
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
366 (0.144)
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
367 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
368 (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
369 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4414' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
370 (0.117)
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
371 (0.105)
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.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
373 (0.140)
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
374 (0.186)
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
375 (0.139)
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
376 (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
377 (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
378 (0.182)
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
379 (0.145)
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
380 (0.126)
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
381 (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
382 (0.122)
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
383 (0.143)
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
384 (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
385 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
386 (0.127)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
387 (0.151)
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
388 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
389 (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
390 (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
391 (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
392 (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
393 (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
394 (0.103)
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
395 (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
396 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
397 (0.103)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
398 (0.103)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
399 (0.115)
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
400 (0.141)
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
401 (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
402 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
403 (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
404 (0.131)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
405 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
406 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
407 (0.162)
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
408 (0.086)
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
409 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
410 (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
411 (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
412 (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
413 (0.115)
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
414 (0.084)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
415 (0.133)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
416 (0.144)
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
417 (0.129)
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
418 (0.084)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
419 (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
420 (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
421 (0.114)
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
422 (0.074)
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
423 (0.122)
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
424 (0.136)
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
425 (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
426 (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
427 (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
428 (0.105)
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
429 (0.135)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
430 (0.142)
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
431 (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
432 (0.124)
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
433 (0.114)
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
434 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
435 (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
436 (0.110)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
437 (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
438 (0.113)
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
439 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
440 (0.107)
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
441 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
442 (0.132)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
443 (0.109)
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
444 (0.106)
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
445 (0.119)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
446 (0.112)
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
447 (0.123)
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
448 (0.090)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
449 (0.146)
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
450 (0.147)
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
451 (0.084)
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
452 (0.128)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
453 (0.121)
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
454 (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
455 (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
456 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
457 (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
458 (0.120)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
459 (0.123)
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
460 (0.086)
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
461 (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
462 (0.129)
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
463 (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
464 (0.132)
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
465 (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
466 (0.074)
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
467 (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
468 (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
469 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
470 (0.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
471 (0.103)
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
472 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
473 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
474 (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
475 (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
476 (0.110)
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
477 (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
478 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
479 (0.099)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
480 (0.102)
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
481 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
482 (0.105)
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
483 (0.129)
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
484 (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
485 (0.146)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
486 (0.145)
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
487 (0.162)
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
488 (0.139)
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
489 (0.132)
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
490 (0.147)
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
491 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'sl-SI' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
492 (0.155)
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
493 (0.130)
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
494 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/language'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
495 (0.129)
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
496 (0.147)
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
497 (0.123)
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
498 (0.087)
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
499 (0.136)
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
500 (0.114)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/currency'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
501 (0.120)
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
502 (0.130)
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
503 (0.124)
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
504 (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
505 (0.141)
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
506 (0.125)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
507 (0.127)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
508 (0.134)
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
509 (0.131)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
510 (0.684)
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
511 (0.112)
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
512 (0.077)
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
513 (0.130)
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
514 (0.084)
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
515 (0.076)
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
516 (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
517 (0.077)
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
518 (0.063)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
519 (0.091)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
520 (0.103)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
521 (0.264)
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
522 (0.128)
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
523 (0.112)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
524 (0.123)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
525 (0.120)
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
526 (0.113)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
527 (0.108)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
528 (0.135)
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
529 (0.131)
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
530 (0.126)
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
531 (0.113)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
532 (0.118)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
533 (0.111)
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
534 (0.107)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
535 (0.625)
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
536 (0.108)
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.075)
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.104)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
539 (0.080)
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
540 (0.063)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
541 (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
542 (0.073)
SELECT *
FROM oc_country
WHERE country_id = 190
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:90
543 (0.064)
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
544 (0.110)
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
545 (0.106)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
546 (0.229)
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
547 (0.121)
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
548 (0.103)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
549 (0.115)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
550 (0.109)
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
551 (0.114)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = 'ae46b27681e241c95053302ac9'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
552 (0.098)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/cart'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
553 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/css'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
554 (0.113)
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
555 (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
556 (0.102)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/header'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
557 (0.149)
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
558 (0.092)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
559 (0.146)
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
560 (0.154)
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
561 (0.121)
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
562 (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
563 (0.120)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
564 (0.157)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '450' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
565 (0.133)
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
566 (0.096)
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
567 (0.082)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
568 (0.121)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
569 (0.123)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '450' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
570 (0.122)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
571 (0.098)
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
572 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
573 (0.264)
SELECT
SUM(op.quantity) AS quantity
FROM `oc_order_product` op
LEFT JOIN `oc_order` o ON op.order_id = o.order_id
WHERE o.order_status_id <> 0 AND op.product_id = '450'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:474
574 (0.127)
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")
