Total memory used: 61.82 MB
1 (0.043)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.227)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (1.046)
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.057)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.132)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '1518a4aff3e3be82198a664604' AND `expire` > '2025-06-01 04:45:10'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (39.327)
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 (55.427)
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.586)
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 (52.609)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'bags' OR `keyword` LIKE '%/bags') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (66.003)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-light-tote-bag-bags' OR `keyword` LIKE '%/stanleystella-light-tote-bag-bags') 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 (1.770)
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.219)
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.157)
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.126)
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.299)
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.189)
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.144)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (46.453)
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 (42.355)
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 (60.177)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'bags' OR `keyword` LIKE '%/bags') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (73.586)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-light-tote-bag-bags' OR `keyword` LIKE '%/stanleystella-light-tote-bag-bags') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.309)
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
25 (0.121)
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
26 (0.239)
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.165)
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.131)
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
29 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
30 (0.138)
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
31 (0.132)
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
32 (0.222)
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.091)
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 (665) 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.503)
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 (665)
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 (2.636)
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 (665)
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 (14.571)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
37 (0.926)
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` = '665' 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.285)
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` = '665' 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.209)
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` = '665' 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.134)
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.136)
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.198)
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.161)
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.141)
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.173)
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.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
47 (0.179)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
48 (0.144)
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.140)
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.137)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/form'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
51 (0.118)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
52 (0.129)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
53 (0.152)
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.123)
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.104)
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.109)
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.104)
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.127)
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.108)
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.178)
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.219)
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` = '244' 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.156)
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.146)
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
64 (0.604)
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` = '665' 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.138)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
66 (0.174)
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='665')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
67 (0.123)
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
68 (0.080)
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
69 (0.147)
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
70 (0.114)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '665'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
71 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
72 (0.136)
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
73 (0.147)
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.132)
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.127)
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.170)
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` = '665' 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.165)
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` = '665' 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.153)
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.128)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '{page}' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
80 (0.114)
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.141)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
82 (0.137)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
83 (0.119)
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.127)
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.184)
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.153)
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.146)
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.206)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '665'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
89 (0.160)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '665' 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.260)
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` = '665' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
91 (0.599)
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` = '665' AND pov.`product_option_id` = '1207' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
92 (0.194)
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` = '665' AND pov.`product_option_id` = '1208' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
93 (0.191)
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` = '665' 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.125)
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
95 (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
96 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
97 (0.221)
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` = '665' 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.194)
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` = '665' 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.150)
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.124)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'StanleyStella / Light Tote Bag / Bags' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
101 (0.115)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'STAU773' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
102 (0.114)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Bags' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
103 (0.096)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '665' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
104 (0.118)
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.127)
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.310)
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 (665)
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.968)
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 (666,673,677,6505,6506,6519,11218) 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.195)
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 (666,673,677,6505,6506,6519,11218)
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.311)
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 (666,673,677,6505,6506,6519,11218)
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.140)
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
111 (0.091)
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
112 (0.150)
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
113 (0.150)
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
114 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '673'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
115 (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
116 (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
117 (0.150)
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
118 (0.465)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '677'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
119 (0.088)
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
120 (0.139)
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
121 (0.484)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '677' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
122 (0.120)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '6505'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
123 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '411'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
124 (0.076)
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
125 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244_411' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
126 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '6505' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
127 (0.324)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '6506'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
128 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '412'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
129 (0.070)
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
130 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244_412' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
131 (0.704)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '6506' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
132 (0.119)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '6519'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
133 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '412'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
134 (0.072)
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
135 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244_412' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
136 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '6519' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
137 (0.114)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11218'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
138 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '234'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
139 (0.128)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '234' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
140 (1.376)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11218' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
141 (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
142 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
143 (0.137)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
144 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
145 (0.126)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
146 (0.126)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
147 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
148 (6.389)
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 (244)
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 != '665'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
149 (0.988)
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 (13995,14662,11569,11869,11704,11615,11815,11581,14535,11568) 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
150 (0.186)
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 (13995,14662,11569,11869,11704,11615,11815,11581,14535,11568)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
151 (0.430)
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 (13995,14662,11569,11869,11704,11615,11815,11581,14535,11568)
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
152 (0.150)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '13995'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
153 (0.092)
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
154 (0.161)
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
155 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '13995' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
156 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14662'
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 = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
158 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
159 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14662' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
160 (0.117)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11569'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
161 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
162 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
163 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11569' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
164 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11869'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
165 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
166 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
167 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11869' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
168 (0.119)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11704'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
169 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
170 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
171 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11704' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
172 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11615'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
173 (0.076)
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
174 (0.124)
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
175 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11615' 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 = '11815'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
177 (0.075)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
178 (0.125)
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
179 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11815' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
180 (0.105)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11581'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
181 (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
182 (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
183 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11581' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
184 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14535'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
185 (0.076)
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
186 (0.125)
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
187 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14535' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
188 (0.110)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11568'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
189 (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
190 (0.139)
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
191 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11568' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
192 (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
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.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
195 (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
196 (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
197 (0.099)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
198 (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
199 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
200 (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
201 (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
202 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
203 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
204 (0.117)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
205 (0.106)
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
206 (0.158)
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
207 (0.130)
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
208 (0.563)
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 (665, 666, 673)
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
209 (0.765)
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 (665,666,673) 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
210 (0.184)
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 (665,666,673)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
211 (1.432)
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 (665,666,673)
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
212 (0.154)
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
213 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
214 (0.155)
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
215 (0.125)
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
216 (0.079)
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
217 (0.152)
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
218 (0.133)
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
219 (1.072)
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
220 (0.943)
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
221 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
222 (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
223 (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
224 (0.142)
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
225 (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
226 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
227 (0.173)
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
228 (0.131)
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
229 (0.656)
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
230 (1.086)
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
231 (0.595)
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
232 (0.196)
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
233 (0.304)
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
234 (0.306)
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
235 (0.325)
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
236 (0.237)
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
237 (0.161)
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
238 (0.196)
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
239 (0.307)
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
240 (0.235)
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
241 (0.213)
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
242 (0.180)
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
243 (0.550)
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
244 (0.230)
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
245 (0.345)
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
246 (0.170)
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
247 (0.325)
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
248 (0.296)
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
249 (0.283)
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
250 (0.243)
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
251 (0.195)
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
252 (0.141)
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
253 (0.674)
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
254 (0.768)
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
255 (0.931)
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
256 (0.144)
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
257 (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
258 (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
259 (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
260 (0.822)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
261 (0.197)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
262 (0.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
263 (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
264 (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
265 (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
266 (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
267 (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
268 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
269 (0.120)
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
270 (0.135)
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
271 (0.128)
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
272 (0.115)
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
273 (0.115)
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
274 (0.112)
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
275 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
276 (0.200)
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
277 (0.241)
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
278 (0.174)
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
279 (0.140)
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
280 (0.160)
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
281 (0.157)
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
282 (0.140)
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
283 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/special' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
284 (0.134)
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
285 (0.132)
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
286 (0.142)
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
287 (0.137)
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
288 (0.353)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 05:45:11'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
289 (0.176)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.223', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/bags/stanleystella-light-tote-bag-bags', `referer` = 'https://gajcom.si/product/bags/stanleystella-light-tote-bag-bags', `date_added` = '2025-06-01 06:45:11'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
290 (0.216)
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
291 (0.134)
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
292 (0.155)
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
293 (0.153)
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
294 (0.142)
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
295 (0.150)
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
296 (0.118)
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
297 (0.180)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
298 (0.111)
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.26 MB
1 (0.043)
SET time_zone = '+00:00'
/home/gajcom/htdocs/gajcom.si/system/framework.php:130
2 (0.227)
SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/store.php:11
3 (1.046)
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.057)
SET time_zone = '+02:00'
/home/gajcom/htdocs/gajcom.si/catalog/controller/startup/setting.php:45
5 (0.132)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '1518a4aff3e3be82198a664604' AND `expire` > '2025-06-01 04:45:10'
/home/gajcom/htdocs/gajcom.si/system/library/session/db.php:18
6 (39.327)
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 (55.427)
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.586)
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 (52.609)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'bags' OR `keyword` LIKE '%/bags') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
10 (66.003)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-light-tote-bag-bags' OR `keyword` LIKE '%/stanleystella-light-tote-bag-bags') 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 (1.770)
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.219)
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.157)
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.126)
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.299)
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.189)
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.144)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
20 (46.453)
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 (42.355)
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 (60.177)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'bags' OR `keyword` LIKE '%/bags') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
23 (73.586)
SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'stanleystella-light-tote-bag-bags' OR `keyword` LIKE '%/stanleystella-light-tote-bag-bags') AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:5
24 (0.309)
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
25 (0.121)
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
26 (0.239)
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.165)
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.131)
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
29 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
30 (0.138)
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
31 (0.132)
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
32 (0.222)
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.091)
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 (665) 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.503)
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 (665)
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 (2.636)
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 (665)
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 (14.571)
SELECT *
FROM `oc_journal3_module`
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/module.php:9
37 (0.926)
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` = '665' 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.285)
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` = '665' 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.209)
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` = '665' 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.134)
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.136)
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.198)
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.161)
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.141)
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.173)
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.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
47 (0.179)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
48 (0.144)
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.140)
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.137)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/form'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
51 (0.118)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
52 (0.129)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/product_tabs'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
53 (0.152)
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.123)
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.104)
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.109)
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.104)
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.127)
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.108)
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.178)
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.219)
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` = '244' 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.156)
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.146)
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
64 (0.604)
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` = '665' 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.138)
SELECT *
FROM `print_calculator`
WHERE active='1'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/calculator.php:7
66 (0.174)
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='665')
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:369
67 (0.123)
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
68 (0.080)
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
69 (0.147)
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
70 (0.114)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '665'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
71 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
72 (0.136)
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
73 (0.147)
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.132)
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.127)
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.170)
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` = '665' 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.165)
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` = '665' 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.153)
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.128)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '{page}' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
80 (0.114)
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.141)
SELECT *
FROM `oc_extension`
WHERE `type` = 'captcha' AND `code` = 'recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:17
82 (0.137)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/google_recaptcha/captcha/recaptcha'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
83 (0.119)
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.127)
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.184)
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.153)
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.146)
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.206)
SELECT *
FROM `oc_product_image`
WHERE `product_id` = '665'
ORDER BY `sort_order` ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:334
89 (0.160)
SELECT *
FROM `oc_product_discount`
WHERE `product_id` = '665' 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.260)
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` = '665' AND od.`language_id` = '1'
ORDER BY o.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:283
91 (0.599)
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` = '665' AND pov.`product_option_id` = '1207' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
92 (0.194)
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` = '665' AND pov.`product_option_id` = '1208' AND ovd.`language_id` = '1'
ORDER BY ov.`sort_order`
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:288
93 (0.191)
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` = '665' 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.125)
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
95 (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
96 (0.137)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
97 (0.221)
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` = '665' 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.194)
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` = '665' 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.150)
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.124)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'StanleyStella / Light Tote Bag / Bags' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
101 (0.115)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'STAU773' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
102 (0.114)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'tag' AND `value` = 'Bags' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
103 (0.096)
SELECT *
FROM `oc_product_to_layout`
WHERE `product_id` = '665' AND `store_id` = '0'
/home/gajcom/htdocs/gajcom.si/catalog/model/catalog/product.php:352
104 (0.118)
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.127)
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.310)
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 (665)
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.968)
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 (666,673,677,6505,6506,6519,11218) 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.195)
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 (666,673,677,6505,6506,6519,11218)
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.311)
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 (666,673,677,6505,6506,6519,11218)
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.140)
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
111 (0.091)
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
112 (0.150)
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
113 (0.150)
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
114 (0.118)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '673'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
115 (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
116 (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
117 (0.150)
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
118 (0.465)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '677'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
119 (0.088)
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
120 (0.139)
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
121 (0.484)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '677' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
122 (0.120)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '6505'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
123 (0.089)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '411'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
124 (0.076)
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
125 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244_411' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
126 (0.164)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '6505' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
127 (0.324)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '6506'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
128 (0.080)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '412'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
129 (0.070)
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
130 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244_412' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
131 (0.704)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '6506' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
132 (0.119)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '6519'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
133 (0.081)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '412'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
134 (0.072)
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
135 (0.131)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244_412' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
136 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '6519' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
137 (0.114)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11218'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
138 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '234'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
139 (0.128)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '234' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
140 (1.376)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11218' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
141 (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
142 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
143 (0.137)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
144 (0.148)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
145 (0.126)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
146 (0.126)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
147 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
148 (6.389)
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 (244)
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 != '665'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC
LIMIT 0, 10
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:263
149 (0.988)
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 (13995,14662,11569,11869,11704,11615,11815,11581,14535,11568) 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
150 (0.186)
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 (13995,14662,11569,11869,11704,11615,11815,11581,14535,11568)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
151 (0.430)
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 (13995,14662,11569,11869,11704,11615,11815,11581,14535,11568)
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
152 (0.150)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '13995'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
153 (0.092)
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
154 (0.161)
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
155 (0.155)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '13995' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
156 (0.126)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14662'
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 = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
158 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
159 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14662' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
160 (0.117)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11569'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
161 (0.079)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
162 (0.139)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
163 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11569' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
164 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11869'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
165 (0.074)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
166 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
167 (0.144)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11869' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
168 (0.119)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11704'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
169 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '228'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
170 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '228' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
171 (0.145)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11704' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
172 (0.113)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11615'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
173 (0.076)
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
174 (0.124)
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
175 (0.151)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11615' 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 = '11815'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
177 (0.075)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
178 (0.125)
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
179 (0.130)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11815' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
180 (0.105)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11581'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
181 (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
182 (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
183 (0.138)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11581' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
184 (0.115)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '14535'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
185 (0.076)
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
186 (0.125)
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
187 (0.134)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '14535' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
188 (0.110)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11568'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
189 (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
190 (0.139)
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
191 (0.129)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11568' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
192 (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
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.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
195 (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
196 (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
197 (0.099)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
198 (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
199 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
200 (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
201 (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
202 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
203 (0.105)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
204 (0.117)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/bottom'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
205 (0.106)
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
206 (0.158)
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
207 (0.130)
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
208 (0.563)
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 (665, 666, 673)
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
209 (0.765)
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 (665,666,673) 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
210 (0.184)
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 (665,666,673)
GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:97
211 (1.432)
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 (665,666,673)
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
212 (0.154)
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
213 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
214 (0.155)
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
215 (0.125)
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
216 (0.079)
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
217 (0.152)
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
218 (0.133)
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
219 (1.072)
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
220 (0.943)
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
221 (0.131)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
222 (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
223 (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
224 (0.142)
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
225 (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
226 (0.147)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
227 (0.173)
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
228 (0.131)
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
229 (0.656)
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
230 (1.086)
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
231 (0.595)
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
232 (0.196)
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
233 (0.304)
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
234 (0.306)
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
235 (0.325)
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
236 (0.237)
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
237 (0.161)
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
238 (0.196)
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
239 (0.307)
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
240 (0.235)
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
241 (0.213)
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
242 (0.180)
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
243 (0.550)
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
244 (0.230)
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
245 (0.345)
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
246 (0.170)
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
247 (0.325)
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
248 (0.296)
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
249 (0.283)
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
250 (0.243)
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
251 (0.195)
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
252 (0.141)
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
253 (0.674)
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
254 (0.768)
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
255 (0.931)
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
256 (0.144)
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
257 (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
258 (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
259 (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
260 (0.822)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
261 (0.197)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
262 (0.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
263 (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
264 (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
265 (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
266 (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
267 (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
268 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
269 (0.120)
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
270 (0.135)
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
271 (0.128)
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
272 (0.115)
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
273 (0.115)
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
274 (0.112)
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
275 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
276 (0.200)
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
277 (0.241)
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
278 (0.174)
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
279 (0.140)
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
280 (0.160)
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
281 (0.157)
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
282 (0.140)
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
283 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/special' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
284 (0.134)
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
285 (0.132)
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
286 (0.142)
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
287 (0.137)
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
288 (0.353)
DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-06-01 05:45:11'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:5
289 (0.176)
REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.223', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/product/bags/stanleystella-light-tote-bag-bags', `referer` = 'https://gajcom.si/product/bags/stanleystella-light-tote-bag-bags', `date_added` = '2025-06-01 06:45:11'
/home/gajcom/htdocs/gajcom.si/catalog/model/tool/online.php:7
290 (0.216)
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
291 (0.134)
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
292 (0.155)
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
293 (0.153)
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
294 (0.142)
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
295 (0.150)
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
296 (0.118)
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
297 (0.180)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
298 (0.111)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
299 (0.134)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
300 (0.113)
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
301 (0.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
302 (0.122)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
303 (0.151)
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
304 (0.261)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
305 (0.144)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
306 (0.180)
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
307 (0.235)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
308 (0.123)
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
309 (0.176)
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
310 (0.153)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
311 (0.157)
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
312 (0.273)
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.209)
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.312)
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
315 (0.230)
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
316 (0.109)
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
317 (0.192)
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
318 (0.273)
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
319 (0.168)
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
320 (0.210)
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
321 (0.127)
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
322 (0.232)
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
323 (0.260)
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
324 (0.189)
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
325 (0.133)
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
326 (0.203)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
327 (0.223)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
328 (0.178)
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
329 (0.339)
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
330 (0.174)
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
331 (0.192)
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.156)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
333 (0.154)
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
334 (0.203)
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
335 (0.150)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
336 (0.153)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
337 (0.159)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
338 (0.160)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
339 (0.151)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
340 (0.174)
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
341 (0.246)
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
342 (0.224)
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
343 (0.202)
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
344 (0.172)
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
345 (1.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
346 (0.210)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
347 (0.213)
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
348 (0.344)
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
349 (0.279)
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.198)
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.783)
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
352 (0.206)
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
353 (0.158)
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
354 (0.241)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
355 (0.286)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
356 (0.318)
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
357 (0.177)
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
358 (0.139)
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
359 (0.110)
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
360 (0.293)
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
361 (0.155)
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
362 (0.619)
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
363 (0.455)
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
364 (0.204)
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
365 (0.204)
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
366 (0.630)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
367 (0.143)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
368 (0.168)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
369 (0.233)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
370 (0.565)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
371 (0.977)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
372 (0.147)
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
373 (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
374 (0.442)
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
375 (0.426)
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
376 (0.534)
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
377 (0.497)
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
378 (0.184)
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
379 (0.183)
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
380 (0.217)
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
381 (0.103)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
382 (0.149)
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.204)
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
384 (0.156)
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
385 (0.124)
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
386 (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
387 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
388 (0.151)
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
389 (0.158)
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
390 (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
391 (0.078)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
392 (0.141)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
393 (0.136)
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
394 (0.112)
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
395 (0.077)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
396 (0.143)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
397 (0.147)
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
398 (0.115)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
399 (0.254)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
400 (0.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
401 (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
402 (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
403 (0.369)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
404 (0.131)
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
405 (0.189)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
406 (0.144)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
407 (0.136)
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
408 (0.355)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
409 (0.144)
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
410 (0.175)
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
411 (0.226)
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
412 (0.226)
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
413 (0.214)
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
414 (0.271)
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
415 (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
416 (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
417 (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
418 (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
419 (0.212)
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
420 (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
421 (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
422 (0.129)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
423 (0.360)
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
424 (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
425 (0.149)
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
426 (0.144)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '665'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
427 (0.229)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
428 (0.363)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
429 (0.136)
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
430 (0.083)
SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:412
431 (0.189)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
432 (0.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
433 (0.215)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
434 (0.128)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
435 (0.765)
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
436 (0.128)
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.130)
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
438 (0.113)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
439 (0.168)
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
440 (0.133)
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
441 (0.126)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
442 (0.576)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
443 (0.145)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
444 (0.119)
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
445 (0.144)
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
446 (0.127)
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
447 (0.126)
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
448 (0.124)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
449 (0.192)
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
450 (0.135)
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
451 (0.126)
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
452 (0.123)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
453 (0.186)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
454 (0.169)
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
455 (0.102)
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
456 (0.206)
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
457 (0.122)
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
458 (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
459 (0.149)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
460 (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
461 (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
462 (0.137)
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
463 (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
464 (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
465 (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
466 (0.129)
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
467 (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
468 (0.151)
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
469 (0.123)
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
470 (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
471 (0.154)
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
472 (0.117)
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
473 (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
474 (0.138)
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
475 (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
476 (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
477 (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
478 (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
479 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
480 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
481 (0.104)
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
482 (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
483 (0.108)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
484 (0.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
485 (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
486 (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
487 (0.107)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
488 (0.101)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
489 (0.101)
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
490 (0.139)
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
491 (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
492 (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
493 (0.120)
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
494 (0.157)
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
495 (0.143)
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
496 (0.121)
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
497 (0.173)
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
498 (0.145)
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
499 (0.152)
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
500 (0.135)
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
501 (0.112)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/language'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
502 (0.116)
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
503 (0.132)
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
504 (0.134)
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
505 (0.088)
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
506 (0.145)
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
507 (0.106)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/currency'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
508 (0.115)
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
509 (0.134)
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
510 (0.110)
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
511 (0.104)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/search'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
512 (0.111)
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
513 (0.133)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
514 (0.134)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
515 (0.113)
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
516 (0.117)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
517 (0.681)
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
518 (0.116)
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
519 (0.082)
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
520 (0.118)
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
521 (0.075)
SELECT *
FROM oc_country
WHERE country_id = 190
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:90
522 (0.068)
SELECT *
FROM oc_zone
WHERE zone_id = 3963
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:94
523 (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
524 (0.076)
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
525 (0.065)
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
526 (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
527 (0.124)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
528 (0.296)
SELECT *
FROM oc_setting
WHERE `key` = 'config_currency' AND store_id = 0
ORDER BY setting_id DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:189
529 (0.136)
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
530 (0.124)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
531 (0.127)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
532 (0.110)
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
533 (0.110)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
534 (0.109)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
535 (0.153)
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
536 (0.144)
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
537 (0.128)
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
538 (0.117)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
539 (0.122)
SELECT *
FROM `oc_extension`
WHERE `type` = 'total'
/home/gajcom/htdocs/gajcom.si/catalog/model/setting/extension.php:11
540 (0.107)
SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/sub_total'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/translation.php:5
541 (0.110)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
542 (0.651)
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
543 (0.095)
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
544 (0.073)
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
545 (0.153)
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
546 (0.102)
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
547 (0.073)
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
548 (0.120)
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
549 (0.078)
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
550 (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
551 (0.099)
SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)
/home/gajcom/htdocs/gajcom.si/extension/category_product_based_fee/catalog/model/total/category_product_based_fee.php:101
552 (0.113)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
553 (0.312)
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
554 (0.144)
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
555 (0.129)
SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'
/home/gajcom/htdocs/gajcom.si/system/library/cart/customer.php:131
556 (0.152)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
557 (0.129)
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
558 (0.145)
SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '1518a4aff3e3be82198a664604'
/home/gajcom/htdocs/gajcom.si/system/library/cart/cart.php:35
559 (0.132)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/cart'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
560 (0.125)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/css'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
561 (0.130)
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
562 (0.129)
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
563 (0.117)
SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/header'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/theme.php:5
564 (0.203)
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
565 (0.110)
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
566 (0.190)
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
567 (0.184)
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
568 (0.123)
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
569 (0.092)
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
570 (0.146)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
571 (0.165)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '665' AND `store_id` = '0' AND `language_id` = '2'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
572 (0.162)
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
573 (0.112)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '665'
ORDER BY main_category DESC LIMIT 1
/home/gajcom/htdocs/gajcom.si/extension/seopro/catalog/controller/startup/seo_url.php:428
574 (0.109)
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
575 (0.135)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
576 (0.150)
SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '665' AND `store_id` = '0' AND `language_id` = '3'
/home/gajcom/htdocs/gajcom.si/catalog/model/design/seo_url.php:11
577 (0.680)
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
578 (0.097)
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
579 (0.148)
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
580 (0.233)
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 = '665'
/home/gajcom/htdocs/gajcom.si/catalog/model/journal3/product.php:474
581 (0.129)
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")
